format("Y-m-d"); $signedTime =date('H:i:s'); $myUID = $user_data['u_id']; if(isset($_GET['id'])){ $prfNumber=$_GET['id']; $aLink = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number`='$prfNumber'"),0); $attachmentLink = 'https://www.autohub.ph/connect/home/FILES/prfdoc/'.$aLink; echo ""; $myToken=$_GET['token']; $myKey=$_GET['key']; echo ""; $userID = $_GET['uid']; $companyID = mysql_result(mysql_query("SELECT `comp_id` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),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); $companyTIN = mysql_result(mysql_query("SELECT `comp_tin` 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); $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $itemCat = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $itemCatName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$itemCat'"),0); $purposeOfReq = mysql_result(mysql_query("SELECT `purpose_of_request` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $reqBy = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $reqByFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqBy'"),0); $reqByLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqBy'"),0); $aprBy = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); $aprByFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprBy'"),0); $aprByLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprBy'"),0); $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $chkIfPosted = mysql_result(mysql_query("SELECT `current_status` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber' AND `current_status`=2"),0); //echo "Result:".$chkIfPosted; if($chkIfPosted != 2){ echo "
ERROR: Purchase Request is no longer exist.
"; exit; } ?>

Website: https://www.autohubgroup.com

".$companyAddress.""; echo "Tel. No.".$companyTel." Fax." .$companyFax.""; echo "E-mail: ".$companyEmail.""; ?>
PURCHASE REQUEST FOR GEN. MANAGER APPROVAL
Requested By: Category:
PRF Number: Date Needed:
Approving Head: Purpose of Request:
QTY UNIT ASSET TYPE DESCRIPTION
"; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
".$row['quantity']."".$row['uom']."".strtoupper($itemCName)."".strtoupper($row['item_description'])."

* * * NOTHING FOLLOWS * * *