function opigno_class_app_courses_of_class_that_user_is_part_of in Opigno Class App 7

1 call to opigno_class_app_courses_of_class_that_user_is_part_of()

opigno_class_app_views_query_alter in ./opigno_class_app.module

Implements hook_views_query_alter().

File

./opigno_class_app.module, line 386

Module hooks.

Code

function opigno_class_app_courses_of_class_that_user_is_part_of($class) {
  $courses = array();
  $query = db_select('field_data_opigno_class_courses', 'class_course');
  $query
    ->fields('class_course', array(
    'opigno_class_courses_target_id',
  ));
  $query
    ->condition('class_course.deleted', 0, '=');
  $query
    ->condition('class_course.bundle', 'class', '=');
  $query
    ->condition('class_course.entity_id', $class, '=');
  $result = $query
    ->execute();
  while ($record = $result
    ->fetchAssoc()) {
    $courses[$record['opigno_class_courses_target_id']] = $record['opigno_class_courses_target_id'];
  }
  return $courses;
}