123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710 |
- <?php
- $uInfo = $_REQUEST['uInfo'];
- $view = $_REQUEST['view'];
- $language_file = 'tracking';
- include('../inc/global.inc.php');
- $user_id = api_get_user_id();
- $course_id = api_get_course_id();
- $is_allowed = true;
- include(api_get_path(LIBRARY_PATH).'statsUtils.lib.inc.php');
- include(api_get_path(LIBRARY_PATH).'course.lib.php');
- include(api_get_path(SYS_CODE_PATH).'resourcelinker/resourcelinker.inc.php');
- require_once(api_get_path(SYS_CODE_PATH).'exercice/hotpotatoes.lib.php');
- if ($_GET['scormcontopen'])
- {
- $tbl_lp = Database::get_course_table(TABLE_LP_MAIN);
- $contopen = (int) $_GET['scormcontopen'];
- $sql = "SELECT default_encoding FROM $tbl_lp WHERE id = ".$contopen;
- $res = Database::query($sql,__FILE__,__LINE__);
- $row = Database::fetch_array($res);
- $lp_charset = $row['default_encoding'];
-
- }
- if($uInfo)
- {
- $interbreadcrumb[]= array ("url"=>"../user/userInfo.php?uInfo=$uInfo", "name"=> get_lang('BredCrumpUsers'));
- }
- $nameTools = get_lang('ToolName');
- $is_allowedToTrack = $is_courseAdmin;
- $is_course_member = CourseManager::is_user_subscribed_in_real_or_linked_course($user_id, $course_id);
- $TABLECOURSUSER = Database::get_main_table(TABLE_MAIN_COURSE_USER);
- $TABLEUSER = Database::get_main_table(TABLE_MAIN_USER);
- $tbl_session_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
- $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
- $TABLETRACK_ACCESS = $_configuration['statistics_database']."`.`track_e_access";
- $TABLETRACK_LINKS = $_configuration['statistics_database']."`.`track_e_links";
- $TABLETRACK_LOGIN = $_configuration['statistics_database']."`.`track_e_login";
- $TABLETRACK_DOWNLOADS = $_configuration['statistics_database']."`.`track_e_downloads";
- $TABLETRACK_UPLOADS = $_configuration['statistics_database']."`.`track_e_uploads";
- $TABLETRACK_EXERCICES = $_configuration['statistics_database']."`.`track_e_exercices";
- $TABLETRACK_HOTPOTATOES = $_configuration['statistics_database']."`.`track_e_hotpotatoes";
- $TABLECOURSE_LINKS = Database::get_course_table(TABLE_LINK);
- $TABLECOURSE_WORK = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
- $TABLECOURSE_GROUPSUSER = Database::get_course_table(TABLE_GROUP_USER);
- $TABLECOURSE_EXERCICES = Database::get_course_table(TABLE_QUIZ_TEST);
- if(api_get_setting('use_session_mode') == "true") {
- $sql = "SELECT 1
- FROM $tbl_session_course_user AS session_course_user
- INNER JOIN $tbl_session AS session
- ON session_course_user.id_session = session.id
- AND ((date_start<=NOW()
- AND date_end>=NOW())
- OR (date_start='0000-00-00' AND date_end='0000-00-00'))
- WHERE id_session='".$_SESSION['id_session']."' AND course_code='$_cid'";
-
- $result=Database::query($sql,__FILE__,__LINE__);
- if(!Database::num_rows($result)){
- $disabled = true;
- }
- }
- $tbl_learnpath_main = Database::get_course_table(TABLE_LP_MAIN);
- $tbl_learnpath_item = Database::get_course_table(TABLE_LP_ITEM);
- $tbl_learnpath_view = Database::get_course_table(TABLE_LP_VIEW);
- $tbl_learnpath_item_view = Database::get_course_table(TABLE_LP_ITEM_VIEW);
- $documentPath=api_get_path(SYS_COURSE_PATH).$_course['path'].'/document';
- $DaysShort = array (myEnc(get_lang("SundayShort")), myEnc(get_lang("MondayShort")), myEnc(get_lang("TuesdayShort")), myEnc(get_lang("WednesdayShort")), myEnc(get_lang("ThursdayShort")), myEnc(get_lang("FridayShort")), myEnc(get_lang("SaturdayShort")));
- $DaysLong = array (myEnc(get_lang("SundayLong")), myEnc(get_lang("MondayLong")), myEnc(get_lang("TuesdayLong")), myEnc(get_lang("WednesdayLong")), myEnc(get_lang("ThursdayLong")), myEnc(get_lang("FridayLong")), myEnc(get_lang("SaturdayLong")));
- $MonthsLong = array (myEnc(get_lang("JanuaryLong")), myEnc(get_lang("FebruaryLong")), myEnc(get_lang("MarchLong")), myEnc(get_lang("AprilLong")), myEnc(get_lang("MayLong")), myEnc(get_lang("JuneLong")), myEnc(get_lang("JulyLong")), myEnc(get_lang("AugustLong")), myEnc(get_lang("SeptemberLong")), myEnc(get_lang("OctoberLong")), myEnc(get_lang("NovemberLong")), myEnc(get_lang("DecemberLong")));
- $MonthsShort = array (myEnc(get_lang("JanuaryShort")), myEnc(get_lang("FebruaryShort")), myEnc(get_lang("MarchShort")), myEnc(get_lang("AprilShort")), myEnc(get_lang("MayShort")), myEnc(get_lang("JuneShort")), myEnc(get_lang("JulyShort")), myEnc(get_lang("AugustShort")), myEnc(get_lang("SeptemberShort")), myEnc(get_lang("OctoberShort")), myEnc(get_lang("NovemberShort")), myEnc(get_lang("DecemberShort")));
- $is_allowedToTrack = true;
- $is_allowedToTrackEverybodyInCourse = $is_allowedToTrack;
- function myEnc($isostring,$supposed_encoding='ISO-8859-15')
- {
- return api_htmlentities($isostring,ENT_QUOTES,$supposed_encoding);
- }
- function display_login_tracking_info($view, $user_id, $course_id)
- {
- $MonthsLong = $GLOBALS['MonthsLong'];
- $track_access_table = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ACCESS);
- $tempView = $view;
- if(substr($view,0,1) == '1')
- {
- $new_view = substr_replace($view,'0',0,1);
- $title[1]= myEnc(get_lang('LoginsAndAccessTools')).myEnc(get_lang('LoginsDetails'));
- $sql = "SELECT UNIX_TIMESTAMP(`access_date`), count(`access_date`)
- FROM $track_access_table
- WHERE `access_user_id` = '$user_id'
- AND `access_cours_code` = '".$course_id."'
- GROUP BY YEAR(`access_date`),MONTH(`access_date`)
- ORDER BY YEAR(`access_date`),MONTH(`access_date`) ASC";
-
- $results = getManyResults3Col($sql);
- $title_line= myEnc(get_lang('LoginsTitleMonthColumn')).';'.myEnc(get_lang('LoginsTitleCountColumn'))."\n";
- $line='';
- $total = 0;
- if (is_array($results))
- {
- for($j = 0 ; $j < count($results) ; $j++)
- {
- $line .= $results[$j][0].';'.$results[$j][1]."\n";
- $total = $total + $results[$j][1];
- }
- $line .= myEnc(get_lang('Total')).";".$total."\n";
- }
- else
- {
- $line= myEnc(get_lang('NoResult'))."</center></td>";
- }
- }
- else
- {
- $new_view = substr_replace($view,'1',0,1);
- }
- return array($title_line, $line);
- }
- function display_exercise_tracking_info($view, $user_id, $course_id)
- {
- global $TABLECOURSE_EXERCICES, $TABLETRACK_EXERCICES, $TABLETRACK_HOTPOTATOES;
- if(substr($view,1,1) == '1')
- {
- $new_view = substr_replace($view,'0',1,1);
- $title[1]= myEnc(get_lang('ExercicesDetails'));
- $line='';
- $sql = "SELECT `ce`.`title`, `te`.`exe_result` , `te`.`exe_weighting`, UNIX_TIMESTAMP(`te`.`exe_date`)
- FROM $TABLECOURSE_EXERCICES AS ce , `$TABLETRACK_EXERCICES` AS `te`
- WHERE `te`.`exe_cours_id` = '$course_id'
- AND `te`.`exe_user_id` = '$user_id'
- AND `te`.`exe_exo_id` = `ce`.`id`
- ORDER BY `ce`.`title` ASC, `te`.`exe_date` ASC";
- $hpsql = "SELECT `te`.`exe_name`, `te`.`exe_result` , `te`.`exe_weighting`, UNIX_TIMESTAMP(`te`.`exe_date`)
- FROM `$TABLETRACK_HOTPOTATOES` AS te
- WHERE `te`.`exe_user_id` = '$user_id' AND `te`.`exe_cours_id` = '$course_id'
- ORDER BY `te`.`exe_cours_id` ASC, `te`.`exe_date` ASC";
- $hpresults = getManyResultsXCol($hpsql, 4);
- $NoTestRes = 0;
- $NoHPTestRes = 0;
- $results = getManyResultsXCol($sql, 4);
- $title_line=myEnc(get_lang('ExercicesTitleExerciceColumn')).";".myEnc(get_lang('Date')).';'.myEnc(get_lang('ExercicesTitleScoreColumn'))."\n";
- if (is_array($results))
- {
- for($i = 0; $i < sizeof($results); $i++)
- {
- $display_date = format_locale_date(get_lang('dateTimeFormatLong'), $results[$i][3]);
- $line .= $results[$i][0].";".$display_date.";".$results[$i][1]." / ".$results[$i][2]."\n";
- }
- }
- else
- {
- $NoTestRes = 1;
- }
-
- if(is_array($hpresults))
- {
- for($i = 0; $i < sizeof($hpresults); $i++)
- {
- $title = GetQuizName($hpresults[$i][0],'');
- if ($title == '')
- $title = basename($hpresults[$i][0]);
- $display_date = format_locale_date(get_lang('dateTimeFormatLong'), $hpresults[$i][3]);
- $line .= $title.';'.$display_date.';'.$hpresults[$i][1].'/'.$hpresults[$i][2]."\n";
- }
- }
- else
- {
- $NoHPTestRes = 1;
- }
- if ($NoTestRes == 1 && $NoHPTestRes == 1)
- {
- $line=get_lang('NoResult');
- }
- }
- else
- {
- $new_view = substr_replace($view,'1',1,1);
- }
- return array($title_line, $line);
- }
- function display_student_publications_tracking_info($view, $user_id, $course_id)
- {
- global $TABLETRACK_UPLOADS, $TABLECOURSE_WORK, $dateTimeFormatLong;
- if(substr($view,2,1) == '1')
- {
- $new_view = substr_replace($view,'0',2,1);
- $sql = "SELECT `u`.`upload_date`, `w`.`title`, `w`.`author`,`w`.`url`
- FROM `$TABLETRACK_UPLOADS` `u` , $TABLECOURSE_WORK `w`
- WHERE `u`.`upload_work_id` = `w`.`id`
- AND `u`.`upload_user_id` = '$user_id'
- AND `u`.`upload_cours_id` = '$course_id'
- ORDER BY `u`.`upload_date` DESC";
- $results = getManyResultsXCol($sql,4);
- $title[1]=myEnc(get_lang('WorksDetails'));
- $line='';
- $title_line=myEnc(get_lang('WorkTitle')).";".myEnc(get_lang('WorkAuthors')).";".myEnc(get_lang('Date'))."\n";
- if (is_array($results))
- {
- for($j = 0 ; $j < count($results) ; $j++)
- {
- $pathToFile = api_get_path(WEB_COURSE_PATH).$_course['path']."/".$results[$j][3];
- $timestamp = strtotime($results[$j][0]);
- $beautifulDate = format_locale_date($dateTimeFormatLong,$timestamp);
- $line .= $results[$j][1].";".$results[$j][2].";".$beautifulDate."\n";
- }
- }
- else
- {
- $line= myEnc(get_lang('NoResult'));
- }
- }
- else
- {
- $new_view = substr_replace($view,'1',2,1);
- }
- return array($title_line, $line);
- }
- function display_links_tracking_info($view, $user_id, $course_id)
- {
- global $TABLETRACK_LINKS, $TABLECOURSE_LINKS;
- if(substr($view,3,1) == '1')
- {
- $new_view = substr_replace($view,'0',3,1);
- $title[1]=myEnc(get_lang('LinksDetails'));
- $sql = "SELECT `cl`.`title`, `cl`.`url`
- FROM `$TABLETRACK_LINKS` AS sl, $TABLECOURSE_LINKS AS cl
- WHERE `sl`.`links_link_id` = `cl`.`id`
- AND `sl`.`links_cours_id` = '$course_id'
- AND `sl`.`links_user_id` = '$user_id'
- GROUP BY `cl`.`title`, `cl`.`url`";
- $results = getManyResults2Col($sql);
- $title_line= myEnc(get_lang('LinksTitleLinkColumn'))."\n";
- if (is_array($results))
- {
- for($j = 0 ; $j < count($results) ; $j++)
- {
- $line .= $results[$j][0]."\n";
- }
- }
- else
- {
- $line=myEnc(get_lang('NoResult'));
- }
- }
- else
- {
- $new_view = substr_replace($view,'1',3,1);
- }
- return array($title_line, $line);
- }
- function display_document_tracking_info($view, $user_id, $course_id)
- {
- $downloads_table = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);
- if(substr($view,4,1) == '1')
- {
- $new_view = substr_replace($view,'0',4,1);
- $title[1]= myEnc(get_lang('DocumentsDetails'));
- $sql = "SELECT `down_doc_path`
- FROM $downloads_table
- WHERE `down_cours_id` = '$course_id'
- AND `down_user_id` = '$user_id'
- GROUP BY `down_doc_path`";
- $results = getManyResults1Col($sql);
- $title_line = myEnc(get_lang('DocumentsTitleDocumentColumn'))."\n";
- if (is_array($results))
- {
- for($j = 0 ; $j < count($results) ; $j++)
- {
- $line .= $results[$j]."\n";
- }
- }
- else
- {
- $line=myEnc(get_lang('NoResult'));
- }
- }
- else
- {
- $new_view = substr_replace($view,'1',4,1);
- }
- return array($title_line, $line);
- }
- $title[0]='';
- $title[1]='';
- $line='';
- $title_line='';
- if( ( $is_allowedToTrack || $is_allowedToTrackEverybodyInCourse ) && $_configuration['tracking_enabled'] )
- {
- if(!$uInfo && !isset($uInfo) )
- {
-
- if( $is_allowedToTrackEverybodyInCourse )
- {
-
- if(api_get_setting('use_session_mode')) {
- $sql = "SELECT count(user_id)
- FROM $TABLECOURSUSER
- WHERE `course_code` = '$_cid'";
- }
- else {
- $sql = "SELECT count(id_user)
- FROM $tbl_session_course_user
- WHERE `course_code` = '$_cid'";
- }
- }
- else
- {
-
- $sql = "SELECT count(user)
- FROM $TABLECOURSE_GROUPSUSER
- WHERE `group_id` = '$_gid'";
- }
- $userGroupNb = getOneResult($sql);
- $step = 25;
- if ($userGroupNb > $step)
- {
- if(!isset($offset))
- {
- $offset=0;
- }
- $next = $offset + $step;
- $previous = $offset - $step;
- $navLink = "";
- if ($previous >= 0)
- {
- }
- if ($next < $userGroupNb)
- {
- }
- }
- else
- {
- $offset = 0;
- }
- echo $navLink;
- if (!settype($offset, 'integer') || !settype($step, 'integer')) die('Offset or step variables are not integers.');
- if( $is_allowedToTrackEverybodyInCourse )
- {
-
- $sql = "SELECT `u`.`user_id`, `u`.`firstname`,`u`.`lastname`
- FROM $TABLECOURSUSER cu , $TABLEUSER u
- WHERE `cu`.`user_id` = `u`.`user_id`
- AND `cu`.`course_code` = '$_cid'
- LIMIT $offset,$step";
- }
- else
- {
-
- $sql = "SELECT `u`.`user_id`, `u`.`firstname`,`u`.`lastname`
- FROM $TABLECOURSE_GROUPSUSER gu , $TABLEUSER u
- WHERE `gu`.`user_id` = `u`.`user_id`
- AND `gu`.`group_id` = '$_gid'
- LIMIT $offset,$step";
- }
- $list_users = getManyResults3Col($sql);
- for($i = 0 ; $i < sizeof($list_users) ; $i++)
- {
- }
- }
- else
- {
-
-
-
- if( $is_allowedToTrackEverybodyInCourse )
- {
-
- $tracking_is_accepted = $is_course_member;
- $tracked_user_info = Database::get_user_info_from_id($uInfo);
- $title[0]=$tracked_user_info[1].'_'.$tracked_user_info[2];
- }
- 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,__FILE__,__LINE__);
- $tracked_user_info = @mysql_fetch_assoc($query);
- if(is_array($tracked_user_info)) $tracking_is_accepted = true;
- $title[0] = $tracked_user_info['firstname'].'_'.$tracked_user_info['lastname'];
- }
- if ($tracking_is_accepted)
- {
- $tracked_user_info['email'] == '' ? $mail_link = myEnc(get_lang('NoEmail')) : $mail_link = Display::encrypted_mailto_link($tracked_user_info['email']);
- if(!isset($view))
- {
- $view ='0000000';
- }
-
- list($title_line1, $line1) = display_login_tracking_info($view, $uInfo, $_cid);
-
- list($title_line2, $line2) = display_exercise_tracking_info($view, $uInfo, $_cid);
-
- list($title_line3, $line3) = display_student_publications_tracking_info($view, $uInfo, $_cid);
-
- list($title_line4, $line4) = display_links_tracking_info($view, $uInfo, $_cid);
-
- list($title_line5, $line5) = display_document_tracking_info($view, $uInfo, $_cid);
- $title_line = $title_line1.$title_line2.$title_line3.$title_line4.$title_line5;
- $line= $line1.$line2.$line3.$line4.$line5;
- }
- else
- {
- echo myEnc(get_lang('ErrorUserNotInGroup'));
- }
-
-
-
- }
-
- $len = strlen($title_line.$line);
- header('Content-type: application/octet-stream');
-
- header('Content-length: '.$len);
- $filename = html_entity_decode(str_replace(":","",str_replace(" ","_", $title[0].'_'.$title[1].'.csv')));
- if(preg_match("/MSIE 5.5/",$_SERVER['HTTP_USER_AGENT']))
- {
- header('Content-Disposition: filename= '.$filename);
- }
- else
- {
- header('Content-Disposition: attachment; filename= '.$filename);
- }
- if(strpos($_SERVER['HTTP_USER_AGENT'],'MSIE'))
- {
- header('Pragma: ');
- header('Cache-Control: ');
- header('Cache-Control: public');
- }
- header('Content-Description: '.$filename);
- header('Content-transfer-encoding: binary');
- echo api_html_entity_decode($title_line, ENT_QUOTES, $charset);
- echo api_html_entity_decode($line, ENT_QUOTES, $charset);
- exit;
- }
- else
- {
- if(!$_configuration['tracking_enabled'])
- {
- echo myEnc(get_lang('TrackingDisabled'));
- }
- else
- {
- api_not_allowed();
- }
- }
|