@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])

    <link href="{{ asset('assets/summernote-0.9.0-dist/summernote.min.css') }}" rel="stylesheet">

    <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 class="col">
                                            {{-- display label alias on class filter --}}
                                            Filter {{ @$table_class->alias }} :
                                            <select class="form-select" id="{{ @$table_class->field }}"
                                                style="width: 150px;">
                                                @if (@$table_class->query != '')
                                                    @if ($check_filter != '')
                                                        @php
                                                            $data_query = DB::select(@$table_class->query);
                                                        @endphp
                                                        @foreach ($data_query as $q)
                                                            <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>54</b><br />
                                                            @if ($check_filter == $sAsArray[0])
                                                                <option value="{{ $sAsArray[0] }}">
                                                                    @if (isset($dmenu) && $dmenu === 'rpgsap')
                                                                        {{ $sAsArray[1] }}
                                                                    @else
                                                                        {{ $sAsArray[0] }} - {{ $sAsArray[1] }}
                                                                    @endif
                                                                </option>
                                                            @endif
                                                        @endforeach
                                                    @else
                                                        @if (isset($dmenu) && $dmenu === 'rpgsap')
                                                            <option value="" selected>% - All</option>
                                                            @php
                                                                $data_query = DB::select(@$table_class->query);
                                                            @endphp
                                                            @foreach ($data_query as $q)
                                                                <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>72</b><br />
                                                                <option
                                                                    value="{{ isset($dmenu) && $dmenu === 'rpgsap' ? $sAsArray[1] : $sAsArray[0] }}">
                                                                    {{ $sAsArray[1] }}
                                                                </option>
                                                            @endforeach
                                                        @else
                                                            <option value="" selected>% - All</option>
                                                            @php
                                                                $data_query = DB::select(@$table_class->query);
                                                            @endphp
                                                            @foreach ($data_query as $q)
                                                                <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>84</b><br />
                                                                <option value="{{ $sAsArray[0] }}">
                                                                    {{ $sAsArray[0] }} - {{ $sAsArray[1] }}
                                                                </option>
                                                            @endforeach
                                                        @endif
                                                    @endif
                                                @endif
                                            </select>
                                        </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>
                                                @foreach ($table_result as $result)
                                                    @php
                                                        $sAsArray = array_keys((array) $result);
                                                        $i = 0;
                                                    @endphp
                                                @endforeach
                                                @foreach ($sAsArray as $header)
                                                    @php
                                                        $i++;
                                                    @endphp
                                                @endforeach
                                                <th style="text-align: center;">Tipe PO</th>
                                                <th style="text-align: center;">No PO</th>
                                                <th style="text-align: center;">Email To</th>
                                                <th style="text-align: center;">Email CC</th>


                                                <th style="text-align: center;">Subject</th>
                                                <th style="text-align: center;">Body</th>
                                                <th style="text-align: center;">File Path</th>
                                                <th style="text-align: center;">TimeStamp</th>
                                                <th style="text-align: center;">Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            {{-- retrieve table result --}}
                                            @foreach ($table_result as $detail)
                                                {{-- @dump($detail); --}}
                                                <tr
                                                    {{ @$detail->isactive == '0' || @$detail->ISACTIVE == '0' ? 'class=not style=background-color:#ffe9ed;' : '' }}>
                                                    <td>{{ $loop->iteration }}</td>
                                                    @foreach ($table_result as $result)
                                                        @php
                                                            $field = array_keys((array) $result);
                                                            $i = 0;
                                                        @endphp
                                                    @endforeach
                                                    @foreach ($field as $header)
                                                        @php
                                                            $string = $header;
                                                            $img_id = '';
                                                            $characters =
                                                                'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
                                                            for ($i = 0; $i < 10; $i++) {
                                                                $img_id .=
                                                                    $characters[mt_rand(0, strlen($characters) - 1)];
                                                            }
                                                        @endphp
                                                        @php
                                                            $i++;
                                                        @endphp
                                                    @endforeach
                                                    @php
                                                        $decoded = json_decode($detail->email_to, true);
                                                        $cccode = json_decode($detail->email_cc, true);
                                                        $emailTo = is_array($decoded)
                                                            ? implode(', ', $decoded)
                                                            : $detail->email_to;
                                                        $emailcc = is_array($cccode)
                                                            ? implode(', ', $cccode)
                                                            : $detail->email_cc;
                                                    @endphp
                                                    <td>{{ $detail->tipe_pr }}</td>
                                                    <td>{{ $detail->no_po }}</td>
                                                    <td>{{ $emailTo }}</td>
                                                    <td>{{ $emailcc }}</td>
                                                    <td>{{ $detail->subject }}</td>
                                                    <td>
                                                        <span class="badge bg-primary body-view" style="cursor:pointer;"
                                                            data-subject="{{ e($detail->subject) }}"
                                                            data-body-target="body-{{ $detail->id }}">
                                                            <i class="fas fa-eye me-1"></i> View Body
                                                        </span>

                                                        {{-- Simpan HTML body asli di textarea hidden --}}
                                                        <textarea id="body-{{ $detail->id }}" class="d-none">{!! $detail->body !!}</textarea>
                                                    </td>
                                                    <td>
                                                        @if (!empty($detail->file_path))
                                                            <a href="{{ asset($detail->file_path) }}"
                                                                class="btn btn-sm btn-danger mb-0" target="_blank"
                                                                rel="noopener">
                                                                <i class="fas fa-file-pdf me-1"></i> View PDF
                                                            </a>
                                                        @endif
                                                    </td>
                                                    <td>{{ $detail->created_at }}</td>
                                                    <td>{{ $detail->status == 2 ? 'terkirim' : ($detail->status == 3 ? 'gagal kirim' : $detail->status) }}
                                                    </td>

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

                        <div class="modal fade" id="modalEmailBody" tabindex="-1" aria-hidden="true">
                            <div class="modal-dialog modal-lg modal-dialog-scrollable">
                                <div class="modal-content">
                                    <div class="modal-header py-2">
                                        <h5 class="modal-title">Detail Email</h5>
                                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                                    </div>

                                    <div class="modal-body">
                                        <div class="mb-2">
                                            <label class="form-label mb-1"><strong>Subject</strong></label>
                                            <input type="text" id="modalEmailSubject" class="form-control" readonly>
                                        </div>

                                        <div class="mb-2">
                                            <label class="form-label mb-1"><strong>Body Email</strong></label>
                                            <div id="modalEmailBodyEditor"></div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>


                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                @if ($table_result)
                                    <div class="nav-wrapper" id="noted"><code>Note : <i aria-hidden="true"
                                                style="color: #ffc2cd;" class="fas fa-circle"></i> Data not active</code>
                                    </div>
                                @else
                                    <div class="nav-wrapper"><code> Data not found!</code></div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    @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

    <div class="modal fade" id="poDetailModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-xl modal-dialog-scrollable">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Detail NO PO: <span id="mdlNoPo"></span></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Tutup"></button>
                </div>
                <div class="modal-body">
                    <div id="mdlMeta" class="mb-2 text-muted"></div>
                    <div class="table-responsive">
                        <table class="table table-sm table-bordered mb-0">
                            <thead style="background-color:#00b7bd4f;">
                                <tr>
                                    <th style="width:80px">Urut</th>
                                    <th style="width:220px">Material</th>
                                    <th>Deskripsi Material</th>
                                    <th>Deskripsi Barang</th>
                                    <th class="text-end" style="width:160px">Nominal</th>
                                </tr>
                            </thead>
                            <tbody id="mdlBody">
                                <tr>
                                    <td colspan="5" class="text-center text-muted">Memuat…
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Tutup</button>
                </div>
            </div>
        </div>
    </div>
@endsection
@push('js')
    <script src="{{ asset('assets/summernote-0.9.0-dist/summernote.min.js') }}"></script>
    <script>
        $(document).on('click', '.body-view', function() {
            const subject = $(this).data('subject') || '';
            const targetId = $(this).data('body-target');
            const bodyHtml = $('#' + targetId).val() || '';

            Swal.fire({
                title: 'Detail Email',
                width: '70%',
                html: `
            <div class="mb-2 text-start">
                <label class="form-label mb-1"><strong>Subject</strong></label>
                <input type="text" id="tplSubject" class="form-control" readonly>
            </div>

            <div class="mb-2 text-start">
                <label class="form-label mb-1"><strong>Body</strong></label>
                <div id="tplBody"></div>
            </div>
        `,
                showCancelButton: true,
                showConfirmButton: false,
                cancelButtonText: 'Tutup',
                didOpen: () => {
                    const $dlg = $(Swal.getHtmlContainer());
                    const $sub = $dlg.find('#tplSubject');
                    const $body = $dlg.find('#tplBody');

                    // isi subject
                    $sub.val(subject);

                    // safety: kalau Summernote belum ke-load
                    if (!$.fn.summernote) {
                        console.error('Summernote belum ke-load. Cek include JS/CSS-nya.');
                        $body.html(bodyHtml);
                        return;
                    }

                    // init summernote
                    $body.summernote({
                        height: 200,
                        toolbar: [], // viewer only
                        disableDragAndDrop: true,
                    });

                    // jadikan readonly
                    $body.summernote('disable');

                    // isi HTML body
                    $body.summernote('code', bodyHtml || '<em>(kosong)</em>');
                }
            });
        });
    </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' || columnNames ==
                    'Status Email') {
                    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/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>456</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>456</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>457</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>457</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>458</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/report/rlogem/result.blade.php</b> on line <b>458</b><br />
        //function delete
        function deleteData(name, msg) {
            pesan = confirm('Apakah Anda Yakin ' + msg + ' Data ' + name + ' ini ?');
            if (pesan) return true
            else return false
        }

        // Klik No PO → buka modal
        $('#list_{{ $dmenu }}').on('click', '.po-link', function(e) {
            e.preventDefault();
            const no_po = $(this).data('po');
            if (no_po) openDetailModal(no_po);
        });

        function openDetailModal(no_po) {
            const $body = $('#mdlBody');
            $('#mdlNoPo').text(no_po || '-');
            $('#mdlMeta').text('');
            $body.html('<tr><td colspan="5" class="text-center text-muted">Memuat…</td></tr>');

            // show modal
            const modal = bootstrap.Modal.getOrCreateInstance(document.getElementById('poDetailModal'));
            modal.show();

            // AJAX ambil detail
            $.ajax({
                    url: `{{ route('rpgsap.detail') }}`,
                    method: 'GET',
                    data: {
                        no_po: no_po
                    },
                    dataType: 'json',
                    headers: {
                        'Accept': 'application/json'
                    }
                })
                .done(function(res) {
                    // Normalisasi payload -> items[]
                    let items = [];
                    if (Array.isArray(res)) items = res;
                    else if (Array.isArray(res?.items)) items = res.items;
                    else if (Array.isArray(res?.data)) items = res.data;
                    else if (res && typeof res === 'object') items = Object.values(res);

                    // Render
                    $body.html(renderRows(items));
                })
                .fail(function(xhr) {
                    console.error('detail AJAX fail:', {
                        status: xhr.status,
                        statusText: xhr.statusText,
                        url: this.url,
                        resp: (xhr.responseText || '').slice(0, 300)
                    });
                    $body.html(
                        '<tr><td colspan="5" class="text-center text-danger">Gagal memuat detail.</td></tr>'
                    );
                });
        }

        function renderRows(items) {
            if (!Array.isArray(items) || !items.length) {
                return '<tr><td colspan="5" class="text-center text-muted">Tidak ada detail.</td></tr>';
            }
            return items.map(r => {
                const urut = (r.urut ?? '').toString().trim();
                const material = (r.material ?? '').toString().trim();
                const descMat = (r.deskripsi_material ?? '').toString().trim();
                const descBarang = (r.deskripsi_barang ?? '').toString().trim();
                const nominal = (r.nominal ?? '').toString().trim();
                return `<tr>
                    <td>${urut}</td>
                    <td>${material}</td>
                    <td>${descMat}</td>
                    <td>${descBarang}</td>
                    <td class="text-end">${nominal}</td>
                </tr>`;
            }).join('');
        }
    </script>
@endpush