<?php
include_once "../include/DB.php";

$userName = "";
$userPhoneNumber = "";
$userPassword = "";
$DEID="";

if (isset($_POST["name"]) && !empty($_POST["name"])) {
    $userName = $_POST["name"];
}
if (isset($_POST["phonenumber"]) && !empty($_POST["phonenumber"])) {
    $userPhoneNumber = $_POST["phonenumber"];
}
if (isset($_POST["password"]) && !empty($_POST["password"])) {
    $userPassword = $_POST["password"];
}
if (isset($_POST["DEID"]) && !empty($_POST["DEID"])) {
    $DEID = $_POST["DEID"];
}

$phoneNumberChecksql = "SELECT * FROM user WHERE PhoneNumber='$userPhoneNumber'";
$phoneNumberCheckresult = $conn->query($phoneNumberChecksql);

if ($phoneNumberCheckresult !== false && $phoneNumberCheckresult->num_rows > 0) {
    http_response_code(404);
    // Declare an array with error message 
    $value = array(
        "Message" => "Your signup failed. Entered phone number is exist",
        "Error" => "Entered phone number is exist"
    );
    // Use json_encode() function
    $json = json_encode($value);
} else {
    $userInsertSql = "INSERT INTO user(UserName, PhoneNumber, Password, DEID) VALUES ('$userName','$userPhoneNumber','$userPassword','$DEID')";
    $userInsertresult = $conn->query($userInsertSql);
    $UserID = $conn->insert_id;

    $raiderInsertSql = "INSERT INTO rider(RiderID, UserID) VALUES ('$userPhoneNumber','$UserID')";
    $raiderInsertresult = $conn->query($raiderInsertSql);

    $swapreferInsertSql = "INSERT INTO swaprefer(RiderID, TotalFreeSwapCount, UsedSwapCount, AvailableSwapCount) VALUES ('$userPhoneNumber','0','0','0')";
    $swapreferInsertresult = $conn->query($swapreferInsertSql);

    $swaprechargeInsertSql = "INSERT INTO swaprecharge(RiderID, TotalRechargedSwapCount, UsedSwapCount, AvailableSwapCount) VALUES ('$userPhoneNumber','0','0','0')";
    $swaprechargeInsertresult = $conn->query($swaprechargeInsertSql);

    $getUsersql = "SELECT UserID,UserName,PhoneNumber,CreatedAt AS UserCreatedAt,UpdatedAt AS UserUpdatedAt FROM user WHERE PhoneNumber='$userPhoneNumber' AND Password='$userPassword'";
    $getUserresult = $conn->query($getUsersql);

    if ($getUserresult !== false && $getUserresult->num_rows > 0) {
        $listArray = [];
        // output data of each row
        while ($getUserresultrow = $getUserresult->fetch_assoc()) {
            // Declare an array 
            $value = array(
                "UserID" => (int)$getUserresultrow["UserID"],
                "UserName" => $getUserresultrow["UserName"],
                "PhoneNumber" => $getUserresultrow["PhoneNumber"],
                "UserCreatedAt" => $getUserresultrow["UserCreatedAt"],
                "UserUpdatedAt" => $getUserresultrow["UserUpdatedAt"],
                "Message" => "Your signup successful"
            );

            $listArray[] = $value;
        }

        $count = count($listArray);

        if ($count == 1) {
            // Use json_encode() function
            $json = json_encode($listArray[0]);
        } else {
            // Use json_encode() function
            $json = json_encode($listArray);
        }
    }else {
        http_response_code(404);
        $errorMesage= $conn->error;
        // Declare an array with error message 
        $value = array(
          "Message"=>"Something went wrong",
          "Error"=>$errorMesage
        );
        // Use json_encode() function
        $json = json_encode($value);
    }
}
// Display the output
echo ($json);
$conn->close();