@extends('layouts.app')
@section('content')
<div class="wrapper">
    <div class="content-wrapper">
        <section class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1 class="player-title">Data Management</h1>
                    </div>
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-right">
                            <li class="breadcrumb-item"><a href="#">Home</a></li>
                            <li class="breadcrumb-item active">Data Management</li>
                        </ol>
                    </div>
                </div>
            </div>
        </section>
        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <!-- Filter Dropdown -->
                    <div class="col-md-6 ml-auto mb-4">
                        <form method="GET" action="{{ route('data-management.index') }}">
                            <div class="form-group">
                                <label for="survey">Select General Survey</label>
                                <select class="form-control" id="survey" name="survey_id" onchange="this.form.submit()">
                                    <option value="">-- Select Survey --</option>
                                    @foreach($expiredSurveys as $survey)
                                        <option value="{{ $survey->id }}" {{ request()->get('survey_id') == $survey->id ? 'selected' : '' }}>
                                            {{ ucfirst($survey->title) }}
                                    @endforeach
                                </select>
                            </div>
                        </form>
                    </div>
                </div>
                <!-- Data Table -->
                @if(!empty($responses) && !empty($questions))
                    <div class="row">
                        <div class="col-12">
                            <div class="card inner-table-responsive">
                                <div class="card-body">
                                    <table id="example1" class="table-data-management table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th>S. No</th>
                                                <th>Name</th>
                                                <th>Email</th>
                                                <th>Gender</th>
                                                <th>Age</th>
                                                <th>Nationality</th>
                                                <th>Location</th>
                                                <!-- <th>Action</th> -->
                                                @foreach($questions as $question)
                                                    <th>{{ ucfirst($question) }}</th>
                                                @endforeach
                                            </tr>
                                        </thead>
                                        <tbody>
                                                                                        @foreach($responses as $index => $response)
                                                <tr>
                                                    <th> {{$i}} </th>
                                                    <td>{{ $response['name'] }}</td>
                                                    <td>{{ $response['email'] }}</td>
                                                    <td>{{ $response['sex'] }}</td>
                                                    <td>{{ $response['age'] }}</td>
                                                    <td>{{ $response['nationality'] }}</td>
                                                    <td>{{ $response['location'] }}</td>
                                                    <!-- <td class="data-management-action text-center">
                                                        <a href="{{ route('data-management.view', ['userId' => $response['user_id'], 'surveyId' => $response['survey_id']]) }}"
                                                            class="btn btn-primary">
                                                            View Response</a>
                                                    </td> -->
                                                    @foreach($response['responses'] as $questionId => $answers)
                                                        <td>
                                                            {{ is_array($answers) ? implode(',', $answers) : $answers }}
                                                        </td>
                                                    @endforeach
                                                </tr> 
                                                                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                @else
                    <p>No data available. Please select a survey to view data.</p>
                @endif
            </div>
        </section>
    </div>
</div>
@endsection