Method findWithStats

apps/web/services/channels/index.ts:78–112

(
    communityId: string
  )

  }

  static async findWithStats(
    communityId: string
  ): Promise<findChannelsWithStats> {
    return await prisma.channels
      .findMany({
        include: {
          _count: { select: { threads: true } },
          threads: {
            take: 1,
            orderBy: { sentAt: 'desc' },
            select: { sentAt: true },
          },
        },
        where: {
          accountId: communityId,
          type: { not: ChannelType.DM },
        },
      })
      .then((channels) =>
        channels.map(({ threads, _count, ...rest }) => {
          const lastThreadAt = threads.find(Boolean)?.sentAt;
          const threadCount = _count.threads;

          let stats = `${threadCount} thread${threadCount > 1 ? 's' : ''}`;

          if (lastThreadAt) {
            const date = new Date(
              Math.floor(Number(lastThreadAt))
            ).toISOString();
            stats += `, latest from ${formatDistance(date)}`;
          }
          return { ...serializeChannel(rest), stats };
        })
      );
  }

  static async setDefaultChannels({
    channelIds,