PHP DBkitModel::get Examples

Example #1

File: test.php Project: andreyvit/retester

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}'");
}

Example #2

File: question_editor.php Project: andreyvit/retester

<?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);