File: /home/barbeatleanalyti/public_html/baris.beatleanalytics.com/site/template/pmcmanpowersummary.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">
<!------------------------------------------------------------------>
<!-------9-9-2020-- display:none;-->
<form method="post" action="pmcmanpowersummary.html" name="frmSearch" id="frmSearch" 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="manpowerlog.html"> <i class="fa fa-long-arrow-left"></i> Back </a></div>
<div class=" col-xs-12 col-md-3 col-lg-2 form-group">
<select class="form-control input-md" id="month" name="Month">
<option value="01">Janaury</option>
<option value="02">February</option>
<option value="03">March</option>
<option value="04">April</option>
<option value="05">May</option>
<option value="06">June</option>
<option value="07">July</option>
<option value="08">August</option>
<option value="09">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
</div>
<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>
<script>
function myFunction() {
$(".loader").show();
document.getElementById("frmSearch").submit();
}
$(window).bind("load", function() {
//$(".loader").hide();
});
</script>
</span>
</div>
<div class="col-md-4"></div>
</div>
</h3>
</div>
</form>
<div class="NEWCTS">
<div class="fixed-btn">
<?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">
<!---<div class="creat_new_page_print"></div>
<table id="" class="display-- new_print_display" style="width:100%; margin-bottom: 87px; ">
aaaaaaa
</table>--->
<table id="" class="display-- new_print_display " style="width:100%; margin-top:25px; margin-bottom:0px;" >
<colgroup span="7" width="64"></colgroup>
<tbody>
<tr class="no_br report_header2">
<td colspan="28" height="28" valign="bottom"> <?php echo $objScorecardctsnew->getcommondata('baris_station','zoneName','OrgID',$_SESSION['UserInfo']['OrgID']) ?> RAILWAY </td>
</tr>
<tr class="no_br report_header2">
<td colspan="28" height="28" valign="bottom"><span class="report_name">PMC - Manpower Summary</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','OrgID',$_SESSION['UserInfo']['OrgID']) ?> 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">
Month <?php echo $Month; ?> :<span class="t_nas" id="dateofinspection00"><?php echo date("F", mktime(null, null, null, $Month)) ?></span>
Year :<span class="t_nas" id="dateofinspection00"><?php echo $Year; ?></span>
Division :<span class="t_nas" id="auditorname00"><?php echo $objScorecardctsnew->getcommondata('baris_division','DivisionName','OrgID',$_SESSION['UserInfo']['OrgID']) ?></span>
Station :<span class="t_nas" id="trainno00"><?php echo $objScorecardctsnew->getcommondata('baris_station','stationName','OrgID',$_SESSION['UserInfo']['OrgID']) ?></span>
Name Of Contractor:<span class="t_nas" id="#"><?php echo $objScorecardctsnew->getcommondata('baris_organization','db_Orgname','OrgID',$_SESSION['UserInfo']['OrgID']) ?> </span>
Total Month Penalty :<span class="t_nas" id="totalPenalty"></span>
</td>
</tr>
<tr class="no_br">
<td height="100" style=" height: 12px !important;"></td>
</tr>
<tr class="header_bg">
<td height="220" valign="middle"><b>Date</b></td>
<td valign="middle"><b>To Be Provided as per Norms</b></td>
<td valign="middle"><b>Actual Avaliable</b></td>
<td valign="middle"><b>Absent (A)</b></td>
<?php
if ($userdata[0]['OrgID'] == 16 || $userdata[0]['OrgID'] == 17 || $userdata[0]['OrgID'] == 18 || $userdata[0]['OrgID'] == 21 || $userdata[0]['OrgID'] == 23 || $userdata[0]['OrgID'] == 24 || $userdata[0]['OrgID'] == 25 || $userdata[0]['OrgID'] == 28 || $userdata[0]['OrgID'] == 30 || $userdata[0]['OrgID'] == 28){
?>
<td valign="middle"><b>Found Without Dress Code/ ID Cards/ Batches (D)</b></td>
<?php } ?>
<td valign="middle"><b>Found Without Protective Gears (G)</b></td>
<!--<td valign="middle"><b>Penalty for the Day @ Rs. 1525 for A, Rs. 100 for D/ person, Rs. 20 for G /person </b></td>-->
<td valign="middle">
<?php if ($userdata[0]['OrgID'] == 17 || $userdata[0]['OrgID'] == 18)
{
if ($Year =='2021' && $Month <='9')
{
?>
<b>
Penalty for the Day : Manager @ Rs 1714/ Person, Supervisor @ Rs 1000/ Person,Pest Control @ Rs 731/ Person,House Keeper @ Rs 731/ Person, Driver @ Rs 1505/ Person</b>
<?php
}
else if (($Year =='2021' && $Month >'9') || ($Year =='2022' && $Month <='3'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1724/ Person, Supervisor @ Rs 1012/ Person,Pest Control @ Rs 737/ Person,House Keeper @ Rs 737/ Person, Driver @ Rs 1512/ Person</b>
<?php
}
else if (($Year =='2022' && $Month <='9'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1770/ Person, Supervisor @ Rs 1044/ Person,Pest Control @ Rs 766/ Person,House Keeper @ Rs 766/ Person, Driver @ Rs 1544/ Person</b>
<?php
}
else if (($Year =='2022' && ( $Month == '10' || $Month == '11' || $Month == '12')) || ($Year =='2023' && $Month <='3'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1788/ Person, Supervisor @ Rs 1057/ Person,Pest Control @ Rs 777/ Person,House Keeper @ Rs 777/ Person, Driver @ Rs 1557/ Person</b>
<?php
}
// code by sid
else if (($Year =='2023' && $Month >'3' && $Month <='9'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1816/ Person, Supervisor @ Rs 1077/ Person,Pest Control @ Rs 794/ Person,House Keeper @ Rs 794/ Person, Driver @ Rs 1577/ Person</b>
<?php
}
else if (($Year =='2023' && $Month >='10'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1832/ Person, Supervisor @ Rs 1087/ Person,Pest Control @ Rs 804/ Person,House Keeper @ Rs 804/ Person, Driver @ Rs 1587/ Person</b>
<?php
}
else if (($Year =='2024' && $Month >='1' && $Month <'4'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1832/ Person, Supervisor @ Rs 1087/ Person,Pest Control @ Rs 804/ Person,House Keeper @ Rs 804/ Person, Driver @ Rs 1587/ Person</b>
<?php
}
else if (($Year =='2024' && $Month >='4' && $Month <= '9'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1862/ Person, Supervisor @ Rs 1110/ Person,Pest Control @ Rs 822/ Person,House Keeper @ Rs 822/ Person, Driver @ Rs 1/ Person</b>
<?php
}
else if (($Year =='2024' && $Month >='10'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1868/ Person, Supervisor @ Rs 1114/ Person,Pest Control @ Rs 826/ Person,House Keeper @ Rs 826/ Person, Driver @ Rs 1614/ Person</b>
<?php
}
else if (($Year =='2025' && $Month <='3'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1868/ Person, Supervisor @ Rs 1114/ Person,Pest Control @ Rs 826/ Person,House Keeper @ Rs 826/ Person, Driver @ Rs 1614/ Person</b>
<?php
}
else if (($Year =='2025' && $Month >='4'))
{
?>
<b>
Penalty for the Day : Manager @ Rs 1893/ Person, Supervisor @ Rs 1132/ Person,Pest Control @ Rs 841/ Person,House Keeper @ Rs 841/ Person, Driver @ Rs 1632/ Person</b>
<?php
}
else {
?>
<b>
Penalty for the Day : Manager @ Rs 1734/ Person, Supervisor @ Rs 1090/ Person,Pest Control @ Rs 743/ Person,House Keeper @ Rs 743/ Person, Driver @ Rs 1519/ Person</b>
<?php
}
}
else if ($userdata[0]['OrgID'] == 13 )
{
if ($Year =='2022' && $Month >='10')
{
?>
<b>Penalty for the Day :Manager @ Rs 1788, Supervisor @ Rs 1671/ Person, Machine Operator @ Rs 1595, House Keeper @ Rs 1595/ Person</b>
<?php
}
elseif ($Year =='2023' && $Month >='1'&& $Month <'11')
{
?>
<b>Penalty for the Day :Manager @ Rs 1788, Supervisor @ Rs 1671/ Person, Machine Operator @ Rs 1595, House Keeper @ Rs 1595/ Person</b>
<?php
}
elseif ($Year =='2023' && $Month >='11')
{
?>
<b>Penalty for the Day :Manager @ Rs 1832, Supervisor @ Rs 1709/ Person, Machine Operator @ Rs 1628, House Keeper @ Rs 1628/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month <='3')
{
?>
<b>Penalty for the Day :Manager @ Rs 1832, Supervisor @ Rs 1709/ Person, Machine Operator @ Rs 1628, House Keeper @ Rs 1628/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month >'3' && $Month <'11' )
{
?>
<b>Penalty for the Day :Manager @ Rs 1862, Supervisor @ Rs 1734/ Person, Machine Operator @ Rs 1651, House Keeper @ Rs 1651/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month >'10')
{
?>
<b>Penalty for the Day :Manager @ Rs 1868, Supervisor @ Rs 1739/ Person, Machine Operator @ Rs 1655, House Keeper @ Rs 1655/ Person</b>
<?php
}
elseif ($Year =='2025' && $Month <='3')
{
?>
<b>Penalty for the Day :Manager @ Rs 1868, Supervisor @ Rs 1739/ Person, Machine Operator @ Rs 1655, House Keeper @ Rs 1655/ Person</b>
<?php
}
elseif ($Year =='2025' && $Month >='4')
{
?>
<b>Penalty for the Day :Manager @ Rs 1893, Supervisor @ Rs 1760/ Person, Machine Operator @ Rs 1674, House Keeper @ Rs 1674/ Person</b>
<?php
}
else {
?>
<b>
Penalty for the Day :Manager @ Rs 1714, Supervisor @ Rs 1609/ Person, Machine Operator @ Rs 1595, House Keeper @ Rs 1595/ Person</b>
<?php }
}
else if ($userdata[0]['OrgID'] == 16 )
{
if ($Year =='2022' && $Month >='10')
{
?>
<b>
Penalty for the Day :Manager @ Rs 1366/ Person, Supervisor @ Rs 1171/ Person,House Keeper @ Rs 1095/ Person</b>
<?php
}
else if (($Year =='2022' && $Month >='4') || ($Year =='2022' && $Month <='9'))
{
?>
<b>
Penalty for the Day :Manager @ Rs 1346/ Person, Supervisor @ Rs 1156/ Person,House Keeper @ Rs 1081/ Person</b>
<?php
}
else {
?>
<b>
Penalty for the Day :Manager @ Rs 1295/ Person, Supervisor @ Rs 1117/ Person,House Keeper @ Rs 1046/ Person</b>
<?php
}
}
elseif ($userdata[0]['OrgID'] == 21 ){
if ($Year =='2022' && $Month >='10')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1671/ Person,Computer Operator @ Rs 1671/ Person,House Keeper @ Rs 1595/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month <='3')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1709/ Person,House Keeper @ Rs 1628/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month >'3')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1734/ Person,House Keeper @ Rs 1651/ Person</b>
<?php
}
elseif ($Year =='2023' && $Month <='3')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1671/ Person,Computer Operator @ Rs 1671/ Person,House Keeper @ Rs 1595/ Person</b>
<?php
}
elseif ($Year >='2023' && $Month >='4'&& $Month <'10')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1695/ Person,House Keeper @ Rs 1616/ Person</b>
<?php
}
elseif ($Year =='2023' && $Month >='10')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1709/ Person,House Keeper @ Rs 1628/ Person</b>
<?php
}
elseif ($Year =='2022' && $Month >='4') //date('Y-m-d',strtotime($date)) <= date('Y-m-d',strtotime('2022-03-31')))
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1625/ Person,Computer Operator @ Rs 1625/ Person,House Keeper @ Rs 1553/ Person</b>
<?php
}
else {
?>
<b>
Penalty for the Day : Supervisor @ Rs 1617/ Person,Computer Operator @ Rs 1617/ Person,House Keeper @ Rs 1546/ Person</b>
<?php }
}
elseif ($userdata[0]['OrgID'] == 20 ){
?>
<b>
Penalty for the Day :Supervisor @ Rs 1505/ Person,House Keeper @ Rs 1431/ Person</b>
<?php
}
elseif ($userdata[0]['OrgID'] == 24 )
{
if ($Year =='2022' && $Month >='10')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1557/ Person,Pest Control @ Rs 1557/ Person,House Keeper @ Rs 1477/ Person</b>
<?php
}
elseif ($Year >='2023' && $Month <='3')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1557/ Person,Pest Control @ Rs 1557/ Person,House Keeper @ Rs 1477/ Person</b>
<?php
}
elseif ($Year >='2023' && $Month >='4')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1577/ Person,Pest Control @ Rs 1577/ Person,House Keeper @ Rs 1494/ Person</b>
<?php
}
else if($Year =='2022' && $Month >='4' && $Month <='9')
{
?>
<b>
Penalty for the Day : Supervisor @ Rs 1519/ Person,Pest Control @ Rs 1519/ Person,House Keeper @ Rs 1443/ Person</b>
<?php
}
else {
?>
<b>
Penalty for the Day : Supervisor @ Rs 1512/ Person,Pest Control @ Rs 1512/ Person,House Keeper @ Rs 1437/ Person</b>
<?php
}
}
else if ($userdata[0]['OrgID'] == 26 )
{
?>
<b>
Penalty for the Day : Head Supervisor @ Rs 1512/ Person,House Keeper @ Rs 1437/ Person, Pest Control @ Rs 1512/ Person, Rag Picking @ Rs 1437/ Person</b>
<?php
}
else if ($userdata[0]['OrgID'] == 28 )
{
if ($Year =='2022' && $Month >='10')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1671/ Person,House Keeper @ Rs 1595/ Person</b>
<?php
}
elseif ($Year =='2023' && $Month <='3')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1671/ Person,House Keeper @ Rs 1595/ Person</b>
<?php
}
elseif ($Year =='2023' && $Month >='10')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1709/ Person,House Keeper @ Rs 1628/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month <='3')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1709/ Person,House Keeper @ Rs 1628/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month >='4'&& $Month <'10')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1734/ Person,House Keeper @ Rs 1651/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month >'9')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1739/ Person,House Keeper @ Rs 1655/ Person</b>
<?php
}
elseif ($Year =='2025' && $Month <='3')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1739/ Person,House Keeper @ Rs 1655/ Person</b>
<?php
}
elseif ($Year =='2025' && $Month >='4')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1760/ Person,House Keeper @ Rs 1674/ Person</b>
<?php
}
elseif ($Year =='2023' && $Month >='4'&& $Month <'10')
{
?>
<b>Penalty for the Day :Supervisor @ Rs 1695/ Person,House Keeper @ Rs 1616/ Person</b>
<?php
}
else if ($Year =='2022' && $Month ='9')
{
?>
<b>Penalty for the Day : Supervisor @ Rs 1656/ Person, House Keeper @ Rs 1581/ Person</b>
<?php
}
else if ($Year =='2022' && $Month >'3' && $Month <'9')
{
?>
<b>Penalty for the Day : Supervisor @ Rs 1656/ Person, House Keeper @ Rs 1581/ Person</b>
<?php
}
else {
?>
<b>
Penalty for the Day : Supervisor @ Rs 1617/ Person,House Keeper @ Rs 1546/ Person</b>
<?php }
}
else if ($userdata[0]['OrgID'] == 29 ){
?>
<b>
Penalty for the Day : Head Supervisor @ Rs 1512/ Person,House Keeper @ Rs 1437/ Person, Pest Control @ Rs 1512/ Person, Rag Picking @ Rs 1437/ Person</b>
<?php
}
else if ($userdata[0]['OrgID'] == 30 )
{
if ($Year =='2023' && $Month >='4')
{
?>
<b>Penalty for the Day :Manager @ Rs 1398/ Person, Supervisor @ Rs 1195/ Person, House Keeper @ Rs 1116/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month >='1'&& $Month <'10')
{
?>
<b>Penalty for the Day :Manager @ Rs 1398/ Person, Supervisor @ Rs 1195/ Person, House Keeper @ Rs 1116/ Person</b>
<?php
}
elseif ($Year =='2024' && $Month >='10')
{
?>
<b>Penalty for the Day :Manager @ Rs 1454/ Person, Supervisor @ Rs 1239/ Person, House Keeper @ Rs 1155/ Person</b>
<?php
}
else {
?>
<b>
Penalty for the Day :Manager @ Rs 1366/ Person, Supervisor @ Rs 1171/ Person, House Keeper @ Rs 1095/ Person</b>
<?php }
}
else {
?>
<b>
Penalty for the Day : Manager @ Rs 1866/ Person, Supervisor @ Rs 1671/ Person, House Keeper @ Rs 1095/ Person</b>
<?php }?>
</td>
</tr>
<?php
$mQuestionId = getquestionid('PMC');
$QuestionId = getsubquestionid('PMC','manpower_log');
$rsParamIDS = SubQuestionGroupIDS('params',$QuestionId);//subquestion
$rsPagesIDS = SubQuestionGroupIDS('pages',$rsParamIDS[0]);
$totalTarget = 0;
$totalAvailable = 0;
$managerTarget = 0;
$supvisorTarget = 0;
$storeKeeperTarget = 0;
$machineOpeTarget = 0;
$houseKeeperTarget = 0;
$projectManagerTarget = 0;
$driverTarget = 0;
$ragPickingTarget = 0;
$pestcontrolTarget = 0;
$houseKeeper1Target = 0;
$houseKeeper2Target = 0;
$houseKeeper3Target = 0;
$headSupervisorTarget = 0;
$computerOperatorTarget = 0;
$plineAllRagPickingTarget = 0;
$pestandrodentWorkerTarget = 0;
foreach ($rsParamIDS as $key => $rsParams){
$rsParamData = $objScorecardctsnew->getParamsData($rsParams);
$desc = explode(',', $rsParamData[0]['paramChoice']);
//$rsTargetData = $objScorecardctsnew->getMonthlyTarget($mQuestionId,$QuestionId,$rsParamId,$Month,$Year);
//$rsTargetData = explode(',', $rsTargetData[0]['value']);
$rsTargetData = $objScorecardctsnew->getTarget($mQuestionId,$QuestionId,$rsParams,$Month,$Year);
$rsTargetData = explode(',', $rsTargetData[0]['value']);
foreach ($desc as $key1 => $value) {
$totalTarget = $totalTarget + $rsTargetData[$key1];
if($value == "Manager") $managerTarget = $managerTarget + $rsTargetData[$key1];
if($value == "Supervisor")$supvisorTarget = $supvisorTarget + $rsTargetData[$key1];
if($value == "Storekeeper/Technician")$storeKeeperTarget = $storeKeeperTarget + $rsTargetData[$key1];
if($value == "Machine Operator")$machineOpeTarget = $machineOpeTarget + $rsTargetData[$key1];
if($value == "Housekeeper")$houseKeeperTarget = $houseKeeperTarget + $rsTargetData[$key1];
if($value == "Project Manager") $projectManagerTarget = $projectManagerTarget + $rsTargetData[$key1];
if($value == "Housekeeper (Line Siding And Good s Yard)")$houseKeeper1Target = $houseKeeper1Target + $rsTargetData[$key1];
if($value == "Housekeeper (Drains)")$houseKeeper2Target = $houseKeeper2Target + $rsTargetData[$key1];
if($value == "House Keeper (Garbage Disposable)")$houseKeeper3Target = $houseKeeper3Target + $rsTargetData[$key1];
if($value == "Driver")$driverTarget = $driverTarget + $rsTargetData[$key1];
if($value == "Head Supervisor")$headSupervisorTarget = $headSupervisorTarget + $rsTargetData[$key1];
if($value == "Pest Control")$pestcontrolTarget = $pestcontrolTarget + $rsTargetData[$key1];
if($value == "Rag Picking")$ragPickingTarget = $ragPickingTarget + $rsTargetData[$key1];
if($value == "Computer Operator")$computerOperatorTarget = $computerOperaterTarget + $rsTargetData[$key1];
if($value == "P/Line(all) coaching yard Rag Picking")$plineAllRagPickingTarget = $plineAllRagPickingTarget + $rsTargetData[$key1];
if($value == "Pest control & Rodent worker")$pestandrodentWorkerTarget = $pestandrodentWorkerTarget + $rsTargetData[$key1];
}
}
$totalPenalty = 0;
$totalDays = cal_days_in_month(CAL_GREGORIAN, $Month, $Year);
for ($i=1; $i <= $totalDays; $i++) {
$date = $Year.'-'.$Month.'-'.$i;
$actualAvailable = 0;
$absent = 0;
$foundWoDress = 0;
$foundWoProGlass = 0;
$managerAvailable = 0;
$supvisorAvailable = 0;
$storeKeeperAvailable = 0;
$machineOpeAvailable = 0;
$houseKeeperAvailable = 0;
$projectManagerAvailable = 0;
$driverAvailable = 0;
$pestcontrolAvailable = 0;
$houseKeeper1Available = 0;
$houseKeeper2Available = 0;
$houseKeeper3Available = 0;
$ragPickingAvailable = 0;
$headSupervisorAvailable = 0;
$computerOperatorAvailable = 0;
$plineAllRagPickingAvailable = 0;
$pestandrodentWorkerAvailable = 0;
$rsQuestionsInfo = $objScorecardctsnew->FetchQuestionsDataManpower($mQuestionId,$QuestionId,$date);
/* echo "<pre>";
print_r($rsQuestionsInfo);
die();*/
//[created_date] => 2020-09-01 00:00:00
if(count($rsQuestionsInfo)>0){
for ($q=0;$q< count($rsQuestionsInfo);$q++){
foreach ($rsParamIDS as $rsParams) {
$rsParamData = $objScorecardctsnew->getParamsData($rsParams);
$desc = explode(',', $rsParamData[0]['paramChoice']);
foreach ($desc as $key1 => $value) {
$avgVal1 = 0;
foreach ($rsPagesIDS as $key2 => $rsPages) {
$avgVal = $objScorecardctsnew->FetchValueScoreManpower($rsQuestionsInfo[$q][0]['db_surveyQuestionId'],$rsQuestionsInfo[$q][0]['db_surveySubQuestionId'],$rsParams,$rsPages,$value,$rsQuestionsInfo[$q][0]['tokenid']);
//$avgVal1 += $avgVal;
// echo $rsQuestionsInfo[$q][0]['created_date'];
$created_date[] = $rsQuestionsInfo[$q][0]['created_date'];
if($value == "Manager") $avgVal1 += $avgVal;
if($value == "Supervisor")$avgVal1 += $avgVal;
if($value == "Storekeeper/Technician")$avgVal1 += $avgVal;
if($value == "Machine Operator")$avgVal1 += $avgVal;
if($value == "Housekeeper")$avgVal1 += $avgVal;
if($value == "Project Manager")$avgVal1 += $avgVal;
if($value == "Driver")$avgVal1 += $avgVal;
if($value == "Pest Control")$avgVal1 += $avgVal;
if($value == "Housekeeper (Line Siding And Good s Yard)")$avgVal1 += $avgVal;
if($value == "Housekeeper (Drains)")$avgVal1 += $avgVal;
if($value == "House Keeper (Garbage Disposable)")$avgVal1 += $avgVal;
if($value == "Rag Picking")$avgVal1 += $avgVal;
if($value == "Head Supervisor")$avgVal1 += $avgVal;
if($value == "Computer Operator")$avgVal1 += $avgVal;
if($value == "P/Line(all) coaching yard Rag Picking")$avgVal1 += $avgVal;
if($value == "Pest control & Rodent worker")$avgVal1 += $avgVal;
if($key2==1){
//$absent += $avgVal;
// $avgVal1 -= $avgVal;
// $actualAvailable += $avgVal1-$avgVal;
if($value == "Manager"){
$avgVal1 -= $avgVal;
$managerAvailable += $avgVal1-$avgVal;
}
if($value == "Supervisor"){
$avgVal1 -= $avgVal;
$supvisorAvailable += $avgVal1-$avgVal;
}
if($value == "Storekeeper/Technician"){
$avgVal1 -= $avgVal;
$storeKeeperAvailable += $avgVal1-$avgVal;
}
if($value == "Machine Operator"){
$avgVal1 -= $avgVal;
$machineOpeAvailable += $avgVal1-$avgVal;
}
if($value == "Housekeeper"){
$avgVal1 -= $avgVal;
$houseKeeperAvailable += $avgVal1-$avgVal;
}
if($value == "Computer Operator"){
$avgVal1 -= $avgVal;
$computerOperatorAvailable += $avgVal1-$avgVal;
}
if($value == "Rag Picking"){
$avgVal1 -= $avgVal;
$ragPickingAvailable += $avgVal1-$avgVal;
}
if($value == "Head Supervisor"){
$avgVal1 -= $avgVal;
$headSupervisorAvailable += $avgVal1-$avgVal;
}
if($value == "Project Manager"){
$avgVal1 -= $avgVal;
$projectManagerAvailable += $avgVal1-$avgVal;
}
if($value == "Housekeeper (Line Siding And Good s Yard)"){
$avgVal1 -= $avgVal;
$houseKeeper1Available += $avgVal1-$avgVal;
}
if($value == "Housekeeper (Drains)"){
$avgVal1 -= $avgVal;
$houseKeeper2Available += $avgVal1-$avgVal;
}
if($value == "House Keeper (Garbage Disposable)"){
$avgVal1 -= $avgVal;
$houseKeeper3Available += $avgVal1-$avgVal;
}
if($value == "Driver"){
$avgVal1 -= $avgVal;
$driverAvailable += $avgVal1-$avgVal;
}
if($value == "Pest Control"){
$avgVal1 -= $avgVal;
$pestcontrolAvailable += $avgVal1-$avgVal;
}
if($value == "P/Line(all) coaching yard Rag Picking"){
$avgVal1 -= $avgVal;
$plineAllRagPickingAvailable += $avgVal1-$avgVal;
}
if($value == "Pest control & Rodent worker"){
$avgVal1 -= $avgVal;
$pestandrodentWorkerAvailable += $avgVal1-$avgVal;
}
}
if($key2==2){
$foundWoDress += $avgVal;
}
if($key2==3){
$foundWoProGlass += $avgVal;
}
}
}
}
}
}
$totalAvailable = $managerAvailable+$supvisorAvailable+$machineOpeAvailable+$houseKeeperAvailable+$projectManagerAvailable+$houseKeeper1Available+$computerOperatorAvailable+$houseKeeper2Available+$houseKeeper3Available+$driverAvailable+$pestcontrolAvailable+$ragPickingAvailable+$headSupervisorAvailable+$plineAllRagPickingAvailable+$pestandrodentWorkerAvailable;
$absent= $totalAvailable==0 ? 0 : ($managerTarget-$managerAvailable)+($supvisorTarget-$supvisorAvailable)+($machineOpeTarget-$machineOpeAvailable)+($houseKeeperTarget-$houseKeeperAvailable)+($projectManagerTarget-$projectManagerAvailable)+($houseKeeper1Target-$houseKeeper1Available)+($houseKeeper2Target-$houseKeeper2Available)+($houseKeeper3Target-$houseKeeper3Available)+($computerOperatorTarget-$computerOperatorAvailable)+($driverTarget-$driverAvailable)+($pestcontrolTarget-$pestcontrolAvailable)+($ragPickingTarget-$ragPickingAvailable)+($headSupervisorTarget-$headSupervisorAvailable)+($plineAllRagPickingTarget-$plineAllRagPickingAvailable)+($pestandrodentWorkerTarget-$pestandrodentWorkerAvailable);
if ($userdata[0]['OrgID'] == 16 && date('Y-m-d',strtotime($date)) <= date('Y-m-d',strtotime('2021-09-30'))){
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1277)+
(($projectManagerTarget-$projectManagerAvailable)*1277)+
(($houseKeeper1Target-$houseKeeper1Available)*1034)+
(($houseKeeper2Target-$houseKeeper2Available)*1034)+
(($houseKeeper3Target-$houseKeeper3Available)*1034)+
(($supvisorTarget-$supvisorAvailable)*1130)+(($machineOpeTarget-$machineOpeAvailable)*1034)+(($houseKeeperTarget-$houseKeeperAvailable)*1034)+($foundWoDress*100);
}
elseif ($userdata[0]['OrgID'] == 21){
if ($Year =='2022' && $Month >='4' && $Month <='9') {
$totalPenalty += $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1625)+
(($supvisorTarget-$supvisorAvailable)*1625)+
(($houseKeeperTarget-$houseKeeperAvailable)*1553)+
($foundWoDress*100);
}
else if ($Year =='2023' && $Month <='3') {
$totalPenalty += $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1671)+
(($supvisorTarget-$supvisorAvailable)*1671)+
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
($foundWoDress*100);
}
else if ($Year >='2023' && $Month >='4'&& $Month <'10') {
$totalPenalty += $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1695)+
(($supvisorTarget-$supvisorAvailable)*1695)+
(($houseKeeperTarget-$houseKeeperAvailable)*1616)+
($foundWoDress*100);
}
else if ($Year =='2023' && $Month >='10') {
$totalPenalty += $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1709)+
(($supvisorTarget-$supvisorAvailable)*1709)+
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
($foundWoDress*100);
}
else if ($Year =='2024' && $Month <='3') {
$totalPenalty += $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1709)+
(($supvisorTarget-$supvisorAvailable)*1709)+
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
($foundWoDress*100);
}
else if ($Year =='2024' && $Month >='4') {
$totalPenalty += $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1734)+
(($supvisorTarget-$supvisorAvailable)*1734)+
(($houseKeeperTarget-$houseKeeperAvailable)*1651)+
($foundWoDress*100);
}
else if ($Year =='2022' && $Month >='10') {
$totalPenalty += $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1671)+
(($supvisorTarget-$supvisorAvailable)*1671)+
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
($foundWoDress*100);
}
else {
$totalPenalty += $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1617)+
(($supvisorTarget-$supvisorAvailable)*1617)+
(($houseKeeperTarget-$houseKeeperAvailable)*1546)+
($foundWoDress*100);
}
}
elseif ($userdata[0]['OrgID'] == 16)
{
if ($Year =='2022' && $Month >='10')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1366)+
(($projectManagerTarget-$projectManagerAvailable)*1366)+
(($houseKeeper1Target-$houseKeeper1Available)*1095)+
(($houseKeeper2Target-$houseKeeper2Available)*1095)+
(($houseKeeper3Target-$houseKeeper3Available)*1095)+
(($supvisorTarget-$supvisorAvailable)*1171)+(($machineOpeTarget-$machineOpeAvailable)*1095)+(($houseKeeperTarget-$houseKeeperAvailable)*1095)+($foundWoDress*100);
}
else if (($Year =='2022' && $Month >='4') || ($Year =='2022' && $Month <='9'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1346)+
(($projectManagerTarget-$projectManagerAvailable)*1346)+
(($houseKeeper1Target-$houseKeeper1Available)*1081)+
(($houseKeeper2Target-$houseKeeper2Available)*1081)+
(($houseKeeper3Target-$houseKeeper3Available)*1081)+
(($supvisorTarget-$supvisorAvailable)*1156)+(($machineOpeTarget-$machineOpeAvailable)*1081)+(($houseKeeperTarget-$houseKeeperAvailable)*1081)+($foundWoDress*100);
}
else {
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1295)+
(($projectManagerTarget-$projectManagerAvailable)*1295)+
(($houseKeeper1Target-$houseKeeper1Available)*1046)+
(($houseKeeper2Target-$houseKeeper2Available)*1046)+
(($houseKeeper3Target-$houseKeeper3Available)*1046)+
(($supvisorTarget-$supvisorAvailable)*1117)+(($machineOpeTarget-$machineOpeAvailable)*1046)+(($houseKeeperTarget-$houseKeeperAvailable)*1046)+($foundWoDress*100);
}
}
elseif ($userdata[0]['OrgID'] == 13)
{
if ($Year =='2022' && $Month >='10')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1788)+
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
(($supvisorTarget-$supvisorAvailable)*1671)+
(($machineOpeTarget-$machineOpeAvailable)*1595)+
($foundWoDress*0)+($foundWoProGlass*0);
}
elseif ($Year =='2023' && $Month >='1'&& $Month <'11')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1788)+
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
(($supvisorTarget-$supvisorAvailable)*1671)+
(($machineOpeTarget-$machineOpeAvailable)*1595)+
($foundWoDress*0)+($foundWoProGlass*0);
}
elseif ($Year =='2023' && $Month =='11')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1832)+
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
(($supvisorTarget-$supvisorAvailable)*1709)+
(($machineOpeTarget-$machineOpeAvailable)*1628)+
($foundWoDress*0)+($foundWoProGlass*0);
}
elseif ($Year =='2024' && $Month <='3')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1832)+
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
(($supvisorTarget-$supvisorAvailable)*1709)+
(($machineOpeTarget-$machineOpeAvailable)*1628)+
($foundWoDress*0)+($foundWoProGlass*0);
}
elseif ($Year =='2024' && $Month >'3' && $Month <'11' )
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1862)+
(($houseKeeperTarget-$houseKeeperAvailable)*1651)+
(($supvisorTarget-$supvisorAvailable)*1734)+
(($machineOpeTarget-$machineOpeAvailable)*1651)+
($foundWoDress*0)+($foundWoProGlass*0);
}
elseif ($Year =='2024' && $Month >'10')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1868)+
(($houseKeeperTarget-$houseKeeperAvailable)*1655)+
(($supvisorTarget-$supvisorAvailable)*1739)+
(($machineOpeTarget-$machineOpeAvailable)*1655)+
($foundWoDress*0)+($foundWoProGlass*0);
}
elseif ($Year =='2025' && $Month <='3')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1868)+
(($houseKeeperTarget-$houseKeeperAvailable)*1655)+
(($supvisorTarget-$supvisorAvailable)*1739)+
(($machineOpeTarget-$machineOpeAvailable)*1655)+
($foundWoDress*0)+($foundWoProGlass*0);
}
elseif ($Year =='2025' && $Month >='4')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1893)+
(($houseKeeperTarget-$houseKeeperAvailable)*1674)+
(($supvisorTarget-$supvisorAvailable)*1760)+
(($machineOpeTarget-$machineOpeAvailable)*1674)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else {
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1714)+
(($houseKeeperTarget-$houseKeeperAvailable)*1539)+
(($supvisorTarget-$supvisorAvailable)*1609)+
(($machineOpeTarget-$machineOpeAvailable)*1595)+
($foundWoDress*0)+($foundWoProGlass*0);
}
}
elseif ($userdata[0]['OrgID'] == 17)
{
if ($Year =='2021' && $Month <='9')
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1714)+
(($houseKeeperTarget-$houseKeeperAvailable)*731)+
(($supvisorTarget-$supvisorAvailable)*1000)+
(($driverTarget-$driverAvailable)*1505)+
(($pestcontrolTarget-$pestcontrolAvailable)*731)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2021' && $Month >'9') || ($Year =='2022' && $Month <='3'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1724)+
(($houseKeeperTarget-$houseKeeperAvailable)*737)+
(($supvisorTarget-$supvisorAvailable)*1012)+
(($driverTarget-$driverAvailable)*1512)+
(($pestcontrolTarget-$pestcontrolAvailable)*737)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2022' && $Month <='9'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1770)+
(($houseKeeperTarget-$houseKeeperAvailable)*766)+
(($supvisorTarget-$supvisorAvailable)*1044)+
(($driverTarget-$driverAvailable)*1544)+
(($pestcontrolTarget-$pestcontrolAvailable)*766)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2022' && ( $Month == '10' || $Month == '11' || $Month == '12')) || ($Year =='2023' && $Month <='3'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1788)+
(($houseKeeperTarget-$houseKeeperAvailable)*777)+
(($supvisorTarget-$supvisorAvailable)*1057)+
(($driverTarget-$driverAvailable)*1557)+
(($pestcontrolTarget-$pestcontrolAvailable)*777)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2023' && $Month >'3' && $Month <='9'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1816)+
(($houseKeeperTarget-$houseKeeperAvailable)*794)+
(($supvisorTarget-$supvisorAvailable)*1077)+
(($driverTarget-$driverAvailable)*1577)+
(($pestcontrolTarget-$pestcontrolAvailable)*794)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2023' && $Month >='10'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1832)+
(($houseKeeperTarget-$houseKeeperAvailable)*804)+
(($supvisorTarget-$supvisorAvailable)*1087)+
(($driverTarget-$driverAvailable)*1587)+
(($pestcontrolTarget-$pestcontrolAvailable)*804)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2024' && $Month >='1' && $Month <'4'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1832)+
(($houseKeeperTarget-$houseKeeperAvailable)*804)+
(($supvisorTarget-$supvisorAvailable)*1087)+
(($driverTarget-$driverAvailable)*1587)+
(($pestcontrolTarget-$pestcontrolAvailable)*804)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2024' && $Month >='4' && $Month <= '9'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1862)+
(($houseKeeperTarget-$houseKeeperAvailable)*822)+
(($supvisorTarget-$supvisorAvailable)*1110)+
(($driverTarget-$driverAvailable)*1610)+
(($pestcontrolTarget-$pestcontrolAvailable)*822)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2024' && $Month >='10'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1868)+
(($houseKeeperTarget-$houseKeeperAvailable)*826)+
(($supvisorTarget-$supvisorAvailable)*1114)+
(($driverTarget-$driverAvailable)*1614)+
(($pestcontrolTarget-$pestcontrolAvailable)*826)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2025' && $Month <='3'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1868)+
(($houseKeeperTarget-$houseKeeperAvailable)*826)+
(($supvisorTarget-$supvisorAvailable)*1114)+
(($driverTarget-$driverAvailable)*1614)+
(($pestcontrolTarget-$pestcontrolAvailable)*826)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2025' && $Month >='4'))
{
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1893)+
(($houseKeeperTarget-$houseKeeperAvailable)*841)+
(($supvisorTarget-$supvisorAvailable)*1132)+
(($driverTarget-$driverAvailable)*1632)+
(($pestcontrolTarget-$pestcontrolAvailable)*841)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else {
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1734)+
(($houseKeeperTarget-$houseKeeperAvailable)*743)+
(($supvisorTarget-$supvisorAvailable)*1090)+
(($driverTarget-$driverAvailable)*1519)+
(($pestcontrolTarget-$pestcontrolAvailable)*743)+
($foundWoDress*50)+($foundWoProGlass*100);
}
}
elseif ($userdata[0]['OrgID'] == 18){
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1195)+
(($houseKeeperTarget-$houseKeeperAvailable)*720)+
(($supvisorTarget-$supvisorAvailable)*1069)+
(($driverTarget-$driverAvailable)*920)+
(($pestcontrolTarget-$pestcontrolAvailable)*2000)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($userdata[0]['OrgID'] == 20){
$totalPenalty += $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*0)+
(($houseKeeperTarget-$houseKeeperAvailable)*1431)+
(($supvisorTarget-$supvisorAvailable)*1505)+
(($driverTarget-$driverAvailable)*0)+
(($pestcontrolTarget-$pestcontrolAvailable)*0)+
($foundWoDress*100);
}
elseif ($userdata[0]['OrgID'] == 24)
{
if ($Year =='2022' && $Month >='10')
{
$totalPenalty += $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1557)+
(($ragPickingTarget-$ragPickingAvailable)*1477)+
(($supvisorTarget-$supvisorAvailable)*1557)+
(($houseKeeperTarget-$houseKeeperAvailable)*1477)+
(($pestcontrolTarget-$pestcontrolAvailable)*1557)+
($foundWoDress*100);
}
elseif ($Year =='2023' && $Month <='3')
{
$totalPenalty += $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1557)+
(($ragPickingTarget-$ragPickingAvailable)*1477)+
(($supvisorTarget-$supvisorAvailable)*1557)+
(($houseKeeperTarget-$houseKeeperAvailable)*1477)+
(($pestcontrolTarget-$pestcontrolAvailable)*1557)+
($foundWoDress*100);
}
elseif ($Year =='2023' && $Month >='4')
{
$totalPenalty += $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1577)+
(($ragPickingTarget-$ragPickingAvailable)*1494)+
(($supvisorTarget-$supvisorAvailable)*1577)+
(($houseKeeperTarget-$houseKeeperAvailable)*1494)+
(($pestcontrolTarget-$pestcontrolAvailable)*1557)+
($foundWoDress*100);
}
else if($Year =='2022' && $Month >='4' && $Month <='9')
{
$totalPenalty += $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1519)+
(($ragPickingTarget-$ragPickingAvailable)*1443)+
(($houseKeeperTarget-$houseKeeperAvailable)*1443)+
(($supvisorTarget-$supvisorAvailable)*1519)+
(($pestcontrolTarget-$pestcontrolAvailable)*1519)+
($foundWoDress*100);
}
else {
$totalPenalty += $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1512)+
(($ragPickingTarget-$ragPickingAvailable)*1437)+
(($supvisorTarget-$supvisorAvailable)*1519)+
(($houseKeeperTarget-$houseKeeperAvailable)*1437)+
(($pestcontrolTarget-$pestcontrolAvailable)*1437)+
($foundWoDress*100);
}
}
elseif ($userdata[0]['OrgID'] == 25){
$totalPenalty += $totalAvailable==0 ? 0 :
(($headSupervisorTarget-$headSupervisorAvailable)*1512)+
(($houseKeeperTarget-$houseKeeperAvailable)*1437)+
(($ragPickingTarget-$ragPickingAvailable)*1437)+
(($pestcontrolTarget-$pestcontrolAvailable)*1512)+
($foundWoDress*100);
}
elseif ($userdata[0]['OrgID'] == 26){
$totalPenalty += $totalAvailable==0 ? 0 :
(($headSupervisorTarget-$headSupervisorAvailable)*1512)+
(($houseKeeperTarget-$houseKeeperAvailable)*1437)+
(($ragPickingTarget-$ragPickingAvailable)*1437)+
(($pestcontrolTarget-$pestcontrolAvailable)*1512)+
($foundWoDress*100);
}
elseif ($userdata[0]['OrgID'] == 28){
if ($Year =='2022' && $Month >'9') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
(($supvisorTarget-$supvisorAvailable)*1671)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2023' && $Month <='3') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
(($supvisorTarget-$supvisorAvailable)*1671)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2023' && $Month >='4'&& $Month <'10') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1616)+
(($supvisorTarget-$supvisorAvailable)*1695)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2023' && $Month >='10') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
(($supvisorTarget-$supvisorAvailable)*1709)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month <='3') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
(($supvisorTarget-$supvisorAvailable)*1709)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month >='4'&& $Month <'10') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1651)+
(($supvisorTarget-$supvisorAvailable)*1734)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month >'9') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1655)+
(($supvisorTarget-$supvisorAvailable)*1739)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2025' && $Month <='3') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1655)+
(($supvisorTarget-$supvisorAvailable)*1739)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2025' && $Month >='4') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1674)+
(($supvisorTarget-$supvisorAvailable)*1760)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2022' && $Month =='9') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1581)+
(($supvisorTarget-$supvisorAvailable)*1656)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2022' && $Month >'3' && $Month <'9') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1581)+
(($supvisorTarget-$supvisorAvailable)*1656)+
($foundWoDress*100)+($foundWoProGlass*100);
}
else {
$totalPenalty += $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*743)+
(($supvisorTarget-$supvisorAvailable)*1090)+
($foundWoDress*100)+($foundWoProGlass*100);
}
}
elseif ($userdata[0]['OrgID'] == 29){
$totalPenalty += $totalAvailable==0 ? 0 :
(($headSupervisorTarget-$headSupervisorAvailable)*1512)+
(($supvisorTarget-$supvisorAvailable)*1505)+
(($houseKeeperTarget-$houseKeeperAvailable)*1437)+
(($plineAllRagPickingTarget-$plineAllRagPickingAvailable)*1437)+
(($pestandrodentWorkerTarget-$pestandrodentWorkerAvailable)*1512)+
($foundWoDress*100);
}
elseif ($userdata[0]['OrgID'] == 30){
if ($Year =='2023' && $Month >='4') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1397)+
(($projectManagerTarget-$projectManagerAvailable)*1397)+
(($houseKeeper1Target-$houseKeeper1Available)*1116)+
(($houseKeeper2Target-$houseKeeper2Available)*1116)+
(($houseKeeper3Target-$houseKeeper3Available)*1116)+
(($supvisorTarget-$supvisorAvailable)*1195)+(($machineOpeTarget-$machineOpeAvailable)*1116)+(($houseKeeperTarget-$houseKeeperAvailable)*1116)+($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month >='1'&& $Month <'10') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1397)+
(($projectManagerTarget-$projectManagerAvailable)*1397)+
(($houseKeeper1Target-$houseKeeper1Available)*1116)+
(($houseKeeper2Target-$houseKeeper2Available)*1116)+
(($houseKeeper3Target-$houseKeeper3Available)*1116)+
(($supvisorTarget-$supvisorAvailable)*1195)+(($machineOpeTarget-$machineOpeAvailable)*1116)+(($houseKeeperTarget-$houseKeeperAvailable)*1116)+($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month >='10') {
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1454)+
(($projectManagerTarget-$projectManagerAvailable)*1454)+
(($houseKeeper1Target-$houseKeeper1Available)*1155)+
(($houseKeeper2Target-$houseKeeper2Available)*1155)+
(($houseKeeper3Target-$houseKeeper3Available)*1155)+
(($supvisorTarget-$supvisorAvailable)*1239)+(($machineOpeTarget-$machineOpeAvailable)*1155)+(($houseKeeperTarget-$houseKeeperAvailable)*1155)+($foundWoDress*100)+($foundWoProGlass*100);
}
else {
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1366)+
(($projectManagerTarget-$projectManagerAvailable)*1366)+
(($houseKeeper1Target-$houseKeeper1Available)*1095)+
(($houseKeeper2Target-$houseKeeper2Available)*1095)+
(($houseKeeper3Target-$houseKeeper3Available)*1095)+
(($supvisorTarget-$supvisorAvailable)*1171)+(($machineOpeTarget-$machineOpeAvailable)*1095)+(($houseKeeperTarget-$houseKeeperAvailable)*1095)+($foundWoDress*100)+($foundWoProGlass*100);
}
}
else{
if (date('Y-m-d',strtotime($date)) <= date('Y-m-d',strtotime('2021-04-01')) ) {
$totalPenalty += $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1714)+
(($projectManagerTarget-$projectManagerAvailable)*1714)+
(($houseKeeper1Target-$houseKeeper1Available)*1539)+
(($supvisorTarget-$supvisorAvailable)*1630)+
(($machineOpeTarget-$machineOpeAvailable)*1539)+
(($houseKeeperTarget-$houseKeeperAvailable)*1539);
}
//else {
//$totalPenalty += $totalAvailable==0 ? 0 :
//(($managerTarget-$managerAvailable)*1707)+
//(($projectManagerTarget-$projectManagerAvailable)*1707)+
//(($houseKeeper1Target-$houseKeeper1Available)*1707)+
//(($supvisorTarget-$supvisorAvailable)*1603)+
//(($machineOpeTarget-$machineOpeAvailable)*1534)+
//(($houseKeeperTarget-$houseKeeperAvailable)*1534);
//}
}
?>
<tr>
<td height="20" valign="middle" sdval="43891" sdnum="1033;1033;D-MMM-YYYY;@"><?php echo $i.'-'.date("M", mktime(null, null, null, $Month)).'-'.$Year ?></td>
<td valign="middle" sdval="32" sdnum="1033;"><?php echo $totalTarget; ?></td>
<td valign="middle" sdval="32" sdnum="1033;"><?php echo $totalAvailable; ?></td>
<td valign="middle" sdval="0" sdnum="1033;"><?php echo $absent ?></td>
<?php if ($userdata[0]['OrgID'] == 16 || $userdata[0]['OrgID'] == 17 || $userdata[0]['OrgID'] == 18 || $userdata[0]['OrgID'] == 21 || $userdata[0]['OrgID'] == 23 || $userdata[0]['OrgID'] == 24 || $userdata[0]['OrgID'] == 25 || $userdata[0]['OrgID'] == 30 || $userdata[0]['OrgID'] == 28){ ?>
<td valign="middle" sdval="0" sdnum="1033;"><?php echo $foundWoDress; ?></td>
<?php }?>
<td valign="middle" sdval="1" sdnum="1033;"><?php echo $foundWoProGlass; ?></td>
<td valign="middle" sdval="20" sdnum="1033;"><?php
// echo ($absent*1525)+($foundWoDress*100)+($foundWoProGlass*20)
if ($userdata[0]['OrgID'] == 16)
{
if ($Year =='2022' && $Month >='10')
{
echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1366)+
(($projectManagerTarget-$projectManagerAvailable)*1366)+
(($houseKeeper1Target-$houseKeeper1Available)*1095)+
(($houseKeeper2Target-$houseKeeper2Available)*1095)+
(($houseKeeper3Target-$houseKeeper3Available)*1095)+
(($supvisorTarget-$supvisorAvailable)*1171)+(($machineOpeTarget-$machineOpeAvailable)*1095)+(($houseKeeperTarget-$houseKeeperAvailable)*1095)+($foundWoDress*100);
}
else if (($Year =='2022' && $Month >='4') || ($Year =='2022' && $Month <='9'))
{
echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1346)+
(($projectManagerTarget-$projectManagerAvailable)*1346)+
(($houseKeeper1Target-$houseKeeper1Available)*1081)+
(($houseKeeper2Target-$houseKeeper2Available)*1081)+
(($houseKeeper3Target-$houseKeeper3Available)*1081)+
(($supvisorTarget-$supvisorAvailable)*1156)+(($machineOpeTarget-$machineOpeAvailable)*1081)+(($houseKeeperTarget-$houseKeeperAvailable)*1081)+($foundWoDress*100);
}
else {
echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1295)+
(($projectManagerTarget-$projectManagerAvailable)*1295)+
(($houseKeeper1Target-$houseKeeper1Available)*1046)+
(($houseKeeper2Target-$houseKeeper2Available)*1046)+
(($houseKeeper3Target-$houseKeeper3Available)*1046)+
(($supvisorTarget-$supvisorAvailable)*1117)+(($machineOpeTarget-$machineOpeAvailable)*1046)+(($houseKeeperTarget-$houseKeeperAvailable)*1046)+($foundWoDress*100);
}
}
elseif ($userdata[0]['OrgID'] == 17 || $userdata[0]['OrgID'] == 18)
{
if ($Year =='2021' && $Month <='9')
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1714)+
(($houseKeeperTarget-$houseKeeperAvailable)*731)+
(($supvisorTarget-$supvisorAvailable)*1000)+
(($driverTarget-$driverAvailable)*1505)+
(($pestcontrolTarget-$pestcontrolAvailable)*731)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2021' && $Month >'9') || ($Year =='2022' && $Month <='3'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1724)+
(($houseKeeperTarget-$houseKeeperAvailable)*737)+
(($supvisorTarget-$supvisorAvailable)*1012)+
(($driverTarget-$driverAvailable)*1512)+
(($pestcontrolTarget-$pestcontrolAvailable)*737)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2022' && $Month <='9'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1770)+
(($houseKeeperTarget-$houseKeeperAvailable)*766)+
(($supvisorTarget-$supvisorAvailable)*1044)+
(($driverTarget-$driverAvailable)*1544)+
(($pestcontrolTarget-$pestcontrolAvailable)*766)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2022' && ( $Month == '10' || $Month == '11' || $Month == '12')) || ($Year =='2023' && $Month <='3'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1788)+
(($houseKeeperTarget-$houseKeeperAvailable)*777)+
(($supvisorTarget-$supvisorAvailable)*1057)+
(($driverTarget-$driverAvailable)*1557)+
(($pestcontrolTarget-$pestcontrolAvailable)*777)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2023' && $Month >'3' && $Month <='9'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1816)+
(($houseKeeperTarget-$houseKeeperAvailable)*794)+
(($supvisorTarget-$supvisorAvailable)*1077)+
(($driverTarget-$driverAvailable)*1577)+
(($pestcontrolTarget-$pestcontrolAvailable)*794)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2023' && $Month >='10'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1832)+
(($houseKeeperTarget-$houseKeeperAvailable)*804)+
(($supvisorTarget-$supvisorAvailable)*1087)+
(($driverTarget-$driverAvailable)*1587)+
(($pestcontrolTarget-$pestcontrolAvailable)*804)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2024' && $Month >='1' && $Month <'4'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1832)+
(($houseKeeperTarget-$houseKeeperAvailable)*804)+
(($supvisorTarget-$supvisorAvailable)*1087)+
(($driverTarget-$driverAvailable)*1587)+
(($pestcontrolTarget-$pestcontrolAvailable)*804)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2024' && $Month >='4' && $Month <='9'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1862)+
(($houseKeeperTarget-$houseKeeperAvailable)*822)+
(($supvisorTarget-$supvisorAvailable)*1110)+
(($driverTarget-$driverAvailable)*1610)+
(($pestcontrolTarget-$pestcontrolAvailable)*822)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2024' && $Month >='10'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1868)+
(($houseKeeperTarget-$houseKeeperAvailable)*826)+
(($supvisorTarget-$supvisorAvailable)*1114)+
(($driverTarget-$driverAvailable)*1614)+
(($pestcontrolTarget-$pestcontrolAvailable)*826)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2025' && $Month <='3'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1868)+
(($houseKeeperTarget-$houseKeeperAvailable)*826)+
(($supvisorTarget-$supvisorAvailable)*1114)+
(($driverTarget-$driverAvailable)*1614)+
(($pestcontrolTarget-$pestcontrolAvailable)*826)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else if (($Year =='2025' && $Month >='4'))
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1893)+
(($houseKeeperTarget-$houseKeeperAvailable)*841)+
(($supvisorTarget-$supvisorAvailable)*1132)+
(($driverTarget-$driverAvailable)*1632)+
(($pestcontrolTarget-$pestcontrolAvailable)*841)+
($foundWoDress*50)+($foundWoProGlass*100);
}
else {
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1734)+
(($houseKeeperTarget-$houseKeeperAvailable)*743)+
(($supvisorTarget-$supvisorAvailable)*1090)+
(($driverTarget-$driverAvailable)*1519)+
(($pestcontrolTarget-$pestcontrolAvailable)*743)+
($foundWoDress*50)+($foundWoProGlass*100);
}
}
elseif ($userdata[0]['OrgID'] == 13)
{
if ($Year =='2022' && $Month >='10')
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1788)+
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
(($supvisorTarget-$supvisorAvailable)*1671)+
(($machineOpeTarget-$machineOpeAvailable)*1595)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else if ($Year =='2023' && $Month >='1'&& $Month <'11')
{
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1788)+
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
(($supvisorTarget-$supvisorAvailable)*1671)+
(($machineOpeTarget-$machineOpeAvailable)*1595)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else if ($Year =='2023' && $Month >='11')
{
echo $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1832)+
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
(($supvisorTarget-$supvisorAvailable)*1709)+
(($machineOpeTarget-$machineOpeAvailable)*1628)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else if ($Year =='2024' && $Month <='3')
{
echo $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1832)+
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
(($supvisorTarget-$supvisorAvailable)*1709)+
(($machineOpeTarget-$machineOpeAvailable)*1628)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else if ($Year =='2024' && $Month >'3' && $Month <'11' )
{
echo $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1862)+
(($houseKeeperTarget-$houseKeeperAvailable)*1651)+
(($supvisorTarget-$supvisorAvailable)*1734)+
(($machineOpeTarget-$machineOpeAvailable)*1651)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else if ($Year =='2024' && $Month >'10')
{
echo $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1868)+
(($houseKeeperTarget-$houseKeeperAvailable)*1655)+
(($supvisorTarget-$supvisorAvailable)*1739)+
(($machineOpeTarget-$machineOpeAvailable)*1655)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else if ($Year =='2025' && $Month <='3')
{
echo $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1868)+
(($houseKeeperTarget-$houseKeeperAvailable)*1655)+
(($supvisorTarget-$supvisorAvailable)*1739)+
(($machineOpeTarget-$machineOpeAvailable)*1655)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else if ($Year =='2025' && $Month >='4')
{
echo $totalAvailable==0 ? 0 :
(($managerTarget-$managerAvailable)*1893)+
(($houseKeeperTarget-$houseKeeperAvailable)*1674)+
(($supvisorTarget-$supvisorAvailable)*1760)+
(($machineOpeTarget-$machineOpeAvailable)*1674)+
($foundWoDress*0)+($foundWoProGlass*0);
}
else {
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1714)+
(($houseKeeperTarget-$houseKeeperAvailable)*1539)+
(($supvisorTarget-$supvisorAvailable)*1609)+
(($machineOpeTarget-$machineOpeAvailable)*1539)+
($foundWoDress*0)+($foundWoProGlass*0);
}
}
elseif ($userdata[0]['OrgID'] == 18){
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*1195)+
(($houseKeeperTarget-$houseKeeperAvailable)*720)+
(($supvisorTarget-$supvisorAvailable)*1069)+
(($driverTarget-$driverAvailable)*920)+
(($pestcontrolTarget-$pestcontrolAvailable)*2000)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($userdata[0]['OrgID'] == 20){
echo $totalAvailable==0 ? 0 :
(($projectManagerTarget-$projectManagerAvailable)*0)+
(($houseKeeperTarget-$houseKeeperAvailable)*1431)+
(($supvisorTarget-$supvisorAvailable)*1505)+
(($driverTarget-$driverAvailable)*0)+
(($pestcontrolTarget-$pestcontrolAvailable)*0)+
($foundWoDress*100);
}
elseif ($userdata[0]['OrgID'] == 21){
if ($Year =='2022' && $Month >='4' && $Month <='9') {
echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1625)+
(($supvisorTarget-$supvisorAvailable)*1625)+
(($houseKeeperTarget-$houseKeeperAvailable)*1553)+
($foundWoDress*100);
}
else if ($Year =='2023' && $Month <='3') {
echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1671)+
(($supvisorTarget-$supvisorAvailable)*1671)+
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
($foundWoDress*100);
}
else if ($Year =='2023' && $Month >='4'&& $Month <'10') {
echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1695)+
(($supvisorTarget-$supvisorAvailable)*1695)+
(($houseKeeperTarget-$houseKeeperAvailable)*1616)+
($foundWoDress*100);
}
else if ($Year =='2023' && $Month >='10') {
echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1709)+
(($supvisorTarget-$supvisorAvailable)*1709)+
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
($foundWoDress*100);
}
else if ($Year =='2024' && $Month <='3') {
echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1709)+
(($supvisorTarget-$supvisorAvailable)*1709)+
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
($foundWoDress*100);
}
else if ($Year =='2024' && $Month >='4') {
echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1734)+
(($supvisorTarget-$supvisorAvailable)*1734)+
(($houseKeeperTarget-$houseKeeperAvailable)*1651)+
($foundWoDress*100);
}
else if ($Year =='2022' && $Month >='10') {
echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1671)+
(($supvisorTarget-$supvisorAvailable)*1671)+
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
($foundWoDress*100);
}
else {
echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1617)+
(($supvisorTarget-$supvisorAvailable)*1617)+
(($houseKeeperTarget-$houseKeeperAvailable)*1546)+
($foundWoDress*100);
}
}
elseif ($userdata[0]['OrgID'] == 24)
{
if ($Year =='2022' && $Month >='10')
{
echo $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1557)+
(($ragPickingTarget-$ragPickingAvailable)*1477)+
(($houseKeeperTarget-$houseKeeperAvailable)*1477)+
(($supvisorTarget-$supvisorAvailable)*1557)+
(($pestcontrolTarget-$pestcontrolAvailable)*1557)+
($foundWoDress*100);
}
elseif ($Year =='2023' && $Month <='3')
{
echo $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1557)+
(($ragPickingTarget-$ragPickingAvailable)*1477)+
(($houseKeeperTarget-$houseKeeperAvailable)*1477)+
(($supvisorTarget-$supvisorAvailable)*1557)+
(($pestcontrolTarget-$pestcontrolAvailable)*1557)+
($foundWoDress*100);
}
elseif ($Year =='2023' && $Month >='4')
{
echo $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1577)+
(($ragPickingTarget-$ragPickingAvailable)*1494)+
(($houseKeeperTarget-$houseKeeperAvailable)*1494)+
(($supvisorTarget-$supvisorAvailable)*1577)+
(($pestcontrolTarget-$pestcontrolAvailable)*1577)+
($foundWoDress*100);
}
else if($Year =='2022' && $Month >='4' && $Month <='9')
{
echo $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1519)+
(($ragPickingTarget-$ragPickingAvailable)*1443)+
(($supvisorTarget-$supvisorAvailable)*1519)+
(($houseKeeperTarget-$houseKeeperAvailable)*1443)+
(($pestcontrolTarget-$pestcontrolAvailable)*1519)+
($foundWoDress*100);
}
else {
echo $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1512)+
(($ragPickingTarget-$ragPickingAvailable)*1437)+
(($houseKeeperTarget-$houseKeeperAvailable)*1437)+
(($supvisorTarget-$supvisorAvailable)*1512)+
(($pestcontrolTarget-$pestcontrolAvailable)*1437)+
($foundWoDress*100);
}
}
elseif ($userdata[0]['OrgID'] == 25){
echo $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1512)+
(($ragPickingTarget-$ragPickingAvailable)*1437)+
(($houseKeeperTarget-$houseKeeperAvailable)*1437)+
(($pestcontrolTarget-$pestcontrolAvailable)*1437)+
($foundWoDress*100);
}
elseif ($userdata[0]['OrgID'] == 28){
if ($Year =='2022' && $Month >'9') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
(($supvisorTarget-$supvisorAvailable)*1671)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2023' && $Month <='3') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1595)+
(($supvisorTarget-$supvisorAvailable)*1671)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2023' && $Month >'3' && $Month <'10') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1616)+
(($supvisorTarget-$supvisorAvailable)*1695)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month <='3') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
(($supvisorTarget-$supvisorAvailable)*1709)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month >='4'&& $Month <'10') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1651)+
(($supvisorTarget-$supvisorAvailable)*1734)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month >'9') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1655)+
(($supvisorTarget-$supvisorAvailable)*1739)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2025' && $Month <='3') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1655)+
(($supvisorTarget-$supvisorAvailable)*1739)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2025' && $Month >='4') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1674)+
(($supvisorTarget-$supvisorAvailable)*1760)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2023' && $Month >='10') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1628)+
(($supvisorTarget-$supvisorAvailable)*1709)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2022' && $Month ='9') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1581)+
(($supvisorTarget-$supvisorAvailable)*1656)+
($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2022' && $Month >'3' && $Month <'9') {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*1581)+
(($supvisorTarget-$supvisorAvailable)*1656)+
($foundWoDress*100)+($foundWoProGlass*100);
}
else {
echo $totalAvailable==0 ? 0 :
(($houseKeeperTarget-$houseKeeperAvailable)*743)+
(($supvisorTarget-$supvisorAvailable)*1090)+
($foundWoDress*100)+($foundWoProGlass*100);
}
}
elseif ($userdata[0]['OrgID'] == 29){
echo $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1512)+
(($supvisorTarget-$supvisorAvailable)*1505)+
(($houseKeeperTarget-$houseKeeperAvailable)*1437)+
(($plineAllRagPickingTarget-$plineAllRagPickingAvailable)*1437)+
(($pestandrodentWorkerTarget-$pestandrodentWorkerAvailable)*1512)+
($foundWoDress*100);
}
elseif ($userdata[0]['OrgID'] == 30){
if ($Year =='2023' && $Month >='4') {
echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1397)+
(($projectManagerTarget-$projectManagerAvailable)*1397)+
(($houseKeeper1Target-$houseKeeper1Available)*1116)+
(($houseKeeper2Target-$houseKeeper2Available)*1116)+
(($houseKeeper3Target-$houseKeeper3Available)*1116)+
(($supvisorTarget-$supvisorAvailable)*1195)+(($machineOpeTarget-$machineOpeAvailable)*1116)+(($houseKeeperTarget-$houseKeeperAvailable)*1116)+($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month >='1'&& $Month <'10') {
echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1397)+
(($projectManagerTarget-$projectManagerAvailable)*1397)+
(($houseKeeper1Target-$houseKeeper1Available)*1116)+
(($houseKeeper2Target-$houseKeeper2Available)*1116)+
(($houseKeeper3Target-$houseKeeper3Available)*1116)+
(($supvisorTarget-$supvisorAvailable)*1195)+(($machineOpeTarget-$machineOpeAvailable)*1116)+(($houseKeeperTarget-$houseKeeperAvailable)*1116)+($foundWoDress*100)+($foundWoProGlass*100);
}
elseif ($Year =='2024' && $Month >='10') {
echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1454)+
(($projectManagerTarget-$projectManagerAvailable)*1454)+
(($houseKeeper1Target-$houseKeeper1Available)*1155)+
(($houseKeeper2Target-$houseKeeper2Available)*1155)+
(($houseKeeper3Target-$houseKeeper3Available)*1155)+
(($supvisorTarget-$supvisorAvailable)*1239)+(($machineOpeTarget-$machineOpeAvailable)*1155)+(($houseKeeperTarget-$houseKeeperAvailable)*1155)+($foundWoDress*100)+($foundWoProGlass*100);
}
else {
echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1366)+
(($projectManagerTarget-$projectManagerAvailable)*1366)+
(($houseKeeper1Target-$houseKeeper1Available)*1095)+
(($houseKeeper2Target-$houseKeeper2Available)*1095)+
(($houseKeeper3Target-$houseKeeper3Available)*1095)+
(($supvisorTarget-$supvisorAvailable)*1171)+(($machineOpeTarget-$machineOpeAvailable)*1095)+(($houseKeeperTarget-$houseKeeperAvailable)*1095)+($foundWoDress*100)+($foundWoProGlass*100);
}
}
else{
if (date('Y-m-d',strtotime($date)) >= date('Y-m-d',strtotime('2021-04-01')) ) {
echo
$totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1714)+
(($projectManagerTarget-$projectManagerAvailable)*1714)+
(($houseKeeper1Target-$houseKeeper1Available)*1539)+
(($houseKeeper2Target-$houseKeeper2Available)*1539)+
(($houseKeeper3Target-$houseKeeper3Available)*1539)+
(($supvisorTarget-$supvisorAvailable)*1630 )+
(($machineOpeTarget-$machineOpeAvailable)*1539)+
(($houseKeeperTarget-$houseKeeperAvailable)*1539);
}
else {
echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1707)+
(($projectManagerTarget-$projectManagerAvailable)*1707)+
(($houseKeeper1Target-$houseKeeper1Available)*1707)+
(($houseKeeper2Target-$houseKeeper2Available)*1707)+
(($houseKeeper3Target-$houseKeeper3Available)*1707)+
(($supvisorTarget-$supvisorAvailable)*1603)+
(($machineOpeTarget-$machineOpeAvailable)*1534)+
(($houseKeeperTarget-$houseKeeperAvailable)*1534) ;
}
}
?></td>
</tr>
<?php } ?>
<script type="text/javascript">$('#totalPenalty').text('<?php echo $totalPenalty ?>')</script>
<tr>
<td height="20" colspan="4" class="text-right" style=" text-align: right; padding-right: 17px !important;">Total Month Penalty</td>
<td height="20"><?php echo $totalPenalty; ?></td>
</tr>
<tr class="no_br report_header2 signature" style="">
<td colspan="28" height="28" 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>
</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>
$(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;
}
}
$('#month').val('<?php echo $Month ?>');
$('#year').val('<?php echo $Year ?>');
</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; }
/*tr td:nth-child(6) {display:none;}*/
</style>