| | |
|---|
| | | .leftJoin(YwProject.class,YwProject::getId,YwBuilding::getProjectId); |
|---|
| | | 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=t.id) as roomNum"+ |
|---|
| | | queryWrapper.select(" (select count(1) from yw_room a where a.isdeleted=0 and a.BUILDING_ID=t.id) as roomNum "+ |
|---|
| | | ",(select count(1) from yw_room a where a.isdeleted=0 and a.BUILDING_ID=t.id and a.IS_INVESTMENT=1) as roomRentNum"); |
|---|
| | | if (pageWrap.getModel().getId() != null) { |
|---|
| | | queryWrapper.eq(YwBuilding::getId, pageWrap.getModel().getId()); |
|---|
