@extends('layouts.app')

@section('title', 'Welcome')
@section('content')
<div class="d-flex justify-content-between align-items-center mb-3">
    <h1 class="page-header mb-0">Reports Management</h1>
</div>
<div class="panel panel-inverse border-0">
    <div class="panel-heading">
        Site Collection Report
    </div>
    <div class="panel-body">
        <form action="{{ route('report.site') }}" method="GET" class="align-items-center">
            <div class="row">
                <div class="col-sm-6 col-md-3">
                    <label class="form-label" for="date_from">Date Received From</label>
                    <input type="date" class="form-control mb-3" id="date_from" name="date_from"
                           value="{{ request()->get('date_from') == '' ?  now()->startOfMonth()->format('Y-m-d') : request()->get('date_from') }}"
                           placeholder="Date From">
                </div>

                <div class="col-sm-6 col-md-3">
                    <label class="form-label" for="date_to">Date Received To</label>
                    <input type="date" class="form-control mb-3" id="date_to" name="date_to"
                           value="{{ request()->get('date_to') == '' ?  now()->endOfMonth()->format('Y-m-d') : request()->get('date_to') }}"
                           placeholder="Date To">
                </div>

                <div class="col-sm-6 col-md-3">
                    <label class="form-label" for="status">Site Status</label>
                    <select name="status" id="status" class="form-select mb3">
                        <option value="">- Select Status -</option>
                        @foreach(\App\Models\Traits\Enum\CardHolderStatus::cases() as $status)
                            <option value="{{ $status->value }}" @selected(old('status', \App\Models\Traits\Enum\CardHolderStatus::ACTIVE->value) == $status->value)>{{ $status->label() }}</option>
                        @endforeach
                    </select>
                </div>

                <div class="col-sm-6 col-md-3  mt-4">
                    <button type="submit" class="btn btn-primary">Filter</button>
                    <a href="{{ route('report.site') }}" class="btn btn-white">Reset</a>
                    <button type="submit" name="action" value="export" class="btn btn-green">Export</button>
                </div>
            </div>
        </form>
        <div class="table-responsive">
            <table class="table table-hover border text-nowrap align-middle mb-0">
                <thead class="table-light">
                    <tr>
                        <th>No.</th>
                        <th>Name</th>
                        <th class="text-end col-2">No. of Payment Made</th>
                        <th class="text-end col-2">Collection</th>
                    </tr>
                </thead>
                <tbody class="table-group-divider">
                    @forelse ($sites as $index => $site)
                        <tr>
                            <td>{{ $sites->firstItem() + $index }}</td>
                            <td class="text-uppercase">{{ $site->name }}</td>
                            <td class="text-end">{{ $site->payments_count }}</td>
                            <td class="text-end">
                                <span>RM</span> {{ number_format($site->payments_sum_amount, 2) ?? '0' }}
                            </td>
                        </tr>
                    @empty
                    @endforelse
                    <tr class="text-uppercase">
                        <th class="text-end" colspan="2">Total In This Page</th>
                        <th class="text-end">{{ collect($sites->items())->sum('payments_count') }}</th>
                        <th class="text-end">
                            RM {{ number_format(collect($sites->items())->sum('payments_sum_amount'), 2) }}
                        </th>
                    </tr>
                    <tr class="bg-info fs-5">
                        <th class="text-end" colspan="2">TOTAL</th>
                        <th class="text-end">{{ number_format($count) }}</th>
                        <th class="text-end">
                            RM {{ number_format($amount, 2) }}
                        </th>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>
    <div class="panel-footer">
        {{ $sites->links() }}
    </div>
</div>
@endsection