@php(
    $headerOption = \App\Http\Controllers\Controller::getHeaderOptions(
        $title ?? '',
        $subTitle ?? '',
        isset($filters) ? $filters : [],
        isset($advancedFilters) ? $advancedFilters : []
    )
)
@php($headingOptions = [
    '<a href="' . route('my-merchants.index') . '" class="'. \Config::get('view.buttons.secondary') .'"><i class="bx bx-arrow-back"></i> My Merchants</a>',
])
@php($exceptionCategories = [
    'NSF', 'Return Item', 'Unauthorized', 'Stop Payment', 'Account Closed',
    'Refer to Maker', 'Uncollected Funds', 'Unable to Locate', 'Frozen Account',
    'Bad Debt', 'Duplicate Entry', 'Stale Date', 'Postdated', 'Missing Signature',
    'Irregular Signature', 'Altered Check', 'Endorsement Missing', 'Other'
])
@extends('admin.layouts.layout', $headerOption)
@section('content')
<div class="col-12">
    <x-heading-sec :module="'Deposit Exceptions'" :options="$headingOptions" />

    {{-- Filter Bar --}}
    <div class="project-box mb-3 p-3">
        <form method="GET" class="row g-2 align-items-end">
            <div class="col-md-2">
                <div class="project-form mb-0">
                    <label class="form-label mb-0">Processor</label>
                    <select name="processor" class="form-select form-select-sm select2">
                        <option value="">All Processors</option>
                    </select>
                </div>
            </div>
            <div class="col-md-2">
                <div class="project-form mb-0">
                    <label class="form-label mb-0">Group</label>
                    <select name="master_group_id" class="form-select form-select-sm select2">
                        <option value="">All Groups</option>
                    </select>
                </div>
            </div>
            <div class="col-md-2">
                <div class="project-form mb-0">
                    <label class="form-label mb-0">Date From</label>
                    <input type="date" name="date_from" class="form-control form-control-sm" value="{{ request('date_from') }}">
                </div>
            </div>
            <div class="col-md-2">
                <div class="project-form mb-0">
                    <label class="form-label mb-0">Date To</label>
                    <input type="date" name="date_to" class="form-control form-control-sm" value="{{ request('date_to') }}">
                </div>
            </div>
            <div class="col-md-2">
                <div class="project-form mb-0">
                    <label class="form-label mb-0">Keyword</label>
                    <select name="keywords[]" class="form-select form-select-sm select2" multiple data-placeholder="Select keywords...">
                        @foreach($exceptionCategories as $cat)
                        <option value="{{ $cat }}" {{ in_array($cat, request('keywords', [])) ? 'selected' : '' }}>{{ $cat }}</option>
                        @endforeach
                    </select>
                </div>
            </div>
            <div class="col-auto">
                <button type="submit" class="green-btn-inner waves-effect"><i class="bx bx-filter-alt me-1"></i>Apply</button>
            </div>
        </form>
    </div>

    {{-- Results grouped by exception category --}}
    <div class="project-box p-3">
        @foreach($exceptionCategories as $cat)
        @php($catData = collect($data ?? [])->filter(fn($r) => stripos($r->description ?? '', $cat) !== false || stripos($r->reason ?? '', $cat) !== false))
        @if($catData->isNotEmpty() || request('keywords') === null)
        <div class="mb-3">
            {{-- Teal group-header row --}}
            <div class="d-flex justify-content-between align-items-center px-3 py-2 rounded mb-2"
                style="background:#0B6FA4;color:white;">
                <span class="fw-semibold">{{ $cat }}</span>
                <div class="d-flex gap-2 align-items-center">
                    <span class="badge bg-white text-primary">{{ $catData->count() }} items</span>
                    <input type="text" class="form-control form-control-sm dep-exc-filter" style="width:160px"
                        placeholder="Filter DBA..." data-category="{{ $cat }}">
                </div>
            </div>
            @if($catData->isNotEmpty())
            <div class="table-responsive">
                <table class="table table-sm table-bordered mb-0" data-cat-table="{{ $cat }}">
                    <thead>
                    <tr>
                        <th>Merchant</th>
                        <th>MID</th>
                        <th>Date</th>
                        <th>Amount</th>
                        <th>Description</th>
                    </tr>
                    </thead>
                    <tbody>
                    @foreach($catData as $row)
                    <tr class="dep-exc-row" data-dba="{{ strtolower($row->merchant_dba ?? '') }}">
                        <td>{{ $row->merchant_dba ?? $row->dba ?? '—' }}</td>
                        <td><code>{{ $row->merchant_mid ?? $row->mid ?? '—' }}</code></td>
                        <td>{{ $row->transaction_date ? \App\Helpers\Helper::showdate($row->transaction_date, false) : '—' }}</td>
                        <td>${{ number_format($row->amount ?? 0, 2) }}</td>
                        <td>{{ $row->description ?? $row->reason ?? '—' }}</td>
                    </tr>
                    @endforeach
                    </tbody>
                </table>
            </div>
            @else
            <p class="text-muted small px-2">No records in this category.</p>
            @endif
        </div>
        @endif
        @endforeach
        @if(empty($data))
        <div class="text-center text-muted py-4">
            <i class="bx bx-info-circle fs-3 d-block mb-2"></i>
            No deposit exceptions found. Adjust filters to see results.
        </div>
        @endif
    </div>
</div>
@endsection
@push('page_script')
<script src="{{ asset('assets/js/common.js') }}"></script>
<script>
(function($){
    // Per-category DBA inline filter
    $(document).on('keyup', '.dep-exc-filter', function(){
        const cat = $(this).data('category');
        const val = $(this).val().toLowerCase();
        $('[data-cat-table="' + cat + '"] .dep-exc-row').each(function(){
            $(this).toggle($(this).data('dba').includes(val));
        });
    });
})(jQuery);
</script>
@endpush