Nos services web

final class Contact
{
    public string $email {
        set(string $value) {
            if (!filter_var($value, FILTER_VALIDATE_EMAIL)) {
                throw new InvalidArgumentException('E-mail invalide');
            }
            $this->email = strtolower($value);
        }
    }

    public function __construct(
        public readonly int $id,
        string $email,
        public private(set) string $phase = 'nouveau',
    ) {
        $this->email = $email;
    }
}

type Lead = { id: number; name: string; phase: 'nouveau' | 'qualifié' | 'client' };

export async function fetchLeads(signal?: AbortSignal): Promise<Lead[]> {
  const res = await fetch('/api/leads?limit=50', {
    headers: { Accept: 'application/json' },
    signal,
  });
  if (!res.ok) throw new Error(`API ${res.status}`);
  return (await res.json()) as Lead[];
}

CREATE INDEX idx_contacts_phase_maj
  ON contacts (phase, updated_at DESC);

WITH recents AS (
  SELECT id, nom, phase, updated_at
  FROM contacts
  WHERE updated_at >= NOW() - INTERVAL 30 DAY
)
SELECT phase, COUNT(*) AS total, MAX(updated_at) AS derniere_activite
FROM recents
GROUP BY phase
ORDER BY total DESC;

.card-list { container-type: inline-size; }

.card {
  display: grid;
  gap: .75rem;
  &:has(img) { grid-template-columns: 8rem 1fr; }

  @container (width < 30rem) {
    grid-template-columns: 1fr;
  }
}

@media (prefers-reduced-motion: no-preference) {
  .card { transition: transform .2s ease; }
}