| | |
| | | |
| | | @Override |
| | | public List<YwProject> findList(YwProject ywProject) { |
| | | ywProject.setIsdeleted(Constants.ZERO); |
| | | QueryWrapper<YwProject> wrapper = new QueryWrapper<>(ywProject); |
| | | return ywProjectMapper.selectList(wrapper); |
| | | } |
| | |
| | | IPage<YwProject> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | QueryWrapper<YwProject> queryWrapper = new QueryWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | pageWrap.getModel().setIsdeleted(Constants.ZERO); |
| | | queryWrapper.select("*,(select count(1) from yw_room a where a.isdeleted=0 and a.PROJECT_ID=yw_project.id) as roomNum"+ |
| | | ",(select count(1) from yw_room a where a.isdeleted=0 and a.PROJECT_ID=yw_project.id and a.IS_INVESTMENT=1) as roomRentNum"); |
| | | if (pageWrap.getModel().getId() != null) { |
| | | queryWrapper.lambda().eq(YwProject::getId, pageWrap.getModel().getId()); |
| | | } |
| | |
| | | if (pageWrap.getModel().getAddr() != null) { |
| | | queryWrapper.lambda().eq(YwProject::getAddr, pageWrap.getModel().getAddr()); |
| | | } |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | | if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { |
| | | queryWrapper.orderByDesc(sortData.getProperty()); |
| | | } else { |
| | | queryWrapper.orderByAsc(sortData.getProperty()); |
| | | } |
| | | } |
| | | queryWrapper.lambda().orderByDesc(YwProject::getCreateDate); |
| | | return PageData.from(ywProjectMapper.selectPage(page, queryWrapper)); |
| | | } |
| | | |