public static function LongAnswerResponse::fetchUnscoredAnswersByQuestion in Quiz 8.4

Given a quiz, return a list of all of the unscored answers.

Parameters

$nid: Node ID for the quiz to check.

$vid: Version ID for the quiz to check.

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

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

Return value

Indexed array of result IDs that need to be scored.

File

question_types/long_answer/lib/Drupal/long_answer/LongAnswerResponse.php, line 69

Class

LongAnswerResponse

Extension of QuizQuestionResponse

Namespace

Drupal\long_answer

Code

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;
}