@php use Illuminate\Support\Facades\URL; @endphp
<div class="p-6 bg-white rounded-2xl shadow-lg">

    <!-- Zurück Button -->
    <div class="flex justify-between items-center mb-6">
        <button class="text-[rgb(241,131,0)] z-1">
            <a href="{{ route('kpi-menu', ['fid' => session('fid'), 'mid' => session('mid'), 'proz_id' => $proz_id ?? request('proz_id')]) }}">
                &lt;zurück
            </a>
        </button>
    </div>

    <h2 class="text-2xl font-semibold mb-6 text-gray-800">Reporting: Key Performance Indikatoren</h2>

    <div class="overflow-x-auto rounded-xl border border-gray-200 shadow-sm">
        <table class="min-w-full text-sm text-left text-gray-700">
            <thead class="bg-gray-100 text-gray-900 text-sm font-semibold uppercase tracking-wide">
            <tr>
                <th class="px-4 py-3 border-b">Nr</th>
                <th class="px-4 py-3 border-b">Prozess</th>
                <th class="px-4 py-3 border-b">Kennzahl</th>
                <th class="px-4 py-3 border-b">Ziel</th>
                <th class="px-4 py-3 border-b">Bewertung</th>
                <th class="px-4 py-3 border-b">Methode</th>
                <th class="px-4 py-3 border-b">Berichtszyklen</th>
                <th class="px-4 py-3 border-b">Datenquelle</th>
            </tr>
            </thead>
            <tbody class="divide-y divide-gray-200">
            @forelse ($latestKpis as $index => $kpi)
                <tr class="hover:bg-gray-50 transition">
                    <td class="px-4 py-3 font-medium text-gray-900">{{ $index + 1 }}</td>
                    <td class="px-4 py-3">
                        @if($kpi->prozesse && $kpi->prozesse->count())
                            <div class="flex flex-wrap gap-1">
                                @foreach($kpi->prozesse as $p)
                                    <span class="inline-flex items-center px-2 py-1 rounded-full text-xs font-medium bg-blue-100 text-blue-700">
                                     {{ $p->prozess->proz_nummer ?? '–' }} - {{ $p->prozess->proz_name ?? '–' }}
                                    </span>
                                @endforeach
                            </div>
                        @else
                            <span class="text-gray-400">–</span>
                        @endif
                    </td>
                    <td class="px-4 py-3">{{ $kpi->name ?? '-' }}</td>
                    <td class="px-4 py-3">{{ $kpi->ziel ?? '-' }}</td>
                    <td class="px-4 py-3">
                        @if($kpi->bewertung)
                            <span class="inline-flex items-center px-2 py-1 rounded-full text-xs font-semibold
                                {{ str_contains(strtolower($kpi->bewertung), 'gut') ? 'bg-green-100 text-green-700' : 'bg-yellow-100 text-yellow-700' }}">
                                {{ $kpi->bewertung }}
                            </span>
                        @else
                            <span class="text-gray-400">–</span>
                        @endif
                    </td>
                    <td class="px-4 py-3">{{ $kpi->methode ?? '-' }}</td>
                    <td class="px-4 py-3">{{ $kpi->zyklus->name ?? '-' }}</td>
                    <td class="px-4 py-3">
                        @if($kpi->dateien && $kpi->dateien->count())
                            <div class="space-y-2">
                                @foreach($kpi->dateien as $file)
                                    @php
                                        try {
                                            $downloadUrl = $file->file_path
                                                ? URL::temporarySignedRoute(
                                                    'file.download',
                                                    now()->addMinutes(60),
                                                    [
                                                        'folder' => $file->getSFTP(),
                                                        'filePath' => $file->file_path,
                                                        'filename' => $file->original_filename,
                                                    ]
                                                  )
                                                : null;
                                        } catch (\Exception $e) {
                                            $downloadUrl = null;
                                        }
                                    @endphp

                                    <div class="flex flex-col text-sm">
                                        @if($downloadUrl)
                                            <a href="{{ $downloadUrl }}" target="_blank" class="text-blue-600 hover:underline font-medium">
                                                📄 {{ $file->original_filename ?? '–' }}
                                            </a>
                                        @else
                                            <span class="text-gray-500">{{ $file->original_filename ?? '–' }}</span>
                                        @endif

                                        @if(!empty($file->bemerkung))
                                            <span class="text-gray-500 text-xs italic ml-5">
                                                {{ $file->bemerkung }}
                                            </span>
                                        @endif
                                    </div>
                                @endforeach

                            </div>
                        @else
                            <span class="text-gray-400">–</span>
                        @endif
                    </td>
                </tr>
            @empty
                <tr>
                    <td colspan="8" class="px-4 py-3 text-center text-gray-500">Keine Daten vorhanden.</td>
                </tr>
            @endforelse
            </tbody>
        </table>
    </div>
</div>