@extends('Training::backend.layouts.app')

@section('title', 'Average Attendance Report')

@push('css')
    <link href="{{ asset('assets/admin/plugins/datatables/dataTables.bootstrap4.min.css') }}" rel="stylesheet"
          type="text/css"/>
    <link href="{{ asset('assets/admin/plugins/select2/select2.min.css') }}" rel="stylesheet" type="text/css">
@endpush

@section('content')
    <!-- Page Content-->
    <div class="page-content-tab">
        <div class="container-fluid">
            <!-- Page-Title -->
            <div class="row">
                <div class="col-sm-12">
                    <div class="page-title-box">
                        <h4 class="page-title">Average Attendance report</h4>
                    </div>
                    <!--end page-title-box-->
                </div>
                <!--end col-->
            </div>
            <!--end row-->
            <!-- end page title end breadcrumb -->
            <div class="row">
                <div class="col-sm-12">

                    @if(session('success'))
                        <div id="mydiv" class="alert alert-success mt-3 text-center">
                            {{ session('success') }}
                        </div>
                    @endif

                    @if(session('error'))
                        <div id="mydiv" class="alert alert-danger mt-3 text-center">
                            {{ session('error') }}
                        </div>
                    @endif

                    <div class="card">
                        <div class="card-body">
                            <h4 class="mt-0 mb-0 header-title">Filter</h4>
                            <p class="text-muted mb-3">Search Report</p>
                            <form method="GET" class="form-horizontal form-wizard-wrapper"
                                  action="{{ route('admin.attendance.average_report') }}">
                                <div class="row">
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Filter</label>
                                            <select name="duaration" class="form-control mb-3 custom-select">
                                                <option selected disabled value="">Select</option>
                                                <option value="{{ Carbon\Carbon::now()->format('Y-m-d'). ' - ' . Carbon\Carbon::now()->format('Y-m-d')}}">Daily</option>
                                                <option value="{{ $weeks[0] }}">Weekly</option>
                                                <option value="{{ $months[0] }}">Monthly</option>
                                            </select>
                                        </div>
                                    </div>
                                    {{--<div class="col-md-2">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Daily</label>
                                            <select name="emp_id" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select</option>
                                                <option value="{{ Carbon\Carbon::now()->format('Y-m-d')}}">{{ Carbon\Carbon::now()->format('Y-m-d')}}</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Week</label>
                                            <select name="week" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select Week</option>
                                                @foreach($weeks as $week)
                                                    @if(strpos($week, "-") > 0)
                                                        <option
                                                            value="{{ $week }}" {{ $week == (request()->week ?? getDefaultWeek()) ? 'selected' : '' }}>{{ $week }}</option>
                                                    @endif
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Month</label>
                                            <select name="month" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select Month</option>
                                                @foreach($months as $month)
                                                    @if(strpos($month, "-") > 0)
                                                    <option value="{{ $month }}" {{ $month == (request()->month ?? getDefaultMonth()) ? 'selected' : '' }}>{{ $month }}</option>
                                                    @endif
                                                @endforeach
                                            </select>
                                        </div>
                                    </div> --}}  
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Zone</label>
                                            <select name="zone_id" id="zone_id" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select Zone</option>                                                
                                                @foreach($zones as $zone)
                                                    <option {{ request()->zone_id == $zone->id ? 'Selected' : '' }} value="{{ $zone->id ?? '' }}">{{ $zone->name  ?? '' }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>                                
                                    {{--<div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Department</label>
                                            <select name="department" id="department" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select Department</option>
                                                
                                                @foreach($departments as $department)
                                                    <option {{ request()->department == $department->id ? 'Selected' : '' }} value="{{ $department->id ?? '' }}">{{ $department->name  ?? '' }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div> --}}                                   
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <a href="{{ route('admin.attendance.average_report') }}"
                                               class="btn btn-danger waves-effect waves-light mt-4 mr-2">
                                                <i class="ti-reload mr-2"></i>Clear
                                            </a>
                                            <button type="submit" class="btn btn-primary waves-effect waves-light mt-4">
                                                <i class="ti-search mr-2"></i>Filter Now
                                            </button>
                                            <!-- <button id="csvDownload" type="submit" name="download" value="1"
                                                    class="btn btn-success waves-effect waves-light mt-4 mr-2"><i
                                                    class="fas fa-download"></i> Download as Excel
                                            </button> -->
                                        </div>
                                    </div>
                                </div>
                            </form>
                            <!--end form-->
                        </div>
                        <!--end card-body-->
                    </div>
                    <!--end card-->
                </div>
                <!--end col-->
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-lg-6 col-sm-6">
                                    <h4 class="mt-0 mb-0 header-title">Lists </h4>
                                </div>
                            </div>
                            <!-- end row -->

                            <div class="table-responsive">
                                <table class="table table-bordered">
                                    <thead>
                                        <tr>
                                            <th>Zone</th>                                           
                                            <th>Active Employee</th>
                                            <th>Avg Present</th>
                                            <th>Avg Late</th>
                                            <th>Avg Absent</th>                                       
                                        </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($data as $employee)
                                        <tr>                                           
                                            <td>{{ $employee['zone'] ?? '' }} </td>
                                            <td>{{ $employee['active_employee'] ?? '' }} </td>
                                            <td>{{ $employee['avg_present'] ?? '' }} </td>
                                            <td>{{ $employee['avg_late'] ?? '' }} </td>
                                            <td>{{ $employee['avg_absent'] ?? '' }} </td>
                                            
                                        </tr>
                                    @endforeach
                                    </tbody>
                                </table>
                                
                            </div>
                        </div><!--end card-body-->
                    </div><!--end card-->
                </div><!--end col-->
            </div><!--end row-->
        </div>
        <!-- footer -->
    @include('admin.sections.footer')
    <!--end footer-->
    </div>
    <!-- end page content -->
@endsection

@push('js')
    <script src="{{ asset('assets/admin/plugins/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('assets/admin/plugins/datatables/dataTables.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('assets/admin/plugins/select2/select2.min.js') }}"></script>
    <script src="{{ asset('assets/admin/plugins/moment/moment.js') }}"></script>
    <script src="{{ asset('assets/admin/plugins/bootstrap-datetimepicker/bootstrap-datetimepicker.min.js') }}"></script>
    <script>
        $("#datatable").DataTable({
            "scrollX": true,
            "language": {
                "emptyTable": "No attendance found"
            }
        });

        $(document).ready(function () {
            $(".select2").select2();
            $('#department').on('change', function () {
                var selectVal = $("#department option:selected").val();

                $('#designation').empty();
                $.ajax({
                    type: "POST",
                    url: '{{ route('employeeDesignation.designationByDepartment') }}',
                    data: {
                        "_token": "{{ csrf_token() }}",
                        val: selectVal
                        },
                    success: function(result) {
                        var obj = $.parseJSON(result);
                        var toAppend='<option value="null">Select Designation</option>>'
                        $.each(obj, function (key, value) {
                                toAppend+='<option value="'+value.id+'">'+ value.location+'->'+value.name +'</option>>'
                        });
                        $("#designation").append(toAppend)
                    }

                })

            });

            $('input[name="startdate"]').datetimepicker({format: 'DD/MM/YYYY'});
            $('input[name="enddate"]').datetimepicker({format: 'DD/MM/YYYY'});
        });
    </script>
@endpush