FrontController.java 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682
  1. package com.slibra.web.controller.business;
  2. import com.alibaba.fastjson2.JSON;
  3. import com.alibaba.fastjson2.JSONWriter;
  4. import com.github.pagehelper.PageInfo;
  5. import com.slibra.business.domain.*;
  6. import com.slibra.business.mapper.*;
  7. import com.slibra.business.req.ChatReq;
  8. import com.slibra.business.req.WorkOrderReq;
  9. import com.slibra.business.res.CarbonMajorSimple;
  10. import com.slibra.business.res.CarbonSmartQueryDB;
  11. import com.slibra.business.res.IndustrySimpleBean;
  12. import com.slibra.business.res.RobotSimpleBean;
  13. import com.slibra.business.service.IFrontService;
  14. import com.slibra.business.service.ITXinyiCarbonMajorService;
  15. import com.slibra.common.DecimalUtils;
  16. import com.slibra.common.annotation.Log;
  17. import com.slibra.common.constant.HttpStatus;
  18. import com.slibra.common.constant.MyConstants;
  19. import com.slibra.common.core.controller.BaseController;
  20. import com.slibra.common.core.domain.AjaxResult;
  21. import com.slibra.common.core.domain.R;
  22. import com.slibra.common.core.page.TableDataInfo;
  23. import com.slibra.common.enums.BusinessEnum;
  24. import com.slibra.common.enums.BusinessType;
  25. import com.slibra.common.exception.ServiceException;
  26. import com.slibra.common.utils.DateUtils;
  27. import com.slibra.common.utils.SecurityUtils;
  28. import com.slibra.common.utils.StringUtils;
  29. import com.slibra.common.utils.poi.ExcelUtil;
  30. import com.slibra.common.utils.uuid.IdUtils;
  31. import com.sun.glass.ui.ClipboardAssistance;
  32. import lombok.extern.slf4j.Slf4j;
  33. import org.checkerframework.checker.units.qual.A;
  34. import org.checkerframework.checker.units.qual.C;
  35. import org.springframework.beans.BeanUtils;
  36. import org.springframework.beans.factory.annotation.Autowired;
  37. import org.springframework.security.access.prepost.PreAuthorize;
  38. import org.springframework.util.CollectionUtils;
  39. import org.springframework.web.bind.annotation.*;
  40. import javax.servlet.http.HttpServletResponse;
  41. import java.math.BigDecimal;
  42. import java.time.format.DateTimeFormatter;
  43. import java.util.*;
  44. import java.util.stream.Collectors;
  45. import static com.slibra.common.constant.MyConstants.*;
  46. /**
  47. * 前端用户相关接口
  48. */
  49. @RestController
  50. @RequestMapping("/front")
  51. @Slf4j
  52. public class FrontController extends BaseController {
  53. @Autowired
  54. private IFrontService frontService;
  55. @Autowired
  56. private TXinyiChatRecordMapper xinyiChatRecordMapper;
  57. @Autowired
  58. private TXinyiWarningRecordMapper xinyiWarningRecordMapper;
  59. @Autowired
  60. private TXinyiAgentAssistantMapper xinyiAgentAssistantMapper;
  61. @Autowired
  62. private TXinyiIndustryMapper xinyiIndustryMapper;
  63. @Autowired
  64. private TXinyiCarbonMajorMapper xinyiCarbonMajorMapper;
  65. @Autowired
  66. private ITXinyiCarbonMajorService tXinyiCarbonMajorService;
  67. @Autowired
  68. private TXinyiMedicineConfMapper xinyiMedicineConfMapper;
  69. @Autowired
  70. private TXinyiRobotMapper xinyiRobotMapper;
  71. /**
  72. * 获取大屏的实时数据 + 统计数据
  73. * @return
  74. */
  75. @GetMapping(value = "/realTimeData")
  76. public AjaxResult realTimeData()
  77. {
  78. log.info("进入了 获取大屏的实时数据 + 统计数据 接口");
  79. return AjaxResult.success(frontService.countInfo());
  80. }
  81. //2024年12月18日13:39:38 新增2个列表数据,用于展示工业库的数据和化验室的N天的数据,生成报表
  82. /**
  83. * 获取大屏的最近N天的工业库的数据
  84. * @return
  85. */
  86. @GetMapping(value = "/getIndustryDataByDays")
  87. public AjaxResult getIndustryDataByDays(@RequestParam(required = true) int days)
  88. {
  89. log.info("进入了 获取大屏的最近N天的工业库的数据 接口,请求参数为{}", days);
  90. List<IndustrySimpleBean> resultList = new ArrayList<>();
  91. //获取N天之前的日期
  92. List<TXinyiIndustry> tXinyiIndustries = this.xinyiIndustryMapper.selectTXinyiIndustryList(TXinyiIndustry.builder().timeBegin(DateUtils.parseDateToStr(DateUtils.YYYYMMDD_TS, DateUtils.plusDate(-days, DateUtils.getNowDate()))).build());
  93. if(!CollectionUtils.isEmpty(tXinyiIndustries)){
  94. for (TXinyiIndustry tXinyiIndustry : tXinyiIndustries) {
  95. IndustrySimpleBean industrySimpleBean = new IndustrySimpleBean();
  96. BeanUtils.copyProperties(tXinyiIndustry, industrySimpleBean);
  97. resultList.add(industrySimpleBean);
  98. }
  99. }
  100. return AjaxResult.success(resultList);
  101. }
  102. /**
  103. * 获取大屏的最近N天的化验室的数据
  104. * @return
  105. */
  106. @GetMapping(value = "/getRobotDataByDays")
  107. public AjaxResult getRobotDataByDays(@RequestParam(required = true) int days)
  108. {
  109. log.info("进入了 获取大屏的最近N天的化验室的数据 接口,请求参数为{}", days);
  110. List<RobotSimpleBean> resultList = new ArrayList<>();
  111. //获取N天之前的日期
  112. List<TXinyiRobot> tXinyiRobots = this.xinyiRobotMapper.selectTXinyiRobotList(TXinyiRobot.builder().timeBegin(DateUtils.parseDateToStr(DateUtils.YYYYMMDD_TS, DateUtils.plusDate(-days, DateUtils.getNowDate()))).build());
  113. if(!CollectionUtils.isEmpty(tXinyiRobots)){
  114. for (TXinyiRobot tXinyiRobot : tXinyiRobots) {
  115. RobotSimpleBean robotSimpleBean = new RobotSimpleBean();
  116. BeanUtils.copyProperties(tXinyiRobot, robotSimpleBean);
  117. resultList.add(robotSimpleBean);
  118. }
  119. }
  120. return AjaxResult.success(resultList);
  121. }
  122. /**
  123. * 分页获取大模型的问答记录
  124. * @param tXinyiChatRecord
  125. * @return
  126. */
  127. @GetMapping("/bigModel/qa/pageList")
  128. public TableDataInfo qaPageList(TXinyiChatRecord tXinyiChatRecord)
  129. {
  130. log.info("进入了 分页获取大模型的问答记录 接口");
  131. //获取登录用户信息
  132. Long userId = SecurityUtils.getUserId();
  133. tXinyiChatRecord.setUserId(String.valueOf(userId));
  134. startPage();
  135. return getDataTable(xinyiChatRecordMapper.selectTXinyiChatRecordFirstList(tXinyiChatRecord));
  136. }
  137. /**
  138. * 不分页获取大模型的问答记录
  139. * @param tXinyiChatRecord
  140. * @return
  141. */
  142. @GetMapping("/bigModel/qa/noPageList")
  143. public AjaxResult noPageList(TXinyiChatRecord tXinyiChatRecord)
  144. {
  145. log.info("进入了 不分页获取大模型的问答记录 接口");
  146. //获取登录用户信息
  147. Long userId = SecurityUtils.getUserId();
  148. tXinyiChatRecord.setUserId(String.valueOf(userId));
  149. return AjaxResult.success(xinyiChatRecordMapper.selectTXinyiChatRecordFirstList(tXinyiChatRecord));
  150. }
  151. /**
  152. * 通过sessionId获取某个用户的问答列表
  153. * @param tXinyiChatRecord
  154. * @return
  155. */
  156. @GetMapping("/bigModel/qa/qaListBySessionId")
  157. public AjaxResult qaListBySessionId(TXinyiChatRecord tXinyiChatRecord)
  158. {
  159. log.info("进入了 通过sessionId获取某个用户的问答列表 接口");
  160. String sessionId = tXinyiChatRecord.getSessionId();
  161. if(StringUtils.isBlank(sessionId))
  162. throw new ServiceException("必须传入sessionId");
  163. //获取登录用户信息
  164. Long userId = SecurityUtils.getUserId();
  165. tXinyiChatRecord.setUserId(String.valueOf(userId));
  166. //2024年08月16日13:50:30 拿到数据以后,按照counts字段排序,目的是让SQL通过ID排序,走主键索引
  167. return AjaxResult.success(xinyiChatRecordMapper.selectTXinyiChatRecordList(tXinyiChatRecord).stream().sorted(Comparator.comparing(TXinyiChatRecord::getCounts)).collect(Collectors.toList()));
  168. }
  169. /**
  170. *
  171. * 获取报警统计信息接口
  172. * @return
  173. */
  174. @GetMapping("/bigModel/warningCount")
  175. public AjaxResult warningCount()
  176. {
  177. log.info("进入了获取报警统计信息接口");
  178. return AjaxResult.success(frontService.warningCount());
  179. }
  180. /**
  181. * 首页报警记录(按时间倒叙 取十条)
  182. * @return
  183. */
  184. @GetMapping("/bigModel/home/warningList")
  185. public AjaxResult homeWarningList()
  186. {
  187. log.info("进入了 首页报警记录(按时间倒叙 取十条) 接口");
  188. return AjaxResult.success(frontService.homeWarningList());
  189. }
  190. /**
  191. * 获取 信义推荐问答列表
  192. * type: 0专家问答 1水质报警 2生化报警 3预测预警
  193. * @return
  194. */
  195. @GetMapping("/bigModel/home/recommendQAList/{type}")
  196. public AjaxResult recommendQAList(@PathVariable Integer type)
  197. {
  198. log.info("进入了 获取 信义推荐问答列表 接口");
  199. return AjaxResult.success(frontService.recommendQAList(type));
  200. }
  201. //报警+预警记录列表分页 【水质报警 1生化报警 2预测报警】
  202. /**
  203. * 报警+预警记录列表分页
  204. * @param tXinyiWarningRecord
  205. * @return
  206. */
  207. @GetMapping("/bigModel/warning/pageList")
  208. public TableDataInfo warningPageList(TXinyiWarningRecord tXinyiWarningRecord)
  209. {
  210. log.info("进入了 报警+预警记录列表分页 接口");
  211. startPage();
  212. List<TXinyiWarningRecord> tXinyiWarningRecords = xinyiWarningRecordMapper.selectTXinyiWarningRecordList(tXinyiWarningRecord);
  213. this.addWarningRecordExtra(tXinyiWarningRecords);
  214. return getDataTable(tXinyiWarningRecords);
  215. }
  216. //报警+预警记录列表不分页 【水质报警 1生化报警 2预测报警】
  217. /**
  218. * 报警+预警记录列表不分页
  219. * @param tXinyiWarningRecord
  220. * @return
  221. */
  222. @GetMapping("/bigModel/warning/noPageList")
  223. public AjaxResult noPageList(TXinyiWarningRecord tXinyiWarningRecord)
  224. {
  225. log.info("进入了 报警+预警记录列表不分页 接口");
  226. List<TXinyiWarningRecord> tXinyiWarningRecords = xinyiWarningRecordMapper.selectTXinyiWarningRecordList(tXinyiWarningRecord);
  227. this.addWarningRecordExtra(tXinyiWarningRecords);
  228. return AjaxResult.success(tXinyiWarningRecords);
  229. }
  230. private void addWarningRecordExtra(List<TXinyiWarningRecord> tXinyiWarningRecords) {
  231. if(!CollectionUtils.isEmpty(tXinyiWarningRecords)){
  232. for (TXinyiWarningRecord tXinyiWarningRecord : tXinyiWarningRecords) {
  233. Date endDate = null;
  234. //判断类型 如果结束了 截止时间就是告警截止时间; 如果正在报警 截止时间就是当前时间
  235. if(0 == tXinyiWarningRecord.getStatus() || 3 == tXinyiWarningRecord.getStatus())
  236. endDate = DateUtils.getNowDate();
  237. else
  238. endDate = tXinyiWarningRecord.getOffTime();
  239. //防止 之前程序处理错误 理论上不再报警了,一定有截止时间的
  240. if(Objects.isNull(endDate)){
  241. log.error("xxxxxxxxx:之前处理告警结束的逻辑异常,没有更新截止时间");
  242. endDate = DateUtils.getNowDate();
  243. }
  244. tXinyiWarningRecord.setCounts(Math.min(DateUtils.differentHoursByMillisecond(tXinyiWarningRecord.getCreateTime(), endDate) + 1, MAX_COUNT));
  245. //2024年7月11日13:36:41 新增处理,返回带单位的报警值(目前只处理生化报警的)
  246. if(1 == tXinyiWarningRecord.getType())
  247. tXinyiWarningRecord.setWarningValStr(this.getWarningValStr(tXinyiWarningRecord.getWarningVal(), tXinyiWarningRecord.getCategory()));
  248. //2024年7月13日17:41:06 小数点保留两位小数
  249. this.handleDecimalPoint(tXinyiWarningRecord);
  250. }
  251. }
  252. }
  253. private void handleDecimalPoint(TXinyiWarningRecord xinyiWarningRecord) {
  254. BigDecimal warningVal = xinyiWarningRecord.getWarningVal();
  255. BigDecimal designVal = xinyiWarningRecord.getDesignVal();
  256. BigDecimal controlVal = xinyiWarningRecord.getControlVal();
  257. BigDecimal forecastVal = xinyiWarningRecord.getForecastVal();
  258. if(!Objects.isNull(warningVal))
  259. xinyiWarningRecord.setWarningVal(DecimalUtils.getAbsAndScale(warningVal, INT_2));
  260. if(!Objects.isNull(designVal))
  261. xinyiWarningRecord.setDesignVal(DecimalUtils.getAbsAndScale(designVal, INT_2));
  262. if(!Objects.isNull(controlVal))
  263. xinyiWarningRecord.setControlVal(DecimalUtils.getAbsAndScale(controlVal, INT_2));
  264. if(!Objects.isNull(forecastVal))
  265. xinyiWarningRecord.setForecastVal(DecimalUtils.getAbsAndScale(forecastVal, INT_2));
  266. }
  267. private String getWarningValStr(BigDecimal warningVal, String category) {
  268. BigDecimal absAndScale = DecimalUtils.getAbsAndScale(warningVal, MyConstants.INT_2);
  269. if(BusinessEnum.WarningCategoryEnum.NHLB.getCode().equals(category))
  270. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.PERCENT.getCode();
  271. if(BusinessEnum.WarningCategoryEnum.WHLB.getCode().equals(category))
  272. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.PERCENT.getCode();
  273. if(BusinessEnum.WarningCategoryEnum.WNND_MLSS_1.getCode().equals(category))
  274. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.MG_L.getCode();
  275. if(BusinessEnum.WarningCategoryEnum.WNND_MLSS_2.getCode().equals(category))
  276. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.MG_L.getCode();
  277. if(BusinessEnum.WarningCategoryEnum.WNFH.getCode().equals(category))
  278. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.KGBOD_KGMLSS_D.getCode();
  279. if(BusinessEnum.WarningCategoryEnum.HFXWNNDZB.getCode().equals(category))
  280. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.NULL.getCode();
  281. if(BusinessEnum.WarningCategoryEnum.TDB.getCode().equals(category))
  282. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.NULL.getCode();
  283. if(BusinessEnum.WarningCategoryEnum.TLB.getCode().equals(category))
  284. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.NULL.getCode();
  285. if(BusinessEnum.WarningCategoryEnum.BODCODB.getCode().equals(category))
  286. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.NULL.getCode();
  287. if(BusinessEnum.WarningCategoryEnum.HYQDO_ONE.getCode().equals(category))
  288. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.MG_L.getCode();
  289. if(BusinessEnum.WarningCategoryEnum.HYQDO_TWO.getCode().equals(category))
  290. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.MG_L.getCode();
  291. if(BusinessEnum.WarningCategoryEnum.QSB.getCode().equals(category))
  292. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.M3_M3.getCode();
  293. if(BusinessEnum.WarningCategoryEnum.ECC_BMFH.getCode().equals(category))
  294. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.M3_M2_H.getCode();
  295. if(BusinessEnum.WarningCategoryEnum.ECC_GTFH.getCode().equals(category))
  296. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.KG_M2_D.getCode();
  297. if(BusinessEnum.WarningCategoryEnum.FCXSL.getCode().equals(category))
  298. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.PERCENT.getCode();
  299. return absAndScale + SPACE_STR + BusinessEnum.BigModelUnitEnum.NULL.getCode();
  300. }
  301. /**
  302. * 获取 后台配置的智能助手列表
  303. * @return
  304. */
  305. @GetMapping("/bigModel/agentAssistant/list")
  306. public AjaxResult agentAssistantList()
  307. {
  308. log.info("进入了 获取 后台配置的智能助手列表 接口");
  309. return AjaxResult.success(xinyiAgentAssistantMapper.selectTXinyiAgentAssistantList(null));
  310. }
  311. /**
  312. * 获取 告警id获取决策列表的最后一条数据
  313. * 2024年6月23日17:30:07 因为只展示一条数据,所以判断是不是最后一条数据是report类型的,如果是就返回; 如果不是,获取是定时任务生成的最近的一条数据
  314. * @return
  315. */
  316. @GetMapping("/bigModel/warning/qaDetailByWarningId/{warningId}")
  317. public AjaxResult qaDetailByWarningId(@PathVariable String warningId)
  318. {
  319. log.info("进入了 获取 告警id获取决策列表的最后一条数据 接口");
  320. return AjaxResult.success(frontService.qaDetailByWarningId(warningId));
  321. }
  322. /**
  323. * 删除问答记录(单条)
  324. * @return
  325. */
  326. @DeleteMapping("/bigModel/chat/deleteOneChtById/{id}")
  327. public AjaxResult deleteOneChtById(@PathVariable Long id)
  328. {
  329. log.info("进入了 删除问答记录(单条) 接口");
  330. return AjaxResult.success(xinyiChatRecordMapper.deleteTXinyiChatRecordById(id));
  331. }
  332. /**
  333. * 生成sessionId给聊天接口使用
  334. * @return
  335. */
  336. @GetMapping("/bigModel/chat/generateSessionId")
  337. public AjaxResult generateSessionId()
  338. {
  339. log.info("进入了 生成sessionId给聊天接口使用 接口");
  340. return AjaxResult.success(SUCCESS, IdUtils.simpleUUID());
  341. }
  342. /**
  343. * 标记问题是否满意
  344. * @return
  345. */
  346. @PutMapping("/bigModel/chat/isSatisfiedAnswer")
  347. public AjaxResult isSatisfiedAnswer(@RequestBody ChatReq chatReq)
  348. {
  349. log.info("进入了 标记问题是否满意 接口");
  350. return AjaxResult.success(frontService.isSatisfiedAnswer(chatReq));
  351. }
  352. /**
  353. * 人工处理告警接口(是否采用大模型问答 是否转应急 归档/上传地址)
  354. * @return
  355. */
  356. @PutMapping("/bigModel/warning/handleWarningByMan")
  357. public AjaxResult handleWarningByMan(@RequestBody TXinyiWarningRecord warningRecord)
  358. {
  359. log.info("进入了 人工处理告警接口 接口");
  360. return AjaxResult.success(frontService.handleWarningByMan(warningRecord));
  361. }
  362. /**
  363. * 获取 首页简报的问答数据
  364. * @return
  365. */
  366. @GetMapping("/bigModel/home/getLeastShortReport")
  367. public AjaxResult getLeastShortReport()
  368. {
  369. log.info("进入了 首页简报的问答数据获取 接口");
  370. return AjaxResult.success(frontService.getLeastShortReport());
  371. }
  372. /**
  373. * 获取 告警id获取所有的仿真预测列表
  374. * @return
  375. */
  376. @GetMapping("/bigModel/warning/forecastList/{warningId}")
  377. public AjaxResult forecastList(@PathVariable String warningId)
  378. {
  379. log.info("进入了 获取 告警id获取所有的仿真预测列表 接口");
  380. return AjaxResult.success(frontService.forecastList(warningId));
  381. }
  382. /**
  383. * 获取 最新的一条日报相关的费用信息
  384. * @return
  385. */
  386. @GetMapping("/bigModel/daily/recentlyOneFeeInfo")
  387. public String recentlyOneFeeInfo()
  388. {
  389. log.info("进入了 获取 最新的一条日报相关的费用信息 接口");
  390. return JSON.toJSONString(success(frontService.recentlyOneFeeInfo()), JSONWriter.Feature.WriteNulls);
  391. }
  392. /**
  393. * 自定义工单接口 获取数据接口
  394. * @return
  395. * 2024年6月19日14:45:51 返回结构再处理下,方便前端解析
  396. */
  397. @PostMapping("/bigModel/custom/workOrder")
  398. public AjaxResult customWorkOrder(@RequestBody WorkOrderReq workOrderReq)
  399. {
  400. log.info("进入了 自定义工单接口 获取数据接口 接口");
  401. return AjaxResult.success(frontService.customWorkOrderHandle(workOrderReq));
  402. }
  403. /**
  404. *
  405. * 大模型停止生成
  406. * @param sessionId
  407. * @return
  408. */
  409. @GetMapping("/bigModel/warning/stopChat/{sessionId}")
  410. public AjaxResult stopChat(@PathVariable String sessionId)
  411. {
  412. log.info("进入了 大模型停止生成 接口");
  413. return AjaxResult.success(frontService.stopChat(sessionId));
  414. }
  415. /**
  416. *
  417. * 智能投药系统获取实时需要数据接口
  418. * @return
  419. */
  420. @GetMapping("/bigModel/smartAdd/dataInfo")
  421. public AjaxResult smartAddDataInfo()
  422. {
  423. log.info("进入了 智能投药系统获取实时需要数据 接口");
  424. return AjaxResult.success(frontService.smartAddDataInfo());
  425. }
  426. /**
  427. * type说明:
  428. * 0:进水流量
  429. * 1:#1好氧池硝酸盐
  430. * 2:#2好氧池硝酸盐
  431. * 3:#1缺氧池氨氮
  432. * 4:#2缺氧池氨氮
  433. * 5:进水COD
  434. * 6:进水总氮
  435. * 7:碳源投加量
  436. *
  437. *
  438. * @param type
  439. * @return
  440. */
  441. @GetMapping("/bigModel/smartAdd/charList/{type}")
  442. public AjaxResult smartAddCharList(@PathVariable int type, @RequestParam(required = false, name = "timeBegin") String timeBegin, @RequestParam(required = false, name = "timeEnd") String timeEnd)
  443. {
  444. log.info("进入了 智能投药系统获取对应指标最近3天的数据情况 接口");
  445. return AjaxResult.success(frontService.smartAddCharList(type, timeBegin, timeEnd));
  446. }
  447. /**
  448. *获取碳源投加 是否在本系统中允许投放(用于部分场景:计算异常 或者 想手动中断等)
  449. * @return
  450. */
  451. @GetMapping("/bigModel/smartAdd/getSwitchStatus")
  452. public R<Integer> getSwitchStatus()
  453. {
  454. log.info("进入了 获取碳源投加 是否在本系统中允许投放(用于部分场景:计算异常 或者 想手动中断等) 接口");
  455. TXinyiMedicineConf tXinyiMedicineConf = xinyiMedicineConfMapper.selectTXinyiMedicineConfById(LONG_1);
  456. if(Objects.isNull(tXinyiMedicineConf))
  457. throw new ServiceException("未查询到碳源投放配置开关");
  458. return R.ok(tXinyiMedicineConf.getAddStatus());
  459. }
  460. /**
  461. *修改碳源投加 是否在本系统中允许投放(用于部分场景:计算异常 或者 想手动中断等)
  462. * @return
  463. */
  464. @PutMapping("/bigModel/smartAdd/updateSwitchStatus")
  465. public R<String> updateSwitchStatus(@RequestBody TXinyiMedicineConf tXinyiMedicineConf)
  466. {
  467. log.info("进入了 修改碳源投加 是否在本系统中允许投放(用于部分场景:计算异常 或者 想手动中断等) 接口");
  468. if(Objects.isNull(tXinyiMedicineConf.getAddStatus()))
  469. throw new ServiceException("请输入要更改的状态");
  470. tXinyiMedicineConf.setId(LONG_1);
  471. this.xinyiMedicineConfMapper.updateTXinyiMedicineConf(tXinyiMedicineConf);
  472. return R.ok("修改成功");
  473. }
  474. //--------------------下面是碳排放智能体相关的方法--------------------begin
  475. /**
  476. * 碳排放智能体-获取所有的填写的月份
  477. * @return
  478. */
  479. @GetMapping("/bigModel/carbonSmart/allMonths")
  480. public R<List<String>> allMonths()
  481. {
  482. log.info("进入了 碳排放智能体-获取所有的填写的月份 接口");
  483. return R.ok(xinyiCarbonMajorMapper.allMonths());
  484. }
  485. /**
  486. * 获取某个月份的部分数据(水量是总值 tn和cod是平均值)
  487. */
  488. @GetMapping(value = "/bigModel/carbonSmart/getDBDatas/{month}")
  489. public R<CarbonSmartQueryDB> getDBDatasByMonth(@PathVariable("month") String month)
  490. {
  491. return R.ok(tXinyiCarbonMajorService.getDBDatasByMonth(month));
  492. }
  493. /**
  494. * 通过月份获取碳排放主详细信息
  495. */
  496. @GetMapping(value = "/bigModel/carbonSmart/getCarbonDetailsByMonth/{month}")
  497. public R<TXinyiCarbonMajor> getCarbonDetailsByMonth(@PathVariable("month") String month)
  498. {
  499. return R.ok(tXinyiCarbonMajorService.getCarbonDetailsByMonth(month));
  500. }
  501. /**
  502. * 通过ID获取碳排放主详细信息
  503. */
  504. @GetMapping(value = "/bigModel/carbonSmart/getCarbonDetailsById/{id}")
  505. public R<TXinyiCarbonMajor> getCarbonDetailsById(@PathVariable("id") Long id)
  506. {
  507. return R.ok(tXinyiCarbonMajorService.getCarbonDetailsById(id));
  508. }
  509. /**
  510. * 查询碳排放主列表数据-部分展示字段(分页)
  511. */
  512. @GetMapping("/bigModel/carbonSmart/pageList")
  513. public TableDataInfo carbonSmartPageList(TXinyiCarbonMajor tXinyiCarbonMajor)
  514. {
  515. startPage();
  516. List<TXinyiCarbonMajor> list = tXinyiCarbonMajorService.selectTXinyiCarbonMajorList(tXinyiCarbonMajor);
  517. List<CarbonMajorSimple> resultList = new ArrayList<>();
  518. if(!CollectionUtils.isEmpty(list)) {
  519. for (TXinyiCarbonMajor xinyiCarbonMajor : list) {
  520. CarbonMajorSimple carbonMajorSimple = new CarbonMajorSimple();
  521. BeanUtils.copyProperties(xinyiCarbonMajor, carbonMajorSimple);
  522. resultList.add(carbonMajorSimple);
  523. }
  524. }
  525. TableDataInfo rspData = new TableDataInfo();
  526. rspData.setCode(HttpStatus.SUCCESS);
  527. rspData.setMsg("查询成功");
  528. rspData.setRows(resultList);
  529. rspData.setTotal(new PageInfo(list).getTotal());
  530. return rspData;
  531. }
  532. /**
  533. * 导出碳排放主列表部分字段
  534. */
  535. @PostMapping("/bigModel/carbonSmart/export")
  536. public void carbonSmartExport(HttpServletResponse response, TXinyiCarbonMajor tXinyiCarbonMajor)
  537. {
  538. List<TXinyiCarbonMajor> list = tXinyiCarbonMajorService.selectTXinyiCarbonMajorList(tXinyiCarbonMajor);
  539. if(CollectionUtils.isEmpty(list))
  540. log.info("导出的数据为空,无法导出");
  541. else{
  542. List<CarbonMajorSimple> resultList = new ArrayList<>();
  543. for (TXinyiCarbonMajor xinyiCarbonMajor : list) {
  544. CarbonMajorSimple carbonMajorSimple = new CarbonMajorSimple();
  545. BeanUtils.copyProperties(xinyiCarbonMajor, carbonMajorSimple);
  546. resultList.add(carbonMajorSimple);
  547. }
  548. ExcelUtil<CarbonMajorSimple> util = new ExcelUtil<>(CarbonMajorSimple.class);
  549. util.exportExcel(response, resultList, "碳排放主数据");
  550. }
  551. }
  552. /**
  553. * 新增碳排放主
  554. */
  555. @PostMapping("/bigModel/carbonSmart/addCarbonSmart")
  556. public AjaxResult addCarbonSmart(@RequestBody TXinyiCarbonMajor tXinyiCarbonMajor)
  557. {
  558. // tXinyiCarbonMajor.setCreateBy(getUsername());
  559. return toAjax(tXinyiCarbonMajorService.insertTXinyiCarbonMajor(tXinyiCarbonMajor));
  560. }
  561. //--------------------上面是碳排放智能体相关的方法--------------------end
  562. //--------------------下面是测试的方法--------------------
  563. /*@GetMapping("/test/data")
  564. public void testData(){
  565. List<DecisionReq> decisionReqs = this.xinyiIndustryMapper.selectLast10RecordsForDecisionOnlyIndustry();
  566. System.out.println(JSON.toJSONString(decisionReqs, JSONWriter.Feature.WriteNulls));
  567. }*/
  568. }