getUserId();
$username = $session->getUsername();
$role = $session->getRole();
// 获取用户账户信息
try {
$db = Database::getInstance();
$conn = $db->getConnection();
// 检查字段是否存在
$result = $conn->query("SHOW COLUMNS FROM users LIKE 'balance'");
if ($result->num_rows === 0) {
// 添加余额相关字段
$conn->query("
ALTER TABLE users
ADD COLUMN balance decimal(20,8) NOT NULL DEFAULT '0.00000000' AFTER points,
ADD COLUMN commission_balance decimal(20,8) NOT NULL DEFAULT '0.00000000' AFTER balance,
ADD COLUMN total_commission decimal(20,8) NOT NULL DEFAULT '0.00000000' AFTER commission_balance
");
}
// 获取用户信息
$stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$user_id]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
// 确保所有必要的字段都有默认值
$user['balance'] = $user['balance'] ?? 0;
$user['commission_balance'] = $user['commission_balance'] ?? 0;
$user['total_commission'] = $user['total_commission'] ?? 0;
// 初始化账户余额
$balance = [
'total' => 0, // 总资产
'available' => 0, // 可用余额
'frozen' => 0, // 冻结金额
'profit' => 0, // 累计收益
'yesterday' => 0, // 昨日收益
'today' => 0 // 今日收益
];
// 获取账户余额信息
$stmt = $conn->prepare("SELECT * FROM user_balance WHERE user_id = ?");
$stmt->execute([$user_id]);
$balanceResult = $stmt->fetch(PDO::FETCH_ASSOC);
if ($balanceResult) {
$balance = array_merge($balance, $balanceResult);
}
// 获取API数量
$apiCount = getApiCount($user_id);
// 获取策略数量
$strategyCount = getActiveStrategyCount($user_id);
// 获取推荐人数
$referralCount = getReferralCount($user_id);
// 获取最近的交易记录
$recentTrades = getRecentTrades($user_id);
$stat = get_user_commission_stat($user_id);
$commission_can_withdraw = $stat['can_withdraw'];
} catch (Exception $e) {
error_log("获取用户信息失败: " . $e->getMessage());
$_SESSION['flash'] = ['type' => 'danger', 'message' => '获取用户信息失败'];
}
$pdfUrl = !empty($GLOBALS['partnerInfo']['manual_pdf']) ? $GLOBALS['partnerInfo']['manual_pdf'] : '/help.pdf';
$bannerImg = !empty($GLOBALS['partnerInfo']['banner_img']) ? $GLOBALS['partnerInfo']['banner_img'] : '/uploads/partner_logo/index.gif';
$page_title = '控制面板';
include 'templates/header.php';
?>
控制面板
调试信息： 用户角色ID: |
是否为合伙人:
最近交易