@extends('master')
@section('content')

<section>
    <div class="container-fluid">
        <div class="card mb-4">
            <div class="card-header with-border">
                <h3 class="card-title text-center">{{__('Monthly Attendance Info')}}
                    <hr><span
                        id="details_month_year" class="thin-text"></span>
                </h3>
            </div>
            <div class="card-body">
                <div class="row">
                    <div class="col-md-12">
                        <form method="post" id="filter_form" class="form-horizontal">
                            @csrf
                            <div class="row">
                                <div class="col-md-4 fv-row mb-5">
                                            <label class="required fs-5 fw-bold mb-2">{{__('Month Year')}}</label>
                                            <input type="text" name="month_year" id="month_year" class="form-control form-control-solid flatpickr-date"
                                                autocomplete="off" value="{{ date('F Y') }}" placeholder="Select Month Year">
                                </div>
                                <div class="col-md-4">
                                    <div class="form-group">
                                    <label class="required fs-5 fw-bold mb-2">{{__('Company')}}</label>

                                        <select name="company_id" id="company_id" class="form-select form-select-solid dynamic" data-dropdown-parent="#filter_form" data-control="select2"
                                            data-live-search="true" data-live-search-style="contains" data-first_name="first_name" data-last_name="last_name" data-placeholder="Select Company"
                                            title='{{__('Selecting',['key'=>trans('Company')])}}...'>
                                            @foreach($companies as $company)
                                            <option value="{{$company->id}}">{{$company->company_name}}</option>
                                            @endforeach

                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-4">
                                    <div class="form-group">
                                    <label class="required fs-5 fw-bold mb-2">{{__('Employee')}}</label>
                                        <select name="employee_id" id="employee_id" data-dropdown-parent="#filter_form" data-control="select2" class="form-select form-select-solid"
                                            data-live-search="true" data-live-search-style="begins" data-placeholder="Select Employee"
                                            title='{{__('Selecting',['key'=>trans('Employee')])}}...'>
                                        </select>
                                    </div>
                                </div>
                               
                            </div>
                            <div class="form-group">
                                        <button name="submit_form" id="submit_form" type="submit" class="btn btn-primary"><i class="fa fa fa-check-square"></i> {{trans('Get')}}</button>
                            </div>
                        </form>
                    </div>
                </div>
                <div class="row">
                    <div class="col-md-12">
                        <div class="table-responsive">
                            <table id="month_wise_attendance-table" class="table table-row-dashed table-row-gray-300 align-middle gs-0 gy-4">
                                <thead>
                                    <tr  class="text-start text-muted text-uppercase fw-bolder fs-7 gs-0">
                                        <th></th>
                                        <th>{{trans('Employee')}} </th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th>{{__('Worked Days')}}</th>
                                        <th>{{__('Total Worked Hours')}}</th>
                                    </tr>
                                </thead>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <span class="attendace_mark_info mb-3">
            <small>{{trans('Present')}} = P , {{trans('Absent')}} = A ,{{trans('Leave')}} = L , {{trans('Holiday')}} = H ,{{__('Off Day')}} = O</small>
        </span>
    </div>

</section>



@endsection

@section('page_script')
<script nonce="{{ $cspNonce }}">

    (function($) {
        "use strict";

        $(document).ready(function () {
            // Initialize flatpickr for date inputs
            flatpickr(".flatpickr-date", {
                dateFormat: "F Y", // Display month and year
                altFormat: "F Y",
                theme: "material_blue",
                allowInput: true,
                onReady: function(selectedDates, dateStr, instance) {
                    instance.altInput.value = instance.formatDate(selectedDates[0], "F Y");
                }
            })

            

            fill_datatable();

            function fill_datatable(filter_company = '', filter_employee = '', filter_month_year = $('#month_year').val()) {
                $('#details_month_year').html($('#month_year').val());
                let table_table = $('#month_wise_attendance-table').DataTable({
                    initComplete: function () {
                        this.api().columns([2, 4]).every(function () {
                            var column = this;
                            var select = $('<select><option value=""></option></select>')
                                .appendTo($(column.footer()).empty())
                                .on('change', function () {
                                    var val = $.fn.dataTable.util.escapeRegex(
                                        $(this).val()
                                    );

                                    column
                                        .search(val ? '^' + val + '$' : '', true, false)
                                        .draw();
                                });

                            column.data().unique().sort().each(function (d, j) {
                                select.append('<option value="' + d + '">' + d + '</option>');
                                $('select').selectpicker('refresh');
                            });
                        });
                    },
                    responsive: false,
                    scrollX: true,
                    fixedHeader: {
                        header: true,
                        footer: true
                    },
                   
                    serverSide: true,
                    ajax: {
                        url: "{{ route('monthly_attendances.index') }}",
                        data: {
                            filter_company: filter_company,
                            filter_employee: filter_employee,
                            filter_month_year: filter_month_year,
                            "_token": "{{ csrf_token()}}"
                        },
                        // success: function (data) {
                        //     console.log(data);
                        // },
                        dataSrc: function ( json ) {
                            $.each( json.date_range, function( key, value ) {
                                $( table_table.column( key+2 ).header() ).text(value);
                            });
                            for (var i = json.date_range.length; i < 31; i++) {
                                table_table.column( i+2 ).visible( false );
                            }
                            return json.data;
                        }
                    },

                    columns: [
                        {
                            data: null,
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'employee_name',
                            name: 'employee_name',
                        },
                        {
                            data: 'day1',
                            name: 'day1',
                        },
                        {
                            data: 'day2',
                            name: 'day2',
                        },
                        {
                            data: 'day3',
                            name: 'day3',
                        },
                        {
                            data: 'day4',
                            name: 'day4',
                        },
                        {
                            data: 'day5',
                            name: 'day5',
                        },
                        {
                            data: 'day6',
                            name: 'day6',
                        },
                        {
                            data: 'day7',
                            name: 'day7',
                        },
                        {
                            data: 'day8',
                            name: 'day8',
                        },
                        {
                            data: 'day9',
                            name: 'day9',
                        },
                        {
                            data: 'day10',
                            name: 'day10',
                        },
                        {
                            data: 'day11',
                            name: 'day11',
                        },
                        {
                            data: 'day12',
                            name: 'day12',
                        },
                        {
                            data: 'day13',
                            name: 'day13',
                        },
                        {
                            data: 'day14',
                            name: 'day14',
                        },
                        {
                            data: 'day15',
                            name: 'day15',
                        },
                        {
                            data: 'day16',
                            name: 'day16',
                        },
                        {
                            data: 'day17',
                            name: 'day17',
                        },
                        {
                            data: 'day18',
                            name: 'day18',
                        },
                        {
                            data: 'day19',
                            name: 'day19',
                        },
                        {
                            data: 'day20',
                            name: 'day20',
                        },
                        {
                            data: 'day21',
                            name: 'day21',
                        },
                        {
                            data: 'day22',
                            name: 'day22',
                        },
                        {
                            data: 'day23',
                            name: 'day23',
                        },
                        {
                            data: 'day24',
                            name: 'day24',
                        },
                        {
                            data: 'day25',
                            name: 'day25',
                        },
                        {
                            data: 'day26',
                            name: 'day26',
                        },
                        {
                            data: 'day27',
                            name: 'day27',
                        },
                        {
                            data: 'day28',
                            name: 'day28',
                        },
                        {
                            data: 'day29',
                            name: 'day29',
                        },
                        {
                            data: 'day30',
                            name: 'day30',
                        },
                        {
                            data: 'day31',
                            name: 'day31',
                        },
                        {
                            data: 'worked_days',
                            name: 'worked_days',
                        },
                        {
                            data: 'total_worked_hours',
                            name: 'total_worked_hours',
                        },

                    ],


                    "order": [],
                    'language': {
                        'lengthMenu': '_MENU_ {{__("records per page")}}',
                        "info": '{{trans("Showing")}} _START_ - _END_ (_TOTAL_)',
                        "search": '{{trans("Search")}}',
                        'paginate': {
                            'previous': '{{trans("Previous")}}',
                            'next': '{{trans("Next")}}'
                        }
                    },
                    'columnDefs': [
                        {
                            "orderable": false,
                            'targets': [0]
                        },
                        {
                            'render': function (data, type, row, meta) {
                                if (type == 'display') {
                                    data = '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>';
                                }

                                return data;
                            },
                            'checkboxes': {
                                'selectRow': true,
                                'selectAllRender': '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>'
                            },
                            'targets': [0]
                        },
                    ],

                    'select': {style: 'multi', selector: 'td:first-child'},
                    'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]],
                    dom: '<"row"lfB>rtip',
                    buttons: [
                        {
                            extend: 'pdf',
                            orientation: 'landscape',
                            pageSize : 'LEGAL',
                            text: '<i title="export to pdf" class="fa fa-file-pdf"></i>',
                            exportOptions: {
                                columns: ':visible:Not(.not-exported)',
                                rows: ':visible'
                            },
                        },
                        {
                            extend: 'csv',
                            orientation: 'landscape',
                            pageSize : 'LEGAL',
                            text: '<i title="export to csv" class="fa fa-file-csv"></i>',
                            exportOptions: {
                                columns: ':visible:Not(.not-exported)',
                                rows: ':visible'
                            },
                        },
                        {
                            extend: 'print',
                            orientation: 'landscape',
                            pageSize : 'LEGAL',
                            text: '<i title="print" class="fa fa-print"></i>',
                            exportOptions: {
                                columns: ':visible:Not(.not-exported)',
                                rows: ':visible'
                            },
                        },
                    ],
                });
            }

            $('#submit_form').on('click', function (e) {
                e.preventDefault();

                var filter_company = $('#company_id').val();
                var filter_employee = $('#employee_id').val();
                var filter_month_year = $('#month_year').val();
                if (filter_company !== '' && filter_month_year !== '') {
                    $('#month_wise_attendance-table').DataTable().destroy();
                    fill_datatable(filter_company, filter_employee, filter_month_year);
                }
                else {
                    alert('{{__('Select at least one filter option')}}');
                }
            });
        });


        $('.dynamic').change(function() {
            if ($(this).val() !== '') {
                let value = $(this).val();
                let first_name = $(this).data('first_name');
                let last_name = $(this).data('last_name');
                let _token = $('input[name="_token"]').val();
                $.ajax({
                    url:"{{ route('dynamic_employee') }}",
                    method:"POST",
                    data:{ value:value, _token:_token, first_name:first_name,last_name:last_name},
                    success:function(result)
                    {
                        $('#employee_id').html(result);
                    }
                });
            }
        });
    })(jQuery);
</script>
@endsection