File: /home/barbeatleanalyti/public_html/baris.beatleanalytics.com/site/template/equipments.php
<!DOCTYPE html>
<?php
// Declare new object
$objScorecardctsnew = object;
// Assing object
$objScorecardctsnew = $objDB->objController;
// Assign all variable's value
$pg = $objScorecardctsnew->pg;
$acn = $objScorecardctsnew->acn;
$v = $objScorecardctsnew->v;
$State = $objScorecardctsnew->State;
$ReligionName = $objScorecardctsnew->ReligionName;
$sort = $objScorecardctsnew->sort;
$ReligionID = $objScorecardctsnew->ReligionID;
$field = $objScorecardctsnew->field;
$error = $objScorecardctsnew->error;
$msg = $objScorecardctsnew->msg;
$perpage = $objScorecardctsnew->perpage;
$start = $objScorecardctsnew->start;
$limit = $objScorecardctsnew->limit;
$SearchValue = $objScorecardctsnew->SearchValue;
$s = $objScorecardctsnew->s;
$CustomerID = $objScorecardctsnew->CustomerID;
$SurveyID = $objScorecardctsnew->SurveyID;
$TokenID = $objScorecardctsnew->TokenID;
$pType = $objScorecardctsnew->pType;
$OrgID = $objScorecardctsnew->OrgID;
$BranchID = $objScorecardctsnew->BranchID;
$IndustryID = $objScorecardctsnew->IndustryID;
$FromDate = $objScorecardctsnew->FromDate;
$ToDate = $objScorecardctsnew->ToDate;
$StationId = $objScorecardctsnew->StationId;
$QuestionId = $objScorecardctsnew->QuestionId;
$AuditorId = $objScorecardctsnew->AuditorId;
$Year = $objScorecardctsnew->Year;
$valck[] = array();
//echo '<pre>'; print_r($userdata[0]['reportType']); die;
if(!in_array('EQP', explode(',', $userdata[0]['reportType']))){
ReturnPostFormData($ValidateArr = array(),"error.html","<span class='error-msg'>Method <strong>".$acn."</strong> does not exist in <strong>".$pg."</strong> file !</span>",2);
}
?>
<!-- jQuery 3 -->
<script src="<?php echo $curImagePath?>/bower_components/jquery/dist/jquery.min.js"></script>
<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">-->
<link rel="stylesheet" href="<?php echo $curImagePath?>/dist/css/Custom.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?>/dist/js/jQuery.print.min.js"></script>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-body">
<form method="post" action="pmcsurprisesummary.html" name="frmSearch_filter" id="frmSearch_filter" class="pe-no-print" style="display:block;">
<div class="box-header">
<h3 class="box-title" style="width:100%;">
<div class="form-group">
<div class="col-md-4"><a class="btn btn-info btn-sm" href="dashboard.html"> <i class="fa fa-long-arrow-left"></i> Back </a></div>
<?php /**<div class=" col-xs-12 col-md-3 col-lg-2 form-group">
<select class="form-control input-md" id="year" name="Year">
<?php
$firstYear = 2020;
$lastYear = (int)date('Y');
for($i=$firstYear;$i<=$lastYear;$i++){
echo '<option value='.$i.'>'.$i.'</option>';
}?>
</select>
</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>
<?php if ($userdata[0]['db_usertype'] != 'viewer' ){ ?>
<a class="btn btn-success btn-sm dailytarget" href="equipmentstarget.html"> Set Target </a>
<a class="btn btn-success btn-sm dailytarget" href="deliveredequipments.html"> Delivered Equipments </a>
<?php } ?>
</span>
</div>
<div class="col-md-4"></div>
</div>
</h3>
</div>
</form>
<div class="NEWCTS">
<!---<div class="fixed-btn">
<div class="table_print- pe-no-print">
<form name="myform" class="print_cheked">
<button type="button" class="print print_btn" >Print All</button>
<input type="checkbox" name="mybox" checked="" style="display: none;">
</form>
</div>
</div>--->
<?php
$rsStation = $objScorecardctsnew->fetchStation();
$rsPagesIDS = SubQuestionGroupIDS('pages',$rsStation[0]['paramId']);
// echo "<pre>";
// print_r($rsPagesIDS);
// die;
?>
<div class="printTable pe-preserve-ancestor" id="printTable">
<br>
<table cellspacing="0" border="0" style=" margin:0 auto;">
<colgroup width="64"></colgroup>
<colgroup width="412"></colgroup>
<colgroup span="2" width="64"></colgroup>
<colgroup width="123"></colgroup>
<colgroup width="90"></colgroup>
<tr class="no_br report_header2">
<td colspan="28" align="center" valign="bottom"> NORTH EASTERN RAILWAY </td>
</tr>
<?php if ($_SESSION['UserInfo']['OrgID'] == 17 || $_SESSION['UserInfo']['OrgID'] == 18) { ?>
<tr class="no_br report_header2">
<td colspan="28" height="28" align="center" valign="bottom"><span class="report_name"> EQUIPMENTS - TARGETS FOR 1 YEARS </span> </td>
</tr>
<?php }
else { ?>
<tr class="no_br report_header2">
<td colspan="28" height="28" align="center" valign="bottom"><span class="report_name"> EQUIPMENTS - TARGETS FOR 4 YEARS </span> </td>
</tr>
<?php } ?>
<tr class="no_br report_header2 " style="border-bottom: 1px solid #bfbfbf;">
<td colspan="28" align="center" valign="bottom">
</td>
</tr>
<tr class="no_br">
<td height="100" style=" height: 12px !important;"></td>
</tr>
<tr style="background:#ddd;">
<td height="19">S.No</td>
<td>Description Of Material</td>
<td>Traget</td>
<td>Units</td>
<td>Achieved</td>
<td>Deficit</td>
<?php foreach ($rsPagesIDS as $rsPages) {
$rsDeliverData = $objScorecardctsnew->FetchDeliveredData($rsStation[0]['stationId'],$rsStation[0]['paramId'],$rsPages);
foreach ($rsDeliverData as $key => $value) { ?>
<td>Delivered<br><?php echo date('d/m/Y', strtotime($value['created_date'])); ?></td>
<?php } break;
} ?>
</tr>
<?php
$no = 1;
foreach ($rsPagesIDS as $rsPages) {
$rsPagesData = $objScorecardctsnew->getPagesData($rsPages);
$rsTargetData = $objScorecardctsnew->getTarget($rsPages);
$rsDeliverData = $objScorecardctsnew->FetchDeliveredData($rsStation[0]['stationId'],$rsStation[0]['paramId'],$rsPages);
//echo '<pre>'; print_r($rsDeliverData);
?>
<tr>
<td height="19" sdval="1" sdnum="1033;"><?php echo $no++; ?></td>
<td><?php echo $rsPagesData[0]['db_pagename']; ?></td>
<td sdval="100" sdnum="1033;"><?php echo $rsTargetData[0]['value']; ?></td>
<td><?php echo $rsPagesData[0]['db_pageChoice2']; ?></td>
<td sdval="80" sdnum="1033;" id="achieved<?php echo $rsPages ?>">80</td>
<td sdval="20" sdnum="1033;" id="delivered<?php echo $rsPages ?>">20</td>
<?php
$totalDel = 0;
foreach ($rsDeliverData as $key => $value) {
$totalDel = $totalDel + $value['db_surveyValue'];
?>
<td sdval="20" sdnum="1033;"><?php echo $value['db_surveyValue'] ?></td>
<?php }
$totalDiff = $rsTargetData[0]['value'] - $totalDel;
if($rsTargetData[0]['value'] != 0){
// $totalAchi = round(($totalDiff/$rsTargetData[0]['value'])*100,2);
$totalAchi = round(($totalDel/$rsTargetData[0]['value'])*100,2);
} else{
$totalAchi = 0;
}
?>
</tr>
<script type="text/javascript">$("#achieved<?php echo $rsPages ?>").text("<?php echo $totalAchi; ?>%")</script>
<script type="text/javascript">$("#delivered<?php echo $rsPages ?>").text("<?php echo $totalDiff; ?>")</script>
<?php
}
?>
</table>
</div>
</div>
</div>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
<!-- /.col -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<!-- Bootstrap 3.3.7 -->
<script src="<?php echo $curImagePath?>/bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- DataTables -->
<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/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 for demo purposes -->
<script src="<?php echo $curImagePath?>/dist/js/demo.js"></script>
<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>
$('#year').val('<?php echo $Year ?>');
$(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>
<!---creat_new_page_print--->
<script>
function breakeveryheader() {
if (!document.getElementById) {
alert("You need IE5 or NS6 to run this example")
return
}
var thestyle = (document.forms.myform.mybox.checked) ? "always" : "auto"
for (i = 0; i < document.getElementsByClassName("creat_new_page_print").length; i++)
document.getElementsByClassName("creat_new_page_print")[i].style.pageBreakBefore = thestyle
}
</script>
<script>
$('.print_btn').on('click', function() { // select print button with class "print," then on click run callback function
breakeveryheader();
$.print("#printTable"); // inside callback function the section with class "content" will be printed
});
</script>
<!--//creat_new_page_print -->
<style>
@media print {
.new_print_display { page-break-after: always; }
}
@page { size: A4; }
</style>