<?php
date_default_timezone_set('Asia/Manila');
header('Content-Type: application/json');
error_reporting(0);
$sqlUser = 'autoph_arnel';
$sqlDatabase = 'autoph_connect';
$sqlPass = 'Hke@2001';
$toDate = date_create() ->format("m/d/Y"); // for viewing date only
 $myDate ="As of ".$toDate;

$conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.');
$db =  mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.');

$keyID= $_REQUEST['keyID'];  
$brandID= $_REQUEST['brandID'];  
$modelID= $_REQUEST['modelID']; 
$ModelColor= $_REQUEST['ModelColor'];  
$byVariant= $_REQUEST['VehicleVariant'];
 
//======================================================================
 $brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='$brandID'"),0);
 if($modelID ==''){
     $modelName="NA";
 }else{
    $modelName = mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE `m_id`='$modelID'"),0);
 }
if($keyID==10246222018){ 
       
   $brandCountOld = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand`='$brandName' AND `incoming_unit`= 0"),0);
   $brandCountNew = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand`='$brandName' AND `incoming_unit`=1"),0);
   $brandLogo = mysql_result(mysql_query("SELECT `logo` FROM `vts_brands` WHERE `b_name`='$brandName'"),0);
   
    $brand=$brandName;
    $model=$modelDesc;
    $color = $ModelColor;
    
    $checkTotal = $brandCountOld + $brandCountNew;
    if($checkTotal < 3 ){
        $QTYNotes ="AVAILABLE:  But limited stocks";
    }
    if($checkTotal > 2 ){
        $QTYNotes ="AVAILABLE:  Please call us for reservation ";
    }
    if($checkTotal == 0 ){
        $QTYNotes ="INCOMING:  Ready within a few weeks";
    }
    
    
    $json = json_encode(["TotalCountOld"=>$brandCountOld,"TotalCountNew"=>$brandCountNew,"Brand"=>$brand,"Model"=>$modelName,"Color"=>$color,"Logo"=>$brandLogo,"QNotes" =>$QTYNotes]);
    
} 
if($keyID==12233344441234){ 
    
   $ModelCountOld =  mysql_result(mysql_query("SELECT COUNT(`id`) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand`='$brandName' AND `incoming_unit`=0 AND `brand_code`='$modelName'"),0);
   $ModelCountNew = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand`='$brandName' AND `incoming_unit`=1 AND `brand_code`='$modelName'"),0);
   $brandLogo = mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$modelName'"),0);
   $modelCatalog = mysql_result(mysql_query("SELECT `catalog_link` FROM `vts_model` WHERE `m_name`='$modelName'"),0);
    $color = $ModelColor;
    $color = $ModelColor;
    $checkTotal = $ModelCountOld + $ModelCountNew;
    if($checkTotal < 3 ){
        $QTYNotes ="AVAILABLE:  But limited stocks";
    }
    if($checkTotal > 2 ){
        $QTYNotes ="AVAILABLE:  Please call us for reservation ";
    }
    if($checkTotal == 0 ){
        $QTYNotes ="INCOMING:  Ready within a few weeks";
    }
 
    $json = json_encode(["TotalCountOld"=>$ModelCountOld,"TotalCountNew"=>$ModelCountNew,"Brand"=>$brandName,"Model"=>$modelName,"Color"=>$color,"Logo"=>$brandLogo,"Catalog"=>$modelCatalog,"QNotes" =>$QTYNotes]);
    
}
if($keyID==24242233344441234){ 
    
   $ModelCountOld =  mysql_result(mysql_query("SELECT COUNT(`id`) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand`='$brandName' AND `incoming_unit`=0 AND `brand_code`='$modelName' AND `color`='$ModelColor'"),0);
   $ModelCountNew = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand`='$brandName' AND `incoming_unit`=1 AND `brand_code`='$modelName' AND `color`='$ModelColor'"),0);
   $brandLogo = mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$modelName'"),0);
    $brand=$brandName;
    $model=$modelName;
    $color = $ModelColor;
  
    $brand=$brandName;
    $model=$modelName;
    $color = $ModelColor;
    $checkTotal = $ModelCountOld + $ModelCountNew;
    if($checkTotal < 3 ){
        $QTYNotes ="AVAILABLE:  But limited stocks";
    }
    if($checkTotal > 2 ){
        $QTYNotes ="AVAILABLE:  Please call us for reservation ";
    }
    if($checkTotal == 0 ){
        $QTYNotes ="INCOMING:  Ready within a few weeks";
    }
    $json = json_encode(["TotalCountOld"=>$ModelCountOld,"TotalCountNew"=>$ModelCountNew,"Brand"=>$brand,"Mdoel"=>$model,"Color"=>$color,"Logo"=>$brandLogo,"QNotes" =>$QTYNotes]);
    
}

if($keyID==242422330000344441234){ 
    
   $ModelCountOld =  mysql_result(mysql_query("SELECT COUNT(`id`) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand`='$brandName' AND `incoming_unit`=0 AND `brand_code`='$modelName' AND `color`='$ModelColor' AND `description`='$byVariant'"),0);
   $ModelCountNew = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `db_vehicle_inventory` WHERE `sold`=0 AND `returned`=0 AND `brand`='$brandName' AND `incoming_unit`=1 AND `brand_code`='$modelName' AND `color`='$ModelColor' AND `description`='$byVariant'"),0);
   $brandLogo = mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$modelName'"),0);
   
    $brand=$brandName;
    $model=$modelName;
    $color = $ModelColor;
    $Variant = $byVariant;
      $checkTotal = $ModelCountOld + $ModelCountNew;
    if($checkTotal < 3 ){
        $QTYNotes ="AVAILABLE:  But limited stocks";
    }
    if($checkTotal > 2 ){
        $QTYNotes ="AVAILABLE:  Please call us for reservation ";
    }
    if($checkTotal == 0 ){
        $QTYNotes ="INCOMING:  Ready within a few weeks";
    }
    $json = json_encode(["TotalCountOld"=>$ModelCountOld,"TotalCountNew"=>$ModelCountNew,"Brand"=>$brand,"Mdoel"=>$model,"Color"=>$color,"Logo"=>$brandLogo,"Variant"=>$Variant,"QNotes" =>$QTYNotes]);
    
}
 

if($did_something === 0)
{
	$msg = did_nothing_message;
	$json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]);
}
echo $json;
 
 
?>