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()
    {
        $id_cats = array('2', '6');
 
        $querier = PersistenceContext::get_querier();
        $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 idcat IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
 
        $this->build_modules_view($results);
    }
 
    private function build_modules_view(SelectQueryResult $results)
    {
        $tpl = new FileTemplate('HomeCustom/categorie1.tpl');
        $i = 0;
        foreach ($results as $row)
        {
            if ($i >= 6)
            {
                break; 
            }
 
            $link = new Url('/news/news' . 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++;
        }
        $this->template->put('CATEGORIE', $tpl);
    }
}
?>

# INCLUDE  CATEGORIE #

$results = $querier->select('SELECT file.id, file.id_category, file.name, file.contents, file.short_contents, file.updated_date, file.picture_url , user.login
  FROM ' . PREFIX . 'news file
  LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = file.author_user_id 
  WHERE visible = 1 AND approved = 1 AND file.id_category IN (' . implode(', ', $id_cats) . ')
);

<?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()
{
$id_cats = array('2', '6');
 
$querier = PersistenceContext::get_querier();
$results = $querier->select('SELECT file.id, file.id_category, file.name, file.contents, file.short_contents, file.updated_date, file.picture_url , user.login
  FROM ' . PREFIX . 'news file
  LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = file.author_user_id 
  WHERE visible = 1 AND approved = 1 AND file.id_category IN (' . implode(', ', $id_cats) . ')
);
 
$this->build_categorie_view($results);
}
 
private function build_categorie_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/categorie1.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 6)
{
break; 
}
 
$link = new Url('/news/news' . url('.php?id=' . $row['id'], '-' . $row['id'] .  '+' . Url::encode_rewrite($row['name']) . '.php'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['name'],
'DESC' => $row['short_contents'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('CATEGORIE', $tpl);
}
}
?>