| | |
| | | ('渠道配置查询', @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, ''); |
| | | ('渠道配置删除', @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, ''); |