package com.hxzkappboot.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.github.pagehelper.PageInfo;
//import com.hxzk.deo.GpsGuiJi;
//import com.hxzk.mapper.GpsGuiJiDao;
//import com.hxzk.pojo.TbGuiJiTrack;
//import com.hxzk.service.GpsGuiJiService;
import com.hxzkappboot.mapper.GpsGuiJiDao;
import com.hxzkappboot.pojo.GpsGuiJi;
import com.hxzkappboot.pojo.TbGuiJiTrack;
import com.hxzkappboot.service.GpsGuiJiService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

@Service
public class GpsGuiJiServiceImpl extends ServiceImpl<GpsGuiJiDao, TbGuiJiTrack>implements GpsGuiJiService {
    @Autowired
    GpsGuiJiDao gpsGuiJiDao;
//    @Override
//    public PageInfo<TbGuiJiTrack> findAll(Integer page, Integer limit, String time) {
//        List<TbGuiJiTrack> gps = gpsGuiJiDao.findAll(time);
//        PageInfo<TbGuiJiTrack> info = new PageInfo<>(gps);
//        return info;
//    }

    public List<GpsGuiJi> findGuiJi(String tagid, String time2, String time3) throws ParseException {
        SimpleDateFormat inputFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        SimpleDateFormat outputFormat = new SimpleDateFormat("yyyyMMdd");
        Date date2 = inputFormat.parse(time2);
        Date date3 = inputFormat.parse(time3);
        String formattedTime2 = outputFormat.format(date2);
        String formattedTime3 = outputFormat.format(date3);
        boolean isCrossDay = !formattedTime2.equals(formattedTime3);
        String start;
        if (isCrossDay) {
            start = "SELECT t.tagid, layer, t.baoliu2 AS gspJingdu, t.baoliu3 AS gpsWeidu, t.z AS gpsHaibaGao, t.time AS addtime, t.baoliu1, t.baoliu2, t.baoliu3, t.baoliu4, t.baoliu5, t.baoliu6, t.baoliu7, t.baoliu8 AS name, t.baoliu9 FROM tb_track_" + formattedTime2 + " t WHERE (t.baoliu8 = '" + tagid + "' OR t.tagid = '" + tagid + "') AND t.time >= '" + time2 + "' UNION ALL SELECT t.tagid, layer, t.baoliu2 AS gspJingdu, t.baoliu3 AS gpsWeidu, t.z AS gpsHaibaGao, t.time AS addtime, t.baoliu1, t.baoliu2, t.baoliu3, t.baoliu4, t.baoliu5, t.baoliu6, t.baoliu7, t.baoliu8 AS name, t.baoliu9 FROM tb_track_" + formattedTime3 + " t WHERE (t.baoliu8 = '" + tagid + "' OR t.tagid = '" + tagid + "') AND t.time <= '" + time3 + "'";
        } else {
            start = "SELECT t.tagid, layer, t.baoliu2 AS gspJingdu, t.baoliu3 AS gpsWeidu, t.z AS gpsHaibaGao, t.time AS addtime, t.baoliu1, t.baoliu2, t.baoliu3, t.baoliu4, t.baoliu5, t.baoliu6, t.baoliu7, t.baoliu8 AS name, t.baoliu9 FROM tb_track_" + formattedTime2 + " t WHERE (t.baoliu8 = '" + tagid + "' OR t.tagid = '" + tagid + "') AND t.time >= '" + time2 + "' AND t.time <= '" + time3 + "'";
        }

        return this.gpsGuiJiDao.findGpsGuiJi(start, tagid, time2, time3);
    }

    public List<GpsGuiJi> findGuiJiFloor(String tagid, String time2, String time3, String layer) throws ParseException {
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        Date now = dateFormat.parse(time2);
        SimpleDateFormat dateFormat2 = new SimpleDateFormat("yyyyMMdd");
        String now2 = dateFormat2.format(now);
        return this.gpsGuiJiDao.findGpsGuiJiFloor(tagid, time2, time3, now2, layer);
    }
}