from pathlib import Path
import pandas as pd
from django.conf import settings

CSV_PATH = Path(settings.BASE_DIR) / "dashboard" / "data" / "Structure DATA crm_saham.csv"

def load_crm_data():
    print("CSV PATH:", CSV_PATH)

    if not CSV_PATH.exists():
        raise FileNotFoundError(f"CSV not found here: {CSV_PATH}")

    df = pd.read_csv(CSV_PATH)
    df.columns = df.columns.str.strip()

    for column in ("Date_Contact", "Date_Installation_App", "Date_Souscription"):
        if column in df.columns:
            df[column] = pd.to_datetime(df[column], errors="coerce")

    return df