caelum0x 9ed86fa715 feat(apps): roadmap batch — agent-console, creator-dashboard, marketplace, admin, dashboard
- agent-console: Agents (ERC-8004 identity/reputation) + Jobs (ERC-8183 lifecycle timeline) pages via Local ports; 'Agent economy' nav group.
- creator-dashboard: per-source detail + per-payout royalty-split breakdown pages (stable slug/settlementId routing).
- marketplace: listing/service detail page + tag/search filtering.
- admin: settlements console.
- dashboard: Profile card (EditProfile) wired to PATCH /v1/auth/account.
- 1308 tests / 213 suites, typecheck + all app builds green.
2026-06-21 02:04:43 +03:00

143 lines
4.5 KiB
TypeScript

import "server-only";
import { money } from "@settlekit/common";
import {
createDb,
createRepository,
schema,
type Database,
} from "@settlekit/database";
import type {
AdminDeliveryRun,
AdminEntitlement,
AdminOrganization,
AdminPayment,
AdminSettlement,
AdminWebhookEvent,
} from "./types";
/**
* Optional Postgres-backed read layer. When DATABASE_URL is configured the
* admin pages read live rows through @settlekit/database's typed drizzle
* repositories; otherwise the in-memory store (store.ts) is used. Reads here
* are real parameterised queries via createRepository — no raw SQL.
*/
let cached: Database | null = null;
export function isDbEnabled(): boolean {
return Boolean(process.env.DATABASE_URL);
}
function db(): Database {
if (!cached) {
const url = process.env.DATABASE_URL;
if (!url) throw new Error("DATABASE_URL is not configured");
cached = createDb(url, { applicationName: "settlekit-admin", max: 5 });
}
return cached;
}
const toIso = (value: Date | string | null | undefined, fallback: string): string => {
if (value instanceof Date) return value.toISOString();
if (typeof value === "string") return value;
return fallback;
};
export async function dbOrganizations(): Promise<AdminOrganization[]> {
const repo = createRepository(db(), schema.organizations);
const rows = await repo.findMany();
return rows.map((r) => ({
id: r.id,
name: r.name,
slug: r.slug,
status: (r.status as AdminOrganization["status"]) ?? "active",
createdAt: toIso(r.createdAt, new Date(0).toISOString()),
}));
}
export async function dbPayments(): Promise<AdminPayment[]> {
const repo = createRepository(db(), schema.payments);
const rows = await repo.findMany();
return rows.map((r) => ({
id: r.id,
organizationId: r.merchantId,
customerId: r.customerId ?? undefined,
status: (r.status as AdminPayment["status"]) ?? "pending",
amount: money(r.amount, (r.currency as "USDC") ?? "USDC"),
network: r.network,
createdAt: toIso(r.createdAt, new Date(0).toISOString()),
}));
}
export async function dbEntitlements(): Promise<AdminEntitlement[]> {
const repo = createRepository(db(), schema.entitlements);
const rows = await repo.findMany();
return rows.map((r) => ({
id: r.id,
organizationId: r.merchantId,
customerId: r.customerId,
type: r.type,
status: (r.status as AdminEntitlement["status"]) ?? "active",
createdAt: toIso(r.createdAt, new Date(0).toISOString()),
}));
}
export async function dbDeliveryRuns(): Promise<AdminDeliveryRun[]> {
const repo = createRepository(db(), schema.deliveryRuns);
const rows = await repo.findMany();
return rows.map((r) => {
const actionRuns = (r.actionRuns ?? []).map((a) => ({
actionId: a.actionId,
status: a.status,
error: a.error,
}));
const lastError = actionRuns.find((a) => a.error)?.error;
return {
id: r.id,
organizationId: r.merchantId,
paymentId: r.paymentId ?? undefined,
entitlementId: r.entitlementId ?? undefined,
status: (r.status as AdminDeliveryRun["status"]) ?? "pending",
attempt: r.attempt,
actionRuns,
lastError,
createdAt: toIso(r.createdAt, new Date(0).toISOString()),
updatedAt: toIso(r.updatedAt, new Date(0).toISOString()),
};
});
}
export async function dbSettlements(): Promise<AdminSettlement[]> {
const repo = createRepository(db(), schema.payouts);
const rows = await repo.findMany();
return rows.map((r) => ({
id: r.id,
organizationId: r.organizationId,
status: (r.status as AdminSettlement["status"]) ?? "pending",
amount: money(r.amount, (r.currency as "USDC") ?? "USDC"),
network: r.network,
// payouts has no reference column; derive a stable, non-empty value.
reference: `stl_${r.id}`,
txHash: r.txHash ?? undefined,
createdAt: toIso(r.createdAt, new Date(0).toISOString()),
updatedAt: toIso(r.updatedAt, new Date(0).toISOString()),
}));
}
export async function dbWebhookEvents(): Promise<AdminWebhookEvent[]> {
const repo = createRepository(db(), schema.webhookEvents);
const rows = await repo.findMany();
return rows.map((r) => ({
id: r.id,
organizationId: r.merchantId,
type: r.type,
endpointUrl: r.endpointId ?? "",
payload: r.payload ?? {},
delivered: r.delivered,
attempts: r.attempts,
lastError: r.lastError ?? undefined,
createdAt: toIso(r.createdAt, new Date(0).toISOString()),
deliveredAt: r.deliveredAt ? toIso(r.deliveredAt, "") : undefined,
}));
}