From 0c16e566fe10841921401cf7bf4d2ff71da41956 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期二, 01 九月 2026 11:03:54 +0800 Subject: [PATCH] docs: 年报导入模板文件入库（单位基本/法人财务/公路旅客能耗/公共汽电车/轨道车辆线路/轨道人员运营 6类） --- docs/database.md | 169 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 168 insertions(+), 1 deletions(-) diff --git a/docs/database.md b/docs/database.md index 11f29bf..b245236 100644 --- a/docs/database.md +++ b/docs/database.md @@ -211,7 +211,99 @@ | import_batch_id | bigint | 瀵煎叆鎵规 | | created_at | datetime | 鍒涘缓鏃堕棿 | + +### h2031_enterprise_monthly锛堜氦浼佺粺H203-1琛� 鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌锛� +> 鏁版嵁鏉ユ簮锛氬叕璺梾瀹㈣繍杈撴湀搴︾敓浜ф儏鍐�.xlsx 鐨勩�屽叕璺梾瀹�6鏈堟姤銆峴heet锛涘悓鏂囦欢銆岃繍鏀胯溅杈嗘暟銆峴heet 瀵煎叆 passenger_auth_vehicle + +| 瀛楁 | 绫诲瀷 | 璇存槑 | +|------|------|------| +| id | bigint | PK | +| report_period | varchar(20) | 鎶ヨ〃鏈� 2026-06 | +| region_code | varchar(20) | 鎵�灞炲湴鍖猴紙琛屾斂鍖哄垝浠ｇ爜锛� | +| enterprise_code | varchar(50) | 浼佷笟浠ｇ爜 | +| enterprise_name | varchar(200) | 浼佷笟鍚嶇О | +| vehicle_total | int | 瀹㈣繍杞﹁締_鎬昏 | +| seat_total | int | 鏍稿畾杞藉浣峗鎬昏 | +| vehicle_schedule | int | 杞﹁締鏁癬瀹㈣繍鐝溅锛堝惈瀹氱嚎鏃呮父锛� | +| seat_schedule | int | 鏍稿畾杞藉浣峗瀹㈣繍鐝溅锛堝惈瀹氱嚎鏃呮父锛� | +| vehicle_charter | int | 杞﹁締鏁癬瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓革級 | +| seat_charter | int | 鏍稿畾杞藉浣峗瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓革級 | +| passenger_total | double | 瀹㈣繍閲廮鎬昏锛堜汉锛� | +| turnover_total | double | 鏃呭鍛ㄨ浆閲廮鎬昏锛堜汉鍏噷锛� | +| passenger_class1 ~ passenger_class4 | double | 瀹㈣繍閲廮涓�~鍥涚被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛� | +| turnover_class1 ~ turnover_class4 | double | 鏃呭鍛ㄨ浆閲廮涓�~鍥涚被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛� | +| passenger_charter | double | 瀹㈣繍閲廮瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓革級 | +| turnover_charter | double | 鏃呭鍛ㄨ浆閲廮瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓革級 | +| avg_distance_total | double | 瀹㈣繍骞冲潎杩愯窛锛堝叕閲岋級 | +| avg_distance_class1 ~ avg_distance_class4 | double | 涓�~鍥涚被瀹㈣繍鐝嚎骞冲潎杩愯窛锛堝叕閲岋級 | +| avg_distance_charter | double | 鏃呮父銆佸寘杞﹀钩鍧囪繍璺濓紙鍏噷锛� | +| verify_explanation | text | 鏍稿疄鎬у師鍥犺В閲� | +| import_batch_id | bigint | 瀵煎叆鎵规 | +| created_at | datetime | 鍒涘缓鏃堕棿 | + +### passenger_auth_vehicle锛堝叕璺梾瀹㈣繍鏀胯溅杈嗘暟鎹級 +> 鏁版嵁鏉ユ簮锛氬叕璺梾瀹㈣繍杈撴湀搴︾敓浜ф儏鍐�.xlsx 鐨勩�岃繍鏀胯溅杈嗘暟銆峴heet锛堜紒涓氫唬鐮�/浼佷笟鍚嶇О/杞﹁締鏁�/杞藉浣嶆暟锛夛紝闅忔湀鎶ヤ竴璧锋寜鎶ヨ〃鏈熷鍏� + +| 瀛楁 | 绫诲瀷 | 璇存槑 | +|------|------|------| +| id | bigint | PK | +| report_period | varchar(20) | 鎶ヨ〃鏈� | +| enterprise_code | varchar(50) | 浼佷笟浠ｇ爜 | +| enterprise_name | varchar(200) | 浼佷笟鍚嶇О | +| vehicle_count | int | 杞﹁締鏁� | +| seat_count | int | 杞藉浣嶆暟 | +| import_batch_id | bigint | 瀵煎叆鎵规 | +| created_at | datetime | 鍒涘缓鏃堕棿 | + --- + +### h204_vehicle_quarterly锛堜氦浼佺粺H204琛� 閬撹矾璐ц繍杞﹁締鑳芥簮娑堣�楁儏鍐德疯溅杈嗙矑搴︼級 +> 鏁版嵁鏉ユ簮锛氶亾璺揣杩愯溅杈嗚兘婧愭秷鑰楁儏鍐碉紙2026骞达級.xlsx 鐨勩�岀浜屽搴﹁揣杞﹁兘鑰楁槑缁嗐�峴heet锛堟瘡琛屽乏鍙冲悇5缁勮溅杈嗐�佹瘡缁�18鍒楋級锛涘悓鏂囦欢銆岃繍鏀胯溅杈嗕俊鎭�峴heet 瀵煎叆 h204_auth_vehicle + +| 瀛楁 | 绫诲瀷 | 璇存槑 | +|------|------|------| +| id | bigint | PK | +| report_period | varchar(20) | 鎶ヨ〃鏈� 2026-06锛堝搴︽湯鏈堬級 | +| region_code | varchar(20) | 鎵�灞炲湴鍖猴紙琛屾斂鍖哄垝浠ｇ爜锛� | +| enterprise_code | varchar(50) | 浼佷笟浠ｇ爜 | +| enterprise_name | varchar(200) | 浼佷笟鍚嶇О | +| plate_no | varchar(30) | 杞︾墝鍙� | +| vehicle_type_code | varchar(10) | 杞﹁締绫诲瀷浠ｇ爜 | +| vehicle_type | varchar(50) | 杞﹁締绫诲瀷锛堜腑鏂囷級 | +| fuel_type_code | varchar(10) | 鐕冩枡绫诲瀷浠ｇ爜 | +| fuel_type | varchar(50) | 鐕冩枡绫诲瀷锛堜腑鏂囷級 | +| manufacture_year | int | 鍑哄巶骞翠唤 | +| marked_tonnage | double | 鏍囪鍚ㄤ綅锛堝惃锛� | +| total_mileage | double | 鎬昏绋嬶紙鍏噷锛� | +| loaded_mileage | double | 杞借揣閲岀▼锛堝叕閲岋級 | +| empty_mileage | double | 绌洪┒閲岀▼锛堝叕閲岋級 | +| freight | double | 璐ц繍閲忥紙鍚級 | +| turnover | double | 璐х墿鍛ㄨ浆閲忥紙鍚ㄥ叕閲岋級 | +| trip_count | int | 瓒熸鏁帮紙涓級 | +| fuel_unit | varchar(20) | 鐕冩枡1璁￠噺鍗曚綅 | +| fuel_consumption | double | 鐕冩枡1娑堣�楅噺 | +| avg_distance | double | 骞冲潎杩愯窛锛堝叕閲岋級 | +| avg_loaded_tonnage | double | 骞冲潎杞借揣鍚ㄤ綅锛堝惃锛� | +| avg_trip_mileage | double | 鍗曡稛骞冲潎閲岀▼锛堝叕閲岋級 | +| fuel_per_100km | double | 鐧惧叕閲屽崟鑰� | +| turnover_fuel | double | 鍛ㄨ浆閲忓崟鑰� | +| import_batch_id | bigint | 瀵煎叆鎵规 | +| created_at | datetime | 鍒涘缓鏃堕棿 | + +### h204_auth_vehicle锛堥亾璺揣杩愯兘鑰梍杩愭斂杞﹁締淇℃伅锛� +> 鏁版嵁鏉ユ簮锛氶亾璺揣杩愯溅杈嗚兘婧愭秷鑰楁儏鍐碉紙2026骞达級.xlsx 鐨勩�岃繍鏀胯溅杈嗕俊鎭�峴heet锛堣溅鐗屽彿/杞﹁締绫诲瀷/鐕冩枡绫诲瀷/鏍囪鍚ㄤ綅/鍑嗙壍寮曡川閲忥級锛岄殢瀛ｆ姤涓�璧锋寜鎶ヨ〃鏈熷鍏� + +| 瀛楁 | 绫诲瀷 | 璇存槑 | +|------|------|------| +| id | bigint | PK | +| report_period | varchar(20) | 鎶ヨ〃鏈� | +| plate_no | varchar(30) | 杞︾墝鍙� | +| vehicle_type | varchar(50) | 杞﹁締绫诲瀷锛堜腑鏂囷級 | +| fuel_type | varchar(50) | 鐕冩枡绫诲瀷锛堜腑鏂囷級 | +| marked_tonnage | double | 鏍囪鍚ㄤ綅锛堝惃锛� | +| traction_quality | double | 鍑嗙壍寮曡川閲忥紙鐗靛紩杞︽爣璁板惃浣嶏級 | +| import_batch_id | bigint | 瀵煎叆鎵规 | +| created_at | datetime | 鍒涘缓鏃堕棿 | ## 涓夈�佸鏍歌鍒欐ā鍧� @@ -232,13 +324,25 @@ | sort_order | int | 鎺掑簭 | | created_at | datetime | - | -Demo棰勭疆6鏉¤鍒欙細 +Demo棰勭疆14鏉¤鍒欙紙report_type 鍖哄垎 H2032 璐ц繍 / H2031 鏃呭锛夛細 + +璐ц繍 H2032 6鏉★細 1. 杞﹁締杩愭斂瀵规瘮锛圖IFF>5 鈫� RED锛� 2. 鍚ㄤ綅杩愭斂瀵规瘮锛圖IFF>50 鈫� RED锛� 3. 鍛ㄨ浆閲忚建杩瑰姣旓紙RATIO>1.3 鈫� RED锛� 4. 璐ц繍绫诲瀷鐜瘮锛圡OM 鈫� YELLOW锛� 5. 闆嗚绠卞紓甯革紙NULL_CHECK 鈫� RED锛� 6. 鏁磋溅鍚ㄤ綅鑼冨洿锛圤UT_RANGE 涓嶅湪4-40涔嬮棿 鈫� YELLOW锛� + +鏃呭 H2031 8鏉★紙compare_type 鏂板 MOM_EQ_ZERO/MOM_PCT/MOM_EQ/EXISTENCE锛夛細 +1. 杞﹁締鏁拌繍鏀垮姣旓紙DIFF>3 鈫� RED锛� +2. 杞藉浣嶆暟杩愭斂瀵规瘮锛圖IFF>50 鈫� RED锛� +3. 瀹㈣繍閲忕幆姣�=0锛堜竴~鍥涚被+鍖呰溅锛屽�间笌涓婃湀鐩稿悓 鈫� YELLOW锛� +4. 鏃呭鍛ㄨ浆閲忕幆姣�=0锛堝悓涓� 鈫� YELLOW锛� +5. 骞冲潎杩愯窛鐜瘮瓒吢�10%锛堜竴~鍥涚被 鈫� YELLOW锛� +6. 鍖呰溅骞冲潎杩愯窛绛変簬涓婃湀锛堚啋 YELLOW锛� +7. 鏃犵彮绾挎湁鐝嚎瀹㈣繍閲忥紙EXISTENCE 鈫� RED锛� +8. 鏃犲寘杞︽湁鍖呰溅瀹㈣繍閲忥紙EXISTENCE 鈫� RED锛� ## 鍥涖�佸鏍哥粨鏋滄ā鍧� @@ -278,6 +382,7 @@ |------|------|------| | 鐢熸垚_璐ц繍閲忓垎甯傚窞鏄庣粏.xlsx | freight_turnover_import + h2032_enterprise_monthly + scale_split_transport | 1-N鏈堟槑缁�+鍚屾瘮锛涜揣杩愰噺鍚堣=妯℃澘銆佽涓�=H2032銆佽涓�=鍚堣-瑙勪笂锛涘懆杞噺=鎷嗗垎琛� | | 鐢熸垚_璐ц繍閲忔帓鍚�.xlsx | freight_turnover_import + h2032_enterprise_monthly | 瑙勪笂=H2032绱銆佸悎璁�=妯℃澘绱銆佽涓�=鍚堣-瑙勪笂 | +| 鐢熸垚_鍏矾鏃呭鍒嗗競宸炴槑缁�.xlsx | h2031_enterprise_monthly锛堟寜甯傚窞姹囨�伙級 | 鏈堟姤锛堥�夊勾-鏈堬紝浠婂勾1-N鏈�+绱锛�/骞存姤锛堥�夊勾浠斤紝鍏ㄥ勾12涓湀+绱锛夛紱姣忔湡鍚綋骞�+杩�3骞村尯鍧椼�佸悇鏈堝悓姣斻�佺疮璁″悓姣旓紱鍩庨檯鍩庝埂鍏氦/宸℃父鍑虹/缃戠害杞﹀垪鏆傜暀绌� | | 鐢熸垚_鍛ㄨ浆閲忔帓鍚�.xlsx | scale_split_transport | 瑙勪笂/瑙勪笅/鍚堣鍛ㄨ浆閲忔帓鍚嶏紙鍚繝瀹炲鍏ョ殑鍏ㄧ渷琛岋級 | ## 鍏�佺郴缁熸棩蹇� @@ -314,3 +419,65 @@ | masked_value | varchar(200) | 鑴辨晱鍊� | | mask_type | varchar(20) | ENTERPRISE/REGION | | call_id | varchar(50) | 璋冪敤ID | + +## 鍏�佹姇璧勬ā鍧楋紙瀹㈣繍绔欏満 / 鐗╂祦鍥尯锛� + +> 鏁版嵁婧愶細鍏ㄧ渷姹囨�诲ぇ琛紙`7鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx` 鏄庣粏sheet銆乣6鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls` 鍒嗛」鐩姇璧勫畬鎴愭儏鍐祍heet锛夛紝瀹℃牳姣斿鍩哄噯涓烘姇璧勭郴缁熷鍑猴紙`鏌ヨ缁撴灉(鎶曡祫绯荤粺-瀹㈣繍+鐗╂祦 2026.7).xls`锛夈�� + +### investment_project锛堟姇璧勯」鐩富妗ｏ級 +| 瀛楁 | 绫诲瀷 | 璇存槑 | +|------|------|------| +| id | bigint | PK | +| project_name | varchar(200) | 椤圭洰鍚嶇О锛堜笌 category 缁勬垚鍞竴閿級 | +| category | varchar(20) | 瀹㈣繍绔欏満 / 鐗╂祦鍥尯 | +| city | varchar(50) | 甯傚窞 | +| county | varchar(100) | 鍘匡紙甯傘�佸尯锛� | +| builder_name | varchar(200) | 鎶曡祫寤鸿鍗曚綅 | +| construct_nature | varchar(50) | 寤鸿鎬ц川锛堟柊寤�/缁缓/鏀规墿寤猴級 | +| start_time / end_time | varchar(20) | 寮�宸� / 寤烘垚鏃堕棿 | +| total_investment | double | 璁″垝鎬绘姇璧勶紙涓囧厓锛� | +| approval_gk / approval_cs | varchar(500) | 宸ュ彲 / 鍒濊鎵瑰 | +| building_area | double | 寤虹瓚闈㈢Н锛堝钩鏂圭背锛岀墿娴佽〃锛� | +| is_billion / is_county / is_five_year | tinyint | 浜垮厓 / 缁忔祹寮哄幙 / 鍗佷簲浜旈噸鐐� 鍥哄畾鍚嶅崟鏍囪 | + +### investment_monthly锛堟姇璧勯」鐩湀搴﹀畬鎴愭儏鍐碉級 +| 瀛楁 | 绫诲瀷 | 璇存槑 | +|------|------|------| +| id | bigint | PK | +| report_period | varchar(20) | 鎶ヨ〃鏈� 2026-07 | +| project_id | bigint | 鍏宠仈 investment_project.id | +| year_plan | double | 鏈勾璁″垝鎶曡祫锛堜竾鍏冿級 | +| year_cum | double | 鑷勾鍒濈疮璁″畬鎴愭姇璧勶紙涓囧厓锛� | +| month_done | double | 鍏朵腑锛氭湰鏈堝畬鎴愭姇璧勶紙涓囧厓锛� | +| start_cum | double | 鑷紑濮嬪缓璁剧疮璁″畬鎴愭姇璧勶紙涓囧厓锛� | +| progress_stage | varchar(100) | 寤鸿闃舵 | +| progress_desc | varchar(2000) | 褰㈣薄杩涘害 | +| building_area | double | 寤虹瓚闈㈢Н锛堝钩鏂圭背锛� | + +### investment_system锛堟姇璧勭郴缁熷鍑郝峰鏍告瘮瀵瑰熀鍑嗭級 +| 瀛楁 | 绫诲瀷 | 璇存槑 | +|------|------|------| +| id | bigint | PK | +| report_period | varchar(20) | 鎶ヨ〃鏈� | +| project_name | varchar(200) | 椤圭洰鍚嶇О锛堝崟浣嶏級 | +| total_investment | double | 璁″垝鎬绘姇璧勶紙涓囧厓锛� | +| start_cum | double | 鑷紑濮嬪缓璁捐嚦鏈湀绱瀹屾垚鎶曡祫锛堜竾鍏冿級 | +| year_plan | double | 鏈勾璁″垝鎶曡祫锛堜竾鍏冿級 | +| year_cum | double | 鑷勾鍒濈疮璁″畬鎴愭姇璧勶紙涓囧厓锛� | +| month_done | double | 褰撴湀瀹屾垚鎶曡祫锛堜竾鍏冿級 | + +### 鎶曡祫瀹℃牳瑙勫垯锛坮eport_type=INVEST锛� +| 瑙勫垯 | 姣旇緝绫诲瀷 | 璇存槑 | +|------|---------|------| +| RULE_I001 鑷紑濮嬬疮璁″姣� | CROSS_DIFF | 缁濆宸�>100涓� 涓� 鐩稿宸�>5% | +| RULE_I002 鑷勾鍒濈疮璁″姣� | CROSS_DIFF | 缁濆宸�>50涓� 涓� 鐩稿宸�>5% | +| RULE_I003 鏈湀瀹屾垚瀵规瘮 | CROSS_DIFF | 缁濆宸�>30涓� 涓� 鐩稿宸�>30% | +| RULE_I004 绯荤粺缂哄け | EXISTENCE_SYS | 姹囨�诲ぇ琛ㄩ」鐩湪鎶曡祫绯荤粺瀵煎嚭涓笉瀛樺湪 | + +### 鎶曡祫 4 寮犻瀵兼姤琛紙ReportExportService锛� +| 绔偣 | 琛ㄥ悕 | 鏁版嵁 | +|------|------|------| +| /api/report/export/investPlan | 鍏ㄧ渷棰勫畨鎺掕鍒掕繘搴︽眹鎬� | 瀹㈣繍+鐗╂祦澶у潡銆�17甯傚窞灏忚妭+椤圭洰琛� | +| /api/report/export/investFiveYearLogistics | "鍗佷簲浜�"鐗╂祦椤圭洰杩涘睍 | 鍥哄畾鍚嶅崟杩囨护锛屽競宸炲皬鑺�+椤圭洰琛� | +| /api/report/export/investBillion | 浜垮厓鎶曡祫椤圭洰 | 鎶曡祫鎬昏〃 + 瑙勪笂椤圭洰琛ㄤ袱sheet锛屼嚎鍏冨悕鍗曡繃婊� | +| /api/report/export/investCounty | 缁忔祹寮哄幙鎶曡祫缁熻 | 缁忔祹寮哄幙鍚嶅崟杩囨护 | -- Gitblit v1.9.1