File: /var/www/html/taxicamera/applicationold/views/admin/report/docket/docket_report_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-md-12">
<div class="card">
<div class="card-header">
<div class="page-title-wrap">
<h4 class="card-title">Docket Report</h4>
</div>
</div>
<div class="card-body">
<div class="px-3">
<form id="bond_report_form" action="" method="Post" 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>Company Name</label>
<select id="company_id" name="company_id" class="js-select2" data-show-subtext="true" data-live-search="true">
<option value="">Select Company</option>
<?php if($company_list): ?>
<?php foreach($company_list as $list): ?>
<option value="<?php echo $list['company_id']; ?>"><?php echo $list['company_name']; ?></option>
<?php endforeach; ?>
<?php endif; ?>
</select>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label>Dockets Name</label>
<select id="docket_id" name="docket_id" style="font-size:12px" class="js-select2" data-show-subtext="true" data-live-search="true">
<option value="">Select Dockets</option>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Driver Name</label>
<select id="driver_id" name="driver_id" style="font-size:12px" class="js-select2" data-show-subtext="true" data-live-search="true">
<option value="">Select Driver</option>
<?php if(!empty($driver_list)):?>
<?php foreach($driver_list as $val): ?>
<option value="<?php $val['user_id']; ?>"><?php echo $val['full_name'].' - '.$val['dc_no']; ?></option>
<?php endforeach; ?>
<?php endif; ?>
</select>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label>From Date</label>
<div class="input-group">
<input id="from_dt" name="from_dt" type="text" style="font-size:12px" class="form-control pickadate" value="" placeholder="DD/MM/YYYY"/>
<?php // echo date('d/m/Y',strtotime('-2 week')); ?>
<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 id="to_dt" name="to_dt" type="text" style="font-size:12px" class="form-control pickadate" value="" placeholder="DD/MM/YYYY"/>
<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-2" style="margin-top:2.5%">
<div class="form-group">
<button type="button" class="btn btn-success" id="search_btn">
<i class="fa fa-search" aria-hidden="true"></i> Search
</button>
</div>
</div>
</div>
</div>
</div>
</form>
<div id="report_list_div">
<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 docket_report_table">
<thead>
<tr>
<th>SL No.</th>
<th>DC</th>
<th>Driver Name</th>
<th>Car No.</th>
<th>Dockets Name</th>
<th>Date</th>
<th>Amount($)</th>
</tr>
</thead>
<tbody>
<?php $total_docket_amt=0; if(!empty($docket_report_data)): ?>
<?php foreach($docket_report_data as $key => $list):
if($list['middle_name']!=''){
$middle_name = $list['middle_name'].' ';
}
else{
$middle_name ='';
}
?>
<tr>
<td><?php echo $key+1; ?></td>
<td><?php echo $list['dc_no']; ?></td>
<td><?php echo $list['first_name'].' '.$middle_name.$list['last_name']; ?></td>
<td><?php echo $list['registration_no']; ?></td>
<td><?php echo $list['docket_name']; ?></td>
<td><?php echo date('d/m/Y',strtotime($list['created_on'])); ?></td>
<td><?php echo number_format($list['docket_settlement_amt'],2); ?></td>
<!--<td><?php //echo number_format($list['total_docket'],2); ?></td>-->
</tr>
<?php $total_docket_amt +=$list['docket_settlement_amt']; endforeach; ?>
<?php else: ?>
<tr>
<td colspan="7">No data found</td>
</tr>
<?php endif; ?>
</tbody>
<tfoot>
<tr style="background: #1db5bd;color: #fff;">
<td colspan="6"><strong>TOTAL</strong></td>
<td><strong><?=number_format($total_docket_amt,2)?></strong></td>
</tr>
</tfoot>
</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();
$('.docket_report_table').DataTable({
pageLength: 100,
dom: 'Bfrtip',
buttons: [{
extend: 'excel',
text: 'Download Excel',
className: 'btn btn-outline-primary mr-1',
filename: 'docket_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','#company_id',function(event){
var company_id = $("#company_id").val();
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/DocketReport/GetDocketsList')?>',
data:{company_id : company_id},
dataType:'json',
success: function(response){
if(response != 'Blank')
{
$('#driver_id').find('option').remove().end();
$.each( response, function( key, value ) {
var name = response[key].docket_name;
var docketid = response[key].docket_id;
$("<option></option>", {value: docketid, text: name}).appendTo('#docket_id');
});
}
else{
$('#docket_id').find('option').remove().end();
$("<option></option>", {value: '', text: 'Select Docket'}).appendTo('#docket_id');
}
},
error:function(response){
alert("error");
}
});
});
$(document).on('click','#search_btn',function(event){
event.preventDefault();
var company_id = $("#company_id").val();
var driver_id = $("#driver_id").val();
var from_date = $("#from_dt").val();
var to_date = $("#to_dt").val();
var cnt =0;
if(company_id == ""){
alert("Please select company.");
cnt++;
}
else{
//nothing to do
}
if(driver_id == ""){
alert("Please select driver.");
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/DocketReport/DocketReportGenerate')?>',
data:{company_id : company_id,driver_id : driver_id,from_date:from_date,to_date:to_date},
dataType:'JSON',
success: function(response){
//alert(response);
$("#report_list_div").html(response['html']);
var now = new Date();
var date = now.getFullYear() + "-" + now.getMonth() + "-" + now.getDate();
$('.docket_report_table').DataTable({
pageLength: 100,
dom: 'Bfrtip',
buttons: [{
extend: 'excel',
text: 'Download Excel',
className: 'btn btn-outline-primary mr-1',
filename: 'docket_report_' + date,
exportOptions: {
columns: [0,1,2,3,4,5,6]
}
}
//'copy', 'csv', 'excel', 'pdf', 'print'
]
});
},
error:function(response){
alert("error");
}
});
}
});
</script>