public function sendMailInvitation()
 {
     $last_invited_add = Input::get('invited_id');
     $inv_admin = Input::get('admin_colonia');
     $admin_colonia = Neighbors::where('id', '=', $inv_admin)->first();
     $neighbors = InvitedNeighbors::where('invited_id', '=', $last_invited_add)->get();
     $urbanism_id = Input::get('urbanismo');
     $urbanism = Urbanism::findOrFail($urbanism_id);
     $code = Session::get('code');
     foreach ($neighbors as $inv_neighbor) {
         $email = $inv_neighbor->email;
         $data = array('email' => $email, 'link' => 'ConfirmationController@confirm', 'code' => $inv_neighbor->confirmation_code, 'name_inv' => $admin_colonia->name, 'lname_inv' => $admin_colonia->last_name, 'urbanism' => $urbanism->name);
         Mail::send('emails.confirm_neighbors', $data, function ($message) use($email) {
             $message->subject('Invitación HABITARIA');
             $message->to($email);
         });
     }
     $notice_msg = "<h4>A concluido el proceso de registro</h4><p>Vecinos invitados con éxito</p>";
     return Redirect::action('NeighborController@admin_neighbor', array('admin_colonia' => $inv_admin, 'urbanismo' => $urbanism_id));
 }
 public function send_inv()
 {
     $data = Input::All();
     $invited_id = md5(uniqid(mt_rand(), true));
     $invited_neighbors = $data['mails'];
     foreach ($invited_neighbors as $neighbor_email) {
         $encrypted = Crypt::encrypt(md5(uniqid(mt_rand(), true)));
         $invited = new InvitedNeighbors();
         $invited->neighbor_id = Input::get('admin_colonia');
         $invited->invited_id = $invited_id;
         $invited->urbanism_id = Input::get('urbanism_id');
         $invited->email = $neighbor_email;
         $invited->confirmed = false;
         $invited->confirmation_code = $encrypted;
         $invited->save();
     }
     $neighbors = InvitedNeighbors::where('invited_id', '=', $invited_id)->get();
     $admin_colonia = Neighbors::where('id', '=', Input::get('admin_colonia'))->first();
     $urbanism = Urbanism::where('id', '=', Input::get('urbanism_id'))->first();
     foreach ($neighbors as $inv_neighbor) {
         $email = $inv_neighbor->email;
         $data = array('email' => $email, 'link' => 'ConfirmationController@confirm', 'code' => $inv_neighbor->confirmation_code, 'name_inv' => $admin_colonia->name, 'lname_inv' => $admin_colonia->last_name, 'urbanism' => $urbanism->Colony->name);
         Mail::send('emails.confirm_neighbors', $data, function ($message) use($email) {
             $message->subject('Invitación HABITARIA');
             $message->to($email);
         });
     }
     $notice_msg = "Vecinos invitados con éxito";
     return Redirect::action('ColonyController@edit_inv')->with('error', false)->with('msg', $notice_msg)->with('class', 'info');
 }
 public function confirm_data_fam($code)
 {
     if (!$code) {
         $error_msg = new InvalidConfirmationCodeException();
         return Redirect::action('UsersController@login')->with('error', $error_msg);
     }
     $confirm = InvitedNeighbors::where('Confirmation_code', '=', $code)->first();
     if (!$confirm) {
         $error_msg = Lang::get('confide::confide.alerts.wrong_confirmation');
         return Redirect::action('UsersController@login')->with('error', $error_msg);
     }
     if (!$confirm->confirmed) {
         $email = $confirm->email;
         $reg_user = User::where('email', '=', $email)->first();
         if ($reg_user) {
             $reg_neighbor = Neighbors::where('user_id', '=', $reg_user->id)->first();
             $property = NeighborProperty::where('neighbors_id', '=', $reg_neighbor->id)->first();
             $urbanism_id = $confirm->urbanism_id;
             $urbanism = Urbanism::findOrFail($urbanism_id);
             $urbanism_name = $urbanism->name;
             $urbanism_type = $urbanism->urbanism_type_id;
             if ($urbanism_type == 3) {
                 $catalog = BuildingCatalog::where('urbanism_id', '=', $urbanism_id)->first();
             } else {
                 $catalog = StreetCatalog::where('urbanism_id', '=', $urbanism_id)->first();
             }
             $notice_msg = Lang::get('confide::confide.alerts.confirmation_invitation');
             return View::make('dashboard.neighbors.edit_fam', ['email' => $email, 'urbanism' => $urbanism_name, 'urbanism_id' => $urbanism_id, 'code' => $code, 'urbanism_type' => $urbanism_type, 'catalog' => $catalog, 'neighbor' => $reg_neighbor, 'property' => $property, 'notice' => $notice_msg]);
         } else {
             return Redirect::action('ConfirmationController@confirm', $code);
         }
     } else {
         $notice_msg = 'Acceda a Habitaria con su usuario creado';
         return Redirect::action('UsersController@login')->with('notice', $notice_msg);
     }
 }
 public function store_update_fam()
 {
     $post = Input::All();
     $email = Input::get('email');
     $user_id = User::where('email', '=', $email)->pluck('id');
     $neighbor_add = Neighbors::where('user_id', '=', $user_id)->first();
     $neighbor_pro = NeighborProperty::where('neighbors_id', '=', $neighbor_add->id)->first();
     $user = UserNeighbors::findOrFail($user_id);
     $user->password = Hash::make(Input::get('password'));
     $user->update(['id']);
     $last_user_add = $user->id;
     $neighbor = Neighbors::findOrFail($neighbor_add->id);
     $neighbor->name = Input::get('firstname');
     $neighbor->last_name = Input::get('lastname');
     $neighbor->phone = Input::get('phone');
     $neighbor->update(['id']);
     $confirm = InvitedNeighbors::where('Confirmation_code', '=', Input::get('code'))->first();
     $confirm->confirmed = true;
     $confirm->update(['id']);
     $urbanismNeigh = $neighbor_pro->urbanism_id;
     $colonies = Colony::select('colonies.id')->join('urbanisms', 'urbanisms.colony_id', '=', 'colonies.id')->join('neighbors_properties', 'urbanisms.id', '=', 'neighbors_properties.urbanism_id')->where('neighbors_properties.urbanism_id', '=', $urbanismNeigh)->first();
     $user_auth = User::where('id', '=', $last_user_add)->first();
     Auth::login($user_auth);
     if (Auth::check()) {
         Session::put('colonia', $colonies->id);
         return Redirect::action('HomeController@index');
     } else {
         return Redirect::action('UsersController@login');
     }
 }