@extends('layouts.app', ['title' => 'Lohn- & Kassenausgaben'])
@section('content')

@php
    $groupedPayments = $payments->groupBy(function ($p) {
        return $p->year . '-' . str_pad($p->month, 2, '0', STR_PAD_LEFT);
    });
    $grandTotal = $payments->sum('amount');
    $grandPaid  = 0;
    foreach ($payments as $p) {
        $grandPaid += $p->paid ? $p->amount : $p->parts->sum('amount');
    }
    $grandOpen = $grandTotal - $grandPaid;

    $monthNames = ['01'=>'Januar','02'=>'Februar','03'=>'März','04'=>'April','05'=>'Mai','06'=>'Juni',
                   '07'=>'Juli','08'=>'August','09'=>'September','10'=>'Oktober','11'=>'November','12'=>'Dezember'];
@endphp

<div class="container-fluid py-4" style="max-width:1600px;">

    {{-- Header --}}
    <div class="d-flex align-items-center justify-content-between mb-4 flex-wrap gap-2">
        <h4 class="fw-bold mb-0"><i class="bi bi-cash-stack me-2 text-primary"></i>Lohn- & Kassenausgaben</h4>
        <div class="d-flex gap-2 flex-wrap">
            <a href="{{ route('rechnungswesen.recipients.index') }}" class="btn btn-outline-secondary rounded-pill px-3 btn-sm">
                <i class="bi bi-people me-1"></i>Empfänger
            </a>
            <button class="btn btn-info rounded-pill px-3 btn-sm" data-bs-toggle="modal" data-bs-target="#import320Modal">
                <i class="bi bi-upload me-1"></i>Import 320
            </button>
            <button class="btn btn-warning rounded-pill px-3 btn-sm" data-bs-toggle="modal" data-bs-target="#import202Modal">
                <i class="bi bi-upload me-1"></i>Import 202
            </button>
            <button class="btn btn-success rounded-pill px-3 btn-sm" data-bs-toggle="modal" data-bs-target="#createPaymentModal">
                <i class="bi bi-plus-lg me-1"></i>Neue Zahlung
            </button>
        </div>
    </div>

    @if(session('msg'))
        <div class="alert alert-success alert-dismissible fade show">
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            {{ session('msg') }}
        </div>
    @endif
    @if(session('error'))
        <div class="alert alert-danger alert-dismissible fade show">
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            {{ session('error') }}
        </div>
    @endif
    @if(session('status'))
        <div class="alert alert-success alert-dismissible fade show">
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            {{ session('status') }}
        </div>
    @endif
    @if($errors->any())
        <div class="alert alert-danger alert-dismissible fade show">
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            <ul class="mb-0">@foreach($errors->all() as $e)<li>{{ $e }}</li>@endforeach</ul>
        </div>
    @endif

    {{-- Gesamt-Statistik --}}
    <div class="row g-3 mb-4">
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="text-muted small mb-1">Gesamt (alle Monate)</div>
                    <h3 class="fw-bold mb-0">{{ number_format($grandTotal, 2, ',', '.') }} €</h3>
                    <div class="mt-2 rounded" style="height:4px;background:#0d6efd;"></div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="text-muted small mb-1">Bezahlt</div>
                    <h3 class="fw-bold mb-0 text-success">{{ number_format($grandPaid, 2, ',', '.') }} €</h3>
                    <div class="mt-2 rounded" style="height:4px;background:#198754;"></div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="text-muted small mb-1">Offen</div>
                    <h3 class="fw-bold mb-0 text-danger">{{ number_format($grandOpen, 2, ',', '.') }} €</h3>
                    <div class="mt-2 rounded" style="height:4px;background:#dc3545;"></div>
                </div>
            </div>
        </div>
    </div>

    {{-- Monate --}}
    @forelse($groupedPayments as $yearMonth => $items)
        @php
            [$year, $month] = explode('-', $yearMonth);
            $mTotal = $items->sum('amount');
            $mPaid  = 0;
            foreach ($items as $p) { $mPaid += $p->paid ? $p->amount : $p->parts->sum('amount'); }
            $mOpen  = $mTotal - $mPaid;
        @endphp

        {{-- Delete Month Modal --}}
        <div class="modal fade" id="deleteMonthModal-{{ $year }}-{{ $month }}" tabindex="-1">
            <div class="modal-dialog modal-dialog-centered">
                <div class="modal-content border-0 shadow">
                    <div class="modal-header border-0 pb-0">
                        <h5 class="modal-title fw-semibold text-danger"><i class="bi bi-trash me-2"></i>Monat {{ $month }}/{{ $year }} löschen</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body">
                        <p>Willst du wirklich <strong>alle {{ $items->count() }} Zahlungen</strong> für <strong>{{ $monthNames[$month] ?? $month }} {{ $year }}</strong> löschen?</p>
                        <p class="text-muted small">Gesamtbetrag: <strong>{{ number_format($mTotal, 2, ',', '.') }} €</strong></p>
                        <p class="text-danger small mb-0"><i class="bi bi-exclamation-triangle me-1"></i>Dieser Vorgang kann nicht rückgängig gemacht werden!</p>
                    </div>
                    <div class="modal-footer border-0">
                        <button class="btn btn-outline-secondary rounded-pill px-3" data-bs-dismiss="modal">Abbrechen</button>
                        <form method="POST" action="{{ route('rechnungswesen.payments.destroyMonth', ['year' => $year, 'month' => $month]) }}" class="d-inline">
                            @csrf @method('DELETE')
                            <button class="btn btn-danger rounded-pill px-3" type="submit">Ja, löschen</button>
                        </form>
                    </div>
                </div>
            </div>
        </div>

        <div class="card border-0 shadow-sm mb-3">
            {{-- Monat Header --}}
            <div class="card-header bg-white border-0 py-3 px-4 d-flex align-items-center justify-content-between flex-wrap gap-2"
                 style="cursor:pointer;" data-bs-toggle="collapse" data-bs-target="#month-{{ $year }}-{{ $month }}">
                <div class="d-flex align-items-center gap-3">
                    <i class="bi bi-chevron-down text-muted" style="font-size:.75rem;transition:transform .2s;" id="icon-{{ $year }}-{{ $month }}"></i>
                    <span class="fw-semibold">{{ $monthNames[$month] ?? $month }} {{ $year }}</span>
                    <span class="badge bg-secondary rounded-pill">{{ $items->count() }} Einträge</span>
                </div>
                <div class="d-flex align-items-center gap-3">
                    <span class="small text-muted">Gesamt: <strong>{{ number_format($mTotal, 2, ',', '.') }} €</strong></span>
                    <span class="small text-success">Bezahlt: <strong>{{ number_format($mPaid, 2, ',', '.') }} €</strong></span>
                    <span class="small text-danger">Offen: <strong>{{ number_format($mOpen, 2, ',', '.') }} €</strong></span>
                    <button type="button" class="btn btn-outline-danger btn-sm rounded-circle p-0"
                        style="width:28px;height:28px;"
                        data-bs-toggle="modal" data-bs-target="#deleteMonthModal-{{ $year }}-{{ $month }}"
                        onclick="event.stopPropagation()">
                        <i class="bi bi-trash" style="font-size:.7rem;"></i>
                    </button>
                </div>
            </div>

            {{-- Monat Body --}}
            <div class="collapse show" id="month-{{ $year }}-{{ $month }}">
                <div class="card-body p-0">
                    <table class="table table-hover align-middle mb-0" style="font-size:0.82rem;">
                        <thead class="table-light">
                            <tr>
                                <th class="ps-3">Empfänger</th>
                                <th>Verwendungszweck</th>
                                <th>Kategorie</th>
                                <th class="text-end">Betrag</th>
                                <th>Status</th>
                                <th class="text-end pe-3">Aktion</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($items->sortBy('recipient_id') as $payment)
                                @php
                                    $rName   = mb_strtolower($payment->recipient?->name ?? '');
                                    $purpose = mb_strtolower($payment->purpose ?? '');
                                    $category = 'Sonstige';
                                    if (str_contains($rName, 'fa potsdam')) {
                                        $category = str_contains($rName, 'lohnsteuer') || str_contains($purpose, 'lst') ? 'FA Potsdam Lohnsteuer'
                                            : (str_contains($rName, 'umsatzsteuer') || str_contains($purpose, 'ust') ? 'FA Potsdam Umsatzsteuer' : 'FA Potsdam');
                                    } elseif (str_contains($purpose, 'lohn/gehalt') || str_contains($payment->recipient?->name ?? '', ',')) {
                                        $category = 'Lohn & Gehalt';
                                    } else {
                                        foreach (['aok','tk','techniker','dak','ikk','sbk','bkk','bun','kkh','hek','big','hkk','pronova','barmer','viactiv','mobil','siemens','merck','bek','mhplus'] as $kw) {
                                            if (str_contains($rName, $kw)) { $category = 'Krankenkasse'; break; }
                                        }
                                    }
                                    $paidParts  = $payment->parts->sum('amount');
                                    $openAmount = $payment->amount - $paidParts;
                                @endphp

                                {{-- Teilzahlung Modal --}}
                                @if(!$payment->paid)
                                <div class="modal fade" id="addPartModal-{{ $payment->id }}" tabindex="-1">
                                    <div class="modal-dialog modal-dialog-centered">
                                        <div class="modal-content border-0 shadow">
                                            <div class="modal-header border-0 pb-0">
                                                <h5 class="modal-title fw-semibold">Teilzahlung – {{ $payment->recipient?->name }}</h5>
                                                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                                            </div>
                                            <form method="POST" action="{{ route('rechnungswesen.payments.paid_part', $payment) }}">
                                                @csrf
                                                <div class="modal-body">
                                                    <div class="d-flex gap-3 mb-3 small text-muted">
                                                        <span>Gesamt: <strong class="text-dark">{{ number_format($payment->amount, 2, ',', '.') }} €</strong></span>
                                                        <span>Bezahlt: <strong class="text-success">{{ number_format($paidParts, 2, ',', '.') }} €</strong></span>
                                                        <span>Offen: <strong class="text-danger">{{ number_format($openAmount, 2, ',', '.') }} €</strong></span>
                                                    </div>
                                                    <div class="mb-3">
                                                        <label class="form-label fw-semibold">Betrag</label>
                                                        <input type="number" step="0.01" name="amount" class="form-control" max="{{ $openAmount > 0 ? $openAmount : $payment->amount }}" required>
                                                    </div>
                                                    <div class="mb-3">
                                                        <label class="form-label fw-semibold">Zahlungsdatum</label>
                                                        <input type="date" name="paid_at" class="form-control" value="{{ now()->format('Y-m-d') }}">
                                                    </div>
                                                    <div class="mb-1">
                                                        <label class="form-label fw-semibold">Notiz (optional)</label>
                                                        <input type="text" name="note" class="form-control" maxlength="255">
                                                    </div>
                                                </div>
                                                <div class="modal-footer border-0">
                                                    <button class="btn btn-outline-secondary rounded-pill px-3" type="button" data-bs-dismiss="modal">Abbrechen</button>
                                                    <button class="btn btn-primary rounded-pill px-3" type="submit">Speichern</button>
                                                </div>
                                            </form>
                                        </div>
                                    </div>
                                </div>

                                {{-- Löschen Modal --}}
                                <div class="modal fade" id="deletePaymentModal-{{ $payment->id }}" tabindex="-1">
                                    <div class="modal-dialog modal-dialog-centered">
                                        <div class="modal-content border-0 shadow">
                                            <div class="modal-header border-0 pb-0">
                                                <h5 class="modal-title fw-semibold text-danger"><i class="bi bi-trash me-2"></i>Zahlung löschen</h5>
                                                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                                            </div>
                                            <div class="modal-body">
                                                <p><strong>{{ $payment->recipient?->name }}</strong> — {{ $payment->purpose }}</p>
                                                <p class="fw-semibold">{{ number_format($payment->amount, 2, ',', '.') }} € · {{ str_pad($payment->month, 2, '0', STR_PAD_LEFT) }}/{{ $payment->year }}</p>
                                                <p class="text-danger small mb-0"><i class="bi bi-exclamation-triangle me-1"></i>Dieser Vorgang kann nicht rückgängig gemacht werden.</p>
                                            </div>
                                            <div class="modal-footer border-0">
                                                <button class="btn btn-outline-secondary rounded-pill px-3" type="button" data-bs-dismiss="modal">Abbrechen</button>
                                                <form method="POST" action="{{ route('rechnungswesen.payments.destroy', $payment) }}" class="d-inline">
                                                    @csrf @method('DELETE')
                                                    <button class="btn btn-danger rounded-pill px-3" type="submit">Ja, löschen</button>
                                                </form>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                @endif

                                <tr>
                                    <td class="ps-3 fw-semibold">{{ $payment->recipient?->name }}</td>
                                    <td class="text-muted">{{ $payment->purpose }}</td>
                                    <td>
                                        <span class="badge bg-light text-dark border rounded-pill">{{ $category }}</span>
                                    </td>
                                    <td class="text-end fw-semibold">{{ number_format($payment->amount, 2, ',', '.') }} €</td>
                                    <td>
                                        @if($payment->paid)
                                            <span class="badge bg-success rounded-pill">bezahlt</span>
                                            <div class="text-muted small">{{ $payment->paid_at?->format('d.m.Y H:i') }}</div>
                                        @else
                                            <span class="badge bg-danger rounded-pill">offen</span>
                                            @if($payment->parts->count() > 0)
                                                <div class="mt-1 small">
                                                    @foreach($payment->parts as $part)
                                                        <div class="d-flex align-items-center gap-1 mb-1">
                                                            <form method="POST" action="{{ route('rechnungswesen.payments.parts.destroy', $part) }}" onsubmit="return confirm('Teilzahlung löschen?')">
                                                                @csrf @method('DELETE')
                                                                <button type="submit" class="btn btn-outline-danger rounded-circle p-0" style="width:18px;height:18px;font-size:.55rem;">
                                                                    <i class="bi bi-x"></i>
                                                                </button>
                                                            </form>
                                                            <span class="text-success">{{ number_format($part->amount, 2, ',', '.') }} €</span>
                                                            @if($part->paid_at)<span class="text-muted">· {{ $part->paid_at->format('d.m.Y') }}</span>@endif
                                                            @if($part->note)<span class="text-muted fst-italic">· {{ $part->note }}</span>@endif
                                                        </div>
                                                    @endforeach
                                                </div>
                                            @endif
                                        @endif
                                    </td>
                                    <td class="text-end pe-3">
                                        <div class="d-flex gap-1 justify-content-end">
                                            <form method="POST" action="{{ route('rechnungswesen.payments.togglePaid', $payment) }}">
                                                @csrf
                                                <button class="btn btn-sm rounded-pill px-2 {{ $payment->paid ? 'btn-outline-warning' : 'btn-outline-success' }}" type="submit">
                                                    {{ $payment->paid ? 'unbezahlt' : 'bezahlt' }}
                                                </button>
                                            </form>
                                            @if(!$payment->paid)
                                                <button class="btn btn-sm btn-outline-info rounded-pill px-2" data-bs-toggle="modal" data-bs-target="#addPartModal-{{ $payment->id }}">
                                                    Teilzahlung
                                                </button>
                                                <button class="btn btn-sm btn-outline-danger rounded-circle p-0" style="width:28px;height:28px;"
                                                    data-bs-toggle="modal" data-bs-target="#deletePaymentModal-{{ $payment->id }}">
                                                    <i class="bi bi-trash" style="font-size:.7rem;"></i>
                                                </button>
                                            @endif
                                        </div>
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>
                        <tfoot class="table-light">
                            <tr class="fw-semibold">
                                <td class="ps-3" colspan="3">{{ $items->count() }} Zahlungen</td>
                                <td class="text-end">{{ number_format($mTotal, 2, ',', '.') }} €</td>
                                <td><span class="text-success">{{ number_format($mPaid, 2, ',', '.') }} €</span> / <span class="text-danger">{{ number_format($mOpen, 2, ',', '.') }} €</span></td>
                                <td></td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>

    @empty
        <div class="card border-0 shadow-sm">
            <div class="card-body text-center py-5 text-muted">
                <i class="bi bi-inbox d-block fs-2 opacity-25 mb-2"></i>
                Keine Zahlungen vorhanden
            </div>
        </div>
    @endforelse

</div>

{{-- Modal: Import 320 --}}
<div class="modal fade" id="import320Modal" tabindex="-1">
    <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content border-0 shadow">
            <div class="modal-header border-0 pb-0">
                <h5 class="modal-title fw-semibold"><i class="bi bi-upload me-2 text-info"></i>Import – DATEV Datei 320</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form method="POST" action="{{ route('rechnungswesen.payments.import320') }}" enctype="multipart/form-data">
                @csrf
                <div class="modal-body">
                    <p class="text-muted small">Importiert Krankenkassen, FA Potsdam Lohnsteuer/Umsatzsteuer usw.</p>
                    <div class="mb-1">
                        <label class="form-label fw-semibold">320 Datei auswählen</label>
                        <input type="file" name="file_320" class="form-control" accept=".ans,.txt,.csv" required>
                    </div>
                </div>
                <div class="modal-footer border-0">
                    <button class="btn btn-outline-secondary rounded-pill px-3" data-bs-dismiss="modal">Abbrechen</button>
                    <button class="btn btn-info rounded-pill px-3" type="submit">Import starten</button>
                </div>
            </form>
        </div>
    </div>
</div>

{{-- Modal: Import 202 --}}
<div class="modal fade" id="import202Modal" tabindex="-1">
    <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content border-0 shadow">
            <div class="modal-header border-0 pb-0">
                <h5 class="modal-title fw-semibold"><i class="bi bi-upload me-2 text-warning"></i>Import – DATEV Datei 202</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form method="POST" action="{{ route('rechnungswesen.payments.import202') }}" enctype="multipart/form-data">
                @csrf
                <div class="modal-body">
                    <p class="text-muted small">Importiert Mitarbeiter-Lohnzahlungen aus der DÜ-Liste (202).</p>
                    <div class="mb-1">
                        <label class="form-label fw-semibold">202 Datei auswählen</label>
                        <input type="file" name="file_202" class="form-control" accept=".ans,.txt,.csv" required>
                    </div>
                </div>
                <div class="modal-footer border-0">
                    <button class="btn btn-outline-secondary rounded-pill px-3" data-bs-dismiss="modal">Abbrechen</button>
                    <button class="btn btn-warning rounded-pill px-3" type="submit">Import starten</button>
                </div>
            </form>
        </div>
    </div>
</div>

{{-- Modal: Neue Zahlung --}}
<div class="modal fade" id="createPaymentModal" tabindex="-1">
    <div class="modal-dialog modal-xl modal-dialog-centered">
        <div class="modal-content border-0 shadow">
            <div class="modal-header border-0 pb-0">
                <h5 class="modal-title fw-semibold"><i class="bi bi-plus-lg me-2 text-success"></i>Zahlungen für Monat/Jahr anlegen</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form method="POST" action="{{ route('rechnungswesen.payments.store') }}">
                @csrf
                <div class="modal-body">
                    <div class="row g-3 mb-3">
                        <div class="col-md-6">
                            <label class="form-label fw-semibold">Jahr</label>
                            <input type="number" name="year" class="form-control" value="{{ old('year', now()->year) }}" min="2000" max="2100" required>
                        </div>
                        <div class="col-md-6">
                            <label class="form-label fw-semibold">Monat</label>
                            <select name="month" class="form-select" required>
                                @for($m = 1; $m <= 12; $m++)
                                    <option value="{{ $m }}" {{ (int)old('month', now()->month) === $m ? 'selected' : '' }}>
                                        {{ str_pad($m, 2, '0', STR_PAD_LEFT) }}
                                    </option>
                                @endfor
                            </select>
                        </div>
                    </div>
                    <p class="text-muted small">Nur Zeilen mit einem Betrag &gt; 0 werden gespeichert.</p>
                    <div class="table-responsive">
                        <table class="table table-sm align-middle" style="font-size:0.85rem;">
                            <thead class="table-light">
                                <tr>
                                    <th>Empfänger</th>
                                    <th style="width:35%;">Verwendungszweck</th>
                                    <th style="width:15%;">Betrag</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($recipients->sortBy('id') as $i => $recipient)
                                    <tr>
                                        <td>
                                            {{ $recipient->name }}
                                            <input type="hidden" name="payments[{{ $i }}][recipient_id]" value="{{ $recipient->id }}">
                                        </td>
                                        <td>
                                            <input type="text" name="payments[{{ $i }}][purpose]" class="form-control form-control-sm" value="{{ old("payments.$i.purpose") }}" placeholder="z.B. 84984482">
                                        </td>
                                        <td>
                                            <input type="number" step="0.01" name="payments[{{ $i }}][amount]" class="form-control form-control-sm text-end" value="{{ old("payments.$i.amount") }}" placeholder="0,00">
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                    <p class="text-muted small mb-0">Bereits vorhandene Zahlungen für den gleichen Monat/Jahr werden nicht überschrieben.</p>
                </div>
                <div class="modal-footer border-0">
                    <button class="btn btn-outline-secondary rounded-pill px-3" type="button" data-bs-dismiss="modal">Abbrechen</button>
                    <button class="btn btn-success rounded-pill px-3" type="submit">Zahlungen speichern</button>
                </div>
            </form>
        </div>
    </div>
</div>

@if($errors->any())
<script>
    document.addEventListener('DOMContentLoaded', function () {
        new bootstrap.Modal(document.getElementById('createPaymentModal')).show();
    });
</script>
@endif

@endsection