/** * Mission filter results * CODE:mission_type_index */ public function executeForm(sfWebRequest $request) { if ($request->getParameter('member_id')) { $member_id = $request->getParameter('member_id'); } $orgin = $request->getParameter('f_orgin', ''); $dest = $request->getParameter('f_dest', ''); $airport_id = $request->getParameter('primary_airportID', 0); $date_range1 = $request->getParameter('f_date_range1', ''); $date_range2 = $request->getParameter('f_date_range2', ''); $filled = $request->getParameter('f_filled', ''); $open = $request->getParameter('f_open', ''); //needs by $pilot = $request->getParameter('f_pilot', ''); $mission_assistant = $request->getParameter('f_ma', ''); $ifr_backup = $request->getParameter('f_ifr', ''); if ($request->getParameter('f_alltype')) { $all_type = $request->getParameter('f_alltype', ''); } else { $all_type = ''; } //days $day_1 = $request->getParameter('f_day_1', ''); $day_2 = $request->getParameter('f_day_2', ''); $day_3 = $request->getParameter('f_day_3', ''); $day_4 = $request->getParameter('f_day_4', ''); $day_5 = $request->getParameter('f_day_5', ''); $day_6 = $request->getParameter('f_day_6', ''); $day_7 = $request->getParameter('f_day_7', ''); $max_pass = $request->getParameter('f_maxpass', 0); $max_wei = $request->getParameter('f_maxwei', 0); $max_dist = $request->getParameter('f_maxdist', 0); $max_eff = $request->getParameter('f_maxeff ', 0); //only accept values 1-100 $location_type = $request->getParameter('location_type', ''); $wing = ''; $ident = ''; $city = ''; $state = ''; $zip = ''; if ($location_type == 1) { $wing = $request->getParameter('f_wing', ''); } elseif ($location_type == 2) { $ident = $request->getParameter('f_ident', ''); } elseif ($location_type == 3) { $city = $request->getParameter('f_city', ''); $state = $request->getParameter('f_state', ''); $zip = $request->getParameter('f_zipcode', ''); } if ($request->getParameter('is_a_check')) { $is_check = $request->getParameter('is_a_check', ''); } else { $is_check = ''; } $unset_availability = $request->getParameter('unset_availability', ''); $set_availability = $request->getParameter('set_availability', ''); $availability = $request->getParameter('available', ''); $store = $request->getParameter('store', ''); $first_date = ''; $last_date = ''; $not_available = ''; $no_weekday = ''; $no_weekend = ''; $as_ma = ''; if ($is_check == '') { if ($request->getParameter('first_date')) { $first_date = $request->getParameter('first_date', ''); } if ($request->getParameter('last_date')) { $last_date = $request->getParameter('last_date', ''); } if ($request->getParameter('not_av')) { $not_available = $request->getParameter('not_av', ''); } if ($request->getParameter('no_weekday')) { $no_weekday = $request->getParameter('no_weekday', ''); } if ($request->getParameter('no_weekend')) { $no_weekend = $request->getParameter('no_weekend', ''); } if ($request->getParameter('as_ma')) { $as_ma = $request->getParameter('as_ma', ''); } } $sort_by = $request->getParameter('sort_by'); $this->mission_legs = MissionLegPeer::getByFilterCamp($max = 10, $page = 1, $sort_by, $availability, $first_date, $last_date, $not_available, $no_weekday, $no_weekend, $as_ma, $orgin, $dest, $airport_id, $date_range1, $date_range2, $filled, $open, $pilot, $mission_assistant, $ifr_backup, $wing, $ident, $city, $state, $zip, $day_1, $day_2, $day_3, $day_4, $day_5, $day_6, $day_7, $all_type, $max_pass, $max_wei, $max_dist, $max_eff); #get the Pilot's nearest Mission Legs with camps $this->missions = array(); $this->camps = array(); $count = 0; foreach ($this->mission_legs as $leg) { if ($leg->getToAirportId()) { $this->destination_airport = $leg->getToAirportId(); } $this->missions[$count] = MissionPeer::retrieveByPK($leg->getMissionId()); $this->camps[$count] = CampPeer::retrieveByPK(MissionPeer::retrieveByPK($leg->getMissionId())->getCampId()); $count++; } }