middleware('permission:rto_master-create', ['only' => ['create']]); $this->middleware('permission:rto_master-edit', ['only' => ['edit']]); $this->middleware('permission:rto_master-view', ['only' => ['view']]); $this->middleware('permission:rto_master-delete', ['only' => ['delete']]); } /** construct */ public function index(Request $request) { if($request->ajax()){ $data = rto_master::where('status','!=','deleted')->get(); return Datatables::of($data) ->addIndexColumn() ->addColumn('action', function($data){ $return = '

'; if(auth()->user()->can('rto_master-view')){ $return .= ' '; } if(auth()->user()->can('rto_master-edit')){ $return .= ' '; } if (auth()->user()->can('rto_master-delete')) { $return .= ' '; } $return .= '

'; return $return; }) /*->editColumn('percentage', function ($data) { return $data->percentage."%"; })*/ ->editColumn('status', function ($data) { if ($data->status == 'active') { return 'Active'; } else if ($data->status == 'inactive') { return 'Inactive'; } else if ($data->status == 'deleted') { return 'Deleted'; } }) ->rawColumns(['action' ,'percentage' ,'status']) ->make(true); } return view('rto_master.index'); } /** create */ public function create(Request $request){ return view('rto_master.create'); } /** create */ /** insert */ public function insert(Request $request){ if($request->ajax()) { return true; } $crud = [ 'amount' => $request->amount, // 'percentage' => $request->percentage, 'status' => 'active', 'created_at' => date('Y-m-d H:i:s'), 'created_by' => auth()->user()->id, 'updated_at' => date('Y-m-d H:i:s'), 'updated_by' => auth()->user()->id ]; $last_id = rto_master::insertGetId($crud); if ($last_id) { return redirect()->route('rto_master')->with(['success' => 'Record inserted successfully']); } else { return redirect()->back()->with(['error'=>'Faild to insert Record!'])->withInput(); } } /** insert */ /** view */ public function view(Request $request){ $id = base64_decode($request->id); $data = rto_master::where(['id' => $id])->first(); return view('rto_master.view')->with(['data'=>$data]); } /** view */ /** edit */ public function edit(Request $request){ $id = base64_decode($request->id); $data = rto_master::where(['id' => $id])->first(); return view('rto_master.edit')->with(['data'=>$data]); } /** edit */ /** update */ public function update(Request $request){ if($request->ajax()){ return true; } $id = $request->id; $crud = [ 'amount' => $request->amount, // 'percentage' => $request->percentage, 'updated_at' => date('Y-m-d H:i:s'), 'updated_by' => auth()->user()->id ]; DB::enableQueryLog(); $update = rto_master::where(['id' => $id])->update($crud); // dd(DB::getQueryLog()); if ($update){ return redirect()->route('rto_master')->with(['success' => 'Record updated successfully']); }else{ return redirect()->back()->with(['error'=>'Faild to update Record!'])->withInput(); } } /** update */ /** change-status */ public function change_status(Request $request){ if (!$request->ajax()) { exit('No direct script access allowed'); } $id = base64_decode($request->id); $data = rto_master::where(['id' => $id])->first(); if (!empty($data)) { $update = rto_master::where(['id' => $id])->update(['status' => $request->status, 'updated_at' => date('Y-m-d H:i:s'), 'updated_by' => auth('sanctum')->user()->id]); if ($update) { return response()->json(['code' => 200]); } else { return response()->json(['code' => 201]); } } else { return response()->json(['code' => 201]); } } /** change-status */ }