package com.hxzk.gps.mapper.Track;

import com.hxzk.gps.entity.Track.TbTrack;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author YuZhiTong
 * @since 2025-05-26
 */
public interface TbTrackMapper extends BaseMapper<TbTrack> {
    List<TbTrack> FindTrackInfo(@Param("company") String companyName, @Param("time")String time,@Param("tagid")String tagid);

    @Select("SELECT t.baoliu2,t.baoliu3,t.tagid,t.time,t.baoliu8,t.baoliu9,p.p_department as baoliu10,t.baoliu4,t.x,t.y  FROM tb_track_${time} t INNER JOIN tb_person p on p.p_tagid = t.tagid where t.time >= #{baoliu1} and t.time <= #{baoliu2} and t.tagid = #{tagid} or t.time >= #{baoliu1} and t.time <= #{baoliu2} and t.baoliu8 = #{tagid} order by t.time asc ")
    List<TbTrack> FindTrackView(TbTrack tbTrack);
}