@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 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/msjlocker/resources/views/report/rpopna/result.blade.php</b> on line <b>51</b><br />
                                                            @if ($check_filter == $sAsArray[0])
                                                                <option value="{{ $sAsArray[0] }}">
                                                                    {{ $sAsArray[0] }} - {{ $sAsArray[1] }}
                                                                </option>
                                                            @endif
                                                        @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/msjlocker/resources/views/report/rpopna/result.blade.php</b> on line <b>64</b><br />
                                                            <option value="{{ $sAsArray[0] }}">
                                                                {{ $sAsArray[0] }} - {{ $sAsArray[1] }}
                                                            </option>
                                                        @endforeach
                                                    @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;">
                                            <th>Action</th>
                                            <th>Kode Pintu</th>
                                            <th>Jenis Loker</th>
                                            <th>Gedung</th>
                                            <th>Lokasi</th>
                                            <th>Nama Karyawan</th>
                                            <th>Status Karyawan</th>
                                            <th>Bagian</th>
                                            <th>Qty Default</th>
                                            <th>Qty Stock</th>
                                            <th>Qty User</th>
                                            <th>Tanggal Serah Terima</th>
                                            <th>Tanggal Kembali</th>
                                            <th>Pengecekan</th>
                                        </thead>
                                        <tbody>
                                            {{-- retrieve table result --}}
                                            @php
                                                $groupedData = [];
                                            @endphp
                                            @foreach ($table_result as $result)
                                                @php
                                                    $key = $result->kodepintu;
                                                    if (!isset($groupedData[$key])) {
                                                        $groupedData[$key] = [
                                                            'id' => $result->id,
                                                            'kodepintu' => $result->kodepintu,
                                                            'nama_loker' => $result->nama_loker,
                                                            'nama_gedung' => $result->nama_gedung,
                                                            'nama_lokasi' => $result->nama_lokasi,
                                                            'nama' => $result->nama,
                                                            'bagian' => $result->bagian,
                                                            'status' => $result->statuskaryawan,
                                                            'qty_default' => $result->qty_default,
                                                            'qty_stock' => $result->qty_stock,
                                                            'qty_user' => $result->qty_user,
                                                            'tanggal_pinjam' => $result->nama
                                                                ? $result->tanggal_pinjam
                                                                : '',
                                                            'tanggal_kembali' => $result->nama
                                                                ? $result->tanggal_kembali
                                                                : '',
                                                            'pengecekan' => $result->pengecekan,
                                                        ];
                                                    } else {
                                                        if ($groupedData[$key]['nama'] == '') {
                                                            $groupedData[$key]['nama'] .= $result->nama;
                                                            $groupedData[$key]['bagian'] .= $result->bagian;
                                                            $groupedData[$key]['status'] .= $result->statuskaryawan;
                                                        } else {
                                                            $groupedData[$key]['nama'] .= ',' . $result->nama;
                                                            $groupedData[$key]['bagian'] .= ',' . $result->bagian;
                                                            $groupedData[$key]['status'] .=
                                                                ',' . $result->statuskaryawan;
                                                        }
                                                    }
                                                @endphp
                                            @endforeach
                                            {{-- @php
                                                print_r($groupedData[$key]['nama']);
                                                //echo $groupedData;
                                            @endphp
                                            var_dump($groupedData[$key]['nama']); --}}
                                            @foreach ($groupedData as $data)
                                          
                                                {{-- @php
                                                print_r($data);
                                                //echo $groupedData;
                                            @endphp --}}
                                                <tr>
                                                    {{ @$data['isactive'] == '0' ? 'class=not style=background-color:#ffe9ed;' : '' }}
                                                    <td>
                                                        @if ($data['qty_stock'] < 2 && $data['pengecekan'] == 0)
                                                            <form
                                                                action="{{ route('trhistUpdate', encrypt($data['id'])) }}"
                                                                method="POST" style="display: inline-block;">
                                                                @csrf
                                                                @method('PUT')
                                                                <input type="hidden" name="action" value="approve">
                                                                <button type="button" class="btn btn-sm btn-success mb-0"
                                                                    title="Setujui Opname"
                                                                    onclick="updateStatus(event, '{{ $data['kodepintu'] }}', 'Menyetujui')">
                                                                    <i class="fas fa-check"></i><span
                                                                        class="font-weight-bold"> Setujui Opname</span>
                                                                </button>
                                                            </form>
                                                        @endif
                                                        @if ($data['qty_stock'] < 2 && $authorize->edit == '1')
                                                            <button type="button" class="btn btn-sm btn-warning mb-0"
                                                                title="Edit Data"
                                                                onclick="window.location='{{ URL::to('/rpopna/edit/' . encrypt($data['id'])) }}'">
                                                                <i class="fas fa-edit"></i><span class="font-weight-bold">
                                                                    Edit</span>
                                                            </button>
                                                        @endif
                                                        @if ($data['qty_stock'] == 2 && $authorize->add == '1')
                                                            <button class="btn btn-primary mb-0"
                                                                onclick="window.open('{{ url('/trsrah' . '/add' . '/' . $data['id']) }}?kodepintu={{ $data['kodepintu'] }}&nama_loker={{ $data['nama_loker'] }}&gedung={{ $data['nama_gedung'] }}&lokasi={{ $data['nama_lokasi'] }}', '_blank')">
                                                                <i class="fas fa-plus me-1"></i><span class="font-weight-bold">Tambah</span>
                                                            </button>
                                                        @endif
                                                    </td>
                                                    <td>{{ $data['kodepintu'] }}</td>
                                                    <td>{{ $data['nama_loker'] }}</td>
                                                    <td>{{ $data['nama_gedung'] }}</td>
                                                    <td>{{ $data['nama_lokasi'] }}</td>
                                                    <td>{{ $data['nama'] }}</td>
                                                    <td>{{ $data['bagian'] }}</td>
                                                    <td>{{ $data['status'] }}</td>
                                                    <td>{{ $data['qty_default'] }}</td>
                                                    <td>{{ $data['qty_stock'] }}</td>
                                                    <td>{{ $data['qty_user'] }}</td>
                                                    <td>{{ $data['tanggal_pinjam'] }}</td>
                                                    <td>{{ $data['tanggal_kembali'] }}</td>
                                                    <td>{{ $data['pengecekan'] }}</td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    @endif
                                </table>
                            </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>
    {{-- 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({
            "order": [
                [1, "asc"]
            ],
            "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/msjlocker/resources/views/report/rpopna/result.blade.php</b> on line <b>343</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjlocker/resources/views/report/rpopna/result.blade.php</b> on line <b>343</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjlocker/resources/views/report/rpopna/result.blade.php</b> on line <b>344</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjlocker/resources/views/report/rpopna/result.blade.php</b> on line <b>344</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjlocker/resources/views/report/rpopna/result.blade.php</b> on line <b>345</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjlocker/resources/views/report/rpopna/result.blade.php</b> on line <b>345</b><br />
        //function delete
        function deleteData(name, msg) {
            pesan = confirm('Apakah Anda Yakin ' + msg + ' Data ' + name + ' ini ?');
            if (pesan) return true
            else return false
        }

        function updateStatus(event, kodepintu, action) {
            event.preventDefault();
            let confirmationMessage = '';
            let successMessage = '';
            confirmationMessage = `Apakah Anda yakin ${action} Report Opname dari ${kodepintu}?`;
            successMessage = `Pengecekan telah berhasil`;

            Swal.fire({
                title: 'Konfirmasi',
                text: confirmationMessage,
                icon: 'warning',
                showCancelButton: true,
                confirmButtonText: `Ya, ${action}`,
                cancelButtonText: 'Batal',
                confirmButtonColor: '#028284'
            }).then((result) => {
                if (result.isConfirmed) {
                    // Find the closest form element and submit it manually
                    const form = event.target.closest('form');
                    form.submit();

                    // Show success message
                    Swal.fire({
                        title: 'Berhasil',
                        text: successMessage,
                        icon: 'success',
                        confirmButtonColor: '#028284'
                    }).then(() => {
                        // Reload the page after the success message is closed
                        location.reload();
                    });
                }
            });
        }
    </script>
@endpush