group_space_tracking.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. require_once '../inc/global.inc.php';
  4. $allow = api_get_configuration_value('extra');
  5. if (empty($allow)) {
  6. exit;
  7. }
  8. $current_course_tool = TOOL_GROUP;
  9. // Notice for unauthorized people.
  10. api_protect_course_script(true);
  11. /* Libraries & config files */
  12. require_once api_get_path(SYS_CODE_PATH).'forum/forumfunction.inc.php';
  13. require_once api_get_path(SYS_CODE_PATH).'forum/forumconfig.inc.php';
  14. /* MAIN CODE */
  15. $group_id = api_get_group_id();
  16. $user_id = api_get_user_id();
  17. $current_group = GroupManager:: get_group_properties($group_id);
  18. // regroup table names for maintenance purpose
  19. if (!api_is_allowed_to_edit(false, true) && !$is_group_member) {
  20. api_not_allowed(true);
  21. }
  22. $tbl_stats_exercices_temp = Database:: get_main_table(track_e_exercices_temp);
  23. //on vide la table temp qui recoit les examen complétés
  24. $query = "TRUNCATE TABLE $tbl_stats_exercices_temp ";
  25. $result = Database::query($query);
  26. if (empty($current_group)) {
  27. api_not_allowed(true);
  28. }
  29. $this_section = SECTION_COURSES;
  30. $nameTools = get_lang('suivi_de');
  31. $interbreadcrumb[] = ['url' => 'group.php', 'name' => get_lang('Groups')];
  32. $forums_of_groups = get_forums_of_group($current_group['id']);
  33. $forum_state_public = 0;
  34. if (is_array($forums_of_groups)) {
  35. foreach ($forums_of_groups as $key => $value) {
  36. if ($value['forum_group_public_private'] == 'public') {
  37. $forum_state_public = 1;
  38. }
  39. }
  40. }
  41. if ($current_group['doc_state'] != 1 &&
  42. $current_group['calendar_state'] != 1 &&
  43. $current_group['work_state'] != 1 &&
  44. $current_group['announcements_state'] != 1 &&
  45. $current_group['wiki_state'] != 1 &&
  46. $current_group['chat_state'] != 1 &&
  47. $forum_state_public != 1
  48. ) {
  49. if (!api_is_allowed_to_edit(null, true) &&
  50. !GroupManager::is_user_in_group($user_id, $group_id)) {
  51. api_not_allowed($print_headers);
  52. }
  53. }
  54. /* Header */
  55. Display::display_header($nameTools.' '.Security::remove_XSS($current_group['name']), 'Group');
  56. Display::display_introduction_section(TOOL_GROUP);
  57. $course_code = api_get_course_id();
  58. $is_course_member = CourseManager::is_user_subscribed_in_real_or_linked_course(
  59. api_get_user_id(),
  60. $course_code
  61. );
  62. /*
  63. * List all the tutors of the current group
  64. */
  65. $tutors = GroupManager::get_subscribed_tutors($current_group['id']);
  66. $tutor_info = '';
  67. if (count($tutors) == 0) {
  68. $tutor_info = get_lang('GroupNoneMasc');
  69. } else {
  70. isset($origin) ? $my_origin = $origin : $my_origin = '';
  71. $tutor_info .= '<ul class="thumbnails">';
  72. foreach ($tutors as $index => $tutor) {
  73. $tab_user_info = api_get_user_info($tutor['user_id']);
  74. $username = api_htmlentities(sprintf(get_lang('LoginX'), $tab_user_info['username']), ENT_QUOTES);
  75. $image_path = UserManager::get_user_picture_path_by_id($tutor['user_id'], 'web', false, true);
  76. $image_repository = $image_path['dir'];
  77. $existing_image = $image_path['file'];
  78. $completeName = api_get_person_name($tutor['firstname'], $tutor['lastname']);
  79. $photo = '<img src="'.$image_repository.$existing_image.'" alt="'.$completeName.'" width="32" height="32" title="'.$completeName.'" />';
  80. $tutor_info .= '<li><a href="'.api_get_path(
  81. WEB_CODE_PATH
  82. ).'user/userInfo.php?origin='.$my_origin.'&amp;uInfo='.$tutor['user_id'].'">'.
  83. $photo.'&nbsp;'.$completeName.'</a></li>';
  84. }
  85. $tutor_info .= '</ul>';
  86. }
  87. echo Display::page_subheader(get_lang('GroupTutors'));
  88. if (!empty($tutor_info)) {
  89. echo $tutor_info;
  90. }
  91. /*
  92. * List all the members of the current group
  93. */
  94. echo '<div class="actions">';
  95. $now = date('Y-m-d');
  96. echo '&nbsp;Le '.$now.' <a href="#" onclick="window.print()"><img align="absbottom" src="../img/printmgr.gif">&nbsp;'.get_lang(
  97. 'Print'
  98. ).'</a>';
  99. echo '&nbsp; <a target="_blank" href="save_diff_all.php"><img src="'.api_get_path(
  100. WEB_IMG_PATH
  101. ).'addd.gif" border="0" />'.get_lang('save_diff_all').'</a>';
  102. echo '</div>';
  103. $table = new SortableTable(
  104. 'group_users',
  105. 'get_number_of_group_users',
  106. 'get_group_user_data',
  107. (api_is_western_name_order() xor api_sort_by_first_name()) ? 2 : 1
  108. );
  109. //$table -> display();
  110. $my_cidreq = isset($_GET['cidReq']) ? Security::remove_XSS($_GET['cidReq']) : '';
  111. $my_origin = isset($_GET['origin']) ? Security::remove_XSS($_GET['origin']) : '';
  112. $my_gidreq = isset($_GET['gidReq']) ? Security::remove_XSS($_GET['gidReq']) : '';
  113. $parameters = ['cidReq' => $my_cidreq, 'origin' => $my_origin, 'gidReq' => $my_gidreq];
  114. $table->set_additional_parameters($parameters);
  115. $table->set_header(1, get_lang('OfficialCode'), false, 'align="center"');
  116. if (api_is_western_name_order()) {
  117. $table->set_header(2, get_lang('LastName'));
  118. $table->set_header(3, get_lang('FirstName'));
  119. } else {
  120. $table->set_header(2, get_lang('LastName'));
  121. $table->set_header(3, get_lang('FirstName'));
  122. }
  123. //the order of these calls is important
  124. $table->set_column_filter(2, 'user_name_filter');
  125. $table->set_column_filter(3, 'user_name_filter');
  126. $table->set_header(4, get_lang('Examen'), false);
  127. //the order of these calls is important
  128. $table->set_column_filter(2, 'user_name_filter');
  129. $table->set_column_filter(3, 'user_name_filter');
  130. $table->set_header(4, get_lang('Examen'), false);
  131. $table->set_header(5, get_lang('LatestLogin'), false, 'align="center"');
  132. $table->set_header(6, get_lang('time_tot'), false, 'align="center"');
  133. $table->set_header(7, get_lang('jours_complet'), false, 'align="center"');
  134. $table->set_header(8, get_lang('diff_horaire'), false, 'align="center"');
  135. $table->set_header(9, get_lang('save_diff'), false, 'align="center"');
  136. $table->set_header(10, get_lang('GroupCalendar'), false, 'align="center"');
  137. $table->set_header(11, get_lang('Details'), false);
  138. // Database table definition
  139. $table_group_user = Database:: get_course_table(TABLE_GROUP_USER);
  140. $table_user = Database:: get_main_table(TABLE_MAIN_USER);
  141. // $tbl_personal_agenda = Database :: get_user_personal_table(TABLE_PERSONAL_AGENDA);
  142. $tbl_personal_agenda = Database:: get_main_table(TABLE_PERSONAL_AGENDA);
  143. $tbl_course = Database:: get_main_table(TABLE_MAIN_COURSE);
  144. $tbl_course_user = Database:: get_main_table(TABLE_MAIN_COURSE_USER);
  145. $tbl_stats_exercices = Database:: get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
  146. $tbl_stats_exercices_temp = Database:: get_main_table(track_e_exercices_temp);
  147. $tbl_group_course_info = Database:: get_course_table(TABLE_GROUP);
  148. $course_id = api_get_course_int_id();
  149. //on trouve le vrai groupID
  150. $sql = "SELECT iid FROM ".$tbl_group_course_info."
  151. WHERE c_id=".$course_id." and id=".$current_group['id'];
  152. $current_group_result = Database::query($sql);
  153. $current_group = Database::fetch_assoc($current_group_result)['iid'];
  154. //on trouve les user dans le groupe
  155. $sql = "SELECT *
  156. FROM ".$table_user." user, ".$table_group_user." group_rel_user
  157. WHERE group_rel_user.c_id = $course_id AND group_rel_user.user_id = user.user_id
  158. AND group_rel_user.group_id = ".$current_group." order by lastname
  159. ";
  160. $result = Database::query($sql);
  161. // Francois Belisle Kezber
  162. // Le TableDisplay contient une fonction qui set les headers... les headers sont plac�s dans la Row 0... Ce qui ecrase le contenue
  163. // le la vrai row 0... Il faut donc ajouter un empty record a la row 0 qui se fera ecras� par lesh headers plutot que le premier record
  164. // en ajoutant un empty record, ca fonctionne, mais il faut trouver pourquoi les headers ecrasent le premier record
  165. $row = [];
  166. $row[] = $student_datas['official_code'];
  167. $row[] = $student_datas['lastname'];
  168. $row[] = $student_datas['firstname'];
  169. $row[] = substr_replace($exampass, '', '0', '2');
  170. $row[] = $last_connection_date;
  171. $row[] = $time_tot;
  172. $row[] = $Total;
  173. $row[] = '<center>'.$sing.''.$diff.'&nbsp;'.$Days.''.$avertissement.'</font></b></center>';
  174. $row[] = '<center><a target="_blank" href="save_diff.php?student='.$user_in_groupe.'&diff='.$ajout.''.$diff.'"><img src="'.api_get_path(
  175. WEB_IMG_PATH
  176. ).'addd.gif" border="0" /></a></center>';
  177. $row[] = '<center><a target="_blank" href="suivi_myagenda.php?user_id='.$user_in_groupe.'&action=view&view=personal&firstname='.$student_datas['firstname'].'&name='.$student_datas['lastname'].'"><img src="'.api_get_path(
  178. WEB_IMG_PATH
  179. ).'calendar_week.gif" border="0" /></a></center>';
  180. $row[] = '<center><a target="_blank" href="../mySpace/myStudents.php?student='.$user_in_groupe.'"><img src="'.api_get_path(
  181. WEB_IMG_PATH
  182. ).'2rightarrow.gif" border="0" /></a></center>';
  183. $all_datas[] = $row;
  184. foreach ($all_datas as $row) {
  185. $table->addRow($row);
  186. }
  187. while ($resulta = Database::fetch_array($result)) {
  188. $user_in_groupe = $resulta['user_id'];
  189. unset($all_datas);
  190. //on cherche les examens
  191. $sqlexam = "SELECT mod_no
  192. FROM $tbl_stats_exercices
  193. WHERE exe_user_id = '$user_in_groupe'
  194. AND c_id = 0 AND (score_ex = 'SU' || score_rep1 = 'SU' || score_rep2 ='SU')
  195. ORDER BY mod_no ASC";
  196. $resultexam = Database::query($sqlexam);
  197. while ($a_exam = Database::fetch_array($resultexam)) {
  198. $exam = "$exam - $a_exam[0]";
  199. }
  200. Database::query(
  201. "INSERT INTO $tbl_stats_exercices_temp (id, exe_user_id, mod_passed) VALUES('', '$user_in_groupe', '$exam') "
  202. );
  203. //fin de exam
  204. //on compte le nombre de m% dans l'agenda pour chaque module
  205. /*
  206. $sqljtot = "SELECT COUNT( * ) AS TOT
  207. FROM $tbl_personal_agenda
  208. WHERE user = '$user_in_groupe'
  209. And title like 'm%'
  210. ";
  211. $resultjt = Database::query($sqljtot);
  212. while($jtot = mysql_fetch_array($resultjt))
  213. {
  214. $jour_realise_tot = ($jour_realise + $jtot['TOT'])/ 2;
  215. }
  216. //fin des jour de l'agenda
  217. */
  218. $course_code = $_course['id'];
  219. $student_datas = api_get_user_info($user_in_groupe);
  220. // affichage des jours complétés dans les parcours par chaque élève
  221. //on recherche les cours où sont inscrit les user
  222. $sql2 = "SELECT c_id, user_id
  223. FROM course_rel_user
  224. WHERE user_id = '$user_in_groupe'
  225. ";
  226. $result2 = Database::query($sql2);
  227. $Total = 0;
  228. while ($a_courses = Database::fetch_array($result2)) {
  229. $Courses_code = $a_courses['c_id'];
  230. $Courses_rel_user_id = $a_courses['user_id'];
  231. //on sort le temps passé dans chaque cours
  232. $sql = "SELECT SUM(UNIX_TIMESTAMP(logout_course_date) - UNIX_TIMESTAMP(login_course_date)) as nb_seconds
  233. FROM track_e_course_access
  234. WHERE UNIX_TIMESTAMP(logout_course_date) > UNIX_TIMESTAMP(login_course_date) AND c_id = $course_id AND user_id = '$user_in_groupe'
  235. ";
  236. //echo($sql);
  237. $rs = Database::query($sql);
  238. $row2 = Database::fetch_array($rs);
  239. $nb_secondes = $row2['nb_seconds'];
  240. $time_tot1 += $nb_secondes;
  241. //convertion secondes en temps
  242. $time_tot = api_time_to_hms($time_tot1);
  243. //on sort le c_id avec le code du cours
  244. //$sql8 = "SELECT *
  245. // FROM course
  246. // WHERE id = '$Courses_code'
  247. // ";
  248. // $result8 = Database::query($sql8);
  249. // $course_code_id = Database::fetch_array($result8) ;
  250. $c_id = $Courses_code;
  251. //pours chaque cours dans lequel il est inscrit, on cherche les jours complétés
  252. $Req3 = "SELECT *
  253. FROM c_lp_view
  254. WHERE user_id = '$Courses_rel_user_id'
  255. AND c_id = '$c_id'
  256. ";
  257. $res3 = Database::query($Req3);
  258. while ($result3 = Database::fetch_array($res3)) {
  259. $lp_id = $result3['lp_id'];
  260. $lp_id_view = $result3['id'];
  261. $c_id_view = $result3['c_id'];
  262. $Req4 = "SELECT id, lp_id ,title ,item_type
  263. FROM c_lp_item
  264. WHERE lp_id = '$lp_id'
  265. AND title LIKE '(+)%'
  266. AND c_id = '$c_id_view'
  267. AND item_type = 'document'
  268. ";
  269. $res4 = Database::query($Req4);
  270. while ($resulta4 = Database::fetch_array($res4)) {
  271. $lp_item_id = $resulta4['id'];
  272. $Req5 = " SELECT Max(id)
  273. FROM c_lp_item_view
  274. WHERE lp_item_id = '$lp_item_id'
  275. AND lp_view_id = '$lp_id_view'
  276. AND c_id = '$c_id_view'
  277. AND status = 'completed'
  278. ";
  279. $res5 = Database::query($Req5);
  280. while ($resul5 = Database::fetch_array($res5)) {
  281. $max = $resul5['0'];
  282. $Req6 = "SELECT COUNT( id )
  283. FROM c_lp_item_view
  284. WHERE id = '$max'
  285. AND c_id = '$c_id_view'
  286. ";
  287. $res6 = Database::query($Req6);
  288. while ($resultat6 = Database::fetch_array($res6)) {
  289. $Total = $Total + $resultat6[0];
  290. }
  291. }
  292. }
  293. }
  294. }
  295. // fin affichage des jours complétés dans les parcours par chaque élève
  296. // on recherche les exam sauvegardé dans la table temp
  297. $sqlexamtot = "SELECT mod_passed
  298. FROM $tbl_stats_exercices_temp
  299. WHERE exe_user_id = '$user_in_groupe'";
  300. $resultexamtot = Database::query($sqlexamtot);
  301. $a_examtot = Database::fetch_array($resultexamtot);
  302. $exampass = $a_examtot['mod_passed'];
  303. //on trouve le nombre dans l'agenda selon la date d'aujourdhui
  304. //si rien n'est inscrit cette journée dans l'agenda, recule de -1
  305. unset($jour_agenda);
  306. $tour = -1;
  307. while ($jour_agenda == '') {
  308. $tour++;
  309. $date = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - $tour, date("Y")));
  310. $sql4 = "SELECT * FROM $tbl_personal_agenda
  311. WHERE user = '$user_in_groupe' AND
  312. text='Pour le calendrier, ne pas effacer'
  313. AND date like '".$date." %:%'
  314. ";
  315. $result4 = Database::query($sql4);
  316. $res4 = Database::fetch_array($result4);
  317. $jour_agenda = $res4['title'];
  318. if ($tour > 300) {
  319. break;
  320. }
  321. }
  322. //on affiche la différence
  323. $diff = $jour_agenda - $Total;
  324. if ($diff > 0) {
  325. $sing = '<b><font color=#CC0000>';
  326. } else {
  327. $sing = '<b><font color=#008000>';
  328. }
  329. if ($diff > 0) {
  330. $avertissement = get_lang('retard');
  331. } else {
  332. $avertissement = get_lang('avance');
  333. }
  334. if ($diff > 0) {
  335. $ajout = '-';
  336. } else {
  337. $ajout = '';
  338. }
  339. $diff = abs($diff);
  340. $last_connection_date = Tracking:: get_last_connection_date($user_in_groupe, true);
  341. if ($last_connection_date == '') {
  342. $last_connection_date = get_lang('NoConnexion');
  343. }
  344. // on présente tous les résultats
  345. $row = [];
  346. $row[] = $student_datas['official_code'];
  347. $row[] = $student_datas['lastname'];
  348. $row[] = $student_datas['firstname'];
  349. $row[] = substr_replace($exampass, '', '0', '2');
  350. $row[] = $last_connection_date;
  351. $row[] = $time_tot;
  352. $row[] = $Total;
  353. $row[] = '<center>'.$sing.''.$diff.'&nbsp;'.$Days.''.$avertissement.'</font></b></center>';
  354. $row[] = '<center><a target="_blank" href="save_diff.php?student='.$user_in_groupe.'&diff='.$ajout.''.$diff.'"><img src="'.api_get_path(
  355. WEB_IMG_PATH
  356. ).'addd.gif" border="0" /></a></center>';
  357. $row[] = '<center><a target="_blank" href="suivi_myagenda.php?user_id='.$user_in_groupe.'&action=view&view=personal&firstname='.$student_datas['firstname'].'&name='.$student_datas['lastname'].'"><img src="'.api_get_path(
  358. WEB_IMG_PATH
  359. ).'calendar_week.gif" border="0" /></a></center>';
  360. $row[] = '<center><a target="_blank" href="../mySpace/myStudents.php?student='.$user_in_groupe.'"><img src="'.api_get_path(
  361. WEB_IMG_PATH
  362. ).'2rightarrow.gif" border="0" /></a></center>';
  363. $all_datas[] = $row;
  364. foreach ($all_datas as $row) {
  365. $table->addRow($row);
  366. }
  367. }
  368. $table->display();
  369. echo $precision_time;
  370. /**
  371. * Return user profile link around the given user name.
  372. *
  373. * The parameters use a trick of the sorteable table, where the first param is
  374. * the original value of the column
  375. *
  376. * @param string User name (value of the column at the time of calling)
  377. * @param string URL parameters
  378. * @param array Row of the "sortable table" as it is at the time of function call - we extract the user ID from
  379. * there
  380. *
  381. * @return string HTML link
  382. */
  383. function user_name_filter($name, $url_params, $row)
  384. {
  385. $tab_user_info = api_get_user_info($row[0]);
  386. $username = api_htmlentities(sprintf(get_lang('LoginX'), $tab_user_info['username']), ENT_QUOTES);
  387. return '<a href="../user/userInfo.php?uInfo='.$row[0].'&amp;'.$url_params.'" title="'.$username.'">'.$name.'</a>';
  388. }
  389. // Footer
  390. $orig = isset($origin) ? $origin : '';
  391. if ($orig != 'learnpath') {
  392. Display::display_footer();
  393. }