aonestar.public

Parameters

Name	Type	Mode
log_user	text	IN
log_type	character	IN
room_id	integer	IN
register_id	integer	IN
booking_id	integer	IN
valid_from	timestamp without time zone	IN
valid_until	timestamp without time zone	IN
card_serial	text	IN (DEFAULT NULL)
card_index	integer	IN (DEFAULT NULL)
card_qty	integer	IN (DEFAULT 1)
log_time	timestamp with time zone	IN (DEFAULT CURRENT_TIMESTAMP)

Definition

declare
    v_msg_text TEXT;
    v_sqlstate TEXT;
    v_detail   TEXT;
    v_hint     TEXT;
    v_context  TEXT;
begin
	if (register_id is not null) and (booking_id is null) then
		booking_id := (select r.booking_id from registration r where r.id = $4);
	end if;

	INSERT INTO intf_keycard_logs (log_type, room_id, register_id, booking_id, card_serial, card_index, valid_from, valid_until, card_qty, log_time, log_user)
	VALUES(log_type, room_id, register_id, booking_id, card_serial, card_index, valid_from, valid_until, card_qty, log_time, log_user);
    RETURN fn_result_success();
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_save_keycard_log', 
        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
        )
    );
end;