@extends('admin.layout.app')
@section('body')
    <div class="container py-4">
        <h4>Income Report</h4>
        <form class="row g-2 mb-3" method="GET">
            <div class="col-auto">
                <select name="company_id" class="form-select">
                    <option value="">All Companies</option>
                    @foreach ($companies as $c)
                        <option value="{{ $c->id }}" {{ $companyId == $c->id ? 'selected' : '' }}>{{ $c->name }}
                        </option>
                    @endforeach
                </select>
            </div>
            <div class="col-auto"><input type="date" class="form-control" name="from" value="{{ $from }}"></div>
            <div class="col-auto"><input type="date" class="form-control" name="to" value="{{ $to }}">
            </div>
            <div class="col-auto"><button class="btn btn-primary">Filter</button></div>
        </form>

        <div class="table-responsive">
            <table class="table table-striped">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Company</th>
                        <th class="text-end">Total</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($rows as $r)
                        <tr>
                            <td>{{ $r->d }}</td>
                            <td>{{ optional($companies->firstWhere('id', $r->company_id))->name }}</td>
                            <td class="text-end">{{ number_format($r->total, 2) }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
@endsection