@extends('app-new')

@push('head-script')
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/responsive.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/components.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/vendors.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/extensions/toastr.min.css">
    <link rel="stylesheet" href="/assets/plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.css">
    <link rel="stylesheet" href="/assets/css/daterangepicker.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/form-wizard.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/core/menu/menu-types/vertical-menu.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/pickers/form-flat-pickr.css">
@endpush

@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">Single Punch Report</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="/{!! $alias !!}/home">Home</a></li>
                    <li class="breadcrumb-item active">Single Punch Report</li>
                </ol>
            </div>
        </div>
    </div>
@endpush

@section('content')
<section id="dashboard-ecommerce">
    <!-- Filter Form -->
    <form method="get" action="/{!! $alias !!}/attendance-report/single-punch-report" class="loder-disabled">
        <div class="content-header row">
            <div class="content-header-left col-md-9 col-12 mt-2 mb-2">
                <div class="row breadcrumbs-top">
                    <div class="col-md-2">
                        <label class="form-label" for="month">{{ trans('admin/template.month') }}</label>
                        <select class="form-control mb-2 select2" name="month" id="month">
                            @foreach ($months as $key => $val)
                                <option value="{{ $key }}" @if ($key == $month) selected @endif>{{ $val }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-2">
                        <label class="form-label" for="year">{{ trans('admin/template.year') }}</label>
                        <select class="form-control mb-2 select2" name="year" id="year">
                            @foreach ($years as $val)
                                <option value="{{ $val }}" @if ($val == $year) selected @endif>{{ $val }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3">
                        <label class="form-label" for="location_id">Location</label>
                        <select name="location_id" class="form-control select2" data-allow-clear="true" data-placeholder="Select Value">
                            <option value=""></option>
                            @foreach ($locations as $location)
                                <option value="{{ $location->id }}" {{ request('location_id') == $location->id ? 'selected' : '' }}>
                                    {{ $location->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    
                    <div class="col-md-5 d-flex align-items-end justify-content-end gap-1" style="min-height: 58px;">
                        <button type="submit" class="btn btn-secondary" name="filter" value="1">
                            Filter
                        </button>
                        <button type="submit" class="btn btn-primary" name="export" value="1">
                            Export
                        </button>
                    </div>
                    
                    
                </div>
            </div>
        </div>
    </form>
    @if($attendanceSummary->isEmpty())
    <div class="col-xs-12">
        <div class="white-box text-center" style="padding: 40px;">
            <img src="/assets/img/no_found.jpg" alt="No Data Found" style="max-width: 200px; border-radius: 20px; margin-bottom: 0px;">
            <h5>{{ \Carbon\Carbon::createFromDate($year, $month)->format('F Y') }}</h5>
        </div>
    </div>
    @else
    <div class="col-xs-12">
        <div class="white-box">
            <div class="table-responsive"> <!-- KEEP this for small screens -->
                <div class="row">
                    <div class="col-md-12">
                        <table class="table table-bordered" id="organization">
                            <thead class="table-light">
                                <tr>
                                    <th></th>
                                    <th></th>
                                    <th colspan="31" style="text-align: center">
                                        Month of {{ \Carbon\Carbon::createFromDate($year, $month)->format('F Y') }}
                                    </th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                </tr>
                                <tr>
                                    <th>Employee Name</th>
                                    <th>Designation</th>
                                    <th>Location</th>
                                    @php
                                        // Safely fetch the days in the month
                                        $firstEmployeeAttendance = $attendanceSummary->first();
                                        $daysInMonth = $firstEmployeeAttendance && $firstEmployeeAttendance->first()
                                            ? $firstEmployeeAttendance->first()->daysInMonth
                                            : 0;
                                    @endphp

                                    @for($day = 1; $day <= $daysInMonth; $day++)
                                        <th>{{ $day }}</th>
                                    @endfor
                                    <th>Present Days</th>
                                    <th>Absent Days</th>
                                    <th>Week Offs</th>
                                    <th>Paid Days</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($attendanceSummary as $employeeAttendances)
                                    @php
                                        $employee = $employeeAttendances->first()->employee;
                                    @endphp
                                    <tr>
                                        <td>{{ $employee->name ?? '-' }}</td>
                                        <td>{{ $employee->designation->name ?? '-' }}</td>
                                        <td>{{ $employee->locations->first()->name ?? '-' }}</td>

                                        @php $statuses = []; @endphp

                                        @for($day = 1; $day <= $daysInMonth; $day++)
                                            @php
                                            $date = \Carbon\Carbon::createFromDate($year, $month, $day)->toDateString();
                                            $attendance = $employeeAttendances->where('attendance_date', $date)->first();
                                            @endphp
                                        <td>
                                            @php
                                                if ($attendance) {
                                                    if (
                                                    !empty($attendance->in_time) ||
                                                    !empty($attendance->out_time)
                                                ) {
                                                        $status = 'P'; // Present
                                                    } elseif ($attendance->attendance_type === 'week-off') {
                                                        $status = 'W'; // Week-off
                                                    } elseif ($attendance->attendance_type === 'holiday') {
                                                        $status = 'H'; // Holiday
                                                    } else {
                                                        $status = 'A'; // Absent
                                                    }
                                                } else {
                                                    $status = '-'; // No data
                                                }

                                                $statuses[] = $status;
                                            @endphp

                                            {{ $status }}
                                        </td>
                                        @endfor

                                        @php
                                        // Calculate present and absent days
                                        $presentDays = collect($statuses)->filter(fn($status) => $status === 'P')->count();
                                        $absentDays = collect($statuses)->filter(fn($status) => $status === 'A')->count();
                                        $weekOffs = collect($statuses)->filter(fn($status) => $status === 'W')->count();
                                        $paidDays = $presentDays + $weekOffs;
                                        @endphp
                        
                                        <td>{{ $presentDays }}</td>
                                        <td>{{ $absentDays }}</td>
                                        <td>{{ $weekOffs }}</td>
                                        <td>{{ $paidDays }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                        {{ $attendanceSummary->links('pagination::bootstrap-4') }}
                    </div>
                </div>
            </div>
        </div>
    </div>
    @endif

</section>
@endsection

@push('footer-script')
    <script src="/app-assets/vendors/js/tables/datatable/jquery.dataTables.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.bootstrap5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.responsive.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/responsive.bootstrap5.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/datatables.checkboxes.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/datatables.buttons.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/jszip.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/pdfmake.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/vfs_fonts.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.html5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.print.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.rowGroup.min.js"></script>
    <script src="/app-assets/vendors/js/extensions/toastr.min.js"></script>
    <script src="/app-assets/js/scripts/forms/form-wizard.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <script src="/assets/js/moment.min.js"></script>
    <script src="/assets/js/daterangepicker.js"></script>
    <script src="/assets/plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
    <script src="/assets/plugins/bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>

    <script>
        $(document).ready(function() {
            $('#attendanceTable').DataTable({
                responsive: true,
                paging: true,
                ordering: false,
                searching: true,
                dom: 'Bfrtip',
                buttons: ['excel', 'print'],
            });
        });

        $(window).on('load', function() {
            if (feather) {
                feather.replace({
                    width: 14,
                    height: 14
                });
            }
        });
    </script>
    <script>
        function submitForm(type) {
            const form = event.target.closest('form');
            const input = document.createElement('input');
            input.type = 'hidden';
            input.name = type;
            input.value = 1;
            form.appendChild(input);
        }
    </script>
@endpush