@extends('Layouts.app')

@section('content')
@if(auth()->user()->level === 'superadmin' || auth()->user()->level === 'Akademik')
<div class="container mx-auto px-4 py-8">
    <div class="flex justify-between items-center mb-6">
        <h1 class="text-3xl font-bold text-gray-800">Daftar Mata Kuliah</h1>
        <a href="{{ route('mata-kuliah.create') }}" class="px-4 py-2 bg-blue-600 text-white rounded-md hover:bg-blue-700 transition duration-300 ease-in-out">
            Tambah Mata Kuliah Baru
        </a>
    </div>
    <a href="/exel/template_import_matkul.xlsx" 
       class="inline-block bg-blue-600 text-white px-4 py-2 rounded hover:bg-green-700 text-sm mb-4">
       Download Template Excel
    </a>

    @if(session('success'))
        <div class="bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded relative mb-4" role="alert">
            <span class="block sm:inline">{{ session('success') }}</span>
        </div>
    @endif

    @if(session('error'))
        <div class="bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded relative mb-4" role="alert">
            <span class="block sm:inline">{{ session('error') }}</span>
        </div>
    @endif

    @if(session('import_errors'))
        <div class="bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded relative mb-4">
            <strong class="font-bold">Gagal Mengimport Data!</strong>
            <span class="block sm:inline">Periksa kesalahan berikut:</span>
            <ul class="list-disc list-inside mt-2">
                @foreach(session('import_errors') as $error)
                    <li>{{ $error }}</li>
                @endforeach
            </ul>
        </div>
    @endif
    
    @if(session('warning'))
        <div class="bg-yellow-100 border border-yellow-400 text-yellow-700 px-4 py-3 rounded relative mb-4" role="alert">
            <span class="block sm:inline">{{ session('warning') }}</span>
        </div>
    @endif

    <div class="mb-8 p-6 bg-white shadow-lg rounded-lg">
        <h2 class="text-2xl font-bold text-gray-800 mb-4">Import Data Mata Kuliah dari Excel</h2>
    
        {{-- Pesan untuk Jurusan --}}
        <div class="mb-6 p-4 bg-blue-50 border-l-4 border-blue-400 text-blue-800 rounded-md">
            <p class="font-semibold text-sm">Informasi Penting:</p>
            <p class="text-sm">Sistem akan secara otomatis mendeteksi dan menambahkan jurusan baru jika nama jurusan di file Excel belum ada di sistem. Jadi, tidak perlu menginput data jurusan secara manual sebelumnya. 😉</p>
        </div>
    
        {{-- Pesan untuk Format Kolom --}}
        <div class="mb-6 p-4 bg-yellow-50 border-l-4 border-yellow-400 text-yellow-800 rounded-md">
            <p class="font-semibold text-sm">Panduan Format File Excel:</p>
            <p class="text-sm">Pastikan baris pertama (header) di file menggunakan nama kolom berikut, tanpa spasi:</p>
            <ul class="list-disc list-inside mt-2 text-sm">
                <li>`kode_mk` (Kode Mata Kuliah)</li>
                <li>`judul_mk` (Nama Mata Kuliah)</li>
                <li>`sks` (Jumlah SKS)</li>
                <li>`jurusan` (Nama Jurusan)</li>
                <li>`smt` (Semester, isi dengan angka 1-8 atau 'Umum')</li>
            </ul>
        </div>
    
        {{-- Pesan untuk Kasus Duplikasi --}}
        <div class="mb-6 p-4 bg-red-50 border-l-4 border-red-400 text-red-800 rounded-md">
            <p class="font-semibold text-sm">Perhatian:</p>
            <p class="text-sm">Jika kode mata kuliah di file Excel Anda sudah ada di sistem, data tersebut akan **dilewati** secara otomatis untuk menghindari duplikasi. Mata kuliah yang sudah ada tidak akan di-update. </p>
        </div>
    
        <form action="{{ route('mata-kuliah.import') }}" method="POST" enctype="multipart/form-data">
            @csrf
            <div class="mb-4">
                <label for="file" class="block text-sm font-medium text-gray-700">Pilih File Excel (.xlsx, .xls, .csv)</label>
                <input type="file" name="file" id="file" class="mt-1 block w-full text-sm text-gray-500 file:mr-4 file:py-2 file:px-4 file:rounded-full file:border-0 file:text-sm file:font-semibold file:bg-blue-50 file:text-blue-700 hover:file:bg-blue-100">
                @error('file')
                    <p class="mt-2 text-sm text-red-600">{{ $message }}</p>
                @enderror
            </div>
            <button type="submit" class="px-4 py-2 bg-green-600 text-white rounded-md hover:bg-green-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-green-500">
                Import Data
            </button>
        </form>
    </div>

    <div class="bg-white shadow-lg rounded-lg overflow-hidden">
        <div class="p-6">
            <div class="overflow-x-auto">
                <table id="mataKuliahTable" class="min-w-full divide-y divide-gray-200">
                    <thead class="bg-gray-50">
                        <tr>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Kode
                            </th>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Judul
                            </th>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                SKS
                            </th>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Semester
                            </th>
                            <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Jurusan
                            </th>
                            <th scope="col" class="px-6 py-3 text-right text-xs font-medium text-gray-500 uppercase tracking-wider">
                                Aksi
                            </th>
                        </tr>
                    </thead>
                    <tbody class="bg-white divide-y divide-gray-200">
                        @foreach($mataKuliah as $mk)
                        <tr class="hover:bg-gray-100 transition duration-150 ease-in-out">
                            <td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">
                                {{ $mk->kode_mk }}
                            </td>
                            <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">
                                {{ $mk->judul_mk }}
                            </td>
                            <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">
                                {{ $mk->sks }}
                            </td>
                            <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">
                                {{ $mk->smt }}
                            </td>
                            <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">
                                {{ $mk->jurusan->nama }}
                            </td>
                            <td class="px-6 py-4 whitespace-nowrap text-right text-sm font-medium">
                                <a href="{{ route('mata-kuliah.edit', $mk->id) }}" class="text-indigo-600 hover:text-indigo-900 mr-2">Edit</a>
                                <form action="{{ route('mata-kuliah.destroy', $mk->id) }}" method="POST" class="inline-block">
                                    @csrf
                                    @method('DELETE')
                                    <button type="submit" class="text-red-600 hover:text-red-900" onclick="return confirm('Apakah Anda yakin ingin menghapus mata kuliah ini?')">Hapus</button>
                                </form>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

{{-- Tambahkan link CDN untuk jQuery dan DataTables --}}
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.css">
<script type="text/javascript" charset="utf8" src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.js"></script>

<script>
    $(document).ready( function () {
        $('#mataKuliahTable').DataTable({
            "language": {
                "url": "//cdn.datatables.net/plug-ins/1.11.5/i18n/id.json"
            }
        });
    });
</script>
@endif
@endsection