--- export const prerender = false; import { isAuthenticated, ADMIN_COOKIE } from '@admin/lib/admin-auth'; import { buildPersonMetadataIdProjectionSql, buildPersonMetadataIdentitySql, remapPersonMetadataFields, } from '@/lib/catalog-metadata'; interface Env { DB: D1Database } const runtime = Astro.locals.runtime as { env: Env } | undefined; const db = runtime?.env?.DB; if (!db || !await isAuthenticated(Astro.cookies.get(ADMIN_COOKIE)?.value, db)) { return Astro.redirect('/admin/login', 302); } const q = (Astro.url.searchParams.get('q') ?? '').trim(); const typeParam = (Astro.url.searchParams.get('type') ?? 'all').toLowerCase(); const type = typeParam === 'cast' || typeParam === 'crew' ? typeParam : 'all'; const page = Math.max(parseInt(Astro.url.searchParams.get('page') ?? '1', 10) || 1, 1); const limit = 50; const offset = (page - 1) * limit; type CastRow = { person_metadata_id: string | null; person_name: string; credit_type: 'cast' | 'crew'; primary_job: string; credit_count: number; title_count: number; primary_count: number; last_seen: string | null; titles_csv: string | null; }; let rows: CastRow[] = []; let total = 0; let dbError: string | null = null; try { const whereParts: string[] = ['1 = 1']; const whereParams: Array = []; if (q) { whereParts.push('tc.person_name LIKE ?'); whereParams.push(`%${q}%`); } if (type !== 'all') { whereParts.push('tc.credit_type = ?'); whereParams.push(type); } const where = whereParts.join(' AND '); const countSQL = ` SELECT COUNT(*) AS total FROM ( SELECT 1 FROM title_credits tc WHERE ${where} GROUP BY ${buildPersonMetadataIdentitySql('tc')}, tc.person_name, tc.credit_type ) `; const dataSQL = ` SELECT ${buildPersonMetadataIdProjectionSql('tc')}, tc.person_name, tc.credit_type, MAX(CASE WHEN tc.credit_type = 'crew' THEN tc.job ELSE '' END) AS primary_job, COUNT(*) AS credit_count, COUNT(DISTINCT tc.title_id) AS title_count, SUM(CASE WHEN tc.is_primary = 1 THEN 1 ELSE 0 END) AS primary_count, MAX(tc.updated_at) AS last_seen, GROUP_CONCAT(DISTINCT t.title_en) AS titles_csv FROM title_credits tc LEFT JOIN titles t ON t.id = tc.title_id WHERE ${where} GROUP BY ${buildPersonMetadataIdentitySql('tc')}, tc.person_name, tc.credit_type ORDER BY primary_count DESC, title_count DESC, tc.person_name ASC LIMIT ? OFFSET ? `; const [countRes, dataRes] = await db.batch([ db.prepare(countSQL).bind(...whereParams), db.prepare(dataSQL).bind(...whereParams, limit, offset), ]); total = Number((countRes.results[0] as { total?: number } | undefined)?.total ?? 0); rows = (dataRes.results ?? []).map((row) => remapPersonMetadataFields(row as Record)) as CastRow[]; } catch (err) { dbError = String(err); } const totalPages = Math.max(1, Math.ceil(total / limit)); const hasPrev = page > 1; const hasNext = page < totalPages; function queryFor(nextPage: number): string { const params = new URLSearchParams(); if (q) params.set('q', q); if (type !== 'all') params.set('type', type); if (nextPage > 1) params.set('page', String(nextPage)); const qs = params.toString(); return qs ? `?${qs}` : ''; } --- Cast & Credits — CultRoll Admin

Cast & Credits

Aggregated cast and crew mapped from the metadata catalog.

{dbError &&

DB error: {dbError}

}

{total.toLocaleString()} people · page {page} / {totalPages}

{rows.length === 0 && ( )} {rows.map((row) => { const sampleTitles = (row.titles_csv ?? '').split(',').map((x) => x.trim()).filter(Boolean).slice(0, 3).join(' • '); return ( ); })}

Person	Type	Primary Role	Titles	Credits	Primary	Sample Titles	Last Seen
No cast/crew rows found.
{row.person_name} {row.person_metadata_id && ( <> {' '} #{row.person_metadata_id} )}	{row.credit_type}	{row.primary_job \|\| (row.credit_type === 'cast' ? 'Cast' : '—')}	{row.title_count}	{row.credit_count}	{row.primary_count}	{sampleTitles \|\| '—'}	{row.last_seen ? row.last_seen.replace('T', ' ').replace('Z', '') : '—'}