123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715 |
- <?php
- class Dropbox_Work
- {
- public $id;
- public $uploader_id;
- public $filename;
- public $filesize;
- public $title;
- public $description;
- public $author;
- public $upload_date;
- public $last_upload_date;
- public $isOldWork;
- public $feedback_date;
- public $feedback;
-
- public function __construct($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)
- {
-
- $this->uploader_id = intval($uploader_id);
- $this->filename = $filename;
- $this->filesize = $filesize;
- $this->title = $title;
- $this->description = $description;
- $this->author = $author;
- $this->last_upload_date = api_get_utc_datetime();
- $course_id = api_get_course_int_id();
-
-
- $this->isOldWork = false;
- $sql = "SELECT id, upload_date
- FROM ".Database::get_course_table(TABLE_DROPBOX_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'];
- $params = [
- 'filesize' => $this->filesize,
- 'title' => $this->title,
- 'description' => $this->description,
- 'author' => $this->author,
- 'last_upload_date' => $this->last_upload_date,
- 'session_id' => api_get_session_id(),
- ];
- Database::update(
- Database::get_course_table(TABLE_DROPBOX_FILE),
- $params,
- ['c_id = ? AND id = ?' => [$course_id, $this->id]]
- );
- } else {
- $this->upload_date = $this->last_upload_date;
- $params = [
- 'c_id' => $course_id,
- 'uploader_id' => $this->uploader_id,
- 'filename' => $this->filename,
- 'filesize' => $this->filesize,
- 'title' => $this->title,
- 'description' => $this->description,
- 'author' => $this->author,
- 'upload_date' => $this->upload_date,
- 'last_upload_date' => $this->last_upload_date,
- 'session_id' => api_get_session_id(),
- 'cat_id' => 0,
- ];
- $this->id = Database::insert(Database::get_course_table(TABLE_DROPBOX_FILE), $params);
- if ($this->id) {
- $sql = "UPDATE ".Database::get_course_table(TABLE_DROPBOX_FILE)." SET id = iid
- WHERE iid = {$this->id}";
- Database::query($sql);
- }
- }
- $sql = "SELECT count(file_id) as count
- FROM ".Database::get_course_table(TABLE_DROPBOX_PERSON)."
- WHERE c_id = $course_id AND file_id = ".intval($this->id)." AND user_id = ".$this->uploader_id;
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- if ($row['count'] == 0) {
-
- $sql = "INSERT INTO ".Database::get_course_table(TABLE_DROPBOX_PERSON)." (c_id, file_id, user_id)
- VALUES ($course_id, ".intval($this->id)." , ".intval($this->uploader_id).")";
- Database::query($sql);
- }
- }
-
- public function createExistingWork($id)
- {
- $course_id = api_get_course_int_id();
- $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 ".Database::get_course_table(TABLE_DROPBOX_FILE)."
- WHERE c_id = $course_id AND id = ".$id."";
- $result = Database::query($sql);
- $res = Database::fetch_array($result, 'ASSOC');
-
- $uploader_id = stripslashes($res['uploader_id']);
- $userInfo = api_get_user_info($uploader_id);
- if (!$userInfo) {
-
- $this->uploader_id = -1;
- } else {
- $this->uploader_id = $uploader_id;
- }
-
- $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' && $this->id == $_GET['id']) {
- $feedback2 = [];
- $sql = "SELECT * FROM ".Database::get_course_table(TABLE_DROPBOX_FEEDBACK)."
- WHERE c_id = $course_id AND file_id='".$id."'
- ORDER BY feedback_id ASC";
- $result = Database::query($sql);
- while ($row_feedback = Database::fetch_array($result)) {
- $row_feedback['feedback'] = Security::remove_XSS($row_feedback['feedback']);
- $feedback2[] = $row_feedback;
- }
- $this->feedback2 = $feedback2;
- }
- }
-
- public function updateFile()
- {
- $course_id = api_get_course_int_id();
- if (empty($this->id) || empty($course_id)) {
- return false;
- }
- $params = [
- 'uploader_id' => $this->uploader_id,
- 'filename' => $this->filename,
- 'filesize' => $this->filesize,
- 'title' => $this->title,
- 'description' => $this->description,
- 'author' => $this->author,
- 'upload_date' => $this->upload_date,
- 'last_upload_date' => $this->last_upload_date,
- 'session_id' => api_get_session_id(),
- ];
- Database::update(
- Database::get_course_table(TABLE_DROPBOX_FILE),
- $params,
- ['c_id = ? AND id = ?' => [$course_id, $this->id]]
- );
- return true;
- }
- }
- class Dropbox_SentWork extends Dropbox_Work
- {
- public $recipients;
-
- public function __construct($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)
- {
- $_course = api_get_course_info();
-
- parent::__construct(
- $uploader_id,
- $title,
- $description,
- $author,
- $filename,
- $filesize
- );
- $course_id = api_get_course_int_id();
-
-
- $uploader_id = (int) $uploader_id;
- $justSubmit = false;
- if (is_int($recipient_ids)) {
- $justSubmit = true;
- $recipient_ids = [$recipient_ids + $this->id];
- } elseif (count($recipient_ids) == 0) {
- $justSubmit = true;
- $recipient_ids = [$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)) {
- continue;
- }
-
- $this->recipients[] = ['id' => $rec];
- }
- $table_post = Database::get_course_table(TABLE_DROPBOX_POST);
- $table_person = Database::get_course_table(TABLE_DROPBOX_PERSON);
- $session_id = api_get_session_id();
- $user = api_get_user_id();
- $now = api_get_utc_datetime();
- $mailId = get_mail_id_base();
-
- 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, feedback_date, cat_id)
- VALUES ($course_id, $file_id, $user_id, $session_id, '$now', 0)";
- 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) {
- Database::query($sql);
- }
- }
-
- if (($ownerid = $this->uploader_id) > $mailId) {
- $ownerid = getUserOwningThisMailing($ownerid);
- }
- if (($recipid = $rec["id"]) > $mailId) {
- $recipid = $ownerid;
- }
- api_item_property_update(
- $_course,
- TOOL_DROPBOX,
- $this->id,
- 'DropboxFileAdded',
- $ownerid,
- null,
- $recipid
- );
- }
- }
-
- public function createExistingSentWork($id)
- {
- $id = intval($id);
- $course_id = api_get_course_int_id();
-
- parent::__construct($id);
-
- $this->recipients = [];
- $sql = "SELECT dest_user_id, feedback_date, feedback
- FROM ".Database::get_course_table(TABLE_DROPBOX_POST)."
- WHERE c_id = $course_id AND file_id = ".intval($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[] = ['id' => -1, 'name' => get_lang('Unknown', '')];
- } else {
- $this->recipients[] = [
- '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 = '';
-
- public function __construct($userId, $isCourseAdmin, $isCourseTutor)
- {
- $course_id = api_get_course_int_id();
-
- $this->userId = $userId;
- $this->isCourseAdmin = $isCourseAdmin;
- $this->isCourseTutor = $isCourseTutor;
- $this->receivedWork = [];
- $this->sentWork = [];
-
- $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 = ".intval($this->userId)." AND
- p.user_id = ".intval($this->userId)."
- $condition_session
- ";
- $result = Database::query($sql);
- while ($res = Database::fetch_array($result)) {
- $this->sentWork[] = new Dropbox_SentWork($res['id']);
- }
- }
-
- public function deleteAllReceivedWork()
- {
- $course_id = api_get_course_int_id();
-
- foreach ($this->receivedWork as $w) {
- $sql = "DELETE FROM ".Database::get_course_table(TABLE_DROPBOX_PERSON)."
- WHERE c_id = $course_id AND user_id='".$this->userId."' AND file_id='".$w->id."'";
- Database::query($sql);
- }
-
- removeUnusedFiles();
- }
-
- public function deleteReceivedWorkFolder($id)
- {
- $course_id = api_get_course_int_id();
- $id = intval($id);
- $sql = "DELETE FROM ".Database::get_course_table(TABLE_DROPBOX_FILE)."
- WHERE c_id = $course_id AND cat_id = '".$id."' ";
- Database::query($sql);
- $sql = "DELETE FROM ".Database::get_course_table(TABLE_DROPBOX_CATEGORY)."
- WHERE c_id = $course_id AND cat_id = '".$id."' ";
- Database::query($sql);
- $sql = "DELETE FROM ".Database::get_course_table(TABLE_DROPBOX_POST)."
- WHERE c_id = $course_id AND cat_id = '".$id."' ";
- Database::query($sql);
- return true;
- }
-
- public function deleteReceivedWork($id)
- {
- $course_id = api_get_course_int_id();
- $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 ".Database::get_course_table(TABLE_DROPBOX_PERSON)."
- WHERE c_id = $course_id AND user_id = '".$this->userId."' AND file_id ='".$id."'";
- Database::query($sql);
- removeUnusedFiles();
- }
-
- public function deleteAllSentWork()
- {
- $course_id = api_get_course_int_id();
-
- foreach ($this->sentWork as $w) {
- $sql = "DELETE FROM ".Database::get_course_table(TABLE_DROPBOX_PERSON)."
- WHERE
- c_id = $course_id AND
- user_id='".$this->userId."' AND
- file_id='".$w->id."'";
- Database::query($sql);
- removeMoreIfMailing($w->id);
- }
- removeUnusedFiles();
- }
-
- public function deleteSentWork($id)
- {
- $course_id = api_get_course_int_id();
- $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)');
- }
- }
-
-
- $sql = "DELETE FROM ".Database::get_course_table(TABLE_DROPBOX_PERSON)."
- WHERE c_id = $course_id AND user_id='".$this->userId."' AND file_id='".$id."'";
- Database::query($sql);
- removeMoreIfMailing($id);
- removeUnusedFiles();
- }
-
- public function updateFeedback($id, $text)
- {
- $course_id = api_get_course_int_id();
- $_course = api_get_course_info();
- $id = intval($id);
-
- $found = false;
- $wi = -1;
- foreach ($this->receivedWork as $w) {
- $wi++;
- if ($w->id == $id) {
- $found = true;
- break;
- }
- }
- if (!$found) {
- return false;
- }
- $feedback_date = api_get_utc_datetime();
- $this->receivedWork[$wi]->feedback_date = $feedback_date;
- $this->receivedWork[$wi]->feedback = $text;
- $params = [
- 'feedback_date' => $feedback_date,
- 'feedback' => $text,
- ];
- Database::update(
- Database::get_course_table(TABLE_DROPBOX_POST),
- $params,
- [
- 'c_id = ? AND dest_user_id = ? AND file_id = ?' => [
- $course_id,
- $this->userId,
- $id,
- ],
- ]
- );
-
- $mailId = get_mail_id_base();
- if (($ownerid = $this->receivedWork[$wi]->uploader_id) > $mailId) {
- $ownerid = getUserOwningThisMailing($ownerid);
- }
- api_item_property_update(
- $_course,
- TOOL_DROPBOX,
- $this->receivedWork[$wi]->id,
- 'DropboxFileUpdated',
- $this->userId,
- null,
- $ownerid
- );
- }
-
- public function filter_received_work($type, $value)
- {
- $new_received_work = [];
- $mailId = get_mail_id_base();
- foreach ($this->receivedWork as $work) {
- switch ($type) {
- case 'uploader_id':
- if ($work->uploader_id == $value ||
- ($work->uploader_id > $mailId &&
- getUserOwningThisMailing($work->uploader_id) == $value)
- ) {
- $new_received_work[] = $work;
- }
- break;
- default:
- $new_received_work[] = $work;
- break;
- }
- }
- $this->receivedWork = $new_received_work;
- }
- }
|