aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_room_block_status_changed
Parameters
Name
Type
Mode
Definition
DECLARE title_name text; BEGIN -- IF OLD.status = 'B' AND NEW.status = 'I' THEN -- CHECK IN ---- UPDATE booking_items ---- SET block_qty = block_qty-1, inhouse_qty = inhouse_qty+1 ---- WHERE item_id = NEW.booking_item; -- ELSIF OLD.status = 'I' AND NEW.status = 'B' THEN -- CANCEL CHECK-IN -- UPDATE booking_items bi -- SET block_qty = bi.block_qty+1, inhouse_qty = inhouse_qty-1 -- WHERE item_id = NEW.booking_item AND inhouse_qty > 0; -- END IF; -- RETURN NEW; END