aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_selfcheckin_add_guests
Parameters
Name
Type
Mode
i_register_id
integer
IN
i_guest_ids
int4[]
IN
i_user
text
IN (DEFAULT NULL)
Definition
DECLARE v_booking_id int; v_primary int; v_added int; BEGIN SELECT booking_id, guest_id INTO v_booking_id, v_primary FROM registration WHERE id = i_register_id; INSERT INTO register_guests (register_id, guest_id) SELECT i_register_id, g FROM unnest(i_guest_ids) g WHERE g <> v_primary ON CONFLICT DO NOTHING; GET DIAGNOSTICS v_added = ROW_COUNT; IF v_booking_id IS NOT NULL THEN UPDATE booking_guests bg SET registered = true, register_id = i_register_id WHERE bg.booking_id = v_booking_id AND bg.guest_id = ANY(i_guest_ids); END IF; RETURN v_added; END