@extends('layouts.app')

@section('title', __('Pending Status'))

@php
    $filters = $summary['filters'];
    $options = $summary['filter_options'];
    $officerRows = is_array($officerRows ?? null) ? $officerRows : ($summary['officers'] ?? []);
    $officerPaginator = $officerPaginator ?? null;
    $officerTotals = $summary['officer_totals'] ?? null;
    $selectedReportTypes = is_array($filters['report_types'] ?? null) ? $filters['report_types'] : [];
    $exportParams = array_filter([
        'date_from' => $filters['date_from'] ?? null,
        'date_to' => $filters['date_to'] ?? null,
        'date_field' => (($filters['date_field'] ?? '') === \App\Support\MecReportDateFieldFilter::PUBLISHED_DATE)
            ? \App\Support\MecReportDateFieldFilter::PUBLISHED_DATE
            : null,
        'region_id' => $filters['region_id'] ?? null,
    ], static fn ($v) => $v !== null && $v !== '');
    if ($selectedReportTypes !== []) {
        $exportParams['report_type'] = $selectedReportTypes;
    }
    $exportQuery = http_build_query($exportParams);
    $rfsResetUrl = route('reports.report-for-sims.index');
    $rfsFiltersOpen = (int) ($filters['region_id'] ?? 0) > 0
        || ($filters['date_from'] ?? '') !== ''
        || ($filters['date_to'] ?? '') !== ''
        || ($filters['date_field'] ?? '') === \App\Support\MecReportDateFieldFilter::PUBLISHED_DATE
        || $selectedReportTypes !== [];
@endphp

@push('stylesheets')
@include('partials.index-datatable-styles')
@include('partials.filter-card-styles')
@include('partials.collapsible-filter-styles')
<link rel="stylesheet" href="{{ asset('assets/plugins/select2/css/select2.min.css') }}">
<link rel="stylesheet" href="{{ asset('assets/plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('assets/plugins/select2-bootstrap4-theme/select2-bootstrap4-custom.css') }}">
<style>
    .report-filter-form {
        display: flex;
        flex-wrap: wrap;
        align-items: flex-end;
        gap: 1rem 1.5rem;
    }
    .report-filter-field {
        display: flex;
        flex-direction: column;
        min-width: 0;
    }
    .report-filter-field label {
        font-weight: 700;
        font-size: 0.7rem;
        text-transform: uppercase;
        letter-spacing: 0.02em;
        color: #212529;
        margin-bottom: 0.35rem;
    }
    .report-filter-field .form-control {
        border-radius: 6px;
        min-height: 38px;
        background: #fff;
    }
    .report-filter-field select.form-control {
        min-width: 150px;
    }
    .report-filter-field .select2-container {
        min-width: 150px;
    }
    .report-filter-field .select2-container--bootstrap4 .select2-selection--single,
    .report-filter-field .select2-container--bootstrap4 .select2-selection--multiple {
        min-height: 38px;
        height: auto !important;
        border-radius: 6px;
    }
    #rfs-type + .select2-container { width: 100% !important; min-width: 180px; }
    #rfs-type + .select2-container .select2-selection--multiple { min-height: 38px; }
    .rfs-card .card-title { font-weight: 600; }
    .rfs-note { font-size: 0.8125rem; color: #6c757d; }
    .rfs-section-title {
        font-weight: 600;
        margin: 1.25rem 0 0.75rem;
    }
    .rfs-legend {
        display: flex;
        flex-wrap: wrap;
        gap: 0.75rem 1.25rem;
        font-size: 0.8125rem;
        color: #495057;
        margin-bottom: 0.75rem;
    }
    /* Desk columns — light tint, same as Summary group (single-row header) */
    #tblReportForSimsRegions thead th.rfs-desk,
    #tblReportForSimsRegions tbody td.rfs-desk,
    #tblReportForSimsRegions tfoot th.rfs-desk,
    #tblReportForSimsOfficers thead th.rfs-desk,
    #tblReportForSimsOfficers tbody td.rfs-desk,
    #tblReportForSimsOfficers tfoot th.rfs-desk {
        background-color: #fff8e1;
    }
    .rfs-card #tblReportForSimsRegions thead th,
    .rfs-card #tblReportForSimsRegions tbody td,
    .rfs-card #tblReportForSimsRegions tfoot th,
    .rfs-card #tblReportForSimsOfficers thead th,
    .rfs-card #tblReportForSimsOfficers tbody td,
    .rfs-card #tblReportForSimsOfficers tfoot th {
        text-align: center !important;
        vertical-align: middle;
    }
    .rfs-card #tblReportForSimsRegions th.col-label,
    .rfs-card #tblReportForSimsRegions td.col-label,
    .rfs-card #tblReportForSimsOfficers th.col-label,
    .rfs-card #tblReportForSimsOfficers td.col-label {
        white-space: nowrap;
    }
    #tblReportForSimsRegions tfoot th,
    #tblReportForSimsOfficers tfoot th {
        font-weight: 700;
    }
</style>
@endpush

@section('contents')
<section class="content">
    <div class="container-fluid">
        <x-collapsible-filter-card
            :title="__('FILTERS')"
            collapse-id="reportForSimsFiltersCollapse"
            form-id="reportForSimsFilterForm"
            :reset-url="$rfsResetUrl"
            :open="$rfsFiltersOpen"
        >
            <div class="card-body">
                <form method="get" action="{{ route('reports.report-for-sims.index') }}" class="report-filter-form" id="reportForSimsFilterForm">
                    <input type="hidden" name="per_page" value="{{ (int) ($perPage ?? 25) }}">
                    <div class="report-filter-field">
                        <label for="rfs-region">{{ __('Region') }}</label>
                        <select name="region_id" id="rfs-region" class="form-control form-control-sm report-filter-select">
                            <option value="">{{ __('All regions') }}</option>
                            @foreach ($options['regions'] as $region)
                                <option value="{{ $region['id'] }}" @selected((int) ($filters['region_id'] ?? 0) === (int) $region['id'])>
                                    {{ $region['name'] }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="report-filter-field">
                        <label for="rfs-date-field">{{ __('Date') }}</label>
                        <select name="date_field" id="rfs-date-field" class="form-control form-control-sm report-filter-select">
                            @foreach (\App\Support\MecReportDateFieldFilter::options() as $dateFieldOption)
                                <option value="{{ $dateFieldOption['value'] }}" @selected(($filters['date_field'] ?? \App\Support\MecReportDateFieldFilter::VISIT_DATE) === $dateFieldOption['value'])>
                                    {{ $dateFieldOption['label'] }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="report-filter-field">
                        <label for="rfs-from">{{ __('Date from') }}</label>
                        <input type="date" name="date_from" id="rfs-from" class="form-control form-control-sm"
                               value="{{ $filters['date_from'] ?? '' }}">
                    </div>
                    <div class="report-filter-field">
                        <label for="rfs-to">{{ __('Date to') }}</label>
                        <input type="date" name="date_to" id="rfs-to" class="form-control form-control-sm"
                               value="{{ $filters['date_to'] ?? '' }}">
                    </div>
                    <div class="report-filter-field">
                        <label for="rfs-type">{{ __('Report type') }}</label>
                        <select name="report_type[]" id="rfs-type" class="form-control form-control-sm" multiple
                                data-placeholder="{{ __('All types') }}">
                            @foreach ($options['report_types'] as $type)
                                <option value="{{ $type['code'] }}" @selected(in_array($type['code'], $selectedReportTypes, true))>
                                    {{ $type['label'] }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </form>
            </div>
        </x-collapsible-filter-card>

        <div class="card rfs-card shadow-sm pms-index-card">
            <div class="card-header d-flex flex-wrap align-items-center justify-content-between gap-2">
                <div>
                    <h3 class="card-title mb-0">{{ __('Pending Status') }}</h3>
                    <p class="rfs-note mb-0 mt-1">
                        {{ __('Region Wise Pending Status upto :period', ['period' => $summary['title_period']]) }}
                    </p>
                </div>
                <a href="{{ route('reports.report-for-sims.export') }}{{ $exportQuery !== '' ? '?'.$exportQuery : '' }}"
                   class="btn btn-sm btn-success">
                    <i class="fas fa-file-excel mr-1"></i>{{ __('Export Excel') }}
                </a>
            </div>
            <div class="card-body p-3">
                <!-- <div class="rfs-legend">
                    <span><strong>{{ __('Assigned') }}</strong>: {{ __('Live approved visit-plan schemes in range + cancelled schemes (Assigned includes Cancelled)') }}</span>
                    <span><strong>{{ __('Cancelled') }}</strong>: {{ __('Schemes cancelled via approved modification requests whose visit plan month overlaps the selected range') }}</span>
                    <span><strong>{{ __('Published') }}</strong>: {{ __('Published M&E reports on live assigned schemes') }}</span>
                    <span><strong>{{ __('Approved') }}</strong>: {{ __('Final-approved M&E reports awaiting publish on live assigned schemes') }}</span>
                    <span><strong>{{ __('MEO/SMEO / RD / SDM / D.G') }}</strong>: {{ __('In-process (incl. declined/returned) reports on live assigned schemes, by current desk') }}</span>
                    <span><strong>{{ __('Pending') }}</strong>: {{ __('Live assigned schemes with no submitted report (drafts count as pending)') }}</span>
                    <span><strong>{{ __('Report type') }}</strong>: {{ __('Multi-select; scopes visit plans that can produce those types and filters report columns (RMR, CMR, etc.)') }}</span>
                    <span><strong>{{ __('Target') }}</strong>: {{ __('Left empty') }}</span>
                </div> -->

                <h5 class="rfs-section-title">{{ __('Region Wise Pending Status') }}</h5>
                <div class="table-responsive">
                    <table class="table table-striped table-bordered mb-0 w-100 pms-index-datatable" id="tblReportForSimsRegions" style="width:100%">
                        <thead>
                            <tr>
                                <th class="col-label" data-sort-col="region">{{ __('Region') }}</th>
                                <th>{{ __('Target') }}</th>
                                <th data-sort-col="assigned">{{ __('Assigned') }}</th>
                                <th data-sort-col="cancelled">{{ __('Cancelled') }}</th>
                                <th data-sort-col="published">{{ __('Published') }}</th>
                                <th data-sort-col="approved">{{ __('Approved') }}</th>
                                <th class="rfs-desk" data-sort-col="meo">{{ __('MEO/SMEO') }}</th>
                                <th class="rfs-desk" data-sort-col="rd">{{ __('RD') }}</th>
                                <th class="rfs-desk" data-sort-col="sdm">{{ __('SDM') }}</th>
                                <th class="rfs-desk" data-sort-col="dg">{{ __('D.G') }}</th>
                                <th data-sort-col="pending">{{ __('Pending') }}</th>
                                <th data-sort-col="sat">{{ __('SAT') }}</th>
                                <th data-sort-col="sat_pct">{{ __('SAT%') }}</th>
                                <th data-sort-col="unsat">{{ __('UNSAT') }}</th>
                                <th data-sort-col="unsat_pct">{{ __('UNSAT%') }}</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($summary['regions'] as $row)
                                <tr>
                                    <td class="col-label">{{ $row['region'] }}</td>
                                    <td></td>
                                    <td>{{ $row['assigned'] }}</td>
                                    <td>{{ $row['cancelled'] ?? 0 }}</td>
                                    <td>{{ $row['published'] }}</td>
                                    <td>{{ $row['approved'] ?? 0 }}</td>
                                    <td class="rfs-desk">{{ $row['meo'] }}</td>
                                    <td class="rfs-desk">{{ $row['rd'] }}</td>
                                    <td class="rfs-desk">{{ $row['sdm'] }}</td>
                                    <td class="rfs-desk">{{ $row['dg'] }}</td>
                                    <td>{{ $row['pending'] }}</td>
                                    <td>{{ $row['sat'] }}</td>
                                    <td>{{ $row['sat_pct'] }}%</td>
                                    <td>{{ $row['unsat'] }}</td>
                                    <td>{{ $row['unsat_pct'] }}%</td>
                                </tr>
                            @empty
                            @endforelse
                        </tbody>
                        @if (count($summary['regions']) > 0)
                        <tfoot>
                            <tr>
                                <th class="col-label">{{ __('Total') }}</th>
                                <th></th>
                                <th>{{ $summary['totals']['assigned'] }}</th>
                                <th>{{ $summary['totals']['cancelled'] ?? 0 }}</th>
                                <th>{{ $summary['totals']['published'] }}</th>
                                <th>{{ $summary['totals']['approved'] ?? 0 }}</th>
                                <th class="rfs-desk">{{ $summary['totals']['meo'] }}</th>
                                <th class="rfs-desk">{{ $summary['totals']['rd'] }}</th>
                                <th class="rfs-desk">{{ $summary['totals']['sdm'] }}</th>
                                <th class="rfs-desk">{{ $summary['totals']['dg'] }}</th>
                                <th>{{ $summary['totals']['pending'] }}</th>
                                <th>{{ $summary['totals']['sat'] }}</th>
                                <th>{{ $summary['totals']['sat_pct'] }}%</th>
                                <th>{{ $summary['totals']['unsat'] }}</th>
                                <th>{{ $summary['totals']['unsat_pct'] }}%</th>
                            </tr>
                        </tfoot>
                        @endif
                    </table>
                </div>

                <h5 class="rfs-section-title">{{ __('MEO Wise Performance Review') }}</h5>
                <div class="table-responsive">
                    <table class="table table-striped table-bordered mb-0 w-100 pms-index-datatable" id="tblReportForSimsOfficers" style="width:100%">
                        <thead>
                            <tr>
                                <th class="col-label" data-sort-col="officer">{{ __('Monitoring Officer') }}</th>
                                <th data-sort-col="assigned">{{ __('Assigned') }}</th>
                                <th data-sort-col="cancelled">{{ __('Cancelled') }}</th>
                                <th data-sort-col="published">{{ __('Published') }}</th>
                                <th data-sort-col="approved">{{ __('Approved') }}</th>
                                <th class="rfs-desk" data-sort-col="meo">{{ __('MEO/SMEO') }}</th>
                                <th class="rfs-desk" data-sort-col="rd">{{ __('RD') }}</th>
                                <th class="rfs-desk" data-sort-col="sdm">{{ __('SDM') }}</th>
                                <th class="rfs-desk" data-sort-col="dg">{{ __('D.G') }}</th>
                                <th data-sort-col="pending">{{ __('Pending') }}</th>
                                <th data-sort-col="sat">{{ __('SAT') }}</th>
                                <th data-sort-col="sat_pct">{{ __('SAT%') }}</th>
                                <th data-sort-col="unsat">{{ __('UNSAT') }}</th>
                                <th data-sort-col="unsat_pct">{{ __('UNSAT%') }}</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($officerRows as $row)
                                <tr>
                                    <td class="col-label">{{ $row['officer'] }}</td>
                                    <td>{{ $row['assigned'] }}</td>
                                    <td>{{ $row['cancelled'] ?? 0 }}</td>
                                    <td>{{ $row['published'] }}</td>
                                    <td>{{ $row['approved'] ?? 0 }}</td>
                                    <td class="rfs-desk">{{ $row['meo'] }}</td>
                                    <td class="rfs-desk">{{ $row['rd'] }}</td>
                                    <td class="rfs-desk">{{ $row['sdm'] }}</td>
                                    <td class="rfs-desk">{{ $row['dg'] }}</td>
                                    <td>{{ $row['pending'] }}</td>
                                    <td>{{ $row['sat'] }}</td>
                                    <td>{{ $row['sat_pct'] }}%</td>
                                    <td>{{ $row['unsat'] }}</td>
                                    <td>{{ $row['unsat_pct'] }}%</td>
                                </tr>
                            @empty
                            @endforelse
                        </tbody>
                        @if (count($summary['officers']) > 0 && is_array($officerTotals))
                        <tfoot>
                            <tr>
                                <th class="col-label">{{ __('Total') }}</th>
                                <th>{{ $officerTotals['assigned'] }}</th>
                                <th>{{ $officerTotals['cancelled'] ?? 0 }}</th>
                                <th>{{ $officerTotals['published'] }}</th>
                                <th>{{ $officerTotals['approved'] ?? 0 }}</th>
                                <th class="rfs-desk">{{ $officerTotals['meo'] }}</th>
                                <th class="rfs-desk">{{ $officerTotals['rd'] }}</th>
                                <th class="rfs-desk">{{ $officerTotals['sdm'] }}</th>
                                <th class="rfs-desk">{{ $officerTotals['dg'] }}</th>
                                <th>{{ $officerTotals['pending'] }}</th>
                                <th>{{ $officerTotals['sat'] }}</th>
                                <th>{{ $officerTotals['sat_pct'] }}%</th>
                                <th>{{ $officerTotals['unsat'] }}</th>
                                <th>{{ $officerTotals['unsat_pct'] }}%</th>
                            </tr>
                        </tfoot>
                        @endif
                    </table>
                </div>
                @include('partials.listing-pagination', [
                    'paginator' => $officerPaginator,
                    'perPage' => $perPage ?? 25,
                    'baseUrl' => route('reports.report-for-sims.index'),
                ])
            </div>
        </div>
    </div>
</section>
@endsection

@push('scripts')
@include('partials.index-datatable-scripts')
@include('partials.collapsible-filter-scripts')
@include('reports.partials.mec-listing-filter-form-scripts')
<script>
(function () {
    function initSummaryTable(selector, emptyMessage, options) {
        options = options || {};
        var $tbl = $(selector);
        if (!$tbl.length || typeof window.PmsIndexDataTable === 'undefined') {
            return;
        }
        if ($.fn.DataTable.isDataTable($tbl)) {
            $tbl.DataTable().destroy();
        }
        $tbl.attr('data-pms-empty-message', emptyMessage);
        PmsIndexDataTable.initLaravelPaginated(selector, {
            scrollX: false,
            ordering: options.ordering !== false,
            searching: !!options.searching,
            autoWidth: false,
        });
    }

    $(function () {
        if ($.fn.select2) {
            $('#rfs-type').select2({
                theme: 'bootstrap4',
                width: '100%',
                placeholder: @json(__('All types')),
                allowClear: true,
                closeOnSelect: false,
            });
        }
        initSummaryTable('#tblReportForSimsRegions', @json(__('No region summary rows.')), { searching: true, ordering: false });
        initSummaryTable('#tblReportForSimsOfficers', @json(__('No officer summary rows.')), { searching: false, ordering: false });

        var sortOptions = {
            baseUrl: '{{ request()->url() }}',
            currentQuery: @json(request()->except(['page', 'sort_col', 'sort_dir'])),
            currentSortCol: '{{ request('sort_col', '') }}',
            currentSortDir: '{{ request('sort_dir', 'asc') }}'
        };
        if (typeof PmsIndexDataTable.attachServerSort === 'function') {
            PmsIndexDataTable.attachServerSort('#tblReportForSimsRegions', sortOptions);
            PmsIndexDataTable.attachServerSort('#tblReportForSimsOfficers', sortOptions);
        }
    });
})();
</script>
@endpush