aonestar.public

Parameters

Name	Type	Mode
rooms	int4[]	IN
status	character	IN
user_name	text	IN
result_code	text	OUT
result_msg	text	OUT
msg_code	text	OUT

Definition

declare 
    old_status char(2);
    _room_id int;
    changed_rooms int[] = '{}';
    _state   TEXT;
    _detail  TEXT;
    _hint    TEXT;
    _context TEXT;  
BEGIN
    result_code = '0'; result_msg = 'Success'; msg_code = '00';
	for _room_id in select unnest(rooms)
	loop
		old_status = (select hk_status from room_status r where r.room_id = _room_id);
		if (old_status <> status) then
			update room_status rs 
			set hk_status = $2 
			where rs.room_id = _room_id;
			changed_rooms = changed_rooms || _room_id;
			perform sp_log_room(_room_id, 'Room status changed', old_status||' -> '||status, user_name);
		end if;	
	end loop;
	
	IF fn_length(changed_rooms) > 0 THEN	
	   perform sp_enqueue_realtime('*', fn_current_propcode(), 'room_status', sp_get_room_details_js(changed_rooms));
	END IF;
EXCEPTION 
    WHEN OTHERS THEN
    GET STACKED DIAGNOSTICS
        _state   = RETURNED_SQLSTATE,
        result_msg= MESSAGE_TEXT,
        _detail  = PG_EXCEPTION_DETAIL,
        _hint    = PG_EXCEPTION_HINT,
        _context = PG_EXCEPTION_CONTEXT;
    result_code = '4'; msg_code = '99';     
    PERFORM sp_log_error('sp_change_maid_status', result_msg, _detail, _state, _hint, _context, 
        jsonb_build_object('rooms',rooms, 'new_status',status), user_name);      
END