public function store_register_neighbors() { $post = Input::All(); $urbanismNeigh = Input::get('urbanism'); $neighbor = new Neighbors(); $neighbor->user_id = Input::get('user_id'); //$neighbor->urbanism_id = Input::get('urbanism'); $neighbor->name = Input::get('firstname'); $neighbor->last_name = Input::get('lastname'); $neighbor->phone = Input::get('phone'); $neighbor->save(); $last_neighbor_add = $neighbor->id; $urbanism_type = Input::get('urbanism_type'); $neighbor_properties = new NeighborProperty(); $neighbor_properties->neighbors_id = $last_neighbor_add; $neighbor_properties->urbanism_id = Input::get('urbanism'); 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'); if ($neighbor_properties->save()) { $role = Role::where('name', '=', 'vecino')->first(); $colony = Urbanism::where('id', '=', Input::get('urbanism'))->pluck('colony_id'); $rol = new AssigmentRole(); $rol->user_id = Input::get('user_id'); $rol->role_id = $role->id; $rol->colony_id = $colony; $rol->save(); } $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 = Neighbors::where('id', '=', $last_neighbor_add)->pluck('user_id'); $user_auth = User::where('id', '=', $user)->first(); Auth::login($user_auth); if (Auth::check()) { Session::put('colonia', $colonies->id); return Redirect::action('HomeController@index'); } else { return Redirect::action('UsersController@login'); } }