user_portal.php 47 KB

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