EVOLUTION-NINJA

Edit File: ae_calculator.php

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

<h2 class="mb-4">AE Calculator</h2>

</div>
    </div>

<label class="form-label">Select Product</label>

<option value="">Select Product</option>

<?php foreach($products as $p): ?>

<option value="<?= $p['product_id'] ?>"

data-rc="<?= $p['rc_price'] ?>"
                data-basic="<?= $p['basic_price'] ?>"
                data-ndp="<?= $p['ndp'] ?>"
                data-gst="<?= $p['gst_percent'] ?>">

<?= $p['model_name'] ?>

</option>

<?php endforeach; ?>

</select>

</div>

<label class="form-label">RC Price</label>

</div>

<label class="form-label">Basic Price</label>

</div>

</div>

</div>

<label class="form-label">AE Commission %</label>

</div>

<hr>

<label class="form-label">AE Commission</label>

</div>

<label class="form-label">
        GST on AE Commission
    </label>

</div>

<label class="form-label">Billing Price</label>

</div>

<label class="form-label">
        GST on RC Price
    </label>

</div>

</div>

<label class="form-label">GST Difference</label>

</div>

</div>
<div class="row">

</div>

<label class="form-label">Dealer Margin</label>

</div>

Save Calculator

</button>

</div>

</form>

</div>

</section>

$(document).ready(function () {

// Product Change

$('#product_id').change(function () {

let selected = $(this).find(':selected');

$('#rc_price').val(selected.data('rc'));

$('#basic_price').val(selected.data('basic'));

$('#ndp').val(selected.data('ndp'));

$('#gst_percent').val(selected.data('gst'));

calculateAE();
    });

// Recalculate

$('#ae_commission_percent, #subsidy_amount').on('keyup change', function () {

calculateAE();

});

function calculateAE()
{

let rc_price =
        parseFloat($('#rc_price').val()) || 0;

let basic_price =
        parseFloat($('#basic_price').val()) || 0;

let ndp =
        parseFloat($('#ndp').val()) || 0;

let gst_percent =
        parseFloat($('#gst_percent').val()) || 0;

let ae_percent =
        parseFloat($('#ae_commission_percent').val()) || 0;

// AE COMMISSION

let ae_commission =
        (basic_price * ae_percent) / 100;

// GST ON AE COMMISSION

let gst_on_ae_commission =
        (ae_commission * gst_percent) / 100;

// NDP WITH GST

let ndp_with_gst =
        ndp + ((ndp * gst_percent) / 100);

// GST ON NDP

let gst_on_ndp =
        ndp_with_gst - ndp;

// GST ON RC PRICE

let gst_on_rc_price =rc_price-basic_price;
        // (rc_price * gst_percent) / 100;

// GST DIFFERENCE

let gst_difference =
        gst_on_rc_price - gst_on_ndp;

// BILLING PRICE

let billing_price =
        rc_price
        - ae_commission
        - gst_on_ae_commission;

// DEALER MARGIN

let dealer_margin =
        rc_price
        - ndp_with_gst
        - gst_difference
        - ae_commission;

// SET VALUES

$('#ae_commission').val(
        ae_commission.toFixed(2)
    );

$('#gst_on_ae_commission').val(
        gst_on_ae_commission.toFixed(2)
    );

$('#ndp_with_gst').val(
        ndp_with_gst.toFixed(2)
    );

$('#gst_on_ndp').val(
        gst_on_ndp.toFixed(2)
    );

$('#gst_on_rc_price').val(
        gst_on_rc_price.toFixed(2)
    );

$('#gst_difference').val(
        gst_difference.toFixed(2)
    );

$('#billing_price').val(
        billing_price.toFixed(2)
    );

$('#dealer_margin').val(
        dealer_margin.toFixed(2)
    );

}
// SAVE CALCULATOR
$(document).ready(function () {

$('#save_calculator').on('click', function (e) {

e.preventDefault();

let product_id = $('#product_id').val();

if (product_id == '') {

alert('Please select product');

return false;
        }

let model_name =
            $('#product_id option:selected').text();

let formData = {

product_id:
                product_id,

model_name:
                model_name,

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

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

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

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

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

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

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

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

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

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

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

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

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

console.log(formData);

$.ajax({

url: "<?= base_url('save-ae-calculator') ?>",

type: "POST",

data: formData,

dataType: "json",

success: function(response) {

console.log(response);

if (response.status == 1) {

alert(response.message);

} else {

alert(response.message);
                }
            },

error: function(xhr) {

console.log(xhr.responseText);

alert('Error while saving data');
            }

});

</script>

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