@extends('admin.layouts.app')
@section('title', 'Attendance Report')
@push('styles')
@endpush
@section('container')
    <!-- Page-Title -->
    <div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <div class="float-end">

                </div>
                <h4 class="page-title">Attendance Report</h4>
            </div>
            <!--end page-title-box-->
        </div>
        <!--end col-->
    </div>
    <!-- end page title end breadcrumb -->

    <div class="row">
        @if (session('success'))
            <div class="alert alert-info">
                {{ session('success') }}
            </div>
        @endif
        @if (session('error'))
            <div class="alert alert-danger">
                {{ session('error') }}
            </div>
        @endif
    </div>
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <form action="">
                        <div class="row">
                            <div class="col-md-3">
                                <div class="mb-3">
                                    <label class="col-form-label text-end">Employee</label>
                                    <div class=form-group">
                                       <select class="form-control" name="employee">
                                           <option value="">Select Option</option>
                                           @foreach($employees as $employee)
                                                <option value="{{ $employee->id }}" {{ request('employee') == $employee->id ? 'selected':'' }}>{{ $employee->name }}</option>
                                           @endforeach
                                       </select>
                                        @error('employee')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="mb-3">
                                    <label class="col-form-label text-end">Start Date</label>
                                    <div class=form-group">
                                        <input type="date" name="start_date" id="start_date" value="{{ old('start_date', request()->start_date??date('Y-m-d')) }}" class="form-control">
                                        @error('start_date')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="mb-3">
                                    <label class="col-form-label text-end">End Date</label>
                                    <div class="form-group">
                                        <input type="date" name="end_date" id="end_date"
                                            value="{{ old('end_date', request()->end_date??date('Y-m-d')) }}" class="form-control">
                                        @error('end_date')
                                            <p class="mt-1 text-danger">{{ $message }}</p>
                                        @enderror
                                    </div>
                                </div>

                            </div>
                            <div class="col-2">
                                <div class="text-start">
                                    <button class="btn btn-primary" style="margin-top: 35px;" type="submit">Search</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>


            </div>
            <!--end card-header-->
            @if(count($totalWorkingHours)>0)
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header with-border">
                                <button class="pull-right btn btn-primary" onclick="getprint('prinarea')">Print</button>
                            </div>
                        </div>
                    </div>
                </div>
                <div id="prinarea">
                    <div class="card-body">
                        <div class="card-header with-border text-center">
                            <h1 class="card-title" style="font-size: 25px;">Attendance Report</h1>
                            <p>Employee Name: {{ $selectEmployee->name }}</p>
                            <p style="margin-top: -20px;">Duration: {{ date('d-m-Y',strtotime(request('start_date'))) }} to {{ date('d-m-Y',strtotime(request('end_date'))) }}</p>
                        </div>
                        <div class="table-responsive">
                            <table id="table" class="table table-bordered">
                                <thead>
                                <tr>
                                    <th style="font-size: 15px !important;">Log Date</th>
                                    <th style="font-size: 15px !important;">Time In</th>
                                    <th style="font-size: 15px !important;">Time Out</th>
                                    <th style="font-size: 15px !important;">Work Hours</th>
                                    <th style="font-size: 15px !important;">Late Time</th>
                                    <th style="font-size: 15px !important;">Att</th>
                                    <th style="font-size: 15px !important;">Remarks</th>
                                </tr>
                                </thead>
                                <tbody>
                                @php
                                    $workingSeconds = 0;
                                    $lateTimeSeconds = 0;
                                    $totalAbsent = 0;
                                    $totalLate = 0;
                                    $totalEarlyOut = 0;
                                @endphp
                                @foreach($totalWorkingHours as $index => $attendance)
                                    @php
                                        //Sum Working Time
                                        if ($attendance->attendance != 'A' && $attendance->attendance != 'W.H' && $attendance->attendance != 'H' && $attendance->attendance != 'L.D'){
                                            //if ($attendance->type != 'full_movement'){
                                                $workingSeconds += \App\Helpers\Helper::timeToSeconds($attendance->working_hours);
                                                $lateTimeSeconds += \App\Helpers\Helper::timeToSeconds($attendance->lateTime);
                                            //}
                                        }
                                        if ($attendance->attendance == 'A'){
                                            $totalAbsent += 1;
                                        }
                                        if ($attendance->attendance == 'L' || $attendance->attendance == 'L.E'){
                                            $totalLate += 1;
                                        }
                                        if ($attendance->attendance == 'E' || $attendance->attendance == 'L.E'){
                                            $totalEarlyOut += 1;
                                        }
                                        // Determine the class for the row based on attendance status
                                        $rowClass = '';
                                        switch ($attendance->attendance) {
                                            case 'A':
                                                $rowClass = 'bg-danger text-white'; // Red background for absent
                                                break;
                                            case 'L':
                                                $rowClass = 'bg-warning'; // Yellow background for late
                                                break;
                                            case 'E':
                                                $rowClass = 'bg-warning'; // Yellow background for early checkout
                                                break;
                                             case 'L.E':
                                                  $rowClass = 'bg-warning'; // Yellow background for early checkout
                                                break;
                                            case 'P':
                                                $rowClass = 'bg-success text-white'; // Green background for present
                                                break;
                                            case 'H':
                                                $rowClass = 'bg-dark text-white'; // Green background for present
                                                break;
                                            case 'L.D':
                                                $rowClass = 'bg-dark text-white'; // Green background for present
                                                break;
                                            case 'W.H':
                                                $rowClass = 'bg-info text-white'; // Info background for Fridays
                                                break;
                                        }
                                    @endphp
                                    <tr class="{{ $rowClass }}">
                                        <td>{{ \Carbon\Carbon::parse($attendance->date)->format('d-m-Y') }}</td>
                                        @if($attendance->attendance == 'A')
                                            <td colspan="4" class="text-center">Absent Day</td>
                                            <td>{{ $attendance->attendance }}</td>
                                            <td>{{ $attendance->remarks }}</td>
                                        @elseif($attendance->attendance == 'W.H')
                                            <td colspan="4">This is a Friday (weekend)</td>
                                            <td>{{ $attendance->attendance }}</td>
                                            <td>{{ $attendance->remarks }}</td>
                                        @elseif($attendance->attendance == 'H')
                                            <td colspan="4">This is a Holiday</td>
                                            <td>{{ $attendance->attendance }}</td>
                                            <td>{{ $attendance->remarks }}</td>
                                        @elseif($attendance->attendance == 'L.D')
                                            <td colspan="4">This is a Leave Day</td>
                                            <td>{{ $attendance->attendance }}</td>
                                            <td>{{ $attendance->remarks }}</td>
                                        @else
                                            <td>
                                                {{ \Carbon\Carbon::parse($attendance->first_login)->format('H:i:s') }}
                                            </td>
                                            <td>{{ \Carbon\Carbon::parse($attendance->last_logout)->format('H:i:s') }}</td>
                                            <td>{{ $attendance->working_hours }}</td>
                                            <td>{{ $attendance->lateTime }}</td>
                                            <td>{{ $attendance->attendance }}</td>
                                            <td>{{ $attendance->remarks ?? '' }}</td>
                                        @endif
                                    </tr>
                                @endforeach
                                <tr>
                                    <th colspan="3" class="text-center">Total</th>
                                    <th>{{ \App\Helpers\Helper::secondsToTime($workingSeconds) }}</th>
                                    <th>{{ \App\Helpers\Helper::secondsToTime($lateTimeSeconds) }}</th>
                                    <th colspan="2"></th>
                                </tr>
                                </tbody>
                            </table>
                            <div class="row">
                                <div class="col-sm-8">
                                    <i><strong>Note: Total No of Late In {{ $totalLate }}, Early Out {{ $totalEarlyOut }}, Daily Movement 0 and Half Day Absent 0</strong></i>
                                </div>
                                <div class="col-sm-4 text-right">
                                    <i><strong>Total Days Absent {{ $totalAbsent }}</strong></i>
                                </div>
                            </div>
                            <i><strong>P: Present; A: Absent; A.H: Half Day Absent; L: Late; E: Early; L.E : Late & Early;Per: Personal; Offi:Official; H: Holiday; W.H: Weekly Holiday; NC: Not Calculated;</strong></i>
                        </div>
                    </div>
                </div>
            @endif
            <!--end card-body-->
        </div>
        <!--end card-->
    </div> <!-- end col -->


    </div> <!-- end row -->
@endsection
@push('scripts')
    <script>
        var APP_URL = '{!! url()->full()  !!}';
        function getprint(print) {

            $('body').html($('#'+print).html());
            window.print();
            window.location.replace(APP_URL)
        }
    </script>
@endpush