File: /var/www/html/taxicamera/old/applicationold/views/admin/report/accident/accident_report_details.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">Accident Report Details</h4>
<a href="<?php echo base_url().'admin/AccidentReport' ?>"class="btn btn-secondary pull-right">Back To List</a>
</div>
<div class="pull-right" style="margin-top:15px;margin-left:20px">
<p style="font-size:18px"><strong>Total Accident Amount: <?php echo '$'.number_format($accident_details[0]['total_amt'],2);?></strong><p>
<p style="font-size:18px"><strong>Initial Amount Paid: <?php echo '$'.number_format($accident_details[0]['amt_pai'],2)?></strong><p>
</div>
</div>
<div class="card-body">
<div class="px-3">
<div id="report_list">
<div class="row">
<div class="table-responsive custom_table_area export_table_area">
<table class="table table-striped table-bordered export_btn_dt c_table_style">
<thead>
<tr>
<th>Shift Id</th>
<th>Payment Date</th>
<th>InstalmentAmount Paid($)</th>
</tr>
</thead>
<tbody>
<?php if(!empty($accident_details)): ?>
<?php foreach($accident_details as $list): ?>
<?php if(!empty($list['shift_id'])): ?>
<tr>
<td><?php echo $list['shift_id']; ?></td>
<td><?php echo date('d/m/Y',strtotime($list['payment_dt'])); ?></td>
<td style="text-align:right"><?php echo number_format($list['shift_amt'],2); ?></td>
</tr>
<?php else: ?>
<tr>
<td colspan="3">No Data Found</td>
</tr>
<?php endif; ?>
<?php endforeach; ?>
<tr>
<td colspan="2" style="font-size:15px";><strong>Due Amount($)</strong></td>
<td style="text-align:right"><?php echo number_format($due_amt,2); ?></td>
</tr>
<?php else: ?>
<tr>
<td colspan="5" style="text-align: center";><h5>No data found</h5></td>
</tr>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- // Basic form layout section end -->
</div>
</div>
</div>
<script>
$(document).ready(function() {
var now = new Date();
var date = now.getFullYear() + "-" + now.getMonth() + "-" + now.getDate();
$('.accident_report_table').DataTable({
pageLength: 100,
dom: 'Bfrtip',
buttons: [{
extend: 'excel',
text: 'Download Excel',
className: 'btn btn-outline-primary mr-1',
filename: 'accident_report_' + date,
exportOptions: {
columns: [0,1,2,3,4,5,6]
}
}
//'copy', 'csv', 'excel', 'pdf', 'print'
]
});
$(".js-select2").select2();
var from_dt = $('#from_dt').pickadate({format:'dd/mm/yyyy',autoclose:true}),
from_dt_picker = from_dt.pickadate('picker');
var to_dt = $('#to_dt').pickadate({format:'dd/mm/yyyy',autoclose:true}),
to_dt_picker = to_dt.pickadate('picker');
// Check if there’s a “from” or “to” date to start with.
// if ( from_dt_picker.get('value') ) {
// to_dt_picker.set('min', from_dt_picker.get('select'))
// }
// if ( to_dt_picker.get('value') ) {
// from_dt_picker.set('max', to_dt_picker.get('select'))
// }
// When something is selected, update the “from” and “to” limits.
from_dt_picker.on('set', function(event) {
if ( event.select ) {
to_dt_picker.set('min', from_dt_picker.get('select'));
}
else if ( 'clear' in event ) {
to_dt_picker.set('min', false);
}
})
to_dt_picker.on('set', function(event) {
if ( event.select ) {
from_dt_picker.set('max', to_dt_picker.get('select'));
}
else if ( 'clear' in event ) {
from_dt_picker.set('max', false);
}
})
});
$(document).on('change','#driver_id',function(event){
var driver_id = $("#driver_id").val();
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/AccidentReport/GetCarList')?>',
data:{driver_id : driver_id},
dataType:'json',
success: function(response){
if(response != 'Blank')
{
$('#car_id').find('option').remove().end();
$("<option></option>", {value: '', text: 'Select Car'}).appendTo('#car_id');
$.each( response, function( key, value ) {
var name = response[key].car_no;
var carid = response[key].car_id;
$("<option></option>", {value: carid, text: name}).appendTo('#car_id');
});
}
else{
$('#car_id').find('option').remove().end();
$("<option></option>", {value: '', text: 'Select car'}).appendTo('#car_id');
}
},
error:function(response){
alert("error");
}
});
});
$(document).on('click','#search_btn',function(event){
event.preventDefault();
var driver_id = $("#driver_id").val();
var car_id = $("#car_id").val();
var from_date = $("#from_dt").val();
var to_date = $("#to_dt").val();
var cnt =0;
if(driver_id == ""){
alert("Please select driver.");
cnt++;
}
else{
//nothing to do
}
if(car_id == ""){
alert("Please select Car.");
cnt++;
}
else{
//nothing to do
}
if(from_date == ""){
alert("Please select from date.");
cnt++;
}
else{
//nothing to do
}
if(to_date == ""){
alert("Please select to date.");
cnt++;
}
else{
//nothing to do
}
if(cnt == 0){
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/AccidentReport/AccidentReportGenerate')?>',
data:{driver_id : driver_id,car_id : car_id,from_date:from_date,to_date:to_date},
dataType:'JSON',
success: function(response){
//alert(response);
$("#report_list").html(response['html']);
var now = new Date();
var date = now.getFullYear() + "-" + now.getMonth() + "-" + now.getDate();
$('.accident_report_table').DataTable({
pageLength: 100,
dom: 'Bfrtip',
buttons: [{
extend: 'excel',
text: 'Download Excel',
className: 'btn btn-outline-primary mr-1',
filename: 'accident_report_' + date,
exportOptions: {
columns: [0,1,2,3,4,5,6]
}
}
//'copy', 'csv', 'excel', 'pdf', 'print'
]
});
},
error:function(response){
alert("error");
}
});
}
});
</script>