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 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 java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * @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() > 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;
    }

    //通过昨天数据更新今天数据
    @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.setDiarrhea(msSuspected.getDiarrhea());
                    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.setDiarrhea(msSuspected.getDiarrhea());
                                        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;
            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();
            }
            //添加今日家人
            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.setDiarrhea(msSuspected.getDiarrhea());
                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.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(msSuspected.getIsTrip());
                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;
    }
}