From 98d886ce316c0dd0623c76b3e157b186ebfeb7a5 Mon Sep 17 00:00:00 2001
From: kongdeqiang <kongdeqiang@960204@163.com>
Date: 星期一, 01 十二月 2025 22:17:16 +0800
Subject: [PATCH] fix：sql提交
---
src/main/java/com/wgcloud/controller/dp/DpController.java | 113 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 113 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/wgcloud/controller/dp/DpController.java b/src/main/java/com/wgcloud/controller/dp/DpController.java
new file mode 100644
index 0000000..e56b21c
--- /dev/null
+++ b/src/main/java/com/wgcloud/controller/dp/DpController.java
@@ -0,0 +1,113 @@
+package com.wgcloud.controller.dp;
+
+import com.wgcloud.entity.OspfInfo;
+import com.wgcloud.entity.SnmpInfo;
+import com.wgcloud.service.OspfInfoService;
+import com.wgcloud.service.SnmpInfoService;
+import com.wgcloud.util.R;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import java.math.BigDecimal;
+import java.text.SimpleDateFormat;
+import java.util.*;
+
+/**
+ * @author kdq
+ * @version 1.0.0
+ * @ClassName DpController.java
+ * @Description TODO
+ * @createTime 2025骞�11鏈�16鏃� 14:59:00
+ */
+@RestController
+@RequestMapping("/dp")
+public class DpController {
+
+ @Autowired
+ private OspfInfoService ospfInfoService;
+
+ @GetMapping("/getTop")
+ public R getTop5() throws Exception {
+ List<Map<String,Object>> list = new ArrayList<>();
+ List<OspfInfo> ospfInfos = ospfInfoService.selectAllByParams(null);
+
+ for (OspfInfo ospfInfo : ospfInfos) {
+ HashMap<String, Object> map = new HashMap<>();
+ map.put("name",ospfInfo.getInfoContent());
+ map.put("ipaddress",ospfInfo.getHostname());
+ map.put("areaNum",ospfInfo.getAreaNum());
+ list.add(map);
+ }
+ if(list.size()>5){
+ return R.ok(list.subList(0,5));
+ }else {
+ return R.ok(list);
+ }
+ }
+
+ @GetMapping("/getWb")
+ public R getWb() throws Exception {
+ List<Map<String,Object>> list = new ArrayList<>();
+ List<OspfInfo> ospfInfos = ospfInfoService.selectAllByParams(null);
+
+ for (OspfInfo ospfInfo : ospfInfos) {
+ HashMap<String, Object> map = new HashMap<>();
+ map.put("name",ospfInfo.getInfoContent());
+ map.put("ipaddress",ospfInfo.getHostname());
+ map.put("type",1);
+ map.put("status",1);
+ list.add(map);
+ }
+ return R.ok(list);
+ }
+
+ @GetMapping("/getError")
+ public R getError() throws Exception {
+ SimpleDateFormat sdf = new SimpleDateFormat("MM/dd");
+ String format = sdf.format(new Date());
+ List<Map<String,Object>> list = new ArrayList<>();
+ List<OspfInfo> ospfInfos = ospfInfoService.selectAllByParams(null);
+
+ for (OspfInfo ospfInfo : ospfInfos) {
+ HashMap<String, Object> map = new HashMap<>();
+ map.put("date",format);
+ map.put("name",ospfInfo.getInfoContent());
+ map.put("ipaddress",ospfInfo.getHostname());
+ map.put("status",1);
+ list.add(map);
+ }
+ return R.ok(list);
+ }
+
+ @GetMapping("/getCount")
+ public R getCount() throws Exception {
+ List<OspfInfo> ospfInfos = ospfInfoService.selectAllByParams(null);
+ Map<String,Object> map = new HashMap<>();
+ map.put("allCount",ospfInfos.size());
+ map.put("normalCount",ospfInfos.size()-2);
+ map.put("errorCount",2);
+ double i = (double)(ospfInfos.size() - 2) /(double) ospfInfos.size();
+ double o = (double)2 /(double) ospfInfos.size();
+ BigDecimal n = new BigDecimal(i).setScale(2, BigDecimal.ROUND_HALF_UP);
+ BigDecimal e = new BigDecimal(o).setScale(2, BigDecimal.ROUND_HALF_UP);
+ map.put("normalProp",n);
+ map.put("errorProp",e);
+ return R.ok(map);
+ }
+ @GetMapping("/getInfo")
+ public R getInfo() throws Exception {
+ List<Map<String,Object>> list = new ArrayList<>();
+ List<OspfInfo> ospfInfos = ospfInfoService.selectAllByParams(null);
+ for (OspfInfo ospfInfo : ospfInfos) {
+ HashMap<String, Object> map = new HashMap<>();
+ map.put("ipAddress",ospfInfo.getHostname());
+ map.put("status",1);
+ list.add(map);
+ }
+ return R.ok(list);
+ }
+
+
+}
--
Gitblit v1.9.1