public static function LongAnswerResponse::fetchAllUnscoredAnswers in Quiz 7

Same name and namespace in other branches

1. 6.6 question_types/long_answer/long_answer.classes.inc \LongAnswerResponse::fetchAllUnscoredAnswers()
2. 6.3 question_types/long_answer/long_answer.classes.inc \LongAnswerResponse::fetchAllUnscoredAnswers()
3. 6.4 question_types/long_answer/long_answer.classes.inc \LongAnswerResponse::fetchAllUnscoredAnswers()
4. 6.5 question_types/long_answer/long_answer.classes.inc \LongAnswerResponse::fetchAllUnscoredAnswers()
5. 7.6 question_types/long_answer/long_answer.classes.inc \LongAnswerResponse::fetchAllUnscoredAnswers()
6. 7.4 question_types/long_answer/long_answer.classes.inc \LongAnswerResponse::fetchAllUnscoredAnswers()

Get all scores that have not yet been evaluated.

Parameters

$count: Number of items to return (default: 50).

$offset: Where in the results we should start (default: 0).

Return value

Array of objects describing unanswered questions. Each object will have result_id, question_nid, and question_vid.

File

question_types/long_answer/long_answer.classes.inc, line 190

Long answer classes.

Class

LongAnswerResponse

Extension of QuizQuestionResponse

Code

public static function fetchAllUnscoredAnswers($count = 50, $offset = 0) {
  $results = db_query('SELECT a.result_id, a.question_nid, a.question_vid, r.title, n.time_end, n.time_start, n.uid
      FROM {quiz_long_answer_user_answers} AS a
      INNER JOIN {node_revision} AS r ON a.question_vid = r.vid
      INNER JOIN {quiz_node_results} AS qnr ON a.result_id = qnr.result_id
      JOIN {node} n ON qnr.nid = n.nid
      WHERE a.is_evaluated = :is_evaluated', array(
    ':is_evaluated' => 0,
  ));
  $unscored = array();
  foreach ($results as $row) {
    $unscored[] = $row;
  }
  return $unscored;
}