From 259db33b22095891f436b9ed5a81a21496b11c4c Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 23:41:55 +0800 Subject: [PATCH] feat(汇总大表): 缺数清单加导出前弹窗并在生成件附《数据缺失清单》页（待验收） --- docs/汇总大表生成数据验证方法_2026-10-12.md | 89 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 89 insertions(+), 0 deletions(-) diff --git "a/docs/\346\261\207\346\200\273\345\244\247\350\241\250\347\224\237\346\210\220\346\225\260\346\215\256\351\252\214\350\257\201\346\226\271\346\263\225_2026-10-12.md" "b/docs/\346\261\207\346\200\273\345\244\247\350\241\250\347\224\237\346\210\220\346\225\260\346\215\256\351\252\214\350\257\201\346\226\271\346\263\225_2026-10-12.md" new file mode 100644 index 0000000..7a99400 --- /dev/null +++ "b/docs/\346\261\207\346\200\273\345\244\247\350\241\250\347\224\237\346\210\220\346\225\260\346\215\256\351\252\214\350\257\201\346\226\271\346\263\225_2026-10-12.md" @@ -0,0 +1,89 @@ +# 姹囨�诲ぇ琛ㄣ�岀敓鎴愭暟鎹槸鍚︽纭�嶉獙璇佹柟娉曪紙2026-10-12锛� + +> 鐢ㄩ�旓細鍥炵瓟"绋嬪簭鐢熸垚鐨勬暟鎹涓嶅"銆� +> **涓�鍙ヨ瘽鍘熷垯**锛氭瘡涓�娈甸兘瑕佹湁涓�涓�**鐙珛浜庤娈电殑鍙傜収**鈥斺�斾袱杈瑰悓婧愶紝灏遍獙涓嶅嚭涓滆タ銆� +> 鏈柟娉曟槸 2026-10-12 鐢ㄤ袱缁勭湡瀹炴暟鎹窇鍑烘潵骞朵慨姝ｈ繃鐨勶紙瑙佺涓冭妭锛夈�� + +## 涓�銆佸厛鎶婇棶棰樻媶寮�锛堝惁鍒�"姝ｇ‘"娌℃湁瀹氫箟锛� + +"绋嬪簭鐢熸垚鐨勬暟鎹槸鍚︽纭�"瀹為檯鏄� 4 涓笉鍚岀殑闂锛屽弬鐓у拰璐ｄ换浜洪兘涓嶅悓锛� + +| # | 闂 | 鍙傜収锛堝繀椤荤嫭绔嬩簬琚獙瀵硅薄锛� | 璋佽礋璐� | 绋嬪簭鑳借嚜璇佸悧 | +|---|---|---|---|---| +| 1 | 婧愭暟鎹涓嶅 | 婧愭枃浠� / 鐪侀噷涓嬪彂琛ㄦā鏉� | 鏁版嵁銆佷笟鍔� | 涓嶈兘 | +| 2 | 绠楁硶銆佸彛寰勫涓嶅 | 鎵嬪啓 SQL 澶嶇畻锛堜笉鐪嬫瘝鐗堛�佷笉鐪嬪畾绋匡級 | 绋嬪簭 | 鑳� | +| 3 | 鍐欏洖銆佺増寮忓涓嶅 | 涓婁竴鏈熸瘝鐗堬紙鍚屾簮瀵规瘮锛岃姹�"涓嶈鍔ㄧ殑鏍兼湭鍙�"锛� | 绋嬪簭 | 鑳� | +| 4 | 涓庝汉宸ュ畾绋夸竴鑷村悧 | 鎵嬪伐瀹氱锛堝繀椤昏鐗堟湰 + sha256锛� | 鍙屾柟澶嶆牳 | 閮ㄥ垎 | + +鎵�浠ュ崟闂�"鏁版嵁瀵逛笉瀵�"娌℃湁绛旀锛涘厛闂�"**鍝竴娈�**"銆� + +## 浜屻�佷簲娈甸摼鏉′笌鍚勮嚜鐨勯獙璇佹墜娈碉紙鍚け璐ユā寮忥級 + +### L0 婧愭枃浠� 鈫� 搴� +- **鍙傜収**锛氭簮鏂囦欢鏈韩銆� +- **鎵嬫**锛氳鏁帮紙`import_batch` 鐨� total/success/fail vs 琛ㄥ唴 `COUNT(*)`锛夛紱閫愯鎶芥煡锛堟瘡甯傚窞 1~2 鏉� + 杈圭晫锛氭渶澶с�佹渶灏忋�佺己鎶ュ競宸烇級锛涘崟浣嶆牳瀵癸紙鍚� vs 涓囧惃锛夛紱鍚堣鍕剧ń锛埼�17 甯傚窞 = 婧愯〃"婀栧寳鐪�"琛岋級銆� +- **鍏稿瀷澶辫触**锛氭煇鏈堟紡瀵硷紱鍒楅敊浣嶏紱鍗曚綅宸� 10000锛涢噸澶嶅鍏ュ彔鍔狅紙"鏌愭湀閫愬競宸炲�间笌鐩搁偦鏈堝畬鍏ㄧ浉鍚�"鏄噸澶嶅鍏ョ殑鎸囩汗锛夈�� +- **宸ュ叿**锛歚_compare_freight.py` 閭ｇ被"鏂囦欢 vs 搴�"鑴氭湰锛沗import_batch`銆� + +### L1 搴� 鈫� 鍙ｅ緞鍊硷紙**鏈�鍊煎緱鎶曞叆鐨勪竴灞�**锛� +- **鍙傜収**锛氭妸鍙ｅ緞鍐欐垚 SQL/鑴氭湰**鑷繁绠椾竴閬�**锛屼笉渚濊禆姣嶇増銆佷笉渚濊禆瀹氱銆� +- **鎵嬫**锛氣憼 寮傚父浣撴 `GET /api/report/summaryWorkbook/freightCheck?period=YYYY-MM`锛堝�掑噺涓鸿礋銆佲憼婕忔姤銆佄ｅ競宸炩墵鐪佽銆佺幆姣斿紓甯搞�佺疮璁″嬀绋斤級锛涒憽 **缂烘暟娓呭崟**锛堢洰鏍囨湡璇ユ湁鐨勬湀浠�/甯傚窞鏄惁榻愬叏锛夛紱鈶� 閿氱偣澶嶇畻锛堝叏鐪� + 鎶� 2 涓競宸烇紱瑕嗙洊 瑙勪笂/瑙勪笅/鍚堣/鍛ㄨ浆閲�/涓彛寰勫洓缁�/鍩庡競鍐咃級銆� +- **鍏稿瀷澶辫触**锛氳涓嬪�掑噺涓鸿礋鎴栬櫄楂橈紱鍏ㄧ渷琛屼笌 危甯傚窞涓嶉棴鍚堬紱鏉ユ簮琛ㄧ己鏈熴�� +- **娉ㄦ剰**锛�**浣撴閫氳繃 鈮� 鏁版嵁榻愬叏**銆�2026-08 浣撴 0 鍛戒腑锛屼絾 9 鏈堢敓鎴愪欢鐨� 8 鏈堝垪浠嶇┖銆�9 鏈堝懆杞噺浠嶄负 0 鈫� 寮傚父娓呭崟涓庣己鏁版竻鍗曞繀椤�**鍒嗗紑杈撳嚭**銆� + +### L2 鍙ｅ緞鍊� 鈫� 鍗曞厓鏍硷紙鍐欏洖灞傦級 +- **鍙傜収**锛氫笂涓�鏈熸瘝鐗� / 涓婁竴鏈熺敓鎴愪欢銆� +- **鎵嬫**锛氶�愭牸 diff锛�**鍊兼ā寮忎笌鍏紡妯″紡鍚勮窇涓�閬�**锛涚洰鏍囨湀鍒楁槸鍚︾湡鐨勫啓杩涘幓浜嗭紱涓婃湡鍙婁互鍓嶅垪鏄惁 0 鍙樺寲銆� +- **鍏稿瀷澶辫触**锛氬綋鏈堝垪娌″啓锛堟湰娆″疄璇侊細璐ц繍銆佺綉绾﹁溅鍙洖濉�"鐩爣鏈�"锛屾瘝鐗堢己涓婃湀灏辫ˉ涓嶄笂锛夛紱涓婃湡鍒楄閲嶇畻鍐叉帀锛涘叕寮忔柇閾俱�� + +### L3 鍗曞厓鏍� 鈫� 鏁存湰锛堝嚭琛ㄥ眰锛� +- **鍙傜収**锛氭墜宸ュ畾绋匡紙**蹇呴』璁板綍鐗堟湰 + sha256**锛屽彧鍦ㄥ畾绋挎湭婊炲悗鏃舵湁鏁堬級銆� +- **鎵嬫**锛歚python docs\宸ュ叿\姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵�.py <鐢熸垚浠�> <鎵嬪伐瀹氱> <杈撳嚭鍓嶇紑>`锛涘彧鍒よ **瀹炶川鏁板�煎樊寮� / 闇�澶勭悊(闈炴暟鍊兼枃鏈�)** 涓ょ被锛涘樊寮傛寜棰勭櫥璁扮櫧鍚嶅崟鍒嗙被銆� +- **鍏稿瀷澶辫触**锛氭妸"瀹氱婊炲悗"褰撴垚"绋嬪簭鍥炲綊"锛堟湰娆★細瀹氱鏄� 9/13 鐗堬紝缂� 09-28 涔嬪悗鐨勬墜宸ユ敼鍔� 鈫� 澶氬嚭 364 鏉℃墜宸ヤ晶閿欒鍊� + 10 鏉″凡纭椤癸級銆� + +### L4 璺ㄩ〉鍚堟垚椤靛嬀绋斤紙**鏈�瀹规槗琚紡**锛� +- **鍙傜収**锛氬嬀绋藉紡鏈韩銆� +- **鎵嬫**锛歚鍩庡競姹囨�籤銆乣鍩庡競鍒嗗競宸瀈銆乣涓彛寰勬槑缁哷銆乣閬撹矾杩愯緭鍛ㄨ浆閲廯 姣忛〉缁欎竴鏉″嬀绋藉紡鑷锛屼緥锛氶亾璺繍杈撳懆杞噺 `B = G锛堣揣杩愰〉瑙勪笂+瑙勪笅鍛ㄨ浆閲忥級 + L/2锛堝煄甯傚杩愰噺锛� + Q/10锛堝叕璺梾瀹㈠懆杞噺锛塦銆� +- **鍏稿瀷澶辫触**锛氭簮椤甸兘瀵广�佸悎鎴愰〉寮曠敤閿欏垪銆傛湰娆� 2025-03/04 缃戠害杞︽媶鍒嗙殑褰卞搷闈紝灏辨槸闈�"鎺掑悕椤� vs 鏄庣粏椤典袱鏉￠摼璺涓嶄笂"鏆撮湶鐨勩�� + +## 涓夈�佸弽鍚屾簮鐩插尯锛�**鏈�閲嶈鐨勪竴鏉�**锛� + +浠婃棩瀹炶瘉锛�**"鐢熸垚浠� vs 鎵嬪伐瀹氱"杩欎竴灞傦紝鍦ㄦ瘝鐗堜笌瀹氱鍚屾簮鏃讹紝婧愭暟鎹湰韬殑閿欐案杩滄煡涓嶅嚭鏉ャ��** +- 2025-11 璐ц繍瀹滄槍鍛ㄨ浆閲忓樊 34.30锛�2 鏍硷級銆佺彮绾垮寘杞︿釜浣撳懆杞噺宸紙5 鏍硷級锛屽湪"鐢熸垚浠� vs 瀹氱"閲屾槸 **0 鏉�**锛屽彧鏈�"**搴撶幇绠� vs 姣嶇増缂撳瓨**"鎵嶆毚闇层�� +- 鎵�浠ワ細**蹇呴』涓撻棬鍋氫竴娆�"搴撳唴鍊� vs 姣嶇増缂撳瓨鍊�"鐨勫叏閲� diff**鈥斺�旇繖涔熸鏄� 2026-10-09 浜ゆ帴鍒椾负"闇�鍏堝仛"鐨勫緟鍔烇紝鏄�"鑳戒笉鑳藉垏璇诲簱"鐨勫敮涓�鍓嶇疆鏉′欢銆� +- 鎺緸瑕佸垎娓咃細**鍑鸿〃鍙ｅ緞**涓�"搴撲笉鑳芥浛浠ｆ瘝鐗堢紦瀛�"锛團8/Q1锛夛紱**楠岃瘉鏂规硶**涓婂繀椤讳笓闂ㄦ瘮涓�娆°�備袱鑰呬笉鐭涚浘銆� + +## 鍥涖�佹搷浣滈『搴忥紙鐓ф妱鍗冲彲锛� + +1. **鍐荤粨**锛氳 姣嶇増 sha256銆佸叧閿簮琛� `max(report_period)` 涓庤鏁般�佸悗绔繘绋� PID + 鍚姩鏃堕棿銆� + 锛�"鍒ゆ柇鏄惁鎹簡鏂拌繘绋�"蹇呴』鐪� `netstat -ano` 鐨勭湡瀹炵洃鍚� PID + 鏃ュ織鍚姩琛岋紝涓嶈兘鍙俊鍚仠鑴氭湰杈撳嚭銆傦級 +2. 寮傚父浣撴 + 缂烘暟娓呭崟锛�**鍒嗕袱浠借緭鍑�**锛夈�� +3. 鍙ｅ緞澶嶇畻閿氱偣锛堝叏鐪� + 2 甯傚窞锛涜嚦灏戣鐩� 瑙勪笂/瑙勪笅/鍚堣/鍛ㄨ浆閲�/涓彛寰�/鍩庡競鍐咃級銆� +4. 鐗堝紡鑷锛氬綋鏈堝垪宸插啓锛涗笂鏈熷強浠ュ墠鍒� 0 鍙樺寲锛沗#REF!` 鏁颁笉澧烇紱鏍囬鏈熸 = 鐩爣鏈燂紱绱 = 1..M銆� +5. 涓庡畾绋块�愭牸 diff锛堝彧鐪嬩袱绫伙級锛涘樊寮傛寜鐧藉悕鍗曞垎绫汇�� +6. 鍚堟垚椤靛嬀绋斤紙L4锛夈�� +7. 鍐欑粨璁猴細閫氳繃椤� / 鏈�氳繃椤� / **鏈鐩栭」**锛堟槑纭娓呭摢鍑犲眰娌￠獙锛夈�� + +## 浜斻�侀�氳繃鏍囧噯锛堝缓璁啓姝伙級 + +- **L0**锛氳鏁颁笌鍕剧ń涓�鑷达紙0 宸紓锛夈�� +- **L1**锛氫綋妫� 0 鍛戒腑 + 缂烘暟娓呭崟涓虹┖锛堟垨缂烘暟宸茬‘璁や负涓氬姟浜嬪疄锛�+ 閿氱偣澶嶇畻 0 宸紓銆� +- **L2**锛氫笂鏈熷強浠ュ墠鍒� 0 鍙樺寲锛涘綋鏈堝垪鍐欏叆鏍兼暟 = 棰勬湡銆� +- **L3**锛氬畾绋� diff 鐨�"瀹炶川鏁板�煎樊寮�"鍙惈鐧藉悕鍗曢」銆� +- **L4**锛氬嬀绋藉紡 0 宸紓銆� +- **浠讳竴灞傛湭瑕嗙洊 鈫� 缁撹鍙兘鍐�"鏈鐩�"锛屼笉寰楀啓"宸查獙璇�"銆�** + +## 鍏�佷笁鏉＄邯寰� + +1. **鐙珛鍙傜収**锛氬悓婧愮殑涓ょ浜х墿浜掓瘮绛変簬娌￠獙銆� +2. **涓�娆″彧鎹竴涓彉閲�**锛氭崲浠ｇ爜 / 鎹㈡暟鎹� / 鎹㈡瘝鐗堝垎寮�楠岋紝鍚﹀垯宸紓鏃犳硶褰掑洜銆� +3. **宸紓鍏堝垎绫诲啀缁撹**锛氱粨鏋�/鏍煎紡/娴偣灏惧樊鍙鏁帮紱鍙湁"瀹炶川鏁板�煎樊寮� + 闇�澶勭悊"杩涙竻鍗曘�傜櫧鍚嶅崟锛坄USER_EDITS`銆佸凡纭椤癸級棰勭櫥璁帮紝涓嶈姣忔閲嶆柊鍒よ銆� + +## 涓冦�佹湰鏂规硶鐨勫疄璇侊紙2026-10-12锛� + +1. **2026-08 鐢熸垚浠� vs 9/13 鎵嬪伐瀹氱**锛�1020 鏉℃槑缁嗛噷鍙湁 11 鏉¤鍏虫敞锛�10 鏉¤揣杩� 2022 绱鍚屾瘮銆愪笟鍔″凡纭杞欢瀵广��+ 1 鏉℃墜宸ヤ晶鑴忓瓧绗︼級锛屽叾浣欏叏鏄害瀹氬樊寮傦紙缁撴瀯/鑽夌鍒�/鏂囨湰鍨嬫暟瀛� 354/鍙栨暣灏惧樊/鎵嬪伐渚ч敊璇�� 364锛夆啋 **绠楁硶灞傞�氳繃**銆� +2. **搴撳唴 2025 vs 姣嶇増 2025**锛氬叕浜ゃ�佸嚭绉熴�佽建閬撹疆娓� **100% 涓�鑷�**锛涜揣杩愩�佺彮绾垮寘杞﹂櫎涓埆鏍间竴鑷达紱鏌ュ嚭 3 澶勯渶涓氬姟纭锛� + - 缃戠害杞� 2025-03/04銆屽叾涓煄甯傚唴銆嶅彛寰� 60 鏍硷紙鍙︽湁 12 鏈� 12 鏍煎皬宸級鈥斺��2026-09-21 宸插畾浣嶏紙姣嶇増鐢ㄤ簡鍙︿竴浠芥棫鐨勫嚭绉熷煄甯傚唴杈撳叆锛夛紱 + - 璐ц繍 瀹滄槍 2025-11 鍛ㄨ浆閲� 2 鏍硷紙宸� 34.30锛夛紱 + - 鐝嚎鍖呰溅 2025-11 涓綋鏃呭鍛ㄨ浆閲� 5 鏍笺�� + 鍚庝袱澶勪负**婧愭暟鎹眰鏂板彂鐜�**锛屾鍓嶆棤浠讳綍璁板綍锛堝洜涓哄巻鍙叉牳瀵归兘鍦ㄥ悓婧愮殑"鐢熸垚浠� vs 瀹氱"灞傦級銆� -- Gitblit v1.9.1