File

classes/_DatabaseHandler.php, line 1150

Class

_DatabaseHandler

Code

function get_group_id($group_name, $catalog_year) {

  if ($catalog_year < $GLOBALS ["fp_system_settings"]["earliest_catalog_year"]) 
   {
    $catalog_year = $GLOBALS ["fp_system_settings"]["earliest_catalog_year"];
  }


  // If it's already in our static cache, just return that.
  static $group_id_cache = array();
  if (isset($group_id_cache [$group_name][$catalog_year])) {
    return $group_id_cache [$group_name][$catalog_year];
  }



  $res7 = $this->db_query("SELECT group_id FROM groups
              WHERE group_name = ?
              AND catalog_year = ?
              AND delete_flag = 0
               LIMIT 1 ", $group_name, $catalog_year);
  if ($this->db_num_rows($res7) > 0) 
   {
    $cur7 = $this->db_fetch_array($res7);

    // Save to our cache
    $group_id_cache [$group_name][$catalog_year] = $cur7 ['group_id'];
    return $cur7 ['group_id'];
  }
  return false;
}