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

<style>
   
    #myTable tbody td{
        vertical-align: middle !important;
    }
 </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>Leave Allowance Report</h3>
                        </div>
                      
                        <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>
                      

                    </div>
                </div>
                <div class="card-body">
                   
                    <form action="{{route('payroll.payroll.leave_allowance.report')}}" 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> Name/Code</label>
                                    <select class="form-control name_code_live_search" name="employee_id" id="employee_id">
                                    </select>    
                                 </div>
                            </div>
                           
                            <div class='col-lg-3 col-md-3 col-sm-6 '>
                                <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}}" @if(request()->get('department_id') == $department) {{'selected'}} @endif>{{$department->name}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            
                            <div class='col-lg-1 col-md-1  col-sm-4  mt-4'>
                                <button class='btn btn-sm btn-danger' name='button_submit'>Search</button>
                            </div>
                           
                        </div>
                    </form>
                    </div>
                </div>
            </div>
        </div>
       
    @if(count($employees) >0)
    @php
    $sl =1;
    @endphp
     <div id="divTableDataHolder" class="table2excel">
         <style>
              @media print{
            @page{
                size: A4 portrait;
                /* size: legal landscape; */
              padding : 0;
              margin: 5mm;
            }
            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;
            }

            #myTable tbody td{
                vertical-align: middle !important;
            }

        }
         </style>
        @foreach ($employees->chunk(25) 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">Leave Allowance  Report</h4>
                        <h4 class="text-center">{{$chunk_data->first()->department}}</h4>

                        <div class=" row m-3" style="display: none">
                            <table class="table table-stripped table-bordered" style="width:100%">
                                <tr>
                                    <th colspan="12" class="text-center">
                                        <h4 class="text-center">Leave Allowance  Report</h4>
                                    </th>
                                </tr>
                                <tr>
                                    <th colspan="12" class="text-center">
                                        <h4 class="text-center">{{$chunk_data->first()->department}}</h4>
                                    </tr>  
                            </table>
                        </div>
                    
                        <div class="col-lg-12 col-md-12 col-sm-12 " style="">
                            <table class="table table-bordered table-hover text-center" style="width: 100%" id="myTable">
                            <thead class="">
                                <tr>
                                    <th>#SL</th>
                                    <th>Code</th>
                                    <th>Name</th>
                                    <th>Designation</th>
                                    <th>Join Date</th>
                                    <th>Basic</th>
                                    <th>Period</th>
                                    <th>Leave</th>
                                    <th>Net Payable</th>
                                    <th style="width: 15%">Signature</th>
                                </tr>
                                </thead>
                                <tbody id="tbody_data">
                                   
                                    @foreach ($chunk_data as $employee)                                          
                                    <tr style="height:50px">
                                        <td>{{$sl++}}</td>
                                        <td>{{$employee->code}}</td>
                                        <td class="text-left">{{$employee->name}}</td>
                                        <td class="text-left">{{ $employee->designation}}</td>
                                        <td class="text-center" style="white-space: nowrap">{{$employee->joining_date}}</td>
                                        <td>{{number_format($employee->basic_salary)}}</td>
                                        <td>{{ $employee->service_length}}</td>
                                        <td>{{ $employee->leave_days}}</td>
                                        <td>{{number_format($employee->amount)}}</td>
                                        <td></td>
                                    </tr>
                                    @endforeach
                                    <tr>
                                        <td colspan="5" class="text-right"> Total</td>
                                        <td>{{number_format($employees->sum('basic_salary'))}}</td>
                                        <td colspan="2"></td>
                                        <td>{{number_format($employees->sum('amount'))}}</td>
                                        <td></td>
                                    </tr>
                                </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