e-billiard Billiard Hall Management System\n\nAn all-in-one smart management software designed for billiard halls and pool rooms. Runs on Windows desktop, works fully offline with all data stored locally \u2014 secure and reliable.\n\n\n\u3010Product Overview\u3011\n\ne-billiard is a full-featured offline billiard hall management system covering the entire business workflow: front desk table management, timing & billing, membership management, product sales, and smart device control. The software features a visual operation interface, supports 13 languages, and is suitable for billiard hall operations worldwide. Whether you run a single location or a chain of stores, you can get started quickly and manage efficiently.\n\n\n\u3010Key Features\u3011\n\n1. Smart Front Desk Dashboard\n - All tables at a glance, grouped by type, with real-time status display (idle, in use, paused, reserved, maintenance)\n - One-click operations: start session, checkout, pause, transfer table, reserve\n - Table cards show real-time customer name, elapsed time, estimated cost, coach avatar, and other key information\n - Simplified mode available for waitstaff with a streamlined interface\n\n2. Precise Timing & Billing\n - Automatic calculation of table usage duration, accurate to the minute\n - Pause time automatically deducted \u2014 only effective usage time is counted\n - Flexible overtime rounding rules (no rounding, round up to 5/10/15/30 minutes, etc.)\n - Package time auto-deduction\n - Coach fees calculated in real-time\n\n3. Membership Management\n - Multi-tier membership (Regular, Silver, Gold, VIP, etc.) with different discounts per tier\n - Top-up with bonus amount support\n - Member balance payment with one-click lookup and deduction at checkout\n - Member spending history tracking with last visit date reminders\n - Bulk export member data to Excel\n\n4. Complete Product & Order Management\n - Product category management with inventory tracking\n - Order directly from the table \u2014 product charges auto-merged into the bill\n - Order history search with filters by date, status, and customer info\n - Export order data to Excel\n\n5. Coach / Assistant Management\n - Coach profiles (name, phone, photo, commission rate)\n - Clock-in/clock-out system with real-time work hour tracking\n - Pause/resume coach timing\n - Automatic commission calculation\n - Coach avatar displayed on the corresponding table card on the front desk dashboard\n\n6. Flexible Checkout System\n - Bills automatically summarize table fees, product charges, and coach fees\n - Multiple payment methods supported (cash, bank card, member balance, WeChat, Alipay, etc. \u2014 customizable)\n - Member discounts auto-applied\n - Manual discount and waiver amount input\n - Multi-currency settlement with automatic exchange rate conversion\n - 10 rounding rules (round half up, round up, etc.)\n - Print bill preview before checkout\n - Customer display screen syncs bill info in real-time\n\n7. Smart Device Control (IoT)\n - Smart locker management: remote unlock, status monitoring, member binding\n - Smart appliance control: remote on/off for table lights, fans, and other devices\n - Real-time device online status monitoring\n - Batch device creation with QR code generation\n - Socket protocol-based device communication with encrypted transmission\n\n8. Kitchen Order System\n - Independent kitchen display interface with three-column status board (In Progress / Completed / Pending Cancellation)\n - Sound alert for new orders\n - Batch operations (one-click complete, one-click serve, one-click cancel)\n - Auto-refresh every 2 seconds for real-time sync\n\n9. Package Management\n - Create time-based packages (e.g., 2-hour unlimited play package)\n - Set package validity period\n - Bind to specific table types\n - Auto-deduct package time at checkout\n\n10. Data Reports\n - Daily income breakdown and summary\n - Coach clock-in statistics (detailed and summary)\n - Coach commission statistics\n - Coach income analysis\n - Monthly view with sorting support\n\n11. Permission Management System\n - Role management: create custom roles and assign menu permissions\n - User management: create accounts and bind roles\n - Tree-structured menu permission configuration\n - Role inheritance support\n - Kitchen-dedicated role showing only the kitchen interface\n\n12. Customer Display Screen (Payout Display)\n - Support for second monitor as customer-facing display\n - Auto-push bill to customer display at checkout\n - Real-time WebSocket communication with no delay\n - Auto-scrolling bill display\n - Independent language switching\n\n13. Multi-Language Support\n - 13 languages supported: Simplified Chinese, Traditional Chinese, English, Vietnamese, Japanese, Korean, French, German, Spanish, Portuguese (Brazil), Russian, Thai, Indonesian\n - Automatic system language detection\n - Switch anytime with instant effect\n\n14. Data Security\n - All data stored locally \u2014 no cloud upload required\n - One-click database export backup\n - Database import restore\n - Auto-named backup files with timestamps\n\n\n\u3010Detailed Description\u3011\n\ne-billiard is a professional management tool designed for offline billiard halls. The software runs without an internet connection, with all business data securely stored on the local device.\n\nThe system centers on the front desk dashboard, displaying all tables as visual cards. Staff can complete all daily operations \u2014 start session, pause, checkout, transfer table \u2014 simply by clicking on a table. The timing and billing engine is accurate to the minute and supports various billing rules including pause deduction, package deduction, and overtime rounding to meet different business models.\n\nThe membership system supports multi-tier management with independent discount rates per tier. Members can top up, pay with balance, and view spending history. The system automatically identifies member tiers and applies corresponding discounts at checkout.\n\nThe product management module supports category maintenance and inventory tracking. Customer orders placed at the table are automatically merged into the final bill. The kitchen provides an independent order dashboard interface, displaying pending, completed, and pending-cancellation orders as three-column status cards, with sound alerts and batch operations.\n\nThe coach management module provides complete clock-in/out, pause/resume, and commission calculation features. Coach avatars are displayed on the corresponding table cards on the front desk dashboard for easy customer identification.\n\nThe smart device control module communicates with smart lockers, table lights, and other IoT devices via Socket protocol. It enables remote unlocking, on/off control, and status monitoring. Device communication supports encrypted transmission to ensure data security.\n\nThe checkout system supports multiple coexisting payment methods with custom additions. The system supports multi-currency settlement and exchange rate conversion for international operations. The customer display feature pushes bills in real-time to a second monitor for customers to view their spending details.\n\nPermission management uses a role-based model where administrators can create different roles and assign corresponding menu permissions. The system includes a preset kitchen-dedicated role, allowing kitchen staff to see only the kitchen interface upon login.\n\nThe data reporting module provides daily income statistics, coach work hour statistics, coach commission analysis, and other multi-dimensional reports with monthly views and sorting to support business decision-making.\n\n\n\u3010Use Cases\u3011\n\n- Daily operations management for billiard halls / pool rooms / snooker clubs\n- Table-based entertainment venues requiring precise timing and billing\n- Venues equipped with smart lockers, smart lighting, and other IoT devices\n- Billiard training and business venues with coach/assistant services\n- Internationally operated stores requiring multi-language interfaces (Southeast Asia, East Asia, Europe, South America, etc.)\n- Entertainment service venues requiring membership and top-up management\n- Billiard halls with food service requiring kitchen order management\n- Operators who value data privacy and prefer local data storage\n\n\n\u3010System Requirements\u3011\n\n- Operating System: Windows 10 / Windows 11\n- Core features work without internet connection\n- Smart device control requires a local area network (LAN)\n