function oa_sections_get_icons in Open Atrium Core 7.2

Return array of icon/images keyed by section type tid

File

modules/oa_sections/oa_sections.module, line 324

Code

function oa_sections_get_icons() {
  $vid = oa_core_taxonomy_vocabulary('section_type')->vid;
  $terms = taxonomy_get_tree($vid);
  $query = db_select('taxonomy_term_data', 't');
  $query
    ->leftJoin('field_data_field_oa_icon_class', 'ic', "ic.entity_id = t.tid");
  $query
    ->leftJoin('field_data_field_oa_icon_image', 'im', "im.entity_id = t.tid");
  $query
    ->fields('t', array(
    'tid',
  ))
    ->fields('ic', array(
    'field_oa_icon_class_value',
  ))
    ->fields('im', array(
    'field_oa_icon_image_fid',
  ))
    ->condition('t.vid', $vid);
  $result = $query
    ->execute()
    ->fetchAllAssoc('tid');
  return $result;
}