public function configure()
{
// unset($this['id']);
$wings = WingPeer::getForSelectParent();
$states = sfConfig::get('app_states', array('AL' => 'Alabama', 'AK' => 'Alaska'));
$disable = 'disabled';
if ($this->getObject()->isNew()) {
$disable = '';
}
# Fields
$this->widgetSchema['ident'] = new sfWidgetFormInput(array(), array('class' => 'text airport-new'));
$this->widgetSchema['name'] = new sfWidgetFormInput(array(), array('class' => 'text airport-new'));
$this->widgetSchema['city'] = new sfWidgetFormInput(array(), array('class' => 'text airport-new', 'disabled' => $disable));
$this->widgetSchema['state'] = new sfWidgetFormSelect(array('choices' => $states), array('class' => 'text narrow airport-new', 'disabled' => $disable));
$this->widgetSchema['latitude'] = new sfWidgetFormInput(array(), array('class' => 'text airport-new', 'disabled' => $disable));
$this->widgetSchema['longitude'] = new sfWidgetFormInput(array(), array('class' => 'text airport-new', 'disabled' => $disable));
$this->widgetSchema['runway_length'] = new sfWidgetFormInput(array(), array('class' => 'text airport-new', 'disabled' => $disable));
$this->widgetSchema['wing_id'] = new sfWidgetFormChoice(array('choices' => $wings), array('class' => 'text narrow airport-new', 'disabled' => $disable));
$this->widgetSchema['gmt_offset'] = new sfWidgetFormInput(array(), array('class' => 'text airport-new', 'disabled' => $disable));
$this->widgetSchema['dst_offset'] = new sfWidgetFormInput(array(), array('class' => 'text airport-new', 'disabled' => $disable));
$this->widgetSchema['zipcode'] = new widgetFormInputZipcode(array(), array('class' => 'text narrow airport-new', 'disabled' => $disable));
$this->widgetSchema['closed'] = new sfWidgetFormInputCheckbox(array(), array('value' => 1, 'disabled' => $disable));
$this->widgetSchema->setLabels(array('ident' => 'Ident'));
$this->widgetSchema->setLabels(array('name' => 'Name'));
$this->widgetSchema->setLabels(array('city' => 'City'));
$this->widgetSchema->setLabels(array('state' => 'State'));
$this->widgetSchema->setLabels(array('latitude' => 'Latitude'));
$this->widgetSchema->setLabels(array('longitude' => 'Longitude'));
$this->widgetSchema->setLabels(array('runway_length' => 'Runway length'));
$this->widgetSchema->setLabels(array('wing_id' => 'Wing'));
$this->widgetSchema->setLabels(array('gmt_offset' => 'GMT offset'));
$this->widgetSchema->setLabels(array('dst_offset' => 'DST offset'));
$this->widgetSchema->setLabels(array('zipcode' => 'Zipcode'));
$this->widgetSchema->setLabels(array('closed' => 'Closed'));
$this->validatorSchema['ident'] = new sfValidatorString(array('required' => false));
$this->validatorSchema['name'] = new sfValidatorString(array('required' => false));
$this->validatorSchema['city'] = new sfValidatorString(array('required' => false));
$this->validatorSchema['state'] = new sfValidatorString(array('required' => false));
$this->validatorSchema['latitude'] = new sfValidatorNumber(array('required' => false));
$this->validatorSchema['longitude'] = new sfValidatorNumber(array('required' => false));
$this->validatorSchema['runway_length'] = new sfValidatorInteger(array('required' => false), array('invalid' => 'Runway length must be in numner format !'));
$this->validatorSchema['wing_id'] = new sfValidatorInteger(array('required' => false));
$this->validatorSchema['gmt_offset'] = new sfValidatorInteger(array('required' => false), array('invalid' => 'GMT offset must be in numner format !'));
$this->validatorSchema['dst_offset'] = new sfValidatorInteger(array('required' => false), array('invalid' => 'DST offset must be in numner format !'));
$this->validatorSchema['zipcode'] = new validatorZipcode(array('required' => false), array('max_length' => 10, 'min_length' => 5));
$this->validatorSchema['closed'] = new sfValidatorInteger(array('required' => false));
$this->widgetSchema->setNameFormat('airp[%s]');
}
/**
* Searches for airports by filter
*/
private function processFilter(sfWebRequest $request)
{
$params = $this->getUser()->getAttribute('airport', array(), 'airport');
if (!isset($params['ident'])) {
$params['ident'] = null;
}
if (!isset($params['name'])) {
$params['name'] = null;
}
if (!isset($params['city'])) {
$params['city'] = null;
}
if (!isset($params['state'])) {
$params['state'] = null;
}
if (!isset($params['wing_name'])) {
$params['wing_name'] = null;
}
if (!isset($params['closed'])) {
$params['closed'] = null;
}
$this->max_array = array(5, 10, 20, 30);
$this->wings = WingPeer::getOnlyNames();
if (in_array($request->getParameter('max'), $this->max_array)) {
$params['max'] = $request->getParameter('max');
} else {
if (!isset($params['max'])) {
$params['max'] = sfConfig::get('app_max_person_per_page', 10);
}
}
if ($request->hasParameter('filter')) {
$params['ident'] = $request->getParameter('ident');
$params['name'] = $request->getParameter('name');
$params['city'] = $request->getParameter('city');
$params['state'] = $request->getParameter('state');
$params['wing_name'] = in_array($request->getParameter('wing_name'), array_keys($this->wings)) ? $request->getParameter('wing_name') : '';
$params['closed'] = $request->getParameter('closed');
}
$this->page = $page = $request->getParameter('page', 1);
$this->max = $params['max'];
$this->ident = $params['ident'];
$this->name = $params['name'];
$this->city = $params['city'];
$this->state = $params['state'];
$this->wing_name = $params['wing_name'];
$this->closed = $params['closed'];
$this->getUser()->setAttribute('airport', $params, 'airport');
}
public function configure()
{
unset($this['id'], $this['person_id'], $this['external_id'], $this['master_member_id'], $this['active'], $this['inactive_reason'], $this['inactive_comment'], $this['contact'], $this['renewed_date'], $this['renewal_date'], $this['renewal_notice1'], $this['renewal_notice2'], $this['renewal_notice3'], $this['renewal_notice4'], $this['review_done'], $this['ed_new_member_notify'], $this['wn_new_memberN_ntify'], $this['hold_harmless_received'], $this['member_welcomed'], $this['badge_made'], $this['notebook_sent'], $this['clothing_sent'], $this['s_mod_member_notify'], $this['w_mod_member_notify'], $this['renew_mark'], $this['renewal_sent_date'], $this['s_late_renewal_notify'], $this['w_late_renewal_notify'], $this['s_inactive_notify'], $this['w_inactive_notify'], $this['w_not_oriented_notify_date1'], $this['w_not_oriented_notify_date2'], $this['no_wing_contact_ack']);
$wings = WingPeer::getForSelectParent();
$flight_statuses = sfConfig::get('app_flight_statuses', array('Command pilot' => 'Command pilot'));
# Fields
$this->widgetSchema['date_of_birth'] = new widgetFormDate(array('change_year' => true, 'change_month' => true, 'format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text narrow'));
$this->widgetSchema['weight'] = new sfWidgetFormInput(array(), array('class' => 'text narrow'));
$this->widgetSchema['languages'] = new sfWidgetFormInput(array(), array('class' => 'text'));
$this->widgetSchema['wing_id'] = new sfWidgetFormChoice(array('choices' => $wings), array('class' => 'text narrow'));
$this->widgetSchema['secondary_wing_id'] = new sfWidgetFormChoice(array('choices' => $wings), array('class' => 'text narrow'));
$this->widgetSchema['join_date'] = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text narrow'));
$this->widgetSchema['member_class_id'] = new sfWidgetFormPropelChoice(array('model' => 'MemberClass', 'add_empty' => '-- select --'), array('class' => 'text narrow'));
$this->widgetSchema['spouse_name'] = new sfWidgetFormInput(array(), array('class' => 'text'));
$this->widgetSchema['coordinator_notes'] = new sfWidgetFormTextarea(array(), array('class' => 'text'));
$this->widgetSchema['flight_status'] = new sfWidgetFormSelect(array('choices' => $flight_statuses), array('class' => 'text narrow'));
$this->widgetSchema['co_pilot'] = new sfWidgetFormInputCheckbox(array(), array('value' => 1));
# Labels
$this->widgetSchema->setLabels(array('date_of_birth' => 'Date of birth'));
$this->widgetSchema->setLabels(array('weight' => 'Weight'));
$this->widgetSchema->setLabels(array('languages' => 'Languages'));
$this->widgetSchema->setLabels(array('wing_id' => 'Wing'));
$this->widgetSchema->setLabels(array('secondary_wing_id' => 'Secondary Wing'));
$this->widgetSchema->setLabels(array('join_date' => 'Join Date'));
$this->widgetSchema->setLabels(array('member_class_id' => 'Class'));
$this->widgetSchema->setLabels(array('spouse_name' => 'Spouse/Emergency Name'));
$this->widgetSchema->setLabels(array('coordinator_notes' => 'Coordinator\'s Notes'));
$this->widgetSchema->setLabels(array('flight_status' => 'Flight Status'));
$this->widgetSchema->setLabels(array('co_pilot' => 'Co-Pilot'));
# Validation
$this->validatorSchema['date_of_birth'] = new sfValidatorDate(array('max' => time(), 'required' => false), array('invalid' => 'Date of birth is invalid !.'));
$this->validatorSchema['weight'] = new sfValidatorInteger(array('required' => false), array('required' => 'Please confirm first name !.', 'invalid' => 'Weight is must be in number format!.'));
$this->validatorSchema['languages'] = new sfValidatorString(array('required' => false), array('required' => 'Please confirm last name !'));
$this->validatorSchema['wing_id'] = new sfValidatorString(array('required' => false));
$this->validatorSchema['secondary_wing_id'] = new sfValidatorString(array('required' => false));
$this->validatorSchema['join_date'] = new sfValidatorDate(array('max' => time(), 'required' => true), array('invalid' => 'Join date is invalid !'));
$this->validatorSchema['member_class_id'] = new sfValidatorInteger(array('required' => true), array('required' => 'Please choice member class!'));
$this->validatorSchema['spouse_name'] = new sfValidatorString(array('required' => false));
$this->validatorSchema['coordinator_notes'] = new sfValidatorString(array('required' => false));
$this->validatorSchema['flight_status'] = new sfValidatorString(array('required' => true), array('required' => 'Please choice flight status !'));
$this->validatorSchema['co_pilot'] = new sfValidatorInteger(array('required' => false));
# Descriptive message
$this->setDefault('join_date', date("m/d/y"));
#help
$this->widgetSchema->setHelp('weight', 'lbs.');
$this->widgetSchema->setNameFormat('mem[%s]');
}
/**
* Wing delete
* CODE:wing_delete
*/
public function executeDelete(sfWebRequest $request)
{
#security
if (!$this->getUser()->hasCredential(array('Administrator'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
$request->checkCSRFProtection();
try {
$wing = WingPeer::retrieveByPK($request->getParameter('id'));
$this->forward404Unless($wing);
$wing->delete();
$this->getUser()->setFlash('success', "Successfully deleted.");
} catch (Exception $e) {
$this->getUser()->setFlash('warning', "There are related persons to this wing. Please remove them first.");
}
$this->redirect('wing/index');
}
?>
<?php
$person = PersonPeer::retrieveByPK($person_id);
?>
<?php
}
?>
<?php
$wing_id = $member->getWingId();
?>
<?php
if ($wing_id) {
?>
<?php
$wing = WingPeer::retrieveByPK($wing_id);
?>
<?php
}
?>
<tr>
<td class="cell-1">
<?php
if (isset($member)) {
echo $member->getExternalId();
}
?>
</td>
<td class="cell-1">
<?php
private function processFilterNew(sfWebRequest $request)
{
$params = $this->getUser()->getAttribute('event');
//set max
if (!isset($params['max'])) {
$params['max'] = 10;
}
$this->max_array = array(5, 10, 20, 30);
if (in_array($request->getParameter('max'), $this->max_array)) {
$params['max'] = $request->getParameter('max');
}
//set page
if (!isset($params['page'])) {
$params['page'] = 1;
}
if ($request->getParameter('page')) {
$params['page'] = $request->getParameter('page');
}
//set wing id & wing name
if (!isset($params['wing_id'])) {
$params['wing_id'] = 0;
}
if (!isset($params['wingname'])) {
$params['wingname'] = 0;
}
if ($request->hasParameter('filter')) {
$name = $request->getParameter('wing_name');
if (empty($name)) {
$params['wing_id'] = 0;
$params['wingname'] = 0;
} else {
$wing_obj = WingPeer::getByName($request->getParameter('wing_name'));
$wing_id = $wing_obj->getId();
$params['wing_id'] = $wing_id;
$params['wingname'] = $name;
}
}
//Reset all
if ($request->getParameter('reset')) {
$params['wing_id'] = 0;
}
//value set for pager
$this->page = $params['page'];
$this->max = $params['max'];
$this->wing_id = $params['wing_id'];
$this->wingname = $params['wingname'];
$this->getUser()->setAttribute('event', $params);
}
<?php
echo $form['long_desc'];
?>
</td>
</tr>
<tr>
<th><?php
echo "Participating Wings";
//echo $form['wing_id']
?>
</th>
<td>
<ul class="checkbox_list">
<?php
$wing = new Criteria();
$wings = WingPeer::doSelect($wing);
foreach ($wings as $wing_list) {
?>
<li>
<input type="checkbox" <?php
if ($form->getObject()->getId() != '') {
foreach ($ch as $ch_list) {
if ($ch_list->getWingId() == $wing_list->getId()) {
echo 'checked="checked"';
}
}
}
?>
id="event_wing_id_<?php
echo $wing_list->getId();
?>
/**
* Populates the object using an array.
*
* This is particularly useful when populating an object from one of the
* request arrays (e.g. $_POST). This method goes through the column
* names, checking to see whether a matching key exists in populated
* array. If so the setByName() method is called for that column.
*
* You can specify the key type of the array by additionally passing one
* of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
* BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
* The default key type is the column's phpname (e.g. 'AuthorId')
*
* @param array $arr An array to populate the object from.
* @param string $keyType The type of keys the array uses.
* @return void
*/
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = WingPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setName($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setNewsletterAbbreviation($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setDisplayName($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setState($arr[$keys[4]]);
}
}
/**
* Get the associated Wing object
*
* @param PropelPDO Optional Connection object.
* @return Wing The associated Wing object.
* @throws PropelException
*/
public function getWing(PropelPDO $con = null)
{
if ($this->aWing === null && $this->wing_id !== null) {
$c = new Criteria(WingPeer::DATABASE_NAME);
$c->add(WingPeer::ID, $this->wing_id);
$this->aWing = WingPeer::doSelectOne($c, $con);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aWing->addEmailLists($this);
*/
}
return $this->aWing;
}
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';
}
public function executeAutoCompleteRegion()
{
$this->region_name = $this->getRequestParameter('mop_regions_served');
$this->wing_names = WingPeer::getResionServedNames($this->region_name);
}
private function processRosterFilter(sfWebRequest $request)
{
$params = $this->getUser()->getAttribute('member_roster', array(), 'person');
if (!isset($params['pilot_status'])) {
$params['pilot_status'] = null;
}
if (!isset($params['wing_id'])) {
$params['wing_id'] = 0;
}
if (!isset($params['ifr'])) {
$params['ifr'] = null;
}
if (!isset($params['multi'])) {
$params['multi'] = null;
}
if (!isset($params['instructor'])) {
$params['instructor'] = null;
}
if (!isset($params['board_member'])) {
$params['board_member'] = null;
}
if (!isset($params['coordinator'])) {
$params['coordinator'] = null;
}
if (!isset($params['orientation_pilot'])) {
$params['orientation_pilot'] = null;
}
if (!isset($params['state'])) {
$params['state'] = null;
}
if (!isset($params['home_base'])) {
$params['home_base'] = null;
}
if (!isset($params['area_code'])) {
$params['area_code'] = null;
}
if (!isset($params['email'])) {
$params['email'] = null;
}
if (!isset($params['wing_job1'])) {
$params['wing_job1'] = null;
}
$this->pilot_statuses = array_merge(array('' => 'All'), sfConfig::get('app_flight_statuses', array()));
$this->wings = array_merge(array(0 => 'All'), WingPeer::getNames());
if ($request->hasParameter('filter')) {
$params['wing_id'] = in_array($request->getParameter('wing_id'), array_keys($this->wings)) ? $request->getParameter('wing_id') : 0;
$params['pilot_status'] = in_array($request->getParameter('pilot_status'), array_keys($this->pilot_statuses)) ? $request->getParameter('pilot_status') : '';
$params['ifr'] = $request->getParameter('ifr');
$params['multi'] = $request->getParameter('multi');
$params['instructor'] = $request->getParameter('instructor');
$params['board_member'] = $request->getParameter('board_member');
$params['coordinator'] = $request->getParameter('coordinator');
$params['orientation_pilot'] = $request->getParameter('orientation_pilot');
$params['state'] = $request->getParameter('state');
$params['home_base'] = $request->getParameter('home_base');
$params['area_code'] = $request->getParameter('area_code');
$params['email'] = $request->getParameter('email');
$params['wing_job1'] = $request->getParameter('wing_job1');
}
$this->page = $page = $request->getParameter('page', 1);
$this->max = sfConfig::get('app_max_member_roster_per_pager');
$this->pilot_status = $params['pilot_status'];
$this->wing_id = $params['wing_id'];
$this->ifr = $params['ifr'];
$this->multi = $params['multi'];
$this->instructor = $params['instructor'];
$this->board_member = $params['board_member'];
$this->coordinator = $params['coordinator'];
$this->orientation_pilot = $params['orientation_pilot'];
$this->state = $params['state'];
$this->home_base = $params['home_base'];
$this->area_code = $params['area_code'];
$this->email = $params['email'];
$this->wing_job1 = $params['wing_job1'];
$this->getUser()->setAttribute('member_roster', $params, 'person');
}
/**
* 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 = "";
}
}
/**
* Missing waivers
* CODE:missing_waivers
* TODO:
*/
public function executeMissingWaivers(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');
}
# filter
$this->processMissingWaiversFilter($request);
$this->pager = MissionLegPeer::getMissingWaiversPager($this->max, $this->page, $this->mission_date1, $this->mission_date2, $this->pass_name, $this->pilot_name, $this->wing);
$this->leg_list = $this->pager->getResults();
$this->wings = WingPeer::doSelect(new Criteria());
$this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text'));
}
public function executeEditPilot(sfWebRequest $request)
{
$member = MemberPeer::retrieveByPK($this->getUser()->getMemberId());
$this->forward404Unless($member);
$pilot = $member->getPilot();
$this->forward404Unless($pilot);
$this->flight_status = $member->getFlightStatus();
$this->co_pilot = $member->getCoPilot();
$this->license_type = $pilot->getLicenseType();
$this->wing_id = $member->getWingId();
$this->primary_airport_id = $pilot->getPrimaryAirportId();
$this->secondary_airport_id = $pilot->getPrimaryAirportId();
// TODO change to secondary
$this->flight_statuses = sfConfig::get('app_flight_statuses', array());
$this->license_types = sfConfig::get('app_pilot_license_types', array());
$this->wings = WingPeer::getNames();
}
/**
* 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(WingPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(WingPeer::DATABASE_NAME);
$criteria->add(WingPeer::ID, $pks, Criteria::IN);
$objs = WingPeer::doSelect($criteria, $con);
}
return $objs;
}
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
}
/**
* Selects a collection of Member objects pre-filled with all related objects except MemberRelatedByMasterMemberId.
*
* @param Criteria $c
* @param PropelPDO $con
* @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
* @return array Array of Member objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAllExceptMemberRelatedByMasterMemberId(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$c = clone $c;
// Set the correct dbName if it has not been overridden
// $c->getDbName() will return the same object if not set to another value
// so == check is okay and faster
if ($c->getDbName() == Propel::getDefaultDB()) {
$c->setDbName(self::DATABASE_NAME);
}
MemberPeer::addSelectColumns($c);
$startcol2 = MemberPeer::NUM_COLUMNS - MemberPeer::NUM_LAZY_LOAD_COLUMNS;
PersonPeer::addSelectColumns($c);
$startcol3 = $startcol2 + (PersonPeer::NUM_COLUMNS - PersonPeer::NUM_LAZY_LOAD_COLUMNS);
WingPeer::addSelectColumns($c);
$startcol4 = $startcol3 + (WingPeer::NUM_COLUMNS - WingPeer::NUM_LAZY_LOAD_COLUMNS);
MemberClassPeer::addSelectColumns($c);
$startcol5 = $startcol4 + (MemberClassPeer::NUM_COLUMNS - MemberClassPeer::NUM_LAZY_LOAD_COLUMNS);
$c->addJoin(array(MemberPeer::PERSON_ID), array(PersonPeer::ID), $join_behavior);
$c->addJoin(array(MemberPeer::WING_ID), array(WingPeer::ID), $join_behavior);
$c->addJoin(array(MemberPeer::MEMBER_CLASS_ID), array(MemberClassPeer::ID), $join_behavior);
$stmt = BasePeer::doSelect($c, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = MemberPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = MemberPeer::getInstanceFromPool($key1))) {
// We no longer rehydrate the object, since this can cause data loss.
// See http://propel.phpdb.org/trac/ticket/509
// $obj1->hydrate($row, 0, true); // rehydrate
} else {
$omClass = MemberPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj1 = new $cls();
$obj1->hydrate($row);
MemberPeer::addInstanceToPool($obj1, $key1);
}
// if obj1 already loaded
// Add objects for joined Person rows
$key2 = PersonPeer::getPrimaryKeyHashFromRow($row, $startcol2);
if ($key2 !== null) {
$obj2 = PersonPeer::getInstanceFromPool($key2);
if (!$obj2) {
$omClass = PersonPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj2 = new $cls();
$obj2->hydrate($row, $startcol2);
PersonPeer::addInstanceToPool($obj2, $key2);
}
// if $obj2 already loaded
// Add the $obj1 (Member) to the collection in $obj2 (Person)
$obj2->addMember($obj1);
}
// if joined row is not null
// Add objects for joined Wing rows
$key3 = WingPeer::getPrimaryKeyHashFromRow($row, $startcol3);
if ($key3 !== null) {
$obj3 = WingPeer::getInstanceFromPool($key3);
if (!$obj3) {
$omClass = WingPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj3 = new $cls();
$obj3->hydrate($row, $startcol3);
WingPeer::addInstanceToPool($obj3, $key3);
}
// if $obj3 already loaded
// Add the $obj1 (Member) to the collection in $obj3 (Wing)
$obj3->addMember($obj1);
}
// if joined row is not null
// Add objects for joined MemberClass rows
$key4 = MemberClassPeer::getPrimaryKeyHashFromRow($row, $startcol4);
if ($key4 !== null) {
$obj4 = MemberClassPeer::getInstanceFromPool($key4);
if (!$obj4) {
$omClass = MemberClassPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj4 = new $cls();
$obj4->hydrate($row, $startcol4);
MemberClassPeer::addInstanceToPool($obj4, $key4);
}
// if $obj4 already loaded
// Add the $obj1 (Member) to the collection in $obj4 (MemberClass)
$obj4->addMember($obj1);
}
// if joined row is not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
/**
* Selects a collection of EmailList objects pre-filled with all related objects.
*
* @param Criteria $c
* @param PropelPDO $con
* @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
* @return array Array of EmailList objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAll(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
foreach (sfMixer::getCallables('BaseEmailListPeer:doSelectJoinAll:doSelectJoinAll') as $callable) {
call_user_func($callable, 'BaseEmailListPeer', $c, $con);
}
$c = clone $c;
// Set the correct dbName if it has not been overridden
if ($c->getDbName() == Propel::getDefaultDB()) {
$c->setDbName(self::DATABASE_NAME);
}
EmailListPeer::addSelectColumns($c);
$startcol2 = EmailListPeer::NUM_COLUMNS - EmailListPeer::NUM_LAZY_LOAD_COLUMNS;
WingPeer::addSelectColumns($c);
$startcol3 = $startcol2 + (WingPeer::NUM_COLUMNS - WingPeer::NUM_LAZY_LOAD_COLUMNS);
$c->addJoin(array(EmailListPeer::WING_ID), array(WingPeer::ID), $join_behavior);
$stmt = BasePeer::doSelect($c, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = EmailListPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = EmailListPeer::getInstanceFromPool($key1))) {
// We no longer rehydrate the object, since this can cause data loss.
// See http://propel.phpdb.org/trac/ticket/509
// $obj1->hydrate($row, 0, true); // rehydrate
} else {
$omClass = EmailListPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj1 = new $cls();
$obj1->hydrate($row);
EmailListPeer::addInstanceToPool($obj1, $key1);
}
// if obj1 already loaded
// Add objects for joined Wing rows
$key2 = WingPeer::getPrimaryKeyHashFromRow($row, $startcol2);
if ($key2 !== null) {
$obj2 = WingPeer::getInstanceFromPool($key2);
if (!$obj2) {
$omClass = WingPeer::getOMClass();
$cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1);
$obj2 = new $cls();
$obj2->hydrate($row, $startcol2);
WingPeer::addInstanceToPool($obj2, $key2);
}
// if obj2 loaded
// Add the $obj1 (EmailList) to the collection in $obj2 (Wing)
$obj2->addEmailList($obj1);
}
// if joined row not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
