From fae95228037f0c1304c1917ae5fff452f2160c5a Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期四, 05 十一月 2026 17:10:50 +0800
Subject: [PATCH] feat: add process knowledge and after-sales workflows
---
sql/mysql/after_sale_collaboration_menu_20261105.sql | 14
yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/finance/ErpAfterSaleFinanceDraftService.java | 79 +++
yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/dataobject/finance/ErpAfterSaleFinanceDraftDO.java | 33 +
yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/enums/ErrorCodeConstants.java | 2
yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/dto/AfterSaleFinanceReviewDTO.java | 11
yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/ticket/AfterSaleTicketController.java | 13
yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/AfterSaleFinanceDraftApi.java | 12
yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/dto/AfterSaleFinanceDraftCreateDTO.java | 18
sql/mysql/after_sale_collaboration_20261105.sql | 19
yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/collaboration/AfterSaleCollaborationMapper.java | 8
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeReferenceDO.java | 18
yudao-module-aftersales/pom.xml | 5
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeDO.java | 27 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeStandardDO.java | 17
yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/finance/ErpAfterSaleFinanceDraftMapper.java | 8
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeStandardMapper.java | 8
yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/collaboration/AfterSaleCollaborationController.java | 64 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeMapper.java | 8
sql/mysql/after_sale_finance_draft_menu_20261105.sql | 10
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeReferenceMapper.java | 8
yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/sale/ErpSaleOrderServiceImpl.java | 11
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeResourceDO.java | 19
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/knowledge/KnowledgeController.java | 94 +++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeResourceMapper.java | 8
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeSearchService.java | 86 +++
sql/mysql/after_sale_finance_draft_20261105.sql | 63 ++
yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/dataobject/collaboration/AfterSaleCollaborationDO.java | 42 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeMatch.java | 31 +
sql/mysql/process_knowledge_schema_20261105.sql | 83 +++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeWriteService.java | 242 ++++++++++
sql/mysql/process_knowledge_menu_20261105.sql | 23
yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/controller/admin/finance/ErpAfterSaleFinanceDraftController.java | 37 +
sql/mysql/process_knowledge_entry_20261105.sql | 18
yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/service/collaboration/AfterSaleCollaborationService.java | 231 +++++++++
yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/service/ticket/AfterSaleLedgerService.java | 24 +
35 files changed, 1,394 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/after_sale_collaboration_20261105.sql b/sql/mysql/after_sale_collaboration_20261105.sql
new file mode 100644
index 0000000..25fe396
--- /dev/null
+++ b/sql/mysql/after_sale_collaboration_20261105.sql
@@ -0,0 +1,19 @@
+-- 鍞悗璺ㄩ儴闂ㄥ崗鍚屼换鍔★紱涓嶇洿鎺ュ垱寤鸿储鍔″嚟璇佹垨渚涘簲鍟嗙储璧斿崟銆�
+CREATE TABLE IF NOT EXISTS after_sale_collaboration (
+ id BIGINT NOT NULL AUTO_INCREMENT,
+ ticket_id BIGINT NOT NULL COMMENT '鍞悗宸ュ崟缂栧彿',
+ category VARCHAR(32) NOT NULL COMMENT 'QUALITY銆丗INANCE銆丼UPPLIER銆乄ARRANTY銆丷ESEARCH銆丳ROCESS',
+ title VARCHAR(200) NOT NULL COMMENT '鍗忓悓浜嬮」',
+ content VARCHAR(2000) NOT NULL COMMENT '寰呭鐞嗗唴瀹�',
+ assignee_user_id BIGINT NOT NULL COMMENT '鎺ユ敹浜�',
+ requested_by BIGINT NOT NULL COMMENT '鍙戣捣浜�',
+ status TINYINT NOT NULL DEFAULT 0 COMMENT '0 寰呭鐞嗭紝1 宸插畬鎴愶紝2 宸插彇娑�',
+ result VARCHAR(2000) DEFAULT NULL COMMENT '澶勭悊缁撴灉',
+ completed_time DATETIME DEFAULT NULL,
+ creator VARCHAR(64) DEFAULT '', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ updater VARCHAR(64) DEFAULT '', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ deleted BIT(1) NOT NULL DEFAULT b'0',
+ PRIMARY KEY (id), KEY idx_collaboration_ticket (ticket_id, deleted),
+ KEY idx_collaboration_assignee (assignee_user_id, status, deleted),
+ KEY idx_collaboration_requester (requested_by, deleted)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鍞悗鍗忓悓浠诲姟';
diff --git a/sql/mysql/after_sale_collaboration_menu_20261105.sql b/sql/mysql/after_sale_collaboration_menu_20261105.sql
new file mode 100644
index 0000000..c86623b
--- /dev/null
+++ b/sql/mysql/after_sale_collaboration_menu_20261105.sql
@@ -0,0 +1,14 @@
+-- 渚濊禆鏃㈡湁鍞悗绠$悊鐩綍锛屾墍鏈� ID 鐢辩洰鏍囧簱鐢熸垚锛涜鑹叉潈闄愰渶鍦ㄧ洰鏍囩郴缁熸樉寮忓垎閰嶃��
+SET @after_sale_parent := (SELECT id FROM system_menu WHERE path = '/aftersales' AND parent_id = 0 AND deleted = b'0' LIMIT 1);
+INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, updater)
+SELECT '鍞悗鍗忓悓', '', 2, 20, @after_sale_parent, 'collaboration', 'lucide:users', 'aftersales/collaboration/index', 'AftersalesCollaboration', 0, b'1', b'1', b'1', '1', '1'
+WHERE @after_sale_parent IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component = 'aftersales/collaboration/index' AND deleted = b'0');
+SET @collaboration_page := (SELECT id FROM system_menu WHERE component = 'aftersales/collaboration/index' AND deleted = b'0' LIMIT 1);
+INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, updater)
+SELECT p.name, p.permission, 3, p.sort_no, @collaboration_page, '', '', 0, b'1', b'1', b'1', '1', '1'
+FROM (SELECT '鍗忓悓鏌ヨ' name, 'aftersales:collaboration:query' permission, 1 sort_no UNION ALL
+ SELECT '鍗忓悓鍙戣捣', 'aftersales:collaboration:create', 2 UNION ALL
+ SELECT '鍗忓悓澶勭悊', 'aftersales:collaboration:update', 3 UNION ALL
+ SELECT '涓氬姟瀹℃牳', 'aftersales:collaboration:approve', 4) p
+WHERE @collaboration_page IS NOT NULL AND NOT EXISTS
+ (SELECT 1 FROM system_menu m WHERE m.permission = p.permission AND m.deleted = b'0');
diff --git a/sql/mysql/after_sale_finance_draft_20261105.sql b/sql/mysql/after_sale_finance_draft_20261105.sql
new file mode 100644
index 0000000..0bb0427
--- /dev/null
+++ b/sql/mysql/after_sale_finance_draft_20261105.sql
@@ -0,0 +1,63 @@
+-- 鍦� after_sale_collaboration_20261105.sql 鍚庢墽琛屻�備粎淇濆瓨璐㈠姟寰呭鏍歌崏绋匡紝涓嶄骇鐢熶粯娆炬垨鍑瘉銆�
+SET @sql_amount := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='amount')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN amount DECIMAL(18,2) NULL COMMENT ''閲戦锛堝厓锛�''', 'SELECT 1');
+PREPARE stmt_amount FROM @sql_amount; EXECUTE stmt_amount; DEALLOCATE PREPARE stmt_amount;
+SET @sql_direction := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='direction')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN direction VARCHAR(16) NULL COMMENT ''RECEIVABLE銆丳AYABLE銆両NTERNAL''', 'SELECT 1');
+PREPARE stmt_direction FROM @sql_direction; EXECUTE stmt_direction; DEALLOCATE PREPARE stmt_direction;
+SET @sql_party := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='party_name')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN party_name VARCHAR(200) NULL COMMENT ''寰�鏉ユ柟鍚嶇О''', 'SELECT 1');
+PREPARE stmt_party FROM @sql_party; EXECUTE stmt_party; DEALLOCATE PREPARE stmt_party;
+SET @sql_finance_id := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='finance_draft_id')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN finance_draft_id BIGINT NULL COMMENT ''璐㈠姟鑽夌缂栧彿''', 'SELECT 1');
+PREPARE stmt_finance_id FROM @sql_finance_id; EXECUTE stmt_finance_id; DEALLOCATE PREPARE stmt_finance_id;
+SET @sql_business_actor := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='business_approver_id')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN business_approver_id BIGINT NULL COMMENT ''涓氬姟瀹℃牳浜�''', 'SELECT 1');
+PREPARE stmt_business_actor FROM @sql_business_actor; EXECUTE stmt_business_actor; DEALLOCATE PREPARE stmt_business_actor;
+SET @sql_business_time := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='business_approval_time')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN business_approval_time DATETIME NULL COMMENT ''涓氬姟瀹℃牳鏃堕棿''', 'SELECT 1');
+PREPARE stmt_business_time FROM @sql_business_time; EXECUTE stmt_business_time; DEALLOCATE PREPARE stmt_business_time;
+SET @sql_business_remark := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='business_remark')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN business_remark VARCHAR(1000) NULL COMMENT ''涓氬姟瀹℃牳鎰忚''', 'SELECT 1');
+PREPARE stmt_business_remark FROM @sql_business_remark; EXECUTE stmt_business_remark; DEALLOCATE PREPARE stmt_business_remark;
+SET @sql_previous := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='previous_id')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN previous_id BIGINT NULL COMMENT ''涓婁竴娆¢��鍥炵殑鍗忓悓浜嬮」''', 'SELECT 1');
+PREPARE stmt_previous FROM @sql_previous; EXECUTE stmt_previous; DEALLOCATE PREPARE stmt_previous;
+SET @sql_previous_index := IF((SELECT COUNT(*) FROM information_schema.statistics WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND index_name='uq_collaboration_previous')=0,
+ 'ALTER TABLE after_sale_collaboration ADD UNIQUE KEY uq_collaboration_previous (previous_id)', 'SELECT 1');
+PREPARE stmt_previous_index FROM @sql_previous_index; EXECUTE stmt_previous_index; DEALLOCATE PREPARE stmt_previous_index;
+
+CREATE TABLE IF NOT EXISTS erp_after_sale_finance_draft (
+ id BIGINT NOT NULL AUTO_INCREMENT,
+ collaboration_id BIGINT NOT NULL COMMENT '鍞悗鍗忓悓浜嬮」',
+ ticket_id BIGINT NOT NULL COMMENT '鍞悗宸ュ崟',
+ category VARCHAR(32) NOT NULL COMMENT '鍗忓悓绫诲瀷',
+ direction VARCHAR(16) NOT NULL COMMENT 'RECEIVABLE銆丳AYABLE銆両NTERNAL',
+ amount DECIMAL(18,2) NOT NULL COMMENT '閲戦锛堝厓锛�',
+ party_name VARCHAR(200) DEFAULT NULL COMMENT '寰�鏉ユ柟鍚嶇О',
+ description VARCHAR(2000) NOT NULL COMMENT '涓氬姟璇存槑',
+ business_approver_id BIGINT NOT NULL COMMENT '涓氬姟纭浜�',
+ status TINYINT NOT NULL DEFAULT 0 COMMENT '0 寰呰储鍔″鏍革紝1 瀹℃牳閫氳繃锛�2 閫�鍥�',
+ reviewer_id BIGINT DEFAULT NULL,
+ review_remark VARCHAR(1000) DEFAULT NULL,
+ review_time DATETIME DEFAULT NULL,
+ creator VARCHAR(64) DEFAULT '', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ updater VARCHAR(64) DEFAULT '', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ deleted BIT(1) NOT NULL DEFAULT b'0',
+ PRIMARY KEY (id), UNIQUE KEY uq_as_finance_collaboration (collaboration_id),
+ KEY idx_as_finance_status (status, deleted), KEY idx_as_finance_ticket (ticket_id, deleted)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鍞悗璐㈠姟瀹℃牳鑽夌';
+
+-- 鍏宠仈涓绘暟鎹紝鍚屾椂淇濈暀鍚嶇О蹇収锛涘巻鍙茶褰曞厑璁镐负绌恒��
+SET @sql_party_type := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='party_type')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN party_type VARCHAR(16) NULL', 'SELECT 1');
+PREPARE stmt_party_type FROM @sql_party_type; EXECUTE stmt_party_type; DEALLOCATE PREPARE stmt_party_type;
+SET @sql_party_id := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='after_sale_collaboration' AND column_name='party_id')=0,
+ 'ALTER TABLE after_sale_collaboration ADD COLUMN party_id BIGINT NULL', 'SELECT 1');
+PREPARE stmt_party_id FROM @sql_party_id; EXECUTE stmt_party_id; DEALLOCATE PREPARE stmt_party_id;
+SET @sql_draft_party_type := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='erp_after_sale_finance_draft' AND column_name='party_type')=0,
+ 'ALTER TABLE erp_after_sale_finance_draft ADD COLUMN party_type VARCHAR(16) NULL', 'SELECT 1');
+PREPARE stmt_draft_party_type FROM @sql_draft_party_type; EXECUTE stmt_draft_party_type; DEALLOCATE PREPARE stmt_draft_party_type;
+SET @sql_draft_party_id := IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='erp_after_sale_finance_draft' AND column_name='party_id')=0,
+ 'ALTER TABLE erp_after_sale_finance_draft ADD COLUMN party_id BIGINT NULL', 'SELECT 1');
+PREPARE stmt_draft_party_id FROM @sql_draft_party_id; EXECUTE stmt_draft_party_id; DEALLOCATE PREPARE stmt_draft_party_id;
diff --git a/sql/mysql/after_sale_finance_draft_menu_20261105.sql b/sql/mysql/after_sale_finance_draft_menu_20261105.sql
new file mode 100644
index 0000000..7aaa361
--- /dev/null
+++ b/sql/mysql/after_sale_finance_draft_menu_20261105.sql
@@ -0,0 +1,10 @@
+-- 鍦ㄨ储鍔$鐞嗕笅澧炲姞鐙珛瀹℃牳鑽夌鍏ュ彛锛涜鑹叉潈闄愬湪鐩爣绯荤粺涓樉寮忓垎閰嶃��
+SET @finance_parent := (SELECT id FROM system_menu WHERE path='finance' AND type=1 AND deleted=b'0' AND name='璐㈠姟绠$悊' LIMIT 1);
+INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,creator,updater)
+SELECT '鍞悗璐㈠姟鑽夌','',2,30,@finance_parent,'after-sale-draft','lucide:file-check','erp/finance/after-sale-draft/index','ErpAfterSaleFinanceDraft',0,b'1',b'1',b'1','1','1'
+WHERE @finance_parent IS NOT NULL AND NOT EXISTS(SELECT 1 FROM system_menu WHERE component='erp/finance/after-sale-draft/index' AND deleted=b'0');
+SET @finance_page := (SELECT id FROM system_menu WHERE component='erp/finance/after-sale-draft/index' AND deleted=b'0' LIMIT 1);
+INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,status,visible,keep_alive,always_show,creator,updater)
+SELECT p.name,p.permission,3,p.sort_no,@finance_page,'','',0,b'1',b'1',b'1','1','1'
+FROM (SELECT '鑽夌鏌ヨ' name,'erp:after-sale-finance:query' permission,1 sort_no UNION ALL SELECT '鑽夌瀹℃牳','erp:after-sale-finance:review',2) p
+WHERE @finance_page IS NOT NULL AND NOT EXISTS(SELECT 1 FROM system_menu m WHERE m.permission=p.permission AND m.deleted=b'0');
diff --git a/sql/mysql/process_knowledge_entry_20261105.sql b/sql/mysql/process_knowledge_entry_20261105.sql
new file mode 100644
index 0000000..9d1487f
--- /dev/null
+++ b/sql/mysql/process_knowledge_entry_20261105.sql
@@ -0,0 +1,18 @@
+-- 渚濊禆 process_knowledge_menu_20261105.sql锛涜彍鍗� ID 鐢辨暟鎹簱鐢熸垚銆�
+SET @process_parent := (SELECT id FROM system_menu WHERE path = '/process-design' AND parent_id = 0 AND deleted = b'0' LIMIT 1);
+SET @knowledge_menu := (SELECT id FROM system_menu WHERE parent_id = @process_parent AND path = 'knowledge' AND type = 1 AND deleted = b'0' LIMIT 1);
+INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, updater)
+SELECT '鐭ヨ瘑缁存姢', '', 2, 0, @knowledge_menu, 'catalog', 'lucide:book-open', 'mes/process-design/knowledge/index', 'MesPdKnowledge', 0, b'1', b'1', b'1', '1', '1'
+WHERE @knowledge_menu IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component = 'mes/process-design/knowledge/index' AND deleted = b'0');
+SET @knowledge_page := (SELECT id FROM system_menu WHERE component = 'mes/process-design/knowledge/index' AND deleted = b'0' LIMIT 1);
+INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, updater)
+SELECT p.name, p.permission, 3, p.sort_no, @knowledge_page, '', '', 0, b'1', b'1', b'1', '1', '1'
+FROM (SELECT '鐭ヨ瘑鏌ヨ' name, 'mes:pd-knowledge:query' permission, 1 sort_no UNION ALL
+ SELECT '鐭ヨ瘑鍒涘缓', 'mes:pd-knowledge:create', 2 UNION ALL
+ SELECT '鐭ヨ瘑淇敼', 'mes:pd-knowledge:update', 3 UNION ALL
+ SELECT '鐭ヨ瘑鍙戝竷', 'mes:pd-knowledge:publish', 4 UNION ALL
+ SELECT '鐭ヨ瘑鍙傝��', 'mes:pd-knowledge:reference', 5) p
+WHERE @knowledge_page IS NOT NULL AND NOT EXISTS
+ (SELECT 1 FROM system_menu m WHERE m.permission = p.permission AND m.deleted = b'0');
+
+-- 椤甸潰涓庢搷浣滄潈闄愰�氳繃绯荤粺瑙掕壊绠$悊鏄惧紡鍒嗛厤锛涗笉鑷姩鎵╁ぇ宸叉湁瑙掕壊鏉冮檺銆�
diff --git a/sql/mysql/process_knowledge_menu_20261105.sql b/sql/mysql/process_knowledge_menu_20261105.sql
new file mode 100644
index 0000000..d0777c5
--- /dev/null
+++ b/sql/mysql/process_knowledge_menu_20261105.sql
@@ -0,0 +1,23 @@
+-- 宸ヨ壓鐭ヨ瘑搴撹彍鍗曟暣鐞嗭細淇濈暀鍘熼〉闈€�佹潈闄愬強鎸夐挳锛屼粎鏂板鐩綍骞惰皟鏁寸埗绾с��
+-- 鍦ㄧ洰鏍囧簱鎵ц鍓嶈鍏堝浠� system_menu 鍜� system_role_menu銆�
+-- 閫氳繃缁勪欢璺緞瀹氫綅宸叉湁鑿滃崟锛屼笉渚濊禆璺ㄩ」鐩殑鍥哄畾鑿滃崟 ID銆�
+SET @process_parent := (SELECT id FROM system_menu WHERE path = '/process-design' AND parent_id = 0 AND deleted = b'0' LIMIT 1);
+
+INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, updater)
+SELECT '宸ヨ壓鐭ヨ瘑搴�', '', 1, 1, @process_parent, 'knowledge', 'lucide:library-big', 0, b'1', b'1', b'1', '1', '1'
+WHERE @process_parent IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE parent_id = @process_parent AND path = 'knowledge' AND deleted = b'0');
+
+SET @knowledge_menu := (SELECT id FROM system_menu WHERE parent_id = @process_parent AND path = 'knowledge' AND type = 1 AND deleted = b'0' LIMIT 1);
+
+-- 鍙悜宸叉湁鐩稿叧椤甸潰鏉冮檺鐨勮鑹插紑鏀剧洰褰曪紝涓嶆墿澶т笟鍔¢〉闈㈡潈闄愩��
+INSERT INTO system_role_menu (role_id, menu_id, creator, updater, tenant_id)
+SELECT DISTINCT rm.role_id, @knowledge_menu, '1', '1', rm.tenant_id
+FROM system_role_menu rm JOIN system_menu m ON m.id = rm.menu_id
+WHERE @knowledge_menu IS NOT NULL AND rm.deleted = b'0' AND m.deleted = b'0'
+ AND m.component IN ('mes/process-design/parameter/index', 'mes/process-design/template/index', 'mes/process-design/process/index')
+ AND NOT EXISTS (SELECT 1 FROM system_role_menu existing WHERE existing.role_id = rm.role_id AND existing.tenant_id = rm.tenant_id AND existing.menu_id = @knowledge_menu AND existing.deleted = b'0');
+
+UPDATE system_menu SET parent_id = @knowledge_menu, updater = '1', update_time = NOW()
+WHERE @knowledge_menu IS NOT NULL AND parent_id = @process_parent AND deleted = b'0'
+ AND component IN ('mes/process-design/parameter/index', 'mes/process-design/template/index', 'mes/process-design/process/index');
diff --git a/sql/mysql/process_knowledge_schema_20261105.sql b/sql/mysql/process_knowledge_schema_20261105.sql
new file mode 100644
index 0000000..595c12e
--- /dev/null
+++ b/sql/mysql/process_knowledge_schema_20261105.sql
@@ -0,0 +1,83 @@
+-- 宸ヨ壓鐭ヨ瘑搴撶嫭绔嬫暟鎹粨鏋勶紱涓嶄慨鏀规棦鏈夎矾绾裤�佸弬鏁板拰宸ュ簭鏁版嵁銆�
+-- 浣跨敤涓氬姟 ID 鍏宠仈鐜版湁涓绘暟鎹紝涓嶈法妯″潡璁剧疆鐗╃悊澶栭敭锛屼究浜庨」鐩棿杩佺Щ銆�
+CREATE TABLE IF NOT EXISTS mes_pd_knowledge (
+ id BIGINT NOT NULL AUTO_INCREMENT,
+ code VARCHAR(64) NOT NULL COMMENT '鐭ヨ瘑缂栫爜',
+ name VARCHAR(200) NOT NULL COMMENT '鐭ヨ瘑鍚嶇О',
+ version INT NOT NULL DEFAULT 1 COMMENT '鐭ヨ瘑鐗堟湰',
+ product_item_id BIGINT DEFAULT NULL COMMENT '閫傜敤鎴愬搧鐗╂枡',
+ bom_id BIGINT DEFAULT NULL COMMENT '閫傜敤 BOM 瀛愮墿鏂欑紪鍙�',
+ voltage_min DECIMAL(16,4) DEFAULT NULL COMMENT '鏈�浣庣數鍘嬶紝鍗曚綅 kV',
+ voltage_max DECIMAL(16,4) DEFAULT NULL COMMENT '鏈�楂樼數鍘嬶紝鍗曚綅 kV',
+ market VARCHAR(16) NOT NULL DEFAULT 'ALL' COMMENT 'ALL銆丏OMESTIC 鎴� EXPORT',
+ route_id BIGINT DEFAULT NULL COMMENT '鍙傝�冨伐鑹鸿矾绾�',
+ template_id BIGINT DEFAULT NULL COMMENT '鍙傝�冨弬鏁版ā鏉�',
+ description TEXT COMMENT '閫傜敤璇存槑',
+ status TINYINT NOT NULL DEFAULT 0 COMMENT '0 鑽夌銆�1 宸插彂甯冦��2 鍋滅敤',
+ creator VARCHAR(64) DEFAULT '',
+ create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ updater VARCHAR(64) DEFAULT '',
+ update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ deleted BIT(1) NOT NULL DEFAULT b'0',
+ PRIMARY KEY (id),
+ UNIQUE KEY uq_knowledge_code_version (code, version),
+ KEY idx_knowledge_match (status, market, product_item_id, deleted)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='宸ヨ壓鐭ヨ瘑鐗堟湰';
+
+-- 鍚屾涓哄厛鍓嶅凡鍒涘缓鐨勮〃琛ュ缓鍞竴绱㈠紩锛涘宸叉湁閲嶅鏁版嵁鍒欏簲鍏堜汉宸ュ鐞嗭紝涓嶈兘闈欓粯璺宠繃銆�
+SET @knowledge_unique_sql := IF(
+ (SELECT COUNT(*) FROM information_schema.statistics WHERE table_schema = DATABASE()
+ AND table_name = 'mes_pd_knowledge' AND index_name = 'uq_knowledge_code_version') = 0,
+ 'ALTER TABLE mes_pd_knowledge ADD UNIQUE KEY uq_knowledge_code_version (code, version)',
+ 'SELECT 1');
+PREPARE knowledge_unique_stmt FROM @knowledge_unique_sql;
+EXECUTE knowledge_unique_stmt;
+DEALLOCATE PREPARE knowledge_unique_stmt;
+
+CREATE TABLE IF NOT EXISTS mes_pd_knowledge_standard (
+ id BIGINT NOT NULL AUTO_INCREMENT,
+ knowledge_id BIGINT NOT NULL,
+ standard_code VARCHAR(128) NOT NULL COMMENT '閫傜敤鏍囧噯缂栫爜',
+ standard_name VARCHAR(200) DEFAULT NULL COMMENT '閫傜敤鏍囧噯鍚嶇О',
+ creator VARCHAR(64) DEFAULT '', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ updater VARCHAR(64) DEFAULT '', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ deleted BIT(1) NOT NULL DEFAULT b'0',
+ PRIMARY KEY (id), KEY idx_knowledge_standard_parent (knowledge_id, deleted),
+ KEY idx_knowledge_standard_code (standard_code, deleted)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='宸ヨ壓鐭ヨ瘑閫傜敤鏍囧噯';
+
+CREATE TABLE IF NOT EXISTS mes_pd_knowledge_resource (
+ id BIGINT NOT NULL AUTO_INCREMENT,
+ knowledge_id BIGINT NOT NULL,
+ process_id BIGINT DEFAULT NULL COMMENT '鐜版湁宸ュ簭',
+ resource_type VARCHAR(32) NOT NULL COMMENT '璧勬簮绫诲瀷',
+ resource_id BIGINT DEFAULT NULL COMMENT '鐜版湁璧勬簮缂栧彿',
+ capability_description VARCHAR(500) DEFAULT NULL COMMENT '鑳藉姏鍙婄害鏉熸弿杩�',
+ creator VARCHAR(64) DEFAULT '', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ updater VARCHAR(64) DEFAULT '', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ deleted BIT(1) NOT NULL DEFAULT b'0',
+ PRIMARY KEY (id), KEY idx_knowledge_resource_parent (knowledge_id, deleted)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='宸ヨ壓鐭ヨ瘑璧勬簮鑳藉姏';
+
+CREATE TABLE IF NOT EXISTS mes_pd_knowledge_reference (
+ id BIGINT NOT NULL AUTO_INCREMENT,
+ knowledge_id BIGINT NOT NULL,
+ knowledge_version INT NOT NULL COMMENT '寮曠敤鏃剁増鏈�',
+ target_type VARCHAR(32) NOT NULL COMMENT '寮曠敤鐩爣绫诲瀷',
+ target_id BIGINT NOT NULL COMMENT '寮曠敤鐩爣缂栧彿',
+ creator VARCHAR(64) DEFAULT '', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ updater VARCHAR(64) DEFAULT '', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ deleted BIT(1) NOT NULL DEFAULT b'0',
+ PRIMARY KEY (id), UNIQUE KEY uq_knowledge_reference (knowledge_id, target_type, target_id),
+ KEY idx_knowledge_reference_source (knowledge_id, knowledge_version, deleted),
+ KEY idx_knowledge_reference_target (target_type, target_id, deleted)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='宸ヨ壓鐭ヨ瘑寮曠敤璁板綍';
+
+SET @knowledge_reference_sql := IF(
+ (SELECT COUNT(*) FROM information_schema.statistics WHERE table_schema = DATABASE()
+ AND table_name = 'mes_pd_knowledge_reference' AND index_name = 'uq_knowledge_reference') = 0,
+ 'ALTER TABLE mes_pd_knowledge_reference ADD UNIQUE KEY uq_knowledge_reference (knowledge_id, target_type, target_id)',
+ 'SELECT 1');
+PREPARE knowledge_reference_stmt FROM @knowledge_reference_sql;
+EXECUTE knowledge_reference_stmt;
+DEALLOCATE PREPARE knowledge_reference_stmt;
diff --git a/yudao-module-aftersales/pom.xml b/yudao-module-aftersales/pom.xml
index ab92efd..0440c29 100644
--- a/yudao-module-aftersales/pom.xml
+++ b/yudao-module-aftersales/pom.xml
@@ -18,6 +18,11 @@
</description>
<dependencies>
+ <dependency>
+ <groupId>cn.iocoder.boot</groupId>
+ <artifactId>yudao-module-srm-api</artifactId>
+ <version>${revision}</version>
+ </dependency>
<!-- 鍞悗 API 妯″潡 -->
<dependency>
<groupId>cn.iocoder.boot</groupId>
diff --git a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/collaboration/AfterSaleCollaborationController.java b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/collaboration/AfterSaleCollaborationController.java
new file mode 100644
index 0000000..99b320d
--- /dev/null
+++ b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/collaboration/AfterSaleCollaborationController.java
@@ -0,0 +1,64 @@
+package cn.iocoder.yudao.module.aftersales.controller.admin.collaboration;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.aftersales.dal.dataobject.collaboration.AfterSaleCollaborationDO;
+import cn.iocoder.yudao.module.aftersales.service.collaboration.AfterSaleCollaborationService;
+import jakarta.annotation.Resource;
+import jakarta.validation.Valid;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.web.bind.annotation.*;
+import java.util.List;
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.invalidParamException;
+import static cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils.getLoginUserId;
+
+@RestController
+@RequestMapping("/aftersales/collaboration")
+public class AfterSaleCollaborationController {
+ @Resource private AfterSaleCollaborationService service;
+
+ @PostMapping("/create")
+ @PreAuthorize("@ss.hasPermission('aftersales:collaboration:create')")
+ public CommonResult<Long> create(@RequestBody AfterSaleCollaborationService.CreateRequest input) {
+ return success(service.create(input, getLoginUserId()));
+ }
+
+ @GetMapping("/my-page")
+ @PreAuthorize("@ss.hasPermission('aftersales:collaboration:query')")
+ public CommonResult<PageResult<AfterSaleCollaborationDO>> myPage(@Valid PageParam page) {
+ return success(service.myTasks(page, getLoginUserId()));
+ }
+
+ @GetMapping("/ticket-list")
+ @PreAuthorize("@ss.hasPermission('aftersales:collaboration:query')")
+ public CommonResult<List<AfterSaleCollaborationDO>> ticketList(@RequestParam("ticketId") Long ticketId) {
+ return success(service.ticketTasks(ticketId, getLoginUserId()));
+ }
+
+ @PutMapping("/complete")
+ @PreAuthorize("@ss.hasPermission('aftersales:collaboration:update')")
+ public CommonResult<Boolean> complete(@RequestParam("id") Long id, @RequestBody CompleteRequest input) {
+ service.complete(id, getLoginUserId(), input == null ? null : input.result());
+ return success(true);
+ }
+
+ @PutMapping("/cancel")
+ @PreAuthorize("@ss.hasPermission('aftersales:collaboration:update')")
+ public CommonResult<Boolean> cancel(@RequestParam("id") Long id) {
+ service.cancel(id, getLoginUserId());
+ return success(true);
+ }
+
+ @PutMapping("/review-financial")
+ @PreAuthorize("@ss.hasPermission('aftersales:collaboration:approve')")
+ public CommonResult<Boolean> reviewFinancial(@RequestParam("id") Long id, @RequestBody ReviewRequest input) {
+ if (input == null || input.approved() == null) throw invalidParamException("璇烽�夋嫨瀹℃牳缁撴灉");
+ service.reviewFinancial(id, getLoginUserId(), input.approved(), input.remark());
+ return success(true);
+ }
+
+ public record CompleteRequest(String result) {}
+ public record ReviewRequest(Boolean approved, String remark) {}
+}
diff --git a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/ticket/AfterSaleTicketController.java b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/ticket/AfterSaleTicketController.java
index 4f6cddd..aa8a552 100644
--- a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/ticket/AfterSaleTicketController.java
+++ b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/controller/admin/ticket/AfterSaleTicketController.java
@@ -11,6 +11,7 @@
import cn.iocoder.yudao.module.aftersales.dal.dataobject.ticket.AfterSaleTicketDO;
import cn.iocoder.yudao.module.aftersales.dal.dataobject.ticket.AfterSaleTicketItemDO;
import cn.iocoder.yudao.module.aftersales.service.ticket.AfterSaleTicketService;
+import cn.iocoder.yudao.module.aftersales.service.ticket.AfterSaleLedgerService;
import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi;
import cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO;
import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
@@ -38,6 +39,8 @@
@Resource
private AfterSaleTicketService ticketService;
+ @Resource
+ private AfterSaleLedgerService ledgerService;
@Resource
private CrmCustomerApi customerApi;
@@ -94,6 +97,16 @@
return success(new PageResult<>(list, pageResult.getTotal()));
}
+ @GetMapping("/overview")
+ @Operation(summary = "缁熻褰撳墠鐢ㄦ埛鍙鐨勫敭鍚庡伐鍗曠姸鎬�")
+ @PreAuthorize("@ss.hasPermission('aftersales:ticket:query')")
+ public CommonResult<Map<Integer, Long>> getOverview(@RequestParam("sceneType") Integer sceneType) {
+ if (sceneType == null || sceneType < 1 || sceneType > 4) {
+ throw cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.invalidParamException("宸ュ崟鍦烘櫙涓嶆纭�");
+ }
+ return success(ledgerService.overview(getLoginUserId(), sceneType));
+ }
+
@PostMapping("/assign")
@Operation(summary = "鍒嗛厤澶勭悊浜�")
@PreAuthorize("@ss.hasPermission('aftersales:ticket:update')")
diff --git a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/dataobject/collaboration/AfterSaleCollaborationDO.java b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/dataobject/collaboration/AfterSaleCollaborationDO.java
new file mode 100644
index 0000000..189b3fb
--- /dev/null
+++ b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/dataobject/collaboration/AfterSaleCollaborationDO.java
@@ -0,0 +1,42 @@
+package cn.iocoder.yudao.module.aftersales.dal.dataobject.collaboration;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.annotation.TableField;
+import cn.iocoder.yudao.module.erp.api.finance.dto.AfterSaleFinanceReviewDTO;
+import tools.jackson.databind.annotation.JsonSerialize;
+import tools.jackson.databind.ser.std.ToStringSerializer;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import java.time.LocalDateTime;
+import java.math.BigDecimal;
+
+@TableName("after_sale_collaboration")
+@Data
+@EqualsAndHashCode(callSuper = true)
+public class AfterSaleCollaborationDO extends BaseDO {
+ @TableId private Long id;
+ private Long ticketId;
+ private String category;
+ private String title;
+ private String content;
+ private Long assigneeUserId;
+ private Long requestedBy;
+ private Integer status;
+ private String result;
+ private LocalDateTime completedTime;
+ @JsonSerialize(using = ToStringSerializer.class)
+ private BigDecimal amount;
+ private String direction;
+ private String partyName;
+ private String partyType;
+ private Long partyId;
+ private Long financeDraftId;
+ private Long previousId;
+ private Long businessApproverId;
+ private LocalDateTime businessApprovalTime;
+ private String businessRemark;
+ @TableField(exist = false)
+ private AfterSaleFinanceReviewDTO financeReview;
+}
diff --git a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/collaboration/AfterSaleCollaborationMapper.java b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/collaboration/AfterSaleCollaborationMapper.java
new file mode 100644
index 0000000..e98fa80
--- /dev/null
+++ b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/dal/mysql/collaboration/AfterSaleCollaborationMapper.java
@@ -0,0 +1,8 @@
+package cn.iocoder.yudao.module.aftersales.dal.mysql.collaboration;
+
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.aftersales.dal.dataobject.collaboration.AfterSaleCollaborationDO;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface AfterSaleCollaborationMapper extends BaseMapperX<AfterSaleCollaborationDO> {}
diff --git a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/service/collaboration/AfterSaleCollaborationService.java b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/service/collaboration/AfterSaleCollaborationService.java
new file mode 100644
index 0000000..d31d3fa
--- /dev/null
+++ b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/service/collaboration/AfterSaleCollaborationService.java
@@ -0,0 +1,231 @@
+package cn.iocoder.yudao.module.aftersales.service.collaboration;
+
+import cn.iocoder.yudao.framework.common.biz.system.permission.PermissionCommonApi;
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.aftersales.dal.dataobject.collaboration.AfterSaleCollaborationDO;
+import cn.iocoder.yudao.module.aftersales.dal.dataobject.ticket.AfterSaleTicketDO;
+import cn.iocoder.yudao.module.aftersales.dal.mysql.collaboration.AfterSaleCollaborationMapper;
+import cn.iocoder.yudao.module.aftersales.enums.AfterSaleBizTypeEnum;
+import cn.iocoder.yudao.module.aftersales.enums.permission.AfterSalePermissionLevelEnum;
+import cn.iocoder.yudao.module.aftersales.service.permission.AfterSalePermissionService;
+import cn.iocoder.yudao.module.aftersales.service.ticket.AfterSaleTicketService;
+import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
+import cn.iocoder.yudao.module.srm.api.supplier.SrmSupplierApi;
+import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi;
+import cn.iocoder.yudao.module.erp.api.finance.AfterSaleFinanceDraftApi;
+import cn.iocoder.yudao.module.erp.api.finance.dto.AfterSaleFinanceDraftCreateDTO;
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
+import jakarta.annotation.Resource;
+import lombok.Data;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.dao.DuplicateKeyException;
+import java.time.LocalDateTime;
+import java.math.BigDecimal;
+import java.util.List;
+import java.util.Objects;
+import java.util.Set;
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.invalidParamException;
+
+@Service
+public class AfterSaleCollaborationService {
+ @Resource private AfterSaleCollaborationMapper mapper;
+ @Resource private AfterSaleTicketService ticketService;
+ @Resource private AfterSalePermissionService permissionService;
+ @Resource private PermissionCommonApi permissionApi;
+ @Resource private AdminUserApi userApi;
+ @Resource private AfterSaleFinanceDraftApi financeDraftApi;
+ @Resource private SrmSupplierApi supplierApi;
+ @Resource private CrmCustomerApi customerApi;
+
+ @Data
+ public static class CreateRequest {
+ private Long ticketId;
+ private String category;
+ private String title;
+ private String content;
+ private Long assigneeUserId;
+ private BigDecimal amount;
+ private String direction;
+ private String partyName;
+ private Long partyId;
+ private Long previousId;
+ }
+
+ @Transactional(rollbackFor = Exception.class)
+ public Long create(CreateRequest input, Long userId) {
+ if (userId == null || input == null || input.getTicketId() == null || input.getAssigneeUserId() == null
+ || input.getCategory() == null || !Set.of("QUALITY", "FINANCE", "SUPPLIER", "WARRANTY", "RESEARCH", "PROCESS").contains(input.getCategory())
+ || input.getTitle() == null || input.getTitle().isBlank() || input.getTitle().length() > 200
+ || input.getContent() == null || input.getContent().isBlank() || input.getContent().length() > 2000)
+ throw invalidParamException("璇峰畬鏁村~鍐欏崗鍚屼簨椤瑰強鎺ユ敹浜�");
+ boolean financialCategory = Set.of("FINANCE", "SUPPLIER", "WARRANTY").contains(input.getCategory());
+ if (financialCategory && input.getAmount() == null) throw invalidParamException("璇ュ崗鍚岀被鍨嬪繀椤诲~鍐欓噾棰�");
+ if (input.getAmount() != null) {
+ if (!Set.of("QUALITY", "FINANCE", "SUPPLIER", "WARRANTY").contains(input.getCategory())
+ || input.getAmount().signum() <= 0 || input.getAmount().stripTrailingZeros().scale() > 2
+ || input.getAmount().compareTo(new BigDecimal("9999999999999999.99")) > 0
+ || input.getDirection() == null || !Set.of("RECEIVABLE", "PAYABLE", "INTERNAL").contains(input.getDirection())
+ || (input.getPartyName() != null && input.getPartyName().length() > 200)
+ || (!Set.of("SUPPLIER", "WARRANTY").contains(input.getCategory()) && !"INTERNAL".equals(input.getDirection()) && (input.getPartyName() == null || input.getPartyName().isBlank())))
+ throw invalidParamException("閲戦銆佽祫閲戞柟鍚戞垨寰�鏉ユ柟涓嶆纭�");
+ } else if (input.getDirection() != null || input.getPartyId() != null || (input.getPartyName() != null && !input.getPartyName().isBlank())) {
+ throw invalidParamException("濉啓璧勯噾鏂瑰悜鎴栧線鏉ユ柟鏃跺繀椤诲~鍐欓噾棰�");
+ }
+ AfterSaleTicketDO ticket = ticketService.getTicket(input.getTicketId());
+ if (ticket == null) throw invalidParamException("鍞悗宸ュ崟涓嶅瓨鍦�");
+ if (Objects.equals(ticket.getStatus(), 60) || Objects.equals(ticket.getStatus(), 99))
+ throw invalidParamException("宸插叧闂垨鍙栨秷鐨勫伐鍗曚笉鑳藉彂璧峰崗鍚�");
+ if (!canWrite(ticket, userId)) throw invalidParamException("鏃犳潈鍙戣捣璇ュ伐鍗曠殑鍗忓悓浜嬮」");
+ String partyType = null, partyName = null;
+ Long partyId = null;
+ if (input.getAmount() != null) {
+ if ("SUPPLIER".equals(input.getCategory())) {
+ if (input.getPartyId() == null) throw invalidParamException("璇烽�夋嫨渚涘簲鍟�");
+ var supplier = supplierApi.getSupplier(input.getPartyId()).getCheckedData();
+ if (supplier == null || !Objects.equals(supplier.getStatus(), 0) || supplier.getName() == null || supplier.getName().isBlank())
+ throw invalidParamException("渚涘簲鍟嗕笉瀛樺湪鎴栧凡鍋滅敤");
+ partyType = "SUPPLIER"; partyId = supplier.getId(); partyName = supplier.getName();
+ } else if ("WARRANTY".equals(input.getCategory())) {
+ if (ticket.getCustomerId() == null) throw invalidParamException("宸ュ崟鏈叧鑱斿鎴凤紝璇峰厛瀹屽杽宸ュ崟");
+ var customer = customerApi.getCustomer(ticket.getCustomerId());
+ if (customer == null || customer.getName() == null || customer.getName().isBlank())
+ throw invalidParamException("宸ュ崟鍏宠仈鐨勫鎴蜂笉瀛樺湪");
+ partyType = "CUSTOMER"; partyId = customer.getId(); partyName = customer.getName();
+ } else if ("INTERNAL".equals(input.getDirection())) {
+ partyType = "INTERNAL";
+ } else {
+ partyType = "OTHER"; partyName = input.getPartyName().trim();
+ }
+ }
+ userApi.validateUser(input.getAssigneeUserId());
+ if (input.getPreviousId() != null) {
+ AfterSaleCollaborationDO previous = mapper.selectById(input.getPreviousId());
+ if (previous == null || !Objects.equals(previous.getRequestedBy(), userId)
+ || !Objects.equals(previous.getTicketId(), input.getTicketId()) || !Objects.equals(previous.getCategory(), input.getCategory()))
+ throw invalidParamException("鍘熷崗鍚屼簨椤逛笉鍖归厤鎴栨棤鏉冮噸鏂板彂璧�");
+ boolean allowed = Objects.equals(previous.getStatus(), 4)
+ || (Objects.equals(previous.getStatus(), 2) && previous.getPreviousId() != null);
+ if (Objects.equals(previous.getStatus(), 3) && previous.getFinanceDraftId() != null) {
+ var review = financeDraftApi.getReviewResults(List.of(previous.getFinanceDraftId())).get(previous.getFinanceDraftId());
+ allowed = review != null && Objects.equals(review.getStatus(), 2);
+ }
+ if (!allowed) throw invalidParamException("鍙湁涓氬姟閫�鍥炪�佽储鍔¢��鍥炴垨宸插彇娑堢殑閲嶅姙浜嬮」鍙互閲嶆柊鍙戣捣");
+ }
+ var task = new AfterSaleCollaborationDO();
+ task.setTicketId(input.getTicketId()); task.setCategory(input.getCategory()); task.setTitle(input.getTitle().trim());
+ task.setContent(input.getContent().trim()); task.setAssigneeUserId(input.getAssigneeUserId());
+ task.setRequestedBy(userId); task.setStatus(0); task.setAmount(input.getAmount());
+ task.setDirection(input.getDirection()); task.setPartyName(partyName); task.setPartyType(partyType); task.setPartyId(partyId); task.setPreviousId(input.getPreviousId());
+ try { mapper.insert(task); }
+ catch (DuplicateKeyException e) { throw invalidParamException("璇ヤ簨椤瑰凡閲嶆柊鍙戣捣锛岃鍒锋柊鍚庢煡鐪�"); }
+ return task.getId();
+ }
+
+ public PageResult<AfterSaleCollaborationDO> myTasks(PageParam page, Long userId) {
+ if (userId == null) throw invalidParamException("鐢ㄦ埛鏈櫥褰�");
+ boolean canApprove = permissionApi.hasAnyPermissions(userId, "aftersales:collaboration:approve");
+ boolean isAdmin = canApprove && permissionApi.hasAnyRoles(userId, "aftersales_admin");
+ var query = new LambdaQueryWrapperX<AfterSaleCollaborationDO>();
+ query.and(w -> {
+ w.eq(AfterSaleCollaborationDO::getAssigneeUserId, userId).or().eq(AfterSaleCollaborationDO::getRequestedBy, userId)
+ .or().eq(AfterSaleCollaborationDO::getBusinessApproverId, userId);
+ if (canApprove) w.or(approval -> {
+ approval.eq(AfterSaleCollaborationDO::getStatus, 1).isNotNull(AfterSaleCollaborationDO::getAmount);
+ if (!isAdmin) approval.exists("SELECT 1 FROM after_sale_ticket t WHERE t.id = after_sale_collaboration.ticket_id AND t.deleted = 0 "
+ + "AND (t.owner_user_id = {0} OR EXISTS (SELECT 1 FROM after_sale_permission p WHERE p.biz_type = 1 "
+ + "AND p.biz_id = t.id AND p.user_id = {1} AND p.level IN (1, 3) AND p.deleted = 0))", userId, userId);
+ });
+ });
+ PageResult<AfterSaleCollaborationDO> result = mapper.selectPage(page, query.orderByDesc(AfterSaleCollaborationDO::getId));
+ attachFinanceReviews(result.getList());
+ return result;
+ }
+
+ public List<AfterSaleCollaborationDO> ticketTasks(Long ticketId, Long userId) {
+ if (userId == null || ticketId == null) throw invalidParamException("鍙傛暟涓嶆纭�");
+ AfterSaleTicketDO ticket = ticketService.getTicket(ticketId);
+ if (ticket == null) throw invalidParamException("鍞悗宸ュ崟涓嶅瓨鍦�");
+ var query = new LambdaQueryWrapperX<AfterSaleCollaborationDO>().eq(AfterSaleCollaborationDO::getTicketId, ticketId);
+ if (!canRead(ticket, userId)) query.and(w -> w.eq(AfterSaleCollaborationDO::getAssigneeUserId, userId).or().eq(AfterSaleCollaborationDO::getRequestedBy, userId));
+ List<AfterSaleCollaborationDO> result = mapper.selectList(query.orderByDesc(AfterSaleCollaborationDO::getId));
+ attachFinanceReviews(result);
+ return result;
+ }
+
+ private void attachFinanceReviews(List<AfterSaleCollaborationDO> tasks) {
+ List<Long> ids = tasks.stream().map(AfterSaleCollaborationDO::getFinanceDraftId).filter(Objects::nonNull).distinct().toList();
+ if (ids.isEmpty()) return;
+ var reviews = financeDraftApi.getReviewResults(ids);
+ tasks.forEach(task -> task.setFinanceReview(reviews.get(task.getFinanceDraftId())));
+ }
+
+ @Transactional(rollbackFor = Exception.class)
+ public void complete(Long id, Long userId, String result) {
+ if (id == null || userId == null || result == null || result.isBlank() || result.length() > 2000)
+ throw invalidParamException("璇峰~鍐欎笉瓒呰繃 2000 瀛楃殑澶勭悊缁撴灉");
+ AfterSaleCollaborationDO task = mapper.selectById(id);
+ if (task == null || !Objects.equals(task.getAssigneeUserId(), userId) || !Objects.equals(task.getStatus(), 0))
+ throw invalidParamException("鍗忓悓浜嬮」涓嶅瓨鍦ㄣ�佸凡澶勭悊鎴栧綋鍓嶇敤鎴蜂笉鏄帴鏀朵汉");
+ if (mapper.update(null, new LambdaUpdateWrapper<AfterSaleCollaborationDO>()
+ .eq(AfterSaleCollaborationDO::getId, id).eq(AfterSaleCollaborationDO::getStatus, 0)
+ .eq(AfterSaleCollaborationDO::getAssigneeUserId, userId).set(AfterSaleCollaborationDO::getStatus, 1)
+ .set(AfterSaleCollaborationDO::getResult, result.trim()).set(AfterSaleCollaborationDO::getCompletedTime, LocalDateTime.now())) != 1)
+ throw invalidParamException("鍗忓悓浜嬮」鐘舵�佸凡鍙樺寲锛岃鍒锋柊鍚庨噸璇�");
+ }
+
+ @Transactional(rollbackFor = Exception.class)
+ public void cancel(Long id, Long userId) {
+ if (id == null || userId == null) throw invalidParamException("鍙傛暟涓嶆纭�");
+ AfterSaleCollaborationDO task = mapper.selectById(id);
+ if (task == null || !Objects.equals(task.getRequestedBy(), userId) || !Objects.equals(task.getStatus(), 0))
+ throw invalidParamException("鍙湁鍙戣捣浜哄彲浠ュ彇娑堝緟澶勭悊浜嬮」");
+ if (mapper.update(null, new LambdaUpdateWrapper<AfterSaleCollaborationDO>()
+ .eq(AfterSaleCollaborationDO::getId, id).eq(AfterSaleCollaborationDO::getStatus, 0)
+ .eq(AfterSaleCollaborationDO::getRequestedBy, userId).set(AfterSaleCollaborationDO::getStatus, 2)) != 1)
+ throw invalidParamException("鍗忓悓浜嬮」鐘舵�佸凡鍙樺寲锛岃鍒锋柊鍚庨噸璇�");
+ }
+
+ /** 涓氬姟瀹℃壒閫氳繃鍚庡垱寤鸿储鍔″鏍歌崏绋匡紱鑽夌鍒涘缓澶辫触鏃舵湰娆″鎵规暣浣撳洖婊氥�� */
+ @Transactional(rollbackFor = Exception.class)
+ public void reviewFinancial(Long id, Long userId, boolean approved, String remark) {
+ if (id == null || userId == null || (remark != null && remark.length() > 1000)
+ || (!approved && (remark == null || remark.isBlank()))) throw invalidParamException("閫�鍥炴椂璇峰~鍐欎笟鍔″鏍告剰瑙�");
+ AfterSaleCollaborationDO task = mapper.selectById(id);
+ if (task == null || !Objects.equals(task.getStatus(), 1) || task.getAmount() == null)
+ throw invalidParamException("浜嬮」涓嶅瓨鍦ㄦ垨鏈浜庡緟涓氬姟瀹℃牳鐘舵��");
+ AfterSaleTicketDO ticket = ticketService.getTicket(task.getTicketId());
+ if (ticket == null || !canWrite(ticket, userId)) throw invalidParamException("鏃犳潈瀹℃牳璇ュ伐鍗曠殑鍗忓悓浜嬮」");
+ int changed = mapper.update(null, new LambdaUpdateWrapper<AfterSaleCollaborationDO>()
+ .eq(AfterSaleCollaborationDO::getId, id).eq(AfterSaleCollaborationDO::getStatus, 1)
+ .isNotNull(AfterSaleCollaborationDO::getAmount)
+ .set(AfterSaleCollaborationDO::getStatus, approved ? 3 : 4)
+ .set(AfterSaleCollaborationDO::getBusinessApproverId, userId)
+ .set(AfterSaleCollaborationDO::getBusinessApprovalTime, LocalDateTime.now())
+ .set(AfterSaleCollaborationDO::getBusinessRemark, remark));
+ if (changed != 1) throw invalidParamException("浜嬮」鐘舵�佸凡鍙樺寲锛岃鍒锋柊鍚庨噸璇�");
+ if (approved) {
+ var input = new AfterSaleFinanceDraftCreateDTO();
+ input.setCollaborationId(id); input.setTicketId(task.getTicketId()); input.setCategory(task.getCategory());
+ input.setDirection(task.getDirection()); input.setAmount(task.getAmount()); input.setPartyName(task.getPartyName());
+ input.setPartyType(task.getPartyType()); input.setPartyId(task.getPartyId());
+ input.setDescription(task.getResult()); input.setBusinessApproverId(userId);
+ Long draftId = financeDraftApi.createDraft(input);
+ if (draftId == null) throw invalidParamException("璐㈠姟鑽夌鍒涘缓澶辫触");
+ var update = new AfterSaleCollaborationDO(); update.setId(id); update.setFinanceDraftId(draftId);
+ if (mapper.updateById(update) != 1) throw invalidParamException("鍏宠仈璐㈠姟鑽夌澶辫触锛岃閲嶈瘯");
+ }
+ }
+
+ private boolean canWrite(AfterSaleTicketDO ticket, Long userId) {
+ return Objects.equals(ticket.getOwnerUserId(), userId) || permissionApi.hasAnyRoles(userId, "aftersales_admin")
+ || permissionService.hasPermission(AfterSaleBizTypeEnum.AFTER_SALE_TICKET.getType(), ticket.getId(), userId, AfterSalePermissionLevelEnum.WRITE)
+ || permissionService.hasPermission(AfterSaleBizTypeEnum.AFTER_SALE_TICKET.getType(), ticket.getId(), userId, AfterSalePermissionLevelEnum.OWNER);
+ }
+
+ private boolean canRead(AfterSaleTicketDO ticket, Long userId) {
+ return canWrite(ticket, userId) || permissionService.hasPermission(AfterSaleBizTypeEnum.AFTER_SALE_TICKET.getType(), ticket.getId(), userId, AfterSalePermissionLevelEnum.READ);
+ }
+}
diff --git a/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/service/ticket/AfterSaleLedgerService.java b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/service/ticket/AfterSaleLedgerService.java
new file mode 100644
index 0000000..a62c8ea
--- /dev/null
+++ b/yudao-module-aftersales/src/main/java/cn/iocoder/yudao/module/aftersales/service/ticket/AfterSaleLedgerService.java
@@ -0,0 +1,24 @@
+package cn.iocoder.yudao.module.aftersales.service.ticket;
+
+import cn.iocoder.yudao.module.aftersales.controller.admin.ticket.vo.ticket.AfterSaleTicketPageReqVO;
+import cn.iocoder.yudao.module.aftersales.enums.AfterSaleTicketStatusEnum;
+import jakarta.annotation.Resource;
+import org.springframework.stereotype.Service;
+import java.util.LinkedHashMap;
+import java.util.Map;
+
+/** 澶嶇敤宸ュ崟鍒楄〃鏉冮檺鍜屽満鏅紝缁熻褰撳墠鐢ㄦ埛鍙宸ュ崟銆� */
+@Service
+public class AfterSaleLedgerService {
+ @Resource private AfterSaleTicketService ticketService;
+
+ public Map<Integer, Long> overview(Long userId, Integer sceneType) {
+ Map<Integer, Long> counts = new LinkedHashMap<>();
+ for (AfterSaleTicketStatusEnum status : AfterSaleTicketStatusEnum.values()) {
+ var request = new AfterSaleTicketPageReqVO();
+ request.setPageNo(1); request.setPageSize(1); request.setSceneType(sceneType); request.setStatus(status.getStatus());
+ counts.put(status.getStatus(), ticketService.getTicketPage(request, userId).getTotal());
+ }
+ return counts;
+ }
+}
diff --git a/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/AfterSaleFinanceDraftApi.java b/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/AfterSaleFinanceDraftApi.java
new file mode 100644
index 0000000..d4be64e
--- /dev/null
+++ b/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/AfterSaleFinanceDraftApi.java
@@ -0,0 +1,12 @@
+package cn.iocoder.yudao.module.erp.api.finance;
+
+import cn.iocoder.yudao.module.erp.api.finance.dto.AfterSaleFinanceDraftCreateDTO;
+import cn.iocoder.yudao.module.erp.api.finance.dto.AfterSaleFinanceReviewDTO;
+import java.util.List;
+import java.util.Map;
+
+/** 渚涘敭鍚庝笟鍔$‘璁ゅ悗鍒涘缓璐㈠姟瀹℃牳鑽夌锛涗笉鎵ц浠樻鎴栬璐︺�� */
+public interface AfterSaleFinanceDraftApi {
+ Long createDraft(AfterSaleFinanceDraftCreateDTO input);
+ Map<Long, AfterSaleFinanceReviewDTO> getReviewResults(List<Long> ids);
+}
diff --git a/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/dto/AfterSaleFinanceDraftCreateDTO.java b/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/dto/AfterSaleFinanceDraftCreateDTO.java
new file mode 100644
index 0000000..725af50
--- /dev/null
+++ b/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/dto/AfterSaleFinanceDraftCreateDTO.java
@@ -0,0 +1,18 @@
+package cn.iocoder.yudao.module.erp.api.finance.dto;
+
+import lombok.Data;
+import java.math.BigDecimal;
+
+@Data
+public class AfterSaleFinanceDraftCreateDTO {
+ private Long collaborationId;
+ private Long ticketId;
+ private String category;
+ private String direction;
+ private BigDecimal amount;
+ private String partyName;
+ private String partyType;
+ private Long partyId;
+ private String description;
+ private Long businessApproverId;
+}
diff --git a/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/dto/AfterSaleFinanceReviewDTO.java b/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/dto/AfterSaleFinanceReviewDTO.java
new file mode 100644
index 0000000..545be2e
--- /dev/null
+++ b/yudao-module-erp-api/src/main/java/cn/iocoder/yudao/module/erp/api/finance/dto/AfterSaleFinanceReviewDTO.java
@@ -0,0 +1,11 @@
+package cn.iocoder.yudao.module.erp.api.finance.dto;
+
+import lombok.Data;
+import java.time.LocalDateTime;
+
+@Data
+public class AfterSaleFinanceReviewDTO {
+ private Integer status;
+ private String remark;
+ private LocalDateTime reviewTime;
+}
diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/controller/admin/finance/ErpAfterSaleFinanceDraftController.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/controller/admin/finance/ErpAfterSaleFinanceDraftController.java
new file mode 100644
index 0000000..65628d1
--- /dev/null
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/controller/admin/finance/ErpAfterSaleFinanceDraftController.java
@@ -0,0 +1,37 @@
+package cn.iocoder.yudao.module.erp.controller.admin.finance;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.erp.dal.dataobject.finance.ErpAfterSaleFinanceDraftDO;
+import cn.iocoder.yudao.module.erp.service.finance.ErpAfterSaleFinanceDraftService;
+import jakarta.annotation.Resource;
+import jakarta.validation.Valid;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.web.bind.annotation.*;
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.invalidParamException;
+import static cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils.getLoginUserId;
+
+@RestController
+@RequestMapping("/erp/finance/after-sale-draft")
+public class ErpAfterSaleFinanceDraftController {
+ @Resource private ErpAfterSaleFinanceDraftService service;
+
+ @GetMapping("/page")
+ @PreAuthorize("@ss.hasPermission('erp:after-sale-finance:query')")
+ public CommonResult<PageResult<ErpAfterSaleFinanceDraftDO>> page(@Valid PageParam page,
+ @RequestParam(value = "status", required = false) Integer status) {
+ return success(service.page(page, status));
+ }
+
+ @PutMapping("/review")
+ @PreAuthorize("@ss.hasPermission('erp:after-sale-finance:review')")
+ public CommonResult<Boolean> review(@RequestParam("id") Long id, @RequestBody ReviewRequest request) {
+ if (request == null || request.approved() == null) throw invalidParamException("璇烽�夋嫨瀹℃牳缁撴灉");
+ service.review(id, getLoginUserId(), request.approved(), request.remark());
+ return success(true);
+ }
+
+ public record ReviewRequest(Boolean approved, String remark) {}
+}
diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/dataobject/finance/ErpAfterSaleFinanceDraftDO.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/dataobject/finance/ErpAfterSaleFinanceDraftDO.java
new file mode 100644
index 0000000..76b3809
--- /dev/null
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/dataobject/finance/ErpAfterSaleFinanceDraftDO.java
@@ -0,0 +1,33 @@
+package cn.iocoder.yudao.module.erp.dal.dataobject.finance;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import tools.jackson.databind.annotation.JsonSerialize;
+import tools.jackson.databind.ser.std.ToStringSerializer;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import java.math.BigDecimal;
+import java.time.LocalDateTime;
+
+@TableName("erp_after_sale_finance_draft")
+@Data
+@EqualsAndHashCode(callSuper = true)
+public class ErpAfterSaleFinanceDraftDO extends BaseDO {
+ @TableId private Long id;
+ private Long collaborationId;
+ private Long ticketId;
+ private String category;
+ private String direction;
+ @JsonSerialize(using = ToStringSerializer.class)
+ private BigDecimal amount;
+ private String partyName;
+ private String partyType;
+ private Long partyId;
+ private String description;
+ private Long businessApproverId;
+ private Integer status;
+ private Long reviewerId;
+ private String reviewRemark;
+ private LocalDateTime reviewTime;
+}
diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/finance/ErpAfterSaleFinanceDraftMapper.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/finance/ErpAfterSaleFinanceDraftMapper.java
new file mode 100644
index 0000000..7243c9a
--- /dev/null
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/finance/ErpAfterSaleFinanceDraftMapper.java
@@ -0,0 +1,8 @@
+package cn.iocoder.yudao.module.erp.dal.mysql.finance;
+
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.erp.dal.dataobject.finance.ErpAfterSaleFinanceDraftDO;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface ErpAfterSaleFinanceDraftMapper extends BaseMapperX<ErpAfterSaleFinanceDraftDO> {}
diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/enums/ErrorCodeConstants.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/enums/ErrorCodeConstants.java
index d7fb9d3..9857c8f 100644
--- a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/enums/ErrorCodeConstants.java
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/enums/ErrorCodeConstants.java
@@ -100,6 +100,8 @@
ErrorCode SALE_ORDER_SUBMIT_FAIL_ITEM_EMPTY = new ErrorCode(1_020_201_018, "鎻愪氦瀹℃壒澶辫触锛岄攢鍞鍗�({})娌℃湁璁㈠崟鏄庣粏锛屾棤娉曟彁浜�");
ErrorCode SALE_ORDER_BPM_CATEGORY_NOT_EXISTS = new ErrorCode(1_020_201_019, "閿�鍞鍗曞鏍稿垎绫讳笉瀛樺湪锛岃鍏堝湪BPM妯″潡鍒涘缓閿�鍞鍗曞鏍告祦绋嬪垎绫�");
ErrorCode SALE_ORDER_BPM_PROCESS_DEFINITION_NOT_EXISTS = new ErrorCode(1_020_201_020, "閿�鍞鍗曞鏍稿垎绫讳笅娌℃湁鍙敤鐨勬祦绋嬫ā鍨嬶紝璇峰厛鍒涘缓骞跺彂甯冩祦绋�");
+ ErrorCode SALE_ORDER_CANCEL_FAIL_ACTIVE_MPS = new ErrorCode(1_020_201_021, "浣滃簾澶辫触锛岃鍗曚粛鏈夊叧鑱旂敓浜ц鍒掞紝璇峰厛澶勭悊骞跺彇娑堢敓浜ц鍒�");
+ ErrorCode SALE_ORDER_CANCEL_FAIL_MPS_UNKNOWN = new ErrorCode(1_020_201_022, "鏃犳硶纭鍏宠仈鐢熶骇璁″垝鐘舵�侊紝璇风◢鍚庨噸璇�");
// ========== ERP 閿�鍞嚭搴擄紙1-030-202-000锛� ==========
ErrorCode SALE_OUT_NOT_EXISTS = new ErrorCode(1_020_202_000, "閿�鍞嚭搴撳崟涓嶅瓨鍦�");
diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/finance/ErpAfterSaleFinanceDraftService.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/finance/ErpAfterSaleFinanceDraftService.java
new file mode 100644
index 0000000..584c88f
--- /dev/null
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/finance/ErpAfterSaleFinanceDraftService.java
@@ -0,0 +1,79 @@
+package cn.iocoder.yudao.module.erp.service.finance;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.erp.api.finance.AfterSaleFinanceDraftApi;
+import cn.iocoder.yudao.module.erp.api.finance.dto.AfterSaleFinanceDraftCreateDTO;
+import cn.iocoder.yudao.module.erp.api.finance.dto.AfterSaleFinanceReviewDTO;
+import cn.iocoder.yudao.module.erp.dal.dataobject.finance.ErpAfterSaleFinanceDraftDO;
+import cn.iocoder.yudao.module.erp.dal.mysql.finance.ErpAfterSaleFinanceDraftMapper;
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
+import jakarta.annotation.Resource;
+import org.springframework.dao.DuplicateKeyException;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import java.math.BigDecimal;
+import java.time.LocalDateTime;
+import java.util.Objects;
+import java.util.Set;
+import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.invalidParamException;
+
+@Service
+public class ErpAfterSaleFinanceDraftService implements AfterSaleFinanceDraftApi {
+ @Resource private ErpAfterSaleFinanceDraftMapper mapper;
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public Long createDraft(AfterSaleFinanceDraftCreateDTO input) {
+ if (input == null || input.getCollaborationId() == null || input.getTicketId() == null || input.getBusinessApproverId() == null
+ || input.getCategory() == null || !Set.of("QUALITY", "FINANCE", "SUPPLIER", "WARRANTY").contains(input.getCategory())
+ || input.getDirection() == null || !Set.of("RECEIVABLE", "PAYABLE", "INTERNAL").contains(input.getDirection())
+ || input.getAmount() == null || input.getAmount().signum() <= 0 || input.getAmount().stripTrailingZeros().scale() > 2
+ || input.getAmount().compareTo(new BigDecimal("9999999999999999.99")) > 0
+ || input.getDescription() == null || input.getDescription().isBlank() || input.getDescription().length() > 2000
+ || (input.getPartyName() != null && input.getPartyName().length() > 200)
+ || (!"INTERNAL".equals(input.getDirection()) && (input.getPartyName() == null || input.getPartyName().isBlank())))
+ throw invalidParamException("璐㈠姟鑽夌鐨勯噾棰濄�佹柟鍚戙�佸線鏉ユ柟鎴栨潵婧愪笉姝g‘");
+ var draft = new ErpAfterSaleFinanceDraftDO();
+ draft.setCollaborationId(input.getCollaborationId()); draft.setTicketId(input.getTicketId());
+ draft.setCategory(input.getCategory()); draft.setDirection(input.getDirection()); draft.setAmount(input.getAmount());
+ draft.setPartyName(input.getPartyName()); draft.setDescription(input.getDescription());
+ draft.setPartyType(input.getPartyType()); draft.setPartyId(input.getPartyId());
+ draft.setBusinessApproverId(input.getBusinessApproverId()); draft.setStatus(0);
+ try { mapper.insert(draft); }
+ catch (DuplicateKeyException e) { throw invalidParamException("璇ュ崗鍚屼簨椤瑰凡鐢熸垚璐㈠姟鑽夌"); }
+ return draft.getId();
+ }
+
+ public PageResult<ErpAfterSaleFinanceDraftDO> page(PageParam page, Integer status) {
+ if (status != null && !Set.of(0, 1, 2).contains(status)) throw invalidParamException("瀹℃牳鐘舵�佷笉姝g‘");
+ return mapper.selectPage(page, new LambdaQueryWrapperX<ErpAfterSaleFinanceDraftDO>()
+ .eqIfPresent(ErpAfterSaleFinanceDraftDO::getStatus, status).orderByDesc(ErpAfterSaleFinanceDraftDO::getId));
+ }
+
+ @Override
+ public Map<Long, AfterSaleFinanceReviewDTO> getReviewResults(List<Long> ids) {
+ if (ids == null || ids.isEmpty()) return Map.of();
+ return mapper.selectBatchIds(ids).stream().collect(Collectors.toMap(ErpAfterSaleFinanceDraftDO::getId, draft -> {
+ var result = new AfterSaleFinanceReviewDTO(); result.setStatus(draft.getStatus());
+ result.setRemark(draft.getReviewRemark()); result.setReviewTime(draft.getReviewTime()); return result;
+ }));
+ }
+
+ @Transactional(rollbackFor = Exception.class)
+ public void review(Long id, Long reviewerId, boolean approved, String remark) {
+ if (id == null || reviewerId == null || (remark != null && remark.length() > 1000)
+ || (!approved && (remark == null || remark.isBlank()))) throw invalidParamException("閫�鍥炴椂璇峰~鍐欏鏍告剰瑙�");
+ var draft = mapper.selectById(id);
+ if (draft == null || !Objects.equals(draft.getStatus(), 0)) throw invalidParamException("鑽夌涓嶅瓨鍦ㄦ垨宸插鏍�");
+ if (mapper.update(null, new LambdaUpdateWrapper<ErpAfterSaleFinanceDraftDO>()
+ .eq(ErpAfterSaleFinanceDraftDO::getId, id).eq(ErpAfterSaleFinanceDraftDO::getStatus, 0)
+ .set(ErpAfterSaleFinanceDraftDO::getStatus, approved ? 1 : 2).set(ErpAfterSaleFinanceDraftDO::getReviewerId, reviewerId)
+ .set(ErpAfterSaleFinanceDraftDO::getReviewRemark, remark).set(ErpAfterSaleFinanceDraftDO::getReviewTime, LocalDateTime.now())) != 1)
+ throw invalidParamException("鑽夌鐘舵�佸凡鍙樺寲锛岃鍒锋柊鍚庨噸璇�");
+ }
+}
diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/sale/ErpSaleOrderServiceImpl.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/sale/ErpSaleOrderServiceImpl.java
index 04d1d9b..beec292 100644
--- a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/sale/ErpSaleOrderServiceImpl.java
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/service/sale/ErpSaleOrderServiceImpl.java
@@ -605,6 +605,17 @@
throw exception(SALE_ORDER_CANCEL_FAIL_EXISTS_OUT);
}
+ // 閿�鍞鍗曞鏍稿悗鍙兘宸茬敓鎴� MPS銆傛湭鍙栨秷鐨勮鍒掍笉鑳介殢鐫�璁㈠崟浣滃簾缁х画鎵ц銆�
+ List<ErpSaleOrderItemDO> orderItems = saleOrderItemMapper.selectListByOrderId(id);
+ if (CollUtil.isNotEmpty(orderItems)) {
+ List<Long> itemIds = convertList(orderItems, ErpSaleOrderItemDO::getId);
+ List<MesProMpsRespDTO> plans = mpsApi.getMpsListBySaleOrderItemIds(itemIds);
+ if (plans == null) throw exception(SALE_ORDER_CANCEL_FAIL_MPS_UNKNOWN);
+ if (plans.stream().anyMatch(plan -> plan == null || ObjectUtil.notEqual(plan.getStatus(), MPS_STATUS_CANCELED))) {
+ throw exception(SALE_ORDER_CANCEL_FAIL_ACTIVE_MPS);
+ }
+ }
+
// 2. 鏇存柊鐘舵�佷负宸蹭綔搴�
int updateCount = saleOrderMapper.updateByIdAndStatus(id, saleOrder.getStatus(),
new ErpSaleOrderDO().setStatus(ErpAuditStatus.CANCEL.getStatus()));
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/knowledge/KnowledgeController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/knowledge/KnowledgeController.java
new file mode 100644
index 0000000..1314025
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/knowledge/KnowledgeController.java
@@ -0,0 +1,94 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.knowledge;
+
+import cn.iocoder.yudao.framework.common.pojo.CommonResult;
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeDO;
+import cn.iocoder.yudao.module.mes.service.pd.knowledge.KnowledgeMatch;
+import cn.iocoder.yudao.module.mes.service.pd.knowledge.KnowledgeSearchService;
+import cn.iocoder.yudao.module.mes.service.pd.knowledge.KnowledgeWriteService;
+import jakarta.annotation.Resource;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.PutMapping;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestParam;
+import org.springframework.web.bind.annotation.RestController;
+
+import java.math.BigDecimal;
+import java.util.List;
+import java.util.Set;
+import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.invalidParamException;
+
+@RestController
+@RequestMapping("/mes/pd/knowledge")
+public class KnowledgeController {
+ @Resource private KnowledgeSearchService searchService;
+ @Resource private KnowledgeWriteService writeService;
+
+ @GetMapping("/page")
+ @PreAuthorize("@ss.hasPermission('mes:pd-knowledge:query')")
+ public CommonResult<PageResult<KnowledgeDO>> page(PageParam page,
+ @RequestParam(value = "name", required = false) String name) {
+ return success(searchService.page(page, name));
+ }
+
+ @GetMapping("/get")
+ @PreAuthorize("@ss.hasPermission('mes:pd-knowledge:query')")
+ public CommonResult<KnowledgeSearchService.Detail> get(@RequestParam("id") Long id) {
+ return success(searchService.get(id));
+ }
+
+ @PostMapping("/create")
+ @PreAuthorize("@ss.hasPermission('mes:pd-knowledge:create')")
+ public CommonResult<Long> create(@RequestBody KnowledgeWriteService.SaveRequest input) {
+ return success(writeService.create(input));
+ }
+
+ @PutMapping("/update")
+ @PreAuthorize("@ss.hasPermission('mes:pd-knowledge:update')")
+ public CommonResult<Boolean> update(@RequestBody KnowledgeWriteService.SaveRequest input) {
+ writeService.update(input);
+ return success(true);
+ }
+
+ @PutMapping("/publish")
+ @PreAuthorize("@ss.hasPermission('mes:pd-knowledge:publish')")
+ public CommonResult<Boolean> publish(@RequestParam("id") Long id) {
+ writeService.publish(id);
+ return success(true);
+ }
+
+ @PostMapping("/revise")
+ @PreAuthorize("@ss.hasPermission('mes:pd-knowledge:create')")
+ public CommonResult<Long> revise(@RequestParam("id") Long id) {
+ return success(writeService.revise(id));
+ }
+
+ @PostMapping("/reference-route")
+ @PreAuthorize("@ss.hasPermission('mes:pd-knowledge:reference')")
+ public CommonResult<Boolean> referenceRoute(@RequestParam("id") Long id, @RequestParam("routeId") Long routeId) {
+ writeService.referenceRoute(id, routeId);
+ return success(true);
+ }
+
+ @GetMapping("/match")
+ @PreAuthorize("@ss.hasPermission('mes:pd-knowledge:query')")
+ public CommonResult<List<KnowledgeDO>> match(
+ @RequestParam(value = "productId", required = false) Long productId,
+ @RequestParam(value = "bomId", required = false) Long bomId,
+ @RequestParam(value = "voltage", required = false) BigDecimal voltage,
+ @RequestParam(value = "market", required = false) String market,
+ @RequestParam(value = "standards", required = false) Set<String> standards) {
+ if (market != null && !Set.of("DOMESTIC", "EXPORT").contains(market)) {
+ throw invalidParamException("鍐呭閿�绫诲瀷涓嶆纭�");
+ }
+ if (voltage != null && voltage.signum() < 0) {
+ throw invalidParamException("鐢靛帇涓嶈兘灏忎簬闆�");
+ }
+ return success(searchService.match(new KnowledgeMatch.Request(productId, bomId, voltage, market, standards)));
+ }
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeDO.java
new file mode 100644
index 0000000..bdd2d57
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeDO.java
@@ -0,0 +1,27 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import java.math.BigDecimal;
+
+@TableName("mes_pd_knowledge")
+@Data
+@EqualsAndHashCode(callSuper = true)
+public class KnowledgeDO extends BaseDO {
+ @TableId private Long id;
+ private String code;
+ private String name;
+ private Integer version;
+ private Long productItemId;
+ private Long bomId;
+ private BigDecimal voltageMin;
+ private BigDecimal voltageMax;
+ private String market;
+ private Long routeId;
+ private Long templateId;
+ private String description;
+ private Integer status;
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeReferenceDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeReferenceDO.java
new file mode 100644
index 0000000..8b3ab0f
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeReferenceDO.java
@@ -0,0 +1,18 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+@TableName("mes_pd_knowledge_reference")
+@Data
+@EqualsAndHashCode(callSuper = true)
+public class KnowledgeReferenceDO extends BaseDO {
+ @TableId private Long id;
+ private Long knowledgeId;
+ private Integer knowledgeVersion;
+ private String targetType;
+ private Long targetId;
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeResourceDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeResourceDO.java
new file mode 100644
index 0000000..343f422
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeResourceDO.java
@@ -0,0 +1,19 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+@TableName("mes_pd_knowledge_resource")
+@Data
+@EqualsAndHashCode(callSuper = true)
+public class KnowledgeResourceDO extends BaseDO {
+ @TableId private Long id;
+ private Long knowledgeId;
+ private Long processId;
+ private String resourceType;
+ private Long resourceId;
+ private String capabilityDescription;
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeStandardDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeStandardDO.java
new file mode 100644
index 0000000..1c364a0
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/knowledge/KnowledgeStandardDO.java
@@ -0,0 +1,17 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+@TableName("mes_pd_knowledge_standard")
+@Data
+@EqualsAndHashCode(callSuper = true)
+public class KnowledgeStandardDO extends BaseDO {
+ @TableId private Long id;
+ private Long knowledgeId;
+ private String standardCode;
+ private String standardName;
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeMapper.java
new file mode 100644
index 0000000..668bdd4
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeMapper.java
@@ -0,0 +1,8 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeDO;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface KnowledgeMapper extends BaseMapperX<KnowledgeDO> {}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeReferenceMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeReferenceMapper.java
new file mode 100644
index 0000000..20e38a0
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeReferenceMapper.java
@@ -0,0 +1,8 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeReferenceDO;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface KnowledgeReferenceMapper extends BaseMapperX<KnowledgeReferenceDO> {}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeResourceMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeResourceMapper.java
new file mode 100644
index 0000000..4c6c4a6
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeResourceMapper.java
@@ -0,0 +1,8 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeResourceDO;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface KnowledgeResourceMapper extends BaseMapperX<KnowledgeResourceDO> {}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeStandardMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeStandardMapper.java
new file mode 100644
index 0000000..057f066
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/knowledge/KnowledgeStandardMapper.java
@@ -0,0 +1,8 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeStandardDO;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface KnowledgeStandardMapper extends BaseMapperX<KnowledgeStandardDO> {}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeMatch.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeMatch.java
new file mode 100644
index 0000000..8b40af5
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeMatch.java
@@ -0,0 +1,31 @@
+package cn.iocoder.yudao.module.mes.service.pd.knowledge;
+
+import java.math.BigDecimal;
+import java.util.Objects;
+import java.util.Set;
+
+/** 鍖归厤宸插彂甯冨伐鑹虹煡璇嗙殑閫傜敤鑼冨洿锛涙湭鐭ユ潯浠朵笉鑳芥弧瓒虫湁绾︽潫鐨勭煡璇嗐�� */
+public final class KnowledgeMatch {
+ private KnowledgeMatch() {}
+
+ public record Criteria(Long productId, Long bomId, BigDecimal minVoltage,
+ BigDecimal maxVoltage, String market, Set<String> standards) {}
+ public record Request(Long productId, Long bomId, BigDecimal voltage,
+ String market, Set<String> standards) {}
+
+ public static boolean matches(Criteria criteria, Request request) {
+ Objects.requireNonNull(criteria, "criteria");
+ Objects.requireNonNull(request, "request");
+ if (criteria.productId() != null && !criteria.productId().equals(request.productId())) return false;
+ if (criteria.bomId() != null && !criteria.bomId().equals(request.bomId())) return false;
+ if (criteria.minVoltage() != null || criteria.maxVoltage() != null) {
+ if (request.voltage() == null) return false;
+ if (criteria.minVoltage() != null && request.voltage().compareTo(criteria.minVoltage()) < 0) return false;
+ if (criteria.maxVoltage() != null && request.voltage().compareTo(criteria.maxVoltage()) > 0) return false;
+ }
+ if (!"ALL".equals(criteria.market()) && !Objects.equals(criteria.market(), request.market())) return false;
+ Set<String> available = criteria.standards() == null ? Set.of() : criteria.standards();
+ Set<String> required = request.standards() == null ? Set.of() : request.standards();
+ return available.containsAll(required);
+ }
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeSearchService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeSearchService.java
new file mode 100644
index 0000000..3bedb81
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeSearchService.java
@@ -0,0 +1,86 @@
+package cn.iocoder.yudao.module.mes.service.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeStandardDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeResourceDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeReferenceDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge.KnowledgeMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge.KnowledgeStandardMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge.KnowledgeResourceMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge.KnowledgeReferenceMapper;
+import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdProductBomDO;
+import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
+import cn.iocoder.yudao.module.mes.service.md.item.MesMdProductBomService;
+import jakarta.annotation.Resource;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+import java.util.Map;
+import java.util.Set;
+import java.util.Objects;
+import java.util.stream.Collectors;
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.invalidParamException;
+
+/** 宸插彂甯冪煡璇嗙殑鏉′欢鍖归厤锛涜崏绋垮拰鍋滅敤鐗堟湰涓嶅弬涓庢帹鑽愩�� */
+@Service
+public class KnowledgeSearchService {
+ @Resource private KnowledgeMapper knowledgeMapper;
+ @Resource private KnowledgeStandardMapper standardMapper;
+ @Resource private KnowledgeResourceMapper resourceMapper;
+ @Resource private KnowledgeReferenceMapper referenceMapper;
+ @Resource private MesMdItemService itemService;
+ @Resource private MesMdProductBomService bomService;
+
+ public PageResult<KnowledgeDO> page(PageParam page, String name) {
+ return knowledgeMapper.selectPage(page, new LambdaQueryWrapperX<KnowledgeDO>()
+ .likeIfPresent(KnowledgeDO::getName, name).orderByDesc(KnowledgeDO::getId));
+ }
+
+ public Detail get(Long id) {
+ KnowledgeDO record = knowledgeMapper.selectById(id);
+ if (record == null) return null;
+ List<String> standards = standardMapper.selectList(new LambdaQueryWrapperX<KnowledgeStandardDO>()
+ .eq(KnowledgeStandardDO::getKnowledgeId, id)).stream()
+ .map(KnowledgeStandardDO::getStandardCode).toList();
+ List<KnowledgeResourceDO> resources = resourceMapper.selectList(new LambdaQueryWrapperX<KnowledgeResourceDO>()
+ .eq(KnowledgeResourceDO::getKnowledgeId, id));
+ List<KnowledgeReferenceDO> references = referenceMapper.selectList(new LambdaQueryWrapperX<KnowledgeReferenceDO>()
+ .eq(KnowledgeReferenceDO::getKnowledgeId, id));
+ return new Detail(record, standards, resources, references);
+ }
+
+ public record Detail(KnowledgeDO knowledge, List<String> standards, List<KnowledgeResourceDO> resources, List<KnowledgeReferenceDO> references) {}
+
+ public List<KnowledgeDO> match(KnowledgeMatch.Request request) {
+ if (request.bomId() != null && request.productId() == null) throw invalidParamException("璇烽�夋嫨 BOM 鏄庣粏鎵�灞炵殑鐗╂枡");
+ if (request.productId() != null) itemService.validateItemExists(request.productId());
+ Set<Long> productBomItems;
+ if (request.productId() != null) {
+ productBomItems = bomService.getProductBomListByItemId(request.productId()).stream()
+ .filter(bom -> Objects.equals(bom.getItemId(), request.productId()) && Objects.equals(bom.getStatus(), 0)).map(MesMdProductBomDO::getBomItemId)
+ .filter(Objects::nonNull).collect(Collectors.toSet());
+ } else productBomItems = Set.of();
+ if (request.bomId() != null && !productBomItems.contains(request.bomId()))
+ throw invalidParamException("鎵�閫� BOM 瀛愮墿鏂欎笉瀛樺湪銆佹湭鍚敤鎴栦笉灞炰簬璇ョ墿鏂�");
+ Set<Long> candidateBomItems = request.bomId() == null ? productBomItems : Set.of(request.bomId());
+ List<KnowledgeDO> records = knowledgeMapper.selectList(new LambdaQueryWrapperX<KnowledgeDO>()
+ .eq(KnowledgeDO::getStatus, 1).orderByDesc(KnowledgeDO::getId));
+ if (records.isEmpty()) return List.of();
+ List<Long> ids = records.stream().map(KnowledgeDO::getId).toList();
+ Map<Long, Set<String>> standards = standardMapper.selectList(new LambdaQueryWrapperX<KnowledgeStandardDO>()
+ .in(KnowledgeStandardDO::getKnowledgeId, ids)).stream()
+ .collect(Collectors.groupingBy(KnowledgeStandardDO::getKnowledgeId,
+ Collectors.mapping(KnowledgeStandardDO::getStandardCode, Collectors.toSet())));
+ return records.stream().filter(record -> {
+ if (record.getBomId() != null && !candidateBomItems.contains(record.getBomId())) return false;
+ // 宸叉寜 BOM 瀛愮墿鏂欐瘮瀵癸紝鍚戠函瑙勫垯浼犻�掑綋鍓嶇煡璇嗗搴旂殑绾︽潫銆�
+ var resolvedRequest = new KnowledgeMatch.Request(request.productId(), record.getBomId(), request.voltage(), request.market(), request.standards());
+ return KnowledgeMatch.matches(new KnowledgeMatch.Criteria(record.getProductItemId(), record.getBomId(),
+ record.getVoltageMin(), record.getVoltageMax(), record.getMarket(),
+ standards.getOrDefault(record.getId(), Set.of())), resolvedRequest);
+ }).toList();
+ }
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeWriteService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeWriteService.java
new file mode 100644
index 0000000..2ae81f6
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/knowledge/KnowledgeWriteService.java
@@ -0,0 +1,242 @@
+package cn.iocoder.yudao.module.mes.service.pd.knowledge;
+
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeStandardDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeResourceDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.knowledge.KnowledgeReferenceDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge.KnowledgeMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge.KnowledgeStandardMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge.KnowledgeResourceMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.knowledge.KnowledgeReferenceMapper;
+import cn.iocoder.yudao.module.mes.service.dv.machinery.MesDvMachineryService;
+import cn.iocoder.yudao.module.mes.service.md.workstation.MesMdWorkstationService;
+import cn.iocoder.yudao.module.mes.service.pro.process.MesProProcessService;
+import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
+import cn.iocoder.yudao.module.mes.service.md.item.MesMdProductBomService;
+import cn.iocoder.yudao.module.mes.service.pro.route.MesProRouteService;
+import cn.iocoder.yudao.module.mes.service.pd.processparamtemplate.MesPdProcessParamTemplateService;
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
+import jakarta.annotation.Resource;
+import lombok.Data;
+import org.springframework.stereotype.Service;
+import org.springframework.dao.DuplicateKeyException;
+import org.springframework.transaction.annotation.Transactional;
+import java.math.BigDecimal;
+import java.util.List;
+import java.util.Objects;
+import java.util.Set;
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.invalidParamException;
+
+@Service
+public class KnowledgeWriteService {
+ @Resource private KnowledgeMapper knowledgeMapper;
+ @Resource private KnowledgeStandardMapper standardMapper;
+ @Resource private KnowledgeResourceMapper resourceMapper;
+ @Resource private KnowledgeReferenceMapper referenceMapper;
+ @Resource private MesDvMachineryService machineryService;
+ @Resource private MesMdWorkstationService workstationService;
+ @Resource private MesProProcessService processService;
+ @Resource private MesMdItemService itemService;
+ @Resource private MesMdProductBomService bomService;
+ @Resource private MesProRouteService routeService;
+ @Resource private MesPdProcessParamTemplateService templateService;
+
+ @Data
+ public static class SaveRequest {
+ private Long id;
+ private String code;
+ private String name;
+ private Long productItemId;
+ private Long bomId;
+ private BigDecimal voltageMin;
+ private BigDecimal voltageMax;
+ private String market;
+ private Long routeId;
+ private Long templateId;
+ private String description;
+ private List<String> standards;
+ private List<ResourceInput> resources;
+ }
+
+ @Data
+ public static class ResourceInput {
+ private Long processId;
+ private String resourceType;
+ private Long resourceId;
+ private String capabilityDescription;
+ }
+
+ @Transactional(rollbackFor = Exception.class)
+ public Long create(SaveRequest input) {
+ validate(input);
+ String code = input.getCode().trim();
+ if (!knowledgeMapper.selectList(new LambdaQueryWrapperX<KnowledgeDO>()
+ .eq(KnowledgeDO::getCode, code).eq(KnowledgeDO::getVersion, 1)).isEmpty()) {
+ throw invalidParamException("鐭ヨ瘑缂栫爜宸插瓨鍦�");
+ }
+ var record = new KnowledgeDO();
+ record.setCode(code); record.setVersion(1); record.setStatus(0);
+ copyFields(record, input);
+ try {
+ knowledgeMapper.insert(record);
+ } catch (DuplicateKeyException e) {
+ throw invalidParamException("鐭ヨ瘑缂栫爜宸插瓨鍦�");
+ }
+ saveStandards(record.getId(), input.getStandards());
+ saveResources(record.getId(), input.getResources());
+ return record.getId();
+ }
+
+ @Transactional(rollbackFor = Exception.class)
+ public void update(SaveRequest input) {
+ KnowledgeDO existing = input == null || input.getId() == null ? null : knowledgeMapper.selectById(input.getId());
+ if (existing == null || !Integer.valueOf(0).equals(existing.getStatus())) {
+ throw invalidParamException("鐭ヨ瘑涓嶅瓨鍦ㄦ垨涓嶆槸鍙紪杈戠殑鑽夌");
+ }
+ validate(input);
+ if (!existing.getCode().equals(input.getCode().trim())) throw invalidParamException("鐭ヨ瘑缂栫爜涓嶅彲淇敼");
+ var update = new LambdaUpdateWrapper<KnowledgeDO>()
+ .eq(KnowledgeDO::getId, existing.getId()).eq(KnowledgeDO::getStatus, 0)
+ .set(KnowledgeDO::getName, input.getName().trim())
+ .set(KnowledgeDO::getProductItemId, input.getProductItemId()).set(KnowledgeDO::getBomId, input.getBomId())
+ .set(KnowledgeDO::getVoltageMin, input.getVoltageMin()).set(KnowledgeDO::getVoltageMax, input.getVoltageMax())
+ .set(KnowledgeDO::getMarket, input.getMarket()).set(KnowledgeDO::getRouteId, input.getRouteId())
+ .set(KnowledgeDO::getTemplateId, input.getTemplateId()).set(KnowledgeDO::getDescription, input.getDescription());
+ if (knowledgeMapper.update(null, update) != 1) throw invalidParamException("鐭ヨ瘑鐘舵�佸凡鍙樺寲锛岃鍒锋柊鍚庨噸璇�");
+ if (input.getStandards() != null) {
+ standardMapper.delete(new LambdaQueryWrapperX<KnowledgeStandardDO>().eq(KnowledgeStandardDO::getKnowledgeId, existing.getId()));
+ saveStandards(existing.getId(), input.getStandards());
+ }
+ if (input.getResources() != null) {
+ resourceMapper.delete(new LambdaQueryWrapperX<KnowledgeResourceDO>().eq(KnowledgeResourceDO::getKnowledgeId, existing.getId()));
+ saveResources(existing.getId(), input.getResources());
+ }
+ }
+
+ @Transactional(rollbackFor = Exception.class)
+ public void publish(Long id) {
+ KnowledgeDO record = id == null ? null : knowledgeMapper.selectById(id);
+ if (record == null || !Integer.valueOf(0).equals(record.getStatus()))
+ throw invalidParamException("鐭ヨ瘑涓嶅瓨鍦ㄦ垨涓嶆槸鑽夌");
+ if (record.getRouteId() == null) throw invalidParamException("鍙戝竷鍓嶈閫夋嫨宸ヨ壓璺嚎");
+ routeService.validateRouteExists(record.getRouteId());
+ if (record.getTemplateId() != null) templateService.validateProcessParamTemplateExists(record.getTemplateId());
+ var update = new LambdaUpdateWrapper<KnowledgeDO>().eq(KnowledgeDO::getId, id)
+ .eq(KnowledgeDO::getStatus, 0).eq(KnowledgeDO::getRouteId, record.getRouteId());
+ if (record.getTemplateId() == null) update.isNull(KnowledgeDO::getTemplateId);
+ else update.eq(KnowledgeDO::getTemplateId, record.getTemplateId());
+ if (knowledgeMapper.update(null, update.set(KnowledgeDO::getStatus, 1)) != 1)
+ throw invalidParamException("鐭ヨ瘑鐘舵�佸凡鍙樺寲锛岃鍒锋柊鍚庨噸璇�");
+ // 鍚屼竴缂栫爜鍙繚鐣欏綋鍓嶅彂甯冪増鏈紝鏃х増浠嶅彲浣滀负寮曠敤蹇収杩芥函銆�
+ knowledgeMapper.update(null, new LambdaUpdateWrapper<KnowledgeDO>()
+ .eq(KnowledgeDO::getCode, record.getCode()).eq(KnowledgeDO::getStatus, 1)
+ .lt(KnowledgeDO::getVersion, record.getVersion()).set(KnowledgeDO::getStatus, 2));
+ }
+
+ @Transactional(rollbackFor = Exception.class)
+ public Long revise(Long id) {
+ KnowledgeDO source = id == null ? null : knowledgeMapper.selectById(id);
+ if (source == null || !Integer.valueOf(1).equals(source.getStatus()))
+ throw invalidParamException("鍙兘浠庡凡鍙戝竷鐨勭煡璇嗗垱寤烘柊鐗堟湰");
+ List<KnowledgeDO> versions = knowledgeMapper.selectList(new LambdaQueryWrapperX<KnowledgeDO>()
+ .eq(KnowledgeDO::getCode, source.getCode()).orderByDesc(KnowledgeDO::getVersion));
+ if (versions.stream().anyMatch(version -> Integer.valueOf(0).equals(version.getStatus())))
+ throw invalidParamException("璇ョ煡璇嗗凡鏈夋湭鍙戝竷鐨勮崏绋跨増鏈�");
+ int nextVersion = versions.stream().map(KnowledgeDO::getVersion).max(Integer::compareTo).orElse(0) + 1;
+ var draft = new KnowledgeDO();
+ draft.setCode(source.getCode()); draft.setVersion(nextVersion); draft.setStatus(0); draft.setName(source.getName());
+ draft.setProductItemId(source.getProductItemId()); draft.setBomId(source.getBomId());
+ draft.setVoltageMin(source.getVoltageMin()); draft.setVoltageMax(source.getVoltageMax()); draft.setMarket(source.getMarket());
+ draft.setRouteId(source.getRouteId()); draft.setTemplateId(source.getTemplateId()); draft.setDescription(source.getDescription());
+ try { knowledgeMapper.insert(draft); }
+ catch (DuplicateKeyException e) { throw invalidParamException("鐗堟湰宸插彉鍖栵紝璇峰埛鏂板悗閲嶈瘯"); }
+ List<String> standards = standardMapper.selectList(new LambdaQueryWrapperX<KnowledgeStandardDO>()
+ .eq(KnowledgeStandardDO::getKnowledgeId, source.getId())).stream().map(KnowledgeStandardDO::getStandardCode).toList();
+ saveStandards(draft.getId(), standards);
+ List<KnowledgeResourceDO> resources = resourceMapper.selectList(new LambdaQueryWrapperX<KnowledgeResourceDO>()
+ .eq(KnowledgeResourceDO::getKnowledgeId, source.getId()));
+ for (KnowledgeResourceDO resource : resources) {
+ var copy = new KnowledgeResourceDO(); copy.setKnowledgeId(draft.getId());
+ copy.setProcessId(resource.getProcessId()); copy.setResourceType(resource.getResourceType());
+ copy.setResourceId(resource.getResourceId()); copy.setCapabilityDescription(resource.getCapabilityDescription());
+ resourceMapper.insert(copy);
+ }
+ return draft.getId();
+ }
+
+ /** 璁板綍鍙傝�冨叧绯伙紝涓嶄慨鏀圭洰鏍囪矾绾挎垨澶嶅埗璺嚎鍐呭銆� */
+ @Transactional(rollbackFor = Exception.class)
+ public void referenceRoute(Long knowledgeId, Long targetRouteId) {
+ if (knowledgeId == null || targetRouteId == null) throw invalidParamException("璇烽�夋嫨鐭ヨ瘑鍙婄洰鏍囧伐鑹鸿矾绾�");
+ KnowledgeDO source = knowledgeMapper.selectOne(new LambdaQueryWrapperX<KnowledgeDO>()
+ .eq(KnowledgeDO::getId, knowledgeId).last("FOR UPDATE"));
+ if (source == null || !Integer.valueOf(1).equals(source.getStatus()))
+ throw invalidParamException("鍙兘鍙傝�冨綋鍓嶅凡鍙戝竷鐨勭煡璇�");
+ routeService.validateRouteExists(targetRouteId);
+ var reference = new KnowledgeReferenceDO(); reference.setKnowledgeId(source.getId());
+ reference.setKnowledgeVersion(source.getVersion()); reference.setTargetType("ROUTE"); reference.setTargetId(targetRouteId);
+ try { referenceMapper.insert(reference); }
+ catch (DuplicateKeyException e) { throw invalidParamException("璇ヨ矾绾垮凡鍙傝�冩鐭ヨ瘑鐗堟湰"); }
+ }
+
+ private void validate(SaveRequest input) {
+ if (input == null || input.getCode() == null || input.getCode().isBlank() || input.getCode().length() > 64
+ || input.getName() == null || input.getName().isBlank() || input.getName().length() > 200)
+ throw invalidParamException("璇峰~鍐欐湁鏁堢殑鐭ヨ瘑缂栫爜鍜屽悕绉�");
+ if (input.getMarket() == null || !Set.of("ALL", "DOMESTIC", "EXPORT").contains(input.getMarket())) throw invalidParamException("鍐呭閿�绫诲瀷涓嶆纭�");
+ if ((input.getVoltageMin() != null && input.getVoltageMin().signum() < 0)
+ || (input.getVoltageMax() != null && input.getVoltageMax().signum() < 0)
+ || (input.getVoltageMin() != null && input.getVoltageMax() != null && input.getVoltageMin().compareTo(input.getVoltageMax()) > 0))
+ throw invalidParamException("鐢靛帇鑼冨洿涓嶆纭�");
+ if (input.getProductItemId() != null) itemService.validateItemExists(input.getProductItemId());
+ if (input.getBomId() != null) {
+ if (input.getProductItemId() == null) throw invalidParamException("閫夋嫨 BOM 鏄庣粏鍓嶈鍏堥�夋嫨閫傜敤鐗╂枡");
+ boolean found = bomService.getProductBomListByItemId(input.getProductItemId()).stream()
+ .anyMatch(bom -> Objects.equals(bom.getItemId(), input.getProductItemId())
+ && Objects.equals(bom.getBomItemId(), input.getBomId()) && Objects.equals(bom.getStatus(), 0));
+ if (!found) throw invalidParamException("鎵�閫� BOM 瀛愮墿鏂欎笉瀛樺湪銆佹湭鍚敤鎴栦笉灞炰簬璇ョ墿鏂�");
+ }
+ if (input.getRouteId() != null) routeService.validateRouteExists(input.getRouteId());
+ if (input.getTemplateId() != null) templateService.validateProcessParamTemplateExists(input.getTemplateId());
+ if (input.getStandards() != null && input.getStandards().stream().anyMatch(s -> s == null || s.isBlank() || s.trim().length() > 128))
+ throw invalidParamException("鏍囧噯缂栫爜涓嶈兘涓虹┖鎴栬秴杩� 128 瀛楃");
+ if (input.getResources() != null) for (ResourceInput resource : input.getResources()) {
+ if (resource == null || resource.getResourceType() == null || !Set.of("MACHINE", "WORKSTATION", "OTHER").contains(resource.getResourceType()))
+ throw invalidParamException("璧勬簮绫诲瀷涓嶆纭�");
+ if (resource.getCapabilityDescription() == null || resource.getCapabilityDescription().isBlank()
+ || resource.getCapabilityDescription().length() > 500) throw invalidParamException("璇峰~鍐欎笉瓒呰繃 500 瀛楃殑璧勬簮鑳藉姏璇存槑");
+ if (resource.getProcessId() != null) processService.validateProcessExists(resource.getProcessId());
+ if ("MACHINE".equals(resource.getResourceType())) {
+ if (resource.getResourceId() == null) throw invalidParamException("璇烽�夋嫨璁惧");
+ machineryService.validateMachineryExists(resource.getResourceId());
+ } else if ("WORKSTATION".equals(resource.getResourceType())) {
+ if (resource.getResourceId() == null) throw invalidParamException("璇烽�夋嫨宸ヤ綔绔�");
+ workstationService.validateWorkstationExists(resource.getResourceId());
+ } else if (resource.getResourceId() != null) throw invalidParamException("鍏朵粬璧勬簮涓嶈兘鎸囧畾璁惧鎴栧伐浣滅珯缂栧彿");
+ }
+ }
+
+ private void copyFields(KnowledgeDO record, SaveRequest input) {
+ record.setName(input.getName().trim()); record.setProductItemId(input.getProductItemId()); record.setBomId(input.getBomId());
+ record.setVoltageMin(input.getVoltageMin()); record.setVoltageMax(input.getVoltageMax()); record.setMarket(input.getMarket());
+ record.setRouteId(input.getRouteId()); record.setTemplateId(input.getTemplateId()); record.setDescription(input.getDescription());
+ }
+
+ private void saveStandards(Long id, List<String> standards) {
+ if (standards == null) return;
+ standards.stream().map(String::trim).distinct().forEach(code -> {
+ var standard = new KnowledgeStandardDO(); standard.setKnowledgeId(id); standard.setStandardCode(code);
+ standardMapper.insert(standard);
+ });
+ }
+
+ private void saveResources(Long id, List<ResourceInput> resources) {
+ if (resources == null) return;
+ for (ResourceInput resource : resources) {
+ var item = new KnowledgeResourceDO(); item.setKnowledgeId(id); item.setProcessId(resource.getProcessId());
+ item.setResourceType(resource.getResourceType()); item.setResourceId(resource.getResourceId());
+ item.setCapabilityDescription(resource.getCapabilityDescription().trim()); resourceMapper.insert(item);
+ }
+ }
+}
--
Gitblit v1.9.3