Function matchesRule

packages/shared-domain/src/database-transforms.ts:35–70

(row: DbRow, rule: FilterRule, field: DbField | undefined)

// ---------------------------------------------------------------------------

function matchesRule(row: DbRow, rule: FilterRule, field: DbField | undefined): boolean {
  if (!field) return true
  const raw = cell(row, field.id)
  const v = raw.trim()
  const target = (rule.value ?? '').trim()
  switch (rule.op) {
    case 'is':
      if (field.type === 'multiSelect') return splitMultiSelect(raw).includes(target)
      return v.toLowerCase() === target.toLowerCase()
    case 'isNot':
      if (field.type === 'multiSelect') return !splitMultiSelect(raw).includes(target)
      return v.toLowerCase() !== target.toLowerCase()
    case 'contains':
      return v.toLowerCase().includes(target.toLowerCase())
    case 'notContains':
      return !v.toLowerCase().includes(target.toLowerCase())
    case 'isEmpty':
      return v.length === 0
    case 'isNotEmpty':
      return v.length > 0
    case 'gt':
      return Number(v) > Number(target)
    case 'lt':
      return Number(v) < Number(target)
    case 'before':
      return v.length > 0 && v < target
    case 'after':
      return v.length > 0 && v > target
    case 'checked':
      return isCheckboxTrue(raw)
    case 'unchecked':
      return !isCheckboxTrue(raw)
    default:
      return true
  }
}

export function filterRows(
  rows: DbRow[],