@extends('layout.app')

@section('content')
<section class="content">
    <div class="container-fluid">
        <div class="card">
            <div class="card-body py-2">

                {{-- .auto-deduct-select, not .select2, so only this page's init claims them. --}}
                <form method="GET" action="{{ route('manager-auto-deduct-report') }}" class="mb-2">
                    <div class="form-row">
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">From Date</label>
                            <input type="date" name="from_date" class="form-control form-control-sm" value="{{ $fromRaw }}">
                        </div>
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">To Date</label>
                            <input type="date" name="to_date" class="form-control form-control-sm" value="{{ $toRaw }}">
                        </div>
                        <div class="col-md-4">
                            <label class="mb-0 small text-muted">Manager</label>
                            <select name="reseller_id[]" class="form-control form-control-sm auto-deduct-select" multiple data-placeholder="— All Managers —">
                                @foreach ($managers as $m)
                                    <option value="{{ $m->id }}" {{ in_array($m->id, (array) request('reseller_id')) ? 'selected' : '' }}>
                                        {{ $m->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">Bill Type</label>
                            <select name="bill_type" class="form-control form-control-sm auto-deduct-select" data-placeholder="— All Types —">
                                <option value="">— All Types —</option>
                                @foreach ($billTypes as $key => $label)
                                    <option value="{{ $key }}" {{ request('bill_type') === $key ? 'selected' : '' }}>{{ $label }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2 d-flex align-items-end">
                            <button type="submit" class="btn btn-sm btn-primary"><i class="fa fa-filter"></i> Filter</button>
                            <a href="{{ route('manager-auto-deduct-report') }}" class="btn btn-sm btn-secondary ml-2">Reset</a>
                        </div>
                    </div>
                </form>

                {{-- One table: each manager's deductions together, a subtotal row after each
                     manager, and the grand total at the foot. --}}
                <div class="table-responsive finance-table-wrap">
                    <table class="table table-bordered table-hover table-sm">
                        <thead class="thead-dark">
                            <tr>
                                <th>#</th>
                                <th>Manager ID</th>
                                <th>Manager</th>
                                <th>Deducted At</th>
                                <th>Bill Type</th>
                                <th>Bill</th>
                                <th class="text-right">Balance Before</th>
                                <th class="text-right">Deducted Amount</th>
                                <th class="text-right">Balance After</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php $sl = 0; @endphp
                            @forelse ($groups as $group)
                                @php $reseller = $group->first()->reseller; @endphp
                                @foreach ($group as $row)
                                    <tr>
                                        <td>{{ ++$sl }}</td>
                                        <td>{{ optional($reseller)->id }}</td>
                                        <td>{{ optional($reseller)->name ?? '—' }}</td>
                                        <td>{{ $row->deducted_at->format('d M Y h:i A') }}</td>
                                        <td>{{ $row->bill_type }}</td>
                                        <td>
                                            @if ($row->bill_id)
                                                #{{ $row->bill_id }}{{ $row->bill_label ? ' — ' . $row->bill_label : '' }}
                                            @else
                                                <span class="text-muted">Deleted bill</span>
                                            @endif
                                        </td>
                                        <td class="text-right">{{ $row->balance_before !== null ? number_format($row->balance_before, 2) : '—' }}</td>
                                        <td class="text-right">{{ number_format($row->amount, 2) }}</td>
                                        <td class="text-right {{ $row->balance_after !== null && $row->balance_after < 0 ? 'text-danger' : '' }}">
                                            {{ $row->balance_after !== null ? number_format($row->balance_after, 2) : '—' }}
                                        </td>
                                    </tr>
                                @endforeach
                                <tr style="font-weight:600;background:#eef2f7;">
                                    <td colspan="7" class="text-right">
                                        {{ optional($reseller)->name ?? '—' }} Total
                                        <small class="text-muted">({{ $group->count() }} {{ $group->count() > 1 ? 'entries' : 'entry' }})</small>
                                    </td>
                                    <td class="text-right">{{ number_format($group->sum('amount'), 2) }}</td>
                                    <td></td>
                                </tr>
                            @empty
                                <tr><td colspan="9" class="text-center text-muted py-3">No auto deduction in this period.</td></tr>
                            @endforelse
                        </tbody>
                        @if ($groups->count())
                            <tfoot>
                                <tr class="total-row" style="font-weight:bold;background:#f4f6f9;">
                                    <td colspan="7" class="text-right">Grand Total</td>
                                    <td class="text-right">{{ number_format($grandTotal, 2) }}</td>
                                    <td></td>
                                </tr>
                            </tfoot>
                        @endif
                    </table>
                </div>
            </div>
        </div>
    </div>
</section>
@endsection
@section('ajax')
<script>
    $(function () {
        $('.auto-deduct-select').each(function () {
            var $el = $(this);
            $el.select2({
                theme: 'bootstrap4',
                placeholder: $el.data('placeholder'),
                allowClear: true,
                width: '100%',
            });
        });
    });
</script>
@endsection
@include('partials.finance-sticky-table')