| | |
| | | |
| | | @Override |
| | | public List<YwBuilding> findList(YwBuilding ywBuilding) { |
| | | ywBuilding.setIsdeleted(Constants.ZERO); |
| | | QueryWrapper<YwBuilding> wrapper = new QueryWrapper<>(ywBuilding); |
| | | return ywBuildingMapper.selectList(wrapper); |
| | | } |
| | |
| | | IPage<YwBuilding> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | QueryWrapper<YwBuilding> 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.BUILDING_ID=yw_building.id) as roomNum"+ |
| | | ",(select count(1) from yw_room a where a.isdeleted=0 and a.BUILDING_ID=yw_building.id and a.IS_INVESTMENT=1) as roomRentNum"); |
| | | if (pageWrap.getModel().getId() != null) { |
| | | queryWrapper.lambda().eq(YwBuilding::getId, pageWrap.getModel().getId()); |
| | | } |