| | |
| | | return selectPage(reqVO, new LambdaQueryWrapperX<CrmInvoiceDO>() |
| | | .eq(CrmInvoiceDO::getCustomerId, reqVO.getCustomerId()) // 必须传递 |
| | | .eqIfPresent(CrmInvoiceDO::getNo, reqVO.getNo()) |
| | | .likeIfPresent(CrmInvoiceDO::getInvoiceNo, reqVO.getInvoiceNo()) |
| | | .eqIfPresent(CrmInvoiceDO::getContractId, reqVO.getContractId()) |
| | | .orderByDesc(CrmInvoiceDO::getId)); |
| | | } |
| | |
| | | // 拼接自身的查询条件 |
| | | query.selectAll(CrmInvoiceDO.class) |
| | | .eqIfPresent(CrmInvoiceDO::getNo, pageReqVO.getNo()) |
| | | .likeIfPresent(CrmInvoiceDO::getInvoiceNo, pageReqVO.getInvoiceNo()) |
| | | .eqIfPresent(CrmInvoiceDO::getContractId, pageReqVO.getContractId()) |
| | | .eqIfPresent(CrmInvoiceDO::getAuditStatus, pageReqVO.getAuditStatus()) |
| | | .orderByDesc(CrmInvoiceDO::getId); |
| | |
| | | return selectCount(CrmInvoiceDO::getContractId, contractId); |
| | | } |
| | | |
| | | /** |
| | | * 查询合同下的全部开票(导入去重用) |
| | | */ |
| | | default List<CrmInvoiceDO> selectListByContractId(Long contractId) { |
| | | return selectList(new LambdaQueryWrapperX<CrmInvoiceDO>() |
| | | .eq(CrmInvoiceDO::getContractId, contractId) |
| | | .orderByAsc(CrmInvoiceDO::getId)); |
| | | } |
| | | |
| | | } |