File manager - Edit - /home/autoph/public_html/pms_v1/pef/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; ?> <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'>PCP STATUS</th> <th class='col-lg-4 text-dark'>EMPLOYEE NAME</th> <th class='text-dark'>MAR</th> <th class='text-dark'>SETUP</th> <th class='text-dark'>STAT</th> <th class='text-dark'>PEF</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 `posted_by`!=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)){ $activePCPid = $row['id']; $employeeID = $row['employee_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 class='text-center'>"; $countMAR = "SELECT * FROM `mar_emp_header` WHERE `pcp_id`='$activePCPid' AND `emp_id`='$employeeID'"; $result = mysqli_query($conn,$countMAR); $marC = mysqli_num_rows($result); if($marC > 0){ while($w=mysqli_fetch_array($result)){ $mCount=$mCount + 1; } }else{ $mCount = 0; } echo $mCount." / ".$periodCount; // found in pcp_header table $mCount =0; echo "</td>"; echo "<td class='text-center'>"; ?><i data-toggle="modal" data-target="#setupPCPPeriod" class='fa fa-pencil-square-o' aria-hidden='true' style='cursor:pointer;color:gray;font-size:14px'></i><?php echo "</td>"; echo "<td class='text-center'>"; if($row['status']==="APPROVED"){ echo "<i class='fa fa-lock' aria-hidden='true' style='cursor:pointer;color:#f00;font-size:16px'></i>"; }else{ echo "<i class='fa fa-unlock' aria-hidden='true' style='cursor:pointer;color:grat;font-size:16px'></i>"; } echo "</td>"; echo "<td class='text-center' 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