File: /var/www/html/pmw24/app/application/views/admin/servicedue/list_02_08_2019.php
<script src="<?php echo base_url();?>public/admin_assets/plugins/select2/select2.full.min.js"></script><!-- Content Wrapper. Contains page content -->
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/js/bootstrap-datepicker.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.4.1/css/bootstrap-datepicker3.css"/>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h3>Service Due Report</h3>
<!--<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li class="active">Dashboard</li>
</ol>-->
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box box-primary">
<div class="box-header with-border">
<?php if($this->session->flashdata('error_msg')){?>
<span style="color:red; font-weight:bold"><?php echo $this->session->flashdata('error_msg');?></span>
<?php }?>
<?php if($this->session->flashdata('success_msg')){?>
<span style="color:green; font-weight:bold"><?php echo $this->session->flashdata('success_msg'); ?></span>
<?php }?>
<div class="row" >
<div class='col-sm-2'>
<div class="form-group">
<label>From Date</label>
<div class='input-group date'>
<input type='text' class="form-control" placeholder="Start Date" value="<?php echo date('d/m/Y');?>" id="start_date"/>
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</div>
<div class='col-sm-2'>
<div class="form-group">
<label>To Date</label>
<div class='input-group date'>
<input type='text' class="form-control" placeholder="End Date" value="<?php echo date("d/m/Y");?>" id="end_date"/>
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</div>
<div class='col-sm-2'>
<div class="form-group">
<label></label>
<button class="form-control btn-primary" id="btn_filter">Search</button>
</div>
</div>
<div class='col-sm-2'>
<div class="form-group">
<label></label>
<button class="form-control btn-primary" id="btn_serviceduereport_csv">Download Excel</button>
</div>
</div>
</div>
</div>
<!-- /.box-header -->
<div class="box-body">
<table id="transaction_list" class="table table-bordered table-striped" style="width: 100%">
<thead>
<tr>
<!-- <th class="no-sort"><input type="checkbox" id="checkAll"></th> -->
<th>Car No</th>
<th>Due Transmission</th>
<th>Due Engine</th>
<th>Due Spark Plug</th>
</tr>
</thead>
<tbody>
</tbody>
<tfoot>
</tfoot>
</table>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- Modal -->
<div class="modal" id='myModal'>
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title">Message</h4>
</div>
<div class="modal-body" id='modalContent' title="">
<!-- <p>Would you like to continue ?</p>-->
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
<button type="button" class="btn btn-primary" data-dismiss="modal" id="cdel">Ok</button>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<div class="modal" id='myModalinactive'>
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title">Message</h4>
</div>
<div class="modal-body" id='modalContentinactive' title="">
<!-- <p>Would you like to continue ?</p>-->
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
<button type="button" class="btn btn-primary" data-dismiss="modal" id="inactive">Ok</button>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<!-- Modal -->
<!-- Modal -->
<div class="modal" id='myModalmdelete'>
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title">Message</h4>
</div>
<div class="modal-body" id='modalContentmdelete' title="">
<!-- <p>Would you like to continue ?</p>-->
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
<button type="button" class="btn btn-primary" data-dismiss="modal" id="mdel">Ok</button>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<div class="modal" id='myModal2'>
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title">Details</h4>
</div>
<div class="modal-body" id='modalContent2' title="">
<!-- <p>Would you like to continue ?</p>-->
</div>
<div class="modal-footer">
<button type="button" class="btn btn-primary" data-dismiss="modal" id="cdel2">Ok</button>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<!-- Modal -->
<script src="<?php echo base_url()?>public/admin_assets/plugins/datatables/jquery.dataTables.min.js"></script>
<script src="<?php echo base_url()?>public/admin_assets/plugins/datatables/dataTables.bootstrap.min.js"></script>
<script>
$(document).ready(function() {
table = $('#transaction_list').DataTable({
"processing": true, //Feature control the processing indicator.
"serverSide": true, //Feature control DataTables' server-side processing mode.
"order": [], //Initial no order.
"searching": false,
// Load data for the table's content from an Ajax source
"ajax": {
"url": "<?php echo site_url('admin/servicedue/all_content_list')?>",
"type": "POST",
"data": function(args){
args.start_date = $('#start_date').val(),
args.end_date = $('#end_date').val()
}
},
//Set column definition initialisation properties.
"columnDefs": [
{
"targets": 'no-sort', //1st and last column
"orderable": false, //set not orderable
},
],
});
$('#btn_filter').click(function(){
var start_date = $('#start_date').val();
var end_date = $('#end_date').val();
var d1 = new Date(start_date);
var d2 = new Date(end_date);
if(start_date==''){
alert('Start date field is required');
return true;
}
if(end_date==''){
alert('End date field is required');
return true;
}
if(d2 < d1){
alert('End date must be greater than start date');
return true;
}
table.draw();
});
$('#btn_serviceduereport_csv').click(function(){
var start_date = $('#start_date').val();
var end_date = $('#end_date').val();
//alert(start_date);
$.ajax({
type: "POST",
"url": "<?php echo site_url('admin/servicedue/all_content_list_csv')?>",
data: 'user_ids='+ids,
data: 'start_date='+start_date+'&end_date='+end_date,
dataType:'text',
success: function(response){
//alert(response);
// window.open('http://localhost/punjabm/response','_blank' );
window.location = '<?php echo site_url('public/reports/')?>'+response;
}
});
});
var dtable = $("#transaction_list").dataTable().api();
$(".dataTables_filter input")
.unbind() // Unbind previous default bindings
.bind("input", function(e) { // Bind our desired behavior
// If the length is 3 or more characters, or the user pressed ENTER, search
if(this.value.length >= 0 || e.keyCode == 13) {
// Call the API search function
dtable.search(this.value).draw();
}
// Ensure we clear the search if they backspace far enough
if(this.value == "") {
dtable.search("").draw();
}
return;
});
$(document).on( "click",'#duser',function(){
$('#modalContentmdelete').html('<p>Would you like to continue ?</p>');
var id=$(this).prop('title');
$('#modalContentmdelete').attr('title',id);
$('#myModalmdelete').modal('show');
});
var ids = [];
$(document).on( "click",'#generate_payment',function(){
$('#transaction_list input[type=checkbox]:checked').each(function () {
if($(this).attr('title') != undefined){
ids.push($(this).attr('title'));
}
});
if(ids == '')
{
alert('Please select at least one payment record to settle');
return false;
}else{
$('#transaction_id_list').val(ids);
var driver_id = $('#driver_id').val();
$('#selected_driver_id').val(driver_id);
}
});
$("#checkAll").change(function () {
$("#transaction_list input[type=checkbox]").prop('checked', $(this).prop("checked"));
});
//var ids = [];
var total_pay = 0;
$(document).on('click','.get_transaction',function(){
if (this.checked) {
$('#transaction_list input[type=checkbox]:checked').each(function () {
ids.push($(this).attr('title'));
});
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/newtransaction/total_pay')?>',
data: 'transaction_ids='+ids,
dataType:'json',
success: function(response){
//alert(response.driver_comission);
$('#total').val(response.driver_comission);
total_pay = response.driver_comission;
}
});
ids = [];
}else{
var transaction_id = $(this).attr('title');
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/newtransaction/get_driver_comm')?>',
data: 'transaction_id='+transaction_id,
dataType:'json',
success: function(response){
//alert(response.total_driver_comission);
if(final_pay != ''){
var total_driver_comission = response.total_driver_comission;
var final_pay = total_pay - response.total_driver_comission;
$('#total').val(final_pay.toFixed(2));
}else{
$('#total').val('');
}
total_pay = final_pay;
}
});
}
});
$("#transaction_list input[type=checkbox]").change(function(){
if (this.checked) {
//alert("check_all");
$('#transaction_list input[type=checkbox]:checked').each(function () {
ids.push($(this).attr('title'));
});
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/newtransaction/total_pay')?>',
data: 'transaction_ids='+ids,
dataType:'json',
success: function(response){
$('#total').val(response.driver_comission);
total_pay = response.driver_comission;
}
});
}else{
//alert("uncheck_all");
total_pay = 0;
$('#total').val("0.00");
}
ids = [];
});
$(document).on('click','#mdel',function(){
var ids = [];
$('#transaction_list input[type=checkbox]:checked').each(function () {
ids.push($(this).attr('title'));
});
if(ids.length === 0){
alert('Please Select Check Box to Delete');
}else{
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/newtransaction/total_pay')?>',
data: 'transaction_ids='+ids,
dataType:'json',
success: function(response){
$('#modalContentmdelete').html(response.message);
$('#myModalmdelete').modal('show');
setTimeout(function(){
$('#myModalmdelete').modal('hide')
},400);
window.location.reload('<?php echo base_url('admin/usersetting'); ?>');
}
});
}
});
$(document).on( "click",'#delete.cstm_view',function() {
$('#modalContent').html('<p>Would you like to continue ?</p>');
var id=$(this).prop('title');
$('#modalContent').attr('title',id);
$('#myModal').modal('show');
});
$(document).on('click','#cdel',function(){
var id=$('#modalContent').prop('title');
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/driver/del')?>',
data: 'user_id='+id,
dataType:'json',
success: function(response){
$('#modalContent').html(response.message);
$('#myModal').modal('show');
setTimeout(function(){
$('#myModal').modal('hide')
},400);
window.location.reload('<?php echo base_url('admin/cms'); ?>');
},
error:function(response){
$('#modalContent').html(response.message);
$('#myModal').modal('show');
setTimeout(function(){
$('#myModal').modal('hide')
},400);
}
});
});
$(document).on( "click",'#view.cstm_view',function() {
var id=$(this).prop('title');
var car_id = $(this).attr('car_id');
var content='<div class="box-body" style="max-height: 600px;overflow-y: auto;"> <h1 style="font-size: 24px; font-weight: 500;">Car Information</h1> <table class="table table-bordered">';
$.ajax({
type:'POST',
url :'<?php echo base_url('admin/servicehistory/all_details');?>',
data:'job_id='+id+'&car_id='+car_id,
dataType:'json',
success:function(result){
if(result.car.silver_service == 1){
var silver_service = "Yes";
}else{
var silver_service = "No";
}
content+='<tr><td>Car No</td> <td>'+result.car.car_no+'</td></tr>';
content+='<tr><td>Company Name</td> <td>'+result.car.company_name+'</td></tr>';
content+='<tr><td>Make</td> <td>'+result.car.make+'</td></tr>';
content+='<tr><td>Model No</td> <td>'+result.car.model_no+'</td></tr>';
content+='<tr><td>Body</td> <td>'+result.car.body+'</td></tr>';
content+='<tr><td>Compliance Date</td> <td>'+result.car.compliance_date+'</td></tr>';
content+='<tr><td>Vin</td> <td>'+result.car.vin+'</td></tr>';
content+='<tr><td>Engine</td> <td>'+result.car.engine+'</td></tr>';
content+='<tr><td>Fuel</td> <td>'+result.car.fuel+'</td></tr>';
content+='<tr><td>Network</td> <td>'+result.car.network+'</td></tr>';
content+='<tr><td>colour</td> <td>'+result.car.colour+'</td></tr>';
content+='<tr><td>Silver Service</td> <td>'+silver_service+'</td></tr>';
content+='<tr><td>Camera</td> <td>'+result.car.camera+'</td></tr>';
content+='<tr><td>Registration Expiry Date</td> <td>'+result.car.registration_expiry_date+'</td></tr>';
content+='<tr><td>Registration Due Month</td> <td>'+result.car.registration_due_month+'</td></tr>';
content+='<tr><td>Plate Type</td> <td>'+result.car.plate_type+'</td></tr>';
content+='<tr><td>Status</td> <td>'+result.car.car_status+'</td></tr>';
content+='<tr><td>Terminal No</td> <td>'+result.car.terminal_no+'</td></tr>';
content+='<tr><td>Remarks</td> <td>'+result.car.remarks+'</td></tr>';
content+='<tr><td>Owner Type</td> <td>'+result.car.owner_type+'</td></tr>';
content+='<tr><td>Driver Dc</td> <td>'+result.car.driver_dc+'</td></tr>';
content+='<tr><td>Name</td> <td>'+result.car.name+'</td></tr>';
content+='<tr><td>Email</td> <td>'+result.car.email+'</td></tr>';
content+='<tr><td>Address</td> <td>'+result.car.address+'</td></tr>';
content+='<tr><td>Contact No</td> <td>'+result.car.contact_no+'</td></tr>';
content+='<tr><td>Date Of Birth</td> <td>'+result.car.dob+'</td></tr>';
content+='</table>';
/* $.each( result.services, function( key, value ) {
content+='<tr><td>'+value.service_name+'</td></tr>';
}); */
content+='<h1 style="font-size: 24px; font-weight: 500; padding:5px 0;">Services</h1>';
$.each( result.services, function( key, value ) {
content+='<h3 style="padding:0 0 0 0; font-size:20px">'+value.service_name+'</h3>';
content+= '<ul>';
$.each( value.task, function( keyv, valuet ) {
content+= '<li>'+valuet.task_name+'</li>';
});
content+= '</ul>';
});
content+='</div>';
$('#modalContent2').html(content);
$('#myModal2').modal('show');
},error:function(){
}
});
});
$(document).on( "click",'#active.cstm_view_status',function() {
var p = $(this);
p.html('---');
p.css("color", "green");
var id=$(this).prop('title');
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/driver/inactive')?>',
data: 'user_id='+id,
dataType:'json',
success: function(response){
p.attr("id", "inactive");
p.text('Inactive');
p.css("color","red");
//window.location.reload('<?php echo base_url('admin/feedback'); ?>');
}
});
});
$(document).on( "click",'#inactive.cstm_view_status',function() {
var pactive = $(this);
pactive.html('---');
pactive.css("color","red");
var id=$(this).prop('title');
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/driver/active')?>',
data: 'user_id='+id,
dataType:'json',
success: function(response){
pactive.attr("id", "active");
pactive.text('Active');
pactive.css("color", "green");
//pactive.html('<a class="cstm_view_status_active" id="active" style="color:green" href="javascript:void(0)" title="'+id+'">Active</a>');
//window.location.reload('<?php echo base_url('admin/feedback'); ?>');
}
});
});
});
$(".select2").select2();
var nowDate = new Date();
var today = new Date(nowDate.getFullYear(), nowDate.getMonth(), nowDate.getDate(), 0, 0, 0, 0);
$('#start_date').datepicker({
startDate:today,
format: 'dd/mm/yyyy',
setDate: new Date()
});
$('#end_date').datepicker({
startDate:today,
format: 'dd/mm/yyyy',
setDate: new Date()
});
$('#downlad_pdf').click(function(){
var start_date = $('#start_date').val();
var end_date = $('#end_date').val();
var driver_id = $('#driver_id').val();
var pp_device_id = $('#pp_device_id').val();
$.ajax({
type: "POST",
url: '<?php echo base_url('admin/devicedcusages/export_pdf')?>',
data: 'start_date='+start_date+'&end_date='+end_date+'&driver_id='+driver_id+'&pp_device_id='+pp_device_id,
dataType:'text',
success: function(response){
if(response=='error'){
alert('No data found');
}else{
window.open(response,'_blank' );
}
}
});
});
</script>
<style>
.modal-body h3 {
padding: 0px 0 3px 0;
margin: 0 0 10px 0;
border-bottom: 1px dotted #999;
}
.modal-body ul {
padding: 0 0 30px 0;
margin: 0;
}
.modal-body ul li {
padding: 4px 0;
margin: 0;
border-bottom: 1px solid #ccc;
}
</style>