The Open Source DocuSign Alternative.
TypeScript digital-signaturedocument-signingdocusign-alternativee-signatureesignesignaturenext-authnextjsopen-sourcepades-standardpdfpdf-signpdf-signaturepostgresqlprismaself-hostedsigningtypescript
import { prisma } from '@documenso/prisma';
import { SigningStatus } from '@prisma/client';
export type GetCompletedFieldsForDocumentOptions = {
documentId: number;
};
export const getCompletedFieldsForDocument = async ({ documentId }: GetCompletedFieldsForDocumentOptions) => {
return await prisma.field.findMany({
where: {
documentId,
recipient: {
signingStatus: SigningStatus.SIGNED,
},
inserted: true,
},
include: {
signature: true,
recipient: {
select: {
name: true,
email: true,
},
},
},
});
};