Forum

<?php
/*##################################################
 *                     HomeCustomHomePageExtensionPoint.class.php
 *                            -------------------
 *   begin                : August 25, 2012
 *   copyright            : (C) 2012 Kevin MASSY
 *   email                : kevin.massy@phpboost.com
 *
 *
 ###################################################
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 ###################################################*/
 
class HomeCustomHomePageExtensionPoint implements HomePageExtensionPoint
{
    private $template;
 
    public function get_home_page()
    {
        return new DefaultHomePage($this->get_title(), $this->get_view());
    }
 
    private function get_title()
    {
        return LangLoader::get_message('title', 'common', 'HomeCustom');
    }
 
    private function get_view()
    {
        $this->template = new FileTemplate('HomeCustom/home.tpl');
 
        $this->build_view_item();
 
        $this->build_view_news();
 
        return $this->template;
    }
 
    //#############################################
    //# Séléction des 3 dernières news importante #
    //#############################################
    private function build_view_item()
    {
        $id_cats_item = array('2');
 
        $querier_item = PersistenceContext::get_querier();
        $results_item = $querier_item->select('SELECT cat.id, cat.rewrited_name, news.id, news.rewrited_name, news.picture_url, news.name, news.short_contents FROM ' . PREFIX . 'news news 
            LEFT JOIN ' . PREFIX . 'news_cats cat 
            ON cat.id = news.id_category 
            WHERE news.id_category IN (' . implode(', ', $id_cats_item) . ') 
            ORDER BY news.creation_date DESC');
        $this->build_modules_view_item($results_item);
    }
 
    private function build_modules_view_item(SelectQueryResult $results_item)
    {
        $tpl_item = new FileTemplate('HomeCustom/items.tpl');
 
        foreach ($results_item as $row_item)
        {
            if ($i_item >= 3)
            {
                break; 
            }
 
            if($i_item==1){$class_item="item active";}
            else{$class_item="item";}
 
            $link_item = new Url('/news/' . $row_item['cat.id'] . '-' . $row_item['cat.rewrited_name'] . '/' . $row_item['news.id'] . '-' . $row_item['news.rewrited_name']);
 
            $tpl_item->assign_block_vars('item', array(
                'U_LINK' => $link_item->absolute(),
                'U_IMG' => Url::to_absolute($row_item['news.picture_url']),
                'TITLE' => $row_item['news.name'],
                'SHORT_CONTENT' => $row_item['news.short_contents'],
                'CLASS' => $item_class
            ));
            $i_item++;
        }
 
        $this->template->put('ITEMS', $tpl_item);
    }
 
    //##################################
    //# Selection des 4 dernières news #
    //##################################
    private function build_view_news()
    {
        $id_cats_news = array('1', '2');
 
        $querier_news = PersistenceContext::get_querier();
        $results_news = $querier_news->select('SELECT cat.id, cat.rewrited_name, news.id, news.rewrited_name, news.picture_url, news.name, news.short_contents FROM ' . PREFIX . 'news news 
            LEFT JOIN ' . PREFIX . 'news_cats cat 
            ON cat.id = news.id_category 
            WHERE news.id_category IN (' . implode(', ', $id_cats_news) . ') 
            ORDER BY news.creation_date DESC');
        $this->build_modules_view_news($results_news);
    }
 
    private function build_modules_view_news(SelectQueryResult $results_news)
    {
        $tpl_news = new FileTemplate('HomeCustom/news.tpl');
 
        foreach ($results_news as $row_news)
        {
            if ($i_news >= 4)
            {
                break; 
            }
 
            $link_news = new Url('/news/' . $row_news['cat.id'] . '-' . $row_news['cat.rewrited_name'] . '/' . $row_news['news.id'] . '-' . $row_news['news.rewrited_name']);
 
            $tpl_news->assign_block_vars('news', array(
                'U_LINK' => $link_news->absolute(),
                'U_IMG' => Url::to_absolute($row_news['news.picture_url']),
                'TITLE' => $row_news['news.name'],
                'SHORT_CONTENT' => $row_news['news.short_contents']
            ));
            $i_news++;
        }
 
        $this->template->put('NEWS', $tpl_news);
    }
 
}
?>

'TITLE' => $row_news['news.name'],

'TITLE' => 'test',

'TITLE' => 'test',

 
$results = $querier->select('SELECT file.id, file.idcat, file.title, file.short_contents, file.timestamp, file.image, 
user.login
        FROM ' . PREFIX . 'download file
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = file.user_id
        WHERE visible = 1 AND approved = 1 AND file.idcat IN (' . implode(', ', $id_cats) . ')
        ORDER BY timestamp DESC');
 

 
foreach ($results as $row)
{
if ($i >= 3)
{
break; 
}
 
$link = new Url('/download/download' . url('.php?id=' . $row['id'], '-' . $row['id'] .  '+' . Url::encode_rewrite($row['title']) . '.php'));
 
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['image']),
'C_IMG' => !empty($row['image']),
'TITLE' => $row['title'],
'DESC' => $row['short_contents'],
'PSEUDO' => $row['login']
));
$i++;
}