<%- include('partials/page-start', { pageTitle, activePage }) %> <% const num = (value) => Number(value || 0); %> <% const analytics = result.analytics || {}; %> <% const stats = analytics.stats || {}; %> <% const revenueRows = analytics.revenueTrend || []; %> <% const orderRows = analytics.orderTrend || []; %> <% const pct = (part, total) => total > 0 ? Math.round((num(part) / num(total)) * 100) : 0; %> <% const maxRevenue = Math.max(1, ...revenueRows.map((row) => num(row.total))); %> <% const revenue30 = revenueRows.reduce((sum, row) => sum + num(row.total), 0); %> <% const orders30 = orderRows.reduce((sum, row) => sum + num(row.total), 0); %> <% const gatewayOptions = analytics.gatewayBreakdown || []; %> <% const planOptions = analytics.planBreakdown || []; %> <% const activeFilterCount = ['q','status','gateway','plan','date_from','date_to'].filter((key) => filters[key]).length; %>
Financial operations

Transactions

Review money movement, resolve pending orders and inspect gateway records from one focused workspace.

Confirmed revenue<%= formatMoney(stats.confirmed_revenue || 0) %><%= num(stats.confirmed_orders).toLocaleString() %> successful transactions
30-day revenue<%= formatMoney(stats.revenue_30d || 0) %><%= num(stats.orders_30d).toLocaleString() %> transactions created
Needs review<%= formatMoney(stats.review_amount || 0) %><%= num(stats.review_orders).toLocaleString() %> pending or submitted
Confirmation rate<%= num(stats.confirm_rate).toLocaleString() %>%<%= formatMoney(stats.avg_confirmed_order || 0) %> average value
Last 30 days

Revenue activity

Daily confirmed revenue with created transaction activity.

<%= formatMoney(revenue30) %><%= orders30.toLocaleString() %> created
<% if (!revenue30 && !orders30) { %>
No transaction activity was recorded in this period.
<% } else { %> <% } %>
<% if ((analytics.statusBreakdown || []).length || planOptions.length || gatewayOptions.length) { %>
Transaction analyticsStatus, plan and gateway distributionExpand

Status pipeline

<% (analytics.statusBreakdown || []).forEach((row) => { %><%= row.label %><%= num(row.total).toLocaleString() %><% }) %>

Revenue by plan

<% planOptions.forEach((row) => { %><%= row.label %><%= formatMoney(row.revenue || 0) %><% }) %>

Gateway mix

<% gatewayOptions.forEach((row) => { %><%= row.label %><%= num(row.total).toLocaleString() %><% }) %>
<% } %>
Transaction ledger

All transactions

<%= result.total %> matching record(s)

<% if (activeFilterCount) { %><%= activeFilterCount %> active filter(s)<% } %>
Reset
<% if (!result.items.length) { %>
No transactions match these filters.
<% } else { %>
<% result.items.forEach((transaction) => { %> <% }) %>
TransactionUserPlanAmountGatewayStatusCreated
#<%= transaction.order_id || transaction.id %>Internal ID <%= transaction.id %> <% if (transaction.user_id) { %><%= transaction.user_name || transaction.user_email || ('User #' + transaction.user_id) %><%= transaction.user_email || ('User ID ' + transaction.user_id) %><% } else { %>Unknown userNo user ID<% } %> <%= transaction.plan_name || 'Unknown' %><%= transaction.billing_cycle || (transaction.duration_months ? `${transaction.duration_months} months` : '—') %> <%= formatMoney(transaction.payable_amount || transaction.amount_usd, transaction.currency || 'USD') %>Base <%= formatMoney(transaction.amount_usd || 0) %> <%= transaction.gateway || 'Unknown' %><%= transaction.oxapay_track_id || transaction.gateway_order_id || 'No track ID' %> <%= transaction.status %> <%= formatDate(transaction.created_at, false) %><%= formatDate(transaction.created_at) %> Inspect
<%- include('partials/pagination', { result }) %> <% } %>
<%- include('partials/page-end', { activePage }) %>