index.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594
  1. <?php // $Id: index.php,v 1.46 2005/09/26 10:20:25 pcool Exp $
  2. /*
  3. ==============================================================================
  4. Dokeos - elearning and course management software
  5. Copyright (c) 2006-2008 Dokeos S.A.
  6. Copyright (c) 2006 Ghent University (UGent)
  7. Copyright (c) various contributors
  8. For a full list of contributors, see "credits.txt".
  9. The full license can be read in "license.txt".
  10. This program is free software; you can redistribute it and/or
  11. modify it under the terms of the GNU General Public License
  12. as published by the Free Software Foundation; either version 2
  13. of the License, or (at your option) any later version.
  14. See the GNU General Public License for more details.
  15. Contact address: Dokeos, 44 rue des palais, B-1030 Brussels, Belgium
  16. Mail: info@dokeos.com
  17. ==============================================================================
  18. */
  19. /**
  20. ==============================================================================
  21. * @desc The dropbox is a personal (peer to peer) file exchange module that allows
  22. * you to send documents to a certain (group of) users.
  23. *
  24. * @version 1.3
  25. *
  26. * @author Jan Bols <jan@ivpv.UGent.be>, main programmer, initial version
  27. * @author Ren� Haentjens <rene.haentjens@UGent.be>, several contributions (see RH)
  28. * @author Roan Embrechts, virtual course support
  29. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University (see history version 1.3)
  30. *
  31. * @package dokeos.dropbox
  32. *
  33. * @todo complete refactoring. Currently there are about at least 3 sql queries needed for every individual dropbox document.
  34. * first we find all the documents that were sent (resp. received) by the user
  35. * then for every individual document the user(s)information who received (resp. sent) the document is searched
  36. * then for every individual document the feedback is retrieved
  37. * @todo the implementation of the dropbox categories could (on the database level) have been done more elegantly by storing the category
  38. * in the dropbox_person table because this table stores the relationship between the files (sent OR received) and the users
  39. ==============================================================================
  40. */
  41. /**
  42. ==============================================================================
  43. HISTORY
  44. ==============================================================================
  45. Version 1.1
  46. ------------
  47. - dropbox_init1.inc.php: changed include statements to require statements. This way if a file is not found, it stops the execution of a script instead of continuing with warnings.
  48. - dropbox_init1.inc.php: the include files "claro_init_global.inc.php" & "debug.lib.inc.php" are first checked for their existence before including them. If they don't exist, in the .../include dir, they get loaded from the .../inc dir. This change is necessary because the UCL changed the include dir to inc.
  49. - dropbox_init1.inc.php: the databasetable name in the variable $dropbox_cnf["introTbl"] is chnged from "introduction" to "tool_intro"
  50. - install.php: after submit, checks if the database uses accueil or tool_list as a tablename
  51. - index.php: removed the behaviour of only the teachers that are allowed to delete entries
  52. - index.php: added field "lastUploadDate" in table dropbox_file to store information about last update when resubmiting a file
  53. - dropbox.inc.php: added $lang["lastUpdated"]
  54. - index.php: entries in received list show when file was last updated if it is updated
  55. - index.php: entries in sent list show when file was last resent if it was resent
  56. - dropbox_submit.php: add a unique id to every uploaded file
  57. - index.php: add POST-variable to the upload form with overwrite data when user decides to overwrite the previous sent file with new file
  58. - dropbox_submit.php: add sanity checks on POST['overwrite'] data
  59. - index.php: remove title field in upload form
  60. - dropbox_submit.php: remove use of POST['title'] variable
  61. - dropbox_init1.inc.php: added $dropbox_cnf["version"] variable
  62. - dropbox_class.inc.php: add $this->lastUploadDate to Dropbox_work class
  63. - dropbox.inc.php: added $lang['emptyTable']
  64. - index.php: if the received or sent list is empty, a message is displayed
  65. - dropbox_download.php: the $file var is set equal to the title-field of the filetable. So not constructed anymore by substracting the username from the filename
  66. - index.php: add check to see if column lastUploadDate exists in filetable
  67. - index.php: moved javascripts from dropbox_init2.inc.php to index.php
  68. - index.php: when specifying an uploadfile in the form, a checkbox allowing the user to overwrite a previously sent file is shown when the specified file has the same name as a previously uploaded file of that user.
  69. - index.php: assign all the metadata (author, description, date, recipient, sender) of an entry in a list to the class="dropbox_detail" and add css to html-header
  70. - index.php: assign all dates of entries in list to the class="dropbox_date" and add CSS
  71. - index.php: assign all persons in entries of list to the class="dropbox_person" and add CSS
  72. - dropbox.inc.php: added $lang['dropbox_version'] to indicate the lates version. This must be equal to the $dropbox_cnf['version'] variable.
  73. - dropbox_init1.inc.php: if the newest lang file isn't loaded by claro_init_global.inc.php from the .../lang dir it will be loaded locally from the .../plugin/dropbox/ dir. This way an administrator must not install the dropbox.inc.php in the .../lang/english dir, but he can leave it in the local .../plugin/dropbox/ dir. However if you want to present multiple language translations of the file you must still put the file in the /lang/ dir, because there is no language management system inside the .../plugin/dropbox dir.
  74. - mime.inc.php: created this file. It contains an array $mimetype with all the mimetypes that are used by dropbox_download.php to give hinst to the browser during download about content
  75. - dropbox_download.php: remove https specific headers because they're not necessary
  76. - dropbox_download.php: use application/octet-stream as the default mime and inline as the default Content-Disposition
  77. - dropbox.inc.php: add lang vars for "order by" action
  78. - dropbox_class.inc.php: add methods orderSentWork, orderReceivedWork en _cmpWork and propery _orderBy to class Dropbox_person to take care of sorting
  79. - index.php: add selectionlist to headers of sent/received lists to select "order by" and add code to keep selected value in sessionvar.
  80. - index.php: moved part of a <a> hyperlink to previous line to remove the underlined space between symbol and title of a work entry in the sent/received list
  81. - index.php: add filesize info in sent/received lists
  82. - dropbox_submit.php: resubmit prevention only for GET action, because it gives some annoying behaviour in POST situation: white screen in IE6
  83. Version 1.2
  84. -----------
  85. - adapted entire dropbox tool so it can be used as a default tool in Dokeos 1.5
  86. - index.php: add event registration to log use of tool in stats tables
  87. - index.php: upload form checks for correct user selection and file specification before uploading the script
  88. - dropbox_init1.inc.php: added dropbox_cnf["allowOverwrite"] to allow or disallow overwriting of files
  89. - index.php: author name textbox is automatically filled in
  90. - mailing functionality (see RH comments in code)
  91. - allowStudentToStudent and allowJustUpload options (id.)
  92. - help in separate window (id.)
  93. Version 1.3 (Patrick Cool)
  94. --------------------------
  95. - sortable table
  96. - categories
  97. - fixing a security hole
  98. - tabs (which can be disabled: see $dropbox_cnf['sent_received_tabs'])
  99. - same action on multiple documents ([zip]download, move, delete)
  100. - consistency with the docuements tool (open/download file, icons of documents, ...)
  101. - zip download of complete folder
  102. Version 1.4 (Yannick Warnier)
  103. -----------------------------
  104. - removed all self-built database tables names
  105. ==============================================================================
  106. */
  107. /*
  108. ==============================================================================
  109. INIT SECTION
  110. ==============================================================================
  111. */
  112. // the file that contains all the initialisation stuff (and includes all the configuration stuff)
  113. require_once( "dropbox_init.inc.php");
  114. // get the last time the user accessed the tool
  115. if ($_SESSION['last_access'][$_course['id']][TOOL_DROPBOX]=='')
  116. {
  117. $last_access=get_last_tool_access(TOOL_DROPBOX,$_course['code'],$_user['user_id']);
  118. $_SESSION['last_access'][$_course['id']][TOOL_DROPBOX]=$last_access;
  119. }
  120. else
  121. {
  122. $last_access=$_SESSION['last_access'][$_course['id']][TOOL_DROPBOX];
  123. }
  124. // do the tracking
  125. event_access_tool(TOOL_DROPBOX);
  126. //this var is used to give a unique value to every page request. This is to prevent resubmiting data
  127. $dropbox_unid = md5( uniqid( rand( ), true));
  128. /*
  129. ==============================================================================
  130. DISPLAY SECTION
  131. ==============================================================================
  132. */
  133. // Tool introduction text
  134. Display::display_introduction_section(TOOL_DROPBOX);
  135. /*
  136. -----------------------------------------------------------
  137. ACTIONS: add a dropbox file, add a dropbox category.
  138. -----------------------------------------------------------
  139. */
  140. // *** display the form for adding a new dropbox item. ***
  141. if ($_GET['action']=="add")
  142. {
  143. display_add_form();
  144. }
  145. if ($_POST['submitWork'])
  146. {
  147. $check = Security::check_token();
  148. if($check)
  149. {
  150. Display :: display_normal_message(store_add_dropbox());
  151. //include_once('dropbox_submit.php');
  152. }
  153. }
  154. // *** display the form for adding a category ***
  155. if ($_GET['action']=="addreceivedcategory" or $_GET['action']=="addsentcategory")
  156. {
  157. display_addcategory_form($_POST['category_name']);
  158. }
  159. // *** editing a category: displaying the form ***
  160. if ($_GET['action']=='editcategory' and isset($_GET['id']))
  161. {
  162. if (!$_POST)
  163. {
  164. display_addcategory_form('',$_GET['id']);
  165. }
  166. }
  167. // *** storing a new or edited category ***
  168. if ($_POST['StoreCategory'])
  169. {
  170. Display :: display_normal_message(store_addcategory());
  171. }
  172. // *** Move a File ***
  173. if (($_GET['action']=='movesent' OR $_GET['action']=='movereceived') AND isset($_GET['move_id']))
  174. {
  175. display_move_form(str_replace('move','',$_GET['action']), $_GET['move_id'], get_dropbox_categories(str_replace('move','',$_GET['action'])));
  176. }
  177. if ($_POST['do_move'])
  178. {
  179. Display :: display_normal_message(store_move($_POST['id'], $_POST['move_target'], $_POST['part']));
  180. }
  181. // *** Delete a file ***
  182. if (($_GET['action']=='deletereceivedfile' OR $_GET['action']=='deletesentfile') AND isset($_GET['id']) AND is_numeric($_GET['id']))
  183. {
  184. $dropboxfile=new Dropbox_Person( $_user['user_id'], $is_courseAdmin, $is_courseTutor);
  185. if ($_GET['action']=='deletereceivedfile')
  186. {
  187. $dropboxfile->deleteReceivedWork($_GET['id']);
  188. $message=get_lang('ReceivedFileDeleted');
  189. }
  190. if ($_GET['action']=='deletesentfile')
  191. {
  192. $dropboxfile->deleteSentWork($_GET['id']);
  193. $message=get_lang('SentFileDeleted');
  194. }
  195. Display :: display_normal_message($message);
  196. }
  197. // *** Delete a category ***
  198. if (($_GET['action']=='deletereceivedcategory' OR $_GET['action']=='deletesentcategory') AND isset($_GET['id']) AND is_numeric($_GET['id']))
  199. {
  200. $message=delete_category($_GET['action'], $_GET['id']);
  201. }
  202. // *** Do an action on multiple files ***
  203. // only the download has is handled separately in dropbox_init_inc.php because this has to be done before the headers are sent
  204. // (which also happens in dropbox_init.inc.php
  205. if (!isset($_POST['feedback']) && ($_POST['action'] == 'delete_received' OR $_POST['action'] == 'download_received' OR $_POST['action'] == 'delete_sent' OR $_POST['action'] == 'download_sent'))
  206. {
  207. $display_message=handle_multiple_actions();
  208. Display :: display_normal_message($display_message);
  209. }
  210. // *** Store Feedback ***
  211. if ($_POST['feedback'])
  212. {
  213. $display_message = store_feedback();
  214. Display :: display_normal_message($display_message);
  215. }
  216. // *** Error Message ***
  217. if (isset($_GET['error']) AND !empty($_GET['error']))
  218. {
  219. Display :: display_normal_message(get_lang($_GET['error']));
  220. }
  221. if ($_GET['action']!="add")
  222. {
  223. // getting all the categories in the dropbox for the given user
  224. $dropbox_categories=get_dropbox_categories();
  225. // creating the arrays with the categories for the received files and for the sent files
  226. foreach ($dropbox_categories as $category)
  227. {
  228. if ($category['received']=='1')
  229. {
  230. $dropbox_received_category[]=$category;
  231. }
  232. if ($category['sent']=='1')
  233. {
  234. $dropbox_sent_category[]=$category;
  235. }
  236. }
  237. /*
  238. -----------------------------------------------------------
  239. THE MENU TABS
  240. -----------------------------------------------------------
  241. */
  242. if ($dropbox_cnf['sent_received_tabs'])
  243. {
  244. ?>
  245. <div id="tabbed_menu">
  246. <ul id="tabbed_menu_tabs">
  247. <li><a href="index.php?<?php echo api_get_cidreq();?>&view=received" <?php if (!$_GET['view'] OR $_GET['view']=='received'){echo 'class="active"';}?> ><?php echo get_lang('ReceivedFiles'); ?></a></li>
  248. <li><a href="index.php?<?php echo api_get_cidreq();?>&view=sent" <?php if ($_GET['view']=='sent'){echo 'class="active"';}?>><?php echo get_lang('SentFiles'); ?></a></li>
  249. </ul>
  250. </div>
  251. <?php
  252. }
  253. /*
  254. -----------------------------------------------------------
  255. RECEIVED FILES
  256. -----------------------------------------------------------
  257. */
  258. if (!$_GET['view'] OR $_GET['view']=='received' OR $dropbox_cnf['sent_received_tabs']==false)
  259. {
  260. //echo '<h3>'.get_lang('ReceivedFiles').'</h3>';
  261. // This is for the categories
  262. if (isset($_GET['view_received_category']) AND $_GET['view_received_category']<>'')
  263. {
  264. $view_dropbox_category_received=$_GET['view_received_category'];
  265. }
  266. else
  267. {
  268. $view_dropbox_category_received=0;
  269. }
  270. /* *** Menu Received *** */
  271. if ($view_dropbox_category_received<>0)
  272. {
  273. echo get_lang('CurrentlySeeing').': <strong>'.$dropbox_categories[$view_dropbox_category_received]['cat_name'].'</strong><br />';
  274. echo '<img src="../img/folder_up.gif" alt="'.get_lang('up').'" align="absmiddle" /><a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category=0&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'">'.get_lang('Root')."</a>\n";
  275. }
  276. echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&action=addreceivedcategory"><img src="../img/folder_new.gif" align=\"absmiddle\"/> '.get_lang('AddNewCategory').'</a>';
  277. // object initialisation
  278. $dropbox_person = new Dropbox_Person( $_user['user_id'], $is_courseAdmin, $is_courseTutor); // note: are the $is_courseAdmin and $is_courseTutor parameters needed????
  279. // constructing the array that contains the total number of feedback messages per document.
  280. $number_feedback=get_total_number_feedback();
  281. // sorting and paging options
  282. $sorting_options = array();
  283. $paging_options = array();
  284. // the headers of the sortable tables
  285. $column_header=array();
  286. $column_header[] = array('',false,'');
  287. $column_header[] = array(get_lang('Type'),true,'style="width:40px"');
  288. $column_header[] = array(get_lang('ReceivedTitle'), TRUE, '');
  289. $column_header[] = array(get_lang('Size'), TRUE, '');
  290. $column_header[] = array(get_lang('Authors'), TRUE, '');
  291. $column_header[] = array(get_lang('LastResent'), true);
  292. $column_header[] = array(get_lang('Modify'), FALSE, '', 'nowrap style="text-align: right"');
  293. $column_header[] = array('RealDate', true);
  294. // An array with the setting of the columns -> 1: columns that we will show, 0:columns that will be hide
  295. $column_show[]=1;
  296. $column_show[]=1;
  297. $column_show[]=1;
  298. $column_show[]=1;
  299. $column_show[]=1;
  300. $column_show[]=1;
  301. $column_show[]=1;
  302. $column_show[]=0;
  303. // Here we change the way how the colums are going to be sort
  304. // in this case the the column of LastResent ( 4th element in $column_header) we will be order like the column RealDate
  305. // because in the column RealDate we have the days in a correct format "2008-03-12 10:35:48"
  306. $column_order[]=1;
  307. $column_order[]=2;
  308. $column_order[]=3;
  309. $column_order[]=4;
  310. $column_order[]=7;
  311. $column_order[]=6;
  312. $column_order[]=7;
  313. $column_order[]=8;
  314. // the content of the sortable table = the received files
  315. foreach ( $dropbox_person -> receivedWork as $dropbox_file)
  316. {
  317. $dropbox_file_data=array();
  318. if ($view_dropbox_category_received==$dropbox_file->category) // we only display the files that are in the category that we are in.
  319. {
  320. $dropbox_file_data[]=$dropbox_file->id;
  321. // new icon
  322. if ($dropbox_file->last_upload_date > $last_access AND !in_array($dropbox_file->id,$_SESSION['_seen'][$_course['id']][TOOL_DROPBOX]))
  323. {
  324. $new_icon='&nbsp;<img src="../img/new.gif" align="absmiddle" alt="'.get_lang('New').'" />';
  325. }
  326. else
  327. {
  328. $new_icon='';
  329. }
  330. $dropbox_file_data[]=build_document_icon_tag('file',$dropbox_file->title);
  331. $dropbox_file_data[]='<a href="dropbox_download.php?'.api_get_cidreq().'&id='.$dropbox_file->id.'&amp;action=download"><img src="../img/filesave.gif" style="float:right;" alt="'.get_lang('Save').'"/></a><a href="dropbox_download.php?'.api_get_cidreq().'&id='.$dropbox_file->id.'">'.$dropbox_file->title.'</a>'.$new_icon.'<br>'.$dropbox_file->description;
  332. $dropbox_file_data[]=ceil(($dropbox_file->filesize)/1024).' '.get_lang('kB');
  333. $dropbox_file_data[]=$dropbox_file->author;
  334. //$dropbox_file_data[]=$dropbox_file->description;
  335. $dropbox_file_data[]=date_to_str_ago($dropbox_file->last_upload_date).'<br><span class="dropbox_date">'.$dropbox_file->last_upload_date.'</span>';
  336. $action_icons=check_number_feedback($dropbox_file->id, $number_feedback).' '.get_lang('Feedback').'
  337. <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=viewfeedback&amp;id='.$dropbox_file->id.'"><img src="../img/comment_bubble.gif" alt="'.get_lang('Comment').'" align="absmiddle" /></a>
  338. <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=movereceived&amp;move_id='.$dropbox_file->id.'"><img src="../img/deplacer_fichier.gif" alt="'.get_lang('Move').'" align="absmiddle"/></a>
  339. <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=deletereceivedfile&amp;id='.$dropbox_file->id.'" onclick="return confirmation(\''.$dropbox_file->title.'\');"><img src="../img/delete.gif" alt="'.get_lang('Delete').'" align="absmiddle" /></a>';
  340. //$action_icons=' <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;action=movereceived&amp;move_id='.$dropbox_file->id.'"><img src="../img/deplacer.gif" alt="'.get_lang('Move').'"/></a>
  341. // <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;action=deletereceivedfile&amp;id='.$dropbox_file->id.'" onclick="return confirmation(\''.$dropbox_file->title.'\');"><img src="../img/delete.gif" alt="'.get_lang('Delete').'"/></a>';
  342. // this is a hack to have an additional row in a sortable table
  343. if($_GET['action']=='viewfeedback' AND isset($_GET['id']) and is_numeric($_GET['id']) AND $dropbox_file->id==$_GET['id'])
  344. {
  345. $action_icons.="</td></tr>\n"; // ending the normal row of the sortable table
  346. $action_icons.='<tr><td colspan="2"><a href="index.php?"'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category']."&amp;view_sent_category=".$_GET['view_sent_category']."&amp;view=".$_GET['view']."\">".get_lang('CloseFeedback')."</a></td><td colspan=\"7\">".feedback($dropbox_file->feedback2)."</td>\n</tr>\n";
  347. }
  348. $dropbox_file_data[]=$action_icons;
  349. $action_icons='';
  350. $dropbox_file_data[]=$dropbox_file->last_upload_date;//date
  351. $dropbox_data_recieved[]=$dropbox_file_data;
  352. }
  353. }
  354. // the content of the sortable table = the categories (if we are not in the root)
  355. if ($view_dropbox_category_received==0)
  356. {
  357. foreach ($dropbox_categories as $category) // note: this can probably be shortened since the categories for the received files are already in the $dropbox_received_category array;
  358. {
  359. $dropbox_category_data=array();
  360. if ($category['received']=='1')
  361. {
  362. $dropbox_category_data[]=''; // this is where the checkbox icon for the files appear
  363. // the icon of the category
  364. $dropbox_category_data[]=build_document_icon_tag('folder',$category['cat_name']);
  365. $dropbox_category_data[]='<a href="dropbox_download.php?'.api_get_cidreq().'&cat_id='.$category['cat_id'].'&amp;action=downloadcategory&amp;sent_received=received"><img width="16" height="16" src="../img/folder_zip.gif" style="float:right;" alt="'.get_lang('Save').'"/></a><a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$category['cat_id'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'">'.$category['cat_name'].'</a>';
  366. $dropbox_category_data[]='';
  367. $dropbox_category_data[]='';
  368. $dropbox_category_data[]='';
  369. $dropbox_category_data[]='<a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=editcategory&amp;id='.$category['cat_id'].'"><img src="../img/edit.gif" alt="'.get_lang('Edit').'" /></a>
  370. <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=deletereceivedcategory&amp;id='.$category['cat_id'].'" onclick="return confirmation(\''.$category['cat_name'].'\');"><img src="../img/delete.gif" alt="'.get_lang('Delete').'" /></a>';
  371. }
  372. if (is_array($dropbox_category_data) && count($dropbox_category_data)>0)
  373. {
  374. $dropbox_data_recieved[]=$dropbox_category_data;
  375. }
  376. }
  377. }
  378. // Displaying the table
  379. $additional_get_parameters=array('view'=>$_GET['view'], 'view_received_category'=>$_GET['view_received_category'],'view_sent_category'=>$_GET['view_sent_category']);
  380. Display::display_sortable_config_table($column_header, $dropbox_data_recieved, $sorting_options, $paging_options, $additional_get_parameters,$column_show,$column_order, array ('delete_received' => get_lang('Delete'),'download_received'=>get_lang('Download')));
  381. }
  382. /*
  383. -----------------------------------------------------------
  384. SENT FILES
  385. -----------------------------------------------------------
  386. */
  387. if ($_GET['view']=='sent' OR $dropbox_cnf['sent_received_tabs']==false)
  388. {
  389. //echo '<h3>'.get_lang('SentFiles').'</h3>';
  390. // This is for the categories
  391. if (isset($_GET['view_sent_category']) AND $_GET['view_sent_category']<>'')
  392. {
  393. $view_dropbox_category_sent=$_GET['view_sent_category'];
  394. }
  395. else
  396. {
  397. $view_dropbox_category_sent=0;
  398. }
  399. /* *** Menu Sent *** */
  400. if ($view_dropbox_category_sent<>0)
  401. {
  402. echo get_lang('CurrentlySeeing').': <strong>'.$dropbox_categories[$view_dropbox_category_sent]['cat_name'].'</strong><br />';
  403. echo '<img src="../img/folder_up.gif" alt="'.get_lang('Up').'" align="absmiddle" /><a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category=0&amp;view='.$_GET['view'].'">'.get_lang('Root')."</a>\n";
  404. }
  405. echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&view=".$_GET['view']."&amp;action=add\"><img src=\"../img/submit_file.gif\" align=\"absmiddle\"/> ".get_lang('UploadNewFile')."</a>&nbsp;\n";
  406. echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&view=".$_GET['view']."&amp;action=addsentcategory\"><img src=\"../img/folder_new.gif\" align=\"absmiddle\" /> ".get_lang('AddNewCategory')."</a>\n";
  407. //echo '<form name="sent_files" method="post" action="'.api_get_self().'?view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'">';
  408. // object initialisation
  409. $dropbox_person = new Dropbox_Person( $_user['user_id'], $is_courseAdmin, $is_courseTutor);
  410. // constructing the array that contains the total number of feedback messages per document.
  411. $number_feedback=get_total_number_feedback();
  412. // sorting and paging options
  413. $sorting_options = array();
  414. $paging_options = array();
  415. // the headers of the sortable tables
  416. $column_header=array();
  417. $column_header[] = array('',false,'');
  418. $column_header[] = array(get_lang('Type'),true,'style="width:40px"','style="text-align:center"');
  419. $column_header[] = array(get_lang('SentTitle'), TRUE, '');
  420. $column_header[] = array(get_lang('Size'), TRUE, '');
  421. $column_header[] = array(get_lang('SentTo'), TRUE, '');
  422. $column_header[] = array(get_lang('LastResent'), TRUE, '');
  423. $column_header[] = array(get_lang('Modify'), FALSE, '', 'nowrap style="text-align: right"');
  424. $column_header[] = array('RealDate', FALSE);
  425. $column_show=array();
  426. $column_order=array();
  427. // An array with the setting of the columns -> 1: columns that we will show, 0:columns that will be hide
  428. $column_show[]=1;
  429. $column_show[]=1;
  430. $column_show[]=1;
  431. $column_show[]=1;
  432. $column_show[]=1;
  433. $column_show[]=1;
  434. $column_show[]=1;
  435. $column_show[]=0;
  436. // Here we change the way how the colums are going to be sort
  437. // in this case the the column of LastResent ( 4th element in $column_header) we will be order like the column RealDate
  438. // because in the column RealDate we have the days in a correct format "2008-03-12 10:35:48"
  439. $column_order[]=1;
  440. $column_order[]=2;
  441. $column_order[]=3;
  442. $column_order[]=4;
  443. $column_order[]=7;
  444. $column_order[]=6;
  445. $column_order[]=7;
  446. $column_order[]=8;
  447. // the content of the sortable table = the received files
  448. foreach ( $dropbox_person -> sentWork as $dropbox_file)
  449. {
  450. $dropbox_file_data=array();
  451. if ($view_dropbox_category_sent==$dropbox_file->category)
  452. {
  453. $dropbox_file_data[]=$dropbox_file->id;
  454. $dropbox_file_data[]=build_document_icon_tag('file',$dropbox_file->title);
  455. $dropbox_file_data[]='<a href="dropbox_download.php?'.api_get_cidreq().'&id='.$dropbox_file->id.'&amp;action=download"><img src="../img/filesave.gif" style="float:right;" alt="'.get_lang('Save').'" /></a><a href="dropbox_download.php?'.api_get_cidreq().'&id='.$dropbox_file->id.'">'.$dropbox_file->title.'</a><br>'.$dropbox_file->description;
  456. $dropbox_file_data[]=ceil(($dropbox_file->filesize)/1024).' '.get_lang('kB');
  457. foreach ($dropbox_file->recipients as $recipient)
  458. {
  459. $receivers_celldata=display_user_link($recipient['user_id'], $recipient['name']).', '.$receivers_celldata;
  460. }
  461. $dropbox_file_data[]=$receivers_celldata;
  462. $dropbox_file_data[]=date_to_str_ago($dropbox_file->last_upload_date).'<br><span class="dropbox_date">'.$dropbox_file->last_upload_date.'</span>';
  463. //$dropbox_file_data[]=$dropbox_file->author;
  464. $receivers_celldata='';
  465. $action_icons=check_number_feedback($dropbox_file->id, $number_feedback).' '.get_lang('Feedback').'
  466. <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=viewfeedback&amp;id='.$dropbox_file->id.'"><img src="../img/comment_bubble.gif" alt="'.get_lang('Comment').'" align="absmiddle" /></a>
  467. <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=movesent&amp;move_id='.$dropbox_file->id.'"><img src="../img/deplacer_fichier.gif" alt="'.get_lang('Move').'" align="absmiddle"/></a>
  468. <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=deletesentfile&amp;id='.$dropbox_file->id.'" onclick="return confirmation(\''.$dropbox_file->title.'\');"><img src="../img/delete.gif" alt="'.get_lang('Delete').'" align="absmiddle" /></a>';
  469. // this is a hack to have an additional row in a sortable table
  470. if($_GET['action']=='viewfeedback' AND isset($_GET['id']) and is_numeric($_GET['id']) AND $dropbox_file->id==$_GET['id'])
  471. {
  472. $action_icons.="</td></tr>\n"; // ending the normal row of the sortable table
  473. $action_icons.="<tr>\n\t<td colspan=\"2\"><a href=\"index.php?".api_get_cidreq()."&view_received_category=".$_GET['view_received_category']."&amp;view_sent_category=".$_GET['view_sent_category']."&amp;view=".$_GET['view']."\">".get_lang('CloseFeedback')."</a></td><td colspan=\"7\">".feedback($dropbox_file->feedback2)."</td>\n</tr>\n";
  474. }
  475. $dropbox_file_data[]=$action_icons;
  476. $dropbox_file_data[]=$dropbox_file->last_upload_date;
  477. $action_icons='';
  478. $dropbox_data_sent[]=$dropbox_file_data;
  479. }
  480. }
  481. // the content of the sortable table = the categories (if we are not in the root)
  482. if ($view_dropbox_category_sent==0)
  483. {
  484. foreach ($dropbox_categories as $category)
  485. {
  486. $dropbox_category_data=array();
  487. if ($category['sent']=='1')
  488. {
  489. $dropbox_category_data[]=''; // this is where the checkbox icon for the files appear
  490. $dropbox_category_data[]=build_document_icon_tag('folder',$category['cat_name']);
  491. $dropbox_category_data[]='<a href="dropbox_download.php?'.api_get_cidreq().'&cat_id='.$category['cat_id'].'&amp;action=downloadcategory&amp;sent_received=sent"><img width="16" height="16" src="../img/folder_zip.gif" style="float:right;" alt="'.get_lang('Save').'" /></a><a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$category['cat_id'].'&amp;view='.$_GET['view'].'">'.$category['cat_name'].'</a>';
  492. //$dropbox_category_data[]='';
  493. $dropbox_category_data[]='';
  494. //$dropbox_category_data[]='';
  495. $dropbox_category_data[]='';
  496. $dropbox_category_data[]='';
  497. $dropbox_category_data[]='<a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=editcategory&id='.$category['cat_id'].'"><img src="../img/edit.gif" alt="'.get_lang('Edit').'"/></a>
  498. <a href="'.api_get_self().'?'.api_get_cidreq().'&view_received_category='.$_GET['view_received_category'].'&amp;view_sent_category='.$_GET['view_sent_category'].'&amp;view='.$_GET['view'].'&amp;action=deletesentcategory&amp;id='.$category['cat_id'].'" onclick="return confirmation(\''.$category['cat_name'].'\');"><img src="../img/delete.gif" alt="'.get_lang('Delete').'" /></a>';
  499. }
  500. if (is_array($dropbox_category_data) && count($dropbox_category_data)>0)
  501. {
  502. $dropbox_data_sent[]=$dropbox_category_data;
  503. }
  504. }
  505. }
  506. // Displaying the table
  507. $additional_get_parameters=array('view'=>$_GET['view'], 'view_received_category'=>$_GET['view_received_category'],'view_sent_category'=>$_GET['view_sent_category']);
  508. Display::display_sortable_config_table($column_header, $dropbox_data_sent, $sorting_options, $paging_options, $additional_get_parameters,$column_show,$column_order, array ('delete_received' => get_lang('Delete'),'download_received'=>get_lang('Download')));
  509. }
  510. }
  511. Display::display_footer();
  512. ?>