From 664cae654867b528ea339f187ebe290cb04d6fcf Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期四, 27 八月 2026 18:41:21 +0800 Subject: [PATCH] docs: 关机前交接——运行状态、待验证项、外置配置要点 --- docs/投资模块实施方案.md | 118 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 118 insertions(+), 0 deletions(-) diff --git "a/docs/\346\212\225\350\265\204\346\250\241\345\235\227\345\256\236\346\226\275\346\226\271\346\241\210.md" "b/docs/\346\212\225\350\265\204\346\250\241\345\235\227\345\256\236\346\226\275\346\226\271\346\241\210.md" new file mode 100644 index 0000000..ba1df1b --- /dev/null +++ "b/docs/\346\212\225\350\265\204\346\250\241\345\235\227\345\256\236\346\226\275\346\226\271\346\241\210.md" @@ -0,0 +1,118 @@ +# 鎶曡祫妯″潡瀹炴柦鏂规锛堝杩愮珯鍦� / 鐗╂祦鍥尯锛� + +> 鍩轰簬 `docs/鎵╁睍琛ㄦā鏉�/鎶曡祫/` 鍏ㄩ儴鏍蜂緥瀹炴媶鏁寸悊锛�2026-08-23锛� +> 缁撹鍏堣锛�**涓绘暟鎹簮璧�"鍏ㄧ渷姹囨�诲ぇ琛� + 甯傚窞涓婃姤琛ㄨВ鏋�"锛屾姇璧勭郴缁熷鍑轰粎浣滃鏍告瘮瀵�**锛涘缓璁垎涓ゆ湡钀藉湴锛岀涓�鏈熷厛璁� 4 寮犻瀵兼姤琛ㄨ窇閫氥�� + +## 涓�銆佹暟鎹簮瀹炴媶缁撹 + +### 1. 鎶曡祫绯荤粺鏌ヨ瀵煎嚭锛堟渶骞插噣锛屼絾瀛楁鏈�灏戯級 +`鏌ヨ缁撴灉(鎶曡祫绯荤粺-瀹㈣繍+鐗╂祦 2026.7).xls`锛�149 琛� 脳 8 鍒楋級锛� + +| 鍒� | 瀛楁 | 鏍蜂緥 | +|----|------|------| +| A | 琛屽彿 | 2 | +| B | 鍗曚綅锛堝嵆椤圭洰鍚嶇О锛� | 姹夊彛瀹㈣繍涓績 | +| C | 鏃舵湡 | 2026骞�7鏈� | +| D | 璁″垝鎬绘姇璧� | 315700 | +| E | 鑷紑濮嬪缓璁捐嚦鏈湀绱瀹屾垚鎶曡祫 | 177685.4 | +| F | 鏈勾璁″垝鎶曡祫 | 30000 | +| G | 鑷勾鍒濈疮璁″畬鎴愭姇璧� | 4000 | +| H | 褰撴湀瀹屾垚鎶曡祫 | 500 | + +- 浼樼偣锛氱粨鏋勫浐瀹氥�佹棤闇�瀹归敊瑙ｆ瀽銆� +- 灞�闄愶細**鏃犲競宸炪�佹棤杩涘害/褰㈣薄杩涘害/鎵瑰鏂囧彿**锛屽彧鑳芥敮鎾� 4 寮犺緭鍑鸿〃閲岀殑鏁板�煎垪锛屼笉瓒充互鐙珛鐢熸垚棰嗗鎶ヨ〃銆� + +### 2. 甯傚窞涓婃姤琛紙鏍煎紡涓嶇粺涓�锛岄渶瀹归敊瑙ｆ瀽锛� +- 瀹㈣繍绔欏満鏍蜂緥锛氬疁鏄� 18 鍒椼�佹眹鎬诲ぇ琛� 20 鍒楋紱鐗╂祦鏍蜂緥锛氶粍鐭� 23 鍒椼�佹眹鎬昏〃 24 鍒椼�� +- 鍏叡瀛楁锛堝垪浣嶇疆鍥犺〃鑰屽紓锛岄』鎸夎〃澶村叧閿瘝鍖归厤锛夛細 + 搴忓彿 / 椤圭洰鍚嶇О鍙婄珯绾� / 鎶曡祫寤鸿鍗曚綅 / 寤鸿鎬ц川锛堟柊寤�/缁缓/鏀规墿寤猴級/ 寮�宸ユ椂闂� / 绔ｅ伐鏃堕棿 / 璁″垝鎬绘姇璧� / 鑷紑濮嬪缓璁剧疮璁″畬鎴愭姇璧� / 鏈勾璁″垝鎶曡祫 / 鑷勾鍒濈疮璁″畬鎴愭姇璧� / 鍏朵腑鏈湀瀹屾垚鎶曡祫 / 寤鸿闃舵锛堝湪寤�/瀹屽伐/鍓嶆湡锛�/ 褰㈣薄杩涘害 / 宸ュ彲鎵瑰 / 鍒濊鎵瑰 / 寤虹瓚闈㈢Н / 鐢ㄥ伐浜烘暟銆� +- 鍒嗙粍琛岋細`涓�銆佷娇鐢ㄤ氦閫氶儴杞﹁喘绋庤祫閲戝缓璁鹃」鐩甡銆乣浜屻�佷娇鐢ㄧ渷鐕冩补绋庤繑杩樿祫閲戝缓璁鹃」鐩甡銆乣涓夈�佸啘鏉戠患鍚堣繍杈撴湇鍔＄珯/涓�鑸」鐩甡銆乣鍥涖�佸�欒溅浜�/鍐滄潙缁煎悎鏈嶅姟绔檂銆乣浜斻�佽鍒掑椤圭洰`锛涘競宸炲皬璁¤鍚�"灏忚/鍚堣"銆� +- 鏂囦欢娣峰瓨锛歚.xls / .xlsx / .et / .pdf`锛屾爣棰樿浣嶇疆涓嶄竴锛堥儴鍒嗘棤鏍囬鐩存帴鏄〃澶达級銆� + +### 3. 鍏ㄧ渷姹囨�讳腑闂磋〃锛堟帹鑽愪竴鏈熶富鍏ュ彛锛� +- `6鏈�/7鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx`锛氫袱 sheet锛堟槑缁� 121 琛� 脳 20 鍒� + 姹囨�伙級锛屽凡鏄叏鐪� 17 甯傚窞鍒嗙粍鍚堣缁撴瀯锛屾牸寮忕粺涓�銆� +- `6鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls`锛�4 sheet锛堟湀2 寤鸿瑙勬ā琛� / 鍒嗛」鐩姇璧勫畬鎴愭儏鍐� / 鍒嗗競宸炶鍒掑唴澶栭」鐩畬鎴愭儏鍐� / 甯傚窞姹囨�伙級锛屾牸寮忕粺涓�銆� + +### 4. 杈撳嚭 4 寮犺〃锛堢粰棰嗗锛岄渶姹傝 `姣忎釜鏈堝仛鍑鸿繖浜涘浐瀹氭牸寮忕殑琛紝缁欓瀵肩湅.txt`锛� +| # | 琛ㄥ悕 | 缁撴瀯 | 鍏抽敭鍙ｅ緞 | +|---|------|------|---------| +| 1 | 2026骞村叏鐪侀瀹夋帓璁″垝杩涘害鎯呭喌姹囨�� | 28 鍒楋紝鍙屽眰琛ㄥご锛涘悎璁�/瀹㈣繍绔欏満/鐗╂祦 澶у潡 + 17 甯傚窞灏忚 + 椤圭洰鏄庣粏 | 搴忓彿/甯傚窞/鍘垮尯/椤圭洰/鎬ц川/寤鸿鏃堕棿/鎬绘姇璧�/绱瀹屾垚/2026骞磋鍒�(鍚堣路閮风渷路鑷路杩涘害)/2026路2027寤鸿璁″垝/鍓嶆湡宸ヤ綔/1-N鏈堢疮璁″畬鎴�/瀹為檯杩涘害/鐪佽ˉ璧勯噾/澶囨敞 | +| 2 | "鍗佷簲浜�"瑙勫垝鐗╂祦椤圭洰杩涘睍 | 甯傚窞灏忚 + 椤圭洰鏄庣粏 | 搴忓彿/椤圭洰/浼佷笟/寮�宸�/瀹屽伐/鎬绘姇璧�/绱瀹屾垚/鏈湀瀹屾垚/杩涘害/杩涘睍鎻忚堪 | +| 3 | 婀栧寳鐪侊紙瀹㈣揣绔欏満锛変嚎鍏冩姇璧勯」鐩� | 2 sheet锛氭姇璧勬�昏〃(6鍒楀搴﹀彛寰�) + 瑙勪笂椤圭洰琛�(24鍒�) | 瑙勪笂椤圭洰锛氱渷浠�/甯傚窞/椤圭洰/绫诲埆/寤鸿鍐呭/鐘舵��/鎬ц川/寮�宸�/鎬绘姇璧�/绱/鍚勬湀璁″垝涓庡畬鎴愶紱**绛涢�夆墺1浜垮厓椤圭洰** | +| 4 | 锛堢粡娴庡己鍘块」鐩級浜ら�氱墿娴佸熀纭�璁炬柦鎶曡祫缁熻 | 17 鍒� | 搴忓彿/椤圭洰/浼佷笟/鎬绘姇璧�/绱瀹屾垚/鏈勾璁″垝/鑷勾鍒濈疮璁�/鏈湀瀹屾垚/杩涘害/杩涘睍/宸ュ彲鍒濊鎵瑰 | + +**娲炲療**锛�4 寮犺緭鍑鸿〃鏄悓涓�鎵归」鐩暟鎹殑 4 绉嶈瑙掞紙鍏ㄧ渷璁″垝鍏ㄦ櫙 / 鍗佷簲浜旂墿娴侀噸鐐� / 浜垮厓瑙勬ā浠ヤ笂 / 缁忔祹寮哄幙锛夛紝鎶戒竴濂楅」鐩富妗ｅ嵆鍙鐢ㄣ�� + +## 浜屻�佹暟鎹ā鍨嬶紙寤鸿 2 寮犺〃锛� + +### investment_project 椤圭洰涓绘。锛堟寜椤圭洰鍚�+绫诲瀷鍞竴锛� +| 瀛楁 | 璇存槑 | +|------|------| +| id / project_name | 涓婚敭 / 椤圭洰鍚嶇О锛堝敮涓�閿細project_name + category锛� | +| category | 瀹㈣繍绔欏満 / 鐗╂祦鍥尯 | +| city / county | 甯傚窞 / 鍘匡紙甯傘�佸尯锛� | +| construct_nature | 鏂板缓/缁缓/鏀规墿寤� | +| start_year / end_year | 寮�宸� / 绔ｅ伐鏃堕棿 | +| total_investment | 璁″垝鎬绘姇璧勶紙涓囧厓锛宒ouble锛� | +| approval_gk / approval_cs | 宸ュ彲 / 鍒濊鎵瑰鏂囧彿 | +| planned_level | 鏄惁 2026 棰勫畨鎺掕鍒掑唴 / "鍗佷簲浜�"閲嶇偣 / 浜垮厓椤圭洰鏍囪 | +| source | 鏁版嵁鏉ユ簮锛堝叏鐪佹眹鎬昏〃/甯傚窞鎶ヨ〃/绯荤粺瀵煎嚭锛� | + +### investment_monthly 鏈堝害瀹屾垚琛紙report_period + project_id锛� +| 瀛楁 | 璇存槑 | +|------|------| +| report_period | 鎶ヨ〃鏈� 2026-07 | +| project_id | 鍏宠仈涓绘。 | +| year_plan | 鏈勾璁″垝鎶曡祫 | +| year_cum | 鑷勾鍒濈疮璁″畬鎴愭姇璧� | +| month_done | 褰撴湀瀹屾垚鎶曡祫 | +| start_cum | 鑷紑濮嬪缓璁剧疮璁″畬鎴愭姇璧� | +| progress_stage / progress_desc | 寤鸿闃舵 / 褰㈣薄杩涘害 | +| building_area | 寤虹瓚闈㈢Н锛堝杩愯〃锛� | + +> 鎶ヨ〃鏈熶互椤甸潰閫夋嫨涓哄噯锛涢噾棰�/闈㈢Н缁熶竴 double 瀛樺偍锛屼笉鍋� BigDecimal銆� + +## 涓夈�佸鍏ヨ璁★紙涓ゆ湡锛� + +### 涓�鏈燂細鍏ㄧ渷姹囨�诲ぇ琛� + 绯荤粺瀵煎嚭锛堝揩閫熻窇閫� 4 寮犺〃锛� +- 鏂板瀵煎叆绫诲瀷"鎶曡祫鏈堟姤"锛氭敮鎸� `6鏈�/7鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx`锛堟槑缁� sheet锛変笌 `6鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls`锛堝垎椤圭洰鎶曡祫瀹屾垚鎯呭喌 sheet锛変袱绫荤粺涓�鏍煎紡銆� +- 瑙ｆ瀽瑕佺偣锛氳烦杩囧垎缁勮/灏忚琛岋紙鍏抽敭璇嶏細甯傚窞鍚�+鏁板瓧鍒椼�乣灏忚/鍚堣`銆乣涓�銆佷簩銆佷笁鈥锛夛紝璇嗗埆椤圭洰鏄庣粏琛岋紱琛ㄥご鎸夊叧閿瘝鏄犲皠鍒椼�� +- 骞傜瓑锛氬悓鎶ヨ〃鏈熷垹闄ゆ棫鏁版嵁锛堜富妗ｆ寜鍚� upsert锛屾湀搴﹁〃鎸� period 鍒犻櫎閲嶅缓锛夈�� +- 鍚屾椂瀵煎叆 `鏌ヨ缁撴灉(鎶曡祫绯荤粺鈥�).xls` 浣滀负瀹℃牳姣斿鍩哄噯锛堝瓨 `investment_system` 琛ㄦ垨鐩存帴瀹℃牳鏃惰鏂囦欢鈫掑缓璁瓨琛級銆� + +### 浜屾湡锛�17 甯傚窞鍗曡〃瀹归敊瑙ｆ瀽 +- 瑙ｆ瀽鍣ㄤ笁绾у閿欙細鈶犳寜鍏抽敭璇嶅畾浣嶈〃澶磋锛坄椤圭洰鍚嶇О`+`鎬绘姇璧刞锛夆啋 鈶℃寜琛ㄥご鍏抽敭璇嶆槧灏勫垪锛坄璁″垝.*鎬绘姇璧刞鈫掓�绘姇璧勭瓑锛夆啋 鈶㈠垎缁�/灏忚琛岃繃婊ゃ�� +- 鏍煎紡娉ㄥ唽琛細姣忕甯傚窞鏍煎紡 = 涓�涓В鏋愬櫒閰嶇疆锛堝垪鏄犲皠 + 鏍囬琛屽亸绉� + 璺宠繃琛屾ā寮忥級锛屾柊澧炴牸寮忓姞閰嶇疆涓嶆敼浠ｇ爜銆� +- 鏀寔 `.xls/.xlsx`锛沗.et`锛圵PS锛変笌 `.pdf` 鍏堟彁绀�"璇峰彟瀛樹负 xls/xlsx"銆� + +## 鍥涖�佸鏍歌鍒欙紙瑙勫垯琛ㄩ┍鍔紝report_type=INVEST锛� +| 瑙勫垯 | 姣旇緝绫诲瀷 | 璇存槑 | +|------|---------|------| +| 涓庢姇璧勭郴缁熸暟瀵规瘮 | CROSS_DIFF | 璁″垝鎬绘姇璧�/鑷勾鍒濈疮璁�/褰撴湀瀹屾垚 涓庣郴缁熷鍑哄樊寮傝秴闃堝�硷紙濡傛�绘姇璧�>5% 鎴栫粷瀵瑰樊>100涓囷級 | +| 瀹屾垚瓒呰鍒� | RANGE | 褰撴湀瀹屾垚 > 鏈勾璁″垝鍓╀綑锛涚疮璁″畬鎴� > 璁″垝鎬绘姇璧劽�1.05 | +| 杩涘害鐭涚浘 | LOGIC | 闃舵=瀹屽伐浣嗗畬鎴愮巼<1锛涢樁娈�=鍦ㄥ缓浣嗙疮璁�=0 | +| 蹇呭～缂哄け | NULL_CHECK | 椤圭洰鍚�/鎬绘姇璧�/绱瀹屾垚 涓虹┖ | + +## 浜斻�佹姤琛ㄧ敓鎴愶紙澶嶇敤鐜版湁瀵煎嚭妗嗘灦锛� +- 4 涓鐐癸細`/api/report/export/investPlan`锛堥瀹夋帓璁″垝琛級銆乣investFiveYearLogistics`锛堝崄浜斾簲鐗╂祦锛夈�乣investBillion`锛堜嚎鍏冮」鐩紝鍚姇璧勬�昏〃+瑙勪笂椤圭洰琛ㄤ袱 sheet锛夈�乣investCounty`锛堢粡娴庡己鍘胯〃锛夈�� +- 鍔ㄦ�佹湀浠斤細`period=2026-07` 鈫� 鏍囬/鍒楀ご鐢� `1-7鏈堢疮璁锛涘競宸為『搴忔部鐢� `RegionUtil.cityList()`銆� +- 浜垮厓椤圭洰琛細鎸� `total_investment 鈮� 10000 涓囧厓` 绛涢�夛紱鎶曡祫鎬昏〃鎸夊搴﹀彛寰勪粠鏈堝害瀹屾垚鎺ㄥ锛堜竴瀛ｅ害=1-3鏈堛�佷簩瀛ｅ害=4-6鏈堚�︼級銆� + +## 鍏�佸墠绔� +- `DataImport.vue`锛氭柊澧�"鎶曡祫鏈堟姤"锛堝叏鐪佹眹鎬诲ぇ琛級涓�"鎶曡祫绯荤粺瀵煎嚭"涓ょ瀵煎叆绫诲瀷銆� +- `ReportExport.vue`锛氭柊澧�"鎶曡祫鎶ヨ〃锛圛NVEST锛�"鍗＄墖锛�4 涓敓鎴愭寜閽�� +- `AuditResult.vue`锛氭姤琛ㄧ被鍨嬪鍔�"鎶曡祫鏈堟姤"锛堝彲閫夛紝浜屾湡锛夈�� + +## 涓冦�侀噷绋嬬涓庡伐浣滈噺锛堝崟浜猴級 +| 閲岀▼纰� | 鍐呭 | 宸ヤ綔閲� | +|--------|------|--------| +| M1 | 鍏ㄧ渷姹囨�诲ぇ琛ㄥ鍏� + 涓绘。/鏈堝害琛� + 4 寮犳姤琛ㄨ緭鍑� | 鍚庣 4~5 浜哄ぉ + 鍓嶇 1~2 浜哄ぉ | +| M2 | 甯傚窞鍗曡〃瀹归敊瑙ｆ瀽 + 绯荤粺瀵煎嚭姣斿瀹℃牳 | 鍚庣 4~6 浜哄ぉ | +| M3 | 鍓嶇鍏ュ彛鏁村悎 + 鑱旇皟锛堜笌甯傚窞鏍稿 6/7 鏈堟牱渚嬶級 | 2~3 浜哄ぉ | + +> 涓嶅惈闇�姹傜‘璁や笌鏁版嵁鍙ｅ緞鏍稿疄锛涘缓璁� M1 瀹屾垚鍗宠鐢ㄦ埛鐢� 6/7 鏈堟牱渚嬫牳瀵� 4 寮犺緭鍑鸿〃涓庣幇鏈� Excel 鏄惁涓�鑷淬�� + +## 鍏�佸緟鐢ㄦ埛纭鐨勭偣 +1. 涓绘暟鎹簮锛氬厛浠�"鍏ㄧ渷姹囨�诲ぇ琛�"涓哄噯锛圡1锛夛紝杩樻槸鐩存帴涓�"甯傚窞鍗曡〃瑙ｆ瀽"锛� +2. 绯荤粺瀵煎嚭鏄惁姣忔湀閮芥湁锛堝彲浣滄瘮瀵瑰熀鍑嗭級锛熸槸鍚︽彁渚涢」鐩�-甯傚窞瀵圭収锛堢郴缁熷鍑烘棤甯傚窞瀛楁锛夛紵 +3. 浜垮厓椤圭洰绛涢�夊彛寰勶細鈮�1 浜匡紙10000 涓囷級鏄惁鍑嗙‘锛熺粡娴庡己鍘块」鐩竻鍗曟槸鍚︽湁鍥哄畾鍚嶅崟锛� \ No newline at end of file -- Gitblit v1.9.1