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