File manager - Edit - /home/autoph/public_html/pms_v1/mar/loadPendingPEFApproval.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); // error_reporting(0); if(isset($_POST['code'])){ $userID = $_POST['userID']; $count=0; $mCount=0; ?> <thead> <th style='text-dark'>EMP.ID</th> <th class='text-dark'>PCP ID</th> <th class='text-dark'>YEAR</th> <th class='text-dark'>PERIOD</th> <th class='text-dark'>STATUS</th> <th class='col-lg-4 text-dark'>EMPLOYEE NAME</th> <th class='text-dark'>MAR</th> <th class='text-dark'>PEF</th> <th class='text-dark'>SET</th> <th class='text-dark'>-</th> <?php $getMyProfile = "SELECT * FROM `tempMaRViews` WHERE 1 ORDER BY `last_name` ASC"; $getMyPro = mysqli_query($conn,$getMyProfile); while($row = mysqli_fetch_array($getMyPro)){ $activeRecordID =$row['emp_rec_id']; $getPCPList = "SELECT * FROM `pcp_headers` WHERE `pef_status`!=2 AND `deleted`=0 AND `employee_id` ='$activeRecordID' AND `deleted`=0 ORDER BY `year` DESC"; //$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'"; $getPCP = mysqli_query($conn,$getPCPList); $activePCPid=0; while($row = mysqli_fetch_array($getPCP)){ $mCount =0; $activePCPid = $row['id']; $periodCount =$row['period_count']; $count = $count + 1; if($row['status']==="OPEN"){ $fontColor="#02470A"; }else{ $fontColor="#7B7F7B"; } ?><tr onclick="javascript:getMARinfoAPR(this);" ><?php echo "<td>".$activeRecordID."</td>"; echo "<td>".$row['id']."</td>"; echo "<td>".$row['year']."</td>"; echo "<td>".$row['period']."</td>"; echo "<td>".$row['status']."</td>"; echo "<td>"; echo getEmployeeEmpInformationB($activeRecordID)[3]. " ".getEmployeeEmpInformationB($activeRecordID)[2]; echo "</td>"; echo "<td>"; $countMAR = "SELECT * FROM `mar_emp_header` WHERE `pcp_id`='$activePCPid' AND `emp_id`='$activeRecordID'"; $result = mysqli_query($conn,$countMAR); while($w=mysqli_fetch_array($result)){ $mCount=$mCount + 1; } echo $mCount."/".$periodCount; // found in pcp_header table echo "</td>"; echo "<td>"; if($row['pef_rating']!=''){ echo "<i class='fa fa-check-square-o' aria-hidden='true' style='cursor:pointer;color:gray;font-size:14px'></i>"; }else{ echo "<i class='fa fa-times' aria-hidden='true' style='cursor:pointer;color:gray;font-size:14px'></i>"; } echo "</td>"; echo "<td>"; if($row['status']==="OPEN"){ echo "<i class='fa fa-unlock' aria-hidden='true' style='cursor:pointer;color:#f00;font-size:16px'></i>"; }else{ echo "<i class='fa fa-lock' aria-hidden='true' style='cursor:pointer;color:grat;font-size:16px'></i>"; } echo "</td>"; echo "<td style='width:5%;text-align:center;border:1px solid white;background:white'>"; ?> <!--<abbr title='View KRA'><i class='fa fa-plus-circle' aria-hidden='true' style='cursor:pointer;color:green;float:right;font-size:18px'></i> </abbr>--> <i data-toggle="modal" data-target="#viewPEFForm" class="fa fa-folder-open" style='cursor:pointer;color:orange;font-size:14px'></i> <?php echo "</td>"; echo "<tr>"; } } if($count ==0){ echo "<tr>"; echo "<td colspan='9' class='text-dark text-center p-5' style='background:white;border:0px solid white'><h6 class='p-5 mt-5'>No pending PEF for approval</6></td>"; echo "</tr>"; } $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings