From 5f708178b260cabf081f9049cf51e9ad66ae2911 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期四, 10 九月 2026 14:49:29 +0800
Subject: [PATCH] feat(erp/mes): 新增采购订单/销售订单/计量器具 Excel 导入，含导入菜单权限 SQL
---
sql/mysql/hrm_employee_contract_import_menu.sql | 23 +++++++++++++++--------
1 files changed, 15 insertions(+), 8 deletions(-)
diff --git a/sql/mysql/hrm_employee_contract_import_menu.sql b/sql/mysql/hrm_employee_contract_import_menu.sql
index d47f209..1d553be 100644
--- a/sql/mysql/hrm_employee_contract_import_menu.sql
+++ b/sql/mysql/hrm_employee_contract_import_menu.sql
@@ -1,13 +1,20 @@
--- 鍛樺伐鍚堝悓 - 瀵煎叆/瀵煎叆妯℃澘 鎸夐挳鏉冮檺
--- 鐖惰彍鍗曪細鍛樺伐鍚堝悓锛坧arent_id = 1063105锛�
--- 鍙傜収锛氬悎鍚屾柊澧炴寜閽� id=1063107锛坱ype=3, permission=hrm:employee-contract:create锛�
+-- 鍛樺伐鍚堝悓 - 瀵煎叆鎸夐挳鏉冮檺锛堢埗鑿滃崟锛氬憳宸ュ悎鍚� id=1063105锛�
+-- 鍔ㄦ�� id锛圡AX(id)+1锛夛紝閬垮厤涓庢棦鏈夎彍鍗曟挒杞︼紱鍙噸澶嶆墽琛岋紙骞傜瓑锛夈��
+SET @perm_exists := (SELECT COUNT(*) FROM system_menu WHERE permission = 'hrm:employee-contract:import');
+SET @import_menu_id := IFNULL((SELECT MAX(id) FROM system_menu), 0) + 1;
+
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 (1063300, '鍚堝悓瀵煎叆', 'hrm:employee-contract:import', 3, 5, 1063105, '', '#', '', NULL,
- 0, 1, 0, 1, '1', NOW(), '1', NOW(), 0);
+SELECT @import_menu_id, '鍚堝悓瀵煎叆', 'hrm:employee-contract:import', 3, 5, 1063105, '', '#', '', NULL,
+ 0, 1, 0, 1, '1', NOW(), '1', NOW(), 0
+FROM DUAL
+WHERE @perm_exists = 0;
--- 鎺堜簣瓒呯骇绠＄悊鍛樿鑹诧紙role_id=1锛夎鎸夐挳鏉冮檺锛堝箓绛夛級
+SET @menu_id := (SELECT id FROM system_menu WHERE permission = 'hrm:employee-contract:import');
+SET @grant_exists := (SELECT COUNT(*) FROM system_role_menu WHERE role_id = 1 AND menu_id = @menu_id);
+
INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted)
-SELECT 1, 1063300, '1', NOW(), '1', NOW(), 0 FROM DUAL
-WHERE NOT EXISTS (SELECT 1 FROM system_role_menu WHERE role_id = 1 AND menu_id = 1063300);
+SELECT 1, @menu_id, '1', NOW(), '1', NOW(), 0
+FROM DUAL
+WHERE @menu_id IS NOT NULL AND @grant_exists = 0;
--
Gitblit v1.9.3