index.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Session view
  5. * @package chamilo.session
  6. * @author Julio Montoya <gugli100@gmail.com> Beeznest
  7. */
  8. // Language files that should be included.
  9. $language_file = array('courses', 'index','tracking','exercice', 'admin');
  10. $cidReset = true;
  11. require_once '../inc/global.inc.php';
  12. $libpath = api_get_path(LIBRARY_PATH);
  13. require_once $libpath.'course.lib.php';
  14. //require_once $libpath.'usermanager.lib.php';
  15. require_once $libpath.'sessionmanager.lib.php';
  16. require_once $libpath.'usermanager.lib.php';
  17. require_once $libpath.'formvalidator/FormValidator.class.php';
  18. require_once $libpath.'tracking.lib.php';
  19. require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpathList.class.php';
  20. require_once api_get_path(SYS_CODE_PATH).'exercice/exercise.lib.php';
  21. require_once api_get_path(SYS_CODE_PATH).'exercice/exercise.class.php';
  22. api_block_anonymous_users(); // Only users who are logged in can proceed.
  23. $this_section = SECTION_COURSES;
  24. $htmlHeadXtra[] = api_get_jquery_ui_js(true);
  25. //$interbreadcrumb[] = array ('url' => '#', 'name' => get_lang('Course'));
  26. Display::display_header(get_lang('Session'));
  27. $session_id = intval($_GET['session_id']);
  28. $course_id = intval($_GET['course_id']);
  29. if (empty($session_id)) {
  30. api_not_allowed();
  31. }
  32. $session_info = SessionManager::fetch($session_id);
  33. $session_list = SessionManager::get_sessions_by_coach(api_get_user_id());
  34. $course_list = SessionManager::get_course_list_by_session_id($session_id);
  35. $session_select = array();
  36. foreach ($session_list as $item) {
  37. $session_select[$item['id']] = $item['name'];
  38. }
  39. // Session list form
  40. if (count($session_select) > 1) {
  41. $form = new FormValidator('exercise_admin', 'get', api_get_self().'?session_id='.$session_id);
  42. $form->addElement('select', 'session_id', get_lang('SessionList'), $session_select, 'onchange="javascript:change_session()"');
  43. $defaults['session_id'] = $session_id;
  44. $form->setDefaults($defaults);
  45. $form->display();
  46. }
  47. //Listing LPs from all courses
  48. /*
  49. $lps = array();
  50. if (!empty($course_list)) {
  51. foreach ($course_list as $item) {
  52. $list = new LearnpathList(api_get_user_id(),$item['code']);
  53. $flat_list = $list->get_flat_list();
  54. $lps[$item['code']] = $flat_list;
  55. foreach ($flat_list as $item) {
  56. //var_dump(get_week_from_day($item['publicated_on']));
  57. }
  58. }
  59. }*/
  60. //Getting all sessions where I'm subscribed
  61. $new_session_list = UserManager::get_personal_session_course_list(api_get_user_id());
  62. $my_session_list = array();
  63. $final_array = array();
  64. if (!empty($new_session_list)) {
  65. foreach($new_session_list as $item) {
  66. $my_session_id = $item['id_session'];
  67. if (isset($my_session_id) && !in_array($my_session_id, $my_session_list) && $session_id == $my_session_id) {
  68. $final_array[$my_session_id]['name'] = $item['session_name'];
  69. //Get all courses by session where I'm subscribed
  70. $my_course_list = UserManager::get_courses_list_by_session(api_get_user_id(), $my_session_id);
  71. foreach ($my_course_list as $my_course) {
  72. $course = array();
  73. $course_info = api_get_course_info($my_course['code']);
  74. //Getting all exercises from the current course
  75. $exercise_list = get_all_exercises($course_info, $my_session_id);
  76. //Exercises we skip
  77. /*if (empty($exercise_list)) {
  78. continue;
  79. } */
  80. //$exercise_course_list = array();
  81. $course['name'] = $course_info['name'];
  82. $course['id'] = $course_info['real_id'];
  83. if (!empty($exercise_list)) {
  84. foreach($exercise_list as $exercise_item) {
  85. //Loading the exercise
  86. $exercise = new Exercise($course_info['real_id']);
  87. $exercise->read($exercise_item['id']);
  88. //$exercise_course_list[$exercise_item['id']] = $exercise;
  89. //Reading all Exercise results by user, exercise_id, code, and session
  90. $user_results = get_all_exercise_results_by_user(api_get_user_id(), $exercise_item['id'], $my_course['code'], $my_session_id);
  91. $course['exercises'][$exercise_item['id']]['data']['exercise_data'] = $exercise;
  92. $course['exercises'][$exercise_item['id']]['data']['results'] = $user_results;
  93. }
  94. $final_array[$my_session_id]['data'][$my_course['code']] = $course;
  95. }
  96. }
  97. }
  98. $my_session_list[] = $my_session_id;
  99. }
  100. }
  101. //echo '<pre>';print_r($final_array);
  102. //If the requested session does not exist in my list we stop the script
  103. if (!api_is_platform_admin()) {
  104. if (!in_array($session_id, $my_session_list)) {
  105. api_not_allowed();
  106. }
  107. }
  108. //require_once api_get_path(LIBRARY_PATH).'pear/HTML/Table.php';
  109. //$html = '';
  110. //Final data to be show
  111. $my_real_array = $new_exercises = array();
  112. $now = time();
  113. foreach($final_array as $session_data) {
  114. $my_course_list = $session_data['data'];
  115. if (!empty($my_course_list))
  116. foreach ($my_course_list as $my_course_code=>$course_data) {
  117. //echo '<pre>'; print_r($course_data);
  118. if (isset($course_id) && !empty($course_id)) {
  119. if ($course_id != $course_data['id']) {
  120. continue;
  121. }
  122. }
  123. if (!empty($course_data['exercises'])) {
  124. //Exercises
  125. foreach ($course_data['exercises'] as $my_exercise_id => $exercise_data) {
  126. $best_score_data = get_best_attempt_in_course($my_exercise_id, $my_course_code, $session_id);
  127. $best_score = show_score($best_score_data['exe_result'], $best_score_data['exe_weighting']);
  128. //Exercise results
  129. $counter = 1;
  130. foreach($exercise_data as $exercise_item) {
  131. $result_list = $exercise_item['results'];
  132. $exercise_info = $exercise_item['exercise_data'];
  133. if ($exercise_info->start_time == '0000-00-00 00:00:00') {
  134. $start_date = '-';
  135. } else {
  136. $start_date = api_get_local_time($exercise_info->start_time);
  137. }
  138. if (!empty($result_list)) {
  139. foreach ($result_list as $exercise_result) {
  140. //$my_exercise_result = array($exercise_info->exercise, $exercise_result['exe_id']);
  141. $column = 1;
  142. $platform_score = show_score($exercise_result['exe_result'], $exercise_result['exe_weighting']);
  143. $my_score = 0;
  144. if(!empty($exercise_result['exe_weighting']) && intval($exercise_result['exe_weighting']) != 0) {
  145. $my_score = $exercise_result['exe_result']/$exercise_result['exe_weighting'];
  146. }
  147. $position = get_exercise_result_ranking($my_score, $exercise_result['exe_id'], $my_exercise_id, $my_course_code,$session_id);
  148. $my_real_array[]= array( //'date' => api_get_local_time($exercise_result['exe_date']),
  149. 'status' => Display::return_icon('quiz.gif', get_lang('Attempted'),'','22'),
  150. 'date' => $start_date,
  151. 'course' => $course_data['name'],
  152. 'exercise' => $exercise_info->exercise,
  153. 'attempt' => $counter,
  154. 'result' => $platform_score,
  155. 'best_result' => $best_score,
  156. 'position' => $position
  157. );
  158. $counter++;
  159. }
  160. } else {
  161. //We check the date validation of the exercise if the user can make it
  162. if ($exercise_info->start_time != '0000-00-00 00:00:00') {
  163. $allowed_time = api_strtotime($exercise_info->start_time);
  164. if ($now < $allowed_time) {
  165. continue;
  166. }
  167. }
  168. $exercise_info->exercise = Display::url($exercise_info->exercise, api_get_path(WEB_CODE_PATH)."exercice/exercice_submit.php?cidReq=$my_course_code&exerciseId={$exercise_info->id}&id_session=$session_id", array('target'=>SESSION_LINK_TARGET));
  169. $new_exercises[]= array( //'date' => api_get_local_time($exercise_result['exe_date']),
  170. 'status' => Display::return_icon('star.png', get_lang('New'), array('width'=>'22')),
  171. 'date' => $start_date,
  172. 'course' => $course_data['name'],
  173. 'exercise' => $exercise_info->exercise,
  174. 'attempt' => '-',
  175. 'result' => '-',
  176. 'best_result' => '-',
  177. 'position' => '-'
  178. );
  179. }
  180. }
  181. }
  182. }
  183. }
  184. }
  185. $my_real_array = msort($my_real_array, 'date','asc');
  186. if (!empty($new_exercises)) {
  187. $my_real_array = array_merge($new_exercises, $my_real_array);
  188. }
  189. $back_url = '';
  190. if (!empty($course_id)) {
  191. $back_url = Display::url(Display::return_icon('back.png',get_lang('back.png')), api_get_path(WEB_CODE_PATH).'session/?session_id='.$session_id);
  192. }
  193. $start = $end = '';
  194. if (!empty($session_info['date_start']) && $session_info['date_start'] != '0000-00-00') {
  195. $start = api_convert_and_format_date($session_info['date_start'], DATE_FORMAT_SHORT);
  196. $start_only = get_lang('From').' '.$session_info['date_start'];
  197. }
  198. if (!empty($session_info['date_start']) && $session_info['date_end'] != '0000-00-00') {
  199. $end = api_convert_and_format_date($session_info['date_end'], DATE_FORMAT_SHORT);
  200. $end_only = get_lang('Until').' '.$session_info['date_end'];
  201. }
  202. if (!empty($start) && !empty($end)) {
  203. $dates = Display::tag('i', sprintf(get_lang('FromDateXToDateY'),$start, $end));
  204. } else {
  205. $dates = Display::tag('i', $start_only.' '.$end_only);
  206. }
  207. echo Display::tag('h1', $back_url.' '.$session_info['name']);
  208. echo $dates.'<br />';
  209. //echo '<pre>';print_r($course_list);
  210. $new_course_list = array();
  211. if (!empty($course_list)) {
  212. foreach($course_list as $course_data) {
  213. $course_data['title'] = Display::url($course_data['title'], api_get_path(WEB_CODE_PATH).'session/?session_id='.$session_id.'&course_id='.$course_data['id'].'#tabs-2');
  214. $new_course_list[] = array('title'=>$course_data['title']);
  215. }
  216. }
  217. //All Learnpaths grid settings (First tab, first subtab)
  218. $columns_courses = array(get_lang('Title'));
  219. $column_model_courses = array(array('name'=>'title', 'index'=>'title', 'width'=>'150', 'align'=>'left', 'sortable'=>'false'),
  220. );
  221. $extra_params_courses['autowidth'] = 'true'; //use the width of the parent
  222. $url = api_get_path(WEB_AJAX_PATH).'course_home.ajax.php?a=session_courses_lp_default&session_id='.$session_id.'&course_id='.$course_id;
  223. $columns = array(get_lang('PublicationDate'),get_lang('Course'), get_lang('LearningPath'));
  224. $column_model = array(array('name'=>'date', 'index'=>'date', 'width'=>'150', 'align'=>'left', 'sortable'=>'false'),
  225. array('name'=>'course', 'index'=>'course', 'width'=>'400', 'align'=>'left', 'sortable'=>'false'),
  226. array('name'=>'lp', 'index'=>'lp', 'width'=>'200', 'align'=>'center','sortable'=>'false'));
  227. //$extra_params['autowidth'] = 'true'; //use the width of the parent
  228. //$extra_params['forceFit'] = 'true'; //use the width of the parent
  229. //$extra_params['altRows'] = 'true'; //zebra style
  230. //Per course grid settings
  231. $url_by_course = api_get_path(WEB_AJAX_PATH).'course_home.ajax.php?a=session_courses_lp_by_course&session_id='.$session_id.'&course_id='.$course_id;
  232. $extra_params_course['grouping'] = 'true';
  233. $extra_params_course['groupingView'] = array('groupField' => array('course'),
  234. 'groupColumnShow' => array('false'),
  235. 'groupText' => array('<b>'.get_lang('Course').' {0}</b>'));
  236. //$extra_params_course['autowidth'] = 'true'; //use the width of the parent
  237. //Per Week grid
  238. $url_week = api_get_path(WEB_AJAX_PATH).'course_home.ajax.php?a=session_courses_lp_by_week&session_id='.$session_id.'&course_id='.$course_id;
  239. $column_week = array(get_lang('PeriodWeek'), get_lang('PublicationDate'), get_lang('Course'), get_lang('LearningPath'));
  240. $column_week_model = array (
  241. array('name'=>'week', 'index'=>'week', 'width'=>'80', 'align'=>'left', 'sortable'=>'false'),
  242. array('name'=>'date', 'index'=>'date', 'width'=>'150', 'align'=>'left', 'sortable'=>'false'),
  243. array('name'=>'course', 'index'=>'course', 'width'=>'400', 'align'=>'left', 'sortable'=>'false'),
  244. array('name'=>'lp', 'index'=>'lp', 'width'=>'200', 'align'=>'center','sortable'=>'false'));
  245. $extra_params_week['grouping'] = 'true';
  246. //For more details see http://www.trirand.com/jqgridwiki/doku.php?id=wiki:grouping
  247. $extra_params_week['groupingView'] = array('groupDataSorted' =>true,
  248. 'groupField'=>array('week'),
  249. 'groupColumnShow'=>'false',
  250. 'groupText' => array('<b>'.get_lang('PeriodWeek').' {0}</b>'));
  251. //$extra_params_week['autowidth'] = 'true'; //use the width of the parent
  252. //MyQCM grid
  253. $column_exercise = array(get_lang('Status'), get_lang('ExerciseStartDate'), get_lang('Course'), get_lang('Exercise'),get_lang('Attempts'), get_lang('Result'), get_lang('BestResultInCourse'), get_lang('Ranking'));
  254. $column_exercise_model = array(
  255. array('name'=>'status', 'index'=>'status', 'width'=>'50', 'align'=>'left', 'sortable'=>'true'),
  256. array('name'=>'date', 'index'=>'date', 'width'=>'130','align'=>'left', 'sortable'=>'true'),
  257. array('name'=>'course', 'index'=>'course', 'width'=>'200','align'=>'left', 'sortable'=>'true'),
  258. array('name'=>'exercise', 'index'=>'exercise', 'width'=>'200','align'=>'left', 'sortable'=>'true'),
  259. array('name'=>'attempt', 'index'=>'attempt', 'width'=>'60', 'align'=>'center', 'sortable'=>'true'),
  260. array('name'=>'result', 'index'=>'result', 'width'=>'120','align'=>'center', 'sortable'=>'true'),
  261. array('name'=>'best_result','index'=>'best_result','width'=>'140','align'=>'center', 'sortable'=>'true'),
  262. array('name'=>'position', 'index'=>'position', 'width'=>'55', 'align'=>'center', 'sortable'=>'true')
  263. );
  264. $extra_params_exercise['height'] = '300';
  265. //$extra_params_exercise['sortname'] = 'status';
  266. //$extra_params_exercise['sortorder'] = 'desc';
  267. //$extra_params_exercise['grouping'] = 'true';
  268. //$extra_params_exercise['groupingView'] = array('groupField'=>array('course'),'groupColumnShow'=>'false','groupText' => array('<b>'.get_lang('Course').' {0}</b>'));
  269. //$extra_params_exercise['groupingView'] = array('groupField'=>array('course'),'groupColumnShow'=>'false','groupText' => array('<b>'.get_lang('Course').' {0} - {1} Item(s)</b>'));
  270. ?>
  271. <br />
  272. <script>
  273. function change_session() {
  274. document.exercise_admin.submit();
  275. }
  276. $(function() {
  277. //js used when generating images on the fly see function Tracking::show_course_detail()
  278. $(".dialog").dialog("destroy");
  279. $(".dialog").dialog({
  280. autoOpen: false,
  281. show: "blind",
  282. resizable: false,
  283. height:300,
  284. width:550,
  285. modal: true
  286. });
  287. $(".opener").click(function() {
  288. var my_id = $(this).attr('id');
  289. var big_image = '#main_graph_' + my_id;
  290. $( big_image ).dialog("open");
  291. return false;
  292. });
  293. /* Binds a tab id in the url */
  294. $("#tabs").bind('tabsselect', function(event, ui) {
  295. window.location.href=ui.tab;
  296. });
  297. //Generate tabs with jquery-ui
  298. $('#tabs').tabs();
  299. $( "#sub_tab" ).tabs();
  300. <?php
  301. //Displays js code to use a jqgrid
  302. echo Display::grid_js('courses', '', $columns_courses,$column_model_courses,$extra_params_courses,$new_course_list);
  303. echo Display::grid_js('list_default', $url, $columns, $column_model,$extra_params,array(), '');
  304. echo Display::grid_js('list_course', $url_by_course, $columns, $column_model,$extra_params_course,array(),'');
  305. echo Display::grid_js('list_week', $url_week, $column_week, $column_week_model, $extra_params_week,array(),'');
  306. echo Display::grid_js('exercises', '', $column_exercise,$column_exercise_model, $extra_params_exercise, $my_real_array);
  307. ?>
  308. });
  309. </script>
  310. <?php
  311. $my_reporting = Tracking::show_user_progress(api_get_user_id(), $session_id, '&session_id='.$session_id.'#tabs-4', false);
  312. $my_reporting .= '<br />'.Tracking::show_course_detail(api_get_user_id(), $_GET['course'], $_GET['session_id']);
  313. //Main headers
  314. $headers = array(get_lang('Courses'), get_lang('LearningPaths'), get_lang('MyQCM'), get_lang('MyStatistics'));
  315. //Subheaders
  316. $sub_header = array(get_lang('AllLearningPaths'), get_lang('PerWeek'), get_lang('ByCourse'));
  317. //Sub headers data
  318. $lp_tabs = Display::tabs($sub_header, array(Display::grid_html('list_default'), Display::grid_html('list_week'), Display::grid_html('list_course')),'sub_tab');
  319. $courses_tab = Display::grid_html('courses');
  320. //Main headers data
  321. echo Display::tabs($headers, array($courses_tab, $lp_tabs, Display::grid_html('exercises'), $my_reporting));
  322. Display::display_footer();