format("Y/m/d");
if(isset($_POST['Display'])){
$brandName = mysql_real_escape_string($_POST['brandName']);
$MyUserID = mysql_real_escape_string($_POST['MyUserID']);
$UserCompanyName =mysql_real_escape_string($_POST['UserCompanyName']);
$myCompanyID = mysql_result(mysql_query("SELECT `company` FROM `vts_users` WHERE `u_id`='$MyUserID'"),0);
$userFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$MyUserID'"),0);
$userLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$MyUserID'"),0);
//echo "My Lastname is:" .$userLName;
$myLabel = $brandName;
$getData = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `sold`='0' AND `returned`='0' AND `incoming_unit` = '0' AND `company`='$UserCompanyName' AND `brand`='$brandName'");
}else{
//GROUP WIDE
$myLabel ="Autohub Wide";
$getData = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `sold`='0' AND `returned`='0' AND `incoming_unit` = '0'");
}
while($row=mysql_fetch_array($getData)){
$olddate = $row['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){
$lessNinety = $lessNinety + 1;
$lessNinetyAmount = $lessNinetyAmount + $row['price'];
}
if ($totalCount > 90 && $totalCount < 181){
$betweenNinetyOneEighty = $betweenNinetyOneEighty + 1;
$betweenNinetyOneEightyAmount = $betweenNinetyOneEightyAmount + $row['price'];
}
if ($totalCount > 180 ){
$oldestUnit = $oldestUnit + 1;
$oldestUnitAmount = $oldestUnitAmount + $row['price'];
}
$total = $oldestUnit + $lessNinety + $betweenNinetyOneEighty;
$totalB = $lessNinetyAmount + $betweenNinetyOneEightyAmount + $oldestUnitAmount;
}
$EarlyCount = number_format(($lessNinety / $total * 100),2,'.',',');
$MidCount = number_format(($betweenNinetyOneEighty / $total * 100),2,'.',',');
$LateCount = number_format(($oldestUnit / $total * 100),2,'.',',');
$EarlyCountB = number_format(($lessNinetyAmount / $totalB * 100),2,'.',',');
$MidCountB = number_format(($betweenNinetyOneEightyAmount / $totalB * 100),2,'.',',');
$LateCountB = number_format(($oldestUnitAmount / $totalB * 100),2,'.',',');
?>
Account has been activated
DASHBOARD VIEW