| | |
|---|
| | | query.eq(ErpPurchaseOrderDO::getStatus, ErpAuditStatus.APPROVE.getStatus()) |
|---|
| | | .apply("t.return_count < t.in_count"); |
|---|
| | | } |
|---|
| | | // 可来票登记（剩余可开票金额 > 0）：金额已开完的订单不展示 |
|---|
| | | if (Boolean.TRUE.equals(reqVO.getRemainPriceEnable())) { |
|---|
| | | // 编辑来票时（invoiceId 非空）剔除本张来票自身的分摊，相当于把它已分摊的金额退回订单 |
|---|
| | | String sql = "t.total_price > (SELECT IFNULL(SUM(a.price), 0) FROM erp_purchase_invoice_order a " |
|---|
| | | + "INNER JOIN erp_purchase_invoice i ON i.id = a.invoice_id AND i.deleted = 0 " |
|---|
| | | + "WHERE a.purchase_order_id = t.id AND a.deleted = 0"; |
|---|
| | | if (reqVO.getInvoiceId() != null) { |
|---|
| | | query.apply(sql + " AND a.invoice_id <> {0})", reqVO.getInvoiceId()); |
|---|
| | | } else { |
|---|
| | | query.apply(sql + ")"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if (reqVO.getProductId() != null) { |
|---|
| | | query.leftJoin(ErpPurchaseOrderItemDO.class, ErpPurchaseOrderItemDO::getOrderId, ErpPurchaseOrderDO::getId) |
|---|
| | | .eq(reqVO.getProductId() != null, ErpPurchaseOrderItemDO::getProductId, reqVO.getProductId()) |
|---|
| | |
|---|
| | | return selectOne(ErpPurchaseOrderDO::getNo, no); |
|---|
| | | } |
|---|
| | | |
|---|
| | | default ErpPurchaseOrderDO selectByProcessInstanceId(String processInstanceId) { |
|---|
| | | return selectOne(ErpPurchaseOrderDO::getProcessInstanceId, processInstanceId); |
|---|
| | | } |
|---|
| | | |
|---|
| | | default List<ErpPurchaseOrderDO> selectList(Long supplierId, Integer status) { |
|---|
| | | return selectList(new LambdaQueryWrapperX<ErpPurchaseOrderDO>() |
|---|
| | | .eqIfPresent(ErpPurchaseOrderDO::getSupplierId, supplierId) |
|---|
