123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714 |
- <?php
- 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;
-
- 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);
- }
- }
-
- public function _createNewWork($uploader_id, $title, $description, $author, $filename, $filesize)
- {
- $_user = api_get_user_info();
- $dropbox_cnf = getDropboxConf();
-
- $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();
-
-
- $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;
- }
-
- 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();
- }
- $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) {
-
- $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);
- }
- }
-
- public function _createExistingWork($id)
- {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
- $action = isset($_GET['action']) ? $_GET['action'] : null;
-
- $id = intval($id);
-
- $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');
-
- $uploader_id = stripslashes($res['uploader_id']);
- $uploaderName = getUserNameFromId($uploader_id);
- if (!$uploaderName) {
-
- $this->uploader_id = -1;
- $this->uploaderName = get_lang('Unknown', '');
- } else {
- $this->uploader_id = $uploader_id;
- $this->uploaderName = $uploaderName;
- }
-
- $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'];
-
- 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;
-
- 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);
- }
- }
-
- public function _createNewSentWork($uploader_id, $title, $description, $author, $filename, $filesize, $recipient_ids)
- {
- $dropbox_cnf = getDropboxConf();
- $_course = api_get_course_info();
-
- $this->Dropbox_Work($uploader_id, $title, $description, $author, $filename, $filesize);
- $course_id = api_get_course_int_id();
-
-
- settype($uploader_id, 'integer') or die(get_lang('GeneralError').' (code 208)');
- $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)');
-
-
- $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();
-
- 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 ($user_id != $user) {
-
- $sql = "INSERT INTO $table_person (c_id, file_id, user_id)
- VALUES ($course_id, $file_id, $user_id)";
-
- if (!$justSubmit) {
- $result = Database::query($sql);
- }
- }
-
- if (($ownerid = $this->uploader_id) > $dropbox_cnf['mailingIdBase']) {
- $ownerid = getUserOwningThisMailing($ownerid);
- }
- if (($recipid = $rec["id"]) > $dropbox_cnf['mailingIdBase']) {
- $recipid = $ownerid;
- }
- api_item_property_update($_course, TOOL_DROPBOX, $this->id, 'DropboxFileAdded', $ownerid, null, $recipid) ;
- }
- }
-
- function _createExistingSentWork ($id)
- {
- $dropbox_cnf = getDropboxConf();
- $id = intval($id);
- $course_id = api_get_course_int_id();
-
- $this->Dropbox_Work($id);
-
- $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')) {
-
- $dest_user_id = $res['dest_user_id'];
- $user_info = api_get_user_info($dest_user_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
- {
-
- public $receivedWork;
- public $sentWork;
- public $userId = 0;
- public $isCourseAdmin = false;
- public $isCourseTutor = false;
- public $_orderBy = '';
-
- function Dropbox_Person($userId, $isCourseAdmin, $isCourseTutor) {
- $course_id = api_get_course_int_id();
-
- $this->userId = $userId;
- $this->isCourseAdmin = $isCourseAdmin;
- $this->isCourseTutor = $isCourseTutor;
- $this->receivedWork = array();
- $this->sentWork = array();
-
- $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);
-
- $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;
- }
-
- $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']);
- }
- }
-
- function _cmpWork($a, $b)
- {
- $sort = $this->_orderBy;
- $aval = $a->$sort;
- $bval = $b->$sort;
- if ($sort == 'recipients') {
- $aval = $aval[0]['name'];
- $bval = $bval[0]['name'];
- }
- if ($sort == 'filesize') {
- return $aval < $bval ? -1 : 1;
- } elseif ($sort == 'title') {
- return api_strnatcmp($aval, $bval);
- } else {
- return api_strcasecmp($aval, $bval);
- }
- }
-
- 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'));
- }
-
- 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'));
- }
-
- function deleteAllReceivedWork () {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
-
- 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();
- }
-
- 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;
- }
-
- function deleteReceivedWork($id)
- {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
- $id = intval($id);
-
- $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)');
- }
- }
-
- $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();
- }
-
- function deleteAllSentWork()
- {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
-
- 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();
- }
-
- function deleteSentWork($id)
- {
- $course_id = api_get_course_int_id();
- $dropbox_cnf = getDropboxConf();
- $id = intval($id);
-
- $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)');
- }
- }
-
-
- 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();
- }
-
- function updateFeedback($id, $text)
- {
- $course_id = api_get_course_int_id();
- $_course = api_get_course_info();
- $dropbox_cnf = getDropboxConf();
- $id = intval($id);
-
- $found = false;
- $wi = -1;
- foreach ($this->receivedWork as $w) {
- $wi++;
- if ($w->id == $id){
- $found = true;
- break;
- }
- }
- 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."'");
-
- 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) ;
- }
-
- 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;
- }
- }
|