Skip to content

A premium, full-stack cafe management platform that transforms coffee shop operations. Built with PHP & MySQL, featuring real-time order processing, intelligent inventory management, staff performance analytics, and seamless payment integration. Perfect for modern cafes seeking digital transformation.

License

Notifications You must be signed in to change notification settings

TM-Mehrab-Hasan/brewmaster-cafe-system

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

2 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

โ˜• BrewMaster Cafe System

A premium, full-stack cafe management platform that transforms coffee shop operations. Built with PHP & MySQL, featuring real-time order processing, intelligent inventory management, staff performance analytics, and seamless payment integration. Perfect for modern cafes seeking digital transformation.

Cafe Management System MySQL JavaScript CSS3 XAMPP

๐ŸŒŸ Features

๐Ÿ‘ฅ Role-Based Access Control

  • Customer Portal - Order placement, profile management, order history
  • Staff Panel - Order management, payment processing, sales reports, kitchen display
  • Admin Dashboard - Complete system control, inventory management, staff management, analytics

๐Ÿ›’ Customer Features

  • User Registration & Login - Secure authentication system
  • Menu Browsing - Interactive menu with categories and search
  • Order Placement - Real-time cart management with AJAX
  • Order Tracking - Live status updates (pending โ†’ preparing โ†’ ready โ†’ completed)
  • Profile Management - Personal information and order history
  • Responsive Design - Mobile-friendly interface

๐Ÿ‘จโ€๐Ÿ’ผ Staff Features

  • Order Management - View, update, and process customer orders
  • Payment Processing - Multiple payment methods (Cash, Card, Mobile Banking)
  • Receipt Generation - Automatic receipt printing and customer copies
  • Kitchen Display System - Real-time order tracking with audio notifications
  • Personal Sales Reports - Individual performance analytics with charts
  • Sales Analytics - Hourly sales data, payment method breakdown
  • Export Functionality - CSV export for sales data

๐Ÿ”ง Admin Features

  • Staff Management - Approve/reject staff registrations, manage permissions
  • Product Management - Add, edit, delete menu items with categories
  • Inventory Management - Real-time stock tracking with low-stock alerts
  • Stock Movement Tracking - Complete audit trail for inventory changes
  • Sales Dashboard - Comprehensive analytics with Chart.js visualizations
  • Reports Generation - Detailed sales and inventory reports
  • System Configuration - Global settings and thresholds

๐ŸŽฏ Advanced Features

  • Real-time Updates - AJAX-powered dynamic content updates
  • Chart Analytics - Interactive charts for sales and inventory data
  • Stock Alerts - Automated low-stock notifications
  • Audit Trail - Complete logging of all system activities
  • Print Integration - Receipt and report printing capabilities
  • Modern UI/UX - Gradient backgrounds, animations, and responsive design

๐Ÿ—๏ธ Project Structure

BrewMaster Cafe System/
โ”œโ”€โ”€ ๐Ÿ“ admin/                          # Administrator Panel
โ”‚   โ”œโ”€โ”€ admin_login.php                # Admin authentication
โ”‚   โ”œโ”€โ”€ admin_logout.php               # Admin logout handler
โ”‚   โ”œโ”€โ”€ index.php                      # Admin dashboard
โ”‚   โ”œโ”€โ”€ staff_approval.php             # Staff registration approval
โ”‚   โ”œโ”€โ”€ staff_management.php           # Staff account management
โ”‚   โ”œโ”€โ”€ product_management.php         # Menu item management
โ”‚   โ”œโ”€โ”€ inventory.php                  # Inventory management system
โ”‚   โ”œโ”€โ”€ update_stock.php               # Stock update processor
โ”‚   โ”œโ”€โ”€ stock_history.php              # Stock movement history
โ”‚   โ”œโ”€โ”€ stock_report.php               # Inventory reports
โ”‚   โ””โ”€โ”€ reports.php                    # Sales analytics dashboard
โ”‚
โ”œโ”€โ”€ ๐Ÿ“ staff/                          # Staff Panel
โ”‚   โ”œโ”€โ”€ staff_login.php                # Staff authentication
โ”‚   โ”œโ”€โ”€ staff_logout.php               # Staff logout handler
โ”‚   โ”œโ”€โ”€ staff_registration.php         # Staff registration form
โ”‚   โ”œโ”€โ”€ process_staff_registration.php # Registration processor
โ”‚   โ”œโ”€โ”€ index.php                      # Staff dashboard
โ”‚   โ”œโ”€โ”€ order_management.php           # Order processing interface
โ”‚   โ”œโ”€โ”€ payment_processing.php         # Payment handling system
โ”‚   โ”œโ”€โ”€ kitchen_display.php            # Real-time kitchen orders
โ”‚   โ”œโ”€โ”€ get_kitchen_orders.php         # Kitchen data API
โ”‚   โ”œโ”€โ”€ sales_report.php               # Individual sales analytics
โ”‚   โ”œโ”€โ”€ get_staff_chart_data.php       # Sales chart data API
โ”‚   โ””โ”€โ”€ export_sales_csv.php           # Sales data export
โ”‚
โ”œโ”€โ”€ ๐Ÿ“ customer/                       # Customer Portal
โ”‚   โ”œโ”€โ”€ customer_login.php             # Customer authentication
โ”‚   โ”œโ”€โ”€ customer_logout.php            # Customer logout handler
โ”‚   โ”œโ”€โ”€ customer_registration.php      # Customer registration form
โ”‚   โ”œโ”€โ”€ process_customer_registration.php # Registration processor
โ”‚   โ”œโ”€โ”€ index.php                      # Customer dashboard
โ”‚   โ”œโ”€โ”€ menu.php                       # Interactive menu browser
โ”‚   โ”œโ”€โ”€ place_order.php                # Order placement system
โ”‚   โ”œโ”€โ”€ order_history.php              # Personal order history
โ”‚   โ”œโ”€โ”€ customer_profile.php           # Profile management
โ”‚   โ””โ”€โ”€ get_menu_data.php              # Menu data API
โ”‚
โ”œโ”€โ”€ ๐Ÿ“ global/                         # Shared Resources
โ”‚   โ”œโ”€โ”€ ๐Ÿ“ css/
โ”‚   โ”‚   โ””โ”€โ”€ style.css                  # Comprehensive styling
โ”‚   โ”œโ”€โ”€ ๐Ÿ“ js/
โ”‚   โ”‚   โ””โ”€โ”€ main.js                    # Global JavaScript utilities
โ”‚   โ”œโ”€โ”€ ๐Ÿ“ php/
โ”‚   โ”‚   โ”œโ”€โ”€ db_connect.php             # Database connection
โ”‚   โ”‚   โ””โ”€โ”€ cafe_database.sql          # Complete database schema
โ”‚   โ””โ”€โ”€ ๐Ÿ“ images/                     # Static assets
โ”‚
โ”œโ”€โ”€ index.html                         # Landing page
โ”œโ”€โ”€ cafe_database.sql                  # Database setup script
โ”œโ”€โ”€ inventory_setup.sql                # Inventory system setup
โ””โ”€โ”€ README.md                          # Project documentation

๐Ÿ› ๏ธ Technology Stack

Technology Purpose Version
PHP Backend Logic 7.4+
MySQL Database 5.7+
JavaScript Frontend Interactivity ES6+
CSS3 Styling & Animations Latest
AJAX Asynchronous Operations jQuery/Vanilla
Chart.js Data Visualization 3.x
XAMPP Development Environment Latest

๐Ÿ“‹ Prerequisites

  • XAMPP/WAMP/LAMP server environment
  • PHP 7.4 or higher
  • MySQL 5.7 or higher
  • Modern web browser (Chrome, Firefox, Safari, Edge)
  • Text editor/IDE (VS Code, Sublime Text, etc.)

๐Ÿš€ Installation & Setup

1. Clone the Repository

git clone https://github.com/yourusername/brewmaster-cafe-system.git
cd brewmaster-cafe-system

2. Setup XAMPP Environment

  1. Download and install XAMPP
  2. Start Apache and MySQL services
  3. Copy project folder to C:\xampp\htdocs\ (Windows) or /opt/lampp/htdocs/ (Linux)

3. Database Configuration

  1. Open phpMyAdmin (http://localhost/phpmyadmin)
  2. Create a new database named cafe_management
  3. Import the database schema:
    # Navigate to the project directory and import
    mysql -u root -p cafe_management < global/php/cafe_database.sql
    Or use phpMyAdmin's import feature with cafe_database.sql

4. Configure Database Connection

Update global/php/db_connect.php with your database credentials:

<?php
$servername = "localhost";
$username = "root";          // Your MySQL username
$password = "";              // Your MySQL password
$dbname = "cafe_management"; // Database name
?>

5. Access the Application

  • Main Landing Page: http://localhost/brewmaster-cafe-system/
  • Customer Portal: http://localhost/brewmaster-cafe-system/customer/
  • Staff Panel: http://localhost/brewmaster-cafe-system/staff/
  • Admin Dashboard: http://localhost/brewmaster-cafe-system/admin/

๐Ÿ‘ค Default Login Credentials

Admin Account

  • Username: admin
  • Password: admin123
  • Email: admin@cafe.com

Test Staff Account

  • Email: mike@cafe.com
  • Password: password123
  • Status: Approved

Test Customer Account

  • Email: john@example.com
  • Password: password123

๐ŸŽฏ User Roles & Permissions

๐Ÿ›ก๏ธ Administrator

  • โœ… Full system access and control
  • โœ… Staff registration approval/rejection
  • โœ… Product and menu management
  • โœ… Inventory tracking and stock management
  • โœ… Sales analytics and reporting
  • โœ… System configuration and settings

๐Ÿ‘จโ€๐Ÿ’ผ Staff Member

  • โœ… Order management and processing
  • โœ… Payment processing (multiple methods)
  • โœ… Kitchen display for order tracking
  • โœ… Personal sales reports and analytics
  • โœ… Customer service functions
  • โŒ Cannot access admin functions

๐Ÿ‘ค Customer

  • โœ… Menu browsing and ordering
  • โœ… Order history and tracking
  • โœ… Profile management
  • โœ… Real-time order status updates
  • โŒ Cannot access staff/admin functions

๐Ÿ”ง Configuration Options

Database Settings

  • Host: localhost (default)
  • Port: 3306 (default MySQL port)
  • Database: cafe_management

System Settings

  • Low Stock Threshold: 10 units (configurable)
  • Session Timeout: 30 minutes
  • Order Status Flow: Pending โ†’ Confirmed โ†’ Preparing โ†’ Ready โ†’ Completed

Payment Methods

  • Cash - Manual change calculation
  • Card - Credit/Debit card processing
  • bKash - Mobile banking (Bangladesh)
  • Nagad - Mobile banking (Bangladesh)
  • Rocket - Mobile banking (Bangladesh)

๐Ÿ“Š Features Overview

Customer Experience

  • ๐Ÿ›’ Shopping Cart - Real-time cart management
  • ๐Ÿ” Search & Filter - Find products by category/name
  • ๐Ÿ“ฑ Mobile Responsive - Works on all devices
  • ๐Ÿ”” Order Notifications - Real-time status updates

Staff Operations

  • ๐Ÿ“‹ Order Queue - Organized order processing
  • ๐Ÿ’ฐ Payment Processing - Multiple payment methods
  • ๐Ÿงพ Receipt Generation - Automatic receipt printing
  • ๐Ÿ“ˆ Performance Tracking - Individual sales analytics

Administrative Control

  • ๐Ÿ‘ฅ User Management - Complete user control
  • ๐Ÿ“ฆ Inventory Control - Stock tracking with alerts
  • ๐Ÿ“Š Business Analytics - Comprehensive reporting
  • ๐Ÿ”ง System Configuration - Customizable settings

๐ŸŽจ UI/UX Features

  • Modern Design - Gradient backgrounds and smooth animations
  • Responsive Layout - Mobile-first design approach
  • Interactive Elements - Hover effects and transitions
  • Color-Coded Status - Visual status indicators
  • Chart Integration - Beautiful data visualizations
  • Print-Friendly - Optimized printing layouts

๐Ÿ”’ Security Features

  • Password Hashing - BCrypt encryption
  • SQL Injection Prevention - Prepared statements
  • Session Management - Secure session handling
  • Role-Based Access - Proper permission controls
  • Input Validation - Client and server-side validation

๐Ÿ“ˆ Analytics & Reporting

Sales Analytics

  • Daily/Weekly/Monthly sales trends
  • Payment method distribution
  • Top-selling products analysis
  • Staff performance metrics

Inventory Reports

  • Current stock levels
  • Low stock alerts
  • Stock movement history
  • Inventory valuation

๐Ÿ› ๏ธ Development & Customization

Adding New Features

  1. Create new PHP files in appropriate role directories
  2. Update navigation menus in respective dashboards
  3. Add corresponding CSS styles in global/css/style.css
  4. Include JavaScript functionality in global/js/main.js

Database Modifications

  1. Update schema in global/php/cafe_database.sql
  2. Create migration scripts for existing installations
  3. Update related PHP files for new fields/tables

Styling Customization

  • Modify global/css/style.css for visual changes
  • Update color schemes in CSS custom properties
  • Adjust responsive breakpoints as needed

๐Ÿค Contributing

  1. Fork the repository
  2. Create a feature branch (git checkout -b feature/new-feature)
  3. Commit your changes (git commit -am 'Add new feature')
  4. Push to the branch (git push origin feature/new-feature)
  5. Create a Pull Request

๐Ÿ“ License

This project is licensed under the MIT License - see the LICENSE file for details.

๐Ÿ› Known Issues & Limitations

  • Email Integration: Email notifications not implemented
  • Payment Gateway: Real payment processing not integrated
  • Multi-location: Single location support only
  • Backup System: Automated backups not implemented

๐Ÿ”ฎ Future Enhancements

  • Email notification system
  • Real payment gateway integration
  • Multi-location support
  • Mobile app development
  • Advanced reporting dashboard
  • Automated backup system
  • Customer loyalty program
  • Table reservation system

๐Ÿ“ž Support & Contact

For support, feature requests, or bug reports:

๐Ÿ™ Acknowledgments

  • Chart.js for beautiful data visualizations
  • Unsplash for high-quality stock images
  • Font Awesome for icon sets
  • PHP Community for excellent documentation and resources

Made with โค๏ธ for the cafe industry

โญ Star this repository if you find it helpful! โญ

About

A premium, full-stack cafe management platform that transforms coffee shop operations. Built with PHP & MySQL, featuring real-time order processing, intelligent inventory management, staff performance analytics, and seamless payment integration. Perfect for modern cafes seeking digital transformation.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published