From a4442190c8d2d3d3a094b2af925071c85800489b Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期一, 10 四月 2017 11:51:23 +0800
Subject: [PATCH]
---
VisitFace/document/erdb api接口描述.txt | 99 ++++++++++++++++++++++++++++++++-----------------
1 files changed, 65 insertions(+), 34 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..1424f8d 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"
@@ -29,6 +29,14 @@
}
]
+enum StatusID
+{
+鏅�氳瀹�
+榛戝悕鍗�
+鏁欏笀
+瀛︾敓
+棰嗗骞查儴
+}
select ID, distinct label from VisitorType where RegisterCompanyID = 0 or RegisterCompanyID = "$companyID"
1.2. ImageTypeID
@@ -44,17 +52,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锛堜氦缁欎汉鑴歌瘑鍒湇鍔★級
+ Face2 = 2, // 姝ｉ潰鐓х墖2锛堝瓨鏀惧埌FaceImage琛級
+ FaceLSide, // 锛堜富浣撹瑙掞紝<=45搴︼級宸︿晶鑴哥収鐗囷紙瀛樻斁鍒癋aceImage琛級
+ FaceRSide, // 锛堜富浣撹瑙掞紝<=45搴︼級鍙充晶鑴哥収鐗囷紙瀛樻斁鍒癋aceImage琛級
+ FaceTSide, // 锛堜富浣撹瑙掞紝<=45搴︼級椤朵晶鑴哥収鐗囷紙瀛樻斁鍒癋aceImage琛級
+ FaceBSide, // 锛堜富浣撹瑙掞紝<=45搴︼級搴曚晶鑴哥収鐗囷紙瀛樻斁鍒癋aceImage琛級
+ FaceUploaded, // 涓婁紶鐓х墖锛堝瓨鏀惧埌FaceImage琛級
+ Icon, // 鍥炬爣锛堝瓨鏀惧埌Image琛級
+ IdentificationCard, // 韬唤璇佺収鐗囷紙瀛樻斁鍒癐mage琛級
+ BusinessCard, // 鍚嶇墖鐓х墖锛堝瓨鏀惧埌Image琛級
+ OtherCard, // 鍏朵粬璇佷欢锛堝瓨鏀惧埌Image琛級
}
1.2. StatusID
@@ -70,11 +78,12 @@
enum StatusID
{
-鏅�氳瀹�
-榛戝悕鍗�
-鏁欏笀
-瀛︾敓
-棰嗗骞查儴
+鏈敞鍐�
+宸叉敞鍐岋紙璁垮锛�
+鏉ヨ鐧昏锛堣瀹級
+绛剧锛堣瀹級
+绛惧埌锛堝憳宸ワ級
+绛鹃��锛堝憳宸ワ級
}
@@ -101,21 +110,21 @@
a)鎺ユ敹imgs浜岃繘鍒舵暟鎹�
b)杞彂鍒颁汉鑴歌瘑鍒湇鍔�(registerCompanyID, imgs)
-c)鎺ユ敹璇嗗埆缁撴灉锛�<dbid, faceid>锛屽叾涓�<0,0>琛ㄧず鏈壘鍒扮粨鏋滐紝<0,N>琛ㄧず鍦ㄨ瀹㈡暟鎹簱涓壘鍒颁汉鑴革紝<N,M>琛ㄧず鍦∟鍏徃涓尮閰嶄汉鑴窶
+c)鎺ユ敹璇嗗埆缁撴灉锛�<dbid, faceid>锛屽叾涓�<(<0),0>琛ㄧず鏈壘鍒扮粨鏋滐紝<(<0),N>琛ㄧず鍦ㄨ瀹㈡暟鎹簱涓壘鍒颁汉鑴革紝<N,M>琛ㄧず鍦∟鍏徃涓尮閰嶄汉鑴窶
d) 瀵逛簬鍗曚釜浜鸿劯缁撴灉锛�
if <0,0>
{
// 鎼滅储鏃犵粨鏋�
}
- else if (dbid == 0 && faceid != 0)
+ else if (dbid < 0 && faceid != 0)
{ // 璁垮
- // select * from VisitFace where faceid="$faceid";
- // select * from Person where
+ // select PersonID from FaceImage where RegisterCompanyID="$dbid" and faceid="$faceid";
+ // select * from Person where PersonID="$PersonID"
}
- else if (dbid != 0 && faceid != 0)
+ else if (dbid > 0 && faceid != 0)
{ // 鍛樺伐
- // select * from EmployeeFace where RegisterCompanyID="$dbid" and faceid="$faceid";
- // select * from Person where
+ // select * from FaceImage where RegisterCompanyID="$dbid" and faceid="$faceid";
+ // select * from Person where PersonID="$PersonID"
}
@@ -157,7 +166,7 @@
Request:
{
placeID : 123, // 鑻ヤ负-1鍒欏彧鎼滅储VisitFaceDB
- visitStatusID : 1 // 绛惧埌銆佺閫�/绛剧
+ enterOrExit : 1 // 绛惧埌銆佺閫�/绛剧
imgs : [ "image base64" ] // 瀵瑰簲澶氫釜浜虹殑浜鸿劯鍥惧儚
}
Response:
@@ -175,12 +184,12 @@
]
-鍙傝�僡)b)c)d)
+鍙傝��1.3. a)b)c)d)
e) 瀵逛簬鍗曚釜浜鸿劯缁撴灉锛�
// "$person.id"
select CompanyID from Place where placeID="$placeID"
isChecking = select * CheckingCompany where CompanyID = "$CompanyID" and PersonID="$PersonID"
- if (visitStatusID == 绛惧埌) // 鍏ュ彛鎽勫儚澶�
+ if (enterOrExit == 绛惧埌) // 鍏ュ彛鎽勫儚澶�
{
if (isChecking)
checking(PersonID, placeID);
@@ -188,13 +197,14 @@
else
return person status not changed;
}
- else if (visitStatusID == 绛鹃��/绛剧) // 鍑哄彛鎽勫儚澶�
+ else if (enterOrExit == 绛鹃��/绛剧) // 鍑哄彛鎽勫儚澶�
{
if (isChecking)
unchecking(PersonID, placeID);
return person current status
else
unvisit(PersonID, placeID);
+ return person current status
}
checking:
@@ -252,14 +262,15 @@
b) if Person exists return error
c) else insert into Person
d) companyID = (select * from or insert Company where name = "$companyName")
+e) department_id , Post_id
+f)
2.4. 娉ㄥ唽璁垮浜鸿劯(visit face register)
Request:
{
registerCompanyID : 123,
personID : 123,
- imgs : [ "image base64" ] // 瀵瑰簲涓�涓汉鐨勮嫢骞蹭釜浜鸿劯鍥惧儚
- imgIdentity : "image base64"
+ imgs : { ImageTypeID : "image base64" } // 瀵瑰簲涓�涓汉鐨勮嫢骞蹭釜浜鸿劯鍥惧儚
}
Response:
{
@@ -268,17 +279,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)鏍规嵁image type淇濆瓨鍥剧墖
+d)璋冪敤浜鸿劯璇嗗埆鏈嶅姟[faceids]=(registerCompanyID, dbid=-1, 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,10 +296,19 @@
[
{
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. 鑾峰緱琚浜哄憳鍒楄〃
杩斿洖鎸夊鍚嶇缉鍐欏崌搴忕殑缁撴灉
@@ -309,6 +328,9 @@
}
]
+set @companyID =1;
+select * from person pe where pe.company_id = @companyID
+
3.2. 鎼滅储
(3. 4. 5. 6.)
鏉ヨ浜哄憳锛屽鏋滄病鏈夌粰鍑烘悳绱㈠瓧娈垫椂锛屾樉绀烘湰鏍℃浘缁忔潵璁夸汉鍛樺垪琛╒isitStat锛涘鏋滅粰鍑哄叧閿瓧锛屽垯鎼滅储鍏ㄩ儴浜哄憳
@@ -327,6 +349,15 @@
#todo 琚鑰冭檻鍜屼汉鍛樺垪琛ㄥ悎骞�
+if isVisitor
+ select *
+ from visit_stat vs left outer join person pe
+ on vs.person_id = person.id
+ where vs.register_company_id = "$registerCompanyID" and pe.name_spell like "$nameSpell%"
+else
+ select * from person
+ where CompanyID = "$registerCompanyID" and name_spell like "$nameSpell%"
+
3.3. 鑾峰緱鏉ヨ/琚浜哄憳璇︾粏淇℃伅锛坴isitor/visitee锛�
Request:
{
--
Gitblit v1.8.0