{{-- resources/views/returns/index.blade.php --}}
@extends('layouts.app')

@section('title', 'Return History')

@section('content')
@php
    /**
     * Group returns by return_no (preferred).
     * If return_no missing, fallback grouping: type-party-date-note
     */
    $groups = collect($returns->items() ?? $returns)->groupBy(function ($r) {
        $key = $r->return_no ?? null;

        if ($key) return $key;

        $date = $r->date ? \Carbon\Carbon::parse($r->date)->format('Y-m-d') : 'no-date';
        $note = trim((string)($r->note ?? ''));
        return "{$r->type}-{$r->party_id}-{$date}-{$note}";
    });

    // nice group label helper
    $getPartyName = function($row) {
        if ($row->type === 'customer') return optional($row->customer)->name ?? '—';
        return optional($row->supplier)->name ?? '—';
    };

    $getTypeBadge = function($row) {
        if ($row->type === 'customer') {
            return '<span class="badge bg-success">Customer</span>';
        }
        return '<span class="badge bg-info text-dark">Supplier</span>';
    };
@endphp

<div class="d-flex justify-content-between align-items-center mb-3">
    <h1 class="h4 mb-0">Return History</h1>

    <div class="d-flex gap-2">
        <a href="{{ url()->previous() }}" class="btn btn-sm btn-outline-secondary">
            ← Back
        </a>

        <a href="{{ route('returns.create') }}" class="btn btn-sm btn-primary">
            + New Return
        </a>
    </div>
</div>

<div class="table-responsive">
    <table class="table table-bordered table-striped table-sm mb-0 align-middle">
        <thead class="table-dark">
            <tr>
                <th style="width:60px;">ID</th>
                <th style="width:120px;">Return No</th>
                <th style="width:100px;">Type</th>
                <th>Party</th>
                <th style="width:120px;">Date</th>
                <th class="text-end" style="width:140px;">Total</th>
                <th style="width:180px;">Note</th>
            </tr>
        </thead>

        <tbody>
        @forelse($groups as $groupKey => $rows)
            @php
                $first = $rows->first();
                $groupTotal = (float) $rows->sum('total');
                $partyName = $getPartyName($first);
                $dateLabel = $first->date ? \Carbon\Carbon::parse($first->date)->format('d-m-Y') : '-';
                $returnNo = $first->return_no ?? '—';
                $collapseId = 'ret_' . md5($groupKey);
            @endphp

            {{-- Header row --}}
            <tr class="table-secondary" style="cursor:pointer;"
                data-bs-toggle="collapse"
                data-bs-target="#{{ $collapseId }}"
                aria-expanded="false"
                aria-controls="{{ $collapseId }}">
                <td>{{ $first->id }}</td>

                <td>
                    <strong>{{ $returnNo }}</strong>
                </td>

                <td>{!! $getTypeBadge($first) !!}</td>

                <td>
                    <strong>{{ $partyName }}</strong>
                    <div class="text-muted small">
                        {{ $first->type === 'customer' ? 'From Customer (Return In)' : 'To Supplier (Return Out)' }}
                    </div>
                </td>

                <td>{{ $dateLabel }}</td>

                <td class="text-end">
                    <strong>{{ number_format($groupTotal, 2) }}</strong>
                </td>

                <td>
                    {{ $first->note ?? '-' }}
                    <div class="text-muted small">
                        Click to view items
                    </div>
                </td>
            </tr>

            {{-- Items row (collapse) --}}
            <tr class="collapse" id="{{ $collapseId }}">
                <td colspan="7" class="p-0">
                    <table class="table mb-0 table-bordered">
                        <thead class="table-light">
                            <tr>
                                <th style="width:50%;">Product</th>
                                <th class="text-end" style="width:10%;">Qty</th>
                                <th class="text-end" style="width:20%;">Unit Price</th>
                                <th class="text-end" style="width:20%;">Line Total</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($rows as $item)
                                <tr>
                                    <td>
                                        {{ optional($item->product)->name ?? '—' }}
                                        <div class="text-muted small">
                                            Product ID: {{ $item->product_id }}
                                        </div>
                                    </td>
                                    <td class="text-end">{{ (int) $item->qty }}</td>
                                    <td class="text-end">{{ number_format((float)$item->unit_price, 2) }}</td>
                                    <td class="text-end">{{ number_format((float)$item->total, 2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="4" class="text-center text-muted">No items</td>
                                </tr>
                            @endforelse
                        </tbody>
                        <tfoot class="table-light">
                            <tr>
                                <th colspan="3" class="text-end">Grand Total</th>
                                <th class="text-end">{{ number_format($groupTotal, 2) }}</th>
                            </tr>
                        </tfoot>
                    </table>
                </td>
            </tr>

        @empty
            <tr>
                <td colspan="7" class="text-center text-muted">
                    No returns found.
                </td>
            </tr>
        @endforelse
        </tbody>
    </table>
</div>

{{-- Pagination --}}
@if(method_exists($returns, 'links'))
    <div class="mt-3">
        {{ $returns->links() }}
    </div>
@endif
@endsection