| | |
| | | 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; |
| | |
| | | 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; |
| | |
| | | |
| | | @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 |
| | |
| | | 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 |
| | |
| | | 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()); |
| | | } |
| | |
| | | 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()); |
| | |
| | | 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); |