Restaurant Billing System (Python + Streamlit)

Overview

A simple restaurant billing system built with Python, Streamlit UI, and SQLite. Features:

• Menu stored in SQLite (DB/RESTAURANT.DB) and DATA/MENU.CSV
• Order entry (DINE-IN / TAKEAWAY)
• GST calculation, discounts, and payment method recording
• Exports: DATA/SAMPLE_BILLS.JSON, DATA/SALES_REPORT.CSV
• Simple Streamlit UI: UI/MAIN_UI.PY
• Sample images and logo included in DATA/

Setup (local)

1. Clone or unzip the project.
2. Install requirements:

   pip install streamlit pandas pillow

3. Run the app:

   streamlit run UI/MAIN_UI.PY

Files

• DB/RESTAURANT.DB - SQLite database with menu and sample orders
• DATA/MENU.CSV - Sample menu CSV
• DATA/SAMPLE_BILLS.JSON - Sample orders exported
• DATA/SALES_REPORT.CSV - Sales summary CSV
• UI/MAIN_UI.PY - Streamlit UI
• UTILS/DB_UTILS.PY, UTILS/CALCULATOR.PY - helper utilities
• APP.PY - quick entry printout

Test Cases included

• Multiple items order
• GST only
• GST + discount
• UPI vs CASH payments
• Edge case: order without items (UI prevents it but sample stored in DB)

Enjoy!