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

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

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

    // সব সেল controller থেকে $sales হিসেবে আসছে (DESC order)
    $totalSales = isset($sales) ? (float) $sales->sum('total') : 0;
    $totalPaid  = isset($sales) ? (float) $sales->sum('paid')  : 0;

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

    // Final হিসাব:
    // Opening + Total sales - Total paid - customer returns
    $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>Date</th>
                        <th>Invoice</th>
                        <th class="text-end">Total</th>
                        <th class="text-end">Paid</th>
                        <th class="text-end">Due</th>
                        <th>Status</th>
                        <th>Next Due</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($sales as $sale)
                        <tr class="table-secondary">
                            <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>
                        </tr>

                        {{-- Sale Items --}}
                        <tr>
                            <td colspan="7" class="p-0">
                                <table class="table mb-0">
                                    <thead>
                                        <tr>
                                            <th style="width: 40%;">&nbsp;&nbsp;Product</th>
                                            <th class="text-end" style="width: 10%;">Qty</th>
                                            <th class="text-end" style="width: 15%;">Price</th>
                                            <th class="text-end" style="width: 15%;">Line Total</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse($sale->items as $item)
                                            <tr>
                                                <td>&nbsp;&nbsp;{{ $item->product->name ?? '—' }}</td>
                                                <td class="text-end">{{ $item->qty }}</td>
                                                <td class="text-end">{{ number_format($item->price ?? 0, 2) }}</td>
                                                <td class="text-end">{{ number_format($item->line_total ?? 0, 2) }}</td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="4" class="text-muted">&nbsp;&nbsp;No items</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @endif
    </div>
</div>

{{-- 🔹 Payment History --}}
<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>Date</th>
                        <th>Method</th>
                        <th class="text-end">Amount</th>
                        <th>Ref No</th>
                        <th>Note</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($payments as $pay)
                        <tr>
                            <td>{{ $pay->date ? \Carbon\Carbon::parse($pay->date)->format('d-m-Y') : '-' }}</td>
                            <td>{{ $pay->method }}</td>
                            <td class="text-end">{{ number_format($pay->amount ?? 0, 2) }}</td>
                            <td>{{ $pay->ref_no ?? '-' }}</td>
                            <td>{{ $pay->note ?? '-' }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @endif
    </div>
</div>

{{-- 🔥 Return History --}}
<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>Date</th>
                        <th>Product</th>
                        <th class="text-end">Qty</th>
                        <th class="text-end">Unit Price</th>
                        <th class="text-end">Total</th>
                        <th>Note</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($returns as $r)
                        <tr>
                            <td>{{ $r->date ? $r->date->format('d-m-Y') : '-' }}</td>
                            <td>{{ optional($r->product)->name ?? '—' }}</td>
                            <td class="text-end">{{ $r->qty }}</td>
                            <td class="text-end">{{ number_format($r->unit_price, 2) }}</td>
                            <td class="text-end">{{ number_format($r->total, 2) }}</td>
                            <td>{{ $r->note ?? '-' }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @endif
    </div>
</div>

@endsection