<?php

/*

    Get Info News

 */


/*
 * Get last newsItem from database
 */
$NewsDbh = new DatabaseHandler();
$NewsDbh->setTableName('page_nieuws_items');
$NewsDbh->setData(array('id'=>'','title'=>'','description'=>''));
$NewsDbh->setActiveOnly(TRUE,1);
$NewsDbh->setScope(0,1);
X2 ? $NewsDbh->addRule('x2',1) : $NewsDbh->addRule('x2',1, 'AND NOT') ;
$newsData = $NewsDbh->select();

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

/*
 * Manipulate data
 */
$linkTitle = $this->encodeUrl($newsData['title']);
$newsData['displayTitle'] = '<a href="'.SITE_ROOT.'media/news/'.$linkTitle.'/">'.$newsData['title'].'</a>';

$maxChar = 200;

$testDesc = strip_tags($newsData['description']);
if(strlen($testDesc) > $maxChar){
    $newDesc = '';
    $words = explode(' ',$newsData['description']);
    foreach($words as $word)
    {
        if(strlen($newDesc) < $maxChar)
        {
            $newDesc .= $word . ' ';
        }
    }
    $newDesc = substr($newDesc,0,-1);

    $newsData['description'] = $newDesc;
    $newsData['description'] .= '&hellip; <a href="' . SITE_ROOT . 'media/news/' . $linkTitle . '/" class="read_more">Read more</a>';
}

$newsImageData['filename_thumb'] = '<a href="'.SITE_ROOT.'media/news/'.$linkTitle.'/">
                                        <img src="'.IMAGE_ROOT.'uploads/'.$newsImageData['filename_thumb'].'" alt="Spire Corp | '.$newsData['title'].'" />
                                   </a>';

/*
 * Set News Data
 */
$this->setData('news_title', $newsData['displayTitle']);
$this->setData('news_desc', $newsData['description']);
$this->setData('news_thumb', $newsImageData['filename_thumb']);

/*

    Get Info Awards

*/

/*
 * Get last two awards from database
 */
$awardDbh = new DatabaseHandler();
$awardDbh->setTableName('page_awards_items');
$awardDbh->setData(array('id'=>'','title'=>'','description'=>'','link'=>''));
$awardDbh->setActiveOnly(TRUE,2);
$awardDbh->setScope(0,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);

unset($_SESSION['popup_awards']);
$_SESSION['popup_awards'] = array();
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();

    // needed for popup
    $popup = array();
    $popup['title'] = $data['title'];
    $popup['description'] = $data['description'];
    $popup['link'] = $data['link'];
    $popup['thumb'] = $awardImageData['filename_thumb'];
    $_SESSION['popup_awards'][$data['id']] = $popup;

    /*
     * Manipulate data
     */
    $linkTitle = $this->encodeUrl($data['title']);
    $data['displayTitle'] = '<a href="'.SITE_ROOT.'media/news/'.$linkTitle.'/">'.$data['title'].'</a>';

    //$awardImageData['filename_thumb'] = '<a href="'. $data['link'] .'" target="_blank"><img src="'.IMAGE_ROOT.'uploads/'.$awardImageData['filename_thumb'].'" alt="Spire Corp | '.$data['title'].'" /></a>';

    $awardImageData['filename_thumb'] = '<a href="/mvc/views/v_award_pop_up.php?id='. $data['id'].'" title="'.$data['title'].'" class="adwardPopUp"><img src="'.IMAGE_ROOT.'uploads/'.$awardImageData['filename_thumb'].'" alt="Spire Corp | '.$data['title'].'" /></a>';

    $this->setData('awards'.$key.'_title', '<a href="/mvc/views/v_award_pop_up.php?id='. $data['id'].'" title="'.$data['title'].'" class="adwardPopUp">' . $data['title'] . '</a>');


    $shortDesc = $data['description'];
    if(strlen($shortDesc) > 200) $shortDesc = substr($shortDesc,0,200) . '&hellip;';

    $this->setData('awards'.$key.'_desc', $shortDesc);
    $this->setData('awards'.$key.'_thumb', $awardImageData['filename_thumb']);
}

/*
 * Slider photo
 */

$BannerDb = new DatabaseHandler();
$BannerDb->setTableName('page_homebanners_items');
$BannerDb->setData(array('id'=>'','title'=>'','link'=>''));
$BannerDb->setActiveOnly(TRUE,14);
$BannerDb->setScope(0,3);
X2 ? $BannerDb->addRule('x2',1) : $BannerDb->addRule('x2',1, 'AND NOT') ;
$bannerData = $BannerDb->select();


//correct if one
$firstKey = key($bannerData);
if(!is_array($bannerData[$firstKey])) $bannerData = array($bannerData);

$bannerOutput = '';
$bannerNavOutput = '';
foreach($bannerData as $key => $data)
{

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

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


    //$awardImageData['filename_thumb'] = '<a href="'.SITE_ROOT.'media/awards/'.$linkTitle.'/" title="'.$data['title'].'"><img src="'.IMAGE_ROOT.'uploads/'.$awardImageData['filename_thumb'].'" alt="'.$data['title'].'" /></a>';

    $bannerOutput .= '<li>';
    if( ! empty($data['link'])) $bannerOutput .= '<a href="'.$data['link'].'">';
    $bannerOutput .= '<img src="' . IMAGE_ROOT . 'uploads/'. $bannerImageData['filename_thumb'] . '" alt="Spire Corp. | ' . $data['title'] . '" data-large="' . IMAGE_ROOT . 'uploads/'. $bannerImageData['filename_original'] . '" data-small="' . IMAGE_ROOT . 'uploads/'. $bannerImageData['filename_thumb'] . '"/>';
    if( ! empty($data['link'])) $bannerOutput .= '</a>';
    $bannerOutput .= '</li>';

    $bannerNavOutput .= '<li style="z-index: '.$key.'"><span class="title">' . $data['title'] . '</span><span class="background"></span></li>';

}

/*
 * Set  Data
 */
$this->setData('page_title', 'Awards | Media | '.SITE_NAME);
$this->setData('banner_list', $bannerOutput);
$this->setData('bannerNav_list', $bannerNavOutput);

/*
 * JS
 */
$jsOutput = '<script type="text/javascript" src="/js/KE010102_image_slider.js"></script>';


$this->setData('jsOutput',$jsOutput, TRUE);

/*
 * Set Global Data
 */
$this->setData('page_title', SITE_NAME);

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