/**
* @param string $myzip
* @param int $miles
* @return array v6_databaselist->the_list
*/
function ZipsWithinMiles($myzip, $miles)
{
// first find out my lat/lon
$this->my_zip_record->load_by_secondary_key('zip_code', $myzip);
$ziplist = new v6_database_list($this->zip_radius_table_name);
$where = sprintf("(SQRT((69.172*(%f-zip_radius_table_name.latitude))*(69.172*(%f-zip_radius_table_name.latitude))+(53.0*(%f-zip_radius_table_name.longitude))*(53.0*(%f-zip_radius_table_name.longitude)))<=%f)", $this->my_zip_record->latitude, $this->my_zip_record->latitude, $this->my_zip_record->longitude, $this->my_zip_record->longitude, $miles);
$where = str_replace('zip_radius_table_name', $this->zip_radius_table_name, $where);
$ziplist->load_by_custom_where($where);
return $ziplist->the_list;
}
public function PrivilegeId($privilege_id_descrip)
{
if (is_string($privilege_id_descrip) == true) {
$privilege = new v6_table('privileges');
$privilege->load_by_secondary_key('descrip', $privilege_id_descrip);
$result = $privilege->id;
} else {
// otherwise it's really an int not a string so return the int without looking it up from a string
$result = $privilege_id_descrip;
}
return $result;
}
