/** * Gets MissionLeg object which contain a foreign key that references this object. * * @param PropelPDO $con * @param Criteria $criteria * @return MissionLeg * @throws PropelException */ public function getMissionLeg($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(MissionReportPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collMissionLeg === null) { if (!$this->isNew()) { $criteria->add(MissionLegPeer::MISSION_REPORT_ID, $this->id); MissionLegPeer::addSelectColumns($criteria); $this->collMissionLeg = MissionLegPeer::doSelectOne($criteria, $con); } } return $this->collMissionLegs; }
/** * Executes index action * * @param sfRequest $request A request object */ public function executeIndex(sfWebRequest $request) { # for navigation menu sfContext::getInstance()->getConfiguration()->loadHelpers('Partial'); slot('nav_menu', array('instrument', '')); #security /* if( !$this->getUser()->hasCredential(array('Administrator','Staff','Pilot','Member','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('type')) { $this->flag = 1; } if ($request->hasParameter('return')) { $this->pilot_request = 1; } if ($request->hasParameter('avail')) { $this->window_loc = 'avail'; } if ($request->hasParameter('window_loc_visual')) { $this->window_loc_visual = 'window_loc_visual'; } $member_id = $this->getUser()->getMemberId(); $member = MemberPeer::retrieveByPK($member_id); $pilot = $member->getPilot(); if ($request->getParameter('first') == 1) { if ($pilot) { $first_airport = AirportPeer::retrieveByPK($pilot->getPrimaryAirportId()); $this->orgin_airport = $first_airport->getIdent(); } $this->types = MissionTypePeer::getOnlyNames(); $this->dest_airport = null; $this->miss_type = null; $this->miss_date1 = null; $this->miss_date2 = null; } else { $this->processFilterVisual($request); } $this->airport_list = AirportPeer::getMappable(); $this->legs = MissionLegPeer::getMappable($this->orgin_airport, $this->dest_airport, $this->miss_type, $this->miss_date1, $this->miss_date2); $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); }
/** * Add or edit fbo * CODE:fbo_create */ public function executeFboUpdate(sfWebRequest $request) { # security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Coordinator', 'Volunteer'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } //$this->airports=""; sfContext::getInstance()->getConfiguration()->loadHelpers('Partial'); $this->airport = trim($this->getRequestParameter('airport', '*')) == '' ? '*' : trim($this->getRequestParameter('airport', '*')); if ($request->getParameter('leg')) { $this->leg_id = $request->getParameter('leg'); } if ($request->getParameter('id')) { $this->fbo = FboPeer::retrieveByPK($request->getParameter('id')); $this->forward404Unless($this->fbo); $this->title = 'Edit Fbo'; $success = 'FBO information has successfully edited!'; slot('nav_menu', array('reference', '')); if ($this->fbo->getAirportId()) { $this->airport_id = $this->fbo->getAirportId(); } $this->airports = AirportPeer::doSelect(new Criteria()); } else { $this->fbo = new Fbo(); $this->title = 'Add Fbo'; $success = 'FBO information has successfully created!'; slot('nav_menu', array('reference', 'add-fbo')); } //Aiport PopUp Form $airport = new Airport(); $this->form_airport = new AirportForm($airport); $this->airport_referer = $request->getReferer(); $this->form = new FboForm($this->fbo); if ($request->isMethod('post')) { $this->referer = $request->getParameter('referer'); $this->form->bind($request->getParameter('fbo')); if ($this->form->isValid() && $request->getParameter('airport') && $this->form->getValue('name')) { if ($request->getParameter('airport')) { $airport = AirportPeer::getByIdent($request->getParameter('airport')); } if (isset($airport) && $airport instanceof Airport) { $this->fbo->setAirportId($airport->getId()); } $this->fbo->setName($this->form->getValue('name')); $this->fbo->setAddress($this->form->getValue('address')); $this->fbo->setVoicePhone($this->form->getValue('voice_phone')); $this->fbo->setFaxPhone($this->form->getValue('fax_phone')); $this->fbo->setDiscountAmount($this->form->getValue('discount_amount')); if ($this->form->getValue('fuel_discount') == null || $this->form->getValue('discount_amount') == 0) { $this->fbo->setFuelDiscount(0); } else { $this->fbo->setFuelDiscount($this->form->getValue('fuel_discount')); } if ($this->fbo->isNew()) { $ext = ''; if (isset($airport) && $airport instanceof Airport) { $ext = ' for ' . $airport->getIdent(); } $content = $this->getUser()->getName() . ' added new FBO' . $ext . ': ' . $this->fbo->getName(); ActivityPeer::log($content); } $this->fbo->save(); $this->getUser()->setFlash('success', $success); $back = '@fbo'; if ($request->getParameter('leg_id')) { $set_leg = MissionLegPeer::retrieveByPK($request->getParameter('leg_id')); if (isset($set_leg) && $set_leg instanceof MissionLeg) { $set_leg->setFboId($this->fbo->getId()); $set_leg->save(); } $back = '@leg_edit?id=' . $request->getParameter('leg_id'); } $this->redirect($back); } else { if ($request->getParameter('airport') == NULL) { $this->errairport = 1; } if ($request->getParameter('airport') == NULL && $this->form->getValue('name')) { $this->getUser()->setFlash('error', 'Please Provide An Airport Name!'); } else { if ($request->getParameter('airport') && $this->form->getValue('name') == NULL) { $this->getUser()->setFlash('error', 'Please Provide A Name!'); } else { $this->getUser()->setFlash('error', 'Please Provide Airport and Name!'); } } } } else { # Set referer URL $this->referer = $request->getReferer() ? $request->getReferer() : '@fbo'; } $this->fbo = $this->fbo; }
/** * Get the associated MissionLeg object * * @param PropelPDO Optional Connection object. * @return MissionLeg The associated MissionLeg object. * @throws PropelException */ public function getMissionLeg(PropelPDO $con = null) { if ($this->aMissionLeg === null && $this->id !== null) { $c = new Criteria(MissionLegPeer::DATABASE_NAME); $c->add(MissionLegPeer::ID, $this->id); $this->aMissionLeg = MissionLegPeer::doSelectOne($c, $con); // Because this foreign key represents a one-to-one relationship, we will create a bi-directional association. $this->aMissionLeg->setAfaLeg($this); } return $this->aMissionLeg; }
/** * Passenger view * CODE: passenger_view */ public function executeView(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'); } $passenger = PassengerPeer::retrieveByPK($request->getParameter('id')); $this->redirectUnless($passenger, '@homepage'); $this->passenger = $passenger; $this->person = $passenger->getPerson(); $this->companions = $passenger->getCompanions(); $this->back = $request->getReferer(); if (strstr($this->back, '/mission/view')) { $this->frommission = 1; } else { $this->frommission = 0; } # recent item $this->getUser()->addRecentItem($this->person->getName(), 'passenger', 'passenger/view?id=' . $passenger->getId()); if ($request->getParameter('back')) { $this->back = $request->getParameter('back'); } # handle the master member if ($request->hasParameter('mission_for') && hasCredential(array('Administrator', 'Staff'), false)) { $this->mission_for = MissionLegPeer::retrieveByPK($request->getParameter('mission_for')); } else { $this->mission_for = null; } }
/** * Get the associated MissionLeg object * * @param PropelPDO Optional Connection object. * @return MissionLeg The associated MissionLeg object. * @throws PropelException */ public function getMissionLeg(PropelPDO $con = null) { if ($this->aMissionLeg === null && $this->leg_id !== null) { $c = new Criteria(MissionLegPeer::DATABASE_NAME); $c->add(MissionLegPeer::ID, $this->leg_id); $this->aMissionLeg = MissionLegPeer::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->aMissionLeg->addMissionPhotos($this); */ } return $this->aMissionLeg; }
public static function doSelectJoinCustom(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { foreach (sfMixer::getCallables('MissionPeer:doSelectJoinCustom:doSelectJoinCustom') as $callable) { call_user_func($callable, 'MissionPeer', $c, $con); } $c = clone $c; // Set the correct dbName if it has not been overridden if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } MissionPeer::addSelectColumns($c); $startcol2 = MissionPeer::NUM_COLUMNS - MissionPeer::NUM_LAZY_LOAD_COLUMNS; ItineraryPeer::addSelectColumns($c); $startcol3 = $startcol2 + (ItineraryPeer::NUM_COLUMNS - ItineraryPeer::NUM_LAZY_LOAD_COLUMNS); MissionTypePeer::addSelectColumns($c); $startcol4 = $startcol3 + (MissionTypePeer::NUM_COLUMNS - MissionTypePeer::NUM_LAZY_LOAD_COLUMNS); PassengerPeer::addSelectColumns($c); $startcol5 = $startcol4 + (PassengerPeer::NUM_COLUMNS - PassengerPeer::NUM_LAZY_LOAD_COLUMNS); MissionLegPeer::addSelectColumns($c); $startcol6 = $startcol5 + (MissionLegPeer::NUM_COLUMNS - MissionLegPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(MissionPeer::ITINERARY_ID), array(ItineraryPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::MISSION_TYPE_ID), array(MissionTypePeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::PASSENGER_ID), array(PassengerPeer::ID), $join_behavior); $c->addJoin(array(MissionPeer::ID), array(MissionLegPeer::MISSION_ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = MissionPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = MissionPeer::getInstanceFromPool($key1))) { // We no longer rehydrate the object, since this can cause data loss. // See http://propel.phpdb.org/trac/ticket/509 // $obj1->hydrate($row, 0, true); // rehydrate } else { $omClass = MissionPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); MissionPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Itinerary rows $key2 = ItineraryPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = ItineraryPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = ItineraryPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); ItineraryPeer::addInstanceToPool($obj2, $key2); } // if obj2 loaded // Add the $obj1 (Mission) to the collection in $obj3 (Itinerary) $obj2->addMission($obj1); } // if joined row not null // Add objects for joined MissionType rows $key3 = MissionTypePeer::getPrimaryKeyHashFromRow($row, $startcol3); if ($key3 !== null) { $obj3 = MissionTypePeer::getInstanceFromPool($key3); if (!$obj3) { $omClass = MissionTypePeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj3 = new $cls(); $obj3->hydrate($row, $startcol3); MissionTypePeer::addInstanceToPool($obj3, $key3); } // if obj3 loaded // Add the $obj1 (Mission) to the collection in $obj3 (MissionType) $obj3->addMission($obj1); } // if joined row not null // Add objects for joined Passenger rows $key4 = PassengerPeer::getPrimaryKeyHashFromRow($row, $startcol4); if ($key4 !== null) { $obj4 = PassengerPeer::getInstanceFromPool($key4); if (!$obj4) { $omClass = PassengerPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj4 = new $cls(); $obj4->hydrate($row, $startcol4); PassengerPeer::addInstanceToPool($obj4, $key4); } // if obj4 loaded // Add the $obj1 (Mission) to the collection in $obj4 (Passenger) $obj4->addMission($obj1); } // if joined row not null // Add objects for joined MissionLeg rows $key5 = MissionLegPeer::getPrimaryKeyHashFromRow($row, $startcol5); if ($key5 !== null) { $obj5 = MissionLegPeer::getInstanceFromPool($key5); if (!$obj5) { $omClass = MissionLegPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj5 = new $cls(); $obj5->hydrate($row, $startcol5); MissionLegPeer::addInstanceToPool($obj5, $key5); } // if obj5 loaded // Add the $obj1 (Mission) to the collection in $obj5 (MissionLeg) $obj5->setMission($obj1); } // if joined row not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
<th></th> <th>Name</th> <th></th> <th>Location</th> <th>Weights</th> <th>Comments</th> <th>Distance</th> </tr> </thead> <tbody> <?php $passengers = array(); $linked_passengers = array(); $cc = 0; foreach ($missions as $miss) { $legs = MissionLegPeer::getbyMissIdNoPilotId($miss->getId()); if ($legs && isset($legs) && $miss->getMissionDate('m/d/Y') == $key) { $passengers[$cc] = $miss->getPassengerId(); $cc++; } } if (isset($passengers)) { ?> <?php for ($u = 0; $u < count($passengers); $u++) { //if passenger is linked and listed already, dont show $print = true; foreach ($linked_passengers as $key => $value) { if ($passengers[$u] == $value) { $print = false; break;
</a> <?php } ?> <input type="hidden" name="leg_id" value="<?php echo $leg->getId(); ?> "/> <input type="submit" class="hide" id="leg_form_submit"/> </div> </form> </div> <?php $from_airport1 = AirportPeer::retrieveByPK($leg->getFromAirportId()); $to_airport1 = AirportPeer::retrieveByPK($leg->getToAirportId()); $miss_legs = MissionLegPeer::getbyMissId($mission->getId()); if (count($miss_legs)) { ?> <table class="mission-request-table"> <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 $mission_leg) { ?>
/** * 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; }
public function executeAjaxGetPilotRequests(sfWebRequest $request) { # arrived requests $this->mission_requests = MissionRequestPeer::getRsNonProcessed($count); $this->mission_requests_count = $count; # available missions $this->available_mission_legs = MissionLegPeer::getRsAvailable($count); $this->available_mission_legs_count = $count; # coordinated missions $this->coordinated_mission_legs = MissionLegPeer::getRsCoordinated($count); $this->coordinated_mission_legs_count = $count; # pilot requests //return $this->renderText($request->getParameter('req_date1').' '.$request->getParameter('req_date2')); # filter $this->processPilotRequestFilter($request); $this->pager = PilotRequestPeer::getPager($this->max, $this->page, $this->req_date1, $this->req_date2, $this->miss_date1, $this->miss_date2, $this->not_process, $this->hold, $this->process); $this->pilot_reqs = $this->pager->getResults(); $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); # member requests $c = new Criteria(); $c->add(ApplicationTempPeer::RENEWAL, null, Criteria::ISNULL); $c->add(ApplicationTempPeer::MEMBER_ID, null, Criteria::ISNULL); $c->add(ApplicationTempPeer::PROCESSED_DATE, null, Criteria::ISNULL); $c->setLimit(50); $this->member_requests = ApplicationTempPeer::doSelect($c); $this->transportations = array('air_mission' => 'Air Mission', 'ground_mission' => 'Ground Mission', 'commercial_mission' => 'Commercial Mission'); }
public function executePendingPilot(sfWebRequest $request) { $pilot_id = $request->getParameter('pilot_id'); $this->processPendingFilter($request); $this->pager = MissionLegPeer::getPendingPagerPilot($this->max, $this->page, $pilot_id, $this->wing_id, $this->ident); $this->mission_legs = $this->pager->getResults(); $this->setTemplate('pending'); }
/** * Match according to personal flights of pilot * @param <type> $id * @param <type> $max * @param <type> $page * @return sfPropelPager */ public static function getByFilterPF($id, $max = 10, $page = 1) { $personal_flight = PersonalFlightPeer::retrieveByPK($id); if (!$id or !isset($personal_flight)) { return null; } $c = new Criteria(); $c->addAscendingOrderByColumn(self::MISSION_ID); $c->addJoin(self::MISSION_ID, MissionPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(MissionPeer::MISSION_TYPE_ID, MissionTypePeer::ID, Criteria::LEFT_JOIN); $c->addJoin(self::ID, PilotRequestPeer::LEG_ID, Criteria::LEFT_JOIN); //airport $c->addAlias('c1', AirportPeer::TABLE_NAME); $c->addAlias('c2', AirportPeer::TABLE_NAME); $c->addJoin(self::FROM_AIRPORT_ID, AirportPeer::alias('c1', AirportPeer::ID), Criteria::LEFT_JOIN); $c->addJoin(self::TO_AIRPORT_ID, AirportPeer::alias('c2', AirportPeer::ID), Criteria::LEFT_JOIN); $criterion = $c->getNewCriterion(MissionPeer::MISSION_DATE, date('Y-m-d', strtotime($personal_flight->getDepartureDate())) . '%', Criteria::LIKE); $criterion->addAnd($c->getNewCriterion(AirportPeer::alias('c1', AirportPeer::CITY), '%' . $personal_flight->getOriginCity() . '%', Criteria::LIKE)); $criterion->addAnd($c->getNewCriterion(AirportPeer::alias('c2', AirportPeer::CITY), '%' . $personal_flight->getDestinationCity() . '%', Criteria::LIKE)); $criterion->addAnd($c->getNewCriterion(AirportPeer::alias('c1', AirportPeer::ZIPCODE), '%' . $personal_flight->getOriginZipcode() . '%', Criteria::LIKE)); $criterion->addAnd($c->getNewCriterion(AirportPeer::alias('c2', AirportPeer::ZIPCODE), '%' . $personal_flight->getDestinationZipcode() . '%', Criteria::LIKE)); $criterion2 = $c->getNewCriterion(AirportPeer::alias('c2', AirportPeer::CITY), $personal_flight->getOriginCity()); $criterion2->addAnd($c->getNewCriterion(AirportPeer::alias('c1', AirportPeer::CITY), $personal_flight->getDestinationCity())); $criterion2->addAnd($c->getNewCriterion(MissionPeer::MISSION_DATE, date('Y-m-d', strtotime($personal_flight->getReturnDate())) . '%', Criteria::LIKE)); $criterion2->addAnd($c->getNewCriterion(AirportPeer::alias('c2', AirportPeer::ZIPCODE), '%' . $personal_flight->getOriginZipcode() . '%', Criteria::LIKE)); $criterion2->addAnd($c->getNewCriterion(AirportPeer::alias('c1', AirportPeer::ZIPCODE), '%' . $personal_flight->getDestinationZipcode() . '%', Criteria::LIKE)); $criterion->addOr($criterion2); $c->add($criterion); $c->add(self::MISSION_REPORT_ID, null, Criteria::ISNULL); $c->add(PilotRequestPeer::PILOT_TYPE, 'Command Pilot', Criteria::NOT_EQUAL); $criterion = $c->getNewCriterion(PilotRequestPeer::PROCESSED, 0, Criteria::EQUAL); $criterion->addOr($c->getNewCriterion(PilotRequestPeer::ID, null, Criteria::ISNULL)); $c->add($criterion); MissionLegPeer::addSelectColumns($c); /* $c->addAsColumn('distance', 'Round(ACos(Sin(Radians(c1.latitude)) * Sin(Radians(c2.latitude)) + Cos(Radians(c1.latitude)) * Cos(Radians(c2.latitude)) * Cos(Radians(c1.longitude)-Radians(c2.longitude))) * ((180*60)/3.1415),0)'); //EFFECIENCY if ($home_base && $hb_airport = AirportPeer::retrieveByPK($home_base)) { $c->addAsColumn('efficiency', " CEILING(ROUND(ACOS(SIN(RADIANS(c1.latitude)) *SIN(RADIANS(c2.latitude))+COS(RADIANS(c1.latitude)) *COS(RADIANS(c2.latitude))*COS(RADIANS(c1.longitude)-RADIANS(c2.longitude))) *((180*60)/PI()))/(ROUND(ACOS(SIN(RADIANS(c1.latitude)) *SIN(RADIANS(c2.latitude))+COS(RADIANS(c1.latitude)) *COS(RADIANS(c2.latitude)) * COS(RADIANS(c1.longitude)-RADIANS(c2.longitude)) ) * ((180*60)/PI()) ) + ROUND( ACOS( SIN(RADIANS({$hb_airport->getLatitude()})) * SIN(RADIANS(c2.latitude)) + COS(RADIANS({$hb_airport->getLatitude()})) * COS(RADIANS(c2.latitude)) * COS(RADIANS({$hb_airport->getLongitude()})-RADIANS(c2.longitude)) ) * ((180*60)/PI()) ) + ROUND( ACOS( SIN(RADIANS({$hb_airport->getLatitude()})) * SIN(RADIANS(c1.latitude)) + COS(RADIANS({$hb_airport->getLatitude()})) * COS(RADIANS(c1.latitude)) * COS(RADIANS({$hb_airport->getLongitude()})-RADIANS(c1.longitude)) ) * ((180*60)/PI()))) * 200)"); $c->addDescendingOrderByColumn('efficiency'); } $c->addDescendingOrderByColumn('distance'); */ // return self::doSelect($c); $pager = new sfPropelPager('MissionLeg', $max); $pager->setCriteria($c); $pager->setPage($page); $pager->init(); return $pager; }
</div> <table class="mission-request-table"> <thead> <tr> <td>Mission Info</td> <td>Mission Report</td> <td>Status/Action</td> </tr> </thead> <tbody> <?php foreach ($reports as $report) { ?> <?php $mission_leg = MissionLegPeer::getMissionLegByReportId($report->getId()); ?> <tr> <td style="padding-left:30px;"> Mission Date: <?php echo date('m/d/Y', strtotime($report->getMissionDate())); ?> <br /> Passenger: <?php echo $report->getPassengerNames(); ?> <br /> Route: <?php echo $report->getPickupAirportIdent(); ?> to <?php
/** * 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 = MissionLegPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setMissionId($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setLegNumber($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setFromAirportId($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setToAirportId($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setReverseFrom($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setPassOnBoard($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setBaggageWeight($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setBaggageDesc($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setCoordinatorId($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setPublicCNote($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setPrivateCNote($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setCopilotWanted($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setPilotId($arr[$keys[13]]); } if (array_key_exists($keys[14], $arr)) { $this->setCopilotId($arr[$keys[14]]); } if (array_key_exists($keys[15], $arr)) { $this->setMissAssisId($arr[$keys[15]]); } if (array_key_exists($keys[16], $arr)) { $this->setBackupPilotId($arr[$keys[16]]); } if (array_key_exists($keys[17], $arr)) { $this->setBackupCopilotId($arr[$keys[17]]); } if (array_key_exists($keys[18], $arr)) { $this->setBackupMissAssisId($arr[$keys[18]]); } if (array_key_exists($keys[19], $arr)) { $this->setCancelled($arr[$keys[19]]); } if (array_key_exists($keys[20], $arr)) { $this->setCancelComment($arr[$keys[20]]); } if (array_key_exists($keys[21], $arr)) { $this->setWaiverReceived($arr[$keys[21]]); } if (array_key_exists($keys[22], $arr)) { $this->setWebCoordinated($arr[$keys[22]]); } if (array_key_exists($keys[23], $arr)) { $this->setMissionReportId($arr[$keys[23]]); } if (array_key_exists($keys[24], $arr)) { $this->setPilotAircraftId($arr[$keys[24]]); } if (array_key_exists($keys[25], $arr)) { $this->setFboId($arr[$keys[25]]); } if (array_key_exists($keys[26], $arr)) { $this->setFboAddressNew($arr[$keys[26]]); } if (array_key_exists($keys[27], $arr)) { $this->setFboDestId($arr[$keys[27]]); } if (array_key_exists($keys[28], $arr)) { $this->setShareAfaOrgId($arr[$keys[28]]); } if (array_key_exists($keys[29], $arr)) { $this->setTransportation($arr[$keys[29]]); } if (array_key_exists($keys[30], $arr)) { $this->setGroundOrigin($arr[$keys[30]]); } if (array_key_exists($keys[31], $arr)) { $this->setGroundDestination($arr[$keys[31]]); } if (array_key_exists($keys[32], $arr)) { $this->setFlightTime($arr[$keys[32]]); } if (array_key_exists($keys[33], $arr)) { $this->setAirlineId($arr[$keys[33]]); } if (array_key_exists($keys[34], $arr)) { $this->setFundId($arr[$keys[34]]); } if (array_key_exists($keys[35], $arr)) { $this->setConfirmCode($arr[$keys[35]]); } if (array_key_exists($keys[36], $arr)) { $this->setFlightCost($arr[$keys[36]]); } if (array_key_exists($keys[37], $arr)) { $this->setCommOrigin($arr[$keys[37]]); } if (array_key_exists($keys[38], $arr)) { $this->setCommDest($arr[$keys[38]]); } if (array_key_exists($keys[39], $arr)) { $this->setFlightNumber($arr[$keys[39]]); } if (array_key_exists($keys[40], $arr)) { $this->setDeparture($arr[$keys[40]]); } if (array_key_exists($keys[41], $arr)) { $this->setArrival($arr[$keys[41]]); } if (array_key_exists($keys[42], $arr)) { $this->setPrefix($arr[$keys[42]]); } if (array_key_exists($keys[43], $arr)) { $this->setCancelMissionLeg($arr[$keys[43]]); } if (array_key_exists($keys[44], $arr)) { $this->setCopiedMissionLeg($arr[$keys[44]]); } }
/** * Add or edit coordinator * CODE: coordinator_create */ public function executeUpdate(sfWebRequest $request) { # security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } if ($request->getParameter('member_id')) { $this->member = MemberPeer::retrieveByPK($request->getParameter('member_id')); } if ($request->getParameter('id')) { $this->coor = CoordinatorPeer::retrieveByPK($request->getParameter('id')); $this->title = 'Edit Coordinator'; $success = 'Coordinator information has been successfully edited!'; $this->member = MemberPeer::retrieveByPK($this->coor->getMemberId()); } else { $this->coor = new Coordinator(); $this->title = 'Add Coordinator'; $success = 'Coordinator information has been successfully created!'; } if ($request->getParameter('leg')) { $this->leg_id = $request->getParameter('leg'); } if ($request->getParameter('member')) { $this->member = MemberPeer::retrieveByPK($request->getParameter('member')); } $this->form = new CoordinatorForm($this->coor); $this->back = $request->getReferer(); if ($request->isMethod('post')) { $this->referer = $request->getReferer(); $this->form->bind($request->getParameter('coor')); if ($this->form->isValid()) { $this->coor->setMemberId($request->getParameter('member_id')); if ($this->form->getValue('coor_of_the_week') == null) { $this->coor->setCoorOfTheWeek(0); } else { $this->coor->setCoorOfTheWeek($this->form->getValue('coor_of_the_week')); } $this->coor->setCoorWeekDate($this->form->getValue('coor_week_date')); $this->coor->setInitialContact($this->form->getValue('initial_contact')); $is_new = $this->coor->isNew(); $this->coor->save(); if ($is_new) { sfContext::getInstance()->getConfiguration()->loadHelpers(array('Tag', 'Url')); $content = $this->getUser()->getName() . ' updated ' . link_to($this->member->getPerson()->getName(), 'coordinator/view?id=' . $this->coor->getId()) . ' as coordinator'; ActivityPeer::log($content); } $this->getUser()->setFlash('success', $success); $last = $request->getParameter('back'); $back_url = 'coordinator'; if (strstr($last, 'member/view')) { $member = MemberPeer::retrieveByPK($request->getParameter('member_id')); $member_id = $member->getId(); $back_url = '@member_view?id=' . $member_id; } elseif (strstr($last, 'coordinator/view')) { $back_url = '@coordinator_view?id=' . $this->coor->getId(); } $leg_id = $request->getParameter('leg_id'); if (isset($leg_id)) { $set_leg = MissionLegPeer::retrieveByPK($leg_id); if (isset($set_leg) && $set_leg instanceof MissionLeg) { $set_leg->setCoordinatorId($this->coor->getId()); $set_leg->save(); } else { $this->forward404Unless($set_leg); } $back_url = '@leg_edit?id=' . $request->getParameter('leg_id'); } return $this->redirect($back_url); } } else { # Set referer URL $this->referer = $request->getReferer() ? $request->getReferer() : '@companion'; } }
public function executeReverse(sfWebRequest $request) { $mis1 = MissionPeer::retrieveByPK($request->getParameter('miss_id')); $itine_id = $mis1->getItineraryId(); $mis2 = MissionPeer::retrieveByPK($request->getParameter('mis2_id')); $mis1_legs = MissionLegPeer::getbyDesOrderMissId($request->getParameter('miss_id')); $legnumber = 1; $comcount = 1; $aircount = 1; $groundcount = 1; foreach ($mis1_legs as $mleg) { $type = $mleg->getTransportation(); switch ($type) { case 'air_mission': $mission_leg = new MissionLeg(); $mission_leg->setMissionId($mis2->getId()); $mission_leg->setLegNumber($legnumber); $mission_leg->setFromAirportId($mleg->getToAirportId()); $mission_leg->setToAirportId($mleg->getFromAirportId()); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('air_mission'); $mission_leg->setPrefix('air' . $aircount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $aircount++; break; case 'ground_mission': $mission_leg = new MissionLeg(); $mission_leg->setMissionId($mis2->getId()); $mission_leg->setLegNumber($legnumber); $mission_leg->setPassOnBoard(0); $mission_leg->setTransportation('ground_mission'); $mission_leg->setGroundOrigin($mleg->getGroundDestination()); $mission_leg->setGroundDestination($mleg->getGroundOrigin()); $mission_leg->setPrefix('g' . $groundcount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $groundcount++; break; case 'commercial_mission': $mission_leg = new MissionLeg(); $mission_leg->setMissionId($mis2->getId()); $mission_leg->setLegNumber($legnumber); $mission_leg->setFlightTime($mleg->getFlightTime()); //$mission_leg->setBaggageDesc($request->getParameter('baggage_desc')); //$mission_leg->setBaggageWeight($request->getParameter('baggage_weight')); $mission_leg->setAirlineId($mleg->getAirlineId()); $mission_leg->setFundId($mleg->getFundId()); $mission_leg->setConfirmCode($mleg->getConfirmCode()); $mission_leg->setFlightCost($mleg->getFlightCost()); $mission_leg->setCommOrigin($mleg->getCommDest()); $mission_leg->setCommDest($mleg->getCommOrigin()); $mission_leg->setFlightNumber($mleg->getFlightNumber()); $mission_leg->setDeparture($mleg->getDeparture()); $mission_leg->setTransportation('commercial_mission'); $mission_leg->setPrefix('com' . $comcount); $mission_leg->setCancelMissionLeg(1); $mission_leg->save(); $comcount++; break; } $legnumber++; } $this->getUser()->setFlash('success', 'Successfully reverse.'); $this->redirect('itinerary/detail?id=' . $itine_id); }
public function executeIndexCancelled(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'); } # for navigation menu sfContext::getInstance()->getConfiguration()->loadHelpers('Partial'); slot('nav_menu', array('mission_coord', 'find-camp')); # recent item $this->getUser()->addRecentItem('Mission Legs', 'mission_legs', 'missionLeg/index'); $cancel = 1; # filter $this->processFilter($request); $this->pager = MissionLegPeer::getPager($this->max, $this->page, $this->miss_ext_id, $this->miss_type, $this->miss_date1, $this->miss_date2, $this->pass_fname, $this->pass_lname, $this->mreq_fname, $this->mreq_lname, $this->orgin_airport, $this->orgin_city, $this->orgin_state, $this->dest_airport, $this->dest_city, $this->dest_state, $this->pilot_fname, $this->pilot_lname, $cancel); $this->mission_leg_list = $this->pager->getResults(); $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); }
public function executeRemovePassenger(sfWebRequest $request) { if ($request->getParameter('camp_id') && $request->getParameter('member_id') && $request->getParameter('pass_id')) { $camp_mission_legs = MissionLegPeer::getByCampIdPassengerId($request->getParameter('camp_id'), $request->getParameter('pass_id')); if ($camp_mission_legs) { foreach ($camp_mission_legs as $leg) { $leg->setPilotId(null); $leg->save(); } } //if passenger linked then remove also $camp_passenger = CampPassengerPeer::retrieveByPK($request->getParameter('camp_id'), $request->getParameter('pass_id')); if ($camp_passenger->getLink() != null) { $camp_mission_legs = MissionLegPeer::getByCampIdPassengerId($request->getParameter('camp_id'), $camp_passenger->getLink()); if ($camp_mission_legs) { foreach ($camp_mission_legs as $leg) { $leg->setPilotId(null); $leg->save(); } } } } $this->setLayout(false); $this->flight_date = $request->getParameter('flight_date'); $this->pilot_req_id = $request->getParameter('pilot_req_id'); $this->getUser()->setFlash('error', 'Oops! Please try again.'); $this->setTemplate('assignPassenger'); }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Member is new, it will return * an empty collection; or if this Member has previously * been saved, it will retrieve related MissionLegsRelatedByBackupCopilotId from storage. * * This method is protected by default in order to keep the public * api reasonable. You can provide public methods for those you * actually need in Member. */ public function getMissionLegsRelatedByBackupCopilotIdJoinFbo($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(MemberPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collMissionLegsRelatedByBackupCopilotId === null) { if ($this->isNew()) { $this->collMissionLegsRelatedByBackupCopilotId = array(); } else { $criteria->add(MissionLegPeer::BACKUP_COPILOT_ID, $this->id); $this->collMissionLegsRelatedByBackupCopilotId = MissionLegPeer::doSelectJoinFbo($criteria, $con, $join_behavior); } } else { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(MissionLegPeer::BACKUP_COPILOT_ID, $this->id); if (!isset($this->lastMissionLegRelatedByBackupCopilotIdCriteria) || !$this->lastMissionLegRelatedByBackupCopilotIdCriteria->equals($criteria)) { $this->collMissionLegsRelatedByBackupCopilotId = MissionLegPeer::doSelectJoinFbo($criteria, $con, $join_behavior); } } $this->lastMissionLegRelatedByBackupCopilotIdCriteria = $criteria; return $this->collMissionLegsRelatedByBackupCopilotId; }
?> disabled="disabled" <?php } ?> name="other_requester_mail[]" /> </div> <div class="leglabel">Email: </div> <div class="leg_filed"> <?php echo $other_requester_id->getPerson()->getEmail(); ?> </div> </div> <?php } $mission_leg = MissionLegPeer::getAllMissionLegByMissionId($mission_list->getId()); foreach ($mission_leg as $miss_leg) { $pilot_id = PilotPeer::retrieveByPK($miss_leg->getPilotId()); if ($pilot_id) { ?> <div class="legemail_box"> <div class="heading">Pilot : <?php echo $pilot_id->getMember()->getPerson()->getFirstName(); ?> <?php echo $pilot_id->getMember()->getPerson()->getLastName(); ?> </div> <div class="chbox"> <input type="checkbox" <?php if ($pilot_id->getMember() && $pilot_id->getMember()->getPerson() && $pilot_id->getMember()->getPerson()->getEmail()) {
public function executeInstrumentNotication(sfWebRequest $request) { $c = new Criteria(); $c->add(PersonRolePeer::PERSON_ID, $this->getUser()->getId()); $c->addJoin(PersonRolePeer::ROLE_ID, RoleNotificationPeer::ROLE_ID); $personNotification = RoleNotificationPeer::doSelect($c); $this->mid = 0; foreach ($personNotification as $key => $value) { $this->mid = $value->getMid(); $this->notification = $value->getNotification(); //5. person add if ($this->mid == 5 && ($this->notification == 2 || $this->notification == 3)) { $c = new Criteria(); $c->addDescendingOrderByColumn(PersonPeer::ID); $c->setLimit(5); $this->newperson = PersonPeer::doSelect($c); } } $this->host = $request->getHost(); $this->memberId = $this->getUser()->getMemberId(); //$query = "SELECT COUNT(pilot_request.accepted) FROM pilot_request "; //$query .="WHERE pilot_request.accepted = 1 AND pilot_request.processed = 1 AND pilot_request.member_id = ".$this->memberId; //$con = Propel::getConnection(); //$stmt = $con->prepare($query); //$stmt->execute(); /*if($rs = $stmt->fetch(PDO::FETCH_NUM)) { $count = (int)$rs[0]; }else{ $count = 0; }*/ $c = new Criteria(); $c->add(PilotRequestPeer::ACCEPTED, 1); $c->add(PilotRequestPeer::PROCESSED, 1); $c->add(PilotRequestPeer::MEMBER_ID, $this->memberId); $this->totalAccepted = PilotRequestPeer::doCount($c); /* $this->memberId = $this->getUser()->getMemberId(); $query = "SELECT COUNT(pilot_request.accepted) FROM pilot_request "; $query .="WHERE pilot_request.accepted = 0 AND pilot_request.member_id = $this->memberId"; $con = Propel::getConnection(); $stmt = $con->prepare($query); $stmt->execute(); if($rs = $stmt->fetch(PDO::FETCH_NUM)) { $count = (int)$rs[0]; }else{ $count = 0; }*/ $c = new Criteria(); $c->add(PilotRequestPeer::ACCEPTED, 0); $c->add(PilotRequestPeer::MEMBER_ID, $this->memberId); $this->totaldeclined = PilotRequestPeer::doCount($c); $c = new Criteria(); $c->add(MissionLegPeer::PILOT_ID, $this->getUser()->getPilotId()); $c->add(MissionLegPeer::CANCEL_MISSION_LEG, 0); $this->totalMissionCancellation = MissionLegPeer::doCount($c); //total signup events count $pilot_id = $this->getUser()->getPilotId(); if ($pilot_id) { $pilot = PilotPeer::retrieveByPK($pilot_id); $member_id = $pilot->getMemberId(); $date = date('Y-m-d'); $c = new Criteria(); $c->add(EventReservationPeer::MEMBER_ID, $member_id, Criteria::EQUAL); $c->addJoin(EventPeer::ID, EventReservationPeer::EVENT_ID); $c->add(EventPeer::EVENT_DATE, $date, Criteria::GREATER_EQUAL); $this->totalSignupEvents = EventReservationPeer::doCount($c); } // }
/** * Selects a collection of MissionPhoto objects pre-filled with all related objects except Mission. * * @param Criteria $c * @param PropelPDO $con * @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN * @return array Array of MissionPhoto objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptMission(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { foreach (sfMixer::getCallables('BaseMissionPhotoPeer:doSelectJoinAllExcept:doSelectJoinAllExcept') as $callable) { call_user_func($callable, 'BaseMissionPhotoPeer', $c, $con); } $c = clone $c; // Set the correct dbName if it has not been overridden // $c->getDbName() will return the same object if not set to another value // so == check is okay and faster if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } MissionPhotoPeer::addSelectColumns($c); $startcol2 = MissionPhotoPeer::NUM_COLUMNS - MissionPhotoPeer::NUM_LAZY_LOAD_COLUMNS; MissionLegPeer::addSelectColumns($c); $startcol3 = $startcol2 + (MissionLegPeer::NUM_COLUMNS - MissionLegPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(MissionPhotoPeer::LEG_ID), array(MissionLegPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = MissionPhotoPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = MissionPhotoPeer::getInstanceFromPool($key1))) { // We no longer rehydrate the object, since this can cause data loss. // See http://propel.phpdb.org/trac/ticket/509 // $obj1->hydrate($row, 0, true); // rehydrate } else { $omClass = MissionPhotoPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); MissionPhotoPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined MissionLeg rows $key2 = MissionLegPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = MissionLegPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = MissionLegPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); MissionLegPeer::addInstanceToPool($obj2, $key2); } // if $obj2 already loaded // Add the $obj1 (MissionPhoto) to the collection in $obj2 (MissionLeg) $obj2->addMissionPhoto($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
public function executeReview(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'); } $this->getUser()->addRecentItem('Mission Report', 'mission_report', 'mission_report/review'); sfContext::getInstance()->getConfiguration()->loadHelpers('Partial'); slot('nav_menu', array('reports', 'mission_report_review')); # filter $this->processFilter($request); $this->miss = $request->hasParameter('missing'); if ($this->miss) { $this->pagers = MissionLegPeer::getMigaPager($this->max, $this->page); $this->mission_legs = $this->pagers->getResults(); } else { if ($request->isMethod('post') || $request->getParameter('page')) { $this->pager = MissionReportPeer::getPager($this->max, $this->page, $this->from_date, $this->to_date, $this->pilot_name, $this->passenger_name, $this->not_approved, $this->approved, $this->missing); $this->reports = $this->pager->getResults(); //$this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); } } $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); }
</strong> <em class="time">12:55:44 PM</em> </td> <td class="cell-2"> <dl> <dt>I:</dt> <dd> <?php echo $req->getId(); ?> </dd> <dt>M:</dt> <dd> <?php if ($req->getLegId()) { $mission_leg = MissionLegPeer::retrieveByPK($req->getLegId()); if (isset($mission_leg)) { if ($mission_leg->getMissionId()) { $mission = MissionPeer::retrieveByPK($mission_leg->getMissionId()); echo $mission->getId() . ' - ' . $mission_leg->getId(); } } } ?> </dd> </dl> </td> <td class="cell-3"> <?php if ($req->getDate()) { echo $req->getDate('m/d/Y');
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; }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this MissionReport is new, it will return * an empty collection; or if this MissionReport has previously * been saved, it will retrieve related MissionLegs from storage. * * This method is protected by default in order to keep the public * api reasonable. You can provide public methods for those you * actually need in MissionReport. */ public function getMissionLegsJoinFbo($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(MissionReportPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collMissionLegs === null) { if ($this->isNew()) { $this->collMissionLegs = array(); } else { $criteria->add(MissionLegPeer::MISSION_REPORT_ID, $this->id); $this->collMissionLegs = MissionLegPeer::doSelectJoinFbo($criteria, $con, $join_behavior); } } else { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(MissionLegPeer::MISSION_REPORT_ID, $this->id); if (!isset($this->lastMissionLegCriteria) || !$this->lastMissionLegCriteria->equals($criteria)) { $this->collMissionLegs = MissionLegPeer::doSelectJoinFbo($criteria, $con, $join_behavior); } } $this->lastMissionLegCriteria = $criteria; return $this->collMissionLegs; }
/** * 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(MissionLegPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(MissionLegPeer::DATABASE_NAME); $criteria->add(MissionLegPeer::ID, $pks, Criteria::IN); $objs = MissionLegPeer::doSelect($criteria, $con); } return $objs; }