');
}
$form->addElement('date_time_picker', 'start_time');
$form->addElement('html', '
');
$form->addElement(
'checkbox',
'activate_end_date_check',
null,
get_lang('Enable end time'),
['onclick' => 'activate_end_date()']
);
if (!empty($this->end_time)) {
$form->addElement('html', '
');
} else {
$form->addElement('html', '
');
}
$form->addElement('date_time_picker', 'end_time');
$form->addElement('html', '
');
$display = 'block';
$form->addElement(
'checkbox',
'propagate_neg',
null,
get_lang('Propagate negative results between questions')
);
$options = [
'' => get_lang('Please select an option'),
1 => get_lang('Save the correct answer for the next attempt'),
2 => get_lang('Pre-fill with answers from previous attempt'),
];
$form->addSelect(
'save_correct_answers',
get_lang('Save answers'),
$options
);
$form->addElement('html', '
');
$form->addElement('checkbox', 'review_answers', null, get_lang('Review my answers'));
$form->addElement('html', '
');
// Timer control
$form->addElement(
'checkbox',
'enabletimercontrol',
null,
get_lang('Enable time control'),
[
'onclick' => 'option_time_expired()',
'id' => 'enabletimercontrol',
'onload' => 'check_load_time()',
]
);
$expired_date = (int) $this->selectExpiredTime();
if (($expired_date != '0')) {
$form->addElement('html', '
');
} else {
$form->addElement('html', '
');
}
$form->addText(
'enabletimercontroltotalminutes',
get_lang('Total duration in minutes of the test'),
false,
[
'id' => 'enabletimercontroltotalminutes',
'cols-size' => [2, 2, 8],
]
);
$form->addElement('html', '
');
$form->addElement(
'text',
'pass_percentage',
[get_lang('Pass percentage'), null, '%'],
['id' => 'pass_percentage']
);
$form->addRule('pass_percentage', get_lang('Numericalal'), 'numeric');
$form->addRule('pass_percentage', get_lang('Value is too small.'), 'min_numeric_length', 0);
$form->addRule('pass_percentage', get_lang('Value is too big.'), 'max_numeric_length', 100);
// add the text_when_finished textbox
$form->addHtmlEditor(
'text_when_finished',
get_lang('Text appearing at the end of the test'),
false,
false,
$editor_config
);
$allow = api_get_configuration_value('allow_notification_setting_per_exercise');
if ($allow === true) {
$settings = ExerciseLib::getNotificationSettings();
$group = [];
foreach ($settings as $itemId => $label) {
$group[] = $form->createElement(
'checkbox',
'notifications[]',
null,
$label,
['value' => $itemId]
);
}
$form->addGroup($group, '', [get_lang('E-mail notifications')]);
}
$form->addCheckBox(
'update_title_in_lps',
null,
get_lang('Update this title in learning paths')
);
$defaults = [];
if (api_get_setting('search_enabled') === 'true') {
require_once api_get_path(LIBRARY_PATH).'specific_fields_manager.lib.php';
$form->addElement('checkbox', 'index_document', '', get_lang('Index document text?'));
$form->addSelectLanguage('language', get_lang('Document language for indexation'));
$specific_fields = get_specific_field_list();
foreach ($specific_fields as $specific_field) {
$form->addElement('text', $specific_field['code'], $specific_field['name']);
$filter = [
'c_id' => api_get_course_int_id(),
'field_id' => $specific_field['id'],
'ref_id' => $this->id,
'tool_id' => "'".TOOL_QUIZ."'",
];
$values = get_specific_field_values_list($filter, ['value']);
if (!empty($values)) {
$arr_str_values = [];
foreach ($values as $value) {
$arr_str_values[] = $value['value'];
}
$defaults[$specific_field['code']] = implode(', ', $arr_str_values);
}
}
}
$skillList = Skill::addSkillsToForm($form, ITEM_TYPE_EXERCISE, $this->iId);
$extraField = new ExtraField('exercise');
$extraField->addElements(
$form,
$this->iId,
[], //exclude
false, // filter
false, // tag as select
[], //show only fields
[], // order fields
[] // extra data
);
$form->addElement('html', '
'); //End advanced setting
$form->addElement('html', '
');
}
// submit
if (isset($_GET['exerciseId'])) {
$form->addButtonSave(get_lang('Edit test name and settings'), 'submitTest');
} else {
$form->addButtonUpdate(get_lang('Proceed to questions'), 'submitTest');
}
$form->addRule('exerciseTitle', get_lang('GiveTest name'), 'required');
// defaults
if ($type == 'full') {
// rules
$form->addRule('exerciseAttempts', get_lang('Numericalal'), 'numeric');
$form->addRule('start_time', get_lang('Invalid date'), 'datetime');
$form->addRule('end_time', get_lang('Invalid date'), 'datetime');
if ($this->id > 0) {
$defaults['randomQuestions'] = $this->random;
$defaults['randomAnswers'] = $this->getRandomAnswers();
$defaults['exerciseType'] = $this->selectType();
$defaults['exerciseTitle'] = $this->get_formated_title();
$defaults['exerciseDescription'] = $this->selectDescription();
$defaults['exerciseAttempts'] = $this->selectAttempts();
$defaults['exerciseFeedbackType'] = $this->getFeedbackType();
$defaults['results_disabled'] = $this->selectResultsDisabled();
$defaults['propagate_neg'] = $this->selectPropagateNeg();
$defaults['save_correct_answers'] = $this->getSaveCorrectAnswers();
$defaults['review_answers'] = $this->review_answers;
$defaults['randomByCat'] = $this->getRandomByCategory();
$defaults['text_when_finished'] = $this->getTextWhenFinished();
$defaults['display_category_name'] = $this->selectDisplayCategoryName();
$defaults['pass_percentage'] = $this->selectPassPercentage();
$defaults['question_selection_type'] = $this->getQuestionSelectionType();
$defaults['hide_question_title'] = $this->getHideQuestionTitle();
$defaults['show_previous_button'] = $this->showPreviousButton();
$defaults['exercise_category_id'] = $this->getExerciseCategoryId();
if (!empty($this->start_time)) {
$defaults['activate_start_date_check'] = 1;
}
if (!empty($this->end_time)) {
$defaults['activate_end_date_check'] = 1;
}
$defaults['start_time'] = !empty($this->start_time) ? api_get_local_time($this->start_time) : date('Y-m-d 12:00:00');
$defaults['end_time'] = !empty($this->end_time) ? api_get_local_time($this->end_time) : date('Y-m-d 12:00:00', time() + 84600);
// Get expired time
if ($this->expired_time != '0') {
$defaults['enabletimercontrol'] = 1;
$defaults['enabletimercontroltotalminutes'] = $this->expired_time;
} else {
$defaults['enabletimercontroltotalminutes'] = 0;
}
$defaults['skills'] = array_keys($skillList);
$defaults['notifications'] = $this->getNotifications();
} else {
$defaults['exerciseType'] = 2;
$defaults['exerciseAttempts'] = 0;
$defaults['randomQuestions'] = 0;
$defaults['randomAnswers'] = 0;
$defaults['exerciseDescription'] = '';
$defaults['exerciseFeedbackType'] = 0;
$defaults['results_disabled'] = 0;
$defaults['randomByCat'] = 0;
$defaults['text_when_finished'] = '';
$defaults['start_time'] = date('Y-m-d 12:00:00');
$defaults['display_category_name'] = 1;
$defaults['end_time'] = date('Y-m-d 12:00:00', time() + 84600);
$defaults['pass_percentage'] = '';
$defaults['end_button'] = $this->selectEndButton();
$defaults['question_selection_type'] = 1;
$defaults['hide_question_title'] = 0;
$defaults['show_previous_button'] = 1;
$defaults['on_success_message'] = null;
$defaults['on_failed_message'] = null;
}
} else {
$defaults['exerciseTitle'] = $this->selectTitle();
$defaults['exerciseDescription'] = $this->selectDescription();
}
if (api_get_setting('search_enabled') === 'true') {
$defaults['index_document'] = 'checked="checked"';
}
$this->setPageResultConfigurationDefaults($defaults);
$form->setDefaults($defaults);
// Freeze some elements.
if ($this->id != 0 && $this->edit_exercise_in_lp == false) {
$elementsToFreeze = [
'randomQuestions',
//'randomByCat',
'exerciseAttempts',
'propagate_neg',
'enabletimercontrol',
'review_answers',
];
foreach ($elementsToFreeze as $elementName) {
/** @var HTML_QuickForm_element $element */
$element = $form->getElement($elementName);
$element->freeze();
}
}
}
/**
* @param $form
*/
public function setResultFeedbackGroup(FormValidator $form)
{
// Feedback type.
$feedback = [];
$feedback[] = $form->createElement(
'radio',
'exerciseFeedbackType',
null,
get_lang('At end of test'),
EXERCISE_FEEDBACK_TYPE_END,
[
'id' => 'exerciseType_'.EXERCISE_FEEDBACK_TYPE_END,
'onclick' => 'check_feedback()',
]
);
if (api_get_setting('enable_quiz_scenario') === 'true') {
// Can't convert a question from one feedback to another
// if there is more than 1 question already added
if ($this->selectNbrQuestions() == 0) {
$feedback[] = $form->createElement(
'radio',
'exerciseFeedbackType',
null,
get_lang('Adaptative test with immediate feedback'),
EXERCISE_FEEDBACK_TYPE_DIRECT,
[
'id' => 'exerciseType_'.EXERCISE_FEEDBACK_TYPE_DIRECT,
'onclick' => 'check_direct_feedback()',
]
);
}
}
$feedback[] = $form->createElement(
'radio',
'exerciseFeedbackType',
null,
get_lang('Direct feedback as pop-up'),
EXERCISE_FEEDBACK_TYPE_POPUP,
['id' => 'exerciseType_'.EXERCISE_FEEDBACK_TYPE_POPUP, 'onclick' => 'check_direct_feedback()']
);
$feedback[] = $form->createElement(
'radio',
'exerciseFeedbackType',
null,
get_lang('Exam (no feedback)'),
EXERCISE_FEEDBACK_TYPE_EXAM,
['id' => 'exerciseType_'.EXERCISE_FEEDBACK_TYPE_EXAM]
);
$form->addGroup(
$feedback,
null,
[
get_lang('Feedback'),
get_lang('How should we show the feedback/comment for each question? This option defines how it will be shown to the learner when taking the test. We recommend you try different options by editing your test options before having learners take it.'),
]
);
}
/**
* function which process the creation of exercises.
*
* @param FormValidator $form
*
* @return int c_quiz.iid
*/
public function processCreation($form)
{
$this->updateTitle(self::format_title_variable($form->getSubmitValue('exerciseTitle')));
$this->updateDescription($form->getSubmitValue('exerciseDescription'));
$this->updateAttempts($form->getSubmitValue('exerciseAttempts'));
$this->updateFeedbackType($form->getSubmitValue('exerciseFeedbackType'));
$this->updateType($form->getSubmitValue('exerciseType'));
$this->setRandom($form->getSubmitValue('randomQuestions'));
$this->updateRandomAnswers($form->getSubmitValue('randomAnswers'));
$this->updateResultsDisabled($form->getSubmitValue('results_disabled'));
$this->updateExpiredTime($form->getSubmitValue('enabletimercontroltotalminutes'));
$this->updatePropagateNegative($form->getSubmitValue('propagate_neg'));
$this->updateSaveCorrectAnswers($form->getSubmitValue('save_correct_answers'));
$this->updateRandomByCat($form->getSubmitValue('randomByCat'));
$this->updateTextWhenFinished($form->getSubmitValue('text_when_finished'));
$this->updateDisplayCategoryName($form->getSubmitValue('display_category_name'));
$this->updateReviewAnswers($form->getSubmitValue('review_answers'));
$this->updatePassPercentage($form->getSubmitValue('pass_percentage'));
$this->updateCategories($form->getSubmitValue('category'));
$this->updateEndButton($form->getSubmitValue('end_button'));
$this->setOnSuccessMessage($form->getSubmitValue('on_success_message'));
$this->setOnFailedMessage($form->getSubmitValue('on_failed_message'));
$this->updateEmailNotificationTemplate($form->getSubmitValue('email_notification_template'));
$this->setEmailNotificationTemplateToUser($form->getSubmitValue('email_notification_template_to_user'));
$this->setNotifyUserByEmail($form->getSubmitValue('notify_user_by_email'));
$this->setModelType($form->getSubmitValue('model_type'));
$this->setQuestionSelectionType($form->getSubmitValue('question_selection_type'));
$this->setHideQuestionTitle($form->getSubmitValue('hide_question_title'));
$this->sessionId = api_get_session_id();
$this->setQuestionSelectionType($form->getSubmitValue('question_selection_type'));
$this->setScoreTypeModel($form->getSubmitValue('score_type_model'));
$this->setGlobalCategoryId($form->getSubmitValue('global_category_id'));
$this->setShowPreviousButton($form->getSubmitValue('show_previous_button'));
$this->setNotifications($form->getSubmitValue('notifications'));
$this->setExerciseCategoryId($form->getSubmitValue('exercise_category_id'));
$this->setPageResultConfiguration($form->getSubmitValues());
$this->start_time = null;
if ($form->getSubmitValue('activate_start_date_check') == 1) {
$start_time = $form->getSubmitValue('start_time');
$this->start_time = api_get_utc_datetime($start_time);
}
$this->end_time = null;
if ($form->getSubmitValue('activate_end_date_check') == 1) {
$end_time = $form->getSubmitValue('end_time');
$this->end_time = api_get_utc_datetime($end_time);
}
$this->expired_time = 0;
if ($form->getSubmitValue('enabletimercontrol') == 1) {
$expired_total_time = $form->getSubmitValue('enabletimercontroltotalminutes');
if ($this->expired_time == 0) {
$this->expired_time = $expired_total_time;
}
}
$this->random_answers = 0;
if ($form->getSubmitValue('randomAnswers') == 1) {
$this->random_answers = 1;
}
// Update title in all LPs that have this quiz added
if ($form->getSubmitValue('update_title_in_lps') == 1) {
$courseId = api_get_course_int_id();
$table = Database::get_course_table(TABLE_LP_ITEM);
$sql = "SELECT * FROM $table
WHERE
c_id = $courseId AND
item_type = 'quiz' AND
path = '".$this->id."'
";
$result = Database::query($sql);
$items = Database::store_result($result);
if (!empty($items)) {
foreach ($items as $item) {
$itemId = $item['iid'];
$sql = "UPDATE $table SET title = '".$this->title."'
WHERE iid = $itemId AND c_id = $courseId ";
Database::query($sql);
}
}
}
$iId = $this->save();
if (!empty($iId)) {
$values = $form->getSubmitValues();
$values['item_id'] = $iId;
$extraFieldValue = new ExtraFieldValue('exercise');
$extraFieldValue->saveFieldValues($values);
Skill::saveSkills($form, ITEM_TYPE_EXERCISE, $iId);
}
}
public function search_engine_save()
{
if ($_POST['index_document'] != 1) {
return;
}
$course_id = api_get_course_id();
require_once api_get_path(LIBRARY_PATH).'specific_fields_manager.lib.php';
$specific_fields = get_specific_field_list();
$ic_slide = new IndexableChunk();
$all_specific_terms = '';
foreach ($specific_fields as $specific_field) {
if (isset($_REQUEST[$specific_field['code']])) {
$sterms = trim($_REQUEST[$specific_field['code']]);
if (!empty($sterms)) {
$all_specific_terms .= ' '.$sterms;
$sterms = explode(',', $sterms);
foreach ($sterms as $sterm) {
$ic_slide->addTerm(trim($sterm), $specific_field['code']);
add_specific_field_value($specific_field['id'], $course_id, TOOL_QUIZ, $this->id, $sterm);
}
}
}
}
// build the chunk to index
$ic_slide->addValue("title", $this->exercise);
$ic_slide->addCourseId($course_id);
$ic_slide->addToolId(TOOL_QUIZ);
$xapian_data = [
SE_COURSE_ID => $course_id,
SE_TOOL_ID => TOOL_QUIZ,
SE_DATA => ['type' => SE_DOCTYPE_EXERCISE_EXERCISE, 'exercise_id' => (int) $this->id],
SE_USER => (int) api_get_user_id(),
];
$ic_slide->xapian_data = serialize($xapian_data);
$exercise_description = $all_specific_terms.' '.$this->description;
$ic_slide->addValue("content", $exercise_description);
$di = new ChamiloIndexer();
isset($_POST['language']) ? $lang = Database::escape_string($_POST['language']) : $lang = 'english';
$di->connectDb(null, null, $lang);
$di->addChunk($ic_slide);
//index and return search engine document id
$did = $di->index();
if ($did) {
// save it to db
$tbl_se_ref = Database::get_main_table(TABLE_MAIN_SEARCH_ENGINE_REF);
$sql = 'INSERT INTO %s (id, course_code, tool_id, ref_id_high_level, search_did)
VALUES (NULL , \'%s\', \'%s\', %s, %s)';
$sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $this->id, $did);
Database::query($sql);
}
}
public function search_engine_edit()
{
// update search enchine and its values table if enabled
if (api_get_setting('search_enabled') == 'true' && extension_loaded('xapian')) {
$course_id = api_get_course_id();
// actually, it consists on delete terms from db,
// insert new ones, create a new search engine document, and remove the old one
// get search_did
$tbl_se_ref = Database::get_main_table(TABLE_MAIN_SEARCH_ENGINE_REF);
$sql = 'SELECT * FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s LIMIT 1';
$sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $this->id);
$res = Database::query($sql);
if (Database::num_rows($res) > 0) {
require_once api_get_path(LIBRARY_PATH).'specific_fields_manager.lib.php';
$se_ref = Database::fetch_array($res);
$specific_fields = get_specific_field_list();
$ic_slide = new IndexableChunk();
$all_specific_terms = '';
foreach ($specific_fields as $specific_field) {
delete_all_specific_field_value($course_id, $specific_field['id'], TOOL_QUIZ, $this->id);
if (isset($_REQUEST[$specific_field['code']])) {
$sterms = trim($_REQUEST[$specific_field['code']]);
$all_specific_terms .= ' '.$sterms;
$sterms = explode(',', $sterms);
foreach ($sterms as $sterm) {
$ic_slide->addTerm(trim($sterm), $specific_field['code']);
add_specific_field_value($specific_field['id'], $course_id, TOOL_QUIZ, $this->id, $sterm);
}
}
}
// build the chunk to index
$ic_slide->addValue('title', $this->exercise);
$ic_slide->addCourseId($course_id);
$ic_slide->addToolId(TOOL_QUIZ);
$xapian_data = [
SE_COURSE_ID => $course_id,
SE_TOOL_ID => TOOL_QUIZ,
SE_DATA => ['type' => SE_DOCTYPE_EXERCISE_EXERCISE, 'exercise_id' => (int) $this->id],
SE_USER => (int) api_get_user_id(),
];
$ic_slide->xapian_data = serialize($xapian_data);
$exercise_description = $all_specific_terms.' '.$this->description;
$ic_slide->addValue("content", $exercise_description);
$di = new ChamiloIndexer();
isset($_POST['language']) ? $lang = Database::escape_string($_POST['language']) : $lang = 'english';
$di->connectDb(null, null, $lang);
$di->remove_document($se_ref['search_did']);
$di->addChunk($ic_slide);
//index and return search engine document id
$did = $di->index();
if ($did) {
// save it to db
$sql = 'DELETE FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=\'%s\'';
$sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $this->id);
Database::query($sql);
$sql = 'INSERT INTO %s (id, course_code, tool_id, ref_id_high_level, search_did)
VALUES (NULL , \'%s\', \'%s\', %s, %s)';
$sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $this->id, $did);
Database::query($sql);
}
} else {
$this->search_engine_save();
}
}
}
public function search_engine_delete()
{
// remove from search engine if enabled
if (api_get_setting('search_enabled') == 'true' && extension_loaded('xapian')) {
$course_id = api_get_course_id();
$tbl_se_ref = Database::get_main_table(TABLE_MAIN_SEARCH_ENGINE_REF);
$sql = 'SELECT * FROM %s
WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s AND ref_id_second_level IS NULL
LIMIT 1';
$sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $this->id);
$res = Database::query($sql);
if (Database::num_rows($res) > 0) {
$row = Database::fetch_array($res);
$di = new ChamiloIndexer();
$di->remove_document($row['search_did']);
unset($di);
$tbl_quiz_question = Database::get_course_table(TABLE_QUIZ_QUESTION);
foreach ($this->questionList as $question_i) {
$sql = 'SELECT type FROM %s WHERE id=%s';
$sql = sprintf($sql, $tbl_quiz_question, $question_i);
$qres = Database::query($sql);
if (Database::num_rows($qres) > 0) {
$qrow = Database::fetch_array($qres);
$objQuestion = Question::getInstance($qrow['type']);
$objQuestion = Question::read((int) $question_i);
$objQuestion->search_engine_edit($this->id, false, true);
unset($objQuestion);
}
}
}
$sql = 'DELETE FROM %s
WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s AND ref_id_second_level IS NULL
LIMIT 1';
$sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_QUIZ, $this->id);
Database::query($sql);
// remove terms from db
require_once api_get_path(LIBRARY_PATH).'specific_fields_manager.lib.php';
delete_all_values_for_item($course_id, TOOL_QUIZ, $this->id);
}
}
public function selectExpiredTime()
{
return $this->expired_time;
}
/**
* Cleans the student's results only for the Exercise tool (Not from the LP)
* The LP results are NOT deleted by default, otherwise put $cleanLpTests = true
* Works with exercises in sessions.
*
* @param bool $cleanLpTests
* @param string $cleanResultBeforeDate
*
* @return int quantity of user's exercises deleted
*/
public function cleanResults($cleanLpTests = false, $cleanResultBeforeDate = null)
{
$sessionId = api_get_session_id();
$table_track_e_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$table_track_e_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);
$sql_where = ' AND
orig_lp_id = 0 AND
orig_lp_item_id = 0';
// if we want to delete results from LP too
if ($cleanLpTests) {
$sql_where = '';
}
// if we want to delete attempts before date $cleanResultBeforeDate
// $cleanResultBeforeDate must be a valid UTC-0 date yyyy-mm-dd
if (!empty($cleanResultBeforeDate)) {
$cleanResultBeforeDate = Database::escape_string($cleanResultBeforeDate);
if (api_is_valid_date($cleanResultBeforeDate)) {
$sql_where .= " AND exe_date <= '$cleanResultBeforeDate' ";
} else {
return 0;
}
}
$sql = "SELECT exe_id
FROM $table_track_e_exercises
WHERE
c_id = ".api_get_course_int_id()." AND
exe_exo_id = ".$this->id." AND
session_id = ".$sessionId." ".
$sql_where;
$result = Database::query($sql);
$exe_list = Database::store_result($result);
// deleting TRACK_E_ATTEMPT table
// check if exe in learning path or not
$i = 0;
if (is_array($exe_list) && count($exe_list) > 0) {
foreach ($exe_list as $item) {
$sql = "DELETE FROM $table_track_e_attempt
WHERE exe_id = '".$item['exe_id']."'";
Database::query($sql);
$i++;
}
}
// delete TRACK_E_EXERCISES table
$sql = "DELETE FROM $table_track_e_exercises
WHERE
c_id = ".api_get_course_int_id()." AND
exe_exo_id = ".$this->id." $sql_where AND
session_id = ".$sessionId;
Database::query($sql);
$this->generateStats($this->id, api_get_course_info(), $sessionId);
Event::addEvent(
LOG_EXERCISE_RESULT_DELETE,
LOG_EXERCISE_ID,
$this->id,
null,
null,
api_get_course_int_id(),
$sessionId
);
return $i;
}
/**
* Copies an exercise (duplicate all questions and answers).
*/
public function copyExercise()
{
$exerciseObject = $this;
$categories = $exerciseObject->getCategoriesInExercise();
// Get all questions no matter the order/category settings
$questionList = $exerciseObject->getQuestionOrderedList();
// Force the creation of a new exercise
$exerciseObject->updateTitle($exerciseObject->selectTitle().' - '.get_lang('Copy'));
// Hides the new exercise
$exerciseObject->updateStatus(false);
$exerciseObject->updateId(0);
$exerciseObject->sessionId = api_get_session_id();
$exerciseObject->save();
$newId = $exerciseObject->selectId();
if ($newId && !empty($questionList)) {
// Question creation
foreach ($questionList as $oldQuestionId) {
$oldQuestionObj = Question::read($oldQuestionId);
$newQuestionId = $oldQuestionObj->duplicate();
if ($newQuestionId) {
$newQuestionObj = Question::read($newQuestionId);
if (isset($newQuestionObj) && $newQuestionObj) {
$newQuestionObj->addToList($newId);
if (!empty($oldQuestionObj->category)) {
$newQuestionObj->saveCategory($oldQuestionObj->category);
}
// This should be moved to the duplicate function
$newAnswerObj = new Answer($oldQuestionId);
$newAnswerObj->read();
$newAnswerObj->duplicate($newQuestionObj);
}
}
}
if (!empty($categories)) {
$newCategoryList = [];
foreach ($categories as $category) {
$newCategoryList[$category['category_id']] = $category['count_questions'];
}
$exerciseObject->save_categories_in_exercise($newCategoryList);
}
}
}
/**
* Changes the exercise status.
*
* @param string $status - exercise status
*/
public function updateStatus($status)
{
$this->active = $status;
}
/**
* @param int $lp_id
* @param int $lp_item_id
* @param int $lp_item_view_id
* @param string $status
*
* @return array
*/
public function get_stat_track_exercise_info(
$lp_id = 0,
$lp_item_id = 0,
$lp_item_view_id = 0,
$status = 'incomplete'
) {
$track_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
if (empty($lp_id)) {
$lp_id = 0;
}
if (empty($lp_item_id)) {
$lp_item_id = 0;
}
if (empty($lp_item_view_id)) {
$lp_item_view_id = 0;
}
$condition = ' WHERE exe_exo_id = '."'".$this->id."'".' AND
exe_user_id = '."'".api_get_user_id()."'".' AND
c_id = '.api_get_course_int_id().' AND
status = '."'".Database::escape_string($status)."'".' AND
orig_lp_id = '."'".$lp_id."'".' AND
orig_lp_item_id = '."'".$lp_item_id."'".' AND
orig_lp_item_view_id = '."'".$lp_item_view_id."'".' AND
session_id = '."'".api_get_session_id()."' LIMIT 1"; //Adding limit 1 just in case
$sql_track = 'SELECT * FROM '.$track_exercises.$condition;
$result = Database::query($sql_track);
$new_array = [];
if (Database::num_rows($result) > 0) {
$new_array = Database::fetch_array($result, 'ASSOC');
$new_array['num_exe'] = Database::num_rows($result);
}
return $new_array;
}
/**
* Saves a test attempt.
*
* @param int $clock_expired_time clock_expired_time
* @param int int lp id
* @param int int lp item id
* @param int int lp item_view id
* @param array $questionList
* @param float $weight
*
* @return int
*/
public function save_stat_track_exercise_info(
$clock_expired_time = 0,
$safe_lp_id = 0,
$safe_lp_item_id = 0,
$safe_lp_item_view_id = 0,
$questionList = [],
$weight = 0
) {
$track_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$safe_lp_id = (int) $safe_lp_id;
$safe_lp_item_id = (int) $safe_lp_item_id;
$safe_lp_item_view_id = (int) $safe_lp_item_view_id;
if (empty($clock_expired_time)) {
$clock_expired_time = null;
}
$questionList = array_map('intval', $questionList);
$params = [
'exe_exo_id' => $this->id,
'exe_user_id' => api_get_user_id(),
'c_id' => api_get_course_int_id(),
'status' => 'incomplete',
'session_id' => api_get_session_id(),
'data_tracking' => implode(',', $questionList),
'start_date' => api_get_utc_datetime(),
'orig_lp_id' => $safe_lp_id,
'orig_lp_item_id' => $safe_lp_item_id,
'orig_lp_item_view_id' => $safe_lp_item_view_id,
'max_score' => $weight,
'user_ip' => Database::escape_string(api_get_real_ip()),
'exe_date' => api_get_utc_datetime(),
'score' => 0,
'steps_counter' => 0,
'exe_duration' => 0,
'expired_time_control' => $clock_expired_time,
'questions_to_check' => '',
];
$id = Database::insert($track_exercises, $params);
return $id;
}
/**
* @param int $question_id
* @param int $questionNum
* @param array $questions_in_media
* @param string $currentAnswer
* @param array $myRemindList
*
* @return string
*/
public function show_button(
$question_id,
$questionNum,
$questions_in_media = [],
$currentAnswer = '',
$myRemindList = []
) {
global $safe_lp_id, $safe_lp_item_id, $safe_lp_item_view_id;
$nbrQuestions = $this->getQuestionCount();
$buttonList = [];
$html = $label = '';
$hotspot_get = isset($_POST['hotspot']) ? Security::remove_XSS($_POST['hotspot']) : null;
if (in_array($this->getFeedbackType(), [EXERCISE_FEEDBACK_TYPE_DIRECT, EXERCISE_FEEDBACK_TYPE_POPUP]) &&
$this->type == ONE_PER_PAGE
) {
$urlTitle = get_lang('Proceed with the test');
if ($questionNum == count($this->questionList)) {
$urlTitle = get_lang('End test');
}
$url = api_get_path(WEB_CODE_PATH).'exercise/exercise_submit_modal.php?'.api_get_cidreq();
$url .= '&'.http_build_query([
'learnpath_id' => $safe_lp_id,
'learnpath_item_id' => $safe_lp_item_id,
'learnpath_item_view_id' => $safe_lp_item_view_id,
'hotspot' => $hotspot_get,
'nbrQuestions' => $nbrQuestions,
'num' => $questionNum,
'exerciseType' => $this->type,
'exerciseId' => $this->id,
'reminder' => empty($myRemindList) ? null : 2,
]);
$params = [
'class' => 'ajax btn btn-default no-close-button',
'data-title' => Security::remove_XSS(get_lang('Comment')),
'data-size' => 'md',
'id' => "button_$question_id",
];
if ($this->getFeedbackType() === EXERCISE_FEEDBACK_TYPE_POPUP) {
//$params['data-block-div-after-closing'] = "question_div_$question_id";
$params['data-block-closing'] = 'true';
}
$html .= Display::url(
$urlTitle,
$url,
$params
);
$html .= '
';
} else {
// User
if (api_is_allowed_to_session_edit()) {
$endReminderValue = false;
if (!empty($myRemindList)) {
$endValue = end($myRemindList);
if ($endValue == $question_id) {
$endReminderValue = true;
}
}
if ($this->type == ALL_ON_ONE_PAGE || $nbrQuestions == $questionNum || $endReminderValue) {
if ($this->review_answers) {
$label = get_lang('Review selected questions');
$class = 'btn btn-success';
} else {
$label = get_lang('End test');
$class = 'btn btn-warning';
}
} else {
$label = get_lang('Next question');
$class = 'btn btn-primary';
}
// used to select it with jquery
$class .= ' question-validate-btn';
if ($this->type == ONE_PER_PAGE) {
if ($questionNum != 1) {
if ($this->showPreviousButton()) {
$prev_question = $questionNum - 2;
$showPreview = true;
if (!empty($myRemindList)) {
$beforeId = null;
for ($i = 0; $i < count($myRemindList); $i++) {
if (isset($myRemindList[$i]) && $myRemindList[$i] == $question_id) {
$beforeId = isset($myRemindList[$i - 1]) ? $myRemindList[$i - 1] : null;
break;
}
}
if (empty($beforeId)) {
$showPreview = false;
} else {
$num = 0;
foreach ($this->questionList as $originalQuestionId) {
if ($originalQuestionId == $beforeId) {
break;
}
$num++;
}
$prev_question = $num;
}
}
if ($showPreview) {
$buttonList[] = Display::button(
'previous_question_and_save',
get_lang('Previous question'),
[
'type' => 'button',
'class' => 'btn btn-default',
'data-prev' => $prev_question,
'data-question' => $question_id,
]
);
}
}
}
// Next question
if (!empty($questions_in_media)) {
$buttonList[] = Display::button(
'save_question_list',
$label,
[
'type' => 'button',
'class' => $class,
'data-list' => implode(",", $questions_in_media),
]
);
} else {
$buttonList[] = Display::button(
'save_now',
$label,
['type' => 'button', 'class' => $class, 'data-question' => $question_id]
);
}
$buttonList[] = '
';
$html .= implode(PHP_EOL, $buttonList);
} else {
if ($this->review_answers) {
$all_label = get_lang('Review selected questions');
$class = 'btn btn-success';
} else {
$all_label = get_lang('End test');
$class = 'btn btn-warning';
}
// used to select it with jquery
$class .= ' question-validate-btn';
$buttonList[] = Display::button(
'validate_all',
$all_label,
['type' => 'button', 'class' => $class]
);
$buttonList[] = ' '.Display::span(null, ['id' => 'save_all_response']);
$html .= implode(PHP_EOL, $buttonList);
}
}
}
return $html;
}
/**
* @param int $timeLeft in seconds
* @param string $url
*
* @return string
*/
public function showSimpleTimeControl($timeLeft, $url = '')
{
$timeLeft = (int) $timeLeft;
return "";
}
/**
* So the time control will work.
*
* @param int $timeLeft
*
* @return string
*/
public function showTimeControlJS($timeLeft)
{
$timeLeft = (int) $timeLeft;
$script = 'redirectExerciseToResult();';
if ($this->type == ALL_ON_ONE_PAGE) {
$script = "save_now_all('validate');";
}
return "";
}
/**
* This function was originally found in the exercise_show.php.
*
* @param int $exeId
* @param int $questionId
* @param mixed $choice the user-selected option
* @param string $from function is called from 'exercise_show' or
* 'exercise_result'
* @param array $exerciseResultCoordinates the hotspot coordinates $hotspot[$question_id] =
* coordinates
* @param bool $saved_results save results in the DB or just show the reponse
* @param bool $from_database gets information from DB or from the current selection
* @param bool $show_result show results or not
* @param int $propagate_neg
* @param array $hotspot_delineation_result
* @param bool $showTotalScoreAndUserChoicesInLastAttempt
* @param bool $updateResults
* @param bool $showHotSpotDelineationTable
*
* @todo reduce parameters of this function
*
* @return string html code
*/
public function manage_answer(
$exeId,
$questionId,
$choice,
$from = 'exercise_show',
$exerciseResultCoordinates = [],
$saved_results = true,
$from_database = false,
$show_result = true,
$propagate_neg = 0,
$hotspot_delineation_result = [],
$showTotalScoreAndUserChoicesInLastAttempt = true,
$updateResults = false,
$showHotSpotDelineationTable = false
) {
$debug = false;
//needed in order to use in the exercise_attempt() for the time
global $learnpath_id, $learnpath_item_id;
require_once api_get_path(LIBRARY_PATH).'geometry.lib.php';
$em = Database::getManager();
$feedback_type = $this->getFeedbackType();
$results_disabled = $this->selectResultsDisabled();
if ($debug) {
error_log("<------ manage_answer ------> ");
error_log('exe_id: '.$exeId);
error_log('$from: '.$from);
error_log('$saved_results: '.intval($saved_results));
error_log('$from_database: '.intval($from_database));
error_log('$show_result: '.intval($show_result));
error_log('$propagate_neg: '.$propagate_neg);
error_log('$exerciseResultCoordinates: '.print_r($exerciseResultCoordinates, 1));
error_log('$hotspot_delineation_result: '.print_r($hotspot_delineation_result, 1));
error_log('$learnpath_id: '.$learnpath_id);
error_log('$learnpath_item_id: '.$learnpath_item_id);
error_log('$choice: '.print_r($choice, 1));
}
$final_overlap = 0;
$final_missing = 0;
$final_excess = 0;
$overlap_color = 0;
$missing_color = 0;
$excess_color = 0;
$threadhold1 = 0;
$threadhold2 = 0;
$threadhold3 = 0;
$arrques = null;
$arrans = null;
$studentChoice = null;
$expectedAnswer = '';
$calculatedChoice = '';
$calculatedStatus = '';
$questionId = (int) $questionId;
$exeId = (int) $exeId;
$TBL_TRACK_ATTEMPT = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);
$table_ans = Database::get_course_table(TABLE_QUIZ_ANSWER);
$studentChoiceDegree = null;
// Creates a temporary Question object
$course_id = $this->course_id;
$objQuestionTmp = Question::read($questionId, $this->course);
if ($objQuestionTmp === false) {
return false;
}
$questionName = $objQuestionTmp->selectTitle();
$questionWeighting = $objQuestionTmp->selectWeighting();
$answerType = $objQuestionTmp->selectType();
$quesId = $objQuestionTmp->selectId();
$extra = $objQuestionTmp->extra;
$next = 1; //not for now
$totalWeighting = 0;
$totalScore = 0;
// Extra information of the question
if ((
$answerType == MULTIPLE_ANSWER_TRUE_FALSE ||
$answerType == MULTIPLE_ANSWER_TRUE_FALSE_DEGREE_CERTAINTY
)
&& !empty($extra)
) {
$extra = explode(':', $extra);
if ($debug) {
error_log(print_r($extra, 1));
}
// Fixes problems with negatives values using intval
$true_score = floatval(trim($extra[0]));
$false_score = floatval(trim($extra[1]));
$doubt_score = floatval(trim($extra[2]));
}
// Construction of the Answer object
$objAnswerTmp = new Answer($questionId, $course_id);
$nbrAnswers = $objAnswerTmp->selectNbrAnswers();
if ($debug) {
error_log('Count of answers: '.$nbrAnswers);
error_log('$answerType: '.$answerType);
}
if ($answerType == MULTIPLE_ANSWER_TRUE_FALSE_DEGREE_CERTAINTY) {
$choiceTmp = $choice;
$choice = isset($choiceTmp['choice']) ? $choiceTmp['choice'] : '';
$choiceDegreeCertainty = isset($choiceTmp['choiceDegreeCertainty']) ? $choiceTmp['choiceDegreeCertainty'] : '';
}
if ($answerType == FREE_ANSWER ||
$answerType == ORAL_EXPRESSION ||
$answerType == CALCULATED_ANSWER ||
$answerType == ANNOTATION
) {
$nbrAnswers = 1;
}
$generatedFile = '';
if ($answerType == ORAL_EXPRESSION) {
$exe_info = Event::get_exercise_results_by_attempt($exeId);
$exe_info = isset($exe_info[$exeId]) ? $exe_info[$exeId] : null;
$objQuestionTmp->initFile(
api_get_session_id(),
isset($exe_info['exe_user_id']) ? $exe_info['exe_user_id'] : api_get_user_id(),
isset($exe_info['exe_exo_id']) ? $exe_info['exe_exo_id'] : $this->id,
isset($exe_info['exe_id']) ? $exe_info['exe_id'] : $exeId
);
// Probably this attempt came in an exercise all question by page
if ($feedback_type == 0) {
$objQuestionTmp->replaceWithRealExe($exeId);
}
$generatedFile = $objQuestionTmp->getFileUrl();
}
$user_answer = '';
// Get answer list for matching
$sql = "SELECT id_auto, id, answer
FROM $table_ans
WHERE c_id = $course_id AND question_id = $questionId";
$res_answer = Database::query($sql);
$answerMatching = [];
while ($real_answer = Database::fetch_array($res_answer)) {
$answerMatching[$real_answer['id_auto']] = $real_answer['answer'];
}
$real_answers = [];
$quiz_question_options = Question::readQuestionOption(
$questionId,
$course_id
);
$organs_at_risk_hit = 0;
$questionScore = 0;
$orderedHotSpots = [];
if ($answerType == HOT_SPOT || $answerType == ANNOTATION) {
$orderedHotSpots = $em->getRepository('ChamiloCoreBundle:TrackEHotspot')->findBy(
[
'hotspotQuestionId' => $questionId,
'course' => $course_id,
'hotspotExeId' => $exeId,
],
['hotspotAnswerId' => 'ASC']
);
}
if ($debug) {
error_log('Start answer loop ');
}
$answerDestination = null;
$userAnsweredQuestion = false;
$correctAnswerId = null;
for ($answerId = 1; $answerId <= $nbrAnswers; $answerId++) {
$answer = $objAnswerTmp->selectAnswer($answerId);
$answerComment = $objAnswerTmp->selectComment($answerId);
$answerCorrect = $objAnswerTmp->isCorrect($answerId);
$answerWeighting = (float) $objAnswerTmp->selectWeighting($answerId);
$answerAutoId = $objAnswerTmp->selectAutoId($answerId);
$answerIid = isset($objAnswerTmp->iid[$answerId]) ? (int) $objAnswerTmp->iid[$answerId] : 0;
if ($debug) {
error_log("answer auto id: $answerAutoId ");
error_log("answer correct: $answerCorrect ");
}
// Delineation
$delineation_cord = $objAnswerTmp->selectHotspotCoordinates(1);
$answer_delineation_destination = $objAnswerTmp->selectDestination(1);
switch ($answerType) {
case UNIQUE_ANSWER:
case UNIQUE_ANSWER_IMAGE:
case UNIQUE_ANSWER_NO_OPTION:
case READING_COMPREHENSION:
if ($from_database) {
$sql = "SELECT answer FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND
question_id = $questionId";
$result = Database::query($sql);
$choice = Database::result($result, 0, 'answer');
if ($userAnsweredQuestion === false) {
$userAnsweredQuestion = !empty($choice);
}
$studentChoice = $choice == $answerAutoId ? 1 : 0;
if ($studentChoice) {
$questionScore += $answerWeighting;
$answerDestination = $objAnswerTmp->selectDestination($answerId);
$correctAnswerId = $answerId;
}
} else {
$studentChoice = $choice == $answerAutoId ? 1 : 0;
if ($studentChoice) {
$questionScore += $answerWeighting;
$answerDestination = $objAnswerTmp->selectDestination($answerId);
$correctAnswerId = $answerId;
}
}
break;
case MULTIPLE_ANSWER_TRUE_FALSE:
if ($from_database) {
$choice = [];
$sql = "SELECT answer FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND
question_id = ".$questionId;
$result = Database::query($sql);
while ($row = Database::fetch_array($result)) {
$values = explode(':', $row['answer']);
$my_answer_id = isset($values[0]) ? $values[0] : '';
$option = isset($values[1]) ? $values[1] : '';
$choice[$my_answer_id] = $option;
}
}
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : null;
if (!empty($studentChoice)) {
if ($studentChoice == $answerCorrect) {
$questionScore += $true_score;
} else {
if ($quiz_question_options[$studentChoice]['name'] == "Don't know" ||
$quiz_question_options[$studentChoice]['name'] == "DoubtScore"
) {
$questionScore += $doubt_score;
} else {
$questionScore += $false_score;
}
}
} else {
// If no result then the user just hit don't know
$studentChoice = 3;
$questionScore += $doubt_score;
}
$totalScore = $questionScore;
break;
case MULTIPLE_ANSWER_TRUE_FALSE_DEGREE_CERTAINTY:
if ($from_database) {
$choice = [];
$choiceDegreeCertainty = [];
$sql = "SELECT answer
FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND question_id = $questionId";
$result = Database::query($sql);
while ($row = Database::fetch_array($result)) {
$ind = $row['answer'];
$values = explode(':', $ind);
$myAnswerId = $values[0];
$option = $values[1];
$percent = $values[2];
$choice[$myAnswerId] = $option;
$choiceDegreeCertainty[$myAnswerId] = $percent;
}
}
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : null;
$studentChoiceDegree = isset($choiceDegreeCertainty[$answerAutoId]) ? $choiceDegreeCertainty[$answerAutoId] : null;
// student score update
if (!empty($studentChoice)) {
if ($studentChoice == $answerCorrect) {
// correct answer and student is Unsure or PrettySur
if (isset($quiz_question_options[$studentChoiceDegree]) &&
$quiz_question_options[$studentChoiceDegree]['position'] >= 3 &&
$quiz_question_options[$studentChoiceDegree]['position'] < 9
) {
$questionScore += $true_score;
} else {
// student ignore correct answer
$questionScore += $doubt_score;
}
} else {
// false answer and student is Unsure or PrettySur
if ($quiz_question_options[$studentChoiceDegree]['position'] >= 3
&& $quiz_question_options[$studentChoiceDegree]['position'] < 9) {
$questionScore += $false_score;
} else {
// student ignore correct answer
$questionScore += $doubt_score;
}
}
}
$totalScore = $questionScore;
break;
case MULTIPLE_ANSWER:
if ($from_database) {
$choice = [];
$sql = "SELECT answer FROM $TBL_TRACK_ATTEMPT
WHERE exe_id = $exeId AND question_id = $questionId ";
$resultans = Database::query($sql);
while ($row = Database::fetch_array($resultans)) {
$choice[$row['answer']] = 1;
}
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : null;
$real_answers[$answerId] = (bool) $studentChoice;
if ($studentChoice) {
$questionScore += $answerWeighting;
}
} else {
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : null;
$real_answers[$answerId] = (bool) $studentChoice;
if (isset($studentChoice)) {
$questionScore += $answerWeighting;
}
}
$totalScore += $answerWeighting;
if ($debug) {
error_log("studentChoice: $studentChoice");
}
break;
case GLOBAL_MULTIPLE_ANSWER:
if ($from_database) {
$choice = [];
$sql = "SELECT answer FROM $TBL_TRACK_ATTEMPT
WHERE exe_id = $exeId AND question_id = $questionId ";
$resultans = Database::query($sql);
while ($row = Database::fetch_array($resultans)) {
$choice[$row['answer']] = 1;
}
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : null;
$real_answers[$answerId] = (bool) $studentChoice;
if ($studentChoice) {
$questionScore += $answerWeighting;
}
} else {
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : null;
if (isset($studentChoice)) {
$questionScore += $answerWeighting;
}
$real_answers[$answerId] = (bool) $studentChoice;
}
$totalScore += $answerWeighting;
if ($debug) {
error_log("studentChoice: $studentChoice");
}
break;
case MULTIPLE_ANSWER_COMBINATION_TRUE_FALSE:
if ($from_database) {
$choice = [];
$sql = "SELECT answer FROM $TBL_TRACK_ATTEMPT
WHERE exe_id = $exeId AND question_id = $questionId";
$resultans = Database::query($sql);
while ($row = Database::fetch_array($resultans)) {
$result = explode(':', $row['answer']);
if (isset($result[0])) {
$my_answer_id = isset($result[0]) ? $result[0] : '';
$option = isset($result[1]) ? $result[1] : '';
$choice[$my_answer_id] = $option;
}
}
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : '';
$real_answers[$answerId] = false;
if ($answerCorrect == $studentChoice) {
$real_answers[$answerId] = true;
}
} else {
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : '';
$real_answers[$answerId] = false;
if ($answerCorrect == $studentChoice) {
$real_answers[$answerId] = true;
}
}
break;
case MULTIPLE_ANSWER_COMBINATION:
if ($from_database) {
$choice = [];
$sql = "SELECT answer FROM $TBL_TRACK_ATTEMPT
WHERE exe_id = $exeId AND question_id = $questionId";
$resultans = Database::query($sql);
while ($row = Database::fetch_array($resultans)) {
$choice[$row['answer']] = 1;
}
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : null;
if ($answerCorrect == 1) {
$real_answers[$answerId] = false;
if ($studentChoice) {
$real_answers[$answerId] = true;
}
} else {
$real_answers[$answerId] = true;
if ($studentChoice) {
$real_answers[$answerId] = false;
}
}
} else {
$studentChoice = isset($choice[$answerAutoId]) ? $choice[$answerAutoId] : null;
if ($answerCorrect == 1) {
$real_answers[$answerId] = false;
if ($studentChoice) {
$real_answers[$answerId] = true;
}
} else {
$real_answers[$answerId] = true;
if ($studentChoice) {
$real_answers[$answerId] = false;
}
}
}
break;
case FILL_IN_BLANKS:
$str = '';
$answerFromDatabase = '';
if ($from_database) {
$sql = "SELECT answer
FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND
question_id= $questionId ";
$result = Database::query($sql);
$str = $answerFromDatabase = Database::result($result, 0, 'answer');
}
// if ($saved_results == false && strpos($answerFromDatabase, 'font color') !== false) {
if (false) {
// the question is encoded like this
// [A] B [C] D [E] F::10,10,10@1
// number 1 before the "@" means that is a switchable fill in blank question
// [A] B [C] D [E] F::10,10,10@ or [A] B [C] D [E] F::10,10,10
// means that is a normal fill blank question
// first we explode the "::"
$pre_array = explode('::', $answer);
// is switchable fill blank or not
$last = count($pre_array) - 1;
$is_set_switchable = explode('@', $pre_array[$last]);
$switchable_answer_set = false;
if (isset($is_set_switchable[1]) && $is_set_switchable[1] == 1) {
$switchable_answer_set = true;
}
$answer = '';
for ($k = 0; $k < $last; $k++) {
$answer .= $pre_array[$k];
}
// splits weightings that are joined with a comma
$answerWeighting = explode(',', $is_set_switchable[0]);
// we save the answer because it will be modified
$temp = $answer;
$answer = '';
$j = 0;
//initialise answer tags
$user_tags = $correct_tags = $real_text = [];
// the loop will stop at the end of the text
while (1) {
// quits the loop if there are no more blanks (detect '[')
if ($temp == false || ($pos = api_strpos($temp, '[')) === false) {
// adds the end of the text
$answer = $temp;
$real_text[] = $answer;
break; //no more "blanks", quit the loop
}
// adds the piece of text that is before the blank
//and ends with '[' into a general storage array
$real_text[] = api_substr($temp, 0, $pos + 1);
$answer .= api_substr($temp, 0, $pos + 1);
//take the string remaining (after the last "[" we found)
$temp = api_substr($temp, $pos + 1);
// quit the loop if there are no more blanks, and update $pos to the position of next ']'
if (($pos = api_strpos($temp, ']')) === false) {
// adds the end of the text
$answer .= $temp;
break;
}
if ($from_database) {
$str = $answerFromDatabase;
api_preg_match_all('#\[([^[]*)\]#', $str, $arr);
$str = str_replace('\r\n', '', $str);
$choice = $arr[1];
if (isset($choice[$j])) {
$tmp = api_strrpos($choice[$j], ' / ');
$choice[$j] = api_substr($choice[$j], 0, $tmp);
$choice[$j] = trim($choice[$j]);
// Needed to let characters ' and " to work as part of an answer
$choice[$j] = stripslashes($choice[$j]);
} else {
$choice[$j] = null;
}
} else {
// This value is the user input, not escaped while correct answer is escaped by ckeditor
$choice[$j] = api_htmlentities(trim($choice[$j]));
}
$user_tags[] = $choice[$j];
// Put the contents of the [] answer tag into correct_tags[]
$correct_tags[] = api_substr($temp, 0, $pos);
$j++;
$temp = api_substr($temp, $pos + 1);
}
$answer = '';
$real_correct_tags = $correct_tags;
$chosen_list = [];
for ($i = 0; $i < count($real_correct_tags); $i++) {
if ($i == 0) {
$answer .= $real_text[0];
}
if (!$switchable_answer_set) {
// Needed to parse ' and " characters
$user_tags[$i] = stripslashes($user_tags[$i]);
if ($correct_tags[$i] == $user_tags[$i]) {
// gives the related weighting to the student
$questionScore += $answerWeighting[$i];
// increments total score
$totalScore += $answerWeighting[$i];
// adds the word in green at the end of the string
$answer .= $correct_tags[$i];
} elseif (!empty($user_tags[$i])) {
// else if the word entered by the student IS NOT the same as
// the one defined by the professor
// adds the word in red at the end of the string, and strikes it
$answer .= '
'.$user_tags[$i].'';
} else {
// adds a tabulation if no word has been typed by the student
$answer .= ''; // remove that causes issue
}
} else {
// switchable fill in the blanks
if (in_array($user_tags[$i], $correct_tags)) {
$chosen_list[] = $user_tags[$i];
$correct_tags = array_diff($correct_tags, $chosen_list);
// gives the related weighting to the student
$questionScore += $answerWeighting[$i];
// increments total score
$totalScore += $answerWeighting[$i];
// adds the word in green at the end of the string
$answer .= $user_tags[$i];
} elseif (!empty($user_tags[$i])) {
// else if the word entered by the student IS NOT the same
// as the one defined by the professor
// adds the word in red at the end of the string, and strikes it
$answer .= '
'.$user_tags[$i].'';
} else {
// adds a tabulation if no word has been typed by the student
$answer .= ''; // remove that causes issue
}
}
// adds the correct word, followed by ] to close the blank
$answer .= ' /
'.$real_correct_tags[$i].']';
if (isset($real_text[$i + 1])) {
$answer .= $real_text[$i + 1];
}
}
} else {
// insert the student result in the track_e_attempt table, field answer
// $answer is the answer like in the c_quiz_answer table for the question
// student data are choice[]
$listCorrectAnswers = FillBlanks::getAnswerInfo($answer);
$switchableAnswerSet = $listCorrectAnswers['switchable'];
$answerWeighting = $listCorrectAnswers['weighting'];
// user choices is an array $choice
// get existing user data in n the BDD
if ($from_database) {
$listStudentResults = FillBlanks::getAnswerInfo(
$answerFromDatabase,
true
);
$choice = $listStudentResults['student_answer'];
}
// loop other all blanks words
if (!$switchableAnswerSet) {
// not switchable answer, must be in the same place than teacher order
for ($i = 0; $i < count($listCorrectAnswers['words']); $i++) {
$studentAnswer = isset($choice[$i]) ? $choice[$i] : '';
$correctAnswer = $listCorrectAnswers['words'][$i];
if ($debug) {
error_log("Student answer: $i");
error_log($studentAnswer);
}
// This value is the user input, not escaped while correct answer is escaped by ckeditor
// Works with cyrillic alphabet and when using ">" chars see #7718 #7610 #7618
// ENT_QUOTES is used in order to transform ' to '
if (!$from_database) {
$studentAnswer = FillBlanks::clearStudentAnswer($studentAnswer);
if ($debug) {
error_log("Student answer cleaned:");
error_log($studentAnswer);
}
}
$isAnswerCorrect = 0;
if (FillBlanks::isStudentAnswerGood($studentAnswer, $correctAnswer, $from_database)) {
// gives the related weighting to the student
$questionScore += $answerWeighting[$i];
// increments total score
$totalScore += $answerWeighting[$i];
$isAnswerCorrect = 1;
}
if ($debug) {
error_log("isAnswerCorrect $i: $isAnswerCorrect");
}
$studentAnswerToShow = $studentAnswer;
$type = FillBlanks::getFillTheBlankAnswerType($correctAnswer);
if ($debug) {
error_log("Fill in blank type: $type");
}
if ($type == FillBlanks::FILL_THE_BLANK_MENU) {
$listMenu = FillBlanks::getFillTheBlankMenuAnswers($correctAnswer, false);
if ($studentAnswer != '') {
foreach ($listMenu as $item) {
if (sha1($item) == $studentAnswer) {
$studentAnswerToShow = $item;
}
}
}
}
$listCorrectAnswers['student_answer'][$i] = $studentAnswerToShow;
$listCorrectAnswers['student_score'][$i] = $isAnswerCorrect;
}
} else {
// switchable answer
$listStudentAnswerTemp = $choice;
$listTeacherAnswerTemp = $listCorrectAnswers['words'];
// for every teacher answer, check if there is a student answer
for ($i = 0; $i < count($listStudentAnswerTemp); $i++) {
$studentAnswer = trim($listStudentAnswerTemp[$i]);
$studentAnswerToShow = $studentAnswer;
if ($debug) {
error_log("Student answer: $i");
error_log($studentAnswer);
}
$found = false;
for ($j = 0; $j < count($listTeacherAnswerTemp); $j++) {
$correctAnswer = $listTeacherAnswerTemp[$j];
$type = FillBlanks::getFillTheBlankAnswerType($correctAnswer);
if ($type == FillBlanks::FILL_THE_BLANK_MENU) {
$listMenu = FillBlanks::getFillTheBlankMenuAnswers($correctAnswer, false);
if (!empty($studentAnswer)) {
foreach ($listMenu as $key => $item) {
if ($key == $correctAnswer) {
$studentAnswerToShow = $item;
break;
}
}
}
}
if (!$found) {
if (FillBlanks::isStudentAnswerGood(
$studentAnswer,
$correctAnswer,
$from_database
)
) {
$questionScore += $answerWeighting[$i];
$totalScore += $answerWeighting[$i];
$listTeacherAnswerTemp[$j] = '';
$found = true;
}
}
}
$listCorrectAnswers['student_answer'][$i] = $studentAnswerToShow;
if (!$found) {
$listCorrectAnswers['student_score'][$i] = 0;
} else {
$listCorrectAnswers['student_score'][$i] = 1;
}
}
}
$answer = FillBlanks::getAnswerInStudentAttempt($listCorrectAnswers);
}
break;
case CALCULATED_ANSWER:
$calculatedAnswerList = Session::read('calculatedAnswerId');
if (!empty($calculatedAnswerList)) {
$answer = $objAnswerTmp->selectAnswer($calculatedAnswerList[$questionId]);
$preArray = explode('@@', $answer);
$last = count($preArray) - 1;
$answer = '';
for ($k = 0; $k < $last; $k++) {
$answer .= $preArray[$k];
}
$answerWeighting = [$answerWeighting];
// we save the answer because it will be modified
$temp = $answer;
$answer = '';
$j = 0;
// initialise answer tags
$userTags = $correctTags = $realText = [];
// the loop will stop at the end of the text
while (1) {
// quits the loop if there are no more blanks (detect '[')
if ($temp == false || ($pos = api_strpos($temp, '[')) === false) {
// adds the end of the text
$answer = $temp;
$realText[] = $answer;
break; //no more "blanks", quit the loop
}
// adds the piece of text that is before the blank
// and ends with '[' into a general storage array
$realText[] = api_substr($temp, 0, $pos + 1);
$answer .= api_substr($temp, 0, $pos + 1);
// take the string remaining (after the last "[" we found)
$temp = api_substr($temp, $pos + 1);
// quit the loop if there are no more blanks, and update $pos to the position of next ']'
if (($pos = api_strpos($temp, ']')) === false) {
// adds the end of the text
$answer .= $temp;
break;
}
if ($from_database) {
$sql = "SELECT answer FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND
question_id = $questionId ";
$result = Database::query($sql);
$str = Database::result($result, 0, 'answer');
api_preg_match_all('#\[([^[]*)\]#', $str, $arr);
$str = str_replace('\r\n', '', $str);
$choice = $arr[1];
if (isset($choice[$j])) {
$tmp = api_strrpos($choice[$j], ' / ');
if ($tmp) {
$choice[$j] = api_substr($choice[$j], 0, $tmp);
} else {
$tmp = ltrim($tmp, '[');
$tmp = rtrim($tmp, ']');
}
$choice[$j] = trim($choice[$j]);
// Needed to let characters ' and " to work as part of an answer
$choice[$j] = stripslashes($choice[$j]);
} else {
$choice[$j] = null;
}
} else {
// This value is the user input not escaped while correct answer is escaped by ckeditor
$choice[$j] = api_htmlentities(trim($choice[$j]));
}
$userTags[] = $choice[$j];
// put the contents of the [] answer tag into correct_tags[]
$correctTags[] = api_substr($temp, 0, $pos);
$j++;
$temp = api_substr($temp, $pos + 1);
}
$answer = '';
$realCorrectTags = $correctTags;
$calculatedStatus = Display::label(get_lang('Incorrect'), 'danger');
$expectedAnswer = '';
$calculatedChoice = '';
for ($i = 0; $i < count($realCorrectTags); $i++) {
if ($i == 0) {
$answer .= $realText[0];
}
// Needed to parse ' and " characters
$userTags[$i] = stripslashes($userTags[$i]);
if ($correctTags[$i] == $userTags[$i]) {
// gives the related weighting to the student
$questionScore += $answerWeighting[$i];
// increments total score
$totalScore += $answerWeighting[$i];
// adds the word in green at the end of the string
$answer .= $correctTags[$i];
$calculatedChoice = $correctTags[$i];
} elseif (!empty($userTags[$i])) {
// else if the word entered by the student IS NOT the same as
// the one defined by the professor
// adds the word in red at the end of the string, and strikes it
$answer .= '
'.$userTags[$i].'';
$calculatedChoice = $userTags[$i];
} else {
// adds a tabulation if no word has been typed by the student
$answer .= ''; // remove that causes issue
}
// adds the correct word, followed by ] to close the blank
if ($this->results_disabled != EXERCISE_FEEDBACK_TYPE_EXAM) {
$answer .= ' /
'.$realCorrectTags[$i].'';
$calculatedStatus = Display::label(get_lang('Correct'), 'success');
$expectedAnswer = $realCorrectTags[$i];
}
$answer .= ']';
if (isset($realText[$i + 1])) {
$answer .= $realText[$i + 1];
}
}
} else {
if ($from_database) {
$sql = "SELECT *
FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND
question_id = $questionId ";
$result = Database::query($sql);
$resultData = Database::fetch_array($result, 'ASSOC');
$answer = $resultData['answer'];
$questionScore = $resultData['marks'];
}
}
break;
case FREE_ANSWER:
if ($from_database) {
$sql = "SELECT answer, marks FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND
question_id= ".$questionId;
$result = Database::query($sql);
$data = Database::fetch_array($result);
$choice = $data['answer'];
$choice = str_replace('\r\n', '', $choice);
$choice = stripslashes($choice);
$questionScore = $data['marks'];
if ($questionScore == -1) {
$totalScore += 0;
} else {
$totalScore += $questionScore;
}
if ($questionScore == '') {
$questionScore = 0;
}
$arrques = $questionName;
$arrans = $choice;
} else {
$studentChoice = $choice;
if ($studentChoice) {
//Fixing negative puntation see #2193
$questionScore = 0;
$totalScore += 0;
}
}
break;
case ORAL_EXPRESSION:
if ($from_database) {
$query = "SELECT answer, marks
FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND
question_id = $questionId
";
$resq = Database::query($query);
$row = Database::fetch_assoc($resq);
$choice = $row['answer'];
$choice = str_replace('\r\n', '', $choice);
$choice = stripslashes($choice);
$questionScore = $row['marks'];
if ($questionScore == -1) {
$totalScore += 0;
} else {
$totalScore += $questionScore;
}
$arrques = $questionName;
$arrans = $choice;
} else {
$studentChoice = $choice;
if ($studentChoice) {
//Fixing negative puntation see #2193
$questionScore = 0;
$totalScore += 0;
}
}
break;
case DRAGGABLE:
case MATCHING_DRAGGABLE:
case MATCHING:
if ($from_database) {
$sql = "SELECT id, answer, id_auto
FROM $table_ans
WHERE
c_id = $course_id AND
question_id = $questionId AND
correct = 0
";
$result = Database::query($sql);
// Getting the real answer
$real_list = [];
while ($realAnswer = Database::fetch_array($result)) {
$real_list[$realAnswer['id_auto']] = $realAnswer['answer'];
}
$sql = "SELECT id, answer, correct, id_auto, ponderation
FROM $table_ans
WHERE
c_id = $course_id AND
question_id = $questionId AND
correct <> 0
ORDER BY id_auto";
$result = Database::query($sql);
$options = [];
while ($row = Database::fetch_array($result, 'ASSOC')) {
$options[] = $row;
}
$questionScore = 0;
$counterAnswer = 1;
foreach ($options as $a_answers) {
$i_answer_id = $a_answers['id']; //3
$s_answer_label = $a_answers['answer']; // your daddy - your mother
$i_answer_correct_answer = $a_answers['correct']; //1 - 2
$i_answer_id_auto = $a_answers['id_auto']; // 3 - 4
$sql = "SELECT answer FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = '$exeId' AND
question_id = '$questionId' AND
position = '$i_answer_id_auto'";
$result = Database::query($sql);
$s_user_answer = 0;
if (Database::num_rows($result) > 0) {
// rich - good looking
$s_user_answer = Database::result($result, 0, 0);
}
$i_answerWeighting = $a_answers['ponderation'];
$user_answer = '';
$status = Display::label(get_lang('Incorrect'), 'danger');
if (!empty($s_user_answer)) {
if ($answerType == DRAGGABLE) {
if ($s_user_answer == $i_answer_correct_answer) {
$questionScore += $i_answerWeighting;
$totalScore += $i_answerWeighting;
$user_answer = Display::label(get_lang('Correct'), 'success');
if ($this->showExpectedChoice()) {
$user_answer = $answerMatching[$i_answer_id_auto];
}
$status = Display::label(get_lang('Correct'), 'success');
} else {
$user_answer = Display::label(get_lang('Incorrect'), 'danger');
if ($this->showExpectedChoice()) {
$data = $options[$real_list[$s_user_answer] - 1];
$user_answer = $data['answer'];
}
}
} else {
if ($s_user_answer == $i_answer_correct_answer) {
$questionScore += $i_answerWeighting;
$totalScore += $i_answerWeighting;
$status = Display::label(get_lang('Correct'), 'success');
// Try with id
if (isset($real_list[$i_answer_id])) {
$user_answer = Display::span(
$real_list[$i_answer_id],
['style' => 'color: #008000; font-weight: bold;']
);
}
// Try with $i_answer_id_auto
if (empty($user_answer)) {
if (isset($real_list[$i_answer_id_auto])) {
$user_answer = Display::span(
$real_list[$i_answer_id_auto],
['style' => 'color: #008000; font-weight: bold;']
);
}
}
if (isset($real_list[$i_answer_correct_answer])) {
$user_answer = Display::span(
$real_list[$i_answer_correct_answer],
['style' => 'color: #008000; font-weight: bold;']
);
}
} else {
$user_answer = Display::span(
$real_list[$s_user_answer],
['style' => 'color: #FF0000; text-decoration: line-through;']
);
if ($this->showExpectedChoice()) {
if (isset($real_list[$s_user_answer])) {
$user_answer = Display::span($real_list[$s_user_answer]);
}
}
}
}
} elseif ($answerType == DRAGGABLE) {
$user_answer = Display::label(get_lang('Incorrect'), 'danger');
if ($this->showExpectedChoice()) {
$user_answer = '';
}
} else {
$user_answer = Display::span(
get_lang('Incorrect').' ',
['style' => 'color: #FF0000; text-decoration: line-through;']
);
if ($this->showExpectedChoice()) {
$user_answer = '';
}
}
if ($show_result) {
if ($this->showExpectedChoice() === false &&
$showTotalScoreAndUserChoicesInLastAttempt === false
) {
$user_answer = '';
}
switch ($answerType) {
case MATCHING:
case MATCHING_DRAGGABLE:
echo '
';
if (!in_array(
$this->results_disabled,
[
RESULT_DISABLE_SHOW_ONLY_IN_CORRECT_ANSWER,
]
)
) {
echo ''.$s_answer_label.' | ';
echo ''.$user_answer.' | ';
} else {
echo ''.$s_answer_label.' | ';
$status = Display::label(get_lang('Correct'), 'success');
}
if ($this->showExpectedChoice()) {
if ($this->showExpectedChoiceColumn()) {
echo '';
if (in_array($answerType, [MATCHING, MATCHING_DRAGGABLE])) {
if (isset($real_list[$i_answer_correct_answer]) &&
$showTotalScoreAndUserChoicesInLastAttempt == true
) {
echo Display::span(
$real_list[$i_answer_correct_answer]
);
}
}
echo ' | ';
}
echo ''.$status.' | ';
} else {
if (in_array($answerType, [MATCHING, MATCHING_DRAGGABLE])) {
if (isset($real_list[$i_answer_correct_answer]) &&
$showTotalScoreAndUserChoicesInLastAttempt === true
) {
if ($this->showExpectedChoiceColumn()) {
echo '';
echo Display::span(
$real_list[$i_answer_correct_answer],
['style' => 'color: #008000; font-weight: bold;']
);
echo ' | ';
}
}
}
}
echo '
';
break;
case DRAGGABLE:
if ($showTotalScoreAndUserChoicesInLastAttempt == false) {
$s_answer_label = '';
}
echo '
';
if ($this->showExpectedChoice()) {
if (!in_array($this->results_disabled, [
RESULT_DISABLE_SHOW_ONLY_IN_CORRECT_ANSWER,
//RESULT_DISABLE_SHOW_SCORE_AND_EXPECTED_ANSWERS_AND_RANKING,
])
) {
echo ''.$user_answer.' | ';
} else {
$status = Display::label(get_lang('Correct'), 'success');
}
echo ''.$s_answer_label.' | ';
echo ''.$status.' | ';
} else {
echo ''.$s_answer_label.' | ';
echo ''.$user_answer.' | ';
echo '';
if (in_array($answerType, [MATCHING, MATCHING_DRAGGABLE])) {
if (isset($real_list[$i_answer_correct_answer]) &&
$showTotalScoreAndUserChoicesInLastAttempt === true
) {
echo Display::span(
$real_list[$i_answer_correct_answer],
['style' => 'color: #008000; font-weight: bold;']
);
}
}
echo ' | ';
}
echo '
';
break;
}
}
$counterAnswer++;
}
break 2; // break the switch and the "for" condition
} else {
if ($answerCorrect) {
if (isset($choice[$answerAutoId]) &&
$answerCorrect == $choice[$answerAutoId]
) {
$questionScore += $answerWeighting;
$totalScore += $answerWeighting;
$user_answer = Display::span($answerMatching[$choice[$answerAutoId]]);
} else {
if (isset($answerMatching[$choice[$answerAutoId]])) {
$user_answer = Display::span(
$answerMatching[$choice[$answerAutoId]],
['style' => 'color: #FF0000; text-decoration: line-through;']
);
}
}
$matching[$answerAutoId] = $choice[$answerAutoId];
}
}
break;
case HOT_SPOT:
if ($from_database) {
$TBL_TRACK_HOTSPOT = Database::get_main_table(TABLE_STATISTIC_TRACK_E_HOTSPOT);
// Check auto id
$sql = "SELECT hotspot_correct
FROM $TBL_TRACK_HOTSPOT
WHERE
hotspot_exe_id = $exeId AND
hotspot_question_id= $questionId AND
hotspot_answer_id = $answerAutoId
ORDER BY hotspot_id ASC";
$result = Database::query($sql);
if (Database::num_rows($result)) {
$studentChoice = Database::result(
$result,
0,
'hotspot_correct'
);
if ($studentChoice) {
$questionScore += $answerWeighting;
$totalScore += $answerWeighting;
}
} else {
// If answer.id is different:
$sql = "SELECT hotspot_correct
FROM $TBL_TRACK_HOTSPOT
WHERE
hotspot_exe_id = $exeId AND
hotspot_question_id= $questionId AND
hotspot_answer_id = ".intval($answerId)."
ORDER BY hotspot_id ASC";
$result = Database::query($sql);
if (Database::num_rows($result)) {
$studentChoice = Database::result(
$result,
0,
'hotspot_correct'
);
if ($studentChoice) {
$questionScore += $answerWeighting;
$totalScore += $answerWeighting;
}
} else {
// check answer.iid
if (!empty($answerIid)) {
$sql = "SELECT hotspot_correct
FROM $TBL_TRACK_HOTSPOT
WHERE
hotspot_exe_id = $exeId AND
hotspot_question_id= $questionId AND
hotspot_answer_id = $answerIid
ORDER BY hotspot_id ASC";
$result = Database::query($sql);
$studentChoice = Database::result(
$result,
0,
'hotspot_correct'
);
if ($studentChoice) {
$questionScore += $answerWeighting;
$totalScore += $answerWeighting;
}
}
}
}
} else {
if (!isset($choice[$answerAutoId]) && !isset($choice[$answerIid])) {
$choice[$answerAutoId] = 0;
$choice[$answerIid] = 0;
} else {
$studentChoice = $choice[$answerAutoId];
if (empty($studentChoice)) {
$studentChoice = $choice[$answerIid];
}
$choiceIsValid = false;
if (!empty($studentChoice)) {
$hotspotType = $objAnswerTmp->selectHotspotType($answerId);
$hotspotCoordinates = $objAnswerTmp->selectHotspotCoordinates($answerId);
$choicePoint = Geometry::decodePoint($studentChoice);
switch ($hotspotType) {
case 'square':
$hotspotProperties = Geometry::decodeSquare($hotspotCoordinates);
$choiceIsValid = Geometry::pointIsInSquare($hotspotProperties, $choicePoint);
break;
case 'circle':
$hotspotProperties = Geometry::decodeEllipse($hotspotCoordinates);
$choiceIsValid = Geometry::pointIsInEllipse($hotspotProperties, $choicePoint);
break;
case 'poly':
$hotspotProperties = Geometry::decodePolygon($hotspotCoordinates);
$choiceIsValid = Geometry::pointIsInPolygon($hotspotProperties, $choicePoint);
break;
}
}
$choice[$answerAutoId] = 0;
if ($choiceIsValid) {
$questionScore += $answerWeighting;
$totalScore += $answerWeighting;
$choice[$answerAutoId] = 1;
$choice[$answerIid] = 1;
}
}
}
break;
case HOT_SPOT_ORDER:
// @todo never added to chamilo
// for hotspot with fixed order
$studentChoice = $choice['order'][$answerId];
if ($studentChoice == $answerId) {
$questionScore += $answerWeighting;
$totalScore += $answerWeighting;
$studentChoice = true;
} else {
$studentChoice = false;
}
break;
case HOT_SPOT_DELINEATION:
// for hotspot with delineation
if ($from_database) {
// getting the user answer
$TBL_TRACK_HOTSPOT = Database::get_main_table(TABLE_STATISTIC_TRACK_E_HOTSPOT);
$query = "SELECT hotspot_correct, hotspot_coordinate
FROM $TBL_TRACK_HOTSPOT
WHERE
hotspot_exe_id = $exeId AND
hotspot_question_id= $questionId AND
hotspot_answer_id = '1'";
// By default we take 1 because it's a delineation
$resq = Database::query($query);
$row = Database::fetch_array($resq, 'ASSOC');
$choice = $row['hotspot_correct'];
$user_answer = $row['hotspot_coordinate'];
// THIS is very important otherwise the poly_compile will throw an error!!
// round-up the coordinates
$coords = explode('/', $user_answer);
$coords = array_filter($coords);
$user_array = '';
foreach ($coords as $coord) {
list($x, $y) = explode(';', $coord);
$user_array .= round($x).';'.round($y).'/';
}
$user_array = substr($user_array, 0, -1) ?: '';
} else {
if (!empty($studentChoice)) {
$newquestionList[] = $questionId;
}
if ($answerId === 1) {
$studentChoice = $choice[$answerId];
$questionScore += $answerWeighting;
}
if (isset($_SESSION['exerciseResultCoordinates'][$questionId])) {
$user_array = $_SESSION['exerciseResultCoordinates'][$questionId];
}
}
$_SESSION['hotspot_coord'][$questionId][1] = $delineation_cord;
$_SESSION['hotspot_dest'][$questionId][1] = $answer_delineation_destination;
break;
case ANNOTATION:
if ($from_database) {
$sql = "SELECT answer, marks
FROM $TBL_TRACK_ATTEMPT
WHERE
exe_id = $exeId AND
question_id = $questionId ";
$resq = Database::query($sql);
$data = Database::fetch_array($resq);
$questionScore = empty($data['marks']) ? 0 : $data['marks'];
$arrques = $questionName;
break;
}
$studentChoice = $choice;
if ($studentChoice) {
$questionScore = 0;
}
break;
}
if ($show_result) {
if ($from === 'exercise_result') {
// Display answers (if not matching type, or if the answer is correct)
if (!in_array($answerType, [MATCHING, DRAGGABLE, MATCHING_DRAGGABLE]) ||
$answerCorrect
) {
if (in_array(
$answerType,
[
UNIQUE_ANSWER,
UNIQUE_ANSWER_IMAGE,
UNIQUE_ANSWER_NO_OPTION,
MULTIPLE_ANSWER,
MULTIPLE_ANSWER_COMBINATION,
GLOBAL_MULTIPLE_ANSWER,
READING_COMPREHENSION,
]
)) {
ExerciseShowFunctions::display_unique_or_multiple_answer(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
0,
0,
0,
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt,
$this->export
);
} elseif ($answerType == MULTIPLE_ANSWER_TRUE_FALSE) {
ExerciseShowFunctions::display_multiple_answer_true_false(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
0,
$questionId,
0,
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt
);
} elseif ($answerType == MULTIPLE_ANSWER_TRUE_FALSE_DEGREE_CERTAINTY) {
ExerciseShowFunctions::displayMultipleAnswerTrueFalseDegreeCertainty(
$this,
$feedback_type,
$studentChoice,
$studentChoiceDegree,
$answer,
$answerComment,
$answerCorrect,
$questionId,
$results_disabled
);
} elseif ($answerType == MULTIPLE_ANSWER_COMBINATION_TRUE_FALSE) {
ExerciseShowFunctions::display_multiple_answer_combination_true_false(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
0,
0,
0,
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt
);
} elseif ($answerType == FILL_IN_BLANKS) {
ExerciseShowFunctions::display_fill_in_blanks_answer(
$this,
$feedback_type,
$answer,
0,
0,
$results_disabled,
'',
$showTotalScoreAndUserChoicesInLastAttempt
);
} elseif ($answerType == CALCULATED_ANSWER) {
ExerciseShowFunctions::display_calculated_answer(
$this,
$feedback_type,
$answer,
0,
0,
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt,
$expectedAnswer,
$calculatedChoice,
$calculatedStatus
);
} elseif ($answerType == FREE_ANSWER) {
ExerciseShowFunctions::display_free_answer(
$feedback_type,
$choice,
$exeId,
$questionId,
$questionScore,
$results_disabled
);
} elseif ($answerType == ORAL_EXPRESSION) {
// to store the details of open questions in an array to be used in mail
/** @var OralExpression $objQuestionTmp */
ExerciseShowFunctions::display_oral_expression_answer(
$feedback_type,
$choice,
0,
0,
$objQuestionTmp->getFileUrl(true),
$results_disabled,
$questionScore
);
} elseif ($answerType == HOT_SPOT) {
$correctAnswerId = 0;
/** @var TrackEHotspot $hotspot */
foreach ($orderedHotSpots as $correctAnswerId => $hotspot) {
if ($hotspot->getHotspotAnswerId() == $answerAutoId) {
break;
}
}
// force to show whether the choice is correct or not
$showTotalScoreAndUserChoicesInLastAttempt = true;
ExerciseShowFunctions::display_hotspot_answer(
$feedback_type,
++$correctAnswerId,
$answer,
$studentChoice,
$answerComment,
$results_disabled,
$correctAnswerId,
$showTotalScoreAndUserChoicesInLastAttempt
);
} elseif ($answerType == HOT_SPOT_ORDER) {
ExerciseShowFunctions::display_hotspot_order_answer(
$feedback_type,
$answerId,
$answer,
$studentChoice,
$answerComment
);
} elseif ($answerType == HOT_SPOT_DELINEATION) {
$user_answer = $_SESSION['exerciseResultCoordinates'][$questionId];
// Round-up the coordinates
$coords = explode('/', $user_answer);
$coords = array_filter($coords);
$user_array = '';
foreach ($coords as $coord) {
if (!empty($coord)) {
$parts = explode(';', $coord);
if (!empty($parts)) {
$user_array .= round($parts[0]).';'.round($parts[1]).'/';
}
}
}
$user_array = substr($user_array, 0, -1) ?: '';
if ($next) {
$user_answer = $user_array;
// We compare only the delineation not the other points
$answer_question = $_SESSION['hotspot_coord'][$questionId][1];
$answerDestination = $_SESSION['hotspot_dest'][$questionId][1];
// Calculating the area
$poly_user = convert_coordinates($user_answer, '/');
$poly_answer = convert_coordinates($answer_question, '|');
$max_coord = poly_get_max($poly_user, $poly_answer);
$poly_user_compiled = poly_compile($poly_user, $max_coord);
$poly_answer_compiled = poly_compile($poly_answer, $max_coord);
$poly_results = poly_result($poly_answer_compiled, $poly_user_compiled, $max_coord);
$overlap = $poly_results['both'];
$poly_answer_area = $poly_results['s1'];
$poly_user_area = $poly_results['s2'];
$missing = $poly_results['s1Only'];
$excess = $poly_results['s2Only'];
// //this is an area in pixels
if ($debug > 0) {
error_log(__LINE__.' - Polygons results are '.print_r($poly_results, 1), 0);
}
if ($overlap < 1) {
// Shortcut to avoid complicated calculations
$final_overlap = 0;
$final_missing = 100;
$final_excess = 100;
} else {
// the final overlap is the percentage of the initial polygon
// that is overlapped by the user's polygon
$final_overlap = round(((float) $overlap / (float) $poly_answer_area) * 100);
if ($debug > 1) {
error_log(__LINE__.' - Final overlap is '.$final_overlap, 0);
}
// the final missing area is the percentage of the initial polygon
// that is not overlapped by the user's polygon
$final_missing = 100 - $final_overlap;
if ($debug > 1) {
error_log(__LINE__.' - Final missing is '.$final_missing, 0);
}
// the final excess area is the percentage of the initial polygon's size
// that is covered by the user's polygon outside of the initial polygon
$final_excess = round((((float) $poly_user_area - (float) $overlap) / (float) $poly_answer_area) * 100);
if ($debug > 1) {
error_log(__LINE__.' - Final excess is '.$final_excess, 0);
}
}
// Checking the destination parameters parsing the "@@"
$destination_items = explode('@@', $answerDestination);
$threadhold_total = $destination_items[0];
$threadhold_items = explode(';', $threadhold_total);
$threadhold1 = $threadhold_items[0]; // overlap
$threadhold2 = $threadhold_items[1]; // excess
$threadhold3 = $threadhold_items[2]; // missing
// if is delineation
if ($answerId === 1) {
//setting colors
if ($final_overlap >= $threadhold1) {
$overlap_color = true;
}
if ($final_excess <= $threadhold2) {
$excess_color = true;
}
if ($final_missing <= $threadhold3) {
$missing_color = true;
}
// if pass
if ($final_overlap >= $threadhold1 &&
$final_missing <= $threadhold3 &&
$final_excess <= $threadhold2
) {
$next = 1; //go to the oars
$result_comment = get_lang('Acceptable');
$final_answer = 1; // do not update with update_exercise_attempt
} else {
$next = 0;
$result_comment = get_lang('Unacceptable');
$comment = $answerDestination = $objAnswerTmp->selectComment(1);
$answerDestination = $objAnswerTmp->selectDestination(1);
// checking the destination parameters parsing the "@@"
$destination_items = explode('@@', $answerDestination);
}
} elseif ($answerId > 1) {
if ($objAnswerTmp->selectHotspotType($answerId) == 'noerror') {
if ($debug > 0) {
error_log(__LINE__.' - answerId is of type noerror', 0);
}
//type no error shouldn't be treated
$next = 1;
continue;
}
if ($debug > 0) {
error_log(__LINE__.' - answerId is >1 so we\'re probably in OAR', 0);
}
$delineation_cord = $objAnswerTmp->selectHotspotCoordinates($answerId);
$poly_answer = convert_coordinates($delineation_cord, '|');
$max_coord = poly_get_max($poly_user, $poly_answer);
$poly_answer_compiled = poly_compile($poly_answer, $max_coord);
$overlap = poly_touch($poly_user_compiled, $poly_answer_compiled, $max_coord);
if ($overlap == false) {
//all good, no overlap
$next = 1;
continue;
} else {
if ($debug > 0) {
error_log(__LINE__.' - Overlap is '.$overlap.': OAR hit', 0);
}
$organs_at_risk_hit++;
//show the feedback
$next = 0;
$comment = $answerDestination = $objAnswerTmp->selectComment($answerId);
$answerDestination = $objAnswerTmp->selectDestination($answerId);
$destination_items = explode('@@', $answerDestination);
$try_hotspot = $destination_items[1];
$lp_hotspot = $destination_items[2];
$select_question_hotspot = $destination_items[3];
$url_hotspot = $destination_items[4];
}
}
} else {
// the first delineation feedback
if ($debug > 0) {
error_log(__LINE__.' first', 0);
}
}
} elseif (in_array($answerType, [MATCHING, MATCHING_DRAGGABLE])) {
echo '
';
echo Display::tag('td', $answerMatching[$answerId]);
echo Display::tag(
'td',
"$user_answer / ".Display::tag(
'strong',
$answerMatching[$answerCorrect],
['style' => 'color: #008000; font-weight: bold;']
)
);
echo '
';
} elseif ($answerType == ANNOTATION) {
ExerciseShowFunctions::displayAnnotationAnswer(
$feedback_type,
$exeId,
$questionId,
$questionScore,
$results_disabled
);
}
}
} else {
if ($debug) {
error_log('Showing questions $from '.$from);
}
switch ($answerType) {
case UNIQUE_ANSWER:
case UNIQUE_ANSWER_IMAGE:
case UNIQUE_ANSWER_NO_OPTION:
case MULTIPLE_ANSWER:
case GLOBAL_MULTIPLE_ANSWER:
case MULTIPLE_ANSWER_COMBINATION:
case READING_COMPREHENSION:
if ($answerId == 1) {
ExerciseShowFunctions::display_unique_or_multiple_answer(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
$exeId,
$questionId,
$answerId,
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt,
$this->export
);
} else {
ExerciseShowFunctions::display_unique_or_multiple_answer(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
$exeId,
$questionId,
'',
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt,
$this->export
);
}
break;
case MULTIPLE_ANSWER_COMBINATION_TRUE_FALSE:
if ($answerId == 1) {
ExerciseShowFunctions::display_multiple_answer_combination_true_false(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
$exeId,
$questionId,
$answerId,
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt
);
} else {
ExerciseShowFunctions::display_multiple_answer_combination_true_false(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
$exeId,
$questionId,
'',
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt
);
}
break;
case MULTIPLE_ANSWER_TRUE_FALSE:
if ($answerId == 1) {
ExerciseShowFunctions::display_multiple_answer_true_false(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
$exeId,
$questionId,
$answerId,
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt
);
} else {
ExerciseShowFunctions::display_multiple_answer_true_false(
$this,
$feedback_type,
$answerType,
$studentChoice,
$answer,
$answerComment,
$answerCorrect,
$exeId,
$questionId,
'',
$results_disabled,
$showTotalScoreAndUserChoicesInLastAttempt
);
}
break;
case MULTIPLE_ANSWER_TRUE_FALSE_DEGREE_CERTAINTY:
if ($answerId == 1) {
ExerciseShowFunctions::displayMultipleAnswerTrueFalseDegreeCertainty(
$this,
$feedback_type,
$studentChoice,
$studentChoiceDegree,
$answer,
$answerComment,
$answerCorrect,
$questionId,
$results_disabled
);
} else {
ExerciseShowFunctions::displayMultipleAnswerTrueFalseDegreeCertainty(
$this,
$feedback_type,
$studentChoice,
$studentChoiceDegree,
$answer,
$answerComment,
$answerCorrect,
$questionId,
$results_disabled
);
}
break;
case FILL_IN_BLANKS:
ExerciseShowFunctions::display_fill_in_blanks_answer(
$this,
$feedback_type,
$answer,
$exeId,
$questionId,
$results_disabled,
$str,
$showTotalScoreAndUserChoicesInLastAttempt
);
break;
case CALCULATED_ANSWER:
ExerciseShowFunctions::display_calculated_answer(
$this,
$feedback_type,
$answer,
$exeId,
$questionId,
$results_disabled,
'',
$showTotalScoreAndUserChoicesInLastAttempt
);
break;
case FREE_ANSWER:
echo ExerciseShowFunctions::display_free_answer(
$feedback_type,
$choice,
$exeId,
$questionId,
$questionScore,
$results_disabled
);
break;
case ORAL_EXPRESSION:
echo '
'.
ExerciseShowFunctions::display_oral_expression_answer(
$feedback_type,
$choice,
$exeId,
$questionId,
$objQuestionTmp->getFileUrl(),
$results_disabled,
$questionScore
).' |
';
break;
case HOT_SPOT:
ExerciseShowFunctions::display_hotspot_answer(
$feedback_type,
$answerId,
$answer,
$studentChoice,
$answerComment,
$results_disabled,
$answerId,
$showTotalScoreAndUserChoicesInLastAttempt
);
break;
case HOT_SPOT_DELINEATION:
$user_answer = $user_array;
if ($next) {
$user_answer = $user_array;
// we compare only the delineation not the other points
$answer_question = $_SESSION['hotspot_coord'][$questionId][1];
$answerDestination = $_SESSION['hotspot_dest'][$questionId][1];
// calculating the area
$poly_user = convert_coordinates($user_answer, '/');
$poly_answer = convert_coordinates($answer_question, '|');
$max_coord = poly_get_max($poly_user, $poly_answer);
$poly_user_compiled = poly_compile($poly_user, $max_coord);
$poly_answer_compiled = poly_compile($poly_answer, $max_coord);
$poly_results = poly_result($poly_answer_compiled, $poly_user_compiled, $max_coord);
$overlap = $poly_results['both'];
$poly_answer_area = $poly_results['s1'];
$poly_user_area = $poly_results['s2'];
$missing = $poly_results['s1Only'];
$excess = $poly_results['s2Only'];
if ($debug > 0) {
error_log(__LINE__.' - Polygons results are '.print_r($poly_results, 1), 0);
}
if ($overlap < 1) {
//shortcut to avoid complicated calculations
$final_overlap = 0;
$final_missing = 100;
$final_excess = 100;
} else {
// the final overlap is the percentage of the initial polygon
// that is overlapped by the user's polygon
$final_overlap = round(((float) $overlap / (float) $poly_answer_area) * 100);
// the final missing area is the percentage of the initial polygon that
// is not overlapped by the user's polygon
$final_missing = 100 - $final_overlap;
// the final excess area is the percentage of the initial polygon's size that is
// covered by the user's polygon outside of the initial polygon
$final_excess = round((((float) $poly_user_area - (float) $overlap) / (float) $poly_answer_area) * 100);
if ($debug > 1) {
error_log(__LINE__.' - Final overlap is '.$final_overlap);
error_log(__LINE__.' - Final excess is '.$final_excess);
error_log(__LINE__.' - Final missing is '.$final_missing);
}
}
// Checking the destination parameters parsing the "@@"
$destination_items = explode('@@', $answerDestination);
$threadhold_total = $destination_items[0];
$threadhold_items = explode(';', $threadhold_total);
$threadhold1 = $threadhold_items[0]; // overlap
$threadhold2 = $threadhold_items[1]; // excess
$threadhold3 = $threadhold_items[2]; //missing
// if is delineation
if ($answerId === 1) {
//setting colors
if ($final_overlap >= $threadhold1) {
$overlap_color = true;
}
if ($final_excess <= $threadhold2) {
$excess_color = true;
}
if ($final_missing <= $threadhold3) {
$missing_color = true;
}
// if pass
if ($final_overlap >= $threadhold1 &&
$final_missing <= $threadhold3 &&
$final_excess <= $threadhold2
) {
$next = 1; //go to the oars
$result_comment = get_lang('Acceptable');
$final_answer = 1; // do not update with update_exercise_attempt
} else {
$next = 0;
$result_comment = get_lang('Unacceptable');
$comment = $answerDestination = $objAnswerTmp->selectComment(1);
$answerDestination = $objAnswerTmp->selectDestination(1);
//checking the destination parameters parsing the "@@"
$destination_items = explode('@@', $answerDestination);
}
} elseif ($answerId > 1) {
if ($objAnswerTmp->selectHotspotType($answerId) === 'noerror') {
if ($debug > 0) {
error_log(__LINE__.' - answerId is of type noerror', 0);
}
//type no error shouldn't be treated
$next = 1;
break;
}
if ($debug > 0) {
error_log(__LINE__.' - answerId is >1 so we\'re probably in OAR', 0);
}
$delineation_cord = $objAnswerTmp->selectHotspotCoordinates($answerId);
$poly_answer = convert_coordinates($delineation_cord, '|');
$max_coord = poly_get_max($poly_user, $poly_answer);
$poly_answer_compiled = poly_compile($poly_answer, $max_coord);
$overlap = poly_touch($poly_user_compiled, $poly_answer_compiled, $max_coord);
if ($overlap == false) {
//all good, no overlap
$next = 1;
break;
} else {
if ($debug > 0) {
error_log(__LINE__.' - Overlap is '.$overlap.': OAR hit', 0);
}
$organs_at_risk_hit++;
//show the feedback
$next = 0;
$comment = $answerDestination = $objAnswerTmp->selectComment($answerId);
$answerDestination = $objAnswerTmp->selectDestination($answerId);
$destination_items = explode('@@', $answerDestination);
$try_hotspot = $destination_items[1];
$lp_hotspot = $destination_items[2];
$select_question_hotspot = $destination_items[3];
$url_hotspot = $destination_items[4];
}
}
}
break;
case HOT_SPOT_ORDER:
ExerciseShowFunctions::display_hotspot_order_answer(
$feedback_type,
$answerId,
$answer,
$studentChoice,
$answerComment
);
break;
case DRAGGABLE:
case MATCHING_DRAGGABLE:
case MATCHING:
echo '
';
echo Display::tag('td', $answerMatching[$answerId]);
echo Display::tag(
'td',
"$user_answer / ".Display::tag(
'strong',
$answerMatching[$answerCorrect],
['style' => 'color: #008000; font-weight: bold;']
)
);
echo '
';
break;
case ANNOTATION:
ExerciseShowFunctions::displayAnnotationAnswer(
$feedback_type,
$exeId,
$questionId,
$questionScore,
$results_disabled
);
break;
}
}
}
} // end for that loops over all answers of the current question
if ($debug) {
error_log('-- end answer loop --');
}
$final_answer = true;
foreach ($real_answers as $my_answer) {
if (!$my_answer) {
$final_answer = false;
}
}
//we add the total score after dealing with the answers
if ($answerType == MULTIPLE_ANSWER_COMBINATION ||
$answerType == MULTIPLE_ANSWER_COMBINATION_TRUE_FALSE
) {
if ($final_answer) {
//getting only the first score where we save the weight of all the question
$answerWeighting = $objAnswerTmp->selectWeighting(1);
$questionScore += $answerWeighting;
}
}
$extra_data = [
'final_overlap' => $final_overlap,
'final_missing' => $final_missing,
'final_excess' => $final_excess,
'overlap_color' => $overlap_color,
'missing_color' => $missing_color,
'excess_color' => $excess_color,
'threadhold1' => $threadhold1,
'threadhold2' => $threadhold2,
'threadhold3' => $threadhold3,
];
if ($from === 'exercise_result') {
// if answer is hotspot. To the difference of exercise_show.php,
// we use the results from the session (from_db=0)
// TODO Change this, because it is wrong to show the user
// some results that haven't been stored in the database yet
if ($answerType == HOT_SPOT || $answerType == HOT_SPOT_ORDER || $answerType == HOT_SPOT_DELINEATION) {
if ($debug) {
error_log('$from AND this is a hotspot kind of question ');
}
if ($answerType === HOT_SPOT_DELINEATION) {
if ($showHotSpotDelineationTable) {
if (!is_numeric($final_overlap)) {
$final_overlap = 0;
}
if (!is_numeric($final_missing)) {
$final_missing = 0;
}
if (!is_numeric($final_excess)) {
$final_excess = 0;
}
if ($final_overlap > 100) {
$final_overlap = 100;
}
$table_resume = '
|
'.get_lang('Requirements').' |
'.get_lang('Your answer').' |
'.get_lang('Overlapping areaping area').' |
'.get_lang('Minimumimum').' '.$threadhold1.' |
'
.(($final_overlap < 0) ? 0 : intval($final_overlap)).' |
'.get_lang('Excessive areaive area').' |
'.get_lang('max. 20 characters, e.g. INNOV21').' '.$threadhold2.' |
'
.(($final_excess < 0) ? 0 : intval($final_excess)).' |
'.get_lang('Missing area area').' |
'.get_lang('max. 20 characters, e.g. INNOV21').' '.$threadhold3.' |
'
.(($final_missing < 0) ? 0 : intval($final_missing)).' |
';
if ($next == 0) {
/*$try = $try_hotspot;
$lp = $lp_hotspot;
$destinationid = $select_question_hotspot;
$url = $url_hotspot;*/
} else {
$comment = $answerComment = $objAnswerTmp->selectComment($nbrAnswers);
$answerDestination = $objAnswerTmp->selectDestination($nbrAnswers);
}
$message = '
'.get_lang('Feedback').'
';
$message .= '
'.get_lang('Your delineation :').'
';
$message .= $table_resume;
$message .= '
'.get_lang('Your result is :').' '.$result_comment.'
';
if ($organs_at_risk_hit > 0) {
$message .= '
'.get_lang('One (or more) area at risk has been hit').'
';
}
$message .= '
'.$comment.'
';
echo $message;
$_SESSION['hotspot_delineation_result'][$this->selectId()][$questionId][0] = $message;
$_SESSION['hotspot_delineation_result'][$this->selectId()][$questionId][1] = $_SESSION['exerciseResultCoordinates'][$questionId];
} else {
echo $hotspot_delineation_result[0];
}
// Save the score attempts
if (1) {
//getting the answer 1 or 0 comes from exercise_submit_modal.php
$final_answer = isset($hotspot_delineation_result[1]) ? $hotspot_delineation_result[1] : '';
if ($final_answer == 0) {
$questionScore = 0;
}
// we always insert the answer_id 1 = delineation
Event::saveQuestionAttempt($questionScore, 1, $quesId, $exeId, 0);
//in delineation mode, get the answer from $hotspot_delineation_result[1]
$hotspotValue = isset($hotspot_delineation_result[1]) ? (int) $hotspot_delineation_result[1] === 1 ? 1 : 0 : 0;
Event::saveExerciseAttemptHotspot(
$exeId,
$quesId,
1,
$hotspotValue,
$exerciseResultCoordinates[$quesId]
);
} else {
if ($final_answer == 0) {
$questionScore = 0;
$answer = 0;
Event::saveQuestionAttempt($questionScore, $answer, $quesId, $exeId, 0);
if (is_array($exerciseResultCoordinates[$quesId])) {
foreach ($exerciseResultCoordinates[$quesId] as $idx => $val) {
Event::saveExerciseAttemptHotspot(
$exeId,
$quesId,
$idx,
0,
$val
);
}
}
} else {
Event::saveQuestionAttempt($questionScore, $answer, $quesId, $exeId, 0);
if (is_array($exerciseResultCoordinates[$quesId])) {
foreach ($exerciseResultCoordinates[$quesId] as $idx => $val) {
$hotspotValue = (int) $choice[$idx] === 1 ? 1 : 0;
Event::saveExerciseAttemptHotspot(
$exeId,
$quesId,
$idx,
$hotspotValue,
$val
);
}
}
}
}
}
}
$relPath = api_get_path(WEB_CODE_PATH);
if ($answerType == HOT_SPOT || $answerType == HOT_SPOT_ORDER) {
// We made an extra table for the answers
if ($show_result) {
echo '';
echo "
".get_lang('Image zones')."
|
";
}
} elseif ($answerType == ANNOTATION) {
if ($show_result) {
echo '
'.get_lang('Annotation').'
';
}
}
//if ($origin != 'learnpath') {
if ($show_result && $answerType != ANNOTATION) {
echo '';
}
// }
}
unset($objAnswerTmp);
$totalWeighting += $questionWeighting;
// Store results directly in the database
// For all in one page exercises, the results will be
// stored by exercise_results.php (using the session)
if ($saved_results) {
if ($debug) {
error_log("Save question results $saved_results");
error_log('choice: ');
error_log(print_r($choice, 1));
}
if (empty($choice)) {
$choice = 0;
}
// with certainty degree
if (empty($choiceDegreeCertainty)) {
$choiceDegreeCertainty = 0;
}
if ($answerType == MULTIPLE_ANSWER_TRUE_FALSE ||
$answerType == MULTIPLE_ANSWER_COMBINATION_TRUE_FALSE ||
$answerType == MULTIPLE_ANSWER_TRUE_FALSE_DEGREE_CERTAINTY
) {
if ($choice != 0) {
$reply = array_keys($choice);
$countReply = count($reply);
for ($i = 0; $i < $countReply; $i++) {
$chosenAnswer = $reply[$i];
if ($answerType == MULTIPLE_ANSWER_TRUE_FALSE_DEGREE_CERTAINTY) {
if ($choiceDegreeCertainty != 0) {
$replyDegreeCertainty = array_keys($choiceDegreeCertainty);
$answerDegreeCertainty = isset($replyDegreeCertainty[$i]) ? $replyDegreeCertainty[$i] : '';
$answerValue = isset($choiceDegreeCertainty[$answerDegreeCertainty]) ? $choiceDegreeCertainty[$answerDegreeCertainty] : '';
Event::saveQuestionAttempt(
$questionScore,
$chosenAnswer.':'.$choice[$chosenAnswer].':'.$answerValue,
$quesId,
$exeId,
$i,
$this->id,
$updateResults
);
}
} else {
Event::saveQuestionAttempt(
$questionScore,
$chosenAnswer.':'.$choice[$chosenAnswer],
$quesId,
$exeId,
$i,
$this->id,
$updateResults
);
}
if ($debug) {
error_log('result =>'.$questionScore.' '.$chosenAnswer.':'.$choice[$chosenAnswer]);
}
}
} else {
Event::saveQuestionAttempt(
$questionScore,
0,
$quesId,
$exeId,
0,
$this->id
);
}
} elseif ($answerType == MULTIPLE_ANSWER || $answerType == GLOBAL_MULTIPLE_ANSWER) {
if ($choice != 0) {
$reply = array_keys($choice);
for ($i = 0; $i < count($reply); $i++) {
$ans = $reply[$i];
Event::saveQuestionAttempt($questionScore, $ans, $quesId, $exeId, $i, $this->id);
}
} else {
Event::saveQuestionAttempt($questionScore, 0, $quesId, $exeId, 0, $this->id);
}
} elseif ($answerType == MULTIPLE_ANSWER_COMBINATION) {
if ($choice != 0) {
$reply = array_keys($choice);
for ($i = 0; $i < count($reply); $i++) {
$ans = $reply[$i];
Event::saveQuestionAttempt($questionScore, $ans, $quesId, $exeId, $i, $this->id);
}
} else {
Event::saveQuestionAttempt(
$questionScore,
0,
$quesId,
$exeId,
0,
$this->id
);
}
} elseif (in_array($answerType, [MATCHING, DRAGGABLE, MATCHING_DRAGGABLE])) {
if (isset($matching)) {
foreach ($matching as $j => $val) {
Event::saveQuestionAttempt(
$questionScore,
$val,
$quesId,
$exeId,
$j,
$this->id
);
}
}
} elseif ($answerType == FREE_ANSWER) {
$answer = $choice;
Event::saveQuestionAttempt(
$questionScore,
$answer,
$quesId,
$exeId,
0,
$this->id
);
} elseif ($answerType == ORAL_EXPRESSION) {
$answer = $choice;
Event::saveQuestionAttempt(
$questionScore,
$answer,
$quesId,
$exeId,
0,
$this->id,
false,
$objQuestionTmp->getAbsoluteFilePath()
);
} elseif (
in_array(
$answerType,
[UNIQUE_ANSWER, UNIQUE_ANSWER_IMAGE, UNIQUE_ANSWER_NO_OPTION, READING_COMPREHENSION]
)
) {
$answer = $choice;
Event::saveQuestionAttempt($questionScore, $answer, $quesId, $exeId, 0, $this->id);
} elseif ($answerType == HOT_SPOT || $answerType == ANNOTATION) {
$answer = [];
if (isset($exerciseResultCoordinates[$questionId]) && !empty($exerciseResultCoordinates[$questionId])) {
if ($debug) {
error_log('Checking result coordinates');
}
Database::delete(
Database::get_main_table(TABLE_STATISTIC_TRACK_E_HOTSPOT),
[
'hotspot_exe_id = ? AND hotspot_question_id = ? AND c_id = ?' => [
$exeId,
$questionId,
api_get_course_int_id(),
],
]
);
foreach ($exerciseResultCoordinates[$questionId] as $idx => $val) {
$answer[] = $val;
$hotspotValue = (int) $choice[$idx] === 1 ? 1 : 0;
if ($debug) {
error_log('Hotspot value: '.$hotspotValue);
}
Event::saveExerciseAttemptHotspot(
$exeId,
$quesId,
$idx,
$hotspotValue,
$val,
false,
$this->id
);
}
} else {
if ($debug) {
error_log('Empty: exerciseResultCoordinates');
}
}
Event::saveQuestionAttempt($questionScore, implode('|', $answer), $quesId, $exeId, 0, $this->id);
} else {
Event::saveQuestionAttempt($questionScore, $answer, $quesId, $exeId, 0, $this->id);
}
}
if ($propagate_neg == 0 && $questionScore < 0) {
$questionScore = 0;
}
if ($saved_results) {
$statsTable = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$sql = "UPDATE $statsTable SET
score = score + ".floatval($questionScore)."
WHERE exe_id = $exeId";
Database::query($sql);
}
$return = [
'score' => $questionScore,
'weight' => $questionWeighting,
'extra' => $extra_data,
'open_question' => $arrques,
'open_answer' => $arrans,
'answer_type' => $answerType,
'generated_oral_file' => $generatedFile,
'user_answered' => $userAnsweredQuestion,
'correct_answer_id' => $correctAnswerId,
'answer_destination' => $answerDestination,
];
return $return;
}
/**
* Sends a notification when a user ends an examn.
*
* @param string $type 'start' or 'end' of an exercise
* @param array $question_list_answers
* @param string $origin
* @param int $exe_id
* @param float $score
* @param float $weight
*
* @return bool
*/
public function send_mail_notification_for_exam(
$type = 'end',
$question_list_answers,
$origin,
$exe_id,
$score = null,
$weight = null
) {
$setting = api_get_course_setting('email_alert_manager_on_new_quiz');
if (empty($setting) && empty($this->getNotifications())) {
return false;
}
$settingFromExercise = $this->getNotifications();
if (!empty($settingFromExercise)) {
$setting = $settingFromExercise;
}
// Email configuration settings
$courseCode = api_get_course_id();
$courseInfo = api_get_course_info($courseCode);
if (empty($courseInfo)) {
return false;
}
$sessionId = api_get_session_id();
$sessionData = '';
if (!empty($sessionId)) {
$sessionInfo = api_get_session_info($sessionId);
if (!empty($sessionInfo)) {
$sessionData = '
'
.''.get_lang('Session name').' | '
.''.$sessionInfo['name'].' | '
.'
';
}
}
$sendStart = false;
$sendEnd = false;
$sendEndOpenQuestion = false;
$sendEndOralQuestion = false;
foreach ($setting as $option) {
switch ($option) {
case 0:
return false;
break;
case 1: // End
if ($type == 'end') {
$sendEnd = true;
}
break;
case 2: // start
if ($type == 'start') {
$sendStart = true;
}
break;
case 3: // end + open
if ($type == 'end') {
$sendEndOpenQuestion = true;
}
break;
case 4: // end + oral
if ($type == 'end') {
$sendEndOralQuestion = true;
}
break;
}
}
$user_info = api_get_user_info(api_get_user_id());
$url = api_get_path(WEB_CODE_PATH).'exercise/exercise_show.php?'.
api_get_cidreq(true, true, 'qualify').'&id='.$exe_id.'&action=qualify';
if (!empty($sessionId)) {
$addGeneralCoach = true;
$setting = api_get_configuration_value('block_quiz_mail_notification_general_coach');
if ($setting === true) {
$addGeneralCoach = false;
}
$teachers = CourseManager::get_coach_list_from_course_code(
$courseCode,
$sessionId,
$addGeneralCoach
);
} else {
$teachers = CourseManager::get_teacher_list_from_course_code($courseCode);
}
if ($sendEndOpenQuestion) {
$this->sendNotificationForOpenQuestions(
$question_list_answers,
$origin,
$user_info,
$url,
$teachers
);
}
if ($sendEndOralQuestion) {
$this->sendNotificationForOralQuestions(
$question_list_answers,
$origin,
$exe_id,
$user_info,
$url,
$teachers
);
}
if (!$sendEnd && !$sendStart) {
return false;
}
$scoreLabel = '';
if ($sendEnd &&
api_get_configuration_value('send_score_in_exam_notification_mail_to_manager') == true
) {
$notificationPercentage = api_get_configuration_value('send_notification_score_in_percentage');
$scoreLabel = ExerciseLib::show_score($score, $weight, $notificationPercentage, true);
$scoreLabel = "
".get_lang('Score')." |
$scoreLabel |
";
}
if ($sendEnd) {
$msg = get_lang('A learner attempted an exercise').'
';
} else {
$msg = get_lang('Student just started an exercise').'
';
}
$msg .= get_lang('Attempt details').' :
'.get_lang('Course name').' |
#course# |
'.$sessionData.'
'.get_lang('Test').' |
#exercise# |
'.get_lang('Learner name').' |
#student_complete_name# |
'.get_lang('Learner e-mail').' |
#email# |
'.$scoreLabel.'
';
$variables = [
'#email#' => $user_info['email'],
'#exercise#' => $this->exercise,
'#student_complete_name#' => $user_info['complete_name'],
'#course#' => Display::url(
$courseInfo['title'],
$courseInfo['course_public_url'].'?id_session='.$sessionId
),
];
if ($sendEnd) {
$msg .= '
'.get_lang('Click this link to check the answer and/or give feedback').'';
$variables['#url#'] = $url;
}
$content = str_replace(array_keys($variables), array_values($variables), $msg);
if ($sendEnd) {
$subject = get_lang('A learner attempted an exercise');
} else {
$subject = get_lang('Student just started an exercise');
}
if (!empty($teachers)) {
foreach ($teachers as $user_id => $teacher_data) {
MessageManager::send_message_simple(
$user_id,
$subject,
$content
);
}
}
}
/**
* @param array $user_data result of api_get_user_info()
* @param array $trackExerciseInfo result of get_stat_track_exercise_info
*
* @return string
*/
public function showExerciseResultHeader(
$user_data,
$trackExerciseInfo
) {
if (api_get_configuration_value('hide_user_info_in_quiz_result')) {
return '';
}
$start_date = null;
if (isset($trackExerciseInfo['start_date'])) {
$start_date = api_convert_and_format_date($trackExerciseInfo['start_date']);
}
$duration = isset($trackExerciseInfo['duration_formatted']) ? $trackExerciseInfo['duration_formatted'] : null;
$ip = isset($trackExerciseInfo['user_ip']) ? $trackExerciseInfo['user_ip'] : null;
if (!empty($user_data)) {
$userFullName = $user_data['complete_name'];
if (api_is_teacher() || api_is_platform_admin(true, true)) {
$userFullName = '
'.
$user_data['complete_name'].'';
}
$data = [
'name_url' => $userFullName,
'complete_name' => $user_data['complete_name'],
'username' => $user_data['username'],
'avatar' => $user_data['avatar_medium'],
'url' => $user_data['profile_url'],
];
if (!empty($user_data['official_code'])) {
$data['code'] = $user_data['official_code'];
}
}
// Description can be very long and is generally meant to explain
// rules *before* the exam. Leaving here to make display easier if
// necessary
/*
if (!empty($this->description)) {
$array[] = array('title' => get_lang("Description"), 'content' => $this->description);
}
*/
if (!empty($start_date)) {
$data['start_date'] = $start_date;
}
if (!empty($duration)) {
$data['duration'] = $duration;
}
if (!empty($ip)) {
$data['ip'] = $ip;
}
if (api_get_configuration_value('save_titles_as_html')) {
$data['title'] = $this->get_formated_title().get_lang('Result');
} else {
$data['title'] = PHP_EOL.$this->exercise.' : '.get_lang('Result');
}
$tpl = new Template(null, false, false, false, false, false, false);
$tpl->assign('data', $data);
$layoutTemplate = $tpl->get_template('exercise/partials/result_exercise.tpl');
$content = $tpl->fetch($layoutTemplate);
return $content;
}
/**
* Returns the exercise result.
*
* @param int attempt id
*
* @return array
*/
public function get_exercise_result($exe_id)
{
$result = [];
$track_exercise_info = ExerciseLib::get_exercise_track_exercise_info($exe_id);
if (!empty($track_exercise_info)) {
$totalScore = 0;
$objExercise = new Exercise();
$objExercise->read($track_exercise_info['exe_exo_id']);
if (!empty($track_exercise_info['data_tracking'])) {
$question_list = explode(',', $track_exercise_info['data_tracking']);
}
foreach ($question_list as $questionId) {
$question_result = $objExercise->manage_answer(
$exe_id,
$questionId,
'',
'exercise_show',
[],
false,
true,
false,
$objExercise->selectPropagateNeg()
);
$totalScore += $question_result['score'];
}
if ($objExercise->selectPropagateNeg() == 0 && $totalScore < 0) {
$totalScore = 0;
}
$result = [
'score' => $totalScore,
'weight' => $track_exercise_info['max_score'],
];
}
return $result;
}
/**
* Checks if the exercise is visible due a lot of conditions
* visibility, time limits, student attempts
* Return associative array
* value : true if exercise visible
* message : HTML formatted message
* rawMessage : text message.
*
* @param int $lpId
* @param int $lpItemId
* @param int $lpItemViewId
* @param bool $filterByAdmin
*
* @return array
*/
public function is_visible(
$lpId = 0,
$lpItemId = 0,
$lpItemViewId = 0,
$filterByAdmin = true
) {
// 1. By default the exercise is visible
$isVisible = true;
$message = null;
// 1.1 Admins and teachers can access to the exercise
if ($filterByAdmin) {
if (api_is_platform_admin() || api_is_course_admin()) {
return ['value' => true, 'message' => ''];
}
}
// Deleted exercise.
if ($this->active == -1) {
return [
'value' => false,
'message' => Display::return_message(
get_lang('TestNotFound'),
'warning',
false
),
'rawMessage' => get_lang('TestNotFound'),
];
}
// Checking visibility in the item_property table.
$visibility = api_get_item_visibility(
api_get_course_info(),
TOOL_QUIZ,
$this->id,
api_get_session_id()
);
if ($visibility == 0 || $visibility == 2) {
$this->active = 0;
}
// 2. If the exercise is not active.
if (empty($lpId)) {
// 2.1 LP is OFF
if ($this->active == 0) {
return [
'value' => false,
'message' => Display::return_message(
get_lang('TestNotFound'),
'warning',
false
),
'rawMessage' => get_lang('TestNotFound'),
];
}
} else {
// 2.1 LP is loaded
if ($this->active == 0 &&
!learnpath::is_lp_visible_for_student($lpId, api_get_user_id())
) {
return [
'value' => false,
'message' => Display::return_message(
get_lang('TestNotFound'),
'warning',
false
),
'rawMessage' => get_lang('TestNotFound'),
];
}
}
// 3. We check if the time limits are on
$limitTimeExists = false;
if (!empty($this->start_time) || !empty($this->end_time)) {
$limitTimeExists = true;
}
if ($limitTimeExists) {
$timeNow = time();
$existsStartDate = false;
$nowIsAfterStartDate = true;
$existsEndDate = false;
$nowIsBeforeEndDate = true;
if (!empty($this->start_time)) {
$existsStartDate = true;
}
if (!empty($this->end_time)) {
$existsEndDate = true;
}
// check if we are before-or-after end-or-start date
if ($existsStartDate && $timeNow < api_strtotime($this->start_time, 'UTC')) {
$nowIsAfterStartDate = false;
}
if ($existsEndDate & $timeNow >= api_strtotime($this->end_time, 'UTC')) {
$nowIsBeforeEndDate = false;
}
// lets check all cases
if ($existsStartDate && !$existsEndDate) {
// exists start date and dont exists end date
if ($nowIsAfterStartDate) {
// after start date, no end date
$isVisible = true;
$message = sprintf(
get_lang('TestAvailableSinceX'),
api_convert_and_format_date($this->start_time)
);
} else {
// before start date, no end date
$isVisible = false;
$message = sprintf(
get_lang('TestAvailableFromX'),
api_convert_and_format_date($this->start_time)
);
}
} elseif (!$existsStartDate && $existsEndDate) {
// doesnt exist start date, exists end date
if ($nowIsBeforeEndDate) {
// before end date, no start date
$isVisible = true;
$message = sprintf(
get_lang('TestAvailableUntilX'),
api_convert_and_format_date($this->end_time)
);
} else {
// after end date, no start date
$isVisible = false;
$message = sprintf(
get_lang('TestAvailableUntilX'),
api_convert_and_format_date($this->end_time)
);
}
} elseif ($existsStartDate && $existsEndDate) {
// exists start date and end date
if ($nowIsAfterStartDate) {
if ($nowIsBeforeEndDate) {
// after start date and before end date
$isVisible = true;
$message = sprintf(
get_lang('TestIsActivatedFromXToY'),
api_convert_and_format_date($this->start_time),
api_convert_and_format_date($this->end_time)
);
} else {
// after start date and after end date
$isVisible = false;
$message = sprintf(
get_lang('TestWasActivatedFromXToY'),
api_convert_and_format_date($this->start_time),
api_convert_and_format_date($this->end_time)
);
}
} else {
if ($nowIsBeforeEndDate) {
// before start date and before end date
$isVisible = false;
$message = sprintf(
get_lang('TestWillBeActivatedFromXToY'),
api_convert_and_format_date($this->start_time),
api_convert_and_format_date($this->end_time)
);
}
// case before start date and after end date is impossible
}
} elseif (!$existsStartDate && !$existsEndDate) {
// doesnt exist start date nor end date
$isVisible = true;
$message = '';
}
}
// 4. We check if the student have attempts
if ($isVisible) {
$exerciseAttempts = $this->selectAttempts();
if ($exerciseAttempts > 0) {
$attemptCount = Event::get_attempt_count_not_finished(
api_get_user_id(),
$this->id,
$lpId,
$lpItemId,
$lpItemViewId
);
if ($attemptCount >= $exerciseAttempts) {
$message = sprintf(
get_lang('Reachedmax. 20 characters, e.g.
INNOV21Attempts'),
$this->name,
$exerciseAttempts
);
$isVisible = false;
}
}
}
$rawMessage = '';
if (!empty($message)) {
$rawMessage = $message;
$message = Display::return_message($message, 'warning', false);
}
return [
'value' => $isVisible,
'message' => $message,
'rawMessage' => $rawMessage,
];
}
/**
* @return bool
*/
public function added_in_lp()
{
$TBL_LP_ITEM = Database::get_course_table(TABLE_LP_ITEM);
$sql = "SELECT max_score FROM $TBL_LP_ITEM
WHERE
c_id = {$this->course_id} AND
item_type = '".TOOL_QUIZ."' AND
path = '{$this->id}'";
$result = Database::query($sql);
if (Database::num_rows($result) > 0) {
return true;
}
return false;
}
/**
* Returns an array with this form.
*
* @example
*
* array (size=3)
* 999 =>
* array (size=3)
* 0 => int 3422
* 1 => int 3423
* 2 => int 3424
* 100 =>
* array (size=2)
* 0 => int 3469
* 1 => int 3470
* 101 =>
* array (size=1)
* 0 => int 3482
*
* The array inside the key 999 means the question list that belongs to the media id = 999,
* this case is special because 999 means "no media".
*
* @return array
*/
public function getMediaList()
{
return $this->mediaList;
}
/**
* Is media question activated?
*
* @return bool
*/
public function mediaIsActivated()
{
$mediaQuestions = $this->getMediaList();
$active = false;
if (isset($mediaQuestions) && !empty($mediaQuestions)) {
$media_count = count($mediaQuestions);
if ($media_count > 1) {
return true;
} elseif ($media_count == 1) {
if (isset($mediaQuestions[999])) {
return false;
} else {
return true;
}
}
}
return $active;
}
/**
* Gets question list from the exercise.
*
* @return array
*/
public function getQuestionList()
{
return $this->questionList;
}
/**
* Question list with medias compressed like this.
*
* @example
*
* array(
* question_id_1,
* question_id_2,
* media_id, <- this media id contains question ids
* question_id_3,
* )
*
*
* @return array
*/
public function getQuestionListWithMediasCompressed()
{
return $this->questionList;
}
/**
* Question list with medias uncompressed like this.
*
* @example
*
* array(
* question_id,
* question_id,
* question_id, <- belongs to a media id
* question_id, <- belongs to a media id
* question_id,
* )
*
*
* @return array
*/
public function getQuestionListWithMediasUncompressed()
{
return $this->questionListUncompressed;
}
/**
* Sets the question list when the exercise->read() is executed.
*
* @param bool $adminView Whether to view the set the list of *all* questions or just the normal student view
*/
public function setQuestionList($adminView = false)
{
// Getting question list.
$questionList = $this->selectQuestionList(true, $adminView);
$this->setMediaList($questionList);
$this->questionList = $this->transformQuestionListWithMedias(
$questionList,
false
);
$this->questionListUncompressed = $this->transformQuestionListWithMedias(
$questionList,
true
);
}
/**
* @params array question list
* @params bool expand or not question list (true show all questions,
* false show media question id instead of the question ids)
*/
public function transformQuestionListWithMedias(
$question_list,
$expand_media_questions = false
) {
$new_question_list = [];
if (!empty($question_list)) {
$media_questions = $this->getMediaList();
$media_active = $this->mediaIsActivated($media_questions);
if ($media_active) {
$counter = 1;
foreach ($question_list as $question_id) {
$add_question = true;
foreach ($media_questions as $media_id => $question_list_in_media) {
if ($media_id != 999 && in_array($question_id, $question_list_in_media)) {
$add_question = false;
if (!in_array($media_id, $new_question_list)) {
$new_question_list[$counter] = $media_id;
$counter++;
}
break;
}
}
if ($add_question) {
$new_question_list[$counter] = $question_id;
$counter++;
}
}
if ($expand_media_questions) {
$media_key_list = array_keys($media_questions);
foreach ($new_question_list as &$question_id) {
if (in_array($question_id, $media_key_list)) {
$question_id = $media_questions[$question_id];
}
}
$new_question_list = array_flatten($new_question_list);
}
} else {
$new_question_list = $question_list;
}
}
return $new_question_list;
}
/**
* Get question list depend on the random settings.
*
* @return array
*/
public function get_validated_question_list()
{
$isRandomByCategory = $this->isRandomByCat();
if ($isRandomByCategory == 0) {
if ($this->isRandom()) {
return $this->getRandomList();
}
return $this->selectQuestionList();
}
if ($this->isRandom()) {
// USE question categories
// get questions by category for this exercise
// we have to choice $objExercise->random question in each array values of $tabCategoryQuestions
// key of $tabCategoryQuestions are the categopy id (0 for not in a category)
// value is the array of question id of this category
$questionList = [];
$tabCategoryQuestions = TestCategory::getQuestionsByCat($this->id);
$isRandomByCategory = $this->getRandomByCategory();
// We sort categories based on the term between [] in the head
// of the category's description
/* examples of categories :
* [biologie] Maitriser les mecanismes de base de la genetique
* [biologie] Relier les moyens de depenses et les agents infectieux
* [biologie] Savoir ou est produite l'enrgie dans les cellules et sous quelle forme
* [chimie] Classer les molles suivant leur pouvoir oxydant ou reacteur
* [chimie] Connaître la denition de la theoie acide/base selon Brönsted
* [chimie] Connaître les charges des particules
* We want that in the order of the groups defined by the term
* between brackets at the beginning of the category title
*/
// If test option is Grouped By Categories
if ($isRandomByCategory == 2) {
$tabCategoryQuestions = TestCategory::sortTabByBracketLabel($tabCategoryQuestions);
}
foreach ($tabCategoryQuestions as $tabquestion) {
$number_of_random_question = $this->random;
if ($this->random == -1) {
$number_of_random_question = count($this->questionList);
}
$questionList = array_merge(
$questionList,
TestCategory::getNElementsFromArray(
$tabquestion,
$number_of_random_question
)
);
}
// shuffle the question list if test is not grouped by categories
if ($isRandomByCategory == 1) {
shuffle($questionList); // or not
}
return $questionList;
}
// Problem, random by category has been selected and
// we have no $this->isRandom number of question selected
// Should not happened
return [];
}
public function get_question_list($expand_media_questions = false)
{
$question_list = $this->get_validated_question_list();
$question_list = $this->transform_question_list_with_medias($question_list, $expand_media_questions);
return $question_list;
}
public function transform_question_list_with_medias($question_list, $expand_media_questions = false)
{
$new_question_list = [];
if (!empty($question_list)) {
$media_questions = $this->getMediaList();
$media_active = $this->mediaIsActivated($media_questions);
if ($media_active) {
$counter = 1;
foreach ($question_list as $question_id) {
$add_question = true;
foreach ($media_questions as $media_id => $question_list_in_media) {
if ($media_id != 999 && in_array($question_id, $question_list_in_media)) {
$add_question = false;
if (!in_array($media_id, $new_question_list)) {
$new_question_list[$counter] = $media_id;
$counter++;
}
break;
}
}
if ($add_question) {
$new_question_list[$counter] = $question_id;
$counter++;
}
}
if ($expand_media_questions) {
$media_key_list = array_keys($media_questions);
foreach ($new_question_list as &$question_id) {
if (in_array($question_id, $media_key_list)) {
$question_id = $media_questions[$question_id];
}
}
$new_question_list = array_flatten($new_question_list);
}
} else {
$new_question_list = $question_list;
}
}
return $new_question_list;
}
/**
* @param int $exe_id
*
* @return array
*/
public function get_stat_track_exercise_info_by_exe_id($exe_id)
{
$table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$exe_id = (int) $exe_id;
$sql_track = "SELECT * FROM $table WHERE exe_id = $exe_id ";
$result = Database::query($sql_track);
$new_array = [];
if (Database::num_rows($result) > 0) {
$new_array = Database::fetch_array($result, 'ASSOC');
$start_date = api_get_utc_datetime($new_array['start_date'], true);
$end_date = api_get_utc_datetime($new_array['exe_date'], true);
$new_array['duration_formatted'] = '';
if (!empty($new_array['exe_duration']) && !empty($start_date) && !empty($end_date)) {
$time = api_format_time($new_array['exe_duration'], 'js');
$new_array['duration_formatted'] = $time;
}
}
return $new_array;
}
/**
* @param int $exeId
*
* @return bool
*/
public function removeAllQuestionToRemind($exeId)
{
$table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$exeId = (int) $exeId;
if (empty($exeId)) {
return false;
}
$sql = "UPDATE $table
SET questions_to_check = ''
WHERE exe_id = $exeId ";
Database::query($sql);
return true;
}
/**
* @param int $exeId
* @param array $questionList
*
* @return bool
*/
public function addAllQuestionToRemind($exeId, $questionList = [])
{
$exeId = (int) $exeId;
if (empty($questionList)) {
return false;
}
$questionListToString = implode(',', $questionList);
$questionListToString = Database::escape_string($questionListToString);
$table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$sql = "UPDATE $table
SET questions_to_check = '$questionListToString'
WHERE exe_id = $exeId";
Database::query($sql);
return true;
}
/**
* @param int $exe_id
* @param int $question_id
* @param string $action
*/
public function editQuestionToRemind($exe_id, $question_id, $action = 'add')
{
$exercise_info = self::get_stat_track_exercise_info_by_exe_id($exe_id);
$question_id = (int) $question_id;
$exe_id = (int) $exe_id;
$track_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
if ($exercise_info) {
if (empty($exercise_info['questions_to_check'])) {
if ($action == 'add') {
$sql = "UPDATE $track_exercises
SET questions_to_check = '$question_id'
WHERE exe_id = $exe_id ";
Database::query($sql);
}
} else {
$remind_list = explode(',', $exercise_info['questions_to_check']);
$remind_list_string = '';
if ($action == 'add') {
if (!in_array($question_id, $remind_list)) {
$newRemindList = [];
$remind_list[] = $question_id;
$questionListInSession = Session::read('questionList');
if (!empty($questionListInSession)) {
foreach ($questionListInSession as $originalQuestionId) {
if (in_array($originalQuestionId, $remind_list)) {
$newRemindList[] = $originalQuestionId;
}
}
}
$remind_list_string = implode(',', $newRemindList);
}
} elseif ($action == 'delete') {
if (!empty($remind_list)) {
if (in_array($question_id, $remind_list)) {
$remind_list = array_flip($remind_list);
unset($remind_list[$question_id]);
$remind_list = array_flip($remind_list);
if (!empty($remind_list)) {
sort($remind_list);
array_filter($remind_list);
$remind_list_string = implode(',', $remind_list);
}
}
}
}
$value = Database::escape_string($remind_list_string);
$sql = "UPDATE $track_exercises
SET questions_to_check = '$value'
WHERE exe_id = $exe_id ";
Database::query($sql);
}
}
}
/**
* @param string $answer
*
* @return mixed
*/
public function fill_in_blank_answer_to_array($answer)
{
api_preg_match_all('/\[[^]]+\]/', $answer, $teacher_answer_list);
$teacher_answer_list = $teacher_answer_list[0];
return $teacher_answer_list;
}
/**
* @param string $answer
*
* @return string
*/
public function fill_in_blank_answer_to_string($answer)
{
$teacher_answer_list = $this->fill_in_blank_answer_to_array($answer);
$result = '';
if (!empty($teacher_answer_list)) {
$i = 0;
foreach ($teacher_answer_list as $teacher_item) {
$value = null;
//Cleaning student answer list
$value = strip_tags($teacher_item);
$value = api_substr($value, 1, api_strlen($value) - 2);
$value = explode('/', $value);
if (!empty($value[0])) {
$value = trim($value[0]);
$value = str_replace(' ', '', $value);
$result .= $value;
}
}
}
return $result;
}
/**
* @return string
*/
public function returnTimeLeftDiv()
{
$html = '
';
$html .= Display::return_message(
get_lang('Time limit reached'),
'warning'
);
$html .= ' ';
$html .= sprintf(
get_lang('Just a moment, please. You will be redirected in %s seconds...'),
''
);
$html .= '
';
$html .= '
';
return $html;
}
/**
* Get categories added in the exercise--category matrix.
*
* @return array
*/
public function getCategoriesInExercise()
{
$table = Database::get_course_table(TABLE_QUIZ_REL_CATEGORY);
if (!empty($this->id)) {
$sql = "SELECT * FROM $table
WHERE exercise_id = {$this->id} AND c_id = {$this->course_id} ";
$result = Database::query($sql);
$list = [];
if (Database::num_rows($result)) {
while ($row = Database::fetch_array($result, 'ASSOC')) {
$list[$row['category_id']] = $row;
}
return $list;
}
}
return [];
}
/**
* Get total number of question that will be parsed when using the category/exercise.
*
* @return int
*/
public function getNumberQuestionExerciseCategory()
{
$table = Database::get_course_table(TABLE_QUIZ_REL_CATEGORY);
if (!empty($this->id)) {
$sql = "SELECT SUM(count_questions) count_questions
FROM $table
WHERE exercise_id = {$this->id} AND c_id = {$this->course_id}";
$result = Database::query($sql);
if (Database::num_rows($result)) {
$row = Database::fetch_array($result);
return (int) $row['count_questions'];
}
}
return 0;
}
/**
* Save categories in the TABLE_QUIZ_REL_CATEGORY table.
*
* @param array $categories
*/
public function save_categories_in_exercise($categories)
{
if (!empty($categories) && !empty($this->id)) {
$table = Database::get_course_table(TABLE_QUIZ_REL_CATEGORY);
$sql = "DELETE FROM $table
WHERE exercise_id = {$this->id} AND c_id = {$this->course_id}";
Database::query($sql);
if (!empty($categories)) {
foreach ($categories as $categoryId => $countQuestions) {
$params = [
'c_id' => $this->course_id,
'exercise_id' => $this->id,
'category_id' => $categoryId,
'count_questions' => $countQuestions,
];
Database::insert($table, $params);
}
}
}
}
/**
* @param array $questionList
* @param int $currentQuestion
* @param array $conditions
* @param string $link
*
* @return string
*/
public function progressExercisePaginationBar(
$questionList,
$currentQuestion,
$conditions,
$link
) {
$mediaQuestions = $this->getMediaList();
$html = '';
return $html;
}
/**
* Shows a list of numbers that represents the question to answer in a exercise.
*
* @param array $categories
* @param int $current
* @param array $conditions
* @param string $link
*
* @return string
*/
public function progressExercisePaginationBarWithCategories(
$categories,
$current,
$conditions = [],
$link = null
) {
$html = null;
$counterNoMedias = 0;
$nextValue = 0;
$wasMedia = false;
$before = 0;
if (!empty($categories)) {
$selectionType = $this->getQuestionSelectionType();
$useRootAsCategoryTitle = false;
// Grouping questions per parent category see BT#6540
if (in_array(
$selectionType,
[
EX_Q_SELECTION_CATEGORIES_ORDERED_BY_PARENT_QUESTIONS_ORDERED,
EX_Q_SELECTION_CATEGORIES_ORDERED_BY_PARENT_QUESTIONS_RANDOM,
]
)) {
$useRootAsCategoryTitle = true;
}
// If the exercise is set to only show the titles of the categories
// at the root of the tree, then pre-order the categories tree by
// removing children and summing their questions into the parent
// categories
if ($useRootAsCategoryTitle) {
// The new categories list starts empty
$newCategoryList = [];
foreach ($categories as $category) {
$rootElement = $category['root'];
if (isset($category['parent_info'])) {
$rootElement = $category['parent_info']['id'];
}
//$rootElement = $category['id'];
// If the current category's ancestor was never seen
// before, then declare it and assign the current
// category to it.
if (!isset($newCategoryList[$rootElement])) {
$newCategoryList[$rootElement] = $category;
} else {
// If it was already seen, then merge the previous with
// the current category
$oldQuestionList = $newCategoryList[$rootElement]['question_list'];
$category['question_list'] = array_merge($oldQuestionList, $category['question_list']);
$newCategoryList[$rootElement] = $category;
}
}
// Now use the newly built categories list, with only parents
$categories = $newCategoryList;
}
foreach ($categories as $category) {
$questionList = $category['question_list'];
// Check if in this category there questions added in a media
$mediaQuestionId = $category['media_question'];
$isMedia = false;
$fixedValue = null;
// Media exists!
if ($mediaQuestionId != 999) {
$isMedia = true;
$fixedValue = $counterNoMedias;
}
//$categoryName = $category['path']; << show the path
$categoryName = $category['name'];
if ($useRootAsCategoryTitle) {
if (isset($category['parent_info'])) {
$categoryName = $category['parent_info']['title'];
}
}
$html .= '
';
$html .= '
'.$categoryName.'
';
$html .= '
';
if (!empty($nextValue)) {
if ($wasMedia) {
$nextValue = $nextValue - $before + 1;
}
}
$html .= Display::progressPaginationBar(
$nextValue,
$questionList,
$current,
$fixedValue,
$conditions,
$link,
$isMedia,
true
);
$html .= '
';
$html .= '
';
if ($mediaQuestionId == 999) {
$counterNoMedias += count($questionList);
} else {
$counterNoMedias++;
}
$nextValue += count($questionList);
$before = count($questionList);
if ($mediaQuestionId != 999) {
$wasMedia = true;
} else {
$wasMedia = false;
}
}
}
return $html;
}
/**
* Renders a question list.
*
* @param array $questionList (with media questions compressed)
* @param int $currentQuestion
* @param array $exerciseResult
* @param array $attemptList
* @param array $remindList
*/
public function renderQuestionList(
$questionList,
$currentQuestion,
$exerciseResult,
$attemptList,
$remindList
) {
$mediaQuestions = $this->getMediaList();
$i = 0;
// Normal question list render (medias compressed)
foreach ($questionList as $questionId) {
$i++;
// For sequential exercises
if ($this->type == ONE_PER_PAGE) {
// If it is not the right question, goes to the next loop iteration
if ($currentQuestion != $i) {
continue;
} else {
if (!in_array(
$this->getFeedbackType(),
[EXERCISE_FEEDBACK_TYPE_DIRECT, EXERCISE_FEEDBACK_TYPE_POPUP]
)) {
// if the user has already answered this question
if (isset($exerciseResult[$questionId])) {
echo Display::return_message(
get_lang('You already answered the question'),
'normal'
);
break;
}
}
}
}
// The $questionList contains the media id we check
// if this questionId is a media question type
if (isset($mediaQuestions[$questionId]) &&
$mediaQuestions[$questionId] != 999
) {
// The question belongs to a media
$mediaQuestionList = $mediaQuestions[$questionId];
$objQuestionTmp = Question::read($questionId);
$counter = 1;
if ($objQuestionTmp->type == MEDIA_QUESTION) {
echo $objQuestionTmp->show_media_content();
$countQuestionsInsideMedia = count($mediaQuestionList);
// Show questions that belongs to a media
if (!empty($mediaQuestionList)) {
// In order to parse media questions we use letters a, b, c, etc.
$letterCounter = 97;
foreach ($mediaQuestionList as $questionIdInsideMedia) {
$isLastQuestionInMedia = false;
if ($counter == $countQuestionsInsideMedia) {
$isLastQuestionInMedia = true;
}
$this->renderQuestion(
$questionIdInsideMedia,
$attemptList,
$remindList,
chr($letterCounter),
$currentQuestion,
$mediaQuestionList,
$isLastQuestionInMedia,
$questionList
);
$letterCounter++;
$counter++;
}
}
} else {
$this->renderQuestion(
$questionId,
$attemptList,
$remindList,
$i,
$currentQuestion,
null,
null,
$questionList
);
$i++;
}
} else {
// Normal question render.
$this->renderQuestion(
$questionId,
$attemptList,
$remindList,
$i,
$currentQuestion,
null,
null,
$questionList
);
}
// For sequential exercises.
if ($this->type == ONE_PER_PAGE) {
// quits the loop
break;
}
}
// end foreach()
if ($this->type == ALL_ON_ONE_PAGE) {
$exercise_actions = $this->show_button($questionId, $currentQuestion);
echo Display::div($exercise_actions, ['class' => 'exercise_actions']);
}
}
/**
* @param int $questionId
* @param array $attemptList
* @param array $remindList
* @param int $i
* @param int $current_question
* @param array $questions_in_media
* @param bool $last_question_in_media
* @param array $realQuestionList
* @param bool $generateJS
*/
public function renderQuestion(
$questionId,
$attemptList,
$remindList,
$i,
$current_question,
$questions_in_media = [],
$last_question_in_media = false,
$realQuestionList,
$generateJS = true
) {
// With this option on the question is loaded via AJAX
//$generateJS = true;
//$this->loadQuestionAJAX = true;
if ($generateJS && $this->loadQuestionAJAX) {
$url = api_get_path(WEB_AJAX_PATH).'exercise.ajax.php?a=get_question&id='.$questionId.'&'.api_get_cidreq();
$params = [
'questionId' => $questionId,
'attemptList' => $attemptList,
'remindList' => $remindList,
'i' => $i,
'current_question' => $current_question,
'questions_in_media' => $questions_in_media,
'last_question_in_media' => $last_question_in_media,
];
$params = json_encode($params);
$script = '
';
echo $script;
} else {
global $origin;
$question_obj = Question::read($questionId);
$user_choice = isset($attemptList[$questionId]) ? $attemptList[$questionId] : null;
$remind_highlight = null;
// Hides questions when reviewing a ALL_ON_ONE_PAGE exercise
// see #4542 no_remind_highlight class hide with jquery
if ($this->type == ALL_ON_ONE_PAGE && isset($_GET['reminder']) && $_GET['reminder'] == 2) {
$remind_highlight = 'no_remind_highlight';
if (in_array($question_obj->type, Question::question_type_no_review())) {
return null;
}
}
$attributes = ['id' => 'remind_list['.$questionId.']'];
// Showing the question
$exercise_actions = null;
echo '
';
echo '
';
// Shows the question + possible answers
$showTitle = $this->getHideQuestionTitle() == 1 ? false : true;
echo $this->showQuestion(
$question_obj,
false,
$origin,
$i,
$showTitle,
false,
$user_choice,
false,
null,
false,
$this->getModelType(),
$this->categoryMinusOne
);
// Button save and continue
switch ($this->type) {
case ONE_PER_PAGE:
$exercise_actions .= $this->show_button(
$questionId,
$current_question,
null,
$remindList
);
break;
case ALL_ON_ONE_PAGE:
if (api_is_allowed_to_session_edit()) {
$button = [
Display::button(
'save_now',
get_lang('Save and continue'),
['type' => 'button', 'class' => 'btn btn-primary', 'data-question' => $questionId]
),
'
',
];
$exercise_actions .= Display::div(
implode(PHP_EOL, $button),
['class' => 'exercise_save_now_button']
);
}
break;
}
if (!empty($questions_in_media)) {
$count_of_questions_inside_media = count($questions_in_media);
if ($count_of_questions_inside_media > 1 && api_is_allowed_to_session_edit()) {
$button = [
Display::button(
'save_now',
get_lang('Save and continue'),
['type' => 'button', 'class' => 'btn btn-primary', 'data-question' => $questionId]
),
'
',
];
$exercise_actions = Display::div(
implode(PHP_EOL, $button),
['class' => 'exercise_save_now_button']
);
}
if ($last_question_in_media && $this->type == ONE_PER_PAGE) {
$exercise_actions = $this->show_button($questionId, $current_question, $questions_in_media);
}
}
// Checkbox review answers
if ($this->review_answers &&
!in_array($question_obj->type, Question::question_type_no_review())
) {
$remind_question_div = Display::tag(
'label',
Display::input(
'checkbox',
'remind_list['.$questionId.']',
'',
$attributes
).get_lang('Revise question later'),
[
'class' => 'checkbox',
'for' => 'remind_list['.$questionId.']',
]
);
$exercise_actions .= Display::div(
$remind_question_div,
['class' => 'exercise_save_now_button']
);
}
echo Display::div(' ', ['class' => 'clear']);
$paginationCounter = null;
if ($this->type == ONE_PER_PAGE) {
if (empty($questions_in_media)) {
$paginationCounter = Display::paginationIndicator(
$current_question,
count($realQuestionList)
);
} else {
if ($last_question_in_media) {
$paginationCounter = Display::paginationIndicator(
$current_question,
count($realQuestionList)
);
}
}
}
echo '
';
echo Display::div($exercise_actions, ['class' => 'form-actions']);
echo '
';
}
}
/**
* Returns an array of categories details for the questions of the current
* exercise.
*
* @return array
*/
public function getQuestionWithCategories()
{
$categoryTable = Database::get_course_table(TABLE_QUIZ_QUESTION_CATEGORY);
$categoryRelTable = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY);
$TBL_EXERCICE_QUESTION = Database::get_course_table(TABLE_QUIZ_TEST_QUESTION);
$TBL_QUESTIONS = Database::get_course_table(TABLE_QUIZ_QUESTION);
$sql = "SELECT DISTINCT cat.*
FROM $TBL_EXERCICE_QUESTION e
INNER JOIN $TBL_QUESTIONS q
ON (e.question_id = q.id AND e.c_id = q.c_id)
INNER JOIN $categoryRelTable catRel
ON (catRel.question_id = e.question_id AND catRel.c_id = e.c_id)
INNER JOIN $categoryTable cat
ON (cat.id = catRel.category_id AND cat.c_id = e.c_id)
WHERE
e.c_id = {$this->course_id} AND
e.exercice_id = ".intval($this->id);
$result = Database::query($sql);
$categoriesInExercise = [];
if (Database::num_rows($result)) {
$categoriesInExercise = Database::store_result($result, 'ASSOC');
}
return $categoriesInExercise;
}
/**
* Calculate the max_score of the quiz, depending of question inside, and quiz advanced option.
*/
public function get_max_score()
{
$out_max_score = 0;
// list of question's id !!! the array key start at 1 !!!
$questionList = $this->selectQuestionList(true);
// test is randomQuestions - see field random of test
if ($this->random > 0 && $this->randomByCat == 0) {
$numberRandomQuestions = $this->random;
$questionScoreList = [];
foreach ($questionList as $questionId) {
$tmpobj_question = Question::read($questionId);
if (is_object($tmpobj_question)) {
$questionScoreList[] = $tmpobj_question->weighting;
}
}
rsort($questionScoreList);
// add the first $numberRandomQuestions value of score array to get max_score
for ($i = 0; $i < min($numberRandomQuestions, count($questionScoreList)); $i++) {
$out_max_score += $questionScoreList[$i];
}
} elseif ($this->random > 0 && $this->randomByCat > 0) {
// test is random by category
// get the $numberRandomQuestions best score question of each category
$numberRandomQuestions = $this->random;
$tab_categories_scores = [];
foreach ($questionList as $questionId) {
$question_category_id = TestCategory::getCategoryForQuestion($questionId);
if (!is_array($tab_categories_scores[$question_category_id])) {
$tab_categories_scores[$question_category_id] = [];
}
$tmpobj_question = Question::read($questionId);
if (is_object($tmpobj_question)) {
$tab_categories_scores[$question_category_id][] = $tmpobj_question->weighting;
}
}
// here we've got an array with first key, the category_id, second key, score of question for this cat
foreach ($tab_categories_scores as $tab_scores) {
rsort($tab_scores);
for ($i = 0; $i < min($numberRandomQuestions, count($tab_scores)); $i++) {
$out_max_score += $tab_scores[$i];
}
}
} else {
// standard test, just add each question score
foreach ($questionList as $questionId) {
$question = Question::read($questionId, $this->course);
$out_max_score += $question->weighting;
}
}
return $out_max_score;
}
/**
* @return string
*/
public function get_formated_title()
{
if (api_get_configuration_value('save_titles_as_html')) {
}
return api_html_entity_decode($this->selectTitle());
}
/**
* @param string $title
*
* @return string
*/
public static function get_formated_title_variable($title)
{
return api_html_entity_decode($title);
}
/**
* @return string
*/
public function format_title()
{
return api_htmlentities($this->title);
}
/**
* @param string $title
*
* @return string
*/
public static function format_title_variable($title)
{
return api_htmlentities($title);
}
/**
* @param int $courseId
* @param int $sessionId
*
* @return array exercises
*/
public function getExercisesByCourseSession($courseId, $sessionId)
{
$courseId = (int) $courseId;
$sessionId = (int) $sessionId;
$tbl_quiz = Database::get_course_table(TABLE_QUIZ_TEST);
$sql = "SELECT * FROM $tbl_quiz cq
WHERE
cq.c_id = %s AND
(cq.session_id = %s OR cq.session_id = 0) AND
cq.active = 0
ORDER BY cq.id";
$sql = sprintf($sql, $courseId, $sessionId);
$result = Database::query($sql);
$rows = [];
while ($row = Database::fetch_array($result, 'ASSOC')) {
$rows[] = $row;
}
return $rows;
}
/**
* @param int $courseId
* @param int $sessionId
* @param array $quizId
*
* @return array exercises
*/
public function getExerciseAndResult($courseId, $sessionId, $quizId = [])
{
if (empty($quizId)) {
return [];
}
$sessionId = (int) $sessionId;
$courseId = (int) $courseId;
$ids = is_array($quizId) ? $quizId : [$quizId];
$ids = array_map('intval', $ids);
$ids = implode(',', $ids);
$track_exercises = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
if ($sessionId != 0) {
$sql = "SELECT * FROM $track_exercises te
INNER JOIN c_quiz cq ON cq.id = te.exe_exo_id AND te.c_id = cq.c_id
WHERE
te.id = %s AND
te.session_id = %s AND
cq.id IN (%s)
ORDER BY cq.id";
$sql = sprintf($sql, $courseId, $sessionId, $ids);
} else {
$sql = "SELECT * FROM $track_exercises te
INNER JOIN c_quiz cq ON cq.id = te.exe_exo_id AND te.c_id = cq.c_id
WHERE
te.id = %s AND
cq.id IN (%s)
ORDER BY cq.id";
$sql = sprintf($sql, $courseId, $ids);
}
$result = Database::query($sql);
$rows = [];
while ($row = Database::fetch_array($result, 'ASSOC')) {
$rows[] = $row;
}
return $rows;
}
/**
* @param $exeId
* @param $exercise_stat_info
* @param $remindList
* @param $currentQuestion
*
* @return int|null
*/
public static function getNextQuestionId(
$exeId,
$exercise_stat_info,
$remindList,
$currentQuestion
) {
$result = Event::get_exercise_results_by_attempt($exeId, 'incomplete');
if (isset($result[$exeId])) {
$result = $result[$exeId];
} else {
return null;
}
$data_tracking = $exercise_stat_info['data_tracking'];
$data_tracking = explode(',', $data_tracking);
// if this is the final question do nothing.
if ($currentQuestion == count($data_tracking)) {
return null;
}
$currentQuestion = $currentQuestion - 1;
if (!empty($result['question_list'])) {
$answeredQuestions = [];
foreach ($result['question_list'] as $question) {
if (!empty($question['answer'])) {
$answeredQuestions[] = $question['question_id'];
}
}
// Checking answered questions
$counterAnsweredQuestions = 0;
foreach ($data_tracking as $questionId) {
if (!in_array($questionId, $answeredQuestions)) {
if ($currentQuestion != $counterAnsweredQuestions) {
break;
}
}
$counterAnsweredQuestions++;
}
$counterRemindListQuestions = 0;
// Checking questions saved in the reminder list
if (!empty($remindList)) {
foreach ($data_tracking as $questionId) {
if (in_array($questionId, $remindList)) {
// Skip the current question
if ($currentQuestion != $counterRemindListQuestions) {
break;
}
}
$counterRemindListQuestions++;
}
if ($counterRemindListQuestions < $currentQuestion) {
return null;
}
if (!empty($counterRemindListQuestions)) {
if ($counterRemindListQuestions > $counterAnsweredQuestions) {
return $counterAnsweredQuestions;
} else {
return $counterRemindListQuestions;
}
}
}
return $counterAnsweredQuestions;
}
}
/**
* Gets the position of a questionId in the question list.
*
* @param $questionId
*
* @return int
*/
public function getPositionInCompressedQuestionList($questionId)
{
$questionList = $this->getQuestionListWithMediasCompressed();
$mediaQuestions = $this->getMediaList();
$position = 1;
foreach ($questionList as $id) {
if (isset($mediaQuestions[$id]) && in_array($questionId, $mediaQuestions[$id])) {
$mediaQuestionList = $mediaQuestions[$id];
if (in_array($questionId, $mediaQuestionList)) {
return $position;
} else {
$position++;
}
} else {
if ($id == $questionId) {
return $position;
} else {
$position++;
}
}
}
return 1;
}
/**
* Get the correct answers in all attempts.
*
* @param int $learnPathId
* @param int $learnPathItemId
* @param bool $onlyCorrect
*
* @return array
*/
public function getAnswersInAllAttempts($learnPathId = 0, $learnPathItemId = 0, $onlyCorrect = true)
{
$attempts = Event::getExerciseResultsByUser(
api_get_user_id(),
$this->id,
api_get_course_int_id(),
api_get_session_id(),
$learnPathId,
$learnPathItemId,
'DESC'
);
$list = [];
foreach ($attempts as $attempt) {
foreach ($attempt['question_list'] as $answers) {
foreach ($answers as $answer) {
$objAnswer = new Answer($answer['question_id']);
if ($onlyCorrect) {
switch ($objAnswer->getQuestionType()) {
case FILL_IN_BLANKS:
$isCorrect = FillBlanks::isCorrect($answer['answer']);
break;
case MATCHING:
case DRAGGABLE:
case MATCHING_DRAGGABLE:
$isCorrect = Matching::isCorrect(
$answer['position'],
$answer['answer'],
$answer['question_id']
);
break;
case ORAL_EXPRESSION:
$isCorrect = false;
break;
default:
$isCorrect = $objAnswer->isCorrectByAutoId($answer['answer']);
}
if ($isCorrect) {
$list[$answer['question_id']][] = $answer;
}
} else {
$list[$answer['question_id']][] = $answer;
}
}
}
if ($onlyCorrect === false) {
// Only take latest attempt
break;
}
}
return $list;
}
/**
* Get the correct answers in all attempts.
*
* @param int $learnPathId
* @param int $learnPathItemId
*
* @return array
*/
public function getCorrectAnswersInAllAttempts($learnPathId = 0, $learnPathItemId = 0)
{
return $this->getAnswersInAllAttempts($learnPathId, $learnPathItemId);
}
/**
* @return bool
*/
public function showPreviousButton()
{
$allow = api_get_configuration_value('allow_quiz_show_previous_button_setting');
if ($allow === false) {
return true;
}
return $this->showPreviousButton;
}
/**
* @return int
*/
public function getExerciseCategoryId()
{
if (empty($this->exerciseCategoryId)) {
return null;
}
return (int) $this->exerciseCategoryId;
}
/**
* @param int $value
*/
public function setExerciseCategoryId($value)
{
if (!empty($value)) {
$this->exerciseCategoryId = (int) $value;
}
}
/**
* @param array $values
*
* @throws \Doctrine\DBAL\DBALException
*/
public function setPageResultConfiguration($values)
{
$pageConfig = api_get_configuration_value('allow_quiz_results_page_config');
if ($pageConfig) {
$params = [
'hide_expected_answer' => isset($values['hide_expected_answer']) ? $values['hide_expected_answer'] : '',
'hide_question_score' => isset($values['hide_question_score']) ? $values['hide_question_score'] : '',
'hide_total_score' => isset($values['hide_total_score']) ? $values['hide_total_score'] : '',
];
$type = Type::getType('array');
$platform = Database::getManager()->getConnection()->getDatabasePlatform();
$this->pageResultConfiguration = $type->convertToDatabaseValue($params, $platform);
}
}
/**
* @param array $defaults
*/
public function setPageResultConfigurationDefaults(&$defaults)
{
$configuration = $this->getPageResultConfiguration();
if (!empty($configuration) && !empty($defaults)) {
$defaults = array_merge($defaults, $configuration);
}
}
/**
* @return array
*/
public function getPageResultConfiguration()
{
$pageConfig = api_get_configuration_value('allow_quiz_results_page_config');
if ($pageConfig) {
/*$params = [
'hide_expected_answer' => isset($values['hide_expected_answer']) ? $values['hide_expected_answer'] : '',
'hide_question_score' => isset($values['hide_question_score']) ? $values['hide_question_score'] : '',
'hide_total_score' => isset($values['hide_total_score']) ? $values['hide_total_score'] : ''
];*/
$type = Type::getType('array');
$platform = Database::getManager()->getConnection()->getDatabasePlatform();
$result = $type->convertToPHPValue($this->pageResultConfiguration, $platform);
return $result;
}
return [];
}
/**
* @param string $attribute
*
* @return mixed|null
*/
public function getPageConfigurationAttribute($attribute)
{
$result = $this->getPageResultConfiguration();
if (!empty($result)) {
$value = isset($result[$attribute]) ? $result[$attribute] : null;
return $value;
}
return null;
}
/**
* @param bool $showPreviousButton
*
* @return Exercise
*/
public function setShowPreviousButton($showPreviousButton)
{
$this->showPreviousButton = $showPreviousButton;
return $this;
}
/**
* @param array $notifications
*/
public function setNotifications($notifications)
{
$this->notifications = $notifications;
}
/**
* @return array
*/
public function getNotifications()
{
return $this->notifications;
}
/**
* @return bool
*/
public function showExpectedChoice()
{
return api_get_configuration_value('show_exercise_expected_choice');
}
/**
* @return bool
*/
public function showExpectedChoiceColumn()
{
if (!in_array($this->results_disabled, [
RESULT_DISABLE_SHOW_ONLY_IN_CORRECT_ANSWER,
])
) {
$hide = (int) $this->getPageConfigurationAttribute('hide_expected_answer');
if ($hide === 1) {
return false;
}
return true;
}
return false;
}
/**
* @param string $class
* @param string $scoreLabel
* @param string $result
* @param array
*
* @return string
*/
public function getQuestionRibbon($class, $scoreLabel, $result, $array)
{
$hide = (int) $this->getPageConfigurationAttribute('hide_question_score');
if ($hide === 1) {
return '';
}
if ($this->showExpectedChoice()) {
$html = null;
$hideLabel = api_get_configuration_value('exercise_hide_label');
$label = '
'.$scoreLabel.'
';
if (!empty($result)) {
$label .= '
'.get_lang('Score').': '.$result.'
';
}
if ($hideLabel === true) {
$answerUsed = (int) $array['used'];
$answerMissing = (int) $array['missing'] - $answerUsed;
for ($i = 1; $i <= $answerUsed; $i++) {
$html .= '
'.
Display::return_icon('attempt-check.png', null, null, ICON_SIZE_SMALL).
'';
}
for ($i = 1; $i <= $answerMissing; $i++) {
$html .= '
'.
Display::return_icon('attempt-nocheck.png', null, null, ICON_SIZE_SMALL).
'';
}
$label = '
'.get_lang('Correct answers').': '.$result.'
';
$label .= '
';
$label .= $html;
$label .= '
';
}
return '
'.$label.'
'
;
} else {
$html = '
'.$scoreLabel.'
';
if (!empty($result)) {
$html .= '
'.get_lang('Score').': '.$result.'
';
}
$html .= '
';
return $html;
}
}
/**
* @return int
*/
public function getAutoLaunch()
{
return $this->autolaunch;
}
/**
* Clean auto launch settings for all exercise in course/course-session.
*/
public function enableAutoLaunch()
{
$table = Database::get_course_table(TABLE_QUIZ_TEST);
$sql = "UPDATE $table SET autolaunch = 1
WHERE iid = ".$this->iId;
Database::query($sql);
}
/**
* Clean auto launch settings for all exercise in course/course-session.
*/
public function cleanCourseLaunchSettings()
{
$table = Database::get_course_table(TABLE_QUIZ_TEST);
$sql = "UPDATE $table SET autolaunch = 0
WHERE c_id = ".$this->course_id." AND session_id = ".$this->sessionId;
Database::query($sql);
}
/**
* Get the title without HTML tags.
*
* @return string
*/
public function getUnformattedTitle()
{
return strip_tags(api_html_entity_decode($this->title));
}
/**
* @param int $start
* @param int $length
*
* @return array
*/
public function getQuestionForTeacher($start = 0, $length = 10)
{
$start = (int) $start;
if ($start < 0) {
$start = 0;
}
$length = (int) $length;
$quizRelQuestion = Database::get_course_table(TABLE_QUIZ_TEST_QUESTION);
$question = Database::get_course_table(TABLE_QUIZ_QUESTION);
$sql = "SELECT DISTINCT e.question_id
FROM $quizRelQuestion e
INNER JOIN $question q
ON (e.question_id = q.iid AND e.c_id = q.c_id)
WHERE
e.c_id = {$this->course_id} AND
e.exercice_id = '".$this->id."'
ORDER BY question_order
LIMIT $start, $length
";
$result = Database::query($sql);
$questionList = [];
while ($object = Database::fetch_object($result)) {
$questionList[] = $object->question_id;
}
return $questionList;
}
/**
* @param int $exerciseId
* @param array $courseInfo
* @param int $sessionId
*
* @throws \Doctrine\ORM\OptimisticLockException
*
* @return bool
*/
public function generateStats($exerciseId, $courseInfo, $sessionId)
{
$allowStats = api_get_configuration_value('allow_gradebook_stats');
if (!$allowStats) {
return false;
}
if (empty($courseInfo)) {
return false;
}
$courseId = $courseInfo['real_id'];
$sessionId = (int) $sessionId;
$exerciseId = (int) $exerciseId;
$result = $this->read($exerciseId);
if (empty($result)) {
api_not_allowed(true);
}
$statusToFilter = empty($sessionId) ? STUDENT : 0;
$studentList = CourseManager::get_user_list_from_course_code(
$courseInfo['code'],
$sessionId,
null,
null,
$statusToFilter
);
if (empty($studentList)) {
Display::addFlash(Display::return_message(get_lang('No users in course')));
header('Location: '.api_get_path(WEB_CODE_PATH).'exercise/exercise.php?'.api_get_cidreq());
exit;
}
$tblStats = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$studentIdList = [];
if (!empty($studentList)) {
$studentIdList = array_column($studentList, 'user_id');
}
if ($this->exercise_was_added_in_lp == false) {
$sql = "SELECT * FROM $tblStats
WHERE
exe_exo_id = $exerciseId AND
orig_lp_id = 0 AND
orig_lp_item_id = 0 AND
status <> 'incomplete' AND
session_id = $sessionId AND
c_id = $courseId
";
} else {
$lpId = null;
if (!empty($this->lpList)) {
// Taking only the first LP
$lpId = current($this->lpList);
$lpId = $lpId['lp_id'];
}
$sql = "SELECT *
FROM $tblStats
WHERE
exe_exo_id = $exerciseId AND
orig_lp_id = $lpId AND
status <> 'incomplete' AND
session_id = $sessionId AND
c_id = $courseId ";
}
$sql .= ' ORDER BY exe_id DESC';
$studentCount = 0;
$sum = 0;
$bestResult = 0;
$sumResult = 0;
$result = Database::query($sql);
while ($data = Database::fetch_array($result, 'ASSOC')) {
// Only take into account users in the current student list.
if (!empty($studentIdList)) {
if (!in_array($data['exe_user_id'], $studentIdList)) {
continue;
}
}
if (!isset($students[$data['exe_user_id']])) {
if ($data['exe_weighting'] != 0) {
$students[$data['exe_user_id']] = $data['exe_result'];
if ($data['exe_result'] > $bestResult) {
$bestResult = $data['exe_result'];
}
$sumResult += $data['exe_result'];
}
}
}
$count = count($studentList);
$average = $sumResult / $count;
$em = Database::getManager();
$links = AbstractLink::getGradebookLinksFromItem(
$this->id,
LINK_EXERCISE,
$courseInfo['code'],
$sessionId
);
if (empty($links)) {
$links = AbstractLink::getGradebookLinksFromItem(
$this->iId,
LINK_EXERCISE,
$courseInfo['code'],
$sessionId
);
}
if (!empty($links)) {
$repo = $em->getRepository('ChamiloCoreBundle:GradebookLink');
foreach ($links as $link) {
$linkId = $link['id'];
/** @var GradebookLink $exerciseLink */
$exerciseLink = $repo->find($linkId);
if ($exerciseLink) {
$exerciseLink
->setUserScoreList($students)
->setBestScore($bestResult)
->setAverageScore($average)
->setScoreWeight($this->get_max_score());
$em->persist($exerciseLink);
$em->flush();
}
}
}
}
/**
* Return an HTML table of exercises for on-screen printing, including
* action icons. If no exercise is present and the user can edit the
* course, show a "create test" button.
*
* @param int $categoryId
* @param string $keyword
*
* @return string
*/
public static function exerciseGrid($categoryId, $keyword = '')
{
$TBL_DOCUMENT = Database::get_course_table(TABLE_DOCUMENT);
$TBL_ITEM_PROPERTY = Database::get_course_table(TABLE_ITEM_PROPERTY);
$TBL_EXERCISE_QUESTION = Database::get_course_table(TABLE_QUIZ_TEST_QUESTION);
$TBL_EXERCISES = Database::get_course_table(TABLE_QUIZ_TEST);
$TBL_TRACK_EXERCISES = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);
$categoryId = (int) $categoryId;
$keyword = Database::escape_string($keyword);
$learnpath_id = isset($_REQUEST['learnpath_id']) ? (int) $_REQUEST['learnpath_id'] : null;
$learnpath_item_id = isset($_REQUEST['learnpath_item_id']) ? (int) $_REQUEST['learnpath_item_id'] : null;
$autoLaunchAvailable = false;
if (api_get_course_setting('enable_exercise_auto_launch') == 1 &&
api_get_configuration_value('allow_exercise_auto_launch')
) {
$autoLaunchAvailable = true;
}
$is_allowedToEdit = api_is_allowed_to_edit(null, true);
$courseInfo = api_get_course_info();
$sessionId = api_get_session_id();
$courseId = $courseInfo['real_id'];
$tableRows = [];
$uploadPath = DIR_HOTPOTATOES; //defined in main_api
$exercisePath = api_get_self();
$origin = api_get_origin();
$userInfo = api_get_user_info();
$charset = 'utf-8';
$token = Security::get_token();
$userId = api_get_user_id();
$isDrhOfCourse = CourseManager::isUserSubscribedInCourseAsDrh($userId, $courseInfo);
$documentPath = api_get_path(SYS_COURSE_PATH).$courseInfo['path'].'/document';
$limitTeacherAccess = api_get_configuration_value('limit_exercise_teacher_access');
// Condition for the session
$condition_session = api_get_session_condition($sessionId, true, true);
$content = '';
$column = 0;
if ($is_allowedToEdit) {
$column = 1;
}
$table = new SortableTableFromArrayConfig(
[],
$column,
self::PAGINATION_ITEMS_PER_PAGE,
'exercises_cat_'.$categoryId
);
$limit = $table->per_page;
$page = $table->page_nr;
$from = $limit * ($page - 1);
$categoryCondition = '';
if (api_get_configuration_value('allow_exercise_categories')) {
if (!empty($categoryId)) {
$categoryCondition = " AND exercise_category_id = $categoryId ";
} else {
$categoryCondition = ' AND exercise_category_id IS NULL ';
}
}
$keywordCondition = '';
if (!empty($keyword)) {
$keywordCondition = " AND title LIKE '%$keyword%' ";
}
// Only for administrators
if ($is_allowedToEdit) {
$total_sql = "SELECT count(iid) as count
FROM $TBL_EXERCISES
WHERE
c_id = $courseId AND
active <> -1
$condition_session
$categoryCondition
$keywordCondition
";
$sql = "SELECT * FROM $TBL_EXERCISES
WHERE
c_id = $courseId AND
active <> -1
$condition_session
$categoryCondition
$keywordCondition
ORDER BY title
LIMIT $from , $limit";
} else {
// Only for students
$total_sql = "SELECT count(iid) as count
FROM $TBL_EXERCISES
WHERE
c_id = $courseId AND
active = 1
$condition_session
$categoryCondition
$keywordCondition
";
$sql = "SELECT * FROM $TBL_EXERCISES
WHERE c_id = $courseId AND
active = 1
$condition_session
$categoryCondition
$keywordCondition
ORDER BY title
LIMIT $from , $limit";
}
$result = Database::query($sql);
$result_total = Database::query($total_sql);
$total_exercises = 0;
if (Database :: num_rows($result_total)) {
$result_total = Database::fetch_array($result_total);
$total_exercises = $result_total['count'];
}
//get HotPotatoes files (active and inactive)
if ($is_allowedToEdit) {
$sql = "SELECT * FROM $TBL_DOCUMENT
WHERE
c_id = $courseId AND
path LIKE '".Database::escape_string($uploadPath.'/%/%')."'";
$res = Database::query($sql);
$hp_count = Database :: num_rows($res);
} else {
$sql = "SELECT * FROM $TBL_DOCUMENT d
INNER JOIN $TBL_ITEM_PROPERTY ip
ON (d.id = ip.ref AND d.c_id = ip.c_id)
WHERE
ip.tool = '".TOOL_DOCUMENT."' AND
d.path LIKE '".Database::escape_string($uploadPath.'/%/%')."' AND
ip.visibility = 1 AND
d.c_id = $courseId AND
ip.c_id = $courseId";
$res = Database::query($sql);
$hp_count = Database::num_rows($res);
}
$total = $total_exercises + $hp_count;
$exerciseList = [];
while ($row = Database::fetch_array($result, 'ASSOC')) {
$exerciseList[] = $row;
}
if (!empty($exerciseList) &&
api_get_setting('exercise_invisible_in_session') === 'true'
) {
if (!empty($sessionId)) {
$changeDefaultVisibility = true;
if (api_get_setting('configure_exercise_visibility_in_course') === 'true') {
$changeDefaultVisibility = false;
if (api_get_course_setting('exercise_invisible_in_session') == 1) {
$changeDefaultVisibility = true;
}
}
if ($changeDefaultVisibility) {
// Check exercise
foreach ($exerciseList as $exercise) {
if ($exercise['session_id'] == 0) {
$visibilityInfo = api_get_item_property_info(
$courseId,
TOOL_QUIZ,
$exercise['iid'],
$sessionId
);
if (empty($visibilityInfo)) {
// Create a record for this
api_item_property_update(
$courseInfo,
TOOL_QUIZ,
$exercise['iid'],
'invisible',
api_get_user_id(),
0,
null,
'',
'',
$sessionId
);
}
}
}
}
}
}
if (!empty($exerciseList)) {
if ($origin !== 'learnpath') {
$visibilitySetting = api_get_configuration_value('show_hidden_exercise_added_to_lp');
//avoid sending empty parameters
$mylpid = empty($learnpath_id) ? '' : '&learnpath_id='.$learnpath_id;
$mylpitemid = empty($learnpath_item_id) ? '' : '&learnpath_item_id='.$learnpath_item_id;
foreach ($exerciseList as $row) {
$currentRow = [];
$my_exercise_id = $row['id'];
$attempt_text = '';
$actions = '';
$exercise = new Exercise();
$exercise->read($my_exercise_id, false);
if (empty($exercise->id)) {
continue;
}
$locked = $exercise->is_gradebook_locked;
// Validation when belongs to a session
$session_img = api_get_session_image($row['session_id'], $userInfo['status']);
$time_limits = false;
if (!empty($row['start_time']) || !empty($row['end_time'])) {
$time_limits = true;
}
$is_actived_time = false;
if ($time_limits) {
// check if start time
$start_time = false;
if (!empty($row['start_time'])) {
$start_time = api_strtotime($row['start_time'], 'UTC');
}
$end_time = false;
if (!empty($row['end_time'])) {
$end_time = api_strtotime($row['end_time'], 'UTC');
}
$now = time();
//If both "clocks" are enable
if ($start_time && $end_time) {
if ($now > $start_time && $end_time > $now) {
$is_actived_time = true;
}
} else {
//we check the start and end
if ($start_time) {
if ($now > $start_time) {
$is_actived_time = true;
}
}
if ($end_time) {
if ($end_time > $now) {
$is_actived_time = true;
}
}
}
}
// 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($row['start_time'])) {
$time_limits = true;
$is_actived_time = false;
}
}
$cut_title = $exercise->getCutTitle();
$alt_title = '';
if ($cut_title != $row['title']) {
$alt_title = ' title = "'.$exercise->getUnformattedTitle().'" ';
}
// Teacher only
if ($is_allowedToEdit) {
$lp_blocked = null;
if ($exercise->exercise_was_added_in_lp == true) {
$lp_blocked = Display::div(
get_lang('This exercise has been included in a learning path, so it cannot be accessed by students directly from here. If you want to put the same exercise available through the exercises tool, please make a copy of the current exercise using the copy icon.'),
['class' => 'lp_content_type_label']
);
}
// Get visibility in base course
$visibility = api_get_item_visibility(
$courseInfo,
TOOL_QUIZ,
$my_exercise_id,
0
);
if (!empty($sessionId)) {
// If we are in a session, the test is invisible
// in the base course, it is included in a LP
// *and* the setting to show it is *not*
// specifically set to true, then hide it.
if ($visibility == 0) {
if (!$visibilitySetting) {
if ($exercise->exercise_was_added_in_lp == true) {
continue;
}
}
}
$visibility = api_get_item_visibility(
$courseInfo,
TOOL_QUIZ,
$my_exercise_id,
$sessionId
);
}
if ($row['active'] == 0 || $visibility == 0) {
$title = Display::tag('font', $cut_title, ['style' => 'color:grey']);
} else {
$title = $cut_title;
}
$count_exercise_not_validated = (int) Event::count_exercise_result_not_validated(
$my_exercise_id,
$courseId,
$sessionId
);
/*$move = Display::return_icon(
'all_directions.png',
get_lang('Move'),
['class' => 'moved', 'style' => 'margin-bottom:-0.5em;']
);*/
$move = null;
$class_tip = '';
if (!empty($count_exercise_not_validated)) {
$results_text = $count_exercise_not_validated == 1 ? get_lang('Result not reviewed') : get_lang('Results and feedback and feedback and feedback and feedback and feedback and feedback not reviewed');
$title .= '
'.$count_exercise_not_validated.' '.$results_text.' ';
$class_tip = 'link_tooltip';
}
$url = $move.'
'.Display::return_icon('quiz.png', $row['title']).'
'.$title.' '.PHP_EOL;
if (ExerciseLib::isQuizEmbeddable($row)) {
$embeddableIcon = Display::return_icon('om_integration.png', get_lang('ThisQuizCanBeEmbeddable'));
$url .= Display::div($embeddableIcon, ['class' => 'pull-right']);
}
$currentRow['title'] = $url.' '.$session_img.$lp_blocked;
// Count number exercise - teacher
$sql = "SELECT count(*) count FROM $TBL_EXERCISE_QUESTION
WHERE c_id = $courseId AND exercice_id = $my_exercise_id";
$sqlresult = Database::query($sql);
$rowi = (int) Database::result($sqlresult, 0, 0);
if ($sessionId == $row['session_id']) {
// Questions list
$actions = Display::url(
Display::return_icon('edit.png', get_lang('Edit'), '', ICON_SIZE_SMALL),
'admin.php?'.api_get_cidreq().'&exerciseId='.$row['id']
);
// Test settings
$settings = Display::url(
Display::return_icon('settings.png', get_lang('Configure'), '', ICON_SIZE_SMALL),
'exercise_admin.php?'.api_get_cidreq().'&exerciseId='.$row['id']
);
if ($limitTeacherAccess && !api_is_platform_admin()) {
$settings = '';
}
$actions .= $settings;
// Exercise results
$resultsLink = '
'.
Display::return_icon('test_results.png', get_lang('Results and feedback and feedback and feedback and feedback and feedback and feedback'), '', ICON_SIZE_SMALL).'';
if ($limitTeacherAccess) {
if (api_is_platform_admin()) {
$actions .= $resultsLink;
}
} else {
// Exercise results
$actions .= $resultsLink;
}
// Auto launch
if ($autoLaunchAvailable) {
$autoLaunch = $exercise->getAutoLaunch();
if (empty($autoLaunch)) {
$actions .= Display::url(
Display::return_icon(
'launch_na.png',
get_lang('Enable'),
'',
ICON_SIZE_SMALL
),
'exercise.php?'.api_get_cidreq().'&choice=enable_launch&sec_token='.$token.'&exerciseId='.$row['id']
);
} else {
$actions .= Display::url(
Display::return_icon(
'launch.png',
get_lang('Disable'),
'',
ICON_SIZE_SMALL
),
'exercise.php?'.api_get_cidreq().'&choice=disable_launch&sec_token='.$token.'&exerciseId='.$row['id']
);
}
}
// Export
$actions .= Display::url(
Display::return_icon('cd.png', get_lang('CopyTest')),
'',
[
'onclick' => "javascript:if(!confirm('".addslashes(api_htmlentities(get_lang('Are you sure to copy'), ENT_QUOTES, $charset))." ".addslashes($row['title'])."?"."')) return false;",
'href' => 'exercise.php?'.api_get_cidreq().'&choice=copy_exercise&sec_token='.$token.'&exerciseId='.$row['id'],
]
);
// Clean exercise
if ($locked == false) {
$clean = Display::url(
Display::return_icon(
'clean.png',
get_lang('Clear all learners results for this exercise and feedback'),
'',
ICON_SIZE_SMALL
),
'',
[
'onclick' => "javascript:if(!confirm('".addslashes(api_htmlentities(get_lang('Are you sure to delete results and feedback'), ENT_QUOTES, $charset))." ".addslashes($row['title'])."?"."')) return false;",
'href' => 'exercise.php?'.api_get_cidreq().'&choice=clean_results&sec_token='.$token.'&exerciseId='.$row['id'],
]
);
} else {
$clean = Display::return_icon(
'clean_na.png',
get_lang('This option is not available because this activity is contained by an assessment, which is currently locked. To unlock the assessment, ask your platform administrator.'),
'',
ICON_SIZE_SMALL
);
}
if ($limitTeacherAccess && !api_is_platform_admin()) {
$clean = '';
}
$actions .= $clean;
// Visible / invisible
// Check if this exercise was added in a LP
if ($exercise->exercise_was_added_in_lp == true) {
$visibility = Display::return_icon(
'invisible.png',
get_lang('This exercise has been included in a learning path, so it cannot be accessed by students directly from here. If you want to put the same exercise available through the exercises tool, please make a copy of the current exercise using the copy icon.'),
'',
ICON_SIZE_SMALL
);
} else {
if ($row['active'] == 0 || $visibility == 0) {
$visibility = Display::url(
Display::return_icon(
'invisible.png',
get_lang('Activate'),
'',
ICON_SIZE_SMALL
),
'exercise.php?'.api_get_cidreq().'&choice=enable&sec_token='.$token.'&exerciseId='.$row['id']
);
} else {
// else if not active
$visibility = Display::url(
Display::return_icon(
'visible.png',
get_lang('Deactivate'),
'',
ICON_SIZE_SMALL
),
'exercise.php?'.api_get_cidreq().'&choice=disable&sec_token='.$token.'&exerciseId='.$row['id']
);
}
}
if ($limitTeacherAccess && !api_is_platform_admin()) {
$visibility = '';
}
$actions .= $visibility;
// Export qti ...
$export = Display::url(
Display::return_icon(
'export_qti2.png',
'IMS/QTI',
'',
ICON_SIZE_SMALL
),
'exercise.php?action=exportqti2&exerciseId='.$row['id'].'&'.api_get_cidreq()
);
if ($limitTeacherAccess && !api_is_platform_admin()) {
$export = '';
}
$actions .= $export;
} else {
// not session
$actions = Display::return_icon(
'edit_na.png',
get_lang('TestEditionNotAvailableInSession')
);
// Check if this exercise was added in a LP
if ($exercise->exercise_was_added_in_lp == true) {
$visibility = Display::return_icon(
'invisible.png',
get_lang('This exercise has been included in a learning path, so it cannot be accessed by students directly from here. If you want to put the same exercise available through the exercises tool, please make a copy of the current exercise using the copy icon.'),
'',
ICON_SIZE_SMALL
);
} else {
if ($row['active'] == 0 || $visibility == 0) {
$visibility = Display::url(
Display::return_icon(
'invisible.png',
get_lang('Activate'),
'',
ICON_SIZE_SMALL
),
'exercise.php?'.api_get_cidreq().'&choice=enable&sec_token='.$token.'&exerciseId='.$row['id']
);
} else {
// else if not active
$visibility = Display::url(
Display::return_icon(
'visible.png',
get_lang('Deactivate'),
'',
ICON_SIZE_SMALL
),
'exercise.php?'.api_get_cidreq().'&choice=disable&sec_token='.$token.'&exerciseId='.$row['id']
);
}
}
if ($limitTeacherAccess && !api_is_platform_admin()) {
$visibility = '';
}
$actions .= $visibility;
$actions .= '
'.
Display::return_icon('test_results.png', get_lang('Results and feedback and feedback and feedback and feedback and feedback and feedback'), '', ICON_SIZE_SMALL).'';
$actions .= Display::url(
Display::return_icon('cd.gif', get_lang('CopyTest')),
'',
[
'onclick' => "javascript:if(!confirm('".addslashes(api_htmlentities(get_lang('Are you sure to copy'), ENT_QUOTES, $charset))." ".addslashes($row['title'])."?"."')) return false;",
'href' => 'exercise.php?'.api_get_cidreq().'&choice=copy_exercise&sec_token='.$token.'&exerciseId='.$row['id'],
]
);
}
// Delete
$delete = '';
if ($sessionId == $row['session_id']) {
if ($locked == false) {
$delete = Display::url(
Display::return_icon(
'delete.png',
get_lang('Delete'),
'',
ICON_SIZE_SMALL
),
'',
[
'onclick' => "javascript:if(!confirm('".addslashes(api_htmlentities(get_lang('Are you sure to delete'), ENT_QUOTES, $charset))." ".addslashes($exercise->getUnformattedTitle())."?"."')) return false;",
'href' => 'exercise.php?'.api_get_cidreq().'&choice=delete&sec_token='.$token.'&exerciseId='.$row['id'],
]
);
} else {
$delete = Display::return_icon(
'delete_na.png',
get_lang('This option is not available because this activity is contained by an assessment, which is currently locked. To unlock the assessment, ask your platform administrator.'),
'',
ICON_SIZE_SMALL
);
}
}
if ($limitTeacherAccess && !api_is_platform_admin()) {
$delete = '';
}
$actions .= $delete;
// Number of questions
$random_label = null;
if ($row['random'] > 0 || $row['random'] == -1) {
// if random == -1 means use random questions with all questions
$random_number_of_question = $row['random'];
if ($random_number_of_question == -1) {
$random_number_of_question = $rowi;
}
if ($row['random_by_category'] > 0) {
$nbQuestionsTotal = TestCategory::getNumberOfQuestionRandomByCategory(
$my_exercise_id,
$random_number_of_question
);
$number_of_questions = $nbQuestionsTotal.' ';
$number_of_questions .= ($nbQuestionsTotal > 1) ? get_lang('questions') : get_lang('question');
$number_of_questions .= ' - ';
$number_of_questions .= min(
TestCategory::getNumberMaxQuestionByCat($my_exercise_id), $random_number_of_question
).' '.get_lang('QuestionByCategory');
} else {
$random_label = ' ('.get_lang('Random').') ';
$number_of_questions = $random_number_of_question.' '.$random_label.' / '.$rowi;
// Bug if we set a random value bigger than the real number of questions
if ($random_number_of_question > $rowi) {
$number_of_questions = $rowi.' '.$random_label;
}
}
} else {
$number_of_questions = $rowi;
}
$currentRow['count_questions'] = $number_of_questions;
} else {
// Student only.
$visibility = api_get_item_visibility(
$courseInfo,
TOOL_QUIZ,
$my_exercise_id,
$sessionId
);
if ($visibility == 0) {
continue;
}
$url = '
'.
$cut_title.'';
// Link of the exercise.
$currentRow['title'] = $url.' '.$session_img;
// This query might be improved later on by ordering by the new "tms" field rather than by exe_id
// Don't remove this marker: note-query-exe-results
$sql = "SELECT * FROM $TBL_TRACK_EXERCISES
WHERE
exe_exo_id = ".$row['id']." AND
exe_user_id = $userId AND
c_id = ".api_get_course_int_id()." AND
status <> 'incomplete' AND
orig_lp_id = 0 AND
orig_lp_item_id = 0 AND
session_id = '".api_get_session_id()."'
ORDER BY exe_id DESC";
$qryres = Database::query($sql);
$num = Database :: num_rows($qryres);
// Hide the results.
$my_result_disabled = $row['results_disabled'];
$attempt_text = '-';
// Time limits are on
if ($time_limits) {
// Exam is ready to be taken
if ($is_actived_time) {
// Show results
if (
in_array(
$my_result_disabled,
[
RESULT_DISABLE_SHOW_SCORE_AND_EXPECTED_ANSWERS,
RESULT_DISABLE_SHOW_SCORE_AND_EXPECTED_ANSWERS_AND_RANKING,
RESULT_DISABLE_SHOW_SCORE_ONLY,
RESULT_DISABLE_RANKING,
]
)
) {
// More than one attempt
if ($num > 0) {
$row_track = Database :: fetch_array($qryres);
$attempt_text = get_lang('LatestAttempt').' : ';
$attempt_text .= ExerciseLib::show_score(
$row_track['exe_result'],
$row_track['exe_weighting']
);
} else {
//No attempts
$attempt_text = get_lang('Not attempted');
}
} else {
$attempt_text = '-';
}
} else {
// Quiz not ready due to time limits
//@todo use the is_visible function
if (!empty($row['start_time']) && !empty($row['end_time'])) {
$today = time();
$start_time = api_strtotime($row['start_time'], 'UTC');
$end_time = api_strtotime($row['end_time'], 'UTC');
if ($today < $start_time) {
$attempt_text = sprintf(
get_lang('ExerciseWillBeActivatedFromXToY'),
api_convert_and_format_date($row['start_time']),
api_convert_and_format_date($row['end_time'])
);
} else {
if ($today > $end_time) {
$attempt_text = sprintf(
get_lang('ExerciseWasActivatedFromXToY'),
api_convert_and_format_date($row['start_time']),
api_convert_and_format_date($row['end_time'])
);
}
}
} else {
//$attempt_text = get_lang('ExamNotAvailableAtThisTime');
if (!empty($row['start_time'])) {
$attempt_text = sprintf(
get_lang('TestAvailableFromX'),
api_convert_and_format_date($row['start_time'])
);
}
if (!empty($row['end_time'])) {
$attempt_text = sprintf(
get_lang('TestAvailableUntilX'),
api_convert_and_format_date($row['end_time'])
);
}
}
}
} else {
// Normal behaviour.
// Show results.
if (
in_array(
$my_result_disabled,
[
RESULT_DISABLE_SHOW_SCORE_AND_EXPECTED_ANSWERS,
RESULT_DISABLE_SHOW_SCORE_AND_EXPECTED_ANSWERS_AND_RANKING,
RESULT_DISABLE_SHOW_SCORE_ONLY,
RESULT_DISABLE_RANKING,
]
)
) {
if ($num > 0) {
$row_track = Database :: fetch_array($qryres);
$attempt_text = get_lang('LatestAttempt').' : ';
$attempt_text .= ExerciseLib::show_score(
$row_track['exe_result'],
$row_track['exe_weighting']
);
} else {
$attempt_text = get_lang('Not attempted');
}
}
}
}
$currentRow['attempt'] = $attempt_text;
if ($is_allowedToEdit) {
$additionalActions = ExerciseLib::getAdditionalTeacherActions($row['id']);
if (!empty($additionalActions)) {
$actions .= $additionalActions.PHP_EOL;
}
$currentRow = [
$row['id'],
$currentRow['title'],
$currentRow['count_questions'],
$actions,
];
} else {
$currentRow = [
$currentRow['title'],
$currentRow['attempt'],
];
if ($isDrhOfCourse) {
$currentRow[] = '
'.
Display::return_icon('test_results.png', get_lang('Results and feedback and feedback and feedback and feedback and feedback and feedback'), '', ICON_SIZE_SMALL).'';
}
}
$tableRows[] = $currentRow;
}
}
}
// end exercise list
// Hotpotatoes results
if ($is_allowedToEdit) {
$sql = "SELECT d.iid, d.path as path, d.comment as comment
FROM $TBL_DOCUMENT d
WHERE
d.c_id = $courseId AND
(d.path LIKE '%htm%') AND
d.path LIKE '".Database :: escape_string($uploadPath.'/%/%')."'
LIMIT $from , $limit"; // only .htm or .html files listed
} else {
$sql = "SELECT d.iid, d.path as path, d.comment as comment
FROM $TBL_DOCUMENT d
WHERE
d.c_id = $courseId AND
(d.path LIKE '%htm%') AND
d.path LIKE '".Database :: escape_string($uploadPath.'/%/%')."'
LIMIT $from , $limit";
}
$result = Database::query($sql);
$attributes = [];
while ($row = Database::fetch_array($result, 'ASSOC')) {
$attributes[$row['iid']] = $row;
}
$nbrActiveTests = 0;
if (!empty($attributes)) {
foreach ($attributes as $item) {
$id = $item['iid'];
$path = $item['path'];
$title = GetQuizName($path, $documentPath);
if ($title == '') {
$title = basename($path);
}
// prof only
if ($is_allowedToEdit) {
$visibility = api_get_item_visibility(
['real_id' => $courseId],
TOOL_DOCUMENT,
$id,
0
);
if (!empty($sessionId)) {
if (0 == $visibility) {
continue;
}
$visibility = api_get_item_visibility(
['real_id' => $courseId],
TOOL_DOCUMENT,
$id,
$sessionId
);
}
$title =
implode(PHP_EOL, [
Display::return_icon('hotpotatoes_s.png', 'HotPotatoes'),
Display::url(
$title,
'showinframes.php?'.api_get_cidreq().'&'.http_build_query([
'file' => $path,
'uid' => $userId,
]),
['class' => $visibility == 0 ? 'text-muted' : null]
),
]);
$actions = Display::url(
Display::return_icon(
'edit.png',
get_lang('Edit'),
'',
ICON_SIZE_SMALL
),
'adminhp.php?'.api_get_cidreq().'&hotpotatoesName='.$path
);
$actions .= '
'.
Display::return_icon('test_results.png', get_lang('Results and feedback and feedback and feedback and feedback and feedback and feedback'), '', ICON_SIZE_SMALL).
'';
// if active
if ($visibility != 0) {
$nbrActiveTests = $nbrActiveTests + 1;
$actions .= '
'.
Display::return_icon('visible.png', get_lang('Deactivate'), '', ICON_SIZE_SMALL).'';
} else { // else if not active
$actions .= '
'.
Display::return_icon('invisible.png', get_lang('Activate'), '', ICON_SIZE_SMALL).'';
}
$actions .= '
'.
Display::return_icon('delete.png', get_lang('Delete'), '', ICON_SIZE_SMALL).'';
$currentRow = [
'',
$title,
'',
$actions,
];
} else {
$visibility = api_get_item_visibility(
['real_id' => $courseId],
TOOL_DOCUMENT,
$id,
$sessionId
);
if (0 == $visibility) {
continue;
}
// Student only
$attempt = ExerciseLib::getLatestHotPotatoResult(
$path,
$userId,
api_get_course_int_id(),
api_get_session_id()
);
$nbrActiveTests = $nbrActiveTests + 1;
$title = Display::url(
$title,
'showinframes.php?'.api_get_cidreq().'&'.http_build_query(
[
'file' => $path,
'cid' => api_get_course_id(),
'uid' => $userId,
]
)
);
if (!empty($attempt)) {
$actions = '
'.Display::return_icon('test_results.png', get_lang('Results and feedback and feedback and feedback and feedback and feedback and feedback'), '', ICON_SIZE_SMALL).'';
$attemptText = get_lang('Latest attempt').' : ';
$attemptText .= ExerciseLib::show_score(
$attempt['exe_result'],
$attempt['exe_weighting']
).' ';
$attemptText .= $actions;
} else {
// No attempts.
$attemptText = get_lang('Not attempted').' ';
}
$currentRow = [
$title,
$attemptText,
];
if ($isDrhOfCourse) {
$currentRow[] = '
'.
Display::return_icon('test_results.png', get_lang('Results and feedback and feedback and feedback and feedback and feedback and feedback'), '', ICON_SIZE_SMALL).'';
}
}
$tableRows[] = $currentRow;
}
}
if (empty($tableRows) && empty($categoryId)) {
if ($is_allowedToEdit && $origin != 'learnpath') {
$content .= '
';
$content .= '
'.get_lang('Tests').'
';
$content .= Display::return_icon('quiz.png', '', [], 64);
$content .= '
';
$content .= Display::url(
' '.get_lang('Create a new test'),
'exercise_admin.php?'.api_get_cidreq(),
['class' => 'btn btn-primary']
);
$content .= '
';
$content .= '
';
}
} else {
if (empty($tableRows)) {
return '';
}
$table->setTableData($tableRows);
$table->setTotalNumberOfItems($total);
$table->set_additional_parameters([
'cidReq' => api_get_course_id(),
'id_session' => api_get_session_id(),
'category_id' => $categoryId,
]);
if ($is_allowedToEdit) {
$formActions = [];
$formActions['visible'] = get_lang('Activate');
$formActions['invisible'] = get_lang('Deactivate');
$formActions['delete'] = get_lang('Delete');
$table->set_form_actions($formActions);
}
$i = 0;
if ($is_allowedToEdit) {
$table->set_header($i++, '', false, 'width="18px"');
}
$table->set_header($i++, get_lang('Test name'), false);
if ($is_allowedToEdit) {
$table->set_header($i++, get_lang('Questions'), false);
$table->set_header($i++, get_lang('Detail'), false);
} else {
$table->set_header($i++, get_lang('Status'), false);
if ($isDrhOfCourse) {
$table->set_header($i++, get_lang('Detail'), false);
}
}
$content .= $table->return_table();
}
return $content;
}
/**
* @return int value in minutes
*/
public function getResultAccess()
{
$extraFieldValue = new ExtraFieldValue('exercise');
$value = $extraFieldValue->get_values_by_handler_and_field_variable(
$this->iId,
'results_available_for_x_minutes'
);
if (!empty($value) && isset($value['value'])) {
return (int) $value['value'];
}
return 0;
}
/**
* @param array $exerciseResultInfo
*
* @return bool
*/
public function getResultAccessTimeDiff($exerciseResultInfo)
{
$value = $this->getResultAccess();
if (!empty($value)) {
$endDate = new DateTime($exerciseResultInfo['exe_date'], new DateTimeZone('UTC'));
$endDate->add(new DateInterval('PT'.$value.'M'));
$now = time();
if ($endDate->getTimestamp() > $now) {
return (int) $endDate->getTimestamp() - $now;
}
}
return 0;
}
/**
* @param array $exerciseResultInfo
*
* @return bool
*/
public function hasResultsAccess($exerciseResultInfo)
{
$diff = $this->getResultAccessTimeDiff($exerciseResultInfo);
if ($diff === 0) {
return false;
}
return true;
}
/**
* @return int
*/
public function getResultsAccess()
{
$extraFieldValue = new ExtraFieldValue('exercise');
$value = $extraFieldValue->get_values_by_handler_and_field_variable(
$this->iId,
'results_available_for_x_minutes'
);
if (!empty($value)) {
return (int) $value;
}
return 0;
}
/**
* @param Question $objQuestionTmp
* @param int $questionId
* @param bool $show_results
* @param array $question_result
*/
public function getDelineationResult(Question $objQuestionTmp, $questionId, $show_results, $question_result)
{
$id = (int) $objQuestionTmp->id;
$questionId = (int) $questionId;
$final_overlap = $question_result['extra']['final_overlap'];
$final_missing = $question_result['extra']['final_missing'];
$final_excess = $question_result['extra']['final_excess'];
$overlap_color = $question_result['extra']['overlap_color'];
$missing_color = $question_result['extra']['missing_color'];
$excess_color = $question_result['extra']['excess_color'];
$threadhold1 = $question_result['extra']['threadhold1'];
$threadhold2 = $question_result['extra']['threadhold2'];
$threadhold3 = $question_result['extra']['threadhold3'];
if ($show_results) {
if ($overlap_color) {
$overlap_color = 'green';
} else {
$overlap_color = 'red';
}
if ($missing_color) {
$missing_color = 'green';
} else {
$missing_color = 'red';
}
if ($excess_color) {
$excess_color = 'green';
} else {
$excess_color = 'red';
}
if (!is_numeric($final_overlap)) {
$final_overlap = 0;
}
if (!is_numeric($final_missing)) {
$final_missing = 0;
}
if (!is_numeric($final_excess)) {
$final_excess = 0;
}
if ($final_excess > 100) {
$final_excess = 100;
}
$table_resume = '
|
'.get_lang('Requirements').' |
'.get_lang('Your answer').' |
'.get_lang('Overlapping areaping area').' |
'.get_lang('Minimumimum').' '.$threadhold1.' |
'.(($final_overlap < 0) ? 0 : intval($final_overlap)).'
|
'.get_lang('Excessive areaive area').' |
'.get_lang('max. 20 characters, e.g. INNOV21').' '.$threadhold2.' |
'.(($final_excess < 0) ? 0 : intval($final_excess)).'
|
'.get_lang('Missing area area').' |
'.get_lang('max. 20 characters, e.g. INNOV21').' '.$threadhold3.' |
'.(($final_missing < 0) ? 0 : intval($final_missing)).'
|
';
$answerType = $objQuestionTmp->selectType();
if ($answerType != HOT_SPOT_DELINEATION) {
$item_list = explode('@@', $destination);
$try = $item_list[0];
$lp = $item_list[1];
$destinationid = $item_list[2];
$url = $item_list[3];
$table_resume = '';
} else {
if ($next == 0) {
$try = $try_hotspot;
$lp = $lp_hotspot;
$destinationid = $select_question_hotspot;
$url = $url_hotspot;
} else {
//show if no error
$comment = $answerComment = $objAnswerTmp->selectComment($nbrAnswers);
$answerDestination = $objAnswerTmp->selectDestination($nbrAnswers);
}
}
echo '
'.get_lang('Feedback').'
';
if ($answerType == HOT_SPOT_DELINEATION) {
if ($organs_at_risk_hit > 0) {
$message = '
'.get_lang('Your result is :').'
'.$result_comment.'';
$message .= '
'.get_lang('One (or more) area at risk has been hit').'
';
} else {
$message = '
'.get_lang('Your delineation :').'
';
$message .= $table_resume;
$message .= '
'.get_lang('Your result is :').'
'.$result_comment.'';
}
$message .= '
'.$comment.'
';
echo $message;
} else {
echo '
'.$comment.'
';
}
// Showing the score
/*$queryfree = "SELECT marks FROM $TBL_TRACK_ATTEMPT
WHERE exe_id = $id AND question_id = $questionId";
$resfree = Database::query($queryfree);
$questionScore = Database::result($resfree, 0, 'marks');
$totalScore += $questionScore;*/
$relPath = api_get_path(REL_PATH);
echo '';
echo "
|
";
}
}
/**
* Clean exercise session variables.
*/
public static function cleanSessionVariables()
{
Session::erase('objExercise');
Session::erase('exe_id');
Session::erase('calculatedAnswerId');
Session::erase('duration_time_previous');
Session::erase('duration_time');
Session::erase('objQuestion');
Session::erase('objAnswer');
Session::erase('questionList');
Session::erase('exerciseResult');
Session::erase('firstTime');
Session::erase('exerciseResultCoordinates');
Session::erase('hotspot_coord');
Session::erase('hotspot_dest');
Session::erase('hotspot_delineation_result');
}
/**
* Gets the question list ordered by the question_order setting (drag and drop).
*
* @param bool $adminView Optional.
*
* @return array
*/
private function getQuestionOrderedList($adminView = false)
{
$TBL_EXERCICE_QUESTION = Database::get_course_table(TABLE_QUIZ_TEST_QUESTION);
$TBL_QUESTIONS = Database::get_course_table(TABLE_QUIZ_QUESTION);
// Getting question_order to verify that the question
// list is correct and all question_order's were set
$sql = "SELECT DISTINCT count(e.question_order) as count
FROM $TBL_EXERCICE_QUESTION e
INNER JOIN $TBL_QUESTIONS q
ON (e.question_id = q.id AND e.c_id = q.c_id)
WHERE
e.c_id = {$this->course_id} AND
e.exercice_id = ".$this->id;
$result = Database::query($sql);
$row = Database::fetch_array($result);
$count_question_orders = $row['count'];
// Getting question list from the order (question list drag n drop interface).
$sql = "SELECT DISTINCT e.question_id, e.question_order
FROM $TBL_EXERCICE_QUESTION e
INNER JOIN $TBL_QUESTIONS q
ON (e.question_id = q.id AND e.c_id = q.c_id)
WHERE
e.c_id = {$this->course_id} AND
e.exercice_id = '".$this->id."'
ORDER BY question_order";
$result = Database::query($sql);
// Fills the array with the question ID for this exercise
// the key of the array is the question position
$temp_question_list = [];
$counter = 1;
$questionList = [];
while ($new_object = Database::fetch_object($result)) {
if (!$adminView) {
// Correct order.
$questionList[$new_object->question_order] = $new_object->question_id;
} else {
$questionList[$counter] = $new_object->question_id;
}
// Just in case we save the order in other array
$temp_question_list[$counter] = $new_object->question_id;
$counter++;
}
if (!empty($temp_question_list)) {
/* If both array don't match it means that question_order was not correctly set
for all questions using the default mysql order */
if (count($temp_question_list) != $count_question_orders) {
$questionList = $temp_question_list;
}
}
return $questionList;
}
/**
* Select N values from the questions per category array.
*
* @param array $categoriesAddedInExercise
* @param array $question_list
* @param array $questions_by_category per category
* @param bool $flatResult
* @param bool $randomizeQuestions
*
* @return array
*/
private function pickQuestionsPerCategory(
$categoriesAddedInExercise,
$question_list,
&$questions_by_category,
$flatResult = true,
$randomizeQuestions = false
) {
$addAll = true;
$categoryCountArray = [];
// Getting how many questions will be selected per category.
if (!empty($categoriesAddedInExercise)) {
$addAll = false;
// Parsing question according the category rel exercise settings
foreach ($categoriesAddedInExercise as $category_info) {
$category_id = $category_info['category_id'];
if (isset($questions_by_category[$category_id])) {
// How many question will be picked from this category.
$count = $category_info['count_questions'];
// -1 means all questions
$categoryCountArray[$category_id] = $count;
if ($count == -1) {
$categoryCountArray[$category_id] = 999;
}
}
}
}
if (!empty($questions_by_category)) {
$temp_question_list = [];
foreach ($questions_by_category as $category_id => &$categoryQuestionList) {
if (isset($categoryCountArray) && !empty($categoryCountArray)) {
$numberOfQuestions = 0;
if (isset($categoryCountArray[$category_id])) {
$numberOfQuestions = $categoryCountArray[$category_id];
}
}
if ($addAll) {
$numberOfQuestions = 999;
}
if (!empty($numberOfQuestions)) {
$elements = TestCategory::getNElementsFromArray(
$categoryQuestionList,
$numberOfQuestions,
$randomizeQuestions
);
if (!empty($elements)) {
$temp_question_list[$category_id] = $elements;
$categoryQuestionList = $elements;
}
}
}
if (!empty($temp_question_list)) {
if ($flatResult) {
$temp_question_list = array_flatten($temp_question_list);
}
$question_list = $temp_question_list;
}
}
return $question_list;
}
/**
* Changes the exercise id.
*
* @param int $id - exercise id
*/
private function updateId($id)
{
$this->id = $id;
}
/**
* Sends a notification when a user ends an examn.
*
* @param array $question_list_answers
* @param string $origin
* @param array $user_info
* @param string $url_email
* @param array $teachers
*/
private function sendNotificationForOpenQuestions(
$question_list_answers,
$origin,
$user_info,
$url_email,
$teachers
) {
// Email configuration settings
$courseCode = api_get_course_id();
$courseInfo = api_get_course_info($courseCode);
$sessionId = api_get_session_id();
$sessionData = '';
if (!empty($sessionId)) {
$sessionInfo = api_get_session_info($sessionId);
if (!empty($sessionInfo)) {
$sessionData = '
'
.''.get_lang('Session name').' | '
.' '.$sessionInfo['name'].' | '
.'
';
}
}
$msg = get_lang('A learner has answered an open question').'
'
.get_lang('Attempt details').' :
'
.'
'
.''
.''.get_lang('Course name').' | '
.' #course# | '
.'
'
.$sessionData
.''
.''.get_lang('Test attempted').' | '
.' #exercise# | '
.'
'
.''
.''.get_lang('Learner name').' | '
.' #firstName# #lastName# | '
.'
'
.''
.''.get_lang('Learner e-mail').' | '
.' #mail# | '
.'
'
.'
';
$open_question_list = null;
foreach ($question_list_answers as $item) {
$question = $item['question'];
$answer = $item['answer'];
$answer_type = $item['answer_type'];
if (!empty($question) && !empty($answer) && $answer_type == FREE_ANSWER) {
$open_question_list .=
'
'
.' '.get_lang('Question').' | '
.''.$question.' | '
.'
'
.'
'
.' '.get_lang('Answer').' | '
.''.$answer.' | '
.'
';
}
}
if (!empty($open_question_list)) {
$msg .= '
'.get_lang('A learner has answered an open questionAre').' :
'.
'
';
$msg .= $open_question_list;
$msg .= '
';
$msg = str_replace('#exercise#', $this->exercise, $msg);
$msg = str_replace('#firstName#', $user_info['firstname'], $msg);
$msg = str_replace('#lastName#', $user_info['lastname'], $msg);
$msg = str_replace('#mail#', $user_info['email'], $msg);
$msg = str_replace(
'#course#',
Display::url($courseInfo['title'], $courseInfo['course_public_url'].'?id_session='.$sessionId),
$msg
);
if ($origin != 'learnpath') {
$msg .= '
'.get_lang('Click this link to check the answer and/or give feedback').'';
}
$msg = str_replace('#url#', $url_email, $msg);
$subject = get_lang('A learner has answered an open question');
if (!empty($teachers)) {
foreach ($teachers as $user_id => $teacher_data) {
MessageManager::send_message_simple(
$user_id,
$subject,
$msg
);
}
}
}
}
/**
* Send notification for oral questions.
*
* @param array $question_list_answers
* @param string $origin
* @param int $exe_id
* @param array $user_info
* @param string $url_email
* @param array $teachers
*/
private function sendNotificationForOralQuestions(
$question_list_answers,
$origin,
$exe_id,
$user_info,
$url_email,
$teachers
) {
// Email configuration settings
$courseCode = api_get_course_id();
$courseInfo = api_get_course_info($courseCode);
$oral_question_list = null;
foreach ($question_list_answers as $item) {
$question = $item['question'];
$file = $item['generated_oral_file'];
$answer = $item['answer'];
if ($answer == 0) {
$answer = '';
}
$answer_type = $item['answer_type'];
if (!empty($question) && (!empty($answer) || !empty($file)) && $answer_type == ORAL_EXPRESSION) {
if (!empty($file)) {
$file = Display::url($file, $file);
}
$oral_question_list .= '
'.get_lang('Question').' |
'.$question.' |
'.get_lang('Answer').' |
'.$answer.$file.' |
';
}
}
if (!empty($oral_question_list)) {
$msg = get_lang('A learner has attempted one or more oral question').'
'.get_lang('Attempt details').' :
'.get_lang('Course name').' |
#course# |
'.get_lang('Test attempted').' |
#exercise# |
'.get_lang('Learner name').' |
#firstName# #lastName# |
'.get_lang('Learner e-mail').' |
#mail# |
';
$msg .= '
'.sprintf(get_lang('A learner has attempted one or more oral questionAreX'), $oral_question_list).'
';
$msg1 = str_replace("#exercise#", $this->exercise, $msg);
$msg = str_replace("#firstName#", $user_info['firstname'], $msg1);
$msg1 = str_replace("#lastName#", $user_info['lastname'], $msg);
$msg = str_replace("#mail#", $user_info['email'], $msg1);
$msg = str_replace("#course#", $courseInfo['name'], $msg1);
if (!in_array($origin, ['learnpath', 'embeddable'])) {
$msg .= '
'.get_lang('Click this link to check the answer and/or give feedback').'';
}
$msg1 = str_replace("#url#", $url_email, $msg);
$mail_content = $msg1;
$subject = get_lang('A learner has attempted one or more oral question');
if (!empty($teachers)) {
foreach ($teachers as $user_id => $teacher_data) {
MessageManager::send_message_simple(
$user_id,
$subject,
$mail_content
);
}
}
}
}
/**
* Returns an array with the media list.
*
* @param array question list
*
* @example there's 1 question with iid 5 that belongs to the media question with iid = 100
*
* array (size=2)
* 999 =>
* array (size=3)
* 0 => int 7
* 1 => int 6
* 2 => int 3254
* 100 =>
* array (size=1)
* 0 => int 5
*
*/
private function setMediaList($questionList)
{
$mediaList = [];
/*
* Media feature is not activated in 1.11.x
if (!empty($questionList)) {
foreach ($questionList as $questionId) {
$objQuestionTmp = Question::read($questionId, $this->course_id);
// If a media question exists
if (isset($objQuestionTmp->parent_id) && $objQuestionTmp->parent_id != 0) {
$mediaList[$objQuestionTmp->parent_id][] = $objQuestionTmp->id;
} else {
// Always the last item
$mediaList[999][] = $objQuestionTmp->id;
}
}
}*/
$this->mediaList = $mediaList;
}
/**
* @param FormValidator $form
*
* @return HTML_QuickForm_group
*/
private function setResultDisabledGroup(FormValidator $form)
{
$resultDisabledGroup = [];
$resultDisabledGroup[] = $form->createElement(
'radio',
'results_disabled',
null,
get_lang('Auto-evaluation mode: show score and expected answers'),
'0',
['id' => 'result_disabled_0']
);
$resultDisabledGroup[] = $form->createElement(
'radio',
'results_disabled',
null,
get_lang('Exam mode: Do not show score nor answers'),
'1',
['id' => 'result_disabled_1', 'onclick' => 'check_results_disabled()']
);
$resultDisabledGroup[] = $form->createElement(
'radio',
'results_disabled',
null,
get_lang('Practice mode: Show score only, by category if at least one is used'),
'2',
['id' => 'result_disabled_2', 'onclick' => 'check_results_disabled()']
);
if (in_array($this->getFeedbackType(), [EXERCISE_FEEDBACK_TYPE_DIRECT, EXERCISE_FEEDBACK_TYPE_POPUP])) {
$group = $form->addGroup(
$resultDisabledGroup,
null,
get_lang('ShowResults and feedback and feedback and feedback and feedback and feedback and feedbackToStudents')
);
return $group;
}
$resultDisabledGroup[] = $form->createElement(
'radio',
'results_disabled',
null,
get_lang('Show score on every attempt, show correct answers only on last attempt (only works with an attempts limit)'),
'4',
['id' => 'result_disabled_4']
);
$resultDisabledGroup[] = $form->createElement(
'radio',
'results_disabled',
null,
get_lang('Do not show the score (only when user finishes all attempts) but show feedback for each attempt.'),
'5',
['id' => 'result_disabled_5', 'onclick' => 'check_results_disabled()']
);
$resultDisabledGroup[] = $form->createElement(
'radio',
'results_disabled',
null,
get_lang('TestRankingMode'),
RESULT_DISABLE_RANKING,
['id' => 'result_disabled_6']
);
$resultDisabledGroup[] = $form->createElement(
'radio',
'results_disabled',
null,
get_lang('TestShowOnlyGlobalScoreAndCorrect answers'),
RESULT_DISABLE_SHOW_ONLY_IN_CORRECT_ANSWER,
['id' => 'result_disabled_7']
);
$resultDisabledGroup[] = $form->createElement(
'radio',
'results_disabled',
null,
get_lang('TestAutoEvaluationAndRankingMode'),
RESULT_DISABLE_SHOW_SCORE_AND_EXPECTED_ANSWERS_AND_RANKING,
['id' => 'result_disabled_8']
);
$group = $form->addGroup(
$resultDisabledGroup,
null,
get_lang('ShowResults and feedback and feedback and feedback and feedback and feedback and feedbackToStudents')
);
return $group;
}
}