<?php
/**
 * c_categories.php
 * Created by Komma Mediadesign.
 * Author: mike
 * Date: 2/18/13
 */

$thumbListOutput = '';
$thumbListDescOutput = '';
$subMenuOutput =  '';

/*
 * Get category data from database
 */
$CatDbh = new DatabaseHandler();
$CatDbh->setTableName('page_categorieen_items');
$CatDbh->setData(array('id'=>'','title'=>'','description'=>'','x2_title'=>'','x2_description'=>''));
$CatDbh->addRule('id',9,'AND NOT');
$CatDbh->setActiveOnly(TRUE,3);

if(X2)
{
    $CatDbh->addRule('x2',1);
    $CatDbh->setOrder('x2_title','ASC');
}
else
{
    $CatDbh->setOrder('title','ASC');
}

if($catData = $CatDbh->select())
{

    if ( ! is_array($catData[key($catData)])) $catData = array($catData);

    foreach($catData as $key => $data)
    {
        $linkTitle = $this->encodeUrl($data['title']);

        // Catch x2 title
        if(X2)
        {
            if( ! empty($data['x2_title'])) $data['title'] = $data['x2_title'];
            if( ! empty($data['x2_description'])) $data['description'] = $data['x2_description'];
        }

        /*
         * Get thumbnail
         */
        $ImageDbh = new DatabaseHandler();
        $ImageDbh->setTableName('page_categorieen_images');
        $ImageDbh->setData(array('filename_thumb'=>''));
        $ImageDbh->setOrder('imageOrder','DESC');
        $ImageDbh->addRule('itemId',$data['id']);
        $catDataData = $ImageDbh->select();

        /*
         * Manipulate data
         */
        $catDataData['filename_thumb'] = '<img src="'.IMAGE_ROOT.'uploads/'.$catDataData['filename_thumb'].'" alt="Spire Corp | '.$data['title'].'" />';
        if(X2)
        {
            switch($linkTitle)
            {
                case 'computer-cases':
                    $catDataData['filename_thumb'] = '<img src="/img/x2/products/cases.jpg" alt="X2 Products | '.$data['title'].'" />';
                    break;
                case 'cpu-coolers':
                    $catDataData['filename_thumb'] = '<img src="/img/x2/products/cpucoolers.jpg" alt="X2 Products | '.$data['title'].'" />';
                    break;
                case 'pc-accessories':
                    $catDataData['filename_thumb'] = '<img src="/img/x2/products/peripherals.jpg" alt="X2 Products | '.$data['title'].'" />';
                    break;
                case 'power-supplies':
                    $catDataData['filename_thumb'] = '<img src="/img/x2/products/powersupplies.jpg" alt="X2 Products | '.$data['title'].'" />';
                    break;
                case 'system-cooling':
                    $catDataData['filename_thumb'] = '<img src="/img/x2/products/systemcooling.jpg" alt="X2 Products | '.$data['title'].'" />';
                    break;
            }
        }


        /*
         * Create output data for categoryBlock without description
         */
        $thumbListOutput .= '<li';
        if($key % 4 == 0) $thumbListOutput .= ' class="first"';
        $thumbListOutput .= '>';
        $thumbListOutput .= '<a href="'.SITE_ROOT.$linkTitle.'/">';
        $thumbListOutput .= '<span class="borderTop"></span>';
        $thumbListOutput .= '<div class="image"><div class="shadow"></div><div class="labelDown"></div>'.$catDataData['filename_thumb'].'</div>';
        $thumbListOutput .= '<div class="content">';
        $thumbListOutput .= '<span>'.$data['title'].'</span>';
        $thumbListOutput .= '</div>';
        $thumbListOutput .= '</a>';
        $thumbListOutput .= '</li>';

        /*
         * Create output data for categoryBlock with description
         */
        $thumbListDescOutput .= '<li';
        if($key % 4 == 0) $thumbListDescOutput .= ' class="first"';
        $thumbListDescOutput .= '>';
        $thumbListDescOutput .= '<a href="'.SITE_ROOT.$linkTitle.'/">';
        $thumbListDescOutput .= '<span class="borderTop"></span>';
        $thumbListDescOutput .= '<div class="image"><div class="shadow"></div><div class="labelDown"></div>'.$catDataData['filename_thumb'].'</div>';
        $thumbListDescOutput .= '<div class="content">';
        $thumbListDescOutput .= '<span>'.$data['title'].'</span>';
        $thumbListDescOutput .= $data['description'];
        $thumbListDescOutput .= '</div>';
        $thumbListDescOutput .= '</a>';
        $thumbListDescOutput .= '</li>';

        /*
         * Create output data for subMenu
         */
        $classes = array();
        if(($key+1) % 4 == 0) $classes[] = 'last';
        if(defined('URL_PAGE') && URL_PAGE == $linkTitle) $classes[] = 'active';
        $subMenuOutput .= '<li';
        if(count($classes)>0)
        {
            $subMenuOutput .= ' class="';
        }
        foreach($classes as $n=> $class)
        {
            if($n != 0) $subMenuOutput .= ' ';
            $subMenuOutput .= $class;
        }

        if(count($classes)>0)
        {
            $subMenuOutput .= '"';
        }
        $subMenuOutput .= '><a href="'.SITE_ROOT.$linkTitle.'/">'.$data['title'].'</a><span class="separator"></span><span class="background"></span></li>';
    }
}
/*
 * Set Data
 */
$this->setData('cat_thumb_list',$thumbListOutput);
$this->setData('cat_thumb_desc_list',$thumbListDescOutput);
$this->setData('cat_subMenu_list',$subMenuOutput);