Skip to main content

Aliz Vacation Dashboard

Repository

Overview​

An internal web dashboard for Aliz employees to track personal vacation usage, sick leave, overtime balance, and daily work-hour records for the current and past years. Authentication is handled by Firebase Google OAuth and data is served from BigQuery via a Vercel serverless proxy.

Tech Stack​

  • React 19, TypeScript, Vite
  • TailwindCSS v4, shadcn/ui
  • TanStack Query v5 with IndexedDB persistence
  • Firebase Authentication (Google OAuth)
  • Recharts
  • PWA via Workbox
  • Vercel (hosting + serverless API proxy)

Architecture​

The Vercel serverless proxy holds the service-account credentials needed to query BigQuery — they are never exposed to the browser.

Browser (React SPA)
  → Firebase Google OAuth → ID token
  → Vercel serverless proxy (/api/*)
    → BigQuery REST API (GCP)

Key Features​

  • Yearly calendar with colour-coded day types (vacation, sick, public holiday, overtime, normal)
  • Summary stats cards (allocation, used, remaining, sick, overtime balance)
  • Overtime trend chart
  • Per-day dialog with deep-links to Toggl and Google Calendar
  • Offline PWA support with persistent query cache

Getting Started​

Clone the repository and follow the README for setup instructions.