" . COURSE_RELATION_TYPE_RRHH . " AND
cu.c_id = '$courseId' AND
u.user_id = '$uInfo'";
} else {
$sql = "SELECT u.firstname,u.lastname, u.email
FROM $TABLECOURSE_GROUPSUSER gu , $TABLEUSER u
WHERE gu.user_id = u.user_id
AND gu.group_id = '$_gid'
AND u.user_id = '$uInfo'";
}
$query = Database::query($sql);
$res = @Database::fetch_array($query);
if (is_array($res)) {
$res[2] == "" ? $res2 = get_lang('NoEmail') : $res2 = Display::encrypted_mailto_link($res[2]);
echo "";
echo $informationsAbout . " :
";
echo "\n"
. "- " . get_lang('FirstName') . " : " . $res[0] . "
\n"
. "- " . get_lang('LastName') . " : " . $res[1] . "
\n"
. "- " . get_lang('Email') . " : " . $res2 . "
\n"
. " ";
echo " |
";
/* * ***** MENU ******* */
echo "
|
[" . get_lang('Back') . "]
";
echo " ||
[" . get_lang('PeriodWeek') . "]
[" . get_lang('PeriodMonth') . "]
||
";
switch ($period) {
case "week" :
// previous and next date must be evaluated
$previousReqDate = $reqdate - 7 * 86400;
$nextReqDate = $reqdate + 7 * 86400;
echo "
[" . get_lang('PreviousWeek') . "]
[" . get_lang('NextWeek') . "]
";
break;
default :
$period = "month";
case "month" :
// previous and next date must be evaluated
// 30 days should be a good approximation
$previousReqDate = mktime(1, 1, 1, date("m", $reqdate) - 1, 1, date("Y", $reqdate));
$nextReqDate = mktime(1, 1, 1, date("m", $reqdate) + 1, 1, date("Y", $reqdate));
echo "
[" . get_lang('PreviousMonth') . "]
[" . get_lang('NextMonth') . "]
";
break;
}
echo "
|
";
/* * ***** END OF MENU ******* */
switch ($period) {
case "month" :
$sql = "SELECT access_date
FROM $TABLETRACK_ACCESS
WHERE access_user_id = $uInfo
AND c_id = $courseId
AND MONTH(access_date) = MONTH( FROM_UNIXTIME('$reqdate') )
AND YEAR(access_date) = YEAR(FROM_UNIXTIME('$reqdate'))
GROUP BY DAYOFMONTH(access_date)
ORDER BY access_date ASC";
$displayedDate = $MonthsLong[date("n", $reqdate) - 1] . date(" Y", $reqdate);
break;
case "week" :
$sql = "SELECT access_date
FROM $TABLETRACK_ACCESS
WHERE access_user_id = $uInfo
AND c_id = $courseId
AND WEEK(access_date) = WEEK( FROM_UNIXTIME('$reqdate') )
AND YEAR(access_date) = YEAR(FROM_UNIXTIME('$reqdate'))
GROUP BY DAYOFMONTH(access_date)
ORDER BY access_date ASC";
$weeklowreqdate = ($reqdate - (86400 * date("w", $reqdate)));
$weekhighreqdate = ($reqdate + (86400 * (6 - date("w", $reqdate)) ));
$displayedDate = get_lang('From') . " " . date("d ", $weeklowreqdate) . $MonthsLong[date("n", $weeklowreqdate) - 1] . date(" Y", $weeklowreqdate)
. " " . get_lang('To') . " " . date("d ", $weekhighreqdate) . $MonthsLong[date("n", $weekhighreqdate) - 1] . date(" Y", $weekhighreqdate);
break;
}
echo "";
$results = StatsUtils::getManyResults1Col($sql);
/* * * display of the displayed period ** */
echo "";
echo "| " . $displayedDate . " | ";
if (is_array($results)) {
for ($j = 0; $j < sizeof($results); $j++) {
$beautifulDateTime = api_convert_and_format_date($results[$j], null, date_default_timezone_get());
echo "";
echo "| " . $beautifulDateTime . " | ";
echo" ";
// $limit is used to select only results between $results[$j] (current login) and next one
if ($j == ( sizeof($results) - 1 ))
$limit = date("Y-m-d H:i:s", $nextReqDate);
else
$limit = $results[$j + 1];
// select all access to tool between displayed date and next displayed date or now() if
// displayed date is the last login date
$sql = "SELECT access_tool, count(access_tool)
FROM $TABLETRACK_ACCESS
WHERE access_user_id = $uInfo
AND access_tool IS NOT NULL
AND access_date > '" . $results[$j] . "'
AND access_date < '" . $limit . "'
AND c_id = $courseId
GROUP BY access_tool
ORDER BY access_tool ASC";
$results2 = StatsUtils::getManyResults2Col($sql);
if (is_array($results2)) {
echo "\n";
echo "\n";
for ($k = 0; $k < count($results2); $k++) {
echo "\n";
echo "| " . get_lang($results2[$k][0]) . " | \n";
echo "" . $results2[$k][1] . " " . get_lang('Visits') . " | \n";
echo " ";
}
echo " \n";
echo " | \n";
}
$previousDate = $value;
}
} else {
echo "";
echo "| " . get_lang('NoResult') . " | ";
echo " ";
}
echo " ";
echo " |
";
} else {
echo get_lang('ErrorUserNotInGroup');
}
} else {
// not allowed
api_not_allowed();
}
?>