View source
<?php
namespace Drupal\long_answer;
use Drupal\quiz_question\QuizQuestionResponse;
class LongAnswerResponse extends QuizQuestionResponse {
public static function fetchAllUnscoredAnswers($count = 50, $offset = 0) {
$user = \Drupal::currentUser();
$query = db_select('quiz_long_answer_user_answers', 'a');
$query
->fields('a', array(
'result_id',
'question_nid',
'question_vid',
'answer_feedback',
));
$query
->fields('nd', array(
'title',
'uid',
));
$query
->fields('qnr', array(
'time_end',
'time_start',
));
$query
->join('quiz_node_results', 'qnr', 'a.result_id = qnr.result_id');
$query
->join('node', 'n', 'qnr.nid = n.nid');
$query
->join('node_field_data', 'nd', 'nd.nid = n.nid AND nd.vid = n.vid');
$query
->condition('a.is_evaluated', 0);
if ($user
->hasPermission('score own quiz') && $user
->hasPermission('score taken quiz answer')) {
$query
->condition(db_or()
->condition('nd.uid', $user
->id())
->condition('qnr.uid', $user
->id()));
}
else {
if (user_access('score own quiz')) {
$query
->condition('nd.uid', $user
->id());
}
else {
if (user_access('score taken quiz answer')) {
$query
->condition('qnr.uid', $user
->id());
}
}
}
$results = $query
->execute();
$unscored = array();
foreach ($results as $row) {
$unscored[] = $row;
}
return $unscored;
}
public static function fetchUnscoredAnswersByQuestion($nid, $vid, $count = 50, $offset = 0) {
$results = db_query('SELECT result_id FROM {quiz_long_answer_user_answers}
WHERE is_evaluated = :is_evaluated
AND question_nid = :question_nid
AND question_vid = :question_vid', array(
':is_evaluated' => 0,
':question_nid' => $nid,
':question_vid' => $vid,
));
$unscored = array();
foreach ($results as $row) {
$unscored[] = $row->result_id;
}
return $unscored;
}
protected $answer_id = 0;
public function __construct($result_id, $question_node, $answer = NULL) {
parent::__construct($result_id, $question_node, $answer);
if (!isset($answer)) {
$r = db_query('SELECT answer_id, answer, is_evaluated, score, question_vid, question_nid, result_id, answer_feedback
FROM {quiz_long_answer_user_answers}
WHERE question_nid = :qnid AND question_vid = :qvid AND result_id = :rid', array(
':qnid' => $question_node
->id(),
':qvid' => $question_node
->getRevisionId(),
':rid' => $result_id,
))
->fetch();
if (!empty($r)) {
$this->answer = $r->answer;
$this->score = $r->score;
$this->evaluated = $r->is_evaluated;
$this->answer_id = $r->answer_id;
$this->answer_feedback = $r->answer_feedback;
}
}
else {
$this->answer = $answer;
$this->evaluated = FALSE;
}
}
public function isValid() {
if (trim($this->answer) == '') {
return t('You must provide an answer');
}
return TRUE;
}
public function save() {
$this->answer_id = db_insert('quiz_long_answer_user_answers')
->fields(array(
'answer' => $this->answer,
'question_nid' => $this->question
->id(),
'question_vid' => $this->question
->getRevisionId(),
'result_id' => $this->rid,
))
->execute();
}
public function delete() {
db_delete('quiz_long_answer_user_answers')
->condition('question_nid', $this->question
->id())
->condition('question_vid', $this->question
->getRevisionId())
->condition('result_id', $this->rid)
->execute();
}
public function score() {
return (int) db_query('SELECT score FROM {quiz_long_answer_user_answers}
WHERE result_id = :result_id AND question_vid = :question_vid', array(
':result_id' => $this->rid,
':question_vid' => $this->question
->getRevisionId(),
))
->fetchField();
}
public function getResponse() {
return $this->answer;
}
public function getReportFormResponse($showpoints = TRUE, $showfeedback = TRUE, $allow_scoring = FALSE) {
$form = array();
$form['#theme'] = 'long_answer_response_form';
if ($this->question && !empty($this->question->answers)) {
$answer = (object) current($this->question->answers);
}
else {
return $form;
}
$form['answer'] = array(
'#markup' => check_markup($answer->answer),
);
if ($answer->is_evaluated == 1) {
if ($showfeedback && !empty($answer->feedback)) {
$feedback = check_markup($answer->feedback);
}
}
else {
$feedback = t('This answer has not yet been scored.') . '<br/>' . t('Until the answer is scored, the total score will not be correct.');
}
if ($allow_scoring) {
$form['rubric'] = array(
'#type' => 'item',
'#title' => t('Rubric'),
'#markup' => check_markup($this->question->rubric),
);
}
if (!$allow_scoring && !empty($this->answer_feedback)) {
$form['answer_feedback'] = array(
'#title' => t('Feedback'),
'#type' => 'item',
'#markup' => '<span class="quiz_answer_feedback">' . $this->answer_feedback . '</span>',
);
}
if (!empty($feedback)) {
$form['feedback'] = array(
'#markup' => '<span class="quiz_answer_feedback">' . $feedback . '</span>',
);
}
return $form;
}
public function getReportFormScore($showfeedback = TRUE, $showpoints = TRUE, $allow_scoring = FALSE) {
$score = $this
->isEvaluated() ? $this
->getScore() : '?';
if (quiz_access_to_score() && $allow_scoring) {
return array(
'#type' => 'textfield',
'#default_value' => $score,
'#size' => 3,
'#maxlength' => 3,
'#attributes' => array(
'class' => array(
'quiz-report-score',
),
),
);
}
else {
return array(
'#markup' => $score,
);
}
}
public function getReportFormAnswerFeedback($showpoints = TRUE, $showfeedback = TRUE, $allow_scoring = FALSE) {
if (quiz_access_to_score() && $allow_scoring) {
return array(
'#title' => t('Enter feedback'),
'#type' => 'textarea',
'#default_value' => $this->answer_feedback,
'#attributes' => array(
'class' => array(
'quiz-report-score',
),
),
);
}
return FALSE;
}
public function getReportFormSubmit($showfeedback = TRUE, $showpoints = TRUE, $allow_scoring = FALSE) {
return $allow_scoring ? 'long_answer_report_submit' : FALSE;
}
public function getReportFormValidate($showfeedback = TRUE, $showpoints = TRUE, $allow_scoring = FALSE) {
return $allow_scoring ? 'long_answer_report_validate' : FALSE;
}
}