From 54e10aee11aa4a10926df02782ca07d41eeb9b98 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期二, 06 十月 2026 16:19:07 +0800
Subject: [PATCH] fix(holiday): 加大折线图纵向间距并同步 Word 尺寸

---
 docs/database.md |   71 +++++++++++++++++++++++++++++++++++
 1 files changed, 71 insertions(+), 0 deletions(-)

diff --git a/docs/database.md b/docs/database.md
index b245236..042b269 100644
--- a/docs/database.md
+++ b/docs/database.md
@@ -222,6 +222,8 @@
 | region_code | varchar(20) | 鎵�灞炲湴鍖猴紙琛屾斂鍖哄垝浠ｇ爜锛� |
 | enterprise_code | varchar(50) | 浼佷笟浠ｇ爜 |
 | enterprise_name | varchar(200) | 浼佷笟鍚嶇О |
+| unified_credit_code | varchar(50) | 缁熶竴绀句細淇＄敤浠ｇ爜锛堟柊鐗堟ā鏉挎柊澧炲垪锛涜�佹ā鏉挎棤姝ゅ垪鏃朵负 NULL锛� |
+| report_unit | varchar(200) | 濉姤鍗曚綅锛堟柊鐗堟ā鏉挎柊澧炲垪锛涜�佹ā鏉挎棤姝ゅ垪鏃朵负 NULL锛� |
 | vehicle_total | int | 瀹㈣繍杞﹁締_鎬昏 |
 | seat_total | int | 鏍稿畾杞藉浣峗鎬昏 |
 | vehicle_schedule | int | 杞﹁締鏁癬瀹㈣繍鐝溅锛堝惈瀹氱嚎鏃呮父锛� |
@@ -411,6 +413,10 @@
 
 ## 涓冦�丩LM鑴辨晱鏄犲皠
 
+> **瀹炵幇璇存槑锛�2026-09-14 鏇存柊锛�**锛氬綋鍓嶅疄闄呯敓鏁堢殑鑴辨晱鏄�**鍐呭瓨鎬�**鐨勨�斺�擿DesensitizeService` 鍦ㄦ暟鎹鍙戝墠鎶婁紒涓氬悕绉版浛鎹负 `Company1`銆乣Company2`鈥︼紝鍥炵瓟杩斿洖鍓嶅啀杩樺師锛屾槧灏勫彧瀛樺湪杩涚▼鍐呭瓨涓�佷笉钀藉簱銆�
+> 鍏蜂綋鍋氭硶锛欰I 鏌ュ簱锛坄query_database`锛夌粨鏋滃洖濉粰澶фā鍨嬪墠锛屼紒涓氬悕绉扮粺涓�鎹㈠埆鍚嶏紝鑷敱鏂囨湰閲岀殑浼佷笟鍚嶇О涓庢墜鏈哄彿涓�骞跺鐞嗭紱`contact_person`锛堝～琛ㄤ汉锛夈�乣contact_phone`锛堣仈绯荤數璇濓級銆乣unified_credit_code`锛堢粺涓�绀句細淇＄敤浠ｇ爜锛夈�乣unit_leader`銆乣stats_leader`銆乣report_unit`銆乣enterprise_code` 鐩存帴浠�"鍙煡鍒�"涓墧闄わ紝AI 鏃㈡煡涓嶅埌涔熶笉鑳戒綔涓鸿繃婊�/鎺掑簭鏉′欢銆�
+> 涓嬭〃 `llm_desensitize_map` 涓�**棰勭暀**鐨勮惤搴撶増鏄犲皠琛紝鐩墠浠ｇ爜鏈紩鐢ㄣ�佽〃涓虹┖锛涜嫢鍚庣画闇�瑕佺暀瀛樿劚鏁忓璁＄棔杩瑰啀鍚敤銆�
+
 ### llm_desensitize_map 鑴辨晱鏄犲皠琛�
 | 瀛楁 | 绫诲瀷 | 璇存槑 |
 |------|------|------|
@@ -481,3 +487,68 @@
 | /api/report/export/investFiveYearLogistics | "鍗佷簲浜�"鐗╂祦椤圭洰杩涘睍 | 鍥哄畾鍚嶅崟杩囨护锛屽競宸炲皬鑺�+椤圭洰琛� |
 | /api/report/export/investBillion | 浜垮厓鎶曡祫椤圭洰 | 鎶曡祫鎬昏〃 + 瑙勪笂椤圭洰琛ㄤ袱sheet锛屼嚎鍏冨悕鍗曡繃婊� |
 | /api/report/export/investCounty | 缁忔祹寮哄幙鎶曡祫缁熻 | 缁忔祹寮哄幙鍚嶅崟杩囨护 |
+
+
+## 涔濄�佷笓椤圭粺璁�-閲嶈鑺傚亣鏃ユā鍧�
+
+> 鏁版嵁鏉ユ簮涓庢ā鏉匡細`docs/涓撻」缁熻/閲嶈鑺傚亣鏃�/2026骞村崄涓�鏁版嵁.xlsx`锛涘揩鎶ユā鏉匡細`docs/涓撻」缁熻/閲嶈鑺傚亣鏃�/婀栧寳鐪佸浗搴嗗亣鏈熺患鍚堣繍杈撳娴佸揩鎶ユā鏉�.docx`銆傞娆″惎鍔ㄤ細浠庡伐浣滅翱鍒濆鍖� 2024/2025 骞村崄涓�瀹㈡祦銆佽溅娴佹暟鎹��2024-2026 骞撮搧璺�/姘戣埅鍓嶄竴鏃ユ暟鎹��2019 骞撮亾璺暟鎹紝骞跺垵濮嬪寲 2024-2026 骞村杩愮郴鏁般��
+
+### holiday_calendar 鑺傚亣鏃ユ棩鏈熼厤缃�
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| id | bigint | PK |
+| year | int | 骞翠唤 |
+| holiday_type | varchar(32) | 鏄ヨ妭 SPRING_FESTIVAL / 浜斾竴 LABOR_DAY / 鍗佷竴 NATIONAL_DAY |
+| holiday_date | date | 鑺傚亣鏃ュ叿浣撴棩鏈� |
+| day_index | int | 0=鍓嶄竴鏃ワ紝1..N=鍋囨湡绗� N 鏃� |
+| created_at / updated_at | datetime | 鍒涘缓/鏇存柊鏃堕棿 |
+
+鍞竴閿細`(year, holiday_type, day_index)`銆乣(year, holiday_type, holiday_date)`銆備粎 admin 鍙�氳繃绯荤粺閰嶇疆鑿滃崟缁存姢锛沗day_index=0` 鐢ㄤ簬閾佽矾銆佹皯鑸殑鍓嶄竴鏃ョ幆姣斿熀鏁般��
+
+### holiday_passenger_flow 鑺傚亣鏃ョ患鍚堣繍杈撹惀涓氭�у娴�
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| id | bigint | PK |
+| year | int | 骞翠唤 |
+| flow_date | date | 鏃ユ湡 |
+| transport_mode | varchar(32) | 閾佽矾 RAIL / 姘戣埅 CIVIL_AVIATION / 閬撹矾 ROAD / 姘磋矾 WATER |
+| passenger_count | decimal(30,15) | 鍙戦�佹梾瀹㈡暟锛堜竾浜烘锛� |
+| created_at / updated_at | datetime | 鍒涘缓/鏇存柊鏃堕棿 |
+
+鍞竴閿細`(year, flow_date, transport_mode)`銆�
+
+### holiday_vehicle_flow 鑺傚亣鏃ョ患鍚堣繍杈撻潪钀ヤ笟鎬ц溅娴�
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| id | bigint | PK |
+| year | int | 骞翠唤 |
+| flow_date | date | 鏃ユ湡 |
+| 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) | 鏅�氬浗鐪侀亾鐜瘮鍩烘湡锛堜竾杈嗘锛屼汉宸ュ鐢ㄥ�硷紝浠� 2026 骞村惎鐢ㄣ�佷笉鍙備笌璁＄畻锛� |
+  | created_at / updated_at | datetime | 鍒涘缓/鏇存柊鏃堕棿 |
+
+鍞竴閿細`(year, flow_date, road_category, vehicle_type)`銆�
+
+### holiday_passenger_coefficient 瀹㈣繍绯绘暟閰嶇疆
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| id | bigint | PK |
+| year | int | 骞翠唤 |
+| date_category | varchar(32) | 鑺傚亣鏃� HOLIDAY / 闈炶妭鍋囨棩 NON_HOLIDAY |
+| coefficient | decimal(30,15) | 瀹㈣繍绯绘暟 |
+| created_at / updated_at | datetime | 鍒涘缓/鏇存柊鏃堕棿 |
+
+鍞竴閿細`(year, date_category)`銆備粎 admin 鍙�氳繃绯荤粺閰嶇疆鑿滃崟缁存姢銆�
+
+### 璁＄畻涓庡鍏ュ鍑哄彛寰�
+  - 闈炶惀涓氭�т汉鍛樻祦鍔ㄩ噺 =锛堥珮閫熻溅娴� + 鏅�氬浗鐪侀亾杞︽祦锛壝� 褰撳勾鑺傚亣鏃ュ杩愮郴鏁般��
+  - 鏅�氬浗鐪侀亾鐜瘮鍥哄畾鎸夆�滃綋鏃� / 鍓嶄竴鏃� - 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 骞� 10 鏈� 1-8 鏃ョ殑 `holiday_calendar` 閰嶇疆鐢ㄤ簬鍦ㄧ郴缁熼厤缃拰鑺傚亣鏃ョ粺璁￠〉鏌ョ湅璇ュ巻鍙插熀绾裤��
+- 瀵煎叆鍓嶆鏌ユ瘮鏈鏈�鏂板鍏ユ棩鏇存棭鐨勫巻鍙叉棩鏈熸槸鍚﹀彂鐢熷彉鍖栵紱濡傛湁鍙樺寲鍏堜笉鍐欏簱锛岃繑鍥炲樊寮傛竻鍗曪紝鐢ㄦ埛纭鍚庢墠鍏佽瑕嗙洊銆�
+- 璁板綍鈥滃墠涓�鏃モ�濈殑閾佽矾銆佹皯鑸暟鎹悗锛屽亣鏈熺 1 鏃ョ殑閾佽矾銆佹皯鑸幆姣旀寜璇ユ暟鎹绠楋紱鍏矾銆佹按璺�佹�讳汉鍛樻祦鍔ㄩ噺鍦ㄧ 1 鏃ヤ粛涓嶈绠楃幆姣斻��
+- 瀵煎嚭浠ユ簮宸ヤ綔绨夸负搴曠锛屽洖濉簱鍐呮暟鎹笌瀹㈣繍绯绘暟锛涘揩鎶ユ寜鏃ユ湡鐢熸垚 Word锛屽悓姣斿浐瀹氫娇鐢� 2025銆�2024 涓ゅ勾锛屼笉浣跨敤 2019 鏁版嵁銆�

--
Gitblit v1.9.1