File: /home/barbeatleanalyti/public_html/baris.beatleanalytics.com/site/template/manpowerlog.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;
// $Month = $objScorecardctsnew->Month;
// $Year = $objScorecardctsnew->Year;
$valck[] = array();
if(!in_array('PMC', 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="manpowerlog.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 = $objScorecardctsnew->fetchStation(); ?>
<!-- <label class=" control-label station_select"> Select Station</label>-->
<div class=" col-md-2 station_select_omanpowerlogion ">
<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 = $objScorecardctsnew->FetchQuestion(); ?>
<option value="0">Select Question </option>
<?php/* if($_SESSION['UserInfo']['OrgID'] == 16){ ?>
<option selected="selected" value="19">Manpower log</option>
<?php }else{ ?>
<option selected="selected" value="4">Manpower log</option>
<?php }*/ ?>
<option selected="selected" value="<?php echo getsubquestionid('PMC','manpower_log') ?>">Manpower log</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 = $objScorecardctsnew->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>
<?php if ($userdata[0]['db_usertype'] != 'viewer' ){ ?>
<a class="btn btn-success btn-sm dailytarget" href="manpowertarget.html"> Manpower Target </a>
<?php } ?>
<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)){
$rsParamIDS = SubQuestionGroupIDS('params',$QuestionId);//subquestion
$rsPagesIDS = SubQuestionGroupIDS('pages',$rsParamIDS[0]);
$rsUserInfo = $objScorecardctsnew->FetchUsersData();
// if($_SESSION['UserInfo']['OrgID'] == 16){
// $mQuestionId = 15;
// }else{
// $mQuestionId = 14;
// }
$mQuestionId = getquestionid('PMC');
?>
<div class="NEWCTS">
<div class="fixed-btn">
<a href="pmcmanpowersummary.html" class="btn summary-btn" target="_blank">Manpower Log - Summary </a>
<?php if ($userdata[0]['db_usertype'] != 'viewer' ){ ?>
<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>
<?php } ?>
</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 = $objScorecardctsnew->FetchQuestionsData($rsUserInfo[$u]['db_surveyUserid']);
$rsQuestionsInfo = $objScorecardctsnew->FetchQuestionsData($rsUserInfo[$u]);
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%; margin-bottom: 87px; ">
aaaaaaa
</table>--->
<?php if($_SESSION['UserInfo']['OrgID'] == 16 || $_SESSION['UserInfo']['OrgID'] == 17 || $_SESSION['UserInfo']['OrgID'] == 21 || $_SESSION['UserInfo']['OrgID'] == 20 || $_SESSION['UserInfo']['OrgID'] == 23 || $_SESSION['UserInfo']['OrgID'] == 24 || $_SESSION['UserInfo']['OrgID'] == 25 || $_SESSION['UserInfo']['OrgID'] == 28 || $_SESSION['UserInfo']['OrgID'] == 30){ ?>
<table id="" class="display-- new_print_display" style="width: 100%; margin-bottom: 87px;">
<colgroup width="100"></colgroup>
<colgroup width="120"></colgroup>
<colgroup width="100"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="250"></colgroup>
<tbody>
<tr class="no_br report_header2">
<td colspan="28" height="28" align="center" valign="bottom"> <?php echo $objScorecardctsnew->getcommondata('baris_station','zoneName','stationId',$rsQuestionsInfo[$i][0]['db_surveyStationId']) ?> RAILWAY </td>
</tr>
<tr class="no_br report_header2">
<td colspan="28" height="28" valign="bottom">
<span class="report_name"> Manpower Log </span>
</td>
</tr>
<tr class="no_br report_header2" style="border-bottom: 1px solid #bfbfbf;">
<td colspan="28" height="28" valign="bottom">
Daily uses of type and quantity of consumables of environmental sanitation, mechanized cleaning and housekeeping contract at <?php echo $objScorecardctsnew->getcommondata('baris_station','stationName','stationId',$rsQuestionsInfo[$i][0]['db_surveyStationId']) ?> Railway station
</td>
</tr>
<tr class="no_br">
<td height="100" style="height: 12px !important;"></td>
</tr>
<tr class="no_br report_header2">
<td colspan="28" height="28" valign="bottom">
Date :
<span class="t_nas" id="dateofinspection00"><?php echo date('Y-m-d',strtotime($rsQuestionsInfo[$i][0]['created_date']));?></span>
Division :
<span class="t_nas" id="trainno00"><?php echo $objScorecardctsnew->getcommondata('baris_division','DivisionName','DivisionId',$rsQuestionsInfo[$i][0]['DivisionId']) ?></span>
Station :
<span class="t_nas" id="auditorname00"> <?php echo $objScorecardctsnew->getcommondata('baris_station','stationName','stationId',$rsQuestionsInfo[$i][0]['db_surveyStationId']) ?></span>
Total Required Manpower :
<span class="t_nas" id="manpower<?php echo $u.$i ?>">0</span>
Present for the Day :
<span class="t_nas" id="present<?php echo $u.$i ?>">14</span>
</td>
</tr>
<tr class="no_br">
<td height="100" style="height: 12px !important;"></td>
</tr>
<tr class="header_bg">
<td height="64" align="center" valign="middle">Shift</td>
<td align="center" valign="middle">Description</td>
<td align="center" valign="middle">To be provided as per norms</td>
<?php foreach ($rsPagesIDS as $key => $rsPages){
$rsPagesData = $objScorecardctsnew->getPagesData($rsPages);
?>
<td align="center" valign="middle" ><?php echo $rsPagesData[0]['db_pagename']; ?></td>
<?php if($key==1){ ?>
<td align="center" valign="middle" >Actual avaliable</td>
<?php } } ?>
<td align="center" valign="middle">Signature of On duty CHI</td>
</tr>
<?php
$rowspan = 0;
$gTotalTarget = 0;
$actualAvailableSum = 0;
$actualAvailable = 0;
foreach ($rsParamIDS as $key => $rsParams){
$rsParamData = $objScorecardctsnew->getParamsData($rsParams);
$desc = explode(',', $rsParamData[0]['paramChoice']);
$rowspan = count($desc);
$month = date('m',strtotime($rsQuestionsInfo[$i][0]['created_date']));
$year = date('Y',strtotime($rsQuestionsInfo[$i][0]['created_date']));
$rsTargetData = $objScorecardctsnew->getMonthlyTarget($mQuestionId,$QuestionId,$rsParams,$month,$year);
$rsTargetData = explode(',', $rsTargetData[0]['value']);
// $rsTargetData = $objScorecardctsnew->getTarget($mQuestionId,$QuestionId,$rsParams);
// $rsTargetData = explode(',', $rsTargetData[0]['value']);
$totalTarget = 0;
$auditorname = '';
foreach ($desc as $key1 => $value) {
$totalTarget = $totalTarget + $rsTargetData[$key1];
?>
<tr>
<?php if($rowspan != 0){ ?>
<td height="64" rowspan="<?php echo $rowspan ?>" align="center" valign="middle" bgcolor="#FFFFFF"><?php echo $rsParamData[0]['paramName']; ?></td>
<?php } ?>
<td align="center" valign="middle" bgcolor="#FFFFFF"><?php echo $value; ?></td>
<td align="center" valign="middle" bgcolor="#FFFFFF" sdval="1" sdnum="1033;"><?php echo $rsTargetData[$key1]; ?></td>
<?php
$avgVal1 = 0;
// echo "<pre>"; print_r($rsTargetData);echo "</pre>";
foreach ($rsPagesIDS as $key2 => $rsPages){
$avgVal = $objScorecardctsnew->FetchValueScore($rsQuestionsInfo[$i][0]['db_surveyQuestionId'],$rsQuestionsInfo[$i][0]['db_surveySubQuestionId'],$rsParams,$rsPages,$value,$rsQuestionsInfo[$i][0]['tokenid']);
$avgVal1 += $avgVal[0]['AvgValue'];
$auditorname = $avgVal[0]['auditorname'];
?>
<?php if($key==1){?>
<script type="text/javascript">$('#chi_name_shift_one<?php echo $u.$i ?>').text('(<?php echo $auditorname ?>)')</script>
<?php } ?>
<td align="center" valign="middle"><?php echo $avgVal[0]['AvgValue']; ?></td>
<?php
if($key2==1){
$avgVal1 -= $avgVal[0]['AvgValue'];
$actualAvailable = $avgVal1-$avgVal[0]['AvgValue'];
$actualAvailableSum += $actualAvailable;
?>
<td align="center" valign="middle" ><?php echo $actualAvailable ?></td>
<?php } } ?>
<?php if($rowspan != 0){ ?>
<td align="center" rowspan="<?php echo $rowspan ?>" valign="middle" bgcolor="#FFFFFF">
<?php
if($rowspan > 1){
echo "CHI ".$rsParamData[0]['paramName'];
}else{
echo "CHI Shift 1/2/3";
}
?>
<span class="chi_name"> (<?php echo $auditorname ?>)</span>
</td>
<?php } ?>
</tr>
<?php $rowspan = 0; } ?>
<tr>
<td colspan="2" height="20" align="center" valign="middle" bgcolor="#FFFFFF">Total</td>
<td align="center" valign="middle" bgcolor="#FFFFFF" sdval="1" sdnum="1033;"><?php echo $totalTarget; ?></td>
<?php foreach ($rsPagesIDS as $key2 => $rsPages){ ?>
<td align="center" valign="middle" ><?php echo ''; ?></td>
<?php if($key2==1){ ?>
<td align="center" valign="middle" ></td>
<?php } ?>
<?php } ?>
<td align="center" valign="bottom" bgcolor="#FFFFFF">
</td>
</tr>
<?php
$gTotalTarget = $gTotalTarget + $totalTarget;
} ?>
<script type="text/javascript">
$("#manpower<?php echo $u.$i ?>").text(<?php echo $gTotalTarget; ?>);
$("#present<?php echo $u.$i ?>").text(<?php echo $actualAvailableSum; ?>);
</script>
<?php
echo "tokenid ".$rsQuestionsInfo[$i][0]['tokenid'];
?>
<tr>
<td colspan="2" height="20" align="center" valign="bottom"><font color="#000000">Grand Total</font></td>
<td align="center" valign="middle" sdval="150" sdnum="1033;"><font color="#000000"><?php echo $gTotalTarget; ?></font></td>
<td align="left" valign="bottom"><font color="#000000"><br /></font></td>
<td align="left" valign="bottom"><font color="#000000"><br /></font></td>
<td align="left" valign="bottom"><font color="#000000"><br /></font></td>
<td align="left" valign="bottom"><font color="#000000"><br /></font></td>
<td align="left" valign="bottom"><font color="#000000"><br /></font></td>
<td align="center" valign="bottom" bgcolor="#FFFFFF">
<!-- CHI Shift
<br />
<span class="chi_name" id="chi_name_shift_one00"> (xxxxxxxx)</span> -->
</td>
</tr>
<tr class="no_br report_header2 signature" style="">
<td colspan="28" height="28" valign="bottom" style="padding-top: 28px !important;">
<span class="t_nas" id="" style="padding: 0px 20px 36px 20px; margin-right: 20%;">Signature of Contractor Representative </span>
<?php if ($userdata[0]['OrgID'] == 30)
{ ?>
<span class="t_nas" id="" style="padding: 13px 32px; margin-left: 20%;">DCI IN Charge</span>
<?php } else { ?>
<span class="t_nas" id="" style="padding: 13px 32px; margin-left: 20%;">CHI IN Charge</span>
<?php } ?>
</td>
</tr>
</tbody>
</table>
<?php }else{ ?>
<table id="" class="display-- new_print_display" style="width:100%; margin-bottom: 87px; ">
<colgroup width="100"></colgroup>
<colgroup width="120"></colgroup>
<colgroup width="100"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="150"></colgroup>
<colgroup width="250"></colgroup>
<tbody>
<tr class="no_br report_header2">
<td colspan="28" height="28" valign="bottom"> NORTHERN RAILWAY </td>
</tr>
<tr class="no_br report_header2">
<td colspan="28" height="28" valign="bottom"><span class="report_name"> Manpower Log </span> </td>
</tr>
<tr class="no_br report_header2 " style="border-bottom: 1px solid #bfbfbf;">
<td colspan="28" height="28" valign="bottom">
Daily uses of type and quantity of consumables of environmental sanitation, mechanized cleaning and housekeeping contract at <?php echo $objScorecardctsnew->getcommondata('baris_station','stationName','stationId',$rsQuestionsInfo[$i][0]['db_surveyStationId']) ?> Railway station
</td>
</tr>
<tr class="no_br">
<td height="100" style=" height: 12px !important;"></td>
</tr>
<tr class="no_br report_header2">
<td colspan="28" height="28" valign="bottom">
Date : <span class="t_nas" id="dateofinspection00"><?php echo date('Y-m-d',strtotime($rsQuestionsInfo[$i][0]['created_date']));?></span>
Division : <span class="t_nas" id="trainno00"><?php echo $objScorecardctsnew->getcommondata('baris_division','DivisionName','DivisionId',$rsQuestionsInfo[$i][0]['DivisionId']) ?></span>
Station : <span class="t_nas" id="auditorname00"> <?php echo $objScorecardctsnew->getcommondata('baris_station','stationName','stationId',$rsQuestionsInfo[$i][0]['db_surveyStationId']) ?></span>
Total Required Manpower : <span class="t_nas" id="manpower<?php echo $u.$i ?>">150</span>
Present for the Day : <span class="t_nas" id="present<?php echo $u.$i ?>">150</span>
</td>
</tr>
<tr class="no_br">
<td height="100" style=" height: 12px !important;"></td>
</tr>
<tr class="header_bg">
<td height="64" align="center" valign="middle" >Shift</td>
<td align="center" valign="middle" >Description</td>
<td align="center" valign="middle" >To be provided as per norms</td>
<?php foreach ($rsPagesIDS as $key => $rsPages): ?>
<?php
$rsPagesData = $objScorecardctsnew->getPagesData($rsPages);
?>
<td align="center" valign="middle" ><?php echo $rsPagesData[0]['db_pagename']; ?></td>
<?php if($key==1){ ?>
<td align="center" valign="middle" >Actual avaliable</td>
<?php } ?>
<?php endforeach ?>
<td align="center" valign="middle" >Signature of On duty CHI</td>
</tr>
<?php
$rowspan = 0;
$is_second = false;
$gTotalTarget = 0;
$actualAvailableSum = 0;
$actualAvailable = 0;
echo $rsQuestionsInfo[$i][0]['tokenid'];
foreach ($rsParamIDS as $key => $rsParams): ?>
<?php
$rsParamData = $objScorecardctsnew->getParamsData($rsParams);
$desc = explode(',', $rsParamData[0]['paramChoice']);
$rowspan = count($desc);
// echo "string ".$rowspan;
$month = date('m',strtotime($rsQuestionsInfo[$i][0]['created_date']));
$year = date('Y',strtotime($rsQuestionsInfo[$i][0]['created_date']));
$rsTargetData = $objScorecardctsnew->getMonthlyTarget($mQuestionId,$QuestionId,$rsParams,$month,$year);
$rsTargetData = explode(',', $rsTargetData[0]['value']);
// $rsTargetData = $objScorecardctsnew->getTarget($mQuestionId,$QuestionId,$rsParams);
// $rsTargetData = explode(',', $rsTargetData[0]['value']);
$totalTarget = 0;
$auditorname = '';
foreach ($desc as $key1 => $value) {
$totalTarget = $totalTarget + $rsTargetData[$key1];
?>
<tr>
<?php if($rowspan != 0){ ?>
<td height="64" rowspan="<?php echo $rowspan ?>" align="center" valign="middle" bgcolor="#FFFFFF"><?php echo $rsParamData[0]['paramName']; ?></td>
<?php } ?>
<td align="center" valign="middle" bgcolor="#FFFFFF"><?php echo $value; ?></td>
<td align="center" valign="middle" bgcolor="#FFFFFF" sdval="1" sdnum="1033;"><?php echo $rsTargetData[$key1]; ?></td>
<?php
$avgVal1 = 0;
foreach ($rsPagesIDS as $key2 => $rsPages){ ?>
<?php
$avgVal = $objScorecardctsnew->FetchValueScore($rsQuestionsInfo[$i][0]['db_surveyQuestionId'],$rsQuestionsInfo[$i][0]['db_surveySubQuestionId'],$rsParams,$rsPages,$value,$rsQuestionsInfo[$i][0]['tokenid']);
$avgVal1 += $avgVal[0]['AvgValue'];
$auditorname = $avgVal[0]['auditorname'];
?>
<?php if($key==1){?>
<script type="text/javascript">$('#chi_name_shift_one<?php echo $u.$i ?>').text('(<?php echo $auditorname ?>)')</script>
<?php } ?>
<?php
$avgnew = $avgVal[0]['AvgValue'];
if($key2==0){
} ?>
<td align="center" valign="middle" ><?php echo $avgVal[0]['AvgValue']; ?></td>
<?php
if($key2==1){
$avgVal1 -= $avgVal[0]['AvgValue'];
$actualAvailable = $avgVal1-$avgVal[0]['AvgValue'];
$actualAvailableSum += $actualAvailable;
?>
<td align="center" valign="middle" ><?php echo $actualAvailable ?></td>
<?php } ?>
<?php } ?>
<?php if($rowspan == 1){ ?>
<td align="center" valign="middle" bgcolor="#FFFFFF"><br><br><br>CHI Shift 1/2/3 <br><span class="chi_name"> (<?php echo $auditorname ?>)</span></td>
<?php }else{ ?>
<?php if($rowspan != 0 && $is_second == true){ ?>
<td rowspan="<?php if ($key < count($rsParamIDS)-1) echo '5'; else echo '6'; ?>" align="center" valign="bottom" bgcolor="#FFFFFF">CHI <?php echo $rsParamData[0]['paramName']; ?> <span class="chi_name"> (<?php echo $auditorname ?>)</span></td>
<?php } $is_second = true; } ?>
</tr>
<?php $rowspan = 0; }
echo $rsQuestionsInfo[$i][0]['tokenid'];
?>
<tr>
<td colspan="2" height="20" align="center" valign="middle" bgcolor="#FFFFFF">Total</td>
<td align="center" valign="middle" bgcolor="#FFFFFF" sdval="1" sdnum="1033;"><?php echo $totalTarget; ?></td>
<?php foreach ($rsPagesIDS as $key2 => $rsPages): ?>
<td align="center" valign="middle" ><?php echo ''; ?></td>
<?php if($key2==1){ ?>
<td align="center" valign="middle" ></td>
<?php } ?>
<?php endforeach ?>
<?php if(count($desc)==1){ ?>
<td rowspan="6" align="center" valign="bottom" bgcolor="#FFFFFF">CHI Shift 1 <br> <span class="chi_name" id="chi_name_shift_one<?php echo $u.$i ?>"> (xxxxxxxx)</span></td>
<?php } ?>
</tr>
<?php $gTotalTarget = $gTotalTarget + $totalTarget;
//echo $rsQuestionsInfo[$i][0]['tokenid'];
?>
<?php endforeach ?>
<script type="text/javascript">
$("#manpower<?php echo $u.$i ?>").text(<?php echo $gTotalTarget; ?>);
$("#present<?php echo $u.$i ?>").text(<?php echo $actualAvailableSum; ?>);
</script>
<tr>
<td colspan="2" height="20" align="center" valign="bottom"><font color="#000000">Grand Total</td>
<td align="center" valign="middle" sdval="150" sdnum="1033;"><font color="#000000"><?php echo $gTotalTarget; ?></td>
<td align="left" valign="bottom"><font color="#000000"><br></td>
<td align="left" valign="bottom"><font color="#000000"><br></td>
<td align="left" valign="bottom"><font color="#000000"><br></td>
<td align="left" valign="bottom"><font color="#000000"><br></td>
<td align="left" valign="bottom"><font color="#000000"><br></td>
</tr>
<tr class="no_br report_header2 signature" style="">
<td colspan="28" height="28" valign="bottom" style=" padding-top: 28px !important;">
<span class="t_nas" id="" style=" padding: 0px 20px 36px 20px; margin-right: 20%;">Signature of Contractor Representative </span>
<span class="t_nas" id="" style="padding: 0px 20px 36px 20px; margin-left: 20%;">CHI IN Charge</span>
</td>
</tr>
</tbody>
</table>
<?php } ?>
<?php }
}
}
}?>
</div>
</div>
</div>
<?php }else{ ?>
<!----NEWCTS-start---->
<center>
<img class="report_sch_img" src="https://baris.beatleanalytics.com/theme/black/dist/img/searchfeedback4.jpg"
style="width:100%;">
</center>
<!----NEWCTS-End---->
<?php } ?>
</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>
$(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>