CollectionController.php - Set Total Records

CollectionController.php

    public function getTotalRecords(Request $request)
    {
        if ($request->ajax()) {
            $users = User::select(['id', 'name', 'email', 'created_at', 'updated_at'])->get();

            return Datatables::of($users)
                ->setTotalRecords(20)
                ->make(true);
        }

        return view('datatables.collection.total-records');
    }

Javascript

    $('#users-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: 'https://yajratables.tuecus.com/collection/total-records',
        columns: [
            {data: 'id', name: 'id'},
            {data: 'name', name: 'name'},
            {data: 'email', name: 'email'},
            {data: 'created_at', name: 'created_at'},
            {data: 'updated_at', name: 'updated_at'}
        ]
    });