| | |
|---|
| | | 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; |
|---|
| | |
|---|
| | | 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.orderByDesc(Company::getCreateDate); |
|---|
| | | queryWrapper.leftJoin(Category.class,Category::getId,Company::getCategoryId) |
|---|
| | | .leftJoin(SystemUser.class,SystemUser::getId,Company::getCreator); |
|---|
| | | .leftJoin(Member.class, Member::getId,Company::getHeadId); |
|---|
| | | queryWrapper.selectAll(Company.class) |
|---|
| | | .selectAs(Category::getName,Company::getCategoryName) |
|---|
| | | .select("count(t1.id) as countNum") |
|---|
| | | .selectAs(SystemUser::getRealname,Company::getCreatorName); |
|---|
| | | .selectAs(Member::getName,Company::getHeadName) |
|---|
| | | .selectAs(Member::getPhone,Company::getHeadPhone) |
|---|
| | | .select("count(t1.id) as countNum"); |
|---|
| | | IPage<Company> companyIPage = companyJoinMapper.selectJoinPage(page, Company.class, queryWrapper); |
|---|
| | | return PageData.from(companyIPage); |
|---|
| | | } |
|---|
