From d516c09d759c7f92da31f09a825c4aba9a885436 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期三, 16 七月 2025 12:07:49 +0800
Subject: [PATCH] art: 岗位数据添加-SQL+常量
---
lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/BusinessCodeConst.java | 16 +++++++++++++++-
db/ZHR/position_zhr.sql | 18 ++++++++++++------
2 files changed, 27 insertions(+), 7 deletions(-)
diff --git a/db/ZHR/position_zhr.sql b/db/ZHR/position_zhr.sql
index 527c4e4..4f17104 100644
--- a/db/ZHR/position_zhr.sql
+++ b/db/ZHR/position_zhr.sql
@@ -1,10 +1,16 @@
INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079838201671681', N'PCR0001', N'鎿嶄綔宸�', NULL, NULL, N'admin', '2025-04-07 11:04:37.0720000', NULL, NULL, N'A01');
INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079910381449218', N'PCR0002', N'缁翠慨宸�', NULL, NULL, N'admin', '2025-04-07 11:04:54.2810000', NULL, NULL, N'A01');
-INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079910381449219', N'PCR0005', N'璁惧鑳芥簮閮�', NULL, NULL, N'admin', '2025-04-07 12:04:55.0000000', NULL, NULL, N'A01A01');
-INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079939120820226', N'PCR0003', N'璁惧妫�楠屽憳', NULL, NULL, N'admin', '2025-04-07 11:05:01.0000000', N'admin', '2025-05-19 15:42:08.0230000', N'A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079939120820226', N'PCR0003', N'璁惧妫�楠屽憳', NULL, NULL, N'admin', '2025-04-07 11:05:01.0000000', N'admin', '2025-07-11 19:48:40.1340000', N'A01');
INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1909079969235922946', N'PCR0004', N'杞﹂棿璁惧绠＄悊鍛�', NULL, NULL, N'admin', '2025-04-07 11:05:08.0000000', N'admin', '2025-05-19 15:41:14.8330000', N'A01');
-INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1922222199530192898', N'PCR0006', N'鐢熶骇淇濋殰閮�', NULL, NULL, N'admin', '2025-05-13 17:27:40.0000000', N'admin', '2025-05-19 15:41:34.2050000', N'A01');
-INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1927291533460058114', N'PCR0007', N'宸ヨ壓鍛�', NULL, NULL, N'admin', '2025-05-27 17:11:23.5840000', NULL, NULL, N'A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1922222199530192898', N'PCR0006', N'鐢熶骇璁惧绠＄悊涓荤', NULL, NULL, N'admin', '2025-05-13 17:27:40.0000000', N'admin', '2025-07-16 12:02:09.7730000', N'A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1927291533460058114', N'PCR0007', N'宸ヨ壓鍛�', NULL, NULL, N'admin', '2025-05-27 17:11:23.0000000', N'admin', '2025-07-11 19:44:16.5370000', N'A01');
INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1942474796260507650', N'PCR0008', N'缁翠慨瀹や富浠�', NULL, NULL, N'admin', '2025-07-08 14:44:15.0000000', N'admin', '2025-07-08 14:47:27.8780000', N'A01A01');
-INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1942475634831900673', N'PCR0009', N'鐢熶骇璁惧鎶�鏈富绠�', NULL, NULL, N'admin', '2025-07-08 14:47:35.4530000', NULL, NULL, N'A01A01');
-INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1943644324128256002', N'PCR0010', N'浣跨敤鍗曚綅鎶�鏈富绠�', NULL, NULL, N'admin', '2025-07-11 20:11:32.6910000', NULL, NULL, N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1942475634831900673', N'PCR0009', N'鐢熶骇璁惧鎶�鏈富绠�', NULL, NULL, N'admin', '2025-07-08 14:47:35.0000000', N'admin', '2025-07-11 19:49:30.1330000', N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1943637993744961537', N'PCR0010', N'浣跨敤杞﹂棿鎶�鏈富绠�', NULL, NULL, N'admin', '2025-07-11 19:46:23.4140000', NULL, NULL, N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1945331595416137730', N'PCR0011', N'浣跨敤鍗曚綅涓荤瀹ょ骇棰嗗', NULL, NULL, N'admin', '2025-07-16 11:56:09.5140000', NULL, NULL, N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1945331725208875010', N'PCR0012', N'鐢熶骇鎸囨尌閮ㄥ绾ч瀵�', NULL, NULL, N'admin', '2025-07-16 11:56:40.4620000', NULL, NULL, N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1945331935767130113', N'PCR0013', N'缁翠慨鍖洪暱', NULL, NULL, N'admin', '2025-07-16 11:57:30.6600000', NULL, NULL, N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1945332049952862210', N'PCR0014', N'璧勪骇绠＄悊閮�', NULL, NULL, N'admin', '2025-07-16 11:57:57.8870000', NULL, NULL, N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1945332106357862401', N'PCR0015', N'椤圭洰涓荤閮�', NULL, NULL, N'admin', '2025-07-16 11:58:11.3330000', NULL, NULL, N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1945332200423518209', N'PCR0016', N'杩愮淮鍟嗗姟瀹や富浠�', NULL, NULL, N'admin', '2025-07-16 11:58:33.7600000', NULL, NULL, N'A01A01');
+INSERT INTO [dbo].[sys_position] ([id], [code], [name], [post_rank], [company_id], [create_by], [create_time], [update_by], [update_time], [sys_org_code]) VALUES (N'1945333327185539073', N'PCR0017', N'杩愮淮绠＄悊瀹ゅ涓讳换', NULL, NULL, N'admin', '2025-07-16 12:03:02.4010000', NULL, NULL, N'A01A01');
diff --git a/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/BusinessCodeConst.java b/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/BusinessCodeConst.java
index dd7ed3d..f7eaac2 100644
--- a/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/BusinessCodeConst.java
+++ b/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/BusinessCodeConst.java
@@ -70,7 +70,7 @@
String PCR0004 = "PCR0004";
//璁惧鑳芥簮閮�
String PCR0005 = "PCR0005";
- //鐢熶骇淇濋殰閮�
+ //鐢熶骇璁惧绠＄悊涓荤
String PCR0006 = "PCR0006";
//宸ヨ壓鍛�
String PCR0007 = "PCR0007";
@@ -80,6 +80,20 @@
String PCR0009 = "PCR0009";
//浣跨敤杞﹂棿鎶�鏈富绠�
String PCR0010 = "PCR0010";
+ //浣跨敤鍗曚綅涓荤瀹ょ骇棰嗗
+ String PCR0011 = "PCR0011";
+ //鐢熶骇鎸囨尌閮ㄥ绾ч瀵�
+ String PCR0012 = "PCR0012";
+ //缁翠慨鍖洪暱
+ String PCR0013 = "PCR0013";
+ //璧勪骇绠＄悊閮�
+ String PCR0014 = "PCR0014";
+ //椤圭洰涓荤閮�
+ String PCR0015 = "PCR0015";
+ //杩愮淮鍟嗗姟瀹や富浠�
+ String PCR0016 = "PCR0016";
+ //杩愮淮绠＄悊瀹ゅ涓讳换
+ String PCR0017 = "PCR0017";
//閫氳繃銆侀┏鍥�
String APPROVED = "1";
--
Gitblit v1.9.3