<?php
require_once '../includes/auth.php';
require_once '../includes/language_manager.php';

$auth = new Auth();
$auth->requireLogin();

// Get system settings
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();

$settings = [];
$query = "SELECT * FROM system_settings";
$stmt = $db->prepare($query);
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($results as $setting) {
    $settings[$setting['setting_key']] = $setting['setting_value'];
}
?>
<!DOCTYPE html>
<html lang="zh-TW">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>系統設定 - SEO AI 自動化系統</title>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css" rel="stylesheet">
    <link href="../assets/css/admin.css" rel="stylesheet">
</head>
<body>
<?php include '../includes/language_switcher.php'; ?>
    <div class="admin-layout">
        <!-- Sidebar -->
        <aside class="sidebar">
            <div class="sidebar-header">
                <div class="logo">
                    <i class="fas fa-robot"></i>
                    <span>SEO AI</span>
                </div>
            </div>
            
            <nav class="sidebar-nav">
                <ul>
                    <li>
                        <a href="dashboard.php">
                            <i class="fas fa-tachometer-alt"></i>
                            <span>儀表板</span>
                        </a>
                    </li>
                    <li>
                        <a href="brands.php">
                            <i class="fas fa-building"></i>
                            <span>品牌管理</span>
                        </a>
                    </li>
                    <li>
                        <a href="reports.php">
                            <i class="fas fa-chart-line"></i>
                            <span>SEO報告</span>
                        </a>
                    </li>
                    <li>
                        <a href="content.php">
                            <i class="fas fa-edit"></i>
                            <span>內容管理</span>
                        </a>
                    </li>
                    <li>
                        <a href="analytics.php">
                            <i class="fas fa-analytics"></i>
                            <span>成效分析</span>
                        </a>
                    </li>
                    <li class="active">
                        <a href="settings.php">
                            <i class="fas fa-cog"></i>
                            <span>系統設定</span>
                        </a>
                    </li>
                    <li>
                        <a href="help.php">
                            <i class="fas fa-question-circle"></i>
                            <span>使用說明</span>
                        </a>
                    </li>
                </ul>
            </nav>
        </aside>
        
        <!-- Main Content -->
        <main class="main-content">
            <!-- Header -->
            <header class="header">
                <div class="header-left">
                    <h1>系統設定</h1>
                    <p>管理系統配置和API設定</p>
                </div>
                <div class="header-right">
                    <div class="user-menu">
                        <div class="user-info">
                            <i class="fas fa-user-circle"></i>
                            <span><?php echo htmlspecialchars($_SESSION['username']); ?></span>
                        </div>
                        <div class="user-dropdown">
                            <a href="profile.php"><i class="fas fa-user"></i> 個人資料</a>
                            <a href="settings.php"><i class="fas fa-cog"></i> 設定</a>
                            <a href="logout.php"><i class="fas fa-sign-out-alt"></i> 登出</a>
                        </div>
                    </div>
                </div>
            </header>
            
            <!-- Settings Content -->
            <div class="settings-content">
                <div class="settings-sections">
                    <!-- API Settings -->
                    <div class="settings-section">
                        <h2><i class="fas fa-key"></i> API 設定</h2>
                        <div class="form-container">
                            <form id="apiSettingsForm">
                                <div class="form-group">
                                    <label for="gptApiKey">OpenAI GPT API Key</label>
                                    <div class="input-group">
                                        <input type="password" id="gptApiKey" name="gpt_api_key" class="form-control" 
                                               value="<?php echo htmlspecialchars($settings['gpt_api_key'] ?? ''); ?>">
                                        <button type="button" class="btn-icon" onclick="togglePassword('gptApiKey')">
                                            <i class="fas fa-eye"></i>
                                        </button>
                                    </div>
                                    <small class="form-text">用於AI內容生成和SEO分析</small>
                                </div>
                                
                                <div class="form-group">
                                    <label for="siteTitle">網站標題</label>
                                    <input type="text" id="siteTitle" name="site_title" class="form-control" 
                                           value="<?php echo htmlspecialchars($settings['site_title'] ?? ''); ?>">
                                </div>
                                
                                <div class="form-group">
                                    <label for="siteDescription">網站描述</label>
                                    <textarea id="siteDescription" name="site_description" class="form-control" rows="3"><?php echo htmlspecialchars($settings['site_description'] ?? ''); ?></textarea>
                                </div>
                                
                                <button type="submit" class="btn btn-primary">
                                    <i class="fas fa-save"></i>
                                    儲存設定
                                </button>
                            </form>
                        </div>
                    </div>
                    
                    <!-- System Info -->
                    <div class="settings-section">
                        <h2><i class="fas fa-info-circle"></i> 系統資訊</h2>
                        <div class="info-grid">
                            <div class="info-card">
                                <div class="info-icon">
                                    <i class="fas fa-server"></i>
                                </div>
                                <div class="info-content">
                                    <h3>PHP 版本</h3>
                                    <p><?php echo PHP_VERSION; ?></p>
                                </div>
                            </div>
                            
                            <div class="info-card">
                                <div class="info-icon">
                                    <i class="fas fa-database"></i>
                                </div>
                                <div class="info-content">
                                    <h3>MySQL 版本</h3>
                                    <p><?php 
                                        try {
                                            $version = $db->query('SELECT VERSION()')->fetchColumn();
                                            echo $version;
                                        } catch (Exception $e) {
                                            echo '無法取得版本資訊';
                                        }
                                    ?></p>
                                </div>
                            </div>
                            
                            <div class="info-card">
                                <div class="info-icon">
                                    <i class="fas fa-hdd"></i>
                                </div>
                                <div class="info-content">
                                    <h3>磁碟空間</h3>
                                    <p><?php 
                                        $bytes = disk_free_space('.');
                                        $gb = round($bytes / 1024 / 1024 / 1024, 2);
                                        echo $gb . ' GB 可用';
                                    ?></p>
                                </div>
                            </div>
                            
                            <div class="info-card">
                                <div class="info-icon">
                                    <i class="fas fa-memory"></i>
                                </div>
                                <div class="info-content">
                                    <h3>記憶體限制</h3>
                                    <p><?php echo ini_get('memory_limit'); ?></p>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <!-- Database Status -->
                    <div class="settings-section">
                        <h2><i class="fas fa-database"></i> 資料庫狀態</h2>
                        <div class="status-grid">
                            <div class="status-item">
                                <span class="status-label">連線狀態</span>
                                <span class="status-value success">
                                    <i class="fas fa-check-circle"></i>
                                    正常
                                </span>
                            </div>
                            
                            <div class="status-item">
                                <span class="status-label">資料表數量</span>
                                <span class="status-value">
                                    <?php 
                                        try {
                                            $count = $db->query("SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'seoai_db'")->fetchColumn();
                                            echo $count;
                                        } catch (Exception $e) {
                                            echo 'N/A';
                                        }
                                    ?>
                                </span>
                            </div>
                            
                            <div class="status-item">
                                <span class="status-label">品牌數量</span>
                                <span class="status-value">
                                    <?php 
                                        try {
                                            $count = $db->query("SELECT COUNT(*) FROM brands")->fetchColumn();
                                            echo $count;
                                        } catch (Exception $e) {
                                            echo 'N/A';
                                        }
                                    ?>
                                </span>
                            </div>
                            
                            <div class="status-item">
                                <span class="status-label">報告數量</span>
                                <span class="status-value">
                                    <?php 
                                        try {
                                            $count = $db->query("SELECT COUNT(*) FROM seo_reports")->fetchColumn();
                                            echo $count;
                                        } catch (Exception $e) {
                                            echo 'N/A';
                                        }
                                    ?>
                                </span>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </main>
    </div>
    
    <style>
        .settings-content {
            padding: 30px;
        }
        
        .settings-sections {
            max-width: 1000px;
            margin: 0 auto;
        }
        
        .settings-section {
            background: white;
            border-radius: 15px;
            padding: 30px;
            margin-bottom: 30px;
            box-shadow: 0 5px 20px rgba(0, 0, 0, 0.08);
        }
        
        .settings-section h2 {
            font-size: 1.5rem;
            font-weight: 600;
            color: #333;
            margin-bottom: 25px;
            display: flex;
            align-items: center;
            gap: 10px;
        }
        
        .input-group {
            position: relative;
            display: flex;
        }
        
        .input-group .form-control {
            flex: 1;
            padding-right: 45px;
        }
        
        .input-group .btn-icon {
            position: absolute;
            right: 5px;
            top: 50%;
            transform: translateY(-50%);
            width: 35px;
            height: 35px;
            border: none;
            background: #f8f9fa;
            border-radius: 6px;
            cursor: pointer;
            display: flex;
            align-items: center;
            justify-content: center;
        }
        
        .form-text {
            color: #666;
            font-size: 0.85rem;
            margin-top: 5px;
        }
        
        .info-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 20px;
        }
        
        .info-card {
            background: #f8f9fa;
            padding: 20px;
            border-radius: 10px;
            display: flex;
            align-items: center;
            gap: 15px;
        }
        
        .info-icon {
            width: 50px;
            height: 50px;
            background: linear-gradient(135deg, #667eea, #764ba2);
            border-radius: 10px;
            display: flex;
            align-items: center;
            justify-content: center;
            color: white;
            font-size: 1.2rem;
        }
        
        .info-content h3 {
            font-size: 0.9rem;
            color: #666;
            margin-bottom: 5px;
        }
        
        .info-content p {
            font-size: 1.1rem;
            font-weight: 600;
            color: #333;
            margin: 0;
        }
        
        .status-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 20px;
        }
        
        .status-item {
            background: #f8f9fa;
            padding: 20px;
            border-radius: 10px;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        
        .status-label {
            font-weight: 500;
            color: #333;
        }
        
        .status-value {
            font-weight: 600;
            color: #666;
        }
        
        .status-value.success {
            color: #4ecdc4;
        }
        
        .status-value.success i {
            margin-right: 5px;
        }
    </style>
    
    <script src="../assets/js/admin.js"></script>
    <script>
        function togglePassword(inputId) {
            const input = document.getElementById(inputId);
            const button = input.nextElementSibling;
            const icon = button.querySelector('i');
            
            if (input.type === 'password') {
                input.type = 'text';
                icon.className = 'fas fa-eye-slash';
            } else {
                input.type = 'password';
                icon.className = 'fas fa-eye';
            }
        }
        
        // Handle form submission
        document.getElementById('apiSettingsForm').addEventListener('submit', function(e) {
            e.preventDefault();
            
            const formData = new FormData(this);
            const data = Object.fromEntries(formData);
            
            // TODO: Send to API
            console.log('Settings data:', data);
            saveSettings(data);
        
        function saveSettings(data) {
            fetch('/api/settings.php', {
                method: 'POST',
                headers: {
                    'Content-Type': 'application/json',
                },
                credentials: 'same-origin',
                body: JSON.stringify({
                    action: 'save_settings',
                    ...data
                })
            })
            .then(response => response.json())
            .then(result => {
                if (result.success) {
                    alert('設定保存成功！');
                } else {
                    alert('保存失敗: ' + result.message);
                }
            })
            .catch(error => {
                console.error('Error:', error);
                alert('網路錯誤，請稍後再試');
            });
        }
        });
    </script>
</body>
</html>
