File: D:/HostingSpaces/SBogers10/keystud.komma-mediadesign.nl/wwwroot/app/controllers/c_home.class.php
<?php
class Ks_Home extends Controller
{
public function __construct()
{
parent::__construct();
}
public function index()
{
$page = 'home';
// Get last two news items
$Db = new DatabaseHandler();
$Db->setTableName(TABLE_PREFIX . 'homepage_items');
$homeData = $Db->select();
if(URL_LANG == 'nl'){
$title = $homeData['title'];
$desc = $homeData['description'];
}
else{
$title = $homeData['title_en'];
$desc = $homeData['description_en'];
}
if(empty($title)) $title = $homeData['title'];
if(empty($desc)) $desc = $homeData['description'];
$this->View->setData('title',$title);
$this->View->setData('description',$desc);
$Db->setTableName(TABLE_PREFIX . 'homepage_images');
$Db->setData(array('filename'=>''));
$homeImages = $Db->select();
$homeImages = $Db->twoDimensional($homeImages);
// Shuffle images
shuffle($homeImages);
// Check if we need to get news items or images ?
$newsOutput = '';
// Get last two news items
$Db = new DatabaseHandler();
$Db->setTableName(TABLE_PREFIX . 'news_items');
$Db->setScope(0,2);
$Db->addRule('active',1);
$Db->setActiveOnly(TRUE,5);
$Db->setOrder('date','DESC');
if($items = $Db->select())
{
$items = $Db->twoDimensional($items);
$Functions = new Functions();
foreach($items as $key => $item)
{
$ImageDb = new DatabaseHandler();
$ImageDb->setData(array('filename'=>''));
$ImageDb->setTableName(TABLE_PREFIX . 'news_images');
$ImageDb->addRule('itemId',$item['id']);
$ImageDb->addRule('session_key',$item['thumb']);
$image = $ImageDb->select();
$date = date('d / m / Y',$item['date']);
$key % 2 == 0 ? $alt = '' : $alt = ' alt';
$linkTitle = $Functions->encodeUrl($item['title']);
$newsOutput .= '<div class="image_holder' . $alt . '">
<div class="hover">
<div class="text respH">
<div class="icon sprite"></div>
<span class="title"><a href="' . LANG_ROOT . $this->urls['news'] . '/' . $linkTitle . '">' . $item['title'] . '</a></span>
<span class="posted">' . $this->lang['posted'] . '</span>
<span class="date">- ' . $date . ' -</span>
</div>
<div class="bg"></div>
</div>
<img src="' . UPLOADS_ROOT . $image['filename'] . '" alt="horse" class="resp" />
</div>';
}
}
if(empty($newsOutput))
{
// add two photos
if(isset($homeImages[0]['filename']))
$newsOutput .= '<div class="image_holder">
<img src="' . UPLOADS_ROOT . $homeImages[0]['filename'] . '" alt="horse" class="resp" />
</div>';
if(isset($homeImages[1]['filename']))
$newsOutput .= '<div class="image_holder">
<img src="' . UPLOADS_ROOT . $homeImages[1]['filename'] . '" alt="horse" class="resp" />
</div>';
}
else if(count($items) == 1)
{
// add one photo
if(isset($homeImages[0]['filename']))
$newsOutput .= '<div class="image_holder">
<img src="' . UPLOADS_ROOT . $homeImages[0]['filename'] . '" alt="horse" class="resp" />
</div>';
}
// Links to horses
$Db = new DatabaseHandler();
$Db->setData(array('birthYear'=>''));
$Db->addRule('active',1);
$Db->setOrder('birthYear','DESC');
$Db->setScope(0,1);
$Db->setActiveOnly(TRUE,2);
$Db->setTableName(TABLE_PREFIX . 'mares_items');
$mares = $Db->select();
$Db->setActiveOnly(TRUE,1);
$Db->setTableName(TABLE_PREFIX . 'foals_items');
$foals = $Db->select();
$Db->setActiveOnly(TRUE,3);
$Db->setTableName(TABLE_PREFIX . 'youngsters_items');
$youngsters = $Db->select();
$this->View->setData('link_mares', LANG_ROOT . $this->urls['mares'] . '/');
$this->View->setData('link_foals', LANG_ROOT . $this->urls['foals'] . '/' . $foals['birthYear']);
$this->View->setData('link_youngsters', LANG_ROOT . $this->urls['youngsters'] . '/' . $youngsters['birthYear']);
$this->View->setData('newsOutput',$newsOutput);
$this->View->setData('page_title', SITE_NAME);
$this->View->setData('page_id','home');
$this->View->setData('page_name',$page);
$this->View->setData('js_output','<script type="text/javascript" src="' . SITE_ROOT . 'public/js/responsive_' . $page . '.js"></script>');
$this->View->render('v_' . $page);
}
}