with("categories",$categories); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $request->validate([ 'name' => 'required|string|max:191', ]); TicketCategory::create($request->all()); return redirect(route("moderator.ticket.category.index"))->with("success",__("Category created")); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function update(Request $request) { $request->validate([ 'category' => 'required|int', 'name' => 'required|string|max:191', ]); $category = TicketCategory::where("id",$request->category)->firstOrFail(); $category->name = $request->name; $category->save(); return redirect()->back()->with("success",__("Category name updated")); } /** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $category = TicketCategory::where("id",$id)->firstOrFail(); if($category->id == 5 ){ //cannot delete "other" category return back()->with("error","You cannot delete that category"); } $tickets = Ticket::where("ticketcategory_id",$category->id)->get(); foreach($tickets as $ticket){ $ticket->ticketcategory_id = "5"; $ticket->save(); } $category->delete(); return redirect() ->route('moderator.ticket.category.index') ->with('success', __('Category removed')); } public function datatable() { $query = TicketCategory::withCount("tickets"); return datatables($query) ->addColumn('name', function ( TicketCategory $category) { return $category->name; }) ->editColumn('tickets', function ( TicketCategory $category) { return $category->tickets_count; }) ->addColumn('actions', function (TicketCategory $category) { return '

'.csrf_field().' '.method_field('DELETE').'

'; }) ->editColumn('created_at', function (TicketCategory $category) { return $category->created_at ? $category->created_at->diffForHumans() : ''; }) ->rawColumns(['actions']) ->make(); } }