File: /var/www/html/taxicamera/old/application/views/admin/report/meter_reading/list.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-sm-12">
<h2 class="content-header">Driver Master</h2>
</div>
</div>-->
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-header">
<div class="page-title-wrap">
<h4 class="card-title">Meter Reading</h4>
</div>
<!--<p class="mb-0">This is the most basic and cost estimation form is the default position.</p>-->
</div>
<div class="card-body">
<div class="px-3">
<form class="form custom_form_style">
<div class="form-body">
<div class="user_permission_top">
<div class="row">
<div class="col-md-3">
<div class="form-group">
<label>Select Taxi</label>
<select class="js-select2" id="car_id" data-show-subtext="true" data-live-search="true">
<option value="">Select Taxi</option>
<?php if(!empty($car_list)){
foreach($car_list as $car) { ?>
<option value="<?=$car['car_id']?>"><?=$car['registration_no']?></option>
<?php } } ?>
</select>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label>From Date</label>
<div class="input-group">
<input type="text" name="from_date" id="from_date" class="form-control pickadate" placeholder="" />
<div class="input-group-append">
<span class="input-group-text">
<span class="fa fa-calendar-o"></span>
</span>
</div>
</div>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label>To Date</label>
<div class="input-group">
<input type="text" name="to_date" id="to_date" class="form-control pickadate" placeholder="" />
<div class="input-group-append">
<span class="input-group-text">
<span class="fa fa-calendar-o"></span>
</span>
</div>
</div>
</div>
</div>
<div class="col-md-1">
<div class="form-group">
<label class="blank_lbl"> </label>
<button id="search_btn" type="button" class="btn btn-success">
<i class="fa fa-search" aria-hidden="true"></i> Search
</button>
</div>
</div>
<div class="col-md-1" style="margin-left: 20px;">
<div class="form-group">
<label class="blank_lbl"> </label>
<button id="download_pdf" type="button" class="btn btn-success">
<i class="fa fa-download" aria-hidden="true"></i>PDF
</button>
</div>
</div>
</div>
</div>
</div>
</form>
<div class="row ">
<div class="table-responsive custom_table_area export_table_area">
<table id="meter_reading_table" class="table table-striped table-bordered export_btn_dt c_table_style">
<thead>
<tr>
<th>Sl. No.</th>
<th>Date</th>
<th>Car No.</th>
<th>Shift</th>
<th>Meter Start</th>
<th>Meter Finish</th>
<th>Meter Total</th>
<th>KLMS Start</th>
<th>KLMS Finish</th>
<th>KLMS Total</th>
<th>Paid KLMS Start</th>
<th>Paid KLMS Finish</th>
<th>Paid KLMS Total</th>
</tr>
</thead>
<tbody id="tbody_meter_reading">
<?php if (!empty($meter_reading_list)) {
foreach ($meter_reading_list as $key => $meter_reading) { ?>
<tr>
<td><?= $key + 1 ?></td>
<td><?= $meter_reading['payin_date'] ?></td>
<td><?= $meter_reading['registration_no'] ?></td>
<?php if($meter_reading['shift_name'] == "D"){
$shift_name = "Day";
}
else if($meter_reading['shift_name'] == "H"){
$shift_name = "Hungry";
}
else{
$shift_name = "Night";
}
?>
<td><?= $shift_name; ?></td>
<td><?= $meter_reading['total_km_start'] ?></td>
<td><?= $meter_reading['total_km_end'] ?></td>
<td style="background:#20C997;color:#fff;"><?= number_format(($meter_reading['total_km_end'] - $meter_reading['total_km_start']),2); ?></td>
<td><?= $meter_reading['total_extra_start'] ?></td>
<td><?= $meter_reading['total_extra_end'] ?></td>
<td style="background:#20C997;color:#fff;"><?= number_format(($meter_reading['total_extra_end'] - $meter_reading['total_extra_start']),2); ?></td>
<td><?= $meter_reading['paid_km_start'] ?></td>
<td><?= $meter_reading['paid_km_end'] ?></td>
<td style="background:#20C997;color:#fff;"><?= number_format(($meter_reading['paid_km_end'] - $meter_reading['paid_km_start']),2);?></td>
</tr>
<?php } ?>
<?php } ?>
</tbody>
</table>
</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();
$("#meter_reading_table").dataTable().fnDestroy();
$('#meter_reading_table').DataTable({
pageLength: 100,
dom: 'Bfrtip',
buttons: [{
extend: 'excel',
text: 'Download Excel',
className: 'btn btn-outline-primary mr-1',
filename: 'meter_reading_report_' + date
}
//'copy', 'csv', 'excel', 'pdf', 'print'
]
});
})
$(document).on('click', '#search_btn', function() {
var start_date = $("#from_date").val();
var end_date = $("#to_date").val();
var car_id = $("#car_id").val();
var resulthtml = footerhtml ='';
$.ajax({
url: "<?php echo base_url('admin/report/meter_reading_report_search'); ?>",
type: "POST",
data: {
'car_id': car_id,
'start_date': start_date,
'end_date': end_date
},
dataType: "json",
encode: true,
//async: false
})
.done(function(data) {
//console.log(data);
if (data.status) {
if (data.meter_reading_list) {
var i = 0;
var shift_name ;
$.each(data.meter_reading_list, function(key, value) {
i++;
resulthtml += '<tr>';
resulthtml += '<td>' + i + '</td>';
resulthtml += '<td>' + value.payin_date + '</td>';
resulthtml += '<td>' + value.registration_no + '</td>';
if(value.shift_name == "D"){
shift_name = "Day";
}
else if(value.shift_name == "H"){
shift_name = "Hungry";
}
else{
shift_name = "Night";
}
resulthtml += '<td>' + shift_name + '</td>';
resulthtml += '<td>' + value.total_km_start + '</td>';
resulthtml += '<td>' + value.total_km_end + '</td>';
resulthtml += '<td style="background:#20C997;color:#fff;">' + parseFloat(Number(value.total_km_end) - Number(value.total_km_start)).toFixed(2) + '</td>';
resulthtml += '<td>' + value.total_extra_start + '</td>';
resulthtml += '<td>' + value.total_extra_end + '</td>';
resulthtml += '<td style="background:#20C997;color:#fff;">' + parseFloat(Number(value.total_extra_end) - Number(value.total_extra_start)).toFixed(2) + '</td>';
resulthtml += '<td>' + value.paid_km_start + '</td>';
resulthtml += '<td>' + value.paid_km_end + '</td>';
resulthtml += '<td style="background:#20C997;color:#fff;">' + parseFloat(Number(value.paid_km_end) - Number(value.paid_km_start)).toFixed(2) + '</td>';
resulthtml += '</tr>';
})
//console.log(resulthtml);
var now = new Date();
var date = now.getFullYear() + ":" + now.getMonth() + ":" + now.getDate();
$("#meter_reading_table").dataTable().fnDestroy();
$("#tbody_meter_reading").html(resulthtml);
$('#meter_reading_table').DataTable({
pageLength: 100,
dom: 'Bfrtip',
buttons: [{
extend: 'excel',
text: 'Download Excel',
className: 'btn btn-outline-primary mr-1',
filename: 'meter_reading_report_' + date
}
//'copy', 'csv', 'excel', 'pdf', 'print'
]
});
}
} else {
$.alert({
type: 'red',
title: 'Alert!',
content: 'Oops!Something went wrong...',
});
}
})
.fail(function(result) {
$.alert({
type: 'red',
title: 'Alert!',
content: 'Oops!Something went wrong...',
});
})
})
$(document).on('click','#download_pdf',function(){
var start_date = $("#from_date").val();
var end_date = $("#to_date").val();
var car_id = $("#car_id").val();
var format_start_date=start_date.split("/").reverse().join("-");
var format_end_date=end_date.split("/").reverse().join("-");
window.location.href = "<?=base_url()?>admin/report/download_pdf_metered_fare/"+car_id+"/"+format_start_date+"/"+format_end_date;
})
</script>