File: /var/www/html/taxicamera/application/views/admin/driver_settlement/bulk_settlement.php
<div class="main-content">
<div class="content-wrapper">
<div class="container-fluid">
<!-- Basic form layout section start -->
<section id="basic-form-layouts">
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-header">
<div class="page-title-wrap">
<h4 class="card-title">Bulk Settlement</h4>
</div>
</div>
<div class="card-body">
<div class="px-3">
<form id="driver_payin" class="roster_form_s" method="post">
<input type="hidden" id="shift_id" name="shift_id" value="">
<div class="form-body">
<div class="daily_stl_top_box">
<div class="filter_area">
<div class="row">
<div class="col-md-3">
<div class="form-group">
<label>Select Driver</label>
<div class="input-group">
<select id="driver_id" name="driver_id" class="js-select2" data-show-subtext="true" data-live-search="true" required>
<option value="">Select Driver</option>
<?php if (!empty($driver_list)) : ?>
<?php foreach ($driver_list as $list) : ?>
<?php if (!empty($list['middle_name'])) : ?>
<?php $middle = $list['middle_name'] . ' '; ?>
<?php else : ?>
<?php $middle = ''; ?>
<?php endif; ?>
<option value="<?php echo $list['user_id']; ?>"><?php echo $list['first_name'] . ' ' . $middle . $list['last_name'] . ' - ' . $list['dc_no']; ?></option>
<?php endforeach; ?>
<?php endif; ?>
</select>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<div id="bulk_settlement_div" class="col-md-12"></div>
</div>
<div id="payment_mode_div" class="table_row repeat" style="display:none;">
<h4 class="cash_summary">
<strong><span id="payment_collection_div"> Payment Mode : </span></strong>
<strong style="float: right;">$<span style="float: right;" id="final_due_amount">0.00</span></strong>
</h4>
<input type="hidden" id="final_due_amount_hid" name="final_due_amount_hid" value="0">
<div class="table-responsive custom_table_area">
<table class="table table-striped table-bordered daily_stl_table">
<tbody>
<?php if (!empty($payment_options)) : ?>
<?php foreach ($payment_options as $payopn) : ?>
<tr>
<td style="width: 50%;"><?php echo $payopn['payment_method'] ?></td>
<td>
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text" id="basic-addon1">$</span>
</div>
<input type="text" id="<?php echo $payopn['payment_method_id'] ?>" class="form-control payment_opn decimal_positive_cls" readonly>
</div>
</td>
</tr>
<?php endforeach; ?>
<?php endif; ?>
<tr>
<td style="width: 50%;color: #000;font-weight: 800;"><strong>Accumulate</strong></td>
<td>
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text" id="basic-addon1">$</span>
</div>
<input type="text" id="admin_total_payment" name="admin_total_payment" class="form-control" value="" readonly>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<!-- Denomination -->
<div id="denomination_div" class="table_row repeat" style="display:none;">
<div class="daily_stl_top_box">
<h4 class="cash_summary">Denominations</h4>
<div class="table-responsive custom_table_area">
<table class="table table-striped table-bordered daily_stl_table">
<thead>
<tr>
<th width="10%">Notes</th>
<th width="10%">Qty</th>
<th width="20%">Amount</th>
<th width="10%">Adjustment Qty</th>
<th width="20%">Amount</th>
<th width="30%">Final Amount</th>
</tr>
</thead>
<tbody>
<tr style="display:none;">
<td>1c Coins</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="1c_coins_qty" id="1c_coins_qty" data-dollar_price=".01">
<input type="hidden" id="1c_coins_amt" name="1c_coins_amt">
</td>
<td class="dollar_amount"></td>
</tr>
<tr>
<td>5c Coins</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="5c_coins_qty" id="5c_coins_qty" data-dollar_price=".05" data-balance_qty="<?=(isset($cash_in_data['5c_coins_qty']) || isset($cash_out_data['5c_coins_qty']))?($cash_in_data['5c_coins_qty'] - $cash_out_data['5c_coins_qty']) : 0?>">
<input type="hidden" id="5c_coins_amt" name="5c_coins_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="5c_coins_qty_adjust" id="5c_coins_qty_adjust" data-dollar_price=".05" data-balance_qty="<?=(isset($cash_in_data['5c_coins_qty']) || isset($cash_out_data['5c_coins_qty']))?($cash_in_data['5c_coins_qty'] - $cash_out_data['5c_coins_qty']) : 0?>">
<input type="hidden" id="5c_coins_amt_adjust" name="5c_coins_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>10c Coins</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="10c_coins_qty" id="10c_coins_qty" data-dollar_price=".10" data-balance_qty="<?=(isset($cash_in_data['10c_coins_qty']) || isset($cash_out_data['10c_coins_qty']))?($cash_in_data['10c_coins_qty'] - $cash_out_data['10c_coins_qty']) : 0?>">
<input type="hidden" id="10c_coins_amt" name="10c_coins_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="10c_coins_qty_adjust" id="10c_coins_qty_adjust" data-dollar_price=".10" data-balance_qty="<?=(isset($cash_in_data['10c_coins_qty']) || isset($cash_out_data['10c_coins_qty']))?($cash_in_data['10c_coins_qty'] - $cash_out_data['10c_coins_qty']) : 0?>">
<input type="hidden" id="10c_coins_amt_adjust" name="10c_coins_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>20c Coins</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="20c_coins_qty" id="20c_coins_qty" data-dollar_price=".20" data-balance_qty="<?=(isset($cash_in_data['20c_coins_qty']) || isset($cash_out_data['20c_coins_qty']))?($cash_in_data['20c_coins_qty'] - $cash_out_data['20c_coins_qty']) : 0?>">
<input type="hidden" id="20c_coins_amt" name="20c_coins_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="20c_coins_qty_adjust" id="20c_coins_qty_adjust" data-dollar_price=".20" data-balance_qty="<?=(isset($cash_in_data['20c_coins_qty']) || isset($cash_out_data['20c_coins_qty']))?($cash_in_data['20c_coins_qty'] - $cash_out_data['20c_coins_qty']) : 0?>">
<input type="hidden" id="20c_coins_amt_adjust" name="20c_coins_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>50c Coins</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="50c_coins_qty" id="50c_coins_qty" data-dollar_price=".50" data-balance_qty="<?=(isset($cash_in_data['50c_coins_qty']) || isset($cash_out_data['50c_coins_qty']))?($cash_in_data['50c_coins_qty'] - $cash_out_data['50c_coins_qty']) : 0?>">
<input type="hidden" id="50c_coins_amt" name="50c_coins_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="50c_coins_qty_adjust" id="50c_coins_qty_adjust" data-dollar_price=".50" data-balance_qty="<?=(isset($cash_in_data['50c_coins_qty']) || isset($cash_out_data['50c_coins_qty']))?($cash_in_data['50c_coins_qty'] - $cash_out_data['50c_coins_qty']) : 0?>">
<input type="hidden" id="50c_coins_amt_adjust" name="50c_coins_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>1$ Coins</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="1d_coins_qty" id="1d_coins_qty" data-dollar_price="1" data-balance_qty="<?=(isset($cash_in_data['1d_coins_qty']) || isset($cash_out_data['1d_coins_qty']))?($cash_in_data['1d_coins_qty'] - $cash_out_data['1d_coins_qty']) : 0?>">
<input type="hidden" id="1d_coins_amt" name="1d_coins_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="1d_coins_qty_adjust" id="1d_coins_qty_adjust" data-dollar_price="1" data-balance_qty="<?=(isset($cash_in_data['1d_coins_qty']) || isset($cash_out_data['1d_coins_qty']))?($cash_in_data['1d_coins_qty'] - $cash_out_data['1d_coins_qty']) : 0?>">
<input type="hidden" id="1d_coins_amt_adjust" name="1d_coins_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>2$ Coins</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="2d_coins_qty" id="2d_coins_qty" data-dollar_price="2" data-balance_qty="<?=(isset($cash_in_data['2d_coins_qty']) || isset($cash_out_data['2d_coins_qty']))?($cash_in_data['2d_coins_qty'] - $cash_out_data['2d_coins_qty']) : 0?>">
<input type="hidden" id="2d_coins_amt" name="2d_coins_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="2d_coins_qty_adjust" id="2d_coins_qty_adjust" data-dollar_price="2" data-balance_qty="<?=(isset($cash_in_data['2d_coins_qty']) || isset($cash_out_data['2d_coins_qty']))?($cash_in_data['2d_coins_qty'] - $cash_out_data['2d_coins_qty']) : 0?>">
<input type="hidden" id="2d_coins_amt_adjust" name="2d_coins_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>5$ Notes</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="5d_notes_qty" id="5d_notes_qty" data-dollar_price="5" data-balance_qty="<?=(isset($cash_in_data['5d_notes_qty']) || isset($cash_out_data['5d_notes_qty']))?($cash_in_data['5d_notes_qty'] - $cash_out_data['5d_notes_qty']) : 0?>">
<input type="hidden" id="5d_notes_amt" name="5d_notes_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="5d_notes_qty_adjust" id="5d_notes_qty_adjust" data-dollar_price="5" data-balance_qty="<?=(isset($cash_in_data['5d_notes_qty']) || isset($cash_out_data['5d_notes_qty']))?($cash_in_data['5d_notes_qty'] - $cash_out_data['5d_notes_qty']) : 0?>">
<input type="hidden" id="5d_notes_amt_adjust" name="5d_notes_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>10$ Notes</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="10d_notes_qty" id="10d_notes_qty" data-dollar_price="10" data-balance_qty="<?=(isset($cash_in_data['10d_notes_qty']) || isset($cash_out_data['10d_notes_qty']))?($cash_in_data['10d_notes_qty'] - $cash_out_data['10d_notes_qty']) : 0?>">
<input type="hidden" id="10d_notes_amt" name="10d_notes_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="10d_notes_qty_adjust" id="10d_notes_qty_adjust" data-dollar_price="10" data-balance_qty="<?=(isset($cash_in_data['10d_notes_qty']) || isset($cash_out_data['10d_notes_qty']))?($cash_in_data['10d_notes_qty'] - $cash_out_data['10d_notes_qty']) : 0?>">
<input type="hidden" id="10d_notes_amt_adjust" name="10d_notes_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>20$ Notes</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="20d_notes_qty" id="20d_notes_qty" data-dollar_price="20" data-balance_qty="<?=(isset($cash_in_data['20d_notes_qty']) || isset($cash_out_data['20d_notes_qty']))?($cash_in_data['20d_notes_qty'] - $cash_out_data['20d_notes_qty']) : 0?>">
<input type="hidden" id="20d_notes_amt" name="20d_notes_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="20d_notes_qty_adjust" id="20d_notes_qty_adjust" data-dollar_price="20" data-balance_qty="<?=(isset($cash_in_data['20d_notes_qty']) || isset($cash_out_data['20d_notes_qty']))?($cash_in_data['20d_notes_qty'] - $cash_out_data['20d_notes_qty']) : 0?>">
<input type="hidden" id="20d_notes_amt_adjust" name="20d_notes_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>50$ Notes</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="50d_notes_qty" id="50d_notes_qty" data-dollar_price="50" data-balance_qty="<?=(isset($cash_in_data['50d_notes_qty']) || isset($cash_out_data['50d_notes_qty']))?($cash_in_data['50d_notes_qty'] - $cash_out_data['50d_notes_qty']) : 0?>">
<input type="hidden" id="50d_notes_amt" name="50d_notes_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="50d_notes_qty_adjust" id="50d_notes_qty_adjust" data-dollar_price="50" data-balance_qty="<?=(isset($cash_in_data['50d_notes_qty']) || isset($cash_out_data['50d_notes_qty']))?($cash_in_data['50d_notes_qty'] - $cash_out_data['50d_notes_qty']) : 0?>">
<input type="hidden" id="50d_notes_amt_adjust" name="50d_notes_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
<tr>
<td>100$ Notes</td>
<td>
<input type="text" class="form-control calculate_amt num_validation_cls" name="100d_notes_qty" id="100d_notes_qty" data-dollar_price="100" data-balance_qty="<?=(isset($cash_in_data['100d_notes_qty']) || isset($cash_out_data['100d_notes_qty']))?($cash_in_data['100d_notes_qty'] - $cash_out_data['100d_notes_qty']) : 0?>">
<input type="hidden" id="100d_notes_amt" name="100d_notes_amt">
</td>
<td class="dollar_amount"></td>
<td>
<input type="text" class="form-control calculate_amt_adjust num_validation_cls" name="100d_notes_qty_adjust" id="100d_notes_qty_adjust" data-dollar_price="100" data-balance_qty="<?=(isset($cash_in_data['100d_notes_qty']) || isset($cash_out_data['100d_notes_qty']))?($cash_in_data['100d_notes_qty'] - $cash_out_data['100d_notes_qty']) : 0?>">
<input type="hidden" id="100d_notes_amt_adjust" name="100d_notes_amt_adjust">
</td>
<td class="dollar_amount_adjust"></td>
<td class="final_amount"></td>
</tr>
</tbody>
<tfoot>
<tr>
<td colspan="2" style="text-align:left;"><strong>TOTAL</strong></td>
<td><strong class="total_amount"></strong></td>
<td colspan="2"><strong class="total_amount_adjust"></strong></td>
<td><strong class="total_final_amount"></strong></td>
<input type="hidden" id="total_amount_cash" name="total_amount_cash">
<input type="hidden" id="total_amount" name="total_amount">
<input type="hidden" id="total_amount_adjust" name="total_amount_adjust">
</tr>
</tfoot>
</table>
</div>
</div>
</div>
<!-- END -->
<div id="submit_bulk_settlement_div" class="form-actions" style="display:none; text-align:center;">
<button type="button" id="submit_bulk_settlement" class="btn btn-success">
<i class="fa fa-floppy-o" aria-hidden="true"></i> Submit
</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- // Basic form layout section end -->
</div>
</div>
</div>
<script>
$(document).ready(function() {
$(".js-select2").select2();
$(".decimal_validation_cls").inputFilter(function(value) {
return /^-?\d*[.]?\d*$/.test(value);
});
$(".num_validation_cls").inputFilter(function(value) {
return /^\d*$/.test(value);
});
})
$(document).on('change', '#driver_id', function() {
search_bulk_settlement();
});
function search_bulk_settlement() {
var driver_id = $("#driver_id").val();
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/DriverSettlement/ajaxDriverShiftDetailsBulk') ?>',
data: {
driver_id: driver_id,
},
dataType: 'JSON',
async: false,
success: function(response) {
console.log(response);
if (response['html'] != '') {
$("#bulk_settlement_div").html(response['html']);
$(".decimal_positive_cls").inputFilter(function(value) {
return /^\d*[.]?\d*$/.test(value);
});
}
},
error: function(response) {
$.alert({
type: 'red',
title: 'Alert!',
content: 'error',
});
}
});
}
$(document).on('click', '.bulk_settlement_chkbox', function() {
if ($(this).prop("checked") == false){
$(this).parents('tr').find('.bulk_settlement_amount').val('');
$(this).parents('tr').find('.bulk_settlement_credit_card').val('');
$(this).parents('tr').find('.bulk_settlement_bank_transfer').val('');
$(this).parents('tr').find('.bulk_settlement_cash').val('');
$(this).parents('tr').find('.bulk_settlement_amount').attr('readonly',false);
$(this).parents('tr').find('.bulk_settlement_credit_card').attr('readonly',false);
$(this).parents('tr').find('.bulk_settlement_bank_transfer').attr('readonly',false);
$(this).parents('tr').find('.bulk_settlement_cash').attr('readonly',false);
}
var bulk_settlement_amount = $(this).parents('tr').find('.bulk_settlement_amount').val();
var bulk_settlement_credit_card_amount = $(this).parents('tr').find('.bulk_settlement_credit_card').val();
var bulk_settlement_bank_transfer_amount = $(this).parents('tr').find('.bulk_settlement_bank_transfer').val();
var bulk_settlement_cash_amount = $(this).parents('tr').find('.bulk_settlement_cash').val();
var bulk_settlement_ts = $(this).data('bulk_settlement_ts');
var validation_check = true;
$('.bulk_settlement_chkbox:checked').each(function() {
if(bulk_settlement_ts != $(this).data('bulk_settlement_ts')){
validation_check = false;
}
})
if ($(this).prop("checked") == true && !validation_check) {
$.alert({
type: 'red',
title: 'Alert!',
content: 'Please select settlement from only one group',
});
return false;
}
else if ($(this).prop("checked") == true && Number(bulk_settlement_amount) == 0) {
$.alert({
type: 'red',
title: 'Alert!',
content: 'Please enter payment amount',
});
return false;
}
else if(Number(bulk_settlement_amount) != (Number(bulk_settlement_credit_card_amount) + Number(bulk_settlement_bank_transfer_amount) + Number(bulk_settlement_cash_amount))){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Settlement amount not equals to sum of crdit card & bank transfer & cash amount',
});
return false;
}else{
if ($(this).prop("checked") == true){
$(this).parents('tr').find('.bulk_settlement_amount').attr('readonly',true);
$(this).parents('tr').find('.bulk_settlement_credit_card').attr('readonly',true);
$(this).parents('tr').find('.bulk_settlement_bank_transfer').attr('readonly',true);
$(this).parents('tr').find('.bulk_settlement_cash').attr('readonly',true);
}
}
calculate_total();
})
function calculate_total(){
var total_amount = 0 * 1;
var total_credit_card_amount = 0 * 1;
var total_bank_transfer_amount = 0 * 1;
var total_cash_amount = 0 * 1;
var total_amount_sign = 0 * 1;
$('.bulk_settlement_chkbox').each(function() {
if ($(this).prop("checked") == true) {
total_amount += Number((($(this).val() < 0)?'-':'') + $(this).parents('tr').find('.bulk_settlement_amount').val());
total_credit_card_amount += ($(this).parents('tr').find('.bulk_settlement_credit_card').val())? Number((($(this).val() < 0)?'-':'') + $(this).parents('tr').find('.bulk_settlement_credit_card').val()):Number(0);
total_bank_transfer_amount += ($(this).parents('tr').find('.bulk_settlement_bank_transfer').val())? Number((($(this).val() < 0)?'-':'') + $(this).parents('tr').find('.bulk_settlement_bank_transfer').val()):Number(0);
total_cash_amount += ($(this).parents('tr').find('.bulk_settlement_cash').val())? Number((($(this).val() < 0)?'-':'') + $(this).parents('tr').find('.bulk_settlement_cash').val()):Number(0);
}
})
//alert(total_credit_card_amount);
$("#total_amount").text(parseFloat(Number(total_amount)).toFixed(2));
$("#total_credit_card_amount").text(parseFloat(Number(total_credit_card_amount)).toFixed(2));
$("#total_bank_transfer_amount").text(parseFloat(Number(total_bank_transfer_amount)).toFixed(2));
$("#total_cash_amount").text(parseFloat(Number(total_cash_amount)).toFixed(2));
$(".payment_opn#1").val(parseFloat(Number(Math.abs(total_credit_card_amount))).toFixed(2));
$(".payment_opn#2").val(parseFloat(Number(Math.abs(total_bank_transfer_amount))).toFixed(2));
$(".payment_opn#3").val(parseFloat(Number(Math.abs(total_cash_amount))).toFixed(2));
$("#admin_total_payment").val(parseFloat(Number(Math.abs(total_amount))).toFixed(2));
if (total_amount > 0) {
$("#payment_collection_div").text('Payment Collection Mode');
} else {
$("#payment_collection_div").text('Payment Mode');
}
$("#final_due_amount").text(parseFloat(Number(total_amount)).toFixed(2));
$("#final_due_amount_hid").val(parseFloat(Number(total_amount)).toFixed(2));
if(total_amount){
$("#payment_mode_div").show();
$("#submit_bulk_settlement_div").show();
} else {
$("#payment_mode_div").hide();
$("#submit_bulk_settlement_div").hide();
}
//alert(Number(Math.abs(total_cash_amount)));
if(Number(Math.abs(total_cash_amount)) > 0){
$("#denomination_div").show();
} else {
$("#denomination_div").hide();
}
}
$(document).on('keyup','.payment_opn',function(){
var accumulate_amount = 0;
var payment_opn = $("input.payment_opn");
var payment_opn_arr = $.map(payment_opn, function(element) {
return element.value;
});
$.each(payment_opn_arr,function(){
accumulate_amount +=parseFloat(this) || 0;
});
// if(Math.abs(Number($("#final_due_amount_hid").val())) < Math.abs(Number(accumulate_amount))){
// $.alert({
// type: 'red',
// title: 'Alert!',
// content: 'Total due amount should be equal to total payment amount',
// });
// $(this).val(0);
// return false;
// }
$("#admin_total_payment").val(parseFloat(accumulate_amount).toFixed(2));
if(this.id==3){
var cash_amt=$(this).val();
if(cash_amt > 0){
$("#denomination_div").show();
} else {
$("#denomination_div").hide();
}
}
});
$(document).on('click','#submit_bulk_settlement',function(){
var values = $("input.payment_opn");
var payment_opn_arr = $.map(values, function(element) {
return element.value;
});
var bulk_settlement_ts = $('.bulk_settlement_chkbox:checked:first').data('bulk_settlement_ts');
//alert(bulk_settlement_ts);
var validation_check = true;
$('.bulk_settlement_chkbox:checked').each(function() {
if ($(this).data("bulk_settlement_ts") != bulk_settlement_ts) {
validation_check = false;
}
})
if(!validation_check){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Please check all the checkbox of same group',
});
return false;
}
if(Math.abs(Number($("#final_due_amount_hid").val())) != Math.abs(Number($("#admin_total_payment").val()))){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Total due amount should be equal to total payment amount',
});
return false;
}
var credit_card_amt = payment_opn_arr[0];
var bank_transfer_amt = payment_opn_arr[1];
var cash_amt = payment_opn_arr[2];
var admin_total_payment = $("#admin_total_payment").val();
var final_due_amount = $("#final_due_amount_hid").val();
var total = $("#final_due_amount_hid").val();
var total_amount_cash = $("#total_amount_cash").val();
if(admin_total_payment == ''){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Please enter payment amount',
});
return false;
}
else if((Math.abs(Number(total)) != Math.abs(Number(admin_total_payment)))){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Accumulate amount & amount due should be same',
});
return false;
}
else if((cash_amt > 0 && Math.abs(Number(cash_amt)) !=Math.abs(Number(total_amount_cash)))){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Denomination total not matching with cash total',
});
return false;
}
else if((cash_amt > 0 && Math.abs(Number(cash_amt)) !=Math.abs(Number(total_amount_cash)))){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Denomination total not matching with cash total',
});
return false;
}
else{
$("#submit_bulk_settlement").attr('disabled',true);
dr_settlement_id = [];
bulk_settlement_amount = [];
bulk_settlement_credit_card = [];
bulk_settlement_bank_transfer = [];
bulk_settlement_cash = [];
$('.bulk_settlement_chkbox').each(function() {
if ($(this).prop("checked") == true) {
dr_settlement_id.push($(this).data('dr_settlement_id'));
bulk_settlement_amount.push($(this).parents('tr').find('.bulk_settlement_amount').val());
bulk_settlement_credit_card.push($(this).parents('tr').find('.bulk_settlement_credit_card').val());
bulk_settlement_bank_transfer.push($(this).parents('tr').find('.bulk_settlement_bank_transfer').val());
bulk_settlement_cash.push($(this).parents('tr').find('.bulk_settlement_cash').val());
}
})
var c_1_coins_qty = $("#1c_coins_qty").val();
var c_1_coins_amt = $("#1c_coins_amt").val();
var c_5_coins_qty = $("#5c_coins_qty").val();
var c_5_coins_amt = $("#5c_coins_amt").val();
var c_10_coins_qty = $("#10c_coins_qty").val();
var c_10_coins_amt = $("#10c_coins_amt").val();
var c_20_coins_qty = $("#20c_coins_qty").val();
var c_20_coins_amt = $("#20c_coins_amt").val();
var c_50_coins_qty = $("#50c_coins_qty").val();
var c_50_coins_amt = $("#50c_coins_amt").val();
var d_1_coins_qty = $("#1d_coins_qty").val();
var d_1_coins_amt = $("#1d_coins_amt").val();
var d_2_coins_qty = $("#2d_coins_qty").val();
var d_2_coins_amt = $("#2d_coins_amt").val();
var d_5_notes_qty = $("#5d_notes_qty").val();
var d_5_notes_amt = $("#5d_notes_amt").val();
var d_10_notes_qty = $("#10d_notes_qty").val();
var d_10_notes_amt = $("#10d_notes_amt").val();
var d_20_notes_qty = $("#20d_notes_qty").val();
var d_20_notes_amt = $("#20d_notes_amt").val();
var d_50_notes_qty = $("#50d_notes_qty").val();
var d_50_notes_amt = $("#50d_notes_amt").val();
var d_100_notes_qty = $("#100d_notes_qty").val();
var d_100_notes_amt = $("#100d_notes_amt").val();
var c_1_coins_qty_adjust = $("#1c_coins_qty_adjust").val();
var c_1_coins_amt_adjust = $("#1c_coins_amt_adjust").val();
var c_5_coins_qty_adjust = $("#5c_coins_qty_adjust").val();
var c_5_coins_amt_adjust = $("#5c_coins_amt_adjust").val();
var c_10_coins_qty_adjust = $("#10c_coins_qty_adjust").val();
var c_10_coins_amt_adjust = $("#10c_coins_amt_adjust").val();
var c_20_coins_qty_adjust = $("#20c_coins_qty_adjust").val();
var c_20_coins_amt_adjust = $("#20c_coins_amt_adjust").val();
var c_50_coins_qty_adjust = $("#50c_coins_qty_adjust").val();
var c_50_coins_amt_adjust = $("#50c_coins_amt_adjust").val();
var d_1_coins_qty_adjust = $("#1d_coins_qty_adjust").val();
var d_1_coins_amt_adjust = $("#1d_coins_amt_adjust").val();
var d_2_coins_qty_adjust = $("#2d_coins_qty_adjust").val();
var d_2_coins_amt_adjust = $("#2d_coins_amt_adjust").val();
var d_5_notes_qty_adjust = $("#5d_notes_qty_adjust").val();
var d_5_notes_amt_adjust = $("#5d_notes_amt_adjust").val();
var d_10_notes_qty_adjust = $("#10d_notes_qty_adjust").val();
var d_10_notes_amt_adjust = $("#10d_notes_amt_adjust").val();
var d_20_notes_qty_adjust = $("#20d_notes_qty_adjust").val();
var d_20_notes_amt_adjust = $("#20d_notes_amt_adjust").val();
var d_50_notes_qty_adjust = $("#50d_notes_qty_adjust").val();
var d_50_notes_amt_adjust = $("#50d_notes_amt_adjust").val();
var d_100_notes_qty_adjust = $("#100d_notes_qty_adjust").val();
var d_100_notes_amt_adjust = $("#100d_notes_amt_adjust").val();
var total_amount_cash = $("#total_amount_cash").val();
var total_amount = $("#total_amount").val();
var total_amount_adjust = $("#total_amount_adjust").val();
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/DriverSettlement/BulkDriverSettlement')?>',
data:{
"credit_card_amt":credit_card_amt,"bank_transfer_amt":bank_transfer_amt,"cash_amt":cash_amt,
"1c_coins_qty":c_1_coins_qty,"1c_coins_amt":c_1_coins_amt,
"5c_coins_qty":c_5_coins_qty,"5c_coins_amt":c_5_coins_amt,"10c_coins_qty":c_10_coins_qty,"10c_coins_amt":c_10_coins_amt,"20c_coins_qty":c_20_coins_qty,"20c_coins_amt":c_20_coins_amt,"50c_coins_qty":c_50_coins_qty,"50c_coins_amt":c_50_coins_amt,"1d_coins_qty":d_1_coins_qty,"1d_coins_amt":d_1_coins_amt,"2d_coins_qty":d_2_coins_qty,"2d_coins_amt":d_2_coins_amt,"5d_notes_qty":d_5_notes_qty,"5d_notes_amt":d_5_notes_amt,"10d_notes_qty":d_10_notes_qty,"10d_notes_amt":d_10_notes_amt,"20d_notes_qty":d_20_notes_qty,"20d_notes_amt":d_20_notes_amt,"50d_notes_qty":d_50_notes_qty,"50d_notes_amt":d_50_notes_amt,"100d_notes_qty":d_100_notes_qty,"100d_notes_amt":d_100_notes_amt,
"1c_coins_qty_adjust":c_1_coins_qty_adjust,"1c_coins_amt_adjust":c_1_coins_amt_adjust,
"5c_coins_qty_adjust":c_5_coins_qty_adjust,"5c_coins_amt_adjust":c_5_coins_amt_adjust,"10c_coins_qty_adjust":c_10_coins_qty_adjust,"10c_coins_amt_adjust":c_10_coins_amt_adjust,"20c_coins_qty_adjust":c_20_coins_qty_adjust,"20c_coins_amt_adjust":c_20_coins_amt_adjust,"50c_coins_qty_adjust":c_50_coins_qty_adjust,"50c_coins_amt_adjust":c_50_coins_amt_adjust,"1d_coins_qty_adjust":d_1_coins_qty_adjust,"1d_coins_amt_adjust":d_1_coins_amt_adjust,"2d_coins_qty_adjust":d_2_coins_qty_adjust,"2d_coins_amt_adjust":d_2_coins_amt_adjust,"5d_notes_qty_adjust":d_5_notes_qty_adjust,"5d_notes_amt_adjust":d_5_notes_amt_adjust,"10d_notes_qty_adjust":d_10_notes_qty_adjust,"10d_notes_amt_adjust":d_10_notes_amt_adjust,"20d_notes_qty_adjust":d_20_notes_qty_adjust,"20d_notes_amt_adjust":d_20_notes_amt_adjust,"50d_notes_qty_adjust":d_50_notes_qty_adjust,"50d_notes_amt_adjust":d_50_notes_amt_adjust,"100d_notes_qty_adjust":d_100_notes_qty_adjust,"100d_notes_amt_adjust":d_100_notes_amt_adjust,
"total_amount":total_amount,"total_amount_adjust":total_amount_adjust,
"total_amount_cash":total_amount_cash,"dr_settlement_id":dr_settlement_id,"final_due_amount":final_due_amount,"bulk_settlement_amount":bulk_settlement_amount,"bulk_settlement_credit_card":bulk_settlement_credit_card,
"bulk_settlement_bank_transfer":bulk_settlement_bank_transfer,"bulk_settlement_cash":bulk_settlement_cash
},
dataType:'html',
success: function(response){
if(response =='success'){
$.alert({
type: 'green',
title: 'Success',
content: 'Bulk settlement done Successfully',
buttons: {
OK: function () {
location.reload();
},
}
});
}
},
error:function(response){
$("#submit_bulk_settlement").attr('disabled',false);
$.alert({
type: 'red',
title: 'Alert!',
content: 'error',
});
}
});
}
});
$(document).on('keyup','.calculate_amt',function(){
var qty = $(this).val();
var dollar_price = $(this).data('dollar_price');
var balance_qty = $(this).data('balance_qty');
var final_due_amount_hid = $("#final_due_amount_hid").val();
// alert(Number(qty));
// alert(Number(balance_qty));
if((Number(final_due_amount_hid) < 0) && (Number(qty) > Number(balance_qty))){
$.alert({
type: 'red',
title: 'Denomination Not Available',
content: 'Denomination not available in your cashbox.please add denomination in cash In',
});
$(this).val(0);
}
qty = $(this).val();
var amount = parseFloat(Number(qty) * Number(dollar_price)).toFixed(2);
var total_amount_adjust = parseFloat(Number($(this).parents('tr').find('.dollar_amount_adjust').text())).toFixed(2);
var final_amount = parseFloat(amount - total_amount_adjust).toFixed(2);;
$(this).next('input[type=hidden]').val(amount);
$(this).parents('tr').find('.dollar_amount').html(amount);
$(this).parents('tr').find('.final_amount').html(final_amount);
calculate_total_cash($(this));
})
$(document).on('keyup','.calculate_amt_adjust',function(){
var qty = $(this).val();
var dollar_price = $(this).data('dollar_price');
var balance_qty = $(this).data('balance_qty');
var final_due_amount_hid = $("#final_due_amount_hid").val();
// alert(Number(qty));
// alert(Number(balance_qty));
if((Number(final_due_amount_hid) > 0) && (Number(qty) > Number(balance_qty))){
$.alert({
type: 'red',
title: 'Denomination Not Available',
content: 'Denomination not available in your cashbox.please add denomination in cash In',
});
$(this).val(0);
}
qty = $(this).val();
var amount = parseFloat(Number(qty) * Number(dollar_price)).toFixed(2);
var total_amount = parseFloat(Number($(this).parents('tr').find('.dollar_amount').text())).toFixed(2);
var final_amount = parseFloat(total_amount - amount).toFixed(2);;
$(this).next('input[type=hidden]').val(amount);
$(this).parents('tr').find('.dollar_amount_adjust').html(amount);
$(this).parents('tr').find('.final_amount').html(final_amount);
calculate_total_cash($(this));
})
function calculate_total_cash(this_obj){
var total_cash_amount=$("#3").val();
var total_amount =0 * 1;
var total_amount_adjust =0 * 1;
$('.dollar_amount').each(function(){
total_amount +=Number($(this).text());
})
$('.dollar_amount_adjust').each(function(){
total_amount_adjust +=Number($(this).text());
})
var final_amount = total_amount - total_amount_adjust;
// if(Math.abs(total_cash_amount) < Math.abs(final_amount)){
// $.alert({
// type: 'red',
// title: 'Alert!',
// content: 'Cash amount not matched with denominations total',
// });
// this_obj.val('');
// this_obj.next('input[type=hidden]').val('');
// this_obj.parent().parent().children('.dollar_amount').html('');
// }else{
$(".total_amount").text(parseFloat(total_amount).toFixed(2));
$(".total_amount_adjust").text(parseFloat(total_amount_adjust).toFixed(2));
$(".total_final_amount").text(parseFloat(final_amount).toFixed(2));
$("#total_amount").val(parseFloat(total_amount).toFixed(2));
$("#total_amount_adjust").val(parseFloat(total_amount_adjust).toFixed(2));
$("#total_amount_cash").val(parseFloat(final_amount).toFixed(2));
//}
}
$(document).on('keyup','.bulk_settlement_amount',function(){
var total_due_amount = $(this).parents('tr').find('.bulk_settlement_chkbox').val();
var bulk_settlement_amount = $(this).val();
if(Math.abs(Number(total_due_amount)) < Math.abs(Number(bulk_settlement_amount))){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Payment amount should not greater than due amount',
});
$(this).val('');
$(this).parents('tr').find('.bulk_settlement_chkbox').prop('checked',false);
} else if(Math.abs(Number(bulk_settlement_amount)) == 0){
$(this).parents('tr').find('.bulk_settlement_chkbox').prop('checked',false);
}
calculate_total();
})
$(document).on('keyup','.bulk_settlement_credit_card,.bulk_settlement_bank_transfer,.bulk_settlement_cash',function(){
calculate_total();
})
</script>