From 2235796b1f18a699dd86395f18db64512b0a47e6 Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期四, 20 七月 2017 12:25:19 +0800
Subject: [PATCH] 

---
 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineAttenderRegisterItem.java |    9 ++
 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitItem.java            |    2 
 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/RegisterMng.java                            |   35 +-------
 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitorRegisterItem.java  |   65 ++++++++++++++++
 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java                     |   68 ++++++++++++++++
 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/util/FileUtil.java                                  |   12 +++
 6 files changed, 159 insertions(+), 32 deletions(-)

diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineAttenderRegisterItem.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineAttenderRegisterItem.java
index 36ed941..ef4bdab 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineAttenderRegisterItem.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineAttenderRegisterItem.java
@@ -2,4 +2,13 @@
 
 public class OfflineAttenderRegisterItem {
 
+    private String attenderId;
+
+    public String getAttenderId() {
+        return attenderId;
+    }
+
+    public void setAttenderId(String attenderId) {
+        this.attenderId = attenderId;
+    }
 }
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 6a49ca8..8fe3a20 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
@@ -2,6 +2,6 @@
 
 public class OfflineVisitItem {
 
-    
+
 
 }
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitorRegisterItem.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitorRegisterItem.java
index edb1d03..d64193a 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitorRegisterItem.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/discern/query/item/OfflineVisitorRegisterItem.java
@@ -1,5 +1,9 @@
 package cn.com.basic.face.discern.query.item;
 
+import java.io.File;
+
+import cn.com.basic.face.util.FileUtil;
+
 public class OfflineVisitorRegisterItem {
 
     private String visitorId;
@@ -25,6 +29,12 @@
 	private String idCardPhotoPath;
 	private String idCardPhotoWidth;
 	private String idCardPhotoHeight;
+	private String createTime;
+
+    File rawSurveillancePhoto;
+    File surveillancePhoto;
+    File uploadCustomPhoto;
+    File idCardPhoto;
 
     public String getUsername() {
         return username;
@@ -209,4 +219,59 @@
     public void setVisitorId(String visitorId) {
         this.visitorId = visitorId;
     }
+
+    public File getRawSurveillancePhoto() {
+        return rawSurveillancePhoto;
+    }
+
+    public void setRawSurveillancePhoto(File rawSurveillancePhoto) {
+        this.rawSurveillancePhoto = rawSurveillancePhoto;
+    }
+
+    public File getSurveillancePhoto() {
+        return surveillancePhoto;
+    }
+
+    public void setSurveillancePhoto(File surveillancePhoto) {
+        this.surveillancePhoto = surveillancePhoto;
+    }
+
+    public File getUploadCustomPhoto() {
+        return uploadCustomPhoto;
+    }
+
+    public void setUploadCustomPhoto(File uploadCustomPhoto) {
+        this.uploadCustomPhoto = uploadCustomPhoto;
+    }
+
+    public File getIdCardPhoto() {
+        return idCardPhoto;
+    }
+
+    public void setIdCardPhoto(File idCardPhoto) {
+        this.idCardPhoto = idCardPhoto;
+    }
+
+    public String getCreateTime() {
+        return createTime;
+    }
+
+    public void setCreateTime(String createTime) {
+        this.createTime = createTime;
+    }
+
+    public void loadFiles() {
+        setRawSurveillancePhoto(FileUtil.getFile(getRawSurveillancePhotoPath()));
+        setSurveillancePhoto(FileUtil.getFile(getSurveillancePhotoPath()));
+        setUploadCustomPhoto(FileUtil.getFile(getUploadCustomPhotoPath()));
+        setIdCardPhoto(FileUtil.getFile(getIdCardPhotoPath()));
+    }
+
+    public void deleteFiles() {
+        FileUtil.deleteFile(getRawSurveillancePhotoPath());
+        FileUtil.deleteFile(getSurveillancePhotoPath());
+        FileUtil.deleteFile(getUploadCustomPhotoPath());
+        FileUtil.deleteFile(getIdCardPhotoPath());
+    }
+
 }
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/RegisterMng.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/RegisterMng.java
index 426e767..4cb677e 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/RegisterMng.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/RegisterMng.java
@@ -236,46 +236,23 @@
         params.addBodyParameter("width", item.getRawSurveillancePhotoWidth());
         params.addBodyParameter("height", item.getRawSurveillancePhotoHeight());
 
-        File rawSurveillancePhoto= FileUtil.getFile(item.getRawSurveillancePhotoPath());
-        File surveillancePhoto= FileUtil.getFile(item.getSurveillancePhotoPath());
-        File uploadCustomPhoto= FileUtil.getFile(item.getUploadCustomPhotoPath());
-        File idCardPhoto= FileUtil.getFile(item.getIdCardPhotoPath());
-        params.addBodyParameter("rawSurveillancePhoto", rawSurveillancePhoto);
-        params.addBodyParameter("surveillancePhoto", surveillancePhoto);
-        params.addBodyParameter("uploadCustomPhoto", uploadCustomPhoto);
-        params.addBodyParameter("idCardPhoto", idCardPhoto);
+        item.loadFiles();
+
+        params.addBodyParameter("rawSurveillancePhoto", item.getRawSurveillancePhoto());
+        params.addBodyParameter("surveillancePhoto", item.getSurveillancePhoto());
+        params.addBodyParameter("uploadCustomPhoto", item.getUploadCustomPhoto());
+        params.addBodyParameter("idCardPhoto", item.getIdCardPhoto());
         try {
             File path = BaseApplication.getInstance().getFilesDir();
-            File rawSurveillancePhotoFile = new File(path, "rawSurveillancePhoto");
-            if (!rawSurveillancePhotoFile.exists()) {
-                rawSurveillancePhotoFile.createNewFile();
-            }
             File f0 = new File(path, "f0");
             if (!f0.exists()) {
                 f0.createNewFile();
             }
-            File surveillancePhotoFile = new File(path, "surveillancePhoto");
-            if (!surveillancePhotoFile.exists()) {
-                surveillancePhotoFile.createNewFile();
-            }
-            File uploadCustomPhotoFile = new File(path, "uploadCustomPhoto");
-            if (!uploadCustomPhotoFile.exists()) {
-                uploadCustomPhotoFile.createNewFile();
-            }
-            File idCardPhotoFile = new File(path, "idCardPhoto");
-            if (!idCardPhotoFile.exists()) {
-                idCardPhotoFile.createNewFile();
-            }
-
             FileWriter fw0 = new FileWriter(f0);
             fw0.write("test1");
             fw0.close();
             params.setUri(AppApi.BASE_URL +AppApi.REGISTER_ADD);
             params.addBodyParameter("f0", f0);
-            params.addBodyParameter("rawSurveillancePhoto", rawSurveillancePhotoFile);
-            params.addBodyParameter("surveillancePhoto", surveillancePhotoFile);
-            params.addBodyParameter("uploadCustomPhoto", uploadCustomPhotoFile);
-            params.addBodyParameter("idCardPhoto", idCardPhotoFile);
             x.http().post(params, new BaseCommonCallBack() {
                 @Override
                 public void success() {
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java
index 4c4936e..ad0fc73 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/RegisterDao.java
@@ -1,12 +1,17 @@
 package cn.com.basic.face.service.sqlite;
 
 import android.database.Cursor;
+import android.database.sqlite.SQLiteDatabase;
 
 import org.xutils.http.RequestParams;
+
+import java.io.File;
 
 import cn.com.basic.face.base.Config;
 import cn.com.basic.face.discern.query.item.OfflineAttenderRegisterItem;
 import cn.com.basic.face.discern.query.item.OfflineVisitorRegisterItem;
+import cn.com.basic.face.discern.query.item.UnknownQueryItem;
+import cn.com.basic.face.util.FileUtil;
 
 public class RegisterDao {
 
@@ -48,7 +53,56 @@
     }
 
     public OfflineVisitorRegisterItem readOfflineVisitorRegister() {
-        return null;
+        OfflineVisitorRegisterItem item = null;
+        String sql =
+                "SELECT\n" +
+                "	a.visitor_id,\n" +
+                "	a.username,\n" +
+                "	a.mobile_phone,\n" +
+                "	a.gender_id,\n" +
+                "	a.identity_type_id,\n" +
+                "	a.country_id,\n" +
+                "	a.visitor_type_id,\n" +
+                "	a.identify_num,\n" +
+                "	a.company_id,\n" +
+                "	a.birthday,\n" +
+                "	a.remark,\n" +
+                "	a.raw_surveillance_photo_path,\n" +
+                "	a.raw_surveillance_photo_width,\n" +
+                "	a.raw_surveillance_photo_height,\n" +
+                "	a.surveillance_photo_path,\n" +
+                "	a.upload_custom_photo_path,\n" +
+                "	a.id_card_photo_path,\n" +
+                "	a.create_time\n" +
+                "FROM\n" +
+                "	offline_visitor_register a";
+        SQLiteDatabase db = Config.sqlMap.getDb();
+        db.beginTransaction();
+        Cursor c = db.rawQuery(sql, new String[]{});
+        if (c.moveToFirst()) {
+            item = new OfflineVisitorRegisterItem();
+            item.setVisitorId(c.getString(c.getColumnIndex("visitor_id")));
+            item.setUsername(c.getString(c.getColumnIndex("username")));
+            item.setMobilePhone(c.getString(c.getColumnIndex("mobile_phone")));
+            item.setGenderId(c.getString(c.getColumnIndex("gender_id")));
+            item.setIdentityTypeId(c.getString(c.getColumnIndex("identity_type_id")));
+            item.setCountryId(c.getString(c.getColumnIndex("country_id")));
+            item.setVisitorTypeId(c.getString(c.getColumnIndex("visitor_type_id")));
+            item.setIdentifyNum(c.getString(c.getColumnIndex("identify_num")));
+            item.setCompanyId(c.getString(c.getColumnIndex("company_id")));
+            item.setBirthday(c.getString(c.getColumnIndex("birthday")));
+            item.setRemark(c.getString(c.getColumnIndex("remark")));
+            item.setRawSurveillancePhotoPath(c.getString(c.getColumnIndex("raw_surveillance_photo_path")));
+            item.setRawSurveillancePhotoWidth(c.getString(c.getColumnIndex("raw_surveillance_photo_width")));
+            item.setRawSurveillancePhotoHeight(c.getString(c.getColumnIndex("raw_surveillance_photo_height")));
+            item.setSurveillancePhotoPath(c.getString(c.getColumnIndex("surveillance_photo_path")));
+            item.setUploadCustomPhotoPath(c.getString(c.getColumnIndex("upload_custom_photo_path")));
+            item.setIdCardPhotoPath(c.getString(c.getColumnIndex("id_card_photo_path")));
+            item.setCreateTime(c.getString(c.getColumnIndex("create_time")));
+        }
+        c.close();
+        db.endTransaction();
+        return item;
     }
 
     public OfflineAttenderRegisterItem readOfflineAttenderRegister() {
@@ -56,7 +110,17 @@
     }
 
     public void removeOfflineVisitorRegister(OfflineVisitorRegisterItem item) {
-
+        try {
+            String sql = "delete from offline_visitor_register where visitor_id='"+item.getVisitorId()+"'";
+            SQLiteDatabase db = Config.sqlMap.getDb();
+            db.beginTransaction();
+            db.execSQL(sql);
+            db.endTransaction();
+            item.deleteFiles();
+        }
+        catch (Exception e) {
+            e.printStackTrace();
+        }
     }
 
 }
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/util/FileUtil.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/util/FileUtil.java
index d2eb01d..822b513 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/util/FileUtil.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/util/FileUtil.java
@@ -77,4 +77,16 @@
     }
 
 
+    public static void deleteFile(String fileName) {
+        try {
+            String dir = MainActivity.getInstance().getFilesDir().getAbsolutePath();
+
+            File file = new File(dir, fileName);
+            if (file.exists()) {
+                file.delete();
+            }
+        }catch (Exception e) {
+            e.printStackTrace();
+        }
+    }
 }

--
Gitblit v1.8.0