From 79b5a1c92e219128d50b58714eb2f6ec0f695d83 Mon Sep 17 00:00:00 2001
From: sgj <1442489573@qq.com>
Date: 星期三, 04 三月 2026 16:58:51 +0800
Subject: [PATCH] 添加第一版gis监管页面,建模版本

---
 fzzy-igdss-web/src/main/java/com/fzzy/group/manager/GroupManager.java |  465 ++++++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 432 insertions(+), 33 deletions(-)

diff --git a/fzzy-igdss-web/src/main/java/com/fzzy/group/manager/GroupManager.java b/fzzy-igdss-web/src/main/java/com/fzzy/group/manager/GroupManager.java
index adfc479..b974889 100644
--- a/fzzy-igdss-web/src/main/java/com/fzzy/group/manager/GroupManager.java
+++ b/fzzy-igdss-web/src/main/java/com/fzzy/group/manager/GroupManager.java
@@ -1,22 +1,26 @@
 package com.fzzy.group.manager;
 
+import com.fzzy.common.manager.CommonManager;
 import com.fzzy.igds.constant.Constant;
-import com.fzzy.igds.data.ChartPie;
-import com.fzzy.igds.data.GisData;
-import com.fzzy.igds.domain.Depot;
-import com.fzzy.igds.domain.Dept;
-import com.fzzy.igds.domain.DicArea;
-import com.fzzy.igds.service.CoreDeptService;
-import com.fzzy.igds.service.DepotService;
-import com.fzzy.igds.service.DicAreaService;
+import com.fzzy.igds.constant.FoodVariety;
+import com.fzzy.igds.constant.RespCodeEnum;
+import com.fzzy.igds.data.*;
+import com.fzzy.igds.domain.*;
+import com.fzzy.igds.service.*;
 import com.fzzy.igds.utils.ContextUtil;
+import com.fzzy.igds.utils.DateUtil;
+import com.fzzy.igds.utils.NumberUtil;
 import com.ruoyi.common.utils.StringUtils;
 import lombok.extern.slf4j.Slf4j;
+import org.apache.commons.lang3.time.DateFormatUtils;
 import org.springframework.stereotype.Component;
 
 import javax.annotation.Resource;
 import java.text.DecimalFormat;
-import java.util.*;
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.LinkedHashMap;
+import java.util.List;
 
 /**
  * @Description
@@ -28,11 +32,28 @@
 public class GroupManager {
 
     @Resource
+    private CommonManager commonManager;
+    @Resource
     private DicAreaService dicAreaService;
     @Resource
     private CoreDeptService deptService;
     @Resource
     private DepotService depotService;
+    @Resource
+    private CoreCompanyService coreCompanyService;
+    @Resource
+    private InoutRecordService inoutRecordService;
+    @Resource
+    private EventInfoService eventInfoService;
+    @Resource
+    private SnapRecordService snapRecordService;
+    @Resource
+    private SecCameraService cameraService;
+    @Resource
+    private BankService bankService;
+
+    @Resource
+    private PledgeContractService pledgeContractService;
 
     /**
      * 鑾峰彇鐪佸強涓嬪睘甯傚窞闆嗗悎
@@ -104,23 +125,370 @@
         return list;
     }
 
+
+    public List<DicArea> getBankAndChildDept(String areaCode) {
+
+        DicArea area = dicAreaService.listDicAreaByCode(areaCode);
+        if (null == area) {
+            return null;
+        }
+        List<DicArea> areaChildren =  new ArrayList<>();
+
+        List<DicArea> list = new ArrayList<>();
+        if (Constant.AREA_TYPE_1.equals(area.getType())) {
+           //鏌ヨ鎵�鏈夌殑璐ㄦ娂鍚堝悓
+            List<PledgeContract> pledgeContractList = pledgeContractService.listAll(null);
+            //鏌ヨ鎵�鏈夌殑搴撳尯
+            List<Dept> depotList = deptService.listDept(null, ContextUtil.getCompanyId(), null);
+            //鏌ヨ鎵�鏈夌殑閾惰
+            List<Bank> bankList = bankService.listAll(null);
+            DicArea defaultBank = new DicArea();
+            defaultBank.setCode("-1");
+            defaultBank.setName("鏃犺川鎶奸摱琛�");
+            defaultBank.setChildren(new ArrayList<>());
+
+            for (Dept dept : depotList) {
+                Boolean isPledge = false;
+                for (PledgeContract pledgeContract : pledgeContractList) {
+                    if( dept.getId().equals(pledgeContract.getPledgeDept())){
+                        //浠巐ist涓壘鍒板綋鍓嶈川鎶奸摱琛岀殑鏁版嵁
+                        DicArea pledgeBank = null;
+                        int indexBank = -1;
+                        for (DicArea item : areaChildren) {
+                            if (pledgeContract.getPledgeBank().equals(item.getCode())) {
+                                pledgeBank = item;
+                                indexBank = areaChildren.indexOf(pledgeBank);
+                                break;
+                            }
+                        }
+                        if( null == pledgeBank){
+                            //鏈壘鍒拌川鎶奸摱琛屾暟鎹垯鏂板缓
+                            pledgeBank = new DicArea();
+                            pledgeBank.setCode(pledgeContract.getPledgeBank());
+                            pledgeBank.setName("璐ㄦ娂閾惰_"+pledgeContract.getPledgeBank());
+                            //浠庨摱琛屾暟鎹腑鎵惧埌璐ㄦ娂閾惰鐨勪俊鎭�
+                            for (Bank bank : bankList) {
+                                if (pledgeContract.getPledgeBank().equals(bank.getId())) {
+                                    pledgeBank.setName(bank.getName());
+                                }
+                            }
+                            //娣诲姞璐ㄦ娂閾惰涓嬬殑搴撳尯鏁版嵁
+                            DicArea deptDic = new DicArea();
+                            deptDic.setCode(dept.getId());
+                            deptDic.setName(dept.getKqmc());
+
+                            List<DicArea> children = pledgeBank.getChildren();
+                            if (null == children) {
+                                pledgeBank.setChildren(new ArrayList<>());
+                            }
+                            pledgeBank.getChildren().add(deptDic);
+                            //鏂板璐ㄦ娂閾惰鏁版嵁鍒發ist涓�
+                            areaChildren.add(pledgeBank);
+                            isPledge=true;
+                            break;
+                        }else{
+                            //娣诲姞璐ㄦ娂閾惰涓嬬殑搴撳尯鏁版嵁
+                            DicArea deptDic = new DicArea();
+                            deptDic.setCode(dept.getId());
+                            deptDic.setName(dept.getKqmc());
+
+                            List<DicArea> children = pledgeBank.getChildren();
+                            if (null == children) {
+                                pledgeBank.setChildren(new ArrayList<>());
+                            }
+                            pledgeBank.getChildren().add(deptDic);
+                            //鏇存柊list涓殑璐ㄦ娂閾惰鏁版嵁
+                            areaChildren.set(indexBank,pledgeBank);
+                            isPledge=true;
+                            break;
+
+                        }
+
+
+                    }
+                }
+                if(!isPledge){
+                    DicArea deptDic = new DicArea();
+                    deptDic.setCode(dept.getId());
+                    deptDic.setName(dept.getKqmc());
+
+                    List<DicArea> children = defaultBank.getChildren();
+                    if (null == children) {
+                        defaultBank.setChildren(new ArrayList<>());
+                    }
+                    defaultBank.getChildren().add(deptDic);
+                }
+            }
+            List<DicArea> defaultBankChildren = defaultBank.getChildren();
+            if (defaultBankChildren.size()>0) {
+                areaChildren.add(defaultBank);
+            }
+            area.setChildren(areaChildren);
+        }
+        list.add(area);
+        return list;
+    }
+
     /**
-     * 鑾峰彇缁勭粐涓嬫墍鏈夊簱鍖轰俊鎭�
+     * 鑾峰彇鐢ㄦ埛涓嬫墍鏈夊簱鍖轰俊鎭�
+     *
+     * @return
+     */
+    public List<Dept> getDeptList() {
+        return deptService.getDeptByUserType(null);
+    }
+
+    /**
+     * 鑾峰彇搴撳尯灏佽淇℃伅
      *
      * @param companyId
      * @return
      */
-    public List<Dept> getAllDept(String companyId) {
-        return deptService.listDept(null, companyId, null);
+    public List<GroupDeptData> getDeptData(String companyId) {
+
+        List<GroupDeptData> list = new ArrayList<>();
+        GroupDeptData deptData;
+        List<Dept> deptList = deptService.getDeptByUserType(null);
+        if (null != deptList && !deptList.isEmpty()) {
+            List<Depot> depotList;
+            for (Dept dept : deptList) {
+                deptData = new GroupDeptData();
+                deptData.setDeptId(dept.getId());
+                deptData.setDeptName(dept.getKqmc());
+                deptData.setCode(dept.getXzqhdm());
+                deptData.setCounty(dept.getXzqhmc());
+                deptData.setJd(dept.getJd());
+                deptData.setWd(dept.getWd());
+
+                //缁熻浠撳簱鏁�
+                depotList = depotService.getCacheDepotList(dept.getCompanyId(), dept.getId());
+                if (null != depotList && !depotList.isEmpty()) {
+                    for (Depot depot : depotList) {
+                        deptData.setDepotNumber(deptData.getDepotNumber() + 1);
+
+                        if (StringUtils.isNotBlank(depot.getPledgeBank())) {
+                            deptData.setDepotBankNumber(deptData.getDepotBankNumber() + 1);
+                        }
+
+                        if (null == depot.getStorageReal()) {
+                            depot.setStorageReal(0.0);
+                        }
+                        deptData.setStorageNum(deptData.getStorageNum() + depot.getStorageReal() / 1000);
+                    }
+                }
+
+                //缁熻鍑哄叆搴撴暟閲�
+                InoutParam inoutParam = new InoutParam();
+                inoutParam.setDeptId(dept.getId());
+                inoutParam.setCompanyId(companyId);
+                inoutParam.setStart(DateUtil.getCurZero(new Date()));
+                inoutParam.setEnd(DateUtil.getNextZero(new Date()));
+                List<InoutRecord> inoutRecords = inoutRecordService.listInout(inoutParam);
+                if (null != inoutRecords && !inoutRecords.isEmpty()) {
+                    for (InoutRecord inoutRecord : inoutRecords) {
+                        if (Constant.TYPE_IN.equals(inoutRecord.getType())) {
+                            deptData.setInNum(deptData.getInNum() + 1);
+                        }
+                        if (Constant.TYPE_OUT.equals(inoutRecord.getType())) {
+                            deptData.setOutNum(deptData.getOutNum() + 1);
+
+                        }
+                    }
+                }
+
+                list.add(deptData);
+            }
+        }
+
+        return list;
+    }
+
+    /**
+     * 鑾峰彇搴撳尯涓嬬洃鎺т俊鎭�
+     *
+     * @param param
+     * @return
+     */
+    public PageResponse<List<Camera>> cameraList(IgdsBaseParam param) {
+
+        if (StringUtils.isBlank(param.getDeptId())) {
+            return new PageResponse<>(RespCodeEnum.CODE_2000, null);
+        }
+
+        if (StringUtils.isBlank(param.getCompanyId())) {
+            param.setCompanyId(ContextUtil.getCompanyId());
+        }
+
+        List<Camera> listCamera = cameraService.getCameraByDeptId(param.getCompanyId(), param.getDeptId());
+
+        return new PageResponse<>(RespCodeEnum.CODE_0000, listCamera);
+    }
+
+    /**
+     * 澶у睆棣栭〉缁熻淇℃伅锛氫紒涓氭暟銆佸簱鍖烘暟銆佷粨搴撴暟銆佽川鎶间粨鏁般�佹暎绮強鎴愬搧绮暟銆佸垎鍝佺搴撳瓨鏁�
+     *
+     * @param param
+     * @return
+     */
+    public PageResponse<GroupIndexData> getGroupIndexData(IgdsBaseParam param) {
+
+        GroupIndexData indexData = new GroupIndexData();
+
+        //浼佷笟鏁�
+        Integer companyNum = coreCompanyService.getCompanyNum(param.getCompanyId());
+        indexData.setCompanyNum(companyNum);
+
+        //搴撳尯鏁�
+        List<Dept> deptList = deptService.getDeptByUserType(null);
+        if (null != deptList) {
+            indexData.setDeptNum(deptList.size());
+        }
+
+        ///浠撳簱鏁板強璐ㄦ娂浠撳簱鏁�
+        List<Depot> depotList = depotService.getCacheDepotList(param.getCompanyId());
+        if (null != depotList) {
+            Double foodSum = 0.0;
+            Double packFoodSum = 0.0;
+            indexData.setDepotNum(depotList.size());
+
+            //鐢ㄤ簬缁熻鍒嗗搧绉嶅簱瀛�
+            LinkedHashMap<String, Double> varietyMap = new LinkedHashMap<>();
+            for (Depot depot : depotList) {
+                if (StringUtils.isNotBlank(depot.getPledgeBank())) {
+                    indexData.setDepotBankNum(indexData.getDepotBankNum() + 1);
+                }
+                if (null == depot.getStorageReal()) {
+                    depot.setStorageReal(0.0);
+                }
+                if (StringUtils.isNotBlank(depot.getStoreType()) && "2".equals(depot.getStoreType())) {
+                    packFoodSum += depot.getStorageReal() / 1000;
+                } else {
+                    foodSum += depot.getStorageReal() / 1000;
+                }
+
+                if (depot.getStorageReal() > 0) {
+                    if (StringUtils.isBlank(depot.getFoodVariety())) {
+                        //璁剧疆涓哄叾浠栧搧绫�
+                        depot.setFoodVariety("9999000");
+                    }
+
+                    varietyMap.putIfAbsent(depot.getFoodVariety(), 0.000);
+                    varietyMap.put(depot.getFoodVariety(), varietyMap.get(depot.getFoodVariety()) + NumberUtil.keepPrecision(depot.getStorageReal() / 1000, 3));
+                }
+            }
+
+            for (String mapKey : varietyMap.keySet()) {
+                if (varietyMap.get(mapKey) <= 0) {
+                    continue;
+                }
+                indexData.getXaxis().add(FoodVariety.getMsg(mapKey));
+                indexData.getSeriesData().add(new DecimalFormat("0.000").format(varietyMap.get(mapKey)));
+            }
+            indexData.setFoodSum(new DecimalFormat("0.000").format(foodSum));
+            indexData.setPackFoodSum(new DecimalFormat("0.000").format(packFoodSum));
+        }
+
+        return new PageResponse<>(RespCodeEnum.CODE_0000, indexData);
+    }
+
+    /**
+     * 澶у睆棣栭〉-搴撳尯淇℃伅缁熻
+     *
+     * @param param
+     * @return
+     */
+    public PageResponse<List<GroupDeptData>> indexDeptList(IgdsBaseParam param) {
+
+        List<GroupDeptData> list = new ArrayList<>();
+        GroupDeptData deptData;
+        List<Dept> deptList = deptService.getDeptByUserType(null);
+        if (null != deptList && !deptList.isEmpty()) {
+            List<Depot> depotList;
+            for (Dept dept : deptList) {
+                deptData = new GroupDeptData();
+                deptData.setDeptId(dept.getId());
+                deptData.setDeptName(dept.getKqmc());
+                deptData.setCode(dept.getXzqhdm());
+                deptData.setCounty(dept.getXzqhmc());
+                deptData.setJd(dept.getJd());
+                deptData.setWd(dept.getWd());
+
+                //缁熻浠撳簱鏁�
+                depotList = depotService.getCacheDepotList(dept.getCompanyId(), dept.getId());
+                if (null != depotList && !depotList.isEmpty()) {
+                    for (Depot depot : depotList) {
+                        deptData.setDepotNumber(deptData.getDepotNumber() + 1);
+
+                        if (StringUtils.isNotBlank(depot.getPledgeBank())) {
+                            deptData.setDepotBankNumber(deptData.getDepotBankNumber() + 1);
+                        }
+
+                        if (null == depot.getStorageReal()) {
+                            depot.setStorageReal(0.0);
+                        }
+                        deptData.setStorageNum(deptData.getStorageNum() + depot.getStorageReal() / 1000);
+                    }
+                }
+
+                //缁熻鍑哄叆搴撴暟閲�
+                InoutParam inoutParam = new InoutParam();
+                inoutParam.setDeptId(dept.getId());
+                inoutParam.setCompanyId(param.getCompanyId());
+                inoutParam.setStart(DateUtil.getCurZero(new Date()));
+                inoutParam.setEnd(DateUtil.getNextZero(new Date()));
+                List<InoutRecord> inoutRecords = inoutRecordService.listInout(inoutParam);
+                if (null != inoutRecords && !inoutRecords.isEmpty()) {
+                    for (InoutRecord inoutRecord : inoutRecords) {
+                        if (Constant.TYPE_IN.equals(inoutRecord.getType())) {
+                            deptData.setInNum(deptData.getInNum() + 1);
+                        }
+                        if (Constant.TYPE_OUT.equals(inoutRecord.getType())) {
+                            deptData.setOutNum(deptData.getOutNum() + 1);
+
+                        }
+                    }
+                }
+
+                //缁熻AI浜嬩欢鏁伴噺
+                IgdsBaseParam igdsParam = new IgdsBaseParam();
+                igdsParam.setDeptId(dept.getId());
+                igdsParam.setCompanyId(param.getCompanyId());
+                igdsParam.setStart(DateUtil.getNewByDay(new Date(), -6));
+                igdsParam.setEnd(DateUtil.getNextZero(new Date()));
+                List<EventInfo> enevtList = eventInfoService.getListByParam(igdsParam);
+                List<EventInfo> resultEnevtList = new ArrayList<>();
+                for (EventInfo info : enevtList) {
+                    //褰撴爣绛惧寘鍚� 鍗¤溅锛� 鎴栬�呭寘鍚ぇ鍐欑殑鑻辨枃瀛楁瘝锛堜唬琛ㄦ湁杞︾墝锛夋椂锛屾坊鍔犺繘result
+                    if (StringUtils.isNotBlank(info.getTags())) {
+                        if (info.getTags().contains("鍗¤溅") || info.getTags().matches(".*[A-Z].*")) {
+                            resultEnevtList.add(info);
+                        }
+                    }
+                }
+                if (null != resultEnevtList && !resultEnevtList.isEmpty()) {
+                    deptData.setWarnNum7(resultEnevtList.size());
+                    for (EventInfo eventInfo : resultEnevtList) {
+                        if (DateFormatUtils.format(new Date(), "yyyyMMdd").equals(DateFormatUtils.format(eventInfo.getTime(), "yyyyMMdd"))) {
+                            deptData.setDailyTotal(deptData.getDailyTotal() + 1);
+                        }
+                    }
+                }
+
+                list.add(deptData);
+            }
+        }
+
+        return new PageResponse<>(RespCodeEnum.CODE_0000, list);
     }
 
     /**
      * 缁熻gis鏁版嵁锛屽彧缁熻鐧诲綍浜轰笅灞炵殑鏁版嵁缁熻
+     *
      * @return
      */
-    public GisData getGisData() {
+    public GroupGisData getGisData() {
 
-        GisData gisData = new GisData();
+        GroupGisData groupGisData = new GroupGisData();
 
         //鏌ヨ浼婄妬涓嬪睘鍖哄幙
         //鍖哄幙
@@ -135,13 +503,13 @@
                 namePieChart.put(dicArea.getCode(), dicArea.getName());
             }
         }
-        List<Dept> deptList = deptService.getDeptData();
+        List<Dept> deptList = deptService.getDeptByUserType(null);
         if (null != deptList && !deptList.isEmpty()) {
             //搴撳尯鎬绘暟
-            gisData.setDeptNum(deptList.size());
+            groupGisData.setDeptNum(deptList.size());
             for (Dept dept : deptList) {
                 if (StringUtils.isBlank(dept.getXzqhdm()) || null == valuePieChart.get(dept.getXzqhdm())) {
-                    if(null == valuePieChart.get("999999")){
+                    if (null == valuePieChart.get("999999")) {
                         valuePieChart.put("999999", 0);
                         namePieChart.put("999999", "鍏朵粬鍖哄幙");
                     }
@@ -151,33 +519,64 @@
             }
         }
 
-        if(gisData.getDeptNum() > 0){
+        if (groupGisData.getDeptNum() > 0) {
             for (String mapKey : valuePieChart.keySet()) {
-                gisData.getDeptList().add(new ChartPie(valuePieChart.get(mapKey) + "", namePieChart.get(mapKey), new DecimalFormat("0.0").format((double)valuePieChart.get(mapKey) / gisData.getDeptNum() * 100)));
+                groupGisData.getDeptList().add(new ChartPie(valuePieChart.get(mapKey) + "", namePieChart.get(mapKey), new DecimalFormat("0.0").format((double) valuePieChart.get(mapKey) / groupGisData.getDeptNum() * 100)));
             }
         }
 
         //缁熻閲嶉噺
-        List<Depot> depotLisst = depotService.getData(ContextUtil.getCompanyId(), ContextUtil.subDeptId(null), false);
-        if (null != depotLisst && !depotLisst.isEmpty()) {
-            for (Depot depot : depotLisst) {
-                if(null == depot.getStorageReal()){
+        List<Depot> depotList = depotService.getData(ContextUtil.getCompanyId(), ContextUtil.subDeptId(null), false);
+        if (null != depotList && !depotList.isEmpty()) {
+            for (Depot depot : depotList) {
+                if (null == depot.getStorageReal()) {
                     depot.setStorageReal(0.0);
                 }
-                gisData.setSum(gisData.getSum() + depot.getStorageReal());
-                if(StringUtils.isNotBlank(depot.getPledgeBank())){
-                    gisData.setBankSum(gisData.getBankSum() + depot.getStorageReal());
-                }else{
-                    gisData.setNormalSum(gisData.getNormalSum() + depot.getStorageReal());
+                groupGisData.setSum(groupGisData.getSum() + depot.getStorageReal());
+                if (StringUtils.isNotBlank(depot.getPledgeBank())) {
+                    groupGisData.setBankSum(groupGisData.getBankSum() + depot.getStorageReal());
+                } else {
+                    groupGisData.setNormalSum(groupGisData.getNormalSum() + depot.getStorageReal());
                 }
             }
         }
-        if(gisData.getSum() > 0){
-            gisData.setSumPer(new DecimalFormat("0.00").format(gisData.getSum() / gisData.getSum() * 100L));
-            gisData.setBankSumPer(new DecimalFormat("0.00").format(gisData.getBankSum() / gisData.getSum() * 100L));
-            gisData.setNormalSumPer(new DecimalFormat("0.00").format(gisData.getNormalSum() / gisData.getSum() * 100L));
+        if (groupGisData.getSum() > 0) {
+            groupGisData.setSumPer(new DecimalFormat("0.00").format(groupGisData.getSum() / groupGisData.getSum() * 100L));
+            groupGisData.setBankSumPer(new DecimalFormat("0.00").format(groupGisData.getBankSum() / groupGisData.getSum() * 100L));
+            groupGisData.setNormalSumPer(new DecimalFormat("0.00").format(groupGisData.getNormalSum() / groupGisData.getSum() * 100L));
         }
 
-        return gisData;
+        return groupGisData;
+    }
+
+    /**
+     * 澶у睆棣栭〉-鎶撴媿璺熻釜淇℃伅
+     *
+     * @param param
+     * @return
+     */
+    public PageResponse<List<SnapRecord>> indexSnapList(IgdsBaseParam param) {
+
+        param.setStart(DateUtil.getNewByDay(new Date(), -10));
+        param.setEnd(new Date());
+        List<SnapRecord> listSnap = snapRecordService.getListByParam(param);
+
+        List<SnapRecord> resultListSnap = new ArrayList<>();
+        for (SnapRecord info : listSnap) {
+            //褰撴爣绛惧寘鍚� 鍗¤溅锛� 鎴栬�呭寘鍚ぇ鍐欑殑鑻辨枃瀛楁瘝锛堜唬琛ㄦ湁杞︾墝锛夋椂锛屾坊鍔犺繘result
+            if (StringUtils.isNotBlank(info.getTags())) {
+                if (info.getTags().contains("鍗¤溅") || info.getTags().matches(".*[A-Z].*")) {
+                    resultListSnap.add(info);
+                }
+            }
+        }
+        if (null != resultListSnap && !resultListSnap.isEmpty()) {
+            //鍒ゆ柇鏂囦欢鏄惁瀛樺湪
+            for (SnapRecord record : resultListSnap) {
+                record.setImgName(commonManager.isImgExit(record.getImgName(), null));
+            }
+        }
+
+        return new PageResponse<>(RespCodeEnum.CODE_0000, resultListSnap);
     }
 }

--
Gitblit v1.9.3