From 38ef4fef1899d8bdbd8d444a2e833a79e9253f5d Mon Sep 17 00:00:00 2001 From: jiaosong <jiaosong6760@dingtalk.com> Date: 星期一, 04 十二月 2023 17:55:15 +0800 Subject: [PATCH] #供应人员新增查询 --- server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java index 3161c88..1009c4a 100644 --- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java +++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java @@ -50,7 +50,6 @@ LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); checkUnique(company); - Company insert = new Company(); insert.setCreator(loginUserInfo.getId()); insert.setCreateDate(new Date()); @@ -233,6 +232,7 @@ .leftJoin(SystemUser.class,SystemUser::getId,Company::getCreator); queryWrapper.selectAll(Company.class) .selectAs(Category::getName,Company::getCategoryName) + .select("count(t1.id) as countNum") .selectAs(SystemUser::getRealname,Company::getCreatorName); IPage<Company> companyIPage = companyJoinMapper.selectJoinPage(page, Company.class, queryWrapper); return PageData.from(companyIPage); -- Gitblit v1.9.3