@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])

@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    <div class="card mx-4 shadow-lg">
        <div class="card-body p-3">
            <div class="row gx-4">
                <div class="col-md-12">
                    <div class="nav-wrapper">
                        <button type="button" class="btn btn-secondary mb-0" onclick="window.location='{{ url($url_menu) }}'">
                            <i class="fas fa-arrow-left"></i> Kembali
                        </button>
                        <button type="button" id="btn-pdf" class="btn btn-danger mb-0">
                            <i class="fas fa-file-pdf me-1"></i>
                            Export PDF
                        </button>
                        <button type="button" id="btn-excel" class="btn btn-success mb-0">
                            <i class="fas fa-file-excel me-1"></i>
                            Export Excel
                        </button>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="container-fluid py-4">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="row">
                            <div class="card-header col-md-auto">
                                <h5 class="mb-0">{{ $title_menu }} - {{ $report_title }}</h5>
                            </div>
                            <div class="col">
                                @include('components.alert')
                            </div>

                        </div>
                        <hr class="horizontal dark mt-0">

                        <!-- Results Table -->
                        <div class="row mb-4 px-4">
                            <div class="table-responsive">
                                @if (!empty($isCompactView) && $isCompactView)
                                    {{-- Compact view for all periods (12 months) --}}
                                    <table class="table-bordered custom-report-table" id="pa_detail_table_compact">
                                        <thead class="thead-light" style="background-color:#b0e9eb;">
                                            <tr>
                                                <th class="text-center">No #</th>
                                                <th class="text-center">Standar</th>
                                                <th class="text-center">Bobot</th>
                                                @foreach ($monthHeaders as $header)
                                                    <th class="compact-month text-center">{{ $header['name'] }}</th>
                                                @endforeach
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @forelse ($detailedData as $positionGroup)
                                                {{-- Position Header Row --}}
                                                <tr style="background-color: #FED182; font-weight: bold;">
                                                    <td colspan="{{ 3 + count($monthHeaders ?? []) }}" class="text-left">
                                                        {{ $positionGroup['position_name'] ?? '-' }}
                                                    </td>
                                                </tr>

                                                {{-- Loop through employees in this position --}}
                                                @foreach ($positionGroup['employees'] as $employee)
                                                    {{-- Employee Name Header Row --}}
                                                    <tr style="background-color: #9FED9E; font-weight: bold;">
                                                        <td colspan="{{ 3 + count($monthHeaders ?? []) }}"
                                                            class="text-left">
                                                            {{ $employee['employee_name'] }}
                                                        </td>
                                                    </tr>

                                                    @php
                                                        $standardItems = [];
                                                        $monthlyData = [];

                                                        // Organize by standard (order)
                                                        foreach ($employee['months'] as $monthKey => $monthData) {
                                                            foreach ($monthData['items'] as $item) {
                                                                if (!isset($standardItems[$item->order_no])) {
                                                                    $standardItems[$item->order_no] = [
                                                                        'name' => $item->standard_name,
                                                                        'weight' => $item->weight,
                                                                    ];
                                                                }

                                                                $monthlyData[$item->order_no][$monthKey] = [
                                                                    'final_score' => $item->final_score,
                                                                    'weighted_score' => $item->weighted_score,
                                                                ];
                                                            }
                                                        }

                                                        ksort($standardItems);
                                                        ksort($monthlyData);
                                                    @endphp

                                                    @foreach ($standardItems as $order => $standard)
                                                        <tr>
                                                            <td class="text-center">{{ $order }}</td>
                                                            <td class="compact-standard">{{ $standard['name'] }}</td>
                                                            <td class="text-center">{{ round($standard['weight']) }}</td>

                                                            @foreach ($monthsKeys as $monthKey)
                                                                @php
                                                                    $monthData =
                                                                        $monthlyData[$order][$monthKey] ?? null;
                                                                    $weightedScore = $monthData['weighted_score'] ?? 0;
                                                                @endphp
                                                                <td class="compact-score text-center">
                                                                    {{ $weightedScore > 0 ? number_format($weightedScore, 1) : '-' }}
                                                                </td>
                                                            @endforeach
                                                        </tr>
                                                    @endforeach

                                                    {{-- Total Row for this Employee --}}
                                                    <tr style="font-weight: bold; background-color: #f8f9fa;">
                                                        <td colspan="3" class="text-end">Total</td>
                                                        @php
                                                            $grandTotals = array_fill(0, count($monthsKeys ?? []), 0);
                                                            foreach ($monthlyData as $itemData) {
                                                                foreach ($monthsKeys ?? [] as $idx => $mKey) {
                                                                    if (isset($itemData[$mKey])) {
                                                                        $grandTotals[$idx] +=
                                                                            $itemData[$mKey]['weighted_score'];
                                                                    }
                                                                }
                                                            }
                                                        @endphp

                                                        @foreach ($grandTotals as $total)
                                                            <td class="text-center">
                                                                {{ $total > 0 ? rtrim(rtrim(number_format($total, 2), '0'), '.') : '-' }}
                                                            </td>
                                                        @endforeach
                                                    </tr>
                                                @endforeach
                                            @empty
                                                <tr>
                                                    <td colspan="{{ 3 + count($monthHeaders ?? []) }}" class="text-center">
                                                        Tidak ada Data.
                                                    </td>
                                                </tr>
                                            @endforelse
                                        </tbody>
                                    </table>
                                @else
                                    {{-- Detailed view for specific periods (3 months) --}}
                                    <table class="table-bordered custom-report-table" id="pa_detail_table">
                                        <thead class="thead-light" style="background-color:#b0e9eb;">
                                            <!-- First Header Row -->
                                            <tr>
                                                <th rowspan="2" class="text-center align-middle"
                                                    style="vertical-align: middle;">No #</th>
                                                <th rowspan="2" class="text-center align-middle"
                                                    style="vertical-align: middle;">Standar</th>
                                                @if (!empty($monthHeaders))
                                                    @foreach ($monthHeaders as $header)
                                                        <th colspan="4" class="text-center">{{ $header['name'] }}</th>
                                                    @endforeach
                                                @else
                                                    <th colspan="4" class="text-center">No Data</th>
                                                @endif
                                            </tr>
                                            <!-- Second Header Row -->
                                            <tr>
                                                @if (!empty($monthHeaders))
                                                    @foreach ($monthHeaders as $header)
                                                        <th class="text-center">Bobot</th>
                                                        <th class="text-center">Nilai</th>
                                                        <th class="text-center">Total</th>
                                                        <th class="text-center">#</th>
                                                    @endforeach
                                                @else
                                                    <th class="text-center">Bobot</th>
                                                    <th class="text-center">Nilai</th>
                                                    <th class="text-center">Total</th>
                                                    <th class="text-center">#</th>
                                                @endif
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @forelse ($detailedData as $positionGroup)
                                                {{-- Position Header Row --}}
                                                <tr style="background-color: #FED182; font-weight: bold;">
                                                    <td colspan="{{ 2 + count($monthHeaders ?? []) * 4 }}"
                                                        class="text-left">
                                                        {{ $positionGroup['position_name'] ?? '-' }}</td>
                                                </tr>

                                                {{-- Loop through employees in this position --}}
                                                @foreach ($positionGroup['employees'] as $employee)
                                                    {{-- Employee Name Header Row --}}
                                                    <tr style="background-color: #9FED9E; font-weight: bold;">
                                                        <td colspan="{{ 2 + count($monthHeaders ?? []) * 4 }}"
                                                            class="text-left">{{ $employee['employee_name'] }}
                                                        </td>
                                                    </tr>

                                                    @php
                                                        $standardItems = [];
                                                        $monthlyData = [];

                                                        // Organize by standard (order)
                                                        foreach ($employee['months'] as $monthKey => $monthData) {
                                                            foreach ($monthData['items'] as $item) {
                                                                // NOTE: $item is stdClass from query—access with ->
                                                                if (!isset($standardItems[$item->order_no])) {
                                                                    $standardItems[$item->order_no] = [
                                                                        'name' => $item->standard_name,
                                                                        'weight' => $item->weight,
                                                                    ];
                                                                }

                                                                $monthlyData[$item->order_no][$monthKey] = [
                                                                    'final_score' => $item->final_score,
                                                                    'original_score' => $item->original_score,
                                                                    'weighted_score' => $item->weighted_score,
                                                                    'reason' => $item->revision_reason,
                                                                    'is_revised' => $item->is_revised,
                                                                    'weight' => $item->weight, // Add weight here for month-specific access
                                                                ];
                                                            }
                                                        }

                                                        ksort($standardItems);
                                                        ksort($monthlyData);
                                                    @endphp

                                                    @foreach ($standardItems as $order => $standard)
                                                        <tr>
                                                            <td class="text-center">{{ $order }}</td>
                                                            <td>{{ $standard['name'] }}</td>

                                                            @php
                                                                $monthTotals = [];
                                                            @endphp

                                                            @foreach ($monthsKeys as $monthKey)
                                                                @php
                                                                    $monthData =
                                                                        $monthlyData[$order][$monthKey] ?? null;
                                                                    // Use month-specific weight instead of standard weight
                                                                    $weight =
                                                                        $monthData && isset($monthData['weight'])
                                                                            ? round($monthData['weight'])
                                                                            : '-';
                                                                    $finalScore = $monthData['final_score'] ?? 0;
                                                                    $originalScore = $monthData['original_score'] ?? 0;
                                                                    $isRevised = $monthData['is_revised'] ?? false;
                                                                    $weightedScore = $monthData['weighted_score'] ?? 0;
                                                                    $reason = $monthData['reason'] ?? '';

                                                                    $scoreDisplay = $finalScore;
                                                                    if ($isRevised && $originalScore != $finalScore) {
                                                                        $scoreDisplay =
                                                                            $finalScore . ' (' . $originalScore . ')';
                                                                    }

                                                                    $monthTotals[] = $weightedScore;
                                                                @endphp

                                                                <td class="text-center">{{ $weight }}</td>
                                                                <td class="text-center">{{ $scoreDisplay ?: '-' }}</td>
                                                                <td class="text-center">
                                                                    {{ $weightedScore > 0 ? rtrim(rtrim(number_format($weightedScore, 2), '0'), '.') : '-' }}
                                                                </td>
                                                                <td class="text-center">
                                                                    {{ $reason }}
                                                                </td>
                                                            @endforeach
                                                        </tr>
                                                    @endforeach

                                                    {{-- Total Row for this Employee --}}
                                                    <tr style="font-weight: bold; background-color: #f8f9fa;">
                                                        @php
                                                            $grandTotals = array_fill(0, count($monthsKeys ?? []), 0);
                                                            foreach ($monthlyData as $itemData) {
                                                                foreach ($monthsKeys ?? [] as $idx => $mKey) {
                                                                    if (isset($itemData[$mKey])) {
                                                                        $grandTotals[$idx] +=
                                                                            $itemData[$mKey]['weighted_score'];
                                                                    }
                                                                }
                                                            }
                                                        @endphp

                                                        @foreach ($grandTotals as $index => $total)
                                                            @if ($index === 0)
                                                                {{-- First month: colspan for No#, Standar, Bobot, Nilai --}}
                                                                <td colspan="4" class="text-end">Total</td>
                                                                <td class="text-center">
                                                                    {{ rtrim(rtrim(number_format($total, 2), '0'), '.') }}
                                                                </td>
                                                            @else
                                                                {{-- Other months: colspan for Bobot, Nilai --}}
                                                                <td colspan="3" class="text-end">Total</td>
                                                                <td class="text-center">
                                                                    {{ rtrim(rtrim(number_format($total, 2), '0'), '.') }}
                                                                </td>
                                                            @endif
                                                        @endforeach
                                                        <td class="text-center"></td> {{-- # column --}}
                                                    </tr>
                                                @endforeach
                                            @empty
                                                <tr>
                                                    <td colspan="{{ 2 + max($monthHeaders ? count($monthHeaders) * 4 : 0, 4) }}"
                                                        class="text-center">
                                                        Tidak ada Data.</td>
                                                </tr>
                                            @endforelse
                                        </tbody>
                                    </table>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('js')
    <script>
        $(document).ready(function() {
            // Prevent any automatic DataTables initialization
            if ($.fn.DataTable) {
                // Destroy any existing DataTables instance
                if ($.fn.DataTable.isDataTable('#pa_detail_table')) {
                    $('#pa_detail_table').DataTable().destroy();
                }
                if ($.fn.DataTable.isDataTable('#pa_detail_table_compact')) {
                    $('#pa_detail_table_compact').DataTable().destroy();
                }

                // Prevent automatic initialization by removing data attributes
                $('#pa_detail_table, #pa_detail_table_compact').removeAttr('data-toggle data-target');
            }

            // PDF Export functionality using server-side mPDF
            $('#btn-pdf').click(function() {
                generatePDFServerSide();
            });

            // Excel Export functionality using SheetJS
            $('#btn-excel').click(function() {
                generateExcel();
            });
        });

        function generatePDFServerSide() {
            try {
                // Show loading state
                const button = $('#btn-pdf');
                const originalText = button.html();
                button.prop('disabled', true).html('<i class="fas fa-spinner fa-spin me-1"></i>Generating...');

                // Create form with current filter parameters
                const form = $('<form>', {
                    method: 'GET',
                    action: '{{ route('rptout.export-pdf') }}',
                    style: 'display: none;',
                    target: '_blank'
                });

                // Add current filter parameters
                form.append($('<input>', {
                    name: 'department',
                    value: '{{ request('department') }}'
                }));
                form.append($('<input>', {
                    name: 'employee',
                    value: '{{ request('employee') }}'
                }));
                form.append($('<input>', {
                    name: 'year',
                    value: '{{ request('year') }}'
                }));
                form.append($('<input>', {
                    name: 'period',
                    value: '{{ request('period') }}'
                }));
                form.append($('<input>', {
                    name: 'status',
                    value: '{{ request('status') }}'
                }));

                // Submit form to trigger download
                $('body').append(form);
                form.submit();
                form.remove();

                // Reset button after short delay
                setTimeout(() => {
                    button.prop('disabled', false).html(originalText);
                }, 2000);

            } catch (e) {
                console.error('PDF export failed:', e);
                alert('PDF export failed: ' + e.message);

                // Reset button on error
                const button = $('#btn-pdf');
                button.prop('disabled', false).html('<i class="fas fa-file-pdf me-1"></i>Export PDF');
            }
        }

        function generateExcel() {
            try {
                // Show loading state
                const button = $('#btn-excel');
                const originalText = button.html();
                button.prop('disabled', true).html('<i class="fas fa-spinner fa-spin me-1"></i>Generating...');

                // Create form with current filter parameters
                const form = $('<form>', {
                    method: 'GET',
                    action: '{{ route('rptout.export-excel') }}',
                    style: 'display: none;'
                });

                // Add current filter parameters
                form.append($('<input>', {
                    name: 'department',
                    value: '{{ request('department') }}'
                }));
                form.append($('<input>', {
                    name: 'employee',
                    value: '{{ request('employee') }}'
                }));
                form.append($('<input>', {
                    name: 'year',
                    value: '{{ request('year') }}'
                }));
                form.append($('<input>', {
                    name: 'period',
                    value: '{{ request('period') }}'
                }));
                form.append($('<input>', {
                    name: 'status',
                    value: '{{ request('status') }}'
                }));

                // Submit form to trigger download
                $('body').append(form);
                form.submit();
                form.remove();

                // Reset button after short delay
                setTimeout(() => {
                    button.prop('disabled', false).html(originalText);
                }, 2000);

            } catch (e) {
                console.error('Excel export failed:', e);
                alert('Excel export failed: ' + e.message);

                // Reset button on error
                const button = $('#btn-excel');
                button.prop('disabled', false).html('<i class="fas fa-file-excel me-1"></i>Export Excel');
            }
        }
    </script>

    <style>
        /* Better table styling for complex structure */
        #pa_detail_table,
        #pa_detail_table_compact {
            width: 100%;
        }

        #pa_detail_table th,
        #pa_detail_table td,
        #pa_detail_table_compact th,
        #pa_detail_table_compact td {
            border: 1px solid #000;
            color: #000;
            padding: 8px;
            vertical-align: middle;
            font-size: 12px;
            word-wrap: break-word;
            word-break: break-word;
            white-space: normal;
            max-width: 150px;
        }

        /* Compact table specific styling */
        #pa_detail_table_compact {
            font-size: 11px;
        }

        #pa_detail_table_compact th,
        #pa_detail_table_compact td {
            padding: 6px 4px;
            font-size: 11px;
        }

        /* Month columns in compact view - very narrow */
        #pa_detail_table_compact .compact-month {
            max-width: 60px;
            min-width: 60px;
            font-size: 10px;
            writing-mode: vertical-rl;
            text-orientation: mixed;
            white-space: nowrap;
            height: 80px;
            padding: 4px 2px;
        }

        /* Standard name column in compact view */
        #pa_detail_table_compact .compact-standard {
            max-width: 200px;
            min-width: 150px;
            font-size: 10px;
        }

        /* Score columns in compact view */
        #pa_detail_table_compact .compact-score {
            max-width: 50px;
            min-width: 50px;
            font-size: 10px;
            text-align: center !important;
        }

        /* Specific styling for reason columns (# columns) - columns 6, 10, 14 but NOT in total row */
        #pa_detail_table tbody tr:not([style*="background-color: #f8f9fa"]) td:nth-child(6),
        #pa_detail_table tbody tr:not([style*="background-color: #f8f9fa"]) td:nth-child(10),
        #pa_detail_table tbody tr:not([style*="background-color: #f8f9fa"]) td:nth-child(14),
        #pa_detail_table th:nth-child(6),
        #pa_detail_table th:nth-child(10),
        #pa_detail_table th:nth-child(14) {
            max-width: 120px;
            font-size: 10px;
            line-height: 1.2;
            word-wrap: break-word;
            word-break: break-word;
            white-space: normal;
        }

        /* Standard column - make it wider for detailed view */
        #pa_detail_table td:nth-child(2) {
            max-width: 250px;
        }

        /* Number columns - keep narrow (excluding reason columns) for detailed view */
        #pa_detail_table td:nth-child(1),
        #pa_detail_table td:nth-child(3),
        #pa_detail_table td:nth-child(4),
        #pa_detail_table td:nth-child(5),
        #pa_detail_table td:nth-child(7),
        #pa_detail_table td:nth-child(8),
        #pa_detail_table td:nth-child(9),
        #pa_detail_table td:nth-child(11),
        #pa_detail_table td:nth-child(12),
        #pa_detail_table td:nth-child(13) {
            max-width: 80px;
        }

        .table-bordered {
            border: 1px solid #dee2e6;
        }

        /* Responsive table */
        .table-responsive {
            overflow-x: auto;
        }

        /* Export button styling */
        #btn-pdf,
        #btn-excel {
            transition: all 0.3s ease;
            margin-left: 8px;
        }

        #btn-pdf:hover,
        #btn-excel:hover {
            transform: translateY(-1px);
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
        }

        /* Mobile responsiveness for compact view */
        @media (max-width: 768px) {
            #pa_detail_table_compact .compact-month {
                writing-mode: horizontal-tb;
                text-orientation: unset;
                height: auto;
                max-width: 40px;
                min-width: 40px;
            }
        }
    </style>
@endpush