aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_rate_comparison_js
Parameters
Name
Type
Mode
register_id
integer
IN
Definition
WITH summ AS ( SELECT sp_get_registration_summary_js(rg.id) AS actual, sp_get_checkin_summary_js(rg.booking_item, rg.room_id) AS booking, sp_get_rate_summary_js(rm.roomtype_id, rg.rateplan_id, rg.arrival, rg.departure, rg.adult, rg.child, rg.infant, rg.extra_adult, rg.extra_child, rg.extra_infant ) AS standard FROM registration rg LEFT JOIN room rm ON rm.id = rg.room_id WHERE rg.id = $1 ), rates AS ( SELECT json_build_object('rate_plan', actual->>'rate_plan', 'accommodations', actual->'accommodations') AS actual, json_build_object('rate_plan', booking->>'rate_plan', 'accommodations', booking->'accommodations') AS booking, json_build_object('rate_plan', standard->>'rate_plan', 'accommodations', standard->'accommodations') AS standard FROM summ ) SELECT row_to_json(rates) FROM rates