aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_today_stat_js
Parameters
Name
Type
Mode
Definition
WITH RECAP AS ( SELECT COALESCE(total_rooms, 0) - COALESCE(ooi_rooms, 0) /* - COALESCE(ooo_rooms, 0) */ as total_rooms, COALESCE(occ_rooms, 0) as occ_rooms, COALESCE(expected_arrival, 0) as expected_arrival, COALESCE(expected_departure, 0) as expected_departure, COALESCE(arrival_rooms, 0) as arrival_rooms, COALESCE(departure_rooms, 0) as departure_rooms, COALESCE(walk_in_rooms, 0) as walk_in FROM sp_get_recapitulate() ), STAT AS ( SELECT json_build_object( 'value', fn_percent(occ_rooms, total_rooms), 'tonight', fn_percent(occ_rooms + expected_arrival - expected_departure, total_rooms) ) AS occupancy, json_build_object( 'value', expected_arrival, 'current', arrival_rooms, 'total', arrival_rooms + expected_arrival ) AS expected_arrival, json_build_object( 'value', expected_departure, 'current', departure_rooms - expected_departure, 'total', departure_rooms ) AS expected_departure, json_build_object( 'value', occ_rooms, 'tonight', occ_rooms + expected_arrival - expected_departure ) AS in_house, walk_in, ( SELECT count(*) FROM room_status rs WHERE rs.status = 'VAC' AND rs.hk_status = ANY(fn_sellable_statuses()) ) AS room_ready_to_sell FROM RECAP ) SELECT row_to_json(STAT) FROM STAT