documenso/packages/lib/server-only/user/get-all-users.ts

import { prisma } from '@documenso/prisma';
import { EnvelopeType, Prisma } from '@prisma/client';

type GetAllUsersProps = {
  username: string;
  email: string;
  page: number;
  perPage: number;
};

export const findUsers = async ({ username = '', email = '', page = 1, perPage = 10 }: GetAllUsersProps) => {
  const whereClause = Prisma.validator<Prisma.UserWhereInput>()({
    OR: [
      {
        name: {
          contains: username,
          mode: 'insensitive',
        },
      },
      {
        email: {
          contains: email,
          mode: 'insensitive',
        },
      },
    ],
  });

  const [users, count] = await Promise.all([
    prisma.user.findMany({
      select: {
        _count: {
          select: {
            envelopes: {
              where: {
                type: EnvelopeType.DOCUMENT,
              },
            },
          },
        },
        id: true,
        name: true,
        email: true,
        roles: true,
      },
      where: whereClause,
      skip: Math.max(page - 1, 0) * perPage,
      take: perPage,
    }),
    prisma.user.count({
      where: whereClause,
    }),
  ]);

  return {
    users: users.map((user) => ({
      ...user,
      documentCount: user._count.envelopes,
    })),
    totalPages: Math.ceil(count / perPage),
  };
};