aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_recalc_booking_rooms
Parameters
Name
Type
Mode
booking_item
integer
IN
Definition
WITH summ AS ( SELECT count(DISTINCT iif(checked_in, null, room_id)) AS block_count, array_agg(DISTINCT r.room_number) AS block_rooms FROM room_block rb INNER JOIN room r ON r.id = rb.room_id WHERE rb.booking_item = $1 ) UPDATE booking_items bi SET block_qty = block_count, room_numbers = array_to_string(block_rooms, ','), rooms = block_rooms FROM summ WHERE bi.item_id = $1