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