package com.tairui.app.cim.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tairui.app.cim.dao.model.AlarmPoint;
import com.tairui.app.cim.dao.model.Elevation;
import com.vividsolutions.jts.geom.Point;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author yw
 * @since 2022-05-21
 */
@Mapper
@Repository
public interface ElevationMapper extends BaseMapper<Elevation> {

        /**
         * 包含面
         * select * from (select gid,geom,coor_z,cen_x,cen_y,name from elevation_correction where floor_num='Floor5')
         * as xx where ST_Within(st_geomfromtext('Point(124.041948 41.840189)',4326),xx.geom)
         *
         * @param x
         * @param y
         * @param floor
         * @return
         */
       @Select("select gid,to_char(coor_z,'999.999') as high ,name from elevation_correction " +
                "where floor_num='${floor_num}' and  ST_Within(st_geomfromtext('Point(${x} ${y})',4326),geom) ")
        public List<Elevation> queryFloor(@Param("x") double x, @Param("y") double y,  @Param("floor_num") String floor_num);


        /**
         * 查询最近的面
         * select * from (select gid,geom,coor_z,cen_x,cen_y,name from elevation_correction
         * where floor_num='Floor3') as xx order by (st_geomfromtext('Point(124.04 41.840)',4326)<->xx.geom) asc limit 1
         *
         * @param x
         * @param y
         * @param floor
         * @return
         */

        @Select("select gid,to_char(coor_z,'999.999') as high ,ST_X(ST_AsText(ST_PointOnSurface(geom::geometry))) as cen_x," +
                "ST_Y(ST_AsText(ST_PointOnSurface(geom::geometry))) as cen_y,name from elevation_correction " +
                "where floor_num='${floor_num}'  order by (st_geomfromtext('Point(${x} ${y})',4326)<->geom) asc limit 1")
        public List<Elevation> queryMinDistance(@Param("x") double x, @Param("y") double y, @Param("floor_num") String floor_num);
}