EVOLUTION-NINJA

Edit File: dealer_report.php

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

<div class="row m-0">
        <div class="col-sm-12">
            <h1 class="crt-pjt">Dealer Report</h1>
            <br>
        </div>
    </div>

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

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

</select>

</div>

</div>

</div>

Get Report

</button>

</div>

</form>

<thead>

<tr>

<th>Dealer Name</th>

<th>No. of Customers</th>

<th>Billing Price</th>

<th>Total Subsidy Amount</th>

<th>Subsidy Paid</th>

<th>Total Farmer Share</th>

<th>Farmer Share Paid</th>

<th>Total Paid</th>

<th>Balance Amount</th>

<th>AE Commission</th>
                    <th>Action</th>

</tr>

</thead>

</table>

</div>

</section>
<style>

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

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

</style>

let table;

// =====================================
// LOAD DEALER DROPDOWN
// =====================================

function loadDealerFilter()
{
    $.ajax({

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

type: "POST",

dataType: "json",

success: function(data)
        {
            let dealers = [];

data.forEach(function(row){

if(
                    row.dealer_name &&
                    !dealers.includes(row.dealer_name)
                ){

dealers.push(row.dealer_name);

$('#dealer_name').append(

`<option value="${row.dealer_name}">
                            ${row.dealer_name}
                        </option>`

);
                }

});

}

});
}

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

function loadTable()
{

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

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

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

processing: true,

destroy: true,

pageLength: 10,

scrollX: true,

responsive: false,

ajax: {

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

type: "POST",

data: function(d){

d.dealer_name =
        $('#dealer_name').val();

d.from_date =
        $('#from_date').val();

d.to_date =
        $('#to_date').val();
},

dataSrc: ""
        },

columns: [

{
                data: null,

render: function (data, type, row, meta) {

return meta.row + 1;
                }
            },

{ data: "dealer_name" },

{ data: "total_customers" },

{ data: "total_billing_price" },

{ data: "total_subsidy_amount" },

{ data: "subsidy_paid" },

{ data: "total_farmer_share_amount" },

{ data: "farmer_share_paid" },

{ data: "total_paid" },

{ data: "balance_amount" },

{ data: "total_ae_commission" },

{
    data: null,

render: function(data, type, row)
    {
        return `

<button
                class="btn btn-sm btn-primary"

onclick="viewCustomers('${row.dealer_name}')">

View Customers

</button>

`;
    }
}

]

});

}

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

$(document).ready(function () {

loadDealerFilter();

loadTable();

});

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

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

e.preventDefault();

loadTable();

});

</script>

function viewCustomers(dealer_name)
{
    window.location.href =
    "<?= base_url('farmer-report') ?>?dealer_name="
    + encodeURIComponent(dealer_name);
}
</script>

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