report.py

import pandas as pd
from sqlalchemy import create_engine

# MySQL Connection (XAMPP default settings)
engine = create_engine('mysql+pymysql://root:@localhost/ecommerce_db')

# SQL Query jo humne abhi chalayi thi
query = """
SELECT 
    MONTH(STR_TO_DATE(InvoiceDate, '%%m/%%d/%%Y %%H:%%i')) AS Month, 
    SUM(Quantity * UnitPrice) AS Monthly_Revenue
FROM data
GROUP BY Month
ORDER BY Month;
"""

# Data ko SQL se utha kar DataFrame mein daalna
df = pd.read_sql(query, engine)

# Excel file mein save kara
df.to_excel("Monthly_Sales_Report.xlsx", index=False)
print("Zabardast! Excel Report tayyar hai.")