package com.ks.app.dao.user;
|
|
import com.ks.app.entity.SystemEnum;
|
import com.ks.app.entity.user.UserInfo;
|
import org.apache.ibatis.annotations.Param;
|
import org.springframework.stereotype.Repository;
|
import org.yeshi.utils.mybatis.BaseMapper;
|
import org.yeshi.utils.statistic.BaseStatisticMySQLTimeQuery;
|
import org.yeshi.utils.statistic.StatisticNumberResult;
|
|
import java.util.Date;
|
import java.util.List;
|
|
@Repository
|
public interface UserInfoDao extends BaseMapper<UserInfo> {
|
|
UserInfo selectByPrimaryKeyForUpdate(@Param("id") java.lang.Long id);
|
|
List<UserInfo> list(@Param("query") DaoQuery query);
|
|
List<UserInfo> listByUids(@Param("uidList") List<Long> uidList);
|
|
long count(@Param("query") DaoQuery query);
|
|
/**
|
* @author hxh
|
* @description 根据创建时间统计用户数量
|
* @date 18:58 2021/11/18
|
* @param: system
|
* @param: timeQuery
|
* @return java.util.List<org.yeshi.utils.statistic.http.StatisticNumberResult>
|
**/
|
List<StatisticNumberResult> statisticByCreateTime(@Param("system") SystemEnum system, @Param("timeQuery") BaseStatisticMySQLTimeQuery timeQuery);
|
|
public static class DaoQuery {
|
public SystemEnum system;
|
public Long wxId;
|
public Long qqId;
|
public String nickName;
|
public String phone;
|
public String email;
|
public Date maxCreateTime;
|
public Date minCreateTime;
|
public Integer status;
|
public long start;
|
public int count;
|
public List<String> sortList;
|
}
|
|
}
|
