getRole() === 'admin' && strpos($_SERVER['PHP_SELF'], '/admin/') !== false) {
include 'templates/admin/sidebar.php';
} else {
include 'templates/sidebar.php';
}
?>
API配置
暂无API配置
| 交易所 | 只读API Key | 只读API Secret | 交易API Key | 交易API Secret | 账户权益 | 可用资金 | 仓位占比 | 昨日盈亏 | 当日盈亏 | 备注 | 状态 | 添加时间 | 操作 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
0,
'available_balance' => 0,
'position_ratio' => 0
];
// 获取账户余额信息（现货账户）
$spot_balance = [
'total_equity' => 0,
'available_balance' => 0
];
try {
// 检查表是否存在
$tableCheck = $conn->query("SHOW TABLES LIKE 'exchange_account_balances'");
if ($tableCheck === false) {
throw new Exception("检查表失败: " . $conn->error);
}
if ($tableCheck->num_rows === 0) {
// 创建表
$result = $conn->query("
CREATE TABLE IF NOT EXISTS `exchange_account_balances` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`api_id` int(11) NOT NULL,
`account_type` enum('futures','spot') NOT NULL,
`total_equity` decimal(20,8) NOT NULL DEFAULT '0.00000000',
`available_balance` decimal(20,8) NOT NULL DEFAULT '0.00000000',
`position_ratio` decimal(10,2) NOT NULL DEFAULT '0.00',
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `api_id` (`api_id`),
CONSTRAINT `exchange_account_balances_ibfk_1` FOREIGN KEY (`api_id`) REFERENCES `exchange_apis` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
");
if ($result === false) {
throw new Exception("创建表失败: " . $conn->error);
}
}
// 获取合约账户余额
$stmt = $conn->prepare("
SELECT total_equity, available_balance, position_ratio
FROM exchange_account_balances
WHERE api_id = ? AND account_type = 'futures'
ORDER BY updated_at DESC
LIMIT 1
");
if ($stmt === false) {
throw new Exception("准备合约账户查询语句失败: " . $conn->error);
}
$stmt->execute([$api['id']]);
$result = $stmt->get_result();
if ($result === false) {
throw new Exception("获取合约账户结果失败: " . $stmt->error);
}
if ($row = $result->fetch_assoc()) {
$futures_balance = array_merge($futures_balance, $row);
}
// 获取现货账户余额
$stmt = $conn->prepare("
SELECT total_equity, available_balance
FROM exchange_account_balances
WHERE api_id = ? AND account_type = 'spot'
ORDER BY updated_at DESC
LIMIT 1
");
if ($stmt === false) {
throw new Exception("准备现货账户查询语句失败: " . $conn->error);
}
$stmt->execute([$api['id']]);
$result = $stmt->get_result();
if ($row = $result->fetch_assoc()) {
$spot_balance = array_merge($spot_balance, $row);
}
} catch (Exception $e) {
error_log("获取API账户余额失败: " . $e->getMessage());
// 设置默认值
$futures_balance = [
'total_equity' => 0,
'available_balance' => 0,
'position_ratio' => 0
];
$spot_balance = [
'total_equity' => 0,
'available_balance' => 0
];
}
?>
合约账户：
总权益: USDT
可用资金: USDT
仓位占比: %
现货账户：
总权益: USDT
可用资金: USDT
|
API配置说明
权限要求
- 读取账户资产
- 读取交易记录
- 交易下单（如需自动交易）
注意事项
- 请勿泄露API密钥，定期更换密钥
- 建议设置IP白名单
- 建议只开启必要的API权限