@extends('admin.layout.master')
@section('content')

 
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header" style="padding: 0 10px">
                    <div class='row'>
                        <div class='col-md-10 text-left' pt-2>
                            <h3>{{__('obs.attendance')}} {{__('obs.summary')}}</h3>
                        </div>
                        @if(count($attendances) >0)
                        <div class='col-md-1 text-right'>
                          
                            <div class="form-group">
                                <button type="button" class="btn btn-sm btn-info text-right" onclick="PrintDiv();">{{__('obs.print')}}</button>
                            </div>
                         
                        </div>
                        <div class='col-md-1 text-right'>
                           
                            @include('payroll.includes.printAndExcel')
                           
                        </div>
                        @endif

                    </div>
                </div>
                <div class="card-body">
                   
                    <form action="{{route('payroll.hrm.attendance.attendance_summary')}}" method="get">
                     <input type="hidden" name="search" value="true">

                        <div class='row'>
                            <div class='col-lg-3 col-md-3  col-sm-6 '>
                                <div class="form-group">
                                    <label class="">{{__('obs.name')}}/{{__('obs.code')}}</label>
                                    <select class="form-control input-sm name_code_live_search" name="emp_code" id="emp_code">
                                        {{-- @foreach ($employes as $e)
                                        <option value="{{$e->id}}">{{$e->emp_name}}-{{$e->emp_code}}</option>
                                        @endforeach --}}
                                    </select>
                                 </div>
                            </div>
                       
                            <div class='col-lg-2 col-md-2 col-sm-6 '>
                                <div class="form-group">
                                    <label>{{__('obs.department')}}</label>
                                    <select name="department_id" id="department_id" class="form-control select_2">
                                        <option value="">--Select--</option>
                                        @if(!empty($department_lists))
                                            @foreach($department_lists as $depart_val)
                                                <option value="{{$depart_val->id}}" @if(request()->get('department_id') == $depart_val) {{'selected'}} @endif>{{$depart_val->name}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            
                            <div class='col-lg-2 col-md-2 col-sm-6 '>
                                <div class="form-group">
                                    <label>{{__('obs.date')}} {{__('obs.from')}} </label>
                                    <input type="text" class="datepicker form-control input-sm"
                                           name="date_from" id="date_from" value="{{ request()->get('date_from') ?? start_end_date()[0]}}">
                                </div>
                            </div>
                            <div class='col-lg-2 col-md-2 col-sm-6 '>
                                <div class="form-group">
                                    <label>{{__('obs.date')}} {{__('obs.to')}}</label>
                                    <input type="text" class="datepicker form-control input-sm"
                                           name="date_to" id="date_to" value="{{ request()->get('date_to') ?? start_end_date()[1]}}">   
                                </div>
                            </div>
                          
                            <div class='col-lg-1 col-md-1  col-sm-4  mt-4'>
                                <button class='btn btn-sm btn-danger'>{{__('obs.search')}}</button>
                            </div>
                           
                        </div>
                    </form>
                    </div>
                </div>
            </div>
        </div>
       
    @if(count($attendances) >0)
    {{-- @dd($attendances) --}}
     <div id="divTableDataHolder" class="table2excel">
        <style>
            @media print{
                    @page{
                        /* /* size: A4 portrait; */
                        size: legal landscape;
                        padding: auto;
                        margin:5px;
                       
                    }
                    body {
                        zoom:100%; /*or whatever percentage you need, play around with this number*/
                        font-family: serif;
                        font-size:17px;
                        font-weight: bold;
                        background-color: #FFFFFF !important;
                    
                    }
                }
        </style>

        @foreach (collect($attendances)->chunk(40) as $chunk_data)
        <div class="row" >
            <div class="col-lg-12">
                <div class="card">
                    <div class="card-body" style="padding: 0 ">
                        <h4 id="heading_name" class="text-center pt-2">{{__('obs.attendance')}} {{__('obs.summary')}} {{__('obs.for')}} {{__('obs.the')}} {{__('obs.date')}}  {{__('obs.of')}} ({{carbon()->parse($date_from)->format('d-m-Y')}} - {{carbon()->parse($date_to)->format('d-m-Y')}})</h4>

                            <div class=" row m-3">

                                {{-- <table class="table table-stripped table-bordered" style="width:100%">
                                    <tr>
                                        <th colspan="10" class="text-center">
                                            <h4>
                                                <span id="heading_name">{{$data['employee_info']->emp_name}}-{{$data['employee_info']->emp_code}}</span>
                                            </h4>
                                            <h4>Attendance Summary For The Date  Of ({{carbon()->parse($date_from)->format('d-m-Y')}} - {{carbon()->parse($date_to)->format('d-m-Y')}})</h4>
                                        </th>
                                    </tr>
                                   

                                </table> --}}
                              </div>
                    
                        <div class="col-lg-12 col-md-12 col-sm-12 " style="">
                            <table class="table table-bordered table-hover text-center" >
                            <thead class="">
                                <tr>
                                    <th> #{{__('obs.sl')}}</th>
                                    <th> {{__('obs.name')}}</th>
                                    <th> {{__('obs.days')}}</th>
                                    <th> {{__('obs.presents')}}</th>
                                    <th> {{__('obs.absents')}}</th>
                                    <th> {{__('obs.weekends')}}</th>
                                    <th> {{__('obs.holidays')}}</th>
                                    <th> {{__('obs.leaves')}}</th>
                                    <th> {{__('obs.tour')}}</th>
                                  
                                    <th> {{__('obs.lates')}}</th>
                                    <th> {{__('obs.not')}} {{__('obs.in')}}</th>
                                    <th> {{__('obs.early')}}</th>
                                    <th> {{__('obs.wh')}}</th>
                                    <th> {{__('obs.late')}} </th>
                                    <th> {{__('obs.ot')}}</th>
                                    <th> {{__('obs.ot')}} {{__('obs.day')}}</th>
                                </tr>
                                </thead>
                                <tbody>
                                    @php($i=1)
                                    @foreach ($chunk_data as $data)
                                    <tr>
                                        <td>{{$i++}}</td>
                                        <td class="text-start" style="white-space: nowrap">
                                            {{$data['employee_info']->emp_name}} -{{$data['employee_info']->emp_code}}
                                        </td>
                                        <td>{{count($data['attendances'])}}</td>
                                        <td>
                                            {{$data['attendances']->where('status','Present')->count() + $data['attendances']->where('status','Half Weekend')->count() }}
                                        </td>
                                        <td>{{$data['attendances']->where('status','Absent')->count()}}</td>
                                        <td>
                                            {{$data['attendances']->where('status','Weekend')->count() + $data['attendances']->where('status','Weekend Present')->count()}}
                                        </td>
                                        <td>{{$data['attendances']->where('status','holiday')->count()}}</td>
                                        <td>{{$data['attendances']->where('status','Leave')->count()}}</td>
                                        <td>{{$data['attendances']->where('status','Tour Leave')->count()}}</td>

                                        
                                        <td>{{$data['attendances']->whereNotNull('late')->whereNull('late_approval_status')->count()}}</td>
                                        <td>{{$data['attendances']->whereNull('in_time')->whereNotNull('out_time')->count()}}</td>
                                        <td>{{$data['attendances']->whereNotNull('early_leave')->count()}}</td>
                                        <td>{{$data['attendances']->sum('working_hours')}} </td>
                                        
                                        <td>{{$data['attendances']->sum('late_hours')}} </td>
                                        <td>{{$data['attendances']->sum('over_time_hours')}}</td>
                                        <td>{{$data['attendances']->sum('ot_day')}}</td>
                                    </tr>
                                    @endforeach

                                    </tbody>
                            </table>
                        </div>                         
                        
                    </div>
                    </div>
                </div>
            </div>
            <div style="page-break-after: always;"></div>
            @endforeach
        </div>
     @else
     
     @if(request()->get('search') !=null)
     <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-body">
                    <h4 class="text-center"> {{__('obs.no')}} {{__('obs.data')}} {{__('obs.found')}}</h4>
                </div>
           </div>
        </div>
    </div>
    @endif
@endif
@endsection

@section('script')
    <script src="{{ asset('payroll_assets/payroll_common.js') }}"></script>
    <script src="{{ asset('payroll_assets/payroll_print.js') }}"></script>

<script>
    $(document).ready(function() {
        $('.select_2').select2();
    });
    function PrintDiv() {
        var divToPrint = document.getElementById('divTableDataHolder');
        var popupWin = window.open('', '_blank', 'width=900,height=900');
        popupWin.document.open();
        popupWin.document.write('<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><link href="{{asset('/')}}assets/css/bootstrap.min.css" rel="stylesheet" media="screen,print"></head><body onload="window.print()">' + divToPrint.innerHTML + '</html>');
        popupWin.document.write('<style>\n' +
            '.table thead tr th,.table tr td{\n' +
            '        border: 1px solid black !important;\n' +
            '        text-align: center !important;\n' +
            '    }\n' +
            '.value{\n' +
            '        font-size: 12px !important;\n' +
            '    }\n' +
            '.line_height{\n' +
            '        line-height: 1.00 !important;\n' +
            '        font-size: 16px !important;\n' +
            '    }\n' +
            '.table_line_height{\n' +
            '        line-height: 1.0 !important;\n' +
            '    }\n' +
            '.border_remove{\n' +
            '       border-top: 1px solid white !important;\n' +
            '       border-left: 1px solid white !important;\n' +
            '       border-right: 1px solid white !important;\n' +
            '    }\n' +
            '.display_none{\n' +
            '       display: none !important;\n' +
            '    }\n' +
            '</style>');
        popupWin.document.close();
    }
 
 
</script>
@endsection