chamilo-lms2/main/inc/ajax/myspace.ajax.php

<?php
/* For licensing terms, see /license.txt */
/**
 * Responses to AJAX calls
 */

$language_file = array ('tracking');

require_once '../global.inc.php';
$action = $_GET['a'];

//if (!api_is_platform_admin() && !api_is_xml_http_request()) { exit; }
require_once api_get_path(SYS_CODE_PATH).'mySpace/myspace.lib.php';

switch ($action) {
    case 'access_detail':
        $user_id        = intval($_REQUEST['student']);
        $courseId    = Security::remove_XSS($_REQUEST['course']);
        $type           = Security::remove_XSS($_REQUEST['type']);
        $range          = Security::remove_XSS($_REQUEST['range']);

        if ($range == 1){
            $start_date     = Security::remove_XSS($_REQUEST['sd']);
            $end_date       = Security::remove_XSS($_REQUEST['ed']);
            $sql_result     = get_connections_to_course_by_date($user_id, $courseId, $start_date, $end_date);
        } else {
            $sql_result     = MySpace::get_connections_to_course($user_id, $courseId);
        }
        $foo_print = grapher($sql_result, $start_date, $end_date, $type);
        echo $foo_print;

        break;

    case 'access_detail_by_date':

        $db = array('is_empty'=>true);
        $start_date     = isset($_REQUEST['startDate'])?$_REQUEST['startDate']:"";
        $end_date       = isset($_REQUEST['endDate'])?$_REQUEST['endDate']:"";
        $user_id        = isset($_REQUEST['student'])?$_REQUEST['student']:"";
        $courseId    = isset($_REQUEST['course'])?$_REQUEST['course']:"";

        $sql_result = get_connections_to_course_by_date($user_id, $courseId, $start_date, $end_date);

        if (is_array($sql_result) && count($sql_result) > 0) {
            $db['is_empty']     = false;
            $db['result']       = convert_to_string($sql_result);
            $rst                = get_stats($user_id, $courseId, $start_date, $end_date);
            $foo_stats           = '<strong>'.get_lang('Total').': </strong>'.$rst['total'].'<br />';
            $foo_stats          .= '<strong>'.get_lang('Average').': </strong>'.$rst['avg'].'<br />';
            $foo_stats          .= '<strong>'.get_lang('Quantity').' : </strong>'.$rst['times'].'<br />';
            $db['stats']        = $foo_stats;
            $db['graph_result'] = grapher($sql_result, $start_date, $end_date);
        } else {
            $db['result']       = Display::return_message(get_lang('NoDataAvailable'), 'warning');
            $db['graph_result'] = Display::return_message(get_lang('NoDataAvailable'), 'warning');
            $db['stats']        = Display::return_message(get_lang('NoDataAvailable'), 'warning');
        }
        header('Cache-Control: no-cache');
        echo json_encode($db); // requires: PHP >= 5.2.0, PECL json >= 1.2.0

    break;
}
exit;