HEX
Server: Microsoft-IIS/8.5
System: Windows NT YDAWBH120 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
User: tentjecom_web (0)
PHP: 7.4.14
Disabled: NONE
Upload Files
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);
    }
}