Queries

Copyimport "server-only"
 
import type { Prisma } from "@prisma/client"
 
import { db } from "@/lib/db"
 
const teacherListSelect = {
  id: true,
  firstName: true,
  lastName: true,
  email: true,
  phone: true,
  active: true,
} as const
 
export interface TeacherQueryParams {
  q?: string
  active?: boolean
  page?: number
  pageSize?: number
}
 
export async function getTeacherList(
  schoolId: string,
  params: Partial<TeacherQueryParams> = {}
) {
  const { q, active, page = 1, pageSize = 20 } = params
  const where: Prisma.TeacherWhereInput = {
    schoolId,
    ...(active !== undefined && { active }),
    ...(q && {
      OR: [{ firstName: { contains: q } }, { lastName: { contains: q } }],
    }),
  }
 
  const [data, total] = await Promise.all([
    db.teacher.findMany({
      where,
      select: teacherListSelect,
      skip: (page - 1) * pageSize,
      take: pageSize,
      orderBy: { lastName: "asc" },
    }),
    db.teacher.count({ where }),
  ])
 
  return { data, total, page, pageSize }
}
 
export async function getTeacherDetail(schoolId: string, id: string) {
  return db.teacher.findUnique({
    where: { id_schoolId: { id, schoolId } },
    select: { ...teacherListSelect, qualifications: true, classes: true },
  })
}