import Link from 'next/link'; import { prisma } from '@/lib/db'; import { templateById } from '@/lib/templates'; import { voiceById } from '@/lib/voices'; import { planById } from '@/lib/plans'; import { StatusBadge } from '@/components/StatusBadge'; import { AHead, Bars, Dist, Panel, Stat } from '@/components/admin/ui'; import { PERIODS, day, dt, dur, n, pct, since, tryFmt } from '@/lib/admin'; import { apShort } from '@/lib/ap'; export default async function Overview({ searchParams }: { searchParams: Promise<{ d?: string }> }) { const { d = '30' } = await searchParams; const from = since(d); const inP = from ? { createdAt: { gte: from } } : {}; const days = d === '0' ? 90 : d === '1' ? 14 : Number(d); // grafik: İstanbul gece yarısına hizalı tam günler const seriesFrom = new Date(since('1')!.getTime() - (days - 1) * 86400_000); const stale = new Date(Date.now() - 45 * 60_000); const [orders, byStatus, rev, paysAll, paysOk, users, verified, credits, delivered, jobs, byTpl, byPlan, byIl, byVoice, dOrders, dRev, failed, stuck, latest, signups, lastDone, refUsers] = await Promise.all([ prisma.order.count({ where: inP }), prisma.order.groupBy({ by: ['status'], where: inP, _count: true }), prisma.payment.aggregate({ where: { ...inP, status: 'succeeded', plan: { not: 'admin' } }, _sum: { amount: true }, _count: true }), prisma.payment.count({ where: { ...inP, plan: { not: 'admin' } } }), prisma.payment.count({ where: { ...inP, plan: { not: 'admin' }, status: 'succeeded' } }), prisma.user.count({ where: inP }), prisma.user.count({ where: { ...inP, emailVerifiedAt: { not: null } } }), prisma.user.aggregate({ _sum: { credits: true } }), prisma.order.findMany({ where: { ...inP, status: 'DELIVERED', deliveredAt: { not: null } }, select: { createdAt: true, deliveredAt: true }, take: 3000, orderBy: { createdAt: 'desc' } }), prisma.job.groupBy({ by: ['status'], _count: true }), prisma.order.groupBy({ by: ['template'], where: inP, _count: true }), prisma.order.groupBy({ by: ['plan'], where: inP, _count: true }), prisma.order.groupBy({ by: ['il'], where: inP, _count: true, orderBy: { _count: { il: 'desc' } }, take: 10 }), prisma.order.groupBy({ by: ['voice'], where: inP, _count: true }), prisma.$queryRaw<{ d: string; v: number }[]>`SELECT to_char("createdAt" + interval '3 hours', 'YYYY-MM-DD') d, count(*)::int v FROM "Order" WHERE "createdAt" >= ${seriesFrom} GROUP BY 1`, prisma.$queryRaw<{ d: string; v: number }[]>`SELECT to_char("createdAt" + interval '3 hours', 'YYYY-MM-DD') d, coalesce(sum(amount),0)::int v FROM "Payment" WHERE status = 'succeeded' AND plan <> 'admin' AND "createdAt" >= ${seriesFrom} GROUP BY 1`, prisma.order.findMany({ where: { status: 'FAILED' }, orderBy: { updatedAt: 'desc' }, take: 6, select: { id: true, code: true, error: true, updatedAt: true } }), prisma.order.findMany({ where: { status: 'RENDERING', updatedAt: { lt: stale } }, orderBy: { updatedAt: 'asc' }, take: 6, select: { id: true, code: true, progress: true, progressMsg: true, updatedAt: true, claimedBy: true } }), prisma.order.findMany({ orderBy: { createdAt: 'desc' }, take: 8, select: { id: true, code: true, ada: true, parsel: true, mahalle: true, ilce: true, status: true, createdAt: true, user: { select: { email: true } } } }), prisma.user.findMany({ orderBy: { createdAt: 'desc' }, take: 6, select: { id: true, email: true, name: true, company: true, createdAt: true, emailVerifiedAt: true } }), prisma.order.findFirst({ where: { status: 'DELIVERED' }, orderBy: { deliveredAt: 'desc' }, select: { deliveredAt: true } }), prisma.user.count({ where: { ...inP, referredById: { not: null } } }), ]); const st = (k: string) => byStatus.find((x) => x.status === k)?._count ?? 0; const jb = (k: string) => jobs.find((x) => x.status === k)?._count ?? 0; const times = delivered.map((o) => o.deliveredAt!.getTime() - o.createdAt.getTime()).sort((a, b) => a - b); const median = times.length ? times[Math.floor(times.length / 2)] : 0; const finished = st('DELIVERED') + st('FAILED'); const series = (rows: { d: string; v: number }[]) => Array.from({ length: days }, (_, i) => { const t = new Date(seriesFrom.getTime() + i * 86400_000 + 3 * 3600_000); const k = t.toISOString().slice(0, 10); return { label: day(new Date(t.getTime() - 3 * 3600_000)), v: rows.find((r) => r.d === k)?.v ?? 0 }; }); const revenue = rev._sum.amount ?? 0; return (
{PERIODS.map(([k, l]) => {l})}
`${x} sipariş`} /> tryFmt(x)} color="#FF6A1F" />
Ayrıntı}>
{([['Kuyrukta', 'queued'], ['Üretiliyor', 'running'], ['Harici ajan', 'external'], ['Ölü kuyruk', 'dead']] as const).map(([l, k]) => (
{l}
{jb(k)}
))}

Son teslim: {dt(lastDone?.deliveredAt)}

 ({ label: templateById(x.template).name, v: x._count })).sort((a, b) => b.v - a.v)} /> ({ label: planById(x.plan)?.name || x.plan, v: x._count })).sort((a, b) => b.v - a.v)} /> ({ label: voiceById(x.voice).name, v: x._count })).sort((a, b) => b.v - a.v)} />
({ label: x.il, v: x._count, href: `/krtf1krtf/siparisler?q=${encodeURIComponent(x.il)}` }))} /> 45 dk+ güncellenmeyen} pad={false}> {stuck.length ?
    {stuck.map((o) => (
  • {o.code} %{o.progress} · {o.progressMsg}{o.claimedBy ? ` · ${o.claimedBy}` : ''}son güncelleme {dt(o.updatedAt)}
    • ))}
:

Takılan üretim yok.

} Tümü} pad={false}> {failed.length ?
    {failed.map((o) => (
  • {o.code} {dt(o.updatedAt)}{o.error || 'hata kaydı yok'}
    • ))}
:

Başarısız sipariş yok.

}
Tümü} pad={false}>
    {latest.map((o) => (
  • {apShort(o.ada, o.parsel)} {o.mahalle}, {o.ilce} {o.code} · {o.user.email} · {dt(o.createdAt)}
    • ))}
 Tümü} pad={false}>
    {signups.map((u) => (
  • {u.company || u.name}{!u.emailVerifiedAt && doğrulanmadı}{u.email} · {dt(u.createdAt)}
    • ))}
); }