| | |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
|---|
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
|---|
| | | import com.github.yulichang.query.MPJQueryWrapper; |
|---|
| | | import com.github.yulichang.wrapper.MPJLambdaWrapper; |
|---|
| | | import org.apache.commons.lang3.StringUtils; |
|---|
| | | import org.apache.shiro.SecurityUtils; |
|---|
| | | import org.checkerframework.checker.units.qual.C; |
|---|
| | |
|---|
| | | @Override |
|---|
| | | public PageData<Category> findPage(PageWrap<Category> pageWrap) { |
|---|
| | | IPage<Category> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
|---|
| | | QueryWrapper<Category> queryWrapper = new QueryWrapper<>(); |
|---|
| | | MPJLambdaWrapper<Category> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
|---|
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() + |
|---|
| | | systemDictDataBiz.queryByCode(Constants.FTP,Constants.BANNER_IMG).getCode(); |
|---|
| | | |
|---|
| | | queryWrapper.lambda().eq(Category::getIsdeleted,Constants.ZERO) |
|---|
| | | queryWrapper.selectAll(Category.class ); |
|---|
| | | if(Constants.equalsInteger(pageWrap.getModel().getType(),Constants.FOUR)){ |
|---|
| | | //如果是主线路，查询线路数和客户数 |
|---|
| | | queryWrapper.select( "(select count(1) from jk_line b where b.isdeleted=0 and b.CATEGORY_ID = t.id)",Category::getLineNum); |
|---|
| | | queryWrapper.select( "(select count(1) from jk_customer b left join jk_line c on b.line_id=c.id where c.isdeleted=0 and b.isdeleted=0 and c.CATEGORY_ID = t.id)",Category::getCustomerNum); |
|---|
| | | queryWrapper.select( "(select count(1) from jk_customer b left join jk_line c on b.line_id=c.id where c.isdeleted=0 and b.isdeleted=0 and c.CATEGORY_ID = t.id b.DISTANCE_STATUS = 1)",Category::getCustomerDoneNum); |
|---|
| | | } |
|---|
| | | queryWrapper.eq(Category::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Objects.nonNull(pageWrap.getModel().getType()),Category::getType,pageWrap.getModel().getType()) |
|---|
| | | .like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Category::getName,pageWrap.getModel().getName()) |
|---|
| | | .isNull(Category::getParentId) |
|---|
