/**
* 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->aAgency !== null) {
if ($this->aAgency->isModified() || $this->aAgency->isNew()) {
$affectedRows += $this->aAgency->save($con);
}
$this->setAgency($this->aAgency);
}
if ($this->aAirport !== null) {
if ($this->aAirport->isModified() || $this->aAirport->isNew()) {
$affectedRows += $this->aAirport->save($con);
}
$this->setAirport($this->aAirport);
}
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[] = CampPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = CampPeer::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 += CampPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
if ($this->collCampPassengers !== null) {
foreach ($this->collCampPassengers as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collMissions !== null) {
foreach ($this->collMissions 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;
}
/**
* 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;
}
protected function processForm(sfWebRequest $request, AgencyForm $form)
{
$form->bind($request->getParameter('agency'));
if ($form->isValid()) {
$agency = new Agency();
$agency->setName($form->getValue('name'));
$agency->setAddress1($form->getValue('address1'));
$agency->setAddress2($form->getValue('address2'));
$agency->setCity($form->getValue('city'));
$agency->setCounty($form->getValue('county'));
$agency->setState($form->getValue('state'));
$agency->setCountry($form->getValue('country'));
$agency->setZipcode($form->getValue('zipcode'));
$agency->setPhone($form->getValue('phone'));
$agency->setComment($form->getValue('comment'));
$agency->setFaxPhone($form->getValue('fax_phone'));
$agency->setFaxComment($form->getValue('fax_comment'));
$agency->setEmail($form->getValue('email'));
if ($agency->isNew()) {
$content = $this->getUser()->getName() . ' added new Agency: ' . $agency->getName();
ActivityPeer::log($content);
}
$agency->save();
//exit;
$this->new_requester_agency_id = $agency->getId();
$this->new_requester_agency_name = $form->getValue('name');
}
}
/**
* Get agency by ajax in popup
* CODE: agency_create
*/
public function executeUpdateAjax(sfWebRequest $request)
{
#security
if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Coordinator', 'Volunteer'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
$this->setLayout(false);
$agency = new Agency();
$this->form = new AgencyForm($agency);
$this->back = $request->getReferer();
$this->backurl = "";
$this->is_camp = 0;
$this->person_ids = 1;
if ($request->getParameter('camp') == 1) {
$this->backurl = '/camp/create';
$this->is_camp = 1;
} elseif ($request->getParameter('req') == 1) {
$this->backurl = '/requester/create?person_id=' . $request->getParameter('person_id');
$this->person_ids = $request->getParameter('person_id');
}
if ($request->isMethod('post')) {
$this->referer = $request->getReferer();
$this->form->bind($request->getParameter('agency'));
if ($this->form->isValid()) {
$agency->setName($this->form->getValue('name'));
$agency->setAddress1($this->form->getValue('address1'));
$agency->setAddress2($this->form->getValue('address2'));
$agency->setCity($this->form->getValue('city'));
$agency->setCounty($this->form->getValue('county'));
$agency->setState($this->form->getValue('state'));
$agency->setCountry($this->form->getValue('country'));
$agency->setZipcode($this->form->getValue('zipcode'));
$agency->setPhone($this->form->getValue('phone'));
$agency->setComment($this->form->getValue('comment'));
$agency->setFaxPhone($this->form->getValue('fax_phone'));
$agency->setFaxComment($this->form->getValue('fax_comment'));
$agency->setEmail($this->form->getValue('email'));
if ($agency->isNew()) {
$content = $this->getUser()->getName() . ' added new Agency: ' . $agency->getName();
ActivityPeer::log($content);
}
$agency->save();
$this->getUser()->setFlash('new_agency', $this->form->getValue('name'));
$b_u = $request->getParameter('backurl');
// if($request->getReferer()){
// $back = $request->getReferer();
// if(isset($back)){
// if(strstr($back,'requester/edit')){
// $req =1;
// }elseif(strstr($back,'camp/create')){
// $camp =1;
// }
// }
// }
$id = $agency->getId();
$str = <<<XYZ
<script type="text/javascript">
var a = {$id};
if(window.jQuery('#back_agency_id')){
window.jQuery('#back_agency_id').val('');
}
if(window.jQuery('#back_agency_id')){
window.jQuery('#back_agency_id').val(a);
}
if(window.jQuery('#pre_agency_id')){
window.jQuery('#pre_agency_id').val('');
}
if(window.jQuery('#pre_agency_id')){
window.jQuery('#pre_agency_id').val(a);
}
location.href='{$b_u}?agency_id={$id}';
</script>
XYZ;
$this->getUser()->setFlash('success', 'New Agency has added!');
return $this->renderText($str);
}
} else {
# Set referer URL
$this->referer = $request->getReferer() ? $request->getReferer() : '@agency';
}
$this->agency = $agency;
}
