jqgrid integration * Modified by hubert.borderiou (question category) * * @todo fix excel export */ require_once __DIR__.'/../inc/global.inc.php'; // Setting the tabs $this_section = SECTION_COURSES; $htmlHeadXtra[] = api_get_jqgrid_js(); $filter_user = isset($_REQUEST['filter_by_user']) ? (int) $_REQUEST['filter_by_user'] : null; $isBossOfStudent = false; if (api_is_student_boss() && !empty($filter_user)) { // Check if boss has access to user info. if (UserManager::userIsBossOfStudent(api_get_user_id(), $filter_user)) { $isBossOfStudent = true; } else { api_not_allowed(true); } } else { api_protect_course_script(true, false, true); } $limitTeacherAccess = api_get_configuration_value('limit_exercise_teacher_access'); if ($limitTeacherAccess && !api_is_platform_admin()) { api_not_allowed(true); } // including additional libraries require_once 'hotpotatoes.lib.php'; $_course = api_get_course_info(); // document path $documentPath = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document'; $origin = api_get_origin(); $is_allowedToEdit = api_is_allowed_to_edit(null, true) || api_is_drh() || api_is_student_boss() || api_is_session_admin(); $is_tutor = api_is_allowed_to_edit(true); $TBL_TRACK_EXERCISES = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES); $TBL_TRACK_ATTEMPT = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT); $TBL_TRACK_ATTEMPT_RECORDING = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT_RECORDING); $TBL_LP_ITEM_VIEW = Database::get_course_table(TABLE_LP_ITEM_VIEW); $allowCoachFeedbackExercises = api_get_setting('allow_coach_feedback_exercises') === 'true'; $course_id = api_get_course_int_id(); $exercise_id = isset($_REQUEST['exerciseId']) ? (int) $_REQUEST['exerciseId'] : 0; $locked = api_resource_is_locked_by_gradebook($exercise_id, LINK_EXERCISE); $sessionId = api_get_session_id(); if (empty($exercise_id)) { api_not_allowed(true); } $blockPage = true; if (empty($sessionId)) { if ($is_allowedToEdit) { $blockPage = false; } } else { if ($allowCoachFeedbackExercises && api_is_coach($sessionId, $course_id)) { $blockPage = false; } else { if ($is_allowedToEdit) { $blockPage = false; } } } if ($blockPage) { api_not_allowed(true); } if (!empty($exercise_id)) { $parameters['exerciseId'] = $exercise_id; } if (!empty($_GET['path'])) { $parameters['path'] = Security::remove_XSS($_GET['path']); } if (!empty($_REQUEST['export_report']) && $_REQUEST['export_report'] == '1') { if (api_is_platform_admin() || api_is_course_admin() || api_is_course_tutor() || api_is_session_general_coach() ) { $loadExtraData = false; if (isset($_REQUEST['extra_data']) && $_REQUEST['extra_data'] == 1) { $loadExtraData = true; } $includeAllUsers = false; if (isset($_REQUEST['include_all_users']) && $_REQUEST['include_all_users'] == 1 ) { $includeAllUsers = true; } $onlyBestAttempts = false; if (isset($_REQUEST['only_best_attempts']) && $_REQUEST['only_best_attempts'] == 1 ) { $onlyBestAttempts = true; } require_once 'exercise_result.class.php'; $export = new ExerciseResult(); $export->setIncludeAllUsers($includeAllUsers); $export->setOnlyBestAttempts($onlyBestAttempts); switch ($_GET['export_format']) { case 'xls': $export->exportCompleteReportXLS( $documentPath, null, $loadExtraData, null, $exercise_id ); exit; break; case 'csv': default: $export->exportCompleteReportCSV( $documentPath, null, $loadExtraData, null, $exercise_id ); exit; break; } } else { api_not_allowed(true); } } $objExerciseTmp = new Exercise(); $exerciseExists = $objExerciseTmp->read($exercise_id); //Send student email @todo move this code in a class, library if (isset($_REQUEST['comments']) && $_REQUEST['comments'] === 'update' && ($is_allowedToEdit || $is_tutor || $allowCoachFeedbackExercises) ) { // Filtered by post-condition $id = (int) $_GET['exeid']; $track_exercise_info = ExerciseLib::get_exercise_track_exercise_info($id); if (empty($track_exercise_info)) { api_not_allowed(); } $student_id = $track_exercise_info['exe_user_id']; $session_id = $track_exercise_info['session_id']; $lp_id = $track_exercise_info['orig_lp_id']; $lpItemId = $track_exercise_info['orig_lp_item_id']; $lp_item_view_id = (int) $track_exercise_info['orig_lp_item_view_id']; $exerciseId = $track_exercise_info['exe_exo_id']; $exeWeighting = $track_exercise_info['exe_weighting']; $post_content_id = []; $comments_exist = false; foreach ($_POST as $key_index => $key_value) { $my_post_info = explode('_', $key_index); $post_content_id[] = isset($my_post_info[1]) ? $my_post_info[1] : null; if ($my_post_info[0] === 'comments') { $comments_exist = true; } } $loop_in_track = $comments_exist === true ? (count($_POST) / 2) : count($_POST); if ($comments_exist === true) { $array_content_id_exe = array_slice($post_content_id, $loop_in_track); } else { $array_content_id_exe = $post_content_id; } for ($i = 0; $i < $loop_in_track; $i++) { $my_marks = isset($_POST['marks_'.$array_content_id_exe[$i]]) ? $_POST['marks_'.$array_content_id_exe[$i]] : ''; $my_comments = ''; if (isset($_POST['comments_'.$array_content_id_exe[$i]])) { $my_comments = $_POST['comments_'.$array_content_id_exe[$i]]; } $my_questionid = (int) $array_content_id_exe[$i]; $params = [ 'marks' => $my_marks, 'teacher_comment' => $my_comments, ]; Database::update( $TBL_TRACK_ATTEMPT, $params, ['question_id = ? AND exe_id = ?' => [$my_questionid, $id]] ); $params = [ 'exe_id' => $id, 'question_id' => $my_questionid, 'marks' => $my_marks, 'insert_date' => api_get_utc_datetime(), 'author' => api_get_user_id(), 'teacher_comment' => $my_comments, ]; Database::insert($TBL_TRACK_ATTEMPT_RECORDING, $params); } $useEvaluationPlugin = false; $pluginEvaluation = QuestionOptionsEvaluationPlugin::create(); if ('true' === $pluginEvaluation->get(QuestionOptionsEvaluationPlugin::SETTING_ENABLE)) { $formula = $pluginEvaluation->getFormulaForExercise($exerciseId); if (!empty($formula)) { $useEvaluationPlugin = true; } } if (!$useEvaluationPlugin) { $qry = 'SELECT DISTINCT question_id, marks FROM '.$TBL_TRACK_ATTEMPT.' WHERE exe_id = '.$id.' GROUP BY question_id'; $res = Database::query($qry); $tot = 0; while ($row = Database :: fetch_array($res, 'ASSOC')) { $tot += $row['marks']; } } else { $tot = $pluginEvaluation->getResultWithFormula($id, $formula); } $sql = "UPDATE $TBL_TRACK_EXERCISES SET score = '".floatval($tot)."' WHERE exe_id = ".$id; Database::query($sql); if (isset($_POST['send_notification'])) { //@todo move this somewhere else $subject = get_lang('Examsheet viewed/corrected/commented by the trainer'); $message = isset($_POST['notification_content']) ? $_POST['notification_content'] : ''; MessageManager::send_message_simple( $student_id, $subject, $message, api_get_user_id() ); if ($allowCoachFeedbackExercises) { Display::addFlash( Display::return_message(get_lang('Message Sent')) ); header('Location: '.api_get_self().'?'.api_get_cidreq().'&exerciseId='.$exerciseId); exit; } } // Updating LP score here if (!empty($lp_id) && !empty($lpItemId)) { $statusCondition = ''; $item = new learnpathItem($lpItemId, api_get_user_id(), api_get_course_int_id()); if ($item) { $prereqId = $item->get_prereq_string(); $minScore = $item->getPrerequisiteMinScore(); $maxScore = $item->getPrerequisiteMaxScore(); $passed = false; $lp = new learnpath(api_get_course_id(), $lp_id, $student_id); $prereqCheck = $lp->prerequisites_match($lpItemId); if ($prereqCheck) { $passed = true; } if ($passed === false) { if (!empty($objExerciseTmp->pass_percentage)) { $passed = ExerciseLib::isSuccessExerciseResult( $tot, $exeWeighting, $objExerciseTmp->pass_percentage ); } else { $passed = false; } } if ($passed) { $statusCondition = ', status = "completed" '; } else { $statusCondition = ', status = "failed" '; } Display::addFlash(Display::return_message(get_lang('Learning path updated'))); } $sql = "UPDATE $TBL_LP_ITEM_VIEW SET score = '".floatval($tot)."' $statusCondition WHERE c_id = ".$course_id." AND id = ".$lp_item_view_id; Database::query($sql); if (empty($origin)) { header('Location: '.api_get_path(WEB_CODE_PATH).'exercise/exercise_report.php?exerciseId='.$exercise_id.'&'.api_get_cidreq()); exit; } if ($origin === 'tracking_course') { //Redirect to the course detail in lp header('Location: '.api_get_path(WEB_CODE_PATH).'exercise/exercise.php?course='.Security::remove_XSS($_GET['course'])); exit; } else { // Redirect to the reporting header( 'Location: '.api_get_path(WEB_CODE_PATH).'mySpace/myStudents.php?origin='.$origin.'&student='.$student_id.'&details=true&course='.api_get_course_id( ).'&session_id='.$session_id ); exit; } } } $actions = null; if ($is_allowedToEdit && $origin != 'learnpath') { // the form if (api_is_platform_admin() || api_is_course_admin() || api_is_course_tutor() || api_is_session_general_coach() ) { $actions .= ''. Display::return_icon('back.png', get_lang('Go back to the questions list'), '', ICON_SIZE_MEDIUM).''; $actions .= ''. Display::return_icon('activity_monitor.png', get_lang('Live results'), '', ICON_SIZE_MEDIUM).''; $actions .= ''. Display::return_icon('statistics.png', get_lang('Report by question'), '', ICON_SIZE_MEDIUM).''; $actions .= ''. Display::return_icon('save.png', get_lang('Export'), '', ICON_SIZE_MEDIUM).''; // clean result before a selected date icon $actions .= Display::url( Display::return_icon( 'clean_before_date.png', get_lang('Clean all results before a selected date'), '', ICON_SIZE_MEDIUM ), '#', ['onclick' => 'javascript:display_date_picker()'] ); // clean result before a selected date datepicker popup $actions .= Display::span( Display::input( 'input', 'datepicker_start', get_lang('Select a date from the calendar'), [ 'onmouseover' => 'datepicker_input_mouseover()', 'id' => 'datepicker_start', 'onchange' => 'datepicker_input_changed()', 'readonly' => 'readonly', ] ). Display::button( 'delete', get_lang('Delete'), ['onclick' => 'submit_datepicker()'] ), ['style' => 'display:none', 'id' => 'datepicker_span'] ); } } else { $actions .= ''. Display::return_icon( 'back.png', get_lang('Go back to the questions list'), '', ICON_SIZE_MEDIUM ). ''; } // Deleting an attempt if (($is_allowedToEdit || $is_tutor || api_is_coach()) && isset($_GET['delete']) && $_GET['delete'] === 'delete' && !empty($_GET['did']) && $locked == false ) { $exe_id = (int) $_GET['did']; if (!empty($exe_id)) { $sql = 'DELETE FROM '.$TBL_TRACK_EXERCISES.' WHERE exe_id = '.$exe_id; Database::query($sql); $sql = 'DELETE FROM '.$TBL_TRACK_ATTEMPT.' WHERE exe_id = '.$exe_id; Database::query($sql); Event::addEvent( LOG_EXERCISE_ATTEMPT_DELETE, LOG_EXERCISE_ATTEMPT, $exe_id, api_get_utc_datetime() ); header('Location: exercise_report.php?'.api_get_cidreq().'&exerciseId='.$exercise_id); exit; } } if ($is_allowedToEdit || $is_tutor) { $interbreadcrumb[] = [ 'url' => 'exercise.php?'.api_get_cidreq(), 'name' => get_lang('Tests'), ]; $nameTools = get_lang('Learner score'); if ($exerciseExists) { $interbreadcrumb[] = [ 'url' => '#', 'name' => $objExerciseTmp->selectTitle(true), ]; } } else { $interbreadcrumb[] = [ 'url' => 'exercise.php?'.api_get_cidreq(), 'name' => get_lang('Tests'), ]; if ($exerciseExists) { $nameTools = get_lang('Results and feedback').': '.$objExerciseTmp->selectTitle(true); } } if (($is_allowedToEdit || $is_tutor || api_is_coach()) && isset($_GET['a']) && $_GET['a'] === 'close' && !empty($_GET['id']) && $locked == false ) { // Close the user attempt otherwise left pending $exe_id = (int) $_GET['id']; $sql = "UPDATE $TBL_TRACK_EXERCISES SET status = '' WHERE exe_id = $exe_id AND status = 'incomplete'"; Database::query($sql); } Display::display_header($nameTools); // Clean all results for this test before the selected date if (($is_allowedToEdit || $is_tutor || api_is_coach()) && isset($_GET['delete_before_date']) && $locked == false ) { // ask for the date $check = Security::check_token('get'); if ($check) { $objExerciseTmp = new Exercise(); if ($objExerciseTmp->read($exercise_id)) { $count = $objExerciseTmp->cleanResults( true, $_GET['delete_before_date'].' 23:59:59' ); echo Display::return_message( sprintf(get_lang('XResults and feedbackCleaned'), $count), 'confirm' ); } } } // Security token to protect deletion $token = Security::get_token(); $actions = Display::div($actions, ['class' => 'actions']); $extra = ''; $extra .= '
'; $form = new FormValidator( 'report', 'post', null, null, ['class' => 'form-vertical'] ); $form->addElement( 'radio', 'export_format', null, get_lang('CSV export'), 'csv', ['id' => 'export_format_csv_label'] ); $form->addElement( 'radio', 'export_format', null, get_lang('Excel export'), 'xls', ['id' => 'export_format_xls_label'] ); $form->addElement( 'checkbox', 'load_extra_data', null, get_lang('Load extra user fields data (have to be marked as \'Filter\' to appear).'), '0', ['id' => 'export_format_xls_label'] ); $form->addElement( 'checkbox', 'include_all_users', null, get_lang('Include all users'), '0' ); $form->addElement( 'checkbox', 'only_best_attempts', null, get_lang('Only best attempts'), '0' ); $form->setDefaults(['export_format' => 'csv']); $extra .= $form->returnForm(); $extra .= '
'; if ($is_allowedToEdit) { echo $extra; } echo $actions; $url = api_get_path(WEB_AJAX_PATH).'model.ajax.php?a=get_exercise_results&exerciseId='.$exercise_id.'&filter_by_user='.$filter_user.'&'.api_get_cidreq(); $action_links = ''; // Generating group list $group_list = GroupManager::get_group_list(); $group_parameters = [ 'group_all:'.get_lang('All'), 'group_none:'.get_lang('none'), ]; foreach ($group_list as $group) { $group_parameters[] = $group['id'].':'.$group['name']; } if (!empty($group_parameters)) { $group_parameters = implode(';', $group_parameters); } $officialCodeInList = api_get_setting('show_official_code_exercise_result_list'); if ($is_allowedToEdit || $is_tutor) { // The order is important you need to check the the $column variable in the model.ajax.php file $columns = [ get_lang('First name'), get_lang('Last name'), get_lang('Login'), get_lang('Group'), get_lang('Duration').' ('.get_lang('minute').')', get_lang('Start Date'), get_lang('End Date'), get_lang('Score'), get_lang('IP'), get_lang('Status'), get_lang('Learning path'), get_lang('Detail'), ]; if ($officialCodeInList === 'true') { $columns = array_merge([get_lang('Code')], $columns); } // Column config $column_model = [ ['name' => 'firstname', 'index' => 'firstname', 'width' => '50', 'align' => 'left', 'search' => 'true'], ['name' => 'lastname', 'index' => 'lastname', 'width' => '50', 'align' => 'left', 'formatter' => 'action_formatter', 'search' => 'true'], [ 'name' => 'login', 'index' => 'username', 'width' => '40', 'align' => 'left', 'search' => 'true', 'hidden' => api_get_configuration_value('exercise_attempts_report_show_username') ? 'false' : 'true', ], [ 'name' => 'group_name', 'index' => 'group_id', 'width' => '40', 'align' => 'left', 'search' => 'true', 'stype' => 'select', //for the bottom bar 'searchoptions' => [ 'defaultValue' => 'group_all', 'value' => $group_parameters, ], //for the top bar 'editoptions' => ['value' => $group_parameters], ], ['name' => 'duration', 'index' => 'exe_duration', 'width' => '30', 'align' => 'left', 'search' => 'true'], ['name' => 'start_date', 'index' => 'start_date', 'width' => '60', 'align' => 'left', 'search' => 'true'], ['name' => 'exe_date', 'index' => 'exe_date', 'width' => '60', 'align' => 'left', 'search' => 'true'], ['name' => 'score', 'index' => 'score', 'width' => '50', 'align' => 'center', 'search' => 'true'], ['name' => 'ip', 'index' => 'user_ip', 'width' => '40', 'align' => 'center', 'search' => 'true'], [ 'name' => 'status', 'index' => 'revised', 'width' => '40', 'align' => 'left', 'search' => 'true', 'stype' => 'select', //for the bottom bar 'searchoptions' => [ 'defaultValue' => '', 'value' => ':'.get_lang('All').';1:'.get_lang('Validated').';0:'.get_lang('Not validated'), ], //for the top bar 'editoptions' => [ 'value' => ':'.get_lang('All').';1:'.get_lang('Validated').';0:'.get_lang( 'Not validated' ), ], ], ['name' => 'lp', 'index' => 'orig_lp_id', 'width' => '60', 'align' => 'left', 'search' => 'false'], ['name' => 'actions', 'index' => 'actions', 'width' => '60', 'align' => 'left', 'search' => 'false', 'sortable' => 'false'], ]; if ($officialCodeInList === 'true') { $officialCodeRow = ['name' => 'official_code', 'index' => 'official_code', 'width' => '50', 'align' => 'left', 'search' => 'true']; $column_model = array_merge([$officialCodeRow], $column_model); } $action_links = ' // add username as title in lastname filed - ref 4226 function action_formatter(cellvalue, options, rowObject) { // rowObject is firstname,lastname,login,... get the third word var loginx = "'.api_htmlentities(sprintf(get_lang('Login: %s'), ':::'), ENT_QUOTES).'"; var tabLoginx = loginx.split(/:::/); // tabLoginx[0] is before and tabLoginx[1] is after ::: // may be empty string but is defined return ""+cellvalue+""; }'; } $extra_params['autowidth'] = 'true'; $extra_params['height'] = 'auto'; $extra_params['gridComplete'] = " defaultGroupId = Cookies.get('default_group_".$exercise_id."'); if (typeof defaultGroupId !== 'undefined') { $('#gs_group_name').val(defaultGroupId); } "; $extra_params['beforeRequest'] = " var defaultGroupId = $('#gs_group_name').val(); // Load from group menu if (typeof defaultGroupId !== 'undefined') { Cookies.set('default_group_".$exercise_id."', defaultGroupId); } else { // get from cookies defaultGroupId = Cookies.get('default_group_".$exercise_id."'); $('#gs_group_name').val(defaultGroupId); } if (typeof defaultGroupId !== 'undefined') { var posted_data = $(\"#results\").jqGrid('getGridParam', 'postData'); var extraFilter = ',{\"field\":\"group_id\",\"op\":\"eq\",\"data\":\"'+ defaultGroupId +'\"}]}'; var filters = posted_data.filters; var stringObj = new String(filters); stringObj.replace(']}', extraFilter); posted_data['group_id_in_toolbar'] = defaultGroupId; $(this).jqGrid('setGridParam', 'postData', posted_data); } "; $gridJs = Display::grid_js( 'results', $url, $columns, $column_model, $extra_params, [], $action_links, true ); ?>