hust-epi/whepi-web/src/main/java/com/bofeng/controller/EpiLYExportController.java

package com.bofeng.controller;

import com.bofeng.dao.MsReportMapper;
import com.bofeng.dao.UserOpenMapper;
import com.bofeng.entity.*;
import com.bofeng.service.MsReportService;
import com.bofeng.service.MsTripService;
import com.bofeng.word.WordUtils;
import com.google.common.collect.Lists;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.*;

@RestController
public class EpiLYExportController {

    @Autowired
    private UserOpenMapper userOpenMapper;
    @Autowired
    private MsReportMapper msReportMapper;
    @Autowired
    private MsTripService msTripService;
    @Autowired
    private MsReportService msReportService;

    @ApiOperation("导出单个健康及旅居申报表")
    @GetMapping("/whepi/export/lyReport")
    public @ResponseBody
    void exportSellPlan(HttpServletRequest request, HttpServletResponse response) {
        Long userId = Long.parseLong(request.getParameter("userId"));
        String userName = "", workPlace = "", telPhone = "", isLeave = "", trip = "", blackTime = "", veicle = "", otherSymptom = "", isTrue = "";
        //用户姓名，电话
        UserOpen userOpen = userOpenMapper.selectUserBaseByUserId(userId);
        if (userOpen != null) {
            userName = userOpen.getLinkman();
            telPhone = userOpen.getPhone();
        }
        //工作驻地
        MsTrip msTrip = msReportMapper.selectWorkByUserId(userId);
        if (msTrip != null)
            workPlace = msReportService.getLocalOther(msTrip.getWorkLocal(), msTrip.getWorkLocalOther());
        //是否离开过驻地
        MsTrip msTrip1 = msReportMapper.selectIsTripByUserId(userId);
        if (msTrip1 == null)
            isLeave = "否";
        else
            isLeave = "是";
        //15日居住地
        List<MsTrip> listMsTrip = msReportMapper.select15TripByUserId(userId);
        if (listMsTrip != null && listMsTrip.size() > 0) {
            for (MsTrip msTrip2 : listMsTrip) {
                if (msReportService.getLocalOther(msTrip2.getTodayLocal(), msTrip2.getTodayLocalOther()) != "")
                    trip += msReportService.getLocalOther(msTrip2.getTodayLocal(), msTrip2.getTodayLocalOther()) + ",";
            }
            trip = trip.substring(0, trip.length() - 1);
        }
        //返回时间
        MsReport msReport = msReportMapper.selectBackTripByUserId(userId);
        if (msReport != null) {
            SimpleDateFormat sj = new SimpleDateFormat("yyyy-MM-dd");
            blackTime = sj.format(msReport.getReportDate());
            //返回交通工具
            List<MsTripDet> listMsTripDet = msReportMapper.selectBackTripByReportrId(msReport.getReportId());
            if (listMsTripDet != null && listMsTripDet.size() > 0) {
                for (MsTripDet msTripDet : listMsTripDet) {
                    veicle += msReportService.getTripType(msTripDet.getTripType()) + ",";
                }
                veicle = veicle.substring(0, veicle.length() - 1);
            }
        }
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("userName", userName);
        map.put("workPlace", workPlace);
        map.put("telPhone", telPhone);
        map.put("isLeave", isLeave);
        map.put("trip", trip);
        map.put("backTime", blackTime);
        map.put("vehicle", veicle);

        Map<String, Object> rt = new HashMap<String, Object>();
        map.put("rt", rt);
        for (int i = 1; i <= 5; i++) {
            rt.put("d" + i, msReportService.getTimeByDate(i - 5));
            rt.put("t" + i, msReportService.getTemperature(userId, i - 5));
        }

        //是否有其他症状
        List<MsSuspected> listSuspected1 = msReportMapper.selectOtherSymptomByReportrId(userId);
        if (listSuspected1 != null && listSuspected1.size() > 0)
            otherSymptom = "是";
        else
            otherSymptom = "否";
        map.put("otherSymptom", otherSymptom);
        Integer sureNum = msReportMapper.selectisSuspectedNum(userId);
        if (sureNum == 0)
            isTrue = "否";
        else
            isTrue = "是";
        //是否确诊
        map.put("isTrue", isTrue);

        WordUtils.exportWord("word/健康及旅居申报表_20200221.docx", "temp", "健康及旅居申报表.docx", map, request, response);
    }

    @ApiOperation("导出多个健康及旅居申报表")
    @GetMapping("/whepi/export/lyReports")
    public @ResponseBody
    void exportSellPlan2(HttpServletRequest request, HttpServletResponse response) {
        String userIds = request.getParameter("userId");
        String[] listUserId = userIds.split(",");
        List<Map<String, Object>> list = Lists.newArrayList();
        for (String userStringId : listUserId) {
            Long userId = Long.parseLong(userStringId);
            String userName = "", workPlace = "", telPhone = "", isLeave = "", trip = "", blackTime = "", veicle = "", otherSymptom = "", isTrue = "";
            //用户姓名，电话
            UserOpen userOpen = userOpenMapper.selectUserBaseByUserId(userId);
            if (userOpen != null) {
                userName = userOpen.getLinkman();
                telPhone = userOpen.getPhone();
            }
            //工作驻地
            MsTrip msTrip = msReportMapper.selectWorkByUserId(userId);
            if (msTrip != null)
                workPlace = msReportService.getLocalOther(msTrip.getWorkLocal(), msTrip.getWorkLocalOther());
            //是否离开过驻地
            MsTrip msTrip1 = msReportMapper.selectIsTripByUserId(userId);
            if (msTrip1 == null)
                isLeave = "否";
            else
                isLeave = "是";
            //15日居住地
            List<MsTrip> listMsTrip = msReportMapper.select15TripByUserId(userId);
            if (listMsTrip != null && listMsTrip.size() > 0) {
                for (MsTrip msTrip2 : listMsTrip) {
                    if (msReportService.getLocalOther(msTrip2.getTodayLocal(), msTrip2.getTodayLocalOther()) != "")
                        trip += msReportService.getLocalOther(msTrip2.getTodayLocal(), msTrip2.getTodayLocalOther()) + ",";
                }
                trip = trip.substring(0, trip.length() - 1);
            }
            //返回时间
            MsReport msReport = msReportMapper.selectBackTripByUserId(userId);
            if (msReport != null) {
                SimpleDateFormat sj = new SimpleDateFormat("yyyy-MM-dd");
                blackTime = sj.format(msReport.getReportDate());
                //返回交通工具
                List<MsTripDet> listMsTripDet = msReportMapper.selectBackTripByReportrId(msReport.getReportId());
                if (listMsTripDet != null && listMsTripDet.size() > 0) {
                    for (MsTripDet msTripDet : listMsTripDet) {
                        veicle += msReportService.getTripType(msTripDet.getTripType()) + ",";
                    }
                    veicle = veicle.substring(0, veicle.length() - 1);
                }
            }
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("userName", userName);
            map.put("workPlace", workPlace);
            map.put("telPhone", telPhone);
            map.put("isLeave", isLeave);
            map.put("trip", trip);
            map.put("backTime", blackTime);
            map.put("vehicle", veicle);

            Map<String, Object> rt = new HashMap<String, Object>();
            map.put("rt", rt);
            for (int i = 1; i <= 5; i++) {
                rt.put("d" + i, msReportService.getTimeByDate(i - 5));
                rt.put("t" + i, msReportService.getTemperature(userId, i - 5));
            }

            //是否有其他症状
            List<MsSuspected> listSuspected1 = msReportMapper.selectOtherSymptomByReportrId(userId);
            if (listSuspected1 != null && listSuspected1.size() > 0)
                otherSymptom = "是";
            else
                otherSymptom = "否";
            map.put("otherSymptom", otherSymptom);
            Integer sureNum = msReportMapper.selectisSuspectedNum(userId);
            if (sureNum == 0)
                isTrue = "否";
            else
                isTrue = "是";
            //是否确诊
            map.put("isTrue", isTrue);
            list.add(map);
        }
        WordUtils.exportWord("word/健康及旅居申报表_20200221.docx", "temp", "健康及旅居申报表.docx", list, request, response);
    }

    @ApiOperation("导出单个隔离人员解除隔离审批表")
    @GetMapping("/whepi/export/lyApprove")
    public @ResponseBody
    void lyApprove(HttpServletRequest request, HttpServletResponse response) {
        Long userId = Long.parseLong(request.getParameter("userId"));
        String userName = "", org = "", gander = "", bAddr = "", backDate = "", otherSymptom = "";
        //用户姓名，部门
        UserOpen userOpen = userOpenMapper.selectUserBaseByUserId(userId);
        if (userOpen != null) {
            userName = userOpen.getLinkman();
            org = userOpen.getRidgepole() + userOpen.getUnit();
        }
        //性别
        //性别
        List<MsSuspected> ListMsSuspected = msReportMapper.selectGrenderUserId(userId);
        if(ListMsSuspected!=null && ListMsSuspected.size()>1)
            return;
        if (ListMsSuspected!=null && ListMsSuspected.size()==1){
            if (ListMsSuspected.get(0).getGrender() == 1)
                gander = "男";
            if (ListMsSuspected.get(0).getGrender() == 2)
                gander = "女";
        }

        //返回时间
        MsReport msReport = msReportMapper.selectBackTripByUserId(userId);
        if (msReport != null) {
            SimpleDateFormat sj = new SimpleDateFormat("yyyy-MM-dd");
            backDate = sj.format(msReport.getReportDate());
            bAddr = msReportService.getLocalOther(msReport.getTodayLocal(), msReport.getTodayLocalOther());
        }
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("userName", userName);
        map.put("gander", gander);
        map.put("org", org);
        map.put("bAddr", bAddr);
        map.put("backDate", backDate);

        //最近15天体温
        Map<String, Object> rt = new HashMap<String, Object>();
        map.put("rt", rt);
        for (int i = 1; i <= 15; i++) {
            rt.put("d" + i, msReportService.getTimeByDate(i - 15));
            rt.put("t" + i, msReportService.getTemperature(userId, i - 15));
        }

        List<MsSuspected> listSuspected1 = msReportMapper.selectOtherSymptomByReportrId(userId);
        if (listSuspected1 != null && listSuspected1.size() > 0)
            otherSymptom = "是";
        else
            otherSymptom = "否";
        map.put("otherSymptom", otherSymptom);

        WordUtils.exportWord("word/隔离人员解除隔离审批表_20200221.docx", "temp", "隔离人员解除隔离审批表.docx", map, request, response);
    }

    @ApiOperation("导出多个隔离人员解除隔离审批表")
    @GetMapping("/whepi/export/lyApproves")
    public @ResponseBody
    void lyApproves(HttpServletRequest request, HttpServletResponse response) {

        String userIds = request.getParameter("userId");
        String[] listUserId = userIds.split(",");
        List<Map<String, Object>> list = Lists.newArrayList();
        for (String userStringId : listUserId) {
            Long userId = Long.parseLong(userStringId);
            String userName = "", org = "", gander = "", bAddr = "", backDate = "", otherSymptom = "";
            //用户姓名，部门
            UserOpen userOpen = userOpenMapper.selectUserBaseByUserId(userId);
            if (userOpen != null) {
                userName = userOpen.getLinkman();
                org = userOpen.getRidgepole() + userOpen.getUnit();
            }
            //性别
            List<MsSuspected> ListMsSuspected = msReportMapper.selectGrenderUserId(userId);
            if(ListMsSuspected!=null && ListMsSuspected.size()>1)
                return;
            if (ListMsSuspected!=null && ListMsSuspected.size()==1){
                if (ListMsSuspected.get(0).getGrender() == 1)
                    gander = "男";
                if (ListMsSuspected.get(0).getGrender() == 2)
                    gander = "女";
            }

            //返回时间
            MsReport msReport = msReportMapper.selectBackTripByUserId(userId);
            if (msReport != null) {
                SimpleDateFormat sj = new SimpleDateFormat("yyyy-MM-dd");
                backDate = sj.format(msReport.getReportDate());
                bAddr = msReportService.getLocalOther(msReport.getTodayLocal(), msReport.getTodayLocalOther());
            }
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("userName", userName);
            map.put("gander", gander);
            map.put("org", org);
            map.put("bAddr", bAddr);
            map.put("backDate", backDate);

            //最近15天体温
            Map<String, Object> rt = new HashMap<String, Object>();
            map.put("rt", rt);
            for (int i = 1; i <= 15; i++) {
                rt.put("d" + i, msReportService.getTimeByDate(i - 15));
                rt.put("t" + i, msReportService.getTemperature(userId, i - 15));
            }

            List<MsSuspected> listSuspected1 = msReportMapper.selectOtherSymptomByReportrId(userId);
            if (listSuspected1 != null && listSuspected1.size() > 0)
                otherSymptom = "是";
            else
                otherSymptom = "否";
            map.put("otherSymptom", otherSymptom);
            list.add(map);
        }

        WordUtils.exportWord("word/隔离人员解除隔离审批表_20200221.docx", "temp", "隔离人员解除隔离审批表.docx", list, request, response);
    }
}