public function executeSaveReturnSourceLocation(sfWebRequest $request)
{
$pass_id = $this->getRequestParameter('passengerid');
$new_airportname = $this->getRequestParameter('airportname');
$new_airport = AirportPeer::getBySpecificAirportName($new_airportname);
$camp_id = $this->getRequestParameter('camp_id');
$camp = CampPeer::retrieveByPK($camp_id);
$mission_id = $this->getRequestParameter('mission_id');
$conn = Propel::getConnection();
$sql = 'UPDATE mission_leg set to_airport_id = ' . $new_airport->getId() . ' WHERE mission_id = ' . $mission_id . ' AND from_airport_id = ' . $camp->getAirportId();
$statement = $conn->prepare($sql);
$statement->execute();
$sql = 'UPDATE camp_passenger set return_airport_id = ' . $new_airport->getId() . ' WHERE camp_id = ' . $camp_id . ' AND passenger_id = ' . $pass_id . ' AND mission_id = ' . $mission_id;
$statement = $conn->prepare($sql);
$statement->execute();
$this->airportname = $new_airportname;
$this->setTemplate('saveSourceLocation');
}
