Skip to content

The Open Source DocuSign Alternative.

872 B
Raw Blame
import { prisma } from '@documenso/prisma';
import { ExtendedDocumentStatus } from '@documenso/prisma/types/extended-document-status';
import { EnvelopeType } from '@prisma/client';

export const getDocumentStats = async () => {
  const counts = await prisma.envelope.groupBy({
    where: {
      type: EnvelopeType.DOCUMENT,
    },
    by: ['status'],
    _count: {
      _all: true,
    },
  });

  const stats: Record<Exclude<ExtendedDocumentStatus, 'INBOX' | 'EXPIRED'>, number> = {
    [ExtendedDocumentStatus.DRAFT]: 0,
    [ExtendedDocumentStatus.PENDING]: 0,
    [ExtendedDocumentStatus.COMPLETED]: 0,
    [ExtendedDocumentStatus.REJECTED]: 0,
    [ExtendedDocumentStatus.CANCELLED]: 0,
    [ExtendedDocumentStatus.ALL]: 0,
  };

  counts.forEach((stat) => {
    stats[stat.status] = stat._count._all;

    stats.ALL += stat._count._all;
  });

  return stats;
};