public function getBusqueda()
{
$quest = Input::get('q');
$area = Input::get('area_de_especializacion');
$per_page = 5;
if ($quest != null) {
$pk = 'id_asociado';
$parameters = $this->engine($quest, $pk, $area);
$pieces = $parameters['pieces'];
$regexp = $parameters['regexp'];
$ins = $parameters['ins'];
$primary_key = $parameters['primary_key'];
$consultores = ORGAssociates::whereNested(function ($query) use($pieces, $regexp, $ins, $primary_key) {
$query->whereRaw($primary_key . ' in (' . $ins . ') ');
})->select(array('id_asociado', 'nombre_completo', 'email', 'telefone_res', 'ddi_res', 'sexo', 'classificados_conteudo', 'classificados_imagem'))->orderByRaw(\DB::raw("FIELD(" . $primary_key . ", " . $ins . ")"))->paginate($per_page);
// Lighthing top_results
foreach ($consultores as $result) {
$result->nombre_completo = str_replace(trim($quest), '<span style="background-color:#FFFF00">' . trim($quest) . '</span>', $result->nombre_completo);
$result->nombre_completo = str_replace(mb_strtoupper(trim($quest), 'UTF-8'), '<span style="background-color:#FFFF00">' . trim(mb_strtoupper($quest, 'UTF-8')) . '</span>', $result->nombre_completo);
$result->nombre_completo = str_replace(mb_strtolower(trim($quest), 'UTF-8'), '<span style="background-color:#FFFF00">' . trim(mb_strtolower($quest, 'UTF-8')) . '</span>', $result->nombre_completo);
$result->nombre_completo = str_replace(mb_convert_case(trim($quest), MB_CASE_TITLE, 'UTF-8'), '<span style="background-color:#FFFF00">' . trim(mb_convert_case($quest, MB_CASE_TITLE, 'UTF-8')) . '</span>', $result->nombre_completo);
$result->light_email = str_replace(trim($quest), '<span style="background-color:#FFFF00">' . trim($quest) . '</span>', $result->email);
$result->classificados_conteudo = str_replace(trim($quest), '<span style="background-color:#FFFF00">' . trim($quest) . '</span>', $result->classificados_conteudo);
$result->classificados_conteudo = str_replace(mb_strtoupper(trim($quest), 'UTF-8'), '<span style="background-color:#FFFF00">' . trim(mb_strtoupper($quest, 'UTF-8')) . '</span>', $result->classificados_conteudo);
$result->classificados_conteudo = str_replace(mb_strtolower(trim($quest), 'UTF-8'), '<span style="background-color:#FFFF00">' . trim(mb_strtolower($quest, 'UTF-8')) . '</span>', $result->classificados_conteudo);
$result->classificados_conteudo = str_replace(mb_convert_case(trim($quest), MB_CASE_TITLE, 'UTF-8'), '<span style="background-color:#FFFF00">' . trim(mb_convert_case($quest, MB_CASE_TITLE, 'UTF-8')) . '</span>', $result->classificados_conteudo);
foreach ($pieces as $piece) {
$result->classificados_conteudo = str_replace($piece, ' <span style="background-color:#FFFF00">' . trim($piece) . '</span> ', $result->classificados_conteudo);
$result->classificados_conteudo = str_replace(mb_strtoupper($piece, 'UTF-8'), ' <span style="background-color:#FFFF00">' . trim(mb_strtoupper($piece, 'UTF-8')) . '</span> ', $result->classificados_conteudo);
$result->classificados_conteudo = str_replace(mb_strtolower($piece, 'UTF-8'), ' <span style="background-color:#FFFF00">' . trim(mb_strtolower($piece, 'UTF-8')) . '</span> ', $result->classificados_conteudo);
$result->classificados_conteudo = str_replace(mb_convert_case($piece, MB_CASE_TITLE, 'UTF-8'), ' <span style="background-color:#FFFF00">' . trim(mb_convert_case($piece, MB_CASE_TITLE, 'UTF-8')) . '</span> ', $result->classificados_conteudo);
}
}
} elseif ($area != '-1' && $area != null) {
# code...
$consultores = ORGAssociates::where('classificados_view', '=', '1')->where('area_de_especializacion', '=', $area)->paginate($per_page);
} else {
$consultores = ORGAssociates::where('classificados_view', '=', '1')->paginate($per_page);
}
$args = array('q' => $quest, 'consultores' => $consultores, 'data' => $area, 'route' => self::$route);
return View::make('frontend.consultores.engine')->with($args);
}
public function postCadastrojuridica()
{
if (count(ORGAssociates::where('email', '=', Input::get('login'))->get()) > 0) {
return Redirect::to(self::$route . '/cadastrojuridica')->with(array('msg_error' => 'Email Cadastrado'));
} elseif (count(User::where('email', '=', Input::get('login'))->get()) > 0) {
return Redirect::to(self::$route . '/cadastrojuridica')->with(array('msg_error' => 'Email Cadastrado'));
} else {
$org_associate = new ORGAssociates();
$org_associate->email = Input::get('login');
$org_associate->senha = md5(Input::get('password'));
$org_associate->tipo_pessoa = 'J';
$org_associate->save();
$user = new User();
$user->email = Input::get('login');
$user->password = Hash::make(Input::get('password'));
$user->type = 'associate';
$user->status = 'publish';
$user->save();
$associate = new Associates();
$associate->email = Input::get('login');
$associate->password = md5(Input::get('password'));
$associate->user = $user->id;
$associate->associate = $org_associate->id_asociado;
$associate->type = 'associate';
$associate->status = 'publish';
$associate->save();
Auth::user()->login($user);
return Redirect::to(self::$route);
}
}
public function postCadastro()
{
$associate = Auth::user()->user()->associate->asociado;
if (Input::get('senha') != '') {
$associate->senha = md5(Input::get('senha'));
$assoc = $associate->associate;
$assoc->password = $associate->senha;
$assoc->save();
$user = $assoc->user;
$user->password = Hash::make(Input::get('senha'));
$user->save();
}
if (Input::get('email') != $associate->email) {
$new_email = Input::get('email');
$asocs = ORGAssociates::where('email', '=', $new_email)->get();
$users = User::where('email', '=', $new_email)->get();
$bool = false;
if (isset($asocs[0])) {
foreach ($asocs as $ascoc) {
if ($ascoc->id_asociado != $associate->id_asociado) {
$bool = true;
}
}
}
if (isset($users[0])) {
foreach ($users as $user) {
if (!($user->type == 'associate' and $user->associate->asociado->id_asociado == $associate->id_asociado)) {
$bool = true;
}
}
}
if (!$bool) {
$user = $associate->associate->getuser;
$user->email = $new_email;
$user->save();
} else {
dd('Este correo ya le pertenece a un usuario registrado');
}
}
$associate->nombre_completo = Input::get('nombre_completo');
$associate->data_nascimento = date('Y-m-d', strtotime(Input::get('data_nascimento')));
$associate->email = Input::get('email');
$associate->sexo = Input::get('sexo');
$associate->edo_civil = Input::get('edo_civil');
$associate->senha = Input::get('senha') != '' ? md5(Input::get('senha')) : $associate->senha;
$associate->passaporte = Input::get('passaporte');
$associate->web_site = Input::get('web_site');
$associate->institucion = Input::get('institucion');
$associate->categoria = Input::get('categoria');
$associate->empresa = Input::get('empresa');
$associate->cargo = Input::get('cargo');
$associate->rg = Input::get('rg');
$associate->cpf = Input::get('cpf');
$associate->tipo_correspondencia = Input::get('tipo_correspondencia');
$associate->cep_res = Input::get('cep_res');
$associate->logradouro_res = Input::get('logradouro_res');
$associate->numero_res = Input::get('numero_res');
$associate->dir_res = Input::get('dir_res');
$associate->complemento_res = Input::get('complemento_res');
$associate->bairro_res = Input::get('bairro_res');
$associate->pais_res = Input::get('pais_res');
$associate->uf_res = Input::get('uf_res');
$associate->municipio_res = Input::get('municipio_res');
$associate->cep_com = Input::get('cep_com');
$associate->logradouro_com = Input::get('logradouro_com');
$associate->numero_com = Input::get('numero_com');
$associate->dir_com = Input::get('dir_com');
$associate->complemento_com = Input::get('complemento_com');
$associate->bairro_com = Input::get('bairro_com');
$associate->pais_com = Input::get('pais_com');
$associate->uf_com = Input::get('uf_com');
$associate->municipio_com = Input::get('municipio_com');
$associate->area_de_especializacion = Input::get('area_de_especializacion');
$associate->classificados_conteudo = Input::get('classificados_conteudo');
$image = Input::file('classificados_imagem');
$validator = Validator::make(array('image' => $image), array('image' => 'required|mimes:png,jpeg,gif'), array('mimes' => 'Tipo de imagen inválido, solo se admite los formatos PNG, JPEG, y GIF'));
if (!$validator->fails()) {
$associate->classificados_imagem = $this->uploadImage($image);
}
$associate->save();
return Redirect::to(self::$route . '/cadastro');
}
public function postUpdate($id = '')
{
if ($id == '') {
return Redirect::to($this->route);
} else {
$associate = ORGAssociates::find($id);
if (!$associate) {
return Redirect::to($this->route);
} else {
if (Input::get('senha') != '') {
$new_password = Input::get('senha');
if ($associate->associate != null) {
$user = $associate->associate->getuser;
$user->password = Hash::make($new_password);
$user->save();
} else {
$user = new User();
$user->type = 'associate';
$user->email = $associate->email;
$user->password = Hash::make($new_password);
$user->name = $associate->nombre_completo;
$user->status = 'publish';
$user->save();
$assoc = new Associates();
$assoc->associate = $associate->id_asociado;
$assoc->user = $user->id;
$assoc->name = $associate->nombre_completo;
$assoc->email = $associate->email;
$assoc->password = $associate->senha;
$assoc->cpf = $associate->cpf;
$assoc->type = 'associate';
$assoc->status = 'publish';
$assoc->save();
}
}
if (Input::get('email') != $associate->email) {
$new_email = Input::get('email');
$asocs = ORGAssociates::where('email', '=', $new_email)->get();
$users = User::where('email', '=', $new_email)->get();
$bool = false;
if (isset($asocs[0])) {
foreach ($asocs as $ascoc) {
if ($ascoc->id_asociado != $associate->id_asociado) {
$bool = true;
}
}
}
if (isset($users[0])) {
foreach ($users as $user) {
if (!($user->type == 'associate' and $user->associate->asociado->id_asociado == $associate->id_asociado)) {
$bool = true;
}
}
}
if (!$bool) {
if ($associate->associate != null) {
$user = $associate->associate->getuser;
$user->email = $new_email;
$user->save();
} else {
$user = new User();
$user->type = 'associate';
$user->email = $new_email;
$user->name = $associate->nombre_completo;
$user->status = 'publish';
$user->save();
$assoc = new Associates();
$assoc->associate = $associate->id_asociado;
$assoc->user = $user->id;
$assoc->name = $associate->nombre_completo;
$assoc->email = $new_email;
$assoc->cpf = $associate->cpf;
$assoc->type = 'associate';
$assoc->status = 'publish';
$assoc->save();
}
} else {
dd('Este correo ya le pertenece a un asociado registrado');
}
}
$associate->status_asso = Input::get('status_asso') != null ? Input::get('status_asso') : $associate->status_asso;
$associate->categoria = Input::get('categoria') != null ? Input::get('categoria') : $associate->categoria;
// $associate->es_associado = 1 != null ? Input::get('es_associado') : $associate->es_associado;
$associate->estado_matricula = Input::get('estado_matricula') != null ? Input::get('estado_matricula') : $associate->estado_matricula;
$associate->institucion = Input::get('institucion') != null ? Input::get('institucion') : $associate->institucion;
$associate->codigo_matricula = Input::get('codigo_matricula') != null ? Input::get('codigo_matricula') : $associate->codigo_matricula;
$associate->nombre_completo = Input::get('nombre_completo') != null ? Input::get('nombre_completo') : $associate->nombre_completo;
$associate->tipo_pessoa = Input::get('tipo_pessoa') != null ? Input::get('tipo_pessoa') : $associate->tipo_pessoa;
$associate->formacao = Input::get('formacao') != null ? Input::get('formacao') : $associate->formacao;
$associate->cpf = Input::get('cpf') != null ? Input::get('cpf') : $associate->cpf;
$associate->data_cadastro = Input::get('data_cadastro') != null ? Input::get('data_cadastro') : $associate->data_cadastro;
$associate->edo_civil = Input::get('edo_civil') != null ? Input::get('edo_civil') : $associate->edo_civil;
$associate->senha = Input::get('senha') != null ? md5(Input::get('senha')) : $associate->senha;
$associate->web_site = Input::get('web_site') != null ? Input::get('web_site') : $associate->web_site;
$associate->rg = Input::get('rg') != null ? Input::get('rg') : $associate->rg;
$associate->razon_social = Input::get('razon_social') != null ? Input::get('razon_social') : $associate->razon_social;
$associate->sexo = Input::get('sexo') != null ? Input::get('sexo') : $associate->sexo;
$associate->cpf = Input::get('cpf') != null ? Input::get('cpf') : $associate->cpf;
$associate->cnpj = Input::get('cnpj') != null ? Input::get('cnpj') : $associate->cnpj;
$associate->passaporte = Input::get('passaporte') != null ? Input::get('passaporte') : $associate->passaporte;
$associate->tipo_correspondencia = Input::get('tipo_correspondencia') != null ? Input::get('tipo_correspondencia') : $associate->tipo_correspondencia;
$associate->email = Input::get('email') != null ? Input::get('email') : $associate->email;
$associate->web_site = Input::get('web_site') != null ? Input::get('web_site') : $associate->web_site;
$associate->responsavel = Input::get('responsavel') != null ? Input::get('responsavel') : $associate->responsavel;
$associate->observacao = Input::get('observacao') != null ? Input::get('observacao') : $associate->observacao;
$associate->empresa = Input::get('empresa') != null ? Input::get('empresa') : $associate->empresa;
$associate->cargo = Input::get('cargo') != null ? Input::get('cargo') : $associate->cargo;
$associate->cep_res = Input::get('cep_res') != null ? Input::get('cep_res') : $associate->cep_res;
$associate->logradouro_res = Input::get('logradouro_res') != null ? Input::get('logradouro_res') : $associate->logradouro_res;
$associate->dir_res = Input::get('dir_res') != null ? Input::get('dir_res') : $associate->dir_res;
$associate->complemento_res = Input::get('complemento_res') != null ? Input::get('complemento_res') : $associate->complemento_res;
$associate->numero_res = Input::get('numero_res') != null ? Input::get('numero_res') : $associate->numero_res;
$associate->bairro_res = Input::get('bairro_res') != null ? Input::get('bairro_res') : $associate->bairro_res;
$associate->pais_res = Input::get('pais_res') != null ? Input::get('pais_res') : $associate->pais_res;
$associate->ddd_res = Input::get('ddd_res') != null ? Input::get('ddd_res') : $associate->ddd_res;
$associate->ddi_res = Input::get('ddi_res') != null ? Input::get('ddi_res') : $associate->ddi_res;
$associate->telefone_res = Input::get('telefone_res') != null ? Input::get('telefone_res') : $associate->telefone_res;
$associate->ddd_two_res = Input::get('ddd_two_res') != null ? Input::get('ddd_two_res') : $associate->ddd_two_res;
$associate->ddi_two_res = Input::get('ddi_two_res') != null ? Input::get('ddi_two_res') : $associate->ddi_two_res;
$associate->telefone_seg_res = Input::get('telefone_seg_res') != null ? Input::get('telefone_seg_res') : $associate->telefone_seg_res;
$associate->ddd_cel_res = Input::get('ddd_cel_res') != null ? Input::get('ddd_cel_res') : $associate->ddd_cel_res;
$associate->ddi_cel_res = Input::get('ddi_cel_res') != null ? Input::get('ddi_cel_res') : $associate->ddi_cel_res;
$associate->celular_res = Input::get('celular_res') != null ? Input::get('celular_res') : $associate->celular_res;
$associate->ciudad_internacional_res = Input::get('ciudad_internacional_res') != null ? Input::get('ciudad_internacional_res') : $associate->ciudad_internacional_res;
$associate->uf_res = Input::get('uf_res') != null ? Input::get('uf_res') : $associate->uf_res;
$associate->municipio_res = Input::get('municipio_res') != null ? Input::get('municipio_res') : $associate->municipio_res;
$associate->cep_com = Input::get('cep_com') != null ? Input::get('cep_com') : $associate->cep_com;
$associate->logradouro_com = Input::get('logradouro_com') != null ? Input::get('logradouro_com') : $associate->logradouro_com;
$associate->dir_com = Input::get('dir_com') != null ? Input::get('dir_com') : $associate->dir_com;
$associate->complemento_com = Input::get('complemento_com') != null ? Input::get('complemento_com') : $associate->complemento_com;
$associate->numero_com = Input::get('numero_com') != null ? Input::get('numero_com') : $associate->numero_com;
$associate->bairro_com = Input::get('bairro_com') != null ? Input::get('bairro_com') : $associate->bairro_com;
$associate->pais_com = Input::get('pais_com') != null ? Input::get('pais_com') : $associate->pais_com;
$associate->ddd_com = Input::get('ddd_com') != null ? Input::get('ddd_com') : $associate->ddd_com;
$associate->ddi_com = Input::get('ddi_com') != null ? Input::get('ddi_com') : $associate->ddi_com;
$associate->telefone_com = Input::get('telefone_com') != null ? Input::get('telefone_com') : $associate->telefone_com;
$associate->ddd_two_com = Input::get('ddd_two_com') != null ? Input::get('ddd_two_com') : $associate->ddd_two_com;
$associate->ddi_two_com = Input::get('ddi_two_com') != null ? Input::get('ddi_two_com') : $associate->ddi_two_com;
$associate->telefone_seg_com = Input::get('telefone_seg_com') != null ? Input::get('telefone_seg_com') : $associate->telefone_seg_com;
$associate->ddd_cel_com = Input::get('ddd_cel_com') != null ? Input::get('ddd_cel_com') : $associate->ddd_cel_com;
$associate->ddi_cel_com = Input::get('ddi_cel_com') != null ? Input::get('ddi_cel_com') : $associate->ddi_cel_com;
$associate->celular_com = Input::get('celular_com') != null ? Input::get('celular_com') : $associate->celular_com;
$associate->ciudad_internacional_com = Input::get('ciudad_internacional_com') != null ? Input::get('ciudad_internacional_com') : $associate->ciudad_internacional_com;
$associate->uf_com = Input::get('uf_com') != null ? Input::get('uf_com') : $associate->uf_com;
$associate->municipio_com = Input::get('municipio_com') != null ? Input::get('municipio_com') : $associate->municipio_com;
$associate->classificados_conteudo = Input::get('classificados_conteudo') != null ? Input::get('classificados_conteudo') : $associate->classificados_conteudo;
$associate->classificados_view = Input::get('classificados_view') != null ? Input::get('classificados_view') : $associate->classificados_view;
$associate->area_de_especializacion = Input::get('area_de_especializacion') != null ? Input::get('area_de_especializacion') : $associate->area_de_especializacion;
$image = Input::file('classificados_imagem');
$validator = Validator::make(array('image' => $image), array('image' => 'required|mimes:png,jpeg,gif'), array('mimes' => 'Tipo de imagen inválido, solo se admite los formatos PNG, JPEG, y GIF'));
if (!$validator->fails()) {
$associate->classificados_imagem = $this->uploadImage($image);
}
if ($associate->save()) {
return Redirect::to($this->route)->with('msg_succes', Lang::get('messages.associates_update', array('title' => $associate->title)));
} else {
dd('Error');
return Redirect::to($this->route)->with('msg_error', Lang::get('messages.associates_update_err', array('title' => $associate->title)));
}
}
}
}