Website: https://www.autohubgroup.com

COMPANY

JAN.

FEB.

MAR.

APR

MAY

JUN.

JUL.

AUG.

SEP.

OCT.

NOV.

DEC.

TOTAL

"; $getDealerName = mysql_query("SELECT * FROM `vts_dealerships` WHERE `comp_id`='$compID' ORDER BY `deal_name` ASC"); while($row=mysql_fetch_array($getDealerName)){ $dealID = $row['deal_id']; echo ""; echo "".$row['deal_name'].""; echo ""; $getJan = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$JanYearStart' AND '$JanYearEnd' AND `deleted`=0"),0); if($getJan > 0 ){echo number_format($getJan,2,'.',',');}else{echo '';} $getJanTotal = $getJanTotal + $getJan; echo ""; echo ""; $getFeb = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$FebYearStart' AND '$FebYearEnd' AND `deleted`='no'"),0); if($getFeb > 0 ){echo number_format($getFeb,2,'.',',');}else{echo '';} $getFebTotal = $getFebTotal + $getFeb; echo ""; echo ""; $getMar = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$MarYearStart' AND '$MarYearEnd' AND `deleted`='no'"),0); if($getMar > 0 ){echo number_format($getMar,2,'.',',');}else{echo '';} $getMarTotal = $getMarTotal + $getMar; echo ""; echo ""; $getApr = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$AprYearStart' AND '$AprYearEnd' AND `deleted`='no'"),0); if($getApr > 0 ){echo number_format($getApr,2,'.',',');}else{echo '';} $getAprTotal = $getAprTotal + $getApr; echo ""; echo ""; $MayFeb = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$MayYearStart' AND '$MayYearEnd' AND `deleted`='no'"),0); if($MayFeb > 0 ){echo number_format($MayFeb,2,'.',',');}else{echo '';} $MayFebTotal = $MayFebTotal + $MayFeb; echo ""; echo ""; $JunFeb = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$JunYearStart' AND '$JunYearEnd' AND `deleted`='no'"),0); if($JunFeb > 0 ){echo number_format($JunFeb,2,'.',',');}else{echo '';} $JunFebTotal = $JunFebTotal + $JunFeb; echo ""; echo ""; $JulFeb = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$JulYearStart' AND '$JulYearEnd' AND `deleted`='no'"),0); if($JulFeb > 0 ){echo number_format($JulFeb,2,'.',',');}else{echo '';} $JulFebTotal = $JulFebTotal + $JulFeb; echo ""; echo ""; $AugFeb = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$AugYearStart' AND '$AugYearEnd' AND `deleted`='no'"),0); if($AugFeb > 0 ){echo number_format($AugFeb,2,'.',',');}else{echo '';} $AugFebTotal = $AugFebTotal + $AugFeb; echo ""; echo ""; $SepMar = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$SepYearStart' AND '$SepYearEnd' AND `deleted`='no'"),0); if($SepMar > 0 ){echo number_format($SepMar,2,'.',',');}else{echo '';} $SepMarTotal = $SepMarTotal + $SepMar; echo ""; echo ""; $OctFeb = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$OctYearStart' AND '$OctYearEnd' AND `deleted`='no'"),0); if($OctFeb > 0 ){echo number_format($OctFeb,2,'.',',');}else{echo '';} $OctFebTotal = $OctFebTotal + $OctFeb; echo ""; echo ""; $NovFeb = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$NovYearStart' AND '$NovYearEnd' AND `deleted`='no'"),0); if($NovFeb > 0 ){echo number_format($NovFeb,2,'.',',');}else{echo '';} $NovFebTotal = $NovFebTotal + $NovFeb; echo ""; echo ""; $getDec = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `comp_id`='".$row['comp_id']."' AND `dealer_id`='$dealID' AND `date_created` BETWEEN '$DecYearStart' AND '$DecYearEnd' AND `deleted`='no'"),0); if($getDec > 0 ){echo number_format($getDec,2,'.',',');}else{echo '';} $getDecTotal = $getDecTotal + $getDec; echo ""; echo ""; $prfCount = $getDec + $NovFeb + $OctFeb + $SepFeb + $AugFeb + $JulFeb + $JunFeb + $MayFeb + $getApr + $getMar + $getFeb + $getJan; $prfCountTotal = $prfCountTotal + $prfCount; echo number_format($prfCount,2,'.',','); echo ""; echo ""; } echo ""; echo "TOTAL"; echo "". number_format($getJanTotal,2,'.',',').""; echo "". number_format($getFebTotal,2,'.',',').""; echo "". number_format($getMarTotal,2,'.',',').""; echo "". number_format($getAprTotal,2,'.',',').""; echo "". number_format($MayFebTotal,2,'.',',').""; echo "". number_format($JunFebTotal,2,'.',',').""; echo "". number_format($JulFebTotal,2,'.',',').""; echo "". number_format($AugFebTotal,2,'.',',').""; echo "". number_format($SepMarTotal,2,'.',',').""; echo "". number_format($OctFebTotal,2,'.',',').""; echo "". number_format($NovFebTotal,2,'.',',').""; echo "". number_format($getDecTotal,2,'.',',').""; echo "". number_format($prfCountTotal,2,'.',',').""; echo ""; echo ""; ?>