| | |
|---|
| | | import org.apache.ibatis.annotations.Delete; |
|---|
| | | import org.apache.ibatis.annotations.Insert; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | |
|---|
| | | "<if test=\"endTime != null\"> AND time<=#{endTime}</if>" + |
|---|
| | | " ORDER BY time ASC" + |
|---|
| | | " </script>"}) |
|---|
| | | List<MobilePosition> queryPositionByDeviceIdAndTime(String deviceId, String channelId, String startTime, String endTime); |
|---|
| | | List<MobilePosition> queryPositionByDeviceIdAndTime(@Param("deviceId") String deviceId, @Param("channelId") String channelId, @Param("startTime") String startTime, @Param("endTime") String endTime); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM wvp_device_mobile_position WHERE device_id = #{deviceId}" + |
|---|
| | | " ORDER BY time DESC LIMIT 1") |
|---|
