@extends('layouts.app', ['title' => 'Offene Posten Bericht'])
@section('content')

@php
    $totalWarnings        = 0.0;
    $totalPayments        = 0.0;
    $bruttoSum            = 0.0;
    $paymentDifference    = 0.0;
    $sumBruttoWithWarnings = 0.0;
    $sumPaymentDifference  = 0.0;
    $sumPayment            = 0.0;
    $sumTax                = 0.0;

    if (!empty($costCentres)) {
        $sortedCostCentres = $costCentres->sortByDesc(function ($item) {
            $w = $item->outgoing_invoices->reduce(fn($c, $inv) => $c + $inv->get_warning->sum('total'), 0);
            $p = $item->outgoing_invoices->reduce(fn($c, $inv) => $inv->is_paid ? $c + $inv->total : $c + $inv->get_payments->sum('amount'), 0);
            return $item->outgoing_invoices->sum('total') - $p + $w;
        });

        foreach ($sortedCostCentres as $item) {
            $w = $item->outgoing_invoices->reduce(fn($c, $inv) => $c + $inv->get_warning->sum('total'), 0);
            $p = $item->outgoing_invoices->reduce(fn($c, $inv) => $inv->is_paid ? $c + $inv->total : $c + $inv->get_payments->sum('amount'), 0);
            $b = $item->outgoing_invoices->sum('total');
            $sumPayment            += $p;
            $sumBruttoWithWarnings += $b + $w;
            $sumPaymentDifference  += $b - $p + $w;
            $sumTax                += $item->outgoing_invoices->sum('tax');
        }
    }
@endphp

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

    <div class="d-flex align-items-center mb-4">
        <h4 class="fw-bold mb-0"><i class="bi bi-journal-text me-2 text-primary"></i>Offene Posten Bericht</h4>
    </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(!empty($costCentres))

        {{-- Stat Cards --}}
        <div class="row g-3 mb-4">
            <div class="col-md-3">
                <div class="card border-0 shadow-sm h-100">
                    <div class="card-body">
                        <div class="text-muted small mb-1">Summe MwSt.</div>
                        <h3 class="fw-bold mb-0">{{ number_format($sumTax, 2, ',', '.') }} €</h3>
                        <div class="mt-2 rounded" style="height:4px;background:#6c757d;"></div>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card border-0 shadow-sm h-100">
                    <div class="card-body">
                        <div class="text-muted small mb-1">Brutto + Mahngebühren</div>
                        <h3 class="fw-bold mb-0">{{ number_format($sumBruttoWithWarnings, 2, ',', '.') }} €</h3>
                        <div class="mt-2 rounded" style="height:4px;background:#0d6efd;"></div>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card border-0 shadow-sm h-100">
                    <div class="card-body">
                        <div class="text-muted small mb-1">Zahlungseingang</div>
                        <h3 class="fw-bold mb-0 text-success">{{ number_format($sumPayment, 2, ',', '.') }} €</h3>
                        <div class="mt-2 rounded" style="height:4px;background:#198754;"></div>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card border-0 shadow-sm h-100">
                    <div class="card-body">
                        <div class="text-muted small mb-1">Zahlungs-Differenz (offen)</div>
                        <h3 class="fw-bold mb-0 {{ $sumPaymentDifference > 0 ? 'text-danger' : 'text-success' }}">
                            {{ number_format($sumPaymentDifference, 2, ',', '.') }} €
                        </h3>
                        <div class="mt-2 rounded" style="height:4px;background:{{ $sumPaymentDifference > 0 ? '#dc3545' : '#198754' }};"></div>
                    </div>
                </div>
            </div>
        </div>

        {{-- Tabelle --}}
        <div class="card border-0 shadow-sm">
            <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" style="width:180px;">Rg.empfänger</th>
                            <th>KST / Projekt</th>
                            <th>ltz. Rg.Nr.</th>
                            <th>ltz. Rg.Datum</th>
                            <th class="text-end">Netto</th>
                            <th class="text-end">MwSt.</th>
                            <th class="text-end">Brutto</th>
                            <th class="text-end text-danger">Mahnungen</th>
                            <th class="text-end text-success">Zahlung</th>
                            <th class="text-end pe-3">Differenz</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($sortedCostCentres as $idx => $item)
                            @php
                                $w  = $item->outgoing_invoices->reduce(fn($c, $inv) => $c + $inv->get_warning->sum('total'), 0);
                                $p  = $item->outgoing_invoices->reduce(fn($c, $inv) => $inv->is_paid ? $c + $inv->total : $c + $inv->get_payments->sum('amount'), 0);
                                $b  = $item->outgoing_invoices->sum('total');
                                $diff = $b - $p + $w;
                                $totalBudgetSum = $item->projects->sum('budget_total') + $item->order_spares->sum('budget_total') + $item->order_repairs->sum('budget_total');
                            @endphp
                            {{-- Hauptzeile --}}
                            <tr class="fw-semibold" style="cursor:pointer;" onclick="toggleDetail('detail-{{ $idx }}', this)">
                                <td class="ps-3">
                                    <i class="bi bi-chevron-right me-1 toggle-icon" style="font-size:.7rem;transition:transform .2s;"></i>
                                    {{ $item->outgoing_invoices->first()->customer->name }}
                                </td>
                                <td>
                                    <span class="text-primary">{{ $item->number ?? $item->old_number }}</span>
                                    – {{ $item->name }}
                                </td>
                                <td class="text-muted">{{ $item->outgoing_invoices->last()->invoice_nr }}</td>
                                <td class="text-muted">{{ date('d.m.Y', strtotime($item->outgoing_invoices->last()->invoice_date)) }}</td>
                                <td class="text-end">{{ number_format($item->outgoing_invoices->sum('subtotal'), 2, ',', '.') }} €</td>
                                <td class="text-end text-muted">{{ number_format($item->outgoing_invoices->sum('tax'), 2, ',', '.') }} €</td>
                                <td class="text-end">{{ number_format($b, 2, ',', '.') }} €</td>
                                <td class="text-end text-danger">
                                    @if($w > 0){{ number_format($w, 2, ',', '.') }} €@else<span class="text-muted">—</span>@endif
                                </td>
                                <td class="text-end text-success">
                                    @if($p > 0){{ number_format($p, 2, ',', '.') }} €@else<span class="text-muted">—</span>@endif
                                </td>
                                <td class="text-end pe-3">
                                    <span class="{{ $diff < 0 ? 'text-warning' : ($diff == 0 ? 'text-success' : 'text-danger') }} fw-bold">
                                        {{ number_format($diff, 2, ',', '.') }} €
                                    </span>
                                    @if($diff < 0)<br><small class="text-danger">Überbezahlung!</small>@endif
                                </td>
                            </tr>
                            {{-- Detail-Zeile --}}
                            <tr id="detail-{{ $idx }}" style="display:none;">
                                <td colspan="10" class="p-0">
                                    <div class="p-3 bg-light border-top border-bottom">

                                        {{-- Info-Zeile --}}
                                        <div class="d-flex gap-4 mb-3 small text-muted">
                                            <span>ID: {{ $item->id }}</span>
                                            <span>Kst. Auftragssumme Netto: <strong class="text-dark">{{ number_format($totalBudgetSum, 2, ',', '.') }} €</strong></span>
                                            <span>Zahlungseingang: <strong class="text-success">{{ number_format($p, 2, ',', '.') }} €</strong></span>
                                            <span>Kst. Differenz: <strong class="text-danger">{{ number_format($totalBudgetSum - $p + $w, 2, ',', '.') }} €</strong></span>
                                        </div>

                                        <div class="row g-3">
                                            {{-- Rechnungen --}}
                                            <div class="col-lg-6">
                                                <div class="fw-semibold small mb-2"><i class="bi bi-receipt me-1 text-primary"></i>Rechnungen</div>
                                                <table class="table table-sm table-bordered bg-white mb-0" style="font-size:0.8rem;">
                                                    <thead class="table-light">
                                                        <tr>
                                                            <th>Rechnung</th>
                                                            <th>Betreff</th>
                                                            <th>Datum</th>
                                                            <th>Frist</th>
                                                            <th class="text-end">Betrag</th>
                                                            <th class="text-end">Status</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @foreach($item->outgoing_invoices as $invoice)
                                                            <tr>
                                                                <td><a href="{{ route('accounting.outgoing-invoice.show', ['id' => $invoice->id]) }}" target="_blank">{{ $invoice->invoice_nr }}</a></td>
                                                                <td>{{ $invoice->title }}</td>
                                                                <td>{{ date('d.m.Y', strtotime($invoice->invoice_date)) }}</td>
                                                                <td>{{ date('d.m.Y', strtotime($invoice->expiry_date)) }}</td>
                                                                <td class="text-end">{{ number_format($invoice->total, 2, ',', '.') }} €</td>
                                                                <td class="text-end">
                                                                    @if($invoice->is_paid)
                                                                        <span class="badge bg-success rounded-pill">bezahlt</span>
                                                                    @else
                                                                        <span class="badge bg-danger rounded-pill">offen</span>
                                                                    @endif
                                                                </td>
                                                            </tr>
                                                        @endforeach
                                                    </tbody>
                                                </table>
                                            </div>
                                            {{-- Mahnungen --}}
                                            <div class="col-lg-3">
                                                <div class="fw-semibold small mb-2 text-danger"><i class="bi bi-exclamation-triangle me-1"></i>Mahnungen</div>
                                                <table class="table table-sm table-bordered bg-white mb-0" style="font-size:0.8rem;">
                                                    <thead class="table-light">
                                                        <tr>
                                                            <th>Datum</th>
                                                            <th>Frist bis</th>
                                                            <th class="text-end">Gebühr</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @forelse($item->outgoing_invoices->flatMap(fn($inv) => $inv->get_warning) as $witem)
                                                            <tr>
                                                                <td>{{ date('d.m.Y', strtotime($witem->income_date)) }}</td>
                                                                <td>{{ date('d.m.Y', strtotime($witem->expiry_date)) }}</td>
                                                                <td class="text-end text-danger">{{ number_format($witem->total, 2, ',', '.') }} €</td>
                                                            </tr>
                                                        @empty
                                                            <tr><td colspan="3" class="text-center text-muted small py-2">Keine Mahnungen</td></tr>
                                                        @endforelse
                                                    </tbody>
                                                </table>
                                            </div>
                                            {{-- Zahlungen --}}
                                            <div class="col-lg-3">
                                                <div class="fw-semibold small mb-2 text-success"><i class="bi bi-cash-coin me-1"></i>Zahlungseingänge</div>
                                                <table class="table table-sm table-bordered bg-white mb-0" style="font-size:0.8rem;">
                                                    <thead class="table-light">
                                                        <tr>
                                                            <th class="text-end">Betrag</th>
                                                            <th>Datum</th>
                                                            <th>Methode</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @forelse($item->outgoing_invoices->flatMap(fn($inv) => $inv->get_payments) as $pitem)
                                                            <tr>
                                                                <td class="text-end text-success">{{ number_format($pitem->amount, 2, ',', '.') }} €</td>
                                                                <td>{{ date('d.m.Y', strtotime($pitem->payment_date)) }}</td>
                                                                <td>{{ $pitem->get_payment_method->name }}</td>
                                                            </tr>
                                                        @empty
                                                            <tr><td colspan="3" class="text-center text-muted small py-2">Keine Zahlungen</td></tr>
                                                        @endforelse
                                                    </tbody>
                                                </table>
                                            </div>
                                        </div>
                                    </div>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot class="table-light fw-semibold">
                        <tr>
                            <td class="ps-3" colspan="4">Gesamt ({{ $sortedCostCentres->count() }} Kostenstellen)</td>
                            <td class="text-end" colspan="3">{{ number_format($sumBruttoWithWarnings, 2, ',', '.') }} €</td>
                            <td class="text-end text-danger">—</td>
                            <td class="text-end text-success">{{ number_format($sumPayment, 2, ',', '.') }} €</td>
                            <td class="text-end pe-3 {{ $sumPaymentDifference > 0 ? 'text-danger' : 'text-success' }}">
                                {{ number_format($sumPaymentDifference, 2, ',', '.') }} €
                            </td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>

    @else
        <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 Daten vorhanden
            </div>
        </div>
    @endif

</div>

<script>
function toggleDetail(id, row) {
    const detail = document.getElementById(id);
    const icon   = row.querySelector('.toggle-icon');
    const open   = detail.style.display === 'none' || detail.style.display === '';
    detail.style.display = open ? 'table-row' : 'none';
    if (icon) icon.style.transform = open ? 'rotate(90deg)' : 'rotate(0deg)';
}
</script>

@endsection