package com.skyline.electricity.mapper;
|
|
import com.baomidou.mybatisplus.core.conditions.Wrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.extension.service.IService;
|
import com.skyline.electricity.pojo.Information;
|
import com.skyline.electricity.pojo.Monitor;
|
import com.skyline.electricity.pojo.MonitorInfo;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
|
@Mapper
|
public interface InformationMapper extends BaseMapper<Information> {
|
@Select("SELECT * from information where userid=#{userid} " )
|
Information getInformationByUserid(String userid);
|
|
|
@Select("SELECT * from information where (to_timestamp(starttime::BIGINT)+ (hb||' sec')::interval) > (now()::timestamp) " )
|
List<Information> listInformations();
|
|
@Select("select gid,monitor_name, monitor_type, belong_device, aisle_no, aisle_type, video_ip, monitor_id, belong_area, monitor_index," +
|
"x, y, z, hk_rtsp,ST_AsText(geom) as geom from monitor where gid in " +
|
"(select gid from (select *,ST_Distance((geom)," +
|
"ST_GeomFromText('Point(${lat} ${lon})')) as dis from monitor" +
|
|
" order by dis limit 1 ) as foo)")
|
MonitorInfo queryMinDistance(String lon, String lat);
|
}
|
