File manager - Edit - /home/missmand/public_html/learning/old/main/couple/eval.php
Back
<?php /* For licensing terms, see /license.txt */ /** * Model CRUD for couple_tool_eval * @author Batiste Roger <batiste.roger@live.fr> * @package chamilo.couple */ require_once(api_get_path(SYS_PATH) . 'main/couple/tool.php'); define('TABLE_TUTOR_EVAL', 'couple_tutor_eval'); define('TABLE_TUTOR_EVAL_QUESTION', 'couple_tutor_eval_question'); function eval_create_form ($user_id) { $subrole_prefix = get_subrole($user_id); $questions = eval_read_questions($subrole_prefix); $answers = array(); foreach ($questions as $question) { $id = $question['id']; if (!isset($_GET[$id])) return false; // All questions should be answered $answers[$id] = intval($_GET[$id]); } return eval_create($user_id, $answers); } function eval_create ($user_id, $question_array) { // Check that booleans are booleans try { error_test_param (UserManager::is_user_id_valid($user_id), "Id $user_id is not a valid user id."); } catch (Exception $e) { return error_log($e->getMessage()); } foreach ($question_array as $question_id => $question_eval) { $sql = "INSERT INTO " . TABLE_TUTOR_EVAL . " SET question_id = '$question_id', user_id = '$user_id', eval = '$question_eval'"; Database::query($sql); } // Create the action item $tool_id = tool_get_max_id(); $sql = "INSERT INTO " . TABLE_TOOL_ACTION . " SET tool_id = '$tool_id'"; $ret = Database::query($sql); return $ret; } function eval_read ($user_id) { if (!UserManager::is_user_id_valid($user_id)) return null; $sql = "SELECT question_id, eval, date_creation FROM " . TABLE_TUTOR_EVAL . " WHERE user_id = '$user_id'"; $result = Database::query($sql); $result_array = array(); while ($row = Database::fetch_assoc($result)) { $q_id = $row['question_id']; $date = new DateTime($row['date_creation']); if (!isset($result_array[$q_id]) || $result_array[$q_id]['date'] < $date) { $result_array[$q_id] = $row; $result_array[$q_id]['date'] = $date; } } return $result_array; } function eval_read_all ($user_id) { $sql = "SELECT *, eval as evaluation, " . "MINUTE (date_creation) AS minute, " . "HOUR (date_creation) AS hour, " . "DAY (date_creation) AS day, " . "MONTH(date_creation) AS month, " . "YEAR (date_creation) AS year " . "FROM " . TABLE_TUTOR_EVAL . " evals JOIN " . TABLE_TUTOR_EVAL_QUESTION . " questions ON evals.question_id = questions.id WHERE user_id = '$user_id' ORDER BY date_creation"; $res = Database::query($sql); $array = array(); while ($row = Database::fetch_assoc($res)) { $array[$row['question_id']][] = $row; // Ajout de la ligne dans array[question_id] } return $array; } /** * Lists questions for the given subrole * @param type $subrole * @return array(SELECT*) */ function eval_read_questions ($subrole) { $subrole_prefix = subrole_to_prefix($subrole); $sql = "SELECT * FROM " . TABLE_TUTOR_EVAL_QUESTION . " WHERE subrole = '$subrole_prefix' ORDER BY id"; $result = Database::query($sql); $result_array = array(); while ($row = Database::fetch_array($result)) { $result_array[] = $row; } return $result_array; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings