From 67cd940347bfe38ef6aab075a2dbd738bec41ed3 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期六, 03 十月 2026 14:43:44 +0800
Subject: [PATCH] feat(holiday): support 2019 and previous-day data in new templates
---
HANDOFF.md | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/HANDOFF.md b/HANDOFF.md
index a305c9f..f550548 100644
--- a/HANDOFF.md
+++ b/HANDOFF.md
@@ -6,6 +6,17 @@
## 鏈�鏂帮紙2026-10-03锛�
+### 10-03 鏅氾細閲嶈鑺傚亣鏃ユ柊妯℃澘锛�2019/鍓嶄竴鏃ワ級閫傞厤
+- **妯℃澘鍙樺寲**锛歚2026骞村崄涓�鏁版嵁.xlsx` 鐨勯亾璺〃澧炲姞 2019 骞村強鍚屾瘮2019锛涢搧璺�佹皯鑸鍔犫�滃墠涓�鏃モ�濊锛涘揩鎶ユā鏉垮鍔犲悓姣�2024 鍒椼�傛棫妯℃澘宸叉斁鍦� `docs/涓撻」缁熻/閲嶈鑺傚亣鏃�/澶囦唤/`銆�
+- **鏁版嵁搴撳垵濮嬪寲**锛氬惎鍔ㄦ椂鐩存帴鍐欏叆 2019 閬撹矾鏁版嵁锛屼互鍙� 2024/2025/2026 骞撮搧璺�佹皯鑸墠涓�鏃ユ暟鎹紱`holiday_calendar.day_index=0` 琛ㄧず鈥滃墠涓�鏃モ�濓紝鏃у簱鍚姩浼氳嚜鍔ㄨˉ榻愬凡鏈夊勾浠界殑鍓嶄竴鏃ラ厤缃锛屼笖涓嶈鐩栫鐞嗗憳宸茬淮鎶ょ殑鏃ユ湡銆�
+- **姝ｅ父瀵煎叆鍙ｅ緞**锛氬彧璇诲彇鎵�閫夊勾浠界殑褰撳勾鍒楋紙2026 骞撮搧璺�/姘戣埅/閬撹矾/姘磋矾涓� C 鍒椼�侀珮閫熶负 C 鍒椼�佹櫘閫氬浗鐪侀亾涓� D 鍒楋級锛涘悓鏃跺彧棰濆璇诲彇褰撳墠骞翠唤閾佽矾/姘戣埅鐨勨�滃墠涓�鏃モ�濊銆�2019/2024/2025 鍘嗗彶鍒椾笉鍙備笌瀵煎叆銆�
+- **蹇姤鍙ｅ緞**锛氬悓姣斿彧浣跨敤 2025銆�2024锛涘亣鏈熺 1 鏃ョ殑閾佽矾銆佹皯鑸幆姣斾娇鐢ㄢ�滃墠涓�鏃モ�濇暟鎹紝鍏矾銆佹按璺�佹�昏鍙婂叾浠栧彛寰勭 1 鏃ヤ粛鏄剧ず鈥溾�斺�濓紱绗� 2 鏃ヨ捣姝ｅ父璁＄畻鐜瘮銆�
+- **杩佺Щ鑴氭湰**锛歚docs/sql_holiday_previous_day_migration.sql`锛岄儴缃插寘鍚屾涓� `deploy-templates/db/sql_holiday_previous_day_migration.sql`锛岃剼鏈彲閲嶅鎵ц銆�
+- **楠岃瘉锛堟湰鏈� 3305 搴� + 鐪熷疄妯℃澘锛�**锛氭帴鍙ｅ鍏ョ粨鏋� `passengerRows=10, vehicleRows=4, successRows=14, failRows=0`锛涙暟鎹簱鎶芥煡 2026-09-30 閾佽矾=82.1銆佹皯鑸�=6.6994锛�2026-10-01 閾佽矾=113.8銆佹皯鑸�=6.7482銆侀亾璺�=78.82銆佹按璺�=1.311锛�2026-10-02 閾佽矾=82.0銆佹皯鑸�=6.3914銆侀亾璺�=75.61銆佹按璺�=3.3373锛�2026-10-01 蹇姤閾佽矾鐜瘮=+38.6%銆佹皯鑸幆姣�=+0.7%锛屾�昏鐜瘮涓衡�溾�斺�濓紱2026-10-02 閾佽矾鐜瘮=-27.9%銆佹皯鑸幆姣�=-5.3%銆�
+- **杩愯鐘舵��**锛氬悗绔� 8090锛堥噸鍚悗宸插姞杞芥柊浠ｇ爜锛夈�佸墠绔� 8080 鍧囧湪杩愯锛涜闂� `http://localhost:8080`銆�
+
+---
+
### 琛ュ厖锛�10-03 涓嬪崍锛夛細鏈嶅姟鍣ㄩ儴缃叉姤 鈥淎ccess denied ... (using password: NO)鈥� 鈥斺�� 鏍瑰洜涓庝慨澶�
- **鐜拌薄**锛氭妸 `deploy/traffic-audit-release-20261002/` 閮ㄧ讲鍒� `61.183.254.94` 鍚庯紝鍚庣鍚姩鎶� `java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)`銆�
- **鏍瑰洜**锛歫ar 鍐呯疆閰嶇疆閲屽簱鍙ｄ护鏄崰浣嶇 `${TRAFFIC_DB_PASSWORD:}`锛堥粯璁ょ┖涓诧級锛岃�� 10-02 閭ｄ釜鍖�**鍙惈 jar + web + dist**锛屾病鏈夊缃� `application.yml`銆佹病鏈� `docs/`銆乣db/`銆佸惎鍔ㄨ剼鏈�傞儴缃叉満娌℃湁浠讳綍澶栭儴閰嶇疆瑕嗙洊锛孲pring 灏辨嬁绌哄瘑鐮佽繛鏈満 MySQL 鈫� `using password: NO`锛堟敞鎰忥細杩欐槸鈥滄湯浼犲瘑鐮佲�濓紝涓嶆槸瀵嗙爜閿欙級銆�
@@ -61,7 +72,8 @@
- 鍖呭悕锛氫慨澶嶇増閲嶆墦鍖呮椂鑴氭湰澶嶇敤浜嗗凡閲婃斁鐨勫熀纭�鍚嶏紝鏈�缁堝凡鍒犳帀鏃у潖鍖呭苟鏀瑰悕锛宍deploy\` 浠嶇劧鏄�**鍞竴**鐨� `traffic-audit-deploy-20261003-4\`锛堝惈淇鍚庣殑 install-service.ps1锛変笌鍚屽悕 zip銆�
- 鐢ㄦ埛渚ф渶灏忎慨澶嶏細鍙渶鐢ㄦ柊鍖呴噷鐨� `backend\install-service.ps1` 瑕嗙洊鏈嶅姟鍣� `D:\trafficAudit\install-service.ps1`锛屽啀閲嶈窇 `install-service.cmd`锛堜笉蹇呴噸鎷� 110MB锛夈��
- **鏈嶅姟鍣ㄩ儴缃叉垚鍔燂紙10-03 鏅氾紝鐢ㄦ埛纭锛�**锛氭湇鍔″櫒锛堥儴缃茬洰褰� `D:\trafficAudit`锛屾妸 backend 閲岀殑鍐呭鐩存帴閾哄湪璇ョ洰褰曚笅锛夌敤淇鍚庣殑 `install-service.cmd` 瀹夎鏈嶅姟 `TrafficAuditBackend` 鎴愬姛銆�
- - **寰呯‘璁わ紙灏氭湭楠岃瘉锛�**锛氣憼 閲嶅惎鏈嶅姟鍣ㄥ悗鏄惁鑷姩鍚姩锛堝簲鍚屾椂鐪嬪埌鈥滆嚜鍔� + 寤惰繜鍚姩鈥濓級锛涒憽 8090 鏄惁宸插鍏跺畠鏈哄櫒鏀捐锛圵indows 闃茬伀澧欓粯璁や細鎷﹀叆绔欙級锛涒憿 涓氬姟椤甸潰/瀵煎叆瀵煎嚭楠屾敹銆�
+ - **宸查獙璇侊紙鐢ㄦ埛纭锛�**锛氣憼 鍔炲叕鐢佃剳娴忚鍣ㄨ兘鎵撳紑鏈嶅姟鍣ㄩ〉闈紙璇存槑缃戠粶/闃茬伀澧欒繖涓�灞傞�氾紝鏃犻渶棰濆鏀捐 8090锛夛紱鈶� **閲嶅惎鏈嶅姟鍣ㄥ悗浠嶈兘浠庡姙鍏數鑴戞墦寮�椤甸潰 鈫� 寮�鏈鸿嚜鍚疄娴嬬敓鏁�**锛堟湇鍔′笉渚濊禆浠讳綍璐﹀彿鐧诲綍锛夈��
+ - **浠嶅緟鍋�**锛氫笟鍔″姛鑳介獙鏀讹紙鐧诲綍 / 鏁版嵁瀵煎叆 / 鎶ヨ〃瀵煎嚭 / Word 蹇姤锛夛紱纭 `application.yml` 鐨� jwt.secret 宸叉崲鎴愭寮忛殢鏈哄�笺�侀缃� admin/admin123 宸叉敼瀵嗐��
- 闃茬伀澧欐斁琛岋紙鑰佺郴缁熶篃鑳界敤锛夛細`netsh advfirewall firewall add rule name="TrafficAudit 8090" dir=in action=allow protocol=TCP localport=8090`
- 瑁呭畬鍚庡父鐢細`install-service.ps1 -Status / -Restart / -Remove`锛涙棩蹇楀湪 `D:\trafficAudit\logs\trafficAudit.out.log`锛堥敊璇湅 `trafficAudit.err.log`锛夈��
--
Gitblit v1.9.1