From bc2cd2ac2e94892bd14f7ab4c157947e42618415 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期一, 02 十一月 2026 11:29:52 +0800
Subject: [PATCH] 采购申请审批详情:补业务附件配置,展示采购申请单
---
docs/sql/cfwj_bpm_purchase_request_attach.sql | 33 +++++++++++++++++++++++++++++++++
1 files changed, 33 insertions(+), 0 deletions(-)
diff --git a/docs/sql/cfwj_bpm_purchase_request_attach.sql b/docs/sql/cfwj_bpm_purchase_request_attach.sql
new file mode 100644
index 0000000..51f2865
--- /dev/null
+++ b/docs/sql/cfwj_bpm_purchase_request_attach.sql
@@ -0,0 +1,33 @@
+-- ============================================================
+-- 璇氬彂浜旈噾锛氶噰璐敵璇峰鎵硅鎯呮樉绀轰笟鍔″崟鎹紙涓氬姟闄勪欢閰嶇疆锛�
+-- 鑳屾櫙锛氶噰璐敵璇风殑瀹℃壒璇︽儏璧� BPM锛屽姩鎬佽〃鍗曞揩鐓т负绌猴紝
+-- 闇�瑕� bpm_business_attach 鍛戒腑娴佺▼瀹氫箟 key锛屽墠绔墠浼氭覆鏌�
+-- 銆岄噰璐敵璇疯鎯呫�嶄笟鍔$粍浠讹紱鍚﹀垯瀹℃壒璇︽儏椤佃〃鍗曞尯鍩熸槸绌虹櫧鐨勩��
+-- 鐜扮姸锛氬簱鍐呴噰璐敵璇峰垎绫讳笅鏈夊涓彲鍙戣捣鐨勫巻鍙叉ā鍨嬶紝key 涓嶆槸鏍囧噯
+-- purchase_request_approve锛堝 C000_abc.锛夛紝鍥犳鍘熼厤缃笉鍛戒腑銆�
+-- 鐩爣搴擄細璇氬彂浜旈噾瀹㈡埛搴擄紙鏈湴涓� CFWJ锛夛紝璇锋寜瀹為檯搴撳悕鎵ц鎴栧厛 USE銆�
+-- 骞傜瓑锛氭寜 process_definition_key + deleted 鍘婚噸锛屽彲閲嶅鎵ц銆�
+-- 娉ㄦ剰锛氭湰鑴氭湰涓嶅惈 tenant_id锛堝崟绉熸埛锛夈��
+-- ============================================================
+
+INSERT INTO `bpm_business_attach`
+(`process_definition_key`, `business_type`, `component_path`, `status`, `remark`, `creator`)
+SELECT k.`process_definition_key`, 'erp_purchase_request',
+ '/erp/purchase/request/detail/index.vue', 0, '閲囪喘鐢宠瀹℃壒璇︽儏', '1'
+FROM (
+ SELECT 'purchase_request_approve' AS `process_definition_key`
+ UNION ALL SELECT 'C000_abc.'
+ UNION ALL SELECT 'D200_abc.'
+ UNION ALL SELECT 'E000_abc.'
+ UNION ALL SELECT 'purchase_approve'
+ UNION ALL SELECT 'pus'
+) k
+WHERE NOT EXISTS (
+ SELECT 1 FROM `bpm_business_attach` a
+ WHERE a.`process_definition_key` = k.`process_definition_key` AND a.`deleted` = b'0'
+);
+
+-- 楠岃瘉锛氫互涓� key 閮藉簲鍛戒腑閲囪喘鐢宠璇︽儏缁勪欢
+-- SELECT process_definition_key, business_type, component_path, status
+-- FROM bpm_business_attach
+-- WHERE process_definition_key IN ('purchase_request_approve', 'C000_abc.', 'D200_abc.', 'E000_abc.');
--
Gitblit v1.9.3