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<CrmCustomerProgressDO> {
|
|
default List<CrmCustomerProgressDO> selectListByCustomerId(Long customerId) {
|
return selectList(new LambdaQueryWrapperX<CrmCustomerProgressDO>()
|
.eq(CrmCustomerProgressDO::getCustomerId, customerId)
|
.orderByDesc(CrmCustomerProgressDO::getProgressTime)
|
.orderByDesc(CrmCustomerProgressDO::getId));
|
}
|
|
/**
|
* 查询多个客户的全部洽谈进度，按洽谈时间倒序，便于在内存中取每个客户的最新一条
|
*/
|
default List<CrmCustomerProgressDO> selectListByCustomerIds(Collection<Long> customerIds) {
|
if (CollUtil.isEmpty(customerIds)) {
|
return Collections.emptyList();
|
}
|
return selectList(new LambdaQueryWrapperX<CrmCustomerProgressDO>()
|
.in(CrmCustomerProgressDO::getCustomerId, customerIds)
|
.orderByDesc(CrmCustomerProgressDO::getProgressTime)
|
.orderByDesc(CrmCustomerProgressDO::getId));
|
}
|
|
}
|
