"; echo "

VEHICLE INVENTORY REPORT

UNIT AGING SUMMARY REPORT"; echo "

Date: ".date("m/d/Y").""; echo "

"; echo "

".$brand."

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getData)){ $lineModel = $row['brand_code']; $totalItemCount = 0; $lessNinety = 0; $betweenNinetyOneEighty = 0; $oldestUnit = 0; $NewUnit = 0; $myLineModel = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `sold`='0' AND `returned`='0' AND `company`='$filCompany' AND `brand_code`='$lineModel' ORDER BY `brand_code` ASC"); while($xRow=mysql_fetch_array($myLineModel)){ $totalItemCount = $totalItemCount + 1; $olddate = TRIM($xRow['date_received']); $now = time(); // or your date as well' $your_date = strtotime($olddate); $datediff = $now - $your_date; $totalCount=round($datediff / (60 * 60 * 24)); if($xRow['incoming_unit']==1){ $NewUnit = $NewUnit + 1; //echo $xRow['id']."
"; } if($totalCount < 91){ $lessNinety = $lessNinety + 1; } if ($totalCount > 90 && $totalCount < 181){ $betweenNinetyOneEighty = $betweenNinetyOneEighty + 1; } if ($totalCount > 180 ){ $oldestUnit = $oldestUnit + 1; } } $GrnTotalItemCount = $GrnTotalItemCount + $totalItemCount; $GrnlessNinety = $GrnlessNinety + $lessNinety; $GrnbetweenNinetyOneEighty = $GrnbetweenNinetyOneEighty + $betweenNinetyOneEighty; $GrnoldestUnit = $GrnoldestUnit + $oldestUnit; $GrnNewUnit = $GrnNewUnit + $NewUnit ; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

VEHICLE MODEL/VARIANT	TOTAL STOCK	INCOMING	1 - 90 DAYS	91 - 180 DAYS	181 ABOVE
".$lineModel."	".$totalItemCount."	".$NewUnit."	".$lessNinety."	".$betweenNinetyOneEighty."	".$oldestUnit."
GRAND TOTAL	".$GrnTotalItemCount."	".$GrnNewUnit."	".$GrnlessNinety."	".$GrnbetweenNinetyOneEighty."	".$GrnoldestUnit."

"; echo "

Prepared by:_______________________

"; echo "

Date Prepared: ".date("m/d/Y")." ".date('h:i a')."

"; echo "