@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="row">
                            <div class="card-header col-md-auto">
                                <h5 class="mb-0">List {{ $title_menu }}</h5>
                            </div>
                            <div class="col">
                                {{-- alert --}}
                                @include('components.alert')
                            </div>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                <div class="nav-wrapper">
                                    {{-- check authorize add --}}
                                    @if ($authorize->add == '1')
                                        {{-- button add --}}
                                        <button class="btn btn-primary mb-0"
                                            onclick="window.location='{{ URL::to($url_menu . '/add') }}'">
                                            <i class="fas fa-plus me-1"> </i>
                                            <span class="font-weight-bold">Tambah</span>
                                        </button>
                                    @endif

                                    {{-- Input Batch --}}
                                    <input type="text" id="batch-input" class="form-control d-inline-block w-25 ms-2"
                                        placeholder="Masukkan batch yang ingin dihapus">

                                    {{-- button delete --}}
                                    <button class="btn btn-danger mb-0 ms-2" id="delete-button">
                                        <i class="fas fa-trash me-1"> </i>
                                        <span class="font-weight-bold">Hapus</span>
                                    </button>
                                </div>
                            </div>
                        </div>

                        <div class="row px-4 py-2">
                            @php
                                // Fetch data from the query
                                $data = DB::select("SELECT a.period, 
                                    (SELECT COUNT(batch) FROM mst_rawdata WHERE period = a.period)
as ROLL 
                                    FROM mst_rawdata a 
                                    GROUP BY a.period 
                                    ORDER BY a.period DESC");
                            @endphp

                            <div class="row px-4 py-2">
                                @php
                                    // Fetch data from the query
                                    $data = DB::select("SELECT a.period, 
            (SELECT COUNT(batch) FROM mst_rawdata WHERE period = a.period)
as ROLL 
        FROM mst_rawdata a 
        GROUP BY a.period 
        ORDER BY a.period DESC");
                                @endphp

                                <div class="table-responsive">
                                    <table class="table display" id="list_{{ $dmenu }}">
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th style="width: 40%;">Periode</th>
                                                <th style="width: 40%;">Roll</th>
                                                <th style="width: 20%;">Aksi</th> <!-- Column for action -->
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @if (!empty($data) && count($data) > 0)
                                                @foreach ($data as $row)
                                                    <tr>
                                                        <td style="width: 40%;">{{ $row->period }}</td>
                                                        <td style="width: 40%;">{{ $row->ROLL }}</td>
                                                        <td style="width: 20%;">
                                                            <!-- Delete Button -->
                                                            <form
                                                                action="{{ route('delete-period', ['period' => $row->period]) }}"
                                                                method="POST"
                                                                onsubmit="return confirm('Apakah Anda yakin ingin menghapus data untuk periode ini?')">
                                                                @csrf
                                                                @method('DELETE') <!-- Method DELETE -->
                                                                <button type="submit"
                                                                    class="btn btn-danger btn-sm">Delete</button>
                                                            </form>
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            @endif
                                        </tbody>
                                    </table>
                                </div>
                            </div>

                            <!-- Menampilkan pesan sukses atau error -->
                            @if (session('success'))
                                <div class="alert alert-success">
                                    {{ session('success') }}
                                </div>
                            @endif

                            @if (session('error'))
                                <div class="alert alert-danger">
                                    {{ session('error') }}
                                </div>
                            @endif

                        </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 numColumns = $('#list_{{ $dmenu }}').DataTable().columns().count();
            let columnNames = '';
            for (let index = 0; index < numColumns; index++) {
                columnNames = $('#list_{{ $dmenu }}').DataTable().columns(index).header()[0].textContent;
                if (columnNames == 'Status' || columnNames == 'status') {
                    columnAbjad = String.fromCharCode(65 + index);
                }
            }

            //check class exp
            if ($('*').hasClass('exp')) {
                $('#noted').html(`<code>Note :( <i aria-hidden="true" style="color: #ffc2cd;"
                class="fas fa-circle"></i> Data not active ), ( <i aria-hidden="true"
                style="color: #ffe768;" class="fas fa-circle"></i> ` + $('#datenote').text() + ` )</code>`)
            }

            // AJAX delete function
            $('#delete-button').on('click', function() {
                var batch = $('#batch-input').val(); // Ambil nilai dari input

                if (!batch) {
                    alert('Silahkan masukkan batch yang ingin dihapus.');
                    return;
                }

                // Kirim permintaan AJAX untuk menghapus data
                $.ajax({
                    url: '/batch', // Ganti dengan route yang sudah Anda tentukan
                    type: 'DELETE',
                    data: {
                        batch: $('#batch-input').val(), // Mengambil input batch dari pengguna
                        _token: '{{ csrf_token() }}', // Tambahkan token CSRF untuk keamanan
                    },
                    success: function(response) {
                        // Memeriksa status respons
                        if (response.status === 'success') {
                            Swal.fire({
                                title: 'Berhasil!',
                                text: response.message,
                                icon: 'success',
                            }).then(() => {
                                // Reload atau lakukan tindakan setelah berhasil
                                location.reload();
                            });
                        } else {
                            // Jika tidak berhasil, tampilkan pesan error
                            Swal.fire({
                                title: 'Gagal!',
                                text: response.message,
                                icon: 'error', // Menampilkan ikon error
                            });
                        }
                    },
                    error: function(xhr) {
                        // Menangani kesalahan
                        Swal.fire({
                            title: 'Error!',
                            text: xhr.responseJSON.message,
                            icon: 'error',
                        });
                    }
                });
            });


        });

        //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',
                    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',
                    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',
                    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/msjqapdreport/resources/views/master/addraw/list.blade.php</b> on line <b>272</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjqapdreport/resources/views/master/addraw/list.blade.php</b> on line <b>272</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjqapdreport/resources/views/master/addraw/list.blade.php</b> on line <b>273</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjqapdreport/resources/views/master/addraw/list.blade.php</b> on line <b>273</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjqapdreport/resources/views/master/addraw/list.blade.php</b> on line <b>274</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjqapdreport/resources/views/master/addraw/list.blade.php</b> on line <b>274</b><br />

        //function delete
        function deleteData(event, name, msg) {
            event.preventDefault(); // Prevent default form submission
            Swal.fire({
                title: 'Konfirmasi',
                text: `Apakah Anda Yakin ${msg} Data ${name} ini?`,
                icon: 'warning',
                showCancelButton: true,
                confirmButtonText: `Ya, ${msg}`,
                cancelButtonText: 'Batal',
                confirmButtonColor: '#028284'
            }).then((result) => {
                if (result.isConfirmed) {
                    // Find the closest form element and submit it manually
                    event.target.closest('form').submit();
                }
            });
        }
    </script>
@endpush