From fbacc121df810f01e5b6ed43e6431dea6df270fd Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期五, 02 十月 2026 10:04:06 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/main' --- docs/database.md | 69 ++++++++++++++++++++++++++++++++++ 1 files changed, 69 insertions(+), 0 deletions(-) diff --git a/docs/database.md b/docs/database.md index b245236..96057a4 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,66 @@ | /api/report/export/investFiveYearLogistics | "鍗佷簲浜�"鐗╂祦椤圭洰杩涘睍 | 鍥哄畾鍚嶅崟杩囨护锛屽競宸炲皬鑺�+椤圭洰琛� | | /api/report/export/investBillion | 浜垮厓鎶曡祫椤圭洰 | 鎶曡祫鎬昏〃 + 瑙勪笂椤圭洰琛ㄤ袱sheet锛屼嚎鍏冨悕鍗曡繃婊� | | /api/report/export/investCounty | 缁忔祹寮哄幙鎶曡祫缁熻 | 缁忔祹寮哄幙鍚嶅崟杩囨护 | + + +## 涔濄�佷笓椤圭粺璁�-閲嶈鑺傚亣鏃ユā鍧� + +> 鏁版嵁鏉ユ簮涓庢ā鏉匡細`docs/涓撻」缁熻/閲嶈鑺傚亣鏃�/2026骞村崄涓�鏁版嵁.xlsx`锛涘揩鎶ユā鏉匡細`docs/涓撻」缁熻/閲嶈鑺傚亣鏃�/婀栧寳鐪佸浗搴嗗亣鏈熺患鍚堣繍杈撳娴佸揩鎶ユā鏉�.docx`銆傞娆″惎鍔ㄤ細浠庡伐浣滅翱鍒濆鍖� 2024/2025 骞村崄涓�瀹㈡祦銆佽溅娴佹暟鎹紝骞跺垵濮嬪寲 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 | 绗嚑鏃ワ紝浠� 1 寮�濮� | +| created_at / updated_at | datetime | 鍒涘缓/鏇存柊鏃堕棿 | + +鍞竴閿細`(year, holiday_type, day_index)`銆乣(year, holiday_type, holiday_date)`銆備粎 admin 鍙�氳繃绯荤粺閰嶇疆鑿滃崟缁存姢銆� + +### 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) | 鏅�氬浗鐪侀亾鐜瘮鍩烘湡锛堜竾杈嗘锛屼粎褰撳勾浣跨敤锛� | + | 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 鍙�氳繃绯荤粺閰嶇疆鑿滃崟缁存姢銆� + +### 璁＄畻涓庡鍏ュ鍑哄彛寰� + - 闈炶惀涓氭�т汉鍛樻祦鍔ㄩ噺 =锛堥珮閫熻溅娴� + 鏅�氬浗鐪侀亾杞︽祦锛壝� 褰撳勾鑺傚亣鏃ュ杩愮郴鏁般�� + - 2026 骞存櫘閫氬浗鐪侀亾濡傚～鍐欑幆姣斿熀鏈燂紝鍒欏彧褰卞搷鏅�氬浗鐪侀亾杞︽祦閲忚嚜韬幆姣旓細濉啓鏃舵寜鈥滃綋鏃� / 鐜瘮鍩烘湡 - 1鈥濓紝鏈～鍐欐椂鎸夆�滃綋鏃� / 鍓嶄竴鏃� - 1鈥濓紱鎶樼畻浜哄憳娴佸姩閲忋�佹�讳汉鍛樻祦鍔ㄩ噺绛夌户缁寜 Excel 鍘熷叕寮忚绠椼��2024銆�2025 鍘嗗彶鏁版嵁涓嶄娇鐢ㄨ瀛楁銆� + - 鍏矾浜哄憳娴佸姩閲� = 閬撹矾钀ヤ笟鎬у杩愰噺 + 闈炶惀涓氭�т汉鍛樻祦鍔ㄩ噺銆� +- 鎬讳汉鍛樻祦鍔ㄩ噺 = 鍏矾 + 閾佽矾 + 姘戣埅 + 姘磋矾銆� +- 瀵煎叆鎸夆�滃勾浠� + 鑺傚亣鏃ュ垎绫烩�濊鍙� `holiday_calendar` 鐨勬棩鏈燂紝灏嗗伐浣滅翱鈥滅N鏃モ�濊瑕嗙洊鍐欏叆褰撳勾瀹㈡祦/杞︽祦锛涙棩甯稿彧璇诲彇鎵�閫夊勾浠界殑褰撳勾鍒楋紝鍘嗗彶骞翠唤浠呴娆″垵濮嬪寲銆� +- 瀵煎叆鍓嶆鏌ユ瘮鏈鏈�鏂板鍏ユ棩鏇存棭鐨勫巻鍙叉棩鏈熸槸鍚﹀彂鐢熷彉鍖栵紱濡傛湁鍙樺寲鍏堜笉鍐欏簱锛岃繑鍥炲樊寮傛竻鍗曪紝鐢ㄦ埛纭鍚庢墠鍏佽瑕嗙洊銆� +- 瀵煎嚭浠ユ簮宸ヤ綔绨夸负搴曠锛屽洖濉簱鍐呮暟鎹笌瀹㈣繍绯绘暟锛涘揩鎶ユ寜鏃ユ湡鐢熸垚 Word 骞舵浛鎹㈡ā鏉夸腑鐨勫綋鏃ャ�佺疮璁°�佺幆姣斿拰鍚屾瘮鍐呭銆� -- Gitblit v1.9.1