| src/main/resources/mapper/sales/SalesLedgerProductMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/resources/mapper/sales/SalesLedgerProductMapper.xml
@@ -166,7 +166,7 @@ resultType="com.ruoyi.purchase.dto.ProcurementBusinessSummaryStatisticsDto"> SELECT COALESCE(SUM(slp.tax_inclusive_total_price), 0) AS purchaseTotalAmount, COALESCE(COUNT(DISTINCT slp.product_category), 0) AS productCategoryCount, COALESCE(COUNT(DISTINCT slp.product_model_id), 0) AS productCategoryCount, COALESCE(SUM(rop.allocated_return_amount), 0) AS returnTotalAmount FROM sales_ledger_product slp LEFT JOIN purchase_ledger sl ON slp.sales_ledger_id = sl.id
