| | |
| | | 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)); |
| | | |
| | | |
| | |
| | | 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); |
| | |
| | | queryWrapper.selectAll(Taxes.class); |
| | | queryWrapper.selectAs(SystemUser::getRealname,Taxes::getCreatorName); |
| | | queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Taxes::getCreator); |
| | | |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | queryWrapper.eq(Taxes::getIsdeleted, Constants.ZERO); |
| | | Taxes queryModel = pageWrap.getModel(); |
| | |
| | | |
| | | |
| | | |
| | | @Override |
| | | public List<Taxes> findListForCompany(Taxes queryModel) { |
| | | LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); |
| | | MPJLambdaWrapper<Taxes> queryWrapper = new MPJLambdaWrapper<>(); |
| | | queryWrapper.selectAll(Taxes.class); |
| | | queryWrapper.selectAs(SystemUser::getRealname,Taxes::getCreatorName); |
| | | queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Taxes::getCreator); |
| | | |
| | | queryWrapper.eq(Taxes::getIsdeleted, Constants.ZERO); |
| | | if(!user.getType().equals(Constants.ONE)){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"非企业用户无法进行该业务查询"); |
| | | } |
| | | if(!Objects.isNull(queryModel)){ |
| | | queryWrapper.ge(queryModel.getStartDate() != null,Taxes::getCreateDate, (queryModel.getStartDate())); |
| | | 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.orderByAsc(Taxes::getCreateDate); |
| | | return taxesJoinMapper.selectJoinList(Taxes.class, queryWrapper); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | @Override |