/** * @return Pilot */ public function getCoPilot() { if (0 == (int) $this->getCopilotId()) { return null; } $c = new Criteria(); $c->add(PilotPeer::ID, $this->getCopilotId()); return PilotPeer::doSelectOne($c); }
public function executeIndex(sfWebRequest $request) { $this->person = PersonPeer::retrieveByPK($this->getUser()->getId()); if ($pilot_id = $this->getUser()->getPilotId()) { $this->pilot = PilotPeer::retrieveByPK($pilot_id); } else { $this->pilot = null; } if ($member_id = $this->getUser()->getMemberId()) { $this->member = MemberPeer::retrieveByPK($member_id); // Farazi Renewal date calculation $date_now = strtotime("NOW"); $date_ren = strtotime($this->member->getRenewalDate()); $sub = $date_ren - $date_now; $preday = 0; if ($sub >= 86400) { $pday = $sub / 86400; $preday = explode('.', $pday); } else { $pday = $sub / 86400; $preday = explode('.', $pday); } $this->due_day = $preday[0]; //End Farazi Renewal date calculation } else { $this->member = null; } if ($this->member !== null && $this->pilot !== null) { $this->availability = $this->member->getAvailability(); } if (!$this->availability instanceof Availability) { $this->availability = new Availability(); } $this->email_lists = EmailListPeer::doSelect(new Criteria()); $this->subscribed_list = EmailListPersonPeer::getEmailListIdsByPersonId($this->person->getId()); }
<?php } ?> <?php } ?> <?php } ?> </td> <td class="cell-1"> <?php if ($mission_leg->getMissAssisId()) { ?> <?php $cpilot = PilotPeer::getByMemberId($mission_leg->getMissAssisId()); ?> <?php if (isset($cpilot)) { ?> <?php $cmember = MemberPeer::retrieveByPK($cpilot->getMemberId()); ?> <?php if (isset($cmember)) { ?> <?php $cperson = PersonPeer::retrieveByPK($cmember->getPersonId()); ?> <?php if (isset($cperson)) {
<tr> <td colspan="4"><?php echo $message; ?> </td> </tr> <?php } ?> <?php $pilot_req = PilotRequestPeer::retrieveByPK($pilot_req_id); #get passengers assigned to this pilot date if (isset($pilot_req) && $pilot_req instanceof PilotRequest) { if ($pilot_req->getGroupCampId()) { $camp_id = $pilot_req->getGroupCampId(); $pilot = PilotPeer::getByMemberId($pilot_req->getMemberId()); #get Missions which has selected Camp if (isset($camp_id) && $pilot) { // $camp_pilot_passengers = CampPilotPassengerPeer::getByCampPilot($camp_id, $pilot_req->getMemberId()); // foreach ($camp_pilot_passengers as $cpp){ $passengers = array(); $missions = MissionPeer::getByCampId($camp_id); foreach ($missions as $miss) { $legs = MissionLegPeer::getbyMissId($miss->getId()); if (isset($legs) && $legs[0]->getPilotId() == $pilot->getId() && $miss->getMissionDate('Ymd') == $flight_date) { $passengers[$miss->getPassengerId()] = $miss; } } foreach ($passengers as $cpp) { $pass = $cpp->getPassenger(); if ($pass) {
if ($mission_legs) { $index = 0; $totabaggage = 0; foreach ($mission_legs as $mleg) { $totabaggage += $mleg->getBaggageWeight(); if ($mleg->getPilotId()) { $pilot_info = PilotPeer::retrieveByPK($mleg->getPilotId()); $pilot_person = $pilot_info->getMember()->getPerson(); $pilot_aircrafts = PilotAircraftPeer::getByMemberId($pilot_info->getMember()->getId()); } if ($mleg->getMissAssisId()) { $memberMiss = MemberPeer::retrieveByPK($mleg->getMissAssisId()); $miss_assi_persopn = $memberMiss->getPerson(); } if ($mleg->getBackupPilotId()) { $backup_pilot_info = PilotPeer::retrieveByPK($mleg->getPilotId()); $backupPilot_person = $backup_pilot_info->getMember()->getPerson(); } if ($mleg->getCoordinatorId()) { $coordinator = CoordinatorPeer::retrieveByPK($mleg->getCoordinatorId()); if ($coordinator->getMemberId()) { $coordiPerson = $coordinator->getMember()->getPerson(); } } if ($mleg->getMissAssisId()) { $memberMiss = MemberPeer::retrieveByPK($mleg->getMissAssisId()); $miss_assi_persopn = $memberMiss->getPerson(); } if ($mleg->getMissAssisId()) { $memberMiss = MemberPeer::retrieveByPK($mleg->getMissAssisId()); $miss_assi_persopn = $memberMiss->getPerson();
/** * Fills steps other than step1 * @param ApplicationTemp $app */ private function fillStepsRemaining(ApplicationTemp $app) { $app->setRenewal(1); $app->setPersonId($this->getUser()->getId()); $app->setPremiumChoice(1); $app->setPremiumSize(0); $member = MemberPeer::retrieveByPK($this->getUser()->getMemberId()); if ($member) { $app->setMemberId($member->getId()); $v = explode(' ', $member->getSpouseName()); $app->setSpouseFirstName((string) $v[0]); $app->setSpouseLastName((string) $v[1]); $app->setEmergencyContactName($member->getEmergencyContactName()); $app->setEmergencyContactPhone($member->getEmergencyContactPhone()); $app->setApplicantCopilot($member->getCoPilot()); $app->setLanguagesSpoken($member->getLanguages()); $app->setDateOfBirth($member->getDateOfBirth()); $app->setDriversLicenseNumber($member->getDriversLicenseNumber()); $app->setDriversLicenseState($member->getDriversLicenseState()); $app->setWeight($member->getWeight()); $app->setWingId($member->getWingId()); $app->setMemberClassId($member->getMemberClassId()); $pilot = PilotPeer::retrieveByPK($this->getUser()->getPilotId()); if ($pilot) { $airport = $pilot->getAirport(); $app->setHomeBase($airport->getIdent()); $v = array(); foreach ($airport->getFbos() as $fbo) { $v[] = $fbo->getName(); } $app->setFboName(implode(', ', $v)); $v = array(); if ($pilot->getIfr()) { $v[] = 'IFR'; } if ($pilot->getMultiEngine()) { $v[] = 'multi'; } if ($pilot->getOtherRatings()) { $v[] = 'other'; } if ($pilot->getSeInstructor()) { $v[] = $pilot->getSeInstructor(); } if ($pilot->getSeInstructor()) { $v[] = $pilot->getMeInstructor(); } if ($pilot->getLicenseType()) { $v[] = $pilot->getLicenseType(); } $app->setRatings(implode(', ', $v)); $app->setTotalHours($pilot->getTotalHours()); } $availability = $member->getAvailability(); if ($availability) { $app->setAvailabilityWeekdays($availability->getNoWeekday() ? 0 : 1); $app->setAvailabilityWeeknights($availability->getNoNight() ? 0 : 1); $app->setAvailabilityWeekends($availability->getNoWeekend() ? 0 : 1); $app->setAvailabilityLastMinute($availability->getLastMinute()); $app->setAvailabilityCopilot($availability->getAsMissionMssistant()); } $pilot_aircrafts = $member->getPilotAircrafts(); /* @var $p_a PilotAircraft */ if (isset($pilot_aircrafts[0])) { $p_a = $pilot_aircrafts[0]; $app->setAircraftPrimaryId($p_a->getAircraftId()); $app->setAircraftPrimaryOwn($p_a->getOwn()); $app->setAircraftPrimarySeats($p_a->getSeats()); $app->setAircraftPrimaryIce($p_a->getKnownIce()); $app->setAircraftPrimaryNNumber($p_a->getNNumber()); } if (isset($pilot_aircrafts[1])) { $p_a = $pilot_aircrafts[1]; $app->setAircraftSecondaryId($p_a->getAircraftId()); $app->setAircraftSecondaryOwn($p_a->getOwn()); $app->setAircraftSecondarySeats($p_a->getSeats()); $app->setAircraftSecondaryIce($p_a->getKnownIce()); $app->setAircraftSecondaryNNumber($p_a->getNNumber()); } if (isset($pilot_aircrafts[2])) { $p_a = $pilot_aircrafts[2]; $app->setAircraftThirdId($p_a->getAircraftId()); $app->setAircraftThirdOwn($p_a->getOwn()); $app->setAircraftThirdSeats($p_a->getSeats()); $app->setAircraftThirdIce($p_a->getKnownIce()); $app->setAircraftThirdNNumber($p_a->getNNumber()); } $application = $member->getLastApplication(); if ($application) { $app->setPremiumChoice($application->getPremiumChoice()); $app->setMissionOrientation($application->getMissionOrientation()); $app->setMissionCoordination($application->getMissionCoordination()); $app->setPilotRecruitment($application->getPilotRecruitment()); $app->setFundRaising($application->getFundRaising()); $app->setCelebrityContacts($application->getCelebrityContacts()); $app->setGraphicArts($application->getGraphicArts()); $app->setHospitalOutreach($application->getHospitalOutreach()); $app->setEventPlanning($application->getEventPlanning()); $app->setMediaRelations($application->getMediaRelations()); $app->setTelephoneWork($application->getTelephoneWork()); $app->setComputers($application->getComputers()); $app->setClerical($application->getClerical()); $app->setPrinting($application->getPrinting()); $app->setWriting($application->getWriting()); $app->setSpeakersBureau($application->getSpeakersBureau()); $app->setWingTeam($application->getWingTeam()); $app->setWebInternet($application->getWebInternet()); $app->setFoundationContacts($application->getFoundationContacts()); $app->setAviationContacts($application->getAviationContacts()); $app->setMemberAopa($application->getMemberAopa()); $app->setMemberKiwanis($application->getMemberKiwanis()); $app->setMemberRotary($application->getMemberRotary()); $app->setMemberLions($application->getMemberLions()); $app->setMember99s($application->getMember99s()); $app->setMemberWia($application->getMemberWia()); $app->setCompanyName($application->getCompany()); $app->setCompanyPosition($application->getCompanyPosition()); $app->setCompanyMatchFunds($application->getCompanyMatchFunds()); $app->setHeight($application->getHeight()); $app->setPilotCertificate($application->getPilotCertificate()); $app->setMedicalClass($application->getMedicalClass()); } } }
<?php } ?> <?php } ?> <?php } ?> </td> <td class="cell-1"> <?php if ($mission_leg->getCoPilotId()) { ?> <?php $cpilot = PilotPeer::retrieveByPK($mission_leg->getPilotId()); ?> <?php if (isset($cpilot)) { ?> <?php $cmember = MemberPeer::retrieveByPK($cpilot->getMemberId()); ?> <?php if (isset($cmember)) { ?> <?php $cperson = PersonPeer::retrieveByPK($cmember->getPersonId()); ?> <?php if (isset($cperson)) {
<th class="aa">Pilot</th> <th class="aa">Aircraft</th> <th class="aa">Home Base</th> <th class="aa">Seats</th> <th class="aa">Weights</th> <th class="aa">Multiple Stops?</th> <th class="aa">Comments</th> </tr> </thead> <tbody> <?php foreach ($requests_of_this_date as $rq) { $member_id = $rq->getMemberId(); $pilot_req = PilotRequestPeer::retrieveByPK($rq->getPilotRequestId()); $pilot = PilotPeer::getByMemberId($member_id); if (isset($pilot) && $pilot instanceof Pilot) { $person = $pilot->getMember()->getPerson(); $pilot_aircraft = PilotAircraftPeer::getPrimary($member_id); #pilot's aircraft if (isset($pilot_aircraft) && $pilot_aircraft instanceof PilotAircraft) { $aircraft = $pilot_aircraft->getAircraft(); } } ?> <?php if (isset($pilot) && $pilot instanceof Pilot) { ?> <tr> <td class="aa"><?php if (isset($person) && $person instanceof Person) {
public function executePilotSignupEventDetail(sfWebRequest $request) { $pilot_id = $this->getUser()->getPilotId(); $pilot = PilotPeer::retrieveByPK($pilot_id); $member_id = $pilot->getMemberId(); $this->processFilterNew($request); $this->pager = EventPeer::getsignupPager($this->max, $this->page, $member_id); $this->events = $this->pager->getResults(); $this->total = $this->pager->getNbResults(); }
public static function getNotInPilot() { $c = new Criteria(); $pliots = PilotPeer::doSelect($c); if ($pliots) { foreach ($pliots as $pliot) { $c->addJoin(self::ID, PilotPeer::MEMBER_ID, Criteria::LEFT_JOIN); $c->addJoin(self::PERSON_ID, PersonPeer::ID); $c->add(PilotPeer::MEMBER_ID, null, Criteria::ISNULL); $not_in_pilot_persons = PersonPeer::doSelect($c); } } else { $not_in_pilot_persons = PersonPeer::doSelect($c); } $arr = array(); $arr[0] = '-- select --'; foreach ($not_in_pilot_persons as $not_in_pilot_person) { $arr[$not_in_pilot_person->getId()] = $not_in_pilot_person->getLastName(); } return $arr; }
public function executePrintMissionLeg(sfWebRequest $request) { #Security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Coordinator'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } if ($request->getParameter('id')) { $this->leg = MissionLegPeer::retrieveByPK($request->getParameter('id')); if (isset($this->leg)) { $this->mission = MissionPeer::retrieveByPK($this->leg->getMissionId()); $this->requester = RequesterPeer::retrieveByPK($this->mission->getRequesterId()); $this->req_person = $this->requester->getPerson(); $this->agency = $this->requester->getAgency(); // Camp information if ($this->mission->getCampId()) { $this->camp = CampPeer::retrieveByPK($this->mission->getCampId()); } //Coordinator if ($this->mission->getCoordinatorId()) { $this->coordinator = CoordinatorPeer::retrieveByPK($this->mission->getCoordinatorId()); $this->coordiPerson = PersonPeer::retrieveByPK($this->coordinator->getMember()->getPersonId()); } if (isset($this->mission)) { $this->itinerary = ItineraryPeer::retrieveByPK($this->mission->getItineraryId()); $pass = PassengerPeer::retrieveByPK($this->mission->getPassengerId()); //Companions information $this->companions = CompanionPeer::getByPassId($this->mission->getPassengerId()); if (isset($pass) && $pass instanceof Passenger) { $this->pass = $pass; //print_r($this->pass); //die(); $this->person = PersonPeer::retrieveByPK($pass->getPersonId()); $this->itinerary = $this->mission->getItinerary(); // Pre-define addresses for ground missions $this->ground_addresses = array('patient' => '', 'facility' => '', 'lodging' => '', 'airport' => ''); $this->ground_addr_sel = sfConfig::get('app_ground_address_type', array()); if ($this->itinerary) { //$this->ground_addresses['lodging'] = $this->ground_addresses['facility'] = $this->itinerary->getDestCity().', '.$this->itinerary->getDestState(); } } else { unset($this->passenger); } } } if (isset($this->leg) && $this->leg instanceof MissionLeg) { if ($this->leg->getPilotId()) { $this->pilot = PilotPeer::retrieveByPK($this->leg->getPilotId()); $this->pilot_member = MemberPeer::retrieveByPK($this->pilot->getMemberId()); $this->copilot = PilotPeer::retrieveByPK($this->leg->getCoPilotId()); $this->mission_assistant = PilotPeer::getByMemberId($this->leg->getMissAssisId()); $this->back_up_mission_assistant = PilotPeer::retrieveByPK($this->leg->getBackupMissAssisId()); } } if ($this->getUser()->hasAttribute('pilotAddToLegview')) { $this->getUser()->setFlash("success", 'Pilot is added to this mission leg successfully !'); $this->getUser()->getAttributeHolder()->remove('pilotAddToLegview'); } } }
public function executeDeactive(sfWebRequest $request) { $pilot = PilotPeer::retrieveByPK($request->getParameter('id')); $pilot->setMopActiveStatus(0); $pilot->save(); return sfView::NONE; }
/** * Save Accept Pilot Request * CODE:pilot_request_on_accept */ public function executeAccept(sfWebRequest $request) { #security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Pilot', 'Coordinator', 'Volunteer'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } $this->setTemplate(false); if ($request->getParameter('id')) { $req = PilotRequestPeer::retrieveByPK($request->getParameter('id')); if (isset($req) && $req instanceof PilotRequest) { if ($req->getAccepted() == 1) { $req->setAccepted(0); $req->setProcessed(1); $req->setOnHold(0); } else { $req->setAccepted(1); $req->setProcessed(1); $member_id = $req->getMemberId(); $leg_id = $req->getLegId(); $mission_leg = MissionLegPeer::retrieveByPK($leg_id); $leg_number = $mission_leg->getLegNumber(); $mission_id = $mission_leg->getMissionId(); /// Send Command Pilot Email if ($member_id) { $member = MemberPeer::retrieveByPK($member_id); $person_id = $member->getPersonId(); $externalID = $member->getExternalId(); $person = PersonPeer::retrieveByPK($person_id); $frist_name = $person->getFirstName(); $last_name = $person->getLastName(); $name = $frist_name . ' ' . $last_name; $email = $person->getEmail(); if ($person->getEmail()) { $pilot_type = "Command Pilot"; # send email requested pilot $this->getComponent('mail', 'pilotRequestAccepted', array('email' => $email, 'name' => $name, 'externalID' => $externalID, 'pilot_type' => $pilot_type, 'leg_number' => $leg_number)); } } $req->save(); /// Accepted and Send Mission Assistand Email if pilot want mission assitand $miss_assis_id = $req->getMissAssisId(); if ($miss_assis_id) { $member = MemberPeer::retrieveByPK($req->getMissAssisId()); $externalID = $member->getExternalId(); $person = PersonPeer::retrieveByPK($member->getPersonId()); $frist_name = $person->getFirstName(); $last_name = $person->getLastName(); $name = $frist_name . ' ' . $last_name; $email = $person->getEmail(); // Accept Mission Assistant $pilot_request = PilotRequestPeer::getPilotRequestByMemberId($req->getMissAssisId(), $leg_id); if ($pilot_request instanceof PilotRequest) { $pilot_request->setAccepted(1); $pilot_request->setProcessed(1); $pilot_request->save(); } else { return $this->renderText("not saved"); } //return $this->renderText('Pilot Request: '.$pilot_request->getId()); if ($person->getEmail()) { $pilot_type = "Mission Assistant"; # send email requested pilot $this->getComponent('mail', 'pilotRequestAccepted', array('email' => $email, 'name' => $name, 'externalID' => $externalID, 'pilot_type' => $pilot_type, 'leg_number' => $leg_number)); } } $pilot = PilotPeer::getByMemberId($member_id); $pilot_id = $pilot->getId(); $mission_leg->setPilotId($pilot_id); $mission_leg->setMissAssisId($req->getMissAssisId()); $mission_leg->save(); $c = new Criteria(); $c->add(PilotRequestPeer::ID, NULL, Criteria::ISNOTNULL); if ($req->getMissionAssistantWanted() == 1 && $req->getMissAssisId()) { $getMemberId = $req->getMissAssisId(); $c->add(PilotRequestPeer::MEMBER_ID, $getMemberId, Criteria::NOT_EQUAL); } $c->add(PilotRequestPeer::ACCEPTED, 0); $c->add(PilotRequestPeer::LEG_ID, $leg_id); $reqs = PilotRequestPeer::doSelect($c); foreach ($reqs as $reqpilot) { if ($reqpilot instanceof PilotRequest) { // Member information $member = MemberPeer::retrieveByPK($reqpilot->getMemberId()); $externalID = $member->getExternalId(); // Person information $person = PersonPeer::retrieveByPK($member->getPersonId()); $frist_name = $person->getFirstName(); $last_name = $person->getLastName(); $name = $frist_name . ' ' . $last_name; $email = $person->getEmail(); $reqpilot->setAccepted(0); $reqpilot->setProcessed(1); $reqpilot->setOnHold(0); $reqpilot->save(); // Mission Leg information $mission_leg = MissionLegPeer::retrieveByPK($leg_id); $leg_number = $mission_leg->getLegNumber(); // Missio information $mission = MissionPeer::retrieveByPK($mission_leg->getMissionId()); $missionDate = $mission->getMissionDate(); if ($person->getEmail()) { $this->getComponent('mail', 'pilotRequestNotAccepted', array('email' => $email, 'name' => $name, 'externalID' => $externalID, 'leg_number' => $leg_number, 'missionDate' => $missionDate)); } } } $this->getUser()->setAttribute('pilotAddToLegview', 1); return $this->renderText($leg_id); } } return sfView::NONE; } }
/** * Request a group Missions * CODE:mission_request_group_create */ public function executeRequestGroupMission(sfWebRequest $request) { #security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Pilot', 'Coordinator', 'Volunteer'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } $camp = CampPeer::retrieveByPK($request->getParameter('id')); if (isset($camp) && $camp instanceof Camp) { $this->camp_id = $camp->getId(); $missions = MissionPeer::getByCampId($camp->getId()); } $this->dates = array(); $this->home_base = null; $this->number_of_seats = null; $this->total_carry = null; $this->multi_pick = null; $this->date_choice = null; $this->comment = null; $this->request_as = null; $this->acc_cre = null; $this->pilot_ma = null; $this->IFR = null; $this->aircraft = null; $this->tail = null; $this->other_pilot = null; $miss_dates = array(); //$appt_dates = array(); //$count = 0; //$count2 = 0; foreach ($missions as $mission) { if ($mission->getMissionDate()) { $miss_dates[$mission->getMissionDate('m/d/Y')] = $mission->getMissionDate(); //$count++; //it may change $this->mission_date = $mission->getMissionDate(); $this->appt_date = $mission->getApptDate(); // } /* if($mission->getApptDate()){ $appt_dates[$count2] = $mission->getApptDate(); $count2++; }*/ $miss_id = $mission->getId(); } $this->mission_dates = array(); $this->mission_dates = $miss_dates; if (isset($miss_id)) { $legs = MissionLegPeer::getbyMissId($miss_id); $this->mission = MissionPeer::retrieveByPK($miss_id); foreach ($legs as $leg) { if ($leg->getToAirportId()) { $this->leg = $leg; $airport = AirportPeer::retrieveByPK($leg->getToAirportId()); if (isset($airport) && $airport instanceof Airport) { $this->destination_airport = $airport; } } } } /* if(isset($miss_dates[$count-1])){ $this->mission_date = $miss_dates[$count-1]; } if(isset($appt_dates[$count2-1])){ $this->appt_date = $appt_dates[$count2-1]; } */ //$this->mission_leg = MissionLegPeer::retrieveByPK($request->getParameter('id')); $member = MemberPeer::getByPersonId($this->getUser()->getId()); if (isset($member)) { $this->pilot = PilotPeer::getByMemberId($member->getId()); $this->pilot_aircrafts = PilotAircraftPeer::getByMemberId($member->getId()); $this->pre_requests = PilotRequestPeer::getByMemnerIdLegIdCamp($member->getId(), $this->leg->getId()); } if ($request->isMethod('post')) { if ($request->getParameter('id')) { //set post variables $this->dates = $request->getParameter('dates[]', array()); $this->home_base = $request->getParameter('home_base'); $this->number_of_seats = $request->getParameter('number_of_seats'); $this->total_carry = $request->getParameter('total_carry'); $this->multi_pick = $request->getParameter('multi_pick'); $this->date_choice = $request->getParameter('date_choice'); $this->comment = $request->getParameter('comment'); $this->request_as = $request->getParameter('request_as'); $this->acc_cre = $request->getParameter('acc_cre'); $this->pilot_ma = $request->getParameter('pilot_ma'); $this->IFR = $request->getParameter('IFR'); $this->aircraft = $request->getParameter('aircraft'); $this->tail = $request->getParameter('tail'); $this->other_pilot = $request->getParameter('other_pilot'); if (count($this->dates) > 0 && $request->getParameter('home_base') && $request->getParameter('number_of_seats') && $request->getParameter('total_carry')) { //check if this pilot requested this camp already? $c = $has_requested = PilotRequestPeer::getByMemberIdCampId($member->getId(), $request->getParameter('camp_id')); if (!$has_requested) { $pilot_request = new PilotRequest(); if ($member) { $pilot_request->setMemberId($member->getId()); } $pilot_request->setGroupCampId($request->getParameter('camp_id')); if ($request->getParameter('home_base')) { $airport_hb = AirportPeer::getByIdent($request->getParameter('home_base')); if (isset($airport_hb) && $airport_hb instanceof Airport) { $pilot_request->setHomeBase($airport_hb->getIdent()); } else { $this->getUser()->setFlash('warning', 'Home Base is not found!'); $this->redirect($request->getReferer()); } } if ($request->getParameter('number_of_seats')) { if (is_integer((int) $request->getParameter('number_of_seats'))) { $pilot_request->setNumberSeats((int) $request->getParameter('number_of_seats')); } else { $this->getUser()->setFlash('warning', 'Number of seats is in wrong format!'); $this->redirect($request->getReferer()); } } if ($request->getParameter('total_carry')) { if (is_int((int) $request->getParameter('total_carry'))) { $pilot_request->setTotalWeight((int) $request->getParameter('total_carry')); } else { $this->getUser()->setFlash('success', 'Total of carry value is in wrong format!'); $this->redirect($request->getReferer()); } } $pilot_request->setMultiplePick($request->getParameter('multi_pick')); $pilot_request->save(); if (count($this->dates) > 0) { #check is has Pilot Date //$has_pilot_date = PilotDatePeer::getByMemberId($member->getId()); for ($y = 0; $y < count($this->dates); $y++) { $pilot_date = new PilotDate(); $pilot_date->setMemberId($member->getId()); $pilot_date->setDate($this->dates[$y]); $pilot_date->setPilotRequestId($pilot_request->getId()); $pilot_date->save(); } } if (count($this->dates) == 0) { $pilot_request->setDate($this->dates[0]); } $pilot_request->setNumberDateAssign($request->getParameter('date_choice', 1)); $pilot_request->setPilotType($request->getParameter('request_as')); $pilot_request->setComment($request->getParameter('comment')); $pilot_request->setAircraftId($request->getParameter('aircraft')); $pilot_request->setTail($request->getParameter('tail')); //check pilot_type if ($request->getParameter('other_pilot') == 1) { ////mission assistant,earth angel $pilot_request->setMissionAssistantWanted(0); $pilot_request->setIfrBackupWanted(0); $pilot_request->setAccepted(0); $pilot_request->setProcessed(0); $pilot_request->setOnHold(0); } else { ////command pilot $pilot_request->setProcessed(1); if ($request->getParameter('acc_cre') == 1) { $pilot_request->setMissionAssistantWanted(0); #set pilot as mission assistant if ($member->getPerson()) { $pilot_request->setMissionAssistantName($member->getPerson()->getLastName() . ' ' . $member->getPerson()->getFirstName()); } } else { $pilot_request->setMissionAssistantWanted(0); #set pilot's mission assistant as mission assistant if ($request->getParameter('pilot_ma')) { $pilot_request->setMissionAssistantName($request->getParameter('pilot_ma')); } } if ($request->getParameter('IFR') == 0) { $pilot_request->setIfrBackupWanted(0); } else { $pilot_request->setIfrBackupWanted(1); } } $pilot_request->setCreatedAt(date('m/d/y')); $pilot_request->save(); $this->getUser()->setFlash('success', 'Your request has been saved on Camp ID#' . $request->getParameter('camp_id')); // $this->redirect('@pilot_thanks?id='.$request->getParameter('id')); } else { $this->getUser()->setFlash('success', 'You have already requested this Camp Mission!'); // $this->redirect('@pilot_thanks?id='.$request->getParameter('id')); } } else { if (count($this->dates) < 1) { $this->date_other_e = 1; $this->type = $request->getParameter('request_as'); } if (!$request->getParameter('home_base')) { $this->home = 1; } if (!$request->getParameter('number_of_seats')) { $this->number_of = 1; } if (!$request->getParameter('total_carry')) { $this->carry = 1; } } } } }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Airport is new, it will return * an empty collection; or if this Airport has previously * been saved, it will retrieve related Pilots from storage. * * This method is protected by default in order to keep the public * api reasonable. You can provide public methods for those you * actually need in Airport. */ public function getPilotsJoinPilotRelatedByMopOrientedMemberId($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(AirportPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collPilots === null) { if ($this->isNew()) { $this->collPilots = array(); } else { $criteria->add(PilotPeer::PRIMARY_AIRPORT_ID, $this->id); $this->collPilots = PilotPeer::doSelectJoinPilotRelatedByMopOrientedMemberId($criteria, $con, $join_behavior); } } else { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(PilotPeer::PRIMARY_AIRPORT_ID, $this->id); if (!isset($this->lastPilotCriteria) || !$this->lastPilotCriteria->equals($criteria)) { $this->collPilots = PilotPeer::doSelectJoinPilotRelatedByMopOrientedMemberId($criteria, $con, $join_behavior); } } $this->lastPilotCriteria = $criteria; return $this->collPilots; }
/** * @return Pilot */ public function getPilot() { $c = new Criteria(); $c->add(PilotPeer::MEMBER_ID, $this->getId()); return PilotPeer::doSelectOne($c); }
public function executeAssignPassenger(sfWebRequest $request) { /*$camp_passenger = new CampPilotPassenger(); $camp_passenger->setCampId($request->getParameter('camp_id')); $camp_passenger->setMemberId($request->getParameter('member_id')); $camp_passenger->setPassengerId($request->getParameter('pass_id')); * */ $this->setLayout(false); $this->pilot_req_id = $request->getParameter('pilot_req_id'); $this->flight_date = $request->getParameter('flight_date'); $this->message = ''; if (!$request->getParameter('camp_id') || !$request->getParameter('member_id') || !$request->getParameter('pass_id') || !$request->getParameter('pilot_req_id')) { //$this->getUser()->setFlash('error', 'Incomplete data!'); $this->message = 'Incomplete data!'; } else { $pilot = PilotPeer::getByMemberId($request->getParameter('member_id')); if (!$pilot) { $this->message = 'Pilot not found!'; ////$this->getUser()->setFlash('error', 'Pilot not found!'); return; } $pilot_request = PilotRequestPeer::retrieveByPK($request->getParameter('pilot_req_id')); if (!$pilot_request) { $this->message = 'Pilot request not found!'; return; } //check if passenger is linked $camp_passenger = CampPassengerPeer::retrieveByPK($request->getParameter('camp_id'), $request->getParameter('pass_id')); $pass = PassengerPeer::retrieveByPK($request->getParameter('pass_id')); $mission = MissionPeer::getByCampPass($request->getParameter('camp_id'), $request->getParameter('pass_id')); if (!$camp_passenger || !$pass || !$mission) { $this->message = 'Passenger or mission info not found!'; return; } $total_weight = $pass->getWeight(); $num_of_pass = 1; $pass_linked = null; if ($camp_passenger->getLink() != null) { $mission_linked = MissionPeer::getByCampPass($request->getParameter('camp_id'), $camp_passenger->getLink()); $pass_linked = PassengerPeer::retrieveByPK($camp_passenger->getLink()); //now check if mission dates are same if ($mission_linked && $pass_linked) { if ($mission_linked->getMissionDate('m/d/Y') != $mission->getMissionDate('m/d/Y')) { $this->message = 'Linked passengers mission dates are should be same!'; return; } else { $total_weight += $pass_linked->getWeight(); $num_of_pass += 1; } } } /* //check pilots assigned number of day //TODO $pilot_assigned_dates = MissionPeer::getCampPilotDates($request->getParameter('camp_id'), $pilot->getId()); if(sizeof($pilot_assigned_dates) == $pilot_request->getNumberDateAssign()){ foreach ($pilot_assigned_dates as $key => $value){ //if($value==) } } */ //TODO:check pilots max weight //TODO:check pilots number of seats //set pilot to passenger's leg $camp_mission_legs = MissionLegPeer::getByCampIdPassengerId($request->getParameter('camp_id'), $request->getParameter('pass_id')); if ($camp_mission_legs) { foreach ($camp_mission_legs as $leg) { $leg->setPilotId($pilot->getId()); $leg->save(); } } //set pilot to linked passenger's leg if exists a link if ($pass_linked) { $camp_mission_legs = MissionLegPeer::getByCampIdPassengerId($request->getParameter('camp_id'), $pass_linked->getId()); if ($camp_mission_legs) { foreach ($camp_mission_legs as $leg) { $leg->setPilotId($pilot->getId()); $leg->save(); } } } } }
} //Pilot if ($mission_leg->getPilotId()) { $pilot = PilotPeer::retrieveByPK($mission_leg->getPilotId()); $pilotMember = $pilot->getMember(); $pilot_person = PersonPeer::retrieveByPK($pilotMember->getPersonId()); $pilot_aircrafts = PilotAircraftPeer::getByMemberId($pilot->getMemberId()); } // Mission Assistant if ($mission_leg->getMissAssisId()) { $mission_assistant = MemberPeer::retrieveByPK($mission_leg->getMissAssisId()); $miss_assi_persopn = PersonPeer::retrieveByPK($mission_assistant->getPersonId()); } // Backup Pilot if ($mission_leg->getBackupPilotId()) { $backupPilot = PilotPeer::retrieveByPK($mission_leg->getBackupPilotId()); $backupPilotMember = $pilot->getMember(); $backupPilot_person = PersonPeer::retrieveByPK($backupPilotMember->getPersonId()); } /* echo "<pre>"; print_r($pilotMember); die(); //*/ //Companions information $companions = CompanionPeer::getByPassId($passenger->getId()); if ($passenger) { $passenger_type = $passenger->getPassengerType(); } $is_air = $mission_leg->getTransportation() == 'air_mission'; if ($is_air) {
?> disabled="disabled" <?php } ?> name="miss_assis_mail[]" /> </div> <div class="leglabel">Email: </div> <div class="leg_filed"> <?php echo $miss_assis_id->getPerson()->getEmail(); ?> </div> </div> <?php } $backup_pilot_id = PilotPeer::retrieveByPK($miss_leg->getBackupPilotId()); if ($backup_pilot_id) { ?> <div class="legemail_box"> <div class="heading">Backup Pilot: <?php echo $backup_pilot_id->getMember()->getPerson()->getFirstName(); ?> <?php echo $backup_pilot_id->getMember()->getPerson()->getLastName(); ?> </div> <div class="chbox"> <input type="checkbox" <?php if (isset($backup_pilot_id) && $backup_pilot_id->getMember() && $backup_pilot_id->getMember()->getPerson() && $backup_pilot_id->getMember()->getPerson()->getEmail()) { ?> value="<?php
public function executeInstrumentNotication(sfWebRequest $request) { $c = new Criteria(); $c->add(PersonRolePeer::PERSON_ID, $this->getUser()->getId()); $c->addJoin(PersonRolePeer::ROLE_ID, RoleNotificationPeer::ROLE_ID); $personNotification = RoleNotificationPeer::doSelect($c); $this->mid = 0; foreach ($personNotification as $key => $value) { $this->mid = $value->getMid(); $this->notification = $value->getNotification(); //5. person add if ($this->mid == 5 && ($this->notification == 2 || $this->notification == 3)) { $c = new Criteria(); $c->addDescendingOrderByColumn(PersonPeer::ID); $c->setLimit(5); $this->newperson = PersonPeer::doSelect($c); } } $this->host = $request->getHost(); $this->memberId = $this->getUser()->getMemberId(); //$query = "SELECT COUNT(pilot_request.accepted) FROM pilot_request "; //$query .="WHERE pilot_request.accepted = 1 AND pilot_request.processed = 1 AND pilot_request.member_id = ".$this->memberId; //$con = Propel::getConnection(); //$stmt = $con->prepare($query); //$stmt->execute(); /*if($rs = $stmt->fetch(PDO::FETCH_NUM)) { $count = (int)$rs[0]; }else{ $count = 0; }*/ $c = new Criteria(); $c->add(PilotRequestPeer::ACCEPTED, 1); $c->add(PilotRequestPeer::PROCESSED, 1); $c->add(PilotRequestPeer::MEMBER_ID, $this->memberId); $this->totalAccepted = PilotRequestPeer::doCount($c); /* $this->memberId = $this->getUser()->getMemberId(); $query = "SELECT COUNT(pilot_request.accepted) FROM pilot_request "; $query .="WHERE pilot_request.accepted = 0 AND pilot_request.member_id = $this->memberId"; $con = Propel::getConnection(); $stmt = $con->prepare($query); $stmt->execute(); if($rs = $stmt->fetch(PDO::FETCH_NUM)) { $count = (int)$rs[0]; }else{ $count = 0; }*/ $c = new Criteria(); $c->add(PilotRequestPeer::ACCEPTED, 0); $c->add(PilotRequestPeer::MEMBER_ID, $this->memberId); $this->totaldeclined = PilotRequestPeer::doCount($c); $c = new Criteria(); $c->add(MissionLegPeer::PILOT_ID, $this->getUser()->getPilotId()); $c->add(MissionLegPeer::CANCEL_MISSION_LEG, 0); $this->totalMissionCancellation = MissionLegPeer::doCount($c); //total signup events count $pilot_id = $this->getUser()->getPilotId(); if ($pilot_id) { $pilot = PilotPeer::retrieveByPK($pilot_id); $member_id = $pilot->getMemberId(); $date = date('Y-m-d'); $c = new Criteria(); $c->add(EventReservationPeer::MEMBER_ID, $member_id, Criteria::EQUAL); $c->addJoin(EventPeer::ID, EventReservationPeer::EVENT_ID); $c->add(EventPeer::EVENT_DATE, $date, Criteria::GREATER_EQUAL); $this->totalSignupEvents = EventReservationPeer::doCount($c); } // }
/** * Selects a collection of MissionLegChange objects pre-filled with all related objects. * * @param Criteria $c * @param PropelPDO $con * @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN * @return array Array of MissionLegChange objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAll(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { foreach (sfMixer::getCallables('BaseMissionLegChangePeer:doSelectJoinAll:doSelectJoinAll') as $callable) { call_user_func($callable, 'BaseMissionLegChangePeer', $c, $con); } $c = clone $c; // Set the correct dbName if it has not been overridden if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } MissionLegChangePeer::addSelectColumns($c); $startcol2 = MissionLegChangePeer::NUM_COLUMNS - MissionLegChangePeer::NUM_LAZY_LOAD_COLUMNS; PilotPeer::addSelectColumns($c); $startcol3 = $startcol2 + (PilotPeer::NUM_COLUMNS - PilotPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(MissionLegChangePeer::PILOT_ID), array(PilotPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = MissionLegChangePeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = MissionLegChangePeer::getInstanceFromPool($key1))) { // We no longer rehydrate the object, since this can cause data loss. // See http://propel.phpdb.org/trac/ticket/509 // $obj1->hydrate($row, 0, true); // rehydrate } else { $omClass = MissionLegChangePeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); MissionLegChangePeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Pilot rows $key2 = PilotPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = PilotPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = PilotPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); PilotPeer::addInstanceToPool($obj2, $key2); } // if obj2 loaded // Add the $obj1 (MissionLegChange) to the collection in $obj2 (Pilot) $obj2->addMissionLegChange($obj1); } // if joined row not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
public static function getEmailAddressesOfPersonsRelatedToMissionLeg(MissionLeg $mission_leg) { $receivers = array(); // Get Coordinator email address $coordinator = CoordinatorPeer::retrieveByPK($mission_leg->getCoordinatorId()); if ($coordinator && ($coordinator = $coordinator->getMember())) { $coordinator = $coordinator->getPerson()->getEmail(); if (!empty($coordinator)) { // $receivers['coordinator_'.$mission_leg->getId()] = $coordinator; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $coordinator)) { $receivers[] = $coordinator; } } } unset($coordinator); // Get Pilot email address $pilot = PilotPeer::retrieveByPK($mission_leg->getPilotId()); if ($pilot && ($pilot = $pilot->getMember())) { $pilot = $pilot->getPerson()->getEmail(); if (!empty($pilot)) { // $receivers['pilot_'.$mission_leg->getId()] = $pilot; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $pilot)) { $receivers[] = $pilot; } } } unset($pilot); // Get Backup Pilot email address $backup_pilot = PilotPeer::retrieveByPK($mission_leg->getBackupPilotId()); if ($backup_pilot && ($backup_pilot = $backup_pilot->getMember())) { $backup_pilot = $backup_pilot->getPerson()->getEmail(); if (!empty($backup_pilot)) { // $receivers['backup_pilot_'.$mission_leg->getId()] = $backup_pilot; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $backup_pilot)) { $receivers[] = $backup_pilot; } } } unset($backup_pilot); // Get Co-Pilot which is relate to Member $co_pilot = MemberPeer::retrieveByPK($mission_leg->getCopilotId()); if ($co_pilot) { $co_pilot = $co_pilot->getPerson()->getEmail(); if (!empty($co_pilot)) { // $receivers['co_pilot_'.$mission_leg->getId()] = $co_pilot; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $co_pilot)) { $receivers[] = $co_pilot; } } } unset($co_pilot); // Get Backup Co-pilot email address $backup_co_pilot = MemberPeer::retrieveByPK($mission_leg->getBackupCopilotId()); if ($backup_co_pilot) { $backup_co_pilot = $backup_co_pilot->getPerson()->getEmail(); if (!empty($backup_co_pilot)) { // $receivers['backup_co_pilot_'.$mission_leg->getId()] = $backup_co_pilot; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $backup_co_pilot)) { $receivers[] = $backup_co_pilot; } } } unset($backup_co_pilot); // Get mission assist email address $mission_assist = MemberPeer::retrieveByPK($mission_leg->getMissAssisId()); if ($mission_assist) { $mission_assist = $mission_assist->getPerson()->getEmail(); if (!empty($mission_assist)) { // $receivers['mission_assist_'.$mission_leg->getId()] = $mission_assist; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $mission_assist)) { $receivers[] = $mission_assist; } } } unset($mission_assist); // Get Backup mission assist email address $backup_mission_assist = MemberPeer::retrieveByPK($mission_leg->getBackupMissAssisId()); if ($backup_mission_assist) { $backup_mission_assist = $backup_mission_assist->getPerson()->getEmail(); if (!empty($backup_mission_assist)) { // $receivers['backup_mission_assist_'.$mission_leg->getId()] = $backup_mission_assist; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $backup_mission_assist)) { $receivers[] = $backup_mission_assist; } } } unset($backup_mission_assist); // Get Pilot Aircraft email address $pilot_aircraft = PilotAircraftPeer::retrieveByPK($mission_leg->getPilotAircraftId()); if ($pilot_aircraft && ($pilot_aircraft = $pilot_aircraft->getMember())) { $pilot_aircraft = $pilot_aircraft->getPerson()->getEmail(); if (!empty($pilot_aircraft)) { // $receivers['pilot_aircraft_'.$mission_leg->getId()] = $pilot_aircraft; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $pilot_aircraft)) { $receivers[] = $pilot_aircraft; } } } unset($pilot_aircraft); // Get Share AFA ORG email address $afa_org = AfaOrgPeer::retrieveByPK($mission_leg->getShareAfaOrgId()); if ($afa_org) { $afa_org = $afa_org->getRefContactEmail(); if (!empty($afa_org)) { // $receivers['afa_org_'.$mission_leg->getId()] = $afa_org; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $afa_org)) { $receivers[] = $afa_org; } } } unset($afa_org); return $receivers; }
/** * Get the associated Pilot object * * @param PropelPDO Optional Connection object. * @return Pilot The associated Pilot object. * @throws PropelException */ public function getPilot(PropelPDO $con = null) { if ($this->aPilot === null && $this->pilot_id !== null) { $c = new Criteria(PilotPeer::DATABASE_NAME); $c->add(PilotPeer::ID, $this->pilot_id); $this->aPilot = PilotPeer::doSelectOne($c, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aPilot->addMissionLegChanges($this); */ } return $this->aPilot; }
public function executeIndex(sfWebRequest $request) { $text = $request->getParameter('search_by'); $this->results = array(); $this->messages = array(); $this->uris = array(); //person search if ($this->getUser()->hasRights('person_index')) { $c = new Criteria(); $c1 = $c->getNewCriterion(PersonPeer::FIRST_NAME, $text . '%', Criteria::LIKE); $c2 = $c->getNewCriterion(PersonPeer::LAST_NAME, $text . '%', Criteria::LIKE); //$c->setDistinct(PersonPeer::FIRST_NAME); //$c->setDistinct(PersonPeer::LAST_NAME); $c->add($c1->addOr($c2)); $this->results['person'] = PersonPeer::doCount($c); $this->messages['person'] = ' person results'; $this->uris['person'] = 'person/index?filter=1&findperson=1&firstname=' . $text; } //passenger search if ($this->getUser()->hasRights('passenger_index')) { $c = new Criteria(); $c->addJoin(PassengerPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); $c->add(PersonPeer::FIRST_NAME, $text . '%', Criteria::LIKE); $this->results['passenger'] = PassengerPeer::doCount($c); $this->messages['passenger'] = ' passenger results'; $this->uris['passenger'] = 'passenger/index?filter=1&firstname=' . $text; } //companion search if ($this->getUser()->hasRights('companion_index')) { $c = new Criteria(); $c->add(CompanionPeer::NAME, $text . '%', Criteria::LIKE); $this->results['companion'] = CompanionPeer::doCount($c); $this->messages['companion'] = ' companion results'; $this->uris['companion'] = 'companion/index?filter=1&name=' . $text; } //mission search if ($this->getUser()->hasRights('mission_index')) { $c = new Criteria(); if (is_numeric($text)) { $c->add(MissionPeer::ID, $text . '%', Criteria::LIKE); $this->results['mission'] = MissionPeer::doCount($c); $this->uris['mission'] = 'mission/index?filter=1&miss_id=' . $text; } else { $c->addJoin(MissionPeer::PASSENGER_ID, PassengerPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(PassengerPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); $c->add(PersonPeer::FIRST_NAME, $text . '%', Criteria::LIKE); $this->results['mission'] = MissionPeer::doCount($c); $this->uris['mission'] = 'mission/index?filter=1&pass_fname=' . $text; } $this->messages['mission'] = ' mission results'; } //leg search if ($this->getUser()->hasRights('leg_index')) { $c = new Criteria(); $c->addJoin(MissionLegPeer::MISSION_ID, MissionPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(MissionPeer::PASSENGER_ID, PassengerPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(PassengerPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); $c->add(PersonPeer::FIRST_NAME, $text . '%', Criteria::LIKE); $this->results['leg'] = MissionLegPeer::doCount($c); $this->messages['leg'] = ' mission leg results'; $this->uris['leg'] = 'missionLeg/index?filter=1&pass_fname=' . $text; } //requester search if ($this->getUser()->hasRights('requester_index')) { $c = new Criteria(); $c->addJoin(RequesterPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); $c->add(PersonPeer::FIRST_NAME, $text . '%', Criteria::LIKE); $this->results['requester'] = RequesterPeer::doCount($c); $this->messages['requester'] = ' requester results'; $this->uris['requester'] = 'requester/index?filter=1&firstname=' . $text; } //agency search if ($this->getUser()->hasRights('agency_index')) { $c = new Criteria(); $c->add(AgencyPeer::NAME, $text . '%', Criteria::LIKE); $this->results['agency'] = AgencyPeer::doCount($c); $this->messages['agency'] = ' agency results'; $this->uris['agency'] = 'agency/index?filter=1&name=' . $text; } //coordinator search if ($this->getUser()->hasRights('coordinator_index')) { $c = new Criteria(); $c->addJoin(CoordinatorPeer::MEMBER_ID, MemberPeer::ID); $c->addJoin(PersonPeer::ID, MemberPeer::PERSON_ID); $c->add(PersonPeer::FIRST_NAME, $text . '%', Criteria::LIKE); $this->results['coordinator'] = CoordinatorPeer::doCount($c); $this->messages['coordinator'] = ' coordinator results'; $this->uris['coordinator'] = 'coordinator/index?filter=1&firstname=' . $text; } //camp search if ($this->getUser()->hasRights('camp_index')) { $c = new Criteria(); $c->add(CampPeer::CAMP_NAME, $text . '%', Criteria::LIKE); $this->results['camp'] = CampPeer::doCount($c); $this->messages['camp'] = ' camp results'; $this->uris['camp'] = 'camp/index?filter=1&camp_name=' . $text; } //airport search if ($this->getUser()->hasRights('airport_index')) { $c = new Criteria(); $c->add(AirportPeer::NAME, $text . '%', Criteria::LIKE); $this->results['airport'] = AirportPeer::doCount($c); $this->messages['airport'] = ' airport results'; $this->uris['airport'] = 'airport/index?filter=1&name=' . $text; } //member search if ($this->getUser()->hasRights('member_index')) { $c = new Criteria(); if (is_numeric($text)) { $c->add(MemberPeer::ID, $text . '%', Criteria::LIKE); $this->results['member'] = MemberPeer::doCount($c); $this->uris['member'] = 'member/index?filter=1&member_id=' . $text; } else { $c->addJoin(MemberPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); $c->add(PersonPeer::FIRST_NAME, $text . '%', Criteria::LIKE); $this->results['member'] = MemberPeer::doCount($c); $this->uris['member'] = 'member/index?filter=1&firstname=' . $text; } $this->messages['member'] = ' member results'; } //pilot search if ($this->getUser()->hasRights('pilot_index')) { $c = new Criteria(); $c->addJoin(PilotPeer::MEMBER_ID, MemberPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(MemberPeer::PERSON_ID, PersonPeer::ID, Criteria::LEFT_JOIN); $c->add(PersonPeer::FIRST_NAME, $text . '%', Criteria::LIKE); $this->results['pilot'] = PilotPeer::doCount($c); $this->messages['pilot'] = ' pilot results'; $this->uris['pilot'] = 'pilot/index?filter=1&firstname=' . $text; } //pilot request search if ($this->getUser()->hasRights('mission_available_list')) { $c = new Criteria(); if ($text) { $c->add(PilotRequestPeer::DATE, date('Y-m-d', strtotime($text)), Criteria::GREATER_EQUAL); } $this->results['pilotRequest'] = PilotRequestPeer::doCount($c); $this->messages['pilotRequest'] = ' pilot request results'; $this->uris['pilotRequest'] = 'pilotRequest/index?filter=1&req_date2=' . $text; } //mission request search if ($this->getUser()->hasRights('mission_request_index')) { $c = new Criteria(); if ($text) { $c->add(MissionRequestPeer::REQUESTER_DATE, date('Y-m-d', strtotime($text)), Criteria::GREATER_EQUAL); } $this->results['missionRequest'] = MissionRequestPeer::doCount($c); $this->messages['missionRequest'] = ' missionRequest results'; $this->uris['missionRequest'] = 'missionRequest/index?filter=1&request_date2=' . $text; } //mission report search if ($this->getUser()->hasRights('mission_report_review')) { $c = new Criteria(); $c->add(MissionReportPeer::COPILOT_NAME, $text . '%', Criteria::LIKE); $this->results['missionReport'] = MissionReportPeer::doCount($c); $this->messages['missionReport'] = ' missionReport results'; $this->uris['missionReport'] = 'mission_report/review?filter=1&pilot_name=' . $text; } //role search if (1 == 1) { $c = new Criteria(); if (isset($text)) { $c->add(RolePeer::TITLE, $text . '%', Criteria::LIKE); } $this->results['role'] = RolePeer::doCount($c); $this->messages['role'] = ' role results'; $this->uris['role'] = 'role_permission/index?search_by=' . $text; } $this->text = $text; }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(PilotPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(PilotPeer::DATABASE_NAME); $criteria->add(PilotPeer::ID, $pks, Criteria::IN); $objs = PilotPeer::doSelect($criteria, $con); } return $objs; }
/** * Removes the related airport. * CODE: airport_create */ public function executeUnlinkAirport(sfWebRequest $request) { # security if (!$this->getUser()->hasCredential(array('Administrator'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } $pilot = PilotPeer::retrieveByPK($request->getParameter('id')); $this->forward404Unless($pilot); $pilot->setPrimaryAirportId(null); $pilot->save(); $this->getUser()->setFlash('success', 'Primary Airport information have successfully removed!'); $this->redirect('@pilot_view?id=' . $pilot->getId()); }
?> <?php } ?> <?php } ?> </div> </td> <td class="cell-4"> <div class="s-list"> <?php if ($leg->getPilotId()) { ?> <?php $pilot = PilotPeer::retrieveByPK($leg->getPilotId()); ?> <?php if (isset($pilot)) { ?> <?php $member = MemberPeer::retrieveByPK($pilot->getMemberId()); ?> <?php if (isset($member)) { ?> <?php $person = PersonPeer::retrieveByPK($member->getPersonId()); ?> <?php if (isset($person)) {
/** * Selects a collection of MissionLeg objects pre-filled with all related objects except Fbo. * * @param Criteria $c * @param PropelPDO $con * @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN * @return array Array of MissionLeg objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptFbo(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $c = clone $c; // Set the correct dbName if it has not been overridden // $c->getDbName() will return the same object if not set to another value // so == check is okay and faster if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } MissionLegPeer::addSelectColumns($c); $startcol2 = MissionLegPeer::NUM_COLUMNS - MissionLegPeer::NUM_LAZY_LOAD_COLUMNS; MissionPeer::addSelectColumns($c); $startcol3 = $startcol2 + (MissionPeer::NUM_COLUMNS - MissionPeer::NUM_LAZY_LOAD_COLUMNS); AirportPeer::addSelectColumns($c); $startcol4 = $startcol3 + (AirportPeer::NUM_COLUMNS - AirportPeer::NUM_LAZY_LOAD_COLUMNS); AirportPeer::addSelectColumns($c); $startcol5 = $startcol4 + (AirportPeer::NUM_COLUMNS - AirportPeer::NUM_LAZY_LOAD_COLUMNS); CoordinatorPeer::addSelectColumns($c); $startcol6 = $startcol5 + (CoordinatorPeer::NUM_COLUMNS - CoordinatorPeer::NUM_LAZY_LOAD_COLUMNS); PilotPeer::addSelectColumns($c); $startcol7 = $startcol6 + (PilotPeer::NUM_COLUMNS - PilotPeer::NUM_LAZY_LOAD_COLUMNS); MemberPeer::addSelectColumns($c); $startcol8 = $startcol7 + (MemberPeer::NUM_COLUMNS - MemberPeer::NUM_LAZY_LOAD_COLUMNS); PilotPeer::addSelectColumns($c); $startcol9 = $startcol8 + (PilotPeer::NUM_COLUMNS - PilotPeer::NUM_LAZY_LOAD_COLUMNS); MemberPeer::addSelectColumns($c); $startcol10 = $startcol9 + (MemberPeer::NUM_COLUMNS - MemberPeer::NUM_LAZY_LOAD_COLUMNS); MissionReportPeer::addSelectColumns($c); $startcol11 = $startcol10 + (MissionReportPeer::NUM_COLUMNS - MissionReportPeer::NUM_LAZY_LOAD_COLUMNS); PilotAircraftPeer::addSelectColumns($c); $startcol12 = $startcol11 + (PilotAircraftPeer::NUM_COLUMNS - PilotAircraftPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(MissionLegPeer::MISSION_ID), array(MissionPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::FROM_AIRPORT_ID), array(AirportPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::TO_AIRPORT_ID), array(AirportPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::COORDINATOR_ID), array(CoordinatorPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::PILOT_ID), array(PilotPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::COPILOT_ID), array(MemberPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::BACKUP_PILOT_ID), array(PilotPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::BACKUP_COPILOT_ID), array(MemberPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::MISSION_REPORT_ID), array(MissionReportPeer::ID), $join_behavior); $c->addJoin(array(MissionLegPeer::PILOT_AIRCRAFT_ID), array(PilotAircraftPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = MissionLegPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = MissionLegPeer::getInstanceFromPool($key1))) { // We no longer rehydrate the object, since this can cause data loss. // See http://propel.phpdb.org/trac/ticket/509 // $obj1->hydrate($row, 0, true); // rehydrate } else { $omClass = MissionLegPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); MissionLegPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Mission rows $key2 = MissionPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = MissionPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = MissionPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); MissionPeer::addInstanceToPool($obj2, $key2); } // if $obj2 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj2 (Mission) $obj2->addMissionLeg($obj1); } // if joined row is not null // Add objects for joined Airport rows $key3 = AirportPeer::getPrimaryKeyHashFromRow($row, $startcol3); if ($key3 !== null) { $obj3 = AirportPeer::getInstanceFromPool($key3); if (!$obj3) { $omClass = AirportPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj3 = new $cls(); $obj3->hydrate($row, $startcol3); AirportPeer::addInstanceToPool($obj3, $key3); } // if $obj3 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj3 (Airport) $obj3->addMissionLegRelatedByFromAirportId($obj1); } // if joined row is not null // Add objects for joined Airport rows $key4 = AirportPeer::getPrimaryKeyHashFromRow($row, $startcol4); if ($key4 !== null) { $obj4 = AirportPeer::getInstanceFromPool($key4); if (!$obj4) { $omClass = AirportPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj4 = new $cls(); $obj4->hydrate($row, $startcol4); AirportPeer::addInstanceToPool($obj4, $key4); } // if $obj4 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj4 (Airport) $obj4->addMissionLegRelatedByToAirportId($obj1); } // if joined row is not null // Add objects for joined Coordinator rows $key5 = CoordinatorPeer::getPrimaryKeyHashFromRow($row, $startcol5); if ($key5 !== null) { $obj5 = CoordinatorPeer::getInstanceFromPool($key5); if (!$obj5) { $omClass = CoordinatorPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj5 = new $cls(); $obj5->hydrate($row, $startcol5); CoordinatorPeer::addInstanceToPool($obj5, $key5); } // if $obj5 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj5 (Coordinator) $obj5->addMissionLeg($obj1); } // if joined row is not null // Add objects for joined Pilot rows $key6 = PilotPeer::getPrimaryKeyHashFromRow($row, $startcol6); if ($key6 !== null) { $obj6 = PilotPeer::getInstanceFromPool($key6); if (!$obj6) { $omClass = PilotPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj6 = new $cls(); $obj6->hydrate($row, $startcol6); PilotPeer::addInstanceToPool($obj6, $key6); } // if $obj6 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj6 (Pilot) $obj6->addMissionLegRelatedByPilotId($obj1); } // if joined row is not null // Add objects for joined Member rows $key7 = MemberPeer::getPrimaryKeyHashFromRow($row, $startcol7); if ($key7 !== null) { $obj7 = MemberPeer::getInstanceFromPool($key7); if (!$obj7) { $omClass = MemberPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj7 = new $cls(); $obj7->hydrate($row, $startcol7); MemberPeer::addInstanceToPool($obj7, $key7); } // if $obj7 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj7 (Member) $obj7->addMissionLegRelatedByCopilotId($obj1); } // if joined row is not null // Add objects for joined Pilot rows $key8 = PilotPeer::getPrimaryKeyHashFromRow($row, $startcol8); if ($key8 !== null) { $obj8 = PilotPeer::getInstanceFromPool($key8); if (!$obj8) { $omClass = PilotPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj8 = new $cls(); $obj8->hydrate($row, $startcol8); PilotPeer::addInstanceToPool($obj8, $key8); } // if $obj8 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj8 (Pilot) $obj8->addMissionLegRelatedByBackupPilotId($obj1); } // if joined row is not null // Add objects for joined Member rows $key9 = MemberPeer::getPrimaryKeyHashFromRow($row, $startcol9); if ($key9 !== null) { $obj9 = MemberPeer::getInstanceFromPool($key9); if (!$obj9) { $omClass = MemberPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj9 = new $cls(); $obj9->hydrate($row, $startcol9); MemberPeer::addInstanceToPool($obj9, $key9); } // if $obj9 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj9 (Member) $obj9->addMissionLegRelatedByBackupCopilotId($obj1); } // if joined row is not null // Add objects for joined MissionReport rows $key10 = MissionReportPeer::getPrimaryKeyHashFromRow($row, $startcol10); if ($key10 !== null) { $obj10 = MissionReportPeer::getInstanceFromPool($key10); if (!$obj10) { $omClass = MissionReportPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj10 = new $cls(); $obj10->hydrate($row, $startcol10); MissionReportPeer::addInstanceToPool($obj10, $key10); } // if $obj10 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj10 (MissionReport) $obj10->addMissionLeg($obj1); } // if joined row is not null // Add objects for joined PilotAircraft rows $key11 = PilotAircraftPeer::getPrimaryKeyHashFromRow($row, $startcol11); if ($key11 !== null) { $obj11 = PilotAircraftPeer::getInstanceFromPool($key11); if (!$obj11) { $omClass = PilotAircraftPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj11 = new $cls(); $obj11->hydrate($row, $startcol11); PilotAircraftPeer::addInstanceToPool($obj11, $key11); } // if $obj11 already loaded // Add the $obj1 (MissionLeg) to the collection in $obj11 (PilotAircraft) $obj11->addMissionLeg($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }