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