| | |
| | | InvoiceRegistrationProduct invoiceRegistrationProduct = invoiceRegistrationProductMapper.selectById(productDto.getId()); |
| | | SalesLedgerProduct salesLedgerProduct = salesLedgerProductMapper.selectById(invoiceRegistrationProduct.getSalesLedgerProductId()); |
| | | |
| | | BigDecimal invoiceNum = productDto.getInvoiceTotal().divide(invoiceRegistrationProduct.getTaxInclusiveTotalPrice(), 2, BigDecimal.ROUND_HALF_UP); |
| | | BigDecimal invoiceNum = productDto.getInvoiceTotal().divide(invoiceRegistrationProduct.getTaxInclusiveUnitPrice(), 2, BigDecimal.ROUND_HALF_UP); |
| | | //计算 未开票数/未开票金额 |
| | | BigDecimal noInvoiceAmount = salesLedgerProduct.getNoInvoiceAmount().add(invoiceRegistrationProduct.getInvoiceAmount()).subtract(productDto.getInvoiceTotal()); |
| | | BigDecimal noInvoiceNum = salesLedgerProduct.getNoInvoiceNum().add(invoiceRegistrationProduct.getInvoiceNum()).subtract(invoiceNum); |
| | |
| | | T2.project_name |
| | | FROM invoice_registration_product T1 |
| | | LEFT JOIN sales_ledger T2 ON T1.sales_ledger_id = T2.id |
| | | LEFT JOIN invoice_ledger T3 ON T1.id = T3.invoice_registration_product_id |
| | | RIGHT JOIN invoice_ledger T3 ON T1.id = T3.invoice_registration_product_id |
| | | LEFT JOIN ( |
| | | SELECT |
| | | invoice_ledger_id, |