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();

const BUSINESS_ID = 'cmcqfih0g0001vjoolt160sup';

async function main() {
  try {
    // Fetch the business profile with all related data
    const business = await prisma.businessProfile.findUnique({
      where: { id: BUSINESS_ID },
      include: {
        owner: {
          select: {
            id: true,
            name: true,
            email: true,
            role: true,
            isProfilePublic: true,
            profilePicture: true,
            specialization: true,
            yearsOfExperience: true,
            totalCases: true,
            wonCases: true,
            lostCases: true,
            averageRating: true,
            hourlyRate: true,
            totalBadges: true,
            level: true,
            isVerified: true,
            bio: true,
            username: true
          }
        },
        members: {
          select: {
            id: true,
            name: true,
            email: true,
            role: true,
            isProfilePublic: true,
            profilePicture: true,
            specialization: true,
            yearsOfExperience: true,
            totalCases: true,
            wonCases: true,
            lostCases: true,
            averageRating: true,
            hourlyRate: true,
            totalBadges: true,
            level: true,
            isVerified: true,
            bio: true,
            username: true
          }
        }
      }
    });

    if (!business) {
      console.log('Business profile not found!');
      return;
    }

    console.log('=== BUSINESS PROFILE DATA ===');
    console.log('Business Name:', business.businessName);
    console.log('Business Type:', business.businessType);
    console.log('Industry:', business.industry);
    console.log('Description:', business.description);
    console.log('Website:', business.website);
    console.log('Phone:', business.phone);
    console.log('Email:', business.email);
    console.log('Address:', business.address);
    console.log('Is Public:', business.isPublic);
    console.log('Is Verified:', business.isVerified);
    console.log('');

    console.log('=== OWNER ===');
    if (business.owner) {
      console.log('Name:', business.owner.name);
      console.log('Email:', business.owner.email);
      console.log('Role:', business.owner.role);
      console.log('Is Profile Public:', business.owner.isProfilePublic);
      console.log('Specialization:', business.owner.specialization);
      console.log('Years of Experience:', business.owner.yearsOfExperience);
      console.log('Total Cases:', business.owner.totalCases);
      console.log('Won Cases:', business.owner.wonCases);
      console.log('Lost Cases:', business.owner.lostCases);
      console.log('Average Rating:', business.owner.averageRating);
      console.log('Hourly Rate:', business.owner.hourlyRate);
      console.log('Total Badges:', business.owner.totalBadges);
      console.log('Level:', business.owner.level);
      console.log('Is Verified:', business.owner.isVerified);
      console.log('Bio:', business.owner.bio);
      console.log('Username:', business.owner.username);
    } else {
      console.log('No owner found');
    }
    console.log('');

    console.log('=== MEMBERS ===');
    console.log('Total members:', business.members.length);
    business.members.forEach((member, index) => {
      console.log(`\nMember ${index + 1}:`);
      console.log('  Name:', member.name);
      console.log('  Email:', member.email);
      console.log('  Role:', member.role);
      console.log('  Is Profile Public:', member.isProfilePublic);
      console.log('  Specialization:', member.specialization);
      console.log('  Years of Experience:', member.yearsOfExperience);
      console.log('  Total Cases:', member.totalCases);
      console.log('  Won Cases:', member.wonCases);
      console.log('  Lost Cases:', member.lostCases);
      console.log('  Average Rating:', member.averageRating);
      console.log('  Hourly Rate:', member.hourlyRate);
      console.log('  Total Badges:', member.totalBadges);
      console.log('  Level:', member.level);
      console.log('  Is Verified:', member.isVerified);
      console.log('  Bio:', member.bio);
      console.log('  Username:', member.username);
    });

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

main();