import fs from 'fs-extra'
import { parseString } from 'xml2js'
import _ from 'lodash'
import moment from 'moment-timezone'

const xml = fs.readFileSync('./input/snow.kml', 'utf8')

parseString(xml, (error, result) => {

	if (error) {

		console.error(error)

		process.exit(1)

	} else {

		try {

			const placemarks = _.get(result, 'kml.Document[0].Placemark', [])

			const allData = _(placemarks)
				.map(v => {

					const lat = _.get(v, 'LookAt[0].latitude[0]', '0')

					const lon = _.get(v, 'LookAt[0].longitude[0]', '0')

					const description = _.get(v, 'description[0]', '')

					const parts =
						description.match(/Snowfall: (.*) inches(.*)Time of Report:<\/b>(.*)<br>\n$/) || []

					const [, amount, , datetime] = parts

					return {
						lat: (+lat).toFixed(1),
						lon: (+lon).toFixed(1),
						amount: +amount,
						datetime,
					}

				})

				.filter('datetime')

				.map(v => ({
					...v,
					unix: moment(v.datetime.trim(), 'h:mm A on MM/D/YYYY').valueOf(),
				}))

				.groupBy(v => [v.lat, v.lon].join(''))

				.map(values =>

					_(values)
						.orderBy(['amount'], ['desc'])
						.head()
				)

				.orderBy(['unix'], ['desc'])

				.map((v, i) => ({
					lat: v.lat,
					lon: v.lon,
					amount: v.amount,

					timestamp: i === 0 ? v.unix : null,
				}))
				.value()

			fs.writeJsonSync('./output/reports.json', allData)

		} catch (e) {

			console.error(e)

			process.exit(1)

		}

	}

})