<?php
date_default_timezone_set('Asia/Manila');
header('Content-Type: application/json');

 
//API.GEONAMES.ORG FOR THE API GEOLOCATION SERVICE
// /mysql_connect('localhost','autoph_portal','mis1541ng') or die ($connect_error);
$sqlUser = 'autoph_arnel';
$sqlDatabase = 'autoph_connect';
$sqlPass = 'Hke@2001';

 

$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(). '.');
 

$regPost = $_REQUEST['requestKey'];  

// 911721622

 
 if($regPost == '1024241010244'){
    $return_arr = Array();
	$sql = "SELECT * FROM `vts_brands` WHERE `b_status` = 1 ORDER BY `b_name` ASC";
	$sqlTable = mysql_query($sql, $conn);
	while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{
	    $return_arr[]=$sqlRecord;
	}
	
	$json = json_encode($return_arr);
	$did_something += 1;
 }
 
 if($regPost == '101010242424'){
    $brandID = $_REQUEST['brandID']; 
     
    $return_arr = Array();
	$sql = "SELECT * FROM `vts_model` WHERE `m_status` = 1 AND `b_id`='$brandID' ORDER BY `m_name` ASC";
	$sqlTable = mysql_query($sql, $conn);
	while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{
	    $return_arr[]= $sqlRecord;
	}
	 $brandImage = mysql_result(mysql_query("SELECT `logo` FROM `vts_brands` WHERE `b_id`='$brandID'"),0);
	  $brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='$brandID'"),0);
	$json = json_encode([$return_arr,"BrandImage"=>$brandImage,"BrandName"=>$brandName]);
	$did_something += 1;
 }
 
 
 if($regPost == 911721622){
   $modelID = mysql_real_escape_string($_REQUEST['modelName']);  
   $modelName =  mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE  `m_id`='$modelID' ORDER BY `m_name` ASC"),0);
    $return_arr = Array();
	$sql = "SELECT DISTINCT(`color`) FROM `db_vehicle_inventory` WHERE `brand_code` = '$modelName' ORDER BY `color` ASC";
	$sqlTable = mysql_query($sql, $conn);
	while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{
	    $return_arr[] = $sqlRecord;
	}
	$json = json_encode($return_arr);
	$did_something += 1;
 }
 
 if($regPost == 2110101024242422){
   $MyModelID = TRIM($_REQUEST['modelID']);  
   $brandCode = mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE `m_id`='$MyModelID'"),0); 
    
    $return_arr = Array();
	$sql = "SELECT DISTINCT(`description`) FROM `db_vehicle_inventory` WHERE `brand_code` = '$brandCode' ORDER BY `description` ASC";
	$sqlTable = mysql_query($sql, $conn);
	while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{
	    $return_arr[]=$sqlRecord;
	}
	 $modelImage = mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$brandCode'"),0);
	 
	$json = json_encode($return_arr);
	$did_something += 1;
 }

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