/**
* 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(MissionTypePeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(MissionTypePeer::DATABASE_NAME);
$criteria->add(MissionTypePeer::ID, $pks, Criteria::IN);
$objs = MissionTypePeer::doSelect($criteria, $con);
}
return $objs;
}
?>
<label for="form-item-7">IFR Backup</label>
</li>
</ul>
<strong>Show:</strong>
<a href="#" class="all-missions" name="all_types" id="all_types" onclick="javascript:jQuery('#mtypes').css('display','block');">
<label id="types_text">All Mission Types</label></a>
<div id="mtypes" class="all-mtype">
<div class="holder">
<div class="bg">
<a href="#" class="all-missions" name="c_all_types" id="c_all_types">All/None</a>
<input type="hidden" name="checkflag" value="0"/>
<br/>
<table>
<?php
$mission_types = MissionTypePeer::doSelect(new Criteria());
?>
<?php
foreach ($mission_types as $mission_type) {
?>
<tr>
<td>
<?php
echo checkbox_tag('selected_types[]', $mission_type->getId(), in_array($mission_type->getId(), $selected_types), array("id" => "ru" . $mission_type->getId()));
?>
<label for="<?php
echo "ru" . $mission_type->getId();
?>
"><?php
echo $mission_type->getName();
?>
public function executeAvailableMissions(sfWebRequest $request)
{
$pilot = PilotPeer::retrieveByPK($this->getUser()->getPilotId());
if (!$pilot instanceof Pilot) {
return sfView::NONE;
}
if ($pilot->getPrimaryAirportId()) {
$this->mission_legs = MissionLegPeer::getPilotNear($pilot->getPrimaryAirportId());
} else {
$this->mission_legs = array();
}
$this->home_airport = $pilot->getAirport();
$ids = array();
foreach ($this->mission_legs as $leg) {
$ids[] = $leg->getId();
}
$c = new Criteria();
$c->add(MissionLegPeer::TRANSPORTATION, 'air_mission');
$c->add(MissionLegPeer::ID, $ids, Criteria::NOT_IN);
$c->add(MissionLegPeer::CANCELLED, null, Criteria::ISNULL);
$c1 = $c->getNewCriterion(MissionLegPeer::PILOT_ID, null, Criteria::ISNULL);
$c2 = $c->getNewCriterion(MissionLegPeer::COPILOT_ID, null, Criteria::ISNULL);
$c->add($c1->addOr($c2));
$c->setLimit(50);
$this->interest_legs = MissionLegPeer::doSelectJoinMission($c);
$c->clear();
$c->addJoin(MissionLegPeer::ID, PilotRequestPeer::LEG_ID, Criteria::LEFT_JOIN);
$c->add(PilotRequestPeer::ACCEPTED, 1, Criteria::NOT_EQUAL);
$c->add(MissionLegPeer::TRANSPORTATION, 'air_mission');
//$c->addAscendingOrderByColumn();
$c->setLimit(50);
$this->pending_legs = MissionLegPeer::doSelectJoinMission($c);
//ziyed
// validity
$person = PersonPeer::retrieveByPK($this->getUser()->getId());
//$this->forward404Unless($person);
$member = $person->getMember();
//$this->forward404Unless($member);
if ($member) {
$pilot = $member->getPilot();
} else {
$pilot = null;
}
// filter related
$this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text'));
if ($pilot) {
$this->personal_flights = $pilot->getPersonalFlights();
} else {
$this->personal_flights = array();
}
$this->wings = WingPeer::doSelect(new Criteria());
$this->idents = AirportPeer::doSelect(new Criteria());
$this->states = sfConfig::get('app_short_states');
$this->mission_types = MissionTypePeer::doSelect(new Criteria());
$this->member = $member;
$this->pilot = $pilot;
if ($pilot) {
$this->airport = $pilot->getAirport();
} else {
$this->airport = null;
}
if ($request) {
$this->processFilterForm($request);
}
if ($request->getParameter('needs') == 1) {
$this->needs_pilot = 1;
}
$this->pager = MissionPeer::getPilotAvailablePager($this->max, $this->airport, $this->page, $this->sort_by, $this->date_range1, $this->date_range2, $this->weekdays, $this->wing_id, $this->ident, $this->city, $this->state, $this->zip, $this->origin, $this->dest, $this->needs_pilot, $this->co_pilot, $this->ifr, $this->selected_types, $this->filled, $this->open, $this->max_pass, $this->max_weight, $this->max_distance, $this->min_efficiency, false, $this->ignore_availability);
$this->miss_array = $this->pager->getResults();
$this->total_mission_available = $this->pager->getNbResults();
$this->missions = MissionPeer::getByMayInterested($this->airport, $this->min_efficiency);
$ident = $request->getParameter('airport_ident');
if (!empty($ident)) {
$this->airport_ident = $request->getParameter('airport_ident');
} else {
$this->airport_ident = "";
}
//end ziyed
}
public function executePilotRequestAcceptedView(sfWebRequest $request)
{
#security
if (!$this->getUser()->hasCredential(array('Administrator', 'Pilot', 'Staff', 'Coordinator', 'Volunteer'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
$person = PersonPeer::retrieveByPK($this->getUser()->getId());
$this->forward404Unless($person);
$member = $person->getMember();
if ($member) {
$pilot = $member->getPilot();
} else {
$pilot = null;
}
$this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text'));
if ($pilot) {
$this->personal_flights = $pilot->getPersonalFlights();
} else {
$this->personal_flights = array();
}
$this->wings = WingPeer::doSelect(new Criteria());
$this->idents = AirportPeer::doSelect(new Criteria());
$this->states = sfConfig::get('app_short_states');
$this->mission_types = MissionTypePeer::doSelect(new Criteria());
$this->member = $member;
$this->pilot = $pilot;
if ($pilot) {
$this->airport = $pilot->getAirport();
} else {
$this->airport = null;
}
if ($request->getParameter('needs') == 1) {
$this->needs_pilot = 1;
}
$c = new Criteria();
$c->add(PilotRequestPeer::ACCEPTED, 1);
$c->add(PilotRequestPeer::MEMBER_ID, $member->getId());
$c->addJoin(PilotRequestPeer::LEG_ID, MissionLegPeer::ID);
$c->addJoin(MissionLegPeer::MISSION_ID, MissionPeer::ID);
//$this->result = MissionPeer::doSelect($c);
$this->page = $request->getParameter("page", 1);
$this->max = $request->getParameter("max", 10);
$this->pager = new sfPropelPager('MissionLeg', $this->max);
$this->pager->setCriteria($c);
$this->pager->setPage($this->page);
$this->pager->init();
$this->miss_legs = $this->pager->getResults();
$this->url = 'pilotRequestAcceptedView';
}
/**
* Available missions for a pilot
* CODE: mission_view
* CODE: mission_available
*/
public function executeRequestLegs(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->getUri());
$this->redirect('dashboard/index');
}
// validity
$person = PersonPeer::retrieveByPK($this->getUser()->getId());
$this->forward404Unless($person);
$member = $person->getMember();
//$this->forward404Unless($member);
if ($member) {
$pilot = $member->getPilot();
} else {
$pilot = null;
}
// filter related
$this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text'));
if ($pilot) {
$this->personal_flights = $pilot->getPersonalFlights();
} else {
$this->personal_flights = array();
}
$this->wings = WingPeer::doSelect(new Criteria());
$this->idents = AirportPeer::doSelect(new Criteria());
$this->states = sfConfig::get('app_short_states');
$this->mission_types = MissionTypePeer::doSelect(new Criteria());
$this->member = $member;
$this->pilot = $pilot;
if ($pilot) {
$this->airport = $pilot->getAirport();
} else {
$this->airport = null;
}
$this->processFilterForm($request);
if ($request->getParameter('needs') == 1) {
$this->needs_pilot = 1;
}
$this->pager = MissionPeer::getPilotAvailablePager($this->max, $this->airport, $this->page, $this->sort_by, $this->date_range1, $this->date_range2, $this->weekdays, $this->wing_id, $this->ident, $this->city, $this->state, $this->zip, $this->origin, $this->dest, $this->needs_pilot, $this->co_pilot, $this->ifr, $this->selected_types, $this->filled, $this->open, $this->max_pass, $this->max_weight, $this->max_distance, $this->min_efficiency, false, $this->ignore_availability);
// $this->pager = MissionPeer::getMissionsAvailable();
$this->miss_array = $this->pager->getResults();
//echo "<pre>";
//print_r($this->miss_array);exit;
$this->missions = MissionPeer::getByMayInterested($this->airport, $this->min_efficiency);
$ident = $request->getParameter('airport_ident');
if (!empty($ident)) {
$this->airport_ident = $request->getParameter('airport_ident');
} else {
$this->airport_ident = "";
}
}
/**
* Mission Available with camps Pilot view
* CODE:mission_available_camp
*/
public function executeAvailableCamp(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');
}
// validity
$person = PersonPeer::retrieveByPK($this->getUser()->getId());
$this->forward404Unless($person);
$member = $person->getMember();
// $this->forward404Unless($member);
if ($member) {
$pilot = $member->getPilot();
} else {
$pilot = null;
}
// $this->forward404Unless($pilot);
if ($pilot && $pilot->getPrimaryAirportId() === null) {
$this->getUser()->setFlash('warning', 'Please confirm Primary Airport!');
$this->redirect('account/index');
}
// filter related
$this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text'));
if ($pilot) {
$this->personal_flights = $pilot->getPersonalFlights();
} else {
$this->personal_flights = array();
}
$this->wings = WingPeer::doSelect(new Criteria());
$this->idents = AirportPeer::doSelect(new Criteria());
$this->states = sfConfig::get('app_short_states');
$this->mission_types = MissionTypePeer::doSelect(new Criteria());
if ($member) {
$this->av = $member->getAvailability();
} else {
$this->av = null;
}
$this->member = $member;
$this->pilot = $pilot;
if ($pilot) {
$this->primary_airport_id = $pilot->getPrimaryAirportId();
} else {
$this->primary_airport_id = null;
}
if ($pilot) {
$this->airport = $pilot->getAirport();
} else {
$this->airport = null;
}
$this->processFilterForm($request);
$this->pager = MissionPeer::getPilotAvailablePager($this->max, $this->airport, $this->page, $this->sort_by, $this->date_range1, $this->date_range2, $this->weekdays, $this->wing_id, $this->ident, $this->city, $this->state, $this->zip, $this->origin, $this->dest, $this->needs_pilot, $this->co_pilot, $this->ifr, $this->selected_types, $this->filled, $this->open, $this->max_pass, $this->max_weight, $this->max_distance, $this->min_efficiency, true, $this->ignore_availability);
$this->miss_array = $this->pager->getResults();
$this->missions = MissionPeer::getByMayInterested();
/*
if(isset($pilot) && $pilot->getPrimaryAirportId() != null && $pilot instanceof Pilot){
#get the Pilot's nearest Mission Legs with camps
$this->mission_legs = MissionLegPeer::getPilotNearWithCamp($pilot->getPrimaryAirportId());
echo var_dump($this->mission_legs);die();
$this->missions = array();
$this->camps = array();
$count=0;
foreach ($this->mission_legs as $leg){
if($leg->getToAirportId()){
$this->destination_airport = $leg->getToAirportId();
}
$this->missions[$count] = MissionPeer::retrieveByPK($leg->getMissionId());
$this->camps[$count] = CampPeer::retrieveByPK(MissionPeer::retrieveByPK($leg->getMissionId())->getCampId());
$count++;
}
#get Missions Pilot may interested
$this->imissions = MissionPeer::getByMayInterested();
$this->miss_pre = array();
$this->miss_array = array();
$this->miss_ids = array();
$count_pre = 0;
$count = 0;
$check = 0;
foreach ($this->mission_legs as $leg){
$this->miss_ids[$leg->getMissionId()] = $leg->getMissionId();
}
foreach ($this->mission_legs as $leg){
if($this->miss_ids[$leg->getMissionId()] == $leg->getMissionId()){
$this->miss_array[$leg->getMissionId()] = $leg->getMissionId();
$count++;
}
}
}else{
if($pilot->getPrimaryAirportId() == null && isset($pilot)){
$this->getUser()->setFlash('success','Pilot has not confirm Primary Airport!!');
$this->redirect('@pilot_view?id='.$pilot->getId());
}
$this->getUser()->setFlash('success','You are not Pilot yet!');
$this->redirect($request->getReferer());
}
}else{
$this->mission_legs = MissionLegPeer::doSelect(new Criteria());
$this->missions = MissionPeer::getByMayInterested();
$this->miss_pre = array();
$this->miss_array = array();
$this->miss_ids = array();
$count_pre = 0;
$count = 0;
$check = 0;
foreach ($this->mission_legs as $leg){
$this->miss_ids[$leg->getMissionId()] = $leg->getMissionId();
}
foreach ($this->mission_legs as $leg){
if($this->miss_ids[$leg->getMissionId()] == $leg->getMissionId()){
$this->miss_array[$leg->getMissionId()] = $leg->getMissionId();
$count++;
}
}
}
}*/
}
