File manager - Edit - /home/autoph/public_html/pms_v1/pcpDocuments/pmsAdmin_pcpView.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['pcpAdmin'])){ $count = 0; $searchText = $_POST['searchText']; $selCompID = $_POST['selCompID']; echo "<table id='viewEmployeePCP' class='w-100' data-toggle='modal' data-target='#EmployeePCPForm'>"; echo "<thead>"; echo "<th class='col-1'>EMP. ID.</th>"; echo "<th class='col-1'>COMPANY</th>"; echo "<th class='col-1'>BRANCH</th>"; echo "<th class='col-6'>EMPLOYEE NAME</th>"; echo "<th class='col-3'>POSITION</th>"; echo "</thead>"; $deptID = $_POST['deptID']; $userID = $_POST['userID']; if($searchText !=""){ $empList = "SELECT * FROM `pms_employee_data` WHERE `comp_id`='$selCompID' AND `department_id`='$deptID' AND `deleted`=0 AND `first_name` LIKE '%$searchText%' || `comp_id`='$selCompID' AND `department_id`='$deptID' AND `deleted`=0 AND `last_name` LIKE '%$searchText%' ORDER BY `last_name` ASC"; }else{ $empList = "SELECT * FROM `pms_employee_data` WHERE `comp_id`='$selCompID' AND `department_id`='$deptID' AND `deleted`=0 ORDER BY `last_name` ASC"; } $empQ = mysqli_query($conn,$empList); while($row = mysqli_fetch_array($empQ)){ $count = $count + 1; $empID = $row['id']; $compID = $row['comp_id']; $branchID = $row['branch_id']; $posID = $row['position']; ?><tr onclick="javascript:getInfo(this);"><?php echo "<td style='font-family:Calibri;font-size:13px;' class='text-dark'> $empID</td>"; echo "<td style='font-family:Calibri;font-size:13px;' class='text-dark'>".getCompanyNameSub($compID)[1]."</td>"; echo "<td style='font-family:Calibri;font-size:13px;' class='text-dark'>".getDealerNameSub($branchID)[1]."</td>"; echo "<td style='font-family:Calibri;font-size:13px;' class='text-dark'>".strtoupper(getEmployeeEmpInformationB($empID)[2]).", ".strtoupper(getEmployeeEmpInformationB($empID)[3])."</td>"; echo "<td style='font-family:Calibri;font-size:13px;' class='text-dark'>".getPositionName($posID)[0]."</td>"; echo "</tr>"; } echo "</table>"; $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings