@extends('layout.main')
@section('content')

    <section>
        <div class="container-fluid">
            <div class="card mb-4">
                <div class="card-header with-border">
                    <h3 class="card-title text-center"> {{ __(' Attendance') }} </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">
                                    @if (Auth::user()->can('attendances'))
                                        <div class="col-md-6">
                                            <div class="form-group">
                                                <label>{{ trans('file.Company') }} *</label>
                                                <select name="company_id" id="company_id"
                                                    class="form-control selectpicker dynamic" required
                                                    data-live-search="true" data-live-search-style="contains"
                                                    data-first_name="first_name" data-last_name="last_name"
                                                    data-dependent="department_name"
                                                    title='{{ __('Selecting', ['key' => trans('file.Company')]) }}...'>
                                                    @php($i = 0)
                                                    @foreach ($companies as $company)
                                                        <option value="{{ $company->id }}" @if($i == 0) selected @endif>{{ $company->company_name }}
                                                        </option>
                                                    @php($i++)
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>

                                        <div class="col-md-6 form-group">
                                            <label>{{ trans('file.Department') }}</label>
                                            <select name="department_id" id="department_id"
                                                class="selectpicker form-control department_wise_employees"
                                                data-live-search="true" data-live-search-style="contains"
                                                data-first_name="first_name" data-last_name="last_name"
                                                title="{{ __('Selecting', ['key' => trans('file.Department')]) }}...">
                                            </select>
                                        </div>
                                    @else
                                        <input type="hidden" name="employee_id" id="employee_id"
                                            value="{{ Auth::user()->id }}"> {{-- users.id == employees.id  are same in this system --}}
                                    @endif

                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="start_date">{{ __('Start Date') }}</label>
                                            <input class="form-control month_year date" placeholder="Select Date"
                                                readonly="" id="start_date" name="start_date" type="text" required
                                                value="">
                                        </div>
                                    </div>


                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="end_date">{{ __('End Date') }}</label>
                                            <input class="form-control month_year date" placeholder="Select Date"
                                                readonly="" id="end_date" name="end_date" type="text" required
                                                value="">
                                        </div>
                                    </div>

                                </div>

                                <div class="row">
                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <div class="form-actions">
                                                <button type="submit" class="filtering btn btn-primary"><i
                                                        class="fa fa-search"></i> {{ trans('file.Search') }}
                                                </button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="table-responsive">
            <table id="attendance-table" class="table ">
                <thead>
                    <tr>
                        <th></th>
                        <th>{{ __('Employee') }}</th>
                        <th>{{ __('Attendance Date') }}</th>
                        <th>{{ __('In Time') }}</th>
                        <th>{{ __('Out Time') }}</th>
                        <th>{{ __('Total Work') }}</th>
                    </tr>
                </thead>
            </table>
        </div>

    </section>
    {{-- https://stackoverflow.com/questions/27997269/addition-of-hours-in-hhmm-using-jquery --}}
    {{-- first_date = 29.03.2021 && 30.03.2021 --}}

    <script type="text/javascript">
        (function($) {
            "use strict";
            $(document).ready(function() {

                let date = $('.date');
                date.datepicker({
                    format: '{{ env('Date_Format_JS') }}',
                    autoclose: true,
                    todayHighlight: true,
                    endDate: new Date(),
                });
                date.datepicker("setDate", "1");
            });

            fill_datatable();

            function fill_datatable(filter_start_date = '', filter_end_date = '', company_id = '', department_id = '') {

                let table_table = $('#attendance-table').DataTable({
                    responsive: true,
                    fixedHeader: {
                        header: true,
                    },
                    processing: true,
                    serverSide: true,
                    ajax: {
                        url: "{{ route('attendances.index') }}",
                        data: {
                            filter_start_date: filter_start_date,
                            filter_end_date: filter_end_date,
                            company_id: company_id,
                            department_id: department_id,
                            "_token": "{{ csrf_token() }}"
                        }
                    },

                    columns: [{
                            data: null,
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'employee_name',
                            name: 'employee_name'
                        },
                        {
                            data: 'attendance_date',
                            name: 'attendance_date',
                        },
                        {
                            data: 'in_time',
                            name: 'in_time'
                        },
                        {
                            data: 'out_time',
                            name: 'out_time'
                        },
                        {
                            data: 'total_work',
                            name: 'total_work'
                        },
                    ],


                    "order": [],
                    'language': {
                        'lengthMenu': '_MENU_ {{ __('records per page') }}',
                        "info": '{{ trans('file.Showing') }} _START_ - _END_ (_TOTAL_)',
                        "search": '{{ trans('file.Search') }}',
                        'paginate': {
                            'previous': '{{ trans('file.Previous') }}',
                            'next': '{{ trans('file.Next') }}'
                        }
                    },

                    'columnDefs': [{

                            "orderable": true,
                            // 'targets': [0, 10],
                        },
                        {
                            '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',
                            text: '<i title="export to pdf" class="fa fa-file-pdf-o"></i>',
                            exportOptions: {
                                columns: ':visible:Not(.not-exported)',
                                rows: ':visible'
                            },
                            footer: true
                        },
                        {
                            extend: 'csv',
                            text: '<i title="export to csv" class="fa fa-file-text-o"></i>',
                            exportOptions: {
                                columns: ':visible:Not(.not-exported)',
                                rows: ':visible'
                            },
                            footer: true
                        },
                        {
                            extend: 'print',
                            text: '<i title="print" class="fa fa-print"></i>',
                            exportOptions: {
                                columns: ':visible:Not(.not-exported)',
                                rows: ':visible'
                            },
                            footer: true
                        },
                        {
                            extend: 'colvis',
                            text: '<i title="column visibility" class="fa fa-eye"></i>',
                            columns: ':gt(0)'
                        },
                    ],
                });
                new $.fn.dataTable.FixedHeader(table_table);
            }

            function datatable_sum(dt_selector, columnNo) {
                var rows = dt_selector.rows().indexes();
                var rowsdataCol = dt_selector.cells(rows, columnNo, {
                    page: 'current'
                }).data();

                var totalMinutes = 0;
                for (let i = 0; i < rowsdataCol.length; i++) {
                    if (rowsdataCol[i] != "---") {
                        var timeArray = rowsdataCol[i].split(":");
                        totalMinutes += parseInt(timeArray[0] * 60) + parseInt(timeArray[1]);
                    }
                }
                var hours = Math.trunc(totalMinutes / 60);
                var minutes = totalMinutes % 60;

                var result = digitCheck(hours) + ':' + digitCheck(minutes);
                $(dt_selector.column(columnNo).footer()).html(result);
            }

            function digitCheck(data) {
                if (data < 10) {
                    var result = '0' + data;
                } else {
                    var result = data;
                }
                return result;
            }

            $('#filter_form').on('submit', function(e) {
                e.preventDefault();
                var filter_start_date = $('#start_date').val();
                var filter_end_date = $('#end_date').val();
                let company_id = $('#company_id').val();
                let department_id = $('#department_id').val();
                if (filter_start_date !== '' && filter_end_date === '' || filter_start_date === '' &&
                    filter_end_date !== '') {
                    alert('{{ __('Select Both filter option') }}');
                } else {
                    $('#attendance-table').DataTable().destroy();
                    fill_datatable(filter_start_date, filter_end_date, company_id, department_id);
                }
            });





            $('.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) {
                            $('select').selectpicker("destroy");
                            $('#employee_id').html(result);
                            $('select').selectpicker();

                        }
                    });
                }
            });

            $('.dynamic').change(function() {
                if ($(this).val() !== '') {
                    let value = $(this).val();
                    let dependent = $(this).data('dependent');
                    let _token = $('input[name="_token"]').val();
                    $.ajax({
                        url: "{{ route('dynamic_department') }}",
                        method: "POST",
                        data: {
                            value: value,
                            _token: _token,
                            dependent: dependent
                        },
                        success: function(result) {

                            $('select').selectpicker("destroy");
                            $('#department_id').html(result);
                            $('select').selectpicker();

                        }
                    });
                }
            });

            $('.department_wise_employees').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_department') }}",
                        method: "POST",
                        data: {
                            value: value,
                            _token: _token,
                            first_name: first_name,
                            last_name: last_name
                        },
                        success: function(result) {

                            $('select').selectpicker("destroy");
                            $('#employee_id').html(result);
                            $('select').selectpicker();

                        }
                    });
                }
            });

        })(jQuery);
    </script>

@endsection