<h2 style="text-align: center;">{{ num_active_sites }} active sites</h2>

<p id="utctime" style="text-align: center;"></p>
<p id="localtime" style="text-align: center;"></p>
<script type="text/javascript">
    var now = moment('{{ now }}');
    $('#utctime')[0].innerHTML = moment.utc(now).format('YYYY-MM-DD HH:mm') + 'Z';
    $('#localtime')[0].innerHTML = '(' + now.format('YYYY-MM-DD HH:mm ZZ') + ')';
    $(document).ready(function() {
        $('a.envelope-link').click(function() {
            var temp = $(document.createElement('input'));
            $("body").append(temp);
            temp.val($(this).data("value")).select();
            document.execCommand("copy");
            temp.remove();
            $(this).fadeOut(250);
            $(this).fadeIn(1000);
        });
    });
</script>

<ul>
    <li><strong>active (site)</strong> - has ≥5 DAUs</li>
    <li>sites are listed if ≥1 users active in last 2 weeks</li>
    <li><strong>user</strong> - registered user, not deactivated, not a bot</li>
    <li><strong>active (user)</strong> - sent a message, or advanced the pointer (reading messages doesn't count unless advances the pointer)</li>
    <li><strong><th><i class="fa fa-envelope"></i></th></strong> - copies realm admin emails to clipboard</li>
    <li><strong>DAU</strong> (Daily Active Users) - users active in last 24hr</li>
    <li><strong>WAU</strong> (Weekly Active Users) - users active in last 7 * 24hr</li>
    <li><strong>DAT</strong> (Daily Active Time) - total user-activity time in last 24hr</li>
    <li><strong>Human message</strong> - message sent by non-bot user, and not with known-bot client</li>
</ul>

<table class="table summary-table sortable table-striped table-bordered">

    <thead class="activity_head">
        <tr>
            <th>Realm</th>
            <th>Created (green if ≤12wk)</th>
            <th><i class="fa fa-envelope"></i></th>
            <th>DAU</th>
            <th>WAU</th>
            <th>Total users</th>
            <th>Bots</th>
            <th>DAT/DAU (hr)</th>
            <th>DAT (hr)</th>
            <th></th>
            <th colspan=8>Human messages sent, last 8 UTC days (today-so-far first)</th>
        </tr>
    </thead>

    <tbody>
        {% for row in rows %}
        <tr>

            <td>
                {{ row.string_id }}
            </td>

            <td {% if row.is_new %}
                class="good" {% else %}
                class="neutral" {% endif %} >
                {{ row.date_created_day }}
            </td>

            <td class="envelope">
                {% if not loop.last %}
                <a class="envelope-link" data-value="{{ row.realm_admin_email }}">
                    <i class="fa fa-envelope"></i>
                </a>
                {% endif %}
            </td>

            <td class="number">
                {{ row.dau_count }}
            </td>

            <td class="number">
                {{ row.wau_count }}
            </td>

            <td class="number">
                {{ row.user_profile_count }}
            </td>

            <td class="number">
                {{ row.bot_count }}
            </td>

            <td class="number">
                {% if row.hours_per_user %}
                {{ row.hours_per_user }}
                {% endif %}
            </td>

            <td class="number">
                {{ row.hours }}
            </td>

            <td>&nbsp;</td>

            {% if row.history %}
            {{ row.history|safe }}
            {% else %}
            <td colspan=8></td>
            {% endif %}
        </tr>
        {% endfor %}
    </tbody>

</table>
