connect_error) {
error_log("Kết nối database thất bại: " . $mysqli->connect_error);
http_response_code(500);
echo "Kết nối thất bại: " . htmlspecialchars($mysqli->connect_error);
exit;
}
// Thống kê lệnh Open
$open_count_query = "SELECT COUNT(*) as open_count FROM orders WHERE danh_dau = 'Open'";
$buy_chinh_query = "SELECT COUNT(*) as buy_chinh_count FROM orders WHERE danh_dau = 'Open' AND side = 'BUY' AND phan_biet = 'Chinh'";
$sell_chinh_query = "SELECT COUNT(*) as sell_chinh_count FROM orders WHERE danh_dau = 'Open' AND side = 'SELL' AND phan_biet = 'Chinh'";
$buy_nguoc_query = "SELECT COUNT(*) as buy_nguoc_count FROM orders WHERE danh_dau = 'Open' AND side = 'BUY' AND phan_biet = 'Nguoc'";
$sell_nguoc_query = "SELECT COUNT(*) as sell_nguoc_count FROM orders WHERE danh_dau = 'Open' AND side = 'SELL' AND phan_biet = 'Nguoc'";
// Thống kê lệnh Close
$close_count_query = "SELECT COUNT(*) as close_count FROM orders WHERE danh_dau = 'Close'";
$buy_close_query = "SELECT COUNT(*) as buy_close_count FROM orders WHERE danh_dau = 'Close' AND side = 'BUY'";
$sell_close_query = "SELECT COUNT(*) as sell_close_count FROM orders WHERE danh_dau = 'Close' AND side = 'SELL'";
// Thực thi truy vấn
$open_result = $mysqli->query($open_count_query);
$buy_chinh_result = $mysqli->query($buy_chinh_query);
$sell_chinh_result = $mysqli->query($sell_chinh_query);
$buy_nguoc_result = $mysqli->query($buy_nguoc_query);
$sell_nguoc_result = $mysqli->query($sell_nguoc_query);
$close_result = $mysqli->query($close_count_query);
$buy_close_result = $mysqli->query($buy_close_query);
$sell_close_result = $mysqli->query($sell_close_query);
// Kiểm tra lỗi truy vấn
if ($open_result === false || $buy_chinh_result === false || $sell_chinh_result === false ||
$buy_nguoc_result === false || $sell_nguoc_result === false || $close_result === false ||
$buy_close_result === false || $sell_close_result === false) {
error_log("Lỗi truy vấn thống kê: " . $mysqli->error);
echo "Lỗi truy vấn thống kê: " . htmlspecialchars($mysqli->error);
$mysqli->close();
exit;
}
// Lấy dữ liệu thống kê
$open_count = $open_result->fetch_assoc()['open_count'];
$buy_chinh_count = $buy_chinh_result->fetch_assoc()['buy_chinh_count'];
$sell_chinh_count = $sell_chinh_result->fetch_assoc()['sell_chinh_count'];
$buy_nguoc_count = $buy_nguoc_result->fetch_assoc()['buy_nguoc_count'];
$sell_nguoc_count = $sell_nguoc_result->fetch_assoc()['sell_nguoc_count'];
$close_count = $close_result->fetch_assoc()['close_count'];
$buy_close_count = $buy_close_result->fetch_assoc()['buy_close_count'];
$sell_close_count = $sell_close_result->fetch_assoc()['sell_close_count'];
// Giải phóng kết quả
$open_result->free();
$buy_chinh_result->free();
$sell_chinh_result->free();
$buy_nguoc_result->free();
$sell_nguoc_result->free();
$close_result->free();
$buy_close_result->free();
$sell_close_result->free();
// Lấy danh sách lệnh
$sql = "SELECT id, symbol, side, quantity, type, danh_dau, phan_biet, price, orderId, clientOrderId, avgPrice, origQty, updateTime FROM orders ORDER BY updateTime DESC";
$result = $mysqli->query($sql);
if ($result === false) {
error_log("Lỗi truy vấn danh sách lệnh: " . $mysqli->error);
echo "Lỗi truy vấn: " . htmlspecialchars($mysqli->error);
$mysqli->close();
exit;
}
?>
Danh sách lệnh
Danh sách lệnh
Tổng lệnh Open: |
BUY Chính: |
SELL Chính: |
BUY Ngược: |
SELL Ngược:
Tổng lệnh Close: |
BUY Close: |
SELL Close:
| ID |
Symbol |
Side |
Quantity |
Type |
Danh Dấu |
Phân Biệt |
Price |
Order ID |
Client Order ID |
Avg Price |
Orig Qty |
Update Time |
fetch_assoc()): ?>
|
|
|
|
|
|
|
|
|
|
|
|
|
free();
$mysqli->close();
?>