package com.hxzk.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.github.pagehelper.PageInfo;
import com.hxzk.pojo.TbAchor;
import com.hxzk.pojo.TbGpsTrack;
import com.hxzk.pojo.TbTrackGps;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface GpsTrackDao extends BaseMapper<TbGpsTrack> {

    @Select("select * from tb_gps_track_${time} limit 0,1000")
    List<TbGpsTrack> findAll(String time);

    @Select("select * from tb_gps_track_${time} where tagid = ${tagid}")
    List<TbGpsTrack> findAllSearch(@Param("time") String time, @Param("tagid") String tagid);


    @Select("SELECT t.tagid,t.x,t.y,t.z,t.layer,t.time,t.baoliu1,t.baoliu2,t.baoliu3,t.baoliu4,t.baoliu5,t.baoliu6,t.baoliu7,t.baoliu8,t.baoliu9,p.p_image AS image FROM tb_track_${now2} t JOIN tb_person p ON p.p_tagid = t.tagid where t.layer = ${floor} and t.tagid = ${tag_id} and t.time>= '${begin_time}' and t.time <= '${end_time}'")
    List<TbTrackGps> getTagtrack(@Param("tag_id")String tag_id, @Param("begin_time")String begin_time, @Param("end_time")String end_time, @Param("floor")String floor,@Param("now2")String now2);
}