@php
    $totalAdvance      = (float) $list->sum('amount');
    $totalInstallments = (int) $list->sum('installment_count');
    // Each row's own per-instalment figure, added up — the instalment counts differ, so
    // this is not $totalAdvance / $totalInstallments.
    $totalPerInstall   = (float) $list->sum(function ($item) {
        return $item->installment_count > 0 ? $item->amount / $item->installment_count : 0;
    });
@endphp

<div class="mb-2">
    <span class="badge badge-info">Total: {{ $list->count() }}</span>
    <span class="badge badge-warning ml-1">Total Advance: {{ number_format($list->sum('amount'), 2) }} TK</span>
    <span class="badge badge-success ml-1">Approved: {{ number_format($list->where('status','approved')->sum('amount'), 2) }} TK</span>
    <span class="badge badge-secondary ml-1">Pending: {{ number_format($list->where('status','pending')->sum('amount'), 2) }} TK</span>
</div>

<div class="table-responsive finance-table-wrap">
    <table class="table table-bordered table-striped table-sm">
        <thead class="thead-dark">
            <tr>
                <th>#</th>
                <th>Manager</th>
                <th>Month</th>
                <th>Status</th>
                <th>Description</th>
                <th>Created By</th>
                <th>Approved By</th>
                <th>Date</th>
                <th class="text-right">Advance Amount (TK)</th>
                <th class="text-center">Installments</th>
                <th class="text-right">Per Install (TK)</th>
                @canany(['reseller-advance-commission-edit','reseller-advance-commission-approve','reseller-advance-commission-delete','reseller-advance-commission-history'])
                    <th>Action</th>
                @endcanany
            </tr>
            {{-- The Total row lives in <thead>, above the rows, so it stays put under the
                 sticky header instead of sitting at the far end of a long list. --}}
            <tr class="total-row font-weight-bold bg-light">
                <td colspan="8" class="text-right">Total:</td>
                <td class="text-right text-danger">{{ number_format($totalAdvance, 2) }}</td>
                <td class="text-center">{{ $totalInstallments }}</td>
                <td class="text-right">{{ number_format($totalPerInstall, 2) }}</td>
                @canany(['reseller-advance-commission-edit','reseller-advance-commission-approve','reseller-advance-commission-delete','reseller-advance-commission-history'])
                    <td></td>
                @endcanany
            </tr>
        </thead>
        <tbody>
            @forelse($list as $item)
                @php $perInstall = $item->installment_count > 0 ? $item->amount / $item->installment_count : 0; @endphp
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $item->reseller->name_with_type ?? 'N/A' }}</td>
                    <td>
                        {{ $item->advance_month ? $item->advance_month->format('M Y') : '-' }}
                        @if($item->recovery_start_month)
                            <br><small class="text-muted">Recovery from {{ $item->recovery_start_month->format('M Y') }}</small>
                        @endif
                    </td>
                    <td>
                        @include('partials.approval-status', ['item' => $item])
                        @include('partials.approval-comment', ['item' => $item])
                    </td>
                    <td>{{ $item->description ?? '-' }}</td>
                    <td>{{ $item->createdBy->name ?? 'N/A' }}</td>
                    <td>
                        @if($item->approved_by)
                            {{ $item->approvedBy->name ?? 'N/A' }}
                            <br><small class="text-muted">{{ $item->approved_at ? $item->approved_at->format('d M Y') : '' }}</small>
                        @else
                            <span class="text-muted">-</span>
                        @endif
                    </td>
                    <td>{{ $item->created_at->format('d M Y h:i A') }}</td>
                    <td class="text-right font-weight-bold text-danger">
                        {{ number_format($item->amount, 2) }}
                    </td>
                    <td class="text-center"><span class="badge badge-dark">{{ $item->installment_count }}</span></td>
                    <td class="text-right">{{ number_format($perInstall, 2) }}</td>
                    @canany(['reseller-advance-commission-edit','reseller-advance-commission-approve','reseller-advance-commission-delete','reseller-advance-commission-history'])
                        <td class="text-nowrap">
                            {{-- An approved advance stays editable/deletable, but only for a user who
                                 also holds the *-approved permission. --}}
                            @php
                                $isApproved = $item->status === 'approved';
                                $canEditRow = auth()->user()->can('reseller-advance-commission-edit') && (!$isApproved || auth()->user()->can('reseller-advance-commission-edit-approved'));
                                $canDeleteRow = auth()->user()->can('reseller-advance-commission-delete') && (!$isApproved || auth()->user()->can('reseller-advance-commission-delete-approved'));
                            @endphp
                            @if ($canEditRow)
                                <button type="button" class="btn btn-warning btn-xs"
                                    onclick="openEditModal({{ $item->id }}, '{{ addslashes($item->reseller->name_with_type ?? '') }}', '{{ $item->advance_month ? $item->advance_month->format('Y-m') : '' }}', '{{ $item->amount }}', '{{ addslashes($item->description ?? '') }}', '{{ $item->installment_count }}', '{{ $item->recovery_start_month ? $item->recovery_start_month->format('Y-m') : '' }}')">
                                    <i class="fa fa-edit"></i> Edit
                                </button>
                            @endif
                            @if ($canDeleteRow)
                                <form action="{{ route('reseller-advance-commission.destroy', $item->id) }}"
                                      method="POST" class="d-inline"
                                      onsubmit="return confirm('Delete this advance entry?')">
                                    @csrf
                                    @method('DELETE')
                                    <button type="submit" class="btn btn-danger btn-xs">
                                        <i class="fa fa-trash"></i> Delete
                                    </button>
                                </form>
                            @endif
                            @can('reseller-advance-commission-approve')
                                @include('partials.approval-decision-buttons', [
                                    'item'  => $item,
                                    'url'   => route('reseller-advance-commission.approve', $item->id),
                                    'label' => 'advance entry',
                                    'size'  => 'btn-xs',
                                ])
                            @endcan
                            @php
                                $advPaid = (float) ($item->payments_sum_amount ?? 0);
                                $advRemaining = max(0, (float) $item->amount - $advPaid);
                            @endphp
                            @if ($item->status === 'approved')
                                @can('reseller-advance-commission-payment')
                                    @if ($advRemaining > 0)
                                        <button type="button" class="btn btn-success btn-xs pay-adv-btn"
                                            data-id="{{ $item->id }}"
                                            data-manager="{{ $item->reseller->name_with_type ?? '' }}"
                                            data-amount="{{ number_format($item->amount, 2) }}"
                                            data-remaining="{{ number_format($advRemaining, 2) }}">
                                            <i class="fa fa-money-bill-wave"></i> Pay
                                        </button>
                                    @endif
                                    @if ($advPaid > 0)
                                        <button type="button" class="btn btn-info btn-xs pay-log-adv-btn" data-id="{{ $item->id }}">
                                            <i class="fa fa-history"></i> Pay Log
                                        </button>
                                    @endif
                                @endcan
                            @endif
                            @can('reseller-advance-commission-history')
                                <a href="{{ route('editLog-history', ['id' => $item->id, 'type' => 'ResellerAdvanceCommission']) }}"
                                   class="btn btn-secondary btn-xs">
                                    <i class="fa fa-list-alt"></i> History
                                </a>
                            @endcan
                            <button type="button" class="btn btn-primary btn-xs schedule-adv-btn" data-id="{{ $item->id }}">
                                <i class="fa fa-calendar-alt"></i> Schedule
                            </button>
                        </td>
                    @endcanany
                </tr>
            @empty
                <tr>
                    <td colspan="12" class="text-center text-muted">No advance commission records found.</td>
                </tr>
            @endforelse
        </tbody>
    </table>
</div>

{{-- Edit Modal --}}
<div class="modal fade" id="editAdvanceModal" tabindex="-1" role="dialog">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Edit Advance Commission</h5>
                <button type="button" class="close" data-dismiss="modal"><span>&times;</span></button>
            </div>
            <form id="editAdvanceForm" method="POST">
                @csrf
                @method('PUT')
                <div class="modal-body">
                    <div class="form-group">
                        <label>Manager</label>
                        <input type="text" id="edit_reseller_name" class="form-control" readonly>
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Month <span class="text-danger">*</span></label>
                                <input type="month" name="advance_month" id="edit_advance_month" class="form-control" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Recovery Start Month</label>
                                <input type="month" name="recovery_start_month" id="edit_recovery_start_month" class="form-control">
                                <small class="text-muted">Leave empty to start from the advance month.</small>
                            </div>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Advance Amount (TK) <span class="text-danger">*</span></label>
                                <input type="number" name="amount" id="edit_amount" class="form-control" min="1" step="0.01" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label>Installment Count <span class="text-danger">*</span></label>
                                <input type="number" name="installment_count" id="edit_installment_count" class="form-control" min="1" step="1" required>
                            </div>
                        </div>
                    </div>
                    <div class="form-group">
                        <label>Description</label>
                        <textarea name="description" id="edit_description" class="form-control" rows="2"></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary"><i class="fa fa-save"></i> Update</button>
                </div>
            </form>
        </div>
    </div>
</div>

<script>
function openEditModal(id, resellerName, month, amount, description, installmentCount, recoveryStartMonth) {
    document.getElementById('edit_reseller_name').value      = resellerName;
    document.getElementById('edit_advance_month').value      = month;
    document.getElementById('edit_recovery_start_month').value = recoveryStartMonth || '';
    document.getElementById('edit_amount').value             = amount;
    document.getElementById('edit_installment_count').value  = installmentCount;
    document.getElementById('edit_description').value        = description;
    document.getElementById('editAdvanceForm').action        = '/admin/reseller-advance-commission/' + id;
    $('#editAdvanceModal').modal('show');
}
</script>