From 73a05513ffaac43e440734aa8fffeea953563741 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期四, 17 九月 2026 14:14:44 +0800
Subject: [PATCH] chore(投资)：入库用户整理后的输入/模板/输出文件 + 回填口径确认（用户 2026-09-17 答复）
---
docs/打包部署说明.md | 289 ++++++++++++++++++++++++++++++++++-----------------------
1 files changed, 173 insertions(+), 116 deletions(-)
diff --git "a/docs/\346\211\223\345\214\205\351\203\250\347\275\262\350\257\264\346\230\216.md" "b/docs/\346\211\223\345\214\205\351\203\250\347\275\262\350\257\264\346\230\216.md"
index 5ec47bb..5d98f70 100644
--- "a/docs/\346\211\223\345\214\205\351\203\250\347\275\262\350\257\264\346\230\216.md"
+++ "b/docs/\346\211\223\345\214\205\351\203\250\347\275\262\350\257\264\346\230\216.md"
@@ -1,6 +1,6 @@
# 浜ら�氱粺璁℃姤琛ㄥ鏍哥郴缁� 鈥� 鎵撳寘涓庨儴缃茶鏄�
-> 閫傜敤锛氬悎骞跺悗 main 鍒嗘敮锛�2026-08-27 璧凤級銆傚悗绔� Spring Boot 2.7锛圝ava 8锛夛紝鍓嶇 Vue 2 + Element UI銆�
+> 閫傜敤锛歮ain 鍒嗘敮锛堟渶鏂版洿鏂� 2026-09-13锛夈�傚悗绔� Spring Boot 2.7锛圝ava 8锛夛紝鍓嶇 Vue 2 + Element UI銆�
> 鏈枃妗ｉ潰鍚戝紑鍙戜笌閮ㄧ讲鍚屼簨锛屽懡浠ゅ潎鍦� Windows 涓嬮獙璇併��
## 涓�銆侀」鐩粨鏋�
@@ -9,156 +9,213 @@
|------|------|
| `traffic-audit-server` | 鍚庣锛圫pring Boot锛孞ava 8锛岀鍙� 8090锛屾帴鍙ｅ叏閮ㄥ湪 `/api/**`锛� |
| `traffic-audit-web` | 鍓嶇锛圴ue 2 + Element UI锛屽紑鍙戠鍙� 8080锛宍/api` 浠ｇ悊鍒� 8090锛� |
-| `docs` | 杩愯鏁版嵁鐩綍锛堟姤琛� Word/Excel 妯℃澘 + 鐩綍瀵煎叆鏁版嵁锛夛紝**鍙戝竷蹇呴』甯︿笂** |
-| `docs/init.sql` | 鏁版嵁搴撳垵濮嬪寲鑴氭湰锛堝缓搴撳缓琛� + 鍒濆璐﹀彿锛� |
+| `docs` | 杩愯鏁版嵁鐩綍锛堟姤琛ㄦā鏉裤�佹眹鎬诲ぇ琛ㄦ瘝鐗堢瓑锛夛紝**鍙戝竷蹇呴』甯︿笂** |
+| `package-deploy.py` | 涓�閿墦鍖呰剼鏈紙鍓嶇鏋勫缓 鈫� 鍐呭祵杩� jar 鈫� 缁勮閮ㄧ讲鍖� 鈫� 鎵� zip锛� |
## 浜屻�佺幆澧冭姹�
-| 缁勪欢 | 鐗堟湰 | 鐢ㄩ�� |
+| 缁勪欢 | 鐗堟湰 | 璇存槑 |
|------|------|------|
-| JDK | 1.8 | 鍚庣缂栬瘧涓庤繍琛� |
-| Maven | 3.x | 鍚庣鎵撳寘 |
-| Node.js | 14+ | 鍓嶇鎵撳寘锛坴ue-cli 4.5锛� |
-| MySQL | 8.0 | 鏁版嵁搴擄紙搴撳悕 `traffic_audit`锛� |
+| JDK | 1.8 | 閮ㄧ讲鏈哄繀椤伙紱鍚庣缂栬瘧/杩愯 |
+| MySQL | **8.0** | 閮ㄧ讲鏈哄繀椤伙紝搴撳悕 `traffic_audit`锛涚幇缃�/寮�鍙戞満涓� 8.0.29锛岃〃鎺掑簭瑙勫垯鏄� `utf8mb4_0900_ai_ci`锛�**鐩爣鏈鸿 5.7 浼氬鍏ュけ璐�** |
+| Maven 3.x / Node.js 14+ | 鈥� | **鍙湁銆屽湪閮ㄧ讲鏈轰笂鎵撳寘銆嶆墠闇�瑕�**锛涚敤涓�閿剼鏈骇鍑虹殑鍖呴儴缃插垯涓嶉渶瑕� |
+| Redis | **涓嶉渶瑕�** | 浠ｇ爜鏈娇鐢� Redis锛堟棫璇存槑涓殑 Redis 閰嶇疆鏄仐鐣欓」锛屽彲蹇界暐锛� |
+| nginx / IIS | **涓嶉渶瑕�** | 鍓嶇宸插唴宓岃繘 jar锛岃闂� 8090 鍗冲彲锛涜鍓嶅悗绔垎绂绘椂鎵嶆槸澶囬�� |
-## 涓夈�佹暟鎹簱鍒濆鍖�
-
-鍏堟墽琛屽缓搴撳缓琛ㄨ剼鏈紝鍐嶆寜闇�瀵煎叆鍩庡競瀹㈣繍鏁版嵁锛�
-
-```bash
-mysql --default-character-set=utf8mb4 -h <涓绘満> -P 3306 -u root -p < docs/init.sql
-mysql --default-character-set=utf8mb4 -h <涓绘満> -P 3306 -u root -p traffic_audit < docs/sql_city_bus.sql
-mysql --default-character-set=utf8mb4 -h <涓绘満> -P 3306 -u root -p traffic_audit < docs/sql_city_taxi.sql
-```
-
-- `init.sql` 浼氶噸寤� `traffic_audit` 搴撳苟棰勭疆鍒濆璐﹀彿锛歚admin / admin123`锛堢敓浜х幆澧冭鐧诲綍鍚庢敼瀵嗙爜锛�
-- `sql_city_bus.sql`銆乣sql_city_taxi.sql` 涓哄煄甯傚杩愶紙鍏氦/鍑虹锛夌ず渚嬫暟鎹紝鎸夐渶瀵煎叆
-
-## 鍥涖�佹墦鍖�
-
-### 4.1 鍚庣锛堥」鐩牴鐩綍鎵ц锛�
+## 涓夈�佹墦鍖咃紙鍦ㄥ紑鍙戞満涓婃墽琛岋紝鎺ㄨ崘涓�閿剼鏈級
```powershell
+cd D:\鏂囨。\ChatGPT\traffic-audit
+python package-deploy.py # 鍏ㄦ祦绋嬶細鍓嶇鏋勫缓 + 鍚庣鎵撳寘 + 缁勮 + 鍘嬬缉
+python package-deploy.py --no-build # 璺宠繃鍓嶇鏋勫缓锛坉ist 宸叉槸鏈�鏂版椂鏇村揩锛�
+```
+
+鑴氭湰鍋氫簡浠�涔堬細
+
+1. `traffic-audit-web` 涓� `npm run build` 鈫� `dist`锛�
+2. 鎶� `dist` 澶嶅埗杩� `traffic-audit-server/src/main/resources/static`锛屼娇 **jar 鑷甫鍓嶇**锛屽啀 `mvn clean package -DskipTests`锛堣窇瀹岃嚜鍔ㄦ竻绌� static锛屼繚鎸佷粨搴撳共鍑�锛夛紱
+3. 缁勮 `deploy/traffic-audit-deploy-YYYYMMDD/`锛�
+4. 鍘嬬缉涓� `traffic-audit-deploy-YYYYMMDD.zip`锛堢害 70 MB锛夈��
+
+鎵嬪伐绛変环鍛戒护锛堜笉鎯崇敤鑴氭湰鏃讹級锛�
+
+```powershell
+cd traffic-audit-web ; npm run build ; cd ..
+robocopy traffic-audit-web\dist traffic-audit-server\src\main\resources\static /E
cmd /c "mvn -q clean package -DskipTests -f traffic-audit-server\pom.xml"
```
-浜х墿锛歚traffic-audit-server\target\traffic-audit-server-1.0.0-SNAPSHOT.jar`锛堝彲鎵ц fat jar锛岀害 57MB锛夈��
+> 娉ㄦ剰锛氭墜宸ユ柟寮忚窇瀹岃寰楀垹鎺� `traffic-audit-server/src/main/resources/static` 涓嬬殑鍐呭锛屽惁鍒欎細姹℃煋婧愮爜鐩綍銆�
-### 4.2 鍓嶇锛坄traffic-audit-web` 鐩綍鎵ц锛�
-
-```powershell
-cd traffic-audit-web
-npm run build
-```
-
-浜х墿锛歚traffic-audit-web\dist\`锛坄index.html` + `css/js/fonts`锛岀函闈欐�佹枃浠讹級銆�
-
-## 浜斻�侀儴缃茬洰褰曠粨鏋勶紙鎺ㄨ崘锛�
+## 鍥涖�侀儴缃插寘鍐呭
```
-deploy\
-鈹溾攢 app.jar # 鍚庣 jar锛堝彲鏀瑰悕锛�
-鈹溾攢 docs\ # 蹇呴』锛氭ā鏉夸笌鐩綍瀵煎叆鏁版嵁鐩綍
-鈹� 鈹溾攢 鍩庡競瀹㈣繍\
-鈹� 鈹溾攢 鍏矾鏃呭\
-鈹� 鈹溾攢 璐ц繍\
-鈹� 鈹溾攢 鑳借�梊
-鈹� 鈹溾攢 鎶曡祫\
-鈹� 鈹� 鈹斺攢 妯℃澘\
-鈹� 鈹斺攢 (6鏈圽 7鏈圽 绛夊鍏ユ暟鎹洰褰曪紝鎸夐渶)
-鈹斺攢 web\ # 鍓嶇 dist 鐨勫唴瀹癸紙鐢卞悗绔� 8090 鎵樼锛�
- 鈹溾攢 index.html
- 鈹溾攢 css\ js\ fonts\
+traffic-audit-deploy-YYYYMMDD/
+鈹溾攢 backend/
+鈹� 鈹溾攢 traffic-audit-server-1.0.0-SNAPSHOT.jar 鍚庣 + 鍐呭祵鍓嶇锛堢害 55 MB锛�
+鈹� 鈹溾攢 docs/ 妯℃澘涓庤繍琛屾暟鎹紙蹇呴渶锛屽嬁鍒狅級
+鈹� 鈹溾攢 application.yml 澶栭儴閰嶇疆锛堟敼杩欓噷鍗冲彲锛屾棤闇�閲嶆墦鍖咃級
+鈹� 鈹斺攢 start-backend.cmd / start-backend.sh 鍚姩鑴氭湰
+鈹溾攢 frontend/
+鈹� 鈹溾攢 dist/ 鍓嶇浜х墿锛堜粎 nginx 鏂规闇�瑕侊級
+鈹� 鈹斺攢 nginx.conf.example nginx 閰嶇疆绀轰緥
+鈹溾攢 db/
+鈹� 鈹溾攢 init.sql 寤哄簱寤鸿〃 + 棰勭疆璐﹀彿锛堝繀椤绘墽琛岋級
+鈹� 鈹溾攢 sql_city_bus.sql 鍩庡競瀹㈣繍-鍏氦鏈堝害琛紙蹇呴』鎵ц锛�
+鈹� 鈹溾攢 sql_city_taxi.sql 鍩庡競瀹㈣繍-鍑虹鏈堝害琛�/鎺堟潈琛紙蹇呴』鎵ц锛�
+鈹� 鈹斺攢 sql_wyc.sql 缃戠害杞﹀叏鐪佹�婚噺/璁㈠崟鍒嗗競宸炶〃锛堝繀椤绘墽琛岋級
+鈹斺攢 README-閮ㄧ讲璇存槑.txt
```
-鍏抽敭鐐癸細
+## 浜斻�佺洰鏍囨満鍣ㄩ儴缃叉楠�
-- **`docs` 蹇呴』鏀惧湪 jar 鍚岀骇**銆傚悗绔繍琛屾椂鎸夊惎鍔ㄧ洰褰曞悜涓婃煡鎵� `docs`锛堟姤琛ㄥ鍑虹殑 Word 妯℃澘銆佸鍏ラ〉銆屼笅杞芥ā鏉裤�嶃�佺洰褰曞鍏ユ暟鎹兘浠庤繖閲岃锛夛紝鎵句笉鍒颁細鎶ャ�屾湭鎵惧埌鏁版嵁鐩綍 docs銆嶆垨銆屾湭鎵惧埌妯℃澘鏂囦欢 xxx銆嶃��
-- 棣栨閮ㄧ讲鐩存帴鎶婇」鐩噷鐨勬暣涓� `docs` 鎷疯繃鍘绘渶绋冲Ε锛涘悗缁彲绮剧畝锛堝彧鐣欐ā鏉垮瓙鐩綍锛夛紝璇﹁銆屽父瑙侀棶棰樸�嶃��
-- `application.yml` 鎵撳寘鍦� jar 鍐咃紝宸插唴缃墠绔潤鎬佹墭绠★紙`file:./web/`锛夛紱閮ㄧ讲鏈洪渶瑕佹敼閰嶇疆鏃讹紝鍙湪 jar 鍚岀骇鏀句竴涓缃� `application.yml`锛堝缃紭鍏堢骇楂樹簬鍐呯疆锛屾敞鎰忛渶鍖呭惈瀹屾暣閰嶇疆锛夛紝鎴栨敼瀹屽啀鎵撳寘銆�
-- 鍚姩鍚庢祻瑙堝櫒鐩存帴璁块棶 `http://<鏈嶅姟鍣�>:8090`锛屾棤闇�棰濆 Web 鏈嶅姟鍣ㄣ��
+### 5.1 鍑嗗鏁版嵁搴擄紙涓ゆ潯璺嚎浜岄�変竴锛�**涓嶈娣风潃鍋�**锛�
-## 鍏�佸叧閿厤缃紙application.yml锛�
+#### 璺嚎 A锛氬叏鏂扮┖搴擄紙瑕佽窇 4 涓剼鏈級
+
+`init.sql` 鑷甫 `CREATE DATABASE` 涓� `USE traffic_audit`锛屽彲鐙珛鎵ц锛涘彟澶� 3 涓剼鏈病鏈� `USE` 璇彞锛屽繀椤荤敤 `-D traffic_audit`锛堟垨 `mysql ... traffic_audit < 鏂囦欢`锛夋寚瀹氬簱锛�
+
+```bash
+cd db
+mysql --default-character-set=utf8mb4 -u root -p < init.sql # 寤哄簱 + 24 寮犲熀纭�琛� + 棰勭疆璐﹀彿
+mysql --default-character-set=utf8mb4 -u root -p -D traffic_audit < sql_city_bus.sql
+mysql --default-character-set=utf8mb4 -u root -p -D traffic_audit < sql_city_taxi.sql
+mysql --default-character-set=utf8mb4 -u root -p -D traffic_audit < sql_wyc.sql
+```
+
+> 鈿狅笍 **`init.sql` 鏄牬鍧忔�х殑**锛氶噷闈㈢殑鍩虹琛ㄩ兘甯� `DROP TABLE IF EXISTS`銆�**宸叉湁鏁版嵁鐨勫簱涓婂崈涓囦笉瑕佸啀璺� init.sql**锛屽惁鍒欒〃鏁版嵁浼氳娓呯┖閲嶅缓銆�
+> 4 涓剼鏈叡瑕嗙洊 29 寮犺〃锛坕nit.sql 24 寮� + 鍩庡競瀹㈣繍 3 寮� + 缃戠害杞� 2 寮狅級銆�
+
+#### 璺嚎 B锛氭妸鐜扮綉/寮�鍙戞満鐨勬暟鎹暣濂楁惉杩囧幓锛堟帹鑽愶紝涓嶇敤璺戣剼鏈級
+
+鍏堢‘璁や袱绔� MySQL 閮芥槸 **8.0**锛堟湰搴撹〃鎺掑簭瑙勫垯涓� `utf8mb4_0900_ai_ci`锛�5.7 涓嶈瘑鍒細瀵艰嚧瀵煎叆澶辫触锛夛紝骞朵笖**鐢ㄤ笌鏈嶅姟绔悓鐗堟湰鐨� mysqldump**锛堜笉瑕佺敤 5.7 鐨勫鎴风鍘诲 8.0 鏈嶅姟绔級銆�
+
+鍦ㄦ簮鏈哄櫒锛堟湰鏈� MySQL 绔彛绀轰緥 3308锛屾寜瀹為檯鏀癸級锛�
+
+```bash
+"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" ^
+ --host=127.0.0.1 --port=3308 --user=root --password=浣犵殑瀵嗙爜 ^
+ --default-character-set=utf8mb4 --single-transaction --routines --triggers --events ^
+ --databases traffic_audit > traffic_audit_full_YYYYMMDD.sql
+```
+
+鍦ㄧ洰鏍囨満鍣細
+
+```bash
+mysql --default-character-set=utf8mb4 -u root -p < traffic_audit_full_YYYYMMDD.sql
+```
+
+- `--databases` 浼氭妸 `CREATE DATABASE` + `USE` 涓�璧峰啓杩涘浠斤紝鎵�浠ョ洰鏍囨満鍣�**涓嶇敤鍏堝缓搴撱�佷篃涓嶇敤璺戦偅 4 涓剼鏈�**銆�
+- 澶囦唤閲屽寘鍚� `sys_user`锛岃处鍙峰瘑鐮佷笌婧愭満鍣ㄥ畬鍏ㄤ竴鑷达紙鏈満鏄� `admin / 123456`锛夛紝涓嶄細琚噸缃垚 `admin/admin123`銆�
+- 鈿狅笍 澶囦唤閲屾瘡寮犺〃閮藉甫 `DROP TABLE IF EXISTS`锛堝叡 29 寮狅級锛�**鐩爣搴撹鏄凡鏈夋暟鎹紝浼氳鐩存帴瑕嗙洊**銆傝杩樺師鍒扮┖搴擄紝鎴栧厛鑷繁澶囦唤鐩爣搴撱��
+- 鏈宸茬敓鎴愬苟**楠岃瘉杩�**澶囦唤锛歚traffic_audit_full_20260913.sql`锛�45.5 MB锛�8.0.29 瀹㈡埛绔鍑猴級銆�
+ 楠岃瘉鏂瑰紡锛氭妸澶囦唤搴撳悕鏀规垚涓存椂搴撳鍏ワ紝閫愯〃姣斿 `SHOW CREATE TABLE`锛堣〃缁撴瀯锛変笌 `COUNT(*)`锛堣鏁帮級鈥斺��**29 寮犺〃缁撴瀯涓庤鏁板潎 0 宸紓**锛屾娊鏌� `wyc_order_monthly` 2026-08 鏁版嵁涓�鑷达紝楠岃瘉鍚庡凡鍒犻櫎涓存椂搴撱��
+
+#### 璺嚎 B2锛氱敤 Navicat 鐨勩�屽浠� / 杩樺師澶囦唤銆嶏紙.nb3锛屾渶璐磋繎鏃ュ父涔犳儻锛�
+
+`.nb3` 鏄� Navicat 绉佹湁澶囦唤鏍煎紡锛坱ar 瀹瑰櫒锛氭瘡寮犺〃涓�浠� meta.json + gz 鍘嬬缉鐨勬暟鎹垎鐗� + SHA1 鏍￠獙 + 鎬� meta.json锛夛紝
+鍙兘鐢� Navicat 鑷繁鐢熸垚銆佷篃鍙兘鍦� Navicat 閲岀敤銆岃繕鍘熷浠姐�嶈繕鍘熲�斺��**鐢� `.sql` 鐐广�岃繕鍘熷浠姐�嶄竴瀹氬け璐�**锛堥偅涓叆鍙ｅ彧璁� .nb3锛夈��
+
+鍦ㄦ簮鏈哄櫒锛�30 绉掞級锛�
+
+1. Navicat 鈫� 杩炴帴 `mysql80` 鈫� 閫変腑 `traffic_audit` 鈫� 鍙抽敭 鈫掋�屽浠解�︺�嶁啋 璧蜂釜鍚嶅瓧 鈫� 纭畾锛岀瓑瀹冭窇瀹岋紱
+2. 鐢熸垚鐨勫浠芥枃浠跺湪 Navicat 鐨� profile 鐩綍锛歚D:\鏂囨。\Navicat\MySQL\Servers\mysql80\traffic_audit\<鏃堕棿鎴�>.nb3`
+ 锛堟湰鏈� 8/27 閭ｄ唤灏卞湪杩欓噷锛屼絾瀹�**宸茶繃鏈�**锛氬彧鏈� 27 寮犺〃銆佺己缃戠害杞︿袱寮犺〃銆佹暟鎹槸 8/27 鐨勶紝涓嶈鐢級銆�
+
+鍦ㄧ洰鏍囨満鍣細
+
+3. 鍏堝湪 Navicat 閲屽缓涓�涓繛鍒版湰鏈� MySQL 8.0 鐨勮繛鎺ワ紙**杩炴帴鍚嶅缓璁笌婧愭満鍣ㄤ竴鑷达紝姣斿 `mysql80`**锛夛紝骞舵柊寤虹┖搴� `traffic_audit`锛堝瓧绗﹂泦 utf8mb4锛夛紱
+4. 鎶� `.nb3` 鏀惧埌鐩爣鏈哄櫒鐨勫搴旂洰褰� `<Navicat profile>\MySQL\Servers\<杩炴帴鍚�>\traffic_audit\`锛堟病鏈夊氨鐓х潃寤虹洰褰曪級锛�
+5. 鍙抽敭璇ュ簱 鈫掋�岃繕鍘熷浠姐�嶁啋 鍦ㄩ�夋嫨鍒楄〃閲屽嬀閫夎繖浠藉浠� 鈫� 寮�濮嬶紙鍒楄〃閲岀湅涓嶅埌灏遍噸鍚竴娆� Navicat锛夈��
+
+> 涓夌鏂瑰紡锛堣矾绾� A 绌哄簱 4 鑴氭湰 / 璺嚎 B 鍛戒护琛岃繕鍘� .sql / 璺嚎 B2 Navicat .nb3锛�**浠婚�夊叾涓�**鍗冲彲锛�
+> 浣�**涓嶈鍙犲姞**锛氳繕鍘熷畬澶囦唤鍚庡啀璺� `init.sql` 浼氭妸鏁版嵁娓呯┖閲嶅缓銆�
+
+> 娉ㄦ剰锛歚docs/` 鐩綍锛堟姤琛ㄦā鏉裤�佹眹鎬诲ぇ琛ㄦ瘝鐗堬級**涓庢暟鎹簱鏃犲叧锛屾棤璁哄摢鏉¤矾绾块兘蹇呴』涓�骞舵嫹璐�**銆�
+
+### 5.2 鏀归厤缃� `backend/application.yml`
| 閰嶇疆椤� | 璇存槑 |
|--------|------|
-| `spring.datasource.url/username/password` | 鏁版嵁搴撹繛鎺ワ紙妯℃澘榛樿 `localhost:3305/root/root`锛岄儴缃叉満**蹇呴』鏀�**锛涚敓浜у缓璁敤鐜鍙橀噺 `MYSQL_PASSWORD` 娉ㄥ叆锛� |
-| `deepseek.api-key` | AI 鍒嗘瀽鎺ュ彛瀵嗛挜锛堢幆澧冨彉閲� `DEEPSEEK_API_KEY`锛屼笉浣跨敤 AI 鍒嗘瀽鍙暀绌猴級 |
-| `jwt.secret` | 鐧诲綍浠ょ墝瀵嗛挜锛堢敓浜у繀椤绘敼锛岀幆澧冨彉閲� `JWT_SECRET`锛� |
-| `docs.template-root` | 瀵煎叆妯℃澘涓嬭浇鏍圭洰褰曪紙榛樿 `docs`锛� |
-| `city-passenger.template-dir` | 鍩庡競瀹㈣繍鎶ヨ〃妯℃澘鐩綍锛堥粯璁� `docs/鍩庡競瀹㈣繍`锛� |
-| `passenger.template-dir` | 鍏矾鏃呭鎶ヨ〃妯℃澘鐩綍锛堥粯璁� `docs/鍏矾鏃呭`锛� |
-| `freight.template-dir` | 璐ц繍鎶ヨ〃妯℃澘鐩綍锛堥粯璁� `docs/璐ц繍`锛� |
-| `energy.template-dir` | 鑳借�楁姤琛ㄦā鏉跨洰褰曪紙榛樿 `docs/鑳借�梎锛� |
-| `investment.template-dir` | 鎶曡祫鎶ヨ〃妯℃澘鐩綍锛堥粯璁� `docs/鎶曡祫/妯℃澘`锛� |
+| `spring.datasource.url` | 鏁版嵁搴撳湴鍧�锛堝嚭鍘傚�� `127.0.0.1:3306/traffic_audit`锛屾寜瀹為檯鏀癸級 |
+| `spring.datasource.username/password` | 鏁版嵁搴撹处鍙峰瘑鐮侊紙**蹇呮敼**锛� |
+| `jwt.secret` | 鐧诲綍浠ょ墝瀵嗛挜锛�**蹇呴』鏄� Base64 鍚堟硶瀛楃涓旈暱搴︽槸 4 鐨勫�嶆暟**锛堝嚭鍘傚�兼槸涓�涓� 32 浣嶅崄鍏繘鍒讹級锛涘～涓枃鎴栭潪娉曞瓧绗︿細瀵艰嚧鐧诲綍 500锛堢▼搴忓凡鍋氬厹搴曞苟鎵� WARN锛屼絾浠嶅缓璁～瑙勮寖鍊硷級 |
+| `deepseek.api-key` | AI 鍒嗘瀽鐢紝涓嶇敤鍙暀绌� |
+| `server.port` | 榛樿 8090 |
-> 娉ㄦ剰锛氫粨搴撳彧鎻愪氦鍗犱綅妯℃澘 `application.yml.example`锛岀湡瀹� `application.yml` 涓嶅叆搴撱��
+> 澶栫疆 `application.yml` 涓� jar 鍚岀骇鍗崇敓鏁堬紙浼樺厛绾ч珮浜� jar 鍐呯疆閰嶇疆锛夛紝鏀瑰畬涓嶇敤閲嶆柊鎵撳寘銆�
-## 涓冦�佸惎鍔ㄥ悗绔�
+### 5.3 鍚姩锛堝繀椤诲湪 `backend` 鐩綍涓嬶級
```powershell
-cd deploy
-java -jar app.jar
+# Windows锛氬弻鍑� start-backend.cmd锛涙垨
+cd backend ; java -jar traffic-audit-server-1.0.0-SNAPSHOT.jar
```
-- 鎴愬姛鏍囧織锛氭棩蹇楀嚭鐜� `Started TrafficAuditApplication` 鍜� `Tomcat started on port(s): 8090`銆�
-- 鍦� `deploy` 鐩綍涓嬪惎鍔ㄥ嵆鍙懡涓悓绾х殑 `docs`銆�
-
-## 鍏�佸墠绔儴缃诧紙鎺ㄨ崘锛歋pring Boot 鐩存帴鎵樼锛屾棤闇� IIS/nginx锛�
-
-- 鎶婂墠绔瀯寤轰骇鐗� `dist` 鐨勫唴瀹规斁鍒� jar 鍚岀骇鐩綍 `web\`锛堝嵆 `web\index.html`銆乣web\js\`銆乣web\css\`銆乣web\fonts\`锛夈��
-- 鍚庣宸插唴缃細`spring.web.resources.static-locations: file:./web/`锛堥潤鎬佹墭绠★級+ 瀹夊叏閰嶇疆鏀捐闈欐�佽祫婧愶紝鍚姩鍚庣洿鎺ヨ闂� `http://<鏈嶅姟鍣�>:8090` 鍗冲彲锛岄〉闈笌 `/api` 鍚屾簮锛�**涓嶉渶瑕� IIS/nginx 鍙嶄唬**銆�
-- 鍓嶇璺敱涓� hash 妯″紡锛屽埛鏂�/鐩磋揪鏃� 404 闂銆�
-
-### 澶囬�夛細nginx 鎵樼 + /api 鍙嶄唬锛堝闇�鍓嶅悗绔垎绂伙級
-
-```nginx
-server {
- listen 80;
- server_name _;
- root D:/deploy/web; # 鍓嶇 dist 鐩綍
- index index.html;
-
- location / {
- try_files $uri $uri/ /index.html;
- }
-
- location /api {
- proxy_pass http://127.0.0.1:8090;
- proxy_set_header Host $host;
- proxy_set_header X-Real-IP $remote_addr;
- proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
- }
-
- client_max_body_size 100m; # 涓婁紶 Excel 闇�瑕侊紝涓庡悗绔� multipart 100MB 瀵归綈
-}
+```bash
+# Linux
+cd backend && sh start-backend.sh
```
-> 鑻ュ墠绔敱 IIS 鎵樼锛岄渶瀹夎 URL Rewrite 2.0 + ARR 3.0 骞跺惎鐢� proxy锛岀珯鐐规牴鐩綍鏀� `docs/iis-web.config.example`锛堥噸鍛藉悕 web.config锛夛紝瑙勫垯绀轰緥瑙佽鏂囦欢銆�
+鎴愬姛鏍囧織锛氭棩蹇楀嚭鐜� `Started TrafficAuditApplication` 涓� `Tomcat started on port(s): 8090`銆�
-## 涔濄�侀儴缃插悗楠岃瘉
+### 5.4 璁块棶
-1. 娴忚鍣ㄦ墦寮� `http://<鏈嶅姟鍣�>:8090`锛�
-2. 鐢� `admin / admin123` 鐧诲綍锛堢敓浜ф敼瀵嗗悗浣跨敤鏂板瘑鐮侊級锛�
-3. 鏁版嵁瀵煎叆锛氫笅杞芥ā鏉� 鈫� 涓婁紶 Excel锛堟垨鐩綍瀵煎叆锛夛紱
-4. 鎶ヨ〃锛氭煡璇� 鈫� 棰勮/瀵煎嚭锛堜緷璧� `docs` 妯℃澘鏂囦欢锛夛紱
-5. AI 鍒嗘瀽锛氶渶閰嶇疆 `deepseek.api-key` 鍚庡彲鐢ㄣ��
+娴忚鍣ㄦ墦寮� `http://<閮ㄧ讲鏈篒P>:8090`锛堝墠绔凡鍐呭祵锛岄〉闈笌鎺ュ彛鍚屾簮锛屾棤闇� nginx锛夛紝璐﹀彿 `admin / admin123`銆�
-## 鍗併�佸父瑙侀棶棰�
+## 鍏�佸叧閿厤缃紙application.yml锛変笌杩愯鏁版嵁
+
+| 閰嶇疆椤� | 榛樿鍊� | 璇存槑 |
+|--------|--------|------|
+| `docs.template-root` | `docs` | 瀵煎叆妯℃澘涓嬭浇鏍圭洰褰� |
+| `city-passenger.template-dir` | `docs/鍩庡競瀹㈣繍` | 鍩庡競瀹㈣繍锛堝惈銆婃ā鏉縚缃戠害杞﹁鍗�.docx銆嬶級 |
+| `passenger.template-dir` | `docs/鍏矾鏃呭` | 鍏矾鏃呭 |
+| `freight.template-dir` | `docs/璐ц繍` | 璐ц繍 |
+| `energy.template-dir` | `docs/鑳借�梎 | 鑳借�� |
+| `investment.template-dir` | `docs/鎶曡祫/妯℃澘` | 鎶曡祫 |
+| `summary.template-dir` | `docs/鐢熸垚姹囨�诲ぇ琛╜ | **姹囨�诲ぇ琛ㄦ瘝鐗堜笌鐗堝紡鍙傜収浠�**锛堝鍑烘姤琛ㄤ緷璧栵級 |
+
+`docs/鐢熸垚姹囨�诲ぇ琛╜ 鑷冲皯瑕佹湁锛�
+
+- `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`锛堢増寮忓弬鐓т欢锛岀己澶变細閫�鍥為粯璁ゅ垪瀹斤級锛�
+- 闇�瑕佸鍑虹殑鍚勬湀浠芥瘝鐗� `YYYY骞碝鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛堢己鍝釜鏈堬紝瀵奸偅涓湀灏变細鏄庣‘鎶ラ敊锛夈��
+
+## 涓冦�佸墠绔儴缃诧紙涓ょ鏂瑰紡锛�
+
+1. **鎺ㄨ崘锛歫ar 鍐呭祵**鈥斺�斾竴閿剼鏈凡鎶� `dist` 鎵撹繘 jar锛岀洿鎺ヨ闂� `http://<IP>:8090` 鍗冲彲锛屾棤闇�棰濆 Web 鏈嶅姟鍣ㄣ��
+2. 澶囬�夛細nginx 鎵樼 `frontend/dist` 骞舵妸 `/api` 鍙嶄唬鍒� 8090锛堥厤缃 `frontend/nginx.conf.example`锛夛紱涓婁紶 100MB 澶ф枃浠舵椂璁板緱璁� `client_max_body_size 100m`銆�
+
+鍓嶇璺敱涓� hash 妯″紡锛屽埛鏂�/鐩磋揪涓嶄細 404銆�
+
+## 鍏�侀儴缃插悗楠岃瘉娓呭崟
+
+1. `http://<IP>:8090` 鎵撳紑鐧诲綍椤碉紙椤甸潰涓嶆槸绌虹櫧锛夛紱
+2. `admin / admin123` 鑳界櫥褰曪紝宸︿笂瑙掓樉绀恒�岀鐞嗗憳銆嶏紱
+3. 銆屾暟鎹鍏ャ�嶉〉鑳戒笅杞芥ā鏉裤�佽兘涓婁紶 Excel锛�
+4. 銆屾姤琛ㄣ�嶉〉鏌ヨ + 瀵煎嚭銆婇亾璺繍杈撻噺姹囨�昏〃銆嬶紝鑳戒笅杞藉埌 xlsx锛�
+5. 鎵撳紑瀵煎嚭鐨� xlsx锛屾牳瀵瑰綋鏈堟暟鍊兼槸鍚︿负鏈�鏂版姤琛ㄦ湡銆�
+
+## 涔濄�佸父瑙侀棶棰�
| 鐜拌薄 | 鍘熷洜 / 澶勭悊 |
|------|------------|
-| 鍚姩鎶ャ�屾湭鎵惧埌鏁版嵁鐩綍 docs銆� | 褰撳墠杩愯鐩綍涓嶅锛涙妸 `docs` 鏀惧埌 jar 鍚岀骇鍐嶅惎鍔� |
-| 瀵煎嚭鎶ャ�屾湭鎵惧埌妯℃澘鏂囦欢 xxx銆� | `docs` 瀵瑰簲瀛愮洰褰曠己妯℃澘鏂囦欢锛涢娆￠儴缃叉嫹鏁翠釜 `docs` |
-| 椤甸潰鑳藉紑浣嗘帴鍙� 404锛堥獙璇佺爜鍔犺浇澶辫触锛� | 鍓嶇鐢� IIS/nginx 鎵樼鏃舵病閰� `/api` 鍙嶄唬锛涙敼鐢� Spring Boot 鎵樼锛坵eb\ 鐩綍锛夊垯鏃犳闂 |
-| 鏁版嵁搴撹繛鎺ュけ璐� | 妫�鏌� `application.yml` 鍦板潃/璐﹀彿/瀵嗙爜锛涘厛鎵ц `init.sql` |
-| 涓婁紶澶ф枃浠跺け璐� | 妫�鏌� nginx `client_max_body_size` 涓庡悗绔� multipart 闄愬埗 |
-| 绔彛鍗犵敤 | 鍚庣 8090銆佸墠绔� 80/8080 |
+| 鍚姩鎶ャ�屾湭鎵惧埌鏁版嵁鐩綍 docs銆� | 蹇呴』鍦� `backend` 鐩綍涓嬪惎鍔紙jar 涓� docs 鍚岀骇锛� |
+| 瀵煎嚭鎶ャ�屾湭鎵惧埌妯℃澘鏂囦欢 xxx銆� | `docs` 瀵瑰簲瀛愮洰褰曠己妯℃澘锛涗粠婧愭満鍣ㄦ嫹璐� |
+| 瀵煎嚭鎶ャ�屾湭鎵惧埌姹囨�昏〃姣嶇増銆奩YYY骞碝鏈堚�︺�嬨�� | `docs/鐢熸垚姹囨�诲ぇ琛╜ 缂鸿鏈堟瘝鐗� |
+| 鐧诲綍鎺ュ彛 500 | `jwt.secret` 濉簡闈炴硶瀛楃锛堝涓枃锛夛紱鏀规垚 32 浣嶅崄鍏繘鍒朵覆 |
+| 椤甸潰鑳藉紑浣嗘帴鍙� 404 | 璧� nginx 鏂规鏃舵病閰� `/api` 鍙嶄唬锛涙敼鐢� jar 鍐呭祵璁块棶 8090 |
+| 鏁版嵁搴撹繛鎺ュけ璐� | 妫�鏌� `application.yml`锛涚‘璁� 4 涓� SQL 鑴氭湰宸叉墽琛� |
+| 绔彛鍗犵敤 | 鏀� `server.port`锛涘墠绔紑鍙戠鍙� 8080 |
-## 鍗佷竴銆佸紑鍙戠幆澧冩棩甯稿惎鍔�
-
-椤圭洰鏍圭洰褰曡繍琛屼竴閿剼鏈紙鑷姩鎷夎捣鍚庣 8090 + 鍓嶇 8080锛夛細
+## 鍗併�佸紑鍙戠幆澧冩棩甯稿惎鍔�
```powershell
powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1
-```
\ No newline at end of file
+```
+
+鍚庣 8090锛坄mvn spring-boot:run`锛�+ 鍓嶇 8080锛坄npm run serve`锛夛紝璁块棶 `http://localhost:8080`銆�
+
+## 鍗佷竴銆佸彉鏇磋褰�
+
+- **2026-09-13**锛氭柊澧炰竴閿墦鍖呰剼鏈� `package-deploy.py`锛沯ar 鏀逛负鍐呭祵鍓嶇锛堥儴缃叉満涓嶅啀闇�瑕� nginx锛夛紱鍒犻櫎 Redis 鐩稿叧璇存槑锛堜唬鐮佹湭浣跨敤锛夛紱琛� `sql_wyc.sql` 涓� `summary.template-dir`锛涜ˉ `jwt.secret` 鍙栧�艰鍒欙紱琛ラ儴缃插悗楠岃瘉娓呭崟銆�
+- 2026-08-27锛氶鐗堬紙zip 閮ㄧ讲鍖� + nginx 鏂规锛夈��
--
Gitblit v1.9.1