From deb3baf0fb04c3a9f5b0d4b5bd9fb3237908d576 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期一, 19 二月 2024 18:38:12 +0800 Subject: [PATCH] 111 --- server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java | 15 ++++++++++++--- 1 files changed, 12 insertions(+), 3 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java index f9c781b..a980821 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/TaxesServiceImpl.java @@ -393,9 +393,18 @@ queryWrapper.le(queryModel.getEndDate() != null,Taxes::getCreateDate, (queryModel.getEndDate())); queryWrapper.eq(!Objects.isNull(queryModel.getInsuranceApplyId()),Taxes::getInsuranceApplyId,queryModel.getInsuranceApplyId()); queryWrapper.eq(!Objects.isNull(queryModel.getStatus()),Taxes::getStatus,queryModel.getStatus()); + queryWrapper.exists(!Objects.isNull(queryModel.getApplyId())," select 1 from tax_detial td where td.insurance_apply_id = "+queryModel.getApplyId()+" and t.id = td.tax_id "); } queryWrapper.orderByAsc(Taxes::getCreateDate); - return taxesJoinMapper.selectJoinList(Taxes.class, queryWrapper); + + List<Taxes> result = taxesJoinMapper.selectJoinList(Taxes.class, queryWrapper); + String path =systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode()+systemDictDataBiz.queryByCode(Constants.OSS,Constants.TAXES_FILE).getCode(); + for(Taxes t : result){ + if(StringUtils.isNotBlank(t.getImgurl())){ + t.setImgurlFull(path + t.getImgurl()); + } + } + return result; } @@ -409,7 +418,7 @@ || Objects.isNull(entrustInvoicingDTO.getInvoicingMoney()) || Objects.isNull(entrustInvoicingDTO.getType()) || Objects.isNull(entrustInvoicingDTO.getTaxDetialList()) - || StringUtils.isNotBlank(entrustInvoicingDTO.getAddress()) + || StringUtils.isBlank(entrustInvoicingDTO.getAddress()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } @@ -447,7 +456,7 @@ //鏌ヨ姣忎釜淇濆崟涓嬪彲浠ユ姇淇濈殑閲戦 InsuranceApply insuranceApply = insuranceApplyJoinMapper.selectJoinOne(InsuranceApply.class,new MPJLambdaWrapper<InsuranceApply>() .selectAll(InsuranceApply.class) - .select(" ( select sum(td.fee) from taxes ts inner join tax_detial td on ts.TAX_ID = ts.id where ts.status != 2 and td.INSURANCE_APPLY_ID = t.id ) as taxesMoney ") + .select(" ifnull(( select sum(td.fee) from taxes ts inner join tax_detial td on td.TAX_ID = ts.id where ts.status != 2 and td.INSURANCE_APPLY_ID = t.id ),0) as taxesMoney ") .eq(InsuranceApply::getId,taxDetial.getInsuranceApplyId()) ); if(Objects.isNull(insuranceApply)){ -- Gitblit v1.9.3