File manager - Edit - /home/autoph/public_html/tasks/apr.tar
Back
loaddivMTableApprovers.php 0000644 00000012324 15025030741 0011665 0 ustar 00 <?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(); } ?> loadEmpTableApprovers.php 0000644 00000012512 15025030741 0011506 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['empl'])){ $empLName = ""; $empFName = ""; $empID = ""; $empLevel = ""; $errorMSG=""; $lcomp = $_POST['empl']; 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` ='EMPL' 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', 'EMPL', '$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` ='EMPL' AND `unit_id`='$selUnitID' ORDER BY `id` ASC LIMIT 20"; $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:14px'></i></abbr> </td>"; echo "<tr>"; } echo "<tr><td colspan=7 style='padding:20px;color:red;font-size:14px;text-align:left;background:white;border:0px solid white'>".$errorMSG."</td></tr>"; $conn->close(); } ?> .htaccess 0000644 00000000030 15025030741 0006330 0 ustar 00 DirectoryIndex index.php searchEmpPEFApprover.php 0000644 00000003610 15025030741 0011233 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['iSearch'])){ $selUnitID = $_POST['selUnitID']; $searchEmployee = $_POST['searchEmployee']; $getEmpInfo = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `last_name` LIKE '%$searchEmployee%' || `first_name` LIKE '%$searchEmployee%' || `emp_id` LIKE '%$searchEmployee%' ORDER BY `last_name` ASC LIMIT 10"; $getEmp = mysqli_query($conn,$getEmpInfo); $statRow = mysqli_num_rows($getEmp); ?><table style="width:100%;border-collapse:collapse;"> <?php if($statRow > 0){ echo "<thead> <th style='width:20%;padding-left:2px;text-align:left;border:0px solid red'>REC.ID</thd> <th style='width:20%;padding-left:2px;text-align:left;border:0px solid red'>EMP. ID</th> <th style='width:60%;padding-left:2px;text-align:left;border:0px solid red'>EMPLOYEE NAME</th> </thead>"; while($eow = mysqli_fetch_array($getEmp)){ ?><tr onclick="javascript:getPEFApproverID(this);" style="width:100%"><?php echo "<td style='width:20%;border:0px solid red'>".$eow['id']."</td>"; echo "<td style='width:20%;border:0px solid red'>".$eow['emp_id']."</td>"; echo "<td style='width:60%;border:0px solid red'>".strtoupper($eow['last_name']).", ".strtoupper($eow['first_name'])."</td>"; echo "</tr>"; } }else{ echo "<h6 style='padding:20px;text-align:center'>No record found.</h6>"; } ?> </table> <?php $conn->close(); } ?> index.php 0000644 00000000113 15025030741 0006354 0 ustar 00 <?php header("Location: ../index.php"); /* Redirect browser */ exit(); ?> loadBranchApprovers.php 0000644 00000012351 15025030741 0011213 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['ldeal'])){ $empLName = ""; $empFName = ""; $empID = ""; $empLevel = ""; $errorMSG=""; $lcomp = $_POST['ldeal']; 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` ='DEAL' AND `unit_id`='$selUnitID' AND `approver_id`='$employeeSearchID' AND `level`='DEAL' 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', 'DEAL', '$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` ='DEAL' 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(); } ?> loadPMSOfficers.php 0000644 00000012213 15025030741 0010231 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['pms'])){ $empLName = ""; $empFName = ""; $empID = ""; $empLevel = ""; $errorMSG=""; $pms = $_POST['pms']; switch ($pms){ case 1: //LOAD $selUnitID = $_POST['selUnitID']; break; case 2: //ADD $aprID = $_POST['aprID']; $selRole = $_POST['selRole']; $selUnitID = $_POST['selUnitID']; $employeeSearchID = $_POST['employeeSearchID']; $userID = $_POST['userID']; //check if exist $chkIfExist = "SELECT * FROM `pms_officers` WHERE `deleted`=0 AND `comp_id`='$selUnitID' AND `pms_officer_id`='$employeeSearchID' AND `role_level`='$selRole' 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 pms_officers ( `id`, `comp_id`, `pms_officer_id`, `role_level`, `date_created`, `created_by`) VALUES ( '', '$selUnitID', '$employeeSearchID', '$selRole', '$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 pms_officers SET deleted = 1,date_modified='$myTimeStamp',modified_by='$userID',`last_action`='Deleted' WHERE `id`='$aprID' AND `comp_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 `pms_officers` WHERE `deleted`=0 AND `comp_id`='$selUnitID' ORDER BY `id` ASC"; $getApr = mysqli_query($conn,$getCApprover); $statRow = mysqli_num_rows($getApr); while($row = mysqli_fetch_array($getApr)){ $pmsOfficer = $row['pms_officer_id']; $empLevel = $row['role_level']; $getEmpInfo = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `id` ='$pmsOfficer' 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:aprData(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(); } ?> pmsOfficers.php 0000644 00000051334 15025030741 0007540 0 ustar 00 <?php session_start(); if(isset($_SESSION['userID'])) { // echo "Session ID is '" . $_SESSION['userID']; // echo "<br>PMS Name id " . $_SESSION['userID']; $uID = $_SESSION['userID']; } include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['apr'])){ //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($uID); $moduleID = 21; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo "<input type='hidden' id='addAccess' value='$add'>"; echo "<input type='hidden' id='editAccess' value='$edit'>"; echo "<input type='hidden' id='deleteAccess' value='$delete'>"; echo "<input type='hidden' id='printAccess' value='$print'>"; echo "<input type='hidden' id='downloadAccess' value='$download'>"; if($add == 1){$addButton = '';}else{$addButton='Disabled';} if($edit == 1){$editButton = '';}else{$editButton='Disabled';} if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';} if($print == 1){$printButton = '';}else{$printButton='Disabled';} if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';} if(checkViewAccessM1024($roleID, $moduleID)[0] == 0){ echo " <center><img src='./images/locked_out_icon.png' width='100' style='margin-top:100px'><img></center> "; echo "<h4 class='text-center text-danger align-middle pt-5'> Access Denied </h4>"; echo "<p class='display-5 text-center text-danger'> Sorry, you are not authorized to access this page. <br>Please contact your system support for assistance. <br><br>Thank you! <br><br> </p>"; exit(); } //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== ?> <style> .menuItem{ background:none; color:black; font-size:12px; text-decoration:none; } .menuItem:hover{ background:none; color:blue; font-size:12px; text-decoration:underline; } ul, #myUL { list-style-type: none; } #myUL { margin: 0; padding: 0; } .caret { cursor: pointer; -webkit-user-select: none; /* Safari 3.1+ */ -moz-user-select: none; /* Firefox 2+ */ -ms-user-select: none; /* IE 10+ */ user-select: none; font-size:14px; font-weight:normal; } .caret:hover{ cursor: pointer; -webkit-user-select: none; /* Safari 3.1+ */ -moz-user-select: none; /* Firefox 2+ */ -ms-user-select: none; /* IE 10+ */ user-select: none; color:blue; font-size:14px; text-decoration:none; font-weight:normal; } .caret::before { content: "+"; /*"\271A";*/ color: black; display: inline-block; margin-right: 6px; font-weight:bold; font-size:22px } .caret-down::before { content: "- "; font-weight:bold; font-size:22px /*-ms-transform: rotate(90deg); IE 9 */ /*-webkit-transform: rotate(90deg); /* Safari /*transform: rotate(90deg); */ } .nested { display: none; cursor: pointer; } .active { display: block; } </style> <div class="shadow-sm mb-3 pageHeaderContainer content-justify-right pt-2 pb-2" style="padding:0px;" > <div class="pageSearchHeader bg-white p-1 pt-1" > <h4 class="ml-3 mt-1"><i class="fa fa-file-text-o" style='color:#0471AC'> PMS Officers </i></h4> </div> <div class="pageSearchHeader bg-white p-1 pt-1 "> <input class="form-control border p-3" type="search" placeholder="search" id="searchText" style="margin:0px;min-width:250px;width:75%;float:left"> <button type="button" class="btn btn-info" id="goSearchRecord" style="float:rigth;width:20%;margin-left:3px">Search</button> </div> </div> <div class="wrapper mt-3 p-0 shadow-sm float:left bg-white h-auto"> <div class="row fluid m-0 w-100 p-0 bg-white h-auto pageBodyMenu"> <div class="bg-red float:left text-left col-xs-12 col-md-4 col-lg-4 col-sm-12 p-2 h-auto" style='background:#fff;min-height:800px;border-right:1px solid lightgray'> <!--########################################################################################--> <!--########################################################################################--> <h4 class="btn btn-info w-100 text-left" >NAVIGATION:</h4> <div style="height:800px;overflow:auto;background:#fff"> <ul style='background:#fff;padding:10px;border:0px solid lightgray;'> <li><span class="caret" style='font-weight:bold'>SELECT COMPANY</span> <ul> <!--<ul class="nested"> --> <?php //LOAD LIST OF COMPANY IN TABULAR FORMAT $getComp = "SELECT * FROM `vts_company` WHERE `comp_status`=1 ORDER BY `comp_name` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); if($statRow > 0){ echo "<table id='compTable'>"; while($row = mysqli_fetch_array($getC)){ ?><tr onclick="javascript:compMenuID(this);" ><?php echo "<td class='menuItem'>".$row['comp_id']."</td>"; echo "<td class='menuItem'>".$row['comp_name']."</td>"; echo "</tr>"; } echo "</table>"; } ?> </ul> </li> <!-------------------------------------------------------------------------------------------> </ul> </div> </div> <!--########################################################################################--> <!--########################################################################################--> <div id="activeReportFrom" class="bg-red float:left text-left col-xs-12 col-xs-12 col-md-8 col-lg-8 col-xl-8 col-sm-12 p-2 h-600"> <!--########################################################################################--> <!--########################################################################################--> <input type='hidden' id='aprID' placeholder="approver ID"> <input type='hidden' id='activeUnit' placeholder="activeUnit"> <input type='hidden' id='selUnitID' placeholder="selUnitID"> <input type='hidden' id='employeeSearchID' placeholder="employeeSearchID"> <input type='hidden' id='userID' value="<?php echo $uID;?>" placeholder="user ID"> <h4 id='activeTitle' class="btn btn-info w-100 text-left" >Active Unit:</h4> <table style="width:100%;border-collapse:collapse;"> <thead> <th style="width:10%;padding-left:2px;text-align:left;border:0px solid red">REC.ID</thd> <th style="width:13%;padding-left:2px;text-align:left;border:0px solid red">EMP. ID</th> <th style="width:27%;padding-left:2px;text-align:left;border:0px solid red">FIRSTNAME</th> <th style="width:30%;padding-left:2px;text-align:left;border:0px solid red">LASTNAME</th> <th style="width:15%;padding-left:2px;text-align:left;border:0px solid red">TYPE</th> <th style="width:5%;border:0px solid red;color:red;font-family:Calibri;font-size:18px;font-weight:normal"> <i data-toggle='modal' data-target='#addApproverForm' class='fa fa-plus' aria-hidden='true'></i> </th> </thead> <tr> <td colspan="6" style='padding:0px'> <div id='tdDataXX' style="maring:0px;overflow:auto"> <table id='tdDataTable' style='width:100%;border-collapse:collapse;'> </table> </div> </td> </tr> </table> <!--########################################################################################--> <!--########################################################################################--> </div> </div> </div> <!--MODAL FORM FOR ADD NEW GROUP--> <!-- The Modal --> <div class="modal fade " id="addApproverForm"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 class="modal-title" id='activeUnitName'>NEW APPROVER</h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <input type="hidden" class="form-control" id="compName" disabled > <div class="form-group"> <label for="usr">SEARCH BY NAME / EMP. ID:</label> <input class="form-control border p-4" type="search" placeholder="SEARCH BY NAME / EMP. ID" id="searchEmployee" OnkeyPress="searchMyEmployee()" style='background:yellow;border:1px solid gray' autofocus> </div> <div class="form-group"> <label for="selRole">MAIN KPIX:</label> <select name='selRole' id='selRole' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option value='' selected>- Select Role -</option> <option value='COOR'>PMS Coordinator</option> <option value='SPEC'>PMS Specialist</option> <option value='ADMN'>PMS Administrator</option> </select> </div> <div class="form-group" style="border:1px solid gray;boackground:lightgary;height:180px;overflow:auto"> <div id='searchData' style="width:100%;maring:0px;overflow:auto"> </div> </div> <p id='addThisName' style='padding:3px; color:red;margin:2px'></p> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4" data-dismiss="modal" id="addNewApproverID"> <span class="btn-label"><i class="fa fa-save"> Add</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close"> Close</i></button> </div> </div> </div> </div> <?php } ?> <script> var toggler = document.getElementsByClassName("caret"); var i; for (i = 0; i < toggler.length; i++) { toggler[i].addEventListener("click", function() { this.parentElement.querySelector(".nested").classList.toggle("active"); this.classList.toggle("caret-down"); }); } function compMenuID(row) { var x=row.cells; document.getElementById("selUnitID").value = x[0].innerHTML; document.getElementById("compName").value = x[1].innerHTML; document.getElementById("activeUnit").value = "COMPANY"; document.getElementById("activeTitle").innerHTML = x[1].innerHTML; document.getElementById("activeUnitName").innerHTML = x[1].innerHTML + " - Approver"; } function aprData(row) { var x=row.cells; document.getElementById("aprID").value = x[0].innerHTML; } function aprDataDeal(row) { var x=row.cells; document.getElementById("aprID").value = x[0].innerHTML; } function getSearchEmpID(row) { var x=row.cells; document.getElementById("employeeSearchID").value = x[0].innerHTML; document.getElementById("addThisName").innerHTML = "Selected: " + x[2].innerHTML; } $('#compTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var selUnitID = $("#selUnitID").val(); ShowUploadBar(); $.ajax({ url: "./apr/loadPMSOfficers.php", method: 'POST', dataType: 'text', async:true, data: { "pms": "1", "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); }); $('#tdDataTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); if(dCell ==5){ var userID = $("#userID").val(); var selUnitID = $("#selUnitID").val(); var aprID = $("#aprID").val(); var activeUnit = $("#activeUnit").val(); var deleteAccess = $("#deleteAccess").val(); //alert(deleteAccess); if(deleteAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to delete record from this page...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } Swal.fire({ title: 'Deleting Record', text: "Are you sure you want to delete this record? You won't be able to revert this!", icon: 'warning', showCancelButton: true, confirmButtonColor: '#3085d6', cancelButtonColor: '#d33', confirmButtonText: 'Yes, delete it!' }).then((result) => { if (result.isConfirmed) { ShowUploadBar(); if(activeUnit === "COMPANY"){ $.ajax({ url: "./apr/loadPMSOfficers.php", method: 'POST', dataType: 'text', async:true, data: { "pms": "3", "aprID":aprID, "userID":userID, "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); } } }) } }); function searchMyEmployee(){ var searchEmployee = $("#searchEmployee").val(); var selUnitID = $("#selUnitID").val(); var compName = $("#compName").val(); var len = searchEmployee.length; if(len > 0){ if(compName===""){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'No active company has been selected.' //footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } $.ajax({ url: "./apr/searchEmpByCompany.php", method: 'POST', dataType: 'text', async:true, data: { iSearch: 104, "searchEmployee": searchEmployee, "selUnitID": selUnitID }, success: function(d){ $("#searchData").html(d); } }); } //$('#marScore').val(myTotalScore.toFixed(2)); //$('#myVarianceNo').val(myVariance.toFixed(2)); } function searchDept(){ var sDept = $("#sDept").val(); var sec = sDept.length; //if(sec > 0){ $.ajax({ url: "./apr/searchDepartment.php", method: 'POST', dataType: 'text', async:true, data: { iSearch: 104, "sDept": sDept }, success: function(d){ $("#deptTable").html(d); } }); // } //$('#marScore').val(myTotalScore.toFixed(2)); //$('#myVarianceNo').val(myVariance.toFixed(2)); } $("#addNewApproverID").click(function(){ var aprID = $("#aprID").val(); var selRole = $("#selRole").val(); var selUnitID = $("#selUnitID").val(); var employeeSearchID = $("#employeeSearchID").val(); var userID = $("#userID").val(); if(employeeSearchID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select employee to continue...' //footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(selRole===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select access role to continue...' //footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); $.ajax({ url: "./apr/loadPMSOfficers.php", type: "POST", async: true, data: { "aprID":aprID, "selRole":selRole, "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "pms":"2"//save company approver }, success: function(dx){ $("#tdDataTable").html(dx); $("#searchEmployee").val(""); ShowUploadBar(); } }) }); </script> loadUnitTableApprovers.php 0000644 00000012324 15025030741 0011705 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['sect'])){ $empLName = ""; $empFName = ""; $empID = ""; $empLevel = ""; $errorMSG=""; $lcomp = $_POST['sect']; 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` ='SECT' 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', 'SECT', '$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` ='SECT' 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(); } ?> loadSubGroupApprovers.php 0000644 00000012326 15025030741 0011566 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['sbGrp'])){ $empLName = ""; $empFName = ""; $empID = ""; $empLevel = ""; $errorMSG=""; $lcomp = $_POST['sbGrp']; 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` ='SUBG' 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', 'SUBG', '$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` ='SUBG' 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(); } ?> searchDepartment.php 0000644 00000001355 15025030741 0010547 0 ustar 00 <?php include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['iSearch'])){ $searchString= $_POST['sDept']; $getUnit = "SELECT * FROM `pms_department_tbl` WHERE `deleted`=0 AND `dept_name` LIKE '%$searchString%' ORDER BY `dept_name` ASC LIMIT 20"; $getU = mysqli_query($conn,$getUnit); $statRow = mysqli_num_rows($getU); while($row = mysqli_fetch_array($getU)){ ?><tr onclick="javascript:deptMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['dept_name']."</td>"; echo "</tr>"; } $conn->close(); } ?> ApproverSetup.php 0000644 00000165615 15025030741 0010107 0 ustar 00 <?php session_start(); if(isset($_SESSION['userID'])) { // echo "Session ID is '" . $_SESSION['userID']; // echo "<br>PMS Name id " . $_SESSION['userID']; $uID = $_SESSION['userID']; } include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['apr'])){ //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($uID); $moduleID = 20; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo "<input type='hidden' id='addAccess' value='$add'>"; echo "<input type='hidden' id='editAccess' value='$edit'>"; echo "<input type='hidden' id='deleteAccess' value='$delete'>"; echo "<input type='hidden' id='printAccess' value='$print'>"; echo "<input type='hidden' id='downloadAccess' value='$download'>"; echo "<input type='hidden' id='approverEmpNumber' value='$download'>"; if($add == 1){$addButton = '';}else{$addButton='Disabled';} if($edit == 1){$editButton = '';}else{$editButton='Disabled';} if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';} if($print == 1){$printButton = '';}else{$printButton='Disabled';} if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';} if(checkViewAccessM1024($roleID, $moduleID)[0] == 0){ echo " <center><img src='./images/locked_out_icon.png' width='100' style='margin-top:100px'><img></center> "; echo "<h4 class='text-center text-danger align-middle pt-5'> Access Denied </h4>"; echo "<p class='display-5 text-center text-danger'> Sorry, you are not authorized to access this page. <br>Please contact your system support for assistance. <br><br>Thank you! <br><br> </p>"; exit(); } //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== ?> <style> .menuItem{ background:none; color:black; font-size:12px; text-decoration:none; } .menuItem:hover{ background:none; color:blue; font-size:12px; text-decoration:underline; } ul, #myUL { list-style-type: none; } #myUL { margin: 0; padding: 0; } .caret { cursor: pointer; -webkit-user-select: none; /* Safari 3.1+ */ -moz-user-select: none; /* Firefox 2+ */ -ms-user-select: none; /* IE 10+ */ user-select: none; font-size:14px; font-weight:normal; } .caret:hover{ cursor: pointer; -webkit-user-select: none; /* Safari 3.1+ */ -moz-user-select: none; /* Firefox 2+ */ -ms-user-select: none; /* IE 10+ */ user-select: none; color:blue; font-size:14px; text-decoration:none; font-weight:normal; } .caret::before { content: "+"; /*"\271A";*/ color: black; display: inline-block; margin-right: 6px; font-weight:bold; font-size:22px } .caret-down::before { content: "- "; font-weight:bold; font-size:22px /*-ms-transform: rotate(90deg); IE 9 */ /*-webkit-transform: rotate(90deg); /* Safari /*transform: rotate(90deg); */ } .nested { display: none; cursor: pointer; } .active { display: block; } </style> <div class="shadow-sm mb-3 pageHeaderContainer content-justify-right pt-2 pb-2" style="padding:0px;" > <div class="pageSearchHeader bg-white p-1 pt-1" > <h4 class="ml-3 mt-1"><i class="fa fa-file-text-o" style='color:#0471AC'> Setup Approver </i></h4> </div> <div class="pageSearchHeader bg-white p-1 pt-1 "> <input class="form-control border p-3" type="search" placeholder="search" id="searchText" style="margin:0px;min-width:250px;width:75%;float:left"> <button type="button" class="btn btn-info" id="goSearchRecord" style="float:rigth;width:20%;margin-left:3px">Search</button> </div> </div> <div class="wrapper mt-3 p-0 shadow-sm float:left bg-white h-auto"> <div class="row fluid m-0 w-100 p-0 bg-white h-auto pageBodyMenu"> <div class="bg-red float:left text-left col-xs-12 col-md-4 col-lg-4 col-sm-12 p-2 h-auto" style='background:#fff;min-height:800px;border-right:1px solid lightgray'> <!--########################################################################################--> <!--########################################################################################--> <h4 class="btn btn-info w-100 text-left" >Select Unit:</h4> <div style="height:800px;overflow:auto;background:#fff"> <ul style='background:#fff;padding:10px;border:0px solid lightgray;'> <li><span class="caret">COMPANY LEVEL</span> <ul class="nested"> <?php //LOAD LIST OF COMPANY IN TABULAR FORMAT $getComp = "SELECT * FROM `vts_company` WHERE `comp_status`=1 ORDER BY `comp_name` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); if($statRow > 0){ echo "<table id='compTable'>"; while($row = mysqli_fetch_array($getC)){ ?><tr onclick="javascript:compMenuID(this);" ><?php echo "<td class='menuItem'>".$row['comp_id']."</td>"; echo "<td class='menuItem'>".$row['comp_name']."</td>"; echo "</tr>"; } echo "</table>"; } ?> </ul> </li> <!-------------------------------------------------------------------------------------------> <li><span class="caret">BRANCH LEVEL</span> <ul class="nested"> <?php //LOAD LIST OF COMPANY IN TABULAR FORMAT $getComp = "SELECT * FROM `vts_dealerships` WHERE `deal_status`=1 ORDER BY `deal_name` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); if($statRow > 0){ echo "<table id='dealTable'>"; while($row = mysqli_fetch_array($getC)){ ?><tr onclick="javascript:dealMenuID(this);" ><?php echo "<td class='menuItem'>".$row['deal_id']."</td>"; echo "<td class='menuItem'>".$row['deal_name']."</td>"; echo "</tr>"; } echo "</table>"; } ?> </ul> </li> <!-------------------------------------------------------------------------------------------> <li><span class="caret">GROUP LEVEL</span> <ul class="nested"> <?php //LOAD LIST OF COMPANY IN TABULAR FORMAT $getComp = "SELECT * FROM `pms_sub_group` WHERE `deleted`=0 ORDER BY `sub_group_name` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); if($statRow > 0){ echo "<table id='subGTable'>"; while($row = mysqli_fetch_array($getC)){ ?><tr onclick="javascript:subGroupMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['sub_group_name']."</td>"; echo "</tr>"; } echo "</table>"; } ?> </ul> </li> <!-------------------------------------------------------------------------------------------> <li><span class="caret">DIVISION LEVEL</span> <ul class="nested"> <?php //LOAD LIST OF COMPANY IN TABULAR FORMAT $getComp = "SELECT * FROM `pms_division_tbl` WHERE `deleted`=0 ORDER BY `division_name` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); if($statRow > 0){ echo "<table id='divMTable'>"; while($row = mysqli_fetch_array($getC)){ ?><tr onclick="javascript:divisionMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['division_name']."</td>"; echo "</tr>"; } echo "</table>"; } ?> </ul> </li> <!-------------------------------------------------------------------------------------------> <li><span class="caret">DEPARTMENT LEVEL</span> <ul class="nested"> <input class="form-control " style='padding-left:10px;text-align:left;color:blue;width:60%;border:1px solid white;border-bottom:1px solid lightgray' type="search" placeholder="Search ..." id="sDept" OnkeyUp="searchDept()"> <?php //LOAD LIST OF COMPANY IN TABULAR FORMAT $getComp = "SELECT * FROM `pms_department_tbl` WHERE `deleted`=0 ORDER BY `dept_name` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); if($statRow > 0){ echo "<table id='deptTable'>"; while($row = mysqli_fetch_array($getC)){ ?><tr onclick="javascript:deptMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['dept_name']."</td>"; echo "</tr>"; } echo "</table>"; } ?> </ul> </li> <!-------------------------------------------------------------------------------------------> <li><span class="caret">SECTION LEVEL</span> <ul class="nested"> <input class="form-control " style='padding-left:10px;text-align:left;color:blue;width:60%;border:1px solid white;border-bottom:1px solid lightgray' type="search" placeholder="Search ..." id="sSect" OnkeyUp="searchSection()"> <?php //LOAD LIST OF COMPANY IN TABULAR FORMAT $getComp = "SELECT * FROM `pms_unit_tbl` WHERE `deleted`=0 ORDER BY `unit_name` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); if($statRow > 0){ echo "<table id='unitTable'>"; while($row = mysqli_fetch_array($getC)){ ?><tr onclick="javascript:sectionMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['unit_name']."</td>"; echo "</tr>"; } echo "</table>"; } ?> </ul> </li> <!-------------------------------------------------------------------------------------------> <li><span class="caret">EMPLOYEE LEVEL</span> <ul class="nested"> <input class="form-control " style='padding-left:10px;text-align:left;color:blue;width:60%;border:1px solid white;border-bottom:1px solid lightgray' type="search" placeholder="Search ..." id="sEmpl" OnkeyUp="searchEMPL()"> <?php //LOAD LIST OF COMPANY IN TABULAR FORMAT $getComp = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 ORDER BY `last_name` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); if($statRow > 0){ echo "<table id='empTable'>"; while($row = mysqli_fetch_array($getC)){ ?><tr onclick="javascript:employeeMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['last_name'].", ".$row['first_name']." - ".$row['emp_id']."</td>"; echo "</tr>"; } echo "</table>"; } ?> </ul> </li> <!-------------------------------------------------------------------------------------------> </ul> </div> </div> <!--########################################################################################--> <!--########################################################################################--> <div id="activeReportFrom" class="bg-red float:left text-left col-xs-12 col-xs-12 col-md-8 col-lg-8 col-xl-8 col-sm-12 p-2 h-600"> <!--########################################################################################--> <!--########################################################################################--> <input type='hidden' id='aprID' placeholder="approver ID"> <input type='hidden' id='activeUnit' placeholder="activeUnit"> <input type='hidden' id='selUnitID' placeholder="selUnitID"> <input type='hidden' id='employeeSearchID' placeholder="employeeSearchID"> <input type='hidden' id='userID' value="<?php echo $uID;?>" placeholder="user ID"> <h4 id='activeTitle' class="btn btn-info w-100 text-left" >Active Unit:</h4> <table style="width:100%;border-collapse:collapse;"> <thead> <th style="width:10%;padding-left:2px;text-align:left;border:0px solid red">REC.ID</thd> <th style="width:13%;padding-left:2px;text-align:left;border:0px solid red">EMP. ID</th> <th style="width:27%;padding-left:2px;text-align:left;border:0px solid red">FIRSTNAME</th> <th style="width:30%;padding-left:2px;text-align:left;border:0px solid red">LAST NAME</th> <th style="width:15%;padding-left:2px;text-align:left;border:0px solid red">LEVEL</th> <th colspan=2 style="width:5%;border:0px solid red;color:red;font-family:Calibri;font-size:18px;font-weight:normal"> <i data-toggle='modal' data-target='#addApproverForm' class='fa fa-plus text-center' aria-hidden='true'></i> </th> </thead> <tr> <td colspan="6" style='padding:0px;border:0px solid white;background:white'> <div id='tdDataXX' style="maring:0px;overflow:auto;min-height:200px"> <table id='tdDataTable' style='width:100%;border-collapse:collapse;'> </table> </div> </table> <div id='pefPartIIApproverForm' style="display:none;maring:0px;overflow:auto;min-height:200px"> <h4 class="btn btn-secondary w-100 text-left" >PEF Part II Evaluator</h4> <table style="width:100%;border-collapse:collapse;"> <thead> <th style="width:10%;padding-left:2px;text-align:left;border:0px solid red">REC.ID</thd> <th style="width:15%;padding-left:2px;text-align:left;border:0px solid red">EMP. ID</th> <th style="width:70%;padding-left:2px;text-align:left;border:0px solid red">LASTNAME</th> <th colspan=2 style="width:5%;border:0px solid red;color:red;font-family:Calibri;font-size:18px;font-weight:normal"> <i data-toggle='modal' data-target='#addPEFEvaluatorForm' class='fa fa-plus text-center' aria-hidden='true'></i> </th> </thead> <tr> <td colspan=4 class='bg-white'> <table id='tdPEFApprover' style='width:100%;border-collapse:collapse;'> </table> </td> </tr> </table> </div> <!--########################################################################################--> <!--########################################################################################--> </div> </div> </div> <!--MODAL FORM FOR ADD NEW GROUP--> <!-- The Modal --> <div class="modal fade " id="addApproverForm"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 class="modal-title" id='activeUnitName'>NEW APPROVER</h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <input type="hidden" class="form-control" id="compName" disabled > <div class="form-group"> <label for="usr">SEARCH BY NAME / EMP. ID:</label> <input class="form-control border p-4" type="search" placeholder="SEARCH BY NAME / EMP. ID" id="searchEmployee" OnkeyUp="searchMyEmployee()" style='background:yellow;border:1px solid gray' autofocus> </div> <div class="form-group" style="border:1px solid gray;boackground:lightgary;height:180px;overflow:auto"> <div id='searchData' style="width:100%;maring:0px;overflow:auto"> </div> </div> <p id='addThisName' style='padding:3px; color:red;margin:2px'></p> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton; ?> type="button" class="btn btn-success pl-4 pr-4" data-dismiss="modal" id="addNewApproverID"> <span class="btn-label"><i class="fa fa-save"> Add</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close"> Close</i></button> </div> </div> </div> </div> <!--PART 11 EVALUATOR SETUP--> <!-- The Modal --> <div class="modal fade " id="addPEFEvaluatorForm"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 class="modal-title" id='activeUnitName'>NEW PEF PART II EVALUATOR</h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <input type="hidden" class="form-control" id="compName" disabled > <div class="form-group"> <label for="usr">Search PEF Officers:</label> <input class="form-control border p-4" type="search" placeholder="SEARCH BY NAME / EMP. ID" id="pefEvaluatorID" OnkeyUp="searchMyEvaluator()" style='background:yellow;border:1px solid gray' autofocus> </div> <div class="form-group" style="border:1px solid gray;boackground:lightgary;height:180px;overflow:auto"> <div id='searchEvaluatorData' style="width:100%;maring:0px;overflow:auto"> </div> </div> <p id='addPEFApproverName' style='padding:3px; color:red;margin:2px'></p> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton; ?> type="button" class="btn btn-success pl-4 pr-4" data-dismiss="modal" id="addNewPEFAvaluator"> <span class="btn-label"><i class="fa fa-save"> Add</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close"> Close</i></button> </div> </div> </div> </div> <?php } ?> <script> var toggler = document.getElementsByClassName("caret"); var i; for (i = 0; i < toggler.length; i++) { toggler[i].addEventListener("click", function() { this.parentElement.querySelector(".nested").classList.toggle("active"); this.classList.toggle("caret-down"); }); } function compMenuID(row) { var x=row.cells; document.getElementById("selUnitID").value = x[0].innerHTML; document.getElementById("compName").value = x[1].innerHTML; document.getElementById("activeUnit").value = "COMPANY"; document.getElementById("activeTitle").innerHTML = x[1].innerHTML; document.getElementById("activeUnitName").innerHTML = x[1].innerHTML + " - Approver"; } function dealMenuID(row) { var x=row.cells; document.getElementById("selUnitID").value = x[0].innerHTML; document.getElementById("compName").value = x[1].innerHTML; document.getElementById("activeUnit").value = "DEAL"; document.getElementById("activeTitle").innerHTML = x[1].innerHTML; document.getElementById("activeUnitName").innerHTML = x[1].innerHTML + " - Approver"; } function subGroupMenuID(row) { var x=row.cells; document.getElementById("selUnitID").value = x[0].innerHTML; document.getElementById("compName").value = x[1].innerHTML; document.getElementById("activeUnit").value = "SUBG"; document.getElementById("activeTitle").innerHTML = x[1].innerHTML; document.getElementById("activeUnitName").innerHTML = x[1].innerHTML + " - Approver"; } function divisionMenuID(row) { var x=row.cells; document.getElementById("selUnitID").value = x[0].innerHTML; document.getElementById("compName").value = x[1].innerHTML; document.getElementById("activeUnit").value = "DIVM"; document.getElementById("activeTitle").innerHTML = x[1].innerHTML; document.getElementById("activeUnitName").innerHTML = x[1].innerHTML + " - Approver"; } function deptMenuID(row) { var x=row.cells; document.getElementById("selUnitID").value = x[0].innerHTML; document.getElementById("compName").value = x[1].innerHTML; document.getElementById("activeUnit").value = "DEPT"; document.getElementById("activeTitle").innerHTML = x[1].innerHTML; document.getElementById("activeUnitName").innerHTML = x[1].innerHTML + " - Approver"; } function sectionMenuID(row) { var x=row.cells; document.getElementById("selUnitID").value = x[0].innerHTML; document.getElementById("compName").value = x[1].innerHTML; document.getElementById("activeUnit").value = "SECT"; document.getElementById("activeTitle").innerHTML = x[1].innerHTML; document.getElementById("activeUnitName").innerHTML = x[1].innerHTML + " - Approver"; } function employeeMenuID(row) { var x=row.cells; document.getElementById("selUnitID").value = x[0].innerHTML; document.getElementById("compName").value = x[1].innerHTML; document.getElementById("activeUnit").value = "EMPL"; document.getElementById("activeTitle").innerHTML = x[1].innerHTML; document.getElementById("activeUnitName").innerHTML = x[1].innerHTML + " - Approver"; } function aprData(row) { var x=row.cells; document.getElementById("aprID").value = x[0].innerHTML; } function aprDataDeal(row) { var x=row.cells; document.getElementById("aprID").value = x[0].innerHTML; document.getElementById("approverEmpNumber").value = x[1].innerHTML; } function getSearchEmpID(row) { var x=row.cells; document.getElementById("employeeSearchID").value = x[0].innerHTML; document.getElementById("addThisName").innerHTML = "Selected: " + x[2].innerHTML; } function getPEFApproverID(row) { var x=row.cells; document.getElementById("employeeSearchID").value = x[0].innerHTML; document.getElementById("addPEFApproverName").innerHTML = "Selected: " + x[2].innerHTML; } $('#compTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var selUnitID = $("#selUnitID").val(); ShowUploadBar(); $.ajax({ url: "./apr/loadCompanyApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "lcomp": "1", "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); document.getElementById("pefPartIIApproverForm").style.display = "none"; } }); loadPEFApprover(); }); $('#dealTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var selUnitID = $("#selUnitID").val(); ShowUploadBar(); $.ajax({ url: "./apr/loadBranchApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "ldeal": "1", "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); document.getElementById("pefPartIIApproverForm").style.display = "none"; } }); loadPEFApprover(); }); $('#subGTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var selUnitID = $("#selUnitID").val(); ShowUploadBar(); $.ajax({ url: "./apr/loadSubGroupApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "sbGrp": "1", "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); document.getElementById("pefPartIIApproverForm").style.display = "none"; } }); loadPEFApprover(); }); $('#divMTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var selUnitID = $("#selUnitID").val(); ShowUploadBar(); $.ajax({ url: "./apr/loaddivMTableApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "divM": "1", "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); document.getElementById("pefPartIIApproverForm").style.display = "none"; } }); loadPEFApprover(); }); $('#deptTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var selUnitID = $("#selUnitID").val(); ShowUploadBar(); $.ajax({ url: "./apr/loadDeptTableApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "dept": "1", "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); document.getElementById("pefPartIIApproverForm").style.display = "none"; } }); loadPEFApprover(); }); $('#unitTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var selUnitID = $("#selUnitID").val(); ShowUploadBar(); $.ajax({ url: "./apr/loadUnitTableApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "sect": "1", "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); document.getElementById("pefPartIIApproverForm").style.display = "none"; } }); loadPEFApprover(); }); $('#empTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var selUnitID = $("#selUnitID").val(); ShowUploadBar(); $.ajax({ url: "./apr/loadEmpTableApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "empl": "1", "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); document.getElementById("pefPartIIApproverForm").style.display = "block"; } }); loadPEFApprover(); }); function loadPEFApprover(){ var userID = $("#userID").val(); var selUnitID = $("#selUnitID").val(); //Employee record id //alert(selUnitID); ShowUploadBar(); $.ajax({ url: "./apr/addPEFEvaluator.php", type: "POST", async: true, data: { "selUnitID":selUnitID, "userID":userID, "pefe":"1"//add new approver }, success: function(dx){ $("#tdPEFApprover").html(dx); $("#searchEvaluatorData").val(""); ShowUploadBar(); } }) } $('#tdPEFApprover').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); var aprID = $("#aprID").val(); var deleteAccess = $("#deleteAccess").val(); if(dCell == 3){ //alert(deleteAccess); if(deleteAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to delete record from this page...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } $.ajax({ url: "./apr/addPEFEvaluator.php", type: "POST", async: true, data: { "selUnitID":0, "employeeSearchID":0, "userID":0, "aprID":aprID, "pefe":"3"//delete evaluator }, success: function(dx){ $("#tdPEFApprover").html(dx); ShowUploadBar(); } }) } }); $('#tdDataTable').on("click","tr td",function(){ var data = $(this).text(); var dCell = $(this).index(); if(dCell == 5){ var userID = $("#userID").val(); var selUnitID = $("#selUnitID").val(); var aprID = $("#aprID").val(); var activeUnit = $("#activeUnit").val(); var deleteAccess = $("#deleteAccess").val(); //alert(deleteAccess); if(deleteAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to delete record from this page...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } Swal.fire({ title: 'Deleting Record', text: "Are you sure you want to delete this record? You won't be able to revert this!", icon: 'warning', showCancelButton: true, confirmButtonColor: '#3085d6', cancelButtonColor: '#d33', confirmButtonText: 'Yes, delete it!' }).then((result) => { if (result.isConfirmed) { ShowUploadBar(); if(activeUnit === "COMPANY"){ $.ajax({ url: "./apr/loadCompanyApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "lcomp": "3", "aprID":aprID, "userID":userID, "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); } if(activeUnit === "DEAL"){ $.ajax({ url: "./apr/loadBranchApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "ldeal": "3", "aprID":aprID, "userID":userID, "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); } if(activeUnit === "SUBG"){ $.ajax({ url: "./apr/loadSubGroupApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "sbGrp": "3", "aprID":aprID, "userID":userID, "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); } if(activeUnit === "DIVM"){ $.ajax({ url: "./apr/loaddivMTableApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "divM": "3", "aprID":aprID, "userID":userID, "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); } if(activeUnit === "DEPT"){ $.ajax({ url: "./apr/loadDeptTableApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "dept": "3", "aprID":aprID, "userID":userID, "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); } if(activeUnit === "SECT"){ $.ajax({ url: "./apr/loaduNITTableApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "sect": "3", "aprID":aprID, "userID":userID, "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); } if(activeUnit === "EMPL"){ $.ajax({ url: "./apr/loadEmpTableApprovers.php", method: 'POST', dataType: 'text', async:true, data: { "empl": "3", "aprID":aprID, "userID":userID, "selUnitID": selUnitID }, success: function(d){ $("#tdDataTable").html(d); ShowUploadBar(); } }); } } }) } }); function searchMyEmployee(){ var searchEmployee = $("#searchEmployee").val(); var selUnitID = $("#selUnitID").val(); var compName = $("#compName").val(); var len = searchEmployee.length; if(len > 0){ if(compName===""){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'No active company has been selected.' //footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } $.ajax({ url: "./apr/searchEmpByCompany.php", method: 'POST', dataType: 'text', async:true, data: { iSearch: 104, "searchEmployee": searchEmployee, "selUnitID": selUnitID }, success: function(d){ $("#searchData").html(d); } }); } //$('#marScore').val(myTotalScore.toFixed(2)); //$('#myVarianceNo').val(myVariance.toFixed(2)); } function searchMyEvaluator(){ var searchEmployee = $("#pefEvaluatorID").val(); var selUnitID = $("#selUnitID").val(); var compName = $("#compName").val(); var len = searchEmployee.length; if(len > 0){ if(compName===""){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'No active company has been selected.' //footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } $.ajax({ url: "./apr/searchEmpPEFApprover.php", method: 'POST', dataType: 'text', async:true, data: { iSearch: 104, "searchEmployee": searchEmployee, "selUnitID": selUnitID }, success: function(d){ $("#searchEvaluatorData").html(d); } }); } //$('#marScore').val(myTotalScore.toFixed(2)); //$('#myVarianceNo').val(myVariance.toFixed(2)); } function searchDept(){ var sDept = $("#sDept").val(); var sec = sDept.length; //if(sec > 0){ $.ajax({ url: "./apr/searchDepartment.php", method: 'POST', dataType: 'text', async:true, data: { iSearch: 104, "sDept": sDept }, success: function(d){ $("#deptTable").html(d); } }); // } //$('#marScore').val(myTotalScore.toFixed(2)); //$('#myVarianceNo').val(myVariance.toFixed(2)); } function searchSection(){ var sSect = $("#sSect").val(); //var sec = sSect.length; //if(sec > 0){ $.ajax({ url: "./apr/searchSection.php", method: 'POST', dataType: 'text', async:true, data: { iSearch: 104, "sSect": sSect }, success: function(d){ $("#unitTable").html(d); } }); // } //$('#marScore').val(myTotalScore.toFixed(2)); //$('#myVarianceNo').val(myVariance.toFixed(2)); } function searchEMPL(){ var sEmpl = $("#sEmpl").val(); var emp = sEmpl.length; //alert(sEmpl); if(emp > 0){ $.ajax({ url: "./apr/searchEmployee.php", method: 'POST', dataType: 'text', async:true, data: { iSearch: 104, "sEmpl": sEmpl }, success: function(d){ $("#empTable").html(d); } }); } //$('#marScore').val(myTotalScore.toFixed(2)); //$('#myVarianceNo').val(myVariance.toFixed(2)); } $("#addNewApproverID").click(function(){ var aprID = $("#aprID").val(); var activeUnit = $("#activeUnit").val(); var selUnitID = $("#selUnitID").val(); var employeeSearchID = $("#employeeSearchID").val(); var userID = $("#userID").val(); var addAccess = $("#addAccess").val(); if(addAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to add new record...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(employeeSearchID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select employee to continue...' //footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); if(activeUnit === "COMPANY"){ $.ajax({ url: "./apr/loadCompanyApprovers.php", type: "POST", async: true, data: { "aprID":aprID, "activeUnit":activeUnit, "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "lcomp":"2"//save company approver }, success: function(dx){ $("#tdDataTable").html(dx); $("#searchEmployee").val(""); ShowUploadBar(); } }) } if(activeUnit === "DEAL"){ $.ajax({ url: "./apr/loadBranchApprovers.php", type: "POST", async: true, data: { "aprID":aprID, "activeUnit":activeUnit, "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "ldeal":"2"//save company approver }, success: function(dx){ $("#tdDataTable").html(dx); $("#searchEmployee").val(""); ShowUploadBar(); } }) } if(activeUnit === "SUBG"){ $.ajax({ url: "./apr/loadSubGroupApprovers.php", type: "POST", async: true, data: { "aprID":aprID, "activeUnit":activeUnit, "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "sbGrp":"2"//save company approver }, success: function(dx){ $("#tdDataTable").html(dx); $("#searchEmployee").val(""); ShowUploadBar(); } }) } if(activeUnit === "DIVM"){ $.ajax({ url: "./apr/loaddivMTableApprovers.php", type: "POST", async: true, data: { "aprID":aprID, "activeUnit":activeUnit, "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "divM":"2"//save company approver }, success: function(dx){ $("#tdDataTable").html(dx); $("#searchEmployee").val(""); ShowUploadBar(); } }) } if(activeUnit === "DEPT"){ $.ajax({ url: "./apr/loadDeptTableApprovers.php", type: "POST", async: true, data: { "aprID":aprID, "activeUnit":activeUnit, "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "dept":"2"//save company approver }, success: function(dx){ $("#tdDataTable").html(dx); $("#searchEmployee").val(""); ShowUploadBar(); } }) } if(activeUnit === "SECT"){ $.ajax({ url: "./apr/loadUnitTableApprovers.php", type: "POST", async: true, data: { "aprID":aprID, "activeUnit":activeUnit, "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "sect":"2"//save company approver }, success: function(dx){ $("#tdDataTable").html(dx); $("#searchEmployee").val(""); ShowUploadBar(); } }) } if(activeUnit === "EMPL"){ $.ajax({ url: "./apr/loadEmpTableApprovers.php", type: "POST", async: true, data: { "aprID":aprID, "activeUnit":activeUnit, "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "empl":"2"//save company approver }, success: function(dx){ $("#tdDataTable").html(dx); $("#searchEmployee").val(""); ShowUploadBar(); } }) } }); $("#addNewPEFAvaluator").click(function(){ var selUnitID = $("#selUnitID").val(); //employee id needs approvers var employeeSearchID = $("#employeeSearchID").val(); var userID = $("#userID").val(); var addAccess = $("#addAccess").val(); var activeUnit = $("#activeUnit").val(); if(addAccess == 0){ Swal.fire({ icon: 'error', title: 'Access Denied', text: 'You are not allowed to add new record...', footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } if(employeeSearchID===''){ Swal.fire({ icon: 'error', title: 'Invalid Entry', text: 'Please select employee to continue...' //footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' }) return false; } ShowUploadBar(); if(activeUnit === "EMPL"){ $.ajax({ url: "./apr/addPEFEvaluator.php", type: "POST", async: true, data: { "selUnitID":selUnitID, "employeeSearchID":employeeSearchID, "userID":userID, "pefe":"2"//add new approver }, success: function(dx){ $("#tdPEFApprover").html(dx); $("#searchEvaluatorData").val(""); ShowUploadBar(); } }) } }); </script> searchEmpByCompany.php 0000644 00000003606 15025030741 0011010 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['iSearch'])){ $selUnitID = $_POST['selUnitID']; $searchEmployee = $_POST['searchEmployee']; $getEmpInfo = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `last_name` LIKE '%$searchEmployee%' || `first_name` LIKE '%$searchEmployee%' || `emp_id` LIKE '%$searchEmployee%' ORDER BY `last_name` ASC LIMIT 10"; $getEmp = mysqli_query($conn,$getEmpInfo); $statRow = mysqli_num_rows($getEmp); ?><table style="width:100%;border-collapse:collapse;"> <?php if($statRow > 0){ echo "<thead> <th style='width:20%;padding-left:2px;text-align:left;border:0px solid red'>REC.ID</thd> <th style='width:20%;padding-left:2px;text-align:left;border:0px solid red'>EMP. ID</th> <th style='width:60%;padding-left:2px;text-align:left;border:0px solid red'>EMPLOYEE NAME</th> </thead>"; while($eow = mysqli_fetch_array($getEmp)){ ?><tr onclick="javascript:getSearchEmpID(this);" style="width:100%"><?php echo "<td style='width:20%;border:0px solid red'>".$eow['id']."</td>"; echo "<td style='width:20%;border:0px solid red'>".$eow['emp_id']."</td>"; echo "<td style='width:60%;border:0px solid red'>".strtoupper($eow['last_name']).", ".strtoupper($eow['first_name'])."</td>"; echo "</tr>"; } }else{ echo "<h6 style='padding:20px;text-align:center'>No record found.</h6>"; } ?> </table> <?php $conn->close(); } ?> searchEmployee.php 0000644 00000001667 15025030741 0010231 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['iSearch'])){ $searchString= $_POST['sEmpl']; $getUnit = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `first_name` LIKE '%$searchString%' || `deleted`=0 AND `last_name` LIKE '%$searchString%' || `deleted`=0 AND `emp_id` LIKE '%$searchString%' ORDER BY `last_name` ASC LIMIT 20"; $getU = mysqli_query($conn,$getUnit); $statRow = mysqli_num_rows($getU); while($row = mysqli_fetch_array($getU)){ ?><tr onclick="javascript:employeeMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['last_name'].", ".$row['first_name']." - ".$row['emp_id']."</td>"; echo "</tr>"; } $conn->close(); } ?> loadCompanyApprovers.php 0000644 00000012345 15025030741 0011427 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['lcomp'])){ $empLName = ""; $empFName = ""; $empID = ""; $empLevel = ""; $errorMSG=""; $lcomp = $_POST['lcomp']; 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` ='COMP' AND `unit_id`='$selUnitID' AND `approver_id`='$employeeSearchID' AND `level`='COMP' 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', 'COMP', '$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` ='COMP' 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:aprData(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(); } ?> searchSection.php 0000644 00000001352 15025030741 0010045 0 ustar 00 <?php include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['iSearch'])){ $searchString= $_POST['sSect']; $getUnit = "SELECT * FROM `pms_unit_tbl` WHERE `deleted`=0 AND `unit_name` LIKE '%$searchString%' ORDER BY `unit_name` ASC LIMIT 20"; $getU = mysqli_query($conn,$getUnit); $statRow = mysqli_num_rows($getU); while($row = mysqli_fetch_array($getU)){ ?><tr onclick="javascript:sectionMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['unit_name']."</td>"; echo "</tr>"; } $conn->close(); } ?> addPEFEvaluator.php 0000644 00000007126 15025030741 0010226 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['pefe'])){ $errorMSG=""; $selUnitID = $_POST['selUnitID']; $userID = $_POST['userID']; $lcomp = $_POST['pefe']; switch ($lcomp){ case 1: //LOAD break; case 2: //ADD //check if exist $employeeSearchID = $_POST['employeeSearchID']; $chkIfExist = "SELECT * FROM `pef_parttwo_evaluator` WHERE `deleted`=0 AND `emp_id`='$selUnitID' AND `pef_evaluator_id`='$employeeSearchID'"; $valExist = mysqli_query($conn,$chkIfExist); $valRow = mysqli_num_rows($valExist); if($valRow > 0){ $errorMSG="Record already exist."; }else{ //store data $sql = "INSERT INTO pef_parttwo_evaluator ( `id`, `emp_id`, `pef_evaluator_id`, `type`, `added_by`) VALUES ( '', '$selUnitID', '$employeeSearchID', 'PEF', '$userID')"; if ($conn->query($sql) === TRUE) { $errorMSG="Record has been saved."; } else { $errorMSG="Error saving record"; } } break; case 3: //DELETE aprID $aprID = $_POST['aprID']; $sql = "UPDATE pef_parttwo_evaluator SET deleted = 1 WHERE `id`='$aprID'"; if ($conn->query($sql) === TRUE) { $errorMSG="Record has been deleted."; } else { $errorMSG="Error saving record."; } break; } $getCApprover = "SELECT * FROM `pef_parttwo_evaluator` WHERE `deleted`=0 AND `type` ='PEF' AND `emp_id`='$selUnitID' ORDER BY `id` ASC LIMIT 20"; $getApr = mysqli_query($conn,$getCApprover); $statRow = mysqli_num_rows($getApr); while($row = mysqli_fetch_array($getApr)){ $approverID = $row['pef_evaluator_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:15%;border:0px solid red'>"; echo $row['emp_id']; echo "</td>"; echo "<td style='width:70%;border:0px solid red'>"; echo getEmployeeEmpInformationB($approverID)[2] . ", ". getEmployeeEmpInformationB($approverID)[3]; 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:14px'></i></abbr> </td>"; echo "<tr>"; } echo "<tr><td colspan=4 style='padding:20px;color:red;font-size:14px;text-align:left;background:white;border:0px solid white'>".$errorMSG."</td></tr>"; $conn->close(); } ?> loadDeptTableApprovers.php 0000644 00000012324 15025030741 0011662 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['dept'])){ $empLName = ""; $empFName = ""; $empID = ""; $empLevel = ""; $errorMSG=""; $lcomp = $_POST['dept']; 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` ='DEPT' 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', 'DEPT', '$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` ='DEPT' 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