aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_room_activity_update_usage
Parameters
Name
Type
Mode
Definition
BEGIN INSERT INTO room_usage(use_date, status, roomtype_id, channel_id, qty, last_update) SELECT fn_date_range(new.start_date, new.end_date), new.status, new.roomtype_id, new.channel_id, iif(new.status='ttl', new.qty, -new.qty), new.activity_time; RETURN NULL; END