From 2761abd2f50ae9f3838d0746b9817a30cb9fc13a Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期日, 20 九月 2026 14:47:08 +0800 Subject: [PATCH] fix(汇总表): 城市客运8月/累计同比取数修正（母版删AJ辅助列+按表头定位月份列） --- docs/工作日结/工作日结_2026-09-20.md | 43 +++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 41 insertions(+), 2 deletions(-) diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-20.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-20.md" index 7e6963e..9d57ab3 100644 --- "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-20.md" +++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-20.md" @@ -21,6 +21,26 @@ - 閲嶅惎鍓嶅悗绔姞杞芥柊浠ｇ爜锛堝悗绔� `Started TrafficAuditApplication` 10:49:51锛夈�� - 椤烘墜鏍稿锛氬墠涓�鏅氥�屽悎璁¤琚綋椤圭洰銆嶄慨澶嶅悗锛屽杩愭湰鏈堝畬鎴愭姇璧勭敱鍚悎璁¤鐨� 2130.1 鏀舵暃涓� **2048.1**锛屼笌 SQL 閫愰」涓�鑷达紱搴撳唴宸叉棤鍚�岃銆嶇殑浼」鐩銆� +### 1.3 淇锛氭眹鎬诲ぇ琛ㄣ�婂煄甯傚杩愩��8 鏈堝悓姣� / 绱鍚屾瘮绠楅敊锛堟瘝鐗堝垹 AJ 杈呭姪鍒� + 绋嬪簭鎸夎〃澶村彇鏁帮級 + +- **鐜拌薄**锛氱敤鎴蜂笂鎶ョ敓鎴愯〃鍩庡競瀹㈣繍 8 鏈堝悓姣� 鈭�86.5%銆佺疮璁″悓姣� 鈭�43.5%锛涗笖銆�2025骞�1-7鏈堢疮璁°�嶅垪鍦ㄦ瘝鐗堝垹杩囧嵈浠嶅湪鐢熸垚琛ㄩ噷銆� +- **鏍瑰洜锛�3 涓級**锛� + 1. 姣嶇増鏈�**涓ゆ湰**鈥斺�旂敤鎴峰垹鐨勬槸銆�2026骞�7鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬶紝鑰� 8 鏈堝鍑虹敤鐨勬槸銆�2026骞�8鏈堚�︺�嬶紝 + 鍚庤�呭煄甯傚杩愰〉 2025 骞存鎻掍簡 AJ 鍒椼��2025骞�1-7鏈堢疮璁°�嶏紝鎶� 2025骞�8鏈堝垪鎸ゅ埌 AK锛� + 8 鏈堝悓姣� `=Q4/AJ4-1` 瀹為檯鏄��8鏈堝�� 梅 2025骞�1-7鏈堢疮璁°�嶏紱绱鍚屾瘮鍒嗘瘝鍙堟妸 1-6 鏈堥噸澶嶈銆�8 鏈堟紡璁°�� + 2. 鏂板啓鐨勫垪鍙锋崲绠� `colIndexOf()` 杩斿洖 1 鍩哄垪鍙凤紝鑰� POI 鍒楀彿鏄� 0 鍩� 鈫� 鏈堜唤鍒楁煡琛ㄥ叏钀界┖銆侀��鍖栨垚銆�+2 鍒椼�嶏紝 + `=O5/AH5-1` 琚畻鎴� `=R5/AK5-1`锛堣嚜寮曠敤锛夆啋 璐ц繍/缃戠害杞�/涓彛寰勬槑缁� 鍏� 360 鏍煎惊鐜紩鐢ㄣ�� + 3. POI `setCellFormula` 涓嶆帴鍙楀甫 `=` 鍓嶇紑鐨勫叕寮忎覆锛屽紓甯稿張琚� `catch (Exception ignore)` 鍚炴帀锛� + 绱鍚屾瘮鍒嗘瘝淇涓�鐩撮潤榛樺け璐ワ紙鏃ュ織鍙樉绀恒�屼慨姝ｆ牸鏁�=0銆嶏級锛涘彟姣嶇増 3~8 鏈堣〃澶存槸 46235 杩欑被瑁稿簭鍒� + General 鏍煎紡锛� + 鍘熸寜 `isCellDateFormatted` 鍒ゅ畾浼氭紡鍒ゃ�� +- **澶勭疆**锛� + 1. 姣嶇増锛氱敤 Excel 16.0 COM 鍦ㄣ��2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬪煄甯傚杩愰〉鏁村垪鍒犻櫎 AJ锛堝紩鐢ㄧ敱 Excel 鑷姩璋冩暣锛� + 濡� `W4` 鈫� `=V4/AW4-1`锛夛紝鍐嶆妸鍒犲垪浜х敓鐨� 36 澶� `#REF!` 绱鍚屾瘮鍏紡杩樺師涓� `AJ`锛� + 澶囦唤 `_bak_202608姣嶇増鍒犻櫎AJ鍒楀墠_20260920.xlsx`锛涘垹鍒楀悗姣嶇増涓庣増寮忓弬鐓т欢銆婄敓鎴恄閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx銆嬪垪缁撴瀯涓�鑷淬�� + 2. 浠ｇ爜锛歚colIndexOf` 鏀� 0 鍩猴紱`setCellFormula` 鍘绘帀 `=` 鍓嶇紑骞舵妸 catch 鏀规垚 WARN 鏃ュ織锛� + `yearMonthOf` 鏀寔瑁告棩鏈熷簭鍒楋紱`repairCumulativeYoyFormulas()` 淇濈暀浣滄瘝鐗堝厹搴曘�� + 3. 鍓嶇锛歚ReportExport.vue` 棰勮琛ラ綈璐ц繍閲�/鍩庡競瀹㈣繍/涓彛寰勫叡 8 椤瑰悓姣旀槧灏勶紝淇銆屽綋鏈堣揣鐗╁懆杞噺(涓囧惃)銆嶅崟浣嶃�� + ## 浜屻�佹祴璇曠粨鏋滄憳瑕� 銆婂姛鑳芥祴璇曟姤鍛奯鎶曡祫鏄庣粏琛ㄥ氨缁笌棰勮绫诲瀷琛ラ綈_2026-09-20.md銆嬶細**7 鏉＄敤渚嬮�氳繃锛�1 鏉℃湭瀹炴祴**锛堢己姣嶇増鎻愮ず锛屾湭涓存椂绉诲姩鐢ㄦ埛姣嶇増鏂囦欢锛夈�� @@ -35,16 +55,35 @@ | 鍘熸湁鎶曡祫绫诲瀷鍥炲綊 | investPlan / investBillion / investCounty / investFiveYearLogistics 鍧� ready=true锛宺ows=167 | | 鏈煡绫诲瀷璐熷悜 | `foo` 鈫� ready=false銆乶ote=鏈煡鎶ヨ〃绫诲瀷锛歠oo锛堝厹搴曚粛鏈夋晥锛� | +銆婂姛鑳芥祴璇曟姤鍛奯鍩庡競瀹㈣繍鏈堝害涓庣疮璁″悓姣擾2026-09-20.md銆嬶細**15 鏉＄敤渚嬮�氳繃**銆� + +| 鏍￠獙椤� | 缁撴灉 | +| --- | --- | +| 鍩庡競瀹㈣繍 R4 / T4 鍏紡 | `=Q4/AJ4-1`銆乣=S4/(V4+X4+Z4+AB4+AD4+AF4+AH4+AJ4)-1`锛堜笉鍐嶆槸 `#REF!`锛� | +| 鍏ㄧ渷瀹㈣繍閲� 8 鏈堝悓姣� / 绱鍚屾瘮 | **+4.44% / +0.117%**锛堜慨澶嶅墠 鈭�86.5% / 鈭�43.5%锛� | +| 杈呭姪鍒� | 鐢熸垚琛ㄤ笌姣嶇増鍧囨棤銆�2025骞�1-7鏈堢疮璁°�嶏紝鍩庡競瀹㈣繍椤� BV鈫払U | +| 寰幆寮曠敤 | 鍏ㄨ〃 0 澶勶紙淇鍓� 360 澶勶紝鍚揣杩�/缃戠害杞�/涓彛寰勬槑缁� R 鍒楋級 | +| 鍏跺畠 18 涓〉绛惧洖褰� | 闄や笂杩� R 鍒椾慨澶嶅閫愭牸涓�鑷� | +| 棰勮鎺ュ彛 | 24 椤规寚鏍囧惈 8 椤瑰悓姣旓紝1.03 绉� | +| 瀵煎嚭鑰楁椂 | 14 绉掞紙姣嶇増璇诲彇+鍥炲～ 6.5s銆佸叕寮忛噸绠� 4.1s銆佸啓鐩樹紶杈� 3.4s锛� | + ## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙 1. 姝︽眽鐗╂祦椤圭洰娓呭崟鍙ｅ緞锛堝凡纭蹇界暐锛夈�� 2. 澶╅棬鐗╂祦婧愭枃浠� H/J/K 涓虹┖ 鈫� 寰呯敤鎴锋壘鍚屼簨瑕佹暟鎹悗瀵煎叆銆� 3. 鑽嗗窞/榛勭煶銆岃鍒掑唴/瑙勫垝澶栥�嶆媶鍒嗗彛寰� 鈫� 寰呯敤鎴峰悜鍚屼簨纭銆� -4. C 缁勶紙鍩庡競瀹㈣繍椤电粨鏋勫綊涓�锛岄渶鐢ㄦ埛鍏堝湪 WPS 鏁村垪鍒犻櫎 AJ 鍒楋級锛廌 缁勶紙澧為�熸帓鍚嶆帾杈烇級锛廈4锛堝鍑哄墠鍩烘暟浣撴 + 寮圭獥 + 銆婃暟鎹己澶辨竻鍗曘�嬮〉锛夊緟鎺掓湡銆� +4. ~~C 缁勶紙鍩庡競瀹㈣繍椤电粨鏋勫綊涓�锛岄渶鐢ㄦ埛鍏堝湪 WPS 鏁村垪鍒犻櫎 AJ 鍒楋級~~ **宸插畬鎴�**锛堟敼鐢� Excel COM 鏁村垪鍒犻櫎 + 鍏紡杩樺師锛夛紱 + D 缁勶紙澧為�熸帓鍚嶆帾杈烇級锛廈4锛堝鍑哄墠鍩烘暟浣撴 + 寮圭獥 + 銆婃暟鎹己澶辨竻鍗曘�嬮〉锛夊緟鎺掓湡銆� 5. 缂烘瘝鐗堟彁绀猴紙T08锛夋湭瀹炴祴锛屽彲鍦ㄦ湁娴嬭瘯鍓湰鏃惰ˉ娴嬨�� +6. 姹囨�诲ぇ琛ㄥ鍑烘槸**鍚屾璇锋眰**锛屽綋鍓嶇害 14 绉掞紙姣忔閮借閲嶇畻鏁存湰绾� 4 涓囨牸鍏紡锛夛細鏁版嵁閲忓啀娑ㄤ富瑕佹槸 SQL 鑱氬悎鍙樻參锛� + 涓嶄細銆屽崱姝汇�嶏紝浣嗗缓璁悗缁仛鎴愬紓姝ヤ换鍔� + 杩涘害鎻愮ず銆� +7. 閮ㄧ讲鍖� `deploy/traffic-audit-deploy-20260913/backend/docs/鐢熸垚姹囨�诲ぇ琛�/` 涓� `_deploytest/` 涓嬩粛鏄�**甯� AJ 鍒楃殑鏃ф瘝鐗�**锛� + 涓嬫鎵撳寘鏃堕渶鍚屾锛堟湭缁忕敤鎴风‘璁や笉鎿呰嚜鏀归儴缃蹭骇鐗╋級銆� +8. 涓彛寰勬槑缁� 4 鏍硷紙鍩庨檯鍩庝埂宸℃父鍑虹/缃戠害杞︼級鍥� 2025骞�8鏈堝熀鏁颁负 0锛屽悓姣旀樉绀� `#DIV/0!`锛堜笉鍙瘮锛夛紝濡傞渶鏀圭┖鐧介渶鐢ㄦ埛纭鍙ｅ緞銆� ## 鍥涖�佹槑鏃ヨ鍒� 1. 绛夊ぉ闂ㄦ簮鏁版嵁 / 鑽嗗窞榛勭煶鍙ｅ緞纭鍚庤ˉ瀵煎苟澶嶉獙銆� 2. 鎺ㄨ繘 C/D 缁勪笌 B4銆� -3. 涓庣敤鎴风‘璁ゆ槸鍚︽妸 09-18 澶滈棿璧风殑鏈湴鎻愪氦涓�骞舵帹閫佸埌鍏徃 gitea锛堢敤鎴� 09-19 鏇捐姹傘�屼粖澶╁厛涓嶆帹鍏徃銆嶏級銆� \ No newline at end of file +3. 涓庣敤鎴风‘璁ゆ槸鍚︽妸 09-18 澶滈棿璧风殑鏈湴鎻愪氦涓�骞舵帹閫佸埌鍏徃 gitea锛堢敤鎴� 09-19 鏇捐姹傘�屼粖澶╁厛涓嶆帹鍏徃銆嶏級銆� +4. 璇勪及姹囨�诲ぇ琛ㄥ鍑哄紓姝ュ寲锛堥暱浠诲姟杩涘害鏉� / 缁撴灉缂撳瓨锛夛紝骞剁‘璁ら儴缃插寘姣嶇増鍚屾鏂瑰紡銆� -- Gitblit v1.9.1