From ddafb0f0951e68b4e56bfceef43cf78559f5161f Mon Sep 17 00:00:00 2001
From: zuoxiao <470321431@qq.com>
Date: 星期三, 26 六月 2024 14:52:27 +0800
Subject: [PATCH] 1.修复河南版本域名卡结构不同问题 2.修复齐河版本最终购水日期的bug
---
qihealonelibrary/src/main/java/com/dayu/qihealonelibrary/dao/UserCardDao.java | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/qihealonelibrary/src/main/java/com/dayu/qihealonelibrary/dao/UserCardDao.java b/qihealonelibrary/src/main/java/com/dayu/qihealonelibrary/dao/UserCardDao.java
index d28bfd2..52c88c2 100644
--- a/qihealonelibrary/src/main/java/com/dayu/qihealonelibrary/dao/UserCardDao.java
+++ b/qihealonelibrary/src/main/java/com/dayu/qihealonelibrary/dao/UserCardDao.java
@@ -33,11 +33,16 @@
@Query("select * from UserCardBean where date>=:beginTime and date<=:endTime")
List<UserCardBean> findByTime(long beginTime, long endTime);
+
@Query("select * from UserCardBean where userName like :data or userID like :data or phone like :data")
List<UserCardBean> findByData(String data);
@Query("select * from UserCardBean order by date desc LIMIT :limit OFFSET :offset")
- List<UserCardBean> findAll(int offset,int limit);
+ List<UserCardBean> findAll(int offset, int limit);
+
@Query("select COUNT(*) from UserCardBean")
int getUserTotale();
+
+ @Query("select * from UserCardBean where cardNumber =:data order by date desc")
+ List<UserCardBean> findUserName(String data);
}
--
Gitblit v1.8.0