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()
{
$columns_disabled = Environment::get_graphical_environment()->get_columns_disabled();
  $columns_disabled->set_disable_left_columns(true);
  $columns_disabled->set_disable_right_columns(true);
  $columns_disabled->set_disable_top_central(true);
  $columns_disabled->set_disable_bottom_central(true);
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();
 
return $this->template;
}
 
private function build_view()
{
 
$querier = PersistenceContext::get_querier();
$results = $querier->select('
SELECT id, title, contents, timestamp, img, user_id
FROM ' . PREFIX . 'blog
WHERE visible = 1
ORDER BY timestamp DESC 
LIMIT 3');
 
$this->build_modules_view($results);
}
 
private function build_modules_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/modules.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 3)
{
break; 
}
 
$link = new Url('/blog/blog.php?id=' . $row['id']);
$date = new Date(DATE_TIMESTAMP, TIMEZONE_AUTO, $row['timestamp']);
$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++;
}
$this->template->put('MODULES', $tpl);
}
}
?>

<?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()
    {
        $columns_disabled = Environment::get_graphical_environment()->get_columns_disabled();
          $columns_disabled->set_disable_left_columns(true);
          $columns_disabled->set_disable_right_columns(true);
          $columns_disabled->set_disable_top_central(true);
          $columns_disabled->set_disable_bottom_central(true);
        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();
 
        return $this->template;
    }
 
    private function build_view()
    {
 
        $querier = PersistenceContext::get_querier();
        $results = $querier->select('
        SELECT id, name, short_contents, creation_date, picture_url, author_user_id
            FROM ' . PREFIX . 'news
            WHERE approbation_type=1
            ORDER BY creation_date DESC 
            LIMIT 3');
 
        $this->build_modules_view($results);
    }
 
    private function build_modules_view(SelectQueryResult $results)
    {
        $tpl = new FileTemplate('HomeCustom/feed_news.tpl');
        $i = 0;
        foreach ($results as $row)
        {
            if ($i >= 3)
            {
                break; 
            }
 
            $link = new Url('/news/news' . url('.php?id=' . $row['id'], '-' . $row['id'] .  '+' . Url::encode_rewrite($row['name']) . '.php'));
            $date = new Date(DATE_TIMESTAMP, TIMEZONE_AUTO, $row['creation_date']);
            $tpl->assign_block_vars('feed_news', array(
                'U_LINK' => $link->absolute(),
                'U_IMG' => Url::to_absolute($row['picture_url']),
                'C_IMG' => !empty($row['picture_url']),
                'TITLE' => $row['name'],
                'DESCR' => $row['short_contents'],
                'AUTHOR' => $row['author_user_id']
            ));
            $i++;
        }
        $this->template->put('feed_news', $tpl);
    }
}
?>

$this->template->put('feed_news', $tpl);

 
$this->template->put('MODULES', $tpl);
 

$link = new Url('/news/news' . url('.php?id=' . $row['id'], '-' . $row['id'] .  '+' . Url::encode_rewrite($row['name']) . '.php'));