EVOLUTION-NINJA

Edit File: farmer_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>

Farmer Payment Report

</h1>

</div>

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

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

</select>

</div>

</div>

</div>

Get Report

</button>

</div>

</form>

<thead>

<tr>

<th>FARMER ID</th>

<th>FARMER NAME</th>

<th>DEALER</th>

<th>TOTAL PRICE</th>

<th>PAID AMOUNT</th>

<th>BALANCE AMOUNT</th>

<th>PAYMENT DATE</th>

</tr>

</thead>

<tfoot>

<tr>

TOTAL :

</th>

</tr>

</tfoot>

</table>

</div>

</section>

<style>

.dataTables_wrapper{
    width:100%;
    overflow-x:auto;
}

table.dataTable{
    width:100% !important;
}

</style>

let table;

let dealer_name = '';

// =====================================
// DOCUMENT READY
// =====================================

$(document).ready(function () {

// GET DEALER FROM URL

const params =
        new URLSearchParams(window.location.search);

dealer_name =
        params.get('dealer_name');

loadFilters();

loadTable({

dealer_name: dealer_name

});

// =====================================
// LOAD FILTERS
// =====================================

function loadFilters()
{

$.ajax({

url:
        "<?= base_url('AEReportController/getFarmerReport') ?>",

type: "POST",

dataType: "json",

success: function(data)
        {

let farmers = [];

data.forEach(function(row){

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>`

);
                }

});

}

});

}

// =====================================
// LOAD TABLE
// =====================================

function loadTable(filters = {})
{

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

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

table = $('#farmerTable').DataTable({

processing: true,

destroy: true,

scrollX: true,

responsive: false,

autoWidth: false,

pageLength: 10,

ajax: {

url:
            "<?= base_url('AEReportController/getFarmerReport') ?>",

type: "POST",

data: filters,

dataSrc: "",

error: function (xhr) {

console.log(xhr.responseText);

alert("Check console for errors.");

}

columns: [

{
        data: null,

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

{ data: "farmer_id" },

{ data: "farmer_name" },

{ data: "dealer_name" },

{ data: "total_price" },

{ data: "paid_amount" },

{ data: "balance_amount" },

{
        data: "payment_date",

render: function(data)
        {
            if(
                !data ||
                data === '0000-00-00'
            )
            {
                return `
                    <span style="
                        color:red;
                        font-weight:bold;
                    ">
                        Yet To Pay
                    </span>
                `;
            }

let d = new Date(data);

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

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

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

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

}, 0);

let totalPaid = api
                .column(5, { page: 'current' })
                .data()
                .reduce(function(a, b){

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

}, 0);

let totalBalance = api
                .column(6, { page: 'current' })
                .data()
                .reduce(function(a, b){

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

}, 0);

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

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

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

});

}

// =====================================
// FILTER SUBMIT
// =====================================

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

e.preventDefault();

let filters = {

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

dealer_name:
            dealer_name,

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

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

};

loadTable(filters);

});

</script>

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