function opigno_in_house_training_app_get_all_iht in Opigno in house training app 7

2 calls to opigno_in_house_training_app_get_all_iht()

opigno_in_house_training_app_group_status in ./opigno_in_house_training_app.module

opigno_in_house_training_score_form in ./opigno_in_house_training_app.module

File

./opigno_in_house_training_app.module, line 413

Code

function opigno_in_house_training_app_get_all_iht($node_id) {
  $nodes = array();
  $query = db_select('node', 'n')
    ->fields('n', array(
    'nid',
    'title',
    'vid',
  ))
    ->condition('n.status', 1, '=')
    ->condition('n.type', 'in_house_training', '=');
  $query
    ->join('og_membership', 'og_m', 'og_m.etid = n.nid');

  //JOIN node with users
  $query
    ->fields('og_m', array(
    'gid',
  ))
    ->condition('og_m.gid', $node_id, '=')
    ->condition('og_m.field_name', 'og_group_ref', '=')
    ->condition('og_m.state', 1, '=')
    ->condition('og_m.entity_type', 'node', '=');
  $query
    ->join('field_data_opigno_calendar_date', 'fdcd', 'fdcd.entity_id = n.nid');

  //JOIN node with users
  $query
    ->fields('fdcd')
    ->condition('fdcd.deleted', 0, '=')
    ->condition('fdcd.bundle', 'in_house_training', '=');
  $query
    ->orderBy('fdcd.opigno_calendar_date_value', 'ASC');
  $query
    ->orderBy('n.nid', 'ASC');
  $result = $query
    ->execute();
  $total = 0;
  while ($record = $result
    ->fetchAssoc()) {
    if ($router_item = menu_get_item('node/' . $record['nid'])) {
      if ($router_item['access']) {
        $nodes[$node_id][$record['nid']] = $record['nid'];
      }
    }
  }
  return $nodes;
}