public function editColonyInfo() { $data = Input::all(); $user_id = Auth::user()->id; $colonia = Session::get("colonia"); $neighbors = Neighbors::join('neighbors_properties', 'neighbors_properties.neighbors_id', '=', 'neighbors.id')->join('urbanisms', 'urbanisms.id', '=', 'neighbors_properties.urbanism_id')->join('colonies', 'colonies.id', '=', 'urbanisms.colony_id')->select('urbanisms.id as urbanisms_id', 'neighbors.id as neighbors_id', 'neighbors_properties.id as neighbors_properties_id', 'colonies.id as colonies_id')->where('colonies.id', '=', $colonia)->where('user_id', '=', $user_id)->first(); $colony = Colony::findOrFail($neighbors->colonies_id); $colony->location_id = Input::get('city'); $colony->name = Input::get('colony_name'); $colony->update(['id']); $urbanism = Urbanism::findOrFail($neighbors->urbanisms_id); $urbanism->urbanism_type_id = Input::get('urbanism_type'); $urbanism->update(['id']); $notice_msg = 'Datos guardados exitosamente'; return Redirect::action('ColonyController@edit_informacion')->with('error', false)->with('msg', $notice_msg)->with('class', 'info'); }