//
|
// Source code recreated from a .class file by IntelliJ IDEA
|
// (powered by FernFlower decompiler)
|
//
|
|
package com.hxzk.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.hxzk.deo.GpsGuiJi;
|
import com.hxzk.pojo.TbGuiJiTrack;
|
import java.util.List;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
public interface GpsGuiJiDao extends BaseMapper<TbGuiJiTrack> {
|
@Select({"select * from tb_track_${time} limit 0,1000"})
|
List<TbGuiJiTrack> findAll(String var1);
|
@Select("${value}") // 动态接收 SQL 字符串
|
List<GpsGuiJi> findGpsGuiJi(@Param("value") String dynamicSql, @Param("tag_id") String tagId, @Param("time2") String time2, @Param("time3") String time3);
|
@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 layer);
|
}
|
