activity.php 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645
  1. <?php // $Id: activity.php,v 1.5 2006/08/10 14:34:54 pcool Exp $
  2. /*
  3. ==============================================================================
  4. Dokeos - elearning and course management software
  5. Copyright (c) 2004-2005 Dokeos S.A.
  6. Copyright (c) 2003 Ghent University
  7. Copyright (c) 2001 Universite Catholique de Louvain
  8. Copyright (c) various contributors
  9. For a full list of contributors, see "credits.txt".
  10. The full license can be read in "license.txt".
  11. This program is free software; you can redistribute it and/or
  12. modify it under the terms of the GNU General Public License
  13. as published by the Free Software Foundation; either version 2
  14. of the License, or (at your option) any later version.
  15. See the GNU General Public License for more details.
  16. Contact address: Dokeos, 44 rue des palais, B-1030 Brussels, Belgium
  17. Mail: info@dokeos.com
  18. ==============================================================================
  19. */
  20. /**
  21. ==============================================================================
  22. * HOME PAGE FOR EACH COURSE
  23. *
  24. * This page, included in every course's index.php is the home
  25. * page. To make administration simple, the teacher edits his
  26. * course from the home page. Only the login detects that the
  27. * visitor is allowed to activate, deactivate home page links,
  28. * access to the teachers tools (statistics, edit forums...).
  29. *
  30. * @package dokeos.course_home
  31. ==============================================================================
  32. */
  33. require_once '../../main/inc/global.inc.php';
  34. /*
  35. ==============================================================================
  36. FUNCTIONS
  37. ==============================================================================
  38. */
  39. /**
  40. * Displays the tools of a certain category.
  41. *
  42. * @return void
  43. * @param string $course_tool_category contains the category of tools to display:
  44. * "toolauthoring", "toolinteraction", "tooladmin", "tooladminplatform"
  45. */
  46. function show_tools_category($course_tool_category)
  47. {
  48. global $_user;
  49. $web_code_path = api_get_path(WEB_CODE_PATH);
  50. $course_tool_table = Database::get_course_table(TABLE_TOOL_LIST);
  51. $is_allowed_to_edit = api_is_allowed_to_edit();
  52. $is_platform_admin = api_is_platform_admin();
  53. //condition for the session
  54. $session_id = api_get_session_id();
  55. $condition_session = api_get_session_condition($session_id,true,true);
  56. switch ($course_tool_category) {
  57. case TOOL_STUDENT_VIEW:
  58. $result = Database::query("SELECT * FROM $course_tool_table WHERE visibility = '1' AND (category = 'authoring' OR category = 'interaction') $condition_session ORDER BY id",__FILE__,__LINE__);
  59. $colLink ="##003399";
  60. break;
  61. case TOOL_AUTHORING:
  62. $result = Database::query("SELECT * FROM $course_tool_table WHERE category = 'authoring' $condition_session ORDER BY id",__FILE__,__LINE__);
  63. $colLink ="##003399";
  64. break;
  65. case TOOL_INTERACTION:
  66. $result = Database::query("SELECT * FROM $course_tool_table WHERE category = 'interaction' $condition_session ORDER BY id",__FILE__,__LINE__);
  67. $colLink ="##003399";
  68. break;
  69. case TOOL_ADMIN_VISIBLE:
  70. $result = Database::query("SELECT * FROM $course_tool_table WHERE category = 'admin' AND visibility ='1' $condition_session ORDER BY id",__FILE__,__LINE__);
  71. $colLink ="##003399";
  72. break;
  73. case TOOL_ADMIN_PLATEFORM:
  74. $result = Database::query("SELECT * FROM $course_tool_table WHERE category = 'admin' $condition_session ORDER BY id",__FILE__,__LINE__);
  75. $colLink ="##003399";
  76. break;
  77. }
  78. while ($temp_row = Database::fetch_array($result))
  79. {
  80. $all_tools_list[]=$temp_row;
  81. }
  82. /*if(api_is_course_coach())
  83. {
  84. $result = Database::query("SELECT * FROM $course_tool_table WHERE name='tracking'",__FILE__,__LINE__);
  85. $all_tools_list[]=Database :: fetch_array($result);
  86. }*/
  87. $i=0;
  88. // grabbing all the links that have the property on_homepage set to 1
  89. $course_link_table = Database::get_course_table(TABLE_LINK);
  90. $course_item_property_table = Database::get_course_table(TABLE_ITEM_PROPERTY);
  91. switch ($course_tool_category)
  92. {
  93. case TOOL_AUTHORING:
  94. $sql_links="SELECT tl.*, tip.visibility
  95. FROM $course_link_table tl
  96. LEFT JOIN $course_item_property_table tip ON tip.tool='link' AND tip.ref=tl.id
  97. WHERE tl.on_homepage='1' $condition_session";
  98. break;
  99. case TOOL_INTERACTION:
  100. $sql_links = null;
  101. /*
  102. $sql_links="SELECT tl.*, tip.visibility
  103. FROM $course_link_table tl
  104. LEFT JOIN $course_item_property_table tip ON tip.tool='link' AND tip.ref=tl.id
  105. WHERE tl.on_homepage='1' ";
  106. */
  107. break;
  108. case TOOL_STUDENT_VIEW:
  109. $sql_links="SELECT tl.*, tip.visibility
  110. FROM $course_link_table tl
  111. LEFT JOIN $course_item_property_table tip ON tip.tool='link' AND tip.ref=tl.id
  112. WHERE tl.on_homepage='1' $condition_session";
  113. break;
  114. case TOOL_ADMIN:
  115. $sql_links="SELECT tl.*, tip.visibility
  116. FROM $course_link_table tl
  117. LEFT JOIN $course_item_property_table tip ON tip.tool='link' AND tip.ref=tl.id
  118. WHERE tl.on_homepage='1' $condition_session";
  119. break;
  120. default:
  121. $sql_links = null;
  122. break;
  123. }
  124. //edit by Kevin Van Den Haute (kevin@develop-it.be) for integrating Smartblogs
  125. if($sql_links != null)
  126. {
  127. $result_links = Database::query($sql_links,__FILE__,__LINE__);
  128. $properties = array();
  129. if (Database::num_rows($result_links) > 0) {
  130. while($links_row = Database::fetch_array($result_links))
  131. {
  132. unset($properties);
  133. $properties['name'] = $links_row['title'];
  134. $properties['session_id'] = $links_row['session_id'];
  135. $properties['link'] = $links_row['url'];
  136. $properties['visibility'] = $links_row['visibility'];
  137. $properties['image'] = ($links_row['visibility']== '0') ? "file_html.gif" : "file_html.gif";
  138. $properties['adminlink'] = api_get_path(WEB_CODE_PATH) . "link/link.php?action=editlink&id=".$links_row['id'];
  139. $properties['target'] = $links_row['target'];
  140. $tmp_all_tools_list[] = $properties;
  141. }
  142. }
  143. }
  144. if(isset($tmp_all_tools_list))
  145. {
  146. foreach($tmp_all_tools_list as $toolsRow)
  147. {
  148. if($toolsRow['image'] == 'blog.gif')
  149. {
  150. // Init
  151. $tbl_blogs_rel_user = Database::get_course_table(TABLE_BLOGS_REL_USER);
  152. // Get blog id
  153. $blog_id = substr($toolsRow['link'], strrpos($toolsRow['link'], '=') + 1, strlen($toolsRow['link']));
  154. // Get blog members
  155. if($is_platform_admin)
  156. {
  157. $sql_blogs = "
  158. SELECT *
  159. FROM " . $tbl_blogs_rel_user . " `blogs_rel_user`
  160. WHERE `blog_id` = " . $blog_id;
  161. }
  162. else
  163. {
  164. $sql_blogs = "
  165. SELECT *
  166. FROM " . $tbl_blogs_rel_user . " `blogs_rel_user`
  167. WHERE
  168. `blog_id` = " . $blog_id . " AND
  169. `user_id` = " . api_get_user_id();
  170. }
  171. $result_blogs = Database::query($sql_blogs, __FILE__, __LINE__);
  172. if(Database::num_rows($result_blogs) > 0)
  173. $all_tools_list[] = $toolsRow;
  174. }
  175. else
  176. $all_tools_list[] = $toolsRow;
  177. }
  178. }
  179. if(isset($all_tools_list))
  180. {
  181. $lnk = '';
  182. foreach($all_tools_list as $toolsRow)
  183. {
  184. if (api_get_session_id()!=0 && in_array($toolsRow['name'],array('course_maintenance','course_setting'))) {
  185. continue;
  186. }
  187. if(!($i%2))
  188. {echo "<tr valign=\"top\">\n";}
  189. // This part displays the links to hide or remove a tool.
  190. // These links are only visible by the course manager.
  191. unset($lnk);
  192. echo '<td width="50%">' . "\n";
  193. if($is_allowed_to_edit)
  194. {
  195. if($toolsRow['visibility'] == '1' && $toolsRow['admin'] !='1')
  196. {
  197. $link['name'] = Display::return_icon('visible.gif', get_lang('Deactivate'),array('id'=>'linktool_'.$toolsRow["id"]));
  198. $link['cmd'] = "hide=yes";
  199. $lnk[] = $link;
  200. }
  201. if($toolsRow['visibility'] == '0' && $toolsRow['admin'] !='1')
  202. {
  203. $link['name'] = Display::return_icon('invisible.gif', get_lang('Activate'),array('id'=>'linktool_'.$toolsRow["id"]));
  204. $link['cmd'] = "restore=yes";
  205. $lnk[] = $link;
  206. }
  207. if(!empty($toolsRow['adminlink']))
  208. {
  209. echo '<a href="'.$toolsRow['adminlink'].'">'.Display::return_icon('edit.gif', get_lang('Edit')).'</a>';
  210. }
  211. }
  212. // Both checks are necessary as is_platform_admin doesn't take student view into account
  213. if( $is_platform_admin && $is_allowed_to_edit)
  214. {
  215. if($toolsRow['admin'] !='1')
  216. {
  217. $link['cmd'] = "hide=yes";
  218. }
  219. }
  220. if(isset($lnk) && is_array($lnk))
  221. {
  222. foreach($lnk as $this_link)
  223. {
  224. if(empty($toolsRow['adminlink']))
  225. {
  226. echo "<a class=\"make_visible_and_invisible\" href=\"" .api_get_self(). "?".api_get_cidreq()."&amp;id=" . $toolsRow["id"] . "&amp;" . $this_link['cmd'] . "\">" . $this_link['name'] . "</a>";
  227. //echo "<a class=\"make_visible_and_invisible\" href=\"javascript:void(0)\" >" . $this_link['name'] . "</a>";
  228. }
  229. }
  230. }
  231. else{ echo '&nbsp;&nbsp;&nbsp;&nbsp;';}
  232. // NOTE : table contains only the image file name, not full path
  233. if(!stristr($toolsRow['link'], 'http://') && !stristr($toolsRow['link'], 'https://') && !stristr($toolsRow['link'],'ftp://'))
  234. $toolsRow['link'] = $web_code_path . $toolsRow['link'];
  235. if($toolsRow['visibility'] == '0' && $toolsRow['admin'] != '1')
  236. {
  237. $class="class=\"invisible\"";
  238. $info = pathinfo($toolsRow['image']);
  239. $basename = basename ($toolsRow['image'],'.'.$info['extension']); // $file is set to "index"
  240. $toolsRow['image'] = $basename.'_na.'.$info['extension'];
  241. }
  242. else
  243. $class='';
  244. $qm_or_amp = ((strpos($toolsRow['link'], '?') === FALSE) ? '?' : '&amp;');
  245. //If it's a link, we don't add the cidReq
  246. if($toolsRow['image'] == 'file_html.gif' || $toolsRow['image'] == 'file_html_na.gif'){
  247. $toolsRow['link'] = $toolsRow['link'].$qm_or_amp;
  248. }
  249. else{
  250. $toolsRow['link'] = $toolsRow['link'].$qm_or_amp.api_get_cidreq();
  251. }
  252. if(strpos($toolsRow['name'],'visio_')!==false) {
  253. /*
  254. $toollink = "\t" . '<a ' . $class . ' href="#" onclick="window.open(\'' . htmlspecialchars($toolsRow['link']) . '\',\'window_visio\',config=\'height=\'+730+\', width=\'+1020+\', left=2, top=2, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, directories=no, status=no\')" target="' . $toolsRow['target'] . '">';
  255. */
  256. $toollink = "\t" . '<a id="tooldesc_'.$toolsRow["id"].'" ' . $class . ' href="javascript: void(0);" onclick="window.open(\'' . htmlspecialchars($toolsRow['link']) . '\',\'window_visio'.$_SESSION['_cid'].'\',config=\'height=\'+730+\', width=\'+1020+\', left=2, top=2, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, directories=no, status=no\')" target="' . $toolsRow['target'] . '">';
  257. $my_tool_link = "\t" . '<a id="istooldesc_'.$toolsRow["id"].'" ' . $class . ' href="javascript: void(0);" onclick="window.open(\'' . htmlspecialchars($toolsRow['link']) . '\',\'window_visio'.$_SESSION['_cid'].'\',config=\'height=\'+730+\', width=\'+1020+\', left=2, top=2, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, directories=no, status=no\')" target="' . $toolsRow['target'] . '">';
  258. } else if(strpos($toolsRow['name'],'chat')!==false && api_get_course_setting('allow_open_chat_window')==true) {
  259. /*
  260. $toollink = "\t" . '<a ' . $class . ' href="#" onclick="window.open(\'' . htmlspecialchars($toolsRow['link']) . '\',\'window_chat'.$_SESSION['_cid'].'\',config=\'height=\'+380+\', width=\'+625+\', left=2, top=2, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, directories=no, status=no\')" target="' . $toolsRow['target'] . '">';
  261. */
  262. $toollink = "\t" . '<a id="tooldesc_'.$toolsRow["id"].'" ' . $class . ' href="javascript: void(0);" onclick="window.open(\'' . htmlspecialchars($toolsRow['link']) . '\',\'window_chat'.$_SESSION['_cid'].'\',config=\'height=\'+380+\', width=\'+625+\', left=2, top=2, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, directories=no, status=no\')" target="' . $toolsRow['target'] . '">';
  263. $my_tool_link="\t" . '<a id="istooldesc_'.$toolsRow["id"].'" ' . $class . ' href="javascript: void(0);" onclick="window.open(\'' . htmlspecialchars($toolsRow['link']) . '\',\'window_chat'.$_SESSION['_cid'].'\',config=\'height=\'+380+\', width=\'+625+\', left=2, top=2, toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, directories=no, status=no\')" target="' . $toolsRow['target'] . '">';
  264. } else {
  265. if (count(explode('type=classroom',$toolsRow['link']))==2 || count(explode('type=conference',$toolsRow['link']))==2) {
  266. //$toollink = "\t" . '<a ' . $class . ' href="' . $toolsRow['link'] . '" target="_blank">';
  267. $toollink = "\t" . '<a id="tooldesc_'.$toolsRow["id"].'" ' . $class . ' href="' . $toolsRow['link'] . '" target="_blank">';
  268. $my_tool_link = "\t" . '<a id="istooldesc_'.$toolsRow["id"].'" ' . $class . ' href="' . $toolsRow['link'] . '" target="_blank">';
  269. } else {
  270. //$toollink = "\t" . '<a ' . $class . ' href="' . htmlspecialchars($toolsRow['link']) . '" target="' . $toolsRow['target'] . '">';
  271. $toollink = "\t" . '<a id="tooldesc_'.$toolsRow["id"].'" ' . $class . ' href="' . htmlspecialchars($toolsRow['link']) . '" target="' . $toolsRow['target'] . '">';
  272. $my_tool_link = "\t" . '<a id="istooldesc_'.$toolsRow["id"].'" ' . $class . ' href="' . htmlspecialchars($toolsRow['link']) . '" target="' . $toolsRow['target'] . '">';
  273. }
  274. }
  275. echo $toollink;
  276. //var_dump($toollink);
  277. /*
  278. Display::display_icon($toolsRow['image'], get_lang(ucfirst($toolsRow['name'])));
  279. */
  280. if ($toolsRow['image'] == 'file_html.gif' || $toolsRow['image'] == 'file_html_na.gif'
  281. || $toolsRow['image'] == 'scormbuilder.gif' || $toolsRow['image'] == 'scormbuilder_na.gif'
  282. || $toolsRow['image'] == 'blog.gif' || $toolsRow['image'] == 'blog_na.gif'
  283. || $toolsRow['image'] == 'external.gif' || $toolsRow['image'] == 'external_na.gif')
  284. {
  285. $tool_name = stripslashes($toolsRow['name']);
  286. } else {
  287. $tool_name = get_lang(ucfirst($toolsRow['name']));
  288. }
  289. Display::display_icon($toolsRow['image'], $tool_name, array('class'=>'tool-icon','id'=>'toolimage_'.$toolsRow["id"]));
  290. //validacion when belongs to a session
  291. $session_img = api_get_session_image($toolsRow['session_id'], $_user['status']);
  292. echo '</a> ';
  293. echo $my_tool_link;
  294. /*
  295. echo ($toolsRow['image'] == 'file_html_na.gif' || $toolsRow['image'] == 'file_html.gif' || $toolsRow['image'] == 'scormbuilder.gif' || $toolsRow['image'] == 'scormbuilder_na.gif' || $toolsRow['image'] == 'blog.gif' || $toolsRow['image'] == 'blog_na.gif' || $toolsRow['image'] == 'external.gif' || $toolsRow['image'] == 'external_na.gif') ? ' '.stripslashes($toolsRow['name']) : ' '.get_lang(ucfirst($toolsRow['name']));
  296. */
  297. echo "{$tool_name}$session_img";
  298. echo "\t" . '</a>';
  299. echo '</td>';
  300. if($i%2)
  301. {
  302. echo "</tr>";
  303. }
  304. $i++;
  305. }
  306. }
  307. if($i%2)
  308. {
  309. echo "<td width=\"50%\">&nbsp;</td>\n",
  310. "</tr>\n";
  311. }
  312. }
  313. //End of functions show tools
  314. /*
  315. ==============================================================================
  316. MAIN CODE
  317. ==============================================================================
  318. */
  319. /*
  320. -----------------------------------------------------------
  321. Work with data post askable by admin of course (franglais, clean this)
  322. -----------------------------------------------------------
  323. */
  324. if (isset($_GET['sent_http_request']) && $_GET['sent_http_request']==1) {
  325. if(api_is_allowed_to_edit()) {
  326. $tool_table = Database::get_course_table(TABLE_TOOL_LIST);
  327. $tool_id = Security::remove_XSS($_GET["id"]);
  328. $tool_info = api_get_tool_information($tool_id);
  329. $tool_visibility = $tool_info['visibility'];
  330. $tool_image = $tool_info['image'];
  331. $new_image = str_replace('.gif','_na.gif',$tool_image);
  332. $requested_image = ($tool_visibility == 0 ) ? $tool_image : $new_image;
  333. $requested_clase = ($tool_visibility == 0 ) ? 'visible' : 'invisible';
  334. $requested_message = ($tool_visibility == 0 ) ? 'is_active' : 'is_inactive';
  335. $requested_view = ($tool_visibility == 0 ) ? 'visible.gif' : 'invisible.gif';
  336. $requested_visible = ($tool_visibility == 0 ) ? 1 : 0;
  337. /*
  338. -----------------------------------------------------------
  339. HIDE
  340. -----------------------------------------------------------
  341. */
  342. if(isset($_GET['visibility']) && $_GET['visibility']==0) // visibility 1 -> 0
  343. {
  344. if ($_GET["id"]==strval(intval($_GET["id"]))) {
  345. $sql="UPDATE $tool_table SET visibility=0 WHERE id='".$_GET["id"]."'";
  346. Database::query($sql,__FILE__,__LINE__);
  347. }
  348. }
  349. /*
  350. -----------------------------------------------------------
  351. REACTIVATE
  352. -----------------------------------------------------------
  353. */
  354. elseif(isset($_GET['visibility'])&& $_GET['visibility']==1) // visibility 0,2 -> 1
  355. {
  356. if ($_GET["id"]==strval(intval($_GET["id"]))) {
  357. Database::query("UPDATE $tool_table SET visibility=1 WHERE id='".$_GET["id"]."'",__FILE__,__LINE__);
  358. }
  359. }
  360. $response_data = array(
  361. 'image' => $requested_image,
  362. 'tclass' => $requested_clase,
  363. 'message' => $requested_message,
  364. 'view' => $requested_view
  365. );
  366. print(json_encode($response_data));
  367. exit;
  368. }
  369. } else {
  370. if(api_is_allowed_to_edit()) {
  371. /*
  372. -----------------------------------------------------------
  373. HIDE
  374. -----------------------------------------------------------
  375. */
  376. if(!empty($_GET['hide'])) // visibility 1 -> 0
  377. {
  378. Database::query("UPDATE $tool_table SET visibility=0 WHERE id='".$_GET["id"]."'",__FILE__,__LINE__);
  379. Display::display_confirmation_message(get_lang('ToolIsNowHidden'));
  380. }
  381. /*
  382. -----------------------------------------------------------
  383. REACTIVATE
  384. -----------------------------------------------------------
  385. */
  386. elseif(!empty($_GET['restore'])) // visibility 0,2 -> 1
  387. {
  388. Database::query("UPDATE $tool_table SET visibility=1 WHERE id='".$_GET["id"]."'",__FILE__,__LINE__);
  389. Display::display_confirmation_message(get_lang('ToolIsNowVisible'));
  390. }
  391. }
  392. }
  393. // work with data post askable by admin of course
  394. if(api_is_platform_admin())
  395. {
  396. // Show message to confirm that a tools must be hide from available tools
  397. // visibility 0,1->2
  398. if(!empty($_GET['askDelete']))
  399. {
  400. ?>
  401. <div id="toolhide">
  402. <?php echo get_lang("DelLk")?>
  403. <br />&nbsp;&nbsp;&nbsp;
  404. <a href="<?php echo api_get_self()?>"><?php echo get_lang("No")?></a>&nbsp;|&nbsp;
  405. <a href="<?php echo api_get_self()?>?delete=yes&id=<?php echo $_GET["id"]?>"><?php echo get_lang("Yes")?></a>
  406. </div>
  407. <?php
  408. }
  409. /*
  410. * Process hiding a tools from available tools.
  411. */
  412. elseif(isset($_GET["delete"]) && $_GET["delete"])
  413. {
  414. Database::query("DELETE FROM $tool_table WHERE id='$id' AND added_tool=1",__FILE__,__LINE__);
  415. }
  416. }
  417. /*
  418. ==============================================================================
  419. SESSION DATA
  420. ==============================================================================
  421. */
  422. /**
  423. * Shows the general data for a particular meeting
  424. *
  425. * @param id session id
  426. * @return string session data
  427. *
  428. */
  429. function show_session_data($id_session) {
  430. $session_table = Database::get_main_table(TABLE_MAIN_SESSION);
  431. $user_table = Database::get_main_table(TABLE_MAIN_USER);
  432. $session_category_table = Database::get_main_table(TABLE_MAIN_SESSION_CATEGORY);
  433. $sql = 'SELECT name, nbr_courses, nbr_users, nbr_classes, DATE_FORMAT(date_start,"%d-%m-%Y") as date_start, DATE_FORMAT(date_end,"%d-%m-%Y") as date_end, lastname, firstname, username, session_admin_id, nb_days_access_before_beginning, nb_days_access_after_end, session_category_id, visibility
  434. FROM '.$session_table.'
  435. LEFT JOIN '.$user_table.'
  436. ON id_coach = user_id
  437. WHERE '.$session_table.'.id='.$id_session;
  438. $rs = Database::query($sql, __FILE__, __LINE__);
  439. $session = Database::store_result($rs);
  440. $session = $session[0];
  441. $sql_category = 'SELECT name FROM '.$session_category_table.' WHERE id = "'.intval($session['session_category_id']).'"';
  442. $rs_category = Database::query($sql_category, __FILE__, __LINE__);
  443. $session_category = '';
  444. if (Database::num_rows($rs_category) > 0) {
  445. $rows_session_category = Database::store_result($rs_category);
  446. $rows_session_category = $rows_session_category[0];
  447. $session_category = $rows_session_category['name'];
  448. }
  449. if ($session['date_start'] == '00-00-0000') {
  450. $msg_date = get_lang('NoTimeLimits');
  451. } else {
  452. $msg_date = get_lang('From').' '.$session['date_start'].' '.get_lang('To').' '.$session['date_end'];
  453. }
  454. $output = '';
  455. if (!empty($session_category)) {
  456. $output .= '<tr><td>'. get_lang('SessionCategory') . ': ' . '<b>' . $session_category .'</b></td></tr>';
  457. }
  458. $output .= '<tr><td style="width:50%">'. get_lang('SessionName') . ': ' . '<b>' . $session['name'] .'</b></td><td>'. get_lang('GeneralCoach') . ': ' . '<b>' . $session['lastname'].' '.$session['firstname'].' ('.$session['username'].')' .'</b></td></tr>';
  459. $output .= '<tr><td>'. get_lang('SessionIdentifier') . ': '. Display::return_icon('star.png', ' ', array('align' => 'absmiddle')) .'</td><td>'. get_lang('Date') . ': ' . '<b>' . $msg_date .'</b></td></tr>';
  460. return $output;
  461. }
  462. /*
  463. ==============================================================================
  464. COURSE ADMIN ONLY VIEW
  465. ==============================================================================
  466. */
  467. // start of tools for CourseAdmins (teachers/tutors)
  468. if(api_is_allowed_to_edit())
  469. {
  470. $current_protocol = $_SERVER['SERVER_PROTOCOL'];
  471. $current_host = $_SERVER['HTTP_HOST'];
  472. $server_protocol = substr($current_protocol,0,strrpos($current_protocol,'/'));
  473. $server_protocol = $server_protocol.'://';
  474. if ($current_host == 'localhost') {
  475. //Get information of path
  476. $info = explode('courses',api_get_self());
  477. $path_work = substr($info[0], 0, strlen($info[0]));
  478. } else {
  479. $path_work = "";
  480. }
  481. ?>
  482. <div class="normal-message" id="id_normal_message" style="display:none"><?php echo get_lang("PleaseStandBy")."<br/>".'<img src="'.$server_protocol.$current_host.'/'.$path_work.'main/inc/lib/javascript/indicator.gif"/>'; ?></div>
  483. <div class="confirmation-message" id="id_confirmation_message" style="display:none"></div>
  484. <?php
  485. if (api_get_setting('show_session_data') === 'true' && $id_session > 0) {
  486. ?>
  487. <div class="courseadminview">
  488. <span class="viewcaption"><?php echo get_lang("SessionData") ?></span>
  489. <table width="100%">
  490. <?php echo show_session_data($id_session);?>
  491. </table>
  492. </div>
  493. <?php
  494. }
  495. ?>
  496. <div class="courseadminview">
  497. <span class="viewcaption"><?php echo get_lang("Authoring") ?></span>
  498. <table width="100%">
  499. <?php show_tools_category(TOOL_AUTHORING);?>
  500. </table>
  501. </div>
  502. <div class="courseadminview">
  503. <span class="viewcaption"><?php echo get_lang("Interaction") ?></span>
  504. <table width="100%">
  505. <?php show_tools_category(TOOL_INTERACTION); ?>
  506. </table>
  507. </div>
  508. <div class="courseadminview">
  509. <span class="viewcaption"><?php echo get_lang("Administration") ?></span>
  510. <table width="100%">
  511. <?php show_tools_category(TOOL_ADMIN_PLATEFORM); ?>
  512. </table>
  513. </div>
  514. <?php
  515. } elseif (api_is_coach()) {
  516. if (api_get_setting('show_session_data') === 'true' && $id_session > 0) {
  517. ?>
  518. <div class="courseadminview">
  519. <span class="viewcaption"><?php echo get_lang("SessionData") ?></span>
  520. <table width="100%">
  521. <?php echo show_session_data($id_session);?>
  522. </table>
  523. </div>
  524. <?php
  525. }
  526. ?>
  527. <div class="Authoringview">
  528. <table width="100%">
  529. <?php show_tools_category(TOOL_STUDENT_VIEW); ?>
  530. </table>
  531. </div>
  532. <?php
  533. /*
  534. ==============================================================================
  535. TOOLS AUTHORING
  536. ==============================================================================
  537. */
  538. } else {
  539. ?>
  540. <div class="Authoringview">
  541. <table width="100%">
  542. <?php show_tools_category(TOOL_STUDENT_VIEW); ?>
  543. </table>
  544. </div>
  545. <?php
  546. }
  547. ?>