From 8d848ae4f41933c0755581e31b7504f2b73492ff Mon Sep 17 00:00:00 2001
From: houxiao <houxiao@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期三, 15 三月 2017 16:59:11 +0800
Subject: [PATCH] 添加接口描述 sql
---
VisitFace/document/erdb api接口描述.txt | 69 +++++++++++++++++++++++-----------
VisitFace/document/erdb.vpp | 0
2 files changed, 47 insertions(+), 22 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 c9e950c..213031b 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,13 +52,13 @@
enum ImageTypeID
{
- 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琛級
+ 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琛級
@@ -70,11 +78,13 @@
enum StatusID
{
-鏅�氳瀹�
-榛戝悕鍗�
-鏁欏笀
-瀛︾敓
-棰嗗骞查儴
+鏈敞鍐�
+璁垮娉ㄥ唽锛堣瀹級
+鏉ヨ鐧昏锛堣瀹級
+鏉ヨ锛堣瀹級
+绛剧锛堣瀹級
+绛惧埌锛堝憳宸ワ級
+绛鹃��锛堝憳宸ワ級
}
@@ -101,21 +111,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"
}
@@ -175,7 +185,7 @@
]
-鍙傝�僡)b)c)d)
+鍙傝��1.3. a)b)c)d)
e) 瀵逛簬鍗曚釜浜鸿劯缁撴灉锛�
// "$person.id"
select CompanyID from Place where placeID="$placeID"
@@ -195,6 +205,7 @@
return person current status
else
unvisit(PersonID, placeID);
+ return person current status
}
checking:
@@ -252,6 +263,8 @@
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:
@@ -267,8 +280,8 @@
a)select exists(*) from person where id="$personID"
b)if not exists return error
-c)淇濆瓨imgIdentity/Icon绛夊埌鏂囦欢瀛樺偍锛屽苟鎻掑叆Image琛紱淇濆瓨浜鸿劯鍥惧埌VisitFace锛孷isitFace.imagePath = 淇濆瓨imgs鍒版枃浠跺瓨鍌�
-d)璋冪敤浜鸿劯璇嗗埆鏈嶅姟[faceids]=(registerCompanyID, dbid=0, img)
+c)鏍规嵁image type淇濆瓨鍥剧墖
+d)璋冪敤浜鸿劯璇嗗埆鏈嶅姟[faceids]=(registerCompanyID, dbid=-1, img)
e)瀵逛簬姣忎竴涓猣aceid锛宨nsert into VisitFace ("$FaceID", $PersonID, "$VisitFace.imagePath")
3. 鏉ヨ鐧昏
@@ -316,6 +329,9 @@
}
]
+set @companyID =1;
+select * from person pe where pe.company_id = @companyID
+
3.2. 鎼滅储
(3. 4. 5. 6.)
鏉ヨ浜哄憳锛屽鏋滄病鏈夌粰鍑烘悳绱㈠瓧娈垫椂锛屾樉绀烘湰鏍℃浘缁忔潵璁夸汉鍛樺垪琛╒isitStat锛涘鏋滅粰鍑哄叧閿瓧锛屽垯鎼滅储鍏ㄩ儴浜哄憳
@@ -334,6 +350,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:
{
diff --git a/VisitFace/document/erdb.vpp b/VisitFace/document/erdb.vpp
index 9b46b93..44e2ea8 100644
--- a/VisitFace/document/erdb.vpp
+++ b/VisitFace/document/erdb.vpp
Binary files differ
--
Gitblit v1.8.0