package incheon.sgp.ipd.academy.service.impl;

import java.util.List;
import java.util.Map;

import org.egovframe.rte.fdl.cmmn.EgovAbstractServiceImpl;
import org.springframework.stereotype.Service;

import incheon.sgp.ipd.academy.mapper.AcademyMapper;
import incheon.sgp.ipd.academy.service.AcademyService;
import incheon.sgp.ipd.academy.vo.AcademyVO;
import incheon.sgp.ipd.eduresource.vo.ElementarySchoolVO;
import lombok.NoArgsConstructor;
import lombok.RequiredArgsConstructor;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Service
@RequiredArgsConstructor
public class AcademyServiceImpl extends EgovAbstractServiceImpl implements AcademyService {
	private final AcademyMapper mapper;
    

	@Override
	public List<AcademyVO> getAcademyListByRadius(double latitude, double longitude,double radius, int offset, int limit) {
        List<AcademyVO> list = mapper.selectAcademyListByRadius(latitude, longitude, radius, offset, limit);        
        List<AcademyVO> result = new ArrayList<>();

        for (AcademyVO vo : list) {
            result.add(vo);
        }
		return list;
	}


	@Override
	public List<AcademyVO> getAcademyListByRadiusCategory(double latitude, double longitude, double radius, int offset,
			int limit, String category1, String category2, String category3) {
        List<AcademyVO> list = mapper.selectAcademyListByRadiusCategory(latitude, longitude, radius, offset, limit,category1,category2,category3);        
        List<AcademyVO> result = new ArrayList<>();

        for (AcademyVO vo : list) {
            result.add(vo);
        }
		return list;
	}


	@Override
	public AcademyVO findAcademyByInfo(double latitude, double longitude, String name) {
		AcademyVO academy = mapper.findAcademyByInfo(latitude,longitude,name);
		
		return academy;
	}



}