Skip to content

armgit / dub

Public Imported from GitHub
0

The modern link attribution platform. Loved by world-class engineering teams at Twilio, Zillow, Jobber, Vercel, Raycast, and more.

1.5 KB
Raw Blame
import { sanitizeFullTextSearch } from "@/lib/prisma";
import { getCustomersCountQuerySchema } from "@/lib/zod/schemas/customers";
import { Prisma } from "@prisma/client";
import * as z from "zod/v4";

type CustomerCountFilters = z.infer<typeof getCustomersCountQuerySchema> & {
  workspaceId: string;
};

export function buildCustomerSearchWhere({
  email,
  externalId,
  search: rawSearch,
}: {
  email?: string | null;
  externalId?: string | null;
  search?: string | null;
}): Prisma.CustomerWhereInput {
  if (email) return { email };

  if (externalId) return { externalId };

  const search = rawSearch?.trim();
  if (!search) return {};

  const isExactCustomerIdQuery = /^cus_[a-z0-9]{24,}$/i.test(search);
  if (isExactCustomerIdQuery) return { id: search };

  if (search.includes("@")) return { email: search };

  const q = sanitizeFullTextSearch(search);
  return {
    email: { search: q },
    name: { search: q },
  };
}

export function buildCustomerCountWhere(filters: CustomerCountFilters) {
  const { workspaceId, email, externalId, search, country, linkId, groupBy } =
    filters;

  const customerWhereInput: Prisma.CustomerWhereInput = {
    projectId: workspaceId,
    ...buildCustomerSearchWhere({ email, externalId, search }),
    // only filter by country if not grouping by country
    ...(country &&
      groupBy !== "country" && {
        country,
      }),
    // only filter by linkId if not grouping by linkId
    ...(linkId &&
      groupBy !== "linkId" && {
        linkId,
      }),
  };

  return customerWhereInput;
}