<?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("Y/m/d");
 

$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(). '.');
 
$reqDealerID= $_REQUEST['reqDealerID']; // Expect LoginName, LoginPassword
$selCompID = $_REQUEST['selCompID'];  
if($reqDealerID == 721622911){
    
     $sql = "SELECT deal_id, comp_id, deal_code, deal_name FROM vts_dealerships WHERE  comp_id='$selCompID' ORDER BY `deal_name` ASC";    
    
   $return_dir = Array();
	$sqlTable = mysql_query($sql, $conn);
		while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{ 
        
        $return_dir[]= $sqlRecord;
       
	}
    $json = json_encode($return_dir);
} 

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