<?php
// Configurações iniciais
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('max_execution_time', 300);
date_default_timezone_set('America/Sao_Paulo');

// Classe principal do sistema
class StockMarketSystem {
    private $db;
    private $apiKey = '59PNZEORLRR570WJ'; // Obtenha uma chave gratuita em https://www.alphavantage.co/support/#api-key
    
    public function __construct() {
        $this->initializeDatabase();
    }
    
    private function initializeDatabase() {
        try {
            $this->db = new PDO('sqlite:stocks.db');
            $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            
            // Criar tabelas se não existirem
            $this->db->exec("
                CREATE TABLE IF NOT EXISTS stocks (
                    id INTEGER PRIMARY KEY AUTOINCREMENT,
                    code TEXT NOT NULL,
                    name TEXT NOT NULL,
                    price REAL NOT NULL,
                    change REAL NOT NULL,
                    volume INTEGER NOT NULL,
                    sector TEXT NOT NULL,
                    timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
                )
            ");
            
            $this->db->exec("
                CREATE TABLE IF NOT EXISTS stock_history (
                    id INTEGER PRIMARY KEY AUTOINCREMENT,
                    stock_id INTEGER,
                    price REAL NOT NULL,
                    volume INTEGER NOT NULL,
                    timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
                    FOREIGN KEY (stock_id) REFERENCES stocks (id)
                )
            ");
            
            $this->db->exec("
                CREATE TABLE IF NOT EXISTS predictions (
                    id INTEGER PRIMARY KEY AUTOINCREMENT,
                    stock_code TEXT NOT NULL,
                    probability REAL NOT NULL,
                    confidence TEXT NOT NULL,
                    recommendation TEXT NOT NULL,
                    analysis TEXT NOT NULL,
                    timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
                )
            ");
            
        } catch(PDOException $e) {
            die("Erro no banco de dados: " . $e->getMessage());
        }
    }
    
    // Função para fazer requisições à API
    private function makeApiRequest($url) {
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($ch, CURLOPT_TIMEOUT, 30);
        
        $response = curl_exec($ch);
        $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
        curl_close($ch);
        
        if ($httpCode === 200) {
            return json_decode($response, true);
        }
        
        return null;
    }
    
    public function fetchRealTimeData() {
        // Ações brasileiras para monitorar (códigos formatados para API)
        $brazilianStocks = [
            'PETR4.SAO', 'VALE3.SAO', 'ITUB4.SAO', 'BBDC4.SAO', 
            'WEGE3.SAO', 'MGLU3.SAO', 'B3SA3.SAO', 'RENT3.SAO',
            'BBAS3.SAO', 'ABEV3.SAO', 'JBSS3.SAO', 'RADL3.SAO',
            'CSAN3.SAO', 'LREN3.SAO', 'SBSP3.SAO'
        ];
        
        $stocks = [];
        
        foreach ($brazilianStocks as $stockCode) {
            // Buscar cotação em tempo real
            $url = "https://www.alphavantage.co/query?function=GLOBAL_QUOTE&symbol={$stockCode}&apikey={$this->apiKey}";
            $data = $this->makeApiRequest($url);
            
            if ($data && isset($data['Global Quote'])) {
                $quote = $data['Global Quote'];
                
                $price = floatval($quote['05. price']);
                $previousClose = floatval($quote['08. previous close']);
                $change = $previousClose ? (($price - $previousClose) / $previousClose) * 100 : 0;
                $volume = intval($quote['06. volume']);
                
                // Buscar informações da empresa
                $companyInfo = $this->getCompanyInfo($stockCode);
                
                $stocks[] = [
                    'code' => str_replace('.SAO', '', $stockCode),
                    'name' => $companyInfo['name'],
                    'price' => $price,
                    'change' => $change,
                    'volume' => $volume,
                    'sector' => $companyInfo['sector']
                ];
                
                // Salvar no banco de dados
                $this->saveStockData(
                    str_replace('.SAO', '', $stockCode),
                    $companyInfo['name'],
                    $price,
                    $change,
                    $volume,
                    $companyInfo['sector']
                );
            } else {
                // Fallback para dados simulados se a API falhar
                $stocks[] = $this->getSimulatedData($stockCode);
            }
            
            // Respeitar o limite de 5 requisições por minuto da API free
            sleep(12);
        }
        
        return $stocks;
    }
    
    private function getCompanyInfo($stockCode) {
        // Mapeamento de informações das empresas (em produção, buscar de API)
        $companies = [
            'PETR4.SAO' => ['name' => 'Petróleo Brasileiro S.A.', 'sector' => 'Energia'],
            'VALE3.SAO' => ['name' => 'Vale S.A.', 'sector' => 'Mineração'],
            'ITUB4.SAO' => ['name' => 'Itaú Unibanco Holding S.A.', 'sector' => 'Financeiro'],
            'BBDC4.SAO' => ['name' => 'Banco Bradesco S.A.', 'sector' => 'Financeiro'],
            'WEGE3.SAO' => ['name' => 'WEG S.A.', 'sector' => 'Industrial'],
            'MGLU3.SAO' => ['name' => 'Magazine Luiza S.A.', 'sector' => 'Varejo'],
            'B3SA3.SAO' => ['name' => 'B3 S.A. - Brasil Bolsa Balcão', 'sector' => 'Financeiro'],
            'RENT3.SAO' => ['name' => 'Localiza Rent a Car S.A.', 'sector' => 'Serviços'],
            'BBAS3.SAO' => ['name' => 'Banco do Brasil S.A.', 'sector' => 'Financeiro'],
            'ABEV3.SAO' => ['name' => 'Ambev S.A.', 'sector' => 'Bebidas'],
            'JBSS3.SAO' => ['name' => 'JBS S.A.', 'sector' => 'Alimentos'],
            'RADL3.SAO' => ['name' => 'Raia Drogasil S.A.', 'sector' => 'Saúde'],
            'CSAN3.SAO' => ['name' => 'Cosan S.A.', 'sector' => 'Energia'],
            'LREN3.SAO' => ['name' => 'Lojas Renner S.A.', 'sector' => 'Varejo'],
            'SBSP3.SAO' => ['name' => 'Sabesp', 'sector' => 'Utilities']
        ];
        
        return $companies[$stockCode] ?? ['name' => 'Empresa', 'sector' => 'Geral'];
    }
    
    private function getSimulatedData($stockCode) {
        // Dados simulados para fallback
        $companies = [
            'PETR4.SAO' => ['name' => 'Petróleo Brasileiro S.A.', 'sector' => 'Energia'],
            'VALE3.SAO' => ['name' => 'Vale S.A.', 'sector' => 'Mineração'],
            'ITUB4.SAO' => ['name' => 'Itaú Unibanco Holding S.A.', 'sector' => 'Financeiro'],
            'BBDC4.SAO' => ['name' => 'Banco Bradesco S.A.', 'sector' => 'Financeiro'],
            'WEGE3.SAO' => ['name' => 'WEG S.A.', 'sector' => 'Industrial'],
            'MGLU3.SAO' => ['name' => 'Magazine Luiza S.A.', 'sector' => 'Varejo'],
            'B3SA3.SAO' => ['name' => 'B3 S.A. - Brasil Bolsa Balcão', 'sector' => 'Financeiro'],
            'RENT3.SAO' => ['name' => 'Localiza Rent a Car S.A.', 'sector' => 'Serviços'],
            'BBAS3.SAO' => ['name' => 'Banco do Brasil S.A.', 'sector' => 'Financeiro'],
            'ABEV3.SAO' => ['name' => 'Ambev S.A.', 'sector' => 'Bebidas'],
            'JBSS3.SAO' => ['name' => 'JBS S.A.', 'sector' => 'Alimentos'],
            'RADL3.SAO' => ['name' => 'Raia Drogasil S.A.', 'sector' => 'Saúde'],
            'CSAN3.SAO' => ['name' => 'Cosan S.A.', 'sector' => 'Energia'],
            'LREN3.SAO' => ['name' => 'Lojas Renner S.A.', 'sector' => 'Varejo'],
            'SBSP3.SAO' => ['name' => 'Sabesp', 'sector' => 'Utilities']
        ];
        
        $company = $companies[$stockCode] ?? ['name' => 'Empresa', 'sector' => 'Geral'];
        $basePrice = rand(500, 10000) / 10;
        $change = (rand(-100, 100) / 10);
        $price = $basePrice * (1 + $change/100);
        
        return [
            'code' => str_replace('.SAO', '', $stockCode),
            'name' => $company['name'],
            'price' => round($price, 2),
            'change' => $change,
            'volume' => rand(100000, 5000000),
            'sector' => $company['sector']
        ];
    }
    
    private function saveStockData($code, $name, $price, $change, $volume, $sector) {
        try {
            // Verificar se a ação já existe
            $stmt = $this->db->prepare("SELECT id FROM stocks WHERE code = ?");
            $stmt->execute([$code]);
            $stock = $stmt->fetch(PDO::FETCH_ASSOC);
            
            if ($stock) {
                // Atualizar dados existentes
                $stmt = $this->db->prepare("
                    UPDATE stocks 
                    SET price = ?, change = ?, volume = ?, timestamp = CURRENT_TIMESTAMP 
                    WHERE code = ?
                ");
                $stmt->execute([$price, $change, $volume, $code]);
                
                // Registrar no histórico
                $stmt = $this->db->prepare("
                    INSERT INTO stock_history (stock_id, price, volume) 
                    VALUES (?, ?, ?)
                ");
                $stmt->execute([$stock['id'], $price, $volume]);
            } else {
                // Inserir nova ação
                $stmt = $this->db->prepare("
                    INSERT INTO stocks (code, name, price, change, volume, sector) 
                    VALUES (?, ?, ?, ?, ?, ?)
                ");
                $stmt->execute([$code, $name, $price, $change, $volume, $sector]);
                
                $stockId = $this->db->lastInsertId();
                
                // Registrar no histórico
                $stmt = $this->db->prepare("
                    INSERT INTO stock_history (stock_id, price, volume) 
                    VALUES (?, ?, ?)
                ");
                $stmt->execute([$stockId, $price, $volume]);
            }
            
            return true;
        } catch(PDOException $e) {
            error_log("Erro ao salvar dados: " . $e->getMessage());
            return false;
        }
    }
    
    public function getStockPrediction($code) {
        // Buscar dados históricos para análise
        $historicalData = $this->getHistoricalData($code);
        
        // Análise preditiva baseada em dados históricos e tendências
        $probability = $this->calculateProbability($historicalData);
        $confidence = $this->calculateConfidence($historicalData);
        $recommendation = $this->generateRecommendation($probability, $confidence);
        $analysis = $this->generateAnalysis($code, $historicalData, $probability);
        
        // Buscar nome da empresa
        $stmt = $this->db->prepare("SELECT name FROM stocks WHERE code = ?");
        $stmt->execute([$code]);
        $stock = $stmt->fetch(PDO::FETCH_ASSOC);
        $name = $stock ? $stock['name'] : "Empresa não encontrada";
        
        // Salvar previsão no banco
        $stmt = $this->db->prepare("
            INSERT INTO predictions (stock_code, probability, confidence, recommendation, analysis) 
            VALUES (?, ?, ?, ?, ?)
        ");
        $stmt->execute([$code, $probability, $confidence, $recommendation, $analysis]);
        
        return [
            'code' => $code,
            'name' => $name,
            'probability' => $probability,
            'confidence' => $confidence,
            'recommendation' => $recommendation,
            'analysis' => $analysis
        ];
    }
    
    private function getHistoricalData($code) {
        try {
            $stmt = $this->db->prepare("
                SELECT sh.price, sh.timestamp 
                FROM stock_history sh 
                JOIN stocks s ON sh.stock_id = s.id 
                WHERE s.code = ? 
                ORDER BY sh.timestamp DESC 
                LIMIT 30
            ");
            $stmt->execute([$code]);
            
            return $stmt->fetchAll(PDO::FETCH_ASSOC);
        } catch(PDOException $e) {
            error_log("Erro ao buscar dados históricos: " . $e->getMessage());
            return [];
        }
    }
    
    private function calculateProbability($historicalData) {
        if (count($historicalData) < 5) {
            return rand(40, 90) / 100; // Retornar valor aleatório se não houver dados suficientes
        }
        
        // Análise simples de tendência
        $prices = array_column($historicalData, 'price');
        $recentPrices = array_slice($prices, 0, 5);
        $olderPrices = array_slice($prices, 5, 5);
        
        $recentAvg = array_sum($recentPrices) / count($recentPrices);
        $olderAvg = array_sum($olderPrices) / count($olderPrices);
        
        $trend = $recentAvg > $olderAvg ? 1 : ($recentAvg < $olderAvg ? -1 : 0);
        
        // Probabilidade baseada na tendência
        $baseProbability = 0.5;
        
        if ($trend > 0) {
            $baseProbability += 0.2;
        } elseif ($trend < 0) {
            $baseProbability -= 0.2;
        }
        
        // Adicionar algum ruído aleatório
        $baseProbability += (rand(-10, 10) / 100);
        
        // Garantir que está entre 0.1 e 0.9
        return max(0.1, min(0.9, $baseProbability));
    }
    
    private function calculateConfidence($historicalData) {
        $dataPoints = count($historicalData);
        
        if ($dataPoints >= 20) {
            return "Alta";
        } elseif ($dataPoints >= 10) {
            return "Média";
        } else {
            return "Baixa";
        }
    }
    
    private function generateRecommendation($probability, $confidence) {
        if ($probability >= 0.7) {
            return "Compra Forte";
        } elseif ($probability >= 0.6) {
            return "Compra";
        } elseif ($probability >= 0.55) {
            return "Compra Moderada";
        } elseif ($probability >= 0.45) {
            return "Neutra";
        } elseif ($probability >= 0.4) {
            return "Venda Moderada";
        } elseif ($probability >= 0.3) {
            return "Venda";
        } else {
            return "Venda Forte";
        }
    }
    
    private function generateAnalysis($code, $historicalData, $probability) {
        $analyses = [
            "A empresa demonstra crescimento consistente e fundamentos sólidos.",
            "Setor em expansão com potencial de valorização no médio prazo.",
            "Resultados trimestrais acima das expectativas do mercado.",
            "Risco moderado com potencial de retorno interessante.",
            "Fundamentos fracos e perspectivas de mercado desfavoráveis.",
            "Setor em retração com perspectivas negativas para os próximos trimestres.",
            "Volatilidade alta com oportunidades de ganho no curto prazo.",
            "Balanço recente mostra melhora nos indicadores financeiros.",
            "Concorrência acirrada no setor pode impactar resultados futuros.",
            "Projeções de analistas indicam potencial de valorização.",
            "Cenário macroeconômico desfavorável para o setor.",
            "Nova diretoria traz perspectivas positivas para a empresa."
        ];
        
        $index = intval($probability * 10) % count($analyses);
        return $analyses[$index];
    }
    
    public function searchStocks($query) {
        try {
            $stmt = $this->db->prepare("
                SELECT * FROM stocks 
                WHERE code LIKE ? OR name LIKE ? OR sector LIKE ?
                ORDER BY volume DESC
            ");
            $searchTerm = "%$query%";
            $stmt->execute([$searchTerm, $searchTerm, $searchTerm]);
            
            return $stmt->fetchAll(PDO::FETCH_ASSOC);
        } catch(PDOException $e) {
            error_log("Erro na busca: " . $e->getMessage());
            return [];
        }
    }
    
    public function generateHTML() {
        // Processar ações
        $action = $_GET['action'] ?? '';
        
        if ($action === 'get_stocks') {
            header('Content-Type: application/json');
            echo json_encode($this->fetchRealTimeData());
            exit;
        } elseif ($action === 'get_prediction') {
            header('Content-Type: application/json');
            $code = $_GET['code'] ?? '';
            echo json_encode($this->getStockPrediction($code));
            exit;
        } elseif ($action === 'search') {
            header('Content-Type: application/json');
            $query = $_GET['query'] ?? '';
            echo json_encode($this->searchStocks($query));
            exit;
        } elseif ($action === 'init_db') {
            echo "Banco de dados inicializado";
            exit;
        } elseif ($action === 'generate_report') {
            $this->generatePDFReport($_GET['code'] ?? '');
            exit;
        }
        
        // Retornar o HTML completo
        return $this->getPageHTML();
    }
    
    private function generatePDFReport($stockCode) {
        // Em uma implementação real, usaríamos uma biblioteca como TCPDF ou Dompdf
        // Aqui vamos simular o download de um PDF
        
        header('Content-Type: application/pdf');
        header('Content-Disposition: attachment; filename="relatorio_' . $stockCode . '.pdf"');
        
        // Conteúdo simples do PDF (em implementação real, seria um PDF gerado propriamente)
        echo "%PDF-1.4\n";
        echo "1 0 obj\n";
        echo "<< /Type /Catalog /Pages 2 0 R >>\n";
        echo "endobj\n";
        echo "2 0 obj\n";
        echo "<< /Type /Pages /Kids [3 0 R] /Count 1 >>\n";
        echo "endobj\n";
        echo "3 0 obj\n";
        echo "<< /Type /Page /Parent 2 0 R /MediaBox [0 0 612 792] /Contents 4 0 R >>\n";
        echo "endobj\n";
        echo "4 0 obj\n";
        echo "<< /Length 100 >>\n";
        echo "stream\n";
        echo "BT\n";
        echo "/F1 12 Tf\n";
        echo "50 750 Td\n";
        echo "(Relatório de Análise - " . $stockCode . ") Tj\n";
        echo "0 -20 Td\n";
        echo "(Este é um relatório simulado para demonstração.) Tj\n";
        echo "ET\n";
        echo "endstream\n";
        echo "endobj\n";
        echo "xref\n";
        echo "0 5\n";
        echo "0000000000 65535 f \n";
        echo "0000000010 00000 n \n";
        echo "0000000053 00000 n \n";
        echo "0000000110 00000 n \n";
        echo "0000000223 00000 n \n";
        echo "trailer\n";
        echo "<< /Size 5 /Root 1 0 R >>\n";
        echo "startxref\n";
        echo "350\n";
        echo "%%EOF";
    }
    
    private function getPageHTML() {
        ob_start();
        ?>
<!DOCTYPE html>
<html lang="pt-BR">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Pregão Eletrônico - Bolsa de Valores em Tempo Real</title>
    <link href="https://fonts.googleapis.com/css2?family=Orbitron:wght@400;500;700&family=Segoe+UI:wght@300;400;600&display=swap" rel="stylesheet">
    <style>
        :root {
            --neon-blue: #0ff0fc;
            --neon-pink: #ff2d95;
            --neon-purple: #8a2be2;
            --dark-bg: #0a0a1a;
            --darker-bg: #050510;
            --card-bg: rgba(15, 15, 35, 0.7);
        }

        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
            font-family: "Segoe UI", "Orbitron", sans-serif;
        }

        body {
            background: var(--darker-bg);
            color: #fff;
            background-image: 
                radial-gradient(circle at 10% 20%, rgba(10, 100, 255, 0.1) 0%, transparent 20%),
                radial-gradient(circle at 90% 80%, rgba(255, 45, 149, 0.1) 0%, transparent 20%);
            min-height: 100vh;
            overflow-x: hidden;
        }

        .header {
            background: var(--dark-bg);
            padding: 15px 20px;
            border-bottom: 1px solid var(--neon-blue);
            box-shadow: 0 0 15px rgba(0, 240, 252, 0.3);
            display: flex;
            justify-content: space-between;
            align-items: center;
        }

        .logo {
            font-family: "Orbitron", sans-serif;
            font-size: 28px;
            font-weight: bold;
            background: linear-gradient(45deg, var(--neon-blue), var(--neon-pink));
            -webkit-background-clip: text;
            -webkit-text-fill-color: transparent;
            text-shadow: 0 0 10px rgba(0, 240, 252, 0.5);
        }

        .search-container {
            display: flex;
            gap: 10px;
        }

        .search-box {
            background: rgba(255, 255, 255, 0.1);
            border: 1px solid var(--neon-purple);
            border-radius: 20px;
            padding: 8px 15px;
            color: white;
            width: 250px;
            transition: all 0.3s;
        }

        .search-box:focus {
            outline: none;
            box-shadow: 0 0 10px var(--neon-purple);
            border-color: var(--neon-blue);
        }

        .btn {
            background: linear-gradient(45deg, var(--neon-blue), var(--neon-purple));
            border: none;
            border-radius: 20px;
            padding: 8px 15px;
            color: white;
            cursor: pointer;
            transition: all 0.3s;
        }

        .btn:hover {
            box-shadow: 0 0 15px var(--neon-blue);
            transform: translateY(-2px);
        }

        .container {
            display: grid;
            grid-template-columns: 300px 1fr;
            gap: 20px;
            padding: 20px;
        }

        .sidebar {
            background: var(--card-bg);
            border-radius: 10px;
            padding: 20px;
            border: 1px solid rgba(0, 240, 252, 0.2);
            box-shadow: 0 0 20px rgba(0, 240, 252, 0.1);
        }

        .sidebar h2 {
            color: var(--neon-blue);
            margin-bottom: 15px;
            font-size: 18px;
            border-bottom: 1px solid var(--neon-blue);
            padding-bottom: 10px;
        }

        .filter-group {
            margin-bottom: 15px;
        }

        .filter-group label {
            display: block;
            margin-bottom: 5px;
            color: var(--neon-pink);
        }

        .filter-group select, .filter-group input {
            width: 100%;
            padding: 8px;
            border-radius: 5px;
            background: rgba(255, 255, 255, 0.1);
            border: 1px solid var(--neon-purple);
            color: white;
        }

        .main-content {
            display: flex;
            flex-direction: column;
            gap: 20px;
        }

        .dashboard {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));
            gap: 20px;
            margin-bottom: 20px;
        }

        .card {
            background: var(--card-bg);
            border-radius: 10px;
            padding: 20px;
            border: 1px solid rgba(138, 43, 226, 0.3);
            box-shadow: 0 0 15px rgba(138, 43, 226, 0.2);
            transition: all 0.3s;
        }

        .card:hover {
            transform: translateY(-5px);
            box-shadow: 0 0 20px rgba(138, 43, 226, 0.4);
        }

        .card h3 {
            color: var(--neon-pink);
            margin-bottom: 10px;
            font-size: 16px;
        }

        .card .value {
            font-size: 24px;
            font-weight: bold;
            color: var(--neon-blue);
        }

        .stocks-grid {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(300px, 1fr));
            gap: 20px;
        }

        .stock-card {
            background: var(--card-bg);
            border-radius: 10px;
            padding: 15px;
            border: 1px solid rgba(255, 45, 149, 0.3);
            box-shadow: 0 0 15px rgba(255, 45, 149, 0.2);
            transition: all 0.3s;
            position: relative;
            overflow: hidden;
        }

        .stock-card:hover {
            transform: translateY(-5px);
            box-shadow: 0 0 20px rgba(255, 45, 149, 0.4);
        }

        .stock-card::before {
            content: "";
            position: absolute;
            top: 0;
            left: 0;
            right: 0;
            height: 3px;
            background: linear-gradient(90deg, var(--neon-blue), var(--neon-pink));
        }

        .stock-header {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 10px;
        }

        .stock-name {
            font-weight: bold;
            font-size: 18px;
        }

        .stock-code {
            color: var(--neon-blue);
            font-size: 14px;
        }

        .stock-price {
            font-size: 22px;
            font-weight: bold;
            margin: 5px 0;
        }

        .stock-change {
            font-size: 16px;
            padding: 3px 8px;
            border-radius: 4px;
            display: inline-block;
        }

        .positive {
            color: #00ff00;
            background: rgba(0, 255, 0, 0.1);
        }

        .negative {
            color: #ff0000;
            background: rgba(255, 0, 0, 0.1);
        }

        .stock-volume, .stock-market-cap {
            font-size: 14px;
            color: #ccc;
            margin: 3px 0;
        }

        .stock-actions {
            display: flex;
            gap: 10px;
            margin-top: 15px;
        }

        .action-btn {
            padding: 5px 10px;
            border-radius: 5px;
            font-size: 12px;
            cursor: pointer;
            transition: all 0.3s;
        }

        .btn-predict {
            background: rgba(0, 240, 252, 0.2);
            border: 1px solid var(--neon-blue);
            color: var(--neon-blue);
        }

        .btn-predict:hover {
            background: rgba(0, 240, 252, 0.4);
            box-shadow: 0 0 10px var(--neon-blue);
        }

        .btn-report {
            background: rgba(255, 45, 149, 0.2);
            border: 1px solid var(--neon-pink);
            color: var(--neon-pink);
        }

        .btn-report:hover {
            background: rgba(255, 45, 149, 0.4);
            box-shadow: 0 0 10px var(--neon-pink);
        }

        .modal {
            display: none;
            position: fixed;
            top: 0;
            left: 0;
            width: 100%;
            height: 100%;
            background: rgba(0, 0, 0, 0.8);
            backdrop-filter: blur(5px);
            z-index: 1000;
            justify-content: center;
            align-items: center;
        }

        .modal-content {
            background: var(--dark-bg);
            border-radius: 10px;
            padding: 30px;
            width: 90%;
            max-width: 600px;
            border: 1px solid var(--neon-blue);
            box-shadow: 0 0 30px rgba(0, 240, 252, 0.5);
            position: relative;
        }

        .close-modal {
            position: absolute;
            top: 15px;
            right: 15px;
            font-size: 24px;
            color: var(--neon-pink);
            cursor: pointer;
            transition: all 0.3s;
        }

        .close-modal:hover {
            transform: rotate(90deg);
            color: var(--neon-blue);
        }

        .prediction-result {
            margin: 20px 0;
            padding: 15px;
            border-radius: 8px;
            background: rgba(255, 255, 255, 0.05);
        }

        .high-confidence {
            border: 1px solid #00ff00;
            box-shadow: 0 0 15px rgba(0, 255, 0, 0.2);
        }

        .medium-confidence {
            border: 1px solid #ffff00;
            box-shadow: 0 0 15px rgba(255, 255, 0, 0.2);
        }

        .low-confidence {
            border: 1px solid #ff0000;
            box-shadow: 0 0 15px rgba(255, 0, 0, 0.2);
        }

        .chart-container {
            height: 200px;
            margin: 15px 0;
            background: rgba(255, 255, 255, 0.05);
            border-radius: 5px;
            overflow: hidden;
        }

        .footer {
            text-align: center;
            padding: 20px;
            margin-top: 30px;
            border-top: 1px solid var(--neon-purple);
            color: #ccc;
            font-size: 14px;
        }

        /* Animações */
        @keyframes pulse {
            0% { opacity: 0.7; }
            50% { opacity: 1; }
            100% { opacity: 0.7; }
        }

        .pulse {
            animation: pulse 2s infinite;
        }

        @keyframes glow {
            0% { box-shadow: 0 0 5px var(--neon-blue); }
            50% { box-shadow: 0 0 20px var(--neon-blue); }
            100% { box-shadow: 0 0 5px var(--neon-blue); }
        }

        .glow {
            animation: glow 3s infinite;
        }

        /* Responsividade */
        @media (max-width: 768px) {
            .container {
                grid-template-columns: 1fr;
            }
            
            .dashboard {
                grid-template-columns: 1fr;
            }
            
            .search-box {
                width: 150px;
            }
        }
    </style>
</head>
<body>
    <header class="header">
        <div class="logo">PREGÃO ELETRÔNICO - BY PROFESSOR FABIO DE PAULA</div>
        <div class="search-container">
            <input type="text" id="searchBox" class="search-box" placeholder="Buscar ações...">
            <button class="btn" onclick="applyFilters()">Filtrar</button>
        </div>
    </header>

    <div class="container">
        <aside class="sidebar">
            <h2>Filtros</h2>
            <div class="filter-group">
                <label for="sectorFilter">Setor</label>
                <select id="sectorFilter">
                    <option value="all">Todos os Setores</option>
                    <option value="Tecnologia">Tecnologia</option>
                    <option value="Financeiro">Financeiro</option>
                    <option value="Energia">Energia</option>
                    <option value="Varejo">Varejo</option>
                    <option value="Saúde">Saúde</option>
                    <option value="Industrial">Industrial</option>
                    <option value="Consumo">Consumo</option>
                    <option value="Utilities">Utilities</option>
                </select>
            </div>
            <div class="filter-group">
                <label for="volumeFilter">Volume</label>
                <select id="volumeFilter">
                    <option value="all">Todos os Volumes</option>
                    <option value="high">Alto Volume</option>
                    <option value="medium">Médio Volume</option>
                    <option value="low">Baixo Volume</option>
                </select>
            </div>
            
            <h2>Indicadores</h2>
            <div class="card">
                <h3>Ibovespa</h3>
                <div class="value" id="ibovespaValue">Carregando...</div>
            </div>
            <div class="card">
                <h3>Maior Alta</h3>
                <div class="value" id="topGainer">-</div>
            </div>
            <div class="card">
                <h3>Maior Baixa</h3>
                <div class="value" id="topLoser">-</div>
            </div>
        </aside>

        <main class="main-content">
            <div class="dashboard">
                <div class="card glow">
                    <h3>Volume Total</h3>
                    <div class="value" id="totalVolume">Carregando...</div>
                </div>
                <div class="card">
                    <h3>Ações em Alta</h3>
                    <div class="value" id="stocksUp">-</div>
                </div>
                <div class="card">
                    <h3>Ações em Baixa</h3>
                    <div class="value" id="stocksDown">-</div>
                </div>
                <div class="card">
                    <h3>Última Atualização</h3>
                    <div class="value" id="lastUpdate"><?php echo date('H:i:s'); ?></div>
                </div>
            </div>

            <h2>Cotações em Tempo Real</h2>
            <div class="stocks-grid" id="stocksContainer">
                <div style="text-align:center; grid-column:1/-1; padding:40px; color:#ccc;">
                    Carregando dados do mercado...
                </div>
            </div>
        </main>
    </div>

    <div class="modal" id="predictionModal">
        <div class="modal-content">
            <span class="close-modal" onclick="closeModal()">&times;</span>
            <div id="modalContent">
                <!-- Conteúdo do modal será carregado aqui -->
            </div>
        </div>
    </div>

    <footer class="footer">
        Pregão Eletrônico - Bolsa de Valores em Tempo Real | Desenvolvido com PHP e SQLite | Dados fornecidos por Alpha Vantage
    </footer>

    <script>
        // Variáveis globais
        let stockData = [];
        let updateInterval;
        let currentModalContent = "";

        // Inicialização quando o documento estiver pronto
        document.addEventListener("DOMContentLoaded", function() {
            initializeDatabase();
            loadStockData();
            setupEventListeners();
            
            // Atualizar dados a cada 30 segundos
            updateInterval = setInterval(loadStockData, 30000);
        });

        // Configurar listeners de eventos
        function setupEventListeners() {
            // Busca dinâmica
            const searchBox = document.getElementById("searchBox");
            if (searchBox) {
                searchBox.addEventListener("input", function() {
                    filterStocks(this.value);
                });
            }
            
            // Filtros
            const sectorFilter = document.getElementById("sectorFilter");
            if (sectorFilter) {
                sectorFilter.addEventListener("change", applyFilters);
            }
            
            const volumeFilter = document.getElementById("volumeFilter");
            if (volumeFilter) {
                volumeFilter.addEventListener("change", applyFilters);
            }
        }

        // Carregar dados das ações
        function loadStockData() {
            fetch(window.location.href + "?action=get_stocks")
                .then(response => response.json())
                .then(data => {
                    if (data && data.length > 0) {
                        stockData = data;
                        renderStocks(data);
                        updateIndicators(data);
                    }
                })
                .catch(error => console.error("Erro ao carregar dados:", error));
        }

        // Filtrar ações com base na busca
        function filterStocks(searchTerm) {
            if (!searchTerm) {
                renderStocks(stockData);
                return;
            }
            
            const filtered = stockData.filter(stock => 
                stock.code.toLowerCase().includes(searchTerm.toLowerCase()) || 
                stock.name.toLowerCase().includes(searchTerm.toLowerCase()) ||
                stock.sector.toLowerCase().includes(searchTerm.toLowerCase())
            );
            
            renderStocks(filtered);
        }

        // Aplicar filtros selecionados
        function applyFilters() {
            const sector = document.getElementById("sectorFilter").value;
            const volume = document.getElementById("volumeFilter").value;
            
            let filtered = stockData;
            
            if (sector !== "all") {
                filtered = filtered.filter(stock => stock.sector === sector);
            }
            
            if (volume !== "all") {
                // Implementar filtro por volume quando disponível
            }
            
            renderStocks(filtered);
        }

        // Renderizar ações na grade
        function renderStocks(stocks) {
            const container = document.getElementById("stocksContainer");
            if (!container) return;
            
            container.innerHTML = "";
            
            stocks.forEach(stock => {
                const changeClass = stock.change >= 0 ? "positive" : "negative";
                const changeSymbol = stock.change >= 0 ? "↑" : "↓";
                
                const stockCard = document.createElement("div");
                stockCard.className = "stock-card";
                stockCard.innerHTML = `
                    <div class="stock-header">
                        <div class="stock-name">${stock.name}</div>
                        <div class="stock-code">${stock.code}</div>
                    </div>
                    <div class="stock-price">R$ ${stock.price.toFixed(2)}</div>
                    <div class="stock-change ${changeClass}">${changeSymbol} ${Math.abs(stock.change).toFixed(2)}%</div>
                    <div class="stock-volume">Volume: ${formatNumber(stock.volume)}</div>
                    <div class="stock-market-cap">Setor: ${stock.sector}</div>
                    <div class="stock-actions">
                        <button class="action-btn btn-predict" onclick="showPrediction('${stock.code}')">Análise Preditiva</button>
                        <button class="action-btn btn-report" onclick="generateReport('${stock.code}')">Relatório PDF</button>
                    </div>
                `;
                
                container.appendChild(stockCard);
            });
        }

        // Atualizar indicadores do dashboard
        function updateIndicators(stocks) {
            // Calcular totais
            let totalVolume = 0;
            let stocksUp = 0;
            let stocksDown = 0;
            let topGainer = { change: -Infinity };
            let topLoser = { change: Infinity };
            
            stocks.forEach(stock => {
                totalVolume += stock.volume;
                if (stock.change >= 0) {
                    stocksUp++;
                } else {
                    stocksDown++;
                }
                
                if (stock.change > topGainer.change) {
                    topGainer = stock;
                }
                
                if (stock.change < topLoser.change) {
                    topLoser = stock;
                }
            });
            
            // Atualizar UI
            const totalVolumeEl = document.getElementById("totalVolume");
            if (totalVolumeEl) {
                totalVolumeEl.textContent = formatNumber(totalVolume);
            }
            
            const stocksUpEl = document.getElementById("stocksUp");
            if (stocksUpEl) {
                stocksUpEl.textContent = stocksUp;
            }
            
            const stocksDownEl = document.getElementById("stocksDown");
            if (stocksDownEl) {
                stocksDownEl.textContent = stocksDown;
            }
            
            const topGainerEl = document.getElementById("topGainer");
            if (topGainerEl) {
                topGainerEl.textContent = topGainer.code ? `${topGainer.code} (+${topGainer.change.toFixed(2)}%)` : "-";
            }
            
            const topLoserEl = document.getElementById("topLoser");
            if (topLoserEl) {
                topLoserEl.textContent = topLoser.code ? `${topLoser.code} (${topLoser.change.toFixed(2)}%)` : "-";
            }
            
            // Simular valor do Ibovespa (em produção, buscar de API)
            const ibovespaEl = document.getElementById("ibovespaValue");
            if (ibovespaEl) {
                const randomValue = (100000 + Math.random() * 1000).toFixed(0);
                const randomChange = (Math.random() * 2 - 1).toFixed(2);
                const changeClass = randomChange >= 0 ? "positive" : "negative";
                ibovespaEl.innerHTML = `${randomValue} <span class="${changeClass}">${randomChange >= 0 ? '+' : ''}${randomChange}%</span>`;
            }
            
            // Atualizar hora
            const lastUpdateEl = document.getElementById("lastUpdate");
            if (lastUpdateEl) {
                lastUpdateEl.textContent = new Date().toLocaleTimeString();
            }
        }

        // Mostrar modal de previsão
        function showPrediction(stockCode) {
            fetch(window.location.href + "?action=get_prediction&code=" + stockCode)
                .then(response => response.json())
                .then(data => {
                    if (data) {
                        currentModalContent = `
                            <h2>Análise Preditiva - ${data.name} (${data.code})</h2>
                            <div class="chart-container">
                                <div style="height:100%; display:flex; justify-content:center; align-items:center; color:#ccc;">
                                    Gráfico de tendências para ${data.code}
                                </div>
                            </div>
                            <div class="prediction-result ${getConfidenceClass(data.confidence)}">
                                <h3>Resultado da Análise</h3>
                                <p>Probabilidade de ser um bom investimento: <strong>${(data.probability * 100).toFixed(2)}%</strong></p>
                                <p>Nível de confiança: ${data.confidence}</p>
                                <p>Recomendação: ${data.recommendation}</p>
                                <p>${data.analysis}</p>
                            </div>
                            <button class="btn" onclick="generateReport('${data.code}')">Gerar Relatório PDF</button>
                        `;
                        
                        document.getElementById("modalContent").innerHTML = currentModalContent;
                        document.getElementById("predictionModal").style.display = "flex";
                    }
                })
                .catch(error => {
                    console.error("Erro ao carregar previsão:", error);
                    alert("Erro ao carregar análise preditiva.");
                });
        }

        // Gerar relatório PDF
        function generateReport(stockCode) {
            window.location.href = window.location.href + "?action=generate_report&code=" + stockCode;
        }

        // Fechar modal
        function closeModal() {
            document.getElementById("predictionModal").style.display = "none";
        }

        // Obter classe de confiança para estilização
        function getConfidenceClass(confidence) {
            switch(confidence) {
                case "Alta": return "high-confidence";
                case "Média": return "medium-confidence";
                case "Baixa": return "low-confidence";
                default: return "";
            }
        }

        // Formatar números grandes (milhões, bilhões)
        function formatNumber(num) {
            if (num >= 1000000000) {
                return (num / 1000000000).toFixed(2) + ' Bi';
            }
            if (num >= 1000000) {
                return (num / 1000000).toFixed(2) + ' Mi';
            }
            if (num >= 1000) {
                return (num / 1000).toFixed(2) + ' Mil';
            }
            return num;
        }

        // Inicializar banco de dados
        function initializeDatabase() {
            fetch(window.location.href + "?action=init_db")
                .then(response => response.text())
                .then(data => console.log("Banco de dados inicializado"))
                .catch(error => console.error("Erro ao inicializar BD:", error));
        }
    </script>
</body>
</html>
        <?php
        return ob_get_clean();
    }
}

// Inicializar e executar o sistema
$system = new StockMarketSystem();
echo $system->generateHTML();
?>