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

// Set your business profile ID here
const BUSINESS_ID = 'cmcqfih0g0001vjoolt160sup'; // <-- Change this to your business ID

async function setAllMembersPublic() {
  try {
    const business = await prisma.businessProfile.findUnique({
      where: { id: BUSINESS_ID },
      include: {
        owner: true,
        members: true
      }
    });

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

    // Update owner
    if (business.owner && !business.owner.isProfilePublic) {
      await prisma.user.update({
        where: { id: business.owner.id },
        data: { isProfilePublic: true }
      });
      console.log(`Set owner ${business.owner.name} public.`);
    }

    // Update all members
    for (const member of business.members) {
      if (!member.isProfilePublic) {
        await prisma.user.update({
          where: { id: member.id },
          data: { isProfilePublic: true }
        });
        console.log(`Set member ${member.name} public.`);
      }
    }

    console.log('All business members set to public!');
  } catch (error) {
    console.error('Error updating members:', error);
  } finally {
    await prisma.$disconnect();
  }
}

setAllMembersPublic();