@extends('admin.layouts.master')
@section('title', 'Product list')
@section('content')

    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <div class="card card-primary card-outline mt-3">
                        <div class="card-header">
                            <h3 class="card-title mt-1"><b>{{ __('Qogita List') }}</b></h3>
                            <div class="card-tools d-flex">

                            </div>
                        </div>
                        <div class="card-body">
                            <div class="tableContent">
                                <table class="table table-striped table-bordered table-sm" id="">
                                    <thead>
                                        <tr>
                                            <th>{{ __('#') }}</th>
                                            <th>{{ __('EAN') }}</th>
                                            <th>{{ __('Name') }}</th>
                                            <th>{{ __('Size') }}</th>
                                            <th>{{ __('Sell Unit') }}</th>
                                            <th>{{ __('Wholesale Price') }}</th>
                                            <th>{{ __('Quntity') }}</th>
                                            <th>{{ __('Brand') }}</th>
                                            <th>{{ __('Sub Category') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody id="tbody">
                                        @forelse ($products as $id => $product)
                                            <tr class="text-center">
                                                <td class="text-center">{{ ++$id }}</td>
                                                <td>{{ $product->qrcode }}</td>
                                                <td>{{ $product->name }}</td>
                                                <td>{{ $product->size }}ML</td>
                                                <td>{{ $product->sale_unit }}</td>
                                                <td>{{ $product->unit_price }}</td>
                                                <td>{{ $product->quantity ?? "N/A" }}</td>
                                                <td>{{ $product->brand->name }}</td>
                                                <td>{{ $product->subCategory->sub_category_name }}</td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="9" class="text-center text-muted">No products available.</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <div class="loader text-center" id="loader" style="display: none">
                            <div class="spinner-border" role="status">
                                <span class="visually-hidden"></span>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection
@section('js')
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">

    <!-- jQuery (Make sure it's included before DataTables) -->
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

    <!-- DataTables JS -->
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script>
        $(document).ready(function () {
            $('.table').DataTable({
                "paging": true,
                "lengthChange": true,
                "searching": true,
                "ordering": true,
                "info": true,
                "autoWidth": false,
                "responsive": true,
                "order": [],
                "pageLength": 50,
                "lengthMenu": [
                    [10, 25, 50, 100],
                    [10, 25, 50, 100]
                ],
                "columnDefs": [{
                    "orderable": false,
                    "targets": [0, -1]
                }],
                "dom": 'lfrtip',
                "buttons": [{
                    extend: 'excelHtml5',
                    text: 'Export to Excel',
                    title: 'Data Export',
                    className: 'btn btn-success btn-sm'
                }]
            }).buttons().container().appendTo('.card-header .card-tools');
        });
    </script>
@endsection