File manager - Edit - /home/autoph/public_html/connect/home/PRF_POFORSUBMISSIONTOVENDOR.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 = $refYear.''.$refMonth.''.$refMinute.''.$refSecond.''.$uniqueRefID; $POSUBM = $user_data['POSUBM']; //PO Creation if($POSUBM==0){ ?> <script type="text/javascript"> Swal.fire('Access Denied. You are not allowed to access this page.') exit; </script> <?php exit; } ?> <!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 id='topMessage' style='border-radius:5px;z-index:9999999999999;position:absolute; top:10px;left:10px;width:400px;height:120px;background:yellow;border:solid 2px #efdd01 ;display:none;padding:15px;font-family:Yu Gothic Light;font-size:1vw;color:black'> </div> <div class='NewPRFHeader'> <p class='PRFBodyTitle'>📝 LIST OF APPROVED PURCHASE ORDER (Not yet routed to the supplier)</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' onclick="javascript:showPOForm();">📑 Create New PO </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:10%'>PO NUMBER</th> <th style='width:8%'>DATE POSTED</th> <th style='width:10%'>COMPANY</th> <th style='width:10%'>DEALER</th> <th style='width:22%'>VENDOR</th> <th style='width:5%'>TERMS</th> <th style='width:10%'>STATUS</th> <th style='width:15%'>REMARKS</th> <th style='width:5%'>...</th> </thead> </table> </div> <div class='PRFTableItems' id='mainTableSub'> <table id='LoadUserApprovedCanvassItem' > <?php //######################################PAGINATION####################################################### //######################################PAGINATION####################################################### //$totalRows = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`=3 "),0); //$noOfRecordPerPage = mysql_result(mysql_query("SELECT `page_count` FROM `asa_versioning_db` WHERE 1"),0); //$myPageCount = ceil($totalRows / $noOfRecordPerPage); //$offSet = 0;//($myPageCount-1) * $noOfRecordPerPage; //echo "<input type='hidden' id='MyPageCount' value='".$myPageCount."'>"; //echo "<input type='hidden' id='MyRowCount' value='".$totalRows."'>"; //echo "<input type='hidden' id='myOffSet' value='".$offSet."'>"; //echo "<input type='hidden' id='recordPerPage' value='".$noOfRecordPerPage."'>"; //####################################################################################################### //####################################################################################################### //SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1 //$getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 3 ORDER BY `id` DESC LIMIT $offSet, $noOfRecordPerPage "); $getItemHdr = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status`= 3 ORDER BY `id` DESC"); while($row=mysql_fetch_array($getItemHdr)){ $vendorID = $row['vendor_id']; $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $reqCompID=$row['comp_id']; $reqDealID=$row['dealer_id']; $reqCompName = mysql_result(mysql_query("SELECT `comp_code` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqDealName = mysql_result(mysql_query("SELECT `deal_code` FROM vts_dealerships WHERE deal_id='$reqDealID'"),0); $myTokenID = $row['token']; ?><tr onclick="javasctipt:getInfo(this);" ><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:10%'>".$row['po_number']."</td>"; echo "<td style='width:8%'>".$row['date_posted']."</td>"; echo "<td style='width:10%'>".$reqCompName."</td>"; echo "<td style='width:10%'>".$reqDealName."</td>"; echo "<td style='width:22%'>".$vendorName."</td>"; echo "<td style='width:5%'>".$row['terms']." Days</td>"; echo "<td style='width:10%'>"; $poStat = mysql_result(mysql_query("SELECT `po_status` FROM `prf_po_status` WHERE `po_code`='".$row['po_status']."'"),0); echo $poStat; echo"</td>"; echo "<td style='width:15%'>".$row['remarks']."</td>"; echo "<td style='width:5%;background:transaparent;text-align:center;'> <a href='poapr.php?id=".$row['po_number']."&uid=".$uniqueRefID."&token=".$myTokenID."' target='_Blank' styl='font-family:Yu Gothic Light;font-size:14px;font-weight:normal;color:red;'>📑</a></td>"; echo "</tr>"; } ?> </table> </div> <!--######################################## PAGINATION ############################################--> <!--######################################## PAGINATION ############################################ <div style='margin-top:50px;background:white;width:100%;padding:0px;float:left;height:70px;padding:30px'> <center> <button onclick="javascript:pageLess();" id='pageCountViewBack' class='paginationBack'>◀ Back</button> <input type='text' disabled id='pageCountView' value ="Page 1 of <?php echo $myPageCount;?>" class='paginationBox' style='width:200px;margin-left:0px'> <input type='hidden' id='pageCount' value='1' class='paginationBox'> <button onclick="javascript:pageAdd();" id='pageCountViewNext' class='paginationNext'>Next ▶ </button> </center> </div> --> </div> <!--######################################## PAGINATION ############################################--> <!--######################################## PAGINATION ############################################--> </div> <!--########################## POPUP ACTION WINDOW FOR DELETE AND VIEW DETAILS ############################################--> <!--########################################################################################################--> <div id="showPOPostingConfirmationForm" class="PopUpActionWindow" style='position:fixed'> <div class='PopUpWindowTitle'> 🪧 CONFIRM POST ACTION <div class='PopUpWindowClose'> <b onclick="javascript:hidePOConfirmForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <table> <tr> <td style='padding:10px;padding-left:20px;width:100%;background:white;font-family:Yu Gothic; font-size:16px;color:red ;height:10px;font-weight:normal;text-align:left'> Are you sure you want to POST this Purchase Order? </td> </tr> <tr> <td colspan='1' style='padding:10px;width:250px;background:white;border-top:1px solid gray;text-align:center;padding-top:5px'> <div style='width:100%;float:right;height:50px;padding:10px;background:white'> <button onclick="javascript:showUpdatePRFForm(this);" id='viewPRFItems' class='PopUpLowerButtonR' >📑 View Details</button> <button onclick="javascript:showUpdatePRFForm(this);" id='LoadCanvassSheet' class='PopUpLowerButtonL' >🗒 Canvass Sheet</button> </div> </td> </tr> </table> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <div id="POActionaForm" class="purchaseOrderForm" style='position:fixed;ackground:white;'> <div class='PopUpWindowTitle'> 🪧 FORWARD PO TO SUPPLIER <div class='PopUpWindowClose'> <b onclick="javascript:hidePOActionaForm(this);" style='font-weight:bold'> ✕ </b> </div> </div> <div style='float:left;width:99%;height:60px;background:lightgray;padding:0px;margin:5px'> <div style='background:transparent;float:left;width:100%;margin:1px;text-align:center;padding:2px;border:0px solid gray;border-radius:10px'> <div style='float:left;width:20%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>PO NUMBER</b><br> <input type='text' id='myPONumber' disabled style='width:100%;margin-left:0px;'> </div> <div style='float:left;width:20%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>DATE POSTED:</b><br> <input type='text' id='myPOPosted' disabled style='width:100%;margin-left:0px;'> </div> <div style='float:left;width:15%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>TERMS:</b><br> <input type='text' id='myPOTerms' disabled style='width:100%;margin-left:0px;'> </div> <div style='float:left;width:20%;padding:0px;margin:0px;padding-right:10px'> <b style='float:left;color:black;padding-top:1px'>STATUS:</b><br> <input type='text' id='myPOStatus' disabled style='width:100%;margin-left:0px;'> </div> </div> </div> <input type='hidden' id='SeletedPRFItemID' class='TableBottomLabel' style='border:0px;text-align:left' disabled> <!--###################################################################################################################################--> <div id='poInformationX' style='padding:2px;width:100%;height:90px;background:w;float:left'> <div style='background:WHITE;float:left;width:100%;padding:5px;padding-top:0px;font-family:Yu Gothic Light;color:gray;font-size:14px;color:blue' id='userItemDesc'> <div id='poInformation' style='padding:0px;width:100%;height:110px;background:white'> <div style='border:0px solid lightgray;float:left;width:15%;padding:2px'> <b style='padding:1px;font-family:Yu Gothic Light;font-size:1vw'>Company Code:</b> <input type='text' disabled id='poByCompany' style='margin-bottom:5px;margin-top:0px'> <label for="notifyReq" style="font-family:Yu Gothic Light;font-size:11px;font-weight:normal;padding-top:10px"> <input type="checkbox" disabled checked id="notifyReq" name="notifyReq" value="Yes" style='font-size:10px'> Notify the requesting part </label> </div> <div style='border:0px solid lightgray;float:left;width:15%;padding:2px'> <b style='padding:1px;font-family:Yu Gothic Light;font-size:1vw'>Dealer Code:</b> <input type='text' disabled id='poByDealer' style='margin-bottom:5px;margin-top:0px'> <label for="notifyReq" style="font-family:Yu Gothic Light;font-size:11px;font-weight:normal;padding-top:10px"> </label> </div> <div style='border:0px solid lightgray;float:left;width:30%;padding:2px'> <b style='padding:3px;font-family:Yu Gothic Light;font-size:1vw'>Supplier / Vendor:</b> <input type='text' disabled id='poToVendor' style='margin-bottom:5px;margin-top:0px;'> <label for="notifyVendor" style="font-family:Yu Gothic Light;font-size:11px;font-weight:normal;padding-top:10px"> <input type="checkbox" disabled checked id="notifyVendor" name="notifyVendor" value="No" style='font-family:Yu Gothic Light;font-size:11px'> If PO is approve, notify the vendor </label> </div> <div style='border:0px solid lightgray;float:left;width:40%;padding:2px'> <b style='padding:3px;font-family:Yu Gothic Light;font-size:1vw'>Instructions:</b> <textarea rows='2' id='myInstructions' disabled style='width:100%'></textarea> </div> </div> </div> </div> <!--###################################################################################################################################--> <div id='activeItemListX' style='padding:2px;width:100%;height:190px;background:white;'> <div style='background:lightgray;float:left;width:100%;padding:3px;font-family:Yu Gothic Light;color:blue;font-size:14px;color:blue' id='userItemDesc'> <b style='font-family:Yu Gothic Light;font-size:1vw;font-weight:normal;color: #2d2d2c ;padding:1px;'> 📖 Active Items:</b> <div style='background:white;padding:2px;width:100%;height:33px;margin-bottom:0px'> <table> <thead> <th style='width:5%;padding:3px'>REC.#</th> <th style='width:10%;padding:3px'>PRF #</th> <th style='width:10%;padding:3px'>COMPANY</th> <th style='width:20%;padding:3px'>VENDOR</th> <th style='width:25%;padding:3px'>ITEM DESCRIPTION</th> <th style='width:5%;padding:3px'>UOM</th> <th style='width:10%;padding:3px'>UNIT COST</th> <th style='width:5%;padding:3px'>QTY</th> <th style='width:10%;padding:3px'>AMOUNT</th> </thead> </table> </div> <div id='activeItemList' style='background: #ffffff ;padding:2px;width:100%;height:270px;margin-top:0px;overflow:auto'> </div> </div> </div> <input type='hidden' id='itemID'> <input type='hidden' id='itemRefCode'> <!--###################################################################################################################################--> <div id='SelectedItemListX' style='padding:25px;width:100%;background:lightgray;height:90px;float:left'> <button onclick="javascript:hidePOActionaForm(this);" class='PopUpLowerButtonR' style='width:150px'>🔙 EXIT</button> <button id='cancelPO' class='PopUpLowerButtonR' style='width:180px'>❌ CANCEL P.O</button> <button id='SendToVendor' class='PopUpLowerButtonR' style='width:200px'>📩 SEND TO VENDOR</button> </div> <!--###################################################################################################################################--> </div> <!--###################################################################################################################################--> <!--###################################################################################################################################--> </body> </html> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript" src="http://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> $(document).ready(function(){ $("#cancelPO").click(function(){ var myPOStatus = $("#myPOStatus").val(); var myPONumber = $("#myPONumber").val(); //alert(myPOStatus); //exit; if(myPOStatus === 'Unposted'){ alert('ERROR: This PO hasn\'t been posted yet.'); exit; }else{ if(confirm("CONFIRM DELETE ACTION: \n\nAre you sure you want to CANCEL this P.O? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "PRF_CANCEL_PO.php", type: "POST", async: false, data: { "myPONumber": myPONumber, "done": 1 }, success: function(d){ hidePOActionaForm(); ShowUploadBar(); $("#mainTableSub").html(d); } }) } } }); <!--###################################################################################################################################--> <!--###################################################################################################################################--> $("#SendToVendor").click(function(){ var myPONumber = $("#myPONumber").val(); alert(myPONumber); //exit(); if(confirm("CONFIRM DELETE ACTION: \n\nAre you sure you want to SEND this PO to supplier? \n\n Press 'OK' button to proceed...")){ ShowUploadBar(); $.ajax({ url: "prf_SendPOToVendor.php", type: "POST", async: false, data: { "myPONumber": myPONumber, "done": 1 }, success: function(d){ ShowUploadBar(); hidePOActionaForm(); $("#topMessage").html(d); updatePOForSupplierSubmission(); } }) } }); <!--###################################################################################################################################--> <!--######################################################################PRF_POST_PO.php#############################################################--> $("#LoadUserApprovedCanvassItem").click(function(){ var myPONumber = $("#myPONumber").val(); //alert(myPONumber); //exit; if(myPONumber==''){ alert('ERROR: PO Number is missing.'); exit; } ShowUploadBar(); $.ajax({ url: "PRF_POViewingOfItemsOnly.php", type: "POST", async: false, data: { "myPONumber": myPONumber, "done": 1 }, success: function(d){ $("#activeItemList").html(d); ShowUploadBar(); } }) }); //============================================================================================================================= //============================================================================================================================= $("#addToPORequestDelete").click(function(){ var itemID = $("#itemID").val(); var itemRefCode = $("#itemRefCode").val(); var myPONumber = $("#myPONumber").val(); //alert(itemID); //exit; if(myPONumber==''){ alert('ERROR: PO Number is missing.'); exit; } ShowUploadBar(); $.ajax({ url: "PRF_PODeleteToOpenPO.php", type: "POST", async: false, data: { "itemID": itemID, "myPONumber": myPONumber, "itemRefCode": itemRefCode, "done": 1 }, success: function(d){ $("#activeItemList").html(d); ShowUploadBar(); hideDelPOedItem(); reloadItemForPO(); showActiveProposal(); showPOedItemPerSelectedVendorAndCompany(); } }) }); //============================================================================================================================= //============================================================================================================================= $("#createPurchaseOrderForApproval").click(function(){ var notifyReq = $("#notifyReq").val(); var notifyVendor = $("#notifyVendor").val(); var poToVendor = $("#poToVendor").val(); var poByCompany = $("#poByCompany").val(); var myPONumber = $("#myPONumber").val(); //alert(canvassID); //exit; if(AwardItemID==''){ alert('ERROR: No item was selected'); exit; } if(canvassID==''){ alert('ERROR: Please select proposal to continue...'); exit; } if(AwardItemQty==''){ alert('ERROR: Invalid Quantity'); exit; } if(AwardItemAmount==''){ alert('ERROR: Invalid Amount'); exit; } ShowUploadBar(); $.ajax({ url: "PRF_EXECOM_AwardToVendor.php", type: "POST", async: false, data: { "AwardItemID": AwardItemID, "canvassID": canvassID, "AwardItemAmount": AwardItemAmount, "AwardItemQty": AwardItemQty, "done": 1 }, success: function(d){ $("#mainTableSub").html(d); hideConfirmedItem(); ShowUploadBar(); UpdateExecomForApprovalCount(); } }) }); //============================================================================================================================= //============================================================================================================================= }); </script> <!--- LOCALIZED COPY OF JAVASCRIPT --> <script type="text/javascript"> //============================================================================================================================= //============================================================================================================================= function showActiveVendors(){ var poByCompany = $("#poByCompany").val(); //alert(poByCompany); //exit; ShowUploadBar(); $.ajax({ url: "PRF_LoadActiveVendorslBasedOnSelectedCompany.php", type: "POST", async: false, data: { "poByCompany": poByCompany, "done": 1 }, success: function(d){ $("#poToVendor").html(d); ShowUploadBar(); } }) } //============================================================================================================================= //==================================.php=========================================================================================== function reloadItemForPO(){ ShowUploadBar(); $.ajax({ url: "PRF_ReLoadForPOItems.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ $("#mainTableSub").html(d); ShowUploadBar(); } }) } //============================================================================================================================= //==================================.php=========================================================================================== function showActiveProposal(){ var poByCompany = $("#poByCompany").val(); var loadActiveProposal = $("#poToVendor").val(); //alert(loadActiveProposal); //exit; ShowUploadBar(); $.ajax({ url: "PRF_LoadProposalBasedOnSelectedCompany.php", type: "POST", async: false, data: { "poByCompany": poByCompany, "loadActiveProposal": loadActiveProposal, "done": 1 }, success: function(d){ $("#activeItemList").html(d); showPOedItemPerSelectedVendorAndCompany(); ShowUploadBar(); reloadItemForPO(); } }) } //============================================================================================================================= //============================================================================================================================= function showPOedItemPerSelectedVendorAndCompany(){ var poByCompany = $("#poByCompany").val(); var poToVendorID = $("#poToVendor").val(); var myPONumber = $("#myPONumber").val(); //alert(poCode); //exit; ShowUploadBar(); $.ajax({ url: "PRF_LoadPOedItemByVendor.php", type: "POST", async: false, data: { "poByCompany": poByCompany, "myPONumber": myPONumber, "poToVendorID": poToVendorID, "done": 1 }, success: function(d){ $("#SelectedItemList").html(d); ShowUploadBar(); } }) } function hidetopMessage(){ $("#topMessage").fadeOut(20800); } function showtopMessage(){ $("#topMessage").fadeIn(100); hidetopMessage(); } function hidePOConfirmForm(){ $("#showPOPostingConfirmationForm").fadeOut(500); } function showPOConfirmForm(){ $("#showPOPostingConfirmationForm").fadeIn(500); } function hidePOActionaForm(){ $("#POActionaForm").fadeOut(500); } function showPOActionaForm(){ $("#POActionaForm").fadeIn(500); } function hidePOForm(){ $("#showGenCanvassForm").fadeOut(500); document.getElementById("poByCompany").disabled = false; document.getElementById("poToVendor").disabled = false; document.getElementById("myInstructions").disabled = false; document.getElementById("myInstructions").value = ''; document.getElementById("myPONumber").value = ''; document.getElementById("disabled").disabled = false; hideActionForm(); }; function showPOForm(){ document.getElementById("poByCompany").disabled = false; document.getElementById("poToVendor").disabled = false; document.getElementById("myInstructions").disabled = false; document.getElementById("myInstructions").value = ''; document.getElementById("poByCompany").value = ''; document.getElementById("poToVendor").value = ''; document.getElementById("myInstructions").value = ''; //document.getElementById("myPONumber").value = ''; $("#showGenCanvassForm").fadeIn(500); } function getInfo(row) { var x=row.cells; document.getElementById("myPONumber").value = x[1].innerHTML; document.getElementById("myPOPosted").value = x[2].innerHTML; document.getElementById("poByCompany").value = x[3].innerHTML; document.getElementById("poByDealer").value = x[4].innerHTML; document.getElementById("poToVendor").value = x[5].innerHTML; document.getElementById("myPOTerms").value = x[6].innerHTML; document.getElementById("myInstructions").value = x[8].innerHTML; document.getElementById("myPOStatus").value = x[7].innerHTML; showPOActionaForm(); } //================================================================================= //================================================================================= $("#pageCountViewNext").click(function(){ var MyPageCount = $("#MyPageCount").val(); var MyRowCount = $("#MyRowCount").val(); var myOffSet = $("#myOffSet").val(); var CurrentpageCount = $("#pageCount").val(); var recordPerPage = $("#recordPerPage").val(); //alert(CurrentpageCount); //exit; ShowUploadBar(); $.ajax({ url: "prf_POSubmission.php", type: "POST", async: false, data: { "MyPageCount": MyPageCount, "myOffSet": myOffSet, "MyRowCount": MyRowCount, "CurrentpageCount": CurrentpageCount, "recordPerPage": recordPerPage, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTableSub").html(d); } }) }); //================================================================================= //================================================================================= $("#pageCountViewBack").click(function(){ var MyPageCount = $("#MyPageCount").val(); var MyRowCount = $("#MyRowCount").val(); var myOffSet = $("#myOffSet").val(); var CurrentpageCount = $("#pageCount").val(); var recordPerPage = $("#recordPerPage").val(); //alert(CurrentpageCount); //exit; ShowUploadBar(); $.ajax({ url: "prf_POSubmission.php", type: "POST", async: false, data: { "MyPageCount": MyPageCount, "myOffSet": myOffSet, "MyRowCount": MyRowCount, "CurrentpageCount": CurrentpageCount, "recordPerPage": recordPerPage, "done": 1 }, success: function(d){ ShowUploadBar(); $("#mainTableSub").html(d); } }) //================================================================================= //================================================================================= }); //====================================================================================================== function updatePOForSupplierSubmission(){ $.ajax({ url: "PRF_UpdateForPOSubmission.php", type: "POST", async: false, data: { "trans":2 }, success: function(d){ $("#forPOSubmission").html(d); } }) } </script>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings