CREATE DEFINER=`root`@`localhost` FUNCTION `get_dict_name`(in_type VARCHAR(100), in_code VARCHAR(100)) RETURNS varchar(255) CHARSET utf8
BEGIN
DECLARE out_name VARCHAR(255) DEFAULT '';
SELECT dict_label INTO out_name FROM sys_dict_data WHERE dict_type=in_type AND dict_value=in_code limit 1;
IF out_name='' OR out_name IS NULL THEN
SET out_name = in_code;
END IF;
RETURN out_name;
END