public function MultichoiceResponse::delete in Quiz 8.4

Implementation of delete

Overrides QuizQuestionResponse::delete

See also

QuizQuestionResponse#delete()

File

question_types/multichoice/lib/Drupal/multichoice/MultichoiceResponse.php, line 101

Class

MultichoiceResponse

Extension of QuizQuestionResponse

Namespace

Drupal\multichoice

Code

public function delete() {
  $user_answer_id = array();
  $query = db_query('SELECT id FROM {quiz_multichoice_user_answers} WHERE question_nid = :nid AND question_vid = :vid AND result_id = :result_id', array(
    ':nid' => $this->question
      ->id(),
    ':vid' => $this->question
      ->getRevisionId(),
    ':result_id' => $this->rid,
  ));
  while ($user_answer = $query
    ->fetch()) {
    $user_answer_id[] = $user_answer->id;
  }
  if (!empty($user_answer_id)) {
    db_delete('quiz_multichoice_user_answer_multi')
      ->condition('user_answer_id', $user_answer_id, 'IN')
      ->execute();
  }
  db_delete('quiz_multichoice_user_answers')
    ->condition('result_id', $this->rid)
    ->condition('question_nid', $this->question
    ->id())
    ->condition('question_vid', $this->question
    ->getRevisionId())
    ->execute();
}