File: /home/barbeatleanalyti/public_html/baris.beatleanalytics.com/site/template/comparisonreport.php
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css">
<script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.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.36/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js"></script>
<script src="https://baris.beatleanalytics.com/theme/black/rgraph/RGraph.svg.common.core.js"></script>
<script src="https://baris.beatleanalytics.com/theme/black/rgraph/RGraph.svg.line.js"></script>
<script src="https://baris.beatleanalytics.com/theme/black/rgraph/RGraph.svg.common.tooltips.js"></script>
<?php
// Declare new object
$objComparisonreport = object;
// Assing object
$objComparisonreport = $objDB->objController;
// Assign all variable's value
$pg = $objComparisonreport->pg;
$acn = $objComparisonreport->acn;
$Email = $objComparisonreport->Email;
$Password = $objComparisonreport->Password;
$error = $objComparisonreport->error;
$msg = $objComparisonreport->msg;
$p = $objComparisonreport->p;
$m = $objComparisonreport->m;
$y = $objComparisonreport->y;
$FromDate = $objComparisonreport->FromDate;
$ToDate = $objComparisonreport->ToDate;
$PageID = $objComparisonreport->PageID;
$PageConID = $objComparisonreport->PageConID;
$atype = $objComparisonreport->atype;
$BranchID = $objComparisonreport->BranchID;
$IndustryID = $objComparisonreport->IndustryID;
$NoData = $objComparisonreport->NoData;
if(!method_exists($objComparisonreport,$acn)){
ReturnPostFormData($ValidateArr = array(),"error.html","<span class='error-msg'>Method <strong>".$acn."</strong> does not exist in <strong>".$pg."</strong> file !</span>",2);
}
$feedCount = fetchTotalFeedbackNewReport(0);
$performanceArr = $objComparisonreport->fetchRatingForNewReportWeekly();
/*echo "<pre>";
print_r($performanceArr);*/
$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>"*/
?>
<!--
data table
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/fixedheader/3.1.5/css/fixedHeader.dataTables.min.css">
--->
<link rel="stylesheet" href="<?php echo $curImagePath?>/dist/css/Custom.css">
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<!-- <h1>
Dashboard
<small>Control panel</small>
</h1>-->
<!--<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Dashboard</a></li>
<li class="active"></li>
</ol>
</section>-->
<?php
?>
<!-- Main content -->
<section class="content">
<!-- Small boxes (Stat box) -->
<div class="row">
<div class="col-xs-12">
<!-- /.box -->
<div class="box">
<!-- /.box-header -->
<div class="box-body">
<!------------------------------------------------------------------>
<form method="post" action="comparisonreport.html" name="frmSearch" id="frmSearch">
<div class="box-header">
<h3 class="box-title" style="width:100%;">
<div class="form-group">
<!-- <label class=" control-label station_select"> Select Station</label>-->
<div class=" col-md-2 station_select_opction ">
<select class="form-control input-md" id="org_list" name="Station">
<option value="0">Select Station </option>
<option value="1">Jaipur Station</option>
<option value="2">Ahmedabad Station</option>
<option value="3">Mumbai Station</option>
</select>
</div>
<div class=" col-xs-12 col-md-3 col-lg-2 form-group">
<select class="form-control input-md" id="org_list" name="Question">
<option value="0">Select Question </option>
<option selected="selected" value="11">Score Card CTS</option>
</select>
</div>
<div class=" col-xs-12 col-md-3 col-lg-2 form-group">
<select class="form-control input-md" id="org_list" name="Auditor">
<option value="0">Select Auditor </option>
<option value="1">gautam prajapati</option>
<option value="2">mehul thumar</option>
</select>
</div>
<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="08-01-2020">
</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="07-02-2020">
</div>
<div class="input-group input-group-sm pull-right- text-right">
<span class="pull-right text-right form-group no-padding">
<a class="btn btn-success btn-sm" onclick="myFunction()" href="#"> <i class="fa fa-search"></i> GO </a>
<script>
function myFunction() {
$(".loader").show();
document.getElementById("frmSearch").submit();
}
$(window).bind("load", function() {
//$(".loader").hide();
});
</script>
</span>
</div>
</div>
</h3>
</div>
</form>
<!----report--->
<h2 style=" font-size: 22px; margin: 0px;color: #000000; margin-bottom: 24px;"> <i class="fa fa-fw fa-list"></i> Auditors Comparison List </h2>
<table id="" class="display example2" cellspacing="0" width="100%">
<thead>
<tr>
<th>Sr.no</th>
<th>Auditor Name</th>
<th>Avg. Scoring</th>
<th>08/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>08/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>08/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>08/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
</tr>
<tr class="search_vr">
<th>Sr.no</th>
<th>Auditor Name</th>
<th>Avg. Scoring</th>
<th>08/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>08/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>08/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
<th>08/01/2020</th>
<th>09/01/2020</th>
<th>10/01/2020</th>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td> Gautam P</td>
<td>90 %</td>
<td>90 %</td>
<td>90 %</td>
<td>90 %</td>
<th>90 %</th>
<th>90 %</th>
<th>90 %</th>
<td>90 %</td>
<td>90 %</td>
<th>90 %</th>
<th>90 %</th>
<th>90 %</th>
<td>90 %</td>
<td>90 %</td>
<th>90 %</th>
<th>90 %</th>
<th>90 %</th>
</tr>
<tr>
<td>1</td>
<td> rahul P</td>
<td>90 %</td>
<td>90 %</td>
<td>90 %</td>
<td>90 %</td>
<th>90 %</th>
<th>90 %</th>
<th>90 %</th>
<td>90 %</td>
<td>90 %</td>
<th>90 %</th>
<th>90 %</th>
<th>90 %</th>
<td>90 %</td>
<td>90 %</td>
<th>90 %</th>
<th>90 %</th>
<th>90 %</th>
</tr>
</tbody>
</table>
<style>
tfoot input { width: 100%; padding: 3px; box-sizing: border-box; }
</style>
<!----report---->
<br><hr>
<h2 style=" font-size: 22px; margin: 0 0 18px 0px; color: #000000;"><i class="fa fa-fw fa-area-chart"></i> Auditors Comparison Graph </h2>
<div style="width: 100%; height: 190px;" id="chart-container-c" ></div>
<!-- <center> <img class="report_sch_img" src="http://baris.beatleanalytics.com/theme/black/dist/img/searchfeedback4.jpg" style="width:100%;"> </center>--->
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
<!-- /.col -->
</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 dashboard demo (This is only for demo purposes) -->
<script src="theme/black/dist/js/pages/dashboard.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="theme/black/dist/js/demo.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
<!-- 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>
<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>
<style>
.small-box>.inner {
border-radius: 0px !IMPORTANT;
}
table.dataTable tr:hover {
box-shadow: 0 0px 0px rgba(0,0,0,0.3);
}
table.dataTable thead {
color: #fff;
background: #3c8dbc;
}
</style>
<style>
div.dataTables_wrapper {
width: 100%;
margin: 0 auto;
}
div.dataTables_wrapper {
max-width: auto !IMPORTANT;
min-width: auto !IMPORTANT;
margin: 0 auto;
}
table.dataTable td.action_user i {
font-size: 20px;
margin: 0 6px;
color: #afafaf;
}
div.dataTables_wrapper {
width: 100% !IMPORTANT;
margin: 0 auto;
padding: 0px !IMPORTANT;
}
.dataTables_scrollHeadInner {
padding: 0px !IMPORTANT;
width: 100% !IMPORTANT;
margin: 0 auto !IMPORTANT;
}
table.display.nowrap.dataTable.no-footer {
width: 100% !IMPORTANT;
text-align: center !IMPORTANT;
margin: 0 auto;
padding: 0pc;
}
table.display.nowrap.dataTable.no-footer thead th {
text-align: center;
}
.dataTables_scrollBody {
height: auto !IMPORTANT;
max-height: 800px !IMPORTANT;
}
.dataTables_scroll {
border: 1px solid #909090;
border-radius: 3px;
}
span.badge.bg-green a {
color: #FFF;
}
table.dataTable th td {border:1px solid !important;}
.fixed .dataTables_scrollHeadInner { width:100% !IMPORTANT; margin:0px !IMPORTANT;}
.fixed table.example420.order-table.table.table-striped.table-bordered.dragscroll.dataTable.no-footer {width: 100% !IMPORTANT; padding-right: 5px; }
.dataTables_scrollBody {height: auto !IMPORTANT; max-height:522px !IMPORTANT;}
.dataTables_scroll { border: 1px solid #909090; border-radius: 3px;}
.table_fix_heder{ background: #48a9d4;color: #FFF !IMPORTANT;}
.table_fix_heder tr th{ color: #FFF !IMPORTANT;}
table.dataTable tr.average_rating { background: #fff;}
table.dataTable tr.average_rating th { color: #dedede !IMPORTANT;}
.red { color: red !IMPORTANT;}
div#propertyThumbnails-- { position: relative;}
.loader {position: absolute; top: 46%;left: 46%; background: #000000c7; padding: 8px 24px; border-radius: 7px; color: #FFFF;}
.sk-double-bounce .sk-child {background-color: #fff;}
div.dataTables_wrapper {max-width:2000px;min-width:1400px;margin: 0 auto;}
div#propertyThumbnails td { color: black;}
.dataTables_scroll { box-shadow: 1px 1px 20px 1px #7c7c7c;}
.DTFC_LeftWrapper {
top: 1px !IMPORTANT;
}
.DTFC_LeftBodyWrapper {
border-right: 1px solid #bfbfbf !IMPORTANT;
}
.modal.cust_coment.in p {
color: #000 !IMPORTANT;
}
.DTFC_ScrollWrapper {
margin-bottom: 16px;
}
table.dataTable thead th, table.dataTable thead td {
border-bottom: 0px solid #111;
}
@media print {
.header-print {
display: table-header-group;
}
}
input[type="text"] {
color: black !important;
}
table.dataTable th.w100 input[type="text"] {
width: 100%;
}
table.dataTable th.w100 {
font-size: 12px !IMPORTANT;
}
table.dataTable th, table.dataTable td {
width: -webkit-fill-available !IMPORTANT;
}
table.dataTable th span {
max-width:100px;
word-wrap:break-word;
}
table#example2 td span a {
color: #FFF !IMPORTANT;
}
table#example2 td span{
width: 20px !IMPORTANT;
height: 20px !IMPORTANT;
padding: 0px !IMPORTANT;
margin: 0px !IMPORTANT;
line-height: 1.7;
border-radius: 20px;
}
span.badge.bg-red.absent-link {
background: #FF9800 !IMPORTANT;
}
table.dataTable thead td.w-40, table.dataTable thead td.w-40, thead .w-40 ,table.dataTable thead th {
font-size: 11px !IMPORTANT;
width: 65px !IMPORTANT;
min-width: 65px !IMPORTANT;
max-width: 65px !IMPORTANT;
margin: 0px 0px !IMPORTANT;
font-weight: 100 !IMPORTANT;
}
table.dataTable thead tr input[type="text"] {
width: 96%;
}
.dataTables_scroll {
box-shadow: 0px 0px 0px 0px #7c7c7c;
}
div#DataTables_Table_0_length select {
padding: 5px 7px;
}
div#DataTables_Table_0_filter input[type="search"] {
border: 1px solid #b7b7b7;
padding: 3px 2px;
}
</style>
<script>
$(document).ready(function() {
// Setup - add a text input to each footer cell
$('.example2 .search_vr th').each( function (i) {
var title = $('.example2 .search_vr th').eq( $(this).index() ).text();
$(this).html( '<input type="text" placeholder="Search '+title+'" data-index="'+i+'" />' );
} );
// DataTable
var table = $('.example2').DataTable( {
scrollY: "900px",
scrollX: true,
autoWidth: true,
scrollCollapse: true,
paging: true,
lengthMenu: [
[ 10, 20, 30, -1 ],
[ '10 rows', '20 rows', '30 rows', 'Show all' ]
]
} );
// Filter event handler
$( table.table().container() ).on( 'keyup', '.search_vr input', function () {
table
.column( $(this).data('index') )
.search( this.value )
.draw();
} );
} );
</script>
<script>
$(document).ready(function() {
$('#example2').DataTable( {
scrollY: "900px",
scrollX: true,
scrollCollapse: true,
paging: true,
dom: 'Bfrtip',
lengthMenu: [
[ 10, 20, 30, -1 ],
[ '10 rows', '20 rows', '30 rows', 'Show all' ]
],
buttons: [
{ extend: 'pageLength', footer: true },
<?php if (in_array('excel', $rsPerm)) { ?>{ extend: 'excel', footer: true },<?php } ?>
<?php if (in_array('pdf', $rsPerm)) { ?>{ extend: 'print', footer: true }<?php } ?>
]
});
});
</script>
<!-- Weekly Sales Analysis START -->
<script>
var linex = new RGraph.SVG.Line({
id: 'chart-container-c',
data: [
[110,100,100,100,150,140,100,100,100],
[80,90,80,85,90,80,80,85,85,85],
[65,70,75,65,70,60,65,65,70,80]
],
options: {
xaxisLabels: ['1','2','3','4','5','6','7','8','9','10'],
yaxisScaleUnitsPost: '%',
labelsSize: 2,
yaxisUnitsPost: '',
xaxisTextColor: '#fff',
yaxisTextColor: '#fff',
tooltips: ['4.71','4.83','4.67','4.77','4.54','4.61','4.55','5','4.99','4.86','5','5','0','5','4.71','4.83','4.67','4.77','4.54','4.61','4.55','5','4.99','4.86','5','5','0','5','4.71','4.83','4.67','4.77','4.54','4.61','4.55','5','4.99','4.86','5','5','0','5'],
gutterLeft: 30,
gutterTop: 20,
gutterRight: 30,
gutterBottom: 30,
colors: ['#00a1ff','#ff0000' ,'#f0ff00'],
linewidth:2.5,
shadow: false,
shadowBlur: 3,
tickmarks: 'circle',
ticksize: 5,
textColor: '#fff',
shadowOpacity: 5,
spline: true
}
}).trace();
</script>
<style>
text {
fill: #fff;
size: 10px !IMPORTANT;
font-size: 11px;
}
.RGraph_tooltip {
margin-top: 61px !IMPORTANT;
}
svg {
background: #222d32;
border-radius: 8px;
width: 100%;
}
</style>