import { prisma } from "../src/lib/prisma";

async function checkAllAppointments() {
  console.log("🔍 Verificando TODAS las citas en la base de datos...\n");
  
  const appointments = await prisma.appointment.findMany({
    include: {
      record: true,
      paciente: {
        select: { name: true, lastname: true }
      }
    },
    orderBy: { createdAt: 'desc' }
  });
  
  console.log(`📊 Total de citas: ${appointments.length}\n`);
  
  appointments.forEach((apt, index) => {
    console.log(`${index + 1}. Cita ID: ${apt.id.slice(-8)}`);
    console.log(`   Paciente: ${apt.paciente?.name} ${apt.paciente?.lastname}`);
    console.log(`   Motivo: ${apt.motivoConsulta.substring(0, 50)}...`);
    console.log(`   recordId: ${apt.recordId || 'NULL'}`);
    console.log(`   Tiene record: ${apt.record ? '✅ SÍ' : '❌ NO'}`);
    console.log(`   Estado: ${apt.estado}`);
    console.log(`   Creada: ${apt.createdAt}`);
    console.log("");
  });
  
  const withRecord = appointments.filter(a => a.record).length;
  const withRecordId = appointments.filter(a => a.recordId).length;
  
  console.log("="
.repeat(60));
  console.log("📋 RESUMEN:");
  console.log("=".repeat(60));
  console.log(`Total: ${appointments.length}`);
  console.log(`Con recordId: ${withRecordId}`);
  console.log(`Con record cargado: ${withRecord}`);
  console.log(`Sin recordId: ${appointments.length - withRecordId}`);
  
  await prisma.$disconnect();
}

checkAllAppointments().catch(console.error);