format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['selYearSN'])){ $compID=$_GET['selectCompanyN']; $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.""; ?>

PRF SUMMARY LIST

Coverage:

Prepared Date:

NO COMPANY PRF NUMBER DATE CATEGORY REQUESTED BY REASON
"; $getPRF = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `deleted`=0 AND `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']; //$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 ""; ?>
Prepared By: