From 8719902780eadfc55d4d159d5a111b433f065137 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期五, 18 九月 2026 11:34:33 +0800 Subject: [PATCH] 功能(中口径): 四维口径统一 + 修独立中口径明细扩列月份总行为空 --- docs/工作日结/工作日结_2026-09-18.md | 55 +++++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 47 insertions(+), 8 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-18.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-18.md" index c0ce255..eb065a0 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-18.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-18.md" @@ -21,6 +21,23 @@ - 鍐欎簡銆婃眹鎬昏〃涓夋潯涓荤嚎淇鏂规_2026-09-18銆嬶紙`docs/闂姹囨��/`锛夛紝鎶婃牴鍥犮�佽瘉鎹��4 姝ヤ慨娉曘�佹姇璧�"鎸夐」鐩悕绉版洿鏂�/鏂板鎻掕"鐜扮姸涓�骞惰褰曘�� - 鎶曡祫渚ф牳瀹烇細瀵煎叆纭疄鎸夈�岄」鐩悕绉� + 绫诲埆銆島psert锛堝簱鍐� 瀹㈣繍绔欏満 49/49銆佺墿娴佸洯鍖� 135/135 鏃犻噸澶嶈锛夛紱缂哄彛鏄�"妯℃澘閲屾病鏈夌殑鏂伴」鐩笉浼氭彃琛�"銆�"璧勯噾娓犻亾鍒嗙粍琛屽鍏ユ椂琚烦杩�"銆�"鍚屽悕涓嶅悓椤圭洰涓嶅脊绐�"銆� +### 3. 绗� 3 姝ワ細涓彛寰勫洓缁村彛寰勭粺涓�锛堜笅鍗堬級 + +**鍙ｅ緞瀹氭**锛堝啓杩涖�婂姛鑳芥祴璇曟姤鍛奯涓彛寰勫洓缁村彛寰勭粺涓�_2026-09-18銆嬶級锛�1 鍏矾鐝嚎锛坔2031+涓綋锛�= 2 鍩庨檯鍩庝埂鍏氦锛坈ity_bus锛�= 3 鍩庨檯鍩庝埂宸℃父鍑虹锛坈ity_taxi锛氭�婚噺鈭掑煄甯傚唴锛�= 4 鍩庨檯鍩庝埂缃戠害杞︼紙WycSplitCalc 鎷嗗垎锛夛紱鎬婚噺 = 鍥涚淮涔嬪拰锛�**鍏ㄧ渷琛屼竴寰� 危17 甯傚窞**銆� + +**鏀瑰姩**锛坄ReportExportService.java`锛夛細 +- `loadMidClassMap()` 琛ョ淮搴� 3銆佺淮搴� 4锛堟柊澧� `midPeriodKey()`锛夛紱 +- `fillMidCell()` 鍘绘帀銆屽嚭绉�/缃戠害杞﹀啓姝� 0銆嶆梺璺紱`fillMidYoyCell()`/`fillMidCumYoyColumn()` 鍚屾瘮鏀瑰洓缁撮綈鍏紱 +- `exportPassengerMidDetail()` 鐢便�屽彧閬嶅巻鍏紡鏍笺�嶆敼涓恒�屾寜鍒楅亶鍘嗐�嶏紙鎵╁垪鍑虹殑 7~12 鏈堢┖鏍兼墠濉緱涓婏級锛� +- 鎵╁垪鏈堜唤鐨勬�昏鍊煎垪鏀圭敱搴撳唴鍥涚淮鍚堣鐩存帴鍐欏叆锛堟ā鏉挎湰鏃犳鍒楋紝鍏嬮殕鍚庢棦鏃犲叕寮忎篃鏃犵紦瀛樺�硷級锛� +- 璇ュ嚱鏁伴噸绠楁敼鐢ㄩ�愭牸瀹归敊鐨� `recalcWorkbookFormulas()`鈥斺�擿evaluateAll()` 浼氬湪璺ㄧ翱鍏紡锛圫heet2 鐨� `[1]xx!A1`锛夊鏁存湰涓柇锛岀疮璁″垪灏辨案杩滄嬁涓嶅埌鏂扮紦瀛樺�笺�� + +**楠岃瘉**锛氱嫭绔嬨�婄敓鎴恄涓彛寰勬槑缁嗐��8 鏈堝叏鐪佹�昏 4003.5701銆�7 鏈� 4028.3213锛堝師涓虹┖锛夛紝18 涓湴鍖烘�昏 = 危4 缁淬�佺疮璁″垪 = 危1-8 鏈堬紱涓庢眹鎬诲ぇ琛ㄣ�屼腑鍙ｅ緞鏄庣粏銆嶉〉閫愭牸涓�鑷达紱鍥炲綊 = 姹囨�昏〃 17 椤� 0 宸紓銆佹帓鍚嶄欢 0 宸紓銆佹槑缁嗕欢浠� 36 鏍硷紙18 鍦板尯 脳 2 涓湀鎬昏锛夊彉鍖栥�� + +**椤哄甫鏌ユ竻涓や釜鑰侀棶棰�**锛� +- 銆婄敓鎴恄涓彛寰勬帓鍚嶃�嬪叏鐪佺疮璁� 29464.6108 / 鍚屾瘮 0.638锛屾瘮涓彛寰勬槑缁嗗皯 2063.45锛屽樊鍊兼濂芥槸 2026 骞� 1-6 鏈堢淮搴� 4锛堢綉绾﹁溅锛夆啋 鎺掑悕浠舵槸 Java 鐜扮畻銆佹槑缁嗛〉璧版瘝鐗堝叕寮忛摼锛屼袱濂楀彛寰勬墦鏋讹紙绗� 3 姝ョ殑鐪熸鏀跺彛鐐癸級銆� +- 姣嶇増銆屼腑鍙ｅ緞鏄庣粏銆嶅煄甯傜骇銆屽煄闄呭煄涔″贰娓稿嚭绉�/缃戠害杞︺�嶈鍏紡寮曢敊椤碉紙`=鍏氦!C13-鍏氦!C15`锛屽簲鎸囧悜 `鍑虹!`/`缃戠害杞�!`锛夛紝鍩庡競绾ф亽 0銆佸叏鐪佽闈犵紦瀛樺�� 鈫� 闇�淇瘝鐗堝叕寮忎竴娆°�� + ## 浜屻�佹祴璇曠粨鏋滄憳瑕� 瑙� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_姹囨�昏〃鍏紡鎵╅〉涓庨噸绠梍2026-09-18.md`锛�8 鏉℃鍚� + 4 鏉¤礋鍚�/杈圭晫 + 4 椤瑰叆搴撴娊鏌ワ紝鍏ㄩ儴閫氳繃銆� @@ -30,16 +47,38 @@ - 涓彛寰勬帓鍚� K3 缂撳瓨 24481.7407 = 鎵嬪伐 危17 甯傚窞銆� - 鍥炲綊锛氭敼鍔ㄥ墠鍚庨�愭牸瀵规瘮锛屼粎 216 鏍煎彉鍖栵紝鍏ㄩ儴钀藉湪鐩爣涓ら〉锛屽叾浣� 17 椤� 0 宸紓銆� +### 绗� 3 姝ワ紙涓嬪崍锛夋祴璇曠粨鏋� + +瑙� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_涓彛寰勫洓缁村彛寰勭粺涓�_2026-09-18.md`锛�6 鏉℃鍚� + 3 鏉″洖褰� + 3 鏉¤礋鍚戣竟鐣岋紝鍏ㄩ儴閫氳繃銆� + +- 鐙珛銆婄敓鎴恄涓彛寰勬槑缁嗐�嬪叏鐪� 8 鏈堟�诲杩愰噺 4003.5701 = 鐝嚎 1646.4801 + 鍏氦 1436.63 + 鍑虹鍩庝埂 493.90 + 缃戠害杞﹀煄涔� 426.56锛� +- 18 涓湴鍖� 脳锛�7銆�8 鏈堬級鎬昏 = 危 璇ュ潡 4 缁磋锛涚疮璁″垪缂撳瓨鍊� = 危1-8 鏈堬紙鍏ㄧ渷 31528.0607锛夛紱 +- 鍥炲綊锛氭眹鎬诲ぇ琛� 17 椤� 0 鏍煎彉鍖栥�併�婄敓鎴恄涓彛寰勬帓鍚嶃��0 鏍煎彉鍖栥�併�婄敓鎴恄涓彛寰勬槑缁嗐�嬩粎 36 鏍煎彉鍖栵紙鍏ㄩ儴鏄洰鏍囨牸锛夈�� + ## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙 -1. **涓彛寰勬帓鍚嶅悓姣斾粛鏄啓姝诲��**锛圡3=0.7424 / Q3=0.2317锛屽簱鍐呭叏鐪佸彛寰勶級锛岄渶涓� 危17 甯傚窞鍙ｅ緞缁熶竴 鈥斺�� 绗� 3 姝ャ�� -2. **`loadMidClassMap()` 缂哄贰娓稿嚭绉� + 缃戠害杞︿袱缁�**锛屽鑷寸嫭绔嬨�婄敓鎴恄鍏矾鏃呭涓彛寰勬槑缁嗐�嬪皯 535.83+333.39锛�1 鏈堬級鈥斺�� 绗� 3 姝ャ�� -3. **搴撳唴 h2031銆屽叏鐪併�嶈 鈮� 危17 甯傚窞**锛�1-8 鏈� 27524.49 vs 24481.74锛屽樊 3042.75锛夛細涓氬姟鍙ｅ緞闂锛屽缓璁笟鍔′晶鏍稿銆� -4. 鎶曡祫锛氭ā鏉块噷娌℃湁鐨勬柊椤圭洰涓嶄細鑷姩鎻掕锛涙槑缁嗚〃璧勯噾娓犻亾鍒嗙粍琛屾湭鍏ュ簱锛堥渶鍔� `fund_channel`锛夛紱鍚屽悕涓嶅悓椤圭洰鏈脊绐椼�� -5. 鎶曡祫涓ゅ紶鏄庣粏琛紙`X鏈堝杩愮珯鎶曡祫鏄庣粏琛╜ / `X鏈堢墿娴佺珯鍦烘姇璧勬槑缁哷锛夌敓鎴愬櫒鏈仛銆� +1. ~~涓彛寰勬帓鍚嶅悓姣斾粛鏄啓姝诲�紐~ 鈫� **宸叉寜鏂板彛寰勫彇鍊�**锛圡3=0.638 / Q3=0.2247锛夛紝浣嗕粛涓庝腑鍙ｅ緞鏄庣粏鐨� 0.0581 涓嶈嚜娲斤紝宸�� 2063.45 = 缃戠害杞� 1-6 鏈堟棤婧愶紱**鏀跺彛鍔炴硶瑙佷笅鏂�"绗� 3 姝ユ敹鍙ｅ缓璁�"**銆� +2. ~~`loadMidClassMap()` 缂哄贰娓稿嚭绉� + 缃戠害杞︿袱缁磣~ 鈫� **宸茶ˉ**锛堢淮搴� 3銆�4锛夛紝鐙珛涓彛寰勬槑缁嗗洓缁撮綈鍏ㄣ�� +3. **姣嶇増缂洪櫡寰呬慨**锛氫腑鍙ｅ緞鏄庣粏鍩庡競绾с�屽煄闄呭煄涔″贰娓稿嚭绉�/缃戠害杞︺�嶈鍏紡寮曢敊椤碉紙鎸囧悜 `鍏氦!`锛夛紝鍩庡競绾ф亽 0銆佸叏鐪佽闈犵紦瀛樺�笺�� +4. **鏁版嵁缂哄彛**锛�2026-01~06 缃戠害杞﹁鍗曟湭鍏ュ簱锛坄order_*` 鍏� NULL锛夛紝妯℃澘銆婄綉绾﹁溅璁㈠崟鍙婂叏鐪佹�婚噺.xlsx銆嬪彧鏈� 2026-07 涓�琛� 鈫� 缁村害 4 璇� 6 涓湀鏃犳簮锛涢渶涓氬姟琛ユ暟鎴栫‘璁や笉閫傜敤銆� +5. 搴撳唴 h2031銆屽叏鐪併�嶈 鈮� 危17 甯傚窞锛�1-8 鏈� 27524.49 vs 24481.74锛屽樊 3042.75锛夛細涓氬姟鍙ｅ緞闂锛屽缓璁笟鍔′晶鏍稿銆� +6. 鎶曡祫锛氭ā鏉块噷娌℃湁鐨勬柊椤圭洰涓嶄細鑷姩鎻掕锛涙槑缁嗚〃璧勯噾娓犻亾鍒嗙粍琛屾湭鍏ュ簱锛堥渶鍔� `fund_channel`锛夛紱鍚屽悕涓嶅悓椤圭洰鏈脊绐椼�� +7. 鎶曡祫涓ゅ紶鏄庣粏琛紙`X鏈堝杩愮珯鎶曡祫鏄庣粏琛╜ / `X鏈堢墿娴佺珯鍦烘姇璧勬槑缁哷锛夌敓鎴愬櫒鏈仛銆� + +### 绗� 3 姝ユ敹鍙ｅ缓璁紙寰呯敤鎴锋媿鏉匡級 + +涓嶅啀璁� Java 鍚勭畻涓�濂楋紝鏀逛负**涓�鏉￠摼璺嚭鏁�**锛氭瘝鐗堝叕寮忛摼锛堝叏鐪佽 = 危17 甯傚窞銆佺疮璁� = 危鍚勬湀銆佹淳鐢熼〉璺ㄩ〉寮曠敤锛�+ 鍙拌处椤靛啓鏁� + 鐢熸垚鏀跺熬閲嶇畻銆� + +1. 鍙拌处椤碉紙璐ц繍 / 鐝嚎鍖呰溅 / 鍏氦 / 鍑虹 / 缃戠害杞� / 杞ㄩ亾杞浮锛夊彧鍐欏綋鏈堝�硷紱 +2. 娲剧敓椤碉紙鍩庡競瀹㈣繍 / 涓彛寰勬槑缁� / 鍏矾鎬诲杩� / 涓彛寰勫杩愰噺 / 鎺掑悕锛�**鍙ˉ鍏紡 + 閲嶇畻锛屼笉鍗曠嫭鍐欐暟**锛� +3. 鍙湁姣嶇増閲屾湰灏辨槸纭紪鐮佹暟鍊肩殑琛岋紙涓彛寰勬槑缁嗙殑鍩庡競绾�"鍩庨檯鍩庝埂鍑虹/缃戠害杞�"銆佸叏鐪佽锛夋寜鍥涚淮鍙ｅ緞鍥炲～锛� +4. 鐙珛瀵煎嚭浠讹紙鐢熸垚_涓彛寰勬槑缁� / 鎺掑悕 / 鍏矾鏃呭鍒嗗競宸烇級鏀逛负鐩存帴鍙栨眹鎬昏〃瀵瑰簲椤电殑鍊硷紝鎴栧叡鐢ㄥ悓涓�鍙ｅ緞鍑芥暟锛� +5. 姣嶇増閲屽紩閿欓〉鐨勫煄甯傜骇鍏紡淇竴娆★紙绗� 3 鏉★級锛� +6. 鐢熸垚鍚庤窇"鐢熸垚浠� vs 姣嶇増閲嶇畻"閫愭牸鍥炲綊姣斿锛屽樊寮傛竻鍗曡惤鏃ュ織锛屼綔涓洪獙鏀跺熀绾裤�� ## 鍥涖�佹槑澶╄鍒� -1. 绗� 3 姝ワ細缁熶竴涓彛寰勫彛寰勶紙rank 鍏ㄧ渷鍚屾瘮鏀逛负鍚屾簮 + `loadMidClassMap` 琛ヤ袱缁达級锛屾敼瀹屽鐙珛涓彛寰勬槑缁嗕笌姹囨�昏〃閫愰」姣斿銆� -2. 鎶曡祫"鏂板椤圭洰鎻掕 + 鍒嗙粍琛屽叆搴�"鏂规钀藉湴锛堢瓑鐢ㄦ埛瀵�"妯″潡"鍙ｅ緞鐨勬渶鍚庣‘璁わ級銆� -3. 寤虹敓鎴愪欢 vs 姣嶇増閲嶇畻鐨勫洖褰掓瘮瀵硅剼鏈紝鍥哄寲涓烘瘡娆℃敼鍔ㄧ殑楠屾敹鍩虹嚎銆� \ No newline at end of file +1. 绗� 3 姝ユ敹鍙ｏ細鎸変笂闈� 6 鏉¤惤鍦帮紙鍏堜慨姣嶇増寮曢敊椤电殑鍩庡競绾у叕寮� 鈫� 鎺掑悕浠舵敼鍙栧悓婧� 鈫� 寤哄洖褰掓瘮瀵硅剼鏈級銆� +2. 缃戠害杞� 2026-01~06 璁㈠崟鏁版嵁缂哄彛锛氬悜鐢ㄦ埛纭鏄ˉ鏁拌繕鏄暀绌恒�� +3. 鎶曡祫"鏂板椤圭洰鎻掕 + 鍒嗙粍琛屽叆搴�"鏂规钀藉湴锛堢瓑鐢ㄦ埛瀵�"妯″潡"鍙ｅ緞鐨勬渶鍚庣‘璁わ級銆� +4. 鎶曡祫涓ゅ紶鏄庣粏琛ㄧ敓鎴愬櫒銆� -- Gitblit v1.9.1