File: D:/HostingSpaces/SBogers10/spire.komma-mediadesign.nl/wwwroot/mvc/controllers/c_system_cooling.php
<?php
/**
* c_cpu_coolers.php
* Created by Komma Mediadesign.
* Author: mike
* Date: 2/18/13
*/
/*
* Create category subMenu and blocks
*/
$this->load('/mvc/controllers/c_categories.php');
if(defined('URL_SUB') && URL_SUB != '' && URL_SUB != 'search') $sub = URL_SUB;
if(isset($sub))
{
/*
Load Product Detail
*/
$this->setData('catId',7); // categoryId in database
$this->setData('catLabel','System Cooling');
$this->setData('catTablename','systemcooling');
$this->load('mvc/controllers/c_product.php');
}
else if(!defined('URL_SUB') || ( defined('URL_SUB') && URL_SUB == 'search') ) {
/*
Load Dashboard
*/
/*
* Set Filter-slider min and max settings.
* (No user-input, so we can use a regular mysql query)
*/
global $pdo;
$query = 'SELECT MIN(fanSizeL) as min_diamater,MAX(fanSizeL) AS max_diamater,MIN(ratedSpeed1) AS min_rpm,MAX(ratedSpeed2) AS max_rpm,
MIN(noiseLevel1) AS min_noiseLevel,MAX(noiseLevel2) AS max_noiseLevel,MIN(airFlow) AS min_airFlow,MAX(airFlow) AS max_airFlow
FROM page_systemcooling_items AS p, kms_active AS a
WHERE a.active = 1
AND a.pageId = 7
LIMIT 1';
$st = $pdo->prepare($query);
$st->execute();
$result = $st->fetch(PDO::FETCH_ASSOC);
$this->setData('min_diameter', $result['min_diamater']);
$this->setData('max_diameter', $result['max_diamater']);
$this->setData('min_rpm', $result['min_rpm']);
$this->setData('max_rpm', $result['max_rpm']);
$this->setData('min_noiseLevel', $result['min_noiseLevel']);
$this->setData('max_noiseLevel', $result['max_noiseLevel']);
$this->setData('min_airFlow', $result['min_airFlow']);
$this->setData('max_airFlow', $result['max_airFlow']);
/*
* Set Page Title
*/
$this->setData('page_title', 'System Cooling | Products | '.SITE_NAME);
/*
* Set Breadcrump
*/
$bc = new Breadcrump();
$bc->add('home',SITE_ROOT);
$bc->add('products',SITE_ROOT.'products/');
$bc->add('System Cooling',SITE_ROOT.'system-cooling/');
$output = $bc->get();
$this->setData('breadcrump', $output);
/*
* Set Inner Breadcrump
*/
$innerBc = new Breadcrump();
$innerBc->add('categories',SITE_ROOT.'products/');
$innerBc->add('System Cooling',SITE_ROOT.'system-cooling/');
$output = $innerBc->getH1();
$this->setData('inner_breadcrump', $output);
/*
* Set Content View Path
*/
$this->setData('content_view_path', 'mvc/views/products/v_system_cooling.php');
/*
* Set Javascript Filter.js
*/
$filterOutput = '<script type="text/javascript" src="/js/filter.js"></script>';
$filterOutput .= '<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/jquery-ui.min.js"></script>
<script>!window.jQuery.ui && document.write(unescape(\'%3Cscript src="/js/jquery-ui.custom.min.js"%3E%3C/script%3E\'))</script>';
$this->setData('jsFilterOutput',$filterOutput);
$this->setData('defaultSearch','search');
if(defined('URL_SUB') && URL_SUB == 'search')
{
if(defined('URL_SUB2'))
{
$searchWord = str_replace('-',' ',URL_SUB2);
$this->setData('defaultSearch',$searchWord);
}
}
}