public function executeRequests(sfWebRequest $request)
{
# arrived requests
$this->mission_requests = MissionRequestPeer::getRsNonProcessed($count);
$this->mission_requests_count = $count;
# available missions
$this->available_mission_legs = MissionLegPeer::getRsAvailable($count);
$this->available_mission_legs_count = $count;
# coordinated missions
$this->coordinated_mission_legs = MissionLegPeer::getRsCoordinated($count);
$this->coordinated_mission_legs_count = $count;
# pilot requests
# filter
$this->processFilter($request);
$this->pager = PilotRequestPeer::getPager($this->max, $this->page, $this->req_date1, $this->req_date2, $this->miss_date1, $this->miss_date2, $this->not_process, $this->hold, $this->process);
$this->pilot_reqs = $this->pager->getResults();
$this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text'));
# member requests
$c = new Criteria();
$c->add(ApplicationTempPeer::RENEWAL, null, Criteria::ISNULL);
$c->add(ApplicationTempPeer::MEMBER_ID, null, Criteria::ISNULL);
$c->add(ApplicationTempPeer::PROCESSED_DATE, null, Criteria::ISNULL);
$c->setLimit(50);
$this->member_requests = ApplicationTempPeer::doSelect($c);
$this->transportations = array('air_mission' => 'Air Mission', 'ground_mission' => 'Ground Mission', 'commercial_mission' => 'Commercial Mission');
if ($request->hasParameter('return')) {
$this->pilot_request_one = true;
}
}