@extends('layout.app')
@section('content')
    <div class="card">
        <div class="card-body">

            <form action="{{ route('sub-manager-commission-transfer-report') }}" method="GET" id="filterForm">
                <div class="row mb-3">
                    <div class="col-md-3">
                        <div class="input-group date" id="searchFrom" data-target-input="nearest">
                            <input value="{{ $from->format('m/d/y') }}" type="text" name="from_date"
                                class="form-control datetimepicker-input input-group-append"
                                data-toggle="datetimepicker" data-target="#searchFrom" autocomplete="off"
                                placeholder="From Date">
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="input-group date" id="searchTo" data-target-input="nearest">
                            <input value="{{ $to->format('m/d/y') }}" type="text" name="to_date"
                                class="form-control datetimepicker-input input-group-append"
                                data-toggle="datetimepicker" data-target="#searchTo" autocomplete="off"
                                placeholder="To Date">
                        </div>
                    </div>
                    <div class="col-md-3">
                        <select name="pop" class="form-control select2">
                            <option value="">All POPs</option>
                            @foreach ($pops as $p)
                                <option value="{{ $p->id }}" {{ request('pop') == $p->id ? 'selected' : '' }}>
                                    {{ $p->popname }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3">
                        <button type="submit" class="btn btn-primary">
                            <i class="fa fa-search"></i> Search
                        </button>
                    </div>
                </div>
            </form>

            <div class="table-responsive">
                <table class="table table-bordered table-hover" style="width:100%">
                    <thead>
                        <tr>
                            <th class="bg-dark">#</th>
                            <th class="bg-dark">Date</th>
                            <th class="bg-dark">POP Name</th>
                            <th class="bg-dark" style="text-align:right;">Amount</th>
                            <th class="bg-dark">Transfer Type</th>
                            <th class="bg-dark">Note</th>
                            <th class="bg-dark">Transferred By</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse ($transfers as $i => $t)
                            @php
                                // comments pattern: "note -- transfer through -- Cash"
                                $parts        = explode(' -- transfer through -- ', $t->comments ?? '');
                                $note         = trim($parts[0] ?? '');
                                $transferType = trim($parts[1] ?? '—');
                                $transferType = $transferType === 'PopRecharge' ? 'Account Recharge' : $transferType;
                            @endphp
                            <tr>
                                <td>{{ $i + 1 }}</td>
                                <td>{{ $t->created_at->format('d M Y h:i A') }}</td>
                                <td>{{ $t->pop->popname ?? '—' }}</td>
                                <td style="text-align:right;">{{ number_format($t->paid_amount, 2) }}</td>
                                <td>
                                    <span class="badge {{ $transferType === 'Account Recharge' ? 'badge-info' : 'badge-success' }}">
                                        {{ $transferType }}
                                    </span>
                                </td>
                                <td>{{ $note ?: '—' }}</td>
                                <td>{{ $t->user->name ?? '—' }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="7" class="text-center text-muted">No commission transfers found for the selected period.</td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if ($transfers->isNotEmpty())
                        <tfoot>
                            <tr class="bg-dark text-white font-weight-bold">
                                <td colspan="3">Total</td>
                                <td style="text-align:right;">{{ number_format($transfers->sum('paid_amount'), 2) }}</td>
                                <td colspan="3"></td>
                            </tr>
                        </tfoot>
                    @endif
                </table>
            </div>

        </div>
    </div>
@endsection