Files
KittyRec2018-Leak/templates/admin/analytics_view.html

1495 lines
85 KiB
HTML

{% extends 'admin/custom_base.html' %}
{% block body %}
<style>
/* ── Layout ── */
.an-wrap{padding:12px 16px;font-size:.82rem}
.an-header{display:flex;align-items:center;justify-content:space-between;flex-wrap:wrap;gap:8px;margin-bottom:12px}
.an-title{font-size:1.15rem;font-weight:800;color:var(--kr-text)}
.an-meta{font-size:.68rem;color:var(--kr-text-muted)}
/* ── Range toolbar ── */
.an-toolbar{display:flex;align-items:center;gap:6px;flex-wrap:wrap;margin-bottom:12px;background:var(--kr-surface);border:1px solid var(--kr-border);border-radius:8px;padding:7px 10px}
.an-toolbar label{font-size:.65rem;font-weight:700;letter-spacing:.7px;text-transform:uppercase;color:var(--kr-text-muted);margin-right:2px}
.rng-btn{background:transparent;border:1px solid var(--kr-border);border-radius:5px;color:var(--kr-text-muted);padding:3px 10px;font-size:.72rem;cursor:pointer;transition:all .12s}
.rng-btn:hover{border-color:var(--kr-purple-l);color:var(--kr-purple-l)}
.rng-btn.active{background:var(--kr-purple);border-color:var(--kr-purple);color:#fff;font-weight:700}
.an-date-in{background:var(--kr-surface2);border:1px solid var(--kr-border);color:var(--kr-text);border-radius:5px;padding:3px 7px;font-size:.72rem;outline:none}
.an-date-in:focus{border-color:var(--kr-purple)}
.an-toolbar-sep{width:1px;height:20px;background:var(--kr-border);margin:0 2px}
.an-export-btn{background:transparent;border:1px solid var(--kr-border);border-radius:5px;color:var(--kr-text-muted);padding:3px 10px;font-size:.72rem;cursor:pointer;transition:all .12s;display:flex;align-items:center;gap:4px}
.an-export-btn:hover{border-color:var(--kr-info);color:var(--kr-info)}
.an-share-btn{background:transparent;border:1px solid var(--kr-border);border-radius:5px;color:var(--kr-text-muted);padding:3px 10px;font-size:.72rem;cursor:pointer;transition:all .12s}
.an-share-btn:hover{border-color:var(--kr-success);color:var(--kr-success)}
/* ── Tabs ── */
.an-tabbar{display:flex;gap:2px;margin-bottom:12px;border-bottom:1px solid var(--kr-border);padding-bottom:0}
.an-tab{background:none;border:none;color:var(--kr-text-muted);padding:7px 14px;font-size:.79rem;font-weight:600;cursor:pointer;border-bottom:2px solid transparent;margin-bottom:-1px;letter-spacing:.3px;transition:color .1s}
.an-tab:hover{color:var(--kr-text)}
.an-tab.active{color:var(--kr-purple-l);border-bottom-color:var(--kr-purple-l)}
/* ── KPI cards ── */
.kpi-row{display:flex;gap:7px;flex-wrap:wrap;margin-bottom:10px}
.kpi{background:var(--kr-surface);border:1px solid var(--kr-border);border-radius:8px;padding:10px 13px;min-width:110px;flex:1;position:relative;overflow:hidden}
.kpi .kv{font-size:1.55rem;font-weight:800;line-height:1;color:var(--kr-text)}
.kpi .kl{font-size:.62rem;font-weight:700;letter-spacing:.8px;text-transform:uppercase;color:var(--kr-text-muted);margin-top:3px}
.kpi .ks{font-size:.64rem;color:var(--kr-text-muted);margin-top:5px;line-height:1.3}
.kpi .kt{font-size:.7rem;font-weight:700;margin-top:4px}
.kpi .kt.up{color:var(--kr-success)}.kpi .kt.dn{color:var(--kr-danger)}.kpi .kt.nc{color:var(--kr-text-muted)}
.kpi::after{content:'';position:absolute;bottom:0;left:0;right:0;height:3px}
.kpi.purple::after{background:var(--kr-purple)}.kpi.green::after{background:var(--kr-success)}
.kpi.teal::after{background:var(--kr-info)}.kpi.yellow::after{background:var(--kr-warning)}
.kpi.red::after{background:var(--kr-danger)}.kpi.pink::after{background:var(--kr-accent)}
.kpi.purple .kv{color:var(--kr-purple-l)}.kpi.green .kv{color:var(--kr-success)}
.kpi.teal .kv{color:var(--kr-info)}.kpi.yellow .kv{color:var(--kr-warning)}
.kpi.red .kv{color:var(--kr-danger)}.kpi.pink .kv{color:var(--kr-accent)}
/* ── Chart containers ── */
.chart-block{background:var(--kr-surface);border:1px solid var(--kr-border);border-radius:8px;padding:12px 14px;margin-bottom:9px;position:relative}
.chart-block .ch-header{display:flex;align-items:flex-start;justify-content:space-between;margin-bottom:8px;gap:8px}
.chart-block .ch-title{font-size:.72rem;font-weight:700;letter-spacing:.7px;text-transform:uppercase;color:var(--kr-text)}
.chart-block .ch-sub{font-size:.64rem;color:var(--kr-text-muted);margin-top:2px}
.chart-block .ch-actions{display:flex;gap:4px;flex-shrink:0}
.ch-btn{background:transparent;border:1px solid var(--kr-border);border-radius:4px;color:var(--kr-text-muted);padding:2px 8px;font-size:.65rem;cursor:pointer;transition:all .1s}
.ch-btn:hover{border-color:var(--kr-purple-l);color:var(--kr-purple-l)}
.chart-canvas-wrap{position:relative}
.anomaly-badge{display:inline-flex;align-items:center;gap:3px;background:rgba(239,68,68,.12);border:1px solid rgba(239,68,68,.3);color:var(--kr-danger);border-radius:4px;padding:2px 7px;font-size:.63rem;font-weight:700;margin-left:6px}
/* ── Tables ── */
.an-grid-2{display:grid;grid-template-columns:1fr 1fr;gap:9px;margin-bottom:9px}
.an-grid-3{display:grid;grid-template-columns:1fr 1fr 1fr;gap:9px;margin-bottom:9px}
.an-section{background:var(--kr-surface);border:1px solid var(--kr-border);border-radius:8px;margin-bottom:9px;overflow:hidden}
.an-sh{display:flex;align-items:center;justify-content:space-between;padding:7px 11px;border-bottom:1px solid var(--kr-border);font-size:.65rem;font-weight:700;letter-spacing:.8px;text-transform:uppercase;color:var(--kr-text-muted)}
.an-sh .ct{font-weight:400;text-transform:none;letter-spacing:0;color:var(--kr-text-muted)}
.an-sh .sh-action{background:transparent;border:1px solid var(--kr-border);border-radius:4px;color:var(--kr-text-muted);padding:1px 7px;font-size:.62rem;cursor:pointer;font-weight:400;letter-spacing:0;text-transform:none;transition:all .1s}
.an-sh .sh-action:hover{border-color:var(--kr-info);color:var(--kr-info)}
.an-tw{overflow-x:auto}
table.at{width:100%;border-collapse:collapse;font-size:.78rem}
table.at thead th{background:var(--kr-surface2);color:var(--kr-purple-l);padding:5px 9px;text-align:left;font-size:.64rem;font-weight:700;letter-spacing:.7px;text-transform:uppercase;border-bottom:1px solid var(--kr-border);white-space:nowrap;cursor:pointer;user-select:none}
table.at thead th:hover{color:var(--kr-text)}
table.at thead th.sorted-asc::after{content:' ↑'}
table.at thead th.sorted-desc::after{content:' ↓'}
table.at tbody td{padding:5px 9px;border-bottom:1px solid rgba(155,89,182,.07);vertical-align:middle}
table.at tbody tr:last-child td{border-bottom:none}
table.at tbody tr:hover{background:rgba(155,89,182,.05)}
.tr{text-align:right}.tc{text-align:center}
.mono{font-family:'Cascadia Code','Fira Code','SF Mono',monospace;font-size:.73rem}
.dim{color:var(--kr-text-muted)}
.fhi{color:var(--kr-success)}.fmd{color:#8bc34a}.flo{color:var(--kr-warning)}.fbd{color:var(--kr-danger)}
.phi{color:var(--kr-success)}.pmd{color:#8bc34a}.plo{color:var(--kr-warning)}.pbd{color:var(--kr-danger)}
/* ── Filter inputs ── */
.an-filter{width:100%;background:var(--kr-bg);border:1px solid var(--kr-border);border-radius:5px;color:var(--kr-text);padding:5px 9px;font-size:.78rem;outline:none;margin-bottom:7px}
.an-filter:focus{border-color:var(--kr-purple)}
/* ── Bar rows ── */
.fi{display:flex;align-items:center;gap:8px;margin-bottom:5px;font-size:.79rem}
.fl{width:86px;color:var(--kr-text-muted);font-size:.68rem;text-transform:uppercase;letter-spacing:.6px}
.fb{flex:1;height:16px;background:rgba(155,89,182,.1);border-radius:3px;overflow:hidden}
.fbar{height:100%;border-radius:3px}
.fv{width:38px;text-align:right;font-weight:700;font-size:.8rem}
/* ── Anomaly indicator ── */
.warn-row td{background:rgba(239,68,68,.06)!important}
.warn-row td:first-child{border-left:2px solid var(--kr-danger)}
/* ── Tooltip copy ── */
.copy-toast{position:fixed;bottom:20px;right:20px;background:var(--kr-success);color:#fff;padding:7px 14px;border-radius:6px;font-size:.78rem;font-weight:700;z-index:9999;opacity:0;transition:opacity .2s;pointer-events:none}
.copy-toast.show{opacity:1}
@media(max-width:768px){.an-grid-2,.an-grid-3{grid-template-columns:1fr}.an-toolbar{flex-direction:column;align-items:flex-start}}
</style>
{# ── Inject all time-series data for JS ── #}
<script>
var AN = {
regByDay: [{% for r in growth.reg_by_day %}{"d":"{{r.d}}","c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}],
loginByDay: [{% for r in growth.daily_logins %}{"d":"{{r.d}}","c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}],
visitByDay: [{% for r in growth.room_visits_by_day %}{"d":"{{r.d}}","c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}],
chatByDay: [{% for r in growth.chat_by_day %}{"d":"{{r.d}}","c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}],
photoByDay: [{% for r in growth.photos_by_day %}{"d":"{{r.d}}","c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}],
giftsByDay: [{% for r in growth.gifts_by_day %}{"d":"{{r.d}}","c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}],
unlockedByDay:[{% for r in growth.unlocked_by_day %}{"d":"{{r.d}}","c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}],
adminByDay: [{% for r in growth.admin_by_day %}{"d":"{{r.d}}","c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}],
bansByDay: [{% for r in growth.bans_by_day %}{"d":"{{r.d}}","c":{{r.c}},"action":"{{r.action}}"}{% if not loop.last %},{% endif %}{% endfor %}],
dailySpend: [{% for d,c in daily_spend.items()|sort %}{"d":"{{d}}","c":{{c}}}{% if not loop.last %},{% endif %}{% endfor %}],
eventsByDay: [{% for d,c in events_by_day.items()|sort %}{"d":"{{d}}","c":{{c}}}{% if not loop.last %},{% endif %}{% endfor %}],
sessionsByDay:[{% for d,c in sessions_by_day.items()|sort %}{"d":"{{d}}","c":{{c}}}{% if not loop.last %},{% endif %}{% endfor %}],
eventsByHour: [{% for h in range(24) %}{"h":{{h}},"c":{{events_by_hour.get('%02d'%h,0)}}}{% if not loop.last %},{% endif %}{% endfor %}],
countHistory: [{% for h in count_history %}{"t":"{{h.recorded_at}}","online":{{h.online}},"sessions":{{h.sessions}}}{% if not loop.last %},{% endif %}{% endfor %}],
totals: {
players:{{growth.totals.players}}, active:{{growth.totals.active}},
banned:{{growth.totals.banned}}, devs:{{growth.totals.devs}},
total_xp:{{growth.totals.total_xp}}, total_tokens:{{growth.totals.total_tokens}},
total_photos:{{growth.totals.total_photos}}, total_chat:{{growth.totals.total_chat}},
total_friends:{{growth.totals.total_friends}}, total_unlocked:{{growth.totals.total_unlocked}},
total_gifts:{{growth.totals.total_gifts}}, total_logins:{{growth.totals.total_logins}},
avg_level:{{growth.totals.avg_level}}, max_level:{{growth.totals.max_level}},
total_visits:{{growth.totals.total_visits}}, total_rooms:{{growth.totals.total_rooms}},
consumables_held:{{growth.totals.consumables_held}}, total_bans:{{growth.totals.total_bans}},
total_admin_acts:{{growth.totals.total_admin_acts}}, gifts_opened:{{growth.totals.gifts_opened}}
}
};
var AN_PURCHASES = [{% for p in purchases %}{"user_id":"{{p.user_id}}","item_name":{{p.item_name|tojson}},"cost":{{p.cost|int}},"item_type":{{p.item_type|tojson}},"storefront":{{p.storefront|tojson}},"created_at":"{{(p.created_at or '')[:10]}}"}{% if not loop.last %},{% endif %}{% endfor %}];
var RARITY_DIST = [{% for r in growth.gift_rarity %}{"r":{{r.gift_rarity}},"c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}];
var LEVEL_DIST = [{% for r in growth.level_dist %}{"level":{{r.level}},"c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}];
var PLATFORM_BRK = [{% for r in growth.platform_breakdown %}{"platform":{{(r.platform or 'Unknown')|tojson}},"c":{{r.c}}}{% if not loop.last %},{% endif %}{% endfor %}];
var TYPE_SPEND = {{type_spend|tojson}};
var SF_COUNTS = {{storefront_counts|tojson}};
var ACTIVITY_SUM = {{activity_summary|tojson}};
var PHOTON_SUM = {{photon_summary|tojson}};
</script>
<div class="an-wrap">
{# ── Page header ── #}
<div class="an-header">
<div>
<div class="an-title">Analytics</div>
<div class="an-meta">{{ stats.total|int }} events &nbsp;·&nbsp; {{ activity_rows|length }} activity sessions &nbsp;·&nbsp; {{ growth.totals.players }} total players</div>
</div>
<div style="display:flex;gap:6px">
<button class="an-share-btn" onclick="shareLink()">🔗 Share View</button>
</div>
</div>
{# ── Range toolbar ── #}
<div class="an-toolbar">
<label>Range</label>
<button class="rng-btn" onclick="setRange('7d',this)">7D</button>
<button class="rng-btn" onclick="setRange('14d',this)">14D</button>
<button class="rng-btn" onclick="setRange('30d',this)">30D</button>
<button class="rng-btn" onclick="setRange('90d',this)">90D</button>
<button class="rng-btn active" onclick="setRange('all',this)">All</button>
<div class="an-toolbar-sep"></div>
<label>From</label>
<input type="date" class="an-date-in" id="range-from" onchange="setCustomRange()">
<label>To</label>
<input type="date" class="an-date-in" id="range-to" onchange="setCustomRange()">
<div class="an-toolbar-sep"></div>
<button class="an-export-btn" onclick="exportCSV()">⬇ CSV</button>
<button class="an-export-btn" id="png-btn" onclick="exportPNG()">⬇ PNG</button>
<span id="range-label" style="font-size:.65rem;color:var(--kr-text-muted);margin-left:4px"></span>
</div>
{# ── Tabs ── #}
<div class="an-tabbar">
<button class="an-tab active" onclick="showTab('growth',this)" id="tab-btn-growth">Growth</button>
<button class="an-tab" onclick="showTab('overview',this)" id="tab-btn-overview">Overview</button>
<button class="an-tab" onclick="showTab('performance',this)" id="tab-btn-performance">Performance</button>
<button class="an-tab" onclick="showTab('economy',this)" id="tab-btn-economy">Economy</button>
<button class="an-tab" onclick="showTab('social',this)" id="tab-btn-social">Social &amp; Stability</button>
<button class="an-tab" onclick="showTab('raw',this)" id="tab-btn-raw">Raw Events</button>
</div>
{# ════════════════════════════════════ GROWTH ════════════════════════════════════ #}
<div id="tab-growth" class="an-panel">
{# KPI row 1 with trend indicators #}
<div class="kpi-row" id="kpi-growth-row1">
<div class="kpi green"><div class="kv">{{ growth.totals.players }}</div><div class="kl">Total Players</div><div class="ks">All registered accounts</div><div class="kt nc" id="kpi-t-players">—</div></div>
<div class="kpi teal"><div class="kv">{{ growth.totals.active }}</div><div class="kl">Active Players</div><div class="ks">Not banned</div></div>
<div class="kpi red"><div class="kv">{{ growth.totals.banned }}</div><div class="kl">Banned</div><div class="ks">Currently banned</div></div>
<div class="kpi yellow"><div class="kv">{{ growth.totals.devs }}</div><div class="kl">Devs</div></div>
<div class="kpi purple"><div class="kv">{{ "{:,}".format(growth.totals.total_xp) }}</div><div class="kl">XP in Circulation</div><div class="ks">Earned across all players</div></div>
<div class="kpi yellow"><div class="kv">{{ "{:,}".format(growth.totals.total_tokens) }}</div><div class="kl">Tokens in Circ.</div><div class="ks">Unspent balance total</div></div>
<div class="kpi teal"><div class="kv">{{ growth.totals.total_photos }}</div><div class="kl">Photos Taken</div><div class="kt nc" id="kpi-t-photos">—</div></div>
<div class="kpi pink"><div class="kv">{{ growth.totals.total_chat }}</div><div class="kl">Chat Messages</div><div class="kt nc" id="kpi-t-chat">—</div></div>
</div>
<div class="kpi-row" id="kpi-growth-row2">
<div class="kpi green"><div class="kv">{{ growth.totals.total_friends }}</div><div class="kl">Friendships</div></div>
<div class="kpi purple"><div class="kv">{{ "{:,}".format(growth.totals.total_unlocked) }}</div><div class="kl">Items Unlocked</div><div class="kt nc" id="kpi-t-unlocked">—</div></div>
<div class="kpi teal"><div class="kv">{{ growth.totals.total_gifts }}</div><div class="kl">Gifts Distributed</div><div class="kt nc" id="kpi-t-gifts">—</div></div>
<div class="kpi yellow"><div class="kv">{{ growth.totals.total_logins }}</div><div class="kl">Total Logins</div><div class="kt nc" id="kpi-t-logins">—</div></div>
<div class="kpi teal"><div class="kv">{{ growth.totals.avg_level }}</div><div class="kl">Avg Level</div></div>
<div class="kpi purple"><div class="kv">{{ growth.totals.max_level }}</div><div class="kl">Max Level</div></div>
<div class="kpi green"><div class="kv">{{ growth.totals.total_visits }}</div><div class="kl">Room Visits</div><div class="kt nc" id="kpi-t-visits">—</div></div>
<div class="kpi yellow"><div class="kv">{{ growth.totals.total_rooms }}</div><div class="kl">Custom Rooms</div></div>
<div class="kpi pink"><div class="kv">{{ growth.totals.consumables_held }}</div><div class="kl">Consumables</div></div>
<div class="kpi red"><div class="kv">{{ growth.totals.total_bans }}</div><div class="kl">Total Bans</div></div>
<div class="kpi teal"><div class="kv">{{ growth.totals.total_admin_acts }}</div><div class="kl">Admin Actions</div></div>
<div class="kpi green"><div class="kv">{{ growth.totals.gifts_opened }}</div><div class="kl">Gifts Opened</div></div>
</div>
{# Cumulative player growth — Line #}
<div class="chart-block">
<div class="ch-header">
<div><div class="ch-title">Cumulative Player Registrations</div><div class="ch-sub">Total accounts over time — shows overall growth trajectory</div></div>
<div class="ch-actions">
<button class="ch-btn" onclick="downloadChart('chart-cumreg','cumulative_registrations')">PNG</button>
</div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-cumreg" height="80"></canvas></div>
</div>
{# Multi-series daily activity — Line #}
<div class="chart-block">
<div class="ch-header">
<div>
<div class="ch-title">Daily Activity — All Channels <span id="anomaly-activity" class="anomaly-badge" style="display:none">⚠ Anomaly detected</span></div>
<div class="ch-sub">Logins, room visits, photos, and chat messages per day — normalized to their own peak</div>
</div>
<div class="ch-actions">
<button class="ch-btn" onclick="toggleSeries('chart-activity',0)">Logins</button>
<button class="ch-btn" onclick="toggleSeries('chart-activity',1)">Visits</button>
<button class="ch-btn" onclick="toggleSeries('chart-activity',2)">Photos</button>
<button class="ch-btn" onclick="toggleSeries('chart-activity',3)">Chat</button>
<button class="ch-btn" onclick="downloadChart('chart-activity','daily_activity')">PNG</button>
</div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-activity" height="80"></canvas></div>
</div>
<div class="an-grid-2">
{# Daily registrations — Bar #}
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header">
<div><div class="ch-title">New Registrations / Day</div><div class="ch-sub">How many new players joined each day</div></div>
<div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-dreg','daily_registrations')">PNG</button><button class="ch-btn" onclick="exportSeriesCSV(AN.regByDay,'date,registrations')">CSV</button></div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-dreg" height="90"></canvas></div>
</div>
{# Gifts per day — Bar #}
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header">
<div><div class="ch-title">Gifts Distributed / Day</div><div class="ch-sub">Reward boxes given out per day — reflects game activity</div></div>
<div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-gifts','gifts_per_day')">PNG</button><button class="ch-btn" onclick="exportSeriesCSV(AN.giftsByDay,'date,gifts')">CSV</button></div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-gifts" height="90"></canvas></div>
</div>
</div>
<div class="an-grid-2" style="margin-top:9px">
{# Items unlocked #}
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header">
<div><div class="ch-title">Items Unlocked / Day</div><div class="ch-sub">Cosmetic items earned through gameplay</div></div>
<div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-unlocked','items_unlocked')">PNG</button></div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-unlocked" height="90"></canvas></div>
</div>
{# Photos per day #}
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header">
<div><div class="ch-title">Photos Taken / Day</div><div class="ch-sub">In-game camera usage — proxy for social engagement</div></div>
<div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-photos','photos_per_day')">PNG</button></div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-photos" height="90"></canvas></div>
</div>
</div>
{# Distributions grid #}
<div class="an-grid-3" style="margin-top:9px">
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header"><div><div class="ch-title">Level Distribution</div><div class="ch-sub">How players are spread across levels</div></div><div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-leveldist','level_dist')">PNG</button></div></div>
<div class="chart-canvas-wrap"><canvas id="chart-leveldist" height="160"></canvas></div>
</div>
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header"><div><div class="ch-title">Gift Rarity Distribution</div><div class="ch-sub">What quality rewards are being given out</div></div><div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-rarity','gift_rarity')">PNG</button></div></div>
<div class="chart-canvas-wrap" style="max-height:160px;display:flex;justify-content:center"><canvas id="chart-rarity" height="160"></canvas></div>
</div>
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header"><div><div class="ch-title">Platform Breakdown</div><div class="ch-sub">Which platforms players log in from</div></div><div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-platform','platform')">PNG</button></div></div>
<div class="chart-canvas-wrap" style="max-height:160px;display:flex;justify-content:center"><canvas id="chart-platform" height="160"></canvas></div>
</div>
</div>
{# Top players #}
<div class="an-grid-2" style="margin-top:9px">
<div class="an-section">
<div class="an-sh">Top Players by XP <button class="sh-action" onclick="exportTableCSV('tbl-top-xp','top_players_xp')">CSV</button></div>
<table class="at" id="tbl-top-xp">
<thead><tr><th onclick="sortTable(this)">#</th><th onclick="sortTable(this)">Player</th><th onclick="sortTable(this)" class="tr">Level</th><th onclick="sortTable(this)" class="tr">XP</th><th onclick="sortTable(this)" class="tr">Tokens</th><th>Status</th></tr></thead>
<tbody>
{% for p in growth.top_players_xp %}
<tr>
<td class="dim" style="font-size:.7rem">{{ loop.index }}</td>
<td><a href="/admin/admin_players/edit/?id={{ p.id }}">{{ p.username }}</a></td>
<td class="tr" style="color:var(--kr-purple-l)">{{ p.level }}</td>
<td class="tr" style="color:var(--kr-success)"><strong>{{ "{:,}".format(p.xp) }}</strong></td>
<td class="tr dim">{{ "{:,}".format(p.tokens) }}</td>
<td>{% if p.developer %}<span style="background:rgba(245,158,11,.15);color:var(--kr-warning);border:1px solid rgba(245,158,11,.3);padding:1px 5px;border-radius:3px;font-size:.62rem">Dev</span>{% endif %}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
<div class="an-section">
<div class="an-sh">Top Players by Token Balance <button class="sh-action" onclick="exportTableCSV('tbl-top-tok','top_players_tokens')">CSV</button></div>
<table class="at" id="tbl-top-tok">
<thead><tr><th onclick="sortTable(this)">#</th><th onclick="sortTable(this)">Player</th><th onclick="sortTable(this)" class="tr">Level</th><th onclick="sortTable(this)" class="tr">Tokens</th><th onclick="sortTable(this)" class="tr">XP</th></tr></thead>
<tbody>
{% for p in growth.top_players_tokens %}
<tr>
<td class="dim" style="font-size:.7rem">{{ loop.index }}</td>
<td><a href="/admin/admin_players/edit/?id={{ p.id }}">{{ p.username }}</a></td>
<td class="tr" style="color:var(--kr-purple-l)">{{ p.level }}</td>
<td class="tr" style="color:var(--kr-warning)"><strong>{{ "{:,}".format(p.tokens) }}</strong></td>
<td class="tr dim">{{ "{:,}".format(p.xp) }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
{# Admin activity + bans #}
{% if growth.admin_by_day %}
<div class="chart-block">
<div class="ch-header">
<div><div class="ch-title">Admin Actions &amp; Bans / Day</div><div class="ch-sub">Moderation activity over time — spikes may indicate incidents</div></div>
<div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-adminbans','admin_bans')">PNG</button></div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-adminbans" height="80"></canvas></div>
</div>
{% endif %}
<div class="an-grid-2">
<div class="an-section">
<div class="an-sh">Admin Action Types</div>
<div style="padding:9px 11px">
{% set at_max = (growth.admin_action_types | map(attribute='c') | list | max) if growth.admin_action_types else 1 %}
{% for row in growth.admin_action_types %}
<div class="fi" style="margin-bottom:4px">
<span class="fl" style="width:130px;font-size:.69rem;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" title="{{ row.action }}">{{ row.action }}</span>
<div class="fb"><div class="fbar" style="width:{{ (row.c/at_max*100)|round }}%;background:var(--kr-purple)"></div></div>
<span class="fv" style="font-size:.73rem">{{ row.c }}</span>
</div>
{% endfor %}
</div>
</div>
<div class="an-section">
<div class="an-sh">Ban &amp; Unban History <button class="sh-action" onclick="exportTableCSV('tbl-bans','ban_history')">CSV</button></div>
<table class="at" id="tbl-bans">
<thead><tr><th onclick="sortTable(this)">Date</th><th onclick="sortTable(this)" class="tr" style="color:var(--kr-danger)">Bans</th><th onclick="sortTable(this)" class="tr" style="color:var(--kr-success)">Unbans</th></tr></thead>
<tbody>
{% set ban_map = {} %}{% set unban_map = {} %}
{% for row in growth.bans_by_day %}{% if row.action == 'ban' %}{% set _ = ban_map.update({row.d: row.c}) %}{% else %}{% set _ = unban_map.update({row.d: row.c}) %}{% endif %}{% endfor %}
{% for d in (ban_map.keys()|list + unban_map.keys()|list)|unique|sort %}
<tr>
<td class="dim" style="font-size:.72rem">{{ d }}</td>
<td class="tr" style="color:var(--kr-danger)">{{ ban_map.get(d, '—') }}</td>
<td class="tr" style="color:var(--kr-success)">{{ unban_map.get(d, '—') }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
</div>{# /growth #}
{# ════════════════════════════════════ OVERVIEW ════════════════════════════════════ #}
<div id="tab-overview" class="an-panel" style="display:none">
{% set uniq = stats.by_user | length %}
{% set tph = (total_playtime_secs / 3600) | round(1) %}
<div class="kpi-row">
<div class="kpi purple"><div class="kv">{{ stats.total }}</div><div class="kl">Total Events</div><div class="ks">Analytics events logged</div></div>
<div class="kpi teal"><div class="kv">{{ uniq }}</div><div class="kl">Unique Players</div><div class="ks">With any recorded event</div></div>
<div class="kpi green"><div class="kv">{{ activity_rows|length }}</div><div class="kl">Activity Sessions</div><div class="ks">Completed game sessions</div></div>
<div class="kpi yellow"><div class="kv">{{ purchases|length }}</div><div class="kl">Purchases</div><div class="ks">Store transactions</div></div>
<div class="kpi red"><div class="kv">{{ crashes|length }}</div><div class="kl">Crashes</div><div class="ks">Client errors reported</div></div>
<div class="kpi pink"><div class="kv">{{ social_counts.get('sent_text_message', 0) }}</div><div class="kl">Messages Sent</div></div>
<div class="kpi teal"><div class="kv">{{ gift_open_rate }}%</div><div class="kl">Gift Open Rate</div><div class="ks">{{ gift_open_consumed }}/{{ gift_open_total }} opened</div></div>
<div class="kpi purple"><div class="kv">{{ tph }}h</div><div class="kl">Total Playtime</div><div class="ks">Across all sessions</div></div>
</div>
<div class="an-grid-2">
<div class="chart-block">
<div class="ch-header">
<div><div class="ch-title">Events — Last 30 Days</div><div class="ch-sub">Analytics event volume per day</div></div>
<div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-evday','events_per_day')">PNG</button><button class="ch-btn" onclick="exportSeriesCSV(AN.eventsByDay,'date,events')">CSV</button></div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-evday" height="90"></canvas></div>
</div>
<div class="chart-block">
<div class="ch-header">
<div><div class="ch-title">Events by Hour of Day (UTC)</div><div class="ch-sub">When players are most active — useful for scheduling maintenance</div></div>
<div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-evhour','events_by_hour')">PNG</button></div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-evhour" height="90"></canvas></div>
</div>
</div>
{% if count_history %}
<div class="chart-block">
<div class="ch-header">
<div><div class="ch-title">Player Count — Last 72h</div><div class="ch-sub">Live online count sampled every 5 minutes — shows peak times and patterns</div></div>
<div class="ch-actions">
<button class="ch-btn" onclick="toggleSeries('chart-pchistory',1)">Sessions</button>
<button class="ch-btn" onclick="downloadChart('chart-pchistory','player_count_72h')">PNG</button>
<button class="ch-btn" onclick="exportSeriesCSV(AN.countHistory,'time,online,sessions','t','online,sessions')">CSV</button>
</div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-pchistory" height="70"></canvas></div>
<div class="dim" style="font-size:.63rem;margin-top:4px">
Peak online: <strong style="color:var(--kr-success)" id="count-peak">—</strong> &nbsp;·&nbsp;
Samples: {{ count_history|length }}
{% if count_history %}&nbsp;·&nbsp; From: {{ count_history[0].recorded_at[:16] }}{% endif %}
</div>
</div>
{% else %}
<div class="an-section" style="padding:12px;text-align:center"><span class="dim" style="font-size:.8rem">Player count history recording started — data will appear after the first 5-minute sample.</span></div>
{% endif %}
<div class="an-grid-2">
<div class="an-section">
<div class="an-sh">Activity Popularity <button class="sh-action" onclick="exportTableCSV('tbl-actpop','activity_popularity')">CSV</button></div>
<table class="at" id="tbl-actpop">
<thead><tr><th onclick="sortTable(this)">Activity</th><th onclick="sortTable(this)" class="tr">Sessions</th><th onclick="sortTable(this)" class="tr">Playtime</th><th onclick="sortTable(this)" class="tr">Avg FPS</th><th onclick="sortTable(this)" class="tr">Avg Ping</th><th onclick="sortTable(this)" class="tr">Gifts</th></tr></thead>
<tbody>
{% for name, s in activity_summary.items()|sort(attribute='1.total_time', reverse=true) %}
{% set fps=s.avg_fps %}{% set ping=s.avg_ping %}{% set secs=s.total_time %}
<tr>
<td><strong>{{ name }}</strong></td>
<td class="tr">{{ s.sessions }}</td>
<td class="tr dim">{% if secs>=3600 %}{{ (secs/3600)|round(1) }}h{% elif secs>=60 %}{{ (secs/60)|round(1) }}m{% else %}{{ secs|round(0)|int }}s{% endif %}</td>
<td class="tr"><span class="{% if fps>=90 %}fhi{% elif fps>=60 %}fmd{% elif fps>=30 %}flo{% else %}fbd{% endif %}">{{ fps }}</span></td>
<td class="tr"><span class="{% if ping<=50 %}phi{% elif ping<=100 %}pmd{% elif ping<=150 %}plo{% else %}pbd{% endif %}">{{ ping }}ms</span></td>
<td class="tr dim">{{ s.total_gifts }}</td>
</tr>
{% else %}<tr><td colspan="6" class="tc dim" style="padding:14px">No activity data yet</td></tr>{% endfor %}
</tbody>
</table>
</div>
<div class="an-section">
<div class="an-sh">Top Players by Events</div>
<table class="at">
<thead><tr><th>#</th><th onclick="sortTable(this)">Player</th><th onclick="sortTable(this)" class="tr">Events</th><th style="width:38%">Share</th></tr></thead>
<tbody>
{% set em = stats.by_user[0].c if stats.by_user else 1 %}
{% for row in stats.by_user[:15] %}
<tr>
<td class="dim" style="font-size:.7rem">{{ loop.index }}</td>
<td><a href="/admin/admin_players/edit/?id={{ row.user_id }}">{{ user_names.get(row.user_id|int, '#'~row.user_id) }}</a></td>
<td class="tr"><strong>{{ row.c }}</strong></td>
<td><div style="background:rgba(155,89,182,.12);border-radius:3px;height:9px;overflow:hidden"><div style="background:var(--kr-purple);height:100%;width:{{ (row.c/em*100)|round }}%;border-radius:3px"></div></div></td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
<div class="an-section">
<div class="an-sh">Event Type Breakdown</div>
<div style="padding:9px 11px">
{% set em2 = stats.by_type[0].c if stats.by_type else 1 %}
<div style="display:grid;grid-template-columns:repeat(auto-fill,minmax(250px,1fr));gap:5px">
{% for row in stats.by_type %}
<div style="display:flex;align-items:center;gap:7px">
<span class="mono dim" style="width:180px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;font-size:.7rem" title="{{ row.event_type }}">{{ row.event_type }}</span>
<div style="flex:1;height:7px;background:rgba(155,89,182,.1);border-radius:3px;overflow:hidden"><div style="background:var(--kr-purple-l);height:100%;width:{{ (row.c/em2*100)|round }}%;border-radius:3px"></div></div>
<span style="width:28px;text-align:right;font-weight:700;font-size:.73rem">{{ row.c }}</span>
</div>
{% endfor %}
</div>
</div>
</div>
</div>{# /overview #}
{# ════════════════════════════════════ PERFORMANCE ════════════════════════════════════ #}
<div id="tab-performance" class="an-panel" style="display:none">
<div class="an-section">
<div class="an-sh">Per-Activity Performance Summary <button class="sh-action" onclick="exportTableCSV('tbl-perf','performance_summary')">CSV</button></div>
<div class="an-tw">
<table class="at" id="tbl-perf">
<thead><tr>
<th onclick="sortTable(this)">Activity</th><th onclick="sortTable(this)" class="tr">Sessions</th>
<th onclick="sortTable(this)" class="tr">Avg FPS</th><th onclick="sortTable(this)" class="tr">±σ FPS</th>
<th onclick="sortTable(this)" class="tr">Avg Ping</th><th onclick="sortTable(this)" class="tr">±σ Ping</th>
<th onclick="sortTable(this)" class="tr">RW Drop%</th><th onclick="sortTable(this)" class="tr">Send Lag</th>
<th onclick="sortTable(this)" class="tr">Avg Load</th><th onclick="sortTable(this)" class="tr">Total Time</th>
</tr></thead>
<tbody>
{% for name, s in activity_summary.items()|sort(attribute='1.sessions', reverse=true) %}
{% set fps=s.avg_fps %}{% set ping=s.avg_ping %}{% set secs=s.total_time %}{% set rw=s.avg_rw_drop %}
<tr{% if fps > 0 and fps < 30 %} class="warn-row"{% endif %}>
<td><strong>{{ name }}</strong></td>
<td class="tr">{{ s.sessions }}</td>
<td class="tr"><span class="{% if fps>=90 %}fhi{% elif fps>=60 %}fmd{% elif fps>=30 %}flo{% else %}fbd{% endif %}">{{ fps }}</span></td>
<td class="tr dim" style="font-size:.72rem">±{{ s.avg_stdev_fps }}</td>
<td class="tr"><span class="{% if ping<=50 %}phi{% elif ping<=100 %}pmd{% elif ping<=150 %}plo{% else %}pbd{% endif %}">{{ ping }}ms</span></td>
<td class="tr dim" style="font-size:.72rem">±{{ s.avg_stdev_ping }}ms</td>
<td class="tr"><span class="{% if rw<=5 %}fhi{% elif rw<=20 %}flo{% else %}fbd{% endif %}">{{ rw }}%</span></td>
<td class="tr dim" style="font-size:.72rem">{{ s.avg_sl }}ms</td>
<td class="tr dim" style="font-size:.72rem">{{ s.avg_load_time }}s</td>
<td class="tr dim">{% if secs>=3600 %}{{ (secs/3600)|round(1) }}h{% elif secs>=60 %}{{ (secs/60)|round(1) }}m{% else %}{{ secs|round(0)|int }}s{% endif %}</td>
</tr>
{% else %}<tr><td colspan="10" class="tc dim" style="padding:14px">No data</td></tr>{% endfor %}
</tbody>
</table>
</div>
</div>
{# FPS / Ping radar by activity #}
<div class="an-grid-2">
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header"><div><div class="ch-title">Avg FPS by Activity</div><div class="ch-sub">&#x3C; 60 = poor, ≥ 90 = excellent</div></div><div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-fps','fps_by_activity')">PNG</button></div></div>
<div class="chart-canvas-wrap"><canvas id="chart-fps" height="140"></canvas></div>
</div>
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header"><div><div class="ch-title">Avg Ping by Activity</div><div class="ch-sub">&#x3C; 50ms = great, > 150ms = poor</div></div><div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-ping','ping_by_activity')">PNG</button></div></div>
<div class="chart-canvas-wrap"><canvas id="chart-ping" height="140"></canvas></div>
</div>
</div>
<div class="an-grid-2" style="margin-top:9px">
<div class="an-section">
<div class="an-sh">Photon Region Latency <button class="sh-action" onclick="exportTableCSV('tbl-photon','photon_latency')">CSV</button></div>
<table class="at" id="tbl-photon">
<thead><tr><th onclick="sortTable(this)">Region</th><th onclick="sortTable(this)" class="tr">Avg</th><th onclick="sortTable(this)" class="tr">Min</th><th onclick="sortTable(this)" class="tr">P95</th><th onclick="sortTable(this)" class="tr">Max</th><th onclick="sortTable(this)" class="tr">n</th><th style="width:28%">Quality</th></tr></thead>
<tbody>
{% for region, s in photon_summary.items()|sort(attribute='1.avg') %}
{% set avp=s.avg %}
<tr{% if avp > 200 %} class="warn-row"{% endif %}>
<td><strong class="mono">{{ region|upper }}</strong></td>
<td class="tr"><span class="{% if avp<=50 %}phi{% elif avp<=100 %}pmd{% elif avp<=150 %}plo{% else %}pbd{% endif %}">{{ avp|round(0)|int }}ms</span></td>
<td class="tr dim">{{ s.min }}</td>
<td class="tr dim">{{ s.p95 }}</td>
<td class="tr dim">{{ s.max }}</td>
<td class="tr dim">{{ s.count }}</td>
<td>
{% set perc=[avp/4,100]|min %}
{% if avp<=50 %}{% set bc='var(--kr-success)' %}{% elif avp<=100 %}{% set bc='#8bc34a' %}{% elif avp<=150 %}{% set bc='var(--kr-warning)' %}{% else %}{% set bc='var(--kr-danger)' %}{% endif %}
<div style="background:rgba(255,255,255,.06);border-radius:3px;height:7px;overflow:hidden"><div style="background:{{ bc }};height:100%;width:{{ (100-perc)|round }}%;border-radius:3px"></div></div>
</td>
</tr>
{% else %}<tr><td colspan="7" class="tc dim" style="padding:12px">No photon data yet</td></tr>{% endfor %}
</tbody>
</table>
</div>
<div class="an-section">
<div class="an-sh">Scene Load Events</div>
<table class="at">
<thead><tr><th onclick="sortTable(this)">Scene</th><th onclick="sortTable(this)" class="tr">Loads</th><th onclick="sortTable(this)" class="tr">Players</th><th>Top Source</th></tr></thead>
<tbody>
{% for scene, s in load_scene_stats.items()|sort(attribute='1.count', reverse=true) %}
{% set ts = s.sources.items()|list|sort(attribute='1', reverse=true) %}
<tr>
<td><strong>{{ scene }}</strong></td>
<td class="tr">{{ s.count }}</td>
<td class="tr dim">{{ s.players }}</td>
<td class="dim" style="font-size:.71rem">{{ ts[0][0] if ts else '—' }}</td>
</tr>
{% else %}<tr><td colspan="4" class="tc dim" style="padding:12px">No load events</td></tr>{% endfor %}
</tbody>
</table>
</div>
</div>
<div class="an-section" style="margin-top:9px">
<div class="an-sh">Activity Session Log <span class="ct">{{ activity_rows|length }} records</span> <button class="sh-action" onclick="exportTableCSV('act-tbody','activity_sessions')">CSV</button></div>
<div style="padding:7px 9px 0">
<input class="an-filter" placeholder="Filter by player, activity..." oninput="filterRows('act-tbody',this.value)">
</div>
<div class="an-tw" style="max-height:420px;overflow-y:auto">
<table class="at">
<thead><tr>
<th>Player</th><th>Activity</th>
<th class="tr">Time</th><th class="tr">FPS</th><th class="tr">±σ</th>
<th class="tr">Ping</th><th class="tr">±σ</th>
<th class="tr">RW%</th><th class="tr">SL</th>
<th class="tr">Load</th><th>Src</th><th>When</th>
</tr></thead>
<tbody id="act-tbody">
{% for a in activity_rows %}
{% set fps=a.avg_fps %}{% set ping=a.avg_ping %}{% set secs=a.total_time %}{% set rw=a.rw_dropped_perc %}
<tr{% if fps > 0 and fps < 30 %} class="warn-row"{% endif %}>
<td><a href="/admin/admin_players/edit/?id={{ a.user_id }}">{{ user_names.get(a.user_id|int,'#'~a.user_id) }}</a></td>
<td><strong>{{ a.activity }}</strong>{% if a.is_sandbox %} <span class="badge badge-secondary" style="font-size:.58rem;padding:1px 4px">SB</span>{% endif %}</td>
<td class="tr dim">{% if secs>=3600 %}{{ (secs/3600)|round(1) }}h{% elif secs>=60 %}{{ (secs/60)|round(1) }}m{% else %}{{ secs|round(0)|int }}s{% endif %}</td>
<td class="tr"><span class="{% if fps>=90 %}fhi{% elif fps>=60 %}fmd{% elif fps>=30 %}flo{% else %}fbd{% endif %}">{{ fps|round(0)|int }}</span></td>
<td class="tr dim" style="font-size:.69rem">±{{ a.stdev_fps|round(1) }}</td>
<td class="tr"><span class="{% if ping<=50 %}phi{% elif ping<=100 %}pmd{% elif ping<=150 %}plo{% else %}pbd{% endif %}">{{ ping|round(0)|int }}</span></td>
<td class="tr dim" style="font-size:.69rem">±{{ a.stdev_ping|round(1) }}</td>
<td class="tr"><span class="{% if rw<=5 %}fhi{% elif rw<=20 %}flo{% else %}fbd{% endif %}" style="font-size:.7rem">{{ rw|round(1) }}%</span></td>
<td class="tr dim" style="font-size:.69rem">{{ a.avg_sl|round(2) }}</td>
<td class="tr dim" style="font-size:.69rem">{{ a.load_time|round(1) }}s</td>
<td class="dim" style="font-size:.69rem">{{ a.load_source }}</td>
<td class="dim" style="font-size:.68rem;white-space:nowrap">{{ (a.created_at or '')[:16] }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
</div>{# /performance #}
{# ════════════════════════════════════ ECONOMY ════════════════════════════════════ #}
<div id="tab-economy" class="an-panel" style="display:none">
{% set avg_cost = (total_tokens_spent / purchases|length)|round(0)|int if purchases else 0 %}
<div class="kpi-row">
<div class="kpi yellow"><div class="kv">{{ "{:,}".format(total_tokens_spent) }}</div><div class="kl">Tokens Spent</div><div class="ks">Total token drain via purchases</div></div>
<div class="kpi purple"><div class="kv">{{ purchases|length }}</div><div class="kl">Purchases</div></div>
<div class="kpi teal"><div class="kv">{{ avg_cost }}</div><div class="kl">Avg Cost</div><div class="ks">Per transaction</div></div>
<div class="kpi green"><div class="kv">{{ top_items|length }}</div><div class="kl">Unique Items Sold</div></div>
<div class="kpi pink"><div class="kv">{{ gift_open_consumed }}/{{ gift_open_total }}</div><div class="kl">Gifts Opened</div></div>
<div class="kpi teal"><div class="kv">{{ gift_open_rate }}%</div><div class="kl">Open Rate</div><div class="ks">High = players engaging with rewards</div></div>
</div>
{# Daily token drain chart #}
{% if daily_spend %}
<div class="chart-block">
<div class="ch-header">
<div><div class="ch-title">Daily Token Drain</div><div class="ch-sub">Tokens spent per day across all purchases — indicates economy health</div></div>
<div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-spend','daily_token_drain')">PNG</button><button class="ch-btn" onclick="exportSeriesCSV(AN.dailySpend,'date,tokens_spent')">CSV</button></div>
</div>
<div class="chart-canvas-wrap"><canvas id="chart-spend" height="80"></canvas></div>
</div>
{% endif %}
<div class="an-grid-2">
<div class="an-section">
<div class="an-sh">Top Purchased Items <button class="sh-action" onclick="exportTableCSV('tbl-items','top_items')">CSV</button></div>
<table class="at" id="tbl-items">
<thead><tr><th onclick="sortTable(this)">Item</th><th onclick="sortTable(this)">Type</th><th onclick="sortTable(this)" class="tr">Count</th><th onclick="sortTable(this)" class="tr">Total Spent</th><th onclick="sortTable(this)" class="tr">Avg</th></tr></thead>
<tbody>
{% for name, d in top_items %}
<tr>
<td><strong>{{ name }}</strong></td>
<td class="dim" style="font-size:.7rem">{{ d.item_type }}</td>
<td class="tr">{{ d.count }}</td>
<td class="tr dim">{{ "{:,}".format(d.total_cost) }}</td>
<td class="tr dim">{{ (d.total_cost/d.count)|round(0)|int }}</td>
</tr>
{% else %}<tr><td colspan="5" class="tc dim" style="padding:14px">No purchases yet</td></tr>{% endfor %}
</tbody>
</table>
</div>
<div>
<div class="chart-block" style="margin-bottom:9px">
<div class="ch-header"><div><div class="ch-title">Item Type Breakdown</div><div class="ch-sub">Which categories sell most</div></div><div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-itype','item_types')">PNG</button></div></div>
<div class="chart-canvas-wrap" style="max-height:130px;display:flex;justify-content:center"><canvas id="chart-itype" height="130"></canvas></div>
</div>
<div class="chart-block" style="margin-bottom:0">
<div class="ch-header"><div><div class="ch-title">Storefront Breakdown</div><div class="ch-sub">Which storefronts drive purchases</div></div><div class="ch-actions"><button class="ch-btn" onclick="downloadChart('chart-sf','storefronts')">PNG</button></div></div>
<div class="chart-canvas-wrap" style="max-height:130px;display:flex;justify-content:center"><canvas id="chart-sf" height="130"></canvas></div>
</div>
</div>
</div>
<div class="an-section">
<div class="an-sh">Full Purchase Log <span class="ct">{{ purchases|length }} records</span> <button class="sh-action" onclick="exportTableCSV('pur-tbody','purchases')">CSV</button></div>
<div style="padding:7px 9px 0">
<input class="an-filter" placeholder="Filter by player, item, type..." oninput="filterRows('pur-tbody',this.value)">
</div>
<div class="an-tw" style="max-height:380px;overflow-y:auto">
<table class="at">
<thead><tr><th>Player</th><th onclick="sortTable(this)">Item</th><th onclick="sortTable(this)">Type</th><th onclick="sortTable(this)" class="tr">Cost</th><th class="tr">Before</th><th class="tr">After</th><th>Store</th><th onclick="sortTable(this)">When</th></tr></thead>
<tbody id="pur-tbody">
{% for p in purchases %}
<tr>
<td><a href="/admin/admin_players/edit/?id={{ p.user_id }}">{{ user_names.get(p.user_id|int,'#'~p.user_id) }}</a></td>
<td><strong>{{ p.item_name }}</strong></td>
<td class="dim" style="font-size:.7rem">{{ p.item_type }}</td>
<td class="tr" style="color:var(--kr-warning)">{{ "{:,}".format(p.cost|int) }}</td>
<td class="tr dim">{{ "{:,}".format(p.initial_bal|int) }}</td>
<td class="tr dim">{{ "{:,}".format(p.new_bal|int) }}</td>
<td class="dim" style="font-size:.7rem">{{ p.storefront }}</td>
<td class="dim" style="font-size:.68rem;white-space:nowrap">{{ (p.created_at or '')[:16] }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
</div>{# /economy #}
{# ════════════════════════════════════ SOCIAL & STABILITY ════════════════════════════════════ #}
<div id="tab-social" class="an-panel" style="display:none">
<div class="an-grid-2">
<div>
<div class="an-section" style="margin-bottom:9px">
<div class="an-sh">Game Invite Funnel</div>
<div style="padding:12px 14px">
{% set im = [invite_funnel.sent,1]|max %}
<div class="fi"><span class="fl">Sent</span><div class="fb"><div class="fbar" style="width:{{ (invite_funnel.sent/im*100)|round }}%;background:var(--kr-purple)"></div></div><span class="fv">{{ invite_funnel.sent }}</span></div>
<div class="fi"><span class="fl">Received</span><div class="fb"><div class="fbar" style="width:{{ (invite_funnel.received/im*100)|round }}%;background:var(--kr-info)"></div></div><span class="fv">{{ invite_funnel.received }}</span></div>
<div class="fi"><span class="fl">Accepted</span><div class="fb"><div class="fbar" style="width:{{ (invite_funnel.accepted/im*100)|round }}%;background:var(--kr-success)"></div></div><span class="fv">{{ invite_funnel.accepted }}</span></div>
{% if invite_funnel.sent %}<div class="dim" style="font-size:.7rem;margin-top:6px">Acceptance rate: <strong style="color:var(--kr-success)">{{ (invite_funnel.accepted/invite_funnel.sent*100)|round(0)|int }}%</strong></div>{% endif %}
</div>
</div>
<div class="an-section">
<div class="an-sh">Social Event Counts</div>
<table class="at">
<thead><tr><th onclick="sortTable(this)">Event</th><th onclick="sortTable(this)" class="tr">Count</th></tr></thead>
<tbody>
{% for et, cnt in social_counts.items()|sort(attribute='1',reverse=true) %}
<tr><td class="mono dim" style="font-size:.72rem">{{ et }}</td><td class="tr"><strong>{{ cnt }}</strong></td></tr>
{% else %}<tr><td colspan="2" class="tc dim" style="padding:12px">No social events</td></tr>{% endfor %}
</tbody>
</table>
</div>
</div>
<div>
<div class="an-section" style="margin-bottom:9px">
<div class="an-sh">Connection Failures</div>
{% if conn_failures %}
<table class="at">
<thead><tr><th onclick="sortTable(this)">Cause</th><th onclick="sortTable(this)" class="tr">Count</th></tr></thead>
<tbody>
{% for cause, cnt in conn_failures.items()|sort(attribute='1',reverse=true) %}
<tr{% if cnt > 5 %} class="warn-row"{% endif %}><td class="mono" style="color:var(--kr-danger);font-size:.72rem">{{ cause }}</td><td class="tr"><strong>{{ cnt }}</strong></td></tr>
{% endfor %}
</tbody>
</table>
{% else %}<div class="tc dim" style="padding:14px;font-size:.8rem">✓ No connection failures recorded</div>{% endif %}
</div>
<div class="an-section">
<div class="an-sh">Network Master Switches <span class="ct">{{ master_switches|length }}</span></div>
<div class="an-tw" style="max-height:200px;overflow-y:auto">
<table class="at">
<thead><tr><th>Player</th><th>Activity</th><th class="tr">Old Ping</th><th class="tr">New Ping</th><th>When</th></tr></thead>
<tbody>
{% for ms in master_switches %}
<tr>
<td><a href="/admin/admin_players/edit/?id={{ ms.user_id }}">{{ user_names.get(ms.user_id|int,'#'~ms.user_id) }}</a></td>
<td class="dim" style="font-size:.72rem">{{ ms.activity }}</td>
<td class="tr dim">{{ ms.old_ping }}ms</td>
<td class="tr" style="color:var(--kr-success)">{{ ms.new_ping }}ms</td>
<td class="dim" style="font-size:.68rem">{{ (ms.created_at or '')[:16] }}</td>
</tr>
{% else %}<tr><td colspan="5" class="tc dim" style="padding:12px">No master switches</td></tr>{% endfor %}
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="an-section">
<div class="an-sh">
Crash Patterns
<span style="background:rgba(239,68,68,.18);color:var(--kr-danger);border:1px solid rgba(239,68,68,.3);padding:1px 7px;border-radius:10px;font-size:.68rem;font-weight:700;margin-left:6px">{{ crashes|length }}</span>
<button class="sh-action" onclick="exportTableCSV('tbl-crashes','crashes')">CSV</button>
</div>
{% if crash_patterns %}
<div style="padding:9px 11px;border-bottom:1px solid var(--kr-border)">
{% set cpm = (crash_patterns.values()|list|max) or 1 %}
{% for err, cnt in crash_patterns.items()|sort(attribute='1',reverse=true) %}
<div style="display:flex;align-items:center;gap:7px;margin-bottom:4px">
<div class="fb" style="flex:2"><div class="fbar" style="width:{{ (cnt/cpm*100)|round }}%;background:var(--kr-danger)"></div></div>
<span style="color:var(--kr-danger);font-weight:700;width:22px;text-align:right;font-size:.74rem">{{ cnt }}</span>
<span class="mono dim" style="font-size:.69rem;flex:3;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" title="{{ err }}">{{ err }}</span>
</div>
{% endfor %}
</div>
{% endif %}
<div class="an-tw" style="max-height:280px;overflow-y:auto">
<table class="at" id="tbl-crashes">
<thead><tr><th>Player</th><th>Error</th><th>When</th></tr></thead>
<tbody>
{% for c in crashes %}
<tr>
<td><a href="/admin/admin_players/edit/?id={{ c.user_id }}">{{ user_names.get(c.user_id|int,'#'~c.user_id) }}</a></td>
<td class="mono" style="color:var(--kr-danger);font-size:.69rem;max-width:480px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" title="{{ c.error }}">{{ c.error }}</td>
<td class="dim" style="font-size:.68rem;white-space:nowrap">{{ (c.created_at or '')[:16] }}</td>
</tr>
{% else %}<tr><td colspan="3" class="tc dim" style="padding:12px">✓ No crashes recorded</td></tr>{% endfor %}
</tbody>
</table>
</div>
</div>
<div class="an-grid-2">
{% if levelup_data %}
<div class="an-section">
<div class="an-sh">Level-Up Events <span class="ct">{{ levelup_data|length }}</span></div>
<div class="an-tw" style="max-height:240px;overflow-y:auto">
<table class="at">
<thead><tr><th>Player</th><th>In Activity</th><th>When</th></tr></thead>
<tbody>
{% for lu in levelup_data %}
<tr>
<td><a href="/admin/admin_players/edit/?id={{ lu.user_id }}">{{ user_names.get(lu.user_id|int,'#'~lu.user_id) }}</a></td>
<td class="dim">{{ lu.activity }}</td>
<td class="dim" style="font-size:.68rem">{{ (lu.created_at or '')[:16] }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
{% endif %}
{% if objective_data %}
<div class="an-section">
<div class="an-sh">Daily Objective Completions <span class="ct">{{ objective_data|length }}</span></div>
<div class="an-tw" style="max-height:240px;overflow-y:auto">
<table class="at">
<thead><tr><th>Player</th><th class="tr">Type</th><th class="tr">Score</th><th class="tr">Level</th><th>When</th></tr></thead>
<tbody>
{% for ob in objective_data %}
<tr>
<td><a href="/admin/admin_players/edit/?id={{ ob.user_id }}">{{ user_names.get(ob.user_id|int,'#'~ob.user_id) }}</a></td>
<td class="tr dim">{{ ob.type }}</td>
<td class="tr dim">{{ ob.score }}</td>
<td class="tr dim">{{ ob.level }}</td>
<td class="dim" style="font-size:.68rem">{{ (ob.created_at or '')[:16] }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
{% endif %}
</div>
</div>{# /social #}
{# ════════════════════════════════════ RAW EVENTS ════════════════════════════════════ #}
<div id="tab-raw" class="an-panel" style="display:none">
<div class="an-section">
<div class="an-sh">All Events <span class="ct">{{ recent_events|length }} most recent</span> <button class="sh-action" onclick="exportTableCSV('raw-tbody','raw_events')">CSV</button></div>
<div style="padding:7px 9px 0;display:flex;gap:7px">
<input class="an-filter" style="flex:2;margin-bottom:0" id="raw-q" placeholder="Filter by player, type, property..." oninput="rawFilter()">
<select class="an-filter" style="flex:1;max-width:210px;margin-bottom:0" id="raw-type" onchange="rawFilter()">
<option value="">All types</option>
{% for row in stats.by_type %}
<option value="{{ row.event_type }}">{{ row.event_type }} ({{ row.c }})</option>
{% endfor %}
</select>
</div>
<div style="padding:3px 9px 7px"><span id="raw-count" class="dim" style="font-size:.68rem">{{ recent_events|length }} rows</span></div>
<div class="an-tw" style="max-height:600px;overflow-y:auto">
<table class="at">
<thead><tr>
<th style="width:38px">ID</th><th>Player</th><th>Type</th><th>Properties</th>
<th style="width:128px">Time</th>
</tr></thead>
<tbody id="raw-tbody">
{% for ev in recent_events %}
<tr data-type="{{ ev.event_type }}">
<td class="dim mono" style="font-size:.67rem">{{ ev.id }}</td>
<td><a href="/admin/admin_players/edit/?id={{ ev.user_id }}">{{ user_names.get(ev.user_id|int,'#'~ev.user_id) }}</a></td>
<td style="white-space:nowrap">
{% set et=ev.event_type %}
{% if et=='activity_stats' %}<span class="badge badge-info" style="font-size:.62rem">{{ et }}</span>
{% elif 'load' in et %}<span class="badge badge-success" style="font-size:.62rem">{{ et }}</span>
{% elif et=='game_start' %}<span class="badge badge-primary" style="font-size:.62rem">{{ et }}</span>
{% elif et in ('session_start','session_end') %}<span class="badge badge-warning" style="font-size:.62rem">{{ et }}</span>
{% elif et=='player_leveled_up' %}<span style="background:var(--kr-purple);color:#fff;padding:1px 5px;border-radius:3px;font-size:.62rem">{{ et }}</span>
{% elif et=='crashdump_details' %}<span class="badge badge-danger" style="font-size:.62rem">{{ et }}</span>
{% elif et=='purchased_item' %}<span style="background:rgba(245,158,11,.18);color:var(--kr-warning);border:1px solid rgba(245,158,11,.3);padding:1px 5px;border-radius:3px;font-size:.62rem">{{ et }}</span>
{% else %}<span class="badge badge-secondary" style="font-size:.62rem">{{ et }}</span>{% endif %}
</td>
<td>
<span class="mono dim" style="font-size:.69rem;word-break:break-all">
{% set props=ev._props %}
{% if props %}
{% set items=props.items()|list %}
{% for k,v in items[:6] %}<strong>{{ k }}</strong>={{ v|string|truncate(28,true,'…') }}{% if not loop.last %} · {% endif %}{% endfor %}
{% if items|length>6 %}<span class="dim"> +{{ items|length-6 }}</span>{% endif %}
{% else %}—{% endif %}
</span>
</td>
<td class="dim" style="font-size:.68rem;white-space:nowrap">{{ (ev.created_at or '')[:16] }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
</div>{# /raw #}
</div>{# /an-wrap #}
<div class="copy-toast" id="copy-toast">Link copied!</div>
<script src="https://cdn.jsdelivr.net/npm/chart.js@4.4.0/dist/chart.umd.min.js"></script>
<script>
(function(){
'use strict';
/* ── Shared color palette ── */
var C = {
green: '#10b981', blue: '#3b82f6', pink: '#ec4899',
orange: '#f59e0b', purple: '#a855f7', red: '#ef4444',
teal: '#06b6d4', yellow: '#eab308',
greenA: 'rgba(16,185,129,.15)', blueA: 'rgba(59,130,246,.15)',
pinkA: 'rgba(236,72,153,.15)', orangeA: 'rgba(245,158,11,.15)',
purpleA:'rgba(168,85,247,.15)',
grid: 'rgba(255,255,255,.06)', tick: 'rgba(255,255,255,.45)',
};
Chart.defaults.color = C.tick;
Chart.defaults.borderColor = C.grid;
Chart.defaults.font.family = "'Inter','Segoe UI',sans-serif";
Chart.defaults.font.size = 11;
/* ── State ── */
var rangeFrom = null, rangeTo = null;
var charts = {};
var activeTab = 'growth';
/* ── Date helpers ── */
function daysAgo(n) {
var d = new Date(); d.setDate(d.getDate() - n);
return d.toISOString().slice(0,10);
}
function filterDC(arr, field) {
field = field || 'd';
if (!rangeFrom && !rangeTo) return arr;
return arr.filter(function(r) {
var d = r[field];
if (rangeFrom && d < rangeFrom) return false;
if (rangeTo && d > rangeTo) return false;
return true;
});
}
function dcLabels(arr) { return filterDC(arr).map(function(r){return r.d;}); }
function dcValues(arr) { return filterDC(arr).map(function(r){return r.c;}); }
function cumulativeDC(arr) {
var s=0; return filterDC(arr).map(function(r){s+=r.c;return s;});
}
/* ── Trend: last 7d vs prior 7d ── */
function trend7(arr) {
if (!arr || !arr.length) return null;
var sorted = arr.slice().sort(function(a,b){return a.d<b.d?-1:1;});
var now = sorted.slice(-7).reduce(function(s,r){return s+r.c;},0);
var prev = sorted.slice(-14,-7).reduce(function(s,r){return s+r.c;},0);
if (!prev) return null;
var pct = Math.round((now-prev)/prev*100);
return pct;
}
function renderTrend(elId, arr) {
var el = document.getElementById(elId);
if (!el) return;
var pct = trend7(arr);
if (pct === null) { el.textContent='—'; el.className='kt nc'; return; }
var arrow = pct >= 0 ? '↑' : '↓';
el.textContent = arrow+' '+Math.abs(pct)+'% vs prev 7d';
el.className = 'kt '+(pct>=0?'up':'dn');
}
/* ── Anomaly: is latest day < 50% of 14d rolling avg? ── */
function hasAnomaly(arr) {
if (!arr || arr.length < 7) return false;
var s = arr.slice().sort(function(a,b){return a.d<b.d?-1:1;});
var recent = s.slice(-1)[0].c;
var avg14 = s.slice(-15,-1).reduce(function(a,r){return a+r.c;},0) / Math.max(s.slice(-15,-1).length,1);
return avg14 > 2 && recent < avg14 * 0.45;
}
/* ── Chart factory helpers ── */
function baseOpts(extraY) {
return {
animation: false,
responsive: true,
maintainAspectRatio: false,
interaction: { mode:'index', intersect:false },
plugins: {
legend: { display: false },
tooltip: {
backgroundColor: '#1a1a2e',
borderColor: '#2a2a4a',
borderWidth: 1,
titleColor: '#e2e8f0',
bodyColor: '#94a3b8',
padding: 8,
callbacks: {}
}
},
scales: {
x: {
grid: { color: C.grid },
ticks: { color: C.tick, maxTicksLimit: 10, maxRotation: 0 }
},
y: Object.assign({
grid: { color: C.grid },
ticks: { color: C.tick, maxTicksLimit: 6 }
}, extraY||{})
}
};
}
function lineDataset(label, data, color, fill, colorA) {
return {
label: label, data: data,
borderColor: color, borderWidth: 2,
backgroundColor: fill ? (colorA||color) : 'transparent',
fill: !!fill, pointRadius: data.length > 60 ? 0 : 3,
pointHoverRadius: 5, tension: 0.3,
};
}
function barDataset(label, data, color) {
return {
label: label, data: data,
backgroundColor: color, borderRadius: 3, borderSkipped: false,
};
}
/* ── Build / rebuild all charts ── */
function buildCharts() {
buildGrowthCharts();
buildOverviewCharts();
buildPerformanceCharts();
buildEconomyCharts();
updateTrends();
computePeakCount();
}
function updateCharts() {
Object.keys(charts).forEach(function(k) {
if (charts[k]) { charts[k].destroy(); delete charts[k]; }
});
buildCharts();
}
function makeChart(id, type, data, options) {
var el = document.getElementById(id);
if (!el) return null;
if (charts[id]) { charts[id].destroy(); }
var wrap = el.parentElement;
var h = parseInt(el.getAttribute('height')) || 80;
el.style.height = h+'px';
el.style.width = '100%';
var chart = new Chart(el, { type:type, data:data, options:options });
charts[id] = chart;
return chart;
}
/* ── Growth charts ── */
function buildGrowthCharts() {
/* Cumulative registrations */
makeChart('chart-cumreg','line',{
labels: dcLabels(AN.regByDay),
datasets: [lineDataset('Cumulative Players', cumulativeDC(AN.regByDay), C.green, true, C.greenA)]
}, Object.assign(baseOpts(), { aspectRatio:false,
plugins: Object.assign(baseOpts().plugins, {
legend:{display:false},
tooltip:{callbacks:{label:function(c){return ' '+c.formattedValue+' total players';}}}
})
}));
/* Multi-series daily activity (normalized) */
var loginV = dcValues(AN.loginByDay), loginMax = Math.max.apply(null,loginV)||1;
var visitV = dcValues(AN.visitByDay), visitMax = Math.max.apply(null,visitV)||1;
var photoV = dcValues(AN.photoByDay), photoMax = Math.max.apply(null,photoV)||1;
var chatV = dcValues(AN.chatByDay), chatMax = Math.max.apply(null,chatV)||1;
var norm = function(v,m){return v.map(function(x){return x/m;});};
var labels = dcLabels(AN.loginByDay);
var actOpts = baseOpts({max:1.05, ticks:{callback:function(v){return Math.round(v*100)+'%';}, color:C.tick, maxTicksLimit:5}});
actOpts.plugins.legend = {display:true, labels:{color:'#e2e8f0', boxWidth:12, padding:14}};
actOpts.plugins.tooltip.callbacks.label = function(c){
var maxes=[loginMax,visitMax,photoMax,chatMax];
var raw = Math.round(c.raw * maxes[c.datasetIndex]);
return ' '+c.dataset.label+': '+raw+' ('+Math.round(c.raw*100)+'%)';
};
makeChart('chart-activity','line',{
labels: labels,
datasets: [
lineDataset('Logins', norm(loginV,loginMax), C.green),
lineDataset('Visits', norm(visitV,visitMax), C.blue),
lineDataset('Photos', norm(photoV,photoMax), C.pink),
lineDataset('Chat Msgs',norm(chatV, chatMax), C.orange),
]
}, actOpts);
var combined = AN.loginByDay.concat(AN.visitByDay).concat(AN.photoByDay).concat(AN.chatByDay);
var el = document.getElementById('anomaly-activity');
if (el) el.style.display = hasAnomaly(combined) ? '' : 'none';
/* Daily registrations */
var regOpts = baseOpts();
regOpts.plugins.tooltip.callbacks.label = function(c){return ' '+c.formattedValue+' new players';};
makeChart('chart-dreg','bar',{
labels: dcLabels(AN.regByDay),
datasets: [barDataset('Registrations', dcValues(AN.regByDay), C.greenA.replace('.15',',.65'))]
}, regOpts);
makeChart('chart-gifts','bar',{
labels: dcLabels(AN.giftsByDay),
datasets: [barDataset('Gifts', dcValues(AN.giftsByDay), 'rgba(168,85,247,.65)')]
}, baseOpts());
makeChart('chart-unlocked','bar',{
labels: dcLabels(AN.unlockedByDay),
datasets: [barDataset('Items', dcValues(AN.unlockedByDay), 'rgba(59,130,246,.6)')]
}, baseOpts());
makeChart('chart-photos','bar',{
labels: dcLabels(AN.photoByDay),
datasets: [barDataset('Photos', dcValues(AN.photoByDay), 'rgba(236,72,153,.6)')]
}, baseOpts());
/* Level distribution — horizontal bar */
makeChart('chart-leveldist','bar',{
labels: LEVEL_DIST.map(function(r){return 'Lv '+r.level;}),
datasets:[{label:'Players',data:LEVEL_DIST.map(function(r){return r.c;}),
backgroundColor:'rgba(168,85,247,.75)',borderRadius:3,borderSkipped:false}]
}, Object.assign(baseOpts(), {indexAxis:'y', plugins:Object.assign(baseOpts().plugins,{legend:{display:false}}),
scales:{x:{grid:{color:C.grid},ticks:{color:C.tick}},y:{grid:{display:false},ticks:{color:C.tick}}}}));
/* Gift rarity — doughnut */
var RNAMES = {0:'Common',1:'Uncommon',2:'Rare',3:'Epic',4:'Legendary',5:'Mythic'};
var RCOLORS = ['rgba(148,163,184,.85)','rgba(16,185,129,.85)','rgba(59,130,246,.85)','rgba(168,85,247,.85)','rgba(245,158,11,.85)','rgba(236,72,153,.9)'];
makeChart('chart-rarity','doughnut',{
labels: RARITY_DIST.map(function(r){return RNAMES[r.r]||'?';}),
datasets:[{data:RARITY_DIST.map(function(r){return r.c;}),backgroundColor:RARITY_DIST.map(function(r){return RCOLORS[r.r]||'#888';}),borderWidth:0,hoverOffset:4}]
}, {animation:false,responsive:true,maintainAspectRatio:false,cutout:'60%',
plugins:{legend:{display:true,position:'right',labels:{color:'#e2e8f0',boxWidth:10,padding:8,font:{size:10}}},
tooltip:{callbacks:{label:function(c){return ' '+c.label+': '+c.formattedValue;}}}
}});
/* Platform — doughnut */
var PCOLORS = ['rgba(59,130,246,.85)','rgba(16,185,129,.8)','rgba(168,85,247,.8)','rgba(245,158,11,.8)','rgba(236,72,153,.8)'];
makeChart('chart-platform','doughnut',{
labels: PLATFORM_BRK.map(function(r){return r.platform;}),
datasets:[{data:PLATFORM_BRK.map(function(r){return r.c;}),backgroundColor:PCOLORS,borderWidth:0,hoverOffset:4}]
}, {animation:false,responsive:true,maintainAspectRatio:false,cutout:'55%',
plugins:{legend:{display:true,position:'right',labels:{color:'#e2e8f0',boxWidth:10,padding:8,font:{size:10}}},
tooltip:{callbacks:{label:function(c){return ' '+c.label+': '+c.formattedValue;}}}
}});
/* Admin + bans */
var banBans=[],banUnbans=[],banLabels=[];
var banMap={},unbanMap={};
AN.bansByDay.forEach(function(r){if(r.action==='ban')banMap[r.d]=(banMap[r.d]||0)+r.c;else unbanMap[r.d]=(unbanMap[r.d]||0)+r.c;});
var banDates=Object.keys(Object.assign({},banMap,unbanMap)).sort();
banDates.forEach(function(d){banLabels.push(d);banBans.push(banMap[d]||0);banUnbans.push(unbanMap[d]||0);});
if(document.getElementById('chart-adminbans')){
var adminLabels=AN.adminByDay.map(function(r){return r.d;});
var adminVals=AN.adminByDay.map(function(r){return r.c;});
makeChart('chart-adminbans','bar',{
labels:adminLabels,
datasets:[
barDataset('Admin Actions',adminVals,'rgba(168,85,247,.45)'),
{label:'Bans',data:banLabels.map(function(d,i){return banBans[i];}),backgroundColor:'rgba(239,68,68,.7)',borderRadius:3,borderSkipped:false},
{label:'Unbans',data:banLabels.map(function(d,i){return banUnbans[i];}),backgroundColor:'rgba(16,185,129,.65)',borderRadius:3,borderSkipped:false},
]
}, Object.assign(baseOpts(),{plugins:Object.assign(baseOpts().plugins,{legend:{display:true,labels:{color:'#e2e8f0',boxWidth:10,padding:10}}})}));
}
}
/* ── Overview charts ── */
function buildOverviewCharts() {
makeChart('chart-evday','bar',{
labels: dcLabels(AN.eventsByDay),
datasets: [barDataset('Events', dcValues(AN.eventsByDay), 'rgba(168,85,247,.65)')]
}, baseOpts());
var hourOpts = baseOpts();
hourOpts.plugins.tooltip.callbacks.label = function(c){return ' '+c.formattedValue+' events at '+c.label+':00';};
makeChart('chart-evhour','bar',{
labels: AN.eventsByHour.map(function(r){return r.h+':00';}),
datasets: [barDataset('Events', AN.eventsByHour.map(function(r){return r.c;}), 'rgba(6,182,212,.65)')]
}, hourOpts);
if (!AN.countHistory.length) return;
var chLabels = AN.countHistory.map(function(h){return h.t.slice(11,16);});
var chOnline = AN.countHistory.map(function(h){return h.online;});
var chSess = AN.countHistory.map(function(h){return h.sessions;});
var pcOpts = baseOpts({min:0});
pcOpts.plugins.legend = {display:true,labels:{color:'#e2e8f0',boxWidth:10,padding:10}};
pcOpts.scales.x.ticks.maxTicksLimit = 12;
makeChart('chart-pchistory','line',{
labels: chLabels,
datasets:[
lineDataset('Online', chOnline, C.green, true, C.greenA),
{label:'Sessions',data:chSess,borderColor:'rgba(59,130,246,.55)',borderWidth:1.5,borderDash:[4,3],
backgroundColor:'transparent',fill:false,pointRadius:0,tension:0.3},
]
}, pcOpts);
}
/* ── Performance charts ── */
function buildPerformanceCharts() {
var acts = Object.keys(ACTIVITY_SUM);
if (!acts.length) return;
var fps = acts.map(function(a){return ACTIVITY_SUM[a].avg_fps||0;});
var ping = acts.map(function(a){return ACTIVITY_SUM[a].avg_ping||0;});
var fpsColors = fps.map(function(v){
return v>=90?'rgba(16,185,129,.8)':v>=60?'rgba(139,195,74,.8)':v>=30?'rgba(245,158,11,.8)':'rgba(239,68,68,.8)';
});
var pingColors = ping.map(function(v){
return v<=50?'rgba(16,185,129,.8)':v<=100?'rgba(139,195,74,.8)':v<=150?'rgba(245,158,11,.8)':'rgba(239,68,68,.8)';
});
var shortActs = acts.map(function(a){return a.length>12?a.slice(0,11)+'…':a;});
var bOpts = Object.assign(baseOpts(),{indexAxis:'y',plugins:Object.assign(baseOpts().plugins,{legend:{display:false}})});
bOpts.scales = {x:{grid:{color:C.grid},ticks:{color:C.tick}},y:{grid:{display:false},ticks:{color:C.tick}}};
makeChart('chart-fps','bar',{
labels:shortActs,
datasets:[{label:'Avg FPS',data:fps,backgroundColor:fpsColors,borderRadius:3,borderSkipped:false}]
}, bOpts);
var pOpts = JSON.parse(JSON.stringify(bOpts));
pOpts.scales = {x:{grid:{color:C.grid},ticks:{color:C.tick}},y:{grid:{display:false},ticks:{color:C.tick}}};
makeChart('chart-ping','bar',{
labels:shortActs,
datasets:[{label:'Avg Ping (ms)',data:ping,backgroundColor:pingColors,borderRadius:3,borderSkipped:false}]
}, pOpts);
}
/* ── Economy charts ── */
function buildEconomyCharts() {
if (AN.dailySpend.length) {
var spendOpts = baseOpts();
spendOpts.plugins.tooltip.callbacks.label = function(c){return ' '+parseInt(c.formattedValue.replace(/,/g,'')).toLocaleString()+' tokens';};
makeChart('chart-spend','bar',{
labels: dcLabels(AN.dailySpend),
datasets: [barDataset('Tokens Spent', dcValues(AN.dailySpend), 'rgba(245,158,11,.65)')]
}, spendOpts);
}
var itypes = Object.keys(TYPE_SPEND);
var ICOLORS = ['rgba(168,85,247,.85)','rgba(16,185,129,.85)','rgba(59,130,246,.85)','rgba(245,158,11,.85)','rgba(236,72,153,.85)','rgba(239,68,68,.85)'];
if (itypes.length) {
makeChart('chart-itype','doughnut',{
labels:itypes,datasets:[{data:itypes.map(function(k){return TYPE_SPEND[k];}),backgroundColor:ICOLORS,borderWidth:0,hoverOffset:4}]
},{animation:false,responsive:true,maintainAspectRatio:false,cutout:'55%',
plugins:{legend:{display:true,position:'right',labels:{color:'#e2e8f0',boxWidth:10,padding:7,font:{size:10}}},
tooltip:{callbacks:{label:function(c){return ' '+c.label+': '+c.formattedValue;}}}}});
}
var sfs = Object.keys(SF_COUNTS);
if (sfs.length) {
makeChart('chart-sf','doughnut',{
labels:sfs,datasets:[{data:sfs.map(function(k){return SF_COUNTS[k];}),backgroundColor:ICOLORS,borderWidth:0,hoverOffset:4}]
},{animation:false,responsive:true,maintainAspectRatio:false,cutout:'55%',
plugins:{legend:{display:true,position:'right',labels:{color:'#e2e8f0',boxWidth:10,padding:7,font:{size:10}}},
tooltip:{callbacks:{label:function(c){return ' '+c.label+': '+c.formattedValue;}}}}});
}
}
/* ── Update trend KPIs ── */
function updateTrends() {
renderTrend('kpi-t-players', AN.regByDay);
renderTrend('kpi-t-photos', AN.photoByDay);
renderTrend('kpi-t-chat', AN.chatByDay);
renderTrend('kpi-t-unlocked', AN.unlockedByDay);
renderTrend('kpi-t-gifts', AN.giftsByDay);
renderTrend('kpi-t-logins', AN.loginByDay);
renderTrend('kpi-t-visits', AN.visitByDay);
}
function computePeakCount() {
if (!AN.countHistory.length) return;
var peak = AN.countHistory.reduce(function(m,h){return Math.max(m,h.online);},0);
var el = document.getElementById('count-peak');
if (el) el.textContent = peak;
}
/* ── Range controls ── */
window.setRange = function(key, btn) {
document.querySelectorAll('.rng-btn').forEach(function(b){b.classList.remove('active');});
btn.classList.add('active');
var map = {'7d':7,'14d':14,'30d':30,'90d':90};
if (key === 'all') { rangeFrom=null; rangeTo=null; }
else { rangeFrom=daysAgo(map[key]); rangeTo=null; }
document.getElementById('range-from').value = rangeFrom||'';
document.getElementById('range-to').value = rangeTo||'';
updateLabel();
updateCharts();
};
window.setCustomRange = function() {
rangeFrom = document.getElementById('range-from').value || null;
rangeTo = document.getElementById('range-to').value || null;
document.querySelectorAll('.rng-btn').forEach(function(b){b.classList.remove('active');});
updateLabel();
updateCharts();
};
function updateLabel() {
var el = document.getElementById('range-label');
if (!el) return;
if (!rangeFrom && !rangeTo) el.textContent='All time';
else if (rangeFrom && !rangeTo) el.textContent='From '+rangeFrom;
else if (rangeFrom && rangeTo) el.textContent=rangeFrom+' → '+rangeTo;
}
/* ── Tab switching ── */
window.showTab = function(id, btn) {
document.querySelectorAll('.an-panel').forEach(function(p){p.style.display='none';});
document.querySelectorAll('.an-tab').forEach(function(b){b.classList.remove('active');});
document.getElementById('tab-'+id).style.display='';
btn.classList.add('active');
activeTab = id;
if (id === 'performance') buildPerformanceCharts();
if (id === 'economy') buildEconomyCharts();
updateURL();
};
/* ── Series toggle ── */
window.toggleSeries = function(chartId, idx) {
var c = charts[chartId];
if (!c) return;
var meta = c.getDatasetMeta(idx);
meta.hidden = !meta.hidden;
c.update();
};
/* ── Download chart as PNG ── */
window.downloadChart = function(chartId, name) {
var c = charts[chartId];
if (!c) { alert('Chart not found. Switch to its tab first.'); return; }
var a = document.createElement('a');
a.href = c.toBase64Image('image/png', 1);
a.download = (name||chartId)+'.png';
a.click();
};
window.exportPNG = function() {
var cid = 'chart-cumreg';
if (activeTab==='overview') cid='chart-evday';
if (activeTab==='economy') cid='chart-spend';
downloadChart(cid, activeTab+'_chart');
};
/* ── PNG btn tracks active chart ── */
window.downloadChart = function(chartId, name) {
var c = charts[chartId];
if (!c) { alert('Chart not rendered — click its tab first.'); return; }
var a = document.createElement('a');
a.href = c.toBase64Image('image/png', 1);
a.download = (name||chartId)+'.png';
a.click();
};
/* ── CSV export helpers ── */
function escCSV(v) {
v = String(v==null?'':v);
if (v.indexOf(',')!==-1||v.indexOf('"')!==-1||v.indexOf('\n')!==-1) return '"'+v.replace(/"/g,'""')+'"';
return v;
}
function downloadCSV(rows, filename) {
var csv = rows.map(function(r){return r.map(escCSV).join(',');}).join('\n');
var b = new Blob([csv], {type:'text/csv'});
var a = document.createElement('a');
a.href = URL.createObjectURL(b);
a.download = filename+'.csv';
a.click();
}
window.exportSeriesCSV = function(arr, header, dField, valFields) {
dField = dField||'d'; valFields = valFields ? valFields.split(',') : ['c'];
var heads = header.split(',');
var rows = [heads];
arr.forEach(function(r){ rows.push([r[dField]].concat(valFields.map(function(f){return r[f];}))); });
downloadCSV(rows, header.split(',')[0]||'data');
};
window.exportTableCSV = function(tbodyId, name) {
var tbody = document.getElementById(tbodyId);
if (!tbody) return;
var rows = [];
var thead = tbody.closest('table').querySelector('thead');
if (thead) rows.push(Array.from(thead.querySelectorAll('th')).map(function(th){return th.textContent.trim();}));
tbody.querySelectorAll('tr').forEach(function(tr){
if (tr.style.display==='none') return;
rows.push(Array.from(tr.querySelectorAll('td')).map(function(td){return td.textContent.trim();}));
});
downloadCSV(rows, name||'export');
};
window.exportCSV = function() {
var arrMap = {
growth: AN.regByDay, overview: AN.eventsByDay,
economy: AN.dailySpend, performance: null, social: null, raw: null
};
var arr = arrMap[activeTab];
if (arr) { exportSeriesCSV(arr, activeTab+'_data'); return; }
var tbodies = {performance:'act-tbody', social:'tbl-crashes', raw:'raw-tbody'};
var tbid = tbodies[activeTab];
if (tbid) exportTableCSV(tbid, activeTab+'_data');
};
/* ── Share link ── */
window.shareLink = function() {
var p = new URLSearchParams();
p.set('tab', activeTab);
if (rangeFrom) p.set('from', rangeFrom);
if (rangeTo) p.set('to', rangeTo);
var url = window.location.pathname+'?'+p.toString();
navigator.clipboard.writeText(window.location.origin+url).then(function(){
var t = document.getElementById('copy-toast');
t.classList.add('show');
setTimeout(function(){t.classList.remove('show');}, 2200);
}).catch(function(){prompt('Copy this link:', window.location.origin+url);});
};
/* ── Persist tab/range in URL ── */
function updateURL() {
var p = new URLSearchParams();
p.set('tab', activeTab);
if (rangeFrom) p.set('from', rangeFrom);
if (rangeTo) p.set('to', rangeTo);
history.replaceState(null,'',window.location.pathname+'?'+p.toString());
}
/* ── Table filter ── */
window.filterRows = function(tbodyId, q) {
var lq=q.toLowerCase();
document.getElementById(tbodyId).querySelectorAll('tr').forEach(function(r){
r.style.display=(lq===''||r.textContent.toLowerCase().indexOf(lq)!==-1)?'':'none';
});
};
window.rawFilter = function() {
var q=document.getElementById('raw-q').value.toLowerCase();
var type=document.getElementById('raw-type').value;
var vis=0;
document.getElementById('raw-tbody').querySelectorAll('tr').forEach(function(r){
var show=(type===''||r.dataset.type===type)&&(q===''||r.textContent.toLowerCase().indexOf(q)!==-1);
r.style.display=show?'':'none';
if(show)vis++;
});
document.getElementById('raw-count').textContent=vis+' rows';
};
/* ── Sortable tables ── */
window.sortTable = function(th) {
var table = th.closest('table');
var tbody = table.querySelector('tbody');
var idx = Array.from(th.parentElement.children).indexOf(th);
var asc = th.classList.contains('sorted-asc') ? false : true;
table.querySelectorAll('th').forEach(function(h){h.classList.remove('sorted-asc','sorted-desc');});
th.classList.add(asc?'sorted-asc':'sorted-desc');
var rows = Array.from(tbody.querySelectorAll('tr'));
rows.sort(function(a,b){
var av=(a.children[idx]||{}).textContent||'';
var bv=(b.children[idx]||{}).textContent||'';
var an=parseFloat(av.replace(/[^0-9.\-]/g,'')),bn=parseFloat(bv.replace(/[^0-9.\-]/g,''));
if(!isNaN(an)&&!isNaN(bn)) return asc?an-bn:bn-an;
return asc?av.localeCompare(bv):bv.localeCompare(av);
});
rows.forEach(function(r){tbody.appendChild(r);});
};
/* ── Init from URL params ── */
(function() {
var p = new URLSearchParams(window.location.search);
var tab = p.get('tab');
var from = p.get('from');
var to = p.get('to');
if (from) { rangeFrom=from; document.getElementById('range-from').value=from; }
if (to) { rangeTo=to; document.getElementById('range-to').value=to; }
if (from||to) {
document.querySelectorAll('.rng-btn').forEach(function(b){b.classList.remove('active');});
updateLabel();
}
if (tab && tab!=='growth') {
var btn = document.getElementById('tab-btn-'+tab);
if (btn) showTab(tab, btn);
}
})();
/* ── Boot ── */
buildCharts();
})();
</script>
{% endblock %}