aonestar.public

Parameters

Name	Type	Mode
booking_id	integer	IN
user_name	text	IN (DEFAULT NULL)
result_code	text	OUT
result_msg	text	OUT
msg_code	text	OUT

Definition

DECLARE 
    _item_id int;
    _sqlstate TEXT;
    _detail   TEXT;
    _hint     TEXT;
    _context  TEXT;
    _msg_text TEXT;
    error json;
BEGIN 
    CALL sp_check_endday_process();
    CALL sp_check_record_lock(user_name, booking_id := $1);

    FOR _item_id IN 
        SELECT item_id FROM booking_items bi WHERE bi.booking_id = $1
    LOOP 
        SELECT sp.result_code, sp.result_msg, sp.msg_code
        FROM sp_unblock_rooms(_item_id, null, user_name) as sp
        INTO result_code, result_msg, msg_code;
    
        IF result_code = '4' THEN
            RETURN;
        END IF;
    END LOOP;

EXCEPTION  
    WHEN OTHERS THEN
    GET STACKED DIAGNOSTICS
        _sqlstate = RETURNED_SQLSTATE,
        _msg_text = MESSAGE_TEXT,
        _detail   = PG_EXCEPTION_DETAIL,
        _hint     = PG_EXCEPTION_HINT,
        _context  = PG_EXCEPTION_CONTEXT;    
    error := fn_handle_error(_sqlstate, _msg_text, _detail, _hint, _context, 'sp_unblock_all', 
                jsonb_build_object('booking_id', booking_id, 'user_name', user_name)
             );
    msg_code    := error->>'msg_code';
    result_code := error->>'result_code';
    result_msg  := error->>'result_msg';
END