<?php
include('include/headscript.php');

$conn = new mysqli($servername, $username, $password, $dbname);

$product = "12185"; // Sostituisci con il valore reale

$checkservice = "SELECT idservice
          FROM service
          WHERE FIND_IN_SET('$product', wpcatalognumber) > 0";

$result = $conn->prepare($checkservice);
$result->bind_param("s", $product);
$result->execute();
$result->store_result();

if ($result->num_rows > 0) {
    $result->bind_result($idservice);
    $result->fetch();
    $copyOrderItemyogi['idservice'] = $idservice;
} else {
    $copyOrderItemyogi['idservice'] = "0";
}

echo $copyOrderItemyogi['idservice'];

$email = "csironi@cesoft.io";
$first_name = "Claudio";
$last_name = "Sironi";
$auth_user_query = $conn->prepare("SELECT * FROM auth_users WHERE email = ?;");
$auth_user_query->bind_param("s", $email);
$auth_user_query->execute();
$auth_user_result = $auth_user_query->get_result();

if ($auth_user_result->num_rows === 0) {
    // If email doesn't exist, add it to auth_users
    $user_data = array(
        'email' => $email,
        'password' => '!Yogibook159',
        'first_name' => $first_name,
        'last_name' => $last_name,
        'role_id' => '2',
        'status' => 'Active'
    );
    
    $insert_query = "INSERT INTO auth_users (email, password, first_name, last_name, role_id, status, email_verified_at, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, NOW(), NOW(), NOW())";
    $insert_stmt = $conn->prepare($insert_query);
    $insert_stmt->bind_param("ssssss", $user_data['email'], $user_data['password'], $user_data['first_name'], $user_data['last_name'], $user_data['role_id'], $user_data['status']);
    $insert_stmt->execute();
} else {
    $idusercheck = '4';
}
if (isset($idusercheck)) {
    echo $idusercheck;
}
?>