format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['selYearC'])){ $compID=$_GET['activeCompany']; $companyID = mysql_result(mysql_query("SELECT `comp_id` FROM `vts_company` WHERE `comp_id`='$compID'"),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); $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.""; ?>

TOTAL PRF WITH P.O

Report Coverage: Year

Prepared Date:

COMPANY JAN. FEB. MAR. APR MAY JUN. JUL. AUG. SEP. OCT. NOV. DEC. TOTAL
"; $getCompany = mysql_query("SELECT * FROM `vts_company` WHERE `comp_status`=1 ORDER BY `comp_code` ASC"); while($row=mysql_fetch_array($getCompany)){ $checkPO=0; $refCode=0; echo ""; echo "".$row['comp_code'].""; echo ""; $getJan = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$JanYearStart' AND '$JanYearEnd' AND `deleted`=0"); while($janRow=mysql_fetch_array($getJan)){ $refCode = $janRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getJanCount = $getJanCount + 1; } echo $getJanCount; } $getJanTotal = $getJanTotal + $getJanCount; echo ""; echo ""; $getFeb = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$FebYearStart' AND '$FebYearEnd' AND `deleted`=0"); while($febRow=mysql_fetch_array($getFeb)){ $refCode = $febRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getFebCount = $getFebCount + 1; } echo $getFebCount; } $getFebTotal = $getFebTotal + $getFebCount; echo ""; echo ""; $getMar = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$MarYearStart' AND '$MarYearEnd' AND `deleted`=0"); while($marRow=mysql_fetch_array($getMar)){ $refCode = $marRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getMarCount = $getMarCount + 1; } echo $getMarCount; } $getMarTotal = $getMarTotal + $getMarCount; echo ""; echo ""; $getApr = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$AprYearStart' AND '$AprYearEnd' AND `deleted`=0"); while($aprRow=mysql_fetch_array($getApr)){ $refCode = $aprRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getAprCount = $getAprCount + 1; } echo $getAprCount; } $getAprTotal = $getAprTotal + $getAprCount; echo ""; echo ""; $getMay = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$MayYearStart' AND '$MayYearEnd' AND `deleted`=0"); while($mayRow=mysql_fetch_array($getMay)){ $refCode = $mayRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getMayCount = $getMayCount + 1; } echo $getMayCount; } $getMayTotal = $getMayTotal + $getMayCount; echo ""; echo ""; $getJun = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$JunYearStart' AND '$JunYearEnd' AND `deleted`=0"); while($junRow=mysql_fetch_array($getJun)){ $refCode = $junRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getJunCount = $getJunCount + 1; } echo $getJunCount; } $getJunTotal = $getJunTotal + $getJunCount; echo ""; echo ""; $getJul = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$JulYearStart' AND '$JulYearEnd' AND `deleted`=0"); while($julRow=mysql_fetch_array($getJul)){ $refCode = $julRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getJulCount = $getJulCount + 1; } echo $getJulCount; } $getJulTotal = $getJulTotal + $getJulCount; echo ""; echo ""; $getAug = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$AugYearStart' AND '$AugYearEnd' AND `deleted`=0"); while($augRow=mysql_fetch_array($getAug)){ $refCode = $augRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getAugCount = $getAugCount + 1; } echo $getAugCount; } $getAugTotal = $getAugTotal + $getAugCount; echo ""; echo ""; $getSep = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$SepYearStart' AND '$SepYearEnd' AND `deleted`=0"); while($sepRow=mysql_fetch_array($getSep)){ $refCode = $sepRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getSepCount = $getSepCount + 1; } echo $getSepCount; } $getSepTotal = $getSepTotal + $getSepCount; echo ""; echo ""; $getOct = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$OctYearStart' AND '$OctYearEnd' AND `deleted`=0"); while($octRow=mysql_fetch_array($getOct)){ $refCode = $octRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getOctCount = $getOctCount + 1; } echo $getOctCount; } $getOctTotal = $getOctTotal + $getOctCount; echo ""; echo ""; $getNov = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$NovYearStart' AND '$NovYearEnd' AND `deleted`=0"); while($novRow=mysql_fetch_array($getNov)){ $refCode = $novRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getNovCount = $getNovCount + 1; } echo $getNovCount; } $getNovTotal = $getNovTotal + $getNovCount; echo ""; echo ""; $decNov = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$DecYearStart' AND '$DecYearEnd' AND `deleted`=0"); while($decRow=mysql_fetch_array($decNov)){ $refCode = $decRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getDecCount = $getDecCount + 1; } echo $getDecCount; } $getDecTotal = $getDecTotal + $getDecCount; echo ""; echo ""; $getMonthlyTotal = $getJanCount + $getFebCount + $getMarCount + $getAprCount + $getMayCount + $getJunCount + $getJulCount + $getAugCount + $getSepCount + $getOctCount + $getNovCount + $getDecCount; echo $getMonthlyTotal; echo ""; echo ""; $getGranTotal = $getGranTotal+$getMonthlyTotal; $getJanCount=0; $getFebCount=0; $getMarCount=0; $getAprCount=0; $getMayCount=0; $getJunCount=0; $getJulCount=0; $getAugCount=0; $getSepCount=0; $getOctCount=0; $getNovCount=0; $getDecCount=0; } echo ""; echo "TOTAL"; echo "". $getJanTotal.""; echo "". $getFebTotal.""; echo "". $getMarTotal.""; echo "". $getAprTotal.""; echo "". $getMayTotal.""; echo "". $getJunTotal.""; echo "". $getJulTotal.""; echo "". $getAugTotal.""; echo "". $getSepTotal.""; echo "". $getOctTotal.""; echo "". $getNovTotal.""; echo "". $getDecTotal.""; echo "". $getGranTotal.""; echo ""; echo ""; ?>
Prepared By: