<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if (!empty($data)) {
        if ($data->act == "ACK") {
        
            $sql = " SELECT COUNT(*) CTR
                       FROM production.yty_visit_logs
                      WHERE VISIT_ID = :VISIT_ID
                        AND MEM_ID = :MEM_ID
                        AND ACK_TIME IS NULL";
            $sqlarr = oci_parse($dbcon , $sql);
            oci_bind_by_name($sqlarr, ':VISIT_ID', $data->visit_id);
            oci_bind_by_name($sqlarr, ':MEM_ID', $data->mem_id);
            $r = oci_execute($sqlarr);
            while ($row = oci_fetch_array($sqlarr)) {
                $exist = $row['CTR'];
            }

            if ($exist == "1") {
                
                $sql = "UPDATE production.yty_visit_logs
                           SET ACK_TIME = SYSDATE
                         WHERE VISIT_ID = :VISIT_ID
                           AND MEM_ID = :MEM_ID";

                $sqlarr = oci_parse($dbcon , $sql);
                oci_bind_by_name($sqlarr, ':VISIT_ID', $data->visit_id);
                oci_bind_by_name($sqlarr, ':MEM_ID', $data->mem_id);
                $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

                if (!$r) {
                    $e = oci_error($sqlarr);
                    $errorMsg = json_encode($e['message']);
                    goto finalStep;
                }
            } else {
                $errorMsg = "This guest already Acknowledged";
            }
        
        } else if ($data->act == "OUT") {
        
            $sql = " SELECT COUNT(*) CTR
                       FROM production.yty_visit_logs
                      WHERE VISIT_ID = :VISIT_ID
                        AND MEM_ID = :MEM_ID
                        AND TIME_OUT IS NULL";
            $sqlarr = oci_parse($dbcon , $sql);
            oci_bind_by_name($sqlarr, ':VISIT_ID', $data->visit_id);
            oci_bind_by_name($sqlarr, ':MEM_ID', $data->mem_id);
            $r = oci_execute($sqlarr);
            while ($row = oci_fetch_array($sqlarr)) {
                $exist = $row['CTR'];
            }

            if ($exist == "1") {

                //1 Day Visit, Acknowledge is Mandatory
                $sql = "SELECT CASE WHEN ((z.visit_to - z.visit_from)+1) = 1 THEN 
                                   CASE WHEN b.ack_time IS NOT NULL THEN
                                       'Y'
                                   ELSE
                                       'N'
                                   END
                               ELSE
                                   'Y'
                               END allow_checkout
                          FROM production.yty_visit_info z,
                               production.yty_visit_members a,
                               (SELECT * 
                                  FROM production.yty_visit_logs 
                                 WHERE TRUNC(time_in) = TRUNC(SYSDATE)) b
                         WHERE z.visit_id = a.visit_id
                           AND a.visit_id = b.visit_id(+)
                           AND a.mem_id = b.mem_id(+)
                           AND a.visit_id = :VISIT_ID
                           AND a.mem_id = :MEM_ID";
                $sqlarr = oci_parse($dbcon , $sql);
                oci_bind_by_name($sqlarr, ':VISIT_ID', $data->visit_id);
                oci_bind_by_name($sqlarr, ':MEM_ID', $data->mem_id);
                $r = oci_execute($sqlarr);
                while ($row = oci_fetch_array($sqlarr)) {
                    $allow_checkout = $row['ALLOW_CHECKOUT'];
                }

                if ($allow_checkout == "Y") {
                    //Get Badge Number
                    $sql = "SELECT BADGE_NUM
                              FROM yty_visit_members
                             WHERE VISIT_ID = :VISIT_ID
                               AND MEM_ID = :MEM_ID";
    
                    $sqlarr = oci_parse($dbcon , $sql);
                    oci_bind_by_name($sqlarr, ':VISIT_ID', $data->visit_id);
                    oci_bind_by_name($sqlarr, ':MEM_ID', $data->mem_id);
                    $r = oci_execute($sqlarr);
                    while ($row = oci_fetch_array($sqlarr)) {
                        $badge = $row['BADGE_NUM'];
                    }
    
                    //Mark Release
                    $sql = "UPDATE production.visitor_badge
                               SET IN_USE = null
                             WHERE visitor_badge_id = :badge";
    
                    $sqlarr = oci_parse($dbcon , $sql);
                    oci_bind_by_name($sqlarr, ':badge', $badge);
                    $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);
    
                    if (!$r) {
                        $e = oci_error($sqlarr);
                        $errorMsg = json_encode($e['message']);
                        goto finalStep;
                    }
                    
                    $sql = "UPDATE production.yty_visit_logs
                               SET TIME_OUT = SYSDATE
                             WHERE VISIT_ID = :VISIT_ID
                               AND MEM_ID = :MEM_ID";
    
                    $sqlarr = oci_parse($dbcon , $sql);
                    oci_bind_by_name($sqlarr, ':VISIT_ID', $data->visit_id);
                    oci_bind_by_name($sqlarr, ':MEM_ID', $data->mem_id);
                    $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);
    
                    if (!$r) {
                        $e = oci_error($sqlarr);
                        $errorMsg = json_encode($e['message']);
                        goto finalStep;
                    }
    
                    //Mark Complete
                    //Check remaining uncomplete
                    $sql = "SELECT COUNT(*) AS ctr
                              FROM production.yty_visit_members a, production.yty_visit_logs b
                             WHERE a.visit_id = b.visit_id(+)
                               AND a.mem_id = b.mem_id(+)
                               AND b.time_out IS NULL
                               AND a.visit_id = :visit_id";
    
                    $sqlarr = oci_parse($dbcon , $sql);
                    oci_bind_by_name($sqlarr, ':visit_id', $data->visit_id);
                    $r = oci_execute($sqlarr);
                    while ($row = oci_fetch_array($sqlarr)) {
                        $uncomplete = $row['CTR'];
                    }
    
                    if ($uncomplete == "0") {
                        $sql = "UPDATE production.yty_visit_info
                                   SET STATUS = 1
                                 WHERE visit_id = :visit_id";
    
                        $sqlarr = oci_parse($dbcon , $sql);
                        oci_bind_by_name($sqlarr, ':visit_id', $data->visit_id);
                        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);
    
                        if (!$r) {
                            $e = oci_error($sqlarr);
                            $errorMsg = json_encode($e['message']);
                            goto finalStep;
                        }
                    }

                } else {
                    $errorMsg = "Cannot proceed with Check-Out. This guest need to get acknowledge first.";
                }

            } else {
                $errorMsg = "This guest already Check-Out";
            }

        }

    } else {
        $errorMsg = "No data to save";
    } 

finalStep:
    $result = [];
    if ($errorMsg == "") {
        oci_commit($dbcon);
        $result[] = [
            "message" => "Success",
            "id" => $data->VISIT_ID
        ];
    } else {
        oci_rollback($dbcon);
        $result[] = [
            "message" => $errorMsg,
            "id" => ""
        ];
    }
    print json_encode($result);

?>