Wild Oasis Admin Dashboard 🏨

A comprehensive hotel management system for property administrators to manage bookings, cabins, and guest information.

Project Overview

Core Features

1. Authentication System

• Role-based access control (Admin/Staff)
• Password reset flow
• Session timeout handling

2. Booking Management

• Calendar view of reservations
• Check-in/out operations
• Guest details editing
• Booking search/filter

3. Cabin Configuration

• Add/edit/delete cabins
• Upload cabin photos
• Set pricing rules
• Manage amenities

4. Dashboard Analytics

• Occupancy rates
• Revenue charts
• Guest demographics
• Performance metrics

Technical Implementation

Database Schema (Supabase)

-- Cabins table
CREATE TABLE cabins (
  id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  max_capacity INTEGER NOT NULL,
  regular_price NUMERIC NOT NULL,
  discount NUMERIC DEFAULT 0,
  image_url TEXT
);

-- Bookings table
CREATE TABLE bookings (
  id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  cabin_id BIGINT REFERENCES cabins(id),
  guest_id BIGINT REFERENCES guests(id),
  start_date DATE NOT NULL,
  end_date DATE NOT NULL,
  status VARCHAR(20) CHECK (
    status IN ('unconfirmed', 'confirmed', 'checked-in', 'checked-out')
  )
);