@extends('admin.layout.master')
@section('content')
<style>
    label {
        margin-bottom: 1px;
    }
    .form-group {
        margin-bottom: 9px;
    }
    .table-responsive {
        height: calc(100vh - 200px);
    }
    th {
        background: #007bff;
        color: white !important;
        position: sticky;
        top: 0;
        text-align: center;
    }
    table {
        position: relative;
        text-align: center;
    }
    .table-bordered td, .table-bordered th {
        border: 1px solid #aaabab;
        padding: 5px;
    }
   
</style>
<style>
     select {
            height: 33px !important;
        }
    label {
        margin-bottom: 1px;
    }
    table th,td{
      vertical-align: middle !important;
    }
    
    @media print{
            @page{
                size: A4 portrait;
                /* size: legal landscape; */
              
            }
            body {
                zoom:50%; /*or whatever percentage you need, play around with this number*/
                font-family: serif;
                font-size:17px;
                font-weight: bold;
                background-color: #FFFFFF !important;
            }

        }
 </style>
    <div class="row">
        <div class="col-xs-12">
            <h4 class="page-title"></h4>
        </div>
    </div>
    <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.loan_report')}}</h3>
                        </div>
                        @if(count($loans) >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.payroll.manage_loan.loan_deduction_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>{{__('obs.department')}}</label>
                                    <select name="department_id" id="department_id" class="form-control select_2">
                                        <option value="">--Select--</option>
                                        @if(!empty($departments))
                                            @foreach($departments 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-3 col-md-3 col-sm-6 '>
                                <div class="form-group">
                                    <label>{{__('obs.date')}}</label>
                                    <input type="text" class="datepicker form-control" name="date" id="date" value="{{ request()->get('date') ? request()->get('date') : date('01-m-Y') }}">
                                </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($loans) >0)
    @php
        $total_employee = count($loans);
        $grand_total_net_payable = 0;
        $i=1;
    @endphp
   
     <div id="divTableDataHolder" class="table2excel">
        <style>
            table th, table td{
                vertical-align: middle !important; 
            }
           
            @media print {
                table th, table td{
                    font-size: 16px;
                    font-weight: bold;
                 }
                 .no-print{
                    display: none;
                 }
                .pagebreak { page-break-after: always; } 
                
                @page{
                    size: auto;
                    margin: 5mm 5mm 5mm 5mm 
                  
                }
            }
        </style>
        @foreach (collect($loans)->chunk(25) as $chunk_data)
        @php
        $total_employee -=count($chunk_data);
        @endphp
        <div class="row" >
            <div class="col-lg-12">
                        <h4 id="heading_name" class="text-center">{{__('obs.loan_report')}}  ({{carbon()->create(request()->get('date'))->format('F-Y')}})</h4>
                        <h4 class="text-center">{{$department ? $department->name : null}}</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">{{__('obs.loan_report')}} ({{carbon()->parse(request()->get('date'))->format('F-Y')}})</h4>
                                        </th>
                                    </tr>
                                    <tr>
                                        <th colspan="12" class="text-center">
                                            <h4 class="text-center"></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%">
                            <thead class="">
                                <tr>
                                    <th style="width: 5%"> <b>{{__('obs.sl')}}</b></th>
                                    <th style="width: 10%"><b>{{__('obs.code')}}</b></th>
                                    <th style="width: 15%"> <b>{{__('obs.name')}}</b></th>
                                    <th style="width: 12%"><b>{{__('obs.designation')}}</b></th>
                                    <th style="width: 10%"> <b>{{__('obs.balance')}}</b></th>
                                    <th style="width: 10%"> <b>{{__('obs.deduction_amount')}}</b></th>

                                </tr>
                                </thead>
                                <tbody id="data_body">
                                   @php
                                    $grand_total_balance = 0;
                                    $grand_total_deduction_amount = 0;
                                   @endphp
                                    @foreach ($chunk_data as $data)
                                    {{-- @dd($data) --}}
                                    <tr style="height:50px">
                                        @php
                                            $grand_total_balance += $data['balance'];
                                            $grand_total_deduction_amount += $data['deduction_amount'];
                                        @endphp
                                        <td><b>{{$i++}}</b></td>
                                        <td class="text-center"><b>{{$data['employee_info']->emp_code}}</b></td>
                                        <td class="text-left"><b>{{$data['employee_info']->emp_name}}</b></td>
                                        <td class="text-left"><b>{{$data['employee_info']->fetch_designation->name}}</b></td>
                                        <td class="text-right"> <b>{{number_format($data['balance']) }}</b> </td>
                                        <td class="text-right"> <b>{{number_format($data['deduction_amount']) }}</b> </td>
                                    </tr>
                                    @endforeach

                                    @if($total_employee == 0)
                                    <tr>
                                        <td colspan="4"><b>{{__('obs.grand_total')}}</b></td>
                                        <td class="text-right"><b>{{number_format($grand_total_balance) }}</b></td>
                                        <td class="text-right"> <b>{{number_format($grand_total_deduction_amount) }}</b></td>
                                    </tr>
                                   @endif
                                </tbody>
                            </table>
                        </div>    
                </div>
            </div>
            <div style="page-break-before: 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_data_found')}}</h4>
                </div>
           </div>
        </div>
    </div>
    @endif
    @endif
@include('payroll.hrm_script')
@endsection