format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['selYearGS'])){ $compID=$_GET['selectCompanyG']; $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$compID'"),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); $uFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$myUID'"),0); $uLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$myUID'"),0); $uFullName = $uFname.' '.$uLname; ?>

Website: https://www.autohubgroup.com

".$companyName.""; //echo "".$companyAddress.""; //echo "Tel. No.".$companyTel." Fax." .$companyFax.""; //echo "E-mail: ".$companyEmail.""; ?>

REQUEST ITEMS WITHOUT P.O

Coverage: Year

Prepared Date:

NO PRF NUMBER REQ. DATE DEALERSHIP ITEM DESCRIPTION QUANTITY AMOUNT
"; $getPRF = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `date_created` BETWEEN '$startDate' AND '$endDate' AND `comp_id`='16' AND `po_code`='' ORDER BY `date_created` ASC"); while($row=mysql_fetch_array($getPRF)){ $countPRF = $countPRF + 1; //$reqByID=$row['request_by']; $catID=$row['category_id']; $prtStatus=$row['item_status']; $prfStatDesc = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `id`='$prtStatus'"),0); $catName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$catID'"),0); $dealerName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$row['dealer_id']."'"),0); $totalCost = $totalCost + $row['approved_amount']; $totalQTY = $totalQTY + $row['quantity']; echo ""; echo "".$countPRF.""; echo "".$row['header_ref_code'].""; echo "".$row['date_created'].""; echo "".$dealerName.""; echo "".$row['item_description'].""; echo "".number_format($row['quantity'],2,'.',',').""; echo "".number_format($row['approved_amount'],2,'.',',').""; echo ""; } echo ""; echo "TOTAL"; echo "".number_format($totalQTY,2,'.',',').""; echo "".number_format($totalCost,2,'.',',').""; echo""; echo ""; ?>
Prepared By: