Project Overview

• Project Name: RestroSync for Pizza Station
• Description: A restaurant management web app that handles pizza orders, menu updates, user accounts, and dashboard analytics for Pizza Station.
• Live URL: https://restrosync.lovable.app
• Software Requirements Specification (SRS) Document
  Comprehensive documentation of project scope, features, and requirements.
• Repository: https://github.com/AbrarBb/RestroSync-for-Pizza-Station

Tech Stack

Layer	Technology
Frontend	React (TypeScript), Tailwind CSS, shadcn-ui, Vite
Backend	Supabase (PostgreSQL, Auth, Realtime)
Manager	Bun
Hosting	Lovable (Frontend), Supabase (Backend)

Folder Structure

RestroSync-for-Pizza-Station/
├── public/                 # Static assets like icons, images
├── src/                    # Source code
│   ├── components/         # Reusable UI components
│   ├── pages/              # Main views (Menu, Orders, Dashboard, etc.)
│   ├── services/           # Supabase API interactions
│   ├── lib/                # Utility functions and helpers
│   ├── hooks/              # Custom React hooks
│   ├── context/            # Global contexts (e.g., AuthContext)
│   ├── App.tsx             # App entry and route definitions
│   └── main.tsx            # Main app rendering
├── .env                    # Environment variables (not committed)
├── index.html              # Root HTML file
├── tailwind.config.ts      # Tailwind CSS configuration
├── vite.config.ts          # Vite development configuration
├── tsconfig.json           # TypeScript configuration
├── bun.lockb               # Bun package lock file
└── README.md               # Project documentation

Supabase Schema Overview

The backend uses Supabase, a backend-as-a-service platform built on PostgreSQL. Below is an overview of the primary database tables:

users Table

Column Name	Data Type	Description
id	UUID	Primary key, unique user ID
email	TEXT	User's email address
role	TEXT	User role (admin, staff)

menu_items Table

Column Name	Data Type	Description
id	UUID	Primary key, unique item ID
name	TEXT	Name of the menu item
description	TEXT	Description of the item
price	NUMERIC	Price of the item
available	BOOLEAN	Whether the item is available
image_url	TEXT	URL to an image of the menu item

orders Table

Column Name	Data Type	Description
id	UUID	Primary key, unique order ID
user_id	UUID	Foreign key referencing users.id
items	JSONB	List of ordered items with quantity and item ID
status	TEXT	Order status (pending, preparing, ready, delivered)
created_at	TIMESTAMP	Timestamp when the order was placed

Authentication

• Uses Supabase Auth (email/password)

• Managed via AuthContext in src/context/AuthContext.tsx

const session = await supabase.auth.getSession();

Realtime Features

Orders update in real-time using Supabase subscriptions:

codesupabase .channel('orders') .on('postgres_changes', { event: '*', schema: 'public', table: 'orders' }, callback) .subscribe();

UI/UX Details

• Tailwind CSS for responsive design

• shadcn/ui for UI components (alerts, buttons, modals)

• Optimized for tablets and smartphones

  

Deployment (Production)

Frontend

• Hosted on Lovable

• Live URL: https://restrosync.lovable.app

Backend

• Hosted on Supabase

• Uses Supabase Database, Auth, and Realtime

Contribution Guide

1. Fork the repository

2. Create a new branch: git checkout -b feature/your-feature

3. Make changes and commit: git commit -m "Add feature"

4. Push to GitHub: git push origin feature/your-feature

5. Submit a pull request

Documentation Links

• Live App
  Access the deployed RestroSync application for Pizza Station.

• Software Requirements Specification (SRS) Document
  Comprehensive documentation of project scope, features, and requirements.

• Supabase Documentation
  Learn more about the backend services used, including Auth, Database, and Realtime.

• shadcn/ui Documentation
  Reference for UI components used throughout the application.

Future Improvements

• Add unit and integration testing

• Implement role-based UI rendering

• Add receipt printing integration

• Add analytics dashboards

• Enable offline mode using local storage

SQA Analysis List: