From 584dbcd691e66b6deb4d4821ab6eea10bf8c35dd Mon Sep 17 00:00:00 2001 From: lyh <925863403@qq.com> Date: 星期五, 18 七月 2025 11:31:07 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- db/430设备管理数据库设计.pdma.json | 22 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/BusinessCodeConst.java | 2 db/ZHR/process/技术状态变更申请流程.bpmn20.xml | 96 ++++ db/ZHR/process/技术状态鉴定工单变更流程.bpmn20.xml | 130 +++++ db/ZHR/process/技术状态鉴定申请流程.bpmn20.xml | 130 +++++ lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusChangeDetail.java | 3 db/ZHR/process/停用加工设备申请.bpmn20.xml | 96 ++++ db/ZHR/create_table_zhr.sql | 552 ++++++++++++++++++----- db/ZHR/process/技术状态鉴定流程.bpmn20.xml | 342 ++++++++++++++ db/ZHR/business_code_zhr.sql | 4 10 files changed, 1,220 insertions(+), 157 deletions(-) diff --git "a/db/430\350\256\276\345\244\207\347\256\241\347\220\206\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json" "b/db/430\350\256\276\345\244\207\347\256\241\347\220\206\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json" index 5e5694b..6975805 100644 --- "a/db/430\350\256\276\345\244\207\347\256\241\347\220\206\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json" +++ "b/db/430\350\256\276\345\244\207\347\256\241\347\220\206\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json" @@ -4,7 +4,7 @@ "avatar": "", "version": "4.9.2", "createdTime": "2025-3-10 16:38:19", - "updatedTime": "2025-7-17 19:49:48", + "updatedTime": "2025-7-18 10:15:01", "dbConns": [], "profile": { "default": { @@ -30278,24 +30278,6 @@ "extProps": {}, "domain": "73FD2BAD-2358-4336-B96D-45DC897BD792", "id": "589C45F0-0F8C-4497-8999-A8314DE5D601" - }, - { - "defKey": "order_id", - "defName": "鎶�鏈姸鎬侀壌瀹氬伐鍗旾D", - "comment": "鎼縼浣跨敤", - "type": "", - "len": "", - "scale": "", - "primaryKey": false, - "notNull": false, - "autoIncrement": false, - "defaultValue": "", - "hideInGraph": false, - "refDict": "", - "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64", - "extProps": {}, - "domain": "16120F75-6AA7-4483-868D-F07F511BB081", - "id": "153169DD-C196-48EC-B0B4-60626C830D64" } ], "correlations": [], @@ -33216,4 +33198,4 @@ "enable": true } ] -} +} \ No newline at end of file diff --git a/db/ZHR/business_code_zhr.sql b/db/ZHR/business_code_zhr.sql index ef24b26..00891b4 100644 --- a/db/ZHR/business_code_zhr.sql +++ b/db/ZHR/business_code_zhr.sql @@ -1,3 +1,7 @@ --鎶�鏈姸鎬侀壌瀹氱浉鍏崇紪鐮佽鍒� INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1942396178475687937', N'admin', '2025-07-08 09:31:51.5660000', NULL, NULL, 0, N'鎶�鏈姸鎬侀壌瀹氳鑼冪紪鐮佽鍒�', N'TechnicalStatusStandardCodeRule', N'TSES', N'yyyy', NULL, NULL, 4); INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1943153060836503553', N'admin', '2025-07-10 11:39:26.4060000', NULL, NULL, 0, N'鎶�鏈姸鎬侀壌瀹氬伐鍗曠紪鐮佽鍒�', N'TechnicalStatusEvaluationOrderCodeRule', N'TSEO', N'yyyy', NULL, NULL, 4); +INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1946025937108844545', N'admin', '2025-07-18 09:55:13.4730000', NULL, NULL, 0, N'鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇寸紪鐮佽鍒�', N'TechnicalStatusEvaluationOrderChangeCodeRule', N'TSEOC', N'yyyy', NULL, NULL, 4); +INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1946026069359443970', N'admin', '2025-07-18 09:55:45.0080000', NULL, NULL, 0, N'鎶�鏈姸鎬佸彉鏇寸紪鐮佽鍒�', N'TechnicalStatusChangeCodeRule', N'TSC', N'yyyy', NULL, NULL, 4); +INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1946026402634645506', N'admin', '2025-07-18 09:57:04.4710000', NULL, NULL, 0, N'鎶�鏈姸鎬侀壌瀹氱敵璇风紪鐮佽鍒�', N'TechnicalStatusEvaluationApplyCodeRule', N'TSEA', N'yyyy', NULL, NULL, 4); +INSERT INTO [dbo].[sys_business_code_rule] ([id], [create_by], [create_time], [update_by], [update_time], [del_flag], [business_name], [business_code], [prefix], [year_format], [month_format], [day_format], [seq_length]) VALUES (N'1946026519441817602', N'admin', '2025-07-18 09:57:32.3160000', NULL, NULL, 0, N'鍋滅敤鍔犲伐璁惧鐢宠缂栫爜瑙勫垯', N'TechnicalStatusDeactivateCodeRule', N'TSD', N'yyyy', NULL, NULL, 4); diff --git a/db/ZHR/create_table_zhr.sql b/db/ZHR/create_table_zhr.sql index a791fce..dae5b33 100644 --- a/db/ZHR/create_table_zhr.sql +++ b/db/ZHR/create_table_zhr.sql @@ -1049,89 +1049,247 @@ --鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇� -IF EXISTS (SELECT * - FROM sys.objects - WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order_change]') - AND type in (N'U')) - DROP TABLE [dbo].[eam_technical_status_evaluation_order_change]; CREATE TABLE [dbo].[eam_technical_status_evaluation_order_change] ( - id NVARCHAR(32) NOT NULL, - create_by NVARCHAR(50), - create_time DATETIME2, - update_by NVARCHAR(50), - update_time DATETIME2, - del_flag INT, - order_id NVARCHAR(32), - change_order_num NVARCHAR(100), - applicant NVARCHAR(50), - factory_org_code NVARCHAR(100), - apply_date DATETIME2, - change_status NVARCHAR(64), - apply_reason NVARCHAR(64), - deferred_maintenance_date DATETIME2, - equipment_manager_signature NVARCHAR(50), - equipment_manager_signature_time DATETIME2, - depart_manager_signature NVARCHAR(50), - depart_manager_signature_time DATETIME2, - depart_manager_comment NVARCHAR(255), - production_support_signature NVARCHAR(50), - production_support_signature_time DATETIME2, - production_support_comment NVARCHAR(255), - hf_code NVARCHAR(100), - PRIMARY KEY (id) -); + [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL, + [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [create_time] datetime2(7) NULL, + [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [update_time] datetime2(7) NULL, + [del_flag] int NULL, + [order_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL, + [equipment_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL, + [change_order_num] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, + [applicant] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [factory_org_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, + [apply_date] datetime2(7) NULL, + [change_status] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, + [apply_reason] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, + [deferred_evaluation_date] datetime2(7) NULL, + [equipment_manager_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [equipment_manager_signature_time] datetime2(7) NULL, + [equipment_manager_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, + [equipment_manager_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, + [depart_manager_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [depart_manager_signature_time] datetime2(7) NULL, + [depart_manager_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, + [depart_manager_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, + [production_support_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [production_support_signature_time] datetime2(7) NULL, + [production_support_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, + [production_support_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, + [hf_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, + CONSTRAINT [PK__eam_tech__3213E83FFE6D6178] PRIMARY KEY CLUSTERED ([id]) + WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) + ON [PRIMARY] +) + ON [PRIMARY] +GO -EXEC sp_addextendedproperty 'MS_Description', '鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇�', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, null, null; -EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', id; -EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', create_by; -EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', create_time; -EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', update_by; -EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', update_time; -EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', del_flag; -EXEC sp_addextendedproperty 'MS_Description', '宸ュ崟ID', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', order_id; -EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鍗曞彿', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', change_order_num; -EXEC sp_addextendedproperty 'MS_Description', '鐢宠浜�', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', applicant; -EXEC sp_addextendedproperty 'MS_Description', '鐢宠閮ㄩ棬', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', factory_org_code; -EXEC sp_addextendedproperty 'MS_Description', '鐢宠鏃ユ湡', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', apply_date; -EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鐘舵��;寰呮彁浜ゃ�佸緟涓荤瀹℃牳銆佸緟閮ㄩ棬纭銆佸緟淇濋殰閮ㄧ‘璁ゃ�佸凡浣滃簾銆佸凡瀹屾垚', - 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order_change, 'column', change_status; -EXEC sp_addextendedproperty 'MS_Description', - '鍙樻洿鍘熷洜;鐢熶骇浠诲姟鎬ユ棤娉曞仠鏈恒�佽澶囨晠闅滄澶勪簬缁翠慨鐘舵�併�佽澶囧凡鎶ュ簾銆佽澶囧ぇ淇�佹惉杩併�佹敼閫�', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', apply_reason; -EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿閴村畾鏃ユ湡', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', deferred_maintenance_date; -EXEC sp_addextendedproperty 'MS_Description', '涓荤棰嗗绛惧瓧', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature; -EXEC sp_addextendedproperty 'MS_Description', '涓荤棰嗗绛惧瓧鏃堕棿', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature_time; -EXEC sp_addextendedproperty 'MS_Description', '閮ㄩ棬棰嗗绛惧瓧;鏍规嵁鍙樻洿鍘熷洜绫诲瀷鍖哄垎涓嶅悓鐨勪汉瀹℃壒', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', depart_manager_signature; -EXEC sp_addextendedproperty 'MS_Description', '閮ㄩ棬棰嗗绛惧瓧鏃堕棿', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', depart_manager_signature_time; -EXEC sp_addextendedproperty 'MS_Description', '閮ㄩ棬棰嗗鎰忚', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', depart_manager_comment; -EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵肩瀛�', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', production_support_signature; -EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵肩瀛楁椂闂�', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', production_support_signature_time; -EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵兼剰瑙�', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', production_support_comment; -EXEC sp_addextendedproperty 'MS_Description', 'HF缂栫爜', 'SCHEMA', dbo, 'table', - eam_technical_status_evaluation_order_change, 'column', hf_code; +ALTER TABLE [dbo].[eam_technical_status_evaluation_order_change] + SET (LOCK_ESCALATION = TABLE) +GO +EXEC sp_addextendedproperty + 'MS_Description', N'涓婚敭', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'id' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍒涘缓浜�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'create_by' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍒涘缓鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'create_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鏇存柊浜�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'update_by' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鏇存柊鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'update_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍒犻櫎鏍囪', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'del_flag' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'宸ュ崟ID', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'order_id' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'璁惧ID', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'equipment_id' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍙樻洿鍗曞彿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'change_order_num' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鐢宠浜�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'applicant' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鐢宠閮ㄩ棬', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'factory_org_code' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鐢宠鏃ユ湡', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'apply_date' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍙樻洿鐘舵��;寰呮彁浜ゃ�佸緟涓荤瀹℃牳銆佸緟閮ㄩ棬纭銆佸緟淇濋殰閮ㄧ‘璁ゃ�佸凡浣滃簾銆佸凡瀹屾垚', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'change_status' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍙樻洿鍘熷洜;鐢熶骇浠诲姟鎬ユ棤娉曞仠鏈恒�佽澶囨晠闅滄澶勪簬缁翠慨鐘舵�併�佽澶囧凡鎶ュ簾銆佽澶囧ぇ淇�佹惉杩併�佹敼閫�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'apply_reason' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍙樻洿閴村畾鏃ユ湡', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'deferred_evaluation_date' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'涓荤棰嗗绛惧瓧', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'equipment_manager_signature' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'涓荤棰嗗绛惧瓧鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'equipment_manager_signature_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'涓荤棰嗗绛惧瓧缁撴灉', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'equipment_manager_signature_result' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'涓荤棰嗗鎰忚', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'equipment_manager_comment' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'閮ㄩ棬棰嗗绛惧瓧;鏍规嵁鍙樻洿鍘熷洜绫诲瀷鍖哄垎涓嶅悓鐨勪汉瀹℃壒', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'depart_manager_signature' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'閮ㄩ棬棰嗗绛惧瓧鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'depart_manager_signature_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'閮ㄩ棬棰嗗绛惧瓧缁撴灉', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'depart_manager_signature_result' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'閮ㄩ棬棰嗗鎰忚', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'depart_manager_comment' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鐢熶骇淇濋殰閮ㄩ瀵肩瀛�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'production_support_signature' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鐢熶骇淇濋殰閮ㄩ瀵肩瀛楁椂闂�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'production_support_signature_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鐢熶骇淇濋殰閮ㄩ瀵肩瀛楃粨鏋�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'production_support_signature_result' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鐢熶骇淇濋殰閮ㄩ瀵兼剰瑙�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'production_support_comment' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'HF缂栫爜', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change', + 'COLUMN', N'hf_code' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_evaluation_order_change' --鎶�鏈姸鎬佸彉鏇寸敵璇� IF EXISTS (SELECT * @@ -1141,61 +1299,189 @@ DROP TABLE [dbo].[eam_technical_status_change]; CREATE TABLE [dbo].[eam_technical_status_change] ( - id NVARCHAR(32) NOT NULL, - create_by NVARCHAR(50), - create_time DATETIME2, - update_by NVARCHAR(50), - update_time DATETIME2, - del_flag INT, - change_order_num NVARCHAR(100), - change_status NVARCHAR(64), - designer NVARCHAR(50), - designer_time DATETIME2, - depart_header_signature NVARCHAR(50), - depart_header_signature_time DATETIME2, - depart_header_signature_comment NVARCHAR(255), - depart_leader_signature NVARCHAR(50), - depart_leader_signature_time DATETIME2, - depart_leader_signature_comment NVARCHAR(255), - hf_code NVARCHAR(100), - PRIMARY KEY (id) -); + [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL, + [create_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [create_time] datetime2(7) NULL, + [update_by] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [update_time] datetime2(7) NULL, + [del_flag] int NULL, + [change_order_num] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, + [change_status] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, + [factory_org_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, + [designer] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [designer_time] datetime2(7) NULL, + [depart_header_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [depart_header_signature_time] datetime2(7) NULL, + [depart_header_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, + [depart_header_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, + [depart_leader_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + [depart_leader_signature_time] datetime2(7) NULL, + [depart_leader_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL, + [depart_leader_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, + [hf_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL, + [remark] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, + CONSTRAINT [PK__eam_tech__3213E83F5B1204F4] PRIMARY KEY CLUSTERED ([id]) + WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) + ON [PRIMARY] +) + ON [PRIMARY] +GO -EXEC sp_addextendedproperty 'MS_Description', '鎶�鏈姸鎬佸彉鏇寸敵璇�', 'SCHEMA', dbo, 'table', eam_technical_status_change, - null, null; -EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', id; -EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - create_by; -EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - create_time; -EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - update_by; -EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - update_time; -EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - del_flag; -EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鍗曞彿', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - change_order_num; -EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鍗曠姸鎬�', 'SCHEMA', dbo, 'table', eam_technical_status_change, - 'column', change_status; -EXEC sp_addextendedproperty 'MS_Description', '缂栧埗浜�', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - designer; -EXEC sp_addextendedproperty 'MS_Description', '缂栧埗鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - designer_time; -EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠$瀛�', 'SCHEMA', dbo, 'table', eam_technical_status_change, - 'column', depart_header_signature; -EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠$瀛楁椂闂�', 'SCHEMA', dbo, 'table', - eam_technical_status_change, 'column', depart_header_signature_time; -EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠℃剰瑙�', 'SCHEMA', dbo, 'table', eam_technical_status_change, - 'column', depart_header_signature_comment; -EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠$瀛�', 'SCHEMA', dbo, 'table', eam_technical_status_change, - 'column', depart_leader_signature; -EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠$瀛楁椂闂�', 'SCHEMA', dbo, 'table', - eam_technical_status_change, 'column', depart_leader_signature_time; -EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠$瀛�', 'SCHEMA', dbo, 'table', eam_technical_status_change, - 'column', depart_leader_signature_comment; -EXEC sp_addextendedproperty 'MS_Description', 'HF缂栫爜', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', - hf_code; +ALTER TABLE [dbo].[eam_technical_status_change] + SET (LOCK_ESCALATION = TABLE) +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'涓婚敭', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'id' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍒涘缓浜�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'create_by' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍒涘缓鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'create_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鏇存柊浜�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'update_by' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鏇存柊鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'update_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍒犻櫎鏍囪', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'del_flag' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍙樻洿鍗曞彿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'change_order_num' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鍙樻洿鍗曠姸鎬�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'change_status' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鐢宠鍗曚綅', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'factory_org_code' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'缂栧埗浜�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'designer' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'缂栧埗鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'designer_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'浣跨敤鍗曚綅瀹ょ骇涓荤绛惧瓧', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'depart_header_signature' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'浣跨敤鍗曚綅瀹ょ骇涓荤绛惧瓧鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'depart_header_signature_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'浣跨敤鍗曚綅瀹ょ骇涓荤绛惧瓧缁撴灉', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'depart_header_signature_result' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'浣跨敤鍗曚綅瀹ょ骇涓荤鎰忚', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'depart_header_comment' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'浣跨敤鍗曚綅閮ㄧ骇涓荤绛惧瓧', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'depart_leader_signature' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'浣跨敤鍗曚綅閮ㄧ骇涓荤绛惧瓧鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'depart_leader_signature_time' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'浣跨敤鍗曚綅閮ㄧ骇涓荤绛惧瓧缁撴灉', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'depart_leader_signature_result' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'浣跨敤鍗曚綅閮ㄧ骇涓荤绛惧瓧', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'depart_leader_comment' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'HF缂栫爜', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'hf_code' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'澶囨敞', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change', + 'COLUMN', N'remark' +GO + +EXEC sp_addextendedproperty + 'MS_Description', N'鎶�鏈姸鎬佸彉鏇寸敵璇�', + 'SCHEMA', N'dbo', + 'TABLE', N'eam_technical_status_change' --鎶�鏈姸鎬佸彉鏇寸敵璇锋槑缁� diff --git "a/db/ZHR/process/\345\201\234\347\224\250\345\212\240\345\267\245\350\256\276\345\244\207\347\224\263\350\257\267.bpmn20.xml" "b/db/ZHR/process/\345\201\234\347\224\250\345\212\240\345\267\245\350\256\276\345\244\207\347\224\263\350\257\267.bpmn20.xml" new file mode 100644 index 0000000..c0ded4c --- /dev/null +++ "b/db/ZHR/process/\345\201\234\347\224\250\345\212\240\345\267\245\350\256\276\345\244\207\347\224\263\350\257\267.bpmn20.xml" @@ -0,0 +1,96 @@ +<?xml version="1.0" encoding="UTF-8"?> +<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef"> + <process id="technical_status_deactivate_process" name="鍋滅敤鍔犲伐璁惧鐢宠" flowable:processCategory="TECHNICAL_STATUS_DEACTIVATE_PROCESS"> + <startEvent id="startNode1" name="寮�濮�"> + <outgoing>Flow_0yfurvp</outgoing> + </startEvent> + <sequenceFlow id="Flow_0yfurvp" name="鎻愪氦" sourceRef="startNode1" targetRef="Activity_02hq39f" /> + <userTask id="Activity_02hq39f" name="鐢宠鎻愪氦"> + <incoming>Flow_0yfurvp</incoming> + <outgoing>Flow_06c497o</outgoing> + </userTask> + <sequenceFlow id="Flow_06c497o" name="鎻愪氦瀹屾垚" sourceRef="Activity_02hq39f" targetRef="Activity_1aymxw6" /> + <userTask id="Activity_1aymxw6" name="浣跨敤鍗曚綅瀹ょ骇涓荤瀹℃壒"> + <incoming>Flow_06c497o</incoming> + <outgoing>Flow_07sm00g</outgoing> + <outgoing>Flow_1y4h64d</outgoing> + </userTask> + <sequenceFlow id="Flow_07sm00g" name="閫氳繃" sourceRef="Activity_1aymxw6" targetRef="Activity_1abilq7"> + <conditionExpression xsi:type="tFormalExpression">${departHeaderConfrimFlag == 1}</conditionExpression> + </sequenceFlow> + <userTask id="Activity_1abilq7" name="浣跨敤鍗曚綅閮ㄧ骇涓荤瀹℃壒"> + <incoming>Flow_07sm00g</incoming> + <outgoing>Flow_16q19a6</outgoing> + </userTask> + <endEvent id="Event_0w00roh"> + <incoming>Flow_16q19a6</incoming> + </endEvent> + <sequenceFlow id="Flow_16q19a6" name="閫氳繃鎴栭┏鍥�" sourceRef="Activity_1abilq7" targetRef="Event_0w00roh" /> + <endEvent id="Event_057c1tu"> + <incoming>Flow_1y4h64d</incoming> + </endEvent> + <sequenceFlow id="Flow_1y4h64d" name="椹冲洖" sourceRef="Activity_1aymxw6" targetRef="Event_057c1tu"> + <conditionExpression xsi:type="tFormalExpression">${departHeaderConfrimFlag == 2}</conditionExpression> + </sequenceFlow> + </process> + <bpmndi:BPMNDiagram id="BPMNDiagram_flow"> + <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="technical_status_deactivate_process"> + <bpmndi:BPMNEdge id="Flow_1y4h64d_di" bpmnElement="Flow_1y4h64d"> + <di:waypoint x="310" y="340" /> + <di:waypoint x="372" y="340" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="330" y="322" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_16q19a6_di" bpmnElement="Flow_16q19a6"> + <di:waypoint x="260" y="520" /> + <di:waypoint x="260" y="592" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="192" y="554" width="56" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_07sm00g_di" bpmnElement="Flow_07sm00g"> + <di:waypoint x="260" y="380" /> + <di:waypoint x="260" y="440" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="228" y="407" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_06c497o_di" bpmnElement="Flow_06c497o"> + <di:waypoint x="260" y="240" /> + <di:waypoint x="260" y="300" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="207" y="266" width="45" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0yfurvp_di" bpmnElement="Flow_0yfurvp"> + <di:waypoint x="260" y="115" /> + <di:waypoint x="260" y="160" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="228" y="135" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke=""> + <omgdc:Bounds x="245" y="85" width="30" height="30" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="248" y="63" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_0d1w8ij_di" bpmnElement="Activity_02hq39f"> + <omgdc:Bounds x="210" y="160" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1fbagra_di" bpmnElement="Activity_1aymxw6"> + <omgdc:Bounds x="210" y="300" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_144fdht_di" bpmnElement="Activity_1abilq7"> + <omgdc:Bounds x="210" y="440" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_0w00roh_di" bpmnElement="Event_0w00roh"> + <omgdc:Bounds x="242" y="592" width="36" height="36" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_057c1tu_di" bpmnElement="Event_057c1tu"> + <omgdc:Bounds x="372" y="322" width="36" height="36" /> + </bpmndi:BPMNShape> + </bpmndi:BPMNPlane> + </bpmndi:BPMNDiagram> +</definitions> diff --git "a/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\345\217\230\346\233\264\347\224\263\350\257\267\346\265\201\347\250\213.bpmn20.xml" "b/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\345\217\230\346\233\264\347\224\263\350\257\267\346\265\201\347\250\213.bpmn20.xml" new file mode 100644 index 0000000..747045c --- /dev/null +++ "b/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\345\217\230\346\233\264\347\224\263\350\257\267\346\265\201\347\250\213.bpmn20.xml" @@ -0,0 +1,96 @@ +<?xml version="1.0" encoding="UTF-8"?> +<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef"> + <process id="technical_status_change_process" name="鎶�鏈姸鎬佸彉鏇寸敵璇锋祦绋�" flowable:processCategory="TECHNICAL_STATUS_CHANGE_PROCESS"> + <startEvent id="startNode1" name="寮�濮�"> + <outgoing>Flow_1a5561e</outgoing> + </startEvent> + <sequenceFlow id="Flow_1a5561e" sourceRef="startNode1" targetRef="Activity_0vjpbto" /> + <userTask id="Activity_0vjpbto" name="鍙樻洿鎻愪氦"> + <incoming>Flow_1a5561e</incoming> + <outgoing>Flow_049516g</outgoing> + </userTask> + <sequenceFlow id="Flow_049516g" name="鎻愪氦瀹屾垚" sourceRef="Activity_0vjpbto" targetRef="Activity_13y6uei" /> + <userTask id="Activity_13y6uei" name="浣跨敤鍗曚綅瀹ょ骇棰嗗瀹℃牳"> + <incoming>Flow_049516g</incoming> + <outgoing>Flow_1p7phbk</outgoing> + <outgoing>Flow_0kncgmv</outgoing> + </userTask> + <userTask id="Activity_00rff81" name="浣跨敤鍗曚綅閮ㄧ骇棰嗗瀹℃牳"> + <incoming>Flow_1p7phbk</incoming> + <outgoing>Flow_09781az</outgoing> + </userTask> + <sequenceFlow id="Flow_1p7phbk" name="閫氳繃" sourceRef="Activity_13y6uei" targetRef="Activity_00rff81"> + <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 1}</conditionExpression> + </sequenceFlow> + <endEvent id="Event_0jo3kio"> + <incoming>Flow_0kncgmv</incoming> + </endEvent> + <sequenceFlow id="Flow_0kncgmv" name="椹冲洖" sourceRef="Activity_13y6uei" targetRef="Event_0jo3kio"> + <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 2}</conditionExpression> + </sequenceFlow> + <endEvent id="Event_1nq08yu" name=""> + <incoming>Flow_09781az</incoming> + </endEvent> + <sequenceFlow id="Flow_09781az" name="閫氳繃鎴栭┏鍥�" sourceRef="Activity_00rff81" targetRef="Event_1nq08yu" /> + </process> + <bpmndi:BPMNDiagram id="BPMNDiagram_flow"> + <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="technical_status_change_process"> + <bpmndi:BPMNEdge id="Flow_09781az_di" bpmnElement="Flow_09781az"> + <di:waypoint x="150" y="350" /> + <di:waypoint x="150" y="402" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="162" y="371" width="56" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0kncgmv_di" bpmnElement="Flow_0kncgmv"> + <di:waypoint x="200" y="170" /> + <di:waypoint x="292" y="170" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="228" y="152" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1p7phbk_di" bpmnElement="Flow_1p7phbk"> + <di:waypoint x="150" y="210" /> + <di:waypoint x="150" y="270" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="154" y="236" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_049516g_di" bpmnElement="Flow_049516g"> + <di:waypoint x="150" y="70" /> + <di:waypoint x="150" y="130" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="157" y="96" width="45" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1a5561e_di" bpmnElement="Flow_1a5561e"> + <di:waypoint x="150" y="-65" /> + <di:waypoint x="150" y="-10" /> + </bpmndi:BPMNEdge> + <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke=""> + <omgdc:Bounds x="135" y="-95" width="30" height="30" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="138" y="-117" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1kksbkh_di" bpmnElement="Activity_0vjpbto"> + <omgdc:Bounds x="100" y="-10" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1nkn08l_di" bpmnElement="Activity_13y6uei"> + <omgdc:Bounds x="100" y="130" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_018xpql_di" bpmnElement="Activity_00rff81"> + <omgdc:Bounds x="100" y="270" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_0jo3kio_di" bpmnElement="Event_0jo3kio"> + <omgdc:Bounds x="292" y="152" width="36" height="36" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_1nq08yu_di" bpmnElement="Event_1nq08yu"> + <omgdc:Bounds x="132" y="402" width="36" height="36" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="145" y="525" width="12" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNShape> + </bpmndi:BPMNPlane> + </bpmndi:BPMNDiagram> +</definitions> diff --git "a/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\345\267\245\345\215\225\345\217\230\346\233\264\346\265\201\347\250\213.bpmn20.xml" "b/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\345\267\245\345\215\225\345\217\230\346\233\264\346\265\201\347\250\213.bpmn20.xml" new file mode 100644 index 0000000..e988b76 --- /dev/null +++ "b/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\345\267\245\345\215\225\345\217\230\346\233\264\346\265\201\347\250\213.bpmn20.xml" @@ -0,0 +1,130 @@ +<?xml version="1.0" encoding="UTF-8"?> +<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef"> + <process id="evaluation_order_change_process" name="鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇存祦绋�" flowable:processCategory="EVALUATION_ORDER_CHANGE_PROCESS"> + <startEvent id="startNode1" name="寮�濮�"> + <outgoing>Flow_1lrjfyh</outgoing> + </startEvent> + <userTask id="Activity_0xr313b" name="鎻愪氦鍙樻洿"> + <incoming>Flow_1lrjfyh</incoming> + <outgoing>Flow_0rs715w</outgoing> + </userTask> + <sequenceFlow id="Flow_0rs715w" name="鎻愪氦瀹屾垚" sourceRef="Activity_0xr313b" targetRef="Activity_0o3p1rw" /> + <sequenceFlow id="Flow_1lrjfyh" name="" sourceRef="startNode1" targetRef="Activity_0xr313b" /> + <endEvent id="Event_1ljzz5l"> + <incoming>Flow_03s2kfi</incoming> + </endEvent> + <sequenceFlow id="Flow_03s2kfi" name="椹冲洖" sourceRef="Activity_0o3p1rw" targetRef="Event_1ljzz5l"> + <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 2 }</conditionExpression> + </sequenceFlow> + <userTask id="Activity_0o3p1rw" name="浣跨敤鍗曚綅瀹ょ骇棰嗗瀹℃牳"> + <incoming>Flow_0rs715w</incoming> + <outgoing>Flow_03s2kfi</outgoing> + <outgoing>Flow_1bl4oj1</outgoing> + </userTask> + <endEvent id="Event_094wrnm"> + <incoming>Flow_0glq4rb</incoming> + </endEvent> + <userTask id="Activity_0e2mtnc" name="閮ㄩ棬棰嗗瀹℃牳"> + <incoming>Flow_1bl4oj1</incoming> + <outgoing>Flow_1rtxiqx</outgoing> + <outgoing>Flow_0glq4rb</outgoing> + </userTask> + <sequenceFlow id="Flow_1bl4oj1" name="閫氳繃" sourceRef="Activity_0o3p1rw" targetRef="Activity_0e2mtnc"> + <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 1 }</conditionExpression> + </sequenceFlow> + <userTask id="Activity_1ugagrs" name="鐢熶骇淇濋殰閮ㄩ瀵煎鏍�"> + <incoming>Flow_1rtxiqx</incoming> + <outgoing>Flow_1qk08w9</outgoing> + </userTask> + <sequenceFlow id="Flow_1rtxiqx" name="閫氳繃" sourceRef="Activity_0e2mtnc" targetRef="Activity_1ugagrs"> + <conditionExpression xsi:type="tFormalExpression">${departLeaderConfirmFlag == 1}</conditionExpression> + </sequenceFlow> + <endEvent id="Event_1byavvu"> + <incoming>Flow_1qk08w9</incoming> + </endEvent> + <sequenceFlow id="Flow_1qk08w9" name="閫氳繃鎴栭┏鍥�" sourceRef="Activity_1ugagrs" targetRef="Event_1byavvu" /> + <sequenceFlow id="Flow_0glq4rb" name="椹冲洖" sourceRef="Activity_0e2mtnc" targetRef="Event_094wrnm"> + <conditionExpression xsi:type="tFormalExpression">${departLeaderConfirmFlag == 2}</conditionExpression> + </sequenceFlow> + </process> + <bpmndi:BPMNDiagram id="BPMNDiagram_flow"> + <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="evaluation_order_change_process"> + <bpmndi:BPMNEdge id="Flow_0glq4rb_di" bpmnElement="Flow_0glq4rb"> + <di:waypoint x="340" y="360" /> + <di:waypoint x="340" y="288" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="344" y="321" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1qk08w9_di" bpmnElement="Flow_1qk08w9"> + <di:waypoint x="570" y="400" /> + <di:waypoint x="662" y="400" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="582" y="382" width="56" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1rtxiqx_di" bpmnElement="Flow_1rtxiqx"> + <di:waypoint x="390" y="400" /> + <di:waypoint x="470" y="400" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="418" y="382" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1bl4oj1_di" bpmnElement="Flow_1bl4oj1"> + <di:waypoint x="220" y="400" /> + <di:waypoint x="290" y="400" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="244" y="382" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_03s2kfi_di" bpmnElement="Flow_03s2kfi"> + <di:waypoint x="170" y="440" /> + <di:waypoint x="170" y="492" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="174" y="463" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1lrjfyh_di" bpmnElement="Flow_1lrjfyh"> + <di:waypoint x="170" y="135" /> + <di:waypoint x="170" y="200" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="180" y="153" width="11" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0rs715w_di" bpmnElement="Flow_0rs715w"> + <di:waypoint x="170" y="280" /> + <di:waypoint x="170" y="360" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="117" y="317" width="45" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke=""> + <omgdc:Bounds x="155" y="105" width="30" height="30" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="158" y="81" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1f3p44a_di" bpmnElement="Activity_0xr313b"> + <omgdc:Bounds x="120" y="200" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_1ljzz5l_di" bpmnElement="Event_1ljzz5l"> + <omgdc:Bounds x="152" y="492" width="36" height="36" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_0vfhldg_di" bpmnElement="Activity_0o3p1rw"> + <omgdc:Bounds x="120" y="360" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_094wrnm_di" bpmnElement="Event_094wrnm"> + <omgdc:Bounds x="322" y="252" width="36" height="36" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1iibt8n_di" bpmnElement="Activity_0e2mtnc"> + <omgdc:Bounds x="290" y="360" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_17vz2zb_di" bpmnElement="Activity_1ugagrs"> + <omgdc:Bounds x="470" y="360" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_1byavvu_di" bpmnElement="Event_1byavvu"> + <omgdc:Bounds x="662" y="382" width="36" height="36" /> + </bpmndi:BPMNShape> + </bpmndi:BPMNPlane> + </bpmndi:BPMNDiagram> +</definitions> diff --git "a/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\346\265\201\347\250\213.bpmn20.xml" "b/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\346\265\201\347\250\213.bpmn20.xml" new file mode 100644 index 0000000..532b1b7 --- /dev/null +++ "b/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\346\265\201\347\250\213.bpmn20.xml" @@ -0,0 +1,342 @@ +<?xml version="1.0" encoding="UTF-8"?> +<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef"> + <process id="technical_status_evaluation_process" name="鎶�鏈姸鎬侀壌瀹氭祦绋�" flowable:processCategory="TECHNICAL_STATUS_EVALUATION"> + <startEvent id="startNode1" name="寮�濮�"> + <outgoing>Flow_08kar5y</outgoing> + </startEvent> + <sequenceFlow id="Flow_08kar5y" name="棰嗗彇" sourceRef="startNode1" targetRef="Activity_1nstx24" /> + <inclusiveGateway id="Gateway_0t8e1ct"> + <incoming>Flow_14ezqsp</incoming> + <outgoing>Flow_1aeofia</outgoing> + <outgoing>Flow_0qu8c97</outgoing> + <outgoing>Flow_0j0xozz</outgoing> + </inclusiveGateway> + <sequenceFlow id="Flow_14ezqsp" name="鍒嗛厤鍊欓�変汉" sourceRef="Activity_1nstx24" targetRef="Gateway_0t8e1ct" /> + <sequenceFlow id="Flow_1aeofia" name="瀛樺湪瀹夊叏瑁呯疆妫�鏌ラ」" sourceRef="Gateway_0t8e1ct" targetRef="safety_equipment_check"> + <conditionExpression xsi:type="tFormalExpression">${hasSafetyEquipmentCheck == 1}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_0qu8c97" name="瀛樺湪璁惧绮惧害妫�鏌ラ」" sourceRef="Gateway_0t8e1ct" targetRef="equipment_precision_check"> + <conditionExpression xsi:type="tFormalExpression">${hasPrecisionCheck == 1}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_0j0xozz" name="瀛樺湪鍏朵粬妫�鏌ラ」" sourceRef="Gateway_0t8e1ct" targetRef="other_check"> + <conditionExpression xsi:type="tFormalExpression">${hasOtherCheck == 1}</conditionExpression> + </sequenceFlow> + <userTask id="Activity_1nstx24" name="宸ュ崟棰嗗彇"> + <incoming>Flow_08kar5y</incoming> + <outgoing>Flow_14ezqsp</outgoing> + </userTask> + <userTask id="safety_equipment_check" name="瀹夊叏瑁呯疆妫�鏌�"> + <incoming>Flow_1aeofia</incoming> + <incoming>Flow_17a4vks</incoming> + <outgoing>Flow_1b2jdti</outgoing> + </userTask> + <userTask id="equipment_precision_check" name="璁惧绮惧害妫�鏌�"> + <incoming>Flow_0qu8c97</incoming> + <incoming>Flow_10sx1x8</incoming> + <outgoing>Flow_0etgxyr</outgoing> + </userTask> + <userTask id="other_check" name="鍏朵粬妫�鏌�"> + <incoming>Flow_0j0xozz</incoming> + <incoming>Flow_0qmhfoe</incoming> + <outgoing>Flow_0x0nou7</outgoing> + </userTask> + <inclusiveGateway id="Gateway_05inlwj"> + <incoming>Flow_0ce2jd6</incoming> + <incoming>Flow_1830g31</incoming> + <incoming>Flow_14d65ly</incoming> + <outgoing>Flow_0gawkvp</outgoing> + </inclusiveGateway> + <userTask id="Activity_0vx3umo" name="缁翠慨瀹や富浠荤瀛�"> + <incoming>Flow_1r37r0q</incoming> + <outgoing>Flow_0l049xa</outgoing> + <outgoing>Flow_0iqfkbu</outgoing> + </userTask> + <userTask id="Activity_1o9pk5t" name="宸ヨ壓鍛樼瀛�"> + <incoming>Flow_0iqfkbu</incoming> + <incoming>Flow_0iu1nap</incoming> + <outgoing>Flow_1d2uh4m</outgoing> + </userTask> + <userTask id="Activity_1ebqzed" name="浣跨敤鍗曚綅鎶�鏈富绠$瀛�"> + <incoming>Flow_1d2uh4m</incoming> + <outgoing>Flow_0k09keo</outgoing> + <outgoing>Flow_0iu1nap</outgoing> + </userTask> + <userTask id="Activity_0yigfu5" name="璁惧妫�鏌ュ憳绛惧瓧"> + <incoming>Flow_0k09keo</incoming> + <outgoing>Flow_01nyfzi</outgoing> + </userTask> + <endEvent id="Event_1lkemxs"> + <incoming>Flow_01nyfzi</incoming> + </endEvent> + <sequenceFlow id="Flow_1b2jdti" name="妫�鏌ュ畬鎴�" sourceRef="safety_equipment_check" targetRef="safety_equipment_check_confirm" /> + <sequenceFlow id="Flow_0etgxyr" name="妫�鏌ュ畬鎴�" sourceRef="equipment_precision_check" targetRef="equipment_precision_check_confirm" /> + <sequenceFlow id="Flow_0x0nou7" name="妫�鏌ュ畬鎴�" sourceRef="other_check" targetRef="other_check_confirm" /> + <userTask id="safety_equipment_check_confirm" name="缁翠慨瀹や富浠荤瀛�"> + <incoming>Flow_1b2jdti</incoming> + <outgoing>Flow_0ce2jd6</outgoing> + <outgoing>Flow_17a4vks</outgoing> + </userTask> + <userTask id="equipment_precision_check_confirm" name="缁翠慨瀹や富浠荤瀛�"> + <incoming>Flow_0etgxyr</incoming> + <outgoing>Flow_1830g31</outgoing> + <outgoing>Flow_10sx1x8</outgoing> + </userTask> + <userTask id="other_check_confirm" name="缁翠慨瀹や富浠荤瀛�"> + <incoming>Flow_0x0nou7</incoming> + <outgoing>Flow_14d65ly</outgoing> + <outgoing>Flow_0qmhfoe</outgoing> + </userTask> + <sequenceFlow id="Flow_0ce2jd6" name="閫氳繃" sourceRef="safety_equipment_check_confirm" targetRef="Gateway_05inlwj"> + <conditionExpression xsi:type="tFormalExpression">${safetyEquipmentCheckFlag == 1}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_1830g31" name="閫氳繃" sourceRef="equipment_precision_check_confirm" targetRef="Gateway_05inlwj"> + <conditionExpression xsi:type="tFormalExpression">${precisionCheckFlag == 1}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_14d65ly" name="閫氳繃" sourceRef="other_check_confirm" targetRef="Gateway_05inlwj"> + <conditionExpression xsi:type="tFormalExpression">${otherCheckFlag == 1}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_17a4vks" name="椹冲洖" sourceRef="safety_equipment_check_confirm" targetRef="safety_equipment_check"> + <conditionExpression xsi:type="tFormalExpression">${safetyEquipmentCheckFlag == 2}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_10sx1x8" name="椹冲洖" sourceRef="equipment_precision_check_confirm" targetRef="equipment_precision_check"> + <conditionExpression xsi:type="tFormalExpression">${precisionCheckFlag == 2}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_0qmhfoe" name="椹冲洖" sourceRef="other_check_confirm" targetRef="other_check"> + <conditionExpression xsi:type="tFormalExpression">${otherCheckFlag == 2}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_0gawkvp" name="閫氳繃" sourceRef="Gateway_05inlwj" targetRef="Activity_0w2esvf" /> + <sequenceFlow id="Flow_1r37r0q" name="閫氳繃" sourceRef="Activity_0w2esvf" targetRef="Activity_0vx3umo" /> + <sequenceFlow id="Flow_0l049xa" name="椹冲洖" sourceRef="Activity_0vx3umo" targetRef="Activity_0w2esvf"> + <conditionExpression xsi:type="tFormalExpression">${repairManagerApprovalFlag == 2}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_0iqfkbu" name="閫氳繃" sourceRef="Activity_0vx3umo" targetRef="Activity_1o9pk5t"> + <conditionExpression xsi:type="tFormalExpression">${repairManagerApprovalFlag == 1}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_1d2uh4m" name="閫氳繃" sourceRef="Activity_1o9pk5t" targetRef="Activity_1ebqzed" /> + <sequenceFlow id="Flow_0k09keo" name="閫氳繃" sourceRef="Activity_1ebqzed" targetRef="Activity_0yigfu5"> + <conditionExpression xsi:type="tFormalExpression">${technicalLeaderApprovalFlag == 1}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_01nyfzi" name="閫氳繃" sourceRef="Activity_0yigfu5" targetRef="Event_1lkemxs" /> + <sequenceFlow id="Flow_0iu1nap" name="椹冲洖" sourceRef="Activity_1ebqzed" targetRef="Activity_1o9pk5t"> + <conditionExpression xsi:type="tFormalExpression">${technicalLeaderApprovalFlag == 2}</conditionExpression> + </sequenceFlow> + <userTask id="Activity_0w2esvf" name="缁翠慨浜哄憳绛惧瓧"> + <incoming>Flow_0gawkvp</incoming> + <incoming>Flow_0l049xa</incoming> + <outgoing>Flow_1r37r0q</outgoing> + </userTask> + </process> + <bpmndi:BPMNDiagram id="BPMNDiagram_flow"> + <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="technical_status_evaluation_process"> + <bpmndi:BPMNEdge id="Flow_0iu1nap_di" bpmnElement="Flow_0iu1nap"> + <di:waypoint x="730" y="400" /> + <di:waypoint x="800" y="400" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="756" y="403" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_01nyfzi_di" bpmnElement="Flow_01nyfzi"> + <di:waypoint x="460" y="380" /> + <di:waypoint x="378" y="380" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="408" y="362" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0k09keo_di" bpmnElement="Flow_0k09keo"> + <di:waypoint x="630" y="380" /> + <di:waypoint x="560" y="380" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="584" y="362" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1d2uh4m_di" bpmnElement="Flow_1d2uh4m"> + <di:waypoint x="800" y="360" /> + <di:waypoint x="730" y="360" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="754" y="342" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0iqfkbu_di" bpmnElement="Flow_0iqfkbu"> + <di:waypoint x="850" y="280" /> + <di:waypoint x="850" y="340" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="854" y="303" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0l049xa_di" bpmnElement="Flow_0l049xa"> + <di:waypoint x="880" y="200" /> + <di:waypoint x="880" y="140" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="888" y="167" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1r37r0q_di" bpmnElement="Flow_1r37r0q"> + <di:waypoint x="840" y="140" /> + <di:waypoint x="840" y="200" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="808" y="167" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0gawkvp_di" bpmnElement="Flow_0gawkvp"> + <di:waypoint x="735" y="100" /> + <di:waypoint x="800" y="100" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="756" y="82" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0qmhfoe_di" bpmnElement="Flow_0qmhfoe"> + <di:waypoint x="510" y="220" /> + <di:waypoint x="430" y="220" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="459" y="223" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_10sx1x8_di" bpmnElement="Flow_10sx1x8"> + <di:waypoint x="510" y="120" /> + <di:waypoint x="430" y="120" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="459" y="122" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_17a4vks_di" bpmnElement="Flow_17a4vks"> + <di:waypoint x="510" y="20" /> + <di:waypoint x="430" y="20" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="459" y="23" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_14d65ly_di" bpmnElement="Flow_14d65ly"> + <di:waypoint x="610" y="200" /> + <di:waypoint x="710" y="200" /> + <di:waypoint x="710" y="125" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="649" y="182" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1830g31_di" bpmnElement="Flow_1830g31"> + <di:waypoint x="610" y="100" /> + <di:waypoint x="685" y="100" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="636" y="82" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0ce2jd6_di" bpmnElement="Flow_0ce2jd6"> + <di:waypoint x="610" y="0" /> + <di:waypoint x="710" y="0" /> + <di:waypoint x="710" y="75" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="649" y="-18" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0x0nou7_di" bpmnElement="Flow_0x0nou7"> + <di:waypoint x="430" y="200" /> + <di:waypoint x="510" y="200" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="448" y="182" width="45" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0etgxyr_di" bpmnElement="Flow_0etgxyr"> + <di:waypoint x="430" y="100" /> + <di:waypoint x="510" y="100" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="448" y="82" width="45" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1b2jdti_di" bpmnElement="Flow_1b2jdti"> + <di:waypoint x="430" y="0" /> + <di:waypoint x="510" y="0" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="448" y="-18" width="45" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0j0xozz_di" bpmnElement="Flow_0j0xozz"> + <di:waypoint x="240" y="125" /> + <di:waypoint x="240" y="200" /> + <di:waypoint x="330" y="200" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="241" y="183" width="78" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0qu8c97_di" bpmnElement="Flow_0qu8c97"> + <di:waypoint x="265" y="100" /> + <di:waypoint x="330" y="100" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="251" y="66" width="78" height="27" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1aeofia_di" bpmnElement="Flow_1aeofia"> + <di:waypoint x="240" y="75" /> + <di:waypoint x="240" y="0" /> + <di:waypoint x="330" y="0" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="241" y="-34" width="78" height="27" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_14ezqsp_di" bpmnElement="Flow_14ezqsp"> + <di:waypoint x="120" y="100" /> + <di:waypoint x="215" y="100" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="140" y="82" width="56" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_08kar5y_di" bpmnElement="Flow_08kar5y"> + <di:waypoint x="-45" y="100" /> + <di:waypoint x="20" y="100" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="-24" y="82" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke=""> + <omgdc:Bounds x="-75" y="85" width="30" height="30" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="-73" y="122" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Gateway_0n5p3kz_di" bpmnElement="Gateway_0t8e1ct"> + <omgdc:Bounds x="215" y="75" width="50" height="50" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_15ga6fi_di" bpmnElement="Activity_1nstx24"> + <omgdc:Bounds x="20" y="60" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1axd1mf_di" bpmnElement="safety_equipment_check"> + <omgdc:Bounds x="330" y="-40" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_09f2psv_di" bpmnElement="equipment_precision_check"> + <omgdc:Bounds x="330" y="60" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_0hka9ht_di" bpmnElement="other_check"> + <omgdc:Bounds x="330" y="160" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Gateway_1yf4krn_di" bpmnElement="Gateway_05inlwj"> + <omgdc:Bounds x="685" y="75" width="50" height="50" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_0jqk7kf_di" bpmnElement="Activity_0vx3umo"> + <omgdc:Bounds x="800" y="200" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1utlj8v_di" bpmnElement="Activity_1o9pk5t"> + <omgdc:Bounds x="800" y="340" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_093o9g6_di" bpmnElement="Activity_1ebqzed"> + <omgdc:Bounds x="630" y="340" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1pq8o9r_di" bpmnElement="Activity_0yigfu5"> + <omgdc:Bounds x="460" y="340" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_1lkemxs_di" bpmnElement="Event_1lkemxs"> + <omgdc:Bounds x="342" y="362" width="36" height="36" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_11446n6_di" bpmnElement="safety_equipment_check_confirm"> + <omgdc:Bounds x="510" y="-40" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1yeaht6_di" bpmnElement="equipment_precision_check_confirm"> + <omgdc:Bounds x="510" y="60" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_10ic56v_di" bpmnElement="other_check_confirm"> + <omgdc:Bounds x="510" y="160" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_0o51wl1_di" bpmnElement="Activity_0w2esvf"> + <omgdc:Bounds x="800" y="60" width="100" height="80" /> + </bpmndi:BPMNShape> + </bpmndi:BPMNPlane> + </bpmndi:BPMNDiagram> +</definitions> diff --git "a/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\347\224\263\350\257\267\346\265\201\347\250\213.bpmn20.xml" "b/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\347\224\263\350\257\267\346\265\201\347\250\213.bpmn20.xml" new file mode 100644 index 0000000..465ac57 --- /dev/null +++ "b/db/ZHR/process/\346\212\200\346\234\257\347\212\266\346\200\201\351\211\264\345\256\232\347\224\263\350\257\267\346\265\201\347\250\213.bpmn20.xml" @@ -0,0 +1,130 @@ +<?xml version="1.0" encoding="UTF-8"?> +<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:bioc="http://bpmn.io/schema/bpmn/biocolor/1.0" xmlns:flowable="http://flowable.org/bpmn" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.flowable.org/processdef"> + <process id="technical_status_evaluation_apply_process" name="鎶�鏈姸鎬侀壌瀹氱敵璇锋祦绋�" flowable:processCategory="TECHNICAL_STATUS_EVALUATION_APPLY_PROCESS"> + <startEvent id="startNode1" name="寮�濮�"> + <outgoing>Flow_047mezk</outgoing> + </startEvent> + <sequenceFlow id="Flow_047mezk" name="鎻愪氦" sourceRef="startNode1" targetRef="Activity_0phqw21" /> + <userTask id="Activity_0phqw21" name="鐢宠鎻愪氦"> + <incoming>Flow_047mezk</incoming> + <outgoing>Flow_11nxzgi</outgoing> + </userTask> + <userTask id="Activity_1b9d829" name="鐢宠鍗曚綅瀹ょ骇棰嗗瀹℃壒"> + <incoming>Flow_11nxzgi</incoming> + <outgoing>Flow_0b42mpn</outgoing> + <outgoing>Flow_09iuey6</outgoing> + </userTask> + <sequenceFlow id="Flow_11nxzgi" name="鎻愪氦瀹屾垚" sourceRef="Activity_0phqw21" targetRef="Activity_1b9d829" /> + <sequenceFlow id="Flow_0b42mpn" name="閫氳繃" sourceRef="Activity_1b9d829" targetRef="Activity_0s463r9"> + <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 1}</conditionExpression> + </sequenceFlow> + <sequenceFlow id="Flow_1gcy86s" name="閫氳繃" sourceRef="Activity_0s463r9" targetRef="Activity_1c09htz"> + <conditionExpression xsi:type="tFormalExpression">${productionHeaderConfirmFlag == 1}</conditionExpression> + </sequenceFlow> + <endEvent id="Event_0d71i5o"> + <incoming>Flow_1q3g8eo</incoming> + </endEvent> + <userTask id="Activity_1c09htz" name="鐢熶骇淇濋殰閮ㄩ瀵煎鎵�"> + <incoming>Flow_1gcy86s</incoming> + <outgoing>Flow_1q3g8eo</outgoing> + </userTask> + <userTask id="Activity_0s463r9" name="鐢熶骇璁惧绠$悊涓荤瀹℃壒"> + <incoming>Flow_0b42mpn</incoming> + <outgoing>Flow_1gcy86s</outgoing> + <outgoing>Flow_1wzlz4a</outgoing> + </userTask> + <sequenceFlow id="Flow_1q3g8eo" name="閫氳繃鎴栭┏鍥�" sourceRef="Activity_1c09htz" targetRef="Event_0d71i5o" /> + <endEvent id="Event_0qjd1ay"> + <incoming>Flow_1wzlz4a</incoming> + </endEvent> + <sequenceFlow id="Flow_1wzlz4a" name="椹冲洖" sourceRef="Activity_0s463r9" targetRef="Event_0qjd1ay"> + <conditionExpression xsi:type="tFormalExpression">${productionHeaderConfirmFlag == 2}</conditionExpression> + </sequenceFlow> + <endEvent id="Event_14kz3sw"> + <incoming>Flow_09iuey6</incoming> + </endEvent> + <sequenceFlow id="Flow_09iuey6" name="椹冲洖" sourceRef="Activity_1b9d829" targetRef="Event_14kz3sw"> + <conditionExpression xsi:type="tFormalExpression">${departHeaderConfirmFlag == 2}</conditionExpression> + </sequenceFlow> + </process> + <bpmndi:BPMNDiagram id="BPMNDiagram_flow"> + <bpmndi:BPMNPlane id="BPMNPlane_flow" bpmnElement="technical_status_evaluation_apply_process"> + <bpmndi:BPMNEdge id="Flow_09iuey6_di" bpmnElement="Flow_09iuey6"> + <di:waypoint x="260" y="320" /> + <di:waypoint x="332" y="320" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="285" y="302" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1wzlz4a_di" bpmnElement="Flow_1wzlz4a"> + <di:waypoint x="260" y="460" /> + <di:waypoint x="332" y="460" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="285" y="442" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1q3g8eo_di" bpmnElement="Flow_1q3g8eo"> + <di:waypoint x="210" y="650" /> + <di:waypoint x="210" y="702" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="152" y="673" width="56" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_1gcy86s_di" bpmnElement="Flow_1gcy86s"> + <di:waypoint x="210" y="500" /> + <di:waypoint x="210" y="570" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="178" y="532" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_0b42mpn_di" bpmnElement="Flow_0b42mpn"> + <di:waypoint x="210" y="360" /> + <di:waypoint x="210" y="420" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="178" y="387" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_11nxzgi_di" bpmnElement="Flow_11nxzgi"> + <di:waypoint x="210" y="220" /> + <di:waypoint x="210" y="280" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="157" y="247" width="45" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNEdge id="Flow_047mezk_di" bpmnElement="Flow_047mezk"> + <di:waypoint x="210" y="75" /> + <di:waypoint x="210" y="140" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="178" y="93" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNEdge> + <bpmndi:BPMNShape id="BPMNShape_startNode1" bpmnElement="startNode1" bioc:stroke=""> + <omgdc:Bounds x="195" y="45" width="30" height="30" /> + <bpmndi:BPMNLabel> + <omgdc:Bounds x="198" y="23" width="23" height="14" /> + </bpmndi:BPMNLabel> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_0kpg64e_di" bpmnElement="Activity_0phqw21"> + <omgdc:Bounds x="160" y="140" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1xg7mgb_di" bpmnElement="Activity_1b9d829"> + <omgdc:Bounds x="160" y="280" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_0d71i5o_di" bpmnElement="Event_0d71i5o"> + <omgdc:Bounds x="192" y="702" width="36" height="36" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_1eozmdz_di" bpmnElement="Activity_1c09htz"> + <omgdc:Bounds x="160" y="570" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Activity_0cax4o1_di" bpmnElement="Activity_0s463r9"> + <omgdc:Bounds x="160" y="420" width="100" height="80" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_0qjd1ay_di" bpmnElement="Event_0qjd1ay"> + <omgdc:Bounds x="332" y="442" width="36" height="36" /> + </bpmndi:BPMNShape> + <bpmndi:BPMNShape id="Event_14kz3sw_di" bpmnElement="Event_14kz3sw"> + <omgdc:Bounds x="332" y="302" width="36" height="36" /> + </bpmndi:BPMNShape> + </bpmndi:BPMNPlane> + </bpmndi:BPMNDiagram> +</definitions> 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 9627596..bf95163 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 @@ -35,7 +35,7 @@ String TECHNICAL_STATUS_EVALUATION_ORDER_CHANGE_CODE_RULE = "TechnicalStatusEvaluationOrderChangeCodeRule"; //鎶�鏈姸鎬佸彉鏇寸紪鐮佽鍒� String TECHNICAL_STATUS_CHANGE_CODE_RULE = "TechnicalStatusChangeCodeRule"; - //鎶�鏈姸鎬佸彉鏇寸紪鐮佽鍒� + //鎶�鏈姸鎬侀壌瀹氱敵璇风紪鐮佽鍒� String TECHNICAL_STATUS_EVALUATION_APPLY_CODE_RULE = "TechnicalStatusEvaluationApplyCodeRule"; //鍋滅敤鍔犲伐璁惧鐢宠缂栫爜瑙勫垯 String TECHNICAL_STATUS_DEACTIVATE_CODE_RULE = "TechnicalStatusDeactivateCodeRule"; diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusChangeDetail.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusChangeDetail.java index 0a4489b..6654758 100644 --- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusChangeDetail.java +++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/entity/EamTechnicalStatusChangeDetail.java @@ -65,9 +65,6 @@ /**楠屾敹妫�鏌ョ粨鏋�;澶т慨銆佹敼閫� 闇�瑕佸~鍐欓獙鏀剁粨鏋滐紝鎼縼鎸夌収鎶�鏈姸鎬侀壌瀹氬伐鍗曠淮鎶わ紝鍏朵粬鏆傛湭浣跨敤鍒帮紝鍙鐣欐绫诲瀷*/ @ApiModelProperty(value = "楠屾敹妫�鏌ョ粨鏋�;澶т慨銆佹敼閫� 闇�瑕佸~鍐欓獙鏀剁粨鏋滐紝鎼縼鎸夌収鎶�鏈姸鎬侀壌瀹氬伐鍗曠淮鎶わ紝鍏朵粬鏆傛湭浣跨敤鍒帮紝鍙鐣欐绫诲瀷") private String acceptanceCheckResult; - /**鎶�鏈姸鎬侀壌瀹氬伐鍗旾D;鎼縼浣跨敤*/ - @ApiModelProperty(value = "鎶�鏈姸鎬侀壌瀹氬伐鍗旾D;鎼縼浣跨敤") - private String orderId; //鍒楄〃灞曠ず @TableField(exist = false) -- Gitblit v1.9.3