@extends('layouts.app')
@section('title')
    Material Requisition
@endsection
@section('button')
    <a type="button" class="btn btn-info" href="{{ route('material_requisition.create') }}">
        <i class="bi bi-plus-square"></i> Create
    </a>
@endsection
@section('content')
    <style>
        .all_column {
            background: transparent;
            color: white;
        }
    </style>
    <div class="card">
        <div class="card-body tr_1">
            <div class="table-responsive tr_2">
                <table class="table table-bordered m-0 datatable">
                    <thead>
                        <tr>
                            <th>No.</th>
                            <th>MRF No.</th>
                            <th>Request From</th>
                            <th>Request To</th>
                            <th>Request Date</th>
                            <th>Status</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <thead>
                        <tr>
                            <th></th>
                            <th>
                                <input type="text" id="search-mrf_no" class="all_column" placeholder="Search MRF No.">
                            </th>
                            <th>
                                <input type="text" id="search-request_from" class="all_column"
                                    placeholder="Search Request From">
                            </th>
                            <th>
                                <input type="text" id="search-request_to" class="all_column"
                                    placeholder="Search Request To">
                            </th>
                            <th>
                                <input type="text" id="search-request_date" class="all_column"
                                    placeholder="Search Request Date">
                            </th>
                            <th>
                                <input type="text" id="search-status" class="all_column" placeholder="Search Status">
                            </th>
                            <th></th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <script>
        var searchTimeout;
        var table;
        let allData = {};
        $(document).ready(function() {
            let bool = true;
            const tableKey = 'DataTables_DataTables_Table_0_' + window.location.pathname;
            const savedState = localStorage.getItem(tableKey);

            if (savedState) {
                allData = JSON.parse(savedState);
                if (allData.columns) {
                    allData.columns.forEach((col, i) => {
                        if (col.search) {
                            $('thead tr:eq(1) th').eq(i).find('input').val(col.search);
                        }
                    });
                }

                if (allData.search && allData.search.sSearch) {
                    $('#dt-search-0').val(allData.search.sSearch);
                }
                bool = false;
            }
            
            table = $('.datatable').DataTable({
                processing: true,
                serverSide: true,
                displayStart: allData.start || 0,
                pageLength: allData.length || 10,
                order: allData.order || [],
                search: allData.search || {},
                language: {
                    processing: 'Processing'
                },
                ajax: {
                    url: "{{ route('material_requisition.index') }}",
                    type: 'GET',
                    data: function(d) {
                        d.mrf_no = $('#search-mrf_no').val();
                        d.request_from = $('#search-request_from').val();
                        d.request_to = $('#search-request_to').val();
                        d.request_date = $('#search-request_date').val();
                        d.status = $('#search-status').val();
                        d.bool = bool;
                    }
                },
                columns: [{
                        data: 'DT_RowIndex',
                        name: 'DT_RowIndex',
                        orderable: false,
                        searchable: false
                    },

                    {
                        data: 'ref_no',
                        name: 'ref_no',
                    },
                    {
                        data: 'department_from.name',
                        name: 'department_from.name',
                        defaultContent: ''
                    },
                    {
                        data: 'department_to.name',
                        name: 'department_to.name',
                        defaultContent: ''
                    },
                    {
                        data: 'request_date',
                        name: 'request_date',
                    },
                    {

                        data: 'status',
                        name: 'status',
                    },
                    {
                        data: 'action',
                        name: 'action',
                        orderable: false,
                        searchable: false
                    },
                ],
                paging: true,
                pagingType: 'input',
            });
            bool = false;

            

            let isFirstLoad = true;

            $('.datatable').on('search.dt page.dt order.dt length.dt', function() {
                if (isFirstLoad) {
                    isFirstLoad = false;
                    return;
                }
                bool = false;
                storeInLocalStorage();
            });

            $('.datatable thead tr:eq(1) th').each(function(i) {
                $('input', this).on('keyup change', function() {
                    let value = this.value;
                    if (table.column(i).search() !== value) {
                        clearTimeout(searchTimeout);
                        searchTimeout = setTimeout(() => {
                            table.column(i).search(value).draw();
                            bool = false;
                            storeInLocalStorage();
                        }, 500);
                    }
                });
            });

            function storeInLocalStorage() {
                const tableKey = 'DataTables_DataTables_Table_0_' + window.location.pathname;
                const settings = table.settings()[0];
                const state = {
                    time: +new Date(),
                    start: settings._iDisplayStart,
                    length: settings._iDisplayLength,
                    order: settings.aaSorting,
                    search: settings.oPreviousSearch,
                    columns: settings.aoPreSearchCols.map(col => ({
                        search: col.sSearch
                    }))
                };
                localStorage.setItem(tableKey, JSON.stringify(state));
            }
        });
    </script>
@endsection