@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">Pemakaian Bahan Baku</h5>
                            </div>
                            <div class="col">
                                {{-- alert --}}
                                @include('components.alert')
                            </div>
                            @if ($authorize->approval == '1')  
                                <div>
                                    <button class="btn btn-primary mb-0" onclick="sinkron()"><i class="fas fa-sync"> Sinkronisasi</i></button>
                                </div>
                            @endif

                        </div>
                        <hr class="horizontal dark mt-0" />

                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="display table" id="list_{{ $dmenu }}">
                                    <thead class="thead-light" style="background-color: #00b7bd4f">
                                        <tr>
                                            <th>No</th>
                                            <th>Type</th>
                                            <th>Group</th>
                                            <th>Material</th>
                                            <th>Description</th>
                                            <th>Current Stock</th>
                                            <th>Qty Out</th>
                                            <th>UOM</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {{-- retrieve table detail --}}
                                        @foreach ($listData as $detail)
                                            @php
                                                $primary = '';
                                                foreach ($table_primary as $p) {
                                                    $primary == ''
                                                        ? ($primary = $detail->{$p->field})
                                                        : ($primary = $primary . ':' . $detail->{$p->field});
                                                }
                                                $vcount = $loop->iteration;
                                            @endphp

                                            <tr>
                                                <td>{{ $vcount }}</td>
                                                <td>
                                                    {{ $detail->MTART }}
                                                </td>
                                                <td>
                                                    {{ $detail->MATKL }}
                                                </td>
                                                <td>
                                                    {{ $detail->MATNR }}
                                                </td>
                                                <td>
                                                    {{ $detail->MAKTX }}
                                                </td>
                                                <td>
                                                    {{ $detail->MENGE }}
                                                </td>
                                                <td>
                                                    {{ $detail->QTY_OUT }}
                                                </td>
                                                <td>
                                                    {{ $detail->MEINS }}
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="row mt-3">
            <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">{{ $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="table-responsive">
                                <table class="display table" id="list_sending">
                                    <thead class="thead-light" style="background-color: #00b7bd4f">
                                        <tr>
                                            <th>No</th>
                                            <th>Type</th>
                                            <th>Total Qty Out</th>
                                            <th>QTY GR</th>
                                            <th>UOM</th>
                                            <th>GR Date</th>
                                            <th>Date Sending</th>
                                            <th>ETA</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {{-- retrieve table detail --}}
                                        @foreach ($listSend as $detail)
                                            @php
                                                $primary = '';
                                                foreach ($table_primary as $p) {
                                                    $primary == ''
                                                        ? ($primary = $detail->{$p->field})
                                                        : ($primary = $primary . ':' . $detail->{$p->field});
                                                }
                                                $vcount = $loop->iteration;
                                            @endphp

                                            <tr>
                                                <td>{{ $vcount }}</td>
                                                <td>
                                                    {{ $detail->MATKL }}
                                                </td>
                                                <td>
                                                    {{ $detail->TOTAL_QTY }}
                                                </td>
                                                <td>
                                                    {{ $detail->QTY_GR }}
                                                </td>
                                                <td>
                                                    {{ $detail->MEINS }}
                                                </td>
                                                <td>
                                                    {{ $detail->DATE_GR }}
                                                </td>
                                                <td>
                                                    {{ $detail->DATE_LOT }}
                                                </td>
                                                <td>
                                                    {{ $detail->ETA }}
                                                </td>
                                                <td>
                                                    {{-- <span class="btn badge bg-primary" onclick="getDetail('{{ $detail->IDLOT }}')">Detail</span> --}}
                                                    <span class="btn mb-0 badge bg-gradient-primary" onclick="getDetail('{{ $detail->IDLOT }}')">Detail</span>
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="modal fade" id="modalDetail" tabindex="-1" role="dialog" aria-labelledby="modalDetailTitle" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered" role="document">
          <div class="modal-content">
            <div class="modal-header">
              <h5 class="modal-title" id="modalDetailTitle">List Detail</h5>
              <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
              </button>
            </div>
            <div class="modal-body">
                <table class="display table table-responsive" id="table-detail">
                    <thead class="thead-light" style="background-color: #00b7bd4f">
                        <tr>
                            <th>No</th>
                            <th>Material Group</th>
                            <th>Material Code</th>
                            <th>Qty</th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </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>
        $(document).ready(function() {

            let numColumns = $('#list_{{ $dmenu }}').DataTable().columns().count();
            let numColumnsSend = $('#list_sending').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);
                }
            }

            let columnNamesSend = '';
            for (let index = 0; index < numColumnsSend; index++) {
                columnNamesSend = $('#list_sending').DataTable().columns(index).header()[0].textContent;
                if (columnNamesSend == 'Status' || columnNamesSend == 'status') {
                    columnAbjad = String.fromCharCode(65 + index);
                }
            }
            //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> ` +
                    $('#datenote').text() + ` )</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> ` +
                    $('#stocknote').text() + ` )</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> ` +
                    $('#datenote').text() +
                    ` ), ( <i aria-hidden="true"
                    style="color: #f93c3c;" class="fas fa-circle"></i> ` +
                    $('#stocknote').text() + ` )</code>`)
            }
            
            // Memulai penjadwalan
            // scheduleDailyTasks();
        });

        function sinkron() {
            // Mendapatkan waktu saat ini
            const sekarang = new Date();
            
            // Mendapatkan jam dan menit saat ini
            const jamSekarang = sekarang.getHours();
            const menitSekarang = sekarang.getMinutes();
            
            // Jika jam lebih besar dari 12 dan menit lebih besar dari 30
            if (jamSekarang > 12 || (jamSekarang === 12 && menitSekarang >= 30)) {
                // Jalankan function runAtTwelvePM jika waktu lebih dari jam 12:30
                runAtTwelvePM();
            } else {
                // Jalankan function runAtOnePM jika waktu kurang dari jam 12:30
                runAtOneAM();
            }
        }


        function runAtOneAM() {
            // Mendapatkan tanggal saat ini
            let today = new Date();

            // Mengurangi 1 hari
            today.setDate(today.getDate() - 1);

            // Mengubah ke format yyyy-mm-dd
            let yesterday = today.toISOString().split('T')[0];
            ambilData(yesterday, '12:30:00'); // ambil tgl kemaren yg jam pukulnya lebih dari 12:30:00
        }

        function runAtTwelvePM() {
            // Mendapatkan tanggal saat ini
            let today = new Date();

            // Mengubah ke format yyyy-mm-dd
            let tgl = today.toISOString().split('T')[0];
            ambilData(tgl, '00:00:00'); // ambil tgl sekarang yg jam pukulnya lebih dari 00:00:00
        }

        function scheduleDailyTasks() {
            let now = new Date();
            
            // Waktu target pertama: pukul 01:00 dini hari
            let targetTimeOneAM = new Date();
            targetTimeOneAM.setHours(1, 0, 0, 0);
            if (now > targetTimeOneAM) {
                targetTimeOneAM.setDate(targetTimeOneAM.getDate() + 1);
            }

            // Waktu target kedua: pukul 12:30 siang
            let targetTimeTwelvePM = new Date();
            targetTimeTwelvePM.setHours(12, 30, 0, 0);
            if (now > targetTimeTwelvePM) {
                targetTimeTwelvePM.setDate(targetTimeTwelvePM.getDate() + 1);
            }

            // Selisih waktu untuk masing-masing target
            let timeDifferenceOneAM = targetTimeOneAM - now;
            let timeDifferenceTwelvePM = targetTimeTwelvePM - now;

            // Menjalankan fungsi pada pukul 01:00 dini hari
            setTimeout(function() {
                runAtOneAM();
                
                // Menjadwalkan untuk menjalankan fungsi setiap 24 jam pada pukul 01:00 dini hari
                setInterval(runAtOneAM, 24 * 60 * 60 * 1000); // 24 jam dalam milidetik

            }, timeDifferenceOneAM);

            // Menjalankan fungsi pada pukul 12:00 siang
            setTimeout(function() {
                runAtTwelvePM();

                // Menjadwalkan untuk menjalankan fungsi setiap 24 jam pada pukul 12:00 siang
                setInterval(runAtTwelvePM, 24 * 60 * 60 * 1000); // 24 jam dalam milidetik

            }, timeDifferenceTwelvePM);
        }


        //function ambil data dari SAP
        function ambilData(tgl, pukul) {
            //ajax mengambil data dari API SAP
            $.ajax({
                url: "{{ url('getData') }}", // Adjust the URL based on your Laravel routes
                type: 'POST',
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
                data: {
                    date: tgl,
                    pukul: pukul
                }, 
                success: function(data) {
                    hitungData(tgl, pukul);
                },
                error: function(data) {
                    Swal.fire({
                        icon: 'error',
                        title: 'Error',
                        text: data.responseText,
                        confirmButtonText: 'OK'
                    });
                }
            });
        }

        //function hitung total pemakaian
        function hitungData(tgl, pukul) {
            $.ajax({
                url: "{{ url('hitungData') }}", // Adjust the URL based on your Laravel routes
                type: 'POST',
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
                data: {
                    date: tgl,
                    pukul: pukul
                },
                success: function(data) {
                    window.location.reload();
                },
                error: function(data) {
                    Swal.fire({
                        icon: 'error',
                        title: 'Error',
                        text: data.responseText,
                        confirmButtonText: 'OK'
                    });
                }
            });
        }

        function getDetail(idlot){
            $.ajax({
                url: "{{ url('getDetail') }}",
                type: 'POST',
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
                data: {
                    idlot: idlot
                },
                success: function(data){
                    // tampung ke loaditem
                    loadItems(data);
                    $('#modalDetail').modal('show');
                },
                error: function(data){
                    Swal.fire({
                        icon: 'error',
                        title: 'Error',
                        text: data.responseText,
                        confirmButtonText: 'OK'
                    });
                }
            });
        }

        function loadItems(list){
            var i = 0;
            var no = 1;
            var listData = [];
            list.forEach($m => {
                var obj = {};
                obj['NO'] = no;
                obj['MATKL'] = $m['MATKL'];
                obj['MATNR'] = $m['MATNR'];
                obj['QTY'] = $m['QTY'];

                listData.push(obj);
                if(i == (list.length - 1)){
                    refreshTableDetail(listData);
                }
                i = i + 1;
                no = no + 1;
            });
        }

        function refreshTableDetail(list){
            $('#table-detail').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)"
                },
                "searching": false,
                "paging": false,
                "destroy": true,
                "responsive": true,
                "data": list,
                "columns": [{
                    data: 'NO'
                }, {
                    data: 'MATKL'
                }, {
                    data: 'MATNR'
                }, {
                    data: 'QTY'
                }]
            })
        }

        let columnAbjad = '';
        //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)"
            },
            searching: true,
            paging: false,
            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',
                    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)'
                    },
                },
            ]
        });
        $('#list_sending').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)"
            },
            searching: true,
            paging: true,
            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',
                    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/msjdelivery/resources/views/pages/sapins/list.blade.php</b> on line <b>584</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjdelivery/resources/views/pages/sapins/list.blade.php</b> on line <b>584</b><br />

        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjdelivery/resources/views/pages/sapins/list.blade.php</b> on line <b>586</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjdelivery/resources/views/pages/sapins/list.blade.php</b> on line <b>586</b><br />

        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjdelivery/resources/views/pages/sapins/list.blade.php</b> on line <b>588</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjdelivery/resources/views/pages/sapins/list.blade.php</b> on line <b>588</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