<?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;
    
    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());
        }
    }
    
    public function fetchRealTimeData() {
        // Simulação de dados - em produção, integrar com API real
        $sectors = ["Tecnologia", "Financeiro", "Energia", "Varejo", "Saúde", "Industrial", "Consumo", "Utilities"];
        $companies = [
            ["PETR4", "Petróleo Brasileiro S.A.", "Energia"],
            ["VALE3", "Vale S.A.", "Industrial"],
            ["ITUB4", "Itaú Unibanco Holding S.A.", "Financeiro"],
            ["BBDC4", "Banco Bradesco S.A.", "Financeiro"],
            ["WEGE3", "WEG S.A.", "Industrial"],
            ["MGLU3", "Magazine Luiza S.A.", "Varejo"],
            ["B3SA3", "B3 S.A. - Brasil Bolsa Balcão", "Financeiro"],
            ["RENT3", "Localiza Rent a Car S.A.", "Varejo"],
            ["BBAS3", "Banco do Brasil S.A.", "Financeiro"],
            ["ABEV3", "Ambev S.A.", "Consumo"],
            ["JBSS3", "JBS S.A.", "Consumo"],
            ["RADL3", "Raia Drogasil S.A.", "Saúde"],
            ["CSAN3", "Cosan S.A.", "Energia"],
            ["LREN3", "Lojas Renner S.A.", "Varejo"],
            ["SBSP3", "Sabesp", "Utilities"]
        ];
        
        $stocks = [];
        foreach ($companies as $company) {
            $basePrice = rand(500, 10000) / 10;
            $change = (rand(-100, 100) / 10);
            $price = $basePrice * (1 + $change/100);
            
            $stocks[] = [
                'code' => $company[0],
                'name' => $company[1],
                'price' => round($price, 2),
                'change' => $change,
                'volume' => rand(100000, 5000000),
                'sector' => $company[2]
            ];
            
            // Salvar no banco de dados
            $this->saveStockData($company[0], $company[1], $price, $change, rand(100000, 5000000), $company[2]);
        }
        
        return $stocks;
    }
    
    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) {
        // Simulação de análise preditiva - em produção, usar modelos reais de ML
        $probabilities = [
            "PETR4" => 0.75,
            "VALE3" => 0.82,
            "ITUB4" => 0.68,
            "BBDC4" => 0.63,
            "WEGE3" => 0.89,
            "MGLU3" => 0.42,
            "B3SA3" => 0.71,
            "RENT3" => 0.78,
            "BBAS3" => 0.65,
            "ABEV3" => 0.59,
            "JBSS3" => 0.53,
            "RADL3" => 0.81,
            "CSAN3" => 0.67,
            "LREN3" => 0.74,
            "SBSP3" => 0.86
        ];
        
        $confidenceLevels = ["Baixa", "Média", "Alta"];
        $recommendations = [
            "Compra Forte", "Compra", "Compra Moderada", 
            "Neutra", "Venda Moderada", "Venda", "Venda Forte"
        ];
        
        $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."
        ];
        
        $probability = $probabilities[$code] ?? rand(40, 90) / 100;
        $confidence = $confidenceLevels[rand(0, 2)];
        $recommendation = $recommendations[rand(0, 6)];
        $analysis = $analyses[rand(0, 6)];
        
        // 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
        ];
    }
    
    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;
        }
        
        // Retornar o HTML completo
        return $this->getPageHTML();
    }
    
    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</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 simulados para fins demonstrativos
    </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;
            
            stocks.forEach(stock => {
                totalVolume += stock.volume;
                if (stock.change >= 0) {
                    stocksUp++;
                } else {
                    stocksDown++;
                }
            });
            
            // 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;
            }
            
            // Simular valor do Ibovespa
            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) {
            // Em uma implementação real, isso faria uma requisição para gerar o PDF
            alert(`Relatório PDF para ${stockCode} será gerado. Em uma implementação real, isso baixaria um PDF.`);
            
            // Simular download
            const link = document.createElement("a");
            link.href = "#";
            link.download = `relatorio_${stockCode}.pdf`;
            link.click();
        }

        // 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();
?>