public function configure() { $yes_no = array(1 => 'Yes', 0 => 'No'); unset($this['id'], $this['airport_id']); $airports = AirportPeer::getForSelectParent(); $phone_options = array('mask' => '(999) 999-9999', 'ok_class' => 'field_ok', 'holder_class' => 'field_hold'); # Fields // $this->widgetSchema['airport_id'] = new sfWidgetFormChoice(array('choices' => $airports)); $this->widgetSchema['name'] = new sfWidgetFormInput(array(), array('class' => 'text')); $this->widgetSchema['address'] = new sfWidgetFormInput(array(), array('class' => 'text')); $this->widgetSchema['voice_phone'] = new widgetFormInputPhone($phone_options, array('class' => 'text narrow')); $this->widgetSchema['fax_phone'] = new widgetFormInputPhone($phone_options, array('class' => 'text narrow')); $this->widgetSchema['fuel_discount'] = new sfWidgetFormInput(array(), array('class' => 'text narrow')); $this->widgetSchema['discount_amount'] = new sfWidgetFormSelectRadio(array('choices' => $yes_no, 'formatter' => array($this, 'formatterRaw'))); // $this->widgetSchema->setLabels(array('airport_id' => 'Airport')); $this->widgetSchema->setLabels(array('name' => 'Name')); $this->widgetSchema->setLabels(array('address' => 'Address')); $this->widgetSchema->setLabels(array('voice_phone' => 'Voice Phone')); $this->widgetSchema->setLabels(array('fax_phone' => 'Fax Phone')); $this->widgetSchema->setLabels(array('fuel_discount' => 'Discount Amount')); $this->widgetSchema->setLabels(array('discount_amount' => 'Fuel Discount')); // $this->validatorSchema['airport_id'] = new sfValidatorInteger(array('required' => true),array('invalid'=>'Co donor id must be in number format !')); $this->validatorSchema['name'] = new sfValidatorString(array('required' => true), array('required' => 'Please confirm a name !')); $this->validatorSchema['address'] = new sfValidatorString(array('required' => false)); $this->validatorSchema['voice_phone'] = new sfValidatorString(array('required' => false)); $this->validatorSchema['fax_phone'] = new sfValidatorString(array('required' => false)); $this->validatorSchema['discount_amount'] = new sfValidatorChoice(array('choices' => array_keys($yes_no), 'required' => false)); $this->validatorSchema['fuel_discount'] = new sfValidatorNumber(array('required' => false), array('invalid' => 'Please Insert Numbers only')); $this->widgetSchema->setNameFormat('fbo[%s]'); }
/** * Add/edit a pilot * CODE: pilot_create */ public function executeUpdate(sfWebRequest $request) { 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->getParameter('member_id')) { $this->member = MemberPeer::retrieveByPK($request->getParameter('member_id')); $pilot = new Pilot(); $this->title = 'Add Pilot'; } if ($request->getParameter('id')) { $pilot = PilotPeer::retrieveByPK($request->getParameter('id')); $this->forward404Unless($pilot); ///ziyed//// $this->url = $request->getReferer(); if (strstr($this->url, '/pilot/mopAdd')) { $this->title = 'Add mop pilot'; $success = 'MOP information has been successfully added!'; } else { $this->title = 'Edit pilot'; $success = 'Pilot information has been successfully changed!'; $this->current_region = $pilot->getMopRegionsServed(); $this->mopservedby = $pilot->getMopServedBy(); } ////end////// $this->member = MemberPeer::retrieveByPK($pilot->getMemberId()); if ($pilot->getPrimaryAirportId()) { $this->airport_id = $pilot->getPrimaryAirportId(); } $this->airports = AirportPeer::doSelect(new Criteria()); } else { $pilot = new Pilot(); $this->title = 'Add Pilot'; $success = 'Pilot information has been successfully created!'; } $this->airport = trim($this->getRequestParameter('airport', '*')) == '' ? '*' : trim($this->getRequestParameter('airport', '*')); if ($request->getParameter('leg')) { $this->leg_id = $request->getParameter('leg'); } if ($request->getParameter('back')) { $this->backup = $request->getParameter('back'); } if ($request->getParameter('co')) { $this->backup_co = $request->getParameter('co'); } if ($request->getParameter('member')) { $this->member = MemberPeer::retrieveByPK($request->getParameter('member')); } $this->form = new PilotForm($pilot); $this->pilot = $pilot; $this->back = $request->getReferer(); ///////////////////Update /////////// if ($request->isMethod('post')) { $this->referer = $request->getReferer(); $this->form->bind($request->getParameter('pilo')); if ($this->form->isValid() && $this->form->getValue('license_type')) { if ($request->getParameter('member_id')) { $pilot->setMemberId($request->getParameter('member_id')); } //TODO:Set Member Flight status to command pilot $set_member = MemberPeer::retrieveByPK($request->getParameter('member_id')); if ($set_member) { $set_member->setFlightStatus('Command pilot'); $set_member->save(); } if ($request->getParameter('airport') != null) { $airport = AirportPeer::getByIdent($request->getParameter('airport')); if (isset($airport) && $airport instanceof Airport) { $pilot->setPrimaryAirportId($airport->getId()); } } else { $pilot->setPrimaryAirportId(null); $member = MemberPeer::retrieveByPK($request->getParameter('member_id')); $member->setFlightStatus('Non-pilot'); $member->save(); } $pilot->setSecondaryHomeBases($this->form->getValue('secondary_home_bases')); $pilot->setTotalHours($this->form->getValue('total_hours')); $pilot->setLicenseType($this->form->getValue('license_type')); if ($this->form->getValue('ifr') == null) { $pilot->setIfr(0); } else { $pilot->setIfr($this->form->getValue('ifr')); } if ($this->form->getValue('multi_engine') == null) { $pilot->setMultiEngine(0); } else { $pilot->setMultiEngine($this->form->getValue('multi_engine')); } $pilot->setSeInstructor($this->form->getValue('se_instructor')); $pilot->setMeInstructor($this->form->getValue('me_instructor')); $pilot->setOtherRatings($this->form->getValue('other_ratings')); $pilot->setInsuranceReceived($this->form->getValue('insurance_received')); //ziyed task $pilot->setOrientedDate($this->form->getValue('oriented_date')); $pilot->setMopOrientedDate($this->form->getValue('mop_oriented_date')); if ($request->getParameter('pilot_name')) { $pilot->setMopServedBy($request->getParameter('pilot_name')); } else { $pilot->setMopServedBy(NULL); } // $pilot->setMopRegionsServed($request->getParameter('mop_regions_served')); if ($request->getParameter('mop_regions_served')) { $pilot->setMopRegionsServed($request->getParameter('mop_regions_served')); } else { $a = null; $pilot->setMopRegionsServed($a); } //$pilot->setOrientedMemberId($this->form->getValue('oriented_member_id')); //$pilot->setOrientedMemberId($this->form->getValue('mop_oriented_member_id')); //$pilot->setMopQualifications($this->form->getValue('mop_qualifications')); $pilot->setHseats($this->form->getValue('hseats')); if ($this->form->getValue('transplant') == 1) { $pilot->setTransplant(1); } else { $pilot->setTransplant(0); } $pilot->save(); $this->getUser()->setFlash('success', $success); $last = $request->getParameter('back'); $back_url = 'pilot'; if (strstr($last, 'member/view')) { $back_url = '@member_view?id=' . $request->getParameter('member_id'); } elseif (strstr($last, 'pilot/view')) { $back_url = '@pilot_view?id=' . $pilot->getId(); } elseif (strstr($last, 'pilot/edit')) { $back_url = '@pilot_view?id=' . $pilot->getId(); } elseif (strstr($last, 'pilot/mopAdd')) { $back_url = '/pilot/mopAdd'; } if ($request->getParameter('leg_id')) { $back_url = '@leg_edit?id=' . $request->getParameter('leg_id'); } if ($request->getParameter('leg_id')) { if ($request->getParameter('leg_id') && !$request->getParameter('backup')) { $set_leg = MissionLegPeer::retrieveByPK($request->getParameter('leg_id')); if (isset($set_leg) && $set_leg instanceof MissionLeg) { $set_leg->setPilotId($pilot->getId()); $set_leg->save(); $this->getUser()->setFlash('success', 'Mission Leg #' . $set_leg->getId() . ' \\s Pilot has been set!'); } $back_url = '@leg_edit?id=' . $request->getParameter('leg_id'); } } if ($request->getParameter('leg_id')) { if ($request->getParameter('leg_id') && $request->getParameter('backup')) { $set_leg = MissionLegPeer::retrieveByPK($request->getParameter('leg_id')); if (isset($set_leg) && $set_leg instanceof MissionLeg) { $set_leg->setBackupPilotId($pilot->getId()); $set_leg->save(); $this->getUser()->setFlash('success', 'Mission Leg #' . $set_leg->getId() . ' \\s Backup Pilot has been set!'); } $back_url = '@leg_edit?id=' . $request->getParameter('leg_id'); } } if ($request->getParameter('leg_id')) { if ($request->getParameter('leg_id') && $request->getParameter('backup_co')) { $set_leg = MissionLegPeer::retrieveByPK($request->getParameter('leg_id')); if (isset($set_leg) && $set_leg instanceof MissionLeg) { $set_leg->setBackupCopilotId($request->getParameter('member_id')); $set_leg->save(); $this->getUser()->setFlash('success', 'Mission Leg #' . $set_leg->getId() . ' \\s Backup Co-Pilot has been set!'); } $back_url = '@leg_edit?id=' . $request->getParameter('leg_id'); } } return $this->redirect($back_url); } else { if (!$request->getParameter('id')) { $info = 'Please confirm License type and choose Member !'; } else { $info = 'Please confirm License type !'; } $this->getUser()->setFlash('success', $info); } } else { # Set referer URL $this->referer = $request->getReferer() ? $request->getReferer() : '@pilot'; } $this->pilot = $pilot; }
?> <?php $agency = AgencyPeer::retrieveByPK($agency_id); ?> <?php } ?> <?php $airport_id = $camp->getAirportId(); ?> <?php if ($airport_id) { ?> <?php $airport = AirportPeer::retrieveByPK($airport_id); ?> <?php } ?> <tr> <td class="cell-1"> <?php if ($camp->getCampName()) { echo $camp->getCampName(); } ?> </td> <td class="cell-2"> <?php
public function configure() { unset($this['id'], $this['secondary_home_bases'], $this['member_id'], $this['oriented_member_id'], $this['oriented_date'], $this['mop_oriented_member_id'], $this['mop_oriented_date'], $this['mop_regions_served'], $this['mop_qualifications']); $airports = AirportPeer::getForSelectParent(); # Fields // $this->widgetSchema['primary_airport_id'] = new sfWidgetFormChoice(array('choices' => $airports),array('class'=>'text')); $this->widgetSchema['secondary_home_bases'] = new sfWidgetFormInput(array(), array('class' => 'text')); $this->widgetSchema['total_hours'] = new sfWidgetFormInput(array(), array('class' => 'text')); $this->widgetSchema['license_type'] = new sfWidgetFormInput(array(), array('class' => 'text')); $this->widgetSchema['ifr'] = new sfWidgetFormInputCheckbox(array(), array('value' => 1)); $this->widgetSchema['multi_engine'] = new sfWidgetFormInputCheckbox(array(), array('value' => 1)); $this->widgetSchema['se_instructor'] = new sfWidgetFormInput(array(), array('class' => 'text')); $this->widgetSchema['me_instructor'] = new sfWidgetFormInput(array(), array('class' => 'text')); $this->widgetSchema['other_ratings'] = new sfWidgetFormInput(array(), array('class' => 'text')); $this->widgetSchema['insurance_received'] = new widgetFormDate(array('change_year' => true, 'change_month' => true, 'format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text narrow')); // $this->widgetSchema['oriented_member_id'] = new sfWidgetFormInput(); $this->widgetSchema['oriented_date'] = new widgetFormDate(array('change_year' => true, 'change_month' => true, 'format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text narrow')); // $this->widgetSchema['mop_oriented_member_id'] = new sfWidgetFormInput(); $this->widgetSchema['mop_oriented_date'] = new widgetFormDate(array('change_year' => true, 'change_month' => true, 'format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text narrow')); //$this->widgetSchema['mop_regions_served'] = new sfWidgetFormInput(); // $this->widgetSchema['mop_qualifications'] = new sfWidgetFormInput(); $this->widgetSchema['hseats'] = new sfWidgetFormInput(array(), array('class' => 'text narrow')); $this->widgetSchema['transplant'] = new sfWidgetFormInputCheckbox(array(), array('value' => 1)); // $this->widgetSchema->setLabels(array('primary_airport_id' => 'Primary Airport Ident')); $this->widgetSchema->setLabels(array('secondary_home_bases' => 'Secondary Home Bases')); $this->widgetSchema->setLabels(array('total_hours' => 'Total Hours')); $this->widgetSchema->setLabels(array('license_type' => 'License Type')); $this->widgetSchema->setLabels(array('ifr' => 'Ifr')); $this->widgetSchema->setLabels(array('multi_engine' => 'Multi Engine')); $this->widgetSchema->setLabels(array('se_instructor' => 'Se Instructor')); $this->widgetSchema->setLabels(array('me_instructor' => 'Me Instructor')); $this->widgetSchema->setLabels(array('other_ratings' => 'Other Ratings')); $this->widgetSchema->setLabels(array('insurance_received' => 'Insurance Received')); // $this->widgetSchema->setLabels(array('oriented_member_id' => 'Oriented Member Id')); $this->widgetSchema->setLabels(array('oriented_date' => 'Oriented Date')); // $this->widgetSchema->setLabels(array('mop_oriented_member_id' => 'Mop Oriented Member Id')); $this->widgetSchema->setLabels(array('mop_oriented_date' => 'Mop Oriented Date')); //$this->widgetSchema->setLabels(array('mop_regions_served' => 'Regions Served')); // $this->widgetSchema->setLabels(array('mop_qualifications' => 'Mop Qualifications')); $this->widgetSchema->setLabels(array('hseats' => 'Seats')); $this->widgetSchema->setLabels(array('transplant' => 'Transplant')); // $this->validatorSchema['primary_airport_id'] = new sfValidatorInteger(array('required' => false)); $this->validatorSchema['secondary_home_bases'] = new sfValidatorString(array('required' => false)); $this->validatorSchema['total_hours'] = new sfValidatorInteger(array('required' => false), array('invalid' => 'Total hours must be in number format !')); $this->validatorSchema['license_type'] = new sfValidatorString(array('required' => true), array('required' => 'Please confirm licence type')); $this->validatorSchema['ifr'] = new sfValidatorInteger(array('required' => false)); $this->validatorSchema['multi_engine'] = new sfValidatorInteger(array('required' => false)); $this->validatorSchema['se_instructor'] = new sfValidatorString(array('required' => false)); $this->validatorSchema['me_instructor'] = new sfValidatorString(array('required' => false)); $this->validatorSchema['other_ratings'] = new sfValidatorString(array('required' => false)); $this->validatorSchema['insurance_received'] = new sfValidatorDate(array('required' => false), array('invalid' => 'Insurance received date invalid !.')); // $this->validatorSchema['oriented_member_id'] = new sfValidatorInteger(array('required' => false)); $this->validatorSchema['oriented_date'] = new sfValidatorDate(array('required' => false), array('invalid' => 'Oriented date invalid !.')); // $this->validatorSchema['mop_oriented_member_id'] = new sfValidatorInteger(array('required' => false)); $this->validatorSchema['mop_oriented_date'] = new sfValidatorDate(array('required' => false), array('invalid' => 'MOP Oriented date invalid !.')); //$this->validatorSchema['mop_regions_served'] = new sfValidatorString(array('required' => true)); // $this->validatorSchema['mop_qualifications'] = new sfValidatorString(array('required' => true)); $this->validatorSchema['hseats'] = new sfValidatorString(array('required' => false)); $this->validatorSchema['transplant'] = new sfValidatorInteger(array('required' => false)); $this->widgetSchema->setNameFormat('pilo[%s]'); }
/** * Selects a collection of Pilot objects pre-filled with all related objects except PilotRelatedByMopOrientedMemberId. * * @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 Pilot objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptPilotRelatedByMopOrientedMemberId(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); } PilotPeer::addSelectColumns($c); $startcol2 = PilotPeer::NUM_COLUMNS - PilotPeer::NUM_LAZY_LOAD_COLUMNS; MemberPeer::addSelectColumns($c); $startcol3 = $startcol2 + (MemberPeer::NUM_COLUMNS - MemberPeer::NUM_LAZY_LOAD_COLUMNS); AirportPeer::addSelectColumns($c); $startcol4 = $startcol3 + (AirportPeer::NUM_COLUMNS - AirportPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(PilotPeer::MEMBER_ID), array(MemberPeer::ID), $join_behavior); $c->addJoin(array(PilotPeer::PRIMARY_AIRPORT_ID), array(AirportPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = PilotPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = PilotPeer::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 = PilotPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); PilotPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Member rows $key2 = MemberPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = MemberPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = MemberPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); MemberPeer::addInstanceToPool($obj2, $key2); } // if $obj2 already loaded // Add the $obj1 (Pilot) to the collection in $obj2 (Member) $obj2->addPilot($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 (Pilot) to the collection in $obj3 (Airport) $obj3->addPilot($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
<li> Country: <?php echo $person->getCountry() ? $person->getCountry() : '--'; ?> </li> <?php $airport = $pilot = null; ?> <?php $pilot = $member->getPilot(); ?> <?php if ($pilot && $pilot->getPrimaryAirportId()) { ?> <?php $airport = AirportPeer::retrieveByPK($pilot->getPrimaryAirportId()); ?> <?php } ?> <?php if ($airport) { ?> <li>Airport</li> <li>Identifier: <?php echo $airport->getIdent(); ?> </li> <li>Name: <?php echo $airport->getName(); ?>
public function executeAjaxAirport(sfWebRequest $request) { $airports = AirportPeer::getByWingId($request->getParameter('wing_id')); $html = '<select class="text narrow">'; foreach ($airports as $airport) { $html .= '<option value="' . $airport->getId() . '">' . $airport->getIdent() . '</option>'; } $html .= '</select>'; return $this->renderText($html); }
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 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; }
/** * Selects a collection of Fbo objects pre-filled with all related objects. * * @param Criteria $c * @param PropelPDO $con * @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN * @return array Array of Fbo objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAll(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { foreach (sfMixer::getCallables('BaseFboPeer:doSelectJoinAll:doSelectJoinAll') as $callable) { call_user_func($callable, 'BaseFboPeer', $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); } FboPeer::addSelectColumns($c); $startcol2 = FboPeer::NUM_COLUMNS - FboPeer::NUM_LAZY_LOAD_COLUMNS; AirportPeer::addSelectColumns($c); $startcol3 = $startcol2 + (AirportPeer::NUM_COLUMNS - AirportPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(FboPeer::AIRPORT_ID), array(AirportPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = FboPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = FboPeer::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 = FboPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); FboPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Airport rows $key2 = AirportPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = AirportPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = AirportPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); AirportPeer::addInstanceToPool($obj2, $key2); } // if obj2 loaded // Add the $obj1 (Fbo) to the collection in $obj2 (Airport) $obj2->addFbo($obj1); } // if joined row not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
protected function processStep3Check(sfWebRequest $request) { $default_airport = AirportPeer::getByIdent(sfConfig::get('app_default_airport_ident')); $this->forward404Unless($default_airport); $app = $this->application_temp; $person = $this->person; if (!$person instanceof Person) { $person = new Person(); } /* @var $app ApplicationTemp */ /* @var $person Person */ // Person $tmp_arr = $app->toArray(BasePeer::TYPE_FIELDNAME); $tmp_arr['evening_phone'] = $tmp_arr['eve_phone']; $tmp_arr['evening_comment'] = $tmp_arr['eve_comment']; unset($tmp_arr['id']); $person->fromArray($tmp_arr, BasePeer::TYPE_FIELDNAME); $person->save(); // Member $member = MemberPeer::getByPersonId($person->getId()); if (!$member instanceof Member) { $member = new Member(); } // Generate external id using last member is and external id $c = new Criteria(); $c->add(MemberPeer::EXTERNAL_ID, NULL, Criteria::ISNOTNULL); $c->addDescendingOrderByColumn(MemberPeer::ID); $external_member = MemberPeer::doSelectOne($c); $external_id = $external_member->getExternalId(); $currentExternalId = $external_id + 1; //print_r($external_id); //print_r($currentExternalId); $member->setActive(1); $member->setCoPilot($app->getApplicantCopilot()); $member->setContact('By Email'); $member->setDateOfBirth($app->getDateOfBirth()); $member->setDriversLicenseState($app->getDriversLicenseState()); $member->setDriversLicenseNumber($app->getDriversLicenseNumber()); $member->setEmergencyContactName($app->getEmergencyContactName()); $member->setEmergencyContactPhone($app->getEmergencyContactPhone()); $member->setFlightStatus($app->getApplicantPilot() ? 'Verify Orientation' : 'Non-pilot'); $member->setJoinDate(time()); $member->setLanguages($app->getLanguagesSpoken()); //$member->setMasterMemberId($app->getMasterMemberId()); $member->setMemberClassId($app->getMemberClassId()); $member->setPersonId($person->getId()); $member->setRenewedDate(time()); $member->setRenewalDate(strtotime('+1 year')); $member->setSpouseName($app->getSpouseFirstName() . ' ' . $app->getSpouseLastName()); //external_id generate $member->setExternalId($currentExternalId); $member->setWingId($app->getWingId()); $member->save(); // Pilot if ($app->getApplicantPilot()) { $pilot = new Pilot(); $pilot->setMemberId($member->getId()); $airport = AirportPeer::getByIdent($app->getHomeBase()); if (!$airport instanceof Airport) { $airport = $default_airport; } $pilot->setPrimaryAirportId($airport->getId()); $pilot->setTotalHours($app->getTotalHours()); $pilot->setLicenseType('Private'); foreach (sfConfig::get('app_pilot_license_types') as $key => $val) { if (stripos($app->getRatings(), $key) !== false) { $pilot->setLicenseType($key); } } $pilot->setIfr(stripos($app->getRatings(), 'ifr') !== false ? 1 : 0); $pilot->setMultiEngine(stripos($app->getRatings(), 'multi') !== false ? 1 : 0); $pilot->setSeInstructor('No'); // @see ApplicationForm foreach (sfConfig::get('app_pilot_se_instructor') as $key => $val) { if (stripos($app->getRatings(), $key) !== false) { $pilot->setSeInstructor($key); } } $pilot->setMeInstructor($pilot->getSeInstructor()); $pilot->save(); // Availability $availability = new Availability(); $availability->setMemberId($member->getId()); $availability->setNotAvailable(0); $availability->setNoWeekday($app->getAvailabilityWeekdays() == 0); $availability->setNoNight($app->getAvailabilityWeeknights() == 0); $availability->setLastMinute($app->getAvailabilityLastMinute()); $availability->setAsMissionMssistant($app->getAvailabilityCopilot()); $availability->setNoWeekend($app->getAvailabilityWeekends() == 0); try { $availability->save(); } catch (Exception $e) { } // Primary aircraft if ($app->getAircraftPrimaryId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftPrimaryId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftPrimaryNNumber()); $pilot_aircraft->setOwn($app->getAircraftPrimaryOwn()); $pilot_aircraft->setSeats($app->getAircraftPrimarySeats()); $pilot_aircraft->setKnownIce($app->getAircraftPrimaryIce()); $pilot_aircraft->save(); } // Secondary aircraft if ($app->getAircraftSecondaryId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftSecondaryId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftSecondaryNNumber()); $pilot_aircraft->setOwn($app->getAircraftSecondaryOwn()); $pilot_aircraft->setSeats($app->getAircraftSecondarySeats()); $pilot_aircraft->setKnownIce($app->getAircraftSecondaryIce()); $pilot_aircraft->save(); } // Third aircraft if ($app->getAircraftThirdId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftThirdId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftThirdNNumber()); $pilot_aircraft->setOwn($app->getAircraftThirdOwn()); $pilot_aircraft->setSeats($app->getAircraftThirdSeats()); $pilot_aircraft->setKnownIce($app->getAircraftThirdIce()); $pilot_aircraft->save(); } } // Application_temp $app->setPersonId($person->getId()); $app->setMemberId($member->getId()); $app->setProcessedDate(time()); $app->save(); // Application $tmp_arr = $app->toArray(BasePeer::TYPE_FIELDNAME); $tmp_arr['date'] = $tmp_arr['application_date']; $tmp_arr['company'] = $tmp_arr['company_name']; foreach (sfConfig::get('app_pilot_license_types') as $key => $val) { if (stripos($tmp_arr['ratings'], $key) !== false) { $tmp_arr['license_type'] = $key; } } $tmp_arr['ifr'] = stripos($tmp_arr['ratings'], 'ifr') !== false ? 1 : 0; $tmp_arr['multi_engine'] = stripos($tmp_arr['ratings'], 'multi') !== false ? 1 : 0; $tmp_arr['se_instructor'] = 'No'; // @see ApplicationForm foreach (sfConfig::get('app_pilot_se_instructor') as $key => $val) { if (stripos($tmp_arr['ratings'], $key) !== false) { $tmp_arr['se_instructor'] = $key; } } $tmp_arr['me_instructor'] = $tmp_arr['se_instructor']; $tmp_arr['other_ratings'] = $tmp_arr['ratings']; $tmp_arr['fbo'] = $tmp_arr['fbo_name']; $tmp_arr['member_meetings'] = 0; $tmp_arr['executive_board'] = 0; $tmp_arr['dues_amount_paid'] = $tmp_arr['dues_amount_paid'] ? $tmp_arr['dues_amount_paid'] : 0; unset($tmp_arr['id']); $application = new Application(); $application->fromArray($tmp_arr, BasePeer::TYPE_FIELDNAME); $application->save(); $where = $request->getParameter('step3_redirect'); //Ziyed save default role for new member $appTemp = $this->application_temp; if ($appTemp->getPersonId()) { $person_role = new PersonRole(); $person_role->setPersonId($appTemp->getPersonId()); if ($appTemp->getApplicantPilot() == 1) { $person_role->setRoleId(27); } else { $person_role->setRoleId(31); } $person_role->save(); } //Ziyed end save if ($where == 1) { $this->redirect('@member_view?id=' . $member->getId()); } else { /* if ($application->getEmail()) { # send email failure to payment $this->getComponent('mail', 'memberApplicationProcessed', array('email' => $application->getEmail(),'member_id'=>$member->getId(), 'name' => $application->getFirstName() . ' ' . $application->getLastName())); }*/ $this->redirect('pending_member/processComplete?id=' . $member->getId()); } }
<td> </td> </tr> <?php $count = 1; foreach ($camp_passengers_return as $camp_passenger) { ?> <?php $passenger = $camp_passenger->getPassenger(); ?> <?php if ($camp_passenger->getReturnAirportId()) { $air_port = AirportPeer::retrieveByPK($camp_passenger->getReturnAirportId()); ?> <?php } elseif ($camp_passenger->getAirportId()) { $air_port = AirportPeer::retrieveByPK($camp_passenger->getAirportId()); } ?> <tr class="passenger <?php if ($count % 2 != 0) { echo ' alt'; } ?> " id="passenger_<?php echo $passenger->getId(); ?> "> <td><?php echo $count++; ?> </td>
public function executePilotRequestAcceptedView(sfWebRequest $request) { #security if (!$this->getUser()->hasCredential(array('Administrator', 'Pilot', 'Staff', 'Coordinator', 'Volunteer'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } $person = PersonPeer::retrieveByPK($this->getUser()->getId()); $this->forward404Unless($person); $member = $person->getMember(); if ($member) { $pilot = $member->getPilot(); } else { $pilot = null; } $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->getParameter('needs') == 1) { $this->needs_pilot = 1; } $c = new Criteria(); $c->add(PilotRequestPeer::ACCEPTED, 1); $c->add(PilotRequestPeer::MEMBER_ID, $member->getId()); $c->addJoin(PilotRequestPeer::LEG_ID, MissionLegPeer::ID); $c->addJoin(MissionLegPeer::MISSION_ID, MissionPeer::ID); //$this->result = MissionPeer::doSelect($c); $this->page = $request->getParameter("page", 1); $this->max = $request->getParameter("max", 10); $this->pager = new sfPropelPager('MissionLeg', $this->max); $this->pager->setCriteria($c); $this->pager->setPage($this->page); $this->pager->init(); $this->miss_legs = $this->pager->getResults(); $this->url = 'pilotRequestAcceptedView'; }
/** * Mission Leg Edit * CODE: mission_leg_create */ public function executeUpdate(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'); } $this->errors = array(); // for validation $this->orig_set = ''; $this->dest_set = ''; if ($request->getParameter('id')) { $this->title = 'Edit Mission Leg'; $this->leg = MissionLegPeer::retrieveByPK($request->getParameter('id')); if ($this->leg->getFromAirportId()) { $this->fromAirport = $this->leg->getAirportRelatedByFromAirportId(); } if ($this->leg->getToAirportId()) { $this->toAirport = $this->leg->getAirportRelatedBytoAirportId(); } if ($this->leg->getCoordinatorId()) { $this->coordinator = CoordinatorPeer::retrieveByPK($this->leg->getCoordinatorId()); } //print_r($this->coordinator); if ($this->leg->getFboId()) { $this->fbo = FboPeer::retrieveByPK($this->leg->getFboId()); $this->fbo_address = $this->leg->getFboId(); } if ($this->leg->getBackupPilotId()) { $this->backup_pilot = PilotPeer::retrieveByPK($this->leg->getBackupPilotId()); if (isset($this->backup_pilot) && $this->backup_pilot instanceof Pilot) { $this->bp_person = $this->backup_pilot->getMember()->getPerson(); } } if ($this->leg->getBackupCopilotId()) { $this->backup_co_pilot = PilotPeer::retrieveByPK($this->leg->getBackupCopilotId()); if (isset($this->backup_co_pilot) && $this->backup_co_pilot instanceof Pilot) { $this->bp_co_person = $this->backup_co_pilot->getMember()->getPerson(); } } if ($this->leg->getWaiverReceived()) { $this->waiver_rec = $this->leg->getWaiverReceived(); } else { $this->waiver_rec = ''; } if ($this->leg->getFboAddressNew()) { $this->new_fbo_address = $this->leg->getFboAddressNew(); } else { $this->new_fbo_address = ''; } $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); $this->forward404Unless($this->leg); $this->mission = $this->leg->getMission(); $this->passenger = $this->mission->getPassenger(); $this->person = $this->passenger->getPerson(); $this->member = MemberPeer::getByPersonId($this->person->getId()); /*echo "<pre>"; print_r($this->member ); */ /* if(isset($this->member) && $this->member instanceof Member){ $this->pilot = PilotPeer::getByMemberId($this->member->getId()); } /* if(isset($this->leg) && $this->leg instanceof MissionLeg){ $this->pilot = PilotPeer::retrieveByPK($this->leg->getPilotId()); } * */ 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()); //echo "<pre>"; //print_r($this->mission_assistant); $this->back_up_mission_assistant = PilotPeer::retrieveByPK($this->leg->getBackupMissAssisId()); } if ($this->leg->getMissAssisId()) { $this->mission_assistant = PilotPeer::getByMemberId($this->leg->getMissAssisId()); } } //echo "<pre>"; //print_r($this->pilot_member); $is_pilot_requested = PilotRequestPeer::getByLegId($this->leg->getId()); if (isset($is_pilot_requested) && $is_pilot_requested instanceof PilotRequest) { $this->p_req = $is_pilot_requested; } /* echo "<pre>"; print_r($this->person->getId()); die(); */ $this->forward404Unless($this->mission); $mission_id = $this->mission->getId(); } else { $this->title = 'Add Mission Leg'; $this->leg = new MissionLeg(); $mission_id = $request->hasParameter('mis') ? $request->getParameter('mis') : $request->getParameter('mission_id'); $this->mission = MissionPeer::retrieveByPK($mission_id); $this->forward404Unless($this->mission); } if ($request->isMethod('post')) { if ($request->getParameter('transportation') == 'air_mission') { # AIR MISSION if ($request->getParameter('orgin_airport')) { $o_airport = AirportPeer::getByIdent($request->getParameter('orgin_airport')); if (!$o_airport instanceof Airport) { $this->errors[] = 'Origin airport not found in database'; } } else { $this->errors[] = 'Please specify origin airport'; } if ($request->getParameter('dest_airport')) { $d_airport = AirportPeer::getByIdent($request->getParameter('dest_airport')); if (!$d_airport instanceof Airport) { $this->errors[] = 'Destination airport not found in database'; } } else { $this->errors[] = 'Please specify destination airport'; } if (count($this->errors) == 0) { $mission_leg = $this->leg; $mission_leg->setMissionId($mission_id); $mission_leg->setCancelled($request->getParameter('cancelled')); if ($mission_leg->isNew()) { $mission_leg->setLegNumber(MissionLegPeer::getMaxLegNumber($mission_id) + 1); } $mission_leg->setFromAirportId($o_airport->getId()); $mission_leg->setToAirportId($d_airport->getId()); $o_air = AirportPeer::retrieveByPK($o_airport->getId()); $d_air = AirportPeer::retrieveByPK($d_airport->getId()); $distances = MissionLegPeer::getDistance($o_air->getIdent(), $d_air->getIdent()); //$mission_leg->setBaggageWeight($request->getParameter('baggage_weight')); //$mission_leg->setBaggageDesc($request->getParameter('baggage_desc')); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('air_mission'); $mission_leg->save(); $id = $mission_leg->getId(); $leg = MissionLegPeer::retrieveByPK($id); $leg->setReverseFrom($id); $leg->save(); } } elseif ($request->getParameter('transportation') == 'ground_mission') { # GROUND MISSION $origin = $request->getParameter('ground_origin'); $destination = $request->getParameter('ground_destination'); $orgintset = $request->getParameter('orig_set'); $desttset = $request->getParameter('dest_set'); $fbo_address = $request->getParameter('fbo_address'); $this->orig_set = $orgintset; $this->dest_set = $desttset; $this->fbo_address = $fbo_address; if (empty($destination) && empty($desttset)) { $this->errors[] = 'Please specify destination address'; } if (empty($origin) && empty($orgintset)) { $this->errors[] = 'Please specify origin address'; } elseif ($destination == $origin && $destination != '') { $this->errors[] = 'Origin and Destination addresses conflict'; } if (empty($fbo_address)) { $this->errors[] = 'Please specify FBO name'; } if (count($this->errors) == 0) { $mission_leg = $this->leg; $mission_leg->setMissionId($mission_id); if ($mission_leg->isNew()) { $mission_leg->setLegNumber(MissionLegPeer::getMaxLegNumber($mission_id) + 1); } $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('ground_mission'); //get addresses by type $p = $this->passenger = $this->mission->getPassenger(); if ($p instanceof Passenger) { $this->person = $p->getPerson(); } $this->ground_addresses = array('patient' => '', 'facility' => '', 'lodging' => ''); $orgintsetsave = $request->getParameter('ground_origin'); if (empty($orgintsetsave)) { $orgintsetsave = $request->getParameter('orig_set'); } $desttsetsave = $request->getParameter('ground_destination'); if (empty($desttsetsave)) { $desttsetsave = $request->getParameter('dest_set'); } $mission_leg->setGroundOrigin($orgintsetsave); $mission_leg->setGroundDestination($desttsetsave); $mission_leg->setFboId($fbo_address); //ziyed $fbo_address_new = $request->getParameter('fbo_address_new'); $mission_leg->setFboAddressNew($fbo_address_new); //end ziyed $mission_leg->save(); $id = $mission_leg->getId(); $leg = MissionLegPeer::retrieveByPK($id); $leg->setReverseFrom($id); $leg->save(); } } elseif ($request->getParameter('transportation') == 'commercial_mission') { # COMMERCIAL MISSION $airline_id = $request->getParameter('airline_id'); if ($airline_id) { $custom = $request->getParameter('airline_custom'); if ($airline_id == 'other') { if (empty($custom)) { $this->errors[] = 'Please type a new airline name!'; } } else { $airline = AirlinePeer::retrieveByPK($airline_id = $request->getParameter('airline_id')); if (!$airline instanceof Airline) { $this->errors[] = 'Please select airline!'; } } } else { $this->errors[] = 'Please select airline!'; } $origin = $request->getParameter('origin'); $destination = $request->getParameter('destination'); if (empty($origin)) { $this->errors[] = 'Please specify origin'; } if (empty($destination)) { $this->errors[] = 'Please specify destination'; } if (count($this->errors) == 0) { $flight_time = $request->getParameter('flight_time'); if (empty($flight_time['hour']) || empty($flight_time['minute'])) { $flight_time = null; } $airline_id = $request->getParameter('airline_id'); if ($airline_id == 'other') { $airline = new Airline(); $airline->setName($request->getParameter('airline_custom')); $airline->save(); } else { $airline = AirlinePeer::retrieveByPK($airline_id); $this->forward404Unless($airline); } $flight_number = $request->getParameter('flight_number'); $departure = $request->getParameter('departure'); $arrival = $request->getParameter('arrival'); $mission_leg = $this->leg; $mission_leg->setMissionId($this->mission->getId()); if ($mission_leg->isNew()) { $mission_leg->setLegNumber(MissionLegPeer::getMaxLegNumber($mission_id) + 1); } $mission_leg->setFlightTime($flight_time ? strtotime($flight_time['hour'] . ':' . $flight_time['minute'] . ' ' . $flight_time['period']) : null); //$mission_leg->setBaggageDesc($request->getParameter('baggage_desc')); //$mission_leg->setBaggageWeight($request->getParameter('baggage_weight')); $mission_leg->setAirlineId($airline->getId()); $mission_leg->setFundId($request->getParameter('fund_id')); $mission_leg->setConfirmCode($request->getParameter('confirm_code')); $mission_leg->setFlightCost($request->getParameter('flight_cost')); $mission_leg->setCommOrigin($origin); $mission_leg->setCommDest($destination); $mission_leg->setFlightNumber($flight_number); $v = $departure; if (empty($v[0]['hour']) || empty($v[0]['minute'])) { $v = null; } $mission_leg->setDeparture($v ? strtotime($v[0]['hour'] . ':' . $v[0]['minute'] . ' ' . $v[0]['period']) : null); $v = $arrival; if (empty($v[0]['hour']) || empty($v[0]['minute'])) { $v = null; } $mission_leg->setArrival($v ? strtotime($v[0]['hour'] . ':' . $v[0]['minute'] . ' ' . $v[0]['period']) : null); $mission_leg->setTransportation('commercial_mission'); $mission_leg->save(); } } else { $this->forward404(); } if (count($this->errors) == 0) { $this->getUser()->setFlash('success', 'New Mission leg has successfully created!'); if ($request->getParameter('add_another')) { $this->redirect('@leg_create?mis=' . $this->mission->getId()); } else { $this->redirect('@mission_view?id=' . $this->mission->getId()); } } } $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); //echo '<pre>';print_r($this->date_widget); $this->time_widget = new widgetFormTime(); $this->airport_list = AirportPeer::getMappable(); $this->airlines = AirlinePeer::doSelect(new Criteria()); $this->funds = FundPeer::doSelect(new Criteria()); $p = $this->passenger = $this->mission->getPassenger(); if ($p instanceof Passenger) { $this->person = $p->getPerson(); } else { unset($this->passenger); } $this->itinerary = $this->mission->getItinerary(); //echo '<pre>';print_r($this->itinerary); // 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(); } if ($this->passenger) { $this->ground_addresses['lodging'] = $this->passenger->getLodgingName() . ' ' . $this->ground_addresses['lodging']; $this->ground_addresses['facility'] = $this->passenger->getFacilityName() . ' ' . $this->ground_addresses['facility']; $this->ground_addresses['patient'] = $this->person->getAddress1() . ' ' . $this->person->getAddress2() . ' ' . $this->person->getCity() . ', ' . $this->person->getState() . ' ' . $this->person->getZipcode(); } }
public static function getByMayInterested($airport = null, $min_efficiency = 85) { $c = new Criteria(); $c->add(self::APPT_DATE, null, Criteria::ISNOTNULL); $c->add(self::MISSION_DATE, null, Criteria::ISNOTNULL); $c->add(self::CANCEL_MISSION, 1); $c->add(self::MISSION_DATE, date("Y/m/d", strtotime("now")), Criteria::GREATER_EQUAL); $c->addAnd(self::MISSION_DATE, date("Y/m/d", strtotime("+1 year")), Criteria::LESS_EQUAL); if ($min_efficiency && $airport) { $c->addJoin(self::ID, MissionLegPeer::MISSION_ID, Criteria::INNER_JOIN); $c->addJoin(MissionLegPeer::ID, PilotRequestPeer::LEG_ID, Criteria::LEFT_JOIN); $c->addJoin(MissionPeer::ITINERARY_ID, ItineraryPeer::ID, Criteria::INNER_JOIN); $c->add(MissionLegPeer::MISSION_REPORT_ID, null, Criteria::ISNULL); $c->addAlias('from_air', AirportPeer::TABLE_NAME); $c->addAlias('to_air', AirportPeer::TABLE_NAME); $c->addJoin(MissionLegPeer::FROM_AIRPORT_ID, AirportPeer::alias('from_air', AirportPeer::ID), Criteria::INNER_JOIN); $c->addJoin(MissionLegPeer::TO_AIRPORT_ID, AirportPeer::alias('to_air', AirportPeer::ID), Criteria::INNER_JOIN); $c->addAnd(MissionPeer::ID, "\n CEILING(ROUND(ACOS(SIN(RADIANS(from_air.latitude))\n *SIN(RADIANS(to_air.latitude))+COS(RADIANS(from_air.latitude))\n *COS(RADIANS(to_air.latitude))*COS(RADIANS(from_air.longitude)-RADIANS(to_air.longitude)))\n *((180*60)/PI()))/(ROUND(ACOS(SIN(RADIANS(from_air.latitude))\n *SIN(RADIANS(to_air.latitude))+COS(RADIANS(from_air.latitude))\n *COS(RADIANS(to_air.latitude))\n *\n COS(RADIANS(from_air.longitude)-RADIANS(to_air.longitude))\n ) * ((180*60)/PI())\n )\n +\n ROUND(\n ACOS(\n SIN(RADIANS({$airport->getLatitude()}))\n *\n SIN(RADIANS(to_air.latitude))\n +\n COS(RADIANS({$airport->getLatitude()}))\n *\n COS(RADIANS(to_air.latitude))\n *\n COS(RADIANS({$airport->getLongitude()})-RADIANS(to_air.longitude))\n ) * ((180*60)/PI())\n )\n +\n ROUND(\n ACOS(\n SIN(RADIANS({$airport->getLatitude()}))\n *\n SIN(RADIANS(from_air.latitude))\n +\n COS(RADIANS({$airport->getLatitude()}))\n *\n COS(RADIANS(from_air.latitude))\n *\n COS(RADIANS({$airport->getLongitude()})-RADIANS(from_air.longitude))\n ) * ((180*60)/PI()))) * 200) >= " . $min_efficiency, Criteria::CUSTOM); $c->add(MissionLegPeer::CANCELLED, null, Criteria::ISNULL); } $c->setDistinct(self::ID); $c->addAscendingOrderByColumn(self::MISSION_DATE); $c->setLimit(3); return self::doSelect($c); }
echo url_for($back); ?> " class="cancel">Cancel</a> </div> </div><!--box alt--> </form> </div><!--airport_form--> <script type="text/javascript"> //<![CDATA[ jQuery(document).ready(function() { <?php $idents = array(); $count = 0; $airpots = AirportPeer::doSelect(new Criteria()); $size = sizeof($airpots); for ($ii = 0; $ii < $size; $ii++) { $idents[] = "{$count} : '{$airpots[$ii]->getIdent()}'"; $count++; } ?> var sizeOf = <?php echo sizeof($idents); ?> ; var idents = {<?php echo join(',', $idents); ?> };
<?php echo $o_airport->getIdent() . ' ( ' . $o_airport->getCity() . ', ' . $o_airport->getState() . ' )'; ?> <?php } ?> <?php } ?> </td> <td class="cell-1"> <?php if ($mission_leg->getToAirportId()) { ?> <?php $d_airport = AirportPeer::retrieveByPK($mission_leg->getToAirportId()); ?> <?php if ($d_airport || $d_airport->getCity() || $d_airport->getState()) { ?> <?php echo $d_airport->getIdent() . ' ( ' . $d_airport->getCity() . ', ' . $d_airport->getState() . ' )'; ?> <?php } ?> <?php } ?> </td> <td class="cell-2">
/** * 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()); }
<thead> <tr> <td>Leg Number</td> <td colspan="2">Origin</td> <td colspan="2">Destination</td> <td>Action</td> </tr> </thead> <tbody> <?php foreach ($miss_legs as $leg) { ?> <?php if ($leg->getTransportation() == 'air_mission') { $from_airport = AirportPeer::retrieveByPK($leg->getFromAirportId()); $to_airport = AirportPeer::retrieveByPK($leg->getToAirportId()); if ($from_airport && $to_airport) { ?> <tr style="<?php echo $leg->getCancelled() ? 'color:gray' : ''; ?> "> <td class="cell-1"><?php echo $leg->getLegNumber(); ?> </td> <td class="cell-2"><?php echo $from_airport->getIdent(); ?> </td> <td class="cell-1"><?php
public function executeAutoCompleteAirSourceName(sfWebRequest $request) { $params = $request->getPostParameters(); foreach ($params as $key => $param) { if (substr($key, 0, 13) == 'airport_name_') { $this->keyword = $this->getRequestParameter($key); break; } } $this->airport_names = AirportPeer::getByAirportName($this->keyword); }
</strong> <?php if (isset($airport_from)) { if ($airport_from->getCity() || $airport_from->getState()) { echo '( ' . $airport_from->getCity() . ', ' . $airport_from->getState() . ' )'; } } ?> <em>PST</em> </dd> <dt>To:</dt> <dd> <strong> <?php if ($leg->getToAirportId()) { $airport_to = AirportPeer::retrieveByPK($leg->getToAirportId()); if (isset($airport_to)) { echo $airport_to->getIdent(); } } ?> </strong> <?php if (isset($airport_to)) { if ($airport_to->getCity() || $airport_to->getState()) { echo '( ' . $airport_to->getCity() . ', ' . $airport_to->getState() . ' )'; } } ?> <em>PST</em> </dd>
use_stylesheets_for_form($form_airport); use_javascripts_for_form($form_airport); use_helper('Javascript', 'Form'); use_helper('jQuery', 'Form'); ?> <?php use_helper('jQuery'); ?> <h2><?php echo $title; ?> </h2> <?php $airport_info = AirportPeer::retrieveByPK($camp->getAirportId()); ?> <div class="passenger-form"> <form action="<?php echo url_for('@camp_create'); ?> " method="post" id="camp_form"> <input type="hidden" name="id" value="<?php echo $camp->getId(); ?> " /> <input type="hidden" name="referer" value="<?php echo $referer; ?> " /> <div class="box full">
protected function processStep3Check(sfWebRequest $request) { $default_airport = AirportPeer::getByIdent(sfConfig::get('app_default_airport_ident')); $this->forward404Unless($default_airport); $app = $this->application_temp; $person = $this->person; if (!$person instanceof Person) { $person = new Person(); } /* @var $app ApplicationTemp */ /* @var $person Person */ // Person $tmp_arr = $app->toArray(BasePeer::TYPE_FIELDNAME); $tmp_arr['evening_phone'] = $tmp_arr['eve_phone']; $tmp_arr['evening_comment'] = $tmp_arr['eve_comment']; unset($tmp_arr['id']); $person->fromArray($tmp_arr, BasePeer::TYPE_FIELDNAME); $person->save(); // Member $member = MemberPeer::retrieveByPK($app->getMemberId()); if (!$member instanceof Member) { $member = new Member(); } $member->setActive(1); $member->setCoPilot($app->getApplicantCopilot()); $member->setContact('By Email'); $member->setDateOfBirth($app->getDateOfBirth()); $member->setDriversLicenseState($app->getDriversLicenseState()); $member->setDriversLicenseNumber($app->getDriversLicenseNumber()); $member->setEmergencyContactName($app->getEmergencyContactName()); $member->setEmergencyContactPhone($app->getEmergencyContactPhone()); $member->setFlightStatus($app->getApplicantPilot() ? 'Verify Orientation' : 'Non-pilot'); //$member->setJoinDate(time()); $member->setLanguages($app->getLanguagesSpoken()); //Farazi //$member->setMasterMemberId($app->getMasterMemberId()); // Get Last renewal date $this->member = MemberPeer::retrieveByPK($app->getMemberId()); $lastRenewalDate = strtotime($this->member->getRenewalDate()); $member->setMemberClassId($app->getMemberClassId()); $member->setPersonId($person->getId()); $member->setRenewedDate(time()); ///Farazi Renewal Date From Memberclass if ($app->getMemberClassId()) { $memclass = MemberClassPeer::retrieveByPK($app->getMemberClassId()); $renewal_period = $memclass->getRenewalPeriod(); $renewalTime = strtotime('+' . $renewal_period . ' month', $lastRenewalDate); //echo $renewalTime; $member->setRenewalDate($renewalTime); //$member->setRenewalDate(strtotime('+'.$renewal_period.' month')); } // Farazi End //$member->setRenewalDate(strtotime('+1 year')); $member->setSpouseName($app->getSpouseFirstName() . ' ' . $app->getSpouseLastName()); $member->setWeight($app->getWeight()); $member->setWingId($app->getWingId()); $member->save(); // Pilot if ($app->getApplicantPilot()) { $pilot = $member->getPilot(); if (!$pilot instanceof Pilot) { $pilot = new Pilot(); } if ($pilot->isNew()) { // remove aircrafts foreach ($member->getPilotAircrafts() as $p_a) { PilotAircraftPeer::doDelete($p_a); } } $pilot->setMemberId($member->getId()); $airport = AirportPeer::getByIdent($app->getHomeBase()); if (!$airport instanceof Airport) { $airport = $default_airport; } $pilot->setPrimaryAirportId($airport->getId()); $pilot->setTotalHours($app->getTotalHours()); $pilot->setLicenseType('Private'); foreach (sfConfig::get('app_pilot_license_types') as $key => $val) { if (stripos($app->getRatings(), $key) !== false) { $pilot->setLicenseType($key); } } $pilot->setIfr(stripos($app->getRatings(), 'ifr') !== false ? 1 : 0); $pilot->setMultiEngine(stripos($app->getRatings(), 'multi') !== false ? 1 : 0); $pilot->setSeInstructor('No'); // @see ApplicationForm foreach (sfConfig::get('app_pilot_se_instructor') as $key => $val) { if (stripos($app->getRatings(), $key) !== false) { $pilot->setSeInstructor($key); } } $pilot->setMeInstructor($pilot->getSeInstructor()); $pilot->save(); // Availability $availability = $member->getAvailability(); if (!$availability instanceof Availability) { $availability = new Availability(); } $availability->setMemberId($member->getId()); $availability->setNotAvailable(0); $availability->setNoWeekday($app->getAvailabilityWeekdays() == 0); $availability->setNoNight($app->getAvailabilityWeeknights() == 0); $availability->setLastMinute($app->getAvailabilityLastMinute()); $availability->setAsMissionMssistant($app->getAvailabilityCopilot()); $availability->setNoWeekend($app->getAvailabilityWeekends() == 0); $availability->save(); //Farazi //Delete all aircrafts $pilot_aircrafts = PilotAircraftPeer::getByMemberId($member->getId()); foreach ($pilot_aircrafts as $pilot_aircraft) { $pilot_aircraft->delete(); } // Primary aircraft if ($app->getAircraftPrimaryId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftPrimaryId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftPrimaryNNumber()); $pilot_aircraft->setOwn($app->getAircraftPrimaryOwn()); $pilot_aircraft->setSeats($app->getAircraftPrimarySeats()); $pilot_aircraft->setKnownIce($app->getAircraftPrimaryIce()); $pilot_aircraft->save(); } // Secondary aircraft if ($app->getAircraftSecondaryId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftSecondaryId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftSecondaryNNumber()); $pilot_aircraft->setOwn($app->getAircraftSecondaryOwn()); $pilot_aircraft->setSeats($app->getAircraftSecondarySeats()); $pilot_aircraft->setKnownIce($app->getAircraftSecondaryIce()); $pilot_aircraft->save(); } // Third aircraft if ($app->getAircraftThirdId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftThirdId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftThirdNNumber()); $pilot_aircraft->setOwn($app->getAircraftThirdOwn()); $pilot_aircraft->setSeats($app->getAircraftThirdSeats()); $pilot_aircraft->setKnownIce($app->getAircraftThirdIce()); $pilot_aircraft->save(); } } // Application_temp $app->setPersonId($person->getId()); $app->setMemberId($member->getId()); $app->setProcessedDate(time()); $app->save(); // Application $tmp_arr = $app->toArray(BasePeer::TYPE_FIELDNAME); $tmp_arr['date'] = $tmp_arr['application_date']; $tmp_arr['company'] = $tmp_arr['company_name']; foreach (sfConfig::get('app_pilot_license_types') as $key => $val) { if (stripos($tmp_arr['ratings'], $key) !== false) { $tmp_arr['license_type'] = $key; } } $tmp_arr['ifr'] = stripos($tmp_arr['ratings'], 'ifr') !== false ? 1 : 0; $tmp_arr['multi_engine'] = stripos($tmp_arr['ratings'], 'multi') !== false ? 1 : 0; $tmp_arr['se_instructor'] = 'No'; // @see ApplicationForm foreach (sfConfig::get('app_pilot_se_instructor') as $key => $val) { if (stripos($tmp_arr['ratings'], $key) !== false) { $tmp_arr['se_instructor'] = $key; } } $tmp_arr['me_instructor'] = $tmp_arr['se_instructor']; $tmp_arr['other_ratings'] = $tmp_arr['ratings']; $tmp_arr['fbo'] = $tmp_arr['fbo_name']; $tmp_arr['member_meetings'] = 0; $tmp_arr['executive_board'] = 0; $tmp_arr['dues_amount_paid'] = $tmp_arr['dues_amount_paid'] ? $tmp_arr['dues_amount_paid'] : 0; $tmp_arr['donation_amount_paid'] = $tmp_arr['donation_amount_paid'] ? $tmp_arr['donation_amount_paid'] : 0; unset($tmp_arr['id']); $application = new Application(); $application->fromArray($tmp_arr, BasePeer::TYPE_FIELDNAME); $application->save(); $this->getUser()->setFlash('success', 'Membership renewal completed successfully.'); //$this->redirect('renewal/processComplete?id='.$member->getId()); $this->redirect('renewal/processStep3?id=' . $this->application_temp->getId()); //$this->redirect('renewal/index?id='.$member->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 = AirportPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setIdent($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setName($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setCity($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setState($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setLatitude($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setLongitude($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setRunwayLength($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setWingId($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setGmtOffset($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setDstOffset($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setZipcode($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setClosed($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setFaaSiteNumber($arr[$keys[13]]); } if (array_key_exists($keys[14], $arr)) { $this->setAtct($arr[$keys[14]]); } if (array_key_exists($keys[15], $arr)) { $this->setIsPrivate($arr[$keys[15]]); } if (array_key_exists($keys[16], $arr)) { $this->setNonCommercialLandingFee($arr[$keys[16]]); } if (array_key_exists($keys[17], $arr)) { $this->setElevation($arr[$keys[17]]); } }
/** * Get the associated Airport object * * @param PropelPDO Optional Connection object. * @return Airport The associated Airport object. * @throws PropelException */ public function getAirport(PropelPDO $con = null) { if ($this->aAirport === null && $this->airport_id !== null) { $c = new Criteria(AirportPeer::DATABASE_NAME); $c->add(AirportPeer::ID, $this->airport_id); $this->aAirport = AirportPeer::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->aAirport->addCamps($this); */ } return $this->aAirport; }
/** * Show Itinerary details * CODE: itinerary_view */ public function executeDetail(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->orginset = ''; $this->destset = ''; $this->orgintset = ''; $this->desttset = ''; if ($request->getParameter('add_passengers')) { $this->group_camp_id = $request->getParameter('add_passengers'); } $this->mission; $this->mission2; $mission; $mission2; $this->ground_addr_sel = sfConfig::get('app_ground_address_type', array()); $this->errors = array(); $this->errors2 = array(); if ($request->getParameter('id')) { $this->itinerary = ItineraryPeer::retrieveByPK($request->getParameter('id')); $this->back = $request->getReferer(); //echo $this->itinerary->getId(); if (strstr($this->back, '/mission/view')) { $this->frommission = 1; } else { $this->frommission = 0; } $this->mis = MissionPeer::getMissionByItineraryId($this->itinerary->getId(), 1); $mission = $this->mis; /*echo "<pre>"; print_r($this->mis); echo "</pre>"; die("ok"); */ $this->mission = $mission; //print_r($mission); exit (); ///Show leges if (isset($mission)) { $this->mis_legs = MissionLegPeer::getbyMissId($mission->getId()); } //echo "<pre>"; //print_r($this->mis_legs); //echo $this->itinerary->getId(); $this->mis2 = MissionPeer::getMissionByItineraryId($this->itinerary->getId(), 2); /* echo "<pre>"; print_r($this->mis2); echo "</pre>"; die("ok"); */ $mission2 = $this->mis2; $this->mission2 = $mission2; $this->ground_addresses = array('patient' => '', 'facility' => '', 'lodging' => '', 'airport' => ''); $pass; $this->personnew; if ($this->itinerary) { $this->ground_addresses['lodging'] = $this->ground_addresses['facility'] = $this->itinerary->getDestCity() . ', ' . $this->itinerary->getDestState(); $pass = PassengerPeer::retrieveByPK($this->itinerary->getPassengerId()); $this->personnew = PersonPeer::retrieveByPK($pass->getPersonId()); } if ($pass) { $this->ground_addresses['lodging'] = $pass->getLodgingName() . ' ' . $this->ground_addresses['lodging']; $this->ground_addresses['facility'] = $pass->getFacilityName() . ' ' . $this->ground_addresses['facility']; $this->ground_addresses['patient'] = $this->personnew->getAddress1() . ' ' . $this->personnew->getAddress2() . ' ' . $this->personnew->getCity() . ', ' . $this->personnew->getState() . ' ' . $this->personnew->getZipcode(); $this->ground_addresses['airport'] = $this->personnew->getAddress1() . ' ' . $this->personnew->getAddress2() . ' ' . $this->personnew->getCity() . ', ' . $this->personnew->getState() . ' ' . $this->personnew->getZipcode(); } } if ($request->isMethod('post')) { if ($request->getParameter('com')) { if ($request->getParameter('com') == 1) { $mission->setComment($request->getParameter('mis_comment')); $mission->save(); } elseif ($request->getParameter('com') == 2) { $mission2->setComment($request->getParameter('mist_comment')); $mission2->save(); } $this->getUser()->setFlash('success', 'Comment successfully saved.'); } else { if ($request->getParameter('misstsave') == 1) { switch ($request->getParameter('transportation')) { case 'air_mission': $origin_airports = (array) $request->getParameter('origint_idents'); $dest_airports = (array) $request->getParameter('destinationt_idents'); $idents = $dest_airports; $tmp_arr = array(); foreach ($origin_airports as $i => $ident) { $idents[] = $ident; $v = $ident . ' to ' . $dest_airports[$i]; if (in_array($v, $tmp_arr)) { $this->errors2[] = 'Leg ' . $v . ' appeared more than one'; } else { $tmp_arr[] = $v; } if ($dest_airports[$i] == $ident) { $this->errors2[] = 'Leg ' . $ident . ' to ' . $dest_airports[$i] . ' is invalid'; } } $idents = array_unique($idents); $c = new Criteria(); $c->add(AirportPeer::IDENT, $idents, Criteria::IN); if (count($idents) != AirportPeer::doCount($c)) { $this->errors2[] = 'Some airport idents are invalid'; } break; case 'ground_mission': $origin = $request->getParameter('groundt_origin'); $destination = $request->getParameter('groundt_destination'); $orgintset = $request->getParameter('orgintset'); $desttset = $request->getParameter('desttset'); $this->desttset = $desttset; $this->orgintset = $orgintset; if (empty($destination) && empty($desttset)) { $this->errors2[] = 'Please specify destination address'; } if (empty($origin) && empty($orgintset)) { $this->errors2[] = 'Please specify origin address'; } elseif ($destination == $origin && $destination != '') { $this->errors2[] = 'Origin and Destination addresses conflict'; } break; case 'commercial_mission': $mission_date = $request->getParameter('mission_date'); if (empty($mission_date)) { $this->errors2[] = 'Mission date is required'; } if ($v = $request->getParameter('airline_id')) { $custom = $request->getParameter('airline_custom'); if ($v == 'other') { if (empty($custom)) { $this->errors2[] = 'Please type a new airline name!'; } } else { $airline = AirlinePeer::retrieveByPK($v = $request->getParameter('airline_id')); if (!$airline instanceof Airline) { $this->errors2[] = 'Please select airline!'; } } } else { $this->errors2[] = 'Please select airline!'; } break; default: $this->errors2[] = 'Please select Transportation Type'; } if (count($this->errors2)) { # error in form switch ($request->getParameter('transportation')) { case 'air_mission': $this->origin_idents = $origin_airports; $this->dest_idents = $dest_airports; break; case 'ground_mission': break; case 'commercial_mission': break; } $this->erer = 2; } else { $missioncount = MissionLegPeer::getMaxLegNumber($mission2->getId()); switch ($request->getParameter('transportation')) { case 'air_mission': $aircount = MissionLegPeer::getCountbyMissIdAndType($mission2->getId(), 'air_mission'); for ($i = 0; $i < sizeof($origin_airports); $i++) { $airport_o = AirportPeer::getByIdent($origin_airports[$i]); $airport_d = AirportPeer::getByIdent($dest_airports[$i]); $missioncount++; $aircount++; $mission_leg = new MissionLeg(); $mission_leg->setMissionId($mission2->getId()); $mission_leg->setLegNumber($missioncount); $mission_leg->setFromAirportId($airport_o->getId()); $mission_leg->setToAirportId($airport_d->getId()); $mission_leg->setPrefix('air' . $aircount); //$mission_leg->setBaggageWeight($request->getParameter('baggage_weight')); //$mission_leg->setBaggageDesc($request->getParameter('baggage_desc')); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('air_mission'); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); } $this->getUser()->setFlash('success', 'Mission and Leg #' . $mission_leg->getMissionId() . '-' . $mission_leg->getLegNumber() . ' has successfully created!'); return $this->redirect('/itinerary/detail/' . $this->itinerary->getId()); break; case 'ground_mission': $groundcount = MissionLegPeer::getCountbyMissIdAndType($mission2->getId(), 'ground_mission'); $mission_leg = new MissionLeg(); $orgintsetsave = $request->getParameter('groundt_origin'); if (empty($orgintsetsave)) { $orgintsetsave = $request->getParameter('orgintset'); } $desttsetsave = $request->getParameter('groundt_destination'); if (empty($desttsetsave)) { $desttsetsave = $request->getParameter('desttset'); } $groundcount++; $sas = $missioncount + 1; $mission_leg->setMissionId($mission2->getId()); $mission_leg->setLegNumber($sas); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('ground_mission'); $mission_leg->setGroundOrigin($orgintsetsave); $mission_leg->setGroundDestination($desttsetsave); $mission_leg->setPrefix('g' . $groundcount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $this->getUser()->setFlash('success', 'Mission and Leg #' . $mission_leg->getMissionId() . '-' . $mission_leg->getLegNumber() . ' has successfully created!'); return $this->redirect('/itinerary/detail/' . $this->itinerary->getId()); break; case 'commercial_mission': $comcount = MissionLegPeer::getCountbyMissIdAndType($mission2->getId(), 'commercial_mission'); $flight_time = $request->getParameter('flight_time'); if (empty($flight_time['hour']) || empty($flight_time['minute'])) { $flight_time = null; } $airline_id = $request->getParameter('airline_id'); if ($airline_id == 'other') { $airline = new Airline(); $airline->setName($request->getParameter('airline_custom')); $airline->save(); } else { $airline = AirlinePeer::retrieveByPK($airline_id); $this->forward404Unless($airline); } $origins = $request->getParameter('origin'); $destinations = $request->getParameter('destination'); $flight_numbers = $request->getParameter('flight_number'); $departures = $request->getParameter('departure'); $arrivals = $request->getParameter('arrival'); $mission->setFlightTime($flight_time['hour'] . ':' . $flight_time['minute'] . ' ' . $flight_time['period']); $missioncount++; $n_leg = $missioncount; foreach ($origins as $i => $origin) { if (empty($origin) || empty($destinations[$i])) { continue; } $mission_leg = new MissionLeg(); $comcount++; $mission_leg->setMissionId($mission2->getId()); $mission_leg->setLegNumber($n_leg++); $mission_leg->setFlightTime($flight_time ? strtotime($flight_time['hour'] . ':' . $flight_time['minute'] . ' ' . $flight_time['period']) : null); //$mission_leg->setBaggageDesc($request->getParameter('baggage_desc')); //$mission_leg->setBaggageWeight($request->getParameter('baggage_weight')); $mission_leg->setAirlineId($airline->getId()); $mission_leg->setFundId($request->getParameter('fund_id')); $mission_leg->setConfirmCode($request->getParameter('confirm_code')); $mission_leg->setFlightCost($request->getParameter('flight_cost')); $mission_leg->setCommOrigin($origin); $mission_leg->setCommDest($destinations[$i]); $mission_leg->setFlightNumber($flight_numbers[$i]); $v = $departures[$i]; if (empty($v['hour']) || empty($v['minute'])) { $v = null; } $mission_leg->setDeparture($v ? strtotime($v['hour'] . ':' . $v['minute'] . ' ' . $v['period']) : null); $v = $arrivals[$i]; if (empty($v['hour']) || empty($v['minute'])) { $v = null; } $mission_leg->setDeparture($v ? strtotime($v['hour'] . ':' . $v['minute'] . ' ' . $v['period']) : null); $mission_leg->setTransportation('commercial_mission'); $mission_leg->setPrefix('com' . $comcount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $this->getUser()->setFlash('success', 'Mission and Leg #' . $mission_leg->getMissionId() . '-' . $mission_leg->getLegNumber() . ' has successfully created!'); return $this->redirect('/itinerary/detail/' . $this->itinerary->getId()); } break; } } } else { switch ($request->getParameter('transportation')) { case 'air_mission': $origin_airports = (array) $request->getParameter('origin_idents'); $dest_airports = (array) $request->getParameter('destination_idents'); $idents = $dest_airports; $tmp_arr = array(); foreach ($origin_airports as $i => $ident) { $idents[] = $ident; $v = $ident . ' to ' . $dest_airports[$i]; if (in_array($v, $tmp_arr)) { $this->errors[] = 'Leg ' . $v . ' appeared more than one'; } else { $tmp_arr[] = $v; } if ($dest_airports[$i] == $ident) { $this->errors[] = 'Leg ' . $ident . ' to ' . $dest_airports[$i] . ' is invalid'; } } $idents = array_unique($idents); $c = new Criteria(); $c->add(AirportPeer::IDENT, $idents, Criteria::IN); if (count($idents) != AirportPeer::doCount($c)) { $this->errors[] = 'Some airport idents are invalid'; } break; case 'ground_mission': $origin = $request->getParameter('ground_origin'); $destination = $request->getParameter('ground_destination'); //echo $destination; die(); $orginset = $request->getParameter('orginset'); $destset = $request->getParameter('destset'); $this->destset = $destset; $this->orginset = $orginset; if (empty($destination) && empty($destset)) { $this->errors[] = 'Please specify destination address'; } if (empty($origin) && empty($orginset)) { $this->errors[] = 'Please specify origin address'; } elseif ($destination == $origin && $destination != '') { $this->errors[] = 'Origin and Destination addresses conflict'; } break; case 'commercial_mission': $mission_date = $request->getParameter('mission_date'); if (empty($mission_date)) { $this->errors[] = 'Mission date is required'; } if ($v = $request->getParameter('airline_id')) { $custom = $request->getParameter('airline_custom'); if ($v == 'other') { if (empty($custom)) { $this->errors[] = 'Please type a new airline name!'; } } else { $airline = AirlinePeer::retrieveByPK($v = $request->getParameter('airline_id')); if (!$airline instanceof Airline) { $this->errors[] = 'Please select airline!'; } } } else { $this->errors[] = 'Please select airline!'; } break; default: $this->errors[] = 'Please select Transportation Type'; } if (count($this->errors)) { # error in form switch ($request->getParameter('transportation')) { case 'air_mission': $this->origin_idents = $origin_airports; $this->dest_idents = $dest_airports; break; case 'ground_mission': break; case 'commercial_mission': break; } } else { $missioncount = MissionLegPeer::getMaxLegNumber($mission->getId()); switch ($request->getParameter('transportation')) { case 'air_mission': $aircount = MissionLegPeer::getCountbyMissIdAndType($mission->getId(), 'air_mission'); for ($i = 0; $i < sizeof($origin_airports); $i++) { $airport_o = AirportPeer::getByIdent($origin_airports[$i]); $airport_d = AirportPeer::getByIdent($dest_airports[$i]); $missioncount++; $aircount++; $mission_leg = new MissionLeg(); $mission_leg->setMissionId($mission->getId()); $mission_leg->setLegNumber($missioncount); $mission_leg->setFromAirportId($airport_o->getId()); $mission_leg->setToAirportId($airport_d->getId()); $mission_leg->setPrefix('air' . $aircount); //$mission_leg->setBaggageWeight($request->getParameter('baggage_weight')); //$mission_leg->setBaggageDesc($request->getParameter('baggage_desc')); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('air_mission'); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); } $this->getUser()->setFlash('success', 'Mission and Leg #' . $mission_leg->getMissionId() . '-' . $mission_leg->getLegNumber() . ' has successfully created!'); return $this->redirect('/itinerary/detail/' . $this->itinerary->getId()); break; case 'ground_mission': $groundcount = MissionLegPeer::getCountbyMissIdAndType($mission->getId(), 'ground_mission'); $mission_leg = new MissionLeg(); $orginsetsave = $request->getParameter('ground_origin'); if (empty($orginsetsave)) { $orginsetsave = $request->getParameter('orginset'); } $destsetsave = $request->getParameter('ground_destination'); if (empty($destsetsave)) { $destsetsave = $request->getParameter('destset'); } $groundcount++; $missioncount++; $sa = $missioncount; $mission_leg->setMissionId($mission->getId()); $mission_leg->setLegNumber($sa); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('ground_mission'); $mission_leg->setGroundOrigin($orginsetsave); $mission_leg->setGroundDestination($destsetsave); $mission_leg->setPrefix('g' . $groundcount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $this->getUser()->setFlash('success', 'Mission and Leg #' . $mission_leg->getMissionId() . '-' . $mission_leg->getLegNumber() . ' has successfully created!'); return $this->redirect('/itinerary/detail/' . $this->itinerary->getId()); break; case 'commercial_mission': $comcount = MissionLegPeer::getCountbyMissIdAndType($mission->getId(), 'commercial_mission'); $flight_time = $request->getParameter('flight_time'); if (empty($flight_time['hour']) || empty($flight_time['minute'])) { $flight_time = null; } $airline_id = $request->getParameter('airline_id'); if ($airline_id == 'other') { $airline = new Airline(); $airline->setName($request->getParameter('airline_custom')); $airline->save(); } else { $airline = AirlinePeer::retrieveByPK($airline_id); $this->forward404Unless($airline); } $origins = $request->getParameter('origin'); $destinations = $request->getParameter('destination'); $flight_numbers = $request->getParameter('flight_number'); $departures = $request->getParameter('departure'); $arrivals = $request->getParameter('arrival'); $mission->setFlightTime($flight_time['hour'] . ':' . $flight_time['minute'] . ' ' . $flight_time['period']); $missioncount++; $n_leg = $missioncount; foreach ($origins as $i => $origin) { if (empty($origin) || empty($destinations[$i])) { continue; } $mission_leg = new MissionLeg(); $comcount++; $mission_leg->setMissionId($mission->getId()); $mission_leg->setLegNumber($n_leg++); $mission_leg->setFlightTime($flight_time ? strtotime($flight_time['hour'] . ':' . $flight_time['minute'] . ' ' . $flight_time['period']) : null); $mission_leg->setBaggageDesc($request->getParameter('baggage_desc')); $mission_leg->setBaggageWeight($request->getParameter('baggage_weight')); $mission_leg->setAirlineId($airline->getId()); $mission_leg->setFundId($request->getParameter('fund_id')); $mission_leg->setConfirmCode($request->getParameter('confirm_code')); $mission_leg->setFlightCost($request->getParameter('flight_cost')); $mission_leg->setCommOrigin($origin); $mission_leg->setCommDest($destinations[$i]); $mission_leg->setFlightNumber($flight_numbers[$i]); $v = $departures[$i]; if (empty($v['hour']) || empty($v['minute'])) { $v = null; } $mission_leg->setDeparture($v ? strtotime($v['hour'] . ':' . $v['minute'] . ' ' . $v['period']) : null); $v = $arrivals[$i]; if (empty($v['hour']) || empty($v['minute'])) { $v = null; } $mission_leg->setDeparture($v ? strtotime($v['hour'] . ':' . $v['minute'] . ' ' . $v['period']) : null); $mission_leg->setTransportation('commercial_mission'); $mission_leg->setPrefix('com' . $comcount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $this->getUser()->setFlash('success', 'Mission and Leg #' . $mission_leg->getMissionId() . '-' . $mission_leg->getLegNumber() . ' has successfully created!'); return $this->redirect('/itinerary/detail/' . $this->itinerary->getId()); } break; } } } } } if ($request->getParameter('id')) { //$this->itinerary = ItineraryPeer::retrieveByPK($request->getParameter('id')); //$this->mis = MissionPeer::getMissionByItineraryId($this->itinerary->getId(), 'Home'); //$mission = $this->mis; if (isset($mission)) { $this->mis_comment = $mission->getComment(); } //$this->mis_legs = MissionLegPeer::getbyMissId($mission->getId()); if ($mission2) { $this->mis2_legs = MissionLegPeer::getbyMissId($mission2->getId()); $this->mist_comment = $mission2->getComment(); } $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); $this->time_widget = new widgetFormTime(); $this->airport_list = AirportPeer::getMappable(); $this->ground_addresses = $this->getGroundAddresses(); $this->airlines = AirlinePeer::doSelect(new Criteria()); $this->funds = FundPeer::doSelect(new Criteria()); $this->miss_ids = array(); $c = 0; $count = 0; $count2 = 0; if (isset($this->itinerary)) { $this->missions = MissionPeer::getByItiId($this->itinerary->getId()); if (isset($this->missions)) { foreach ($this->missions as $mi) { $this->miss_ids[$c] = $mi->getId(); $legs = MissionLegPeer::getbyMissId($mi->getId()); } } } $this->title = '#' . $this->itinerary->getId() . ' Itinerary Details'; } }
if ($coordinator->getMemberId()) { $coordiPerson = $coordinator->getMember()->getPerson(); } } if ($mleg->getMissAssisId()) { $memberMiss = MemberPeer::retrieveByPK($mleg->getMissAssisId()); $miss_assi_persopn = $memberMiss->getPerson(); } if ($mleg->getMissAssisId()) { $memberMiss = MemberPeer::retrieveByPK($mleg->getMissAssisId()); $miss_assi_persopn = $memberMiss->getPerson(); } if ($mleg->getFboId()) { $fbo = FboPeer::retrieveByPK($mleg->getFboId()); if ($fbo->getAirportId()) { $fbo_airport = AirportPeer::retrieveByPK($fbo->getAirportId()); } } $is_air = $mleg->getTransportation() == 'air_mission'; if ($is_air) { $to_airport = $mleg->getAirportRelatedByToAirportId(); $from_airport = $mleg->getAirportRelatedByFromAirportId(); } //// FBO information if ($mleg->getFboId()) { $fromFbo = FboPeer::retrieveByPK($mleg->getFboId()); } if ($mleg->getFboDestId()) { $destFbo = FboPeer::retrieveByPK($mleg->getFboDestId()); } //ETD and ETA information
public function executeSaveReturnSourceLocation(sfWebRequest $request) { $pass_id = $this->getRequestParameter('passengerid'); $new_airportname = $this->getRequestParameter('airportname'); $new_airport = AirportPeer::getBySpecificAirportName($new_airportname); $camp_id = $this->getRequestParameter('camp_id'); $camp = CampPeer::retrieveByPK($camp_id); $mission_id = $this->getRequestParameter('mission_id'); $conn = Propel::getConnection(); $sql = 'UPDATE mission_leg set to_airport_id = ' . $new_airport->getId() . ' WHERE mission_id = ' . $mission_id . ' AND from_airport_id = ' . $camp->getAirportId(); $statement = $conn->prepare($sql); $statement->execute(); $sql = 'UPDATE camp_passenger set return_airport_id = ' . $new_airport->getId() . ' WHERE camp_id = ' . $camp_id . ' AND passenger_id = ' . $pass_id . ' AND mission_id = ' . $mission_id; $statement = $conn->prepare($sql); $statement->execute(); $this->airportname = $new_airportname; $this->setTemplate('saveSourceLocation'); }
<dl class="destination-list"> <dt>From:</dt> <dd> <strong> Varied </strong> </dd> <dt>To:</dt> <dd> <strong> <?php $legs = $mission->getMissionLegs(); if ($legs) { $destination_airport = $legs[0]->getToAirportId(); } $airport_from = AirportPeer::retrieveByPK($destination_airport); if (isset($airport_from)) { echo $airport_from->getIdent(); } ?> </strong> <?php if (isset($airport_from)) { if ($airport_from->getCity() || $airport_from->getState()) { echo '( ' . $airport_from->getCity() . ', ' . $airport_from->getState() . ' )'; } } ?> <em>PST</em> </dd> </dl>
/** * 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(AirportPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(AirportPeer::DATABASE_NAME); $criteria->add(AirportPeer::ID, $pks, Criteria::IN); $objs = AirportPeer::doSelect($criteria, $con); } return $objs; }