function getNearestProvider($lat, $lng, &$distance)
 {
     $provider = null;
     $rs = $this->db->getResultset("SELECT \t id, distance_km(latitude,longitude," . Database::SqlNumeric($lat) . "," . Database::SqlNumeric($lng) . ") AS distance_km\n                                       FROM \t provider\n                                       WHERE     partner_code = 'TREAT'\n                                       AND       active = 'T'\n                                       ORDER BY  distance_km ASC\n                                       LIMIT \t 1");
     if (count($rs) > 0) {
         $provider = new Provider($rs[0]['id']);
         $distance = $rs[0]['distance_km'];
     }
     return $provider;
 }