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

@section('title', $customer->name)

@section('content')
@php
    $opening = (float) ($customer->opening_balance ?? 0);

    $totalSales = isset($sales) ? (float) $sales->sum('total') : 0;
    $totalPaid  = isset($sales) ? (float) $sales->sum('paid')  : 0;

    $totalReturns = (float) $returns->sum('total');

    $currentDue = $opening + $totalSales - $totalPaid - $totalReturns;
@endphp

<div class="d-flex justify-content-between align-items-center mb-3">
    <div>
        <h3 class="mb-1">{{ $customer->name }}</h3>
        <div class="text-muted">
            Phone: {{ $customer->phone ?? '-' }}
            | Address: {{ $customer->address ?? '-' }}
        </div>
    </div>

    <div class="text-end">
        <div><strong>Opening Balance:</strong> {{ number_format($opening, 2) }}</div>
        <div><strong>Total Sales:</strong> {{ number_format($totalSales, 2) }}</div>
        <div><strong>Total Paid:</strong> {{ number_format($totalPaid, 2) }}</div>
        <div><strong>Total Returns:</strong> {{ number_format($totalReturns, 2) }}</div>
        <div>
            <strong>Current Due:</strong>
            <span class="badge bg-warning text-dark">
                {{ number_format($currentDue, 2) }}
            </span>
        </div>
    </div>
</div>

<a href="{{ route('customers.index') }}" class="btn btn-sm btn-secondary mb-3">
    ← Back to Customers
</a>

{{-- 🔸 Sales History --}}
<div class="card mb-4">
    <div class="card-header">
        <strong>Sales History</strong>
    </div>

    <div class="card-body p-0">
        @if($sales->isEmpty())
            <p class="p-3 mb-0 text-muted">No sales for this customer yet.</p>
        @else
            <table class="table mb-0">
                <thead class="table-light">
                    <tr>
                        <th style="width:110px;">Date</th>
                        <th style="width:180px;">Invoice</th>
                        <th class="text-end" style="width:120px;">Total</th>
                        <th class="text-end" style="width:120px;">Paid</th>
                        <th class="text-end" style="width:120px;">Due</th>
                        <th style="width:90px;">Status</th>
                        <th style="width:110px;">Next Due</th>
                        <th>Items</th>
                    </tr>
                </thead>

                <tbody>
                    @foreach($sales as $sale)
                        @php $collapseId = 'sale_items_' . $sale->id; @endphp

                        <tr>
                            <td>{{ $sale->date ? \Carbon\Carbon::parse($sale->date)->format('d-m-Y') : '-' }}</td>
                            <td>{{ $sale->invoice_no }}</td>
                            <td class="text-end">{{ number_format($sale->total ?? 0, 2) }}</td>
                            <td class="text-end">{{ number_format($sale->paid ?? 0, 2) }}</td>
                            <td class="text-end">{{ number_format($sale->due ?? 0, 2) }}</td>
                            <td>
                                @if($sale->status === 'paid')
                                    <span class="badge bg-success">Paid</span>
                                @else
                                    <span class="badge bg-warning text-dark">Due</span>
                                @endif
                            </td>
                            <td>
                                {{ $sale->next_due_date ? \Carbon\Carbon::parse($sale->next_due_date)->format('d-m-Y') : '-' }}
                            </td>

                            <td class="text-muted">
                                <a class="text-decoration-none"
                                   data-bs-toggle="collapse"
                                   href="#{{ $collapseId }}"
                                   role="button"
                                   aria-expanded="false"
                                   aria-controls="{{ $collapseId }}">
                                    Click to view items
                                </a>
                            </td>
                        </tr>

                        <tr class="collapse" id="{{ $collapseId }}">
                            <td colspan="8" class="bg-light">
                                @if($sale->items->isEmpty())
                                    <span class="text-muted">No items found.</span>
                                @else
                                    <div class="table-responsive">
                                        <table class="table table-sm table-bordered mb-0">
                                            <thead class="table-secondary">
                                                <tr>
                                                    <th>Product</th>
                                                    <th class="text-end" style="width:80px;">Qty</th>
                                                    <th class="text-end" style="width:120px;">Price</th>
                                                    <th class="text-end" style="width:130px;">Line Total</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($sale->items as $it)
                                                    <tr>
                                                        <td>{{ $it->product->name ?? 'Deleted product' }}</td>
                                                        <td class="text-end">{{ $it->qty }}</td>
                                                        <td class="text-end">{{ number_format((float)($it->price ?? 0), 2) }}</td>
                                                        <td class="text-end">{{ number_format((float)(($it->line_total ?? 0) ?: (($it->qty ?? 0) * ($it->price ?? 0))), 2) }}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                @endif
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @endif
    </div>
</div>

{{-- 🔹 Payment History (same style: Click to view details) --}}
<div class="card mb-4">
    <div class="card-header">
        <strong>Payment History</strong>
    </div>

    <div class="card-body p-0">
        @if($payments->isEmpty())
            <p class="p-3 mb-0 text-muted">No payments from this customer yet.</p>
        @else
            <table class="table mb-0">
                <thead class="table-light">
                    <tr>
                        <th style="width:110px;">Date</th>
                        <th style="width:140px;">Method</th>
                        <th class="text-end" style="width:140px;">Amount</th>
                        <th style="width:160px;">Ref No</th>
                        <th>Note</th>
                        <th style="width:160px;">Details</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($payments as $pay)
                        @php $payCollapse = 'pay_details_' . $pay->id; @endphp

                        <tr>
                            <td>{{ $pay->date ? \Carbon\Carbon::parse($pay->date)->format('d-m-Y') : '-' }}</td>
                            <td>{{ $pay->method ?? '-' }}</td>
                            <td class="text-end">{{ number_format((float)($pay->amount ?? 0), 2) }}</td>
                            <td>{{ $pay->ref_no ?? '-' }}</td>
                            <td>{{ $pay->note ?? '-' }}</td>
                            <td class="text-muted">
                                <a class="text-decoration-none"
                                   data-bs-toggle="collapse"
                                   href="#{{ $payCollapse }}"
                                   role="button"
                                   aria-expanded="false"
                                   aria-controls="{{ $payCollapse }}">
                                    Click to view details
                                </a>
                            </td>
                        </tr>

                        <tr class="collapse" id="{{ $payCollapse }}">
                            <td colspan="6" class="bg-light">
                                <div class="p-2">
                                    <div class="row g-2 small">
                                        <div class="col-md-3"><strong>Date:</strong> {{ $pay->date ? \Carbon\Carbon::parse($pay->date)->format('d-m-Y') : '-' }}</div>
                                        <div class="col-md-3"><strong>Method:</strong> {{ $pay->method ?? '-' }}</div>
                                        <div class="col-md-3"><strong>Amount:</strong> {{ number_format((float)($pay->amount ?? 0), 2) }}</div>
                                        <div class="col-md-3"><strong>Ref:</strong> {{ $pay->ref_no ?? '-' }}</div>
                                        <div class="col-12"><strong>Note:</strong> {{ $pay->note ?? '-' }}</div>
                                    </div>
                                </div>
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @endif
    </div>
</div>

{{-- 🔥 Return History (same style: Click to view items) --}}
<div class="card mb-4">
    <div class="card-header">
        <strong>Return History</strong>
    </div>

    <div class="card-body p-0">
        @if($returns->isEmpty())
            <p class="p-3 mb-0 text-muted">No return entries for this customer.</p>
        @else
            <table class="table mb-0">
                <thead class="table-light">
                    <tr>
                        <th style="width:110px;">Date</th>
                        <th style="width:140px;">Type</th>
                        <th class="text-end" style="width:140px;">Total</th>
                        <th>Note</th>
                        <th style="width:160px;">Items</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($returns as $r)
                        @php $retCollapse = 'ret_items_' . $r->id; @endphp

                        <tr>
                            <td>
                                @if($r->date)
                                    {{ $r->date instanceof \Carbon\Carbon ? $r->date->format('d-m-Y') : \Carbon\Carbon::parse($r->date)->format('d-m-Y') }}
                                @else
                                    -
                                @endif
                            </td>
                            <td>{{ $r->type ?? 'customer' }}</td>
                            <td class="text-end">{{ number_format((float)($r->total ?? 0), 2) }}</td>
                            <td>{{ $r->note ?? '-' }}</td>
                            <td class="text-muted">
                                <a class="text-decoration-none"
                                   data-bs-toggle="collapse"
                                   href="#{{ $retCollapse }}"
                                   role="button"
                                   aria-expanded="false"
                                   aria-controls="{{ $retCollapse }}">
                                    Click to view items
                                </a>
                            </td>
                        </tr>

                        <tr class="collapse" id="{{ $retCollapse }}">
                            <td colspan="5" class="bg-light">
                                @php
                                    // ✅ Supports both: $r->items (grouped return) OR single-row return ($r->product)
                                    $hasItemsRelation = isset($r->items);
                                @endphp

                                @if($hasItemsRelation && $r->items && $r->items->count())
                                    <div class="table-responsive">
                                        <table class="table table-sm table-bordered mb-0">
                                            <thead class="table-secondary">
                                                <tr>
                                                    <th>Product</th>
                                                    <th class="text-end" style="width:80px;">Qty</th>
                                                    <th class="text-end" style="width:120px;">Unit Price</th>
                                                    <th class="text-end" style="width:130px;">Total</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($r->items as $it)
                                                    <tr>
                                                        <td>{{ $it->product->name ?? 'Deleted product' }}</td>
                                                        <td class="text-end">{{ $it->qty }}</td>
                                                        <td class="text-end">{{ number_format((float)($it->unit_price ?? 0), 2) }}</td>
                                                        <td class="text-end">{{ number_format((float)($it->total ?? (($it->qty ?? 0) * ($it->unit_price ?? 0))), 2) }}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                @else
                                    {{-- fallback (your old return structure: one row = one product) --}}
                                    <div class="table-responsive">
                                        <table class="table table-sm table-bordered mb-0">
                                            <thead class="table-secondary">
                                                <tr>
                                                    <th>Product</th>
                                                    <th class="text-end" style="width:80px;">Qty</th>
                                                    <th class="text-end" style="width:120px;">Unit Price</th>
                                                    <th class="text-end" style="width:130px;">Total</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <tr>
                                                    <td>{{ optional($r->product)->name ?? '—' }}</td>
                                                    <td class="text-end">{{ $r->qty ?? 0 }}</td>
                                                    <td class="text-end">{{ number_format((float)($r->unit_price ?? 0), 2) }}</td>
                                                    <td class="text-end">{{ number_format((float)($r->total ?? 0), 2) }}</td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                @endif
                            </td>
                        </tr>

                    @endforeach
                </tbody>
            </table>
        @endif
    </div>
</div>

@endsection