From f8751d6e701e0c3e7d8959449b67db6c35d09ec8 Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期日, 08 十二月 2024 19:24:07 +0800 Subject: [PATCH] 新增故障类型 --- ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java | 74 ++++++++++++++++++++++++++++++------ 1 files changed, 61 insertions(+), 13 deletions(-) diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java index 646081a..77e4435 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/YwPointServiceImpl.java @@ -3,6 +3,7 @@ import com.alibaba.excel.EasyExcel; import com.alibaba.excel.ExcelWriter; import com.alibaba.excel.write.metadata.WriteSheet; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper; import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper; @@ -34,6 +35,7 @@ import com.ycl.utils.SecurityUtils; import com.ycl.utils.poi.EasyExcelImportUtils; import com.ycl.utils.uuid.IdUtils; +import constant.CheckConstants; import constant.PointHeaderConstant; import jakarta.servlet.http.HttpServletResponse; import lombok.RequiredArgsConstructor; @@ -135,9 +137,14 @@ YwPoint entity = baseMapper.selectById(form.getId()); Assert.notNull(entity, "璁板綍涓嶅瓨鍦�"); BeanUtils.copyProperties(form, entity); + if (form.getUnitId() != null) { + entity.setUnitId(Long.valueOf(form.getUnitId())); + }else { + entity.setUnitId(null); + } Date now = new Date(); entity.setUpdateTime(now); - baseMapper.updateById(entity); + baseMapper.myUpdateById(entity); return Result.ok("淇敼鎴愬姛"); } @@ -260,7 +267,11 @@ headers.add(PointHeaderConstant.Point_Name); headers.add(PointHeaderConstant.Serial_Number); headers.add(PointHeaderConstant.IP); - headers.add(PointHeaderConstant.Province_Tag); + headers.add(PointHeaderConstant.Area); + headers.add(PointHeaderConstant.Unit); + headers.add(PointHeaderConstant.Province_Tag_Video); + headers.add(PointHeaderConstant.Province_Tag_Car); + headers.add(PointHeaderConstant.Province_Tag_Face); headers.add(PointHeaderConstant.Impotrant_Command_Image); headers.add(PointHeaderConstant.Dept_Tag); List<String> headersList = new LinkedList<>(); @@ -278,7 +289,11 @@ list.add(export.getPointName()); list.add(export.getSerialNumber()); list.add(export.getPointIP()); - list.add(export.getProvinceTagString()); + list.add(export.getArea()); + list.add(export.getUnitName()); + list.add(export.getProvinceTagVideoString()); + list.add(export.getProvinceTagCarString()); + list.add(export.getProvinceTagFaceString()); list.add(export.getImportantCommandImageTagString()); list.add(export.getDeptTagString()); for (String header : headersList) { @@ -333,7 +348,9 @@ pointExport.setPointName(map.get(PointHeaderConstant.Point_Name)); pointExport.setPointIP(map.get(PointHeaderConstant.IP)); pointExport.setSerialNumber(map.get(PointHeaderConstant.Serial_Number)); - pointExport.setProvinceTag("鏄�".equals(map.get(PointHeaderConstant.Province_Tag))); + pointExport.setProvinceTagVideo("鏄�".equals(map.get(PointHeaderConstant.Province_Tag_Video))); + pointExport.setProvinceTagCar("鏄�".equals(map.get(PointHeaderConstant.Province_Tag_Car))); + pointExport.setProvinceTagFace("鏄�".equals(map.get(PointHeaderConstant.Province_Tag_Face))); pointExport.setImportantCommandImageTag("鏄�".equals(map.get(PointHeaderConstant.Impotrant_Command_Image))); pointExport.setDeptTag("鏄�".equals(map.get(PointHeaderConstant.Dept_Tag))); List<DynamicColumnVO> dynamics = new ArrayList<>(); @@ -378,11 +395,15 @@ List<YwPoint> pointList = dataList.stream().map(item -> { YwPoint point = new YwPoint(); point.setImportantCommandImageTag(item.getImportantCommandImageTag()); - point.setProvinceTag(item.getProvinceTag()); + point.setProvinceTagVideo(item.getProvinceTagVideo()); + point.setProvinceTagCar(item.getProvinceTagCar()); + point.setProvinceTagFace(item.getProvinceTagFace()); point.setDeptTag(item.getDeptTag()); if (needUpdateUnit) { if (Objects.nonNull(unitId)) { point.setUnitId(Long.valueOf(unitId)); + } else { + point.setUnitId(null); } point.setStartTime(startTime); point.setEndTime(endTime); @@ -396,7 +417,7 @@ point.setSerialNumber(item.getSerialNumber()); return point; }).collect(Collectors.toList()); - this.waitAllFinishAndGetResult(pointList); + this.waitAllFinishAndGetResult(pointList, needUpdateUnit); } @Override @@ -441,7 +462,7 @@ //鏁版嵁搴撻噷鏌ヤ笉鍒癳xcel閲岄潰鐨勮繖涓偣浣嶅姩鎬佸垪锛屽叏涓烘柊澧� List<DynamicColumnVO> dynamicData = pointExport.getDynamicData(); for (DynamicColumnVO excelData : dynamicData) { - if(excelData.getColumnValue()!=null) { + if (excelData.getColumnValue() != null) { Integer dynamicId = dictionary.get(excelData.getLabelValue()); DynamicColumnValue entity = new DynamicColumnValue(); entity.setColumnValue(excelData.getColumnValue()); @@ -452,23 +473,36 @@ } } } + //mybaits鏂规硶 //鎻掑叆 - if(!CollectionUtils.isEmpty(insertList)) dynamicColumnMapper.saveBatch(insertList); + if (!CollectionUtils.isEmpty(insertList)) dynamicColumnMapper.saveBatch(insertList); //鏇存柊 - if(!CollectionUtils.isEmpty(updateList)) dynamicColumnMapper.updateBatch(updateList); + if (!CollectionUtils.isEmpty(updateList)) dynamicColumnMapper.updateBatch(updateList); //鍒犻櫎 - if(!CollectionUtils.isEmpty(deleteList)) dynamicColumnMapper.deleteBatchIds(deleteList); + if (!CollectionUtils.isEmpty(deleteList)) dynamicColumnMapper.deleteBatch(deleteList); } - public void waitAllFinishAndGetResult(List<YwPoint> dataList) { + /** + * 鏍规嵁璁惧缂栫爜鏌ヨ鐐逛綅淇℃伅 + * + * @param serialNumber 搴忓垪鍙� + * @return {@link YwPoint } + * @author + */ + @Override + public YwPoint selectBySerialNumber(String serialNumber) { + return baseMapper.selectOne(new LambdaQueryWrapper<>(YwPoint.class).eq(YwPoint::getSerialNumber, serialNumber).eq(YwPoint::getDeleted, "0")); + } + + public void waitAllFinishAndGetResult(List<YwPoint> dataList, Boolean needUpdateUnit) { Date startTime = new Date(); - this.baseMapper.updatePoint(dataList); + this.baseMapper.updatePoint(dataList, needUpdateUnit); Date endTime = new Date(); log.error("鎬诲叡鑰楁椂锛�" + (endTime.getTime() - startTime.getTime())); } @Override - public <T extends BaseResult> void setDeviceTagByGB(List<T> dataList) { + public <T extends BaseResult> void setDeviceTagByGB(List<T> dataList,Short category) { List<String> gbList = dataList.stream().map(BaseResult::getNo).collect(Collectors.toList()); List<CheckTagVO> pointList = baseMapper.getTagsByGB(gbList); Map<String, CheckTagVO> pointMap = pointList.stream().collect(Collectors.toMap(CheckTagVO::getNo, item -> item)); @@ -476,6 +510,20 @@ CheckTagVO tag = pointMap.get(data.getNo()); if (Objects.nonNull(tag)) { BeanUtils.copyProperties(tag, data); + //閫氳繃璁惧绫诲瀷鎵撶渷鍘呮爣绛� + if(CheckConstants.Rule_Category_Video.equals(category)){ + data.setProvinceTag(tag.getProvinceTagVideo()); + }else if(CheckConstants.Rule_Category_Car.equals(category)){ + data.setProvinceTag(tag.getProvinceTagCar()); + }else if(CheckConstants.Rule_Category_Face.equals(category)){ + data.setProvinceTag(tag.getProvinceTagFace()); + }else if(CheckConstants.Rule_Category_Or.equals(category)){ + if(tag.getProvinceTagVideo() || tag.getProvinceTagCar() || tag.getProvinceTagFace()) { + data.setProvinceTag(Boolean.TRUE); + }else { + data.setProvinceTag(Boolean.FALSE); + } + } } } } -- Gitblit v1.8.0