/** * 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; }