File manager

File manager - Edit - /home/autoph/public_html/voc/home/CL_CLEARANCE_APPROVAL_VIEW.php

Back
<?php ob_start(); include 'core/init.php'; protected_page(); $comID=$user_data['company']; if(isset($_GET['company'])){ $comName=$_GET['company'];//mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$comID'"),0); }else{ $comName = mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$comID'"),0); } $userID = $user_data['u_id']; ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" href="css/style_menu.css"> <link rel="stylesheet" href="css/style.css"> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> $(function () { $('.showMenu').click(function () { $('.DivToHide').show(); }); $('.showMenu').click(function () { $('.DivToHide').hide(); }); }); $(function () { $('.showMenu').click(function () { $('.DivToHide').show(); }); $('.showMenu').click(function () { $('.DivToHide').hide(); }); }); function confirmDeleteBox(){ var diva=document.getElementById("deleteBoxYesNo"); if (diva.style.display == 'none') { diva.style.display = ''; } else { diva.style.display = 'none'; } } function showAddNewForm(){ var diva=document.getElementById("AddNewInventoryForm"); if (diva.style.display == 'none') { diva.style.display = ''; } else { diva.style.display = 'none'; } } function showAddNewAdminForm(){ var diva=document.getElementById("FORMAddNewAdmin"); if (diva.style.display == 'none') { diva.style.display = ''; } else { diva.style.display = 'none'; } } function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="wait" style="display:none;width:400px;height:100px;border:0px solid red;position:absolute;top:50%;left:45%;padding:2px;z-index:999999999999999999"> <img src='images/demo_wait.gif' width="64" height="64" /><br>Loading...</div> <!-- add jquery --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script language="javascript" type="text/javascript"> function UpdateApprovalCount() { $.ajax({ url: "CL_UPDATE_APPROVAL_COUNT.php", type: "get", dataType: "text", success: function(data){ $('#ForMyApproval').html(data); } }); } function UpdateMyClearanceCount() { $.ajax({ url: "CL_UPDATE_MYCLEARANCE_COUNT.php", type: "get", dataType: "text", success: function(data){ $('#MyClearanceForm').html(data); } }); } function UpdateUnPostedClerance() { $.ajax({ url: "CL_UPDATE_UNPOSTED_COUNT.php", type: "get", dataType: "text", success: function(data){ $('#UnPostedClearance').html(data); } }); } function UpdateCleranceList() { $.ajax({ url: "CL_UPDATE_CLERANCE_LIST_COUNT.php", type: "get", dataType: "text", success: function(data){ $('#cleranceList').html(data); } }); } function UpdateFinalPay() { $.ajax({ url: "CL_UPDATE_FINAL_PAY_COUNT.php", type: "get", dataType: "text", success: function(data){ $('#FinalPay').html(data); } }); } function UpdateReadyForRelease() { $.ajax({ url: "CL_UPDATE_FOR_RELEASE_COUNT.php", type: "get", dataType: "text", success: function(data){ $('#forReleasePay').html(data); } }); } $(document).ready(function(){ $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); //============================================================================================================================================ //============================================================================================================================================ $("#goSearchRecord").click(function(){ var SearchText = $("#SearchText").val(); //alert(SearchText); //return false; if(SearchText==""){ //alert('Invalid Entry'); $('#SearchText').focus(); $('#SearchText').css({'border':'1px solid red'}); $('#SearchText').css({'color':'red'}); $('#SearchText').attr("placeholder","Enter something to search..."); return false; } //if(confirm("WARNING: \n\nARE YOU SURE YOU WANT TO DELETE THIS RECORD? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_SEARCH_CL_HEADER.php", type: "POST", async: false, data: { "SearchText": SearchText, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#templateContent").html(d); //invHideAssignMsg(); //$('#searchText').val(''); . ShowUploadBar(); } }) //} }); //============================================================================================================================================ //============================================================================================================================================ $("#disApprovedClearance").click(function(){ var NewCLRecordID = $("#NewCLRecordID").val(); //endaya aee var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); //alert(recordID); //return false; if(NewCLRecordID == ""){ alert('No record has been selected'); return false; } if(confirm("CONFIRM YOUR ACTION: \n\nAre you sure you want to DISAPPROVE this clearance Form? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "CL_DISAPPROVED_NEW_CLEARANCE_FORM.php", type: "POST", async: false, data: { "NewCLRecordID": NewCLRecordID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ $("#templateContent").html(d); alert("New Clearance Form has been saved."); hideAdminFormEdit(); UpdateApprovalCount(); UpdateMyClearanceCount(); UpdateUnPostedClerance(); UpdateCleranceList(); UpdateFinalPay(); UpdateReadyForRelease(); ShowUploadBar(); } }) } }); //============================================================================================================================================ //============================================================================================================================================ $("#processClearanceApproval").click(function(){ var ClearanceDataID = $("#ClearanceDataID").val(); var txtHeaderID = $("#txtHeaderID").val(); var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); if(ClearanceDataID==""){ alert('No record has been selected'); return false; } ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_OFFICER_APPROVED_SAVE.php", type: "POST", async: false, data: { "ClearanceDataID": ClearanceDataID, "txtHeaderID": txtHeaderID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ $("#templateContentSubA").html(d); hideOfficerApproval(); UpdateApprovalCount(); ShowUploadBar(); } }) //} }); //============================================================================================================================================ //============================================================================================================================================ $("#actionSlipSubmit").click(function(){ var ClearanceDataID = $("#ClearanceDataID").val(); var txtHeaderID = $("#txtHeaderID").val(); var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); var ActionSlip = $("#ActionSlip").val(); var ActionSlipAmount = $("#ActionSlipAmount").val(); //alert(ActionSlip); //return false; if(ClearanceDataID==""){ alert('No record has been selected'); return false; } if(ActionSlip==""){ $('#ActionSlip').focus(); $('#ActionSlip').css({'border':'1px solid red'}); $('#ActionSlip').css({'color':'red'}); $('#ActionSlip').attr("placeholder","Enter something to search..."); //alert('No record has been selected'); return false; } if(ActionSlipAmount==""){ $('#ActionSlipAmount').focus(); $('#ActionSlipAmount').css({'border':'1px solid red'}); $('#ActionSlipAmount').css({'color':'red'}); $('#ActionSlipAmount').attr("placeholder","Required"); //alert('No record has been selected'); return false; } ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_OFFICER_ACTION_SLIP_SAVE.php", type: "POST", async: false, data: { "ClearanceDataID": ClearanceDataID, "txtHeaderID": txtHeaderID, "addCompID": addCompID, "ActionSlip": ActionSlip, "addByUID": addByUID, "ActionSlipAmount": ActionSlipAmount, "done": 1 }, success: function(d){ $('#ActionSlip').val(''); $('#ActionSlipAmount').val(''); ShowUploadBar(); hideOfficerApproval(); $("#ApprovalResult").html(d); } }) //} }); //============================================================================================================================================ //============================================================================================================================================ $("#ApproveFinalClearanceForm").click(function(){ var NewCLRecordID = $("#NewCLRecordID").val(); //Aendaya var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); //alert(recordID); //return false; if(NewCLRecordID == ""){ alert('No record has been selected'); return false; } ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_FINAL_APPROVAL_CLEARANCE_FORM.php", type: "POST", async: false, data: { "NewCLRecordID": NewCLRecordID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ $("#ContentFinalApproval").html(d); // alert("New Clearance Form has been saved."); hideFORMClearanceFinalApproval(); UpdateApprovalCount(); ShowUploadBar(); } }) //} }); //============================================================================================================================================ //============================================================================================================================================ $("#EndorseNewClearanceForm").click(function(){ var NewCLRecordID = $("#NewCLRecordID").val(); //endaya var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); //alert(recordID); //return false; if(NewCLRecordID == ""){ alert('No record has been selected'); return false; } ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_ENDORSE_CLEARANCE_FORM.php", type: "POST", async: false, data: { "NewCLRecordID": NewCLRecordID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#ContentEndorsement").html(d); UpdateApprovalCount(); hideFORMClearanceEndorsement()(); UpdateApprovalCount(); UpdateMyClearanceCount(); UpdateUnPostedClerance(); UpdateCleranceList(); UpdateFinalPay(); UpdateReadyForRelease(); ShowUploadBar(); } }) //} }); //============================================================================================================================================ //============================================================================================================================================ $("#postNewClearanceForm").click(function(){ var NewCLRecordID = $("#NewCLRecordID").val(); //endaya var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); //alert(recordID); //return false; if(NewCLRecordID == ""){ alert('No record has been selected'); return false; } ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_POST_NEW_CLEARANCE_FORM.php", type: "POST", async: false, data: { "NewCLRecordID": NewCLRecordID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ $("#templateContentSubB").html(d); //alert("New Clearance Routed to all approving officers"); hideAdminFormEdit(); UpdateApprovalCount(); UpdateMyClearanceCount(); UpdateUnPostedClerance(); UpdateCleranceList(); UpdateFinalPay(); UpdateReadyForRelease(); ShowUploadBar(); } }) //} }); //============================================================================================================================================ //============================================================================================================================================ $("#PostButton").click(function(){ var NewCLRecordID = $("#NewCLRecordID").val(); var addCompID = $("#addCompID").val(); if(NewCLRecordID==""){ alert('No record has been selected'); return false; } showAdminFormEdit(); ShowUploadBar(); // alert(NewCLRecordID); // return false; $.ajax({ url: "CL_HR_APPROVAL_LOAD_DATA.php", type: "POST", async: false, data: { "addCompID": addCompID, "NewCLRecordID": NewCLRecordID, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#EditResult").html(d); //invHideAssignMsg(); //$('#searchText').val(''); UpdateApprovalCount(); UpdateMyClearanceCount(); UpdateUnPostedClerance(); UpdateCleranceList(); UpdateFinalPay(); UpdateReadyForRelease(); ShowUploadBar(); } }) }); //============================================================================================================================================ //=================AEE=========================================================================================================================== $("#myEndorsementButton").click(function(){ var NewCLRecordID = $("#NewCLRecordID").val(); var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); if(NewCLRecordID==""){ alert('No record has been selected'); return false; } showFORMClearanceEndorsement(); ShowUploadBar(); // alert(NewCLRecordID); //return false; $.ajax({ url: "CL_ENDORSING_OFFICER_LOAD_DATA.php", type: "POST", async: false, data: { "addCompID": addCompID, "NewCLRecordID": NewCLRecordID, "addByUID": addByUID, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#endorseClearance").html(d); //invHideAssignMsg(); UpdateApprovalCount(); UpdateMyClearanceCount(); UpdateUnPostedClerance(); UpdateCleranceList(); UpdateFinalPay(); UpdateReadyForRelease(); ShowUploadBar(); } }) }); //============================================================================================================================================ //============================================================================================================================================ $("#myFinalApprovalButton").click(function(){ var NewCLRecordID = $("#NewCLRecordID").val(); var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); if(NewCLRecordID==""){ alert('No record has been selected'); return false; } showFORMClearanceFinalApproval(); ShowUploadBar(); // alert(NewCLRecordID); //return false; $.ajax({ url: "CL_APPROVING_OFFICER_LOAD_DATA.php", type: "POST", async: false, data: { "addCompID": addCompID, "NewCLRecordID": NewCLRecordID, "addByUID": addByUID, "done": 1 }, success: function(d){ //invShowAssignMsg(); //hideFORMClearanceFinalApproval(); $("#FinalApprovalClearance").html(d); ShowUploadBar(); UpdateApprovalCount(); UpdateMyClearanceCount(); UpdateUnPostedClerance(); UpdateCleranceList(); UpdateFinalPay(); UpdateReadyForRelease(); //$('#searchText').val(''); } }) }); //============================================================================================================================================ //============================================================================================================================================ $("#ApproveButton").click(function(){ var ClearanceDataID = $("#ClearanceDataID").val(); var txtHeaderID = $("#txtHeaderID").val(); var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); if(ClearanceDataID==""){ alert('No record has been selected'); return false; } showOfficerApproval(); ShowUploadBar(); //alert(ClearanceDataID); //return false; $.ajax({ url: "CL_CLEARING_OFFICER_LOAD_DATA.php", type: "POST", async: false, data: { "addCompID": addCompID, "txtHeaderID": txtHeaderID, "ClearanceDataID": ClearanceDataID, "addByUID": addByUID, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#ApprovalResult").html(d); ShowUploadBar(); } }) }); //============================================================================================================================================ //================================================================================================================================= $("#loadEndorsementApprovalForm").click(function(){ var ClearanceDataID = $("#ClearanceDataID").val(); //endaya var txtHeaderID = $("#txtHeaderID").val(); //endaya var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); //alert(ClearanceDataID); //return false; if(ClearanceDataID == ""){ alert('No record has been selected'); return false; } showFORMFullView(); ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_LOAD_CLEARANCE_SIGNATORY.php", type: "POST", async: false, data: { "ClearanceDataID": ClearanceDataID, "txtHeaderID": txtHeaderID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ $("#clearanceSignatoryList").html(d); //hideActionSlipForm(); ShowUploadBar(); } }) //} }); //============================================================================================================================================ //================================================================================================================================= $("#viewClearanceForm").click(function(){ var ClearanceDataID = $("#ClearanceDataID").val(); //endaya var txtHeaderID = $("#txtHeaderID").val(); //endaya var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); //alert(ClearanceDataID); //return false; if(ClearanceDataID == ""){ alert('No record has been selected'); return false; } showFORMFullView(); ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_LOAD_CLEARANCE_SIGNATORY_CLEARING_VIEW.php", type: "POST", async: false, data: { "ClearanceDataID": ClearanceDataID, "txtHeaderID": txtHeaderID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ $("#clearanceSignatoryList").html(d); //hideActionSlipForm();. ShowUploadBar(); } }) //} }); //============================================================================================================================================ //=======================Arnel Endaya========================================================================================================== $("#loadClearanceFormA").click(function(){ var ClearanceDataID = $("#ClearanceDataID").val(); //endaya var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); //alert(ClearanceDataID); //return false; if(ClearanceDataID == ""){ alert('No record has been selected'); return false; } showFORMFullView(); ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_LOAD_CLEARANCE_SIGNATORY_VIEW.php", type: "POST", async: false, data: { "ClearanceDataID": ClearanceDataID, //"txtHeaderID": txtHeaderID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ $("#clearanceSignatoryList").html(d); //hideActionSlipForm(); ShowUploadBar(); } }) //} }); //============================================================================================================================================ //=======================Arnel Endaya========================================================================================================== $("#loadClearanceFormF").click(function(){ var ClearanceDataID = $("#ClearanceDataID").val(); //endaya var txtHeaderID = $("#txtHeaderID").val(); //endaya var addCompID = $("#addCompID").val(); var addByUID = $("#addByUID").val(); //alert(ClearanceDataID); //return false; if(ClearanceDataID == ""){ alert('No record has been selected'); return false; } showFORMFullView(); ShowUploadBar(); //if(confirm("CONFIRM CHANGES: \n\nAre you sure you want to modify this record? \n\n Press 'OK' button to proceed...")){ $.ajax({ url: "CL_LOAD_CLEARANCE_SIGNATORY_VIEW.php", type: "POST", async: false, data: { "ClearanceDataID": ClearanceDataID, "txtHeaderID": txtHeaderID, "addCompID": addCompID, "addByUID": addByUID, "done": 1 }, success: function(d){ $("#clearanceSignatoryList").html(d); //hideActionSlipForm(); ShowUploadBar(); } }) //} }); //============================================================================================================================================ //============================================================================================================================================ }); function hideFORMFullView(){ $("#FORMFullView").fadeOut(200); }; function showFORMFullView(){ $("#FORMFullView").fadeIn(200); }; function hideAdminForm(){ $("#FORMAddNewAdmin").fadeOut(500); }; function showAdminForm(){ $("#FORMAddNewAdmin").fadeIn(500); }; function hideAdminFormEdit(){ $("#FORMAddNewAdminEdit").fadeOut(500); }; function showAdminFormEdit(){ $("#FORMAddNewAdminEdit").fadeIn(500); }; function hideFORMClearanceFinalApproval(){ $("#FORMClearanceFinalApproval").fadeOut(500); }; function showFORMClearanceFinalApproval(){ $("#FORMClearanceFinalApproval").fadeIn(500); }; function hideFORMClearanceEndorsement(){ $("#FORMClearanceEndorsement").fadeOut(500); }; function showFORMClearanceEndorsement(){ $("#FORMClearanceEndorsement").fadeIn(500); }; function hideOfficerApproval(){ $("#FORMOfficeApproval").fadeOut(500); }; function showOfficerApproval(){ $("#FORMOfficeApproval").fadeIn(500); }; function showPostButton(){ $("#PostButton").fadeOut(200); }; function hidePostButton(){ $("#PostButton").fadeIn(200); }; function showClearanceForAuthorization(row) { $("#myFinalApprovalButton").fadeOut(); $("#myEndorsementButton").fadeOut(); $("#PostButton").fadeIn(); $("#ApproveButton").fadeOut(); var x=row.cells; document.getElementById("NewCLRecordID").value = x[1].innerHTML; document.getElementById("activeRecord").value = "SELECTED RECORD: " + x[2].innerHTML + " (Record # " + x[1].innerHTML +")"; document.getElementById("NewCLRecordEmpID").value = x[3].innerHTML; document.getElementById("ClearanceDataID").value = x[1].innerHTML; } function showEndorsement(row) { $("#myFinalApprovalButton").fadeOut(); $("#myEndorsementButton").fadeIn(); $("#PostButton").fadeOut(); $("#ApproveButton").fadeOut(); var x=row.cells; document.getElementById("NewCLRecordID").value = x[1].innerHTML; document.getElementById("activeRecord").value = "SELECTED RECORD: " + x[2].innerHTML + " (Record # " + x[1].innerHTML +")"; document.getElementById("NewCLRecordEmpID").value = x[3].innerHTML; document.getElementById("ClearanceDataID").value = x[1].innerHTML; } function showApproval(row) { $("#myFinalApprovalButton").fadeIn(); $("#myEndorsementButton").fadeOut(); $("#PostButton").fadeOut(); $("#ApproveButton").fadeOut(); var x=row.cells; document.getElementById("NewCLRecordID").value = x[1].innerHTML; document.getElementById("activeRecord").value = "SELECTED RECORD: " + x[2].innerHTML + " (Record # " + x[1].innerHTML +")"; document.getElementById("NewCLRecordEmpID").value = x[3].innerHTML; document.getElementById("ClearanceDataID").value = x[1].innerHTML; } //============================================================================================================================================ function showClearanceApproval(row) { $("#PostButton").fadeOut(); $("#ApproveButton").fadeIn(); $("#myFinalApprovalButton").fadeOut(); $("#myEndorsementButton").fadeOut(); var x=row.cells; document.getElementById("txtHeaderID").value = x[0].innerHTML; document.getElementById("ClearanceDataID").value = x[1].innerHTML; document.getElementById("activeRecord").value = "SELECTED RECORD: " + x[4].innerHTML + " (Record # " + x[1].innerHTML +")"; document.getElementById("NewCLRecordEmpID").value = x[3].innerHTML; } </script> <style> p{ font-Family:Calibri; font-size:20px; font-weight:bold; color:black; padding:10px; padding-top:0px; margin:10px; margin-top:0px; margin-left:0px; } select { -webkit-appearance: button; -moz-appearance: button; -webkit-user-select: none; -moz-user-select: none; -webkit-padding-end: 20px; -moz-padding-end: 20px; -webkit-padding-start: 2px; -moz-padding-start: 2px; background-color: #d9dad8 ; /* Fallback color if gradients are not supported / background-image: url(images/select-arrow.png), -webkit-linear-gradient(top, #E5E5E5, #F4F4F4); / For Chrome and Safari / background-image: url(images/select-arrow.png), -moz-linear-gradient(top, #E5E5E5, #F4F4F4); / For old Firefox (3.6 to 15) / background-image: url(images/select-arrow.png), -ms-linear-gradient(top, #E5E5E5, #F4F4F4); / For pre-releases of Internet Explorer 10/ background-image: url(images/select-arrow.png), -o-linear-gradient(top, #E5E5E5, #F4F4F4); / For old Opera (11.1 to 12.0) / background-image: url(images/select-arrow.png), linear-gradient(to bottom, #E5E5E5, #F4F4F4); / Standard syntax; must be last / background-position: center right; background-repeat: no-repeat; border: 1px solid #AAA; border-radius: 2px; box-shadow: 0px 1px 3px rgba(0, 0, 0, 0.1); color: #555; font-size: 14px; margin: 0px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; padding-right:5px; } .bgColorBlk{ background: -webkit-linear-gradient(left top,#000000, #646462,#e3e3da); / For Safari 5.1 to 6.0 / background: -o-linear-gradient(bottom right, #000000, #646462,#e3e3da); / For Opera 11.1 to 12.0 / background: -moz-linear-gradient(bottom top, #000000, #646462,#e3e3da); / For Firefox 3.6 to 15 / background: linear-gradient(to bottom right, #000000, #646462,#e3e3da); / Standard syntax / } input, text, date { -webkit-appearance: button; -moz-appearance: button; -webkit-user-select: none; -moz-user-select: none; -webkit-padding-end: 20px; -moz-padding-end: 20px; -webkit-padding-start: 2px; -moz-padding-start: 2px; background-color: #d9dad8 ; / Fallback color if gradients are not supported / background-image: url(images/pen.png), -webkit-linear-gradient(top, #E5E5E5, #F4F4F4); / For Chrome and Safari / background-image: url(images/pen.png), -moz-linear-gradient(top, #E5E5E5, #F4F4F4); / For old Firefox (3.6 to 15) / background-image: url(images/pen.png), -ms-linear-gradient(top, #E5E5E5, #F4F4F4); / For pre-releases of Internet Explorer 10/ background-image: url(images/pen.png), -o-linear-gradient(top, #E5E5E5, #F4F4F4); / For old Opera (11.1 to 12.0) / background-image: url(images/pen.png), linear-gradient(to bottom, #E5E5E5, #F4F4F4); / Standard syntax; must be last / background-position: center left; background-repeat: no-repeat; border: 1px solid #AAA; border-radius: 2px; box-shadow: 0px 1px 3px rgba(0, 0, 0, 0.1); color: #555; font-size: 14px; margin: 0px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; padding-left:5px; height:30px; margin-top:0px; text-align:center; } textarea { -webkit-appearance: button; -moz-appearance: button; -webkit-user-select: none; -moz-user-select: none; -webkit-padding-end: 20px; -moz-padding-end: 20px; -webkit-padding-start: 2px; -moz-padding-start: 2px; background-color: #d9dad8 ; / Fallback color if gradients are not supported / background-image: url(images/pen.png), -webkit-linear-gradient(top, #E5E5E5, #F4F4F4); / For Chrome and Safari / background-image: url(images/pen.png), -moz-linear-gradient(top, #E5E5E5, #F4F4F4); / For old Firefox (3.6 to 15) / background-image: url(images/pen.png), -ms-linear-gradient(top, #E5E5E5, #F4F4F4); / For pre-releases of Internet Explorer 10/ background-image: url(images/pen.png), -o-linear-gradient(top, #E5E5E5, #F4F4F4); / For old Opera (11.1 to 12.0) / background-image: url(images/pen.png), linear-gradient(to bottom, #E5E5E5, #F4F4F4); / Standard syntax; must be last / background-position: center right; background-repeat: no-repeat; border: 1px solid #AAA; border-radius: 2px; box-shadow: 0px 1px 3px rgba(0, 0, 0, 0.1); color: #555; font-size: 14px; margin: 0px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; height:30px; margin-top:0px; padding:2px; } table{ border-collapse:collapse; width:100%; } th{ padding:8px; font-family:Verdana; color: #c4cac3 ; font-size:12px; font-weight:normal; border:1px solid gray; text-align:left; background:#2c3e29; } .tableMenu{ display:block;padding:3px;font-weight:normal;color:blue;border:1px solid gray;;width:70px;float:left;margin-right:15px; } .tableMenu:hover{ display:block;padding:3px;font-weight:bold;color:red;cursor: pointer;border:1px solid red;width:70px;background:#f4fcb6;float:left;;margin-right:15px; } </style> </head> <body style="font-family:Verdana;color:#aaaaaa;background:white"> <!--#########################################################################--> <div id="loadBaraData" style="display:none;position:absolute;top:50%;left:35%;width:30%;padding:5px;padding-left:2px;padding-right:2px;height:80px;background:transparent;z-index:9999;border:0px solid gray;z-index:999999999999999999"> <div id="uploadBar" style="font-family:Calibri;font-size:14px;color:red;text-align:center;margin-top:0px;background:white;display:block;width:100%;height:50px;border:0px solid red;position:relative;left:5px;padding:5px;z-index:999999999999999999;border:1px solid orange"> <img src='images/ajaxLoader.gif' width="100%" height="20px" /><br><center>Working...<center></div> </div> <!--#########################################################################--> <!--===================================================== --> <!--===========OPEN TEMPLATE FOR VIEW======================== --> <input type="hidden" id="addByUID" value="<?php echo $userID;?>"> <input type="hidden" id="addCompID" value="<?php echo $comID;?>"> <input type="hidden" id="NewCLRecordID"> <input type="hidden" id="NewCLRecordEmpID"> <input type="hidden" id="ClearanceDataID"> <input type="hidden" id="txtHeaderID"> <!--===================================================== --> <!--===========FINAL APPROVAL CLEARANCE FORM======================== --> <div id="FORMClearanceFinalApproval" style="display:none;width:1000px;height:541px;background:#fce4a4;border:1px solid black;position:absolute;top:150px;left:300px;z-index:9999"> <div class='bgColor' style='vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-size:16px;font-weight:bold;color:black;text-align:left;'> ☶ PROCESS CLEARANCE FINAL APPROVAL: <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideFORMClearanceFinalApproval()' style='font-weight:bold'> ✕ </a> </div> </div> <!--BODY--> <div style="padding:10px;width:100%;height:510px;margin:0px;border;1px solid black;background:white;border-bottom:1px solid gray"> <p style="border-radius:0px;float:right;width:100%;padding:10px;padding-top:5px;height:40px">❖   FINAL APPROVAL</p> <div id="FinalApprovalClearance" style="width:100%;height:380px;background: #fce4a4 ;margin-top:10px;border:1px solid gray;overflow:auto"> <!-- CONTENT OF SELECTED RECORD GOES HERE...--> </div> <!-- postNewClearanceForm--> <input type="submit" id="ApproveFinalClearanceForm" value="⚐   APPROVE CLEARANCE" style="padding:5px;height:40px;width:250px;float:right;margin-right:10px;font-family:Calibri;font-size:16px;font-weight:bold"> <button id='loadClearanceFormF' type="submit" onclick='hideAdminFormEdit()'STYLE="padding:5px;height:40px;width:250px;float:right;margin-right:20px;margin-top:10px;font-familu:Calibri;font-size:14px">&check;   VIEW CLEARANCE SIGNATORY </button> </div> </div> <!--===================================================== --> <!--===========ENDORSE CLEARANCE FORM======================== --> <div id="FORMClearanceEndorsement" style="display:none;width:1000px;height:541px;background:#fce4a4;border:1px solid black;position:absolute;top:150px;left:300px;z-index:9999"> <div class='bgColor' style='vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-size:16px;font-weight:bold;color:black;text-align:left;'> ☶ PROCESS CLEARANCE ENDORSEMENT: <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideFORMClearanceEndorsement()' style='font-weight:bold'> ✕ </a> </div> </div> <!--BODY--> <div style="padding:10px;width:100%;height:510px;margin:0px;border;1px solid black;background:white;border-bottom:1px solid gray"> <p style="border-radius:0px;float:right;width:100%;padding:10px;padding-top:5px;height:40px">❖   ENDORSE CLEARANCE FORM</p> <div id="endorseClearance" style="width:100%;height:380px;background: #fce4a4 ;margin-top:10px;border:1px solid gray;overflow:auto"> </div> <!-- postNewClearanceForm--> <input type="submit" id="EndorseNewClearanceForm" value="⚐   ENDORSE CLEARANCE" style="padding:10px;height:50px;width:250px;float:right;margin-right:10px;font-family:Calibri;font-size:16px;font-weight:bold"> <button id='loadEndorsementApprovalForm' type="submit" onclick='hideAdminFormEdit()'STYLE="padding:5px;height:50px;width:250px;float:right;margin-right:20px;margin-top:10px;font-familu:Calibri;font-size:14px">&check;   VIEW CLEARANCE SIGNATORY </button> </div> </div> <!--===================================================== --> <!--===========VIEW CLEARANCE FORM======================== --> <div id="FORMFullView" style="display:none;width:1200px;height:700px;background:#fce4a4;border:1px solid black;position:absolute;top:80px;left:200px;z-index:9999"> <div class='grayBG' style='vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-size:16px;font-weight:bold;color:black;text-align:left;'> ☶ MY CLEARANCE INFORMATION <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideFORMFullView()' style='font-weight:bold'> ✕ </a> </div> </div> <!--BODY--> <div style="padding:10px;width:100%;height:670px;margin:0px;border;1px solid black;background:white;border-bottom:1px solid gray"> <p style="border-radius:0px;float:right;width:100%;padding:5px;padding-top:0px;height:40px">✎   MY CLEARANCE SIGNATORY LISTS</p> <div id="clearanceSignatoryList" style="width:100%;height:600px;background:#fbfce0;margin-top:10px;border:1px solid gray;overflow:auto"> </div> </div> </div> <!--===================================================== --> <!--===========EDIT NEW CLEARANCE HEADER======================== --> <div id="FORMAddNewAdminEdit" style="display:none;width:1000px;height:481px;background:#fce4a4;border:1px solid black;position:absolute;top:150px;left:300px;"> <div class='bgColor' style='vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-size:16px;font-weight:bold;color:black;text-align:left;'> ☶ UNPOSTED CLEARANCE FORM: <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideAdminFormEdit()' style='font-weight:bold'> ✕ </a> </div> </div> <!--BODY--> <div style="padding:10px;width:100%;height:450px;margin:0px;border;1px solid black;background:white;border-bottom:1px solid gray"> <p style="border-radius:0px;float:right;width:100%;padding:10px;padding-top:5px;height:40px">❖   HR APPROVAL MODE</p> <div id="EditResult" style="width:100%;height:320px;background: #fce4a4 ;margin-top:10px;border:1px solid gray;overflow:auto"> </div> <input type="submit" id="postNewClearanceForm" value="⚐   AUTHORIZED FOR ROUTING" STYLE="padding:5px;height:40px;width:250px;float:right;margin-right:0px;font-familu:Calibri;font-size:14px"> <button id='disApprovedClearance' type="submit" onclick='hideAdminFormEdit()'STYLE="padding:5px;height:40px;width:250px;float:right;margin-right:20px;margin-top:10px;font-familu:Calibri;font-size:14px">✖   CANCEL CLEARANCE FORM </button> <button id='loadClearanceFormA' type="submit" onclick='hideAdminFormEdit()'STYLE="padding:5px;height:40px;width:250px;float:right;margin-right:20px;margin-top:10px;font-familu:Calibri;font-size:14px">&check;   VIEW CLEARANCE SIGNATORY </button> </div> </div> <!--===================================================== --> <!--===========EDIT NEW CLEARANCE HEADER======================== --> <div id="FORMOfficeApproval" style="display:none;width:1000px;height:521px;background:#fce4a4;border:1px solid black;position:absolute;top:150px;left:300px;"> <div class='bgColor' style='vertical-align:top;height:30px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Verdana;font-size:16px;font-weight:bold;color:black;text-align:left;'> ☶ PROCESS CLEARANCE APPROVAL: <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideOfficerApproval()' style='font-weight:bold'> ✕ </a> </div> </div> <!--BODY--> <div style="padding:10px;width:100%;height:490px;margin:0px;border;1px solid black;background:white;border-bottom:1px solid gray"> <div id="ApprovalResult" style="width:100%;height:380px;background: #fff ;margin-top:5px;border:1px solid gray"> </div> <div style='background:lightgray;width:50%;float:left'> <p style='float:left;margin:2px;width:70%;background:lightgray;padding:2px;margin-left:0px;font-family:Calibri;font-size:15px;margin-bottom:0px'>Action Slip:</p> <p style='float:left;margin:2px;width:29%;background:lightgray;padding:2px;margin-left:0px;font-family:Calibri;font-size:15px;margin-bottom:0px'>Amount:</p> <textarea type='text' rows='3' id='ActionSlip' placeholder='Action Slip Notice' style='float:left;height:54px;float:left;width:70%;margin:5px;margin:0px;border:1px solid gray;padding:3px;font-size:12px;color:black;background:white'></textarea> <input type="text" id='ActionSlipAmount' placeholder='0.00'style='float:left;width:29%;background:white;height:54px;margin-top:0px;margin-left:2px;font-family:Calibri;font-size:24px;color:red'> </div> <div style='background:white;width:50%;float:left;height:85px;padding-right:10px'><br> <input type="submit" id="processClearanceApproval" value="👌   CLEARED" STYLE="padding:5px;height:40px;width:130px;float:right;margin-right:0px;font-familu:Calibri;font-size:12px"> <button id='actionSlipSubmit' type="submit" onclick='hideAdminFormEdit()'STYLE="padding:5px;height:40px;width:150px;float:right;margin-right:20px;margin-top:10px;font-familu:Calibri;font-size:12px">💬   SEND ACTION SLIP </button> <button id='viewClearanceForm' type="submit" onclick='hideAdminFormEdit()' STYLE="padding:5px;height:40px;width:130px;float:right;margin-right:20px;margin-top:10px;font-familu:Calibri;font-size:12px">📂   VIEW FORM </button> </div> </div> </div> <!--===================================================== --> <!--===================================================== --> <div class="formSearch" style="width:50%"> <input type="text" id="SearchText" placeholder="☶      Search Record..." style="margin:2px;width:55%;padding:10px;font-family:Calibri;font-size:16px;color:blue;height:40px;float:left"> <input type="submit" id="goSearchRecord" value="SEARCH RECORD       🏸" style="margin:2px;width:38%;padding:10px;font-family:Calibri;font-size:16px;color:black;font-weight:bold;height:40px;float:left;"> </div> <div class="formSearch" style="width:40%;float:right;text-align:center"><p class="menuTitle" style="border-radius:20px;float:right;width:100%;padding:5px;height:40px">☸     CLEARANCE FOR MY APPROVAL</p></div> <div id="templateContent" style="float:left;width:100%;padding:0px;border-top:0px solid orange;border-bottom:0px solid orange;margin-top:0px;max-height:500px;min-height:550px;overflow:auto"> <!-------------------------------FOR HR APPROVAL--------------------------------------> <div style="float:left;width:33%;padding:0px;border-top:0px solid orange;border-bottom:0px solid orange;margin-top:0px;max-height:250px;min-height:250px;overflow:auto;border:1px solid lightgray;border-right:0px solid lightgray;margin-right:3px"> <div style='height:30px;padding:0px;margin:0px;width:100%;background:#8aecf8;font-family:Calibri;font-size:14px;border:1px solid gray'> <div style='padding:3px;margin:0px;width:70%;background:#8aecf8;font-family:Calibri;font-size:14px;float:left;color:black'>✩   FOR ROUTING APPROVAL</div> <button id='PostButton' style="border-radius:0px; border:0px solid white;display:block;margin:0px;width:10%;padding:2px;height:28px;font-family:Calibri;font-size:16px;float:right;border-left:1px solid gray">✔</button> </div> <div id="templateContentSubB"> <?php // echo "<table>"; echo "<thead>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>DATE</th>"; echo "<th style='width:50px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>REC ID.</th>"; echo "<th style='width:220px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>EMPLOYEE NAME</th>"; echo "<th style='width:110px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>STATUS</th>"; //echo "<th style='width:220px;border:0px solid white;font-weight:normal'>Action</th>"; echo "</thead>"; $getActiveClearance = mysql_query("SELECT FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FOR HR APPROVAL' AND `cl_status`='1' AND `cl_h_comp_id` = '$comID' AND `cl_hr_approval_id` = '$userID' AND `cl_hr_approval_timestamp`='' ORDER BY `cl_h_date_created` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $uID = $row['cl_h_emp_id']; $pID = $row['cl_emp_position']; $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0); $count = $count + 1; ?><tr onclick="javascript:showClearanceForAuthorization(this);" ><?php echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($row['cl_h_date_created'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($row['h_id'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-size:12px;color:blue;font-weight:normal'>"; if($row['cl_h_hr_approval']==='FOR HR APPROVAL'){ echo "UNPOSTED"; } if($row['cl_h_hr_approval']==='FOR ENDORSEMENT'){ echo "CLEARED"; } if($row['cl_h_hr_approval']==='FINAL APPROVAL'){ echo "GM APPROVAL"; } echo "</td>"; echo "</tr>"; } echo "</table>"; ?> </div> </div> <!-------------------------------FOR ENDORSEMENT--------------------------------------> <div style="float:left;width:33%;padding:0px;border-top:0px solid orange;border-bottom:0px solid orange;margin-top:0px;max-height:250px;min-height:250px;overflow:auto;border:1px solid lightgray;border-right:0px solid lightgray;margin-right:3px"> <div style='height:30px;padding:0px;margin:0px;width:100%;background:#8aecf8;font-family:Calibri;font-size:14px;border:1px solid gray'> <div style='padding:3px;margin:0px;width:70%;background:#8aecf8;font-family:Calibri;font-size:14px;float:left;color:black'>✩   FOR ENDORSEMENT</div> <button id='myEndorsementButton' style="border-radius:0px; border:0px solid white;display:block;margin:0px;width:10%;padding:2px;height:28px;font-family:Calibri;font-size:16px;float:right;border-left:1px solid gray">✔</button> </div> <div id="ContentEndorsement"> <?php // echo "<table>"; echo "<thead>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>DATE</th>"; echo "<th style='width:50px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>REC ID.</th>"; echo "<th style='width:210px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>EMPLOYEE NAME</th>"; echo "<th style='width:110px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>STATUS</th>"; //echo "<th style='width:220px;border:0px solid white;font-weight:normal'>Action</th>"; echo "</thead>"; $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FOR ENDORSEMENT' AND `hdr_status`='2' AND `cl_h_comp_id` = '$comID' AND `cl_recommender_a_id` = '$userID' AND `cl_recommender_a_timestamp`='' \|\| `cl_h_hr_approval`='FOR ENDORSEMENT' AND `hdr_status`='2' AND `cl_h_comp_id` = '$comID' AND `cl_recommender_b_id` = '$userID' AND `cl_recommender_b_timestamp`='' ORDER BY `cl_h_date_created` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $uID = $row['cl_h_emp_id']; $pID = $row['cl_emp_position']; $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0); $count = $count + 1; ?><tr onclick="javascript:showEndorsement(this);"><?php echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($row['cl_h_date_created'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($row['h_id'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-size:12px;color:blue;font-weight:normal'>"; if($row['cl_h_hr_approval']=='For HR Approval'){ echo "UNPOSTED"; } if($row['cl_h_hr_approval']=='FOR ENDORSEMENT'){ echo "CLEARED"; } if($row['cl_h_hr_approval']=='FINAL APPROVAL'){ echo "GM APPROVAL"; } echo "</td>"; echo "</tr>"; } echo "</table>"; ?> </div> </div> <!-------------------------------FOR FINAL APPROVAL---- JHOANNA---------------------------------> <div style="float:left;width:33%;padding:0px;border-top:0px solid orange;border-bottom:0px solid orange;margin-top:0px;max-height:250px;min-height:250px;overflow:auto;border:1px solid lightgray"> <div style='height:30px;padding:0px;margin:0px;width:100%;background:#8aecf8;font-family:Calibri;font-size:14px;border:1px solid gray'> <div style='padding:3px;margin:0px;width:50%;background:#8aecf8;font-family:Calibri;font-size:14px;float:left;color:black'>✩   FOR FINAL APPROVAL</div> <button id='myFinalApprovalButton' style="border-radius:0px; border:0px solid white;display:block;margin:0px;width:10%;padding:2px;height:28px;font-family:Calibri;font-size:16px;float:right;border-left:1px solid gray">✔</button> </div> <div id="ContentFinalApproval"> <?php // echo "<table>"; echo "<thead>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>DATE</th>"; echo "<th style='width:50px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>REC ID.</th>"; echo "<th style='width:220px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>EMPLOYEE NAME</th>"; echo "<th style='width:110px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>STATUS</th>"; //echo "<th style='width:220px;border:0px solid white;font-weight:normal'>Action</th>"; echo "</thead>"; $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4' AND `cl_approver_id` = '$userID' \|\| `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4' AND `cl_approver_id_b` = '$userID' ORDER BY `cl_h_date_created` DESC"); //$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4' AND `cl_approver_id` = '$userID' ORDER BY `cl_h_date_created` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $uID = $row['cl_h_emp_id']; $pID = $row['cl_emp_position']; $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0); $count = $count + 1; ?><tr onclick="javascript:showApproval(this);"><?php echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($row['cl_h_date_created'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($row['h_id'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-size:12px;color:blue;font-weight:normal'>"; if($row['cl_h_hr_approval']=='For HR Approval'){ echo "UNPOSTED"; } if($row['cl_h_hr_approval']=='FOR ENDORSEMENT'){ echo "CLEARED"; } if($row['cl_h_hr_approval']=='FINAL APPROVAL'){ echo "FOR APPROVAL"; } echo "</td>"; echo "</tr>"; } echo "</table>"; ?> </div> </div> <!-------------------------------TABLE FOR CLEARANCE OFFICERS APPROVAL-------AEEE-------------------------------> <!-------------------------------TABLE FOR CLEARANCE OFFICERS APPROVAL--------------------------------------> <div style="margin-top:1px;float:left;width:100%;height:35px;padding:5px;border:0px solid #3cd408" class="grayBG"> <button id='ApproveButton' style="border-radius:0px; border:0px solid white;display:block;margin:0px;width:30%;padding:2px;height:28px;font-family:Calibri;font-size:16px;float:right;border-left:1px solid gray">✔   PROCESS EMPLOYEE CLEARANCE</button> </div> <div id="templateContentSubA" style="float:left;width:100%;padding:0px;border-top:0px solid orange;border-bottom:0px solid orange;margin-top:0px;max-height:250px;min-height:300px;overflow:auto"> <?php // echo "<table>"; echo "<thead>"; echo "<th style='width:50px;border:0px solid white;font-weight:normal'>NO.</th>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal'>REC ID.</th>"; echo "<th style='width:100px;border:0px solid white;font-weight:normal'>DATE.</th>"; echo "<th style='width:100px;border:0px solid white;font-weight:normal'>EMP. ID.</th>"; echo "<th style='width:200px;border:0px solid white;font-weight:normal'>EMPLOYEE NAME</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>POSITION</th>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal'>TYPE</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>STATUS</th>"; echo "<th style='width:200px;border:0px solid white;font-weight:normal'>INSTRUCTION</th>"; //echo "<th style='width:220px;border:0px solid white;font-weight:normal'>Action</th>"; echo "</thead>"; //$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`!='For HR Approval' AND `cl_status`='1' AND `cl_h_comp_id` = '$comID' ORDER BY `cl_h_date_created` DESC"); 090434218-96 $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_data` WHERE `cl_approver_id_a`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' \|\| `cl_approver_id_b`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' ORDER BY `cl_id` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $keyCodeID = $row['key_code']; $headerID = mysql_result(mysql_query("SELECT `h_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $empID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $pID = mysql_result(mysql_query("SELECT `cl_emp_position` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $clCreatedDate = mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $clRand = mysql_result(mysql_query("SELECT `cl_rank` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $clStatus = mysql_result(mysql_query("SELECT `cl_h_hr_approval` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0); $chkIfIamApprover = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `cl_approver_id_a` ='$userID' AND `key_code` = '$keyCodeID' AND `cl_approved_by_id`='0' \|\| `cl_approver_id_b` ='$userID' AND `key_code` = '$keyCodeID' AND `cl_approved_by_id` ='0'"),0); if($chkIfIamApprover > 0){ $count = $count + 1; ?><tr onclick="javascript:showClearanceApproval(this);" onDblclick="javascript:showFORMClearanceFinalApproval(this);" ><?php echo "<td style=';border:0px solid white;cursor:pointer'>".$headerID."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($row['cl_id'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".$clCreatedDate."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uEMPID)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uPosition)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($clRand)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-size:11px;color:blue;font-weight:normal'>".strtoupper($clStatus)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-size:11px;color:blue;font-weight:normal'>For clearing officer approval</td>"; echo "</tr>"; } } echo "</table>"; ?> </div> </div> <input type="text" id="activeRecord" readonly style="background:#f4fcb6;border:0px solid white;float:left;width:100%;font-family:Calibri;font-size:14px;font-weight:normal;color:black;padding:5px;text-align:left"> </body> </html>

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