File manager

File manager - Edit - /home/autoph/public_html/pms_v1/apr/loaddivMTableApprovers.php

Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['divM'])){ $empLName = ""; $empFName = ""; $empID = ""; $empLevel = ""; $errorMSG=""; $lcomp = $_POST['divM']; switch ($lcomp){ case 1: //LOAD $selUnitID = $_POST['selUnitID']; break; case 2: //ADD $aprID = $_POST['aprID']; $activeUnit = $_POST['activeUnit']; $selUnitID = $_POST['selUnitID']; $employeeSearchID = $_POST['employeeSearchID']; $userID = $_POST['userID']; //check if exist $chkIfExist = "SELECT * FROM `approver_setup` WHERE `deleted`=0 AND `level` ='DIVM' AND `unit_id`='$selUnitID' AND `approver_id`='$employeeSearchID' ORDER BY `id` ASC"; $valExist = mysqli_query($conn,$chkIfExist); $valRow = mysqli_num_rows($valExist); if($valRow > 0){ $errorMSG="Record already exist."; }else{ //store data $sql = "INSERT INTO approver_setup ( `id`, `unit_id`, `approver_id`, `approver_type`, `level`, `date_created`, `created_by`) VALUES ( '', '$selUnitID', '$employeeSearchID', 'ALL', 'DIVM', '$myTimeStamp', '$userID')"; if ($conn->query($sql) === TRUE) { $errorMSG="Record has been saved."; } else { $errorMSG="Error saving record. SQL Error detected at line: 49 loadCompanyApprover @ swtich #2"; } } break; case 3: //DELETE aprID $userID = $_POST['userID']; $aprID = $_POST['aprID']; $selUnitID = $_POST['selUnitID']; $sql = "UPDATE approver_setup SET deleted = 1,date_modified='$myTimeStamp',modified_by='$userID',`last_action`='Deleted' WHERE `id`='$aprID' AND `unit_id`='$selUnitID'"; if ($conn->query($sql) === TRUE) { $errorMSG="Record has been updated."; } else { $errorMSG="Error saving record. SQL Error detected at line: 63 loadCompanyApprover @ swtich #3"; } break; } $getCApprover = "SELECT * FROM `approver_setup` WHERE `deleted`=0 AND `level` ='DIVM' AND `unit_id`='$selUnitID' ORDER BY `id` ASC"; $getApr = mysqli_query($conn,$getCApprover); $statRow = mysqli_num_rows($getApr); while($row = mysqli_fetch_array($getApr)){ $approverID = $row['approver_id']; $empLevel = $row['level']; $getEmpInfo = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `id` ='$approverID' ORDER BY `last_name` ASC"; $getEmp = mysqli_query($conn,$getEmpInfo); $statRow = mysqli_num_rows($getEmp); if($statRow > 0){ while($eow = mysqli_fetch_array($getEmp)){ $empLName = $eow['last_name']; $empFName = $eow['first_name']; $empID = $eow['emp_id']; } } ?><tr onclick="javascript:aprDataDeal(this);" style="width:100%"><?php echo "<td style='width:10%;border:0px solid red'>".$row['id']."</td>"; echo "<td style='width:13%;border:0px solid red'>"; echo $empID; echo "</td>"; echo "<td style='width:27%;border:0px solid red'>"; echo strtoupper($empFName); echo "</td>"; echo "<td style='width:30%;border:0px solid red'>"; echo strtoupper($empLName); echo "</td>"; echo "<td style='width:15%;border:0px solid red'>"; echo strtoupper($empLevel); echo "</td>"; echo "<td style='width:5%'> <abbr title='Delete record'><i class='fa fa-trash ' aria-hidden='true' style='cursor:pointer;color:#FF0800;font-size:16px'></i></abbr> </td>"; echo "<tr>"; } echo "<tr><td colspan=6 style='padding:30px;color:red;font-size:14px;text-align:left'>".$errorMSG."</td></tr>"; $conn->close(); } ?>

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