//
|
// 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);
|
}
|
