#!/bin/bash
# TEMLOL Diagnostic Centre ERP - Ubuntu VPS Production Deployment (PHP 8.3 + Nginx/Apache)
set -e

WEB_ROOT="/var/www/temlol-erp"
DB_NAME="temlol_erp"
DB_USER="temlol_user"
DB_PASS="SecureTemlolLabDBPassword2026!"

echo "Setting up TEMLOL ERP on Linux VPS..."
sudo mkdir -p "$WEB_ROOT"
sudo cp -r . "$WEB_ROOT"
cd "$WEB_ROOT"

sudo chown -R www-data:www-data "$WEB_ROOT"
sudo chmod -R 775 storage bootstrap/cache

composer install --optimize-autoloader --no-dev
cp .env.example .env
php artisan key:generate

echo "Configuring MySQL & importing database.sql..."
sudo mysql -e "CREATE DATABASE IF NOT EXISTS $DB_NAME CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
sudo mysql -e "CREATE USER IF NOT EXISTS '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS';"
sudo mysql -e "GRANT ALL PRIVILEGES ON $DB_NAME.* TO '$DB_USER'@'localhost'; FLUSH PRIVILEGES;"
sudo mysql "$DB_NAME" < database.sql

php artisan optimize
php artisan storage:link

echo "VPS Deployment Complete!"