| | |
|---|
| | | @Override |
|---|
| | | public Sites findOne(Sites sites) { |
|---|
| | | QueryWrapper<Sites> wrapper = new QueryWrapper<>(sites); |
|---|
| | | return sitesMapper.selectOne(wrapper); |
|---|
| | | return sitesMapper.selectOne(wrapper.last(" limit 1")); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | |
|---|
| | | QueryWrapper<Sites> queryWrapper = new QueryWrapper<>(); |
|---|
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
|---|
| | | // queryWrapper.select("*,(select count(r.id) from locks r where r.site_id = sites.id) as localCount" + |
|---|
| | | queryWrapper.select( "*,(select count(r.bike_code) from locks r where r.site_id = sites.id and r.bike_code is null and r.bike_code !='' ) as bikeCount"); |
|---|
| | | queryWrapper.select("*,(select count(r.bike_code) from locks r where r.site_id = sites.id and r.bike_code is null and r.bike_code !='' ) as bikeCount"); |
|---|
| | | // Page<SitesMonitorDTO> sitesMonitorDTO = sitesMapper.getSitesMonitorDTO(page, pageWrap.getModel().getCode(), pageWrap.getModel().getName()); |
|---|
| | | queryWrapper.lambda().like(StringUtils.isNotBlank(pageWrap.getModel().getCode()),Sites::getCode,pageWrap.getModel().getCode()); |
|---|
| | | queryWrapper.lambda().like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Sites::getCode,pageWrap.getModel().getName()); |
|---|
