From 1f9bb7708751a9364ae69d9de5a95c1643ccb3da Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 14 Apr 2021 21:29:58 +0800
Subject: [PATCH] 为导出报表提供实时警情,违禁品,包裹,健康码,体温导出数据接口

---
 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/service/impl/AlarmServiceImpl.java |   88 +++++++++++++++++++++++++++++++-------------
 1 files changed, 62 insertions(+), 26 deletions(-)

diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/service/impl/AlarmServiceImpl.java b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/service/impl/AlarmServiceImpl.java
index d7d9e37..28fedfd 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/service/impl/AlarmServiceImpl.java
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/alarm/service/impl/AlarmServiceImpl.java
@@ -16,16 +16,14 @@
  */
 package org.springblade.jfpt.alarm.service.impl;
 
-import com.baomidou.dynamic.datasource.annotation.DS;
-import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import org.springblade.jfpt.alarm.constant.AlarmTimeConstant;
 import org.springblade.jfpt.alarm.entity.Alarm;
 import org.springblade.jfpt.alarm.mapper.AlarmMapper;
 import org.springblade.jfpt.alarm.service.IAlarmService;
+import org.springblade.common.entity.AlarmExcel;
 import org.springblade.jfpt.alarm.vo.AlarmVO;
-import org.springblade.jfpt.parcel.util.DateUtils;
 import org.springblade.jfpt.parcel.vo.ConditionVo;
 import org.springframework.stereotype.Service;
 
@@ -228,30 +226,31 @@
 				} catch (ParseException e) {
 					e.printStackTrace();
 				}
-			}else {
-				long nowTime = new Date().getTime();
-				try {
-					long alarmTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(alarm.getAlarmTime()).getTime();
-					//0-5分钟
-					if (nowTime-alarmTime>0 && nowTime-alarmTime<AlarmTimeConstant.FIVE_TIME){
-						count05+=1;
-					}
-					//5-10分钟
-					if (nowTime-alarmTime>=AlarmTimeConstant.FIVE_TIME && nowTime-alarmTime<AlarmTimeConstant.TEN_TIME){
-						count0510+=1;
-					}
-					//10-30分钟
-					if (nowTime-alarmTime>=AlarmTimeConstant.TEN_TIME && nowTime-alarmTime<AlarmTimeConstant.THIRTY_TIME){
-						count1030+=1;
-					}
-					//30分钟以上
-					if (nowTime-alarmTime>=AlarmTimeConstant.THIRTY_TIME){
-						count30+=1;
-					}
-				} catch (ParseException e) {
-					e.printStackTrace();
-				}
 			}
+//			else {
+//				long nowTime = new Date().getTime();
+//				try {
+//					long alarmTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(alarm.getAlarmTime()).getTime();
+//					//0-5分钟
+//					if (nowTime-alarmTime>0 && nowTime-alarmTime<AlarmTimeConstant.FIVE_TIME){
+//						count05+=1;
+//					}
+//					//5-10分钟
+//					if (nowTime-alarmTime>=AlarmTimeConstant.FIVE_TIME && nowTime-alarmTime<AlarmTimeConstant.TEN_TIME){
+//						count0510+=1;
+//					}
+//					//10-30分钟
+//					if (nowTime-alarmTime>=AlarmTimeConstant.TEN_TIME && nowTime-alarmTime<AlarmTimeConstant.THIRTY_TIME){
+//						count1030+=1;
+//					}
+//					//30分钟以上
+//					if (nowTime-alarmTime>=AlarmTimeConstant.THIRTY_TIME){
+//						count30+=1;
+//					}
+//				} catch (ParseException e) {
+//					e.printStackTrace();
+//				}
+//			}
 		}
 		//封装数据
 		list.add(count05);
@@ -347,4 +346,41 @@
 		}
 		return Arrays.asList(0,0,0,0,0,0,0,0,0,0,0,0);
 	}
+
+	/**
+	 * 统计时间段内一键求助警情数量数据
+	 * @param conditionVo
+	 * @return
+	 */
+	@Override
+	public Map<String, Object> selectAlarmTimeData(ConditionVo conditionVo) {
+		conditionVo.setStartTime(conditionVo.getStartTime().substring(0,10));
+		conditionVo.setEndTime(conditionVo.getEndTime().substring(0,10));
+		Map<String, Object> map = new HashMap<>();
+		//查询数据
+		List<Integer> list = baseMapper.selectAlarmTimeData(conditionVo);
+		//封装数据
+		map.put("alarmData",list);
+		//返回数据
+		return map;
+	}
+
+	@Override
+	public List<Map<String, Object>> queryYearAlarm(String deviceNumber) {
+		List childList = new ArrayList();
+		for (int i = 1; i <= 12; i++) {
+			childList.add(i);
+		}
+
+		return baseMapper.queryYearAlarm(deviceNumber,childList);
+	}
+
+	/**
+	 * 导出主动报警数据表格
+	 * @param alarmVO 查询条件
+	 */
+	@Override
+	public List<AlarmExcel> exportAlarm(AlarmVO alarmVO) {
+		return baseMapper.exportAlarm(alarmVO);
+	}
 }

--
Gitblit v1.9.3