"; $actionCompilatio .= Display::url( get_lang('Analyse'), 'javascript:void(0)', [ 'class' => 'getSingleCompilatio btn btn-primary btn-xs', 'onclick' => "getSingleCompilatio($item_id);", ] ); $actionCompilatio .= get_lang('with Compilatio'); } } $work['compilatio'] = $actionCompilatio; } $works[] = $work; } } return $works; } } /** * Send reminder to users who have not given the task. * * @param int * * @return array * * @author cvargas carlos.vargas@beeznest.com cfasanando, christian.fasanado@beeznest.com */ function send_reminder_users_without_publication($task_data) { $_course = api_get_course_info(); $task_id = $task_data['id']; $task_title = !empty($task_data['title']) ? $task_data['title'] : basename($task_data['url']); $subject = '['.api_get_setting('siteName').'] '; // The body can be as long as you wish, and any combination of text and variables $content = get_lang('Please remember you still have to send an assignment')."\n".get_lang('Course name').' : '.$_course['name']."\n"; $content .= get_lang('Assignment name').' : '.$task_title."\n"; $list_users = get_list_users_without_publication($task_id); $mails_sent_to = []; foreach ($list_users as $user) { $name_user = api_get_person_name($user[1], $user[0], null, PERSON_NAME_EMAIL_ADDRESS); $dear_line = get_lang('Dear')." ".api_get_person_name($user[1], $user[0]).", \n\n"; $body = $dear_line.$content; MessageManager::send_message($user[3], $subject, $body); $mails_sent_to[] = $name_user; } return $mails_sent_to; } /** * @param int $workId The work ID * @param int $courseId The course ID * @param int $sessionId Optional. The session ID */ function sendEmailToDrhOnHomeworkCreation($workId, $courseId, $sessionId = 0) { $courseInfo = api_get_course_info_by_id($courseId); $assignment = get_work_assignment_by_id($workId, $courseId); $work = get_work_data_by_id($workId, $courseId, $sessionId); $workInfo = array_merge($assignment, $work); if (empty($sessionId)) { $students = CourseManager::get_student_list_from_course_code($courseInfo['code']); } else { $students = CourseManager::get_student_list_from_course_code($courseInfo['code'], true, $sessionId); } $bodyView = new Template(null, false, false, false, false, false); foreach ($students as $student) { $studentInfo = api_get_user_info($student['user_id']); if (empty($studentInfo)) { continue; } $hrms = UserManager::getDrhListFromUser($student['id']); foreach ($hrms as $hrm) { $hrmName = api_get_person_name($hrm['firstname'], $hrm['lastname'], null, PERSON_NAME_EMAIL_ADDRESS); $bodyView->assign('hrm_name', $hrmName); $bodyView->assign('student', $studentInfo); $bodyView->assign('course', $courseInfo); $bodyView->assign('course_link', api_get_course_url($courseInfo['code'], $sessionId)); $bodyView->assign('work', $workInfo); $bodyTemplate = $bodyView->get_template('mail/new_work_alert_hrm.tpl'); MessageManager::send_message( $hrm['id'], sprintf( get_lang('%s got a new assignment in course %s'), $student['firstname'], $courseInfo['title'] ), $bodyView->fetch($bodyTemplate) ); } } } /** * Sends an email to the students of a course when a homework is created. * * @param int $workId * @param int $courseId * @param int $sessionId * * @author Guillaume Viguier * @author Julio Montoya Adding session support - 2011 */ function sendEmailToStudentsOnHomeworkCreation($workId, $courseId, $sessionId = 0) { $courseInfo = api_get_course_info_by_id($courseId); $courseCode = $courseInfo['code']; // Get the students of the course if (empty($sessionId)) { $students = CourseManager::get_student_list_from_course_code($courseCode); } else { $students = CourseManager::get_student_list_from_course_code($courseCode, true, $sessionId); } $emailsubject = '['.api_get_setting('siteName').'] '.get_lang('An assignment was created'); $currentUser = api_get_user_info(api_get_user_id()); if (!empty($students)) { foreach ($students as $student) { $user_info = api_get_user_info($student['user_id']); if (!empty($user_info)) { $link = api_get_path(WEB_CODE_PATH).'work/work_list.php?'.api_get_cidreq().'&id='.$workId; $emailbody = get_lang('Dear')." ".$user_info['complete_name'].",\n\n"; $emailbody .= get_lang('An assignment has been added to course')." ".$courseCode.". "."\n\n". ''.get_lang('Please check the assignments page.').''; $emailbody .= "\n\n".$currentUser['complete_name']; $additionalParameters = [ 'smsType' => SmsPlugin::ASSIGNMENT_BEEN_CREATED_COURSE, 'userId' => $student['user_id'], 'courseTitle' => $courseCode, 'link' => $link, ]; MessageManager::send_message_simple( $student['user_id'], $emailsubject, $emailbody, null, false, false, $additionalParameters, false ); } } } } /** * @param string $url * * @return bool */ function is_work_exist_by_url($url) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $url = Database::escape_string($url); $sql = "SELECT id FROM $table WHERE url='$url'"; $result = Database::query($sql); if (Database::num_rows($result) > 0) { $row = Database::fetch_row($result); if (empty($row)) { return false; } else { return true; } } else { return false; } } /** * Check if a user is the author of a work document. * * @param int $itemId * @param int $userId * @param int $courseId * @param int $sessionId * * @return bool */ function user_is_author($itemId, $userId = null, $courseId = 0, $sessionId = 0) { if (empty($itemId)) { return false; } if (empty($userId)) { $userId = api_get_user_id(); } $isAuthor = false; $is_allowed_to_edit = api_is_allowed_to_edit(); if ($is_allowed_to_edit) { $isAuthor = true; } else { if (empty($courseId)) { $courseId = api_get_course_int_id(); } if (empty($sessionId)) { $sessionId = api_get_session_id(); } $data = api_get_item_property_info($courseId, 'work', $itemId, $sessionId); if ($data['insert_user_id'] == $userId) { $isAuthor = true; } $workData = get_work_data_by_id($itemId); if ($workData['user_id'] == $userId) { $isAuthor = true; } } if (!$isAuthor) { return false; } return $isAuthor; } /** * Get list of users who have not given the task. * * @param int * @param int * * @return array * * @author cvargas * @author Julio Montoya Fixing query */ function get_list_users_without_publication($task_id, $studentId = 0) { $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $table_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER); $table_user = Database::get_main_table(TABLE_MAIN_USER); $session_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); $users = getAllUserToWork($task_id, api_get_course_int_id()); $users = array_column($users, 'user_id'); // Condition for the session $session_id = api_get_session_id(); $course_id = api_get_course_int_id(); $task_id = intval($task_id); $sessionCondition = api_get_session_condition($session_id); if ($session_id == 0) { $sql = "SELECT user_id as id FROM $work_table WHERE c_id = $course_id AND parent_id = '$task_id' AND active IN (0, 1)"; } else { $sql = "SELECT user_id as id FROM $work_table WHERE c_id = $course_id AND parent_id = '$task_id' $sessionCondition AND active IN (0, 1)"; } $result = Database::query($sql); $users_with_tasks = []; while ($row = Database::fetch_array($result)) { $users_with_tasks[] = $row['id']; } if ($session_id == 0) { $sql_users = "SELECT cu.user_id, u.lastname, u.firstname, u.email FROM $table_course_user AS cu, $table_user AS u WHERE u.status != 1 and cu.c_id='".$course_id."' AND u.user_id = cu.user_id"; } else { $sql_users = "SELECT cu.user_id, u.lastname, u.firstname, u.email FROM $session_course_rel_user AS cu, $table_user AS u WHERE u.status != 1 AND cu.c_id='".$course_id."' AND u.user_id = cu.user_id AND cu.session_id = '".$session_id."'"; } if (!empty($studentId)) { $sql_users .= " AND u.user_id = ".intval($studentId); } $group_id = api_get_group_id(); $new_group_user_list = []; if ($group_id) { $groupInfo = GroupManager::get_group_properties($group_id); $group_user_list = GroupManager::get_subscribed_users($groupInfo); if (!empty($group_user_list)) { foreach ($group_user_list as $group_user) { $new_group_user_list[] = $group_user['user_id']; } } } $result_users = Database::query($sql_users); $users_without_tasks = []; while ($rowUsers = Database::fetch_array($result_users)) { $userId = $rowUsers['user_id']; if (in_array($userId, $users_with_tasks)) { continue; } if ($group_id && !in_array($userId, $new_group_user_list)) { continue; } if (!empty($users)) { if (!in_array($userId, $users)) { continue; } } $row_users = []; $row_users[0] = $rowUsers['lastname']; $row_users[1] = $rowUsers['firstname']; $row_users[2] = Display::encrypted_mailto_link($rowUsers['email']); $row_users[3] = $userId; $users_without_tasks[] = $row_users; } return $users_without_tasks; } /** * Display list of users who have not given the task. * * @param int task id * @param int $studentId * * @author cvargas carlos.vargas@beeznest.com cfasanando, christian.fasanado@beeznest.com * @author Julio Montoya Fixes */ function display_list_users_without_publication($task_id, $studentId = null) { $origin = api_get_origin(); $table_header[] = [get_lang('Last name'), true]; $table_header[] = [get_lang('First name'), true]; $table_header[] = [get_lang('e-mail'), true]; $data = get_list_users_without_publication($task_id); $sorting_options = []; $sorting_options['column'] = 1; $paging_options = []; $my_params = []; if (isset($_GET['edit_dir'])) { $my_params['edit_dir'] = Security::remove_XSS($_GET['edit_dir']); } if (isset($_GET['list'])) { $my_params['list'] = Security::remove_XSS($_GET['list']); } $my_params['origin'] = $origin; $my_params['id'] = intval($_GET['id']); //$column_show $column_show[] = 1; $column_show[] = 1; $column_show[] = 1; Display::display_sortable_config_table( 'work', $table_header, $data, $sorting_options, $paging_options, $my_params, $column_show ); } /** * @param int $documentId * @param int $workId * @param int $courseId */ function addDocumentToWork($documentId, $workId, $courseId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); $params = [ 'document_id' => $documentId, 'work_id' => $workId, 'c_id' => $courseId, ]; Database::insert($table, $params); } /** * @param int $documentId * @param int $workId * @param int $courseId * * @return array */ function getDocumentToWork($documentId, $workId, $courseId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); $params = [ 'document_id = ? and work_id = ? and c_id = ?' => [$documentId, $workId, $courseId], ]; return Database::select('*', $table, ['where' => $params]); } /** * @param int $documentId * @param int $workId * @param int $courseId * @param int $sessionId * @param int $userId * @param int $active * * @return array */ function getDocumentToWorkPerUser($documentId, $workId, $courseId, $sessionId, $userId, $active = 1) { $workRel = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); $work = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $documentId = intval($documentId); $workId = intval($workId); $courseId = intval($courseId); $userId = intval($userId); $sessionId = intval($sessionId); $active = intval($active); $sessionCondition = api_get_session_condition($sessionId); $sql = "SELECT w.* FROM $work w INNER JOIN $workRel rel ON (w.parent_id = rel.work_id) WHERE w.document_id = $documentId AND w.parent_id = $workId AND w.c_id = $courseId $sessionCondition AND user_id = $userId AND active = $active "; $result = Database::query($sql); $workInfo = []; if (Database::num_rows($result)) { $workInfo = Database::fetch_array($result, 'ASSOC'); } return $workInfo; } /** * @param int $workId * @param int $courseId * * @return array */ function getAllDocumentToWork($workId, $courseId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); $params = [ 'work_id = ? and c_id = ?' => [$workId, $courseId], ]; return Database::select('*', $table, ['where' => $params]); } /** * @param int $documentId * @param int $workId * @param int $courseId */ function deleteDocumentToWork($documentId, $workId, $courseId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); $params = [ 'document_id = ? and work_id = ? and c_id = ?' => [$documentId, $workId, $courseId], ]; Database::delete($table, $params); } /** * @param int $userId * @param int $workId * @param int $courseId */ function addUserToWork($userId, $workId, $courseId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); $params = [ 'user_id' => $userId, 'work_id' => $workId, 'c_id' => $courseId, ]; Database::insert($table, $params); } /** * @param int $userId * @param int $workId * @param int $courseId * * @return array */ function getUserToWork($userId, $workId, $courseId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); $params = [ 'user_id = ? and work_id = ? and c_id = ?' => [$userId, $workId, $courseId], ]; return Database::select('*', $table, ['where' => $params]); } /** * @param int $workId * @param int $courseId * @param bool $getCount * * @return array|int */ function getAllUserToWork($workId, $courseId, $getCount = false) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); $params = [ 'work_id = ? and c_id = ?' => [$workId, $courseId], ]; if ($getCount) { $count = 0; $result = Database::select( 'count(user_id) as count', $table, ['where' => $params], 'simple' ); if (!empty($result)) { $count = intval($result['count']); } return $count; } else { return Database::select('*', $table, ['where' => $params]); } } /** * @param int $userId * @param int $workId * @param int $courseId */ function deleteUserToWork($userId, $workId, $courseId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); $params = [ 'user_id = ? and work_id = ? and c_id = ?' => [$userId, $workId, $courseId], ]; Database::delete($table, $params); } /** * @param int $userId * @param int $workId * @param int $courseId * * @return bool */ function userIsSubscribedToWork($userId, $workId, $courseId) { $subscribedUsers = getAllUserToWork($workId, $courseId); if (empty($subscribedUsers)) { return true; } else { $subscribedUsersList = []; foreach ($subscribedUsers as $item) { $subscribedUsersList[] = $item['user_id']; } if (in_array($userId, $subscribedUsersList)) { return true; } } return false; } /** * Get the list of students that have to submit their work. * * @param int $workId The internal ID of the assignment * @param int $courseId The course ID * @param int $groupId The group ID, if any * @param int $sessionId The session ID, if any * @param bool $getCount Whether we want just the amount or the full result * * @return array|int An integer (if we just asked for the count) or an array of users */ function getStudentSubscribedToWork( $workId, $courseId, $groupId = null, $sessionId = null, $getCount = false ) { $usersInWork = null; $usersInCourse = null; if (empty($groupId)) { $courseInfo = api_get_course_info_by_id($courseId); $status = STUDENT; if (!empty($sessionId)) { $status = 0; } $usersInCourse = CourseManager::get_user_list_from_course_code( $courseInfo['code'], $sessionId, null, null, $status, $getCount ); } else { $usersInCourse = GroupManager::get_users( $groupId, false, null, null, $getCount, $courseId ); } $usersInWork = getAllUserToWork($workId, $courseId, $getCount); if (empty($usersInWork)) { return $usersInCourse; } else { return $usersInWork; } } /** * @param int $userId * @param int $workId * @param int $courseId * @param bool $forceAccessForCourseAdmins * * @return bool */ function allowOnlySubscribedUser($userId, $workId, $courseId, $forceAccessForCourseAdmins = false) { if (api_is_platform_admin() || api_is_allowed_to_edit()) { return true; } if ($forceAccessForCourseAdmins) { if (api_is_course_admin() || api_is_coach()) { return true; } } return userIsSubscribedToWork($userId, $workId, $courseId); } /** * @param int $workId * @param array $courseInfo * @param int $documentId * * @return array */ function getDocumentTemplateFromWork($workId, $courseInfo, $documentId) { $documents = getAllDocumentToWork($workId, $courseInfo['real_id']); if (!empty($documents)) { foreach ($documents as $doc) { if ($documentId != $doc['document_id']) { continue; } $docData = DocumentManager::get_document_data_by_id($doc['document_id'], $courseInfo['code']); $fileInfo = pathinfo($docData['path']); if ($fileInfo['extension'] == 'html') { if (file_exists($docData['absolute_path']) && is_file($docData['absolute_path'])) { $docData['file_content'] = file_get_contents($docData['absolute_path']); return $docData; } } } } return []; } /** * @param int $workId * @param array $courseInfo * * @return string */ function getAllDocumentsFromWorkToString($workId, $courseInfo) { $documents = getAllDocumentToWork($workId, $courseInfo['real_id']); $content = null; if (!empty($documents)) { $content .= '

'.get_lang('Documents').'
'.$docData['title'].'

'; } return $content; } /** * Returns fck editor toolbar. * * @return array */ function getWorkDescriptionToolbar() { return [ 'ToolbarStartExpanded' => 'true', 'ToolbarSet' => 'Work', 'Width' => '100%', 'Height' => '400', ]; } /** * @param array $work * * @return array */ function getWorkComments($work) { $commentTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT_COMMENT); $userTable = Database::get_main_table(TABLE_MAIN_USER); $courseId = intval($work['c_id']); $workId = intval($work['id']); if (empty($courseId) || empty($workId)) { return []; } $sql = "SELECT c.id, c.user_id FROM $commentTable c INNER JOIN $userTable u ON (u.id = c.user_id) WHERE c_id = $courseId AND work_id = $workId ORDER BY sent_at "; $result = Database::query($sql); $comments = Database::store_result($result, 'ASSOC'); if (!empty($comments)) { foreach ($comments as &$comment) { $userInfo = api_get_user_info($comment['user_id']); $comment['picture'] = $userInfo['avatar']; $comment['complete_name'] = $userInfo['complete_name_with_username']; $commentInfo = getWorkComment($comment['id']); if (!empty($commentInfo)) { $comment = array_merge($comment, $commentInfo); } } } return $comments; } /** * Get total score from a work list. * * @param $workList * * @return int|null */ function getTotalWorkScore($workList) { $count = 0; foreach ($workList as $data) { $count += $data['qualification_score']; } return $count; } /** * Get comment count from a work list (docs sent by students). * * @param array $workList * @param array $courseInfo * * @return int|null */ function getTotalWorkComment($workList, $courseInfo = []) { if (empty($courseInfo)) { $courseInfo = api_get_course_info(); } $count = 0; foreach ($workList as $data) { $count += getWorkCommentCount($data['id'], $courseInfo); } return $count; } /** * Get comment count for a specific work sent by a student. * * @param int $id * @param array $courseInfo * * @return int */ function getWorkCommentCount($id, $courseInfo = []) { if (empty($courseInfo)) { $courseInfo = api_get_course_info(); } $commentTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT_COMMENT); $id = intval($id); $sql = "SELECT count(*) as count FROM $commentTable WHERE work_id = $id AND c_id = ".$courseInfo['real_id']; $result = Database::query($sql); if (Database::num_rows($result)) { $comment = Database::fetch_array($result); return $comment['count']; } return 0; } /** * Get comment count for a specific parent. * * @param int $parentId * @param array $courseInfo * @param int $sessionId * * @return int */ function getWorkCommentCountFromParent( $parentId, $courseInfo = [], $sessionId = 0 ) { if (empty($courseInfo)) { $courseInfo = api_get_course_info(); } if (empty($sessionId)) { $sessionId = api_get_session_id(); } else { $sessionId = intval($sessionId); } $work = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $commentTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT_COMMENT); $parentId = intval($parentId); $sessionCondition = api_get_session_condition($sessionId, false, false, 'w.session_id'); $sql = "SELECT count(*) as count FROM $commentTable c INNER JOIN $work w ON c.c_id = w.c_id AND w.id = c.work_id WHERE $sessionCondition AND parent_id = $parentId AND w.c_id = ".$courseInfo['real_id']; $result = Database::query($sql); if (Database::num_rows($result)) { $comment = Database::fetch_array($result); return $comment['count']; } return 0; } /** * Get last work information from parent. * * @param int $parentId * @param array $courseInfo * @param int $sessionId * * @return int */ function getLastWorkStudentFromParent( $parentId, $courseInfo = [], $sessionId = 0 ) { if (empty($courseInfo)) { $courseInfo = api_get_course_info(); } if (empty($sessionId)) { $sessionId = api_get_session_id(); } else { $sessionId = intval($sessionId); } $work = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $sessionCondition = api_get_session_condition($sessionId, false); $commentTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT_COMMENT); $parentId = intval($parentId); $sql = "SELECT w.* FROM $commentTable c INNER JOIN $work w ON c.c_id = w.c_id AND w.id = c.work_id WHERE $sessionCondition AND parent_id = $parentId AND w.c_id = ".$courseInfo['real_id']." ORDER BY w.sent_date LIMIT 1 "; $result = Database::query($sql); if (Database::num_rows($result)) { $comment = Database::fetch_array($result, 'ASSOC'); return $comment; } return []; } /** * Get last work information from parent. * * @param int $userId * @param array $parentInfo * @param array $courseInfo * @param int $sessionId * * @return int */ function getLastWorkStudentFromParentByUser( $userId, $parentInfo, $courseInfo = [], $sessionId = 0 ) { if (empty($courseInfo)) { $courseInfo = api_get_course_info(); } if (empty($sessionId)) { $sessionId = api_get_session_id(); } else { $sessionId = intval($sessionId); } $userId = intval($userId); $work = Database::get_course_table(TABLE_STUDENT_PUBLICATION); if (empty($parentInfo)) { return false; } $parentId = $parentInfo['id']; $sessionCondition = api_get_session_condition($sessionId); $sql = "SELECT * FROM $work WHERE user_id = $userId $sessionCondition AND parent_id = $parentId AND c_id = ".$courseInfo['real_id']." ORDER BY sent_date DESC LIMIT 1 "; $result = Database::query($sql); if (Database::num_rows($result)) { $work = Database::fetch_array($result, 'ASSOC'); $work['qualification_rounded'] = formatWorkScore($work['qualification'], $parentInfo['qualification']); return $work; } return []; } /** * @param float $score * @param int $weight * * @return string */ function formatWorkScore($score, $weight) { $label = 'info'; $weight = (int) $weight; $relativeScore = 0; if (!empty($weight)) { $relativeScore = $score / $weight; } if ($relativeScore < 0.5) { $label = 'important'; } elseif ($relativeScore < 0.75) { $label = 'warning'; } $scoreBasedInModel = ExerciseLib::convertScoreToModel($relativeScore * 100); if (empty($scoreBasedInModel)) { $finalScore = api_number_format($score, 1).' / '.$weight; return Display::label( $finalScore, $label ); } else { $finalScore = $scoreBasedInModel; return $finalScore; } } /** * @param int $id comment id * @param array $courseInfo * * @return string */ function getWorkComment($id, $courseInfo = []) { if (empty($courseInfo)) { $courseInfo = api_get_course_info(); } if (empty($courseInfo['real_id'])) { return []; } $commentTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT_COMMENT); $id = intval($id); $sql = "SELECT * FROM $commentTable WHERE id = $id AND c_id = ".$courseInfo['real_id']; $result = Database::query($sql); $comment = []; if (Database::num_rows($result)) { $comment = Database::fetch_array($result, 'ASSOC'); $filePath = null; $fileUrl = null; $deleteUrl = null; $fileName = null; if (!empty($comment['file'])) { $work = get_work_data_by_id($comment['work_id']); $workParent = get_work_data_by_id($work['parent_id']); $filePath = api_get_path(SYS_COURSE_PATH).$courseInfo['path'].'/work/'.$workParent['url'].'/'.$comment['file']; $fileUrl = api_get_path(WEB_CODE_PATH).'work/download_comment_file.php?comment_id='.$id.'&'.api_get_cidreq(); $deleteUrl = api_get_path(WEB_CODE_PATH).'work/view.php?'.api_get_cidreq().'&id='.$comment['work_id'].'&action=delete_attachment&comment_id='.$id; $fileParts = explode('_', $comment['file']); $fileName = str_replace($fileParts[0].'_'.$fileParts[1].'_', '', $comment['file']); } $comment['delete_file_url'] = $deleteUrl; $comment['file_path'] = $filePath; $comment['file_url'] = $fileUrl; $comment['file_name_to_show'] = $fileName; $comment['sent_at_with_label'] = Display::dateToStringAgoAndLongDate($comment['sent_at']); } return $comment; } /** * @param int $id * @param array $courseInfo */ function deleteCommentFile($id, $courseInfo = []) { $workComment = getWorkComment($id, $courseInfo); if (isset($workComment['file']) && !empty($workComment['file'])) { if (file_exists($workComment['file_path'])) { $result = my_delete($workComment['file_path']); if ($result) { $commentTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT_COMMENT); $params = ['file' => '']; Database::update( $commentTable, $params, ['id = ? AND c_id = ? ' => [$workComment['id'], $workComment['c_id']]] ); } } } } /** * Adds a comments to the work document. * * @param array $courseInfo * @param int $userId * @param array $parentWork * @param array $work * @param array $data * * @return int */ function addWorkComment($courseInfo, $userId, $parentWork, $work, $data) { $fileData = isset($data['attachment']) ? $data['attachment'] : null; $commentTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT_COMMENT); // If no attachment and no comment then don't save comment if (empty($fileData['name']) && empty($data['comment'])) { return false; } $params = [ 'work_id' => $work['id'], 'c_id' => $work['c_id'], 'user_id' => $userId, 'comment' => $data['comment'], 'sent_at' => api_get_utc_datetime(), ]; $commentId = Database::insert($commentTable, $params); if ($commentId) { Display::addFlash( Display::return_message(get_lang('You comment has been added')) ); $sql = "UPDATE $commentTable SET id = iid WHERE iid = $commentId"; Database::query($sql); } $userIdListToSend = []; if (api_is_allowed_to_edit()) { if (isset($data['send_email']) && $data['send_email']) { // Teacher sends a feedback $userIdListToSend = [$work['user_id']]; } } else { $sessionId = api_get_session_id(); if (empty($sessionId)) { $teachers = CourseManager::get_teacher_list_from_course_code( $courseInfo['code'] ); if (!empty($teachers)) { $userIdListToSend = array_keys($teachers); } } else { $teachers = SessionManager::getCoachesByCourseSession( $sessionId, $courseInfo['real_id'] ); if (!empty($teachers)) { $userIdListToSend = array_values($teachers); } } $sendNotification = api_get_course_setting('email_to_teachers_on_new_work_feedback'); if ($sendNotification != 1) { $userIdListToSend = []; } } $url = api_get_path(WEB_CODE_PATH).'work/view.php?'.api_get_cidreq().'&id='.$work['id']; $subject = sprintf(get_lang('There\'s a new feedback in work: %s'), $parentWork['title']); $content = sprintf(get_lang('There\'s a new feedback in work: %sInWorkXHere'), $work['title'], $url); if (!empty($data['comment'])) { $content .= '
'.get_lang('Comment').':
'.$data['comment']; } if (!empty($userIdListToSend)) { foreach ($userIdListToSend as $userIdToSend) { MessageManager::send_message_simple( $userIdToSend, $subject, $content ); } } if (!empty($commentId) && !empty($fileData)) { $workParent = get_work_data_by_id($work['parent_id']); if (!empty($workParent)) { $uploadDir = api_get_path(SYS_COURSE_PATH).$courseInfo['path'].'/work'.$workParent['url']; $newFileName = 'comment_'.$commentId.'_'.php2phps(api_replace_dangerous_char($fileData['name'])); $newFilePath = $uploadDir.'/'.$newFileName; $result = move_uploaded_file($fileData['tmp_name'], $newFilePath); if ($result) { $params = ['file' => $newFileName]; Database::update( $commentTable, $params, ['id = ? AND c_id = ? ' => [$commentId, $work['c_id']]] ); } } } } /** * @param array $work * @param array $workParent * * @return string */ function getWorkCommentForm($work, $workParent) { $url = api_get_path(WEB_CODE_PATH).'work/view.php?id='.$work['id'].'&action=send_comment&'.api_get_cidreq(); $form = new FormValidator( 'work_comment', 'post', $url, '', ['enctype' => "multipart/form-data"] ); $qualification = $workParent['qualification']; if (api_is_allowed_to_edit()) { if (!empty($qualification) && intval($qualification) > 0) { $model = ExerciseLib::getCourseScoreModel(); if (empty($model)) { $form->addFloat( 'qualification', [get_lang('Score'), " / ".$qualification], false, [], false, 0, $qualification ); } else { ExerciseLib::addScoreModelInput( $form, 'qualification', $qualification, $work['qualification'] ); } $form->addFile('file', get_lang('Correction')); $form->setDefaults(['qualification' => $work['qualification']]); } } Skill::addSkillsToUserForm($form, ITEM_TYPE_STUDENT_PUBLICATION, $workParent['id'], $work['user_id'], $work['id']); $form->addHtmlEditor('comment', get_lang('Comment'), false); $form->addFile('attachment', get_lang('Attachment')); $form->addElement('hidden', 'id', $work['id']); if (api_is_allowed_to_edit()) { $form->addCheckBox( 'send_email', null, get_lang('Send message mail to student') ); } $form->addButtonSend(get_lang('Send'), 'button'); return $form->returnForm(); } /** * @param array $homework result of get_work_assignment_by_id() * * @return array */ function getWorkDateValidationStatus($homework) { $message = null; $has_expired = false; $has_ended = false; if (!empty($homework)) { if (!empty($homework['expires_on']) || !empty($homework['ends_on'])) { $time_now = time(); if (!empty($homework['expires_on'])) { $time_expires = api_strtotime($homework['expires_on'], 'UTC'); $difference = $time_expires - $time_now; if ($difference < 0) { $has_expired = true; } } if (empty($homework['expires_on'])) { $has_expired = false; } if (!empty($homework['ends_on'])) { $time_ends = api_strtotime($homework['ends_on'], 'UTC'); $difference2 = $time_ends - $time_now; if ($difference2 < 0) { $has_ended = true; } } $ends_on = api_convert_and_format_date($homework['ends_on']); $expires_on = api_convert_and_format_date($homework['expires_on']); } if ($has_ended) { $message = Display::return_message(get_lang('End date already passed').' '.$ends_on, 'error'); } elseif ($has_expired) { $message = Display::return_message(get_lang('Expiry date already passed').' '.$expires_on, 'warning'); } else { if ($has_expired) { $message = Display::return_message(get_lang('ExpiryDateToSend messageWorkIs').' '.$expires_on); } } } return [ 'message' => $message, 'has_ended' => $has_ended, 'has_expired' => $has_expired, ]; } /** * @param FormValidator $form * @param int $uploadFormType */ function setWorkUploadForm($form, $uploadFormType = 0) { $form->addHeader(get_lang('Upload a document')); $form->addHidden('contains_file', 0, ['id' => 'contains_file_id']); $form->addHidden('active', 1); $form->addHidden('accepted', 1); $form->addElement('text', 'title', get_lang('Title'), ['id' => 'file_upload']); $form->addElement( 'text', 'extension', get_lang('File extension'), ['id' => 'file_extension', 'readonly' => 'readonly'] ); $form->addRule('title', get_lang('Required field'), 'required'); switch ($uploadFormType) { case 0: // File and text. $form->addElement( 'file', 'file', get_lang('Upload a document'), 'size="40" onchange="updateDocumentTitle(this.value)"' ); $form->addProgress(); $form->addHtmlEditor('description', get_lang('Description'), false, false, getWorkDescriptionToolbar()); break; case 1: // Only text. $form->addHtmlEditor('description', get_lang('Description'), false, false, getWorkDescriptionToolbar()); $form->addRule('description', get_lang('Required field'), 'required'); break; case 2: // Only file. $form->addElement( 'file', 'file', get_lang('Upload a document'), 'size="40" onchange="updateDocumentTitle(this.value)"' ); $form->addProgress(); $form->addRule('file', get_lang('Required field'), 'required'); break; } $form->addButtonUpload(get_lang('Upload'), 'submitWork'); } /** * @param array $my_folder_data * @param array $_course * @param bool $isCorrection * @param array $workInfo * @param array $file * * @return array */ function uploadWork($my_folder_data, $_course, $isCorrection = false, $workInfo = [], $file = []) { if (isset($_FILES['file']) && !empty($_FILES['file'])) { $file = $_FILES['file']; } if (empty($file['size'])) { return [ 'error' => Display:: return_message( get_lang('There was a problem uploading your document: the received file had a 0 bytes size on the server. Please, review your local file for any corruption or damage, then try again.'), 'error' ), ]; } $updir = api_get_path(SYS_COURSE_PATH).$_course['path'].'/work/'; //directory path to upload // Try to add an extension to the file if it has'nt one $filename = add_ext_on_mime(stripslashes($file['name']), $file['type']); // Replace dangerous characters $filename = api_replace_dangerous_char($filename); // Transform any .php file in .phps fo security $filename = php2phps($filename); $filesize = filesize($file['tmp_name']); if (empty($filesize)) { return [ 'error' => Display::return_message( get_lang('There was a problem uploading your document: the received file had a 0 bytes size on the server. Please, review your local file for any corruption or damage, then try again.'), 'error' ), ]; } elseif (!filter_extension($new_file_name)) { return [ 'error' => Display::return_message( get_lang('File upload failed: this file extension or file type is prohibited'), 'error' ), ]; } $repo = Container::getDocumentRepository(); $totalSpace = $repo->getTotalSpace($_course['real_id']); $course_max_space = DocumentManager::get_course_quota($_course['code']); $total_size = $filesize + $totalSpace; if ($total_size > $course_max_space) { return [ 'error' => Display::return_message(get_lang('The upload has failed. Either you have exceeded your maximum quota, or there is not enough disk space.'), 'error'), ]; } // Compose a unique file name to avoid any conflict $new_file_name = api_get_unique_id(); if ($isCorrection) { if (!empty($workInfo['url'])) { $new_file_name = basename($workInfo['url']).'_correction'; } else { $new_file_name = $new_file_name.'_correction'; } } $curdirpath = basename($my_folder_data['url']); // If we come from the group tools the groupid will be saved in $work_table if (is_dir($updir.$curdirpath) || empty($curdirpath)) { $result = move_uploaded_file( $file['tmp_name'], $updir.$curdirpath.'/'.$new_file_name ); } else { return [ 'error' => Display :: return_message( get_lang('Target folder doesn\'t exist on the server.'), 'error' ), ]; } if ($result) { $url = 'work/'.$curdirpath.'/'.$new_file_name; } else { return false; } return [ 'url' => $url, 'filename' => $filename, 'filesize' => $filesize, 'error' => '', ]; } /** * Send an e-mail to users related to this work (course teachers, usually, but * might include other group members). * * @param int $workId * @param array $courseInfo * @param int $sessionId */ function sendAlertToUsers($workId, $courseInfo, $sessionId) { $sessionId = (int) $sessionId; $workData = get_work_data_by_id($workId, $courseInfo['real_id'], $sessionId); // last value is to check this is not "just" an edit // YW Tis part serve to send a e-mail to the tutors when a new file is sent $send = api_get_course_setting('email_alert_manager_on_new_doc'); $userList = []; if ($send == SEND_EMAIL_EVERYONE || $send == SEND_EMAIL_TEACHERS) { // Lets predefine some variables. Be sure to change the from address! if (empty($sessionId)) { // Teachers $userList = CourseManager::get_user_list_from_course_code( api_get_course_id(), null, null, null, COURSEMANAGER ); } else { // Coaches $userList = CourseManager::get_user_list_from_course_code( api_get_course_id(), $sessionId, null, null, 2 ); } } if ($send == SEND_EMAIL_EVERYONE || $send == SEND_EMAIL_STUDENTS) { // Send mail only to sender $studentList = [[ 'user_id' => api_get_user_id(), ]]; $userList = array_merge($userList, $studentList); } if ($send) { $subject = "[".api_get_setting('siteName')."] ".get_lang('Send messageMailBody')."\n ".get_lang('Course name').": ".$courseInfo['name']." "; foreach ($userList as $user_data) { $to_user_id = $user_data['user_id']; $user_info = api_get_user_info($to_user_id); $message = get_lang('Send messageMailBody')."\n".get_lang('Course name')." : ".$courseInfo['name']."\n"; $message .= get_lang('Username')." : ".$user_info['complete_name']."\n"; $message .= get_lang('Date sent')." : ".api_format_date(api_get_local_time())."\n"; $url = api_get_path(WEB_CODE_PATH)."work/work.php?cidReq=".$courseInfo['code']."&id_session=".$sessionId."&id=".$workData['id']; $message .= get_lang('Assignment name')." : ".$workData['title']."\n\n".''.get_lang('Download link')."\n"; MessageManager::send_message_simple( $to_user_id, $subject, $message, 0, false, false, [], false ); } } } /** * Check if the current uploaded work filename already exists in the current assement. * * @param string $filename * @param int $workId * * @return array */ function checkExistingWorkFileName($filename, $workId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $filename = Database::escape_string($filename); $workId = (int) $workId; $sql = "SELECT title FROM $table WHERE parent_id = $workId AND title = '$filename' AND active = 1"; $result = Database::query($sql); return Database::fetch_assoc($result); } /** * @param array $workInfo * @param array $values * @param array $courseInfo * @param int $sessionId * @param int $groupId * @param int $userId * @param array $file * @param bool $checkDuplicated * @param bool $showFlashMessage * * @return string|null */ function processWorkForm( $workInfo, $values, $courseInfo, $sessionId, $groupId, $userId, $file = [], $checkDuplicated = false, $showFlashMessage = true ) { $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $courseId = $courseInfo['real_id']; $groupId = (int) $groupId; $sessionId = (int) $sessionId; $userId = (int) $userId; $extension = ''; if (isset($values['extension'])) { $extension = $values['extension']; } else { $fileInfo = pathinfo($values['title']); if (isset($fileInfo['extension']) && !empty($fileInfo['extension'])) { $extension = '.'.$fileInfo['extension']; $values['title'] = $fileInfo['filename']; } } $title = $values['title'].$extension; $description = isset($values['description']) ? $values['description'] : ''; $containsFile = isset($values['contains_file']) && !empty($values['contains_file']) ? (int) $values['contains_file'] : 0; $saveWork = true; $filename = null; $url = null; $filesize = null; $workData = []; $message = null; if ($containsFile) { $saveWork = false; if ($checkDuplicated) { if (checkExistingWorkFileName($file['name'], $workInfo['id'])) { $saveWork = false; $result['error'] = get_lang('You have already sent this file or another file with the same name. Please make sure you only upload each file once.'); $workData['error'] = get_lang(' already exists.'); } else { $result = uploadWork($workInfo, $courseInfo, false, [], $file); } } else { $result = uploadWork($workInfo, $courseInfo, false, [], $file); } if (isset($result['error'])) { $saveWork = false; if ($showFlashMessage) { $message = $result['error']; } if (empty($result['error']) && isset($result['url']) && !empty($result['url'])) { $saveWork = true; } } } if ($saveWork) { $filename = isset($result['filename']) ? $result['filename'] : null; if (empty($title)) { $title = isset($result['title']) && !empty($result['title']) ? $result['title'] : get_lang('Untitled'); } $filesize = isset($result['filesize']) ? $result['filesize'] : null; $url = isset($result['url']) ? $result['url'] : null; } if (empty($title)) { $title = get_lang('Untitled'); } $groupIid = 0; $groupInfo = []; if ($groupId) { $groupInfo = GroupManager::get_group_properties($groupId); $groupIid = $groupInfo['iid']; } if ($saveWork) { $active = '1'; $params = [ 'c_id' => $courseId, 'url' => $url, 'filetype' => 'file', 'title' => $title, 'description' => $description, 'contains_file' => $containsFile, 'active' => $active, 'accepted' => '1', 'qualificator_id' => 0, 'document_id' => 0, 'weight' => 0, 'allow_text_assignment' => 0, 'post_group_id' => $groupIid, 'sent_date' => api_get_utc_datetime(), 'parent_id' => $workInfo['id'], 'session_id' => $sessionId ? $sessionId : null, 'user_id' => $userId, 'has_properties' => 0, 'qualification' => 0, //'filesize' => $filesize ]; $workId = Database::insert($work_table, $params); if ($workId) { $sql = "UPDATE $work_table SET id = iid WHERE iid = $workId "; Database::query($sql); if (array_key_exists('filename', $workInfo) && !empty($filename)) { $filename = Database::escape_string($filename); $sql = "UPDATE $work_table SET filename = '$filename' WHERE iid = $workId"; Database::query($sql); } if (array_key_exists('document_id', $workInfo)) { $documentId = isset($values['document_id']) ? (int) $values['document_id'] : 0; $sql = "UPDATE $work_table SET document_id = '$documentId' WHERE iid = $workId"; Database::query($sql); } api_item_property_update( $courseInfo, 'work', $workId, 'DocumentAdded', $userId, $groupInfo ); sendAlertToUsers($workId, $courseInfo, $sessionId); Event::event_upload($workId); // The following feature requires the creation of a work-type // extra_field and the following setting in the configuration file // (until moved to the database). It allows te teacher to set a // "considered work time", meaning the time we assume a student // would have spent, approximately, to prepare the task before // handing it in Chamilo, adding this time to the student total // course use time, as a register of time spent *before* his // connection to the platform to hand the work in. $consideredWorkingTime = api_get_configuration_value('considered_working_time'); if (!empty($consideredWorkingTime)) { // Get the "considered work time" defined for this work $fieldValue = new ExtraFieldValue('work'); $resultExtra = $fieldValue->getAllValuesForAnItem( $workInfo['iid'], //the ID of the work *folder*, not the document uploaded by the student true ); $workingTime = null; foreach ($resultExtra as $field) { $field = $field['value']; if ($consideredWorkingTime == $field->getField()->getVariable()) { $workingTime = $field->getValue(); } } // If no time was defined, or a time of "0" was set, do nothing if (!empty($workingTime)) { // If some time is set, get the list of docs handed in by // this student (to make sure we count the time only once) $userWorks = get_work_user_list( 0, 100, null, null, $workInfo['id'], null, $userId, false, $courseId, $sessionId ); if (count($userWorks) == 1) { // The student only uploaded one doc so far, so add the // considered work time to his course connection time Event::eventAddVirtualCourseTime($courseId, $userId, $sessionId, $workingTime); } } } $workData = get_work_data_by_id($workId); if ($workData && $showFlashMessage) { Display::addFlash(Display::return_message(get_lang('The file has been added to the list of publications.'))); } } } else { if ($showFlashMessage) { Display::addFlash( Display::return_message( $message ? $message : get_lang('Impossible to save the document'), 'error' ) ); } } return $workData; } /** * Creates a new task (directory) in the assignment tool. * * @param array $formValues * @param int $user_id * @param array $courseInfo * @param int $groupId * @param int $sessionId * * @return bool|int * @note $params can have the following elements, but should at least have the 2 first ones: ( * 'new_dir' => 'some-name', * 'description' => 'some-desc', * 'qualification' => 20 (e.g. 20), * 'weight' => 50 (percentage) to add to gradebook (e.g. 50), * 'allow_text_assignment' => 0/1/2, * * @todo Rename createAssignment or createWork, or something like that */ function addDir($formValues, $user_id, $courseInfo, $groupId, $sessionId = 0) { $em = Database::getManager(); $user_id = (int) $user_id; $groupId = (int) $groupId; $sessionId = (int) $sessionId; $groupIid = 0; $groupInfo = []; if (!empty($groupId)) { $groupInfo = GroupManager::get_group_properties($groupId); $groupIid = $groupInfo['iid']; } $session = $em->find('ChamiloCoreBundle:Session', $sessionId); $base_work_dir = api_get_path(SYS_COURSE_PATH).$courseInfo['path'].'/work'; $course_id = $courseInfo['real_id']; $directory = api_replace_dangerous_char($formValues['new_dir']); $directory = disable_dangerous_file($directory); $created_dir = create_unexisting_work_directory($base_work_dir, $directory); if (empty($created_dir)) { return false; } $enableEndDate = isset($formValues['enableEndDate']) ? true : false; $enableExpiryDate = isset($formValues['enableExpiryDate']) ? true : false; if ($enableEndDate && $enableExpiryDate) { if ($formValues['expires_on'] > $formValues['ends_on']) { Display::addFlash( Display::return_message( get_lang('The date of effective blocking of sending the work can not be before the displayed posting deadline.'), 'warning' ) ); return false; } } $dirName = '/'.$created_dir; $today = new DateTime(api_get_utc_datetime(), new DateTimeZone('UTC')); $title = isset($formValues['work_title']) ? $formValues['work_title'] : $formValues['new_dir']; $workTable = new CStudentPublication(); $workTable ->setCId($course_id) ->setUrl($dirName) ->setTitle($title) ->setDescription($formValues['description']) ->setActive(true) ->setAccepted(true) ->setFiletype('folder') ->setPostGroupId($groupIid) ->setSentDate($today) ->setQualification($formValues['qualification'] != '' ? $formValues['qualification'] : 0) ->setParentId(0) ->setQualificatorId(0) ->setWeight(!empty($formValues['weight']) ? $formValues['weight'] : 0) ->setSession($session) ->setAllowTextAssignment($formValues['allow_text_assignment']) ->setContainsFile(0) ->setUserId($user_id) ->setHasProperties(0) ->setDocumentId(0); $em->persist($workTable); $em->flush(); $workTable->setId($workTable->getIid()); $em->merge($workTable); $em->flush(); // Folder created api_item_property_update( $courseInfo, 'work', $workTable->getIid(), 'DirectoryCreated', $user_id, $groupInfo ); updatePublicationAssignment( $workTable->getIid(), $formValues, $courseInfo, $groupIid ); // Added the new Work ID to the extra field values $formValues['item_id'] = $workTable->getIid(); $workFieldValue = new ExtraFieldValue('work'); $workFieldValue->saveFieldValues($formValues); $sendEmailAlert = api_get_course_setting('email_alert_students_on_new_homework'); switch ($sendEmailAlert) { case 1: sendEmailToStudentsOnHomeworkCreation( $workTable->getIid(), $course_id, $sessionId ); //no break case 2: sendEmailToDrhOnHomeworkCreation( $workTable->getIid(), $course_id, $sessionId ); break; } return $workTable->getIid(); } /** * @param int $workId * @param array $courseInfo * * @return int */ function agendaExistsForWork($workId, $courseInfo) { $workTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT); $courseId = $courseInfo['real_id']; $workId = intval($workId); $sql = "SELECT add_to_calendar FROM $workTable WHERE c_id = $courseId AND publication_id = ".$workId; $res = Database::query($sql); if (Database::num_rows($res)) { $row = Database::fetch_array($res, 'ASSOC'); if (!empty($row['add_to_calendar'])) { return $row['add_to_calendar']; } } return 0; } /** * Update work description, qualification, weight, allow_text_assignment. * * @param int $workId (iid) * @param array $params * @param array $courseInfo * @param int $sessionId */ function updateWork($workId, $params, $courseInfo, $sessionId = 0) { $workTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $filteredParams = [ 'description' => $params['description'], 'qualification' => $params['qualification'], 'weight' => $params['weight'], 'allow_text_assignment' => $params['allow_text_assignment'], ]; Database::update( $workTable, $filteredParams, [ 'iid = ? AND c_id = ?' => [ $workId, $courseInfo['real_id'], ], ] ); $workFieldValue = new ExtraFieldValue('work'); $workFieldValue->saveFieldValues($params); } /** * @param int $workId * @param array $params * @param array $courseInfo * @param int $groupId */ function updatePublicationAssignment($workId, $params, $courseInfo, $groupId) { $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT); $workTable = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $workId = intval($workId); $now = api_get_utc_datetime(); $course_id = $courseInfo['real_id']; // Insert into agenda $agendaId = 0; if (isset($params['add_to_calendar']) && $params['add_to_calendar'] == 1) { // Setting today date $date = $end_date = $now; if (isset($params['enableExpiryDate'])) { $end_date = $params['expires_on']; $date = $end_date; } $title = sprintf(get_lang('Handing over of task %s'), $params['new_dir']); $description = isset($params['description']) ? $params['description'] : ''; $content = '' .$params['new_dir'].''.$description; $agendaId = agendaExistsForWork($workId, $courseInfo); // Add/edit agenda $agenda = new Agenda('course'); $agenda->set_course($courseInfo); if (!empty($agendaId)) { // add_to_calendar is set but it doesnt exists then invalidate $eventInfo = $agenda->get_event($agendaId); if (empty($eventInfo)) { $agendaId = 0; } } $eventColor = $agenda->eventStudentPublicationColor; if (empty($agendaId)) { $agendaId = $agenda->addEvent( $date, $end_date, 'false', $title, $content, ['GROUP:'.$groupId], false, null, [], [], null, $eventColor ); } else { $agenda->editEvent( $agendaId, $end_date, $end_date, 'false', $title, $content, [], [], [], null, $eventColor ); } } $qualification = isset($params['qualification']) && !empty($params['qualification']) ? 1 : 0; $expiryDate = isset($params['enableExpiryDate']) && (int) $params['enableExpiryDate'] == 1 ? api_get_utc_datetime($params['expires_on']) : ''; $endDate = isset($params['enableEndDate']) && (int) $params['enableEndDate'] == 1 ? api_get_utc_datetime($params['ends_on']) : ''; $data = get_work_assignment_by_id($workId, $course_id); if (!empty($expiryDate)) { $expiryDateCondition = "expires_on = '".Database::escape_string($expiryDate)."', "; } else { $expiryDateCondition = "expires_on = null, "; } if (!empty($endDate)) { $endOnCondition = "ends_on = '".Database::escape_string($endDate)."', "; } else { $endOnCondition = "ends_on = null, "; } if (empty($data)) { $sql = "INSERT INTO $table SET c_id = $course_id , $expiryDateCondition $endOnCondition add_to_calendar = $agendaId, enable_qualification = '$qualification', publication_id = '$workId'"; Database::query($sql); $my_last_id = Database::insert_id(); if ($my_last_id) { $sql = "UPDATE $table SET id = iid WHERE iid = $my_last_id"; Database::query($sql); $sql = "UPDATE $workTable SET has_properties = $my_last_id, view_properties = 1 WHERE c_id = $course_id AND id = $workId"; Database::query($sql); } } else { $sql = "UPDATE $table SET $expiryDateCondition $endOnCondition add_to_calendar = $agendaId, enable_qualification = '".$qualification."' WHERE publication_id = $workId AND c_id = $course_id AND iid = ".$data['iid']; Database::query($sql); } if (!empty($params['category_id'])) { $link_info = GradebookUtils::isResourceInCourseGradebook( $courseInfo['code'], LINK_STUDENTPUBLICATION, $workId, api_get_session_id() ); $linkId = null; if (!empty($link_info)) { $linkId = $link_info['id']; } if (isset($params['make_calification']) && $params['make_calification'] == 1 ) { if (empty($linkId)) { GradebookUtils::add_resource_to_course_gradebook( $params['category_id'], $courseInfo['code'], LINK_STUDENTPUBLICATION, $workId, $params['new_dir'], api_float_val($params['weight']), api_float_val($params['qualification']), $params['description'], 1, api_get_session_id() ); } else { GradebookUtils::updateResourceFromCourseGradebook( $linkId, $courseInfo['code'], $params['weight'] ); } } else { // Delete everything of the gradebook for this $linkId GradebookUtils::remove_resource_from_course_gradebook($linkId); } } } /** * Delete all work by student. * * @param int $userId * @param array $courseInfo * * @return array return deleted items */ function deleteAllWorkPerUser($userId, $courseInfo) { $deletedItems = []; $workPerUser = getWorkPerUser($userId); if (!empty($workPerUser)) { foreach ($workPerUser as $work) { $work = $work['work']; foreach ($work->user_results as $userResult) { $result = deleteWorkItem($userResult['id'], $courseInfo); if ($result) { $deletedItems[] = $userResult; } } } } return $deletedItems; } /** * @param int $item_id * @param array course info * * @return bool */ function deleteWorkItem($item_id, $courseInfo) { $item_id = (int) $item_id; if (empty($item_id) || empty($courseInfo)) { return false; } $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $TSTDPUBASG = Database::get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT); $currentCourseRepositorySys = api_get_path(SYS_COURSE_PATH).$courseInfo['path'].'/'; $is_allowed_to_edit = api_is_allowed_to_edit(); $file_deleted = false; $is_author = user_is_author($item_id); $work_data = get_work_data_by_id($item_id); $locked = api_resource_is_locked_by_gradebook($work_data['parent_id'], LINK_STUDENTPUBLICATION); $course_id = $courseInfo['real_id']; if (($is_allowed_to_edit && $locked == false) || ( $locked == false && $is_author && api_get_course_setting('student_delete_own_publication') == 1 && $work_data['qualificator_id'] == 0 ) ) { // We found the current user is the author $sql = "SELECT url, contains_file, user_id, session_id, parent_id FROM $work_table WHERE c_id = $course_id AND id = $item_id"; $result = Database::query($sql); $row = Database::fetch_array($result); $count = Database::num_rows($result); if ($count > 0) { // If the "considered_working_time" option is enabled, check // whether some time should be removed from track_e_course_access $consideredWorkingTime = api_get_configuration_value('considered_working_time'); if ($consideredWorkingTime) { $userWorks = get_work_user_list( 0, 100, null, null, $row['parent_id'], null, $row['user_id'], false, $course_id, $row['session_id'] ); // We're only interested in deleting the time if this is the latest work sent if (count($userWorks) == 1) { // Get the "considered work time" defined for this work $fieldValue = new ExtraFieldValue('work'); $resultExtra = $fieldValue->getAllValuesForAnItem( $row['parent_id'], true ); $workingTime = null; foreach ($resultExtra as $field) { $field = $field['value']; if ($consideredWorkingTime == $field->getField()->getVariable()) { $workingTime = $field->getValue(); } } // If no time was defined, or a time of "0" was set, do nothing if (!empty($workingTime)) { $sessionId = empty($row['session_id']) ? 0 : $row['session_id']; // Getting false from the following call would mean the // time record Event::eventRemoveVirtualCourseTime( $course_id, $row['user_id'], $sessionId, $workingTime ); } } } // end of considered_working_time check section $sql = "UPDATE $work_table SET active = 2 WHERE c_id = $course_id AND id = $item_id"; Database::query($sql); $sql = "DELETE FROM $TSTDPUBASG WHERE c_id = $course_id AND publication_id = $item_id"; Database::query($sql); Compilatio::plagiarismDeleteDoc($course_id, $item_id); api_item_property_update( $courseInfo, 'work', $item_id, 'DocumentDeleted', api_get_user_id() ); Event::addEvent( LOG_WORK_FILE_DELETE, LOG_WORK_DATA, [ 'id' => $work_data['id'], 'url' => $work_data['url'], 'title' => $work_data['title'], ], null, api_get_user_id(), api_get_course_int_id(), api_get_session_id() ); $work = $row['url']; if ($row['contains_file'] == 1) { if (!empty($work)) { if (api_get_setting('permanently_remove_deleted_files') === 'true') { my_delete($currentCourseRepositorySys.'/'.$work); $file_deleted = true; } else { $extension = pathinfo($work, PATHINFO_EXTENSION); $new_dir = $work.'_DELETED_'.$item_id.'.'.$extension; if (file_exists($currentCourseRepositorySys.'/'.$work)) { rename($currentCourseRepositorySys.'/'.$work, $currentCourseRepositorySys.'/'.$new_dir); $file_deleted = true; } } } } else { $file_deleted = true; } } } return $file_deleted; } /** * @param FormValidator $form * @param array $defaults * @param int $workId * * @return FormValidator */ function getFormWork($form, $defaults = [], $workId = 0) { $sessionId = api_get_session_id(); if (!empty($defaults)) { if (isset($defaults['submit'])) { unset($defaults['submit']); } } // Create the form that asks for the directory name $form->addText('new_dir', get_lang('Assignment name')); $form->addHtmlEditor( 'description', get_lang('Description'), false, false, getWorkDescriptionToolbar() ); $form->addButtonAdvancedSettings('advanced_params', get_lang('Advanced settings')); if (!empty($defaults) && (isset($defaults['enableEndDate']) || isset($defaults['enableExpiryDate']))) { $form->addHtml('

'); } else { $form->addHtml('

'); } // ScoreOfAssignment $form->addElement('text', 'qualification', get_lang('ScoreNumeric')); if (($sessionId != 0 && Gradebook::is_active()) || $sessionId == 0) { $form->addElement( 'checkbox', 'make_calification', null, get_lang('Add to gradebook'), [ 'id' => 'make_calification_id', 'onclick' => "javascript: if(this.checked) { document.getElementById('option1').style.display='block';}else{document.getElementById('option1').style.display='none';}", ] ); } else { // QualificationOfAssignment $form->addElement('hidden', 'make_calification', false); } if (!empty($defaults) && isset($defaults['category_id'])) { $form->addHtml('

'); } else { $form->addHtml(''); $form->addElement('checkbox', 'enableExpiryDate', null, get_lang('Enable handing over deadline (visible to learners)'), 'id="expiry_date"'); if (isset($defaults['enableExpiryDate']) && $defaults['enableExpiryDate']) { $form->addHtml('

'); } else { $form->addHtml(''); $form->addElement('checkbox', 'enableEndDate', null, get_lang('Enable final acceptance date (invisible to learners)'), 'id="end_date"'); if (!isset($defaults['ends_on'])) { $nextDay = substr(api_get_local_time($timeNextWeek + 86400), 0, 10); $date = substr($nextDay, 0, 10); $defaults['ends_on'] = $date.' 23:59'; } if (isset($defaults['enableEndDate']) && $defaults['enableEndDate']) { $form->addHtml('

'); } else { $form->addHtml(''); $form->addElement('checkbox', 'add_to_calendar', null, get_lang('Add to calendar')); $form->addElement('select', 'allow_text_assignment', get_lang('Document type'), getUploadDocumentType()); // Extra fields $extraField = new ExtraField('work'); $extra = $extraField->addElements($form, $workId); $htmlHeadXtra[] = ' '; $form->addHtml('

'); $skillList = Skill::addSkillsToForm($form, ITEM_TYPE_STUDENT_PUBLICATION, $workId); if (!empty($defaults)) { $defaults['skills'] = array_keys($skillList); $form->setDefaults($defaults); } return $form; } /** * @return array */ function getUploadDocumentType() { return [ 0 => get_lang('Allow files or online text'), 1 => get_lang('Allow only text'), 2 => get_lang('Allow only files'), ]; } /** * @param int $itemId * @param array $course_info * * @return bool */ function makeVisible($itemId, $course_info) { $itemId = (int) $itemId; if (empty($course_info) || empty($itemId)) { return false; } $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $course_id = $course_info['real_id']; $sql = "UPDATE $work_table SET accepted = 1 WHERE c_id = $course_id AND id = $itemId"; Database::query($sql); api_item_property_update($course_info, 'work', $itemId, 'visible', api_get_user_id()); return true; } /** * @param int $itemId * @param array $course_info * * @return int */ function makeInvisible($itemId, $course_info) { $itemId = (int) $itemId; if (empty($course_info) || empty($itemId)) { return false; } $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $course_id = $course_info['real_id']; $sql = "UPDATE $table SET accepted = 0 WHERE c_id = $course_id AND id = '".$itemId."'"; Database::query($sql); api_item_property_update( $course_info, 'work', $itemId, 'invisible', api_get_user_id() ); return true; } /** * @param int $item_id * @param string $path * @param array $courseInfo * @param int $groupId iid * @param int $sessionId * * @return string */ function generateMoveForm($item_id, $path, $courseInfo, $groupId, $sessionId) { $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $courseId = $courseInfo['real_id']; $folders = []; $session_id = (int) $sessionId; $groupId = (int) $groupId; $sessionCondition = empty($sessionId) ? ' AND (session_id = 0 OR session_id IS NULL) ' : " AND session_id='".$session_id."'"; $groupIid = 0; if ($groupId) { $groupInfo = GroupManager::get_group_properties($groupId); $groupIid = $groupInfo['iid']; } $sql = "SELECT id, url, title FROM $work_table WHERE c_id = $courseId AND active IN (0, 1) AND url LIKE '/%' AND post_group_id = $groupIid $sessionCondition"; $res = Database::query($sql); while ($folder = Database::fetch_array($res)) { $title = empty($folder['title']) ? basename($folder['url']) : $folder['title']; $folders[$folder['id']] = $title; } return build_work_move_to_selector($folders, $path, $item_id); } /** * @param int $workId * * @return string */ function showStudentList($workId) { $columnModel = [ [ 'name' => 'student', 'index' => 'student', 'width' => '350px', 'align' => 'left', 'sortable' => 'false', ], [ 'name' => 'works', 'index' => 'works', 'align' => 'center', 'sortable' => 'false', ], ]; $token = null; $url = api_get_path(WEB_AJAX_PATH).'model.ajax.php?a=get_work_student_list_overview&work_id='.$workId.'&'.api_get_cidreq(); $columns = [ get_lang('Learners'), get_lang('Assignments'), ]; $order = api_is_western_name_order() ? 'firstname' : 'lastname'; $params = [ 'autowidth' => 'true', 'height' => 'auto', 'rowNum' => 5, 'sortname' => $order, 'sortorder' => 'asc', ]; $html = ''; $html .= Display::grid_html('studentList'); return $html; } /** * @param string $courseCode * @param int $sessionId * @param int $groupId * @param int $start * @param int $limit * @param string $sidx * @param string $sord * @param $getCount * * @return array|int */ function getWorkUserList($courseCode, $sessionId, $groupId, $start, $limit, $sidx, $sord, $getCount = false) { if (!empty($groupId)) { $userList = GroupManager::get_users( $groupId, false, $start, $limit, $getCount, null, $sidx, $sord ); } else { $limitString = null; if (!empty($start) && !empty($limit)) { $start = intval($start); $limit = intval($limit); $limitString = " LIMIT $start, $limit"; } $orderBy = null; if (!empty($sidx) && !empty($sord)) { if (in_array($sidx, ['firstname', 'lastname'])) { $orderBy = "ORDER BY $sidx $sord"; } } if (empty($sessionId)) { $userList = CourseManager::get_user_list_from_course_code( $courseCode, $sessionId, $limitString, $orderBy, STUDENT, $getCount ); } else { $userList = CourseManager::get_user_list_from_course_code( $courseCode, $sessionId, $limitString, $orderBy, 0, $getCount ); } if ($getCount == false) { $userList = array_keys($userList); } } return $userList; } /** * @param int $workId * @param string $courseCode * @param int $sessionId * @param int $groupId * @param int $start * @param int $limit * @param int $sidx * @param string $sord * @param bool $getCount * * @return array|int */ function getWorkUserListData( $workId, $courseCode, $sessionId, $groupId, $start, $limit, $sidx, $sord, $getCount = false ) { $my_folder_data = get_work_data_by_id($workId); $workParents = []; if (empty($my_folder_data)) { $workParents = getWorkList($workId, $my_folder_data, null); } $workIdList = []; if (!empty($workParents)) { foreach ($workParents as $work) { $workIdList[] = $work->id; } } $courseInfo = api_get_course_info($courseCode); $userList = getWorkUserList( $courseCode, $sessionId, $groupId, $start, $limit, $sidx, $sord, $getCount ); if ($getCount) { return $userList; } $results = []; if (!empty($userList)) { foreach ($userList as $userId) { $user = api_get_user_info($userId); $link = api_get_path(WEB_CODE_PATH).'work/student_work.php?'.api_get_cidreq().'&studentId='.$user['user_id']; $url = Display::url(api_get_person_name($user['firstname'], $user['lastname']), $link); $userWorks = 0; if (!empty($workIdList)) { $userWorks = getUniqueStudentAttempts( $workIdList, $groupId, $courseInfo['real_id'], $sessionId, $user['user_id'] ); } $works = $userWorks." / ".count($workParents); $results[] = [ 'student' => $url, 'works' => Display::url($works, $link), ]; } } return $results; } /** * @param int $id * @param array $course_info * @param bool $isCorrection * * @return bool */ function downloadFile($id, $course_info, $isCorrection) { return getFile($id, $course_info, true, $isCorrection, true); } /** * @param int $id * @param array $course_info * @param bool $download * @param bool $isCorrection * @param bool $forceAccessForCourseAdmins * * @return bool */ function getFile($id, $course_info, $download = true, $isCorrection = false, $forceAccessForCourseAdmins = false) { $file = getFileContents($id, $course_info, 0, $isCorrection, $forceAccessForCourseAdmins); if (!empty($file) && is_array($file)) { return DocumentManager::file_send_for_download( $file['path'], $download, $file['title'] ); } return false; } /** * Get the file contents for an assigment. * * @param int $id * @param array $courseInfo * @param int $sessionId * @param bool $correction * @param bool $forceAccessForCourseAdmins * * @return array|bool */ function getFileContents($id, $courseInfo, $sessionId = 0, $correction = false, $forceAccessForCourseAdmins = false) { $id = (int) $id; if (empty($courseInfo) || empty($id)) { return false; } if (empty($sessionId)) { $sessionId = api_get_session_id(); } $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); if (!empty($courseInfo['real_id'])) { $sql = "SELECT * FROM $table WHERE c_id = ".$courseInfo['real_id']." AND id = $id"; $result = Database::query($sql); if ($result && Database::num_rows($result)) { $row = Database::fetch_array($result, 'ASSOC'); if ($correction) { $row['url'] = $row['url_correction']; } if (empty($row['url'])) { return false; } $full_file_name = api_get_path(SYS_COURSE_PATH).api_get_course_path().'/'.$row['url']; $item_info = api_get_item_property_info( api_get_course_int_id(), 'work', $row['id'], $sessionId ); if (empty($item_info)) { return false; } $isAllow = allowOnlySubscribedUser( api_get_user_id(), $row['parent_id'], $courseInfo['real_id'], $forceAccessForCourseAdmins ); if (empty($isAllow)) { return false; } /* field show_score in table course : 0 => New documents are visible for all users 1 => New documents are only visible for the teacher(s) field visibility in table item_property : 0 => eye closed, invisible for all students 1 => eye open field accepted in table c_student_publication : 0 => eye closed, invisible for all students 1 => eye open ( We should have visibility == accepted, otherwise there is an inconsistency in the Database) field value in table c_course_setting : 0 => Allow learners to delete their own publications = NO 1 => Allow learners to delete their own publications = YES +------------------+-------------------------+------------------------+ |Can download work?| doc visible for all = 0 | doc visible for all = 1| +------------------+-------------------------+------------------------+ | visibility = 0 | editor only | editor only | | | | | +------------------+-------------------------+------------------------+ | visibility = 1 | editor | editor | | | + owner of the work | + any student | +------------------+-------------------------+------------------------+ (editor = teacher + admin + anybody with right api_is_allowed_to_edit) */ $work_is_visible = $item_info['visibility'] == 1 && $row['accepted'] == 1; $doc_visible_for_all = (int) $courseInfo['show_score'] === 0; $is_editor = api_is_allowed_to_edit(true, true, true); $student_is_owner_of_work = user_is_author($row['id'], api_get_user_id()); if (($forceAccessForCourseAdmins && $isAllow) || $is_editor || $student_is_owner_of_work || ($doc_visible_for_all && $work_is_visible) ) { $title = $row['title']; if ($correction) { $title = $row['title_correction']; } if (array_key_exists('filename', $row) && !empty($row['filename'])) { $title = $row['filename']; } $title = str_replace(' ', '_', $title); if ($correction == false) { $userInfo = api_get_user_info($row['user_id']); if ($userInfo) { $date = api_get_local_time($row['sent_date']); $date = str_replace([':', '-', ' '], '_', $date); $title = $date.'_'.$userInfo['username'].'_'.$title; } } if (Security::check_abs_path( $full_file_name, api_get_path(SYS_COURSE_PATH).api_get_course_path().'/' )) { Event::event_download($title); return [ 'path' => $full_file_name, 'title' => $title, 'title_correction' => $row['title_correction'], ]; } } } } return false; } /** * @param int $userId * @param array $courseInfo * @param string $format * * @return bool */ function exportAllWork($userId, $courseInfo, $format = 'pdf') { $userInfo = api_get_user_info($userId); if (empty($userInfo) || empty($courseInfo)) { return false; } $workPerUser = getWorkPerUser($userId); switch ($format) { case 'pdf': if (!empty($workPerUser)) { $pdf = new PDF(); $content = null; foreach ($workPerUser as $work) { $work = $work['work']; foreach ($work->user_results as $userResult) { $content .= $userResult['title']; // No need to use api_get_local_time() $content .= $userResult['sent_date']; $content .= $userResult['qualification']; $content .= $userResult['description']; } } if (!empty($content)) { $pdf->content_to_pdf( $content, null, api_replace_dangerous_char($userInfo['complete_name']), $courseInfo['code'] ); } } break; } } /** * @param int $workId * @param array $courseInfo * @param int $sessionId * @param string $format * * @return bool */ function exportAllStudentWorkFromPublication( $workId, $courseInfo, $sessionId, $format = 'pdf' ) { if (empty($courseInfo)) { return false; } $workData = get_work_data_by_id($workId); if (empty($workData)) { return false; } $assignment = get_work_assignment_by_id($workId); $courseCode = $courseInfo['code']; $header = get_lang('Course').': '.$courseInfo['title']; $teachers = CourseManager::getTeacherListFromCourseCodeToString( $courseCode ); if (!empty($sessionId)) { $sessionInfo = api_get_session_info($sessionId); if (!empty($sessionInfo)) { $header .= ' - '.$sessionInfo['name']; $header .= '
'.$sessionInfo['description']; $teachers = SessionManager::getCoachesByCourseSessionToString( $sessionId, $courseInfo['real_id'] ); } } $header .= '
'.get_lang('Trainers').': '.$teachers.'
'; $header .= '
'.get_lang('Date').': '.api_get_local_time().'
'; $header .= '
'.get_lang('Assignment name').': '.$workData['title'].'
'; $content = null; $expiresOn = null; if (!empty($assignment) && isset($assignment['expires_on'])) { $content .= '
'.get_lang('Posted deadline for sending the work (Visible to the learner)').': '.api_get_local_time($assignment['expires_on']); $expiresOn = api_get_local_time($assignment['expires_on']); } if (!empty($workData['description'])) { $content .= '
'.get_lang('Description').': '.$workData['description']; } $workList = get_work_user_list(null, null, null, null, $workId); switch ($format) { case 'pdf': if (!empty($workList)) { $table = new HTML_Table(['class' => 'data_table']); $headers = [ get_lang('Name'), get_lang('User'), get_lang('Deadline'), get_lang('Sent date'), get_lang('Filename'), get_lang('Score'), get_lang('Feedback'), ]; $column = 0; foreach ($headers as $header) { $table->setHeaderContents(0, $column, $header); $column++; } $row = 1; //$pdf->set_custom_header($header); foreach ($workList as $work) { $content .= '

'; // getWorkComments need c_id $work['c_id'] = $courseInfo['real_id']; //$content .= get_lang('Date').': '.api_get_local_time($work['sent_date_from_db']).'
'; $score = null; if (!empty($work['qualification_only'])) { $score = $work['qualification_only']; } $comments = getWorkComments($work); $feedback = null; if (!empty($comments)) { $content .= '

'.get_lang('Feedback').':

'; foreach ($comments as $comment) { $feedback .= get_lang('User').': '.$comment['complete_name']. '
'; $feedback .= $comment['comment'].'
'; } } $table->setCellContents($row, 0, strip_tags($workData['title'])); $table->setCellContents($row, 1, strip_tags($work['fullname'])); $table->setCellContents($row, 2, $expiresOn); $table->setCellContents($row, 3, api_get_local_time($work['sent_date_from_db'])); $table->setCellContents($row, 4, strip_tags($work['title'])); $table->setCellContents($row, 5, $score); $table->setCellContents($row, 6, $feedback); $row++; } $content = $table->toHtml(); if (!empty($content)) { $params = [ 'filename' => $workData['title'].'_'.api_get_local_time(), 'pdf_title' => api_replace_dangerous_char($workData['title']), 'course_code' => $courseInfo['code'], ]; $pdf = new PDF('A4', null, $params); $pdf->html_to_pdf_with_template($content); } exit; } break; } } /** * Downloads all user files per user. * * @param int $userId * @param array $courseInfo * * @return bool */ function downloadAllFilesPerUser($userId, $courseInfo) { $userInfo = api_get_user_info($userId); if (empty($userInfo) || empty($courseInfo)) { return false; } $tempZipFile = api_get_path(SYS_ARCHIVE_PATH).api_get_unique_id().".zip"; $coursePath = api_get_path(SYS_COURSE_PATH).$courseInfo['path'].'/work/'; $zip = new PclZip($tempZipFile); $workPerUser = getWorkPerUser($userId); if (!empty($workPerUser)) { $files = []; foreach ($workPerUser as $work) { $work = $work['work']; foreach ($work->user_results as $userResult) { if (empty($userResult['url']) || empty($userResult['contains_file'])) { continue; } $data = getFileContents($userResult['id'], $courseInfo); if (!empty($data) && isset($data['path'])) { $files[basename($data['path'])] = [ 'title' => $data['title'], 'path' => $data['path'], ]; } } } if (!empty($files)) { Session::write('files', $files); foreach ($files as $data) { $zip->add( $data['path'], PCLZIP_OPT_REMOVE_PATH, $coursePath, PCLZIP_CB_PRE_ADD, 'preAddAllWorkStudentCallback' ); } } // Start download of created file $name = basename(api_replace_dangerous_char($userInfo['complete_name'])).'.zip'; Event::event_download($name.'.zip (folder)'); if (Security::check_abs_path($tempZipFile, api_get_path(SYS_ARCHIVE_PATH))) { DocumentManager::file_send_for_download($tempZipFile, true, $name); @unlink($tempZipFile); exit; } } exit; } /** * @param $p_event * @param array $p_header * * @return int */ function preAddAllWorkStudentCallback($p_event, &$p_header) { $files = Session::read('files'); if (isset($files[basename($p_header['stored_filename'])])) { $p_header['stored_filename'] = $files[basename($p_header['stored_filename'])]['title']; return 1; } return 0; } /** * Get all work created by a user. * * @param int $user_id * @param int $courseId * @param int $sessionId * * @return array */ function getWorkCreatedByUser($user_id, $courseId, $sessionId) { $items = api_get_item_property_list_by_tool_by_user( $user_id, 'work', $courseId, $sessionId ); $list = []; if (!empty($items)) { foreach ($items as $work) { $item = get_work_data_by_id( $work['ref'], $courseId, $sessionId ); if (!empty($item)) { $list[] = [ $item['title'], api_get_local_time($work['insert_date']), api_get_local_time($work['lastedit_date']), ]; } } } return $list; } /** * @param array $courseInfo * @param int $workId * * @return bool */ function protectWork($courseInfo, $workId) { $userId = api_get_user_id(); $groupId = api_get_group_id(); $sessionId = api_get_session_id(); $workData = get_work_data_by_id($workId); if (empty($workData) || empty($courseInfo)) { api_not_allowed(true); } if (api_is_platform_admin() || api_is_allowed_to_edit()) { return true; } $workId = $workData['id']; if ($workData['active'] != 1) { api_not_allowed(true); } $visibility = api_get_item_visibility($courseInfo, 'work', $workId, $sessionId); if ($visibility != 1) { api_not_allowed(true); } $isAllow = allowOnlySubscribedUser($userId, $workId, $courseInfo['real_id']); if (empty($isAllow)) { api_not_allowed(true); } $groupInfo = GroupManager::get_group_properties($groupId); if (!empty($groupId)) { $showWork = GroupManager::user_has_access( $userId, $groupInfo['iid'], GroupManager::GROUP_TOOL_WORK ); if (!$showWork) { api_not_allowed(true); } } } /** * @param array $courseInfo * @param array $work */ function deleteCorrection($courseInfo, $work) { if (isset($work['url_correction']) && !empty($work['url_correction']) && isset($work['iid'])) { $id = $work['iid']; $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $sql = "UPDATE $table SET url_correction = '', title_correction = '' WHERE iid = $id"; Database::query($sql); $coursePath = api_get_path(SYS_COURSE_PATH).$courseInfo['path'].'/'; if (file_exists($coursePath.$work['url_correction'])) { if (Security::check_abs_path($coursePath.$work['url_correction'], $coursePath)) { unlink($coursePath.$work['url_correction']); } } } } /** * @param int $workId * * @return string */ function workGetExtraFieldData($workId) { $sessionField = new ExtraField('work'); $extraFieldData = $sessionField->getDataAndFormattedValues($workId); $result = ''; if (!empty($extraFieldData)) { $result .= '

'; foreach ($extraFieldData as $data) { $result .= $data['text'].': '.$data['value'].''; } $result .= '

'; } return $result; }