//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by FernFlower decompiler)
//

package com.hxzkappboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
//import com.hxzk.deo.GpsGuiJi;
//import com.hxzk.pojo.TbGuiJiTrack;
import com.hxzkappboot.pojo.GpsGuiJi;
import com.hxzkappboot.pojo.TbGuiJiTrack;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface GpsGuiJiDao extends BaseMapper<TbGuiJiTrack> {
//    @Select({"select * from tb_track_${time} limit 0,1000"})
//    List<TbGuiJiTrack> findAll(String var1);

    @Select({"${value}"})
    List<GpsGuiJi> findGpsGuiJi(@Param("value") String var1, @Param("tag_id") String var2, @Param("time2") String var3, @Param("time3") String var4);

    @Select({"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_${now} t JOIN tb_person p ON p.p_tagid = t.tagid where  t.baoliu8 = '${tag_id}' and t.time>= '${time2}' and t.time <= '${time3}' and t.layer = '${layer}'  or t.tagid = '${tag_id}' and t.time>= '${time2}' and t.time <= '${time3}' and t.layer = '${layer}'  "})
    List<GpsGuiJi> findGpsGuiJiFloor(@Param("tag_id") String var1, @Param("time2") String var2, @Param("time3") String var3, @Param("now") String var4, @Param("layer") String var5);
}