public static function LongAnswerResponse::fetchAllUnscoredAnswers in Quiz 7.4

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 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.

2 calls to LongAnswerResponse::fetchAllUnscoredAnswers()

long_answer_get_all_unscored_answers in question_types/long_answer/long_answer.module

Get all quiz scores that have not yet been evaluated.

long_answer_view_unscored in question_types/long_answer/long_answer.admin.inc

Generate a view of all unscored answer questions.

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) {
  global $user;
  $query = db_select('quiz_long_answer_user_answers', 'a');
  $query
    ->fields('a', array(
    'result_id',
    'question_nid',
    'question_vid',
    'answer_feedback',
    'answer_feedback_format',
  ));
  $query
    ->fields('r', array(
    'title',
  ));
  $query
    ->fields('qnr', array(
    'time_end',
    'time_start',
    'uid',
  ));
  $query
    ->join('node_revision', 'r', 'a.question_vid = r.vid');
  $query
    ->join('quiz_node_results', 'qnr', 'a.result_id = qnr.result_id');
  $query
    ->join('node', 'n', 'qnr.nid = n.nid');
  $query
    ->condition('a.is_evaluated', 0);
  if (user_access('score own quiz') && user_access('score taken quiz answer')) {
    $query
      ->condition(db_or()
      ->condition('n.uid', $user->uid)
      ->condition('qnr.uid', $user->uid));
  }
  else {
    if (user_access('score own quiz')) {
      $query
        ->condition('n.uid', $user->uid);
    }
    else {
      if (user_access('score taken quiz answer')) {
        $query
          ->condition('qnr.uid', $user->uid);
      }
    }
  }
  $results = $query
    ->execute();
  $unscored = array();
  foreach ($results as $row) {
    $unscored[] = $row;
  }
  return $unscored;
}