PHP Route::save方法代码示例

 /**
  * Create the application document registry
  *
  * @param array $aData
  * @return string
  *
  */
 public function create($aData)
 {
     $oConnection = Propel::getConnection(RoutePeer::DATABASE_NAME);
     try {
         $sRouteUID = G::generateUniqueID();
         $aData['ROU_UID'] = $sRouteUID;
         $oRoute = new Route();
         // validating default values
         $aData['ROU_TO_LAST_USER'] = $this->validateValue(isset($aData['ROU_TO_LAST_USER']) ? $aData['ROU_TO_LAST_USER'] : '', array('TRUE', 'FALSE'), 'FALSE');
         $aData['ROU_OPTIONAL'] = $this->validateValue(isset($aData['ROU_OPTIONAL']) ? $aData['ROU_OPTIONAL'] : '', array('TRUE', 'FALSE'), 'FALSE');
         $aData['ROU_SEND_EMAIL'] = $this->validateValue(isset($aData['ROU_SEND_EMAIL']) ? $aData['ROU_SEND_EMAIL'] : '', array('TRUE', 'FALSE'), 'TRUE');
         $oRoute->fromArray($aData, BasePeer::TYPE_FIELDNAME);
         if ($oRoute->validate()) {
             $oConnection->begin();
             $iResult = $oRoute->save();
             $oConnection->commit();
             return $sRouteUID;
         } else {
             $sMessage = '';
             $aValidationFailures = $oRoute->getValidationFailures();
             foreach ($aValidationFailures as $oValidationFailure) {
                 $sMessage .= $oValidationFailure->getMessage() . '<br />';
             }
             throw new Exception('The registry cannot be created!<br />' . $sMessage);
         }
     } catch (Exception $oError) {
         $oConnection->rollback();
         throw $oError;
     }
 }

 /**
  * Save this walk to the database
  * Also saves any route attached to the walk
  */
 public function save()
 {
     $db = JFactory::getDbo();
     // Commit everything as one transaction
     $db->transactionStart();
     $query = $db->getQuery(true);
     // First, do the basic fields
     foreach ($this->dbmappings as $var => $dbField) {
         $query->set($dbField . " = '" . $db->escape($this->{$var}) . "'");
     }
     $query->set("suggestedby = " . $this->suggestedBy->id);
     // Update or insert?
     if (!isset($this->id)) {
         $query->insert("walks");
     } else {
         $query->where("ID = " . (int) $this->id);
         $query->update("walks");
     }
     $db->setQuery($query);
     $db->query();
     if (!isset($this->id)) {
         // Get the ID from the database
         $this->id = $db->insertid();
     }
     // TODO: Handle failure
     // Commit the transaction - the route is not a critical part of the walk
     $db->transactionCommit();
     // Now save the route
     if (isset($this->route)) {
         $this->route->save();
     }
 }

 /**
  * Store a newly created resource in storage.
  *
  * @return Response
  */
 public function store(Request $request)
 {
     $route = new Route();
     $route->name = $request['name'];
     $route->distance = $request['distance'];
     $route->duration = $request['duration'];
     $route->price = $request['price'];
     $route->save();
 }

 public function insert_routes(Request $request)
 {
     $route = new Route();
     $route->route_name = $request->input('name');
     $route->start = $request->input('start');
     $route->end = $request->input('end');
     $route->rep_id = $request->input('rep');
     $route->remarks = $request->input('remarks');
     $route->save();
 }

 public function seeder()
 {
     //adding new route
     $route = new Route();
     $route->name = '/login';
     $route->save();
     //adding a method to route
     $method = $route->methods()->create(['tags' => 'customer', 'method' => 'POST', 'description' => 'Post operation on customer route']);
     //adding parameters to method
     $method->parameters()->create(['name' => 'mobile', 'in' => 'formData', 'description' => 'mobile number of customer', 'required' => true, 'type' => 'string']);
     $method->parameters()->create(['name' => 'password', 'in' => 'formData', 'description' => 'password of customer', 'required' => true, 'type' => 'string']);
     return true;
 }

 public function addapi()
 {
     if (isset($_POST) == true && empty($_POST) == false) {
         $api = $_POST['api'];
         $methodName = $_POST['method'];
         $tags = $_POST['tags'] ? $_POST['tags'] : 'default';
         $description = $_POST['description'] ? $_POST['description'] : ' ';
         $BX_NAME = $_POST['BX_NAME'];
         $BX_TYPE = $_POST['BX_TYPE'];
         $BX_CHK = $_POST['BX_CHK'];
         $BX_DESCRIPTION = $_POST['BX_DESCRIPTION'];
         $BX_IN = $_POST['BX_IN'];
         $param_count = count($BX_NAME);
         //check if route already exists
         $route = Route::where('name', '=', $api)->first();
         if (!$route) {
             //adding new route
             $route = new Route();
             $route->name = $api;
             $route->save();
         }
         $method = $route->methods()->where('method', '=', $methodName)->firstOrCreate(['tags' => $tags, 'method' => $methodName, 'description' => $description]);
         //parameters
         //if blank field submitted in parameter don't add it
         for ($i = 0; $i < $param_count; $i++) {
             if ($BX_NAME[$i] != '') {
                 $BX_CHK[$i] = 'on' ? true : false;
                 $BX_DESCRIPTION[$i] = $BX_DESCRIPTION[$i] ? $BX_DESCRIPTION[$i] : ' ';
                 $method->parameters()->create(['name' => $BX_NAME[$i], 'in' => $BX_IN[$i], 'description' => $BX_DESCRIPTION[$i], 'required' => $BX_CHK[$i], 'type' => $BX_TYPE[$i]]);
             }
             //END if
         }
         //for
         header('location: ' . URL . '/show');
     } else {
         header('location: ' . URL . '/show');
     }
     //if-else post
 }

 public function actionAddInfo()
 {
     $source = '';
     $thumb = '';
     if (isset($_POST['source'])) {
         $source = $_POST['source'];
     }
     if (isset($_POST['thumb'])) {
         $thumb = $_POST['thumb'];
     }
     $route = new Route();
     $route->name = $_POST['title'];
     $route->area = $_POST['area'];
     $route->port = $_POST['port'];
     $route->style = $_POST['style'];
     $route->company = $_POST['company'];
     $route->source = $source;
     $route->thumb = $thumb;
     $route->description = $_POST['description'];
     $route->start_time = $_POST['date'];
     $route->continent = $_POST['continent'];
     $route->save();
     echo 1;
 }

 /**
  * Sets the Route's path field
  * @param int $path [optional]
  * @return bool
  */
 public function setPath($path, $load = true)
 {
     # Prepare
     $save = false;
     # Prepare
     $path = trim($path, '/');
     if (empty($path)) {
         return false;
     }
     # Update
     if ($this->Route_id) {
         $Route = $this->Route;
     } else {
         $Route = new Route();
         $Route->type = 'content';
         $Route->data = array('id' => $this->id);
         $this->Route = $Route;
         $save = true;
     }
     # Apply
     if ($Route->path != $path) {
         $Route->path = $path;
         $Route->save();
         # Update Children
         $Children = $this->Children;
         foreach ($Children as $Child) {
             $Child->setPath($path . '/' . $Child->code);
         }
     }
     # Done
     return $save;
 }