From 6d1ac6150e4bc5e5c15faeed9889df21c04f6051 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期五, 09 十月 2026 10:11:02 +0800 Subject: [PATCH] fix(汇总大表): 四页取数月份列由写死 C/V 改为按表头动态定位（Step 0，待验收） --- HANDOFF.md | 23 +++++++++++++++++++++++ 1 files changed, 23 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index 7933da4..5bbc9d5 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -35,6 +35,29 @@ - **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` 绗崄鍥涜妭宸插畾椤规浛鎹�"鏈喅椤�"锛涜鏍艰〃涓庨厤缃垵绋垮悇杩藉姞鍙ｅ緞琛ュ厖銆� +- **鐘舵��**锛氥�愬緟楠屾敹銆戯紱鏈敼鍔ㄤ唬鐮併�佹湭瀵煎叆鏁版嵁銆� + +### 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`銆� +- **鐘舵��**锛�**銆愬緟楠屾敹銆�**锛堝彇鏁版柟寮忓睘鍙ｅ緞鐩稿叧鏀瑰姩锛夈�傛湭瀵煎叆浠讳綍涓氬姟鏁版嵁銆� +- **涓嬩竴姝�**锛歋tep 1 鎵╁垪鍣ㄦ湰浣擄紙閰嶇疆椹卞姩锛�8 涓彲瑙佸彴璐﹂〉锛浡�5.2 涓夋潯蹇呮敼鐐癸紱浜х墿鍏堣惤 `杈撳嚭/` 寰呬汉宸ョ‘璁ゅ悗鍐嶈惤鐩樹负涓嬫湡姣嶇増锛夈�� ## 鏈�鏂帮紙2026-10-06锛寊yj 绾匡級 ### 10-06锛氭媺鍙栧悎骞� + 楠屾敹闂ㄧ鍒嗙骇 + 姹囨�诲ぇ琛� M0 绔嬮」 -- Gitblit v1.9.1