#!/bin/bash

# Script de correção IMEDIATA para remover referências às colunas inexistentes

echo "========================================="
echo "CORREÇÃO IMEDIATA - Removendo 'active'"
echo "========================================="
echo ""

cd /var/www/gestorstream

echo "1. Verificando arquivos..."
echo ""

# Model Subscription
if grep -q "'active'" backend/app/Models/Subscription.php; then
    echo "   Corrigindo Model Subscription..."
    sed -i "/'active',/d" backend/app/Models/Subscription.php
    sed -i "/'active' => 'boolean',/d" backend/app/Models/Subscription.php
    sed -i "s/\$this->active && !/\$this->status === 'active' \&\& !/g" backend/app/Models/Subscription.php
    echo "   ✓ Model corrigido"
else
    echo "   ✓ Model já está correto"
fi

# Test file - remover 'active' e 'cancelled_at' dos updates
if grep -q "'active'" test_payment_flow.php || grep -q "'cancelled_at'" test_payment_flow.php; then
    echo "   Corrigindo test_payment_flow.php..."
    # Criar backup
    cp test_payment_flow.php test_payment_flow.php.backup
    
    # Remover linhas com 'active' em creates/updates
    sed -i "/'active' => true,/d" test_payment_flow.php
    sed -i "/'active' => false,/d" test_payment_flow.php
    sed -i "/'cancelled_at' => now(),/d" test_payment_flow.php
    
    # Corrigir verificações de $sub->active
    sed -i 's/->where('\''active'\'', true)//g' test_payment_flow.php
    sed -i 's/\$sub->active/(\$sub->status === '\''active'\'')/g' test_payment_flow.php
    sed -i '/\$activeIcon/d' test_payment_flow.php
    sed -i '/Ativo.*activeIcon/d' test_payment_flow.php
    
    echo "   ✓ test_payment_flow.php corrigido"
else
    echo "   ✓ test_payment_flow.php já está correto"
fi

echo ""
echo "2. Limpando cache Laravel..."
cd backend
php artisan config:clear > /dev/null 2>&1
php artisan cache:clear > /dev/null 2>&1
php artisan route:clear > /dev/null 2>&1
cd ..
echo "   ✓ Cache limpo"

echo ""
echo "3. Verificando correções..."
if grep -q "'active'" test_payment_flow.php || grep -q "'cancelled_at'" test_payment_flow.php; then
    echo "   ⚠ Ainda há referências em test_payment_flow.php"
    echo "   Linhas encontradas:"
    grep -n "'active'\|'cancelled_at'" test_payment_flow.php | head -10
else
    echo "   ✓ Todas as referências removidas!"
fi

echo ""
echo "========================================="
echo "Correção concluída!"
echo "========================================="
echo ""
echo "Execute novamente: php test_payment_flow.php"