Tag Archive 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']);
        }
    }