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); ?> ".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $poAmount = $poAmount + ($row['approved_amount'] * $row['approved_qty']); $invAmount = $invAmount + ($row['approved_amount'] * $row['delivered_qty']); } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>

".$row['header_ref_code']."	".$row['item_description']."	".$row['uom']."	".number_format($row['approved_amount'],2,'.',',')."	".$row['approved_qty']."	".number_format(($row['approved_amount']*$row['approved_qty']),2,'.',',')."	".$row['delivered_qty']."	".number_format(($row['approved_amount']*$row['delivered_qty']),2,'.',',')."
TOTAL AMOUNT:					".number_format($poAmount,2,'.',',')."		INV. AMOUNT	".number_format($invAmount,2,'.',',')."
Date/Time Sent to Vendor:						".$poSentDate."
Date/Time Received by Vendor:						".$poRCVDate."
Delivery Date:						".$poDeliveryDate."
						"; $myTokenID = mysql_result(mysql_query("SELECT `token` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0);; echo "🖨 Print PO"; echo"