activity.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515
  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. $web_code_path = api_get_path(WEB_CODE_PATH);
  49. $course_tool_table = Database::get_course_table(TABLE_TOOL_LIST);
  50. $is_allowed_to_edit = api_is_allowed_to_edit();
  51. $is_platform_admin = api_is_platform_admin();
  52. switch ($course_tool_category)
  53. {
  54. case TOOL_STUDENT_VIEW:
  55. $result = api_sql_query("SELECT * FROM $course_tool_table WHERE visibility = '1' AND (category = 'authoring' OR category = 'interaction') ORDER BY id",__FILE__,__LINE__);
  56. $colLink ="##003399";
  57. break;
  58. case TOOL_AUTHORING:
  59. $result = api_sql_query("SELECT * FROM $course_tool_table WHERE category = 'authoring' ORDER BY id",__FILE__,__LINE__);
  60. $colLink ="##003399";
  61. break;
  62. case TOOL_INTERACTION:
  63. $result = api_sql_query("SELECT * FROM $course_tool_table WHERE category = 'interaction' ORDER BY id",__FILE__,__LINE__);
  64. $colLink ="##003399";
  65. break;
  66. case TOOL_ADMIN_VISIBLE:
  67. $result = api_sql_query("SELECT * FROM $course_tool_table WHERE category = 'admin' AND visibility ='1' ORDER BY id",__FILE__,__LINE__);
  68. $colLink ="##003399";
  69. break;
  70. case TOOL_ADMIN_PLATEFORM:
  71. $result = api_sql_query("SELECT * FROM $course_tool_table WHERE category = 'admin' ORDER BY id",__FILE__,__LINE__);
  72. $colLink ="##003399";
  73. break;
  74. }
  75. while ($temp_row = Database::fetch_array($result))
  76. {
  77. $all_tools_list[]=$temp_row;
  78. }
  79. /*if(api_is_course_coach())
  80. {
  81. $result = api_sql_query("SELECT * FROM $course_tool_table WHERE name='tracking'",__FILE__,__LINE__);
  82. $all_tools_list[]=Database :: fetch_array($result);
  83. }*/
  84. $i=0;
  85. // grabbing all the links that have the property on_homepage set to 1
  86. $course_link_table = Database::get_course_table(TABLE_LINK);
  87. $course_item_property_table = Database::get_course_table(TABLE_ITEM_PROPERTY);
  88. switch ($course_tool_category)
  89. {
  90. case TOOL_AUTHORING:
  91. $sql_links="SELECT tl.*, tip.visibility
  92. FROM $course_link_table tl
  93. LEFT JOIN $course_item_property_table tip ON tip.tool='link' AND tip.ref=tl.id
  94. WHERE tl.on_homepage='1'";
  95. break;
  96. case TOOL_INTERACTION:
  97. $sql_links = null;
  98. /*
  99. $sql_links="SELECT tl.*, tip.visibility
  100. FROM $course_link_table tl
  101. LEFT JOIN $course_item_property_table tip ON tip.tool='link' AND tip.ref=tl.id
  102. WHERE tl.on_homepage='1' ";
  103. */
  104. break;
  105. case TOOL_STUDENT_VIEW:
  106. $sql_links="SELECT tl.*, tip.visibility
  107. FROM $course_link_table tl
  108. LEFT JOIN $course_item_property_table tip ON tip.tool='link' AND tip.ref=tl.id
  109. WHERE tl.on_homepage='1'";
  110. break;
  111. case TOOL_ADMIN:
  112. $sql_links="SELECT tl.*, tip.visibility
  113. FROM $course_link_table tl
  114. LEFT JOIN $course_item_property_table tip ON tip.tool='link' AND tip.ref=tl.id
  115. WHERE tl.on_homepage='1'";
  116. break;
  117. default:
  118. $sql_links = null;
  119. break;
  120. }
  121. //edit by Kevin Van Den Haute (kevin@develop-it.be) for integrating Smartblogs
  122. if($sql_links != null)
  123. {
  124. $result_links = api_sql_query($sql_links,__FILE__,__LINE__);
  125. $properties = array();
  126. while($links_row = Database::fetch_array($result_links))
  127. {
  128. unset($properties);
  129. $properties['name'] = $links_row['title'];
  130. $properties['link'] = $links_row['url'];
  131. $properties['visibility'] = $links_row['visibility'];
  132. $properties['image'] = ($links_row['visibility']== '0') ? "file_html.gif" : "file_html.gif";
  133. $properties['adminlink'] = api_get_path(WEB_CODE_PATH) . "link/link.php?action=editlink&id=".$links_row['id'];
  134. $properties['target'] = $links_row['target'];
  135. $tmp_all_tools_list[] = $properties;
  136. }
  137. }
  138. if(isset($tmp_all_tools_list))
  139. {
  140. foreach($tmp_all_tools_list as $toolsRow)
  141. {
  142. if($toolsRow['image'] == 'blog.gif')
  143. {
  144. // Init
  145. $tbl_blogs_rel_user = Database::get_course_table(TABLE_BLOGS_REL_USER);
  146. // Get blog id
  147. $blog_id = substr($toolsRow['link'], strrpos($toolsRow['link'], '=') + 1, strlen($toolsRow['link']));
  148. // Get blog members
  149. if($is_platform_admin)
  150. {
  151. $sql_blogs = "
  152. SELECT *
  153. FROM " . $tbl_blogs_rel_user . " `blogs_rel_user`
  154. WHERE `blog_id` = " . $blog_id;
  155. }
  156. else
  157. {
  158. $sql_blogs = "
  159. SELECT *
  160. FROM " . $tbl_blogs_rel_user . " `blogs_rel_user`
  161. WHERE
  162. `blog_id` = " . $blog_id . " AND
  163. `user_id` = " . api_get_user_id();
  164. }
  165. $result_blogs = api_sql_query($sql_blogs, __FILE__, __LINE__);
  166. if(Database::num_rows($result_blogs) > 0)
  167. $all_tools_list[] = $toolsRow;
  168. }
  169. else
  170. $all_tools_list[] = $toolsRow;
  171. }
  172. }
  173. if(isset($all_tools_list))
  174. {
  175. $lnk = '';
  176. foreach($all_tools_list as $toolsRow)
  177. {
  178. if(!($i%2))
  179. {echo "<tr valign=\"top\">\n";}
  180. // This part displays the links to hide or remove a tool.
  181. // These links are only visible by the course manager.
  182. unset($lnk);
  183. echo '<td width="50%">' . "\n";
  184. if($is_allowed_to_edit)
  185. {
  186. if($toolsRow['visibility'] == '1' && $toolsRow['admin'] !='1')
  187. {
  188. $link['name'] = Display::return_icon('visible.gif', get_lang('Deactivate'),array('id'=>'linktool_'.$toolsRow["id"]));
  189. $link['cmd'] = "hide=yes";
  190. $lnk[] = $link;
  191. }
  192. if($toolsRow['visibility'] == '0' && $toolsRow['admin'] !='1')
  193. {
  194. $link['name'] = Display::return_icon('invisible.gif', get_lang('Activate'),array('id'=>'linktool_'.$toolsRow["id"]));
  195. $link['cmd'] = "restore=yes";
  196. $lnk[] = $link;
  197. }
  198. if(!empty($toolsRow['adminlink']))
  199. {
  200. echo '<a href="'.$toolsRow['adminlink'].'">'.Display::return_icon('edit.gif', get_lang('Edit')).'</a>';
  201. }
  202. }
  203. // Both checks are necessary as is_platform_admin doesn't take student view into account
  204. if( $is_platform_admin && $is_allowed_to_edit)
  205. {
  206. if($toolsRow['admin'] !='1')
  207. {
  208. $link['cmd'] = "hide=yes";
  209. }
  210. }
  211. if(isset($lnk) && is_array($lnk))
  212. {
  213. foreach($lnk as $this_link)
  214. {
  215. if(empty($toolsRow['adminlink']))
  216. {
  217. 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>";
  218. //echo "<a class=\"make_visible_and_invisible\" href=\"javascript:void(0)\" >" . $this_link['name'] . "</a>";
  219. }
  220. }
  221. }
  222. else{ echo '&nbsp;&nbsp;&nbsp;&nbsp;';}
  223. // NOTE : table contains only the image file name, not full path
  224. if(!stristr($toolsRow['link'], 'http://') && !stristr($toolsRow['link'], 'https://') && !stristr($toolsRow['link'],'ftp://'))
  225. $toolsRow['link'] = $web_code_path . $toolsRow['link'];
  226. if($toolsRow['visibility'] == '0' && $toolsRow['admin'] != '1')
  227. {
  228. $class="class=\"invisible\"";
  229. $info = pathinfo($toolsRow['image']);
  230. $basename = basename ($toolsRow['image'],'.'.$info['extension']); // $file is set to "index"
  231. $toolsRow['image'] = $basename.'_na.'.$info['extension'];
  232. }
  233. else
  234. $class='';
  235. $qm_or_amp = ((strpos($toolsRow['link'], '?') === FALSE) ? '?' : '&amp;');
  236. //If it's a link, we don't add the cidReq
  237. if($toolsRow['image'] == 'file_html.gif' || $toolsRow['image'] == 'file_html_na.gif'){
  238. $toolsRow['link'] = $toolsRow['link'].$qm_or_amp;
  239. }
  240. else{
  241. $toolsRow['link'] = $toolsRow['link'].$qm_or_amp.api_get_cidreq();
  242. }
  243. if(strpos($toolsRow['name'],'visio_')!==false) {
  244. /*
  245. $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'] . '">';
  246. */
  247. $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'] . '">';
  248. $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'] . '">';
  249. } else if(strpos($toolsRow['name'],'chat')!==false && api_get_course_setting('allow_open_chat_window')==true) {
  250. /*
  251. $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'] . '">';
  252. */
  253. $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'] . '">';
  254. $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'] . '">';
  255. } else {
  256. if (count(explode('type=classroom',$toolsRow['link']))==2 || count(explode('type=conference',$toolsRow['link']))==2) {
  257. //$toollink = "\t" . '<a ' . $class . ' href="' . $toolsRow['link'] . '" target="_blank">';
  258. $toollink = "\t" . '<a id="tooldesc_'.$toolsRow["id"].'" ' . $class . ' href="' . $toolsRow['link'] . '" target="_blank">';
  259. $my_tool_link = "\t" . '<a id="istooldesc_'.$toolsRow["id"].'" ' . $class . ' href="' . $toolsRow['link'] . '" target="_blank">';
  260. } else {
  261. //$toollink = "\t" . '<a ' . $class . ' href="' . htmlspecialchars($toolsRow['link']) . '" target="' . $toolsRow['target'] . '">';
  262. $toollink = "\t" . '<a id="tooldesc_'.$toolsRow["id"].'" ' . $class . ' href="' . htmlspecialchars($toolsRow['link']) . '" target="' . $toolsRow['target'] . '">';
  263. $my_tool_link = "\t" . '<a id="istooldesc_'.$toolsRow["id"].'" ' . $class . ' href="' . htmlspecialchars($toolsRow['link']) . '" target="' . $toolsRow['target'] . '">';
  264. }
  265. }
  266. echo $toollink;
  267. //var_dump($toollink);
  268. /*
  269. Display::display_icon($toolsRow['image'], get_lang(ucfirst($toolsRow['name'])));
  270. */
  271. if ($toolsRow['image'] == 'file_html.gif' || $toolsRow['image'] == 'file_html_na.gif'
  272. || $toolsRow['image'] == 'scormbuilder.gif' || $toolsRow['image'] == 'scormbuilder_na.gif'
  273. || $toolsRow['image'] == 'blog.gif' || $toolsRow['image'] == 'blog_na.gif'
  274. || $toolsRow['image'] == 'external.gif' || $toolsRow['image'] == 'external_na.gif')
  275. {
  276. $tool_name = stripslashes($toolsRow['name']);
  277. } else {
  278. $tool_name = get_lang(ucfirst($toolsRow['name']));
  279. }
  280. Display::display_icon($toolsRow['image'], $tool_name, array('class'=>'tool-icon','id'=>'toolimage_'.$toolsRow["id"]));
  281. echo '</a> ';
  282. echo $my_tool_link;
  283. /*
  284. 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']));
  285. */
  286. echo $tool_name;
  287. echo "\t" . '</a>';
  288. echo '</td>';
  289. if($i%2)
  290. {
  291. echo "</tr>";
  292. }
  293. $i++;
  294. }
  295. }
  296. if($i%2)
  297. {
  298. echo "<td width=\"50%\">&nbsp;</td>\n",
  299. "</tr>\n";
  300. }
  301. }
  302. //End of functions show tools
  303. /*
  304. ==============================================================================
  305. MAIN CODE
  306. ==============================================================================
  307. */
  308. /*
  309. -----------------------------------------------------------
  310. Work with data post askable by admin of course (franglais, clean this)
  311. -----------------------------------------------------------
  312. */
  313. if (isset($_GET['sent_http_request']) && $_GET['sent_http_request']==1) {
  314. if(api_is_allowed_to_edit()) {
  315. $tool_table = Database::get_course_table(TABLE_TOOL_LIST);
  316. /*
  317. -----------------------------------------------------------
  318. HIDE
  319. -----------------------------------------------------------
  320. */
  321. if(isset($_GET['visibility']) && $_GET['visibility']==0) // visibility 1 -> 0
  322. {
  323. if ($_GET["id"]==strval(intval($_GET["id"]))) {
  324. $sql="UPDATE $tool_table SET visibility=0 WHERE id='".$_GET["id"]."'";
  325. api_sql_query($sql,__FILE__,__LINE__);
  326. echo 'ToolIsNowHidden';
  327. }
  328. }
  329. /*
  330. -----------------------------------------------------------
  331. REACTIVATE
  332. -----------------------------------------------------------
  333. */
  334. elseif(isset($_GET['visibility'])&& $_GET['visibility']==1) // visibility 0,2 -> 1
  335. {
  336. if ($_GET["id"]==strval(intval($_GET["id"]))) {
  337. api_sql_query("UPDATE $tool_table SET visibility=1 WHERE id='".$_GET["id"]."'",__FILE__,__LINE__);
  338. echo 'ToolIsNowVisible';
  339. }
  340. }
  341. exit;
  342. }
  343. } else {
  344. if(api_is_allowed_to_edit()) {
  345. /*
  346. -----------------------------------------------------------
  347. HIDE
  348. -----------------------------------------------------------
  349. */
  350. if(!empty($_GET['hide'])) // visibility 1 -> 0
  351. {
  352. api_sql_query("UPDATE $tool_table SET visibility=0 WHERE id='".$_GET["id"]."'",__FILE__,__LINE__);
  353. Display::display_confirmation_message(get_lang('ToolIsNowHidden'));
  354. }
  355. /*
  356. -----------------------------------------------------------
  357. REACTIVATE
  358. -----------------------------------------------------------
  359. */
  360. elseif(!empty($_GET['restore'])) // visibility 0,2 -> 1
  361. {
  362. api_sql_query("UPDATE $tool_table SET visibility=1 WHERE id='".$_GET["id"]."'",__FILE__,__LINE__);
  363. Display::display_confirmation_message(get_lang('ToolIsNowVisible'));
  364. }
  365. }
  366. }
  367. // work with data post askable by admin of course
  368. if(api_is_platform_admin())
  369. {
  370. // Show message to confirm that a tools must be hide from available tools
  371. // visibility 0,1->2
  372. if(!empty($_GET['askDelete']))
  373. {
  374. ?>
  375. <div id="toolhide">
  376. <?php echo get_lang("DelLk")?>
  377. <br />&nbsp;&nbsp;&nbsp;
  378. <a href="<?php echo api_get_self()?>"><?php echo get_lang("No")?></a>&nbsp;|&nbsp;
  379. <a href="<?php echo api_get_self()?>?delete=yes&id=<?php echo $_GET["id"]?>"><?php echo get_lang("Yes")?></a>
  380. </div>
  381. <?php
  382. }
  383. /*
  384. * Process hiding a tools from available tools.
  385. */
  386. elseif(isset($_GET["delete"]) && $_GET["delete"])
  387. {
  388. api_sql_query("DELETE FROM $tool_table WHERE id='$id' AND added_tool=1",__FILE__,__LINE__);
  389. }
  390. }
  391. /*
  392. ==============================================================================
  393. COURSE ADMIN ONLY VIEW
  394. ==============================================================================
  395. */
  396. // start of tools for CourseAdmins (teachers/tutors)
  397. if(api_is_allowed_to_edit())
  398. {
  399. ?>
  400. <div class="normal-message" id="id_normal_message" style="display:none"><?php echo get_lang("PleaseStandBy")."<br/>"; ?></div>
  401. <div class="confirmation-message" id="id_confirmation_message" style="display:none"></div>
  402. <div class="courseadminview">
  403. <span class="viewcaption"><?php echo get_lang("Authoring") ?></span>
  404. <table width="100%">
  405. <?php show_tools_category(TOOL_AUTHORING);?>
  406. </table>
  407. </div>
  408. <div class="courseadminview">
  409. <span class="viewcaption"><?php echo get_lang("Interaction") ?></span>
  410. <table width="100%">
  411. <?php show_tools_category(TOOL_INTERACTION); ?>
  412. </table>
  413. </div>
  414. <div class="courseadminview">
  415. <span class="viewcaption"><?php echo get_lang("Administration") ?></span>
  416. <table width="100%">
  417. <?php show_tools_category(TOOL_ADMIN_PLATEFORM); ?>
  418. </table>
  419. </div>
  420. <?php
  421. }
  422. /*
  423. ==============================================================================
  424. TOOLS AUTHORING
  425. ==============================================================================
  426. */
  427. else{
  428. ?>
  429. <div class="Authoringview">
  430. <table width="100%">
  431. <?php show_tools_category(TOOL_STUDENT_VIEW); ?>
  432. </table>
  433. </div>
  434. <?php
  435. }
  436. ?>