From fc00eb79fce982425f9a83d63894a51549ed758a Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 17:11:58 +0800 Subject: [PATCH] fix(汇总大表): 扩列表头行改按基准月份列判定并清理9月母版被写入日期的13格（待验收） --- HANDOFF.md | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index f4a0d2d..4149825 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -4,6 +4,14 @@ > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆� +### 10-12锛�11锛夛細鎵╁垪琛ㄥご琛屼簩娆′慨姝� + 9 鏈堟瘝鐗堣鎵╁垪鍐欐垚鏃ユ湡鐨� 13 鏍兼竻鐞嗐�愬緟楠屾敹銆� + +- **鐜拌薄锛堢敤鎴锋姤鍛婏級**锛氱敓鎴愯〃閲�"寰堝鏁版嵁鏄� 8 鏈堢殑"銆傛帓鏌ュ彂鐜� **9 鏈堟瘝鐗堥噷鏈� 13 涓暟鎹牸琚啓鎴愪簡 9 鏈堟湀浠芥棩鏈熷簭鍒� `46266`锛�= 2026-09-01锛�**锛歚 璐ц繍!S11/T11`銆乣鐝嚎鍖呰溅!S9/T9`銆乣鍏氦!S8/T8`銆乣鍑虹!S6/T6`銆乣涓彛寰勬槑缁�!S5/T5`锛涗笅娓哥紦瀛樿甯﹀亸锛坄鐝嚎鍖呰溅!S5`銆乣涓彛寰勬槑缁�!S99/S100/S104/S105` 绛変篃鏄� 46266锛夈�� +- **鏍瑰洜**锛氭墿鍒楀櫒 `headerRowsOf` 棣栫増鍙姹�"鏁磋 鈮�2 涓湀浠芥牸"锛岃�屽嚭绉熺 6 琛屻�佺彮绾垮寘杞︾ 3 琛岃繖绫�**鏁版嵁琛�**閲屾伆濂芥湁 2 涓儚鏃ユ湡搴忓垪鐨勬暟鍊� 鈫� 琚鍒ゆ垚琛ㄥご琛� 鈫� 鎵╁垪鏃舵妸"鏈堜唤鏃ユ湡"鍐欒繘浜嗘暟鎹锛坄cloneHeaderCell` 瀵规暟鍊兼牸鍐� `targetMonth` 鐨勬棩鏈燂級銆� +- **淇硶**锛氭敼涓�**鍏堝彇"鏈堜唤琛ㄥご鏍兼渶澶氱殑閭ｄ竴琛�"浣滃熀鍑嗭紝鎶婂畠鐨勬湀浠藉垪褰撴爣鍑嗗垪**锛涘彧鏈夎繖浜涘垪涓婂ぇ鍗婃槸鏈堜唤鏍肩殑琛屾墠绠楄〃澶磋銆傝建閬撱�佽疆娓′竴椤典袱涓潡鐨� `[1,10]` 淇濇寔 鉁擄紱` 璐ц繍/鍏氦/缃戠害杞�/涓彛寰勬槑缁哷 浠嶄负鍗曡琛ㄥご 鉁撱�� +- **姣嶇増淇锛堢敤 Excel COM锛屾湭鏁存湰閲嶅啓锛�**锛�13 鏍兼寜鎵╁垪瑙勫垯绮句慨锛堣鐣欑┖鐨勬竻绌恒�佸叕寮忔寜瑙勫垯琛ュ洖 `=S12+S13` / `=S11/AN11-1` / `=S10+S14+鈥锛�+ `CalculateFull` 鏁存湰閲嶇畻鍒锋柊缂撳瓨锛涗慨澶嶅墠澶囦唤 `_bak_2026骞�9鏈堟瘝鐗坃娓呯悊鑴忔牸鍓峗20261012.xlsx`銆備慨澶嶅悗鍏ㄧ翱鍙墿 3 涓� `46266` 鐨�**鍚堟硶琛ㄥご鏈堜唤鏍�**锛堝煄甯傚杩� S2銆佸叕浜� S3銆佸嚭绉� S3锛夈�� +- **楠岃瘉**锛氶噸璺� 2026-08鈫�9 鏈堟墿鍒楋紙鏃ュ織琛ㄥご琛� ` 璐ц繍[2] 鐝嚎鍖呰溅[1] 鍩庡競瀹㈣繍[1] 鍏氦[2] 鍑虹[2] 缃戠害杞2] 杞ㄩ亾銆佽疆娓1,10] 涓彛寰勬槑缁哰2]`锛夛紝鏂版帹浠跺湪杩� 13 鏍间笂鍏ㄩ儴姝ｇ‘锛涢噸璺� 2026-09 鐢熸垚锛屼骇鐗� `docs\鐢熸垚姹囨�诲ぇ琛╘杈撳嚭\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-09.xlsx` 涓� 13 鏍兼仮澶嶄负鐪熷疄 9 鏈堝�硷紙`鐝嚎鍖呰溅!S9=20647.5363`銆乣鍏氦!S8=61618.09`銆乣鍑虹!S6=32787.72`锛夛紝**鏃� 46266 娈嬬暀**銆� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎵╁垪琛ㄥご琛屽熀鍑嗗垪淇涓庢瘝鐗堣剰鏍兼竻鐞哶2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� ### 10-12锛�3锛夛細淇��9 鏈堜骇鐗╀涪 8 鏈堝垪 / 绱婕忔湀銆嶁�斺�旀墿鍒楁敼涓�**浠ュ綋鏈熶骇鐗╀负搴�**銆愬緟楠屾敹銆� - **鐜拌薄锛堢敤鎴锋姤鍛婏級**锛氱敓鎴愮殑 9 鏈堟眹鎬诲ぇ琛ㄩ噷 **8 鏈堝垪鍏ㄧ┖**锛岀疮璁℃紡鎺� 8 鏈堬紙瑙勪笂璐ц繍閲忕疮璁℃樉绀� 31309.58锛屾纭簲涓� 1-7鏈� 27734.46 + 8鏈� 3665.36 + 9鏈� 3575.12 = **34974.95**锛夈�� @@ -71,6 +79,13 @@ - **楠岃瘉**锛氭墿鍒� 2026-08 鈫� 鍏紡鏍� **39,961** 涓紝**绌虹紦瀛樹粎 4 鏍�**锛堝叏鍦� ` 璐ц繍`锛孭OI 鏃犳硶姹傝В鐨勫閮ㄥ紩鐢紝Excel 鎵撳紑浼氱畻锛夛紱淇鍓嶅悓绫绘瘝鐗堢害 2.47 涓囨牸鏃犵紦瀛樸�� - **鐢ㄦ埛鍐冲畾**锛歚涓彛寰勬帓鍚峘 閭� 46 鏍�**淇濈暀鏂板��**锛堜笌涓彛寰勫垎鏋愪竴鑷达紝鍙ｅ緞缁熶竴锛夈�� - **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎵╁垪鏁存湰閲嶇畻鍐欑紦瀛榑2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�10锛夛細9 鏈堝鍏ユ牳楠� + 鍑鸿〃鎶芥煡閫氳繃锛�9 鏈堜粛缂烘暟鎹竻鍗曘�愬緟楠屾敹銆� + +- **9 鏈堝鍏ユ牳楠岋紙鍙鏌ュ簱锛�**锛氬煄甯傚叕浜� **141 琛�**銆佸贰娓稿嚭绉� **17 琛�**銆佸叕璺梾瀹� H2031 **767 琛�**銆佽揣杩愪紒涓� H2032 **636 琛�** 鈫� 鍏ㄩ儴鎴愬姛锛�**鍏氦/鍑虹鐨�"鎸夎〃澶村悕瀹氫綅"鏀瑰姩瀹炴祴鏈夋晥** 鉁擄紝`import_batch` 551/552 鍙锛夈�備粛缂� 9 鏈堬細**鈶°�婅揣杩愰噺鍛ㄨ浆閲忚〃銆嬶紙鍏ㄥ彛寰勶級0 琛屻�佲憿瑙勪笂瑙勪笅鎷嗗垎琛� 0 琛屻�佺綉绾﹁溅璁㈠崟/鍏ㄧ渷 pin 0/0銆佷釜浣撳杩� 0 琛�**锛堢敤鎴� 2026-10-12 璇存槑锛氬叾浠栨暟鎹殏鏃惰繕娌℃湁锛夈�� +- **鍑鸿〃鎶芥煡锛堜骇鐗╄惤 `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-09.xlsx`锛�**锛氬叕浜� 9 鏈堝杩愰噺 **13476.35**銆佸煄甯傚唴 **12021.00**銆佸嚭绉熷杩愰噺 **5626.81**銆佸煄甯傚唴 **5139.61** 鈥斺�� 涓庡簱鍐� 危17 甯傚窞**閫愪綅涓�鑷�** 鉁擄紱绱宸插惈 9 鏈堬紙鍏氦绱 **124252.69** = 1-8鏈� 110776.34 + 9鏈� 13476.35锛夆湏銆傚洜鈶℃湭瀵硷紝9 鏈堛�� 璐ц繍銆嬮〉"鍏ㄥ彛寰�"鏆傜瓑浜庤涓婏紙3575.1211锛夈��"瑙勪笅"涓� 0 鈥斺�� 灞炵己鏁帮紝闈炵畻閿欍�� +- **灏忓緟鍔�**锛氬叕浜� 9 鏈� **141 琛�** vs 1-8 鏈堝悇鏈� **142 琛�**锛堝皯 1 琛岋級锛屽緟鏍告槸婧愭枃浠跺皯琛岃繕鏄鍏ヨ烦杩囷紙鍙兘鏄┖琛�/姹囨�昏锛夆�斺�旂敤鎴疯鍏堣繖鏍凤紝鐣欏緟浠ュ悗銆� +- **鏈満闄愬埗**锛氬姪鎵嬫矙绠变笉鑳藉啓 `D:\涓嬭浇`锛岀敓鎴愪欢鍙兘钀藉湪浠撳簱鍐咃紙`docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/`锛夛紱姝ｅ紡涓嬭浇璇峰湪椤甸潰鐐圭敓鎴�/涓嬭浇銆� +- **鐘舵��**锛�**銆愬緟楠屾敹銆�**銆� ## 鏈�鏂帮紙2026-10-12锛寊yj 绾匡級 ### 10-12锛氭墿鍒楀櫒琛ャ�屾爣棰樻寜姣嶇増鏈熸閲嶅啓銆�+ 淇 8 鏈堟瘝鐗堟爣棰樸�愬緟楠屾敹銆� -- Gitblit v1.9.1