@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">
    
    <!-- BEGIN: Page 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">
    <!-- END: Page CSS-->
    
@endpush 
@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">{{trans('master/master.canteen_attendance_monthly')}}</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="home">{{trans('common/common.home')}}</a>
                    </li>
                    <li class="breadcrumb-item active">{{trans('master/master.canteen_attendance_monthly')}}
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush

@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">
        <form >                
            <div class="content-header row">
                <div class="content-header-left col-md-9 col-12 mb-2">
                    <div class="row breadcrumbs-top">
                        <div class="col-12">
                            <h2 class="content-header-title float-start mb-0"></h2>
                            
                        </div>
                    </div>
                </div>
                <div class="content-header-right text-md-end col-md-3 col-12 d-md-block d-none">
                    <div class="mb-1 breadcrumb-right">
                        <div class="dropdown">
                            <button class="btn-icon btn btn-primary btn-round btn-sm dropdown-toggle" type="button"
                                data-bs-toggle="offcanvas" data-bs-target="#offcanvasEnd" aria-controls="offcanvasEnd"
                                type="button"><i data-feather='filter'></i></button>
                        </div>
                    </div>
                </div>
            </div>
            <div class="offcanvas-end-example">
                <div class="offcanvas offcanvas-end" tabindex="-1" id="offcanvasEnd" aria-labelledby="offcanvasEndLabel">
                <div class="offcanvas-header">
                    <h5 id="offcanvasEndLabel" class="offcanvas-title">{{trans('common/common.filter')}}</h5>
                    <button type="button" class="btn-close text-reset" data-bs-dismiss="offcanvas"
                        aria-label="Close"></button>
                </div>
                <div class="offcanvas-body my-auto mx-0 flex-grow-0">
                    <label class="form-label" for="date_range">Date range</label>
                    <input type="hidden" name="search" placeholder="Search" id="SearchFilter"
                    class="form-control" value="{{ request()->input('search') }}">
                    <input type="text" id="date_range" name="date_range" value="{{$dateRange}}" class="form-control daterangebg"> {!! $errors->first('date_range', '<label class="control-label error" for="date_range">:message</label>')!!}
                    @if(request()->input('type'))
                    <input type="hidden" name="type" value="{{request()->input('type')}}">
                    @endif
                    
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.location')}}</label>
                    <select class="form-control mb-2 select2" name="location_id[]" id="location_id" onchange="getsubLocations(this,'sublocations')" multiple>
                        @foreach($locations as $location)
                            <option value="{{$location->id}}" @if( ($locationIds) && in_array($location->id, $locationIds)) selected @endif>{{$location->name}}
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.sub_location')}}</label>
                    <select class="form-control mb-2 select2" name="sub_location_id[]" id="sub_location_id" multiple>
                        @foreach($subLocations as $subLocation)
                            <option value="{{$subLocation->id}}" @if( ($subLocationIds) && in_array($subLocation->id, $subLocationIds)) selected @endif>{{$subLocation->name}}
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.department')}}</label>
                    <select class="form-control mb-2 select2" name="department_id[]" id="department_id" multiple>
                        @foreach($departments as $department)
                            <option value="{{$department->id}}" @if( ($departmentIds) && in_array($department->id, $departmentIds)) selected @endif>
                                                {{$department->name}}</option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.sub_department')}}</label>
                    <select class="form-control mb-2 select2" name="sub_department_id[]" id="sub_department_id" multiple>
                        @foreach($subDepartments as $subDepartment)
                                            <option value="{{$subDepartment->id}}" @if( ($subDepartmentIds) && in_array($subDepartment->id, $subDepartmentIds)) selected @endif>{{$subDepartment->name}}
                                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.designation')}}</label>
                    <select class="form-control mb-2 select2" name="designation_id[]" id="designation_id" multiple>
                        @foreach($designations as $designation)
                                            <option value="{{$designation->id}}" @if( ($designationIds) && in_array($designation->id, $designationIds)) selected @endif>
                                                {{$designation->name}}
                                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.employees')}}</label>
                    <select class="form-control mb-2 select2" name="employee_id[]" id="employee_id" multiple>
                        @foreach($employees as $employee)
                            <option value="{{$employee->id}}" @if( ($employeeIds) && in_array($employee->id, $employeeIds)) selected @endif>
                                {{$employee->name}}({{$employee->employee_code}})
                            </option>
                        @endforeach
                    </select>
                    <label class="form-label mt-2" for="area_id">{{trans('master/master.is_defaulter')}}</label>
                    <select class="form-control mb-2 select2" name="is_defaulter" id="is-defaulter">
                        <option value="">Select </option>
                        <option value="Yes" @if( ($is_defaulter) && $is_defaulter == 'Yes') selected @endif>
                            Yes
                        </option>
                        <option value="No" @if( ($is_defaulter) && $is_defaulter == 'No') selected @endif>
                            No
                        </option>
                       
                    </select>
                    <button type="submit" class="btn btn-primary mt-2 mb-1 d-grid w-100 d-flex justify-content-center" data-bs-dismiss="offcanvas" aria-label="Close"><i
                            data-feather='search' class="me-2"></i> {{trans('common/common.search')}}</button>
                </div>
            </div>
        </form>
        <div class="col-12">
            <div class="card">
                <div class="card-header d-flex justify-content-end">
                    <a class="dt-button buttons-excel" target="_blank"
                    href="/{!! $alias !!}/canteen/monthly-report/export?{{ $queryString }}"
                        style="display: initial;"><button type="button"
                            class="btn btn-primary waves-effect waves-float waves-light">
                            <span> Excel</span>
                        </button></a>
                </div>
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-datatable">
                        <table class="dt-column-search table table-responsive tablenewheadfixed" id="organization">
                           <thead>
                            <th>S.No</th>          
                            <th class="text-nowrap">Employee code</th>                          
                            <th class="text-nowrap">Employee Name</th>
                            <th class="text-nowrap">Category</th>
                            <th class="text-nowrap">Department</th>
                            <th class="text-nowrap">Designation</th>
                             <th>Total</th>
                            @for ($d = 1; $d <= $daysInMonth; $d++)
                                @php
                                    $date = \Carbon\Carbon::create($year, $month, $d);
                                @endphp
                                <th class="text-nowrap">
                                    {{ $d }} 
                                    <small>({{ $date->format('D') }})</small>
                                </th>
                            @endfor
                           
                        </tr>
                    </thead>
                    <tbody>
                    @php
                     $grouped = collect($data->items())->groupBy('employee_id');
                    @endphp
                @foreach($grouped as $empId => $rows)
                    @php 
                        $emp = $rows->first(); 
                    @endphp
                    <tr>
                        <td>{{ $loop->iteration }}</td>  
                        <td class="text-nowrap">{{ $emp->employee->employee_code ?? '-' }}</td>                                      
                        <td class="text-nowrap"><strong>{{ $emp->employee->name ?? '-' }}</strong></td>
                        <td class="text-nowrap">{{ $emp->employee->category->name ?? '-' }}</td>
                        <td class="text-nowrap">{{ $emp->employee->department->name ?? '-' }}</td>
                        <td class="text-nowrap">{{ $emp->employee->designation->name ?? '-' }}</td>
                        @php $total = 0; @endphp
                        <td>
                            @for ($d = 1; $d <= $daysInMonth; $d++)
                                @php
                                    $date = sprintf('%04d-%02d-%02d', $year, $month, $d);
                                    $count = $rows
                                        ->firstWhere('attendance_date', $date)
                                        ->total_visit ?? 0;
                                    $total += $count;
                                @endphp
                            @endfor
                            <strong>{{ $total }}</strong>
                        </td>
                        @for ($d = 1; $d <= $daysInMonth; $d++)
                            @php
                                $date = sprintf('%04d-%02d-%02d', $year, $month, $d);
                                $count = $rows
                                    ->firstWhere('attendance_date', $date)
                                    ->total_visit ?? 0;
                            @endphp
                            <td class="{{ $count > 0 ? 'bg-light-success' : '' }}">
                                {{ $count }}
                            </td>
                        @endfor
                    </tr>
                @endforeach
                    </tbody>
                        </table>
                        {{ $data->appends(request()->except('page'))->links('pagination::bootstrap-5') }}
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!--/ Column Search -->
@endsection 


@push('footer-script') 
    <!-- BEGIN: Page Vendor JS-->
    <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/pickers/flatpickr/flatpickr.min.js"></script>
    <script src="/app-assets/js/scripts/ui/ui-feather.js"></script>

    <script type="text/javascript" src="/assets/js/moment.min.js"></script>
    <script type="text/javascript" src="/assets/js/daterangepicker.js"></script>
    <link rel="stylesheet" type="text/css" href="/assets/css/daterangepicker.css" />

    <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>
    <!-- END: Page Vendor JS-->
    <script src="/app-assets/js/scripts/forms/form-wizard.js"></script>


    <!-- BEGIN: Page JS-->
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <!-- END: Page JS-->    

    <script>
        $(function(){
            $('#organization').DataTable({
                "lengthChange": false,
                searching: false, paging: false, info: false
            });
        })

        $(function() {
            $('.select2').select2();

            $('input[name="date_range"]').daterangepicker({
                opens: 'left',
            });
        });
    </script>
@endpush