File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_CLEARANCE_HISTORY_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'; } } </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"); }); / //============================================================================================================================================ //============================================================================================================================================ $("#goSearchRecord").click(function(){ var SearchText = $("#SearchText").val(); var addByUID = $("#addByUID").val(); var NewCLRecordID = $("#NewCLRecordID").val(); var NewCLRecordEmpID = $("#NewCLRecordEmpID").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_HISTORY.php", type: "POST", async: false, data: { "SearchText": SearchText, "addByUID": addByUID, "NewCLRecordID": NewCLRecordID, "NewCLRecordEmpID": NewCLRecordEmpID, "done": 1 }, success: function(d){ //invShowAssignMsg(); $("#templateContent").html(d); //invHideAssignMsg(); //$('#searchText').val(''); . } }) //} }); //============================================================================================================================================ //============================================================================================================================================ }); function hideAdminForm(){ $("#FORMAddNewAdmin").fadeOut(500); }; function showAdminForm(){ $("#FORMAddNewAdmin").fadeIn(500); }; function hideAdminFormEdit(){ $("#FORMAddNewAdminEdit").fadeOut(500); }; function showAdminFormEdit(){ $("#FORMAddNewAdminEdit").fadeIn(500); }; function showPostButton(){ $("#PostButton").fadeOut(200); }; function hidePostButton(){ $("#PostButton").fadeIn(200); }; function showAdminAccess(row) { $("#PostButton").fadeIn(); $("#ApproveButton").fadeOut(); var x=row.cells; document.getElementById("NewCLRecordID").value = x[0].innerHTML; document.getElementById("activeRecord").value = "SELECTED RECORD: " + x[3].innerHTML + " (Record # " + x[0].innerHTML +")"; document.getElementById("NewCLRecordEmpID").value = x[2].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"> <!--===================================================== --> <!--===========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"> <!--===================================================== --> <!--===================================================== --> <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 TRANSACTION HISTORY</p></div> <div style="margin-top:2px;float:left;width:100%;height:40px;padding:8px;border:0px solid #3cd408" class="grayBG"> <b style="background:transparent;font-family:Calibri;font-weight:bold;font-size:18px;color:black">☲   MY CLEARANCE ACTIVITY HISTORY</b> </div> <div id="templateContent" style="float:left;width:100%;padding:0px;border-top:0px solid orange;border-bottom:0px solid orange;margin-top:0px;height:600px;min-height:400px;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'>DATE RECEIVED</th>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal'>DATE SIGNED</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>EMPLOYEE NAME</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>CREATED BY</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>AUTHORIZED BY</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>ENDORSED BY #1</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>ENDORSED BY #2</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>APPROVED BY</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>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_hr_approval_id` ='$userID' \|\| `cl_recommender_a_id` ='$userID' \|\| `cl_approver_id` ='$userID' \|\| `cl_recommender_b_id` ='$userID' ORDER BY `h_id` DESC"); $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_data` WHERE `cl_approved_by_id` ='$userID' ORDER BY `cl_id` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $uID = $row['cl_h_emp_id']; $kCode=$row['key_code']; $pID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $createdBy = mysql_result(mysql_query("SELECT `cl_created_by` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $AuthorizedBy = mysql_result(mysql_query("SELECT `cl_hr_approval_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $AuthorizedTS = mysql_result(mysql_query("SELECT `cl_hr_approval_timestamp` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $EndorsedByA = mysql_result(mysql_query("SELECT `cl_recommender_a_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $EndorsedByATS = mysql_result(mysql_query("SELECT `cl_recommender_a_timestamp` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $EndorsedByB = mysql_result(mysql_query("SELECT `cl_recommender_b_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $EndorsedByBTS = mysql_result(mysql_query("SELECT `cl_recommender_b_timestamp` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $clHDateCreated= mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $clhStatus= mysql_result(mysql_query("SELECT `cl_h_hr_approval` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $ApprovedB = mysql_result(mysql_query("SELECT `cl_approver_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $ApprovedBTS = mysql_result(mysql_query("SELECT `cl_approver_id_timestamp` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $uEMPID= mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uEMPID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uEMPID'"),0); $createdByF=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$createdBy'"),0); $createdByL=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$createdBy'"),0); $authFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $authLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $endaFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$EndorsedByA'"),0); $endaLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$EndorsedByA'"),0); $endbFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$EndorsedByB'"),0); $endbLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$EndorsedByB'"),0); $apprFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$ApprovedB'"),0); $apprLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$ApprovedB'"),0); $count = $count + 1; ?><tr onclick="javascript:showAdminAccess(this);"><?php echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".$count."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".$clHDateCreated."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".$row['cl_approved_date']."</td>"; //echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($uEMPID)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($createdByF)." ".strtoupper($createdByL)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($authLName).", ".strtoupper($authFName); echo "<br><i style='font-family:Calibri;font-size:10px;color:red;valign:top'>".$AuthorizedTS."<i>"; echo"</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($endaLName).", ".strtoupper($endaFName); echo "<br><i style='font-family:Calibri;font-size:10px;color:red;'>".$EndorsedByATS."<i>"; echo"</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($endbLName).", ".strtoupper($endbFName); echo "<br><i style='font-family:Calibri;font-size:10px;color:red;'>".$EndorsedByBTS."<i>"; echo"</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($apprLName).", ".strtoupper($apprFName); echo "<br><i style='font-family:Calibri;font-size:10px;color:red;'>".$ApprovedBTS."<i>"; echo"</td>"; echo "<td style=';border:0px solid white;cursor:pointer;valign:top'>".strtoupper($clhStatus)."</td>"; echo "</tr>"; } echo "</table>"; ?> </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.01 | proxy | phpinfo | Settings