File: /var/www/html/taxicamera/application/views/admin/driver_refund_settlement/settle.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">Settle</h4>
</div>
</div>
<div class="card-body">
<div class="px-3">
<form class="form custom_form_style" action="<?php echo base_url() . 'admin/DriverRefundSettlement/settleRefund' ?>" method="post">
<div class="form-body">
<div class="cust_from_area">
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Driver *</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="form-group">
<?php $name = '';
if (!empty($driver_refund_settlement) && $driver_refund_settlement['first_name'] && $driver_refund_settlement['dc_no']) :
if ($driver_refund_settlement['middle_name']) :
$middle_name = '';
$middle_name . ' ';
else :
$middle_name = '';
endif;
$name = $driver_refund_settlement['first_name'] . ' ' . $middle_name . $driver_refund_settlement['last_name'] . ' - ' . $driver_refund_settlement['dc_no'];
endif;
?>
<input type="text" class="form-control" disabled value="<?php echo $name; ?>">
</div>
</div>
</div>
</div>
</div>
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Bank Account Details (Bank - Acc No. - BSB) *</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="form-group">
<?php $bank_details = '';
if (!empty($driver_refund_settlement)) :
$bank_details .= $driver_refund_settlement['bank_name'].' - '.$driver_refund_settlement['account_no'] .' - '.$driver_refund_settlement['bsb'];
endif;
?>
<input type="text" class="form-control" disabled value="<?php echo $bank_details; ?>">
</div>
</div>
</div>
</div>
</div>
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Total Bond Amount *</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text">$</span>
</div>
<?php $bond_amt = '';
if (!empty($driver_refund_settlement) && $driver_refund_settlement['bond_amt']) :
$bond_amt = $driver_refund_settlement['bond_amt'];
endif;
?>
<input type="text" class="form-control" value="<?php echo $bond_amt; ?>" style="height:38px" readonly>
</div>
</div>
</div>
</div>
</div>
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Bond Refund Remaining *</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text">$</span>
</div>
<?php $bond_accumulated_amt = '';
if (!empty($driver_refund_settlement) && $driver_refund_settlement['bond_accumulated_amt']) :
$bond_accumulated_amt = $driver_refund_settlement['bond_accumulated_amt'];
endif;
?>
<input type="text" class="form-control" value="<?php echo $bond_accumulated_amt; ?>" id="bond_accumulated_amt" name="bond_accumulated_amt" style="height:38px" readonly>
</div>
</div>
</div>
</div>
</div>
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Refund Type</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="form-group">
<?php $refund_type = '';
if (!empty($driver_refund_settlement) && $driver_refund_settlement['refund_type']) :
$refund_type = $driver_refund_settlement['refund_type'];
endif;
?>
<input type="text" class="form-control" value="<?php echo UCfirst($refund_type); ?>">
</div>
</div>
</div>
</div>
</div>
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Refund Amount *</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text">$</span>
</div>
<?php $refund_amt = '';
if (!empty($driver_refund_settlement) && $driver_refund_settlement['refund_amt']) :
$refund_amt = $driver_refund_settlement['refund_amt'];
endif;
?>
<input type="number" min="1" step=".01" class="form-control" value="<?php echo $refund_amt; ?>" id="refund_amt" name="refund_amt" style="height:38px" required>
</div>
</div>
</div>
</div>
</div>
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Notice Date *</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="form-group">
<div class="input-group">
<?php $notice_dt = '';
if (!empty($driver_refund_settlement) && $driver_refund_settlement['notice_dt']) :
$notice_dt = $driver_refund_settlement['notice_dt'];
endif;
?>
<input type="text" class="form-control pickadate" id="notice_date" value="<?php echo $notice_dt; ?>" placeholder="D/M/YYYY" required/>
<div class="input-group-append">
<span class="input-group-text">
<span class="fa fa-calendar-o"></span>
</span>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Bond Refund Due Date *</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="form-group">
<div class="input-group">
<?php $bond_refund_due_dt = '';
if (!empty($driver_refund_settlement) && $driver_refund_settlement['bond_refund_due_dt']) :
$bond_refund_due_dt = $driver_refund_settlement['bond_refund_due_dt'];
endif;
?>
<input type="text" id="bond_refund_due_dt" class="form-control pickadate" value="<?php echo date('d/m/Y', strtotime($bond_refund_due_dt)); ?>" placeholder="D/M/YYYY" required/>
<div class="input-group-append">
<span class="input-group-text">
<span class="fa fa-calendar-o"></span>
</span>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="table_row">
<div class="row">
<div class="col-sm-5">
<div class="form_box">
<label>Payment Method *</label>
</div>
</div>
<div class="col-sm-7">
<div class="form_box">
<div class="form-group">
<select id="payment_method" name="payment_method" class="form-control" required>
<option value="">Select Payment Method</option>
<?php if ($payment_method_data) :
foreach ($payment_method_data as $list) : ?>
<option value="<?php echo $list['payment_method_id']; ?>"><?php echo $list['payment_method']; ?></option>
<?php endforeach; ?>
<?php endif; ?>
</select>
</div>
</div>
</div>
</div>
</div>
<!-- Denomination -->
<div id="denomination_div" class="table_row" 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="20%">Notes</th>
<th width="30%">Qty</th>
<th width="50%">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>
</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>
</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>
</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>
</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>
</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>
</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>
</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>
</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>
</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>
</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>
</tr>
</tbody>
<tfoot>
<tr>
<td colspan="2"><strong>TOTAL</strong></td>
<td><strong class="total_amount"></strong></td>
<input type="hidden" id="total_amount" name="total_amount">
</tr>
</tfoot>
</table>
</div>
</div>
</div>
<!-- END -->
</div>
<button type="submit" class="btn btn-success">
<?php $dr_refund_settlement_id = '';
$driver_id = '';
if (!empty($driver_refund_settlement) && $driver_refund_settlement['dr_refund_settlement_id']) :
$dr_refund_settlement_id = $driver_refund_settlement['dr_refund_settlement_id'];
endif;
if (!empty($driver_refund_settlement) && $driver_refund_settlement['driver_id']) :
$driver_id = $driver_refund_settlement['driver_id'];
endif;
?>
<input type="hidden" name="driver_id" value="<?php echo $driver_id; ?>">
<input type="hidden" name="dr_refund_settlement_id" value="<?php echo $dr_refund_settlement_id; ?>">
<i class="fa fa-floppy-o" aria-hidden="true"></i> Save
</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- // Basic form layout section end -->
</div>
</div>
</div>
<script>
$(document).on('focusout', '#refund_amt', function() {
var refund_amt = $(this).val();
var bond_accumulated_amt = $("#bond_accumulated_amt").val();
//alert(bond_accumulated_amt + " && " + refund_amt);
if (parseFloat(bond_accumulated_amt) < parseFloat(refund_amt)) {
$.alert({
title : "ALERT!",
content : "Refund amount should not be grater than remaining bond refund.",
type:"red"
});
$(this).val(parseFloat(bond_accumulated_amt));
return false;
}
});
</script>
</script>
</body>
</html>
<script>
$(document).ready(function() {
var notice_date = $('#notice_date').pickadate({
format: 'dd/mm/yyyy',
autoclose: true,
max: new Date()
}),
notice_dt_picker = notice_date.pickadate('picker');
var bond_refund_due_dt = $('#bond_refund_due_dt').pickadate({
format: 'dd/mm/yyyy',
autoclose: true
}),
bond_refund_due_dt_picker = bond_refund_due_dt.pickadate('picker');
// Check if there’s a “from” or “to” date to start with.
if (notice_dt_picker.get('value')) {
bond_refund_due_dt_picker.set('min', notice_dt_picker.get('select'))
}
if (bond_refund_due_dt_picker.get('value')) {
notice_dt_picker.set('max', bond_refund_due_dt_picker.get('select'))
}
// When something is selected, update the “from” and “to” limits.
notice_dt_picker.on('set', function(event) {
if (event.select) {
bond_refund_due_dt_picker.set('min', notice_dt_picker.get('select'));
} else if ('clear' in event) {
bond_refund_due_dt_picker.set('min', false);
}
})
bond_refund_due_dt_picker.on('set', function(event) {
if (event.select) {
notice_dt_picker.set('max', bond_refund_due_dt_picker.get('select'));
} else if ('clear' in event) {
notice_dt_picker.set('max', false);
}
})
});
$(document).on('change','#payment_method,#refund_amt',function(){
if($("#payment_method").val()==3){
var refund_amt=$("#refund_amt").val();
if(refund_amt > 0){
$("#denomination_div").show();
} else {
$("#denomination_div").hide();
}
}else {
$("#denomination_div").hide();
}
});
$(document).on('keyup','.calculate_amt',function(){
var qty = $(this).val();
var dollar_price = $(this).data('dollar_price');
var balance_qty = $(this).data('balance_qty');
// alert(Number(qty));
// alert(Number(balance_qty));
if(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_cash_amount=$("#refund_amt").val();
var total_amount =0 * 1;
$(this).next('input[type=hidden]').val(amount);
$(this).parent().parent().children('.dollar_amount').html(amount);
$('.dollar_amount').each(function(){
total_amount +=Number($(this).text());
})
if(Math.abs(total_cash_amount) < Math.abs(total_amount)){
$.alert({
type: 'red',
title: 'Alert!',
content: 'Cash amount not matched with denominations total',
});
$(this).val('');
$(this).next('input[type=hidden]').val('');
$(this).parent().parent().children('.dollar_amount').html('');
var final_total_amount =0 * 1;
$('.dollar_amount').each(function(){
final_total_amount +=Number($(this).text());
})
$(".total_amount").text(parseFloat(final_total_amount).toFixed(2));
$("#total_amount").val(final_total_amount);
}else{
$(".total_amount").text(parseFloat(total_amount).toFixed(2));
$("#total_amount").val(total_amount);
}
})
</script>