public function getPassenger() { if (!$this->aPassenger instanceof Passenger) { $this->aPassenger = PassengerPeer::retrieveByPK($this->getPassengerId()); } return $this->aPassenger; }
public static function getForSelectParent() { $c = new Criteria(); $passengers = PassengerPeer::doSelectJoinPerson($c); $arr = array(); $arr[0] = '-- select --'; foreach ($passengers as $passenger) { $arr[$passenger->getId()] = $passenger->getPerson()->getName(); } return $arr; }
/** * 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 = PassengerPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setPersonId($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setPassengerTypeId($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setParent($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setDateOfBirth($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setIllness($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setFinancial($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setWeight($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setPublicConsiderations($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setPrivateConsiderations($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setReleasingPhysician($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setReleasingPhone($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setLodgingName($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setLodgingPhone($arr[$keys[13]]); } if (array_key_exists($keys[14], $arr)) { $this->setLodgingPhoneComment($arr[$keys[14]]); } if (array_key_exists($keys[15], $arr)) { $this->setFacilityName($arr[$keys[15]]); } if (array_key_exists($keys[16], $arr)) { $this->setFacilityCity($arr[$keys[16]]); } if (array_key_exists($keys[17], $arr)) { $this->setFacilityState($arr[$keys[17]]); } if (array_key_exists($keys[18], $arr)) { $this->setFacilityPhone($arr[$keys[18]]); } if (array_key_exists($keys[19], $arr)) { $this->setFacilityPhoneComment($arr[$keys[19]]); } if (array_key_exists($keys[20], $arr)) { $this->setRequesterId($arr[$keys[20]]); } if (array_key_exists($keys[21], $arr)) { $this->setMedicalReleaseRequested($arr[$keys[21]]); } if (array_key_exists($keys[22], $arr)) { $this->setMedicalReleaseReceived($arr[$keys[22]]); } if (array_key_exists($keys[23], $arr)) { $this->setPassengerIllnessCategoryId($arr[$keys[23]]); } if (array_key_exists($keys[24], $arr)) { $this->setReleasingFax1($arr[$keys[24]]); } if (array_key_exists($keys[25], $arr)) { $this->setReleasingFax1Comment($arr[$keys[25]]); } if (array_key_exists($keys[26], $arr)) { $this->setReleasingEmail($arr[$keys[26]]); } if (array_key_exists($keys[27], $arr)) { $this->setTreatingPhysician($arr[$keys[27]]); } if (array_key_exists($keys[28], $arr)) { $this->setTreatingPhone($arr[$keys[28]]); } if (array_key_exists($keys[29], $arr)) { $this->setTreatingFax1($arr[$keys[29]]); } if (array_key_exists($keys[30], $arr)) { $this->setTreatingFax1Comment($arr[$keys[30]]); } if (array_key_exists($keys[31], $arr)) { $this->setTreatingEmail($arr[$keys[31]]); } if (array_key_exists($keys[32], $arr)) { $this->setLanguageSpoken($arr[$keys[32]]); } if (array_key_exists($keys[33], $arr)) { $this->setBestContactMethod($arr[$keys[33]]); } if (array_key_exists($keys[34], $arr)) { $this->setEmergencyContactName($arr[$keys[34]]); } if (array_key_exists($keys[35], $arr)) { $this->setEmergencyContactPrimaryPhone($arr[$keys[35]]); } if (array_key_exists($keys[36], $arr)) { $this->setEmergencyContactSecondaryPhone($arr[$keys[36]]); } if (array_key_exists($keys[37], $arr)) { $this->setEmergencyContactPrimaryComment($arr[$keys[37]]); } if (array_key_exists($keys[38], $arr)) { $this->setEmergencyContactSecondaryComment($arr[$keys[38]]); } if (array_key_exists($keys[39], $arr)) { $this->setTravelHistoryNotes($arr[$keys[39]]); } if (array_key_exists($keys[40], $arr)) { $this->setNeedMedicalRelease($arr[$keys[40]]); } if (array_key_exists($keys[41], $arr)) { $this->setGroundTransportationComment($arr[$keys[41]]); } }
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(); } } } } }
/** * Save Edit Mission's Medical Release Date * CODE: */ public function executeEditMedicalDate(sfWebRequest $request) { if ($request->isMethod('post')) { $miss_id = $request->getParameter('miss_id', ''); $pass_id = $request->getParameter('passenger_id' . $miss_id, ''); $medical_date = $request->getParameter('medicalDate' . $miss_id, ''); if (isset($medical_date) && isset($pass_id)) { $passenger = PassengerPeer::retrieveByPK($pass_id); if (isset($passenger) && $passenger instanceof Passenger) { $passenger->setMedicalReleaseReceived($medical_date); if ($medical_date) { $passenger->setNeedMedicalRelease(1); } else { $passenger->setNeedMedicalRelease(0); } $passenger->save(); $this->date = $passenger->getMedicalReleaseReceived(); } } } }
/** * Selects a collection of CampPassenger objects pre-filled with all related objects except Camp. * * @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 CampPassenger objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptCamp(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { foreach (sfMixer::getCallables('BaseCampPassengerPeer:doSelectJoinAllExcept:doSelectJoinAllExcept') as $callable) { call_user_func($callable, 'BaseCampPassengerPeer', $c, $con); } $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); } CampPassengerPeer::addSelectColumns($c); $startcol2 = CampPassengerPeer::NUM_COLUMNS - CampPassengerPeer::NUM_LAZY_LOAD_COLUMNS; PassengerPeer::addSelectColumns($c); $startcol3 = $startcol2 + (PassengerPeer::NUM_COLUMNS - PassengerPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(CampPassengerPeer::PASSENGER_ID), array(PassengerPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = CampPassengerPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = CampPassengerPeer::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 = CampPassengerPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); CampPassengerPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Passenger rows $key2 = PassengerPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = PassengerPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = PassengerPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); PassengerPeer::addInstanceToPool($obj2, $key2); } // if $obj2 already loaded // Add the $obj1 (CampPassenger) to the collection in $obj2 (Passenger) $obj2->addCampPassenger($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
public function executeGetPassengerLodgingAndFacility() { $id = $this->getRequestParameter('id'); $passenger = PassengerPeer::retrieveByPK($id); $data = array('lodging' => '', 'facility' => '', 'lodging_phone' => '', 'facility_phone' => '', 'lodging_phone_comment' => '', ' facility_phone_comment' => '', ' facility_city' => '', 'facility_state' => ''); if ($passenger) { $data['lodging'] = $passenger->getLodgingName(); $data['facility'] = $passenger->getFacilityName(); $data['lodging_phone'] = $passenger->getLodgingPhone(); $data['facility_phone'] = $passenger->getFacilityPhone(); $data['lodging_phone_comment'] = $passenger->getLodgingPhoneComment(); $data['facility_phone_comment'] = $passenger->getFacilityPhoneComment(); $data['facility_city'] = $passenger->getFacilityCity(); $data['facility_state'] = $passenger->getFacilityState(); } return $this->renderText(json_encode($data)); }
/** * Get the associated Passenger object * * @param PropelPDO Optional Connection object. * @return Passenger The associated Passenger object. * @throws PropelException */ public function getPassenger(PropelPDO $con = null) { if ($this->aPassenger === null && $this->passenger_id !== null) { $c = new Criteria(PassengerPeer::DATABASE_NAME); $c->add(PassengerPeer::ID, $this->passenger_id); $this->aPassenger = PassengerPeer::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->aPassenger->addCompanions($this); */ } return $this->aPassenger; }
public static function doSelectJoinCustom(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { foreach (sfMixer::getCallables('MissionPeer:doSelectJoinCustom:doSelectJoinCustom') as $callable) { call_user_func($callable, 'MissionPeer', $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); } MissionPeer::addSelectColumns($c); $startcol2 = MissionPeer::NUM_COLUMNS - MissionPeer::NUM_LAZY_LOAD_COLUMNS; ItineraryPeer::addSelectColumns($c); $startcol3 = $startcol2 + (ItineraryPeer::NUM_COLUMNS - ItineraryPeer::NUM_LAZY_LOAD_COLUMNS); MissionTypePeer::addSelectColumns($c); $startcol4 = $startcol3 + (MissionTypePeer::NUM_COLUMNS - MissionTypePeer::NUM_LAZY_LOAD_COLUMNS); PassengerPeer::addSelectColumns($c); $startcol5 = $startcol4 + (PassengerPeer::NUM_COLUMNS - PassengerPeer::NUM_LAZY_LOAD_COLUMNS); MissionLegPeer::addSelectColumns($c); $startcol6 = $startcol5 + (MissionLegPeer::NUM_COLUMNS - MissionLegPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(MissionPeer::ITINERARY_ID), array(ItineraryPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::MISSION_TYPE_ID), array(MissionTypePeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::PASSENGER_ID), array(PassengerPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::ID), array(MissionLegPeer::MISSION_ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = MissionPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = MissionPeer::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 = MissionPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); MissionPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Itinerary rows $key2 = ItineraryPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = ItineraryPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = ItineraryPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); ItineraryPeer::addInstanceToPool($obj2, $key2); } // if obj2 loaded // Add the $obj1 (Mission) to the collection in $obj3 (Itinerary) $obj2->addMission($obj1); } // if joined row not null // Add objects for joined MissionType rows $key3 = MissionTypePeer::getPrimaryKeyHashFromRow($row, $startcol3); if ($key3 !== null) { $obj3 = MissionTypePeer::getInstanceFromPool($key3); if (!$obj3) { $omClass = MissionTypePeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj3 = new $cls(); $obj3->hydrate($row, $startcol3); MissionTypePeer::addInstanceToPool($obj3, $key3); } // if obj3 loaded // Add the $obj1 (Mission) to the collection in $obj3 (MissionType) $obj3->addMission($obj1); } // if joined row not null // Add objects for joined Passenger rows $key4 = PassengerPeer::getPrimaryKeyHashFromRow($row, $startcol4); if ($key4 !== null) { $obj4 = PassengerPeer::getInstanceFromPool($key4); if (!$obj4) { $omClass = PassengerPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj4 = new $cls(); $obj4->hydrate($row, $startcol4); PassengerPeer::addInstanceToPool($obj4, $key4); } // if obj4 loaded // Add the $obj1 (Mission) to the collection in $obj4 (Passenger) $obj4->addMission($obj1); } // if joined row not null // Add objects for joined MissionLeg rows $key5 = MissionLegPeer::getPrimaryKeyHashFromRow($row, $startcol5); if ($key5 !== null) { $obj5 = MissionLegPeer::getInstanceFromPool($key5); if (!$obj5) { $omClass = MissionLegPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj5 = new $cls(); $obj5->hydrate($row, $startcol5); MissionLegPeer::addInstanceToPool($obj5, $key5); } // if obj5 loaded // Add the $obj1 (Mission) to the collection in $obj5 (MissionLeg) $obj5->setMission($obj1); } // if joined row not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
public static function getEmailAddressesOfPersonsRelatedToMission(Mission $mission) { $receivers = array(); // Get Passenger email address $passenger = PassengerPeer::retrieveByPK($mission->getPassengerId()); if ($passenger) { $passenger = $passenger->getPerson()->getEmail(); if (!empty($passenger)) { // $receivers['passenger_'.$mission->getId()] = $passenger; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $passenger)) { $receivers[] = $passenger; } } } unset($passenger); // Get Requester email address $requestr = RequesterPeer::retrieveByPK($mission->getRequesterId()); if ($requestr) { $requestr = $requestr->getPerson()->getEmail(); if (!empty($requestr)) { // $receivers['requestr_'.$mission->getId()] = $requestr; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $requestr)) { $receivers[] = $requestr; } } } unset($requestr); // Get Coordinator email address $coordinator = CoordinatorPeer::retrieveByPK($mission->getCoordinatorId()); if ($coordinator && ($coordinator = $coordinator->getMember())) { $coordinator = $coordinator->getPerson()->getEmail(); if (!empty($coordinator)) { // $receivers['coordinator_'.$mission->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 Other Requester email address $other_requestr = RequesterPeer::retrieveByPK($mission->getOtherRequesterId()); if ($other_requestr) { $other_requestr = $other_requestr->getPerson()->getEmail(); if (!empty($other_requestr)) { // $receivers['other_requestr_'.$mission->getId()] = $other_requestr; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $other_requestr)) { $receivers[] = $other_requestr; } } } unset($other_requestr); // Get Other Agency email address $other_agency = AgencyPeer::retrieveByPK($mission->getOtherAgencyId()); if ($other_agency) { $other_agency = $other_agency->getEmail(); if (!empty($other_requestr)) { // $receivers['other_agency_'.$mission->getId()] = $other_agency; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $other_agency)) { $receivers[] = $other_agency; } } } unset($other_agency); // Get Agency email address $agency = AgencyPeer::retrieveByPK($mission->getAgencyId()); if ($agency) { $agency = $agency->getEmail(); if (!empty($agency)) { // $receivers['agency_'.$mission->getId()] = $agency; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $agency)) { $receivers[] = $agency; } } } unset($agency); return $receivers; }
/** * 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(PassengerPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(PassengerPeer::DATABASE_NAME); $criteria->add(PassengerPeer::ID, $pks, Criteria::IN); $objs = PassengerPeer::doSelect($criteria, $con); } return $objs; }
public function executePassengercompanions(sfWebRequest $request) { $id = $request->getParameter('id'); $this->passenger = PassengerPeer::retrieveByPK($id); }
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'); } } }
/** * Selects a collection of Mission objects pre-filled with all related objects except Coordinator. * * @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 Mission objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptCoordinator(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); } MissionPeer::addSelectColumns($c); $startcol2 = MissionPeer::NUM_COLUMNS - MissionPeer::NUM_LAZY_LOAD_COLUMNS; MissionRequestPeer::addSelectColumns($c); $startcol3 = $startcol2 + (MissionRequestPeer::NUM_COLUMNS - MissionRequestPeer::NUM_LAZY_LOAD_COLUMNS); ItineraryPeer::addSelectColumns($c); $startcol4 = $startcol3 + (ItineraryPeer::NUM_COLUMNS - ItineraryPeer::NUM_LAZY_LOAD_COLUMNS); MissionTypePeer::addSelectColumns($c); $startcol5 = $startcol4 + (MissionTypePeer::NUM_COLUMNS - MissionTypePeer::NUM_LAZY_LOAD_COLUMNS); PassengerPeer::addSelectColumns($c); $startcol6 = $startcol5 + (PassengerPeer::NUM_COLUMNS - PassengerPeer::NUM_LAZY_LOAD_COLUMNS); RequesterPeer::addSelectColumns($c); $startcol7 = $startcol6 + (RequesterPeer::NUM_COLUMNS - RequesterPeer::NUM_LAZY_LOAD_COLUMNS); AgencyPeer::addSelectColumns($c); $startcol8 = $startcol7 + (AgencyPeer::NUM_COLUMNS - AgencyPeer::NUM_LAZY_LOAD_COLUMNS); RequesterPeer::addSelectColumns($c); $startcol9 = $startcol8 + (RequesterPeer::NUM_COLUMNS - RequesterPeer::NUM_LAZY_LOAD_COLUMNS); AgencyPeer::addSelectColumns($c); $startcol10 = $startcol9 + (AgencyPeer::NUM_COLUMNS - AgencyPeer::NUM_LAZY_LOAD_COLUMNS); CampPeer::addSelectColumns($c); $startcol11 = $startcol10 + (CampPeer::NUM_COLUMNS - CampPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(MissionPeer::REQUEST_ID), array(MissionRequestPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::ITINERARY_ID), array(ItineraryPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::MISSION_TYPE_ID), array(MissionTypePeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::PASSENGER_ID), array(PassengerPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::REQUESTER_ID), array(RequesterPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::AGENCY_ID), array(AgencyPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::OTHER_REQUESTER_ID), array(RequesterPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::OTHER_AGENCY_ID), array(AgencyPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::CAMP_ID), array(CampPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = MissionPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = MissionPeer::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 = MissionPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); MissionPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined MissionRequest rows $key2 = MissionRequestPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = MissionRequestPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = MissionRequestPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); MissionRequestPeer::addInstanceToPool($obj2, $key2); } // if $obj2 already loaded // Add the $obj1 (Mission) to the collection in $obj2 (MissionRequest) $obj2->addMission($obj1); } // if joined row is not null // Add objects for joined Itinerary rows $key3 = ItineraryPeer::getPrimaryKeyHashFromRow($row, $startcol3); if ($key3 !== null) { $obj3 = ItineraryPeer::getInstanceFromPool($key3); if (!$obj3) { $omClass = ItineraryPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj3 = new $cls(); $obj3->hydrate($row, $startcol3); ItineraryPeer::addInstanceToPool($obj3, $key3); } // if $obj3 already loaded // Add the $obj1 (Mission) to the collection in $obj3 (Itinerary) $obj3->addMission($obj1); } // if joined row is not null // Add objects for joined MissionType rows $key4 = MissionTypePeer::getPrimaryKeyHashFromRow($row, $startcol4); if ($key4 !== null) { $obj4 = MissionTypePeer::getInstanceFromPool($key4); if (!$obj4) { $omClass = MissionTypePeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj4 = new $cls(); $obj4->hydrate($row, $startcol4); MissionTypePeer::addInstanceToPool($obj4, $key4); } // if $obj4 already loaded // Add the $obj1 (Mission) to the collection in $obj4 (MissionType) $obj4->addMission($obj1); } // if joined row is not null // Add objects for joined Passenger rows $key5 = PassengerPeer::getPrimaryKeyHashFromRow($row, $startcol5); if ($key5 !== null) { $obj5 = PassengerPeer::getInstanceFromPool($key5); if (!$obj5) { $omClass = PassengerPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj5 = new $cls(); $obj5->hydrate($row, $startcol5); PassengerPeer::addInstanceToPool($obj5, $key5); } // if $obj5 already loaded // Add the $obj1 (Mission) to the collection in $obj5 (Passenger) $obj5->addMission($obj1); } // if joined row is not null // Add objects for joined Requester rows $key6 = RequesterPeer::getPrimaryKeyHashFromRow($row, $startcol6); if ($key6 !== null) { $obj6 = RequesterPeer::getInstanceFromPool($key6); if (!$obj6) { $omClass = RequesterPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj6 = new $cls(); $obj6->hydrate($row, $startcol6); RequesterPeer::addInstanceToPool($obj6, $key6); } // if $obj6 already loaded // Add the $obj1 (Mission) to the collection in $obj6 (Requester) $obj6->addMissionRelatedByRequesterId($obj1); } // if joined row is not null // Add objects for joined Agency rows $key7 = AgencyPeer::getPrimaryKeyHashFromRow($row, $startcol7); if ($key7 !== null) { $obj7 = AgencyPeer::getInstanceFromPool($key7); if (!$obj7) { $omClass = AgencyPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj7 = new $cls(); $obj7->hydrate($row, $startcol7); AgencyPeer::addInstanceToPool($obj7, $key7); } // if $obj7 already loaded // Add the $obj1 (Mission) to the collection in $obj7 (Agency) $obj7->addMissionRelatedByAgencyId($obj1); } // if joined row is not null // Add objects for joined Requester rows $key8 = RequesterPeer::getPrimaryKeyHashFromRow($row, $startcol8); if ($key8 !== null) { $obj8 = RequesterPeer::getInstanceFromPool($key8); if (!$obj8) { $omClass = RequesterPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj8 = new $cls(); $obj8->hydrate($row, $startcol8); RequesterPeer::addInstanceToPool($obj8, $key8); } // if $obj8 already loaded // Add the $obj1 (Mission) to the collection in $obj8 (Requester) $obj8->addMissionRelatedByOtherRequesterId($obj1); } // if joined row is not null // Add objects for joined Agency rows $key9 = AgencyPeer::getPrimaryKeyHashFromRow($row, $startcol9); if ($key9 !== null) { $obj9 = AgencyPeer::getInstanceFromPool($key9); if (!$obj9) { $omClass = AgencyPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj9 = new $cls(); $obj9->hydrate($row, $startcol9); AgencyPeer::addInstanceToPool($obj9, $key9); } // if $obj9 already loaded // Add the $obj1 (Mission) to the collection in $obj9 (Agency) $obj9->addMissionRelatedByOtherAgencyId($obj1); } // if joined row is not null // Add objects for joined Camp rows $key10 = CampPeer::getPrimaryKeyHashFromRow($row, $startcol10); if ($key10 !== null) { $obj10 = CampPeer::getInstanceFromPool($key10); if (!$obj10) { $omClass = CampPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj10 = new $cls(); $obj10->hydrate($row, $startcol10); CampPeer::addInstanceToPool($obj10, $key10); } // if $obj10 already loaded // Add the $obj1 (Mission) to the collection in $obj10 (Camp) $obj10->addMission($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
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; }
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; break; } } if ($print) { //$assigned_pass = CampPilotPassengerPeer::getByCamp($camp_id); $pass = PassengerPeer::retrieveByPK($passengers[$u]); $camp_passenger = CampPassengerPeer::retrieveByPK($camp->getId(), $passengers[$u]); $passenger_link = null; if ($camp_passenger && $camp_passenger->getLink() != null) { $passenger_link = PassengerPeer::retrieveByPK($camp_passenger->getLink()); } $person = $pass->getPerson(); ?> <tr id="<?php echo $person->getId(); ?> "> <td <?php if ($passenger_link) { echo 'rowspan=2 valign=middle'; } ?> > <input type="hidden" id="person_id" name="person_id" value="<?php echo $person->getId();
/** * 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()); }
} ?> value="commercial_mission">Commercial Mission</option> </select> <div id="message_display"></div> </dd> </dl> <dl> <dt>Passenger:</dt> <dd> <?php if ($itinerary->getPassengerId()) { ?> <?php $passenger = PassengerPeer::retrieveByPK($itinerary->getPassengerId()); ?> <?php if ($passenger) { ?> <?php $person = PersonPeer::retrieveByPK($passenger->getPersonId()); ?> <a href="<?php echo url_for('passenger/view?id=' . $passenger->getId()); ?> "> <?php if (isset($person)) { ?> <?php
$li = 0; ?> <?php foreach ($mission_assistants as $mission_assistant) { ?> <?php $member = MemberPeer::retrieveByPK($mission_assistant->getMemberId()); ?> <?php if ($member->getPersonId()) { ?> <?php $m_person = $member->getPerson(); ?> <?php $m_pass = PassengerPeer::getByPersonId($m_person->getId()); ?> <?php } ?> <?php if (isset($m_person)) { ?> <div class="mission-dtls"> <dl> <dt><?php $count++; $li++; ?> </dt> <label><input type="radio" id="<?php
<?php $mission = $mission_leg->getMission(); $passenger = $mission->getPassenger(); // Camp information if ($mission->getCampId()) { $camp = CampPeer::retrieveByPK($mission->getCampId()); } // Passenger Information $pass_person = PersonPeer::retrieveByPK($passenger->getPersonId()); //Requester $requester = RequesterPeer::retrieveByPK($mission->getRequesterId()); $req_person = PersonPeer::retrieveByPK($requester->getPersonId()); $req_passenger = PassengerPeer::getByPersonId($requester->getPersonId()); //Mission Coordinator if ($mission->getCoordinatorId()) { $misscoordinator = CoordinatorPeer::retrieveByPK($mission->getCoordinatorId()); if ($misscoordinator->getMemberId()) { $missCoordiPerson = PersonPeer::retrieveByPK($misscoordinator->getMember()->getPersonId()); } } //Coordinator if ($mission_leg->getCoordinatorId()) { $coordinator = CoordinatorPeer::retrieveByPK($mission_leg->getCoordinatorId()); if ($coordinator->getMemberId()) { $coordiPerson = PersonPeer::retrieveByPK($coordinator->getMember()->getPersonId()); } } $baggageWeight = $mission_leg->getBaggageWeight(); $baggageDesc = $mission_leg->getBaggageDesc(); if ($mission_leg->getFboId()) {
<td>Date of birth</td> <td>Action</td> </tr> </thead> <tbody> <?php foreach ($companions as $companion) { ?> <?php $pass_id = $companion->getPassengerId(); ?> <?php if ($pass_id) { ?> <?php $person_id = PassengerPeer::retrieveByPK($pass_id)->getPersonId(); ?> <?php $person = PersonPeer::retrieveByPK($person_id); ?> <?php } ?> <tr> <td class="cell-1"> <?php if (isset($person)) { echo $person->getFirstName(); } ?> </td>
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this PassengerIllnessCategory is new, it will return * an empty collection; or if this PassengerIllnessCategory has previously * been saved, it will retrieve related Passengers 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 PassengerIllnessCategory. */ public function getPassengersJoinRequester($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(PassengerIllnessCategoryPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collPassengers === null) { if ($this->isNew()) { $this->collPassengers = array(); } else { $criteria->add(PassengerPeer::PASSENGER_ILLNESS_CATEGORY_ID, $this->id); $this->collPassengers = PassengerPeer::doSelectJoinRequester($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(PassengerPeer::PASSENGER_ILLNESS_CATEGORY_ID, $this->id); if (!isset($this->lastPassengerCriteria) || !$this->lastPassengerCriteria->equals($criteria)) { $this->collPassengers = PassengerPeer::doSelectJoinRequester($criteria, $con, $join_behavior); } } $this->lastPassengerCriteria = $criteria; return $this->collPassengers; }
public function executeUpdateFacLodAjax(sfWebRequest $request) { $passenger_id = $request->getParameter('faclodpassid'); $this->passid = $passenger_id; //echo $passenger_id; die(); $this->passenger = PassengerPeer::retrieveByPK($passenger_id); $passenger = $this->passenger; $this->setLayout(false); $facandlod = new PassengerDest(); $this->form6 = new PassengerDestForm($facandlod); $this->back = $request->getReferer(); if ($request->isMethod('post')) { $this->referer = $request->getReferer(); $this->form6->bind($request->getParameter('passDest')); $this->form6->isValid(); //foreach ($this->form6->getGlobalErrors() as $name => $error){ //echo $name.': '.$error.'<br/>'; //} //var_dump($this->form6->getErrorSchema()->getErrors()); //die(); if ($this->form6->isValid() && $passenger_id) { $passenger->setFacilityName($this->form6->getValue('facility')); $passenger->setLodgingName($this->form6->getValue('lodging')); $passenger->setFacilityPhone($this->form6->getValue('fac_phone')); $passenger->setFacilityPhoneComment($this->form6->getValue('facility_phone_comment')); $passenger->setLodgingPhone($this->form6->getValue('lod_phone')); $passenger->setLodgingPhoneComment($this->form6->getValue('lod_phone_comment')); $passenger->setFacilityCity($this->form6->getValue('facility_city')); $passenger->setFacilityState($this->form6->getValue('facility_state')); $passenger->save(); $this->form6->getObject()->setPassengerId($passenger_id); $this->form6->save(); /* $facandlod->setPassengerId($passenger_id); $facandlod->setLodging($this->form6->getValue('lodging_name')); //echo $this->form6->getValue('lodging_phone'); die(); $facandlod->setLodgingPhone($this->form6->getValue('lodging_phone')); $facandlod->setLodgingPhoneComment($this->form6->getValue('lodging_phone_comment')); $facandlod->setFacility($this->form6->getValue('facility_name')); $facandlod->setFacilityPhone($this->form6->getValue('facility_phone')); $facandlod->setFacilityPhoneComment($this->form6->getValue('facility_phone_comment')); $facandlod->setFacilityCity($this->form6->getValue('facility_city')); $facandlod->setFacilityState($this->form6->getValue('facility_state')); $facandlod->save(); */ $content = array('lodging' => '', 'facility' => '', 'lodging_phone' => '', 'facility_phone' => '', 'lodging_phone_comment' => '', ' facility_phone_comment' => '', ' facility_city' => '', 'facility_state' => ''); if ($passenger) { $content['lodging'] = $passenger->getLodgingName(); $content['facility'] = $passenger->getFacilityName(); $content['lodging_phone'] = $passenger->getLodgingPhone(); $content['facility_phone'] = $passenger->getFacilityPhone(); $content['lodging_phone_comment'] = $passenger->getLodgingPhoneComment(); $content['facility_phone_comment'] = $passenger->getFacilityPhoneComment(); $content['facility_city'] = $passenger->getFacilityCity(); $content['facility_state'] = $passenger->getFacilityState(); } $data = array('html' => false, 'content' => $content); return $this->renderText(json_encode($data)); } } $data = array('html' => true); $data['content'] = $this->renderPartial('updateFacLodAjaxSuccess', array('passid' => $passenger_id, 'passenger' => $this->passenger, 'form6' => $this->form6, 'back' => $this->back)); return $this->renderText(json_encode($data)); }
<?php echo $mission->getMissionDate('m/d/Y'); ?> <br/> <?php echo $mission->getExternalId(); ?> </div> </td> <td class="cell-3"> <div class="s-list"> <?php if (isset($mission)) { ?> <?php $pass = PassengerPeer::retrieveByPK($mission->getPassengerId()); ?> <?php if (isset($pass)) { $per = PersonPeer::retrieveByPK($pass->getPersonId()); ?> <?php if ($per) { ?> <?php echo $per->getTitle() . $per->getFirstName() . ' ' . $per->getLastName(); ?> <?php } ?> <?php
</td> <td> <?php if (isset($is_member)) { if ($sf_user->hasCredential(array('Administrator'), false)) { echo link_to('remove', '@default?module=member&action=delete&id=' . $is_member->getId(), array('method' => 'delete', 'confirm' => 'Are you sure to remove ', 'class' => 'action-remove')); } } ?> </td> </tr> <tr> <td class="cell-1">Passenger</td> <td> <?php $passenger = PassengerPeer::getByPersonId($person->getId()); ?> <?php if (!$passenger) { ?> <?php $linkp = 'add'; ?> <?php } else { ?> <?php $linkp = 'active'; ?> <?php }