File: /home/barbeatleanalyti/public_html/barisnew.beatleanalytics.com/site/template/reports.php
<style type="text/css">
.main {margin: 0 auto; width: 740px; color:#AAA;}
#dmhd tr:hover {color:#EEEEEE; background:#3c4448;}
#vWrapper {margin-top:80px; padding:6px; width:140px; opacity:0.5; filter:alpha(opacity=50); background:#666;}
#vWrapper tr:hover {color:#FFF; text-decoration:underline; background:#333;}
.column_box { float:left; padding:0 20px;}
tbody#dmhd td.text-center.sorting_1 {
background: none;
}
#dmhd tr:hover td label a , #dmhd tr:hover td label {
color: #fff !important;
}
.column_box p {
margin: 0px;
}
.cust_review {
float: left;
width: 100%;
}
.cust_review h4.box-title {
margin: 10px 0 0 0;
}
.cust_review p {
font-size: 19px !IMPORTANT;
font-weight: 100;
margin: 0px !IMPORTANT;
padding: 0px !IMPORTANT;
}
div#mcTooltip {
margin-bottom: 0px !IMPORTANT;
padding-bottom: 10px;
}
</style>
<?php
// Declare new object
$objReports = object;
// Assing object
$objReports = $objDB->objController;
// Assign all variable's value
$pg = $objReports->pg;
$acn = $objReports->acn;
$v = $objReports->v;
$State = $objReports->State;
$ReligionName = $objReports->ReligionName;
$sort = $objReports->sort;
$ReligionID = $objReports->ReligionID;
$field = $objReports->field;
$error = $objReports->error;
$msg = $objReports->msg;
$perpage = $objReports->perpage;
$start = $objReports->start;
$limit = $objReports->limit;
$SearchValue = $objReports->SearchValue;
$s = $objReports->s;
$CustomerID = $objReports->CustomerID;
$SurveyID = $objReports->SurveyID;
$TokenID = $objReports->TokenID;
$pType = $objReports->pType;
$OrgID = $objReports->OrgID;
$BranchID = $objReports->BranchID;
$IndustryID = $objReports->IndustryID;
$FromDate = $objReports->FromDate;
$ToDate = $objReports->ToDate;
$StationId = $objReports->StationId;
$QuestionId = $objReports->QuestionId;
$AuditorId = $objReports->AuditorId;
$valck[] = array();
/*$rsCustomerInfo = $objReports->FetchCustomerData("All");
if($start == 1)
$limit = 0;
else if($start == 2)
$limit = $perpage;
else
$limit = ($start-1) * $perpage;
$objReports->limit = $limit;
$nume = count($rsCustomerInfo);
$totalpage = @ceil(count($rsCustomerInfo)/$perpage); */
//$rsCustomerInfo = $objReports->FetchCustomerData();
/*echo "<pre>";
print_r($rsCustomerInfo);*/
?>
<link rel="stylesheet" href="<?php echo $curImagePath?>/datatable/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="<?php echo $curImagePath?>/datatable/css/buttons.dataTables.min.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<!-- /.box -->
<div class="box">
<!-- /.box-header -->
<div class="box-body">
<!------------------------------------------------------------------>
<form method="post" action="reports.html" name="frmSearch" id="frmSearch">
<div class="box-header">
<h3 class="box-title" style="width:100%;">
<div class="form-group" >
<?php $rsStation = $objReports->fetchStation(); ?>
<!-- <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>
<?php if(count($rsStation) > 0) {
for($s=0; $s<count($rsStation); $s++) { ?>
<option <?php if($StationId === $rsStation[$s]['stationId']) echo 'selected="selected"'; ?> value="<?php echo $rsStation[$s]['stationId']?>"><?php echo $rsStation[$s]['stationName']?></option>
<?php }
}else{ ?>
<option value="0">No any station found</option>
<?php } ?>
</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">
<?php $rsQuestion = $objReports->FetchQuestion(); ?>
<option value="0">Select Question </option>
<?php if(count($rsQuestion) > 0) {
for($q=0; $q<count($rsQuestion); $q++) { ?>
<option <?php if($QuestionId === $rsQuestion[$q]['queId']) echo 'selected="selected"'; ?> value="<?php echo $rsQuestion[$q]['queId']?>"><?php echo $rsQuestion[$q]['queName']?></option>
<?php }
}else{ ?>
<option value="0">No any question found</option>
<?php } ?>
</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">
<?php $rsAuditor = $objReports->FetchAuditor(); ?>
<option value="0">Select Auditor </option>
<?php if(count($rsAuditor) > 0) {
for($a=0; $a<count($rsAuditor); $a++) { ?>
<option <?php if($AuditorId === $rsAuditor[$a]['userId']) echo 'selected="selected"'; ?> value="<?php echo $rsAuditor[$a]['userId']?>"><?php echo $rsAuditor[$a]['db_username']?></option>
<?php }
}else{ ?>
<option value="0">No any auditor found</option>
<?php } ?>
</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="<?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>
<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>
<?php
if(!empty($QuestionId) && !empty($StationId)){
$rsPagesIDS = QuestionGroupIDS('pages',$QuestionId);
$rsParamIDS = QuestionGroupIDS('params',$QuestionId);
/*echo "<pre>";
print_r($rsParamIDS);
echo "</pre>";*/
//$rsQuestionsInfo = $objReports->FetchQuestionsData();
$rsUserInfo = $objReports->FetchUsersData();
/*echo "<pre>";
print_r($rsQuestionsInfo);
echo "</pre>";*/
?>
<!------------------------------------------------------------------->
<table id="question_report" class="table table-bordered table-striped question_report">
<thead>
<tr>
<th>Sr No.</th>
<th>Date </th>
<th>Auditor </th>
<th>Parameter </th>
<th> overall score</th>
<?php
foreach($rsParamIDS as $val) {
?>
<th id="tbl-<?php echo $val;?>"><?php echo $objReports->SelectBarisParamName($val);?></th>
<?php } ?>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$totalAvgVer = 0;
$zeroTotalAvgVer = 0;
if(count($rsUserInfo)>0){
for ($u=0;$u< count($rsUserInfo);$u++)
{
$rsQuestionsInfo = $objReports->FetchQuestionsData($rsUserInfo[$u]['db_surveyUserid']);
/*echo "<pre>";
print_r($rsQuestionsInfo);
echo "</pre>";*/
if(count($rsQuestionsInfo)>0){ ?>
<?php
$idArr = array();
for ($i=0;$i< count($rsQuestionsInfo);$i++)
{
for ($j=0;$j< count($rsQuestionsInfo[$i]);$j++)
{ ?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo date("d/m/Y",strtotime($rsQuestionsInfo[$i][$j]['created_date'])); ?></td>
<td data-toggle="modal" data-target="#modal-default<?php echo $u.$i.$j;?>"><?php echo $rsQuestionsInfo[$i][$j]['db_username'];?></td>
<td><?php echo $objReports->SelectBarisPageName($rsQuestionsInfo[$i][$j]['db_surveyPageId']);?></td>
<td id="oveAvg<?php echo $u.$i.$j;?>" data-toggle="tooltip" data-placement="bottom" title="Test Demo"></td>
<!-- <td><small class="label bg-green">8</small></td>
<td><small class="label bg-red">5</small></td> -->
<?php
$zeroRatings = 0;
$avgSum = 0;
$totalAvg = 0;
foreach($rsParamIDS as $val) {
$avgVal = $objReports->FetchValueScore($rsQuestionsInfo[$i][$j]['db_surveyQuestionId'],$val,$rsQuestionsInfo[$i][$j]['db_surveyPageId'],$rsQuestionsInfo[$i][$j]['tokenid']);
if($avgVal != 0){
$zeroRatings++;
}
$avgSum = $avgSum + $avgVal;
if($avgVal == 0){
$span = '<small class="label bg-gold" >'.$avgVal.'</small>';
}elseif($avgVal >0 && $avgVal <= 5){
$span = '<small class="label bg-red" >'.$avgVal.'</small>';
}else{
$span = '<small class="label bg-green" >'.$avgVal.'</small>';
} ?>
<td data-toggle="tooltip" data-placement="bottom" title="Test Demo"><?php echo $span;?></td>
<?php
}
//overall average code//
$totalAvg += round($avgSum/$zeroRatings,2);
$totalAvgVer = $totalAvgVer + $totalAvg;
if($totalAvg <= 5){
$span = '<small class="label bg-red" >'.$totalAvg.'</small>';
}else{
$span = '<small class="label bg-green" >'.$totalAvg.'</small>';
}
?>
<script>
$("#oveAvg<?php echo $u.$i.$j?>").html('<?php echo $span ;?>');
</script>
</tr>
<div id="printThis" >
<div class="modal fade in" id="modal-default<?php echo $u.$i.$j;?>" style="display: none; padding-right: 17px;">
<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"> Remark</h4>
</div>
<div class="modal-body">
<?php foreach($rsParamIDS as $val) { ?>
<p> <b><?php echo $objReports->SelectBarisParamName($val);?> : </b>
<?php $remarkVal = $objReports->fetchContentRemark($val,$rsQuestionsInfo[$i][$j]['tokenid']);
echo $remarkVal;
?>
</p>
<?php } ?>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
<button id="btnPrint" type="button" class="btn btn-default">Print</button>
</div>
</div>
</div>
</div>
</div>
<?php $zeroTotalAvgVer++; ?>
<?php } } ?>
<?php }else{?>
<center> No date found</center>
<?php }
}
?>
<?php $totalAvgVer = round($totalAvgVer/$zeroTotalAvgVer,2);
if($totalAvgVer == 0){
$spanTotal = '<small class="label bg-gold" >'.$totalAvgVer.'</small>';
$spanTotalPer = '<small class="label bg-gold" >'.$totalAvgVer.'%</small>';
}elseif($totalAvgVer >0 && $totalAvgVer <= 5){
$spanTotal = '<small class="label bg-red" >'.$totalAvgVer.'</small>';
$spanTotalPer = '<small class="label bg-red" >'.(($totalAvgVer*100)/10).'%</small>';
}else{
$spanTotal = '<small class="label bg-green" >'.$totalAvgVer.'</small>';
$spanTotalPer = '<small class="label bg-green" >'.(($totalAvgVer*100)/10).'%</small>';
} ?>
<tfoot>
<tr>
<td colspan="4"> <div class="avg">Average</div> <div class="per_avg">Percentage</div></td>
<td><div class="avg"><?php echo $spanTotal;?></div><div class="per_avg"> <?php echo $spanTotalPer;?> </div> </td>
<?php
foreach($rsParamIDS as $val) {
$avgVal = $objReports->FetchParamAvg($val);
if($avgVal == 0){
$span = '<small class="label bg-gold" >'.$avgVal.'</small>';
}elseif($avgVal >0 && $avgVal <= 5){
$span = '<small class="label bg-red" >'.round($avgVal,2).'</small>';
}else{
$span = '<small class="label bg-green" >'.round($avgVal,2).'</small>';
}
if($avgVal == 0){
$spanPer = '<small class="label bg-gold" >'.$avgVal.'%</small>';
}elseif($avgVal >0 && $avgVal <= 5){
$spanPer = '<small class="label bg-red" >'.round((($avgVal*100)/10),2).'%</small>';
}else{
$spanPer = '<small class="label bg-green" >'.round((($avgVal*100)/10),2).'%</small>';
}?>
<td><div class="avg"><?php echo $span;?> </div><div class="per_avg"> <?php echo $spanPer;?></div></td>
<?php } ?>
</tr>
</tfoot>
</tbody>
<?php }else{?>
<!--<center> No date found</center>-->
<?php } ?>
</table>
<!--model-->
<?php }else{ ?>
<center> <img class="report_sch_img" src="<?php echo $curImagePath?>/dist/img/searchfeedback4.jpg" style="width:100%;"> </center>
<?php } ?>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<!-- jQuery 3 -->
<script src="<?php echo $curImagePath?>/bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="<?php echo $curImagePath?>/bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="<?php echo $curImagePath?>/bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src='<?php echo $curImagePath?>/datatable/js/dataTables.fixedColumns.min.js' charset="utf-8"></script>
<script src="<?php echo $curImagePath?>/datatable/js/jquery-3.3.1.js"></script>
<script src="<?php echo $curImagePath?>/datatable/js/jquery.dataTables.min.js"></script>
<script src="<?php echo $curImagePath?>/datatable/js/dataTables.buttons.min.js"></script>
<script src="<?php echo $curImagePath?>/datatable/js/buttons.flash.min.js"></script>
<script src="<?php echo $curImagePath?>/datatable/js/jszip.min.js"></script>
<script src="<?php echo $curImagePath?>/datatable/js/pdfmake.min.js"></script>
<script src="<?php echo $curImagePath?>/datatable/js/vfs_fonts.js"></script>
<script src="<?php echo $curImagePath?>/datatable/js/buttons.html5.min.js"></script>
<script src="<?php echo $curImagePath?>/datatable/js/buttons.print.min.js"></script>
<!-- SlimScroll -->
<script src="<?php echo $curImagePath?>/bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="<?php echo $curImagePath?>/bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="<?php echo $curImagePath?>/dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="<?php echo $curImagePath?>/dist/js/demo.js"></script>
<!-- page script -->
<script>
$(document).ready(function() {
$('#question_report').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 },
{ extend: 'excel', footer: true },
//{ extend: 'print', footer: true },//
]
} );
} );
</script>
<style>
.avg , .per_avg{
border-right: 1px solid #ddd;
}
.avg {
display: table;
}
@media print {
table#question_report {transform: scale(50);}
table {page-break-inside: avoid;}
}
.station_select {
margin-top: 8px;
}
</style>
<style>
.avg, .per_avg {
width: 100% !IMPORTANT;
display: table;
}
.avg {
line-height: 2;
}
.avg .label, .per_avg .label {
line-height: 2.5 !IMPORTANT;
}
tfoot tr td {
padding: 0px !IMPORTANT;
margin: 0px !IMPORTANT;
}
label.control-label.station_select {
float: left;
}
table#question_report {
margin: 0px;
width: 100% !IMPORTANT;
}
tfoot {
background: #cacaca;
}
.dt-buttons button {
background: #e8e8e8;
border: 1px solid #d2d2d2;
}
td, th {
text-align: center;
}
input[type="search"] {
border: 1px solid #DDD;
padding: 5px 0;
border-radius: 5px;
}
thead {
background: #3c8dbc;
color: #FFF;
}
.date_pikars {
height: 35px;
border: 1px solid #d2d6de;
font-size: 15px;
padding: 5px 0;
}
span.date_info {
font-size: 18px;
margin-right: 10px;
}
.date_s_frome ,.date_s_to {
float: left;
margin-right: 19px;
}
tfoot tr th {
text-align: center;
}
small.label.bg-gold {
background: #d0a110;
}
</style>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">
<link rel='stylesheet' type='text/css' href='<?php echo $curImagePath?>/datepikar2/datepicker3.css' >
<link rel='stylesheet' type='text/css' href='<?php echo $curImagePath?>/datepikar2/daterangepicker-bs3.css' >
<script src="<?php echo $curImagePath?>/datepikar2/bootstrap-datepicker.js"></script>
<script src="<?php echo $curImagePath?>/datepikar2/daterangepicker.js"></script>
<script src="<?php echo $curImagePath?>/datepikar2/moment.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>
<style>
@media screen {
#printSection {
display: none;
}
}
#printSection button {display:none;}
@media print {
.modal-open {
visibility:hidden;
}
#printSection, #printSection * {
visibility:visible;
width:100%;
margin:0 auto;
}
#printSection p {font-size:30px;}
#printSection {
position:absolute;
left:0;
top:0;
}
}
table.dataTable thead .sorting_asc {
background-image: url(<?php echo $curImagePath?>/dist/img/sort_asc.png) !IMPORTANT;
}
table.dataTable thead .sorting_desc {
background-image: url(<?php echo $curImagePath?>/dist/img/sort_desc.png) !IMPORTANT;
}
table.dataTable thead .sorting {
background-image: url(<?php echo $curImagePath?>/dist/img/sort_both.png) !IMPORTANT;
}
</style>
<script>
document.getElementById("btnPrint").onclick = function () {
printElement(document.getElementById("printThis"));
}
function printElement(elem) {
var domClone = elem.cloneNode(true);
var $printSection = document.getElementById("printSection");
if (!$printSection) {
var $printSection = document.createElement("div");
$printSection.id = "printSection";
document.body.appendChild($printSection);
}
$printSection.innerHTML = "";
$printSection.appendChild(domClone);
window.print();
}
</script>
<script>
$(document).ready(function(){
$('[data-toggle="tooltip"]').tooltip();
});
</script>