<?php
include '../../../cfg/ahaconn.php';
$mykey =$_GET['mKey'];
//STORE GUEST CHAT ATTEMP
if($mykey =="1a010101a10201020x2"){
    
    $chatID =$_GET['convoID'];
    $carBrand =$_GET['brandCode'];
    $carModel =$_GET['carModel'];
    $compCode =$_GET['compCode'];
    $yearmodel =$_GET['yearmodel'];
    $mileage =$_GET['mileage'];
    $mobile =$_GET['mobileNumber'];
    $email =$_GET['emailAddress'];
    $dp =$_GET['dp'];
    $myPlate =$_GET['myPlate'];
    $fullName =$_GET['fullName'];
    $userDateTimeV =$_GET['PrefDateTime'];
    $dt = explode("T",$userDateTime," ");
    $userDateTime = $dt[0] ." " . $dt[1];
    $interest = $_GET['interest'];
    $sql = "INSERT INTO bot_leads (`id`,`chat_id`,`comp_code`,`brand_code`,`car_model`,`full_name`,`interest` ,`mobile_no`,`email`,`test_drive_date`,`mileage`,`yearModel`,`downpayment`,`plate`)
    	VALUES ('','$chatID','$compCode','$carBrand','$carModel','$fullName','$interest','$mobile','$email','$userDateTime','$mileage','$yearmodel','$dp','$myPlate')";
     
    	if ($conn->query($sql) === TRUE) {
            $stat='success';	 
    	} else{
    	    $stat='error';
    	}
    	 // Output the result in JSON format
        header('Content-Type: application/json');
        echo json_encode(["userID" =>$mykey]);
} 
$conn->close();
?>