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

$uReg = $_REQUEST['uReg'];  
 
//======================================================================
//=========================================================
if($uReg == 10241024){
     $regErrorCode = 0;
	$regiID= addslashes($_REQUEST['regEmpID']);
    $regFName= addslashes($_REQUEST['regFName']);
	$regLName= addslashes($_REQUEST['regLName']);
	$regMobileA= addslashes($_REQUEST['regMobileA']);
	$regMobileB= addslashes($_REQUEST['regMobileB']);
	$regEmail= addslashes($_REQUEST['regEmail']);
	$regCompany= addslashes($_REQUEST['regCompany']);
	$regDealership= addslashes($_REQUEST['regDealership']);
	$regPosition=addslashes($_REQUEST['regPosition']);
	$regPasswordA= addslashes($_REQUEST['regPasswordA']);
	$MyregPasswordA = md5($regPasswordA);
	$regPasswordB= addslashes($_REQUEST['regPasswordB']);
	$MyregPasswordB = md5($regPasswordB);
	
	$myFrame="<iframe src=\"https://api.qrserver.com/v1/create-qr-code/?size=100x100&data=".$regiID.":".$regFName." ".$regLName. ":".$regCompany." frameborder =\"no\" scrolling=\"no\"></iframe>";
	$myFrame = mysql_real_escape_string($myFrame);
	$checkIfEMPIDExist = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `u_name`='$regiID'"),0);
	if($checkIfEMPIDExist != 0){
	    $status = "Username already exist.";
        $regErrorCode =  $regErrorCode + 1;
	     $json = json_encode(['Status'=>$status,'username' => $regiID, 'REgCode'=>'REGISTRATION FAILED', 'Password' =>'hidden', 'Mobile'=>$regMobileA, 'email'=>$regEmail]);
	   
	    
	} else {
    	if($MyregPasswordA != $MyregPasswordB){
    	   	$status = "Your password didn't match.";
    		$json = json_encode(["status" => "$status", "errorCode" => '0']); 
    	    $regErrorCode =  $regErrorCode + 1;
    	    $json = json_encode(['Status'=>$status,'username' => $regiID, 'REgCode'=>'REGISTRATION FAILED', 'Password' =>'hidden', 'Mobile'=>$regMobileA, 'email'=>$regEmail]);    
    	}
    	if($regiID === '' || $regFName ==='' || $regLName ==='' || $regMobileA ==='' || $regEmail ==='' || $regDealership ==='' || $regCompany ==='' || $regPosition ==='' || $regPasswordA ===''){
    	   	$status = "Incomplete information.";
    		$json = json_encode(["status" => "$status", "errorCode" => '1']); 
    	     $regErrorCode =  $regErrorCode + 1;
    	     $json = json_encode(['Status'=>$status,'username' => $regiID, 'REgCode'=>'REGISTRATION FAILED', 'Password' =>'hidden', 'Mobile'=>$regMobileA, 'email'=>$regEmail]);
    	}
    	

    	    if($regErrorCode == 0){
    			$sql = "INSERT INTO vts_users (employee_id, company, dealer, u_name,u_fname, u_lname, u_position, email, u_password, u_password2, u_status, account_type, access_right, date, usr_mobile,mobileTwo, u_locked,`long`) VALUES('$regiID', '$regCompany','$regDealership','$regiID','$regFName','$regLName','$regPosition','$regEmail','$MyregPasswordA','$MyregPasswordB','0', 'user','', '$toDate', '$regMobileA','$regMobileB','1','$myFrame')";
    			$sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.');
    			
    		 
    		   
    		   $getUserID = mysql_result(mysql_query("SeLECT `u_id` FROM `vts_users` WHERE `u_name`='$regiID'"),0);
    		   
    		   $getUserBrand = mysql_result(mysql_query("SeLECT `brand` FROM `vts_company` WHERE `comp_id`='$regCompany'"),0);
    		   $getUserBrandID = mysql_result(mysql_query("SeLECT `b_id` FROM `vts_brands` WHERE `b_name`='$getUserBrand'"),0);
    		   
    		    
    		$status =  " Please take note of the following information below while we are validating your request.  Thank you!";
    		   $json = json_encode(['Status'=>$status,'username' => $regiID, 'REgCode'=>'REGISTRATION COMPLETE', 'Password' =>'*********', 'Mobile'=>$regMobileA, 'email'=>$regEmail]);
$registrationMessage ="Thank you!   

You have successfully registered to AUTOHUB CONNECT.  Please take note of the following information:
    
    Your Username: ".$regiID."
    Your Password: ".$regPasswordA."
    Registered E-mail: ".$regEmail."
    
    Please wait your Admin to Activate your account
    
    Thank you.
    
    
    From Support Group";
mail($regEmail,'USER REGISTRATION',$registrationMessage, 'From: support@autohubgroup.com');
    	    }

	}
    
} 
 

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