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

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function listAllUsers() {
  try {
    const users = await prisma.user.findMany({
      select: {
        id: true,
        email: true,
        name: true,
        role: true,
      },
      orderBy: {
        role: 'desc'
      }
    });

    console.log('📋 All Users in Database:');
    console.log('=' .repeat(60));
    
    users.forEach((user, index) => {
      const roleEmoji = getRoleEmoji(user.role);
      console.log(`${index + 1}. ${roleEmoji} ${user.name || 'No Name'}`);
      console.log(`   📧 ${user.email}`);
      console.log(`   🔑 ${user.role}`);
      console.log(`   🆔 ${user.id}`);
      console.log('');
    });

    console.log(`Total users: ${users.length}`);

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

function getRoleEmoji(role: string): string {
  switch (role) {
    case 'SUPERADMIN':
      case 'SUPERADMIN':
      case 'SUPERADMIN': return '👑';
    case 'ADMIN': return '👩‍⚖️';
    case 'LAWYER': return '⚖️';
    case 'SECRETARY': return '📋';
    case 'CLERK': return '📚';
    case 'ASSISTANT': return '🤝';
    case 'USER': return '👤';
    default: return '❓';
  }
}

if (require.main === module) {
  listAllUsers();
}

export { listAllUsers };