From 65ad99e0a5e47c2cfcfd9ceade7dc6f2b83bcbd2 Mon Sep 17 00:00:00 2001 From: jiaosong <jiaosong6760@dingtalk.com> Date: 星期三, 11 十月 2023 16:38:54 +0800 Subject: [PATCH] #pgsql 订单退款 结算退款 未消费结算 --- 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