php and angularjs limited offset for paginating

PHP (Laravel 4.2)

//PHP function
$rowsPerPage = 50;
$num = 1;
$offsets = ($num - 1) * $rowsPerPage; 
$data['trans'] = Transaction::withoutBranch()
->select('id', 'amount')
->where('payment_date', '>=', '2019-05-06')
->limit($rowsPerPage)
->offset($offsets)
->get();

In PHP, the total of records in the database is 100. I did a query to limit 50 records for the first page then 50 records for seconds.

AngularJS

 //api call from PHP funtion
 fetchTrx: function (data) {
       return api.call('api/bank_recon/fetch_trx', data);
            },

 //controller
 .controller('bankReconCtrl', function ($scope, $state, Module, 
CSRF_TOKEN, toastr, $controller, actionBar, $compile,DTOptionsBuilder) {

 var vm = this;
        vm.dtOptions = DTOptionsBuilder.newOptions()
            .withOption('ajax', {
                // Either you specify the AjaxDataProp here
                url: 'api/bank_recon/fetch_trx',
                type: 'POST',

            })
            .withDataProp('data')
            .withOption('processing', true)
            .withOption('serverSide', true)
            .withPaginationType('full_numbers');

 ////api call from PHP funtion
 $scope.fetchTrx = function () {
            Module.fetchTrx({
                month: $scope.item.month,
                year: $scope.item.year,
                account_id: $scope.item.account_id,
                page_number: $scope.item.page_number
            }).then(function(res) {
                angular.forEach(res.trans, function (trx) {

                });

                $scope.trans = res;
                console.log($scope.trans);
                $scope.item.reconcile_date = res.reconcile_date;
                // console.log($scope.trans.photos);
                $scope.item.actual_balance = 
Math.roundCurrency(res.actual_balance);
                $scope.item.end_balance = 
Math.roundCurrency(res.end_balance);
                $scope.form.$setPristine();
            }).finally(function () {
                // calculate
                $scope.calBalance();
            });
        };

My expectation is the page will loading 50 records first then second 50 records will loading from the server when a user clicked on the second page. This is to avoid large records render at the same time lead to the page is lagging. Therefore.

I using I-lin angularjs datatable server-side processing to achieve my expectation. So far the datatable only displays 50 records not the total of 100 records.

Source: AngularJS