function opigno_sort_groups_set_defaults in Opigno Class App 7

1 call to opigno_sort_groups_set_defaults()

opigno_sort_groups_install in opigno_sort_groups/opigno_sort_groups.install

Implements hook_install().

File

opigno_sort_groups/opigno_sort_groups.install, line 55

Opigno course quota app install file

Code

function opigno_sort_groups_set_defaults() {
  $courses = array();
  $query = db_select('node', 'n')
    ->fields('n')
    ->condition('type', "class", '=');
  $result = $query
    ->execute();
  while ($record = $result
    ->fetchAssoc()) {
    $ccourses = array();
    $query2 = db_select('field_data_opigno_class_courses', 'fdd')
      ->fields('fdd')
      ->condition('entity_id', $record['nid'], '=')
      ->condition('deleted', 0, '=');
    $result2 = $query2
      ->execute();
    while ($record2 = $result2
      ->fetchAssoc()) {
      $ccourses[$record2['opigno_class_courses_target_id']] = $record2['opigno_class_courses_target_id'];
    }
    foreach ($ccourses as $course) {
      db_insert('opigno_sort_groups')
        ->fields(array(
        'cgid' => $record['nid'],
        'gid' => $course,
        'weight' => 0,
      ))
        ->execute();
    }
    $courses += $ccourses;
  }
  $query = db_select('node', 'n')
    ->fields('n')
    ->condition('type', "course", '=');
  $result = $query
    ->execute();
  while ($record = $result
    ->fetchAssoc()) {
    if (!in_array($record['nid'], $courses)) {
      db_insert('opigno_sort_groups')
        ->fields(array(
        'gid' => $record['nid'],
        'weight' => 99,
      ))
        ->execute();
    }
  }
}