Website: https://www.autohubgroup.com

NO

COMPANY

PRF NUMBER

DATE

CATEGORY

REQUESTED BY

REASON

ITEM DESCRIPTION UOM ASSIGNED DATE NAME OF BUYER STATUS PO NUMBER PO DATE PO AMOUNT SUPPLIER NAME

"; $getPRF = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `date_created` BETWEEN '$startDate' AND '$endDate' ORDER BY `date_created` ASC"); while($row=mysql_fetch_array($getPRF)){ $countPRF = $countPRF + 1; $reqByID=$row['request_by']; $catID=$row['category_id']; $prfCompID=$row['comp_id']; $prtStatus=$row['current_status']; $kyCode = $row['reference_code']; //$prfStatDesc = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `id`='$prtStatus'"),0); $prfComp = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$prfCompID'"),0); $catName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$catID'"),0); $reqByLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqByID'"),0); $reqByFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqByID'"),0); echo ""; echo "".$countPRF.""; echo "".$prfComp.""; echo "".$row['reference_code'].""; echo "".$row['date_created'].""; echo "".$catName.""; echo "".$reqByLName.", ".$reqByFName.""; echo "".$row['purpose_of_request'].""; echo ""; echo ""; $getPRFDetl = mysql_query("SELECT * FROM `prf_request_detl` WHERE `header_ref_code`='$kyCode' ORDER BY `id` ASC"); while($xrow=mysql_fetch_array($getPRFDetl)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".$xrow['item_description']."

".$xrow['uom']."

".$xrow['date_time_pick']."

"; $buyerID =$xrow['canvass_by']; $buyerFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id` ='$buyerID'"),0); $buyerLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id` ='$buyerID'"),0); echo strtoupper($buyerFName)." " . strtoupper($buyerLName); echo "

"; $statusID = $xrow['item_status']; $statusName = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `sequence` ='$statusID'"),0); echo strtoupper($statusName); echo"

".$xrow['po_code']."

"; $poCode = $xrow['po_code']; $poDate = mysql_result(mysql_query("SELECT `date_posted` FROM `prf_purchase_order` WHERE `po_number` ='$poCode'"),0); echo strtoupper($poDate); echo "

".$xrow['approved_amount']."

"; $awardToVendorID = $xrow['award_to_vendor_id']; $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id` ='$awardToVendorID'"),0); echo strtoupper($vendorName); echo "

"; echo""; echo ""; } $kyCode=""; echo ""; ?>