From d1c6020dc36ce118ce9f13ba81caa70d7117d94c Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期四, 12 十月 2023 12:14:33 +0800 Subject: [PATCH] Merge branch 'dev' of http://139.186.142.91:10010/r/productDev/parkBike into dev --- server/services/src/main/java/com/doumee/service/business/impl/SitesServiceImpl.java | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/server/services/src/main/java/com/doumee/service/business/impl/SitesServiceImpl.java b/server/services/src/main/java/com/doumee/service/business/impl/SitesServiceImpl.java index f3f4186..7fdb63f 100644 --- a/server/services/src/main/java/com/doumee/service/business/impl/SitesServiceImpl.java +++ b/server/services/src/main/java/com/doumee/service/business/impl/SitesServiceImpl.java @@ -128,7 +128,7 @@ @Override public Sites findOne(Sites sites) { QueryWrapper<Sites> wrapper = new QueryWrapper<>(sites); - return sitesMapper.selectOne(wrapper); + return sitesMapper.selectOne(wrapper.last(" limit 1")); } @Override @@ -206,7 +206,7 @@ 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()); -- Gitblit v1.9.3