Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/lavocat.ca/private_html/scripts/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

const { PrismaClient } = require('@prisma/client');

const prisma = new PrismaClient();

async function getRegistrationUrl() {
  try {
    console.log('🔍 Finding registration for SUPERADMIN...\n');

    // Get the SUPERADMIN user
    const superadmin = await prisma.user.findFirst({
      where: { role: 'SUPERADMIN' }
    });

    if (!superadmin) {
      console.log('❌ No SUPERADMIN user found');
      return;
    }

    console.log(`👑 SUPERADMIN: ${superadmin.name} (${superadmin.email}) - ID: ${superadmin.id}\n`);

    // Find the registration for this SUPERADMIN
    const registration = await prisma.registration.findFirst({
      where: {
        OR: [
          { userId: superadmin.id },
          { 
            AND: [
              { userId: null },
              { email: superadmin.email }
            ]
          },
          { 
            AND: [
              { createdBy: { not: null } },
              { createdBy: superadmin.id }
            ]
          }
        ]
      },
      include: {
        legalCase: true
      }
    });

    if (!registration) {
      console.log('❌ No registration found for SUPERADMIN');
      return;
    }

    console.log('📋 Registration found:');
    console.log(`   ID: ${registration.id}`);
    console.log(`   Name: ${registration.firstName} ${registration.lastName}`);
    console.log(`   Email: ${registration.email}`);
    console.log(`   Status: ${registration.status}`);
    console.log(`   Case: ${registration.legalCase?.title || 'No case'}`);
    console.log(`   Case ID: ${registration.legalCase?.id || 'No case ID'}`);
    console.log(`   Created: ${registration.createdAt}`);
    console.log(`   Updated: ${registration.updatedAt}`);

    console.log('\n🔗 Correct URLs:');
    console.log(`   Admin registration page: /admin/registrations/${registration.id}`);
    console.log(`   User application page: /user/applications/${registration.id}`);
    console.log(`   Admin case page: /admin/cases/${registration.legalCase?.id || 'NO_CASE_ID'}`);

    // Also check if there are any other registrations
    const allRegistrations = await prisma.registration.findMany({
      include: {
        legalCase: true,
        user: true
      }
    });

    console.log('\n📊 All registrations in database:');
    allRegistrations.forEach((reg, index) => {
      console.log(`\n${index + 1}. Registration ID: ${reg.id}`);
      console.log(`   Name: ${reg.firstName} ${reg.lastName}`);
      console.log(`   Email: ${reg.email}`);
      console.log(`   Status: ${reg.status}`);
      console.log(`   userId: ${reg.userId}`);
      console.log(`   createdBy: ${reg.createdBy}`);
      console.log(`   Case: ${reg.legalCase?.title || 'No case'}`);
      console.log(`   Case ID: ${reg.legalCase?.id || 'No case ID'}`);
      console.log(`   User: ${reg.user?.name || 'No user'}`);
    });

  } catch (error) {
    console.error('❌ Error:', error);
  } finally {
    await prisma.$disconnect();
  }
}

getRegistrationUrl();