@extends('layouts.app')

@section('content')


<div class="container">
    <h2>Profit & Loss Summary</h2>

    <form method="GET" class="form-inline mb-3">
        <div class="form-group mr-2">
            <label for="from" class="mr-2">From</label>
            <input type="date" name="from" id="from" class="form-control" value="{{ $from ?? '' }}">
        </div>
        <div class="form-group mr-2">
            <label for="to" class="mr-2">To</label>
            <input type="date" name="to" id="to" class="form-control" value="{{ $to ?? '' }}">
        </div>
        <button class="btn btn-primary" type="submit">Filter</button>
    </form>

    <div class="row">
        <div class="col-md-6">
            <h4>Income</h4>
            <table class="table table-sm">
                <thead>
                    <tr><th>Account</th><th class="text-right">Amount</th></tr>
                </thead>
                <tbody>
                    @foreach($income_lines as $line)
                        <tr>
                            <td>{{ $line->name }}</td>
                            <td class="text-right">{{ number_format($line->amount,2) }}</td>
                        </tr>
                    @endforeach
                    <tr class="font-weight-bold">
                        <td>Total Income</td>
                        <td class="text-right">{{ number_format($total_income,2) }}</td>
                    </tr>
                </tbody>
            </table>
        </div>

        <div class="col-md-6">
            <h4>Expenses</h4>
            <table class="table table-sm">
                <thead>
                    <tr><th>Account</th><th class="text-right">Amount</th></tr>
                </thead>
                <tbody>
                    @foreach($expense_lines as $line)
                        <tr>
                            <td>{{ $line->name }}</td>
                            <td class="text-right">{{ number_format($line->amount,2) }}</td>
                        </tr>
                    @endforeach
                    <tr class="font-weight-bold">
                        <td>Total Expense</td>
                        <td class="text-right">{{ number_format($total_expense,2) }}</td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>

    <div class="row mt-3">
        <div class="col-md-12">
            <h4>Net Profit: <span class="ml-3">{{ number_format($net,2) }}</span></h4>
        </div>
    </div>

</div>
@endsection