gaoluyang
昨天 8c65f898ed6e5b0c7a94c792c4562f6ec831dccd
yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/invoice/CrmInvoiceMapper.java
@@ -133,6 +133,32 @@
    }
    /**
     * 批量查询多个销售订单下、指定审批状态的开票(财务对账报表使用,避免逐单查询)
     */
    default List<CrmInvoiceDO> selectListBySaleOrderIdsAndStatus(Collection<Long> saleOrderIds,
                                                                 Collection<Integer> auditStatuses) {
        if (CollUtil.isEmpty(saleOrderIds)) {
            return Collections.emptyList();
        }
        return selectList(new LambdaQueryWrapperX<CrmInvoiceDO>()
                .in(CrmInvoiceDO::getSaleOrderId, saleOrderIds)
                .in(CrmInvoiceDO::getAuditStatus, auditStatuses));
    }
    /**
     * 批量查询多个销售出库单下、指定审批状态的开票(财务对账报表使用,避免逐单查询)
     */
    default List<CrmInvoiceDO> selectListBySaleOutIdsAndStatus(Collection<Long> saleOutIds,
                                                               Collection<Integer> auditStatuses) {
        if (CollUtil.isEmpty(saleOutIds)) {
            return Collections.emptyList();
        }
        return selectList(new LambdaQueryWrapperX<CrmInvoiceDO>()
                .in(CrmInvoiceDO::getSaleOutId, saleOutIds)
                .in(CrmInvoiceDO::getAuditStatus, auditStatuses));
    }
    /**
     * 查询合同下的全部开票(导入去重用)
     */
    default List<CrmInvoiceDO> selectListByContractId(Long contractId) {