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