@extends('app-new')
@push('head-script')
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/responsive.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/components.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/vendors.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/extensions/toastr.min.css">

    <!-- BEGIN: Page CSS-->
    <link rel="stylesheet" type="text/css" href="/app-assets/css/core/menu/menu-types/vertical-menu.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/pickers/form-flat-pickr.css">
    <!-- END: Page CSS-->
@endpush

@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">{{ trans('master/master.overtime_report') }}</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="home">{{ trans('common/common.home') }}</a>
                    </li>
                    <li class="breadcrumb-item active">{{ trans('master/master.overtime_report') }}
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">
        <!-- Filters -->
        <form action="{!! route('overtime-masters.report-member', ['alias' => $alias]) !!}" method="POST">

            <input type="hidden" name="_token" value="{{ csrf_token() }}" />
            <input type="hidden" id="filename" value="overtime-report">
            <div class="content-header row">
                <div class="content-header-left col-md-9 col-12 mb-2">
                    <div class="row breadcrumbs-top">
                        <div class="col-12">
                            <h2 class="content-header-title float-start mb-0"></h2>

                        </div>
                    </div>
                </div>
                <div class="content-header-right text-md-end col-md-3 col-12 d-md-block d-none">
                    <div class="mb-1 breadcrumb-right">
                        <div class="dropdown">
                            <button class="btn-icon btn btn-primary btn-round btn-sm dropdown-toggle" type="button"
                                data-bs-toggle="offcanvas" data-bs-target="#offcanvasEnd" aria-controls="offcanvasEnd"
                                type="button"><i data-feather='filter'></i></button>
                        </div>
                    </div>
                </div>
            </div>
            <div class="offcanvas-end-example">
                <div class="offcanvas offcanvas-end" tabindex="-1" id="offcanvasEnd" aria-labelledby="offcanvasEndLabel">
                    <div class="offcanvas-header">
                        <h5 id="offcanvasEndLabel" class="offcanvas-title">{{ trans('common/common.filter') }}</h5>
                        <button type="button" class="btn-close text-reset" data-bs-dismiss="offcanvas"
                            aria-label="Close"></button>
                    </div>
                    <div class="offcanvas-body my-auto mx-0 flex-grow-0">

                        <label class="form-label" for="name">{{ trans('master/master.date_range') }}</label>
                        <input type="text" id="date_range" name="date_range" class="form-control"
                            value="{{ $date_range }}" />
                        
                @if(Auth::user()->hasTeam()) 
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.department') }}</label>
                        <select class="form-control mb-2 select2" name="department_id[]" id="department_id" multiple>
                            @foreach ($departments as $department)
                                <option value="{{ $department->id }}" @if (isset($departmentSelected) && in_array($department->id, $departmentSelected)) selected @endif>
                                    {{ $department->name }}
                                </option>
                            @endforeach
                        </select>

                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.designation') }}</label>
                        <select class="form-control mb-2 select2" name="designation_id[]" id="designation_id" multiple>
                            @foreach ($designations as $designation)
                                <option value="{{ $designation->id }}" @if (isset($designationSelected) && in_array($designation->id, $designationSelected)) selected @endif>
                                    {{ $designation->name }}
                                </option>
                            @endforeach
                        </select>

                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.employee_type') }}</label>
                        <select class="form-control mb-2 select2" name="employee_type" id="employee_type"
                            onchange="getEmployeeByType(this.value)">
                            <option value="">Select Type</option>
                            @foreach ($employeeTypes as $empType)
                                <option value="{{ $empType }}" @if ($empType == $employeeTypeSelected || old('employee_type') == $empType) selected @endif>
                                    {{ ucwords($empType) }}
                                </option>
                            @endforeach
                        </select>
                        <label class="form-label mt-2" for="area_id">{{ trans('master/master.employees') }}</label>
                        <select class="form-control mb-2 select2" name="employee_id[]" id="employee_id" multiple>
                            @foreach ($employees as $employee)
                                <option value="{{ $employee->id }}" @if (isset($employeeSelected) && in_array($employee->id, $employeeSelected)) selected @endif>
                                    {{ $employee->name }}({{ $employee->employee_code }})
                                </option>
                            @endforeach
                        </select>
                    @endif
                        <button type="submit" class="btn btn-primary mt-2 mb-1 d-grid w-100 d-flex justify-content-center"
                            data-bs-dismiss="offcanvas" aria-label="Close"><i data-feather='search' class="me-2"></i>
                            {{ trans('common/common.search') }}</button>
                    </div>
                </div>
            </div>
            <!-- // Filters // -->

        </form>
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-datatable">
                        <table class="dt-column-search table table-responsive" id="organization">
                            <thead>
                                <tr>
                                    <th scope="col" class="text-nowrap">{{ trans('common/common.id') }}</th>
                                    <th scope="col" class="text-nowrap">{{ trans('master/master.employee_name') }}
                                    </th>
                                    <th scope="col" class="text-nowrap">{{ trans('master/master.employee_code') }}e
                                    </th>
                                    <th scope="col" class="text-nowrap">{{ trans('master/master.employee_type') }}
                                    </th>
                                    <th scope="col" class="text-nowrap">
                                        {{ trans('attendance/admin.attendance_date') }}</th>
                                    <th scope="col" class="text-nowrap">{{ trans('attendance/admin.punch_in') }}</th>
                                    <th scope="col" class="text-nowrap">{{ trans('attendance/admin.punch_out') }}</th>
                                    <th scope="col" class="text-nowrap">{{ trans('attendance/admin.working_hours') }}
                                    </th>
                                    <th scope="col" class="text-nowrap">{{ trans('attendance/admin.working_norms') }}
                                    </th>
                                    <th scope="col" class="text-nowrap">{{ trans('master/master.approved_overtime') }}
                                    </th>
                                </tr>
                            </thead>
                            <tbody>
                                                                @foreach ($data as $key)
                                    @foreach ($key as $value)
                                        <tr>
                                            <td class="text-nowrap">{{ $count++ }}</td>
                                            <td class="text-nowrap">{{ $value['employee_name'] }}</td>
                                            <td class="text-nowrap">{{ $value['employee_code'] }}</td>
                                            <td class="text-nowrap">{{ ucfirst($value['employee_type']) }}</td>
                                            <td class="text-nowrap">{{ $value['attendance_date'] }}</td>
                                            <td class="text-nowrap">{{ $value['in_time'] }}</td>
                                            <td class="text-nowrap">{{ $value['out_time'] }}</td>
                                            <td class="text-nowrap">{{ $value['working_hours'] }}</td>
                                            <td class="text-nowrap">{{ $value['working_norms'] }}</td>
                                            <td class="text-nowrap">{{ @$value['approved_overtime'] }}</td>
                                        </tr>
                                    @endforeach
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

    </section>
    <!--/ Column Search -->
@endsection
@push('footer-script')
    <!-- BEGIN: Page Vendor JS-->
    <script src="/app-assets/vendors/js/tables/datatable/jquery.dataTables.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.bootstrap5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.responsive.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/responsive.bootstrap5.js"></script>
    <script src="/app-assets/vendors/js/pickers/flatpickr/flatpickr.min.js"></script>
    <script src="/app-assets/js/scripts/ui/ui-feather.js"></script>

    <script type="text/javascript" src="/assets/js/moment.min.js"></script>
    <script type="text/javascript" src="/assets/js/daterangepicker.js"></script>
    <link rel="stylesheet" type="text/css" href="/assets/css/daterangepicker.css" />

    <script src="/app-assets/vendors/js/tables/datatable/datatables.checkboxes.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/datatables.buttons.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/jszip.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/pdfmake.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/vfs_fonts.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.html5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.print.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.rowGroup.min.js"></script>
    <!-- END: Page Vendor JS-->
    <script src="/app-assets/vendors/js/extensions/toastr.min.js"></script>
    <script src="/app-assets/js/scripts/forms/form-wizard.js"></script>
    <!-- BEGIN: Page JS-->
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <!-- END: Page JS-->
    <script>
        $(document).ready(function() {
            callDt();
        });

        function callDt() {
            var dt_filter_table = $('.dt-column-search');

            if ($('body').attr('data-framework') === 'laravel') {
                assetPath = $('body').attr('data-asset-path');
            }

            if (dt_filter_table.length) {

                var dt_filter = dt_filter_table.DataTable({
                    dom: '<"card-header border-bottom p-1"<"head-label"><"dt-action-buttons text-end"B>><"d-flex justify-content-between align-items-center mx-0 row"<"col-sm-12 col-md-6"l><"col-sm-12 col-md-6"f>>t<"d-flex justify-content-between mx-0 row"<"col-sm-12 col-md-6"i><"col-sm-12 col-md-6"p>>',
                    orderCellsTop: true,
                    language: {
                        paginate: {
                            // remove previous & next text from pagination
                            previous: '&nbsp;',
                            next: '&nbsp;'
                        }
                    },


                    buttons: [{
                        extend: 'collection',
                        className: 'btn btn-outline-secondary dropdown-toggle',
                        text: feather.icons['share'].toSvg({
                            class: 'font-small-4 me-50'
                        }) + "{{ trans('common/common.export') }}",
                        buttons: [{
                                extend: 'print',
                                filename: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                title: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                text: feather.icons['printer'].toSvg({
                                    class: 'font-small-4 me-50'
                                }) + "{{ trans('common/common.print') }}",
                                className: 'dropdown-item',
                                exportOptions: {
                                    columns: Array.from(Array($("#organization th").length).keys())
                                },
                            },
                            {
                                extend: 'csv',
                                filename: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                title: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                text: feather.icons['file-text'].toSvg({
                                    class: 'font-small-4 me-50'
                                }) + "{{ trans('common/common.csv') }}",
                                className: 'dropdown-item',
                                exportOptions: {
                                    columns: Array.from(Array($("#organization th").length).keys())
                                },
                            },
                            {
                                extend: 'excel',
                                filename: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                title: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                text: feather.icons['file'].toSvg({
                                    class: 'font-small-4 me-50'
                                }) + "{{ trans('common/common.excel') }}",
                                className: 'dropdown-item',
                                exportOptions: {
                                    columns: Array.from(Array($("#organization th").length).keys())
                                },
                            },
                            {
                                extend: 'pdf',
                                filename: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                title: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                text: feather.icons['clipboard'].toSvg({
                                    class: 'font-small-4 me-50'
                                }) + "{{ trans('common/common.pdf') }}",
                                className: 'dropdown-item',
                                orientation: 'landscape',
                                exportOptions: {
                                    columns: Array.from(Array($("#organization th").length).keys())
                                },
                                customize: function(doc) {
                                    doc['footer'] = (function() {
                                        return {
                                            columns: [{
                                                alignment: 'center',
                                                text: ['Downloaded by: ', {
                                                        text: '{{ Auth::user()->name }}'
                                                    },
                                                    ' on {{ date('d-m-Y') }} at {{ date('g:i A') }}'
                                                ]
                                            }],
                                            margin: 10
                                        }
                                    });
                                },
                            },
                            {
                                extend: 'copy',
                                filename: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                title: '{{ Auth::user()->name }} - {{ date('d-m-Y H-i-s') }}',
                                text: feather.icons['copy'].toSvg({
                                    class: 'font-small-4 me-50'
                                }) + "{{ trans('common/common.copy') }}",
                                className: 'dropdown-item',
                                exportOptions: {
                                    columns: Array.from(Array($("#organization th").length).keys())
                                }
                            }
                        ],
                        init: function(api, node, config) {
                            $(node).removeClass('btn-secondary');
                            $(node).parent().removeClass('btn-group');
                            setTimeout(function() {
                                $(node).closest('.dt-buttons').removeClass('btn-group')
                                    .addClass('d-inline-flex');
                            }, 50);
                        }
                    }, ],

                });
            }

            $('div.head-label').html(
                '<h6 class="mb-0">{{ trans('master/master.overtime_report') }} {{ trans('master/master.listing') }}</h6>'
                );
        };

        $(function() {
            $('input[name="date_range"]').daterangepicker({
                timePicker: false,
                opens: 'left',
                startDate: moment().startOf('month').format('MM/DD/YYYY'),
                endDate: moment().endOf('month').format('MM/DD/YYYY'),
                locale: {
                    format: 'MM/DD/YYYY'
                }
            }, function(start, end, label) {
                console.log("A new date selection was made: " + start.startOf('month').format(
                    'YYYY-MM-DD') + ' to ' + end.endOf('month').format('YYYY-MM-DD'));
            });
        });

        function getEmployeeByType(employee_type) {
            var url = "{!! route('employees--type', ['alias' => $alias]) !!}?employee_type=" + employee_type;
            $.ajax({
                url: url,
                type: "GET",
                success: function(data) {
                    op = '';
                    for (var i = 0; i < data.length; i++) {
                        op += '<option value="' + data[i].id + '">' + data[i].name + '(' + data[i]
                            .employee_code + ')</option>';
                    }
                    $('#employee_id').html(op);
                }
            });

        }
    </script>
@endpush