From ecf2b3c4ca25709aff8aae6f5969f0595d55206f Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期三, 23 九月 2026 09:28:48 +0800 Subject: [PATCH] Merge remote-tracking branch 'gitea/main' --- docs/功能测试报告/功能测试报告_潜江投资物流月报重导_2026-09-23.md | 67 +++++++++++++++++++++++++++++++++ 1 files changed, 67 insertions(+), 0 deletions(-) diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\275\234\346\261\237\346\212\225\350\265\204\347\211\251\346\265\201\346\234\210\346\212\245\351\207\215\345\257\274_2026-09-23.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\275\234\346\261\237\346\212\225\350\265\204\347\211\251\346\265\201\346\234\210\346\212\245\351\207\215\345\257\274_2026-09-23.md" new file mode 100644 index 0000000..fef2752 --- /dev/null +++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_\346\275\234\346\261\237\346\212\225\350\265\204\347\211\251\346\265\201\346\234\210\346\212\245\351\207\215\345\257\274_2026-09-23.md" @@ -0,0 +1,67 @@ +# 鍔熻兘娴嬭瘯鎶ュ憡 鈥� 娼滄睙鐗╂祦鎶曡祫鏈堟姤 2026-06/07/08 閲嶅淇 + +> 娴嬭瘯鏃ユ湡锛�2026-09-23 +> 琚祴瀵硅薄锛氭姇璧勫競宸炲崟琛ㄥ鍏ワ紙`POST /api/import/batch`锛宍type=investmentLogistics`锛�+ 鐗╂祦绔欏満鎶曡祫鏄庣粏瀵煎嚭 +> 鑳屾櫙锛�09-22 宸蹭慨澶嶁�滄綔姹熷鍘嗗彶 sheet 閫夐敊椤电鈥濓紝浣嗕氦鎺ラ仐鐣欐槑纭姹傞噸瀵� 2026-06/07銆傚鏍稿綋鍓嶅簲鐢ㄥ疄闄呰繛鎺ュ簱鏃跺張鍙戠幇 2026-08 浠嶆槸鏃ч」鐩敊鍊笺�� + +## 涓�銆佸姛鑳借鏄庝笌鏁版嵁淇 + +鏈娌℃湁鏀逛笟鍔′唬鐮侊紝浣跨敤鐜版湁閲嶅/骞傜瓑閫昏緫淇褰撳墠搴旂敤搴� `3305/traffic_audit` 鐨勬綔姹熺墿娴� 2026-06銆�2026-07銆�2026-08 鏈堝害鏁版嵁锛� + +| 鏈熼棿 | 婧愭枃浠� | 婧愯〃褰撴湡椤电 | 婧愯〃鍏抽敭鍊硷紙H/J/K锛� | +| --- | --- | --- | --- | +| 2026-06 | `docs/鎶曡祫/杈撳叆/鐗╂祦锛堢墿娴佸洯鍖猴級/6鏈�/娼滄睙2026.06.xlsx` | `娼滄睙浼犲寲2022.3`锛岃〃鍐呮姤琛ㄦ湡 `2026.06.22` | `11947.9 / 1135 / 0` | +| 2026-07 | `docs/鎶曡祫/杈撳叆/鐗╂祦锛堢墿娴佸洯鍖猴級/7鏈�/娼滄睙2026.07.xlsx` | `娼滄睙浼犲寲2022.3`锛岃〃鍐呮姤琛ㄦ湡 `2026.07.22` | `11947.9 / 1135 / 0` | +| 2026-08 | `docs/鎶曡祫/杈撳叆/鐗╂祦锛堢墿娴佸洯鍖猴級/8鏈�/娼滄睙2026.08.xlsx` | `娼滄睙浼犲寲2022.3`锛岃〃鍐呮姤琛ㄦ湡 `2026.08.24` | `11947.9 / 1135 / 0` | + +淇鍓嶅綋鍓嶅簲鐢ㄥ簱涓変釜鏈堝潎鎸傛棫椤圭洰鈥滄綔姹熶紶鍖栧叕璺腐椤圭洰鈥濓紝2026-08 涓� `5173 / 12000 / 5173 / 1440`锛涗慨姝ｅ悗涓変釜鏈堝潎鎸傗�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鏈堝害鍊间负 `start_cum=11947.9 / year_plan=0 / year_cum=1135 / month_done=0 / progress_stage=鍦ㄥ缓`銆� + +## 浜屻�佹祴璇曠幆澧� + +- 鍚庣锛歚start-dev.ps1` 鍚姩锛�8090 鏃ュ織鍑虹幇 `Started TrafficAuditApplication`銆� +- 鏁版嵁搴擄細`jdbc:mysql://localhost:3305/traffic_audit`锛宍root/root`銆� +- 鐧诲綍锛歚admin/123456`锛岄獙璇佺爜閰嶇疆 `required=false`銆� +- 瀵煎叆鏂瑰紡锛氬彧涓婁紶瀵瑰簲鏈堜唤鐨勬綔姹熷崟鏂囦欢锛岄伩鍏嶅叏鐩綍瀵煎叆鏀瑰姩鍏朵粬甯傚窞銆� +- 瀵煎嚭楠岃瘉锛歚GET /api/report/export/investLogisticsDetail?period=2026-08&mode=month`銆� + +## 涓夈�佹祴璇曠敤渚嬩笌缁撴灉 + +| # | 鐢ㄤ緥 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +| --- | --- | --- | --- | --- | --- | +| 1 | 2026-06 姝ｅ悜閲嶅 | `娼滄睙2026.06.xlsx` | 閫夊綋鏈熼〉锛屾垚鍔� 1 鏉� | 鎺ュ彛 `success=1`锛涘簱鍐呴」鐩�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鍊� `11947.9 / 0 / 1135 / 0` | 鉁� | +| 2 | 2026-07 姝ｅ悜閲嶅 | `娼滄睙2026.07.xlsx` | 閫夊綋鏈熼〉锛屾垚鍔� 1 鏉� | 鎺ュ彛 `success=1`锛涘簱鍐呴」鐩�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鍊� `11947.9 / 0 / 1135 / 0` | 鉁� | +| 3 | 2026-08 涓�鑷存�т慨姝� | `娼滄睙2026.08.xlsx` | 褰撳墠搴旂敤搴撲笉鍐嶄繚鐣欐棫椤圭洰閿欏�� | 鎺ュ彛 `success=1`锛涘簱鍐呮敼涓衡�滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝鍊� `11947.9 / 0 / 1135 / 0` | 鉁� | +| 4 | 璐熷悜-鍘嗗彶椤电涓嶆硠婕� | 涓変唤鏂囦欢鍧囧惈 2018/2019 绛夊巻鍙� sheet | 涓嶅緱瀵煎叆鈥滄綔姹熶紶鍖栧叕璺腐椤圭洰鈥濈殑鍘嗗彶琛� | 涓変釜鏈堝簱鍐呭潎鏃犺椤圭洰鏈堝害璁板綍锛涢�変腑椤靛潎浠ヨ〃鍐� `2026.xx.xx` 鎶ヨ〃鏈熷懡涓� | 鉁� | +| 5 | 鍏ュ簱鎶芥煡 | 涓変唤婧愯〃褰撳墠椤� H/J/K | 搴撳唴閫愰」涓�鑷� | 6/7/8 鏈堝潎涓� `11947.9 / 1135 / 0`锛岄」鐩悕銆佸缓璁鹃樁娈典竴鑷� | 鉁� | +| 6 | 骞傜瓑-閲嶅閲嶅 | 涓変唤鏂囦欢鍚勫啀瀵煎叆涓�娆� | 涓嶆柊澧為噸澶嶆湀搴﹁鎴栭噸澶嶉」鐩� | 6/7/8 鏈堝悇淇濇寔 `monthly_rows=1`銆乣projects=1`锛涙綔姹熼噸鍚嶉」鐩暟 `0` | 鉁� | +| 7 | 绔埌绔鍑� | 2026-08 鐗╂祦绔欏満鎶曡祫鏄庣粏 | 娼滄睙琛屽彇鏂板�硷紝涓嶇粨杞棫鍊� | 杈撳嚭 `_tmp/qa_qianjiang_20260923/鐢熸垚_鐗╂祦绔欏満鎶曡祫鏄庣粏_2026-08.xls`锛宍鍒嗛」鐩姇璧勫畬鎴愭儏鍐礰 绗� 180 琛屼负鈥滀腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯鈥濓紝閲戦 `11947.9 / 1135 / 0` | 鉁� | + +## 鍥涖�佸叧閿彂鐜帮細楠岃瘉搴撲笌搴旂敤瀹為檯杩炴帴搴撲笉涓�鑷� + +- 褰撳墠杩愯閰嶇疆 `traffic-audit-server/src/main/resources/application.yml` 鎸囧悜 `localhost:3305/traffic_audit`銆� +- 09-22銆婂姛鑳芥祴璇曟姤鍛奯鎶曡祫鏄庣粏琛ㄥ彇鏁颁慨澶嶃�嬭褰曠殑楠岃瘉鐜鏄� `localhost:3308/traffic_audit`銆� +- 鏈鐩存帴鏌ヨ褰撳墠搴旂敤搴� `3305` 鏃讹紝娼滄睙 2026-08 浠嶆槸鏃ч」鐩� `5173/12000/5173/1440`锛岃鏄� 09-22 鐨� 08 鏈堜慨姝ｆ病鏈夊弽鏄犲埌鏈瀹為檯杩愯搴撱�俙3308` 褰撳墠鏃犳硶杩炴帴锛圚TTP/MySQL 杩炴帴琚嫆缁濓級锛屽洜姝や笉鑳界户缁互璇ュ簱浣滀负浜や粯楠屾敹渚濇嵁銆� +- 澶勭悊锛氭湰娆″湪鍚屼竴鍚庣浼氳瘽涓噸瀵� 6/7/8 涓変釜鏈堬紝骞跺湪 `3305` 涓婂畬鎴愬簱鍐呮娊鏌ュ拰 2026-08 绔埌绔鍑洪獙璇併�� + +## 浜斻�佹暟鎹彉鏇磋鏄� + +| 琛� | 鏈熼棿 | 淇鍓� | 淇鍚� | +| --- | --- | --- | --- | +| `investment_monthly` | 2026-06 | 娼滄睙浼犲寲鍏矾娓」鐩� `3685/12000/3685/1520` | 涓浗铏捐胺鍐烽摼浠撳偍鐗╂祦鍥� `11947.9/0/1135/0` | +| `investment_monthly` | 2026-07 | 娼滄睙浼犲寲鍏矾娓」鐩� `3733/12000/3733/48` | 涓浗铏捐胺鍐烽摼浠撳偍鐗╂祦鍥� `11947.9/0/1135/0` | +| `investment_monthly` | 2026-08 | 娼滄睙浼犲寲鍏矾娓」鐩� `5173/12000/5173/1440` | 涓浗铏捐胺鍐烽摼浠撳偍鐗╂祦鍥� `11947.9/0/1135/0` | + +- 鏈垹闄や换浣� `investment_project` 涓绘。锛涙棫椤圭洰涓绘。 `id=108` 淇濈暀锛屼絾鍏� 6/7/8 鏈堟棫鏈堝害璁板綍宸叉寜甯傚窞+绫诲埆+鏈熼棿娓呯悊銆� +- 鏂板椤圭洰涓绘。 `id=276`锛岀被鍒� `鐗╂祦鍥尯`锛屽悗缁笁涓湀澶嶇敤鍚屼竴鏉′富妗ｃ�� +- 鏈敼鍔ㄥ叾浠栧競宸炪�佸叾浠栨湡闂淬�佸叾浠栨姇璧勭被鍒�� + +## 鍏�侀仐鐣欓棶棰樹笌涓嬩竴姝� + +1. 鎶曡祫鏄庣粏琛� L/D/E/F 鍒楄鐩栧彛寰勪粛闇�銆婂缓璁鹃樁娈靛綊涓�琛ㄣ�嬪悗纭銆� +2. 姝︽眽鐗╂祦 8 鏈堛�侀粍鍐堝杩� 8 鏈堟簮鏁版嵁浠嶆湭琛ラ綈銆� +3. P0 椤逛笉鍙橈細浜垮厓鎶曡祫椤圭洰鎸� Q7 杩藉垪銆佸鍑哄墠鍩烘暟浣撴銆�2026-09 姣嶇増銆� +4. 鍚庣画鍐欐祴璇�/浜ゆ帴鏂囨。鏃讹紝蹇呴』鍏堣鍙栧綋鍓� `application.yml` 鎴栬繍琛屼腑杩涚▼閰嶇疆锛屼笉鑳芥部鐢ㄤ笂涓�杞姤鍛婄殑鏁版嵁搴撶鍙ｄ綔涓洪獙鏀剁幆澧冦�� + +## 涓冦�佺粨璁� + +娼滄睙鐗╂祦鎶曡祫 2026-06銆�2026-07 鍘嗗彶閿欏�煎凡淇锛涘悓鏃跺彂鐜板苟淇浜嗗綋鍓嶅簲鐢ㄥ簱閬楁紡鐨� 2026-08 閿欏�笺�備笁涓湀閲嶅鍧囨垚鍔燂紝鍘嗗彶椤电鏈硠婕忥紝閲嶅瀵煎叆淇濇寔骞傜瓑锛�2026-08 瀵煎嚭绔埌绔彇鍊兼纭�� -- Gitblit v1.9.1