aonestar.public

Parameters

Name	Type	Mode
i_room_id	integer	IN (DEFAULT NULL)
i_register_id	integer	IN (DEFAULT NULL)
i_booking_id	integer	IN (DEFAULT NULL)

Definition

DECLARE
    v_result json;
    v_msg_text text;
    v_sqlstate text;
    v_detail text;
    v_hint text;
    v_context text;
BEGIN
    SELECT json_agg(
        jsonb_build_object(
            'log_user', log_user,
            'log_type', log_type,
            'room_id', room_id,
            'register_id', register_id,
            'booking_id', booking_id,
            'valid_from', valid_from,
            'valid_until', valid_until,
            'card_qty', card_qty,
            'card_serial', card_serial,
            'card_index', card_index,
            'log_time', log_time
        )
    ) INTO v_result
    FROM public.intf_keycard_logs
    WHERE (i_room_id IS NULL OR intf_keycard_logs.room_id = i_room_id)
    AND (i_register_id IS NULL OR intf_keycard_logs.register_id = i_register_id)
    AND (i_booking_id IS NULL OR intf_keycard_logs.booking_id = i_booking_id);
    
    -- Return empty array instead of null if no records found
    IF v_result IS NULL THEN
        v_result := '[]'::json;
    END IF;
   
     return fn_result_success(v_result);     
  --  RETURN result;
exception
    when others then
        get stacked diagnostics
            v_msg_text = message_text,
            v_sqlstate = returned_sqlstate,
            v_detail = pg_exception_detail,
            v_hint = pg_exception_hint,
            v_context = pg_exception_context;
            
        return fn_handle_error(
            v_sqlstate,
            v_msg_text,
            v_detail,
            v_hint,
            v_context,
            'sp_get_issue_card_log',
            null
        );
END;