function opigno_class_app_classes_of_course_that_user_is_part_of in Opigno Class App 7

File

./opigno_class_app.module, line 367

Module hooks.

Code

function opigno_class_app_classes_of_course_that_user_is_part_of($course_nid, $user_id) {
  $classes = array();
  $query = db_select('field_data_opigno_class_courses', 'class_course');
  $query
    ->join('og_membership', 'ogm', 'ogm.gid = class_course.entity_id');
  $query
    ->fields('ogm', array(
    'gid',
  ));
  $query
    ->fields('class_course', array());
  $query
    ->groupBy('ogm.gid');
  $query
    ->condition('ogm.entity_type', 'user', '=');
  $query
    ->condition('ogm.state', 1, '=');
  $query
    ->condition('ogm.etid', $user_id, '=');
  $query
    ->condition('class_course.deleted', 0, '=');
  $query
    ->condition('class_course.opigno_class_courses_target_id', $course_nid, '=');
  $result = $query
    ->execute();
  while ($record = $result
    ->fetchAssoc()) {
    $classes[$record['gid']] = $record['gid'];
  }
  return $classes;
}