@if($data && $data->count() > 0)
<table>
    <thead>
        <tr>
            <th>D-No</th>
            <th>Activity Description</th>
            <th>Credit Points Claimed</th>
            <th>Files Uploaded</th>
        </tr>
    </thead>
    <tbody>
        @foreach($data->sortBy(function($item) { return (int)substr($item->d_no, 1); }) as $summary)
        <tr>
            <td><strong>{{ $summary->d_no }}</strong></td>
            <td>{{ $summary->activity }}</td>
            <td style="text-align: center;">{{ number_format($summary->credit_points_claimed, 2) }}</td>
            <td style="text-align: center;">{{ $summary->files_uploaded ? 'Yes' : 'No' }}</td>
        </tr>
        @endforeach
    </tbody>
    <tfoot>
        <tr style="background-color: #f8f9fa; font-weight: bold;">
            <td colspan="2">Total Credit Points</td>
            <td style="text-align: center;">{{ number_format($data->sum('credit_points_claimed'), 2) }}</td>
            <td style="text-align: center;">{{ $data->where('files_uploaded', true)->count() }}/{{ $data->count() }}</td>
        </tr>
    </tfoot>
</table>

<div style="background-color: #e8f5e8; padding: 10px; border: 1px solid #27ae60; margin-top: 10px;">
    <strong>Summary:</strong> Total {{ $data->count() }} activities with {{ number_format($data->sum('credit_points_claimed'), 2) }} credit points claimed.
    <br>
    <strong>Files Status:</strong> {{ $data->where('files_uploaded', true)->count() }} out of {{ $data->count() }} activities have supporting files uploaded.
</div>
@else
<div class="no-data">No credit point summary available</div>
@endif