<?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';

$registrations_table = 'vts_users';
$checkins_table = 'login_history';

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

//These functions are defined at the bottom.
//initialize_htaccess(); // make sure .htaccess file allows web services calls from anyone
//initialize_registrations(); //make sure registrations table has been created
//initialize_checkins(); //make sure checkins table has been created
$usrList= $_REQUEST['usrList']; // Expect LoginName, LoginPassword
$login = $_REQUEST['login']; // Expect LoginName, LoginPassword
$register = $_REQUEST['register'];//expect RegName, RegPassword
$insert = $_REQUEST['insert'];//Expects CheckinRegID, Lattitue, Longitude, HouseNo, Street, Zip
$select = $_REQUEST['select']; // Expects select = * or select = RegID

$getLeads = $_REQUEST['getLeads']; // Expects select = * or select = RegID
$chkList= addslashes($_REQUEST['chkList']); // Expects select = * or select = RegID
$did_something = 0;
//$did_nothing_message ="Valid Input Sets: [login,LoginName,LoginPassword]; [register,RegName,RegPassword]; [insert,CheckinRegID,Latitude,Longitude, HouseNo,Street,Zip];[select]";
//
  
if($chkList == 1)
{
	$MyCustomerID = addslashes($_REQUEST['MyCustomerID']);
	$customerType = addslashes($_REQUEST['customerType']);
	$return_arr = Array();
	if($customerType==='No'){
	    $sql = "SELECT * FROM vts_customers WHERE c_id = $MyCustomerID ORDER BY u_lname ASC LIMIT 1";
	}else{
	    $sql = "SELECT * FROM businesses_names WHERE bid = $MyCustomerID ORDER BY business_name ASC LIMIT 1";
	}
	
	$sqlTable = mysql_query($sql, $conn);
	while($sqlRecord = mysql_fetch_assoc($sqlTable))
	{
       $return_arr[]=$sqlRecord;
	  
	}
	$json = json_encode($return_arr);

	$did_something += 1;
}

 

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