@extends('layouts.master')
@section('content')

    <div class="card">
        <div class="card-header bg-success text-white">
            TimeTable
        </div>
        <div class="card-body">
            <div class="table-responsive">
                <table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                    <thead>
                        <tr >
                            <th>Date</th>
                            @foreach ($employees as $employee)                            
                            <th>{{ $employee->name }}</th>
                            @endforeach
                            @php

                                $today = today();
                                $dates = [];
                                
                                for ($i = 1; $i < $today->daysInMonth + 1; ++$i) {
                                    $dates[] = \Carbon\Carbon::createFromDate($today->year, $today->month, $i)->format('Y-m-d');
                                }
                                
                            @endphp                            

                        </tr>
                    </thead>

                    <tbody>            
                            <input type="hidden" name="emp_id" value="{{ $employee->id }}">
                                                       
                            @foreach ($dates as $date)
                            
                           
                            <tr>
                                <td>{{ $date }}</td>
                                @foreach ($employees as $employee) 
                            @php                            
                                    $attd = \App\Models\Attendance::query()
                                            ->where('emp_id', $employee->id)                                            
                                            ->where('attendance_date', $date)
                                            ->first();
                            @endphp        
                                
                                <td>
                                    <table style="font-size:8px;" width="50px">
                                        @if(isset($attd))
                                            @if($attd->status=='1')
                                                <thead>
                                                    <th>IT:{{date( 'g:ia', strtotime($attd->in_time) )}}
                                                        OT:{{date( 'g:ia', strtotime($attd->out_time))}}
                                                        OvT:{{$attd->over_time}}
                                                        NH:{{$attd->net_hours}}
                                                    </th>
                                                </thead>                                               
                                                @else
                                                    <thead>
                                                    <th class="table-danger">Absent</th>                                            
                                                    </thead>
                                            @endif
                                            @else
                                            <thead>
                                                <th>NA</th>
                                            </thead>
                                            @endif
                                    </table>
                                </td>    
                                @endforeach
                            </tr>
                            
                            @endforeach
                    </tbody>


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