How epk-courses/tablesync-pro works
TableSync Pro is a role-based restaurant management web application. Customers can browse the menu and manage reservations; waiters handle table occupancy, orders, kitchen-status progress, and invoices; managers oversee menu and table configuration, analytics, turnover estimates, and data exports/restores. The sampled PHP pages connect directly to a shared PDO database and use session-based role guards. Major documented capabilities are included, but several page implementations were not sampled, so their internal wiring is not inferred.
Main entry points: db.php PDO Database Access · index.php Landing Router · auth.php Session & Role Guard · dashboard_manager.php Manager Portal
Components 20
Access & Portals
- Landing Router
code/pages/index.php - Login
code/pages/login.php - Registration
code/pages/register.php - Session & Role Guard
code/includes/auth.php - Customer Portal
code/pages/dashboard_customer.php
Dining Operations
- Reservations
code/pages/reservations_create.php - Menu Browse & Manage
code/pages/menu_search.php - Table Status & Seating
code/pages/tables_status.php - Order Lifecycle
code/pages/orders_active.php
Service & Billing
- Waiter Floor Portal
code/pages/dashboard_waiter.php - Invoice & Payment
code/includes/invoice_print.php
Management & Insights
- Manager Portal
code/pages/dashboard_manager.php - Business Reports
code/pages/reports.php - Turnover Analytics
code/includes/turnover_prediction.php - Backup & Restore
code/includes/backup.php
Other components
- Customer
- Waiter
- Manager
- PDO Database Access
code/config/db.php - Restaurant Data
backend/schema.sql
Connections 26
- Customer → Landing Router: opens portal
- Waiter → Landing Router: opens portal
- Manager → Landing Router: opens portal
- Landing Router → Login: redirects unauthenticated
- Landing Router → Customer Portal: routes by role
- Login → Session & Role Guard: uses session guard
- Registration → Session & Role Guard: uses session guard
- Customer Portal → Session & Role Guard: requires customer role
- Waiter Floor Portal → Session & Role Guard: requires session
- Manager Portal → Session & Role Guard: requires manager role
- Customer Portal → Reservations: offers booking access
- Customer Portal → Menu Browse & Manage: offers menu access
- Table Status & Seating → Order Lifecycle: links active orders
- Waiter Floor Portal → Table Status & Seating: opens floor controls
- Waiter Floor Portal → Order Lifecycle: opens order tracking
- Order Lifecycle → Invoice & Payment: links billing
- Manager Portal → Business Reports: opens analytics
- Manager Portal → Turnover Analytics: opens turnover view
- Manager Portal → Backup & Restore: opens data tools
- Menu Browse & Manage → PDO Database Access: queries menu data
- Table Status & Seating → PDO Database Access: queries seating data
- Invoice & Payment → PDO Database Access: reads and updates invoices
- Business Reports → PDO Database Access: queries business data
- Turnover Analytics → PDO Database Access: queries dining history
- Backup & Restore → PDO Database Access: exports and restores
- PDO Database Access → Restaurant Data: reads and writes