| | |
|---|
| | | queryWrapper.selectAll(YwRoom.class ) |
|---|
| | | .selectAs(YwProject::getName,YwRoom::getProjectName) |
|---|
| | | .selectAs(YwFloor::getName,YwRoom::getFloorName) |
|---|
| | | .select(" ifnull( ( select case when y1.status = 3 then now() BETWEEN y1.START_DATE and y1.BT_DATE else now() BETWEEN y1.START_DATE and y1.END_DATE END " + |
|---|
| | | "from yw_contract y1 left join yw_contract_room y2 on y1.id = y2.CONTRACT_ID and y2.TYPE = 0 " + |
|---|
| | | "where y1.`STATUS` <> 4 and y2.room_id = t.id order by y1.create_date desc limit 1 ) ,0) ",YwRoom::getLeaseStatus) |
|---|
| | | .selectAs(YwBuilding::getName,YwRoom::getBuildingName) |
|---|
| | | .leftJoin(YwProject.class,YwProject::getId,YwRoom::getProjectId) |
|---|
| | | .leftJoin(YwBuilding.class,YwBuilding::getId,YwRoom::getBuildingId) |
|---|
