From 1b0cf0db5c82ea8308d2f338973a91555787c34d Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期二, 18 三月 2025 11:17:23 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev

---
 server/services/src/main/java/com/doumee/service/business/impl/SitesServiceImpl.java |   50 ++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 46 insertions(+), 4 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 64b2943..1bfd82a 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
@@ -10,6 +10,7 @@
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
 import com.doumee.core.utils.Utils;
+import com.doumee.core.wx.WxMiniUtilService;
 import com.doumee.dao.business.LocksMapper;
 import com.doumee.dao.business.SitesMapper;
 import com.doumee.dao.business.model.Locks;
@@ -30,6 +31,7 @@
 import org.springframework.util.CollectionUtils;
 
 import java.math.BigDecimal;
+import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
 import java.util.Objects;
@@ -52,6 +54,7 @@
     @Autowired
     private SystemDictDataBiz systemDictDataBiz;
 
+
     @Override
     public String create(Sites sites) {
         LoginUserInfo principal = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
@@ -64,6 +67,7 @@
             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"绔欑偣缂栧彿宸插瓨鍦�");
         }
         Sites insert = new Sites();
+        insert.setId(sites.getCode());
         insert.setCreateDate(new Date());
         insert.setCreator(principal.getId());
         insert.setEditDate(new Date());
@@ -72,10 +76,10 @@
         insert.setInfo(sites.getInfo());
         insert.setName(sites.getName());
         insert.setCode(sites.getCode());
-        insert.setStatus(sites.getStatus());
+        insert.setStatus(Constants.ZERO);
         insert.setLockNum(sites.getLockNum());
         insert.setIp(sites.getIp());
-        sitesMapper.insert(sites);
+        sitesMapper.insert(insert);
         return sites.getId();
     }
 
@@ -101,7 +105,15 @@
     @Override
     public void updateById(Sites sites) {
         LoginUserInfo principal = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+        QueryWrapper<Sites> wrapper = new QueryWrapper<>();
+        wrapper.lambda()
+                .eq(Sites::getCode,sites.getCode());
+        Sites count = sitesMapper.selectOne(wrapper);
+        if (Objects.nonNull(count) && !count.getId().equals(sites.getId())){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"绔欑偣缂栧彿宸插瓨鍦�");
+        }
         Sites update = new Sites();
+        update.setId(sites.getId());
         update.setCreateDate(new Date());
         update.setEditor(principal.getId());
         update.setName(sites.getName());
@@ -209,7 +221,7 @@
          ",(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());
+        queryWrapper.lambda().like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Sites::getName,pageWrap.getModel().getName());
         queryWrapper.lambda().orderByAsc(Sites::getCode);
         IPage<Sites> sitesMonitorDTO = sitesMapper.selectPage(page, queryWrapper);
         if (!CollectionUtils.isEmpty(sitesMonitorDTO.getRecords())){
@@ -226,7 +238,37 @@
     }
 
     @Override
-    public void siteReservesNotice(String siteId) throws Exception {
+    public void siteReservesNotice()  throws Exception{
+        QueryWrapper<Sites> queryWrapper = new QueryWrapper<>();
+        queryWrapper.select(" *, " +
+                " (select count(r.id) from locks r where r.site_id = sites.id) as all_lock_num ," +
+                "(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");
+        queryWrapper.lambda().eq(Sites::getStatus,Constants.ZERO);
+        queryWrapper.lambda().eq(Sites::getIsdeleted,Constants.ZERO);
+        queryWrapper.lambda().orderByAsc(Sites::getCode);
+        List<Sites> sitesList = sitesMapper.selectList(queryWrapper);
+        if (!CollectionUtils.isEmpty(sitesList)){
+                for (Sites s:sitesList) {
+                    if(Constants.formatIntegerNum(s.getAllLockNum())<=Constants.ZERO){
+                        continue;
+                    }
+                    BigDecimal warnMin = new BigDecimal(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.WARN_MIN).getCode());
+                    BigDecimal warnMax = new BigDecimal(systemDictDataBiz.queryByCode(Constants.MINI_PROGRAMME,Constants.WARN_MAX).getCode());
+                    BigDecimal rata = new BigDecimal(s.getBikeCount()).divide(new BigDecimal(s.getAllLockNum()),2,BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100L));
+                    if(rata.compareTo(warnMax)>Constants.ZERO){
+                        //鍙戦�侀拤閽夐�氱煡
+                        DingDingNotice.reservesNotice(StringUtils.isBlank(s.getName())?s.getId() + " - 鏈煡" :s.getId() + " - " + s.getName(),
+                                systemDictDataBiz.queryByCode(Constants.DINGDING,Constants.DINGDING_URL).getCode(),
+                                systemDictDataBiz.queryByCode(Constants.DINGDING,Constants.DINGDING_SECRET).getCode(),Constants.ZERO,warnMax);
+                    }else if(rata.compareTo(warnMin)<Constants.ZERO){
+                        //鍙戦�侀拤閽夐�氱煡
+                        DingDingNotice.reservesNotice(StringUtils.isBlank(s.getName())?s.getId() + " - 鏈煡" :s.getId() + " - " + s.getName(),
+                                systemDictDataBiz.queryByCode(Constants.DINGDING,Constants.DINGDING_URL).getCode(),
+                                systemDictDataBiz.queryByCode(Constants.DINGDING,Constants.DINGDING_SECRET).getCode(),Constants.ONE,warnMin);
+                    }
+                }
+        }
+
 
     }
 }

--
Gitblit v1.9.3