public function ScormActivityAnswer::getAnswerResultItemData in Opigno module 3.x

Same name and namespace in other branches

1. 8 ActivityTypes/opigno_scorm_activity/src/Plugin/ActivityAnswer/ScormActivityAnswer.php \Drupal\opigno_scorm_activity\Plugin\ActivityAnswer\ScormActivityAnswer::getAnswerResultItemData()

Returns answer result data.

File

ActivityTypes/opigno_scorm_activity/src/Plugin/ActivityAnswer/ScormActivityAnswer.php, line 117

Class

ScormActivityAnswer

Class ScormActivityAnswer.

Namespace

Drupal\opigno_scorm_activity\Plugin\ActivityAnswer

Code

public function getAnswerResultItemData(OpignoAnswerInterface $answer) {
  $db_connection = \Drupal::service('database');
  $interactions = $db_connection
    ->select('opigno_scorm_user_answer_results', 'osur')
    ->fields('osur')
    ->condition('answer_id', $answer
    ->id())
    ->condition('answer_vid', $answer
    ->getLoadedRevisionId())
    ->orderBy('id', 'ASC')
    ->execute()
    ->fetchAll();
  if ($interactions) {
    return $interactions;
  }
  return FALSE;
}