package com.hxzk.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.hxzk.deo.GpsGuiJi;
|
import com.hxzk.pojo.TbGpsTrack;
|
import com.hxzk.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 time);
|
|
@Select("select g.tagid,g.gps_haiba_gao,g.gps_state,g.gps_power,g.addtime,g.gsp_jingdu,g.gps_weidu,p.p_name as name from tb_gps_track_${now} g inner join tb_person p on p.p_tagid=g.tagid where g.tagid = #{tagid} and g.addtime >= #{time2} and g.addtime <= #{time3} ")
|
List<GpsGuiJi> findGpsGuiJi(@Param("tagid") String tagid, @Param("now")String now, @Param("time2")String time2, @Param("time3")String time3);
|
}
|
