File: /home/barbeatleanalyti/public_html/barisnew.beatleanalytics.com/site/template/mcc.php
<?php
set_time_limit(0);
?>
<!DOCTYPE html>
<?php
// Declare new object
$objScorecardmcc = object;
// Assing object
$objScorecardmcc = $objDB->objController;
// Assign all variable's value
$pg = $objScorecardmcc->pg;
$acn = $objScorecardmcc->acn;
$v = $objScorecardmcc->v;
$State = $objScorecardmcc->State;
$ReligionName = $objScorecardmcc->ReligionName;
$sort = $objScorecardmcc->sort;
$ReligionID = $objScorecardmcc->ReligionID;
$field = $objScorecardmcc->field;
$error = $objScorecardmcc->error;
$msg = $objScorecardmcc->msg;
$perpage = $objScorecardmcc->perpage;
$start = $objScorecardmcc->start;
$limit = $objScorecardmcc->limit;
$SearchValue = $objScorecardmcc->SearchValue;
$s = $objScorecardmcc->s;
$CustomerID = $objScorecardmcc->CustomerID;
$SurveyID = $objScorecardmcc->SurveyID;
$TokenID = $objScorecardmcc->TokenID;
$pType = $objScorecardmcc->pType;
$OrgID = $objScorecardmcc->OrgID;
$BranchID = $objScorecardmcc->BranchID;
$IndustryID = $objScorecardmcc->IndustryID;
$FromDate = $objScorecardmcc->FromDate;
$ToDate = $objScorecardmcc->ToDate;
$StationId = $objScorecardmcc->StationId;
$QuestionId = $objScorecardmcc->QuestionId;
$AuditorId = $objScorecardmcc->AuditorId;
$valck[] = array();
if(!in_array('RBPC', 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">
<!-- 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="mcc.html" name="frmSearch" id="frmSearch" class="pe-no-print">
<div class="box-header">
<h3 class="box-title" style="width:100%;">
<div class="form-group" >
<?php $rsStation = $objScorecardmcc->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 = $objScorecardmcc->FetchQuestion(); ?>
<option value="0">Select Question </option>
<option selected="selected" value="10">RBPC</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">
<?php $rsAuditor = $objScorecardmcc->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',12);
// //echo implode(',', $rsPagesIDS);die();
// $rsParamIDS = QuestionGroupIDS('params',$QuestionId);
// $rsParamIDS = SubQuestionGroupIDS('params',$QuestionId);//subquestion
// // echo $rsParamIDS[0];
// $rsPagesIDS = SubQuestionGroupIDS('pages',$rsParamIDS[0]);
$rsUserInfo = $objScorecardmcc->FetchUsersData();
?>
<div class="NEWCTS">
<div class="fixed-btn">
<a href="rbpcscorecardsummary.html" class="btn summary-btn" target="_blank">RBPC - Summary </a>
<div class="table_print- pe-no-print">
<form name="myform" class="print_cheked">
<button type="button" class="print print_btn" >Print All</button>
<!-- onClick="breakeveryheader()" -->
<input type="checkbox" name="mybox" checked="" style="display: none;">
</form>
</div>
</div>
<div class="printTable pe-preserve-ancestor" id="printTable">
<?php
//$no = 1;
$totalAvgVer = 0;
$zeroTotalAvgVer = 0;
if(count($rsUserInfo)>0){
for ($u=0;$u< count($rsUserInfo);$u++)
{
// $rsQuestionsInfo = $objScorecardmcc->FetchQuestionsData($rsUserInfo[$u]['db_surveyUserid']);
$rsQuestionsInfo = $objScorecardmcc->FetchQuestionsData($rsUserInfo[$u],$rsPagesIDS);
if(count($rsQuestionsInfo)>0){
$idArr = array();
for ($i=0;$i< count($rsQuestionsInfo);$i++)
{
$noofcoach_attended =0;
// echo "<pre>";
// print_r($rsQuestionsInfo[$i]);
?>
<div class="creat_new_page_print"></div>
<table id="" class="display-- new_print_display" style="width:100%; ">
<colgroup width="50"></colgroup>
<colgroup width="900"></colgroup>
<colgroup width="900"></colgroup>
<colgroup span="25" width="50"></colgroup>
<tr class="no_br report_header2">
<td colspan="28" height="28" align="center" valign="bottom"> NORTH EASTERN RAILWAY </td>
</tr>
<tr class="no_br report_header2">
<td colspan="28" height="28" align="center" valign="bottom"><span class="report_name">"Score Card Platform Turnaround/RBPC Rake Cleaning"</span> </td>
</tr>
<tr class="no_br report_header2 " style="border-bottom: 1px solid #bfbfbf;">
<td colspan="28" height="28" align="center" valign="bottom">
SCORE CARD (TO BE FILED BY THE DEPOT HOUSE KEEPING INSPECTOR) </td>
</tr>
<tr class="no_br"><td height="100" style=" height: 5px !important;"></td></tr>
<tr class="no_br report_header2">
<td colspan="28" height="28" align="center" valign="bottom">
Agremment No:<span class="t_nas" id="">xxxxx</span>
Dated:<span class="t_nas" id="">xx-xx-xxxx</span>
Name of Contractor :<span class="t_nas" id=""><?php echo $objScorecardmcc->getcommondata('baris_organization','db_Orgname','OrgID',$rsQuestionsInfo[$i][0]['OrgID']) ?></span>
Date of inspection:<span class="t_nas" id="dateofinspection<?php echo $u.$i;?>">xxxxxx</span>
Name of Depot:<span class="t_nas" id="score_inaccessible00"><?php echo $objScorecardmcc->getcommondata('baris_station','stationName','stationId',$rsQuestionsInfo[$i][0]['db_surveyStationId']) ?></span>
Train No :<span class="t_nas" id="trainno<?php echo $u.$i;?>">xxxxx</span>
</td>
</tr>
<tr class="no_br report_header2">
<td colspan="28" height="28" align="center" valign="bottom">
Name Of Supervisor:<span class="t_nas" id="auditorname<?php echo $u.$i;?>">xxxxxxx</span>
Time Work Started :<span class="t_nas" id="deptime<?php echo $u.$i;?>"></span>
Time work Completed :<span class="t_nas" id="timeworkcompleted<?php echo $u.$i;?>"></span>
No. of Caches in the reke:<span class="t_nas" id="noofcoach_intrain<?php echo $u.$i;?>">xxxxxx</span>
No. of Coaches attended<span class="t_nas" id="noofcoach_attended<?php echo $u.$i;?>">xxxxxxxx</span>
Division :<span class="t_nas" id=""><?php echo $objScorecardmcc->getcommondata('baris_division','DivisionName','DivisionId',$rsQuestionsInfo[$i][0]['DivisionId']) ?></span>
Overall score :<span class="t_nas" id="totalscore_obtained<?php echo $u.$i;?>"></span>
</td>
</tr>
<tr class="no_br"><td height="100" style=" height: 12px !important;"></td></tr>
<tr>
<td height="20" valign=center>S.N.</td>
<td colspan=2 align="center" valign=center>Coach Srl No</td>
<td valign=center><br></td>
<?php
$rsCoachList = $objScorecardmcc->FetchCoachList($rsQuestionsInfo[$i][0]['tokenid']);
for ($c=0;$c < 24;$c++){?>
<td sdval="<?php echo $c+1; ?>" sdnum="1033;"> C<?php echo $c+1; ?> <span class="c_num"><br><?php echo wordwrap(str_replace($rsCoachList[$c][0]." ","",$rsCoachList[$c][1]),6,"<br>\n",TRUE);?></span> </td>
<?php } ?>
</tr>
<tr>
<td height="20" valign=center><br></td>
<td valign=top>Itemized Description of work</td>
<td valign=top>Coach Type--></td>
<td valign=top><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
<td valign=center><br></td>
</tr>
<?php
$no = 1;
$tokenid = "";
$totalCountOfOne = 0;
$totalCount = 0;
$totalRatingBox = 0;
$inaccessibleCount = 0;
for ($j=0;$j< count($rsQuestionsInfo[$i]);$j++)
{
$tokenid = $rsQuestionsInfo[$i][$j]['tokenid'];
$fixPageID_T = array("35", "36", "37", "38");
$fixPageID_BD = array("27", "28", "29", "30");
//for toilet column
$fixPageID2 = array("31", "32", "33","34");?>
<tr>
<?php if($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 35){ ?>
<td rowspan=4 height="80" sdval="1" sdnum="1033;">1 </td>
<?php } ?>
<?php if($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 39){ ?>
<td height="20" valign=center sdval="2" sdnum="1033;">2</td>
<?php } ?>
<?php if($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 27){ ?>
<td height="20" valign=center sdval="3" sdnum="1033;">3</td>
<?php } ?>
<?php if($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 40){ ?>
<td height="39" valign=center sdval="4" sdnum="1033;">4</td>
<?php } ?>
<?php if($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 41){ ?>
<td height="20" valign=center sdval="5" sdnum="1033;">5</td>
<?php } ?>
<?php if ($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 35){?>
<td colspan=2 rowspan=4 valign=center>Toilet cleaning-side panels,amenity fittings <br>& washbasin and drying</td>
<?php }elseif ($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 39) {?>
<td colspan=2 valign=center>Watering of coaches</td>
<?php }elseif($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 27){?>
<td colspan=2 valign=center>Cleaning of Berths/Seats/Recks in Coaches</td>
<?php }elseif($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 40){?>
<td colspan=2 valign=center>Interior Floor particularly the areas below<br>the lower berth & Aisle portion</td>
<?php }elseif($rsQuestionsInfo[$i][$j]['db_surveyPageId'] == 41){?>
<td colspan=2 valign=center>Vestibules</td>
<?php }?>
<td>
<?php echo $objScorecardmcc->SelectBarisPageName($rsQuestionsInfo[$i][$j]['db_surveyPageId']);?>
</td>
<?php
$totalScore = 0;
//$rsCoachList = $objScorecardmcc->FetchCoachList($rsQuestionsInfo[$i][0]['tokenid']);
// echo "<pre>";
// print_r($rsCoachList);
//die;
// for ($c=0;$c< count($rsCoachList);$c++)
for ($c=0;$c < 24;$c++)
{
/*}
foreach($rsParamIDS as $val) {*/
if(count($rsCoachList) > $c){
$avgVal = $objScorecardmcc->FetchValueScore($rsQuestionsInfo[$i][$j]['db_surveyQuestionId'],'',$rsQuestionsInfo[$i][$j]['db_surveyPageId'],$rsQuestionsInfo[$i][$j]['tokenid'],$rsCoachList[$c][0]);
$totalRatingBox++;
if($avgVal != "-"){
$totalCount++;
$totalCountOfOne = $totalCountOfOne + $avgVal;
}
}else{
$avgVal ="-";
}
if($rsQuestionsInfo[$i][$j]['db_totalCoachCount'] <= $c)
$avgVal ="";
?>
<td sdval="<?php echo $avgVal;?>" sdnum="1033;"><?php echo $avgVal;?></td>
<?php } ?>
</tr>
<script>
$("#dateofinspection<?php echo $u.$i;?>").html('<?php echo date("Y-m-d",strtotime($rsQuestionsInfo[$i][$j]['created_date']));?>');
//$("#timeworkcompleted<?php echo $u.$i;?>").html('<?php echo date("h:m",strtotime($rsQuestionsInfo[$i][$j]['created_date']));?>');
$("#auditorname<?php echo $u.$i;?>").html('<?php echo $rsQuestionsInfo[$i][$j]['db_username'];?>');
$("#trainno<?php echo $u.$i;?>").html('<?php echo $rsQuestionsInfo[$i][$j]['db_trainno'];?>');
//$("#deptime<?php echo $u.$i;?>").html('<?php echo $rsQuestionsInfo[$i][$j]['db_depart_time'];?>');
$("#noofcoach_intrain<?php echo $u.$i;?>").html('<?php echo $rsQuestionsInfo[$i][$j]['db_totalCoachCount'];?>');
$("#totalscore_obtained<?php echo $u.$i;?>").html('<?php echo round(($totalCountOfOne/$totalCount)*10,2); ?>%');
//$("#score_inaccessible<?php echo $u.$i;?>").html('<?php echo round(($inaccessibleCount/$totalRatingBox)*100,2); ?>%');
</script>
<?php } ?>
<?php
$vertiScoreZero1 = 0;
$vertiScoreX1 = 0;
for ($c=0;$c < 24;$c++){
$vertiScoreZero = 0;
$vertiScoreX = 0;
if(!empty($rsCoachList[$c][0])){
for ($j=0;$j< count($rsQuestionsInfo[$i]);$j++)
{
$avgVal = $objScorecardmcc->FetchValueScore($rsQuestionsInfo[$i][$j]['db_surveyQuestionId'],'',$rsQuestionsInfo[$i][$j]['db_surveyPageId'],$rsQuestionsInfo[$i][$j]['tokenid'],$rsCoachList[$c][0]);
if($avgVal == "0"){
$vertiScoreZero++;
}
if($avgVal == "-"){
$vertiScoreX++;
}
}
if($vertiScoreZero==8){
$vertiScoreZero1++;
}
if($vertiScoreX==8){
$vertiScoreX1++;
}
}
?>
<?php }
//echo "zeros".$vertiScoreZero1;
//echo "xs".$vertiScoreX1;
?>
<script type="text/javascript">
$("#noofcoach_attended<?php echo $u.$i;?>").html('<?php echo count($rsCoachList)-($vertiScoreZero1+$vertiScoreX1);?>');
</script>
<tr>
<td height="20" valign=center><br></td>
<td colspan=2 valign=top>Total Marks</td>
<td valign=center><br></td>
<?php for ($c=0;$c < 24;$c++){
$vertiScoreOne = 0;
for ($j=0;$j< count($rsQuestionsInfo[$i]);$j++)
{
$avgVal = $objScorecardmcc->FetchValueScore($rsQuestionsInfo[$i][$j]['db_surveyQuestionId'],'',$rsQuestionsInfo[$i][$j]['db_surveyPageId'],$rsQuestionsInfo[$i][$j]['tokenid'],$rsCoachList[$c][0]);
// if($avgVal == "1" || $avgVal == "X"){
if($avgVal != "-"){
$vertiScoreOne = $vertiScoreOne + $avgVal;
}
}
if(empty($rsCoachList[$c][0])){
$vertiScoreOne = "";
}
?>
<td sdval="0" sdnum="1033;"><?php echo $vertiScoreOne; ?></td>
<?php } ?>
</tr>
<tr>
<td height="20" valign=center><br></td>
<td colspan=2 valign=top>% Payments</td>
<td valign=center><br></td>
<?php
$noofcoach_nill = 0;
$noofcoach_10 = 0;
$noofcoach_20 = 0;
$noofcoach_nopay = 0;
?>
<?php for ($c=0;$c < 24;$c++){
$vertiScoreOne = 0;
$vertiScore = 0;
for ($j=0;$j< count($rsQuestionsInfo[$i]);$j++)
{
$avgVal = $objScorecardmcc->FetchValueScore($rsQuestionsInfo[$i][$j]['db_surveyQuestionId'],'',$rsQuestionsInfo[$i][$j]['db_surveyPageId'],$rsQuestionsInfo[$i][$j]['tokenid'],$rsCoachList[$c][0]);
if($avgVal != "-"){
$vertiScoreOne++;
$vertiScore = $vertiScore + $avgVal;
}
}
if(empty($rsCoachList[$c][0])){
$vertiScoreAvg = "";
}else{
$vertiScoreAvg = round($vertiScore*10/$vertiScoreOne,2)."%";
if($vertiScoreAvg > 90){
// $vertiScoreAvg = "100%";
$noofcoach_nill++;
}elseif($vertiScoreAvg >= 80){
// $vertiScoreAvg = "90%";
$noofcoach_10++;
}elseif($vertiScoreAvg >= 70){
// $vertiScoreAvg = "80%";
$noofcoach_20++;
}else{
// $vertiScoreAvg = "0%";
$noofcoach_nopay++;
}
//$vertiScoreOne = $vertiScoreOne*100/8;
// if($vertiScoreOne == 8){
// $vertiScoreOne = "100%";
// }elseif($vertiScoreOne == 7){
// $vertiScoreOne = "90%";
// }elseif($vertiScoreOne == 6){
// $vertiScoreOne = "80%";
// }else{
// $vertiScoreOne = "0%";
// }
}
?>
<td sdval="0" sdnum="1033;"><?php echo $vertiScoreAvg; ?></td>
<?php } ?>
<?php
$paydue_nill = round($noofcoach_nill*231.74676,2);
$paydue_10 = round($noofcoach_10*(231.74676-(231.74676*10/100)),2);
$paydue_20 = round($noofcoach_20*(231.74676-(231.74676*20/100)),2);
$finalPayment = round($paydue_nill+$paydue_10+$paydue_20,2);
?>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" colspan=28 height="20" align="center" valign=center> </td>
</tr>
<tr>
<td height="20" valign=center>S.N.</td>
<td colspan=6 valign=center>Overall Rating</td>
<td colspan=21 valign=center>Penalty if any</td>
</tr>
<tr>
<td height="20" valign=center>i</td>
<td colspan=6 valign=center>More than 90%</td>
<td colspan=21 valign=center>No panalty</td>
</tr>
<tr>
<td height="20" valign=center>ii</td>
<td colspan=6 valign=center>80-90%</td>
<td colspan=21 valign=center>10% of the accepted rate/coach will be recovered from the bills for no. of coaches in that rake.</td>
</tr>
<tr>
<td height="20" valign=center>iii</td>
<td colspan=6 valign=center>70-80%</td>
<td colspan=21 valign=center>20% of the accepted rate/coach will be recovered from the bills for no. of coaches in that rake.</td>
</tr>
<tr>
<td height="20" valign=center>iv</td>
<td colspan=6 valign=center>Less than 70%</td>
<td colspan=21 valign=center>No payment will be allowed for that rake for the day.</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000" colspan=28 height="20" align="center" valign=center></td>
</tr>
<tr>
<td height="20" valign=center>S.N.</td>
<td colspan=3 valign=center>Overall Rating</td>
<td colspan=10 valign=center>Penalty</td>
<td colspan=4 valign=center>No of Coaches in rake</td>
<td colspan=10 valign=center>Payment due for the Rake d x (accepted rate-c)</td>
</tr>
<tr>
<td height="20" valign=center>a</td>
<td colspan=3 valign=center>b</td>
<td colspan=10 valign=center>c</td>
<td colspan=4 valign=center>d</td>
<td colspan=10 valign=center>e</td>
</tr>
<tr>
<td height="20" valign=center>i</td>
<td colspan=3 valign=center>More than 90%</td>
<td colspan=10 valign=center>Nil</td>
<td colspan=4 align="center" valign=center><?php echo $noofcoach_nill; ?></td>
<td colspan=10 valign=center><?php echo $paydue_nill; ?></td>
</tr>
<tr>
<td height="20" valign=center>ii</td>
<td colspan=3 valign=center>81-90%</td>
<td colspan=10 valign=center>10 % of the accepted rate per coach</td>
<td colspan=4 align="center" valign=center><?php echo $noofcoach_10; ?></td>
<td colspan=10 valign=center><?php echo $paydue_10; ?></td>
</tr>
<tr>
<td height="20" valign=center>iii</td>
<td colspan=3 valign=center>70-80%</td>
<td colspan=10 valign=center>20% of the accepted rate per coach</td>
<td colspan=4 align="center" valign=center><?php echo $noofcoach_20; ?></td>
<td colspan=10 valign=center><?php echo $paydue_20; ?></td>
</tr>
<tr>
<td height="20" valign=center>iv</td>
<td colspan=3 valign=center>70% or less</td>
<td colspan=10 valign=center>No payment</td>
<td colspan=4 align="center" valign=center><?php echo $noofcoach_nopay; ?></td>
<td colspan=10 valign=center>0</td>
</tr>
<tr>
<td height="20" valign=center><br></td>
<td colspan=3 align="center" valign=center><br></td>
<td colspan=10 align="center" valign=center><br></td>
<td colspan=4 valign=center><br></td>
<td colspan=10 valign=center>TOTAL Rs : <?php echo $finalPayment; ?></td>
</tr>
<tr class="no_br report_header2" style="">
<td colspan="28" height="28" align="center" valign="bottom" style=" padding-top: 10px !important;">
<span class="t_nas" id="" style=" padding: 5px 32px; margin-right: 20%;">Sig. Rly Contractor </span>
<span class="t_nas" id="" style="padding: 5px 32px; margin-left: 20%;">Sig. Rly Authority</span>
</td>
</tr>
</table>
<?php }
}
}
}else{
echo "<center>No Data Found</center>";
}?>
</div>
</div>
<?php }else{ ?>
<!----NEWCTS-start---->
<center>
<img class="report_sch_img" src="http://baris.beatleanalytics.com/theme/black/dist/img/searchfeedback4.jpg"
style="width:100%;"> </center>
<!----NEWCTS-End---->
<?php } ?>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</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>
<!-- page script -->
<script>
$(document).ready(function() {
/** $('#question_report').append('<caption style="caption-side: bottom">A fictional company\'s staff table.</caption>');
$('#question_report').append('<caption style="caption-side: top">A fictional company\'s staff table.</caption>');****/
$('#question_report').DataTable({
scrollY: "900px",
scrollX: true,
footer: 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: 'print',
footer: true,
messageTop: '<center class="print_title" style="font-size: 20px;"><p><span style=" margin-right: 30px;">Date of Inspection : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">02/01/2020</b></span><span style=" margin-right: 30px;">Auditor : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">gautam prajapati</b></span><span style=" margin-right: 30px;">Train No. : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">54820</b></span> <span style=" margin-right: 30px;">Dep.Time : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">5:50</b></span> </p><p><span style=" margin-right: 30px;">No.of Coaches Attended by contractor : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">224</b></span> <span style=" margin-right: 30px;">Total No. of Coaches in the train : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">24</b></span> </p> <p><span style=" margin-right: 30px;">Total Scores obtained : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">80%</b></span><span style=" margin-right: 30px;">Inaccessible : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">10%</b></span></p></center>',
messageBottom: '<BR><BR><P style="width:80%; margin:0 auto; font-size: 20px;"><span class="pull-left" style=" border-bottom: 1px solid #656565dd; height: 49px; padding: 0 84px 0 84px; float: left !IMPORTANT;">Sig. Rly Authority----</span><span class="pull-right" style=" border-bottom: 1px solid #656565dd; height: 49px; padding: 0 84px 0 84px; float: right !IMPORTANT;">Sig. Rly Contractor---</span></P> '
},
]
});
});
</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>
<!---16-3-2020--->
<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>
<!--//creat_new_page_print -->
<script>
$(document).ready(function() {
/** $('#question_report').append('<caption style="caption-side: bottom">A fictional company\'s staff table.</caption>');
$('#question_report').append('<caption style="caption-side: top">A fictional company\'s staff table.</caption>');****/
$('.display').DataTable({
scrollY: "900px",
scrollX: true,
footer: true,
scrollCollapse: true,
paging: false,
dom: 'Bfrtip',
buttons: [{
extend: false,
footer: true
},
{
extend: 'print',
footer: true,
messageTop: '<center class="print_title" style="font-size: 20px;"><p><span style=" margin-right: 30px;">Date of Inspection : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">02/01/2020</b></span><span style=" margin-right: 30px;">Auditor : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">1</b></span><span style=" margin-right: 30px;">Train No. : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">54820</b></span> <span style=" margin-right: 30px;">Dep.Time : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">5:50</b></span> </p><p><span style=" margin-right: 30px;">No.of Coaches Attended by contractor : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">224</b></span> <span style=" margin-right: 30px;">Total No. of Coaches in the train : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">24</b></span> </p> <p><span style=" margin-right: 30px;">Total Scores obtained : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">80%</b></span><span style=" margin-right: 30px;">Inaccessible : <b style=" border-bottom: 1px solid;padding: 0 33px 0 4px;">10%</b></span></p></center>',
messageBottom: '<p><b>Note : </b> Please give marks for each item as either 0 or 1 or X "_". All items as above which are inaccessible should be marked "X" and shall not be counted in total score </p><br><p> <b>Item not available should be marked "_". No column should be left blank</b> </p> <p class="reason_w100" style=" width: 100%; display: inline-block"><div class="cn_reason" style="float: left; width:23%;padding: 0px;margin: 0 16px 0 0;border: 1px solid #ddd;height: 70px;text-align: left;"><div class="c_num" style="border: none; float: left; text-align: left; width: 85px; MARGIN: 0PZ; margin: 0px; padding: 5px 3px 4px 5px; height: 23px;">Coach No : </div ><div class="c_reason" style="float: left; width: 76px; padding: 0px; margin: 0px; height: 20px;border-bottom: 1px solid #656565dd;"></div> </div><div class="cn_reason" style="float: left; width:23%;padding: 0px;margin: 0 16px 0 0;border: 1px solid #ddd;height: 70px;text-align: left;"><div class="c_num" style="border: none; float: left; text-align: left; width: 85px; MARGIN: 0PZ; margin: 0px; padding: 5px 3px 4px 5px; height: 23px;">Coach No : </div ><div class="c_reason" style="float: left; width: 76px; padding: 0px; margin: 0px; height: 20px;border-bottom: 1px solid #656565dd;"></div> </div><div class="cn_reason" style="float: left; width:23%;padding: 0px;margin: 0 16px 0 0;border: 1px solid #ddd;height: 70px;text-align: left;"><div class="c_num" style="border: none; float: left; text-align: left; width: 85px; MARGIN: 0PZ; margin: 0px; padding: 5px 3px 4px 5px; height: 23px;">Coach No : </div ><div class="c_reason" style="float: left; width: 76px; padding: 0px; margin: 0px; height: 20px;border-bottom: 1px solid #656565dd;"></div> </div><div class="cn_reason" style="float: left; width:23%;padding: 0px;margin: 0 16px 0 0;border: 1px solid #ddd;height: 70px;text-align: left;"><div class="c_num" style="border: none; float: left; text-align: left; width: 85px; MARGIN: 0PZ; margin: 0px; padding: 5px 3px 4px 5px; height: 23px;">Coach No : </div ><div class="c_reason" style="float: left; width: 76px; padding: 0px; margin: 0px; height: 20px;border-bottom: 1px solid #656565dd;"></div> </div></p> <BR><BR><P style="padding-top: 50px; width:80%; margin:0 auto; font-size: 20px;"><span class="pull-left" style=" border-bottom: 1px solid #656565dd; height: 49px; padding: 0 84px 0 84px; float: left !IMPORTANT;">Sig. Rly Authority</span><span class="pull-right" style=" border-bottom: 1px solid #656565dd; height: 49px; padding: 0 84px 0 84px; float: right !IMPORTANT;">Sig. Rly Contractor<span></P> '
},
]
});
});
</script>
<style>
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;
}
.dt-buttons button:first-child {display: none;}
</style>
<!---//16-3-2020--->
<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>
<style>
@page {size: A4 landscape;}
</style>