chamilo / chamilo-lms

    /**

     * @param string $action

     */

    public function getMostChangedPages($action)

    {

        $_course = $this->courseInfo;

        $tbl_wiki = $this->tbl_wiki;

        $course_id = $this->course_id;

        $condition_session = $this->condition_session;

        $groupfilter = $this->groupfilter;

        echo '<div class="actions">'.get_lang('MostChangedPages').'</div>';

        if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { //only by professors if page is hidden

            $sql = 'SELECT *, MAX(version) AS MAX FROM '.$tbl_wiki.'

                    WHERE c_id = '.$course_id.' AND '.$groupfilter.$condition_session.'

                    GROUP BY reflink';//TODO:check MAX and group by return last version

        } else {

            $sql = 'SELECT *, MAX(version) AS MAX FROM '.$tbl_wiki.'

                    WHERE c_id = '.$course_id.' AND '.$groupfilter.$condition_session.' AND visibility=1

                    GROUP BY reflink'; //TODO:check MAX and group by return last version

        }

        $allpages = Database::query($sql);

        //show table

        if (Database::num_rows($allpages) > 0) {

            $rows = array();

            while ($obj = Database::fetch_object($allpages)) {

                //get type assignment icon

                $ShowAssignment = '';

                if ($obj->assignment == 1) {

                    $ShowAssignment = Display::return_icon('wiki_assignment.png', get_lang('AssignmentDesc'), '', ICON_SIZE_SMALL);

                } elseif ($obj->assignment == 2) {

                    $ShowAssignment = Display::return_icon('wiki_work.png', get_lang('AssignmentWork'), '', ICON_SIZE_SMALL);

                } elseif ($obj->assignment == 0) {

                    $ShowAssignment = Display::return_icon('px_transparent.gif');

                }

                $row = array();

                $row[] = $ShowAssignment;

                $row[] = '<a href="'.api_get_self().'?cidReq='.$_course['code'].'&action=showpage&title='.api_htmlentities(urlencode($obj->reflink)).'&session_id='.api_htmlentities($_GET['session_id']).'&group_id='.api_htmlentities($_GET['group_id']).'">'.

                    api_htmlentities($obj->title).'</a>';

                $row[] = $obj->MAX;

                $rows[] = $row;

            }

            $table = new SortableTableFromArrayConfig(

                $rows,

                2,

                10,

                'MostChangedPages_table',

                '',

                '',

                'DESC'

            );

            $table->set_additional_parameters(

                array(

                    'cidReq' => Security::remove_XSS($_GET['cidReq']),

                    'action' => Security::remove_XSS($action),

                    'session_id' => intval($_GET['session_id']),

                    'group_id' => intval($_GET['group_id']),

                )

            );

            $table->set_header(

                0,

                get_lang('Type'),

                true,

                array('style' => 'width:30px;')

            );

            $table->set_header(1, get_lang('Title'), true);

            $table->set_header(2, get_lang('Changes'), true);

            $table->display();

    /**

     * Most visited

     */

    public function getMostVisited()

    {

        $tbl_wiki = $this->tbl_wiki;

        $course_id = $this->course_id;

        $groupfilter = $this->groupfilter;

        $condition_session = $this->condition_session;

        $_course = $this->courseInfo;

        echo '<div class="actions">'.get_lang('MostVisitedPages').'</div>';

        if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { //only by professors if page is hidden

            $sql = 'SELECT *, SUM(hits) AS tsum FROM '.$tbl_wiki.'

                    WHERE c_id = '.$course_id.' AND '.$groupfilter.$condition_session.'

                    GROUP BY reflink';

        } else {

            $sql = 'SELECT *, SUM(hits) AS tsum FROM '.$tbl_wiki.'

                    WHERE

                        c_id = '.$course_id.' AND

                        '.$groupfilter.$condition_session.' AND

                        visibility=1

                    GROUP BY reflink';

        }

        $allpages = Database::query($sql);

        //show table

        if (Database::num_rows($allpages) > 0) {

            $rows = array();

            while ($obj = Database::fetch_object($allpages)) {

                //get type assignment icon

                $ShowAssignment = '';

                if ($obj->assignment == 1) {

                    $ShowAssignment = Display::return_icon(

                        'wiki_assignment.png',

                        get_lang('AssignmentDesc'),

                        '',

                        ICON_SIZE_SMALL

                    );

                } elseif ($obj->assignment == 2) {

                    $ShowAssignment = $ShowAssignment = Display::return_icon(

                        'wiki_work.png',

                        get_lang('AssignmentWork'),

                        '',

                        ICON_SIZE_SMALL

                    );

                } elseif ($obj->assignment == 0) {

                    $ShowAssignment = Display::return_icon(

                        'px_transparent.gif'

                    );

                }

                $row = array();

                $row[] = $ShowAssignment;

                $row[] = '<a href="'.api_get_self().'?cidReq='.$_course['code'].'&action=showpage&title='.api_htmlentities(urlencode($obj->reflink)).'&session_id='.api_htmlentities($_GET['session_id']).'&group_id='.api_htmlentities($_GET['group_id']).'">'.

                    api_htmlentities($obj->title).'</a>';

                $row[] = $obj->tsum;

                $rows[] = $row;

            }

            $table = new SortableTableFromArrayConfig(

                $rows,

                2,

                10,

                'MostVisitedPages_table',

                '',

                '',

                'DESC'

            );

            $table->set_additional_parameters(

                array(

                    'cidReq' => Security::remove_XSS($_GET['cidReq']),

                    'action' => Security::remove_XSS($this->action),

                    'session_id' => intval($_GET['session_id']),