<div class="row">
    <div class="col-sm-12">
        <p><a href="<?= base_url('admin/stocks'); ?>"><i class="fa fa-arrow-left" aria-hidden="true"></i> Kembali ke Stok Produk</a></p>
        <h3>Stok Produk Yang Menipis (Under 10)</h3>
        <?= $this->session->flashdata('success'); ?>
    </div>
</div>

<!-- Add brand filter form -->
<!-- Add brand filter form -->
<form action="<?= base_url('admin/stocks/stock_low'); ?>" method="get">
    <div class="form-group">
        <label for="brand">Filter by Brand:</label>
        <select name="brand" id="brand" class="form-control">
            <option value="">All Brands</option>
            <?php foreach ($brands as $brand) : ?>
                <option value="<?= $brand->id_brands; ?>" <?= (isset($selected_brand) && $selected_brand == $brand->id_brands) ? 'selected' : ''; ?>><?= $brand->brand; ?></option>
            <?php endforeach; ?>
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Filter</button>
</form>


<div class="row">
    <div class="col-sm-12">
        <div class="table-responsive">
            <table class="table table-striped" id="productTable">
                <thead>
                    <tr>
                        <th>Nama Produk - Attribute - SKU</th>
                        <th>Stok Jual</th>
                        <th>Stok Keep</th>
                        <th>Stok Total</th>
                        <th>Detail Stok</th>
                    </tr>
                </thead>
                <tbody>
                    <?php if (count($products)) : ?>
                        <?php foreach ($products as $product) : ?>
                            <tr>
                                <td><?= ucfirst($product->title); ?> - <?= ucfirst($product->attribute_detail); ?> <br> <?= ucfirst($product->sku); ?></td>
                                <td><?= ucfirst($product->stock); ?> </td>
                                <td><?= ucfirst($product->stock_keep); ?> </td>
                                <td><?= ucfirst($product->stock_keep + $product->stock); ?></td>
                                <td> <a href="<?= base_url() . 'admin/stocks/get/' . $product->id_products; ?>" target="_blank"><i class="fa fa-file" aria-hidden="true"></i> Lihat & Edit</td>
                            </tr>
                        <?php endforeach; ?>
                    <?php else : ?>
                        <tr>
                            <td colspan="3">Produk tidak ditemukan.</td>
                        </tr>
                    <?php endif; ?>
                </tbody>
            </table>
        </div><!-- end class responsive-->
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->

<script src="https://cdn.datatables.net/plug-ins/1.10.21/sorting/order.js"></script>
<script src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.flash.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.print.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.21/css/jquery.dataTables.min.css">
<script>
    $(document).ready(function() {
        $('#productTable').DataTable({
            "dom": 'Bfrtip',
            "buttons": [{
                    extend: 'copy',
                    filename: function() {
                        return 'Stock_Under_10_report';
                    },
                    text: 'Copy',
                },
                {
                    extend: 'excel',
                    filename: function() {
                        return 'Stock_Under_10_report';
                    },
                    text: 'Export to Excel',
                },
                {
                    extend: 'csv',
                    filename: function() {
                        return 'Stock_Under_10_report';
                    },
                    text: 'Export to CSV',
                },
                {
                    extend: 'pdf',
                    filename: function() {
                        return 'Stock_Under_10_report';
                    },
                    text: 'Export to PDF',
                },
                {
                    extend: 'print',
                    filename: function() {
                        return 'Stock_Under_10_report';
                    },
                    text: 'Print',
                }
            ],
        });
    });
</script>