File manager - Edit - /home/autoph/public_html/pms_v1/reports/loadDataReportC.php
Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['lDat'])){ $rptYear=$_POST['rptYear']; $rptSemester=$_POST['rptSemester']; $empName=$_POST['empName']; $empPosition=$_POST['empPosition']; $unitID=$_POST['unitID']; $searchID=$_POST['searchID']; //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']; } //get opsplan entry $ops = "SELECT * FROM `ops_department_level` WHERE deleted = 0 AND coverage_year ='$rptYear' AND `record_id` = '$searchID'"; $qOps = mysqli_query($conn,$ops); while($row = mysqli_fetch_array($qOps)){ $opsHeadID = $row['id']; } $getPCPdata = "SELECT * FROM `ops_data_department` WHERE `pms_record_id`='$searchID' AND `deleted`=0 GROUP BY `ops_kra` ASC"; $qKRA = mysqli_query($conn,$getPCPdata); $ckhResult = mysqli_num_rows($qKRA); echo "<center><table class='col-lg-12 col-md-12' style='width:100%'>"; echo "<thead>"; echo "<th>KRA DESCKRIPTION</th>"; echo "<th>WEIGHT </th>"; echo "<th>TARGET</th>"; echo "<th>AVG. ACTUAL</th>"; echo "<th>AVG. SCORE</th>"; echo "<th>AVE. NR</th>"; echo "<th>AVE. WP</th>"; echo "</thead>"; while($row = mysqli_fetch_array($qKRA)){ echo "<tr>"; echo "<td>"; $kraID = $row['ops_kra']; $gtName = "SELECT kra_name FROM kra_department_tbl where ID = $kraID"; $qName = mysqli_query($conn,$gtName); while($dk=mysqli_fetch_array($qName)){ echo $dk['kra_name']; } echo"</td>"; echo "<td>".$row['ops_weight']."</td>"; echo "<td>".$row['ops_target']."</td>"; echo "<td>"; echo "</td>"; echo "</tr>"; } echo "</table></center>"; } //$conn->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings