'); } // Loading Gradebook select GradebookUtils::load_gradebook_select_in_tool($form); $form->addElement('text', 'weight', get_lang('WeightInTheGradebook')); $form->addHtml('

'); } else { $form->addHtml(''); $form->addElement('checkbox', 'enableEndDate', null, get_lang('EnableEndDate'), '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(''); if (!empty($defaults)) { $form->setDefaults($defaults); } return $form; } /** * @return array */ function getUploadDocumentType() { return array( 0 => get_lang('AllowFileOrText'), 1 => get_lang('AllowOnlyText'), 2 => get_lang('AllowOnlyFiles') ); } /** * @param array $courseInfo * @param bool $showScore * @param bool $studentDeleteOwnPublication */ function updateSettings($courseInfo, $showScore, $studentDeleteOwnPublication) { $showScore = intval($showScore); $courseId = api_get_course_int_id(); $main_course_table = Database::get_main_table(TABLE_MAIN_COURSE); $table_course_setting = Database::get_course_table(TOOL_COURSE_SETTING); if (empty($courseId)) { return false; } $query = "UPDATE $main_course_table SET show_score = '$showScore' WHERE id = $courseId"; Database::query($query); /** * Course data are cached in session so we need to update both the database * and the session data */ $_course['show_score'] = $showScore; Session::write('_course', $courseInfo); // changing the tool setting: is a student allowed to delete his/her own document // counting the number of occurrences of this setting (if 0 => add, if 1 => update) $query = "SELECT * FROM $table_course_setting WHERE c_id = $courseId AND variable = 'student_delete_own_publication'"; $result = Database::query($query); $number_of_setting = Database::num_rows($result); if ($number_of_setting == 1) { $query = "UPDATE ".$table_course_setting." SET value='" . Database::escape_string($studentDeleteOwnPublication)."' WHERE variable = 'student_delete_own_publication' AND c_id = $courseId"; Database::query($query); } else { $params = [ 'c_id' => $courseId, 'variable' => 'student_delete_own_publication', 'value' => $studentDeleteOwnPublication, 'category' => 'work' ]; Database::insert($table_course_setting, $params); } } /** * @param int $item_id * @param array $course_info */ function makeVisible($item_id, $course_info) { $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $course_id = $course_info['real_id']; $item_id = intval($item_id); $sql = "UPDATE $work_table SET accepted = 1 WHERE c_id = $course_id AND id = $item_id"; Database::query($sql); api_item_property_update($course_info, 'work', $item_id, 'visible', api_get_user_id()); } /** * @param int $item_id * @param array $course_info */ function makeInvisible($item_id, $course_info) { $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); $item_id = intval($item_id); $course_id = $course_info['real_id']; $sql = "UPDATE ".$work_table." SET accepted = 0 WHERE c_id = $course_id AND id = '".$item_id."'"; Database::query($sql); api_item_property_update( $course_info, 'work', $item_id, 'invisible', api_get_user_id() ); } /** * @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 = array(); $session_id = intval($sessionId); $groupId = intval($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 = array( array( 'name' => 'student', 'index' => 'student', 'width' => '350px', 'align' => 'left', 'sortable' => 'false', ), array( '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 = array( get_lang('Students'), get_lang('Works') ); $order = api_is_western_name_order() ? 'firstname' : 'lastname'; $params = array( '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, array('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 = array(); if (empty($my_folder_data)) { $workParents = getWorkList($workId, $my_folder_data, null); } $workIdList = array(); 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 = array(); 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[] = array( '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); } /** * @param int $id * @param array $course_info * @param bool $download * @param bool $isCorrection * * @return bool */ function getFile($id, $course_info, $download = true, $isCorrection = false) { $file = getFileContents($id, $course_info, 0, $isCorrection); 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 $course_info * @param int Session ID * @param $correction * * @return array|bool */ function getFileContents($id, $course_info, $sessionId = 0, $correction = false) { $id = intval($id); if (empty($course_info) || empty($id)) { return false; } if (empty($sessionId)) { $sessionId = api_get_session_id(); } $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION); if (!empty($course_info['real_id'])) { $sql = 'SELECT * FROM '.$table.' WHERE c_id = '.$course_info['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; } allowOnlySubscribedUser( api_get_user_id(), $row['parent_id'], $course_info['real_id'] ); /* 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 = $course_info['show_score'] == 1; $is_editor = api_is_allowed_to_edit(true, true, true); $student_is_owner_of_work = user_is_author($row['id'], $row['user_id']); if ($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(array(':', '-', ' '), '_', $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 array( '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::get_teacher_list_from_course_code_to_string( $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('Teachers').': '.$teachers.'
'; $header .= '
'.get_lang('Date').': '.api_get_local_time().'
'; $header .= '
'.get_lang('WorkName').': '.$workData['title'].'
'; $content = null; $expiresOn = null; if (!empty($assignment) && isset($assignment['expires_on'])) { $content .= '
'.get_lang('ExpirationDate').': '.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(array('class' => 'data_table')); $headers = array( get_lang('Name'), get_lang('User'), get_lang('HandOutDateLimit'), get_lang('SentDate'), 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 = array( '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 = array(); 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'])] = array( '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 = array(); if (!empty($items)) { foreach ($items as $work) { $item = get_work_data_by_id( $work['ref'], $courseId, $sessionId ); if (!empty($item)) { $list[] = array( $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); } allowOnlySubscribedUser($userId, $workId, $courseInfo['real_id']); $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']); } } } }