From 5072520172e8f45e3ccb8afc26cf0c8186ba4cdd Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期一, 19 十月 2026 16:31:42 +0800 Subject: [PATCH] refactor(mes): 重构质量管理和批次绑定功能 --- docs/production_quality_flow_20261019.md | 50 ++++++++++++++++++++------------------------------ 1 files changed, 20 insertions(+), 30 deletions(-) diff --git a/docs/production_quality_flow_20261019.md b/docs/production_quality_flow_20261019.md index 20ae47f..f0e2c89 100644 --- a/docs/production_quality_flow_20261019.md +++ b/docs/production_quality_flow_20261019.md @@ -1,37 +1,27 @@ -# 鐢熶骇璐ㄦ娴佺▼涓庤彍鍗曟槧灏� +# 绉嶅瓙璐ㄦ娴佺▼ -渚濇嵁鐢ㄦ埛鎻愪緵鐨勭敓浜ф祦绋嬪浘鍜屽綋鍓� `system_menu`锛屼繚鐣欏凡鏈夎川閲忕鐞嗚彍鍗曪紝鏂板鈥滈攢鍞川妫�鈥濆叆鍙ｃ�� +鎸夎鐮佷繚瀛樿川妫�璁板綍锛涙墭鐩樼爜銆佹壒娆＄爜鎻愪氦鏃讹紝姣忚鐢熸垚鐙珛璁板綍銆傜函搴︺�佸噣搴︺�佸彂鑺界巼銆佹按鍒嗗洓椤规寚鏍囧湪鍒濇銆侀噸鏂板垵妫�鍜屽妫�涓竴鑷淬�傛瘡娆℃楠屼繚瀛樻寚鏍囧揩鐓с�佹搷浣滀汉銆佹椂闂村拰涓嶅悎鏍煎師鍥犮�� -| 娴佺▼鍥捐妭鐐� | 绯荤粺鍏ュ彛 | 瀹炵幇 | +璐ㄦ椤瑰悎鏍艰寖鍥撮厤缃〉缁存姢鍥涢」鎸囨爣鐨勯粯璁ょ櫨鍒嗘瘮涓婁笅闄愶紙鍚竟鐣岋級銆傝繖鏄～鍐欐ā鏉匡紱鏈厤缃椂鍙墜鍔ㄥ～鍐欙紝鍒濇銆侀噸鏂板垵妫�鍜屽妫�鍧囧彲淇敼鏈鑼冨洿銆傛湇鍔＄鎸夋湰娆℃彁浜ょ殑瀹炴祴鍊煎拰鑼冨洿鍒ゅ畾锛屽苟淇濆瓨鑼冨洿蹇収锛涢厤缃洿鏂颁笉鏀瑰彉鍘嗗彶璁板綍銆傛闈㈢鍜屾祻瑙堝櫒绉诲姩绔潎鍙壂鎻忔墭鐩樼爜鎴栫敓浜ф壒娆＄爜锛屾壒閲忓鐞嗚鑼冨洿鍐呭悓涓�寰呮鐘舵�佺殑鍏ㄩ儴琚嬬爜锛涙彁浜ゆ椂閲嶆柊鏍稿娓呭崟锛屼换涓�琚嬪け璐ュ垯鏁存壒鍥炴粴銆� + +| 鐘舵�� | 杩涘叆鏉′欢 | 涓嬩竴姝� | | --- | --- | --- | -| 48/100 琚嬫壂鐮佸叆搴撱�佺敓鎴愭墭鐩樼爜 | 涓�琚嬩竴鐮� / 浠撳偍鐗╂祦 | 鏃㈡湁琚嬬爜銆佹墭鐩樼爜銆佹壒娆＄爜 | -| 鍔犲伐閮ㄥ垵妫� | 璐ㄩ噺绠＄悊 / 绉嶅瓙璐ㄦ | 鍙寜琚嬨�佹墭鐩樸�佹壒娆℃彁浜わ紱姣忚鐙珛璁板綍 | -| 鍒濇涓嶅悎鏍笺�佸妫� | 璐ㄩ噺绠＄悊 / 璐ㄦ璁板綍 | 淇濈暀鏆傚瓨搴撳瓨锛岃褰曞妫�缁撴灉涓庡巻娆℃寚鏍� | -| 鍔犲伐閮ㄩ瀵煎鎵� | 璐ㄩ噺绠＄悊 / 璐ㄦ璁板綍 | 鍗曟潯鎴栧悓鐘舵�佹壒閲忓鎵癸紝鍙┏鍥為噸妫� | -| 鍏徃璐ㄦ瀹℃壒 | 璐ㄩ噺绠＄悊 / 璐ㄦ璁板綍 | 鍗曟潯鎴栧悓鐘舵�佹壒閲忓鎵癸紱閫氳繃鍚庢墠杩佺Щ鎴栨姤搴熷簱瀛� | -| 閿�鍞儴璐ㄦ | 璐ㄩ噺绠＄悊 / 閿�鍞川妫� | 鐙珛鑿滃崟锛屽鐢ㄦ棦鏈� OQC 閿�鍞嚭搴撳崟妫�楠屽崟 | -| 閿�鍞妫�涓庡鎵� | 璐ㄩ噺绠＄悊 / 閿�鍞川妫� | 涓嶅悎鏍煎厛澶嶆锛岄攢鍞儴涓庡叕鍙歌川妫�瀹℃壒鍚庡洖鍐欏嚭搴撹川閲忕姸鎬� | -| 涓嶅悎鏍煎搧鐣欑棔璇勫 | 璐ㄩ噺绠＄悊 / 涓嶅悎鏍煎搧澶勭悊 | 鏃㈡湁 OQC/IPQC 鑷姩鍒涘缓 NCR | -| 姝ｅ紡鍏ュ簱銆佸嚭搴撱�佹壂鐮佽拷婧� | 浠撳偍鐗╂祦 / 鍑哄簱娴侀�� / 杩芥函 | 瀹℃壒鏀捐鍚庤鐮� `qc_status=20`锛涙湭鏀捐涓嶈兘鎵爜鍑哄簱 | +| 20 寰呭垵妫�瀹℃牳 | 鍒濇鍚堟牸 | 閫氳繃 鈫� 10锛涢┏鍥� 鈫� 50 | +| 25 寰呭垵妫�涓嶅悎鏍煎鐞� | 鍒濇涓嶅悎鏍� | 纭骞跺畨鎺掑妫� 鈫� 10锛涢┏鍥炲師妫�楠� 鈫� 50 | +| 50 鍒濇椹冲洖寰呴噸妫� | 鍒濇瀹℃牳椹冲洖 | 閲嶆柊褰曞叆鍥涢」鎸囨爣 鈫� 20 鎴� 25 | +| 10 寰呭妫� | 鍒濇瀹℃牳閫氳繃锛屾垨澶嶆瀹℃牳椹冲洖 | 褰曞叆鍥涢」鎸囨爣 鈫� 30 鎴� 60 | +| 30 寰呭妫�瀹℃牳 | 澶嶆鍚堟牸 | 閫氳繃 鈫� 40锛涢┏鍥� 鈫� 10 | +| 60 寰呭妫�涓嶅悎鏍煎鐞� | 澶嶆涓嶅悎鏍� | 纭鎶ュ簾 鈫� 70锛涢┏鍥為噸鏂板妫� 鈫� 10 | +| 40 宸叉斁琛� | 澶嶆鍚堟牸涓斿鏍搁�氳繃 | 琚嬬爜杞叆閫夊畾鍚堟牸搴� | +| 70 宸叉姤搴� | 澶嶆涓嶅悎鏍间笖瀹℃牳纭 | 鏆傚瓨搴撳瓨鎵ｅ噺骞舵姤搴熻鐮� | -## 绉嶅瓙璐ㄦ鐘舵�� +鍒濇涓庡妫�鏈熼棿搴撳瓨鐣欏湪鏆傚瓨搴撱�傚彧鏈夋渶缁堝鏍搁�氳繃鎵嶅彂鐢熷簱瀛樹簨鍔°�備笉鍚堟牸妫�楠屽繀椤诲～鍐欏師鍥狅紱澶勭疆浜洪渶濉啓瀹℃牳鎰忚銆傚妫�涓嶅悎鏍肩‘璁ゆ椂鏄庣‘鎵ц鎶ュ簾锛岄┏鍥炲垯閫�鍥炲妫�銆傛壒閲忓鏍稿湪鍚屼竴浜嬪姟鍐呭畬鎴愶紝浠讳竴琚嬪簱瀛樻祦杞け璐ュ垯鍏ㄩ儴鍥炴粴銆� -- 10 寰呭妫�锛氬垵妫�澶辫触鎴栧鎵归┏鍥烇紱搴撳瓨浠嶅湪鏆傚瓨搴撱�� -- 20 寰呭姞宸ラ儴瀹℃壒锛氬垵妫�鎴栧妫�鍚堟牸銆� -- 30 寰呭叕鍙歌川妫�瀹℃壒锛氬姞宸ラ儴鍚屾剰鏀捐銆� -- 40 宸叉斁琛岋細鍏徃璐ㄦ鍚屾剰锛屼簨鍔℃�у湴灏嗚琚嬬敱鏆傚瓨搴撶Щ鍏ュ悎鏍煎簱銆� -- 50 寰呭姞宸ラ儴涓嶅悎鏍艰瘎瀹★細澶嶆涓嶅悎鏍笺�� -- 60 寰呭叕鍙镐笉鍚堟牸瀹℃壒锛氬姞宸ラ儴鍚屾剰鎶ュ簾銆� -- 70 宸叉姤搴燂細鍏徃璐ㄦ鍚屾剰锛屼簨鍔℃�у湴绉婚櫎璇ヨ鏆傚瓨搴撳瓨銆� +鈥滆川妫�瀹℃牳浜洪厤缃�濅粎缁存姢绉嶅瓙璐ㄦ鐨勫垵妫�瀹℃牳锛堣妭鐐� 1锛夊拰澶嶆瀹℃牳锛堣妭鐐� 3锛夛紝鏀寔澶氫汉鍜屽仠鐢ㄣ�傛湇鍔＄鍚屾椂鏍￠獙鎸夐挳鏉冮檺涓庡綋鍓嶅鏍镐汉閰嶇疆锛涜秴绾х鐞嗗憳鍙烦杩囧鏍镐汉閰嶇疆鏍￠獙銆傚師 process-approve / company-approve 鎺ュ彛鍙婃潈闄愮爜淇濈暀锛屽吋瀹瑰凡鍒嗛厤瑙掕壊銆� -瀹℃壒椹冲洖鍥炲埌 10銆傛瘡娆″垵妫�銆佸妫�鍜屽鎵瑰啓鍏� `mes_qc_seed_quality_action`锛屽寘鍚搷浣滀汉銆佹椂闂淬�佹剰瑙佸拰妫�楠屾寚鏍囧揩鐓с�傛壒閲忓鎵瑰湪鍚屼竴鏁版嵁搴撲簨鍔″唴鎵ц锛屼换涓�琚嬪簱瀛樻祦杞け璐ュ垯鍏ㄩ儴鍥炴粴銆� +## 閮ㄧ讲 -閿�鍞川妫�鐨勬祦绋嬬姸鎬佷笌绉嶅瓙璐ㄦ鐩稿悓锛屽叾涓� 20/50 鐢遍攢鍞儴瀹℃壒锛�40 琛ㄧず鍑鸿揣妫�楠岄�氳繃骞跺洖鍐欓攢鍞嚭搴撳崟琛岋紝70 琛ㄧず涓嶅悎鏍煎鎵瑰畬鎴愬苟鍥炲啓涓轰笉鍚堟牸锛屽悓鏃跺垱寤� NCR銆傚垵妫�涓庡妫�涓嶅洖鍐欏嚭搴撳崟璐ㄩ噺缁撴灉锛屽洜姝ゅ鎵瑰墠浠嶅浜庡緟妫�鐘舵�併�傚妫�鍓嶅悗鏁伴噺鍙婂鎵规剰瑙佸啓鍏� `mes_qc_oqc_action`銆� - -## 閮ㄧ讲椤哄簭 - -1. 澶囦唤鏁版嵁搴擄紝鎵ц `sql/mysql/mes_seed_quality_workflow_20261019.sql`銆傝剼鏈槸涓�娆℃�ц縼绉伙紱鍘嗗彶宸叉祦杞殑鍚堟牸/涓嶅悎鏍艰褰曞垎鍒爣璁颁负 40/70锛岄伩鍏嶉噸澶嶅簱瀛樹簨鍔°�� -2. 閮ㄧ讲鍚庣銆佸墠绔�傚墠绔瀯寤轰骇鐗╁湪 `mom-pro2-before/dist.zip`銆� -3. 涓哄姞宸ラ儴涓庡叕鍙歌川妫�瑙掕壊鍒嗗埆鎺堜簣 `mes:qc-seed-quality:process-approve`銆乣mes:qc-seed-quality:company-approve`锛涘妫�浜哄憳鎺堜簣 `mes:qc-seed-quality:retest`銆備负閿�鍞儴涓庡叕鍙歌川妫�瑙掕壊鍒嗗埆鎺堜簣 `mes:qc-oqc:sales-approve`銆乣mes:qc-oqc:company-approve`锛涢攢鍞妫�浜哄憳鎺堜簣 `mes:qc-oqc:retest`銆傛牳瀵光�滈攢鍞川妫�鈥濊彍鍗曡鑹叉潈闄愩�� - -鈥滈攢鍞川妫�鈥濅笌鍘熲�滃嚭璐ф楠屸�濆叡鐢� OQC 妫�楠屽崟鍙婃棦鏈夊嚭璐ф楠岃〃鍗曪紝浣嗘湁鐙珛鑿滃崟涓庝笓闂ㄧ殑澶嶆銆佸鎵规搷浣溿�傚師鈥滆繃绋嬫楠岋紙IPQC锛夆�濅粛鏈嶅姟鐢熶骇浠诲姟鍜屾姤宸ワ紝鏈苟鍏ユ寜琚嬬爜娴佽浆鐨勭瀛愯川妫�瀹℃壒閾俱�� +1. 澶囦唤鏁版嵁搴擄紝鎵ц sql/mysql/mes_seed_quality_workflow_20261019.sql銆傚巻鍙插凡娴佽浆璁板綍鏍囦负宸叉斁琛屾垨宸叉姤搴燂紝閬垮厤閲嶅搴撳瓨浜嬪姟銆� +2. 鎵ц sql/mysql/mes_qc_oqc_retest_approver_20261019.sql锛屽垱寤哄鏍镐汉閰嶇疆涓庤彍鍗曘�傝鑴氭湰浠呮秹鍙婄瀛愯川妫�锛屼笉淇敼鍏朵粬璐ㄦ琛ㄣ�� +3. 鎵ц sql/mysql/mes_qc_seed_indicator_range_20261019.sql锛屽垱寤鸿寖鍥存ā鏉胯〃鍜岄〉闈㈣彍鍗曪紱涓虹鐞嗗憳鍒嗛厤 mes:qc-seed-range:query銆乵es:qc-seed-range:update 鏉冮檺銆傚缓璁厤缃畬鏁村洓椤归粯璁よ寖鍥淬�� +4. 閮ㄧ讲鍚庣鍜� mom-pro2-before 鍓嶇銆傚垎閰� mes:qc-seed-quality:retest銆乵es:qc-seed-quality:process-approve銆乵es:qc-seed-quality:company-approve 鏉冮檺锛屽苟鍦ㄥ鏍镐汉閰嶇疆涓寚瀹氫袱鑺傜偣瀹℃牳浜恒�� -- Gitblit v1.9.3