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 org.springframework.security.core.parameters.P;
|
|
import java.util.List;
|
|
public interface GpsTrackDao extends BaseMapper<TbGpsTrack> {
|
|
@Select("select * from tb_gps_track_${time} limit #{page},1000")
|
List<TbGpsTrack> findAll(@Param("time")String time,@Param("page")Integer page,@Param("limit")Integer limit);
|
@Select("select count(*) from tb_gps_track_${time}")
|
Integer selectCounts(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);
|
}
|
