@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="mb-0">Result {{ $title_menu }}</h5>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                <div class="nav-wrapper row">
                                    <div class="col">
                                        {{-- button back --}}
                                        <button class="btn btn-secondary mb-0" onclick="history.back()"><i
                                                class="fas fa-circle-left me-1"> </i><span
                                                class="font-weight-bold">Kembali</span></button>
                                    </div>
                                    {{--  --}}
                                </div>
                            </div>
                        </div>

                        {{-- Blade table integration --}}
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <button class="btn btn-danger buttons-pdf mb-3">
                                    <i class="fas fa-file-pdf me-1"></i> Download PDF
                                </button>
                                <table class="table display" id="list_{{ $dmenu }}">
                                    {{-- Check result data --}}
                                    @if ($table_result)
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th colspan="{{ 5 + count($group_lines) * 2 }}" style="text-align: center;">
                                                    Resume Off Grade (group) - {{ $nama_filter }} - {{ $period }}
                                                </th>
                                            </tr>
                                            <tr>
                                                <th rowspan="3" style="text-align: center; vertical-align: middle;">No
                                                </th>
                                                <th rowspan="3" style="text-align: center; vertical-align: middle;">
                                                    Remark</th>
                                                <th colspan="{{ count($group_lines) * 2 }}"
                                                    style="text-align: center; background-color: #FFF9C4;">Before Upgrade
                                                </th>
                                                <th rowspan="2" colspan="2"
                                                    style="text-align: center; vertical-align: middle;">Total</th>
                                            </tr>
                                            <tr>
                                                @foreach ($group_lines as $group_line)
                                                    <th colspan="2" style="text-align: center;">Group {{ $group_line }}
                                                    </th>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                @foreach ($group_lines as $group_line)
                                                    <th style="text-align: center; background-color: #FFF9C4;">Roll (Batch)
                                                    </th>
                                                    <th style="text-align: center; background-color: #FFF9C4;">Weight (kg)
                                                    </th>
                                                @endforeach
                                                <th style="text-align: center;">Roll (Batch)</th>
                                                <th style="text-align: center;">Weight (kg)</th>
                                            </tr>
                                        </thead>

                                        <tbody>
                                            @foreach ($beforeUpgrade as $key => $data)
                                                <tr>
                                                    <td style="text-align: center;">{{ $key + 1 }}</td>
                                                    <td>{{ $data->remark }}</td>
                                                    @foreach ($group_lines as $group_line)
                                                        <td style="text-align: center;background-color: #FFF9C4;">
                                                            {{ $data->{"roll_{$group_line}"} ?? '-' }}
                                                        </td>
                                                        <td style="text-align: center;background-color: #FFF9C4;">
                                                            {{ null !== $data->{"weight_{$group_line}"} ? number_format($data->{"weight_{$group_line}"}, 1) : '-' }}
                                                        </td>
                                                    @endforeach
                                                    <td style="text-align: center;">{{ $data->total_batch }}</td>
                                                    <td style="text-align: center;">
                                                        {{ null !== $data->total_weight ? number_format($data->total_weight, 1) : '-' }}
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>

                                        <tfoot class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th colspan="2" style="text-align: center;">Total Off Grade</th>
                                                @foreach ($group_lines as $group_line)
                                                    {{-- Hitung total roll dan weight per group --}}
                                                    @php
                                                        $total_roll = $beforeUpgrade->sum("roll_{$group_line}");
                                                        $total_weight = $beforeUpgrade->sum("weight_{$group_line}");
                                                    @endphp
                                                    <th style="text-align: center;">
                                                        {{ $total_roll ?? '-' }}
                                                    </th>
                                                    <th style="text-align: center;">
                                                        {{ null !== $total_weight ? number_format($total_weight, 1) : '-' }}
                                                    </th>
                                                @endforeach
                                                {{-- Kolom untuk Total keseluruhan (semua group) --}}
                                                <th style="text-align: center;">
                                                    {{ $beforeUpgrade->sum('total_batch') }}
                                                </th>
                                                <th style="text-align: center;">
                                                    {{ null !== $beforeUpgrade->sum('total_weight') ? number_format($beforeUpgrade->sum('total_weight'), 1) : '-' }}
                                                </th>
                                            </tr>

                                            <tr>
                                                <th colspan="2" style="text-align: center;">Total Produksi</th>
                                                @foreach ($group_lines as $group_line)
                                                    {{-- Mengambil total produksi roll dan weight per group dari $total_produksi --}}
                                                    <th style="text-align: center;">
                                                        {{ $total_produksi->{"roll_{$group_line}"} ?? '-' }}
                                                    </th>
                                                    <th style="text-align: center;">
                                                        {{ null !== $total_produksi->{"weight_{$group_line}"} ? number_format($total_produksi->{"weight_{$group_line}"}, 1) : '-' }}
                                                    </th>
                                                @endforeach
                                                {{-- Kolom untuk Total keseluruhan (semua group) --}}
                                                <th style="text-align: center;">
                                                    {{ $total_produksi->total_batch ?? '-' }}
                                                </th>
                                                <th style="text-align: center;">
                                                    {{ null !== $total_produksi->total_weight ? number_format($total_produksi->total_weight, 1) : '-' }}
                                                </th>
                                            </tr>

                                            <tr>
                                                <th colspan="2" style="text-align: center;">% Off Grade</th>
                                                @foreach ($group_lines as $group_line)
                                                    {{-- Kolom kosong untuk roll (batch) --}}
                                                    <th style="text-align: center;"></th>

                                                    {{-- Kolom untuk weight --}}
                                                    @php
                                                        // Hitung persentase hanya untuk weight per group
                                                        $percent_weight =
                                                            isset($total_produksi->{"weight_{$group_line}"}) &&
                                                            $total_produksi->{"weight_{$group_line}"} > 0
                                                                ? ($total_off_grade->{"weight_{$group_line}"} /
                                                                        $total_produksi->{"weight_{$group_line}"}) *
                                                                    100
                                                                : 0;

                                                    @endphp

                                                    <th style="text-align: center;">
                                                        {{ number_format($percent_weight, 2) }}%
                                                    </th>
                                                @endforeach
                                                {{-- Kolom untuk Total keseluruhan (semua group) --}}
                                                {{-- Kolom kosong untuk total roll (batch) --}}
                                                <th style="text-align: center;"></th>

                                                {{-- Kolom untuk total weight --}}
                                                @php
                                                    // Hitung persentase total keseluruhan hanya untuk weight
                                                    $total_percent_weight =
                                                        isset($total_produksi->total_weight) &&
                                                        $total_produksi->total_weight > 0
                                                            ? ($total_off_grade->total_weight /
                                                                    $total_produksi->total_weight) *
                                                                100
                                                            : 0;
                                                @endphp
                                                <th style="text-align: center;">
                                                    {{ number_format($total_percent_weight, 2) }}%
                                                </th>
                                            </tr>

                                        </tfoot>
                                    @else
                                        <tbody>
                                            <tr>
                                                <td colspan="11">Data not found!</td> {{-- Update colspan to match total columns --}}
                                            </tr>
                                        </tbody>
                                    @endif
                                </table>
                            </div>
                        </div>

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

    {{-- check flag js on dmenu --}}
    @if ($jsmenu == '1')
        @if (view()->exists("js.{$dmenu}"))
            @push('addjs')
                {{-- file js in folder (resources/views/js) --}}
                @include('js.' . $dmenu);
            @endpush
        @else
            @push('addjs')
                <script>
                    Swal.fire({
                        title: 'JS Not Found!!',
                        text: 'Please Create File JS',
                        icon: 'error',
                        confirmButtonColor: '#028284'
                    });
                </script>
            @endpush
        @endif
    @endif
@endsection

@push('js')
    <script src="{{ asset('/') }}assets/js/jspdf.umd.min.js"></script>
    <script src="{{ asset('/') }}assets/js/jspdf.plugin.autotable.min.js"></script>
    {{-- <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.4.0/jspdf.umd.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.25/jspdf.plugin.autotable.min.js"></script> --}}

    <script>
        function exportTableToPDF() {
            const {
                jsPDF
            } = window.jspdf;
            const doc = new jsPDF('landscape', 'mm', 'a4'); // Landscape orientation and A4 size

            // Tambahkan Judul Laporan
            doc.setFontSize(14);
            doc.text('Laporan {{ $title_menu }} - {{ $period }}', 14, 10);

            // Ambil elemen tabel
            const table = document.getElementById('list_{{ $dmenu }}');

            // AutoTable untuk tabel utama
            doc.autoTable({
                html: table,
                startY: 20, // Mulai render tabel di PDF
                theme: 'striped',
                styles: {
                    fontSize: 8, // Ukuran font
                    cellPadding: 3, // Padding dalam tabel
                    halign: 'center', // Horizontal align center
                    valign: 'middle', // Vertical align middle
                },
                headStyles: {
                    fillColor: [0, 183, 189], // Warna header
                    textColor: 255, // Warna teks header
                },
                alternateRowStyles: {
                    fillColor: [240, 240, 240], // Warna baris alternatif
                },
            });

            // Posisi akhir tabel utama
            const finalY = doc.lastAutoTable.finalY + 10;

            // Simpan file PDF
            doc.save('Laporan_{{ $title_menu }}.pdf');
        }

        // Event listener pada tombol ekspor
        document.querySelector('.buttons-pdf').addEventListener('click', exportTableToPDF);
    </script>

    <script>
        // Initialize Datatable
        $('#list_{{ $dmenu }}').DataTable({
            language: {
                search: "Cari :",
                lengthMenu: "Tampilkan _MENU_ baris",
                zeroRecords: "Maaf - Data tidak ada",
                info: "Data _START_ - _END_ dari _TOTAL_",
                infoEmpty: "Tidak ada data",
                infoFiltered: "(pencarian dari _MAX_ data)"
            },
            responsive: true,
            dom: 'frtip',
            pageLength: -1,
            buttons: [{
                    extend: 'pdfHtml5',
                    text: '<i class="fas fa-file-pdf me-1 text-lg text-danger"> </i><span class="font-weight-bold"> PDF',
                    orientation: 'landscape',
                    pageSize: 'A4',
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    },
                },

            ]
        });

        // Custom filter implementation
        let columnAbjad = '';
        $(document).ready(function() {
            let table = $('#list_{{ $dmenu }}').DataTable();
            let numColumns = $('#list_{{ $dmenu }}').DataTable().columns().count();
            let filter = '{{ @$table_class->alias }}'.toLowerCase();
            for (let index = 0; index < numColumns; index++) {
                let columnNames = $('#list_{{ $dmenu }}').DataTable().columns(index).header().to$().text();
                if (columnNames.toLowerCase() == filter.toLowerCase()) {
                    columnAbjad = String.fromCharCode(65 + index);
                }
            }

            $('#{{ @$table_class->field }}').on('change', function() {
                table.columns(columnAbjad + ":name").search(this.value).draw();
            });
        });
    </script>
@endpush