middleware(['permission:show_states'])->only('index'); $this->middleware(['permission:edit_state'])->only('edit'); $this->middleware(['permission:delete_state'])->only('destroy'); $this->state_rules = [ 'name' => ['required','max:255'], 'country_id' => ['required'], ]; $this->state_messages = [ 'name.required' => translate('State Name is required'), 'name.max' => translate('Max 255 characters'), 'country_id.required' => translate('Country is required'), ]; } /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $sort_search = null; $states = State::orderBy('id','asc'); $countries = Country::where('status',1)->get(); if ($request->has('search')){ $sort_search = $request->search; $states = $states->where('name', 'like', '%'.$sort_search.'%'); } $states = $states->paginate(10); return view('admin.member_profile_attributes.states.index', compact('states','countries','sort_search')); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { // } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $rules = $this->state_rules; $messages = $this->state_messages; $validator = Validator::make($request->all(), $rules, $messages); if ($validator->fails()) { flash(translate('Sorry! Something went wrong'))->error(); return Redirect::back()->withErrors($validator); } $state = new State; $state->name = $request->name; $state->country_id = $request->country_id; if($state->save()) { flash(translate('New state has been added successfully'))->success(); return redirect()->route('states.index'); } else { flash(translate('Sorry! Something went wrong.'))->error(); return back(); } } /** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // } /** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $state = State::findOrFail(decrypt($id)); $countries = Country::where('status',1)->get(); return view('admin.member_profile_attributes.states.edit', compact('state','countries')); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $rules = $this->state_rules; $messages = $this->state_messages; $validator = Validator::make($request->all(), $rules, $messages); if ($validator->fails()) { flash(translate('Sorry! Something went wrong'))->error(); return Redirect::back()->withErrors($validator); } $state = State::findOrFail($id); $state->name = $request->name; $state->country_id = $request->country_id; if($state->save()) { flash(translate('State info has been updated successfully'))->success(); return redirect()->route('states.index'); } else { flash(translate('Sorry! Something went wrong.'))->error(); return back(); } } /** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $state = State::findOrFail($id); foreach ($state->cities as $key => $city) { $city->delete(); } if (State::destroy($id)) { flash(translate('State info has been deleted successfully'))->success(); return redirect()->route('states.index'); } else { flash(translate('Sorry! Something went wrong.'))->error(); return back(); } } // Get State by country public function get_state_by_country(Request $request) { $states = State::where('country_id', $request->country_id)->get(); return $states; } }