Billiard Management System

A simple web-based billiard management system that allows admins and cashiers to manage tables, bookings, and tournaments. The system also integrates with payment gateways such as Paymongo, Gcash, and PayPal sandbox.

Features

Admin Role

• Create and manage billiard tables.
• Manage booking system for users.
• Manage tournament brackets.
• Access to payment integrations for Paymongo, Gcash, and PayPal (sandbox).

Cashier Role

• View and manage booking transactions.

Setup Instructions

Prerequisites

• XAMPP (with PHP and MySQL) installed on your machine.
• phpMyAdmin to manage your MySQL database.
• Paymongo, Gcash, and PayPal sandbox accounts for payment integrations.

Installation

1. Clone the Repository:

git clone https://github.com/your-username/billiard-management.git
cd billiard-management

2. Set up the Database:

• Navigate to the database folder in your project.
• Import the SQL file into phpMyAdmin:
  1. Go to phpMyAdmin -> Databases -> Import.
  2. Select the SQL file from the database folder.

3. Configure Database Connection:

• Open the conn.php file located in the includes directory.
• Update the following database configuration to match your local phpMyAdmin credentials:

$servername = "localhost";
$username = "root"; // default username
$password = ""; // default password is empty
$dbname = "billiard_management"; // or your database name

4. Start the PHP Server

• In XAMPP, start the Apache server to run your PHP files.
• Access the application in your browser: http://localhost/billiard-management/

Payment Gateway Setup

Paymongo

1. Sign up for a Paymongo account.
2. Obtain your API keys from the Paymongo dashboard.
3. Integrate the API keys into the payment handling sections of your application.

Gcash

1. Sign up for a Gcash merchant account.
2. Obtain your API keys from the Gcash merchant dashboard.
3. Integrate the API keys into the payment processing area of your application.

PayPal Sandbox

1. Create a PayPal developer account.
2. Obtain your sandbox API credentials.
3. Add the credentials to your payment processing configuration.

Roles and Permissions

Admin

• Admins have full control over the system, including the ability to:
  • Create tables
  • Manage bookings
  • Handle tournament brackets

Cashier

• Cashiers can:
  • View and manage booking transactions

Screenshots