From ad69b5895a0348dd827a32513293ce4bee920519 Mon Sep 17 00:00:00 2001 From: dongyukun <1208714201@qq.com> Date: 星期四, 02 一月 2025 14:35:23 +0800 Subject: [PATCH] 调度模型下发数据类型字典、数据质量字典 --- iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpTagController.java | 73 +++++++++++++++++++++++++++++++++--- 1 files changed, 67 insertions(+), 6 deletions(-) diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpTagController.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpTagController.java index 07b08cc..0731d9e 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpTagController.java +++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpTagController.java @@ -1,21 +1,36 @@ package com.iailab.module.data.channel.http.controller.admin; +import com.iailab.framework.apilog.core.annotation.ApiAccessLog; import com.iailab.framework.common.pojo.CommonResult; +import com.iailab.framework.common.pojo.PageParam; import com.iailab.framework.common.pojo.PageResult; import com.iailab.framework.common.util.object.BeanUtils; +import com.iailab.framework.common.util.object.ConvertUtils; +import com.iailab.framework.excel.core.util.ExcelUtils; +import com.iailab.module.data.channel.http.collector.HttpCollector; import com.iailab.module.data.channel.http.entity.HttpTagEntity; import com.iailab.module.data.channel.http.service.HttpTagService; import com.iailab.module.data.channel.http.vo.HttpTagPageReqVO; import com.iailab.module.data.channel.http.vo.HttpTagRespVO; +import com.iailab.module.data.channel.tag.vo.TagExportExcelVO; +import com.iailab.module.data.channel.tag.vo.TagImportExcelVO; +import com.iailab.module.data.channel.tag.vo.TagImportRespVO; +import com.iailab.module.data.common.enums.DataQualityEnum; +import com.iailab.module.data.common.enums.IsEnableEnum; +import io.swagger.v3.oas.annotations.Operation; +import io.swagger.v3.oas.annotations.Parameter; +import io.swagger.v3.oas.annotations.Parameters; import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; +import javax.servlet.http.HttpServletResponse; import javax.validation.Valid; -import java.util.Date; -import java.util.List; -import java.util.UUID; - +import java.io.IOException; +import java.util.*; +import static com.iailab.framework.apilog.core.enums.OperateTypeEnum.EXPORT; import static com.iailab.framework.common.pojo.CommonResult.success; @@ -31,11 +46,20 @@ @Resource private HttpTagService tagService; + @Resource + private HttpCollector httpCollector; + @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @GetMapping("page") public CommonResult<PageResult<HttpTagRespVO>> page(@Valid HttpTagPageReqVO reqVO) { PageResult<HttpTagEntity> page = tagService.queryPage(reqVO); - return success(BeanUtils.toBean(page, HttpTagRespVO.class)); + PageResult<HttpTagRespVO> pageResult = BeanUtils.toBean(page, HttpTagRespVO.class); + pageResult.getList().forEach(item -> { + item.setDataValue(httpCollector.getTagValue(item.getApiId(), item.getTagName())); + item.setDataTime(new Date()); + item.setDataQuality(DataQualityEnum.getEumByValue(item.getDataValue()).getDesc()); + }); + return success(pageResult); } @PreAuthorize("@ss.hasPermission('data:channel-http:query')") @@ -54,7 +78,7 @@ @PreAuthorize("@ss.hasPermission('data:channel-http:create')") @PostMapping("/create") - public CommonResult<Boolean> add(@RequestBody HttpTagEntity httpTagEntity){ + public CommonResult<Boolean> create(@RequestBody HttpTagEntity httpTagEntity){ httpTagEntity.setId(UUID.randomUUID().toString()); httpTagEntity.setCreateTime(new Date()); tagService.add(httpTagEntity); @@ -75,4 +99,41 @@ tagService.delete(id); return success(true); } + + @GetMapping("/export") + @Operation(summary = "导出modbus tag列表") + @PreAuthorize("@ss.hasPermission('data:channel-http-tag:export')") + @ApiAccessLog(operateType = EXPORT) + public void exportPointList(@Validated HttpTagPageReqVO reqVO, HttpServletResponse response) throws IOException { + reqVO.setPageSize(PageParam.PAGE_SIZE_NONE); + PageResult<HttpTagEntity> page = tagService.queryPage(reqVO); + List<TagExportExcelVO> list = ConvertUtils.sourceToTarget(page.getList(), TagExportExcelVO.class); + ExcelUtils.write(response, "tag列表.xls", "数据", TagExportExcelVO.class, list, true); + } + + @GetMapping("/get-import-template") + @Operation(summary = "获得tag导入模板") + public void importTemplate(HttpServletResponse response) throws IOException { + // 手动创建导出 demo + List<TagImportExcelVO> list = Collections.singletonList( + TagImportExcelVO.builder().tagName("Tag名称").tagDesc("Tag描述").dataType("String").enabled(IsEnableEnum.ENABLE.getCode()) + .build() + ); + // 输出 + ExcelUtils.write(response, "tag导入模板.xls", "tag列表", TagImportExcelVO.class, list,true); + } + + @PostMapping("/import") + @Operation(summary = "导入tag") + @Parameters({ + @Parameter(name = "file", description = "Excel 文件", required = true), + @Parameter(name = "updateSupport", description = "是否支持更新,默认为 false", example = "true") + }) + @PreAuthorize("@ss.hasPermission('data:channel-http-tag:import')") + public CommonResult<TagImportRespVO> importExcel(@RequestParam("file") MultipartFile file, + @RequestParam(value = "updateSupport", required = false, defaultValue = "false") Boolean updateSupport, + @RequestParam("device") String device) throws Exception { + List<TagImportExcelVO> list = ExcelUtils.read(file, TagImportExcelVO.class); + return success(tagService.importHttpTagList(list, updateSupport, device)); + } } -- Gitblit v1.9.3