function opigno_assessment_get_quizzes in Opigno 7.0

1 call to opigno_assessment_get_quizzes()

opigno_assessment_form_course_node_form_alter in modules/opigno_assessment/opigno_assessment.module

Implements hook_form_course_node_form_alter()

File

modules/opigno_assessment/opigno_assessment.module, line 242

Contains all hook_implementations and module specific API.

Code

function opigno_assessment_get_quizzes($og_node) {
  $nodes = array();
  if (isset($og_node->nid)) {
    $query = db_select('node', 'n');
    $query
      ->leftJoin('node_revision', 'v', 'v.vid = n.vid');
    $query
      ->leftJoin('og_membership', 'om', 'om.etid = n.nid');
    $query
      ->leftJoin('og', 'o', 'o.gid = om.gid');
    $result = $query
      ->fields('n', array(
      'nid',
    ))
      ->fields('v', array(
      'title',
    ))
      ->condition('n.type', 'quiz')
      ->condition('om.state', 1)
      ->condition('o.entity_type', 'node')
      ->condition('o.etid', $og_node->nid)
      ->execute();
    while ($node = $result
      ->fetchObject()) {
      $nodes[$node->nid] = $node->title;
    }
  }
  return $nodes;
}