| | |
|---|
| | | query.eq(ErpPurchaseOrderDO::getStatus, ErpAuditStatus.APPROVE.getStatus()) |
|---|
| | | .apply("t.return_count < t.in_count"); |
|---|
| | | } |
|---|
| | | // 可来票登记（剩余可开票金额 > 0）：金额已开完的订单不展示 |
|---|
| | | if (Boolean.TRUE.equals(reqVO.getRemainPriceEnable())) { |
|---|
| | | query.apply("t.total_price > (SELECT IFNULL(SUM(i.price), 0) FROM erp_purchase_invoice i " |
|---|
| | | + "WHERE i.purchase_order_id = t.id AND i.deleted = 0)"); |
|---|
| | | } |
|---|
| | | if (reqVO.getProductId() != null) { |
|---|
| | | query.leftJoin(ErpPurchaseOrderItemDO.class, ErpPurchaseOrderItemDO::getOrderId, ErpPurchaseOrderDO::getId) |
|---|
| | | .eq(reqVO.getProductId() != null, ErpPurchaseOrderItemDO::getProductId, reqVO.getProductId()) |
|---|
