"""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)