From 49fea21571a4060aa8570cbf220088352e2ccf15 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期三, 16 九月 2026 17:33:01 +0800
Subject: [PATCH] docs(工作日结): 补记 2026-09-16 收工记录（origin 已推 80e0879、gitea 仍不通、未提交项与明日计划）

---
 docs/问题汇总/问题与注意事项汇总_2026-09-16.md |  289 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 289 insertions(+), 0 deletions(-)

diff --git "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md" "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md"
new file mode 100644
index 0000000..a4ecacb
--- /dev/null
+++ "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\351\227\256\351\242\230\344\270\216\346\263\250\346\204\217\344\272\213\351\241\271\346\261\207\346\200\273_2026-09-16.md"
@@ -0,0 +1,289 @@
+# 浜ら�氳揣杩愮粺璁″鏍哥郴缁� 鈥� 闂涓庢敞鎰忎簨椤规眹鎬�
+
+> 鐢ㄩ�旓細鎶婇」鐩繍琛屻�佹暟鎹鍏ャ�佹姤琛ㄧ敓鎴愩�佷粨搴撳崗浣滀腑鎵�鏈夈�岃俯杩囩殑鍧戙�嶉泦涓褰曪紝渚涘悗缁紑鍙戜笌杩愮淮蹇�熸煡闃呫��
+> 缁存姢鏂瑰紡锛氭柊鍙戠幇闂璇风洿鎺ュ湪鏈枃浠惰拷鍔狅紝骞舵敞鏄庢棩鏈熴��
+> 鏈�鍚庢洿鏂帮細2026-09-16
+
+---
+
+## 涓�銆侀�熸煡琛紙鏈�甯歌鐨� 10 鏉★級
+
+| # | 浜嬮」 | 姝ｇ‘鍋氭硶 |
+|---|------|----------|
+| 1 | 鍚姩鍓嶅悗绔� | 椤圭洰鏍圭洰褰曟墽琛� `powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1` |
+| 2 | 绔彛鍗犵敤鍒ゆ柇 | 鐪� `backend.log` / `traffic-audit-web/frontend.log`锛�**涓嶈**渚濊禆 `Get-NetTCPConnection` |
+| 3 | 鍚庣灏辩华鏍囧織 | 鏃ュ織鍑虹幇 `Started TrafficAuditApplication` + `Tomcat started on port(s): 8090` |
+| 4 | 鍓嶇灏辩华鏍囧織 | 鏃ュ織鍑虹幇 `Compiled successfully` + `App running at:` |
+| 5 | 杩炴暟鎹簱 | `mysql.exe --host=127.0.0.1 --port=3308 --user=root --default-character-set=utf8mb4 -D traffic_audit` |
+| 6 | 鍋滄棫杩涚▼ | 鎸� PID 绮剧‘鍋� `cmd 鈫� java(maven) 鈫� java(app)` 閾撅紱**涓嶈鏉� node_repl 鍜岀敤鎴疯嚜宸辩殑 cmd 绐楀彛** |
+| 7 | 鑴氭湰鎶ャ�屽凡娣诲姞浜嗗叿鏈夌浉鍚岄敭鐨勯」銆� | 鏈満鍚屾椂瀛樺湪 `Path` 涓� `PATH`锛屾敼鐢� `cmd.exe /c ... > log 2>&1`锛�**涓ョ鐢� `Start-Process`** |
+| 8 | 鍐欎腑鏂囨枃浠� | 鐢� UTF-8锛沗main.js` 甯� BOM 蹇呴』鍐欏洖 BOM锛涙敼鏂囦欢鍓嶅厛纭鍘熸枃浠舵槸 CRLF 杩樻槸 LF |
+| 9 | 鎻愪氦鍓� | 鍏堟祴璇� + 鍐欍�婂姛鑳芥祴璇曟姤鍛娿��+ 鏇存柊銆婂伐浣滄棩缁撱�嬶紝鍐� fetch/鍚堝苟/鎺ㄩ�� |
+| 10 | 鎺ㄥ叕鍙� gitea | 鍏� `git fetch gitea` 涓庤繙绔� `main` 鍚堝苟锛�**绂佹寮烘帹** |
+
+---
+
+## 浜屻�佸惎鍔ㄤ笌杩涚▼绠＄悊
+
+| 闂 | 鍘熷洜 | 澶勭疆 |
+|------|------|------|
+| `Start-Process` 鎶ャ�屽凡娣诲姞浜嗗叿鏈夌浉鍚岄敭鐨勯」銆� | 鐜鍙橀噺鍚屾椂瀛樺湪 `Path` 涓� `PATH`锛堝�肩浉鍚岋級 | 缁熶竴鐢� `cmd.exe /c ... > log 2>&1` 鎴� `ProcessStartInfo` 鍚姩 |
+| 鍓嶇鍦ㄦ矙绠卞唴璧蜂笉鏉ワ紙`EPERM: lstat`锛� | node 璁块棶鐢ㄦ埛鐩綍琚矙绠辨嫤鎴� | `start-dev.ps1` 鏁翠綋鍦ㄦ矙绠卞鎵ц |
+| 宓屽 `powershell.exe -Command` 寮曞彿琚牬鍧� | 澶栧眰 shell 鍏堣В鏋愪竴灞傚紩鍙� | 鐩存帴杩愯 `.ps1` 鏂囦欢锛屼笉鍋氬祵濂� |
+| 閲嶅惎鏃惰鏉� Codex 鍐呮牳 | 鎸夊悕瀛楁潃 `node.exe` 浼氬懡涓� `node_repl` | 鎸� PID 绮剧‘鍋滃悗绔摼 `cmd 鈫� java(maven) 鈫� java(app)`銆佸墠绔摼 `cmd 鈫� node(npm) 鈫� cmd 鈫� node(vue-cli-service)` |
+| 鍓嶇鏃ュ織鎵句笉鍒� | 鏃ュ織鍦ㄥ瓙鐩綍 | `traffic-audit-web/frontend.log`锛涘悗绔� `backend.log` 鍦ㄤ粨搴撴牴鐩綍 |
+
+**閲嶅惎鏍囧噯娴佺▼**锛氬垪鍑� `java.exe` 杩涚▼ 鈫� 鍋� `app` 鈫� `maven` 鈫� `cmd` 鈫� 杩愯 `start-dev.ps1`锛堣剼鏈嚜鍔ㄨ烦杩囧凡鍦ㄧ洃鍚殑绔彛锛夈��
+
+---
+
+## 涓夈�佹湇鍔＄姸鎬侀獙璇�
+
+- 娌欑鍐� `Get-NetTCPConnection` 浼氬洜鏉冮檺銆屾嫆缁濊闂�嶈��**闈欓粯澶辫触**锛屾嵁姝ゅ垽瀹氱鍙ｆ湭鐩戝惉鏄敊鐨勩��
+- 鍒ゆ柇鏈嶅姟鐘舵�佷竴寰嬩互鏃ュ織涓哄噯锛汬TTP 鎺㈡椿鐢細
+  - 鍚庣锛歚GET http://127.0.0.1:8090/api/auth/captcha-config`锛堣繑鍥� `{"code":200,...}` 鍗抽�氾級
+  - 鍓嶇锛歚http://localhost:8080/#/login`
+- 鍓嶇鏃ュ織鍑虹幇 `Proxy error: Could not proxy request /api/... (ECONNREFUSED)` 璇存槑**鍚庣褰撴椂娌¤捣鏉�**锛屼笉鏄墠绔棶棰樸��
+
+---
+
+## 鍥涖�佹暟鎹簱
+
+- 杩炴帴锛堟湰鍦板紑鍙戝簱锛夛細
+  `& 'C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe' --host=127.0.0.1 --port=3308 --user=root --password=<瑙� AGENTS.md> --default-character-set=utf8mb4 -D traffic_audit`
+- **蹇呴』鍐� `--host=127.0.0.1`**锛氬啓鎴� `-h127.0.0.1` 浼氳瑙ｆ瀽鎴� host `127`锛岃繛鎺ュけ璐ャ��
+- 杈撳嚭杩囨护 `2>&1 | Select-String -NotMatch 'Warning'` 鍙睆钄藉瘑鐮佽鍛娿��
+- 甯哥敤琛ㄤ笌鍏抽敭鍒楋細
+
+| 琛� | 璇存槑 | 鍏抽敭鍒� |
+|----|------|--------|
+| `freight_turnover_import` | 璐ц繍閲�/鍛ㄨ浆閲� | `report_period`銆乣region_name`銆乣freight_m01..m12`銆乣turnover_m01..m12`銆乣last_*` |
+| `h2031_enterprise_monthly` | 鍏矾鏃呭 H203-1 鏈堟姤 | `report_period`銆乣enterprise_code`銆乣unified_credit_code`銆乣report_unit` |
+| `import_batch` | 瀵煎叆鎵规 | `import_type`銆乣report_period`銆乣file_name`銆乣success_rows` |
+| `audit_result` / `audit_run` | 瀹℃牳缁撴灉/杩愯 | `report_period` |
+
+- 鎺掓煡銆屾煇鏈熸暟鎹湪涓嶅湪銆嶏細`SELECT report_period, COUNT(*) FROM <琛�> GROUP BY report_period ORDER BY report_period;`
+- 鎺掓煡銆屾煇鏈熷鍏ユ潵鑷摢涓枃浠躲�嶏細鏌� `import_batch` 鐨� `file_name`銆�
+- **琛ㄧ粨鏋勫彉鏇磋鍚屾涓夊**锛氬疄闄呭簱 DDL銆乣docs/init.sql`銆乣docs/database.md`銆�
+- 娴嬭瘯鐢ㄦ姤琛ㄦ湡寤鸿鐢� `2099-xx`锛屾祴瀹岀敤 `POST /api/import/clear?period=...` 鎴栫洿鎺� DELETE 娓呯悊锛岄伩鍏嶆薄鏌撶湡瀹炴湀浠戒笅鎷夐」銆�
+
+---
+
+## 浜斻�佹暟鎹鍏ワ細鏂囦欢璺緞涓庢湡娆＄害瀹�
+
+### 5.1 璐ц繍閲�/鍛ㄨ浆閲忥紙`/api/import/freightTurnover`锛�
+
+| 婧愭枃浠� | 瑕嗙洊鏈熸 | 澶囨敞 |
+|--------|----------|------|
+| `D:\05_鏁版嵁鍒嗙被\楂橀�焅瀹氱-婀栧寳鐪佸悇甯傚窞杩愯緭閲忔暟鎹紙2026骞�1-8鏈堬級.xlsx` | 2021-12 / 2022-12 / 2024-12 / 2025-12 / 2026-08 | **鏃� 2023 骞� Sheet** |
+| `D:\05_鏁版嵁鍒嗙被\璐ц繍\7鏈圽瀹氱-婀栧寳鐪佸悇甯傚窞杩愯緭閲忔暟鎹紙2026骞�1-7鏈堬級.xlsx` | 澶氫竴涓� `2023` Sheet | 2023 骞存暟鎹殑鏉ユ簮锛�2021/2022/2024 涓� 8 鏈堟枃浠堕�愬�间竴鑷� |
+
+- 澶氬勾搴﹀伐浣滅翱璇嗗埆瑙勫垯锛坄detectYearSheets`锛夛細
+  1. **鑷冲皯 2 涓� Sheet**锛堝崟 Sheet 鏂囦欢涓嶈瘑鍒负澶氬勾搴﹀伐浣滅翱锛屼細璧拌�佺殑鏈堝害妯℃澘璺緞锛夛紱
+  2. 姣忎釜 Sheet 鍚嶅尮閰� `^\d{4}\s*骞�?$`锛坄2023骞碻銆乣2023` 閮藉彲浠ワ級锛�
+  3. 姣忎釜 Sheet 棣栬 A1 鍚�岃揣杩愰噺銆嶃�丅1 鍚�屾湀銆嶃��
+  浠讳竴鏉′欢涓嶆弧瓒� 鈫� 鏁翠綋鍥為��鑰佺殑鏈堝害妯℃澘瑙ｆ瀽銆�
+- 姣忎釜骞村害 Sheet 鐨勭粨鏋勶細涓婃柟鏄�岃揣杩愰噺(涓囧惃)銆嶅潡锛堢害 20 琛岋級锛屼笅鏂规槸銆屽懆杞噺(涓囧惃鍏噷)銆嶅潡锛�**鍚屼竴甯傚窞鍚嶇浜屾鍑虹幇鍗宠涓哄懆杞噺鍧�**銆�
+- 鎶ヨ〃鏈熻涔夛細**`2021-12` 杩欑被鏈熸斁鐨勬槸璇ュ勾 1鈥�12 鏈堢殑鍏ㄥ勾鏁版嵁**锛坄m01..m12` 鍏ㄩ儴鏈夊�硷級锛屼笉鏄� 12 鏈堝崟鏈堛�傝骞存渶鍚庢湁鏁版嵁鐨勬湀浠藉喅瀹氭湡鍙凤紙2026 骞村彧鏈� 1鈥�8 鏈� 鈫� `2026-08`锛夈��
+- 涓婂勾鍚屾湡锛氬骞村害鏂囦欢閲岃嚜鍔ㄥ彇**涓婁竴骞村害 Sheet**锛涜嫢涓婁竴骞村害涓嶅瓨鍦紙濡� 2021 鏃� 2020 Sheet锛夛紝`last_*` 涓虹┖銆�
+- 鍙ˉ鏌愪竴骞存椂锛屽彲鍙﹀瓨涓�涓彧鍚骞� + 涓婁竴骞寸殑涓存椂宸ヤ綔绨垮啀瀵煎叆锛堟敞鎰忋�岃嚦灏� 2 涓� Sheet銆嶈鍒欙級銆�
+
+### 5.2 鍏矾鏃呭 H203-1锛坄/api/import/passengerMonthly`锛�
+
+| 婧愭枃浠� | 澶囨敞 |
+|--------|------|
+| `docs\鍏矾鏃呭\妯℃澘_浜や紒缁烪203-1琛╛鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌.xlsx` | 鐢ㄦ埛淇敼鍚庣殑妯℃澘 |
+| `D:\妗岄潰\娴嬭瘯鏁版嵁\鍏矾鏃呭\鍏湀\鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌锛�2026锛塤2026-09-09 09_18_45.xls` | 绯荤粺瀵煎嚭鐨勮�佹牸寮忔牱渚� |
+| `D:\闇�瑕佸鍏ョ殑鏁版嵁\鍏矾鏃呭\*.xls` | 鍘嗗彶鍚勬湀瀵煎嚭鏂囦欢 |
+- 瑙ｆ瀽**鎸夎〃澶村悕鍙栧��**锛坄buildHeaderMap`锛夛紝鍥犳妯℃澘鍦ㄤ腑闂存彃鍒�/鏁翠綋鍙崇Щ**涓嶄細**鐮村潖鍏跺畠瀛楁銆�
+- 鏂版ā鏉垮湪銆屼紒涓氬悕绉般�嶅悗鏂板 2 鍒楋細`缁熶竴绀句細淇＄敤浠ｇ爜`銆乣濉姤鍗曚綅`锛涜�佹牸寮忔枃浠跺叾瀹炰篃甯﹁繖涓ゅ垪锛堟鍓嶄唬鐮佹湭璇诲彇锛夈��
+- 蹇呴渶鍒楃己澶变細鐩存帴鎶ラ敊锛屼緥濡傞�夐敊绫诲瀷鏃舵彁绀恒�岃〃澶寸己灏戝繀闇�鍒椼�愪紒涓氬悕绉般�戙�愬杩愰噺_鎬昏銆戙�嶃��
+
+### 5.3 鍏跺畠
+
+- 瀵煎叆澶辫触蹇呴』鍦ㄩ〉闈㈡樉绀�**琛屽彿**锛堢敤鎴疯姹傦級锛屾柊澧炶В鏋愰�昏緫鏃朵笉瑕佸悶鎺夎鍙蜂俊鎭��
+
+---
+
+## 鍏�佹姤琛ㄧ敓鎴�
+
+- 銆屾眹鎬诲ぇ琛ㄣ�嶉瑙堝脊绐楃敱 `ReportExport.vue` 娓叉煋锛�
+  - 寮圭獥鍐�**鍙繚鐣欎竴寮犳寚鏍囪〃**锛堝垎绫� / 鎸囨爣 / 鏁版嵁 / 鍚屾瘮锛夛紝銆屼腑鍙ｅ緞銆嶄箣鍚庝笉鍐嶆覆鏌撲换浣曡〃鏍硷紱
+  - 寮圭獥鏀寔鎷栧姩锛坄v-dialog-drag` 鎸囦护锛屾嫋鏍囬鏍忥級+ 10px 鍦嗚銆�
+- 瀵煎嚭渚濊禆**姣嶇増妯℃澘鏂囦欢**锛歚docs/鐢熸垚姹囨�诲ぇ琛�/YYYY骞碝鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`銆傜己澶辨椂鎶ャ�屾瘝鐗堝畾浣嶅け璐ワ細鏈壘鍒版ā鏉挎枃浠躲�嶏紝**涓嶆槸鏁版嵁闂**銆�
+- 鎺ュ彛灞傞潰鑷煡锛堢粫杩囧墠绔紝瀹氫綅鏄墠绔繕鏄悗绔棶棰橈級锛�
+  - 棰勮锛歚GET /api/report/preview?period=2026-08&mode=month&types=summaryWorkbook`
+  - 瀵煎嚭锛歚GET /api/report/export/summaryWorkbook?...`
+- 澶辫触鎻愮ず宸茬粏鍒嗭細鑳藉尯鍒嗐�岃繛涓嶄笂鏈嶅姟鍣ㄣ�嶅拰銆屽悗绔繑鍥炵殑鍏蜂綋鍘熷洜銆嶏紱瀵煎嚭鎺ュ彛鏄� `responseType:'blob'`锛屾姤閿欐椂 `data` 涔熸槸 Blob锛屽繀椤诲厛 `text()` 鍐嶈В鏋愩��
+
+---
+
+## 涓冦�佺櫥褰曚笌楠岃瘉鐮�
+
+| 闂 | 鍘熷洜 | 澶勭疆 |
+|------|------|------|
+| 鐧诲綍椤靛嚭鐜扮┖鐧芥柟妗� + 銆岄獙璇佺爜鍔犺浇澶辫触锛岃妫�鏌ョ綉缁溿�� | 鍓嶇 `captchaRequired` 榛樿 `true`锛岃鍙� `/api/auth/captcha-config` 澶辫触鏃堕潤榛樺拷鐣ワ紝椤甸潰娈嬬暀鍔犺浇涓嶅嚭鏉ョ殑楠岃瘉鐮佹 | 榛樿鍊兼敼 `false`锛屾敼涓� fail-safe锛氬彧鏈夊悗绔槑纭繑鍥� `required === true` 鎵嶆樉绀猴紱璇锋眰澶辫触鎸夈�屼笉闇�瑕侀獙璇佺爜銆嶅鐞� |
+| 寮�鍏充綅缃� | 鍚庣 `application.yml` 鐨� `app.captcha.required` | 鍏虫帀鍚庡簲鏄剧ず銆屾祴璇曟ā寮忥細琛屼负楠岃瘉鐮佸凡璺宠繃銆� |
+| 鎹㈢綉缁�/鎹� IP 鍚庢帴鍙� 403 | 璺ㄥ煙鐧藉悕鍗� | CORS 闇�鏀捐鍐呯綉缃戞锛堝凡淇 `0d2a5fc`锛� |
+
+---
+
+## 鍏�佹枃浠跺啓鍏ヤ笌鏂囨湰澶勭悊鐨勫潙
+
+- 鏈満鏂囦欢**鎹㈣绗︿笉缁熶竴**锛歚Login.vue`銆乣main.js` 鏄� CRLF锛沗ReportExport.vue`銆乣DataImportService.java`銆乣docs/*.md` 鏄� LF銆傜敤 `[System.IO.File]::WriteAllText` 鏃跺繀椤诲尮閰嶅師鎹㈣绗︼紝鍚﹀垯鍚庣画 `-replace` / 瀛楃涓插尮閰嶄細澶辫触銆�
+- `main.js` 甯� BOM锛坄EF BB BF`锛夛紝鏀瑰啓鏃惰鐢� `New-Object System.Text.UTF8Encoding($true)`銆�
+- **`git checkout -- <鏂囦欢>` 浼氭妸 LF 杞垚 CRLF**锛堟湰浠撳簱 `core.autocrlf=true`锛夛紝浼氳鍚庣画鍩轰簬 LF 鐨勬浛鎹㈠け鏁堬紱鎿嶄綔鍓嶅厛纭鐪熷疄鎹㈣绗︺��
+- PowerShell 澶氳涓枃鏇挎崲寤鸿鍐� `*.py` 鑴氭湰鐢� `python` 鎵ц锛坄apply_patch` 鍦ㄦ湰鏈轰笉鍙敤锛夈��
+- 瀛楃涓叉浛鎹�**娉ㄦ剰閿氱偣鍞竴鎬�**锛歚| enterprise_name | varchar(200) | 浼佷笟鍚嶇О |` 鍦� `docs/database.md` 鍑虹幇 4 娆★紝鐩存帴 replace 浼氭敼閿欒〃锛涘繀椤诲厛鎴彇鐩爣绔犺妭鍐嶆浛鎹€��
+- 璇� `.xls`锛氭湰鏈� python 鏃� `xlrd`锛屽彲鐢� Excel COM锛坄New-Object -ComObject Excel.Application` 鈫� `Workbooks.Open` 鈫� `Cells.Item(r,c).Text`锛岃寰� `Quit()` + `ReleaseComObject`锛夈��
+
+---
+
+## 涔濄�佹祻瑙堝櫒鑷姩鍖栧彇璇佺殑鍧�
+
+- `tab.playwright.evaluate()` 璇� DOM 鎵嶅彲淇★紱AX 鏍戝彲鑳借鍒扮紦瀛樸��
+- Playwright locator 瀵� Element UI 琛ㄦ牸鍐呮寜閽�**浼氳秴鏃�**锛坄isVisible()` 鎭掍负 false锛夛紱鏀圭敤 AX 绱㈠紩 `tab.click(index)`銆�
+- `tab.drag([x1,y1],[x2,y2])` 鎷栨嫿鏃讹紝鍧愭爣蹇呴』钀藉湪**褰撳墠瑙嗗彛**鍐咃紙鏈満鍐呭祵娴忚鍣ㄨ鍙ｅ緢灏忥紝绾� 319脳790锛夛紝鍚﹀垯鎶� `Coordinate is outside the active tab content viewport`銆�
+- `tab.click` 鐨� AX 绱㈠紩**鍦ㄩ〉闈㈠埛鏂板悗浼氬け鏁�**锛屽彲鑳藉懡涓埆鐨勬帶浠讹紱姣忔鎿嶄綔鍓嶉噸鏂� `cua.getTab(...)` 鍙栨柊绱㈠紩銆�
+- 鎴浘锛歚const fs = await import('fs'); fs.writeFileSync(path, Buffer.from(await tab.getScreenshot()))`锛坄require` 涓嶅彲鐢級銆�
+- 鏀� `.vue` 鍚庨渶瑕� `tab.reload()`銆�
+- 涓存椂鑴氭湰/鏂囦欢锛坄_*.*`锛夋湭缁忕敤鎴峰悓鎰�**涓嶈鍒�**銆�
+
+---
+
+## 鍗併�丟it 鍙屼粨搴撳伐浣滄祦
+
+| 浠撳簱 | remote | 鍒嗘敮 | 鍦板潃 |
+|------|--------|------|------|
+| 涓汉 | `origin` | `master` | `https://gitee.com/zhizhijie/traffic-audit.git` |
+| 鍏徃 | `gitea` | `main` | `http://61.183.254.94:3000/r/trafficAudit.git`锛堣处鍙� zyj锛� |
+
+姣忔鏀瑰姩鐨勫浐瀹氶『搴忥細
+1. 娴嬭瘯 + 鍐欍�婂姛鑳芥祴璇曟姤鍛娿�� + 鏇存柊銆婂伐浣滄棩缁撱�嬶紱
+2. `git fetch origin` 鈫� 鍚堝苟涓汉浠撳簱鏂版彁浜わ紙閬垮厤瑕嗙洊鐢ㄦ埛鏀瑰姩锛夛紱
+3. `git fetch gitea` 鈫� 涓庤繙绔� `main` 瀵规瘮鍚堝苟 鈫� **绂佹寮烘帹**锛�
+4. `git commit` 鈫� `git push`銆�
+
+- 鍑嵁鍙蛋鏈満 git/涓存椂 askpass锛�**绂佹鍐欒繘浠撳簱浠讳綍鏂囦欢**銆�
+- 鍏徃 gitea 缃戠粶涓嶉�氭椂璁板綍涓洪仐鐣欓棶棰橈紝**涓嶈**鐢ㄥ己鎺ㄧ粫杩囥��
+
+---
+
+## 鍗佷竴銆佸綋鍓嶅凡鐭ラ仐鐣欓棶棰橈紙鎴嚦 2026-09-16锛�
+
+| # | 闂 | 褰卞搷 | 鐘舵�� |
+|---|------|------|------|
+| 1 | 8 鏈堟簮鏂囦欢缂� 2023 骞� Sheet | 宸茬敤 7 鏈堟枃浠惰ˉ褰� `2023-12` 瑙ｅ喅 | 宸茶В鍐� |
+| 2 | 2026-01 ~ 2026-07 鐨� `last_*` 涓虹┖ | 杩欏嚑鏈熸敼鍔ㄥ墠鍗充负绌猴紝闈炴湰娆″紩鍏� | 寰呯敤鎴风‘璁ゆ槸鍚﹁ˉ |
+| 3 | 2026-01 ~ 2026-07 鐨� H203-1 `unified_credit_code` / `report_unit` 涓虹┖ | 鏂板垪鏈湡鎵嶈鍙栵紝鍘嗗彶鏈熸湭鍥炲～ | 寰呯敤鎴风‘璁ゆ槸鍚﹂噸瀵� |
+| 4 | 棰勮寮圭獥銆屽叡 0 琛屻�嶄笌銆屾湀搴﹁鐩栵細1~8鏈堝潎鏈夋暟鎹�嶅彛寰勪笉鍚� | 鏄撹瑙� | 寰呯敤鎴风‘璁ゆ敼鏂囨 |
+| 5 | 鍏徃 gitea 鎺ㄩ�� | 缃戠粶鏃犲搷搴旓紝鏈帹鎴愬姛 | 寰呰ˉ鎺� |
+| 6 | 浠撳簱鏍圭洰褰曞ぇ閲� `_*.*` 涓存椂鏂囦欢 | 浣撶Н/鍙鎬� | 缁忕敤鎴峰悓鎰忓悗鍐嶆竻鐞� |
+
+> 2026-09-16 鍌嶆櫄鏇存柊锛氶仐鐣欓棶棰� 4锛堥瑙堝脊绐椼�屽叡 0 琛屻�嶆枃妗堬級宸叉寜鐢ㄦ埛纭淇敼瀹屾瘯鈥斺�旀眹鎬诲ぇ琛ㄦ敼涓烘樉绀恒�屾寚鏍� N 椤广�嶏紝鍏跺畠鎶ヨ〃鏄剧ず銆屽叡 N 琛屾槑缁嗐�嶃��
+
+---
+
+## 鍗佷簩銆�2026-09-16 琛ュ厖锛氳揣杩愰〉绛俱�岀疮璁°�嶅垪淇锛堥噸瑕佸彛寰勶級
+
+### 12.1 姣嶇増娲剧敓鍙ｅ緞锛堝繀椤婚伒瀹堬級
+
+銆� 璐ц繍銆嬮〉琛岀粨鏋勶細
+- 鍏ㄧ渷鍧楋細r5 璐ц繍閲� / r6 鍛ㄨ浆閲� / r7 鍏朵腑瑙勪笂璐ц繍閲� / r8 鍏朵腑瑙勪笂鍛ㄨ浆閲� / r9 鍏朵腑瑙勪笅璐ц繍閲� / r10 鍏朵腑瑙勪笅鍛ㄨ浆閲忥紱
+- 17 涓競宸炲潡姣忓潡 6 琛岋紝棣栬 11,17,23,...,107锛堟姹夊競...鏋楀尯锛夛紝鍧楀唴椤哄簭锛氬悎璁¤揣杩愰噺 / 瑙勪笂璐ц繍閲� / 瑙勪笅璐ц繍閲� / 鍚堣鍛ㄨ浆閲� / 瑙勪笂鍛ㄨ浆閲� / 瑙勪笅鍛ㄨ浆閲忋��
+
+**瑙勫垯锛氬叏鐪佽蹇呴』瀹屽叏鐢� 17 甯傚窞琛屾淳鐢熴��**
+- r7 / r8 / r9 / r10 = SUM(17 甯傚窞瀵瑰簲琛�)锛�
+- r5 = m7+m9锛宺6 = m8+m10銆�
+
+鍘嗗彶鏁欒锛歳9/r10锛堝叏鐪佽涓嬶級鏇炬槸**鍐欐甯搁噺**锛屼笌 17 甯傚窞瑙勪笅涔嬪拰涓嶇瓑 鈥斺�� 2023 宸� 4.6e-3銆�2022 宸� 3.1e-3銆�2021 宸� 1.5e-4锛�2024/2025/2026 鎭板ソ涓� 0锛夛紝瀵艰嚧 6 涓疮璁″垪閲� 2022/2023 姣旀簮鏂囦欢浜哄伐鏍哥畻宸� 0.003 宸﹀彸銆�2021 鏁村垪涓虹┖銆�2026-09-16 宸插叏閮ㄦ敼涓哄叕寮忋��
+
+绱鍒楃幇鐘讹紙鍏ㄧ渷琛岋紝4 浣嶅皬鏁颁笌婧愭枃浠朵竴鑷达級锛�
+
+| 鍒� | 骞村害 | 鍏紡 |
+|---|---|---|
+| S | 2026(1-8鏈�) | C+E+G+I+K+M+O+Q |
+| AT | 2025 | V+X+...+AR |
+| BV | 2024 | AX+AZ+...+BT |
+| CW | 2023 | BY+CA+...+CU |
+| DZ | 2022 | =SUM(DM:DX)锛堝師涓哄啓姝诲父閲忥級 |
+| EO | 2021 | =SUM(EC:EN)锛堝師涓�**绌�**锛� |
+| EP | 2021 绱鍚屾瘮 | 淇濇寔涓虹┖锛堥〉鍐呮棤 2020 鍧楋紝鏃犲熀鏈燂級 |
+| EA | 2022 绱鍚屾瘮 | =IFERROR(DZ/SUM(EC:EN)-1, 绌轰覆)锛堝師涓哄啓姝诲父閲忥級 |
+
+### 12.2 姣嶇増鏀瑰姩鏂瑰紡涓庢枃浠惰亴璐�
+
+- **蹇呴』鐢� Excel COM**锛堟敼鍏紡 -> CalculateFullRebuild -> Save锛夛紝**涓嶅彲鐢� openpyxl 鍙﹀瓨**锛氫細娓呯┖鍏ㄦ湰鍏紡缂撳瓨鍊硷紙鏇惧鑷� 2021 骞存箹鍖楃渷琛屽彉 0锛夈��
+- 瀵煎嚭浠堕噷鐨勫叕寮�**鏃犵紦瀛樺��**锛歰penpyxl(data_only=True) 璇诲嚭鏉ュ叏鏄� None锛屾牳瀵规暟鍊煎繀椤荤敤 Excel COM 閲嶇畻鎴栬嚜鍐欐眰鍊煎櫒銆�
+- 鏂囦欢鑱岃矗锛�
+  - YYYY骞碝鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx = **姣嶇増**锛堝敮涓�鏁版嵁鏉ユ簮锛夛紱
+  - 鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx = **鍙綔鍒楀鍙傜収**锛坅pplySummaryReferenceLayout 鍙鍒楀/闅愯棌鏍囪锛屼笉璇绘暟鍊硷級锛�
+  - 2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx = 杩愯鏃�**鏃犱换浣曚唬鐮佸紩鐢�**銆�
+- 鍚屾湡澶囦唤姣嶇増杩樺師鏈哄埗锛歳esolveSummaryDonor 鍙鏂囦欢鍚�**浠� `_澶囦唤_` 寮�澶翠笖鍚�寋骞磢鏈堛��**鐨勬枃浠讹紝鍛戒腑鍗虫暣鏍煎洖濉鐩栨瘝鐗堛��=> 鑷缓鐨勫浠芥枃浠�/鐩綍**涓嶈**鐢� `_澶囦唤_` 鍓嶇紑锛屽惁鍒欏彲鑳借褰撴垚 donor 鎶婃瘝鐗堟敼鍥炴棫鍊笺��
+
+### 12.3 鏂囨湰澶勭悊鐨勫潙锛堟湰鏈� PowerShell / git锛�
+
+| 闂 | 鍘熷洜 | 澶勭疆 |
+|---|---|---|
+| 鍏紡琚啓鎴� =SUM(DM5) | "$m7" 琚В鏋愪负鍙橀噺 m7锛�"$r:DX" 閲岀殑 $r:DX 琚綋鎴愩�岄┍鍔ㄥ櫒 r:銆嶈�屽悶鎺� | 涓�寰嬬敤 ${m} / ${r} 瀹氱晫 |
+| 鍛戒护鏁翠綋涓嶆墽琛屻�佹棤杈撳嚭銆侀��鍑虹爜 1 | 涓�涓懡浠ら噷鍑虹幇**宓屽鐨勫崟寮曞彿 here-string**锛屽灞傚湪绗竴涓粨鏉熺澶勬彁鍓嶇粨鏉� | 涓�涓懡浠ゅ彧鏀句竴涓� here-string锛涙垨鍏� Out-File 鍐欒ˉ涓佹枃浠讹紝鍐嶇敤 Get-Content -Raw |
+| apply_patch 浼犲琛屽弬鏁板け璐� | .bat 鍖呰鍣ㄧ牬鍧忎簡澶氳鍙傛暟 | 鐩存帴璋� codex.exe --codex-run-as-apply-patch $patch |
+| git commit -m 鎶� "outside repository" | PowerShell 鐢ㄥ弽寮曞彿杞箟锛屾秷鎭噷鐨勫弽鏂滄潬+寮曞彿浼氭彁鍓嶇粨鏉熷瓧绗︿覆 | 鐢� git commit -F <娑堟伅鏂囦欢> |
+| PS5.1 鎶ヤ贡鐮佽矾寰勩�屾棤娉曟壘鍒� ...銆� | PS7 鐨� Out-File -Encoding utf8 鍐欑殑鏄�**鏃� BOM** UTF-8锛孭S5.1 鎸� GBK 璇昏剼鏈� | 鍐� .ps1 鏃剁敤 -Encoding utf8BOM |
+
+### 12.4 閬楃暀闂澧為噺锛堟埅鑷� 2026-09-16 鏅氾級
+
+| # | 闂 | 褰卞搷 | 鐘舵�� |
+|---|---|---|---|
+| 7 | h2032_enterprise_monthly 2026-09 鑴忔湡锛堝疄涓� 8 鏈堟枃浠惰瀛樹负 9 鏈堬級 | 636 琛� + import_batch 302 | **宸插垹闄�**锛岀暀鍙繕鍘� SQL 澶囦唤 |
+| 8 | 銆� 璐ц繍銆嬮〉绱鍒� 2021/2022/2023 瀵逛笉涓婁汉宸ユ牳绠� | 宸蹭慨姣嶇増娲剧敓鍙ｅ緞锛�6 鍒楀叏閮ㄥ涓� | **宸茶В鍐�** |
+| 9 | 2026-09 鏈熻繕鍦� h204_vehicle_quarterly(1284 琛�) / investment_monthly(31 琛�) / audit_result(2061 琛�) / audit_run(3 琛�) | 鑻ユ寜 2026-09 鍑烘姤琛ㄤ細鍙栧埌鑴忔暟鎹� | 寰呯敤鎴风‘璁ゆ槸鍚︽竻鐞� |
+| 10 | 2026-07 瀵煎嚭浠躲�� 璐ц繍銆嬮〉涓� 118x145锛堟瘮 8 鏈堝皯 2 鍒楋級 | 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�嶏紝闈炲畬鏁存瘝鐗� | 寰� 7 鏈堟瘝鐗堝畾绋� |
+| 11 | 2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx 鐨� S 鍒楁紡 8 鏈堬紙缂� Q5锛� | 杩愯鏃舵湭琚紩鐢紝鏆傛棤褰卞搷 | 寰呯‘璁よ鏂囦欢鍘荤暀 |
+| 12 | 姣嶇増缁� Excel 閲嶅瓨鍚庝綋绉� 959,706 -> 1,492,121 瀛楄妭锛堝鍑轰欢 950,186 -> 1,331,599锛� | 绾牸寮忓紑閿�锛屾暟鎹棤褰卞搷 | 璁板綍 |
+
+璇﹁銆婂姛鑳芥祴璇曟姤鍛�/鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍椤电绱鍒椾慨澶嶄笌鑴忔湡娓呯悊_2026-09-16.md銆嬨��
+
+---
+
+## 鍗佷笁銆�2026-09-16 琛ュ厖锛�2026-07 姣嶇増琛ラ綈 & 瀵煎嚭浠躲�孍xcel 鎵撲笉寮�銆嶆牴鍥狅紙P0锛�
+
+### 13.1 鐥囩姸涓庢牴鍥�
+
+| 椤� | 鍐呭 |
+|---|---|
+| 鐥囩姸 | `GET /api/report/export/summaryWorkbook?period=2026-07&mode=month` 鐢熸垚鐨� xlsx锛�**Excel 鎵撲笉寮�**锛圕OM 鎶ャ�屼笉鑳藉彇寰楃被 Workbooks 鐨� Open 灞炴�с�嶏紱`CorruptLoad=1` 淇妯″紡鍚屾牱鎵撲笉寮�锛夛紱2026-08 鍚屾帴鍙ｆ甯� |
+| 鐩存帴鍘熷洜 | 瀵煎嚭浠堕噷鏈� **19 涓ā寮忛潪娉曟牸**锛歚<c r="E15" s="111" t="n"><v>67.0</v><is><t>67.00</t></is></c>` 鈥斺�� `t="n"` 涓嶅厑璁稿甫 `<is>`锛坕nlineStr 涓撶敤锛� |
+| 娣卞眰鍘熷洜 | 7 鏈堟瘝鐗堢敱 **openpyxl** 鍐欏嚭锛坄docProps/app.xml` = `Microsoft Excel Compatible / Openpyxl 3.1.5`锛屾枃鏈瓨 `<is>`锛夛紱8 鏈堟瘝鐗堟槸 **Excel 鍘熺敓**锛堟枃鏈蛋 sharedStrings锛夈�侾OI 鐨勯儴鍒嗗啓鍏ヨ矾寰勫彧鏀� `t`/`<v>`銆佷笉娓呮棫 `<is>` |
+| 瑙﹀彂璺緞 | 7 鏈堝瓨鍦� `_澶囦唤_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_娓呯悊鍓峗20260904.xlsx` 鈫� `restoreSummaryMonthlyBlocks` 鏁存牸鍥炲～ 鈫� 寰� inlineStr 鏍奸噷鍐欏�肩暀涓嬫棫 `<is>`銆�8 鏈堟棤 `_澶囦唤_*`锛屼笉璧板洖濉紝鏁呮甯� |
+| 鍛戒腑浣嶇疆 | leave-one-out 瀹氫綅鍒� **sheet9銆婂叕浜ゃ��17 鏍� + sheet12銆婅建閬撱�佽疆娓°��2 鏍�** |
+
+### 13.2 淇锛坄traffic-audit-server`锛�
+
+1. **`exportSummaryWorkbook` 鏂板 `normalizeStaleInlineStrings(wb)`**锛氳惤鐩樺墠娓呮帀鎵�鏈夈�岄潪 `inlineStr` 鍗存畫鐣� `<is>`銆嶇殑鏍煎瓙锛堝箓绛夛級锛屽懡涓嵆鎵� warn 鏃ュ織銆�
+2. **`restoreSummaryMonthlyBlocks` 鏂板 `skipFreightHistoryBlocks`**锛氥�� 璐ц繍銆嬮〉 **T 鍒楀強浠ュ悗**锛�2025/2024/2023/2022/2021 骞村害鍧� + 鍚勫勾绱/绱鍚屾瘮鍒楋級**姘镐笉浠庡浠芥瘝鐗堝洖濉�** 鈥斺�� 涓庢棦鏈夈�屼腑鍙ｅ緞鎺掑悕宸﹀潡姘镐笉鍥炲～銆嶅悓涓�鎬濊矾锛岄伩鍏嶈ˉ榻愯銆岀敓鎴愬張澶嶆椿銆嶃��
+
+### 13.3 2026-07 姣嶇増琛ラ綈锛堝彛寰勪笌 8 鏈堟瘝鐗堝榻愶級
+
+- 骞村害鍧楋紙姣忓垪锛夛細`r7/r9/r8/r10 = SUM(17 甯傚窞瀵瑰簲琛�)`銆乣r5 = r7+r9`銆乣r6 = r8+r10` 鈫� 360 鏍硷紱
+- 绱鍒楋細`DX = SUM(DK:DV)`锛�2022锛夈�乣EM = SUM(EA:EL)`锛�2021锛屽師**鏁村垪涓虹┖**锛夈�乣DY = IFERROR(DX/SUM(EA:EL)-1,"")`锛�2022 绱鍚屾瘮锛屽師涓�**鍐欐甯搁噺**锛夆啋 324 鏍硷紱
+- 2023 绱 `CU = BW+BY+鈥�+CS` 鏈潵灏辨纭紝鏈敼锛沗EN`锛�2021 绱鍚屾瘮锛夋寜鍙ｅ緞淇濇寔涓虹┖銆�
+- 涓�鎵嬭瘉鎹細姣嶇増 `DX5=144979.2825`锛堟棫甯搁噺 `144979.285376043`锛屽樊 0.0029 = 鍏ㄧ渷瑙勪笅甯搁噺涓� 17 甯傚窞涔嬪拰鐨勫樊锛夈�乣EM5=161309.53162`銆乣CU5=173045.296428512`锛屼笌 8 鏈堟瘝鐗� `DZ5/EO5/CW5` **瀹屽叏鐩哥瓑**銆�
+- 澶囦唤锛歚docs/鐢熸垚姹囨�诲ぇ琛�/_bak_2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃_琛ラ綈鍓峗20260916.xlsx`銆�**鍒囧嬁鏀瑰悕涓� `_澶囦唤_` 寮�澶�**锛屽惁鍒欎細琚� `resolveSummaryDonor` 褰� donor 鍥炲～銆�
+
+### 13.4 鏈鏂板鐨勬帓鏌ュ潙
+
+| 闂 | 鍘熷洜 | 澶勭疆 |
+|---|---|---|
+| Excel COM **闂存瓏鎬�**鎶ュ悓涓�涓敊锛屽鑷磋鍒ゃ��8 鏈堜欢涔熸墦涓嶅紑銆� | 姣忔 `New-Object -ComObject Excel.Application` 鐣欎笅鐨�**瀛ゅ効 EXCEL 杩涚▼**浼氭薄鏌撳悗缁疄渚� | 姣忎緥娴嬪畬鎶娿�屾湰娆℃柊寤虹殑 EXCEL 杩涚▼銆嶅己鏉�鍐嶆祴涓嬩竴渚嬶紱`Quit()`+`ReleaseComObject` 骞朵笉澶� |
+| 缂栬瘧鎶ャ�屾壘涓嶅埌 isSetSheetData()銆� | `CTWorksheet.sheetData` 鏄� XSD **蹇呭～**鍏冪礌锛屼笉鐢熸垚 `isSetXxx` | 鏀圭敤 `ctw.getSheetData() != null` |
+| 閮ㄤ欢绾� diff 澶ぇ璺戜笉鍔� | 瀵� 519KB 鐨� `styles.xml` 鐩存帴 `difflib` 鏄� O(n虏) | 鍏堟寜閮ㄤ欢姣斿瓧鑺傚昂瀵�/鏄惁鐩哥瓑锛屽彧鍦ㄥ繀瑕佺殑灏忛儴浠朵笂鍋� diff |
+
+### 13.5 閬楃暀闂澧為噺
+
+| # | 闂 | 褰卞搷 | 鐘舵�� |
+|---|---|---|---|
+| 13 | 2026-06 / 2026-09 鏃犳瘝鐗� | 棰勮 `ready=False`銆屾湭鎵惧埌妯℃澘鏂囦欢銆嶏紝鏃犳硶鍑烘暟 | 闇�鍏堝缓姣嶇増锛堢敤鎴风 5 闂殑寤朵几锛� |
+| 14 | 浠撳簱鏍� `_*.*` 涓存椂鏂囦欢缁х画澧炲锛坄_hyb_*` / `_loo_*` / `_v2_*` / `_final_*` / `_fixed_*` / `_t7_*` / `_poijar`锛� | 浣撶Н/鍙鎬� | 缁忕敤鎴峰悓鎰忓悗鍐嶆竻鐞� |
+
+> 绗� 10 椤癸紙2026-07 瀵煎嚭浠跺皯 2 鍒� / 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�嶏級鏈妭宸插鐞嗭細瀵煎嚭绔細**鑷姩琛ュ嚭 5/6/7 鏈堣〃澶翠笌鍏紡**骞堕噸绠楃疮璁″叕寮忥紝姣嶇増宸茶ˉ榻� 2021/2022/2023 绱鍒楋紝鏁呭叧闂椤广��

--
Gitblit v1.9.1