twigfiddle.com - Fiddle 44bq4a v3 - Created on November 7, 2019 18:10

File

{% set codes = [] %}
            {% set deliveries = [] %}
            {% set nursing = [] %}
            {% set products = [] %}
            {% set newArray = [] %}
            {% set testArray = [] %}
            
{% for item in lineItems %}
    {% set group2Code = item.extrinsics['Key'] is defined ? item.extrinsics['Key'] : "" %}
       {% set testArray = testArray|merge(
           {
                   (item.clientProductCode) : {
                      'key': (group2Code),
                      'desc': (item.descriptions.0),
                      'qty': (item.quantity),
                      'unit': (item.unitStandardCostNet),
                      'vat': (item.VATCode),
                      'costNet': (item.costNet),
                      'clientProductCode':(item.extrinsics['itemNo'])
                    }
                 }
       ) %}
            
         
{% endfor %}


{% for item in testArray %}   
    {% set group2Code = item.key %}
          {% if group2Code matches '/^B/' %}

              {% set newArray = newArray|merge(
                        {
                            (item.clientProductCode) : {
                                'key': (item.key),
                                'desc': (item.desc),
                                'qty': (item.qty),
                                'unit': (item.unit),
                                'vat': (item.vat),
                                'costNet': (item.costNet),
                                'clientProductCode':(item.clientProductCode)
                            }
                        }
                    ) %}
               
          {% elseif group2Code matches '/^A/' %}
              {% set nursing = nursing|merge(
                        {
                            (item.clientProductCode) : {
                                'key': (item.key),
                                'desc': (item.desc),
                                'qty': (item.qty),
                                'unit': (item.unit),
                                'vat': (item.vat),
                                'costNet': (item.costNet),
                                'clientProductCode':(item.clientProductCode)
                            }
                        }
                    ) %}
          {% endif %}  
        
        
{% endfor %}

Components
{% for j in newArray %}
{{ j.key }}
{% endfor %}

Nursing
{% for k in nursing %}
{{ k.key }}
{% endfor %}

Format

{
    "totalNet": "73.76",
    "totalVAT": "12.85",
    "totalGross": "91.67",
    "documentDate": "01\/01\/2019",
    "contactName": "Manfred Andreas2",
    "contactJobTitle": "Structural Analysis Engineer2",
    "faxNo": "690-183-5976",
    "telNo": "941-163-4104",
    "contactEmailAddress": "mandreas_new0@clickbank.net",
    "documentNumber": "28617184D-806-1",
    "orderDate": "18\/01\/2017",
    "customerOrderNumber": "58232-0717",
    "clientOrderNumber": "0065-0341",
    "taxPointDate": "20\/01\/2017",
    "deliveryAddress": {
        "address_line_1": "9 Buhler Drive",
        "address_line_2": "73 Erie Trail",
        "address_line_3": "8 Southridge Street",
        "address_line_4": "39352 Anthes Junction",
        "post_code": "39-410",
        "addressName": "dolor",
        "addressee_name": "Tawnya Mc Combe",
        "town": "Tuamese",
        "region": "Hamberang Sabrang",
        "country": "Indonesia",
        "telephone": "440-246-8766",
        "fax": "809-357-5330",
        "clientReference": "0430-6201",
        "customerReference": "50950-002",
        "vatRegNo": "0078-0614",
        "thirdPartyReference": "61520-001",
        "addresseeName": "Tawnya Mc Combe",
        "addCountryISO": "GBR",
        "addLanguage": "EN",
        "addressType": "DOC_TO"
    },
    "billingAddress": [],
    "lineItems": [
        {
            "clientProductCode": "63629-000",
            "descriptions": [
                "commodo placerat"
            ],
            "extraCharges": {
                "41167-4266": {
                    "valueNet": "37.94",
                    "valueVAT": "17.49",
                    "valueGross": "85.89",
                    "VATCode": "GB350983637",
                    "VATPercentage": "75.21",
                    "currency": "GBP"
                }
            },
            "extrinsics": {
                "packingList": "1582624",
                "routeCode": "REPAIR",
                "warehouse": "01",
                "Key":"AA123",
                "itemNo":"1999"
            },
            "unitOfMeasure": "pound",
            "quantity": "83.24",
            "unitStandardCostNet": "11.39",
            "costNet": "58.72",
            "VATPercentage": "85.45",
            "noOfUnitsPerUOM": "pound",
            "customerOrderDate": "DateTime Object\r\n        (\r\n            [date] => 2017-04-24 12:00:00.000000\r\n            [timezone_type] => 3\r\n            [timezone] => Europe\/London\r\n        )",
            "text": "in tempor turpis nec",
            "lineNumber": "1",
            "customerProductCode": "63629-5076",
            "thirdPartyProductCode": "58118-3078",
            "unitDiscountedCostNet": "97.55",
            "discountPercentage": "92.94",
            "discountAmount": "51.41",
            "costVAT": "91.88",
            "costGross": "8.47",
            "VATCode": "GB216528709",
            "currency": "EUR",
            "clientOrderNumber": "53808-0595",
            "customerOrderNumber": "11534-164",
            "customerOrderLineNumber": "26",
            "proofOfDeliveryReference": "0006-0735",
            "dispatchDate": "08\/02\/2017",
            "clientDeliveryNumber": "63629-4179",
            "customerDeliveryNumber": "10019-163",
            "deliveryDate": "20\/08\/2017",
            "flag": "donec",
            "pgBrkAftr": "1",
            "customerOrderQuantity": "1"
        },
        {
            "clientProductCode": "632D63-8",
            "descriptions": [
                "STATOR UNIT DTW281"
            ],
            "extraCharges": {
                "charge": {
                    "valueNet": "22",
                    "valueVAT": "24",
                    "valueGross": "28",
                    "VATCode": "vat-code",
                    "VATPercentage": "20",
                    "currency": "USD"
                }
            },
            "extrinsics": {
                "packingList": "1582624",
                "routeCode": "REPAIR",
                "warehouse": "01",
                "Key":"B123",
                "itemNo":"0999"
            },
            "unitOfMeasure": "pound",
            "quantity": "1",
            "unitStandardCostNet": "75",
            "costNet": "0",
            "VATPercentage": "0",
            "noOfUnitsPerUOM": "pound",
            "customerOrderDate": "",
            "text": "W281Z S\/N XXX 0",
            "lineNumber": "2",
            "customerProductCode": "632D6333",
            "thirdPartyProductCode": "58118-3079",
            "unitDiscountedCostNet": "0",
            "discountPercentage": "0",
            "discountAmount": "100",
            "costVAT": "0",
            "costGross": "0",
            "VATCode": "STD",
            "currency": "GBP",
            "clientOrderNumber": "",
            "customerOrderNumber": "",
            "customerOrderLineNumber": "0",
            "proofOfDeliveryReference": "ref1",
            "dispatchDate": "18\/01\/2017",
            "clientDeliveryNumber": "111",
            "customerDeliveryNumber": "222",
            "deliveryDate": "18\/01\/2017",
            "flag": "",
            "pgBrkAftr": "",
            "customerOrderQuantity": "1"
        },
        {
            "clientProductCode": "632D63-145",
            "descriptions": [
                "STATOR UNIT DTW281"
            ],
            "extraCharges": {
                "charge": {
                    "valueNet": "22",
                    "valueVAT": "24",
                    "valueGross": "28",
                    "VATCode": "vat-code",
                    "VATPercentage": "20",
                    "currency": "USD"
                }
            },
            "extrinsics": {
                "packingList": "1582624",
                "routeCode": "REPAIR",
                "warehouse": "01",
                "Key":"B456",
                "itemNo":"2653"
            },
            "unitOfMeasure": "pound",
            "quantity": "1",
            "unitStandardCostNet": "75",
            "costNet": "0",
            "VATPercentage": "0",
            "noOfUnitsPerUOM": "pound",
            "customerOrderDate": "",
            "text": "W281Z S\/N XXX 0",
            "lineNumber": "2",
            "customerProductCode": "632D6333",
            "thirdPartyProductCode": "58118-3079",
            "unitDiscountedCostNet": "0",
            "discountPercentage": "0",
            "discountAmount": "100",
            "costVAT": "0",
            "costGross": "0",
            "VATCode": "STD",
            "currency": "GBP",
            "clientOrderNumber": "",
            "customerOrderNumber": "",
            "customerOrderLineNumber": "0",
            "proofOfDeliveryReference": "ref1",
            "dispatchDate": "18\/01\/2017",
            "clientDeliveryNumber": "111",
            "customerDeliveryNumber": "222",
            "deliveryDate": "18\/01\/2017",
            "flag": "",
            "pgBrkAftr": "",
            "customerOrderQuantity": "1"
        },
        {
            "clientProductCode": "632D63-12",
            "descriptions": [
                "STATOR UNIT DTW281"
            ],
            "extraCharges": {
                "charge": {
                    "valueNet": "22",
                    "valueVAT": "24",
                    "valueGross": "28",
                    "VATCode": "vat-code",
                    "VATPercentage": "20",
                    "currency": "USD"
                }
            },
            "extrinsics": {
                "packingList": "1582624",
                "routeCode": "REPAIR",
                "warehouse": "01",
                "Key":"AA56",
                "itemNo":"2653"
            },
            "unitOfMeasure": "pound",
            "quantity": "1",
            "unitStandardCostNet": "75",
            "costNet": "0",
            "VATPercentage": "0",
            "noOfUnitsPerUOM": "pound",
            "customerOrderDate": "",
            "text": "W281Z S\/N XXX 0",
            "lineNumber": "2",
            "customerProductCode": "632D6333",
            "thirdPartyProductCode": "58118-3079",
            "unitDiscountedCostNet": "0",
            "discountPercentage": "0",
            "discountAmount": "100",
            "costVAT": "0",
            "costGross": "0",
            "VATCode": "STD",
            "currency": "GBP",
            "clientOrderNumber": "",
            "customerOrderNumber": "",
            "customerOrderLineNumber": "0",
            "proofOfDeliveryReference": "ref1",
            "dispatchDate": "18\/01\/2017",
            "clientDeliveryNumber": "111",
            "customerDeliveryNumber": "222",
            "deliveryDate": "18\/01\/2017",
            "flag": "",
            "pgBrkAftr": "",
            "customerOrderQuantity": "1"
        },
        {
            "clientProductCode": "632D63-12",
            "descriptions": [
                "STATOR UNIT DTW281"
            ],
            "extraCharges": {
                "charge": {
                    "valueNet": "22",
                    "valueVAT": "24",
                    "valueGross": "28",
                    "VATCode": "vat-code",
                    "VATPercentage": "20",
                    "currency": "USD"
                }
            },
            "extrinsics": {
                "packingList": "1582624",
                "routeCode": "REPAIR",
                "warehouse": "01",
                "Key":"B678",
                "itemNo":"2653"
            },
            "unitOfMeasure": "pound",
            "quantity": "1",
            "unitStandardCostNet": "75",
            "costNet": "0",
            "VATPercentage": "0",
            "noOfUnitsPerUOM": "pound",
            "customerOrderDate": "",
            "text": "W281Z S\/N XXX 0",
            "lineNumber": "2",
            "customerProductCode": "632D6333",
            "thirdPartyProductCode": "58118-3079",
            "unitDiscountedCostNet": "0",
            "discountPercentage": "0",
            "discountAmount": "100",
            "costVAT": "0",
            "costGross": "0",
            "VATCode": "STD",
            "currency": "GBP",
            "clientOrderNumber": "",
            "customerOrderNumber": "",
            "customerOrderLineNumber": "0",
            "proofOfDeliveryReference": "ref1",
            "dispatchDate": "18\/01\/2017",
            "clientDeliveryNumber": "111",
            "customerDeliveryNumber": "222",
            "deliveryDate": "18\/01\/2017",
            "flag": "",
            "pgBrkAftr": "",
            "customerOrderQuantity": "1"
        }
    ]
}