From 70577a6d6cf2bded29e71dcad11a0c2605193d20 Mon Sep 17 00:00:00 2001 From: lishuai <260038442@qq.com> Date: 星期二, 26 十二月 2023 10:32:31 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java | 55 +++++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 47 insertions(+), 8 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 484823e..1c94c15 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 @@ -14,6 +14,7 @@ import com.doumee.dao.business.join.CompanyJoinMapper; import com.doumee.dao.business.model.Category; import com.doumee.dao.business.model.Company; +import com.doumee.dao.business.model.Member; import com.doumee.dao.system.model.SystemUser; import com.doumee.service.business.CompanyService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; @@ -23,6 +24,7 @@ import com.github.yulichang.wrapper.MPJLambdaWrapper; import io.swagger.annotations.ApiModelProperty; import org.apache.commons.collections.CollectionUtils; +import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; @@ -82,7 +84,14 @@ @Override public void deleteById(Integer id) { - companyMapper.deleteById(id); + LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); + + Company company=new Company(); + company.setId(id); + company.setIsdeleted(Constants.ZERO); + company.setEditDate(new Date()); + company.setEditor(loginUserInfo.getId()); + companyMapper.updateById(company); } @Override @@ -96,7 +105,17 @@ if (CollectionUtils.isEmpty(ids)) { return; } - companyMapper.deleteBatchIds(ids); + LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); + Company company=new Company(); + + // companyMapper.deleteBatchIds(ids); + ids.stream().forEach(s->{ + company.setId(s); + company.setIsdeleted(Constants.ZERO); + company.setEditDate(new Date()); + company.setEditor(loginUserInfo.getId()); + companyMapper.updateById(company); + }); } @Override @@ -143,6 +162,7 @@ IPage<Company> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper<Company> queryWrapper = new MPJLambdaWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); + pageWrap.getModel().setIsdeleted(Constants.ZERO); if (pageWrap.getModel().getId() != null) { queryWrapper.eq(Company::getId, pageWrap.getModel().getId()); } @@ -164,7 +184,7 @@ queryWrapper.eq(Company::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getName() != null) { - queryWrapper.eq(Company::getName, pageWrap.getModel().getName()); + queryWrapper.like(Company::getName, pageWrap.getModel().getName()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.eq(Company::getRemark, pageWrap.getModel().getRemark()); @@ -237,17 +257,36 @@ queryWrapper.le(Company::getFsDate, Utils.Date.getEnd(pageWrap.getModel().getFsDate())); } queryWrapper.orderByDesc(Company::getCreateDate); - queryWrapper.leftJoin(Category.class,Category::getId,Company::getCategoryId) - .leftJoin(SystemUser.class,SystemUser::getId,Company::getCreator); + queryWrapper.leftJoin(Category.class,Category::getId,Company::getCategoryId); + /* .leftJoin(Member.class, Member::getId,Company::getHeadId)*/ + /* queryWrapper.leftJoin(" company c on c.id=t.parent_id");*/ queryWrapper.selectAll(Company.class) - .selectAs(Category::getName,Company::getCategoryName) - .select("count(t1.id) as countNum") - .selectAs(SystemUser::getRealname,Company::getCreatorName); + .select("(select count(m.id) from member m where m.COMPANY_ID=t.id and m.ISDELETED=0) as countNum") + /*.select("c.name as parentName");*/ + .selectAs(Category::getName,Company::getCategoryName); + /* .selectAs(Member::getName,Company::getHeadName) + .selectAs(Member::getPhone,Company::getHeadPhone) + .select("count(t1.id) as countNum");*/ +// queryWrapper.eq(Company::getType,Constants.ZERO); + queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getStatus()),Company::getStatus,Constants.ZERO); + queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Company::getName,pageWrap.getModel().getName()); + queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getParentName()),"c.name",pageWrap.getModel().getParentName()); IPage<Company> companyIPage = companyJoinMapper.selectJoinPage(page, Company.class, queryWrapper); return PageData.from(companyIPage); } @Override + public void updateStatusById(Company company) { + LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); + + company.setEditDate(new Date()); + company.setEditor(loginUserInfo.getId()); + company.setStatus(company.getStatus()); + companyMapper.updateById(company); + } + + + @Override public long count(Company company) { QueryWrapper<Company> wrapper = new QueryWrapper<>(company); return companyMapper.selectCount(wrapper); -- Gitblit v1.9.3