From a647bc8a43c0212f482bee0630ebd14dca120a8a Mon Sep 17 00:00:00 2001
From: 吴羡 <16976746+Xian-TT3@user.noreply.gitee.com>
Date: 星期一, 28 九月 2026 14:13:28 +0800
Subject: [PATCH] feat: CRM 发票/合同导入、MES 质检批量导入与检测台账、回款与报价校验、权限码细化

---
 docs/project-business/index.html |   30 ++++++++++++++++++++++--------
 1 files changed, 22 insertions(+), 8 deletions(-)

diff --git a/docs/project-business/index.html b/docs/project-business/index.html
index 72f2500..f9036ad 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瀹℃壒鈫掔敓鎴愰攢鍞鍗暵锋敮鎸丒xcel瀵煎叆)", "寮�绁�(BPM瀹℃壒路鏀寔Excel瀵煎叆路鍚屼竴鎵规暟鎹笉鍙噸澶嶅鍏�)鈫掑洖娆�(鍏堝紑绁ㄦ牎楠�)", "鍥炴璁″垝", "閿�鍞洰鏍�", "鏁版嵁鏉冮檺涓夌骇(璐熻矗浜�/鍙/璇诲啓)"],
      "objects": ["绾跨储", "瀹㈡埛", "鑱旂郴浜�", "鍟嗘満", "鎶ヤ环鍗�", "鍚堝悓", "鍙戠エ", "鍥炴", "閿�鍞洰鏍�"],
      "roles": ["閿�鍞唴鍕�", "閿�鍞粡鐞�", "璐㈠姟(寮�绁ㄥ洖娆�)"],
      "upstream": ["涓绘暟鎹�(鐗╂枡)"], "downstream": ["杩涢攢瀛�(閿�鍞鍗�)", "鍞悗(瀹㈡埛)", "AI(鎶ヤ环OCR)"],
@@ -450,8 +450,8 @@
     {"name": "鑱旂郴浜�", "module": "閿�鍞鐞�", "table": "crm_contact", "doc": "瀹㈡埛涓嬭仈绯讳汉锛屼笌鍟嗘満澶氬澶�", "upstream": ["瀹㈡埛"], "downstream": ["鍟嗘満"], "keywords": "鑱旂郴浜� contact"},
     {"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_contract", "doc": "HT缂栧彿锛孊PM 瀹℃壒(0鑽夌/10瀹℃壒涓�/20閫氳繃/30椹冲洖/40鍙栨秷/50浣滃簾)锛岄�氳繃鍚庡彲鐢熸垚閿�鍞鍗曪紱鏀寔 Excel 瀵煎叆锛堜竴鍚堝悓澶氫骇鍝佹槑缁嗚銆佸悎骞跺崟鍏冩牸鑷姩鎷夊钩锛屽鎴蜂笌鐗╂枡鎸夊悕绉�/缂栫爜鏍¢獙锛夛紱浜у搧鏄庣粏甯﹀嚭鐗╂枡鍚嶇О/缂栫爜/鏉$爜/瑙勬牸鍨嬪彿/璁¢噺鍗曚綅锛涘垹闄ゅ悎鍚屾椂杩炲甫鍒犻櫎浜у搧鏄庣粏锛屼笉鐣欏鍎挎暟鎹�", "upstream": ["鎶ヤ环鍗�"], "downstream": ["閿�鍞鍗�", "鍥炴璁″垝", "寮�绁�"], "keywords": "鍚堝悓 contract 瀹℃壒 瀵煎叆"},
+    {"name": "鍙戠エ", "module": "閿�鍞鐞�", "table": "crm_invoice", "doc": "KP缂栧彿锛堝彲鐣欑┖鑷姩鐢熸垚銆佺郴缁熷唴鍞竴锛夛紝BPM 瀹℃壒锛岀疮璁″紑绁ㄢ墹鍚堝悓棰濓紝闄勪欢蹇呬紶锛涙敮鎸� 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"},
@@ -478,9 +478,9 @@
     {"name": "鐩樼偣浠诲姟", "module": "浠撳偍", "table": "mes_wm_stock_taking_task", "doc": "闈欐��/鍔ㄦ�佺洏鐐癸紝琛岀粨鏋�:姝e父/鐩樼泩(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": "鎶ュ伐璐ㄦ宸ュ簭浜у嚭琛岃Е鍙戯紝瀹屾垚鍥炶皟鎺ㄨ繘鎶ュ伐涓庝骇鍑哄叆搴擄紱琛屾搷浣溿�屽嚭鎶ュ憡銆嶄粎鍦ㄥ凡瀹屾垚鏃跺彲瑙�", "upstream": ["鎶ュ伐"], "downstream": ["浜у嚭鍏ュ簱", "NCR", "鎶ュ憡瀹炰緥(鍑烘姤鍛�)"], "keywords": "IPQC 杩囩▼妫�楠� 宸℃ 鍑烘姤鍛�"},
-    {"name": "OQC鍑鸿揣妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_oqc", "doc": "閿�鍞嚭搴撴彁浜よЕ鍙戯紝瀹屾垚鎺ㄨ繘鍑哄簱鍗曞緟鎷h揣锛涜鎿嶄綔銆屽嚭鎶ュ憡銆嶄粎鍦ㄥ凡瀹屾垚鏃跺彲瑙�", "upstream": ["閿�鍞嚭搴撳崟"], "downstream": ["閿�鍞嚭搴撳崟(鎺ㄨ繘)", "鎶ュ憡瀹炰緥(鍑烘姤鍛�)"], "keywords": "OQC 鍑鸿揣妫�楠� 鍑哄巶妫�楠� 鍑烘姤鍛�"},
+    {"name": "IQC鏉ユ枡妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_iqc", "doc": "鍒拌揣閫氱煡/澶栧崗鍏ュ簱瑙﹀彂锛岃崏绋�0鈫掑畬鎴�4锛岀粨璁哄洖鍐欐潵婧愬崟鎹紱琛屾搷浣溿�屽嚭鎶ュ憡銆嶄粎鍦ㄥ凡瀹屾垚鏃跺彲瑙侊紱鏀寔 Excel 鎵归噺瀵煎叆锛堝伐鍏锋爮銆屾壒閲忓鍏ャ�嶏紝绾柊澧炪�佸鍏ュ崟涓鸿崏绋裤�佺紪鍙峰彲鐣欑┖鑷姩鐢熸垚锛夛紱鍚屼竴鎵规暟鎹笉鍙噸澶嶅鍏ワ紙鐗╂枡+渚涘簲鍟�+渚涘簲鍟嗘壒娆�+鏉ユ枡鏃ユ湡锛屾枃浠跺唴閲嶅琛屼笌搴撳唴宸叉湁鍗曢兘鎷掕琛岋級", "upstream": ["鍒拌揣閫氱煡", "澶栧崗鍏ュ簱", "Excel 鎵归噺瀵煎叆"], "downstream": ["閲囪喘鍏ュ簱", "渚涘簲鍟嗛��璐�", "NCR", "鎶ュ憡瀹炰緥(鍑烘姤鍛�)"], "keywords": "IQC 鏉ユ枡妫�楠� 鍑烘姤鍛� 鎵归噺瀵煎叆 瀵煎叆妯℃澘"},
+    {"name": "IPQC杩囩▼妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_ipqc", "doc": "鎶ュ伐璐ㄦ宸ュ簭浜у嚭琛岃Е鍙戯紝瀹屾垚鍥炶皟鎺ㄨ繘鎶ュ伐涓庝骇鍑哄叆搴擄紱琛屾搷浣溿�屽嚭鎶ュ憡銆嶄粎鍦ㄥ凡瀹屾垚鏃跺彲瑙侊紱鏀寔 Excel 鎵归噺瀵煎叆锛堜骇鍝佺墿鏂欑敱鐢熶骇宸ュ崟鎺ㄥ锛屾ā鏉夸笉濉墿鏂欙紱宸ュ簾+鏂欏簾+鍏朵粬搴熷搧涓嶅緱瓒呰繃涓嶅悎鏍煎搧鏁伴噺锛夛紱鍚屼竴鎵规暟鎹笉鍙噸澶嶅鍏ワ紙鐢熶骇宸ュ崟+妫�楠岀被鍨�+宸ヤ綅+妫�娴嬫棩鏈燂紝鏂囦欢鍐呴噸澶嶈涓庡簱鍐呭凡鏈夊崟閮芥嫆璇ヨ锛�", "upstream": ["鎶ュ伐", "Excel 鎵归噺瀵煎叆"], "downstream": ["浜у嚭鍏ュ簱", "NCR", "鎶ュ憡瀹炰緥(鍑烘姤鍛�)"], "keywords": "IPQC 杩囩▼妫�楠� 宸℃ 鍑烘姤鍛� 鎵归噺瀵煎叆 瀵煎叆妯℃澘"},
+    {"name": "OQC鍑鸿揣妫�楠�", "module": "璐ㄩ噺", "table": "mes_qc_oqc", "doc": "閿�鍞嚭搴撴彁浜よЕ鍙戯紝瀹屾垚鎺ㄨ繘鍑哄簱鍗曞緟鎷h揣锛涜鎿嶄綔銆屽嚭鎶ュ憡銆嶄粎鍦ㄥ凡瀹屾垚鏃跺彲瑙侊紱鏀寔 Excel 鎵归噺瀵煎叆锛堝鎴烽』鍦ㄥ綋鍓嶇櫥褰曠敤鎴风殑瀹㈡埛鏁版嵁鏉冮檺鑼冨洿鍐咃級锛涘悓涓�鎵规暟鎹笉鍙噸澶嶅鍏ワ紙鐗╂枡+瀹㈡埛+鎵规鍙�+鍑鸿揣鏃ユ湡锛屾枃浠跺唴閲嶅琛屼笌搴撳唴宸叉湁鍗曢兘鎷掕琛岋級", "upstream": ["閿�鍞嚭搴撳崟", "Excel 鎵归噺瀵煎叆"], "downstream": ["閿�鍞嚭搴撳崟(鎺ㄨ繘)", "鎶ュ憡瀹炰緥(鍑烘姤鍛�)"], "keywords": "OQC 鍑鸿揣妫�楠� 鍑哄巶妫�楠� 鍑烘姤鍛� 鎵归噺瀵煎叆 瀵煎叆妯℃澘"},
     {"name": "RQC閫�璐ф楠�", "module": "璐ㄩ噺", "table": "mes_qc_rqc", "doc": "鐢熶骇閫�鏂�/閿�鍞��璐�/鍞悗閫�璐цЕ鍙戯紝缁撹鍥炶皟鍞悗锛涜鎿嶄綔銆屽嚭鎶ュ憡銆嶄粎鍦ㄥ凡瀹屾垚鏃跺彲瑙併�傛帾杈炲凡缁熶竴涓恒�岄��璐ф楠屻�嶏紙鍘熻彍鍗曠埗椤逛笌 mes_qc_type 瀛楀吀鍐欍�岄��鏂欐楠屻�嶏紝涓庡悗绔灇涓�/琛ㄦ敞閲�/鑿滃崟鏉冮檺瀛愰」涓嶄竴鑷达紱RQC 涓夎�呴兘瑕嗙洊锛屾晠鍙栥�岄��璐ф楠屻�嶏級", "upstream": ["閫�鏂�", "閫�璐�"], "downstream": ["閫�璐у叆搴�", "鍞悗鍥炶皟", "鎶ュ憡瀹炰緥(鍑烘姤鍛�)"], "keywords": "RQC 閫�璐ф楠� 閫�鏂欐楠� 鍑烘姤鍛�"},
     {"name": "NCR涓嶅悎鏍煎搧", "module": "璐ㄩ噺", "table": "mes_qc_ncr", "doc": "寰呰瘎瀹�0鈫掑凡璇勫6鈫掑凡澶勭疆7鈫掑凡鍏抽棴8锛屽缃�:閫�璐�/鎶ュ簾/杩斿伐/璁╂鎺ユ敹/闄嶇骇", "upstream": ["IQC/IPQC/OQC/RQC"], "downstream": ["閫�璐�/鎶ュ簾/杩斿伐(鍙拌处)"], "keywords": "NCR 涓嶅悎鏍� 澶勭疆 鐗归噰 鎶ュ簾"},
     {"name": "璁惧", "module": "璁惧", "table": "mes_dv_machinery", "doc": "鍙拌处鐘舵��:鍋滄満/鐢熶骇涓�/淇濆吇涓紱鐐规路淇濆吇路缁翠慨宸ュ崟锛汚I 椋庨櫓棰勬祴娑堣垂鍏舵暟鎹�", "upstream": [], "downstream": ["鐐规", "缁翠慨", "鐢熶骇椋庨櫓棰勬祴"], "keywords": "璁惧 鐐规 淇濆吇 缁翠慨 machinery"},
@@ -500,7 +500,7 @@
      "steps": [
        {"stage": "鑾峰", "action": "绾跨储杞寲瀹㈡埛銆佸缓鑱旂郴浜恒�佺珛椤瑰晢鏈�", "roles": ["閿�鍞唴鍕�"]},
        {"stage": "鎶ヤ环", "action": "鍟嗘満璧㈠崟鍚庡缓鎶ヤ环鍗�(AI OCR 棰勫~)锛岃浆鍚堝悓", "roles": ["閿�鍞唴鍕�"]},
-       {"stage": "绛剧害", "action": "鍚堝悓鎻愪氦 BPM 瀹℃壒(鍙�夋祦绋嬪畾涔�)锛岄�氳繃=20", "roles": ["閿�鍞�", "瀹℃壒浜�"]},
+       {"stage": "绛剧害", "action": "鍚堝悓鏉ユ簮锛氭墜宸ユ柊寤� / 鎶ヤ环鍗曡浆鍏� / Excel 瀵煎叆(涓�鍚堝悓澶氫骇鍝佹槑缁嗚)锛涙彁浜� BPM 瀹℃壒(鍙�夋祦绋嬪畾涔�)锛岄�氳繃=20", "roles": ["閿�鍞�", "瀹℃壒浜�"]},
        {"stage": "鎺ュ崟", "action": "鍚堝悓涓�閿敓鎴愰攢鍞鍗�(XSDD)锛岄攢鍞鍗曞啀璧� BPM锛涘鎵归�氳繃鑷姩涓� needProduction 鏄庣粏鍒涘缓 MPS", "roles": ["閿�鍞�", "璁″垝鍛�"]},
        {"stage": "浜や粯", "action": "鍙戣揣閫氱煡瀹℃牳(鍗犵敤)鈫� 閿�鍞嚭搴� OQC 鈫� 鍙戣繍 鈫� 鍑哄簱鍥炲啓閮ㄥ垎/鍏ㄩ儴鍑哄簱", "roles": ["浠撶", "璐ㄦ"]},
        {"stage": "鍥炴", "action": "寮�绁� BPM(绱鈮ゅ悎鍚岄) 鈫� 鍥炴寮哄埗鍏堝紑绁�(绱鈮ゅ悎鍚屽墿浣欎笌寮�绁ㄥ墿浣�)", "roles": ["璐㈠姟", "閿�鍞�"]}]},
@@ -530,6 +530,7 @@
        {"stage": "杩囩▼", "action": "鎶ュ伐璐ㄦ宸ュ簭浜у嚭琛屸啋IPQC锛屽悎鏍兼媶琛屽叆搴撱�佷笉鍚堟牸鐢熸垚 NCR", "roles": ["IPQC 璐ㄦ鍛�"]},
        {"stage": "鍑鸿揣", "action": "閿�鍞嚭搴撴彁浜も啋OQC锛屽畬鎴愬悗鍑哄簱鍗曡繘鍏ュ緟鎷h揣", "roles": ["OQC 璐ㄦ鍛�"]},
        {"stage": "閫�璐�", "action": "閫�鏂�/閿�鍞��璐�/鍞悗閫�璐р啋RQC锛岀粨璁哄洖璋冨崟鎹笌鍞悗", "roles": ["RQC 璐ㄦ鍛�"]},
+       {"stage": "瀵煎叆", "action": "IQC/IPQC/OQC 涓夊垪琛ㄥ悇鏀寔 Excel 鎵归噺瀵煎叆(鎸夐挳鍦ㄣ�屾柊澧炪�嶄笌銆屽鍑恒�嶄箣闂达紝绾柊澧炰笉鍋氭洿鏂拌鐩�)锛氫竴琛屼竴寮犲崟锛岀紪鍙风暀绌鸿嚜鍔ㄧ敓鎴愶紝璐ㄦ鏂规鐣欑┖鎸夌墿鏂�+妫�楠岀被鍨嬭嚜鍔ㄥ尮閰嶏紝妫�娴嬩汉鍛樼暀绌哄彇褰撳墠鐧诲綍鐢ㄦ埛锛涚墿鏂�/渚涘簲鍟�/瀹㈡埛/宸ュ崟/宸ヤ綅鎸夌紪鐮佹垨鍚嶇О绮剧‘鍖归厤(IPQC 鐗╂枡鐢卞伐鍗曟帹瀵硷紝妯℃澘涓嶅~)锛屽悎鏍�+涓嶅悎鏍�=妫�娴�/鎺ユ敹鏁伴噺銆両PQC 宸ュ簾+鏂欏簾+鍏朵粬搴熷搧鈮や笉鍚堟牸銆丱QC 瀹㈡埛椤诲湪鏈汉鏁版嵁鏉冮檺鍐咃紱閫愯瀵煎叆閮ㄥ垎鎴愬姛锛屽け璐ヨ杩� failureList 甯﹁鍙蜂笌鍙墽琛屽姩浣滐紝鎴愬姛鍗曚竴寰嬪緟妫�楠�0锛涘悓涓�鎵规暟鎹笉鍙噸澶嶅鍏ワ細鏂囦欢鍐呴噸澶嶈涓庡簱鍐呭凡瀛樺湪鍚屼笟鍔¢敭鍗曟嵁锛圛QC 鐗╂枡+渚涘簲鍟�+渚涘簲鍟嗘壒娆�+鏉ユ枡鏃ユ湡銆両PQC 鐢熶骇宸ュ崟+妫�楠岀被鍨�+宸ヤ綅+妫�娴嬫棩鏈熴�丱QC 鐗╂枡+瀹㈡埛+鎵规鍙�+鍑鸿揣鏃ユ湡锛夊潎鎷掕琛岋紝鎻愮ず鍚淮搴︺�佸弻鏂瑰疄闄呭�间笌銆屽厛鍒犻櫎璇ュ崟鎹啀閲嶈瘯銆嶅姩浣�", "roles": ["璐ㄦ鍛�", "IQC 璐ㄦ鍛�", "IPQC 璐ㄦ鍛�", "OQC 璐ㄦ鍛�"]},
        {"stage": "涓嶅悎鏍�", "action": "NCR: 寰呰瘎瀹♀啋璇勫鈫掑缃�(閫�璐�/鎶ュ簾/杩斿伐/璁╂鎺ユ敹/闄嶇骇)鈫掑叧闂�", "roles": ["璐ㄩ噺宸ョ▼甯�"]},
        {"stage": "鍑轰欢", "action": "涓ゆ潯鍑轰欢鍏ュ彛锛氣憼閫氱敤 generate/preview(璋冪敤鏂硅嚜甯︿笂涓嬫枃) 娓叉煋 HTML 骞跺喕缁撴暟鎹揩鐓э紝缂栧彿 QR+鏃ユ湡+4浣嶆祦姘存寜澶╃嫭绔嬶紝preview 鍙覆鏌撲笉钀藉簱涓嶆秷鑰楃紪鍙凤紝regenerate 鐢ㄥ喕缁撳揩鐓ч噸娓蹭笖鏁版嵁涓庣紪鍙蜂笉鍙樺苟浣滃簾宸插綊妗� PDF锛屽鍑� PDF 鐢卞悗绔皟 Chromium 鎵撳嵃瀹炰緥宸插瓨鐨� HTML 鍚庡綊妗i檮浠朵腑蹇冿紱鈶enerate-from-qc 鐢辫川妫�鍗曠洿鎺ュ嚭浠�(鏁版嵁缁� MesQcReportApi 浠� MES 鍙栵紝鍓嶇涓嶆嫾涓婁笅鏂�)锛屽嚭浠跺墠浜旈亾鏍¢獙鎸変笟鍔′紭鍏堢骇鍙姤绗竴澶勶細绫诲瀷闈炴硶/鍗曟嵁涓嶅瓨鍦�/鏈畬鎴愭楠�/鏈~鍒ゅ畾/妯℃澘绫诲瀷涓嶇/鏃犲彲鐢ㄦ楠岄」锛屾姤鍛婂ご鍙﹀甫鍗曟嵁鍘熷垽瀹� qcResult+qcResultText 涓庡紩鎿庡垽瀹氬苟瀛橈紝鍝嶅簲鍥� undecidableCount 寰呭垽瀹氶」鏁颁笌 warnings(鍒嗙粍鏍囬璺宠繃/鎸囨爣宸插垹/鏈綍瀹炴祴鍊�/鏍峰搧瓒�3)锛屽悓涓�寮犲崟鎹彲鍙嶅鍑哄浠�", "roles": ["璐ㄦ鍛�"]},
        {"stage": "寤烘ā鏉�", "action": "AI 瀵煎叆锛氫笂浼犳棦鏈夋楠屾姤鍛婃枃浠�(鎵弿浠�/鐓х墖銆佺數瀛愮増 PDF銆乄ord/Excel) 鈫� 璇嗗埆鎴愭ā鏉胯崏绋�(涓嶈惤搴�) 鈫� 浜哄伐鍦ㄨ璁″櫒纭璋冩暣鍚庝繚瀛樹负鐗堟湰锛�.doc/.xls 鏃ф牸寮忎笉鏀寔", "roles": ["璐ㄦ鍛�", "璐ㄩ噺宸ョ▼甯�"]}]},
@@ -695,6 +696,7 @@
   E -->|杈撳崟鎴栨棤鏁坾 X[缁撴潫]
   F -->|杞悎鍚屄峰甫鍏ュ鎴蜂骇鍝佹姌鎵 G[鍚堝悓 HT路鑽夌0鈫掑鎵逛腑10]
   D -->|鐩存帴寤哄悎鍚寍 G
+  Q[鍚堝悓 Excel 瀵煎叆路涓�鍚堝悓澶氫骇鍝佹槑缁嗚] -->|鎵归噺寤鸿崏绋垮悎鍚寍 G
   G -->|BPM瀹℃壒閫氳繃20| H[鐢熸垚 ERP 閿�鍞鍗� XSDD]
   H -->|鎻愪氦BPM| I[閿�鍞鍗曞鎵孤峰鎵逛腑15鈫掑凡瀹℃牳20]
   I -->|鏄庣粏闇�鐢熶骇路鑷姩鍒涘缓| J[MES 涓荤敓浜ц鍒� MPS]
@@ -754,6 +756,18 @@
   T2[鎶ュ伐璐ㄦ宸ュ簭閫氳繃鍚庝骇鍑鸿] --> A2[IPQC 杩囩▼妫�楠屄疯崏绋�0鈫掑畬鎴�4]
   T3[閿�鍞嚭搴撳崟鎻愪氦] --> A3[OQC 鍑鸿揣妫�楠屄疯崏绋�0鈫掑畬鎴�4]
   T4[鐢熶骇閫�鏂欏崟 鎴� 閿�鍞��璐у崟 鎴� 鍞悗閫�璐 --> A4[RQC 閫�璐ф楠屄疯崏绋�0鈫掑畬鎴�4]
+  T5[Excel 鎵归噺瀵煎叆路IQC IPQC OQC 涓夊垪琛ㄥ悇涓�涓叆鍙B锋寜閽湪鏂板涓庡鍑轰箣闂碷 --> IMP{瀵煎叆闂搁棬路閫愯瑙f瀽路澶辫触琛屼簰涓嶅奖鍝峿
+  IMP -->|缂栧彿鐣欑┖鑷姩鐢熸垚路缂栧彿閲嶅鎴栧悓涓�鎵规暟鎹噸澶嶅垯鎷掕琛寍 A1
+  IMP --> A2
+  IMP --> A3
+  IMP -.->|鍚屼竴鎵规暟鎹笉鍙噸澶嶅鍏ヂ稩QC 鐗╂枡+渚涘簲鍟�+鎵规+鏉ユ枡鏃ユ湡 / IPQC 宸ュ崟+绫诲瀷+宸ヤ綅+妫�娴嬫棩鏈� / OQC 鐗╂枡+瀹㈡埛+鎵规+鍑鸿揣鏃ユ湡路鏂囦欢鍐呴噸澶嶈涓庡簱鍐呭凡鏈夊崟閮芥嫆骞跺洖鏄惧弻鏂瑰疄闄呭�紎 IMPDUP[瀵煎叆鍘婚噸路鎸変笟鍔¢敭]
+  IMP -.->|鐗╂枡鎸夌紪鐮� 渚涘簲鍟�/瀹㈡埛/宸ヤ綅鎸夊悕绉� 宸ュ崟鎸夊伐鍗曞彿 绮剧‘鍖归厤路鐣欑┖鏂规鎸夌墿鏂�+妫�楠岀被鍨嬭嚜鍔ㄥ尮閰峾 IMPR[寮曠敤瑙f瀽路QC_NO_TEMPLATE 琛ョ墿鏂欎笌鍙墽琛屽姩浣淽
+  IMP -.->|鍚堟牸+涓嶅悎鏍� 蹇呴』绛変簬 妫�娴�/鎺ユ敹鏁伴噺路濉啓涓嶇瓑绛夊垯璇ヨ鎷抾 IMPQ[鏁伴噺鍏崇郴鏍¢獙路涓や晶瀹為檯鍊奸兘鍥炴樉]
+  IMP -.->|IPQC 宸ュ簾+鏂欏簾+鍏朵粬搴熷搧 涓嶅緱瓒呰繃涓嶅悎鏍煎搧鏁伴噺| IMPQ
+  IMP -.->|OQC 鏍¢獙瀹㈡埛鍦ㄦ湰浜烘暟鎹潈闄愬唴路鍚﹀垯瀵煎叆鍚庡垪琛ㄤ篃鐪嬩笉鍒皘 IMPP[鏁版嵁鏉冮檺鍓嶇疆鏍¢獙]
+  IMP -.->|妫�娴嬩汉鍛樼暀绌�=褰撳墠鐧诲綍鐢ㄦ埛路IQC妫�娴�/鏉ユ枡鏃ユ湡涓嶰QC妫�娴�/鍑鸿揣鏃ユ湡蹇呭~| IMPD[浜哄憳涓庢棩鏈焆
+  IMP --> IMR[鍝嶅簲 createList 鎴愬姛缂栧彿 + failureList 琛屽彿鈫掑師鍥犅锋暣琛岀┖鑷姩璺宠繃]
+  IMR -.->|瀵煎叆鍗曚竴寰嬪緟妫�楠�0路涓嶈蛋鏉ユ簮鍗曟嵁鍥炲啓路涓嶇敓鎴怤CR| IMRNOTE[涓庤Е鍙戝紡寤哄崟鐨勫尯鍒穎inish 鎵嶅垽瀹氫笌鍥炲啓]
   A1 --> R{妫�楠屽垽瀹� MesQcCheckResultEnum}
   A2 --> R
   A3 --> R
@@ -808,7 +822,7 @@
   RCTX --> RCITEM[妫�楠岄」=鏍峰搧脳鎸囨爣浜ゅ弶灞曞紑路鍏ㄦ寚鏍囪繘涓嶈繃婊ぢ峰鏍峰搧鏃舵牱鍝佸彿鎶樿繘 remark]
   RCTX --> RCQC[鎼哄甫鍗曟嵁鍘熷垽瀹� qcResult 鏁奥穛cResultText 涓枃路涓庡紩鎿庡垽瀹氬苟瀛樹簰涓嶈鐩朷
   MESMAP -->|鍒嗙粍椤� item_type=2 涓庡畠鐨勫瓙椤规寜 parent_id 杩樺師涓ゅ眰路褰掑睘涓嶇湅 type 涔熶笉鐪嬭搴弢 RCTXG
-  RCTXG["鍒嗙粍杩樺師路缁勫ご琛岃儗缁勫悕涓� formula_text 鍏紡路缁勫唴绗竴琛岃儗 span=璇ョ粍鎬昏鏁奥峰悓缁勫叾浣欒 span=1 涓� hidden 璁╀綅路鍙悎骞舵楠岄」鐩竴鍒�"] --- RCTX
+  RCTXG["鍒嗙粍杩樺師路缁勫ご琛岃儗缁勫悕涓� formula_text 鍏紡路缁勫唴绗竴琛岃儗 span=璇ョ粍鎬昏鏁奥峰悓缁勫叾浣欒 span=1 涓� hidden 璁╀綅路鍚堝苟鐨勬槸妯℃澘 columns 閲屽甫 # 鐨勯偅涓�鍒楋紙榛樿鍒楀嵆妫�楠岄」鐩級路鍚堝苟琛屾暟鏄湰鍗曡缁勫疄闄呰鏁拌�岄潪涓绘暟鎹瓙椤规暟路璇ョ粍鏈崟鏃犲瓙椤硅鍒欎笉鍚堝苟"] --- RCTX
   MESMAP -.->|鍒嗙粍椤规湰鍗曟病鏈夊睘浜庡畠鐨勫瓙椤� / 缁勫ご鏈崟娌℃湁琛岀敱鍚庣琛ヤ竴琛寍 RCWARN
   MESMAP -.->|鎸囨爣宸插垹 / 鏈綍瀹炴祴鍊硷紙缁勫ご閿氱偣琛屾寜瀹氫箟鏃犲�悸蜂笉鎶ワ級 / 鏍峰搧瓒� 3 涓疯繘 warnings| RCWARN
   RCWARN[warnings 杞彁绀郝蜂笉钀藉簱路浜嬪悗鐪嬩笉鍒伴渶鑷鐣欑棔] --- RCTX

--
Gitblit v1.9.3