{% extends 'wfbo/_layout.html.twig' %} {% macro tier_label(t) %}{{ t == 'try_again' ? 'BALIK TAYA' : t|upper }}{% endmacro %} {% block title %}Royale King 999 Results — WFBO{% endblock %} {% block wfbo_title %}Royale King 999 Results{% endblock %} {% block wfbo_content %} {% import _self as l9 %} {% set presets = [ {key: 'this_month', label: 'This Month'}, {key: 'last_month', label: 'Last Month'}, {key: 'this_year', label: 'This Year'}, {key: 'last_year', label: 'Last Year'}, ] %}
{% for p in presets %} {{ p.label }} {% endfor %}

Total Spins

{{ overall.total }}

Total Won

{{ overall.wins }}

Losses: {{ overall.losses }} · Balik Taya: {{ overall.try_again }}

Net Revenue

₱{{ overall.revenue|number_format(2) }}

Bets: ₱{{ overall.bet_amount|number_format(2) }} · Won: ₱{{ overall.win_amount|number_format(2) }}

Payout Rate

{{ overall.payout_rate|number_format(2) }}%

Revenue Rate: {{ overall.bet_amount > 0 ? ((overall.revenue / overall.bet_amount) * 100)|number_format(2) : '0.00' }}%

{% if byTier is not empty %}
{% for row in byTier %} {% set winPct = row.total > 0 ? ((row.wins / row.total) * 100)|number_format(1) : '0.0' %} {% endfor %}
Tier Spins Wins Losses Win % Bet Amount Win Amount Revenue
{{ l9.tier_label(row.tier) }} {{ row.total }} {{ row.wins }} {{ row.losses }} {{ winPct }}% ₱{{ row.bet_amount|number_format(2) }} ₱{{ row.win_amount|number_format(2) }} ₱{{ row.revenue|number_format(2) }}
{% endif %}
Filter by tier: All {% for t in tierFilters %} {{ l9.tier_label(t) }} {% endfor %}
{% for bet in bets %} {% else %} {% endfor %}
Time Player Reels Tier Amount Payout Status

{{ bet.created_at|date('M d, Y') }}

{{ bet.created_at|date('h:i A') }}

{% if is_granted('ROLE_ADMIN') %} {{ bet.first_name }} {{ bet.last_name }} {% else %} {{ bet.first_name }} {{ bet.last_name }} {% endif %}

{{ bet.mobile_number }}

{% set reels = bet.reels|json_decode %} {% if reels is iterable %}{{ reels|join(' ') }}{% endif %} {{ bet.tier is not null ? l9.tier_label(bet.tier) : 'LOSS' }} ₱{{ bet.amount|number_format(2) }} {% if bet.payout > 0 %}₱{{ bet.payout|number_format(2) }}{% else %}—{% endif %} {% if bet.status == 'won' %} Won {% elseif bet.status == 'void' %} Balik Taya {% else %} Lost {% endif %}
No bets found for this period.
{% if totalPages > 1 %}

Page {{ currentPage }} of {{ totalPages }} ({{ total }} total)

{% if currentPage > 1 %} Previous {% endif %} {% if currentPage < totalPages %} Next {% endif %}
{% endif %} {% endblock %}