aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_notify_minibar_status_change
Parameters
Name
Type
Mode
Definition
DECLARE v_room_number text; BEGIN SELECT room_number INTO v_room_number FROM public.room WHERE id = NEW.room_id; PERFORM sp_enqueue_realtime('*', fn_current_propcode(), 'minibar_status', json_build_object( 'room_id', NEW.room_id, 'room_number', v_room_number, 'minibar_status', NEW.minibar_status, 'minibar_status_user', NEW.minibar_status_user, 'minibar_status_time', NEW.minibar_status_time )); RETURN NEW; END