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

/*
 * Get all newsItems from database
 */
$NewsDbh = new DatabaseHandler();
$NewsDbh->setTableName('page_nieuws_items');
$NewsDbh->setData(array('id'=>'','title'=>'','timest'=>'','description'=>'','pdflabel'=>''));
$NewsDbh->setActiveOnly(TRUE,1);
X2 ? $NewsDbh->addRule('x2',1) : $NewsDbh->addRule('x2',1, 'AND NOT') ;
$currentId = null;

/* Get id from item in url */
if(defined('URL_SUB2') && URL_SUB2 != '')
{
    $allData = $NewsDbh->select();

    //correct if one
    $firstKey = key($allData);
    if(!is_array($allData[$firstKey])) $allData = array($allData);
    foreach($allData as $data)
    {
        $linkTitle = $this->encodeUrl($data['title']);
        if($linkTitle == URL_SUB2)
        {
            $currentId = $data['id'];
        }
    }
}
if($currentId == null)
{
    $this->notFound();
}

/*
 * Get last newsItems from database
 */
$NewsDbh->setScope(0,1);
$NewsDbh->addRule('id',$currentId);
X2 ? $NewsDbh->addRule('x2',1) : $NewsDbh->addRule('x2',1, 'AND NOT') ;
$newsData = $NewsDbh->select();

$linkTitle = $this->encodeUrl($newsData['title']);
if( !(defined('URL_SUB2') && URL_SUB2 != ''))
{
    //header ('HTTP/1.1 301 Moved Permanently');
    header ('Location: '.SITE_ROOT.URL_PAGE.'/news/'.$linkTitle.'/');
    exit();
}

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

/*
 * Get possible documents
 */
$DocDbh = new DatabaseHandler();
$DocDbh->setTableName('page_nieuws_docs');
$DocDbh->setData(array('title'=>'','filename'=>''));
$DocDbh->addRule('itemId',$newsData['id']);
if($newsDocData = $DocDbh->select())
{
    $dTitle = 'Download ' . $newsDocData['title'];
    $dUrl = IMAGE_ROOT . 'uploads/' . $newsDocData['filename'];

    if( ! empty($newsData['pdflabel'])) $dTitle = $newsData['pdflabel'];

    $download = '<p><a href="' . $dUrl . '">' . $dTitle . '</a></p>';

    $this->setData('thisItem_download',$download);
}



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

$image = '<img src="'.IMAGE_ROOT.'uploads/'.$newsImageData['filename_original'].'" alt="'.$newsData['title'].'" />';

/*
 * Set data for current item
 */
$this->setData('thisItem_image',$image);

$this->setData('thisItem_title',$newsData['title']);
$this->setData('thisItem_desc',$newsData['description']);
$this->setData('thisItem_date',$date);



/*
 * Get all newsItems from database
 */
$NewsDbh->clearRule('id');
X2 ? $NewsDbh->addRule('x2',1) : $NewsDbh->addRule('x2',1, 'AND NOT') ;
$NewsDbh->setScope(0,4);

$newsData = $NewsDbh->select();

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

/*
 *  Output all items in list
 */
$newsOutput = '';
foreach($newsData as $data)
{
    $linkTitle = $this->encodeUrl($data['title']);
    $newsOutput .= '<li';
    if(defined('URL_SUB2') && URL_SUB2 == $linkTitle) $newsOutput .= ' class="active"';
    $newsOutput .= '><span>'.$date.'</span><a href="'.SITE_ROOT.URL_PAGE.'/'.URL_SUB.'/'.$linkTitle.'/" title="'.$data['title'].'">'.$data['title'].'</a></li>';
}

/*
 * Set Data
 */
$this->setData('news_list', $newsOutput);
$this->setData('page_title', 'News | Media | '.SITE_NAME);


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