From 797f03be4fe1bd1f83072f5ca25909f4d2bd4b56 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 13:18:53 +0800 Subject: [PATCH] fix(城市客运): 公交/出租导入改按表头名定位列，兼容同事版少列模板 待验收 --- HANDOFF.md | 129 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 129 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index 7933da4..1f0b58d 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -4,6 +4,101 @@ > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� > **鍗忎綔绾﹀畾锛�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`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +## 鏈�鏂帮紙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 瑙勬牸琛ョ鍗佷簩鑺� @@ -35,6 +130,40 @@ - **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 绔嬮」 -- Gitblit v1.9.1