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; } ?>

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 * * *

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); $purposeOfRequest = mysql_result(mysql_query("SELECT `purpose_of_request` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); echo "
"; echo "

PRF NUMBER: ".$refCode."

"; echo "

DEALERSHIP: ".strtoupper($dealName)."

"; echo "

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

"; echo "

PURPOSE : ".strtoupper($purposeOfRequest)."

"; echo "
"; } ?>
TOTAL

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.

*The Seller/Provider unconditionally warrants that the provision of service and /or products is made in good faith and in full compliance with existing laws. The Seller / Provider shall be solely liable for, indemnity and hold Autohub Group Holdings, Inc. and its affiliates free and harmless from any and all liability, claim, causes of action, less and or damage arising from any provisions of service.
Prepared By:
Checked By:
Approved By:

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