";
echo "";
echo "| KRA DESCKRIPTION | ";
echo "WEIGHT | ";
echo "TARGET | ";
echo "AVG. ACTUAL | ";
echo "AVG. SCORE | ";
echo "AVE. NR | ";
echo "AVE. WP | ";
echo "";
while($row = mysqli_fetch_array($qKRA)){
$kraCount = $kraCount + 1;
$count = 0;
$marActual=0;
$marScore=0;
$marNRAVG=0;
$marWPAVG=0;
$marNR =0;
$avgMarActual = 0;
$avgMarScore = 0;
$avgMarNR = 0;
$avgMarVariance = 0;
$unitKRAID = $row['id'];
$kraWeight = $row['weight'];
$myWeight =str_replace("%","",$kraWeight);
echo "";
echo "| ".$row['kra_name']." | ";
echo "".$row['weight']." | ";
echo " | ";
echo "";
$gUnitActual = "SELECT
mar_emp_data.id,
kra_unit_tbl.id AS unitKRAID,
kra_unit_tbl.unit_id AS unitKRAID,
kra_unit_tbl.deleted AS UnitDeleted,
kra_employee_tbl.id AS empKRAID,
kra_employee_tbl.weight AS empKRAWeight,
kra_employee_tbl.unit_kra_id AS kraUnitID,
mar_emp_data.kra_id,
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.deleted,
mar_emp_data.kpi_id,
mar_emp_data.unit_id
FROM kra_unit_tbl
JOIN kra_employee_tbl ON kra_employee_tbl.unit_kra_id = kra_unit_tbl.id
JOIN mar_emp_data ON mar_emp_data.kra_id = kra_employee_tbl.id
WHERE kra_unit_tbl.unit_id = mar_emp_data.unit_id AND kra_employee_tbl.unit_kra_id =$unitKRAID AND kra_unit_tbl.deleted=0";
$qMar = mysqli_query($conn,$gUnitActual);
$tRow = mysqli_num_rows($qMar);
if($tRow > 0){
$marKPIID=0;
while($row = mysqli_fetch_array($qMar)){
$count = $count + 1;
$marActual =$marActual + $row['mar_actual'];
$marScore =$marScore + $row['my_score'];
$marNR =$marNR + $row['mar_numerical_rating'];
$marKPIID = $row['kpi_id'];
}
$marActualAVG =number_format(($marActual / $count),3,'.','');
$marScoreAVG =number_format(($marScore / $count),3,'.','');
$marNRAVG =number_format(($marNR / $count),3,'.','');
$marWPCounter =$marNRAVG * ($myWeight/100);
$marWPATotal= $marWPATotal + $marWPCounter; //Global Accumulation
$marWPAVG=number_format($marWPCounter,3,'.','');
}else{
$marActualAVG ='0.000';
$marScoreAVG ='0.000';
$marNRAVG ='0.000';
$marWPAVG ='0.000';
}
echo $marActualAVG;
//echo $myActual;
echo " | ";
echo "".$marScoreAVG." | ";
echo "".$marNRAVG." | ";
echo "".$marWPAVG." | ";
echo "
";
echo "";
echo "| ";
$getUniKraKpi = "SELECT * FROM kpi_unit WHERE kra_id='$unitKRAID'";
$qkPosK = mysqli_query($conn,$getUniKraKpi);
while($uni=mysqli_fetch_array($qkPosK)){
echo "".$uni['kpi_name'].""; // unit KPI ID
$activeUnitKPIID = $uni['id'];
}
echo " | ";
$kpiScore = "SELECT
AVG(mar_emp_data.my_score) AS myKPIScore,
AVG(mar_emp_data.mar_actual) AS myKPImarActual,
AVG(mar_emp_data.mar_numerical_rating) AS myKPINumerical,
AVG(mar_emp_data.mar_variance_no) AS myKPIVarianceNO,
kpi_unit.id AS UnitKPIID,
kpi_unit.kpi_target AS unitTarget,
kpi_unit.kpi_name,
kpi_unit.kpi_weight,
kpi_position.id AS posID,
kpi_position.top_kpi_id AS unitPostLinkID,
kpi_position.kpi_target AS posTarget,
kpi_employee.top_kpi_id AS postEmpLinkID,
kpi_employee.id AS empKPIID,
kpi_employee.kpi_target AS empTarget,
mar_emp_data.kpi_id AS marEmpLinkID,
mar_emp_data.mar_weight,
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
FROM mar_emp_data
JOIN kpi_employee ON kpi_employee.id = mar_emp_data.kpi_id
JOIN kpi_position ON kpi_position.id = kpi_employee.top_kpi_id
JOIN kpi_unit ON kpi_unit.id = kpi_position.top_kpi_id
WHERE mar_emp_data.deleted = 0 AND mar_emp_data.mar_year_data=$rptYear AND kpi_unit.id = $activeUnitKPIID";
$qKpi = mysqli_query($conn,$kpiScore);
$kpiRow = mysqli_num_rows($qKpi);
if($kpiRow > 0){
while($kp = mysqli_fetch_array($qKpi)){
$avgMarActual = number_format($kp['myKPImarActual'],3,'.','');
$avgMarScore = number_format($kp['myKPIScore'],3,'.','');
$avgMarNR = number_format($kp['myKPINumerical'],3,'.','');
$avgMarVariance = number_format($kp['myKPIVarianceNO'],3,'.','');
$unitTaret = $kp['unitTarget'];
$unitWeight = $kp['kpi_weight'];
}
}
$unitWeightCounter = str_replace("%","",$unitWeight);
echo "".$unitWeight." | ";
echo "".$unitTaret." | ";
echo "".$avgMarActual." | ";
echo "".$avgMarScore." | ";
echo "".$avgMarNR." | ";
echo "";
$kpiWP =$avgMarNR * ($unitWeightCounter / 100);
echo "". number_format($kpiWP,3,'.','')."";
//echo $unitWeightCounter;
echo " | ";
echo "
";
}
if($kraCount==0){
$perCentile = 0;
}else{
$perCentile = ((($marWPATotal / $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 "";
// echo " ";
echo " |
|
";
echo "";
echo "| PERFORMANCE RATING (sum of weighted points) | ";
echo "".$marWPATotal." | ";
echo "
";
echo "";
echo "| PERCENTILE EQUIVALENT | ";
echo "";
if($kraCount==0){
$perCentile=0;
}else{
$perCentile = ((($marWPATotal / 5) * $multiplierPTS) + $plusFactorPTS) * 100;
}
echo number_format($perCentile,3,'.','') ."%";
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 "|
//
// Adjectival Equivalent
// $partOneAdju
//
// | ";
// echo "
// Weighted Points
// ".$marWPATotal." | ";
// echo "
// Numerical Rating
// ";
// echo number_format($perCentile,3,'.','') ."%";
// echo " | ";
// echo "
";
echo "