public function store() { $rules = ['name' => 'required', 'email' => 'required|email', 'phone' => 'required']; $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } else { $password = Input::get('password'); if (Input::has('agent_id')) { $id = Input::get('agent_id'); $agent = AgentModel::find($id); if ($password !== '') { $agent->secure_key = md5($agent->salt . $password); } } else { $agent = new AgentModel(); if ($password === '') { $alert['msg'] = 'You have to enter password'; $alert['type'] = 'danger'; return Redirect::route('company.agent.create')->with('alert', $alert); } $agent->salt = str_random(8); $agent->token = str_random(8); $agent->secure_key = md5($agent->salt . $password); } $agent->name = Input::get('name'); $agent->email = Input::get('email'); $agent->phone = Input::get('phone'); $agent->store_id = Input::get('store_id'); $agent->save(); $alert['msg'] = 'Agent has been saved successfully'; $alert['type'] = 'success'; return Redirect::route('company.agent')->with('alert', $alert); } }
/** * Stores the object 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 Connection $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($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->aUser !== null) { if ($this->aUser->isModified()) { $affectedRows += $this->aUser->save($con); } $this->setUser($this->aUser); } if ($this->aAgent !== null) { if ($this->aAgent->isModified()) { $affectedRows += $this->aAgent->save($con); } $this->setAgent($this->aAgent); } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = AgentHasUserPeer::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 += AgentHasUserPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } $this->alreadyInSave = false; } return $affectedRows; }
public function run() { $agent = new Agent(); $agent->agent_first_name = 'Leticia'; $agent->agent_last_name = 'Fuentes'; $agent->agent_phone_number = '210.213.9803'; $agent->agent_email = '*****@*****.**'; $agent->agent_photo = '/img/agents/lettyfuentes.jpg'; $agent->agent_facebook = 'https://www.facebook.com/AlamoCityHomes'; $agent->agent_linkedin = 'https://www.linkedin.com/in/lettyfuentes'; $agent->agent_twitter = 'https://twitter.com/lettyfuentes5'; $agent->agent_youtube = 'https://www.youtube.com/user/AlamoCityDreamoHomes'; $agent->agent_password = $_ENV['AGENT_PASS']; // $agent->agent_listing_leads = '' //can be null // $agent->agent_listing_appointments = '' //can be null // $agent->agent_listings_taken = '' //can be null // $agent->agent_listings_sold = '' //can be null // $agent->agent_lead_to_sold_rate= ''; //can be null // $agent->agent_dollar_volume = ''; //can be null $agent->agent_lead_received = false; $agent->brokerage_id = Brokerage::findorFail(1)->id; $agent->broker_id = Broker::findorFail(1)->id; $agent->save(); }
public function agents($agent_id = NULL) { //A method to make setting up APIs a breeze $envelope = self::setupAPI($this); $verb = self::requireVerb($envelope); switch ($verb) { case 'GET': if (is_null($agent_id)) { $agent = Doctrine::getTable('Agent')->findAll(Doctrine::HYDRATE_ARRAY); } else { $agent = Doctrine::getTable('Agent')->findOneBy('agent_id', $agent_id, Doctrine::HYDRATE_ARRAY); if (!$agent) { self::throwErrorAndDie('Invalid identifier', array($agent_id), 410); } } self::returnSuccessAndDie($agent); break; case 'POST': try { if (is_null($agent_id)) { self::throwErrorAndDie('Invalid request', array($agent_id), 410); } $data = self::requireData($envelope); $agent = Doctrine::getTable('Agent')->findOneBy('agent_id', $agent_id); if (!$agent) { self::throwErrorAndDie('invalid identifier', array($agent_id), 410); } $agent->synchronizeWithArray($data); $agent->save(); self::returnSuccessAndDie($agent->toArray()); } catch (Exception $e) { self::throwErrorAndDie('invalid data', Bluebox_Controller::$validation->errors(), 400); } break; // // $agent = NULL; // // if(isset($envelope->data)) // { // $data = $envelope->data; // // if(isset($data->agent_id)) // { // $id = $data->agent_id; // // if(is_array($id)) // { // foreach($id as $_id) // { // if(is_int($_id)) // { // $agent[] = Doctrine::getTable('Agent')->findOneBy('agent_id', $_id, Doctrine::HYDRATE_ARRAY); // } // else // { // self::throwErrorAndDie('Invalid id passed'); // } // } // } // else if(is_int($id)) // { // $agent = Doctrine::getTable('Agent')->findOneBy('agent_id', $id, Doctrine::HYDRATE_ARRAY); // } // else // { // self::throwErrorAndDie('Invalid id passed'); // } // } // } // // if(!isset($agent)) // { // $agent = Doctrine::getTable('Agent')->findAll(Doctrine::HYDRATE_ARRAY); // } // // self::returnSuccessAndDie($agent); // // break; // // $agent = NULL; // // if(isset($envelope->data)) // { // $data = $envelope->data; // // if(isset($data->agent_id)) // { // $id = $data->agent_id; // // if(is_array($id)) // { // foreach($id as $_id) // { // if(is_int($_id)) // { // $agent[] = Doctrine::getTable('Agent')->findOneBy('agent_id', $_id, Doctrine::HYDRATE_ARRAY); // } // else // { // self::throwErrorAndDie('Invalid id passed'); // } // } // } // else if(is_int($id)) // { // $agent = Doctrine::getTable('Agent')->findOneBy('agent_id', $id, Doctrine::HYDRATE_ARRAY); // } // else // { // self::throwErrorAndDie('Invalid id passed'); // } // } // } // // if(!isset($agent)) // { // $agent = Doctrine::getTable('Agent')->findAll(Doctrine::HYDRATE_ARRAY); // } // // self::returnSuccessAndDie($agent); // // break; case 'PUT': try { if (!is_null($agent_id)) { self::throwErrorAndDie('invalid identifier', array($agent_id), 410); } $data = self::requireData($envelope); $agent = new Agent(); $agent->synchronizeWithArray($data); $agent->save(); self::returnSuccessAndDie($agent->toArray()); } catch (Exception $e) { self::throwErrorAndDie('invalid data', Bluebox_Controller::$validation->errors(), 400); } break; // // $data = self::requireData($envelope, 'The verb given to this API requires data to be present'); // // if(isset($data->id)) // { // $putType = "edit"; // if(!($agent = Doctrine::getTable('Agent')->findOneBy('agent_id', $data->id))) // { // $putType = "create"; // $agent = new Agent(); // $agent['agent_id'] = $data->id; // } // } // else // { // $putType = "create"; // $agent = new Agent(); // } // // if($putType == "create") // { // if(!(isset($data->name) && isset($data->type) && isset($data->device_id))) // { // self::throwErrorAndDie('When creating an new record, all fields must be present'); // } // } // // if(isset($data->name)) // { // $agent['name'] = $data->name; // } // // if(isset($data->type)) // { // $agent['type'] = $data->type; // } // // if(isset($data->device_id)) // { // if(!($device = Doctrine::getTable('Device')->findOneBy('device_id', $data->device_id))) // { // self::throwErrorAndDie('Invalid device id specified'); // } // // $agent['device_id'] = $data->device_id; // } // // if(isset($data->registry)) // { // if(is_array($data->registry)) // { // $registry = array(); // foreach($data->registry as $entry) // { // if(is_string($entry->name)) // { // $registry[$entry->name] = $entry->value; // } // else // { // self::throwErrorAndDie('The registry invalid registry key'); // } // } // // $agent->registry = arr::merge($agent->registry, $registry); // } // else // { // self::throwErrorAndDie('The registry must be an array'); // } // } // // $agent->save(); // // self::returnSuccessAndDie($agent->toArray()); // // break; // // $data = self::requireData($envelope, 'The verb given to this API requires data to be present'); // // if(isset($data->id)) // { // $putType = "edit"; // if(!($agent = Doctrine::getTable('Agent')->findOneBy('agent_id', $data->id))) // { // $putType = "create"; // $agent = new Agent(); // $agent['agent_id'] = $data->id; // } // } // else // { // $putType = "create"; // $agent = new Agent(); // } // // if($putType == "create") // { // if(!(isset($data->name) && isset($data->type) && isset($data->device_id))) // { // self::throwErrorAndDie('When creating an new record, all fields must be present'); // } // } // // if(isset($data->name)) // { // $agent['name'] = $data->name; // } // // if(isset($data->type)) // { // $agent['type'] = $data->type; // } // // if(isset($data->device_id)) // { // if(!($device = Doctrine::getTable('Device')->findOneBy('device_id', $data->device_id))) // { // self::throwErrorAndDie('Invalid device id specified'); // } // // $agent['device_id'] = $data->device_id; // } // // if(isset($data->registry)) // { // if(is_array($data->registry)) // { // $registry = array(); // foreach($data->registry as $entry) // { // if(is_string($entry->name)) // { // $registry[$entry->name] = $entry->value; // } // else // { // self::throwErrorAndDie('The registry invalid registry key'); // } // } // // $agent->registry = arr::merge($agent->registry, $registry); // } // else // { // self::throwErrorAndDie('The registry must be an array'); // } // } // // $agent->save(); // // self::returnSuccessAndDie($agent->toArray()); // // break; case 'DELETE': if (is_null($agent_id)) { self::throwErrorAndDie('invalid identifier', array($agent_id), 410); } $agent = Doctrine::getTable('Agent')->findOneBy('agent_id', $agent_id); if (!$agent) { self::throwErrorAndDie('invalid identifier', array($agent_id), 410); } $agent->delete(); self::returnSuccessAndDie(array()); break; default: self::throwErrorAndDie('Verb does not exists'); break; } }
/** * Stores the object 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 Connection $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($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->aAgent !== null) { if ($this->aAgent->isModified()) { $affectedRows += $this->aAgent->save($con); } $this->setAgent($this->aAgent); } if ($this->aUserRelatedByCreatedUserId !== null) { if ($this->aUserRelatedByCreatedUserId->isModified()) { $affectedRows += $this->aUserRelatedByCreatedUserId->save($con); } $this->setUserRelatedByCreatedUserId($this->aUserRelatedByCreatedUserId); } if ($this->aUserRelatedByUpdatedUserId !== null) { if ($this->aUserRelatedByUpdatedUserId->isModified()) { $affectedRows += $this->aUserRelatedByUpdatedUserId->save($con); } $this->setUserRelatedByUpdatedUserId($this->aUserRelatedByUpdatedUserId); } if ($this->aStatus !== null) { if ($this->aStatus->isModified()) { $affectedRows += $this->aStatus->save($con); } $this->setStatus($this->aStatus); } if ($this->aProfile !== null) { if ($this->aProfile->isModified()) { $affectedRows += $this->aProfile->save($con); } $this->setProfile($this->aProfile); } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = SchemaPeer::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 += SchemaPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } if ($this->collDiscusss !== null) { foreach ($this->collDiscusss as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collFileImportHistorys !== null) { foreach ($this->collFileImportHistorys as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collRdfNamespaces !== null) { foreach ($this->collRdfNamespaces as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collSchemaPropertys !== null) { foreach ($this->collSchemaPropertys as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collSchemaPropertyElementHistorys !== null) { foreach ($this->collSchemaPropertyElementHistorys as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collSchemaHasUsers !== null) { foreach ($this->collSchemaHasUsers as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collSchemaHasVersions !== null) { foreach ($this->collSchemaHasVersions as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; }