From 5ce314bb05eef373bd25b0b2e289a01bf6e5b6c4 Mon Sep 17 00:00:00 2001
From: 李宇 <986321569@qq.com>
Date: 星期三, 13 一月 2021 16:21:55 +0800
Subject: [PATCH] 添加危废信息展示以及app调用接口
---
src/main/java/com/nanometer/smartlab/service/HazardousWasteServiceImpl.java | 141 +++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 135 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/service/HazardousWasteServiceImpl.java b/src/main/java/com/nanometer/smartlab/service/HazardousWasteServiceImpl.java
index d32804f..5e8c800 100644
--- a/src/main/java/com/nanometer/smartlab/service/HazardousWasteServiceImpl.java
+++ b/src/main/java/com/nanometer/smartlab/service/HazardousWasteServiceImpl.java
@@ -2,13 +2,12 @@
import com.nanometer.smartlab.dao.HazardousWasteMapper;
import com.nanometer.smartlab.entity.HazardousWaste;
+import com.nanometer.smartlab.util.ExcelUtils;
+import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
-import java.util.Date;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
@Service
public class HazardousWasteServiceImpl implements HazardousWasteService{
@@ -17,20 +16,150 @@
private HazardousWasteMapper hazardousWasteMapper;
@Override
- public List<HazardousWaste> selectAll(Date startTime, Date endTime, Integer offset, Integer pageSize) {
+ public List<HazardousWaste> selectAll(Date startTime, Date endTime,String status,String applyPerson,String project,String department,
+ String tid, Integer offset, Integer pageSize) {
Map<String, Object> params = new HashMap<>();
params.put("startTime", startTime);
params.put("endTime", endTime);
params.put("first", offset);
params.put("pageSize", pageSize);
+ if (StringUtils.isNotBlank(status) && !status.equals("全部")){
+ params.put("status", status);
+ }
+ params.put("applyPerson", applyPerson);
+ params.put("project", project);
+ params.put("department", department);
+ params.put("tid", tid);
return hazardousWasteMapper.selectAll(params);
}
@Override
- public int countAll(Date startTime, Date endTime) {
+ public int countAll(Date startTime, Date endTime,String status,String applyPerson,String project,String department,String tid) {
Map<String, Object> params = new HashMap<>();
params.put("startTime", startTime);
params.put("endTime", endTime);
+ if (StringUtils.isNotBlank(status) && !status.equals("全部")){
+ params.put("status", status);
+ }
+ params.put("applyPerson", applyPerson);
+ params.put("project", project);
+ params.put("department", department);
+ params.put("tid", tid);
return hazardousWasteMapper.countAll(params);
}
+
+ @Override
+ public List<Map> exportList(Date startTime, Date endTime, String status, String applyPerson, String project, String department,String tid) {
+ Map<String, Object> params = new HashMap<>();
+ params.put("startTime", startTime);
+ params.put("endTime", endTime);
+ if (StringUtils.isNotBlank(status) && !status.equals("全部")){
+ params.put("status", status);
+ }
+ params.put("applyPerson", applyPerson);
+ params.put("project", project);
+ params.put("department", department);
+ params.put("tid", tid);
+ return hazardousWasteMapper.selectExportList(params);
+ }
+
+ @Override
+ public void export2Excel(List<Map> list) throws Exception {
+ Map<String,String> map = new LinkedHashMap<>();
+ map.put("tid", "单号");
+ map.put("status", "状态");
+ map.put("acid", "酸性废液");
+ map.put("alkali", "碱性废液");
+ map.put("organic", "有机废液");
+ map.put("solid", "固体废弃物");
+ map.put("medical", "医疗废弃物");
+ map.put("applyPerson", "确认者");
+ map.put("project", "课题组");
+ map.put("department", "部门");
+ map.put("unit", "单位");
+ map.put("creator", "创建者");
+ map.put("createTime", "创建时间");
+ ExcelUtils.export2Excel(list,"危废列表",map);
+ }
+
+ @Override
+ public int countStatistics(Date startTime, Date endTime, String status, String applyPerson, String project, String department) {
+ Map<String, Object> params = new HashMap<>();
+ params.put("startTime", startTime);
+ params.put("endTime", endTime);
+ if (StringUtils.isNotBlank(status) && !status.equals("全部")){
+ params.put("status", status);
+ }
+ params.put("applyPerson", applyPerson);
+ params.put("project", project);
+ params.put("department", department);
+ return hazardousWasteMapper.countStatistics(params);
+ }
+
+ @Override
+ public List<HazardousWaste> selectStatistics(Date startTime, Date endTime, String status, String applyPerson, String project, String department, int first, int pageSize) {
+ Map<String, Object> params = new HashMap<>();
+ params.put("startTime", startTime);
+ params.put("endTime", endTime);
+ params.put("first", first);
+ params.put("pageSize", pageSize);
+ if (StringUtils.isNotBlank(status) && !status.equals("全部")){
+ params.put("status", status);
+ }
+ params.put("applyPerson", applyPerson);
+ params.put("project", project);
+ params.put("department", department);
+ return hazardousWasteMapper.selectStatistics(params);
+ }
+
+ @Override
+ public List<Map> exportStatisticsList(Date startTime, Date endTime, String status, String applyPerson, String project, String department) {
+ Map<String, Object> params = new HashMap<>();
+ params.put("startTime", startTime);
+ params.put("endTime", endTime);
+ if (StringUtils.isNotBlank(status) && !status.equals("全部")){
+ params.put("status", status);
+ }
+ params.put("applyPerson", applyPerson);
+ params.put("project", project);
+ params.put("department", department);
+ return hazardousWasteMapper.selectStatisticsExportList(params);
+ }
+
+ @Override
+ public void exportStatistics2Excel(List<Map> list)throws Exception {
+ Map<String,String> map = new LinkedHashMap<>();
+ map.put("status", "状态");
+ map.put("acid", "酸性废液");
+ map.put("alkali", "碱性废液");
+ map.put("organic", "有机废液");
+ map.put("solid", "固体废弃物");
+ map.put("medical", "医疗废弃物");
+ map.put("applyPerson", "确认者");
+ map.put("project", "课题组");
+ map.put("department", "部门");
+ map.put("unit", "单位");
+ ExcelUtils.export2Excel(list,"危废统计分析",map);
+ }
+
+ @Override
+ public void insertInfo(HazardousWaste hazardousWaste) {
+ hazardousWasteMapper.insert(hazardousWaste);
+ }
+
+ @Override
+ public List<HazardousWaste> setAllWasters(String starttime, String endtime, String status, String applyPerson) {
+ return hazardousWasteMapper.setAllWasters(starttime,endtime, status, applyPerson);
+ }
+
+ @Override
+ public HazardousWaste selectByTid(String tid) {
+ return hazardousWasteMapper.selectByTid(tid);
+ }
+
+ @Override
+ public void updateWaste(HazardousWaste hazardousWaste) {
+ hazardousWasteMapper.updateByPrimaryKeySelective(hazardousWaste);
+ }
+
}
--
Gitblit v1.9.2