dropbox_init.inc.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @desc The dropbox is a personal (peer to peer) file exchange module that allows
  5. * you to send documents to a certain (group of) users.
  6. *
  7. * @version 1.3
  8. *
  9. * @author Jan Bols <jan@ivpv.UGent.be>, main programmer, initial version
  10. * @author René Haentjens <rene.haentjens@UGent.be>, several contributions
  11. * @author Roan Embrechts, virtual course support
  12. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University (see history version 1.3)
  13. *
  14. * @package chamilo.dropbox
  15. *
  16. * @todo complete refactoring. Currently there are about at least 3 sql queries needed for every individual dropbox document.
  17. * first we find all the documents that were sent (resp. received) by the user
  18. * then for every individual document the user(s)information who received (resp. sent) the document is searched
  19. * then for every individual document the feedback is retrieved
  20. * @todo the implementation of the dropbox categories could (on the database level) have been done more elegantly by storing the category
  21. * in the dropbox_person table because this table stores the relationship between the files (sent OR received) and the users
  22. */
  23. /**
  24. HISTORY
  25. Version 1.1
  26. ------------
  27. - 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.
  28. - 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.
  29. - dropbox_init1.inc.php: the databasetable name in the variable $dropbox_cnf["introTbl"] is chnged from "introduction" to "tool_intro"
  30. - install.php: after submit, checks if the database uses accueil or tool_list as a tablename
  31. - index.php: removed the behaviour of only the teachers that are allowed to delete entries
  32. - index.php: added field "lastUploadDate" in table dropbox_file to store information about last update when resubmiting a file
  33. - dropbox.inc.php: added $lang["lastUpdated"]
  34. - index.php: entries in received list show when file was last updated if it is updated
  35. - index.php: entries in sent list show when file was last resent if it was resent
  36. - index.php: add POST-variable to the upload form with overwrite data when user decides to overwrite the previous sent file with new file
  37. - dropbox_submit.php: add sanity checks on POST['overwrite'] data
  38. - index.php: remove title field in upload form
  39. - dropbox_init1.inc.php: added $dropbox_cnf["version"] variable
  40. - dropbox_class.inc.php: add $this->lastUploadDate to Dropbox_work class
  41. - dropbox.inc.php: added $lang['emptyTable']
  42. - index.php: if the received or sent list is empty, a message is displayed
  43. - 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
  44. - index.php: add check to see if column lastUploadDate exists in filetable
  45. - index.php: moved javascripts from dropbox_init2.inc.php to index.php
  46. - 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.
  47. - 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
  48. - index.php: assign all dates of entries in list to the class="dropbox_date" and add CSS
  49. - index.php: assign all persons in entries of list to the class="dropbox_person" and add CSS
  50. - dropbox.inc.php: added $lang['dropbox_version'] to indicate the lates version. This must be equal to the $dropbox_cnf['version'] variable.
  51. - 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.
  52. - 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
  53. - dropbox_download.php: remove https specific headers because they're not necessary
  54. - dropbox_download.php: use application/octet-stream as the default mime and inline as the default Content-Disposition
  55. - dropbox.inc.php: add lang vars for "order by" action
  56. - dropbox_class.inc.php: add methods orderSentWork, orderReceivedWork en _cmpWork and propery _orderBy to class Dropbox_person to take care of sorting
  57. - index.php: add selectionlist to headers of sent/received lists to select "order by" and add code to keep selected value in sessionvar.
  58. - 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
  59. - index.php: add filesize info in sent/received lists
  60. - dropbox_submit.php: resubmit prevention only for GET action, because it gives some annoying behaviour in POST situation: white screen in IE6
  61. Version 1.2
  62. -----------
  63. - adapted entire dropbox tool so it can be used as a default tool in Dokeos 1.5
  64. - index.php: add event registration to log use of tool in stats tables
  65. - index.php: upload form checks for correct user selection and file specification before uploading the script
  66. - dropbox_init1.inc.php: added dropbox_cnf["allowOverwrite"] to allow or disallow overwriting of files
  67. - index.php: author name textbox is automatically filled in
  68. - mailing functionality (René Haentjens)
  69. - allowStudentToStudent and allowJustUpload options (id.)
  70. - help in separate window (id.)
  71. Version 1.3 (Patrick Cool)
  72. --------------------------
  73. - sortable table
  74. - categories
  75. - fixing a security hole
  76. - tabs (which can be disabled: see $dropbox_cnf['sent_received_tabs'])
  77. - same action on multiple documents ([zip]download, move, delete)
  78. - consistency with the docuements tool (open/download file, icons of documents, ...)
  79. - zip download of complete folder
  80. Version 1.4 (Yannick Warnier)
  81. -----------------------------
  82. - removed all self-built database tables names
  83. */
  84. /**
  85. * First initialisation file with initialisation of variables and
  86. * without outputting anything to browser.
  87. * 1. Calls global.inc.php and lang file
  88. * 2. Initialises $dropbox_cnf array with all relevant vars
  89. * 3. Often used functions
  90. *
  91. * @version 1.31
  92. * @copyright 2004-2005
  93. * @author Jan Bols <jan@ivpv.UGent.be>, main programmer
  94. * @author René Haentjens, severalcontributions <rene.haentjens@UGent.be>
  95. * @author Roan Embrechts, virtual course support
  96. * @author Patrick Cool <patrick.cool@UGent.be>
  97. Chamilo Config Settings (AWACS)
  98. Refactoring
  99. tool introduction
  100. folders
  101. download file / folder (download icon)
  102. same action on multiple documents
  103. extended feedback
  104. * @package chamilo.dropbox
  105. */
  106. use ChamiloSession as Session;
  107. // including the basic Chamilo initialisation file
  108. require_once __DIR__.'/../inc/global.inc.php';
  109. $is_allowed_in_course = api_is_allowed_in_course();
  110. $is_courseTutor = api_is_course_tutor();
  111. $is_courseAdmin = api_is_course_admin();
  112. $current_course_tool = TOOL_DROPBOX;
  113. // the dropbox file that contains additional functions
  114. require_once 'dropbox_functions.inc.php';
  115. // protecting the script
  116. api_protect_course_script();
  117. $user_id = api_get_user_id();
  118. $course_code = api_get_course_id();
  119. $course_info = api_get_course_info($course_code);
  120. $session_id = api_get_session_id();
  121. $action = isset($_GET['action']) ? $_GET['action'] : null;
  122. $view = isset($_GET['view']) ? Security::remove_XSS($_GET['view']) : null;
  123. $postAction = isset($_POST['action']) ? $_POST['action'] : null;
  124. if (api_is_excluded_user_type()) {
  125. api_not_allowed(true);
  126. }
  127. if (empty($session_id)) {
  128. $is_course_member = CourseManager::is_user_subscribed_in_course(
  129. $user_id,
  130. $course_code,
  131. false
  132. );
  133. } else {
  134. $is_course_member = CourseManager::is_user_subscribed_in_course(
  135. $user_id,
  136. $course_code,
  137. true,
  138. $session_id
  139. );
  140. }
  141. /* Object Initialisation */
  142. // we need this here because the javascript to re-upload the file needs an array
  143. // off all the documents that have already been sent.
  144. // @todo consider moving the javascripts in a function that displays the javascripts
  145. // only when it is needed.
  146. if ($action == 'add') {
  147. $dropbox_person = new Dropbox_Person(
  148. $_user['user_id'],
  149. $is_courseAdmin,
  150. $is_courseTutor
  151. );
  152. }
  153. /* Create javascript and htmlHeaders */
  154. $javascript = "<script>
  155. function confirmsend()
  156. {
  157. if (confirm(\"".get_lang('MailingConfirmSend', '')."\")){
  158. return true;
  159. } else {
  160. return false;
  161. }
  162. return true;
  163. }
  164. function confirmation (name)
  165. {
  166. if (confirm(\"".get_lang('ConfirmDelete', '')." : \"+ name )){
  167. return true;
  168. } else {
  169. return false;
  170. }
  171. return true;
  172. }
  173. function checkForm (frm)
  174. {
  175. if (frm.elements['recipients[]'].selectedIndex < 0){
  176. alert(\"".get_lang('NoUserSelected', '')."\");
  177. return false;
  178. } else if (frm.file.value == '') {
  179. alert(\"".get_lang('NoFileSpecified', '')."\");
  180. return false;
  181. } else {
  182. return true;
  183. }
  184. }
  185. ";
  186. $allowOverwrite = api_get_setting('dropbox_allow_overwrite');
  187. if ($allowOverwrite == 'true') {
  188. //sentArray keeps list of all files still available in the sent files list
  189. //of the user.
  190. //This is used to show or hide the overwrite file-radio button of the upload form
  191. $javascript .= "
  192. var sentArray = new Array(";
  193. if (isset($dropbox_person)) {
  194. for ($i = 0; $i < count($dropbox_person->sentWork); $i++) {
  195. if ($i > 0) {
  196. $javascript .= ", ";
  197. }
  198. $javascript .= "'".$dropbox_person->sentWork[$i]->title."'";
  199. }
  200. }
  201. $javascript .= ");
  202. function checkfile(str)
  203. {
  204. ind = str.lastIndexOf('/'); //unix separator
  205. if (ind == -1) ind = str.lastIndexOf('\\\'); //windows separator
  206. filename = str.substring(ind+1, str.length);
  207. found = 0;
  208. for (i=0; i<sentArray.length; i++) {
  209. if (sentArray[i] == filename) found=1;
  210. }
  211. //always start with unchecked box
  212. el = getElement('cb_overwrite');
  213. el.checked = false;
  214. //show/hide checkbox
  215. if (found == 1) {
  216. displayEl('overwrite');
  217. } else {
  218. undisplayEl('overwrite');
  219. }
  220. }
  221. function getElement(id)
  222. {
  223. return document.getElementById ? document.getElementById(id) :
  224. document.all ? document.all(id) : null;
  225. }
  226. function displayEl(id)
  227. {
  228. var el = getElement(id);
  229. if (el && el.style) el.style.display = '';
  230. }
  231. function undisplayEl(id)
  232. {
  233. var el = getElement(id);
  234. if (el && el.style) el.style.display = 'none';
  235. }";
  236. }
  237. $javascript .= "
  238. </script>";
  239. $htmlHeadXtra[] = $javascript;
  240. $htmlHeadXtra[] ="<script>
  241. function confirmation (name)
  242. {
  243. if (confirm(\" ". get_lang("AreYouSureToDeleteJS") ." \"+ name + \" ?\"))
  244. {return true;}
  245. else
  246. {return false;}
  247. }
  248. </script>";
  249. Session::write('javascript', $javascript);
  250. $htmlHeadXtra[] = '<meta http-equiv="cache-control" content="no-cache">
  251. <meta http-equiv="pragma" content="no-cache">
  252. <meta http-equiv="expires" content="-1">';
  253. $htmlHeadXtra[] = api_get_jquery_libraries_js(array('jquery-ui', 'jquery-upload'));
  254. $htmlHeadXtra[] = "<script>
  255. $(function () {
  256. $('#recipient_form').on('change', function() {
  257. $('#multiple_form').show();
  258. });
  259. });
  260. </script>";
  261. $checked_files = false;
  262. if (!$view || $view == 'received') {
  263. $part = 'received';
  264. } elseif ($view = 'sent') {
  265. $part = 'sent';
  266. } else {
  267. header('location: index.php?view='.$view.'&error=Error');
  268. exit;
  269. }
  270. if (($postAction == 'download_received' || $postAction == 'download_sent') and !$_POST['store_feedback']) {
  271. $checked_file_ids = $_POST['id'];
  272. if (!is_array($checked_file_ids) || count($checked_file_ids) == 0) {
  273. header('location: index.php?view='.$view.'&error=CheckAtLeastOneFile');
  274. } else {
  275. handle_multiple_actions();
  276. }
  277. exit;
  278. }
  279. /*
  280. * AUTHORISATION SECTION
  281. * Prevents access of all users that are not course members
  282. */
  283. if ((!$is_allowed_in_course || !$is_course_member) && !api_is_allowed_to_edit(null, true)) {
  284. if ($origin != 'learnpath') {
  285. api_not_allowed(true);//print headers/footers
  286. } else {
  287. api_not_allowed();
  288. }
  289. exit();
  290. }
  291. /* BREADCRUMBS */
  292. if ($view == 'received') {
  293. $interbreadcrumb[] = array(
  294. 'url' => api_get_path(WEB_CODE_PATH).'dropbox/index.php?'.api_get_cidreq(),
  295. 'name' => get_lang('Dropbox', ''),
  296. );
  297. $nameTools = get_lang('ReceivedFiles');
  298. if ($action == 'addreceivedcategory') {
  299. $interbreadcrumb[] = array(
  300. 'url' => api_get_path(WEB_CODE_PATH).'dropbox/index.php?view=received&'.api_get_cidreq(),
  301. 'name' => get_lang('ReceivedFiles'),
  302. );
  303. $nameTools = get_lang('AddNewCategory');
  304. }
  305. }
  306. if ($view == 'sent' || empty($view)) {
  307. $interbreadcrumb[] = array(
  308. 'url' => api_get_path(WEB_CODE_PATH).'dropbox/index.php?'.api_get_cidreq(),
  309. 'name' => get_lang('Dropbox')
  310. );
  311. $nameTools = get_lang('SentFiles');
  312. if ($action == 'addsentcategory') {
  313. $interbreadcrumb[] = array(
  314. 'url' => api_get_path(WEB_CODE_PATH).'dropbox/index.php?view=sent&'.api_get_cidreq(),
  315. 'name' => get_lang('SentFiles'),
  316. );
  317. $nameTools = get_lang('AddNewCategory');
  318. }
  319. if ($action == 'add') {
  320. $interbreadcrumb[] = array(
  321. 'url' => api_get_path(WEB_CODE_PATH).'dropbox/index.php?view=sent&'.api_get_cidreq(),
  322. 'name' => get_lang('SentFiles'),
  323. );
  324. $nameTools = get_lang('UploadNewFile');
  325. }
  326. }
  327. /* HEADER & TITLE */
  328. if (isset($origin) && $origin == 'learnpath') {
  329. $htmlHeadXtra[] = $javascript;
  330. Display::display_reduced_header($nameTools, 'Dropbox');
  331. } else {
  332. Display::display_header($nameTools, 'Dropbox');
  333. }