File manager - Edit - /home/autoph/public_html/pms_v1/pcpDocuments/loadPendingPCPApproval.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 class='text-dark'>PCP ID</th> <th class='text-dark'>EMP 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='col-lg-4 text-dark'>PCP DESCRIPTION</th> <th class='text-dark'>-</th> </thead> <?php $getMyProfile = "SELECT * FROM `tempmarviews` WHERE `owner_id`='$userID' ORDER BY `last_name` ASC"; $getMyPro = mysqli_query($conn,$getMyProfile); while($row = mysqli_fetch_array($getMyPro)){ $activeRecordID =$row['emp_rec_id']; $getKRAList = "SELECT * FROM `pcp_headers` WHERE `deleted`=0 AND `employee_id` ='$activeRecordID' AND `status` != 'APPROVED' ORDER BY `year` DESC"; //$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'"; $getKRA = mysqli_query($conn,$getKRAList); $statRow = mysqli_num_rows($getKRA); while($row = mysqli_fetch_array($getKRA)){ $count = $count + 1; if($row['status']==="OPEN"){ $fontColor="#780404"; }else{ $fontColor="#106003"; } ?><tr onclick="javascript:getKRAinfoAPR(this);" ><?php echo "<td style='width:10%;color:$fontColor'>".$row['id']."</td>"; echo "<td style='width:10%;color:$fontColor'>".$activeRecordID."</td>"; echo "<td style='width:10%;color:$fontColor''>".$row['year']."</td>"; echo "<td style='width:10%;color:$fontColor''>".$row['period']."</td>"; echo "<td style='width:10%;color:$fontColor''>".$row['status']."</td>"; echo "<td style='width:27%;color:$fontColor''>"; echo getEmployeeEmpInformationB($activeRecordID)[3]. " ".getEmployeeEmpInformationB($activeRecordID)[2]; echo "</td>"; echo "<td style='width:30%;color:$fontColor''>".$row['pcp_description']."</td>"; if($row['status']==="OPEN"){ echo "<td style='width:3%'>";?> <!--<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="#kpiModal" class="fa fa-list-ol" style='cursor:pointer;color:green;float:right;font-size:14px'></i> <?php echo "</td>"; }else{ echo "<td style='width:3%'>";?> <!--<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="#kpiModal" class="fa fa-list-ol" style='cursor:pointer;color:gray;float:right;font-size:14px'></i> <?php echo "</td>"; } echo "<tr>"; } } if($count ==0){ echo "<tr style='background:white;border:1px solid white'>"; echo "<td colspan='8' class='text-dark text-center p-5' style='border:0px solid white'><h6 class='p-5 mt-5' style='border:1px solid white; background:white'>No pending PCP for approval</h6></td>"; echo "</tr>"; } $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings