From 17c972e73c18a40dcd269ac218a0450f927d48d8 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期五, 09 十月 2026 17:08:07 +0800 Subject: [PATCH] docs(汇总大表): 落盘与文件管理改为已确认项、实测细节另列实施要点 --- HANDOFF.md | 82 +++++++++++++++++++++++++++++++++++++++++ 1 files changed, 82 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index aa3a518..31c5619 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -4,6 +4,83 @@ > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆� +## 鏈�鏂帮紙2026-10-09锛寊yj 绾匡級 + +### 10-09锛�2025 鏁版嵁鐜扮姸鏍搁獙锛堢粨璁猴細宸插湪搴擄紝鏃犻渶琛ュ綍锛�+ M0 瑙勬牸琛ョ鍗佷簩鑺� + +- **鏍搁獙鏂瑰紡**锛氬彧璇绘煡璇㈠簱 `127.0.0.1:3308/traffic_audit`锛圡ySQL 8.0.29锛夛紝鏈鍏ャ�佹湭淇敼浠讳綍鏁版嵁銆� +- **2025-01~12 鍚� 12 涓湀榻愬叏**锛歚city_bus_monthly`銆乣city_taxi_monthly`銆乣wyc_order_monthly`銆乣wyc_total_monthly`銆乣h2031_enterprise_monthly`銆乣h2032_enterprise_monthly`銆乣passenger_individual_monthly`銆� +- **涓ゅ紶"涓嶄互涓虹己鍙�"鐨勮〃**锛歚freight_turnover_import` 浠� 2025-12锛屼絾琛ㄥ甫 `last_freight_m01..m12` / `last_turnover_m01..m12`锛�2026 鍚勬湡鏂囦欢鑷甫鍘诲勾鍚屾湀鍊硷紱`scale_split_transport` 鏃� 2025锛屼絾琛ㄥ甫 `above/below/total_yoy`锛屽悓姣斿凡闅� 2026 鍚勬湡鍏ュ簱銆� +- **淇鏃╁墠鍒ゆ柇**锛�09-07 鏂规鏂囨。"2025 鏈叆搴�"鐨勮娉曞凡杩囨湡锛�09-16 鍚庤ˉ褰曡繃澶氬勾搴︽暟鎹級锛沗ReportExportService.java:499 / 558 / 561` 涓夊"寰� 2025 骞村畾绋挎暟鎹鍏ュ悗鑷姩鍑虹幇"鐨勬彁绀烘潯浠跺凡涓嶆垚绔嬨�傚悓姣斿彇鏁拌蛋搴撳唴鍘诲勾鍚屾湡锛坄aggOf(data, year-1, m, "婀栧寳鐪�")`锛岀害 540 琛岋級銆� +- **閬楃暀鐨勬槸鍙ｅ緞闂锛屼笉鏄己鏁版嵁**锛氫腑鍙ｅ緞鎺掑悕/鏄庣粏鐨� 2025 鍒椾粛浠ユ瘝鐗堥潤鎬佸畾绋垮�间负鍑嗭紙`readMidDetailLastYearCumulative`锛宍ReportExportService.java:2745` 璧凤級锛屾敞閲婏紙2686-2689 琛岋級璇存槑鍘熷洜鏄�"鎺掑悕椤靛師鍏堟煡搴撶幇绠楋紝涓よ�呭湪 2025-03/04 缃戠害杞︽媶鍒嗕笂涓嶅悓"銆傗啋 闇�鍏堝仛銆屽簱鍐� 2025 vs 姣嶇増 2025銆嶉�愰」 diff锛屼氦涓氬姟纭鍩哄噯鍚庡啀鍐冲畾鏄惁鍒囨崲璇诲簱锛堝垏鎹㈠繀椤昏繃 diff=0 鍥炲綊锛夈�� +- **瑙勬牸鏇存柊**锛歚docs/姹囨�诲ぇ琛∕0鐗堝紡閲嶅缓鍣ㄨ鏍糭2026-10-06.md` 鏂板绗崄浜岃妭锛堜笁灞傝亴璐� / 涓�琛ㄤ竴绮掑害 / 璋冩暣鍊艰鐩栧眰 / 2025 瀹炴祴鏍搁獙 / 缁撴灉灞傚彲閫� / 銆屾瘝鐗堜笉鐣欐暟鎹�嶇孩绾� / 涓� M0 鐨勪緷璧栭『搴忥級銆� +- **鐘舵��**锛氭湰鑺備笌瑙勬牸绗崄浜岃妭鍧囦负銆愬緟楠屾敹銆戯紱鏈敼鍔ㄤ唬鐮併�佹湭瀵煎叆鏁版嵁銆� + +### 10-09锛�2锛夛細鏌ヨ瘉鏃㈡湁鎷嶆澘鈥斺�斿悓姣斿熀鍑嗕互姣嶇増缂撳瓨涓哄噯锛涙墿鍒楁寜鏈堟寜闇� + +- **鍚屾瘮鍩哄噯锛堢敤鎴锋寚鍑猴紝宸叉煡璇侊紱鍏堝墠鍒ゆ柇淇锛�**锛�2026 涓� 2025 鐨勫悓姣�**浠ユ瘝鐗堢紦瀛樹负鍑�**锛屽簱鍙仛鏍￠獙銆佷笉鐩存帴鏇夸唬銆傚嚭澶勶細`docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md` F8锛堚渽 鍙ｅ緞纭锛夈�乣docs/纭鍥炴墽姹囨�讳笌鍓╀綑鐤戦棶_姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫燺2026-09-07.md` Q1銆乣docs/姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犳柟妗坃2026-09-07.md` 绗節鑺傘�乣docs/寰呯‘璁姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犻棶棰樻竻鍗昣2026-09-07.md` A1銆乣docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md` 鏂规 A锛堝凡瀹炴柦锛夈�傚垏鎹㈠敮涓�鍓嶆彁 = 浜哄伐鏍稿骞堕噸瀵间竴鑷淬�� + - **淇**锛氭湰鏃ヤ笂涓�鏉�"涓彛寰� 2025 閬楃暀鍙ｅ緞寰呭畾"鐨勮娉曚綔搴燂紱搴撳唴 2025 鐜扮畻鍊间笉寰楃洿鎺ユ浛浠ｆ瘝鐗堥潤鎬佸畾绋垮�笺�� +- **鎵╁垪鏂瑰紡锛堟棦鏈夋媿鏉匡紝涓� M0 瑙勬牸鍐茬獊锛�**锛歚docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md` F10 = **鎸夋湀鎸夐渶鎵╁垪锛屼笉棰勫仛 12 鏈堟弧鐗�**锛堚渽 M0 v4锛夛紱鏀归�犳柟妗� v1.1锛�09-08 鐢ㄦ埛鎷嶆澘锛夊悓鍙ｅ緞锛屾鏂�"12 鏈堟弧鐗堝垪鐗堝紡"寤鸿宸蹭綔搴熴�侻0 瑙勬牸绗節/鍗佷竴鑺傜殑"婊＄増寮�"寤鸿**寰呯敤鎴疯瀹�**銆� +- **宸叉湁 09-29 鎵╁垪浜х墿锛堟湰鍦版湭鍏ュ簱锛�**锛歚docs/闂姹囨��/_鎵╁垪瑙勬牸琛╛2026-09-29.md/.csv`锛�19 椤甸�愰〉瑙勬牸锛夈�乣_鎵╁垪閰嶇疆鍒濈_20260929.md/.csv`銆乣_鎵╁垪璁″垝_v3..v10.json`銆乣_鎵╁垪杩涘害_20260929.md`锛涜瘯鍋氫欢 `docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃_璇曞仛_20260929.xlsx`锛堟暟鍊兼湭淇畬锛屽嬁鐢ㄤ簬鍑鸿〃锛夈�� +- **瑙勬牸鏇存柊**锛歚docs/姹囨�诲ぇ琛∕0鐗堝紡閲嶅缓鍣ㄨ鏍糭2026-10-06.md` 鏂板绗崄涓夎妭锛堟棦鏈夋媿鏉挎牳楠岋紝浼樺厛绾ф渶楂橈級锛涘苟淇 12.4 鐨勫缃粨璁恒�� +- **鐘舵��**锛氥�愬緟楠屾敹銆戯紱鏈敼鍔ㄤ唬鐮併�佹湭瀵煎叆鏁版嵁銆� + +### 10-09锛�3锛夛細宸茬‘璁ゅ彛寰勫叏閲忔牳楠� + 09-29 鎵╁垪瑙勬牸杞鍏ュ簱 + M0 瑙勬牸鏀瑰啓 + +- **鍙ｅ緞鏍搁獙鑼冨洿**锛歚docs/瑕佹眰涓庨獙鏀跺熀绾挎竻鍗�.md`銆乣docs/纭鍥炴墽姹囨�讳笌鍓╀綑鐤戦棶_姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫燺2026-09-07.md`锛堝敮涓�鍐崇瓥鍩虹嚎锛夈�乣docs/寰呯‘璁姹囨�诲ぇ琛ㄦ暟鎹┍鍔ㄦ敼閫犻棶棰樻竻鍗昣2026-09-07.md`銆乣docs/闂姹囨��/姹囨�诲ぇ琛ㄩ棶棰樹氦鎺2026-09-21.md`銆乣docs/闂姹囨��/涓彛寰勬帓鍚嶅悓姣斾笌鍩庡競瀹㈣繍鍒楅敊浣峗鏍瑰洜涓庨暱鏁堟柟妗坃2026-09-18.md`銆乣docs/闂姹囨��/鏁版嵁鏌ョ湅姹囨�讳笌姹囨�诲ぇ琛ㄥ彛寰勫搴斿叧绯籣2026-09-23.md`銆� +- **鍏抽敭宸茬‘璁ら」**锛欶1锛堝叏绮惧害瀛樺偍+鏄剧ず涓や綅灏忔暟锛夈�丗8锛堟瘝鐗堢紦瀛樹紭鍏堜綔鍚屾瘮鍩哄噯锛屽簱浠呮牎楠岋級銆丗10锛堟墿鍒楁寜鏈堟寜闇�銆佷笉棰勫仛 12 鏈堟弧鐗堛�佹柊澧炲垪涓轰袱琛岀旱鍚戝悎骞舵爣棰橈級銆丄1锛堝彧瑕嗙洊 2026 鍔ㄦ�佸潡锛�2025 鍙婁互鍓嶄笉閲嶇畻锛夈�丄3锛堝浠借繕鍘熼獙璇侀�氳繃鍓嶄繚鐣欙級銆丄4锛堟瘝鐗堝彧褰撶増寮忔ā鏉匡級銆丏1-D5锛圖3 姣忓勾鏂板紑涓�鏈��2026 鍙埌 12 鏈堬級銆丒1-E3銆丆1-C7锛圕5 涓彛寰勬帓鍚�/鍒嗘瀽鍙敱涓彛寰勫杩愰噺椤电敓鎴愩�丆6 鍛ㄨ浆閲忕郴鏁板浐瀹氥�丆7 鍩庡競姹囨�诲彛寰勶級銆丆3锛堢疮璁″悓姣斿垎姣嶆寜琛ㄥご瀹氫綅"鍘诲勾 M 鏈�"鍒楋級銆丆4锛堢増寮忓榻愭寜琛ㄥご鏂囧瓧鍖归厤鍒楋級銆佺‘璁ゅ洖鎵у叚.4/鍏�.5锛堜袱琛屽悎骞舵爣棰樸�佹瘝鐗堟枃鏈暟瀛楀綊涓�锛夈�� +- **鎾ゅ洖涓夊姝ゅ墠璇堪**锛氣憼 "12 鏈堟弧鐗堝紡"锛堜笌 F10 / 鍏�.1 鍐茬獊锛夛紱鈶� "鍘嗗彶鍙傜収鍊煎叆搴撱�佸悓姣斿垏搴撳��"锛堜笌 F8 / Q1 鍐茬獊锛夛紱鈶� "鍋滅敤 `_澶囦唤_` donor 杩樺師"锛堜笌 A3 鍐茬獊锛岄』楠岃瘉閫氳繃鍚庡啀鍋氾級銆� +- **瑙勬牸杞鍏ュ簱锛�2026-10-09锛�**锛歚docs/姹囨�诲ぇ琛ㄦ瘝鐗堟墿鍒楄鏍糭2026-09-29.md` / `.csv`锛�19 椤甸�愰〉瑙勬牸锛夈�乣docs/姹囨�诲ぇ琛ㄦ瘝鐗堟墿鍒楅厤缃垵绋縚2026-09-29.md`锛堥�愰〉鍒椾綅閰嶇疆 + 纭墠鎻愶級銆傚師鏂囦欢鍦� `docs/闂姹囨��/_*`锛堣 `.gitignore:118` 鎸′綇銆佷粎鏈満锛夛紝鏈鎸夋寮忔枃浠跺悕鍏ュ簱锛屽師 `_` 鏂囦欢淇濈暀鏈湴銆� +- **鏂板鍏抽敭纭墠鎻�**锛堟潵鑷厤缃垵绋跨浜旇妭锛夛細`SM_CUR_COL0=2`锛�2026骞�1鏈�=C锛変笌 `SM_LAST_COL0=21`锛�2025骞�1鏈�=V锛夋槸**鍐欐鐨勫垪浣嶇疆**锛屾彃鍒楀悗鍥涘紶璺ㄩ〉鍚堟垚椤典細璇婚敊 2025 鍩烘暟 鈫� **鎵╁垪鍓嶅繀椤诲厛鏀规垚鎸夎〃澶村姩鎬佸畾浣�**銆� +- **M0 瑙勬牸鏀瑰啓**锛氱涔�/鍗佷竴鑺�"婊＄増寮�"琛ㄨ堪灏卞湴浣滃簾锛涙柊澧炵鍗佸洓鑺傘�婃渶缁堟墽琛屽彛寰勩�嬶紙6 鏉″姩浣� + 閫愭牸 diff 楠屾敹 + 鏈喅椤癸級銆� +- **鏈喅**锛氭墿鍒楄蛋"绋嬪簭鑷姩"锛�09-21 搂5.3 鏂规 A锛夎繕鏄�"鏈満 Excel 灏忓伐鍏�"锛堟柟妗� B锛夆�斺��09-21 浜ゆ帴 搂11.2 鏈褰曠粨璁猴紝09-29 浜х墿涓�"绋嬪簭鐢熸垚璁″垝 + 浜哄伐纭"娣峰悎璺嚎锛屽緟鐢ㄦ埛纭銆� +- **鐘舵��**锛氥�愬緟楠屾敹銆戯紱鏈敼鍔ㄤ唬鐮併�佹湭瀵煎叆鏁版嵁銆� + +### 10-09锛�4锛夛細鎵╁垪鍙ｅ緞鎷嶆澘鈥斺�旂▼搴忔墿鍒椼�佽寖鍥� 8 椤点��4 涓殣钘忛〉淇濈暀闅愯棌 + +- **鐢ㄦ埛鎷嶆澘锛�2026-10-09锛�**锛氣憼 鎵╁垪鏂瑰紡 = **绋嬪簭鎵╁垪**锛堟墿鍒楀櫒锛夛紱鈶� 鎵╁垪鑼冨洿 = **8 涓彲瑙佸彴璐﹂〉**锛坄 璐ц繍`銆乣鐝嚎鍖呰溅`銆乣鍩庡競瀹㈣繍`銆乣鍏氦`銆乣鍑虹`銆乣缃戠害杞銆乣杞ㄩ亾銆佽疆娓銆乣涓彛寰勬槑缁哷锛夛紱鈶� **4 涓殣钘忛〉淇濈暀骞剁户缁殣钘忋�佷笉绾冲叆鏁版嵁鍔犲伐**锛坄鍏矾鎬诲杩恅銆乣2025骞村煄甯傚杩愰噺`銆乣涓彛寰勫杩愰噺`銆乣涓彛寰勮绠楄繃绋媊锛夛紝涓嶆彃鍒椼�佷笉鏀瑰叕寮忋�� +- **姣嶇増鏋勬垚瀹炴祴锛坥penpyxl + xl/workbook.xml锛�**锛�**15 涓彲瑙侀〉绛� + 4 涓殣钘忛〉绛�**锛岄殣钘忕姸鎬佷负 `state="hidden"`锛堥潪 veryHidden锛屽彸閿爣绛惧彲鍙栨秷闅愯棌锛夈�俙鍏矾鎬诲杩恅 40脳274銆乣涓彛寰勫杩愰噺` 189脳68銆乣涓彛寰勮绠楄繃绋媊 217脳11銆乣2025骞村煄甯傚杩愰噺` 16脳13銆� +- **娑堣В涓ゅ鐭涚浘**锛�09-29銆婃墿鍒楄鏍艰〃銆嬫妸 `涓彛寰勫杩愰噺`锛堥〉绛� 18锛夋爣涓� A 绫汇�佷笖 09-29 杩涘害閲屽凡鎻掑垪鐨� 8 椤垫病鏈夊畠锛涖�婇厤缃垵绋裤�嬪張鎶婂畠鏍囨垚"鏃� 2026 鏈堜唤瀵�"銆傛寜鏈鎷嶆澘缁熶竴涓�**涓嶅姞宸�**锛涗袱浠芥枃妗ｅ凡灏卞湴杩藉姞銆婂彛寰勮ˉ鍏咃紙2026-10-09锛夈�嬨�� +- **瀛楁瘝闄烽槺璁版。锛堥伩鍏嶅啀娣凤級**锛�09-21 浜ゆ帴 搂5.3銆屾柟妗� A锛濈▼搴忚嚜鍔ㄦ墿鍒� / 鏂规 B锛滶xcel 灏忓伐鍏枫�嶏紝涓� 09-28/09-29 宸ヤ綔鏃ョ粨銆屾柟妗� A锛濅汉宸ュ仛姣嶇増 / 鏂规 B锛濇墿鍒楀櫒銆�**瀛楁瘝鐩稿弽**銆傚悗缁粺涓�鍐�"**鎵╁垪鍣紙绋嬪簭锛�**"锛屼笉鍐嶇敤 A/B 瀛楁瘝銆� +- **鏄撴贩娣嗙偣璁版。**锛歚涓彛寰勬槑缁哷 椤电殑 A1 鏍囬鏈韩灏卞啓浣�"涓彛寰勫杩愰噺"锛屼笌闅愯棌椤电 `涓彛寰勫杩愰噺` 鍚屽悕鈥斺�旀枃妗ｄ笌鍙ｅご娌熼�氬姟蹇呭甫椤电浣嶇疆锛堢 13 浣� vs 绗� 18 浣嶏級銆� +- **浠嶅緟纭锛堜粎涓�椤癸級**锛氭墿鍒椾骇鐗╂槸鑷姩钀界洏涓轰笅鏈熸瘝鐗堬紝杩樻槸姣忔浜哄伐纭鍚庡啀钀界洏锛堝缓璁悗鑰咃紝涓� A3/A4 涓�鑷达級銆� +- **鏂囨。鏇存柊**锛歚docs/姹囨�诲ぇ琛∕0鐗堝紡閲嶅缓鍣ㄨ鏍糭2026-10-06.md` 绗崄鍥涜妭宸插畾椤规浛鎹�"鏈喅椤�"锛涜鏍艰〃涓庨厤缃垵绋垮悇杩藉姞鍙ｅ緞琛ュ厖銆� +- **鐘舵��**锛氥�愬緟楠屾敹銆戯紱鏈敼鍔ㄤ唬鐮併�佹湭瀵煎叆鏁版嵁銆� + +- **锛堝悓鏃ュ凡纭锛岄潪寰呯‘璁ら」锛夎惤鐩樹笌鏂囦欢绠＄悊**锛氭墿鍒椾骇鐗�**鍏堣惤 `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/`**锛坄_鎵╁垪_YYYY骞碝鏈坃寰呯‘璁�.xlsx`锛夛紝**浜哄伐纭鍚�**鎵嶉噸鍛藉悕钀界洏涓哄綋鏈熸瘝鐗堬紱鐩綍鍙暀**褰撴湡涓�鏈�**姣嶇増锛屽巻鍙叉湡绉诲叆 `docs/鐢熸垚姹囨�诲ぇ琛�/褰掓。/`锛宍2026骞�8鏈堚�鐗堝紡鍘熷瀷.xlsx` 涓�骞跺綊妗ｏ紱鐗堝紡鍙傜収浠� `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx` 鍦ㄦ墿鍒楀櫒璺戦�氬悗褰掓。锛堝綊妗ｅ墠鍋� C4 涓ゆ锛氬垪瀹�/闅愯棌涓�娆℃�у浐鍖栬繘姣嶇増 + `applySummaryReferenceLayout` 鏀规寜琛ㄥご鏂囧瓧鍖归厤鍒楋級銆� +- **瀹炴柦瑕佺偣锛堝疄娴嬬粏鑺傦紝闈炲喅绛栭」锛�**锛氭瘝鐗� vs 鍙傜収浠跺疄娴� **鍒楀 320 澶勩�侀殣钘忔爣璁� 31 澶�**涓嶅悓锛坄 璐ц繍` 77+8銆佺彮绾垮寘杞� 109銆佷腑鍙ｅ緞鏄庣粏 32+14銆佷腑鍙ｅ緞鎺掑悕 17+9 绛夛級锛沗copyColumnWidth`锛坄ReportExportService.java:1186`锛�**鍙鍒跺搴︺�佷笉澶嶅埗 hidden**锛屾墿鍒楀櫒鍏嬮殕鏈堜唤鍒楁椂椤昏ˉ hidden銆� +### 10-09锛�5锛夛細Step 0 钀藉湴鈥斺�斿洓寮犺法椤靛悎鎴愰〉鍙栨暟鏀逛负**鎸夎〃澶村姩鎬佸畾浣�**鏈堜唤鍒椼�愬緟楠屾敹銆� + +- **鏀瑰姩**锛歚ReportExportService` 涓� `SM_CUR_COL0 = 2`锛�2026骞�1鏈�=C锛�/ `SM_LAST_COL0 = 21`锛�2025骞�1鏈�=V锛�**搴熷純**锛屾敼鐢辨柊澧炵殑 `smMonthCols(sheet, year)` + `smYearMonthOf(cell)` 鎸夎〃澶村畾浣嶏紱`smSumMonths` 鏀瑰悆銆屾湀浠解啋鍒楀彿銆嶆槧灏勩��**鍙崲鍙栨暟鏂瑰紡锛屼笉鏀圭増寮忎笌鏁板�煎彛寰勩�佷笉鍋氭墿鍒�**銆� +- **涓轰粈涔堝繀椤诲厛鍋�**锛氳鍐欐鍒椾綅鏄� 09-29銆婇厤缃垵绋裤�嬬浜旇妭鏍囨槑鐨�"纭墠鎻�"鈥斺�斾竴鎻掑垪锛�2025 鍧楀彸绉伙紝鍥涢〉浼氳閿欏幓骞村熀鏁帮紙瀵瑰簲宸茬‘璁ゅ彛寰� C3/C4锛夈�� +- **琛ㄥご涓夊舰寮忓吋瀹�**锛堝疄娴� 8 鏈堟瘝鐗堢‘涓轰笁绉嶆贩鐢級锛氭枃鏈� `'2026骞�3鏈�'`銆佽８鏃ユ湡搴忓垪鍙凤紙`46082`锛孏eneral锛屽嚭绉熼〉鍑犱箮鏁磋锛夈�佺湡鏃ユ湡 + `yyyy"骞�"m"鏈�"`锛坄 璐ц繍`锛夈�傛帓闄ゅ惈銆岀疮璁�/鍚屾瘮/鐜瘮銆嶇殑琛ㄥご涓庨潪褰撴湀 1 鍙风殑鏁板�硷紱骞翠唤涓嶅尮閰嶏紙2024/2023 鍧楋級涓嶈銆� +- **楠岃瘉锛堝叧閿紝閲嶅仛杩囦竴娆★級**锛氭棫浠ｇ爜瀹炰緥锛坖ava PID 5716锛夌敓鎴� 2026-08 浣滃熀绾� 鈫� 鏂颁唬鐮佸疄渚嬶紙java PID 32368锛�10:07:58 鍚姩锛夌敓鎴� 2026-08 鈫� **閫愭牸 diff = 0**锛堝叕寮�/鏂囨湰 0銆佺紦瀛樺�� 0锛岃鐩� 19 椤碉級锛涙棤"鏈瘑鍒埌鏈堜唤琛ㄥご鍒�"鍛婅锛�2026-07 浜︽甯稿嚭琛ㄣ�� +- **韪╁潙锛堝姟蹇呰浣忥級**锛氶娆″姣旂殑"0 宸紓"鏄�**鍋囩殑**鈥斺�旀棫鍚庣浠嶅崰 8090锛宍start-dev.ps1` 鍥犵鍙ｅ凡鐩戝惉鑰岃烦杩囧惎鍔紝涓斿叾鎶ュ嚭鐨� PID 涓庣湡瀹炵洃鍚� PID 涓嶄竴鑷达紝瀵艰嚧璇垽"宸叉崲鏂拌繘绋�"銆�**鍒ゆ柇鏄惁鎹簡杩涚▼锛屽繀椤荤湅 `netstat -ano` 鐨勭湡瀹炵洃鍚� PID + 鏃ュ織閲岀殑鍚姩鏃堕棿/PID锛屼笉鑳藉彧淇″惎鍋滆剼鏈緭鍑恒��** +- **鍏跺畠纭**锛氬悗绔棩蹇椾腑鏂囦负 **GBK**锛坄Select-String` 涓枃妯″紡鍖归厤涓嶅埌锛岄渶鐢� PID/绫诲悕绛� ASCII 閿氱偣锛夛紱涓ゆ浜х墿 sha256 涓嶅悓浣� 29 涓� zip 鏉＄洰鍐呭鍏ㄥ悓锛堝樊寮備粎鍦� zip 瀹瑰櫒鍏冩暟鎹級銆� +- **鎶ュ憡**锛堟湰鍦般�佷笉鍏ュ簱锛夛細`docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_姹囨�诲ぇ琛ㄥ垪浣嶇疆琛ㄥご鍔ㄦ�佸畾浣峗2026-10-09.md`锛涙棩缁� `docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_2026-10-09.md`銆� +- **涓�鑷存�ф梺璇侊紙2026-10-09锛屼綔涓� Step 0 楠屾敹鏉愭枡锛�**锛氱敤 `docs/宸ュ叿/姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵�.py` 鎶�**鏂颁唬鐮佷骇鐗�**涓�**鎵嬪伐瀹氱** `D:\05_鏁版嵁鍒嗙被\姹囨�昏〃\8鏈堟眹鎬诲畾绋縗2026骞�8鏈堝杩愰噺銆佽揣杩愰噺瀹氱.xlsx`锛�9/13 鐗堬級閫愭牸姣斿锛屾槑缁� 1020 鏉★細 + - 瀹炶川鏁板�煎樊寮� **10**锛氬叏鍦ㄣ�� 璐ц繍銆媊DZ` 鍒楋紙2022 骞寸疮璁″悓姣旓紝浠欐/娼滄睙/澶╅棬/鏋楀尯锛夆�斺�斿嵆 09-21~09-28 宸茬‘璁�"**杞欢姝ｇ‘**"鐨勯偅 10 鏉★紱 + - 闇�澶勭悊(闈炴暟鍊兼枃鏈�) **1**锛氱彮绾垮寘杞� `IM50`锛堜粰妗� 瀹㈣繍閲忓悓姣旓級锛岀敓鎴愪欢涓烘暟鍊� `0.0077858鈥锛屾墜宸ヤ晶鍊兼槸**鍙嶅紩鍙疯剰瀛楃**锛� + - 閿欒鍊�(鎵嬪伐) **364**锛氱▼搴忎晶鐣欑┖銆佹墜宸ヤ晶 `#REF!`/`#DIV/0!`锛屽睘宸茬‘璁ょ殑"鍘嗗彶閿欒鍊肩暀鐧�"鍙ｅ緞锛� + - 鐢ㄦ埛鎵嬪伐鏀瑰姩 **1**锛歚鍩庡競姹囨��!G20` 鎺緸锛堝凡鐧昏 `USER_EDITS`锛夛紱 + - 鍏朵綑 1009 鏉′负宸叉寜鍙ｅ緞蹇界暐鐨勭粨鏋�/鏍煎紡绫伙紙缁撴瀯/璁捐銆佹棤琛ㄥご鑽夌鍒椼�佹帓鍚嶈〃褰撴湀/绱鍧椼�佹枃鏈瀷鏁板瓧 354銆佸彇鏁村熬宸�佸崟杈规湁鍊笺�佹帾杈炵瓑锛夈�� + - **缁撹**锛氫笌鎵嬪伐瀹氱**鏁板瓧涓�鑷�**锛屾棤鏂板闇�澶勭悊椤癸紱姣� 09-29"闇�澶勭悊=0"澶氬嚭鐨勯儴鍒嗗叏閮ㄦ簮浜庤瀹氱涓� **9/13 鐗�**銆佸皻鏈悓姝� 09-28 涔嬪悗鐨勬墜宸ユ敼鍔紙鎺緸/娓� 0/閿欒鍊肩暀鐧�/鎸夎蒋浠跺�煎悓姝ワ級鈥斺�斿睘瀹氱婊炲悗锛岄潪绋嬪簭鍥炲綊銆傛姤鍛婏紙鏈湴锛夛細`_tmp/_step0/diff_0813.md` / `.csv`銆� + +- **鐘舵��**锛�**銆愬緟楠屾敹銆�**锛堝彇鏁版柟寮忓睘鍙ｅ緞鐩稿叧鏀瑰姩锛夈�傛湭瀵煎叆浠讳綍涓氬姟鏁版嵁銆� +- **涓嬩竴姝�**锛歋tep 1 鎵╁垪鍣ㄦ湰浣擄紙閰嶇疆椹卞姩锛�8 涓彲瑙佸彴璐﹂〉锛浡�5.2 涓夋潯蹇呮敼鐐癸紱浜х墿鍏堣惤 `杈撳嚭/` 寰呬汉宸ョ‘璁ゅ悗鍐嶈惤鐩樹负涓嬫湡姣嶇増锛夈�� + +## 鏈�鏂帮紙2026-10-06锛寊yj 绾匡級 + +### 10-06锛氭媺鍙栧悎骞� + 楠屾敹闂ㄧ鍒嗙骇 + 姹囨�诲ぇ琛� M0 绔嬮」 + +- **鎷夊彇鍚堝苟**锛歚origin/main` 鐢� `8b739ce` 鏇存柊鍒� `54e10ae`锛堝悓浜� xyc 38 涓彁浜わ細鑺傚亣鏃ヤ笓椤圭粺璁°�佽娴嬬珯鍒嗘棩璋冩煡瀵煎叆銆乿1.0.0 鐗堟湰绠＄悊銆佹墦鍖呬笌 Windows 鏈嶅姟鑷惎绛夛級銆傛湰鍦版湭鎺ㄩ�佹彁浜� `ef85b05`锛�09-29 浜ゆ帴锛変繚鐣欙紝鍚堝苟鎻愪氦 `bee9e18`锛屾棤鍐茬獊锛涘悎骞跺悗鐩稿杩滅鐨勫樊寮傛濂藉彧鏈夋湰鍦扮殑 3 涓枃浠躲�� +- **楠屾敹闂ㄧ鍒嗙骇锛堢敤鎴� 2026-10-06 纭锛屽弬鑰冨悓浜嬪仛娉曪級**锛氫竴鑸姛鑳� / 淇 / 閲嶆瀯娌跨敤銆屾祴璇曢�氳繃鍗虫彁浜ゆ帹閫併�嶏紱鍙ｅ緞绫� / 鐗堝紡绫� / 浠讳綍浼氭敼杈撳嚭鏁板瓧鎴栬〃鏍肩増寮忕殑鏀瑰姩锛岀収甯告彁浜ゆ帹閫侊紝浣嗗繀椤诲湪 HANDOFF 鏍囨敞 **銆愬緟楠屾敹銆�**锛岀敤鎴烽獙鏀堕�氳繃鍚庡啀琛ヤ竴鏉� `docs(浜ゆ帴): 鈥 鎻愪氦鏀逛负銆屽凡楠屾敹锛堟棩鏈燂級銆嶃�傝鍒欏凡鍐欏叆 `AGENTS.md` 绗� 5 鏉°�� +- **姹囨�诲ぇ琛� M0 绔嬮」锛堣鏍煎緟瀹″畾锛�**锛氭柊澧� `docs/姹囨�诲ぇ琛∕0鐗堝紡閲嶅缓鍣ㄨ鏍糭2026-10-06.md`銆傜粨璁� **涓嶉噸鍐�**鈥斺�旇绠楀眰锛坄reportexport/calc` 绾� 900 琛岋級銆佸洖濉眰锛坄SummaryWorkbookFiller` 899 琛岋級銆佹墿鍒楀師璇紙`moveColumnPair` / `cloneColumnPair` / `cloneCellForMonth` / `cloneMergedRegion` / `copyColumnWidth` / `fixCumulativeFormulas`锛宍ReportExportService.java:1039-1200`锛夊潎宸插湪鐢紱缂哄彛鍙槸鎶婅繖浜涘師璇紪鎺掑埌 10 涓渶鎵╁垪闀胯〃椤碉紙宸插垪椤佃鏍艰〃锛岀害 2.45 涓囧鍏紡骞崇Щ锛夈�� +- **宸ヤ綔閲忛噸浼�**锛歁0 绾� **3.5鈥�5 澶�**锛堝惈娴嬭瘯涓庨獙鏀讹級锛屾鍓� 09-29 璁扮殑銆�0.5~1 澶┿�嶅亸涔愯锛屽彧绠椾簡鍘熻澶嶇敤銆� +- **鍗＄偣鏈彉**锛歚resolveSummaryMother`锛坄ReportExportService.java:4576`锛夊彧绮剧‘鍖归厤銆妠year}骞磠month}鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬶紝鐩爣鏈堟棤姣嶇増鍗虫姤閿欙紱9 鏈堟瘝鐗堜粛涓虹敤鎴� 09-29 鎵嬪伐鎵╁垪浜х墿锛堟湰鏈烘湭鍏ュ簱锛夈�� +- **寰呯‘璁�**锛氣憼 鎵╁垪钃濇湰鐢� 9 鏈堟墜宸ョ増杩樻槸 8 鏈堢増锛涒憽 鏄惁涓�娆″缓鎴� 12 鏈堟弧鐗堝紡锛堟柟妗� v1 寤鸿婊＄増寮忥級銆� +- **鐘舵��**锛氭湰娈典笌 M0 瑙勬牸鍧囦负銆愬緟楠屾敹銆戯紱鏈疆鏈敼鍔ㄤ换浣曚唬鐮併�傚伐浣滃尯鏈窡韪殑 `docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃*.xlsx` 涓� `docs/纭.docx` 鎸夌害瀹氫繚鐣欍�� + ## 鏈�鏂帮紙2026-10-06锛� ### 10-06锛氭姌绾垮浘绾靛悜闂磋窛鍔犻珮锛堥獙鏀堕�氳繃锛� @@ -402,6 +479,11 @@ - 缁撴灉锛氭寜褰撳墠姣嶇増閲嶆柊鐢熸垚 2026-08 鍚庯紝涓庢墜宸ュ畾绋跨殑**闇�澶勭悊宸紓 = 0**锛屽叾浣欏叏閮ㄨ惤鍦�"宸插拷鐣ワ紙绾﹀畾宸紓锛�"銆傛竻鍗曪細`docs/闂姹囨��/_娓呭崟_姣嶇増鏈�鏂扮敓鎴愪欢_20260928.md/.csv`锛堟湰鍦帮紝涓嶅叆搴擄級銆� - 娉ㄦ剰锛氭闈㈤偅浠� `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08.xlsx` 鏄棫瀵煎嚭锛堝惈鏃ч敊璇��/鏃у熀鏁帮級锛屼笌鏇存柊鍚庣殑瀹氱姣斿浼氭樉绀鸿緝澶氬樊寮傦紝浠�"姣嶇増閲嶆柊鐢熸垚浠�"涓哄噯銆� - **鏃犺〃澶磋崏绋垮垪娓呭崟锛�9 澶勶紝鍏� 539 鏍硷級**锛歚鍏氦/鍑虹/缃戠害杞�!U`锛堝悇 72锛夈�乣鍩庡競瀹㈣繍!U`锛�36锛夈�乣鐝嚎鍖呰溅!DU`锛�55锛岃〃澶�"1-3鏈堢疮璁�"锛夈�乣涓彛寰勬槑缁�!U`锛�90锛夈�乣涓彛寰勫杩愰噺!AB`锛�180锛夈�乣 璐ц繍!V` 涓� ` 璐ц繍!AX`锛堝悇 74锛岀敤鎴锋墍鎸� U 鍒楀湪鎵嬪伐閭ｄ唤鍙崇Щ涓�鍒楋級銆傛瘝鐗�/鐢熸垚浠�**宸插叏閮ㄦ竻绌�**锛屾墜宸ュ畾绋夸粛淇濈暀 鈫� 瀵规瘮鏃跺綊鍏ャ�屽凡鐭ヨ璁�(鏃犺〃澶磋崏绋垮垪)銆嶃�傚叾浣�"鏃犺〃澶村垪"鏄悎骞惰〃澶寸殑姝ｅ父鍒楋紙` 璐ц繍!C鈥` 鏈堜唤鍊煎垪銆佸悇骞村潡灏鹃儴绱/绱鍚屾瘮鍒椼�佹帓鍚嶉〉 R 鍒楃瓑锛夛紝涓よ竟閮芥湁銆侀潪鑽夌銆傛槑缁嗚 `docs/闂姹囨��/_宸茬‘璁ゅ樊寮傛竻鍗昣2026-08_20260928.md`銆� +- **09-29锛氱敤鎴锋墜宸ユ敼姣嶇増锛堜粎鏍煎紡 + 鍒犻櫎鑽夌锛夛紝骞剁珛椤规瘝鐗堟墿鍒楀櫒** + - 鐢ㄦ埛璇存槑鏈姣嶇増鏀瑰姩浠�"璋冩牸寮� + 鍒犺崏绋�"锛屾湭鍔ㄤ笟鍔″彛寰勶紱鎸囩汗鍙樺寲缂撳瓨鑷姩澶辨晥锛屽凡閲嶆柊鐢熸垚鏍稿锛氶渶澶勭悊 2 鏉� 鈫� `鍩庡競姹囨��!G20` 鎸�"浠ョ敤鎴锋墜宸ユ敼鍔ㄤ负鍑�"鐧昏涓�**宸茬煡宸紓(鐢ㄦ埛鎵嬪伐鏀瑰姩)**锛堝伐鍏锋柊澧� `USER_EDITS`锛夛紱鍓� `鐝嚎鍖呰溅!EO6` = `#DIV/0!`锛圵PS 淇濆瓨閲嶇畻浜х敓锛屽緟瀹氱暀鐧斤級銆� + - **姣嶇増鎵╁垪鍣紙鏂规 B锛�**锛氬鐢� `cloneColumnPair/moveColumnPair/cloneCellForMonth/cloneMergedRegion/copyColumnWidth/fixCumulativeFormulas` 涓� `SummaryWorkbookFiller.ensureMonth*`锛涢渶鏂板啓"鎵╁垪缂栨帓 + 姣忛〉瑙勫垯閰嶇疆 + 鍥炲綊鑷"銆�**褰撳勾鍐呮瘡鏈熶竴閿�佽法骞村姞涓�娆℃��"鏂板勾鍧�"閫昏緫**锛涢娆′及 0.5~1 澶┿�傜瓑鍚屼簨纭鍚庡厛鍑恒��19 椤垫墿鍒楄鏍艰〃銆嬨�� + - 杩愯鐘舵�侊細鍚庣 8090 / 鍓嶇 8080 宸茬敱 `start-dev.ps1` 鍚姩銆� + - 鐢ㄦ埛姣嶇増鏀瑰姩灏氭湭鎻愪氦锛屽緟纭鍚庝笌鎵╁垪鍣ㄤ竴璧锋彁浜ゃ�� - **寰呭姙**锛氣憼 鎺掑悕椤电粨鏋勶紙鍧楅『搴忋�佹爣棰樻帾杈炪�佸競宸炲悕鐭悕/鍏ㄥ悕銆佸懆杞噺鎺掑悕澶� 7 琛岋級锛涒憽 鎺掑悕椤电粨鏋勶紙鍧楅『搴忋�佹爣棰樻帾杈炪�佸競宸炲悕鐭悕/鍏ㄥ悕銆佸懆杞噺鎺掑悕澶� 7 琛岋級锛涒憿 缂� 2026-09 姣嶇増銆佸鍑哄墠鍩烘暟浣撴锛圥0-3锛夈�� ## 鏈�鏂帮紙2026-09-27锛� -- Gitblit v1.9.1