File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_CanvassSheetPreparation.php

Back
<?php include 'core/init.php'; protected_page(); $uniqueRefID = $user_data['u_id']; //echo $uniqueRefID; $prfDate = date_create() ->format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; $NewRefCode = $refMonth.''.$refMinute.''.$refSecond; ?> <!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/> <link rel="stylesheet" type="text/css" href="css/jquery-ui.css"/> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1"/> </head> <body> <div class='NewPRFHeader'> <p class='PRFBodyTitle'>📝  CANVASS SHEET PREPARATION (Preparation for EXECOM approval of Canvass prior to creation of PO)</p> </div> <!--########################## MAIN TABLE WINDOW ############################################--> <!--########################################################################################################--> <div class='NewPRFBody'> <div class='NewPRFBodyMenu'> <div class='searchDIVA'> <!--<b class='BodyTopMenu' id='LoadNewPRFForm' onclick='showActionSlipForm()'>➕ New Purchase </b> --> <b class='BodyTopMenu'>📠 Print </b> <b class='BodyTopMenu' onclick="javascript:getInfoCode(this);">⬇ Export</b> </div> <div class='searchDIVB'> <input type='hidden' id='userActiveID' value='<?php echo $uniqueRefID;?>'> <input type='text' id='SearchCanvass' placeholder='Search Record.' class='textSearch' style='width:70%;margin:0px;border:1px solid lightgray;'> <button id='goSearchCanvass' class='searchButton' style='width:25%'> 🔍       Search</button> </div> </div> <div id='mainTable' class='PRFTableBody'> <div style='width:100%;height:33px;background:white'> <table> <thead> <th style='width:5%'>REC.#</th> <th style='width:20%'>COMPANY</th> <th style='width:15%'>REQUESTOR</th> <th style='width:30%'>ITEM DESCRIPTION</th> <th style='width:15%'>CATEGORY</th> <th style='width:5%'>QTY</th> <th style='width:10%'>DATE NEEDED</th> </thead> </table> </div> <div class='PRFTableItems'> <table> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `create_canvass_sheet`= 1 AND `deleted`=0 AND `awarded`='0' AND `for_execom_canvass_approval`='0' AND `canvass_sheet_creation_ts`=''"); while($row=mysql_fetch_array($getItemHdr)){ $regHDRcode=$row['header_ref_code']; $regCat=$row['category_id']; $regCatName =mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$regCat'"),0); $reqByID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); $reqCompID=$row['comp_id']; $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); $reqCompName = mysql_result(mysql_query("SELECT `comp_name` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$reqByID'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$reqByID'"),0); ?><tr onclick="javascript:getInfo(this);" id='LoadUserApprovedCanvassItem' ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:20%'>".strtoupper($reqCompName)."</td>"; echo "<td style='width:15%'>".strtoupper($reqByLName).", ".strtoupper($reqByFName)."</td>"; echo "<td style='width:30%;text-align:left'>".strtoupper($row['item_description'])."</td>"; echo "<td style='width:15%;text-align:left'>".$regCatName."</td>"; echo "<td style='width:5%;text-align:left'>".strtoupper($row['quantity'])."</td>"; echo "<td style='width:10%'>".strtoupper($dateNeeded)."</td>"; //echo "<td style='width:5%;text-align:center'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$row['file_code']."' target='_blank'>View</a></td>"; echo "</tr>"; } ?> <tr><td colspan='9' ><hr style='padding:0px;background:transparent;border:0px;border-bottom:1px solid gray'></td> <tr> <td colspan='2' style='background:white;font-family:Yu Gothic; font-size:13px;color: #f97d43 ;height:20px;font-weight:normal'>Selected Record:</td> <td colspan='7' style='background:white;'> <input type='text' id='selectedPRFHeaderID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> </td> </tr> </table> </div> </div> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <div id="showGenCanvassForm" class="usrCanvassApprovalForm" style='height:345px;background:white'> <div class='PopUpWindowTitle'> 🪧 User Approved Proposal and Specifications: <div class='PopUpWindowClose'> <b onclick="javascript:hideConfirmedItem(this);" style='font-weight:bold'> ✕ </b> </div> </div> <input type='hidden' id='SeletedPRFItemID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> <div id='loadEndorsedCanvass' style='padding:10px;width:100%;height:250px;background:white;'> <div style='background:lightgray;float:left;width:100%;padding:5px;font-family:Yu Gothic Light;color:gray;font-size:14px;color:blue' id='userItemDesc'><b style='font-size:14px;color:black'>USER APPROVED PROPOSAL / SPECS: <div id='loadCanvassItem' style='padding:0px;width:100%;height:200px;background:white;overflow:auto'> </div> </div> </div> <div style='float:right;width:50%;height:55px;background:white;padding:10px'> <button id='SendToExecom' class='DelPopUpLowerButtonL' style='width:63%;float:right;padding-left:20px'>📩   SEND TO EXECOM</button> <button onclick="javascript:hideConfirmedItem();" class='PopUpLowerButtonL' style='width:30%;float:left'>⬅   CLOSE</button> </div> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> </body> </html> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ //====================================================================================================== $("#SendToExecom").click(function(){ ShowUploadBar(); var SeletedPRFItemID = $("#SeletedPRFItemID").val(); //alert(SeletedPRFItemID); //exit; $.ajax({ url: "PRF_CanvassSendToExecomForApproval.php", type: "POST", async: false, data: { "SeletedPRFItemID": SeletedPRFItemID, "done": 1 }, success: function(d){ $("#mainTable").html(d); hideConfirmedItem(); updateCanvassSheetCount(); UpdateExecomForApprovalCount(); ShowUploadBar(); } }) }); //====================================================================================================== $("#goSearchCanvass").click(function(){ var SearchCanvass = $("#SearchCanvass").val(); ShowUploadBar(); $.ajax({ url: "PRF_Search_CanvassFile.php", type: "POST", async: false, data: { "SearchCanvass": SearchCanvass, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTable").html(d); } }) }); //====================================================================================================== $("#LoadUserApprovedCanvassItem").click(function(){ var SeletedPRFItemID = $("#SeletedPRFItemID").val(); ShowUploadBar(); showConfirmedItem(); $.ajax({ url: "PRF_LOAD_User_Approved_Canvass.php", type: "POST", async: false, data: { "SeletedPRFItemID": SeletedPRFItemID, "done": 1 }, success: function(d){ ShowUploadBar(); $("#loadCanvassItem").html(d); } }) }); //====================================================================================================== function updateCanvassSheetCount(){ $.ajax({ url: "PRF_UpdateCanvassSheetCount.php", type: "POST", async: false, data: { "trans":1 }, success: function(d){ $("#userApprovalCanvassCount").html(d); } }) } //====================================================================================================== function UpdateExecomForApprovalCount(){ $.ajax({ url: "PRF_UpdateExecomForApprovalCount.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#forExecomApprovalCount").html(d); } }) } //====================================================================================================== function updateApprovalPRF(){ $.ajax({ url: "PRF_procIncomingInfo.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#forMyApprovalCount").html(d); } }) } //====================================================================================================== function refreshMainTable(){ $.ajax({ url: "PRF_MainTableHeaderDisplay.php", type: "POST", async: false, data: { }, success: function(d){ //invShowAssignMsg(); $("#mainTable").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) } }); </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> function hideConfirmedItem(){ $("#showGenCanvassForm").fadeOut(500); }; function showConfirmedItem(){ $("#showGenCanvassForm").fadeIn(500); }; function hideUploadForm(){ $("#MyUploadForm").fadeOut(500); }; function showUploadForm(){ $("#MyUploadForm").fadeIn(500); }; function hideUpdatePRFForm(){ $("#PRFUPDATENewRequest").fadeOut(500); }; function showUpdatePRFForm(){ $("#PRFUPDATENewRequest").fadeIn(500); $("#showActionViewDelete").fadeOut(500); }; function getInfo(row) { var x=row.cells; document.getElementById("selectedPRFHeaderID").value = x[1].innerHTML; document.getElementById("SeletedPRFItemID").value = x[0].innerHTML; } function getInfoCode(row) { var x=row.cells; var canvassCodeID = <?php echo $NewRefCode;?> +""+ Math.floor(Math.random() * 888) + <?php echo $uniqueRefID;?>; document.getElementById("canvassCode").value= canvassCodeID;//<?php echo $NewRefCode;?> +""+ Math.floor(Math.random() * 888) + <?php echo $uniqueRefID;?>; showUploadForm(); } //LOAD DEALER BASED ON SELECTED COMPANY function showDealership(str) { //alert(str); if (str == "") { document.getElementById("myDealerList").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("myDealerList").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","PRF_LOAD_DealerBySelectedCompany.php?q="+str,true); xmlhttp.send(); } } //LOAD DEALER BASED ON SELECTED COMPANY function showCategoryItems(str) { //alert(str); if (str == "") { document.getElementById("CategorySubItem").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState == 4 && xmlhttp.status == 200) { document.getElementById("CategorySubItem").innerHTML = xmlhttp.responseText; } } xmlhttp.open("GET","PRF_LOAD_ExpenseCategoryItems.php?q="+str,true); xmlhttp.send(); } } </script>

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