/** * Executes index action * * @param sfRequest $request A request object */ public function executeIndex(sfWebRequest $request) { # for navigation menu sfContext::getInstance()->getConfiguration()->loadHelpers('Partial'); slot('nav_menu', array('instrument', '')); #security /* if( !$this->getUser()->hasCredential(array('Administrator','Staff','Pilot','Member','Coordinator','Volunteer'), false)){ $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url '.$request->getReferer()); $this->redirect('dashboard/index'); }*/ if ($request->getParameter('type')) { $this->flag = 1; } if ($request->hasParameter('return')) { $this->pilot_request = 1; } if ($request->hasParameter('avail')) { $this->window_loc = 'avail'; } if ($request->hasParameter('window_loc_visual')) { $this->window_loc_visual = 'window_loc_visual'; } $member_id = $this->getUser()->getMemberId(); $member = MemberPeer::retrieveByPK($member_id); $pilot = $member->getPilot(); if ($request->getParameter('first') == 1) { if ($pilot) { $first_airport = AirportPeer::retrieveByPK($pilot->getPrimaryAirportId()); $this->orgin_airport = $first_airport->getIdent(); } $this->types = MissionTypePeer::getOnlyNames(); $this->dest_airport = null; $this->miss_type = null; $this->miss_date1 = null; $this->miss_date2 = null; } else { $this->processFilterVisual($request); } $this->airport_list = AirportPeer::getMappable(); $this->legs = MissionLegPeer::getMappable($this->orgin_airport, $this->dest_airport, $this->miss_type, $this->miss_date1, $this->miss_date2); $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); }
/** * Add or edit coordinator * CODE: coordinator_create */ public function executeUpdate(sfWebRequest $request) { # security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } if ($request->getParameter('member_id')) { $this->member = MemberPeer::retrieveByPK($request->getParameter('member_id')); } if ($request->getParameter('id')) { $this->coor = CoordinatorPeer::retrieveByPK($request->getParameter('id')); $this->title = 'Edit Coordinator'; $success = 'Coordinator information has been successfully edited!'; $this->member = MemberPeer::retrieveByPK($this->coor->getMemberId()); } else { $this->coor = new Coordinator(); $this->title = 'Add Coordinator'; $success = 'Coordinator information has been successfully created!'; } if ($request->getParameter('leg')) { $this->leg_id = $request->getParameter('leg'); } if ($request->getParameter('member')) { $this->member = MemberPeer::retrieveByPK($request->getParameter('member')); } $this->form = new CoordinatorForm($this->coor); $this->back = $request->getReferer(); if ($request->isMethod('post')) { $this->referer = $request->getReferer(); $this->form->bind($request->getParameter('coor')); if ($this->form->isValid()) { $this->coor->setMemberId($request->getParameter('member_id')); if ($this->form->getValue('coor_of_the_week') == null) { $this->coor->setCoorOfTheWeek(0); } else { $this->coor->setCoorOfTheWeek($this->form->getValue('coor_of_the_week')); } $this->coor->setCoorWeekDate($this->form->getValue('coor_week_date')); $this->coor->setInitialContact($this->form->getValue('initial_contact')); $is_new = $this->coor->isNew(); $this->coor->save(); if ($is_new) { sfContext::getInstance()->getConfiguration()->loadHelpers(array('Tag', 'Url')); $content = $this->getUser()->getName() . ' updated ' . link_to($this->member->getPerson()->getName(), 'coordinator/view?id=' . $this->coor->getId()) . ' as coordinator'; ActivityPeer::log($content); } $this->getUser()->setFlash('success', $success); $last = $request->getParameter('back'); $back_url = 'coordinator'; if (strstr($last, 'member/view')) { $member = MemberPeer::retrieveByPK($request->getParameter('member_id')); $member_id = $member->getId(); $back_url = '@member_view?id=' . $member_id; } elseif (strstr($last, 'coordinator/view')) { $back_url = '@coordinator_view?id=' . $this->coor->getId(); } $leg_id = $request->getParameter('leg_id'); if (isset($leg_id)) { $set_leg = MissionLegPeer::retrieveByPK($leg_id); if (isset($set_leg) && $set_leg instanceof MissionLeg) { $set_leg->setCoordinatorId($this->coor->getId()); $set_leg->save(); } else { $this->forward404Unless($set_leg); } $back_url = '@leg_edit?id=' . $request->getParameter('leg_id'); } return $this->redirect($back_url); } } else { # Set referer URL $this->referer = $request->getReferer() ? $request->getReferer() : '@companion'; } }
?> </div> </td> <td class="cell-4"> <div class="s-list"> <?php if ($leg->getPilotId()) { ?> <?php $pilot = PilotPeer::retrieveByPK($leg->getPilotId()); ?> <?php if (isset($pilot)) { ?> <?php $member = MemberPeer::retrieveByPK($pilot->getMemberId()); ?> <?php if (isset($member)) { ?> <?php $person = PersonPeer::retrieveByPK($member->getPersonId()); ?> <?php if (isset($person)) { ?> <?php echo $person->getTitle() . $person->getFirstName() . ' ' . $person->getLastName() . '<br/>'; ?> <?php if ($person->getEmail()) {
} ?> </dd> </dl> </td> <td class="cell-3"> <?php if ($req->getDate()) { echo $req->getDate('m/d/Y'); } ?> </td> <td class="cell-4"> <?php if ($req->getMemberId()) { $member = MemberPeer::retrieveByPK($req->getMemberId()); if (isset($member)) { $person = $member->getPerson(); if (isset($person)) { echo $person->getTitle() . ', ' . $person->getLastName() . ' ' . $person->getFirstName(); echo ' '; if ($member->getFlightStatus()) { echo $member->getFlightStatus(); } } } } ?> </td> <td class="cell-5"> <?php
public function executeSaveAvailability(sfWebRequest $request) { $member_id = $this->getUser()->getMemberId(); if ($member_id) { $member = MemberPeer::retrieveByPK($member_id); } else { $this->forward404(); } $availability = $member->getAvailability(); if (!$availability instanceof Availability) { $availability = new Availability(); $availability->setMemberId($member_id); } $availability->setNotAvailable($request->getParameter('available') != 1); if ($availability->getNotAvailable()) { if ($request->getParameter('option') == 'dates') { $availability->setFirstDate($request->getParameter('start_date')); $availability->setLastDate($request->getParameter('end_date')); } else { $availability->setFirstDate(null); $availability->setLastDate(null); } } $availability->setNoWeekday($request->getParameter('weekdays') != 1); $availability->setNoNight($request->getParameter('nights') != 1); $availability->setNoWeekend($request->getParameter('weekends') != 1); $availability->setLastMinute($request->getParameter('last_minute')); $availability->setAsMissionMssistant($request->getParameter('assistant')); $availability->setAvailabilityComment($request->getParameter('comment')); $availability->save(); return sfView::NONE; }
?> disabled="disabled" <?php } ?> name="backup_copilot_mail[]" /> </div> <div class="leglabel">Email: </div> <div class="leg_filed"> <?php echo $backup_copilot_id->getPerson()->getEmail(); ?> </div> </div> <?php } $backup_miss_assis_id = MemberPeer::retrieveByPK($miss_leg->getBackupMissAssisId()); if ($backup_miss_assis_id) { ?> <div class="legemail_box"> <div class="heading">Backup Co Pilot: <?php echo $backup_miss_assis_id->getPerson()->getFirstName(); ?> <?php echo $backup_miss_assis_id->getPerson()->getLastName(); ?> </div> <div class="chbox"> <input type="checkbox" <?php if ($backup_miss_assis_id->getPerson() && $backup_miss_assis_id->getPerson()->getEmail()) { ?> value="<?php
<br/> <?php $count = 0; ?> <div id="mas" style="display:none"> <?php if (isset($mission_assistants)) { ?> <?php $li = 0; ?> <?php foreach ($mission_assistants as $mission_assistant) { ?> <?php $member = MemberPeer::retrieveByPK($mission_assistant->getMemberId()); ?> <?php if ($member->getPersonId()) { ?> <?php $m_person = $member->getPerson(); ?> <?php $m_pass = PassengerPeer::getByPersonId($m_person->getId()); ?> <?php } ?> <?php if (isset($m_person)) {
public static function getEmailAddressesOfPersonsRelatedToMissionLeg(MissionLeg $mission_leg) { $receivers = array(); // Get Coordinator email address $coordinator = CoordinatorPeer::retrieveByPK($mission_leg->getCoordinatorId()); if ($coordinator && ($coordinator = $coordinator->getMember())) { $coordinator = $coordinator->getPerson()->getEmail(); if (!empty($coordinator)) { // $receivers['coordinator_'.$mission_leg->getId()] = $coordinator; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $coordinator)) { $receivers[] = $coordinator; } } } unset($coordinator); // Get Pilot email address $pilot = PilotPeer::retrieveByPK($mission_leg->getPilotId()); if ($pilot && ($pilot = $pilot->getMember())) { $pilot = $pilot->getPerson()->getEmail(); if (!empty($pilot)) { // $receivers['pilot_'.$mission_leg->getId()] = $pilot; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $pilot)) { $receivers[] = $pilot; } } } unset($pilot); // Get Backup Pilot email address $backup_pilot = PilotPeer::retrieveByPK($mission_leg->getBackupPilotId()); if ($backup_pilot && ($backup_pilot = $backup_pilot->getMember())) { $backup_pilot = $backup_pilot->getPerson()->getEmail(); if (!empty($backup_pilot)) { // $receivers['backup_pilot_'.$mission_leg->getId()] = $backup_pilot; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $backup_pilot)) { $receivers[] = $backup_pilot; } } } unset($backup_pilot); // Get Co-Pilot which is relate to Member $co_pilot = MemberPeer::retrieveByPK($mission_leg->getCopilotId()); if ($co_pilot) { $co_pilot = $co_pilot->getPerson()->getEmail(); if (!empty($co_pilot)) { // $receivers['co_pilot_'.$mission_leg->getId()] = $co_pilot; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $co_pilot)) { $receivers[] = $co_pilot; } } } unset($co_pilot); // Get Backup Co-pilot email address $backup_co_pilot = MemberPeer::retrieveByPK($mission_leg->getBackupCopilotId()); if ($backup_co_pilot) { $backup_co_pilot = $backup_co_pilot->getPerson()->getEmail(); if (!empty($backup_co_pilot)) { // $receivers['backup_co_pilot_'.$mission_leg->getId()] = $backup_co_pilot; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $backup_co_pilot)) { $receivers[] = $backup_co_pilot; } } } unset($backup_co_pilot); // Get mission assist email address $mission_assist = MemberPeer::retrieveByPK($mission_leg->getMissAssisId()); if ($mission_assist) { $mission_assist = $mission_assist->getPerson()->getEmail(); if (!empty($mission_assist)) { // $receivers['mission_assist_'.$mission_leg->getId()] = $mission_assist; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $mission_assist)) { $receivers[] = $mission_assist; } } } unset($mission_assist); // Get Backup mission assist email address $backup_mission_assist = MemberPeer::retrieveByPK($mission_leg->getBackupMissAssisId()); if ($backup_mission_assist) { $backup_mission_assist = $backup_mission_assist->getPerson()->getEmail(); if (!empty($backup_mission_assist)) { // $receivers['backup_mission_assist_'.$mission_leg->getId()] = $backup_mission_assist; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $backup_mission_assist)) { $receivers[] = $backup_mission_assist; } } } unset($backup_mission_assist); // Get Pilot Aircraft email address $pilot_aircraft = PilotAircraftPeer::retrieveByPK($mission_leg->getPilotAircraftId()); if ($pilot_aircraft && ($pilot_aircraft = $pilot_aircraft->getMember())) { $pilot_aircraft = $pilot_aircraft->getPerson()->getEmail(); if (!empty($pilot_aircraft)) { // $receivers['pilot_aircraft_'.$mission_leg->getId()] = $pilot_aircraft; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $pilot_aircraft)) { $receivers[] = $pilot_aircraft; } } } unset($pilot_aircraft); // Get Share AFA ORG email address $afa_org = AfaOrgPeer::retrieveByPK($mission_leg->getShareAfaOrgId()); if ($afa_org) { $afa_org = $afa_org->getRefContactEmail(); if (!empty($afa_org)) { // $receivers['afa_org_'.$mission_leg->getId()] = $afa_org; if (preg_match('/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})$/', $afa_org)) { $receivers[] = $afa_org; } } } unset($afa_org); return $receivers; }
/** * Add Pilot Aircraft * CODE: pilot_aircraft_create */ public function executeAircraft(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->getParameter('req')) { $this->req_id = $request->getParameter('req'); } if ($request->getParameter('camp')) { $this->camp_id = $request->getParameter('camp'); } if ($request->getParameter('leg')) { $this->leg_id = $request->getParameter('leg'); } if ($request->getParameter('account')) { $this->account = $request->getParameter('account'); } $this->member = MemberPeer::getByPersonId($this->getUser()->getId()); if ($request->getParameter('member')) { $this->member = MemberPeer::retrieveByPK($request->getParameter('member')); } if ($this->member) { $pilot = PilotPeer::getByMemberId($this->member->getId()); } else { $this->getUser()->setFlash('success', 'You are not a member yet!'); $this->redirect($request->getReferer()); } if ($request->getParameter('id')) { $this->aircraft = PilotAircraftPeer::retrieveByPK($request->getParameter('id')); $this->title = 'Edit Pilot Aircraft'; } else { $this->aircraft = new PilotAircraft(); $this->title = 'Add New Pilot Aircraft'; } $this->referer = $request->getReferer(); $this->form = new PilotAircraftForm($this->aircraft); if ($request->isMethod('post')) { $this->referer = $request->getReferer(); //echo $request->getParameter('a_id'); die; $taintedValues = $request->getParameter('pilot_aircraft'); $taintedValues['member_id'] = $request->getParameter('member_id'); $this->form->bind($taintedValues); //$back = ""; if ($this->form->isValid() && $request->getParameter('pilot_aircraft[aircraft_id]') != 0) { // $member = MemberPeer::retrieveByPK($request->getParameter('member_id')); //echo $this->form->getValue('aircraft_id'); die; $this->aircraft->setMemberId($request->getParameter('member_id')); $this->aircraft->setAircraftId($this->form->getValue('aircraft_id')); //$this->aircraft->setAircraftId(2); $this->aircraft->setNNumber($this->form->getValue('n_number')); if ($this->form->getValue('own') == null) { $this->aircraft->setOwn(0); } else { $this->aircraft->setOwn($this->form->getValue('own')); } if ($this->form->getValue('seats') == null) { $this->aircraft->setSeats(0); } else { $this->aircraft->setSeats($this->form->getValue('seats')); } if ($this->form->getValue('known_ice') == null) { $this->aircraft->setKnownIce(0); } else { $this->aircraft->setKnownIce($this->form->getValue('known_ice')); } $this->aircraft->save(); if ($request->getParameter('req_id')) { $back = '@pilot_request?id=' . $request->getParameter('req_id'); } if ($request->getParameter('camp_id')) { $back = '@request_group_mission?id=' . $request->getParameter('camp_id'); } if ($request->getParameter('referer')) { $back = $request->getParameter('referer'); } else { $back = $request->getReferer(); } $this->getUser()->setFlash('success', 'Aircraft has successfully created!'); if ($request->getParameter('leg_id') && $request->getParameter('member_id')) { $back = '@leg_edit?id=' . $request->getParameter('leg_id'); } else { $this->has_error = 1; } if ($request->getParameter('account')) { $back = 'account_pilot'; } $this->redirect($back); } } }
/** * Member update badge and notebook * CODE: member_update_bn */ public function executeUpdateBN(sfWebRequest $request) { if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Member'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } $member = MemberPeer::retrieveByPK($request->getParameter('id')); $this->forward404Unless($member); if ($request->getParameter('type', 0) == 'b') { $member->setBadgeMade(date()); $member->save(); } else { if ($request->getParameter('type', 0) == 'n') { $member->setNotebookSent(date()); $member->save(); } } return $this->redirect('@member_needsbn'); }
?> </dd> </dl> <div class="preferences" style="width:325px; float:left;"> <div class="frame"> <div class="bg"> <div class="holder"> <h4>Lead Coordinator</h4> <?php $lead_coordinator = $coor->getCoordinatorRelatedByLeadId(); ?> <?php if ($lead_coordinator) { ?> <?php $member = MemberPeer::retrieveByPK($lead_coordinator->getMemberId()); ?> <?php if (isset($member)) { $person = PersonPeer::retrieveByPK($member->getPersonId()); } ?> <?php if (isset($person)) { ?> <?php echo $person->getTitle() . ' ' . $person->getFirstName() . ' ' . $person->getLastName(); ?> <br/> <?php }
/** * 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 executeVisual(sfWebRequest $request) { #security if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Pilot', 'Member', 'Coordinator', 'Volunteer'), false)) { $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer()); $this->redirect('dashboard/index'); } $member_id = $this->getUser()->getMemberId(); $member = MemberPeer::retrieveByPK($member_id); $pilot = $member->getPilot(); if ($request->getParameter('first') == 1) { if ($pilot) { $first_airport = AirportPeer::retrieveByPK($pilot->getPrimaryAirportId()); $this->orgin_airport = $first_airport->getIdent(); } $this->types = MissionTypePeer::getOnlyNames(); $this->dest_airport = null; $this->miss_type = null; $this->miss_date1 = null; $this->miss_date2 = null; } else { $this->processFilterVisual($request); } $this->airport_list = AirportPeer::getMappable(); $this->legs = MissionLegPeer::getMappable($this->orgin_airport, $this->dest_airport, $this->miss_type, $this->miss_date1, $this->miss_date2); $this->date_widget = new widgetFormDate(array('format_date' => array('js' => 'mm/dd/yy', 'php' => 'm/d/Y')), array('class' => 'text')); }
<td>Initial contact</td> <td>Action</td> </tr> </thead> <tbody> <?php foreach ($coordinators as $coordinator) { ?> <?php $mem_id = $coordinator->getMemberId(); ?> <?php if ($mem_id) { ?> <?php $person_id = MemberPeer::retrieveByPK($mem_id)->getPersonId(); ?> <?php $person = PersonPeer::retrieveByPK($person_id); ?> <?php } ?> <tr> <td class="cell-1"> <?php if (isset($person)) { echo $person->getFirstName() . ' ' . $person->getLastName(); } ?> </td>
public function executeByMember() { $member_id = $this->getUser()->getAttribute('user_id', null, 'bo'); $member = MemberPeer::retrieveByPK($member_id); $this->forward404Unless($member); $this->getRequest()->setParameter('member_id', $member_id); $this->executeList(); }
public function executeFreeCard3() { $id = $this->getRequestParameter('id'); $this->valid_until = $this->getRequestParameter('valid_until'); $this->forward404Unless($id); $this->member = MemberPeer::retrieveByPK($id); $this->forward404Unless($this->member); }
<?php include_once dirname(__FILE__) . '/../../bootstrap/unit.php'; include_once dirname(__FILE__) . '/../../bootstrap/database.php'; $t = new lime_test(null, new lime_output_color()); //------------------------------------------------------------ $t->diag('Member::getProfiles()'); $member = MemberPeer::retrieveByPK(1); $t->isa_ok($member->getProfiles(), 'array', 'getProfiles() returns array'); //------------------------------------------------------------ $t->diag('Member::getProfile()'); $t->cmp_ok($member->getProfile('sex'), '===', 1, 'getProfile() returns a value'); $t->cmp_ok($member->getProfile('self_intro'), '===', 'よろしくお願いします。', 'getProfile() returns a value'); $t->cmp_ok($member->getProfile('example'), '===', NULL, 'getProfile() returns NULL if profileName is not registerd by member'); $t->cmp_ok($member->getProfile('unknown'), '===', NULL, 'getProfile() returns NULL if profileName does not exist');
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'); } } }
protected function processForm(sfWebRequest $request, sfForm $form) { $form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName())); if ($form->isValid()) { $application = $form->save(); $this->getUser()->setFlash('success', 'Application have successfully saved!'); $this->redirect('@default?module=application&action=view&id=' . $application->getId()); } $this->member = MemberPeer::retrieveByPK($form['member_id']->getValue()); $this->forward404Unless($this->member); $this->person = $this->member->getPerson(); }
public function executeOrderMember() { $this->returnModule = 'catalog'; $this->returnAction = 'showMemberNondigital?id=' . $this->getRequestParameter('catalog_id'); $member_id = $this->getUser()->getAttribute('user_id', null, 'bo'); $member = MemberPeer::retrieveByPK($member_id); $id = $this->getRequestParameter('id'); $item = ColItemPeer::retrieveByPk($id); $this->forward404Unless($item); $this->forward404Unless($member); $c = new Criteria(); $dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $c->add(CirRegulationPeer::DEPARTMENT_ID, $dept->getChildRecurs(), Criteria::IN); $c->add(CirRegulationPeer::MEMBER_TYPE_ID, $member->getType()); $c->add(CirRegulationPeer::CAT_CATEGORY_ID, $item->getCatalog()->getCatCategoryId()); $regulation = CirRegulationPeer::doSelectOne($c); if (!$regulation) { $this->forward($this->returnModule, $this->returnAction); } $c = new Criteria(); $c->add(CirHistoryPeer::MEMBER_ID, $member->getId()); $c->add(CirHistoryPeer::RETURN_DATE, null); $c->addJoin(CirHistoryPeer::COL_ITEM_ID, ColItemPeer::ID); $c->addJoin(ColItemPeer::CATALOG_ID, CatalogPeer::ID); $c->add(CatalogPeer::CAT_CATEGORY_ID, $regulation->getCatCategoryId()); $cir_hist_array = CirHistoryPeer::doSelect($c); $this->subtitle = ' ' . $item->toString() . ' - judul:' . $item->getCatalog()->getTitle() . ' (' . $item->getId() . ')'; $this->member = $member; $this->item = $item; $this->regulation = $regulation; $this->can_loan = true; $this->max_loan_limit = false; if ($regulation->getCanLoan() !== true) { $this->can_loan = false; } if ($regulation->getMaxLoan() <= count($cir_hist_array)) { $this->max_loan_limit = true; } }
<h4>Lead Coordinator</h4> <?php $is_lead = CoordinatorPeer::retrieveByPK($coor->getId()); ?> <?php if ($is_lead) { ?> <?php $leader = CoordinatorPeer::retrieveByPK($coor->getId()); ?> <?php if (isset($leader)) { } ?> <?php $member = MemberPeer::retrieveByPK($leader->getMemberId()); ?> <?php $p = $member->getPerson(); ?> <?php if (isset($member)) { $person = $member->getPerson(); ?> <?php if (isset($person)) { echo $person->getTitle() . ' ' . $person->getFirstName() . ' ' . $person->getLastName(); } ?> <?php }
<td>Name</td> <td>Primary Airport Details</td> <td>Pilot Details</td> <td>Action</td> </tr> </thead> <tbody> <?php foreach ($pilots as $pilot) { ?> <?php if ($pilot->getMemberId()) { ?> <?php $mem_id = $pilot->getMemberId(); $member = MemberPeer::retrieveByPK($mem_id); $person = PersonPeer::retrieveByPK($member->getPersonId()); ?> <?php } ?> <?php if ($pilot->getPrimaryAirportId()) { $airport = AirportPeer::retrieveByPK($pilot->getPrimaryAirportId()); } ?> <tr> <td class="cell-1"> <?php if (isset($person)) { ?>
/** * Sends new password to the requester * Can retrieve via Username or MemberId * @param sfWebRequest $request */ public function executeSendPassword(sfWebRequest $request) { if ($request->isMethod('post')) { $request->checkCSRFProtection(); $username = $request->getParameter('username'); $member_id = $request->getParameter('member_id'); if (strlen($username) > 0 || strlen($member_id) > 0) { $person = null; if ($member_id) { $member = MemberPeer::retrieveByPK($member_id); if ($member instanceof Member) { $person = $member->getPerson(); } } elseif ($username) { $person = PersonPeer::getByUsername($username); } if ($person instanceof Person) { # create token for password request $pr = new PasswordRequest(); $pr->setPerson($person); $pr->setEmail($person->getEmail()); $pr->save(); if ($person->getEmail()) { # send email via component $this->getComponent('mail', 'sendPassword', array('person' => $person, 'token' => $pr->getToken())); $this->getUser()->setFlash('success', 'Your password request has been successfully sent to your email!'); } else { $this->getUser()->setFlash('success', 'This user doesn\'t have proper email address!'); } # redirect to login $this->redirect('secure/login'); } $this->error_msg = 'Sorry! We haven\'t found any matching record!'; } else { $this->error_msg = 'Please type your username OR member id!'; } } $this->executeForgotPassword($request); $this->setTemplate('forgotPassword'); }
public function executeProcessComplete(sfWebRequest $request) { $this->memberID = $request->getParameter('id'); $member = MemberPeer::retrieveByPK($this->memberID); $this->member_id = $member->getExternalId(); }
protected function processStep3Check(sfWebRequest $request) { $default_airport = AirportPeer::getByIdent(sfConfig::get('app_default_airport_ident')); $this->forward404Unless($default_airport); $app = $this->application_temp; $person = $this->person; if (!$person instanceof Person) { $person = new Person(); } /* @var $app ApplicationTemp */ /* @var $person Person */ // Person $tmp_arr = $app->toArray(BasePeer::TYPE_FIELDNAME); $tmp_arr['evening_phone'] = $tmp_arr['eve_phone']; $tmp_arr['evening_comment'] = $tmp_arr['eve_comment']; unset($tmp_arr['id']); $person->fromArray($tmp_arr, BasePeer::TYPE_FIELDNAME); $person->save(); // Member $member = MemberPeer::retrieveByPK($app->getMemberId()); if (!$member instanceof Member) { $member = new Member(); } $member->setActive(1); $member->setCoPilot($app->getApplicantCopilot()); $member->setContact('By Email'); $member->setDateOfBirth($app->getDateOfBirth()); $member->setDriversLicenseState($app->getDriversLicenseState()); $member->setDriversLicenseNumber($app->getDriversLicenseNumber()); $member->setEmergencyContactName($app->getEmergencyContactName()); $member->setEmergencyContactPhone($app->getEmergencyContactPhone()); $member->setFlightStatus($app->getApplicantPilot() ? 'Verify Orientation' : 'Non-pilot'); //$member->setJoinDate(time()); $member->setLanguages($app->getLanguagesSpoken()); //Farazi //$member->setMasterMemberId($app->getMasterMemberId()); // Get Last renewal date $this->member = MemberPeer::retrieveByPK($app->getMemberId()); $lastRenewalDate = strtotime($this->member->getRenewalDate()); $member->setMemberClassId($app->getMemberClassId()); $member->setPersonId($person->getId()); $member->setRenewedDate(time()); ///Farazi Renewal Date From Memberclass if ($app->getMemberClassId()) { $memclass = MemberClassPeer::retrieveByPK($app->getMemberClassId()); $renewal_period = $memclass->getRenewalPeriod(); $renewalTime = strtotime('+' . $renewal_period . ' month', $lastRenewalDate); //echo $renewalTime; $member->setRenewalDate($renewalTime); //$member->setRenewalDate(strtotime('+'.$renewal_period.' month')); } // Farazi End //$member->setRenewalDate(strtotime('+1 year')); $member->setSpouseName($app->getSpouseFirstName() . ' ' . $app->getSpouseLastName()); $member->setWeight($app->getWeight()); $member->setWingId($app->getWingId()); $member->save(); // Pilot if ($app->getApplicantPilot()) { $pilot = $member->getPilot(); if (!$pilot instanceof Pilot) { $pilot = new Pilot(); } if ($pilot->isNew()) { // remove aircrafts foreach ($member->getPilotAircrafts() as $p_a) { PilotAircraftPeer::doDelete($p_a); } } $pilot->setMemberId($member->getId()); $airport = AirportPeer::getByIdent($app->getHomeBase()); if (!$airport instanceof Airport) { $airport = $default_airport; } $pilot->setPrimaryAirportId($airport->getId()); $pilot->setTotalHours($app->getTotalHours()); $pilot->setLicenseType('Private'); foreach (sfConfig::get('app_pilot_license_types') as $key => $val) { if (stripos($app->getRatings(), $key) !== false) { $pilot->setLicenseType($key); } } $pilot->setIfr(stripos($app->getRatings(), 'ifr') !== false ? 1 : 0); $pilot->setMultiEngine(stripos($app->getRatings(), 'multi') !== false ? 1 : 0); $pilot->setSeInstructor('No'); // @see ApplicationForm foreach (sfConfig::get('app_pilot_se_instructor') as $key => $val) { if (stripos($app->getRatings(), $key) !== false) { $pilot->setSeInstructor($key); } } $pilot->setMeInstructor($pilot->getSeInstructor()); $pilot->save(); // Availability $availability = $member->getAvailability(); if (!$availability instanceof Availability) { $availability = new Availability(); } $availability->setMemberId($member->getId()); $availability->setNotAvailable(0); $availability->setNoWeekday($app->getAvailabilityWeekdays() == 0); $availability->setNoNight($app->getAvailabilityWeeknights() == 0); $availability->setLastMinute($app->getAvailabilityLastMinute()); $availability->setAsMissionMssistant($app->getAvailabilityCopilot()); $availability->setNoWeekend($app->getAvailabilityWeekends() == 0); $availability->save(); //Farazi //Delete all aircrafts $pilot_aircrafts = PilotAircraftPeer::getByMemberId($member->getId()); foreach ($pilot_aircrafts as $pilot_aircraft) { $pilot_aircraft->delete(); } // Primary aircraft if ($app->getAircraftPrimaryId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftPrimaryId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftPrimaryNNumber()); $pilot_aircraft->setOwn($app->getAircraftPrimaryOwn()); $pilot_aircraft->setSeats($app->getAircraftPrimarySeats()); $pilot_aircraft->setKnownIce($app->getAircraftPrimaryIce()); $pilot_aircraft->save(); } // Secondary aircraft if ($app->getAircraftSecondaryId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftSecondaryId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftSecondaryNNumber()); $pilot_aircraft->setOwn($app->getAircraftSecondaryOwn()); $pilot_aircraft->setSeats($app->getAircraftSecondarySeats()); $pilot_aircraft->setKnownIce($app->getAircraftSecondaryIce()); $pilot_aircraft->save(); } // Third aircraft if ($app->getAircraftThirdId() && ($aircraft = AircraftPeer::retrieveByPK($app->getAircraftThirdId()))) { $pilot_aircraft = new PilotAircraft(); $pilot_aircraft->setMemberId($member->getId()); $pilot_aircraft->setAircraftId($aircraft->getId()); $pilot_aircraft->setNNumber($app->getAircraftThirdNNumber()); $pilot_aircraft->setOwn($app->getAircraftThirdOwn()); $pilot_aircraft->setSeats($app->getAircraftThirdSeats()); $pilot_aircraft->setKnownIce($app->getAircraftThirdIce()); $pilot_aircraft->save(); } } // Application_temp $app->setPersonId($person->getId()); $app->setMemberId($member->getId()); $app->setProcessedDate(time()); $app->save(); // Application $tmp_arr = $app->toArray(BasePeer::TYPE_FIELDNAME); $tmp_arr['date'] = $tmp_arr['application_date']; $tmp_arr['company'] = $tmp_arr['company_name']; foreach (sfConfig::get('app_pilot_license_types') as $key => $val) { if (stripos($tmp_arr['ratings'], $key) !== false) { $tmp_arr['license_type'] = $key; } } $tmp_arr['ifr'] = stripos($tmp_arr['ratings'], 'ifr') !== false ? 1 : 0; $tmp_arr['multi_engine'] = stripos($tmp_arr['ratings'], 'multi') !== false ? 1 : 0; $tmp_arr['se_instructor'] = 'No'; // @see ApplicationForm foreach (sfConfig::get('app_pilot_se_instructor') as $key => $val) { if (stripos($tmp_arr['ratings'], $key) !== false) { $tmp_arr['se_instructor'] = $key; } } $tmp_arr['me_instructor'] = $tmp_arr['se_instructor']; $tmp_arr['other_ratings'] = $tmp_arr['ratings']; $tmp_arr['fbo'] = $tmp_arr['fbo_name']; $tmp_arr['member_meetings'] = 0; $tmp_arr['executive_board'] = 0; $tmp_arr['dues_amount_paid'] = $tmp_arr['dues_amount_paid'] ? $tmp_arr['dues_amount_paid'] : 0; $tmp_arr['donation_amount_paid'] = $tmp_arr['donation_amount_paid'] ? $tmp_arr['donation_amount_paid'] : 0; unset($tmp_arr['id']); $application = new Application(); $application->fromArray($tmp_arr, BasePeer::TYPE_FIELDNAME); $application->save(); $this->getUser()->setFlash('success', 'Membership renewal completed successfully.'); //$this->redirect('renewal/processComplete?id='.$member->getId()); $this->redirect('renewal/processStep3?id=' . $this->application_temp->getId()); //$this->redirect('renewal/index?id='.$member->getId()); }
if ($mission_leg->getFboId()) { $fbo = FboPeer::retrieveByPK($mission_leg->getFboId()); if ($fbo->getAirportId()) { $fbo_airport = AirportPeer::retrieveByPK($fbo->getAirportId()); } } //Pilot if ($mission_leg->getPilotId()) { $pilot = PilotPeer::retrieveByPK($mission_leg->getPilotId()); $pilotMember = $pilot->getMember(); $pilot_person = PersonPeer::retrieveByPK($pilotMember->getPersonId()); $pilot_aircrafts = PilotAircraftPeer::getByMemberId($pilot->getMemberId()); } // Mission Assistant if ($mission_leg->getMissAssisId()) { $mission_assistant = MemberPeer::retrieveByPK($mission_leg->getMissAssisId()); $miss_assi_persopn = PersonPeer::retrieveByPK($mission_assistant->getPersonId()); } // Backup Pilot if ($mission_leg->getBackupPilotId()) { $backupPilot = PilotPeer::retrieveByPK($mission_leg->getBackupPilotId()); $backupPilotMember = $pilot->getMember(); $backupPilot_person = PersonPeer::retrieveByPK($backupPilotMember->getPersonId()); } /* echo "<pre>"; print_r($pilotMember); die(); //*/ //Companions information $companions = CompanionPeer::getByPassId($passenger->getId());
if ($mleg->getBackupPilotId()) { $backup_pilot_info = PilotPeer::retrieveByPK($mleg->getPilotId()); $backupPilot_person = $backup_pilot_info->getMember()->getPerson(); } if ($mleg->getCoordinatorId()) { $coordinator = CoordinatorPeer::retrieveByPK($mleg->getCoordinatorId()); if ($coordinator->getMemberId()) { $coordiPerson = $coordinator->getMember()->getPerson(); } } if ($mleg->getMissAssisId()) { $memberMiss = MemberPeer::retrieveByPK($mleg->getMissAssisId()); $miss_assi_persopn = $memberMiss->getPerson(); } if ($mleg->getMissAssisId()) { $memberMiss = MemberPeer::retrieveByPK($mleg->getMissAssisId()); $miss_assi_persopn = $memberMiss->getPerson(); } if ($mleg->getFboId()) { $fbo = FboPeer::retrieveByPK($mleg->getFboId()); if ($fbo->getAirportId()) { $fbo_airport = AirportPeer::retrieveByPK($fbo->getAirportId()); } } $is_air = $mleg->getTransportation() == 'air_mission'; if ($is_air) { $to_airport = $mleg->getAirportRelatedByToAirportId(); $from_airport = $mleg->getAirportRelatedByFromAirportId(); } //// FBO information if ($mleg->getFboId()) {
public function executePriorityList() { $this->pilot_request_count = PilotRequestPeer::countIn2Days(); $this->no_pilot_count = MissionPeer::countNoPilotIn2Days(); $this->cancelled_legs = MissionLegPeer::countCancelled(); $pilot = PilotPeer::retrieveByPK($this->getUser()->getPilotId()); if (!$pilot instanceof Pilot) { return sfView::NONE; } if ($pilot->getPrimaryAirportId()) { $this->near_mission = MissionLegPeer::getPilotNear($pilot->getPrimaryAirportId()); } else { $this->near_mission = array(); } $pilot_id = $this->getUser()->getPilotId(); $this->p_id = $pilot_id; if ($pilot_id) { $pilot = PilotPeer::retrieveByPK($pilot_id); $p_firstname = $pilot->getMember()->getPerson()->getFirstName(); $p_lastname = $pilot->getMember()->getPerson()->getLastName(); $c = new Criteria(); $c->add(MissionLegPeer::TRANSPORTATION, 'air_mission'); $c->add(MissionLegPeer::PILOT_ID, $pilot_id); $c->addJoin(MissionLegPeer::MISSION_ID, MissionPeer::ID, Criteria::RIGHT_JOIN); $c->add(MissionPeer::MISSION_DATE, date('Y-m-d H:i:s'), Criteria::LESS_THAN); $c->addJoin(MissionLegPeer::MISSION_REPORT_ID, MissionReportPeer::ID, Criteria::LEFT_JOIN); $c->add(MissionReportPeer::APPROVED, null, Criteria::ISNULL); $mission_legs = MissionLegPeer::doSelectJoinMission($c, null, Criteria::RIGHT_JOIN); $this->miss = count($mission_legs); $pind = MissionLegPeer::getPendingMissions($pilot_id); $this->pinding = $pind; //Update Farazi $member_id = $this->getUser()->getMemberId(); $member = MemberPeer::retrieveByPK($member_id); $date_now = strtotime("NOW"); $date_ren = strtotime($member->getRenewalDate()); $sub = $date_ren - $date_now; $preday = 0; if ($sub >= 86400) { $pday = $sub / 86400; $preday = explode('.', $pday); } else { $pday = $sub / 86400; $preday = explode('.', $pday); } $this->due_day = $preday[0]; } // Show mission request list for adin user if ($this->getUser()->hasCredential(array('Administrator'), false)) { // Get number of un processed mission requests $this->un_proc_miss_req = MissionRequestPeer::getNumberOfNonProcessedMissionRequest(); // Get number of un processed member applications $this->un_proc_mem_apps = ApplicationTempPeer::getNonProcessedMemberApplications(); // Get number of un processed pilot requests $this->un_proc_pilot_reqs = PilotRequestPeer::getPager()->getNbResults(); // Get uncoordinate mission legs $this->un_coor_mission_legs = MissionLegPeer::getPager(10, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, true)->getNbResults(); } // ziyed : count unprocessed contact request $c = new Criteria(); $c->add(ContactRequestPeer::PROCESSED, NULL, Criteria::ISNULL); $this->un_proce_contact_req = ContactRequestPeer::doCount($c); //end //Farazi : new contact requests $c = new Criteria(); $c->add(ContactRequestPeer::PROCESSED, NULL, Criteria::ISNULL); $this->new_contact_requeststs = ContactRequestPeer::doSelect($c); //end // ziyed : count unprocessed contact request $c = new Criteria(); $c->add(ContactRequestPeer::PROCESSED, NULL, Criteria::ISNULL); $c->add(ContactRequestPeer::REQUEST_DATE, 'ABS(DATEDIFF( NOW( \'Y-m-d\' ),' . ContactRequestPeer::REQUEST_DATE . ') ) > 1', Criteria::CUSTOM); $this->graterThanOneDay = ContactRequestPeer::doCount($c); //end //Farazi //Removed Pilots if ($this->getUser()->hasCredential(array('Pilot'), false)) { $pilot = PilotPeer::retrieveByPK($this->getUser()->getPilotId()); $this->removed_pilot = PilotRequestPeer::getRemovedPilot($pilot->getMemberId()); } //Revival Pilots if ($this->getUser()->hasCredential(array('Pilot'), false)) { $pilot = PilotPeer::retrieveByPK($this->getUser()->getPilotId()); $this->revival_pilot = PilotRequestPeer::getRevivalPilot($pilot->getMemberId()); } //New Pilot added to the mission leg if ($this->getUser()->hasCredential(array('Administrator', 'Staff', 'Coordinator'), false)) { $this->pilots_added = PilotRequestPeer::getPilotsAdded(); } //Mission report due $c = new Criteria(); $pilotId = $this->getUser()->getPilotId(); $c->add(MissionLegPeer::PILOT_ID, $pilotId, Criteria::EQUAL); $c->add(MissionLegPeer::MISSION_REPORT_ID, NULL, Criteria::ISNULL); $c->add(MissionLegPeer::CANCEL_MISSION_LEG, 1, Criteria::NOT_EQUAL); $c->addJoin(MissionPeer::ID, MissionLegPeer::MISSION_ID, Criteria::LEFT_JOIN); $c->add(MissionPeer::MISSION_DATE, 'NOW( \'Y-m-d\' )', Criteria::LESS_THAN); //echo $c->toString(); $this->mission_report_dues = MissionLegPeer::doCount($c); //End Farazi }
public function getMember($con = null) { include_once 'lib/model/om/BaseMemberPeer.php'; if ($this->aMember === null && $this->member_id !== null) { $this->aMember = MemberPeer::retrieveByPK($this->member_id, $con); } return $this->aMember; }
public function executeByMember() { $this->can_add = 0; $this->can_edit = 0; $this->can_remove = 0; $member_id = $this->getUser()->getAttribute('user_id', null, 'bo'); $member = MemberPeer::retrieveByPK($member_id); $this->forward404Unless($member); $c = new Criteria(); $c->add(VisitorPeer::MEMBER_ID, $member->getId()); $this->sort($c); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($this->hasRequestParameter('member_name') && $this->getRequestParameter('member_name') == '') { $filters['MEMBER_ID'] = null; } if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'visitor')); $this->getUser()->setAttribute('max_per_page', $rpp, 'visitor'); $pager = new sfPropelPager('Visitor', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'visitor')); $this->getUser()->setAttribute('page', $page, 'visitor'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions = array(array('name' => 'filter', 'color' => 'white')); #if ($acl->getAddPriv()) array_unshift($actions, array('name'=>'add','url'=>'visitor/create', 'color'=>'green')); $this->actions = $actions; $this->member = $member; }