From 5cd7b2fc0df22213a58bf8181e519482b3e4447d Mon Sep 17 00:00:00 2001 From: jiaosong <jiaosong6760@dingtalk.com> Date: 星期三, 25 十月 2023 17:46:51 +0800 Subject: [PATCH] # 时间设置 --- 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 d3c549d..64b2943 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 @@ -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 all_lock_num" + - ",(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"); + ",(select count(l.bike_code) from locks l where l.site_id = sites.id and l.bike_code IS NOT NULL and l.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()); @@ -215,7 +215,7 @@ if (!CollectionUtils.isEmpty(sitesMonitorDTO.getRecords())){ sitesMonitorDTO.getRecords().forEach(s->{ if(Constants.formatIntegerNum(s.getAllLockNum()) >0){ - s.setRate(new BigDecimal(s.getBikeCount()).divide(new BigDecimal(s.getAllLockNum()),BigDecimal.ROUND_UP).setScale(2)); + s.setRate(new BigDecimal(s.getBikeCount()).divide(new BigDecimal(s.getAllLockNum()),2,BigDecimal.ROUND_HALF_UP)); }else{ s.setRate(new BigDecimal(0.0)); } -- Gitblit v1.9.3