File: /home/barbeatleanalyti/public_html/barisnew.beatleanalytics.com/site/template/mccsummary.php
<?php
// Declare new object
$objDashboard = object;
// Assing object
$objDashboard = $objDB->objController;
// Assign all variable's value
$pg = $objDashboard->pg;
$acn = $objDashboard->acn;
$Email = $objDashboard->Email;
$Password = $objDashboard->Password;
$error = $objDashboard->error;
$msg = $objDashboard->msg;
$p = $objDashboard->p;
$m = $objDashboard->m;
$y = $objDashboard->y;
$FromDate = $objDashboard->FromDate;
$ToDate = $objDashboard->ToDate;
$PageID = $objDashboard->PageID;
$PageConID = $objDashboard->PageConID;
$atype = $objDashboard->atype;
$BranchID = $objDashboard->BranchID;
$IndustryID = $objDashboard->IndustryID;
$NoData = $objDashboard->NoData;
if(!method_exists($objDashboard,$acn)){
ReturnPostFormData($ValidateArr = array(),"error.html","<span class='error-msg'>Method <strong>".$acn."</strong> does not exist in <strong>".$pg."</strong> file !</span>",2);
}
$stationData = $objDashboard->FetchStationData();
$auditorData = $objDashboard->FetchAuditorsData();
$performanceArr = $objDashboard->fetchRatingForNewReportWeekly();
$feedCount = fetchTotalFeedbackNewReport($stationData[0]->stationId);
// echo "<pre>";
// print_r($stationData);
$days = "'".implode("','",$performanceArr['days'])."'";
$weeklyPerformanceFinalArr = array();
$weeklyPerformanceFinalArr['weekly_feedback_total'][] = $performanceArr['weekly_feedback_total'];
$perforArr = array();
$perforArr['wfbtotal'] = array(0,0,0,0,0,0,0);
for($wpday = 0; $wpday < 7; $wpday++) {
$perforArr['wfbtotal'][$wpday];
for($wp = 0; $wp<count($weeklyPerformanceFinalArr['weekly_feedback_total']); $wp++ ){
$perforArr['wfbtotal'][$wpday] = (float)number_format(($perforArr['wfbtotal'][$wpday] + $weeklyPerformanceFinalArr['weekly_feedback_total'][$wp][$wpday]),2);
}
}
/*echo "<pre>";
print_r($perforArr['wfbtotal']);
echo "<pre>"*/
?>
<link href="https://fonts.googleapis.com/css2?family=Varela+Round&display=swap" rel="stylesheet">
<link rel="stylesheet" href="<?php echo $curImagePath?>/dist/css/Custom.css">
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<?php
?>
<!-- Main content -->
<section class="content">
<div class="coming-soon"> <img class="" src="http://baris.beatleanalytics.com/theme/black/dist/img/coming-soon.png"></div>
<!-- Small boxes (Stat box) -->
<div class="row" style="display:none;"
<div class="col-lg-12 col-xs-12">
<div id='date-selection' class="">
<div class="col-md-2 col-xs-6 form-group">
<input type="text" readonly="readonly" id="FromDate" name="FromDate" placeholder="Start date.." class="form-control input-md" value="<?php echo $FromDate;?>">
</div>
<div class="col-md-2 col-xs-6 form-group">
<input type="text" readonly="readonly" id="ToDate" name="ToDate" placeholder="End date.." class="form-control input-md" value="<?php echo $ToDate;?>">
</div>
<button type="submit" class="btn btn-primary">Submit</button>
</div>
<!------------->
<table id="mccsummary" class="display nowrap" style="width:100%">
<thead>
<tr>
<th>S.No</th>
<th>Date of Insp</th>
<th>Auditor</th>
<th>Train No</th>
<th> Coaches in Reke</th>
<th>Coaches Attended</th>
<th>Division </th>
<th> Depot</th>
<th> Contractor</th>
<th>Total Score </th>
<th>Inaccessable </th>
</tr>
</thead>
<tbody>
<tr>
<td> 1</td>
<td> 06/05/2020</td>
<td>Gautam</td>
<td>54567</td>
<td>24</td>
<td>18</td>
<td>Luckhnow - NER</td>
<td>Gorakhpur</td>
<td>V Inspire</td>
<td>92.67 %</td>
<td>5.21 %</td>
</tr>
<tr>
<td> 2</td>
<td> 06/05/2020</td>
<td>Gautam</td>
<td>52415</td>
<td>21</td>
<td>20</td>
<td>Luckhnow - NER</td>
<td>Gorakhpur</td>
<td>V Inspire</td>
<td>93.27 %</td>
<td>4.43 %</td>
</tr>
<tr>
<td> 3</td>
<td> 06/05/2020</td>
<td>Mehul</td>
<td>52177</td>
<td>19</td>
<td>19</td>
<td>Luckhnow - NER</td>
<td>Gorakhpur</td>
<td>V Inspire</td>
<td>80 %</td>
<td>0 %</td>
</tr>
<tr>
<td> 4</td>
<td> 06/05/2020</td>
<td>Mehul</td>
<td>52177</td>
<td>19</td>
<td>19</td>
<td>Luckhnow - NER</td>
<td>Gorakhpur</td>
<td>V Inspire</td>
<td>80 %</td>
<td>0 %</td>
</tr>
<tr>
<td> 5</td>
<td> 06/05/2020</td>
<td>Mehul</td>
<td>52177</td>
<td>19</td>
<td>19</td>
<td>Luckhnow - NER</td>
<td>Gorakhpur</td>
<td>V Inspire</td>
<td>80 %</td>
<td>0 %</td>
</tr>
<tfoot>
<tr>
<td> Total</td>
<td>-</td>
<td>-</td>
<td>-</td>
<td>102</td>
<td>95</td>
<td>-</td>
<td>-</td>
<td> -</td>
<td>xxxx</td>
<td>xxxx</td>
</tr>
</tfoot>
</tbody>
</table>
<!------------>
</div>
</div>
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<!-- jQuery 3 -->
<script src="theme/black/bower_components/jquery/dist/jquery.min.js"></script>
<!-- jQuery UI 1.11.4 -->
<script src="bower_components/jquery-ui/jquery-ui.min.js"></script>
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<script>
$.widget.bridge('uibutton', $.ui.button);
</script>
<!-- Bootstrap 3.3.7 -->
<script src="theme/black/bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- Morris.js charts -->
<script src="theme/black/bower_components/raphael/raphael.min.js"></script>
<script src="theme/black/bower_components/morris.js/morris.min.js"></script>
<!-- Sparkline -->
<script src="theme/black/bower_components/jquery-sparkline/dist/jquery.sparkline.min.js"></script>
<!-- jvectormap -->
<script src="theme/black/plugins/jvectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="theme/black/plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
<!-- jQuery Knob Chart -->
<script src="theme/black/bower_components/jquery-knob/dist/jquery.knob.min.js"></script>
<!-- daterangepicker -->
<script src="theme/black/bower_components/moment/min/moment.min.js"></script>
<script src="theme/black/bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<!-- datepicker -->
<script src="theme/black/bower_components/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script>
<!-- Bootstrap WYSIHTML5 -->
<script src="theme/black/plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script>
<!-- Slimscroll -->
<script src="theme/black/bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="theme/black/bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="theme/black/dist/js/adminlte.min.js"></script>
<!-- AdminLTE ctssummary demo (This is only for demo purposes) -->
<script src="theme/black/dist/js/pages/ctssummary.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="theme/black/dist/js/demo.js"></script>
<!-- FLOT CHARTS -->
<script src="theme/black/bower_components/Flot/jquery.flot.js"></script>
<!-- FLOT RESIZE PLUGIN - allows the chart to redraw when the window is resized -->
<script src="theme/black/bower_components/Flot/jquery.flot.resize.js"></script>
<!-- FLOT PIE PLUGIN - also used to draw donut charts -->
<script src="theme/black/bower_components/Flot/jquery.flot.pie.js"></script>
<!-- FLOT CATEGORIES PLUGIN - Used to draw bar charts -->
<script src="theme/black/bower_components/Flot/jquery.flot.categories.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.21/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.6.2/css/buttons.dataTables.min.css">
<script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.flash.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.print.min.js"></script>
<script>
$(document).ready(function() {
$("#FromDate").datepicker({
format: 'dd-mm-yyyy'
});
$("#ToDate").datepicker({
format: 'dd-mm-yyyy'
});
//document.forms["frmSearch"].submit();
});
function validateDate() {
var D1 = document.getElementById("ToDate");
var D2 = document.getElementById("FromDate");
if (D1.value.trim() == "") {
D1.style.border = "1px solid red";
return false;
}
if (D2.value.trim() == "") {
D2.style.border = "1px solid red";
return false;
}
}
</script>
<script>
$(document).ready(function() {
$('#mccsummary').DataTable( {
dom: 'Bfrtip',
buttons: [
'excel'
]
} );
} );
</script>