<?php
/**
 * c)power_supplies.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')
{
    /*

        Load Product Detail

    */
    $this->setData('catId',8); // categoryId in database
    $this->setData('catLabel','Power Supplies');
    $this->setData('catTablename','powersupply');
    $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(voltageAcInput1),MAX(voltageAcInput2),MIN(nominalPower),MAX(nominalPower)
              FROM page_powersupply_items AS p, kms_active AS a
              WHERE a.active = 1
              AND a.pageId = 8
              LIMIT 1';
    $st = $pdo->prepare($query);
    $st->execute();
    $result = $st->fetch(PDO::FETCH_ASSOC);

    $this->setData('min_inputVoltageAc', $result['MIN(voltageAcInput1)']);
    $this->setData('max_inputVoltageAc', $result['MAX(voltageAcInput2)']);
    $this->setData('min_nominalPower', $result['MIN(nominalPower)']);
    $this->setData('max_nominalPower', $result['MAX(nominalPower)']);



    /*
     * Set Page Title
     */
    $this->setData('page_title', 'Power Supplies | Products | '.SITE_NAME);

    /*
     * Set Breadcrump
     */
    $bc = new Breadcrump();
    $bc->add('home',SITE_ROOT);
    $bc->add('products',SITE_ROOT.'products/');
    $bc->add('power supplies',SITE_ROOT.'power-supplies/');
    $output = $bc->get();
    $this->setData('breadcrump', $output);

    /*
     * Set Inner Breadcrump
     */
    $innerBc = new Breadcrump();
    $innerBc->add('categories',SITE_ROOT.'products/');
    $innerBc->add('power supplies',SITE_ROOT.'power-supplies/');
    $output = $innerBc->getH1();
    $this->setData('inner_breadcrump', $output);

    /*
     * Set Content View Path
     */
    $this->setData('content_view_path', 'mvc/views/products/v_power_supplies.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);
        }
    }
}