From 09e6dc3fb7266620fafb5e341808a8eb36e080a1 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期六, 13 十二月 2025 22:51:52 +0800
Subject: [PATCH] feat:增加企业微信消息提醒
---
sql/notify_menu.sql | 18 +++++++++++++++++-
1 files changed, 17 insertions(+), 1 deletions(-)
diff --git a/sql/notify_menu.sql b/sql/notify_menu.sql
index 1b83cdf..f389c97 100644
--- a/sql/notify_menu.sql
+++ b/sql/notify_menu.sql
@@ -50,4 +50,20 @@
('娓犻亾閰嶇疆鏌ヨ', @channelConfigParentId, 1, '#', '', 1, 0, 'F', '0', '0', 'system:notify:channel:config:query', '#', 'admin', SYSDATE(), '', NULL, ''),
('娓犻亾閰嶇疆鏂板', @channelConfigParentId, 2, '#', '', 1, 0, 'F', '0', '0', 'system:notify:channel:config:add', '#', 'admin', SYSDATE(), '', NULL, ''),
('娓犻亾閰嶇疆淇敼', @channelConfigParentId, 3, '#', '', 1, 0, 'F', '0', '0', 'system:notify:channel:config:edit', '#', 'admin', SYSDATE(), '', NULL, ''),
-('娓犻亾閰嶇疆鍒犻櫎', @channelConfigParentId, 4, '#', '', 1, 0, 'F', '0', '0', 'system:notify:channel:config:remove', '#', 'admin', SYSDATE(), '', NULL, '');
\ No newline at end of file
+('娓犻亾閰嶇疆鍒犻櫎', @channelConfigParentId, 4, '#', '', 1, 0, 'F', '0', '0', 'system:notify:channel:config:remove', '#', 'admin', SYSDATE(), '', NULL, '');
+
+-- 浼佷笟寰俊娴嬭瘯鑿滃崟
+INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+VALUES
+('浼佷笟寰俊娴嬭瘯', @parentId, 4, 'qywechat/test', 'system/qywechat/test', 1, 0, 'C', '0', '0', 'system:qywechat:test:list', 'wechat', 'admin', SYSDATE(), '', NULL, '浼佷笟寰俊娴嬭瘯鑿滃崟');
+
+-- 鑾峰彇鍒氭彃鍏ョ殑浼佷笟寰俊娴嬭瘯鑿滃崟ID
+SET @qywechatTestParentId = (SELECT menu_id FROM sys_menu WHERE menu_name = '浼佷笟寰俊娴嬭瘯' AND menu_type = 'C');
+
+-- 浼佷笟寰俊娴嬭瘯鎸夐挳 SQL
+INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+VALUES
+('浼佷笟寰俊娴嬭瘯鏌ヨ', @qywechatTestParentId, 1, '#', '', 1, 0, 'F', '0', '0', 'system:qywechat:test:query', '#', 'admin', SYSDATE(), '', NULL, ''),
+('浼佷笟寰俊娴嬭瘯鏂板', @qywechatTestParentId, 2, '#', '', 1, 0, 'F', '0', '0', 'system:qywechat:test:add', '#', 'admin', SYSDATE(), '', NULL, ''),
+('浼佷笟寰俊娴嬭瘯淇敼', @qywechatTestParentId, 3, '#', '', 1, 0, 'F', '0', '0', 'system:qywechat:test:edit', '#', 'admin', SYSDATE(), '', NULL, ''),
+('浼佷笟寰俊娴嬭瘯鍒犻櫎', @qywechatTestParentId, 4, '#', '', 1, 0, 'F', '0', '0', 'system:qywechat:test:remove', '#', 'admin', SYSDATE(), '', NULL, '');
\ No newline at end of file
--
Gitblit v1.9.1