ป้ายกำกับ: Eloquent ORM

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