aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_selfcheckin_release_room
Parameters
Name
Type
Mode
i_room_id
integer
IN
i_user
text
IN (DEFAULT NULL)
i_match_user
boolean
IN (DEFAULT true)
Definition
BEGIN IF EXISTS (SELECT 1 FROM out_of_order o JOIN ooo_reason r ON r.id = o.reason_id WHERE o.room_id = i_room_id AND r.ref_code = 'SELFCHK' AND (NOT i_match_user OR i_user IS NULL OR o.create_user = i_user) AND fn_system_date() BETWEEN o.start_date AND o.end_date) THEN PERFORM sp_change_room_status(ARRAY[i_room_id], 'VAC', NULL, NULL, NULL, NULL, NULL, NULL, i_user); RETURN true; END IF; RETURN false; END