package cn.iocoder.yudao.module.crm.dal.mysql.customer; import cn.hutool.core.collection.CollUtil; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.crm.dal.dataobject.customer.CrmCustomerProgressDO; import org.apache.ibatis.annotations.Mapper; import java.util.Collection; import java.util.Collections; import java.util.List; /** * 客户洽谈进度 Mapper * * @author 超级管理员 */ @Mapper public interface CrmCustomerProgressMapper extends BaseMapperX { default List selectListByCustomerId(Long customerId) { return selectList(new LambdaQueryWrapperX() .eq(CrmCustomerProgressDO::getCustomerId, customerId) .orderByDesc(CrmCustomerProgressDO::getProgressTime) .orderByDesc(CrmCustomerProgressDO::getId)); } /** * 查询多个客户的全部洽谈进度,按洽谈时间倒序,便于在内存中取每个客户的最新一条 */ default List selectListByCustomerIds(Collection customerIds) { if (CollUtil.isEmpty(customerIds)) { return Collections.emptyList(); } return selectList(new LambdaQueryWrapperX() .in(CrmCustomerProgressDO::getCustomerId, customerIds) .orderByDesc(CrmCustomerProgressDO::getProgressTime) .orderByDesc(CrmCustomerProgressDO::getId)); } }