From 0912f56a392bdf48315747c64ec0c18bf0aa29a6 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期三, 30 六月 2021 19:07:11 +0800
Subject: [PATCH] 礼金红包兼容
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java | 446 ++++++++++++++++++++++++++++---------------------------
1 files changed, 227 insertions(+), 219 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 be6b1d2..dc59977 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
@@ -1,220 +1,228 @@
-package com.yeshi.fanli.dao.mybatis;
-
-import java.math.BigDecimal;
-import java.util.List;
-
-import org.apache.ibatis.annotations.Param;
-
-import com.yeshi.fanli.dto.ChartTDO;
-import com.yeshi.fanli.entity.bus.user.UserInfo;
-import com.yeshi.fanli.vo.user.UserInfoVO;
-
-public interface UserInfoMapper {
-
- int deleteByPrimaryKey(Long id);
-
- int insert(UserInfo record);
-
- int insertSelective(UserInfo record);
-
- UserInfo selectByPrimaryKey(Long id);
-
- /**
- * 鏌ヨ鏈夋晥鐨�
- *
- * @param id
- * @return
- */
- UserInfo selectAvailableByPrimaryKey(Long id);
-
- UserInfo selectByPrimaryKeyForUpdate(Long id);
-
- int updateByPrimaryKeySelective(UserInfo record);
-
- int updateByPrimaryKey(UserInfo record);
-
- // 鍑忔帀鐢ㄦ埛绾㈠寘閲戦
- int subHongBaoByUid(@Param("uid") long uid, @Param("money") BigDecimal money);
-
- // 澧炲姞鐢ㄦ埛绾㈠寘閲戦
- int addHongBaoByUid(@Param("uid") long uid, @Param("money") BigDecimal money);
-
- void cleanPassword(long id);
-
- BigDecimal getNewPeopleHB(Long id);
-
- BigDecimal getMyHB(Long id);
-
- // 鏍规嵁AppId涓庡井淇nionID鑾峰彇鐢ㄦ埛
- List<UserInfo> listByAppIdAndWXUnionId(@Param("appId") String appId, @Param("unionId") String unionId);
-
- // 鏍规嵁AppId涓庢窐瀹漁penId鑾峰彇鐢ㄦ埛
- List<UserInfo> listByAppIdAndTaoBaoOpenId(@Param("appId") String appId, @Param("openId") String openId);
-
- // 鏍规嵁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();
-
- /**
- * 铻嶅悎璐﹀彿
- *
- * @param mainUid-涓昏处鍙�
- * @param 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
- * 鎺掑簭鏂瑰紡
- * @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,
- @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);
-
- /**
- * 缁熻褰撳墠鏌ヨ缁撴灉鎬婚噾棰�
- *
- * @param title
- * @param userType
- * @param days
- * @param startTime
- * @param endTime
- * @return
- */
- 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
- * 缁熻褰撴湀 浜屽垯涓嶅彲鍚屾椂瀛樺湪
- * @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 澶╂湭鐧婚檰鐨勭敤鎴�
- *
- * @param minMoney
- * @return
- */
- List<Long> longTimeNoLogin(@Param("daysNum") int daysNum, @Param("list") List<Long> list);
-
- /**
- * 缁熻娴佸け鐢ㄦ埛鏁伴噺:锛� num 澶╂湭浣跨敤鐧诲綍骞朵笖鏃犱换浣曡祫閲戞祦鍔ㄧ殑璐﹀彿鏁伴噺锛�
- *
- * @param num
- * 180
- * @return
- */
- long countLoseUser(@Param("num") int num);
-
- /**
- * 绱鏈夎喘涔扮敤鎴锋暟
- *
- * @return
- */
- long countHasOrderUser();
-
- /**
- * 缁熻鏂板鐢ㄦ埛
- *
- * @return
- */
- List<ChartTDO> countNewUserByDate(@Param("channel") String channel, @Param("type") Integer type,
- @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime);
-
- /**
- * 缁熻鏂板鐢ㄦ埛褰撴棩浜х敓璁㈠崟鐢ㄦ埛鏁伴噺
- *
- * @return
- */
- List<ChartTDO> getTodayHasOrder(@Param("channel") String channel, @Param("type") Integer type,
- @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime);
-
- /**
- * 缁熻鏂板鐢ㄦ埛涓�鍛ㄤ骇鐢熻鍗曠敤鎴锋暟閲�
- *
- * @return
- */
- ChartTDO 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);
-
- // 鏍规嵁AppId涓庣數璇濆彿鐮佽幏鍙栫敤鎴�
- List<UserInfo> listByClosed(@Param("appId") String appId, @Param("phone") String phone);
-
- long countAvaiableUser();
-
-
- /**
- * 鏌ヨ婊¤冻鑷姩鎻愮幇鐢ㄦ埛
- * @param start
- * @param count
- * @return
- */
- List<UserInfo> getAutoExtractUser(@Param("start") int start, @Param("count") int count, @Param("money") BigDecimal money,
- @Param("beganDate") String beganDate, @Param("endDate") String endDate);
-
-
- /**
- * 鏌ヨ婊¤冻鑷姩鎻愮幇鐢ㄦ埛
- * @param start
- * @param count
- * @return
- */
- List<UserInfo> getAutoExtractUserTo1212(@Param("start") int start, @Param("count") int count);
+package com.yeshi.fanli.dao.mybatis;
+
+import java.math.BigDecimal;
+import java.util.List;
+
+import com.ks.lijin.query.BaseDaoQuery;
+import com.yeshi.fanli.entity.SystemEnum;
+import org.apache.ibatis.annotations.Param;
+
+import com.yeshi.fanli.dto.ChartTDO;
+import com.yeshi.fanli.entity.bus.user.UserInfo;
+import com.yeshi.fanli.vo.user.UserInfoVO;
+
+public interface UserInfoMapper {
+
+ int deleteByPrimaryKey(Long id);
+
+ int insert(UserInfo record);
+
+ int insertSelective(UserInfo record);
+
+ UserInfo selectByPrimaryKey(Long id);
+
+ /**
+ * 鏌ヨ鏈夋晥鐨�
+ *
+ * @param id
+ * @return
+ */
+ UserInfo selectAvailableByPrimaryKey(Long id);
+
+ UserInfo selectByPrimaryKeyForUpdate(Long id);
+
+ int updateByPrimaryKeySelective(UserInfo record);
+
+ int updateByPrimaryKey(UserInfo record);
+
+ // 鍑忔帀鐢ㄦ埛绾㈠寘閲戦
+ int subHongBaoByUid(@Param("uid") long uid, @Param("money") BigDecimal money);
+
+ // 澧炲姞鐢ㄦ埛绾㈠寘閲戦
+ int addHongBaoByUid(@Param("uid") long uid, @Param("money") BigDecimal money);
+
+ void cleanPassword(long id);
+
+ BigDecimal getNewPeopleHB(Long id);
+
+ BigDecimal getMyHB(Long id);
+
+ List<UserInfo> list(@Param("query") DaoQuery query);
+
+ Long getMaxUid();
+
+ List<UserInfoVO> queryInfo(@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("userType") Integer userType, @Param("level") String level, @Param("activeCode") Integer activeCode, @Param("system") SystemEnum system);
+
+ long countInfo(@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("userType") Integer userType, @Param("level") String level,
+ @Param("activeCode") Integer activeCode, @Param("system") SystemEnum system);
+
+
+ /**
+ * @param start
+ * @param count
+ * @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,
+ @Param("orderField") Integer orderField, @Param("orderMode") Integer orderMode,
+ @Param("userType") Integer userType, @Param("level") String level, @Param("activeCode") Integer activeCode, @Param("system") SystemEnum system);
+
+ 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("userType") Integer userType, @Param("level") String level,
+ @Param("activeCode") Integer activeCode, @Param("system") SystemEnum system);
+
+ /**
+ * 缁熻褰撳墠鏌ヨ缁撴灉鎬婚噾棰�
+ *
+ * @param title
+ * @param userType
+ * @param days
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ 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 缁熻褰撴湀 浜屽垯涓嶅彲鍚屾椂瀛樺湪
+ * @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 澶╂湭鐧婚檰鐨勭敤鎴�
+ *
+ * @param minMoney
+ * @return
+ */
+ List<Long> longTimeNoLogin(@Param("daysNum") int daysNum, @Param("list") List<Long> list);
+
+ /**
+ * 缁熻娴佸け鐢ㄦ埛鏁伴噺:锛� num 澶╂湭浣跨敤鐧诲綍骞朵笖鏃犱换浣曡祫閲戞祦鍔ㄧ殑璐﹀彿鏁伴噺锛�
+ *
+ * @param num 180
+ * @return
+ */
+ long countLoseUser(@Param("num") int num);
+
+ /**
+ * 绱鏈夎喘涔扮敤鎴锋暟
+ *
+ * @return
+ */
+ long countHasOrderUser();
+
+ /**
+ * 缁熻鏂板鐢ㄦ埛
+ *
+ * @return
+ */
+ List<ChartTDO> countNewUserByDate(@Param("channel") String channel, @Param("type") Integer type,
+ @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime);
+
+ /**
+ * 缁熻鏂板鐢ㄦ埛褰撴棩浜х敓璁㈠崟鐢ㄦ埛鏁伴噺
+ *
+ * @return
+ */
+ List<ChartTDO> getTodayHasOrder(@Param("channel") String channel, @Param("type") Integer type,
+ @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime);
+
+ /**
+ * 缁熻鏂板鐢ㄦ埛涓�鍛ㄤ骇鐢熻鍗曠敤鎴锋暟閲�
+ *
+ * @return
+ */
+ ChartTDO getWeekHasOrder(@Param("channel") String channel, @Param("startTime") String startTime,
+ @Param("endTime") String endTime, @Param("orderNum") Integer orderNum);
+
+ /**
+ * 鏍规嵁鐢佃瘽鍙风爜銆侀個璇风爜鑾峰彇閭�璇风敤鎴�
+ *
+ * @param phone
+ * @param inviteCode
+ * @return
+ */
+ UserInfo getUserInfoByInviteCode(@Param("inviteCode") String inviteCode);
+
+ // 鏍规嵁AppId涓庣數璇濆彿鐮佽幏鍙栫敤鎴�
+ List<UserInfo> listByClosed(@Param("appId") String appId, @Param("phone") String phone);
+
+ long countAvaiableUser();
+
+ /**
+ * 鏌ヨ婊¤冻鑷姩鎻愮幇鐢ㄦ埛
+ *
+ * @param start
+ * @param count
+ * @return
+ */
+
+ List<UserInfo> getAutoExtractUser(@Param("start") int start, @Param("count") int count,
+ @Param("money") BigDecimal money, @Param("beganDate") String beganDate, @Param("endDate") String endDate);
+
+ /**
+ * 鏍规嵁type妫�绱�
+ *
+ * @param type
+ * @param start
+ * @param count
+ * @return
+ */
+ List<UserInfo> listByType(@Param("type") int type, @Param("start") long start, @Param("count") int count);
+
+ long countByType(int type);
+
+ /**
+ * 鏌ヨ婊¤冻鑷姩鎻愮幇鐢ㄦ埛
+ *
+ * @param start
+ * @param count
+ * @return
+ */
+ List<UserInfo> getAutoExtractUserTo1212(@Param("start") int start, @Param("count") int count);
+
+
+ public static class DaoQuery extends BaseDaoQuery {
+ public String phone;
+ public String wxUnionId;
+ public String openId;
+ public String qqOpenId;
+ public SystemEnum system;
+ public Integer state;
+ }
+
}
\ No newline at end of file
--
Gitblit v1.8.0