From e77384436e2f6d454bcf2c4bb66f70bb6a2024a6 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期四, 19 六月 2025 16:39:26 +0800
Subject: [PATCH] 3.1预警设置界面用于导出的查询
---
src/main/java/com/whyc/service/PwrdevAlarmParamService.java | 78 ++++++++++++++++++++++++++++++++++++--
1 files changed, 73 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/whyc/service/PwrdevAlarmParamService.java b/src/main/java/com/whyc/service/PwrdevAlarmParamService.java
index 38d73ba..d53cc6b 100644
--- a/src/main/java/com/whyc/service/PwrdevAlarmParamService.java
+++ b/src/main/java/com/whyc/service/PwrdevAlarmParamService.java
@@ -1,13 +1,19 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
+import com.whyc.constant.PowerAlarmEnum;
+import com.whyc.dto.AlarmParam;
+import com.whyc.dto.Param.ParamAlmDto;
import com.whyc.dto.Real.AlmDto;
import com.whyc.dto.Response;
import com.whyc.mapper.PwrdevAlarmParamMapper;
import com.whyc.pojo.db_param.BattAlmparam;
import com.whyc.pojo.db_pwrdev_alarm.PwrdevAlarmParam;
+import com.whyc.pojo.db_station.PowerInf;
import com.whyc.util.ActionUtil;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
@@ -15,19 +21,80 @@
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
+import java.util.ArrayList;
+import java.util.HashMap;
import java.util.List;
+import java.util.Map;
@Service
public class PwrdevAlarmParamService {
@Autowired(required = false)
private PwrdevAlarmParamMapper mapper;
+ @Autowired(required = false)
+ private PowerInfService pinfService;
+
//鑾峰彇鐢垫簮鍛婅鍙傛暟
- public Response getPwrAlmParam(AlmDto almDto) {
- PageHelper.startPage(almDto.getPageNum(),almDto.getPageSize());
- List<PwrdevAlarmParam> list = mapper.getPwrAlmParam(almDto);
- PageInfo pageInfo=new PageInfo(list);
- return new Response().setII(1,list!=null,pageInfo,"鑾峰彇鐢垫簮鍛婅鍙傛暟");
+ public Response getPwrAlmParam(ParamAlmDto dto) {
+ //鏍规嵁鏌ヨ鏉′欢鑾峰彇鐢垫簮闆嗗悎
+ PowerInf pinf=pinfService.getPowerIdList(dto.getPowerId());
+ /*Map<String, List<PwrdevAlarmParam>> map=new HashMap<>();
+ List<PwrdevAlarmParam> almmap30=new ArrayList<>();
+ List<PwrdevAlarmParam> almmap31=new ArrayList<>();
+ List<PwrdevAlarmParam> almmap32=new ArrayList<>();
+ List<PwrdevAlarmParam> almmap33=new ArrayList<>();
+ List<PwrdevAlarmParam> almmap34=new ArrayList<>();
+ List<PwrdevAlarmParam> almmap35=new ArrayList<>();
+ List<PwrdevAlarmParam> almmap36=new ArrayList<>();*/
+ QueryWrapper wrapper=new QueryWrapper();
+ wrapper.eq("power_id",dto.getPowerId());
+ if(dto.getAlmIdList()!=null){
+ wrapper.in("alm_id",dto.getAlmIdList());
+ }
+ wrapper.orderByAsc("alm_id");
+ //PageHelper.startPage(dto.getPageNum(),dto.getPageSize());
+ List<PwrdevAlarmParam> list = mapper.selectList(wrapper);
+ if(list!=null && list.size()>0){
+ for (PwrdevAlarmParam alm:list) {
+ alm.setAlarmName(PowerAlarmEnum.getValue(alm.getAlmId()));
+ /* if(alm.getAlmId()/100000==30){
+ almmap30.add(alm);
+ map.put("鏁呴殰鍛婅",almmap30);
+ }
+ if(alm.getAlmId()/100000==31){
+ almmap31.add(alm);
+ map.put("浜ゆ祦杈撳叆鍛婅",almmap31);
+ }
+ if(alm.getAlmId()/100000==32){
+ almmap32.add(alm);
+ map.put("浜ゆ祦ABC鍛婅",almmap32);
+ }
+ if(alm.getAlmId()/100000==33){
+ almmap33.add(alm);
+ map.put("鏁存祦鍣ㄥ憡璀�",almmap33);
+ }
+ if(alm.getAlmId()/100000==34){
+ almmap34.add(alm);
+ map.put("钃勭數姹犲憡璀�",almmap34);
+ }
+ if(alm.getAlmId()/100000==35){
+ almmap35.add(alm);
+ map.put("娓╂箍搴︾儫鎰熷憡璀�",almmap35);
+ }
+ if(alm.getAlmId()/100000==36){
+ almmap36.add(alm);
+ map.put("鐩存祦鍛婅",almmap36);
+ }*/
+ }
+ }
+ // PageInfo<PwrdevAlarmParam> pageInfo=new PageInfo(list);
+ return new Response().setIII(1,list!=null,list,pinf,"鑾峰彇鐢垫簮鍛婅鍙傛暟");
+ }
+
+ //鑾峰彇鐢垫簮鍛婅鍙傛暟(鏃犲弬鐢ㄤ簬瀵煎嚭)
+ public Response getPwrAlmParamToExport(Integer uid) {
+ List<PwrdevAlarmParam> list = mapper.getPwrAlmParamToExport(uid);
+ return new Response().setII(1,list!=null,list,"鑾峰彇鐢垫簮鍛婅鍙傛暟(鏃犲弬鐢ㄤ簬瀵煎嚭)");
}
//淇敼鐢垫簮鍛婅鍙傛暟
public Response setPwrAlmParam(List<PwrdevAlarmParam> almparamList) {
@@ -39,4 +106,5 @@
}
return new Response().set(1,true,"淇敼鐢垫簮鍛婅鍙傛暟");
}
+
}
\ No newline at end of file
--
Gitblit v1.9.1