{% set team = '-1' %} {% set username = '-1' %} {% set fullname = '' %} {% set total_user = 0 %} {% set total_team = 0 %} {% for row in results %} {% set new_team = false %} {% set new_user = false %} {#{% if team != row['team'] %}#} {#{% set new_team = true %}#} {#{% set new_user = true %}#} {% if username != row['username'] %} {% set new_user = true %} {% endif %} {% if ((username != '-1') and new_user) %} {% endif %} {% if ((team != '-1') and new_team) %} {% endif %} {% if new_team %} {% set team = row['team'] %} {% set total_team = 0 %} {% endif %} {% if new_user %} {% set username = row['username'] %} {% set fullname = row['firstName'] ~ ' ' ~ row['lastName'] %} {% set total_user = 0 %} {% endif %} {% if new_team %} {% endif %} {% if new_user %} {% endif %} {##} {% set total_user = total_user + row['hours'] %} {% set total_team = total_team + row['hours'] %} {% endfor %} {% if (username != '-1') %} {% endif %} {% if (team != '-1') %} {% endif %}

Assignment	User	Date	Hours	Task	Notes
	Total for User {{ fullname }} ({{ username }}): {{ total_user }} hours.
Total for Team {{ team }}: {{ total_team }} hours.
{{ row['team'] }}
	{{ fullname }} ({{ username }})
{{ team }}	{{ row['assignment'] }}	{{ fullname }} ({{ username }})	{{ row['date'] \| date('d/m/Y') }}	{{ row['hours'] }}	{{ row['task'] }}	{{ row['notes'] }}
	Total {{ fullname }}({{ username }}): {{ total_user }} hours.
Total for Team {{ team }}: {{ total_team }} hours.