<style>
    .chosen-container,
    .chosen-container-single {
        width: 100% !important;
    }

    @media only screen and (min-width: 768px) {
        .dataTables_filter {
            text-align: right;
        }

        .dataTables_paginate {
            text-align: right;
        }

        .dataTables_info {
            padding-top: 25px;
        }

        .export {
            text-align: right;
        }

        .addBtn {
            width: 300px;
            text-align: center;
        }

        .divAdd {
            text-align: left;
        }
    }

    @media only screen and (max-width: 768px) {
        .divAdd {
            text-align: center;
        }

        .addBtn {
            width: 100%;
            text-align: center;
        }

        .export {
            text-align: right;
            padding: 15px 0;
        }
    }
</style>


<div class="row">
    <div class="col-sm-12">
        <p><a href="<?= base_url('admin/stocks/transfer_stock'); ?>"><i class="fa fa-arrow-left" aria-hidden="true"></i> Kembali ke Transfer Stok</a></p><br>
        <h2>Transfer Stock Export</h2>
        <?= $this->session->flashdata('success'); //to display success message 
        ?>
        <?= $this->session->flashdata('result'); //to display result message 
        ?>
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->

<br><br>
<div class="table-responsive">
    <table id="tabeltfstock_export" class="table table-striped">
        <thead>
            <tr>
                <th>No</th>
                <th>Tanggal</th>
                <th>Nama Produk</th>
                <th>QTY</th>
                <th>Gudang asal</th>
                <th>Gudang Tujuan</th>
                <th>Status</th>
            </tr>
        </thead>
        <tbody>
            <?php
            $i = 1;
            foreach ($transfer_stock_detail as $tsd) : ?>
                <?php $query = $this->db->select('*')->from('transfer_stock')->where('id_transfer_stock', $tsd->id_transfer_stock)->get()->row(); ?>

                <tr>
                    <td><?= $i; ?></td>
                    <td><?= $query->created; ?></td>
                    <td><?= $tsd->item_name; ?></td>
                    <td><?= $tsd->quantity; ?></td>
                    <td>
                        <?php
                        //get warehouse
                        $this->db->select('name')->from('warehouse')->where('id', $query->out_warehouse_id);
                        $warehouse_name = $this->db->get()->row()->name;
                        echo ucwords($warehouse_name);
                        ?>
                    </td>
                    <td><?php
                        //get warehouse
                        $this->db->select('name')->from('warehouse')->where('id', $query->in_warehouse_id);
                        $warehouse_name = $this->db->get()->row()->name;
                        echo ucwords($warehouse_name);
                        ?></td>
                    <td>
                        <?php
                        if ($query->status == 0) {
                            echo 'Pending';
                        } elseif ($query->status == 1) {
                            echo 'Proses';
                        } elseif ($query->status == 2) {
                            echo 'Terkirim';
                        } elseif ($query->status == 3) {
                            echo 'Diterima';
                        } elseif ($query->status == 4) {
                            echo 'Batal';
                        } else {
                            echo 'Status tidak valid';
                        }
                        ?> </td>
                </tr>
            <?php $i++;
            endforeach ?>
        </tbody>
    </table>
</div>

<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">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.6.2/css/buttons.dataTables.min.css">
<script>
    $(document).ready(function() {
        $('#tabeltfstock_export').DataTable({
            "ordering": false,
            "searching": false, // Menonaktifkan kolom pencarian
            dom: 'Bfrtip',
            buttons: [{
                    extend: 'excelHtml5',
                    title: 'Transfer Stock <?php echo (isset($_SESSION['startProduk'])) ? $_SESSION['startProduk'] . " - " . $_SESSION['endProduk'] : ""  ?>'
                },
                {
                    extend: 'pdfHtml5',
                    title: 'Transfer Stock <?php echo (isset($_SESSION['startProduk'])) ? $_SESSION['startProduk'] . " - " . $_SESSION['endProduk'] : ""  ?>'
                },
                {
                    extend: 'print',
                    title: 'Transfer Stock <?php echo (isset($_SESSION['startProduk'])) ? $_SESSION['startProduk'] . " - " . $_SESSION['endProduk'] : ""  ?>'
                }
            ]
        });
    });
</script>