aonestar.public

Parameters

Name	Type	Mode
i_rooms	int4[]	IN
i_bedtype_id	integer	IN
user_name	text	IN (DEFAULT NULL)
result_code	text	OUT
result_msg	text	OUT
msg_code	text	OUT

Definition

declare 
	_room_id int;
	_old_bed TEXT;
    _new_bed TEXT;	
	changed_rooms int[] = '{}';
    _state   TEXT;
    _detail  TEXT;
    _hint    TEXT;
    _context TEXT;  
begin
	/**
	 * Create by KenG (2020/06/16)
	 */
	result_code = '0'; result_msg = 'Success'; msg_code = '00';
	_new_bed = (SELECT b.code FROM bed_type b WHERE b.id = i_bedtype_id);
	
	for _room_id, _old_bed in 
	   SELECT r.id, b.code 
	   FROM room r LEFT JOIN bed_type b ON b.id = r.bedtype_id 
	   WHERE r.id = ANY(i_rooms)
	LOOP
		update room r set bedtype_id = i_bedtype_id where r.id = _room_id;
		changed_rooms = changed_rooms || _room_id;
		perform sp_log_room(_room_id, 'Change bed type', COALESCE(_old_bed,'None')||' -> '||COALESCE(_new_bed,'None'), user_name);
	end loop;

--room_status
	--sp_get_room
	IF fn_length(changed_rooms) > 0 THEN	
   		perform sp_enqueue_realtime('*', fn_current_propcode(), 'room_status', sp_get_room_details_js(changed_rooms, true));
	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_bedtype', result_msg, _detail, _state, _hint, _context, 
        jsonb_build_object('rooms',i_rooms, 'bedtype_id',i_bedtype_id), user_name);    
END;