Show logins_details.php syntax highlighted
<?php // $Id: logins_details.php 2 2005-07-15 13:01:38Z roane $
/*
==============================================================================
Dokeos - elearning and course management software
Copyright (c) 2004 Dokeos S.A.
Copyright (c) 2003 Ghent University (UGent)
Copyright (c) 2001 Universite catholique de Louvain (UCL)
For a full list of contributors, see "credits.txt".
The full license can be read in "license.txt".
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.
See the GNU General Public License for more details.
Contact address: Dokeos, 44 rue des palais, B-1030 Brussels, Belgium
Mail: info@dokeos.com
==============================================================================
*/
/**
==============================================================================
* @author Thomas Depraetere
* @author Hugues Peeters
* @author Christophe Gesche
* @author Sebastien Piraux
*
* @package dokeos.tracking
==============================================================================
*/
/*
==============================================================================
INIT SECTION
==============================================================================
*/
$uInfo = $_REQUEST['uInfo'];
if( !isset($_REQUEST['reqdate']) )
$reqdate = time();
else
$reqdate = $_REQUEST['reqdate'];
$period = $_REQUEST['period'];
if(!isset($_REQUEST['view']))
$view ="0000000";
else
$view = $_REQUEST['view'];
$langFile = "tracking";
include('../inc/claro_init_global.inc.php');
$interbredcrump[]= array ("url"=>"../user/user.php", "name"=> get_lang('Users'));
$nameTools = get_lang('ToolName');
$htmlHeadXtra[] = "<style type='text/css'>
<!--
.secLine {background-color : #E6E6E6;}
.content {padding-left : 15px;padding-right : 15px; }
.specialLink{color : #0000FF;}
-->
</style>
<STYLE media='print' type='text/css'>
<!--
TD {border-bottom: thin dashed Gray;}
-->
</STYLE>";
//$TABLECOURSUSER = $mysqlMainDb."`.`cours_user";
//updated for 1.6 - YW
$TABLECOURSUSER = Database::get_main_table(MAIN_COURSE_USER_TABLE);
$TABLECOURSE_GROUPSUSER = $_course['dbNameGlu']."user_group";
$TABLEUSER = $mysqlMainDb."`.`user";
$TABLETRACK_LOGIN = $statsDbName."`.`track_e_login";
$TABLETRACK_ACCESS = $statsDbName."`.`track_e_access";
Display::display_header($nameTools, "Tracking");
include(api_get_library_path()."/statsUtils.lib.inc.php");
// the variables for the days and the months
// Defining the shorts for the days
$DaysShort = array (get_lang("SundayShort"), get_lang("MondayShort"), get_lang("TuesdayShort"), get_lang("WednesdayShort"), get_lang("ThursdayShort"), get_lang("FridayShort"), get_lang("SaturdayShort"));
// Defining the days of the week to allow translation of the days
$DaysLong = array (get_lang("SundayLong"), get_lang("MondayLong"), get_lang("TuesdayLong"), get_lang("WednesdayLong"), get_lang("ThursdayLong"), get_lang("FridayLong"), get_lang("SaturdayLong"));
// Defining the months of the year to allow translation of the months
$MonthsLong = array (get_lang("JanuaryLong"), get_lang("FebruaryLong"), get_lang("MarchLong"), get_lang("AprilLong"), get_lang("MayLong"), get_lang("JuneLong"), get_lang("JulyLong"), get_lang("AugustLong"), get_lang("SeptemberLong"), get_lang("OctoberLong"), get_lang("NovemberLong"), get_lang("DecemberLong"));
// Defining the months of the year to allow translation of the months
$MonthsShort = array (get_lang("JanuaryShort"), get_lang("FebruaryShort"), get_lang("MarchShort"), get_lang("AprilShort"), get_lang("MayShort"), get_lang("JuneShort"), get_lang("JulyShort"), get_lang("AugustShort"), get_lang("SeptemberShort"), get_lang("OctoberShort"), get_lang("NovemberShort"), get_lang("DecemberShort"));
$is_allowedToTrack = $is_groupTutor; // allowed to track only user of one group
$is_allowedToTrackEverybodyInCourse = $is_courseAdmin; // allowed to track all student in course
?>
<h3>
<?php echo $nameTools ?>
</h3>
<table width="100%" cellpadding="2" cellspacing="3" border="0">
<?
// check if uid is tutor of this group
if( ( $is_allowedToTrack || $is_allowedToTrackEverybodyInCourse ) && $is_trackingEnabled )
{
if( $is_allowedToTrackEverybodyInCourse )
{
$sql = "SELECT `u`.`firstname`,`u`.`lastname`, `u`.`email`
FROM $TABLECOURSUSER cu , `$TABLEUSER` u
WHERE `cu`.`user_id` = `u`.`user_id`
AND `cu`.`course_code` = '$_cid'
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 = api_sql_query($sql,__FILE__,__LINE__);
$res = @mysql_fetch_array($query);
if(is_array($res))
{
$res[2] == "" ? $res2 = get_lang('NoEmail') : $res2 = Display::encrypted_mailto_link($res[2]);
echo "<tr><td>";
echo $informationsAbout." : <br>";
echo "<ul>\n"
."<li>".get_lang('FirstName')." : ".$res[1]."</li>\n"
."<li>".get_lang('LastName')." : ".$res[0]."</li>\n"
."<li>".get_lang('Email')." : ".$res2."</li>\n"
."</ul>";
echo "</td></tr>";
/******* MENU ********/
echo "<tr>
<td>
[<a href='userLog.php?uInfo=$uInfo&view=$view'>".get_lang('Back')."</a>]
";
echo " ||
[<a href='".$_SERVER['PHP_SELF']."?uInfo=$uInfo&view=$view&period=week&reqdate=$reqdate' class='specialLink'>".get_lang('PeriodWeek')."</a>]
[<a href='".$_SERVER['PHP_SELF']."?uInfo=$uInfo&view=$view&period=month&reqdate=$reqdate' class='specialLink'>".get_lang('PeriodMonth')."</a>]
||
";
switch($period)
{
case "week" :
// previous and next date must be evaluated
$previousReqDate = $reqdate - 7*86400;
$nextReqDate = $reqdate + 7*86400;
echo "
[<a href='".$_SERVER['PHP_SELF']."?uInfo=$uInfo&view=$view&period=week&reqdate=$previousReqDate' class='specialLink'>".get_lang('PreviousWeek')."</a>]
[<a href='".$_SERVER['PHP_SELF']."?uInfo=$uInfo&view=$view&period=week&reqdate=$nextReqDate' class='specialLink'>".get_lang('NextWeek')."</a>]
";
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 "
[<a href='".$_SERVER['PHP_SELF']."?uInfo=$uInfo&view=$view&period=month&reqdate=$previousReqDate' class='specialLink'>".get_lang('PreviousMonth')."</a>]
[<a href='".$_SERVER['PHP_SELF']."?uInfo=$uInfo&view=$view&period=month&reqdate=$nextReqDate' class='specialLink'>".get_lang('NextMonth')."</a>]
";
break;
}
echo "
</td>
</tr>
";
/******* END OF MENU ********/
switch($period)
{
case "month" :
/*$sql = "SELECT `login_date`
FROM `$TABLETRACK_LOGIN`
WHERE `login_user_id` = '$uInfo'
AND MONTH(`login_date`) = MONTH( FROM_UNIXTIME('$reqdate') )
AND YEAR(`login_date`) = YEAR(FROM_UNIXTIME('$reqdate'))
ORDER BY `login_date` ASC ";*/
$sql = "SELECT `access_date`
FROM `$TABLETRACK_ACCESS`
WHERE `access_user_id` = '$uInfo'
AND `access_cours_code` = '".$_cid."'
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 `login_date`
FROM `$TABLETRACK_LOGIN`
WHERE `login_user_id` = '$uInfo'
AND WEEK(`login_date`) = WEEK( FROM_UNIXTIME('$reqdate') )
AND YEAR(`login_date`) = YEAR(FROM_UNIXTIME('$reqdate'))
ORDER BY `login_date` ASC ";*/
$sql = "SELECT `access_date`
FROM `$TABLETRACK_ACCESS`
WHERE `access_user_id` = '$uInfo'
AND `access_cours_code` = '".$_cid."'
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 "<tr><td>";
$results = getManyResults1Col($sql);
/*** display of the displayed period ***/
echo "<table width='100%' cellpadding='2' cellspacing='1' border='0' align=center>";
echo "<td bgcolor='#E6E6E6'>".$displayedDate."</td>";
if (is_array($results))
{
for ($j = 0 ; $j < sizeof($results); $j++)
{
$timestamp = strtotime($results[$j]);
//$beautifulDate = $langDay_of_weekNames['long'][date("w" , $timestamp)].date(" d " , $timestamp);
//$beautifulHour = date("H : i" , $timestamp);
$beautifulDateTime = dateLocalizer($dateTimeFormatLong,$timestamp);
echo "<tr>";
echo "<td style='padding-left : 40px;' valign='top'>".$beautifulDateTime."</td>";
echo"</tr>";
// $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 `access_cours_code` = '".$_cid."'
GROUP BY `access_tool`
ORDER BY `access_tool` ASC";
$results2 = getManyResults2Col($sql);
if (is_array($results2))
{
echo "<tr><td colspan='2'>\n";
echo "<table width='50%' cellpadding='0' cellspacing='0' border='0'>\n";
for($k = 0 ; $k < count($results2) ; $k++)
{
echo "<tr>\n";
echo "<td width='70%' style='padding-left : 60px;'>".get_lang($results2[$k][0])."</td>\n";
echo "<td width='30%' align='right' style='padding-right : 40px'>".$results2[$k][1]." ".get_lang('Visits')."</td>\n";
echo "</tr>";
}
echo "</table>\n";
echo "</td></tr>\n";
}
$previousDate = $value;
}
}
else
{
echo "<tr>";
echo "<td colspan='2' bgcolor='#eeeeee'><center>".get_lang('NoResult')."</center></td>";
echo"</tr>";
}
echo "</table>";
echo "</td></tr>";
}
else
{
echo get_lang('ErrorUserNotInGroup');
}
}
// not allowed
else
{
if(!$is_trackingEnabled)
{
echo get_lang('TrackingDisabled');
}
else
{
api_not_allowed();
}
}
?>
</table>
<?php
Display::display_footer();
?>
See more files for this project here