From dfed9c07aa8da5791d568736716bc4b44d59ebaf Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Fri, 16 Apr 2021 13:33:53 +0800
Subject: [PATCH] jfreechart+easyExcel 方式导出报表

---
 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/service/impl/HealthcodeServiceImpl.java |   39 +++++++++++++++++++++++++++++++++++++++
 1 files changed, 39 insertions(+), 0 deletions(-)

diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/service/impl/HealthcodeServiceImpl.java b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/service/impl/HealthcodeServiceImpl.java
index 635c4e0..6d99f83 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/service/impl/HealthcodeServiceImpl.java
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/healthcode/service/impl/HealthcodeServiceImpl.java
@@ -18,6 +18,7 @@
 
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springblade.common.entity.HealthcodeExcel;
 import org.springblade.jfpt.alarm.constant.AlarmTimeConstant;
 import org.springblade.jfpt.healthcode.entity.Healthcode;
 import org.springblade.jfpt.healthcode.mapper.healthcodeMapper;
@@ -184,4 +185,42 @@
 		//返回数据
 		return list;
 	}
+
+	/**
+	 * 统计时间段内红色健康码人数数量数据
+	 * @param conditionVo
+	 * @return
+	 */
+	@Override
+	public Map<String, Object> selectHealthcodeTimeData(ConditionVo conditionVo) {
+		conditionVo.setStartTime(conditionVo.getStartTime().substring(0,10));
+		conditionVo.setEndTime(conditionVo.getEndTime().substring(0,10));
+		//创建map对象
+		Map<String, Object> map = new HashMap<>();
+		//查询统计数据
+		List<Integer> list = baseMapper.selectHealthcodeTimeData(conditionVo);
+		//封装数据
+		map.put("healthcodeData",list);
+		//返回数据
+		return map;
+	}
+
+	/**
+	 * 导出健康码数据表格
+	 * @param healthcodeVO 查询条件
+	 */
+	@Override
+	public List<HealthcodeExcel> exportHealthcode(HealthcodeVO healthcodeVO) {
+		return baseMapper.exportHealthcode(healthcodeVO);
+	}
+
+	/**
+	 * 获取健康码图标数据
+	 * @param healthcodeVO 查询条件
+	 * @return
+	 */
+	@Override
+	public List<HealthcodeExcel> getHealthcodePie(HealthcodeVO healthcodeVO) {
+		return baseMapper.getHealthcodePie(healthcodeVO);
+	}
 }

--
Gitblit v1.9.3