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

/*
 * Get last two awards from database
 */
$AwardDbh = new DatabaseHandler();
$AwardDbh->setTableName('page_awards_items');
$AwardDbh->setData(array('id'=>'','title'=>'','description'=>'','timest'=>'','link'=>''));
$AwardDbh->setActiveOnly(TRUE,2);
X2 ? $AwardDbh->addRule('x2',1) : $AwardDbh->addRule('x2',1, 'AND NOT') ;
$awardData = $AwardDbh->select();

//correct if one
$firstKey = key($awardData);
if(!is_array($awardData[$firstKey])) $awardData = array($awardData);
$output = '';
foreach($awardData as $key => $data)
{
    /*
     * Get thumbnail
     */
    $ImageDbh = new DatabaseHandler();
    $ImageDbh->setTableName('page_awards_images');
    $ImageDbh->setData(array('filename_thumb'=>''));
    $ImageDbh->setOrder('imageOrder','DESC');
    $ImageDbh->addRule('itemId',$data['id']);
    $awardImageData = $ImageDbh->select();

    /*
     * Manipulate data
     */
    $linkTitle = $this->encodeUrl($data['title']);

    setlocale(LC_ALL, 'nl_NL');
    $date = strftime("%B %Y", $data['timest']);

    $awardImageData['filename_thumb'] = '<img src="'.IMAGE_ROOT.'uploads/'.$awardImageData['filename_thumb'].'" alt="'.$data['title'].'" />';

    $output .= '<li>';
    $output .= '<div class="image"><div class="shadow"></div>'.$awardImageData['filename_thumb'].'</div>';
    $output .= '<div class="content">';
    $output .= '<span class="title">' . $data['title'] . '</span><span class="date">'.$date.'</span>';
    $output .= $data['description'];
    $output .= '<a class="awardLink ctaButton" href="' . $data['link'] . '" target="_blank" title="'.$data['title'].'"><span class="text">Award website</span><span class="left"><span class="up"></span><span class="hover"></span></span><span class="right"><span class="up"></span><span class="hover"></span></span></a>';
    $output .= '</div>';
    $output .= '</li>';
}

/*
 * Set  Data
 */
$this->setData('page_title', 'Awards | Media | '.SITE_NAME);
$this->setData('award_list', $output);

/*
 * Set Breadcrump
 */
$bc = new Breadcrump();
$bc->add('home',SITE_ROOT);
$bc->add('media',SITE_ROOT.'media/news/' . LATEST_NEWSITEM );
$bc->add('awards',SITE_ROOT.'media/awards/');
$output = $bc->get();
$this->setData('breadcrump', $output);

/*
 * Set Content View Path
 */
$this->setData('content_view_path', 'mvc/views/v_awards.php');