<?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',10); // categoryId in database
    $this->setData('catLabel','Computer Cases');
    $this->setData('catTablename','pccases');
    $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(driveBaysExternal) AS min_35external,MAX(driveBaysExternal) AS max_35external,
                    MIN(driveBaysInternal) AS min_35internal,MAX(driveBaysInternal) AS max_35internal,
                    MIN(driveBaysEnternal) AS min_525external,MAX(driveBaysEnternal) AS max_525external,
                    MIN(topPanelConnectionsUsb2) AS min_usb2,MAX(topPanelConnectionsUsb2) AS max_usb2,
                    MIN(topPanelConnectionsUsb3) AS min_usb3,MAX(topPanelConnectionsUsb3) AS max_usb3
              FROM page_pccases_items AS p, kms_active AS a
              WHERE a.active = 1
              AND a.pageId = 10
              LIMIT 1';
    $st = $pdo->prepare($query);
    $st->execute();
    $result = $st->fetch(PDO::FETCH_ASSOC);

    $this->setData('min_35external', $result['min_35external']);
    $this->setData('max_35external', $result['max_35external']);
    $this->setData('min_35internal', $result['min_35internal']);
    $this->setData('max_35internal', $result['max_35internal']);
    $this->setData('min_525external', $result['min_525external']);
    $this->setData('max_525external', $result['max_525external']);

    $this->setData('min_usb2', $result['min_usb2']);
    $this->setData('max_usb2', $result['max_usb2']);
    $this->setData('min_usb3', $result['min_usb3']);
    $this->setData('max_usb3', $result['max_usb3']);
    /*
     * Set Page Title
     */
    $this->setData('page_title', 'Computer cases | Products | '.SITE_NAME);

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

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

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


    /*
     * Get a list containing all products for google crawling
     */
    $Dbh = new DatabaseHandler();
    $Dbh->setTableName('page_pccases_items');
    $Dbh->setData(array('title'=>'','productCode'=>''));
    $Dbh->setActiveOnly(TRUE,10);
    $Dbh->addRule('productStatus','1');
    $data = $Dbh->select();

    $list = '';
    foreach($data as $row)
    {
        $url = '/computer-cases/' . $this->encodeUrl($row['title'] . '-' . $row['productCode']) . '/';
        $list .= '<li><a href="' . $url . '">' . $row['title']. '</a></li>';
    }
    $this->setData('google_products_list',$list);
}