<?php // $Id: logins_details.php,v 1.22 2005/06/27 14:39:08 olivierb78 Exp $
/*
==============================================================================
	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 "  &nbsp;&nbsp;&nbsp;||&nbsp;&nbsp;&nbsp;
                [<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>]
                &nbsp;&nbsp;&nbsp;||&nbsp;&nbsp;&nbsp;
        ";
        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();
?>
