# Import necessary libraries
from flask import Flask, request, jsonify  # For creating the Flask API
import joblib
import pandas as pd
# Initialize the Flask application
sales_forecast_predictor_api = Flask("SuperKart Sales Forecast Predictor")

# Load the trained machine learning model
model = joblib.load("superkart_sales_forecast_model_v1_0.joblib")

# Define a route for the home page (GET request)
@sales_forecast_predictor_api.get('/')
def home():
    """
    This function handles GET requests to the root URL ('/') of the API.
    It returns a simple welcome message.
    """
    return "Welcome to the SuperKart Sales Forecast Prediction API!"

# Define an endpoint for single property prediction (POST request)
@sales_forecast_predictor_api.post('/v1/sales')
def predict_sales_price():
    """
    This function handles POST requests to the '/v1/sales' endpoint.
    It expects a JSON payload containing property details and returns
    the predicted rental price as a JSON response.
    """
    # Get the JSON data from the request body
    property_data = request.get_json()

    # Extract relevant features from the JSON data
    sample = {
        'Product_Weight': property_data['Product_Weight'],
        'Product_Sugar_Content': property_data['Product_Sugar_Content'],
        'Product_Allocated_Area': property_data['Product_Allocated_Area'],
        'Product_Type': property_data['Product_Type'],
        'Product_MRP': property_data['Product_MRP'],
        'Store_Id': property_data['Store_Id'],
        'Store_Establishment_Year': property_data['Store_Establishment_Year'],
        'Store_Size': property_data['Store_Size'],
        'Store_Location_City_Type': property_data['Store_Location_City_Type'],
        'Store_Type': property_data['Store_Type']
    }

    # Convert the extracted data into a Pandas DataFrame
    input_data = pd.DataFrame([sample])

    # Derive 'Store_Age'
    input_data['Store_Age'] = 2025 - input_data['Store_Establishment_Year']

    # Drop original year column
    input_data.drop('Store_Establishment_Year', axis=1, inplace=True)

    # Make prediction (get log_price)
    predicted_sales_forecast = model.predict(input_data)[0]

   # Convert predicted_price to Python float
    predicted_sales = round(float(predicted_sales_forecast), 2)
    # When we send this value directly within a JSON response, Flask's jsonify function encounters a datatype error

    # Return the actual price
    return jsonify({'Predicted Sales (in dollars)': predicted_sales})


# Define an endpoint for batch prediction (POST request)
@sales_forecast_predictor_api.post('/v1/salesbatch')
def predict_sales_price_batch():
    """
    This function handles POST requests to the '/v1/salesbatch' endpoint.
    It expects a CSV file containing property details for multiple properties
    and returns the predicted rental prices as a dictionary in the JSON response.
    """
    # Get the uploaded CSV file from the request
    file = request.files['file']

    # Read the CSV file into a Pandas DataFrame
    input_data = pd.read_csv(file)

    # Store Product_Id separately
    product_ids = input_data['Product_Id']

    # Feature engineering: create Store_Age
    input_data['Store_Age'] = 2025 - input_data['Store_Establishment_Year']

    # Drop unused columns
    input_data.drop(['Store_Establishment_Year', 'Product_Id'], axis=1, inplace=True)

    # Make predictions for all properties in the DataFrame (get log_prices)
    predicted_sales_forecast = model.predict(input_data).tolist()

    # Calculate actual prices
    predicted_sales = [(round(sales_forecast), 2) for sales_forecast in predicted_sales_forecast]

    # Create a dictionary of predictions with property IDs as keys
    product_ids_df = pd.DataFrame(product_ids)
    Product_Id = product_ids_df['Product_Id'].tolist()  # Assuming 'id' is the property ID column
    output_dict = dict(zip(Product_Id, predicted_sales))  # Use actual prices

    # Return the predictions dictionary as a JSON response
    return output_dict

# Run the Flask application in debug mode if this script is executed directly
if __name__ == '__main__':
    sales_forecast_predictor_api.run(debug=True)