aonestar.public

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

sp_today_stat_js

Parameters

Definition