HEX
Server: Microsoft-IIS/8.5
System: Windows NT YDAWBH120 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
User: tentjecom_web (0)
PHP: 7.4.14
Disabled: NONE
Upload Files
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);
        }
    }
}