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

@section('title', 'Individual 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">Individual 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 Individual Report</p>
                            <form method="GET" class="form-horizontal form-wizard-wrapper"
                                  action="{{ route('admin.attendance.individual_report') }}">
                                <div class="row">
                                    
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Employee ID</label>
                                            <select name="emp_id" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select Employee ID</option>
                                                @foreach($employees as $employee)
                                                    <option
                                                        value="{{ $employee->emp_id }}" {{ request()->emp_id == $employee->emp_id ? 'selected' : '' }}>
                                                        {{ $employee->emp_id }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Name</label>
                                            <input type="text" name="name" class="form-control">
                                        </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-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Designation</label>
                                            <select name="designation" id="designation" class="form-control mb-3 custom-select">
                                                
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">From Date</label>                                            
                                            <input type="text" class="form-control" name="startdate"
                                                   value="{{ request()->startdate }}" placeholder="From Date">
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">To Date</label>
                                            
                                            <input type="text" class="form-control" name="enddate"
                                                   value="{{ request()->enddate }}" placeholder="From Date">
                                        </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-9">
                                        <div class="form-group">
                                            <a href="{{ route('admin.attendance.individual_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>SL No.</th>
                                        <th>Em-ID</th>
                                        <th style="width: 200px">Name</th>
                                        <th>Department</th>
                                        <th>Designation</th>
                                        <th style="width: 200px">Reporting To</th>
                                        <th>Area</th>
                                        <th>Phone number</th>
                                        <th>Date of Joining</th>
                                        <th>Working Days</th>
                                        <th>Late (days)</th>
                                        <th>Absent (days)</th>
                                        <th>Late %</th>
                                        <th>Absent %</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($employees1 as $employee)

                                        <tr>
                                            <td>{{ ($employees1 ->currentpage()-1) * $employees1 ->perpage() + $loop->index + 1 }}</td>
                                            <td>{{ $employee['emp_id'] ?? '' }} </td>
                                            <td>{{ $employee['name'] ?? '' }} </td>
                                            <td>{{ $employee['department'] ?? '' }} </td>
                                            <td>{{ $employee['designation'] ?? '' }} </td>
                                            <td>{{ $employee['reporting_to'] ?? '' }} </td>
                                            <td>{{ $employee['area'] ?? '' }} </td>
                                            <td>{{ $employee['phone'] ?? '' }} </td>
                                            <td>{{ $employee['joining_date'] ?? '' }} </td>
                                            <td>{{ $employee['working_day'] ?? '' }} </td>
                                            <td>{{ $employee['late'] ?? '' }} </td>
                                            <td>{{ $employee['absent'] ?? '' }} </td>
                                            <td>{{ $employee['late_percent'] ?? '' }} </td>
                                            <td>{{ $employee['absent_percent'] ?? '' }} </td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                </table>
                                <nav aria-label="d-flex justify-content-end" class="mt-3">
                                    <div>
                                    
            
                                        <div> {{ $employees1->appends(request()->query())->links() }}  Total Data :{{ $employees1->total() }}</div>
                                    </div>
                                </nav>
                            </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: 'YYYY-MM-DD'});
            $('input[name="enddate"]').datetimepicker({format: 'YYYY-MM-DD'});
        });
    </script>
@endpush