From 8bcd59732179e920733dee79fc917aa513f6a37c Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期四, 17 九月 2026 16:42:07 +0800 Subject: [PATCH] chore(git): 根目录临时文件归档至 _tmp/ 并加固 .gitignore（防真实数据误提交），工作日结补记 --- docs/问题汇总/汇总表问题汇总_2026-09-17.md | 134 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 134 insertions(+), 0 deletions(-) diff --git "a/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\350\241\250\351\227\256\351\242\230\346\261\207\346\200\273_2026-09-17.md" "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\350\241\250\351\227\256\351\242\230\346\261\207\346\200\273_2026-09-17.md" new file mode 100644 index 0000000..5442b43 --- /dev/null +++ "b/docs/\351\227\256\351\242\230\346\261\207\346\200\273/\346\261\207\346\200\273\350\241\250\351\227\256\351\242\230\346\261\207\346\200\273_2026-09-17.md" @@ -0,0 +1,134 @@ +# 姹囨�昏〃闂姹囨�伙紙2026-09-17锛� + +> 瑕嗙洊鐢ㄦ埛褰撴棩鎻愬嚭鐨� 5 椤癸細姹囨�昏〃闂鎬荤粨 / 8鏈堟暟鎹己澶变笌鎺掑悕涓嶅 / 鎶曡祫棰勫畨鎺掑鍑轰负绌� / 鎶ヨ〃鐢熸垚鍔犱袱寮犳姇璧勬槑缁嗚〃 / 鏁版嵁鏌ョ湅璋冩暣銆� +> 璇佹嵁鏂囦欢鍧囧彲鍦ㄤ粨搴� `_qa_out/` 涓嬪鐜帮紙涓存椂鐩綍锛屽凡 gitignore锛夈�� + +--- + +## 涓�銆佹眹鎬诲ぇ琛紙鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08.xlsx锛�19 涓〉绛撅級鐨勯棶棰� + +### 1.1 褰撴湀鏁版嵁銆屾病鏈� 8 鏈堛�嶁�斺�旂‘瀹氭槸鐢熸垚閫昏緫闂锛屼笉鏄暟鎹病瀵� + +鏁版嵁搴撻噷 8 鏈堟簮鏁版嵁鏄綈鐨勶細 + +| 琛� | 2026-08 琛屾暟 | +|---|---| +| h2031_enterprise_monthly锛堝叕璺梾瀹�/涓彛寰勬簮锛� | 767 | +| city_bus_monthly | 142 | +| passenger_individual_monthly | 6 | +| h2032_enterprise_monthly锛堣揣杩愶級 | 636 | +| investment_monthly | 168 | + +浣嗗鍑轰欢閲岃繖浜涢〉绛剧殑 8 鏈堝垪鏄┖鐨勶細 + +| 椤电 | 鐜拌薄 | 璇佹嵁 | +|---|---|---| +| **涓彛寰勬槑缁�** | 琛ㄥご鏈� `Q3=2026骞�8鏈坄锛屾暣鍒椾负绌猴紱绱 S5=27524.49 = 1~7 鏈堜箣鍜� | `_qa_out/cmp_mid_2026.txt` | +| **鍩庡競瀹㈣繍** | 鍏ㄩ儴琛屽仠鍦� 1~7 鏈堬紙鍏ㄧ渷绱 237412.33 = 7 鏈堢殑鍊硷級 | `_qa_out/dump_city08.txt` | +| 鍏氦 / 鍑虹 / 缃戠害杞� | **甯傚窞琛�**鏈� 8 鏈堝�硷紝**鍏ㄧ渷琛�** 8 鏈堝垪绌虹櫧 | 鍚屼笂 | +| 鍩庡競鍒嗗競宸� | 甯傚窞琛屾洿鏂板埌 8 鏈堬紝**鍏ㄧ渷琛�**鍋滃湪 237412.33锛�7 鏈堝�硷級 | `_qa_out/cmp_rank_city.txt` | +| 涓彛寰勬帓鍚� | 甯傚窞琛屾洿鏂板埌 8 鏈堬紝**鍏ㄧ渷琛�**涓� 7 鏈堝鍑哄畬鍏ㄧ浉鍚� | 鍚屼笂 | + +### 1.2 鏍瑰洜锛堜唬鐮佷綅缃級 + +1. `SummaryWorkbookFiller.fillMonthlyLedger()`锛坄traffic-audit-server/.../reportexport/calc/SummaryWorkbookFiller.java:50`锛� + 鍙富鍔ㄥ洖濉� **鐝嚎鍖呰溅 / 鍏氦 / 鍑虹 / 杞ㄩ亾杞浮 / 璐ц繍 / 缃戠害杞�** 鍏〉锛岃�屼笖 `fillCityRows()` 鐢ㄣ�孉 鍒楀競宸炲悕銆嶅畾浣嶈锛� + `cityOf()` 璇嗗埆涓嶅埌銆屽叏鐪併�嶈 鈫� **鍏ㄧ渷琛屾案杩滀笉濉�**銆� +2. **鍩庡競瀹㈣繍椤点�佷腑鍙ｅ緞鏄庣粏椤垫牴鏈笉鍦ㄥ洖濉寖鍥村唴** 鈫� 鍙兘娌跨敤姣嶇増銆�8 鏈堟瘝鐗堟槸鎷� 7 鏈堢殑鍙﹀瓨鐨勶紝8 鏈堝垪鏈潵灏辨槸绌虹殑锛� + 鎵�浠ユ暣椤靛仠鍦� 1~7 鏈堬紱绱鍒楀叕寮忎篃娌℃湁鎸� 8 鏈堟墿鍒椼�� +3. 涓彛寰勬帓鍚嶇嫭绔嬬敓鎴愬櫒 `ReportExportService.exportPassengerMidRank()`锛堝悓鏂囦欢 :2485锛夛細 + - 鍏ㄧ渷琛� `B3/F3/L3/P3` 鍦ㄦā鏉块噷鏄� `=SUM(B4:B20)`锛岃�� `setValOrBlank()` 閬囧埌鍏紡鍗曞厓鏍肩洿鎺� `return`锛屼笖璇ユ柟娉�**涓嶈皟鐢� `recalc(wb)`** + 鈫� 鍏ㄧ渷琛屼竴鐩存樉绀烘ā鏉块噷鐨勬棫缂撳瓨鍊硷紙27524.4906 / 4028.3213锛夈�� + - 鍏ㄧ渷琛屽悓姣斿垪鍐欑殑鍗存槸銆屽簱鍐呭叏鐪併�嶅彛寰勶紙`midClassVal(婀栧寳鐪�)`锛夛紝涓� `SUM(17甯傚窞)` 鍙ｅ緞涓嶄竴鑷� 鈫� 鎺掑悕椤点�屾暟鎹笉瀵广�嶃�� +4. 鐙珛瀵煎嚭浠� `passengerMidDetail`锛堢敓鎴恄鍏矾鏃呭涓彛寰勬槑缁�.xlsx锛夊彟鏈夊彛寰勯敊璇細 + 1 鏈堝叏鐪佹�诲杩愰噺 2864.57锛�= 鐝嚎+鍏氦锛�**灏戜簡鍑虹+缃戠害杞�**锛夛紝7/8 鏈堜负 0锛岀疮璁� 18300.77锛� + 鑰屾眹鎬诲ぇ琛ㄤ腑鍙ｅ緞鏄庣粏 1 鏈堟槸 3733.79锛堝惈鍑虹+缃戠害杞︼級銆� + 鍘熷洜锛歚loadMidClassMap()`锛�:2313锛夊彧瑁呬簡銆屽叕璺彮绾裤�嶃�屽煄闄呭煄涔″叕浜ゃ�嶄袱缁达紝**娌℃湁瑁呭贰娓稿嚭绉熴�佺綉绾﹁溅**銆� + +### 1.3 淇鏂瑰悜锛堝緟纭鍚庡疄鏂斤級 + +- `loadMidClassMap()` 琛� `city_taxi_monthly`锛堝煄闄呭煄涔″贰娓稿嚭绉燂級涓庣綉绾﹁溅鍩庨檯鍩庝埂鍙ｅ緞锛屼袱澶勫彛寰勭粺涓�銆� +- `fillMonthlyLedger()` 澧炲姞銆屽煄甯傚杩愩�嶃�屼腑鍙ｅ緞鏄庣粏銆嶄袱椤靛洖濉紱`fillCityRows()`/鍏ㄧ渷琛岃ˉ榻愶紙鍏ㄧ渷 = 17 甯傚窞涔嬪拰锛屾垨鏀圭敤瀹㈣繍鍙ｅ緞鐨勫叏鐪佸�硷級銆� +- `exportPassengerMidRank()` 鍏ㄧ渷琛屾敼涓哄啓鏁板�硷紙鎴栧啓鍏ュ悗璋冪敤 `recalc`锛夛紝骞剁粺涓�鍚屾瘮鍙ｅ緞銆� + +--- + +## 浜屻�佹姇璧勩�婂叏鐪侀瀹夋帓璁″垝杩涘害鎯呭喌姹囨�汇�嬪鍑轰负绌� + +### 2.1 绗竴灞傚師鍥狅細瀵煎嚭鐨勬槸 **7 鏈�**锛屼笉鏄� 8 鏈� + +鐢ㄦ埛妗岄潰鏂囦欢 `D:\妗岄潰\鐢熸垚鏁版嵁\鐢熸垚_鍏ㄧ渷棰勫畨鎺掕鍒掕繘搴︽儏鍐垫眹鎬� (1).xls`锛堜粖澶� 15:16锛変笌鏈湴鐢� +`period=2026-07` 璋� `/api/report/export/investPlan` 瀵煎嚭鐨勬枃浠� **瀛楄妭瀹屽叏鐩稿悓**锛� + +``` +SHA256 妗岄潰浠� = B38F90F35FEF7CF6C667D7EE68C79D6BC160E3706C70DEBDDB993914D4AD88E6 +SHA256 7鏈堝鍑� = B38F90F35FEF7CF6C667D7EE68C79D6BC160E3706C70DEBDDB993914D4AD88E6 +``` + +浣愯瘉锛氳鏂囦欢琛ㄥご鍐欑殑鏄� `1-7鏈堢疮璁″畬鎴愭姇璧刞锛屽悎璁¤ +`H6=2106760.05 / I6=1188542.01 / J6=310523.2 / W6=123170.96` 姝ｅソ绛変簬搴撳唴 2026-07 鐨勫悎璁� +锛�2026-07锛歴tart_cum 1188542.01銆亂ear_plan 310523.2銆亂ear_cum 123170.96锛夈�� + +鐢� 2026-08 閲嶆柊瀵煎嚭鐨勬枃浠讹紙164,864 B锛夎〃澶翠负 `1-8鏈堢疮璁″畬鎴愭姇璧刞锛屽悎璁� +`H6=11108628.86 / I6=3218801.57 / J6=1273968.2 / W6=744262.86`锛屼笌搴撲竴鑷� 鈫� **鏈堜唤閫夊灏辨甯�**銆� + +### 2.2 绗簩灞傚師鍥狅細鍗充娇鏈堜唤瀵逛簡锛岃繖浜涘垪涔熷彧鑳芥槸绌虹殑 + +`妯℃澘_鍏ㄧ渷棰勫畨鎺掕鍒掕繘搴︽儏鍐垫眹鎬�.xls` 鏈� 28 鍒楋紝瀵煎嚭鍙兘濉� 16 鍒椼�傞�愬垪瀵规瘮锛坄_qa_out/cmp_8鏈坃vs_姣嶇増.txt`锛夛細 + +| 绌哄垪 | 琛ㄥご | 鍘熷洜 | +|---|---|---| +| C | 鍘匡紙甯傘�佸尯锛� | `investment_project.county` **184 涓」鐩叏涓� NULL** 鈫� 瀵煎叆娌℃姄杩欎竴鍒楋紙婧愯〃閲屾槸鏈夌殑锛屽彲淇級 | +| K / L / M | 閮ㄨ祫閲� / 鐪佽祫閲� / 浼佷笟鍙婂湴鏂硅嚜绛� | 鏁版嵁搴�**鏃犳瀛楁**锛宍DataImportService.findInvestHeader()` 鏈槧灏� | +| O / P / Q | 2026骞村缓璁鍒掞紙鍚堣/閮ㄧ渷鎶曡祫/涓昏寤鸿鍐呭锛� | 鍚屼笂锛屾棤瀛楁 | +| R / S / T | 2027骞村缓璁鍒掞紙鍚堣/閮ㄧ渷鎶曡祫/涓昏寤鸿鍐呭锛� | 鍚屼笂锛屾棤瀛楁 | +| Y / Z | 鐪佽ˉ璧勯噾 / 椤圭洰澶囨敞 | 鍚屼笂锛屾棤瀛楁 | + +鍙︽湁 2 澶�**璇箟閿欎綅**锛堜笉鏄┖锛屾槸濉敊浜嗘牸锛夛細 +- N 鍒楋紙妯℃澘=銆�2026骞磋鍒�-璁″垝杩涘害銆嶏級琚啓鎴愪簡 `progress_desc`锛堝舰璞¤繘搴﹂暱鏂囨湰锛夛紱 +- X 鍒楋紙妯℃澘=銆屽疄闄呰繘搴︺�嶏紝姣嶇増鏄�"鍦ㄥ缓/瀹屽伐"锛夐」鐩鍐� `progress_stage`銆�**鍚堣琛屽嵈鍐欏畬鎴愮巼姣斾緥**锛�0.3967 / 0.5842锛夈�� + 瑙� `ReportExportService.fillInvestPlanProjectRow()` :5059 涓� `writeInvestAggHssf()` :5263銆� + +### 2.3 缁撹 + +棰勫畨鎺掓眹鎬汇�屽緢澶氭寚鏍囩┖鐧姐��= 涓変欢浜嬪彔鍔狅細 +1. 瀵煎嚭鏃舵湀浠介�夋垚浜� 7 鏈堬紙鏂囦欢閲岃兘鐩存帴鐪嬪嚭鏉ワ級锛� +2. 瀵煎叆娌℃姄 C 鍒楋紙鍘垮競鍖猴級鈥斺�斿彲淇紱 +3. 璧勯噾鏉ユ簮銆佸缓璁鍒掋�佺渷琛ヨ祫閲戙�佸娉ㄨ繖 4 绫诲瓧娈�**鏁版嵁搴撲粠寤鸿〃璧峰氨娌℃湁**锛屼笉琛ヨ〃缁撴瀯/瀵煎叆鏄犲皠姘歌繙濉笉涓娿�� + +--- + +## 涓夈�佹姇璧勩�奨鏈堢墿娴佺珯鍦烘姇璧勬槑缁嗐�嬨�奨鏈堝杩愮珯鎶曡祫鏄庣粏琛ㄣ�嬶紙鎶ヨ〃鐢熸垚鐣岄潰鏂板锛� + +妯℃澘宸插瓨鍦細 +- `docs/鎶曡祫/妯℃澘/妯℃澘_X鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx`锛堟槑缁� + 姹囨�讳袱椤碉紝鎸夊競宸炲垎銆屼竴銆佷娇鐢ㄤ氦閫氶儴杞﹁喘绋庤祫閲戝缓璁鹃」鐩紡浜屻�佷娇鐢ㄧ渷鐕冩补绋庤繑杩樿祫閲戝缓璁鹃」鐩紡涓夈�佸啘鏉戠患鍚堣繍杈撴湇鍔＄珯锛忓洓銆佸�欒溅浜�嶅洓鍧楋級 +- `docs/鎶曡祫/妯℃澘/妯℃澘_X鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls`锛堟湀2 鐪佽〃 + 鍒嗛」鐩姇璧勫畬鎴愭儏鍐� + 鍒嗗競宸炶鍒掑唴澶栭」鐩畬鎴愭儏鍐� + 绗� 4 椤碉級 + +**闃绘柇鐐癸細瀵煎叆鎶娿�屽垎缁勮銆嶄涪鎺変簡銆�** +`DataImportService` :2465 鏄庣‘璺宠繃 `^[涓�浜屼笁鍥涗簲鍏竷鍏節鍗乚+銆�.*` 鐨勮锛岃�岃繖涓ゅ紶琛ㄦ伆鎭拌闈犺繖琛屽喅瀹氶」鐩惤鍦ㄥ摢涓祫閲戞笭閬�/瑙勫垝鍐呭鍧椼�� +`docs/鎶曡祫/杈撳嚭/鏍煎紡鎺㈡祴_2026-07.tsv` 鏄剧ず婧愭枃浠堕噷杩欎簺鍒嗙粍琛屾槸瀛樺湪鐨勶紙濡� `R12 | 涓�銆佷娇鐢ㄤ氦閫氶儴杞﹁喘绋庤祫閲戝缓璁鹃」鐩甡锛夈�� + +瑕佽惤鍦板繀椤诲厛鍋� 3 姝ワ細 +1. `investment_project` 澧炲垪 `fund_channel`锛堣祫閲戞笭閬�/鍒嗙粍鏍囩锛夛紝瀹炰綋鍔犲瓧娈碉紱 +2. 瀵煎叆鏃朵笉鍐嶈烦杩囧垎缁勮锛屾敼涓鸿褰曘�屽綋鍓嶅垎缁勩�嶅苟鍐欏埌鍏跺悗鐨勯」鐩笂锛� +3. 閲嶆柊瀵煎叆 7 鏈堛��8 鏈堟暟鎹悗锛屽啀鍐欒繖涓ゅ紶琛ㄧ殑鐢熸垚鍣紙鎸夊競宸� + 鍒嗙粍鍔ㄦ�佹彃琛屻�侀噸杩炴眹鎬婚〉鍏紡锛夈�� + +> 璇存槑锛氬湪娌℃湁 `fund_channel` 涔嬪墠寮鸿鐢熸垚锛屽彧鑳芥妸鎵�鏈夐」鐩杩涙煇涓潡閲岋紝涓庢瘝鐗堝彛寰勪笉绗︼紝鏁呭厛涓嶅仛銆� + +--- + +## 鍥涖�佹暟鎹煡鐪嬮〉璋冩暣锛堝凡鏀逛唬鐮侊級 + +- `traffic-audit-web/src/views/DataView.vue`锛氭妸**鎶ヨ〃鏈�**浠庛�屾暟鎹被鍨嬨�嶅悗闈㈢Щ鍒�**鍓嶉潰**锛涙柊澧炪�屾姇璧勩�嶃�岃兘鑰椼�嶄袱涓垎缁� + 锛堟姇璧勶細鎶曡祫椤圭洰鍩虹琛� / 甯傚窞鏈堟姤椤圭洰杩涘害 / 鎶曡祫绯荤粺姣忔湀瀵煎叆椤圭洰琛紱鑳借�楋細杞﹁締鑳借�楀搴︽暟鎹� / 鑳借�楄繍鏀胯溅杈嗘暟锛夈�� +- `traffic-audit-server/.../dataimport/controller/DataViewController.java`锛氭柊澧� `investmentMonthly`銆乣investmentProject`銆� + `investmentSystem`銆乣energyVehicle`銆乣energyAuth` 浜旂被鏌ヨ涓庡垪瀹氫箟锛沗mvn -o compile` 閫氳繃銆� +- **鐘舵��**锛氫唬鐮佸凡鏀瑰苟缂栬瘧閫氳繃锛屼絾**灏氭湭閲嶅惎鍚庣**锛屾墍浠� 8090 涓婅繕鏄棫閫昏緫锛涢噸鍚悗鐢熸晥銆� + +--- + +## 浜斻�佸叾浠栨敞鎰忕偣 + +- 姹囨�诲ぇ琛ㄦ瘝鐗堬細`docs/鐢熸垚姹囨�诲ぇ琛�/2026骞�8鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx` 瀛樺湪锛涗絾 `_澶囦唤_2026骞�8鏈堚� 鍚屾湡澶囦唤姣嶇増**涓嶅瓨鍦�**锛� + 鏃ュ織浼氭墦 `WARN 姹囨�诲伐浣滅翱鏈壘鍒板悓鏈熷浠芥瘝鐗坄锛岃繖涔熸槸杩欎簺椤电 8 鏈堜笉榻愮殑涓�涓儗鏅洜绱犮�� +- 涓彛寰勬帓鍚嶇殑銆屽叏鐪� 鈮� 17 甯傚窞涔嬪拰銆嶏紙1~8 鏈堬細27524.49 vs 24481.74锛夛紝灞炰簬**鍙ｅ緞闂**锛岄渶瑕佷笟鍔＄‘璁ゅ叏鐪佸埌搴曟寜鍝釜鍙ｅ緞鍙栥�� -- Gitblit v1.9.1