aonestar.public

Parameters

Name	Type	Mode
room_id	integer	IN
user_name	text	IN
old_roomstatus	character	IN
new_roomstatus	character	IN
old_maidstatus	character	IN
new_maidstatus	character	IN
ooo_id	integer	IN (DEFAULT NULL)
old_ooo_desc	text	IN (DEFAULT NULL)

Definition

declare maid_changed bool;
declare old_status TEXT;
declare new_status TEXT;
begin     
   IF (new_roomstatus is null or new_maidstatus is null) then
      select coalesce(new_roomstatus, rs.status), coalesce(new_maidstatus, rs.hk_status)
      from room_status rs
      where rs.room_id = $1
      into new_roomstatus, new_maidstatus;  
   END IF;

IF (old_roomstatus is distinct from new_roomstatus or old_maidstatus is distinct from new_maidstatus) THEN 
     maid_changed = (old_maidstatus is distinct from new_maidstatus);
	
	 old_status = old_roomstatus;
	 new_status = new_roomstatus;
	
	 IF (old_roomstatus in ('VAC','OCC') or maid_changed) then
 		old_status = old_roomstatus||coalesce('/'||old_maidstatus, '');
 	 END IF;
	  
	 IF (new_roomstatus in ('VAC','OCC') or maid_changed) then
		new_status = new_roomstatus||coalesce('/'||new_maidstatus, '');
 	 END IF;
	
	 perform sp_log_room(room_id, 'Change room status', old_status||' -> '||new_status, user_name);   
--     if (log_text is null and ooo_id is not null) then
--         select oc.name||' on '
--              ||to_char(start_date, 'dd/mm/yy')
--              ||iif(start_date = end_date, '', ' - '||to_char(end_date, 'dd/mm/yy'))
--         from out_of_order oo left join ooo_reason oc on oc.id = oo.reason_id, sysdate s
--         where oo.id = ooo_id
--         order by start_date 
--         limit 1
--         into log_text;
--     END IF;
--    
--     log_text := coalesce(log_text, old_status);
--        
--     perform sp_log_room(room_id, 'Change room status', format('Room %s: %s -> %s', room_number, log_text), user_name);   
   END IF;
END

sp_log_roomstatus

Parameters

Definition