@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</button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <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 table-bordered" id="list_{{ $dmenu }}">
                                    <thead>
                                        <tr>
                                            <th colspan="{{ 5 + count($group_lines) * 2 }}"
                                                style="text-align: center;background-color: #00b7bd4f;">
                                                <strong>
                                                    Annual Off grade - {{ $nama_filter }} - {{ $period }}</strong>
                                            </th>
                                        </tr>
                                        <tr>
                                            <th rowspan="2"
                                                style="text-align: center; background-color: #00b7bd4f;vertical-align: middle;">
                                                <strong>
                                                    No</strong>
                                            </th>
                                            <th rowspan="2"
                                                style="text-align: center; background-color: #00b7bd4f;vertical-align: middle;">
                                                <strong>
                                                    Month</strong>
                                            </th>
                                            <th colspan="3" style="text-align: center; background-color: #fff9c4;">
                                                <strong>
                                                    Before Upgrade</strong>
                                            </th>
                                            <th colspan="3" style="text-align: center; background-color: #ffcccc;">
                                                <strong>
                                                    After Upgrade</strong>
                                            </th>
                                        </tr>
                                        <tr>
                                            <th style="text-align: center; background-color: #fff9c4;"><strong>Offgrade
                                                    (kg)</strong></th>
                                            <th style="text-align: center; background-color: #fff9c4;"><strong>Total
                                                    produksi (kg)</strong></th>
                                            <th style="text-align: center; background-color: #fff9c4;"><strong>% Offgrade
                                                    (BU)</strong></th>
                                            <th style="text-align: center; background-color: #ffcccc;"><strong>Offgrade
                                                    (kg)</strong></th>
                                            <th style="text-align: center; background-color: #ffcccc;"><strong>Total
                                                    produksi (kg)</strong></th>
                                            <th style="text-align: center; background-color: #ffcccc;"><strong>% Offgrade
                                                    (AU)</strong></th>
                                        </tr>
                                    </thead>

                                    <tbody>
                                        @php
                                            $yearlyTotalBeforeOffgrade = 0;
                                            $yearlyTotalAfterOffgrade = 0;
                                            $yearlyTotalProduksi = 0; // Total produksi untuk keseluruhan tahun
                                        @endphp
                                        @for ($i = 1; $i <= 12; $i++)
                                            @php
                                                // Format bulan dengan tahun yang sesuai
                                                $monthPeriod = $period . str_pad($i, 2, '0', STR_PAD_LEFT); // Format: 202403 untuk Maret 2024
                                                $beforeOffgrade = $beforeUpgrade[$monthPeriod]->total_offgrade ?? 0;
                                                $afterOffgrade = $afterUpgrade[$monthPeriod]->total_offgrade ?? 0;
                                                $produksi = $totalProduksi[$monthPeriod]->total_produksi ?? 0;

                                                // Menghitung total tahunan
                                                $yearlyTotalBeforeOffgrade += $beforeOffgrade;
                                                $yearlyTotalAfterOffgrade += $afterOffgrade;
                                                $yearlyTotalProduksi += $produksi;

                                                // Menghitung % Offgrade (BU) dan (AU)
                                                $offgradeBuPercentage =
                                                    $produksi > 0 ? ($beforeOffgrade / $produksi) * 100 : '-';
                                                $offgradeAuPercentage =
                                                    $produksi > 0 ? ($afterOffgrade / $produksi) * 100 : '-';
                                            @endphp
                                            <tr>
                                                <td style="text-align: center;">{{ $i }}</td>
                                                <td style="text-align: center;">
                                                    {{ str_pad($i, 2, '0', STR_PAD_LEFT) . '-' . $period }}
                                                </td>
                                                <td style="text-align: center;background-color: #FFF9C4;">
                                                    {{ $beforeOffgrade == 0 ? '0' : number_format($beforeOffgrade, 1) }}
                                                </td>
                                                <td style="text-align: center;background-color: #FFF9C4;">
                                                    {{ $produksi == 0 ? '0' : number_format($produksi, 1) }}
                                                </td>
                                                <td style="text-align: center;background-color: #FFF9C4;">
                                                    {{ is_numeric($offgradeBuPercentage) ? ($offgradeBuPercentage == 0 ? '0' : number_format($offgradeBuPercentage, 2)) . '%' : '-' }}
                                                </td>
                                                <td style="text-align: center;background-color: #FFCDD2;">
                                                    {{ $afterOffgrade == 0 ? '0' : number_format($afterOffgrade, 1) }}
                                                </td>
                                                <td style="text-align: center;background-color: #FFCDD2;">
                                                    {{ $produksi == 0 ? '0' : number_format($produksi, 1) }}
                                                </td>
                                                <td style="text-align: center;background-color: #FFCDD2;">
                                                    {{ is_numeric($offgradeAuPercentage) ? ($offgradeAuPercentage == 0 ? '0' : number_format($offgradeAuPercentage, 2)) . '%' : '-' }}
                                                </td>
                                            </tr>
                                        @endfor
                                    </tbody>

                                    <tbody>
                                        <tr>
                                            <td colspan="2" style="text-align: center;">
                                                <strong>Total</strong>
                                            </td>

                                            <td style="text-align: center;">
                                                <strong>{{ $yearlyTotalBeforeOffgrade == 0 ? '0' : number_format($yearlyTotalBeforeOffgrade, 1) }}</strong>
                                            </td>
                                            <td style="text-align: center;">
                                                <strong>{{ $yearlyTotalProduksi == 0 ? '0' : number_format($yearlyTotalProduksi, 1) }}</strong>
                                            </td>

                                            <!-- First empty td: Display percentage of Before Offgrade over Total Produksi -->
                                            <td style="text-align: center;">
                                                @if ($yearlyTotalProduksi > 0)
                                                    <strong>{{ number_format(($yearlyTotalBeforeOffgrade / $yearlyTotalProduksi) * 100, 2) }}%</strong>
                                                @else
                                                    <strong>-</strong>
                                                @endif
                                            </td>

                                            <td style="text-align: center;">
                                                <strong>{{ $yearlyTotalAfterOffgrade == 0 ? '0' : number_format($yearlyTotalAfterOffgrade, 1) }}</strong>
                                            </td>
                                            <td style="text-align: center;">
                                                <strong>{{ $yearlyTotalProduksi == 0 ? '0' : number_format($yearlyTotalProduksi, 1) }}</strong>
                                            </td>

                                            <!-- Second empty td: Display percentage of After Offgrade over Total Produksi -->
                                            <td style="text-align: center;">
                                                @if ($yearlyTotalProduksi > 0)
                                                    <strong>{{ number_format(($yearlyTotalAfterOffgrade / $yearlyTotalProduksi) * 100, 2) }}%</strong>
                                                @else
                                                    <strong>-</strong>
                                                @endif
                                            </td>

                                        </tr>
                                    </tbody>

                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@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);

            // AutoTable untuk tabel utama
            doc.autoTable({
                html: '#list_{{ $dmenu }}', // ID tabel utama
                startY: 20, // Mulai render tabel di PDF
                theme: 'striped',
                styles: {
                    fontSize: 8,
                    cellPadding: 3,
                    halign: 'center',
                    valign: 'middle',
                },
                headStyles: {
                    fillColor: [0, 183, 189], // Warna header
                    textColor: 255, // Warna teks header
                },
                alternateRowStyles: {
                    fillColor: [240, 240, 240], // Warna baris alternatif
                },
                margin: {
                    top: 20,
                    bottom: 10,
                },
            });

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

        // Tambahkan event listener untuk tombol
        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,
            pageLength: -1,
            dom: 'frtip',
            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: ''
                    },
                },

            ]
        });

        // 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