| | |
| | | private List<TaxDetial> getJoinDetailListById(Integer id) { |
| | | MPJLambdaWrapper<TaxDetial> queryWrapper = new MPJLambdaWrapper<>(); |
| | | queryWrapper.selectAll(TaxDetial.class); |
| | | queryWrapper.selectAs(Solutions::getName,TaxDetial::getSolutionName); |
| | | queryWrapper.selectAs(Taxes::getDoneCode,TaxDetial::getTaxDoneCode); |
| | | queryWrapper.selectAs(Taxes::getCreateDate,TaxDetial::getTaxCreateDate); |
| | | queryWrapper.selectAs(InsuranceApply::getCode,TaxDetial::getApplyCode); |
| | | queryWrapper.selectAs(ApplyChange::getCode,TaxDetial::getChangApplyCode); |
| | | queryWrapper.select("(CASE t.type\n" + |
| | | queryWrapper.selectAs(ApplyChange::getValidCode,TaxDetial::getChangApplyCode); |
| | | /* queryWrapper.select("(CASE t.type\n" + |
| | | "WHEN 0 THEN (select count(1) from apply_detail c where c.APPLY_ID=t.INSURANCE_APPLY_ID) \n" + |
| | | "ELSE 0 \n" + |
| | | "END) as applyNum,\n" + |
| | |
| | | "(CASE t.type \n" + |
| | | "WHEN 1 THEN (select count(1) from apply_chagne_detail c where c.APPLY_CHANGE_ID=t.APPLY_CHANGE_ID) \n" + |
| | | "ELSE 0 \n" + |
| | | "END) as applyChangeAddNum"); |
| | | "END) as applyChangeAddNum");*/ |
| | | queryWrapper.leftJoin(InsuranceApply.class,InsuranceApply::getId,TaxDetial::getInsuranceApplyId); |
| | | queryWrapper.leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId); |
| | | queryWrapper.leftJoin(ApplyChange.class,ApplyChange::getId,TaxDetial::getApplyChangeId); |
| | | queryWrapper.leftJoin(Taxes.class,Taxes::getId,TaxDetial::getDelTaxId); |
| | | queryWrapper.eq( TaxDetial::getTaxId,id); |
| | | List<TaxDetial> detialList = taxDetailJoinMapper.selectJoinList(TaxDetial.class,queryWrapper.orderByAsc(TaxDetial::getType)); |
| | | return detialList; |
| | | } |
| | |
| | | List<TaxDetial> applyList = new ArrayList<>();//投保和加减保 |
| | | List<TaxDetial> delList = new ArrayList<>();//冲红单 |
| | | if(detialList!=null){ |
| | | for(TaxDetial d :delList){ |
| | | d.setSolutionName(model.getSolutionName()); |
| | | for(TaxDetial d :detialList){ |
| | | // d.setSolutionName(model.getSolutionName()); |
| | | d.setFee(Constants.formatBigdecimal(d.getFee())); |
| | | d.setTotalFee(Constants.formatBigdecimal(d.getTotalFee())); |
| | | if(Constants.equalsInteger(d.getType(),Constants.ZERO) || Constants.equalsInteger(d.getType(),Constants.ONE)){ |
| | | if(Constants.equalsInteger(d.getType(),Constants.ZERO) |
| | | || Constants.equalsInteger(d.getType(),Constants.ONE)){ |
| | | applyList.add(d); |
| | | }else if(Constants.equalsInteger(d.getType(),Constants.TWO)){ |
| | | delList.add(d); |
| | |
| | | .selectAll(InsuranceApply.class) |
| | | .selectAs(Solutions::getName,InsuranceApply::getSolutionsName) |
| | | .select(" ( select count(1) from apply_detail ad where ad.apply_id = t.id ) as insureNum") |
| | | .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId) |
| | | .notExists(" select 1 from taxes t1 inner join tax_detial t2 on t1.id = t2.tax_id where t2.type = 0 and t1.status != 2 and t.id = t2.INSURANCE_APPLY_ID ") |
| | | .eq(InsuranceApply::getStatus,Constants.InsuranceApplyStatus.UPLOAD_INSURANCE.getKey()) |
| | | .eq(InsuranceApply::getId,id) |
| | |
| | | if(CollectionUtils.isNotEmpty(applyChangeList)){ |
| | | for (ApplyChange applyChange:applyChangeList) { |
| | | insuranceApply.setFee(insuranceApply.getFee().subtract(applyChange.getFee())); |
| | | TaxesInvoicingVO taxesInvoicingVO = applyChange.getTaxesInvoicingVO(); |
| | | TaxesInvoicingVO taxesInvoicingVO = applyChange.toTaxesInvoicingVO(); |
| | | if(!Objects.isNull(insuranceApply)){ |
| | | taxesInvoicingVO.setAmount(BigDecimal.ZERO); |
| | | } |
| | |
| | | || Objects.isNull(directInvoicingDTO.getInvoicingMoney()) |
| | | || Objects.isNull(directInvoicingDTO.getType()) |
| | | || Objects.isNull(directInvoicingDTO.getInvoicingDetailDTOList()) |
| | | || StringUtils.isNotBlank(directInvoicingDTO.getAddress()) |
| | | || StringUtils.isBlank(directInvoicingDTO.getAddress()) |
| | | ){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |