#!/bin/bash
# Fix billing site to use PHP 7.4 instead of PHP 8.3
# Run with: sudo bash fix-billing-php-version.sh

echo "=== Fixing Billing Site to Use PHP 7.4 ==="
echo ""

SSL_FILE="/etc/apache2/sites-available/004-billing-le-ssl.conf"
HTTP_FILE="/etc/apache2/sites-available/004-billing.conf"

echo "1. Current configuration:"
grep -i "ProxyPassMatch.*php" "$SSL_FILE" | head -2
echo ""

echo "2. Updating to PHP 7.4..."
# Replace any PHP 8.3 references with PHP 7.4
sudo sed -i 's|php8.3-scala4|php7.4-scala4|g' "$SSL_FILE"
sudo sed -i 's|php8.3-scala4|php7.4-scala4|g' "$HTTP_FILE"

# Ensure ProxyPassMatch includes document root
sudo sed -i 's|ProxyPassMatch "^/(.*\.php(/.*)?)$" "unix:/run/php/php7.4-scala4.sock|fcgi://localhost/"|ProxyPassMatch "^/(.*\.php(/.*)?)$" "unix:/run/php/php7.4-scala4.sock|fcgi://localhost/var/www/html/billing/$1"|' "$SSL_FILE"
sudo sed -i 's|ProxyPassMatch "^/(.*\.php(/.*)?)$" "unix:/run/php/php7.4-scala4.sock|fcgi://localhost/"|ProxyPassMatch "^/(.*\.php(/.*)?)$" "unix:/run/php/php7.4-scala4.sock|fcgi://localhost/var/www/html/billing/$1"|' "$HTTP_FILE"

echo "✓ Updated"
echo ""

echo "3. New configuration:"
grep -i "ProxyPassMatch.*php" "$SSL_FILE" | head -2
echo ""

echo "4. Testing Apache configuration..."
sudo apache2ctl configtest

if [ $? -eq 0 ]; then
    echo "✓ Configuration valid!"
    echo ""
    echo "5. Reloading Apache..."
    sudo systemctl reload apache2
    sleep 2
    echo "✓ Apache reloaded"
    echo ""
    echo "6. Testing billing site..."
    sleep 2
    HTTP_CODE=$(curl -s -o /dev/null -w "%{http_code}" https://billing.friendlytv.site/ 2>&1)
    echo "   HTTP Status: $HTTP_CODE"
    
    if [ "$HTTP_CODE" = "200" ]; then
        echo ""
        echo "✅ SUCCESS! Billing site is working with PHP 7.4!"
    else
        echo ""
        echo "⚠️  Still getting $HTTP_CODE"
        echo "   Check: sudo tail -10 /var/log/apache2/error.log"
    fi
else
    echo "❌ Configuration error"
    exit 1
fi