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