File manager - Edit - /home/autoph/public_html/connect/home/PRF_LoadPOedItemByVendorBAKMar06.php
Back
<?php include_once 'core/init.php'; $myUID = $user_data['u_id']; //echo $uniqueRefID; $prfDateX = date_create() ->format("Y-m-d"); $prtTimeX =Explode(":", date('H:i:s')); $txDateX = explode("-",$prfDateX); $refYearX = $txDateX[0]; $refMonthX = $txDateX[1]; $refMinuteX = $prtTimeX[1]; $refSecondX = $prtTimeX[2]; $NewRefCodeX = $myUID.''.$refMonthX.''.$refMinuteX.''.$refSecondX; if(isset($_POST['done'])){ $poByCompany = trim(mysql_escape_string($_POST['poByCompany'])); $poToVendorID = trim(mysql_escape_string($_POST['poToVendorID'])); $myPONumber = trim(mysql_escape_string($_POST['myPONumber'])); ?> <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 `award_to_vendor_id`='$poToVendorID' AND `po_code`='$myPONumber'"); while($row=mysql_fetch_array($getItemHdr)){ $cID = $row['comp_id']; $venID = $row['award_to_vendor_id']; $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:getItemInfoDel(this);" onDblclick="javascript:showDelPOedItem(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 } ?> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-1.9.1.js"></script> <script type="text/javascript"> //============================================================================================================================= //============================================================================================================================= function getItemInfoDel(row) { var x=row.cells; document.getElementById("itemID").value = x[0].innerHTML; document.getElementById("selectedItem").innerHTML = x[4].innerHTML; document.getElementById("itemRefCode").value = x[1].innerHTML; } function hideDelPOedItem(){ $("#myActionFormDelPOed").fadeOut(300); }; function showDelPOedItem(){ $("#myActionFormDelPOed").fadeIn(300); } </script>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings