<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";
    
    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if ($data->failflag == "Y") {
        $sql = "UPDATE xxytysport.xx_sp_user_details
                   SET log_tried = NVL(log_tried,0)+1,
                       locked_date = case when (NVL(log_tried,0)+1) >= 5 then sysdate else null end 
                 WHERE upper(user_id) = upper(:email_id)";
    } else {
        $sql = "UPDATE xxytysport.xx_sp_user_details
                   SET log_tried = 0,
                       locked_date = null 
                 WHERE upper(user_id) = upper(:email_id)";
    }

    $sqlarr = oci_parse($dbcon , $sql);
    oci_bind_by_name($sqlarr, ':email_id', $data->userid);
    $r = oci_execute($sqlarr);

    if (!$r) {
        $e = oci_error($sqlarr);
        $errorMsg = json_encode($e['message']);
    }

    $result = [];
    if ($errorMsg == "") {

        $result[] = [
            "message" => "Success",
            "id" => $data->userid
        ];

    } else {

        $result[] = [
            "message" => $errorMsg,
            "id" => ""
        ];

    }
    print json_encode($result);
?>