function run_handler(&$RES, $test, $answered_question_id, $answer_id) { $t = DBkitModel::get("SELECT MAX(`order`) AS question_count FROM questions WHERE `test_id` = %d", $test->id); $question_count = $t->question_count; $action = next_action($RES, $question_count); if ($action == 'random') { $action = array(1, $question_count); } if ($action == 'next') { $action = $RES->question_ord + 1; } if (is_integer($action) && $action > $question_count) { $action = 'finish'; } $answered_question_ids = collect_attrs($RES->answers, 'question_id'); $id_cond = empty($answered_question_ids) ? "TRUE" : "`id` NOT IN ?"; if (is_integer($action)) { $t = DBkitModel::get("SELECT MIN(`order`) AS `order` FROM `questions` WHERE `test_id`=%d AND `order`>=%d AND {$id_cond}", $test->id, $action, $answered_question_ids); if (!$t) { // TODO: what to do when the question_ord returned by the handler does not exist? } $question = Question::get("WHERE `order` = %d AND `test_id` = %d LIMIT 1", $t->order, $test->id); } else { if (is_array($action)) { $t = DBkitModel::query("SELECT `id` FROM `questions` WHERE `test_id`=%d AND `order` BETWEEN %d AND %d AND {$id_cond}", $test->id, $action[0], $action[1], $answered_question_ids); if (empty($t)) { $action = 'finish'; } else { $t = $t[mt_rand(0, count($t) - 1)]; $question = Question::get("WHERE `id` = %d AND `test_id` = %d LIMIT 1", $t->id, $test->id); } } } if ($question) { $RES->question_id = $question->id; $RES->question_ord = $question->order; $RES->question_no++; if (!is_null($answered_question_id)) { stat_question_answered($RES->session_id, $test->id, $RES->partner_id, $RES->day, $answered_question_id, $answer_id, $RES->question_id, $RES->paid); } return $question; } if ($action == 'finish') { $RES->finished = true; if ($RES->paid) { $RES->sms_chal = random_string(REATESTER_SMS_CHAL_LENGTH); $RES->sms_resp = random_string(REATESTER_SMS_RESP_LENGTH); } else { $RES->sms_chal = $RES->sms_resp = null; } stat_test_finished($RES->session_id, $test->id, $RES->partner_id, $RES->day, $answered_question_id, $answer_id, $RES->paid, $RES->sms_chal, $RES->sms_resp); redirect("/tests/{$test->id}/"); die; } die("Internal error: invalid handler action '{$action}'"); }
<?php include '../lib/common.inc.php'; $id = $_REQUEST['question_id']; $is_new = $id == 'new'; if ($_POST) { if ($is_new) { $question = new Question(); $question->test_id = $_REQUEST['test_id']; $v = DBkitModel::get("SELECT MAX(`order`) AS max_order FROM `questions` WHERE `test_id`=%s", $question->test_id); $max_order = $v ? $v->max_order : 0; $question->order = $max_order + 1; $answers = array(); } else { if (!($question = Question::get("WHERE id = %s", $id))) { jsdie('questionNotFound', $id); } } $question->assign('question_', array('text', 'image_code')); $answers_data = array(); foreach ($_POST as $k => $v) { if (0 === strpos($k, "ans_")) { $arr = explode('_', $k, 3); $aid = $arr[1]; if (!isset($answers_data[$aid])) { $answers_data[$aid] = array(); } $answers_data[$aid][$arr[2]] = trim($v); } } $answers_by_id = Answer::query_indexed('id', "WHERE question_id=%d", $question->id);