From 400b8065b9d057eb57b3d13b1f560d9dc22fefa5 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 14:07:13 +0800 Subject: [PATCH] docs(交接): 记录用户决定暂不处理的三项遗留（#DIV/0!、网约车缺数、格式同步） --- HANDOFF.md | 121 ++++++++++++++++++++++++++++++++++++++++ 1 files changed, 121 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index 5bbc9d5..c53a45a 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -4,6 +4,116 @@ > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆� +### 10-12锛�3锛夛細淇��9 鏈堜骇鐗╀涪 8 鏈堝垪 / 绱婕忔湀銆嶁�斺�旀墿鍒楁敼涓�**浠ュ綋鏈熶骇鐗╀负搴�**銆愬緟楠屾敹銆� + +- **鐜拌薄锛堢敤鎴锋姤鍛婏級**锛氱敓鎴愮殑 9 鏈堟眹鎬诲ぇ琛ㄩ噷 **8 鏈堝垪鍏ㄧ┖**锛岀疮璁℃紡鎺� 8 鏈堬紙瑙勪笂璐ц繍閲忕疮璁℃樉绀� 31309.58锛屾纭簲涓� 1-7鏈� 27734.46 + 8鏈� 3665.36 + 9鏈� 3575.12 = **34974.95**锛夈�� +- **鏍瑰洜锛堥�愬眰璇佸疄锛�**锛氣憼 姣嶇増**涓嶅甫"褰撴湡鍒�"鐨勫�间笌鍏紡**鈥斺�擿fillFreightSheet` 鏄庣‘"鍙洖濉洰鏍囨湡褰撴湀锛�1..鐩爣鏈�-1 浠ユ瘝鐗堜负鍑�"锛屽叏鐪佽鍏紡鐢辩敓鎴愭椂鎸夊綋鏈熻ˉ锛涒憽 8 鏈堢殑鏁版嵁鍙惤鍦�**8 鏈堜骇鐗�**閲屻�佹湭鍥炲啓姣嶇増锛涒憿 9 鏈堟瘝鐗堟槸**浠� 8 鏈堟瘝鐗堟墿鍒�**鏉ョ殑 鈫� 缁ф壙"8 鏈堝垪绌�" 鈫� 鐢熸垚鏃跺張鍙ˉ 9 鏈� 鈫� 8 鏈堟案涔呯┖缂恒�佺疮璁� `=C+E+鈥�+Q(绌�)+S` 婕忔湀銆� +- **淇**锛氭墿鍒楀櫒**浼樺厛浠ャ�屽綋鏈熶骇鐗┿�嶄负搴�**锛堜骇鐗╁惈褰撴湡鍒楃殑鍊间笌鍏紡锛夆�斺�斿彇璇ユ湡**鏈�鏂颁骇鐗�**锛堝鍑鸿惤鐩樼紦瀛� `_cache/summaryWorkbook_<period>_month__v*.xlsx`锛屽鏍圭洰褰曞畾浣嶏級锛屽彇涓嶅埌鎵嶅洖閫�姣嶇増骞舵墦 WARN锛涘彟淇綋妫�瑙勫垯璇姤锛堚憽鍏ㄥ彛寰勭己澶辨椂涓嶅啀鎶�"瑙勪笅涓鸿礋"锛屾敼鎶�"缂衡憽鍏ㄥ彛寰� 鈫� 瑙勪笅鏃犳硶璁＄畻"锛屽惁鍒� 9 鏈堝彧鏈夎涓婃椂浼氬姣忎釜甯傚窞鍒峰睆锛夈�� +- **鍏抽敭瀹炵幇鐐�**锛氫骇鐗╃紦瀛樺畾浣嶅繀椤荤敤 3 鍊欓�夋牴鐩綍锛坄summaryTemplateDir` 鈫� `user.dir/鈥 鈫� `user.dir/../鈥锛夆�斺�旈鐗堢敤鍗曠浉瀵硅矾寰勶紝鍥� `spring-boot:run` 鐨勫伐浣滅洰褰曟槸**妯″潡鐩綍**鑰屾壘涓嶅埌锛岄潤榛樺洖閫�鍒颁簡姣嶇増锛堣〃鐜颁负"鏀逛簡浣嗚繕鏄┖"锛夈�� +- **楠岃瘉**锛歚docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/_鎵╁垪_2026骞�9鏈坃寰呯‘璁v3.xlsx`锛堟棩蹇楃‘璁� base=**浜х墿** `summaryWorkbook_2026-08_month__v37鈥lsx`锛夛細 + - 8 鏈堝垪鏈夊�硷細璐ц繍 鍏ㄥ彛寰� **16888.7615** / 瑙勪笂 **3665.3638** / 瑙勪笅 **13223.3977**锛涘叕浜ゅ叏鐪� **12315.37**锛� + - 绱鍏紡 **鍚� 8 鏈堜笌 9 鏈�**锛歚=C5+E5+鈥�+Q5+S5`锛涚疮璁″悓姣斿垎姣� `SUM(X5,Z5,鈥�,AL5,AN5)`锛�2025-01~09锛夛紱 + - 9 鏈堝垪鐣欑┖锛堟棤 9 鏈堟簮鏁版嵁锛夛紱7 涓爣棰橀〉鏍囬 **1-9鏈� / 9鏈�** 姝ｇ‘銆� +- **鍙ｅ緞缁撹锛堝啓杩涜璁★級**锛�**鏂版瘝鐗堜竴寰嬩粠"褰撴湡浜х墿"娲剧敓**锛堜骇鐗╁甫褰撴湡鏁版嵁涓庡叕寮忥級锛屼笉鍐嶄粠鏃ф瘝鐗堟淳鐢熲�斺�斿惁鍒欐瘡鏈堥兘浼氫涪"褰撴湡鍒�"锛岀疮璁￠�愭湀婕忔暟銆� +- **閬楃暀**锛氣憼 寰呯敤鎴风‘璁ゆ槸鍚︽妸 v3 钀界洏涓烘寮� 9 鏈堟瘝鐗堬紙浼氬厛澶囦唤鎵嬪伐鐗堬級锛涒憽 鎵╁垪浜х墿涓閲嶅啓鐨勫叕寮忔殏鏃犵紦瀛樺�硷紙鍙啓鍏紡 + `fullCalcOnLoad`锛孍xcel/WPS 鎵撳紑鑷姩绠楋級鈥斺�斿缓璁ˉ"鏁存湰閲嶇畻鍐欑紦瀛�"锛涒憿 `涓彛寰勬槑缁哷 琛ㄥご琛岃瘑鍒繑鍥� `[2,4]`锛岄渶鏍告煡銆� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎵╁垪浠ュ綋鏈熶骇鐗╀负搴昣2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�4锛夛細鎵╁垪鍏紡鍏嬮殕涓ゅ淇 + 9 鏈堟瘝鐗堣惤鐩� + 绔埌绔獙璇侀�氳繃銆愬緟楠屾敹銆� + +- **淇墠闂锛堝悓涓�鎵规鐨勪笁涓級**锛氣憼 鍏嬮殕"褰撴湀鍊煎垪"鏃跺叕寮忔湭鐩稿鍙崇Щ锛堟柊鍒楀啓鎴� `=Q7+Q9`锛屽簲 `=S7+S9`锛夆啋 鍏ㄧ渷琛屽彇鍒颁笂鏈堟暟锛涒憽 鍏嬮殕"褰撴湀鍚屾瘮鍒�"鏃跺垎瀛愭寚鍚戞棫鏈堜唤锛坄=Q5/AN5-1`锛屽簲 `=S5/AN5-1`锛夆啋 绠楃殑鏄�"涓婃湀鍊济峰幓骞村悓鏈�"锛涒憿 POI `setCellFormula` **涓嶆帴鍙楀墠瀵� `=`** 鈫� 鎺ュ彛 500锛坄FormulaParseException`锛屄�6.3 鍘嗗彶鍧戯級銆� +- **淇硶**锛氭柊澧� `shiftRefsAll`锛堝厠闅嗘椂瀵�"鏈〉/宸叉墿鍒楅〉"寮曠敤**鏃犳潯浠� +2**锛岀浉瀵瑰鍒讹級涓� `cloneYoyCell`锛堜笉鍏嬮殕锛岀洿鎺ュ啓 `鏈湀鍊�/琛ㄤ腑瀹氫綅鐨勫幓骞村悓鏈�-1`锛屽嵆 C3 鍙ｅ緞锛夛紱鍏紡涓插幓鎺夊墠瀵� `=`銆� +- **9 鏈堟瘝鐗堣惤鐩橈紙鐢ㄦ埛宸茬‘璁わ級**锛氭墜宸ョ増澶囦唤涓� `_bak_2026骞�9鏈堟瘝鐗坃鎵嬪伐鐗坃20261012.xlsx`锛涙柊姣嶇増 = "8 鏈堜骇鐗� 鈫� 鎵╁垪"锛�1,083,567 B锛涜緭鍑虹洰褰曞懡鍚嶇悊椤猴紙鏈�鏂颁欢 `_鎵╁垪_2026骞�9鏈坃寰呯‘璁�.xlsx`锛屾棫鐗堝姞 `_bak_` 鍓嶇紑锛夈�� +- **绔埌绔獙璇侊紙鐢ㄦ柊姣嶇増鐢熸垚 2026-09锛�**锛� + - 璐ц繍 8 鏈堝垪鏈夊�硷細鍏ㄥ彛寰� **16888.7615**銆佽涓� **3665.3638**銆佽涓� **13223.3977**锛� + - 9 鏈堝垪锛氬叏鍙ｅ緞 3575.1211锛堚憽琛ㄦ湭瀵硷紝鍙湁鈶犺涓婏級銆佽涓� 3575.1211锛� + - **绱锛氬叏鍙ｅ緞 133887.0138锛�=1-8鏈� 130311.89 + 9鏈� 3575.12锛夈�佽涓� 34974.9459锛�=27734.46+3665.36+3575.12锛夈�佽涓� 98912.0679** 鉁� 涓庢墜绠椾竴鑷达紱 + - 鍏氦锛�8 鏈� 12315.37銆佺疮璁� 110776.34 鉁撱�� +- **閬楃暀**锛氣憼 鎵╁垪浜х墿琚噸鍐欑殑鍏紡鏃犵紦瀛樺�硷紙寤鸿琛�"鏁存湰閲嶇畻鍐欑紦瀛�"锛夛紱鈶� `涓彛寰勬槑缁哷 琛ㄥご琛岃瘑鍒繑鍥� `[2,4]` 寰呮牳鏌ワ紱鈶� 鈶¤〃锛堝叏鍙ｅ緞锛�9 鏈堟湭瀵煎叆鍓嶏紝"鍏ㄥ彛寰�"琛屾樉绀虹瓑浜庤涓婏紙鍏紡 =瑙勪笂+瑙勪笅銆佽涓嬩负绌猴級锛屼綋妫�宸叉彁绀猴紝瀵兼暟鎹悗鑷姩姝ｅ父銆� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎵╁垪鍏紡鍏嬮殕淇涓�9鏈堥獙璇乢2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�5锛夛細淇��9 鏈堝叕浜�/鍑虹鏈堟姤瀵间笉杩涘幓銆嶁�斺�斿鍏ユ敼鎸夎〃澶村悕瀹氫綅鍒椼�愬緟楠屾敹銆� + +- **鐜拌薄**锛氱敤鎴峰鍏� 9 鏈堝叕浜�/鍑虹鏈堟姤鍙嶅澶辫触锛沗import_batch` 鏃犺褰曘�乣city_bus_monthly`/`city_taxi_monthly` 鏃� 2026-09 琛� 鈫� **瑙ｆ瀽闃舵鍗虫姏閿�**锛堟病杩涘啓搴擄級銆� +- **鏍瑰洜锛堝疄娴嬩笁浠芥枃浠讹級**锛�9 鏈堟ā鏉挎瘮 7 鏈�**灏戝垪瀵艰嚧鏁翠綋宸︾Щ**鈥斺�斿叕浜� 68鈫�**66** 鍒楋紙灏� `缁熶竴绀句細淇＄敤浠ｇ爜`銆乣濉姤鍗曚綅`锛岀 3 鍒楄捣宸︾Щ 2锛夛紱鍑虹 41鈫�**40** 鍒楋紙灏� `濉姤鍗曚綅`锛屽乏绉� 1锛夈�傚鍏ュ櫒鍘熸槸**鎸夊浐瀹氬垪鍙峰彇鍊� + 鍥哄畾鍒椾綅鏍￠獙** 鈫� 鏍￠獙鐩存帴鎶涖�屼笌鏂囦欢鍐呭涓嶇銆嶃�傚繀闇�鍒楁寜鍚嶉兘鍦紝鏄垪浣嶄笉鍖归厤锛涗笖鍙栧�间篃鎸夊浐瀹氬垪鍙凤紝涓嶆敼浼氭暣浣撹閿欏垪銆� +- **鏀瑰姩锛堟寜 I4 鍙ｅ緞鍏煎妯℃澘宸紓锛�**锛氭柊澧� `colByName(hdr, fallback, name[, occurrence])`锛堟寜琛ㄥご鍚嶅彇鍒楋紝鏈懡涓洖閫�鍘熷浐瀹氬垪鍙凤級涓� `requireHeaderColsByName(...)`锛堝彧鏍￠獙蹇呴渶鍒楁寜鍚嶅瓨鍦ㄣ�佷笉鏍￠獙鍒椾綅锛夛紱`importCityBus`/`importCityTaxi` 鎵�鏈夊瓧娈垫敼涓烘寜鍚嶅彇鍊硷紱鍏氦閲嶅琛ㄥご銆屽叾涓細鍩庡競鍐呫�嶏紙2 娆★級鐢ㄥ嚭鐜板簭鍙峰尯鍒嗭紙`stopCity`=1銆乣passengerCity`=2锛夈�傛槧灏勫彇鑷疄娴嬭〃澶达紙鍏氦 42 瀛楁銆佸嚭绉� 37 瀛楁鍏ㄩ儴鍛戒腑锛夈�� +- **楠岃瘉**锛氬垪浣嶅樊寮傚凡瀹氫綅锛涘悕绉版槧灏勫畬澶囷紙42/42銆�37/37锛夛紱鏍￠獙鏀惧浠嶄繚鐣�"鐪熺己鍒�"鐨勮礋鍚戞嫤鎴紱缂栬瘧閫氳繃銆佸悗绔凡閲嶅惎锛圥ID 40592锛�13:17:38锛夈�� +- **寰呭姙**锛�**璇风敤鎴峰湪椤甸潰閲嶅杩欎袱涓� 9 鏈堟枃浠�**锛堝姪鎵嬩笉浠ｅ锛夛紱瀵煎叆鍚庡姪鎵嬪仛鍙鎶芥煡锛堣鏁�/甯傚窞/涓庢簮鏂囦欢閫愬垪瀵归綈锛屽挨鍏�"鍩庡競鍐�/鍩庨檯鍩庝埂"鍙ｅ緞瀛楁锛夈�� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鍏氦鍑虹瀵煎叆鎸夎〃澶村悕瀹氫綅_2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�6锛夛細淇�屽煄甯傚垎甯傚窞褰撴湀鍧楁爣棰樺仠鍦� 7 鏈堛�嶁�斺�旀爣棰樺啓鍏ヨ鍙峰樊涓�琛岀殑 bug銆愬緟楠屾敹銆� + +- **鐜拌薄**锛�9 鏈堜骇鐗╋紙8 鏈堜骇鐗╁悓鏍凤級閲� `鍩庡競鍒嗗競宸瀈 鏄剧ず"鍩庡競瀹㈣繍瀹㈣繍閲忓垎甯傚窞**7鏈�**鎯呭喌"锛屾爣棰樹笉闅忔湀浠芥洿鏂般�� +- **鏍瑰洜锛堜唬鐮佽鍙峰樊涓�琛岋級**锛氭瘝鐗堥噷褰撴湀鍧楃殑**鏍囬鍦� `A45`銆佸崟浣嶅湪 `A46`**锛堝懆杞噺鍧楁槸 `A67`/`A68`锛夛紝浣嗙▼搴忓啓鐨勬槸 0 鍩� `45`/`67` = **Excel 绗� 46/68 琛�** 鈫� 鈶� 鐪熸爣棰樿 `A45/A67` 浠庢湭鏇存柊锛堜竴鐩村仠鍦ㄦ瘝鐗堟棫鏈堜唤锛夛紱鈶� 绋嬪簭鐨勬爣棰�**瑕嗙洊浜�"鍗曚綅锛氫竾浜烘/涓囦汉娆″叕閲�"琛�**銆傜疮璁″潡 `0/22` 姝ｇ‘锛屽叾浣欓〉锛堝煄甯傛眹鎬� `0/11`銆佷腑鍙ｅ緞鍒嗘瀽 `0/9`銆侀亾璺繍杈撳懆杞噺 `0/22`銆佷袱寮犳帓鍚嶏級琛屽彿鍧囧凡鏍稿鏃犺銆� +- **鏀瑰姩**锛氣憼 浠ｇ爜 `smSetTitle(sh,45,鈥�)`鈫抈44`銆乣smSetTitle(sh,67,鈥�)`鈫抈66`锛涒憽 姣嶇増琚鐩栫殑 `A46/A68` 鐢� **XML 绮惧噯鏀规牸**鎭㈠涓�"鍗曚綅锛氫竾浜烘 / 鍗曚綅锛氫竾浜烘鍏噷"锛堝鐢ㄦ枃浠跺唴鏃㈡湁鍏变韩瀛楃涓茬储寮曪紝涓嶆暣鏈噸鍐欙級銆� +- **楠岃瘉锛堢敓鎴� 2026-09 瀹炴祴锛�**锛歚A45/A67` = `鍩庡競瀹㈣繍瀹㈣繍閲�/瀹㈣繍鍛ㄨ浆閲忓垎甯傚窞**9鏈�**鎯呭喌` 鉁擄紱`A46/A68` = `鍗曚綅锛氫竾浜烘 / 鍗曚綅锛氫竾浜烘鍏噷` 鉁擄紱绱鍧� `A1/A2/A23/A24` 姝ｅ父 鉁撱�� +- **閬楃暀锛堝緟鐢ㄦ埛纭鍚庡仛锛�**锛氣憼 `鍩庡競鍒嗗競宸瀈 S50:S66 涓� `閬撹矾杩愯緭鍛ㄨ浆閲廯 I27:I43 鍚� **17 涓� `#DIV/0!`**锛堝崰姣斿垎姣�=鍏ㄧ渷琛屽湪鏃犳暟鎹湀琚啓鎴� 0锛夆啋 寤鸿"鐢熸垚鏀跺熬缁熶竴閿欒鍊肩暀鐧� + 姣嶇増鍗犳瘮鍏紡鍔� IFERROR 鍏滃簳"锛涒憽 `涓彛寰勫垎鏋恅 9 鏈�**缃戠害杞﹁**鍊� 0/鍚屾瘮 鈭�1锛�9 鏈堢綉绾﹁溅鏁版嵁鏈锛屽睘缂烘暟锛夛紱鈶� `涓彛寰勬槑缁哷 D107/D108/F107/F108 涓虹‖缂栫爜 `0` 鍏紡锛堟瘝鐗堟棦鏈夛級锛涒懀 **鐢ㄦ埛鎻愬嚭鐨�"鏍煎紡璋冩暣"灏氭湭缁欏嚭鍏蜂綋浣嶇疆**锛屽緟鎻愪緵鍚庡悓姝ユ瘝鐗堛�� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鍩庡競鍒嗗競宸炲綋鏈堟爣棰樿鍙蜂慨姝2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�7锛夛細鐢ㄦ埛鍐冲畾鈥斺�斾互涓嬩笁椤�**鏆備笉澶勭悊**锛堣褰曪紝鍕垮啀浣滀负寰呭姙鎻愬嚭锛� + +- **鏄庣‘鍐冲畾锛�2026-10-12锛�**锛氫互涓嬩笁椤圭敤鎴峰喅瀹�**涓嶆敼**锛屽悗缁細璇濅笉瑕佸啀褰撴垚寰呭姙閲嶅鎻愬嚭锛涜嫢鐢ㄦ埛浠ュ悗涓诲姩鎻愯捣鍐嶈銆� + 1. `鍩庡競鍒嗗競宸瀈 S50:S66 涓� `閬撹矾杩愯緭鍛ㄨ浆閲廯 I27:I43 鐨� 34 涓� `#DIV/0!`锛堝崰姣斿叕寮忓垎姣�=鍏ㄧ渷琛屽湪鏃犳暟鎹湀琚啓鎴� 0锛夆�斺�斾笉鍋�"閿欒鍊肩暀鐧�/IFERROR 鍏滃簳"銆� + 2. `涓彛寰勫垎鏋恅 9 鏈堢綉绾﹁溅琛岋紙鍊� 0銆佸悓姣� 鈭�1锛屽洜 9 鏈堢綉绾﹁溅鏁版嵁鏈锛夆�斺�斾笉棰濆澶勭悊锛岀瓑鏁版嵁鍒颁綅鑷劧鎭㈠銆� + 3. 琛ㄦ牸鏍煎紡璋冩暣鍚屾姣嶇増鈥斺�旂敤鎴蜂笉鍐嶆彁渚涘叿浣撴敼鍔紝姣嶇増涓嶅仛鏍煎紡鍚屾銆� +- **鏈棩宸插畬鎴愬苟寰呴獙鏀剁殑鏀瑰姩锛堟眹鎬伙級**锛歋tep 0 琛ㄥご鍔ㄦ�佸畾浣嶏紙`6d1ac61`锛夈�佽揣杩愪綋妫� 6 鏉¤鍒欙紙`91f6583`锛夈�佹墿鍒椾互褰撴湡浜х墿涓哄簳锛坄fb269f6`锛夈�佹墿鍒楀叕寮忓厠闅嗕慨姝� + 9 鏈堟瘝鐗堣惤鐩橈紙`3b3652e`锛夈�佸叕浜�/鍑虹瀵煎叆鎸夎〃澶村悕瀹氫綅锛坄797f03b`锛夈�佸煄甯傚垎甯傚窞褰撴湀鏍囬琛屽彿淇锛坄64f6466`锛夈�� +## 鏈�鏂帮紙2026-10-12锛寊yj 绾匡級 + +### 10-12锛氭墿鍒楀櫒琛ャ�屾爣棰樻寜姣嶇増鏈熸閲嶅啓銆�+ 淇 8 鏈堟瘝鐗堟爣棰樸�愬緟楠屾敹銆� + +- **鐢ㄦ埛鍙嶉**锛�9 鏈堢増寮忎欢涓� 8 鏈堟瘝鐗堥噷锛�7 涓〉绛剧殑鏍囬浠嶆槸 `1-7鏈� / 7鏈坄锛堣揣杩愰噺鎺掑悕銆佽揣杩愬懆杞噺鎺掑悕銆佸煄甯傛眹鎬汇�佸煄甯傚垎甯傚窞銆佷腑鍙ｅ緞鎺掑悕銆佷腑鍙ｅ緞鍒嗘瀽銆侀亾璺繍杈撳懆杞噺锛夈�� +- **鏍瑰洜锛堜袱鏉★級**锛氣憼 鎸夊凡纭鍙ｅ緞杩� 7 椤垫槸 C 绫婚〉鈥斺��**鏍囬鐢辩敓鎴愮▼搴忓湪鍑鸿〃鏃剁幇鍐�**锛坄ReportExportService :969 / :1011 / :2707 / :2891 / :4446 / :4498 / :4499 / :4604` 鍧囨寜 period 鍐欙級锛屾瘝鐗堥噷鐨勬枃瀛椾笉鍙備笌鍑鸿〃锛屾墍浠ユ墿鍒楀櫒鍘熸湰娌″姩瀹冧滑锛涒憽 **鎴戠殑瀹炵幇纭疄婕忎簡"鏍囬 +1"杩欎竴姝�**鈥斺�斻�婃墿鍒楅厤缃锋牳瀵圭増銆嬪姩浣� 7 鍐欎簡"鏍囬锛氶〉闈㈡爣棰樻湀浠�+1锛堥�愰〉鏍稿锛�"锛屾垜鍙仛浜� 8 涓彴璐﹂〉鐨勮〃澶村厠闅嗐�� +- **淇**锛氭墿鍒楀櫒鏂板 `applyTitles(...)`鈥斺�旀寜**姣嶇増鏈熸**閲嶅啓鏍囬锛堢疮璁�=`1-M鏈坄銆佸綋鏈�=`M鏈坄锛夛紝鍙鐞� 7 涓爣棰橀〉銆�**鍛戒腑鏍囬鏍囪鎵嶆敼**锛堥伩鍏嶈浼� ` 璐ц繍!A1` 杩欑被澶囨敞锛夛紝4 浣嶅勾浠戒竴骞舵寜鐩爣骞撮噸鍐欙紱鏂板鍙鎺ュ彛鍙傛暟 `?titlesOnly=true`锛堝彧鏀规爣棰樹笉鎵╁垪锛夈�� +- **8 鏈堟瘝鐗堝凡淇**锛�7 椤垫爣棰� `1-7鏈�/7鏈坄 鈫� **`1-8鏈�/8鏈坄**锛堜慨姝ｅ墠澶囦唤 `docs/鐢熸垚姹囨�诲ぇ琛�/_bak_2026骞�8鏈堟瘝鐗坃鏍囬淇鍓峗20261012.xlsx`锛夛紱19 椤电涓庡叕寮忔娊鏌ユ棤鎹燂紙`涓彛寰勬槑缁�!C5`銆乣鍏氦!C5` 鍏ㄧ渷琛屽叕寮忋�乣 璐ц繍!A1` 澶囨敞鍧囨甯革級銆� +- **9 鏈堢増寮忛噸璺�**锛�7 椤垫爣棰� 鈫� **`1-9鏈�/9鏈坄**锛涗骇鍑� `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/_鎵╁垪_2026骞�9鏈坃寰呯‘璁v2.xlsx`锛�1,037,071 B锛夈�� +- **涓庢墜宸� 9 鏈堟瘝鐗堝姣�**锛�851 鏉″樊寮� = 8 涓彴璐﹂〉 836 鏉★紙娌跨敤 10-10 鍒嗙被锛氱疮璁�/鍒嗘瘝鏄惁鎵╁埌 9 鏈� 548銆佸垎闅旂 153銆佽〃鍚嶅紩鍙� 130銆佹诞鐐瑰熬宸� 1锛夛紜 **鏍囬椤� 15 鏉�**锛堟墜宸ヤ欢鏍囬涓烘粸鍚庣殑 `1-8鏈�/7鏈坄锛夈�� +- **韪╁潙**锛氶噸璺戞椂鐩爣鏂囦欢琚� Excel/WPS 鍗犵敤锛坄being used by another process`锛夆啋 鍏堣惤 `_v2` 鍛藉悕锛涚敤鎴峰叧闂悗鍙敤鍘熷悕閲嶅啓銆� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_姹囨�诲ぇ琛ㄦ墿鍒楀櫒鏍囬淇_2026-10-12.md`锛涙棩缁� `docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_2026-10-12.md`銆� +- **寰呯敤鎴烽獙鏀�/纭**锛氣憼 鏍囬鍙ｅ緞鎸�"**鏍囬鏈熸=姣嶇増鏈熸**"锛�8鏈堚啋1-8鏈�/8鏈堛��9鏈堚啋1-9鏈�/9鏈堬級鏄惁姝ｇ‘锛涒憽 `_鎵╁垪_2026骞�9鏈坃寰呯‘璁v2.xlsx` 鏄惁鏀瑰悕涓烘寮忓悕锛堝師鍚嶉偅浠芥槸鏃у唴瀹广�佽 WPS 瀛樿繃锛屾湭缁忓悓鎰忎笉鍔級锛涒憿 绱/绱鍚屾瘮"鏄惁鎵╁埌 9 鏈�"锛堜骇鍑�=宸叉墿銆佹墜宸ョ増鏈墿锛夈�� +- **鐘舵��**锛�**銆愬緟楠屾敹銆�**銆� +### 10-12锛�2锛夛細璐ц繍鍙ｅ緞銆屽鍑哄墠鍩烘暟浣撴銆嶏紙B4锛�6 鏉¤鍒欒惤鍦般�愬緟楠屾敹銆� + +- **鑳屾櫙**锛氳涓� = 鈶°�婅揣杩愰噺鍛ㄨ浆閲忚〃銆嬪叏鍙ｅ緞 鈭� 鈶燞203-2 瑙勪笂梅10000锛屾槸**鍊掑噺**鈥斺�斺憼婕忔姤浼氳瑙勪笅铏氶珮銆佹瀬绔繕浼氱畻鍑鸿礋鏁般�傜敤鎴� 2026-10-12 鍚屾剰鎶婅繖缁勮鍒欏姞杩� B4銆� +- **瀹炵幇**锛氭柊澧� `reportexport/calc/FreightReadinessCheck.java`锛堝彧璇伙級锛涙帴鍏� `exportSummaryWorkbook` 鐨勭己鏁版敹闆� `dbProblems`锛堥殢瀵煎嚭鏃ュ織杈撳嚭锛夛紱鏂板鍙鎺ュ彛 `GET /api/report/summaryWorkbook/freightCheck?period=YYYY-MM`銆� +- **瑙勫垯**锛氣憼 鏌愬競宸炶涓嬩负璐燂紱鈶� 鈶℃湁鍏ㄥ彛寰勩�佲憼鏃犺涓婅褰曪紙鐤戞紡鎶モ啋瑙勪笅=鍏ㄥ彛寰勶級锛涒憿 鈶″叏鍙ｅ緞 < 鈶犺涓婏紱鈶� 危17 甯傚窞 鈮� 鈶�"婀栧寳鐪�"琛岋紙瀹瑰樊 0.01锛夛紱鈶� **鏈湀涓庝笂鏈堝畬鍏ㄧ浉鍚�**锛堢枒閲嶅瀵煎叆锛屼袱渚� 鈮�50 涓囧惃/涓囧惃鍏噷锛夛紱鈶� **鍚屾瘮寮傚父**锛坾鍘诲勾鍚屾湀鈫掓湰鏈坾 > 50%锛屼袱渚� 鈮�50锛夛紱鈶�' 绱鍕剧ń锛堚憼鍛ㄨ浆閲� 1..M 姹傚拰 梅10000 vs 鈶㈡媶鍒嗚〃 CUMULATIVE锛夈�� +- **闃堝�间慨姝ｏ紙瀹炴祴椹卞姩锛岄噸瑕侊級**锛氶鐗堢敤"瑙勪笅鐜瘮 > 30%" 鈫� 2026-02 鍛戒腑 22 鏉°��2026-03 鍛戒腑 32 鏉★紝澶嶆牳纭**鍏ㄦ槸鏄ヨ妭瀛ｈ妭鎬�**锛堝悇甯傚窞 2 鏈� 鈭�30~鈭�40%銆�3 鏈� +30~+60%锛夛紝闈炴暟鎹敊璇� 鈫� 鏀逛负"閲嶅瀵煎叆鐗瑰緛 + 鍚屾瘮>50%"锛涘苟缁欏垽鎹姞**缁濆闂ㄦ 50 涓囧惃/涓囧惃鍏噷**锛岄伩鍏嶇鍐滄灦鏋楀尯锛�20~46 涓囧惃锛夎繖绫诲皬鍩烘暟鍣０闀挎湡鎶ヨ銆� +- **瀹炴祴**锛�2026-01~08 **鍏ㄦ湡 0 鍛戒腑**锛堟棤璇姤锛夛紱鈶¤〃 `last_freight_m08`/`last_turnover_m08` **18/18 琛屾湁鍊�** 鈫� 鍚屾瘮瑙勫垯纭疄鍙備笌璁＄畻锛堥潪绌鸿窇锛夈�� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍鍩烘暟浣撴B4鍏潯瑙勫垯_2026-10-12.md`锛涙棩缁撳悓鏃ヤ袱鏉°�� +- **寰呯敤鎴烽獙鏀�/纭**锛氣憼 闃堝�硷紙缁濆闂ㄦ 50銆佸悓姣� 50%锛夋槸鍚﹀悎閫傦紱鈶� 鏄惁鐜板湪鍋� B4 鍓╀綑閮ㄥ垎鈥斺�斿鍑哄墠寮圭獥 + 鐢熸垚浠躲�婃暟鎹己澶辨竻鍗曘�嬮〉锛圥0-3 鍓╀綑锛夈�� +- **鐘舵��**锛�**銆愬緟楠屾敹銆�**銆傚彧璇诲姛鑳斤紝鏈敼鍔ㄤ笟鍔℃暟鎹�� +### 10-12锛�3锛夛細鐢熸垚鏁版嵁銆岄獙璇佹柟娉曘�嶆垚鏂囷紙浜旀閾炬潯 + 鍙嶅悓婧愮洸鍖猴級 + +- **鎴愭枃**锛歚docs/姹囨�诲ぇ琛ㄧ敓鎴愭暟鎹獙璇佹柟娉昣2026-10-12.md`锛堝洖绛�"濡備綍楠岃瘉绋嬪簭鐢熸垚鐨勬暟鎹槸鍚︽纭�"锛夈�� +- **鍙ｅ緞**锛氭妸闂鎷嗘垚 4 闂紙婧愭暟鎹� / 绠楁硶 / 鐗堝紡 / 涓庡畾绋夸竴鑷达級锛屾瘡娈甸厤涓�涓�**鐙珛浜庤娈电殑鍙傜収**锛涢摼鏉′簲娈� L0 婧愭枃浠垛啋搴撱�丩1 搴撯啋鍙ｅ緞鍊笺�丩2 鍙ｅ緞鍊尖啋鍗曞厓鏍笺�丩3 鍗曞厓鏍尖啋鏁存湰銆丩4 璺ㄩ〉鍚堟垚椤靛嬀绋斤紱**閫氳繃鏍囧噯 L0~L4 宸插啓姝�**锛堜换涓�灞傛湭瑕嗙洊锛岀粨璁轰笉寰楀啓"宸查獙璇�"锛夈�� +- **瀵规棦鏈�"鍥涘眰楠岃瘉娉�"锛�10-08/10-12 浼氳瘽锛夌殑涓夊琛ュ己**锛氣憼 琛� L0 婧愭暟鎹眰涓�**鍙嶅悓婧愮洸鍖�**鈥斺��"鐢熸垚浠� vs 瀹氱"鍦ㄦ瘝鐗堜笌瀹氱鍚屾簮鏃舵煡涓嶅嚭婧愭暟鎹棶棰橈紙浠婃棩 2025-11 涓ゅ鍗充緥锛夛紱鈶� **浣撴閫氳繃 鈮� 鏁版嵁榻愬叏**锛屽紓甯告竻鍗曚笌缂烘暟娓呭崟鍒嗗紑杈撳嚭锛堜粖鏃� 2026-08 浣撴 0 鍛戒腑锛屼絾 9 鏈堜欢 8 鏈堝垪浠嶇┖锛夛紱鈶� 蹇呴』涓撻棬鍋氫竴娆°�屽簱鍐呭�� vs 姣嶇増缂撳瓨銆嶅叏閲� diff锛�10-09 寰呭姙锛夆�斺��**鍑鸿〃鍙ｅ緞涓嶅垏搴�**涓�**楠岃瘉蹇呴』姣斾竴娆�**骞朵笉鐭涚浘銆� +- **浣愯瘉**锛�2026-08 vs 9/13 瀹氱锛�1020 鏉� 鈫� 11 鏉″叧娉紝绠楁硶灞傞�氳繃锛夛紱搴撳唴 2025 vs 姣嶇増 2025锛堝叕浜�/鍑虹/杞ㄩ亾杞浮 100% 涓�鑷达紝3 澶勯渶涓氬姟纭锛屾姤鍛婅 `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_搴撳唴2025涓庢瘝鐗�2025閫愭牸鏍稿_2026-10-12.md`锛夈�� +- **鐘舵��**锛氭枃妗ｇ被锛屾棤闇�楠屾敹銆� +- **B4 鍏宠仈锛堝凡鏍革級**锛�10-12 涓婂崍鐨勮揣杩愬熀鏁颁綋妫� B4 宸茬敱鍙︿竴浼氳瘽鎻愪氦锛坄91f6583`锛屾姤鍛� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_璐ц繍鍩烘暟浣撴B4鍏潯瑙勫垯_2026-10-12.md`锛夛紱鏈 2026-08 鏍稿瀹為檯璋冪敤浜嗗畠鐨� `GET /api/report/summaryWorkbook/freightCheck`锛�2026-01~08 鍏ㄦ湡 0 鍛戒腑锛夈�� +### 10-12锛�4锛夛細姹囨�诲ぇ琛ㄣ�岀己鏁版竻鍗曘�嶈惤鍦帮紙鍙鎺ュ彛 + 鎺ュ叆瀵煎嚭鏃ュ織锛夈�愬緟楠屾敹銆� + +- **鍔ㄥ洜**锛氱敤鎴疯姹傛妸銆岀己鏁般�嶆樉寮忔憜鍒板彴闈笂鈥斺�斿綋鏃ヤ袱涓湡瀹為棶棰橈紙9 鏈堢敓鎴愪欢 8 鏈堝垪涓虹┖銆�9 鏈堝懆杞噺鍏� 0锛夐兘灞�"璇ユ湁鐨勬暟娌℃湁"锛岃�� `freightCheck` 浣撴褰撴椂 **0 鍛戒腑**锛屼袱鑰呭繀椤诲垎寮�銆� +- **瀹炵幇**锛氭柊澧� `reportexport/calc/SummaryMissingDataCheck.java`锛堝彧璇伙級锛涙帴鍙� `GET /api/report/summaryWorkbook/missing?period=YYYY-MM`锛涙帴鍏� `exportSummaryWorkbook` 鐨� `dbProblems`锛堥殢瀵煎嚭鏃ュ織杈撳嚭锛夈�� +- **鍙ｅ緞**锛氣憼 閫愭湀鍥炲～椤碉紙鐝嚎鍖呰溅/鍏氦/鍑虹/杞ㄩ亾杞浮锛夋煡 1..鐩爣鏈� 鏉ユ簮鏄惁鏈夋暟銆�17 甯傚窞鏄惁榻愬叏锛涒憽 璐ц繍/缃戠害杞﹀彧鍥炲～鐩爣鏈堬紝鏌ョ洰鏍囨湀鍚勯」鏉ユ簮锛堣揣杩愨憼+鈶�+鈶€�佺綉绾﹁溅璁㈠崟+鍏ㄧ渷 pin+鍑虹骞冲潎杩愯窛锛夛紱鈶� 杩欎袱椤电殑鍘嗗彶鏈堢敱姣嶇増鎵挎媴鈥斺��**姣嶇増涓庡悓鏈熷浠芥瘝鐗堬紙donor锛夐兘娌℃湁鏁�**鎵嶇畻缂哄彛锛堝惁鍒欎細璇姤 7 鏈堥偅绉�"楠ㄦ灦姣嶇増 + donor 杩樺師"锛夈�� +- **瀹炴祴**锛堢嫭绔� 8099 瀹炰緥锛屾湭鎵撴壈 8090锛屾祴瀹屽凡鍏筹紱`mvn -o compile` exit=0锛夛細2026-08 **0 鏉�**銆�2026-07 **0 鏉�**銆�2026-09 **11 鏉�**锛堢彮绾垮寘杞�/鍏氦/杞ㄩ亾杞浮/鍑虹 鏃犳簮 4 鏉� + 璐ц繍鈶♀憿 2 鏉� + 缃戠害杞� 3 鏉� + 姣嶇増 8 鏈堝垪绌� 2 鏉★級鈥斺�斿懡涓殑姝ｆ槸褰撴棩涓や釜鐪熷疄闂銆� +- **淇**锛氶鐗堝彧姣旀瘝鐗� 鈫� 璇姤 2026-07 涓ゆ潯锛涘凡鎸夌敓鎴愰摼瀹炵幇琛ヤ笂 donor 姣斿锛屽娴� 0 鏉°�� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_姹囨�诲ぇ琛ㄧ己鏁版竻鍗昣2026-10-12.md`銆� +- **寰呭姙**锛氬鍑哄墠寮圭獥 + 鐢熸垚浠躲�婃暟鎹己澶辨竻鍗曘�嬮〉锛堜笌 B4 鐨� P0-3 鍚堝苟锛夈�� +- **鐘舵��**锛�**銆愬緟楠屾敹銆�**锛堝彧璇诲姛鑳斤紱鏈惤鐩樸�佹湭鏀逛笟鍔℃暟鎹級銆� +## 鏈�鏂帮紙2026-10-10锛寊yj 绾匡級 + +### 10-10锛歋tep 1 鎵╁垪鍣ㄨ惤鍦� + 8鈫�9 鏈堢増寮忛杞骇鍑恒�愬緟楠屾敹銆� + +- **鏂板鎵╁垪鍣�**锛歚traffic-audit-server/.../reportexport/layout/SummaryLayoutExpander.java`锛涙柊澧炲彧璇绘帴鍙� `GET /api/report/export/summaryWorkbook/expand?period=YYYY-MM`锛堣繑鍥炲瓧鑺傘��**涓嶈惤鐩�**锛夛紱`ReportExportService.expandSummaryWorkbook(period)` 璐熻矗鍙栧綋鏈熸瘝鐗堝苟璋冪敤銆傝鍒欎緷鎹� `docs/姹囨�诲ぇ琛ㄦ瘝鐗堟墿鍒楅厤缃甠鏍稿鐗坃2026-10-09.md`锛�8 涓彲瑙佸彴璐﹂〉锛�4 涓殣钘忛〉涓嶆墿鍒椾絾鍚屾骞崇Щ鍏惰法椤靛紩鐢級銆� +- **浜у嚭锛堝緟纭浠讹紝鏈惤鐩樹负姣嶇増锛�**锛歚docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/_鎵╁垪_2026骞�9鏈坃寰呯‘璁�.xlsx`锛�1,036,939 B锛�2026-10-10 09:30:07锛夈�傚彧鍋氱増寮忥紝9 鏈堟暟鎹垪鐣欑┖銆� +- **涓庢墜宸� 9 鏈堟瘝鐗堥�愭牸姣斿**锛�**` 璐ц繍` 宸紓 = 0**锛堣鍒欐纭殑鏈�寮鸿瘉鎹級锛涘叾浣� 7 椤靛叡 836 鏉″樊寮傦紝**鍏ㄩ儴闈炴暟鍊煎垎姝�**锛屽垎涓哄洓绫伙細 + 1. **548 鏉�**锛氫骇鍑烘妸銆岀疮璁�/绱鍚屾瘮鍒嗘瘝銆嶆墿鍒� 9 鏈堬紝鎵嬪伐鐗堟湭鎵┾�斺�旀鏄� 09-29銆婃墿鍒楄繘搴︺�嬭瀹氱殑寰呬慨椤� 鈶⑩懀锛�"绱鍒楀彧绠楀埌 8 鏈�""鍘诲勾鍩烘暟鍙埌 8 鏈�"锛夛紝鍗�**鎵嬪伐 9 鏈堟瘝鐗堣繖 7 椤靛皻鏈慨瀹�**锛� + 2. 153 鏉★細鍒嗘瘝鏂板椤瑰垎闅旂鍐欐硶锛坄SUM(a+b+鈥�,c)` vs `SUM(a+b+鈥�+c)`锛岀瓑浠峰悓鍊硷級锛� + 3. 130 鏉★細琛ㄥ悕寮曞彿鍐欐硶锛坄杞ㄩ亾銆佽疆娓�!C6` vs `'杞ㄩ亾銆佽疆娓�'!C6`锛孍xcel 瑙勮寖鍖栨墍鑷达紝鍚屽�硷級锛� + 4. 1 鏉★細娴偣灏惧樊銆� +- **8 鏈堝強浠ュ墠鍒�**锛氫粎 28 鏉″樊寮備笖鍏ㄩ儴灞炵 3 绫诲紩鍙峰啓娉曪紙闆嗕腑鍦� `鍩庡競瀹㈣繍`锛夛紝鏈姩鏁板��/鍒楀彿銆� +- **杩囩▼涓慨鎺夌殑涓や釜瀹炵幇缂洪櫡**锛堥噸瑕侊紝閬垮厤澶嶇幇锛夛細 + 1. POI 5.2.5 鐨勫悎骞跺尯 API 鏄� `addMergedRegion(CellRangeRangeAddress)`銆乣removeMergedRegion(int)`锛堟棤 CellRangeAddress 閲嶈浇锛夆�斺�旀寜涓嬫爣鎽橀櫎銆佹寜瀵硅薄娣诲姞锛� + 2. 寮曠敤姝ｅ垯鏈�鍒濆彧璁� ASCII 琛ㄥ悕锛�**婕忔帀姣嶇増閲� 5,574 澶�"鏈甫寮曞彿鐨勪腑鏂囪〃鍚�"寮曠敤**锛堝 `杞ㄩ亾銆佽疆娓�!C6`锛夆啋 宸叉妸琛ㄥ悕瀛楃绫绘墿鍒� CJK锛屼慨姝ｅ悗鍒楀彿涓庢墜宸ョ湡鍊间竴鑷淬�� + 3. 鍐欎欢鐢� **POI**锛堜笌鐢熸垚閾捐矾鍚屾簮锛夛紝涓嶇敤 openpyxl锛堟湰椤圭洰鍘嗗彶涓婃湁 openpyxl 鍐欏嚭瀵艰嚧 Excel 鎷掔粷鎵撳紑鐨勬渚嬶級銆� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_姹囨�诲ぇ琛ㄦ墿鍒楀櫒8鏈堝埌9鏈堢増寮廮2026-10-10.md`锛涙棩缁� `docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_2026-10-10.md`銆� +- **寰呯敤鎴烽獙鏀�/纭**锛氣憼 绱鍒椾笌绱鍚屾瘮鍒嗘瘝**鏄惁搴旀墿鍒� 9 鏈�**锛堜骇鍑�=宸叉墿锛涙寜 09-29 寰呬慨娓呭崟锛屾柟鍚戜笌褰撴椂璁ゅ畾涓�鑷达級锛涒憽 纭鍚庢槸鍚︽妸浜у嚭钀界洏涓烘寮� 9 鏈堟瘝鐗堬紙鎸夊凡纭鍙ｅ緞锛氫汉宸ョ‘璁ゅ悗钀界洏锛夈�� +- **鐘舵��**锛�**銆愬緟楠屾敹銆�**锛堢増寮忕被鏀瑰姩锛夈�傛湭瀵煎叆浠讳綍涓氬姟鏁版嵁銆佹湭鏀瑰姩鐢熸垚涓婚摼銆� +- **涓嬩竴姝�**锛氭寜纭缁撹寰皟锛堝闇�锛夆啋 澶嶈窇 8鈫�9 鈫� 鎺ュ叆涓婚摼锛坄resolveSummaryMother` 鎵句笉鍒扮洰鏍囨湀姣嶇増鏃惰嚜鍔ㄦ墿鍒楋級+ 褰掓。鐩綍涓庣増寮忓弬鐓т欢鎸� C4 鏀跺熬銆� ## 鏈�鏂帮紙2026-10-09锛寊yj 绾匡級 ### 10-09锛�2025 鏁版嵁鐜扮姸鏍搁獙锛堢粨璁猴細宸插湪搴擄紝鏃犻渶琛ュ綍锛�+ M0 瑙勬牸琛ョ鍗佷簩鑺� @@ -47,6 +157,8 @@ - **鏂囨。鏇存柊**锛歚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` 鏀瑰悆銆屾湀浠解啋鍒楀彿銆嶆槧灏勩��**鍙崲鍙栨暟鏂瑰紡锛屼笉鏀圭増寮忎笌鏁板�煎彛寰勩�佷笉鍋氭墿鍒�**銆� @@ -56,8 +168,17 @@ - **韪╁潙锛堝姟蹇呰浣忥級**锛氶娆″姣旂殑"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 绔嬮」 -- Gitblit v1.9.1