package com.weather.domain.prediction;

import lombok.extern.slf4j.Slf4j;
import org.joda.time.DateTime;
import org.json.simple.JSONArray;
import org.json.simple.JSONObject;
import org.json.simple.parser.JSONParser;
import org.json.simple.parser.ParseException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.client.RestTemplate;

import java.io.*;
import java.net.URI;
import java.net.URISyntaxException;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.*;

import org.springframework.transaction.annotation.Transactional;
/**
 * Created by godong9 on 2017. 7. 29..
 */

@Slf4j
@Transactional(readOnly = true)
@Service
public class PredictionService {

    @Autowired
    private PredictionRepository predictionRepository;

    private String baseUrl = "http://newsky2.kma.go.kr/service/SecndSrtpdFrcstInfoService2";

    private String ServiceKey = "nKLi60PlKsKvxCjkrxepPposghEF1gzuDrq2Sa2HkWGgrw64Ryi%2FUV%2BlzJfPeZ6OYdq3v9Yqlf5l%2B7NcEaB9CA%3D%3D";

    public Prediction findOne(Long id) {
        return predictionRepository.findOne(id);
    }

    @Transactional(readOnly = false)
    public String predictionCrawling() throws URISyntaxException {
        List<Integer> xList = new ArrayList<>();
        List<Integer> yList = new ArrayList<>();

        try {
            File csv = new File("nxny.csv");
            BufferedReader br = new BufferedReader(new FileReader(csv));
            String line = "";

            int count = 0;
            log.info("csv: ", csv);
            while ((line = br.readLine()) != null && count < 900){
                count += 1;
                String[] token = line.split(",", -1);
                xList.add(Integer.parseInt(token[0]));
                yList.add(Integer.parseInt(token[1]));
            }
            br.close();

        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return null;
    }

    @Transactional(readOnly = false)
    public Prediction readPrediction(int nx,  int ny) throws URISyntaxException {
        Prediction prediction = new Prediction();
        Map<String, Integer> map = new HashMap<>();
        Map<String, Float> resultMap = new HashMap<>();

        RestTemplate restTemplate = new RestTemplate();
        DateTime dt = new DateTime();
        String base_date = dt.toString("yyyyMMdd");

        int hour = dt.getHourOfDay();
        int minute = dt.getMinuteOfHour();


        if (minute < 30) {
            hour = hour - 1;
            System.out.println(hour);
            if (hour < 0) {
                hour = 23;
                System.out.println(hour);
                int dd = Integer.parseInt(base_date.substring(6, 8)) - 1;
                base_date = base_date.substring(0, 6) + dd;
            }
        }

        String base_time = "";

        if(hour < 10)
            base_time = "0" + hour + "30";
        else
            base_time = hour + "30";

        String timeUrl = this.baseUrl + "/ForecastTimeData?ServiceKey=" + this.ServiceKey + "&base_date=" + base_date + "&base_time=" +
                base_time + "&nx=" + nx + "&ny=" + ny + "&numOfRows=30&_type=json";

        if (hour == 2) {
            hour = 23;
            int dd = Integer.parseInt(base_date.substring(6, 8)) - 1;
            base_date = base_date.substring(0, 6) + dd;
        } else if (hour % 3 == 0)
            hour = hour - 1;
        else if (hour % 3 == 1)
            hour = hour - 2;

        base_time = hour + "00";

        String spaceUrl = this.baseUrl + "/ForecastSpaceData?ServiceKey=" + this.ServiceKey + "&base_date=" + base_date + "&base_time=" +
                base_time + "&nx=" + nx + "&ny=" + ny + "&numOfRows=30&_type=json";

        URI timeUri = new URI(timeUrl);
        URI spaceUri = new URI(spaceUrl);

        String timeResult = restTemplate.getForObject(timeUri, String.class);
        String spaceResult = restTemplate.getForObject(spaceUri, String.class);

        JSONParser parser = new JSONParser();

        try {
            JSONObject timeObject = (JSONObject) parser.parse(timeResult);
            JSONObject timeResponse = (JSONObject) timeObject.get("response");
            JSONObject body = (JSONObject) timeResponse.get("body");
            JSONObject timeItems = (JSONObject) body.get("items");
            JSONArray timeJsonArray = (JSONArray) timeItems.get("item");

            JSONObject spaceObject = (JSONObject) parser.parse(spaceResult);
            JSONObject spaceRsponse = (JSONObject) spaceObject.get("response");
            JSONObject spaceBody = (JSONObject) spaceRsponse.get("body");
            JSONObject spaceItems = (JSONObject) spaceBody.get("items");
            JSONArray spaceJsonArray = (JSONArray) spaceItems.get("item");

            JSONObject rainProp = (JSONObject) spaceJsonArray.get(0);
            prediction.setRainProp(rainProp.get("fcstValue").toString());
            System.out.println(rainProp.get("fcstValue").toString());

            JSONObject object = (JSONObject) parser.parse(timeJsonArray.get(0).toString());
            map.put(object.get("category").toString(), 1);

            String bsDate = object.get("baseDate").toString();
            String pdDate = object.get("fcstDate").toString();

            SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd");
            Date baseDate = format.parse(bsDate);
            Date predictionDate = format.parse(pdDate);

            prediction.setBaseDate(new Timestamp(baseDate.getTime()));
            prediction.setPredictionDate(new Timestamp(predictionDate.getTime()));
            prediction.setNx(Integer.parseInt(object.get("nx").toString()));
            prediction.setNy(Integer.parseInt(object.get("ny").toString()));


            for (int i = 1; i < timeJsonArray.size(); i++) {
                JSONObject jsonObject = (JSONObject) parser.parse(timeJsonArray.get(i).toString());
                String category = jsonObject.get("category").toString();
                float value = Float.valueOf(jsonObject.get("fcstValue").toString());

                if (map.containsKey(category)) {
                    if (map.get(category) < 2)
                        resultMap.put(category, value);
                    map.put(category, map.get(category) + 1);
                } else {
                    map.put(category, 1);
                }
            }

            float skyValue = resultMap.get("SKY");

            if (skyValue == 1)
                prediction.setWeatherCode(WeatherCode.SUNNY);
            else if (skyValue == 2 || skyValue == 3)
                prediction.setWeatherCode(WeatherCode.CLOUD);
            else if (skyValue == 4)
                prediction.setWeatherCode(WeatherCode.CLOUDY);

            float rainSnowValue = resultMap.get("PTY");

            if (rainSnowValue == 1)
                prediction.setWeatherCode(WeatherCode.RAIN);
            else if (rainSnowValue == 2 || rainSnowValue == 3)
                prediction.setWeatherCode(WeatherCode.SNOW);

            float thunderValue = resultMap.get("LGT");

            if (thunderValue == 2 || thunderValue == 3)
                prediction.setWeatherCode(WeatherCode.THUNDER);

            prediction.setTemperature(resultMap.get("T1H").toString());
            prediction.setHumidity(resultMap.get("REH").toString());

            this.predictionRepository.save(prediction);

        } catch (ParseException e) {
            e.printStackTrace();
        } catch (java.text.ParseException e) {
            e.printStackTrace();
        }


        return prediction;
    }

    public List<Prediction> findByNxGreaterThanAndNyGreaterThanAndNxLessThanAndNyLessThan(int startNx, int startNy, int endNx, int endNy) {
        return predictionRepository.findByNxGreaterThanAndNyGreaterThanAndNxLessThanAndNyLessThan(
                startNx, startNy, endNx, endNy
        );
    }
}

@@ -1417,17 +1417,51 @@
 ew File(
-%22
+System.getProperty(%22user.dir%22) + %22/
 nxny.csv

Update Path