From f4a0f2acc63d7785eab108419a4e16f5f688cb95 Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期六, 18 一月 2020 12:06:27 +0800 Subject: [PATCH] 用户注册信息 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/UserInfoMapper.java | 41 +++++++++++++++++++++++++++++++++++++---- 1 files changed, 37 insertions(+), 4 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 4f52495..f24e8d4 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,7 +17,7 @@ int insertSelective(UserInfo record); - UserInfo selectByPrimaryKey(Long id); + UserInfo selectByPrimaryKey(Long id); /** * 鏌ヨ鏈夋晥鐨� @@ -59,6 +59,9 @@ // 鏍规嵁鑾稺XUnionId鏈夋晥鐢ㄦ埛 UserInfo getEffectiveUserInfoByWXUnionId(@Param("unionId") String unionId); + + //鏍规嵁寰俊openid鏌ヨ + UserInfo getEffectiveUserInfoByWXOpenId(@Param("wxOpenId") String wxOpenId); Long getMaxUid(); @@ -91,11 +94,11 @@ 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("orderField") Integer orderField, @Param("orderMode") Integer orderMode,@Param("userType") Integer userType); 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("endTime") String endTime,@Param("userType") Integer userType); /** * 缁熻褰撳墠鏌ヨ缁撴灉鎬婚噾棰� @@ -192,10 +195,40 @@ * @param inviteCode * @return */ - UserInfo getInfoByPhoneOrInviteCode(@Param("phone") String phone, @Param("inviteCode") String inviteCode); + 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); } \ No newline at end of file -- Gitblit v1.8.0