File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_template_view_BACKUP.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(); });F $('.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 showViewTemplate(){ var diva=document.getElementById("viewTemplateForm"); if (diva.style.display == 'none') { diva.style.display = ''; } else { diva.style.display = 'none'; } } function hideAssignMsg(){ $("#saveMessage").fadeOut(3000); }; function showAssignMsg(){ $("#saveMessage").fadeIn(); }; function invHideAssignMsg(){ $("#invMessage").fadeOut(3000); }; function invShowAssignMsg(){ $("#invMessage").fadeIn(); }; </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"> $(document).ready(function(){ $(document).ajaxStart(function(){ $("#wait").css("display", "block"); }); $(document).ajaxComplete(function(){ $("#wait").css("display", "none"); }); //============================================================================================================================================ //============================================================================================================================================ $("#saveCLTemplate").click(function(){ var AccountOfficer= $("#AccountOfficer").val(); var PayrollOfficer= $("#PayrollOfficer").val(); var TreasuryOfficer= $("#TreasuryOfficer").val(); var LegalOfficer= $("#LegalOfficer").val(); var MyUserID= $("#addByUID").val(); var addCompID= $("#addCompID").val(); var CLTemplateName= $("#CLTemplateName").val(); var CLCoverage= $("#CLCoverage").val(); var CLRecommendB= $("#CLRecommendB").val(); var CLRecommendA= $("#CLRecommendA").val(); var CLApproving= $("#CLApproving").val(); var CLApprovingB= $("#CLApprovingB").val(); var CLRank= $("#CLRank").val(); var hrApprovingOfficer= $("#hrApprovingOfficer").val(); if(selectedTemplate==''){ alert('No record is selected.'); return false; } if(CLTemplateName==''){ alert('Invalid Template Name.'); return false; } if(CLRecommendA==''){ alert('Recommending Officer is required'); return false; } if(CLRecommendB==''){ alert('Recommending Officer is required'); return false; } if(CLApproving==''){ alert('Aproiving Officer is required'); return false; } if(hrApprovingOfficer==''){ alert('Authorizing HR Officer is required'); return false; } $.ajax({ url: "CL_Save_New_Template.php", type: "POST", async: false, data: { "AccountOfficer": AccountOfficer, "PayrollOfficer": PayrollOfficer, "TreasuryOfficer": TreasuryOfficer, "LegalOfficer": LegalOfficer, "CLApprovingB": CLApprovingB, "addCompID": addCompID, "hrApprovingOfficer": hrApprovingOfficer, "CLRecommendB": CLRecommendB, "CLRecommendA": CLRecommendA, "CLApproving": CLApproving, "MyUserID": MyUserID, "CLTemplateName": CLTemplateName, "CLCoverage": CLCoverage, "CLRank": CLRank, "done": 1 }, success: function(d){ $("#templateContent").html(d); hideTemplateForm(); } }) }); //============================================================================================================================================ //============================================================================================================================================ $("#saveCLTemplateEdit").click(function(){ var CLTemplateNameEdit= $("#CLTemplateNameEdit").val(); var CLRecommendAEdit= $("#CLRecommendAEdit").val(); var CLRecommendBEdit= $("#CLRecommendBEdit").val(); var CLApprovingEdit= $("#CLApprovingEdit").val(); var hrApprovingOfficerEdit= $("#hrApprovingOfficerEdit").val(); var AccountOfficerEdit= $("#AccountOfficerEdit").val(); var PayrollOfficerEdit= $("#PayrollOfficerEdit").val(); var TreasuryOfficerEdit= $("#TreasuryOfficerEdit").val(); var LegalOfficerEdit= $("#LegalOfficerEdit").val(); var selectedTemplate = $("#selectedTemplate").val(); var MyUserID= $("#addByUID").val(); var addCompID= $("#addCompID").val(); var CLCoverageEdit= $("#CLCoverageEdit").val(); var CLApprovingBEdit= $("#CLApprovingBEdit").val(); var CLRankEdit= $("#CLRankEdit").val(); if(selectedTemplate==''){ alert('No record is selected'); return false; } if(CLRankEdit==''){ alert('Position Rank is Required'); return false; } if(CLTemplateNameEdit==''){ alert('Invalid Template Name.'); return false; } if(CLRecommendAEdit==''){ alert('Recommending Officer is required'); return false; } if(CLRecommendBEdit==''){ alert('Recommending Officer is required'); return false; } if(CLApprovingEdit==''){ alert('Aproiving Officer is required'); return false; } if(hrApprovingOfficerEdit==''){ alert('Approving HR Officer is required'); return false; } if(AccountOfficerEdit==''){ alert('Accounting Officer is required'); return false; } if(PayrollOfficerEdit==''){ alert('Payroll Officer is required'); return false; } if(TreasuryOfficerEdit==''){ alert('Treasury Officer is required'); return false; } if(LegalOfficerEdit==''){ alert('Legal Officer is required'); return false; } ShowUploadBar(); $.ajax({ url: "CL_Save_New_TemplateEdit.php", type: "POST", async: false, data: { "AccountOfficerEdit": AccountOfficerEdit, "PayrollOfficerEdit": PayrollOfficerEdit, "TreasuryOfficerEdit": TreasuryOfficerEdit, "LegalOfficerEdit": LegalOfficerEdit, "CLApprovingBEdit": CLApprovingBEdit, "addCompID": addCompID, "hrApprovingOfficerEdit": hrApprovingOfficerEdit, "CLRecommendBEdit": CLRecommendBEdit, "CLRecommendAEdit": CLRecommendAEdit, "CLApprovingEdit": CLApprovingEdit, "selectedTemplate": selectedTemplate, "MyUserID": MyUserID, "CLTemplateNameEdit": CLTemplateNameEdit, "CLCoverageEdit": CLCoverageEdit, "CLRankEdit": CLRankEdit, "done": 1 }, success: function(d){ hideEditTemplateForm(); ShowUploadBar(); $("#templateContent").html(d); } }) }); //============================================================================================================================================ //============================================================================================================================================ $("#openTemplateForm").click(function(){ var addCompID= $("#addCompID").val(); var addByUID = $("#addByUID").val(); var selectedTemplate = $("#selectedTemplate").val(); //XX var rank= $("#rank").val(); if(rank == ""){ alert('Please select record.'); return false; } if(selectedTemplate == ""){ alert('Please select record.'); return false; } ShowUploadBar(); showTemplateEditForm(); $.ajax({ url: "CL_load_Template.php", type: "POST", async: false, data: { "rank": rank, "selectedTemplate": selectedTemplate, //arnel endaya "addByUID": addByUID, "addCompID": addCompID, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#templateData").html(d); ShowUploadBar(); } }) }); //============================================================================================================================================ //============================================================================================================================================ $("#deleteTemplate").click(function(){ var selectedTemplate = $("#selectedTemplate").val(); if(selectedTemplate == ""){ alert('Please select record.'); 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_DELETE_SELECTED_TEMPLATE.php", type: "POST", async: false, data: { "selectedTemplate": selectedTemplate, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#templateContent").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) } }); //============================================================================================================================================ //============================================================================================================================================ }); function hideTemplateForm(){ $("#AddNewInventoryForm").fadeOut(500); }; function showTemplateForm(){ $("#AddNewInventoryForm").fadeIn(500); }; function hideEditTemplateForm(){ $("#editTemplate").fadeOut(500); }; function editTemplateForm(){ $("#editTemplate").fadeIn(500); }; function hideTemplateEditForm(){ $("#viewTemplateForm").fadeOut(500); }; function showTemplateEditForm(){ $("#viewTemplateForm").fadeIn(500); }; function showSelectedBrand(row) { var x=row.cells; document.getElementById("selectedTemplate").value = x[0].innerHTML; document.getElementById("selRank").value = "For " + x[3].innerHTML + " " + x[1].innerHTML; document.getElementById("activeRecord").value = "SELECTED: " + x[3].innerHTML + " TEMPLATE " + " (Record # " + x[0].innerHTML +")"; document.getElementById("rank").value = x[3].innerHTML; document.getElementById("CLTemplateNameEdit").value = x[2].innerHTML; } function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script> <style> 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; } </style> </head> <body style="font-family:Verdana;color:#aaaaaa;background:white"> <!--===================================================== --> <!--===========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="selectedTemplate"> <input type="hidden" id="rank"> <!--#########################################################################--> <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> <!--#########################################################################--> <div id="viewTemplateForm" style="display:none;width:1200px;height:700px;background:white;border:1px solid black;position:absolute;top:90px;left:50px;"> <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:normal;color:#043062;text-align:left;'> ☶ EDIT CLEARANCE TEMPLATE <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideTemplateEditForm()' style='font-weight:bold'> ✕ </a> </div> </div> <!--BODY--> <div style="padding:10px;width:100%;height:600px;margin:0px;border;1px solid black;background:white;border-bottom:1px solid gray"> <div class="formLabel" style="margin:0px;font-family:Calibri;font-size:28px;font-weight:bold;width:100%;text-align:center;border:0px solid blue;padding:0px"> <input type="text" style='font-weight:normal;border:0px solid red;background:white;float:center;width:100%;text-align:center;margin:0px;font-family:Calibri;font-size:16px;font-weight:normal' readonly id='selRank'></label> </div> <div id="templateData" style="background:white;width:100%;border-top:1px solid black;height:590px;float:left;overflow:auto"> </div> </div> </div> <!--===================================================== --> <!--===========CONFIRM DELETE BOX======================== --> <div id="deleteBoxYesNo" style="display:none;width:500px;height:350px;background:white;border:1px solid black;position:absolute;top:150px;left:300px;"> </div> <!--#########################################################################--> <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>Loading...<center></div> </div> <!--#########################################################################--> <!--###############################################################################################################--> <!--###############################################################################################################--> <!--===========ADD TEMPLATE TITLE======================== --> <div id="AddNewInventoryForm" style="display:none;width:600px;height:600px;background:white;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:normal;color:#043062;text-align:left;'> ☶ CREATE NEW TEMPLATE <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideTemplateForm()' style='font-weight:bold'> ✕ </a> </div> </div> <div style="padding:5px;width:100%;height:470px;margin:0px;border;1px solid black;background:white;border-bottom:1px solid gray"> <p>☶ TEMPLATE INFORMATION</p> <table> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">TEMPLATE NAME:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <input type='text' id="CLTemplateName" style='margin:0px;text-align:left;background:white'> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">CLEARANCE COVERAGE:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLCoverage" style='margin:0px;'> <option value="CO">Company Level</option> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">APPLICABLE RANK/POSITION:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLRank" style='margin:0px;'> <option value="RNF">Rank and File</option> <option value="MGR">Supervisors/Managers</option> <option value="EXE">Executives</option> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">RECOMMENDING OFFICER #1:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLRecommendA" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".strtoupper($soRow['u_lname']).", ".strtoupper($soRow['u_fname'])." - ".strtoupper($soRow['u_position'])."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">RECOMMENDING OFFICER #2:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLRecommendB" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">APPROVING OFFICER I:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLApproving" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">APPROVING OFFICER II:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLApprovingB" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">AUTHORIZING HR OFFICER:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="hrApprovingOfficer" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">PAYROLL OFFICER:</b></td> <td style="width:60%;padding:0px;border:0px solid white;background:white"> <select id="PayrollOfficer" style='margin:2px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">ACCOUNTING OFFICER:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="AccountOfficer" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">TREASURY OFFICER:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="TreasuryOfficer" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:gray"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"> <b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">LEGAL OFFICER:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="LegalOfficer" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 AND `u_status`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:gray"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"> </td> <td style="width:60%;padding:0px;border:0px solid white;background:white"> </td> </tr> <tr style="border:0px solid white;background:transparent"> <td colspan="2" style="width:30%;padding:0px;border:0px solid gray;background:transparent"><br><br> <b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal"> <button id="saveCLTemplate" style='float:right;padding:15px;padding-left:25px;padding-right:25px;border-radius:5px'>✚     SAVE TEMPLATE</button> <button onclick='hideTemplateForm()' style='float:right;padding:15px;padding-left:25px;padding-right:25px;margin-right:10px;border-radius:5px'>✘     CLOSE WINDOW</button> </td> </tr> </table> </div> <!--FOOTER / MESSAGE <div id = "saveTemplateHeaderMSH" style="width:100%;height:38px;margin:0px;border;1px solid red;background:lightgray;padding:0px;font-family:Calibri;font-size:14px;color:black"> <p style="margin:0px;padding:5px;font-family:Calibri;font-size:16px;font-weight:normal;color:gray">✏ UNSAVED RECORD </p> </div>--> </div> <!--###############################################################################################################--> <!--###############################################################################################################--> <!--===========EDIT TEMPLATE TITLE======================== --> <div id="editTemplate" style="display:none;width:600px;height:600px;background:white;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:normal;color:#043062;text-align:left;'> ☶ EDIT TEMPLATE <div style='float:right;font-family:Calibri;font-size:18px;'> <a href='#' onclick='hideEditTemplateForm()' style='font-weight:bold'> ✕ </a> </div> </div> <div style="padding:5px;width:100%;height:470px;margin:0px;border;1px solid black;background:white;border-bottom:1px solid gray"> <p>☶ TEMPLATE INFORMATION</p> <table> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">TEMPLATE NAME:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <input type='text' id="CLTemplateNameEdit" style='margin:0px;text-align:left;background:lightgray;font-family:Calibri;font-size:18px;font-weight:bold'> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">CLEARANCE COVERAGE:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLCoverageEdit" style='margin:0px;'> <option value="CO">Company Level</option> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">APPLICABLE RANK/POSITION:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLRankEdit" style='margin:0px;'> <option value="RNF">Rank and File</option> <option value="MGR">Supervisors/Managers</option> <option value="EXE">Executives</option> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">RECOMMENDING OFFICER #1:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLRecommendAEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">RECOMMENDING OFFICER #2:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLRecommendBEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">APPROVING OFFICER I:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLApprovingEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">APPROVING OFFICER II:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="CLApprovingBEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">AUTHORIZING HR OFFICER:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="hrApprovingOfficerEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">PAYROLL OFFICER:</b></td> <td style="width:60%;padding:0px;border:0px solid white;background:white"> <select id="PayrollOfficerEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">ACCOUNTING OFFICER:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="AccountOfficerEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:white"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"><b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">TREASURY OFFICER:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="TreasuryOfficerEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:gray"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"> <b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal">LEGAL OFFICER:</b></td> <td style="width:60%;padding:1px;border:0px solid white;background:white"> <select id="LegalOfficerEdit" style='margin:0px;'> <?php $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver`=1 ORDER BY `u_lname` ASC"); echo "<option value=''>N/A</option>"; while($soRow = mysql_fetch_array($getApproverList)){ echo "<option value='".$soRow['u_id']."'>".$soRow['u_lname'].", ".$soRow['u_fname']." - ".$soRow['u_position']."</option>"; } ?> </select> </td> </tr> <tr style="border:1px solid gray;background:gray"> <td style="width:30%;padding:0px;border:1px solid gray;background:white"> </td> <td style="width:60%;padding:0px;border:0px solid white;background:white"> </td> </tr> <tr style="border:0px solid red;background:transparent"> <td colspan="2" style="width:30%;padding:0px;border:0px solid gray;background:transparent"> <b style="padding:5px;font-family:Calibri;font-size:14px;color:black;font-weight:normal"><br><br> <button id="saveCLTemplateEdit" style='float:right;padding:15px;padding-left:25px;padding-right:25px;border-radius:5px'>✚     SAVE TEMPLATE</button> <button onclick='hideEditTemplateForm()' style='float:right;padding:15px;padding-left:25px;padding-right:25px;margin-right:10px;border-radius:5px'>✘     CLOSE WINDOW</button> </td> </tr> </table> </div> <!--FOOTER / MESSAGE <div id = "saveTemplateHeaderMSH" style="width:100%;height:38px;margin:0px;border;1px solid red;background:lightgray;padding:0px;font-family:Calibri;font-size:14px;color:black"> <p style="margin:0px;padding:5px;font-family:Calibri;font-size:16px;font-weight:normal;color:gray">✏ UNSAVED RECORD </p> </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="float:right;text-align:center"><p class="menuTitle" style="border-radius:20px;float:right;width:100%;padding:5px;height:40px">☸     CLEARANCE TEMPLATE MODULE</p></div>; <div style="margin-top:2px;float:left;width:100%;height:40px;padding:8px;border:0px solid #3cd408" class="grayBG"> <!--<b id="createTemplate" class="pageMenu" onclick="showTemplateForm()">✚ CREATE TEMPLATE</b> <b id="openTemplateForm" class="pageMenu">✐ UPDATE SIGNATORIES</b> <b id="deleteTemplate" class="pageMenu">✘ DELETE TEMPLATE</b>--> <button id='openTemplateForm' style="border-radius:0px; border:0px solid white;display:block;margin:0px;width:200px;padding:2px;height:28px;font-family:Calibri;font-size:16px;float:right;border-left:1px solid gray">✐   UPDATE SIGNATORIES</button> <button id='deleteTemplate' style="border-radius:0px; border:0px solid white;display:block;margin:0px;width:200px;padding:2px;height:28px;font-family:Calibri;font-size:16px;float:right;border-left:1px solid gray">✘   DELETE TEMPLATE</button> <button id='createTemplate' onclick="showTemplateForm()" style="border-radius:0px; border:0px solid white;display:block;margin:0px;width:200px;padding:2px;height:28px;font-family:Calibri;font-size:16px;float:right;border-left:1px solid gray">✚   CREATE TEMPLATE</button> <button id='editTemplate' onclick="editTemplateForm()" style="border-radius:0px; border:0px solid white;display:block;margin:0px;width:200px;padding:2px;height:28px;font-family:Calibri;font-size:16px;float:right;border-left:1px solid gray"> ✎   EDIT TEMPLATE</button> </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:400px;overflow:auto"> <?php $gtTempHeader = mysql_query("SELECT * FROM `cl_template_name` WHERE `cl_template_status` = 1 AND `cl_comp_id`='$comID'ORDER BY `id` ASC"); echo "<table style='width:150%'>"; echo "<thead>"; echo "<th style='width:30px;border:0px solid white'>No.</th>"; echo "<th style='width:120px;border:0px solid white'>LEVEL</th>"; echo "<th style='width:220px;border:0px solid white'>DESCRIPTION</th>"; echo "<th style='width:30px;border:0px solid white'>COVERAGE</th>"; echo "<th style='width:150px;border:0px solid white'>RECOMMENDER #1</t>"; echo "<th style='width:150px;border:0px solid white'>RECOMMENDER #2</t>"; echo "<th style='width:150px;border:0px solid white'>APPROVER #1</t>"; echo "<th style='width:150px;border:0px solid white'>APPROVER #2</t>"; echo "<th style='width:150px;border:0px solid white'>AUTHORIZING HR</t>"; echo "<th style='width:150px;border:0px solid white'>PAYROLL OFFICER</t>"; echo "<th style='width:150px;border:0px solid white'>ACCOUNTING OFFICER</t>"; echo "<th style='width:150px;border:0px solid white'>TREASURY OFFICER</t>"; echo "<th style='width:150px;border:0px solid white'>LEGAL OFFICER</t>"; ECHO "</thead>"; while($row=mysql_fetch_array($gtTempHeader)){ $rcaF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcaL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcbF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $rcbL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $aprF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_hr_approval_id']."'"),0); $aprHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_hr_approval_id']."'"),0); $aprHRFB = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer_b']."'"),0); $aprHRLB = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer_b']."'"),0); $payHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['payroll_officer']."'"),0); $payHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['payroll_officer']."'"),0); $accHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['accounting_officer']."'"),0); $accHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['accounting_officer']."'"),0); $treHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['treasury_officer']."'"),0); $treHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['treasury_officer']."'"),0); $legHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['legal_officer']."'"),0); $legHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['legal_officer']."'"),0); ?><tr onclick="javascript:showSelectedBrand(this);"><?php echo "<td style='cursor:pointer;border:0px solid white'>".$row['id']."</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; if($row['cl_template_tag']==='CO'){ echo "COMPANY LEVEL"; }else{ echo "AUTOHUB LEVEL"; } echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>".$row['cl_template_name']."</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $row['cl_template_rank']; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $rcaL .', '.$rcaF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $rcbL .', '.$rcbF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $aprL .', '.$aprF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $aprHRLB .', '.$aprHRFB; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $aprHRL .', '.$aprHRF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $payHRL .', '.$payHRF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $accHRL .', '.$accHRF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $treHRL .', '.$treHRF; echo"</td>"; echo "<td style='cursor:pointer;border:0px solid white'>"; echo $legHRL .', '.$legHRF; echo"</td>"; echo "</tr>"; } echo "</table>"; ?> <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"> </div> </body> </html>

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