Example of a query that supports text search

[flybayer]

Maybe this will help someone :)

import { Ctx } from "blitz"
import db, { FindManyOrderArgs, OrderWhereInput } from "db"

type GetOrdersInput = Pick<FindManyOrderArgs, "orderBy" | "skip" | "take"> & {
  search?: string
}

export default async function getOrders(
  { orderBy, skip = 0, take, search }: GetOrdersInput,
  { session }: Ctx
) {
  session.authorize("admin")

  let where: OrderWhereInput = {}

  if (search) {
    const words = search.split(" ")
    if (words.length === 2) {
      // Assume searching for first + last name
      where = {
        customer: {
          AND: [
            { firstName: { contains: words[0], mode: "insensitive" } },
            { lastName: { contains: words[1], mode: "insensitive" } },
          ],
        },
      }
    } else {
      where = {
        customer: {
          OR: [
            { firstName: { contains: search, mode: "insensitive" } },
            { lastName: { contains: search, mode: "insensitive" } },
            { email: { contains: search, mode: "insensitive" } },
            { phone: { contains: search, mode: "insensitive" } },
          ],
        },
      }
    }
  }

  const orders = await db.order.findMany({
    where,
    orderBy,
    take,
    skip,
    include: {
      customer: true,
      bookingOrders: {
        orderBy: { bookingId: "asc" },
        include: {
          booking: true,
        },
      },
    },
  })

  const count = await db.order.count({ where })
  const hasMore = typeof take === "number" ? skip + take < count : false
  const nextPage = hasMore ? { take, skip: skip + take! } : null

  return {
    orders,
    nextPage,
    hasMore,
    count,
  }
}