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;
}
/**
* Returns the number of related PersonalFlight objects.
*
* @param Criteria $criteria
* @param boolean $distinct
* @param PropelPDO $con
* @return int Count of related PersonalFlight objects.
* @throws PropelException
*/
public function countPersonalFlights(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(PilotPeer::DATABASE_NAME);
} else {
$criteria = clone $criteria;
}
if ($distinct) {
$criteria->setDistinct();
}
$count = null;
if ($this->collPersonalFlights === null) {
if ($this->isNew()) {
$count = 0;
} else {
$criteria->add(PersonalFlightPeer::PILOT_ID, $this->id);
$count = PersonalFlightPeer::doCount($criteria, $con);
}
} else {
// criteria has no effect for a new object
if (!$this->isNew()) {
// 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 count of the collection.
$criteria->add(PersonalFlightPeer::PILOT_ID, $this->id);
if (!isset($this->lastPersonalFlightCriteria) || !$this->lastPersonalFlightCriteria->equals($criteria)) {
$count = PersonalFlightPeer::doCount($criteria, $con);
} else {
$count = count($this->collPersonalFlights);
}
} else {
$count = count($this->collPersonalFlights);
}
}
return $count;
}
/**
* 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(PersonalFlightPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(PersonalFlightPeer::DATABASE_NAME);
$criteria->add(PersonalFlightPeer::ID, $pks, Criteria::IN);
$objs = PersonalFlightPeer::doSelect($criteria, $con);
}
return $objs;
}
/**
* 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 = PersonalFlightPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setPilotId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setName($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setDepartureDate($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setReturnDate($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setOriginCity($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setOriginZipcode($arr[$keys[6]]);
}
if (array_key_exists($keys[7], $arr)) {
$this->setDestinationCity($arr[$keys[7]]);
}
if (array_key_exists($keys[8], $arr)) {
$this->setDestinationZipcode($arr[$keys[8]]);
}
}
/**
* 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;
}