หมวดหมู่: PHP

 /** * Display a listing of the resource. */ public function index (Request $request) { if ($request->ajax ()) { $json = [ 'data' => [], 'draw' => $request->input ('draw', 1) , 'recordsFiltered' => 0, 'recordsTotal' => 0, ]; $query = Ticket::query () ; $json['recordsTotal'] = $query->count () ; if ($request->has ('search') && !empty ($request->search)) { if (!empty ($request->search['id']) && is_int ( (int) $request->search['id'])) { $query->where ('id', (int) $request->search['id']) ; } if ($request->search['category_id'] && is_int ( (int) $request->search['category_id'])) { $query->where ('category_id', $request->search['category_id']) ; } if ($request->search['service_lines_id'] && is_int ( (int) $request->search['service_lines_id'])) { $query->where ('service_lines_id', $request->search['service_lines_id']) ; } if ($request->search['status_id'] && is_int ( (int) $request->search['status_id'])) { $query->where ('status_id', $request->search['status_id']) ; } if ($request->search['support_engineer_id'] && is_int ( (int) $request->search['support_engineer_id'])) { $query->where ('support_engineer_id', $request->search['support_engineer_id']) ; } } $json['data'] = $query->get () ->map (function ($ticket) { return [ 'id' => $ticket->id, 'category_id' => $ticket->category_id, 'vessel_id' => $ticket->vessel_id, 'service_lines_id' => $ticket->service_lines_id, 'support_engineer_id' => $ticket->support_engineer_id, 'sla_dt' => $ticket->sla_dt, 'working_time' => $ticket->working_time, ]; }) ->skip (request () ->input ('start', $request->input ('start', 0))) ->take (request () ->input ('length', $request->input ('length', -1))) ->toArray () ; $json['recordsFiltered'] = $query->count () ; return response () ->json ($json) ; } else { return view ('tickets.index', ['title' => 'Tickets List']) ; } }