"; echo "

Access Denied

"; echo "

Sorry, you are not authorized to access this page.
Please contact your system support for assistance.

Thank you!

"; exit(); }else{ while($uow=mysqli_fetch_array($qCU)){ $uowaccStat = $uow['account_status']; $uowdeleted = $uow['deleted']; } } if($uowaccStat == 0){ echo "
"; echo "

Access Denied

"; echo "

Sorry, you are not authorized to access this page.
Please contact your system support for assistance.

Thank you!

"; exit(); } if($uowdeleted == 1){ echo "
"; echo "

Access Denied

"; echo "

Sorry, you are not authorized to access this page.
Please contact your system support for assistance.

Thank you!

"; exit(); } //==========CHECK IF EMPLOYEE EXIST IN RECORD AND MATCH ALL INFORMATION IN THE LICNK ========= $chkPoint = "SELECT `last_name`, `first_name`,`account_status`,`deleted` FROM `pms_employee_data` WHERE `id`='$empID'"; $qChk=mysqli_query($conn,$chkPoint); $ckhRow = mysqli_num_rows($qChk); If($ckhRow > 0){ while($row=mysqli_fetch_array($qChk)){ $lastName = $row['last_name']; $firstName = $row['first_name']; $accStat = $row['account_status']; $deleted = $row['deleted']; } }else{ echo "
"; echo "

Access Denied

"; echo "

Sorry, you are not authorized to access this page.
Please contact your system support for assistance.

Thank you!

"; exit(); } if($lName != $lastName){ echo "
"; echo "

Access Denied

"; echo "

Sorry, you are not authorized to access this page.
Please contact your system support for assistance.

Thank you!

"; exit(); } if($fName != $firstName){ echo "
"; echo "

Access Denied

"; echo "

Sorry, you are not authorized to access this page.
Please contact your system support for assistance.

Thank you!

"; exit(); } //END OF CHECKPOINT=============================================================================== //END OF CHECKPOINT=============================================================================== ?>
SCORECARD -
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
KRA DESCIPRTION WEIGHT KPI DESCRIPTION TARGET ACTUAL A. RATE AVG. SCORE W.POINT
".getEmpKRAName($kraID)[0].""; $wpoint = $row['pcp_weight']; echo $wpoint; echo ""; echo ""; $getKPI = "SELECT * FROM kpi_employee WHERE kra_id ='$kraID' AND `emp_id`='$empID' AND `deleted`=0 ORDER BY `id` ASC"; $qKpi = mysqli_query($conn,$getKPI); while($kRow = mysqli_fetch_array($qKpi)){ echo ""; echo ""; echo ""; } echo "
".$kRow['kpi_name']."
"; echo "		"; echo ""; $getKPIt = "SELECT * FROM kpi_employee WHERE kra_id ='$kraID' AND `emp_id`='$empID' AND `deleted`=0 ORDER BY `id` ASC"; $qKpit = mysqli_query($conn,$getKPIt); while($tRow = mysqli_fetch_array($qKpit)){ echo ""; echo ""; echo ""; } echo "
".$tRow['kpi_target']."
"; echo "		"; echo ""; $getKPIt = "SELECT * FROM kpi_employee WHERE kra_id ='$kraID' AND `emp_id`='$empID' AND `deleted`=0 ORDER BY `id` ASC"; $qKpit = mysqli_query($conn,$getKPIt); while($aRow = mysqli_fetch_array($qKpit)){ $kpiID=$aRow['id']; if($sem == 0){ $getActual ="SELECT AVG(`mar_actual`) AS 'myActual' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kpi_id`='$kpiID' AND `mar_year_data`='$rptYear'"; }else{ $getActual ="SELECT AVG(`mar_actual`) AS 'myActual' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kpi_id`='$kpiID' AND `mar_year_data`='$rptYear' AND `mar_semester_data`='$sem'"; } $qActual = mysqli_query($conn,$getActual); while($act = mysqli_fetch_array($qActual)){ echo ""; echo ""; echo ""; } } echo "
".number_format(($act['myActual']),2,'.','')."
"; echo "		"; echo ""; $getKPIt = "SELECT * FROM kpi_employee WHERE kra_id ='$kraID' AND `emp_id`='$empID' AND `deleted`=0 ORDER BY `id` ASC"; $qKpit = mysqli_query($conn,$getKPIt); $countSpan =0; while($aRow = mysqli_fetch_array($qKpit)){ $countSpan=$countSpan + 1; $kpiID=$aRow['id']; if($sem == 0){ $getActual ="SELECT AVG(`my_score`) AS 'myScore' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kpi_id`='$kpiID' AND `mar_year_data`='$rptYear'"; }else{ $getActual ="SELECT AVG(`my_score`) AS 'myScore' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kpi_id`='$kpiID' AND `mar_year_data`='$rptYear' AND `mar_semester_data`='$sem'"; } $qActual = mysqli_query($conn,$getActual); while($act = mysqli_fetch_array($qActual)){ echo ""; echo ""; echo ""; } } echo "
".number_format(($act['myScore']),2,'.','')." %
"; echo "		"; if($sem == 0){ $getActualVG ="SELECT AVG(`my_score`) AS 'myAVGScore' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kra_id`='$kraID' AND `mar_year_data`='$rptYear' LIMIT 1"; }else{ $getActualVG ="SELECT AVG(`my_score`) AS 'myAVGScore' FROM `mar_emp_data` WHERE `emp_rec_id`='$empID' AND `deleted`=0 AND `kra_id`='$kraID' AND `mar_year_data`='$rptYear' AND `mar_semester_data`='$sem' LIMIT 1"; } $qActualVG = mysqli_query($conn,$getActualVG); while($act = mysqli_fetch_array($qActualVG)){ $wp =number_format(($act['myAVGScore']),2,'.','')."%"; echo $wp; } echo ""; $As = str_replace("%","",$wp); $Bs = str_replace("%","",$wpoint); $weightedPoints = ($As / $Bs) ; $weightedPoints = ($As/100) / ($Bs/100); $weightedPointsTotal =$weightedPointsTotal + $weightedPoints; echo number_format($weightedPoints,3,'.') ."%"; echo "
close(); ?>