Taio
/
bot


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535
							<!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="row mb-3">
            <div class="col-12">
                <div class="d-flex justify-content-between align-items-center">
                    <h5 id="currentDate" class="mb-0"></h5>
                    <div>
                        <button class="btn btn-outline-primary me-2" onclick="loadPreviousDay()">
                            <i class="bi bi-arrow-left"></i> 查看前一天
                        </button>
                        <button class="btn btn-outline-primary" onclick="loadNextDay()" id="nextDayBtn">
                            查看后一天 <i class="bi bi-arrow-right"></i>
                        </button>
                    </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>USDT金额</th>
                            <th>笔数</th>
                        </tr>
                    </thead>
                    <tbody id="summaryTable">
                        <tr>
                            <td>应下发</td>
                            <td id="totalDepositCNY">¥0.00</td>
                            <td id="totalDeposit">0.00U</td>
                            <td id="totalDepositCount">0</td>
                        </tr>
                        <tr>
                            <td>已下发</td>
                            <td id="totalWithdrawCNY">¥0.00</td>
                            <td id="totalWithdraw">0.00U</td>
                            <td id="totalWithdrawCount">0</td>
                        </tr>
                        <tr>
                            <td>未下发</td>
                            <td id="balanceCNY">¥0.00</td>
                            <td id="balance">0.00U</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;
        let currentDate = new Date();

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

        // 格式化日期为 YYYY-MM-DD
        function formatDate(date) {
            const year = date.getFullYear();
            const month = String(date.getMonth() + 1).padStart(2, '0');
            const day = String(date.getDate()).padStart(2, '0');
            return `${year}-${month}-${day}`;
        }

        // 检查是否是今天
        function isToday(date) {
            const today = new Date();
            return date.getDate() === today.getDate() &&
                   date.getMonth() === today.getMonth() &&
                   date.getFullYear() === today.getFullYear();
        }

        // 更新当前日期显示和按钮状态
        function updateDateDisplay() {
            const dateStr = formatDate(currentDate);
            document.getElementById('currentDate').textContent = dateStr;
            
            // 如果是今天，禁用"查看后一天"按钮
            const nextDayBtn = document.getElementById('nextDayBtn');
            if (isToday(currentDate)) {
                nextDayBtn.disabled = true;
                nextDayBtn.classList.add('disabled');
            } else {
                nextDayBtn.disabled = false;
                nextDayBtn.classList.remove('disabled');
            }
        }

        // 加载前一天的账单
        function loadPreviousDay() {
            currentDate.setDate(currentDate.getDate() - 1);
            updateDateDisplay();
            loadTransactions(1);
        }

        // 加载后一天的账单
        function loadNextDay() {
            const nextDate = new Date(currentDate);
            nextDate.setDate(nextDate.getDate() + 1);
            
            // 如果后一天超过今天，则不执行
            if (nextDate > new Date()) {
                return;
            }
            
            currentDate = nextDate;
            updateDateDisplay();
            loadTransactions(1);
        }

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

                const startDate = formatDate(currentDate);
                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 dayTransactions = data.transactions.filter(transaction => {
                    const transactionDate = new Date(transaction.time).toISOString().split('T')[0];
                    return transactionDate === startDate;
                });
                
                console.log('当日交易记录:', dayTransactions);
                
                // 计算当日收入
                const dayIncome = dayTransactions.reduce((sum, transaction) => {
                    if (transaction.type === 'deposit') {
                        return sum + parseFloat(transaction.amount);
                    }
                    return sum;
                }, 0);

                // 更新统计数据
                const statistics = {
                    todayIncome: dayIncome,
                    todayOrders: dayTransactions.length
                };
                
                updateTransactionsList(dayTransactions);
                updatePagination(dayTransactions.length, page);
                updateStatistics(statistics);
                
                // 使用最新一条记录的数据更新账单总结
                if (dayTransactions.length > 0) {
                    const latestRecord = dayTransactions[0];
                    console.log('最新记录:', latestRecord);
                    
                    const summary = {
                        totalDeposit: latestRecord.totalDeposit,
                        totalWithdraw: latestRecord.totalWithdrawal,
                        totalUDeposit: latestRecord.totalUDeposit,
                        totalUWithdrawal: latestRecord.totalUWithdrawal,
                        depositCount: dayTransactions.filter(t => t.type === 'deposit').length,
                        withdrawCount: dayTransactions.filter(t => t.type === 'withdrawal').length
                    };
                    
                    console.log('账单总结数据:', summary);
                    updateSummary(summary);
                } else {
                    console.log('没有当日交易记录');
                    updateSummary({
                        totalDeposit: 0,
                        totalWithdraw: 0,
                        totalUDeposit: 0,
                        totalUWithdrawal: 0,
                        depositCount: 0,
                        withdrawCount: 0
                    });
                }
            } 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)}U` : '0.00U';
            };

            const formatCNY = (amount) => {
                return amount ? `¥${parseFloat(amount).toFixed(2)}` : '¥0.00';
            };
            
            // 应下发 = totalUDeposit
            const shouldWithdraw = parseFloat(summary.totalUDeposit) || 0;
            const shouldWithdrawCNY = parseFloat(summary.totalDeposit) || 0;
            
            // 已下发 = totalUWithdrawal
            const alreadyWithdraw = parseFloat(summary.totalUWithdrawal) || 0;
            const alreadyWithdrawCNY = parseFloat(summary.totalWithdraw) || 0;
            
            // 未下发 = totalUDeposit - totalUWithdrawal
            const remainingWithdraw = shouldWithdraw - alreadyWithdraw;
            const remainingWithdrawCNY = shouldWithdrawCNY - alreadyWithdrawCNY;
            
            document.getElementById('totalDepositCNY').textContent = formatCNY(shouldWithdrawCNY);
            document.getElementById('totalDeposit').textContent = formatAmount(shouldWithdraw);
            document.getElementById('totalDepositCount').textContent = summary.depositCount || 0;
            document.getElementById('totalWithdrawCNY').textContent = formatCNY(alreadyWithdrawCNY);
            document.getElementById('totalWithdraw').textContent = formatAmount(alreadyWithdraw);
            document.getElementById('totalWithdrawCount').textContent = summary.withdrawCount || 0;
            document.getElementById('balanceCNY').textContent = formatCNY(remainingWithdrawCNY);
            document.getElementById('balance').textContent = formatAmount(remainingWithdraw);
        }

        // 页面加载时初始化
        document.addEventListener('DOMContentLoaded', function() {
            updateDateDisplay();
            loadTransactions();
        });
    </script>
</body>
</html>