From b843ec4ebeea58664944f1df4b4860585e23f0fa Mon Sep 17 00:00:00 2001
From: zhangnaisong <2434969829@qq.com>
Date: 星期六, 07 十月 2023 09:12:10 +0800
Subject: [PATCH] 应急预案查询加入时间倒序提交
---
ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java | 40 ++++++++++++++++++++--------------------
1 files changed, 20 insertions(+), 20 deletions(-)
diff --git a/ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java b/ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java
index 7b0e13a..a5fd639 100644
--- a/ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java
+++ b/ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java
@@ -1,5 +1,6 @@
package com.ruoyi.statistical.service.impl;
+import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.ruoyi.alarmpoints.well.domain.ArdAlarmpointsWell;
import com.ruoyi.alarmpoints.well.mapper.ArdAlarmpointsWellMapper;
@@ -11,6 +12,7 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import java.util.List;
import java.util.Map;
/**
@@ -69,26 +71,24 @@
}
}
}
- //璁板綍well琛ㄤ腑oil_production涓烘娊娌规満鐨勬暟鎹湁澶氬皯鏉�
- QueryWrapper<ArdAlarmpointsWell> queryWrapper = new QueryWrapper<>();
- queryWrapper.eq("oil_production","鎶芥补鏈�");
- int num = wellMapper.selectCount(queryWrapper);
- SysConfig sysConfigUpd = sysConfigMapper.checkConfigKeyUnique("well");
- if(sysConfigUpd!=null){
- sysConfigUpd.setConfigValue(String.valueOf(num));
- sysConfigUpd.setUpdateBy(SecurityUtils.getUsername());
- sysConfigMapper.updateConfig(sysConfigUpd);
- }else {
- SysConfig sysConfig = new SysConfig();
- int randomNum = (int) (Math.random() * (1000 - 1 + 1)) + 1;
- sysConfig.setConfigId((long) randomNum);
- sysConfig.setConfigType("Y");
- sysConfig.setConfigName("鎶芥按浜�");
- sysConfig.setConfigKey("well");
- sysConfig.setConfigValue(String.valueOf(num));
- sysConfig.setCreateBy(SecurityUtils.getUsername());
- sysConfigMapper.insertConfig(sysConfig);
- }
return Results.succeed("娣诲姞鎴愬姛锛�");
}
+
+ @Override
+ public Results factorySelect() {
+ JSONObject jsonObject = new JSONObject();
+ QueryWrapper<SysConfig> queryWrapper = new QueryWrapper<>();
+ queryWrapper.in("config_key","area","store","people","well","depot","unit");
+ List<SysConfig> list = sysConfigMapper.selectList(queryWrapper);
+ for (int i = 0; i < list.size(); i++) {
+ SysConfig sysConfig = list.get(i);
+ jsonObject.put(sysConfig.getConfigKey(),sysConfig.getConfigValue());
+ }
+ //璁板綍well琛ㄤ腑oil_production涓烘娊娌规満鐨勬暟鎹湁澶氬皯鏉�
+ QueryWrapper<ArdAlarmpointsWell> queryWrapperWell = new QueryWrapper<>();
+ queryWrapperWell.eq("oil_production","鎶芥补鏈�");
+ int num = wellMapper.selectCount(queryWrapperWell);
+ jsonObject.put("well",String.valueOf(num));
+ return Results.succeed(jsonObject);
+ }
}
--
Gitblit v1.9.3