From 2b1af100a2402e65b44a929489754949198a19df Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期二, 06 十月 2026 00:29:34 +0800 Subject: [PATCH] fix(holiday): 国省道环比基期改为纯备用值，不进环比计算 --- docs/database.md | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/docs/database.md b/docs/database.md index b7ffc90..042b269 100644 --- a/docs/database.md +++ b/docs/database.md @@ -526,7 +526,7 @@ | road_category | varchar(32) | 楂橀�熷叕璺� EXPRESSWAY / 鏅�氬浗鐪侀亾 NATIONAL_PROVINCIAL | | vehicle_type | varchar(32) | 灏忓杞� SMALL_PASSENGER / 涓皬瀹㈣溅 MEDIUM_SMALL_PASSENGER | | vehicle_count | decimal(30,15) | 杞︽祦閲忥紙涓囪締娆★級 | - | comparison_base | decimal(30,15) | 鏅�氬浗鐪侀亾鐜瘮鍩烘湡锛堜竾杈嗘锛屼粎褰撳勾浣跨敤锛� | + | comparison_base | decimal(30,15) | 鏅�氬浗鐪侀亾鐜瘮鍩烘湡锛堜竾杈嗘锛屼汉宸ュ鐢ㄥ�硷紝浠� 2026 骞村惎鐢ㄣ�佷笉鍙備笌璁＄畻锛� | | created_at / updated_at | datetime | 鍒涘缓/鏇存柊鏃堕棿 | 鍞竴閿細`(year, flow_date, road_category, vehicle_type)`銆� @@ -544,11 +544,11 @@ ### 璁＄畻涓庡鍏ュ鍑哄彛寰� - 闈炶惀涓氭�т汉鍛樻祦鍔ㄩ噺 =锛堥珮閫熻溅娴� + 鏅�氬浗鐪侀亾杞︽祦锛壝� 褰撳勾鑺傚亣鏃ュ杩愮郴鏁般�� - - 2026 骞存櫘閫氬浗鐪侀亾濡傚～鍐欑幆姣斿熀鏈燂紝鍒欏彧褰卞搷鏅�氬浗鐪侀亾杞︽祦閲忚嚜韬幆姣旓細濉啓鏃舵寜鈥滃綋鏃� / 鐜瘮鍩烘湡 - 1鈥濓紝鏈～鍐欐椂鎸夆�滃綋鏃� / 鍓嶄竴鏃� - 1鈥濓紱鎶樼畻浜哄憳娴佸姩閲忋�佹�讳汉鍛樻祦鍔ㄩ噺绛夌户缁寜 Excel 鍘熷叕寮忚绠椼��2024銆�2025 鍘嗗彶鏁版嵁涓嶄娇鐢ㄨ瀛楁銆� + - 鏅�氬浗鐪侀亾鐜瘮鍥哄畾鎸夆�滃綋鏃� / 鍓嶄竴鏃� - 1鈥濊绠楋紱2024/2025/2026 鍚勫勾涓�鑷淬�俙comparison_base`锛圗xcel 鏅�氬浗鐪侀亾琛� C 鍒椻�滅幆姣斿熀鏈熲�濓級鑷� 2026-10-05 璧蜂粎浣滀汉宸ュ鐢細瀵煎叆瀵煎嚭鍘熸牱淇濆瓨/鍥炲啓锛屼笉鍙備笌鐜瘮銆佹姌绠楁垨绱锛涘鍑烘椂 C 鍒楃収甯稿啓鍑猴紝E 鍒椻�滅幆姣斺�濆叕寮忓缁堝紩鐢ㄤ笂涓�琛屽悓骞� D 鍒椼�� - 鍏矾浜哄憳娴佸姩閲� = 閬撹矾钀ヤ笟鎬у杩愰噺 + 闈炶惀涓氭�т汉鍛樻祦鍔ㄩ噺銆� - 鎬讳汉鍛樻祦鍔ㄩ噺 = 鍏矾 + 閾佽矾 + 姘戣埅 + 姘磋矾銆� - 瀵煎叆鎸夆�滃勾浠� + 鑺傚亣鏃ュ垎绫烩�濊鍙� `holiday_calendar` 涓� `day_index>=1` 鐨勬棩鏈燂紝灏嗗伐浣滅翱鈥滅N鏃モ�濊瑕嗙洊鍐欏叆褰撳勾瀹㈡祦/杞︽祦锛涘悓鏃惰鍙栧綋鍓嶅勾浠介搧璺�佹皯鑸殑鈥滃墠涓�鏃モ�濊锛屽啓鍏� `day_index=0` 瀵瑰簲鐨勬棩鏈熴�� -- 鏃ュ父瀵煎叆鍙鍙栨墍閫夊勾浠界殑褰撳勾鍒楋紙閬撹矾琛ㄧ殑 2019/2024/2025 鍒楀潎涓嶈鍙栵級锛�2019 骞撮亾璺暟鎹拰 2024/2025/2026 骞村墠涓�鏃ラ搧璺�佹皯鑸暟鎹敱鍚姩鍒濆鍖栫洿鎺ュ啓鍏ユ暟鎹簱銆� +- 鏃ュ父瀵煎叆鍙鍙栨墍閫夊勾浠界殑褰撳勾鍒楋紙閬撹矾琛ㄧ殑 2019/2024/2025 鍒楀潎涓嶈鍙栵級锛�2019 骞撮亾璺暟鎹拰 2024/2025/2026 骞村墠涓�鏃ラ搧璺�佹皯鑸暟鎹敱鍚姩鍒濆鍖栫洿鎺ュ啓鍏ユ暟鎹簱銆�2019 骞� 10 鏈� 1-8 鏃ョ殑 `holiday_calendar` 閰嶇疆鐢ㄤ簬鍦ㄧ郴缁熼厤缃拰鑺傚亣鏃ョ粺璁￠〉鏌ョ湅璇ュ巻鍙插熀绾裤�� - 瀵煎叆鍓嶆鏌ユ瘮鏈鏈�鏂板鍏ユ棩鏇存棭鐨勫巻鍙叉棩鏈熸槸鍚﹀彂鐢熷彉鍖栵紱濡傛湁鍙樺寲鍏堜笉鍐欏簱锛岃繑鍥炲樊寮傛竻鍗曪紝鐢ㄦ埛纭鍚庢墠鍏佽瑕嗙洊銆� - 璁板綍鈥滃墠涓�鏃モ�濈殑閾佽矾銆佹皯鑸暟鎹悗锛屽亣鏈熺 1 鏃ョ殑閾佽矾銆佹皯鑸幆姣旀寜璇ユ暟鎹绠楋紱鍏矾銆佹按璺�佹�讳汉鍛樻祦鍔ㄩ噺鍦ㄧ 1 鏃ヤ粛涓嶈绠楃幆姣斻�� - 瀵煎嚭浠ユ簮宸ヤ綔绨夸负搴曠锛屽洖濉簱鍐呮暟鎹笌瀹㈣繍绯绘暟锛涘揩鎶ユ寜鏃ユ湡鐢熸垚 Word锛屽悓姣斿浐瀹氫娇鐢� 2025銆�2024 涓ゅ勾锛屼笉浣跨敤 2019 鏁版嵁銆� -- Gitblit v1.9.1