, Ghent University.
*
* @author Julio Montoya adding c_id support
*/
$this_section = SECTION_COURSES;
$htmlHeadXtra[] = '';
/**
* This function is a wrapper function for the multiple actions feature.
*
* @return string|null If there is a problem, return a string message, otherwise nothing
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function handle_multiple_actions()
{
$_user = api_get_user_info();
$is_courseAdmin = api_is_course_admin();
$is_courseTutor = api_is_course_tutor();
// STEP 1: are we performing the actions on the received or on the sent files?
if ($_POST['action'] == 'delete_received' || $_POST['action'] == 'download_received') {
$part = 'received';
} elseif ($_POST['action'] == 'delete_sent' || $_POST['action'] == 'download_sent') {
$part = 'sent';
}
// STEP 2: at least one file has to be selected. If not we return an error message
$ids = isset($_GET['id']) ? $_GET['id'] : [];
if (count($ids) > 0) {
$checked_file_ids = $_POST['id'];
} else {
foreach ($_POST as $key => $value) {
if (strstr($value, $part.'_') && $key != 'view_received_category' && $key != 'view_sent_category') {
$checked_files = true;
$checked_file_ids[] = intval(substr($value, strrpos($value, '_')));
}
}
}
$checked_file_ids = $_POST['id'];
if (!is_array($checked_file_ids) || count($checked_file_ids) == 0) {
return get_lang('Check at least one file.');
}
// Deleting
if ($_POST['action'] == 'delete_received' || $_POST['action'] == 'delete_sent') {
$dropboxfile = new Dropbox_Person($_user['user_id'], $is_courseAdmin, $is_courseTutor);
foreach ($checked_file_ids as $key => $value) {
if ($_GET['view'] == 'received') {
$dropboxfile->deleteReceivedWork($value);
$message = get_lang('The received file has been deleted.');
}
if ($_GET['view'] == 'sent' || empty($_GET['view'])) {
$dropboxfile->deleteSentWork($value);
$message = get_lang('The sent file has been deleted.');
}
}
return $message;
}
// moving
if (strstr($_POST['action'], 'move_')) {
// check move_received_n or move_sent_n command
if (strstr($_POST['action'], 'received')) {
$part = 'received';
$to_cat_id = str_replace('move_received_', '', $_POST['action']);
} else {
$part = 'sent';
$to_cat_id = str_replace('move_sent_', '', $_POST['action']);
}
foreach ($checked_file_ids as $value) {
store_move($value, $to_cat_id, $part);
}
return get_lang('The selected files have been moved.');
}
// STEP 3D: downloading
if ($_POST['action'] == 'download_sent' || $_POST['action'] == 'download_received') {
zip_download($checked_file_ids);
}
}
/**
* Get conf settings.
*
* @return array
*/
function getDropboxConf()
{
return Session::read('dropbox_conf');
}
/**
* This function deletes a dropbox category.
*
* @todo give the user the possibility what needs to be done with the files
* in this category: move them to the root, download them as a zip, delete them
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function delete_category($action, $id, $user_id = null)
{
$course_id = api_get_course_int_id();
$is_courseAdmin = api_is_course_admin();
$is_courseTutor = api_is_course_tutor();
if (empty($user_id)) {
$user_id = api_get_user_id();
}
$cat = get_dropbox_category($id);
if (count($cat) == 0) {
return false;
}
if ($cat['user_id'] != $user_id && !api_is_platform_admin($user_id)) {
return false;
}
// an additional check that might not be necessary
if ($action == 'deletereceivedcategory') {
$sentreceived = 'received';
$entries_table = Database::get_course_table(TABLE_DROPBOX_POST);
$id_field = 'file_id';
$return_message = get_lang('The folder has been deleted');
} elseif ($action == 'deletesentcategory') {
$sentreceived = 'sent';
$entries_table = Database::get_course_table(TABLE_DROPBOX_FILE);
$id_field = 'id';
$return_message = get_lang('The folder has been deleted');
} else {
return get_lang('Error');
}
// step 1: delete the category
$sql = "DELETE FROM ".Database::get_course_table(TABLE_DROPBOX_CATEGORY)."
WHERE c_id = $course_id AND cat_id='".intval($id)."' AND $sentreceived='1'";
Database::query($sql);
// step 2: delete all the documents in this category
$sql = "SELECT * FROM ".$entries_table."
WHERE c_id = $course_id AND cat_id='".intval($id)."'";
$result = Database::query($sql);
while ($row = Database::fetch_array($result)) {
$dropboxfile = new Dropbox_Person($user_id, $is_courseAdmin, $is_courseTutor);
if ($action == 'deletereceivedcategory') {
$dropboxfile->deleteReceivedWork($row[$id_field]);
}
if ($action == 'deletesentcategory') {
$dropboxfile->deleteSentWork($row[$id_field]);
}
}
return $return_message;
}
/**
* Displays the form to move one individual file to a category.
*
*@ return html code of the form that appears in a message box.
*
* @author Julio Montoya - function rewritten
*/
function display_move_form(
$part,
$id,
$target = [],
$extra_params = [],
$viewReceivedCategory,
$viewSentCategory,
$view
) {
$form = new FormValidator(
'form1',
'post',
api_get_self().'?view_received_category='.$viewReceivedCategory.'&view_sent_category='.$viewSentCategory.'&view='.$view.'&'.$extra_params
);
$form->addElement('header', get_lang('Move file to'));
$form->addElement('hidden', 'id', intval($id));
$form->addElement('hidden', 'part', Security::remove_XSS($part));
$options = ['0' => get_lang('root')];
foreach ($target as $category) {
$options[$category['cat_id']] = $category['cat_name'];
}
$form->addElement('select', 'move_target', get_lang('Move file to'), $options);
$form->addButtonMove(get_lang('Move the file'), 'do_move');
$form->display();
}
/**
* This function moves a file to a different category.
*
* @param int $id the id of the file we are moving
* @param int $target the id of the folder we are moving to
* @param string $part are we moving a received file or a sent file?
*
* @return string string
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function store_move($id, $target, $part)
{
$_user = api_get_user_info();
$course_id = api_get_course_int_id();
if ((isset($id) && $id != '') &&
(isset($target) && $target != '') &&
(isset($part) && $part != '')
) {
if ($part == 'received') {
$sql = "UPDATE ".Database::get_course_table(TABLE_DROPBOX_POST)."
SET cat_id = ".intval($target)."
WHERE c_id = $course_id AND dest_user_id = ".intval($_user['user_id'])."
AND file_id = ".intval($id)."";
Database::query($sql);
$return_message = get_lang('The received file has been moved.');
}
if ($part == 'sent') {
$sql = "UPDATE ".Database::get_course_table(TABLE_DROPBOX_FILE)."
SET cat_id = ".intval($target)."
WHERE
c_id = $course_id AND
uploader_id = ".intval($_user['user_id'])." AND
id = ".intval($id);
Database::query($sql);
$return_message = get_lang('The sent file has been moved');
}
} else {
$return_message = get_lang('The file(s) can not be moved.');
}
return $return_message;
}
/**
* This function retrieves all dropbox categories and returns them as an array.
*
* @param $filter default '', when we need only the categories of the sent or the received part
*
* @return array
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function get_dropbox_categories($filter = '')
{
$course_id = api_get_course_int_id();
$_user = api_get_user_info();
$return_array = [];
$session_id = api_get_session_id();
$condition_session = api_get_session_condition($session_id);
$sql = "SELECT * FROM ".Database::get_course_table(TABLE_DROPBOX_CATEGORY)."
WHERE c_id = $course_id AND user_id='".$_user['user_id']."' $condition_session";
$result = Database::query($sql);
while ($row = Database::fetch_array($result)) {
if (($filter == 'sent' && $row['sent'] == 1) ||
($filter == 'received' && $row['received'] == 1) || $filter == ''
) {
$return_array[$row['cat_id']] = $row;
}
}
return $return_array;
}
/**
* Get a dropbox category details.
*
* @param int The category ID
*
* @return array The details of this category
*/
function get_dropbox_category($id)
{
$course_id = api_get_course_int_id();
$id = (int) $id;
if (empty($id)) {
return [];
}
$sql = "SELECT * FROM ".Database::get_course_table(TABLE_DROPBOX_CATEGORY)."
WHERE c_id = $course_id AND cat_id='".$id."'";
$res = Database::query($sql);
if ($res === false) {
return [];
}
$row = Database::fetch_assoc($res);
return $row;
}
/**
* This functions stores a new dropboxcategory.
*
* @var it might not seem very elegant if you create a category in sent
* and in received with the same name that you get two entries in the
* dropbox_category table but it is the easiest solution. You get
* cat_name | received | sent | user_id
* test | 1 | 0 | 237
* test | 0 | 1 | 237
* more elegant would be
* test | 1 | 1 | 237
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function store_addcategory()
{
$course_id = api_get_course_int_id();
$_user = api_get_user_info();
// check if the target is valid
if ($_POST['target'] == 'sent') {
$sent = 1;
$received = 0;
} elseif ($_POST['target'] == 'received') {
$sent = 0;
$received = 1;
} else {
return get_lang('Error');
}
// check if the category name is valid
if ($_POST['category_name'] == '') {
return ['type' => 'error', 'message' => get_lang('Please give a category name')];
}
if (!isset($_POST['edit_id'])) {
$session_id = api_get_session_id();
// step 3a, we check if the category doesn't already exist
$sql = "SELECT * FROM ".Database::get_course_table(TABLE_DROPBOX_CATEGORY)."
WHERE
c_id = $course_id AND
user_id='".$_user['user_id']."' AND
cat_name='".Database::escape_string($_POST['category_name'])."' AND
received='".$received."' AND
sent='$sent' AND
session_id='$session_id'";
$result = Database::query($sql);
// step 3b, we add the category if it does not exist yet.
if (Database::num_rows($result) == 0) {
$params = [
'cat_id' => 0,
'c_id' => $course_id,
'cat_name' => $_POST['category_name'],
'received' => $received,
'sent' => $sent,
'user_id' => $_user['user_id'],
'session_id' => $session_id,
];
$id = Database::insert(Database::get_course_table(TABLE_DROPBOX_CATEGORY), $params);
if ($id) {
$sql = "UPDATE ".Database::get_course_table(TABLE_DROPBOX_CATEGORY)." SET cat_id = iid
WHERE iid = $id";
Database::query($sql);
}
return ['type' => 'confirmation', 'message' => get_lang('The folder has been created')];
} else {
return ['type' => 'error', 'message' => get_lang('This category already exists, please use a different name')];
}
} else {
$params = [
'cat_name' => $_POST['category_name'],
'received' => $received,
'sent' => $sent,
];
Database::update(
Database::get_course_table(TABLE_DROPBOX_CATEGORY),
$params,
[
'c_id = ? AND user_id = ? AND cat_id = ?' => [
$course_id,
$_user['user_id'],
$_POST['edit_id'],
],
]
);
return ['type' => 'confirmation', 'message' => get_lang('The category has been modified.')];
}
}
/**
* This function displays the form to add a new category.
*
* @param string $category_name this parameter is the name of the category (used when no section is selected)
* @param int $id this is the id of the category we are editing
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function display_addcategory_form($category_name = '', $id = 0, $action = '')
{
$course_id = api_get_course_int_id();
$title = get_lang('Add a new folder');
$id = (int) $id;
if (!empty($id)) {
// retrieve the category we are editing
$sql = "SELECT * FROM ".Database::get_course_table(TABLE_DROPBOX_CATEGORY)."
WHERE c_id = $course_id AND cat_id = ".$id;
$result = Database::query($sql);
$row = Database::fetch_array($result);
if (empty($category_name)) {
// after an edit with an error we do not want to return to the
// original name but the name we already modified.
// (happens when createinrecievedfiles AND createinsentfiles are not checked)
$category_name = $row['cat_name'];
}
if ($row['received'] == '1') {
$target = 'received';
}
if ($row['sent'] == '1') {
$target = 'sent';
}
$title = get_lang('Edit this category');
}
if ($action == 'addreceivedcategory') {
$target = 'received';
}
if ($action == 'addsentcategory') {
$target = 'sent';
}
if ($action == 'editcategory') {
$text = get_lang('Edit category');
} elseif ($action == 'addreceivedcategory' || $action == 'addsentcategory') {
$text = get_lang('Create category');
}
$form = new FormValidator(
'add_new_category',
'post',
api_get_self().'?'.api_get_cidreq().'&view='.Security::remove_XSS($_GET['view'])
);
$form->addElement('header', $title);
if (!empty($id)) {
$form->addElement('hidden', 'edit_id', $id);
}
$form->addElement('hidden', 'action', Security::remove_XSS($action));
$form->addElement('hidden', 'target', Security::remove_XSS($target));
$form->addElement('text', 'category_name', get_lang('Category name'));
$form->addRule('category_name', get_lang('Required field'), 'required');
$form->addButtonSave($text, 'StoreCategory');
$defaults = [];
$defaults['category_name'] = Security::remove_XSS($category_name);
$form->setDefaults($defaults);
$form->display();
}
/**
* this function displays the form to upload a new item to the dropbox.
*
* @param $viewReceivedCategory
* @param $viewSentCategory
* @param $view
* @param int $id
*
* @author Patrick Cool , Ghent University
* @author Julio Montoya
*
* @version march 2006
*/
function display_add_form($viewReceivedCategory, $viewSentCategory, $view, $id = 0)
{
$course_info = api_get_course_info();
$_user = api_get_user_info();
$is_courseAdmin = api_is_course_admin();
$is_courseTutor = api_is_course_tutor();
$origin = api_get_origin();
$token = Security::get_token();
$dropbox_person = new Dropbox_Person(
api_get_user_id(),
$is_courseAdmin,
$is_courseTutor
);
$idCondition = !empty($id) ? '&id='.(int) $id : '';
$url = api_get_self().'?view_received_category='.$viewReceivedCategory.'&view_sent_category='.$viewSentCategory.'&view='.$view.'&'.api_get_cidreq().$idCondition;
$form = new FormValidator(
'sent_form',
'post',
$url,
null,
[
'enctype' => 'multipart/form-data',
'onsubmit' => 'javascript: return checkForm(this);',
]
);
$form->addElement('header', get_lang('Share a new file'));
$maxFileSize = api_get_setting('dropbox_max_filesize');
$form->addElement('hidden', 'MAX_FILE_SIZE', $maxFileSize);
$form->addElement('hidden', 'sec_token', $token);
$form->addElement('hidden', 'origin', $origin);
$form->addElement(
'file',
'file',
get_lang('File upload'),
['onChange' => 'javascript: checkfile(this.value);']
);
$allowOverwrite = api_get_setting('dropbox_allow_overwrite');
if ($allowOverwrite == 'true' && empty($idCondition)) {
$form->addElement(
'checkbox',
'cb_overwrite',
null,
get_lang('Overwrite previous versions of same document?'),
['id' => 'cb_overwrite']
);
}
// List of all users in this course and all virtual courses combined with it
if (api_get_session_id()) {
$complete_user_list_for_dropbox = [];
if (api_get_setting('dropbox_allow_student_to_student') == 'true' || $_user['status'] != STUDENT) {
$complete_user_list_for_dropbox = CourseManager:: get_user_list_from_course_code(
$course_info['code'],
api_get_session_id(),
null,
null,
0,
false,
false,
false,
[],
[],
[],
true
);
}
$complete_user_list2 = CourseManager::get_coach_list_from_course_code(
$course_info['code'],
api_get_session_id()
);
$generalCoachList = [];
$courseCoachList = [];
foreach ($complete_user_list2 as $coach) {
if ($coach['type'] == 'general_coach') {
$generalCoachList[] = $coach;
} else {
$courseCoachList[] = $coach;
}
}
$hideCourseCoach = api_get_setting('dropbox_hide_course_coach');
if ($hideCourseCoach == 'false') {
$complete_user_list_for_dropbox = array_merge(
$complete_user_list_for_dropbox,
$courseCoachList
);
}
$hideGeneralCoach = api_get_setting('dropbox_hide_general_coach');
if ($hideGeneralCoach == 'false') {
$complete_user_list_for_dropbox = array_merge(
$complete_user_list_for_dropbox,
$generalCoachList
);
}
} else {
if (api_get_setting('dropbox_allow_student_to_student') == 'true' || $_user['status'] != STUDENT) {
$complete_user_list_for_dropbox = CourseManager::get_user_list_from_course_code(
$course_info['code'],
api_get_session_id(),
null,
null,
null,
false,
false,
false,
[],
[],
[],
true
);
} else {
$complete_user_list_for_dropbox = CourseManager::get_teacher_list_from_course_code(
$course_info['code'],
false
);
}
}
if (!empty($complete_user_list_for_dropbox)) {
foreach ($complete_user_list_for_dropbox as $k => $e) {
$complete_user_list_for_dropbox[$k] = $e + [
'lastcommafirst' => api_get_person_name(
$e['firstname'],
$e['lastname']
),
];
}
$complete_user_list_for_dropbox = TableSort::sort_table($complete_user_list_for_dropbox, 'lastcommafirst');
}
/*
Create the options inside the select box:
List all selected users their user id as value and a name string as display
*/
$current_user_id = '';
$allowStudentToStudent = api_get_setting('dropbox_allow_student_to_student');
$options = [];
$userGroup = new UserGroup();
foreach ($complete_user_list_for_dropbox as $current_user) {
if ((
$dropbox_person->isCourseTutor
|| $dropbox_person->isCourseAdmin
|| $allowStudentToStudent == 'true'
|| $current_user['status'] != 5 // Always allow teachers.
|| $current_user['is_tutor'] == 1 // Always allow tutors.
) && $current_user['user_id'] != $_user['user_id']) { // Don't include yourself.
if ($current_user['user_id'] == $current_user_id) {
continue;
}
$userId = $current_user['user_id'];
$userInfo = api_get_user_info($userId);
if ($userInfo['status'] != INVITEE) {
$groupNameListToString = '';
if (!empty($groups)) {
$groupNameList = array_column($groups, 'name');
$groupNameListToString = ' - ['.implode(', ', $groupNameList).']';
}
$groups = $userGroup->getUserGroupListByUser($userId);
$full_name = $userInfo['complete_name'].$groupNameListToString;
$current_user_id = $current_user['user_id'];
$options['user_'.$current_user_id] = $full_name;
}
}
}
/*
* Show groups
*/
$allowGroups = api_get_setting('dropbox_allow_group');
if (($dropbox_person->isCourseTutor || $dropbox_person->isCourseAdmin)
&& $allowGroups == 'true' || $allowStudentToStudent == 'true'
) {
$complete_group_list_for_dropbox = GroupManager::get_group_list(null, $course_info);
if (count($complete_group_list_for_dropbox) > 0) {
foreach ($complete_group_list_for_dropbox as $current_group) {
if ($current_group['number_of_members'] > 0) {
$options['group_'.$current_group['id']] = 'G: '.$current_group['name'].' - '.$current_group['number_of_members'].' '.get_lang('Users');
}
}
}
}
$allowUpload = api_get_setting('dropbox_allow_just_upload');
if ($allowUpload == 'true') {
$options['user_'.$_user['user_id']] = get_lang('---Just upload---');
}
if (empty($idCondition)) {
$form->addSelect(
'recipients',
get_lang('Send to'),
$options,
[
'multiple' => 'multiple',
'size' => '10',
]
);
}
$form->addButtonUpload(get_lang('Upload'), 'submitWork');
$headers = [
get_lang('Upload'),
get_lang('Upload').' ('.get_lang('Simple').')',
];
$multipleForm = new FormValidator(
'sent_multiple',
'post',
'#',
null,
['enctype' => 'multipart/form-data', 'id' => 'fileupload']
);
if (empty($idCondition)) {
$multipleForm->addSelect(
'recipients',
get_lang('Send to'),
$options,
[
'multiple' => 'multiple',
'size' => '10',
'id' => 'recipient_form',
]
);
}
$url = api_get_path(WEB_AJAX_PATH).'dropbox.ajax.php?'.api_get_cidreq().'&a=upload_file&'.$idCondition;
if (empty($idCondition)) {
$multipleForm->addHtml('
');
}
$multipleForm->addMultipleUpload($url);
if (empty($idCondition)) {
$multipleForm->addHtml('
';
return $output;
}
/**
* this function returns the code for the form for adding a new feedback message to a dropbox file.
*
* @param $url url string
*
* @return string code
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function feedback_form($url)
{
$return = '
';
} else {
$return .= get_lang('All users have deleted the file so nobody will see the feedback you are adding.');
}
return $return;
}
function user_can_download_file($id, $user_id)
{
$course_id = api_get_course_int_id();
$id = (int) $id;
$user_id = (int) $user_id;
$sql = "SELECT file_id
FROM ".Database::get_course_table(TABLE_DROPBOX_PERSON)."
WHERE c_id = $course_id AND user_id = $user_id AND file_id = ".$id;
$result = Database::query($sql);
$number_users_who_see_file = Database::num_rows($result);
$sql = "SELECT file_id
FROM ".Database::get_course_table(TABLE_DROPBOX_POST)."
WHERE c_id = $course_id AND dest_user_id = $user_id AND file_id = ".$id;
$result = Database::query($sql);
$count = Database::num_rows($result);
return $number_users_who_see_file > 0 || $count > 0;
}
// we now check if the other users have not delete this document yet.
// If this is the case then it is useless to see the
// add feedback since the other users will never get to see the feedback.
function check_if_file_exist($id)
{
$id = (int) $id;
$course_id = api_get_course_int_id();
$sql = "SELECT file_id
FROM ".Database::get_course_table(TABLE_DROPBOX_PERSON)."
WHERE c_id = $course_id AND file_id = ".$id;
$result = Database::query($sql);
$number_users_who_see_file = Database::num_rows($result);
$sql = "SELECT file_id
FROM ".Database::get_course_table(TABLE_DROPBOX_POST)."
WHERE c_id = $course_id AND file_id = ".$id;
$result = Database::query($sql);
$count = Database::num_rows($result);
return $number_users_who_see_file > 0 || $count > 0;
}
/**
* @return string language string (depending on the success or failure
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function store_feedback()
{
if (!is_numeric($_GET['id'])) {
return get_lang('Feedback error');
}
$course_id = api_get_course_int_id();
if (empty($_POST['feedback'])) {
return get_lang('Please type some text.');
} else {
$table = Database::get_course_table(TABLE_DROPBOX_FEEDBACK);
$params = [
'c_id' => $course_id,
'file_id' => $_GET['id'],
'author_user_id' => api_get_user_id(),
'feedback' => $_POST['feedback'],
'feedback_date' => api_get_utc_datetime(),
'feedback_id' => 0,
];
$id = Database::insert($table, $params);
if ($id) {
$sql = "UPDATE $table SET feedback_id = iid WHERE iid = $id";
Database::query($sql);
}
return get_lang('The feedback message has been stored');
}
}
/**
* This function downloads all the files of the input array into one zip.
*
* @param array $fileList containing all the ids of the files that have to be downloaded
*
* @author Patrick Cool , Ghent University
*
* @todo consider removing the check if the user has received or sent this file (zip download of a folder already sufficiently checks for this).
* @todo integrate some cleanup function that removes zip files that are older than 2 days
*
* @author Patrick Cool , Ghent University
* @author Julio Montoya Addin c_id support
*
* @version march 2006
*/
function zip_download($fileList)
{
$_course = api_get_course_info();
$course_id = api_get_course_int_id();
$fileList = array_map('intval', $fileList);
// note: we also have to add the check if the user has received or sent this file.
$sql = "SELECT DISTINCT file.filename, file.title, file.author, file.description
FROM ".Database::get_course_table(TABLE_DROPBOX_FILE)." file
INNER JOIN ".Database::get_course_table(TABLE_DROPBOX_PERSON)." person
ON (person.file_id=file.id AND file.c_id = $course_id AND person.c_id = $course_id)
INNER JOIN ".Database::get_course_table(TABLE_DROPBOX_POST)." post
ON (post.file_id = file.id AND post.c_id = $course_id AND file.c_id = $course_id)
WHERE
file.id IN (".implode(', ', $fileList).") AND
file.id = person.file_id AND
(
person.user_id = '".api_get_user_id()."' OR
post.dest_user_id = '".api_get_user_id()."'
) ";
$result = Database::query($sql);
$files = [];
while ($row = Database::fetch_array($result)) {
$files[$row['filename']] = [
'filename' => $row['filename'],
'title' => $row['title'],
'author' => $row['author'],
'description' => $row['description'],
];
}
// Step 3: create the zip file and add all the files to it
$temp_zip_file = api_get_path(SYS_ARCHIVE_PATH).api_get_unique_id().".zip";
Session::write('dropbox_files_to_download', $files);
$zip = new PclZip($temp_zip_file);
foreach ($files as $value) {
$zip->add(
api_get_path(SYS_COURSE_PATH).$_course['path'].'/dropbox/'.$value['filename'],
PCLZIP_OPT_REMOVE_ALL_PATH,
PCLZIP_CB_PRE_ADD,
'my_pre_add_callback'
);
}
Session::erase('dropbox_files_to_download');
$name = 'dropbox-'.api_get_utc_datetime().'.zip';
$result = DocumentManager::file_send_for_download($temp_zip_file, true, $name);
if ($result === false) {
api_not_allowed(true);
}
@unlink($temp_zip_file);
exit;
}
/**
* This is a callback function to decrypt the files in the zip file
* to their normal filename (as stored in the database).
*
* @param array $p_event a variable of PCLZip
* @param array $p_header a variable of PCLZip
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function my_pre_add_callback($p_event, &$p_header)
{
$files = Session::read('dropbox_files_to_download');
$p_header['stored_filename'] = $files[$p_header['stored_filename']]['title'];
return 1;
}
/**
* @desc Generates the contents of a html file that gives an overview of all the files in the zip file.
* This is to know the information of the files that are inside the zip file (who send it, the comment, ...)
*
* @author Patrick Cool , Ghent University, March 2006
* @author Ivan Tcholakov, 2010, code for html metadata has been added.
*/
function generate_html_overview($files, $dont_show_columns = [], $make_link = [])
{
$return = ''."\n";
$return .= ''."\n";
$return .= "\n\t".get_lang('Overview of diles in this Zip')."\n";
$return .= "\t".''."\n";
$return .= "\n\n";
$return .= ''."\n\n";
$return .= "
\n";
$counter = 0;
foreach ($files as $value) {
// Adding the header.
if ($counter == 0) {
$columns_array = array_keys($value);
$return .= "\n
";
foreach ($columns_array as $columns_array_key => $columns_array_value) {
if (!in_array($columns_array_value, $dont_show_columns)) {
$return .= "\n\t
\n\n";
$return .= "\n";
return $return;
}
/**
* @desc This function retrieves the number of feedback messages on every
* document. This function might become obsolete when
* the feedback becomes user individual.
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function get_total_number_feedback()
{
$course_id = api_get_course_int_id();
$sql = "SELECT COUNT(feedback_id) AS total, file_id
FROM ".Database::get_course_table(TABLE_DROPBOX_FEEDBACK)."
WHERE c_id = $course_id
GROUP BY file_id";
$result = Database::query($sql);
$return = [];
while ($row = Database::fetch_array($result)) {
$return[$row['file_id']] = $row['total'];
}
return $return;
}
/**
* @desc this function checks if the key exists. If this is the case
* it returns the value, if not it returns 0
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*/
function check_number_feedback($key, $array)
{
if (is_array($array)) {
if (array_key_exists($key, $array)) {
return $array[$key];
} else {
return 0;
}
} else {
return 0;
}
}
/**
* Get the last access to a given tool of a given user.
*
* @param $tool string the tool constant
* @param $courseId the course_id
* @param $user_id the id of the user
*
* @return string last tool access date
*
* @author Patrick Cool , Ghent University
*
* @version march 2006
*
* @todo consider moving this function to a more appropriate place.
*/
function get_last_tool_access($tool, $courseId = null, $user_id = null)
{
// The default values of the parameters
if (empty($courseId)) {
$courseId = api_get_course_int_id();
}
if (empty($user_id)) {
$user_id = api_get_user_id();
}
// the table where the last tool access is stored (=track_e_lastaccess)
$table_last_access = Database::get_main_table('track_e_lastaccess');
$sql = "SELECT access_date FROM $table_last_access
WHERE
access_user_id = ".intval($user_id)." AND
c_id='".intval($courseId)."' AND
access_tool='".Database::escape_string($tool)."'
ORDER BY access_date DESC
LIMIT 1";
$result = Database::query($sql);
$row = Database::fetch_array($result);
return $row['access_date'];
}
/**
* Previously $dropbox_cnf['mailingIdBase'], returns a mailing ID to generate a mail ID.
*
* @return int
*/
function get_mail_id_base()
{
// false = no mailing functionality
//$dropbox_cnf['mailingIdBase'] = 10000000; // bigger than any user_id,
// allowing enough space for pseudo_ids as uploader_id, dest_user_id, user_id:
// mailing pseudo_id = dropbox_cnf('mailingIdBase') + mailing id
return 10000000;
}