/** * @return Mission false if not found */ public function getMission(PropelPDO $con = null) { $c = new Criteria(); $c->addJoin(MissionPeer::ITINERARY_ID, ItineraryPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(MissionPeer::ID, MissionLegPeer::MISSION_ID, Criteria::LEFT_JOIN); $c->add(MissionLegPeer::ID, null, Criteria::ISNOTNULL); $c->add(ItineraryPeer::CAMP_ID, $this->getCampId()); $c->add(ItineraryPeer::PASSENGER_ID, $this->getPassengerId()); $mission = MissionPeer::doSelectOne($c); return $mission ? $mission : false; }
/** * Searches for requesters * CODE: requester_index */ public function executeIndex(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'); } if ($request->hasParameter('mission_for')) { //$mission_leg = MissionLegPeer::retrieveByPK($request->getParameter('mission_for')); $this->mission_for = MissionPeer::retrieveByPK($request->getParameter('mission_for')); $this->can_use = 1; } else { $this->change_id = null; } $exclude_ids = array(); if ($this->mission_for) { $exclude_ids[] = $this->mission_for->getId(); } # for navigation menu sfContext::getInstance()->getConfiguration()->loadHelpers('Partial'); slot('nav_menu', array('mission_coord', '')); # filter $this->processFilter($request); if ($request->isMethod('post') || $request->getParameter('page')) { $this->pager = RequesterPeer::getPager($this->max, $this->page, $this->firstname, $this->lastname, $this->city, $this->state, $this->agency_name, $exclude_ids); $this->requesters = $this->pager->getResults(); } # one result with member_id search will go to member view if (count($this->requesters) == 1) { if ($this->mission_for) { $url_add = '&mission_for=' . $this->mission_for->getId(); } else { $url_add = ''; } if ($request->getParameter('mission_for')) { $this->redirect('@leg_edit?id=' . $request->getParameter('mission_for') . $url_add); } } $this->getUser()->addRecentItem('Requesters', 'requesters', 'requester/index'); }
} ?> name="agency_mail" /> </div> <div class="leglabel">Email: </div> <div class="leg_filed"> <?php if ($itinerary->getAgencyId()) { echo $agency->getEmail(); } ?> </div> </div> <?php if ($itinerary->getId()) { $mission = MissionPeer::getAllMissionByItineraryId($itinerary->getId()); } foreach ($mission as $mission_list) { if ($mission_list->getCoordinatorId()) { $coordinator = CoordinatorPeer::retrieveByPK($mission_list->getCoordinatorId()); } if ($coordinator) { ?> <div class="legemail_box"> <div class="heading">Coordinator for Mission <?php $mission_list->getId(); ?> : <?php if ($coordinator->getMember()) { echo $coordinator->getMember()->getPerson()->getFirstName(); }
public function executeCopy(sfWebRequest $request) { $type = $request->getParameter('type'); $miss_id = $request->getParameter('id'); $mission_old = MissionPeer::retrieveByPK($miss_id); $mission = new Mission(); $mission_old->copyInto($mission); $msId = 'copy of ' . $miss_id; $mission->setExternalId(MissionPeer::getLatestExternalId()); $mission->setCopiedMission($msId); $mission->setMissionDate(date('Y-m-d H:i:m')); $mission->save(); $mission_legs = MissionLegPeer::getbyMissIdDown($mission_old->getId()); if ($type === "copy") { foreach ($mission_legs as $mission_leg) { $mi_leg = new MissionLeg(); $mission_leg->copyInto($mi_leg); $mlgId = 'copy of ' . $mission_leg->getId(); $mi_leg->setMissionId($mission->getId()); $mi_leg->setCopiedMissionLeg($mlgId); $mi_leg->save(); } $this->getUser()->setFlash('success', "The mission have been copied successfully."); $this->redirect('mission/index'); } else { foreach ($mission_legs as $mission_leg) { $mi_leg = new MissionLeg(); $mission_leg->copyInto($mi_leg); $mi_leg->setMissionId($mission->getId()); $from = $mi_leg->getFromAirportId(); $to = $mi_leg->getToAirportId(); $mi_leg->setFromAirportId($to); $mi_leg->setToAirportId($from); $mi_leg->save(); } $this->getUser()->setFlash('success', "The mission have been reversed successfully."); $this->redirect('mission/index'); } }
?> <?php if ($camp->getAgency()) { ?> <?php echo $camp->getAgency()->getName(); ?> <?php } ?> <?php } ?> </h3> <?php $missions = MissionPeer::getByCampId($camp->getId()); $mission_dates = array(); foreach ($missions as $mission) { if ($mission->getMissionDate()) { $mission_dates[$mission->getMissionDate('m/d/Y')] = $mission->getMissionDate(); } } $mission = $missions[0]; /* $start_date = date('m/d/y',strtotime($mission->getMissionDate())); $check_date = $start_date; $end_date = date('m/d/y',strtotime($mission->getApptDate())); $start_date2 = $start_date; $check_date2 = $start_date2; $end_date2 = $end_date;
/** * Get the associated Mission object * * @param PropelPDO Optional Connection object. * @return Mission The associated Mission object. * @throws PropelException */ public function getMission(PropelPDO $con = null) { if ($this->aMission === null && $this->mission_id !== null) { $c = new Criteria(MissionPeer::DATABASE_NAME); $c->add(MissionPeer::ID, $this->mission_id); $this->aMission = MissionPeer::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->aMission->addMissionPhotos($this); */ } return $this->aMission; }
public function executeShow(sfWebRequest $request) { #Security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } $this->mission_photo = MissionPhotoPeer::retrieveByPK($request->getParameter('id')); $this->forward404Unless($this->mission_photo); //mission # for navigation menu sfContext::getInstance()->getConfiguration()->loadHelpers('Partial'); slot('nav_menu', array('mission_coord', 'find-camp')); # recent item $this->getUser()->addRecentItem('Missions', 'missions', 'mission/index'); # filter $this->processFilter($request); $this->pager = MissionPeer::getPager($this->max, $this->page, $this->miss_id, $this->miss_type, $this->miss_date1, $this->miss_date2, $this->pass_fname, $this->pass_lname, $this->mreq_fname, $this->mreq_lname); $this->mission_list = $this->pager->getResults(); $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); }
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; }
/** * missionRequests save all data into corresponding tables * CODE:mission_request_create */ public function executeSave(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'); } $miss_req_session = $this->getUser()->getAttribute('miss_req'); if (!$miss_req_session) { return $this->forward('passenger', 'step3'); } //set Requester Person $req_person = new Person(); $req_person->setFirstName($miss_req_session->getReqFirstname()); $req_person->setLastName($miss_req_session->getReqLastname()); $req_person->setAddress1($miss_req_session->getReqAddress1()); $req_person->setAddress2($miss_req_session->getReqAddress2()); $req_person->setCity($miss_req_session->getReqCity()); $req_person->setCounty($miss_req_session->getReqCounty()); $req_person->setState($miss_req_session->getReqState()); $req_person->setCountry($miss_req_session->getReqCountry()); $req_person->setZipcode($miss_req_session->getReqZipcode()); $req_person->setEmail($miss_req_session->getReqEmail()); $req_person->setSecondaryEmail($miss_req_session->getReqSecondaryEmail()); $req_person->setPagerEmail($miss_req_session->getReqPagerEmail()); $req_person->setDayPhone($miss_req_session->getReqDayPhone()); $req_person->setDayComment($miss_req_session->getReqDayComment()); $req_person->setEveningPhone($miss_req_session->getReqEvePhone()); $req_person->setEveningComment($miss_req_session->getReqEveComment()); $req_person->setMobilePhone($miss_req_session->getReqMobilePhone()); $req_person->setMobileComment($miss_req_session->getReqMobileComment()); $req_person->setPagerPhone($miss_req_session->getReqPagerPhone()); $req_person->setPagerComment($miss_req_session->getReqPagerComment()); $req_person->setOtherPhone($miss_req_session->getReqOtherPhone()); $req_person->setOtherComment($miss_req_session->getReqOtherComment()); $req_person->save(); //end of Requester Person // set Requester Agency $agency = AgencyPeer::getByNamePhone(trim($miss_req_session->getAgencyName())); if ($agency) { # nothing } else { $agency = new Agency(); $agency->setName(trim($miss_req_session->getAgencyName())); $agency->save(); } //set Requester $requester = new Requester(); $requester->setPersonId($req_person->getId()); $requester->setAgencyId($agency->getId()); //$requester->setDischarge($miss_req_session->getReqDischarge()); $requester->save(); if (isset($miss_req_session->passenger_id)) { $passenger = PassengerPeer::retrieveByPK($miss_req_session->passenger_id); if (!$passenger instanceof Passenger) { $passenger = new Passenger(); } } else { $passenger = new Passenger(); } if ($passenger->isNew()) { $person = new Person(); } else { $person = $passenger->getPerson(); } //set Person to Passenger $person->setTitle($miss_req_session->getPassTitle()); $person->setFirstName($miss_req_session->getPassFirstName()); $person->setLastName($miss_req_session->getPassLastName()); $person->setGender($miss_req_session->getPassGender()); $person->setAddress1($miss_req_session->getPassAddress1()); $person->setAddress2($miss_req_session->getPassAddress2()); $person->setCity($miss_req_session->getPassCity()); $person->setState($miss_req_session->getPassState()); $person->setZipcode($miss_req_session->getPassZipcode()); $person->setCountry($miss_req_session->getPassCountry()); $person->setEmail($miss_req_session->getPassEmail()); $person->setDayPhone($miss_req_session->getPassDayPhone()); $person->setDayComment($miss_req_session->getPassDayComment()); $person->setEveningPhone($miss_req_session->getPassEvePhone()); $person->setEveningComment($miss_req_session->getPassEveComment()); $person->setMobilePhone($miss_req_session->getPassMobilePhone()); $person->setMobileComment($miss_req_session->getPassMobileComment()); $person->setPagerPhone($miss_req_session->getPassPagerPhone()); $person->setPagerComment($miss_req_session->getPassPagerComment()); $person->setOtherPhone($miss_req_session->getPassOtherPhone()); $person->setOtherComment($miss_req_session->getPassOtherComment()); $person->save(); //set Passenger $passenger->setPersonId($person->getId()); $passenger->setPassengerTypeId($miss_req_session->getPassType()); $passenger->setDateOfBirth($miss_req_session->getPassDateOfBirth()); $passenger->setIllness($miss_req_session->getIllness()); $passenger->setFinancial($miss_req_session->getFinancial()); $passenger->setPublicConsiderations($miss_req_session->getPassPublicCons()); $passenger->setPrivateConsiderations($miss_req_session->getPassPrivateCons()); $passenger->setReleasingPhysician($miss_req_session->getReleasingPhysician()); $passenger->setReleasingPhone($miss_req_session->getReleasePhone()); $passenger->setReleasingFax1($miss_req_session->getReleaseFax()); $passenger->setReleasingFax1Comment($miss_req_session->getReleaseFaxComment()); $passenger->setLodgingName($miss_req_session->getLodgingName()); $passenger->setLodgingPhone($miss_req_session->getLodgingPhone()); $passenger->setLodgingPhoneComment($miss_req_session->getLodgingPhoneComment()); $passenger->setFacilityName($miss_req_session->getFacilityName()); $passenger->setFacilityPhone($miss_req_session->getFacilityPhone()); $passenger->setFacilityPhoneComment($miss_req_session->getFacilityPhoneComment()); $passenger->setReleasingEmail($miss_req_session->getReleaseEmail()); $passenger->setTreatingPhysician($miss_req_session->getTreatingPhysician()); $passenger->setTreatingPhone($miss_req_session->getTreatingPhone()); $passenger->setTreatingFax1($miss_req_session->getTreatingFax()); $passenger->setTreatingFax1Comment($miss_req_session->getTreatingFaxComment()); $passenger->setTreatingEmail($miss_req_session->getTreatingEmail()); $passenger->setLanguageSpoken($miss_req_session->getPassLanguage()); $passenger->setBestContactMethod($miss_req_session->getBestContact()); $passenger->setEmergencyContactName($miss_req_session->getEmergencyName()); $passenger->setEmergencyContactPrimaryPhone($miss_req_session->getEmergencyPhone1()); $passenger->setEmergencyContactPrimaryComment($miss_req_session->getEmergencyPhone1Comment()); $passenger->setEmergencyContactSecondaryPhone($miss_req_session->getEmergencyPhone2()); $passenger->setEmergencyContactSecondaryComment($miss_req_session->getEmergencyPhone2Comment()); $passenger->setNeedMedicalRelease($miss_req_session->getPassMedical()); $passenger->save(); //set Companions if ($passenger && $miss_req_session->getCom1Name()) { $person = new Person(); $names[] = split(" ", $miss_req_session->getCom1Name()); //echo var_dump($names); die(); $person->setFirstName($names[0][0]); $person->setLastName($names[0][1]); $person->setDayPhone($miss_req_session->getCom1Phone()); $person->setDayComment($miss_req_session->getCom1Comment()); $person->save(); $companion = new Companion(); $companion->setPassengerId($passenger->getId()); $companion->setName($miss_req_session->getCom1Name()); $companion->setRelationship($miss_req_session->getCom1Relationship()); $companion->setDateOfBirth($miss_req_session->getCom1DateOfBirth()); $companion->setWeight($miss_req_session->getCom1Weigth()); $companion->setCompanionPhone($miss_req_session->getCom1Phone()); $companion->setCompanionPhoneComment($miss_req_session->getCom1Comment()); $companion->setPersonId($person->getId()); $companion->save(); } if ($passenger && $miss_req_session->getCom2Name()) { $person = new Person(); $names[] = split(" ", $miss_req_session->getCom2Name()); //echo var_dump($names); die(); $person->setFirstName($names[0][0]); $person->setLastName($names[0][1]); $person->setDayPhone($miss_req_session->getCom2Phone()); $person->setDayComment($miss_req_session->getCom2Comment()); $person->save(); $companion = new Companion(); $companion->setPassengerId($passenger->getId()); $companion->setName($miss_req_session->getCom2Name()); $companion->setRelationship($miss_req_session->getCom2Relationship()); $companion->setDateOfBirth($miss_req_session->getCom2DateOfBirth()); $companion->setWeight($miss_req_session->getCom2Weigth()); $companion->setCompanionPhone($miss_req_session->getCom2Phone()); $companion->setCompanionPhoneComment($miss_req_session->getCom2Comment()); $companion->setPersonId($person->getId()); $companion->save(); } if ($passenger && $miss_req_session->getCom3Name()) { $person = new Person(); $names[] = split(" ", $miss_req_session->getCom3Name()); //echo var_dump($names); die(); $person->setFirstName($names[0][0]); $person->setLastName($names[0][1]); $person->setDayPhone($miss_req_session->getCom3Phone()); $person->setDayComment($miss_req_session->getCom3Comment()); $person->save(); $companion = new Companion(); $companion->setPassengerId($passenger->getId()); $companion->setName($miss_req_session->getCom3Name()); $companion->setRelationship($miss_req_session->getCom3Relationship()); $companion->setDateOfBirth($miss_req_session->getCom3DateOfBirth()); $companion->setWeight($miss_req_session->getCom3Weigth()); $companion->setCompanionPhone($miss_req_session->getCom3Phone()); $companion->setCompanionPhoneComment($miss_req_session->getCom3Comment()); $companion->setPersonId($person->getId()); $companion->save(); } if ($passenger && $miss_req_session->getCom4Name()) { $person = new Person(); $names[] = split(" ", $miss_req_session->getCom4Name()); //echo var_dump($names); die(); $person->setFirstName($names[0][0]); $person->setLastName($names[0][1]); $person->setDayPhone($miss_req_session->getCom4Phone()); $person->setDayComment($miss_req_session->getCom4Comment()); $person->save(); $companion = new Companion(); $companion->setPassengerId($passenger->getId()); $companion->setName($miss_req_session->getCom4Name()); $companion->setRelationship($miss_req_session->getCom4Relationship()); $companion->setDateOfBirth($miss_req_session->getCom4DateOfBirth()); $companion->setWeight($miss_req_session->getCom4Weigth()); $companion->setCompanionPhone($miss_req_session->getCom4Phone()); $companion->setCompanionPhoneComment($miss_req_session->getCom4Comment()); $companion->setPersonId($person->getId()); $companion->save(); } if ($passenger && $miss_req_session->getCom5Name()) { $person = new Person(); $names[] = split(" ", $miss_req_session->getCom5Name()); //echo var_dump($names); die(); $person->setFirstName($names[0][0]); $person->setLastName($names[0][1]); $person->setDayPhone($miss_req_session->getCom5Phone()); $person->setDayComment($miss_req_session->getCom5Comment()); $person->save(); $companion = new Companion(); $companion->setPassengerId($passenger->getId()); $companion->setName($miss_req_session->getCom5Name()); $companion->setRelationship($miss_req_session->getCom5Relationship()); $companion->setDateOfBirth($miss_req_session->getCom5DateOfBirth()); $companion->setWeight($miss_req_session->getCom5Weigth()); $companion->setCompanionPhone($miss_req_session->getCom5Phone()); $companion->setCompanionPhoneComment($miss_req_session->getCom5Comment()); $companion->setPersonId($person->getId()); $companion->save(); } //set Itinerary $itinerary = ItineraryPeer::getByMissReqId($miss_req_session->getId()); if (!$itinerary) { $new_itinerary = new Itinerary(); $new_itinerary->setDateRequested(date('m/d/Y')); $new_itinerary->setMissionRequestId($miss_req_session->getId()); $new_itinerary->setMissionTypeId($miss_req_session->getMissionRequestTypeId()); $new_itinerary->setApointTime($miss_req_session->getApptDate()); $new_itinerary->setPassengerId($passenger->getId()); $new_itinerary->setRequesterId($requester->getId()); $new_itinerary->setFacility($miss_req_session->getFacilityName()); $new_itinerary->setLodging($miss_req_session->getLodgingName()); $new_itinerary->setOrginCity($miss_req_session->getOrginCity()); $new_itinerary->setOrginState($miss_req_session->getOrginState()); $new_itinerary->setDestCity($miss_req_session->getDestCity()); $new_itinerary->setDestState($miss_req_session->getDestState()); $new_itinerary->setWaiverNeed(0); $new_itinerary->setNeedMedicalRelease($miss_req_session->getPassMedical()); $new_itinerary->setComment($miss_req_session->getComment()); $new_itinerary->setAgencyId($agency->getId()); $new_itinerary->save(); } //set default Mission to Mission table //get Passenger //$passenger = PassengerPeer::getByPersonId($person->getId()); $misson = new Mission(); $misson->setRequestId($miss_req_session->getId()); $misson->setItineraryId($new_itinerary->getId()); $misson->setMissionTypeId($miss_req_session->getMissionRequestTypeId()); $misson->setDateRequested($miss_req_session->getRequesterDate()); if ($passenger) { $misson->setPassengerId($passenger->getId()); } if ($requester) { $misson->setRequesterId($requester->getId()); } if ($agency) { $misson->setAgencyId($agency->getId()); } // Farazi Mission 1 externa ID $c = new Criteria(); $c->add(MissionPeer::EXTERNAL_ID, NULL, Criteria::ISNOTNULL); $c->addDescendingOrderByColumn(MissionPeer::ID); $external_mission = MissionPeer::doSelectOne($c); $external_id = $external_mission->getExternalId(); $currentExternalId = $external_id + 1; $misson->setExternalId($currentExternalId); $misson->setApptDate($miss_req_session->getApptDate()); $misson->setFlightTime($miss_req_session->getFlightTime()); $misson->setMissionDate($miss_req_session->getMissionDate()); $misson->setMissionCount(1); $misson->save(); $missLeg = new MissionLeg(); $missLeg->setMissionId($misson->getId()); $missLeg->setLegNumber(1); if ($miss_req_session->getOrginState() && $miss_req_session->getOrginZipcode()) { //echo $miss_req_session->getOrginState().'-'.$miss_req_session->getOrginZipcode();die(); $fromairport = AirportPeer::getAirportByStateAndZipcode($miss_req_session->getOrginState(), $miss_req_session->getOrginZipcode()); if ($fromairport) { $missLeg->setFromAirportId($fromairport->getId()); } } if ($miss_req_session->getDestState() && $miss_req_session->getDestZipcode()) { //echo $miss_req_session->getDestState().'--'.$miss_req_session->getDestZipcode();die(); $toairport = AirportPeer::getAirportByStateAndZipcode($miss_req_session->getDestState(), $miss_req_session->getDestZipcode()); if ($toairport) { $missLeg->setToAirportId($toairport->getId()); } } //echo "oder";die(); $missLeg->setPassOnBoard(0); $missLeg->setWebCoordinated(0); $missLeg->setTransportation('air_mission'); $missLeg->save(); //end set Mission $this->getUser()->setFlash('success', 'New mission has successfully created!'); $miss_req_session->setProcessedDate(time()); $miss_req_session->save(); $this->getUser()->setAttribute('miss_req', null); //$this->redirect('miss_req'); //$this->getUser()->setFlash('success',$success); //$request->getParameter('back') $this->redirect('/itinerary/detail/' . $new_itinerary->getId()); }
/** * Populates the object using an array. * * This is particularly useful when populating an object from one of the * request arrays (e.g. $_POST). This method goes through the column * names, checking to see whether a matching key exists in populated * array. If so the setByName() method is called for that column. * * You can specify the key type of the array by additionally passing one * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME, * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM. * The default key type is the column's phpname (e.g. 'AuthorId') * * @param array $arr An array to populate the object from. * @param string $keyType The type of keys the array uses. * @return void */ public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = MissionPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setExternalId($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setRequestId($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setItineraryId($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setMissionTypeId($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setMissionDate($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setDateRequested($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setPassengerId($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setRequesterId($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setAgencyId($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setOtherRequesterId($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setOtherAgencyId($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setCampId($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setCoordinatorId($arr[$keys[13]]); } if (array_key_exists($keys[14], $arr)) { $this->setApptDate($arr[$keys[14]]); } if (array_key_exists($keys[15], $arr)) { $this->setFlightTime($arr[$keys[15]]); } if (array_key_exists($keys[16], $arr)) { $this->setTreatment($arr[$keys[16]]); } if (array_key_exists($keys[17], $arr)) { $this->setComment($arr[$keys[17]]); } if (array_key_exists($keys[18], $arr)) { $this->setAppointment($arr[$keys[18]]); } if (array_key_exists($keys[19], $arr)) { $this->setMissionSpecificComments($arr[$keys[19]]); } if (array_key_exists($keys[20], $arr)) { $this->setStart($arr[$keys[20]]); } if (array_key_exists($keys[21], $arr)) { $this->setApointTime($arr[$keys[21]]); } if (array_key_exists($keys[22], $arr)) { $this->setMissionCount($arr[$keys[22]]); } if (array_key_exists($keys[23], $arr)) { $this->setBWeight($arr[$keys[23]]); } if (array_key_exists($keys[24], $arr)) { $this->setBType($arr[$keys[24]]); } if (array_key_exists($keys[25], $arr)) { $this->setBDesc($arr[$keys[25]]); } if (array_key_exists($keys[26], $arr)) { $this->setCancelMission($arr[$keys[26]]); } if (array_key_exists($keys[27], $arr)) { $this->setCopiedMission($arr[$keys[27]]); } }
public function executeAvailableMissions(sfWebRequest $request) { $pilot = PilotPeer::retrieveByPK($this->getUser()->getPilotId()); if (!$pilot instanceof Pilot) { return sfView::NONE; } if ($pilot->getPrimaryAirportId()) { $this->mission_legs = MissionLegPeer::getPilotNear($pilot->getPrimaryAirportId()); } else { $this->mission_legs = array(); } $this->home_airport = $pilot->getAirport(); $ids = array(); foreach ($this->mission_legs as $leg) { $ids[] = $leg->getId(); } $c = new Criteria(); $c->add(MissionLegPeer::TRANSPORTATION, 'air_mission'); $c->add(MissionLegPeer::ID, $ids, Criteria::NOT_IN); $c->add(MissionLegPeer::CANCELLED, null, Criteria::ISNULL); $c1 = $c->getNewCriterion(MissionLegPeer::PILOT_ID, null, Criteria::ISNULL); $c2 = $c->getNewCriterion(MissionLegPeer::COPILOT_ID, null, Criteria::ISNULL); $c->add($c1->addOr($c2)); $c->setLimit(50); $this->interest_legs = MissionLegPeer::doSelectJoinMission($c); $c->clear(); $c->addJoin(MissionLegPeer::ID, PilotRequestPeer::LEG_ID, Criteria::LEFT_JOIN); $c->add(PilotRequestPeer::ACCEPTED, 1, Criteria::NOT_EQUAL); $c->add(MissionLegPeer::TRANSPORTATION, 'air_mission'); //$c->addAscendingOrderByColumn(); $c->setLimit(50); $this->pending_legs = MissionLegPeer::doSelectJoinMission($c); //ziyed // validity $person = PersonPeer::retrieveByPK($this->getUser()->getId()); //$this->forward404Unless($person); $member = $person->getMember(); //$this->forward404Unless($member); if ($member) { $pilot = $member->getPilot(); } else { $pilot = null; } // filter related $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); if ($pilot) { $this->personal_flights = $pilot->getPersonalFlights(); } else { $this->personal_flights = array(); } $this->wings = WingPeer::doSelect(new Criteria()); $this->idents = AirportPeer::doSelect(new Criteria()); $this->states = sfConfig::get('app_short_states'); $this->mission_types = MissionTypePeer::doSelect(new Criteria()); $this->member = $member; $this->pilot = $pilot; if ($pilot) { $this->airport = $pilot->getAirport(); } else { $this->airport = null; } if ($request) { $this->processFilterForm($request); } if ($request->getParameter('needs') == 1) { $this->needs_pilot = 1; } $this->pager = MissionPeer::getPilotAvailablePager($this->max, $this->airport, $this->page, $this->sort_by, $this->date_range1, $this->date_range2, $this->weekdays, $this->wing_id, $this->ident, $this->city, $this->state, $this->zip, $this->origin, $this->dest, $this->needs_pilot, $this->co_pilot, $this->ifr, $this->selected_types, $this->filled, $this->open, $this->max_pass, $this->max_weight, $this->max_distance, $this->min_efficiency, false, $this->ignore_availability); $this->miss_array = $this->pager->getResults(); $this->total_mission_available = $this->pager->getNbResults(); $this->missions = MissionPeer::getByMayInterested($this->airport, $this->min_efficiency); $ident = $request->getParameter('airport_ident'); if (!empty($ident)) { $this->airport_ident = $request->getParameter('airport_ident'); } else { $this->airport_ident = ""; } //end ziyed }
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'); } } }
<table> <thead> <tr> <th></th> <th>Name</th> <th>Location</th> <th>Weights</th> <th>Comments</th> <th>Distance</th> </tr> </thead> <tbody> <?php $camps_missions = MissionPeer::getByCampId($camp_id); $linked_passengers = array(); $passengers = array(); $cc = 0; foreach ($camps_missions as $miss) { $legs = MissionLegPeer::getbyMissIdNoPilotId($miss->getId()); if ($legs && isset($legs) && $miss->getMissionDate('Ymd') == $flight_date) { $passengers[$cc] = $miss->getPassengerId(); $cc++; } } if (isset($passengers)) { for ($u = 0; $u < count($passengers); $u++) { //if passenger is linked and listed already, dont show $print = true; foreach ($linked_passengers as $key => $value) { if ($passengers[$u] == $value) { $print = false;
/** * 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; } }
public static function getLatestExternalId() { // External Id Block $c = new Criteria(); $c->add(MissionPeer::EXTERNAL_ID, NULL, Criteria::ISNOTNULL); $c->addDescendingOrderByColumn(MissionPeer::ID); $external_mission = MissionPeer::doSelectOne($c); unset($c); return $external_mission->getExternalId() + 1; }
public function executeReverse(sfWebRequest $request) { $mis1 = MissionPeer::retrieveByPK($request->getParameter('miss_id')); $itine_id = $mis1->getItineraryId(); $mis2 = MissionPeer::retrieveByPK($request->getParameter('mis2_id')); $mis1_legs = MissionLegPeer::getbyDesOrderMissId($request->getParameter('miss_id')); $legnumber = 1; $comcount = 1; $aircount = 1; $groundcount = 1; foreach ($mis1_legs as $mleg) { $type = $mleg->getTransportation(); switch ($type) { case 'air_mission': $mission_leg = new MissionLeg(); $mission_leg->setMissionId($mis2->getId()); $mission_leg->setLegNumber($legnumber); $mission_leg->setFromAirportId($mleg->getToAirportId()); $mission_leg->setToAirportId($mleg->getFromAirportId()); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('air_mission'); $mission_leg->setPrefix('air' . $aircount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $aircount++; break; case 'ground_mission': $mission_leg = new MissionLeg(); $mission_leg->setMissionId($mis2->getId()); $mission_leg->setLegNumber($legnumber); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('ground_mission'); $mission_leg->setGroundOrigin($mleg->getGroundDestination()); $mission_leg->setGroundDestination($mleg->getGroundOrigin()); $mission_leg->setPrefix('g' . $groundcount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $groundcount++; break; case 'commercial_mission': $mission_leg = new MissionLeg(); $mission_leg->setMissionId($mis2->getId()); $mission_leg->setLegNumber($legnumber); $mission_leg->setFlightTime($mleg->getFlightTime()); //$mission_leg->setBaggageDesc($request->getParameter('baggage_desc')); //$mission_leg->setBaggageWeight($request->getParameter('baggage_weight')); $mission_leg->setAirlineId($mleg->getAirlineId()); $mission_leg->setFundId($mleg->getFundId()); $mission_leg->setConfirmCode($mleg->getConfirmCode()); $mission_leg->setFlightCost($mleg->getFlightCost()); $mission_leg->setCommOrigin($mleg->getCommDest()); $mission_leg->setCommDest($mleg->getCommOrigin()); $mission_leg->setFlightNumber($mleg->getFlightNumber()); $mission_leg->setDeparture($mleg->getDeparture()); $mission_leg->setTransportation('commercial_mission'); $mission_leg->setPrefix('com' . $comcount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $comcount++; break; } $legnumber++; } $this->getUser()->setFlash('success', 'Successfully reverse.'); $this->redirect('itinerary/detail?id=' . $itine_id); }
/** * Selects a collection of MissionPhoto objects pre-filled with all related objects except MissionLeg. * * @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 MissionPhoto objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptMissionLeg(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); } MissionPhotoPeer::addSelectColumns($c); $startcol2 = MissionPhotoPeer::NUM_COLUMNS - MissionPhotoPeer::NUM_LAZY_LOAD_COLUMNS; MissionPeer::addSelectColumns($c); $startcol3 = $startcol2 + (MissionPeer::NUM_COLUMNS - MissionPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(MissionPhotoPeer::MISSION_ID), array(MissionPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = MissionPhotoPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = MissionPhotoPeer::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 = MissionPhotoPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); MissionPhotoPeer::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 (MissionPhoto) to the collection in $obj2 (Mission) $obj2->addMissionPhoto($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
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(); } } } } }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Agency is new, it will return * an empty collection; or if this Agency has previously * been saved, it will retrieve related MissionsRelatedByOtherAgencyId 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 Agency. */ public function getMissionsRelatedByOtherAgencyIdJoinCoordinator($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(AgencyPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collMissionsRelatedByOtherAgencyId === null) { if ($this->isNew()) { $this->collMissionsRelatedByOtherAgencyId = array(); } else { $criteria->add(MissionPeer::OTHER_AGENCY_ID, $this->id); $this->collMissionsRelatedByOtherAgencyId = MissionPeer::doSelectJoinCoordinator($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(MissionPeer::OTHER_AGENCY_ID, $this->id); if (!isset($this->lastMissionRelatedByOtherAgencyIdCriteria) || !$this->lastMissionRelatedByOtherAgencyIdCriteria->equals($criteria)) { $this->collMissionsRelatedByOtherAgencyId = MissionPeer::doSelectJoinCoordinator($criteria, $con, $join_behavior); } } $this->lastMissionRelatedByOtherAgencyIdCriteria = $criteria; return $this->collMissionsRelatedByOtherAgencyId; }
/** * 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(MissionPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(MissionPeer::DATABASE_NAME); $criteria->add(MissionPeer::ID, $pks, Criteria::IN); $objs = MissionPeer::doSelect($criteria, $con); } return $objs; }
<td class="cell-1">Mission Date</td> <td class="cell-2">Passenger Name</td> <td class="cell-3">Pilot Name</td> <td class="cell-4">Date Received</td> </tr> </thead> <tbody> <?php $line = 0; ?> <?php foreach ($leg_list as $leg) { ?> <tr> <?php $mission = MissionPeer::retrieveByPK($leg->getMissionId()); ?> <td> <div class="date-list"> <?php echo $mission->getMissionDate('m/d/Y'); ?> <br/> <?php echo $mission->getExternalId(); ?> </div> </td> <td class="cell-3"> <div class="s-list"> <?php
/** * 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; }