{% 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] }}