format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['id'])){ $poNumber=$_GET['id']; $companyID = mysql_result(mysql_query("SELECT `comp_id` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyAddress = mysql_result(mysql_query("SELECT `comp_address` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyFax = mysql_result(mysql_query("SELECT `comp_fax` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyTel = mysql_result(mysql_query("SELECT `comp_tel` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyEmail = mysql_result(mysql_query("SELECT `comp_email` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $PODate = mysql_result(mysql_query("SELECT `date_posted` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $POTerms = mysql_result(mysql_query("SELECT `terms` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $POInstructions = mysql_result(mysql_query("SELECT `remarks` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $deliverDate = mysql_result(mysql_query("SELECT `delivery_date` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $supplierID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); $SupplierName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $getPRFNumberFromDetl = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `po_code`='$poNumber'"),0); $getPRFDealerID = mysql_result(mysql_query("SELECT `deal_id` FROM `prf_request_hdr` WHERE `reference_code`='$getPRFNumberFromDetl'"),0); $companyTIN = mysql_result(mysql_query("SELECT `comp_tin` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $dealerTIN = mysql_result(mysql_query("SELECT `deal_tin` FROM `vts_dealerships` WHERE `deal_id`='$getPRFDealerID'"),0); if($dealerTIN == ''){ $poTINNumber = $companyTIN; }else{ $poTINNumber = $dealerTIN; } $SupplierTIN = mysql_result(mysql_query("SELECT `tin_number` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $SupplierAddress = mysql_result(mysql_query("SELECT `address` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $SupplierContact = mysql_result(mysql_query("SELECT `contact_person` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $SupplierTel = mysql_result(mysql_query("SELECT `landline` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $SupplierContactMobile = mysql_result(mysql_query("SELECT `contact_person_mobile` FROM `prf_suppliers` WHERE `id`='$supplierID'"),0); $ckhToken = $_GET['token']; $liveToken = mysql_result(mysql_query("SELECT `token` FROM `prf_purchase_order` WHERE `po_number`='$poNumber'"),0); if($liveToken != $ckhToken){ echo "

This record does not exist. Reason: Invalid Token ID

Please contact your system administrator for assistance. Thank you

Date: ".date("m/d/Y")." | ".date("h:m:s AM/PM")."

"; exit; } ?>

Cancelled P.O

"; } ?>

Website: https://www.autohubgroup.com

".$companyAddress.""; echo "Tel. No.".$companyTel." Fax." .$companyFax.""; echo "E-mail: ".$companyEmail.""; ?>
PURCHASE ORDER
Supplier Name: PO Number:
Address: PO Date:
Contact Person: Terms:
Tel. Number: Contact Mobile#:
Please Invoice To:
TIN Number:
Delivery Date:
Look For:
QTY UNIT DESCRIPTION UNIT COST AMOUNT
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $CostPrice = $row['approved_amount']* $row['approved_qty']; $totalAmount = $totalAmount + $CostPrice; } ?>
".$row['approved_qty']."".$row['uom']."".strtoupper($row['item_description'])."".number_format($row['approved_amount'],2,'.',',')."".number_format(($row['approved_amount'] * $row['approved_qty']),2,'.',',') ."

* * * NOTHING FOLLOWS * * *

TOTAL
P.O INFORMATION:

"; while($prf = mysql_fetch_array($getPRFNumber)){ $refCode= $prf['header_ref_code']; $reqID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); $reqFName =mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqID'"),0); $reqLName =mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqID'"),0); $dealID = mysql_result(mysql_query("SELECT `deal_id` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); $dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); echo "
"; echo "

PRF NUMBER: ".$refCode."

"; echo "

DEALERSHIP: ".strtoupper($dealName)."

"; echo "

REQUESTOR: ".strtoupper($reqFName)." ".strtoupper($reqLName)."

"; echo "
"; } $purposeOfRequest = mysql_result(mysql_query("SELECT `purpose_of_request` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); echo "

PURPOSE : ".strtoupper($purposeOfRequest)."

"; ?>

CONDITIONS:

1) All items and/or services shall b e in accordance with specifications stated and/or qouted.

2) All prices stated are protected from any increase and advice us immediately of any shortage or delay in delivery.

3) We reserve the right to return any goods or reject any service upon discovery of defects not apparent at time of receipt

4) To ensure payment according to above terms, submit a duplicate of the original invoice immediately upon delivery and acceptance.

5) Terms of payment shall commence from date order has been fully delivered.

Prepared By:
Checked By:
Approved By:

*** This is a System Generated Purchase Order, physical signature might not be required ***