server/company/src/main/java/com/doumee/api/business/SolutionsController.java
@@ -67,12 +67,13 @@ return ApiResponse.success(null); } @ApiOperation("分页查询") @ApiOperation("【平台端】分页查询") @PostMapping("/page") @RequiresPermissions("business:solutions:query") public ApiResponse<PageData<Solutions>> findPage (@RequestBody PageWrap<Solutions> pageWrap) { return ApiResponse.success(solutionsService.findPage(pageWrap)); } @ApiOperation("列表查询") @PostMapping("/list") @RequiresPermissions("business:solutions:query") server/service/src/main/java/com/doumee/service/business/SolutionsService.java
@@ -87,6 +87,7 @@ * @return PageData<Solutions> */ PageData<Solutions> findPage(PageWrap<Solutions> pageWrap); PageData<Solutions> findPageCom(PageWrap<Solutions> pageWrap); /** * 条件统计 server/service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java
@@ -448,7 +448,7 @@ if(model == null ||Constants.equalsInteger(model.getIsdeleted(),Constants.ONE)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } MPJLambdaWrapper<CompanySolution> csWrapper = new MPJLambdaWrapper<>(); /*MPJLambdaWrapper<CompanySolution> csWrapper = new MPJLambdaWrapper<>(); csWrapper.selectAll(CompanySolution.class); csWrapper.selectAs(Solutions::getName,CompanySolution::getSolutionName); csWrapper.leftJoin(Solutions.class,Solutions::getId,CompanySolution::getSolutionBaseId); @@ -456,7 +456,7 @@ csWrapper.eq(CompanySolution::getIsdeleted,Constants.ZERO); csWrapper.orderByAsc(CompanySolution::getSortnum); model.setSolutionList(companySolutionJoinMapper.selectJoinList(CompanySolution.class,csWrapper)); */ initImgData(model); return model; } server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java
@@ -359,6 +359,34 @@ } return PageData.from(solutionsMapper.selectPage(page, queryWrapper)); } @Override public PageData<Solutions> findPageCom(PageWrap<Solutions> pageWrap) { IPage<Solutions> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); QueryWrapper<Solutions> queryWrapper = new QueryWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); pageWrap.getModel().setDataType(Constants.ZERO);//只选择基表数据 pageWrap.getModel().setStatus(Constants.ZERO); pageWrap.getModel().setIsdeleted(Constants.ZERO); LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); queryWrapper.exists(("select b.id from company_solution b where b.isdeleted=0 and b.company_id="+user.getCompanyId()+" and b.SOLUTION_BASE_ID = solutions.id")); if (pageWrap.getModel().getName() != null) { queryWrapper.lambda().like(Solutions::getName, pageWrap.getModel().getName()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.lambda().eq(Solutions::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getSortnum() != null) { queryWrapper.lambda().eq(Solutions::getSortnum, pageWrap.getModel().getSortnum()); } if (pageWrap.getModel().getInsuranceId() != null) { queryWrapper.lambda().eq(Solutions::getInsuranceId, pageWrap.getModel().getInsuranceId()); } if (pageWrap.getModel().getBaseId() != null) { queryWrapper.lambda().eq(Solutions::getBaseId, pageWrap.getModel().getBaseId()); } queryWrapper.lambda().orderByAsc(Solutions::getInsuranceId); return PageData.from(solutionsMapper.selectPage(page, queryWrapper)); } @Override public long count(Solutions solutions) {