format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['selYearFS'])){ $compID=$_GET['selectCompanyF']; $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 WITH P.O

Coverage: Year

Prepared Date:

REQ.DATE DATE POST PRF No.# P.O No.# PO DATE DEALER ITEM DESCRIPTION QTY AMOUNT
"; $getPRF = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `date_created` BETWEEN '$startDate' AND '$endDate' AND `comp_id`='$compID' AND `po_code`!='' ORDER BY `header_ref_code` 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_code` FROM `vts_dealerships` WHERE `deal_id`='".$row['dealer_id']."'"),0); $totalCost = $totalCost + $row['approved_amount']; $totalQTY = $totalQTY + $row['approved_qty']; echo ""; //echo "".$countPRF.""; echo "".$row['date_created'].""; echo ""; $getDatePosted = mysql_result(mysql_query("SELECT `posted_date` FROM `prf_request_hdr` WHERE `reference_code` ='".$row['header_ref_code']."'"),0); $getPDateEx = explode(" ", $getDatePosted); $myPDate = $getPDateEx[0]; if($myPDate ==""){ echo $row['date_created']; }else{ echo $myPDate; } //echo $myPDate; echo ""; echo "".$row['header_ref_code'].""; echo "".$row['po_code'].""; echo ""; $poDatePosted = mysql_result(mysql_query("SELECT `date_posted` FROM `prf_purchase_order` WHERE `po_number`='".$row['po_code']."'"),0); echo $poDatePosted; echo ""; echo "".$dealerName.""; echo "".$row['item_description'].""; echo "".number_format($row['approved_qty'],1,'.',',').""; echo "".number_format($row['approved_amount'],2,'.',',').""; echo ""; } echo ""; echo "TOTAL"; echo "".number_format($totalQTY,1,'.',',').""; echo "".number_format($totalCost,2,'.',',').""; echo""; echo ""; ?>
Prepared By: