Exemple #1
0
 /**
  * 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->aAirport !== null) {
             if ($this->aAirport->isModified() || $this->aAirport->isNew()) {
                 $affectedRows += $this->aAirport->save($con);
             }
             $this->setAirport($this->aAirport);
         }
         if ($this->isNew()) {
             $this->modifiedColumns[] = FboPeer::ID;
         }
         // If this object has been modified, then save it to the database.
         if ($this->isModified()) {
             if ($this->isNew()) {
                 $pk = FboPeer::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 += FboPeer::doUpdate($this, $con);
             }
             $this->resetModified();
             // [HL] After being saved an object is no longer 'modified'
         }
         if ($this->collCamps !== null) {
             foreach ($this->collCamps 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);
                 }
             }
         }
         $this->alreadyInSave = false;
     }
     return $affectedRows;
 }
Exemple #2
0
 /**
  * Add new airport from pop up by ajax
  * CODE:airport_create
  */
 public function executeUpdateAjax(sfWebRequest $request)
 {
     # security
     if (!$this->getUser()->hasCredential(array('Administrator'), false)) {
         $this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
         $this->redirect('dashboard/index');
     }
     //    $this->setLayout(false);
     $airport = new Airport();
     $this->airport = $airport;
     $this->form = new AirportForm($airport);
     $this->back = $request->getReferer();
     if ($request->isMethod('post')) {
         $this->referer = $request->getReferer();
         $this->form->bind($request->getParameter('airp'));
         if ($this->form->isValid() && $this->form->getValue('ident')) {
             if ($this->form->getValue('ident') && $request->getParameter('id')) {
                 $is_used = AirportPeer::getByIdent($this->form->getValue('ident'));
                 $airport->setIdent($is_used->getIdent());
             } elseif ($this->form->getValue('ident') && !$request->getParameter('id')) {
                 //new
                 $is_used = AirportPeer::getByIdent($this->form->getValue('ident'));
                 if (isset($is_used)) {
                     if ($is_used->getIdent() == $this->form->getValue('ident')) {
                         if ($request->getParameter('back') == null) {
                             $last = $request->getReferer();
                         } else {
                             $last = $request->getParameter('back');
                         }
                         if (strstr($last, 'camp/create')) {
                             $back_url = $last;
                         } elseif (strstr($last, 'fbo/create')) {
                             $back_url = $last;
                         } else {
                             $back_url = 'airport';
                         }
                         $this->getUser()->setFlash('success', 'This Airport Ident has already used. Please confirm else!');
                         $this->redirect($back_url);
                     }
                 } elseif ($this->form->getValue('ident') == 'null') {
                     $airport->setIdent(null);
                 } else {
                     $airport->setIdent($this->form->getValue('ident'));
                 }
             }
             $airport->setName($this->form->getValue('name'));
             $airport->setCity($this->form->getValue('city'));
             $airport->setState($this->form->getValue('state'));
             $airport->setLatitude($this->form->getValue('latitude'));
             $airport->setLongitude($this->form->getValue('longitude'));
             $airport->setRunwayLength($this->form->getValue('runway_length'));
             if ($this->form->getValue('wing_id') == 0) {
                 $airport->setWingId(null);
             } else {
                 $airport->setWingId($this->form->getValue('wing_id'));
             }
             $airport->setGmtOffset($this->form->getValue('gmt_offset'));
             $airport->setDstOffset($this->form->getValue('dst_offset'));
             $airport->setZipcode($this->form->getValue('zipcode'));
             if ($this->form->getValue('closed') == null) {
                 $airport->setClosed(0);
             } else {
                 $airport->setClosed($this->form->getValue('closed'));
             }
             if ($airport->isNew()) {
                 $content = $this->getUser()->getName() . ' added new Airport: ' . $airport->getName() . ' (' . $airport->getIdent() . ')';
                 ActivityPeer::log($content);
             }
             $airport->save();
             $str = '<script type="text/javascript">' . 'var a = $id;' . "window.\$('#back_airport_id').val('');" . "window.\$('#back_airport_id').val(a);" . "window.\$('#back1').val(\$('#camp_agency_id').val());" . "window.location.reload();" . '</script>';
             $this->getUser()->setFlash('success', 'New Airport created successfully!');
             $this->formValid = true;
             $this->airportName = $airport->getName();
             //return $this->renderText($str);
         } else {
             $str = '<script type="text/javascript">' . "//window.setTimeout(\\'window.location.reload()\\', 1500);" . 'window.location.reload();' . '</script>';
             $this->getUser()->setFlash('success', 'Can not create new Airport without datas!');
             $this->formNotValid = true;
             //return $this->renderText($str);
         }
     } else {
         # Set referer URL
         $this->referer = $request->getReferer() ? $request->getReferer() : '@airport';
     }
     $this->airport = $airport;
 }
Exemple #3
0
 /**
  * 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;
 }