twigfiddle.com - Fiddle xovsv8 v6 - Created on March 22, 2019 17:01

File

{% spaceless %}

{% set perPaymentMethodExpenses = [] %}

{% for report in export.reports %}
     
    {# Group expenses per payment method and sum their value #} 
    {% set paymentMethodRecords = [] %}
    {% for expense in report.bills %}
        
        {# Set group key and default record #}
        {% set key = '_'~expense.paymentMethod.id|default('') %}
        {% set record = paymentMethodRecords[key]|default({
            paymentMethod: expense.paymentMethod,
            expenses: [],
            report: report,
            value: 0
        }) %}
        
        {# Add expense to group record and add up value #}
        {% set record = record|merge({
            'expenses': record['expenses']|merge([ expense ]),
            'value': record['value'] + expense.value
        }) %}

        {% set paymentMethodRecords = paymentMethodRecords|merge({ (key): record }) %}
    {% endfor %}
    
    {% for key, data in paymentMethodRecords %}
        {# do something with data.paymentMethod, data.expenses or data.value #}
    {% endfor %}
{% endfor %}
{% endspaceless %}

Format

export:
    reports:
        - id: 1
          name: 'Januari'
          user:
              id: 1
              code: 'A100'
              fullName: 'Jack Doe'
              email: 'jack@company.com'
          bills:
              - id: 1
                description: 'Lunch Kirsten'
                amount: 12.10
                value: 12.10
                currency: 'EUR'
                distance: 0
                number: 0
                paymentMethod:
                    id: 3
                    code: 'D'
                category:
                    id: 1
                    name: 'Lunch'
                    code: '0100'
                billVats:
                    - id: 1
                      baseAmount: 10.00
                      baseValue: 10.00
                      amount: 2.10
                      value: 2.10
                      vat:
                          id: 1
                          percentage: 21
                          code: H
              - id: 2
                description: 'Paperclips'
                amount: 24.20
                value: 24.20
                currency: 'EUR'
                distance: 0
                number: 0
                paymentMethod:
                    id: 3
                    code: 'D'
                category:
                    id: 2
                    name: 'Office'
                    code: '0200'
                billVats:
                    - id: 1
                      baseAmount: 20.00
                      baseValue: 20.00
                      amount: 4.20
                      value: 4.20
                      vat:
                          id: 1
                          percentage: 21
                          code: H
        - id: 2
          name: 'Januari'
          user:
              id: 2
              code: 'B200'
              fullName: 'Mary Mo'
              email: 'mary@company.com'
          bills:
              - id: 3
                description: 'Lunch Peter'
                amount: 5.05
                value: 5.05
                currency: 'EUR'
                distance: 0
                number: 0
                paymentMethod:
                    id: 3
                    code: 'D'
                category:
                    id: 1
                    name: 'Lunch'
                    code: '0100'
                billVats:
                    - id: 1
                      baseAmount: 5.00
                      baseValue: 5.00
                      amount: 0.50
                      value: 0.50
                      vat:
                          id: 1
                          percentage: 21
                          code: H
              - id: 4
                description: 'Etentje'
                amount: 18.15
                value: 18.15
                currency: 'EUR'
                distance: 0
                number: 0
                paymentMethod:
                    id: 3
                    code: 'D'
                category:
                    id: 1
                    name: 'Lunch'
                    code: '0100'
                billVats:
                    - id: 1
                      baseAmount: 15.00
                      baseValue: 15.00
                      amount: 3.15
                      value: 3.15
                      vat:
                          id: 1
                          percentage: 21
                          code: H