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

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

@section('content')
@php
    use Carbon\Carbon;

    // Opening balance
    $opening = (float) ($supplier->opening_balance ?? 0);

    // Purchases summary
    $totalPurchases = (float) ($purchases?->sum('total') ?? 0);
    $totalPaidInPurchases = (float) ($purchases?->sum('paid') ?? 0);

    // ✅ Payment history sum (যদি controller থেকে $payments আসে)
    $totalPaidPayments = (float) ($payments?->sum('amount') ?? 0);

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

    /**
     * ✅ Current Due হিসাব:
     * Opening + Total Purchases - (Total Paid from Payments OR Purchases) - Returns
     *
     * এখানে priority দিচ্ছি Payment History sum কে,
     * কারণ তুমি payments module দিয়ে টাকা দিচ্ছো।
     * যদি payments না থাকে (খালি), তখন purchases->paid ধরবে।
     */
    $paidForDue = $totalPaidPayments > 0 ? $totalPaidPayments : $totalPaidInPurchases;

    $currentDue = $opening + $totalPurchases - $paidForDue - $totalReturns;

    if ($currentDue < 0) $currentDue = 0; // safeguard
@endphp

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

    <div class="text-end">
        <div><strong>Opening Balance:</strong> {{ number_format($opening, 2) }}</div>
        <div><strong>Total Purchases:</strong> {{ number_format($totalPurchases, 2) }}</div>

        {{-- ✅ Paid breakdown --}}
        <div><strong>Total Paid (Payments):</strong> {{ number_format($totalPaidPayments, 2) }}</div>
        <div class="text-muted small">
            Paid (from Purchases table): {{ number_format($totalPaidInPurchases, 2) }}
        </div>

        <div><strong>Total Returns:</strong> {{ number_format($totalReturns, 2) }}</div>

        <div class="mt-1">
            <strong>Current Due:</strong>
            <span class="badge bg-warning text-dark">
                {{ number_format($currentDue, 2) }}
            </span>
        </div>
    </div>
</div>

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

{{-- 🔸 Purchase History --}}
<div class="card mb-4">
    <div class="card-header">
        <strong>Purchase History</strong>
    </div>
    <div class="card-body p-0">
        @if(($purchases?->isEmpty() ?? true))
            <p class="p-3 mb-0 text-muted">No purchases from this supplier 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($purchases as $purchase)
                        <tr class="table-secondary">
                            <td>{{ $purchase->date ? Carbon::parse($purchase->date)->format('d-m-Y') : '-' }}</td>
                            <td>{{ $purchase->invoice_no }}</td>
                            <td class="text-end">{{ number_format($purchase->total ?? 0, 2) }}</td>
                            <td class="text-end">{{ number_format($purchase->paid ?? 0, 2) }}</td>
                            <td class="text-end">{{ number_format($purchase->due ?? 0, 2) }}</td>
                            <td>
                                @if(($purchase->status ?? null) === 'paid')
                                    <span class="badge bg-success">Paid</span>
                                @else
                                    <span class="badge bg-warning text-dark">Due</span>
                                @endif
                            </td>
                            <td>
                                {{ $purchase->next_due_date ? Carbon::parse($purchase->next_due_date)->format('d-m-Y') : '-' }}
                            </td>
                        </tr>

                        {{-- Purchase 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($purchase->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 d-flex justify-content-between align-items-center">
        <strong>Payment History</strong>
        <span class="small text-muted">
            Total: {{ number_format($totalPaidPayments, 2) }}
        </span>
    </div>

    <div class="card-body p-0">
        @if(($payments?->isEmpty() ?? true))
            <p class="p-3 mb-0 text-muted">
                No payments to this supplier yet.
                <br>
                <span class="small text-muted">
                    (Tip: PaymentController এ `type` mismatch থাকলে এখানে দেখাবে না)
                </span>
            </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::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() ?? true))
            <p class="p-3 mb-0 text-muted">No return entries for this supplier.</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 ? (is_string($r->date) ? Carbon::parse($r->date)->format('d-m-Y') : $r->date->format('d-m-Y')) : '-' }}
                            </td>
                            <td>{{ optional($r->product)->name ?? '—' }}</td>
                            <td class="text-end">{{ $r->qty ?? 0 }}</td>
                            <td class="text-end">{{ number_format($r->unit_price ?? 0, 2) }}</td>
                            <td class="text-end">{{ number_format($r->total ?? 0, 2) }}</td>
                            <td>{{ $r->note ?? '-' }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @endif
    </div>
</div>
@endsection