From 785fd3c3e9984f301018b3b5deb91ecc2c8da124 Mon Sep 17 00:00:00 2001
From: xuxiuxi <xuxiuxi@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期二, 01 八月 2017 17:44:35 +0800
Subject: [PATCH]
---
VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java
index 53b4900..d72400f 100644
--- a/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java
+++ b/VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/AttendanceDao.java
@@ -3,7 +3,9 @@
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
+import java.text.SimpleDateFormat;
import java.util.ArrayList;
+import java.util.Date;
import java.util.List;
import cn.com.basic.face.base.BaseApplication;
@@ -113,6 +115,8 @@
if(deviceId != null && !deviceId.trim().isEmpty()) {
sb.append(" AND b.device_id=").append(deviceId);
}
+ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
+ sb.append(" AND a.time like '"+sdf.format(new Date())+"%' ");
String deviceCompanyId = BaseApplication.getInstance().getAndroidDevice().getCompanyId();
if(deviceCompanyId != null && !deviceCompanyId.trim().isEmpty()) {
sb.append(" AND a.device_company_id = ").append(deviceCompanyId);
@@ -120,7 +124,6 @@
sb.append(" ORDER BY a.time DESC");
StringBuilder count = new StringBuilder(sb.length());
count.append("select count(*) as count from (").append(sb).append(" ) _table");
- sb.append(" LIMIT ").append("0").append(",").append(100);
AttendanceDetailQueryItem aqi = null;
Cursor c = db.rawQuery(sb.toString(),new String[]{});
Cursor c_count = db.rawQuery(count.toString(),new String[]{});
--
Gitblit v1.8.0