aonestar.public

Parameters

Name	Type	Mode
i_register_id	integer	IN
i_folio_item_id	integer	IN
i_booking_id	integer	IN
i_guest_id	integer	IN
i_url	text	IN
i_path	text	IN
i_user	text	IN (DEFAULT NULL)

Definition

DECLARE
    v_id bigint;
BEGIN
    PERFORM sp_error_if(num_nonnulls(i_register_id, i_folio_item_id, i_booking_id) <> 1,
                        '99', 'sp_save_signature: must specify exactly one of register_id/folio_item_id/booking_id');

IF i_register_id IS NOT NULL THEN
        INSERT INTO public.guest_signature (register_id, guest_id, signature_url, signature_path, signed_user)
        VALUES (i_register_id, i_guest_id, i_url, i_path, i_user)
        ON CONFLICT (register_id, guest_id) WHERE register_id IS NOT NULL
        DO UPDATE SET signature_url = EXCLUDED.signature_url, signature_path = EXCLUDED.signature_path,
                      signed_time = now(), signed_user = EXCLUDED.signed_user
        RETURNING id INTO v_id;
    ELSIF i_folio_item_id IS NOT NULL THEN
        INSERT INTO public.guest_signature (folio_item_id, guest_id, signature_url, signature_path, signed_user)
        VALUES (i_folio_item_id, i_guest_id, i_url, i_path, i_user)
        ON CONFLICT (folio_item_id, guest_id) WHERE folio_item_id IS NOT NULL
        DO UPDATE SET signature_url = EXCLUDED.signature_url, signature_path = EXCLUDED.signature_path,
                      signed_time = now(), signed_user = EXCLUDED.signed_user
        RETURNING id INTO v_id;
    ELSE
        INSERT INTO public.guest_signature (booking_id, guest_id, signature_url, signature_path, signed_user)
        VALUES (i_booking_id, i_guest_id, i_url, i_path, i_user)
        ON CONFLICT (booking_id, guest_id) WHERE booking_id IS NOT NULL
        DO UPDATE SET signature_url = EXCLUDED.signature_url, signature_path = EXCLUDED.signature_path,
                      signed_time = now(), signed_user = EXCLUDED.signed_user
        RETURNING id INTO v_id;
    END IF;
    RETURN v_id;
END