File manager - Edit - /home/autoph/public_html/connect/home/PRF_FixedPOLoadApprovedItemByCompanyForPO.php
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $poByCompany = mysql_escape_string($_POST['poByCompany']); ?> <table> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `awarded`= 1 AND `deleted`=0 AND `execom_approval_ts`!= '' AND `for_execom_canvass_approval`=1 AND `comp_id`='$poByCompany' AND `po_code`=''"); while($row=mysql_fetch_array($getItemHdr)){ $cID = $row['comp_id']; $proposalCode = $row['approved_proposal_code']; $venID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_execomcanvassapproval` WHERE `id`='$proposalCode'"),0); $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$venID'"),0); $reqCompName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$cID'"),0); ?><tr onclick="javascript:getExecomApprovalByItemID(this);"><?php echo "<td style='width:5%;padding:3px'>".$row['id']."</td>"; echo "<td style='width:10%;padding:3px'>".$row['header_ref_code']."</td>"; echo "<td style='width:15%;padding:3px'>".$reqCompName."</td>"; echo "<td style='width:20%;padding:3px'>".$vendorName."</td>"; echo "<td style='width:30%;padding:3px'>".$row['item_description']."</td>"; echo "<td style='width:5%;padding:3px'>".$row['approved_qty']."</td>"; echo "<td style='width:10%;padding:3px'>".$row['approved_amount']."</td>"; echo "<td style='width:5%;text-align:center;padding:3px'><a href='https://www.autohub.ph/connect/home/FILES/canvass/".$fileCode."' target='_blank'>📋</a></td>"; echo "</tr>"; } ?> </table> <?php } ?> <!--###################################################################################################################################--> <!--###################################################################################################################################--> <div id="fixedMissingVendorOnPODetail" class="PopUpActionUtilWindow" style='top:-100px;left:300px;width:800px;height:320px;z-index:9'> <div class='PopUpActionUtilWindowTitle'> 🪧 EXECOM APPROVED CANVASS: <div class='PopUpWindowClose'> <b onclick="javascript:fixedMissingVendorHideDetail();" 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'> <p style='margin-bottom:0px;'>SELECT VENDOR:</p> <input type='hidden' id='exeItemID' disabled> <div id='loadExecomApproval' style='border:1px solid lightgray;width:99%;float:left;height:130px;overflow:auto'> </div> <button id='saveCanvassItem' class='PopUpLowerButtonR' style='float:right;width:180px;margin:5px'>📑 SAVE RECORD</button> <input type='text' id='selectedProposalID' disabled style='float:right;width:100px;;margin:8px;height:40px;font-family:18px;font-weight:bold;text-align:center'> </td> </tr> </table> </div> <!-- add jquery https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-3.6.0.js"></script> <script language="javascript" type="text/javascript"> $("#saveCanvassItem").click(function(){ var selectedProposalID = $("#selectedProposalID").val(); var exeItemID = $("#exeItemID").val(); //alert(exeItemID); //alert(selectedProposalID); //return false; if(selectedProposalID==''){ alert('Please select proposal to continue...'); return false; } ShowUploadBar(); $.ajax({ url: "prf_UpdatePOCanvassIDonItem.php", type: "POST", async: false, data: { "selectedProposalID": selectedProposalID, "exeItemID": exeItemID, "done": 1 }, success: function(d){ loadExecomApprovedCanvass(); ShowUploadBar(); $("#selectedProposalID").html(d); fixedMissingVendorHideDetail(); } }) }); function getExecomApprovalByItemID(row) { var x=row.cells; document.getElementById("itemID").value = x[0].innerHTML; document.getElementById("exeItemID").value = x[0].innerHTML; fixedMissingVendorShowDetail(); } function fixedMissingVendorShowDetail(){ $("#fixedMissingVendorOnPODetail").fadeIn(500); loadExecomApprovedCanvass(); } function fixedMissingVendorHideDetail(){ $("#fixedMissingVendorOnPODetail").fadeOut(500); } function loadExecomApprovedCanvass(){ var exeItemID = $("#exeItemID").val(); //alert(exeItemID); $.ajax({ url: "prf_getExecomApprovedCanvass.php", type: "POST", async: false, data: { "exeItemID" : exeItemID, "done":1 }, success: function(d){ $("#loadExecomApproval").html(d); $('#selectedProposalID').val(''); } }) } </script>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.05 |
proxy
|
phpinfo
|
Settings