/**
* 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(PilotRequestPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(PilotRequestPeer::DATABASE_NAME);
$criteria->add(PilotRequestPeer::ID, $pks, Criteria::IN);
$objs = PilotRequestPeer::doSelect($criteria, $con);
}
return $objs;
}
/**
* Gets an array of PilotRequest objects which contain a foreign key that references this object.
*
* If this collection has already been initialized with an identical Criteria, it returns the collection.
* Otherwise if this Camp has previously been saved, it will retrieve
* related PilotRequests from storage. If this Camp is new, it will return
* an empty collection or the current collection, the criteria is ignored on a new object.
*
* @param PropelPDO $con
* @param Criteria $criteria
* @return array PilotRequest[]
* @throws PropelException
*/
public function getPilotRequests($criteria = null, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(CampPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collPilotRequests === null) {
if ($this->isNew()) {
$this->collPilotRequests = array();
} else {
$criteria->add(PilotRequestPeer::GROUP_CAMP_ID, $this->id);
PilotRequestPeer::addSelectColumns($criteria);
$this->collPilotRequests = PilotRequestPeer::doSelect($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 the collection.
$criteria->add(PilotRequestPeer::GROUP_CAMP_ID, $this->id);
PilotRequestPeer::addSelectColumns($criteria);
if (!isset($this->lastPilotRequestCriteria) || !$this->lastPilotRequestCriteria->equals($criteria)) {
$this->collPilotRequests = PilotRequestPeer::doSelect($criteria, $con);
}
}
}
$this->lastPilotRequestCriteria = $criteria;
return $this->collPilotRequests;
}
/**
* Save Accept Pilot Request
* CODE:pilot_request_on_accept
*/
public function executeAccept(sfWebRequest $request)
{
#security
if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Pilot', 'Coordinator', 'Volunteer'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
$this->setTemplate(false);
if ($request->getParameter('id')) {
$req = PilotRequestPeer::retrieveByPK($request->getParameter('id'));
if (isset($req) && $req instanceof PilotRequest) {
if ($req->getAccepted() == 1) {
$req->setAccepted(0);
$req->setProcessed(1);
$req->setOnHold(0);
} else {
$req->setAccepted(1);
$req->setProcessed(1);
$member_id = $req->getMemberId();
$leg_id = $req->getLegId();
$mission_leg = MissionLegPeer::retrieveByPK($leg_id);
$leg_number = $mission_leg->getLegNumber();
$mission_id = $mission_leg->getMissionId();
/// Send Command Pilot Email
if ($member_id) {
$member = MemberPeer::retrieveByPK($member_id);
$person_id = $member->getPersonId();
$externalID = $member->getExternalId();
$person = PersonPeer::retrieveByPK($person_id);
$frist_name = $person->getFirstName();
$last_name = $person->getLastName();
$name = $frist_name . ' ' . $last_name;
$email = $person->getEmail();
if ($person->getEmail()) {
$pilot_type = "Command Pilot";
# send email requested pilot
$this->getComponent('mail', 'pilotRequestAccepted', array('email' => $email, 'name' => $name, 'externalID' => $externalID, 'pilot_type' => $pilot_type, 'leg_number' => $leg_number));
}
}
$req->save();
/// Accepted and Send Mission Assistand Email if pilot want mission assitand
$miss_assis_id = $req->getMissAssisId();
if ($miss_assis_id) {
$member = MemberPeer::retrieveByPK($req->getMissAssisId());
$externalID = $member->getExternalId();
$person = PersonPeer::retrieveByPK($member->getPersonId());
$frist_name = $person->getFirstName();
$last_name = $person->getLastName();
$name = $frist_name . ' ' . $last_name;
$email = $person->getEmail();
// Accept Mission Assistant
$pilot_request = PilotRequestPeer::getPilotRequestByMemberId($req->getMissAssisId(), $leg_id);
if ($pilot_request instanceof PilotRequest) {
$pilot_request->setAccepted(1);
$pilot_request->setProcessed(1);
$pilot_request->save();
} else {
return $this->renderText("not saved");
}
//return $this->renderText('Pilot Request: '.$pilot_request->getId());
if ($person->getEmail()) {
$pilot_type = "Mission Assistant";
# send email requested pilot
$this->getComponent('mail', 'pilotRequestAccepted', array('email' => $email, 'name' => $name, 'externalID' => $externalID, 'pilot_type' => $pilot_type, 'leg_number' => $leg_number));
}
}
$pilot = PilotPeer::getByMemberId($member_id);
$pilot_id = $pilot->getId();
$mission_leg->setPilotId($pilot_id);
$mission_leg->setMissAssisId($req->getMissAssisId());
$mission_leg->save();
$c = new Criteria();
$c->add(PilotRequestPeer::ID, NULL, Criteria::ISNOTNULL);
if ($req->getMissionAssistantWanted() == 1 && $req->getMissAssisId()) {
$getMemberId = $req->getMissAssisId();
$c->add(PilotRequestPeer::MEMBER_ID, $getMemberId, Criteria::NOT_EQUAL);
}
$c->add(PilotRequestPeer::ACCEPTED, 0);
$c->add(PilotRequestPeer::LEG_ID, $leg_id);
$reqs = PilotRequestPeer::doSelect($c);
foreach ($reqs as $reqpilot) {
if ($reqpilot instanceof PilotRequest) {
// Member information
$member = MemberPeer::retrieveByPK($reqpilot->getMemberId());
$externalID = $member->getExternalId();
// Person information
$person = PersonPeer::retrieveByPK($member->getPersonId());
$frist_name = $person->getFirstName();
$last_name = $person->getLastName();
$name = $frist_name . ' ' . $last_name;
$email = $person->getEmail();
$reqpilot->setAccepted(0);
$reqpilot->setProcessed(1);
$reqpilot->setOnHold(0);
$reqpilot->save();
// Mission Leg information
$mission_leg = MissionLegPeer::retrieveByPK($leg_id);
$leg_number = $mission_leg->getLegNumber();
// Missio information
$mission = MissionPeer::retrieveByPK($mission_leg->getMissionId());
$missionDate = $mission->getMissionDate();
if ($person->getEmail()) {
$this->getComponent('mail', 'pilotRequestNotAccepted', array('email' => $email, 'name' => $name, 'externalID' => $externalID, 'leg_number' => $leg_number, 'missionDate' => $missionDate));
}
}
}
$this->getUser()->setAttribute('pilotAddToLegview', 1);
return $this->renderText($leg_id);
}
}
return sfView::NONE;
}
}
