"""Production aggregates, statistical flags, and dashboard charts."""
from typing import Dict, List, Optional
import pandas as pd
import plotly.express as px
from config import get_chart_theme, get_material_label, get_translation
def get_material_stats(df: pd.DataFrame) -> Dict:
total = df["weight_kg"].sum()
stats = {}
for material, group in df.groupby("material_type", sort=False):
material_total = group["weight_kg"].sum()
stats[material] = {
"total": material_total,
"percentage": material_total / total * 100 if total else 0.0,
"daily_avg": group.groupby("date")["weight_kg"].sum().mean(),
"work_days": group["date"].nunique(),
"records": len(group),
}
stats["_total_"] = {
"total": total,
"percentage": 100.0 if total else 0.0,
"daily_avg": df.groupby("date")["weight_kg"].sum().mean(),
"work_days": df["date"].nunique(),
"records": len(df),
}
return stats
def detect_outliers(df: pd.DataFrame) -> Dict:
"""Flag individual weights outside material-specific 1.5 x IQR bounds."""
results = {}
for material, group in df.groupby("material_type", sort=False):
q1, q3 = group["weight_kg"].quantile([0.25, 0.75])
lower = q1 - 1.5 * (q3 - q1)
upper = q3 + 1.5 * (q3 - q1)
flagged = group[(group["weight_kg"] < lower) | (group["weight_kg"] > upper)]
results[material] = {
"count": len(flagged),
"range": f"{lower:.0f} - {upper:.0f} kg",
"dates": flagged["date"].dt.strftime("%Y-%m-%d").tolist(),
"row_indices": flagged.index.tolist(),
"lower": lower,
"upper": upper,
}
return results
def answer_quick_question(kind: str, df: pd.DataFrame, stats: Dict,
lang: str = "English") -> str:
"""Answer fixed dashboard questions from calculations, without an API call."""
t = get_translation(lang)
if kind == "calendar":
daily = df.groupby("date")["weight_kg"].sum()
weekday = daily[daily.index.weekday < 5]
weekend = daily[daily.index.weekday >= 5]
if weekend.empty:
return t["quick_no_weekend"].format(days=len(weekday))
return t["quick_calendar_result"].format(
weekday_days=len(weekday), weekday_avg=weekday.mean(),
weekend_days=len(weekend), weekend_avg=weekend.mean(),
)
if kind == "material":
if not stats["_total_"]["total"]:
return t["quick_no_weight"]
material, info = max(
((name, value) for name, value in stats.items() if name != "_total_"),
key=lambda pair: pair[1]["total"],
)
return t["quick_material_result"].format(
material=get_material_label(material, lang),
weight=info["total"], share=info["percentage"],
)
if kind == "shift":
if "shift" not in df.columns or df["shift"].isna().all():
return t["quick_no_shift"]
grouped = df.groupby("shift")["weight_kg"].agg(["sum", "count"]).sort_values(
"sum", ascending=False
)
details = ", ".join(
t["quick_shift_item"].format(shift=name, weight=row["sum"], records=int(row["count"]))
for name, row in grouped.iterrows()
)
return t["quick_shift_result"].format(details=details)
raise ValueError(f"Unknown quick question: {kind}")
def _with_period(df: pd.DataFrame, time_period: str) -> pd.DataFrame:
data = df.copy()
if time_period == "daily":
data["period"] = data["date"]
elif time_period == "weekly":
data["period"] = data["date"].dt.to_period("W-SUN").dt.start_time
elif time_period == "monthly":
data["period"] = data["date"].dt.to_period("M").dt.start_time
else:
raise ValueError(f"Unsupported time period: {time_period}")
return data
def _style(fig, show_legend: bool = True):
fig.update_layout(**get_chart_theme()["layout"], height=400, showlegend=show_legend)
return fig
def create_total_production_chart(
df: pd.DataFrame, time_period: str = "daily", lang: str = "English"
):
t = get_translation(lang)
grouped = _with_period(df, time_period).groupby("period", as_index=False).agg(
weight_kg=("weight_kg", "sum"), record_count=("weight_kg", "size")
)
title_key = {
"daily": "chart_total_production",
"weekly": "chart_total_production_weekly",
"monthly": "chart_total_production_monthly",
}[time_period]
fig = px.bar(
grouped, x="period", y="weight_kg", custom_data=["record_count"],
title=t[title_key],
labels={"period": t["label_date"], "weight_kg": t["label_weight"]},
)
records_label = "Registreringer" if lang == "Norsk" else "Records"
fig.update_traces(
hovertemplate=f"%{{x|%Y-%m-%d}}
%{{y:,.0f}} kg
{records_label}: %{{customdata[0]}}"
)
return _style(fig, show_legend=False)
def create_materials_trend_chart(
df: pd.DataFrame, time_period: str = "daily",
selected_materials: Optional[List[str]] = None, lang: str = "English"
):
t = get_translation(lang)
data = df[df["material_type"].isin(selected_materials)] if selected_materials is not None else df
grouped = _with_period(data, time_period).groupby(
["period", "material_type"], as_index=False
)["weight_kg"].sum()
grouped["material_label"] = grouped["material_type"].map(
lambda material: get_material_label(material, lang)
)
title_key = {
"daily": "chart_materials_trends",
"weekly": "chart_materials_trends_weekly",
"monthly": "chart_materials_trends_monthly",
}[time_period]
chart = px.line if time_period == "daily" else px.bar
fig = chart(
grouped, x="period", y="weight_kg", color="material_label",
title=t[title_key],
labels={"period": t["label_date"], "weight_kg": t["label_weight"],
"material_label": t["label_material"]},
)
return _style(fig)
def create_shift_trend_chart(
df: pd.DataFrame, time_period: str = "daily", lang: str = "English"
):
t = get_translation(lang)
data = _with_period(df, time_period)
data["shift"] = data["shift"].fillna("Unspecified" if lang == "English" else "Uspesifisert")
grouped = data.groupby(["period", "shift"], as_index=False)["weight_kg"].sum()
title = (t["chart_shift_trends"] if time_period == "daily"
else t["chart_shift_trends_period"])
fig = px.bar(
grouped, x="period", y="weight_kg", color="shift", barmode="stack",
title=title,
labels={"period": t["label_date"], "weight_kg": t["label_weight"]},
)
return _style(fig)