123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714 |
- <?php
- /* For licensing terms, see /license.txt */
- /**
- * Dropbox module for Chamilo
- * Classes for the dropbox module.
- *
- * 3 classes have been defined:
- * - Dropbox_Work:
- * . id
- * . uploader_id => who sent it
- * . uploaderName
- * . filename => name of file stored on the server
- * . filesize
- * . title => name of file returned to user. This is the original name of the file
- * except when the original name contained spaces. In that case the spaces
- * will be replaced by _
- * . description
- * . author
- * . upload_date => date when file was first sent
- * . last_upload_date => date when file was last sent
- * . isOldWork => has the work already been uploaded before
- *
- * . feedback_date => date of most recent feedback
- * . feedback => feedback text (or HTML?)
- *
- * - Dropbox_SentWork extends Dropbox_Work
- * . recipients => array of ["id"]["name"] lists the recipients of the work
- *
- * - Dropbox_Person:
- * . userId
- * . receivedWork => array of Dropbox_Work objects
- * . sentWork => array of Dropbox_SentWork objects
- * . isCourseTutor
- * . isCourseAdmin
- * . _orderBy => private property used for determining the field by which the works have to be ordered
- *
- * @version 1.30
- * @copyright 2004
- * @author Jan Bols <jan@ivpv.UGent.be>
- * with contributions by René Haentjens <rene.haentjens@UGent.be>
- * @package chamilo.dropbox
- */
- class Dropbox_Work
- {
- public $id;
- public $uploader_id;
- public $uploaderName;
- public $filename;
- public $filesize;
- public $title;
- public $description;
- public $author;
- public $upload_date;
- public $last_upload_date;
- public $isOldWork;
- public $feedback_date, $feedback;
- /**
- * Constructor calls private functions to create a new work or retreive an existing work from DB
- * depending on the number of parameters
- *
- * @param unknown_type $arg1
- * @param unknown_type $arg2
- * @param unknown_type $arg3
- * @param unknown_type $arg4
- * @param unknown_type $arg5
- * @param unknown_type $arg6
- * @return Dropbox_Work
- */
- public function Dropbox_Work($arg1, $arg2 = null, $arg3 = null, $arg4 = null, $arg5 = null, $arg6 = null)
- {
- if (func_num_args() > 1) {
- $this->_createNewWork($arg1, $arg2, $arg3, $arg4, $arg5, $arg6);
- } else {
- $this->_createExistingWork($arg1);
- }
- }
- /**
- * private function creating a new work object
- *
- * @param int $uploader_id
- * @param string $title
- * @param string $description
- * @param string $author
- * @param string $filename
- * @param int $filesize
- *
- * @todo $author was originally a field but this has now been replaced by the first and lastname of the uploader (to prevent anonymous uploads)
- * As a consequence this parameter can be removed
- */
- public function _createNewWork($uploader_id, $title, $description, $author, $filename, $filesize)
- {
- $_user = api_get_user_info();
- $dropbox_cnf = getDropboxConf();
- // Fill in the properties
- $this->uploader_id = intval($uploader_id);
- $this->uploaderName = getUserNameFromId($this->uploader_id);
- $this->filename = $filename;
- $this->filesize = $filesize;
- $this->title = $title;
- $this->description = $description;
- $this->author = api_get_person_name($_user['firstName'], $_user['lastName']);
- $this->last_upload_date = api_get_utc_datetime();
- $course_id = api_get_course_int_id();
- // Check if object exists already. If it does, the old object is used
- // with updated information (authors, description, upload_date)
- $this->isOldWork = false;
- $sql = "SELECT id, upload_date FROM ".$dropbox_cnf['tbl_file']."
- WHERE c_id = $course_id AND filename = '".Database::escape_string($this->filename)."'";
- $result = Database::query($sql);
- $res = Database::fetch_array($result);
- if ($res) {
- $this->isOldWork = true;
- }
- // Insert or update the dropbox_file table and set the id property
- if ($this->isOldWork) {
- $this->id = $res['id'];
- $this->upload_date = $res['upload_date'];
- $sql = "UPDATE ".$dropbox_cnf["tbl_file"]." SET
- filesize = '".Database::escape_string($this->filesize)."' ,
- title = '".Database::escape_string($this->title)."',
- description = '".Database::escape_string($this->description)."',
- author = '".Database::escape_string($this->author)."',
- last_upload_date = '".Database::escape_string($this->last_upload_date)."'
- WHERE c_id = $course_id AND id='".Database::escape_string($this->id)."'";
- Database::query($sql);
- } else {
- $this->upload_date = $this->last_upload_date;
- $sql = "INSERT INTO ".$dropbox_cnf['tbl_file']." (c_id, uploader_id, filename, filesize, title, description, author, upload_date, last_upload_date, session_id)
- VALUES ( $course_id,
- '".Database::escape_string($this->uploader_id)."'
- , '".Database::escape_string($this->filename)."'
- , '".Database::escape_string($this->filesize)."'
- , '".Database::escape_string($this->title)."'
- , '".Database::escape_string($this->description)."'
- , '".Database::escape_string($this->author)."'
- , '".Database::escape_string($this->upload_date)."'
- , '".Database::escape_string($this->last_upload_date)."'
- , ".api_get_session_id()."
- )";
- Database::query($sql);
- $this->id = Database::insert_id(); // Get automatically inserted id
- }
- $sql = "SELECT count(file_id) as count FROM ".$dropbox_cnf['tbl_person']."
- WHERE c_id = $course_id AND file_id = '".Database::escape_string($this->id)."' AND user_id = ".$this->uploader_id;
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- if ($row['count'] == 0) {
- // Insert entries into person table
- $sql = "INSERT INTO ".$dropbox_cnf['tbl_person']." (c_id, file_id, user_id)
- VALUES ($course_id,
- '".Database::escape_string($this->id)."'
- , '".Database::escape_string($this->uploader_id)."'
- )";
- Database::query($sql);
- }
- }
- /**
- * private function creating existing object by retreiving info from db
- *
- * @param int $id
- */
- public function _createExistingWork($id)
- {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
- $action = isset($_GET['action']) ? $_GET['action'] : null;
- // Do some sanity checks
- $id = intval($id);
- // Get the data from DB
- $sql = "SELECT uploader_id, filename, filesize, title, description, author, upload_date, last_upload_date, cat_id
- FROM ".$dropbox_cnf['tbl_file']."
- WHERE c_id = $course_id AND id = '".Database::escape_string($id)."'";
- $result = Database::query($sql);
- $res = Database::fetch_array($result, 'ASSOC');
- // Check if uploader is still in Chamilo system
- $uploader_id = stripslashes($res['uploader_id']);
- $uploaderName = getUserNameFromId($uploader_id);
- if (!$uploaderName) {
- //deleted user
- $this->uploader_id = -1;
- $this->uploaderName = get_lang('Unknown', '');
- } else {
- $this->uploader_id = $uploader_id;
- $this->uploaderName = $uploaderName;
- }
- // Fill in properties
- $this->id = $id;
- $this->filename = stripslashes($res['filename']);
- $this->filesize = stripslashes($res['filesize']);
- $this->title = stripslashes($res['title']);
- $this->description = stripslashes($res['description']);
- $this->author = stripslashes($res['author']);
- $this->upload_date = stripslashes($res['upload_date']);
- $this->last_upload_date = stripslashes($res['last_upload_date']);
- $this->category = $res['cat_id'];
- // Getting the feedback on the work.
- if ($action == 'viewfeedback' AND $this->id == $_GET['id']) {
- $feedback2 = array();
- $sql_feedback = "SELECT * FROM ".$dropbox_cnf['tbl_feedback']." WHERE c_id = $course_id AND file_id='".$id."' ORDER BY feedback_id ASC";
- $result = Database::query($sql_feedback);
- while ($row_feedback = Database::fetch_array($result)) {
- $row_feedback['feedback'] = Security::remove_XSS($row_feedback['feedback']);
- $feedback2[] = $row_feedback;
- }
- $this->feedback2= $feedback2;
- }
- }
- }
- class Dropbox_SentWork extends Dropbox_Work
- {
- public $recipients; //array of ['id']['name'] arrays
- /**
- * Constructor calls private functions to create a new work or retreive an existing work from DB
- * depending on the number of parameters
- *
- * @param unknown_type $arg1
- * @param unknown_type $arg2
- * @param unknown_type $arg3
- * @param unknown_type $arg4
- * @param unknown_type $arg5
- * @param unknown_type $arg6
- * @param unknown_type $arg7
- * @return Dropbox_SentWork
- */
- function Dropbox_SentWork($arg1, $arg2 = null, $arg3 = null, $arg4 = null, $arg5 = null, $arg6 = null, $arg7 = null)
- {
- if (func_num_args() > 1) {
- $this->_createNewSentWork($arg1, $arg2, $arg3, $arg4, $arg5, $arg6, $arg7);
- } else {
- $this->_createExistingSentWork($arg1);
- }
- }
- /**
- * private function creating a new SentWork object
- *
- * @param int $uploader_id
- * @param string $title
- * @param string $description
- * @param string $author
- * @param string $filename
- * @param int $filesize
- * @param array $recipient_ids
- */
- public function _createNewSentWork($uploader_id, $title, $description, $author, $filename, $filesize, $recipient_ids)
- {
- $dropbox_cnf = getDropboxConf();
- $_course = api_get_course_info();
- // Call constructor of Dropbox_Work object
- $this->Dropbox_Work($uploader_id, $title, $description, $author, $filename, $filesize);
- $course_id = api_get_course_int_id();
- // Do sanity checks on recipient_ids array & property fillin
- // The sanity check for ex-coursemembers is already done in base constructor
- settype($uploader_id, 'integer') or die(get_lang('GeneralError').' (code 208)'); // Set $uploader_id to correct type
- $justSubmit = false;
- if ( is_int($recipient_ids)) {
- $justSubmit = true;
- $recipient_ids = array($recipient_ids + $this->id);
- } elseif ( count($recipient_ids) == 0) {
- $justSubmit = true;
- $recipient_ids = array($uploader_id);
- }
- if (! is_array($recipient_ids) || count($recipient_ids) == 0) {
- die(get_lang('GeneralError').' (code 209)');
- }
- foreach ($recipient_ids as $rec) {
- if (empty($rec)) die(get_lang('GeneralError').' (code 210)');
- //if (!isCourseMember($rec)) die(); //cannot sent document to someone outside of course
- //this check is done when validating submitted data
- $this->recipients[] = array('id' => $rec, 'name' => getUserNameFromId($rec));
- }
- $table_post = $dropbox_cnf['tbl_post'];
- $table_person = $dropbox_cnf['tbl_person'];
- $session_id = api_get_session_id();
- $uploader_id = $this->uploader_id;
- $user = api_get_user_id();
- // Insert data in dropbox_post and dropbox_person table for each recipient
- foreach ($this->recipients as $rec) {
- $file_id = (int)$this->id;
- $user_id = (int)$rec['id'];
- $sql = "INSERT INTO $table_post (c_id, file_id, dest_user_id, session_id)
- VALUES ($course_id, $file_id, $user_id, $session_id)";
- $result = Database::query($sql);
- // If work already exists no error is generated
- /**
- * Poster is already added when work is created - not so good to split logic
- */
- if ($user_id != $user) {
- // Insert entries into person table
- $sql = "INSERT INTO $table_person (c_id, file_id, user_id)
- VALUES ($course_id, $file_id, $user_id)";
- // Do not add recipient in person table if mailing zip or just upload.
- if (!$justSubmit) {
- $result = Database::query($sql); // If work already exists no error is generated
- }
- }
- // Update item_property table for each recipient
- if (($ownerid = $this->uploader_id) > $dropbox_cnf['mailingIdBase']) {
- $ownerid = getUserOwningThisMailing($ownerid);
- }
- if (($recipid = $rec["id"]) > $dropbox_cnf['mailingIdBase']) {
- $recipid = $ownerid; // mailing file recipient = mailing id, not a person
- }
- api_item_property_update($_course, TOOL_DROPBOX, $this->id, 'DropboxFileAdded', $ownerid, null, $recipid) ;
- }
- }
- /**
- * private function creating existing object by retreiving info from db
- *
- * @param unknown_type $id
- */
- function _createExistingSentWork ($id)
- {
- $dropbox_cnf = getDropboxConf();
- $id = intval($id);
- $course_id = api_get_course_int_id();
- // Call constructor of Dropbox_Work object
- $this->Dropbox_Work($id);
- // Fill in recipients array
- $this->recipients = array();
- $sql = "SELECT dest_user_id, feedback_date, feedback
- FROM ".$dropbox_cnf['tbl_post']."
- WHERE c_id = $course_id AND file_id='".Database::escape_string($id)."'";
- $result = Database::query($sql);
- while ($res = Database::fetch_array($result, 'ASSOC')) {
- // Check for deleted users
- $dest_user_id = $res['dest_user_id'];
- $user_info = api_get_user_info($dest_user_id);
- //$this->category = $res['cat_id'];
- if (!$user_info) {
- $this->recipients[] = array('id' => -1, 'name' => get_lang('Unknown', ''));
- } else {
- $this->recipients[] = array(
- 'id' => $dest_user_id,
- 'name' => $user_info['complete_name'],
- 'user_id' => $dest_user_id,
- 'feedback_date' => $res['feedback_date'],
- 'feedback' => $res['feedback']);
- }
- }
- }
- }
- class Dropbox_Person
- {
- // The receivedWork and the sentWork arrays are sorted.
- public $receivedWork; // an array of Dropbox_Work objects
- public $sentWork; // an array of Dropbox_SentWork objects
- public $userId = 0;
- public $isCourseAdmin = false;
- public $isCourseTutor = false;
- public $_orderBy = ''; // private property that determines by which field
- /**
- * Constructor for recreating the Dropbox_Person object
- *
- * @param int $userId
- * @param bool $isCourseAdmin
- * @param bool $isCourseTutor
- * @return Dropbox_Person
- */
- function Dropbox_Person($userId, $isCourseAdmin, $isCourseTutor) {
- $course_id = api_get_course_int_id();
- // Fill in properties
- $this->userId = $userId;
- $this->isCourseAdmin = $isCourseAdmin;
- $this->isCourseTutor = $isCourseTutor;
- $this->receivedWork = array();
- $this->sentWork = array();
- // Note: perhaps include an ex coursemember check to delete old files
- $session_id = api_get_session_id();
- $condition_session = api_get_session_condition($session_id);
- $post_tbl = Database::get_course_table(TABLE_DROPBOX_POST);
- $person_tbl = Database::get_course_table(TABLE_DROPBOX_PERSON);
- $file_tbl = Database::get_course_table(TABLE_DROPBOX_FILE);
- // Find all entries where this person is the recipient
- $sql = "SELECT DISTINCT r.file_id, r.cat_id
- FROM $post_tbl r INNER JOIN $person_tbl p
- ON (r.file_id = p.file_id AND r.c_id = $course_id AND p.c_id = $course_id )
- WHERE
- p.user_id = ".intval($this->userId)." AND
- r.dest_user_id = ".intval($this->userId)." $condition_session ";
- $result = Database::query($sql);
- while ($res = Database::fetch_array($result)) {
- $temp = new Dropbox_Work($res['file_id']);
- $temp->category = $res['cat_id'];
- $this->receivedWork[] = $temp;
- }
- // Find all entries where this person is the sender/uploader
- $sql = "SELECT DISTINCT f.id
- FROM $file_tbl f INNER JOIN $person_tbl p
- ON (f.id = p.file_id AND f.c_id = $course_id AND p.c_id = $course_id)
- WHERE
- f.uploader_id = '".Database::escape_string($this->userId)."' AND
- p.user_id = '".Database::escape_string($this->userId)."'
- $condition_session
- ";
- $result = Database::query($sql);
- while ($res = Database::fetch_array($result)) {
- $this->sentWork[] = new Dropbox_SentWork($res['id']);
- }
- }
- /**
- * This private method is used by the usort function in the
- * orderSentWork and orderReceivedWork methods.
- * It compares 2 work-objects by 1 of the properties of that object, dictated by the
- * private property _orderBy
- *
- * @param unknown_type $a
- * @param unknown_type $b
- * @return -1, 0 or 1 dependent of the result of the comparison.
- */
- function _cmpWork($a, $b)
- {
- $sort = $this->_orderBy;
- $aval = $a->$sort;
- $bval = $b->$sort;
- if ($sort == 'recipients') { // The recipients property is an array so we do the comparison based on the first item of the recipients array
- $aval = $aval[0]['name'];
- $bval = $bval[0]['name'];
- }
- if ($sort == 'filesize') { // Filesize is not a string, so we use other comparison technique
- return $aval < $bval ? -1 : 1;
- } elseif ($sort == 'title') { // Natural order for sorting titles is more "human-friendly"
- return api_strnatcmp($aval, $bval);
- } else {
- return api_strcasecmp($aval, $bval);
- }
- }
- /**
- * A method that sorts the objects in the sentWork array, dependent on the $sort parameter.
- * $sort can be lastDate, firstDate, title, size, ...
- *
- * @param unknown_type $sort
- */
- function orderSentWork($sort)
- {
- switch($sort) {
- case 'lastDate':
- $this->_orderBy = 'last_upload_date';
- break;
- case 'firstDate':
- $this->_orderBy = 'upload_date';
- break;
- case 'title':
- $this->_orderBy = 'title';
- break;
- case 'size':
- $this->_orderBy = 'filesize';
- break;
- case 'author':
- $this->_orderBy = 'author';
- break;
- case 'recipient':
- $this->_orderBy = 'recipients';
- break;
- default:
- $this->_orderBy = 'last_upload_date';
- }
- usort($this->sentWork, array($this, '_cmpWork'));
- }
- /**
- * method that sorts the objects in the receivedWork array, dependent on the $sort parameter.
- * $sort can be lastDate, firstDate, title, size, ...
- * @param unknown_type $sort
- */
- function orderReceivedWork($sort) {
- switch($sort) {
- case 'lastDate':
- $this->_orderBy = 'last_upload_date';
- break;
- case 'firstDate':
- $this->_orderBy = 'upload_date';
- break;
- case 'title':
- $this->_orderBy = 'title';
- break;
- case 'size':
- $this->_orderBy = 'filesize';
- break;
- case 'author':
- $this->_orderBy = 'author';
- break;
- case 'sender':
- $this->_orderBy = 'uploaderName';
- break;
- default:
- $this->_orderBy = 'last_upload_date';
- }
- usort($this->receivedWork, array($this, '_cmpWork'));
- }
- /**
- * Deletes all the received work of this person
- */
- function deleteAllReceivedWork () {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
- // Delete entries in person table concerning received works
- foreach ($this->receivedWork as $w) {
- Database::query("DELETE FROM ".$dropbox_cnf['tbl_person']." WHERE c_id = $course_id AND user_id='".$this->userId."' AND file_id='".$w->id."'");
- }
- removeUnusedFiles(); // Check for unused files
- }
- /**
- * Deletes all the received categories and work of this person
- */
- function deleteReceivedWorkFolder($id)
- {
- $dropbox_cnf = getDropboxConf();
- $course_id = api_get_course_int_id();
- $id = intval($id);
- $sql = "DELETE FROM ".$dropbox_cnf['tbl_file']." WHERE c_id = $course_id AND cat_id = '".$id."' ";
- if (!Database::query($sql)) return false;
- $sql = "DELETE FROM ".$dropbox_cnf['tbl_category']." WHERE c_id = $course_id AND cat_id = '".$id."' ";
- if (!Database::query($sql)) return false;
- $sql = "DELETE FROM ".$dropbox_cnf['tbl_post']." WHERE c_id = $course_id AND cat_id = '".$id."' ";
- if (!Database::query($sql)) return false;
- return true;
- }
- /**
- * Deletes a received dropbox file of this person with id=$id
- *
- * @param integer $id
- */
- function deleteReceivedWork($id)
- {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
- $id = intval($id);
- // index check
- $found = false;
- foreach ($this->receivedWork as $w) {
- if ($w->id == $id) {
- $found = true;
- break;
- }
- }
- if (!$found) {
- if (!$this->deleteReceivedWorkFolder($id)) {
- die(get_lang('GeneralError').' (code 216)');
- }
- }
- // Delete entries in person table concerning received works
- $sql = "DELETE FROM ".$dropbox_cnf['tbl_person']." WHERE c_id = $course_id AND user_id = '".$this->userId."' AND file_id ='".$id."'";
- Database::query($sql);
- removeUnusedFiles(); // Check for unused files
- }
- /**
- * Deletes all the sent dropbox files of this person
- */
- function deleteAllSentWork()
- {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
- //delete entries in person table concerning sent works
- foreach ($this->sentWork as $w) {
- Database::query("DELETE FROM ".$dropbox_cnf['tbl_person']." WHERE c_id = $course_id AND user_id='".$this->userId."' AND file_id='".$w->id."'");
- removeMoreIfMailing($w->id);
- }
- removeUnusedFiles(); // Check for unused files
- }
- /**
- * Deletes a sent dropbox file of this person with id=$id
- *
- * @param unknown_type $id
- */
- function deleteSentWork($id)
- {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
- $id = intval($id);
- // index check
- $found = false;
- foreach ($this->sentWork as $w) {
- if ($w->id == $id) {
- $found = true;
- break;
- }
- }
- if (!$found) {
- if (!$this->deleteReceivedWorkFolder($id)) {
- die(get_lang('GeneralError').' (code 219)');
- }
- }
- //$file_id = $this->sentWork[$index]->id;
- // Delete entries in person table concerning sent works
- Database::query("DELETE FROM ".$dropbox_cnf['tbl_person']." WHERE c_id = $course_id AND user_id='".$this->userId."' AND file_id='".$id."'");
- removeMoreIfMailing($id);
- removeUnusedFiles(); // Check for unused files
- }
- /**
- * Updates feedback for received work of this person with id=$id
- *
- * @param unknown_type $id
- * @param unknown_type $text
- */
- function updateFeedback($id, $text)
- {
- $course_id = api_get_course_int_id();
- $_course = api_get_course_info();
- $dropbox_cnf = getDropboxConf();
- $id = intval($id);
- // index check
- $found = false;
- $wi = -1;
- foreach ($this->receivedWork as $w) {
- $wi++;
- if ($w->id == $id){
- $found = true;
- break;
- } // foreach (... as $wi -> $w) gives error 221! (no idea why...)
- }
- if (!$found) {
- die(get_lang('GeneralError').' (code 221)');
- }
- $feedback_date = date('Y-m-d H:i:s', time());
- $this->receivedWork[$wi]->feedback_date = $feedback_date;
- $this->receivedWork[$wi]->feedback = $text;
- Database::query("UPDATE ".$dropbox_cnf['tbl_post']." SET feedback_date='".
- Database::escape_string($feedback_date)."', feedback='".Database::escape_string($text).
- "' WHERE c_id = $course_id AND dest_user_id='".$this->userId."' AND file_id='".$id."'");
- // Update item_property table
- if (($ownerid = $this->receivedWork[$wi]->uploader_id) > $dropbox_cnf['mailingIdBase']) {
- $ownerid = getUserOwningThisMailing($ownerid);
- }
- api_item_property_update($_course, TOOL_DROPBOX, $this->receivedWork[$wi]->id, 'DropboxFileUpdated', $this->userId, null, $ownerid) ;
- }
- /**
- * Filter the received work
- * @param string $type
- * @param string $value
- */
- function filter_received_work($type, $value)
- {
- $dropbox_cnf = getDropboxConf();
- $new_received_work = array();
- foreach ($this->receivedWork as $work) {
- switch ($type) {
- case 'uploader_id':
- if ($work->uploader_id == $value ||
- ($work->uploader_id > $dropbox_cnf['mailingIdBase'] && getUserOwningThisMailing($work->uploader_id) == $value)) {
- $new_received_work[] = $work;
- }
- break;
- default:
- $new_received_work[] = $work;
- }
- }
- $this->receivedWork = $new_received_work;
- }
- }
|