work.lib.php 68 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.work
  5. * @author Thomas, Hugues, Christophe - original version
  6. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University - ability for course admins to specify wether uploaded documents are visible or invisible by default.
  7. * @author Roan Embrechts, code refactoring and virtual course support
  8. * @author Frederic Vauthier, directories management
  9. * @version $Id: work.lib.php 22357 2009-07-24 17:44:17Z juliomontoya $
  10. * @todo this lib should be convert in a static class and moved to main/inc/lib
  11. */
  12. /**
  13. * Initialization
  14. */
  15. require_once api_get_path(SYS_CODE_PATH).'document/document.inc.php';
  16. require_once api_get_path(LIBRARY_PATH).'fileDisplay.lib.php';
  17. /**
  18. * Displays action links (for admins, authorized groups members and authorized students)
  19. * @param string Current dir
  20. * @param integer Whether to show tool options
  21. * @param integer Whether to show upload form option
  22. * @return void
  23. */
  24. function display_action_links($cur_dir_path, $always_show_tool_options, $always_show_upload_form) {
  25. global $gradebook;
  26. $display_output = '';
  27. $origin = isset($_GET['origin']) ? Security::remove_XSS($_GET['origin']) : '';
  28. $curdirpath = isset($_GET['curdirpath']) ? Security::remove_XSS($_GET['curdirpath']) : empty($curdirpath);
  29. ///why is that here?
  30. //$origin = api_get_tools_lists($origin);
  31. echo '<div class="actions">';
  32. if (strlen($cur_dir_path) > 0 && $cur_dir_path != '/') {
  33. $parent_dir = dirname($cur_dir_path);
  34. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&origin='.$origin.'&gradebook='.$gradebook.'&curdirpath='.$parent_dir.'">'.Display::return_icon('back.png', get_lang('BackToWorksList'),'','32').'</a>';
  35. } else {
  36. if ($_GET['display_tool_options'] == 'true' OR $_GET['display_upload_form'] == 'true') {
  37. if ($origin != 'learnpath') {
  38. echo '<a href="work.php?gradebook='.$gradebook.'">'.Display::return_icon('back.png', get_lang('BackToWorksList'),'','32').'</a>';
  39. }
  40. }
  41. }
  42. if (!$always_show_tool_options && api_is_allowed_to_edit(null, true) && $origin != 'learnpath') {
  43. // Create dir
  44. if ($cur_dir_path == '/') {
  45. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;toolgroup='.Security::remove_XSS($_GET['toolgroup']).'&amp;createdir=1&origin='.$origin.'&gradebook='.$gradebook.'">'.Display::return_icon('new_work.png', get_lang('CreateAssignment'),'','32').'</a>';
  46. }
  47. // Options
  48. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;display_tool_options=true&amp;origin='.$origin.'&amp;gradebook='.$gradebook.'">'.Display::return_icon('settings.png', get_lang('EditToolOptions'),'','32').'</a>';
  49. }
  50. if (!$always_show_upload_form && api_is_allowed_to_session_edit(false, true) && (isset($_GET['curdirpath']) && (!empty($_GET['curdirpath']) && $_GET['curdirpath'] != '.') )) {
  51. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;curdirpath='.$cur_dir_path.'&amp;display_upload_form=true&amp;origin='.$origin.'&amp;gradebook='.$gradebook.'">'.Display::return_icon('upload_file.png', get_lang('UploadADocument'),'','32').'</a>';
  52. }
  53. if (api_is_allowed_to_edit(null, true) && $origin != 'learnpath' && api_is_allowed_to_session_edit(false, true)) {
  54. // delete all files
  55. if (api_get_setting('permanently_remove_deleted_files') == 'true'){
  56. $message = get_lang('ConfirmYourChoiceDeleteAllfiles');
  57. } else {
  58. $message = get_lang('ConfirmYourChoice');
  59. }
  60. if (empty($curdirpath) or $curdirpath != '.') {
  61. $display_output .= '<a href="#">'.Display::return_icon('delete_na.png', get_lang('Delete'),'','32').'</a>';
  62. } else {
  63. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;curdirpath='.$cur_dir_path.'&amp;origin='.$origin.'&amp;gradebook='.$gradebook.'&amp;delete=all" onclick="javascript: if(!confirm(\''.addslashes(api_htmlentities($message, ENT_QUOTES)).'\')) return false;">'.
  64. Display::return_icon('delete.png', get_lang('Delete'),'','32').'</a>';
  65. }
  66. // make all files visible or invisible
  67. $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  68. $sql_query = "SHOW COLUMNS FROM ".$work_table." LIKE 'accepted'";
  69. $sql_result = Database::query($sql_query);
  70. if ($sql_result) {
  71. $columnStatus = Database::fetch_array($sql_result);
  72. if ($columnStatus['Default'] == 1) {
  73. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;origin='.$origin.'&amp;gradebook='.$gradebook.'&amp;make_invisible=all&amp;curdirpath='.$cur_dir_path.'">'.
  74. Display::return_icon('visible.png', get_lang('MakeAllPapersInvisible'),'','32')."</a>\n";
  75. } else {
  76. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;origin='.$origin.'&amp;gradebook='.$gradebook.'&amp;make_visible=all&amp;curdirpath='.$cur_dir_path.'">'.
  77. Display::return_icon('invisible.png', get_lang('MakeAllPapersVisible'),'','32')."</a>\n";
  78. }
  79. }
  80. }
  81. if (api_is_allowed_to_edit(null, true)) {
  82. global $publication;
  83. if (empty($curdirpath) or $curdirpath != '.' or $cur_dir_path != '/') {
  84. if (empty($_GET['list']) or Security::remove_XSS($_GET['list']) == 'with') {
  85. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;curdirpath='.$cur_dir_path.'&amp;origin='.$origin.'&amp;gradebook='.$gradebook.'&amp;list=without">'.
  86. Display::return_icon('exercice_uncheck.png', get_lang('ViewUsersWithoutTask'),'','32')."</a>\n";
  87. } else {
  88. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;curdirpath='.$cur_dir_path.'&amp;origin='.$origin.'&amp;gradebook='.$gradebook.'&amp;list=with">'.
  89. Display::return_icon('exercice_check.png', get_lang('ViewUsersWithTask'),'','32')."</a>\n";
  90. $_SESSION['token'] = time();
  91. $display_output .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&amp;curdirpath='.$cur_dir_path.'&amp;origin='.$origin.'&amp;gradebook='.$gradebook.'&amp;list=without&amp;action=send_mail&amp;sec_token='.$_SESSION['token'].'">'.
  92. Display::return_icon('mail_send.png', get_lang('ReminderMessage'),'','32')."</a>";
  93. }
  94. }
  95. }
  96. if ($display_output != '') {
  97. echo $display_output;
  98. }
  99. echo '</div>';
  100. }
  101. /**
  102. * Displays all options for this tool.
  103. * These are
  104. * - make all files visible / invisible
  105. * - set the default visibility of uploaded files
  106. *
  107. * @param $uploadvisibledisabled
  108. * @param $origin
  109. * @param $base_work_dir Base working directory (up to '/work')
  110. * @param $cur_dir_path Current subdirectory of 'work/'
  111. * @param $cur_dir_path_url Current subdirectory of 'work/', url-encoded
  112. */
  113. function display_tool_options($uploadvisibledisabled, $origin, $base_work_dir, $cur_dir_path, $cur_dir_path_url) {
  114. global $group_properties, $gradebook;
  115. $is_allowed_to_edit = api_is_allowed_to_edit(null, true);
  116. $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  117. if (!$is_allowed_to_edit) {
  118. return;
  119. }
  120. echo '<form method="post" action="'.api_get_self().'?origin='.$origin.'&gradebook='.$gradebook.'&display_tool_options=true">';
  121. echo '<div class="row"><div class="form_header">'.get_lang('EditToolOptions').'</div></div>';
  122. display_default_visibility_form($uploadvisibledisabled);
  123. display_studentsdelete_form();
  124. echo '<div class="row">
  125. <div class="formw">
  126. <button type="submit" class="save" name="changeProperties" value="'.get_lang('Ok').'">'.get_lang('Ok').'</button>
  127. </div>
  128. </div>';
  129. echo '</form>';
  130. }
  131. /**
  132. * Displays the form where course admins can specify wether uploaded documents
  133. * are visible or invisible by default.
  134. *
  135. * @param $uploadvisibledisabled
  136. * @param $origin
  137. */
  138. function display_default_visibility_form($uploadvisibledisabled) {
  139. ?>
  140. <div class="row">
  141. <div class="label">
  142. <?php echo get_lang('_default_upload'); ?>
  143. </div>
  144. <div class="formw">
  145. <input class="checkbox" type="radio" name="uploadvisibledisabled" value="0" <?php if ($uploadvisibledisabled == 0) echo 'checked'; ?> />
  146. <?php echo get_lang('_new_visible'); ?><br />
  147. <input class="checkbox" type="radio" name="uploadvisibledisabled" value="1" <?php if ($uploadvisibledisabled == 1) echo 'checked'; ?> />
  148. <?php echo get_lang('_new_unvisible'); ?>
  149. </div>
  150. </div>
  151. <?php
  152. }
  153. /**
  154. * Display a part of the form to edit the settings of the tool
  155. * In this case weither the students are allowed to delete their own publication or not (by default not)
  156. *
  157. * @return html code
  158. * @since Dokeos 1.8.6.2
  159. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
  160. */
  161. function display_studentsdelete_form() {
  162. // by default api_get_course_setting returns -1 and the code only expects 0 or 1 so anything tha
  163. // is different than 1 will be converted into 0
  164. $current_course_setting_value = api_get_course_setting('student_delete_own_publication');
  165. if ($current_course_setting_value != 1) {
  166. $current_course_setting_value = 0;
  167. }
  168. ?>
  169. <div class="row">
  170. <div class="label">
  171. <?php echo get_lang('StudentAllowedToDeleteOwnPublication'); ?>
  172. </div>
  173. <div class="formw">
  174. <input class="checkbox" type="radio" name="student_delete_own_publication" value="0" <?php if ($current_course_setting_value == 0) echo 'checked'; ?> />
  175. <?php echo get_lang('No'); ?><br />
  176. <input class="checkbox" type="radio" name="student_delete_own_publication" value="1" <?php if ($current_course_setting_value == 1) echo 'checked'; ?> />
  177. <?php echo get_lang('Yes'); ?>
  178. </div>
  179. </div>
  180. <?php
  181. }
  182. /**
  183. * This function displays the firstname and lastname of the user as a link to the user tool.
  184. *
  185. * @see this is the same function as in the new forum, so this probably has to move to a user library.
  186. *
  187. * @todo move this function to the user library
  188. *
  189. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
  190. * @version march 2006
  191. */
  192. function display_user_link_work($user_id, $name = '') {
  193. global $_otherusers;
  194. $user_id = intval($user_id);
  195. if ($user_id != 0) {
  196. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  197. $sql = "SELECT user_id, firstname, lastname FROM $table_user WHERE user_id='".Database::escape_string($user_id)."'";
  198. $result = Database::query($sql);
  199. $row = Database::fetch_array($result);
  200. if ($name == '') {
  201. return '<a href="../user/userInfo.php?cidReq='.api_get_course_id().'&amp;gradebook='.$gradebook.'&amp;origin=&amp;uInfo='.$row['user_id'].'">'.api_get_person_name($row['firstname'], $row['lastname']).'</a>';
  202. } else {
  203. return '<a href="../user/userInfo.php?cidReq='.api_get_course_id().'&amp;gradebook='.$gradebook.'&amp;origin=&amp;uInfo='.$user_id.'">'.$name.'</a>';
  204. }
  205. } else {
  206. return $name.' ('.get_lang('Anonymous').')';
  207. }
  208. }
  209. /**
  210. * converts 2008-10-06 12:45:00 to timestamp
  211. */
  212. function convert_date_to_number($default) {
  213. // 2008-10-12 00:00:00 ---to--> 12345672218 (timestamp)
  214. $parts = split(' ', $default);
  215. list($d_year, $d_month, $d_day) = split('-', $parts[0]);
  216. list($d_hour, $d_minute, $d_second) = split(':', $parts[1]);
  217. return mktime((int)$d_hour, (int)$d_minute, (int)$d_second, (int)$d_month, (int)$d_day, (int)$d_year);
  218. }
  219. /**
  220. * converts 1-9 to 01-09
  221. */
  222. function two_digits($number) {
  223. $number = (int)$number;
  224. return ($number < 10) ? '0'.$number : $number;
  225. }
  226. /**
  227. * converts 2008-10-06 12:45:00 to -> array($data'year'=>2008,$data'month'=>10 etc...)
  228. */
  229. function convert_date_to_array($date, $group) {
  230. $parts = split(' ', $date);
  231. $date_parts = split('-', $parts[0]);
  232. $date_parts_tmp = array();
  233. foreach ($date_parts as $item) {
  234. $date_parts_tmp[] = intval($item);
  235. }
  236. $time_parts = split(':', $parts[1]);
  237. $time_parts_tmp = array();
  238. foreach ($time_parts as $item) {
  239. $time_parts_tmp[] = intval($item);
  240. }
  241. list($data[$group.'[year]'], $data[$group.'[month]'], $data[$group.'[day]']) = $date_parts_tmp;
  242. list($data[$group.'[hour]'], $data[$group.'[minute]']) = $time_parts_tmp;
  243. return $data;
  244. }
  245. /**
  246. * get date from a group of date
  247. */
  248. function get_date_from_group($group) {
  249. return $_POST[$group]['year'].'-'.two_digits($_POST[$group]['month']).'-'.two_digits($_POST[$group]['day']).' '.two_digits($_POST[$group]['hour']).':'.two_digits($_POST[$group]['minute']).':00';
  250. }
  251. /**
  252. * create a group of select from a date
  253. */
  254. function create_group_date_select($prefix = '') {
  255. $minute = range(10, 59);
  256. $d_year = date('Y');
  257. array_unshift($minute, '00', '01', '02', '03', '04', '05', '06', '07', '08', '09');
  258. $group_name[] = FormValidator :: createElement('select', $prefix.'day', '', array_combine(range(1, 31), range(1, 31)));
  259. $group_name[] = FormValidator :: createElement('select', $prefix.'month', '', array_combine(range(1, 12), api_get_months_long()));
  260. $group_name[] = FormValidator :: createElement('select', $prefix.'year', '', array($d_year => $d_year, $d_year + 1 => $d_year + 1));
  261. $group_name[] = FormValidator :: createElement('select', $prefix.'hour', '', array_combine(range(0, 23), range(0, 23)));
  262. $group_name[] = FormValidator :: createElement('select', $prefix.'minute', '', $minute);
  263. return $group_name;
  264. }
  265. /**
  266. * Display the list of student publications, taking into account the user status
  267. *
  268. * @param $currentCourseRepositoryWeb, the web location of the course folder
  269. * @param $link_target_parameter - should there be a target parameter for the links
  270. * @param $dateFormatLong - date format
  271. * @param $origin - typically empty or 'learnpath'
  272. */
  273. function display_student_publications_list($work_dir, $sub_course_dir, $currentCourseRepositoryWeb, $link_target_parameter, $dateFormatLong, $origin, $add_in_where_query = '') {
  274. global $timeNoSecFormat, $dateFormatShort, $gradebook, $_user;
  275. // Database table names
  276. $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  277. $iprop_table = Database::get_course_table(TABLE_ITEM_PROPERTY);
  278. $work_assigment = Database :: get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT);
  279. $is_allowed_to_edit = api_is_allowed_to_edit(null, true);
  280. $user_id = api_get_user_id();
  281. $publications_list = array();
  282. $sort_params = array();
  283. if (isset($_GET['column'])) {
  284. $sort_params[] = 'column='.Security::remove_XSS($_GET['column']);
  285. }
  286. if (isset($_GET['page_nr'])) {
  287. $sort_params[] = 'page_nr='.Security::remove_XSS($_GET['page_nr']);
  288. }
  289. if (isset($_GET['per_page'])) {
  290. $sort_params[] = 'per_page='.Security::remove_XSS($_GET['per_page']);
  291. }
  292. if (isset($_GET['direction'])) {
  293. $sort_params[] = 'direction='.Security::remove_XSS($_GET['direction']);
  294. }
  295. $sort_params = implode('&amp;', $sort_params);
  296. $my_params = $sort_params;
  297. $origin = Security::remove_XSS($origin);
  298. if (substr($sub_course_dir, -1, 1) != '/' && !empty($sub_course_dir)) {
  299. $sub_course_dir = $sub_course_dir.'/';
  300. }
  301. if ($sub_course_dir == '/') {
  302. $sub_course_dir = '';
  303. }
  304. //condition for the session
  305. $session_id = api_get_session_id();
  306. $condition_session = api_get_session_condition($session_id);
  307. //Get list from database
  308. if ($is_allowed_to_edit) {
  309. $sql_get_publications_list = "SELECT * " .
  310. "FROM ".$work_table." " .
  311. "WHERE url LIKE BINARY '$sub_course_dir%' " .
  312. "AND url NOT LIKE BINARY '$sub_course_dir%/%' " .$add_in_where_query.
  313. $condition_session.
  314. " ORDER BY sent_date DESC";
  315. $sql_get_publications_num = "SELECT count(*) " .
  316. "FROM ".$work_table." " .
  317. "WHERE url LIKE BINARY '$sub_course_dir%' " .
  318. "AND url NOT LIKE BINARY '$sub_course_dir%/%' " .$add_in_where_query.
  319. $condition_session.
  320. " ORDER BY id";
  321. } else {
  322. if (!empty($_SESSION['toolgroup'])) {
  323. $group_query = " WHERE post_group_id = '".intval($_SESSION['toolgroup'])."' "; // set to select only messages posted by the user's group
  324. $subdirs_query = "AND url NOT LIKE BINARY '$sub_course_dir%/%' AND url LIKE BINARY '$sub_course_dir%'";
  325. } else {
  326. $group_query = " WHERE post_group_id = '0' ";
  327. $subdirs_query = "AND url NOT LIKE '$sub_course_dir%/%' AND url LIKE '$sub_course_dir%'";
  328. }
  329. $sql_get_publications_list = "SELECT * FROM $work_table $group_query $subdirs_query ".$add_in_where_query." $condition_session ORDER BY id";
  330. $sql_get_publications_num = "SELECT count(url) " .
  331. "FROM ".$work_table." " .
  332. "WHERE url LIKE BINARY '$sub_course_dir%' " .
  333. "AND url NOT LIKE BINARY '$sub_course_dir%/%' " .$add_in_where_query.
  334. $condition_session.
  335. " ORDER BY id";
  336. }
  337. // echo $sql_get_publications_list;
  338. $sql_result = Database::query($sql_get_publications_list);
  339. $sql_result_num = Database::query($sql_get_publications_num);
  340. $row = Database::fetch_array($sql_result_num);
  341. $count_files = $row[0];
  342. $table_header[] = array(get_lang('Type'), false, 'style="width:40px"');
  343. $table_header[] = array(get_lang('Title'), true);
  344. if ($count_files != 0) {
  345. $table_header[] = array(get_lang('Authors'), true);
  346. $table_header[] = array(get_lang('Qualification'), true);
  347. }
  348. $table_header[] = array(get_lang('Date'), true);
  349. if ($origin != 'learnpath') {
  350. $table_header[] = array(get_lang('Modify'), false);
  351. $table_header[] = array('RealDate', true);
  352. }
  353. // An array with the setting of the columns -> 1: columns that we will show, 0:columns that will be hide
  354. $column_show[] = 1; // type
  355. $column_show[] = 1; // title
  356. if ($count_files != 0) {
  357. $column_show[] = 1; // authors
  358. $column_show[] = 1; // qualification
  359. }
  360. $column_show[] = 1; //date
  361. $column_show[] = 1; // modify
  362. $column_show[] = 0; //real date in correct format
  363. // Here we change the way how the colums are going to be sort
  364. // in this case the the column of LastResent ( 4th element in $column_header) we will be order like the column RealDate
  365. // because in the column RealDate we have the days in a correct format "2008-03-12 10:35:48"
  366. $column_order = array();
  367. $i=0;
  368. foreach($table_header as $item) {
  369. $column_order[$i] = $i;
  370. $i++;
  371. }
  372. if ($count_files != 0) {
  373. if ($sub_course_dir == '/work') {
  374. $column_order[2] = 2;
  375. } else {
  376. //$column_order[2] = 5;
  377. }
  378. } else {
  379. //$column_order[1] = 4;
  380. $column_order[2] = 4;
  381. }
  382. $table_data = array();
  383. $dirs_list = get_subdirs_list($work_dir);
  384. $my_sub_dir = str_replace('work/', '', $sub_course_dir);
  385. // @todo Since "works" cant have sub works this foreach is useless when selecting the list of works
  386. // List of all folders
  387. if (is_array($dirs_list)) {
  388. foreach ($dirs_list as $dir) {
  389. if ($my_sub_dir == '') {
  390. $mydir_temp = '/'.$dir;
  391. } else {
  392. $mydir_temp = '/'.$my_sub_dir.$dir;
  393. }
  394. $sql_select_directory = "SELECT prop.lastedit_date, work.id, author, has_properties, view_properties, description, qualification, weight FROM ".$iprop_table." prop INNER JOIN ".$work_table." work ON (prop.ref=work.id) WHERE ";
  395. if (!empty($_SESSION['toolgroup'])) {
  396. $sql_select_directory .= " work.post_group_id = '".$_SESSION['toolgroup']."' "; // set to select only messages posted by the user's group
  397. } else {
  398. $sql_select_directory .= " work.post_group_id = '0' ";
  399. }
  400. $sql_select_directory .= " AND work.url LIKE BINARY '".$mydir_temp."' AND work.filetype = 'folder' AND prop.tool='work' $condition_session";
  401. $result = Database::query($sql_select_directory);
  402. $row = Database::fetch_array($result);
  403. if (!$row) {
  404. // the folder belongs to another session
  405. continue;
  406. }
  407. $direc_date = $row['lastedit_date']; //directory's date
  408. $author = $row['author']; //directory's author
  409. $view_properties = $row['view_properties'];
  410. $is_assignment = $row['has_properties'];
  411. $id2 = $row['id'];
  412. $mydir = $my_sub_dir.$dir;
  413. if ($is_allowed_to_edit) {
  414. isset($_GET['edit_dir']) ? $clean_edit_dir = Security :: remove_XSS($_GET['edit_dir']) : $clean_edit_dir = '';
  415. // form edit directory
  416. if (isset($clean_edit_dir) && $clean_edit_dir == $mydir) {
  417. if (!empty($row['has_properties'])) {
  418. $sql = Database::query('SELECT * FROM '.$work_assigment.' WHERE id = '."'".$row['has_properties']."'".' LIMIT 1');
  419. $homework = Database::fetch_array($sql);
  420. }
  421. $form_folder = new FormValidator('edit_dir', 'post', api_get_self().'?curdirpath='.$my_sub_dir.'&origin='.$origin.'&gradebook='.$gradebook.'&edit_dir='.$mydir);
  422. $group_name[] = FormValidator :: createElement('text', 'dir_name');
  423. $form_folder -> addGroup($group_name, 'my_group', get_lang('Title'));
  424. $form_folder -> addGroupRule('my_group', get_lang('ThisFieldIsRequired'), 'required');
  425. $defaults = array('my_group[dir_name]' => html_entity_decode($dir), 'description' => api_html_entity_decode($row['description']));
  426. //$form_folder-> addElement('textarea', 'description', get_lang('Description'), array('rows' => 5, 'cols' => 50));
  427. $form_folder->add_html_editor('description', get_lang('Description'), false, false, array('ToolbarSet' => 'profile', 'Width' => '100%', 'Height' => '200'));
  428. $qualification_input[] = FormValidator :: createElement('text','qualification');
  429. $form_folder -> addGroup($qualification_input, 'qualification', get_lang('QualificationNumeric'), 'size="10"');
  430. if ($row['weight'] > 0) {
  431. $weight_input[] = FormValidator :: createElement('text', 'weight');
  432. $form_folder -> addGroup($weight_input, 'weight', get_lang('WeightInTheGradebook'), 'size="10"');
  433. }
  434. $there_is_a_end_date = false;
  435. if ($row['view_properties'] == '1') {
  436. if ($homework['expires_on'] != '0000-00-00 00:00:00') {
  437. $homework['expires_on'] = api_get_local_time($homework['expires_on']);
  438. $there_is_a_expire_date = true;
  439. $form_folder -> addGroup(create_group_date_select(), 'expires', get_lang('ExpiresAt'));
  440. }
  441. if ($homework['ends_on'] != '0000-00-00 00:00:00') {
  442. $homework['ends_on'] = api_get_local_time($homework['ends_on']);
  443. $there_is_a_end_date = true;
  444. $form_folder -> addGroup(create_group_date_select(), 'ends', get_lang('EndsAt'));
  445. }
  446. if ($there_is_a_expire_date && $there_is_a_end_date) {
  447. $form_folder -> addRule(array('expires', 'ends'), get_lang('DateExpiredNotBeLessDeadLine'), 'comparedate');
  448. }
  449. } else {
  450. $form_folder -> addElement('html', '<div class="row">
  451. <div class="label">&nbsp;</div>
  452. <div class="formw">
  453. <a href="javascript://" onclick="javascript: return plus();" ><span id="plus">&nbsp;<img style="vertical-align:middle;" src="../img/div_show.gif" alt="" />&nbsp;'.get_lang('AdvancedParameters').'</span></a>
  454. </div>
  455. </div> ');
  456. $form_folder -> addElement('html', '<div id="options" style="display: none;">');
  457. if (empty($default)) {
  458. $default = api_get_local_time();
  459. }
  460. $parts = split(' ', $default);
  461. list($d_year, $d_month, $d_day) = split('-', $parts[0]);
  462. list($d_hour, $d_minute) = split(':', $parts[1]);
  463. if ((int)$row['weight'] == 0) {
  464. $form_folder -> addElement('checkbox', 'make_calification', null, get_lang('MakeQualifiable'), 'onclick="javascript: if(this.checked){document.getElementById(\'option3\').style.display = \'block\';}else{document.getElementById(\'option3\').style.display = \'none\';}"');
  465. $form_folder -> addElement('html', '<div id=\'option3\' style="display:none">');
  466. $weight_input2[] = FormValidator :: createElement('text', 'weight');
  467. $form_folder -> addGroup($weight_input2, 'weight', get_lang('WeightInTheGradebook'), 'size="10"');
  468. $form_folder -> addElement('html', '</div>');
  469. }
  470. if ($homework['expires_on'] == '0000-00-00 00:00:00') {
  471. $homework['expires_on'] = api_get_local_time();
  472. $there_is_a_expire_date = true;
  473. $form_folder -> addElement('checkbox', 'enableExpiryDate',null,get_lang('EnableExpiryDate'), 'onclick="javascript: if(this.checked){document.getElementById(\'option1\').style.display = \'block\';}else{document.getElementById(\'option1\').style.display = \'none\';}"');
  474. $form_folder -> addElement('html', '<div id=\'option1\' style="display:none">');
  475. $form_folder -> addGroup(create_group_date_select(), 'expires', get_lang('ExpiresAt'));
  476. $form_folder -> addElement('html', '</div>');
  477. }
  478. if ($homework['ends_on'] == '0000-00-00 00:00:00') {
  479. $homework['ends_on'] = api_get_local_time();
  480. $there_is_a_end_date = true;
  481. $form_folder -> addElement('checkbox', 'enableEndDate', null, get_lang('EnableEndDate'), 'onclick="javascript: if(this.checked){document.getElementById(\'option2\').style.display = \'block\';}else{document.getElementById(\'option2\').style.display = \'none\';}"');
  482. $form_folder -> addElement('html', '<div id=\'option2\' style="display:none">');
  483. $form_folder -> addGroup(create_group_date_select(), 'ends', get_lang('EndsAt'));
  484. $form_folder -> addElement('html', '</div>');
  485. }
  486. $form_folder -> addRule(array('expires', 'ends'), get_lang('DateExpiredNotBeLessDeadLine'), 'comparedate');
  487. $form_folder -> addElement('html', '</div>');
  488. }
  489. $form_folder -> addElement('style_submit_button', 'submit', get_lang('ModifyDirectory'), 'class="save"');
  490. if ($there_is_a_end_date) {
  491. $end_date_array = convert_date_to_array($homework['ends_on'], 'ends');
  492. $defaults = array_merge($defaults, $end_date_array);
  493. }
  494. if ($there_is_a_expire_date) {
  495. $expires_date_array = convert_date_to_array($homework['expires_on'], 'expires');
  496. $defaults = array_merge($defaults, $expires_date_array);
  497. }
  498. if (!empty($row['qualification'])) {
  499. $defaults = array_merge($defaults, array('qualification[qualification]' => $row['qualification']));
  500. }
  501. if (!empty($row['weight'])) {
  502. $defaults = array_merge($defaults, array('weight[weight]' => $row['weight']));
  503. }
  504. $form_folder -> setDefaults($defaults);
  505. $display_edit_form = true;
  506. if ($form_folder -> validate()) {
  507. $values = $form_folder -> exportValues();
  508. $values = $values['my_group'];
  509. $dir_name = replace_dangerous_char($values['dir_name']);
  510. $dir_name = disable_dangerous_file($dir_name);
  511. $edit_check = false;
  512. if ($dir_name != $dir) {
  513. if (!is_work_exist_by_url('/'.$dir_name)) {
  514. $edit_check = true;
  515. }
  516. } else {
  517. $edit_check = true;
  518. }
  519. if ($edit_check) {
  520. $TABLEAGENDA = Database::get_course_table(TABLE_AGENDA);
  521. if ($there_is_a_end_date || $there_is_a_expire_date) {
  522. if ($row['view_properties'] == '1') {
  523. $sql_add_publication = "UPDATE ".$work_table." SET has_properties = '".$row['has_properties']. "', view_properties=1 where id ='".$row['id']."'";
  524. Database::query($sql_add_publication);
  525. $expires_query = ' SET expires_on = '."'".($there_is_a_expire_date ? api_get_utc_datetime(get_date_from_group('expires')) : '0000-00-00 00:00:00')."'".',';
  526. $ends_query = ' ends_on = '."'".($there_is_a_end_date ? api_get_utc_datetime(get_date_from_group('ends')) : '0000-00-00 00:00:00')."'";
  527. Database::query('UPDATE '.$work_assigment.$expires_query.$ends_query.' WHERE id = '."'".$row['has_properties']."'");
  528. } elseif ($row['view_properties'] == '0') {
  529. if ($_POST['enableExpiryDate'] == '1') {
  530. $expires_query = ' SET expires_on = '."'".($there_is_a_expire_date ? api_get_utc_datetime(get_date_from_group('expires')) : '0000-00-00 00:00:00')."'";
  531. //$ends_query = ' ends_on = '."'".($there_is_a_end_date ? get_date_from_group('ends') : '0000-00-00 00:00:00')."'";
  532. Database::query('UPDATE '.$work_assigment.$expires_query.' WHERE id = '."'".$row['has_properties']."'");
  533. $sql_add_publication = "UPDATE ".$work_table." SET has_properties = '".$row['has_properties']. "', view_properties=1 where id ='".$row['id']."'";
  534. Database::query($sql_add_publication);
  535. }
  536. if ($_POST['enableEndDate'] == '1') {
  537. //$expires_query = ' SET expires_on = '."'".($there_is_a_expire_date ? get_date_from_group('expires') : '0000-00-00 00:00:00')."'".',';
  538. $ends_query = ' SET ends_on = '."'".($there_is_a_end_date ? api_get_utc_datetime(get_date_from_group('ends')) : '0000-00-00 00:00:00')."'";
  539. Database::query('UPDATE '.$work_assigment.$ends_query.' WHERE id = '."'".$row['has_properties']."'");
  540. $sql_add_publication = "UPDATE ".$work_table." SET has_properties = '".$row['has_properties']. "', view_properties=1 where id ='".$row['id']."'";
  541. Database::query($sql_add_publication);
  542. }
  543. }
  544. }
  545. //if($_POST['qualification']['qualification']!='')
  546. Database::query('UPDATE '.$work_table.' SET description = '."'".Database::escape_string($_POST['description'])."'".', qualification = '."'".Database::escape_string($_POST['qualification']['qualification'])."'".',weight = '."'".Database::escape_string($_POST['weight']['weight'])."'".' WHERE id = '."'".$row['id']."'");
  547. Database::query('UPDATE '.Database :: get_main_table(TABLE_MAIN_GRADEBOOK_LINK).' SET weight = '."'".Database::escape_string($_POST['weight']['weight'])."'".' WHERE course_code = '."'".api_get_course_id()."'".' AND ref_id = '."'".$row['id']."'".'');
  548. //we are changing the current work and we want add them into gradebook
  549. if (isset($_POST['make_calification']) && $_POST['make_calification'] == 1) {
  550. require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/be/gradebookitem.class.php';
  551. require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/be/evaluation.class.php';
  552. require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/be/abstractlink.class.php';
  553. require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/gradebook_functions.inc.php';
  554. $resource_name = $_POST['dir_name'];
  555. add_resource_to_course_gradebook(api_get_course_id(), 3, $row['id'], Database::escape_string($resource_name), (float)$_POST['weight']['weight'], (float)$_POST['qualification']['qualification'], Database::escape_string($_POST['description']), time(), 1, api_get_session_id());
  556. }
  557. update_dir_name($mydir, $dir_name);
  558. $mydir = $my_sub_dir.$dir_name;
  559. $dir = $dir_name;
  560. $display_edit_form = false;
  561. // gets calendar_id from student_publication_assigment
  562. $sql = "SELECT add_to_calendar FROM $work_assigment WHERE publication_id ='".$row['id']."'";
  563. $res = Database::query($sql);
  564. $calendar_id = Database::fetch_row($res);
  565. // update from agenda if it exists
  566. if (!empty($calendar_id[0])) {
  567. $sql = "UPDATE ".$TABLEAGENDA."
  568. SET title='".$dir_name."',
  569. content = '".$dir_name."',
  570. end_date='".get_date_from_group('ends')."'
  571. WHERE id='".$calendar_id[0]."'";
  572. Database::query($sql);
  573. }
  574. Display::display_confirmation_message(get_lang('FolderEdited'));
  575. } else {
  576. Display::display_warning_message(get_lang('FileExists'));
  577. }
  578. }
  579. }
  580. }
  581. $action = '';
  582. $row = array();
  583. $class = '';
  584. //$a_count_directory = count_dir($work_dir.'/'.$dir, false);
  585. $cant_files = 0;
  586. $cant_dir = 0;
  587. if (api_is_allowed_to_edit()) {
  588. $sql_document = "SELECT count(*) FROM $work_table WHERE url NOT LIKE '".$sub_course_dir.$dir."/%/%' AND url LIKE '".$sub_course_dir.$dir."/%'";
  589. } else {
  590. // gets admin_course
  591. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  592. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  593. $sql = "SELECT course_user.user_id FROM $table_user user, $table_course_user course_user
  594. WHERE course_user.user_id=user.user_id AND course_user.course_code='".api_get_course_id()."' AND course_user.status='1'";
  595. $res = Database::query($sql);
  596. $admin_course = '';
  597. while($row_admin = Database::fetch_row($res)) {
  598. $admin_course .= '\''.$row_admin[0].'\',';
  599. }
  600. $sql_document = "SELECT count(*) FROM $work_table s, $iprop_table p WHERE s.id = p.ref AND p.tool='work' AND s.accepted='1' AND url NOT LIKE '".$sub_course_dir.$dir."/%/%' AND url LIKE '".$sub_course_dir.$dir."/%'";
  601. }
  602. //count documents
  603. $res_document = Database::query($sql_document);
  604. $count_document = Database::fetch_row($res_document);
  605. $cant_files = $count_document[0];
  606. //count directories
  607. $sql_directory = "SELECT count(*) FROM $work_table s WHERE url NOT LIKE '/".$mydir."/%/%' AND url LIKE '/".$mydir."/%'";
  608. $res_directory = Database::query($sql_directory);
  609. $count_directory = Database::fetch_row($res_directory);
  610. $cant_dir = $count_directory[0];
  611. $text_file = get_lang('FilesUpload');
  612. $text_dir = get_lang('Directories');
  613. if ($cant_files == 1) {
  614. $text_file = api_strtolower(get_lang('FileUpload'));
  615. }
  616. if ($cant_dir == 1) {
  617. $text_dir = get_lang('directory');
  618. }
  619. if ($cant_dir != 0) {
  620. $dirtext = ' ('.$cant_dir.' '.$text_dir.')';
  621. } else {
  622. $dirtext = '';
  623. }
  624. $icon = '<img src="../img/works.gif" border="0" hspace="5" align="middle" alt="'.get_lang('Assignment').'" title="'.get_lang('Assignment').'" />';
  625. if (!empty($display_edit_form) && isset($clean_edit_dir) && $clean_edit_dir == $mydir) {
  626. $row[] = $icon;
  627. $row[] = '<span class="invisible" style="display:none">'.$dir.'</span>'.$form_folder->toHtml(); // form to edit the directory's name
  628. } else {
  629. $row[] = '<a href="'.api_get_self().'?'.api_get_cidreq().'&origin='.$origin.'&gradebook='.$gradebook.'&curdirpath='.$mydir.'">'.$icon.'</a>';
  630. $tbl_gradebook_link = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINK);
  631. $add_to_name = '';
  632. $sql = "SELECT weight FROM ". $tbl_gradebook_link ." WHERE type='3' AND ref_id= '".$id2."'";
  633. $result = Database::query($sql);
  634. $count = Database::num_rows($result);
  635. if ($count > 0) {
  636. $add_to_name = ' / <span style="color:blue">'.get_lang('IncludedInEvaluation').'</span>';
  637. } else {
  638. $add_to_name = '';
  639. }
  640. $show_as_icon = get_work_id($mydir); //true or false
  641. if ($show_as_icon) {
  642. if (is_allowed_to_edit()) {
  643. $zip='<a href="'.api_get_self().'?cidReq='.api_get_course_id().'&gradebook='.$gradebook.'&action=downloadfolder&path=/'.$mydir.'"><img src="../img/zip_save.gif" style="float:right;" alt="'.get_lang('Save').'" title="'.get_lang('Save').'" width="17" height="17"/></a>';
  644. }
  645. $row[] = $zip.'<a href="'.api_get_self().'?'.api_get_cidreq().'&origin='.$origin.'&gradebook='.Security::remove_XSS($_GET['gradebook']).'&curdirpath='.$mydir.'"'.$class.'>'.$dir.'</a>'.$add_to_name.'<br />'.$cant_files.' '.$text_file.$dirtext;
  646. } else {
  647. $row[] = '<a href="'.api_get_self().'?'.api_get_cidreq().'&origin='.$origin.'&gradebook='.$gradebook.'&curdirpath='.$mydir.'"'.$class.'>'.$dir.'</a>'.$add_to_name.'<br />'.$cant_files.' '.$text_file.$dirtext;
  648. }
  649. }
  650. if ($count_files != 0) {
  651. $row[] = '';
  652. }
  653. if ($direc_date != '' && $direc_date != '0000-00-00 00:00:00') {
  654. $direc_date_local = api_get_local_time($direc_date);
  655. $row[] = date_to_str_ago($direc_date_local).'<br /><span class="dropbox_date">'.api_format_date($direc_date_local).'</span>';
  656. } else {
  657. $direc_date_local = '0000-00-00 00:00:00';
  658. $row[] = '';
  659. }
  660. if ($origin != 'learnpath') {
  661. if ($is_allowed_to_edit) {
  662. $action .= '<a href="'.api_get_self().'?cidReq='.api_get_course_id().
  663. '&curdirpath='.$my_sub_dir.'&origin='.$origin.'&gradebook='.$gradebook.'&edit_dir='.$mydir.'"><img src="../img/edit.gif" alt="'.get_lang('Modify').'" title="'.get_lang('Modify').'"></a>';
  664. $action .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&origin='.$origin.'&gradebook='.$gradebook.'&delete_dir='.$mydir.'&delete2='.$id2.'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'), ENT_QUOTES))."'".')) return false;" title="'.get_lang('DirDelete').'" >'.Display::return_icon('delete.gif',get_lang('DirDelete')).'</a>';
  665. $row[] = $action;
  666. } else {
  667. $row[] = '';
  668. }
  669. }
  670. $row[] = $direc_date_local;
  671. $table_data[] = $row;
  672. }
  673. }
  674. //Redefining $my_sub_dir
  675. if (substr($my_sub_dir,strlen($my_sub_dir)-1, strlen($my_sub_dir)) == '/') {
  676. $my_sub_dir = substr($my_sub_dir, 0,strlen($my_sub_dir)-1);
  677. }
  678. if (Database::num_rows($sql_result) > 0) {
  679. while ($work = Database::fetch_object($sql_result)) {
  680. //Get the author ID for that document from the item_property table
  681. $is_author = false;
  682. $author_sql = "SELECT * FROM $iprop_table WHERE tool = 'work' AND ref=".$work->id;
  683. $author_qry = Database::query($author_sql);
  684. $row2 = Database::fetch_array($author_qry);
  685. if (Database::num_rows($author_qry) == 1) {
  686. $is_author = true;
  687. }
  688. //display info depending on the permissions
  689. if ($work->accepted == '1' || $is_allowed_to_edit) {
  690. $row = array();
  691. if ($work->accepted == '0') {
  692. $class = 'class="invisible"';
  693. } else {
  694. $class = '';
  695. }
  696. $qualification_string = '';
  697. $add_string = '';
  698. if (defined('IS_ASSIGNMENT')) {
  699. if($work->qualification == '') {
  700. //$qualification_string = '<b style="color:orange">'.get_lang('NotRevised').'</b>';
  701. $qualification_string = '<b style="color:orange"> - </b>';
  702. } else {
  703. //$qualification_string = '<b style="color:blue">'.get_lang('Qualification').': '.$work->qualification.'</b>';
  704. $qualification_string = '<b style="color:blue">'.$work->qualification.'</b>';
  705. }
  706. if (defined('ASSIGNMENT_EXPIRES') && (ASSIGNMENT_EXPIRES < convert_date_to_number($work->sent_date))) {
  707. $add_string = ' <b style="color:red">'.get_lang('Expired').'</b>';
  708. }
  709. }
  710. $url = implode('/', array_map('rawurlencode', explode('/', $work->url)));
  711. $row[] = '<a href="download.php?file='.$url.'">'.build_document_icon_tag('file', substr(basename($work->url), 13)).'</a>';
  712. $row[] = '<a href="download.php?file='.$url.'"'.$class.'><img src="../img/filesave.gif" style="float:right;" alt="'.get_lang('Save').'" title="'.get_lang('Save').'" />'.$work->title.'</a><br />'.$work->description;
  713. $row[] = display_user_link_work($row2['insert_user_id'], $work->author); // $work->author;
  714. $row[] = $qualification_string;
  715. $work_sent_date_local = api_get_local_time($work->sent_date);
  716. $row[] = date_to_str_ago($work_sent_date_local).$add_string.'<br /><span class="dropbox_date">'.api_format_date($work_sent_date_local).'</span>';
  717. if ($is_allowed_to_edit) {
  718. $action = '';
  719. $action .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&curdirpath='.urlencode($my_sub_dir).'&amp;origin='.$origin.'&gradebook='.$gradebook.'&amp;edit='.$work->id.'&gradebook='.Security::remove_XSS($_GET['gradebook']).'&amp;parent_id='.$work->parent_id.'" title="'.get_lang('Modify').'" ><img src="../img/edit.gif" alt="'.get_lang('Modify').'" title="'.get_lang('Modify').'"></a>';
  720. $action .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&curdirpath='.urlencode($my_sub_dir).'&amp;origin='.$origin.'&gradebook='.$gradebook.'&amp;delete='.$work->id.'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'),ENT_QUOTES))."'".')) return false;" title="'.get_lang('WorkDelete').'" >'.Display::return_icon('delete.gif', get_lang('WorkDelete')).'</a>';
  721. $action .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&curdirpath='.urlencode($my_sub_dir).'&amp;origin='.$origin.'&gradebook='.$gradebook.'&amp;move='.$work->id.'" title="'.get_lang('Move').'"><img src="../img/deplacer_fichier.gif" border="0" title="'.get_lang('Move').'" alt="'.get_lang('Move').'" /></a>';
  722. if ($work->accepted == '1') {
  723. $action .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&curdirpath='.urlencode($my_sub_dir).'&amp;origin='.$origin.'&gradebook='.$gradebook.'&amp;make_invisible='.$work->id.'&amp;'.$sort_params.'" title="'.get_lang('Invisible').'" ><img src="../img/visible.gif" alt="'.get_lang('Invisible').'" title="'.get_lang('Invisible').'"></a>';
  724. } else {
  725. $action .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&curdirpath='.urlencode($my_sub_dir).'&amp;origin='.$origin.'&gradebook='.$gradebook.'&amp;make_visible='.$work->id.'&amp;'.$sort_params.'" title="'.get_lang('Visible').'" ><img src="../img/invisible.gif" alt="'.get_lang('Visible').'" title="'.get_lang('Visible').'"></a>';
  726. }
  727. $row[] = $action;
  728. // the user that is not course admin can only edit/delete own document
  729. } elseif ($row2['insert_user_id'] == $_user['user_id']) {
  730. $action = '';
  731. $action .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&curdirpath='.urlencode($my_sub_dir).'&gradebook='.Security::remove_XSS($_GET['gradebook']).'&amp;origin='.$origin.'&gradebook='.$gradebook.'&amp;edit='.$work->id.'" title="'.get_lang('Modify').'" ><img src="../img/edit.gif" alt="'.get_lang('Modify').'" title="'.get_lang('Modify').'"></a>';
  732. if (api_get_course_setting('student_delete_own_publication') == 1) {
  733. $action .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&curdirpath='.urlencode($my_sub_dir).'&amp;origin='.$origin.'&gradebook='.$gradebook.'&amp;delete='.$work->id.'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang('ConfirmYourChoice'),ENT_QUOTES))."'".')) return false;" title="'.get_lang('WorkDelete').'" >'.Display::return_icon('delete.gif',get_lang('WorkDelete')).'</a>';
  734. }
  735. $row[] = $action;
  736. } else {
  737. $row[] = ' ';
  738. }
  739. $row[] = $work_sent_date_local;
  740. $table_data[] = $row;
  741. }
  742. }
  743. }
  744. $sorting_options = array();
  745. $sorting_options['column'] = 1;
  746. $paging_options = array();
  747. if (isset($_GET['curdirpath'])) {
  748. $my_params = array ('curdirpath' => Security::remove_XSS($_GET['curdirpath']));
  749. }
  750. if (isset($_GET['edit_dir'])) {
  751. $my_params = array ('edit_dir' => Security::remove_XSS($_GET['edit_dir']));
  752. }
  753. $my_params['origin'] = $origin;
  754. Display::display_sortable_config_table($table_header, $table_data, $sorting_options, $paging_options, $my_params, $column_show, $column_order);
  755. }
  756. /**
  757. * Returns a list of subdirectories found in the given directory.
  758. *
  759. * The list return starts from the given base directory.
  760. * If you require the subdirs of /var/www/ (or /var/www), you will get 'abc/', 'def/', but not '/var/www/abc/'...
  761. * @param string Base dir
  762. * @param integer 0 if we only want dirs from this level, 1 if we want to recurse into subdirs
  763. * @return strings_array The list of subdirs in 'abc/' form, -1 on error, and 0 if none found
  764. * @todo Add a session check to see if subdirs_list doesn't exist yet (cached copy)
  765. */
  766. function get_subdirs_list($basedir = '', $recurse = 0) {
  767. //echo "Looking for subdirs of $basedir";
  768. if (empty($basedir) or !is_dir($basedir)) {
  769. return -1;
  770. }
  771. if (substr($basedir, -1, 1) != '/') {
  772. $basedir = $basedir.'/';
  773. }
  774. $dirs_list = array();
  775. $dh = opendir($basedir);
  776. while ($entry = readdir($dh)) {
  777. $entry = replace_dangerous_char($entry);
  778. $entry = disable_dangerous_file($entry);
  779. if (is_dir($basedir.$entry) && $entry != '..' && $entry != '.') {
  780. $dirs_list[] = $entry;
  781. if ($recurse == 1) {
  782. foreach (get_subdirs_list($basedir.$entry) as $subdir) {
  783. $dirs_list[] = $entry.'/'.$subdir;
  784. }
  785. }
  786. }
  787. }
  788. closedir($dh);
  789. return $dirs_list;
  790. }
  791. /**
  792. * Builds the form thats enables the user to
  793. * select a directory to browse/upload in
  794. * This function has been copied from the document/document.inc.php library
  795. *
  796. * @param array $folders
  797. * @param string $curdirpath
  798. * @param string $group_dir
  799. * @return string html form
  800. */
  801. // TODO: This function is a candidate for removal, it is not used anywhere.
  802. function build_work_directory_selector($folders, $curdirpath, $group_dir = '') {
  803. $form = '<form name="selector" action="'.api_get_self().'?'.api_get_cidreq().'" method="POST">'."\n";
  804. $form .= get_lang('CurrentDirectory').' <select name="curdirpath" onchange="javascript: document.selector.submit();">'."\n";
  805. //group documents cannot be uploaded in the root
  806. if ($group_dir == '') {
  807. $form .= '<option value="/">/ ('.get_lang('Root').')</option>';
  808. if (is_array($folders)) {
  809. foreach ($folders as $folder) {
  810. $selected = ($curdirpath == $folder) ? ' selected="selected"' : '';
  811. $form .= '<option'.$selected.' value="'.$folder.'">'.$folder.'</option>'."\n";
  812. }
  813. }
  814. } else {
  815. foreach ($folders as $folder) {
  816. $selected = ($curdirpath == $folder) ? ' selected="selected"' : '';
  817. $display_folder = substr($folder, strlen($group_dir));
  818. $display_folder = ($display_folder == '') ? '/ ('.get_lang('Root').')' : $display_folder;
  819. $form .= '<option'.$selected.' value="'.$folder.'">'.$display_folder.'</option>'."\n";
  820. }
  821. }
  822. $form .= '</select>'."\n";
  823. $form .= '<noscript><input type="submit" name="change_path" value="'.get_lang('Ok').'" /></noscript>'."\n";
  824. $form .= '</form>';
  825. return $form;
  826. }
  827. /**
  828. * Builds the form thats enables the user to
  829. * move a document from one directory to another
  830. * This function has been copied from the document/document.inc.php library
  831. *
  832. * @param array $folders
  833. * @param string $curdirpath
  834. * @param string $move_file
  835. * @return string html form
  836. */
  837. function build_work_move_to_selector($folders, $curdirpath, $move_file, $group_dir = '') {
  838. //gets file title
  839. $move_file = intval($move_file);
  840. $tbl_work = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  841. $sql = "SELECT title FROM $tbl_work WHERE id ='".$move_file."'";
  842. $result = Database::query($sql);
  843. $title = Database::fetch_row($result);
  844. global $gradebook;
  845. $form = '<form name="move_to" action="'.api_get_self().'?gradebook='.$gradebook.'" method="POST">'."\n";
  846. $form .= '<div class="row"><div class="form_header">'.get_lang('MoveFile').'</div></div>';
  847. $form .= '<input type="hidden" name="move_file" value="'.$move_file.'" />'."\n";
  848. $form .= '<div class="row">
  849. <div class="label">
  850. <span class="form_required">*</span>'.sprintf(get_lang('MoveXTo'), $title[0]).'
  851. </div>
  852. <div class="formw">';
  853. $form .= ' <select name="move_to">'."\n";
  854. //group documents cannot be uploaded in the root
  855. if ($group_dir == '') {
  856. if ($curdirpath != '/') {
  857. $form .= '<option value="0">/ ('.get_lang('Root').')</option>';
  858. }
  859. if (is_array($folders)) {
  860. foreach ($folders as $fid => $folder) {
  861. //you cannot move a file to:
  862. //1. current directory
  863. //2. inside the folder you want to move
  864. //3. inside a subfolder of the folder you want to move
  865. if (($curdirpath != $folder) && ($folder != $move_file) && (substr($folder, 0, strlen($move_file) + 1) != $move_file.'/')) {
  866. $form .= '<option value="'.$fid.'">'.$folder.'</option>'."\n";
  867. }
  868. }
  869. }
  870. } else {
  871. if ($curdirpath != '/') {
  872. $form .= '<option value="0">/ ('.get_lang('Root').')</option>';
  873. }
  874. foreach ($folders as $fid => $folder) {
  875. if (($curdirpath != $folder) && ($folder != $move_file) && (substr($folder, 0, strlen($move_file) + 1) != $move_file.'/')) {
  876. //cannot copy dir into his own subdir
  877. $display_folder = substr($folder, strlen($group_dir));
  878. $display_folder = ($display_folder == '') ? '/ ('.get_lang('Root').')' : $display_folder;
  879. $form .= '<option value="'.$fid.'">'.$display_folder.'</option>'."\n";
  880. }
  881. }
  882. }
  883. $form .= '</select>'."\n";
  884. $form .= ' </div>
  885. </div>';
  886. $form .= '<div class="row">
  887. <div class="label">
  888. </div>
  889. <div class="formw">
  890. <button type="submit" class="save" name="move_file_submit">'.get_lang('MoveFile').'</button>
  891. </div>
  892. </div>';
  893. $form .= '</form>';
  894. $form .= '<div style="clear: both; margin-bottom: 10px;"></div>';
  895. return $form;
  896. }
  897. /**
  898. * Checks if the first given directory exists as a subdir of the second given directory
  899. * This function should now be deprecated by Security::check_abs_path()
  900. * @param string Subdir
  901. * @param string Base dir
  902. * @return integer -1 on error, 0 if not subdir, 1 if subdir
  903. */
  904. // TODO: This function is a candidate for removal, it is not used anywhere.
  905. function is_subdir_of($subdir, $basedir) {
  906. if (empty($subdir) or empty($basedir)) {
  907. return -1;
  908. }
  909. if (substr($basedir, -1, 1) != '/') {
  910. $basedir = $basedir.'/';
  911. }
  912. if (substr($subdir, 0, 1) == '/') {
  913. $subdir = substr($subdir, 1);
  914. }
  915. return is_dir($basedir.$subdir) ? 1 : 0;
  916. }
  917. /**
  918. * creates a new directory trying to find a directory name
  919. * that doesn't already exist
  920. * (we could use unique_name() here...)
  921. *
  922. * @author Hugues Peeters <hugues.peeters@claroline.net>
  923. * @author Bert Vanderkimpen
  924. * @author Yannick Warnier <ywarnier@beeznest.org> Adaptation for work tool
  925. * @param string Base work dir (.../work)
  926. * @param string $desiredDirName complete path of the desired name
  927. * @return string actual directory name if it succeeds, boolean false otherwise
  928. */
  929. function create_unexisting_work_directory($base_work_dir, $desired_dir_name) {
  930. $nb = '';
  931. $base_work_dir = (substr($base_work_dir, -1, 1) == '/' ? $base_work_dir : $base_work_dir.'/');
  932. while (file_exists($base_work_dir.$desired_dir_name.$nb)) {
  933. $nb += 1;
  934. }
  935. if (@mkdir($base_work_dir.$desired_dir_name.$nb, api_get_permissions_for_new_directories())) {
  936. return $desired_dir_name.$nb;
  937. } else {
  938. return false;
  939. }
  940. }
  941. /**
  942. * Delete a work-tool directory
  943. * @param string Base "work" directory for this course as /var/www/dokeos/courses/ABCD/work/
  944. * @param string The directory name as the bit after "work/", without trailing slash
  945. * @return integer -1 on error
  946. */
  947. function del_dir($base_work_dir, $dir, $id) {
  948. $id = intval($id);
  949. if (empty($dir) or $dir == '/') {
  950. return -1;
  951. }
  952. $check = Security::check_abs_path($base_work_dir.$dir, $base_work_dir);
  953. if (!$check || !is_dir($base_work_dir.$dir)) {
  954. return -1;
  955. }
  956. $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  957. $sql = "DELETE FROM $table WHERE url LIKE BINARY 'work/".$dir."/%'";
  958. $res = Database::query($sql);
  959. //delete from DB the directories
  960. $sql = "DELETE FROM $table WHERE filetype = 'folder' AND url LIKE BINARY '/".$dir."%'";
  961. $res = Database::query($sql);
  962. require_once api_get_path(LIBRARY_PATH).'fileManage.lib.php';
  963. $new_dir = $dir.'_DELETED_'.$id;
  964. if (api_get_setting('permanently_remove_deleted_files') == 'true'){
  965. my_delete($base_work_dir.$dir);
  966. } else {
  967. if (file_exists($base_work_dir.$dir)) {
  968. rename($base_work_dir.$dir, $base_work_dir.$new_dir);
  969. }
  970. }
  971. }
  972. /**
  973. * Get the path of a document in the student_publication table (path relative to the course directory)
  974. * @param integer Element ID
  975. * @return string Path (or -1 on error)
  976. */
  977. function get_work_path($id) {
  978. $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  979. $sql = 'SELECT url FROM '.$table.' WHERE id='.intval($id);
  980. $res = Database::query($sql);
  981. if (Database::num_rows($res) != 1) {
  982. return -1;
  983. } else {
  984. $row = Database::fetch_array($res);
  985. return $row['url'];
  986. }
  987. }
  988. /**
  989. * Update the url of a work in the student_publication table
  990. * @param integer ID of the work to update
  991. * @param string Destination directory where the work has been moved (must end with a '/')
  992. * @return -1 on error, sql query result on success
  993. */
  994. function update_work_url($id, $new_path, $parent_id) {
  995. if (empty($id)) return -1;
  996. $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  997. $sql = "SELECT * FROM $table WHERE id=$id";
  998. $res = Database::query($sql);
  999. if (Database::num_rows($res) != 1) {
  1000. return -1;
  1001. } else {
  1002. $row = Database::fetch_array($res);
  1003. $filename = basename($row['url']);
  1004. $new_url = $new_path .$filename;
  1005. $sql2 = "UPDATE $table SET url = '$new_url', parent_id = '$parent_id' WHERE id=$id";
  1006. $res2 = Database::query($sql2);
  1007. return $res2;
  1008. }
  1009. }
  1010. /**
  1011. * Update the url of a dir in the student_publication table
  1012. * @param string old path
  1013. * @param string new path
  1014. */
  1015. function update_dir_name($path, $new_name) {
  1016. if (!empty($new_name)) {
  1017. global $base_work_dir;
  1018. include_once api_get_path(LIBRARY_PATH).'fileManage.lib.php';
  1019. include_once api_get_path(LIBRARY_PATH).'fileUpload.lib.php';
  1020. $path_to_dir = dirname($path);
  1021. if ($path_to_dir == '.') {
  1022. $path_to_dir = '';
  1023. } else {
  1024. $path_to_dir .= '/';
  1025. }
  1026. $new_name = Security::remove_XSS($new_name);
  1027. $new_name = replace_dangerous_char($new_name);
  1028. $new_name = disable_dangerous_file($new_name);
  1029. my_rename($base_work_dir.'/'.$path, $new_name);
  1030. $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  1031. //update all the files in the other directories according with the next query
  1032. $sql = 'SELECT id, url FROM '.$table.' WHERE url LIKE BINARY "work/'.$path.'/%"'; // like binary (Case Sensitive)
  1033. $rs = Database::query($sql);
  1034. $work_len = strlen('work/'.$path);
  1035. while ($work = Database :: fetch_array($rs)) {
  1036. $new_dir = $work['url'];
  1037. $name_with_directory = substr($new_dir, $work_len, strlen($new_dir));
  1038. $sql = 'UPDATE '.$table.' SET url="work/'.$path_to_dir.$new_name.$name_with_directory.'" WHERE id= '.$work['id'];
  1039. Database::query($sql);
  1040. }
  1041. //update all the directory's children according with the next query
  1042. $sql = 'SELECT id, url FROM '.$table.' WHERE url LIKE BINARY "/'.$path.'%"';
  1043. $rs = Database::query($sql);
  1044. $work_len = strlen('/'.$path);
  1045. while ($work = Database :: fetch_array($rs)) {
  1046. $new_dir = $work['url'];
  1047. $name_with_directory = substr($new_dir, $work_len, strlen($new_dir));
  1048. $url = $path_to_dir.$new_name.$name_with_directory;
  1049. $sql = 'UPDATE '.$table.' SET url="/'.$url.'" WHERE id= '.$work['id'];
  1050. Database::query($sql);
  1051. }
  1052. }
  1053. }
  1054. /**
  1055. * Return an array with all the folder's ids that are in the given path
  1056. * @param string Path of the directory
  1057. * @return array The list of ids of all the directories in the path
  1058. * @author Julio Montoya Dokeos
  1059. * @version April 2008
  1060. */
  1061. function get_parent_directories($my_cur_dir_path) {
  1062. $list_id = array();
  1063. if (!empty($my_cur_dir_path)) {
  1064. $list_parents = explode('/', $my_cur_dir_path);
  1065. $dir_acum = '';
  1066. $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  1067. for ($i = 0; $i < count($list_parents) - 1; $i++) {
  1068. $item = Database::escape_string($list_parents[$i]);
  1069. $where_sentence = "url LIKE BINARY '" . $dir_acum . "/" . $item."'";
  1070. $dir_acum .= '/' . $list_parents[$i];
  1071. $sql = "SELECT id FROM ". $work_table . " WHERE ". $where_sentence;
  1072. $result = Database::query($sql);
  1073. $row = Database::fetch_array($result);
  1074. $list_id[] = $row['id'];
  1075. }
  1076. }
  1077. return $list_id;
  1078. }
  1079. /**
  1080. * Transform an all directory structure (only directories) in an array
  1081. * @param string path of the directory
  1082. * @return array the directory structure into an array
  1083. * @author Julio Montoya Dokeos
  1084. * @version April 2008
  1085. */
  1086. function directory_to_array($directory) {
  1087. $array_items = array();
  1088. if ($handle = @opendir($directory)) {
  1089. while (false !== ($file = readdir($handle))) {
  1090. if ($file != '.' && $file != '..') {
  1091. if (is_dir($directory. '/' . $file)) {
  1092. $array_items = array_merge($array_items, directory_to_array($directory. '/' . $file));
  1093. $file = $directory . '/' . $file;
  1094. $array_items[] = preg_replace("/\/\//si", '/', $file);
  1095. }
  1096. }
  1097. }
  1098. closedir($handle);
  1099. }
  1100. return $array_items;
  1101. }
  1102. /**
  1103. * Insert into the DB of the course all the directories
  1104. * @param string path of the /work directory of the course
  1105. * @return -1 on error, sql query result on success
  1106. * @author Julio Montoya Dokeos
  1107. * @version April 2008
  1108. */
  1109. function insert_all_directory_in_course_table($base_work_dir) {
  1110. $dir_to_array = directory_to_array($base_work_dir, true);
  1111. $only_dir = array();
  1112. for ($i = 0; $i < count($dir_to_array); $i++) {
  1113. $only_dir[] = substr($dir_to_array[$i], strlen($base_work_dir), strlen($dir_to_array[$i]));
  1114. }
  1115. for($i = 0; $i < count($only_dir); $i++) {
  1116. global $work_table;
  1117. $sql_insert_all= "INSERT INTO " . $work_table . " SET url = '" . $only_dir[$i] . "', " .
  1118. "title = '',
  1119. description = '',
  1120. author = '',
  1121. active = '0',
  1122. accepted = '1',
  1123. filetype = 'folder',
  1124. post_group_id = '".intval($_GET['toolgroup'])."',
  1125. sent_date = '0000-00-00 00:00:00' ";
  1126. Database::query($sql_insert_all);
  1127. }
  1128. }
  1129. /**
  1130. * This function displays the number of files contained in a directory
  1131. *
  1132. * @param string the path of the directory
  1133. * @param boolean true if we want the total quantity of files include in others child directorys , false only files in the directory
  1134. * @return array the first element is an integer with the number of files in the folder, the second element is the number of directories
  1135. * @author Julio Montoya Dokeos
  1136. * @version April 2008
  1137. */
  1138. function count_dir($path_dir, $recurse) {
  1139. $count = 0;
  1140. $count_dir = 0;
  1141. $d = dir($path_dir);
  1142. while ($entry = $d->Read()) {
  1143. if (!(($entry == '..') || ($entry == '.'))) {
  1144. if (is_dir($path_dir.'/'.$entry)) {
  1145. $count_dir++;
  1146. if ($recurse) {
  1147. $count += count_dir($path_dir . '/' . $entry, $recurse);
  1148. }
  1149. } else {
  1150. $count++;
  1151. }
  1152. }
  1153. }
  1154. $return_array = array();
  1155. $return_array[] = $count;
  1156. $return_array[] = $count_dir;
  1157. return $return_array;
  1158. }
  1159. /**
  1160. * returns all the javascript that is required for easily
  1161. * validation when you create a work
  1162. * this goes into the $htmlHeadXtra[] array
  1163. */
  1164. function to_javascript_work() {
  1165. return '<script>
  1166. function plus() {
  1167. if(document.getElementById(\'options\').style.display == \'none\') {
  1168. document.getElementById(\'options\').style.display = \'block\';
  1169. document.getElementById(\'plus\').innerHTML=\'&nbsp;'.Display::return_icon('div_hide.gif', get_lang('Hide', ''), array('style' => 'vertical-align:middle')).'&nbsp;'.addslashes(get_lang('AdvancedParameters', '')).'\';
  1170. } else {
  1171. document.getElementById(\'options\').style.display = \'none\';
  1172. document.getElementById(\'plus\').innerHTML=\'&nbsp;'.Display::return_icon('div_show.gif', get_lang('Show', ''), array('style' => 'vertical-align:middle')).'&nbsp;'.addslashes(get_lang('AdvancedParameters', '')).'\';
  1173. }
  1174. }
  1175. function updateDocumentTitle(value){
  1176. var temp = value.indexOf("/");
  1177. //linux path
  1178. if(temp!=-1){
  1179. var temp=value.split("/");
  1180. }
  1181. else{
  1182. var temp=value.split("\\\");
  1183. }
  1184. document.getElementById("file_upload").value=temp[temp.length-1];
  1185. }
  1186. function checkDate(month, day, year)
  1187. {
  1188. var monthLength =
  1189. new Array(31,28,31,30,31,30,31,31,30,31,30,31);
  1190. if (!day || !month || !year)
  1191. return false;
  1192. // check for bisestile year
  1193. if (year/4 == parseInt(year/4))
  1194. monthLength[1] = 29;
  1195. if (month < 1 || month > 12)
  1196. return false;
  1197. if (day > monthLength[month-1])
  1198. return false;
  1199. return true;
  1200. }
  1201. function mktime() {
  1202. var no, ma = 0, mb = 0, i = 0, d = new Date(), argv = arguments, argc = argv.length;
  1203. d.setHours(0,0,0); d.setDate(1); d.setMonth(1); d.setYear(1972);
  1204. var dateManip = {
  1205. 0: function(tt){ return d.setHours(tt); },
  1206. 1: function(tt){ return d.setMinutes(tt); },
  1207. 2: function(tt){ set = d.setSeconds(tt); mb = d.getDate() - 1; return set; },
  1208. 3: function(tt){ set = d.setMonth(parseInt(tt)-1); ma = d.getFullYear() - 1972; return set; },
  1209. 4: function(tt){ return d.setDate(tt+mb); },
  1210. 5: function(tt){ return d.setYear(tt+ma); }
  1211. };
  1212. for( i = 0; i < argc; i++ ){
  1213. no = parseInt(argv[i]*1);
  1214. if (isNaN(no)) {
  1215. return false;
  1216. } else {
  1217. // arg is number, lets manipulate date object
  1218. if(!dateManip[i](no)){
  1219. // failed
  1220. return false;
  1221. }
  1222. }
  1223. }
  1224. return Math.floor(d.getTime()/1000);
  1225. }
  1226. function validate(){
  1227. var expires_day = document.form1.expires_day.value;
  1228. var expires_month = document.form1.expires_month.value;
  1229. var expires_year = document.form1.expires_year.value;
  1230. var expires_hour = document.form1.expires_hour.value;
  1231. var expires_minute = document.form1.expires_minute.value;
  1232. var expires_date = mktime(expires_hour,expires_minute,0,expires_month,expires_day,expires_year)
  1233. var ends_day = document.form1.ends_day.value;
  1234. var ends_month = document.form1.ends_month.value;
  1235. var ends_year = document.form1.ends_year.value;
  1236. var ends_hour = document.form1.ends_hour.value;
  1237. var ends_minute = document.form1.ends_minute.value;
  1238. var ends_date = mktime(ends_hour,ends_minute,0,ends_month,ends_day,ends_year)
  1239. var new_dir = document.form1.new_dir.value;
  1240. msg_id1 = document.getElementById("msg_error1");
  1241. msg_id2 = document.getElementById("msg_error2");
  1242. msg_id3 = document.getElementById("msg_error3");
  1243. msg_id4 = document.getElementById("msg_error4");
  1244. msg_id5 = document.getElementById("msg_error_weight");
  1245. if(new_dir==""){
  1246. msg_id1.style.display ="block";
  1247. msg_id1.innerHTML="'.get_lang('FieldRequired', '').'";
  1248. msg_id2.innerHTML="";msg_id3.innerHTML="";msg_id4.innerHTML="";msg_id5.innerHTML="";
  1249. }
  1250. else if(document.form1.type1.checked && document.form1.type2.checked && expires_date > ends_date) {
  1251. msg_id2.style.display ="block";
  1252. msg_id2.innerHTML="'.get_lang('EndDateCannotBeBeforeTheExpireDate', '').'";
  1253. msg_id1.innerHTML="";msg_id3.innerHTML="";msg_id4.innerHTML="";msg_id5.innerHTML="";
  1254. }
  1255. else if (!checkDate(expires_month,expires_day,expires_year))
  1256. {
  1257. msg_id3.style.display ="block";
  1258. msg_id3.innerHTML="'.get_lang('InvalidDate', '').'";
  1259. msg_id1.innerHTML="";msg_id2.innerHTML="";msg_id4.innerHTML="";msg_id5.innerHTML="";
  1260. }
  1261. else if (!checkDate(ends_month,ends_day,ends_year))
  1262. {
  1263. msg_id4.style.display ="block";
  1264. msg_id4.innerHTML="'.get_lang('InvalidDate', '').'";
  1265. msg_id1.innerHTML="";msg_id2.innerHTML="";msg_id3.innerHTML="";msg_id5.innerHTML="";
  1266. }
  1267. else
  1268. {
  1269. if (document.form1.make_calification.checked)
  1270. {
  1271. var weight = document.form1.weight.value;
  1272. if(weight==""){
  1273. msg_id5.style.display ="block";
  1274. msg_id5.innerHTML="'.get_lang('WeightNecessary', '').'";
  1275. msg_id1.innerHTML="";msg_id2.innerHTML="";msg_id3.innerHTML="";msg_id4.innerHTML="";
  1276. return false;
  1277. }
  1278. }
  1279. document.form1.action = "work.php?origin='.api_get_tools_lists($_REQUEST['origin']).'&gradebook='.(empty($_GET['gradebook'])?'':'view').'";
  1280. document.form1.submit();
  1281. }
  1282. }
  1283. </script>';
  1284. }
  1285. /**
  1286. * Gets the id of a student publication with a given path
  1287. * @param string $path
  1288. * @return true if is found / false if not found
  1289. */
  1290. // TODO: The name of this function does not fit with the kind of information it returns. Maybe check_work_id() or is_work_id()?
  1291. function get_work_id($path) {
  1292. $TBL_STUDENT_PUBLICATION = Database :: get_course_table(TABLE_STUDENT_PUBLICATION);
  1293. $TBL_PROP_TABLE = Database::get_course_table(TABLE_ITEM_PROPERTY);
  1294. if (is_allowed_to_edit()) {
  1295. $sql = "SELECT work.id FROM $TBL_STUDENT_PUBLICATION AS work,$TBL_PROP_TABLE AS props WHERE props.tool='work' AND work.id=props.ref AND work.url LIKE 'work/".$path."%' AND work.filetype='file' AND props.visibility<>'2'";
  1296. } else {
  1297. $sql = "SELECT work.id FROM $TBL_STUDENT_PUBLICATION AS work,$TBL_PROP_TABLE AS props WHERE props.tool='work' AND work.id=props.ref AND work.url LIKE 'work/".$path."%' AND work.filetype='file' AND props.visibility<>'2' AND props.lastedit_user_id='".api_get_user_id()."'";
  1298. }
  1299. $result = Database::query($sql);
  1300. $num_rows = Database::num_rows($result);
  1301. if ($result && $num_rows > 0) {
  1302. return true;
  1303. } else {
  1304. return false;
  1305. }
  1306. }
  1307. /**
  1308. * Get list of users who have not given the task
  1309. * @param int
  1310. * @return array
  1311. * @author cvargas carlos.vargas@beeznest.com
  1312. */
  1313. function get_list_users_without_publication($task_id) {
  1314. $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  1315. $iprop_table = Database::get_course_table(TABLE_ITEM_PROPERTY);
  1316. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  1317. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  1318. $session_course_rel_user = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  1319. //condition for the session
  1320. $session_id = api_get_session_id();
  1321. if ($session_id == 0){
  1322. $sql = "SELECT user_id as id FROM $work_table WHERE parent_id='$task_id'";
  1323. } else {
  1324. $sql = "SELECT user_id as id FROM $work_table WHERE parent_id='$task_id' and session_id='".$session_id."'";
  1325. }
  1326. $result = Database::query($sql);
  1327. $users_with_tasks = array();
  1328. while($row = Database::fetch_array($result)) {
  1329. $users_with_tasks[] = $row['id'];
  1330. }
  1331. if ($session_id == 0){
  1332. $sql_users = "SELECT cu.user_id, u.lastname, u.firstname, u.email FROM $table_course_user AS cu, $table_user AS u WHERE u.status!=1 and cu.course_code='".api_get_course_id()."' AND u.user_id=cu.user_id";
  1333. } else {
  1334. $sql_users = "SELECT cu.id_user, u.lastname, u.firstname, u.email FROM $session_course_rel_user AS cu, $table_user AS u WHERE u.status!=1 and cu.course_code='".api_get_course_id()."' AND u.user_id=cu.id_user and cu.id_session='".$session_id."'";
  1335. }
  1336. $result_users = Database::query($sql_users);
  1337. $users_without_tasks = array();
  1338. while ($row_users = Database::fetch_row($result_users)) {
  1339. if (in_array($row_users[0], $users_with_tasks)) continue;
  1340. $user_id = array_shift($row_users);
  1341. $row_users[3] = $row_users[2];
  1342. $row_users[2] = Display::encrypted_mailto_link($row_users[2], $row_users[2]);
  1343. $users_without_tasks[] = $row_users;
  1344. }
  1345. return $users_without_tasks;
  1346. }
  1347. /**
  1348. * Display list of users who have not given the task
  1349. *
  1350. * @param int task id
  1351. * @return array
  1352. * @author cvargas carlos.vargas@beeznest.com cfasanando, christian.fasanado@beeznest.com
  1353. * @author Julio Montoya <gugli100@gmail.com> Fixes
  1354. */
  1355. function display_list_users_without_publication($task_id) {
  1356. global $origin;
  1357. $table_header[] = array(get_lang('LastName'), true);
  1358. $table_header[] = array(get_lang('FirstName'), true);
  1359. $table_header[] = array(get_lang('Email'), true);
  1360. // table_data
  1361. $table_data = get_list_users_without_publication($task_id);
  1362. $sorting_options = array();
  1363. $sorting_options['column'] = 1;
  1364. $paging_options = array();
  1365. $my_params = array();
  1366. if (isset($_GET['curdirpath'])) {
  1367. $my_params['curdirpath'] = Security::remove_XSS($_GET['curdirpath']);
  1368. }
  1369. if (isset($_GET['edit_dir'])) {
  1370. $my_params['edit_dir'] = Security::remove_XSS($_GET['edit_dir']);
  1371. }
  1372. if (isset($_GET['list'])) {
  1373. $my_params['list'] = Security::remove_XSS($_GET['list']);
  1374. }
  1375. $my_params['origin'] = $origin;
  1376. //$column_show
  1377. $column_show[] = 1;
  1378. $column_show[] = 1;
  1379. $column_show[] = 1;
  1380. Display::display_sortable_config_table($table_header, $table_data, $sorting_options, $paging_options, $my_params, $column_show);
  1381. }
  1382. /**
  1383. * Send reminder to users who have not given the task
  1384. *
  1385. * @param int
  1386. * @return array
  1387. * @author cvargas carlos.vargas@beeznest.com cfasanando, christian.fasanado@beeznest.com
  1388. */
  1389. function send_reminder_users_without_publication($task_id) {
  1390. global $_course, $my_cur_dir_path, $currentUserFirstName, $currentUserLastName, $currentUserEmail;
  1391. $emailsubject = '[' . api_get_setting('siteName') . '] ';
  1392. $sender_name = api_get_person_name($currentUserFirstName, $currentUserLastName, null, PERSON_NAME_EMAIL_ADDRESS);
  1393. $email_admin = $currentUserEmail;
  1394. // The body can be as long as you wish, and any combination of text and variables
  1395. $emailbody_user .= get_lang('ReminderToSubmitPendingTask')."\n".get_lang('CourseName').' : '.$_course['name']."\n";
  1396. $emailbody_user .= get_lang('WorkName').' : '.substr($my_cur_dir_path, 0, -1)."\n\n".get_lang('Teacher').' : '.api_get_person_name($currentUserFirstName, $currentUserLastName)."\n".get_lang('Email').' : '.$currentUserEmail;
  1397. $list_users = get_list_users_without_publication($task_id);
  1398. foreach ($list_users as $user) {
  1399. $name_user = api_get_person_name($user[0], $user[1], null, PERSON_NAME_EMAIL_ADDRESS);
  1400. @api_mail($name_user, $user[3], $emailsubject, $emailbody_user, $sender_name, $email_admin);
  1401. }
  1402. }
  1403. /**
  1404. * Sends an email to the students of a course when a homework is created
  1405. *
  1406. * @param string course_id
  1407. *
  1408. * @author Guillaume Viguier <guillaume.viguier@beeznest.com>
  1409. */
  1410. function send_email_on_homework_creation($course_id) {
  1411. require_once api_get_path(LIBRARY_PATH).'course.lib.php';
  1412. // Get the students of the course
  1413. $students = CourseManager::get_student_list_from_course_code($course_id);
  1414. $emailsubject = '[' . api_get_setting('siteName') . '] '.get_lang('HomeworkCreated');
  1415. $currentUser = api_get_user_info(api_get_user_id());
  1416. foreach($students as $student) {
  1417. $user_info = api_get_user_info($student["user_id"]);
  1418. if(!empty($user_info["mail"])) {
  1419. $name_user = api_get_person_name($user_info["firstname"], $user_info["lastname"], null, PERSON_NAME_EMAIL_ADDRESS);
  1420. $emailbody = get_lang('Dear')." ".$name_user.",\n\n";
  1421. $emailbody .= get_lang('HomeworkHasBeenCreatedForTheCourse')." ".$course_id.". "."\n\n".get_lang('PleaseCheckHomeworkPage');
  1422. $emailbody .= "\n\n".api_get_person_name($currentUser["firstname"], $currentUser["lastname"]);
  1423. @api_mail($name_user, $user_info["mail"], $emailsubject, $emailbody, api_get_person_name($currentUser["firstname"], $currentUser["lastname"], null, PERSON_NAME_EMAIL_ADDRESS), $currentUser["mail"]);
  1424. }
  1425. }
  1426. }
  1427. function is_work_exist_by_url($url) {
  1428. $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);
  1429. $url = Database::escape_string($url);
  1430. $sql = "SELECT id FROM $work_table WHERE url='$url'";
  1431. $result = Database::query($sql);
  1432. if (Database::num_rows($result)> 0) {
  1433. $row = Database::fetch_row($result);
  1434. if (empty($row)) {
  1435. return false;
  1436. } else {
  1437. return true;
  1438. }
  1439. } else {
  1440. return false;
  1441. }
  1442. }