From 43aa7504b0faa390ae778e6c56d8c4a42e5154ac Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期四, 05 十二月 2024 14:37:07 +0800 Subject: [PATCH] 开发更新 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java | 76 ++++++++++++++++++++----------------- 1 files changed, 41 insertions(+), 35 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java index 90cf756..4683542 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwContractServiceImpl.java @@ -1228,47 +1228,53 @@ ,Constants.YwLogType.CONTRACT_UPDATE.getKey()) .orderByAsc(YwWorkorderLog::getCreateDate))); - //鏌ヨ璐﹀崟闆嗗悎 - model.setBillList(ywContractBillMapper.selectJoinList(YwContractBill.class,new MPJLambdaWrapper<YwContractBill>() - .selectAll(YwContractBill.class ) - .select(" ( select ifnull(sum(case when yw.REVENUE_TYPE = 0 then yw.ACT_RECEIVABLE_FEE else -yw.ACT_RECEIVABLE_FEE end),0) from yw_contract_revenue yw where yw.bill_id = t.id and yw.status = 0 and yw.isdeleted = 0 ) as actReceivableFee ") - .eq( YwContractBill::getContractId,model.getId()) - .eq(YwContractBill::getIsdeleted,Constants.ZERO) - .orderByAsc(YwContractBill::getSortnum,YwContractBill::getCreateDate))); + queryBillListByModel(model,new Date()); + } + return model; + } + @Override + public YwContract findForBills(YwContract model) { + queryBillListByModel(model,model.getBtDate()); + return model; - for (YwContractBill ywContractBill:model.getBillList()) { - ywContractBill.setNeedReceivableFee(ywContractBill.getReceivableFee().subtract(ywContractBill.getActReceivableFee())); - } + } + private void queryBillListByModel(YwContract model,Date date) { + //鏌ヨ璐﹀崟闆嗗悎 + model.setBillList(ywContractBillMapper.selectJoinList(YwContractBill.class,new MPJLambdaWrapper<YwContractBill>() + .selectAll(YwContractBill.class ) + .select(" ( select ifnull(sum(case when yw.REVENUE_TYPE = 0 then yw.ACT_RECEIVABLE_FEE else -yw.ACT_RECEIVABLE_FEE end),0) from yw_contract_revenue yw where yw.bill_id = t.id and yw.status = 0 and yw.isdeleted = 0 ) as actReceivableFee ") + .eq( YwContractBill::getContractId,model.getId()) + .eq(YwContractBill::getIsdeleted,Constants.ZERO) + .orderByAsc(YwContractBill::getSortnum,YwContractBill::getCreateDate))); - model.setCanBackRentBills(new ArrayList<>()); - long nowStart = Utils.Date.getStart(new Date()).getTime(); - long nowEnd = Utils.Date.getEnd(new Date()).getTime(); - if(model.getBillList()!=null && model.getBillList().size()>0){ - for(YwContractBill bill: model.getBillList()){ - //浠樻鐘舵�侊細0=寰呮敹娆撅紱1=宸茬粨娓咃紱2=閮ㄥ垎缁撴竻锛�3=寰呬粯娆撅紱4=寰呴��娆撅紱5=宸插叧闂� - if(Constants.equalsInteger(bill.getPayStatus(),Constants.ZERO) - ||Constants.equalsInteger(bill.getPayStatus(),Constants.THREE)){ - if(bill.getStartDate().getTime()>nowEnd){ - //濡傛灉杩樻病寮�濮嬶紝璐﹀崟鐩存帴鍏抽棴 - continue; - } - model.getCanBackRentBills().add(bill); - - }else if(Constants.equalsInteger(bill.getPayStatus(),Constants.ONE) ){ - if(bill.getEndDate().getTime()<nowStart){ - //濡傛灉宸茬粨娓咃紝璐﹀崟鐩存帴鍏抽棴 - continue; - } - model.getCanBackRentBills().add(bill); - }else if(Constants.equalsInteger(bill.getPayStatus(),Constants.TWO) ){ - model.getCanBackRentBills().add(bill); + for (YwContractBill ywContractBill:model.getBillList()) { + ywContractBill.setNeedReceivableFee(ywContractBill.getReceivableFee().subtract(ywContractBill.getActReceivableFee())); + } + model.setCanBackRentBills(new ArrayList<>()); + long nowStart = Utils.Date.getStart(date).getTime(); + long nowEnd = Utils.Date.getEnd(date).getTime(); + if(model.getBillList()!=null && model.getBillList().size()>0){ + for(YwContractBill bill: model.getBillList()){ + //浠樻鐘舵�侊細0=寰呮敹娆撅紱1=宸茬粨娓咃紱2=閮ㄥ垎缁撴竻锛�3=寰呬粯娆撅紱4=寰呴��娆撅紱5=宸插叧闂� + if(Constants.equalsInteger(bill.getPayStatus(),Constants.ZERO) + ||Constants.equalsInteger(bill.getPayStatus(),Constants.THREE)){ + if(bill.getStartDate().getTime()>nowEnd){ + //濡傛灉杩樻病寮�濮嬶紝璐﹀崟鐩存帴鍏抽棴 + continue; } + model.getCanBackRentBills().add(bill); + + }else if(Constants.equalsInteger(bill.getPayStatus(),Constants.ONE) ){ + if(bill.getEndDate().getTime()<nowStart){ + //濡傛灉宸茬粨娓咃紝璐﹀崟鐩存帴鍏抽棴 + continue; + } + model.getCanBackRentBills().add(bill); + }else if(Constants.equalsInteger(bill.getPayStatus(),Constants.TWO) ){ + model.getCanBackRentBills().add(bill); } } - } - - return model; } @Override -- Gitblit v1.9.3