From 54b23ebcea16ba422afd595bcaf04d0b7cb6407c Mon Sep 17 00:00:00 2001 From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674> Date: 星期三, 26 七月 2017 14:39:00 +0800 Subject: [PATCH] --- VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java | 6 + VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitItem.java | 164 ---------------------------------------- VisitFace/DemoForBsk/app/src/main/assets/db/aibatis_test_db | 0 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/entity/Visit.java | 10 ++ VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/AttenderRegisterFragment.java | 2 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java | 1 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/CheckInFragment.java | 2 7 files changed, 20 insertions(+), 165 deletions(-) diff --git a/VisitFace/DemoForBsk/app/src/main/assets/db/aibatis_test_db b/VisitFace/DemoForBsk/app/src/main/assets/db/aibatis_test_db index 88683d6..5b6b1f7 100644 --- a/VisitFace/DemoForBsk/app/src/main/assets/db/aibatis_test_db +++ b/VisitFace/DemoForBsk/app/src/main/assets/db/aibatis_test_db Binary files differ diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/entity/Visit.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/entity/Visit.java index 70d3f9c..cb86130 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/entity/Visit.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/entity/Visit.java @@ -112,6 +112,8 @@ private String createTime; + private String visitReason; + public String getIsValid() { return isValid; } @@ -341,6 +343,14 @@ this.deviceCompanyId = deviceCompanyId; } + public String getVisitReason() { + return visitReason; + } + + public void setVisitReason(String visitReason) { + this.visitReason = visitReason; + } + public String toString() { return ",璁块棶浜嬩欢涓婚敭 ="+ visitId + ",璁块棶浜嬬敱涓婚敭 ="+ visitReasonId + ",璁块棶澶囨敞 =" + remark + diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitItem.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitItem.java index f66fc2c..312f896 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitItem.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitItem.java @@ -1,167 +1,7 @@ package cn.com.basic.face.discern.query.item; -public class OfflineVisitItem { +import cn.com.basic.face.discern.entity.Visit; - private String visitId; - private String visitReasonId; - private String remark; - private String enterTime; - private String exitTime; - private String visitorTypeId; - private String visitorId; - private String visitorCompanyId; - private String visiteeId; - private String visiteeCompanyId; - private String currentStateId; - private String warning; - private String updateTime; - private String isSynchron; - private String deviceCompanyId; - private String visitReason; - private String createTime; - private String deviceId; +public class OfflineVisitItem extends Visit { - public String getVisitId() { - return visitId; - } - - public void setVisitId(String visitId) { - this.visitId = visitId; - } - - public String getVisitReasonId() { - return visitReasonId; - } - - public void setVisitReasonId(String visitReasonId) { - this.visitReasonId = visitReasonId; - } - - public String getRemark() { - return remark; - } - - public void setRemark(String remark) { - this.remark = remark; - } - - public String getEnterTime() { - return enterTime; - } - - public void setEnterTime(String enterTime) { - this.enterTime = enterTime; - } - - public String getExitTime() { - return exitTime; - } - - public void setExitTime(String exitTime) { - this.exitTime = exitTime; - } - - public String getVisitorTypeId() { - return visitorTypeId; - } - - public void setVisitorTypeId(String visitorTypeId) { - this.visitorTypeId = visitorTypeId; - } - - public String getVisitorId() { - return visitorId; - } - - public void setVisitorId(String visitorId) { - this.visitorId = visitorId; - } - - public String getVisitorCompanyId() { - return visitorCompanyId; - } - - public void setVisitorCompanyId(String visitorCompanyId) { - this.visitorCompanyId = visitorCompanyId; - } - - public String getVisiteeId() { - return visiteeId; - } - - public void setVisiteeId(String visiteeId) { - this.visiteeId = visiteeId; - } - - public String getVisiteeCompanyId() { - return visiteeCompanyId; - } - - public void setVisiteeCompanyId(String visiteeCompanyId) { - this.visiteeCompanyId = visiteeCompanyId; - } - - public String getCurrentStateId() { - return currentStateId; - } - - public void setCurrentStateId(String currentStateId) { - this.currentStateId = currentStateId; - } - - public String getWarning() { - return warning; - } - - public void setWarning(String warning) { - this.warning = warning; - } - - public String getUpdateTime() { - return updateTime; - } - - public void setUpdateTime(String updateTime) { - this.updateTime = updateTime; - } - - public String getIsSynchron() { - return isSynchron; - } - - public void setIsSynchron(String isSynchron) { - this.isSynchron = isSynchron; - } - - public String getDeviceCompanyId() { - return deviceCompanyId; - } - - public void setDeviceCompanyId(String deviceCompanyId) { - this.deviceCompanyId = deviceCompanyId; - } - - public String getVisitReason() { - return visitReason; - } - - public void setVisitReason(String visitReason) { - this.visitReason = visitReason; - } - - public String getCreateTime() { - return createTime; - } - - public void setCreateTime(String createTime) { - this.createTime = createTime; - } - - public String getDeviceId() { - return deviceId; - } - - public void setDeviceId(String deviceId) { - this.deviceId = deviceId; - } } diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/AttenderRegisterFragment.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/AttenderRegisterFragment.java index 12ecf0e..50f41d3 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/AttenderRegisterFragment.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/AttenderRegisterFragment.java @@ -161,7 +161,7 @@ fragment_attender_register_gender.callOnClick(); return; } - + String post = fragment_attender_register_post.getValue(); if (post.trim().length() <= 0) { Toast.makeText(MainActivity.getInstance(), "鑱屽姟绫诲瀷涓嶈兘涓虹┖", Toast.LENGTH_SHORT).show(); diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/CheckInFragment.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/CheckInFragment.java index 77206e6..89a24c0 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/CheckInFragment.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/fragment/CheckInFragment.java @@ -235,7 +235,7 @@ offlineVisitItem.setCurrentStateId(""+CommonVariables.VisitType.VISITOR_ENTERED); offlineVisitItem.setWarning(visitor.getWarning()); offlineVisitItem.setCreateTime(sdf.format(new Date())); - offlineVisitItem.setDeviceId(BaseApplication.getInstance().getAndroidDevice().getDeviceId()); + //offlineVisitItem.setDeviceId(BaseApplication.getInstance().getAndroidDevice().getDeviceId()); offlineVisitItem.setDeviceCompanyId(BaseApplication.getInstance().getAndroidDevice().getCompanyId()); offlineVisitItem.setIsSynchron("N"); } diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java index 989b679..d1531ed 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/CheckInDao.java @@ -244,6 +244,7 @@ ContentValues contentValues = new ContentValues(); contentValues.put("visit_id",item.getVisitId()); contentValues.put("visit_reason_id",item.getVisitReasonId()); + contentValues.put("visit_reason",item.getVisitReason()); contentValues.put("remark",item.getRemark()); contentValues.put("enter_time",item.getEnterTime()); contentValues.put("exit_time",item.getExitTime()); diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java index 115f686..2c6166b 100644 --- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java +++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/VisitDao.java @@ -33,7 +33,7 @@ sb.append("SELECT a.register_id,a.username,a.surveillance_photo,d.company_name,a.tel,a.identify_num,b.dept_name,") .append("d.company_id,e.post_name,a.mobile_phone,0 as type,f.`name` gender,g.`name` identity_type,") .append("a.birthday,h.`name` country_name,j.username visitee,k.`name` visit_reason,i.enter_time,i.exit_time,") - .append("l.`name` current_status,a.id_card_photo,a.company").append(" FROM ").append(" visit i ") + .append("l.`name` current_status,a.id_card_photo,a.company, i.visit_reason reason ").append(" FROM ").append(" visit i ") .append(" LEFT JOIN register a on i.visitor_id=a.register_id ") .append(" LEFT JOIN company d on d.company_id=a.company_id ") .append(" LEFT JOIN post e on e.post_id=a.post_id ") @@ -83,6 +83,10 @@ if (company != null && !"".equals(company)) { aqi.setCompanyName(company); } + String reason = c.getString(c.getColumnIndex("reason")); + if (reason != null && !"".equals(reason)){ + aqi.setVisitReason(reason); + } list.add(aqi); } Integer total = null; -- Gitblit v1.8.0