File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF_LoadPOItemsForReceiving.php

Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $myPONumber = mysql_escape_string($_POST['myPONumber']); $poRCVDate = mysql_result(mysql_query("SELECT `vendor_confirm_ts` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); $poSentDate = mysql_result(mysql_query("SELECT `date_forwarded_to_vendor` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); $poDeliveryDate = mysql_result(mysql_query("SELECT `delivery_date` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); ?> <table> <?php $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code`= $myPONumber AND `deleted`=0 ORDER BY `id`"); while($row=mysql_fetch_array($getItemHdr)){ $vendorID = $row['award_to_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']; $refCode=$row['header_ref_code']; $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); $reqDate = mysql_result(mysql_query("SELECT `posted_date` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); //$exeDate= mysql_result(mysql_query("SELECT `date_approved` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); $poDate = mysql_result(mysql_query("SELECT `date_approved` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); $venDate = mysql_result(mysql_query("SELECT `vendor_confirm_ts` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); ?><tr onDblClick="javasctipt:showConfirmationBox();" onclick="javascript:getInformationData(this);"><?php echo "<td style='width:5%'>".$row['id']."</td>"; echo "<td style='width:8%'>".$row['header_ref_code']."</td>"; echo "<td style='width:35%'>".$row['item_description']."</td>"; echo "<td style='width:5%'>".$row['uom']."</td>"; echo "<td style='width:9%;text-align:right'>".number_format($row['approved_amount'],2,'.',',')."</td>"; echo "<td style='width:9%;text-align:center'>".$row['approved_qty']."</td>"; echo "<td style='width:9%;text-align:right;border-right:1px solid gray'>".number_format(($row['approved_amount']$row['approved_qty']),2,'.',',')."</td>"; echo "<td style='width:11%;text-align:center;background:#efff7d;border:1px solid gray'>".$row['delivered_qty']."</td>"; echo "<td style='width:9%;text-align:right;background:#efff7d;border:1px solid gray'>".number_format(($row['approved_amount']$row['delivered_qty']),2,'.',',')."</td>"; echo "</tr>"; $poAmount = $poAmount + ($row['approved_amount'] * $row['approved_qty']); $invAmount = $invAmount + ($row['approved_amount'] * $row['delivered_qty']); } echo "<tr>"; echo "<td colspan='5' style='width:5%;text-align:right;font-size:12px;font-weight:bold;'>TOTAL AMOUNT:</td>"; echo "<td colspan='2' style='width:5%;text-align:right;font-size:12px;font-weight:bold;border-right:1px solid gray'>".number_format($poAmount,2,'.',',')."</td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:#e5f573;border:1px solid gray'>INV. AMOUNT</td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:#e5f573;border:1px solid gray'>".number_format($invAmount,2,'.',',')."</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='5' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:#ffffff;height:100px'></td>"; echo "<td colspan='2' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:#ffffff;border-right:0px solid gray'></td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:#ffffff;border:0px solid gray'></td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:bold;background:#ffffff;border:0px solid gray'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='6' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;'>Date/Time Sent to Vendor:</td>"; echo "<td colspan='2' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;border-right:0px solid gray'>".$poSentDate."</td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;border:0px solid gray'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='6' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;'>Date/Time Received by Vendor:</td>"; echo "<td colspan='2' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;border-right:0px solid gray'>".$poRCVDate."</td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;border:0px solid gray'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='6' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;'>Delivery Date:</td>"; echo "<td colspan='2' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;border-right:0px solid gray'>".$poDeliveryDate."</td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;border:0px solid gray'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='6' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;'></td>"; echo "<td colspan='2' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;border-right:0px solid gray'>"; $myTokenID = mysql_result(mysql_query("SELECT `token` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0);; echo "<a href='poapr.php?id=".$myPONumber."&uid=".$myUID."&token=".$myTokenID."' target='_Blank' styl='font-family:Yu Gothic Light;font-size:14px;font-weight:normal;color:red;'>🖨 Print PO</a>"; echo"</td>"; echo "<td colspan='1' style='width:5%;text-align:right;font-size:12px;font-weight:normal;background:#ffffff;border:0px solid gray'></td>"; echo "</tr>"; ?> </table> <?php }?>

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