{% set client = '-1' %} {% set assignment = '-1' %} {% set team = '-1' %} {% set total_client = 0 %} {% set total_assignment = 0 %} {% set total_team = 0 %} {% for row in results %} {% set new_client = false %} {% set new_assignment = false %} {% set new_team = false %} {% if (client != row['client']) %} {% set new_client = true %} {% set new_assignment = true %} {% set new_team = true %} {% elseif (assignment != row['assignment']) %} {% set new_assignment = true %} {% set new_team = true %} {# elseif (team != row['team']) #} {# set new_team = true #} {% endif %} {% if ((team != '-1') and new_team) %} {% endif %} {% if ((assignment != '-1') and new_assignment) %} {% endif %} {% if ((client != '-1') and new_client) %} {% endif %} {% if new_client %} {% set client = row['client'] %} {% set total_client = 0 %} {% endif %} {% if new_assignment %} {% set assignment = row['assignment'] %} {% set total_assignment = 0 %} {% endif %} {% if new_team %} {#{% set team = row['team'] %}#} {% set total_team = 0 %} {% endif %} {% if new_client %} {% endif %} {% if new_assignment %} {% endif %} {#{% if new_team %}#} {##} {##} {##} {##} {##} {#{% endif %}#} {% set total_team = total_team + row['hours'] %} {% set total_assignment = total_assignment + row['hours'] %} {% set total_client = total_client + row['hours'] %} {% endfor %} {% if (team != '-1') %} {% endif %} {% if (assignment != '-1') %} {% endif %} {% if (client != '-1') %} {% endif %}
Client Assignment User Date Hours Task Notes
Total for Team {{ team }}: {{ total_team }} hours.
Total for Assignment {{ assignment }}: {{ total_assignment }} hours.
Total for Client {{ client }}: {{ total_client }} hours.
Client {{ client }}
Assignment {{ assignment }}
Team {{ team }}
{{ row['client'] }} {{ row['assignment'] }} {{ row['firstName'] }} {{ row['lastName'] }} ({{ row['username'] }}) {{ row['date'] | date('d/m/Y') }} {{ row['hours'] }} {{ row['task'] }} {{ row['notes'] }}
Total for Team {{ team }}: {{ total_team }} hours.
Total for Assignment {{ assignment }}: {{ total_assignment }} hours.
Total for Client {{ client }}: {{ total_client }} hours.
{{ knp_pagination_render(results) }}