<?php
require_once 'config.php';

$db = new Database($pdo);

// 获取网站列表
$websites = $db->getWebsites(false);

// 处理添加网站请求
if (isset($_POST['add_website'])) {
    $websiteData = [
        'name' => $_POST['name'],
        'db_host' => $_POST['db_host'],
        'db_name' => $_POST['db_name'],
        'db_user' => $_POST['db_user'],
        'db_pass' => $_POST['db_pass'],
        'table_prefix' => $_POST['table_prefix'],
        'svip_groupid' => $_POST['svip_groupid'],
        'status' => isset($_POST['status']) ? 1 : 0
    ];
    
    if ($db->addWebsite($websiteData)) {
        $message = "网站添加成功";
        // 刷新页面
        header("Location: websites.php?message=" . urlencode($message));
        exit;
    } else {
        $error = "网站添加失败";
    }
}
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>网站管理 - SVIP转化率分析系统</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
    <div class="container py-4">
        <h1 class="text-center mb-4">网站管理</h1>
        
        <?php if (isset($message)): ?>
        <div class="alert alert-success"><?php echo $message; ?></div>
        <?php endif; ?>
        
        <?php if (isset($error)): ?>
        <div class="alert alert-danger"><?php echo $error; ?></div>
        <?php endif; ?>
        
        <div class="row">
            <div class="col-md-6">
                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">添加新网站</h5>
                    </div>
                    <div class="card-body">
                        <form method="post">
                            <div class="mb-3">
                                <label class="form-label">网站名称</label>
                                <input type="text" name="name" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label">数据库地址</label>
                                <input type="text" name="db_host" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label">数据库名</label>
                                <input type="text" name="db_name" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label">数据库用户</label>
                                <input type="text" name="db_user" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label">数据库密码</label>
                                <input type="password" name="db_pass" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label class="form-label">表前缀</label>
                                <input type="text" name="table_prefix" class="form-control" value="yecha_">
                            </div>
                            <div class="mb-3">
                                <label class="form-label">SVIP用户组ID</label>
                                <input type="number" name="svip_groupid" class="form-control" value="18">
                            </div>
                            <div class="mb-3 form-check">
                                <input type="checkbox" name="status" class="form-check-input" checked>
                                <label class="form-check-label">启用</label>
                            </div>
                            <button type="submit" name="add_website" class="btn btn-primary">添加网站</button>
                        </form>
                    </div>
                </div>
            </div>
            
            <div class="col-md-6">
                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">网站列表</h5>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-striped">
                                <thead>
                                    <tr>
                                        <th>网站名称</th>
                                        <th>数据库</th>
                                        <th>状态</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php foreach ($websites as $website): ?>
                                    <tr>
                                        <td><?php echo htmlspecialchars($website['name']); ?></td>
                                        <td><?php echo $website['db_user'] . '@' . $website['db_host'] . '/' . $website['db_name']; ?></td>
                                        <td>
                                            <span class="badge bg-<?php echo $website['status'] ? 'success' : 'secondary'; ?>">
                                                <?php echo $website['status'] ? '启用' : '停用'; ?>
                                            </span>
                                        </td>
                                    </tr>
                                    <?php endforeach; ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        
        <div class="mt-4">
            <a href="index.php" class="btn btn-outline-primary">返回首页</a>
        </div>
    </div>
</body>
</html>