{% extends "template.html" %} {% block body %}

{{ _('Stats') }}

{% macro show_result(result, caption, first, second) %} {% for row in result %} {% endfor %}
{{ caption|e }}
{{ first|e }} {{ second|e }}
{{ row[0]|e }} {{ row[1]|e }}
{% endmacro %} {% if 'A' in PERMS %} {% set cond_cmd = "" %} {% set cond_string = "" %} {% set cond_array = [] %} {% else %} {% set cond_cmd = "WHERE" %} {% set cond_string = "recipient=%s" %} {% set cond_array = [REMOTE_USER] %} {% endif %} {% set total=DB.query("SELECT count(1), virname FROM log " + cond_cmd + " " + cond_string + " GROUP BY virname ORDER BY 1 DESC LIMIT 100", cond_array) %} {% set by_ip=DB.query("SELECT count(1),ip FROM log " + cond_cmd + " " + cond_string + " GROUP BY ip ORDER BY 1 DESC LIMIT 10", cond_array) %} {{show_result(total, _('Top 100 by virus name'), _('Count'), _('Virus name'))}}
{% if 'A' in PERMS %} {% set recipients = DB.query("SELECT count(1),recipient FROM log " + "GROUP BY recipient ORDER BY 1 DESC LIMIT 100") %} {{show_result(recipients, _('Top 100 by recipient'), _('Count'), _('Recipient'))}}
{% endif %} {{show_result(by_ip, _('Top 10 by IP address'), _('Count'), _('Sender IP address'))}}
{% set first_entry = DB.query("SELECT datetime FROM log ORDER BY 1 LIMIT 1") %} {% set last_entry = DB.query("SELECT datetime FROM log ORDER BY 1 DESC LIMIT 1") %} {{ _('First entry: %s') % first_entry[0] }}
{{ _('Last entry: %s') % last_entry[0] }}
{% endblock %}