From ae47753f77690615762a77bde38a34e9ff0fa4ae Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 17:12:24 +0800 Subject: [PATCH] feat(汇总大表): 缺数清单可见且缺数期不沿用上一期旧值（排名页按源侧留空）（待验收） --- HANDOFF.md | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index f4a0d2d..5b161de 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -4,6 +4,28 @@ > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄�� > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆� +### 10-12锛�12锛夛細姹囨�诲ぇ琛ㄣ�岀己鏁颁笉鐣欎笂涓�鏈熸棫鍊笺�嶏紙鎺掑悕椤垫寜婧愪晶鐣欑┖锛�+ 缂烘暟娓呭崟浠ｇ爜鍏ュ簱銆愬緟楠屾敹銆� + +- **鑳屾櫙**锛氱敤鎴烽棶"鐢熸垚琛ㄩ噷寰堝鏁版嵁閮芥槸 8 鏈堢殑鍚�"锛涘悓鏃跺簱閲岀殑缂烘暟娓呭崟浠ｇ爜涓�鐩存湭鎻愪氦锛堟湰鏈烘矙绠辨晠闅滄湡闂村啓鐨勶紝娌欑鎭㈠鍚庤ˉ鎻愪氦锛夈�� +- **鍙ｅ緞鏀瑰姩锛�3 澶勶紝鍚屼竴浠朵簨锛氱己鏁颁笉鐣欎笂涓�鏈熸棫鍊硷級**锛� + 1. `loadCumulativeMap` / `getProvinceCumulative`锛氣憿瑙勪笂瑙勪笅鎷嗗垎琛�**鍙鐩爣鏈�**锛堝師瀹炵幇鍏佽"鐩爣鏈熷強涔嬪墠鏈�杩戜竴鏈�"鈫� 浼氶潤榛樻嬁涓婁竴鏈熺殑鏁板綋鏈湡锛夛紱 + 2. `copyRankValues`锛氭簮渚э紙鐙珛鎺掑悕琛級缂烘暟鏃�**鐩爣鏍肩暀绌�**锛屼笉鍐嶆部鐢ㄦ瘝鐗堜笂涓�鎶ヨ〃鏈熺殑鏃у�硷紙婧愪晶鏂囧瓧鏍囩涓嶆竻锛夛紱 + 3. 鎺掑悕鍧�**鏁村潡缂烘暟**锛堟簮渚т竴涓暟閮芥病鏈夛紝濡� 9 鏈堢己鈶♀憿鏃剁殑銆婅揣杩愬懆杞噺鎺掑悕銆嬶級鈫� 鏁村潡鍙暀鏍囬涓庡競宸炲悕锛岄伩鍏嶆瘝鐗堣嚜甯� RANK/鍗犳瘮鍏紡鍦ㄧ┖鍧椾笂绠楀嚭"鎺掑悕鍏� 1 + 鍗犳瘮 #DIV/0!"銆� +- **鏁堟灉锛�2026-09 瀹炴祴锛屼骇鐗� `docs\鐢熸垚姹囨�诲ぇ琛╘杈撳嚭\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-09.xlsx`锛�**锛� + - 銆婅揣杩愬懆杞噺鎺掑悕銆嬫暣鍧楃暀绌� 鈥斺�� 涓庣敤鎴锋棩甯告牳瀵圭殑銆婄敓鎴恄鍛ㄨ浆閲忔帓鍚嶃�嬬┖鎬佷竴鑷� 鉁擄紱 + - 銆婅揣杩愰噺鎺掑悕銆�9 鏈堝潡锛氳涓�=鈶犲疄鏁帮紙鍏ㄧ渷 **3575.1211**锛夈�佽涓�/鍚堣鐣欑┖锛堢己鈶★級锛涘崰姣斿垪娌跨敤婧愪晶鍏紡锛堝叾涓� 72 涓� #DIV/0! 鏄嫭绔嬫帓鍚嶈〃鏈韩灏辨湁鐨勶級锛� + - 鏃犲洖褰掞細鍏氦 9 鏈堝杩愰噺 **13476.35**銆佸煄甯傚唴 12021.00銆佸嚭绉熷杩愰噺 5626.81 涓庡簱鍐� 危17 甯傚窞閫愪綅涓�鑷� 鉁擄紙鍏朵綑椤典笌涓婁竴鐗堜骇鐗╁樊寮備粎鏉ヨ嚜姣嶇増鑴忔牸娓呯悊涓庣紦瀛樺埛鏂帮級銆� +- **鍚屾椂琛ユ彁浜�**锛堟矙绠辨晠闅滄湡闂撮仐鐣欙紝宸叉寜 10-12锛�4锛夋姤鍛婇獙璇佽繃锛夛細`reportexport/calc/SummaryMissingDataCheck.java`锛堝彧璇荤己鏁版竻鍗曪級銆乣GET /api/report/summaryWorkbook/missing`銆佸鍑烘棩蹇� `dbProblems` 鎺ュ叆锛堟湰娆″鍑烘棩蹇楀凡鍙"缂烘暟鎻愮ず=[鈥"锛夈�� +- **閬楃暀/寰呯‘璁�**锛氣憼 鍩庡競鍒嗗競宸炪�侀亾璺繍杈撳懆杞噺鐨� 34 涓� #DIV/0! 鎸� 10-12锛�7锛夌敤鎴峰喅瀹氫笉鍔紱鈶� **鎺掑悕椤靛湪缂烘暟鏈熸暣浣撶暀绌烘槸鍚︾鍚堥鏈燂紝璇烽獙鏀舵椂纭**锛堣嫢瑕�"淇濈暀涓婁竴鏈熷��"鐨勫彛寰勶紝鍙洖閫�绗� 2/3 鏉★級銆� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_姹囨�诲ぇ琛ㄧ己鏁颁笉鐣欎笂涓�鏈熸棫鍊糭2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 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 +93,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