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

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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

async function checkADWTeam() {
  try {
    console.log('🔍 Checking ADW team status...\n');

    // Check law firm
    const lawFirm = await prisma.lawFirm.findFirst({
      where: { name: 'ADW Avocats' }
    });

    if (lawFirm) {
      console.log('✅ Law Firm found:');
      console.log(`   Name: ${lawFirm.name}`);
      console.log(`   Address: ${lawFirm.address}, ${lawFirm.city}, ${lawFirm.province} ${lawFirm.postalCode}`);
      console.log(`   Phone: ${lawFirm.phone}`);
      console.log(`   Email: ${lawFirm.email}`);
      console.log(`   Website: ${lawFirm.website}`);
      console.log(`   Active: ${lawFirm.isActive}`);
      console.log('');
    } else {
      console.log('❌ Law Firm not found');
      return;
    }

    // Check team members
    const teamMembers = await prisma.user.findMany({
      where: { lawFirmId: lawFirm.id },
      select: {
        id: true,
        name: true,
        email: true,
        role: true,
        title: true,
        specialization: true,
        yearsOfExperience: true,
        bio: true,
        workPhone: true,
        officeLocation: true,
        isProfilePublic: true,
        isVerified: true,
        profilePicture: true,
        barNumber: true,
        education: true
      }
    });

    console.log(`📊 Team Members (${teamMembers.length}):`);
    teamMembers.forEach((member, index) => {
      console.log(`\n${index + 1}. ${member.name}`);
      console.log(`   Email: ${member.email}`);
      console.log(`   Role: ${member.role}`);
      console.log(`   Title: ${member.title || 'N/A'}`);
      console.log(`   Specialization: ${member.specialization || 'N/A'}`);
      console.log(`   Years Experience: ${member.yearsOfExperience || 'N/A'}`);
      console.log(`   Phone: ${member.workPhone || 'N/A'}`);
      console.log(`   Office: ${member.officeLocation || 'N/A'}`);
      console.log(`   Public Profile: ${member.isProfilePublic ? '✅ Yes' : '❌ No'}`);
      console.log(`   Verified: ${member.isVerified ? '✅ Yes' : '❌ No'}`);
      console.log(`   Profile Picture: ${member.profilePicture || 'N/A'}`);
      console.log(`   Bar Number: ${member.barNumber || 'N/A'}`);
      console.log(`   Education: ${member.education || 'N/A'}`);
      if (member.bio) {
        console.log(`   Bio: ${member.bio.substring(0, 100)}...`);
      }
    });

    // Check business profile
    const businessProfile = await prisma.businessProfile.findFirst({
      where: { businessName: 'ADW Avocats' }
    });

    if (businessProfile) {
      console.log('\n✅ Business Profile found:');
      console.log(`   Name: ${businessProfile.businessName}`);
      console.log(`   Type: ${businessProfile.businessType}`);
      console.log(`   Industry: ${businessProfile.industry}`);
      console.log(`   Public: ${businessProfile.isPublic ? '✅ Yes' : '❌ No'}`);
      console.log(`   Verified: ${businessProfile.isVerified ? '✅ Yes' : '❌ No'}`);
      console.log(`   Phone: ${businessProfile.phone}`);
      console.log(`   Email: ${businessProfile.email}`);
      console.log(`   Website: ${businessProfile.website}`);
      console.log(`   Address: ${businessProfile.address}`);
    } else {
      console.log('\n❌ Business Profile not found');
    }

    // Check for demo users
    const demoUsers = await prisma.user.findMany({
      where: {
        email: {
          in: ['demo@example.com', 'test@example.com', 'lawyer@example.com', 'client@example.com', 'admin@example.com']
        }
      },
      select: {
        name: true,
        email: true,
        isProfilePublic: true
      }
    });

    console.log('\n📋 Demo Users Status:');
    if (demoUsers.length > 0) {
      demoUsers.forEach(user => {
        console.log(`   ${user.name} (${user.email}): ${user.isProfilePublic ? '❌ Still Public' : '✅ Deactivated'}`);
      });
    } else {
      console.log('   ✅ No demo users found');
    }

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

checkADWTeam();