From a2299a6d4a6f99e9c11132138f5d3e9ec68f03ea Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期五, 06 六月 2025 19:19:34 +0800
Subject: [PATCH] 开发更新

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwDeviceServiceImpl.java |  415 +++++++++++++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 349 insertions(+), 66 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwDeviceServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwDeviceServiceImpl.java
index 0684415..69ddf41 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwDeviceServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwDeviceServiceImpl.java
@@ -1,21 +1,40 @@
 package com.doumee.service.business.impl;
 
+import com.doumee.biz.system.SystemDictDataBiz;
+import com.doumee.core.constants.ResponseStatus;
+import com.doumee.core.exception.BusinessException;
 import com.doumee.core.model.LoginUserInfo;
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
+import com.doumee.core.utils.Constants;
+import com.doumee.core.utils.DateUtil;
 import com.doumee.core.utils.Utils;
 import com.doumee.dao.business.YwDeviceMapper;
-import com.doumee.dao.business.model.YwDevice;
+import com.doumee.dao.business.YwDeviceRecordMapper;
+import com.doumee.dao.business.model.*;
+import com.doumee.dao.business.vo.YwDeviceCateDataVO;
+import com.doumee.dao.business.vo.YwDeviceDataVO;
+import com.doumee.dao.business.vo.YwDeviceParentCateDataVO;
+import com.doumee.dao.business.vo.YwDeviceStatusDataVO;
+import com.doumee.dao.system.MultifileMapper;
+import com.doumee.dao.system.model.Multifile;
+import com.doumee.dao.system.model.SystemUser;
+import com.doumee.service.business.YwDeviceRecordService;
 import com.doumee.service.business.YwDeviceService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import lombok.extern.java.Log;
+import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.data.redis.core.RedisTemplate;
 import org.springframework.stereotype.Service;
 import org.springframework.util.CollectionUtils;
 
-import java.util.List;
+import java.util.*;
+import java.util.stream.Collectors;
 
 /**
  * 杩愮淮璁惧淇℃伅琛⊿ervice瀹炵幇
@@ -28,15 +47,87 @@
     @Autowired
     private YwDeviceMapper ywDeviceMapper;
 
+    @Autowired
+    private SystemDictDataBiz systemDictDataBiz;
+    @Autowired
+    private MultifileMapper multifileMapper;
+    @Autowired
+    private YwDeviceRecordMapper ywDeviceRecordMapper;
+
+    @Autowired
+    private RedisTemplate<String,Object> redisTemplate;
+
+
     @Override
     public Integer create(YwDevice ywDevice) {
+        if(Objects.isNull(ywDevice)
+            || StringUtils.isBlank(ywDevice.getName())
+            || StringUtils.isBlank(ywDevice.getCode())
+            || Objects.isNull(ywDevice.getStatus())
+            || Objects.isNull(ywDevice.getProjectId())
+            || Objects.isNull(ywDevice.getFloorId())
+            || Objects.isNull(ywDevice.getBuildingId())
+            || Objects.isNull(ywDevice.getRoomId())
+        ){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        LoginUserInfo loginUserInfo = ywDevice.getLoginUserInfo();
+        if(ywDeviceMapper.selectCount(new QueryWrapper<YwDevice>().lambda().eq(YwDevice::getIsdeleted,Constants.ZERO).eq(YwDevice::getCode,ywDevice.getCode()))>Constants.ZERO){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璁惧缂栧彿閲嶅!");
+        }
+        ywDevice.setCreateDate(new Date());
+        ywDevice.setCreator(loginUserInfo.getId());
+        ywDevice.setIsdeleted(Constants.ZERO);
         ywDeviceMapper.insert(ywDevice);
+
+        if(Objects.nonNull(ywDevice.getFileUrl())){
+            Multifile multifile = new Multifile();
+            multifile.setCreator(loginUserInfo.getId());
+            multifile.setCreateDate(new Date());
+            multifile.setIsdeleted(Constants.ZERO);
+            multifile.setObjType(Constants.MultiFile.FN_DEVICE_FILE.getKey());
+            multifile.setObjId(ywDevice.getId());
+            multifile.setFileurl(ywDevice.getFileUrl());
+            multifileMapper.insert(multifile);
+        }
+
+        List<Multifile> fileList = new ArrayList<>();
+        if(ywDevice.getMultifileList()!=null && ywDevice.getMultifileList().size()>0){
+            for (int i = 0; i <  ywDevice.getMultifileList().size(); i++) {
+                Multifile multifile =  ywDevice.getMultifileList().get(i);
+                if(StringUtils.isBlank(multifile.getFileurl())){
+                    continue;
+                }
+                multifile.setCreateDate(ywDevice.getCreateDate());
+                multifile.setEditDate(ywDevice.getCreateDate());
+                multifile.setCreator(ywDevice.getCreator());
+                multifile.setIsdeleted(Constants.ZERO);
+                multifile.setObjId(ywDevice.getId());
+                multifile.setEditor(ywDevice.getCreator());
+                multifile.setObjType(Constants.MultiFile.FN_DEVICE_MAINTENANCE_FILE.getKey());
+                multifile.setSortnum(i+1);
+                fileList.add(multifile);
+            }
+        }
+        if(fileList.size()>0){
+            multifileMapper.insert(fileList);
+        }
+
         return ywDevice.getId();
     }
 
     @Override
     public void deleteById(Integer id, LoginUserInfo user) {
-        ywDeviceMapper.deleteById(id);
+        //鏌ヨ璁惧鏄惁瀛樺湪杩愮淮璁板綍
+        if(ywDeviceRecordMapper.selectCount(new QueryWrapper<YwDeviceRecord>().lambda().eq(YwDeviceRecord::getDeviceId,id).eq(YwDeviceRecord::getIsdeleted,Constants.ZERO))>Constants.ZERO){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"褰撳墠璁惧瀛樺湪杩愮淮璁板綍锛屾棤娉曞垹闄�");
+        };
+        ywDeviceMapper.update(new UpdateWrapper<YwDevice>()
+                .lambda().set(YwDevice::getIsdeleted,Constants.ONE)
+                .set(YwDevice::getEditDate, DateUtil.getCurrDateTime())
+                .set(YwDevice::getEditor,user.getId())
+                .eq(YwDevice::getId,id)
+        );
     }
 
     @Override
@@ -55,7 +146,64 @@
 
     @Override
     public void updateById(YwDevice ywDevice) {
+        if(Objects.isNull(ywDevice)
+                || StringUtils.isBlank(ywDevice.getName())
+                || StringUtils.isBlank(ywDevice.getCode())
+                || Objects.isNull(ywDevice.getStatus())
+                || Objects.isNull(ywDevice.getProjectId())
+                || Objects.isNull(ywDevice.getFloorId())
+                || Objects.isNull(ywDevice.getBuildingId())
+                || Objects.isNull(ywDevice.getRoomId())
+        ){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
+        LoginUserInfo loginUserInfo = ywDevice.getLoginUserInfo();
+        if(ywDeviceMapper.selectCount(new QueryWrapper<YwDevice>().lambda().eq(YwDevice::getIsdeleted,Constants.ZERO)
+                .eq(YwDevice::getCode,ywDevice.getCode())
+                .ne(YwDevice::getId,ywDevice.getId()))>Constants.ZERO){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璁惧缂栧彿閲嶅!");
+        }
+        ywDevice.setEditDate(new Date());
+        ywDevice.setEditor(loginUserInfo.getId());
         ywDeviceMapper.updateById(ywDevice);
+        multifileMapper.delete(new QueryWrapper<Multifile>().lambda()
+                .eq(Multifile::getObjId,ywDevice.getId())
+                .in(Multifile::getObjType,Constants.MultiFile.FN_DEVICE_FILE.getKey(),Constants.MultiFile.FN_DEVICE_MAINTENANCE_FILE.getKey())
+        );
+        if(Objects.nonNull(ywDevice.getFileUrl())){
+            Multifile multifile = new Multifile();
+            multifile.setCreator(loginUserInfo.getId());
+            multifile.setCreateDate(new Date());
+            multifile.setIsdeleted(Constants.ZERO);
+            multifile.setObjType(Constants.MultiFile.FN_DEVICE_FILE.getKey());
+            multifile.setObjId(ywDevice.getId());
+            multifile.setFileurl(ywDevice.getFileUrl());
+            multifileMapper.insert(multifile);
+        }
+
+        List<Multifile> fileList = new ArrayList<>();
+        if(ywDevice.getMultifileList()!=null && ywDevice.getMultifileList().size()>0){
+            for (int i = 0; i <  ywDevice.getMultifileList().size(); i++) {
+                Multifile multifile =  ywDevice.getMultifileList().get(i);
+                if(StringUtils.isBlank(multifile.getFileurl())){
+                    continue;
+                }
+                multifile.setCreateDate(ywDevice.getCreateDate());
+                multifile.setEditDate(ywDevice.getCreateDate());
+                multifile.setCreator(ywDevice.getEditor());
+                multifile.setIsdeleted(Constants.ZERO);
+                multifile.setObjId(ywDevice.getId());
+                multifile.setEditor(ywDevice.getCreator());
+                multifile.setObjType(Constants.MultiFile.FN_DEVICE_MAINTENANCE_FILE.getKey());
+                multifile.setSortnum(i+1);
+                fileList.add(multifile);
+            }
+        }
+        if(fileList.size()>0){
+            multifileMapper.insert(fileList);
+        }
+
+
     }
 
     @Override
@@ -74,6 +222,85 @@
     }
 
     @Override
+    public YwDevice getDetail(Integer id) {
+        YwDevice ywDevice = ywDeviceMapper.selectJoinOne(YwDevice.class,
+                new MPJLambdaWrapper<YwDevice>()
+                .selectAll(YwDevice.class)
+                        .select("c.name",YwDevice::getCategoryName)
+                        .select("c1.name",YwDevice::getCategoryParentName)
+                        .select("s.realname",YwDevice::getRealName)
+                        .select("s1.realname",YwDevice::getMaintenanceUserName)
+                        .selectAs(YwProject::getName,YwDevice::getProjectName)
+                        .selectAs(YwFloor::getName,YwDevice::getFloorName)
+                        .selectAs(YwBuilding::getName,YwDevice::getBuildingName)
+                        .selectAs(YwRoom::getCode,YwDevice::getRoomName)
+                        .leftJoin(YwRoom.class,YwRoom::getId,YwDevice::getRoomId)
+                        .leftJoin(YwFloor.class,YwFloor::getId,YwRoom::getFloor)
+                        .leftJoin(YwProject.class,YwProject::getId,YwRoom::getProjectId)
+                        .leftJoin(YwBuilding.class,YwBuilding::getId,YwRoom::getBuildingId)
+                        .leftJoin("category c on t.CATE_ID = c.id")
+                        .leftJoin("category c1 on c.PARENT_ID = c1.id")
+                        .leftJoin("system_user s on t.user_id = s.id")
+                        .leftJoin("system_user s1 on t.MAINTENANCE_USER_ID = s1.id")
+                        .eq(YwDevice::getId,id)
+                        .last(" limit 1 ")
+        );
+        Multifile multifile = multifileMapper.selectOne(new QueryWrapper<Multifile>().lambda()
+                .eq(Multifile::getObjId,id).eq(Multifile::getObjType,Constants.MultiFile.FN_DEVICE_FILE.getKey()).last(" limit 1"));
+        if(Objects.nonNull(multifile)){
+            String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode()
+                    +systemDictDataBiz.queryByCode(Constants.FTP,Constants.YW_DEVICE).getCode();
+            ywDevice.setFileFullUrl(path + multifile.getFileurl());
+        }
+
+        //闄勪欢鏁版嵁
+        List<Multifile> multifileList = multifileMapper.selectJoinList(Multifile.class,new MPJLambdaWrapper<Multifile>()
+                .selectAll(Multifile.class)
+                .selectAs(SystemUser::getRealname,Multifile::getUserName)
+                .leftJoin(SystemUser.class,SystemUser::getId,Multifile::getCreator)
+                .eq(Multifile::getObjId,ywDevice.getId())
+                .eq(Multifile::getIsdeleted,Constants.ZERO)
+                .eq(Multifile::getObjType,Constants.MultiFile.FN_DEVICE_MAINTENANCE_FILE.getKey()));
+        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){
+            String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode()
+                    +systemDictDataBiz.queryByCode(Constants.FTP,Constants.YW_PATROL).getCode();
+            for (Multifile m:multifileList) {
+                if(StringUtils.isNotBlank(m.getFileurl())){
+                    m.setFileurlFull(path + m.getFileurl());
+                }
+            }
+            ywDevice.setMultifileList(multifileList);
+        }
+
+        return ywDevice;
+    }
+
+
+    /**
+     * 鏍规嵁缂栫爜鏌ヨ
+     * @param deviceCode
+     * @return
+     */
+    @Override
+    public YwDevice findByCode(String deviceCode) {
+        YwDevice ywDevice =  ywDeviceMapper.selectOne(
+                new QueryWrapper<YwDevice>()
+                        .lambda()
+                        .eq(YwDevice::getIsdeleted,Constants.ZERO)
+                        .eq(YwDevice::getCode,deviceCode)
+                        .last(" limit  1 ")
+        );
+        if(Objects.isNull(ywDevice)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+
+        return ywDevice;
+    }
+
+
+
+
+    @Override
     public YwDevice findOne(YwDevice ywDevice) {
         QueryWrapper<YwDevice> wrapper = new QueryWrapper<>(ywDevice);
         return ywDeviceMapper.selectOne(wrapper);
@@ -88,70 +315,29 @@
     @Override
     public PageData<YwDevice> findPage(PageWrap<YwDevice> pageWrap) {
         IPage<YwDevice> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
-        QueryWrapper<YwDevice> queryWrapper = new QueryWrapper<>();
+        MPJLambdaWrapper<YwDevice> queryWrapper = new MPJLambdaWrapper<YwDevice>();
         Utils.MP.blankToNull(pageWrap.getModel());
-        if (pageWrap.getModel().getId() != null) {
-            queryWrapper.lambda().eq(YwDevice::getId, pageWrap.getModel().getId());
-        }
-        if (pageWrap.getModel().getCreator() != null) {
-            queryWrapper.lambda().eq(YwDevice::getCreator, pageWrap.getModel().getCreator());
-        }
-        if (pageWrap.getModel().getCreateDate() != null) {
-            queryWrapper.lambda().ge(YwDevice::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
-            queryWrapper.lambda().le(YwDevice::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
-        }
-        if (pageWrap.getModel().getEditor() != null) {
-            queryWrapper.lambda().eq(YwDevice::getEditor, pageWrap.getModel().getEditor());
-        }
-        if (pageWrap.getModel().getEditDate() != null) {
-            queryWrapper.lambda().ge(YwDevice::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
-            queryWrapper.lambda().le(YwDevice::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
-        }
-        if (pageWrap.getModel().getIsdeleted() != null) {
-            queryWrapper.lambda().eq(YwDevice::getIsdeleted, pageWrap.getModel().getIsdeleted());
-        }
-        if (pageWrap.getModel().getName() != null) {
-            queryWrapper.lambda().eq(YwDevice::getName, pageWrap.getModel().getName());
-        }
-        if (pageWrap.getModel().getRemark() != null) {
-            queryWrapper.lambda().eq(YwDevice::getRemark, pageWrap.getModel().getRemark());
-        }
-        if (pageWrap.getModel().getStatus() != null) {
-            queryWrapper.lambda().eq(YwDevice::getStatus, pageWrap.getModel().getStatus());
-        }
-        if (pageWrap.getModel().getSortnum() != null) {
-            queryWrapper.lambda().eq(YwDevice::getSortnum, pageWrap.getModel().getSortnum());
-        }
-        if (pageWrap.getModel().getModelNo() != null) {
-            queryWrapper.lambda().eq(YwDevice::getModelNo, pageWrap.getModel().getModelNo());
-        }
-        if (pageWrap.getModel().getCateId() != null) {
-            queryWrapper.lambda().eq(YwDevice::getCateId, pageWrap.getModel().getCateId());
-        }
-        if (pageWrap.getModel().getUserId() != null) {
-            queryWrapper.lambda().eq(YwDevice::getUserId, pageWrap.getModel().getUserId());
-        }
-        if (pageWrap.getModel().getCompany() != null) {
-            queryWrapper.lambda().ge(YwDevice::getCompany, Utils.Date.getStart(pageWrap.getModel().getCompany()));
-            queryWrapper.lambda().le(YwDevice::getCompany, Utils.Date.getEnd(pageWrap.getModel().getCompany()));
-        }
-        if (pageWrap.getModel().getContent() != null) {
-            queryWrapper.lambda().eq(YwDevice::getContent, pageWrap.getModel().getContent());
-        }
-        if (pageWrap.getModel().getCode() != null) {
-            queryWrapper.lambda().eq(YwDevice::getCode, pageWrap.getModel().getCode());
-        }
-        if (pageWrap.getModel().getAddr() != null) {
-            queryWrapper.lambda().eq(YwDevice::getAddr, pageWrap.getModel().getAddr());
-        }
-        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
-            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
-                queryWrapper.orderByDesc(sortData.getProperty());
-            } else {
-                queryWrapper.orderByAsc(sortData.getProperty());
-            }
-        }
-        return PageData.from(ywDeviceMapper.selectPage(page, queryWrapper));
+        YwDevice model = pageWrap.getModel();
+        queryWrapper.selectAll(YwDevice.class)
+                .select("c.name",YwDevice::getCategoryName)
+                .select("c1.name",YwDevice::getCategoryParentName)
+                .select("s.realname",YwDevice::getRealName)
+                .select("s1.realname",YwDevice::getMaintenanceUserName)
+                .leftJoin("category c on t.CATE_ID = c.id")
+                .leftJoin("category c1 on c.PARENT_ID = c1.id")
+                .leftJoin("system_user s on t.user_id = s.id")
+                .leftJoin("system_user s1 on t.MAINTENANCE_USER_ID = s1.id")
+                .and(Objects.nonNull(model)&&StringUtils.isNotBlank(model.getName()),i->i.like(YwDevice::getName,model.getName()).or().like(YwDevice::getCode,model.getName()))
+                .eq(Objects.nonNull(model.getStatus()),YwDevice::getStatus,model.getStatus())
+                .eq(Objects.nonNull(model.getRoomId()),YwDevice::getRoomId,model.getRoomId())
+                .eq(Objects.nonNull(model.getFloorId()),YwDevice::getFloorId,model.getFloorId())
+                .eq(Objects.nonNull(model.getProjectId()),YwDevice::getProjectId,model.getProjectId())
+                .eq(Objects.nonNull(model.getBuildingId()),YwDevice::getBuildingId,model.getBuildingId())
+                .eq(YwDevice::getIsdeleted,Constants.ZERO)
+                .orderByDesc(YwDevice::getCreateDate)
+        ;
+        IPage iPage = ywDeviceMapper.selectJoinPage(page,YwDevice.class,queryWrapper);
+        return PageData.from(iPage);
     }
 
     @Override
@@ -159,4 +345,101 @@
         QueryWrapper<YwDevice> wrapper = new QueryWrapper<>(ywDevice);
         return ywDeviceMapper.selectCount(wrapper);
     }
+
+
+
+    @Override
+    public YwDeviceDataVO getYwDeviceData(){
+        YwDeviceDataVO ywDeviceDataVO = new YwDeviceDataVO();
+        List<YwDevice> ywDeviceList = ywDeviceMapper.selectList(new QueryWrapper<YwDevice>().lambda().eq(YwDevice::getIsdeleted,Constants.ZERO));
+        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(ywDeviceList)){
+            ywDeviceDataVO.setQualityNum(ywDeviceList.size());
+            ywDeviceDataVO.setTotalNum(ywDeviceList.size());
+            ywDeviceDataVO.setNormalNum(ywDeviceList.stream().filter(i->Constants.equalsInteger(i.getStatus(),Constants.ZERO)).collect(Collectors.toList()).size());
+            ywDeviceDataVO.setAbnormalNum(ywDeviceList.stream().filter(i->Constants.equalsInteger(i.getStatus(),Constants.ONE)).collect(Collectors.toList()).size());
+            ywDeviceDataVO.setScrapNum(ywDeviceList.stream().filter(i->Constants.equalsInteger(i.getStatus(),Constants.TWO)).collect(Collectors.toList()).size());
+        }
+        return ywDeviceDataVO;
+    }
+
+    @Override
+    public Set<YwDeviceParentCateDataVO> getDeviceCateData(YwDevice model){
+        MPJLambdaWrapper<YwDevice> queryWrapper = new MPJLambdaWrapper<YwDevice>();
+        queryWrapper.selectAll(YwDevice.class)
+                .select("c.name",YwDevice::getCategoryName)
+                .select("c1.name",YwDevice::getCategoryParentName)
+                .select("c1.id",YwDevice::getCateParentId)
+                .selectAs(SystemUser::getRealname,YwDevice::getRealName)
+                .leftJoin(SystemUser.class,SystemUser::getId,YwDevice::getUserId)
+                .leftJoin("category c on t.CATE_ID = c.id")
+                .leftJoin("category c1 on c.PARENT_ID = c1.id")
+                .eq(Objects.nonNull(model.getRoomId()),YwDevice::getRoomId,model.getRoomId())
+                .eq(Objects.nonNull(model.getFloorId()),YwDevice::getFloorId,model.getFloorId())
+                .eq(Objects.nonNull(model.getProjectId()),YwDevice::getProjectId,model.getProjectId())
+                .eq(Objects.nonNull(model.getBuildingId()),YwDevice::getBuildingId,model.getBuildingId())
+                .eq(YwDevice::getIsdeleted,Constants.ZERO)
+                .isNotNull(YwDevice::getCateId)
+                .orderByDesc(YwDevice::getCreateDate)
+        ;
+        List<YwDevice> ywDeviceList = ywDeviceMapper.selectJoinList(YwDevice.class,queryWrapper);
+        Set<YwDeviceCateDataVO> ywDeviceCateDataVOSet = new HashSet<>();
+        Set<YwDeviceParentCateDataVO> ywDeviceParentCateDataVOSet = new HashSet<>();
+        for (YwDevice y: ywDeviceList) {
+            YwDeviceCateDataVO ywDeviceCateDataVO = new YwDeviceCateDataVO();
+            ywDeviceCateDataVO.setCateId(y.getCateId());
+            ywDeviceCateDataVO.setCateName(y.getCategoryName());
+            ywDeviceCateDataVO.setCateParentId(y.getCateParentId());
+            ywDeviceCateDataVOSet.add(ywDeviceCateDataVO);
+
+            YwDeviceParentCateDataVO ywDeviceParentCateDataVO = new YwDeviceParentCateDataVO();
+            ywDeviceParentCateDataVO.setCateId(y.getCateParentId());
+            ywDeviceParentCateDataVO.setCateName(y.getCategoryParentName());
+            ywDeviceParentCateDataVOSet.add(ywDeviceParentCateDataVO);
+        }
+
+        for (YwDeviceCateDataVO ywDeviceCateDataVO:ywDeviceCateDataVOSet) {
+            ywDeviceCateDataVO.setDeviceAmount(
+                    ywDeviceList.stream().filter(i->Objects.nonNull(i.getCateId()) && Constants.equalsInteger(i.getCateId(),ywDeviceCateDataVO.getCateId())).collect(Collectors.toList()).size()
+            );
+        }
+
+        for (YwDeviceParentCateDataVO ywDeviceParentCateDataVO:ywDeviceParentCateDataVOSet) {
+            ywDeviceParentCateDataVO.setDeviceAmount(
+                    ywDeviceList.stream().filter(i->Objects.nonNull(i.getCateParentId()) && Constants.equalsInteger(i.getCateParentId(),ywDeviceParentCateDataVO.getCateId())).collect(Collectors.toList()).size()
+            );
+            ywDeviceParentCateDataVO.setYwDeviceCateDataVOList(
+                    ywDeviceCateDataVOSet.stream().filter(i->Constants.equalsInteger(i.getCateParentId(),ywDeviceParentCateDataVO.getCateId())).collect(Collectors.toList())
+            );
+        }
+        return ywDeviceParentCateDataVOSet;
+    }
+
+
+    @Override
+    public YwDeviceStatusDataVO getDeviceStatus(YwDevice model){
+        YwDeviceStatusDataVO ywDeviceStatusDataVO = new YwDeviceStatusDataVO();
+        MPJLambdaWrapper<YwDevice> queryWrapper = new MPJLambdaWrapper<YwDevice>();
+        queryWrapper.selectAll(YwDevice.class)
+                .eq(Objects.nonNull(model.getRoomId()),YwDevice::getRoomId,model.getRoomId())
+                .eq(Objects.nonNull(model.getFloorId()),YwDevice::getFloorId,model.getFloorId())
+                .eq(Objects.nonNull(model.getProjectId()),YwDevice::getProjectId,model.getProjectId())
+                .eq(Objects.nonNull(model.getBuildingId()),YwDevice::getBuildingId,model.getBuildingId())
+                .eq(YwDevice::getIsdeleted,Constants.ZERO)
+        ;
+        List<YwDevice> ywDeviceList = ywDeviceMapper.selectJoinList(YwDevice.class,queryWrapper);
+        ywDeviceStatusDataVO.setAmount(ywDeviceList.size());
+        ywDeviceStatusDataVO.setWorkAmount(ywDeviceList.stream().filter(i->Objects.nonNull(i.getStatus())&&Constants.equalsInteger(i.getStatus(),Constants.ZERO)).collect(Collectors.toList()).size());
+        ywDeviceStatusDataVO.setExceptionAmount(ywDeviceList.stream().filter(i->Objects.nonNull(i.getStatus())&&Constants.equalsInteger(i.getStatus(),Constants.ONE)).collect(Collectors.toList()).size());
+        ywDeviceStatusDataVO.setErrAmount(ywDeviceList.stream().filter(i->Objects.nonNull(i.getStatus())&&Constants.equalsInteger(i.getStatus(),Constants.TWO)).collect(Collectors.toList()).size());
+        return ywDeviceStatusDataVO;
+
+    }
+
+
+
+
+
 }
+
+
+

--
Gitblit v1.9.3