Taio
/
bot


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438
							<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>机器人统计账单</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.7.2/font/bootstrap-icons.css" rel="stylesheet">
    <style>
        body {
            background-color: #f5f5f5;
            font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;
        }
        .container {
            max-width: 1200px;
            margin: 20px auto;
            padding: 20px;
        }
        .card {
            background: #fff;
            border-radius: 8px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
            margin-bottom: 20px;
        }
        .card-header {
            background: #fff;
            border-bottom: 1px solid #eee;
            padding: 15px 20px;
            font-weight: 600;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        .stat-card {
            background: linear-gradient(45deg, #2196F3, #1976D2);
            color: white;
            border-radius: 8px;
            padding: 20px;
            margin-bottom: 20px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
        }
        .stat-card .title {
            font-size: 14px;
            opacity: 0.8;
        }
        .stat-card .value {
            font-size: 24px;
            font-weight: bold;
            margin: 10px 0;
        }
        .table {
            margin-bottom: 0;
        }
        .table th {
            background: #f8f9fa;
            font-weight: 600;
        }
        .badge {
            padding: 5px 10px;
            border-radius: 4px;
        }
        .badge-success {
            background-color: #28a745;
        }
        .badge-danger {
            background-color: #dc3545;
        }
        .pagination {
            margin: 20px 0;
        }
        .pagination .page-link {
            color: #2196F3;
        }
        .pagination .page-item.active .page-link {
            background-color: #2196F3;
            border-color: #2196F3;
        }
        .summary-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 20px;
        }
        .summary-table th,
        .summary-table td {
            padding: 12px;
            text-align: left;
            border-bottom: 1px solid #eee;
        }
        .summary-table th {
            background-color: #f8f9fa;
            font-weight: 600;
        }
        .summary-table tr:last-child td {
            border-bottom: none;
            font-weight: bold;
        }
        .nav-tabs {
            border-bottom: 1px solid #dee2e6;
            margin-bottom: 20px;
        }
        .nav-tabs .nav-link {
            border: none;
            color: #6c757d;
            padding: 10px 20px;
            font-weight: 500;
        }
        .nav-tabs .nav-link.active {
            color: #2196F3;
            border-bottom: 2px solid #2196F3;
            background: none;
        }
        .tab-content {
            padding: 20px 0;
        }
    </style>
</head>
<body>
    <div class="container">
        <div class="row">
            <div class="col-md-6">
                <div class="stat-card">
                    <div class="title">今日收入</div>
                    <div class="value" id="todayIncome">¥0.00</div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="stat-card">
                    <div class="title">今日订单数</div>
                    <div class="value" id="todayOrders">0</div>
                </div>
            </div>
        </div>

        <div class="card">
            <div class="card-header">
                <span>交易记录</span>
                <ul class="nav nav-tabs card-header-tabs">
                    <li class="nav-item">
                        <a class="nav-link active" data-bs-toggle="tab" href="#deposits">入款记录</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" data-bs-toggle="tab" href="#withdrawals">下发记录</a>
                    </li>
                </ul>
            </div>
            <div class="card-body">
                <div class="tab-content">
                    <div class="tab-pane fade show active" id="deposits">
                        <div class="table-responsive">
                            <table class="table table-hover">
                                <thead>
                                    <tr>
                                        <th>交易ID</th>
                                        <th>时间</th>
                                        <th>金额</th>
                                        <th>费率</th>
                                        <th>汇率</th>
                                        <th>操作人</th>
                                        <th>回复人</th>
                                    </tr>
                                </thead>
                                <tbody id="depositsList">
                                </tbody>
                            </table>
                        </div>
                        <nav>
                            <ul class="pagination justify-content-center" id="depositsPagination">
                            </ul>
                        </nav>
                    </div>
                    <div class="tab-pane fade" id="withdrawals">
                        <div class="table-responsive">
                            <table class="table table-hover">
                                <thead>
                                    <tr>
                                        <th>交易ID</th>
                                        <th>时间</th>
                                        <th>金额</th>
                                        <th>费率</th>
                                        <th>汇率</th>
                                        <th>操作人</th>
                                        <th>回复人</th>
                                    </tr>
                                </thead>
                                <tbody id="withdrawalsList">
                                </tbody>
                            </table>
                        </div>
                        <nav>
                            <ul class="pagination justify-content-center" id="withdrawalsPagination">
                            </ul>
                        </nav>
                    </div>
                </div>
            </div>
        </div>

        <div class="card">
            <div class="card-header">
                账单总结
            </div>
            <div class="card-body">
                <table class="summary-table">
                    <thead>
                        <tr>
                            <th>项目</th>
                            <th>金额</th>
                            <th>笔数</th>
                        </tr>
                    </thead>
                    <tbody id="summaryTable">
                        <tr>
                            <td>总入款</td>
                            <td id="totalDeposit">¥0.00</td>
                            <td id="totalDepositCount">0</td>
                        </tr>
                        <tr>
                            <td>入款费率</td>
                            <td id="depositFeeRate">0%</td>
                            <td>-</td>
                        </tr>
                        <tr>
                            <td>入款汇率</td>
                            <td id="depositExchangeRate">1.0000</td>
                            <td>-</td>
                        </tr>
                        <tr>
                            <td>总下发</td>
                            <td id="totalWithdraw">¥0.00</td>
                            <td id="totalWithdrawCount">0</td>
                        </tr>
                        <tr>
                            <td>下发费率</td>
                            <td id="withdrawFeeRate">0%</td>
                            <td>-</td>
                        </tr>
                        <tr>
                            <td>下发汇率</td>
                            <td id="withdrawExchangeRate">1.0000</td>
                            <td>-</td>
                        </tr>
                        <tr>
                            <td>余额</td>
                            <td id="balance">¥0.00</td>
                            <td>-</td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
    <script>
        let currentPage = 1;
        const pageSize = 10;

        // 获取URL参数
        function getUrlParams() {
            const params = new URLSearchParams(window.location.search);
            return {
                groupId: params.get('groupId')
            };
        }

        // 加载交易记录
        async function loadTransactions(page = 1) {
            try {
                const { groupId } = getUrlParams();
                if (!groupId) {
                    alert('缺少群组ID参数');
                    return;
                }

                // 获取今天的日期（考虑时区）
                const today = new Date();
                const year = today.getFullYear();
                const month = String(today.getMonth() + 1).padStart(2, '0');
                const day = String(today.getDate()).padStart(2, '0');
                const startDate = `${year}-${month}-${day}`;
                const endDate = startDate;

                console.log('日期范围:', { startDate, endDate });

                const url = `/api/public/transactions?page=${page}&limit=${pageSize}&groupId=${groupId}&startDate=${startDate}&endDate=${endDate}`;
                console.log('请求URL:', url);

                const response = await fetch(url);
                console.log('API响应:', response);
                
                if (!response.ok) {
                    const errorData = await response.json();
                    throw new Error(errorData.message || '获取数据失败');
                }

                const data = await response.json();
                console.log('获取到的数据:', data);
                
                // 过滤掉非今天的记录
                const todayTransactions = data.transactions.filter(transaction => {
                    const transactionDate = new Date(transaction.time).toISOString().split('T')[0];
                    return transactionDate === startDate;
                });
                
                // 计算今日收入
                const todayIncome = todayTransactions.reduce((sum, transaction) => {
                    if (transaction.type === 'deposit') {
                        return sum + parseFloat(transaction.amount);
                    }
                    return sum;
                }, 0);

                // 更新统计数据
                const statistics = {
                    todayIncome: todayIncome,
                    todayOrders: todayTransactions.length
                };
                
                updateTransactionsList(todayTransactions);
                updatePagination(todayTransactions.length, page);
                updateStatistics(statistics);
                updateSummary(data.summary);
            } catch (error) {
                console.error('加载交易记录失败:', error);
                alert(error.message || '加载数据失败，请稍后重试');
            }
        }

        // 更新交易记录列表
        function updateTransactionsList(transactions) {
            const depositsList = document.getElementById('depositsList');
            const withdrawalsList = document.getElementById('withdrawalsList');
            
            if (!transactions || transactions.length === 0) {
                depositsList.innerHTML = '<tr><td colspan="7" class="text-center">暂无入款记录</td></tr>';
                withdrawalsList.innerHTML = '<tr><td colspan="7" class="text-center">暂无下发记录</td></tr>';
                return;
            }
            
            const deposits = transactions.filter(t => t.type === 'deposit');
            const withdrawals = transactions.filter(t => t.type === 'withdrawal');
            
            depositsList.innerHTML = deposits.length ? deposits.map(transaction => `
                <tr>
                    <td>${transaction.id}</td>
                    <td>${new Date(transaction.time).toLocaleString('zh-CN')}</td>
                    <td class="text-success">¥${parseFloat(transaction.amount).toFixed(2)}</td>
                    <td>${transaction.fee_rate ? transaction.fee_rate + '%' : '-'}</td>
                    <td>${transaction.exchange_rate ? Number(transaction.exchange_rate).toFixed(4) : '-'}</td>
                    <td>${transaction.operator_id || '-'}</td>
                    <td>${transaction.replier_id || '-'}</td>
                </tr>
            `).join('') : '<tr><td colspan="7" class="text-center">暂无入款记录</td></tr>';
            
            withdrawalsList.innerHTML = withdrawals.length ? withdrawals.map(transaction => `
                <tr>
                    <td>${transaction.id}</td>
                    <td>${new Date(transaction.time).toLocaleString('zh-CN')}</td>
                    <td class="text-danger">¥${parseFloat(transaction.amount).toFixed(2)}</td>
                    <td>${transaction.fee_rate ? transaction.fee_rate + '%' : '-'}</td>
                    <td>${transaction.exchange_rate ? Number(transaction.exchange_rate).toFixed(4) : '-'}</td>
                    <td>${transaction.operator_id || '-'}</td>
                    <td>${transaction.replier_id || '-'}</td>
                </tr>
            `).join('') : '<tr><td colspan="7" class="text-center">暂无下发记录</td></tr>';
        }

        // 更新分页
        function updatePagination(total, currentPage) {
            const totalPages = Math.ceil(total / pageSize);
            const pagination = document.getElementById('depositsPagination');
            const withdrawalsPagination = document.getElementById('withdrawalsPagination');
            
            let html = '';
            
            // 上一页
            html += `
                <li class="page-item ${currentPage === 1 ? 'disabled' : ''}">
                    <a class="page-link" href="#" onclick="event.preventDefault(); loadTransactions(${currentPage - 1})">上一页</a>
                </li>
            `;
            
            // 页码
            for (let i = 1; i <= totalPages; i++) {
                html += `
                    <li class="page-item ${i === currentPage ? 'active' : ''}">
                        <a class="page-link" href="#" onclick="event.preventDefault(); loadTransactions(${i})">${i}</a>
                    </li>
                `;
            }
            
            // 下一页
            html += `
                <li class="page-item ${currentPage === totalPages ? 'disabled' : ''}">
                    <a class="page-link" href="#" onclick="event.preventDefault(); loadTransactions(${currentPage + 1})">下一页</a>
                </li>
            `;
            
            pagination.innerHTML = html;
            withdrawalsPagination.innerHTML = html;
        }

        // 更新统计数据
        function updateStatistics(statistics) {
            if (!statistics) return;
            
            const formatAmount = (amount) => {
                return amount ? `¥${parseFloat(amount).toFixed(2)}` : '¥0.00';
            };
            
            document.getElementById('todayIncome').textContent = formatAmount(statistics.todayIncome);
            document.getElementById('todayOrders').textContent = statistics.todayOrders || 0;
        }

        // 更新总结表格
        function updateSummary(summary) {
            if (!summary) return;
            
            const formatAmount = (amount) => {
                return amount ? `¥${parseFloat(amount).toFixed(2)}` : '¥0.00';
            };
            
            document.getElementById('totalDeposit').textContent = formatAmount(summary.totalDeposit);
            document.getElementById('totalDepositCount').textContent = summary.depositCount || 0;
            document.getElementById('depositFeeRate').textContent = `${summary.depositFeeRate || 0}%`;
            document.getElementById('depositExchangeRate').textContent = `${summary.depositExchangeRate || 0}`;
            document.getElementById('totalWithdraw').textContent = formatAmount(summary.totalWithdraw);
            document.getElementById('totalWithdrawCount').textContent = summary.withdrawCount || 0;
            document.getElementById('withdrawFeeRate').textContent = `${summary.withdrawFeeRate || 0}%`;
            document.getElementById('withdrawExchangeRate').textContent = `${summary.withdrawExchangeRate || 0}`;
            document.getElementById('balance').textContent = formatAmount(summary.balance);
        }

        // 页面加载时加载数据
        loadTransactions();
    </script>
</body>
</html>