HEX
Server: Apache
System: Linux 185.122.168.184.host.secureserver.net 5.14.0-570.52.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Oct 15 06:39:08 EDT 2025 x86_64
User: barbeatleanalyti (1024)
PHP: 8.1.33
Disabled: NONE
Upload Files
File: /home/barbeatleanalyti/public_html/baris.beatleanalytics.com/site/template/22
<!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 :<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){
     ?>
    <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){?>
      <b>
        Penalty for the Day : Manager @ Rs 1277/ Person, Supervisor @ Rs 1130/ Person,House Keeper @ Rs 1034/ Person</b>
      <?php } 
      else if ($userdata[0]['OrgID'] == 13 ){
      ?>
      <b>
        Penalty for the Day : Manager @ Rs 1714/ Person, Supervisor @ Rs 1609/ Person,House Keeper @ Rs 1539/ Person</b>
      <?php
      }
	  else if ($userdata[0]['OrgID'] == 16 ){
      ?>
      <b>
        Penalty for the Day :Manager @ Rs 1295/ Person, Supervisor @ Rs 1117/ Person,House Keeper @ Rs 1046/ Person</b>
      <?php
      }
	  else if ($userdata[0]['OrgID'] == 21 ){
      ?>
      <b>
        Penalty for the Day :Computer Operator @ Rs 1617/ Person,Supervisor @ Rs 1617/ Person,House Keeper @ Rs 1546/ Person</b>
      <?php
      }
       else if ($userdata[0]['OrgID'] == 20 ){
      ?>
      <b>
        Penalty for the Day :Supervisor @ Rs 1505/ Person,House Keeper @ Rs 1431/ Person</b>
      <?php
      }
      else if ($userdata[0]['OrgID'] == 24 ){
      ?>
      <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'] == 25 ){
      ?>
      <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 {
        ?>
              <b>
        Penalty for the Day : Manager @ Rs 1707/ Person, Supervisor @ Rs 1603/ Person, 
        Machine Operator @ Rs 1534/ Person,House Keeper @ Rs 1534/ Person</b>

      <?php }?>
    </td>
  </tr>

  <?php 

  // if($_SESSION['UserInfo']['OrgID'] == 16){
  //   $QuestionId = 19;
  //   $mQuestionId = 15;
  // }else{
  //   $QuestionId = 4;
  //   $mQuestionId = 14;
  // }

  $mQuestionId = getquestionid('PMC');
  $QuestionId = getsubquestionid('PMC','manpower_log');

  $rsParamIDS = SubQuestionGroupIDS('params',$QuestionId);//subquestion
  $rsPagesIDS = SubQuestionGroupIDS('pages',$rsParamIDS[0]);
  $totalTarget = 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;

  foreach ($rsParamIDS as $key => $rsParams){
        
    $rsParamData = $objScorecardctsnew->getParamsData($rsParams);
    $desc = explode(',', $rsParamData[0]['paramChoice']);
        
    $rsTargetData = $objScorecardctsnew->getTarget($mQuestionId,$QuestionId,$rsParams);
    $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];
      
      }
      
  } 

  $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;
   

      $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($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($key2==2){
                    $foundWoDress += $avgVal;
                  }
                  if($key2==3){
                    $foundWoProGlass += $avgVal;
                  }
                }
              }
            }
          }
      }  
  
  // $absent = $actualAvailable==0 ? 0 : $totalTarget-$actualAvailable;
      // $totalPenalty += ($absent*1525)+($foundWoDress*100)+($foundWoProGlass*20);
      //$totalPenalty += (($managerTarget-$managerAvailable)*1707)+(($supvisorTarget-$supvisorAvailable)*1603)+(($storeKeeperTarget-$storeKeeperAvailable)*100)+(($machineOpeTarget-$machineOpeAvailable)*1534)+(($houseKeeperTarget-$houseKeeperAvailable)*1534);

     // $totalAvailable = $managerAvailable+$supvisorAvailable+$machineOpeAvailable+$houseKeeperAvailable;
     $totalAvailable = $managerAvailable+$supvisorAvailable+$machineOpeAvailable+$houseKeeperAvailable+$projectManagerAvailable+$houseKeeper1Available+$computerOperatorAvailable+$houseKeeper2Available+$houseKeeper3Available+$driverAvailable+$pestcontrolAvailable+$ragPickingAvaliable+$headSupervisorAvaliable;

      $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);
	
      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){

         $totalPenalty += $totalAvailable==0 ? 0 : 
           (($computerOperatorTarget-$computerOperatorAvailable)*1617)+
           (($supvisorTarget-$supvisorAvailable)*1617)+
           (($houseKeeperTarget-$houseKeeperAvailable)*1546)+
           ($foundWoDress*100);


     }
      elseif ($userdata[0]['OrgID'] == 16 and date('Y-m-d',strtotime($date))  >= date('Y-m-d',strtotime('2021-10-01'))){

          $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'] == 17 || $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);
      }
      
      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){

         $totalPenalty += $totalAvailable==0 ? 0 : 
                    (($headSupervisorTarget-$headSupervisorAvailable)*1512)+
                    (($houseKeeperTarget-$houseKeeperAvailable)*1437)+
                    (($ragPickingTarget-$ragPickingAvailable)*1437)+
                    (($pestcontrolTarget-$pestcontrolAvailable)*1512)+
                    ($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);
      }
      else{
	 
	    //   if (date('Y-m-d',strtotime($date)) >= date('Y-m-d',strtotime('2020-09-29')) ) {
	          
	         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);
	       	 	
	           /*$totalPenalty += $totalAvailable==0 ? 0 : 
	           (($managerTarget-$managerAvailable)*1733)+
	           (($supvisorTarget-$supvisorAvailable)*1569)+
	           (($machineOpeTarget-$machineOpeAvailable)*1503)+
	           (($houseKeeperTarget-$houseKeeperAvailable)*1503);*/
	       		
	           }
    }
     //echo $date;
  ?>
  <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){ ?>
    <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 && date('Y-m-d',strtotime($date))  <= date('Y-m-d',strtotime('2021-09-30'))){

        echo $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'] == 16 && date('Y-m-d',strtotime($date))  >= date('Y-m-d',strtotime('2021-10-01'))){
		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){
        echo $totalAvailable==0 ? 0 : 
                    (($projectManagerTarget-$projectManagerAvailable)*1195)+
                    (($houseKeeperTarget-$houseKeeperAvailable)*720)+
                    (($supvisorTarget-$supvisorAvailable)*1069)+
                    (($driverTarget-$driverAvailable)*920)+
                    (($pestcontrolTarget-$pestcontrolAvailable)*2000)+
                    ($foundWoDress*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){
		echo $totalAvailable==0 ? 0 : (($computerOperatorTarget-$computerOperatorAvailable)*1617)+
        (($supvisorTarget-$supvisorAvailable)*1617)+
        (($houseKeeperTarget-$houseKeeperAvailable)*1546)+
        ($foundWoDress*100);
      
	  }

    elseif ($userdata[0]['OrgID'] == 24){
    echo $totalAvailable==0 ? 0 : (($headSupervisorTarget-$headSupervisorAvailable)*1512)+
        (($ragPickingTarget-$ragPickingAvailable)*1437)+
        (($houseKeeperTarget-$houseKeeperAvailable)*1437)+
        (($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);
      
    }
    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)  ;
	       	 	
	           /*$totalPenalty += $totalAvailable==0 ? 0 : 
	           (($managerTarget-$managerAvailable)*1733)+
	           (($supvisorTarget-$supvisorAvailable)*1569)+
	           (($machineOpeTarget-$machineOpeAvailable)*1503)+
	           (($houseKeeperTarget-$houseKeeperAvailable)*1503);*/
	       		
	           }

      /*if (date('Y-m-d',strtotime($date)) <= date('Y-m-d',strtotime('2020-09-30'))) {

          echo $totalAvailable==0 ? 0 : 
          (($managerTarget-$managerAvailable)*1733)+
          (($supvisorTarget-$supvisorAvailable)*1569)+
          (($machineOpeTarget-$machineOpeAvailable)*1503)+
          (($houseKeeperTarget-$houseKeeperAvailable)*1503)  ;
        } 
        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)  ;

        }*/
    }
    /*if ($date <= '2020-09-19'){
    
    echo $totalAvailable==0 ? 0 : (($managerTarget-$managerAvailable)*1733)+(($supvisorTarget-$supvisorAvailable)*1569)+(($machineOpeTarget-$machineOpeAvailable)*1503)+(($houseKeeperTarget-$houseKeeperAvailable)*1503)  ;
      }else {*/
   
      //}
    ?></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>
          <span class="t_nas" id="" style="padding: 0px 20px 36px 20px; margin-left: 20%;">CHI IN Charge</span> 
        </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>