@extends('layouts.page')
@section('css_plugin')
<!-- Include Choices CSS -->
<link rel="stylesheet" href="{{ URL::asset('mazer-docs/demo/assets/vendors/choices.js/choices.min.css') }}" />
@endsection
@section('content')
    <div class="page-heading">
        <div class="page-title">
            <div class="row">
                <div class="col-12 col-md-6 order-md-1 order-last">
                    <h3>Upload & Update Data Nilai USBN</h3>
                    <p class="text-subtitle text-muted">Form data menu upload & update data nilai usbn</p>
                </div>
                <div class="col-12 col-md-6 order-md-2 order-first">
                    <nav aria-label="breadcrumb" class="breadcrumb-header float-start float-lg-end">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
                            <li class="breadcrumb-item"><a href="{{ route('uploaddata.index') }}">Upload Data</a></li></li>
                            <li class="breadcrumb-item active" aria-current="page">Nilai USBN</li>
                        </ol>
                    </nav>
                </div>
            </div>
        </div>

        <!-- Basic Tables start -->
        <section class="section">
            <div class="card">
                <div class="card-header">
                    <h3 class="card-title">Filter Mata Pelajaran Kompetensi Keahlian</h3>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-12">
                            <form action="{{ route('uploaddata.cariusbn') }}" method="get" enctype="multipart/form-data" class="form-horizontal">
                                @csrf
                                <div class="row">
                                    <div class="col-md-5">
                                        <div class="form-group">
                                            <select id="jurusan" name="jurusan" class="choices form-select">
                                                <option value="">...: Pilih Kompetensi Keahlian :...</option>
                                                @foreach ($jurusan as $row)
                                                    <option value="{{ $row->id }}" {{ $jur['kompetensi'] == $row->kompetensi ? 'selected':'' }}>{{ $row->kompetensi }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <a href="{{ route('uploaddata.index') }}" class="btn btn-outline-warning">
                                                <i class="fas fa-arrow-left"></i> Kembali
                                            </a>
                                            <button type="submit" class="btn btn-outline-primary">
                                                <i class="fas fa-paper-plane"></i> Submit
                                            </button>
                                        </div>
                                    </div>
                                </div>
                                <!-- /.row -->
                            </form>
                            <hr>
                        </div>
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h3 class="card-title">Daftar Mata Pelajaran Kompetensi Keahlian {{ $jur['kompetensi'] }}</h3>
                                </div>
                                <div class="card-body">
                                    <table class="table">
                                        <thead>
                                            <tr>
                                                <th style="width: 10px">#</th>
                                                <th style="width: 10px">Kelompok</th>
                                                <th>Mata Pelajaran</th>
                                                <th>Aksi</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $no = '1';
                                            @endphp
                                            @forelse ($mapel as $item)
                                            @php
                                                $mapjur = DB::table('mapelusbns')->select('id')->where('jurusan_id',$jur->id)
                                                    ->where('mapel_id',$item->mapel_id)->first();
                                                $usbn = DB::table('usbns')->where('mapelusbn_id',$mapjur->id)
                                                    ->where('tahun', $setting->tahun)->get()->count();
                                            @endphp
                                                <tr>
                                                    <td>{{ $no++ }}</td>
                                                    <td>{{ $item->mapel->jenis_mapel }}</td>
                                                    <td>{{ $item->mapel->nama_mapel }}</td>
                                                    <td class="text-center">
                                                        @if ($usbn>0)
                                                            <a href="{{ route('uploaddata.editusbn',$item->id) }}" class="btn btn-outline-warning btn-sm">
                                                                <i class="fas fa-edit"></i>
                                                            </a>
                                                        @else
                                                            <a href="{{ route('uploaddata.uploadusbn',$item->id) }}" class="btn btn-outline-info btn-sm">
                                                                <i class="fas fa-file-upload"></i>
                                                            </a>
                                                        @endif
                                                    </td>
                                                </tr>
                                            @empty
                                                <tr class="text-center">
                                                    <td colspan="4">Tidak Ada Data</td>
                                                </tr>
                                            @endforelse
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!-- Basic Tables end -->
@endsection
@section('js_plugin')
<script src="{{ URL::asset('mazer-docs/demo/assets/vendors/jquery/jquery.min.js') }}"></script>
<!-- Include Choices JavaScript -->
<script src="{{ URL::asset('mazer-docs/demo/assets/vendors/choices.js/choices.min.js') }}"></script>
<script src="{{ URL::asset('mazer-docs/demo/assets/js/pages/form-element-select.js') }}"></script>
@endsection