@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 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">
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="row px-4 py-2">
                                <div class="table-responsive">
                                    <table class="table display" id="list_{{ $dmenu }}">
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th>No</th>
                                                <th>Tanggal Aktual</th>
                                                <th>ID Transaksi</th>
                                                <th>User</th>
                                                <th>Menu</th>
                                                <th>Aksi</th>
                                                <th>Deskripsi</th>
                                            </tr>
                                        </thead>

                                        <tbody>
                                            @forelse ($table_result as $detail)
                                                <tr>
                                                    <td>
                                                        {{ $loop->iteration }}
                                                    </td>

                                                    <td>
                                                        {{ \Carbon\Carbon::parse($detail->created_at)->translatedFormat('d F Y H:i:s') }}
                                                    </td>

                                                    <td>
                                                        {{ $detail->id_transaksi }}
                                                    </td>

                                                    <td>
                                                        {{ $detail->username }}
                                                    </td>

                                                    <td>
                                                        {{ $detail->menu }}
                                                    </td>

                                                    <td>
                                                        {{ $detail->halaman }}
                                                    </td>

                                                    {{-- DESKRIPSI --}}
                                                    <td style="min-width: 700px; white-space: normal; vertical-align: top;">
                                                        @php
                                                            $deskripsi = $detail->deskripsi ?? '';

                                                            $deskripsiUtama = $deskripsi;

                                                            $decodedSebelum = null;
                                                            $decodedSesudah = null;
                                                            $decodedSingle = null;

                                                            $judulSingle = 'Detail';

                                                            if (
                                                                str_contains($deskripsi, 'Detail Sebelum:') &&
                                                                str_contains($deskripsi, 'Detail Sesudah:')
                                                            ) {
                                                                [$deskripsiUtama, $sisaDetail] = explode(
                                                                    'Detail Sebelum:',
                                                                    $deskripsi,
                                                                    2,
                                                                );

                                                                [$jsonSebelum, $jsonSesudah] = explode(
                                                                    'Detail Sesudah:',
                                                                    $sisaDetail,
                                                                    2,
                                                                );

                                                                $decodedSebelum = json_decode(trim($jsonSebelum), true);

                                                                $decodedSesudah = json_decode(trim($jsonSesudah), true);
                                                            } elseif (str_contains($deskripsi, 'Detail Dihapus:')) {
                                                                [$deskripsiUtama, $jsonSingle] = explode(
                                                                    'Detail Dihapus:',
                                                                    $deskripsi,
                                                                    2,
                                                                );

                                                                $decodedSingle = json_decode(trim($jsonSingle), true);

                                                                $judulSingle = 'Detail Dihapus';
                                                            } elseif (str_contains($deskripsi, 'Detail:')) {
                                                                [$deskripsiUtama, $jsonSingle] = explode(
                                                                    'Detail:',
                                                                    $deskripsi,
                                                                    2,
                                                                );

                                                                $decodedSingle = json_decode(trim($jsonSingle), true);

                                                                $judulSingle = 'Detail';
                                                            }
                                                            $tableGroups = [];

                                                            if (
                                                                is_array($decodedSebelum) &&
                                                                count($decodedSebelum) > 0
                                                            ) {
                                                                $tableGroups[] = [
                                                                    'judul' => 'Detail Sebelum',
                                                                    'data' => $decodedSebelum,
                                                                ];
                                                            }

                                                            if (
                                                                is_array($decodedSesudah) &&
                                                                count($decodedSesudah) > 0
                                                            ) {
                                                                $tableGroups[] = [
                                                                    'judul' => 'Detail Sesudah',
                                                                    'data' => $decodedSesudah,
                                                                ];
                                                            }

                                                            if (is_array($decodedSingle) && count($decodedSingle) > 0) {
                                                                $tableGroups[] = [
                                                                    'judul' => $judulSingle,
                                                                    'data' => $decodedSingle,
                                                                ];
                                                            }

                                                            $mataUang = 'IDR';

                                                            if (
                                                                preg_match(
                                                                    '/Mata Uang:\s*([A-Za-z]{3})/i',
                                                                    $deskripsiUtama,
                                                                    $matchesMataUang,
                                                                )
                                                            ) {
                                                                $mataUang = strtoupper($matchesMataUang[1]);
                                                            }
                                                        @endphp
                                                        {{-- DESKRIPSI UTAMA --}}
                                                        <div class="mb-2">
                                                            {{ trim($deskripsiUtama) }}
                                                        </div>
                                                        {{-- DETAIL TABLE --}}
                                                        @foreach ($tableGroups as $tableGroup)
                                                            @php
                                                                $sortedData = collect($tableGroup['data'])
                                                                    ->sortBy(function ($row) {
                                                                        if ((float) ($row['debit'] ?? 0) > 0) {
                                                                            return 0;
                                                                        }
                                                                        if ((float) ($row['kredit'] ?? 0) > 0) {
                                                                            return 1;
                                                                        }
                                                                        return 2;
                                                                    })
                                                                    ->values();
                                                            @endphp
                                                            <details class="mb-2">
                                                                <summary class="text-primary" style="cursor: pointer;">
                                                                    Lihat {{ $tableGroup['judul'] }}
                                                                </summary>
                                                                <div class="table-responsive mt-2">
                                                                    <table
                                                                        class="table table-sm align-middle mb-0 mt-0 log-detail-table">

                                                                        <thead class="thead-light"
                                                                            style="background-color: #00b7bd4f;">
                                                                            <tr>
                                                                                <th class="text-center"
                                                                                    style="width: 50px;">
                                                                                    No
                                                                                </th>
                                                                                <th>
                                                                                    Keterangan
                                                                                </th>
                                                                                <th>
                                                                                    COA - Nama COA
                                                                                </th>
                                                                                <th class="text-end" style="width: 140px;">
                                                                                    Debit
                                                                                </th>
                                                                                <th class="text-end" style="width: 140px;">
                                                                                    Kredit
                                                                                </th>
                                                                            </tr>
                                                                        </thead>
                                                                        <tbody>
                                                                            @foreach ($sortedData as $index => $row)
                                                                                <tr>
                                                                                    <td class="text-center">
                                                                                        {{ $index + 1 }}
                                                                                    </td>
                                                                                    <td>
                                                                                        {{ $row['keterangan'] ?? '-' }}
                                                                                    </td>
                                                                                    <td>
                                                                                        {{ $row['id_coa'] ?? '-' }}
                                                                                        -
                                                                                        {{ $row['nama_coa'] ?? '-' }}
                                                                                    </td>
                                                                                    <td class="text-end">
                                                                                        @if (!empty($row['debit']))
                                                                                            <div>
                                                                                                Rp
                                                                                                {{ number_format((float) $row['debit'], 2, ',', '.') }}
                                                                                            </div>

                                                                                            @if (!empty($row['debit_valas']))
                                                                                                <small
                                                                                                    class="text-muted d-block">
                                                                                                    {{ $mataUang ?? 'USD' }}
                                                                                                    {{ number_format((float) $row['debit_valas'], 2, ',', '.') }}
                                                                                                </small>
                                                                                            @endif
                                                                                        @else
                                                                                            -
                                                                                        @endif
                                                                                    </td>
                                                                                    <td class="text-end">
                                                                                        @if (!empty($row['kredit']))
                                                                                            <div>
                                                                                                Rp
                                                                                                {{ number_format((float) $row['kredit'], 2, ',', '.') }}
                                                                                            </div>

                                                                                            @if (!empty($row['kredit_valas']))
                                                                                                <small
                                                                                                    class="text-muted d-block">
                                                                                                    {{ $mataUang ?? 'USD' }}
                                                                                                    {{ number_format((float) $row['kredit_valas'], 2, ',', '.') }}
                                                                                                </small>
                                                                                            @endif
                                                                                        @else
                                                                                            -
                                                                                        @endif
                                                                                    </td>
                                                                                </tr>
                                                                            @endforeach
                                                                        </tbody>
                                                                        @php
                                                                            $totalDebit = collect(
                                                                                $tableGroup['data'],
                                                                            )->sum(
                                                                                fn($item) => (float) ($item['debit'] ??
                                                                                    0),
                                                                            );

                                                                            $totalKredit = collect(
                                                                                $tableGroup['data'],
                                                                            )->sum(
                                                                                fn($item) => (float) ($item['kredit'] ??
                                                                                    0),
                                                                            );

                                                                            $totalDebitValas = collect(
                                                                                $tableGroup['data'],
                                                                            )->sum(
                                                                                fn($item) => (float) ($item[
                                                                                    'debit_valas'
                                                                                ] ?? 0),
                                                                            );

                                                                            $totalKreditValas = collect(
                                                                                $tableGroup['data'],
                                                                            )->sum(
                                                                                fn($item) => (float) ($item[
                                                                                    'kredit_valas'
                                                                                ] ?? 0),
                                                                            );
                                                                        @endphp
                                                                        <tfoot class="table-light">
                                                                            <tr>
                                                                                <th colspan="3" class="text-end">
                                                                                    Total
                                                                                </th>

                                                                                <th class="text-end">
                                                                                    <div>
                                                                                        Rp
                                                                                        {{ number_format($totalDebit, 2, ',', '.') }}
                                                                                    </div>

                                                                                    @if ($totalDebitValas != 0)
                                                                                        <small class="text-muted d-block">
                                                                                            {{ $mataUang ?? 'USD' }}
                                                                                            {{ number_format($totalDebitValas, 2, ',', '.') }}
                                                                                        </small>
                                                                                    @endif
                                                                                </th>

                                                                                <th class="text-end">
                                                                                    <div>
                                                                                        Rp
                                                                                        {{ number_format($totalKredit, 2, ',', '.') }}
                                                                                    </div>

                                                                                    @if ($totalKreditValas != 0)
                                                                                        <small class="text-muted d-block">
                                                                                            {{ $mataUang ?? 'USD' }}
                                                                                            {{ number_format($totalKreditValas, 2, ',', '.') }}
                                                                                        </small>
                                                                                    @endif
                                                                                </th>
                                                                            </tr>
                                                                        </tfoot>
                                                                    </table>
                                                                </div>
                                                            </details>
                                                        @endforeach
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <style>
            .log-detail-table {
                width: 100%;
                border-collapse: collapse !important;
                border: 1px solid #8f9aaa !important;
            }

            .log-detail-table th,
            .log-detail-table td {
                border: 1px solid #8f9aaa !important;
            }

            /* Paksa baris terakhir tbody tetap punya garis */
            .log-detail-table tbody tr:last-child td {
                border-bottom: 1px solid #8f9aaa !important;
            }

            .log-detail-table thead th {
                background-color: #a9e0e3 !important;
            }

            .log-detail-table tbody td {
                background-color: #ffffff !important;
            }

            .log-detail-table tfoot th,
            .log-detail-table tfoot td {
                background-color: #e9edf2 !important;
                border: 1px solid #8f9aaa !important;
                font-weight: bold;
            }
        </style>
        {{-- 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>
            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 note
                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>`)
                }
                if ($('*').hasClass('stock')) {
                    $('#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: #f93c3c;" class="fas fa-circle"></i> Stock < Min Stock )</code>`)
                }
                if ($('*').hasClass('exp') && $('*').hasClass('stock')) {
                    $('#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 ), ( <i aria-hidden="true"
                style="color: #f93c3c;" class="fas fa-circle"></i> Stock < Min Stock )</code>`)
                }
            });
            //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:not(:last-child)'
                        },
                    },
                    {
                        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/msjaccounting/resources/views/report/rplgus/result.blade.php</b> on line <b>499</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjaccounting/resources/views/report/rplgus/result.blade.php</b> on line <b>499</b><br />
            <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjaccounting/resources/views/report/rplgus/result.blade.php</b> on line <b>500</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjaccounting/resources/views/report/rplgus/result.blade.php</b> on line <b>500</b><br />
            <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjaccounting/resources/views/report/rplgus/result.blade.php</b> on line <b>501</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjaccounting/resources/views/report/rplgus/result.blade.php</b> on line <b>501</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