Campaign Tracker

1"text-purple-400">import { db } "text-purple-400">from "@/lib/db";
2"text-purple-400">import { DataTable } "text-purple-400">from "@/components/data-table";
3"text-purple-400">import { FilterBar } "text-purple-400">from "@/components/filter-bar";
4"text-purple-400">import "text-purple-400">type { Campaign } "text-purple-400">from "@/lib/types";
5
6"text-purple-400">export "text-purple-400">default "text-purple-400">async "text-purple-400">function DashboardPage() {
7  "text-purple-400">const campaigns = "text-purple-400">await db.query<Campaign>(`
8    SELECT id, client_id, name, status,
9           budget, start_date, end_date
10    FROM campaigns
11    WHERE status IN ('active', 'planning')
12    ORDER BY start_date DESC
13  `);
14
15  "text-purple-400">const activeCount = campaigns.filter(
16    (c) => c.status === 'active'
17  );
18
19  "text-purple-400">return (
20    <div className="space-y-4 p-6">
21      <div className="flex items-center justify-between">
22        <h1 className="text-lg font-semibold">
23          Campaign Dashboard
24        </h1>
25        <span className="text-sm text-muted-foreground">
26          {campaigns.length} campaigns · {activeCount.length} active
27        </span>
28      </div>
29      <FilterBar />
30      <DataTable data={campaigns} />
31    </div>
32  );
33}