File manager

File manager - Edit - /home/autoph/public_html/pms_v1/pef/loadRatersData.php

Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); // error_reporting(0); if(isset($_POST['code'])){ $userID = $_POST['userID']; $pcpID = $_POST['pcpID']; $empRecordID = $_POST['empRecordID']; ?> <table id ='pefPerformanceFactors' style="width:100%"> <thead> <th class='text-left w-25 bg-light text-dark p-1 '>PERFORMANCE FACTORS</th> <th class='text-center w-25 bg-light text-dark p-1'>WEIGHT</th> <th class='text-left w-50 bg-light text-dark p-1'> <?php $rCount = "SELECT * FROM `pef_parttwo_evaluator` WHERE `emp_id`= '$empRecordID' AND `type`='PEF' AND `deleted`=0 ORDER BY `id` ASC"; $qrRater = mysqli_query($conn,$rCount); echo "<table class='w-100'>"; echo "<thead>"; while($row=mysqli_fetch_array($qrRater)){ $aprID = $row['pef_evaluator_id']; echo "<th class='col-lg-3 bg-light text-dark text-center pr-2' style='border:0px solid white'>"; echo substr(getEmployeeEmpInformationB($aprID)[3], 0, 1).".". getEmployeeEmpInformationB($aprID)[2]; echo "</th>"; } echo "</thead>"; echo "</table>"; ?> </th> </thead> <?php $rPef = "SELECT * FROM `performance_factors` WHERE `deleted`=0"; $qrPef = mysqli_query($conn,$rPef); while($row=mysqli_fetch_array($qrPef)){ $factorID = $row['id']; echo "<tr>"; echo "<td class='p-1'>"; echo $row['factors_name']; echo "</td>"; echo "<td class='text-center p-1'>"; echo $row['factors_wp']; echo "</td>"; echo "<td class='text-left p-1 w-50' style='background:transparent'>"; $rqCount = "SELECT * FROM `pef_parttwo_evaluator` WHERE `emp_id`= '$empRecordID' AND `type`='PEF' AND `deleted`=0 ORDER BY `id` ASC"; $rRater = mysqli_query($conn,$rqCount); echo "<table class='w-100'>"; echo "<tr>"; while($rowa=mysqli_fetch_array($rRater)){ $aprID = $rowa['pef_evaluator_id']; echo "<td class='col-lg-3 bg-white text-dark text-center pr-2' style='border:0px solid black;background:transparent'>"; $facCount = "SELECT * FROM `pef_evaluation_behavioral` WHERE `emp_record_id`= '$empRecordID' AND `evaluator_id`='$aprID' AND `factor_id`=' $factorID' AND `deleted`=0 "; $fRater = mysqli_query($conn,$facCount); while($rowb=mysqli_fetch_array($fRater)){ echo number_format(($rowb['assigned_score']),2,'.',''); } echo "</td>"; } echo "</tr>"; echo "</table>"; echo "</td>"; echo "</tr>"; } echo "</table>"; $conn->close(); } ?>

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