import json
import time
from datetime import datetime

import pandas as pd
from amadeus import Client, ResponseError
import calender_maker
from inspiration.TingSomSkalTilføjes.calender_maker import CalenderMaker


# OopCompanion:suppressRename


class AmadeusClient:
	def __init__(self, prod=bool):
		"""
		Initialize the Amadeus API client.
		"""
		if prod:
			client_id = "ABRGQv6U7IWAYxwwmjqAOPUDGvuFMSjw"
			client_secret = "BcwpSKf3FICJIxaw"
			self.client = Client(client_id=client_id, client_secret=client_secret,host="api.amadeus.com")
			print("Getting production Amadeus API client")
		else:
			client_id = "uxDqIh36xPAUvpXnXynwAnH86pGBdIch"
			client_secret = "xTSLooNZpJWantb5"
			self.client = Client( client_id = client_id, client_secret = client_secret,host="test.api.amadeus.com" )
			print( "Getting development Amadeus API client" )

	def find_cheapest_flights(self, origin: str, destination: str, departure_date: str, adults: int = 1):
		"""
		Find the cheapest flights from the origin to the destination on a specific date.

		:param origin: The IATA code for the origin location.
		:param destination: The IATA code for the destination location.
		:param departure_date: The date of departure in YYYY-MM-DD format.
		:param adults: Number of adult passengers.
		:return: Flight offers data.
		"""
		try:
			response = self.client.shopping.flight_offers_search.get(
				originLocationCode=origin,
				destinationLocationCode=destination,
				departureDate=departure_date,
				adults=adults,
				max=250,
				nonStop="true",
			)
			return response.data

		except ResponseError as error:
			if error.response.status_code == 429:
				retry_after = error.response.headers.get( 'Retry-After', '60' )  # standard fallback til 60 sekunder
				print( f"Rate limit reached. Retry after {retry_after} seconds." )
				time.sleep( int( retry_after ) )
			print(error)


	def parse_flight_data(self, flights):
		"""
		Parse the flight data to extract useful information about flights.

		:param flights: Raw flight offers data.
		:return: Parsed flight details.
		"""
		result = []
		for flight_offer in flights:
			itineraries = flight_offer.get("itineraries", [])
			price = float(flight_offer.get("price", {}).get("total", 0))

			for itinerary in itineraries:
				segments = itinerary.get("segments", [])
				for segment in segments:
					if segment.get("numberOfStops", -1) == 0:  # Only non-stop flights
						departure = segment.get("departure", {})
						arrival = segment.get("arrival", {})
						travel_time = (
								              datetime.fromisoformat(arrival["at"]) - datetime.fromisoformat(departure["at"])
						              ).total_seconds() / 3600

						result.append({
							"departure": {
								"iataCode": departure.get("iataCode"),
								"at": departure.get("at"),
							},
							"arrival": {
								"iataCode": arrival.get("iataCode"),
								"at": arrival.get("at"),
							},
							"travel_time": travel_time,
							"price": price,
						})
		return result

	def get_flight_summary(self, departure_date: str, origin: str, destination: str):
		"""
		Get a summary of the flight details for a specific date, origin, and destination.

		:param departure_date: The date oxxf travel in YYYY-MM-DD format.
		:param origin: The IATA code for the origin location.
		:param destination: The IATA code for the destination location.
		:return: Formatted flight summary string.
		"""
		time.sleep(5)  # Avoid rate limiting
		flights = self.find_cheapest_flights(origin, destination, departure_date)
		parsed_flights = self.parse_flight_data(flights)
		with open("data_chunks.txt", "a") as fp:
			json.dump(parsed_flights, fp,indent = 4)
			fp.write(",")


		if not parsed_flights:
			return f"No flights found for {departure_date}: {origin} -> {destination}"

		average_price = sum(f["price"] for f in parsed_flights) / len(parsed_flights)
		first_departure = parsed_flights[0]["departure"]["iataCode"]
		last_arrival = parsed_flights[-1]["arrival"]["iataCode"]

		#return f"{departure_date}: {first_departure} -> {last_arrival} - {average_price:.2f}"
		return {"departure_date":departure_date,  "departure": first_departure, "arrival": last_arrival,"price": average_price,"note":"Success"}

# Example usage
if __name__ == "__main__":
	cd = CalenderMaker()
	travel_days = cd.get_dates(year = 2025, dest_day="Friday", orgin_day="Wednesday")
	amadeus_client = AmadeusClient( prod = True)
	import csv

	with open( "summery.txt", 'w' ) as fp, open( 'data_csv.csv', "w" ) as fp2:
		writer = csv.DictWriter( fp2, fieldnames = ['departure_date', 'departure', 'arrival', 'price','note'] )
		writer.writeheader()
		for days in travel_days:
			try:
				try:

					#summary = amadeus_client.get_flight_summary( days['date'], days['departure'], days['arrival'] )
					summary = amadeus_client.get_flight_summary( days['date'], days['departure'], days['arrival'] )
					print(summary)
					writer.writerow({ "departure_date":summary['departure_date'], "departure":summary['departure'], "arrival":summary['arrival'], "price":summary['price'], "note":summary['note'] } )
					fp.writelines( str(summary) + '\n' )
				except Exception as e:
					#raise e
					#print( f"Error fetching flight summary for {origin} -> {destination} on {departure_date}" )
					writer.writerow({ "departure_date":days['date'], "departure":days['departure'], "arrival":days['arrival'], "price":250, "note":"Not fetched - Failed" } )

			except ResponseError as error:
				print( f"An error occurred: {error}" )

	df = pd.read_csv( 'data_csv.csv' )

	# Write the raw data to the first sheet
	with pd.ExcelWriter( 'output.xlsx' ) as writer:
		df.to_excel( writer, sheet_name = 'Sheet1', index = False )

		# Calculate the average monthly data
		df['departure_date'] = pd.to_datetime( df['departure_date'] )
		df['month'] = df['departure_date'].dt.to_period( 'M' )
		avg_monthly_data = df.groupby( 'month' )['price'].mean().reset_index()
		avg_monthly_data.columns = ['Month', 'Average Price']

		# Write the average monthly data to the second sheet
		avg_monthly_data.to_excel( writer, sheet_name = 'Sheet2', index = False )