From 7166581c0abc64a53c32531800420536c4ee30af Mon Sep 17 00:00:00 2001
From: houxiao <houxiao@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期三, 15 三月 2017 13:22:48 +0800
Subject: [PATCH] 添加接口描述 sql
---
VisitFace/document/erdb api接口描述.txt | 43 +++++++++++++++++++++++++------------------
VisitFace/document/erdb.vpp | 0
2 files changed, 25 insertions(+), 18 deletions(-)
diff --git "a/VisitFace/document/erdb api\346\216\245\345\217\243\346\217\217\350\277\260.txt" "b/VisitFace/document/erdb api\346\216\245\345\217\243\346\217\217\350\277\260.txt"
index 310fe51..c9e950c 100644
--- "a/VisitFace/document/erdb api\346\216\245\345\217\243\346\217\217\350\277\260.txt"
+++ "b/VisitFace/document/erdb api\346\216\245\345\217\243\346\217\217\350\277\260.txt"
@@ -44,17 +44,17 @@
enum ImageTypeID
{
- Face1 = 1, // 姝ｉ潰鐓х墖1
- Face2 = 2, // 姝ｉ潰鐓х墖2
- FaceLSide = 2, // 锛堜富浣撹瀵燂紝<=45搴︼級宸︿晶鑴哥収鐗�
- FaceRSide = 3, // 锛堜富浣撹瀵燂紝<=45搴︼級鍙充晶鑴哥収鐗�
- FaceTSide = 4, // 锛堜富浣撹瀵燂紝<=45搴︼級椤朵晶鑴哥収鐗�
- FaceBSide = 5, // 锛堜富浣撹瀵燂紝<=45搴︼級搴曚晶鑴哥収鐗�
- FaceUploaded = 2, // 涓婁紶鐓х墖
- Icon, // 鍥炬爣
- IdentificationCard, // 韬唤璇佺収鐗�
- BusinessCard, // 鍚嶇墖鐓х墖
- OtherCard,
+ Face1 = 1, // 姝ｉ潰鐓х墖1锛堝瓨鏀惧埌EmployeeFace/VisitFace琛級
+ Face2 = 2, // 姝ｉ潰鐓х墖2锛堝瓨鏀惧埌EmployeeFace/VisitFace琛級
+ FaceLSide, // 锛堜富浣撹瀵燂紝<=45搴︼級宸︿晶鑴哥収鐗囷紙瀛樻斁鍒癊mployeeFace/VisitFace琛級
+ FaceRSide, // 锛堜富浣撹瀵燂紝<=45搴︼級鍙充晶鑴哥収鐗囷紙瀛樻斁鍒癊mployeeFace/VisitFace琛級
+ FaceTSide, // 锛堜富浣撹瀵燂紝<=45搴︼級椤朵晶鑴哥収鐗囷紙瀛樻斁鍒癊mployeeFace/VisitFace琛級
+ FaceBSide, // 锛堜富浣撹瀵燂紝<=45搴︼級搴曚晶鑴哥収鐗囷紙瀛樻斁鍒癊mployeeFace/VisitFace琛級
+ FaceUploaded, // 涓婁紶鐓х墖锛堝瓨鏀惧埌EmployeeFace/VisitFace琛級
+ Icon, // 鍥炬爣锛堝瓨鏀惧埌Image琛級
+ IdentificationCard, // 韬唤璇佺収鐗囷紙瀛樻斁鍒癐mage琛級
+ BusinessCard, // 鍚嶇墖鐓х墖锛堝瓨鏀惧埌Image琛級
+ OtherCard, // 鍏朵粬璇佷欢锛堝瓨鏀惧埌Image琛級
}
1.2. StatusID
@@ -258,8 +258,7 @@
{
registerCompanyID : 123,
personID : 123,
- imgs : [ "image base64" ] // 瀵瑰簲涓�涓汉鐨勮嫢骞蹭釜浜鸿劯鍥惧儚
- imgIdentity : "image base64"
+ imgs : { ImageTypeID : "image base64" } // 瀵瑰簲涓�涓汉鐨勮嫢骞蹭釜浜鸿劯鍥惧儚
}
Response:
{
@@ -268,17 +267,16 @@
a)select exists(*) from person where id="$personID"
b)if not exists return error
-c)淇濆瓨imgIdentity鍒版枃浠跺瓨鍌紝骞舵彃鍏mage琛�
-d)VisitFace.imagePath = 淇濆瓨imgs鍒版枃浠跺瓨鍌�
-e)璋冪敤浜鸿劯璇嗗埆鏈嶅姟[faceids]=(registerCompanyID, dbid=0, img)
-f)瀵逛簬姣忎竴涓猣aceid锛宨nsert into VisitFace ("$FaceID", $PersonID, "$VisitFace.imagePath")
+c)淇濆瓨imgIdentity/Icon绛夊埌鏂囦欢瀛樺偍锛屽苟鎻掑叆Image琛紱淇濆瓨浜鸿劯鍥惧埌VisitFace锛孷isitFace.imagePath = 淇濆瓨imgs鍒版枃浠跺瓨鍌�
+d)璋冪敤浜鸿劯璇嗗埆鏈嶅姟[faceids]=(registerCompanyID, dbid=0, img)
+e)瀵逛簬姣忎竴涓猣aceid锛宨nsert into VisitFace ("$FaceID", $PersonID, "$VisitFace.imagePath")
3. 鏉ヨ鐧昏
3.1. 鑾峰緱鏉ヨ浜哄憳鍒楄〃
杩斿洖鎸夊鍚嶇缉鍐欏崌搴忕殑缁撴灉
Request:
{
- companyID : 123, // 璁惧鎵�鍦ㄥ鏍D
+ companyID : 123, // 璁惧鎵�鍦ㄥ鏍D锛�0琛ㄧず鎵�鏈夊叕鍙革紝浠呬緵绠＄悊鎺ュ彛浣跨敤
beginPage : 0,
endPage : 0
}
@@ -286,11 +284,20 @@
[
{
personID : 123,
+ RegisterCompanyID : 123,
name : "aaa",
img : "image url" // 闈炲瓧绗︿覆琛ㄧず浣跨敤榛樿鍥炬爣
}
]
+set @companyID =1;
+select vs.person_id, vs.register_company_id, pe.name, img.image_type, img.image_path
+ from visit_stat vs join person pe
+ on (@companyID=0 or vs.register_company_id = @companyID) and (vs.person_id = pe.id)
+ left outer join Image img
+ on (pe.id = img.person_id and img.image_type=8) -- icon
+ limit ...
+
3.2. 鑾峰緱琚浜哄憳鍒楄〃
杩斿洖鎸夊鍚嶇缉鍐欏崌搴忕殑缁撴灉
Request:
diff --git a/VisitFace/document/erdb.vpp b/VisitFace/document/erdb.vpp
index c0adb8f..4f2ac28 100644
--- a/VisitFace/document/erdb.vpp
+++ b/VisitFace/document/erdb.vpp
Binary files differ
--
Gitblit v1.8.0