From c085e6fa1cb24f0173b500488ecd192dd2ae624f Mon Sep 17 00:00:00 2001
From: 1697371125@qq.com <wei1697371125>
Date: 星期五, 25 十二月 2020 15:13:50 +0800
Subject: [PATCH] 增加解释及库表说明

---
 api.md |  209 ++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 176 insertions(+), 33 deletions(-)

diff --git a/api.md b/api.md
index ee1c1cc..15b4efb 100644
--- a/api.md
+++ b/api.md
@@ -10,7 +10,7 @@
 &nbsp; &nbsp; [ 2.3鍏昏�佹満鏋勭粺璁(#2.3)  
 &nbsp; &nbsp; [ 2.4鏈嶅姟瀵硅薄缁熻](#2.4)  
 [3.琛ヨ创](#3)  
- &nbsp; &nbsp; [ 3.1鑾峰彇鎬荤粺璁℃暟鎹甝(#3.1)  
+ &nbsp; &nbsp; [ 3.1鑾峰彇鎬荤粺璁℃暟鎹�--鏌ubsidy_log琛╙(#3.1)  
  &nbsp; &nbsp; [ 3.2骞村害鏈堝害缁熻鏁版嵁](#3.2)  
 [4.鏈嶅姟瀵硅薄](#4)  
 &nbsp; &nbsp; [ 4.1鑾峰彇缁熻鏁版嵁](#4.1)  
@@ -33,7 +33,16 @@
 &nbsp; &nbsp; [ 7.4 鍎跨绂忓埄](#7.4)  
 &nbsp; &nbsp; [ 7.5 缁煎悎鍒嗘瀽](#7.5)  
 &nbsp; &nbsp; [ 7.6 鍖哄煙鍦板悕](#7.6)  
-
+[8.搴撹〃](#8)  
+&nbsp; &nbsp; [ 8.1 鍖哄煙](#8.1)  
+&nbsp; &nbsp; [ 8.2 鏈嶅姟璇︽儏-鍗虫湇鍔¢」](#8.2)  
+&nbsp; &nbsp; [ 8.3 鏈嶅姟瀵硅薄](#8.3)  
+&nbsp; &nbsp; [ 8.4 鏈嶅姟浜哄憳](#8.4)  
+&nbsp; &nbsp; [ 8.5 璁㈠崟](#8.5)  
+&nbsp; &nbsp; [ 8.6 鏈嶅姟鏈烘瀯](#8.6)  
+&nbsp; &nbsp; [ 8.7 鍏昏�佹満鏋刔(#8.7)  
+&nbsp; &nbsp; [ 8.8 琛ヨ创鏃ュ織](#8.8)  
+&nbsp; &nbsp; [ 8.9 琛ヨ创浜哄憳](#8.9)  
 
 <h3 id='1'>涓�銆侀�氱敤</h2>
 <h4 id='1.1'>1.1鑾峰彇鎵�鏈夊尯鍩熸帴鍙�</h4>
@@ -341,10 +350,11 @@
 <h3 id='3'>涓夈�佽ˉ璐�</h2>
 <h4 id='3.1'>3.1鑾峰彇鎬荤粺璁℃暟鎹�</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鏍规嵁鍖哄煙id鍜岃ˉ璐寸被鍨嬭幏鍙栨�荤殑缁熻鏁版嵁
+> 鏍规嵁鍖哄煙id鍜岃ˉ璐寸被鍨嬭幏鍙栨�荤殑缁熻鏁版嵁<br>
+> 鏌ubsidy_log琛�   鍏朵腑鐜瘮鍚屾瘮鍙婂鍚堟暟鍙婄鍚堢巼  涓烘帴鍙h繑鍥炵殑闅忔満鏁�
 
 ###### URL
-> /api/subsidy/getTotalStatistics
+> /api2/subsidy/getTotalStatistics
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -363,6 +373,12 @@
 |:-----   |:------|:-----------------------------   |
 | totalPersonNum  |  int  |  鑾峰彇琛ヨ创鐨勬�讳汉鏁� |
 | fwPersonCount  |  double  |  鎬婚噾棰� |
+| hb1  |  int  |  琛ヨ创鎬讳汉鏁帮紝鐜瘮澧為暱 |
+| tb1  |  int  |  琛ヨ创鎬讳汉鏁帮紝鍚屾瘮澧為暱 |
+| hb2  |  int  |  琛ヨ创鎬婚噾棰濓紝鐜瘮澧為暱 |
+| tb2  |  int  |  琛ヨ创鎬婚噾棰濓紝鍚屾瘮澧為暱 |
+| fh1  |  int  |  澶嶅悎鏁� |
+| fh2  |  int  |  绗﹀悎鐜� |
 
 ###### 鎺ュ彛绀轰緥
 ``` java
@@ -373,16 +389,23 @@
     "timestamp": 1607648976798,
     "result": {
         "totalPersonNum": 1,
-        "totalMoney": 100
+        "totalMoney": 100,
+		"hb1": 1,
+		"tb1": 100,
+		"hb2": 1,
+		"tb2": 100,
+		"fh1": 1,
+		"fh2": 100,
     }
 }
 ``` 
 <h4 id='3.2'>3.2骞村害鏈堝害缁熻鏁版嵁</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鏍规嵁鍖哄煙id鍜岃ˉ璐寸被鍨嬭幏鍙栧勾搴︽湀搴︾粺璁℃暟鎹�
+> 鏍规嵁鍖哄煙id鍜岃ˉ璐寸被鍨嬭幏鍙栧勾搴︽湀搴︾粺璁℃暟鎹�<br>
+> 鏌ubsidy_log琛�  鏍规嵁琛ㄤ腑瀛楁areaId 鍜�12涓被鍨嬪搴旂殑type鏌ヨ
 
 ###### URL
-> /api/subsidy/getStatistics
+> /api2/subsidy/getStatistics
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -431,7 +454,9 @@
 <h3 id='4'>鍥涖�佹湇鍔″璞�</h2>
 <h4 id='4.1'>4.1鑾峰彇缁熻鏁版嵁</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鏍规嵁鍖哄煙id鍜岃ˉ璐寸被鍨嬭幏鍙栨�荤殑缁熻鏁版嵁
+> 鏍规嵁鍖哄煙id鍜岃ˉ璐寸被鍨嬭幏鍙栨�荤殑缁熻鏁版嵁----琛ヨ创浜哄憳琛╯ubsidy_person_statics,姣忔湀鍙繘琛屼竴娆℃彃鍏ユ暟鎹�<br>
+> 瀵瑰簲鍥句笂鏈嶅姟瀵硅薄鎬绘暟妯″潡涓唴瀹瑰強楗煎浘鏁版嵁<br>
+> 鐜板湪涓烘帴鍙f斁鍥炵殑闅忔満鏁版病鏈夎繘琛岀湡瀹炴煡琛�
 
 ###### URL
 > /api2/fwdx/getStaticsData
@@ -527,7 +552,9 @@
 ``` 
 <h4 id='4.2'>4.2鑾峰彇鍘嗗彶缁熻鏁版嵁</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鏍规嵁鍖哄煙id鍜岃ˉ璐寸被鍨嬭幏鍙栬幏鍙栧巻鍙茬粺璁℃暟鎹�
+> 鏍规嵁鍖哄煙id鍜岃ˉ璐寸被鍨嬭幏鍙栬幏鍙栧巻鍙茬粺璁℃暟鎹�----琛ヨ创浜哄憳琛╯ubsidy_person_statics,姣忔湀鍙繘琛屼竴娆℃彃鍏ユ暟鎹�<br>
+> 瀵瑰簲鍥句笅閮ㄤ袱涓富绾垮浘鏁版嵁<br>
+> 鐜板湪涓烘帴鍙f斁鍥炵殑闅忔満鏁版病鏈夎繘琛岀湡瀹炴煡琛�
 
 ###### URL
 > /api2/fwdx/getHistoryStaticsData
@@ -591,10 +618,10 @@
 <h3 id='5'>浜斻�佹湇鍔℃満鏋�</h2>
 <h4 id='5.1'>5.1鏍规嵁鍖哄煙id鑾峰彇鍖哄煙涓嬫墍鏈夋満鏋勫拰浜哄憳鏁伴噺浠ュ強璁㈠崟鎬绘暟</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鏍规嵁鍖哄煙id鑾峰彇鍖哄煙涓嬫墍鏈夋満鏋勫拰浜哄憳鏁伴噺浠ュ強璁㈠崟鎬绘暟
-
+> 鏍规嵁鍖哄煙id鑾峰彇鍖哄煙涓嬫墍鏈夋満鏋勫拰浜哄憳鏁伴噺浠ュ強璁㈠崟鎬绘暟<br>
+> 鏈嶅姟鏈烘瀯琛╫rg_fuwu,鏈嶅姟浜哄憳琛╢uwu_person,璁㈠崟琛╫rder
 ###### URL
-> /api/fwjg/getCountByAreaId
+> /api2/fwjg/getCountByAreaId
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -632,10 +659,11 @@
 ``` 
 <h4 id='5.2'>5.2鏍规嵁鍖哄煙id鑾峰彇鍖哄煙涓嬫墍鏈夋湇鍔′互鍙婃湇鍔¤鎯呭拰璁㈠崟浜烘暟</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鏍规嵁鍖哄煙id鑾峰彇鍖哄煙涓嬫墍鏈夋満鏋勫拰浜哄憳鏁伴噺浠ュ強璁㈠崟鎬绘暟
+> 鏍规嵁鍖哄煙id鑾峰彇鍖哄煙涓嬫墍鏈夋満鏋勫拰浜哄憳鏁伴噺浠ュ強璁㈠崟鎬绘暟<br>
+> 鏈嶅姟璇︽儏琛╢uwu_details, 璁㈠崟琛╫rder
 
 ###### URL
-> /api/fwjg/getFwnlByAreaId
+> /api2/fwjg/getFwnlByAreaId
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -740,10 +768,11 @@
 ``` 
 <h4 id='5.3'>5.3 鏈嶅姟鏈烘瀯璁㈠崟閲�</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鏈嶅姟鏈烘瀯璁㈠崟閲�
+> 鏈嶅姟鏈烘瀯璁㈠崟閲�<br>
+> 鏈嶅姟鏈烘瀯琛╫rg_fuwu,璁㈠崟琛╫rder
 
 ###### URL
-> /api/fwjg/getFwjgOrderByOrderNumber
+> /api2/fwjg/getFwjgOrderByOrderNumber
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -902,10 +931,11 @@
 ``` 
 <h4 id='5.4'>5.4 鏈嶅姟棰嗗煙璁㈠崟閲�</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鏈嶅姟棰嗗煙璁㈠崟閲�
+> 鏈嶅姟棰嗗煙璁㈠崟閲�<br>
+> 鏈嶅姟璇︽儏琛╢uwu_details, 璁㈠崟琛╫rder
 
 ###### URL
-> /api/fwjg/getFuwuDetailsOrderByOrderNumber
+> /api2/fwjg/getFuwuDetailsOrderByOrderNumber
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -1066,10 +1096,11 @@
 ``` 
 <h4 id='5.5'>5.5鎵ц涓鍗�</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鎵ц涓鍗�
+> 鎵ц涓鍗�<br>
+> 琛╫rder锛岃〃fuwu_person锛岃〃fuwu_details
 
 ###### URL
-> /api/fwjg/getOrder
+> /api2/fwjg/getOrder
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -1235,10 +1266,11 @@
 <h3 id='6'>鍏�佸吇鑰佹満鏋�</h2>
 <h4 id='6.1'>6.1 鑾峰彇缁熻鏁版嵁</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鑾峰彇缁熻鏁版嵁
+> 鑾峰彇缁熻鏁版嵁<br>
+> 鍏昏�佹満鏋勮〃org_yanglao锛�
 
 ###### URL
-> /api/fwyl/getStaticsData
+> /api2/fwyl/getStaticsData
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -1281,7 +1313,8 @@
 ``` 
 <h4 id='6.2'>6.2 搴婁綅涓暟鎺掑悕</h4>
 ###### 鎺ュ彛鍔熻兘
-> 搴婁綅涓暟鎺掑悕
+> 搴婁綅涓暟鎺掑悕<br>
+> 鍏昏�佹満鏋勮〃org_yanglao
 
 ###### URL
 > /api/fwyl/getBedNumList
@@ -1360,10 +1393,11 @@
 ``` 
 <h4 id='6.3'>6.3 搴婁綅浣跨敤鐜囨帓鍚�</h4>
 ###### 鎺ュ彛鍔熻兘
-> 搴婁綅浣跨敤鐜囨帓鍚�
+> 搴婁綅浣跨敤鐜囨帓鍚�<br>
+> 鍏昏�佹満鏋勮〃org_yanglao锛屽簥浣嶅墠10浣�+闅忔満鏁帮紝
 
 ###### URL
-> /api/fwyl/getBedUseList
+> /api2/fwyl/getBedUseList
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -1407,10 +1441,11 @@
 ``` 
 <h4 id='6.4'>6.4 鍘嗗彶鏁版嵁</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鍘嗗彶鏁版嵁
+> 鍘嗗彶鏁版嵁<br>
+> 鍥句笂杩炵画12涓湀搴婁綅浣跨敤鏁伴噺,鍗冧汉鍏昏�佸簥浣�--鍚庡彴杩斿洖闅忔満鏁�  
 
 ###### URL
-> /api/fwyl/getHistoryData
+> /api2/fwyl/getHistoryData
 
 ###### 鏀寔鏍煎紡
 > JSON
@@ -1479,7 +1514,8 @@
 <h3 id='7'>涓冦�佹柊棣栭〉</h2>
 <h4 id='7.1'>7.1 绀句細鏁戝姪</h4>
 ###### 鎺ュ彛鍔熻兘
-> 绀句細鏁戝姪
+> 绀句細鏁戝姪<br>
+> 娌℃湁鏌ヨ〃
 
 ###### URL
 > /api2/indexnew/getSocialAssistance
@@ -1587,7 +1623,8 @@
 ``` 
 <h4 id='7.2'>7.2 绀句細浜嬪姟</h4>
 ###### 鎺ュ彛鍔熻兘
-> 绀句細浜嬪姟
+> 绀句細浜嬪姟<br>
+> 娌℃湁鏌ヨ〃
 
 ###### URL
 > /api2/indexnew/getSocialAffair
@@ -1675,7 +1712,8 @@
 ``` 
 <h4 id='7.3'>7.3 鍏昏�佹湇鍔�</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鍏昏�佹湇鍔�
+> 鍏昏�佹湇鍔�<br>
+> 娌℃湁鏌ヨ〃
 
 ###### URL
 > /api2/indexnew/getPensionService
@@ -1730,7 +1768,8 @@
 
 <h4 id='7.4'>7.4 鍎跨绂忓埄</h4>
 ###### 鎺ュ彛鍔熻兘
-> 鍎跨绂忓埄
+> 鍎跨绂忓埄<br>
+> 娌℃湁鏌ヨ〃
 
 ###### URL
 > /api2/indexnew/getChildService
@@ -1828,7 +1867,8 @@
 ``` 
 <h4 id='7.5'>7.5 缁煎悎鍒嗘瀽</h4>
 ###### 鎺ュ彛鍔熻兘
-> 缁煎悎鍒嗘瀽
+> 缁煎悎鍒嗘瀽<br>
+> 娌℃湁鏌ヨ〃
 
 ###### URL
 > /api2/indexnew/getZongHe
@@ -1917,6 +1957,7 @@
 <h4 id='7.6'>7.6 鍖哄煙鍦板悕</h4>
 ###### 鎺ュ彛鍔熻兘
 > 鍖哄煙鍦板悕
+> 娌℃湁鏌ヨ〃
 
 ###### URL
 > /api2/indexnew/getRegion
@@ -1977,4 +2018,106 @@
         }
     ]
 }
-``` 
\ No newline at end of file
+``` 
+
+<h4 id='8.1'>8.1 鍖哄煙</h4>
+###### 杩斿洖瀛楁
+|杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| name  |  String  | 鍖哄煙鍚嶇О  |
+| pid  |  String  |  涓婄骇鍖哄煙id |
+
+<h4 id='8.2'>8.2 鏈嶅姟璇︽儏-鍗虫湇鍔¢」</h4>
+###### 杩斿洖瀛楁
+|杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| areaId  |  String  | 鍖哄煙id  |
+| orgFwId  |  String  |  鏈嶅姟鏈烘瀯id |
+| pid  |  String  | 闅跺睘涓婄骇鏈嶅姟id  |
+| name  |  String  |  鏈嶅姟鍚嶇О |
+
+<h4 id='8.3'>8.3 鏈嶅姟瀵硅薄</h4>
+###### 杩斿洖瀛楁
+|杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| name  |  String  | 鍖哄悕绉�  |
+| age  |  String  |  骞撮緞 |
+| sex  |  String  | 鎬у埆  |
+| sfzhm  |  String  |  韬唤璇佸彿鐮� |
+| areaId  |  String  | 鍖哄煙id  |
+| subsidyIds  |  String  |  琛ヨ创闆嗗悎 |
+
+<h4 id='8.4'>8.4 鏈嶅姟瀵硅薄</h4>
+###### 杩斿洖瀛楁
+|杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| name  |  String  | 鍖哄悕绉�  |
+| age  |  String  |  骞撮緞 |
+| sex  |  String  | 鎬у埆  |
+| sfzhm  |  String  |  韬唤璇佸彿鐮� |
+| areaId  |  String  | 鍖哄煙id |
+| orgFwId  |  String  |  鏈嶅姟鏈烘瀯id |
+
+
+<h4 id='8.5'>8.5 璁㈠崟琛╰_yl_order</h4>
+###### 杩斿洖瀛楁
+|杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| areaId  |  String  | 鍖哄煙id  |
+| detailId  |  String  |  鏈嶅姟璇︽儏id |
+| detail  |  String  | 鏈嶅姟璇︽儏  |
+| duixiangId  |  String  |  鏈嶅姟瀵硅薄id |
+| personId  |  String  | 鏈嶅姟浜哄憳id |
+| state  |  String  |  璁㈠崟鐘舵�乮d |
+
+
+<h4 id='8.6'>8.6 鏈嶅姟鏈烘瀯t_yl_org_fuwu</h4>
+###### 杩斿洖瀛楁
+|杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| areaId  |  String  | 鍖哄煙id  |
+| name  |  String  |  鏈嶅姟璇︽儏id |
+| orderNumber  |  String  | 鏈嶅姟璇︽儏  |
+
+
+<h4 id='8.7'>8.7 鍏昏�佹満鏋則_yl_org_yanglao</h4>
+###### 杩斿洖瀛楁
+|杩斿洖瀛楁|瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| areaId  |  String  | 鍖哄煙id  |
+| name  |  String  |  鍚嶇О |
+| type  |  int  | 绫诲瀷 0/鍏昏�侀櫌 1/鏁�侀櫌 2/鐤楀吇闄�"  |
+| square  |  double  | 闈㈢Н  |
+| bedNumber  |  int  | 搴婁綅鏁�  |
+| nurseNumber  |  int  | 鎶ょ悊浜哄憳鏁�  |
+| duixiangNumber  |  int  | 鍏ヤ綇鑰佷汉鏁�  |
+
+
+<h4 id='8.8'>8.8 琛ヨ创鏃ュ織t_yl_subsidy_log</h4>
+###### 杩斿洖瀛楁
+|瀛楁鍚峾瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| areaId  |  String  | 鍖哄煙id  |
+| money  |  Double  |  琛ュ姪閲戦 |
+| type  |  int  | 琛ュ姪绫诲瀷   |
+| duixiangId  |  int  | 鏈嶅姟瀵硅薄id   |
+
+<h4 id='8.9'>8.9 琛ヨ创浜哄憳t_yl_subsidy_person_statics</h4>
+###### 杩斿洖瀛楁
+|瀛楁鍚峾瀛楁绫诲瀷|璇存槑                              |
+|:-----   |:------|:-----------------------------   |
+| subsidyType  |  int  | 琛ヨ创绫诲瀷id  |
+| areaId  |  String  |  鍖哄煙id |
+| month  |  String  | 鏈堜唤   |
+| yearAdd  |  int  | 骞存柊澧�   |
+| yearOut  |  int  | 鏈堥��鍑�   |
+| yearSum  |  int  | 骞村悎璁�  |
+| monthAdd  |  int  |  鏈堟柊澧� |
+| monthOut  |  int  |  鏈堥��鍑� |
+| monthSum  |  int  |  鏈堝悎璁� |
+| totalNum  |  int  |  鐢宠鎬绘鏁� |
+| checkNum  |  int  |  澶嶅悎鎬绘鏁� |
+| personNum  |  int  |  鏈嶅姟鎬讳汉鏁� |
+
+
+

--
Gitblit v1.9.1