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