";
echo "
";
echo "
";
echo "
";
echo "";
echo "";
echo "
Date: ".date("m/d/Y").""; echo "
";
echo "VEHICLE INVENTORY REPORT
AGING UNIT BY UNIT PRICE"; echo "Date: ".date("m/d/Y").""; echo "
".$brand."
"; $myBrandID = mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name`='$brand'"),0); echo "| VEHICLE MODEL/VARIANT | "; echo "AGING UNIT | "; echo "1 - 90 DAYS | "; echo "91 - 180 DAYS | "; echo "181 ABOVE | "; echo ""; while($row=mysql_fetch_array($getData)){ $lineModel = $row['brand_code']; $rowUnitCount = 0; $nAmount = 0; $BAmount = 0; $EAmount = 0; $NunitCount=0; $BunitCount=0; $EunitCount=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)){ $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($totalCount < 91){ $NunitCount = $NunitCount + 1; $nAmount = $nAmount + $xRow['price']; } if ($totalCount > 90 && $totalCount < 181){ $BunitCount = $BunitCount + 1; $BAmount = $BAmount + $xRow['price']; } if ($totalCount > 180 ){ $EunitCount = $EunitCount + 1; $EAmount = $EAmount + $xRow['price']; } } $rowUnitCount = $NunitCount + $BunitCount + $EunitCount; $GrnTotalItemCount = $GrnTotalItemCount + $rowUnitCount; $GrnlessNinety = $GrnlessNinety + $nAmount; $GrnbetweenNinetyOneEighty = $GrnbetweenNinetyOneEighty + $BAmount; $GrnNewUnit = $GrnNewUnit + $EAmount ; echo "
|---|---|---|---|---|
| ".$lineModel." | "; echo "".$rowUnitCount." | "; echo "".number_format($nAmount,2,'.',',')." | "; echo "".number_format($BAmount,2,'.',',')." | "; echo "".number_format($EAmount,2,'.',',')." | "; echo "
| GRAND TOTAL | "; echo "".$GrnTotalItemCount." | "; echo "".number_format($GrnlessNinety,2,'.',',')." | "; echo "".number_format($GrnbetweenNinetyOneEighty,2,'.',',')." | "; echo "".number_format($GrnNewUnit,2,'.',',')." | "; echo "
Prepared by:_______________________
";
echo "Date Prepared: ".date("m/d/Y")." ".date('h:i a')."
"; echo "