How to iterate a JSON ARRAY with internal Array in Blade?

Question

I am working with MongoDB and so far I have been able to loop through the following JSON correctly with the ability to manipulate the data to display.

controller

$json = '[{
"T": {
   "HD": {
       "HD01": "1",
       "HD06": "20201006033942",
       "HD08": "3736803"
       }
   }
},
{
"T": {
   "HD": {
       "HD01": "1",
       "HD06": "20201006035419",
       "HD08": "3736803"
       }
   }
}]'

$keysToRemove = ['HD01', 'HD06'];

$data = collect(json_decode($data, true))
       ->flatten(2)
       ->map(function ($array, $key) use ($keysToRemove) {
           foreach ($keysToRemove as $key) {
               if (array_key_exists($key, $array)) {
                  unset($array[$key]);
               }
           }
       return $array;
     });

return view('dashboard.book.index', [
    'data' => $data
]);

Blade

<table>
    <tr>
        @foreach ($data->first() as $key => $value)
        <th>{{ $key }}</th>
        @endforeach
    </tr>
    @foreach ($data as $items)
    <tr>
        @foreach ($items as $key => $value)
        <td>{{ $value }}</td>
        @endforeach
    </tr>
    @endforeach
</table>

result

Table

Now, now I must go through another one that has an array inside it, and which is made up as follows:

controller

$data = '[{
        "T": {
            "SIEL" : {
                    "SIE" : [
                        {
                            "sequenceNumber" : 0,
                            "itemId" : "3010",
                            "itemDescription" : "BAN VACCINE COSTELLET",
                            "unitAmount" : 29950,
                            "quantity" : 1,405,
                            "subTotalAmount" : 42080,
                            "discountAmount" : 0,
                            "totalAmount" : 42080
                           
                        },
                        {
                            "sequenceNumber" : 1,
                            "itemId" : "1010",
                            "itemDescription" : "CROLETA COOKIE",
                            "unitAmount" : 4800,
                            "quantity" : 0.605,
                            "subTotalAmount" : 2904,
                            "discountAmount" : 0,
                            "totalAmount" : 2904
                        }
                    ]
                }
            }
            
        }]';

How do I go through it following the logic of the first one, to obtain the 'SIE' data?

Peppermintology · Accepted Answer · 2022-09-01 20:15:11Z

0

It is a similar principle to your previous question. Decode your JSON to an associative array, convert to a collection, flatten it and work with the result.

$sieData = collect(json_decode($data, true))->flatten(3)->collapse();

return view('view.blade.php', compact('sieData'));

The value of sieData is an array of associated arrays. You already have how to loop over such a structure in the example code you provided in your question.

answered Sep 1, 2022 at 20:15

Peppermintology

10.4k4 gold badges34 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Adolfi Téllez Over a year ago

Thanks mate... I've been dealing with this for days now. I'm progressing slowly but surely... Here I have another question that you can help me answer if you want: stackoverflow.com/questions/73581695/… . The final part includes joining all the header and all the detail in a table.

Collectives™ on Stack Overflow

How to iterate a JSON ARRAY with internal Array in Blade?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related