/**
* 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;
}
}
