1){ $flo='s'; while($apr = mysqli_fetch_array($qRater)){ $qRow = $qRow + 1; } }else{ $flo=''; } //GET RATER ENTRY COUNT and COMPARE IT TO TOTAL RATER COUNT $qeRow=0; $raterEntryCount = "SELECT * FROM `pef_evaluation_behavioral` WHERE `pcp_id` ='$pcpID' AND `emp_record_id` = '$empRecordID' AND `deleted`=0 GROUP BY `evaluator_id`"; $qERate = mysqli_query($conn,$raterEntryCount); $lockMyview = 'Enable'; while($lck = mysqli_fetch_array($qERate)){ if($lck['evaluator_id']== $userID){ $lockMyview = 'Disabled'; } $qeRow =$qeRow + 1; } if($qeRow == $qRow){ $partTwoEvalutionButton = ''; }else{ $partTwoEvalutionButton = ''; } echo ""; echo ""; echo ""; //Get PCP Period $divisorCount = 6; $pcpPeriod="SELECT `period_count` AS 'pcpPeriodCount' FROM `pcp_headers` WHERE `id`='$pcpID'"; $qpcp = mysqli_query($conn,$pcpPeriod); while($nr = mysqli_fetch_array($qpcp)){ $divisorCount =$nr['pcpPeriodCount']; } $totaNGSumOfWeight = 0; $pefKraWPointF=0; $totaPtwoWeight = 0; $perCentilePTwo = 0; $adjPTow = 0; $plusFactorPTS=0; $multiplierPTS=0; $kraCount = 0; $weightedPointsTotal =0; $approvalButton = ""; $rateeAgreeID =""; $nextHeadID =""; $nextHeadButton=""; $approvedID =""; $confirnData=""; $potentialNotes =""; $suitabilityNotes=""; $competencyNotes=""; $competency =""; $suitability=""; $potential=""; $strength=""; $improvement=""; $tNR=0; $tPercent=""; $tadj=""; $tWP=""; $tOverAll =""; $tOverAdj=""; $confirmNotes=""; $nextHeadNotes =""; $bWeight=""; $inputValue=""; $Notes=""; $weightedPoints=""; $lockNotes=""; $rateeAgreeButton =""; $nextHeadButton = ""; $nextHeadIDButton = ""; //get Formula for later use $pi = "SELECT * FROM `pms_formula` WHERE deleted = 0 LIMIT 1"; $qPi = mysqli_query($conn,$pi); while($row = mysqli_fetch_array($qPi)){ $multiplierPTS = $row['multiplier_pts']; $plusFactorPTS = $row['plus_factor_pts']; $nrMaxCount = $row['nr_max_count']; } //check if PEF has been created and approved $sql ="SELECT * FROM `pef_evaluation_data` WHERE `pcp_id`='$pcpID' AND `deleted`=0 AND `emp_record_id`='$empRecordID'"; $sqlQ = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($sqlQ); if($statRow > 0){ $chkIfMyIDExist = "SELECT * FROM `pef_evaluation_behavioral` WHERE `pcp_id`='$pcpID' AND `deleted`=0 AND `emp_record_id`='$empRecordID' AND `evaluator_id`='$userID'"; $qExist = mysqli_query($conn,$chkIfMyIDExist); $qExCount = mysqli_num_rows($qExist); if($qExCount > 0){ $approvedID = $empRecordID; while($row = mysqli_fetch_array($sqlQ)){ $rateeAgreeID =$row['emp_confirm_by']; $nextHeadID =$row['next_head_approval_id']; $approvedID =$row['evaluated_by']; } } }else{ $rateeAgreeID =0; $nextHeadID =0; $approvedID =0; } if($approvedID == 0 && $nextHeadID == 0 && $rateeAgreeID == 0 ){ if($lockMyview ==='Enable'){ $approvalButton = "ENABLE"; }else{ $approvalButton = "DISABLED"; } $rateeAgreeButton = "DISABLED"; $nextHeadIDButton = "DISABLED"; $lockNotes = "block"; $msg= $qeRow ." / " . $qRow . " Approver".$flo." submitted their assessment"; } //echo $qExCount; //echo $nextHeadID; //echo $rateeAgreeID; if($approvedID != 0 && $nextHeadID == 0 && $rateeAgreeID == 0 ){ $approvalButton = "DISABLED"; $rateeAgreeButton = "ENABLE"; $nextHeadIDButton = "DISABLED"; $lockNotes = "block"; if($qeRow == $qRow){ $msg="Waiting for employee confirmation"; }else{ $msg= $qeRow ." / " . $qRow . " Approver".$flo." submitted their evaluation."; } } if($approvedID != 0 && $nextHeadID == 0 && $rateeAgreeID != 0 ){ $approvalButton = "DISABLED"; $rateeAgreeButton = "DISABLED"; $nextHeadIDButton = "ENABLE"; $lockNotes = "block"; $msg="Waiting for Next Higher Head Approval."; } if($approvedID != 0 && $nextHeadID != 0 && $rateeAgreeID != 0 ){ $approvalButton = "DISABLED"; $rateeAgreeButton = "DISABLED"; $nextHeadIDButton = "DISABLED"; $lockNotes = "block"; $msg="Closed PEF Record"; } ?> $kraID"; echo ""; echo ""; //================================================================= //================================================================= if($GetPCPSemester==="1ST"){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //================================================================= }else{ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //================================================================= //================================================================= echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>

PART I - OUTPUT / ACCOMPLISHMENT (70%)
NO. KRA's / KPI's WEIGHT JAN. FEB. MAR. APR. MAY JUN. JUL. AUG. SEP. OCT. NOV. DEC. Numerical Rating Weighted Points
"; // $kraName = "SELECT * FROM `kra_employee_tbl` WHERE `id`='$kraID' AND `emp_id`='$userID'"; // $kraN = mysqli_query($conn,$kraName); // while($kna=mysqli_fetch_array($kraN)){ // echo $kna['kra_name']; // $weight = $kna['weight']; // } echo getEmployeeKRAName($kraID)[0]; $weight =getEmployeeKRAName($kraID)[1]; echo "$weight"; $jMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=1"; $gMarD = mysqli_query($conn,$jMar); while($jRow = mysqli_fetch_array($gMarD)){ $aveDataJan = $jRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataJan; echo number_format($aveDataJan,3,'.');; echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=2"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataFeb = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataFeb; echo number_format($aveDataFeb,3,'.'); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=3"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataMar = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataMar; echo number_format($aveDataMar,3,'.'); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=4"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataApr = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataApr; echo number_format($aveDataApr,3,'.'); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=5"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataMay = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataMay; echo number_format($aveDataMay,3,'.'); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=6"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataJun = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataJun; echo number_format($aveDataJun,3,'.'); echo ""; $kNR = ($pefKraNR / $divisorCount); //$divisorCount==number of period to or months applicable echo number_format($kNR,3,'.',''); echo ""; $kraWeight = intval($weight) / 100; $pefKraWPointF= $kNR * $kraWeight; $totaNGSumOfWeight = $totaNGSumOfWeight + $pefKraWPointF; echo number_format($pefKraWPointF,3,'.',''); echo ""; $jMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=7"; $gMarD = mysqli_query($conn,$jMar); while($jRow = mysqli_fetch_array($gMarD)){ $aveDataJul = $jRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataJul; echo number_format($aveDataJul,3,'.'); //echo number_format(($pefjVal / 100),3,'.',''); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=8"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataAug = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataAug; echo number_format($aveDataAug,3,'.'); //echo number_format(($peffVal / 100),3,'.',''); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=9"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataSep = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataSep; echo number_format($aveDataSep,3,'.'); //echo number_format(($pefmVal / 100),3,'.',''); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=10"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataOct = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataOct; echo number_format($aveDataOct,3,'.'); //echo number_format(($pefaVal / 100),3,'.',''); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=11"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataNov = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataNov; echo number_format($aveDataNov,3,'.'); //echo number_format(($pefmyVal / 100),3,'.',''); echo ""; $fMar = "SELECT AVG(mar_numerical_rating) AS average_value FROM `mar_emp_data` WHERE `kra_id`='$kraID' AND `emp_rec_id`='$empRecordID' AND `pcp_id`='$pcpID' AND `mar_semester_data`='$GetPCPSemester' AND `mar_month_data`=12"; $fMarD = mysqli_query($conn,$fMar); while($fRow = mysqli_fetch_array($fMarD)){ $aveDataDec = $fRow['average_value']; } $pefKraNR = $pefKraNR + $aveDataDec; echo number_format($aveDataDec,3,'.'); //echo number_format(($pefjnVal / 100),3,'.',''); echo ""; $kNR = $pefKraNR / $divisorCount; echo number_format($kNR,3,'.',''); echo ""; $kraWeight = intval($weight) / 100; $pefKraWPointF= $kNR * $kraWeight; //echo number_format($pefKraWPointF,3,'.',''); $totaNGSumOfWeight = $totaNGSumOfWeight + $pefKraWPointF; echo number_format($pefKraWPointF,3,'.',''); echo "
"; echo "NUMERICAL RATING (Sum of weighted points)"; echo ""; $wpPartOneVal = number_format($totaNGSumOfWeight,3,'.',''); echo ""; echo "
"; echo "PERCENTILE EQUIVALENT"; echo ""; $perCentile = ((($totaNGSumOfWeight / $nrMaxCount ) * $multiplierPTS) + $plusFactorPTS) * 100; $perCentileVal= number_format($perCentile,2,'.','') ."%"; echo ""; echo "
"; echo "ADJECTIVAL RATING"; echo ""; $gP = "SELECT * FROM `gps_adjectival_eq` WHERE $perCentile BETWEEN eq_percentage_from AND eq_percentage_to LIMIT 1"; $gpA = mysqli_query($conn,$gP); while($row=mysqli_fetch_array($gpA)){ $partOneAdju= TRIM($row['eq_adjectival']); } echo ""; echo "
"; echo "WEIGHTED RATING FOR PART I (PR X .70)"; echo ""; $wpPartI = $perCentile * 0.7; $partOneWP = number_format($wpPartI,2,'.','')."%"; echo ""; echo "

PART II - BEHAVIORAL / COMPETENCY AREAS (30%)

"; echo ""; echo ""; echo ""; } echo ""; echo ""; ?>
RATING SCALE:
".$q['rate_s']."".$q['rate_desc']."
0){ while($db = mysqli_fetch_array($qGet)){ $tNR = $db['part_two_nr']; $tPercent = $db['part_two_percent']; $tadj = $db['part_two_adj']; $tWP = $db['part_two_wp']; $tOverAll = $db['per_overall_wp']; $tOverAdj = $db['per_overall_adj']; if($qeRow == $qRow){ $strength = $db['part_three_strength']; $improvement = $db['part_three_improvement']; $competencyX = $db['part_three_competency']; switch($competencyX){ case '1': $competency ="NONE"; break; case '2': $competency="A Particular competencies only (specify in the comment box)"; break; case '3': $competency="Two or more competency (specify in the comment box)"; break; } $competencyNotes = $db['part_three_competency_notes']; $suitabilityX = $db['part_three_suitability']; switch($suitabilityX){ case '1': $suitability ="Very Suitable"; break; case '2': $suitability="Suitable"; break; case '3': $suitability="Not Suitable"; break; } $suitabilityNotes = $db['part_three_suitability_notes']; $potentialX = $db['part_three_potential']; switch($potentialX){ case '1': $potential ="Just right for the present position"; break; case '2': $potential="Moderate Potential"; break; case '3': $potential="High Potential / ready for promotion"; break; } $potentialNotes = $db['part_three_potential_notes']; $confirm = $db['emp_confirm_agreement']; switch($confirm){ case '1': $confirnData ="AGREE"; break; case '2': $confirnData="AGREE WITH RESERVATION"; break; case '3': $confirnData="DISAGREE"; break; } $confirmNotes = $db['emp_confirm_notes']; $nextHeadNotes = $db['next_head_notes']; } } //if($tNR==""){$tNR=0;} } $getFac = "SELECT * FROM `performance_factors` WHERE deleted = 0 ORDER BY `factors_order` ASC"; $qFac = mysqli_query($conn,$getFac); while($row=mysqli_fetch_array($qFac)){ $code = $row['code_name']; //get existing behavioral data if available $bWeight = $row['factors_wp']; $numWeight = explode("%",$bWeight); $floatWeight = $numWeight[0]; if($qeRow == $qRow){ $getDB = "SELECT AVG(`assigned_score`) AS 'assignedScore', assigned_wp,notes FROM `pef_evaluation_behavioral` WHERE `pcp_id`='$pcpID' AND `factor_code_name`='$code' ORDER BY id ASC"; $qDB = mysqli_query($conn,$getDB); $chBPRow = mysqli_num_rows($qDB); if($chBPRow > 0){ while($qD = mysqli_fetch_array($qDB)){ $inputValue = $qD['assignedScore']; //$weightedPoints = $qD['assigned_wp']; $weightedPoints = $inputValue * ($floatWeight/100); $weightedPoints = number_format($weightedPoints,3,'.',''); $Notes = $qD['notes']; $weightedPointsTotal = $weightedPointsTotal + $weightedPoints; } } }else{ $getDB = "SELECT AVG(`assigned_score`) AS 'assignedScore', assigned_wp,notes FROM `pef_evaluation_behavioral` WHERE `pcp_id`='$pcpID' AND `factor_code_name`='$code' AND `evaluator_id`='$userID' ORDER BY id ASC"; $qDB = mysqli_query($conn,$getDB); $chBPRow = mysqli_num_rows($qDB); if($chBPRow > 0){ while($qD = mysqli_fetch_array($qDB)){ $inputValue = $qD['assignedScore']; $weightedPoints = $qD['assigned_wp']; $Notes = $qD['notes']; $weightedPointsTotal = $weightedPointsTotal + $weightedPoints; } } } $weightedPointsTotal = number_format($weightedPointsTotal,3,'.',''); //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //================================================================================\ //================================================================================\ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //================================================================================\ //================================================================================\ //================================================================================\ //================================================================================\ ?>
NO PERFORMANCE FACTORS WEIGHT N.Rating AVG. W.Points REMARKS
".$row['factors_name'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "NUMERICAL RATING (Sum of weighted points)"; echo ""; //echo number_format($totaPtwoWeight,3,'.',''); echo ""; echo "
"; echo "PERCENTILE EQUIVALENT"; echo ""; $tPercentRaw = ((($weightedPointsTotal / $nrMaxCount ) * $multiplierPTS) + $plusFactorPTS) * 100; $tPercentXXX= number_format($tPercentRaw,2,'.','') ."%"; echo ""; echo "
"; echo "ADJECTIVAL RATING"; echo ""; $gPII = "SELECT * FROM `gps_adjectival_eq` WHERE $tPercentRaw BETWEEN eq_percentage_from AND eq_percentage_to "; $gpB = mysqli_query($conn,$gPII); while($row=mysqli_fetch_array($gpB)){ $tadjXXX= $row['eq_adjectival']; } echo ""; echo "
"; echo "WEIGHTED RATING FOR PART II (PR X .30)"; echo ""; $wpPartII = $tPercentRaw * 0.3; $tWPxxx = number_format($wpPartII,2,'.','')."%"; echo ""; echo "
"; echo "OVERALL PERFORMANCE RATING (Part I + Part II Weighted Points)"; echo ""; //wpPartOneTwoWP = wpPartOneWP + wpPartTwo $tOverAllRaw = $wpPartII + $wpPartI; $tOverAllxxx = number_format($tOverAllRaw,2,'.','')."%"; echo ""; echo "
"; echo "ADJECTIVAL EQUIVALENT"; echo ""; $gPIIB = "SELECT * FROM `gps_adjectival_eq` WHERE $tOverAllRaw BETWEEN eq_percentage_from AND eq_percentage_to "; $gpB = mysqli_query($conn,$gPIIB); while($row=mysqli_fetch_array($gpB)){ $tOverAdjXXX= $row['eq_adjectival']; } echo ""; echo "

PART III - COMMENTS AND RECOMMENDATIONS



A. BY THE RATER








B. BY THE RATEE
C. BY THE NEXT HIGHER HEAD
".$msg." "; } ?>

close(); } ?>