Forum

class ArticlesExtensionPointProvider extends ExtensionPointProvider
{
    public function __construct()
    {
        parent::__construct('articles');
    }
 
    public function home_page()
    {
        return new ArticlesHomePageExtensionPoint();
    }
 
    public function comments()
    {
        return new CommentsTopics(array(new ArticlesCommentsTopic()));
    }
 
    public function css_files()
    {
        $module_css_files = new ModuleCssFiles();
        $module_css_files->adding_always_displayed_file('articles_mini.css');
        $module_css_files->adding_running_module_displayed_file('articles.css');
        return $module_css_files;
    }
 
    public function menus()
    {
        return new ModuleMenus(array(
            new ArticlesTopViewModuleMiniMenu(),
            new ArticlesLastArticlesModuleMiniMenu()
            ));
    }
 
    public function feeds()
    {
        return new ArticlesFeedProvider();
    }
 
    public function scheduled_jobs()
    {
        return new ArticlesScheduledJobs();
    }
 
    public function search()
    {
        return new ArticlesSearchable();
    }
    public function sitemap()
    {
        return new ArticlesSitemapExtensionPoint();
    }
 
    public function tree_links()
    {
        return new ArticlesTreeLinks();
    }
 
    public function url_mappings()
    {
        return new UrlMappings(array(new DispatcherUrlMapping('/articles/index.php')));
    }
}

class ArticlesTopViewModuleMiniMenu extends ModuleMiniMenu
{
    public function get_default_block()
    {
        return self::BLOCK_POSITION__RIGHT;
    }
 
    public function get_menu_id()
    {
        return 'module-mini-articles-top-view';
    }
 
    public function get_menu_title()
    {
        return LangLoader::get_message('articles.top.view', 'common', 'articles');
    }
 
    public function is_displayed()
    {
        return ArticlesAuthorizationsService::check_authorizations()->read();
    }
 
    public function get_menu_content()
    {
        //Create file template
        $tpl = new FileTemplate('articles/ArticlesTopView.tpl');
 
        //Assign the lang file to the tpl
        $tpl->add_lang(LangLoader::get('common', 'articles'));
 
        $now = new Date();
        $querier = PersistenceContext::get_querier();
        $top_view = 1;
        $results = $querier->select('SELECT articles.*, member.*, com.number_comments, notes.average_notes, notes.number_notes, note.note, cat.rewrited_name AS rewrited_name_cat
            FROM ' . PREFIX . 'articles articles
            LEFT JOIN ' . PREFIX . 'articles_cats cat ON cat.id = articles.id_category
            LEFT JOIN ' . DB_TABLE_MEMBER . ' member ON member.user_id = articles.author_user_id
            LEFT JOIN ' . DB_TABLE_COMMENTS_TOPIC . ' com ON com.id_in_module = articles.id AND com.module_id = \'articles\'
            LEFT JOIN ' . DB_TABLE_AVERAGE_NOTES . ' notes ON notes.id_in_module = articles.id AND notes.module_name = \'articles\'
            LEFT JOIN ' . DB_TABLE_NOTE . ' note ON note.id_in_module = articles.id AND note.module_name = \'articles\' AND note.user_id = :user_id
            AND (published = 1 OR (published = 2 AND publishing_start_date < :timestamp_now AND (publishing_end_date > :timestamp_now OR publishing_end_date = 0)))
            ORDER BY articles.number_view DESC
            LIMIT 10
            ', array(
                'user_id' => AppContext::get_current_user()->get_id(),
                'timestamp_now' => $now->get_timestamp()
            ));
 
        while($row = $results->fetch())
        {
            $article = new Article();
            $article->set_properties($row);
 
            $tpl->assign_block_vars('articles_items', $article->get_tpl_vars());
            $top_view++;
        }
 
        return $tpl->render();
    }
}

class ArticlesLastArticlesModuleMiniMenu extends ModuleMiniMenu
{
    public function get_default_block()
    {
        return self::BLOCK_POSITION__RIGHT;
    }
 
    public function get_menu_id()
    {
        return 'module-mini-articles-last-articles';
    }
 
    public function get_menu_title()
    {
        return LangLoader::get_message('articles.last.articles', 'common', 'articles');
    }
 
    public function is_displayed()
    {
        return ArticlesAuthorizationsService::check_authorizations()->read();
    }
 
    public function get_menu_content()
    {
        //Create file template
        $tpl = new FileTemplate('articles/ArticlesLastArticles.tpl');
 
        //Assign the lang file to the tpl
        $tpl->add_lang(LangLoader::get('common', 'articles'));
 
        $now = new Date();
        $querier = PersistenceContext::get_querier();
        $top_view = 1;
        $results = $querier->select('SELECT articles.*, member.*, com.number_comments, notes.average_notes, notes.number_notes, note.note, cat.rewrited_name AS rewrited_name_cat
            FROM ' . PREFIX . 'articles articles
            LEFT JOIN ' . PREFIX . 'articles_cats cat ON cat.id = articles.id_category
            LEFT JOIN ' . DB_TABLE_MEMBER . ' member ON member.user_id = articles.author_user_id
            LEFT JOIN ' . DB_TABLE_COMMENTS_TOPIC . ' com ON com.id_in_module = articles.id AND com.module_id = \'articles\'
            LEFT JOIN ' . DB_TABLE_AVERAGE_NOTES . ' notes ON notes.id_in_module = articles.id AND notes.module_name = \'articles\'
            LEFT JOIN ' . DB_TABLE_NOTE . ' note ON note.id_in_module = articles.id AND note.module_name = \'articles\' AND note.user_id = :user_id
            AND (published = 1 OR (published = 2 AND publishing_start_date < :timestamp_now AND (publishing_end_date > :timestamp_now OR publishing_end_date = 0)))
            ORDER BY articles.date_created DESC
            LIMIT 10
            ', array(
                'user_id' => AppContext::get_current_user()->get_id(),
                'timestamp_now' => $now->get_timestamp()
            ));
 
        while($row = $results->fetch())
        {
            $article = new Article();
            $article->set_properties($row);
 
            $tpl->assign_block_vars('articles_items', $article->get_tpl_vars());
            $top_view++;
        }
 
        return $tpl->render();
    }
}