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 UserInfoMapper 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;
    }

}