user_portal.php 44 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211
  1. <?php
  2. // $Id: user_portal.php,v 1.10 2006/08/19 09:33:14 yannoo Exp $
  3. /*
  4. ==============================================================================
  5. Dokeos - elearning and course management software
  6. Copyright (c) 2004-2005 Dokeos S.A.
  7. Copyright (c) 2003 Ghent University (UGent)
  8. Copyright (c) 2001 Universite catholique de Louvain (UCL)
  9. Copyright (c) various contributors
  10. For a full list of contributors, see "credits.txt".
  11. The full license can be read in "license.txt".
  12. This program is free software; you can redistribute it and/or
  13. modify it under the terms of the GNU General Public License
  14. as published by the Free Software Foundation; either version 2
  15. of the License, or (at your option) any later version.
  16. See the GNU General Public License for more details.
  17. Contact address: Dokeos, 44 rue des palais, B-1030 Brussels, Belgium
  18. Mail: info@dokeos.com
  19. ==============================================================================
  20. */
  21. /**
  22. ==============================================================================
  23. * This is the index file displayed when a user is logged in on Dokeos.
  24. *
  25. * It displays:
  26. * - personal course list
  27. * - menu bar
  28. *
  29. * Part of the what's new ideas were based on a rene haentjens hack
  30. *
  31. * Search for
  32. * CONFIGURATION parameters
  33. * to modify settings
  34. *
  35. * @todo rewrite code to separate display, logic, database code
  36. * @package dokeos.main
  37. ==============================================================================
  38. */
  39. /**
  40. * @todo shouldn't the SCRIPTVAL_ and CONFVAL_ constant be moved to the config page? Has anybody any idea what the are used for?
  41. * if these are really configuration settings then we can add those to the dokeos config settings
  42. * @todo move get_personal_course_list and some other functions to a more appripriate place course.lib.php or user.lib.php
  43. * @todo use api_get_path instead of $rootAdminWeb
  44. * @todo check for duplication of functions with index.php (user_portal.php is orginally a copy of index.php)
  45. * @todo display_digest, shouldn't this be removed and be made into an extension?
  46. */
  47. /*
  48. ==============================================================================
  49. INIT SECTION
  50. ==============================================================================
  51. */
  52. // Don't change these settings
  53. define('SCRIPTVAL_No', 0);
  54. define('SCRIPTVAL_InCourseList', 1);
  55. define('SCRIPTVAL_UnderCourseList', 2);
  56. define('SCRIPTVAL_Both', 3);
  57. define('SCRIPTVAL_NewEntriesOfTheDay', 4);
  58. define('SCRIPTVAL_NewEntriesOfTheDayOfLastLogin', 5);
  59. define('SCRIPTVAL_NoTimeLimit', 6);
  60. // End 'don't change' section
  61. $langFile = array ('courses', 'index');
  62. $cidReset = true; /* Flag forcing the 'current course' reset,
  63. as we're not inside a course anymore */
  64. /*
  65. -----------------------------------------------------------
  66. Included libraries
  67. -----------------------------------------------------------
  68. */
  69. include_once ('./main/inc/global.inc.php');
  70. include_once (api_get_path(LIBRARY_PATH).'course.lib.php');
  71. include_once (api_get_path(LIBRARY_PATH).'debug.lib.inc.php');
  72. include_once (api_get_path(LIBRARY_PATH).'system_announcements.lib.php');
  73. include_once (api_get_path(LIBRARY_PATH).'groupmanager.lib.php');
  74. api_block_anonymous_users(); // only users who are logged in can proceed
  75. /*
  76. -----------------------------------------------------------
  77. Table definitions
  78. -----------------------------------------------------------
  79. */
  80. //Database table definitions
  81. $main_user_table = Database :: get_main_table(TABLE_MAIN_USER);
  82. $main_admin_table = Database :: get_main_table(TABLE_MAIN_ADMIN);
  83. $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  84. $main_course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  85. $main_category_table = Database :: get_main_table(TABLE_MAIN_CATEGORY);
  86. /*
  87. -----------------------------------------------------------
  88. Constants and CONFIGURATION parameters
  89. -----------------------------------------------------------
  90. */
  91. // ---- Course list options ----
  92. define('CONFVAL_showCourseLangIfNotSameThatPlatform', TRUE);
  93. // Preview of course content
  94. // to disable all: set CONFVAL_maxTotalByCourse = 0
  95. // to enable all: set e.g. CONFVAL_maxTotalByCourse = 5
  96. // by default disabled since what's new icons are better (see function display_digest() )
  97. define('CONFVAL_maxValvasByCourse', 2); // Maximum number of entries
  98. define('CONFVAL_maxAgendaByCourse', 2); // collected from each course
  99. define('CONFVAL_maxTotalByCourse', 0); // and displayed in summary.
  100. define('CONFVAL_NB_CHAR_FROM_CONTENT', 80);
  101. // Order to sort data
  102. $orderKey = array('keyTools', 'keyTime', 'keyCourse'); // default "best" Choice
  103. //$orderKey = array('keyTools', 'keyCourse', 'keyTime');
  104. //$orderKey = array('keyCourse', 'keyTime', 'keyTools');
  105. //$orderKey = array('keyCourse', 'keyTools', 'keyTime');
  106. define('CONFVAL_showExtractInfo', SCRIPTVAL_UnderCourseList);
  107. // SCRIPTVAL_InCourseList // best choice if $orderKey[0] == 'keyCourse'
  108. // SCRIPTVAL_UnderCourseList // best choice
  109. // SCRIPTVAL_Both // probably only for debug
  110. //define('CONFVAL_dateFormatForInfosFromCourses', get_lang('dateFormatShort'));
  111. define('CONFVAL_dateFormatForInfosFromCourses', get_lang('dateFormatLong'));
  112. //define("CONFVAL_limitPreviewTo",SCRIPTVAL_NewEntriesOfTheDay);
  113. //define("CONFVAL_limitPreviewTo",SCRIPTVAL_NoTimeLimit);
  114. define("CONFVAL_limitPreviewTo", SCRIPTVAL_NewEntriesOfTheDayOfLastLogin);
  115. if(api_is_allowed_to_create_course() && !isset($_GET['sessionview'])){
  116. $nosession = true;
  117. }
  118. else {
  119. $nosession = false;
  120. }
  121. if(api_get_setting('use_session_mode')=='true' && !$nosession)
  122. {
  123. if (isset($_GET['inactives'])){
  124. $display_actives = false;
  125. }
  126. else {
  127. $display_actives = true;
  128. }
  129. }
  130. $nameTools = get_lang('MyCourses');
  131. $this_section = SECTION_COURSES;
  132. /*
  133. -----------------------------------------------------------
  134. Check configuration parameters integrity
  135. -----------------------------------------------------------
  136. */
  137. if (CONFVAL_showExtractInfo != SCRIPTVAL_UnderCourseList and $orderKey[0] != "keyCourse")
  138. {
  139. // CONFVAL_showExtractInfo must be SCRIPTVAL_UnderCourseList to accept $orderKey[0] !="keyCourse"
  140. if (DEBUG || api_is_platform_admin()) // Show bug if admin. Else force a new order
  141. die('
  142. <strong>config error:'.__FILE__.'</strong><br />
  143. set
  144. <ul>
  145. <li>
  146. CONFVAL_showExtractInfo = SCRIPTVAL_UnderCourseList
  147. (actually : '.CONFVAL_showExtractInfo.')
  148. </li>
  149. </ul>
  150. or
  151. <ul>
  152. <li>
  153. $orderKey[0] != "keyCourse"
  154. (actually : '.$orderKey[0].')
  155. </li>
  156. </ul>');
  157. else
  158. {
  159. $orderKey = array ('keyCourse', 'keyTools', 'keyTime');
  160. }
  161. }
  162. /*
  163. -----------------------------------------------------------
  164. Header
  165. include the HTTP, HTML headers plus the top banner
  166. -----------------------------------------------------------
  167. */
  168. Display :: display_header($nameTools);
  169. /*
  170. ==============================================================================
  171. FUNCTIONS
  172. display_admin_links()
  173. display_create_course_link()
  174. display_edit_course_list_links()
  175. display_digest($toolsList, $digest, $orderKey, $courses)
  176. show_notification($my_course)
  177. get_personal_course_list($user_id)
  178. get_logged_user_course_html($my_course)
  179. get_user_course_categories()
  180. ==============================================================================
  181. */
  182. /*
  183. -----------------------------------------------------------
  184. Database functions
  185. some of these can go to database layer.
  186. -----------------------------------------------------------
  187. */
  188. /**
  189. * Database function that gets the list of courses for a particular user.
  190. * @param $user_id, the id of the user
  191. * @return an array with courses
  192. */
  193. function get_personal_course_list($user_id)
  194. {
  195. // initialisation
  196. $personal_course_list = array();
  197. // table definitions
  198. $main_user_table = Database :: get_main_table(TABLE_MAIN_USER);
  199. $main_course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  200. $main_course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  201. $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  202. $tbl_session_course_user= Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  203. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  204. $personal_course_list = array ();
  205. $personal_course_list_sql = "SELECT course.code k, course.directory d, course.visual_code c, course.db_name db, course.title i,
  206. course.tutor_name t, course.course_language l, course_rel_user.status s, course_rel_user.sort sort,
  207. course_rel_user.user_course_cat user_course_cat
  208. FROM ".$main_course_table." course,".$main_course_user_table." course_rel_user
  209. WHERE course.code = course_rel_user.course_code"."
  210. AND course_rel_user.user_id = '".$user_id."'
  211. ORDER BY course_rel_user.user_course_cat, course_rel_user.sort ASC,course.title,course.code";
  212. $course_list_sql_result = api_sql_query($personal_course_list_sql, __FILE__, __LINE__);
  213. while ($result_row = mysql_fetch_array($course_list_sql_result))
  214. {
  215. $personal_course_list[] = $result_row;
  216. }
  217. //$personal_course_list = array_merge($personal_course_list, $course_list_sql_result);
  218. $personal_course_list_sql = "SELECT DISTINCT course.code k, course.directory d, course.visual_code c, course.db_name db, course.title i, course.tutor_name t, course.course_language l, 5 as s
  219. FROM $main_course_table as course, $tbl_session_course_user as srcru
  220. WHERE srcru.course_code=course.code AND srcru.id_user='$user_id'";
  221. $course_list_sql_result = api_sql_query($personal_course_list_sql, __FILE__, __LINE__);
  222. while ($result_row = mysql_fetch_array($course_list_sql_result))
  223. {
  224. $personal_course_list[] = $result_row;
  225. }
  226. //$personal_course_list = array_merge($personal_course_list, $course_list_sql_result);
  227. $personal_course_list_sql = "SELECT DISTINCT course.code k, course.directory d, course.visual_code c, course.db_name db, course.title i, course.tutor_name t, course.course_language l, 2 as s
  228. FROM $main_course_table as course, $tbl_session_course as src, $tbl_session as session
  229. WHERE session.id_coach='$user_id' AND session.id=src.id_session AND src.course_code=course.code";
  230. $course_list_sql_result = api_sql_query($personal_course_list_sql, __FILE__, __LINE__);
  231. //$personal_course_list = array_merge($personal_course_list, $course_list_sql_result);
  232. while ($result_row = mysql_fetch_array($course_list_sql_result))
  233. {
  234. $personal_course_list[] = $result_row;
  235. }
  236. return $personal_course_list;
  237. }
  238. /**
  239. * Enter description here...
  240. *
  241. * @param unknown_type $user_id
  242. * @param unknown_type $list_sessions
  243. * @return unknown
  244. *
  245. */
  246. function get_personal_session_course_list($user_id, $list_sessions)
  247. {
  248. // Database Table Definitions
  249. $tbl_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  250. $tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
  251. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  252. $tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  253. $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);
  254. $tbl_session_course_user = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  255. $tbl_session_rel_user = Database :: get_main_table(TABLE_MAIN_SESSION_USER);
  256. // variable initialisation
  257. $personal_course_list_sql = '';
  258. $personal_course_list = array();
  259. // get the list of sessions where the user is subscribed as student
  260. $result=api_sql_query("SELECT DISTINCT id, name, date_start, date_end, 5 as s
  261. FROM session_rel_user, session
  262. WHERE id_session=id AND id_user=$user_id ORDER BY date_start, date_end, name",__FILE__,__LINE__);
  263. $Sessions=api_store_result($result);
  264. $Sessions = array_merge($Sessions , api_store_result($result));
  265. // get the list of sessions where the user is subscribed as coach in a course
  266. $result=api_sql_query("SELECT DISTINCT id, name, date_start, date_end, 2 as s
  267. FROM $tbl_session as session
  268. INNER JOIN $tbl_session_course as session_rel_course
  269. ON session_rel_course.id_coach = $user_id
  270. ORDER BY date_start, date_end, name",__FILE__,__LINE__);
  271. //global $sessionIsCoach;
  272. $sessionIsCoach = api_store_result($result);
  273. $Sessions = array_merge($Sessions , $sessionIsCoach);
  274. // get the list of sessions where the user is subscribed as coach
  275. $result=api_sql_query("SELECT DISTINCT id, name, date_start, date_end, 2 as s
  276. FROM $tbl_session as session
  277. WHERE session.id_coach = $user_id
  278. ORDER BY date_start, date_end, name",__FILE__,__LINE__);
  279. $Sessions = array_merge($Sessions , api_store_result($result));
  280. if(api_is_allowed_to_create_course())
  281. {
  282. foreach($Sessions as $enreg)
  283. {
  284. $id_session = $enreg['id'];
  285. $personal_course_list_sql = "SELECT DISTINCT course.code k, course.directory d, course.visual_code c, course.db_name db, course.title i, CONCAT(user.lastname,' ',user.firstname) t, email, course.course_language l, 1 sort, category_code user_course_cat, date_start, date_end, session.id as id_session, session.name as session_name
  286. FROM $tbl_session_course as session_course
  287. INNER JOIN $tbl_course AS course
  288. ON course.code = session_course.course_code
  289. INNER JOIN $tbl_session as session
  290. ON session.id = session_course.id_session
  291. LEFT JOIN $tbl_user as user
  292. ON user.user_id = session_course.id_coach
  293. WHERE session_course.id_session = $id_session
  294. AND (session_course.id_coach=$user_id OR session.id_coach=$user_id)
  295. ORDER BY i";
  296. $course_list_sql_result = api_sql_query($personal_course_list_sql, __FILE__, __LINE__);
  297. while ($result_row = mysql_fetch_array($course_list_sql_result))
  298. {
  299. $result_row['s'] = 2;
  300. $key = $result_row['id_session'].' - '.$result_row['k'];
  301. $personal_course_list[$key] = $result_row;
  302. }
  303. }
  304. }
  305. foreach($Sessions as $enreg)
  306. {
  307. $id_session = $enreg['id'];
  308. $personal_course_list_sql = "SELECT DISTINCT course.code k, course.directory d, course.visual_code c, course.db_name db, course.title i, CONCAT(user.lastname,' ',user.firstname) t, email, course.course_language l, 1 sort, category_code user_course_cat, date_start, date_end, session.id as id_session, session.name as session_name
  309. FROM $tbl_session_course as session_course
  310. INNER JOIN $tbl_course AS course
  311. ON course.code = session_course.course_code
  312. LEFT JOIN $tbl_user as user
  313. ON user.user_id = session_course.id_coach
  314. INNER JOIN $tbl_session_course_user
  315. ON $tbl_session_course_user.id_session = $id_session
  316. AND $tbl_session_course_user.id_user = $user_id
  317. INNER JOIN $tbl_session as session
  318. ON session_course.id_session = session.id
  319. WHERE session_course.id_session = $id_session
  320. ORDER BY i";
  321. $course_list_sql_result = api_sql_query($personal_course_list_sql, __FILE__, __LINE__);
  322. while ($result_row = mysql_fetch_array($course_list_sql_result))
  323. {
  324. $key = $result_row['id_session'].' - '.$result_row['k'];
  325. $result_row['s'] = $enreg['s'];
  326. if(!isset($personal_course_list[$key]))
  327. {
  328. $personal_course_list[$key] = $result_row;
  329. }
  330. }
  331. }
  332. return $personal_course_list;
  333. }
  334. /*
  335. -----------------------------------------------------------
  336. Display functions
  337. -----------------------------------------------------------
  338. */
  339. /**
  340. * Warning: this function defines a global.
  341. * @todo use the correct get_path function
  342. */
  343. function display_admin_links()
  344. {
  345. global $rootAdminWeb;
  346. echo "<li><a href=\"".$rootAdminWeb."\">".get_lang("PlatformAdmin")."</a></li>";
  347. }
  348. /**
  349. * Enter description here...
  350. *
  351. */
  352. function display_create_course_link()
  353. {
  354. echo "<li><a href=\"main/create_course/add_course.php\">".get_lang("CourseCreate")."</a></li>";
  355. }
  356. /**
  357. * Enter description here...
  358. *
  359. */
  360. function display_edit_course_list_links()
  361. {
  362. echo "<li><a href=\"main/auth/courses.php\">".get_lang("CourseManagement")."</a></li>";
  363. }
  364. /**
  365. * Displays a digest e.g. short summary of new agenda and announcements items.
  366. * This used to be displayed in the right hand menu, but is now
  367. * disabled by default (see config settings in this file) because most people like
  368. * the what's new icons better.
  369. *
  370. * @version 1.0
  371. */
  372. function display_digest($toolsList, $digest, $orderKey, $courses)
  373. {
  374. if (is_array($digest) && (CONFVAL_showExtractInfo == SCRIPTVAL_UnderCourseList || CONFVAL_showExtractInfo == SCRIPTVAL_Both))
  375. {
  376. // // // LEVEL 1 // // //
  377. reset($digest);
  378. echo "<br/><br/>\n";
  379. while (list ($key1) = each($digest))
  380. {
  381. if (is_array($digest[$key1]))
  382. {
  383. // // // Title of LEVEL 1 // // //
  384. echo "<b>\n";
  385. if ($orderKey[0] == 'keyTools')
  386. {
  387. $tools = $key1;
  388. echo $toolsList[$key1][name];
  389. }
  390. elseif ($orderKey[0] == 'keyCourse')
  391. {
  392. $courseSysCode = $key1;
  393. echo "<a href=\"", api_get_path(WEB_COURSE_PATH), $courses[$key1][coursePath], "\">", $courses[$key1][courseCode], "</a>\n";
  394. }
  395. elseif ($orderKey[0] == 'keyTime')
  396. {
  397. echo format_locale_date(CONFVAL_dateFormatForInfosFromCourses, strtotime($digest[$key1]));
  398. }
  399. echo "</b>\n";
  400. // // // End Of Title of LEVEL 1 // // //
  401. // // // LEVEL 2 // // //
  402. reset($digest[$key1]);
  403. while (list ($key2) = each($digest[$key1]))
  404. {
  405. // // // Title of LEVEL 2 // // //
  406. echo "<p>\n", "\n";
  407. if ($orderKey[1] == 'keyTools')
  408. {
  409. $tools = $key2;
  410. echo $toolsList[$key2][name];
  411. }
  412. elseif ($orderKey[1] == 'keyCourse')
  413. {
  414. $courseSysCode = $key2;
  415. echo "<a href=\"", api_get_path(WEB_COURSE_PATH), $courses[$key2]['coursePath'], "\">", $courses[$key2]['courseCode'], "</a>\n";
  416. }
  417. elseif ($orderKey[1] == 'keyTime')
  418. {
  419. echo format_locale_date(CONFVAL_dateFormatForInfosFromCourses, strtotime($key2));
  420. }
  421. echo "\n";
  422. echo "</p>";
  423. // // // End Of Title of LEVEL 2 // // //
  424. // // // LEVEL 3 // // //
  425. reset($digest[$key1][$key2]);
  426. while (list ($key3, $dataFromCourse) = each($digest[$key1][$key2]))
  427. {
  428. // // // Title of LEVEL 3 // // //
  429. if ($orderKey[2] == 'keyTools')
  430. {
  431. $level3title = "<a href=\"".$toolsList[$key3]["path"].$courseSysCode."\">".$toolsList[$key3]["name"]."</a>";
  432. }
  433. elseif ($orderKey[2] == 'keyCourse')
  434. {
  435. $level3title = "&#8226; <a href=\"".$toolsList[$tools]["path"].$key3."\">".$courses[$key3]['courseCode']."</a>\n";
  436. }
  437. elseif ($orderKey[2] == 'keyTime')
  438. {
  439. $level3title = "&#8226; <a href=\"".$toolsList[$tools]["path"].$courseSysCode."\">".format_locale_date(CONFVAL_dateFormatForInfosFromCourses, strtotime($key3))."</a>";
  440. }
  441. // // // End Of Title of LEVEL 3 // // //
  442. // // // LEVEL 4 (data) // // //
  443. reset($digest[$key1][$key2][$key3]);
  444. while (list ($key4, $dataFromCourse) = each($digest[$key1][$key2][$key3]))
  445. {
  446. echo $level3title, ' &ndash; ', substr(strip_tags($dataFromCourse), 0, CONFVAL_NB_CHAR_FROM_CONTENT);
  447. //adding ... (three dots) if the texts are too large and they are shortened
  448. if (strlen($dataFromCourse) >= CONFVAL_NB_CHAR_FROM_CONTENT)
  449. {
  450. echo '...';
  451. }
  452. }
  453. echo "<br/>\n";
  454. }
  455. }
  456. }
  457. }
  458. }
  459. } // end function display_digest
  460. /**
  461. * Display code for one specific course a logged in user is subscribed to.
  462. * Shows a link to the course, what's new icons...
  463. *
  464. * $my_course['d'] - course directory
  465. * $my_course['i'] - course title
  466. * $my_course['c'] - visual course code
  467. * $my_course['k'] - system course code
  468. * $my_course['db'] - course database
  469. *
  470. * @version 1.0.3
  471. * @todo refactor into different functions for database calls | logic | display
  472. * @todo replace single-character $my_course['d'] indices
  473. * @todo move code for what's new icons to a separate function to clear things up
  474. * @todo add a parameter user_id so that it is possible to show the courselist of other users (=generalisation). This will prevent having to write a new function for this.
  475. */
  476. function get_logged_user_course_html($my_course)
  477. {
  478. global $nosession;
  479. if(api_get_setting('use_session_mode')=='true' && !$nosession)
  480. {
  481. global $now, $date_start, $date_end;
  482. }
  483. //initialise
  484. $result = '';
  485. // Table definitions
  486. //$statistic_database = Database::get_statistic_database();
  487. $course_tool_table = Database :: get_course_table(TABLE_TOOL_LIST, $course_database);
  488. $tool_edit_table = Database :: get_course_table(TABLE_ITEM_PROPERTY, $course_database);
  489. $course_group_user_table = Database :: get_course_table(TOOL_USER, $course_database);
  490. $user_id = api_get_user_id();
  491. $course_database = $my_course['db'];
  492. $course_system_code = $my_course['k'];
  493. $course_visual_code = $my_course['c'];
  494. $course_title = $my_course['i'];
  495. $course_directory = $my_course['d'];
  496. $course_teacher = $my_course['t'];
  497. $course_info = Database :: get_course_info($course_system_code);
  498. $course_access_settings = CourseManager :: get_access_settings($course_system_code);
  499. $course_id = $course_info['course_id'];
  500. $course_visibility = $course_access_settings['visibility'];
  501. $user_in_course_status = CourseManager :: get_user_in_course_status(api_get_user_id(), $course_system_code);
  502. //function logic - act on the data
  503. $is_virtual_course = CourseManager :: is_virtual_course_from_system_code($my_course['c']);
  504. if ($is_virtual_course)
  505. {
  506. // If the current user is also subscribed in the real course to which this
  507. // virtual course is linked, we don't need to display the virtual course entry in
  508. // the course list - it is combined with the real course entry.
  509. $target_course_code = CourseManager :: get_target_of_linked_course($course_system_code);
  510. $is_subscribed_in_target_course = CourseManager :: is_user_subscribed_in_course(api_get_user_id(), $target_course_code);
  511. if ($is_subscribed_in_target_course)
  512. {
  513. return; //do not display this course entry
  514. }
  515. }
  516. $has_virtual_courses = CourseManager :: has_virtual_courses_from_code($course_system_code, api_get_user_id());
  517. if ($has_virtual_courses)
  518. {
  519. $return_result = CourseManager :: determine_course_title_from_course_info(api_get_user_id(), $course_info);
  520. $course_display_title = $return_result['title'];
  521. $course_display_code = $return_result['code'];
  522. }
  523. else
  524. {
  525. $course_display_title = $course_title;
  526. $course_display_code = $course_visual_code;
  527. }
  528. $s_course_status=$my_course["s"];
  529. $s_htlm_status_icon="";
  530. if($s_course_status==1){
  531. $s_htlm_status_icon="<img src='main/img/teachers.gif'>";
  532. }
  533. if($s_course_status==2){
  534. $s_htlm_status_icon="<img src='main/img/coachs.gif'>";
  535. }
  536. if($s_course_status==5){
  537. $s_htlm_status_icon="<img src='main/img/students.gif'>";
  538. }
  539. //display course entry
  540. $result.="\n\t";
  541. $result .= '<li style="list-style-type: none; margin-bottom: 5px;"><div style="border:0px solid #000; width: auto; float:left;padding-right: 5px;">'.$s_htlm_status_icon.'</div>';
  542. //show a hyperlink to the course, unless the course is closed and user is not course admin
  543. if ($course_visibility != COURSE_VISIBILITY_CLOSED || $user_in_course_status == COURSEMANAGER)
  544. {
  545. if(api_get_setting('use_session_mode')=='true' && !$nosession)
  546. {
  547. if(empty($my_course['id_session']))
  548. {
  549. $my_course['id_session'] = 0;
  550. }
  551. if($user_in_course_status == COURSEMANAGER || ($date_start <= $now && $date_end >= $now) || $date_start=='0000-00-00')
  552. {
  553. $result .= '<a href="'.api_get_path(WEB_COURSE_PATH).$course_directory.'/?id_session='.$my_course['id_session'].'">'.$course_display_title.'</a>';
  554. }
  555. }
  556. else
  557. {
  558. $result .= '<a href="'.api_get_path(WEB_COURSE_PATH).$course_directory.'/">'.$course_display_title.'</a>';
  559. }
  560. }
  561. else
  562. {
  563. $result .= $course_display_title." "." ".get_lang("CourseClosed")."";
  564. }
  565. // show the course_code and teacher if chosen to display this
  566. if (get_setting("display_coursecode_in_courselist") == "true" OR get_setting("display_teacher_in_courselist") == "true")
  567. {
  568. $result .= "<br/>";
  569. }
  570. if (get_setting("display_coursecode_in_courselist") == "true")
  571. {
  572. $result .= $course_display_code;
  573. }
  574. if (get_setting("display_coursecode_in_courselist") == "true" AND get_setting("display_teacher_in_courselist") == "true")
  575. {
  576. $result .= ' &ndash; ';
  577. }
  578. if (get_setting("display_teacher_in_courselist") == "true")
  579. {
  580. $result .= $course_teacher;
  581. }
  582. // display the what's new icons
  583. $result .= show_notification($my_course);
  584. /*
  585. // get the user's last access dates to all tools of this course
  586. $sqlLastTrackInCourse = "SELECT * FROM $statistic_database.track_e_lastaccess"
  587. ." WHERE access_user_id = ".$user_id
  588. ." AND access_cours_code = '".$my_course['k']."'";
  589. $resLastTrackInCourse = api_sql_query($sqlLastTrackInCourse,__FILE__,__LINE__);
  590. while($lastTrackInCourse = mysql_fetch_array($resLastTrackInCourse))
  591. {
  592. $lastTrackInCourseDate[$lastTrackInCourse["access_tool"]] = $lastTrackInCourse["access_date"];
  593. }
  594. // get the last edits of all tools of this course
  595. $sql = "SELECT tooledit.lastedit_date last_date, tooledit.tool tool, tooledit.ref ref,
  596. tooledit.lastedit_type type, tooledit.to_group_id group_id,
  597. accueil.image image, accueil.link link
  598. FROM $tool_edit_table tooledit, $course_tool_table accueil
  599. WHERE accueil.name = tooledit.tool
  600. AND accueil.visibility = '1'
  601. AND tooledit.insert_user_id != $user_id
  602. AND (tooledit.to_user_id = '$user_id' OR tooledit.to_user_id = 0)";
  603. $res = api_sql_query($sql,__FILE__,__LINE__);
  604. $sql = "SELECT group_id FROM $course_group_user_table WHERE user_id = '$user_id'";
  605. $groupres = api_sql_query($sql,__FILE__,__LINE__);
  606. $groups = mysql_fetch_array($groupres);
  607. $groups[] = 0;
  608. //show icons of tools where there is something new
  609. while($lastToolEdit = mysql_fetch_array($res))
  610. {
  611. if ($lastTrackInCourseDate[$lastToolEdit["tool"]]<$lastToolEdit["last_date"] && in_array($lastToolEdit["group_id"], $groups))
  612. {
  613. $lastDate = date("d/m/Y H:i", convert_mysql_date($lastToolEdit["last_date"]));
  614. $type = ($lastToolEdit["type"]=="" || $lastToolEdit["type"]==NULL) ? get_lang('_new_item') : $lastToolEdit["type"];
  615. $result.= '<a href="'.api_get_path(WEB_CODE_PATH).$lastToolEdit['link'].'?cidReq='.$my_course['k'].'">'.
  616. '<img title="&mdash; '.$lastToolEdit['tool'].' &mdash; '.get_lang('_title_notification').": $type ($lastDate).\""
  617. .' src="'.api_get_path(WEB_IMG_PATH).$lastToolEdit['image'].'" border="0" align="middle" alt="'.$lastToolEdit['image'].'" /></a>';
  618. }
  619. }
  620. unset($lastTrackInCourseDate);
  621. unset($groups);*/
  622. if ((CONFVAL_showExtractInfo == SCRIPTVAL_InCourseList || CONFVAL_showExtractInfo == SCRIPTVAL_Both) && $nbDigestEntries > 0)
  623. {
  624. reset($digest);
  625. $result .= "<ul>";
  626. while (list ($key2) = each($digest[$thisCourseSysCode]))
  627. {
  628. $result .= "<li>";
  629. if ($orderKey[1] == 'keyTools')
  630. {
  631. $result .= "<a href=\"$toolsList[$key2] [\"path\"] $thisCourseSysCode \">";
  632. $result .= "$toolsList[$key2][\"name\"]</a>";
  633. }
  634. else
  635. {
  636. $result .= format_locale_date(CONFVAL_dateFormatForInfosFromCourses, strtotime($key2));
  637. }
  638. $result .= "</li>";
  639. $result .= "<ul>";
  640. reset($digest[$thisCourseSysCode][$key2]);
  641. while (list ($key3, $dataFromCourse) = each($digest[$thisCourseSysCode][$key2]))
  642. {
  643. $result .= "<li>";
  644. if ($orderKey[2] == 'keyTools')
  645. {
  646. $result .= "<a href=\"$toolsList[$key3] [\"path\"] $thisCourseSysCode \">";
  647. $result .= "$toolsList[$key3][\"name\"]</a>";
  648. }
  649. else
  650. {
  651. $result .= format_locale_date(CONFVAL_dateFormatForInfosFromCourses, strtotime($key3));
  652. }
  653. $result .= "<ul compact=\"compact\">";
  654. reset($digest[$thisCourseSysCode][$key2][$key3]);
  655. while (list ($key4, $dataFromCourse) = each($digest[$thisCourseSysCode][$key2][$key3]))
  656. {
  657. $result .= "<li>";
  658. $result .= htmlspecialchars(substr(strip_tags($dataFromCourse), 0, CONFVAL_NB_CHAR_FROM_CONTENT));
  659. $result .= "</li>";
  660. }
  661. $result .= "</ul>";
  662. $result .= "</li>";
  663. }
  664. $result .= "</ul>";
  665. $result .= "</li>";
  666. }
  667. $result .= "</ul>";
  668. }
  669. $result .= "</li>";
  670. if(api_get_setting('use_session_mode')=='true' && !$nosession)
  671. {
  672. if(!empty($my_course['session_name']))
  673. {
  674. $session = $my_course['session_name'];
  675. if($date_start=='0000-00-00')
  676. {
  677. $session .= ' - '.get_lang('Without time limits');
  678. $active = true;
  679. }
  680. else
  681. {
  682. $session .= ' - '.get_lang('From').' '.$my_course['date_start'].' '.get_lang('To').' '.$my_course['date_end'];
  683. $active = ($date_start <= $now && $date_end >= $now)?true:false;
  684. }
  685. }
  686. $output = array ($my_course['user_course_cat'], $result, $my_course['id_session'], $session, 'active'=>$active);
  687. }
  688. else
  689. {
  690. $output = array ($my_course['user_course_cat'], $result);
  691. }
  692. return $output;
  693. }
  694. /**
  695. * Returns the "what's new" icon notifications
  696. * @version
  697. */
  698. function show_notification($my_course)
  699. {
  700. $statistic_database = Database :: get_statistic_database();
  701. $user_id = api_get_user_id();
  702. $course_database = $my_course['db'];
  703. $course_tool_table = Database::get_course_table(TABLE_TOOL_LIST, $course_database);
  704. $tool_edit_table = Database::get_course_table(TABLE_ITEM_PROPERTY, $course_database);
  705. $course_group_user_table = Database :: get_course_table(GROUP_USER_TABLE, $course_database);
  706. // get the user's last access dates to all tools of this course
  707. $sqlLastTrackInCourse = "SELECT * FROM $statistic_database.track_e_lastaccess
  708. USE INDEX (access_cours_code, access_user_id)
  709. WHERE access_cours_code = '".$my_course['k']."'
  710. AND access_user_id = '$user_id'";
  711. $resLastTrackInCourse = api_sql_query($sqlLastTrackInCourse, __FILE__, __LINE__);
  712. $oldestTrackDate = "3000-01-01 00:00:00";
  713. while ($lastTrackInCourse = mysql_fetch_array($resLastTrackInCourse))
  714. {
  715. $lastTrackInCourseDate[$lastTrackInCourse["access_tool"]] = $lastTrackInCourse["access_date"];
  716. if ($oldestTrackDate > $lastTrackInCourse["access_date"])
  717. $oldestTrackDate = $lastTrackInCourse["access_date"];
  718. }
  719. // get the last edits of all tools of this course
  720. $sql = "SELECT tet.*, tet.lastedit_date last_date, tet.tool tool, tet.ref ref,
  721. tet.lastedit_type type, tet.to_group_id group_id,
  722. ctt.image image, ctt.link link
  723. FROM $tool_edit_table tet, $course_tool_table ctt
  724. WHERE tet.lastedit_date > '$oldestTrackDate'
  725. AND ctt.name = tet.tool
  726. AND ctt.visibility = '1'
  727. AND tet.lastedit_user_id != $user_id
  728. ORDER BY tet.lastedit_date";
  729. $res = api_sql_query($sql);
  730. //get the group_id's with user membership
  731. $group_ids = GroupManager :: get_group_ids($course_database, $user_id);
  732. $groups_ids[] = 0; //add group 'everyone'
  733. //filter all selected items
  734. while ($res && ($item_property = mysql_fetch_array($res)))
  735. {
  736. if ((!isset ($lastTrackInCourseDate[$item_property['tool']]) || $lastTrackInCourseDate[$item_property['tool']] < $item_property['lastedit_date']) && (in_array($item_property['to_group_id'], $groups_ids) || $item_property['to_user_id'] == $user_id) && ($item_property['visibility'] == '1' || ($my_course['s'] == '1' && $item_property['visibility'] == '0') || !isset ($item_property['visibility'])))
  737. {
  738. $notifications[$item_property['tool']] = $item_property;
  739. }
  740. }
  741. //show all tool icons where there is something new
  742. $retvalue = '&nbsp;';
  743. if (isset ($notifications))
  744. {
  745. while (list ($key, $notification) = each($notifications))
  746. {
  747. $lastDate = date("d/m/Y H:i", convert_mysql_date($notification['lastedit_date']));
  748. $type = $notification['lastedit_type'];
  749. //$notification[image]=str_replace(".png","gif",$notification[image]);
  750. //$notification[image]=str_replace(".gif","_s.gif",$notification[image]);
  751. $retvalue .= '<a href="'.api_get_path(WEB_CODE_PATH).$notification['link'].'?cidReq='.$my_course['k'].'&amp;ref='.$notification['ref'].'">'.'<img title="-- '.get_lang($notification['tool']).' -- '.get_lang('_title_notification').": $type ($lastDate).\"".' src="'.api_get_path(WEB_CODE_PATH).'img/'.$notification['image'].'" border="0" align="middle" /></a>&nbsp;';
  752. }
  753. }
  754. return $retvalue;
  755. }
  756. /**
  757. * retrieves the user defined course categories
  758. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
  759. * @return array containing all the titles of the user defined courses with the id as key of the array
  760. */
  761. function get_user_course_categories()
  762. {
  763. global $_user;
  764. $table_category = Database::get_user_personal_table(USER_COURSE_CATEGORY_TABLE);
  765. $sql = "SELECT * FROM ".$table_category." WHERE user_id='".$_user['user_id']."'";
  766. $result = api_sql_query($sql,__FILE__,__LINE__);
  767. while ($row = mysql_fetch_array($result))
  768. {
  769. $output[$row['id']] = $row['title'];
  770. }
  771. return $output;
  772. }
  773. /*
  774. ==============================================================================
  775. MAIN CODE
  776. ==============================================================================
  777. */
  778. /*
  779. ==============================================================================
  780. PERSONAL COURSE LIST
  781. ==============================================================================
  782. */
  783. if (!isset ($maxValvas))
  784. {
  785. $maxValvas = CONFVAL_maxValvasByCourse; // Maximum number of entries
  786. }
  787. if (!isset ($maxAgenda))
  788. {
  789. $maxAgenda = CONFVAL_maxAgendaByCourse; // collected from each course
  790. }
  791. if (!isset ($maxCourse))
  792. {
  793. $maxCourse = CONFVAL_maxTotalByCourse; // and displayed in summary.
  794. }
  795. $maxValvas = (int) $maxValvas;
  796. $maxAgenda = (int) $maxAgenda;
  797. $maxCourse = (int) $maxCourse; // 0 if invalid
  798. if ($maxCourse > 0)
  799. {
  800. unset ($allentries); // we shall collect all summary$key1 entries in here:
  801. $toolsList['agenda']['name'] = get_lang('Agenda');
  802. $toolsList['agenda']['path'] = api_get_path(WEB_CODE_PATH)."calendar/agenda.php?cidReq=";
  803. $toolsList['valvas']['name'] = get_lang('Valvas');
  804. $toolsList['valvas']['path'] = api_get_path(WEB_CODE_PATH)."announcements/announcements.php?cidReq=";
  805. }
  806. /*
  807. -----------------------------------------------------------------------------
  808. Plugins for banner section
  809. -----------------------------------------------------------------------------
  810. */
  811. echo "<div class=\"maincontent\">"; // start of content for logged in users
  812. // link to see the session view or course view
  813. if(api_get_setting('use_session_mode')=='true' && api_is_allowed_to_create_course()) {
  814. if(isset($_GET['sessionview'])){
  815. echo '<a href="'.$_SERVER['PHP_SELF'].'">'.get_lang('CourseView').'</a>';
  816. }
  817. else {
  818. echo '<a href="'.$_SERVER['PHP_SELF'].'?sessionview=true">'.get_lang('SessionView').'</a>';
  819. }
  820. }
  821. /*
  822. -----------------------------------------------------------------------------
  823. System Announcements
  824. -----------------------------------------------------------------------------
  825. */
  826. $announcement = $_GET['announcement'] ? $_GET['announcement'] : -1;
  827. $visibility = api_is_allowed_to_create_course() ? VISIBLE_TEACHER : VISIBLE_STUDENT;
  828. SystemAnnouncementManager :: display_announcements($visibility, $announcement);
  829. if (!empty ($_GET['include']) && !strstr($_GET['include'], '/') && strstr($_GET['include'], '.html'))
  830. {
  831. include ('./home/'.$_GET['include']);
  832. $pageIncluded = true;
  833. }
  834. else
  835. {
  836. /*--------------------------------------
  837. DISPLAY COURSES
  838. --------------------------------------*/
  839. $list = '';
  840. if(api_get_setting('use_session_mode')=='true' && !$nosession)
  841. {
  842. $personal_course_list = get_personal_session_course_list($_user['user_id']);
  843. }
  844. else
  845. {
  846. $personal_course_list = get_personal_course_list($_user['user_id']);
  847. }
  848. foreach ($personal_course_list as $my_course)
  849. {
  850. $thisCourseDbName = $my_course['db'];
  851. $thisCourseSysCode = $my_course['k'];
  852. $thisCoursePublicCode = $my_course['c'];
  853. $thisCoursePath = $my_course['d'];
  854. $sys_course_path = api_get_path(SYS_COURSE_PATH);
  855. /*
  856. currently disabled functionality, should return
  857. $thisCoursePath = $sys_course_path . $thisCoursePath;
  858. if(! file_exists($thisCoursePath))
  859. {
  860. echo "<li>".$my_course['i']."<br/>";
  861. echo "".get_lang("CourseDoesntExist")." (<a href=\"main/install/update_courses.php\">";
  862. echo "".get_lang("GetCourseFromOldPortal")."</a>)</li>";
  863. continue;
  864. }*/
  865. $dbname = $my_course['k'];
  866. $status[$dbname] = $my_course['s'];
  867. $nbDigestEntries = 0; // number of entries already collected
  868. if ($maxCourse < $maxValvas)
  869. $maxValvas = $maxCourse;
  870. if ($maxCourse > 0)
  871. {
  872. $courses[$thisCourseSysCode]['coursePath'] = $thisCoursePath;
  873. $courses[$thisCourseSysCode]['courseCode'] = $thisCoursePublicCode;
  874. }
  875. /*
  876. -----------------------------------------------------------
  877. Announcements
  878. -----------------------------------------------------------
  879. */
  880. $course_database = $my_course['db'];
  881. $course_tool_table = Database::get_course_table(TABLE_TOOL_LIST, $course_database);
  882. $query = "SELECT visibility FROM $course_tool_table WHERE link = 'announcements/announcements.php' AND visibility = 1";
  883. $result = api_sql_query($query);
  884. // collect from announcements, but only if tool is visible for the course
  885. if ($result && $maxValvas > 0 && mysql_num_rows($result) > 0)
  886. {
  887. //Search announcements table
  888. //Take the entries listed at the top of advalvas/announcements tool
  889. $course_announcement_table = Database::get_course_table(TABLE_ANNOUNCEMENT);
  890. $sqlGetLastAnnouncements = "SELECT end_date publicationDate, content
  891. FROM ".$course_announcement_table;
  892. switch (CONFVAL_limitPreviewTo)
  893. {
  894. case SCRIPTVAL_NewEntriesOfTheDay :
  895. $sqlGetLastAnnouncements .= "WHERE DATE_FORMAT(end_date,'%Y %m %d') >= '".date("Y m d")."'";
  896. break;
  897. case SCRIPTVAL_NoTimeLimit :
  898. break;
  899. case SCRIPTVAL_NewEntriesOfTheDayOfLastLogin :
  900. // take care mysql -> DATE_FORMAT(time,format) php -> date(format,date)
  901. $sqlGetLastAnnouncements .= "WHERE DATE_FORMAT(end_date,'%Y %m %d') >= '".date("Y m d", $_user["lastLogin"])."'";
  902. }
  903. $sqlGetLastAnnouncements .= "ORDER BY end_date DESC
  904. LIMIT ".$maxValvas;
  905. $resGetLastAnnouncements = api_sql_query($sqlGetLastAnnouncements, __FILE__, __LINE__);
  906. if ($resGetLastAnnouncements)
  907. {
  908. while ($annoncement = mysql_fetch_array($resGetLastAnnouncements))
  909. {
  910. $keyTools = "valvas";
  911. $keyTime = $annoncement['publicationDate'];
  912. $keyCourse = $thisCourseSysCode;
  913. $digest[$$orderKey[0]][$$orderKey[1]][$$orderKey[2]][] = htmlspecialchars(substr(strip_tags($annoncement["content"]), 0, CONFVAL_NB_CHAR_FROM_CONTENT));
  914. $nbDigestEntries ++; // summary has same order as advalvas
  915. }
  916. }
  917. }
  918. /*
  919. -----------------------------------------------------------
  920. Agenda
  921. -----------------------------------------------------------
  922. */
  923. $course_database = $my_course['db'];
  924. $course_tool_table = Database :: get_course_table(TABLE_TOOL_LIST,$course_database);
  925. $query = "SELECT visibility FROM $course_tool_table WHERE link = 'calendar/agenda.php' AND visibility = 1";
  926. $result = api_sql_query($query);
  927. $thisAgenda = $maxCourse - $nbDigestEntries; // new max entries for agenda
  928. if ($maxAgenda < $thisAgenda)
  929. $thisAgenda = $maxAgenda;
  930. // collect from agenda, but only if tool is visible for the course
  931. if ($result && $thisAgenda > 0 && mysql_num_rows($result) > 0)
  932. {
  933. $tableCal = $courseTablePrefix.$thisCourseDbName.$_configuration['db_glue']."calendar_event";
  934. $sqlGetNextAgendaEvent = "SELECT start_date , title content, start_time
  935. FROM $tableCal
  936. WHERE start_date >= CURDATE()
  937. ORDER BY start_date, start_time
  938. LIMIT $maxAgenda";
  939. $resGetNextAgendaEvent = api_sql_query($sqlGetNextAgendaEvent, __FILE__, __LINE__);
  940. if ($resGetNextAgendaEvent)
  941. {
  942. while ($agendaEvent = mysql_fetch_array($resGetNextAgendaEvent))
  943. {
  944. $keyTools = 'agenda';
  945. $keyTime = $agendaEvent['start_date'];
  946. $keyCourse = $thisCourseSysCode;
  947. $digest[$$orderKey[0]][$$orderKey[1]][$$orderKey[2]][] = htmlspecialchars(substr(strip_tags($agendaEvent["content"]), 0, CONFVAL_NB_CHAR_FROM_CONTENT));
  948. $nbDigestEntries ++; // summary has same order as advalvas
  949. }
  950. }
  951. }
  952. /*
  953. -----------------------------------------------------------
  954. Digest Display
  955. take collected data and display it
  956. -----------------------------------------------------------
  957. */
  958. $list[] = get_logged_user_course_html($my_course);
  959. } //end while mycourse...
  960. }
  961. if (is_array($list))
  962. {
  963. if(api_get_setting('use_session_mode')=='true' && !$nosession)
  964. {
  965. $listActives = $listInactives = $listCourses = array();
  966. foreach($list as $key=>$value){
  967. if($value['active'])
  968. $listActives[] = $value;
  969. else if(!empty($value[2]))
  970. $listInactives[] = $value;
  971. }
  972. $old_user_category = 0;
  973. $userdefined_categories = get_user_course_categories();
  974. //Courses which belong to no sessions
  975. //echo "<ul style=\"line-height: 20px;\">\n\n\n\t<ul class=\"user_course_category\"><li>".get_lang("Courses_no_sessions")."</li></ul>\n</ul>";
  976. if(count($listActives)>0 && $display_actives){
  977. echo "<ul style=\"line-height: 20px;\">\n";
  978. foreach ($listActives as $key => $value)
  979. {
  980. if(!empty($value[2])){
  981. if($old_session != $value[2]){
  982. $old_session = $value[2];
  983. if($key != 0){
  984. echo "\n</ul>";
  985. }
  986. echo "\n\n\t<ul class=\"user_course_category\"><li>".$value[3]."</li></ul>\n";
  987. echo "<ul>";
  988. }
  989. }
  990. echo $value[1];
  991. }
  992. echo "\n</ul></ul><br /><br />\n";
  993. }
  994. if(count($listInactives)>0 && !$display_actives){
  995. echo "<ul style=\"line-height: 20px;\">";
  996. foreach ($listInactives as $key => $value)
  997. {
  998. if(!empty($value[2])){
  999. if($old_session != $value[2]){
  1000. $old_session = $value[2];
  1001. if($key != 0){
  1002. echo "\n</ul>";
  1003. }
  1004. echo "\n\n\t<ul class=\"user_course_category\"><li>".$value[3]."</li></ul>\n";
  1005. echo "<ul>";
  1006. }
  1007. }
  1008. echo $value[1];
  1009. }
  1010. echo "\n</ul><br /><br />\n";
  1011. }
  1012. }
  1013. else
  1014. {
  1015. $old_user_category = 0;
  1016. $userdefined_categories = get_user_course_categories();
  1017. echo "<ul>\n";
  1018. foreach ($list as $key => $value)
  1019. {
  1020. if ($old_user_category<>$value[0])
  1021. {
  1022. if ($key<>0 OR $value[0]<>0) // there are courses in the previous category
  1023. {
  1024. echo "\n</ul>";
  1025. }
  1026. echo "\n\n\t<ul class=\"user_course_category\"><li>".$userdefined_categories[$value[0]]."</li></ul>\n";
  1027. if ($key<>0 OR $value[0]<>0) // there are courses in the previous category
  1028. {
  1029. echo "<ul>";
  1030. }
  1031. $old_user_category=$value[0];
  1032. }
  1033. echo $value[1];
  1034. }
  1035. echo "\n</ul>\n";
  1036. }
  1037. }
  1038. echo "</div>"; // end of content section
  1039. // Register whether full admin or null admin course
  1040. // by course through an array dbname x user status
  1041. api_session_register('status');
  1042. /*
  1043. ==============================================================================
  1044. RIGHT MENU
  1045. ==============================================================================
  1046. */
  1047. echo "<div class=\"menu\">";
  1048. // api_display_language_form(); // moved to the profile page.
  1049. echo "<div class=\"menusection\">";
  1050. echo "<span class=\"menusectioncaption\">".get_lang("MenuUser")."</span>";
  1051. echo "<ul class=\"menulist\">";
  1052. $display_add_course_link = api_is_allowed_to_create_course() && ($_SESSION["studentview"] != "studentenview");
  1053. if ($display_add_course_link)
  1054. display_create_course_link();
  1055. display_edit_course_list_links();
  1056. display_digest($toolsList, $digest, $orderKey, $courses);
  1057. $navigation=array();
  1058. // Link to my profile
  1059. $navigation['myprofile']['url'] = api_get_path(WEB_CODE_PATH).'auth/profile.php'.(!empty($_course['path']) ? '?coursePath='.$_course['path'].'&amp;courseCode='.$_course['official_code'] : '' );
  1060. $navigation['myprofile']['title'] = get_lang('ModifyProfile');
  1061. // Link to my agenda
  1062. $navigation['myagenda']['url'] = api_get_path(WEB_CODE_PATH).'calendar/myagenda.php'.(!empty($_course['path']) ? '?coursePath='.$_course['path'].'&amp;courseCode='.$_course['official_code'] : '' );
  1063. $navigation['myagenda']['title'] = get_lang('MyAgenda');
  1064. foreach($navigation as $section => $navigation_info)
  1065. {
  1066. $current = ($section == $GLOBALS['this_section'] ? ' id="current"' : '');
  1067. echo '<li'.$current.'>';
  1068. echo '<a href="'.$navigation_info['url'].'" target="_top">'.$navigation_info['title'].'</a>';
  1069. echo '</li>';
  1070. echo "\n";
  1071. }
  1072. echo "</ul>";
  1073. echo "</div>";
  1074. /*
  1075. -----------------------------------------------------------------------------
  1076. Plugins for banner section
  1077. -----------------------------------------------------------------------------
  1078. */
  1079. if (is_array($_plugins['mycourses_menu'])){
  1080. echo '<div class="note" style="background: none">';
  1081. api_plugin('mycourses_menu');
  1082. echo "</div>";
  1083. }
  1084. echo "</div>"; // end of menu
  1085. /*
  1086. ==============================================================================
  1087. FOOTER
  1088. ==============================================================================
  1089. */
  1090. Display :: display_footer();
  1091. ?>