<?php
error_reporting(0);
$tz = 'Asia/Kolkata'; 
date_default_timezone_set($tz);
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
session_start();
include 'db.connect.php';
$date=date('Y-m-d H:i:s');
$dealer = $_POST['dealer'];
$mobile_no = $_POST['mobile_no'];
$addr = $_POST['addr'];
$city = $_POST['city'];
$state = $_POST['state'];
$country = $_POST['country'];
$pin_code = $_POST['pin_code'];
$dealer_id = $_SESSION['dealer_id'];
$get_cust = mysqli_query($conn, "SELECT * FROM shop_user where phone='$mobile_no' and dealer_id = '$dealer_id'");
$check_rows = mysqli_num_rows($get_cust);
$insert = "INSERT INTO shop_user(`password`, `name`, `phone`, `address`, `city`, `postcode`, `country`, `state`, `date`, `gst`,  `new_status`, `status`, `dealer_id`) values
('test@123','$dealer', '$mobile_no', '$addr', '$city', '$pin_code', '$country', '$state', '$date', 'GST', '0', '1', '$dealer_id')";
if($check_rows == 0){
if(mysqli_query($conn, $insert)){
    $last = mysqli_insert_id($conn);
    $user_name = 'drganbu-'.$last;
    $update = "UPDATE shop_user set username='$user_name' where user_id='$last'";
    mysqli_query($conn, $update);
    $arr = array('msg'=>'success', 'phone'=>base64_encode($mobile_no));
    echo json_encode($arr);
    exit;
}
}else{
    $arr = array('msg'=>'This phone number already exists with the dealer, please use the searchbox to select address');
    echo json_encode($arr);
    exit;
}
?>