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 var1, @Param("begin_time") String var2, @Param("end_time") String var3, @Param("floor") String var4, @Param("now2") String var5);



    @Select("SELECT id,tagid,gps_utc_time,gps_weidu,gsp_jingdu,gps_state,gps_hdop,gps_num,gps_chafen_time,gps_haiba_gao,tagid,gps_power,addtime FROM tb_gps_track_${datte} WHERE tagid = #{tagid} limit #{page},1000 ")
    List<TbGpsTrack> findJingWeiSearch(@Param("tagid") String tagid, @Param("datte") String datte,@Param("page")Integer page);

    @Select("SELECT COUNT(id) FROM tb_gps_track_${track} WHERE tagid = #{tagid} and ADDTIME LIKE #{dates}")
    public Integer findCountJw(@Param("dates") String dates,@Param("track")String track,@Param("tagid")String tagid);

    @Select("SELECT COUNT(id) FROM tb_gps_track_${track} WHERE ADDTIME LIKE #{dates}")
    public Integer findCountJw1(@Param("dates") String dates,@Param("track")String track);


    @Select("SELECT gps_haiba_gao FROM tb_gps_track_${track} WHERE ADDTIME LIKE #{dates} AND gps_state = '高精度' AND tagid = #{tagid} limit 0,1")
    public Double findHourceCountHaiBa1(@Param("track")String track,@Param("dates")String dates,@Param("tagid")String tagid);
}