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

    </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 card-header-s d-flex flex-wrap align-items-center">
                        <h4 class="col-8 pl-0">Employee Leave Balance</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('payroll.hrm.leave.leave_balance') }}" 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 $department)
                                                <option value="{{ $department->id }}">{{ $department->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 input-sm" name="date_from"
                                        id="date_from"
                                        value="{{ request()->get('date_from') ? request()->get('date_from') : date('01-m-Y') }}">
                                </div>
                            </div>
                            <div class='col-md-2'>
                                <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') ? 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'>Submit</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    @if (count($leaves) > 0)
        <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:3mm;
                               
                            }
                            body {
                                zoom:70%; /*or whatever percentage you need, play around with this number*/
                                font-family: serif;
                                font-size:17px;
                                font-weight: bold;
                            
                            }
                        }
                </style>

             {!! $print['head'] !!}
             @include('payroll.report_header',['text_align'=>"text-center"])

            <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="">
                                
                                <table class="table table-bordered table-hover text-center" style="width:100%">
                                    <thead>
                                        <tr style="height: 30px">
                                            @foreach ($leave_types as $type)
                                                 <td><b>{{ $type->name }}</b></td>
                                            @endforeach
                                            <td><b>Total</b></td>
                                          
                                        </tr>
                                        <tr style="height: 30px">
                                            @foreach ($leave_types as $type)
                                                 <td><b>{{ $type->leave_count }}</b></td>
                                            @endforeach
                                            @php
                                                $total_leave = $leave_types->sum('leave_count')
                                            @endphp
                                            <td><b>{{$total_leave}}</b></td>
                                        </tr>
                                    </thead>
                                </table>

                                <table class="table table-stripped table-bordered text-center" style="width:100%">
                                    <thead>
                                        <tr>
                                            <input type="hidden" name="em_code" id="em_code" value="">
                                        </tr>
                                        <tr>
                                            <th>SL</th>
                                            <th>Emp Code</th>
                                            <th>Emp Name</th>
                                            <th>Designation</th>
                                            @foreach ($leave_types as $type)
                                                <th>{{ $type->name }}</th>
                                            @endforeach
                                            <th>Total Balance</th>
                                            {{-- <th class="no-print">Action</th> --}}
                                        </tr>
                                    </thead>
                                    <tbody id="tbody_data">
                                        @php
                                            $sl = 1;
                                        @endphp
                                        @if (!empty($leaves))
                                            @foreach ($leaves as $emp_id => $employee_leaves)
                                                <tr>
                                                    <td>{{  $sl++ }}</td>
                                                    <td>{{ $employee_leaves->first()->empBasicInfo->emp_code }}</td>
                                                    <td class="text-left">{{ $employee_leaves->first()->empBasicInfo->emp_name }}</td>
                                                    <td>{{ $employee_leaves->first()->empBasicInfo->fetch_designation->name }}
                                                    </td>
                                                    @php
                                                      $total_leave_balance= 0;
                                                     
                                                     @endphp
                                                    @foreach ($leave_types as $type)
                                                    @php
                                                        $type_wise_taken_leave = $employee_leaves->where('leave_type_id',$type->id)->sum('leave_count');
                                                        $type_wise_balance = $type->leave_count - $type_wise_taken_leave;
                                                        $total_leave_balance +=$type_wise_balance;
                                                    @endphp

                                                    <td>{{$type_wise_balance}}</td>
                                                       
                                                    @endforeach
                                                    <td>{{$total_leave_balance}}</td>
                                                    {{-- <td class="no-print py-1">
                                                        <a href="{{ route('payroll.hrm.leave.leave_details', ['employee_id' => $emp_id,'date_from'=>request()->date_from,'date_to'=>request()->date_to]) }}" class='btn btn-sm btn-info' target="_blank">Details</a>
                                                    </td> --}}
                                                </tr>
                                            @endforeach
                                        @endif
                                    </tbody>
                                </table>
                            </div>

                        </div>
                    </div>
                </div>
            </div>
            {{-- <div style="page-break-after: always;"></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 src="{{ asset('/') }}payroll_assets/leave/applist.js"></script>
{{-- <script src="{{asset("payroll_assets/print_excel.js")}}"></script> --}}
    <script type="text/javascript">
        $(document).ready(function() {
            $('.select_2').select2();
        });
    </script>
@endsection