From 298e948226a6773c5432f490f68c671af80dfc16 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期三, 14 十月 2026 09:29:28 +0800
Subject: [PATCH] feat(crm-invoice): 新增开票Excel批量导入功能
---
docs/project-business/index.html | 44 +++++++++++++++++++++++++++++++++-----------
1 files changed, 33 insertions(+), 11 deletions(-)
diff --git a/docs/project-business/index.html b/docs/project-business/index.html
index 2e5d350..7d73b1e 100644
--- a/docs/project-business/index.html
+++ b/docs/project-business/index.html
@@ -341,7 +341,7 @@
{"key": "crm", "name": "閿�鍞鐞嗭紙瀹㈡埛鍏崇郴锛�", "color": "#4f9cff", "tag": "CRM", "flow": "sales",
"positioning": "閿�鍞墠绔細浠庣嚎绱㈠埌鍥炴鐨勫鎴风粡钀�",
"problem": "瀹㈡埛璧勪骇娌夋穩銆佸晢鏈鸿浆鍖栥�佸悎鍚屽鎵逛笌寮�绁ㄥ洖娆剧鎺�",
- "features": ["绾跨储杞寲瀹㈡埛", "鍏捣姹犱笌棰嗗彇涓婇檺", "鑱旂郴浜�", "鍟嗘満鑷畾涔夐樁娈�(鐘舵�佺粍閫夊～)", "璺熻繘璁板綍", "鎶ヤ环鍗�(AI OCR)", "鍚堝悓(BPM瀹℃壒鈫掔敓鎴愰攢鍞鍗�)", "寮�绁�(BPM)鈫掑洖娆�(鍏堝紑绁ㄦ牎楠�)", "鍥炴璁″垝", "閿�鍞洰鏍�", "鏁版嵁鏉冮檺涓夌骇(璐熻矗浜�/鍙/璇诲啓)"],
+ "features": ["绾跨储杞寲瀹㈡埛", "鍏捣姹犱笌棰嗗彇涓婇檺", "鑱旂郴浜�", "鍟嗘満鑷畾涔夐樁娈�(鐘舵�佺粍閫夊～)", "璺熻繘璁板綍", "鎶ヤ环鍗�(AI OCR)", "鍚堝悓(BPM瀹℃壒鈫掔敓鎴愰攢鍞鍗�)", "寮�绁�(BPM瀹℃壒路鏀寔Excel鎵归噺瀵煎叆)鈫掑洖娆�(鍏堝紑绁ㄦ牎楠�)", "鍥炴璁″垝", "閿�鍞洰鏍�", "鏁版嵁鏉冮檺涓夌骇(璐熻矗浜�/鍙/璇诲啓)"],
"objects": ["绾跨储", "瀹㈡埛", "鑱旂郴浜�", "鍟嗘満", "鎶ヤ环鍗�", "鍚堝悓", "鍙戠エ", "鍥炴", "閿�鍞洰鏍�"],
"roles": ["閿�鍞唴鍕�", "閿�鍞粡鐞�", "璐㈠姟(寮�绁ㄥ洖娆�)"],
"upstream": ["涓绘暟鎹�(鐗╂枡)"], "downstream": ["杩涢攢瀛�(閿�鍞鍗�)", "鍞悗(瀹㈡埛)", "AI(鎶ヤ环OCR)"],
@@ -381,8 +381,8 @@
{"key": "qc", "name": "璐ㄩ噺绠＄悊", "color": "#e06c6c", "tag": "MES-QC", "flow": "quality",
"positioning": "鍥涢亾妫�楠岄椄鍙� + 涓嶅悎鏍煎搧闂幆澶勭疆",
"problem": "鏉ユ枡/杩囩▼/鍑鸿揣/閫�璐ф楠屾爣鍑嗗寲锛屼笉鍚堟牸鍙拷婧缃�",
- "features": ["IQC 鏉ユ枡(鍒拌揣/澶栧崗)", "IPQC 杩囩▼(鑱斿姩鎶ュ伐)", "OQC 鍑鸿揣(鑱斿姩閿�鍞嚭搴�)", "RQC 閫�璐�(鑱斿姩閫�鏂�/鍞悗)", "璐ㄦ鏂规路鎸囨爣路缂洪櫡搴�", "妫�娴嬬粨鏋�:IQC/IPQC/RQC 鍚堟牸路鐗归噰路閫�璐锋姤搴� / OQC 1鍨嬄�2鍨嬄峰簾鍝�", "NCR:璇勫鈫掑缃�(閫�璐�/鎶ュ簾/杩斿伐/璁╂/闄嶇骇)鈫掑叧闂�", "AI 鍒ゅ畾寤鸿"],
- "objects": ["IQC", "IPQC", "OQC", "RQC", "璐ㄦ鏂规", "NCR", "缂洪櫡璁板綍"],
+ "features": ["IQC 鏉ユ枡(鍒拌揣/澶栧崗)", "IPQC 杩囩▼(鑱斿姩鎶ュ伐)", "OQC 鍑鸿揣(鑱斿姩閿�鍞嚭搴�)", "RQC 閫�璐�(鑱斿姩閫�鏂�/鍞悗)", "璐ㄦ鏂规路鎸囨爣路缂洪櫡搴�", "妫�娴嬬粨鏋�:IQC/IPQC/RQC 鍚堟牸路鐗归噰路閫�璐锋姤搴� / OQC 1鍨嬄�2鍨嬄峰簾鍝�", "NCR:璇勫鈫掑缃�(閫�璐�/鎶ュ簾/杩斿伐/璁╂/闄嶇骇)鈫掑叧闂�", "Excel鎵归噺瀵煎叆(IQC/IPQC/OQC 鍚勪竴涓叆鍙Ｂ烽�愯瀵煎叆澶辫触琛屼簰涓嶅奖鍝�)", "妫�娴嬬粨鏋滃彴璐�(璺ㄥ洓绫绘楠屽崟缁熶竴鏌ヨ涓庡鍑�)", "AI 鍒ゅ畾寤鸿"],
+ "objects": ["IQC", "IPQC", "OQC", "RQC", "璐ㄦ鏂规", "NCR", "缂洪櫡璁板綍", "妫�娴嬬粨鏋滃彴璐�"],
"roles": ["璐ㄦ鍛�(IQC/IPQC/OQC)", "璐ㄩ噺宸ョ▼甯�"],
"upstream": ["浠撳偍(鍒拌揣)", "鐢熶骇(鎶ュ伐)", "閿�鍞�(鍑哄簱)", "鍞悗(閫�璐�)"], "downstream": ["浠撳偍(鍚堟牸鍏ュ簱/鎶ュ簾鍑哄簱)", "鐢熶骇(NCR杩斿伐)"],
"coreTables": ["mes_qc_iqc", "mes_qc_ipqc", "mes_qc_oqc", "mes_qc_rqc", "mes_qc_template", "mes_qc_indicator", "mes_qc_defect", "mes_qc_ncr"]},
@@ -443,7 +443,7 @@
{"name": "鍟嗘満", "module": "閿�鍞鐞�", "table": "crm_business", "doc": "閿�鍞満浼氾紝DB 閰嶇疆寮忛樁娈垫帹杩涳紙鍟嗘満鐘舵�佺粍/闃舵涓洪�夊～锛氫笉閫夌姸鎬佺粍涔熻兘寤哄崟锛屾鏃舵棤榛樿闃舵銆佷笉鍙彉鏇撮樁娈点�佷笉鍙備笌鐘舵�佺粍缁熻锛夛紝缁撴潫鎬�: 璧�/杈�/鏃犳晥", "upstream": ["瀹㈡埛"], "downstream": ["鎶ヤ环鍗�", "鍚堝悓"], "keywords": "鍟嗘満 business 璧㈠崟 杈撳崟 闃舵 鐘舵�佺粍"},
{"name": "鎶ヤ环鍗�", "module": "閿�鍞鐞�", "table": "crm_sale_quotation", "doc": "QT缂栧彿锛岄�� MDM 鐗╂枡鎶ヤ环锛孉I OCR 褰曞叆锛岃崏绋库啋宸茶浆鍚堝悓", "upstream": ["鍟嗘満"], "downstream": ["鍚堝悓"], "keywords": "鎶ヤ环 quotation QT"},
{"name": "鍚堝悓", "module": "閿�鍞鐞�", "table": "crm_contract", "doc": "HT缂栧彿(鏂板/缂栬緫鍧囧彲鑷畾涔夛紝鐣欑┖鍒欐柊澧炶嚜鍔ㄧ敓鎴愩�佺紪杈戜繚鎸佸師缂栧彿)锛孊PM 瀹℃壒(0鑽夌/10瀹℃壒涓�/20閫氳繃/30椹冲洖/40鍙栨秷/50浣滃簾)锛岄�氳繃鍚庡彲鐢熸垚閿�鍞鍗�", "upstream": ["鎶ヤ环鍗�"], "downstream": ["閿�鍞鍗�", "鍥炴璁″垝", "寮�绁�"], "keywords": "鍚堝悓 contract 瀹℃壒"},
- {"name": "鍙戠エ", "module": "閿�鍞鐞�", "table": "crm_invoice", "doc": "KP缂栧彿锛孊PM 瀹℃壒锛岀疮璁″紑绁ㄢ墹鍚堝悓棰濓紝闄勪欢蹇呬紶", "upstream": ["鍚堝悓"], "downstream": ["鍥炴"], "keywords": "寮�绁� 鍙戠エ invoice"},
+ {"name": "鍙戠エ", "module": "閿�鍞鐞�", "table": "crm_invoice", "doc": "KP缂栧彿锛孊PM 瀹℃壒锛岀疮璁″紑绁ㄢ墹鍚堝悓棰濓紝闄勪欢蹇呬紶锛涙敮鎸� Excel 鎵归噺瀵煎叆锛堝悓涓�鍚堝悓涓嬪悓鍙戠エ鍙风爜銆佹垨鍚屻�岄噾棰�+鎶ご+寮�绁ㄦ棩鏈熴�嶇殑琛屽垽閲嶅骞舵嫆鏀讹紝閫愯鍥炴樉澶辫触鍘熷洜锛�", "upstream": ["鍚堝悓"], "downstream": ["鍥炴"], "keywords": "寮�绁� 鍙戠エ invoice 瀵煎叆"},
{"name": "鍥炴", "module": "閿�鍞鐞�", "table": "crm_receivable", "doc": "HK缂栧彿锛屽垱寤哄嵆瀹℃壒涓�(鎵嬪姩瀹℃牳)锛屽己鍒跺厛寮�绁紝閲戦鍙屾牎楠�", "upstream": ["鍚堝悓", "鍙戠エ"], "downstream": ["鏀舵鍗�(鍏宠仈)"], "keywords": "鍥炴 鏀舵璁″垝 receivable"},
{"name": "閿�鍞洰鏍�", "module": "閿�鍞鐞�", "table": "crm_sales_target", "doc": "骞�/瀛�/鏈埫椾釜浜�/閮ㄩ棬/浜у搧缁村害鐨勫悎鍚屽洖娆剧瓑鐩爣", "upstream": [], "downstream": ["涓氱哗缁熻"], "keywords": "鐩爣 target 涓氱哗"},
{"name": "渚涘簲鍟�", "module": "渚涘簲鍟嗙鐞�", "table": "srm_supplier", "doc": "渚涘簲鍟嗘。妗堬細鎵х収/绋庡彿/閾惰/鑱旂郴浜猴紝ERP 涓� MES 鍏辩敤", "upstream": ["鍑嗗叆鐢宠"], "downstream": ["閲囪喘璁㈠崟", "鍒拌揣閫氱煡", "渚涘簲鍟嗛��璐�", "缁╂晥璇勪环"], "keywords": "渚涘簲鍟� supplier vendor"},
@@ -470,10 +470,11 @@
{"name": "鐩樼偣浠诲姟", "module": "浠撳偍", "table": "mes_wm_stock_taking_task", "doc": "闈欐��/鍔ㄦ�佺洏鐐癸紝琛岀粨鏋�:姝ｅ父/鐩樼泩(ADJUST_IN)/鐩樹簭(ADJUST_OUT)锛屽彲鍐荤粨搴撳瓨銆佺洸鐩�", "upstream": ["搴撳瓨鍙拌处"], "downstream": ["搴撳瓨鍙拌处(璋冩暣)"], "keywords": "鐩樼偣 鐩樼泩 鐩樹簭 stock taking"},
{"name": "搴撳瓨鍙拌处", "module": "浠撳偍", "table": "mes_wm_material_stock", "doc": "鐗╂枡脳浠撳簱脳搴撳尯脳搴撲綅脳鎵规脳渚涘簲鍟嗗叚鍏冪粍锛屾暟閲�/鍐荤粨/鍗犵敤/鍦ㄩ�斿洓閲�", "upstream": ["鍏ㄩ儴鍏ュ簱鍗�"], "downstream": ["鍏ㄩ儴鍑哄簱鍗�", "浜嬪姟娴佹按"], "keywords": "搴撳瓨 鍙拌处 stock 鍙敤閲�"},
{"name": "鎵规", "module": "浠撳偍", "table": "mes_wm_batch", "doc": "鍏宠仈鐗╂枡/宸ュ崟/渚涘簲鍟�/瀹㈡埛/璐ㄩ噺鐘舵�侊紱SN 鐮佸惈鎵规 uuid锛涙潯鐮佹敮鎸�18绉嶄笟鍔″璞�", "upstream": ["鍏ュ簱鍗曟嵁"], "downstream": ["搴撳瓨鍙拌处"], "keywords": "鎵规 batch SN 鏉＄爜 杩芥函"},
- {"name": "IQC鏉ユ枡妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_iqc", "doc": "鍒拌揣閫氱煡/澶栧崗鍏ュ簱瑙﹀彂锛岃崏绋�0鈫掑畬鎴�4锛岀粨璁哄洖鍐欐潵婧愬崟鎹�", "upstream": ["鍒拌揣閫氱煡", "澶栧崗鍏ュ簱"], "downstream": ["閲囪喘鍏ュ簱", "渚涘簲鍟嗛��璐�", "NCR"], "keywords": "IQC 鏉ユ枡妫�楠�"},
- {"name": "IPQC杩囩▼妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_ipqc", "doc": "鎶ュ伐璐ㄦ宸ュ簭浜у嚭琛岃Е鍙戯紝瀹屾垚鍥炶皟鎺ㄨ繘鎶ュ伐涓庝骇鍑哄叆搴擄紱琛ㄥご=鏉ユ簮鍗曟嵁(鍙)+浜у搧鐗╂枡(MDM,蹇呭～)+鎵瑰彿(蹇呭～)+鏁伴噺+妫�楠屼俊鎭紝宸插幓鎺夌敓浜ц鍗�/宸ヤ綅/鐢熶骇浠诲姟/宸ュ簭", "upstream": ["鎶ュ伐"], "downstream": ["浜у嚭鍏ュ簱", "NCR"], "keywords": "IPQC 杩囩▼妫�楠� 宸℃ 鎵瑰彿"},
- {"name": "OQC鍑鸿揣妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_oqc", "doc": "閿�鍞嚭搴撴彁浜よЕ鍙戯紝鑽夌0鈫掑畬鎴�4锛涙娴嬬粨鏋滄寜浜у搧绛夌骇鍒ゅ畾(1鍨�/2鍨�/搴熷搧锛屽繀濉�)锛�1鍨�/2鍨嬪垽琛屽悎鏍煎苟鎺ㄨ繘鍑哄簱鍗曞緟鎷ｈ揣锛屽簾鍝佸垽琛屼笉鍚堟牸骞跺彇娑堥攢鍞嚭搴撳崟锛涘彂璐ф暟閲�/鍑鸿揣鏃ユ湡鍙┖", "upstream": ["閿�鍞嚭搴撳崟"], "downstream": ["閿�鍞嚭搴撳崟(鎺ㄨ繘鎴栧彇娑�)"], "keywords": "OQC 鍑鸿揣妫�楠� 鍑哄巶妫�楠� 1鍨� 2鍨� 搴熷搧"},
- {"name": "RQC閫�璐ф楠�", "module": "璐ㄩ噺", "table": "mes_qc_rqc", "doc": "鐢熶骇閫�鏂�/閿�鍞��璐�/鍞悗閫�璐цЕ鍙戯紝缁撹鍥炶皟鍞悗锛涘洓绫绘楠屽崟鍧囨敮鎸侀噰鏍峰湴鐐�/璇佷功缂栧彿/鎵ц鏍囧噯琛ㄥご涓庡鏍嘎峰鏍镐汉锛屽苟鍙墦鍗版楠屾姤鍛�", "upstream": ["閫�鏂�", "閫�璐�"], "downstream": ["閫�璐у叆搴�", "鍞悗鍥炶皟", "妫�楠屾姤鍛婃墦鍗�"], "keywords": "RQC 閫�璐ф楠�"},
+ {"name": "IQC鏉ユ枡妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_iqc", "doc": "鍒拌揣閫氱煡/澶栧崗鍏ュ簱瑙﹀彂锛岃崏绋�0鈫掑畬鎴�4锛岀粨璁哄洖鍐欐潵婧愬崟鎹紱鍙︽敮鎸� Excel 鎵归噺瀵煎叆锛堢墿鏂欐寜缂栫爜銆佷緵搴斿晢鎸夊悕绉扮簿纭尮閰嶏紝渚涘簲鍟�/渚涘簲鍟嗘壒娆�/鏉ユ枡鏃ユ湡鍙備笌鍘婚噸锛夛紝瀵煎叆鍗曠洿鎺ヨ惤寰呮楠屻�佷笉鍥炲啓鏉ユ簮鍗曟嵁", "upstream": ["鍒拌揣閫氱煡", "澶栧崗鍏ュ簱"], "downstream": ["閲囪喘鍏ュ簱", "渚涘簲鍟嗛��璐�", "NCR", "妫�娴嬬粨鏋滃彴璐�"], "keywords": "IQC 鏉ユ枡妫�楠� 瀵煎叆"},
+ {"name": "IPQC杩囩▼妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_ipqc", "doc": "鎶ュ伐璐ㄦ宸ュ簭浜у嚭琛岃Е鍙戯紝瀹屾垚鍥炶皟鎺ㄨ繘鎶ュ伐涓庝骇鍑哄叆搴擄紱琛ㄥご=鏉ユ簮鍗曟嵁(鍙)+浜у搧鐗╂枡(MDM,蹇呭～)+鎵瑰彿(蹇呭～)+鏁伴噺+妫�楠屼俊鎭紝宸插幓鎺夌敓浜ц鍗�/宸ヤ綅/鐢熶骇浠诲姟/宸ュ簭锛涘彟鏀寔 Excel 鎵归噺瀵煎叆锛堢墿鏂欑紪鐮�+鎵瑰彿+妫�楠岀被鍨�+妫�娴嬫棩鏈熷弬涓庡幓閲嶏紝宸ュ簾+鏂欏簾+鍏朵粬搴熷搧 涓嶅緱瓒呰繃涓嶅悎鏍煎搧鏁伴噺锛夛紝瀵煎叆鍗曠洿鎺ヨ惤寰呮楠�", "upstream": ["鎶ュ伐"], "downstream": ["浜у嚭鍏ュ簱", "NCR", "妫�娴嬬粨鏋滃彴璐�"], "keywords": "IPQC 杩囩▼妫�楠� 宸℃ 鎵瑰彿 瀵煎叆"},
+ {"name": "OQC鍑鸿揣妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_oqc", "doc": "閿�鍞嚭搴撴彁浜よЕ鍙戯紝鑽夌0鈫掑畬鎴�4锛涙娴嬬粨鏋滄寜浜у搧绛夌骇鍒ゅ畾(1鍨�/2鍨�/搴熷搧锛屽繀濉�)锛�1鍨�/2鍨嬪垽琛屽悎鏍煎苟鎺ㄨ繘鍑哄簱鍗曞緟鎷ｈ揣锛屽簾鍝佸垽琛屼笉鍚堟牸骞跺彇娑堥攢鍞嚭搴撳崟锛涘彂璐ф暟閲�/鍑鸿揣鏃ユ湡鍙┖锛涘彟鏀寔 Excel 鎵归噺瀵煎叆锛堢墿鏂欐寜缂栫爜銆佸鎴锋寜鍚嶇О鍖归厤骞舵牎楠屽湪鏈汉鏁版嵁鏉冮檺鍐咃紝鐗╂枡+瀹㈡埛+鎵规鍙�+鍑鸿揣鏃ユ湡鍙備笌鍘婚噸锛夛紝瀵煎叆鍗曠洿鎺ヨ惤寰呮楠屻�佷笉鎺ㄨ繘鎴栧彇娑堥攢鍞嚭搴撳崟", "upstream": ["閿�鍞嚭搴撳崟"], "downstream": ["閿�鍞嚭搴撳崟(鎺ㄨ繘鎴栧彇娑�)", "妫�娴嬬粨鏋滃彴璐�"], "keywords": "OQC 鍑鸿揣妫�楠� 鍑哄巶妫�楠� 1鍨� 2鍨� 搴熷搧 瀵煎叆"},
+ {"name": "RQC閫�璐ф楠�", "module": "璐ㄩ噺", "table": "mes_qc_rqc", "doc": "鐢熶骇閫�鏂�/閿�鍞��璐�/鍞悗閫�璐цЕ鍙戯紝缁撹鍥炶皟鍞悗锛涘洓绫绘楠屽崟鍧囨敮鎸侀噰鏍峰湴鐐�/璇佷功缂栧彿/鎵ц鏍囧噯琛ㄥご涓庡鏍嘎峰鏍镐汉锛屽苟鍙墦鍗版楠屾姤鍛�", "upstream": ["閫�鏂�", "閫�璐�"], "downstream": ["閫�璐у叆搴�", "鍞悗鍥炶皟", "妫�楠屾姤鍛婃墦鍗�", "妫�娴嬬粨鏋滃彴璐�"], "keywords": "RQC 閫�璐ф楠�"},
+ {"name": "妫�娴嬬粨鏋滃彴璐�", "module": "璐ㄩ噺", "table": "mes_qc_iqc / mes_qc_ipqc / mes_qc_oqc / mes_qc_rqc (UNION ALL)", "doc": "鍥涚被妫�楠屽崟缁熶竴鏌ヨ瑙嗗浘锛屼竴琛屼竴涓娴嬮」(妫�楠屽崟鏈綍妫�娴嬮」鏃惰缁勫瓧娈电暀绌轰絾淇濈暀琛屻�佷笉婕忓崟)锛涘垽瀹氫緷鎹敱鏍囧噯鍊间笌涓婁笅闄愭嫾瑁咃紝绛涢�変笌鍒楄〃鍏辩敤鍚屼竴濂楁潯浠跺苟鍙鍑� Excel锛屽彧璇婚〉涓嶆彁渚涘鍒犳敼", "upstream": ["IQC鏉ユ枡妫�楠�", "IPQC杩囩▼妫�楠�", "OQC鍑鸿揣妫�楠�", "RQC閫�璐ф楠�"], "downstream": ["鍙拌处瀵煎嚭"], "keywords": "鍙拌处 妫�娴嬬粨鏋� ledger 缁熶竴鏌ヨ 瀵煎嚭"},
{"name": "妫�楠屾寚鏍�", "module": "璐ㄩ噺", "table": "mes_qc_indicator", "doc": "鏀寔涓ょ骇鍒嗙粍鏍�(itemType褰曞叆/鍒嗙粍+parentId)銆佸叕寮忔枃鏈睍绀恒�佸崟浣嶆枃鏈�佸悓绾ф帓搴忥紱鍒嗙粍椤逛笉褰曞�硷紱鏈夊瓙椤圭鍒狅紱鍚屽眰绾у悕绉板彲閲嶅", "upstream": [], "downstream": ["璐ㄦ鏂规", "妫�楠屾姤鍛婃墦鍗�"], "keywords": "妫�楠屾寚鏍� indicator 鍒嗙粍 鍏紡 鍖栧伐"},
{"name": "妫�楠屾姤鍛婃墦鍗�", "module": "璐ㄩ噺", "table": "mes_qc_indicator_result_detail", "doc": "鍖栧伐鎶ュ憡鑼冨紡锛氬钩琛屾祴閲忔壒娆�(measure_no)+鍒嗙粍鐭╅樀+鍏紡鍒�+绛惧瓧鍖猴紱/mes/qc/indicator-result/report 鑱氬悎锛屽墠绔祻瑙堝櫒鎵撳嵃", "upstream": ["IQC鏉ユ枡妫�楠�", "IPQC杩囩▼妫�楠�", "OQC鍑鸿揣妫�楠�", "RQC閫�璐ф楠�", "妫�楠屾寚鏍�"], "downstream": [], "keywords": "鎵撳嵃 鎶ュ憡 娴嬮噺鎵规 绛惧瓧 姝ｄ竵閱� GB/T6027"},
{"name": "NCR涓嶅悎鏍煎搧", "module": "璐ㄩ噺", "table": "mes_qc_ncr", "doc": "寰呰瘎瀹�0鈫掑凡璇勫6鈫掑凡澶勭疆7鈫掑凡鍏抽棴8锛屽缃�:閫�璐�/鎶ュ簾/杩斿伐/璁╂鎺ユ敹/闄嶇骇", "upstream": ["IQC/IPQC/OQC/RQC"], "downstream": ["閫�璐�/鎶ュ簾/杩斿伐(鍙拌处)"], "keywords": "NCR 涓嶅悎鏍� 澶勭疆 鐗归噰 鎶ュ簾"},
@@ -488,14 +489,14 @@
<script type="application/json" id="data-flows">{
"flows": [
{"id": "sales", "name": "閿�鍞祦绋�", "mermaid": "mermaid/02-sales-flow.mmd", "color": "#4f9cff",
- "summary": "绾跨储杞寲瀹㈡埛 鈫� 鍟嗘満鎺ㄨ繘 鈫� 鎶ヤ环(鍙疉I璇嗗埆) 鈫� 鍚堝悓 BPM 瀹℃壒 鈫� 鐢熸垚 ERP 閿�鍞鍗曞苟瀹℃壒 鈫� 闇�鐢熶骇琛岃嚜鍔ㄥ缓 MPS 鈫� 鍙戣揣閫氱煡 鈫� 閿�鍞嚭搴�(OQC)鍥炲啓 鈫� 寮�绁�(BPM) 鈫� 鍥炴(鍏堝紑绁ㄦ牎楠�)銆�",
+ "summary": "绾跨储杞寲瀹㈡埛 鈫� 鍟嗘満鎺ㄨ繘 鈫� 鎶ヤ环(鍙疉I璇嗗埆) 鈫� 鍚堝悓 BPM 瀹℃壒 鈫� 鐢熸垚 ERP 閿�鍞鍗曞苟瀹℃壒 鈫� 闇�鐢熶骇琛岃嚜鍔ㄥ缓 MPS 鈫� 鍙戣揣閫氱煡 鈫� 閿�鍞嚭搴�(OQC)鍥炲啓 鈫� 寮�绁�(BPM瀹℃壒路鏀寔Excel鎵归噺瀵煎叆) 鈫� 鍥炴(鍏堝紑绁ㄦ牎楠�)銆�",
"steps": [
{"stage": "鑾峰", "action": "绾跨储杞寲瀹㈡埛銆佸缓鑱旂郴浜恒�佺珛椤瑰晢鏈猴紙鍟嗘満鐘舵�佺粍/闃舵閫夊～锛屼笉閫変篃鑳藉缓鍗曪級", "roles": ["閿�鍞唴鍕�"]},
{"stage": "鎶ヤ环", "action": "鍟嗘満璧㈠崟鍚庡缓鎶ヤ环鍗�(AI OCR 棰勫～)锛岃浆鍚堝悓", "roles": ["閿�鍞唴鍕�"]},
{"stage": "绛剧害", "action": "鍚堝悓鎻愪氦 BPM 瀹℃壒(鍙�夋祦绋嬪畾涔�)锛岄�氳繃=20", "roles": ["閿�鍞�", "瀹℃壒浜�"]},
{"stage": "鎺ュ崟", "action": "鍚堝悓涓�閿敓鎴愰攢鍞鍗�(XSDD)锛岄攢鍞鍗曞啀璧� BPM锛涘鎵归�氳繃鑷姩涓� needProduction 鏄庣粏鍒涘缓 MPS", "roles": ["閿�鍞�", "璁″垝鍛�"]},
{"stage": "浜や粯", "action": "鍙戣揣閫氱煡瀹℃牳(鍗犵敤)鈫� 閿�鍞嚭搴� OQC 鈫� 鍙戣繍 鈫� 鍑哄簱鍥炲啓閮ㄥ垎/鍏ㄩ儴鍑哄簱", "roles": ["浠撶", "璐ㄦ"]},
- {"stage": "鍥炴", "action": "寮�绁� BPM(绱鈮ゅ悎鍚岄) 鈫� 鍥炴寮哄埗鍏堝紑绁�(绱鈮ゅ悎鍚屽墿浣欎笌寮�绁ㄥ墿浣�)", "roles": ["璐㈠姟", "閿�鍞�"]}]},
+ {"stage": "鍥炴", "action": "寮�绁� BPM(绱鈮ゅ悎鍚岄锛涙敮鎸� Excel 鎵归噺瀵煎叆锛屽悓涓�鍚堝悓涓嬪悓鍙戠エ鍙风爜鎴栧悓銆岄噾棰�+鎶ご+寮�绁ㄦ棩鏈熴�嶇殑琛屽垽涓洪噸澶嶅苟鎷掓敹锛岄�愯鍥炴樉澶辫触鍘熷洜) 鈫� 鍥炴寮哄埗鍏堝紑绁�(绱鈮ゅ悎鍚屽墿浣欎笌寮�绁ㄥ墿浣�)", "roles": ["璐㈠姟", "閿�鍞�"]}]},
{"id": "purchase", "name": "閲囪喘娴佺▼", "mermaid": "mermaid/03-purchase-flow.mmd", "color": "#5fc79e",
"summary": "SRM 鍑嗗叆/瀹氭爣渚涙簮 鈫� 閲囪喘鐢宠 BPM 鈫� 閲囪喘璁㈠崟 BPM 鈫� 纭鏀惰揣鐢熸垚 MES 鍒拌揣閫氱煡 鈫� IQC(鍚堟牸/鐗归噰鍏ュ簱路閫�璐�/鎶ュ簾) 鈫� 閲囪喘鍏ュ簱鍥炲啓璁㈠崟涓庣敵璇� 鈫� 鏉ョエ(AI OCR) 鈫� 浠樻鍗� BPM銆�",
"steps": [
@@ -516,13 +517,15 @@
{"stage": "鑱斿姩", "action": "瀹℃壒閫氳繃鎸夊伐搴忔爣璁�: 鍊掑啿鈫掕嚜鍔ㄧ墿鏂欐秷鑰楁墸绾胯竟搴�(鍏佽璐熷簱瀛�)锛涜川妫�鈫掍骇鍑哄緟妫�琛岀瓑 IPQC锛涘叧閿潪妫�鈫掔洿鎺ヤ骇鍑哄叆搴�", "roles": ["绯荤粺鑷姩"]},
{"stage": "瀹屽伐", "action": "浠呮湯閬撳伐搴忓洖鍐欏伐鍗曞凡鐢熶骇鏁伴噺锛岃揪鏍囪嚜鍔ㄥ畬鎴愶紱MPS 绱鍒ゆ柇瀹屾垚骞跺彂浜嬩欢缁欓攢鍞鍗�", "roles": ["绯荤粺鑷姩"]}]},
{"id": "quality", "name": "璐ㄩ噺娴佺▼", "mermaid": "mermaid/05-quality-flow.mmd", "color": "#e06c6c",
- "summary": "鍥涢亾妫�楠岄椄鍙�(IQC/IPQC/OQC/RQC锛屼簩鎬� 0鈫�4) + 鍒ゅ畾鍥涙灉(鍚堟牸/鐗归噰/閫�璐�/鎶ュ簾锛汷QC 鏀规寜浜у搧绛夌骇 1鍨�/2鍨�/搴熷搧锛屼粎搴熷搧鍒や笉鍚堟牸) + NCR 璇勫澶勭疆鍏抽棴锛汚I 鎻愪緵鍒ゅ畾寤鸿锛汵CR 褰撳墠浠呭彴璐︿笉瑙﹀彂杩斿伐鍗曘�傛敮鎸佸寲宸ユ姤鍛婅寖寮忥細鍒嗙粍鎸囨爣鏍�+鍏紡鏂囨湰+骞宠娴嬮噺鎵规+閲囨牱琛ㄥご+绛惧瓧鍖猴紝娴忚鍣ㄦ墦鍗版楠屾姤鍛婏紱骞跺彲瀵煎嚭浜у搧妫�楠屽崟 Word锛堢焊璐ㄦ楠屽崟鐗堝紡锛屽垽瀹氱粨璁哄甫鍑烘楠岀粨鏋溿�佹楠屄峰鏍嘎锋壒鍑嗙瀛楀甫鍑烘娴嬩汉路澶嶆牳浜郝峰鏍镐汉濮撳悕銆佽川妫�绔犵暀绌虹洊绔狅紝Word 鎵撳嵃锛夈��",
+ "summary": "鍥涢亾妫�楠岄椄鍙�(IQC/IPQC/OQC/RQC锛屼簩鎬� 0鈫�4) + 鍒ゅ畾鍥涙灉(鍚堟牸/鐗归噰/閫�璐�/鎶ュ簾锛汷QC 鏀规寜浜у搧绛夌骇 1鍨�/2鍨�/搴熷搧锛屼粎搴熷搧鍒や笉鍚堟牸) + NCR 璇勫澶勭疆鍏抽棴锛汚I 鎻愪緵鍒ゅ畾寤鸿锛汵CR 褰撳墠浠呭彴璐︿笉瑙﹀彂杩斿伐鍗曘�傛敮鎸佸寲宸ユ姤鍛婅寖寮忥細鍒嗙粍鎸囨爣鏍�+鍏紡鏂囨湰+骞宠娴嬮噺鎵规+閲囨牱琛ㄥご+绛惧瓧鍖猴紝娴忚鍣ㄦ墦鍗版楠屾姤鍛婏紱骞跺彲瀵煎嚭浜у搧妫�楠屽崟 Word锛堢焊璐ㄦ楠屽崟鐗堝紡锛屽垽瀹氱粨璁哄甫鍑烘楠岀粨鏋溿�佹楠屄峰鏍嘎锋壒鍑嗙瀛楀甫鍑烘娴嬩汉路澶嶆牳浜郝峰鏍镐汉濮撳悕銆佽川妫�绔犵暀绌虹洊绔狅紝Word 鎵撳嵃锛夈�傚彟鏀寔鍥涚被妫�楠屽崟 Excel 鎵归噺瀵煎叆锛圛QC/IPQC/OQC 鍚勪竴涓叆鍙ｏ紝閫愯瑙ｆ瀽銆佸け璐ヨ浜掍笉褰卞搷锛屽鍏ュ崟涓�寰嬨�屽緟妫�楠屻�嶃�佷笉璧版潵婧愬崟鎹洖鍐欍�佷笉鐢熸垚 NCR锛変笌銆屾娴嬬粨鏋滃彴璐︺�嶏紙璺� IQC/IPQC/OQC/RQC 缁熶竴鏌ヨ涓庡鍑猴紝涓�琛屼竴涓娴嬮」锛夈��",
"steps": [
{"stage": "鏉ユ枡", "action": "鍒拌揣閫氱煡/澶栧崗鍏ュ簱鈫扞QC锛岀粨璁哄洖鍐欐帹杩涘緟鍏ュ簱鎴栬Е鍙戦��璐�", "roles": ["IQC 璐ㄦ鍛�"]},
{"stage": "杩囩▼", "action": "鎶ュ伐璐ㄦ宸ュ簭浜у嚭琛屸啋IPQC锛屽悎鏍兼媶琛屽叆搴撱�佷笉鍚堟牸鐢熸垚 NCR", "roles": ["IPQC 璐ㄦ鍛�"]},
{"stage": "鍑鸿揣", "action": "閿�鍞嚭搴撴彁浜も啋OQC(妫�娴嬬粨鏋滄寜浜у搧绛夌骇 1鍨�/2鍨�/搴熷搧蹇呭～锛�1鍨�/2鍨嬪垽琛屽悎鏍硷紝搴熷搧鍒よ涓嶅悎鏍�)锛屽叏閮ㄥ悎鏍煎悗鍑哄簱鍗曡繘鍏ュ緟鎷ｈ揣锛屽嚭鐜板簾鍝佸垯鏁村崟鍙栨秷", "roles": ["OQC 璐ㄦ鍛�"]},
{"stage": "閫�璐�", "action": "閫�鏂�/閿�鍞��璐�/鍞悗閫�璐р啋RQC锛岀粨璁哄洖璋冨崟鎹笌鍞悗", "roles": ["RQC 璐ㄦ鍛�"]},
{"stage": "鎶ュ憡", "action": "妫�楠岀粨鏋滄寜鍒嗙粍鏍�+娴嬮噺鎵规褰曞叆锛�/indicator-result/report 鑱氬悎鍚庡墠绔墦鍗版楠屾姤鍛�(鍚噰鏍峰湴鐐�/璇佷功缂栧彿/鎵ц鏍囧噯/鍒ゅ畾缁撹路璐ㄦ涓撶敤绔�/澶嶆牳路瀹℃牳绛惧瓧鍖猴紱鍒ゅ畾缁撹甯﹀嚭妫�楠岀粨鏋溌疯川妫�绔犵暀绌虹洊绔犅锋棤骞宠娴嬮噺鏃跺垪澶寸О娴嬮噺鍊�)锛�/indicator-result/export-product-word 瀵煎嚭浜у搧妫�楠屽崟Word(鏃犳妧鏈寚鏍囧垪路鍒ゅ畾缁撹甯﹀嚭妫�楠岀粨鏋溌锋楠屄峰鏍嘎锋壒鍑嗙瀛楀甫鍑烘娴嬩汉/澶嶆牳浜�/瀹℃牳浜哄鍚嵚疯川妫�绔犵暀绌虹洊绔犅峰钩琛屾祴閲忛】鍙峰悎骞堵蜂笅杞藉悗Word鎵撳嵃锛涜川妫�鍗曡鎯呮娴嬬粨鏋淭ab鍙寜鏍峰搧鏌ョ湅鍙妫�娴嬪�兼槑缁�)", "roles": ["璐ㄦ鍛�", "澶嶆牳浜�", "瀹℃牳浜�"]},
+ {"stage": "瀵煎叆", "action": "IQC/IPQC/OQC 涓変釜鍒楄〃鍚勬彁渚涖�屾壒閲忓鍏ャ�嶅叆鍙�(浣嶄簬鏂板涓庡鍑轰箣闂�)锛氫笅杞芥ā鏉库啋涓婁紶 xls/xlsx鈫掗�愯瑙ｆ瀽锛岀墿鏂欐寜缂栫爜銆佷緵搴斿晢/瀹㈡埛鎸夊悕绉扮簿纭尮閰嶏紝璐ㄦ鏂规鐣欑┖鎸夈�岀墿鏂�+妫�楠岀被鍨嬨�嶈嚜鍔ㄥ尮閰嶏紝鍚堟牸鍝�+涓嶅悎鏍煎搧蹇呴』绛変簬妫�娴嬫暟閲�(鐣欑┖鍙栦袱鑰呬箣鍜�)锛涘け璐ヨ杩斿洖琛屽彿涓庡師鍥犱笖涓嶅奖鍝嶆垚鍔熻锛屽鍏ュ崟鐩存帴钀姐�屽緟妫�楠屻�嶏紝涓嶈蛋鏉ユ簮鍗曟嵁鍥炲啓涔熶笉鐢熸垚 NCR", "roles": ["璐ㄦ鍛�"]},
+ {"stage": "鍙拌处", "action": "妫�娴嬬粨鏋滃彴璐︼細瀵� mes_qc_iqc / mes_qc_ipqc / mes_qc_oqc / mes_qc_rqc 鍋� UNION ALL锛屼竴琛屼竴涓娴嬮」(妫�楠屽崟鏈綍妫�娴嬮」鏃惰缁勫瓧娈电暀绌轰絾淇濈暀琛屻�佷笉婕忓崟)锛屽垽瀹氫緷鎹敱鏍囧噯鍊间笌涓婁笅闄愭嫾瑁�(濡� 10~20銆佲墹20)锛涚瓫閫変笌鍒楄〃鍏辩敤鍚屼竴濂楁潯浠跺苟鍙鍑� Excel锛涘彧璇婚〉锛屼笉鎻愪緵澧炲垹鏀�", "roles": ["璐ㄦ鍛�", "璐ㄩ噺宸ョ▼甯�"]},
{"stage": "涓嶅悎鏍�", "action": "NCR: 寰呰瘎瀹♀啋璇勫鈫掑缃�(閫�璐�/鎶ュ簾/杩斿伐/璁╂鎺ユ敹/闄嶇骇)鈫掑叧闂�", "roles": ["璐ㄩ噺宸ョ▼甯�"]}]},
{"id": "warehouse", "name": "浠撳偍娴佺▼", "mermaid": "mermaid/06-warehouse-flow.mmd", "color": "#7e6bd6",
"summary": "15 绫诲崟鎹┍鍔ㄥ簱瀛樺彴璐�(鍏厓缁勩�佸洓閲�)鍙樺姩锛屽叏閮ㄧ粡浜嬪姟娴佹按鐣欑棔锛涙敮鎸佽皟鎷ㄥ湪閫斻�佺洏鐐硅皟鏁淬�佹壒娆�/SN 杩芥函銆佸簱瀛樺崰鐢ㄤ笌鍥涚骇鍐荤粨銆佺嚎杈硅櫄鎷熷簱璐熷簱瀛橈紱瀵瑰 WmsStockApi 渚� ERP 鏀跺彂銆�",
@@ -737,6 +740,25 @@
T2[鎶ュ伐璐ㄦ宸ュ簭閫氳繃鍚庝骇鍑鸿] --> A2[IPQC 杩囩▼妫�楠屄疯崏绋�0鈫掑畬鎴�4]
T3[閿�鍞嚭搴撳崟鎻愪氦] --> A3[OQC 鍑鸿揣妫�楠屄疯崏绋�0鈫掑畬鎴�4]
T4[鐢熶骇閫�鏂欏崟 鎴� 閿�鍞��璐у崟 鎴� 鍞悗閫�璐 --> A4[RQC 閫�璐ф楠屄疯崏绋�0鈫掑畬鎴�4]
+ T5[Excel 鎵归噺瀵煎叆路IQC IPQC OQC 涓夊垪琛ㄥ悇涓�涓叆鍙Ｂ锋寜閽湪鏂板涓庡鍑轰箣闂碷 --> IMP{瀵煎叆闂搁棬路閫愯瑙ｆ瀽路澶辫触琛屼簰涓嶅奖鍝峿
+ IMP -->|缂栧彿鐣欑┖鑷姩鐢熸垚路缂栧彿閲嶅鎴栧悓涓�鎵规暟鎹噸澶嶅垯鎷掕琛寍 A1
+ IMP --> A2
+ IMP --> A3
+ IMP -.->|鍚屼竴鎵规暟鎹笉鍙噸澶嶅鍏ヂ稩QC 鐗╂枡+渚涘簲鍟�+渚涘簲鍟嗘壒娆�+鏉ユ枡鏃ユ湡 / IPQC 鐗╂枡+鎵瑰彿+妫�楠岀被鍨�+妫�娴嬫棩鏈� / OQC 鐗╂枡+瀹㈡埛+鎵规鍙�+鍑鸿揣鏃ユ湡路鏂囦欢鍐呴噸澶嶈涓庡簱鍐呭凡鏈夊崟閮芥嫆骞跺洖鏄惧弻鏂瑰疄闄呭�紎 IMPDUP[瀵煎叆鍘婚噸路鎸変笟鍔￠敭]
+ IMP -.->|鐗╂枡鎸夌紪鐮� 渚涘簲鍟嗕笌瀹㈡埛鎸夊悕绉� 绮剧‘鍖归厤路鏂规鐣欑┖鎸夌墿鏂�+妫�楠岀被鍨嬭嚜鍔ㄥ尮閰峾 IMPR[寮曠敤瑙ｆ瀽路QC_NO_TEMPLATE 琛ョ墿鏂欎笌鍙墽琛屽姩浣淽
+ IMP -.->|鍚堟牸+涓嶅悎鏍� 蹇呴』绛変簬 妫�娴嬫垨鎺ユ敹鏁伴噺路涓嶇瓑绛夊垯鎷掕琛寍 IMPQ[鏁伴噺鍏崇郴鏍￠獙路涓や晶瀹為檯鍊奸兘鍥炴樉]
+ IMP -.->|IPQC 宸ュ簾+鏂欏簾+鍏朵粬搴熷搧 涓嶅緱瓒呰繃涓嶅悎鏍煎搧鏁伴噺路涓夊垪鐣欑┖鎸�0| IMPQ
+ IMP -.->|OQC 濉鎴锋椂鏍￠獙鍦ㄦ湰浜烘暟鎹潈闄愬唴路鐣欑┖鍒欎笉灞炰簬浠讳綍瀹㈡埛路涓嶅彈閬尅| IMPP[鏁版嵁鏉冮檺鍓嶇疆鏍￠獙]
+ IMP -.->|妫�娴嬩汉鍛樼暀绌�=褰撳墠鐧诲綍鐢ㄦ埛路IQC 妫�娴嬩笌鏉ユ枡鏃ユ湡銆丱QC 妫�娴嬫棩鏈熷繀濉稩PQC 妫�娴嬫棩鏈熶笌 OQC 鍑鸿揣鏃ユ湡鍙暀绌簗 IMPD[浜哄憳涓庢棩鏈焆
+ IMP --> IMR[鍝嶅簲 createList 鎴愬姛缂栧彿 + failureList 琛屽彿鈫掑師鍥犅锋暣琛岀┖鑷姩璺宠繃]
+ IMR -.->|瀵煎叆鍗曚竴寰嬪緟妫�楠�0路涓嶈蛋鏉ユ簮鍗曟嵁鍥炲啓路涓嶇敓鎴怤CR| IMRNOTE[涓庤Е鍙戝紡寤哄崟鐨勫尯鍒穎inish 鎵嶅垽瀹氫笌鍥炲啓]
+ A1 -->|鍙拌处 UNION ALL| LG[妫�娴嬬粨鏋滃彴璐β疯法 IQC IPQC OQC RQC 缁熶竴鏌ヨ涓庡鍑篯
+ A2 -->|鍙拌处 UNION ALL| LG
+ A3 -->|鍙拌处 UNION ALL| LG
+ A4 -->|鍙拌处 UNION ALL| LG
+ LG -->|涓�琛屼竴涓娴嬮」路鏈綍缁撴灉涔熶繚鐣欎竴琛屼笉婕忓崟| LGF[鎵规鍙锋寜绫诲瀷鍙栨潵婧惵稩QC 渚涘簲鍟嗘壒娆″彿 / IPQC OQC RQC 鎵瑰彿]
+ LG -->|鍒ゅ畾渚濇嵁鐢辨爣鍑嗗�间笌涓婁笅闄愭嫾瑁厊 LGB[鍚屼竴濂楃瓫閫夋潯浠跺鍑� Excel 鍙拌处路鍙椤典笉鎻愪緵澧炲垹鏀筣
+ LG -->|鏉冮檺鐮亅 LGPERM["mes:qc-inspection-ledger:query 鏌ヨ路:export 瀵煎嚭路鑿滃崟鎸傝川閲忕鐞嗙洰褰�"]
A1 --> R{妫�楠屽垽瀹� MesQcCheckResultEnum}
A2 --> R
A4 --> R
--
Gitblit v1.9.3