@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 class="col-md-3 md-auto justify-content-end row">
                                        <div class="col">
                                            {{-- set value filter --}}
                                                                                        @foreach ($filter as $key => $value)
                                                <input type="hidden" name="f{{ $key }}"
                                                    value="{{ $value }}" />
                                                @php
                                                    if (
                                                        preg_replace('/\s+/', '', strtolower(@$table_class->alias)) ==
                                                        preg_replace('/\s+/', '', strtolower($key))
                                                    ) {
                                                        $check_filter = $value == '%' ? '' : $value;
                                                    }
                                                @endphp
                                            @endforeach
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_{{ $dmenu }}">
                                    {{-- check result data --}}
                                    @if ($table_result)
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th>No</th>
                                                {{-- set table header --}}
                                                @foreach ($table_result as $result)
                                                    @php
                                                        $sAsArray = array_keys((array) $result);
                                                        $i = 0;
                                                    @endphp
                                                @endforeach
                                                @foreach ($sAsArray as $header)
                                                    @if (substr($header, 0, 3) == 'IMG')
                                                        <th>{{ substr($header, 4) }}</th>
                                                    @elseif (substr($header, 0, 3) == 'CDT')
                                                        <th>{{ substr($header, 6) . '-' . substr($header, 3, 2) }}</th>
                                                    @else
                                                        <th>{{ $header }}</th>
                                                    @endif
                                                    @php
                                                        $i++;
                                                    @endphp
                                                @endforeach
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                // Ambil header sekali saja dari baris pertama
                                                $field = [];
                                                if (!empty($table_result)) {
                                                    $field = array_keys((array) $table_result[0]);
                                                }
                                            @endphp

                                            @foreach ($table_result as $detail)
                                                <tr
                                                    {{ @$detail->isactive == '0' || @$detail->ISACTIVE == '0' ? 'style=background-color:#ffe9ed;' : '' }}>
                                                    <td>{{ $loop->iteration }}</td>

                                                    @foreach ($field as $header)
                                                        @php
                                                            $string = $header;
                                                            $val = $detail->$string ?? null;
                                                            $isNumeric = is_numeric($val);
                                                            // Kolom yang dianggap uang/nominal
                                                            $isMoney = preg_match(
                                                                '/(harga|total|amount|nominal|nilai|biaya|pengeluaran|pembayaran|subtotal|ppn|dpp)/i',
                                                                $string,
                                                            );
                                                        @endphp

                                                        @if (substr($string, 0, 3) === 'IMG')
                                                            {{-- ... (blok IMG kamu tetap) ... --}}
                                                        @elseif (substr($string, 0, 3) === 'CDT')
                                                            {{-- ... (blok CDT kamu tetap) ... --}}
                                                        @else
                                                            <td
                                                                class="text-sm font-weight-normal {{ $isMoney ? 'text-end' : '' }}">
                                                                @if ($isNumeric && $isMoney)
                                                                    {{ 'Rp ' . number_format((float) $val, 0, ',', '.') }}
                                                                @elseif ($isNumeric)
                                                                    {{ number_format((float) $val, 0, ',', '.') }}
                                                                @else
                                                                    {{ $val }}
                                                                @endif
                                                            </td>
                                                        @endif
                                                    @endforeach
                                                </tr>
                                            @endforeach

                                        </tbody>
                                    @endif
                                </table>
                            </div>
                        </div>

                        <div class="row px-4 py-2 gx-3">
                            {{-- KIRI: Table Diagram --}}
                            <div class="col-12 col-lg-6 mb-4">
                                <div class="table-responsive">
                                    <table class="table display" id="aa">
                                        @if (!empty($table_diagram))
                                            <thead class="thead-light" style="background-color:#00b7bd4f;">
                                                <tr>
                                                    <th>No</th>
                                                    <th>Departemen</th>
                                                    <th class="text-end">Total Distribusi Pengeluaran</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($table_diagram as $detail)
                                                    <tr>
                                                        <td>{{ $loop->iteration }}</td>
                                                        <td>{{ $detail->Departemen ?? ($detail->nama ?? '-') }}</td>
                                                        <td class="text-end">
                                                            {{ number_format($detail->{'Total Pengeluaran'} ?? 0, 0) }}
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        @endif
                                    </table>
                                </div>
                            </div>

                            {{-- KANAN: Table Result (contoh umum) --}}
                            {{-- Kartu Pie Chart --}}
                            <div class="col-12 col-lg-6 mb-4">
                                <div class="card h-100">
                                    <div class="card-header">
                                        <h6 class="mb-0">Distribusi Pengeluaran per Departemen</h6>
                                    </div>
                                    <div class="card-body">
                                        <div id="chart-pengeluaran-pie" style="height:420px;"></div>
                                    </div>
                                </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')
        {{-- ECharts CDN (skip jika sudah di-include) --}}
        <script src="https://cdn.jsdelivr.net/npm/echarts@5/dist/echarts.min.js"></script>
        {{-- <script>
            (function() {
                const el = document.getElementById('chart-pengeluaran-pie');
                if (!el) return;
                const chart = echarts.init(el);

                const pieData = [
                    @foreach ($table_diagram as $row)
                        {
                            name: {!! json_encode($row->Departemen ?? $row->nama) !!},
                            value: {{ (float) ($row->{'Total Pengeluaran'} ?? 0) }}
                        },
                    @endforeach
                ];

                if (pieData.length === 0) {
                    el.innerHTML = '<small class="text-muted">Tidak ada data untuk ditampilkan.</small>';
                    return;
                }

                const fmtIDR = new Intl.NumberFormat('id-ID', {
                    style: 'currency',
                    currency: 'IDR',
                    maximumFractionDigits: 0
                });

                chart.setOption({
                    tooltip: {
                        trigger: 'item',
                        formatter: (p) => `${p.marker} ${p.name}<br/>${fmtIDR.format(p.value)} (${p.percent}%)`
                    },
                    legend: {
                        type: 'scroll',
                        orient: 'vertical',
                        right: 0,
                        top: 'middle'
                    },
                    series: [{
                        name: 'Pengeluaran',
                        type: 'pie',
                        radius: ['40%', '70%'],
                        center: ['40%', '50%'],
                        avoidLabelOverlap: true,
                        label: {
                            show: true,
                            formatter: '{b}: {d}%'
                        },
                        data: pieData
                    }]
                });

                window.addEventListener('resize', () => chart.resize());
            })();
        </script> --}}

        <script>
            (function() {
                const el = document.getElementById('chart-pengeluaran-pie');
                if (!el) return;
                const chart = echarts.init(el);

                const pieData = [
                    @foreach ($table_diagram as $row)
                        {
                            name: {!! json_encode($row->Departemen ?? $row->nama) !!},
                            value: {{ (float) ($row->{'Total Pengeluaran'} ?? 0) }}
                        },
                    @endforeach
                ].filter(d => d && d.name && isFinite(d.value));

                if (pieData.length === 0) {
                    el.innerHTML = '<small class="text-muted">Tidak ada data untuk ditampilkan.</small>';
                    return;
                }

                const TOP_N = 10;
                const sorted = [...pieData].sort((a, b) => b.value - a.value);
                const topNames = new Set(sorted.slice(0, TOP_N).map(d => d.name));
                const legendSelected = Object.fromEntries(
                    pieData.map(d => [d.name, pieData.length <= TOP_N ? true : topNames.has(d.name)])
                );

                const fmtIDR = new Intl.NumberFormat('id-ID', {
                    style: 'currency',
                    currency: 'IDR',
                    maximumFractionDigits: 0
                });

                chart.setOption({
                    tooltip: {
                        trigger: 'item',
                        formatter: (p) => `${p.marker} ${p.name}<br/>${fmtIDR.format(p.value)} (${p.percent}%)`
                    },
                    legend: {
                        type: 'scroll',
                        orient: 'vertical',
                        right: 0,
                        top: 'middle',
                        selector: [{
                            type: 'all',
                            title: 'Tampilkan semua'
                        }, {
                            type: 'inverse',
                            title: 'Balik pilihan'
                        }],
                        selected: legendSelected
                    },
                    series: [{
                        name: 'Pengeluaran',
                        type: 'pie',
                        radius: '70%',
                        center: ['40%', '50%'],
                        avoidLabelOverlap: true,
                        label: {
                            show: true,
                            formatter: '{b}: {d}%'
                        },
                        data: pieData
                    }]
                });

                window.addEventListener('resize', () => chart.resize());
            })();
        </script>

        <script>
            let columnAbjad = '';
            $(document).ready(function() {
                let table = $('#list_{{ $dmenu }}').DataTable();
                let indexStatus = 0;
                let numColumns = $('#list_{{ $dmenu }}').DataTable().columns().count();
                let columnNames = '';
                let filter = '{{ @$table_class->alias }}'.toLowerCase();
                for (let index = 0; index < numColumns; index++) {
                    columnNames = $('#list_{{ $dmenu }}').DataTable().columns(index).header()[0].textContent;
                    filtercolom = columnNames.toLowerCase();
                    if (columnNames == 'Status' || columnNames == 'status' || columnNames == 'STATUS') {
                        columnAbjad = String.fromCharCode(65 + index);
                    }
                    if (filtercolom == filter) {
                        indexStatus = index;
                    }
                }
                //redraw table where filter
                $('#{{ @$table_class->field }}').change(function() {
                    table.column(indexStatus).search($(this).val()).draw();
                })
                //check class exp
                if ($('*').hasClass('exp')) {
                    $('#noted').html(`<code>Note :( <i aria-hidden="true" style="color: #ffc2cd;"
                class="fas fa-circle"></i> Data not active ), ( <i aria-hidden="true"
                style="color: #ffe768;" class="fas fa-circle"></i> Data Expired )</code>`)
                }
            });

            $('#aa').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: 'Bfrtip',
                buttons: [{
                        extend: 'excelHtml5',
                        text: '<i class="fas fa-file-excel me-1 text-lg text-success"> </i><span class="font-weight-bold"> Excel',
                        autoFilter: true,
                        sheetName: 'Exported data',
                      
                        customize: function(xlsx) {
                            var sheet = xlsx.xl.worksheets['sheet1.xml'];
                          
                            sheet.querySelectorAll('row c[r^="' + columnAbjad + '"]').forEach((row) => {
                              
                                let cell = row.querySelector('is t');
                                if (cell && cell.textContent === 'Not Active') {
                                    row.setAttribute('s', '10');
                                }
                            });
                        },
                        exportOptions: {
                            columns: ':visible'
                        },
                    },
                    {
                        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)'
                        },
                    },
                    {
                        extend: 'print',
                        text: '<i class="fas fa-print me-1 text-lg text-info"> </i><span class="font-weight-bold"> Print',
                        orientation: 'landscape',
                        pageSize: 'A4',
                        exportOptions: {
                            columns: ':visible:not(:last-child)'
                        },
                    },
                ]
            });

            //set table into datatables
            $('#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: 'Bfrtip',
                buttons: [{
                        extend: 'excelHtml5',
                        text: '<i class="fas fa-file-excel me-1 text-lg text-success"> </i><span class="font-weight-bold"> Excel',
                        autoFilter: true,
                        sheetName: 'Exported data',
                        // title: 'Nama File Excel',
                        customize: function(xlsx) {
                            var sheet = xlsx.xl.worksheets['sheet1.xml'];
                            // Loop over the cells in column
                            sheet.querySelectorAll('row c[r^="' + columnAbjad + '"]').forEach((row) => {
                                // Get the value
                                let cell = row.querySelector('is t');
                                if (cell && cell.textContent === 'Not Active') {
                                    row.setAttribute('s', '10'); //red background
                                }
                            });
                        },
                        exportOptions: {
                            columns: ':visible'
                        },
                    },
                    {
                        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)'
                        },
                    },
                    {
                        extend: 'print',
                        text: '<i class="fas fa-print me-1 text-lg text-info"> </i><span class="font-weight-bold"> Print',
                        orientation: 'landscape',
                        pageSize: 'A4',
                        exportOptions: {
                            columns: ':visible:not(:last-child)'
                        },
                    },
                ]
            });
            //set color button datatables
            $('.dt-button').addClass('btn btn-secondary');
            $('.dt-button').removeClass('dt-button');
            //check authorize button datatables
            <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjatk/resources/views/report/rpprch/result.blade.php</b> on line <b>460</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjatk/resources/views/report/rpprch/result.blade.php</b> on line <b>460</b><br />
            <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjatk/resources/views/report/rpprch/result.blade.php</b> on line <b>461</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjatk/resources/views/report/rpprch/result.blade.php</b> on line <b>461</b><br />
            <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjatk/resources/views/report/rpprch/result.blade.php</b> on line <b>462</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjatk/resources/views/report/rpprch/result.blade.php</b> on line <b>462</b><br />
            //function delete
            function deleteData(name, msg) {
                pesan = confirm('Apakah Anda Yakin ' + msg + ' Data ' + name + ' ini ?');
                if (pesan) return true
                else return false
            }
        </script>
    @endpush