@extends('admin.layout.master')
@section('content')
<style>
  
</style>

    <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>Monthly Duty 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();">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.roster_report.monthly_attendance_summary')}}" method="get">
                     <input type="hidden" name="search" value="true">

                        <div class='row'>
                            <div class='col-3'>
                                <div class="form-group">
                                    <label>Department</label>
                                    <select name="department_id" id="department_id" class="form-control select_2" required>
                                        <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>Date From </label>
                                    <input type="text" class="datepicker form-control input-sm"
                                           name="date_from" id="date_from" value="{{ request()->get('date_from') }}">
                                </div>
                            </div>
                            <div class='col-lg-2 col-md-2 col-sm-6 '>
                                <div class="form-group">
                                    <label>Date To</label>
                                    <input type="text" class="datepicker form-control input-sm"
                                           name="date_to" id="date_to" value="{{ request()->get('date_to') }}">   
                                </div>
                            </div>
                          
                            <div class='col-lg-1 col-md-1  col-sm-4  mt-4'>
                                <button class='btn btn-sm btn-danger'>Search</button>
                            </div>
                           
                        </div>
                    </form>
                    </div>
                </div>
            </div>
        </div>
       
    @if(count($attendances) >0)
    {{-- @dd($attendances) --}}
     <div id="divTableDataHolder" class="table2excel">
        <style>
            table th, table td{
               vertical-align: middle !important; 
           }
         
           @media print {
                .no-print{
                   display: none;
                }
               .pagebreak { page-break-after: always; } 
            
               @page{
                  /* size: 8.5in 5.5in; */
                   /* size: A4 portrait; */
                   size: legal landscape;
                  /* font-size: 10px; */
                  margin: 3mm !important;
                  padding: 0 !important;
              }

              body {
                  zoom:90%; 
                  /* font-family: serif;
                  font-size:17px;
                  font-weight: bold;
                  background-color: #FFFFFF !important; */
                
              }
           }
       </style>
        @php
            $i=1;
        @endphp
        @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" style="display: none"> Monthly Duty Summary </h4>
                        @include('payroll.report_header',['store_address'=>true,'store_email'=>true,'contact_info'=>true,'text_align'=>"text-center"]) 
                        
                        <h5 id="" class="text-center m-0">
                            Monthly Duty Summary 
                            ({{ date("d-m-Y", strtotime($date_from)) }} - {{date("d-m-Y", strtotime($date_to))}})
                        </h5>
                        <h5 class="text-center text-wrap m-0">@if(request('department_id')) {{ department(request('department_id'))->name }} @endif</h5>    

                    
                        <div class="col-lg-12 col-md-12 col-sm-12">
                            <table class="table table-bordered table-hover text-left" >
                                 
                                    <th class="text-left">Total Days : {{$total_days}}</th>
                                    <th class="text-left">Fridays : {{$total_fridays}}</th>
                                    <th class="text-left">Holidays  : {{$total_holidays}}</th>
                                    <th class="text-left">Working Days : {{$total_working_days}}</th>
                            </table>

                            <table class="table table-bordered table-hover text-center" >
                            <thead class="">
                                <tr>
                                    <th> #SL</th>
                                    <th> Code</th>
                                    <th> Name</th>
                                    <th> Designation</th>
                                    <th> Total Attendance</th>
                                    <th> Absents</th>
                                    <th> Leaves</th>
                                    <th> OT</th>
                                    <th> Lates</th>
                                    <th> Counted Late</th>
                                    <th> Early</th>
                                    <th> Counted Early</th>
                                    <th> Double</th>
                                </tr>
                                </thead>
                                <tbody>
                                   
                                    @foreach ($chunk_data as $data)
                                    {{-- @dd($data['attendances']->whereNotIn('status',['Weekend'])); --}}
                                        @php
                                            $late= $data['attendances']->whereNotNull('late')->count();
                                            $counted_late = $data['late_policy'] ? ($late >= $data['late_policy'] ? (round($late/$data['late_policy'])) : 0) : 0;
                                            $early_leave= $data['attendances']->whereNotNull('early_leave')->count();
                                        //    dd($late, $early_leave,$data['late_policy'],$data['early_policy'] );
                                            $counted_early =$data['early_policy'] ? ( $early_leave >= $data['early_policy'] ? (round($early_leave/$data['early_policy'])) : 0) : 0;
                                        @endphp
                                    <tr>
                                        <td>{{$i++}}</td>
                                        <td class="text-left" style="white-space: nowrap">
                                            {{$data['employee_info']->emp_code}}
                                        </td>
                                        <td class="text-left" style="white-space: nowrap">
                                            {{$data['employee_info']->emp_name}}
                                        </td>
                                        <td class="text-left" style="white-space: nowrap">
                                            {{$data['employee_info']->fetch_designation ? $data['employee_info']->fetch_designation->name : null}}
                                        </td>
                                        <td>{{$data['attendances']->whereNotIn('status',['Weekend','Holiday','Absent'])->count()}}</td>
                                        <td>{{$data['attendances']->where('status','Absent')->count()}}</td>

                                        <td>{{$data['attendances']->where('status','Leave')->count()}}</td>
                                        <td>{{$data['attendances']->sum('over_time_hours')}}</td>
                                       
                                        <td>{{$late}}</td>
                                        <td>{{$counted_late}}</td>
                                        <td>{{$early_leave}}</td>
                                        <td>{{$counted_early}}</td>
                                        <td>{{$data['attendances']->whereNotNull('double')->count()}}</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"> No Data Found</h4>
                </div>
           </div>
        </div>
    </div>
    @endif
     @endif

    @endsection
    @section('script')
    <script src="{{ asset('payroll_assets/payroll_common.js') }}"></script>
    <script>
           $(document).ready(function () {
                $('.select_2').select2();
            });
    
    </script>
    @endsection