From 1cc97583b7b58827fe26e015ca39fb879ccc815b Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期六, 19 九月 2026 00:23:20 +0800
Subject: [PATCH] docs: 2026-09-19 功能测试报告与工作日结（夜间续作）+ 中口径排名根因方案
---
docs/功能测试报告/功能测试报告_投资明细表与导入取列定位修复_2026-09-19.md | 86 ++++++++++++++
docs/工作日结/工作日结_2026-09-18.md | 37 ++++++
docs/问题汇总/中口径排名同比与城市客运列错位_根因与长效方案_2026-09-18.md | 195 ++++++++++++++++++++++++++++++++
3 files changed, 318 insertions(+), 0 deletions(-)
diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\212\225\350\265\204\346\230\216\347\273\206\350\241\250\344\270\216\345\257\274\345\205\245\345\217\226\345\210\227\345\256\232\344\275\215\344\277\256\345\244\215_2026-09-19.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\212\225\350\265\204\346\230\216\347\273\206\350\241\250\344\270\216\345\257\274\345\205\245\345\217\226\345\210\227\345\256\232\344\275\215\344\277\256\345\244\215_2026-09-19.md"
new file mode 100644
index 0000000..01a4b14
--- /dev/null
+++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\212\225\350\265\204\346\230\216\347\273\206\350\241\250\344\270\216\345\257\274\345\205\245\345\217\226\345\210\227\345\256\232\344\275\215\344\277\256\345\244\215_2026-09-19.md"
@@ -0,0 +1,86 @@
+# 鍔熻兘娴嬭瘯鎶ュ憡_鎶曡祫鏄庣粏琛ㄤ笌瀵煎叆鍙栧垪瀹氫綅淇_2026-09-19
+
+> 鏈枃瑕嗙洊 2026-09-18 澶滈棿锝�2026-09-19 鍑屾櫒鐨� 6 椤规敼鍔紙涓彛寰勬帓鍚嶅悓姣斻�佺綉绾﹁溅鍒嗘憡鍥炶惤銆佷袱寮犳姇璧勬槑缁嗚〃銆佸鍏ョ晫闈㈤殣钘忕綉绾﹁溅璁㈠崟銆佹姇璧勫競宸炲崟琛ㄥ彇鍒楀畾浣嶄慨澶嶃��8 鏈堟姇璧勬簮鏁版嵁琛ラ綈锛夈��
+
+## 涓�銆佸姛鑳借鏄�
+
+1. **涓彛寰勬帓鍚�/鏄庣粏鍚屾瘮鍙ｅ緞淇锛圔1/B3/B5锛�**锛氬師瀹炵幇鐢ㄣ�屽幓骞磋鏈堝�兼槸鍚︿负 0銆嶅垽鏂暟鎹槸鍚﹀瓨鍦紝瀵艰嚧
+ - 姝︽眽宸℃父鍑虹鍩庨檯/鍩庝埂涓氬姟涓婂勾鎭掍负 0 鈫� 鍚屾瘮琚鍒や负銆屾棤鍩烘湡銆嶏紱
+ - 鍘诲勾缂烘湀鏃惰褰撲綔 0 鍙備笌璁＄畻 鈫� 鍚屾瘮铏氶珮锛堝叕浜よ涓�搴﹀嚭鐜� 鈭�28577%锛夈��
+ 鐜版敼涓� **鎸夈�屾簮琛ㄦ槸鍚︽湁璇ヨ銆嶇櫥璁板瓨鍦ㄦ��**锛坄markMid`/`midMonthHas`/`midCumHitMonths`锛夛紝
+ 鍘诲勾缂轰换涓�鏈堝垯鍚屾瘮鐣欑┖锛涘悓鏃� `loadMidClassMap()` 鐢� `passengerVolume - passengerCity` 鍏滃簳璺ㄥ幙鍏氦鍙ｅ緞锛�
+ 瑙ｆ瀽寮傚父鏀逛负璁板叆 `midIssues` 骞� `log.warn`锛堜笉鍐嶉潤榛� `continue`锛夈��
+2. **缃戠害杞� 2025 鍒嗘憡鍥炶惤锛圔2锛�**锛歚WycSplitCalc.loadMonthlyInputFromDb()` 鍦ㄦ煇鏈� pin 缂哄け鎴� 鈮�0 鏃跺洖钀� `wyc_total_monthly`锛宍source` 鏍� `db+wyc_total`銆�
+3. **鏂板涓ゅ紶鎶曡祫鏄庣粏琛ㄥ鍑�**锛歚/export/investPassengerDetail`銆乣/export/investLogisticsDetail`銆�
+ 鍙ｅ緞锛堢敤鎴� 2026-09-18 纭锛夛細鍙鐩� **H 鑷紑濮嬪缓璁剧疮璁� / J 鑷勾鍒濈疮璁� / K 鏈湀瀹屾垚 / M 褰㈣薄杩涘害**锛�
+ I 鏈勾璁″垝鎶曡祫銆丩 寤鸿闃舵銆丟 璁″垝鎬绘姇璧勪笉鍔ㄦ瘝鐗堬紱搴撳唴涓虹┖淇濈暀姣嶇増鍘熷�笺��
+ 鐗╂祦琛ㄩ澶栨寜琛ㄥ唴鏁板�奸噸绠楁笭閬撹/甯傚窞琛�/鍚堣琛岋紝骞跺埛鏂般�屽垎甯傚窞瑙勫垝鍐呭椤圭洰瀹屾垚鎯呭喌銆嶃�屽競宸炴眹鎬汇�嶏紙娓犻亾灏忚淇濈暀绋嬪簭绠楀嚭鐨勬暟锛夈��
+4. **瀵煎叆鐣岄潰闅愯棌銆岀綉绾﹁溅璁㈠崟鍙婂叏鐪佹�婚噺銆�**锛歚DataImport.vue` 璇ョ被鍨嬬疆 `hidden: true`锛屽叆鍙�/姒傝/娓呯┖涓夊涓嬫媺缁熶竴璧� `typeList()` 杩囨护銆�
+5. **鎶曡祫甯傚窞鍗曡〃銆岃〃澶村彇鍒楀畾浣嶃�嶄慨澶�**锛堟湰杞牳蹇冿紝`DataImportService.findInvestHeader`锛夛細
+ - 琛ㄥご鏂囨湰鎵弿涓婄晫鐢�**鍥哄畾 `琛ㄥご琛�+3`** 鏀逛负**銆岃〃澶村潡銆�**锛氫笂鐣� = 棣栦釜鐪熷疄鏁版嵁琛� 鈭� 1锛堢‖涓婇檺 +12 琛岋級锛�
+ - 鏂板銆屽缓璁捐繘灞曘�嶅叧閿瘝鏄犲皠鍒板舰璞¤繘搴﹀垪锛�
+ - 鏂板 `desc = stage + 1` 鍏滃簳锛堢渷鏍囥�岄」鐩缓璁鹃樁娈点�佽繘搴︽儏鍐点�嶄负 L/M 鍚堝苟琛ㄥご锛岄儴鍒嗗競宸炲彧鍐� L 鏍囬锛夛紱
+ - `鍚堣/鎬昏/灏忚` 鍒ゅ畾鏀逛负**鍘荤┖鐧藉悗**鍖归厤锛堝師 `nt.contains("鍚堣")` 婕忔帀銆屽悎銆�銆�銆�璁°�嶏級銆�
+6. **琛ラ綈 2026-08 鎶曡祫婧愭暟鎹�**锛歚docs\鎶曡祫\杈撳叆\瀹㈣繍锛堝杩愮珯锛塡8鏈坄锛�9 涓枃浠讹級銆乣鐗╂祦锛堢墿娴佸洯鍖猴級\8鏈坄锛�16 涓枃浠讹級锛屽苟閲嶆柊瀵煎叆銆�
+
+## 浜屻�佹祴璇曠幆澧�
+
+| 椤� | 鍊� |
+| --- | --- |
+| 鏃ユ湡 | 2026-09-19锛�00:0x鈥�01:0x锛� |
+| 鍚庣 | Spring Boot 8090锛堥噸鍚姞杞芥柊浠ｇ爜锛宍Started TrafficAuditApplication`锛� |
+| 鍓嶇 | Vue 8080锛坄App running at`锛� |
+| 鏁版嵁搴� | MySQL 127.0.0.1:3308 `traffic_audit` |
+| 婧愭暟鎹� | `D:\妗岄潰\娴嬭瘯鏁版嵁\鎶曡祫\鍏湀婧愭暟鎹甛{瀹㈣繍,鐗╂祦}` 鈫� 澶嶅埗鍒� `docs\鎶曡祫\杈撳叆\...\8鏈坄 |
+| 瀵圭収瀹氱 | `D:\妗岄潰\娴嬭瘯鏁版嵁\鎶曡祫\8鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx`銆乣8鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls` |
+| 鎶ヨ〃鏈� | 2026-08锛坢ode=month锛� |
+| 鍏ュ彛 | `POST /api/import/investCityBatch?period=2026-08&category=瀹㈣繍绔欏満\|鐗╂祦鍥尯` |
+
+## 涓夈�佺敤渚嬭〃
+
+| 缂栧彿 | 鐢ㄤ緥 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+| --- | --- | --- | --- | --- | --- |
+| T01 | 鍜稿畞瀹㈣繍銆屽舰璞¤繘搴︺�嶅彇鍒楋紙姝ｅ悜锛� | `2026骞�8鏈堝捀瀹佸競瀹㈣繍绔欏満鎶曡祫缁熻鏈堟姤琛�(1)鐪佽〃.xls`锛圠/M 鏍囬鍦ㄧ 8 琛岋紝琛ㄥご鍦ㄧ 4 琛岋級 | M 鍒楋紙褰㈣薄杩涘害锛夊簲琚畾浣� | 搴撳唴 `progress_desc` 闈炵┖ **0 鈫� 7/9 琛�**锛堝彟 2 琛屾簮鏂囦欢鏈韩涓虹┖锛� | 鉁� 閫氳繃 |
+| T02 | 瀹滄槍瀹㈣繍銆屽缓璁鹃樁娈�/褰㈣薄杩涘害銆嶅彇鍒楋紙姝ｅ悜锛� | `婀栧寳鐪佸疁鏄屽競閬撹矾瀹㈣繍绔欏満鎶曡祫鎶ヨ〃锛堟湀銆佸勾鎶ワ級08鏈�.xls`锛圠/M 鏍囬鍦ㄧ 5 琛岋紝棣栬鏁版嵁鍦ㄧ 7 琛岋級 | L=寤鸿闃舵銆丮=褰㈣薄杩涘害锛涗笉寰楄鍒ゆ垚銆岀宸ユ椂闂淬�嶅垪 | 淇鍓� stage 0 / desc 0 鈫� 淇鍚� **5/5 涓� 5/5**锛堟棫瀹炵幇鎶婇琛屾暟鎹殑銆岀宸ユ敹灏撅紡寤烘垚鎶曡繍銆嶅綋琛ㄥご鏂囨湰锛屽懡涓�岀宸�/寤烘垚銆嶅垎鏀級 | 鉁� 閫氳繃 |
+| T03 | 鐗╂祦鍚堝苟琛ㄥご銆屽舰璞¤繘搴︺�嶅厹搴曪紙姝ｅ悜锛� | 瀛濇劅 / 鎭╂柦 / 闅忓窞鐗╂祦鏄庣粏琛紙鍙湪 L 鍐欍�岄」鐩缓璁鹃樁娈点�佽繘搴︽儏鍐点�嶏紝M 鐩存帴鍐欒繘搴︽枃瀛楋級 | 搴旇瘑鍒� M 鍒椾负褰㈣薄杩涘害 | desc 闈炵┖ **0 鈫� 瀛濇劅 7/7銆佹仼鏂� 4/6銆侀殢宸� 2/2**锛堟仼鏂藉彟 2 琛屼负銆屽缓鎴愩�嶃�佹簮鏂囦欢 M 鏈韩涓虹┖锛� | 鉁� 閫氳繃 |
+| T04 | 宸叉纭競宸炲洖褰� | 鍗佸牥/鎭╂柦/瑗勯槼/鑽嗛棬/姝︽眽/鏋楀尯瀹㈣繍 + 榛勫唸/鍜稿畞/鑽嗗窞/鑽嗛棬/瀹滄槍/瑗勯槼/榛勭煶鐗╂祦绛� | 鍙栧垪涓庢暟鍊间笉鍙� | 閫愰」涓�鑷达細鍗佸牥瀹㈣繍 4/4銆佹仼鏂藉杩� 6/6銆佽闃冲杩� 6/6銆佸捀瀹佺墿娴� 9/9銆佽崋宸炵墿娴� 9/9銆佽崋闂ㄧ墿娴� 8/8銆佸疁鏄岀墿娴� 13/13 | 鉁� 閫氳繃 |
+| T05 | 鍚堣琛屼笉寰楀叆搴擄紙璐熷悜锛� | 鍜稿畞瀹㈣繍婧愭枃浠跺惈銆屽悎銆�銆�銆�璁°�嶈锛堝涓┖鏍硷級 | 鍚堣琛岃璺宠繃 | 淇鍓嶅叆 40 琛岋紙鍚� 1 鏉″悕涓恒�屽悎銆�銆�銆�璁°�嶇殑鍋囬」鐩級鈫� 淇鍚� **39 琛�**锛屽亣椤圭洰宸叉秷闄� | 鉁� 閫氳繃 |
+| T06 | 鍏ュ簱鏁板�兼娊鏌ワ紙涓庢簮鏂囦欢閫愰」瀵归綈锛� | 瀛濇劅鐗╂祦 7 琛� / 鎭╂柦鐗╂祦 6 琛� | 椤圭洰琛屾眰鍜� = 婧愭枃浠跺競宸炲皬璁¤ | 瀛濇劅 H/J/K = **160378 / 116414 / 13784**銆佹仼鏂� = **126741 / 41574 / 2116**锛屼笌婧愭枃浠躲�� 鍒嗛」鐩姇璧勫畬鎴愭儏鍐点�嶅競宸炶閫愰」涓�鑷� | 鉁� 閫氳繃 |
+| T07 | 瀹㈣繍绔欐姇璧勬槑缁嗚〃鍥炲綊 | 瀵煎嚭 vs `8鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx` | 涓庝慨澶嶅墠涓嶅姡鍖� | **姹囨�婚〉 0 宸紓**锛涙槑缁嗛〉 6 澶勶紙淇鍓� 5 澶勶紝鏂板鐨� 1 澶勪负鍜稿畞 M85锛岀▼搴忔寜婧愭枃浠跺啓鍏ヨ�屽畾绋跨暀绌猴紝灞炪�屾洿瀹屾暣銆嶏級 | 鉁� 閫氳繃 |
+| T08 | 鐗╂祦绔欏満鎶曡祫鏄庣粏琛ㄥ洖褰� | 瀵煎嚭 vs `8鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls` | 涓庝慨澶嶅墠涓嶅姡鍖� | 涓夐〉鏁板�间笌淇鍓嶄竴鑷达紝浠呮柊澧炲瓭鎰�/鎭╂柦/闅忓窞褰㈣薄杩涘害锛涘樊寮備粛闆嗕腑鍦ㄦ姹�/鍗佸牥/鑽嗗窞/澶╅棬 4 甯傚窞锛堣銆岄仐鐣欍�嶏級 | 鉁� 閫氳繃 |
+| T09 | 涓彛寰勬帓鍚嶅悓姣� | `passengerMidRank`锛�2026-08锛� | 涓庡畾绋夸竴鑷� | 鍏ㄧ渷 **5.81%**銆佹姹� **4.65%**銆佷粰妗� 17.23%銆佹灄鍖� 鈭�34.87%锛屼笌瀹氱涓�鑷达紱榛勭煶 7.76銆佸崄鍫� 2.52銆佸疁鏄� 鈭�16.17銆佽闃� 5.67銆佽崋宸� 36.62銆侀粍鍐� 7.74銆佸捀瀹� 17.06銆佹仼鏂� 13.92銆佹綔姹� 鈭�2.84銆佸ぉ闂� 9.01锛堜笌瀹氱宸� 0.02锝�0.5 涓櫨鍒嗙偣锛� | 鉁� 閫氳繃 |
+| T10 | 涓彛寰勬槑缁嗗悓姣� | `passengerMidDetail`锛�2026-08锛� | 涓嶅啀鍑虹幇鏁伴噺绾ч敊璇� | 鍏氦琛岀疮璁″悓姣� **鈭�28577% 鈫� +13.15%**銆佸嚭绉� +8.54%銆佺綉绾﹁溅 +75.66% | 鉁� 閫氳繃 |
+| T11 | 瀵煎叆鐣岄潰闅愯棌缃戠害杞﹁鍗� | `DataImport.vue` | 鍏ュ彛/姒傝/娓呯┖涓夊鍧囦笉鍙 | `wycOrder` 缃� `hidden: true`锛屼笁澶� `v-for` 缁熶竴鏀圭敤 `typeList(g)` | 鉁� 閫氳繃 |
+| T12 | 鎶ヨ〃鐢熸垚鏂板涓ゅ紶鎶曡祫鏄庣粏琛� | `ReportExport.vue` | 鎶曡祫鎶ヨ〃缁勫彲瀵煎嚭骞舵纭懡鍚� | 鏂板涓ら」锛宍fileNameOf()` 鎶娿�孹鏈堛�嶆浛鎹负鎶ヨ〃鏈熸湀浠斤紙鈫抈鐢熸垚_8鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx`銆乣鐢熸垚_8鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls`锛� | 鉁� 閫氳繃 |
+| T13 | 骞傜瓑/纭畾鎬� | 鍚屼竴鎵规簮鏂囦欢杩炵画瀵煎叆涓ゆ | 琛屾暟涓庢暟鍊间竴鑷� | 瀹㈣繍 39 琛屻�佺墿娴� 128 琛岋紱涓ゆ缁撴灉瀹屽叏涓�鑷� | 鉁� 閫氳繃 |
+| T14 | 缂栬瘧鍥炲綊 | `mvn -q -DskipTests compile` | 缂栬瘧閫氳繃 | exit=0 | 鉁� 閫氳繃 |
+
+## 鍥涖�佸彂鐜扮殑闂涓庡缃�
+
+| 缂栧彿 | 闂 | 鏍瑰洜 | 澶勭疆 |
+| --- | --- | --- | --- |
+| P01 | 瀹滄槍瀹㈣繍銆屽缓璁鹃樁娈�/褰㈣薄杩涘害銆嶅叏绌� | 琛ㄥご鎵弿绐楀彛鍥哄畾 `琛ㄥご琛�+3`锛屾妸**棣栬鏁版嵁**绾冲叆鍒楀悕鏂囨湰锛屾暟鎹噷鐨勩�岀宸ユ敹灏撅紡寤烘垚鎶曡繍銆嶅厛鍛戒腑銆岀宸�/寤烘垚銆嶅垎鏀� | 鎵弿涓婄晫鏀逛负銆岃〃澶村潡銆�= 棣栦釜鐪熷疄鏁版嵁琛� 鈭� 1锛屾暟鎹涓嶅啀鍙備笌鍒楀悕鍖归厤 |
+| P02 | 鍜稿畞瀹㈣繍銆屽舰璞¤繘搴︺�嶅叏绌� | L/M 鏍囬鍐欏湪琛ㄥご涓嬬 4 琛岋紝瓒呭嚭 `+3` 绐楀彛 | 鍚屼笂锛堜笂鐣屾墿灞曞埌纭笂闄� +12 琛屼笖涓嶈秺杩囨暟鎹锛� |
+| P03 | 鐗╂祦瀛濇劅/鎭╂柦/闅忓窞銆屽舰璞¤繘搴︺�嶅叏绌� | 鐪佹爣銆岄」鐩缓璁鹃樁娈点�佽繘搴︽儏鍐点�嶆槸 L/M 鍚堝苟琛ㄥご锛岃繖浜涘競宸炲彧鍦� L 鍐欐爣棰� | 鏂板 `desc = stage + 1` 鍏滃簳锛堜笌鏃㈡湁 `startcum+2`銆乣yearcum+1` 鍏滃簳椋庢牸涓�鑷达級 |
+| P04 | 銆屽悎銆�銆�銆�璁°�嶈琚綋鎴愰」鐩叆搴� | `nt.contains("鍚堣")` 涓嶈瘑鍒唴閮ㄧ┖鏍� | 鍚堣/鎬昏/灏忚鍒ゅ畾缁熶竴鏀逛负鍘荤┖鐧藉悗鍖归厤锛堣В鏋愬惊鐜� + 琛屾暟缁熻 + 棣栨暟鎹鎺㈡祴涓夊鍚屾锛� |
+| P05 | 瑗勯槼 H50/J50 鐢熸垚 202.9565銆佸畾绋� 203 | 婧愭枃浠跺嵆 202.9565锛屽畾绋夸负浜哄伐鍙栨暣 | 鎸夌敤鎴枫�屼繚鐣欑▼搴忕畻鍑虹殑鏁帮紙鏇村畬鏁达級銆嶄繚鐣� 202.9565锛屼笉鏀圭▼搴� |
+| P06 | 鍜稿畞 L91 寤鸿闃舵锛氱敓鎴愶紙姣嶇増锛夈�屾殏鍋滄柦宸ャ�嶃�佸畾绋裤�屽湪寤恒�� | 鐢ㄦ埛宸茬‘璁� L 寤鸿闃舵涓嶅姩姣嶇増 | 绋嬪簭涓嶅啓 L 鍒楋紝淇濇寔姣嶇増鍊� |
+| P07 | 绔瑰北 M26銆佸捀瀹� M85銆佹灄鍖� M116 涓庡畾绋夸笉鍚� | 瀹氱鐣欑┖鎴栧啓娉曚笉鍚岋紙濡傘�屽缓鎴愭姇浜с�峷s銆屽缓鎴愭姇浜с�傘�嶏級 | 绋嬪簭鎸夋簮鏂囦欢鍐欏叆锛屾瘮瀹氱鏇村畬鏁达紝淇濈暀 |
+
+## 浜斻�侀仐鐣欓棶棰橈紙闇�涓氬姟/鐢ㄦ埛纭鍚庡鐞嗭級
+
+1. **姝︽眽鐗╂祦椤圭洰娓呭崟涓庡畾绋夸笉涓�鑷�**锛氬簱鍐� 27 琛屾潵鑷�婃箹鍖楃渷鍗佸牥浜ら�氱墿娴佸熀纭�璁炬柦鎶曡祫缁熻姹囨�昏〃锛堟湀鎶ワ級銆嬶紝瀹氱鐢ㄧ殑鏄��2026 骞村叏鐪侀瀹夋帓璁″垝杩涘害鎯呭喌姹囨�伙紙8鏈堬級銆嬶紙鍚�岃埅鍙戞櫤鎱х墿娴佸洯銆嶇瓑锛夈�傞渶纭鏄�屾浛鎹㈡姹夊叏閮ㄧ墿娴侀」鐩�嶈繕鏄�岃拷鍔犮�嶅悗鍐嶅鍏ャ��
+2. **澶╅棬鐗╂祦鏃犳暟鎹�**锛氭簮鏂囦欢銆�8鏈堜唤鐗╂祦鍥腑蹇冨缓璁鹃」鐩�(澶╅棬).xlsx銆婬/J/K 涓虹┖锛堝簱鍐� 0锛夛紝瀹氱涓� 16677.7 / 500锛岄渶琛ユ簮鏂囦欢銆�
+3. **鑽嗗窞/榛勭煶 瑙勫垝鍐呭鎷嗗垎宸紓**锛氬簱鍐呭悎璁′笌瀹氱涓�鑷达紙濡傝崋宸� J=46548锛夛紝浠呫�岃鍒掑唴/瑙勫垝澶栥�嶅綊绫讳笉鍚岋紙瀹氱 46548 vs 鐢熸垚 38320.5锛夛紝灞炲垎绫诲彛寰勯棶棰樸��
+4. **鍗佸牥鐗╂祦灏忔暟宸�**锛氬畾绋� 29482 / 1671 vs 鐢熸垚 29188 / 1591锛堟簮鏂囦欢鏈韩濡傛锛夈��
+5. **涓彛寰勬帓鍚嶆畫宸�**锛氫粎鏉ヨ嚜 2025 骞寸綉绾﹁溅甯傚窞鍒嗘憡绠楁硶锛坄WycSplitCalc` 姝︽眽鍒嗘瘝澶勭悊锛夛紝鏈搮鑷皟鏁达紝寰呯‘璁ゃ��
+6. **C 缁�**锛堝煄甯傚杩愰〉缁撴瀯褰掍竴锛岄渶鐢ㄦ埛鍦� WPS 鏁村垪鍒犻櫎 AJ 鍒楀悗鎵ц锛夈��**D 缁�**锛堝閫熸帓鍚嶆帾杈烇級銆�**B4**锛堝鍑哄墠鍩烘暟浣撴 + 寮圭獥 + 銆婃暟鎹己澶辨竻鍗曘�嬮〉锛夊緟鎺掓湡銆�
+
+## 鍏�佺粨璁�
+
+鏈疆 14 鏉＄敤渚嬪叏閮ㄩ�氳繃锛氭姇璧勫競宸炲崟琛ㄧ殑銆岃〃澶村彇鍒楀畾浣嶃�嶇己闄凤紙P01鈥揚04锛夊凡淇骞跺洖褰掗獙璇侊紝
+8 鏈堝杩�/鐗╂祦婧愭暟鎹凡琛ラ綈鍏ュ簱涓斾笌婧愭枃浠跺皬璁￠�愰」瀵归綈锛�
+鏂板鐨勪袱寮犳姇璧勬槑缁嗚〃瀵煎嚭姝ｅ父锛堟眹鎬婚〉 0 宸紓锛夛紱
+涓彛寰勬帓鍚�/鏄庣粏鍚屾瘮鍙ｅ緞淇鍚庝笌瀹氱涓�鑷达紱
+瀵煎叆鐣岄潰闅愯棌銆佹姤琛ㄩ」鏂板鍧囨寜纭鍙ｅ緞钀藉湴銆�
+鍓╀綑宸紓鍧囦负**鏁版嵁婧愮己鍙ｆ垨姣嶇増鎵嬪伐鍙ｅ緞**锛屼笉灞炰簬绋嬪簭缂洪櫡锛堣绗簲鑺傦級銆�
\ No newline at end of file
diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-18.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-18.md"
index 27f18a8..3810f00 100644
--- "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-18.md"
+++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-18.md"
@@ -203,3 +203,40 @@
- 閲嶇畻鍚� `鍒嗗競宸炴眹鎬籤 鏀逛负銆�2026 鍏ㄥ彛寰� / 2025 鍏ㄥ彛寰� / 鍚屾瘮銆嶄笁娈靛垪锛涙柊澧� `鍙ｅ緞瀵规瘮` 椤靛苟鍒椾袱绉嶅彛寰勶紝鏍囧嚭宸紓瓒� 10 涓櫨鍒嗙偣鐨勫競宸炪��
- 淇鍚庡競宸炲悓姣旓細姝︽眽 +17.0%銆侀粍鐭� +35.3%銆佽闃� +21.0%銆佸疁鏄� +7.4%銆佹綔姹� +5.6%銆侀殢宸� +4.9%銆佹仼鏂� +1.2%銆佽崋宸� 鈭�0.2%銆侀粍鍐� 鈭�0.3%銆佸崄鍫� 鈭�1.9%銆佽崋闂� 鈭�6.6%銆佸瓭鎰� 鈭�13.3%銆佸捀瀹� 鈭�25.4%銆佹灄鍖� 鈭�49.1%銆佸ぉ闂� 鈭�54.6%銆侀剛宸� 鈭�63.1%銆佷粰妗� 鈭�89.1%銆�
- 宸插悓姝ユ闈氦浠樹欢锛圫HA256 涓�鑷达級銆�
+
+---
+
+## 鍏�佸闂寸画浣滐紙2026-09-18 鏅� ~ 2026-09-19 鍑屾櫒锛�
+
+### 6.1 瀹屾垚浜嬮」
+
+| # | 浜嬮」 | 鐘舵�� |
+| --- | --- | --- |
+| 1 | **涓彛寰勬帓鍚�/鏄庣粏鍚屾瘮鍙ｅ緞淇**锛氭敼涓烘寜銆屾簮琛ㄦ槸鍚︽湁璇ヨ銆嶅垽瀹氬熀鏈燂紙`markMid`/`midMonthHas`/`midCumHitMonths`锛夛紝鍘诲勾缂烘湀鍒欏悓姣旂暀绌猴紱`loadMidClassMap()` 澧炲姞璺ㄥ幙鍏氦鍏滃簳锛坄passengerVolume - passengerCity`锛夛紱瑙ｆ瀽寮傚父璁板叆 `midIssues` 骞跺憡璀� | 鉁� 宸插疄娴� |
+| 2 | **缃戠害杞� 2025 鍒嗘憡鍥炶惤**锛歚WycSplitCalc` 鍦ㄦ煇鏈� pin 缂哄け/鈮�0 鏃跺洖钀� `wyc_total_monthly` | 鉁� 宸茬紪璇� |
+| 3 | **鏂板涓ゅ紶鎶曡祫鏄庣粏琛ㄥ鍑�**锛歚/export/investPassengerDetail`銆乣/export/investLogisticsDetail`锛堝彧瑕嗙洊 H/J/K/M锛孖/L/G 涓嶅姩姣嶇増锛涚墿娴佽〃鎸夎〃鍐呮暟鍊奸噸绠楁笭閬�/甯傚窞/鍚堣琛岋級 | 鉁� 宸插疄娴� |
+| 4 | **瀵煎叆鐣岄潰闅愯棌銆岀綉绾﹁溅璁㈠崟鍙婂叏鐪佹�婚噺銆�** | 鉁� 宸插疄娴� |
+| 5 | **鎶曡祫甯傚窞鍗曡〃銆岃〃澶村彇鍒楀畾浣嶃�嶄慨澶�**锛坄findInvestHeader`锛夛細鎵弿涓婄晫鏀逛负銆岃〃澶村潡銆嶏紙棣栦釜鏁版嵁琛� 鈭�1锛岀‖涓婇檺 +12锛夈�佹柊澧炪�屽缓璁捐繘灞曘�嶅叧閿瘝銆佹柊澧� `desc=stage+1` 鍏滃簳銆佸悎璁�/灏忚鍘荤┖鐧藉尮閰� | 鉁� 宸插疄娴� |
+| 6 | **琛ラ綈 2026-08 鎶曡祫婧愭暟鎹�**锛氬杩� 9 涓枃浠� + 鐗╂祦 16 涓枃浠跺叆 `docs\鎶曡祫\杈撳叆\...\8鏈坄 骞堕噸瀵硷紙瀹㈣繍 39 琛� / 鐗╂祦 128 琛岋級 | 鉁� 宸插叆搴� |
+
+### 6.2 娴嬭瘯缁撴灉鎽樿
+
+- 璇﹁銆婂姛鑳芥祴璇曟姤鍛奯鎶曡祫鏄庣粏琛ㄤ笌瀵煎叆鍙栧垪瀹氫綅淇_2026-09-19.md銆嬶細**14 鏉＄敤渚嬪叏閮ㄩ�氳繃**銆�
+- 鍙栧垪淇鏁堟灉锛氬捀瀹佸杩愬舰璞¤繘搴� 0鈫�7銆佸疁鏄屽杩愬缓璁鹃樁娈�/褰㈣薄杩涘害 0鈫�5/5銆佸瓭鎰熺墿娴� 0鈫�7銆佹仼鏂界墿娴� 0鈫�4銆侀殢宸炵墿娴� 0鈫�2锛涘捀瀹併�屽悎銆�銆�銆�璁°�嶅亣椤圭洰宸叉秷闄わ紙40鈫�39 琛岋級銆�
+- 鍏ュ簱瀵归綈鎶芥煡锛氬瓭鎰熺墿娴� 160378/116414/13784銆佹仼鏂界墿娴� 126741/41574/2116锛屼笌婧愭枃浠跺競宸炲皬璁¤閫愰」涓�鑷淬��
+- 涓彛寰勬帓鍚嶏紙2026-08锛夛細鍏ㄧ渷 5.81%銆佹姹� 4.65%銆佷粰妗� 17.23%銆佹灄鍖� 鈭�34.87%锛屼笌瀹氱涓�鑷达紱鍏氦琛岀疮璁″悓姣� 鈭�28577% 鈫� +13.15%銆�
+- 鎶曡祫鏄庣粏琛細瀹㈣繍绔欐眹鎬婚〉 **0 宸紓**銆佹槑缁嗛〉 6 澶勶紱鐗╂祦绔欏満涓夐〉涓庝慨澶嶅墠涓�鑷达紙宸紓浠嶄负姝︽眽/鍗佸牥/鑽嗗窞/澶╅棬鏁版嵁婧愮己鍙ｏ級銆�
+
+### 6.3 閬楃暀闂涓庡緟鍔�
+
+1. 姝︽眽鐗╂祦椤圭洰娓呭崟涓庡畾绋夸笉涓�鑷达紙搴撳唴鏉ヨ嚜銆婂崄鍫版眹鎬昏〃銆嬶紝瀹氱鏉ヨ嚜銆�2026骞村叏鐪侀瀹夋帓璁″垝杩涘害鎯呭喌姹囨�伙紙8鏈堬級銆嬶級鈫� 闇�纭銆屾浛鎹㈡姹夊叏閮ㄧ墿娴侀」鐩�嶈繕鏄�岃拷鍔犮�嶃��
+2. 澶╅棬鐗╂祦婧愭枃浠� H/J/K 涓虹┖锛堝簱鍐� 0锛屽畾绋� 16677.7/500锛夆啋 闇�琛ユ簮鏂囦欢銆�
+3. 鑽嗗窞/榛勭煶銆岃鍒掑唴/瑙勫垝澶栥�嶆媶鍒嗗彛寰勪笌瀹氱涓嶅悓锛堝悎璁′竴鑷达級銆�
+4. 涓彛寰勬帓鍚嶆畫宸潵鑷� 2025 骞寸綉绾﹁溅甯傚窞鍒嗘憡绠楁硶锛屾湭鎿呮敼锛屽緟纭銆�
+5. C 缁勶紙鍩庡競瀹㈣繍椤电粨鏋勫綊涓�锛岄渶鐢ㄦ埛鍏堝湪 WPS 鏁村垪鍒犻櫎 AJ 鍒楋級锛廌 缁勶紙澧為�熸帓鍚嶆帾杈烇級锛廈4锛堝鍑哄墠鍩烘暟浣撴 + 寮圭獥 + 銆婃暟鎹己澶辨竻鍗曘�嬮〉锛夊緟鎺掓湡銆�
+
+### 6.4 鏄庢棩璁″垝
+
+1. 钀藉疄姝︽眽鐗╂祦鏁版嵁鍙ｅ緞纭鍚庤ˉ瀵硷紱琛ュぉ闂ㄧ墿娴佹簮鏁版嵁銆�
+2. 鎺ㄨ繘 C/D 缁勪笌 B4銆�
+3. 浠ｇ爜锛氫粖鏅氭寜鐢ㄦ埛瑕佹眰**鍙帹涓汉 gitee**锛坄origin master`锛夛紝**涓嶆帹鍏徃 gitea**銆�
\ No newline at end of file
diff --git "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\344\270\255\345\217\243\345\276\204\346\216\222\345\220\215\345\220\214\346\257\224\344\270\216\345\237\216\345\270\202\345\256\242\350\277\220\345\210\227\351\224\231\344\275\215_\346\240\271\345\233\240\344\270\216\351\225\277\346\225\210\346\226\271\346\241\210_2026-09-18.md" "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\344\270\255\345\217\243\345\276\204\346\216\222\345\220\215\345\220\214\346\257\224\344\270\216\345\237\216\345\270\202\345\256\242\350\277\220\345\210\227\351\224\231\344\275\215_\346\240\271\345\233\240\344\270\216\351\225\277\346\225\210\346\226\271\346\241\210_2026-09-18.md"
new file mode 100644
index 0000000..c4091d1
--- /dev/null
+++ "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\344\270\255\345\217\243\345\276\204\346\216\222\345\220\215\345\220\214\346\257\224\344\270\216\345\237\216\345\270\202\345\256\242\350\277\220\345\210\227\351\224\231\344\275\215_\346\240\271\345\233\240\344\270\216\351\225\277\346\225\210\346\226\271\346\241\210_2026-09-18.md"
@@ -0,0 +1,195 @@
+# 涓彛寰勬帓鍚嶃�屽悓姣斾笉瀵广��+ 鍩庡競瀹㈣繍椤靛垪閿欎綅锛氭牴鍥犱笌闀挎晥鏂规锛�2026-09-18锛�
+
+> 缁撹鍏堣锛�
+> 1. **涓彛寰勬帓鍚嶇殑澧為�熼敊锛屼笉鏄叕寮忛敊锛屾槸銆屽幓骞村悓鏈熷熀鏁版畫缂轰篃鐓х畻銆嶃��** 2025 骞翠笁澶勬暟鎹己澶�/姹℃煋锛岃闈欓粯褰撴垚 0 鎴栭敊鍊硷紝鍏ㄧ渷 1-8 鏈堝熀鏁板彧鏈� 18131.0锛堝簲涓� 29796.71锛夛紝鎵�浠� 2026 绱鍚屾瘮绠楀嚭 **+73.89%**锛堢湡鍊� **+5.81%**锛夛紝銆屽閫熸帓鍚嶃�嶆暣鍧椾笉鍙俊銆�
+> 2. **鏂规涓�锛堟妸鍩庡競瀹㈣繍 T 鍒楀垎姣� AJ 鏀规垚 AK锛夐暱杩滀笉鍙**锛氬畠鍙銆�8 鏈堛�嶈繖涓�涓姤琛ㄦ湡鎴愮珛锛�9 鏈堟姤琛ㄦ湡瑕� 1-9 鏈堢疮璁★紝鍒嗘瘝杩樺緱鍐嶆墜鏀规瘝鐗堚�斺�旀鏄娑堢伃鐨勩�屾瘡鏈堟敼妯℃澘銆嶃��
+> 3. 姝ｇ‘鍋氭硶鏄笁鏉¤吙涓�璧锋敼锛�**鏁版嵁琛ュ叏锛堟不鏈級锛� 鍚屾瘮璁＄畻甯﹀畬澶囨�ф牎楠岋紙闃插鍙戯級锛� 鍩庡競瀹㈣繍椤电粨鏋勫綊涓�锛堝幓鐗逛緥锛�**銆�
+
+璇佹嵁鏂囦欢锛歚_tmp\_qa_out\step3g_summary.xlsx`銆乣step3g_midRank.xlsx`銆乣step3g_midDetail.xlsx`銆乣_now_rank.txt`銆乣_ding_rank.txt`銆乣_ding_mid_head.txt`銆乣_mother_rank.txt`銆�
+涓氬姟鍩虹嚎锛堜汉宸ュ畾绋匡級锛歚D:\05_鏁版嵁鍒嗙被\姹囨�昏〃\8鏈堟眹鎬诲畾绋縗2026骞�8鏈堝杩愰噺銆佽揣杩愰噺瀹氱.xlsx`銆�
+
+---
+
+## 涓�銆佷腑鍙ｅ緞鎺掑悕鍚屾瘮涓轰粈涔堜笉瀵癸紙宸查�愰」楠岃瘉锛�
+
+### 1.1 鐜拌薄锛�2026-08 鎶ヨ〃鏈燂級
+
+| 浣嶇疆 | 绋嬪簭绠楀嚭 | 瀹氱/姝ｇ‘鍊� | 鍋忓樊 |
+|---|---|---|---|
+| 绱鍧� 鍏ㄧ渷 鍚屾瘮锛圡3锛� | **+73.89%** | **+5.81%** | 宸� 68 涓櫨鍒嗙偣 |
+| 绱鍧� 姝︽眽 鍚屾瘮锛圡4锛� | **+12.07%** | **+4.65%** | 宸� 7.4 涓櫨鍒嗙偣 |
+| 绱鍧� 榛勭煶 | **+105.41%** | +7.85% | 鈥� |
+| 绱鍧� 鍗佸牥 | **+192.30%** | +2.17% | 鈥� |
+| 绱鍧� 瑗勯槼 | **+107.07%** | +5.63% | 鈥� |
+| 绱鍧� 鍜稿畞 | **+189.54%** | +17.00% | 鈥� |
+| 绱鍧� 娼滄睙 | **+766.85%** | 鈭�2.86% | 鈥� |
+| 褰撴湀鍧� 鍏ㄧ渷 鍚屾瘮锛圡24锛� | **+67.63%** | 鈭�0.67% | 鈥� |
+
+**鍊兼湰韬槸瀵圭殑**锛堢疮璁� 31528.0607銆佸綋鏈� 4003.5701 涓庡畾绋垮畬鍏ㄤ竴鑷达級锛�**鍙湁鍚屾瘮閿�** 鈥斺�� 杩欐鏄�屽垎瀛愬銆佸垎姣嶆畫銆嶇殑鍏稿瀷鐗瑰緛銆�
+
+### 1.2 鍩烘暟璐︼紙鍐冲畾鎬ц瘉鎹級
+
+瀹氱 2025 骞� 1-8 鏈堜腑鍙ｅ緞绱 = **29796.71**锛堜竾鍏冧汉娆★級锛岄�愰」锛�
+
+| 缁村害 | 1鏈� | 2鏈� | 3鏈� | 4鏈� | 5鏈� | 6鏈� | 7鏈� | 8鏈� | 1-8鏈堝悎璁� |
+|---|---|---|---|---|---|---|---|---|---|
+| 鍏矾鐝嚎 | 1688.1442 | 1719.8742 | 1721.8891 | 1824.67 | 1811.8188 | 1718.0442 | 1781.8881 | 1784.7773 | 14051.1159 |
+| 鍩庨檯鍩庝埂鍏氦 | 1143.83 | 1146.53 | 1242.29 | 1288.71 | 1385.12 | 1377.95 | 1344.24 | 1350.08 | **10278.75** |
+| 鍩庨檯鍩庝埂宸℃父鍑虹 | 409.54 | 448.64 | 417.98 | 429.77 | 494.11 | 438.88 | 566.86 | 603.64 | 3809.42 |
+| 鍩庨檯鍩庝埂缃戠害杞� | 142.54 | 152.48 | 167.08 | 194.78 | 230.58 | 206.93 | 271.02 | 292.02 | **1657.43** |
+| **鍚堣** | 3384.0542 | 3467.5242 | 3549.2391 | 3737.93 | 3921.6288 | 3741.8042 | 3964.0081 | 4030.5173 | **29796.71** |
+
+绋嬪簭瀹為檯鐢ㄥ埌鐨勫熀鏁� = 31528.0606 / 1.7389 = **18131.0**銆�
+
+宸 11665.7 = 10278.75锛堝叕浜わ級+ 1514.89锛堢綉绾﹁溅 2-8 鏈堬級鈭� 127.98锛堝嚭绉� 6 鏈堝绠楋級鈫� 瀹屽叏瀵瑰緱涓娿��
+
+### 1.3 涓夊鏁版嵁缂洪櫡锛堥�愭潯宸叉煡瀹烇級
+
+**缂洪櫡鈶� `city_bus_monthly.passenger_chengxiang` 鍦� 2025 骞村叏閮ㄤ负 0/璐�**
+
+```sql
+SELECT report_period, SUM(passenger_chengxiang), SUM(passenger_volume-passenger_city)
+FROM city_bus_monthly WHERE report_period LIKE '2025-%' GROUP BY report_period;
+-- 2025-01: -0.341 vs 1143.83 鈫� 瀛樺偍鍒楁槸 0锛屽疄闄呭簲涓� 1143.83
+-- 2025-08: -0.114 vs 1350.08
+-- 2026-01: 1391.19 vs 1391.19 鈫� 2026 姝ｅ父
+```
+
+- 鍚庢灉锛氫腑鍙ｅ緞鍏氦缁村害 2025 鍏ㄥ勾涓� 0 鈫� 1-8 鏈堝皯 10278.75 涓囦汉娆★紱瀵煎嚭鐨勩�屼腑鍙ｅ緞鏄庣粏銆嶅叕浜ょ疮璁″悓姣旂洿鎺ョ畻鎴� **鈭�28577.71%**锛堝垎姣� 鈭�0.407锛夈��
+- 鍏滃簳鍏崇郴宸查獙璇侀�愭湀涓庡畾绋夸竴鑷达細**鍩庨檯鍩庝埂 = 鎬诲杩愰噺 鈭� 鍩庡競鍐呭杩愰噺**锛堜緥锛�2025-01 15079.24鈭�13935.41=1143.83 鉁擄級銆�
+
+**缂洪櫡鈶� `wyc_order_monthly.pin_*` 鍦� 2025-02~08 涓� NULL**
+
+```sql
+SELECT report_period, pin_k FROM wyc_order_monthly WHERE report_period LIKE '2025%';
+-- 2025-01: 2467.79
+-- 2025-02 .. 2025-08: NULL 鈫� 缂�
+-- 2025-09 .. 2025-12: 鏈夊��
+-- 2025-01 鐨� 2467.79 涓� wyc_total_monthly 瀹屽叏鐩稿悓锛堝悓婧愶級
+```
+
+- `WycSplitCalc.loadMonthlyInputFromDb()` 鍙璁㈠崟琛ㄧ殑 pin 鍒楋紙`WycSplitCalc.java:258-261`锛夛紝pin 璇绘垚 0 鈫� `calc()` 鍦� `WycSplitCalc.java:100-102` 鎶涘紓甯� 鈫� `loadMidClassMap()` 鐨� `catch` 鐩存帴 `continue`锛坄ReportExportService.java:2429-2431`锛夆啋 璇ユ湀缃戠害杞︾淮搴︽暣鏈堜涪澶便��
+- 鍚庢灉锛氱綉绾﹁溅鍩庝埂 2025 鍙畻浜� 1 鏈堬紙142.54锛夛紝2-8 鏈堢己澶� 1514.89 涓囦汉娆°��
+- 鍙︽敞锛歚wyc_total_monthly`锛坧in 涓撹〃锛夐噷 2025-02~08 **鏁版嵁鏄叏鐨�**锛屽彧鏄病鍚屾鍒拌鍗曡〃銆�
+
+**缂洪櫡鈶� `city_taxi_monthly` 2025-06 鏄� 2025-07 鐨勫壇鏈�**
+
+```sql
+-- 閫愬競宸炴瘮瀵� 2025-06 涓� 2025-07锛�17 涓競宸炲杩愰噺/鍛ㄨ浆閲� 瀹屽叏閫愬�肩浉鍚�
+-- 鍏ㄧ渷 2025-06 绋嬪簭鍊� 566.86锛屽畾绋� 438.88锛屽绠� 127.98
+```
+
+- 灞炰簬閲嶅瀵煎叆/閿欐湡瀵煎叆锛岄渶瑕佺敤姝ｇ‘鐨� 6 鏈堟簮鏂囦欢閲嶅銆�
+
+### 1.4 宸叉帓闄ょ殑璇垽
+
+- 姣嶇増/瀹氱鐨勪腑鍙ｅ緞鍏紡**娌℃湁閿�**锛堟棭鍓嶃�屽紩閿欓〉銆嶆槸鎺у埗鍙颁腑鏂囦贡鐮佽鍒わ級銆�
+- `loadMidClassMap()` 鐩墠**鍥涚淮閮藉湪**锛堢彮绾� / 鍏氦 / 宸℃父鍑虹 / 缃戠害杞︼紝`ReportExportService.java:2351-2437`锛夛紱浠婃棩銆婃眹鎬昏〃涓夋潯涓荤嚎淇鏂规銆嬮噷銆屽彧瑁呬簡鐝嚎+鍏氦涓ょ淮銆嶇殑璇存硶宸茶繃鏈熴��
+- `涓彛寰勬帓鍚峘 鐨勫彇鍊煎彛寰勶紙缁村害 0 = 鍥涚淮鍚堣锛�**涓庡畾绋夸竴鑷�**锛屾棤闇�鏀瑰彛寰勩��
+
+---
+
+## 浜屻�佸煄甯傚杩愰〉鍒楅敊浣嶏紙涓庢柟妗堜竴鐩稿叧锛�
+
+### 2.1 姣嶇増鐜扮姸锛坄docs\鐢熸垚姹囨�诲ぇ琛╘2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` 鈫� 鍩庡競瀹㈣繍椤碉紝绗� 2 琛岃〃澶达級
+
+| 鍒� | 琛ㄥご | 璇存槑 |
+|---|---|---|
+| V/X/Z/AB | 2025骞�1鏈�/2鏈�/3鏈�/4鏈� | 鏂囧瓧姝ｅ父 |
+| **AD / AF / AH** | **45778 / 45809 / 45839** | **鏃ユ湡搴忓垪鍙�**锛屼笉鏄��2025骞�5/6/7鏈堛�� |
+| **AJ** | **2025骞�1-7鏈堢疮璁�** | **澶瑰眰杈呭姪鍒楋紝鎻掑湪浜� 2025 鏈堝害鍧椾腑闂�** |
+| **AK** | **45870** | **鏃ユ湡搴忓垪鍙�**锛屾墠鏄湡姝ｇ殑銆�2025骞�8鏈堛�� |
+| AL | 8鏈堝悓姣� | 瀵瑰簲 AK |
+
+2026 渚у悓鏍疯剰锛欸/I/K/M/O/Q = 46082 / 46113 / 46143 / 46174 / 46204 / 46235锛堟棩鏈熷簭鍒楀彿锛夈��
+
+绱鍚屾瘮鍏紡锛�
+
+```
+鍩庡競瀹㈣繍!T4 = S4/(V4+X4+Z4+AB4+AD4+AF4+AH4+AJ4)-1 鈫� 鍒嗘瘝 = (1-7鏈�) + (1-7鏈堢疮璁�) = 2脳(1-7鏈�)
+鍏跺畠 8 椤�!T4 = S4/SUM(V4+X4+Z4+AB4+AD4+AF4+AH4+AJ4)-1 鈫� 鍒嗘瘝 = 1-8鏈堢疮璁★紝姝ｇ‘
+```
+
+鍗筹細**鍙湁鍩庡競瀹㈣繍椤�**鍥犱负 AJ 澶瑰眰鍒楋紝鍒嗘瘝灏戜簡銆�2025骞�8鏈堛�嶃��
+
+### 2.2 涓轰粈涔堛�屾柟妗堜竴銆嶉暱杩滀笉琛�
+
+| # | 闂 | 璇存槑 |
+|---|---|---|
+| 1 | **鍙 8 鏈堟垚绔�** | 9 鏈堟姤琛ㄦ湡瑕� 1-9 鏈堢疮璁★紝鍒嗘瘝闇�鍐嶅姞 AM锛堢湡姝� 2025骞�9鏈堬級锛�10 鏈堝啀鍔犫�︹�︽瘡涓湀閮借鎵嬫敼姣嶇増鍏紡銆傝繖灏辨槸銆屾瘡涓湀鍋氭ā鏉裤�嶇殑鍙樹綋銆� |
+| 2 | **澶瑰眰鍒椾細璁╂墍鏈夈�屾寜鍒楀簭鍙枫�嶇殑澶勭悊鏁翠綋閿欎綅 1 鍒�** | `applySummaryReferenceLayout()`锛坄ReportExportService.java:3535`锛夋槸鎸�**鍒楀簭鍙�**濂楃敤鍒楀/闅愯棌鏍囪鐨勩�備綘宸茬粡鍦ㄥ弬鐓т欢閲屽垹鎺� AJ 鈫� 鐢熸垚浠朵粠 AJ 涔嬪悗鎵�鏈夊垪鐨勫垪瀹�/闅愯棌鏍囪閮介敊浣嶃�� |
+| 3 | **琛ㄥご鏈韩涓嶆槸鏂囧瓧** | AD/AF/AH/AK 鏄棩鏈熷簭鍒楀彿锛屼换浣曘�屾寜琛ㄥご鏂囧瓧鍖归厤鍒椼�嶇殑闀挎晥鏂规鍦ㄨ繖涓〉浼氱洿鎺ュけ鏁堛�傛墍浠ュ繀椤诲厛瑙勮寖琛ㄥご銆� |
+| 4 | **鍙傜収浠朵笌姣嶇増缁撴瀯涓嶄竴鑷�** | 鍒� AJ 鍚庯紝鍙傜収浠� 36 涓� `#REF!`锛圱4:T39锛夛紝鍒楀鏄犲皠鍩哄噯涔熷彉浜嗐�� |
+
+---
+
+## 涓夈�侀暱鏁堟柟妗�
+
+### A. 鏁版嵁渚э紙娌绘湰锛屼竴娆″仛瀹岋級
+
+| # | 鍔ㄤ綔 | 鍏蜂綋鍋氭硶 | 楠屾敹 |
+|---|---|---|---|
+| A1 | 鍥炲～ 2025 鍏ㄥ勾鍏氦銆屽煄闄呭煄涔°�� | `UPDATE city_bus_monthly SET passenger_chengxiang = passenger_volume - passenger_city WHERE report_period LIKE '2025-%' AND (passenger_chengxiang IS NULL OR passenger_chengxiang <= 0)`锛涘懆杞噺鍚屾硶 | 2025 鍚勬湀鍏ㄧ渷 = 1143.83/1146.53/1242.29/1288.71/1385.12/1377.95/1344.24/1350.08鈥� |
+| A2 | 鍥炲～ 2025-02~08 缃戠害杞� pin | 浠� `wyc_total_monthly` 鍚屾 pin_k/pin_ck/pin_z/pin_cz 鍒� `wyc_order_monthly` 鍚屾湡 | 2025 鍏ㄥ勾 pin 榻愬叏 |
+| A3 | 閲嶅 2025-06 鍑虹 | 鐢ㄦ纭殑 6 鏈堟簮鏂囦欢閲嶅 `city_taxi_monthly` 2025-06 | 鍏ㄧ渷 = 438.88锛堢幇 566.86锛� |
+
+### B. 浠ｇ爜渚э紙闃插鍙戯紝鏍稿績鏄�屼笉榻愬叏灏变笉绠椼�嶏級
+
+| # | 鏀瑰姩鐐� | 鍐呭 |
+|---|---|---|
+| B1 | `loadMidClassMap()` dim2 | 瀛樺偍鐨勩�屽煄闄呭煄涔°�嶁墹0 鏃讹紝鐢� `鎬婚噺 鈭� 鍩庡競鍐卄 鍏滃簳锛坄city_bus_monthly` 涓�琛屽唴鐩稿噺鍚庡啀绱姞锛� |
+| B2 | `WycSplitCalc.loadMonthlyInputFromDb()` | 璁㈠崟琛� pin 鍏ㄧ┖鏃跺洖钀� `wyc_total_monthly`锛堟湰渚� 2025-02~08 鍗冲彲鑷姩淇ソ锛夛紱涓よ竟閮界己鎵嶆姏寮傚父 |
+| B3 | `midCumClass()` / `midClassVal()` | 杩斿洖鍊兼敼涓恒�屽�� + 鍛戒腑鏈堜唤鏁般�嶏紱**鍚屾瘮鍙湪銆屽幓骞村悓鏈堥綈鍏ㄣ�嶆椂璁＄畻**锛屼笉榻愬叏涓�寰嬬暀绌猴紙鐜板湪缂烘湀琚潤榛樺綋 0 鈫� 鍩烘暟鍙樺皬 鈫� 鍚屾瘮铏氶珮锛� |
+| B4 | 瀵煎嚭鍓嶇疆銆屽熀鏁颁綋妫�銆� | 涓夋潯瑙勫垯锛氣憼鍘诲勾鍚屾湀璇ョ淮搴�=0锛涒憽鏌愭湀閫愬競宸炲�间笌鐩搁偦鏈堝畬鍏ㄧ浉鍚岋紙閲嶅瀵煎叆鐗瑰緛锛夛紱鈶㈠幓骞村悓鏈堝競宸炶鏁� < 17銆傚懡涓垯锛氬啓鍚庣鏃ュ織 + 椤甸潰寮圭獥 + 鐢熸垚浠堕檮涓�寮犮�婃暟鎹己澶辨竻鍗曘�嬮〉 |
+| B5 | 鏃ュ織 | `loadMidClassMap()` 閲� `catch 鈫� continue` 鏀规垚璁板綍銆屾湡 + 寮傚父鍘熷洜銆嶆竻鍗曪紝闅忓鍑烘棩蹇楄緭鍑猴紙鐜板湪瀹屽叏闈欓粯锛� |
+
+### C. 缁撴瀯渚э紙鍩庡競瀹㈣繍椤靛綊涓�锛屾秷闄ょ壒渚嬶級
+
+| # | 鍔ㄤ綔 |
+|---|---|
+| C1 | 鎶� AJ锛�2025骞�1-7鏈堢疮璁★級**绉诲嚭 2025 鏈堝害鍧�**锛堝拰 U 鍒楄繖绫昏緟鍔╁垪鏀句竴璧凤紝鎴栫洿鎺ュ垹闄わ級锛屼娇鍩庡競瀹㈣繍椤� V..AJ = 2025骞�1鏈堚��8鏈堬紝涓庡叾瀹� 8 椤靛畬鍏ㄥ悓鏋勩��**鍦� WPS/Excel 閲屾暣鍒楀垹**锛岃鍏ㄨ〃寮曠敤鑷姩璋冩暣銆� |
+| C2 | 琛ㄥご鏂囧瓧鍖栵細G/I/K/M/O/Q銆丄D/AF/AH/AK 鐢辨棩鏈熷簭鍒楀彿鏀规垚銆�2026骞�3鏈堚�︺�嶃��2025骞�5鏈�/6鏈�/7鏈�/8鏈堛�� |
+| C3 | 绱鍚屾瘮鍒嗘瘝涓嶅啓姝诲垪娓呭崟锛氱敱绋嬪簭**姣忔鎸夎〃澶村畾浣嶃�屽幓骞� M 鏈堛�嶅垪**鍚庨噸鍐欏叕寮忥紙`=S4/SUM(V4:鍘诲勾M鏈堝垪4)-1`锛屾敞鎰忓彧绱姞濂囨暟鍒楋級锛�9 鏈�/10 鏈堣嚜鍔ㄨ窡鐫�璧帮紝姣嶇増涓嶇敤鍐嶅姩 |
+| C4 | `applySummaryReferenceLayout()` 鏀逛负**鎸夎〃澶存枃瀛楀尮閰嶅垪**鍐嶅鍒楀/闅愯棌锛涘弬鐓т欢鍔犲噺鍒椾笉鍐嶉敊浣� |
+
+### D. 鎶ヨ〃渚�
+
+| # | 鍔ㄤ綔 |
+|---|---|
+| D1 | 銆屽閫熸帓鍚嶃�嶅彧鍦ㄥ悓姣旈綈鍏ㄦ椂鎺掑悕锛涘惁鍒欒鍧楁爣娉ㄣ�屽幓骞村悓鏈熷熀鏁扮己澶憋紝鏆備笉鎺掑悕銆嶏紝閬垮厤鐢ㄥ亣澧為�熸帓鍑哄亣鍚嶆 |
+
+---
+
+## 鍥涖�侀獙鏀跺熀绾匡紙2026-08 鎶ヨ〃鏈燂紝涓彛寰勬帓鍚嶇疮璁″潡锛�
+
+| 甯傚窞 | 搴斾负锛堝畾绋匡級 | 鐜板湪锛堢▼搴忥級 |
+|---|---|---|
+| 鍏ㄧ渷 | +5.81% | **+73.89%** |
+| 姝︽眽 | +4.65% | **+12.07%** |
+| 榛勭煶 | +7.85% | **+105.41%** |
+| 鍗佸牥 | +2.17% | **+192.30%** |
+| 瀹滄槍 | 鈭�15.62% | +4.28% |
+| 瑗勯槼 | +5.63% | **+107.07%** |
+| 鑽嗗窞 | +36.30% | +42.74% |
+| 榛勫唸 | +7.64% | **+147.99%** |
+| 鍜稿畞 | +17.00% | **+189.54%** |
+| 鎭╂柦 | +13.78% | +55.88% |
+| 浠欐 | +17.23% | **+241.89%** |
+| 娼滄睙 | 鈭�2.86% | **+766.85%** |
+| 澶╅棬 | +8.99% | **+282.34%** |
+| 鏋楀尯 | 鈭�34.87% | 鈭�32.18% |
+
+鍏朵綑楠屾敹鐐癸細
+- `涓彛寰勬槑缁哷 鍏氦琛岀疮璁″悓姣斾笉鍐嶅嚭鐜� 鈭�28577% 杩欑鏁帮紱
+- `鍩庡競瀹㈣繍` 椤电疮璁″悓姣斾笌璇ラ〉銆屽煄甯傛眹鎬汇�嶅彛寰勪竴鑷达紙涓嶅啀鏄� 鈭�43% 瀵� +0.12%锛夛紱
+- 鐙珛瀵煎嚭鐨勩�婄敓鎴恄涓彛寰勬帓鍚嶃�嬩笌姹囨�诲ぇ琛ㄣ�屼腑鍙ｅ緞鎺掑悕銆嶉〉閫愭牸涓�鑷淬��
+
+---
+
+## 浜斻�佸缓璁墽琛岄『搴�
+
+1. **A1/A2/A3 鏁版嵁鍥炲～**锛堝崐灏忔椂鍐呭彲瀹屾垚锛屽仛瀹屼腑鍙ｅ緞鎺掑悕鍚屾瘮绔嬪嵆姝ｇ‘锛夛紱
+2. **B2銆丅1 浠ｇ爜鍏滃簳**锛堥槻姝㈠悓绫荤己澶卞啀娆￠潤榛樼敓鏁堬級锛�
+3. **B3銆丅4銆丅5 瀹屽鎬ф牎楠�**锛堥暱鏁堥槻澶嶅彂 + 鏃ュ織鍙锛夛紱
+4. **C1~C4 鍩庡競瀹㈣繍椤靛綊涓�**锛堟敼浜嗘瘝鐗堬紝闇�瑕佸拰涓氬姟纭鍚庝竴娆℃�у仛锛屾敼瀹� 9 鏈堟姤琛ㄦ湡涓嶇敤鍐嶆墜鏀癸級锛�
+5. **D1 鎶ヨ〃鎺緸**銆�
--
Gitblit v1.9.1