หมวดหมู่: jQuery

 /**
 * 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']) ;
 }
 }