<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if (!empty($data)) {

        $sql = "SELECT a.user_id, 'clinic' account_type, b.clinic_name as user_name, 
                       case when trunc(sysdate) > trunc(a.password_expired) then 'Y' else 'N' end reset_flag 
                  FROM ytycustom.medical_user_account a,
                       ytycustom.medical_clinic_master b
                 WHERE a.clinic_id = b.id
                   AND upper(a.user_id) = upper(:user_id)
                   AND upper(a.user_password) = upper(dbms_obfuscation_toolkit.md5(input => UTL_RAW.cast_to_raw(:user_pass)))
                UNION
                SELECT a.logon_name as user_id, 'employee' account_type, b.employee_name as user_name, 'N' reset_flag
                  FROM ytycustom.user_registry a,
                       production.employee_master b
                 WHERE a.logon_name = b.emp_id
                   AND a.account_status = 'ENABLED'
                   AND upper(a.logon_name) = upper(:user_id)
                   AND upper(a.pass_md5) = upper(dbms_obfuscation_toolkit.md5(input => UTL_RAW.cast_to_raw(:user_pass)))";

        if (empty($data->USER_ID->ID)) {
            $userid = $data->USER_ID;
        } else {
            $userid = $data->USER_ID->ID;
        }

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':user_id', $userid);
        oci_bind_by_name($sqlarr, ':user_pass', $data->USER_PASSWORD);
        $r = oci_execute($sqlarr);
        oci_fetch_all($sqlarr, $rows_main, null, null, OCI_FETCHSTATEMENT_BY_ROW);
        
        if (count($rows_main) >= 1) {
            $resMsg = "OK";
        } else {
            $resMsg = "Invalid User ID or Password";
        }

    } else {
        $resMsg = "Invalid request.";
    }

    $result[] = [
        "message" => $resMsg,
        "data" => $rows_main
    ];

    print json_encode($result);
?>