From b14fec1599277629e10b2bc686f02fd0c2e0bec1 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期五, 18 九月 2026 16:46:30 +0800 Subject: [PATCH] fix(货运月报): 订正持续在规企业累计运距同比基期口径（v2） --- docs/工作日结/工作日结_2026-09-18.md | 205 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 205 insertions(+), 0 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" new file mode 100644 index 0000000..27f18a8 --- /dev/null +++ "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" @@ -0,0 +1,205 @@ +# 宸ヤ綔鏃ョ粨_2026-09-18 + +## 涓�銆佷粖澶╁仛浜嗕粈涔� + +### 1. 姹囨�昏〃涓夋潯涓荤嚎锛堢敤鎴� 09-18 涓婂崍鎻愬嚭锛屽凡淇墠涓ゆ潯锛� + +**鍏堝畾浣嶏紝鍐嶅姩鎵�**锛氬鏍� 8 鏈堢敓鎴愪欢锛岀‘璁や笁鏉′富绾挎槸銆屼竴涓粺涓�鏍瑰洜 + 涓�澶勯〉鑼冨洿婕忛」 + 涓�澶勫彛寰勭己鍙ｃ�嶏細 + +- 姣嶇増鏈韩鏄叕寮忛┍鍔ㄧ殑锛氬叏鐪佽 = 危17 甯傚窞锛坄鍏氦!C5 = =C9+C13+鈥锛夈�佸煄甯傚杩�/涓彛寰勬槑缁嗗競宸炶 = 璺ㄨ〃寮曠敤锛坄鍩庡競瀹㈣繍!C9 = =鍏氦!C16+鍑虹!C16+缃戠害杞�!C16+'杞ㄩ亾銆佽疆娓�'!C9`锛夆啋 杩欎袱椤垫牴鏈笉鐢ㄥ崟鐙啓鏁版嵁銆� +- 涓荤嚎 1 鏍瑰洜锛歚SummaryWorkbookFiller.ensureMonthFormulas()` 椤佃寖鍥村彧鍚� 6 涓彴璐﹂〉锛屾紡 鍩庡競瀹㈣繍/涓彛寰勬槑缁嗭紱鑰屽悓姣斿叕寮忕敤鐨勯〉鑼冨洿鏄惈鐨� 鈫� 鍑虹幇"鍚屾瘮鍒楁湁鍏紡銆佸綋鏈堝�煎垪绌虹櫧"銆� +- 涓荤嚎 2/3 鏍瑰洜锛氱敓鎴愪欢**涓嶅甫鍏紡缂撳瓨鍊�**锛岄瑙�/浜屾澶勭悊璇诲埌鐨勬槸姣嶇増涓婁竴鏈熺殑鏃у�笺�� + +**鏀瑰姩**锛� +- `SummaryWorkbookFiller.ensureMonthFormulas()`锛氶〉鑼冨洿鏀圭敤 `isMonthLedgerSheet`锛涙淳鐢熼〉鏂板"缁撴瀯鎬у父閲忚鎸夋湀娌跨敤"锛堜腑鍙ｅ緞鏄庣粏 姝︽眽 鍩庨檯鍩庝埂鍑虹/缃戠害杞� 鎭掍负 0 鐨� 4 鏍硷級锛涘姞 logger锛涘垹鎺夊凡鏃犵敤鐨� `isFilledLedgerSheet()`銆� +- `ReportExportService.recalcWorkbookFormulas()`锛氭柊澧烇紝鐢熸垚鏀跺熬閫愭牸 `evaluateFormulaCell` 鍐欏洖缂撳瓨鍊硷紙澶辫触鍏滃簳 `fullCalcOnLoad=true`锛夈�� + +**韪╁潙璁板綍**锛歅OI 4.1 鐨� `FormulaEvaluator.evaluate(Cell)` **鏃犲壇浣滅敤**锛堝彧绠椾笉鍐欙級锛岀涓�鐗堢櫧璺戯紙鏃ュ織"鎴愬姛 40713 鏍�"浣嗘枃浠舵棤 `<v>`锛夛紝蹇呴』鐢� `evaluateFormulaCell(Cell)`銆� + +### 2. 鍏朵粬 + +- 鍐欎簡銆婃眹鎬昏〃涓夋潯涓荤嚎淇鏂规_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銆佸叏鐪佽闈犵紦瀛樺�� 鈫� 闇�淇瘝鐗堝叕寮忎竴娆°�� + + +### 4. 绗� 3 姝ユ敹灏撅細缂烘暟鎹笉鍐嶈鐩栧畾绋垮�硷紙13:30锛� + +鐢ㄦ埛鍙嶉銆岀嫭绔嬨�婄敓鎴恄涓彛寰勬槑缁嗐��8 鏈堟病闂浜嗭紝浣� 1~6 鏈堝弽鑰岃娓呯┖銆嶅悗锛岃拷鍑�**鐪熸鏍瑰洜**锛� + +- `exportPassengerMidDetail()` 瀵规墿鍒楁湀浠斤紙>6 鏈堬級鐨勬�昏鍊煎垪鏄�岀洿鎺ュ啓搴撳唴鍥涚淮鍚堣銆佸啓 0 灏� setBlank銆嶏紱 + 鑰� 1~6 鏈堣蛋 `keepCached()` 鎶婂叕寮忔竻鎴愮┖鏍� 鈫� 琛ㄩ潰涓� 7/8 鏈堜慨濂戒簡锛屽疄闄呬笂鎶婃瘝鐗堢殑瀹氱閾捐矾鎺愭柇浜嗐�� +- `fillMidCell()` 鍚屾牱銆屽簱鍐呭彇鍊间负 0 鈫� setBlank銆嶏紝浜庢槸 2026-01~06 缃戠害杞﹀煄涔★紙搴撳唴璇� 6 涓湀鏃犺鍗曘�佺淮搴� 4 鏃犳簮锛夎鏁寸墖娓呯┖锛� + 杩炲甫鎬昏銆佺疮璁°�佸悓姣斿叏閿欍�� + +**鏀瑰姩锛坄ReportExportService.java`锛�4 澶勶級**锛� + +1. `exportPassengerMidDetail()` 鎬昏鍊煎垪锛氬垹鎺夈�屾墿鍒楁湀浠芥墜鍐欏簱鍐呭悎璁°�嶄笌 `keepCached` 娓呭叕寮忎袱鏉℃梺璺紝**涓�寰嬩繚鐣欐ā鏉垮叕寮�**锛岀敱鏀跺熬閲嶇畻鍐欏洖缂撳瓨鍊笺�� +2. `fillMidCell()`锛氬簱鍐呭彇鍊间负 0锛堣鏈堣缁存棤婧愶級鏃�**鐩存帴 return锛屼繚鐣欐瘝鐗�/瀹氱鍘熷��**鈥斺�旂粷涓嶅啓绌恒�佷篃缁濅笉鍐� 0銆� +3. `recalcWorkbookFormulas()`锛氭柊澧� `ev.setIgnoreMissingWorkbooks(true)`銆傝法绨垮叕寮忥紙`[1]鍑虹!C13`锛夊湪澶栭儴宸ヤ綔绨跨己澶辨椂榛樿鎶涘紓甯革紝 + 浼氳寮曠敤瀹冪殑鎬昏/绱杩為攣澶辫触锛堣〃鐜颁负銆屽叕寮忓湪銆佹病鏈夌紦瀛樺�笺�嶏級锛岀疆 true 鍚庢敼鐢ㄨ鏍艰嚜韬紦瀛樺�煎弬涓庤绠椼�� +4. 鏂板 `blankFutureMonthColumns()`锛氭姤琛ㄦ湡涔嬪悗鐨勬湀浠藉垪锛�8 鏈堟姤琛ㄩ噷鐨� 9~12 鏈堬級**娓呮暟鎹牸銆佺暀琛ㄥご**锛岄伩鍏嶅厠闅嗗叕寮忕畻鍑恒��9~12 鏈堝叏鏄� 0銆嶇殑鍋囨暟鎹�� + +**閲嶈绾犳锛堝啓杩涙祴璇曟姤鍛婏紝涔熷湪姝ょ暀鐥曪級**锛氭棭鍓嶅垽鏂�屾瘝鐗堜腑鍙ｅ緞鏄庣粏鍩庡競绾у叕寮忓紩閿欓〉锛坄=鍏氦!C13-鍏氦!C15`锛夈�嶆槸**璇垽**鈥斺�� +閭ｆ槸鎺у埗鍙颁腑鏂囦贡鐮侀�犳垚鐨勮璇伙紱姣嶇増/妯℃澘鐪熷疄鍏紡鏄纭殑 `=[1]鍑虹!C13-[1]鍑虹!C15` / `=[1]缃戠害杞�!C13-[1]缃戠害杞�!C15`锛� +鍙拌处椤点�屾�婚噺鈭掑煄甯傚唴銆嵨�17 甯傚窞 = 535.83 / 333.39锛屼笌姣嶇増瀹氱鍏ㄧ渷琛屽畬鍏ㄤ竴鑷淬��**姣嶇増鍏紡涓嶉渶瑕佷慨锛屼箣鍓�"寰呬慨姣嶇増"鐨勭粨璁轰綔搴熴��** + +### 5. 缃戠害杞﹁鍗曟姤鍛婏細Word 2003 XML锛圵ordML锛夊吋瀹瑰鍏ワ紙15:00锛� + +**鐢ㄦ埛鎶ラ殰**锛氥�婃箹鍖楃綉缁滈绾﹀嚭绉熸苯杞�2025骞�09鏈堝垎鏋愭姤鍛�.docx銆嬫斁鍦ㄦ闈㈠涓嶈繘鍘汇�� + +**瀹氫綅**锛氳鏂囦欢鏍规湰涓嶆槸 docx 鈥斺�� 鏄� **Word 2003 XML锛圵ordML 骞抽摵 XML锛�** 琚敼鍚嶆垚 `.docx`锛堟枃浠跺ご `<?mso-application progid="Word.Document"?><w:wordDocument xmlns:w=".../word/2003/wordml">`锛�3.1MB 绾� XML銆佷笉鏄� zip 鍖咃級锛孭OI 鐨� `XWPFDocument` 鍙兘璇� OPC(zip) 鍖� 鈫� 鎶� `File is not a zip file`銆傜洃绠″钩鍙�/鍚屼簨闂存祦杞殑鎶ュ憡甯告槸杩欑鏍煎紡锛屼細鍙嶅鍑虹幇銆� + +**鏀瑰姩锛坄DataImportService.java`锛�**锛� +- `importWycOrderReport()` 鍏ュ彛鎸夋枃浠跺ご鍡呮帰鏍煎紡鍒嗘淳锛歾ip鈫抎ocx锛沗<w:wordDocument`+`wordml`鈫�**鏂板 WordML DOM 瑙ｆ瀽璺緞**锛沗D0CF11E0`鈫掓槑纭彁绀恒��.doc 璇峰彟瀛樹负 docx銆嶏紱鍏跺畠鈫掋�屾棤娉曡瘑鍒�嶏紱 +- 鏂板 `isWordPackage()`锛歾ip 浣嗘棤 `word/document.xml`锛坸lsx 鏀瑰悕锛夆啋 涓枃鎻愮ず锛屼笉鍐嶆姏 XMLBeans 鑻辨枃鍫嗘爤锛� +- 鏂板 `parseXmlSafely()`锛欴OM 瑙ｆ瀽鍏抽棴澶栭儴瀹炰綋/DTD锛堥槻 XXE锛夛紱 +- 琛ㄦ牸鍖归厤鎶芥垚涓庢牸寮忔棤鍏崇殑 `matchWycOrderTable()`锛宒ocx 涓� WordML 涓ゆ潯璺緞**鍏辩敤鍚屼竴濂楄〃澶磋瘑鍒�/17 甯傚窞鍙栧��/鍚堣琛岄�昏緫**锛屼笉浼氬彛寰勫垎鍙夛紱 +- 鎶ヨ〃鏈熻瘑鍒娊鎴� `periodOfParagraphs()`锛屼袱绉嶆牸寮忓叡鐢ㄣ�� + +**楠岃瘉**锛�8 鏉＄敤渚嬪叏閮ㄩ�氳繃锛堣銆婂姛鑳芥祴璇曟姤鍛奯缃戠害杞﹁鍗曟姤鍛奧ordML鍏煎瀵煎叆_2026-09-18銆嬶級銆�2025-09 鍏ュ簱锛氳鍗曞悎璁� 17,652,159锛涙姹� 8,076,610 / 榛勭煶 676,644 / 鍗佸牥 1,048,593 / 鎭╂柦 804,736 / 鏋楀尯 1,424锛屼笌鎶ュ憡闄勪欢1 閫愰」涓�鑷达紱pin 浠� `wyc_total_monthly` 鍚屾湡澶嶅埗銆傜湡 docx锛�2026-08锛夐噸瀵煎箓绛夋棤鍙樺寲锛沗.doc`銆亁lsx 鏀瑰悕銆侀潪鏈姤鍛� docx 涓夌璐熷悜鍧囩粰鍑轰腑鏂囧彲鎿嶄綔鎻愮ず銆� + +**鏁版嵁缂哄彛宸茶ˉ榻愶紙閲嶈锛�**锛氱敤鎴峰湪 14:21~14:49 涔嬮棿鑷瀵煎叆 2026-01~06锛�6 浠斤級銆�2025-01銆�2025-10~12锛�2025-09 鐢辨湰娆′慨澶嶅悗琛ュ叆銆傜幇鍦� **2025-01~12 + 2026-01~08 鐨勮鍗曚笌 pin 鍏ㄩ儴榻愬叏**銆傜洿鎺ユ晥鏋滐細涓彛寰勭淮搴� 4 鐨� 1~6 鏈堜粠銆屾棤婧愩�嶅彉涓恒�屽彲绠椼�嶏紝**涓彛寰勬帓鍚嶄欢涓庝腑鍙ｅ緞鏄庣粏浠剁殑绱鍙ｅ緞鑷姩褰掍竴**锛堜袱鑰� 1-8 鏈堢疮璁″潎涓� 31528.0606锛屾鍓嶅樊 2063.45锛夈�� + +## 浜屻�佹祴璇曠粨鏋滄憳瑕� + +瑙� `docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_姹囨�昏〃鍏紡鎵╅〉涓庨噸绠梍2026-09-18.md`锛�8 鏉℃鍚� + 4 鏉¤礋鍚�/杈圭晫 + 4 椤瑰叆搴撴娊鏌ワ紝鍏ㄩ儴閫氳繃銆� + +- 鍩庡競瀹㈣繍 36 鏍笺�佷腑鍙ｅ緞鏄庣粏 180 鏍� 8 鏈堝垪琛ラ綈锛堝叕寮� + 缂撳瓨鍊硷級銆� +- 鍏ㄧ渷琛� = 危17 甯傚窞涓夋柟涓�鑷达細鍏氦 12315.37銆佸嚭绉� 5786.81銆佺綉绾﹁溅 4997.74锛堜笌搴撳唴 `city_bus_monthly` 2026-08 鍚勫競宸炴眰鍜岄�愰」瀵归綈锛涙姹� 3856.83 / 榛勭煶 879.12 鎶芥煡涓�鑷达級銆� +- 涓彛寰勬帓鍚� 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 鏍煎彉鍖栵紙鍏ㄩ儴鏄洰鏍囨牸锛夈�� + + +### 绗� 3 姝ユ敹灏撅紙13:30锛夐獙璇� + +- 鐙珛銆婄敓鎴恄涓彛寰勬槑缁嗐�嬶細18 鍦板尯 脳 12 涓湀锛�**鎬昏 = 危4 缁淬�佺疮璁� = 危1-8 鏈堬紝涓嶄竴鑷存暟 0**锛�9~12 鏈堟暟鎹牸鍏ㄧ┖銆佽〃澶翠繚鐣欍�� +- 涓庢眹鎬诲ぇ琛ㄣ�屼腑鍙ｅ緞鏄庣粏銆嶉〉 1~8 鏈� **704 瀵规牸 0 宸紓**銆� +- 鍏ㄧ渷 1-8 鏈堟�诲杩愰噺锛�3733.79 / 3777.83 / 3874.44 / 3959.25 / 4115.87 / 4034.99 / 4028.32 / 4003.57锛� + 缃戠害杞﹀煄涔★細333.39 / 294.49 / 347.23 / 335.39 / 369.27 / 383.68 / 421.46 / 426.56锛涚疮璁� AA5 = 31528.0607銆丄A9 = 2911.47銆� +- 鍩庡競绾х綉绾﹁溅鍩庝埂锛氭姹� 0銆侀粍鐭� 13.599765541547697锛堟部鐢ㄥ畾绋匡紝鏈娓呯┖锛夈�� +- 鍥炲綊锛氭眹鎬诲ぇ琛� 17 椤� **0 鏍煎樊寮�**銆併�婄敓鎴恄涓彛寰勬帓鍚嶃��**0 鏍煎樊寮�**锛� + 鏄庣粏浠跺樊寮備粎钀藉湪 鎬昏 / 鍑虹鍩庝埂 / 缃戠害杞﹀煄涔� 琛岀殑鏈堜唤鍒椾笌 AA 绱鍒楋紙灞為鏈燂級銆� + +### 缃戠害杞﹁鍗曟姤鍛� WordML 瀵煎叆锛�15:00锛夐獙璇� + +- 8 鏉＄敤渚嬶紙4 姝ｅ悜 / 3 璐熷悜 / 1 杈圭晫锛夊叏閮ㄩ�氳繃锛歐ordML 2025-09 瀵煎叆鎴愬姛銆佹姤琛ㄦ湡鐣欑┖鏃堕潬鏍囬鑷姩璇嗗埆銆佺湡 docx 骞傜瓑鏃犲彉鍖栥�乣.doc`/xlsx 鏀瑰悕/闈炴湰鎶ュ憡 docx 鍧囩粰鍑轰腑鏂囨彁绀恒�� +- 鏁版嵁琛ラ綈鍚庨噸璺� 8 鏈堝鍑哄洖褰掞細鐙珛銆婄敓鎴恄涓彛寰勬槑缁嗐�嬫姤琛ㄦ湡鍐呬笉涓�鑷� 0銆佹姤琛ㄦ湡鍚庝粛鏈夊�� 0锛涗笌姹囨�诲ぇ琛ㄣ�屼腑鍙ｅ緞鏄庣粏銆嶉〉 **704 瀵规牸 0 宸紓**锛涘叏鐪� 1-8 鏈堟�诲杩愰噺 3733.79鈥�4003.57锛岀綉绾﹁溅鍩庝埂 333.39鈥�426.56锛岀疮璁� AA5=31528.0607銆丄A9=2911.47銆� +- 鎺掑悕浠朵笌鏄庣粏浠剁疮璁″彛寰勪竴鑷达紙鍧� 31528.0606锛夛紝宸�� 2063.45 娑堝け銆� + +## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙 + +1. ~~涓彛寰勬帓鍚嶅悓姣斾粛鏄啓姝诲�紐~ 鈫� **宸叉寜鏂板彛寰勫彇鍊�**锛圡3=0.638 / Q3=0.2247锛夛紝浣嗕粛涓庝腑鍙ｅ緞鏄庣粏鐨� 0.0581 涓嶈嚜娲斤紝宸�� 2063.45 = 缃戠害杞� 1-6 鏈堟棤婧愶紱**鏀跺彛鍔炴硶瑙佷笅鏂�"绗� 3 姝ユ敹鍙ｅ缓璁�"**銆� +2. ~~`loadMidClassMap()` 缂哄贰娓稿嚭绉� + 缃戠害杞︿袱缁磣~ 鈫� **宸茶ˉ**锛堢淮搴� 3銆�4锛夛紝鐙珛涓彛寰勬槑缁嗗洓缁撮綈鍏ㄣ�� +3. ~~**姣嶇増缂洪櫡寰呬慨**锛氫腑鍙ｅ緞鏄庣粏鍩庡競绾у叕寮忓紩閿欓〉~~ 鈫� **璇垽锛屽凡浣滃簾**锛氱湡瀹炲叕寮忔槸姝ｇ‘鐨勮法绨垮紩鐢紝姣嶇増鏃犻渶淇敼锛涘綋鏃剁殑"寮曢敊椤�"鏄帶鍒跺彴涓枃涔辩爜璇銆� +4. ~~**鏁版嵁缂哄彛**锛�2026-01~06 缃戠害杞﹁鍗曟湭鍏ュ簱~~ 鈫� **宸茶ˉ榻�**锛堢敤鎴� 14:21~14:49 瀵煎叆 2026-01~06 + 2025-01 + 2025-10~12锛�2025-09 缁� WordML 淇鍚庤ˉ鍏ワ級銆傜幇鍦� 2025-01~12 + 2026-01~08 璁㈠崟榻愬叏锛岀淮搴� 4 鍏ㄦ湡鍙畻锛屾帓鍚嶄欢/鏄庣粏浠跺彛寰勫綊涓�銆備粛寤鸿琛ヤ竴鏉°�屽鍏ユ椂璁㈠崟鍒楀叏绌恒�嶇殑鏄惧紡鎻愮ず锛堛�婃ā鏉縚缃戠害杞﹁鍗曞強鍏ㄧ渷鎬婚噺.xlsx銆嬮偅绫绘枃浠剁幇鍦ㄤ細闈欓粯鎴愬姛锛夈�� +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. ~~姣嶇増閲屽紩閿欓〉鐨勫煄甯傜骇鍏紡淇竴娆~ 鈫� **鏃犻渶**锛堣鍒わ紝宸蹭綔搴燂級锛� +6. 鐢熸垚鍚庤窇"鐢熸垚浠� vs 姣嶇増閲嶇畻"閫愭牸鍥炲綊姣斿锛屽樊寮傛竻鍗曡惤鏃ュ織锛屼綔涓洪獙鏀跺熀绾匡紱 +7. 搴撳唴缂哄け锛堣鏈堣缁存棤婧愶級鏃�**涓�寰嬩繚鐣欐瘝鐗堝畾绋垮�笺�佷笉瑕嗙洊**鈥斺�斿凡鍦ㄧ 4 鏉℃敼鍔ㄤ腑钀藉湴銆� + +## 鍥涖�佹槑澶╄鍒� + +1. 绗� 3 姝ユ敹鍙ｏ細鎺掑悕浠朵笌鏄庣粏浠跺彛寰勫綊涓�锛堝樊鍊� 2063.45 = 2026 骞� 1-6 鏈堢綉绾﹁溅鍩庝埂锛夆啋 鎺掑悕浠舵敼鍙栨眹鎬昏〃鍚屾簮鍊� 鈫� 鍥哄寲"鐢熸垚浠� vs 姣嶇増閲嶇畻"閫愭牸鍥炲綊鑴氭湰銆� +2. 缃戠害杞﹁鍗曞鍏ョ┖鍒楁彁绀猴紙椤甸潰鏄庣‘鎻愮ず"璇ユ湡璁㈠崟鍒椾负绌猴紝鏈啓鍏ヨ鍗曟暟"锛夆�斺�旀暟鎹櫧宸茶ˉ榻愶紝浣嗛潤榛樻垚鍔熶粛鏄殣鎮ｃ�� +3. 鎶曡祫"鏂板椤圭洰鎻掕 + 鍒嗙粍琛屽叆搴擄紙`fund_channel`锛�"鏂规钀藉湴锛堢瓑鐢ㄦ埛瀵�"妯″潡"鍙ｅ緞鐨勬渶鍚庣‘璁わ級銆� +4. 鎶曡祫涓ゅ紶鏄庣粏琛ㄧ敓鎴愬櫒锛坄X鏈堝杩愮珯鎶曡祫鏄庣粏琛╜ / `X鏈堢墿娴佺珯鍦烘姇璧勬槑缁哷锛夈�� + +--- + +## 浜斻�佸倣鏅氳拷鍔狅細璐ц繍鏈堟姤銆屾寔缁湪瑙勪紒涓氥�嶅垎甯傚窞 1-8 鏈堢疮璁¤繍璺濆強鍚屾瘮锛堟闈氦浠橈級 + +### 5.1 闇�姹備笌鍙ｅ緞 + +鐢ㄦ埛瑕佹眰锛氭妸璐ц繍鏈堟姤銆屾寔缁湪瑙勪紒涓氥�嶅垎甯傚窞 1-8 鏈堢疮璁¤繍璺濆強鍚屾瘮鎯呭喌鏁寸悊鎴� Excel锛岀敓鎴愬埌妗岄潰銆� + +- **鎸佺画鍦ㄨ浼佷笟** = 2026 骞� 1-8 鏈堣繛缁� 8 涓湀鍧囦笂鎶� H203-2 鏈堟姤鐨勪紒涓氾紝**636 瀹�**锛�2026 骞村悇鏈堜笂鎶ヤ紒涓氭暟鍧囦负 636锛屽叏鏈熶竴鑷达級銆� +- **绱骞冲潎杩愯窛** = 1-8 鏈堢疮璁¤揣鐗╁懆杞噺 梅 绱璐ц繍閲忥紙鍔犳潈骞冲潎锛夈�� +- **鍚屾瘮** = 2026 骞� 1-8 鏈堢疮璁¤繍璺� 梅 2025 骞� 1-8 鏈堢疮璁¤繍璺� 鈭� 1锛屽彧鍦�**涓ゅ勾鍧囨寔缁湪瑙勭殑 545 瀹�**涓婅绠楋紙鍙瘮鍙ｅ緞锛夈�� + +### 5.2 鏁版嵁涓庝骇鍑� + +鏁版嵁婧愶細`traffic_audit.h2032_enterprise_monthly`锛�2025-01 ~ 2026-08锛�13,056 鏉′紒涓氱骇璁板綍锛夈�� + +浜у嚭锛歚C:\Users\閮戠帀娲乗Desktop\璐ц繍鏈堟姤_鎸佺画鍦ㄨ浼佷笟_鍒嗗競宸�1-8鏈堢疮璁¤繍璺濆強鍚屾瘮_2026-09-18.xlsx`锛�5 椤电锛氳鏄庝笌鍙ｅ緞 / 鍒嗗競宸炴眹鎬� / 鍒嗗競宸炲垎鏈� / 浼佷笟鏄庣粏 636 琛� / 鍙ｅ緞鏍￠獙锛夛紝鐢熸垚鑴氭湰 `docs\宸ュ叿\鎸佺画鍦ㄨ浼佷笟绱杩愯窛鐢熸垚.py`銆� + +### 5.3 鍏抽敭缁撴灉 + +| 甯傚窞 | 鎸佺画鍦ㄨ(瀹�) | 1-8鏈堢疮璁″钩鍧囪繍璺�(鍏噷) | 鍚屾瘮 | 甯傚窞 | 鎸佺画鍦ㄨ(瀹�) | 1-8鏈堢疮璁″钩鍧囪繍璺�(鍏噷) | 鍚屾瘮 | +| --- | --- | --- | --- | --- | --- | --- | --- | +| 姝︽眽甯� | 199 | 162.11 | +13.5% | 榛勫唸甯� | 71 | 135.14 | +1.1% | +| 榛勭煶甯� | 20 | 117.63 | +20.2% | 鍜稿畞甯� | 17 | 113.33 | 鈭�24.1% | +| 鍗佸牥甯� | 13 | 321.13 | 鈭�2.9% | 闅忓窞甯� | 26 | 187.28 | 鈭�17.1% | +| 瀹滄槍甯� | 65 | 88.55 | +2.6% | 鎭╂柦宸� | 4 | 130.11 | +10.3% | +| 瑗勯槼甯� | 81 | 274.50 | +8.4% | 浠欐甯� | 2 | 65.61 | 涓嶉�傜敤 | +| 閯傚窞甯� | 6 | 38.15 | 鈭�59.0% | 娼滄睙甯� | 13 | 394.20 | +10.9% | +| 鑽嗛棬甯� | 40 | 281.41 | 鈭�4.7% | 澶╅棬甯� | 4 | 61.02 | 鈭�54.6% | +| 瀛濇劅甯� | 21 | 164.00 | 鈭�7.4% | 绁炲啘鏋舵灄鍖� | 2 | 57.68 | 鈭�49.1% | +| 鑽嗗窞甯� | 52 | 324.47 | 鈭�4.7% | **鍏ㄧ渷** | **636** | **156.92** | **+2.9%** | + +- 鍏ㄧ渷绱璐ц繍閲� 31399.82 涓囧惃銆佺疮璁″懆杞噺 4927161.77 涓囧惃鍏噷锛屼笌銆�2026骞�8鏈堣涓婅揣鐗╁懆杞噺涓庡钩鍧囪繍璺濆垎鏋愭姤鍛娿��**瀹屽叏涓�鑷�**锛�8 鏈堝綋鏈堝叏鐪佸钩鍧囪繍璺� 155.51 鍏噷浜︿笌鍙戝竷鍙ｅ緞涓�鑷淬�� +- 绱杩愯窛鏄庢樉鎷夐暱鐨勫彧鏈夋姹夛紙+13.5%锛夈�侀粍鐭筹紙+20.2%锛夛紱閯傚窞锛堚垝59.0%锛夈�佸ぉ闂紙鈭�54.6%锛夈�佹灄鍖猴紙鈭�49.1%锛夈�佸捀瀹侊紙鈭�24.1%锛夈�侀殢宸烇紙鈭�17.1%锛変负澶у箙缂╃煭锛屽缓璁笟鍔′晶鍏虫敞銆� + +### 5.4 娴嬭瘯涓庨棶棰� + +銆婂姛鑳芥祴璇曟姤鍛奯璐ц繍鏈堟姤鎸佺画鍦ㄨ浼佷笟鍒嗗競宸炵疮璁¤繍璺漘2026-09-18.md銆嬶細14 鏉＄敤渚嬶紙8 姝ｅ悜 / 3 杈圭晫 / 3 璐熷悜锛夊叏閮ㄩ�氳繃锛�2026-01~07 閫愭湀瑙勪笂璐ц繍閲忋�佸懆杞噺涓庢眹鎬昏〃銆� 璐ц繍銆嶉〉 14 椤规瘮瀵� 0 宸紓銆� + +- 鐢熸垚鑴氭湰琛屽彿鑷閿欎綅瀵艰嚧琛ㄥご/鏈琚鐩� 鈫� 宸蹭慨姝ｅ苟閫愯澶嶆牳锛堣〃澶� + 17 甯傚窞 + 鍚堣鍏� 18 琛岋級銆� +- 妗岄潰鍓湰绗竴鐗堜负淇鍓嶆枃浠� 鈫� 宸查噸鏂板悓姝ワ紝SHA256 涓�鑷淬�� + +### 5.5 寰呭姙 + +1. ~~璇蜂笟鍔＄‘璁ゃ�屾寔缁湪瑙勪紒涓氥�嶅畾涔墌~ 鈫� **鐢ㄦ埛 2026-09-18 宸茬‘璁�**锛氭寜銆�2026 骞� 1-8 鏈堣繛缁� 8 涓湀涓婃姤銆�= 636 瀹讹紱浜や粯浠舵棤闇�璋冩暣銆� +2. 浠欐甯� 2026 骞� 2 瀹舵寔缁湪瑙勪紒涓� 2025 骞� 1-8 鏈堟棤杩炵画涓婃姤璁板綍锛屽悓姣旂暀绌猴紝寤鸿鏍稿璇ュ競宸炲巻鍙蹭笂鎶ャ�� + +### 5.6 璁㈡锛氬悓姣斿熀鏈熷彛寰勶紙v2锛�17:0x锛� + +鐢ㄦ埛鍙嶉銆�1-8 鏈堢疮璁¤繍璺濆悓姣斾笉瀵广�嶃�傛牳鏌ュ悗纭锛�**v1 鐨勫悓姣斿熀鏈熷彇閿欎簡**銆� + +- 姹囨�昏〃銆岃揣杩愩�嶉〉 T 鍒楋紙绱鍚屾瘮锛夊叕寮� = `=S7/SUM(V7,X7,Z7,AB7,AD7,AF7,AH7,AJ7)-1`锛屽熀鏈熸槸 **2025 骞� 1-8 鏈堝叏閮ㄨ涓婁紒涓�**锛堝叏鐪� 664 瀹讹級锛泇1 鐢ㄧ殑鏄�屼袱骞村潎鎸佺画鍦ㄨ鐨� 545 瀹躲�嶏紝瀵艰嚧鍚屾瘮绯荤粺鎬у亸灏忋�� +- 璇佹嵁锛欴B 2025 骞� 1-8 鏈� = 33994.4483 涓囧惃 / 5102518.9463 涓囧惃鍏噷锛屼笌姹囨�昏〃 V7..AJ7銆乂8..AJ8 缂撳瓨鍊�**閫愰」涓�鑷�**銆� + +| 鎸囨爣 | v1锛�545 瀹讹級 | v2锛堝畼鏂瑰叏鍙ｅ緞锛� | 鍙戝竷鎶ュ憡 | +| --- | --- | --- | --- | +| 绱璐ц繍閲忓悓姣� | 鈭�7.96% | **鈭�7.63%** | 鈭�7.63% | +| 绱鍛ㄨ浆閲忓悓姣� | 鈭�5.30% | **鈭�3.44%** | 鈭�3.44% | +| 鍏ㄧ渷 1-8 鏈堢疮璁″钩鍧囪繍璺� | 158.18 / 153.73 = +2.90% | **156.92 / 150.10 = +4.54%** | 鈥� | + +- 閲嶇畻鍚� `鍒嗗競宸炴眹鎬籤 鏀逛负銆�2026 鍏ㄥ彛寰� / 2025 鍏ㄥ彛寰� / 鍚屾瘮銆嶄笁娈靛垪锛涙柊澧� `鍙ｅ緞瀵规瘮` 椤靛苟鍒椾袱绉嶅彛寰勶紝鏍囧嚭宸紓瓒� 10 涓櫨鍒嗙偣鐨勫競宸炪�� +- 淇鍚庡競宸炲悓姣旓細姝︽眽 +17.0%銆侀粍鐭� +35.3%銆佽闃� +21.0%銆佸疁鏄� +7.4%銆佹綔姹� +5.6%銆侀殢宸� +4.9%銆佹仼鏂� +1.2%銆佽崋宸� 鈭�0.2%銆侀粍鍐� 鈭�0.3%銆佸崄鍫� 鈭�1.9%銆佽崋闂� 鈭�6.6%銆佸瓭鎰� 鈭�13.3%銆佸捀瀹� 鈭�25.4%銆佹灄鍖� 鈭�49.1%銆佸ぉ闂� 鈭�54.6%銆侀剛宸� 鈭�63.1%銆佷粰妗� 鈭�89.1%銆� +- 宸插悓姝ユ闈氦浠樹欢锛圫HA256 涓�鑷达級銆� -- Gitblit v1.9.1