require 'json'
require 'csv'
require 'rgeo'
require 'rgeo-geojson'

class Parser
	def initialize()
		@list_of_locations = {}
		@list_of_locations["type"] = "FeatureCollection"
		@list_of_locations["features"] = []
	end
	def parseConcertesFiles(data_file, coordinates_file)
		data = CSV.parse(File.read(data_file), headers: true, :col_sep => ";")
		coord = CSV.parse(File.read(coordinates_file), headers: true, :col_sep => ";")
		i = 0
		while i < data.size
			new_item = {}
			new_item["type"] = "Feature"
			new_item["geometry"] = {}
			new_item["geometry"]["type"] = "Point"
			new_item["geometry"]["coordinates"] = [coord[i]["CoordLamb_X"].to_f, coord[i]["CoordLamb_Y"].to_f]
			new_item["properties"] = {}
			new_item["properties"]["name"] = data[i]["Denomination_FULL"]
			new_item["properties"]["description"] = data[i]["description"]
			new_item["properties"]["entry_number"] = data[i]["NumEntr"]
			new_item["properties"]["phone_number"] = coord[i]["Tel"]
			new_item["properties"]["website"] = coord[i]["Web"]
			new_item["properties"]["mail"] = coord[i]["Email"]
			new_item["properties"]["address"] = coord[i]["Adresse"]
			new_item["properties"]["city"] = data[i]["INS_COMMUNE"]
			new_item["properties"]["postal_code"] = coord[i]["Code postal"]
			new_item["properties"]["categories"] = []
			new_item["properties"]["source"] = "Concertes"
			new_item["properties"]["srid"] = "4326" #Not precised in Concertes database
			@list_of_locations["features"].push(new_item)
			i += 1
		end
		File.write("Locations.geojson", JSON.pretty_generate(@list_of_locations))
	end
	def writeToFile(write_file)
		File.write(write_file, JSON.pretty_generate(@list_of_locations))
	end
end

BEGIN {
	puts "Starting parser"
}

parser = Parser.new()
parser.parseConcertesFiles("Concertes/20200312_EntreprisesSignaletique.csv", "Concertes/20200312_EntreprisesCoordonnees.csv")
parser.writeToFile("LocationsConcertes.geojson")


END {
	puts "Ending parser"
}