Inventario inteligente

// lib/services/inventory.service.ts
import { prisma } from '@/lib/prisma'

export async function getLowStockItems(businessId: string) {
  return prisma.inventory.findMany({
    where: {
      businessId,           // multi-tenant SIEMPRE
      isActive: true,
      // stock actual <= mínimo configurado
      stockQuantity: {
        lte: prisma.inventory.fields.stockMinimum,
      },
    },
    orderBy: { stockQuantity: 'asc' },
    select: {
      id: true,
      name: true,
      sku: true,
      stockQuantity: true,
      stockMinimum: true,
      costPrice: true,    // Decimal — nunca float
    },
  })
}