package cn.iocoder.yudao.module.im.dal.mysql.message;
|
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.framework.mybatis.core.util.MyBatisUtils;
|
import cn.iocoder.yudao.module.im.controller.admin.manager.message.vo.channel.ImChannelMessagePageReqVO;
|
import cn.iocoder.yudao.module.im.dal.dataobject.message.ImChannelMessageDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
/**
|
* IM 频道消息 Mapper
|
*
|
* @author 芋道源码
|
*/
|
@Mapper
|
public interface ImChannelMessageMapper extends BaseMapperX<ImChannelMessageDO> {
|
|
/**
|
* 拉取指定用户应收的频道消息
|
* <p>
|
* 命中条件：id 大于游标 + (receiver_user_ids 为空表示全员 OR 逗号分隔列表里包含当前 userId)
|
*
|
* @param userId 当前用户编号
|
* @param minId 游标；返回大于此值的消息
|
* @param size 返回条数
|
* @return 频道消息列表；按 id 升序
|
*/
|
default List<ImChannelMessageDO> selectListByUserAndMinId(Long userId, Long minId, Integer size) {
|
return selectList(new LambdaQueryWrapperX<ImChannelMessageDO>()
|
.gt(ImChannelMessageDO::getId, minId)
|
.and(w -> w.isNull(ImChannelMessageDO::getReceiverUserIds)
|
.or().eq(ImChannelMessageDO::getReceiverUserIds, "")
|
.or().apply(MyBatisUtils.findInSet("receiver_user_ids"), userId))
|
.orderByAsc(ImChannelMessageDO::getId)
|
.last("LIMIT " + size));
|
}
|
|
default Long selectCountByMaterialId(Long materialId) {
|
return selectCount(ImChannelMessageDO::getMaterialId, materialId);
|
}
|
|
default PageResult<ImChannelMessageDO> selectPage(ImChannelMessagePageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<ImChannelMessageDO>()
|
.eqIfPresent(ImChannelMessageDO::getChannelId, reqVO.getChannelId())
|
.eqIfPresent(ImChannelMessageDO::getMaterialId, reqVO.getMaterialId())
|
.betweenIfPresent(ImChannelMessageDO::getSendTime, reqVO.getSendTime())
|
.orderByDesc(ImChannelMessageDO::getId));
|
}
|
|
}
|
