aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_seven_days_forecast_js
Parameters
Name
Type
Mode
start_date
date
IN (DEFAULT fn_system_date())
Definition
select json_build_object('data', ( --with forecast as ( select json_agg(json_build_object( 'row_name', row_name, to_char(start_date, 'Dy DD/MM/YYYY'), day1, to_char(start_date+1, 'Dy DD/MM/YYYY'), day2, to_char(start_date+2, 'Dy DD/MM/YYYY'), day3, to_char(start_date+3, 'Dy DD/MM/YYYY'), day4, to_char(start_date+4, 'Dy DD/MM/YYYY'), day5, to_char(start_date+5, 'Dy DD/MM/YYYY'), day6, to_char(start_date+6, 'Dy DD/MM/YYYY'), day7 )) from sp_seven_days_forecast(start_date) ) ) -- select "date", arr_total as arrival, dep_total as departure, inh_total as in_house, occ_overall, occ_actual -- from sp_occupancy_forecast(start_date, start_date+6) --) --select json_agg(forecast) from forecast