@extends('admin.layout.master')
@section('title', 'Dashboard')
@section('content')
<div class="d-flex flex-column flex-column-fluid">
    <div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
        <div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
            <div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
                <ul class="breadcrumb breadcrumb-separatorless fw-semibold fs-7 my-0 pt-1">
                    <li class="breadcrumb-item text-muted">
                        <a href="{{ url('/') }}" class="text-muted text-hover-primary">Dashboard</a>
                    </li>
                    <li class="breadcrumb-item">
                        <span class="bullet bg-gray-400 w-5px h-2px"></span>
                    </li>
                    <li class="breadcrumb-item text-muted">Results</li>
                </ul>
            </div>
        </div>
    </div>
    <div id="kt_app_content_container" class="app-container container-xxl">
        <div class="card mb-5 mb-xl-8">
        <div class="card-header flex-wrap border-0 pt-6 pb-0">
                <div class="card-title">
                    <h3 class="card-label">Team Scores
                    </h3>
                </div>
                <div class="card-toolbar">
                </div>
                @if(session()->has('success'))
                <div class="alert alert-success">
                    {{ session()->get('success') }}
                </div>
                @endif
            </div>
                       
            <div class="card-body py-3">
                <div class="table-responsive">
                    <table class="table table-row-dashed align-middle gs-0 gy-4" id="ds_datatable_table">
                        <thead>
                            <tr>
                                <th>Club</th>
                                <th>National Grade</th>
                                <th>Level</th>
                                <th>Gymnast</th>
                                <th>Gender</th>
                                @foreach ($sname as $name)
                                <th>{{$name}}</th>
                                @endforeach
                                <th>Total</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($data as $row)
                            <tr>
                                <td>{{ $row ->clubname }}</td>
                                <td>{{ $row ->category }}</td>
                                <td>{{ $row ->level }}</td>
                                <td>{{ $row ->name }}</td>
                                <td>{{ $row ->gender }}</td>
                                @foreach ($sname as $name)
                                <td>{{ $row->{'apid_' . $name} }}</td>
                                @endforeach
                                <td>{{ $row ->total }}</td>
    
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@push('js')
<script>
$(document).ready(function() {
    $("#ds_datatable_table").DataTable({
        dom: "<'row'<'col-sm-3 float-start'f><'col-sm-3'><'col-sm-3'><'col-sm-3 float-end'B>><'row'<'col-sm-12'tr>><'row'<'col-sm-12 col-md-1'l><'col-sm-12 col-md-5'i><'col-sm-12 col-md-6'p>>",
                buttons: [
                    {
                        extend: 'excelHtml5',
                        exportOptions: {
                            columns: [0,1,2,3,4,5,6,7,8,9]
                        }
                    }
                ],
        info: 1,
        order: [],
        pageLength: 10,
        lengthChange: 1,
        
    });
});

</script>
@endpush