aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_endday_check_auto_post
Parameters
Name
Type
Mode
status
text
INOUT
msg
text
INOUT
details
jsonb
INOUT
Definition
BEGIN WITH unposted as ( SELECT distinct cs.register_id as id, rm.room_number, g.full_name AS name, cs.arrival, cs.departure FROM sp_get_charge_schedule(post_date => fn_system_date(), posted => false) cs LEFT JOIN room rm ON rm.id = cs.room_id LEFT JOIN registration rg on rg.id = cs.register_id LEFT JOIN guest g on g.id = rg.guest_id ORDER BY room_number ) SELECT jsonb_agg(unposted) FROM unposted INTO details; status := iif(details IS NULL, 'success', 'error'); IF details IS NOT NULL THEN RAISE EXCEPTION SQLSTATE '90004' USING MESSAGE = 'There are unposted auto-charges', DETAIL = details; END IF; END;