@extends('layouts.dashboard.superadminapp')

@section('title', 'Daily Employee Attendance & Leave Report')

@section('styles')
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.bootstrap5.min.css">
<style>
    .dt-buttons .btn {
        margin-right: 0.5rem !important;
        padding: 0.25rem 0.75rem !important;
        font-size: 0.95rem !important;
    }
    .bg-leave { background: #fffbe7 !important; }
</style>
@endsection

@section('content')
<div class="container-fluid bg-white">
    <div class="d-flex align-items-center justify-content-between mb-3">
        <h1 class="h5 mb-0 text-gray-800">
            <i class="fas fa-calendar-day me-2"></i> Daily Attendance & Leave Report
        </h1>
    </div>
    <form method="GET" class="row g-3 mb-3">
        <div class="col-md-3">
            <input type="date" name="date" class="form-control" value="{{ request('date', date('Y-m-d')) }}">
        </div>
        <div class="col-md-3">
            <select name="department" class="form-select">
                <option value="">All Departments</option>
                @foreach($departments as $dept)
                    <option value="{{ $dept }}" @if(request('department') == $dept) selected @endif>{{ $dept }}</option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3">
            <select name="employee_id" class="form-select">
                <option value="">All Employees</option>
                @foreach($employees as $emp)
                    <option value="{{ $emp->id }}" @if(request('employee_id') == $emp->id) selected @endif>
                        {{ $emp->employee_id }} - {{ $emp->name }}
                    </option>
                @endforeach
            </select>
        </div>
        <div class="col-md-3">
            <button class="btn btn-primary w-100"><i class="fas fa-filter"></i> Filter</button>
        </div>
    </form>
    <div class="card">
        <div class="card-body">
            <div class="table-responsive">
                <table id="dailyReportTable" class="table table-bordered table-hover text-dark w-100">
                    <thead class="table-light">
    <tr class="text-center align-middle">
        <th>Date</th> <!-- Added Date column -->
        <th>Employee ID</th>
        <th>Name</th>
        <th>Department</th>
        <th>Attendance Status</th>
        <th>Check In</th>
        <th>Check Out</th>
        <th>Working Hours</th>
        <th>Leave Type</th>
        <th>Leave Status</th>
    </tr>
</thead>
<tbody>
    @foreach ($employees as $emp)
        @php
            $attendance = $attendanceData->where('employee_id', $emp->employee_id)->first();
            $leave = $leaveData->where('employee_id', $emp->id)->first();
        @endphp
        <tr class="text-center align-middle {{ $leave ? 'bg-leave' : '' }}">
            <td>
                @if ($attendance && $attendance->date)
                    {{ \Carbon\Carbon::parse($attendance->date)->format('d-m-Y') }}
                @elseif(request('date'))
                    {{ \Carbon\Carbon::parse(request('date'))->format('d-m-Y') }}
                @else
                    -
                @endif
            </td>
            <td>{{ $emp->employee_id }}</td>
            <td>{{ $emp->name }}</td>
            <td>{{ $emp->department }}</td>
            <td>
                @if($attendance)
                    <span class="badge bg-success">Present</span>
                @elseif($leave)
                    <span class="badge bg-warning text-dark">On Leave</span>
                @else
                    <span class="badge bg-danger">Absent</span>
                @endif
            </td>
            <td>{{ $attendance->check_in ?? '-' }}</td>
            <td>{{ $attendance->check_out ?? '-' }}</td>
            <td>
                @if ($attendance && $attendance->check_in && $attendance->check_out)
                    @php
                        $in = \Carbon\Carbon::parse($attendance->check_in);
                        $out = \Carbon\Carbon::parse($attendance->check_out);
                        $mins = $in->diffInMinutes($out);
                        echo sprintf('%02d:%02d', intdiv($mins,60), $mins%60);
                    @endphp
                @else
                    -
                @endif
            </td>
            <td>
                @if($leave) {{ $leave->leave_type }} @else - @endif
            </td>
            <td>
                @if($leave)
                    <span class="badge bg-info text-dark">{{ $leave->status }}</span>
                @else
                    -
                @endif
            </td>
        </tr>
    @endforeach
</tbody>

                </table>
            </div>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script>
    $(document).ready(function() {
        $('#dailyReportTable').DataTable({
            dom: 'Bfrtip',
            buttons: [
                { extend: 'copy', className: 'btn btn-secondary btn-sm' },
                { extend: 'csv', className: 'btn btn-secondary btn-sm' },
                { extend: 'excel', className: 'btn btn-secondary btn-sm' },
                { extend: 'pdf', className: 'btn btn-secondary btn-sm' },
                { extend: 'print', className: 'btn btn-secondary btn-sm' }
            ],
            responsive: true,
            destroy: true,
        });
    });
</script>
@endsection