$line = ''; //Total $sql = "SELECT count(*)\n FROM {$TABLETRACK_ACCESS}\n WHERE c_id = {$courseId}\n AND access_tool IS NULL"; $count = StatsUtils::getOneResult($sql); $line .= get_lang('CountToolAccess') . " ; " . $count . "\n"; // last 31 days $sql = "SELECT count(*)\n FROM {$TABLETRACK_ACCESS}\n WHERE c_id = {$courseId}\n AND (access_date > DATE_ADD(CURDATE(), INTERVAL -31 DAY))\n AND access_tool IS NULL"; $count = StatsUtils::getOneResult($sql); $line .= get_lang('Last31days') . " ; " . $count . "\n"; // last 7 days $sql = "SELECT count(*)\n FROM {$TABLETRACK_ACCESS}\n WHERE c_id = {$courseId}\n AND (access_date > DATE_ADD(CURDATE(), INTERVAL -7 DAY))\n AND access_tool IS NULL"; $count = StatsUtils::getOneResult($sql); $line .= get_lang('Last7days') . " ; " . $count . "\n"; // today $sql = "SELECT count(*)\n FROM {$TABLETRACK_ACCESS}\n WHERE c_id = {$courseId}\n AND ( access_date > CURDATE() )\n AND access_tool IS NULL"; $count = StatsUtils::getOneResult($sql); $line .= get_lang('ThisDay') . " ; " . $count . "\n"; } /* Tools */ $tempView = $view; if ($view[2] == '1') { $tempView[2] = '0'; $title[1] = $nameTools; $line = ''; $title_line = get_lang('ToolTitleToolnameColumn') . ";" . get_lang('ToolTitleUsersColumn') . ";" . get_lang('ToolTitleCountColumn') . "\n"; $sql = "SELECT access_tool, COUNT(DISTINCT access_user_id),count( access_tool )\n FROM {$TABLETRACK_ACCESS}\n WHERE access_tool IS NOT NULL\n AND c_id = {$courseId}\n GROUP BY access_tool"; $results = getManyResults3Col($sql); if (is_array($results)) { for ($j = 0; $j < count($results); $j++) { $line .= $results[$j][0] . "/" . get_lang($results[$j][0]) . ";" . $results[$j][1] . ";" . $results[$j][2] . "\n"; }
$line = ''; $title_line = ''; // check if uid is tutor of this group if ($is_allowedToTrack || $is_allowedToTrackEverybodyInCourse) { if (!$uInfo && !isset($uInfo)) { /* * Display list of user of this group */ if ($is_allowedToTrackEverybodyInCourse) { // if user can track everybody : list user of course $sql = "SELECT count(user_id)\n FROM {$TABLECOURSUSER}\n WHERE c_id = '{$courseId}' AND relation_type<>" . COURSE_RELATION_TYPE_RRHH . ""; } else { // if user can only track one group : list users of this group $sql = "SELECT count(user)\n FROM {$TABLECOURSE_GROUPSUSER}\n WHERE group_id = '{$_gid}'"; } $userGroupNb = StatsUtils::getOneResult($sql); $step = 25; // number of student per page if ($userGroupNb > $step) { if (!isset($offset)) { $offset = 0; } $next = $offset + $step; $previous = $offset - $step; $navLink = ""; if ($previous >= 0) { } if ($next < $userGroupNb) { } } else { $offset = 0;