import { db } from '../../lib/prisma';

/**
 * Find an employee living here by name, employee ID or room (Sprint 3,
 * shared from Sprint 5): for desks whose staff cannot open the residents
 * list — the laundry desk, the events desk. Ten at most; names only.
 */
export async function findEmployees(q: string, propertyId?: string) {
  const rows = await db.studentProfile.findMany({
    where: {
      residencyStatus: { not: 'VACATED' },
      ...(propertyId ? { propertyId } : {}),
      OR: [
        { user: { name: { contains: q, mode: 'insensitive' } } },
        { employeeCode: { contains: q, mode: 'insensitive' } },
        { bed: { room: { number: { contains: q, mode: 'insensitive' } } } },
      ],
    },
    select: { id: true, employeeCode: true, user: { select: { name: true } }, bed: { select: { label: true, room: { select: { number: true } } } } },
    orderBy: { user: { name: 'asc' } },
    take: 10,
  });
  return rows.map((r) => ({ id: r.id, name: r.user.name, employeeCode: r.employeeCode, room: r.bed ? `Room ${r.bed.room.number} · Bed ${r.bed.label}` : null }));
}
