@extends('admin.layout.master')
@section('content')
<style>
 
</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.salary_increment_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();">{{__('obs.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.increment.report')}}" method="get">
                        <input type="hidden" name="search">
                        <div class='row'>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>{{__('obs.name')}}/{{__('obs.code')}}</label>
                                    <select class="form-control  name_code_live_search" name="employee_id" id="employee_id">
                                    </select>  
                                </div>
                            </div>
                          
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>{{__('obs.department')}}</label>
                                    <select name="emp_department" id="emp_department" class="form-control select_2">
                                        <option value="">--Select--</option>
                                        @if(!empty($department_lists))
                                            @foreach($department_lists as $depart_val)
                                                <option value="{{$depart_val->id}}">{{$depart_val->name}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                           
                          
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>{{__('obs.increment_type')}}</label>
                                    <select name="increment_type_id" id="increment_type_id" class="form-control input-sm">
                                        {{-- <option value="">--Select--</option> --}}
                                        @foreach($increment_types as $increment_type)
                                            <option value="{{$increment_type->id}}">{{$increment_type->name}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class='col-md-1'>
                                <div class="form-group">
                                    <label>{{__('obs.allowance')}}</label>
                                    <select name="allowance_id" id="allowance_id" class="form-control select_2">
                                        @foreach($gorss_allowances as $gorss_allowance)
                                            <option value="{{$gorss_allowance->id}}">{{$gorss_allowance->name}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                        
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>{{__('obs.batch')}}</label>
                                    <select name="batch_no" id="batch_no" class="form-control input-sm">
                                        <option value="">--Select Batch--</option>
                                        @if(!empty($increment_batch))
                                           @foreach($increment_batch as $batch=>$data)
                                                <option value="{{$batch}}">{{$batch}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>

                            <div class='col-1'>
                                <div class="form-group">
                                    <label>{{__('obs.date')}} {{__('obs.form')}} </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-1'>
                                <div class="form-group">
                                    <label>{{__('obs.date')}} {{__('obs.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 mt-4'>
                                <button class='btn btn-sm w-100 btn-success' name="filter">{{__('obs.search')}}</button>
                            </div>
                        </div>
                    </form>
                  </div>
            </div>
        </div>
    </div>
    
    @if(count($increment_list) >0)
     <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 1mm 5mm 1mm 
                  
                }
            }
        </style>
          @php
            $i=1;
            $total_increment = 0;
            $total_current_basic = 0;
            $total_current_gross = 0;
          @endphp
         @foreach ($increment_list->chunk(30) as $chunk_data)
        <div class="row" >
            <div class="col-lg-12">
                        <h4 id="heading_name" class="text-center">{{__('obs.salary_increment_report')}}</h4>
                        <h4 class="text-center">{{request()->get('emp_department') ? department(request()->get('emp_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.salary_increment.reort')}}</h4>
                                           <h4 class="text-center">{{request()->get('emp_department') ? department(request()->get('emp_department'))->name  : null}}</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>Sl#</th>
                                    <th>{{__('obs.code')}}</th>
                                    <th>{{__('obs.name')}}</th>
                                    <th>{{__('obs.designation')}}</th>
                                    <th>{{__('obs.increment')}}</th>
                                    <th>{{__('obs.previous_basic')}}</th>
                                    <th>{{__('obs.current_basic')}}</th>
                                    <th>{{__('obs.previous')}}  {{$filtered_allowance_name}}</th>
                                    <th>{{__('obs.current')}}  {{$filtered_allowance_name}}</th>
                                    <th>{{__('obs.previous_gross')}}</th>
                                    <th>{{__('obs.current_gross')}}</th>
                                </tr>
                                </thead>
                                <tbody class="">
                                    @if(count($chunk_data)>0)
                                   
                                        @foreach ($chunk_data as $increment)
                                        @php
                                            $total_increment += $increment['increment_amount'];
                                            $total_current_basic += $increment['current_basic'];
                                            $total_current_gross += $increment['current_gross'];
                                        @endphp
                                        <tr style="height: 30px">
                                            <td>{{$i++}}</td>
                                            <td>{{$increment['emp_code']}}</td>
                                            <td class="text-left">{{$increment['name']}}</td>
                                            <td class="text-left">{{$increment['designation']}}</td>
                                            <td class="text-right">{{number_format($increment['increment_amount'])}}</td>
                                            <td class="text-right">{{number_format($increment['previous_basic'])}}</td>
                                            <td class="text-right">{{number_format($increment['current_basic'])}}</td>
                                            <td class="text-right">{{number_format($increment['previous_house_rent'])}}</td>
                                            <td class="text-right">{{number_format($increment['current_house_rent'])}}</td>
                                            <td class="text-right">{{number_format($increment['previous_gross'])}}</td>
                                            <td class="text-right">{{number_format($increment['current_gross'])}}</td>
                                        </tr>
                                        @endforeach 
                                        <tr>
                                            <td colspan="4"><b>{{__('obs.grand_total')}}</b></td>
                                            <td class="text-right"><b>{{number_format($total_increment)}}</b></td>
                                            <td class="text-right"><b></b></td>
                                            <td class="text-right"><b>{{number_format($total_current_basic)}}</b></td>
                                            <td class="text-right"><b></b></td>
                                            <td class="text-right"><b></b></td>
                                            <td class="text-right"><b></b></td>
                                            <td class="text-right"><b>{{number_format($total_current_gross)}}</b></td>

                                        </tr>
                                    @else
                                        <tr><td colspan="8">{{__('obs.no_data_found')}}</td></tr>
                                    @endif
                                  
                                </tbody>
                            </table>
                        </div>   
                </div>
          
            <div style="page-break-after: always;"></div>
        </div>
          @endforeach
       
     @else
        @if(request()->has('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
    </div>
    @endif
    @endsection


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