EVOLUTION-NINJA

Edit File: ae_calculator_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">
                AE Calculator Report
            </h1>

</div>

<label class="inpfieldname">
                                Model
                            </label>

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

</select>

</div>

</select>

</div>

</select>

</div>

</div>

Get Report

</button>

</div>

</form>

<thead>

<tr>

<th>Model</th>

<th>RC Price</th>

<th>Basic Price</th>

<th>AE Commission</th>

<th>Billing Price</th>

<th>Dealer Margin</th>

</tr>

</thead>

</table>

</div>

</section>

let table;

$(document).ready(function () {

loadFilters();

loadTable();

});

/* 🔷 LOAD FILTERS */

function loadFilters()
{

$.ajax({

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

type: "POST",

dataType: "json",

success: function(data)
        {

let models = [];
            let gsts = [];
            let aes = [];

data.forEach(function(row){

if(row.model_name &&
                   !models.includes(row.model_name))
                {
                    models.push(row.model_name);

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

if(row.gst_percent &&
                   !gsts.includes(row.gst_percent))
                {
                    gsts.push(row.gst_percent);

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

if(row.ae_commission_percent &&
                   !aes.includes(row.ae_commission_percent))
                {
                    aes.push(row.ae_commission_percent);

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

});

}

});

}

/* 🔷 LOAD TABLE */

function loadTable(filters = {})
{

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

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

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

//     processing: true,

//     pageLength: 10,

//     ajax: {

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

//         type: "POST",

//         data: filters,

//         dataSrc: ""
    //     },

//     columns: [

//         {
    //             data: null,

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

//         { data: "model_name" },

//         { data: "rc_price" },

//         { data: "basic_price" },

//         { data: "ndp" },

//         { data: "gst_percent" },

//         { data: "ae_commission_percent" },

//         { data: "ae_commission" },

//         { data: "gst_on_ae_commission" },

//         { data: "billing_price" },

//         { data: "gst_on_rc_price" },

//         { data: "gst_on_ndp" },

//         { data: "gst_difference" },

//         { data: "ndp_with_gst" },

//         { data: "dealer_margin" },

//         {
    //             data: "created_at",

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

//                 let d = new Date(data);

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

//     ]

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

processing: true,

pageLength: 10,

scrollX: true,

responsive: false,

autoWidth: false,

ajax: {

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

type: "POST",

data: filters,

dataSrc: ""
    },

columns: [

{
            data: null,

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

{ data: "model_name" },

{ data: "rc_price" },

{ data: "basic_price" },

{ data: "ndp" },

{ data: "gst_percent" },

{ data: "ae_commission_percent" },

{ data: "ae_commission" },

{ data: "gst_on_ae_commission" },

{ data: "billing_price" },

// { data: "gst_on_rc_price" },

// { data: "gst_on_ndp" },

{ data: "gst_difference" },

{ data: "ndp_with_gst" },

{ data: "dealer_margin" },

{
            data: "created_at",

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

let d = new Date(data);

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

]

});

}

/* 🔷 FILTER SUBMIT */

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

e.preventDefault();

let filters = {

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

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

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

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

loadTable(filters);

});

</script>

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