File: /home/cafsindia/allyindian_com/sbltt/application/views/abstrack_report/manage.php
<?php $this->load->view("partial/header"); ?>
<link rel="stylesheet" type="text/css" href="dist/data_tables/datatables.min.css"/>
<script type="text/javascript" src="dist/data_tables/datatables.min.js"></script>
<script type="text/javascript">
$(document).ready(function (){
<?php $this->load->view('partial/daterangepicker'); ?>
$('#daterangepicker').data('daterangepicker').setStartDate("<?php echo date($this->config->item('dateformat'), mktime(0,0,0,date("m"),1,date("Y"))); ?>");
var start_date = "<?php echo date('Y-m-d', mktime(0,0,0,date("m"),1,date("Y"))); ?>";
var end_date = "<?php echo date('Y-m-d', mktime(0,0,0,date("m")+1,1,date("Y"))-1); ?>";
$('#search').on('click', function (e){
$.ajax({
type: "POST",
url:"<?php echo base_url('index.php/Abstrack_report/abstrack_report'); ?>?",
data: {start_date: start_date,end_date: end_date},
success: function(data) {
total_enq =0;
var rslt = JSON.parse(data);
enquiry_followup = rslt.result[0]['enquirey_followup'];
enquiry_confirm = rslt.result[0]['enquirey_confirm'];
enquirey_cancel = rslt.result[0]['enquirey_cancel'];
DBookingrow_tot = rslt.result[0]['DBookingrow_tot'];
DBookingcancelrow_tot = rslt.result[0]['DBookingcancelrow_tot'];
DBookingtotalrow_tot = rslt.result[0]['DBookingtotalrow_tot'];
enqBooking_tot = rslt.result[0]['enqBooking_tot'];
booking_follow = rslt.result[0]['bookingfollowrow_tot'];
total_enq = parseInt(enquiry_followup) + parseInt(enquiry_confirm) + parseInt(enquirey_cancel);
var tr = "<tr><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','4')>"+total_enq+"</td><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','1')>"+enquiry_followup+"</td><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','2')>"+enquiry_confirm+"</td><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','3')>"+enquirey_cancel+"</td><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','5')>"+DBookingrow_tot+"</td><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','8')>"+enqBooking_tot+"</td><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','9')>"+booking_follow+"</td><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','7')>"+DBookingcancelrow_tot+"</td><td style='text-align:center; cursor:pointer;' onclick=get_sales_info('"+start_date+"','"+end_date+"','6')>"+DBookingtotalrow_tot+"</td></tr>";
$('#abstrack_report').html(tr);
$('#abstrack_list').DataTable({
"paging": false,
retrieve: true,
"ordering": false,
"filter": false,
dom: 'Bfrtip',
buttons: ['excel'],
});
},
});
});
});
function get_sales_info(start_date,end_date,sts){
var frm = "get_sales_info";
$.ajax({
type: "POST",
url: "./dashboard/report_call.php",
data: {frm:frm,start_date:start_date,end_date:end_date,sts:sts},
success: function(data) {
$('#report_model_body').html(data);
$('#detail').DataTable( {
"paging": false,
"ordering": false,
dom: 'Bfrtip',
buttons: ['excel'],
});
$('#detail_list_model').modal('show');
},
});
}
</script>
<div class="row" id='holder'>
<div class="col-md-12">
<div class="form-group">
<?php echo form_input(array('name' => 'daterangepicker', 'class' => 'form-control input-sm', 'id' => 'daterangepicker')); ?>
</div>
<div class="form-group">
<button class="btn btn-primary btn-sm" id="search" >Search</button>
</div>
<h1>Sales Conversion Report</h1>
</div>
<div class="col-md-12">
<div id="table">
<table id='abstrack_list' class='table table-hover table-striped col-style'>
<thead>
<tr style='font-weight:bold;text-align:center !important;background:#3369E6;'>
<th style='text-align:center !important;padding:4px;'>Total Enquiry</th>
<th style='text-align:center !important;padding:4px;'>Enq Follow Up</th>
<th style='text-align:center !important;padding:4px;'>Enq Confirmed</th>
<th style='text-align:center !important;padding:4px;'>Enq Cancelled</th>
<th style='text-align:center !important;padding:4px;'>Direct Booking</th>
<th style='text-align:center !important;padding:4px;'>Enq to Booking</th>
<th style='text-align:center !important;padding:4px;'>Booking Follow</th>
<th style='text-align:center !important;padding:4px;'>Booking Cancelled</th>
<th style='text-align:center !important;padding:4px;'>Total Booking</th>
</tr>
</thead>
<tbody id="abstrack_report"></tbody>
</table>
</div>
</div>
</div>
<div class="modal fade" id="detail_list_model" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog modal-lg" style="width: 90%;" role="document">
<div class="modal-content">
<div class="modal-header" style='padding: 5px 15px;'>
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="myModalLabel">Detailed List</h4>
</div>
<div class="modal-body" id="report_model_body" style="height:260px;">
</div>
</div>
</div>
</div>
<style type="text/css">
#table_holder .fixed-table-body table tr td {
color: #333333 !important;
padding: 8px !important;
line-height: inherit !important;
vertical-align: middle !important;
height: auto;
}
div#holder {
padding: 15px;
background-color: #FFFFFF;
margin: 5px;
border-radius: 4px;
box-shadow: 0 2px 2px 0 rgba(0, 0, 0, 0.14), 0 1px 5px 0 rgba(0, 0, 0, 0.12), 0 3px 1px -2px rgba(0, 0, 0, 0.2);
}
h1 {
margin: 0;
margin-bottom: 4px !important;
width: auto;
font-size: 25px;
color: #d84f57;
font-weight: bold;
text-transform: initial;
}
#table .btn-default {
color: #ffffff !important;
background: #d84f57;
padding: 2px 6px !important;
font-size: 12px !important;
}
.btn-group, .btn-group-vertical {
position: relative;
display: inline-block;
vertical-align: middle;
float: right;
margin-bottom:10px;
}
div.dataTables_wrapper div.dataTables_filter label {
font-weight: normal;
white-space: nowrap;
text-align: left;
float: left;
}
#report_model_body .btn-default {
color: #ffffff !important;
background: #d84f57;
padding: 1px 6px !important;
font-size: 12px !important;
}
</style>
<?php $this->load->view("partial/footer"); ?>