<?php
date_default_timezone_set('Asia/Manila');
header('Content-Type: application/json');
$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(). '.');
 
$key = $_REQUEST['key']; 

if($key == '5463358374534'){
	$username = $_REQUEST['username'];
	$username = mysql_real_escape_string($username);
	$password = $_REQUEST['password'];
	$md5_password = md5($password);

	
	$user_generic_query = user_generic_query();
	$fields = " SELECT u.*,
			c.comp_id as company_id,
			c.comp_name as company,
			c.comp_code as company_code,
			d.deal_id as dealer_id,
			d.deal_name as dealer,
			d.deal_code as dealer_code ";
	$query = $user_generic_query."
			AND (u.u_name = '%s' OR u.employee_id = '%s') 
			AND u.u_password = '%s'
	";
	
	$query_formatted = sprintf($query,$fields,$username,$username,$md5_password);
	 
//	 echo $query_formatted;exit;
	$sql_obj = mysql_query($query_formatted, $conn);
	$sql_arr = array();
	while($sql__arr = mysql_fetch_assoc($sql_obj))
	{ 
		$sql_arr = $sql__arr;
	}
	
    if(count($sql_arr) > 0){
        $sql_arr['api_status'] = 1;
    }else{
         $sql_arr['api_status'] = 0;
    }
 echo json_encode($sql_arr);
	
			
			
}else if($key == '54633343444223'){
	$asa_id = $_REQUEST['id']; 

	
	$user_generic_query = user_generic_query();
	$fields = " SELECT u.*,
			c.comp_id as company_id,
			c.comp_name as company,
			c.comp_code as company_code,
			d.deal_id as dealer_id,
			d.deal_name as dealer,
			d.deal_code as dealer_code ";
			
	$query = $user_generic_query."
			AND u.u_id = '%s'
	";
	
	$query_formatted = sprintf($query,$fields,$asa_id);
	 
	$sql_obj = mysql_query($query_formatted, $conn);
	$sql_arr = array();
	while($sql__arr = mysql_fetch_assoc($sql_obj))
	{ 
		$sql_arr = $sql__arr;
	}
	
    if(count($sql_arr) > 0){
        $sql_arr['api_status'] = 1;
    }else{
         $sql_arr['api_status'] = 0;
    }
 echo json_encode($sql_arr);

			
}

function user_generic_query(){
	return " %s
			FROM `vts_users` u
			LEFT OUTER JOIN vts_dealerships d
			ON u.dealer = d.deal_id
			LEFT OUTER JOIN vts_company c
			ON d.comp_id = c.comp_id
			WHERE 1 ";
}

?>