package incheon.sgp.ipd.academy.mapper;

import org.egovframe.rte.psl.dataaccess.mapper.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

import incheon.com.config.annotation.ExternalDB;
import incheon.sgp.ipd.academy.vo.AcademyVO;

@org.egovframe.rte.psl.dataaccess.mapper.Mapper @incheon.com.config.annotation.ExternalDB
public interface AcademyMapper {

	List<AcademyVO> selectAcademyListByRadius(
	    @Param("latitude") double latitude,
	    @Param("longitude") double longitude,
	    @Param("radius") double radius, 
	    @Param("offset") int offset,
	    @Param("limit") int limit
	);

	List<AcademyVO> selectAcademyListByRadiusCategory(
	    @Param("latitude") double latitude,
	    @Param("longitude") double longitude,
	    @Param("radius") double radius,
	    @Param("offset") int offset,
	    @Param("limit") int limit,
	    @Param("category1") String category1,
	    @Param("category2") String category2,
	    @Param("category3") String category3
	);

	AcademyVO findAcademyByInfo(
			@Param("latitude") double latitude, 
			@Param("longitude") double longitude, 
			@Param("name") String name
	);
	
}