documenso/packages/lib/server-only/recipient/get-next-pending-recipient.ts

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

import { mapDocumentIdToSecondaryId } from '../../utils/envelope';

export const getNextPendingRecipient = async ({
  documentId,
  currentRecipientId,
}: {
  documentId: number;
  currentRecipientId: number;
}) => {
  const recipients = await prisma.recipient.findMany({
    where: {
      envelope: {
        type: EnvelopeType.DOCUMENT,
        secondaryId: mapDocumentIdToSecondaryId(documentId),
      },
    },
    orderBy: [
      {
        signingOrder: {
          sort: 'asc',
          nulls: 'last',
        },
      },
      {
        id: 'asc',
      },
    ],
  });

  const currentIndex = recipients.findIndex((r) => r.id === currentRecipientId);

  if (currentIndex === -1 || currentIndex === recipients.length - 1) {
    return null;
  }

  return {
    ...recipients[currentIndex + 1],
    token: '',
  };
};