@extends('layouts.index')

@section('content')
<div class="content-wrapper">
    <section class="content-header m-3" style="display:flex; justify-content:space-between; align-items:center;">
        <h1><i class="fa fa-truck"></i> Agent Issuance Requests</h1>
        <div>
            @if(auth()->guard('admin')->user()->checkSpPermission('agents.issue'))
            <a href="{{ url('/sales/agent-issuance') }}" class="btn btn-primary">
                <i class="fa fa-plus"></i> New Issuance
            </a>
            @endif
            @if(auth()->guard('admin')->user()->checkSpPermission('agents.close_order'))
            <a href="{{ url('/Backoffice/orders/close') }}" class="btn btn-warning ml-2">
                <i class="fa fa-lock"></i> Close Orders
            </a>
            @endif
        </div>
    </section>

    <section class="content">
        <div class="row m-3">
            <div class="col-xs-12">

                {{-- Summary cards --}}
                <div class="row" style="margin-bottom:16px;">
                    <div class="col-xs-6 col-sm-3">
                        <div class="small-box bg-aqua">
                            <div class="inner">
                                <h3>{{ $counts['total'] }}</h3>
                                <p>Total Requests</p>
                            </div>
                            <div class="icon"><i class="fa fa-list"></i></div>
                        </div>
                    </div>
                    <div class="col-xs-6 col-sm-3">
                        <div class="small-box bg-green">
                            <div class="inner">
                                <h3>{{ $counts['issued'] }}</h3>
                                <p>Open (Issued)</p>
                            </div>
                            <div class="icon"><i class="fa fa-truck"></i></div>
                        </div>
                    </div>
                    <div class="col-xs-6 col-sm-3">
                        <div class="small-box bg-gray">
                            <div class="inner">
                                <h3>{{ $counts['closed'] }}</h3>
                                <p>Closed</p>
                            </div>
                            <div class="icon"><i class="fa fa-lock"></i></div>
                        </div>
                    </div>
                    <div class="col-xs-6 col-sm-3">
                        <div class="small-box bg-yellow">
                            <div class="inner">
                                <h3>KES {{ number_format($counts['total_value'], 2) }}</h3>
                                <p>Total Value</p>
                            </div>
                            <div class="icon"><i class="fa fa-money"></i></div>
                        </div>
                    </div>
                </div>

                <div class="box box-primary">
                    <div class="box-header with-border">
                        <h3 class="box-title"><i class="fa fa-list-alt"></i> All Issuance Requests</h3>
                        <div class="box-tools pull-right" style="display:flex; gap:8px; align-items:center;">
                            {{-- Status filter --}}
                            <select id="statusFilter" class="form-control input-sm" style="width:130px;">
                                <option value="">All Statuses</option>
                                <option value="issued">Open (Issued)</option>
                                <option value="closed">Closed</option>
                                <option value="requested">Requested</option>
                                <option value="approved">Approved</option>
                            </select>
                            {{-- Agent filter (superadmin only) --}}
                            @if($admin->is_superadmin)
                            <select id="agentFilter" class="form-control input-sm" style="width:150px;">
                                <option value="">All Agents</option>
                                @foreach($agents as $agent)
                                    <option value="{{ strtolower($agent->name) }}">{{ $agent->name }}</option>
                                @endforeach
                            </select>
                            @endif
                            <input type="text" id="requestSearch" class="form-control input-sm"
                                   placeholder="Search order / agent..." style="width:200px;">
                        </div>
                    </div>
                    <div class="box-body no-padding">
                        <table class="table table-bordered table-striped table-hover" id="requestsTable">
                            <thead class="bg-primary" style="color:#fff;">
                                <tr>
                                    <th>#</th>
                                    <th>Request No.</th>
                                    <th>Agent</th>
                                    <th>Date</th>
                                    <th class="text-center">Items</th>
                                    <th class="text-right">Total Value</th>
                                    <th class="text-center">Status</th>
                                    <th class="text-center">Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($requests as $i => $req)
                                @php
                                    $statusColor = match($req->status) {
                                        'Issued'    => 'success',
                                        'Closed'    => 'default',
                                        'Approved'  => 'info',
                                        'Requested' => 'warning',
                                        default     => 'default',
                                    };
                                @endphp
                                <tr class="request-row"
                                    data-status="{{ strtolower($req->status) }}"
                                    data-agent="{{ strtolower($req->agent->name ?? '') }}"
                                    data-search="{{ strtolower($req->request_number . ' ' . ($req->agent->name ?? '')) }}">
                                    <td>{{ $i + 1 }}</td>
                                    <td><strong>{{ $req->request_number }}</strong></td>
                                    <td>
                                        <i class="fa fa-user text-muted"></i>
                                        {{ $req->agent->name ?? '—' }}
                                    </td>
                                    <td>{{ \Carbon\Carbon::parse($req->request_date ?? $req->created_at)->format('d M Y') }}</td>
                                    <td class="text-center">
                                        <span class="badge bg-light-blue">{{ $req->agentRequestItems->count() }}</span>
                                    </td>
                                    <td class="text-right">
                                        <strong>KES {{ number_format($req->total_amount, 2) }}</strong>
                                    </td>
                                    <td class="text-center">
                                        <span class="label label-{{ $statusColor }}">{{ $req->status }}</span>
                                    </td>
                                    <td class="text-center">
                                        <button type="button" class="btn btn-xs btn-info toggle-details"
                                                data-id="{{ $req->id }}">
                                            <i class="fa fa-eye"></i> View Items
                                        </button>
                                        @if(in_array($req->status, ['Issued','Approved','Requested']) && auth()->guard('admin')->user()->checkSpPermission('agents.close_order'))
                                            <a href="{{ url('/Backoffice/orders/close') }}"
                                               class="btn btn-xs btn-warning ml-1">
                                                <i class="fa fa-lock"></i> Close
                                            </a>
                                        @endif
                                    </td>
                                </tr>
                                {{-- Expandable items row --}}
                                <tr class="request-items-row" id="items-{{ $req->id }}" style="display:none;">
                                    <td colspan="8" style="background:#f9f9f9; padding:12px 20px;">
                                        <table class="table table-condensed table-bordered" style="margin:0; background:#fff;">
                                            <thead>
                                                <tr style="background:#ecf0f1;">
                                                    <th>#</th>
                                                    <th>Product</th>
                                                    <th class="text-center">Qty</th>
                                                    <th class="text-right">Unit Price</th>
                                                    <th class="text-right">Subtotal</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach($req->agentRequestItems as $j => $item)
                                                <tr>
                                                    <td>{{ $j + 1 }}</td>
                                                    <td>
                                                        {{ $item->product->product_name ?? 'Unknown' }}
                                                        @if($item->variant_id)
                                                            <small class="text-muted">(variant)</small>
                                                        @endif
                                                    </td>
                                                    <td class="text-center">{{ $item->quantity }}</td>
                                                    <td class="text-right">KES {{ number_format($item->price, 2) }}</td>
                                                    <td class="text-right">KES {{ number_format($item->subtotal, 2) }}</td>
                                                </tr>
                                                @endforeach
                                                <tr style="background:#eaf7ee;">
                                                    <td colspan="4" class="text-right"><strong>Total:</strong></td>
                                                    <td class="text-right">
                                                        <strong>KES {{ number_format($req->total_amount, 2) }}</strong>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>

                                        @php
                                            $commission = $req->commissions->first();
                                        @endphp
                                        @if($commission)
                                        <div class="alert alert-success" style="margin-top:8px; padding:6px 12px;">
                                            <i class="fa fa-money"></i>
                                            Commission recorded: <strong>KES {{ number_format($commission->commission_amount, 2) }}</strong>
                                            — Status: <span class="label label-{{ $commission->status === 'redeemed' ? 'success' : 'warning' }}">{{ ucfirst($commission->status) }}</span>
                                        </div>
                                        @endif
                                    </td>
                                </tr>
                                @empty
                                <tr>
                                    <td colspan="8" class="text-center p-4">
                                        <i class="fa fa-inbox fa-3x text-muted"></i>
                                        <p class="text-muted mt-2">No agent requests found.</p>
                                    </td>
                                </tr>
                                @endforelse
                            </tbody>
                        </table>

                        {{-- Pagination --}}
                        @if($requests->hasPages())
                        <div class="box-footer clearfix">
                            {{ $requests->links() }}
                        </div>
                        @endif
                    </div>
                </div>

            </div>
        </div>
    </section>
</div>
@endsection

@section('script')
<script>
$(document).ready(function () {

    // Toggle item rows
    $(document).on('click', '.toggle-details', function () {
        const id = $(this).data('id');
        const $row = $('#items-' + id);
        $row.toggle();
        const $icon = $(this).find('i');
        $icon.toggleClass('fa-eye fa-eye-slash');
    });

    // Combined filter function
    function applyFilters() {
        const statusVal  = $('#statusFilter').val().toLowerCase();
        const agentVal   = $('#agentFilter').val() ? $('#agentFilter').val().toLowerCase() : '';
        const searchVal  = $('#requestSearch').val().toLowerCase();

        $('.request-row').each(function () {
            const rowStatus = $(this).data('status');
            const rowAgent  = $(this).data('agent');
            const rowSearch = $(this).data('search');

            const statusOk = !statusVal || rowStatus === statusVal;
            const agentOk  = !agentVal  || rowAgent === agentVal;
            const searchOk = !searchVal || rowSearch.includes(searchVal);

            const visible = statusOk && agentOk && searchOk;
            $(this).toggle(visible);

            // Also hide the expanded items row when parent is hidden
            const rowId = $(this).find('.toggle-details').data('id');
            if (!visible) $('#items-' + rowId).hide();
        });
    }

    $('#statusFilter').on('change', applyFilters);
    $('#agentFilter').on('change', applyFilters);
    $('#requestSearch').on('keyup', applyFilters);
});
</script>
@endsection