@extends('layout.app')

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

                {{-- One compact filter line: six fields across, then the buttons and the
                     note. .commission-select, not .select2, so only this page's init claims
                     them — the global .select2 initializer would bind them a second time. --}}
                <form method="GET" action="{{ route('manager-commission-report') }}" class="mb-2">
                    <div class="form-row">
                        {{-- Month-only period: the controller snaps "from" to the 1st and "to" to the month end. --}}
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">From Month</label>
                            <input type="month" name="from_date" class="form-control form-control-sm" value="{{ $fromMonth }}">
                        </div>
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">To Month</label>
                            <input type="month" name="to_date" class="form-control form-control-sm" value="{{ $toMonth }}">
                        </div>
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">Manager Type</label>
                            <select name="manager_type" class="form-control form-control-sm commission-select" data-placeholder="— All Types —">
                                <option value="">— All Types —</option>
                                <option value="own" {{ request('manager_type') === 'own' ? 'selected' : '' }}>Own</option>
                                <option value="other" {{ request('manager_type') === 'other' ? 'selected' : '' }}>Other</option>
                            </select>
                        </div>
                        {{-- Held managers are listed by default; picking some here makes the
                             report a lookup of exactly those. --}}
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">Hold Manager</label>
                            <select name="hold_reseller_id[]" class="form-control form-control-sm commission-select" multiple
                                    data-placeholder="{{ count($holdManagers) ? '— Search hold manager —' : '— No hold manager —' }}">
                                @if (count($holdManagers))
                                    <option value="all" {{ in_array('all', (array) request('hold_reseller_id')) ? 'selected' : '' }}>
                                        — All hold managers ({{ count($holdManagers) }}) —
                                    </option>
                                @endif
                                @foreach ($holdManagers as $h)
                                    <option value="{{ $h->id }}" {{ in_array($h->id, $holdRaw) ? 'selected' : '' }}>
                                        {{ $h->name }} ({{ ucfirst($h->reseller_type) }})
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">Manager</label>
                            <select name="reseller_id[]" class="form-control form-control-sm commission-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 }} ({{ ucfirst($m->reseller_type) }})
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="mb-0 small text-muted">Except Manager</label>
                            <select name="exclude_reseller_id[]" class="form-control form-control-sm commission-select" multiple data-placeholder="— Exclude —">
                                @foreach ($managers as $m)
                                    <option value="{{ $m->id }}" {{ in_array($m->id, (array) request('exclude_reseller_id')) ? 'selected' : '' }}>
                                        {{ $m->name }} ({{ ucfirst($m->reseller_type) }})
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="d-flex flex-wrap align-items-center mt-2">
                        <small class="text-muted mr-auto">
                            Managers with no recharge, no commission and no dues here are hidden — pick them in <em>Manager</em> to see a zero row.
                            Hold managers are listed too (marked <em>Commission on hold</em>) — pick them in <em>Hold Manager</em> to see only those.
                        </small>
                        <button type="submit" class="btn btn-sm btn-primary ml-2"><i class="fa fa-filter"></i> Filter</button>
                        <a href="{{ route('manager-commission-report') }}" class="btn btn-sm btn-secondary ml-2">Reset</a>
                        {{-- Export carries the filters that produced what is on screen. --}}
                        <a href="{{ route('manager-commission-report.export', request()->query()) }}" class="btn btn-sm btn-success ml-2">
                            <i class="fa fa-file-excel"></i> Excel
                        </a>
                    </div>
                </form>

                {{-- <p class="text-muted">
                    Commission period: <strong>{{ $fromLabel }}</strong> — <strong>{{ $toLabel }}</strong>.
                    Net = Total Commission (Calculated) − Core Rent due − Monthly Installment due − Real IP Bill due
                    − Product Installment due − Advance Commission.
                    <br><small>Core Rent / Monthly Installment / Real IP Bill due = billed − cash-paid, for bills <strong>created within this period</strong>.
                    <strong>Product Installment</strong> is schedule-based: only the monthly installments <strong>due within this period</strong> count ((Total − Speed Money) ÷ Count, monthly from approval).
                    <strong>Advance Commission</strong> is also recovered in installments (Amount ÷ Count, monthly from the advance month) — only the installment due within the period is deducted.
                    Amounts cleared via <em>Settle Dues</em> are paid from commission, so they <strong>stay deducted</strong> from Net; only manual/cash payments reduce the deduction.</small>
                </p> --}}

                @php
                    $gTotalAmount   = $rows->sum('total_amount');
                    $gCompanyAmount = $rows->sum('company_amount');
                    $gCommission = $rows->sum('commission');
                    $gCoreRent   = $rows->sum('core_rent');
                    $gMonthly    = $rows->sum('monthly');
                    $gRealIp     = $rows->sum('real_ip');
                    $gProduct    = $rows->sum('product');
                    $gAdvance    = $rows->sum('advance');
                    $gDeduction  = $rows->sum('deduction');
                    $gNet        = $rows->sum('net');
                @endphp

                <div class="table-responsive finance-table-wrap">
                    <table id="dataTable" class="table table-bordered table-striped table-hover table-sm">
                        <thead class="thead-dark">
                            <tr>
                                <th>#</th>
                                <th>Manager ID</th>
                                <th>Manager</th>
                                <th class="text-right">Total Amount</th>
                                <th class="text-right">Company Amount</th>
                                <th class="text-right">Total Commission (Calculated)</th>
                                <th>Type</th>
                                <th class="text-right">Core Rent Due</th>
                                <th class="text-right">Monthly Installment Due</th>
                                <th class="text-right">Real IP Bill Due</th>
                                <th class="text-right">Product Installment Due</th>
                                <th class="text-right">Advance Commission</th>
                                <th class="text-right">Total Deduction</th>
                                <th class="text-right">Net Commission</th>
                                <th>Account No</th>
                                <th>Account Name</th>
                                <th>Bank Name</th>
                                <th>Branch Name</th>
                                <th>Routing No</th>
                                @can('manager-commission-settle')
                                    <th>Action</th>
                                @endcan
                            </tr>
                            <tr class="total-row" style="font-weight:bold;background:#f4f6f9;">
                                <td colspan="3" class="text-right">Total</td>
                                <td class="text-right">{{ number_format($gTotalAmount, 2) }}</td>
                                <td class="text-right">{{ number_format($gCompanyAmount, 2) }}</td>
                                <td class="text-right">{{ number_format($gCommission, 2) }}</td>
                                <td></td>
                                <td class="text-right">{{ number_format($gCoreRent, 2) }}</td>
                                <td class="text-right">{{ number_format($gMonthly, 2) }}</td>
                                <td class="text-right">{{ number_format($gRealIp, 2) }}</td>
                                <td class="text-right">{{ number_format($gProduct, 2) }}</td>
                                <td class="text-right">{{ number_format($gAdvance, 2) }}</td>
                                <td class="text-right text-danger">{{ number_format($gDeduction, 2) }}</td>
                                <td class="text-right {{ $gNet < 0 ? 'text-danger' : 'text-success' }}">{{ number_format($gNet, 2) }}</td>
                                <td colspan="5"></td>
                                @can('manager-commission-settle')
                                    <td></td>
                                @endcan
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($rows as $i => $row)
                                @php
                                    // Manager name with its type in brackets, e.g. "Rahim (Own)".
                                    $managerLabel = $row->reseller->name
                                        . ($row->reseller->reseller_type ? ' (' . ucfirst($row->reseller->reseller_type) . ')' : '');
                                @endphp
                                <tr>
                                    <td>{{ $i + 1 }}</td>
                                    <td>{{ $row->reseller->id }}</td>
                                    <td>{{ $managerLabel }}</td>
                                    <td class="text-right">{{ number_format($row->total_amount, 2) }}</td>
                                    <td class="text-right">{{ number_format($row->company_amount, 2) }}</td>
                                    <td class="text-right">{{ number_format($row->commission, 2) }}</td>
                                    <td>
                                        <span class="badge badge-{{ $row->reseller->reseller_type === 'own' ? 'primary' : 'secondary' }}">
                                            {{ ucfirst($row->reseller->reseller_type) }}
                                        </span>
                                    </td>
                                    <td class="text-right">{{ $row->core_rent > 0 ? number_format($row->core_rent, 2) : '—' }}</td>
                                    <td class="text-right">{{ $row->monthly > 0 ? number_format($row->monthly, 2) : '—' }}</td>
                                    <td class="text-right">{{ $row->real_ip > 0 ? number_format($row->real_ip, 2) : '—' }}</td>
                                    <td class="text-right">{{ $row->product > 0 ? number_format($row->product, 2) : '—' }}</td>
                                    <td class="text-right">{{ $row->advance > 0 ? number_format($row->advance, 2) : '—' }}</td>
                                    <td class="text-right text-danger font-weight-bold">{{ number_format($row->deduction, 2) }}</td>
                                    <td class="text-right font-weight-bold {{ $row->net < 0 ? 'text-danger' : 'text-success' }}">
                                        {{ number_format($row->net, 2) }}
                                    </td>
                                    <td>{{ $row->reseller->bank_account_no ?? '—' }}</td>
                                    <td>{{ $row->reseller->account_name ?? '—' }}</td>
                                    <td>{{ $row->reseller->bank_name ?? '—' }}</td>
                                    <td>{{ $row->reseller->branch_name ?? '—' }}</td>
                                    <td>{{ $row->reseller->routing_number ?? '—' }}</td>
                                    @can('manager-commission-settle')
                                        <td class="text-nowrap">
                                            @if ($row->reseller->commission_hold)
                                                {{-- Listed through the Commission Status filter, but nothing is payable
                                                     while the commission is withheld. --}}
                                                <span class="badge badge-danger"><i class="fa fa-pause"></i> Commission on hold</span>
                                            @else
                                            @if ($row->unpaid > 0)
                                                <form method="POST" action="{{ route('manager-commission-report.settle') }}" class="d-inline"
                                                      onsubmit="return confirm('Settle {{ number_format($row->unpaid, 2) }} dues for {{ addslashes($managerLabel) }}? This records payments and marks the bills paid.')">
                                                    @csrf
                                                    <input type="hidden" name="reseller_id" value="{{ $row->reseller->id }}">
                                                    <input type="hidden" name="from_date" value="{{ $fromRaw }}">
                                                    <input type="hidden" name="to_date" value="{{ $toRaw }}">
                                                    <input type="hidden" name="settle_filter_reseller" value="{{ implode(',', (array) request('reseller_id')) }}">
                                                    <input type="hidden" name="settle_filter_type" value="{{ $typeRaw }}">
                                                    <button type="submit" class="btn btn-sm btn-success">
                                                        <i class="fa fa-money-bill-wave"></i> Pay
                                                    </button>
                                                </form>
                                            @elseif ($row->core_rent + $row->monthly + $row->real_ip + $row->product + $row->advance > 0)
                                                <span class="badge badge-success"><i class="fa fa-check"></i> Paid</span>
                                            @endif

                                            {{-- Advance commission is own-type only. Recovery starts next month, so a
                                                 carried deficit leaves this period's Net at 0 — the button is driven by
                                                 `carryable` (deficit minus what is already booked), never by Net, so a
                                                 second press cannot mint a duplicate advance. --}}
                                            @if ($row->carryable > 0 && $row->reseller->reseller_type === 'own')
                                                <button type="button" class="btn btn-sm btn-warning carry-fwd-btn mt-1"
                                                        data-reseller="{{ $row->reseller->id }}"
                                                        data-name="{{ $managerLabel }}"
                                                        data-deficit="{{ number_format($row->carryable, 2) }}">
                                                    <i class="fa fa-arrow-right"></i> Carry −Net → Advance
                                                </button>
                                            @endif

                                            @if ($row->carried > 0)
                                                <span class="badge badge-info mt-1"
                                                      title="Already carried forward as Advance Commission from this period (or one overlapping it)">
                                                    <i class="fa fa-arrow-right"></i> Carried {{ number_format($row->carried, 2) }}
                                                </span>
                                            @endif

                                            @if ($row->unpaid <= 0 && $row->carried <= 0 && $row->carryable <= 0 && ($row->core_rent + $row->monthly + $row->real_ip + $row->product + $row->advance) <= 0)
                                                <span class="text-muted">—</span>
                                            @endif
                                            @endif
                                        </td>
                                    @endcan
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="{{ auth()->user()->can('manager-commission-settle') ? 20 : 19 }}" class="text-center text-muted py-3">No managers found.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>

            </div>
        </div>
    </div>
</section>

@can('manager-commission-settle')
<div class="modal fade" id="carryFwdModal" tabindex="-1" role="dialog" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <form method="POST" action="{{ route('manager-commission-report.carry-forward-advance') }}">
            @csrf
            <input type="hidden" name="reseller_id" id="cf_reseller_id">
            <input type="hidden" name="from_date" value="{{ $fromRaw }}">
            <input type="hidden" name="to_date" value="{{ $toRaw }}">
            <input type="hidden" name="settle_filter_reseller" value="{{ implode(',', (array) request('reseller_id')) }}">
            <input type="hidden" name="settle_filter_type" value="{{ $typeRaw }}">
            <div class="modal-content">
                <div class="modal-header bg-warning">
                    <h5 class="modal-title"><i class="fa fa-arrow-right mr-2"></i>Carry Deficit → Advance Commission</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                </div>
                <div class="modal-body">
                    <p class="mb-2">Manager: <strong id="cf_name"></strong></p>
                    <p class="mb-3">Negative Net (deficit): <strong class="text-danger">৳<span id="cf_deficit"></span></strong></p>
                    <div class="form-group">
                        <label>Recover over how many months?</label>
                        <input type="number" name="installment_count" class="form-control" value="1" min="1" max="60" required>
                        <small class="text-muted">An approved Advance Commission is created for the deficit; recovery starts <strong>next month</strong> and its monthly installment is deducted in future reports.</small>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-warning"><i class="fa fa-check"></i> Create Advance</button>
                </div>
            </div>
        </form>
    </div>
</div>
@endcan
@endsection

@section('ajax')
<script>
    $(function () {
        $('.commission-select').each(function () {
            var $el = $(this);
            // Clearing only makes sense where an empty choice exists (or on a multi select);
            // Commission Status has no blank option, so it must not offer the clear cross.
            var clearable = $el.prop('multiple') || $el.find('option[value=""]').length > 0;
            $el.select2({
                theme: 'bootstrap4',
                placeholder: $el.data('placeholder') || '— All Own Managers —',
                allowClear: clearable,
                width: '100%',
            });
        });

        $(document).on('click', '.carry-fwd-btn', function () {
            $('#cf_reseller_id').val($(this).data('reseller'));
            $('#cf_name').text($(this).data('name'));
            $('#cf_deficit').text($(this).data('deficit'));
            $('#carryFwdModal').modal('show');
        });
    });
</script>
@endsection

@include('partials.finance-sticky-table')