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/public_html/scripts/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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

const prisma = new PrismaClient();

async function clearImpersonationData() {
  try {
    console.log('🔍 Checking for impersonation data...');
    
    // Find all users with reminders (impersonation data)
    const usersWithReminders = await prisma.user.findMany({
      where: {
        reminders: {
          not: null
        }
      },
      select: {
        id: true,
        email: true,
        name: true,
        role: true,
        reminders: true
      }
    });

    console.log(`📋 Found ${usersWithReminders.length} users with reminders data:`);
    
    for (const user of usersWithReminders) {
      console.log(`- ${user.name} (${user.email}) - Role: ${user.role}`);
      try {
        const reminderData = JSON.parse(user.reminders);
        console.log(`  Reminder data:`, reminderData);
      } catch {
        console.log(`  Non-JSON reminder data: ${user.reminders}`);
      }
    }

    if (usersWithReminders.length > 0) {
      console.log('\n🧹 Clearing all reminders/impersonation data...');
      
      const result = await prisma.user.updateMany({
        where: {
          reminders: {
            not: null
          }
        },
        data: {
          reminders: null
        }
      });

      console.log(`✅ Cleared reminders from ${result.count} users`);
    } else {
      console.log('✅ No impersonation data found');
    }

    // Also check for specific SUPERADMIN user (Danny PEREZ)
    const danny = await prisma.user.findUnique({
      where: {
        email: 'dannywperez@msn.com'
      },
      select: {
        id: true,
        email: true,
        name: true,
        role: true,
        reminders: true
      }
    });

    if (danny) {
      console.log('\n👑 Danny PEREZ status:');
      console.log(`  ID: ${danny.id}`);
      console.log(`  Email: ${danny.email}`);
      console.log(`  Role: ${danny.role}`);
      console.log(`  Reminders: ${danny.reminders || 'null'}`);
    } else {
      console.log('\n❌ Danny PEREZ not found in database');
    }

    console.log('\n🔄 Impersonation cleanup complete!');
    
  } catch (error) {
    console.error('❌ Error clearing impersonation data:', error);
  } finally {
    await prisma.$disconnect();
  }
}

clearImpersonationData();