excel - Foreach loop with json data laravel

Question

I want to make a table in html with json data using laravel excel, the data looks like this

4 => {
    +"id": 5
    +"date": "2020-1-3"
    +"grade": "7"
    +"nama": "["bryan","anderson"]"
    +"status": "["active","active"]"
}

the excel file output i was hoping for is this. Status fill the column based on dates and if there is no data in particular date the column will filled with "-". I tried a foreach loop I found here, but did not have any luck.

I call the data with $reports, for example $reports->status will return ["active","active"] and so on.

This is the code i am working on

<table>
    <thead>
        <tr>
            <th>No.</th>
            <th>Name</th>
            @for ($i = 1; $i < 32; $i++)
                <th>{{ $i }}</th>
            @endfor
        </tr>
    </thead>
    <tbody>
        @foreach ($reports as $rp)
            <tr>
                <td>{{ $loop->iteration }}</td>
                    <!--INSERT DATA HERE-->
                <td></td>
            </tr>
        @endforeach
    </tbody>
</table>

dd($reports) return =

array:2 [▼
0 => {#455 ▼
    +"id": 17
    +"date": "2021-01-03"
    +"grade": "7"
    +"nama": "["bryan","anderson"]"
    +"status": "["active","active"]"
    +"created_at": "2021-01-23 05:33:27"
    +"updated_at": "2021-01-23 05:33:27"
  }
  1 => {#1414 ?}
]

question from:https://stackoverflow.com/questions/65859913/foreach-loop-with-json-data-laravel

Answer 1

Try this following code;
    <table border=1>
                            <thead>
                                <tr>
                                    <th>No.</th>
                                    <th>Name</th>
                                    <th>Status</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php $index=1; @endphp
                                @foreach ($reports as $rp)
                                    @foreach ($rp->nama as $key => $val)
                                        <tr>
                                            <td>{{ $index }}</td>
                                            <td>{{ $val }}</td>
                                            <td>{{ optional($rp->status)[$key] }}</td>
                                        </tr>
                                        @php $index++; @endphp
                                    @endforeach
                                @endforeach
                            </tbody>
                        </table>