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

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

@push('css')
    <link href="{{ asset('assets/admin/plugins/select2/select2.min.css') }}" rel="stylesheet" type="text/css">
    <style>.table td {
            border-top: none;
        }

        .tabb {
            border: 1px solid #eaf0f7;
        }</style>
@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">Weekly 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 Weekly Attendance</p>
                            <form method="GET" class="form-horizontal form-wizard-wrapper"
                                  action="{{ route('admin.attendance.weekly') }}">
                                <div class="row">
                                    <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">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-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase">Area</label>
                                            <select name="area" id="area" class="select2 form-control mb-3 custom-select">
                                                <option selected disabled value="">Select area</option>
                                                @foreach($areas as $area)
                                                   <option {{ (request()->area == $area->id) ? 'Selected' : '' }} value="{{ $area->id ?? '' }}">{{ $area->name ?? '' }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-9">
                                        <div class="form-group">
                                            <a href="{{ route('admin.attendance.weekly') }}"
                                               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>#</th>
                                        <th>ID</th>
                                        <th>Emp ID</th>
                                        <th>Name</th>
                                        <th>Area Name</th>
                                        <th>Department</th>
                                        <th>Designation</th>
                                        <th>Required Time(H)</th>
                                        <th>Spent Time(H)</th>
                                        <th>Overtime</th>
                                        <th>Deficiency</th>
                                        <th>Leave Taken</th>
                                        <th>Achieved (%)</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($groups as $attendances)
                                        <tr>
                                            <td>
                                                <button class="btn btn-default btn-xs collapsed" data-toggle="collapse"
                                                        data-target="#collapse_{{ $loop->iteration }}"
                                                        aria-expanded="false">
                                                    <i data-feather="eye" class="mr-0 font-16"></i>
                                                </button>
                                            </td>
                                            <td>

                                                {{ $attendances->existing_id }}

                                            </td>
                                            <td>
                                                @if(isset($attendances->user))
                                                    {{ $attendances->user->employee->emp_id }}
                                                @else
                                                    N/A
                                                @endif
                                            </td>
                                            <td>
                                                @if(isset($attendances->user))
                                                    {{ $attendances->user->name }}
                                                @else
                                                    N/A
                                                @endif
                                            </td>
                                            <td>{{ $attendance->user->employee->zone_info->name ?? '' }}</td>
                                            <td>{{ $attendances->user->employee->department->name ?? '' }}</td>
                                            <td>{{ $attendances->user->employee->designation->name ?? '' }}</td>
                                            <td>
                                                @php
                                                    if(isset($attendances->user->employee->designation) && ($attendances->user->employee->designation->working_day == 6)){
                                                       $hours = 48;
                                                    } else{
                                                       $hours = 45;
                                                    }
                                                    echo $hours;
                                                @endphp
                                            </td>
                                            <td>
                                                @php
                                                    $spent_time = 0;
                                                    $attendanceDetails = [];
                                                @endphp
                                                @if(isset($allAttendance[$attendances->existing_id]))
                                                    @php
                                                        $spent_time = $allAttendance[$attendances->existing_id]->sum('spent_time');
                                                        $attendanceDetails = $allAttendance[$attendances->existing_id];
                                                    @endphp
                                                    {{ secondsToHoursMinutes($spent_time) }}
                                                @endif
                                            </td>
                                            <td>
                                                @if(isset($allAttendance[$attendances->existing_id]))
                                                    {{ secondsToHoursMinutes($spent_time - ($hours*60*60)) }}
                                                @endif
                                            </td>
                                            <td>
                                                @if(isset($allAttendance[$attendances->existing_id]))
                                                    {{ secondsToHoursMinutes(($hours*60*60) - $spent_time) }}
                                                @endif
                                            </td>
                                            <td>
                                                @if(isset($attendances->user) && isset($attendances->user->employee))
                                                    {{ $attendances->user->employee->leaves_sum_total_hours ?? 0 }}
                                                @else
                                                    0
                                                @endif
                                            </td>
                                            <td>
                                                @php
                                                    if(round((100/($hours*60*60))*$spent_time) > 95){
                                                        echo "<span class='badge badge-success1'>". round((100/($hours*60*60))*$spent_time)." %</span>";
                                                    } else if((round((100/($hours*60*60))*$spent_time) > 90) && (round((100/($hours*60*60))*$spent_time) < 96)){
                                                        echo "<span class='badge badge-warning1'>". round((100/($hours*60*60))*$spent_time)." %</span>";
                                                    }else{
                                                        echo "<span class='badge badge-danger1'>". round((100/($hours*60*60))*$spent_time)." %</span>";
                                                    }
                                                @endphp
                                            </td>
                                        </tr>
                                        <tr class="border-0">
                                            <td class="p-0" colspan="12">
                                                <div class="collapse" id="collapse_{{ $loop->iteration }}" style="">
                                                    <table class="table table-bordered mb-0">
                                                        <thead>
                                                        <tr class="bg-light">
                                                            @foreach($attendanceDetails as $attendance)
                                                                <th class="info">{{ $attendance->date->format('Y-m-d') }}</th>
                                                            @endforeach
                                                        </tr>
                                                        </thead>
                                                        <tbody>
                                                        <tr>
                                                            @foreach($attendanceDetails as $attendance)
                                                                <td class="success">
                                                                    <b>In Time
                                                                        :</b>{{ $attendance->first_in == null ? 'N/A' : $attendance->first_in->format('h:i A') }}
                                                                    <br>
                                                                    <b>Out Time
                                                                        :</b>{{ $attendance->last_out == null ? 'N/A' : $attendance->last_out->format('h:i A') }}
                                                                    <br>
                                                                    <b>Spent Working Hours
                                                                        :</b>{{ secondsToHoursMinutes($attendance->spent_time) }}
                                                                    <br>
                                                                    <b>Status :</b>{{ $attendance->status }}
                                                                </td>
                                                            @endforeach
                                                        </tr>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </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/select2/select2.min.js') }}"></script>
    <script>
        $(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