From 8fd1e1134785eb20ff9640bf7b6f62a6d14df26e Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期三, 16 九月 2026 15:54:42 +0800
Subject: [PATCH] fix(summary): 货运页签累计列改为市州汇总派生，修 2021/2022/2023 累计对不上
---
docs/工作日结/工作日结_2026-09-16.md | 68 ++++++++++++++++++++++++++++++++++
1 files changed, 68 insertions(+), 0 deletions(-)
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-16.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-16.md"
index 5092143..196259b 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-16.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-16.md"
@@ -241,3 +241,71 @@
### 19.4 git 缁撴灉锛堟湰杞級
- 鎻愪氦 `27574bc`锛堝姛鑳芥祴璇曟姤鍛� + 鏈妭 + .gitignore 琛� `_pylibs/`銆佷慨姝� `~$*` 鍓嶅绌烘牸锛夆啋 **宸叉帹 origin锛坓itee master锛�**锛歚559e937..27574bc`銆�
- **鍏徃 gitea 浠嶄笉鍙敤**锛歚Test-NetConnection 61.183.254.94:3000` 杩斿洖 True锛圱CP 閫氾級锛屼絾 `GET /r/trafficAudit.git/info/refs?service=git-upload-pack` 25 绉掓棤浠讳綍鍝嶅簲锛圚TTP 000锛夛紝`git fetch gitea` 鎶� `Operation too slow. Less than 1000 bytes/sec`銆傚垽鏂负鏈嶅姟绔湭姝ｅ父鎻愪緵 HTTP 鍝嶅簲锛屽緟鎭㈠鍚庤ˉ鎺紝**绂佸己鎺�**銆�
+
+## 浜屽崄銆佺敤鎴枫�屽彲浠ャ�嶆巿鏉冮」钀藉疄锛氳揣杩愰〉绛剧疮璁″垪淇 + H2032 鑴忔湡娓呯悊
+
+### 20.1 鍏抽敭鍙戠幇锛氭牴鍥犱笉鏄疮璁″叕寮忥紝鑰屾槸銆屽叏鐪佽涓嬨�嶈
+
+涓婁竴鑺傛垜鍒ゅ畾涓恒��2021 绱鍒楃┖ + 2022 鍐欐甯搁噺 + 2023 绮惧害宸�嶏紝鏈疆鐢� Excel COM 閫愭湀瀹炴祴鍚�**淇浜嗙粨璁�**銆傚 6 涓勾搴﹀潡閫愭湀姣旇緝銆屽叏鐪佽銆嶄笌銆�17 甯傚窞琛屼箣鍜屻�嶏細
+
+| 骞村害 | 鍚堣宸� | 瑙勪笂宸� | 瑙勪笅宸� |
+|---|---|---|---|
+| 2026(1-8) | 2.8e-5 | 1.8e-12 | 2.8e-5 |
+| 2025 | 3.3e-11 | 9.1e-13 | 3.5e-11 |
+| 2024 | 1.5e-11 | 9.1e-13 | 1.3e-11 |
+| 2023 | **4.6e-3** | 4.5e-13 | **4.6e-3** |
+| 2022 | **3.1e-3** | 2.3e-13 | **3.1e-3** |
+| 2021 | 4.0e-5 | 4.0e-5 | 1.5e-4 |
+
+- 銆岃涓娿�嶅叏鐪佽姘歌繙鏄� 17 甯傚窞涔嬪拰锛堝叕寮忥級锛�**涓�澶勪笉宸�**锛�
+- 宸紓 100% 鏉ヨ嚜銆屽叏鐪佽涓嬨�嶈 鈥斺�� 瀹冩槸**鍐欐鐨勫父閲�**锛屼笌 17 甯傚窞瑙勪笅涔嬪拰涓嶇瓑锛�
+- 鑰屻��17 甯傚窞琛屼箣鍜屻�嶆伆濂界瓑浜庢簮鏂囦欢婀栧寳鐪佽锛�2022 = 144979.2825銆�2023 = 173045.2964锛夛紝姝ｆ槸鐢ㄦ埛浜哄伐鏍哥畻鐨勯偅涓暟銆�
+
+鎵�浠ュ彧瑕佹妸銆屽叏鐪� 瑙勪笂/瑙勪笅銆嶄袱琛岄兘鏀规垚 17 甯傚窞姹傚拰鍏紡锛屽叏鐪佽鑷劧绛変簬甯傚窞涔嬪拰锛岀疮璁″垪闅忎箣鑷姩瀵逛笂銆�
+
+### 20.2 姣嶇増鏀瑰姩锛坉ocs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx 鐨勩�� 璐ц繍銆嶉〉锛�
+
+| 浣嶇疆 | 鏀瑰墠 | 鏀瑰悗 |
+|---|---|---|
+| r7/r8/r9/r10锛堝叏鐪� 瑙勪笂/瑙勪笅 璐ц繍閲徛峰懆杞噺锛�2021-2025 鍚勬湀锛� | 鍐欐甯搁噺 | SUM(17 甯傚窞瀵瑰簲琛�) |
+| r5/r6锛堝叏鐪� 璐ц繍閲�/鍛ㄨ浆閲忥紝2021-2025 鍚勬湀锛� | 甯搁噺 | m7+m9 / m8+m10 |
+| DZ锛�2022 绱锛岃 5-112锛� | 鍐欐甯搁噺 | SUM(DM:DX) |
+| EO锛�2021 绱锛岃 5-112锛� | 绌� | SUM(EC:EN) |
+| EA锛�2022 绱鍚屾瘮锛岃 5-112锛� | 鍐欐甯搁噺 | IFERROR(DZ/SUM(EC:EN)-1,"") |
+
+鍏� 360 + 324 涓崟鍏冦��2026 骞村潡涓嶅姩锛堝綋鏈堝�肩敱瀵煎嚭浠ｇ爜鍥炲～锛夛紱EP锛�2021 绱鍚屾瘮锛変繚鎸佷负绌猴紙椤靛唴娌℃湁 2020 鍧楋紝鏃犲悓姣斿熀鏈燂級銆傛敼鍓嶅浠� docs/鐢熸垚姹囨�诲ぇ琛�/_bak_202608姣嶇増淇敼鍓峗20260916/銆�
+
+**鍙敼姣嶇増杩欎竴涓枃浠�**锛氱敓鎴恄閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx 鏄垪瀹藉弬鐓т欢锛堜唬鐮佸彧璇诲垪瀹�/闅愯棌鏍囪锛夛紝_鐗堝紡鍘熷瀷.xlsx 杩愯鏃舵棤浠讳綍浠ｇ爜寮曠敤锛涘悓鏈熷浠芥瘝鐗� resolveSummaryDonor(2026,8) 瑕佹眰鏂囦欢鍚嶄互 _澶囦唤_ 寮�澶翠笖鍚��2026骞�8鏈堛�嶏紝鐩綍涓嬫棤鍖归厤锛堝鍑烘棩蹇楃‘璁ゃ�屾湭鎵惧埌鍚屾湡澶囦唤姣嶇増銆嶏級锛屼笉浼氬啿鎺夋敼鍔ㄣ��
+
+### 20.3 鏁版嵁搴撴竻鐞�
+
+- DELETE FROM h2032_enterprise_monthly WHERE report_period='2026-09' 鈫� 636 琛岋紙ROW_COUNT() 瀹炴祴锛�
+- DELETE FROM import_batch WHERE id=302 鈫� 1 琛�
+- 澶囦唤锛歘backup_h2032_2026-09_rows_20260916.sql锛�636 鍏冪粍锛夈�乢backup_h2032_2026-09_batch302_20260916.sql
+
+### 20.4 淇鍚庡疄娴嬶紙閲嶅鍑� 2026-08锛孍xcel 閲嶇畻锛�
+
+| 骞村害 | 鍒� | 淇鍓� | 淇鍚� | 婧愭枃浠舵牳绠� |
+|---|---|---|---|---|
+| 2026(1-8鏈�) | S | 130311.8927 | 130311.8927 | 130311.8927 |
+| 2025 | AT | 195433.2232 | 195433.2232 | 195433.2232 |
+| 2024 | BV | 184938.5780 | 184938.5780 | 184938.5780 |
+| 2023 | CW | 173045.2932 | **173045.2964** | 173045.2964 |
+| 2022 | DZ | 144979.2854 | **144979.2825** | 144979.2825 |
+| 2021 | EO | 绌� | **161309.5316** | 161309.5316 |
+
+鍏ㄩ儴 4 浣嶅皬鏁颁竴鑷达紙鏈�澶ф畫宸� 4.1e-5锛屼负娴偣绱姞鍣０锛夈�傚鍑轰欢銆屽叏鐪佽銆峷s銆�17 甯傚窞琛屼箣鍜屻�嶉�愭湀 灏忎簬绛変簬 9.3e-10銆傞瑙堟帴鍙� types=summaryWorkbook 杩斿洖 ready=true銆�20 椤规寚鏍囷紙褰撴湀璐ц繍閲� 16888.76銆佺疮璁� 130311.89锛夈��2026-07 瀵煎嚭鍥炲綊閫氳繃銆�
+
+### 20.5 韪╁潙
+
+1. **PowerShell 鍙屽紩鍙烽噷鐨� "$m7" 浼氳褰撴垚鍙橀噺 m7**锛氬叕寮忎覆 "=SUM(DM$r:DX$r)" 涓殑 $r:DX 琚綋鎴愩�岄┍鍔ㄥ櫒 r:銆嶈�屽悶鎺夛紝鍏紡琚啓鎴� =SUM(DM5) 鈥斺�� 棣栨鑴氭湰宸叉妸姣嶇増鏀瑰潖锛岄潬澶囦唤杩樺師鍚庢敼鐢� ${m}/${r} 瀹氱晫閲嶈窇銆�
+2. **宓屽鐨勫崟寮曞彿 here-string 浼氭彁鍓嶇粓姝㈠灞� here-string** 鈫� 鏀逛负銆屽厛 Out-File 鍐欒ˉ涓佹枃浠讹紝鍐� Get-Content -Raw 浼犵粰 codex.exe --codex-run-as-apply-patch銆嶃��
+3. 姣嶇増琚� Excel 閲嶅瓨鍚庝綋绉� 959,706 鈫� 1,480,392 瀛楄妭锛屽鍑轰欢 950,186 鈫� 1,331,599锛圗xcel 鑷韩鏍煎紡寮�閿�锛屼笉褰卞搷鏁版嵁锛夈��
+4. 2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃_鐗堝紡鍘熷瀷.xlsx 鐨� S 鍒楁紡浜� 8 鏈堬紙=C+E+G+I+K+M+O锛岀己 Q5锛夛紝浣嗗畠杩愯鏃朵笉琚紩鐢紝鏈鏈敼銆�
+
+### 20.6 閬楃暀
+
+- 2026-09 鏈熷湪 h204_vehicle_quarterly锛�1284 琛岋紝batch 142/144 鍚屾枃浠讹級銆乮nvestment_monthly锛�31 琛岋紝batch 107/108 鍚屾簮锛夈�乤udit_result锛�2061 琛岋級銆乤udit_run锛�3 琛岋級涓粛鍦紝鏈鏈姩锛屽緟鐢ㄦ埛纭鏄惁娓呯悊銆�
+- 2026-07 鏈熷鍑轰欢銆� 璐ц繍銆嶉〉涓� 118x145锛堟瘮 8 鏈堝皯 2 鍒楋級锛屽洜 7 鏈堟瘝鐗堟槸銆�1-4 鏈堥鏋躲�嶃��
+
+璇﹁銆婂姛鑳芥祴璇曟姤鍛�/鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍椤电绱鍒椾慨澶嶄笌鑴忔湡娓呯悊_2026-09-16.md銆嬨��
--
Gitblit v1.9.1