开票台账删除

chenrui

4 天以前 e595e12fa1ec230ec866dadbe13779765ae6d075

开票台账删除

 src/main/java/com/ruoyi/sales/controller/InvoiceLedgerController.java

@@ -173,4 +173,19 @@
        return AjaxResult.success(invoiceLedgerService.invoiceLedgerProductDetail(id));
    }

    /**
     * 开票台账删除
     * @param invoiceRegistrationProductId
     * @return
     */
    @DeleteMapping("delInvoiceLedger/{invoiceRegistrationProductId}")
    public AjaxResult delInvoiceLedger(@PathVariable Integer invoiceRegistrationProductId) {
        try {
            invoiceLedgerService.delInvoiceLedger(invoiceRegistrationProductId);
            return AjaxResult.success();
        }catch (Exception e) {
            return AjaxResult.error(e.getMessage());
        }
    }

}

 src/main/java/com/ruoyi/sales/mapper/ReceiptPaymentMapper.java

@@ -62,4 +62,11 @@
     * 查询回款记录不分页
     */
    List<ReceiptPaymentDto> receiptPaymentHistoryListNoPage( @Param("params") ReceiptPaymentDto receiptPaymentDto);

    /**
     * 通过开票登记产品id查询是否已经有回款记录
     * @param invoiceRegistrationProductId
     * @return
     */
    List<ReceiptPayment> receiptPaymentListByProdRegId(Integer invoiceRegistrationProductId);
}

 src/main/java/com/ruoyi/sales/service/InvoiceLedgerService.java

@@ -104,4 +104,11 @@
     * @return
     */
    InvoiceRegistrationProductDto invoiceLedgerProductDetail(Integer id);

    /**
     * 开票台账删除
     * @param invoiceRegistrationProductId
     * @return
     */
    void delInvoiceLedger(Integer invoiceRegistrationProductId);
}

 src/main/java/com/ruoyi/sales/service/impl/InvoiceLedgerServiceImpl.java

@@ -10,12 +10,10 @@
import com.ruoyi.sales.dto.InvoiceLedgerDto;
import com.ruoyi.sales.dto.InvoiceRegistrationProductDto;
import com.ruoyi.sales.excel.InvoiceLedgerExcelDto;
import com.ruoyi.sales.mapper.InvoiceLedgerFileMapper;
import com.ruoyi.sales.mapper.InvoiceLedgerMapper;
import com.ruoyi.sales.mapper.InvoiceRegistrationMapper;
import com.ruoyi.sales.mapper.InvoiceRegistrationProductMapper;
import com.ruoyi.sales.mapper.*;
import com.ruoyi.sales.pojo.InvoiceLedger;
import com.ruoyi.sales.pojo.InvoiceLedgerFile;
import com.ruoyi.sales.pojo.ReceiptPayment;
import com.ruoyi.sales.service.InvoiceLedgerService;
import org.apache.commons.collections4.CollectionUtils;
import org.springframework.beans.BeanUtils;
@@ -52,7 +50,7 @@
    private InvoiceRegistrationProductMapper invoiceRegistrationProductMapper;

    @Autowired
    private InvoiceRegistrationMapper invoiceRegistrationMapper;
    private ReceiptPaymentMapper receiptPaymentMapper;

    /**
     * 开票台账新增
@@ -307,4 +305,23 @@
        return invoiceRegistrationProductDto;
    }

    /**
     * 开票台账删除
     * @param invoiceRegistrationProductId
     * @return
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public void delInvoiceLedger(Integer invoiceRegistrationProductId) {
        // 判断是否有回款记录
        List<ReceiptPayment> receiptPaymentList = receiptPaymentMapper.receiptPaymentListByProdRegId(invoiceRegistrationProductId);
        if(!CollectionUtils.isEmpty(receiptPaymentList)){
            throw new RuntimeException("请先删除回款记录");
        }
        // 删除开票台账

        // 删除开票登记
        // 回滚已开票数量
    }

}

 src/main/resources/mapper/sales/ReceiptPaymentMapper.xml

@@ -255,4 +255,14 @@
        ORDER BY T1.receipt_payment_date DESC
    </select>

    <select id="receiptPaymentListByProdRegId" resultType="com.ruoyi.sales.pojo.ReceiptPayment">
        SELECT
            T1.*
        FROM
            receipt_payment T1
                LEFT JOIN invoice_ledger T2 ON T1.invoice_ledger_id = T2.id
        WHERE
            T2.invoice_registration_product_id = #{invoiceRegistrationProductId}
    </select>

</mapper>