@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"> {{__('Date Wise 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">


                                <div class="col-md-4 fv-row mb-5">
                                    <label class="required fs-5 fw-bold mb-2">{{__('Company')}}</label>
                                    <select name="company_id" id="company_id" data-control="select2" class="form-select form-select-solid  dynamic"
                                        data-live-search="true" data-live-search-style="contains" data-first_name="first_name"
                                        data-last_name="last_name" data-placeholder="Select Company" data-dependent="department_name" title='{{__('Selecting',['key'=>trans('Company')])}}'>
                                        <option value=""></option>
                                        @foreach ($companies as $item)
                                        <option value="{{$item->id}}">{{$item->company_name}}</option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-4 form-group">
                                    <label class="required fs-5 fw-bold mb-2">{{trans('Department')}}</label>
                                    <select name="department_id" id="department_id" data-dropdown-parent="#filter_form" data-control="select2"
                                        class="form-select form-select-solid department_wise_employees"
                                        data-live-search="true" data-live-search-style="contains"
                                        data-first_name="first_name" data-last_name="last_name" data-placeholder="Select Department"
                                        title="{{__('Selecting',['key'=>trans('Department')])}}...">
                                    </select>
                                </div>

                                <div class="col-md-4 form-group">
                                    <label class="required fs-5 fw-bold mb-2">{{trans('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="contains" data-placeholder="Select Employee"
                                        title='{{__('Selecting',['key'=>trans('Employee')])}}...'>
                                    </select>
                                </div>


                                <input type="hidden" name="employee_id" id="employee_id">

                                <div class="col-md-6 fv-row mb-5">
                                    <label class="required fs-5 fw-bold mb-2">{{__('Start Date')}}</label>
                                    <input type="text" name="start_date" id="start_date" class="form-control form-control-solid flatpickr-date"
                                        autocomplete="off" value="{{ date('m/Y') }}">
                                </div>

                                <div class="col-md-6 fv-row mb-5">
                                    <label class="required fs-5 fw-bold mb-2">{{__('End Date')}}</label>
                                    <input type="text" name="end_date" id="end_date" class="form-control form-control-solid flatpickr-date"
                                        autocomplete="off" value="{{ date('m/Y') }}">
                                </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('Search')}}
                                            </button>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>

                <div class="row">
                    <div class="col-lg-12">
                        <div class="table-responsive">
                            <table id="date_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>{{trans('Company')}}</th>
                                        <th>{{trans('Date')}}</th>
                                        <th>{{trans('status')}}</th>
                                        <th>{{__('Clock In')}}</th>
                                        <th>{{__('Clock Out')}}</th>
                                        <th>{{trans('Late')}}</th>
                                        <th>{{__('Early Leaving')}}</th>
                                        <th>{{trans('Overtime')}}</th>
                                        <th>{{__('Total Work')}}</th>
                                        <th>{{__('Total Rest')}}</th>
                                    </tr>
                                </thead>
                                <tfoot>
                                    <tr>
                                        <th></th>
                                        <th>{{trans('Total')}}</th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>



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

@endsection

@section('page_script')
<script nonce="{{ $cspNonce }}">
        (function($) {
            "use strict";
            $(document).ready(function () {
               // Initialize flatpickr for date inputs
               flatpickr(".flatpickr-date", {
                dateFormat: "Y-m-d"
            });
            });
            fill_datatable();

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

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

                    columns: [
                        {
                            data: null,
                            orderable: false,
                            searchable: false
                        },
                        {
                            data: 'employee_name',
                            name: 'employee_name'
                        },
                        {
                            data: 'company',
                            name: 'company'
                        },
                        {
                            data: 'attendance_date',
                            name: 'attendance_date',
                        },
                        {
                            data: 'attendance_status',
                            name: 'attendance_status'
                        },
                        {
                            data: 'clock_in',
                            name: 'clock_in',
                        },
                        {
                            data: 'clock_out',
                            name: 'clock_out',
                        },
                        {
                            data: 'time_late',
                            name: 'time_late',
                        },
                        {
                            data: 'early_leaving',
                            name: 'early_leaving',
                        },
                        {
                            data: 'overtime',
                            name: 'overtime',
                        },
                        {
                            data: 'total_work',
                            name: 'total_work'
                        },
                        {
                            data: 'total_rest',
                            name: 'total_rest'
                        },
                    ],


                    "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": 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"></i>',
                            exportOptions: {
                                columns: ':visible:Not(.not-exported)',
                                rows: ':visible'
                            },
                            footer:true
                        },
                        {
                            extend: 'csv',
                            text: '<i title="export to csv" class="fa fa-file-csv"></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
                        }
                    ],
                    drawCallback: function () {
                        var api = this.api();
                        for (let i = 7; i <12; i++) {
                            datatable_sum(api, i);
                        }

                    }
                });
                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();
                let employee_id = $('#employee_id').val();
                if (filter_start_date !== '' && filter_end_date !== '' && company_id !== '') {
                    $('#date_wise_attendance-table').DataTable().destroy();
                    fill_datatable(filter_start_date, filter_end_date, company_id, department_id, employee_id);
                } else {
                    alert('{{__('Select Both 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)
                        {
                            $('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) {

                            
                            $('#department_id').html(result);

                        }
                    });
                }
            });

            $('.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) {

                            $('#employee_id').html(result);

                        }
                    });
                }
            });

        })(jQuery);
    </script>
@endsection