@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="window.location='{{ url($url_menu . '/index') }}'">
                                            <i class="fas fa-circle-left me-1"></i>
                                            <span class="font-weight-bold">Kembali</span>
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_{{ $dmenu }}">
                                    @if ($table_result)
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th class="text-center align-middle">ID</th>
                                                <th class="text-center align-middle">Status</th>
                                                <th class="text-center align-middle">Nama</th>
                                                <th class="text-center align-middle" width="75px">Role</th>
                                                <th class="text-center align-middle" width="75px">Tanggal</th>
                                                <th class="text-center align-middle" width="100px">Berangkat</th>
                                                <th class="text-center align-middle" width="150px">Kembali</th>
                                                <th class="text-center align-middle" width="105px">Total Jam</th>
                                                <th class="text-center align-middle" width="300px">KM Awal</th>
                                                <th class="text-center align-middle" width="75px">KM Akhir</th>
                                                <th class="text-center align-middle" width="200px">Total KM</th>
                                                <th class="text-center align-middle" width="75px">Local</th>
                                                <th class="text-center align-middle" width="75px">Non<br>Local</th>
                                                <th class="text-center align-middle" width="75px">Total<br>Tujuan</th>
                                            </tr>
                                        </thead>

                                        <tbody>
                                            @foreach ($table_result as $dt)
                                                <tr>
                                                    <td class="text-center">{{ $dt->id }}</td>
                                                    <td class="text-center">{{ $dt->status }}</td>
                                                    <td>{{ $dt->Nama }}</td>
                                                    <td class="text-center">{{ $dt->role }}</td>
                                                    <td class="text-center">{{ $dt->Tanggal }}</td>
                                                    <td class="text-center">{{ $dt->Berangkat }}</td>
                                                    <td class="text-center">{{ $dt->Kembali }}</td>
                                                    <td class="text-center">{{ $dt->Total_jam }}</td>
                                                    <td class="text-center">{{ $dt->KM_Awal }}</td>
                                                    <td class="text-center">{{ $dt->KM_Akhir }}</td>
                                                    <td class="text-center">{{ $dt->Total_KM }}</td>
                                                    <td class="text-center">{{ $dt->total_local }}</td>
                                                    <td class="text-center">{{ $dt->total_non_local }}</td>
                                                    <td class="text-center">{{ $dt->jenislokasi }}</td>
                                                    {{-- <td class="text-center">{{ $dt->Lembur }}</td> --}}
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    @endif
                                </table>
                            </div>
                        </div>

                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                @if ($table_result)
                                @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>`)
            }



        });

        function openClose(idpureq, item) {
            const button = event.target;
            const status_h = button.dataset.statusH;
            const status_d = button.dataset.statusD;
            console.log(status_h);
            // const status_h = this.getAttribute('data-status-h'); // Ambil data-status-h
            // const status_d = this.getAttribute('data-status-d'); // Ambil data-status-d
            Swal.fire({
                title: (status_h == 'A' || status_h == 'F') && status_d == 'F' ?
                    'Are you sure you want to open this Purchase Requisition?' :
                    'Are you sure you want to close this Purchase Requisition?',
                showDenyButton: true,
                confirmButtonText: "Yes",
                denyButtonText: `No`,
                icon: 'warning',
            }).then((result) => {
                /* Read more about isConfirmed, isDenied below */
                if (result.isConfirmed) {
                    $.ajaxSetup({
                        headers: {
                            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                        }
                    });

                    $.ajax({
                        url: '{{ URL::to('/') }}/open_close',
                        method: "POST",
                        data: {
                            idPR: idpureq,
                            item_number: item
                        },
                        success: function(response) {
                            if (response.status == 'success') {
                                Swal.fire({
                                    title: (status_h == 'A' || status_h ==
                                            'F') &&
                                        status_d == 'F' ?
                                        'Open this Purchase Requisition Success' :
                                        'Close this Purchase Requisition Success',

                                    confirmButtonText: "OK",
                                    icon: 'success',
                                }).then((result) => {
                                    if (result.isConfirmed) {

                                        window.history.go(-1);

                                    }
                                })
                            } else {
                                Swal.fire({
                                    title: (status_h == 'A' || status_h ==
                                            'F') &&
                                        status_d == 'F' ?
                                        'Open this Purchase Requisition Failed' :
                                        'Close this Purchase Requisition Failed',
                                    confirmButtonText: "OK",
                                    icon: 'error',
                                }).then((result) => {
                                    if (result.isConfirmed) {

                                        window.history.back(-1);
                                    }
                                })
                            }
                        },
                    })
                }
            });
        }
        //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: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
                    },
                },
                {
                    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: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
                    },
                },
                {
                    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: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
                    },
                },
            ],
            drawCallback: function() {
                // Apply text-end class to numeric cells on each draw
                $('#list_{{ $dmenu }} tbody tr').each(function() {
                    $(this).find('td').each(function() {
                        let cellContent = $(this).text().trim();
                        if ($.isNumeric(cellContent)) {
                            $(this).addClass('text-end');
                        }
                    });
                });
            }
        });
        //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/msjkurirbkk/resources/views/report/rptdrv/result.blade.php</b> on line <b>296</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjkurirbkk/resources/views/report/rptdrv/result.blade.php</b> on line <b>296</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjkurirbkk/resources/views/report/rptdrv/result.blade.php</b> on line <b>297</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjkurirbkk/resources/views/report/rptdrv/result.blade.php</b> on line <b>297</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjkurirbkk/resources/views/report/rptdrv/result.blade.php</b> on line <b>298</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjkurirbkk/resources/views/report/rptdrv/result.blade.php</b> on line <b>298</b><br />
    </script>
@endpush