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

@section('title', 'Monthly Attendance List')

@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">Monthly Attendance List</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 Monthly Attendance</p>
                            <form method="GET" class="form-horizontal form-wizard-wrapper"
                                  action="{{ route('admin.attendance.monthly') }}">
                                <div class="row">
                                    <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">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">Status</label>
                                            <select name="status" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select Status</option>
                                                <option
                                                    value="Present" {{ request()->status == 'Present' ? 'Selected' : '' }}>
                                                    Present
                                                </option>
                                                <option
                                                    value="Absent" {{ request()->status == 'Absent' ? 'Selected' : '' }}>
                                                    Absent
                                                </option>
                                                <option
                                                    value="Late In" {{ request()->status == 'Late In' ? 'Selected' : '' }}>
                                                    Late In
                                                </option>
                                                <option
                                                    value="Half Day" {{ request()->status == 'Half Day' ? 'Selected' : '' }}>
                                                    Half Day
                                                </option>
                                            </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-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Designation</label>
                                            <select name="designation" id="designation" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select Designation</option>
                                                @foreach($designations as $designation)
                                                    <option {{ request()->designation == $designation->id ? 'Selected' : '' }} value="{{ $designation->id ?? '' }}">{{ $designation->name ?? '' }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-9">
                                        <div class="form-group">
                                            <a href="{{ route('admin.attendance.monthly') }}"
                                               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 style="width: 200px">Month</th>
                                        <th>ID</th>
                                        <th style="width: 200px">Name</th>
                                        <th>Department</th>
                                        <th>Designation</th>
                                        <th style="width: 200px">Reporting To</th>
                                        <th>Total Working Day</th>
                                        <th>Total Present</th>
                                        <th>Total Late In</th>
                                        <th>Total Half Day</th>
                                        <th>Total Absent</th>
                                        <th>Total Leave Taken</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($groups as $attendances)
                                        @php
                                            $leavesTaken = 0;
                                            if(isset($attendances->user) && isset($attendances->user->employee) && isset($attendances->user->employee->leaves)) {
                                               $leavesTaken =  $attendances->leavesTaken($attendances->user->employee->leaves) ?? 0 ;
                                            } else {
                                               $leavesTaken = 0;
                                            }
                                        @endphp

                                        @php $workingDays = 0; @endphp
                                        @if(isset($attendances->user)
                                            && isset($attendances->user->employee)
                                            && isset($attendances->user->employee->leaves))
                                            @php $workingDays =  $attendances->workingDays(request()->month ?? getDefaultMonth(), $holidayDays, $attendances->user->employee->leaves, $attendances->user->employee) ?? 0; @endphp
                                        @endif

                                        <tr>
                                            <td>{{ $loop->iteration ?? '' }}</td>
                                            <td>{{ (request()->month ?? getDefaultMonth()) ?? '' }}</td>
                                            <td>{{ $attendances->user->employee->emp_id ?? '' }}</td>
                                            <td>{{ $attendances->user->name ?? '' }}</td>
                                            <td>{{ $attendances->user->employee->department->name ?? '' }}</td>
                                            <td>{{ $attendances->user->employee->designation->name ?? '' }}</td>
                                            <td>
                                                @if(isset($attendances->user) && isset($attendances->user->employee->reportingTo))
                                                    {{ $attendances->user->employee->reportingTo->name }}
                                                @else
                                                    N/A
                                                @endif
                                            </td>
                                            <td>
                                                {{ $workingDays }}
                                            </td>
                                            <td>{{ isset($attendances->user->attendances) ? $attendances->user->attendances->where('status', 'Present')->count() : 0 }}</td>
                                            <td>{{ isset($attendances->user->attendances) ? $attendances->user->attendances->where('status', 'Late In')->count() : 0 }}</td>
                                            <td>{{ isset($attendances->user->attendances) ? $attendances->user->attendances->where('status', 'Half Day')->count() : 0}}</td>

                                            <td>{{ isset($attendances->user->attendances) ? $attendances->user->attendances->where('status', 'Absent')->count(): 0 }}</td>
                                            <td>
                                                {{ $leavesTaken }}
                                            </td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                </table>
                                <nav aria-label="d-flex justify-content-end" class="mt-3">
                                    <div>
                                        <div>{{ $groups->appends(request()->query())->links() }}  Total Data :{{ $groups->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>
        $("#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.name +'</option>>'
                        });
                        $("#designation").append(toAppend)
                    }

                })

            });
        });
    </script>
@endpush