Gaming Platform PAM

Appearance

🧩 Technology Stack & Backoffice Overview ​

The Aggregator Project integrates the API and Backoffice of the Gaming Platform PAM. It provides backend processing, admin control, dashboards, provider connections, player management, transactions, reporting, caching and Horizon job queues.

  • 🧠 Backend: Laravel 12 (PHP 8.4)
  • 🗄️ Database: PostgreSQL 17
  • ⚙️ Cache & Queues: Redis 7 + Laravel Horizon
  • 📦 Storage: AWS S3 / DigitalOcean Spaces
  • 🖥️ Backoffice: Vue 3 + Vuetify + Pinia
  • 🔒 Auth: Laravel Sanctum (JWT)
  • 📊 Monitoring: Laravel Telescope
  • 🚦 Queue Dashboard: Laravel Horizon
  • 🐳 Deployment: Docker + deploy.sh automation

📁 Project Structure ​

The backend is organized as follows:

  • aggregator/ → Laravel API
  • back-office/ → Vue 3 Backoffice
  • docker/ → Docker build files & supervisor scripts
  • deploy.sh → Deployment automation
  • docker-compose.yml → Local dev networking
  • .env → Main project environment file

Before configuring the backend, you must set your database connection depending on the environment:

  • 🖥️ Local Development: use DB_HOST=postgres
  • 🚀 Production: use the VPS DB IP (example: 192.168.10.101)
  • 🧪 Staging: use its own VPS DB IP (example: 192.168.10.102)

⚙️ Environment Configuration (.env) ​

Complete production-ready configuration:

env
# Application
APP_NAME=Aggregator
APP_ENV=${APP_ENV}
APP_KEY=base64:JecVhp4VmlHb/S148DS4dFY5iC1KMwXKLLjTIPtnBTY=
APP_DEBUG=true
APP_URL=https://aggregator.example.com

# Database
DB_CONNECTION=pgsql
DB_HOST=${DB_HOST}
DB_PORT=${DB_PORT}
DB_DATABASE=${DB_DATABASE}
DB_USERNAME=${DB_USERNAME}
DB_PASSWORD=${DB_PASSWORD}
DB_SCHEMA=production

# Cache / Logging
CACHE_DRIVER=redis
CACHE_TTL=86400
LOG_CHANNEL=single
LOG_LEVEL=debug

# Features
FORCE_HTTPS=false
TELESCOPE_ENABLED=true
TELESCOPE_JOB_WATCHER=true
HORIZON_ENABLED=true
REAL_TIME_REPORTING=true

# Queue
QUEUE_CONNECTION=redis

# Sessions
SESSION_DRIVER=redis

# Redis
REDIS_HOST=redis
REDIS_PORT=6379
REDIS_PASSWORD=null
REDIS_CLIENT=phpredis

# Horizon
HORIZON_PREFIX=aggregator
HORIZON_DOMAIN=
HORIZON_MEMORY=256

# Storage
FILESYSTEM_DRIVER=s3
AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_DEFAULT_REGION=
AWS_BUCKET=
AWS_ENDPOINT=

MAIL_FROM_ADDRESS=
MAIL_FROM_NAME=""

MAIL_MAILER=
MAIL_HOST=
MAIL_PORT=
MAIL_USERNAME=
MAIL_PASSWORD=

# Twilio Credentials
TWILIO_SID=
TWILIO_AUTH_TOKEN=

# SMS / WhatsApp
TWILIO_SMS_FROM=
TWILIO_WHATSAPP_FROM=whatsapp:
TWILIO_WHATSAPP_TEMPLATE_SID=

# Cloudflare Turnstile
TURNSTILE_SECRET_KEY=

🖥️ Terminal Setup ​

bash
# 1. Go to project root
cd ~/aggregator-pam

# 2. Make the deployment script executable
chmod +x deploy.sh

🚀 Deployment Commands ​

Production ​

bash
./deploy.sh prod --api=https://aggregator.example.com/api
./deploy.sh prod --api=https://aggregator.example.com/api --build
./deploy.sh prod --api=https://aggregator.example.com/api --rebuild

Development ​

bash
./deploy.sh dev --api=http://aggregator.test/api
./deploy.sh dev --api=http://aggregator.test/api --build
./deploy.sh dev --api=http://aggregator.test/api --rebuild

🗺️ Architecture Overview ​

mermaid
graph TD
    WL[🌐 Whitelabel<br />Vue 3 + Nginx<br />https://micasino.net]
    BO[🖥️ Backoffice<br />Vue 3 + Vuetify<br />https://admin.example.com]
    API[⚙️ Aggregator API<br />Laravel + Redis + Horizon]
    DB[🗄️ PostgreSQL<br />Dockerized DB]
    
    WL -->|POST /api/wl/tenant<br />Send domain → get JSON| API
    API -->|WL JSON config| WL
    
    WL -->|POST /login<br />JWT Auth| API
    BO -->|POST /login<br />JWT Auth| API
    
    WL -->|JWT Protected Endpoints| API
    BO -->|JWT Protected Endpoints| API
    
    API -->|DB + Cache + Queues| DB

✅ Deployment Complete ​

INFO

Once you run the deployment commands, the whole platform becomes available automatically:

No extra manual steps — once deploy.sh finishes, everything is online.

© 2025 Gaming Platform – Aggregator Project Documentation

← Back to Home