";
$aKRAID = $krow['pcp_kra_id'];
$nKra = "SELECT * FROM `kra_employee_tbl` WHERE `id`='$aKRAID' LIMIT 1";
$qKra = mysqli_query($conn,$nKra);
while($row =mysqli_fetch_array($qKra)){
echo $row['kra_name'];
$activeKRAID = $row['id'];
$kraWeightText = $row['weight'];
$kraWeight = str_replace("%","",$row['weight']);
}
echo "";
echo "| ".$kraWeightText." | ";
echo "".$krow['pcp_target']." | ";
echo "";
switch ($rptSemester){
case 0: // entire selected year
$gMAR = "SELECT * FROM `mar_emp_data` WHERE `mar_year_data`='$rptYear' AND `deleted`=0 AND `kra_id`='$activeKRAID'";
break;
case 1: //1st sem
$gMAR = "SELECT * FROM `mar_emp_data` WHERE `mar_semester_data`='1' AND `mar_year_data`='$rptYear' AND `deleted`=0 AND `kra_id`='$activeKRAID'";
break;
case 2: // 2nd sem
$gMAR = "SELECT * FROM `mar_emp_data` WHERE `mar_semester_data`='2' AND `mar_year_data`='$rptYear' AND `deleted`=0 AND `kra_id`='$activeKRAID'";
break;
}
$qMAR = mysqli_query($conn,$gMAR);
$total = mysqli_num_rows($qMAR);
if($total >0){
while($row =mysqli_fetch_array($qMAR)){
//echo "
". $stNR ." -" .$stCount;
$count=$count + 1;
$myScore = $myScore + $row['mar_actual'];
$myNR = $myNR + $row['mar_numerical_rating'];
$vgActual = $vgActual + $row['mar_actual'];
//semestral rating
}
//YEARLY COMPUTATION
$avgActual = number_format(($vgActual / $count),2,'.','');
$yNR= number_format(($myScore / $count),2,'.','')."%";
$myKRAWP = number_format(($myNR / $count),2,'.','') * ($kraWeight / 100) ;
$totalWP = $totalWP + $myKRAWP;
$xNR=number_format(($myNR / $count),2,'.','')."%";
}else{
$myNR=0;
$xNR=0;
$myKRAWP =0;
$yNR=0;
}
echo $avgActual;
echo " | ";
echo "";
echo $yNR;
echo " | ";
echo "";
echo $xNR;
echo " | ";
echo "";
echo $myKRAWP ;
echo " | ";
echo "
";
}
$perCentile = ((($totalWP / $kraCount) * $multiplierPTS) + $plusFactorPTS) * 100;
$gP = "SELECT * FROM `gps_adjectival_eq` WHERE $perCentile BETWEEN eq_percentage_from AND eq_percentage_to ";
$gpA = mysqli_query($conn,$gP);
while($row=mysqli_fetch_array($gpA)){
$partOneAdju= $row['eq_adjectival'];
}
echo "";
// KPI Analysis ==================================================================
echo " KPI Analysis
";
echo "";
echo "| KPI DESCKRIPTION | ";
echo "WEIGHT | ";
echo "TARGET | ";
echo "ACTUAL | ";
echo "SCORE (YTD) | ";
echo "N.RATING | ";
echo "W.POINTS | ";
echo "";
$getPCPdata = "SELECT
pcp_employee_data.pcp_header_id,
pcp_employee_data.pcp_kra_id,
pcp_employee_data.pcp_kpi_id,
pcp_employee_data.pcp_weight,
pcp_employee_data.pcp_target,
pcp_employee_data.deleted,
kra_employee_tbl.id AS kraID,
kra_employee_tbl.emp_id,
kra_employee_tbl.kra_code,
kra_employee_tbl.weight AS kraWeight,
kra_employee_tbl.kra_name,
kra_employee_tbl.deleted,
kpi_employee.emp_id,
kpi_employee.kra_id,
kpi_employee.kpi_weight,
kpi_employee.kpi_target,
kpi_employee.kpi_name,
kpi_employee.deleted,
mar_emp_data.emp_rec_id,
mar_emp_data.kra_id AS marKRA,
mar_emp_data.kpi_id AS marKPI,
mar_emp_data.mar_weight,
mar_emp_data.mar_target,
mar_emp_data.mar_actual,
mar_emp_data.my_score,
mar_emp_data.mar_variance_no,
mar_emp_data.mar_numerical_rating,
mar_emp_data.mar_year_data,
mar_emp_data.mar_month_data,
mar_emp_data.mar_semester_data,
mar_emp_data.deleted
FROM `pcp_employee_data`
JOIN kra_employee_tbl ON kra_employee_tbl.id = pcp_employee_data.pcp_kra_id
JOIN kpi_employee ON kpi_employee.id = pcp_employee_data.pcp_kpi_id
JOIN mar_emp_data ON mar_emp_data.emp_rec_id = kra_employee_tbl.emp_id AND mar_emp_data.kpi_id = pcp_employee_data.pcp_kpi_id
WHERE pcp_employee_data.deleted='0' AND kra_employee_tbl.`deleted`=0 AND kra_employee_tbl.emp_id = '$searchID' AND kpi_employee.emp_id = '$searchID' AND mar_emp_data.`mar_year_data`='$rptYear'
GROUP BY mar_emp_data.kra_id ORDER BY mar_emp_data.kra_id ASC;";
$qKRA = mysqli_query($conn,$getPCPdata);
$ckhResult = mysqli_num_rows($qKRA);
while($kpi = mysqli_fetch_array($qKRA)){
$kpiCount = 0;
$marKraID = $kpi['kraID'];
$myKPIID =$kpi['pcp_kpi_id'];
echo "";
echo "| ";
echo $kpi['kra_name'];
echo " | ";
echo "";
echo $kpi['kraWeight'];
echo " | ";
echo "";
echo " | ";
//$kpiNR = number_format((($myKPINR / $kpiCount) * ($kpiWeight / 100)),2,'.','');
echo " ";
switch($rptSemester){
case '0':
$qMar = "SELECT * FROM `mar_emp_data` WHERE `emp_rec_id` = '$searchID' AND `mar_year_data`='$rptYear' AND `kra_id`='$marKraID' AND deleted=0 GROUP BY `kpi_id` ORDER BY `kra_id` ASC";
break;
case '1':
$qMar = "SELECT * FROM `mar_emp_data` WHERE `emp_rec_id` = '$searchID' AND `mar_year_data`='$rptYear' AND `kra_id`='$marKraID' AND deleted=0 AND `mar_semester_data`='1' GROUP BY `kpi_id` ORDER BY `kra_id` ASC";
break;
case '2':
$qMar = "SELECT * FROM `mar_emp_data` WHERE `emp_rec_id` = '$searchID' AND `mar_year_data`='$rptYear' AND `kra_id`='$marKraID' AND deleted=0 AND `mar_semester_data`='2' GROUP BY `kpi_id` ORDER BY `kra_id` ASC";
break;
}
$qqMar = mysqli_query($conn,$qMar);
while($qrow = mysqli_fetch_array($qqMar)){
$kpiCount = $kpiCount + 1;
echo "";
echo "| ";
$kpiWeight =str_replace("%","",$qrow['mar_weight']);
$kpiID= $qrow['kpi_id'];
$qKPIName = "SELECT `kpi_name` FROM `kpi_employee` WHERE `id`=$kpiID";
$qkpi = mysqli_query($conn,$qKPIName);
while($kki = mysqli_fetch_array($qkpi)){
echo "".$kki['kpi_name']."";
}
echo " | ";
echo "";
echo $qrow['mar_weight'];
echo " | ";
echo "";
echo $qrow['mar_target'];
echo " | ";
echo "";
switch($rptSemester){
case '0':
$marActual = "SELECT AVG(`mar_actual`) AS avgActual, AVG(`my_score`) AS marScore , AVG(`mar_numerical_rating`) AS marMyNR FROM `mar_emp_data` WHERE `kpi_id`=$kpiID AND `emp_rec_id`='$searchID' AND `mar_year_data`='$rptYear' LIMIT 1";
break;
case '1':
$marActual = "SELECT AVG(`mar_actual`) AS avgActual, AVG(`my_score`) AS marScore, AVG(`mar_numerical_rating`) AS marMyNR FROM `mar_emp_data` WHERE `kpi_id`=$kpiID AND `emp_rec_id`='$searchID' AND `mar_year_data`='$rptYear' AND `mar_semester_data`='1' LIMIT 1";
break;
case '2':
$marActual = "SELECT AVG(`mar_actual`) AS avgActual , AVG(`my_score`) AS marScore, AVG(`mar_numerical_rating`) AS marMyNR FROM `mar_emp_data` WHERE `kpi_id`=$kpiID AND `emp_rec_id`='$searchID' AND `mar_year_data`='$rptYear' AND `mar_semester_data`='2' LIMIT 1";
break;
}
$act = mysqli_query($conn,$marActual);
while($ac = mysqli_fetch_array($act)){
$empActual = number_format($ac['avgActual'],3,'.','');
$empMyScore = number_format($ac['marScore'],3,'.','');
$marMyNR = number_format($ac['marMyNR'],3,'.','');
}
echo $empActual;
echo " | ";
echo "";
echo $empMyScore;
echo " | ";
echo "";
echo $marMyNR;
echo " | ";
echo "";
$kpiWP = number_format(($marMyNR / $kpiCount) * ($kpiWeight / 100),3,'.','') ;
echo $kpiWP;
echo " | ";
echo " ";
}
}
//================================================================================ #F9F0C8
echo "";
echo "";
echo "| PERFORMANCE RATING (sum of weighted points) | ";
echo "".$totalWP." | ";
echo " ";
echo "";
echo "| PERCENTILE EQUIVALENT | ";
echo "";
$perCentile = ((($totalWP / 5) * $multiplierPTS) + $plusFactorPTS) * 100; // divisor 5 is fixed as per POD max NR is 5
echo number_format($perCentile,2,'.','') ."%";
echo " | ";
echo " ";
echo "";
echo "| ADJECTIVAL EQUIVALENT | ";
echo "";
$gP = "SELECT * FROM `gps_adjectival_eq` WHERE $perCentile BETWEEN eq_percentage_from AND eq_percentage_to ";
$gpA = mysqli_query($conn,$gP);
while($row=mysqli_fetch_array($gpA)){
$partOneAdju= $row['eq_adjectival'];
}
echo $partOneAdju;
echo " | ";
echo " ";
// echo " | ";
// echo "";
// echo "|
// | ";
// echo "
// Adjectival Equivalent
// $partOneAdju
// | ";
// echo "
// Weighted Points
// ".$totalWP." | ";
// echo "
// Numerical Rating
// ";
// echo number_format($perCentile,3,'.','') ."%";
// echo " | ";
// echo " ";
}
echo " ";
}
//$conn->close();
?> |