From 8b7fc3718d7cf847858e26db6a1b3421710ce1f8 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期一, 16 九月 2019 15:52:28 +0800
Subject: [PATCH] UserInfo DAO层修改
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java | 126 +++++++++++++++++++++++------------------
1 files changed, 71 insertions(+), 55 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java
index 3a3c31e..a76ce7f 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java
@@ -17,9 +17,15 @@
int insertSelective(UserInfo record);
- UserInfo selectByPrimaryKey(Long id);
-
- UserInfo selectByPKey(Long id);
+ UserInfo selectByPrimaryKey(Long id);
+
+ /**
+ * 鏌ヨ鏈夋晥鐨�
+ *
+ * @param id
+ * @return
+ */
+ UserInfo selectAvailableByPrimaryKey(Long id);
UserInfo selectByPrimaryKeyForUpdate(Long id);
@@ -47,14 +53,13 @@
// 鏍规嵁AppId涓庣數璇濆彿鐮佽幏鍙栫敤鎴�
List<UserInfo> listByAppIdAndPhone(@Param("appId") String appId, @Param("phone") String phone);
-
+
// 鏍规嵁鑾峰彇鐢佃瘽鍙风爜鏈夋晥鐢ㄦ埛
UserInfo getEffectiveUserInfoByPhone(@Param("phone") String phone);
-
+
// 鏍规嵁鑾稺XUnionId鏈夋晥鐢ㄦ埛
UserInfo getEffectiveUserInfoByWXUnionId(@Param("unionId") String unionId);
-
-
+
Long getMaxUid();
/**
@@ -63,33 +68,38 @@
* @param mainUid-涓昏处鍙�
* @param lessUid-鍓处鍙�
*/
- void connectUser(@Param("mainUid")Long mainUid,@Param("lessUid") Long lessUid);
-
-
+ void connectUser(@Param("mainUid") Long mainUid, @Param("lessUid") Long lessUid);
+
/**
*
* @param start
* @param count
- * @param key 鏌ヨ鏉′欢
- * @param userType 鐢ㄦ埛绫诲瀷
- * @param days 澶╂暟
- * @param startTime 娉ㄥ唽鏃堕棿 -灏�
- * @param endTime 娉ㄥ唽鏃堕棿 -澶�
- * @param orderMode 鎺掑簭鏂瑰紡
+ * @param key
+ * 鏌ヨ鏉′欢
+ * @param userType
+ * 鐢ㄦ埛绫诲瀷
+ * @param days
+ * 澶╂暟
+ * @param startTime
+ * 娉ㄥ唽鏃堕棿 -灏�
+ * @param endTime
+ * 娉ㄥ唽鏃堕棿 -澶�
+ * @param orderMode
+ * 鎺掑簭鏂瑰紡
* @return
*/
- List<UserInfoVO> query(@Param("start") long start, @Param("count") int count, @Param("userState")Integer userState,
- @Param("key") String key, @Param("keyType") Integer keyType,
- @Param("userRank") String userRank, @Param("days")Integer days,
- @Param("startTime") String startTime, @Param("endTime") String endTime,
+ List<UserInfoVO> query(@Param("start") long start, @Param("count") int count, @Param("userState") Integer userState,
+ @Param("key") String key, @Param("keyType") Integer keyType, @Param("userRank") String userRank,
+ @Param("days") Integer days, @Param("startTime") String startTime, @Param("endTime") String endTime,
@Param("orderField") Integer orderField, @Param("orderMode") Integer orderMode);
-
- long queryCount( @Param("userState")Integer userState, @Param("key") String key, @Param("keyType") Integer keyType,
- @Param("userRank")String userRank,@Param("days")Integer days,
- @Param("startTime") String startTime, @Param("endTime") String endTime);
-
+
+ long queryCount(@Param("userState") Integer userState, @Param("key") String key, @Param("keyType") Integer keyType,
+ @Param("userRank") String userRank, @Param("days") Integer days, @Param("startTime") String startTime,
+ @Param("endTime") String endTime);
+
/**
* 缁熻褰撳墠鏌ヨ缁撴灉鎬婚噾棰�
+ *
* @param title
* @param userType
* @param days
@@ -97,87 +107,93 @@
* @param endTime
* @return
*/
- double querySumMoney(@Param("key") String key, @Param("userType")Integer userType, @Param("days")Integer days,
+ double querySumMoney(@Param("key") String key, @Param("userType") Integer userType, @Param("days") Integer days,
@Param("startTime") String startTime, @Param("endTime") String endTime);
-
+
/**
* 缁熻鐢ㄦ埛鏁伴噺
- * @param isToday 缁熻浠婃棩
- * @param isMonth 缁熻褰撴湀 浜屽垯涓嶅彲鍚屾椂瀛樺湪
+ *
+ * @param isToday
+ * 缁熻浠婃棩
+ * @param isMonth
+ * 缁熻褰撴湀 浜屽垯涓嶅彲鍚屾椂瀛樺湪
* @return
*/
long countNewUser(@Param("isToday") Integer isToday, @Param("isMonth") Integer isMonth);
-
+
/**
* 鏍规嵁绛夌骇缁熻鐢ㄦ埛鏁伴噺
+ *
* @param rank
* @return
*/
long countRank(@Param("rank") Integer rank);
-
+
/**
- * 缁熻鎵�鏈夌敤鎴锋�婚噾棰� 鎴� 鍙彁鐜伴噾棰�
+ * 缁熻鎵�鏈夌敤鎴锋�婚噾棰� 鎴� 鍙彁鐜伴噾棰�
+ *
* @param minMoney
* @return
*/
BigDecimal countAllMoney(@Param("minMoney") Double minMoney);
-
-
+
/**
- * 瓒呰繃 daysNum 澶╂湭鐧婚檰鐨勭敤鎴�
+ * 瓒呰繃 daysNum 澶╂湭鐧婚檰鐨勭敤鎴�
+ *
* @param minMoney
* @return
*/
List<Long> longTimeNoLogin(@Param("daysNum") int daysNum, @Param("list") List<Long> list);
-
+
/**
* 缁熻娴佸け鐢ㄦ埛鏁伴噺:锛� num 澶╂湭浣跨敤鐧诲綍骞朵笖鏃犱换浣曡祫閲戞祦鍔ㄧ殑璐﹀彿鏁伴噺锛�
- * @param num 180
+ *
+ * @param num
+ * 180
* @return
*/
long countLoseUser(@Param("num") int num);
-
-
+
/**
* 绱鏈夎喘涔扮敤鎴锋暟
+ *
* @return
*/
long countHasOrderUser();
-
/**
* 缁熻鏂板鐢ㄦ埛
+ *
* @return
*/
- List<Map<String, Object>> countNewUserByDate(@Param("channel")String channel,@Param("type")Integer type, @Param("years") String years,
- @Param("startTime")String startTime, @Param("endTime")String endTime);
-
-
+ List<Map<String, Object>> countNewUserByDate(@Param("channel") String channel, @Param("type") Integer type,
+ @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime);
+
/**
* 缁熻鏂板鐢ㄦ埛褰撴棩浜х敓璁㈠崟鐢ㄦ埛鏁伴噺
+ *
* @return
*/
- List<Map<String, Object>> getTodayHasOrder(@Param("channel")String channel,@Param("type")Integer type, @Param("years") String years,
- @Param("startTime")String startTime, @Param("endTime")String endTime);
-
-
+ List<Map<String, Object>> getTodayHasOrder(@Param("channel") String channel, @Param("type") Integer type,
+ @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime);
+
/**
* 缁熻鏂板鐢ㄦ埛涓�鍛ㄤ骇鐢熻鍗曠敤鎴锋暟閲�
+ *
* @return
*/
- Map<String, Object> getWeekHasOrder(@Param("channel")String channel, @Param("startTime")String startTime,
- @Param("endTime")String endTime, @Param("orderNum")Integer orderNum);
-
-
+ Map<String, Object> getWeekHasOrder(@Param("channel") String channel, @Param("startTime") String startTime,
+ @Param("endTime") String endTime, @Param("orderNum") Integer orderNum);
+
/**
* 鏍规嵁鐢佃瘽鍙风爜銆侀個璇风爜鑾峰彇閭�璇风敤鎴�
+ *
* @param phone
* @param inviteCode
* @return
*/
- UserInfo getInfoByPhoneOrInviteCode(@Param("phone")String phone, @Param("inviteCode")String inviteCode);
-
-
+ UserInfo getInfoByPhoneOrInviteCode(@Param("phone") String phone, @Param("inviteCode") String inviteCode);
+
// 鏍规嵁AppId涓庣數璇濆彿鐮佽幏鍙栫敤鎴�
List<UserInfo> listByClosed(@Param("appId") String appId, @Param("phone") String phone);
--
Gitblit v1.8.0