From 1b997c6b026dc7a897f0b248413054d006af8028 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期六, 03 十月 2026 21:23:15 +0800
Subject: [PATCH] fix(holiday): 快报累计正文单位由亿人次改为万人次
---
deploy-templates/README-部署说明.txt | 98 +++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 94 insertions(+), 4 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"
index 7d759e2..357a775 100644
--- "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"
@@ -1,12 +1,33 @@
TrafficAudit 浜ら�氳揣杩愮粺璁″鏍哥郴缁� 鈥斺�� 閮ㄧ讲鍖咃紙{stamp}锛�
========================================================
+銆愭湇鍔″櫒涓婂彧瑕佸仛杩� 3 姝ャ�戯紙鍏跺畠鏂囦欢閮戒笉鐢ㄥ姩锛�
+ 绗� 1 姝� 鏀归厤缃細鐢ㄨ浜嬫湰鎵撳紑 backend\application.yml锛屾妸鏁版嵁搴撳湴鍧�/璐﹀彿/瀵嗙爜
+ 锛坰pring.datasource 涓嬮潰涓夐」锛夊拰 jwt.secret 鏀规垚杩欏彴鏈嶅姟鍣ㄧ殑鐪熷疄鍊笺��
+ 绗� 2 姝� 瑁呮湇鍔★細杩涘叆 backend 鏂囦欢澶癸紝鍙抽敭 install-service.cmd 鈫掋�屼互绠＄悊鍛樿韩浠借繍琛屻��
+ 锛堢洿鎺ュ弻鍑讳篃琛岋紝瀹冧細鑷繁寮圭鐞嗗憳纭锛夈�傝剼鏈細娉ㄥ唽寮�鏈鸿嚜鍚湇鍔″苟鍚姩瀹冦��
+ 绗� 3 姝� 鐪嬬粨鏋滐細鑴氭湰鏈�鍚庝細鎵撳嵃 OK 鍜岀綉鍧�锛涙祻瑙堝櫒鎵撳紑 http://<鏈嶅姟鍣↖P>:8090
+ 锛堣处鍙� admin / admin123锛夛紝鑳界湅鍒扮櫥褰曢〉灏辩畻鎴愬姛銆�
+
+ 鍝簺瑕佹嫹銆佸摢浜涗笉鐢ㄦ嫹锛�
+ backend\ 蹇呴』鏁翠釜鐩綍涓�璧锋嫹锛坖ar銆乤pplication.yml銆乨ocs銆亀eb銆佹湇鍔℃枃浠堕兘鍦ㄩ噷闈級锛�
+ 涓嶈鍙寫鍑犱釜鏂囦欢鎷枫��
+ db\ 鍙湁闇�瑕佸垵濮嬪寲/杩樺師鏁版嵁搴撴椂鎵嶇敤锛屽钩鏃跺彲涓嶆嫹銆�
+ frontend\ 涓嶇敤鎷凤紙鍓嶇宸插唴宓屽湪 jar 閲岋紝8090 绔彛鐩存帴璁块棶锛夈��
+ 鏈枃浠� 鍙嫹鍙笉鎷凤紝灏辨槸杩欎唤璇存槑涔︺��
+
銆愮洰褰曠粨鏋勩��
backend/
traffic-audit-server-1.0.0-SNAPSHOT.jar 鍚庣绋嬪簭锛堝惈鍏ㄩ儴渚濊禆锛�**宸插唴宓屽墠绔�**锛�
docs/ 鎶ヨ〃妯℃澘涓庤繍琛屾暟鎹洰褰曪紙蹇呴渶锛屽嬁鍒狅級
application.yml 澶栭儴閰嶇疆锛堟敼杩欓噷鍗冲彲锛屾棤闇�閲嶆柊鎵撳寘锛�
- start-backend.cmd / start-backend.sh 鍚姩鑴氭湰
+ start-backend.cmd / start-backend.sh 鍓嶅彴鍚姩鑴氭湰锛堜汉宸ヨ皟璇曠敤锛屽叧浜嗙獥鍙ｅ氨鍋滐級
+ trafficAudit.exe WinSW 鏈嶅姟鍖呰鍣紙鎶� java 鍙樻垚 Windows 鏈嶅姟锛屽嬁鍒犲嬁鏀瑰悕锛�
+ trafficAudit.xml WinSW 鏈嶅姟閰嶇疆锛堟湇鍔″悕/鍚姩鏂瑰紡/鏃ュ織/澶辫触閲嶅惎绛栫暐锛�
+ install-service.cmd 鍙屽嚮鍏ュ彛锛氭敞鍐屽紑鏈鸿嚜鍚湇鍔★紙浼氳嚜鍔ㄨ姹傜鐞嗗憳鏉冮檺锛�
+ install-service.ps1 涓婇潰閭ｄ釜 cmd 瀹為檯璋冪敤鐨勮剼鏈紙娉ㄥ唽/鏌ョ湅/閲嶅惎/鍒犻櫎锛�
+ start-backend-service.cmd 闈炰氦浜掑惎鍔ㄥ櫒锛堟棤 pause銆佸啓 app.log锛岄厤鍚堣鍒掍换鍔＄敤锛�
+ install-autostart.ps1 澶囬�夛細娉ㄥ唽鈥滆鍒掍换鍔♀�濇柟寮忕殑寮�鏈鸿嚜鍚�
frontend/
dist/ 鍓嶇鏋勫缓浜х墿锛堝鐢細鎯崇敤 nginx 鎵樼鏃剁敤锛�
nginx.conf.example nginx 閰嶇疆绀轰緥
@@ -15,6 +36,10 @@
sql_city_bus.sql 鍩庡競瀹㈣繍-鍏氦鏈堝害琛紙蹇呴』鎵ц锛�
sql_city_taxi.sql 鍩庡競瀹㈣繍-鍑虹鏈堝害琛�/鍑虹鎺堟潈琛紙蹇呴』鎵ц锛�
sql_wyc.sql 缃戠害杞﹀叏鐪佹�婚噺琛�/璁㈠崟鍒嗗競宸炶〃锛堝繀椤绘墽琛岋級
+ sql_holiday.sql 涓撻」缁熻-閲嶈鑺傚亣鏃ヨ〃锛堟棫搴撶己琛ㄦ椂鎵ц锛�
+ sql_holiday_decimal_migration.sql 鑺傚亣鏃ユ暟鍊煎垪绮惧害杩佺Щ锛堟棫搴撳崌绾э級
+ sql_holiday_comparison_base_migration.sql 鑺傚亣鏃ョ幆姣斿熀鏈熷瓧娈佃縼绉伙紙鏃у簱鍗囩骇锛�
+ sql_holiday_previous_day_migration.sql 鑺傚亣鏃ュ墠涓�鏃ラ厤缃縼绉伙紙鏃у簱鍗囩骇锛�
README-閮ㄧ讲璇存槑.txt
銆愰儴缃叉満鐜瑕佹眰銆�
@@ -23,12 +48,28 @@
**涓嶉渶瑕� Redis**锛堜唬鐮佹湭浣跨敤锛涙棫鐗堣鏄庨噷鐨� Redis 鏄仐鐣欓厤缃紝鍙拷鐣ワ級
**涓嶉渶瑕� nginx**锛堝墠绔凡鍐呭祵杩� jar锛岃闂� 8090 鍗冲彲锛沶ginx 浠呬负澶囬�夋柟妗堬級
+銆愭搷浣滅郴缁熷吋瀹规�с��
+ 寮�鏈鸿嚜鍚敤鐨勬槸 Windows 鏈嶅姟锛岃�屸�滆嚜鍔ㄥ惎鍔� / 寤惰繜鍚姩 / 澶辫触鑷姩閲嶅惎鈥濇槸绯荤粺鑷甫鑳藉姏锛�
+ 浠� Win7 SP1 鍒� Win11銆丼erver 2008 R2 鍒� Server 2022/2025 鏈哄埗瀹屽叏涓�鏍枫�傚樊鍒彧鍦ㄦ湇鍔″寘瑁呭櫒
+ trafficAudit.exe 渚濊禆浠�涔堣繍琛屾椂锛�
+ - 鏈寘鍐呯殑 trafficAudit.exe 鏄� WinSW 2.12.0 鐨� x64 鑷寘鍚瀯寤猴紙鑷甫 .NET 6 杩愯鏃讹紝宸叉牎楠� SHA-256锛夛紝
+ **涓嶉渶瑕佸彟澶栧畨瑁� .NET Framework**锛涙帹鑽愮敤浜� 64 浣� Win10 / Win11 / Server 2016 鍙婁互涓娿��
+ - Win7 SP1 / Server 2008 R2 / Server 2012(R2)锛氳嚜鍖呭惈鐗堥�氬父涔熻兘璺戯紙Win7 SP1 闇�鍏堟墦 KB2533623锛夛紱
+ 鑻ユ姤缂哄皯 api-ms-win-*.dll 涔嬬被锛屾崲鎴愬畼鏂� thin 鏋勫缓锛氭妸 WinSW.NET461.exe 涓嬭浇鍚庢敼鍚嶆垚
+ trafficAudit.exe 瑕嗙洊锛堥厤缃� trafficAudit.xml 涓嶇敤鏀癸級锛屽畠闇� .NET Framework 4.6.1+锛�
+ https://github.com/winsw/winsw/releases/download/v2.12.0/WinSW.NET461.exe
+ - 32 浣嶇郴缁燂細鎶婂寘瑁呭櫒鎹㈡垚 WinSW-x86.exe锛堝悓涓�涓嬭浇椤碉級銆�
+ - Win7 / Server 2012 鏈韩宸茶繃寰蒋鏀寔鏈燂紝鏂版湇鍔″櫒寤鸿鐩存帴涓� Server 2016 鍙婁互涓娿��
+ - 鑴氭湰瑕佹眰锛歩nstall-service.ps1 鍦� Windows PowerShell 2.0+ 涓嬪彲鐢紙Win7 鑷甫 2.0锛屽凡鍋氬吋瀹癸級锛�
+ 3.2 鐨勮鍒掍换鍔¤剼鏈敤鍒颁簡 New-ScheduledTask* 鍛戒护锛岄渶瑕� Win8 / Server 2012 鍙婁互涓娿��
+
銆愰儴缃叉楠ゃ��
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
+ 娉細鍏ㄦ柊搴撶殑 init.sql 宸插惈鑺傚亣鏃� 4 寮犺〃锛涜嫢鏄湪鏃╂湡鐗堟湰搴撲笂琛ヨ妭鍋囨棩妯″潡锛屽啀鎵ц db/sql_holiday.sql锛屽苟鎸夐渶鎵ц涓変釜杩佺Щ鑴氭湰锛堟暟鍊肩簿搴︺�佺幆姣斿熀鏈熴�佸墠涓�鏃ラ厤缃級銆傚墠涓�鏃ヨ縼绉昏剼鏈彲閲嶅鎵ц銆�
棰勭疆璐﹀彿锛歛dmin / admin123锛堥娆＄櫥褰曞悗璇锋敼瀵嗙爜锛�
2. 鏀归厤缃� backend/application.yml
@@ -37,10 +78,47 @@
- deepseek.api-key 锛氶渶瑕� AI 鍒嗘瀽鏃跺～锛屼笉闇�瑕佸彲鐣欑┖
娉細application.yml 涓� jar 鍚岀骇鍗崇敓鏁堬紝涓嶇敤閲嶆柊鎵撳寘銆�
- 3. 鍚姩鍚庣锛堝湪 backend 鐩綍涓嬶級
+ 3. 鍚姩鍚庣锛堝湪 backend 鐩綍涓嬶紱杩欐鍙槸鎵嬪伐璇曡窇锛屽叧绐楀彛灏卞仠锛岃寮�鏈鸿嚜鍚鐪� 3.1锛�
Windows锛氬弻鍑� start-backend.cmd
Linux锛� sh start-backend.sh
鎴愬姛鏍囧織锛氬嚭鐜� "Started TrafficAuditApplication" 涓� "Tomcat started on port(s): 8090"
+
+ 3.1 Windows 寮�鏈鸿嚜鍚紙鎺ㄨ崘锛氭敞鍐屾垚 Windows 鏈嶅姟锛屼竴娆￠厤缃暱鏈熺敓鏁堬級
+ 鍓嶆彁锛歜ackend 鐩綍涓嬬殑 trafficAudit.exe / trafficAudit.xml / install-service.cmd / install-service.ps1
+ 閮藉凡闅忔湰閮ㄧ讲鍖呮彁渚涳紝涓嶉渶瑕佸彟澶栦笅杞� WinSW锛屼篃涓嶉渶瑕佺粰 java 瑁呭埆鐨勪笢瑗裤��
+ 鏈�鐪佷簨锛氬湪 backend 鐩綍鍙抽敭 install-service.cmd 鈫掋�屼互绠＄悊鍛樿韩浠借繍琛屻��
+ 锛堢洿鎺ュ弻鍑讳篃琛岋紝瀹冧細鑷繁寮� UAC 绠＄悊鍛樼‘璁わ級銆�
+ 绛変环鐨勬墜宸ユ柟寮忥紙鍦� backend 鐩綍涓嬶紝鐢ㄣ�愮鐞嗗憳銆慞owerShell锛夛細
+ powershell -NoProfile -ExecutionPolicy Bypass -File install-service.ps1
+ 鏁堟灉锛氭敞鍐� Windows 鏈嶅姟 TrafficAuditBackend锛屽紑鏈鸿嚜鍔ㄥ惎鍔紙寤惰繜鍚姩锛屽厛绛� MySQL 灏辩华锛夛紝
+ 涓嶉渶瑕佷换浣曠敤鎴风櫥褰曪紱java 杩涚▼寮傚父閫�鍑虹敱鏈嶅姟绠＄悊鍣ㄨ嚜鍔ㄩ噸鍚紙10 绉� / 30 绉� / 60 绉掗�掑閲嶈瘯锛�
+ 1 灏忔椂鍚庨噸璇曡鏁版竻闆讹級銆傛湇鍔′互 LocalSystem 韬唤杩愯銆�
+ 鑴氭湰浼氳嚜鍔ㄥ畾浣� java.exe锛圝AVA_HOME 鈫� PATH 鈫� JavaSoft 娉ㄥ唽琛� 鈫� Program Files锛夛紝
+ 骞舵妸缁濆璺緞鍐欒繘 trafficAudit.xml锛圫YSTEM 鏈嶅姟鐨� PATH 涓庣櫥褰曠敤鎴蜂笉鍚岋紝鍐欑粷瀵硅矾寰勬洿绋筹級銆�
+ 甯哥敤鍙傛暟锛�
+ -Status 鏌ョ湅鏈嶅姟鐘舵�侊紙涓嶉渶瑕佺鐞嗗憳锛�
+ -Restart 閲嶅惎鏈嶅姟 -Remove 鍋滄骞跺垹闄ゆ湇鍔�
+ -NoStart 鍙敞鍐屼笉鍚姩 -JavaPath "D:\jdk8\bin\java.exe" 鎵嬪姩鎸囧畾 JDK
+ 鏃ュ織锛歜ackend\logs\trafficAudit.out.log锛堣繍琛岃緭鍑猴級涓� trafficAudit.err.log锛堥敊璇緭鍑猴級锛�
+ 鍗曚釜鏂囦欢 10MB锛屼繚鐣� 10 涓粴鍔ㄦ枃浠躲��
+ 楠岃瘉锛氳剼鏈瀹屼細鑷姩鎺㈡祴绔彛锛屾墦鍗� OK + 鏈満/瀵瑰缃戝潃锛涜捣涓嶆潵鏃剁洿鎺ユ墦鍗� logs\*.log 鏈�鍚� 15 琛岋紝
+ 鎸夋彁绀烘敼 application.yml 鍚庢墽琛� install-service.ps1 -Restart 鍗冲彲銆備篃鍙墜宸ョ敤娴忚鍣ㄦ墦寮�
+ http://<閮ㄧ讲鏈篒P>:8090 纭銆�
+ 娉ㄦ剰锛�
+ - 寮�鏈鸿嚜鍚潬鏈嶅姟鐨勨�滆嚜鍔ㄢ�濆惎鍔ㄧ被鍨嬶紱濡傛灉鎶婂畠鏀规垚鈥滄墜鍔ㄢ�濓紝灏变笉浼氬啀闅忔満鍣ㄥ惎鍔ㄣ��
+ - 閲嶅鎵ц install-service.ps1 鏄畨鍏ㄧ殑锛氫細鍏堝仠鏈嶅姟鍐嶉噸鏂版敞鍐屽苟鍚姩銆�
+ - 鍚屼竴鍙版満涓嶈鍚屾椂鍚敤涓嬮潰鐨勮鍒掍换鍔℃柟寮忥紝涓や釜杩涚▼浼氭姠 8090 绔彛銆�
+ - 寤鸿鎶婇儴缃插寘鏀惧湪 D:\trafficAudit 杩欑被绠�鍗曡矾寰勶紱鏀惧湪鏌愪簺鐢ㄦ埛鐩綍涓嬫椂 LocalSystem
+ 鍙兘娌℃湁鍐欐潈闄愶紝鏃ュ織浼氭姤鏉冮檺閿欒銆�
+
+ 3.2 澶囬�夛細璁″垝浠诲姟鏂瑰紡锛堜笉鎯虫妸鍚庣瑁呮垚鏈嶅姟鏃剁敤锛屼笌 3.1 浜岄�変竴锛�
+ 鍦� backend 鐩綍涓嬶紝鐢ㄣ�愮鐞嗗憳銆慞owerShell 鎵ц锛�
+ powershell -NoProfile -ExecutionPolicy Bypass -File install-autostart.ps1
+ 鏁堟灉锛氭敞鍐岃鍒掍换鍔� TrafficAuditBackend锛屽紑鏈哄欢杩� 60 绉掑悗浠� SYSTEM 韬唤杩愯 start-backend-service.cmd锛�
+ 涓嶉渶瑕佺敤鎴风櫥褰曪紝澶辫触鑷姩閲嶈瘯 3 娆★紝杩愯鏃ュ織鍐欏湪 backend\app.log銆�
+ 甯哥敤鍙傛暟锛�-DelaySeconds 90锛堟敼寤惰繜绉掓暟锛� -StartNow锛堟敞鍐屽悗绔嬪嵆鍚姩涓�娆★級
+ -Status锛堟煡鐪嬬姸鎬侊級 -Remove锛堝垹闄ゅ紑鏈鸿嚜鍚級
+ 娉細鍚姩鍣ㄤ紭鍏堢敤 JAVA_HOME\bin\java.exe锛屾壘涓嶅埌鏃跺洖閫� PATH锛涙娴嬪埌 8090 宸插湪鐩戝惉鍒欑洿鎺ラ��鍑恒��
4. 璁块棶绯荤粺
娴忚鍣ㄦ墦寮� http://<閮ㄧ讲鏈篒P>:8090 锛堝墠绔凡鍐呭祵锛岄〉闈笌鎺ュ彛鍚屾簮锛�
@@ -54,6 +132,10 @@
娉ㄦ剰锛氬叏閲� dump 浼氬甫涓婃湰鏈虹殑璐﹀彿瀵嗙爜锛岃鐩� init.sql 棰勭疆鐨� admin 璐﹀彿銆�
銆愬父瑙侀棶棰樸��
+ 0. 鍚姩鎶� java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)锛�
+ 鈥渦sing password: NO鈥� = 鍚庣鎷垮埌鐨勬暟鎹簱瀵嗙爜鏄┖涓诧紙涓嶆槸瀵嗙爜閿欙級銆�
+ 妫�鏌� backend/application.yml 鏄惁涓� jar 鍚岀骇涓� spring.datasource.password 宸插～鐪熷疄瀵嗙爜锛�
+ 鑻ユ湭鏀� application.yml锛屼篃鍙敤鐜鍙橀噺 TRAFFIC_DB_PASSWORD 浠ｆ浛銆傛敼瀹岄噸鍚嵆鍙紝鏃犻渶閲嶆柊鎵撳寘銆�
1. 鍚姩鎶ャ�屾湭鎵惧埌鏁版嵁鐩綍 docs銆�/ 瀵煎嚭鎶ャ�屾湭鎵惧埌妯℃澘鏂囦欢銆嶏細
蹇呴』鍦� backend 鐩綍涓嬪惎鍔紙jar 涓� docs 鍚岀骇锛夛紝涓嶈鍙嫹 jar銆�
2. 鎶ヨ〃瀵煎嚭鎶ャ�屾湭鎵惧埌姹囨�昏〃姣嶇増銆奩YYY骞碝鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx銆嬨�嶏細
@@ -61,7 +143,15 @@
3. 8090 绔彛琚崰鐢細鏀� application.yml 鐨� server.port 鍚庨噸鍚��
4. 椤甸潰鎵撳紑鏄┖鐧斤細纭璁块棶鐨勬槸 http://<IP>:8090 鏍硅矾寰勶紝涓旀祻瑙堝櫒寮哄埗鍒锋柊锛圕trl+F5锛夈��
5. 涓婁紶澶ф枃浠跺け璐ワ細鍚庣闄愬埗 100MB锛屽凡閰嶇疆锛涘鍓嶉潰杩樻寕浜� nginx锛岄渶鍚屾鏀惧ぇ client_max_body_size銆�
+ 6. 鏈嶅姟宸叉敞鍐屼絾 8090 鎵撲笉寮�锛氱湅 backend\logs\trafficAudit.err.log 鐨勬姤閿欏唴瀹癸紱
+ 鏈嶅姟鏂瑰紡涓嬬敤鐨勬槸 backend\application.yml锛宲assword 蹇呴』鏄湡瀹� MySQL 瀵嗙爜锛堝崰浣嶆枃瀛椾細瀵艰嚧 using password: NO锛夈��
+ 7. 鏈嶅姟鎶モ�滄嫆缁濊闂�濇垨鍐欎笉浜嗘棩蹇楋細閮ㄧ讲鐩綍鏉冮檺涓嶈冻銆�
+ 鎶婇儴缃插寘鏀惧埌 D:\trafficAudit 杩欑被绠�鍗曡矾寰勶紝鎴栫粰 LocalSystem 鎺堜簣璇ョ洰褰曠殑璇诲啓鏉冮檺銆�
+ 8. 鎯充复鏃跺彇娑堝紑鏈鸿嚜鍚絾淇濈暀鏈嶅姟锛歋et-Service TrafficAuditBackend -StartupType Manual
銆愬仠姝㈡湇鍔°��
- Windows锛氬叧闂� start-backend.cmd 绐楀彛
- Linux锛� Ctrl+C锛屾垨 kill 瀵瑰簲 java 杩涚▼锛坧s -ef | grep java锛�
+ 鏈嶅姟鏂瑰紡锛� Stop-Service TrafficAuditBackend 锛堥噸鏂板惎鍔細Start-Service TrafficAuditBackend锛�
+ 褰诲簳鍒犻櫎寮�鏈鸿嚜鍚細install-service.ps1 -Remove
+ 鍓嶅彴鍚姩锛� 鍏抽棴 start-backend.cmd 绐楀彛
+ 璁″垝浠诲姟锛� Stop-ScheduledTask -TaskName TrafficAuditBackend
+ Linux锛� Ctrl+C锛屾垨 kill 瀵瑰簲 java 杩涚▼锛坧s -ef | grep java锛�
--
Gitblit v1.9.1