@extends('layouts.master')

@section('content')
<div class="container-fluid">
    <h1 class="h3 mb-3 text-gray-800">Customer Statements</h1>
    <form class="form-inline mb-3">
        <input class="form-control mr-2" name="search" value="{{ $search }}" placeholder="Customer name">
        <button class="btn btn-primary">Filter</button>
    </form>
    <div class="card shadow">
        <div class="card-body table-responsive">
            <table class="table table-sm table-bordered">
                <thead><tr><th>Customer</th><th>Total Invoiced</th><th>Total Received</th><th>Outstanding</th><th>Last Transaction</th></tr></thead>
                <tbody>
                    @foreach($customers as $customer)
                        <tr>
                            <td><a href="{{ route('reports.customer-statement.show', $customer->id) }}">{{ $customer->customer_name }}</a></td>
                            <td class="text-right">{{ number_format((float) $customer->total_invoiced, 2) }}</td>
                            <td class="text-right">{{ number_format((float) $customer->total_received, 2) }}</td>
                            <td class="text-right">
                                @foreach(($customerBalances[$customer->id] ?? []) as $code => $amount)
                                    <div>{{ $code }} {{ number_format((float) $amount, 2) }}</div>
                                @endforeach
                            </td>
                            <td>{{ $customer->last_transaction_date }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
            {{ $customers->links() }}
        </div>
    </div>
</div>
@endsection