Example #1
0
 public function getIndex()
 {
     $associates = Associates::all();
     $msg_success = Session::get('msg_success');
     $msg_error = Session::get('msg_error');
     return View::make('backend.associates.index', array('route' => $this->route, 'associates' => $associates, 'msg_success' => $msg_success, 'msg_error' => $msg_error));
 }
 public function postTrabalhoassociado()
 {
     $credentials = array('email' => Input::get('email'), 'password' => Input::get('password'));
     $usertype = UserTypes::find(Input::get('usertype'));
     $course = Courses::find(Input::get('course'));
     if (Auth::user()->attempt($credentials)) {
         if ($inscription = Inscriptions::hasInscription(Auth::user()->user()->id, $course->id)) {
             $array = array('msg_success' => Lang::get('messages.login_welcome'), 'usertype' => $usertype, 'inscription' => $inscription);
             return Redirect::to('/autenticacao/trabalhoactualizacaoassociado/')->with($array);
         } else {
             $inscription = new Inscriptions();
             $inscription->id_course = $course->id;
             $inscription->id_user = Auth::user()->user()->id;
             $inscription->id_usertype = $usertype->id;
             $inscription->save();
             $array = array('inscription' => $inscription);
             return Redirect::to('/autenticacao/trabalhoactualizacaoassociado')->with($array);
         }
     } else {
         $associate = Associates::getByEmail($credentials['email']);
         //var_dump($associate[0]);
         /*
         			echo "Tipeado: " . $credentials['password'] . '<br>';
         
         			die(md5($credentials['password']) . '<br>'. $associate[0]->password);*/
         if (!empty($associate[0])) {
             $associate = $associate[0];
             if ($associate->password == md5($credentials['password'])) {
                 $user_finded = User::where('email', '=', $credentials['email'])->take(1)->get();
                 $user = null;
                 if (!empty($user_finded[0])) {
                     $user = $user_finded[0];
                     $user->password = Hash::make($credentials['password']);
                     $user->save();
                 } else {
                     $user = new User();
                     $user->email = $associate->email;
                     if ($associate->nombre_completo != null) {
                         $user->name = $associate->nombre_completo;
                     } else {
                         $user->name = "User without name";
                     }
                     $user->status = 'publish';
                     $user->type = 'associate';
                     $user->password = Hash::make($credentials['password']);
                     $user->save();
                 }
                 $associate->user = $user->id;
                 $associate->save();
                 Auth::user()->login($user);
                 if ($inscription = Inscriptions::hasInscription(Auth::user()->user()->id, $course->id)) {
                     $array = array('msg_success' => Lang::get('messages.login_welcome'), 'usertype' => $usertype, 'inscription' => $inscription);
                     return Redirect::to('/autenticacao/trabalhoactualizacaoassociado')->with($array);
                 } else {
                     $inscription = new Inscriptions();
                     $inscription->id_course = $course->id;
                     $inscription->id_user = Auth::user()->user()->id;
                     $inscription->id_usertype = $usertype->id;
                     $inscription->save();
                     $array = array('inscription' => $inscription);
                     return Redirect::to('/autenticacao/trabalhoactualizacaoassociado')->with($array);
                 }
             } else {
                 $associate = ORGAssociates::getByEmail($credentials['email']);
                 if (!empty($associate[0])) {
                     $associate = $associate[0];
                     if ($associate->senha == md5($credentials['password'])) {
                         $user = new User();
                         $user->email = $associate->email;
                         if ($associate->nombre_completo != null) {
                             $user->name = $associate->nombre_completo;
                         } else {
                             $user->name = "User without name";
                         }
                         $user->status = 'publish';
                         $user->type = 'associate';
                         $user->password = Hash::make($credentials['password']);
                         $user->save();
                         $assoc = new Associates();
                         $assoc->associate = $associate->id_asociado;
                         $assoc->user = $user->id;
                         $assoc->email = $associate->email;
                         if ($associate->nombre_completo != null) {
                             $assoc->name = $associate->nombre_completo;
                         } else {
                             $assoc->name = "User without name";
                         }
                         $assoc->cpf = $associate->cpf;
                         $assoc->password = $associate->senha;
                         $assoc->status = 'publish';
                         $assoc->type = 'associate';
                         $assoc->save();
                         Auth::user()->login($user);
                         if ($inscription = Inscriptions::hasInscription(Auth::user()->user()->id, $course->id)) {
                             $array = array('msg_success' => Lang::get('messages.login_welcome'), 'usertype' => $usertype, 'inscription' => $inscription);
                             return Redirect::to('/autenticacao/trabalhoactualizacaoassociado')->with($array);
                         } else {
                             $inscription = new Inscriptions();
                             $inscription->id_course = $course->id;
                             $inscription->id_user = Auth::user()->user()->id;
                             $inscription->id_usertype = $usertype->id;
                             $inscription->save();
                             $array = array('inscription' => $inscription);
                             return Redirect::to('/autenticacao/trabalhoactualizacaoassociado')->with($array);
                         }
                     } else {
                         $array = array('course' => $course, 'usertype' => $usertype, 'contents' => FrontendCourseController::getOrderedContent($course->coursesections));
                         return View::make('auth.error')->with($array);
                     }
                 } else {
                     $array = array('course' => $course, 'usertype' => $usertype, 'contents' => FrontendCourseController::getOrderedContent($course->coursesections));
                     return View::make('auth.error')->with($array);
                 }
                 $array = array('course' => $course, 'usertype' => $usertype, 'contents' => FrontendCourseController::getOrderedContent($course->coursesections));
                 return View::make('auth.error')->with($array);
             }
         } else {
             $associate = ORGAssociates::getByEmail($credentials['email']);
             if (!empty($associate[0])) {
                 $associate = $associate[0];
                 if ($associate->senha == md5($credentials['password'])) {
                     $user = new User();
                     $user->email = $associate->email;
                     if ($associate->nombre_completo != null) {
                         $user->name = $associate->nombre_completo;
                     } else {
                         $user->name = "User without name";
                     }
                     $user->status = 'publish';
                     $user->type = 'associate';
                     $user->password = Hash::make($credentials['password']);
                     $user->save();
                     $assoc = new Associates();
                     $assoc->associate = $associate->id_asociado;
                     $assoc->user = $user->id;
                     $assoc->email = $associate->email;
                     if ($associate->nombre_completo != null) {
                         $assoc->name = $associate->nombre_completo;
                     } else {
                         $assoc->name = "User without name";
                     }
                     $assoc->cpf = $associate->cpf;
                     $assoc->password = $associate->senha;
                     $assoc->status = 'publish';
                     $assoc->type = 'associate';
                     $assoc->save();
                     Auth::user()->login($user);
                     if ($inscription = Inscriptions::hasInscription(Auth::user()->user()->id, $course->id)) {
                         $array = array('msg_success' => Lang::get('messages.login_welcome'), 'usertype' => $usertype, 'inscription' => $inscription);
                         return Redirect::to('/autenticacao/trabalhoactualizacaoassociado')->with($array);
                     } else {
                         $inscription = new Inscriptions();
                         $inscription->id_course = $course->id;
                         $inscription->id_user = Auth::user()->user()->id;
                         $inscription->id_usertype = $usertype->id;
                         $inscription->save();
                         $array = array('inscription' => $inscription);
                         return Redirect::to('/autenticacao/trabalhoactualizacaoassociado')->with($array);
                     }
                 } else {
                     $array = array('course' => $course, 'usertype' => $usertype, 'contents' => FrontendCourseController::getOrderedContent($course->coursesections));
                     return View::make('auth.error')->with($array);
                 }
             } else {
                 $array = array('course' => $course, 'usertype' => $usertype, 'contents' => FrontendCourseController::getOrderedContent($course->coursesections));
                 return View::make('auth.error')->with($array);
             }
         }
     }
 }
Example #3
0
 public function getExportinscriptions($idCourse)
 {
     $course = Courses::find($idCourse);
     $inscriptions = $course->inscriptions;
     $users = array();
     $trainings = ORGTrainings::all();
     $states = ORGStates::all();
     $towns = ORGTowns::all();
     $h = 0;
     foreach ($inscriptions as $ins) {
         # code...
         // var_dump($ins->id);
         if ($ins->user->type == "associate" || $ins->user->id == 127) {
             // var_dump($ins->user->id);
             // var_dump($ins->user->type);
             $tempuser = Associates::where('user', '=', $ins->user->id)->take(1)->get();
             $users[$ins->id] = $tempuser[0]->asociado;
         } elseif ($ins->user->type == "participant" && $ins->user->id != 127) {
             $tempuser = Participants::where('user', '=', $ins->user->id)->take(1)->get();
             // if($h>30)
             // 	dd($ins->user->id);
             // else
             // 	var_dump($tempuser[0]->id);
             $users[$ins->id] = $tempuser[0]->participante;
             // }
             /*if(isset($tempuser[0])):
             			$users[$ins->id]=$tempuser[0]->participante;
             		else:
             			var_dump($ins->user->type);
             			dd($ins->user->id);
             		endif;*/
         }
         $h++;
     }
     // foreach($inscriptions as $inscription):
     // 	// $total["name"] = $inscription->user->name;
     // 	// $total["email"] = $inscription->user->email;
     // 	// $total["paid"] = $inscription->paid;
     // 	// $total["date"] = date_format(date_create($inscription->created_at), 'd-m-Y');
     // 	// $total["type"] = $inscription->usertype->title;
     // 	$total= ["nome" => $inscription->user->name,
     // 			 "email" => $inscription->user->email,
     // 			 "paid" => $inscription->paid,
     // 			 "date" => date_format(date_create($inscription->created_at), 'd-m-Y'),
     // 			 "type" => $inscription->usertype->title
     // 			 ];
     // 	// break;
     // 	// array_push($total,$inscription->user->name,$inscription->user->email);
     // endforeach;
     // dd($inscriptions);
     Excel::create('Export Inscriptions ' . $course->title . "-" . rand(2, 700 * date("H")) . "-" . date("d-m-Y"), function ($excel) use($inscriptions, $users) {
         $excel->sheet('Excel sheet', function ($sheet) use($inscriptions, $users) {
             $sheet->setOrientation('portrait');
             $n = 2;
             // $sheet->appendRow(1,array("Codigo Asociado","Nome","RG","Email", "Telefone", "Celular", "CPF", "Tipo Pessoa","Pagamento", "Fecha", "User Type", "Endereço", "Complemento", "CEP", "Cidade", "Estado", "Empresa", "Endereço Empresa", "Complemento Empresa", "Telefone Empresa", "CNPJ", "Cargo" ));
             // $inscriptions = $inscriptions;
             foreach ($inscriptions as $inscription) {
                 // $total["name"] = $inscription->user->name;
                 // $total["email"] = $inscription->user->email;
                 // $total["paid"] = $inscription->paid;
                 // $total["date"] = date_format(date_create($inscription->created_at), 'd-m-Y');
                 // $total["type"] = $inscription->usertype->title;
                 if ($inscription->paid == 0) {
                     $paid = "Não";
                 } else {
                     $paid = "Sim";
                 }
                 if ($inscription->user->type == 'associate' || $inscription->user->id == 127) {
                     // if(isset($users[$inscription->id]->codigo_asoc)){
                     // 	var_dump($users[$inscription->id]->nombre_completo);
                     // }else{
                     // 	dd($inscription->user->id);
                     // }
                     $cod_aso = $users[$inscription->id]->codigo_asoc;
                     $nome = $users[$inscription->id]->nombre_completo;
                     $rg = "";
                     //No agregados
                     $incripcion_estadual = $users[$inscription->id]->inscripcion_estadual;
                     $incripcion_municipal = $users[$inscription->id]->inscripcion_municipal;
                     $data_nascimento = $users[$inscription->id]->data_nascimento;
                     $training = ORGTrainings::find($users[$inscription->id]->formacao);
                     if ($training) {
                         $training = $training->nome;
                     } else {
                         $training = "";
                     }
                     $categoria_titulo = ORGAssociateCategories::all();
                     foreach ($categoria_titulo as $cat) {
                         if ($users[$inscription->id]->categoria == $cat->id_categoria_asociado) {
                             $categoria_titulo = $cat->nombre_categoria;
                             break;
                         }
                     }
                     $logradouro_res = "";
                     $backyards = ORGBackyards::all();
                     foreach ($backyards as $backyard) {
                         if ($users[$inscription->id]->logradouro_res == $backyard->id_logradouro) {
                             $logradouro_res = $backyard->nombre;
                             break;
                         }
                     }
                     $logradouro_com = "";
                     foreach ($backyards as $backyard) {
                         if ($users[$inscription->id]->logradouro_com == $backyard->id_logradouro) {
                             $logradouro_res = $backyard->nombre;
                             break;
                         }
                     }
                     $barrio_res = $users[$inscription->id]->bairro_res;
                     $barrio_com = $users[$inscription->id]->bairro_com;
                     $pasaporte = $users[$inscription->id]->passaporte;
                     $website = $users[$inscription->id]->web_site;
                     $responsable = $users[$inscription->id]->responsavel;
                     $publicaciones = $users[$inscription->id]->publicacoes;
                     $nombre_cientifico = $users[$inscription->id]->nome_cientifico;
                     $num_res = $users[$inscription->id]->numero_res;
                     $num_com = $users[$inscription->id]->numero_com;
                     //Fin de no agregados
                     //Campos participants no agregados
                     $cidade_empresa = "";
                     $estado_empresa = "";
                     $cep_empresa = "";
                     $state = "";
                     //Fin de campos participants no agregados
                     $cpf = $users[$inscription->id]->cpf;
                     $razon_social = $users[$inscription->id]->razon_social;
                     $celular = $users[$inscription->id]->celular_res;
                     $tipo_pessoa = $users[$inscription->id]->tipo_pessoa;
                     $data_nascimento = $users[$inscription->id]->data_nascimento;
                     $email = $users[$inscription->id]->email;
                     $data_cadastro = $users[$inscription->id]->data_cadastro;
                     $empresa = $users[$inscription->id]->empresa;
                     $empresa_dir = $users[$inscription->id]->dir_com;
                     $empresa_com = $users[$inscription->id]->complemento_com;
                     $empresa_tel = $users[$inscription->id]->ddd_com . ' ' . $users[$inscription->id]->ddi_com . ' ' . $users[$inscription->id]->telefone_com;
                     $cnpj = $users[$inscription->id]->cnpj;
                     $cargo = $users[$inscription->id]->cargo;
                     $dir = $users[$inscription->id]->dir_res;
                     $cep = $users[$inscription->id]->cep_res;
                     $complemento = $users[$inscription->id]->complemento_res;
                     $telefone = $users[$inscription->id]->ddd_res . ' ' . $users[$inscription->id]->ddi_res . ' ' . $users[$inscription->id]->telefone_res;
                     $estado = '';
                     $cidade = '';
                 } elseif ($inscription->user->type == 'participant') {
                     $cod_aso = "";
                     $nome = $users[$inscription->id]->nome;
                     // Campos de asociados obligatorio
                     $incripcion_estadual = "";
                     $incripcion_municipal = "";
                     $data_nascimento = "";
                     $training = "";
                     $categoria_titulo = "";
                     $logradouro_res = "";
                     $logradouro_com = "";
                     $barrio_res = "";
                     $barrio_com = "";
                     $pasaporte = "";
                     $website = "";
                     $responsable = "";
                     $publicaciones = "";
                     $nombre_cientifico = "";
                     $num_res = $users[$inscription->id]->numero;
                     $num_com = $users[$inscription->id]->numero_empresa;
                     //fin de campos asociados obligatorios
                     //Campos participants no agregados
                     $cidade_empresa = $users[$inscription->id]->cidade_empresa;
                     $estado_empresa = $users[$inscription->id]->estado_empresa;
                     $cep_empresa = $users[$inscription->id]->cep_empresa;
                     $state = ORGStates::all();
                     foreach ($state as $sta) {
                         if ($users[$inscription->id]->estado == $sta->name_estado) {
                             $state = $users[$inscription->id]->estado;
                             break;
                         } elseif ($users[$inscription->id]->estado == $sta->id_estado) {
                             $state = $sta->name_estado;
                             break;
                         }
                     }
                     //Fin de campos participants no agregados
                     $cpf = $users[$inscription->id]->cpf;
                     $rg = $users[$inscription->id]->rg;
                     $razon_social = '';
                     $celular = $users[$inscription->id]->celular;
                     $tipo_pessoa = 'F';
                     $data_nascimento = $users[$inscription->id]->data_nascimento;
                     $email = $users[$inscription->id]->email;
                     $data_cadastro = $users[$inscription->id]->data_cadastro;
                     $empresa = $users[$inscription->id]->empresa;
                     $empresa_dir = $users[$inscription->id]->endereco_empresa;
                     $empresa_com = $users[$inscription->id]->complemento_empresa;
                     $empresa_tel = "";
                     $cnpj = $users[$inscription->id]->cnpj;
                     $cargo = "";
                     $dir = $users[$inscription->id]->dir_res;
                     $cep = $users[$inscription->id]->cep;
                     $complemento = $users[$inscription->id]->complemento;
                     $telefone = $users[$inscription->id]->telefone;
                     $estado = $state;
                     $cidade = $users[$inscription->id]->cidade;
                     $cidade_empresa = $users[$inscription->id]->cidade_empresa;
                 }
                 $sheet->appendRow(1, array("Codigo Asociado", "Nome", "RG", "Email", "Telefone", "Celular", "CPF", "Tipo Pessoa", "Pagamento", "Fecha", "User Type", "Inscription estadual", "Inscription municipal", "Data Nascimento", "Training", "Category Title", "Logradouro Residencia", "Endereço", "Complemento", "Número Res", "Barrio Res", "CEP", "Cidade", "Estado", "Empresa", "Logradouro Empresa", "Endereço Empresa", "Cidade Empresa", "CEP Empresa", "Complemento Empresa", "Número Empresa", "Barrio Empresa", "Telefone Empresa", "CNPJ", "Cargo", "Pasaporte", "Website", "Responsavel", "Nome Cientifico", "Publicacoes"));
                 $total = ["codigo" => $cod_aso, "nome" => $nome, "rg" => $rg, "email" => $email, "telefone" => $telefone, "celular" => $celular, "cpf" => $cpf, "tipo_pessoa" => $tipo_pessoa, "paid" => $paid, "date" => date_format(date_create($inscription->created_at), 'd-m-Y'), "type" => $inscription->usertype->title, "inscription_est" => $incripcion_estadual, "incripcion_municipal" => $incripcion_municipal, "data_nascimento" => $data_nascimento, "training" => $training, "categoria_titulo" => $categoria_titulo, "logradouro_res" => $logradouro_res, "dir" => $dir, "complemento" => $complemento, "num_res" => $num_res, "barrio_res" => $barrio_res, "cep" => $cep, "cidade" => $cidade, "estado" => $estado, "empresa" => $empresa, "logradouro_com" => $logradouro_com, "empresa_dir" => $empresa_dir, "cidade_empresa" => $cidade_empresa, "cep_empresa" => $cep_empresa, "empresa_com" => $empresa_com, "num_com" => $num_com, "barrio_com" => $barrio_com, "empresa_tel" => $empresa_tel, "cnpj" => $cnpj, "cargo" => $cargo, "pasaporte" => $pasaporte, "website" => $website, "responsable" => $responsable, "nome_cientifico" => $nombre_cientifico, "publicaciones" => $publicaciones];
                 $sheet->appendRow($n, $total);
                 // break;
                 $n++;
                 // array_push($total,$inscription->user->name,$inscription->user->email);
             }
         });
     })->export('xlsx');
     // Excel::create('Export Inscriptions '. $course->title ."-". rand(2, 700*date("H"))."-".date("d-m-Y"), function($excel) use ($total){
     //     $excel->sheet('Excel sheet', function($sheet) use ($total){
     //         $sheet->setOrientation('portrait');
     //         	// dd($total);
     //         	$sheet->fromArray($total, null, 'A1', true);
     //     });
     // })->export('xlsx');
 }
 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);
     }
 }
Example #5
0
 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)));
             }
         }
     }
 }
 public function postAuth()
 {
     $credentials = array('email' => Input::get('email'), 'password' => Input::get('password'), 'type' => 'associate');
     $course = Courses::find(Input::get('course'));
     if (Auth::user()->attempt($credentials)) {
         if ($payment = ORGAssociateAnnuities::hasAnnuity(Auth::user()->user())) {
             return Redirect::to(self::$route . '/acusado');
         } else {
             return Redirect::to(self::$route . '/pagamento');
         }
     } else {
         $associate = Associates::getByEmail($credentials['email']);
         if (!empty($associate[0])) {
             $associate = $associate[0];
             if ($associate->password == md5($credentials['password'])) {
                 $user_finded = User::where('email', '=', $credentials['email'])->take(1)->get();
                 $user = null;
                 if (!empty($user_finded[0])) {
                     $user = $user_finded[0];
                     $user->password = Hash::make($credentials['password']);
                     $user->save();
                 } else {
                     $user = new User();
                     $user->email = $associate->email;
                     if ($associate->nombre_completo != null) {
                         $user->name = $associate->nombre_completo;
                     } else {
                         $user->name = "User without name";
                     }
                     $user->status = 'publish';
                     $user->type = 'associate';
                     $user->password = Hash::make($credentials['password']);
                     $user->save();
                     $associate->user = $user->id;
                     $associate->save();
                 }
                 Auth::user()->login($user);
                 if ($payment = ORGAssociateAnnuities::hasAnnuity(Auth::user()->user())) {
                     return Redirect::to(self::$route . '/acusado');
                 } else {
                     return Redirect::to(self::$route . '/pagamento');
                 }
             } else {
                 $associate = ORGAssociates::getByEmail($credentials['email']);
                 if (!empty($associate[0])) {
                     $associate = $associate[0];
                     if ($associate->senha == md5($credentials['password'])) {
                         $user = new User();
                         $user->email = $associate->email;
                         if ($associate->nombre_completo != null) {
                             $user->name = $associate->nombre_completo;
                         } else {
                             $user->name = "User without name";
                         }
                         $user->status = 'publish';
                         $user->type = 'associate';
                         $user->password = Hash::make($credentials['password']);
                         $user->save();
                         $assoc = new Associates();
                         $assoc->associate = $associate->id_asociado;
                         $assoc->user = $user->id;
                         $assoc->email = $associate->email;
                         if ($associate->nombre_completo != null) {
                             $assoc->name = $associate->nombre_completo;
                         } else {
                             $assoc->name = "User without name";
                         }
                         $assoc->cpf = $associate->cpf;
                         $assoc->password = $associate->senha;
                         $assoc->status = 'publish';
                         $assoc->type = 'associate';
                         $assoc->save();
                         Auth::user()->login($user);
                         if ($payment = ORGAssociateAnnuities::hasAnnuity(Auth::user()->user())) {
                             return Redirect::to(self::$route . '/acusado');
                         } else {
                             return Redirect::to(self::$route . '/pagamento');
                         }
                     } else {
                         return Redirec::to(self::$route . '/error');
                     }
                 } else {
                     return Redirec::to(self::$route . '/error');
                 }
                 return Redirec::to(self::$route . '/error');
             }
         } else {
             $associate = ORGAssociates::getByEmail($credentials['email']);
             if (!empty($associate[0])) {
                 $associate = $associate[0];
                 if ($associate->senha == md5($credentials['password'])) {
                     $user = new User();
                     $user->email = $associate->email;
                     if ($associate->nombre_completo != null) {
                         $user->name = $associate->nombre_completo;
                     } else {
                         $user->name = "User without name";
                     }
                     $user->status = 'publish';
                     $user->type = 'associate';
                     $user->password = Hash::make($credentials['password']);
                     $user->save();
                     $assoc = new Associates();
                     $assoc->associate = $associate->id_asociado;
                     $assoc->user = $user->id;
                     $assoc->email = $associate->email;
                     if ($associate->nombre_completo != null) {
                         $assoc->name = $associate->nombre_completo;
                     } else {
                         $assoc->name = "User without name";
                     }
                     $assoc->cpf = $associate->cpf;
                     $assoc->password = $associate->senha;
                     $assoc->status = 'publish';
                     $assoc->type = 'associate';
                     $assoc->save();
                     Auth::user()->login($user);
                     if ($payment = ORGAssociateAnnuities::hasAnnuity(Auth::user()->user())) {
                         return Redirect::to(self::$route . '/acusado');
                     } else {
                         return Redirect::to(self::$route . '/pagamento');
                     }
                 } else {
                     return Redirec::to(self::$route . '/error');
                 }
             } else {
                 return Redirec::to(self::$route . '/error');
             }
         }
     }
 }