hust-epi/whepi-web/src/main/java/com/bofeng/service/MsReportService.java

package com.bofeng.service;


import com.baomidou.mybatisplus.toolkit.IdWorker;
import com.bofeng.dao.*;
import com.bofeng.entity.*;
import com.yvan.platform.Conv;
import io.swagger.models.auth.In;
import javassist.expr.NewArray;
import org.apache.commons.lang3.tuple.Triple;
import org.joda.time.DateTime;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.servlet.ModelAndView;

import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * @Author: xielianghe
 * @Date: 2020/2/4 15:44
 */
@Service
@Transactional()
public class MsReportService {

    @Autowired
    private MsSuspectedMapper msSuspectedMapper;
    @Autowired
    private MsReportMapper msReportMapper;
    @Autowired
    private MsReportService msReportService;
    @Autowired
    private MsTripDetMapper msTripDetMapper;
    @Autowired
    private MsTripMapper msTripMapper;
    @Autowired
    private UptownUnitMapper uptownUnitMapper;

    public List<MsSuspected> getByReportId(Long reportId) {
        List<MsSuspected> listSuspected = null;
        listSuspected = msSuspectedMapper.selectByReportId(reportId);
        if (listSuspected != null && listSuspected.size() > 0) {
            String tripDet;
            for (MsSuspected msSuspected : listSuspected) {
                tripDet = "";
                //出行详细
                List<MsTripDet> listDet = msSuspectedMapper.selectTripSuspected(msSuspected.getSuspectedId());
                if (listDet != null && listDet.size() > 0) {
                    for (MsTripDet msTripDet : listDet) {
                        tripDet += "出发地：" + getLocalOther(msTripDet.getStartLocal(), msTripDet.getStartLocalOther()) + ",";
                        tripDet += "目的地：" + getLocalOther(msTripDet.getEndLocal(), msTripDet.getEndLocalOther()) + ",";
                        tripDet += "出行方式：" + getTripType(msTripDet.getTripType()) + ",";
                        tripDet += "车次/航班/车牌：" + msTripDet.getTripTypeDesp() + ",";
                    }
                    msSuspected.setTripDet(tripDet.substring(0, tripDet.length() - 1));
                }
            }

        }
        return listSuspected;
    }

    public MsReport getByReport(Long reportId) {
        return msReportMapper.selectById(reportId);
    }

    //获取前一天数据
    public List<MsSuspected> getByReportReportDate(String reportDate, Long userCreate) {
        List<MsReport> listReport = msReportMapper.selectByReportDate(reportDate, userCreate);
        List<MsSuspected> listSuspected = null;
        if (listReport != null && listReport.size() > 0) {
            listSuspected = msSuspectedMapper.selectByReportId(Long.parseLong(listReport.get(0).getReportId().toString()));
            if (listSuspected != null && listSuspected.size() > 0) {
                String tripDet;
                for (MsSuspected msSuspected : listSuspected) {
                    tripDet = "";
                    //出行详细
                    List<MsTripDet> listDet = msSuspectedMapper.selectTripSuspected(msSuspected.getSuspectedId());
                    if (listDet != null && listDet.size() > 0) {
                        for (MsTripDet msTripDet : listDet) {
                            tripDet += "出发地：" + getLocalOther(msTripDet.getStartLocal(), msTripDet.getStartLocalOther()) + ",";
                            tripDet += "目的地：" + getLocalOther(msTripDet.getEndLocal(), msTripDet.getEndLocalOther()) + ",";
                            tripDet += "出行方式：" + getTripType(msTripDet.getTripType()) + ",";
                            tripDet += "车次/航班/车牌：" + msTripDet.getTripTypeDesp() + ",";
                        }
                        msSuspected.setTripDet(tripDet.substring(0, tripDet.length() - 1));
                    }
                }

            }
        }
        return listSuspected;
    }

    //获取日历前一天数据
    public List<MsSuspected> getByReportReportDateStatus(String reportDate, Long userCreate) {
        List<MsReport> listReport = msReportMapper.selectByReportDateStatus(reportDate, userCreate);
        List<MsSuspected> listSuspected = null;
        if (listReport != null && listReport.size() > 0) {
            listSuspected = msSuspectedMapper.selectByReportId(Long.parseLong(listReport.get(0).getReportId().toString()));
            if (listSuspected != null && listSuspected.size() > 0) {
                String tripDet;
                for (MsSuspected msSuspected : listSuspected) {
                    tripDet = "";
                    //出行详细
                    List<MsTripDet> listDet = msSuspectedMapper.selectTripSuspected(msSuspected.getSuspectedId());
                    if (listDet != null && listDet.size() > 0) {
                        for (MsTripDet msTripDet : listDet) {
                            tripDet += "出发地：" + getLocalOther(msTripDet.getStartLocal(), msTripDet.getStartLocalOther()) + ",";
                            tripDet += "目的地：" + getLocalOther(msTripDet.getEndLocal(), msTripDet.getEndLocalOther()) + ",";
                            tripDet += "出行方式：" + getTripType(msTripDet.getTripType()) + ",";
                            tripDet += "车次/航班/车牌：" + msTripDet.getTripTypeDesp() + ",";
                        }
                        msSuspected.setTripDet(tripDet.substring(0, tripDet.length() - 1));
                    }
                }

            }
        }
        return listSuspected;
    }

    public String getLocalOther(Integer local, String localOther) {
        String localDet = "";
        if (local == 1) {
            localDet = "武汉市";
        } else if (local == 2)
            localDet = "宜昌市";
        else if (local == 3)
            localDet = "当阳市";
        else if (local == 4)
            localDet = "其它地点_" + localOther;
        return localDet;
    }

    public String getTripType(Integer tripType) {
        String tripTypeDet = "";
        if (tripType == 1) {
            tripTypeDet = "长途汽车";
        } else if (tripType == 2)
            tripTypeDet = "火车";
        else if (tripType == 3)
            tripTypeDet = "飞机";
        else if (tripType == 4)
            tripTypeDet = "自驾";
        return tripTypeDet;
    }

    //获取今天数据
    public MsReport getReportByDateNow(Long userCreate) {
        //根据昨天的获取今天的
        //msReportService.getNowByYesterday(userCreate);
        //msReportService.getNowByYesterdayDate();
        //msReportService.addReport250();
        Date t = new Date();
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        String reportDate = df.format(t);
        List<MsReport> listReport = msReportMapper.selectByReportDate(reportDate, userCreate);
        MsReport msReport = new MsReport();
        //今天不存在
        if (listReport == null || listReport.size() == 0) {
            //最近一天数据复制到今天
            msReportService.getNowByNextDat(userCreate);
            List<MsReport> listReport1 = msReportMapper.selectByReportDate(reportDate, userCreate);
            //今天不存在
            if (listReport1 != null && listReport1.size() > 0)
                msReport = msReportMapper.selectById(Long.parseLong(listReport1.get(0).getReportId().toString()));
        } else {

            msReport = msReportMapper.selectById(Long.parseLong(listReport.get(0).getReportId().toString()));
        }
        return msReport;
    }

    //上报
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public Integer addReport(Long userCreate) {
        Date t = new Date();
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        String reportDate = df.format(t);
        List<MsReport> listReport = msReportMapper.selectByReportDate(reportDate, userCreate);
        if (listReport == null || listReport.size() == 0)
            return 0;

        //判断体温是否填写
        List<MsSuspected> listSuspected = msSuspectedMapper.selectByReportId(Long.parseLong(listReport.get(0).getReportId().toString()));
        if (listSuspected == null || listSuspected.size() == 0)
            return 3;
            // if (unit != null) {
            //     if (unit.getUptownId() == 1238790987234L || unit.getUptownId() == 5) {
            //         if (listSuspected != null && listSuspected.size() > 1)
            //             return 5;
            //     }
            // }
        else {
            for (MsSuspected msSuspected : listSuspected) {
                //体温是否填写
                if (msSuspected.getTemperature().compareTo(new BigDecimal(0)) == 0)
                    return 2;

                //如果是凌云，判断出行是否填写异常
                UptownUnit unit = uptownUnitMapper.getUptownUnitByUser(userCreate);
                if (unit != null) {
                    if (unit.getUptownId() == 1238790987234L || unit.getUptownId() == 5) {
                        //上一天的上报记录.3天内
                        List<MsSuspected> listSuspected1 = msSuspectedMapper.selectNext3Suspected(userCreate);
                        if (listSuspected1 != null && listSuspected1.size() == 1) {
                            if (listSuspected1.get(0).getTodayLocal() != null && msSuspected.getTodayLocal() != null && msSuspected.getIsTrip() != null && listSuspected1.get(0).getTodayLocal() != 0 && msSuspected.getTodayLocal() != 0) {
                                if (listSuspected1.get(0).getTodayLocalOther() != msSuspected.getTodayLocalOther() && listSuspected1.get(0).getTodayLocal() != msSuspected.getTodayLocal() && msSuspected.getIsTrip() == 0) {
                                    return 4;
                                }
                            }
                        }

                    }
                }
            }

        }
        MsReport msReport = msReportMapper.selectById(Long.parseLong(listReport.get(0).getReportId().toString()));
        if (msReport != null) {
            msReport.setReportStatus(1);
            msReport.setUserUpdate(userCreate);
            msReport.setTimeUpdate(DateTime.now());
            msReportMapper.updateById(msReport);
        }
        return 1;
    }

    //ly修改上报
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public Integer addReportLy(Long reportId, Long suspectedId, Long userCreate) {
        //如果是凌云，判断出行是否填写异常
        MsTrip msTrip = msTripMapper.selectById(suspectedId);
        if (msTrip != null) {
            //上一天的上报记录.3天内
            List<MsSuspected> listSuspected1 = msSuspectedMapper.selectNext3Suspected(userCreate);
            if (listSuspected1 != null && listSuspected1.size() == 1) {
                if (listSuspected1.get(0).getTodayLocal() != null && msTrip.getTodayLocal() != null && msTrip.getIsTrip() != null && listSuspected1.get(0).getTodayLocal() != 0 && msTrip.getTodayLocal() != 0) {
                    if (listSuspected1.get(0).getTodayLocalOther() != msTrip.getTodayLocalOther() && listSuspected1.get(0).getTodayLocal() != msTrip.getTodayLocal() && msTrip.getIsTrip() == 0) {
                        return 4;
                    }
                }
            }
            MsReport msReport = msReportMapper.selectById(reportId);
            if (msReport != null) {
                msReport.setReportStatus(1);
                msReport.setUserUpdate(userCreate);
                msReport.setTimeUpdate(DateTime.now());
                msReportMapper.updateById(msReport);
            }
        }
        return 1;
    }

    //通过昨天数据更新今天数据
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public void getNowByYesterday(Long userCreate) {

        SimpleDateFormat sj = new SimpleDateFormat("yyyy-MM-dd");
        Date d = new Date();

        //判断今天是否有数据
        String DateNow = sj.format(d);
        List<MsReport> listReport = msReportMapper.selectByReportDate(DateNow, userCreate);
        if (listReport != null && listReport.size() > 0)
            return;

        //判断昨天是否有数据
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(d);
        calendar.add(Calendar.DATE, -1);
        String reportDate = sj.format(calendar.getTime());
        List<MsReport> listReport1 = msReportMapper.selectByReportDate(reportDate, userCreate);
        //有数据
        if (listReport1 != null && listReport1.size() > 0) {
            //添加到今天日报
            MsReport msReport = msReportMapper.selectById(Long.parseLong(listReport1.get(0).getReportId().toString()));
            Long reportId = 0L;
            if (msReport != null) {
                MsReport msReport1 = new MsReport();
                msReport1.setReportId(IdWorker.getId());
                msReport1.setHouseId(msReport.getHouseId());
                msReport1.setSafetyNum(msReport.getSafetyNum());
                msReport1.setSureNum(msReport.getSureNum());
                msReport1.setSuspectedNum(msReport.getSuspectedNum());
                msReport1.setNormalNum(msReport.getNormalNum());
                msReport1.setSingleNum(msReport.getSingleNum());
                msReport1.setRemarks(msReport.getRemarks());
                msReport1.setReportDate(DateTime.now().toDate());
                msReport1.setReportStatus(0);//未上报
                msReport1.setMsStatus(msReport.getMsStatus());
                msReport1.setUserCreate(userCreate);
                msReport1.setTimeCreate(DateTime.now());
                msReport1.setUserUpdate(userCreate);
                msReport1.setTimeUpdate(DateTime.now());
                msReportMapper.insert(msReport1);
                reportId = msReport1.getReportId();
            }
            //添加今日家庭
            List<MsSuspected> listSuspected = msSuspectedMapper.selectByReportId(Long.parseLong(listReport1.get(0).getReportId().toString()));
            if (listSuspected != null && listSuspected.size() > 0) {
                for (MsSuspected msSuspected : listSuspected) {
                    MsSuspected msSuspected1 = new MsSuspected();
                    msSuspected1.setSuspectedId(IdWorker.getId());
                    msSuspected1.setReportId(reportId);
                    msSuspected1.setUserName(msSuspected.getUserName());
                    msSuspected1.setGrender(msSuspected.getGrender());
                    msSuspected1.setAge(msSuspected.getAge());
                    msSuspected1.setFamilyStatus(msSuspected.getFamilyStatus());
                    msSuspected1.setStatusDesp(msSuspected.getStatusDesp());
                    msSuspected1.setMedical(msSuspected.getMedical());
                    msSuspected1.setTemperature(new BigDecimal(0));
                    msSuspected1.setCough(msSuspected.getCough());
                    msSuspected1.setMuscle(msSuspected.getMuscle());
                    msSuspected1.setDyspnea(msSuspected.getDyspnea());
                    msSuspected1.setFatigue(msSuspected.getFatigue());
                    msSuspected1.setDiarrhea(msSuspected.getDiarrhea());
                    msSuspected1.setSingleRoom(msSuspected.getSingleRoom());
                    msSuspected1.setOthers(msSuspected.getOthers());
                    // msSuspected1.setScoreRezult(msSuspected.getScoreRezult());
                    // msSuspected1.setScore(msSuspected.getScore());
                    // msSuspected1.setScoreHistroy(msSuspected.getScoreHistroy());
                    // msSuspected1.setTemperatureScore(msSuspected.getTemperatureScore());
                    msSuspected1.setSuspectedStatus(0);
                    msSuspected1.setUserCreate(userCreate);
                    msSuspected1.setTimeCreate(DateTime.now());
                    msSuspected1.setUserUpdate(userCreate);
                    msSuspected1.setTimeUpdate(DateTime.now());
                    msSuspectedMapper.insert(msSuspected1);
                }
            }
        }
    }

    //自动将用户最新的数据更新到今天
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public void getNowByYesterdayDate() {
        //每次执行100条
        Long start = 0L, count = 100L;
        while (true) {
            //今天以前一共有多少用户
            List<Long> listUser = msReportMapper.getUserByYesterdayDate(start, count);
            if (listUser != null && listUser.size() > 0) {
                for (Long userCreate : listUser) {
                    //判断用户今天是否有数据
                    SimpleDateFormat sj = new SimpleDateFormat("yyyy-MM-dd");
                    Date d = new Date();
                    String DateNow = sj.format(d);
                    List<MsReport> listReport = msReportMapper.selectByReportDate(DateNow, userCreate);
                    if (listReport != null && listReport.size() > 0)
                        continue;
                    //查询改用户今天以前的最近一条记录
                    List<MsReport> listReport1 = msReportMapper.getNowByYesterdayDate(userCreate);
                    if (listReport1 != null && listReport1.size() > 0) {
                        for (MsReport msReport : listReport1) {
                            if (msReport != null) {
                                //添加日报
                                MsReport msReport1 = new MsReport();
                                msReport1.setReportId(IdWorker.getId());
                                msReport1.setHouseId(msReport.getHouseId());
                                msReport1.setSafetyNum(msReport.getSafetyNum());
                                msReport1.setSureNum(msReport.getSureNum());
                                msReport1.setSuspectedNum(msReport.getSuspectedNum());
                                msReport1.setNormalNum(msReport.getNormalNum());
                                msReport1.setSingleNum(msReport.getSingleNum());
                                msReport1.setRemarks(msReport.getRemarks());
                                msReport1.setReportDate(DateTime.now().toDate());
                                msReport1.setReportStatus(0);//未上报
                                msReport1.setMsStatus(msReport.getMsStatus());
                                msReport1.setUserCreate(msReport.getUserCreate());
                                msReport1.setTimeCreate(DateTime.now());
                                msReport1.setUserUpdate(msReport.getUserCreate());
                                msReport1.setTimeUpdate(DateTime.now());
                                msReportMapper.insert(msReport1);
                                //添加家人
                                List<MsSuspected> listSuspected = msSuspectedMapper.selectByReportId(msReport.getReportId());
                                if (listSuspected != null && listSuspected.size() > 0) {
                                    for (MsSuspected msSuspected : listSuspected) {
                                        MsSuspected msSuspected1 = new MsSuspected();
                                        msSuspected1.setSuspectedId(IdWorker.getId());
                                        msSuspected1.setReportId(msReport1.getReportId());
                                        msSuspected1.setUserName(msSuspected.getUserName());
                                        msSuspected1.setGrender(msSuspected.getGrender());
                                        msSuspected1.setAge(msSuspected.getAge());
                                        msSuspected1.setFamilyStatus(msSuspected.getFamilyStatus());
                                        msSuspected1.setStatusDesp(msSuspected.getStatusDesp());
                                        msSuspected1.setMedical(msSuspected.getMedical());
                                        msSuspected1.setTemperature(new BigDecimal(0));//温度0
                                        msSuspected1.setCough(msSuspected.getCough());
                                        msSuspected1.setMuscle(msSuspected.getMuscle());
                                        msSuspected1.setDyspnea(msSuspected.getDyspnea());
                                        msSuspected1.setFatigue(msSuspected.getFatigue());
                                        msSuspected1.setDiarrhea(msSuspected.getDiarrhea());
                                        msSuspected1.setSingleRoom(msSuspected.getSingleRoom());
                                        msSuspected1.setOthers(msSuspected.getOthers());
                                        // msSuspected1.setScoreRezult(msSuspected.getScoreRezult());
                                        // msSuspected1.setScore(msSuspected.getScore());
                                        // msSuspected1.setScoreHistroy(msSuspected.getScoreHistroy());
                                        // msSuspected1.setTemperatureScore(msSuspected.getTemperatureScore());
                                        msSuspected1.setSuspectedStatus(0);
                                        msSuspected1.setUserCreate(msSuspected.getUserCreate());
                                        msSuspected1.setTimeCreate(DateTime.now());
                                        msSuspected1.setUserUpdate(msSuspected.getUserUpdate());
                                        msSuspected1.setTimeUpdate(DateTime.now());
                                        msSuspectedMapper.insert(msSuspected1);
                                    }
                                }
                            }
                        }
                    }
                }
            }
            start += count;
            if (listUser == null || listUser.size() < count) {
                break;
            }
        }
    }

    //添加250条记录
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public void addReport250() {
        //每次执行100条
        Long count = 0L;
        while (true) {
            //添加日报
            MsReport msReport1 = new MsReport();
            msReport1.setReportId(IdWorker.getId());
            msReport1.setHouseId(0L);
            msReport1.setSafetyNum(0);
            msReport1.setSureNum(0);
            msReport1.setSuspectedNum(0);
            msReport1.setNormalNum(0);
            msReport1.setSingleNum(0);
            msReport1.setRemarks("");
            msReport1.setReportDate(DateTime.now().toDate());
            msReport1.setReportStatus(0);//未上报
            msReport1.setMsStatus(0);
            msReport1.setUserCreate(count);
            msReport1.setTimeCreate(DateTime.now());
            msReport1.setUserUpdate(count);
            msReport1.setTimeUpdate(DateTime.now());
            count += msReportMapper.insert(msReport1);
            if (count > 250) {
                break;
            }
        }
    }


    //通过最近一天数据更新今天数据
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public void getNowByNextDat(Long userCreate) {

        SimpleDateFormat sj = new SimpleDateFormat("yyyy-MM-dd");
        Date d = new Date();

        //判断今天是否有数据
        String DateNow = sj.format(d);
        List<MsReport> listReport = msReportMapper.selectByReportDate(DateNow, userCreate);
        if (listReport != null && listReport.size() > 0)
            return;

        UptownUnit unit = uptownUnitMapper.getUptownUnitByUser(userCreate);

        //判断最近一天是否有数据
        List<MsSuspected> listSuspected = msSuspectedMapper.selectNextSuspected(userCreate);
        //有数据
        if (listSuspected != null && listSuspected.size() > 0) {
            //添加到今天日报
            MsReport msReport = msReportMapper.selectById(Long.parseLong(listSuspected.get(0).getReportId().toString()));
            Long reportId = 0L;
            Long houseId = 0L;
            if (msReport != null) {
                MsReport msReport1 = new MsReport();
                msReport1.setReportId(IdWorker.getId());
                if (msReport.getHouseId().longValue() == 0L)
                    houseId = msReportMapper.selectHouseIdByUserId(userCreate);
                else
                    houseId = msReport.getHouseId();
                msReport1.setHouseId(houseId);
                msReport1.setSafetyNum(msReport.getSafetyNum());
                msReport1.setSureNum(msReport.getSureNum());
                msReport1.setSuspectedNum(msReport.getSuspectedNum());
                msReport1.setNormalNum(msReport.getNormalNum());
                msReport1.setSingleNum(msReport.getSingleNum());
                msReport1.setRemarks(msReport.getRemarks());
                msReport1.setReportDate(DateTime.now().toDate());
                msReport1.setReportStatus(0);//未上报
                msReport1.setMsStatus(msReport.getMsStatus());
                msReport1.setUserCreate(userCreate);
                msReport1.setTimeCreate(DateTime.now());
                msReport1.setUserUpdate(userCreate);
                msReport1.setTimeUpdate(DateTime.now());
                msReportMapper.insert(msReport1);
                reportId = msReport1.getReportId();
            }
            //添加今日家人
            for (MsSuspected msSuspected : listSuspected) {
                MsSuspected msSuspected1 = new MsSuspected();
                msSuspected1.setSuspectedId(IdWorker.getId());
                msSuspected1.setReportId(reportId);
                msSuspected1.setUserName(msSuspected.getUserName());
                msSuspected1.setGrender(msSuspected.getGrender());
                msSuspected1.setAge(msSuspected.getAge());
                msSuspected1.setFamilyStatus(msSuspected.getFamilyStatus());
                msSuspected1.setStatusDesp(msSuspected.getStatusDesp());
                msSuspected1.setMedical(msSuspected.getMedical());
                msSuspected1.setTemperature(new BigDecimal(0));
                msSuspected1.setCough(msSuspected.getCough());
                msSuspected1.setMuscle(msSuspected.getMuscle());
                msSuspected1.setDyspnea(msSuspected.getDyspnea());
                msSuspected1.setFatigue(msSuspected.getFatigue());
                msSuspected1.setDiarrhea(msSuspected.getDiarrhea());
                //如果是凌云的，不需要复制单间隔离
                if (unit != null) {
                    if (unit.getUptownId() == 1238790987234L || unit.getUptownId() == 5)
                        msSuspected1.setSingleRoom(0);
                } else
                    msSuspected1.setSingleRoom(msSuspected.getSingleRoom());
                msSuspected1.setOthers(msSuspected.getOthers());
                // msSuspected1.setScoreRezult(msSuspected.getScoreRezult());
                // msSuspected1.setScore(msSuspected.getScore());
                // msSuspected1.setScoreHistroy(msSuspected.getScoreHistroy());
                // msSuspected1.setTemperatureScore(msSuspected.getTemperatureScore());
                msSuspected1.setIsContact(msSuspected.getIsContact());
                msSuspected1.setSuspectedStatus(0);
                msSuspected1.setUserCreate(userCreate);
                msSuspected1.setTimeCreate(DateTime.now());
                msSuspected1.setUserUpdate(userCreate);
                msSuspected1.setTimeUpdate(DateTime.now());
                msSuspectedMapper.insert(msSuspected1);

                //添加行程
                MsTrip msTrip = new MsTrip();
                msTrip.setTripId(msSuspected1.getSuspectedId());
                msTrip.setIsTrip(0);
                msTrip.setTodayLocal(msSuspected.getTodayLocal());
                msTrip.setTodayLocalOther(msSuspected.getTodayLocalOther());
                msTrip.setWorkLocal(msSuspected.getWorkLocal());
                msTrip.setWorkLocalOther(msSuspected.getWorkLocalOther());
                msTripMapper.insert(msTrip);

                //添加出行详细
                // List<MsTripDet> listTripDet = msSuspectedMapper.selectTripSuspected(msSuspected.getSuspectedId());
                // if (listTripDet != null && listTripDet.size() > 0) {
                //     for (MsTripDet msTripDet : listTripDet) {
                //         MsTripDet msTripDet1 = new MsTripDet();
                //         msTripDet1.setTripDetId(IdWorker.getId());
                //         msTripDet1.setTripId(msSuspected1.getSuspectedId());
                //         msTripDet1.setSort(msTripDet.getSort());
                //         msTripDet1.setStartLocal(msTripDet.getStartLocal());
                //         msTripDet1.setStartLocalOther(msTripDet.getStartLocalOther());
                //         msTripDet1.setEndLocal(msTripDet.getEndLocal());
                //         msTripDet1.setEndLocalOther(msTripDet.getEndLocalOther());
                //         msTripDet1.setTripType(msTripDet.getTripType());
                //         msTripDet1.setTripTypeDesp(msTripDet.getTripTypeDesp());
                //         msTripDet1.setTimeCreate(DateTime.now());
                //         msTripDet1.setUserCreate(userCreate);
                //         msTripDet1.setTimeUpdate(DateTime.now());
                //         msTripDet1.setUserUpdate(userCreate);
                //         msTripDetMapper.insert(msTripDet1);
                //     }
                // }
            }
        }
    }


    //获取时间
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public String getTimeByDate(Integer numdate) {
        String reportDate = "";
        SimpleDateFormat sj = new SimpleDateFormat("yyyy-MM-dd");
        Date d = new Date();
        if (numdate == 0) {
            reportDate = sj.format(d);
        } else {
            Calendar calendar = Calendar.getInstance();
            calendar.setTime(d);
            calendar.add(Calendar.DATE, numdate);
            reportDate = sj.format(calendar.getTime());
        }
        return reportDate;
    }

    //获取温度
    @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED)
    public String getTemperature(Long userId, Integer numdate) {
        String temperature = "-";
        MsSuspected msSuspected = msReportMapper.select5ByReportrId(userId, getTimeByDate(numdate));
        if (msSuspected != null)
            temperature = msSuspected.getTemperature().toString();
        return temperature;
    }


    //后台专用
    public List<MsReport> getByReportReportDateTest(Long userCreate, Map<String, Object> queryParam) {
        Map<String, Object> mm = queryParam;
        queryParam.put("userCreate", userCreate);
        return msReportMapper.selectByReportDateTest(queryParam);
    }

    public List<MsSuspected> getByReportReportDateTestxq(Map<String, Object> queryParam) {
        List<MsSuspected> msReports = msReportMapper.selectByReportDateTestxq(queryParam);
        if (msReports.size() != 0) {
            for (int i = 0; i < msReports.size(); i++) {
                if (msReports.get(i).getWorkLocal() == 1) {
                    msReports.get(i).setWorkLocalOtherStr("武汉市");
                } else if (msReports.get(i).getWorkLocal() == 2) {
                    msReports.get(i).setWorkLocalOtherStr("宜昌市");
                } else if (msReports.get(i).getWorkLocal() == 3) {
                    msReports.get(i).setWorkLocalOtherStr("当阳市");
                }
                if (msReports.get(i).getTodayLocal() == 1) {
                    msReports.get(i).setTodayLocalOtherStr("武汉市");
                } else if (msReports.get(i).getTodayLocal() == 2) {
                    msReports.get(i).setTodayLocalOtherStr("宜昌市");
                } else if (msReports.get(i).getTodayLocal() == 3) {
                    msReports.get(i).setTodayLocalOtherStr("当阳市");
                }

                if (msReports.get(i).getEndLocal() != null) {
                    if (msReports.get(i).getEndLocal() == 1) {
                        msReports.get(i).setEndLocalOtherStr("武汉市");
                    } else if (msReports.get(i).getEndLocal() == 2) {
                        msReports.get(i).setEndLocalOtherStr("宜昌市");
                    } else if (msReports.get(i).getEndLocal() == 3) {
                        msReports.get(i).setEndLocalOtherStr("当阳市");
                    }
                }
                if (msReports.get(i).getStartLocal() != null) {
                    if (msReports.get(i).getStartLocal() == 1) {
                        msReports.get(i).setStartLocalOtherStr("武汉市");
                    } else if (msReports.get(i).getStartLocal() == 2) {
                        msReports.get(i).setStartLocalOtherStr("宜昌市");
                    } else if (msReports.get(i).getStartLocal() == 3) {
                        msReports.get(i).setStartLocalOtherStr("当阳市");
                    }
                }

            }
        }
        return msReports;
    }

    //统计LY异常情况
    public List<MsReport> getByReportSuspected() throws ParseException {
        //获取所有的ly人员
        List<MsReport> list = msReportMapper.selectByReportSuspected();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        SimpleDateFormat s = new SimpleDateFormat("yyyy-MM-dd");
        List<MsReport> listReport = new ArrayList<>();
        if (list != null && list.size() > 0) {
            for (MsReport msReport : list) {
                //是否确诊
                Integer isSure = msReportMapper.selectNum(msReport.getUserId(), 1) > 0 ? 1 : 0;
                //是否疑似
                Integer isSuspected = msReportMapper.selectNum(msReport.getUserId(), 2) > 0 ? 1 : 0;
                //是否有异常症状
                String isSymptom = "";
                List<MsSuspected> listSuspected = msReportMapper.selectSymptomNum(msReport.getUserId());
                if (listSuspected != null && listSuspected.size() > 0) {
                    for (MsSuspected msSuspected : listSuspected) {
                        isSymptom += s.format(msSuspected.getReportDate().getTime()) + ",";
                        if (Conv.NFloat(msSuspected.getTemperature()) < Conv.NFloat(35) || Conv.NFloat(msSuspected.getTemperature()) > Conv.NFloat(37.3))
                            isSymptom += "体温：异常,";
                        if (msSuspected.getCough() > 0)
                            isSymptom += "咳嗽现象：" + getCough(msSuspected.getCough()) + ",";
                        if (msSuspected.getMuscle() > 0)
                            isSymptom += "肌肉酸痛：" + getMuscle(msSuspected.getMuscle()) + ",";
                        if (msSuspected.getDyspnea() > 0)
                            isSymptom += "呼吸困难：" + getDyspnea(msSuspected.getDyspnea()) + ",";
                        if (msSuspected.getFatigue() > 0)
                            isSymptom += "乏力现象：" + getFatigue(msSuspected.getFatigue()) + ",";
                        if (msSuspected.getDiarrhea() > 0)
                            isSymptom += "腹泻现象：" + getDiarrhea(msSuspected.getDiarrhea()) + ",";
                    }
                }
                //是否有接触史
                Integer isContact = msReportMapper.selectNum(msReport.getUserId(), 3) > 0 ? 1 : 0;
                //家人是否有接触史
                Integer isFamliyContact = msReportMapper.selectFamilyContactNum(msReport.getUserId()) > 0 ? 1 : 0;
                //异地返工
                Integer isWork = 0;
                String returnWork = msReportMapper.returnWork(msReport.getUserId());
                if (returnWork != null) {
                    if (sdf.parse(returnWork + " 00:00:00").getTime() + 1000L * 3600 * 24 * 15 > sdf.parse(s.format(new Date()) + " 00:00:00").getTime()) {
                        isWork = 1;
                    }
                }
                //判断只要存在一种情况，就写进数据库
                if (isSure > 0 || isSuspected > 0 || isSymptom != "" || isContact > 0 || isFamliyContact > 0 || isWork > 0) {
                    msReport.setIsSure(isSure);
                    msReport.setIsSuspected(isSuspected);
                    msReport.setIsSymptom(isSymptom);
                    msReport.setIsContact(isContact);
                    msReport.setIsFamliyContact(isFamliyContact);
                    msReport.setIsWork(isWork);
                    listReport.add(msReport);
                }
            }
        }
        return listReport;
    }

    public String getCough(Integer cough) {
        if (cough == 0)
            return "无咳嗽";
        else if (cough == 1)
            return "偶尔短暂咳嗽";
        else if (cough == 2)
            return "咳嗽轻度影响生活";
        else if (cough == 3)
            return "咳嗽严重影响生活";
        return "";
    }

    public String getMuscle(Integer muscle) {
        if (muscle == 0)
            return "无";
        else if (muscle == 1)
            return "按压有";
        else if (muscle == 2)
            return "偶尔";
        else if (muscle == 3)
            return "持续有";
        return "";
    }

    public String getDyspnea(Integer dyspnea) {
        if (dyspnea == 0)
            return "无";
        else if (dyspnea == 1)
            return "急走或上坡气短";
        else if (dyspnea == 2)
            return "气短而走路变慢";
        else if (dyspnea == 3)
            return "走路数分钟后气短";
        else if (dyspnea == 4)
            return "气短无法离开房间";
        return "";
    }

    public String getFatigue(Integer fatigue) {
        if (fatigue == 0)
            return "无";
        else if (fatigue == 1)
            return "体力劳动后不能恢复";
        else if (fatigue == 2)
            return "轻体力活非常累";
        else if (fatigue == 3)
            return "不能正常生活";
        return "";
    }


    public String getDiarrhea(Integer diarrhea) {
        if (diarrhea == 0)
            return "无";
        else if (diarrhea == 1)
            return "轻度腹泻(少于3次)";
        else if (diarrhea == 2)
            return "中度腹泻(4-6次)";
        else if (diarrhea == 3)
            return "重度腹泻(超过6次)";
        return "";
    }

}