From 6cef375f571bfc0cf50982d75283f8eb260daf62 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期五, 23 十月 2026 12:44:23 +0800
Subject: [PATCH] fix(aftersales): 售后工单数据权限支持「处理人」可见；补齐全模块缺失权限点
---
yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/util/AfterSalePermissionUtils.java | 33 +++++++-
sql/mysql/aftersales_perm_align_all_modules.sql | 144 ++++++++++++++++++++++++++++++++++++
yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/ticket/AfterSaleTicketMapper.java | 4
3 files changed, 174 insertions(+), 7 deletions(-)
diff --git a/sql/mysql/aftersales_perm_align_all_modules.sql b/sql/mysql/aftersales_perm_align_all_modules.sql
new file mode 100644
index 0000000..d0dd30f
--- /dev/null
+++ b/sql/mysql/aftersales_perm_align_all_modules.sql
@@ -0,0 +1,144 @@
+-- =============================================
+-- 琛ラ綈鍚庣 @PreAuthorize 浣跨敤銆佷絾 system_menu 涓己澶辩殑鏉冮檺鐐癸紙type=3 鎸夐挳锛�
+-- 鐩殑锛氶潪瓒呯璐﹀彿璋冪敤杩欎簺鎺ュ彛鏃朵笉鍐� 403锛涗晶鏍忎笉鏄剧ず锛坱ype=3锛�
+-- 鑴氭湰鍙噸澶嶆墽琛岋紙骞傜瓑锛夛紝鐖惰彍鍗曟寜妯″潡鏍硅彍鍗� path 瀹氫綅
+-- =============================================
+SET NAMES utf8mb4;
+
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603000,'鏉冮檺鐐�-bi:dashboard:query','bi:dashboard:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('bi','/bi') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603001,'鏉冮檺鐐�-bpm:oa-notice:query','bpm:oa-notice:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('bpm','/bpm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603002,'鏉冮檺鐐�-crm:invoice:query','crm:invoice:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('crm','/crm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603003,'鏉冮檺鐐�-crm:sale-quotation:convert-contract','crm:sale-quotation:convert-contract',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('crm','/crm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603004,'鏉冮檺鐐�-crm:sale-quotation:export','crm:sale-quotation:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('crm','/crm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603005,'鏉冮檺鐐�-crm:sale-quotation:query','crm:sale-quotation:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('crm','/crm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603006,'鏉冮檺鐐�-erp:purchase-order:import','erp:purchase-order:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603007,'鏉冮檺鐐�-erp:purchase-request:generate-order','erp:purchase-request:generate-order',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603008,'鏉冮檺鐐�-erp:purchase-request:query','erp:purchase-request:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603009,'鏉冮檺鐐�-erp:purchase-request:submit','erp:purchase-request:submit',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603010,'鏉冮檺鐐�-erp:sale-order:cancel','erp:sale-order:cancel',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603011,'鏉冮檺鐐�-erp:sale-order:enable','erp:sale-order:enable',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603012,'鏉冮檺鐐�-erp:sale-order:import','erp:sale-order:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603013,'鏉冮檺鐐�-erp:supplier:create','erp:supplier:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603014,'鏉冮檺鐐�-erp:supplier:delete','erp:supplier:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603015,'鏉冮檺鐐�-erp:supplier:export','erp:supplier:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603016,'鏉冮檺鐐�-erp:supplier:query','erp:supplier:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603017,'鏉冮檺鐐�-erp:supplier:update','erp:supplier:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('erp','/erp') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603018,'鏉冮檺鐐�-mdm:brand:create','mdm:brand:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603019,'鏉冮檺鐐�-mdm:brand:delete','mdm:brand:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603020,'鏉冮檺鐐�-mdm:brand:query','mdm:brand:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603021,'鏉冮檺鐐�-mdm:brand:update','mdm:brand:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603022,'鏉冮檺鐐�-mdm:item-category:create','mdm:item-category:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603023,'鏉冮檺鐐�-mdm:item-category:delete','mdm:item-category:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603024,'鏉冮檺鐐�-mdm:item-category:query','mdm:item-category:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603025,'鏉冮檺鐐�-mdm:item-category:update','mdm:item-category:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603026,'鏉冮檺鐐�-mdm:unit:export','mdm:unit:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603027,'鏉冮檺鐐�-mdm:unit:import','mdm:unit:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603028,'鏉冮檺鐐�-mdm:warehouse:create','mdm:warehouse:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603029,'鏉冮檺鐐�-mdm:warehouse:delete','mdm:warehouse:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603030,'鏉冮檺鐐�-mdm:warehouse:query','mdm:warehouse:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603031,'鏉冮檺鐐�-mdm:warehouse:update','mdm:warehouse:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mdm','/mdm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603032,'鏉冮檺鐐�-member:config:query','member:config:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603033,'鏉冮檺鐐�-member:config:save','member:config:save',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603034,'鏉冮檺鐐�-member:experience-record:query','member:experience-record:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603035,'鏉冮檺鐐�-member:group:create','member:group:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603036,'鏉冮檺鐐�-member:group:delete','member:group:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603037,'鏉冮檺鐐�-member:group:query','member:group:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603038,'鏉冮檺鐐�-member:group:update','member:group:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603039,'鏉冮檺鐐�-member:level:create','member:level:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603040,'鏉冮檺鐐�-member:level:delete','member:level:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603041,'鏉冮檺鐐�-member:level:query','member:level:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603042,'鏉冮檺鐐�-member:level:update','member:level:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603043,'鏉冮檺鐐�-member:level-record:query','member:level-record:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603044,'鏉冮檺鐐�-member:tag:create','member:tag:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603045,'鏉冮檺鐐�-member:tag:delete','member:tag:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603046,'鏉冮檺鐐�-member:tag:query','member:tag:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603047,'鏉冮檺鐐�-member:tag:update','member:tag:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603048,'鏉冮檺鐐�-member:user:query','member:user:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603049,'鏉冮檺鐐�-member:user:update','member:user:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603050,'鏉冮檺鐐�-member:user:update-level','member:user:update-level',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603051,'鏉冮檺鐐�-member:user:update-point','member:user:update-point',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('member','/member') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603052,'鏉冮檺鐐�-mes:dv-metering:import','mes:dv-metering:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603053,'鏉冮檺鐐�-mes:md-unit-measure:create','mes:md-unit-measure:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603054,'鏉冮檺鐐�-mes:md-unit-measure:delete','mes:md-unit-measure:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603055,'鏉冮檺鐐�-mes:md-unit-measure:export','mes:md-unit-measure:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603056,'鏉冮檺鐐�-mes:md-unit-measure:query','mes:md-unit-measure:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603057,'鏉冮檺鐐�-mes:md-unit-measure:update','mes:md-unit-measure:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603058,'鏉冮檺鐐�-mes:md-workshop:export','mes:md-workshop:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603059,'鏉冮檺鐐�-mes:pd-archive:create','mes:pd-archive:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603060,'鏉冮檺鐐�-mes:pd-document:create','mes:pd-document:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603061,'鏉冮檺鐐�-mes:pd-document:delete','mes:pd-document:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603062,'鏉冮檺鐐�-mes:pd-document:export','mes:pd-document:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603063,'鏉冮檺鐐�-mes:pd-document:query','mes:pd-document:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603064,'鏉冮檺鐐�-mes:pd-document:update','mes:pd-document:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603065,'鏉冮檺鐐�-mes:pd-document-audit:create','mes:pd-document-audit:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603066,'鏉冮檺鐐�-mes:pd-document-audit:delete','mes:pd-document-audit:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603067,'鏉冮檺鐐�-mes:pd-document-audit:export','mes:pd-document-audit:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603068,'鏉冮檺鐐�-mes:pd-document-audit:query','mes:pd-document-audit:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603069,'鏉冮檺鐐�-mes:pd-document-audit:update','mes:pd-document-audit:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603070,'鏉冮檺鐐�-mes:pd-process-param:create','mes:pd-process-param:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603071,'鏉冮檺鐐�-mes:pd-process-param:delete','mes:pd-process-param:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603072,'鏉冮檺鐐�-mes:pd-process-param:export','mes:pd-process-param:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603073,'鏉冮檺鐐�-mes:pd-process-param:query','mes:pd-process-param:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603074,'鏉冮檺鐐�-mes:pd-process-param:update','mes:pd-process-param:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603075,'鏉冮檺鐐�-mes:pd-process-param-template:create','mes:pd-process-param-template:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603076,'鏉冮檺鐐�-mes:pd-process-param-template:delete','mes:pd-process-param-template:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603077,'鏉冮檺鐐�-mes:pd-process-param-template:export','mes:pd-process-param-template:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603078,'鏉冮檺鐐�-mes:pd-process-param-template:query','mes:pd-process-param-template:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603079,'鏉冮檺鐐�-mes:pd-process-param-template:update','mes:pd-process-param-template:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603080,'鏉冮檺鐐�-mes:pro-mps:query','mes:pro-mps:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603081,'鏉冮檺鐐�-mes:pro-task-issue:create','mes:pro-task-issue:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603082,'鏉冮檺鐐�-mes:pro-task-issue:delete','mes:pro-task-issue:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603083,'鏉冮檺鐐�-mes:pro-task-issue:query','mes:pro-task-issue:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603084,'鏉冮檺鐐�-mes:pro-task-issue:update','mes:pro-task-issue:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603085,'鏉冮檺鐐�-mes:qc:update','mes:qc:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603086,'鏉冮檺鐐�-mes:qc-ipqc:finish','mes:qc-ipqc:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603087,'鏉冮檺鐐�-mes:qc-iqc:finish','mes:qc-iqc:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603088,'鏉冮檺鐐�-mes:qc-oqc:finish','mes:qc-oqc:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603089,'鏉冮檺鐐�-mes:qc-rqc:finish','mes:qc-rqc:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603090,'鏉冮檺鐐�-mes:wm-material-stock:import','mes:wm-material-stock:import',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603091,'鏉冮檺鐐�-mes:wm-outsource-issue:finish','mes:wm-outsource-issue:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603092,'鏉冮檺鐐�-mes:wm-product-produce:query','mes:wm-product-produce:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603093,'鏉冮檺鐐�-mes:wm-return-vendor:finish','mes:wm-return-vendor:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603094,'鏉冮檺鐐�-mes:wm-stock-taking-task:finish','mes:wm-stock-taking-task:finish',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('mes','/mes') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603095,'鏉冮檺鐐�-point:record:query','point:record:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603096,'鏉冮檺鐐�-point:sign-in-config:create','point:sign-in-config:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603097,'鏉冮檺鐐�-point:sign-in-config:delete','point:sign-in-config:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603098,'鏉冮檺鐐�-point:sign-in-config:query','point:sign-in-config:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603099,'鏉冮檺鐐�-point:sign-in-config:update','point:sign-in-config:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603100,'鏉冮檺鐐�-point:sign-in-record:query','point:sign-in-record:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('point','/point') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603101,'鏉冮檺鐐�-srm:supplier-contact:create','srm:supplier-contact:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603102,'鏉冮檺鐐�-srm:supplier-contact:delete','srm:supplier-contact:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603103,'鏉冮檺鐐�-srm:supplier-contact:query','srm:supplier-contact:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603104,'鏉冮檺鐐�-srm:supplier-contact:update','srm:supplier-contact:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603105,'鏉冮檺鐐�-srm:tender-config:query','srm:tender-config:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603106,'鏉冮檺鐐�-srm:tender-config:update','srm:tender-config:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('srm','/srm') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603107,'鏉冮檺鐐�-trade:domestic-order:cancel','trade:domestic-order:cancel',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603108,'鏉冮檺鐐�-trade:domestic-order:complete','trade:domestic-order:complete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603109,'鏉冮檺鐐�-trade:domestic-order:create','trade:domestic-order:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603110,'鏉冮檺鐐�-trade:domestic-order:delete','trade:domestic-order:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603111,'鏉冮檺鐐�-trade:domestic-order:export','trade:domestic-order:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603112,'鏉冮檺鐐�-trade:domestic-order:outbound','trade:domestic-order:outbound',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603113,'鏉冮檺鐐�-trade:domestic-order:query','trade:domestic-order:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603114,'鏉冮檺鐐�-trade:domestic-order:submit','trade:domestic-order:submit',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603115,'鏉冮檺鐐�-trade:domestic-order:update','trade:domestic-order:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603116,'鏉冮檺鐐�-trade:foreign-order:complete','trade:foreign-order:complete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603117,'鏉冮檺鐐�-trade:foreign-order:create','trade:foreign-order:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603118,'鏉冮檺鐐�-trade:foreign-order:delete','trade:foreign-order:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603119,'鏉冮檺鐐�-trade:foreign-order:export','trade:foreign-order:export',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603120,'鏉冮檺鐐�-trade:foreign-order:outbound','trade:foreign-order:outbound',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603121,'鏉冮檺鐐�-trade:foreign-order:query','trade:foreign-order:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603122,'鏉冮檺鐐�-trade:foreign-order:receive','trade:foreign-order:receive',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603123,'鏉冮檺鐐�-trade:foreign-order:submit','trade:foreign-order:submit',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603124,'鏉冮檺鐐�-trade:foreign-order:update','trade:foreign-order:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603125,'鏉冮檺鐐�-trade:port-batch:create','trade:port-batch:create',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603126,'鏉冮檺鐐�-trade:port-batch:delete','trade:port-batch:delete',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603127,'鏉冮檺鐐�-trade:port-batch:query','trade:port-batch:query',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+INSERT INTO `system_menu` (`id`,`name`,`permission`,`type`,`sort`,`parent_id`,`path`,`icon`,`component`,`component_name`,`status`,`visible`,`keep_alive`,`always_show`,`creator`,`create_time`,`updater`,`update_time`,`deleted`) VALUES (603128,'鏉冮檺鐐�-trade:port-batch:update','trade:port-batch:update',3,900,IFNULL((SELECT id FROM (SELECT id FROM `system_menu` WHERE `path` IN ('trade','/trade') AND `deleted`=b'0' LIMIT 1) t),0),'','','',NULL,0,b'1',b'1',b'1','1',NOW(),'1',NOW(),b'0') ON DUPLICATE KEY UPDATE `permission`=VALUES(`permission`),`name`=VALUES(`name`),`deleted`=b'0';
+
+-- 鎺堟潈缁欐墍鏈夌幇鏈夎鑹�
+INSERT INTO `system_role_menu` (`role_id`,`menu_id`,`creator`,`create_time`,`updater`,`update_time`,`deleted`)
+SELECT r.id, m.id, '1', NOW(), '1', NOW(), b'0'
+FROM `system_role` r JOIN `system_menu` m ON m.id BETWEEN 603000 AND 603128 AND m.deleted=b'0'
+WHERE r.deleted=b'0' AND NOT EXISTS (SELECT 1 FROM `system_role_menu` rm WHERE rm.role_id=r.id AND rm.menu_id=m.id AND rm.deleted=b'0');
+
+SELECT CONCAT('宸茶ˉ榻愭潈闄愮偣: ', COUNT(*)) AS result FROM `system_menu` WHERE id BETWEEN 603000 AND 603128 AND deleted=b'0';
diff --git a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/ticket/AfterSaleTicketMapper.java b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/ticket/AfterSaleTicketMapper.java
index 319d61f..1d2eb17 100644
--- a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/ticket/AfterSaleTicketMapper.java
+++ b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/ticket/AfterSaleTicketMapper.java
@@ -27,9 +27,9 @@
Long customerId, Long saleOrderId,
Integer status, Integer issueType, Integer visitStatus) {
MPJLambdaWrapperX<AfterSaleTicketDO> query = new MPJLambdaWrapperX<>();
- // 鏁版嵁鏉冮檺
+ // 鏁版嵁鏉冮檺锛堝鐞嗕汉涔熻兘鐪嬪埌鑷繁澶勭悊鐨勫伐鍗曪級
AfterSalePermissionUtils.appendPermissionCondition(query, AfterSaleBizTypeEnum.AFTER_SALE_TICKET.getType(),
- AfterSaleTicketDO::getId, userId, sceneType);
+ AfterSaleTicketDO::getId, userId, sceneType, "handler_user_id");
// 鏌ヨ鏉′欢
query.selectAll(AfterSaleTicketDO.class)
.likeIfPresent(AfterSaleTicketDO::getNo, no)
diff --git a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/util/AfterSalePermissionUtils.java b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/util/AfterSalePermissionUtils.java
index b8da995..9c9f680 100644
--- a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/util/AfterSalePermissionUtils.java
+++ b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/util/AfterSalePermissionUtils.java
@@ -54,11 +54,30 @@
public static <T extends MPJLambdaWrapper<?>, S> void appendPermissionCondition(T query, Integer bizType,
SFunction<S, ?> bizId,
Long userId, Integer sceneType) {
+ appendPermissionCondition(query, bizType, bizId, userId, sceneType, null);
+ }
+
+ /**
+ * 鏋勯�犲敭鍚庢ā鍧楁暟鎹�愬垎椤点�戞煡璇㈡潯浠讹紙鏀寔銆屽鐞嗕汉銆嶄篃绠楀彲瑙佽寖鍥达級
+ *
+ * @param handlerUserIdField 澶勭悊浜哄瓧娈碉紙甯﹁〃鍒悕锛夛紝涓� null 琛ㄧず璇ヨ〃娌℃湁澶勭悊浜烘蹇�
+ */
+ public static <T extends MPJLambdaWrapper<?>, S> void appendPermissionCondition(T query, Integer bizType,
+ SFunction<S, ?> bizId,
+ Long userId, Integer sceneType,
+ String handlerUserIdField) {
MybatisPlusJoinProperties mybatisPlusJoinProperties = SpringUtil.getBean(MybatisPlusJoinProperties.class);
- final String ownerUserIdField = mybatisPlusJoinProperties.getTableAlias() + ".owner_user_id";
- // 鍦烘櫙涓�锛氭垜璐熻矗鐨勬暟鎹�
+ final String tableAlias = mybatisPlusJoinProperties.getTableAlias();
+ final String ownerUserIdField = tableAlias + ".owner_user_id";
+ // 澶勭悊浜哄瓧娈佃ˉ榻愯〃鍒悕锛堥伩鍏嶈繛琛ㄦ煡璇㈡椂鍒楀悕姝т箟锛�
+ final String handlerField = handlerUserIdField != null ? tableAlias + "." + handlerUserIdField : null;
+ // 鍦烘櫙涓�锛氭垜璐熻矗鐨勬暟鎹紙鎴栨垜浣滀负澶勭悊浜虹殑鏁版嵁锛�
if (AfterSaleSceneTypeEnum.isOwner(sceneType)) {
- query.eq(ownerUserIdField, userId);
+ if (handlerField != null) {
+ query.and(w -> w.eq(ownerUserIdField, userId).or().eq(handlerField, userId));
+ } else {
+ query.eq(ownerUserIdField, userId);
+ }
}
// 鍦烘櫙浜岋細鎴戝弬涓庣殑鏁版嵁锛堟垜鏈夎鎴栧啓鏉冮檺锛屽苟涓斾笉鏄礋璐ｄ汉锛�
if (AfterSaleSceneTypeEnum.isInvolved(sceneType)) {
@@ -82,12 +101,16 @@
query.in(ownerUserIdField, convertSet(subordinateUsers, AdminUserRespDTO::getId));
}
}
- // 鍦烘櫙鍥涳細鍏ㄩ儴鏁版嵁锛堥渶瑕佹湁 view-all 鏉冮檺鎴栧敭鍚庣鐞嗗憳锛�
+ // 鍦烘櫙鍥涳細鍏ㄩ儴鏁版嵁锛堥渶瑕佹湁 view-all 鏉冮檺鎴栧敭鍚庣鐞嗗憳锛涘惁鍒欏彧鐪嬭嚜宸辫礋璐� + 鑷繁澶勭悊鐨勶級
if (AfterSaleSceneTypeEnum.isAll(sceneType)) {
if (isAftersaleAdmin() || hasViewAllPermission()) {
return;
}
- query.eq(ownerUserIdField, userId);
+ if (handlerField != null) {
+ query.and(w -> w.eq(ownerUserIdField, userId).or().eq(handlerField, userId));
+ } else {
+ query.eq(ownerUserIdField, userId);
+ }
}
}
--
Gitblit v1.9.3