";
echo "
| BRAND/MODEL |
YEAR MODEL |
COLOR |
CS # |
UNIT DESCRIPTION |
STATUS |
S. PRICE |
DATE RECEIVED |
AGING |
SELLING DEALER |
UNIT LOCATION |
ACTION |
REF# |
";
while($row=mysql_fetch_array($result)){
$brand=$row['brand'];
$ifSold =$row['sold'];
$ifReturned =$row['returned'];
$chkInMyAccess = mysql_result(mysql_query("SELECT COUNT('id') FROM `brand_access` WHERE `user_id`='$empID' AND `brand_name`='$brand'"),0);
if($chkInMyAccess < 1){
//echo $chkInMyAccess;
}else{
if($row['reserved']==0 && $row['incoming_unit']==0){
$incomoing = 0;
$status= "Available";
$txtColor='Black';
}else if($row['reserved']==1 && $row['incoming_unit']==0){
$status= "Reserved";
$incomoing = 0;
$txtColor=' #0c5bdc';
}else{
$status= "Incoming";
$txtColor='#ec6209';
$incomoing = 1;
}
if($ifSold ==1 || $ifReturned==1){
//==========================================================================================================
?>".$row['brand_code']."";
echo "| ".$row['year_model']." | ";
echo "".$row['color']." | ";
echo "".$row['cs_number']." | ";
echo "".$row['description']." | ";
echo "";
echo $row['status'];
echo" | ";
echo " ".number_format($row['price'],2,'.',',')." | ";
echo "".$row['date_received']." | ";
echo "";
$olddate = $row['date_received'];
$now = $row['date_released']; // or your date as well
$your_date = strtotime($olddate);
$Sold_date = strtotime($now);
$datediff = $Sold_date - $your_date;
$totalCount = round($datediff / (60 * 60 * 24));
if($datediff == 1){
$MyDay="Day";
}else{
$MyDay="Days";
}
echo "".round($datediff / (60 * 60 * 24)) ." ".$MyDay."";
echo" | ";
echo "".$row['selling_dealer']." | ";
echo "".$row['unit_location']." | ";
echo "";
echo "Unit Not Available";
echo " | ";
echo "".$row['id']." | ";
echo "
";
//==========================================================================================================
}else{
?>".$row['brand_code']."";
echo "| ".$row['year_model']." | ";
echo "".$row['color']." | ";
?> | ".$row['description']."";
echo "";
echo $row['status'];
echo" | ";
echo "".number_format($row['price'],2,'.',',')." | ";
echo "".$row['date_received']." | ";
echo "";
$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($datediff == 1){
$MyDay="Day";
}else{
$MyDay="Days";
}
echo "".round($datediff / (60 * 60 * 24)) ." ".$MyDay."";
echo" | ";
echo "".$row['selling_dealer']." | ";
echo "".$row['unit_location']." | ";
echo "";
if($status != 'Incoming'){
if($row['reserved']==0){
echo " |";
echo "";
}else{
echo "|";
echo "";
}
}else{
echo "";
}
echo " | ";
echo "".$row['id']." | ";
echo "
";
//==========================================================================================================
}
}
}
echo "
";
exit();
} 