function show(Pilot $pilot) { $active = Flight::with('departure', 'departure.country', 'arrival', 'arrival.country')->whereVatsimId($pilot->vatsim_id)->whereIn('state', array(0, 1, 3, 4))->first(); $flights = Flight::with('departure', 'departure.country', 'arrival', 'arrival.country')->whereVatsimId($pilot->vatsim_id)->whereState(2)->orderBy('arrival_time', 'desc')->take(15)->get(); $flightCount = Flight::whereVatsimId($pilot->vatsim_id)->whereState(2)->count(); $stats = new FlightStat(Flight::whereVatsimId($pilot->vatsim_id)); if ($pilot->processing == 0) { Queue::push('LegacyUpdate', $pilot->vatsim_id, 'legacy'); $pilot->processing = 2; $pilot->save(); } if ($pilot->processing == 2) { Messages::success('The data for this pilot is currently being processed. In a couple of minutes, all statistics will be available.')->one(); } $distances = $stats->distances($pilot->distance); $citypair = $stats->citypair(); if ($flights->count() > 0) { $durations = $stats->durations($pilot->duration); extract($durations); } // Charts: popular airlines, airports and aircraft $airlines = $stats->topAirlines(); $airports = $stats->topAirports(); $aircraft = $stats->topAircraft(); $this->javascript('assets/javascript/jquery.flot.min.js'); $this->javascript('assets/javascript/jquery.flot.pie.min.js'); $this->autoRender(compact('pilot', 'flights', 'active', 'distances', 'airlines', 'aircraft', 'airports', 'longest', 'shortest', 'citypair', 'hours', 'minutes'), $pilot->name); }
function show(Pilot $pilot) { $actives = ATC::with('airport', 'airport.country')->whereVatsimId($pilot->vatsim_id)->whereNull('end')->where('facility_id', '!=', 99)->get(); $duties = ATC::with('airport', 'airport.country')->whereVatsimId($pilot->vatsim_id)->whereNotNull('end')->where('facility_id', '!=', 99)->orderBy('end', 'desc')->take(15)->get(); if ($pilot->processing == 0) { Queue::push('LegacyUpdate', $pilot->vatsim_id, 'legacy'); $pilot->processing = 2; $pilot->save(); } if ($pilot->processing == 2) { Messages::success('The data for this controller is currently being processed. In a couple of minutes, all statistics will be available.')->one(); } $stat = new ControllerStat(ATC::whereVatsimId($pilot->vatsim_id)->where('facility_id', '!=', 99)); extract($stat->durations($pilot->duration_atc)); $airports = $stat->topAirports(); $facilities = $stat->topFacilities(); $this->javascript('assets/javascript/jquery.flot.min.js'); $this->javascript('assets/javascript/jquery.flot.pie.min.js'); $this->autoRender(compact('pilot', 'duties', 'actives', 'airport', 'airports', 'longest', 'hours', 'minutes', 'facilities'), $pilot->name); }
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aPilot !== null) { if ($this->aPilot->isModified() || $this->aPilot->isNew()) { $affectedRows += $this->aPilot->save($con); } $this->setPilot($this->aPilot); } if ($this->isNew()) { $this->modifiedColumns[] = MissionLegChangePeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = MissionLegChangePeer::doInsert($this, $con); $affectedRows += 1; // we are assuming that there is only 1 row per doInsert() which // should always be true here (even though technically // BasePeer::doInsert() can insert multiple rows). $this->setId($pk); //[IMV] update autoincrement primary key $this->setNew(false); } else { $affectedRows += MissionLegChangePeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } $this->alreadyInSave = false; } return $affectedRows; }
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()); }
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()); } }
/** * 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; }
/** * Member add or edit * CODE: member_create */ public function executeUpdate(sfWebRequest $request) { $new_pilot = false; #Security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Member'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } //FROM PERSON VIEW if ($request->getParameter('id')) { $member = MemberPeer::retrieveByPK($request->getParameter('id')); $this->forward404Unless($member); $this->title = 'Edit member'; $success = 'Member information has been successfully changed!'; $this->person = $member->getPerson(); } else { $this->person = PersonPeer::retrieveByPK($request->getParameter('person_id')); $this->forward404Unless($this->person); $member = new Member(); $this->title = 'Add new member'; $success = 'Member information has been successfully created!'; } $this->form = new MemberForm($member); $this->back = $request->getReferer(); $this->member = $member; if (strstr($request->getReferer(), 'person/view')) { $this->f_back = 1; } elseif (strstr($request->getReferer(), '/member/view/id')) { $this->f_back = 3; } elseif (strstr($request->getReferer(), '/member')) { $this->f_back = 2; } if ($request->isMethod('post')) { $this->referer = $request->getReferer(); $this->form->bind($request->getParameter('mem')); if ($this->form->isValid() && $this->form->getValue('member_class_id') != 0 && $this->form->getValue('flight_status')) { if ($request->getParameter('person_id')) { $member->setPersonId($request->getParameter('person_id')); } $person = PersonPeer::retrieveByPK($request->getParameter('person_id')); $member->setDateOfBirth($this->form->getValue('date_of_birth')); $member->setWeight($this->form->getValue('weight')); $member->setLanguages($this->form->getValue('languages')); if ($this->form->getValue('wing_id') == 0) { $member->setWingId(null); } else { $member->setWingId($this->form->getValue('wing_id')); } if ($this->form->getValue('secondary_wing_id') == 0) { $member->setSecondaryWingId(null); } else { $member->setSecondaryWingId($this->form->getValue('secondary_wing_id')); } // setting 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; $member->setExternalId($currentExternalId); $member->setJoinDate($this->form->getValue('join_date')); $member->setMemberClassId($this->form->getValue('member_class_id')); $member->setSpouseName($this->form->getValue('spouse_name')); $member->setCoordinatorNotes($this->form->getValue('coordinator_notes')); $member->setFlightStatus($this->form->getValue('flight_status')); if ($this->form->getValue('co_pilot') == null) { $member->setCoPilot(0); } else { $member->setCoPilot($this->form->getValue('co_pilot')); } $new_member = $member->isNew(); if ($new_member) { $content = $this->getUser()->getName() . ' added new Member: ' . $person->getFirstName(); ActivityPeer::log($content); } $member->save(); // $wing_jobs = $request->getParameter('wing_job1[]'); if ($request->getParameter('wing_job1')) { $old_mem_wing_jobs = MemberWingJobPeer::getWingJob($member->getId()); foreach ($old_mem_wing_jobs as $old_mem_wing_job) { $old_mem_wing_job->delete(); } foreach ($wing_jobs as $wing_job) { $member_wing_job = new MemberWingJob(); $member_wing_job->setMemberId($member->getId()); $member_wing_job->setWingJobId($wing_job); $member_wing_job->save(); } } if (strtolower($member->getFlightStatus()) == 'command pilot') { // if command-pilot then make pilot $pilot = new Pilot(); $pilot->setMemberId($member->getId()); $pilot->setLicenseType('Default'); $pilot->setIfr(0); $pilot->setMultiEngine(0); $pilot->save(); $new_pilot = true; } else { $new_pilot = false; } $this->getUser()->setFlash('success', $success); $last = $request->getParameter('back'); $back_url = 'member/index'; if (strstr($last, 'member/edit')) { $back_url = 'member/index'; } elseif (strstr($last, 'person/view')) { if (isset($this->person)) { $back_url = '@person_view?id=' . $this->person->getId(); } } elseif (strstr($last, 'member/view')) { $back_url = '@member_view?id=' . $member->getId(); } //with error validation back url if (strstr($request->getReferer(), 'last/1')) { $back_url = '@person_view?id=' . $this->person->getId(); } elseif (strstr($request->getReferer(), 'last/2')) { $back_url = 'member/index'; } elseif (strstr($request->getReferer(), 'last/3')) { $back_url = '@member_view?id=' . $member->getId(); } // role for new member if ($new_member) { $role = '@Member'; $member_role = RolePeer::getByTitle($role); if ($member_role) { $person_role = new PersonRole(); $person_role->setPersonId($this->person->getId()); $person_role->setRoleId($member_role->getId()); $person_role->save(); } else { $url = $this->generateUrl('default_index', array('module' => 'role'), true); $this->getUser()->setFlash('warning', '"' . $role . '" role not found! Please navigate ' . $url . ' and fix.'); } } // role for new pilot if ($new_pilot) { $role = '@Pilot'; $pilot_role = RolePeer::getByTitle($role); $is_true = PersonRolePeer::getIsTrue($this->person->getId(), $pilot_role->getId()); if (!$is_true) { $person_role = new PersonRole(); $person_role->setPersonId($this->person->getId()); $person_role->setRoleId($pilot_role->getId()); $person_role->save(); } else { $url = $this->generateUrl('default_index', array('module' => 'role'), true); //$this->getUser()->setFlash('warning', '"'.$role.'" role not found! Please navigate '.$url.' and fix'); } } $this->redirect($back_url); } else { $this->getUser()->setFlash('warning', 'Please confirm flight status and choose the member class!'); } } else { # Set referer URL $this->referer = $request->getReferer() ? $request->getReferer() : 'member/index'; } $this->member = $member; }
function vatsimUser($vatsimId, $rating = false) { if (empty($vatsimId)) { return; } $user = Pilot::whereVatsimId($vatsimId)->first(); if (is_null($user) || $rating === true) { $it = new XmlIterator\XmlIterator('https://cert.vatsim.net/vatsimnet/idstatusint.php?cid=' . $vatsimId, 'user'); $official = iterator_to_array($it)[0]; } if (is_null($user)) { $user = new Pilot(); $user->vatsim_id = $vatsimId; $user->name = (string) $official['name_first'] . ' ' . (string) $official['name_last']; $user->rating_id = (string) $official['rating']; $user->save(); } elseif ($rating === true && !is_array($official['rating'])) { $user->rating_id = $official['rating']; $user->save(); } unset($user); }
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aMission !== null) { if ($this->aMission->isModified() || $this->aMission->isNew()) { $affectedRows += $this->aMission->save($con); } $this->setMission($this->aMission); } if ($this->aAirportRelatedByFromAirportId !== null) { if ($this->aAirportRelatedByFromAirportId->isModified() || $this->aAirportRelatedByFromAirportId->isNew()) { $affectedRows += $this->aAirportRelatedByFromAirportId->save($con); } $this->setAirportRelatedByFromAirportId($this->aAirportRelatedByFromAirportId); } if ($this->aAirportRelatedByToAirportId !== null) { if ($this->aAirportRelatedByToAirportId->isModified() || $this->aAirportRelatedByToAirportId->isNew()) { $affectedRows += $this->aAirportRelatedByToAirportId->save($con); } $this->setAirportRelatedByToAirportId($this->aAirportRelatedByToAirportId); } if ($this->aCoordinator !== null) { if ($this->aCoordinator->isModified() || $this->aCoordinator->isNew()) { $affectedRows += $this->aCoordinator->save($con); } $this->setCoordinator($this->aCoordinator); } if ($this->aPilotRelatedByPilotId !== null) { if ($this->aPilotRelatedByPilotId->isModified() || $this->aPilotRelatedByPilotId->isNew()) { $affectedRows += $this->aPilotRelatedByPilotId->save($con); } $this->setPilotRelatedByPilotId($this->aPilotRelatedByPilotId); } if ($this->aMemberRelatedByCopilotId !== null) { if ($this->aMemberRelatedByCopilotId->isModified() || $this->aMemberRelatedByCopilotId->isNew()) { $affectedRows += $this->aMemberRelatedByCopilotId->save($con); } $this->setMemberRelatedByCopilotId($this->aMemberRelatedByCopilotId); } if ($this->aPilotRelatedByBackupPilotId !== null) { if ($this->aPilotRelatedByBackupPilotId->isModified() || $this->aPilotRelatedByBackupPilotId->isNew()) { $affectedRows += $this->aPilotRelatedByBackupPilotId->save($con); } $this->setPilotRelatedByBackupPilotId($this->aPilotRelatedByBackupPilotId); } if ($this->aMemberRelatedByBackupCopilotId !== null) { if ($this->aMemberRelatedByBackupCopilotId->isModified() || $this->aMemberRelatedByBackupCopilotId->isNew()) { $affectedRows += $this->aMemberRelatedByBackupCopilotId->save($con); } $this->setMemberRelatedByBackupCopilotId($this->aMemberRelatedByBackupCopilotId); } if ($this->aMissionReport !== null) { if ($this->aMissionReport->isModified() || $this->aMissionReport->isNew()) { $affectedRows += $this->aMissionReport->save($con); } $this->setMissionReport($this->aMissionReport); } if ($this->aPilotAircraft !== null) { if ($this->aPilotAircraft->isModified() || $this->aPilotAircraft->isNew()) { $affectedRows += $this->aPilotAircraft->save($con); } $this->setPilotAircraft($this->aPilotAircraft); } if ($this->aFbo !== null) { if ($this->aFbo->isModified() || $this->aFbo->isNew()) { $affectedRows += $this->aFbo->save($con); } $this->setFbo($this->aFbo); } if ($this->isNew()) { $this->modifiedColumns[] = MissionLegPeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = MissionLegPeer::doInsert($this, $con); $affectedRows += 1; // we are assuming that there is only 1 row per doInsert() which // should always be true here (even though technically // BasePeer::doInsert() can insert multiple rows). $this->setId($pk); //[IMV] update autoincrement primary key $this->setNew(false); } else { $affectedRows += MissionLegPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } if ($this->singleAfaLeg !== null) { if (!$this->singleAfaLeg->isDeleted()) { $affectedRows += $this->singleAfaLeg->save($con); } } if ($this->collMissionPhotos !== null) { foreach ($this->collMissionPhotos as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collPilotRequests !== null) { foreach ($this->collPilotRequests as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; }