From b14fec1599277629e10b2bc686f02fd0c2e0bec1 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期五, 18 九月 2026 16:46:30 +0800
Subject: [PATCH] fix(货运月报): 订正持续在规企业累计运距同比基期口径（v2）

---
 docs/功能测试报告/功能测试报告_网约车订单报告WordML兼容导入_2026-09-18.md |   72 ++++++++++++++++++++++++++++++++++++
 1 files changed, 72 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_\347\275\221\347\272\246\350\275\246\350\256\242\345\215\225\346\212\245\345\221\212WordML\345\205\274\345\256\271\345\257\274\345\205\245_2026-09-18.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_\347\275\221\347\272\246\350\275\246\350\256\242\345\215\225\346\212\245\345\221\212WordML\345\205\274\345\256\271\345\257\274\345\205\245_2026-09-18.md"
new file mode 100644
index 0000000..4d97116
--- /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_\347\275\221\347\272\246\350\275\246\350\256\242\345\215\225\346\212\245\345\221\212WordML\345\205\274\345\256\271\345\257\274\345\205\245_2026-09-18.md"
@@ -0,0 +1,72 @@
+# 鍔熻兘娴嬭瘯鎶ュ憡_缃戠害杞﹁鍗曟姤鍛� WordML 鍏煎瀵煎叆_2026-09-18
+
+## 涓�銆佸姛鑳借鏄�
+
+**鑳屾櫙锛堢敤鎴锋姤闅滐級**锛氭妸銆婃箹鍖楃綉缁滈绾﹀嚭绉熸苯杞�2025骞�09鏈堝垎鏋愭姤鍛�.docx銆嬫斁鍒版闈㈠悗鐢ㄣ�岀綉绾﹁溅璁㈠崟鎶ュ憡銆嶅鍏ワ紝涓�鐩村け璐ャ��
+
+**瀹氫綅缁撹**锛氳鏂囦欢**涓嶆槸鐪熸鐨� docx**銆傚畠鏄� **Word 2003 XML锛圵ordML 骞抽摵 XML锛屽崟鏂囦欢锛�**琚敼鍚嶆垚浜� `.docx`锛�
+- 鏂囦欢澶存槸 `<?xml version="1.0" ...?> <?mso-application progid="Word.Document"?> <w:wordDocument xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml" ...>`
+- 3.1MB 绾� XML锛�**涓嶆槸 zip 鍖�**锛汸OI 鐨� `XWPFDocument` 鍙兘璇� OPC(zip) 鍖咃紝浜庢槸鎶� `File is not a zip file`銆�
+- 杩欑被鏂囦欢鏄� WPS/Word銆學ord 2003 XML 鏂囨。銆嶆牸寮忥紝缃戠害杞︾洃绠″钩鍙�/鍚屼簨涔嬮棿娴佽浆寰堝父瑙侊紝浼氬弽澶嶅嚭鐜般��
+
+**鏀瑰姩**锛歚traffic-audit-server/src/main/java/com/trafficaudit/dataimport/service/DataImportService.java`
+
+1. `importWycOrderReport()` 鍏ュ彛鍏堟寜鏂囦欢澶村梾鎺㈡牸寮忥紝鍐嶅垎娲撅細
+   - `PK` 寮�澶� 鈫� docx锛坺ip锛夛細鍘� `XWPFDocument` 璺緞锛�
+   - `<w:wordDocument` + `wordml` 鈫� **WordML 骞抽摵 XML锛氭柊澧炶В鏋愯矾寰�**锛�
+   - `D0CF11E0` 鈫� OLE2 鑰� `.doc`锛氱粰鍑恒�岃鍙﹀瓨涓� docx銆嶇殑鏄庣‘鎻愮ず锛�
+   - 鍏跺畠 鈫� 銆屾棤娉曡瘑鍒殑鏂囦欢鏍煎紡銆嶃��
+2. 鏂板 `isWordPackage()`锛歾ip 浣嗗寘鍐呮病鏈� `word/document.xml`锛堝 xlsx 鏀瑰悕锛夋椂锛岀洿鎺ユ彁绀恒�岃繖涓嶆槸 Word 鏂囨。鈥︹�﹀鍗婃槸 Excel 鎴栧叾瀹冩牸寮忋�嶏紝涓嶅啀鎶涘嚭 XMLBeans 鐨勮嫳鏂囧爢鏍堛��
+3. 鏂板 `parseXmlSafely()`锛欴OM 瑙ｆ瀽骞�**鍏抽棴澶栭儴瀹炰綋/DTD**锛堟姤鍛婃潵鑷閮ㄥ钩鍙帮紝闃� XXE锛夈��
+4. 琛ㄦ牸鍖归厤閫昏緫鎶芥垚涓庢牸寮忔棤鍏崇殑 `matchWycOrderTable(tables, orders, sumHolder)`锛�
+   - docx 璺緞鎶� `XWPFTable` 鏂囨湰鍖栧悗璋冪敤锛�
+   - WordML 璺緞鎶� `<w:tbl>/<w:tr>/<w:tc>` 鏂囨湰鍖栧悗璋冪敤锛�
+   - 琛ㄥご璇嗗埆銆�17 甯傚窞鍙栧�笺�佸悎璁¤璇嗗埆**瀹屽叏澶嶇敤鍚屼竴濂楅�昏緫**锛屼袱鏉¤矾寰勪笉浼氬嚭鐜板彛寰勫垎鍙夈��
+5. 鎶ヨ〃鏈熻瘑鍒娊鎴� `periodOfParagraphs(List<String>)`锛屼袱绉嶆牸寮忓叡鐢紙鏍囬 `缃戠害杞﹁涓歒YYY骞碝鏈坄 浼樺厛锛屽彇涓嶅埌鍥為��銆屽墠 10 娈典换鎰� YYYY骞碝鏈堛�嶏級銆�
+
+## 浜屻�佹祴璇曠幆澧�
+
+- 鍚庣 8090锛坄mvn -o compile` 鍚庨噸鍚紝鍔犺浇鏂扮被锛涘惎鍔ㄦ棩蹇� `Started TrafficAuditApplication`锛夛紱鏁版嵁搴� `traffic_audit`锛�127.0.0.1:3308锛夈��
+- 鎺ュ彛锛歚POST /api/import/wycOrderReport`锛坄file` + `period`锛宍period` 鍙负绌� 鈫� 鐢辨姤鍛婃爣棰樻帹鏂級銆�
+- 娴嬭瘯鏂囦欢锛歚D:\妗岄潰\婀栧寳缃戠粶棰勭害鍑虹姹借溅2025骞�09鏈堝垎鏋愭姤鍛�.docx`锛圵ordML锛�3,145,560 瀛楄妭锛夛紱`D:\05_鏁版嵁鍒嗙被\鍩庡競瀹㈣繍\8鏈圽婀栧寳缃戠粶棰勭害鍑虹姹借溅2026骞�08鏈堝垎鏋愭姤鍛�0910鏈�缁堢増.docx`锛堢湡 docx锛夈��
+- 璇佹嵁鏂囦欢锛歚_tmp/_qa_out/`锛堝懡浠よ緭鍑鸿鏈姤鍛婅〃鏍硷紱鏁版嵁鏍稿瑙� `_wyc_2025_09_row.txt`锛夈��
+
+## 涓夈�佺敤渚嬭〃
+
+| 缂栧彿 | 绫诲瀷 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 |
+|---|---|---|---|---|---|
+| 1 | 姝ｅ悜 | WordML銆�2025骞�09鏈堛�嶆姤鍛婏紝`period=2025-09` | 瑙ｆ瀽鍑� 17 甯傚窞璁㈠崟锛屽啓鍏� 2025-09 | `瀵煎叆鎴愬姛锛氭姤琛ㄦ湡 2025-09锛岃鍗曞悎璁� 17,652,159 鍗曪紝宸插啓鍏� 17 涓競宸瀈 | 閫氳繃 |
+| 2 | 姝ｅ悜 | 鍚屼笂锛宍period=` 鐣欑┖ | 鐢辨爣棰� `缃戠害杞﹁涓�2025骞�9鏈坄 鎺ㄦ柇鍑� 2025-09 | 鎶ヨ〃鏈� 2025-09锛岀粨鏋滀笌鐢ㄤ緥 1 涓�鑷� | 閫氳繃 |
+| 3 | 姝ｅ悜 | 鐪� docx銆�2026骞�08鏈堛�嶆姤鍛婇噸瀵� | 涓庡簱鍐呮棦鏈夊�间竴鑷达紙骞傜瓑锛屼笉鏀瑰彉缁撴灉锛� | 璁㈠崟鍚堣 30,508,652銆佹姹� 11,550,551锛屼笌瀵煎叆鍓嶅畬鍏ㄧ浉鍚� | 閫氳繃 |
+| 4 | 姝ｅ悜 | 2026骞�06鏈堟姤鍛� | 璁㈠崟鍚堣 = 鎶ュ憡姝ｆ枃銆屽叏鐪佽鍗曟�绘暟 2684.30 涓囧崟銆� | 搴撳唴 2026-06 = 26,843,037 | 閫氳繃 |
+| 5 | 璐熷悜 | `.doc`锛圤LE2 澶嶅悎鏂囨。锛學ord 97-2003锛� | 鏄庣‘鎻愮ず鏀圭敤 docx | `杩欐槸 Word 97-2003 鑰佹牸寮忥紙.doc锛夛紝璇风敤 WPS/Word 鎵撳紑鍚庛�屽彟瀛樹负銆峝ocx 鏍煎紡鍐嶅鍏 | 閫氳繃 |
+| 6 | 璐熷悜 | xlsx 鏀瑰悕鎴� `.docx` 涓婁紶 | 鏄庣‘鎻愮ず涓嶆槸 Word | `杩欎笉鏄� Word 鏂囨。锛堝帇缂╁寘閲屾病鏈� word/document.xml锛夛紝澶氬崐鏄� Excel 鎴栧叾瀹冩牸寮忊�︹� | 閫氳繃 |
+| 7 | 璐熷悜 | 闈炵綉绾﹁溅鎶ュ憡鐨� docx锛堛�婃姇璧勮〃涔嬮棿鐨勫叧绯�.docx銆嬶級 | 鎻愮ず鏈В鏋愬埌璁㈠崟鏁� | `鏈В鏋愬埌浠讳綍甯傚窞璁㈠崟鏁帮紝璇风‘璁や笂浼犵殑鏄�婄綉绾﹁溅琛屼笟YYYY骞碝鏈堣繍琛岀洃娴嬫儏鍐靛垎鏋愭姤鍛娿�媊 | 閫氳繃 |
+| 8 | 杈圭晫 | WordML 涓〃鏍煎惈 16 鍒椼�佽〃澶村湪绗� 1 琛屻�佸競宸炲悕鐢ㄧ畝绉帮紙`姝︽眽`/`鏋楀尯`锛� | 绠�绉拌兘鏄犲皠鍒拌鑼冨悕锛堟姹夊競/绁炲啘鏋舵灄鍖猴級 | 17 甯傚窞鍏ㄩ儴璇嗗埆锛屾棤缂哄け | 閫氳繃 |
+
+**鍏ュ簱鎶芥煡**锛堟姤琛ㄦ湡 2025-09锛屼笌鎶ュ憡闄勪欢1閫愰」瀵归綈锛�
+
+| 椤� | 鎶ュ憡闄勪欢1 | 搴撳唴 `wyc_order_monthly` | 缁撹 |
+|---|---|---|---|
+| 璁㈠崟鍚堣 | 17,652,159 | 17,652,159 | 涓�鑷� |
+| 姝︽眽 | 8,076,610 | 8,076,610 | 涓�鑷� |
+| 榛勭煶 | 676,644 | 676,644 | 涓�鑷� |
+| 鍗佸牥 | 1,048,593 | 1,048,593 | 涓�鑷� |
+| 鎭╂柦 | 804,736 | 804,736 | 涓�鑷� |
+| 绁炲啘鏋舵灄鍖� | 1,424 | 1,424 | 涓�鑷� |
+| 鍏ㄧ渷 pin锛圔~E锛� | 鎶ュ憡鏃� | 2794.31 / 2522.54 / 16394.73 / 12998.74锛堜粠 `wyc_total_monthly` 鍚屾湡澶嶅埗锛� | 绗﹀悎璁捐 |
+
+## 鍥涖�佸彂鐜扮殑闂涓庡缃�
+
+1. **鏍煎紡鍏煎缂哄彛锛堟湰娆′慨澶嶏級**锛歐ordML 鎶ュ憡鏃犳硶瀵煎叆銆傚凡鍔犺В鏋愯矾寰勶紱涓ょ鏍煎紡鍏辩敤鍚屼竴濂楄〃鏍煎尮閰嶉�昏緫锛岄伩鍏嶅彛寰勫垎鍙夈��
+2. **閿欒淇℃伅涓嶅弸濂斤紙鏈淇锛�**锛歺lsx 鏀瑰悕鍚庢姤 `org.apache.xmlbeans.XmlException: Element workbook@... is not a valid document@...`銆傚凡鏀逛负涓枃涓氬姟鎻愮ず銆�
+3. **20XX 骞村墠鍚庢姤鍛婃爣棰樻牸寮忎笉鍚�**锛�2025 骞存姤鍛婃爣棰樻槸銆屾箹鍖�**缃戠害杞﹁涓� 2025骞�9鏈�** 杩愯鎯呭喌鍒嗘瀽鎶ュ憡銆嶏紝2026 骞存槸銆岀綉绾﹁溅琛屼笟2026骞�6鏈堣繍琛岀洃娴嬫儏鍐靛垎鏋愭姤鍛娿�嶃�傚悓涓�濂楁鍒欏潎鍙懡涓紝鏃犻渶鍐嶆敼銆�
+4. **鏁版嵁缂哄彛宸茬敱鐢ㄦ埛琛ラ綈**锛�2026-01~06锛�14:21 瀵煎叆 6 浠斤級銆�2025-01锛�14:47锛夈��2025-10~12锛�14:49锛夊潎宸插叆搴擄紱2025-09 鐢辨湰娆′慨澶嶅悗琛ュ叆锛�14:59 棣栨銆�15:04 澶嶆牳锛夈��
+   - 鍏ㄩ儴 2025-01~12銆�2026-01~08 鐨勮鍗曚笌 pin 鐜板凡榻愬叏銆�
+   - 褰卞搷锛氫腑鍙ｅ緞缁村害 4锛堝煄闄呭煄涔＄綉绾﹁溅锛�1~6 鏈堢敱銆屾棤婧愩�嶅彉涓恒�屽彲绠椼�嶏紝**涓彛寰勬帓鍚嶄欢涓庝腑鍙ｅ緞鏄庣粏浠剁疮璁″彛寰勮嚜鍔ㄥ綊涓�**锛堟鍓嶅樊鍊� 2063.45 = 1~6 鏈堢綉绾﹁溅鍩庝埂锛夈��
+
+## 浜斻�佺粨璁�
+
+- WordML锛圵ord 2003 XML 鏀瑰悕 .docx锛夋姤鍛婄幇宸插彲鐩存帴瀵煎叆锛�17 甯傚窞 + 鍚堣瑙ｆ瀽姝ｇ‘銆佸叆搴撻�愰」瀵归綈锛涚湡 docx 璺緞鏃犲洖褰掋��
+- 3 鏉¤礋鍚戠敤渚嬪潎缁欏嚭涓枃鍙搷浣滄彁绀猴紙.doc / 闈� Word 鍖� / 闈炴湰鎶ュ憡锛夈��
+- 8 渚嬬敤渚嬪叏閮ㄩ�氳繃锛沗docs/鍔熻兘娴嬭瘯鎶ュ憡/` 涓嬪凡褰掓。鏈姤鍛娿��

--
Gitblit v1.9.1