123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047 |
- <?php
- /* For licensing terms, see /license.txt */
- /**
- * Exercise submission
- * This script allows to run an exercise. According to the exercise type, questions
- * can be on an unique page, or one per page with a Next button.
- *
- * One exercise may contain different types of answers (unique or multiple selection,
- * matching, fill in blanks, free answer, hot-spot).
- *
- * Questions are selected randomly or not.
- *
- * When the user has answered all questions and clicks on the button "Ok",
- * it goes to exercise_result.php
- *
- * Notice : This script is also used to show a question before modifying it by
- * the administrator
- * @package chamilo.exercise
- * @author Olivier Brouckaert
- * @author Julio Montoya <gugli100@gmail.com>
- * Fill in blank option added (2008)
- * Cleaning exercises (2010),
- * Adding hotspot delineation support (2011)
- * Adding reminder + ajax support (2011)
- * Modified by hubert.borderiou (2011-10-21 question category)
- */
- /**
- * Code
- */
- require_once 'exercise.class.php';
- require_once 'question.class.php';
- require_once 'answer.class.php';
- $debug = 1; //debug value is set in the exercise.class.php file
- // name of the language file that needs to be included
- $language_file = 'exercice';
- require_once '../inc/global.inc.php';
- require_once 'exercise.lib.php';
- $this_section = SECTION_COURSES;
- if ($debug) { error_log('--- Enter to the exercise_submit.php ---- '); error_log('0. POST variables : '.print_r($_POST,1)); }
- // Notice for unauthorized people.
- api_protect_course_script(true);
- $is_allowedToEdit = api_is_allowed_to_edit(null,true);
- $htmlHeadXtra[] = api_get_jquery_js();
- if (api_get_setting('show_glossary_in_extra_tools') == 'true') {
- $htmlHeadXtra[] = api_get_js('glossary.js'); //Glossary
- $htmlHeadXtra[] = api_get_js('jquery.highlight.js'); //highlight
- }
- //This library is necessary for the time control feature
- $htmlHeadXtra[] = api_get_js('jquery.epiclock.min.js');
- // General parameters passed via POST/GET
- $learnpath_id = isset($_REQUEST['learnpath_id']) ? intval($_REQUEST['learnpath_id']) : 0;
- $learnpath_item_id = isset($_REQUEST['learnpath_item_id']) ? intval($_REQUEST['learnpath_item_id']) : 0;
- $learnpath_item_view_id = isset($_REQUEST['learnpath_item_view_id']) ? intval($_REQUEST['learnpath_item_view_id']) : 0;
- $origin = isset($_REQUEST['origin']) ? Security::remove_XSS($_REQUEST['origin']) : '';
- $reminder = isset($_REQUEST['reminder']) ? intval($_REQUEST['reminder']) : 0;
- $remind_question_id = isset($_REQUEST['remind_question_id']) ? intval($_REQUEST['remind_question_id']) : 0;
- $exerciseId = isset($_REQUEST['exerciseId']) ? intval($_REQUEST['exerciseId']) : 0;
- if (empty ($formSent)) {
- $formSent = $_REQUEST['formSent'];
- }
- if (empty($exerciseResult)) {
- $exerciseResult = $_REQUEST['exerciseResult'];
- }
- if (empty ($exerciseResultCoordinates)) {
- $exerciseResultCoordinates = $_REQUEST['exerciseResultCoordinates'];
- }
- $choice = isset($_REQUEST['choice']) ? $_REQUEST['choice'] : null;
- $choice = empty($choice) ? $_REQUEST['choice2'] : null;
- $questionNum = isset($_REQUEST['questionNum']) ? intval($_REQUEST['questionNum']) : null;
- $current_question = isset($_REQUEST['num']) ? intval($_REQUEST['num']) : null;
- //Error message
- $error = '';
- $safe_lp_id = ($learnpath_id == '') ? 0 : $learnpath_id;
- $safe_lp_item_id = ($learnpath_item_id == '') ? 0 : $learnpath_item_id;
- $safe_lp_item_view_id = ($learnpath_item_view_id == '') ? 0 : $learnpath_item_view_id;
- //Table calls
- $stat_table = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES);
- $exercice_attemp_table = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);
- /* Teacher takes an exam and want to see a preview, we delete the objExercise from the session in order to get the latest changes in the exercise */
- if (api_is_allowed_to_edit(null,true) && $_GET['preview'] == 1 ) {
- api_session_unregister('objExercise');
- }
- // 1. Loading the $objExercise variable
- if (!isset($_SESSION['objExercise']) || $_SESSION['objExercise']->id != $_REQUEST['exerciseId']) {
- // Construction of Exercise
- $objExercise = new Exercise();
- if ($debug) {error_log('1. Setting the $objExercise variable'); };
- unset($_SESSION['questionList']);
- // if the specified exercise doesn't exist or is disabled
- if (!$objExercise->read($exerciseId) || (!$objExercise->selectStatus() && !$is_allowedToEdit && ($origin != 'learnpath'))) {
- if ($debug) {error_log('1.1. Error while reading the exercise'); };
- unset ($objExercise);
- $error = get_lang('ExerciseNotFound');
- } else {
- // Saves the object into the session
- api_session_register('objExercise');
- if ($debug) {error_log('1.1. $_SESSION[objExercise] was unset - set now - end'); };
- }
- }
- //2. Checking if $objExercise is set
- if (!isset($objExercise) && isset($_SESSION['objExercise'])) {
- if ($debug) { error_log('2. Loading $objExercise from session'); };
- $objExercise = $_SESSION['objExercise'];
- }
- //3. $objExercise is not set, then return to the exercise list
- if (!is_object($objExercise)) {
- if ($debug) {error_log('3. $objExercise was not set, kill the script'); };
- header('Location: exercice.php');
- exit;
- }
- //if reminder ends we jump to the exercise_reminder
- if ($objExercise->review_answers) {
- if ($remind_question_id == -1) {
- header('Location: exercise_reminder.php?origin='.$origin.'&exerciseId='.$exerciseId);
- exit;
- }
- }
- $current_timestamp = time();
- $my_remind_list = array();
- $time_control = false;
- if ($objExercise->expired_time != 0 && $origin != 'learnpath') {
- $time_control = true;
- }
- if ($time_control) {
- //Get the expired time of the current exercice in track_e_exercices
- $total_seconds = $objExercise->expired_time*60;
-
- //Generating the time control key for the user
- $current_expired_time_key = generate_time_control_key($objExercise->id);
- }
- $show_clock = true;
- $user_id = api_get_user_id();
- if ($objExercise->selectAttempts() > 0) {
- $attempt_html = '';
- $attempt_count = get_attempt_count($user_id, $exerciseId, $safe_lp_id, $safe_lp_item_id, $safe_lp_item_view_id);
- if ($attempt_count >= $objExercise->selectAttempts()) {
- $show_clock = false;
- if (!api_is_allowed_to_edit(null,true)) {
- if ($objExercise->results_disabled == 0 && $origin != 'learnpath') {
- //Showing latest attempt according with task BT#1628
- $exercise_stat_info = get_exercise_results_by_user($user_id, $exerciseId, api_get_course_id(), api_get_session_id());
- if (!empty($exercise_stat_info)) {
- $max_exe_id = max(array_keys($exercise_stat_info));
- $last_attempt_info = $exercise_stat_info[$max_exe_id];
- $attempt_html .= Display::div(get_lang('Date').': '.api_get_local_time($last_attempt_info['exe_date']), array('id'=>''));
- $attempt_html .= Display::return_message(sprintf(get_lang('ReachedMaxAttempts'), $exercise_title, $objExercise->selectAttempts()), 'warning', false);
- if (!empty($last_attempt_info['question_list'])) {
- foreach($last_attempt_info['question_list'] as $question_data) {
- $question_id = $question_data['question_id'];
- $marks = $question_data['marks'];
- $question_info = Question::read($question_id);
- $attempt_html .= Display::div($question_info->question, array('class'=>'question_title'));
- $attempt_html .= Display::div(get_lang('Score').' '.$marks, array('id'=>'question_score'));
- }
- }
- $score = show_score($last_attempt_info['exe_result'], $last_attempt_info['exe_weighting']);
- $attempt_html .= Display::div(get_lang('YourTotalScore').' '.$score, array('id'=>'question_score'));
- } else {
- $attempt_html .= Display::return_message(sprintf(get_lang('ReachedMaxAttempts'), $exercise_title, $objExercise->selectAttempts()), 'warning', false);
- }
- } else {
- $attempt_html .= Display::return_message(sprintf(get_lang('ReachedMaxAttempts'), $exercise_title, $objExercise->selectAttempts()), 'warning', false);
- }
- } else {
- $attempt_html .= Display :: return_message(sprintf(get_lang('ReachedMaxAttempts'), $exercise_title, $objExercise->selectAttempts()), 'warning', false);
- //Display :: display_warning_message(sprintf(get_lang('ReachedMaxAttemptsAdmin'), $exercise_title, $objExercise->selectAttempts()), false);
- }
-
- if ($origin == 'learnpath') {
- Display :: display_reduced_header();
- } else {
- Display :: display_header($nameTools,'Exercises');
- }
-
- echo $attempt_html;
- if ($origin != 'learnpath')
- Display :: display_footer();
- exit;
- }
- }
- if ($debug) { error_log("4. Setting the exe_id $exe_id");} ;
- //5. Getting user exercise info (if the user took the exam before) - generating exe_id
- //var_dump($safe_lp_id.' - '.$safe_lp_item_id.' - '.$safe_lp_item_view_id);
- $exercise_stat_info = $objExercise->get_stat_track_exercise_info($safe_lp_id, $safe_lp_item_id, $safe_lp_item_view_id);
- if (empty($exercise_stat_info)) {
- $total_weight = 0;
- $questionList = $objExercise->get_validated_question_list();
- foreach($questionList as $question_id) {
- $objQuestionTmp = Question::read($question_id);
- $total_weight += floatval($objQuestionTmp->weighting);
- }
- $clock_expired_time = '';
- if ($time_control) {
- $expected_time = $current_timestamp + $total_seconds;
-
- if ($debug) error_log('6.3. $current_timestamp '.$current_timestamp);
- if ($debug) error_log('6.4. $expected_time '.$expected_time);
-
- $clock_expired_time = api_get_utc_datetime($expected_time);
- if ($debug) error_log('6.5. $expected_time '.$clock_expired_time);
-
- //Sessions that contain the expired time
- $_SESSION['expired_time'][$current_expired_time_key] = $clock_expired_time;
- if ($debug) {
- error_log('6.6. Setting the $_SESSION[expired_time]: '.$_SESSION['expired_time'][$current_expired_time_key] );
- };
- }
- $exe_id = $objExercise->save_stat_track_exercise_info($clock_expired_time, $safe_lp_id, $safe_lp_item_id, $safe_lp_item_view_id, $questionList, $total_weight);
- $exercise_stat_info = $objExercise->get_stat_track_exercise_info($safe_lp_id, $safe_lp_item_id, $safe_lp_item_view_id);
- } else {
- $exe_id = $exercise_stat_info['exe_id'];
- }
- if ($debug) { error_log('5. $objExercise->get_stat_track_exercise_info function called:: '.print_r($exercise_stat_info, 1)); };
- if (!empty($exercise_stat_info['questions_to_check'])) {
- $my_remind_list = $exercise_stat_info['questions_to_check'];
- $my_remind_list = explode(',', $my_remind_list);
- $my_remind_list = array_filter($my_remind_list);
- }
- $params = 'exe_id='.$exe_id.'&exerciseId='.$exerciseId.'&origin='.$origin.'&learnpath_id='.$learnpath_id.'&learnpath_item_id='.$learnpath_item_id.'&learnpath_item_view_id='.$learnpath_item_view_id;
- if ($debug) { error_log("5.1 params: -> $params"); };
- if ($reminder == 2 && empty($my_remind_list)) {
- header('Location: exercise_reminder.php?'.$params);
- exit;
- }
- /*
- * 6. Loading Time control parameters
- * If the expired time is major that zero(0) then the expired time is compute on this time. Disable for learning path
- */
- if ($time_control) {
- if ($debug) error_log('6.1. Time control is enabled');
- if ($debug) {error_log('6.2. $current_expired_time_key '.$current_expired_time_key); };
- if ($debug) { error_log('6.2. $_SESSION[expired_time][$current_expired_time_key] '.$_SESSION['expired_time'][$current_expired_time_key]); };
-
- if (!isset($_SESSION['expired_time'][$current_expired_time_key])) {
- //Timer - Get expired_time for a student
- if (!empty($exercise_stat_info)) {
- if ($debug) {error_log('6.3 Seems that the session ends and the user want to retake the exam'); };
- $expired_time_of_this_attempt = $exercise_stat_info['expired_time_control'];
- if ($debug) {error_log('$expired_time_of_this_attempt: '.$expired_time_of_this_attempt); }
- //Get the last attempt of an exercice
- $last_attempt_date = get_last_attempt_date_of_exercise($exercise_stat_info['exe_id']);
-
- //This means that the user enters the exam but do not answer the first question we get the date from the track_e_exercises not from the track_et_attempt see #2069
- if (empty($last_attempt_date)) {
- $diff = $current_timestamp - api_strtotime($exercise_stat_info['start_date'], 'UTC');
- $last_attempt_date = api_get_utc_datetime(api_strtotime($exercise_stat_info['start_date'],'UTC') + $diff);
- } else {
- //Recalculate the time control due #2069
- $diff = $current_timestamp - api_strtotime($last_attempt_date,'UTC');
- $last_attempt_date = api_get_utc_datetime(api_strtotime($last_attempt_date,'UTC') + $diff);
- }
- if ($debug) {error_log('6.4. $last_attempt_date: '.$last_attempt_date); }
-
- //New expired time - it is due to the possible closure of session
- $new_expired_time_in_seconds = api_strtotime($expired_time_of_this_attempt, 'UTC') - api_strtotime($last_attempt_date,'UTC');
- if ($debug) {error_log('6.5. $new_expired_time_in_seconds: '.$new_expired_time_in_seconds); }
-
- $expected_time = $current_timestamp + $new_expired_time_in_seconds;
- if ($debug) {error_log('6.6. $expected_time1: '.$expected_time); }
-
- $clock_expired_time = api_get_utc_datetime($expected_time);
- if ($debug) {error_log('6.7. $clock_expired_time: '.$clock_expired_time); }
-
- // First we update the attempt to today
- // How the expired time is changed into "track_e_exercices" table,then the last attempt for this student should be changed too,so
- $sql_track_e_exe = "UPDATE $exercice_attemp_table SET tms = '".api_get_utc_datetime()."' WHERE exe_id = '".$exercise_stat_info['exe_id']."' AND tms = '".$last_attempt_date."' ";
- if ($debug) {error_log('6.8. $sql_track_e_exe2: '.$sql_track_e_exe); }
- Database::query($sql_track_e_exe);
-
- //Sessions that contain the expired time
- $_SESSION['expired_time'][$current_expired_time_key] = $clock_expired_time;
- if ($debug) {error_log('6.9. Setting the $_SESSION[expired_time]: '.$_SESSION['expired_time'][$current_expired_time_key] ); };
- }
- } else {
- $clock_expired_time = $_SESSION['expired_time'][$current_expired_time_key];
- }
- }
- // Get time left for exipiring time
- $time_left = api_strtotime($clock_expired_time,'UTC') - time();
- /*
- * The time control feature is enable here - this feature is enable for a jquery plugin called epiclock
- * for more details of how it works see this link : http://eric.garside.name/docs.html?p=epiclock
- */
- if ($time_control) { //Sends the exercice form when the expired time is finished
- $htmlHeadXtra[] = $objExercise->show_time_control_js($time_left);
- }
- /*
- if ($objExercise->type == ONE_PER_PAGE && $objExercise->feedbacktype != EXERCISE_FEEDBACK_TYPE_DIRECT) {
- if (!empty($exercise_stat_info)) {
- $exe_id = $exercise_stat_info['exe_id'];
- if ($_SERVER['REQUEST_METHOD'] != 'POST') {
- $recorded['questionList'] = explode(',', $exercise_stat_info['data_tracking']);
- $query = 'SELECT * FROM ' . $exercice_attemp_table . ' WHERE exe_id = ' . $exercise_stat_info['exe_id'] . ' ORDER BY tms ASC';
- $result = Database::query($query);
- while ($row = Database :: fetch_array($result,'ASSOC')) {
- $recorded['exerciseResult'][$row['question_id']] = 1;
- }
- $exerciseResult = $_SESSION['exerciseResult'] = $recorded['exerciseResult'];
- $current_question = count($recorded['exerciseResult']);
- $current_question++;
- $questionList = $_SESSION['questionList'] = $recorded['questionList'];
- }
- }
- }*/
- // if the user has submitted the form
- $exercise_title = $objExercise->selectTitle();
- $exercise_description = $objExercise->selectDescription();
- $exercise_sound = $objExercise->selectSound();
- //if (!isset($_SESSION['questionList']) || $origin == 'learnpath') {
- //in LP's is enabled the "remember question" feature?
- if (!isset($_SESSION['questionList'])) {
- // selects the list of question ID
- $questionList = $objExercise->get_validated_question_list();
- if ($objExercise->isRandom() && !empty($exercise_stat_info['data_tracking'])) {
- $questionList = explode(',', $exercise_stat_info['data_tracking']);
- }
- api_session_register('questionList');
- if ($debug > 0) { error_log('$_SESSION[questionList] was set'); }
- } else {
- if (isset($objExercise) && isset($_SESSION['objExercise'])) {
- $questionList = $_SESSION['questionList'];
- }
- }
- if ($debug) error_log('7 Question list loaded '.print_r($questionList, 1));
- $quizStartTime = time();
- api_session_register('quizStartTime');
- //Real question count
- $question_count = 0;
- if (!empty($questionList)) {
- $question_count = count($questionList);
- }
- if ($formSent && isset($_POST)) {
- if ($debug > 0) { error_log('8. $formSent was set'); }
- // Initializing
- if (!is_array($exerciseResult)) {
- $exerciseResult = array();
- $exerciseResultCoordinates = array();
- }
- //Only for hotspot
- if (!isset($choice) && isset($_REQUEST['hidden_hotspot_id'])) {
- $hotspot_id = (int)($_REQUEST['hidden_hotspot_id']);
- $choice = array($hotspot_id => '');
- }
-
- // if the user has answered at least one question
- if (is_array($choice)) {
- if ($debug) { error_log('8.1. $choice is an array '.print_r($choice, 1)); }
- // Also store hotspot spots in the session ($exerciseResultCoordinates
- // will be stored in the session at the end of this script)
- if (isset($_POST['hotspot'])) {
- $exerciseResultCoordinates = $_POST['hotspot'];
- if ($debug) { error_log('8.2. $_POST[hotspot] data '.print_r($exerciseResultCoordinates, 1)); }
- }
- if ($objExercise->type == ALL_ON_ONE_PAGE) {
- // $exerciseResult receives the content of the form.
- // Each choice of the student is stored into the array $choice
- $exerciseResult = $choice;
- } else {
- // gets the question ID from $choice. It is the key of the array
- list ($key) = array_keys($choice);
- // if the user didn't already answer this question
- if (!isset($exerciseResult[$key])) {
- // stores the user answer into the array
- $exerciseResult[$key] = $choice[$key];
- //saving each question
- if ($objExercise->feedbacktype != EXERCISE_FEEDBACK_TYPE_DIRECT) {
- $nro_question = $current_question; // - 1;
- $questionId = $key;
- // gets the student choice for this question
- $choice = $exerciseResult[$questionId];
- if (isset($exe_id)) {
- //Manage the question and answer attempts
- if ($debug > 0) { error_log('8.3. manage_answer exe_id: '.$exe_id.' - $questionId: '.$questionId.' Choice'.print_r($choice,1)); }
- $objExercise->manage_answer($exe_id, $questionId, $choice,'exercise_show',$exerciseResultCoordinates, true, false,false, $objExercise->propagate_neg);
- }
- //END of saving and qualifying
- }
- }
- }
- if ($debug > 0) { error_log('8.3. $choice is an array - end'); }
- if ($debug > 0) { error_log('8.4. $exerciseResult '.print_r($exerciseResult,1)); }
- }
-
-
- // the script "exercise_result.php" will take the variable $exerciseResult from the session
- api_session_register('exerciseResult');
- api_session_register('remind_list');
- api_session_register('exerciseResultCoordinates');
- // if all questions on one page OR if it is the last question (only for an exercise with one question per page)
-
- if (($objExercise->type == ALL_ON_ONE_PAGE || $current_question >= $question_count)) {
- if (api_is_allowed_to_session_edit()) {
- // goes to the script that will show the result of the exercise
- if ($objExercise->type == ALL_ON_ONE_PAGE) {
- if ($debug) { error_log('Exercise ALL_ON_ONE_PAGE -> Redirecting to exercise_result.php'); }
-
- //We check if the user attempts before sending to the exercise_result.php
- if ($objExercise->selectAttempts() > 0) {
- $attempt_count = get_attempt_count(api_get_user_id(), $exerciseId, $safe_lp_id, $safe_lp_item_id, $safe_lp_item_view_id);
- if ($attempt_count >= $objExercise->selectAttempts()) {
- Display :: display_warning_message(sprintf(get_lang('ReachedMaxAttempts'), $exercise_title, $objExercise->selectAttempts()), false);
- if ($origin != 'learnpath') {
- //so we are not in learnpath tool
- echo '</div>'; //End glossary div
- Display :: display_footer();
- } else {
- echo '</body></html>';
- }
- }
- }
- header("Location: exercise_result.php?exe_id=$exe_id&origin=$origin&learnpath_id=$safe_lp_id&learnpath_item_id=$safe_lp_item_id&learnpath_item_view_id=$safe_lp_item_view_id");
- exit;
- } else {
- //Time control is only enabled for ONE PER PAGE
- if (!empty($exe_id) && is_numeric($exe_id)) {
- //Verify if the current test is fraudulent
- if (exercise_time_control_is_valid($exerciseId)) {
- $sql_exe_result = "";
- if ($debug) { error_log('exercise_time_control_is_valid is valid'); }
- } else {
- $sql_exe_result = ", exe_result = 0";
- if ($debug) { error_log('exercise_time_control_is_valid is NOT valid then exe_result = 0 '); }
- }
- /*
- //Clean incomplete - @todo why setting to blank the status?
- $update_query = "UPDATE $stat_table SET status = '', exe_date = '".api_get_utc_datetime() ."' , orig_lp_item_view_id = '$safe_lp_item_view_id' $sql_exe_result WHERE exe_id = ".$exe_id;
-
- if ($debug) { error_log('Updating track_e_exercises '.$update_query); }
- Database::query($update_query);*/
- }
- if ($debug) { error_log('Redirecting to exercise_show.php'); }
- //header("Location: exercise_show.php?id=$exe_id&origin=$origin&learnpath_id=$safe_lp_id&learnpath_item_id=$safe_lp_item_id&learnpath_item_view_id=$safe_lp_item_view_id");
- header("Location: exercise_result.php?exe_id=$exe_id&origin=$origin&learnpath_id=$safe_lp_id&learnpath_item_id=$safe_lp_item_id&learnpath_item_view_id=$safe_lp_item_view_id");
- exit;
- }
- } else {
- if ($debug) { error_log('Redirecting to exercise_submit.php'); }
- header("Location: exercise_submit.php?exerciseId=$exerciseId&origin=$origin");
- exit;
- }
- }
-
- if (!empty($remind_list)) {
- //header("Location: exercise_reminder.php?origin=$origin&learnpath_id=$safe_lp_id&learnpath_item_id=$safe_lp_item_id&learnpath_item_view_id=$safe_lp_item_view_id");
- exit;
- }
- if ($debug > 0) { error_log('$formSent was set - end'); }
- }
- // if questionNum comes from POST and not from GET
- if (!$current_question || $_REQUEST['num']) {
- if (!$current_question) {
- $current_question = 1;
- } else {
- $current_question++;
- }
- }
- if ($question_count != 0) {
- if (($objExercise->type == ALL_ON_ONE_PAGE || $current_question > $question_count)) {
- if (api_is_allowed_to_session_edit()) {
- // goes to the script that will show the result of the exercise
- if ($objExercise->type == ALL_ON_ONE_PAGE) {
- if ($debug) { error_log('Exercise ALL_ON_ONE_PAGE -> Redirecting to exercise_result.php'); }
-
- //We check if the user attempts before sending to the exercise_result.php
- if ($objExercise->selectAttempts() > 0) {
-
- $attempt_count = get_attempt_count(api_get_user_id(), $exerciseId, $safe_lp_id, $safe_lp_item_id, $safe_lp_item_view_id);
- if ($attempt_count >= $objExercise->selectAttempts()) {
- Display :: display_warning_message(sprintf(get_lang('ReachedMaxAttempts'), $exercise_title, $objExercise->selectAttempts()), false);
- if ($origin != 'learnpath') {
- //so we are not in learnpath tool
- echo '</div>'; //End glossary div
- Display :: display_footer();
- } else {
- echo '</body></html>';
- }
- exit;
- }
- }
- //header("Location: exercise_result.php?origin=$origin&learnpath_id=$safe_lp_id&learnpath_item_id=$safe_lp_item_id&learnpath_item_view_id=$safe_lp_item_view_id");
- //exit;
- } else {
-
- //Time control is only enabled for ONE PER PAGE
- if (!empty($exe_id) && is_numeric($exe_id)) {
- //Verify if the current test is fraudulent
- $check = exercise_time_control_is_valid($exerciseId);
-
- if ($check) {
- $sql_exe_result = "";
- if ($debug) { error_log('exercise_time_control_is_valid is valid'); }
- } else {
- $sql_exe_result = ", exe_result = 0";
- if ($debug) { error_log('exercise_time_control_is_valid is NOT valid then exe_result = 0 '); }
- }
- /*
- //Clean incomplete - @todo why setting to blank the status?
- $update_query = "UPDATE $stat_table SET status = '', exe_date = '".api_get_utc_datetime() ."' , orig_lp_item_view_id = '$safe_lp_item_view_id' $sql_exe_result WHERE exe_id = ".$exe_id;
-
- //if ($debug) { error_log('Updating track_e_exercises '.$update_query); }
- Database::query($update_query);*/
- }
- if ($objExercise->review_answers) {
- header('Location: exercise_reminder.php?'.$params);
- exit;
- } else {
- header("Location: exercise_result.php?exe_id=$exe_id&origin=$origin&learnpath_id=$safe_lp_id&learnpath_item_id=$safe_lp_item_id&learnpath_item_view_id=$safe_lp_item_view_id");
- }
- }
- } else {
- if ($debug) { error_log('Redirecting to exercise_submit.php'); }
- //header("Location: exercise_submit.php?exerciseId=$exerciseId");
- exit;
- }
- }
- } else {
- $error = get_lang('ThereAreNoQuestionsForThisExercise');
- // if we are in the case where user select random by category, but didn't choose the number of random question
- if ($objExercise->selectRandomByCat() > 0 && $objExercise->random <= 0) {
- $error .= "<br/>".get_lang('PleaseSelectSomeRandomQuestion');
- }
- }
- if (!empty ($_GET['gradebook']) && $_GET['gradebook'] == 'view') {
- $_SESSION['gradebook'] = Security :: remove_XSS($_GET['gradebook']);
- $gradebook = $_SESSION['gradebook'];
- } elseif (empty ($_GET['gradebook'])) {
- unset ($_SESSION['gradebook']);
- $gradebook = '';
- }
- if (!empty ($gradebook) && $gradebook == 'view') {
- $interbreadcrumb[] = array ('url' => '../gradebook/' . Security::remove_XSS($_SESSION['gradebook_dest']),'name' => get_lang('ToolGradebook'));
- }
- $interbreadcrumb[] = array ("url" => "exercice.php?gradebook=$gradebook", "name" => get_lang('Exercices'));
- $interbreadcrumb[] = array ("url" => "#","name" => $objExercise->name);
- if ($origin != 'learnpath') { //so we are not in learnpath tool
- Display :: display_header($nameTools,'Exercises');
- if (!api_is_allowed_to_session_edit() ) {
- Display :: display_warning_message(get_lang('SessionIsReadOnly'));
- }
- } else {
- Display::display_reduced_header();
- echo '<div style="height:10px"> </div>';
- }
- $show_quiz_edition = $objExercise->added_in_lp();
- // I'm in a preview mode
- if (api_is_course_admin() && $origin != 'learnpath') {
- echo '<div class="actions">';
- //echo '<a href="exercice.php?show=test&id_session='.api_get_session_id().'">' . Display :: return_icon('back.png', get_lang('BackToExercisesList'),'','32').'</a>';
- if ($show_quiz_edition == false) {
- echo '<a href="exercise_admin.php?' . api_get_cidreq() . '&modifyExercise=yes&exerciseId=' . $objExercise->id . '">'.Display :: return_icon('settings.png', get_lang('ModifyExercise'),'','32').'</a>';
- //echo Display :: return_icon('wizard.gif', get_lang('QuestionList')) . '<a href="exercice/admin.php?' . api_get_cidreq() . '&exerciseId=' . $objExercise->id . '">' . get_lang('QuestionList') . '</a>';
- } else {
- echo '<a href="#">'.Display::return_icon('settings_na.png', get_lang('ModifyExercise'),'','32').'</a>';
- }
- echo '</div>';
- }
- /*
- $exercise_header = Display::div($exercise_title, array('class'=>'exercise_title'));
- if (!empty($exercise_description)) {
- $exercise_header .= Display::div($exercise_description, array('class'=>'exercise_description'));
- }
- echo Display::div($exercise_header, array('class'=>'exercise_header'));*/
- $limit_time_exists = (($objExercise->start_time != '0000-00-00 00:00:00') || ($objExercise->end_time != '0000-00-00 00:00:00')) ? true : false;
- if ($limit_time_exists) {
- $exercise_start_time = api_strtotime($objExercise->start_time,'UTC');
- $exercise_end_time = api_strtotime($objExercise->end_time,'UTC');
- $time_now = time();
-
- if ($objExercise->start_time != '0000-00-00 00:00:00') {
- $permission_to_start = (($time_now - $exercise_start_time) > 0) ? true : false;
- } else {
- $permission_to_start = true;
- }
- if ($_SERVER['REQUEST_METHOD'] != 'POST') {
- if ($objExercise->end_time != '0000-00-00 00:00:00') {
- $exercise_timeover = (($time_now - $exercise_end_time) > 0) ? true : false;
- } else {
- $exercise_timeover = false;
- }
- }
-
- if (!$permission_to_start || $exercise_timeover) {
- if (!api_is_allowed_to_edit(null,true)) {
- $message_warning = $permission_to_start ? get_lang('ReachedTimeLimit') : get_lang('ExerciseNoStartedYet');
- Display :: display_warning_message(sprintf($message_warning, $exercise_title, $objExercise->selectAttempts()));
- if ($origin != 'learnpath') {
- Display :: display_footer();
- }
- exit;
- } else {
- $message_warning = $permission_to_start ? get_lang('ReachedTimeLimitAdmin') : get_lang('ExerciseNoStartedAdmin');
- Display :: display_warning_message(sprintf($message_warning, $exercise_title, $objExercise->selectAttempts()));
- exit;
- }
- }
- }
- // Blocking empty start times see BT#2800
- global $_custom;
- if (isset($_custom['exercises_hidden_when_no_start_date']) && $_custom['exercises_hidden_when_no_start_date']) {
- if (empty($objExercise->start_time) || $objExercise->start_time == '0000-00-00 00:00:00') {
- Display :: display_warning_message(sprintf(get_lang('ExerciseNoStartedYet'), $exercise_title, $objExercise->selectAttempts()));
- if ($origin != 'learnpath') {
- Display :: display_footer();
- }
- }
- }
- //Timer control
- if ($time_control) {
- echo '<div align="left" id="wrapper-clock"><div id="square" class="rounded"><div id="text-content" align="center" class="count_down"></div></div></div>';
- echo '<div style="display:none" class="warning-message" id="expired-message-id">'.get_lang('ExerciceExpiredTimeMessage').'</div>';
- }
- if ($origin != 'learnpath') {
- echo '<div id="highlight-plugin" class="glossary-content">';
- }
- //var_dump('$remind_question_id . '.$remind_question_id);
- if ($reminder == 2) {
-
- $data_tracking = $exercise_stat_info['data_tracking'];
- $data_tracking = explode(',', $data_tracking);
-
- $current_question = 1; //set by default the 1st question
-
- if (!empty($my_remind_list)) {
- //Checking which questions we are going to call from the remind list
- for ($i = 0; $i < count($data_tracking); $i++) {
- for($j = 0; $j < count($my_remind_list); $j++) {
-
- if (!empty($remind_question_id)) {
- if ($remind_question_id == $my_remind_list[$j]) {
-
- if ($remind_question_id == $data_tracking[$i]) {
- if (isset($my_remind_list[$j+1])) {
- $remind_question_id = $my_remind_list[$j+1];
- $current_question = $i + 1;
- } else {
- $remind_question_id = -1; //We end the remind list we go to the exercise_reminder.php please
- $current_question = $i + 1; // last question
- }
- break 2;
- }
- }
- } else {
- if ($my_remind_list[$j] == $data_tracking[$i]) {
- if (isset($my_remind_list[$j+1])) {
- $remind_question_id = $my_remind_list[$j+1];
- $current_question = $i + 1; // last question
- } else {
- $remind_question_id = -1; //We end the remind list we go to the exercise_reminder.php please
- $current_question = $i + 1; // last question
- }
- break 2;
- }
- }
- }
- }
- } else {
- if ($objExercise->review_answers) {
- header("Location: exercise_reminder.php?$params");
- exit;
- }
- }
- //var_dump($remind_question_id, $my_remind_list, $data_tracking, $current_question);
- }
- if ($objExercise->review_answers) {
- $script_php = 'exercise_reminder.php';
- } else {
- $script_php = 'exercise_result.php';
- }
- if (!empty($error)) {
- Display :: display_error_message($error, false);
- } else {
- if (!empty ($exercise_sound)) {
- echo "<a href=\"../document/download.php?doc_url=%2Faudio%2F" . Security::remove_XSS($exercise_sound) . "\" target=\"_blank\">", "<img src=\"../img/sound.gif\" border=\"0\" align=\"absmiddle\" alt=", get_lang('Sound') . "\" /></a>";
- }
- // Get number of hotspot questions for javascript validation
- $number_of_hotspot_questions = 0;
- $onsubmit = '';
- $i = 0;
- //i have a doubt in this line cvargas
- //var_dump($questionList);
- if (!strcmp($questionList[0], '') === 0) {
- foreach ($questionList as $questionId) {
- $i++;
- $objQuestionTmp = Question::read($questionId);
- // for sequential exercises
- if ($objExercise->type == ONE_PER_PAGE) {
- // if it is not the right question, goes to the next loop iteration
- if ($current_question != $i) {
- continue;
- } else {
- if ($objQuestionTmp->selectType() == HOT_SPOT || $objQuestionTmp->selectType() == HOT_SPOT_DELINEATION) {
- $number_of_hotspot_questions++;
- }
- break;
- }
- } else {
- if ($objQuestionTmp->selectType() == HOT_SPOT || $objQuestionTmp->selectType() == HOT_SPOT_DELINEATION) {
- $number_of_hotspot_questions++;
- }
- }
- }
- }
-
- if ($number_of_hotspot_questions > 0) {
- $onsubmit = "onsubmit=\"return validateFlashVar('" . $number_of_hotspot_questions . "', '" . get_lang('HotspotValidateError1') . "', '" . get_lang('HotspotValidateError2') . "');\"";
- }
-
- echo '<script>
-
- $(function() {
- //$(".exercise_save_now_button").hide();
- $(".main_question").mouseover(function() {
- //$(this).find(".exercise_save_now_button").show();
- //$(this).addClass("question_highlight");
- });
- $(".main_question").mouseout(function() {
- //$(this).find(".exercise_save_now_button").hide();
- $(this).removeClass("question_highlight");
- });
- });
-
- function previous_question(question_num) {
- url = "exercise_submit.php?'.$params.'&num="+question_num;
- window.location = url;
- }
-
- function save_now(question_id) {
- //1. Normal choice inputs
- var my_choice = $(\'*[name*="choice[\'+question_id+\']"]\').serialize();
-
- //2. Reminder checkbox
- var remind_list = $(\'*[name*="remind_list"]\').serialize();
-
- //3. Hotspots
- var hotspot = $(\'*[name*="hotspot[\'+question_id+\']"]\').serialize();
-
- //Checking FCK
- if (typeof(FCKeditorAPI) !== "undefined") {
- var oEditor = FCKeditorAPI.GetInstance("choice["+question_id+"]") ;
- var fck_content = "";
-
- if (oEditor) {
- fck_content = oEditor.GetHTML();
- my_choice = {};
- my_choice["choice["+question_id+"]"] = fck_content;
- my_choice = $.param(my_choice);
- }
- }
-
- if ($(\'input[name="remind_list[\'+question_id+\']"]\').is(\':checked\')) {
- $("#question_div_"+question_id).addClass("remind_highlight");
- } else {
- $("#question_div_"+question_id).removeClass("remind_highlight");
- }
-
- // Only for the first time
-
-
-
- $("#save_for_now_"+question_id).html("'.addslashes(Display::return_icon('loading1.gif')).'");
- $.ajax({
- url: "'.api_get_path(WEB_AJAX_PATH).'exercise.ajax.php?a=save_exercise_by_now",
- data: "'.$params.'&type=simple&question_id="+question_id+"&"+my_choice+"&"+hotspot+"&"+remind_list,
- success: function(return_value) {
- if (return_value == "ok") {
- $("#save_for_now_"+question_id).html("'.addslashes(Display::return_icon('accept.png', get_lang('Ok'), array(), 22)).'");
- } else if (return_value == "error") {
- $("#save_for_now_"+question_id).html("'.addslashes(Display::return_icon('error.png', get_lang('Error'), array(), 22)).'");
- } else if (return_value == "one_per_page") {
- var url = "";
- if ('.$reminder.' == 1 ) {
- url = "exercise_reminder.php?'.$params.'&num='.$current_question.'";
- } else if ('.$reminder.' == 2 ) {
- url = "exercise_submit.php?'.$params.'&num='.$current_question.'&remind_question_id='.$remind_question_id.'&reminder=2";
- } else {
- url = "exercise_submit.php?'.$params.'&num='.$current_question.'&remind_question_id='.$remind_question_id.'";
- }
- window.location = url;
-
- }
- },
- });
- return false;
- }
-
- function save_now_all(validate) {
- //1. Input choice
- var my_choice = $(\'*[name*="choice"]\').serialize();
-
- //2. Reminder
- var remind_list = $(\'*[name*="remind_list"]\').serialize();
-
- //3. Hotspots
- var hotspot = $(\'*[name*="hotspot"]\').serialize();
-
- //Question list
- var question_list = ['.implode(',', $questionList).'];
-
- var free_answers = {};
-
- $.each(question_list, function(index, my_question_id) {
- //Checking FCK
- if (typeof(FCKeditorAPI) !== "undefined") {
- var oEditor = FCKeditorAPI.GetInstance("choice["+my_question_id+"]") ;
- var fck_content = "";
- if (oEditor) {
- fck_content = oEditor.GetHTML();
- //alert(index + " " +my_question_id + " " +fck_content);
- free_answers["free_choice["+my_question_id+"]"] = fck_content;
- }
- }
- });
- //lok+(fgt)= data base
- free_answers = $.param(free_answers);
-
- $("#save_all_reponse").html("'.addslashes(Display::return_icon('loading1.gif')).'");
-
- $.ajax({
- url: "'.api_get_path(WEB_AJAX_PATH).'exercise.ajax.php?a=save_exercise_by_now",
- data: "'.$params.'&type=all&"+my_choice+"&"+hotspot+"&"+free_answers+"&"+remind_list,
- success: function(return_value) {
- if (return_value == "ok") {
- //$("#save_all_reponse").html("'.addslashes(Display::return_icon('accept.png')).'");
- if (validate == "validate") {
- window.location = "'.$script_php.'?'.$params.'";
- } else {
- $("#save_all_reponse").html("'.addslashes(Display::return_icon('accept.png')).'");
- }
- } else {
- $("#save_all_reponse").html("'.addslashes(Display::return_icon('wrong.gif')).'");
- }
- },
- });
- return false;
- }
-
- function validate_all() {
- save_now_all("validate");
- return false;
- }
- </script>';
- echo '<form id="exercise_form" method="post" action="'.api_get_self().'?'.api_get_cidreq().'&autocomplete=off&gradebook='.$gradebook."&exerciseId=" . $exerciseId .'" name="frm_exercise" '.$onsubmit.'>
- <input type="hidden" name="formSent" value="1" />
- <input type="hidden" name="exerciseId" value="'.$exerciseId . '" />
- <input type="hidden" name="num" value="'.$current_question . '" />
- <input type="hidden" name="exe_id" value="'.$exe_id . '" />
- <input type="hidden" name="origin" value="'.$origin . '" />
- <input type="hidden" name="learnpath_id" value="'.$safe_lp_id . '" />
- <input type="hidden" name="learnpath_item_id" value="'.$safe_lp_item_id . '" />
- <input type="hidden" name="learnpath_item_view_id" value="'.$safe_lp_item_view_id . '" />';
-
- //Show list of questions
- $i = 1;
-
- $attempt_list = array();
-
- if (isset($exe_id)) {
- $attempt_list = get_all_exercise_event_by_exe_id($exe_id);
- }
-
- if (!empty($attempt_list) && $current_question == 1) {
- //Display::display_normal_message(get_lang('YouTriedToResolveThisExerciseEarlier'));
- }
-
- $remind_list = array();
- if (isset($exercise_stat_info['questions_to_check']) && !empty($exercise_stat_info['questions_to_check'])) {
- $remind_list = explode(',', $exercise_stat_info['questions_to_check']);
- }
-
- foreach ($questionList as $questionId) {
-
- // for sequential exercises
- if ($objExercise->type == ONE_PER_PAGE) {
- // if it is not the right question, goes to the next loop iteration
- if ($current_question != $i) {
- $i++;
- continue;
- } else {
- if ($objExercise->feedbacktype != EXERCISE_FEEDBACK_TYPE_DIRECT) {
- // if the user has already answered this question
- if (isset($exerciseResult[$questionId])) {
- // construction of the Question object
- $objQuestionTmp = Question::read($questionId);
- $questionName = $objQuestionTmp->selectTitle();
- // destruction of the Question object
- unset ($objQuestionTmp);
- Display :: display_normal_message(get_lang('AlreadyAnswered'));
- $i++;
- break;
- }
- }
- }
- }
-
- $user_choice = $attempt_list[$questionId];
- $remind_highlight = '';
- $exercise_actions = '';
- $is_remind_on = false;
-
- $attributes = array('id' =>'remind_list['.$questionId.']');
- if (in_array($questionId, $remind_list)) {
- $is_remind_on = true;
- $attributes['checked'] = 1;
- $remind_question = true;
- $remind_highlight = ' remind_highlight ';
- }
-
- //Showing the question
-
- echo '<div id="question_div_'.$questionId.'" class="main_question '.$remind_highlight.'" >';
-
- // shows the question and its answers
- showQuestion($questionId, false, $origin, $i, true, false, $user_choice);
-
- if ($objExercise->type == ONE_PER_PAGE) {
- $exercise_actions .= $objExercise->show_button($questionId, $current_question);
- }
-
- if ($objExercise->type == ALL_ON_ONE_PAGE) {
- $button = '<a href="javascript://" class="a_button orange medium" onclick="save_now(\''.$questionId.'\'); ">'.get_lang('SaveForNow').'</a>';
- $button .= '<span id="save_for_now_'.$questionId.'"></span> ';
- $exercise_actions .= Display::span($button, array('class'=>'exercise_save_now_button'));
- }
-
- if ($objExercise->review_answers) {
- $remind_question_div = Display::input('checkbox', 'remind_list['.$questionId.']', '', $attributes);
- $remind_question_div .= Display::tag('label', get_lang('ReviewQuestionLater'), array('for' =>'remind_list['.$questionId.']'));
- $exercise_actions .= Display::span($remind_question_div, array('class'=>'exercise_save_now_button'));
- }
-
- echo Display::div($exercise_actions, array('class'=>'exercise_actions'));
-
- echo '</div>';
-
- $i++;
- // for sequential exercises
- if ($objExercise->type == ONE_PER_PAGE) {
- // quits the loop
- break;
- }
- }
- // end foreach()
- if ($objExercise->type == ALL_ON_ONE_PAGE) {
- $exercise_actions = $objExercise->show_button($questionId, $current_question);
- echo Display::div($exercise_actions, array('class'=>'exercise_actions'));
- }
- echo '</form>';
- }
- if ($origin != 'learnpath') {
- //so we are not in learnpath tool
- echo '</div>'; //End glossary div
- Display :: display_footer();
- } else {
- echo '</body></html>';
- }
|