/**
* Searches for requesters
* CODE: requester_index
*/
public function executeIndex(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');
}
if ($request->hasParameter('mission_for')) {
//$mission_leg = MissionLegPeer::retrieveByPK($request->getParameter('mission_for'));
$this->mission_for = MissionPeer::retrieveByPK($request->getParameter('mission_for'));
$this->can_use = 1;
} else {
$this->change_id = null;
}
$exclude_ids = array();
if ($this->mission_for) {
$exclude_ids[] = $this->mission_for->getId();
}
# for navigation menu
sfContext::getInstance()->getConfiguration()->loadHelpers('Partial');
slot('nav_menu', array('mission_coord', ''));
# filter
$this->processFilter($request);
if ($request->isMethod('post') || $request->getParameter('page')) {
$this->pager = RequesterPeer::getPager($this->max, $this->page, $this->firstname, $this->lastname, $this->city, $this->state, $this->agency_name, $exclude_ids);
$this->requesters = $this->pager->getResults();
}
# one result with member_id search will go to member view
if (count($this->requesters) == 1) {
if ($this->mission_for) {
$url_add = '&mission_for=' . $this->mission_for->getId();
} else {
$url_add = '';
}
if ($request->getParameter('mission_for')) {
$this->redirect('@leg_edit?id=' . $request->getParameter('mission_for') . $url_add);
}
}
$this->getUser()->addRecentItem('Requesters', 'requesters', 'requester/index');
}
<td class="cell-1">Mission Date</td>
<td class="cell-2">Passenger Name</td>
<td class="cell-3">Pilot Name</td>
<td class="cell-4">Date Received</td>
</tr>
</thead>
<tbody>
<?php
$line = 0;
?>
<?php
foreach ($leg_list as $leg) {
?>
<tr>
<?php
$mission = MissionPeer::retrieveByPK($leg->getMissionId());
?>
<td>
<div class="date-list">
<?php
echo $mission->getMissionDate('m/d/Y');
?>
<br/>
<?php
echo $mission->getExternalId();
?>
</div>
</td>
<td class="cell-3">
<div class="s-list">
<?php
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 executePrintMissionLeg(sfWebRequest $request)
{
#Security
if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Coordinator'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
if ($request->getParameter('id')) {
$this->leg = MissionLegPeer::retrieveByPK($request->getParameter('id'));
if (isset($this->leg)) {
$this->mission = MissionPeer::retrieveByPK($this->leg->getMissionId());
$this->requester = RequesterPeer::retrieveByPK($this->mission->getRequesterId());
$this->req_person = $this->requester->getPerson();
$this->agency = $this->requester->getAgency();
// Camp information
if ($this->mission->getCampId()) {
$this->camp = CampPeer::retrieveByPK($this->mission->getCampId());
}
//Coordinator
if ($this->mission->getCoordinatorId()) {
$this->coordinator = CoordinatorPeer::retrieveByPK($this->mission->getCoordinatorId());
$this->coordiPerson = PersonPeer::retrieveByPK($this->coordinator->getMember()->getPersonId());
}
if (isset($this->mission)) {
$this->itinerary = ItineraryPeer::retrieveByPK($this->mission->getItineraryId());
$pass = PassengerPeer::retrieveByPK($this->mission->getPassengerId());
//Companions information
$this->companions = CompanionPeer::getByPassId($this->mission->getPassengerId());
if (isset($pass) && $pass instanceof Passenger) {
$this->pass = $pass;
//print_r($this->pass);
//die();
$this->person = PersonPeer::retrieveByPK($pass->getPersonId());
$this->itinerary = $this->mission->getItinerary();
// Pre-define addresses for ground missions
$this->ground_addresses = array('patient' => '', 'facility' => '', 'lodging' => '', 'airport' => '');
$this->ground_addr_sel = sfConfig::get('app_ground_address_type', array());
if ($this->itinerary) {
//$this->ground_addresses['lodging'] = $this->ground_addresses['facility'] = $this->itinerary->getDestCity().', '.$this->itinerary->getDestState();
}
} else {
unset($this->passenger);
}
}
}
if (isset($this->leg) && $this->leg instanceof MissionLeg) {
if ($this->leg->getPilotId()) {
$this->pilot = PilotPeer::retrieveByPK($this->leg->getPilotId());
$this->pilot_member = MemberPeer::retrieveByPK($this->pilot->getMemberId());
$this->copilot = PilotPeer::retrieveByPK($this->leg->getCoPilotId());
$this->mission_assistant = PilotPeer::getByMemberId($this->leg->getMissAssisId());
$this->back_up_mission_assistant = PilotPeer::retrieveByPK($this->leg->getBackupMissAssisId());
}
}
if ($this->getUser()->hasAttribute('pilotAddToLegview')) {
$this->getUser()->setFlash("success", 'Pilot is added to this mission leg successfully !');
$this->getUser()->getAttributeHolder()->remove('pilotAddToLegview');
}
}
}
/**
* 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;
}
}
public function executeCopy(sfWebRequest $request)
{
$type = $request->getParameter('type');
$miss_id = $request->getParameter('id');
$mission_old = MissionPeer::retrieveByPK($miss_id);
$mission = new Mission();
$mission_old->copyInto($mission);
$msId = 'copy of ' . $miss_id;
$mission->setExternalId(MissionPeer::getLatestExternalId());
$mission->setCopiedMission($msId);
$mission->setMissionDate(date('Y-m-d H:i:m'));
$mission->save();
$mission_legs = MissionLegPeer::getbyMissIdDown($mission_old->getId());
if ($type === "copy") {
foreach ($mission_legs as $mission_leg) {
$mi_leg = new MissionLeg();
$mission_leg->copyInto($mi_leg);
$mlgId = 'copy of ' . $mission_leg->getId();
$mi_leg->setMissionId($mission->getId());
$mi_leg->setCopiedMissionLeg($mlgId);
$mi_leg->save();
}
$this->getUser()->setFlash('success', "The mission have been copied successfully.");
$this->redirect('mission/index');
} else {
foreach ($mission_legs as $mission_leg) {
$mi_leg = new MissionLeg();
$mission_leg->copyInto($mi_leg);
$mi_leg->setMissionId($mission->getId());
$from = $mi_leg->getFromAirportId();
$to = $mi_leg->getToAirportId();
$mi_leg->setFromAirportId($to);
$mi_leg->setToAirportId($from);
$mi_leg->save();
}
$this->getUser()->setFlash('success', "The mission have been reversed successfully.");
$this->redirect('mission/index');
}
}
