";
echo "
";
echo "
";
echo "
";
echo "";
echo "";
echo "
Date: ".date("m/d/Y").""; echo "
";
echo "VEHICLE INVENTORY REPORT
UNIT COST SUMMARY"; 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 BRAND | "; echo "COUNT | "; echo "TOTAL SRP | "; echo "TOTAL DISCOUNT | "; echo "TOTAL COMMISSION | "; echo ""; while($row=mysql_fetch_array($getData)){ echo "
|---|---|---|---|---|
| ".$row['brand_code']." | "; echo ""; $modelLine =$row['brand_code']; if($inc==0){ //INclude Incoming $itemCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `db_vehicle_inventory` WHERE `brand_code`='$modelLine' AND `sold`='0' AND `returned`='0' AND `incoming_unit`!='1'"),0); }else{ //Exclude Incoming $itemCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `db_vehicle_inventory` WHERE `brand_code`='$modelLine' AND `sold`='0' AND `returned`='0' "),0); } $totalCount = $totalCount + $itemCount; echo $itemCount; echo " | "; echo ""; $modelLine =$row['brand_code']; if($inc==0){ //INclude Incoming $modelCost = mysql_result(mysql_query("SELECT SUM(price) FROM `db_vehicle_inventory` WHERE `brand_code`='$modelLine' AND `sold`='0' AND `returned`='0' AND `incoming_unit`!='1' AND `company`='$filCompany' AND `brand`='$brand'"),0); }else{ //Exclude Incoming $modelCost = mysql_result(mysql_query("SELECT SUM(price) FROM `db_vehicle_inventory` WHERE `brand_code`='$modelLine' AND `sold`='0' AND `returned`='0' AND `company`='$filCompany' AND `brand`='$brand'"),0); } echo number_format($modelCost,2,'.',','); $modelCostTotal = $modelCostTotal + $modelCost; echo " | "; echo ""; $modelLine =$row['brand_code']; if($inc==0){ //INclude Incoming $modelDiscount = mysql_result(mysql_query("SELECT SUM(discount) FROM `db_vehicle_inventory` WHERE `brand_code`='$modelLine' AND `sold`='0' AND `returned`='0' AND `incoming_unit`!='1' AND `company`='$filCompany' AND `brand`='$brand'"),0); }else{ //Exclude Incoming $modelDiscount = mysql_result(mysql_query("SELECT SUM(discount) FROM `db_vehicle_inventory` WHERE `brand_code`='$modelLine' AND `sold`='0' AND `returned`='0' AND `company`='$filCompany' AND `brand`='$brand' "),0); } echo number_format($modelDiscount,2,'.',','); $modelDiscountTotal = $modelDiscountTotal + $modelDiscount; echo " | "; echo ""; $modelLine =$row['brand_code']; if($inc==0){ //INclude Incoming $modelCostComm = mysql_result(mysql_query("SELECT SUM(commission) FROM `db_vehicle_inventory` WHERE `brand_code`='$modelLine' AND `sold`='0' AND `returned`='0' AND `incoming_unit`!='1' AND `company`='$filCompany' AND `brand`='$brand'"),0); }else{ //Exclude Incoming $modelCostComm = mysql_result(mysql_query("SELECT SUM(commission) FROM `db_vehicle_inventory` WHERE `brand_code`='$modelLine' AND `sold`='0' AND `returned`='0' AND `company`='$filCompany' AND `brand`='$brand'"),0); } echo number_format($modelCostComm,2,'.',','); $modelCostCommTotal = $modelCostCommTotal + $modelCostComm; echo " | "; echo "
| GRAND TOTAL | "; echo "".$totalCount." | "; echo "".number_format($modelCostTotal,2,'.',',')." | "; echo "".number_format($modelDiscountTotal,2,'.',',')." | "; echo "".number_format($modelCostCommTotal,2,'.',',')." | "; echo "
Prepared by:_______________________
";
echo "Date Prepared: ".date("m/d/Y")." ".date('h:i a')."
"; echo "