Forum

<?php
/*##################################################
 *                               ArticlesModuleMiniMenu.class.php
 *                            -------------------
 *   begin                : March 5, 2016
 *   copyright            : (C) 2016 SILVERPROD
 *   email                : silverprod.shost.ca@gmail.com
 *
 *
 ###################################################
 *
 * This program is a 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 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.
 *
 ###################################################*/
 /**
 * @author SILVERPROD <silverprod.shost.ca@gmail.com>
 */
class ArticlesModuleMiniMenu extends ModuleMiniMenu
{
    public function get_default_block()
    {
        return self::BLOCK_POSITION__RIGHT;
    }
 
    public function get_menu_id()
    {
        return 'module-mini-articles';
    }
 
    public function get_menu_title()
    {
        return ArticlesConfig::load()->is_sort_type_date() ? LangLoader::get_message('last_articles_files', 'common', 'articles') : LangLoader::get_message('most_view_articles_files', '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'));
 
        //Load module config
        $config = ArticlesConfig::load();
 
        //Load module cache
        $articles_cache = ArticlesCache::load();
 
        //Load categories cache
        $categories_cache = ArticlesService::get_categories_manager()->get_categories_cache();
 
        $articlesfiles = $articles_cache->get_articlesfiles();
 
        $tpl->put_all(array(
            'C_FILES' => !empty($articlesfiles),
            'C_SORT_BY_DATE' => $config->is_sort_type_date(),
            'C_SORT_BY_NOTATION' => $config->is_sort_type_notation(),
            'C_SORT_BY_NUMBER_VIEW' => $config->is_sort_type_number_view()
        ));
 
        $displayed_position = 1;
        foreach ($articlesfiles as $file)
        {
            $articlesfile = new ArticlesFile();
            $articlesfile->set_properties($file);
 
            $tpl->assign_block_vars('articlesfiles', array_merge($articlesfile->get_array_tpl_vars(), array(
                'DISPLAYED_POSITION' => $displayed_position
            )));
 
            $displayed_position++;
        }
 
        return $tpl->render();
    }
}
?>
 

<?php
/*##################################################
 *                        ArticlesExtensionPointProvider.class.php
 *                            -------------------
 *   begin                : March 5, 2016
 *   copyright            : (C) 2016 SILVERPROD
 *   email                : silverprod.shost.ca@gmail.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.
 *
 ###################################################*/
/**
 * @author SILVERPROD <silverprod.shost.ca@gmail.com>
 */
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_running_module_displayed_file('articles_mini.css');
        $module_css_files->adding_running_module_displayed_file('articles.css');
        return $module_css_files;
    }
 
    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')));
    }
}
?>

<table  id="table-mini-articles">
    <thead>
        <tr>
            <th><i class="fa # IF C_SORT_BY_DATE #fa-calendar# ELSE #fa-trophy# ENDIF #"></i></th>
            <th>${LangLoader::get_message('form.name', 'common')}</th>
            # IF NOT C_SORT_BY_DATE #
            <th><i class="fa # IF C_SORT_BY_NUMBER_VIEW #fa-view# ELSE #fa-star-o# ENDIF #"></i></th>
            # ENDIF #
        </tr>
    </thead>
    <tbody>
    # IF C_FILES #
        # START articlesfiles #
        <tr>
            <td># IF C_SORT_BY_DATE #<time datetime="{articlesfiles.DATE_ISO8601}">{articlesfiles.DATE_DAY_MONTH}</time># ELSE #{articlesfiles.DISPLAYED_POSITION}# ENDIF #</td>
            <td # IF C_SORT_BY_NOTATION #class="mini-articles-table-name"# ENDIF #>
                <a href="{articlesfiles.U_LINK}" title="{articlesfiles.NAME}">
                    {articlesfiles.NAME}
                </a>
            </td>
            # IF NOT C_SORT_BY_DATE #
            <td># IF C_SORT_BY_NUMBER_VIEW #{articlesfiles.NUMBER_VIEW}# ELSE #{articlesfiles.STATIC_NOTATION}# ENDIF #</td>
            # ENDIF #
        </tr>
        # END articlesfiles #
    # ELSE #
        <tr>
            <td colspan="# IF C_SORT_BY_DATE #2# ELSE #3# ENDIF #">${LangLoader::get_message('no_item_now', 'common')}</td>
        </tr>
    # ENDIF #
    </tbody>
</table>
 

return LangLoader::get_message('most_viewed_articles', 'common', 'articles');

$lang['most_viewed_articles'] = 'Articles les plus vus';

$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();