Forward_Station_Server/api/v1/ShiftPumpReport/shiftPumpView.php

<table id="example" class="table display table-striped table-bordered table-hover table-sm compact" cellspacing="0" width="100%">
        <thead>
         <tr>
             <th>Pump Number</th>
             <th>Fuel Grade</th>
             <th>Shift Opening Date</th>
             <th>Shift Closing Date</th>
             <th>Pump Opening Volume</th>
             <th>Pump Closing Volume</th>
             <th>Sale Volume (Closing Volume - Opening Volume)</th>
             <th>Unit Price</th>
             <th>Money (Sale Volume x Unit Price)</th>
         </tr>
        </thead>
<!--         <tfoot>
            <tr>
                <th>Pump Number</th>
                <th>Fuel Grade</th>
                <th>Shift Opening Date</th>
                <th>Pump Opening Volume</th>
                <th>Shift Closing</th>
                <th>Pump Closing Volume</th>
                <th>Sale Volume (Closing Volume - Opening Volume)</th>
                <th>Unit Price</th>
                <th>Money (Sale Volume x Unit Price)</th>
            </tr>
        </tfoot> -->
    </table>
<script type="text/javascript">
$(document).ready(function() {
    var table = $('#example').DataTable( {
        "processing": true, // for show progress bar
        "serverSide": false, // for process server side
        "ordering": false,
        //"bFilter": false,
        //"bInfo": false,
        "responsive": true,
        "pagingType": "full", // "simple" option for 'Previous' and 'Next' buttons only
        "ajax": "api/v1/ShiftPumpReport/shiftPumpData.txt",
        "dom": 'lBfrtip',
        "lengthMenu": [[ 30, 50, -1], [ 30, 50, "All"]],
        // "dom": '<"top"i>rt<"bottom"lp><"clear">',
        // "scrollY": "500px",
        //"buttons": [
            // 'copy',
            // 'csv',
            // 'excel',
            // 'pdf',
            // 'print',
            // { "extend": 'copy', "text":'PDF',"className": 'btn btn-primary' },
            // { "extend": 'csv', "text":'PDF',"className": 'btn btn-primary' },
            // { "extend": 'excel', "text":'PDF',"className": 'btn btn-primary' },
            // { "extend": 'pdf', "text":'PDF',"className": 'btn btn-primary' },
         //   { "extend": 'print', "text":'Print',"className": 'btn btn-primary' }
            // {
            //     text: 'My button',
            //     action: function ( e, dt, node, config ) {
            //         alert( 'Button activated' );
            //     }
            // },
            // {
            //     extend: 'print',
            //     text: 'Print all (not just selected)',
            //     exportOptions: {
            //         modifier: {
            //             selected: null
            //         }
            //     }
            // }
        //],
        "select": true,
        "columns": [
            { "data": "Fp_Id" },
            { "data": "Grade_Name" },
            { "data": "Open_Date"},
            { "data": "Close_Date" },
            { "data": "Open_Volume" },
            { "data": "Close_Volume" },
            { "data": "Sale_Total" },
            { "data": "Price" },
            { "data": "Money_Total" },
        ],
        "order": [[1, 'asc']],
       
    } );
} );
</script>