{% extends "base.html" %}
{% block title %}
    Debug
{% endblock title %}
{% block content %}
    <h1>Debug</h1>
    <p>
        Generated at: <time datetime="{{ now|date:'c' }}"
       title="{{ now|date:'DATETIME_FORMAT' }}">{{ now }}</time>
    </p>
    <section>
        <h2>Distinct GraphQL operation_names ({{ operation_names_with_counts|length }})</h2>
        {% if operation_names_with_counts %}
            <table id="operation-names-table">
                <thead>
                    <tr>
                        <th>Operation Name</th>
                        <th>Count</th>
                    </tr>
                </thead>
                <tbody>
                    {% for item in operation_names_with_counts %}
                        <tr>
                            <td>{{ item.trimmed_op }}</td>
                            <td>{{ item.count }}</td>
                        </tr>
                    {% endfor %}
                </tbody>
            </table>
        {% endif %}
    </section>
    <section>
        <h2>Games Without an Assigned Owner ({{ games_without_owner|length }})</h2>
        {% if games_without_owner %}
            <ul>
                {% for game in games_without_owner %}
                    <li>
                        <a href="{% url 'twitch:game_detail' game.twitch_id %}">{{ game.display_name }}</a> (ID: {{ game.twitch_id }})
                    </li>
                {% endfor %}
            </ul>
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Campaigns without Images ({{ broken_image_campaigns|length }})</h2>
        {% if broken_image_campaigns %}
            <ul>
                {% for c in broken_image_campaigns %}
                    <li>
                        <a href="{% url 'twitch:campaign_detail' c.twitch_id %}">{{ c.name }}</a>
                        (Game: <a href="{% url 'twitch:game_detail' c.game.twitch_id %}">{{ c.game.display_name }}</a>)
                    </li>
                {% endfor %}
            </ul>
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Benefits without image URLs ({{ broken_benefit_images|length }})</h2>
        {% if broken_benefit_images %}
            <ul>
                {% for b in broken_benefit_images %}
                    {% with first_drop=b.drops.all.0 %}
                        <li>
                            {{ b.name }}
                            {% if first_drop and first_drop.campaign and first_drop.campaign.game %}
                                (Game: <a href="{% url 'twitch:game_detail' first_drop.campaign.game.twitch_id %}">{{ first_drop.campaign.game.display_name }}</a>)
                            {% else %}
                                (Game: Not linked)
                            {% endif %}
                            - URL: {{ b.image_best_url|default:b.image_asset_url|default:'(empty)' }}
                        </li>
                    {% endwith %}
                {% endfor %}
            </ul>
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Active Campaigns without Images ({{ active_missing_image|length }})</h2>
        {% if active_missing_image %}
            <ul>
                {% for c in active_missing_image %}
                    <li>
                        <a href="{% url 'twitch:campaign_detail' c.twitch_id %}">{{ c.name }}</a>
                        (Game: <a href="{% url 'twitch:game_detail' c.game.twitch_id %}">{{ c.game.display_name }}</a>)
                    </li>
                {% endfor %}
            </ul>
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Time-Based Drops Without Benefits ({{ drops_without_benefits|length }})</h2>
        {% if drops_without_benefits %}
            <ul>
                {% for d in drops_without_benefits %}
                    <li>
                        {{ d.name }}
                        (Campaign: <a href="{% url 'twitch:campaign_detail' d.campaign.twitch_id %}">{{ d.campaign.name }}</a>
                        in Game: <a href="{% url 'twitch:game_detail' d.campaign.game.twitch_id %}">{{ d.campaign.game.display_name }}</a>)
                    </li>
                {% endfor %}
            </ul>
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Campaigns With Invalid Dates ({{ invalid_date_campaigns|length }})</h2>
        {% if invalid_date_campaigns %}
            <ul>
                {% for c in invalid_date_campaigns %}
                    <li>
                        <a href="{% url 'twitch:campaign_detail' c.twitch_id %}">{{ c.name }}</a>
                        (Game: <a href="{% url 'twitch:game_detail' c.game.twitch_id %}">{{ c.game.display_name }}</a>)
                        - Start: {{ c.start_at|default:'(none)' }} / End: {{ c.end_at|default:'(none)' }}
                    </li>
                {% endfor %}
            </ul>
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Duplicate Campaign Names Per Game ({{ duplicate_name_campaigns|length }})</h2>
        {% if duplicate_name_campaigns %}
            <table>
                <thead>
                    <tr>
                        <th>Game</th>
                        <th>Campaign Name</th>
                        <th>Count</th>
                    </tr>
                </thead>
                <tbody>
                    {% for row in duplicate_name_campaigns %}
                        <tr>
                            <td>
                                <a href="{% url 'twitch:game_detail' row.game__twitch_id %}">{{ row.game__display_name }}</a>
                            </td>
                            <td>{{ row.name }}</td>
                            <td>{{ row.name_count }}</td>
                        </tr>
                    {% endfor %}
                </tbody>
            </table>
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Campaigns Missing DropCampaignDetails ({{ campaigns_missing_dropcampaigndetails|length }})</h2>
        {% if campaigns_missing_dropcampaigndetails %}
            <ul>
                {% for c in campaigns_missing_dropcampaigndetails %}
                    <li>
                        <a href="{% url 'twitch:campaign_detail' c.twitch_id %}">{{ c.name }}</a>
                        (Game: <a href="{% url 'twitch:game_detail' c.game.twitch_id %}">{{ c.game.display_name }}</a>)
                        - Operations: {{ c.operation_names|join:", "|default:'(none)' }}
                    </li>
                {% endfor %}
            </ul>
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Data Source Diff — Drop Campaigns</h2>
        <p>Comparing campaigns by <code>data_source</code> field in the DB.</p>
        <h3>Only in SunkwiBOT/twitch-drops-api ({{ sunkibot_only_drops_count }})</h3>
        {% if sunkibot_only_drops %}
            <ul>
                {% for c in sunkibot_only_drops %}
                    <li>
                        <a href="{% url 'twitch:campaign_detail' c.twitch_id %}">{{ c.name }}</a>
                        (Game: <a href="{% url 'twitch:game_detail' c.game.twitch_id %}">{{ c.game.display_name }}</a>)
                    </li>
                {% endfor %}
            </ul>
            {% if sunkibot_only_drops_count > 200 %}
                <p><em>… and {{ sunkibot_only_drops_count|add:"-200" }} more (showing first 200)</em></p>
            {% endif %}
        {% else %}
            <p>None ✅</p>
        {% endif %}
        <h3>Only in TwitchDropsMiner ({{ miner_only_drops_count }})</h3>
        {% if miner_only_drops %}
            <ul>
                {% for c in miner_only_drops %}
                    <li>
                        <a href="{% url 'twitch:campaign_detail' c.twitch_id %}">{{ c.name }}</a>
                        (Game: <a href="{% url 'twitch:game_detail' c.game.twitch_id %}">{{ c.game.display_name }}</a>)
                    </li>
                {% endfor %}
            </ul>
            {% if miner_only_drops_count > 200 %}
                <p><em>… and {{ miner_only_drops_count|add:"-200" }} more (showing first 200)</em></p>
            {% endif %}
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
    <section>
        <h2>Data Source Diff — Reward Campaigns</h2>
        <h3>Only in SunkwiBOT/twitch-drops-api ({{ sunkibot_only_rewards_count }})</h3>
        {% if sunkibot_only_rewards %}
            <ul>
                {% for c in sunkibot_only_rewards %}
                    <li>
                        <a href="{% url 'twitch:reward_campaign_detail' c.twitch_id %}">{{ c.name }}</a>
                    </li>
                {% endfor %}
            </ul>
            {% if sunkibot_only_rewards_count > 200 %}
                <p><em>… and {{ sunkibot_only_rewards_count|add:"-200" }} more (showing first 200)</em></p>
            {% endif %}
        {% else %}
            <p>None ✅</p>
        {% endif %}
        <h3>Only in TwitchDropsMiner ({{ miner_only_rewards_count }})</h3>
        {% if miner_only_rewards %}
            <ul>
                {% for c in miner_only_rewards %}
                    <li>
                        <a href="{% url 'twitch:reward_campaign_detail' c.twitch_id %}">{{ c.name }}</a>
                    </li>
                {% endfor %}
            </ul>
            {% if miner_only_rewards_count > 200 %}
                <p><em>… and {{ miner_only_rewards_count|add:"-200" }} more (showing first 200)</em></p>
            {% endif %}
        {% else %}
            <p>None ✅</p>
        {% endif %}
    </section>
{% endblock content %}