File manager

File manager - Edit - /home/autoph/tmp/public_html/pms_v1/reports/loadDataReportA.php

Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['lDat'])){ $pcpID=0; $activeKRAID=0; $pTile = 0; $totalWP = 0; $adjVal = ""; $kraCount = 0; $plusFactorPTS=0; $multiplierPTS=0; $myKRAID=0; $kpiCount = 0; $ndCount=0; $stCount=0; $stNR = 0; $ndNR = 0; $rptYear=$_POST['rptYear']; $rptSemester=$_POST['rptSemester']; $empName=$_POST['empName']; $empPosition=$_POST['empPosition']; $empID=$_POST['empID']; $searchID=$_POST['searchID']; $getPCPHeaderID = "SELECT * FROM `pcp_headers` WHERE `employee_id`='$searchID' AND `year`='$rptYear' AND `deleted`=0 LIMIT 1"; $qPCP = mysqli_query($conn,$getPCPHeaderID); $ckhResult = mysqli_num_rows($qPCP); if($ckhResult > 0){ while($prow = mysqli_fetch_array($qPCP)){ $pcpID = $prow['id']; } //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']; } }else{ echo '<div class="alert alert-danger Display-5" role="alert" size-14> There is no record found for this employee. Please check if PCP/MAR and KRA\'s has been created and assigned to this employee. </div>'; exit(); } echo "<input type='hidden' id='activePCPID' value='$pcpID'>"; $getPCPdata = "SELECT * FROM `pcp_employee_data` WHERE `pcp_header_id`='$pcpID' AND `deleted`=0 GROUP BY `pcp_kra_id` ORDER BY `id` ASC"; $qKRA = mysqli_query($conn,$getPCPdata); $ckhResult = mysqli_num_rows($qKRA); echo "<center> <h5 class='content text-left color-blue' style='margin-top:50px;padding:10px;background:#FDEFD2;width:100%'>KRA Analysis</h5> <table class='col-lg-12 col-md-12' style='width:100%'>"; echo "<thead>"; echo "<th class='col text-left'>KRA DESCKRIPTION</th>"; echo "<th class='col text-center'>WEIGHT</th>"; echo "<th class='col text-center'>TARGET </th>"; echo "<th class='col text-center'>ACTUAL </th>"; echo "<th class='col text-center'>SCORE (YTD)</th>"; echo "<th class='col text-center'>N.RATING</th>"; echo "<th class='col text-center'>W.POINTS</th>"; echo "</thead>"; if($ckhResult > 0){ while($krow = mysqli_fetch_array($qKRA)){ $kraCount = $kraCount + 1; $myScore=0; $myScoreST=0; $myScoreNT=0; $count = 0; $myNR=0; $avgActual=0; $vgActual =0; $kraWeight=0; ?><tr style='width:100%'><?php echo "<td class='col text-left'>"; $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 "</td>"; echo "<td class='col text-center'>".$kraWeightText."</td>"; echo "<td class='col text-center'>".$krow['pcp_target']."</td>"; echo "<td class='col text-center'>"; 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 "<br>". $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 "</td>"; echo "<td class='col text-center'>"; echo $yNR; echo "</td>"; echo "<td class='col text-center'>"; echo $xNR; echo "</td>"; echo "<td class='col text-center'>"; echo $myKRAWP ; echo "</td>"; echo "</tr>"; } $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 "<tr><td colspan=7 style='background:white;border:0px solid white;height:50px'>"; // KPI Analysis ================================================================== echo " <h5 class='content text-left color-blue' style='margin-top:50px;padding:10px;background:#FDEFD2'>KPI Analysis</h5> <table class='col-lg-12 col-md-12' style='width:100%'>"; echo "<thead>"; echo "<th>KPI DESCKRIPTION</th>"; echo "<th class='col text-center'>WEIGHT</th>"; echo "<th class='col text-center'>TARGET </th>"; echo "<th class='col text-center'>ACTUAL </th>"; echo "<th class='col text-center'>SCORE (YTD)</th>"; echo "<th class='col text-center'>N.RATING</th>"; echo "<th class='col text-center'>W.POINTS</th>"; echo "</thead>"; $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 "<tr>"; echo "<td class='col text-left' style='padding-left:10px;font-family:Tahoma;font-size:12px;font-weight:bold'>"; echo $kpi['kra_name']; echo "</td>"; echo "<td class='col text-center' style='padding-left:10px;font-family:Tahoma;font-size:12px;font-weight:bold'>"; echo $kpi['kraWeight']; echo "</td>"; echo "<td colspan='6' class='col text-left' style='padding-left:10px;font-family:Tahoma;font-size:12px'>"; echo "</td>"; //$kpiNR = number_format((($myKPINR / $kpiCount) * ($kpiWeight / 100)),2,'.',''); echo "</tr>"; 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 "<tr>"; echo "<td class='col text-left' style='padding-left:50px;font-family:Tahoma;font-size:12px'>"; $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 "<i>".$kki['kpi_name']."</i>"; } echo "</td>"; echo "<td class='col text-center' style='padding-left:10px;font-family:Tahoma;font-size:12px'>"; echo $qrow['mar_weight']; echo "</td>"; echo "<td class='col text-center' style='padding-left:10px;font-family:Tahoma;font-size:12px'>"; echo $qrow['mar_target']; echo "</td>"; echo "<td class='col text-center' style='padding-left:10px;font-family:Tahoma;font-size:12px'>"; 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 "</td>"; echo "<td class='col text-center' style='padding-left:10px;font-family:Tahoma;font-size:12px'>"; echo $empMyScore; echo "</td>"; echo "<td class='col text-center' style='padding-left:10px;font-family:Tahoma;font-size:12px'>"; echo $marMyNR; echo "</td>"; echo "<td class='col text-center' style='padding-left:10px;font-family:Tahoma;font-size:12px'>"; $kpiWP = number_format(($marMyNR / $kpiCount) * ($kpiWeight / 100),3,'.','') ; echo $kpiWP; echo "</td>"; echo "</tr>"; } } //================================================================================ #F9F0C8 echo "</td></tr>"; echo "<tr>"; echo "<td colspan=5 style='text-align:right;background:#eeeeee;font-size:16px;font-weight:bold'>PERFORMANCE RATING (sum of weighted points)</td>"; echo "<td colspan=2 style='text-align:right;background:#eeeeee;font-size:16px;font-weight:bold'>".$totalWP."</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan=5 style='text-align:right;background:#eeeeee;font-size:16px;font-weight:bold'>PERCENTILE EQUIVALENT</td>"; echo "<td colspan=2 style='text-align:right;background:#eeeeee;font-size:16px;font-weight:bold'>"; $perCentile = ((($totalWP / 5) * $multiplierPTS) + $plusFactorPTS) * 100; // divisor 5 is fixed as per POD max NR is 5 echo number_format($perCentile,2,'.','') ."%"; echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan=5 style='text-align:right;background:#eeeeee;font-size:16px;font-weight:bold'>ADJECTIVAL EQUIVALENT</td>"; echo "<td colspan=2 style='text-align:right;background:#eeeeee;font-size:16px;font-weight:bold'>"; $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 "</td>"; echo "</tr>"; // echo "<tr><td style='height:100px;background:white'></td></tr>"; // echo "<tr>"; // echo "<td style='height:120px;color:#FA2508;background:#fff;padding:20px'> // </td>"; // echo "<td colspan=3 style='height:120px;color:#FA2508;background:#fff;padding:20px'> // <h6>Adjectival Equivalent </h6> // <h4 class='text-center p-4'> $partOneAdju</h4> // </td>"; // echo "<td colspan=2 style='height:150px;color:#FA2508;background:#fff;padding:20px'> // <h6>Weighted Points </h6> // <h4 class='text-center p-4'>".$totalWP."</h4></td>"; // echo "<td colspan=2 style='height:150px;color:#FA2508;background:#fff;padding:20px'> // <h6>Numerical Rating </h6> // <h4 class='text-center p-4'>"; // echo number_format($perCentile,3,'.','') ."%"; // echo "</h4></td>"; // echo "</tr>"; } echo "</table></center>"; } //$conn->close(); ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings