public function executeSave(sfWebRequest $request)
{
if ($request->isMethod('post')) {
$mission_leg = MissionLegPeer::retrieveByPK($request->getParameter('id'));
if (isset($mission_leg) && $mission_leg instanceof MissionLeg) {
$leg_number = $request->getParameter('leg_number');
$waiver_rec = $request->getParameter('waiver_rec');
$coor_web_off = $request->getParameter('coor_web_off');
$cancel_reason = $request->getParameter('cancel_reason');
$cancel_comment = $request->getParameter('cancel_comment');
$co_pilot_wanted = $request->getParameter('cop_wanted');
$private_coor = $request->getParameter('private_coor_note');
$public_coor = $request->getParameter('public_coor_note');
if ($request->getParameter('leg_id')) {
$leg_id = $request->getParameter('leg_id');
$is_leg = MissionLegPeer::getByIdNumber($mission_leg->getMissionId(), $leg_number);
if (isset($is_leg) && $is_leg instanceof MissionLeg) {
if ($mission_leg->getLegNumber() != $leg_number) {
$this->getUser()->setFlash('success', 'Leg number ' . $leg_number . ' has already used in Leg #' . $request->getParameter('leg_id') . '!');
$this->redirect('@leg_edit?id=' . $leg_id);
}
}
} else {
$this->redirect($request->getReferer());
}
$mission_leg->setLegNumber($leg_number);
$mission_leg->setWaiverReceived($waiver_rec);
if ($coor_web_off == 'on') {
$mission_leg->setWebCoordinated(1);
} else {
$mission_leg->setWebCoordinated(0);
}
$mission_leg->setCancelled($cancel_reason);
$mission_leg->setCancelComment($cancel_comment);
if ($co_pilot_wanted == 'on') {
$mission_leg->setCopilotWanted(1);
} else {
$mission_leg->setCopilotWanted(0);
}
if ($request->getParameter('coordinator_name') && $request->getParameter('coordinator_id')) {
$coordinator = new Coordinator();
$coordinator->setMemberId($request->getParameter('coordinator_id'));
if ($coordinator->save()) {
/*$coordinatorPerson=$coordinator->getMember()->getPerson();
$eoordiEmail=$coordinatorPerson->getEmail();
$legNo=$mission_leg->getLegNumber();
$missionExter=$mission_leg->getMission()->getExternalId();
$legId=$missionExter."-".$legNo;
//echo $legId;
if($eoordiEmail){
$this->getComponent('mail', 'missionCoordinatedAdded', array('email' => $eoordiEmail, 'leg_id' => $legId, 'name' => $coordinatorPerson->getFirstName().' '.$coordinatorPerson->getLastName()));
}*/
}
$codinatorId = $coordinator->getId();
$mission_leg->setCoordinatorId($codinatorId);
}
// die();
// New add 28-02-2011
$pilot_id = $request->getParameter('pilot_id');
$copilot_id = $request->getParameter('copilot_id');
$backup_pilot_id = $request->getParameter('backup_pilot_id');
$backup_copilot_id = $request->getParameter('backup_copilot_id');
$miss_assis_id = $request->getParameter('miss_assis_id');
$backup_miss_assis_id = $request->getParameter('backup_miss_assis_id');
$pilot_aircraft_id = $request->getParameter('pilot_aircraft_id');
/// Manual add pilot
if ($request->getParameter('pilot_name') && $pilot_id) {
$pilotInfo = PilotPeer::retrieveByPK($pilot_id);
$memberId = $pilotInfo->getMemberId();
$pilotRequester = PilotRequestPeer::getPilotByRequestersLegIdMemberId($request->getParameter('id'), $memberId);
if (!$pilotRequester) {
// Manual Add pilot request
$pilot_request = new PilotRequest();
$pilot_request->setMemberId($memberId);
$pilot_request->setLegId($request->getParameter('id'));
$pilot_request->setMissionAssistantWanted(0);
$pilot_request->setIfrBackupWanted(0);
$pilot_request->setAccepted(1);
$pilot_request->setProcessed(1);
$pilot_request->setPilotStatus(0);
$pilot_request->setOnHold(0);
$pilot_request->setComment('Manual Assinged');
$pilot_request->setCreatedAt(date('Y-m-d H:i:s'));
$pilotReqSave = $pilot_request->save();
} else {
//if pilot exist pilot request will be update
$pilotRequester->setAccepted(1);
$pilotRequester->setProcessed(1);
$pilotRequester->setPilotStatus(0);
$pilotRequester->setCreatedAt(date('Y-m-d H:i:s'));
$pilotReqSave = $pilotRequester->save();
}
// Without Accepted pilot all pilot requesters will be decline
$notAcceptedPilots = PilotRequestPeer::getByRequestersLegIdMemberId($request->getParameter('id'), $memberId);
if ($notAcceptedPilots) {
foreach ($notAcceptedPilots as $pilotrequester) {
$pilotrequester->setAccepted(0);
$pilotrequester->setProcessed(0);
$pilotrequester->setPilotStatus(3);
// 2 Pilot Delete 1 Pilot Reopen 3 Pilot Decline
$pilotrequester->save();
// Member information
$member = MemberPeer::retrieveByPK($pilotrequester->getMemberId());
// Person information
$person = PersonPeer::retrieveByPK($member->getPersonId());
$frist_name = $person->getFirstName();
$last_name = $person->getLastName();
$name = $frist_name . ' ' . $last_name;
$email = $person->getEmail();
// Leg information
$legNo = $mission_leg->getLegNumber();
$missionExter = $mission_leg->getMission()->getExternalId();
$missionDate = $mission_leg->getMission()->getMissionDate();
//Send email who will not accepted
if ($email) {
$this->getComponent('mail', 'pilotRequestNotAccepted', array('email' => $email, 'name' => $name, 'externalID' => $missionExter, 'leg_number' => $legNo, 'missionDate' => $missionDate));
}
}
}
// added pilot and send email to mission coordinator
if ($pilotReqSave) {
$mission_leg->setPilotId($request->getParameter('pilot_id'));
$member = MemberPeer::retrieveByPK($memberId);
$pilotPerson = PersonPeer::retrieveByPK($member->getPersonId());
$pilot_name = $pilotPerson->getTitle() . " " . $pilotPerson->getFirstName() . " " . $pilotPerson->getLastName();
$coordinator = CoordinatorPeer::retrieveByPK($mission_leg->getCoordinatorId());
if ($coordinator && $coordinator->getMemberId()) {
$coordinatorPerson = $coordinator->getMember()->getPerson();
$coordinatorEmail = $coordinatorPerson->getEmail();
$legNo = $mission_leg->getLegNumber();
$missionExter = $mission_leg->getMission()->getExternalId();
$legId = $missionExter . "-" . $legNo;
//echo $legId;
if ($coordinatorEmail) {
$this->getComponent('mail', 'missionPilotAdded', array('email' => $coordinatorEmail, 'leg_id' => $legId, 'pilot_name' => $pilot_name, 'name' => $coordinatorPerson->getTitle() . ' ' . $coordinatorPerson->getFirstName() . ' ' . $coordinatorPerson->getLastName()));
}
}
}
$mission_leg->setPilotId($request->getParameter('pilot_id'));
}
if ($copilot_id) {
$mission_leg->setCopilotId($request->getParameter('copilot_id'));
}
if ($backup_pilot_id) {
$mission_leg->setBackupPilotId($request->getParameter('backup_pilot_id'));
}
if ($backup_copilot_id) {
$mission_leg->setBackupCopilotId($request->getParameter('backup_copilot_id'));
}
if ($miss_assis_id) {
$mission_leg->setMissAssisId($request->getParameter('miss_assis_id'));
}
if ($backup_miss_assis_id) {
$mission_leg->setBackupMissAssisId($request->getParameter('backup_miss_assis_id'));
}
if ($pilot_aircraft_id) {
$mission_leg->setPilotAircraftId($request->getParameter('pilot_aircraft_id'));
}
// End
$mission_leg->setPrivateCNote($private_coor);
$mission_leg->setPublicCNote($public_coor);
$mission_leg->setCancelMissionLeg(1);
$mission_leg->save();
$this->getUser()->setFlash('success', 'Mission Leg #' . $request->getParameter('leg_id') . ' has edited !');
if ($request->getParameter('leg_id')) {
$back = '@leg_view?id=' . $request->getParameter('leg_id');
} else {
$back = $request->getReferer();
}
$this->redirect($back);
}
}
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aMissionRequest !== null) {
if ($this->aMissionRequest->isModified() || $this->aMissionRequest->isNew()) {
$affectedRows += $this->aMissionRequest->save($con);
}
$this->setMissionRequest($this->aMissionRequest);
}
if ($this->aItinerary !== null) {
if ($this->aItinerary->isModified() || $this->aItinerary->isNew()) {
$affectedRows += $this->aItinerary->save($con);
}
$this->setItinerary($this->aItinerary);
}
if ($this->aMissionType !== null) {
if ($this->aMissionType->isModified() || $this->aMissionType->isNew()) {
$affectedRows += $this->aMissionType->save($con);
}
$this->setMissionType($this->aMissionType);
}
if ($this->aPassenger !== null) {
if ($this->aPassenger->isModified() || $this->aPassenger->isNew()) {
$affectedRows += $this->aPassenger->save($con);
}
$this->setPassenger($this->aPassenger);
}
if ($this->aRequesterRelatedByRequesterId !== null) {
if ($this->aRequesterRelatedByRequesterId->isModified() || $this->aRequesterRelatedByRequesterId->isNew()) {
$affectedRows += $this->aRequesterRelatedByRequesterId->save($con);
}
$this->setRequesterRelatedByRequesterId($this->aRequesterRelatedByRequesterId);
}
if ($this->aAgencyRelatedByAgencyId !== null) {
if ($this->aAgencyRelatedByAgencyId->isModified() || $this->aAgencyRelatedByAgencyId->isNew()) {
$affectedRows += $this->aAgencyRelatedByAgencyId->save($con);
}
$this->setAgencyRelatedByAgencyId($this->aAgencyRelatedByAgencyId);
}
if ($this->aRequesterRelatedByOtherRequesterId !== null) {
if ($this->aRequesterRelatedByOtherRequesterId->isModified() || $this->aRequesterRelatedByOtherRequesterId->isNew()) {
$affectedRows += $this->aRequesterRelatedByOtherRequesterId->save($con);
}
$this->setRequesterRelatedByOtherRequesterId($this->aRequesterRelatedByOtherRequesterId);
}
if ($this->aAgencyRelatedByOtherAgencyId !== null) {
if ($this->aAgencyRelatedByOtherAgencyId->isModified() || $this->aAgencyRelatedByOtherAgencyId->isNew()) {
$affectedRows += $this->aAgencyRelatedByOtherAgencyId->save($con);
}
$this->setAgencyRelatedByOtherAgencyId($this->aAgencyRelatedByOtherAgencyId);
}
if ($this->aCamp !== null) {
if ($this->aCamp->isModified() || $this->aCamp->isNew()) {
$affectedRows += $this->aCamp->save($con);
}
$this->setCamp($this->aCamp);
}
if ($this->aCoordinator !== null) {
if ($this->aCoordinator->isModified() || $this->aCoordinator->isNew()) {
$affectedRows += $this->aCoordinator->save($con);
}
$this->setCoordinator($this->aCoordinator);
}
if ($this->isNew()) {
$this->modifiedColumns[] = MissionPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = MissionPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += MissionPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
if ($this->collMissionCompanions !== null) {
foreach ($this->collMissionCompanions as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collMissionLegs !== null) {
foreach ($this->collMissionLegs as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collMissionPhotos !== null) {
foreach ($this->collMissionPhotos as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aMission !== null) {
if ($this->aMission->isModified() || $this->aMission->isNew()) {
$affectedRows += $this->aMission->save($con);
}
$this->setMission($this->aMission);
}
if ($this->aAirportRelatedByFromAirportId !== null) {
if ($this->aAirportRelatedByFromAirportId->isModified() || $this->aAirportRelatedByFromAirportId->isNew()) {
$affectedRows += $this->aAirportRelatedByFromAirportId->save($con);
}
$this->setAirportRelatedByFromAirportId($this->aAirportRelatedByFromAirportId);
}
if ($this->aAirportRelatedByToAirportId !== null) {
if ($this->aAirportRelatedByToAirportId->isModified() || $this->aAirportRelatedByToAirportId->isNew()) {
$affectedRows += $this->aAirportRelatedByToAirportId->save($con);
}
$this->setAirportRelatedByToAirportId($this->aAirportRelatedByToAirportId);
}
if ($this->aCoordinator !== null) {
if ($this->aCoordinator->isModified() || $this->aCoordinator->isNew()) {
$affectedRows += $this->aCoordinator->save($con);
}
$this->setCoordinator($this->aCoordinator);
}
if ($this->aPilotRelatedByPilotId !== null) {
if ($this->aPilotRelatedByPilotId->isModified() || $this->aPilotRelatedByPilotId->isNew()) {
$affectedRows += $this->aPilotRelatedByPilotId->save($con);
}
$this->setPilotRelatedByPilotId($this->aPilotRelatedByPilotId);
}
if ($this->aMemberRelatedByCopilotId !== null) {
if ($this->aMemberRelatedByCopilotId->isModified() || $this->aMemberRelatedByCopilotId->isNew()) {
$affectedRows += $this->aMemberRelatedByCopilotId->save($con);
}
$this->setMemberRelatedByCopilotId($this->aMemberRelatedByCopilotId);
}
if ($this->aPilotRelatedByBackupPilotId !== null) {
if ($this->aPilotRelatedByBackupPilotId->isModified() || $this->aPilotRelatedByBackupPilotId->isNew()) {
$affectedRows += $this->aPilotRelatedByBackupPilotId->save($con);
}
$this->setPilotRelatedByBackupPilotId($this->aPilotRelatedByBackupPilotId);
}
if ($this->aMemberRelatedByBackupCopilotId !== null) {
if ($this->aMemberRelatedByBackupCopilotId->isModified() || $this->aMemberRelatedByBackupCopilotId->isNew()) {
$affectedRows += $this->aMemberRelatedByBackupCopilotId->save($con);
}
$this->setMemberRelatedByBackupCopilotId($this->aMemberRelatedByBackupCopilotId);
}
if ($this->aMissionReport !== null) {
if ($this->aMissionReport->isModified() || $this->aMissionReport->isNew()) {
$affectedRows += $this->aMissionReport->save($con);
}
$this->setMissionReport($this->aMissionReport);
}
if ($this->aPilotAircraft !== null) {
if ($this->aPilotAircraft->isModified() || $this->aPilotAircraft->isNew()) {
$affectedRows += $this->aPilotAircraft->save($con);
}
$this->setPilotAircraft($this->aPilotAircraft);
}
if ($this->aFbo !== null) {
if ($this->aFbo->isModified() || $this->aFbo->isNew()) {
$affectedRows += $this->aFbo->save($con);
}
$this->setFbo($this->aFbo);
}
if ($this->isNew()) {
$this->modifiedColumns[] = MissionLegPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = MissionLegPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += MissionLegPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
if ($this->singleAfaLeg !== null) {
if (!$this->singleAfaLeg->isDeleted()) {
$affectedRows += $this->singleAfaLeg->save($con);
}
}
if ($this->collMissionPhotos !== null) {
foreach ($this->collMissionPhotos as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collPilotRequests !== null) {
foreach ($this->collPilotRequests as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
