From 0acd500f0a2e2e34ff199472dd5575723afb6358 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 27 九月 2026 17:48:04 +0800
Subject: [PATCH] fix(汇总表母版): 157 格文本型数字改为数值(公交 AF/M 各68 + G 17、轨道轮渡 4)；重新生成验证仅 68 格类型变化、值不变。并记录排名页块顺序/辅助列定位
---
deploy-templates/README-部署说明.txt | 67 +++++++++++++++++++++++++++++++++
1 files changed, 67 insertions(+), 0 deletions(-)
diff --git "a/deploy-templates/README-\351\203\250\347\275\262\350\257\264\346\230\216.txt" "b/deploy-templates/README-\351\203\250\347\275\262\350\257\264\346\230\216.txt"
new file mode 100644
index 0000000..7d759e2
--- /dev/null
+++ "b/deploy-templates/README-\351\203\250\347\275\262\350\257\264\346\230\216.txt"
@@ -0,0 +1,67 @@
+TrafficAudit 浜ら�氳揣杩愮粺璁″鏍哥郴缁� 鈥斺�� 閮ㄧ讲鍖咃紙{stamp}锛�
+========================================================
+
+銆愮洰褰曠粨鏋勩��
+ backend/
+ traffic-audit-server-1.0.0-SNAPSHOT.jar 鍚庣绋嬪簭锛堝惈鍏ㄩ儴渚濊禆锛�**宸插唴宓屽墠绔�**锛�
+ 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
+
+銆愰儴缃叉満鐜瑕佹眰銆�
+ JDK 8锛堝繀闇�锛�
+ MySQL 5.7 / 8.0锛堝繀闇�锛�
+ **涓嶉渶瑕� Redis**锛堜唬鐮佹湭浣跨敤锛涙棫鐗堣鏄庨噷鐨� Redis 鏄仐鐣欓厤缃紝鍙拷鐣ワ級
+ **涓嶉渶瑕� nginx**锛堝墠绔凡鍐呭祵杩� jar锛岃闂� 8090 鍗冲彲锛沶ginx 浠呬负澶囬�夋柟妗堬級
+
+銆愰儴缃叉楠ゃ��
+ 1. 鍒濆鍖栨暟鎹簱锛�4 涓剼鏈兘瑕佹墽琛岋紝椤哄簭濡備笅锛�
+ mysql --default-character-set=utf8mb4 -u root -p < db/init.sql
+ mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_city_bus.sql
+ mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_city_taxi.sql
+ mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_wyc.sql
+ 棰勭疆璐﹀彿锛歛dmin / admin123锛堥娆＄櫥褰曞悗璇锋敼瀵嗙爜锛�
+
+ 2. 鏀归厤缃� backend/application.yml
+ - spring.datasource.url / username / password 锛氭敼鎴愰儴缃叉満鐨� MySQL锛堥粯璁ょ鍙� 3306锛�
+ - jwt.secret 锛氭敼鎴愪竴涓查殢鏈哄瓧绗︿覆锛�**蹇呴』鏄� Base64 鍚堟硶瀛楃涓旈暱搴︽槸 4 鐨勫�嶆暟**锛屽 32 浣嶅崄鍏繘鍒讹紱濉腑鏂囦細鐧诲綍澶辫触锛�
+ - deepseek.api-key 锛氶渶瑕� AI 鍒嗘瀽鏃跺～锛屼笉闇�瑕佸彲鐣欑┖
+ 娉細application.yml 涓� jar 鍚岀骇鍗崇敓鏁堬紝涓嶇敤閲嶆柊鎵撳寘銆�
+
+ 3. 鍚姩鍚庣锛堝湪 backend 鐩綍涓嬶級
+ Windows锛氬弻鍑� start-backend.cmd
+ Linux锛� sh start-backend.sh
+ 鎴愬姛鏍囧織锛氬嚭鐜� "Started TrafficAuditApplication" 涓� "Tomcat started on port(s): 8090"
+
+ 4. 璁块棶绯荤粺
+ 娴忚鍣ㄦ墦寮� http://<閮ㄧ讲鏈篒P>:8090 锛堝墠绔凡鍐呭祵锛岄〉闈笌鎺ュ彛鍚屾簮锛�
+ 璐﹀彿锛歛dmin / admin123
+
+銆愭暟鎹縼绉伙紙鍙�夛級銆�
+ 鎯虫妸鏈満鏁版嵁涓�骞舵惉鍒版柊鏈哄櫒锛岀敤 mysqldump锛堟湰鏈� MySQL 鑻ヤ笉鍦� 3306锛屾寜瀹為檯绔彛鏀癸級锛�
+ mysqldump -h 127.0.0.1 -P 3306 -u root -p --databases traffic_audit > traffic_audit_full.sql
+ 鍐嶅湪鏂版満鍣ㄦ墽琛岋細
+ mysql -u root -p < traffic_audit_full.sql
+ 娉ㄦ剰锛氬叏閲� dump 浼氬甫涓婃湰鏈虹殑璐﹀彿瀵嗙爜锛岃鐩� init.sql 棰勭疆鐨� admin 璐﹀彿銆�
+
+銆愬父瑙侀棶棰樸��
+ 1. 鍚姩鎶ャ�屾湭鎵惧埌鏁版嵁鐩綍 docs銆�/ 瀵煎嚭鎶ャ�屾湭鎵惧埌妯℃澘鏂囦欢銆嶏細
+ 蹇呴』鍦� backend 鐩綍涓嬪惎鍔紙jar 涓� docs 鍚岀骇锛夛紝涓嶈鍙嫹 jar銆�
+ 2. 鎶ヨ〃瀵煎嚭鎶ャ�屾湭鎵惧埌姹囨�昏〃姣嶇増銆奩YYY骞碝鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬨�嶏細
+ docs/鐢熸垚姹囨�诲ぇ琛� 涓嬬己灏戣鏈堜唤姣嶇増锛涙妸婧愭満鍣ㄧ殑璇ユ枃浠舵嫹杩囧幓銆�
+ 3. 8090 绔彛琚崰鐢細鏀� application.yml 鐨� server.port 鍚庨噸鍚��
+ 4. 椤甸潰鎵撳紑鏄┖鐧斤細纭璁块棶鐨勬槸 http://<IP>:8090 鏍硅矾寰勶紝涓旀祻瑙堝櫒寮哄埗鍒锋柊锛圕trl+F5锛夈��
+ 5. 涓婁紶澶ф枃浠跺け璐ワ細鍚庣闄愬埗 100MB锛屽凡閰嶇疆锛涘鍓嶉潰杩樻寕浜� nginx锛岄渶鍚屾鏀惧ぇ client_max_body_size銆�
+
+銆愬仠姝㈡湇鍔°��
+ Windows锛氬叧闂� start-backend.cmd 绐楀彛
+ Linux锛� Ctrl+C锛屾垨 kill 瀵瑰簲 java 杩涚▼锛坧s -ef | grep java锛�
--
Gitblit v1.9.1