<?php
date_default_timezone_set('Asia/Manila');
header('Content-Type: application/json');
 
$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(). '.');
 
$model= $_REQUEST['modelKey'];  
$brand= $_REQUEST['BrandName'];  
 
//======================================================================================================================================================================================================================================
if($model==1024091107210622){
mysql_query("DROP TABLE IF EXISTS `tempInventoryByModel`"); 

$sql = "CREATE TABLE IF NOT EXISTS `tempInventoryByModel` (`invID` int(11) NOT NULL AUTO_INCREMENT, `model_name` varchar(30) NOT NULL, `available_stock` varchar(7) NOT NULL, `reserved_stsock` varchar(7) NOT NULL, `incoming_stock` varchar(7) NOT NULL, `total_stock` varchar(7) NOT NULL,PRIMARY KEY (`invID`))";
	
	$bid = mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name`='$brand'"),0);
	
    $sqlResponse = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.');
    
    $sql = "SELECT * FROM vts_model WHERE b_id = '$bid' ORDER BY m_name DESC ";
    	$sqlTable = mysql_query($sql, $conn);
	
	
	while($invRecord = mysql_fetch_assoc($sqlTable))
	{
	    $brandCode = $invRecord['m_name'];
	    $TotalCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand_code`='$brandCode' AND `sold`=0 AND `returned`=0"),0);
	    $TotalAvailavle = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand_code`='$brandCode' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 0"),0);
	    $TotalReserved = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand_code`='$brandCode' AND `sold`=0 AND `returned`= 0 AND `reserved`= 1"),0);
	    $TotalIncoming = mysql_result(mysql_query("SELECT COUNT('id') FROM `db_vehicle_inventory` WHERE `brand_code`='$brandCode' AND `sold`=0 AND `returned`= 0 AND `reserved`= 0 AND `incoming_unit`= 1"),0);
	     
	    
	    
	    	$sql = "INSERT INTO tempInventoryByModel (model_name, available_stock, reserved_stsock, incoming_stock, total_stock) VALUES('$brandCode', '$TotalAvailavle', '$TotalReserved', '$TotalIncoming', '$TotalCount')";
			$sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.');
		
 	}
     $return_ar = Array();
	$sql = "SELECT * FROM tempInventoryByModel WHERE model_name !='' ORDER BY model_name ASC";
	$brandLogo=mysql_result(mysql_query("SELECT `logo` FROM `vts_brands` WHERE `b_name`='$brand'"),0);
	$sqlTable = mysql_query($sql, $conn);
		while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{ 
        $return_ar[]= $sqlRecord;
       
	}
	$json = json_encode([$return_ar, "brandLogo" => $brandLogo]);
}
//========================================================================================================================================================== 

 

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