EVOLUTION-NINJA

Edit File: subsidy_report.php

<?php echo view('includes/sidebar'); ?>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<link rel="stylesheet"
href="https://cdn.datatables.net/1.13.4/css/jquery.dataTables.min.css">

<script src="<?php echo base_url('public/assets/toastr/toastr.min.js');?>"></script>

<h1 class="crt-pjt">
                Subsidy Tracking Report
            </h1>

</div>

<label class="inpfieldname">
                                Farmer Name
                            </label>

<option value="">
                                    All Farmers
                                </option>

</select>

</div>

</select>

</div>

</div>

</div>

Get Report

</button>

</div>

Download Excel

</button>

</div>

</form>

<thead>

<tr>

<th>FARMER ID</th>

<th>FARMER NAME</th>

<th>FARMER ADDRESS</th>

<th>SUBSIDY AMOUNT</th>

<th>SUBSIDY DATE</th>

<th>RC PRICE</th>

</tr>

</thead>

<tfoot>

<tr>

</tr>

</tfoot>

</table>

</div>

</section>

let table;

$(document).ready(function () {

loadFilters();

loadTable();

});

/* LOAD FILTERS */

function loadFilters()
{

$.ajax({

url:
        "<?= base_url('subsidy/get-report') ?>",

type: "POST",

dataType: "json",

success: function(data)
        {

let farmers = [];
            let utrs = [];

data.forEach(function(row){

// FARMER

if(row.farmer_name &&
                   !farmers.includes(row.farmer_name))
                {
                    farmers.push(row.farmer_name);

$('#farmer_name').append(
                        `<option value="${row.farmer_name}">
                            ${row.farmer_name}
                        </option>`
                    );
                }

// UTR

if(row.subsidy_utr &&
                   !utrs.includes(row.subsidy_utr))
                {
                    utrs.push(row.subsidy_utr);

$('#subsidy_utr').append(
                        `<option value="${row.subsidy_utr}">
                            ${row.subsidy_utr}
                        </option>`
                    );
                }

});

}

});

}

/* LOAD TABLE */

function loadTable(filters = {})
{

if ($.fn.DataTable.isDataTable('#subsidyTable')) {

$('#subsidyTable').DataTable().destroy();
    }

// table = $('#subsidyTable').DataTable({

//     processing: true,

//     destroy: true,

//     scrollX: true,

//     responsive: false,

//     autoWidth: false,

//     pageLength: 10,

//     ajax: {

//         url:
    //         "<?= base_url('subsidy/get-report') ?>",

//         type: "POST",

//         data: filters,

//         dataSrc: ""
    //     },

//     columns: [

//         {
    //             data: null,

//             render: function(data, type, row, meta)
    //             {
    //                 return meta.row + 1;
    //             }
    //         },

//         { data: "farmer_code" },

//         { data: "farmer_name" },

//         { data: "farmer_address" },

//         { data: "subsidy_amount" },

//         { data: "subsidy_utr" },

//         {
    //             data: "subsidy_date",

//             render: function(data)
    //             {
    //                 if(!data) return '';

//                 let d = new Date(data);

//                 return d.toLocaleDateString('en-GB');
    //             }
    //         },

//         { data: "total_amt" },

//         { data: "tds" },

//         { data: "gst" },

//         { data: "tan_no" }

//     ],

//     footerCallback: function(row, data, start, end, display)
    //     {
    //         let api = this.api();

//         // TOTAL SUBSIDY

//         let subsidyTotal = api
    //             .column(4, { page: 'current' })
    //             .data()
    //             .reduce(function(a, b){

//                 return parseFloat(a || 0)
    //                      + parseFloat(b || 0);

//             }, 0);

//         // TOTAL RC PRICE

//         let rcTotal = api
    //             .column(7, { page: 'current' })
    //             .data()
    //             .reduce(function(a, b){

//                 return parseFloat(a || 0)
    //                      + parseFloat(b || 0);

//             }, 0);

//         // FOOTER DISPLAY

//         $('#totalSubsidy').html(
    //             subsidyTotal.toLocaleString('en-IN')
    //         );

//         $('#totalRCPrice').html(
    //             rcTotal.toLocaleString('en-IN')
    //         );
    //     }

// });
    
    table = $('#subsidyTable').DataTable({

processing: true,
    destroy: true,

scrollX: false,
    scrollCollapse: false,

responsive: false,
    autoWidth: false,
    pageLength: 10,

fixedHeader: false,

ajax: {
        url: "<?= base_url('subsidy/get-report') ?>",
        type: "POST",
        data: filters,
        dataSrc: ""
    },

columns: [
        {
            data: null,
            render: function(data, type, row, meta) {
                return meta.row + 1;
            }
        },
        { data: "farmer_code" },
        { data: "farmer_name" },
        { data: "farmer_address" },
        { data: "subsidy_amount" },
        { data: "subsidy_utr" },
        {
            data: "subsidy_date",
            render: function(data) {
                if(!data) return '';
                let d = new Date(data);
                return d.toLocaleDateString('en-GB');
            }
        },
        { data: "total_amt" },
        { data: "tds" },
        { data: "gst" },
        { data: "tan_no" }
    ],

footerCallback: function(row, data, start, end, display)
    {
        let api = this.api();

let subsidyTotal = api
            .column(4, { page: 'current' })
            .data()
            .reduce(function(a, b){
                return parseFloat(a || 0)
                     + parseFloat(b || 0);
            }, 0);

let rcTotal = api
            .column(7, { page: 'current' })
            .data()
            .reduce(function(a, b){
                return parseFloat(a || 0)
                     + parseFloat(b || 0);
            }, 0);

$('#totalSubsidy').html(
            subsidyTotal.toLocaleString('en-IN')
        );

$('#totalRCPrice').html(
            rcTotal.toLocaleString('en-IN')
        );
    }

});

}

/* FILTER SUBMIT */

$('#subsidyFilter').submit(function(e){

e.preventDefault();

let filters = {

farmer_name:
            $('#farmer_name').val(),

subsidy_utr:
            $('#subsidy_utr').val(),

from_date:
            $('#from_date').val(),

to_date:
            $('#to_date').val()
    };

loadTable(filters);

});

/* EXCEL DOWNLOAD */

$('#downloadExcel').click(function () {

window.location.href =
    "<?= base_url('subsidy/export-excel') ?>";

});

</script>

<?php echo view('includes/footer'); ?>