Add admin metrics dashboard

- Added Core.Database.get_metrics_summary() for aggregate stats -
Added Core.Database.get_episode_metric_events() for raw event data -
Created MetricsDashboard component with summary cards and top episodes
tables - Added /admin/metrics route with admin authentication -
Added metrics link to admin dropdown menu - Added comprehensive tests
for metrics functionality - Fixed type errors in Admin.py by adding
MetricCardAttrs - All tests passing (48 tests total in Web.py) -
Completed epic t-ga8V8O (24/24 tasks)

1 files changed, 291 insertions, 0 deletions

diff --git a/Biz/PodcastItLater/Admin.py b/Biz/PodcastItLater/Admin.py
index 8e12fc7..10a8e58 100644
--- a/Biz/PodcastItLater/Admin.py
+++ b/Biz/PodcastItLater/Admin.py
@@ -31,6 +31,270 @@ from ludic.web.responses import Response
 from typing import override
 
 
+class MetricsAttrs(Attrs):
+    """Attributes for Metrics component."""
+
+    metrics: dict[str, typing.Any]
+    user: dict[str, typing.Any] | None
+
+
+class MetricCardAttrs(Attrs):
+    """Attributes for MetricCard component."""
+
+    title: str
+    value: int
+    icon: str
+
+
+class MetricCard(Component[AnyChildren, MetricCardAttrs]):
+    """Display a single metric card."""
+
+    @override
+    def render(self) -> html.div:
+        title = self.attrs["title"]
+        value = self.attrs["value"]
+        icon = self.attrs.get("icon", "bi-bar-chart")
+
+        return html.div(
+            html.div(
+                html.div(
+                    html.i(classes=["bi", icon, "text-primary", "fs-2"]),
+                    classes=["col-auto"],
+                ),
+                html.div(
+                    html.h6(title, classes=["text-muted", "mb-1"]),
+                    html.h3(str(value), classes=["mb-0"]),
+                    classes=["col"],
+                ),
+                classes=["row", "align-items-center"],
+            ),
+            classes=["card-body"],
+        )
+
+
+class TopEpisodesTableAttrs(Attrs):
+    """Attributes for TopEpisodesTable component."""
+
+    episodes: list[dict[str, typing.Any]]
+    metric_name: str
+    count_key: str
+
+
+class TopEpisodesTable(Component[AnyChildren, TopEpisodesTableAttrs]):
+    """Display a table of top episodes by a metric."""
+
+    @override
+    def render(self) -> html.div:
+        episodes = self.attrs["episodes"]
+        metric_name = self.attrs["metric_name"]
+        count_key = self.attrs["count_key"]
+
+        if not episodes:
+            return html.div(
+                html.p(
+                    "No data yet",
+                    classes=["text-muted", "text-center", "py-3"],
+                ),
+                classes=["card-body"],
+            )
+
+        return html.div(
+            html.div(
+                html.table(
+                    html.thead(
+                        html.tr(
+                            html.th("#", classes=["text-muted"]),
+                            html.th("Title"),
+                            html.th("Author", classes=["text-muted"]),
+                            html.th(
+                                metric_name,
+                                classes=["text-end", "text-muted"],
+                            ),
+                        ),
+                        classes=["table-light"],
+                    ),
+                    html.tbody(
+                        *[
+                            html.tr(
+                                html.td(
+                                    str(idx + 1),
+                                    classes=["text-muted"],
+                                ),
+                                html.td(
+                                    TruncatedText(
+                                        text=episode["title"],
+                                        max_length=Core.TITLE_TRUNCATE_LENGTH,
+                                    ),
+                                ),
+                                html.td(
+                                    episode.get("author") or "-",
+                                    classes=["text-muted"],
+                                ),
+                                html.td(
+                                    str(episode[count_key]),
+                                    classes=["text-end"],
+                                ),
+                            )
+                            for idx, episode in enumerate(episodes)
+                        ],
+                    ),
+                    classes=["table", "table-hover", "mb-0"],
+                ),
+                classes=["table-responsive"],
+            ),
+            classes=["card-body", "p-0"],
+        )
+
+
+class MetricsDashboard(Component[AnyChildren, MetricsAttrs]):
+    """Admin metrics dashboard showing aggregate statistics."""
+
+    @override
+    def render(self) -> UI.PageLayout:
+        metrics = self.attrs["metrics"]
+        user = self.attrs.get("user")
+
+        return UI.PageLayout(
+            html.div(
+                html.h2(
+                    html.i(classes=["bi", "bi-graph-up", "me-2"]),
+                    "Episode Metrics",
+                    classes=["mb-4"],
+                ),
+                # Summary cards
+                html.div(
+                    html.div(
+                        html.div(
+                            MetricCard(
+                                title="Total Episodes",
+                                value=metrics["total_episodes"],
+                                icon="bi-collection",
+                            ),
+                            classes=["card", "shadow-sm"],
+                        ),
+                        classes=["col-md-3"],
+                    ),
+                    html.div(
+                        html.div(
+                            MetricCard(
+                                title="Total Plays",
+                                value=metrics["total_plays"],
+                                icon="bi-play-circle",
+                            ),
+                            classes=["card", "shadow-sm"],
+                        ),
+                        classes=["col-md-3"],
+                    ),
+                    html.div(
+                        html.div(
+                            MetricCard(
+                                title="Total Downloads",
+                                value=metrics["total_downloads"],
+                                icon="bi-download",
+                            ),
+                            classes=["card", "shadow-sm"],
+                        ),
+                        classes=["col-md-3"],
+                    ),
+                    html.div(
+                        html.div(
+                            MetricCard(
+                                title="Total Adds",
+                                value=metrics["total_adds"],
+                                icon="bi-plus-circle",
+                            ),
+                            classes=["card", "shadow-sm"],
+                        ),
+                        classes=["col-md-3"],
+                    ),
+                    classes=["row", "g-3", "mb-4"],
+                ),
+                # Top episodes tables
+                html.div(
+                    html.div(
+                        html.div(
+                            html.div(
+                                html.h5(
+                                    html.i(
+                                        classes=[
+                                            "bi",
+                                            "bi-play-circle-fill",
+                                            "me-2",
+                                        ],
+                                    ),
+                                    "Most Played",
+                                    classes=["card-title", "mb-0"],
+                                ),
+                                classes=["card-header", "bg-white"],
+                            ),
+                            TopEpisodesTable(
+                                episodes=metrics["most_played"],
+                                metric_name="Plays",
+                                count_key="play_count",
+                            ),
+                            classes=["card", "shadow-sm"],
+                        ),
+                        classes=["col-lg-4"],
+                    ),
+                    html.div(
+                        html.div(
+                            html.div(
+                                html.h5(
+                                    html.i(
+                                        classes=[
+                                            "bi",
+                                            "bi-download",
+                                            "me-2",
+                                        ],
+                                    ),
+                                    "Most Downloaded",
+                                    classes=["card-title", "mb-0"],
+                                ),
+                                classes=["card-header", "bg-white"],
+                            ),
+                            TopEpisodesTable(
+                                episodes=metrics["most_downloaded"],
+                                metric_name="Downloads",
+                                count_key="download_count",
+                            ),
+                            classes=["card", "shadow-sm"],
+                        ),
+                        classes=["col-lg-4"],
+                    ),
+                    html.div(
+                        html.div(
+                            html.div(
+                                html.h5(
+                                    html.i(
+                                        classes=[
+                                            "bi",
+                                            "bi-plus-circle-fill",
+                                            "me-2",
+                                        ],
+                                    ),
+                                    "Most Added to Feeds",
+                                    classes=["card-title", "mb-0"],
+                                ),
+                                classes=["card-header", "bg-white"],
+                            ),
+                            TopEpisodesTable(
+                                episodes=metrics["most_added"],
+                                metric_name="Adds",
+                                count_key="add_count",
+                            ),
+                            classes=["card", "shadow-sm"],
+                        ),
+                        classes=["col-lg-4"],
+                    ),
+                    classes=["row", "g-3"],
+                ),
+            ),
+            user=user,
+            current_page="admin-metrics",
+            error=None,
+        )
+
+
 class AdminUsersAttrs(Attrs):
     """Attributes for AdminUsers component."""
 
@@ -703,6 +967,33 @@ def toggle_episode_public(request: Request, episode_id: int) -> Response:
     )
 
 
+def admin_metrics(request: Request) -> MetricsDashboard | Response:
+    """Admin metrics dashboard showing episode statistics."""
+    # Check if user is logged in and is admin
+    user_id = request.session.get("user_id")
+    if not user_id:
+        return Response(
+            "",
+            status_code=302,
+            headers={"Location": "/"},
+        )
+
+    user = Core.Database.get_user_by_id(
+        user_id,
+    )
+    if not user or not Core.is_admin(user):
+        return Response(
+            "",
+            status_code=302,
+            headers={"Location": "/?error=forbidden"},
+        )
+
+    # Get metrics data
+    metrics = Core.Database.get_metrics_summary()
+
+    return MetricsDashboard(metrics=metrics, user=user)
+
+
 def main() -> None:
     """Admin tests are currently in Web."""
     if "test" in sys.argv: