@extends('admin.layout.master')
@section('content')
@section('custom_style')
{{-- <link href="{{asset('assets/css/custom_print.css')}}" rel="stylesheet"/> --}}

    <style>
       #printThis table th, #printThis table td{
            border: 1px solid black !important;
        }

    </style>
    {{-- <style> {!! $print['style_css'] !!} </style> --}}
@endsection
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header" style="padding: 0 10px">
                    <div class="card-header  d-flex flex-wrap align-items-center py-0">
                        <h4 class="col-8 pl-0">Month Wise Leave Summary</h4>
                        <div class="col-2 d-flex justify-content-end">
                        </div>
                        <div class="col-2 d-flex justify-content-end">
                            @include('payroll.includes.report_print_excel_button')
                        </div>
                    </div>
                    
                </div>
                <div class="card-body">

                    <form action="{{ route('leave.month_wise_leave_summary') }}" method="get">
                        <div class="row">
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Name/Code</label>
                                    <select class="form-control  name_code_live_search" name="employee_id" id="employee_id">
                                    </select>
                                </div>
                            </div>

                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>Department</label>
                                    <select name="department_id" id="department_id" class="form-control select_2">
                                        <option value="">--Select--</option>
                                        @if (!empty($departments))
                                            @foreach ($departments as $list)
                                                <option value="{{ $list->id }}">{{ $list->name }}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>Date From </label>
                                    <input type="text" class="datepicker form-control" name="date_from"  id="date_from" value="{{ request()->get('date_from') ? request()->get('date_from') : date('01-01-Y') }}">
                                </div>
                            </div>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>Date To</label>
                                    <input type="text" class="datepicker form-control" name="date_to" id="date_to"value="{{ request()->get('date_to') ? request()->get('date_to') : date('d-m-Y') }}">
                                </div>
                            </div>
                            <div class="col-md-1">
                                <div class="row mt-4">
                                    <button class='btn btn-primary btn-sm' name="filter">Filter</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    @if (count($leaves) > 0)
            <div class="row">
                <div class="col-lg-12">
                    <div class="card">
                        <div class="card-body" style="padding: 0 ">
                            <div class="col-lg-12 col-md-12 col-sm-12 " style="">

                                <div id="printThis" class="common_excel_export" style="">
                                    <style>
                                        @media print{
                                            .no-print{
                                                display: none;
                                            }
                                            @page{
                                                /* size: A4 portrait; */
                                                size: legal landscape;
                                                padding: auto;
                                                margin:4mm;
                                            }
                                            body {
                                                zoom:90%; /*or whatever percentage you need, play around with this number*/
                                                font-size:18px;
                                            }
                                            #printThis table th, #printThis table td{
                                                border: 1px solid black !important;
                                            }
                                        }
                                    </style>
                           
                                 {!! $print['head'] !!}
                                 @foreach ($leaves->chunk(12) as $chunkLeaves)
                                 
                                 @include('payroll.report_header',[
                                        'report_title'=>'Month Wise Laeve Summary',
                                        'department_info'=>$department,
                                        ])

                                    <table class="table table-bordered text-center" style="width:100%">
                                        <thead>
                                            <tr>
                                                <th>SL</th>
                                                <th>Code</th>
                                                <th>Name</th>
                                                <th>Designation</th>
                                                @foreach ($months as $month)
                                                    <th>{{ date("M",strtotime($month)) }}</th>
                                                @endforeach
                                                <th>Total</th>
                                                <th>Consumed</th>
                                                <th>Available</th>
                                                <th>Remarks</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $sl = 1;
                                            @endphp
                                        
                                                @foreach ($chunkLeaves as $emp_id => $employeeLeaves)
                                                    <tr>
                                                        <td>{{  $sl++ }}</td>
                                                        <td>{{ $employeeLeaves->first()->empBasicInfo->emp_code }}</td>
                                                        <td class="text-left" style="white-space: nowrap">{{ $employeeLeaves->first()->empBasicInfo->emp_name }}</td>
                                                        <td>{{ $employeeLeaves->first()->empBasicInfo->fetch_designation->name }} </td>
                                                        @foreach ($months as $month)
                                                            @php
                                                                $monthStart = carbon()->parse($month)->firstOfMonth()->format('Y-m-d');
                                                                $monthEnd = carbon()->parse($month)->endOfMonth()->format('Y-m-d');
                                                                $monthly_leaves = $employeeLeaves->where('start_date',">=", $monthStart)->where('end_date',"<=", $monthEnd)->sum('leave_count');
                                                            @endphp
                                                            <td>
                                                                {{ $monthly_leaves }}
                                                            </td>
                                                        @endforeach
                                                        <td>{{$leave_types->sum('leave_count')}}</td>
                                                        <td>{{$employeeLeaves->sum('leave_count')}}</td>
                                                        <td>{{$leave_types->sum('leave_count') - $employeeLeaves->sum('leave_count')}}</td>
                                                        <td></td>
                                                    </tr>
                                                @endforeach
                                        </tbody>
                                    </table>
                                    <div style="page-break-after: always;"></div>

                                 @endforeach
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </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 type="text/javascript">
     
        $(document).ready(function() {
            $('.select_2').select2();
        });

    </script>
@endsection