function opigno_statistics_app_query_class_child_nids in Opigno Statistics App 7

Get all the node IDs that are in the class (course IDs, lessons IDs of each courses of the class, etc)

3 calls to opigno_statistics_app_query_class_child_nids()

opigno_statistics_app_query_class_number_of_interactions in includes/group/class/queries.inc

Query total number of interaction for a class (cached for 1 day)

opigno_statistics_app_query_class_students_results in includes/group/class/queries.inc

Query students results statistics for a class (cached for 1 day)

opigno_statistics_app_query_class_total_number_of_page_view in includes/group/class/queries.inc

Query total number of page view for a class (cached for 1 day)

File

includes/group/class/queries.inc, line 316

Code

function opigno_statistics_app_query_class_child_nids($class_nid) {
  $all_nids_query = db_query("\n      SELECT etid, gid\n      FROM {field_data_opigno_class_courses} occ\n      INNER JOIN og_membership ogm ON occ.opigno_class_courses_target_id = ogm.gid\n      WHERE occ.entity_id = :class_id AND ogm.entity_type = 'node'\n    ", array(
    ':class_id' => $class_nid,
  ));
  $all_nids = array();
  while ($row = $all_nids_query
    ->fetchAssoc()) {
    $all_nids[] = $row['etid'];
    $all_nids[] = $row['gid'];
  }
  return array_unique($all_nids);
}