@extends('layouts.admin')

@section('main-content')

<div class="card shadow">
    <h1 class="card-header h3 mb-4 text-gray-800">
        Dolgozók
    </h1>
    <div class="card-body">
        <div class="row input-daterange position-absolute" style="top: 140px; padding-left: 220px; z-index: 1000;">
            <form method="GET">
                <div>
                    <label>
                        <input type="date" onchange="this.form.submit();" value="{{ app('request')->input('from') ?? Carbon\Carbon::now()->firstOfMonth()->format('Y-m-d') }}" name="from" id="from" class="form-control form-control-sm d-inline-block w-auto" placeholder="Dátumtól" />
                        <input type="date" onchange="this.form.submit();" value="{{ app('request')->input('to') ?? Carbon\Carbon::now()->format('Y-m-d') }}" name="to" id="to" class="form-control form-control-sm d-inline-block w-auto" placeholder="Dátumig" />
                    </label>
                    <label>
                        <select onchange="this.form.submit();" class="form-control custom-select" name="project_id">
                            <option value="">Válassz...</option>
                            @foreach ( $projects as $project )
                            <option value="{{ $project->id }}" @if(request()->input('project_id') == $project->id) selected @endif>{{ $project->name }}</option>
                            @endforeach
                        </select>
                    </label>
                </div>
            </form>
        </div>
        <table class="table table-bordered table-striped" id="workers-table">
            <thead>
                <tr>
                    <th data-priority="1">Munkaterület</th>
                    <th data-priority="2">Név</th>
                    <th>Adóazonosító</th>
                    <th data-priority="4">Dátumtól</th>
                    <th data-priority="5">Dátumig</th>
                    <th data-priority="3">Munkaóra</th>
                </tr>
            </thead>
        </table>
    </div>
</div>
@endsection

@push('scripts')
<script>
$(function() {

    // excel export all row | serverSide: true
    var oldExportAction = function (self, e, dt, button, config) {
        if (button[0].className.indexOf('buttons-excel') >= 0) {
                if ($.fn.dataTable.ext.buttons.excelHtml5.available(dt, config)) {
                    $.fn.dataTable.ext.buttons.excelHtml5.action.call(self, e, dt, button, config);
                }
                else {
                    $.fn.dataTable.ext.buttons.excelFlash.action.call(self, e, dt, button, config);
                }
        } else if (button[0].className.indexOf('buttons-print') >= 0) {
                $.fn.dataTable.ext.buttons.print.action(e, dt, button, config);
        }
    };

    var newExportAction = function (e, dt, button, config) {
        var self = this;
        var oldStart = dt.settings()[0]._iDisplayStart;

        dt.one('preXhr', function (e, s, data) {
            // Just this once, load all data from the server...
            data.start = 0;
            data.length = 2147483647;

            dt.one('preDraw', function (e, settings) {
                // Call the original action function
                oldExportAction(self, e, dt, button, config);

                dt.one('preXhr', function (e, s, data) {
                    // DataTables thinks the first item displayed is index 0, but we're not drawing that.
                    // Set the property to what it was before exporting.
                    settings._iDisplayStart = oldStart;
                    data.start = oldStart;
                });

                // Reload the grid with the original page. Otherwise, API functions like table.cell(this) don't work properly.
                setTimeout(dt.ajax.reload, 0);

                // Prevent rendering of the full data to the DOM
                return false;
            });
        });

        // Requery the server with the new one-time export settings
        dt.ajax.reload();
    };

    $("#workers-table").append(
       $('<tfoot/>').append( $("#workers-table thead tr").clone() )
    );

    $('#workers-table tfoot th').each( function (i) {
        if(i === 2) return;
        var title = $(this).text();
        $(this).html( '<input type="text" class="form-control form-control-sm" placeholder="'+title+'" />' );
    } );

    window.workersTable = $('#workers-table').DataTable({
        processing: true,
        serverSide: false, // false for search
        responsive: true,
        fixedHeader : {
            header : true,
            footer : false,
            headerOffset: 45
        },
        ajax: {
            url: "{{ url()->current() }}?from="+$('input[name="from"]').val()+"&to="+$('input[name="to"]').val()+"&project_id="+$('select[name="project_id"]').val(),
        },
        columns: [
            { data: 'project', name: 'project' },
            { data: 'name', name: 'worker.name' },
            { data: 'tax_id_number', name: 'tax_id_number' },
            { data: 'from', name: 'from' },
            { data: 'to', name: 'to' },
            { data: 'totalhours', name: 'totalhours' },
        ],
        pageLength: 25,
        //pagingType: 'full',
        filter: true,
        search: {
            "smart": true,
            "caseInsensitive": true
        },
        order: [[1, 'asc']],
        lengthMenu: [[25, 50, 100, -1], [25, 50, 100, "All"]],
        dom: "<'mb-2'B><'row'<'col-sm-6'l><'col-sm-6'f>>rtip",
        buttons: [
            {
                filename: 'workers',
                text: 'Excel',
                extend: 'excel',
                //action: newExportAction
            },
            {
                extend: 'colvis',
                text: 'Láthatóság'
            }
        ],
        createdRow: function( row, data, dataIndex){
            /*
            if( data['status_name'] !=  'Lezárva') {
                $(row).addClass(data['SLA_name']+'_color');
            }
            else {
                $(row).addClass('closed_color');
            }
            */
        },
        initComplete: function () {
            this.api().columns().every(function () {
                var column = this;
//                var input = document.createElement("input");
//                input.className = 'form-control form-control-sm';
//                input.placeholder = 'text';
//                $(input).appendTo($(column.footer()).empty())
                $('input', this.footer())
//                .on('keyup change clear', function () {
                .on('change', function () {
                    if ( column.search() !== this.value ) {
                        column.search( this.value ).draw();
                    }
                });
            });
        },
        drawCallback: function( settings )
        {
			//
        }
    });
});
</script>
@endpush