@extends('layouts.app')
@section('title', 'Balance Sheet')
@section('content')
<h4 class="mb-3">Balance Sheet</h4>
<form class="row g-2 mb-3">
    <div class="col-auto"><label class="col-form-label">As of</label></div>
    <div class="col-auto"><input type="date" name="as_of" value="{{ $asOf }}" class="form-control"></div>
    <div class="col-auto"><button class="btn btn-dark">Filter</button></div>
</form>

<div class="row">
    <div class="col-md-4">
        <h6>Assets</h6>
        <table class="table bg-white table-sm">
            @foreach ($assets as $name => $amount)
            <tr><td>{{ $name }}</td><td class="text-end">{{ number_format($amount,2) }}</td></tr>
            @endforeach
            <tr class="fw-bold"><td>Total Assets</td><td class="text-end">{{ number_format($assets->sum(),2) }}</td></tr>
        </table>
    </div>
    <div class="col-md-4">
        <h6>Liabilities</h6>
        <table class="table bg-white table-sm">
            @foreach ($liabilities as $name => $amount)
            <tr><td>{{ $name }}</td><td class="text-end">{{ number_format($amount,2) }}</td></tr>
            @endforeach
            <tr class="fw-bold"><td>Total Liabilities</td><td class="text-end">{{ number_format($liabilities->sum(),2) }}</td></tr>
        </table>
    </div>
    <div class="col-md-4">
        <h6>Equity</h6>
        <table class="table bg-white table-sm">
            @foreach ($equity as $name => $amount)
            <tr><td>{{ $name }}</td><td class="text-end">{{ number_format($amount,2) }}</td></tr>
            @endforeach
            <tr><td>Retained Earnings (Net Profit to date)</td><td class="text-end">{{ number_format($netProfit,2) }}</td></tr>
            <tr class="fw-bold"><td>Total Equity</td><td class="text-end">{{ number_format($equity->sum() + $netProfit,2) }}</td></tr>
        </table>
    </div>
</div>
<div class="alert alert-info small">
    Total Assets should equal Total Liabilities + Total Equity if your books are balanced:
    {{ number_format($assets->sum(),2) }} vs {{ number_format($liabilities->sum() + $equity->sum() + $netProfit,2) }}
</div>
@endsection