public function store_update()
{
$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']);
$last_neighbor_add = $neighbor->id;
$urbanism_type = Input::get('urbanism_type');
$neighbor_properties = NeighborProperty::findOrFail($neighbor_pro->id);
if ($urbanism_type == 3) {
$neighbor_properties->num_floor_id = Input::get('name_floor');
} else {
$neighbor_properties->num_street_id = Input::get('name_street');
}
$neighbor_properties->num_house_or_apartment = Input::get('num_house_or_apartment');
$neighbor_properties->update(['id']);
$confirm = InvitedNeighbors::where('Confirmation_code', '=', Input::get('code'))->first();
$confirm->confirmed = true;
$confirm->update(['id']);
$urbanismNeigh = $neighbor_properties->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');
}
}
