public function executeAjaxDeletePersonalFlight(sfWebRequest $request) { if (!$this->getUser()->hasCredential(array('Administrator', 'Pilot', 'Staff'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } $personal_flight = PersonalFlightPeer::retrieveByPK($request->getParameter('id')); $this->forward404Unless($personal_flight); $this->forward404Unless($personal_flight->getPilotId() == $this->getUser()->getPilotId()); $personal_flight->delete(); return sfView::NONE; }
/** * 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; }