";
echo "
";
echo "
";
echo "
";
echo "";
echo "";
echo "
Date: ".date("m/d/Y").""; echo "
";
echo "VEHICLE INVENTORY REPORT
UNIT AGING SUMMARY LIST "; echo "Date: ".date("m/d/Y").""; echo "
".$brand."
"; echo "".$ageRange."
| VEHICLE MODEL/VARIANT | "; echo "UNIT DESCRIPTION | "; echo "DATE RECEIVED | "; echo "COLOR | "; echo "CS NUMBER | "; echo "AGING | "; echo ""; $myLineModel = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `sold`='0' AND `returned`='0' AND `company`='$filCompany' AND `brand`='$brand' 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($range ==='A'){ if($totalCount < 91){ $GrnTotalItemCount = $GrnTotalItemCount + 1; $GrnlessNinety = $GrnlessNinety + $lessNinety; $GrnbetweenNinetyOneEighty = $GrnbetweenNinetyOneEighty + $betweenNinetyOneEighty; $GrnoldestUnit = $GrnoldestUnit + $oldestUnit; $GrnNewUnit = $GrnNewUnit + $NewUnit ; echo "|
|---|---|---|---|---|---|---|
| ".$xRow['brand_code']." | "; echo "".$xRow['description']." | "; echo "".$xRow['date_received']." | "; echo "".$xRow['color']." | "; echo "".$xRow['cs_number']." | "; echo "".$totalCount." | "; echo "|
| ".$xRow['brand_code']." | "; echo "".$xRow['description']." | "; echo "".$xRow['date_received']." | "; echo "".$xRow['color']." | "; echo "".$xRow['cs_number']." | "; echo "".$totalCount." | "; echo "|
| ".$xRow['brand_code']." | "; echo "".$xRow['description']." | "; echo "".$xRow['date_received']." | "; echo "".$xRow['color']." | "; echo "".$xRow['cs_number']." | "; echo "".$totalCount." | "; echo "|
| TOTAL | "; echo "".$GrnTotalItemCount." | "; echo "|||||
Prepared by:_______________________
";
echo "Date Prepared: ".date("m/d/Y")." ".date('h:i a')."
"; echo "