twigfiddle.com - Fiddle lohde6 v4 - Created on March 31, 2020 17:27

More options...

Title

File

{% set reportRecords = reportRecords|reduce(
    (rv, x) => rv|default({})|merge({
    ('_'~x['AX']): {
        'records': rv['_'~x['AX']]['records']|default([])|merge([x])
    }
})
    ) %}

{% set ediLineNumberReport = 0 %}
{% for vatId, reportRecord in reportRecords %}
    {% set ediLineNumberReport = ediLineNumberReport + 1000 %}
    {% for i, record in reportRecord['records'] %}
        {% set reportRecords = reportRecords|merge({
            (vatId): {
                'records': {
                    (i): reportRecords[vatId]['records'][i]|merge({
                        'G': ediLineNumberReport
                    })
                }
            }
        }) %}
    {% endfor %}
{% endfor %}

{% set reportColumns = ['AX'] %}

{% autoescape false %}
    {%- for vatId, reportRecord in reportRecords %}
    {%- for record in reportRecord['records'] %}
        {%- for column in reportColumns %}

            {{~ '"'~record[column]|default(' ')~'"' }}{% if not loop.last %},{% endif %}
        {%- endfor %}
    {%- endfor %}
    {%~ endfor %}
{% endautoescape %}

Format

{

  "reportRecords": [
    {
      "id": 1,
      "AX": "NL0"
    },
    {
      "id": 2,
      "AX": "NL0"
    },
    {
      "id": 3,
      "AX": "NLA"
    },
    {
      "id": 4,
      "AX": "NLB"
    },
    {
      "id": 5,
      "AX": "NLA"
    }
  ]
}

Fiddle lohde6 v4 created on March 31, 2020 17:27 and visited 10 times

Developed using

Not logged in.

twigfiddle.com @ 2024
Ask a question on Stackoverflow Report issue Download source code