Category::getUrl(), 'name' => get_lang('Gradebook'), ]; //load the evaluation & category $select_eval = (int) $_GET['selecteval']; if (empty($select_eval)) { api_not_allowed(); } $displayscore = ScoreDisplay::instance(); $eval = Evaluation::load($select_eval); $overwritescore = 0; if ($eval[0]->get_category_id() < 0) { // if category id is negative, then the evaluation's origin is a link $link = LinkFactory::get_evaluation_link($eval[0]->get_id()); $currentcat = Category::load($link->get_category_id()); } else { $currentcat = Category::load($eval[0]->get_category_id()); } //load the result with the evaluation id if (isset($_GET['delete_mark'])) { $result = Result::load($_GET['delete_mark']); if (!empty($result[0])) { $result[0]->delete(); } } if (isset($_GET['selecteval'])) { $allresults = Result :: load(null, null, $select_eval); $iscourse = !empty(api_get_course_id()); } $allowMultipleAttempts = api_get_configuration_value('gradebook_multiple_evaluation_attempts'); if (isset($_GET['action'])) { switch ($_GET['action']) { case 'delete_attempt': $result = Result::load($_GET['editres']); if ($allowMultipleAttempts && !empty($result) && isset($result[0]) && api_is_allowed_to_edit()) { /** @var Result $result */ $result = $result[0]; $url = api_get_self().'?selecteval='.$select_eval.'&'.api_get_cidreq().'&editres='.$result->get_id(); $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_RESULT_ATTEMPT); if (isset($_GET['result_attempt_id'])) { $attemptId = (int) $_GET['result_attempt_id']; $sql = "DELETE FROM $table WHERE result_id = ".$result->get_id()." AND id = $attemptId"; Database::query($sql); Display::addFlash(Display::return_message(get_lang('Deleted'))); } header('Location: '.$url.'&action=add_attempt'); exit; } break; case 'add_attempt': $result = Result::load($_GET['editres']); if ($allowMultipleAttempts && !empty($result) && isset($result[0]) && api_is_allowed_to_edit()) { /** @var Result $result */ $result = $result[0]; $backUrl = api_get_self().'?selecteval='.$select_eval.'&'.api_get_cidreq(); $interbreadcrumb[] = [ 'url' => $backUrl, 'name' => get_lang('Details'), ]; /** @var Evaluation $evaluation */ $evaluation = $eval[0]; $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_RESULT_ATTEMPT); $now = api_get_utc_datetime(); $url = api_get_self().'?selecteval='.$select_eval.'&'.api_get_cidreq().'&editres='.$result->get_id(); $form = new FormValidator('attempt', 'post', $url.'&action=add_attempt'); $form->addHeader(get_lang('AddResult')); $form->addLabel(get_lang('CurrentScore'), $result->get_score()); $form->addFloat( 'score', [ get_lang('Score'), null, '/ '.$evaluation->get_max(), ], true, [ 'size' => '4', 'maxlength' => '5', ], false, 0, $evaluation->get_max() ); $form->addTextarea('comment', get_lang('Comment')); $form->addButtonSave(get_lang('Save')); $attemptList = ResultTable::getResultAttemptTable($result, $url); $form->addLabel(get_lang('Attempts'), $attemptList); if ($form->validate()) { $values = $form->getSubmitValues(); $newScore = $values['score']; $newScore = api_number_format( $newScore, api_get_setting('gradebook_number_decimals') ); $params = [ 'result_id' => $result->get_id(), 'score' => $newScore, 'comment' => $values['comment'], 'created_at' => $now, 'updated_at' => $now, ]; Database::insert($table, $params); if ($newScore > $result->get_score()) { $result->set_score($newScore); $result->save(); } Display::addFlash(Display::return_message(get_lang('Saved'))); header('Location: '.api_get_self().'?selecteval='.$select_eval.'&'.api_get_cidreq()); exit; } Display::display_header(); $items[] = [ 'url' => $backUrl, 'content' => Display::return_icon( 'back.png', get_lang('Back'), [], ICON_SIZE_MEDIUM ), ]; echo Display::actions($items); $form->display(); Display::display_footer(); exit; } break; } } if (isset($_GET['editres'])) { $edit_res_xml = Security::remove_XSS($_GET['editres']); $resultedit = Result::load($edit_res_xml); $edit_res_form = new EvalForm( EvalForm::TYPE_RESULT_EDIT, $eval[0], $resultedit[0], 'edit_result_form', null, api_get_self().'?editres='.$resultedit[0]->get_id().'&selecteval='.$select_eval.'&'.api_get_cidreq() ); if ($edit_res_form->validate()) { $values = $edit_res_form->exportValues(); $result = new Result(); $resultlog = new Result(); $resultlog->addResultLog($values['hid_user_id'], $select_eval); $result->set_id($edit_res_xml); $result->set_user_id($values['hid_user_id']); $result->set_evaluation_id($select_eval); $row_value = isset($values['score']) ? $values['score'] : 0; if (!empty($row_value) || $row_value == 0) { $row_value = api_number_format( $row_value, api_get_setting('gradebook_number_decimals') ); $result->set_score($row_value); } $result->save(); if ($allowMultipleAttempts && !empty($result->get_id())) { $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_RESULT_ATTEMPT); $now = api_get_utc_datetime(); $params = [ 'result_id' => $result->get_id(), 'score' => $row_value, 'comment' => $values['comment'], 'created_at' => $now, 'updated_at' => $now, ]; Database::insert($table, $params); } Display::addFlash(Display::return_message(get_lang('ResultEdited'), 'normal', false)); header('Location: gradebook_view_result.php?selecteval='.$select_eval.'&editresmessage=&'.api_get_cidreq()); exit; } } $file_type = null; if (isset($_GET['import'])) { $interbreadcrumb[] = [ 'url' => api_get_path(WEB_CODE_PATH).'gradebook/gradebook_view_result.php?selecteval='.$select_eval.'&'.api_get_cidreq(), 'name' => get_lang('ViewResult'), ]; $import_result_form = new DataForm( DataForm::TYPE_IMPORT, 'import_result_form', null, api_get_self().'?import=&selecteval='.$select_eval, '_blank', '' ); if (!$import_result_form->validate()) { Display :: display_header(get_lang('Import')); } $eval[0]->check_lock_permissions(); if (isset($_POST['formSent']) && $_POST['formSent']) { if (!empty($_FILES['import_file']['name'])) { $values = $import_result_form->exportValues(); $file_type = $_POST['file_type']; $file_name = $_FILES['import_file']['tmp_name']; $results = Import :: csvToArray($file_name); $nr_results_added = 0; foreach ($results as $index => $importedresult) { //check username & score $importedresult['user_id'] = UserManager::get_user_id_from_username($importedresult['username']); $added = '0'; foreach ($allresults as $allresult) { if (($importedresult['user_id'] == $allresult->get_user_id())) { if ($importedresult['score'] != $allresult->get_score()) { if (!isset($values['overwrite'])) { header('Location: '.api_get_path(WEB_CODE_PATH).'gradebook/gradebook_view_result.php?selecteval='.$select_eval.'&import_score_error='.$importedresult['user_id']); exit; break; } else { GradebookUtils::overwritescore( $allresult->get_id(), $importedresult['score'], $eval[0]->get_max() ); $overwritescore++; $added = '1'; } } else { $added = '1'; } } } if ($importedresult['user_id'] == null) { header('Location: gradebook_view_result.php?selecteval='.$select_eval.'&incorrectdata='); exit; } $userinfo = api_get_user_info($importedresult['user_id']); if ($userinfo['lastname'] != $importedresult['lastname'] || $userinfo['firstname'] != $importedresult['firstname'] || $userinfo['official_code'] != $importedresult['official_code'] ) { if (!isset($values['ignoreerrors'])) { header('Location: gradebook_view_result.php?selecteval='.$select_eval.'&import_user_error='.$importedresult['user_id']); exit; } } if ($added != '1') { if ($importedresult['score'] > $eval[0]->get_max()) { header('Location: gradebook_view_result.php?selecteval='.$select_eval.'&overwritemax='); exit; } $result = new Result(); $result->set_user_id($importedresult['user_id']); if (!empty($importedresult['score'])) { $result->set_score( api_number_format($importedresult['score'], api_get_setting('gradebook_number_decimals')) ); } if (!empty($importedresult['date'])) { $result->set_date(api_get_utc_datetime($importedresult['date'])); } else { $result->set_date(api_get_utc_datetime()); } $result->set_evaluation_id($select_eval); $result->add(); $nr_results_added++; } } } else { Display::addFlash( Display::return_message( get_lang('ImportNoFile'), 'warning', false ) ); header('Location: '.api_get_self().'?import=&selecteval='.$select_eval.'&importnofile='); exit; } if ($overwritescore != 0) { Display::addFlash( Display::return_message( get_lang('ImportOverWriteScore').' '.$overwritescore ) ); header('Location: '.api_get_self().'?selecteval='.$select_eval.'&importoverwritescore='.$overwritescore); exit; } if ($nr_results_added == 0) { Display::addFlash( Display::return_message( get_lang('ProblemUploadingFile'), 'warning', false ) ); header('Location: '.api_get_self().'?selecteval='.$select_eval.'¬hingadded='); exit; } Display::addFlash( Display::return_message( get_lang('FileUploadComplete'), 'success', false ) ); header('Location: '.api_get_self().'?selecteval='.$select_eval.'&importok='); exit; } } if (isset($_GET['export'])) { $interbreadcrumb[] = [ 'url' => 'gradebook_view_result.php?selecteval='.$select_eval.'&'.api_get_cidreq(), 'name' => get_lang('ViewResult'), ]; $locked_status = $eval[0]->get_locked(); $export_result_form = new DataForm( DataForm :: TYPE_EXPORT, 'export_result_form', null, api_get_self().'?export=&selecteval='.$select_eval.'&'.api_get_cidreq(), '_blank', $locked_status ); if (!$export_result_form->validate()) { Display::display_header(get_lang('Export')); } if ($export_result_form->validate()) { $export = $export_result_form->exportValues(); $file_type = $export['file_type']; $filename = 'export_results_'.gmdate('Y-m-d_H-i-s'); $results = Result::load(null, null, $select_eval); $data = []; //when file type is csv, add a header to the output file if ($file_type == 'csv') { $alldata[] = [ 'username', 'official_code', 'lastname', 'firstname', 'score', 'date', ]; } // export results to pdf file if ($file_type == 'pdf') { $number_decimals = api_get_setting('gradebook_number_decimals'); $datagen = new ResultsDataGenerator($eval[0], $allresults); // set headers pdf !empty($_user['official_code']) ? $officialcode = $_user['official_code'].' - ' : ''; $h1 = [get_lang('Teacher'), $officialcode.$_user['firstName'].', '.$_user['lastName']]; $h2 = [get_lang('Score'), $eval[0]->get_max()]; $h3 = [get_lang('Course'), $_course['name']]; $h4 = [get_lang('Weight'), $eval[0]->get_weight()]; $h5 = [get_lang('Session'), api_get_session_name(api_get_session_id())]; $date = date('d-m-Y H:i:s', time()); $h6 = [get_lang('DateTime'), api_convert_and_format_date($date, "%d/%m/%Y %H:%M")]; $header_pdf = [$h1, $h2, $h3, $h4, $h5, $h6]; // set footer pdf $f1 = '