<?php
// 数据库配置
define('DB_HOST', '127.0.0.1');
define('DB_PORT', 3306);
define('DB_NAME', 'liuqu_dns');
define('DB_USER', 'liuqu_dns');
define('DB_PASSWORD', 'password');

// 连接数据库
$conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, DB_PORT);
if (!$conn) {
    die("数据库连接失败：" . mysqli_connect_error());
}
mysqli_set_charset($conn, 'utf8mb4');

// 初始化变量
$id = $username = $email = $phone = $password_hash = $status = $balance = $max_domains = $verified = '';
$msg = '';

// 新增用户
if (isset($_POST['add'])) {
    $username = trim($_POST['username']);
    $email = trim($_POST['email']);
    $phone = trim($_POST['phone']);
    $password_hash = trim($_POST['password_hash']);
    $status = (int)$_POST['status'];
    $balance = (float)$_POST['balance'];
    $max_domains = (int)$_POST['max_domains'];
    $verified = (int)$_POST['verified'];

    if ($username && $email) {
        $sql = "INSERT INTO users (username, email, phone, password_hash, status, balance, max_domains, verified)
                VALUES ('$username','$email','$phone','$password_hash',$status,$balance,$max_domains,$verified)";
        if (mysqli_query($conn, $sql)) {
            $msg = '<div class="alert success">新增成功！</div>';
        } else {
            $msg = '<div class="alert error">新增失败：' . mysqli_error($conn) . '</div>';
        }
    } else {
        $msg = '<div class="alert error">用户名和邮箱为必填项！</div>';
    }
}

// 编辑用户
if (isset($_POST['edit'])) {
    $id = (int)$_POST['id'];
    $username = trim($_POST['username']);
    $email = trim($_POST['email']);
    $phone = trim($_POST['phone']);
    $password_hash = trim($_POST['password_hash']);
    $status = (int)$_POST['status'];
    $balance = (float)$_POST['balance'];
    $max_domains = (int)$_POST['max_domains'];
    $verified = (int)$_POST['verified'];

    if ($id && $username && $email) {
        $sql = "UPDATE users SET
                username='$username',email='$email',phone='$phone',password_hash='$password_hash',
                status=$status,balance=$balance,max_domains=$max_domains,verified=$verified
                WHERE id=$id";
        if (mysqli_query($conn, $sql)) {
            $msg = '<div class="alert success">修改成功！</div>';
        } else {
            $msg = '<div class="alert error">修改失败：' . mysqli_error($conn) . '</div>';
        }
    }
}

// 删除用户
if (isset($_GET['del'])) {
    $id = (int)$_GET['del'];
    mysqli_query($conn, "DELETE FROM users WHERE id=$id");
    $msg = '<div class="alert success">删除成功！</div>';
}

// 获取编辑数据
$editData = null;
if (isset($_GET['edit'])) {
    $id = (int)$_GET['edit'];
    $res = mysqli_query($conn, "SELECT * FROM users WHERE id=$id");
    $editData = mysqli_fetch_assoc($res);
}

// 查询所有用户
$users = mysqli_query($conn, "SELECT * FROM users ORDER BY id DESC");
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>用户管理系统</title>
    <style>
        *{margin:0;padding:0;box-sizing:border-box;font-family:Arial,'Microsoft YaHei'}
        body{background:#f5f7fa;padding:20px}
        .container{max-width:1200px;margin:0 auto;background:#fff;border-radius:10px;box-shadow:0 2px 10px rgba(0,0,0,0.05);padding:20px}
        h1{text-align:center;color:#333;margin-bottom:20px}
        .alert{padding:12px 15px;border-radius:5px;margin-bottom:15px}
        .success{background:#e6f7e6;color:#28a745}
        .error{background:#f8e6e6;color:#dc3545}
        .form-box{border:1px solid #eee;border-radius:8px;padding:20px;margin-bottom:25px}
        .form-title{font-size:18px;color:#333;margin-bottom:15px}
        .form-group{margin-bottom:12px;display:flex;align-items:center}
        .form-group label{width:110px;font-weight:bold;color:#555}
        input,select{padding:8px 10px;border:1px solid #ddd;border-radius:5px;width:100%;outline:none}
        .btn{padding:8px 16px;border:none;border-radius:5px;color:#fff;cursor:pointer;margin-right:5px}
        .btn-primary{background:#007bff}
        .btn-success{background:#28a745}
        .btn-danger{background:#dc3545}
        table{width:100%;border-collapse:collapse;margin-top:10px}
        th,td{padding:12px;text-align:left;border-bottom:1px solid #eee}
        th{background:#f8f9fa;color:#333}
        tr:hover{background:#fafafa}
        .text-center{text-align:center}
        .badge{padding:4px 8px;border-radius:4px;color:#fff;font-size:12px}
        .bg-green{background:#28a745}
        .bg-red{background:#dc3545}
        .flex{display:flex;gap:10px;flex-wrap:wrap}
    </style>
</head>
<body>
<div class="container">
    <h1>用户管理系统</h1>
    <?=$msg?>

    <!-- 新增/编辑表单 -->
    <div class="form-box">
        <div class="form-title"><?=$editData ? '编辑用户' : '新增用户'?></div>
        <form method="post">
            <?php if($editData): ?>
                <input type="hidden" name="id" value="<?=$editData['id']?>">
            <?php endif; ?>
            <div class="form-group">
                <label>用户名：</label>
                <input type="text" name="username" required value="<?=$editData['username']??''?>">
            </div>
            <div class="form-group">
                <label>邮箱：</label>
                <input type="email" name="email" required value="<?=$editData['email']??''?>">
            </div>
            <div class="form-group">
                <label>手机号：</label>
                <input type="text" name="phone" value="<?=$editData['phone']??''?>">
            </div>
            <div class="form-group">
                <label>密码HASH：</label>
                <input type="text" name="password_hash" value="<?=$editData['password_hash']??''?>">
            </div>
            <div class="form-group">
                <label>账户状态：</label>
                <select name="status">
                    <option value="1" <?=($editData['status']??1)==1?'selected':''?>>启用</option>
                    <option value="0" <?=($editData['status']??0)==0?'selected':''?>>禁用</option>
                </select>
            </div>
            <div class="form-group">
                <label>余额：</label>
                <input type="number" step="0.01" name="balance" value="<?=$editData['balance']??0?>">
            </div>
            <div class="form-group">
                <label>可用域名数：</label>
                <input type="number" name="max_domains" value="<?=$editData['max_domains']??5?>">
            </div>
            <div class="form-group">
                <label>实名认证：</label>
                <select name="verified">
                    <option value="0" <?=($editData['verified']??0)==0?'selected':''?>>未认证</option>
                    <option value="1" <?=($editData['verified']??1)==1?'selected':''?>>已认证</option>
                </select>
            </div>
            <div style="margin-top:15px">
                <?php if($editData): ?>
                    <button type="submit" name="edit" class="btn btn-success">保存修改</button>
                    <a href="?" class="btn" style="background:#6c757d;color:#fff">取消</a>
                <?php else: ?>
                    <button type="submit" name="add" class="btn btn-primary">添加用户</button>
                <?php endif; ?>
            </div>
        </form>
    </div>

    <!-- 用户列表 -->
    <div class="form-title">用户列表</div>
    <table>
        <tr>
            <th>ID</th><th>用户名</th><th>邮箱</th><th>手机</th><th>状态</th><th>余额</th><th>域名数</th><th>认证</th><th>创建时间</th><th>操作</th>
        </tr>
        <?php while($u=mysqli_fetch_assoc($users)): ?>
        <tr>
            <td><?=$u['id']?></td>
            <td><?=$u['username']?></td>
            <td><?=$u['email']?></td>
            <td><?=$u['phone']?:'-'?></td>
            <td><span class="badge <?= $u['status']?'bg-green':'bg-red' ?>"><?=$u['status']?'启用':'禁用'?></span></td>
            <td><?=$u['balance']?></td>
            <td><?=$u['max_domains']?></td>
            <td><span class="badge <?= $u['verified']?'bg-green':'bg-red' ?>"><?=$u['verified']?'已认证':'未认证'?></span></td>
            <td><?=$u['created_at']?></td>
            <td class="flex">
                <a href="?edit=<?=$u['id']?>" class="btn" style="background:#007bff">编辑</a>
                <a href="?del=<?=$u['id']?>" class="btn btn-danger" onclick="return confirm('确定删除？')">删除</a>
            </td>
        </tr>
        <?php endwhile; ?>
    </table>
</div>
</body>
</html>
