package cn.iocoder.yudao.module.finance.dal.mysql.voucher;
|
|
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.module.finance.controller.admin.voucher.vo.FinVoucherPageReqVO;
|
import cn.iocoder.yudao.module.finance.dal.dataobject.voucher.FinVoucherDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.time.LocalDate;
|
import java.util.Collection;
|
import java.util.List;
|
|
/**
|
* 记账凭证 Mapper
|
*
|
* @author 超级管理员
|
*/
|
@Mapper
|
public interface FinVoucherMapper extends BaseMapperX<FinVoucherDO> {
|
|
/**
|
* @param creatorIds 制单人编号集合。列表里展示的是昵称，所以 reqVO.getCreator() 拿到的是昵称/编号这类
|
* 搜索词，由 Service 先解析成编号集合再传进来；传 null 表示不按制单人过滤。
|
*/
|
default PageResult<FinVoucherDO> selectPage(FinVoucherPageReqVO reqVO, Collection<String> creatorIds) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<FinVoucherDO>()
|
.likeIfPresent(FinVoucherDO::getVoucherNo, reqVO.getVoucherNo())
|
.likeIfPresent(FinVoucherDO::getSummary, reqVO.getSummary())
|
// 注意：creator 存的是用户编号，搜索词不是编号（是昵称）时不能直接 like，
|
// 否则「赵磊」这种昵称永远匹配不上；Service 已经把搜索词解析成编号集合
|
.inIfPresent(FinVoucherDO::getCreator, creatorIds)
|
.eqIfPresent(FinVoucherDO::getStatus, reqVO.getStatus())
|
.betweenIfPresent(FinVoucherDO::getVoucherDate, reqVO.getVoucherDate())
|
.orderByDesc(FinVoucherDO::getVoucherDate)
|
.orderByDesc(FinVoucherDO::getId));
|
}
|
|
default FinVoucherDO selectByVoucherNo(String voucherNo) {
|
return selectOne(FinVoucherDO::getVoucherNo, voucherNo);
|
}
|
|
default List<FinVoucherDO> selectListByIds(Collection<Long> ids) {
|
return selectList(new LambdaQueryWrapperX<FinVoucherDO>()
|
.in(FinVoucherDO::getId, ids));
|
}
|
|
default Long selectCountByStatus(Integer status) {
|
return selectCount(FinVoucherDO::getStatus, status);
|
}
|
|
default List<FinVoucherDO> selectListByDateBetween(LocalDate startDate, LocalDate endDate) {
|
return selectList(new LambdaQueryWrapperX<FinVoucherDO>()
|
.geIfPresent(FinVoucherDO::getVoucherDate, startDate)
|
.leIfPresent(FinVoucherDO::getVoucherDate, endDate));
|
}
|
|
}
|
