@extends('admin.layout.master')
@section('content')
    <style>
       
        @media print {
            table.listdb {
                border-collapse: unset;
            }

            table td {
                border: 1px solid #000 !important;
            }
            @page{
                size:landscape;
            }
        }
    </style>
    @php use App\Models\Payroll\Common\Settings\CommonSettingsTypes; @endphp

    <div class="row">
        @if (count($errors) > 0)
                <div class="alert alert-danger">
                    <ul>
                        @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                        @endforeach
                    </ul>
                </div>
            @endif
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header" style="padding: 5px 10px">
                    <div class='row'>
                        <div class='col-md-10 text-left' pt-2>
                            <h3 class="card-title font-weight-bold">{{__('obs.employee_generated_salary')}}</h3>
                        </div>
                    
                        @if(count($generated_info) >0)
                        <div class='col-md-1 text-right'>
                             <div class="form-group">
                                <button type="button" class="btn btn-md 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.salary.generated_salary')}}" method="get">
                        <div class='row'>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>{{__('obs.employee_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="department_id" id="department_id" class="form-control select_2">
                                        <option value="">--Select--</option>
                                        @if(!empty($department_lists))
                                            @foreach($department_lists 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-md-2'>
                                <div class="form-group">
                                    <label>{{__('obs.employee_type')}}</label>
                                    <select name="emp_type" id="emp_type" class="form-control select_2">
                                        <option value="">--Select--</option>
                                        @if(!empty($employee_types))
                                            @foreach($employee_types as $emp_type_val)
                                                <option value="{{$emp_type_val->id}}">{{$emp_type_val->name}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>{{__('obs.salary_month')}}</label>
                                    <input type="text" class="datepicker_month form-control input-sm" name="salary_month" id="salary_month">
                                </div>
                            </div>
                            
                            <div class='col-md-1 mt-4'>
                                <button class='btn btn-sm btn-success' style="width: 100px">{{__('obs.search')}}</button>
                            </div>
                          
                        </div>
                       
                    </form>
                    </div>
                </div>
            </div>
        </div>
       


    <div class="row table-responsive"  id="divTableDataHolder" class="table2excel">
        <style>
            table th, table td{
                vertical-align: middle !important; 
            }
            #divTableDataHolder{ 
                
                
            }
            @media print {
                table th, table td{
                    font-size: 10px;
                 }
                 .no-print{
                    display: none;
                 }
                .pagebreak { page-break-after: always; } 
                .print_salary{
                    padding: 0!important;
                    margin: 0 !important;
                }

                @page{
                    /* size: 8.5in 5.5in; */
                    /* size:landscape !important; */
                    /* size: A4; */
                    /* zoom:100%; */
                    /* font-size: 10px; */
                }
            }
        </style>
        <div class="col-lg-12 " >
            <div class="card-box">
                <div class="card-block">
                    <div class="row ">
                        <div class="col-lg-12">
                          
                              @php
                                 $total_employee = count($generated_info);
                                 $i=0;
                              @endphp
                              
                              @php 
                                 $total_gross = 0;$total_basic = 0; 
                                 $total_ot_hour_amount = 0;
                                 $grand_net_payable = 0; $grand_total_salary = 0;$grand_advance_total = 0;$grand_bank_total = 0;  $total_add_deduct_amount  = 0;  $grand_loan_total = 0;
                              @endphp
                                @foreach (collect($generated_info)->chunk(33) as $chunked_salary )
                                    @php
                                        $total_employee -=count($chunked_salary);
                                    @endphp
                                  
                                  
                                    <div>
                                        @if(count($generated_info) >0)
                                        <h4 class="card-title text-center m-0">{{store_info()->name_eng}}</h4>
                                        <h5 class="card-title text-center m-0">@if(!empty($emp_department)){{$emp_department->name}}@endif</h5>
                                        <h5 class="card-title text-center m-0">Salary sheet for the month of  @if(!empty($end_date)){{date('F\'Y',strtotime($end_date))}}@endif</h5>
                                        @endif
                                    </div>

                                    <table class="table table-bordered table-hover" id="" style="">
                                        <thead>
                                        <tr>
                                            @php
                                                $total_col_span = '35';
                                                if (!empty($all_other_allowance)) {
                                                    $total_col_span += count($all_other_allowance);
                                                }
                                            @endphp
                                          
                                        </tr>
                                        <tr>
                                            <th rowspan="2">{{__('obs.sl')}}</th>
                                            <th rowspan="2">{{__('obs.card_number')}}</th>
                                            <th rowspan="2" style="width:10%; white-space: nowrap;">{{__('obs.name')}}</th>
                                            <th rowspan="2" style="padding: 0 !important">{{__('obs.designation')}}</th>
                                            <th rowspan="2" style="padding: 2px !important; white-space: nowrap;">{{__('obs.joining')}}</th>
                                            
                                            <th rowspan="2">{{__('obs.basic')}}</th>
                                             {{-- Allowance --}}
                                            @if (!empty($allowances))
                                                @foreach($allowances as $allowance)
                                                    {{-- <th rowspan="2">{{$allowance->name}}</th> --}}
                                                @endforeach
                                            @endif
                                        
                                            <th rowspan="2" style="white-space: pre-wrap">{{__('obs.gross_salary')}}</th>
                                            <th colspan="2">{{__('obs.hour')}}</th>
                                            <th colspan="3">{{__('obs.overtime_day')}}</th>
                                            <th colspan="2">{{__('obs.late')}}|{{__('obs.early')}}</th>
                                            <th colspan="2">{{__('obs.absent')}}</th>
                                         
                                            <th colspan={{count($all_leave_type)+1}}>Leave</th>
                                             
                                           
                                            @foreach($all_other_allowance as $data)
                                                <th rowspan="2" class="" style="white-space: pre-wrap">{{$data->name}}</th>
                                             @endforeach
                                           
                                            <th rowspan="2" style="white-space: pre-wrap">{{__('obs.total_salary')}}</th>
                                            {{-- conveyance --}}
                                            {{-- <th rowspan="2">Conv.</th> --}}
                                            {{-- <th rowspan="2">Tax</th> --}}
                                            <th colspan="4">{{__('obs.adjustment')}}</th>
                                            <th rowspan="2" style="white-space: pre-wrap">{{__('obs.net_payable')}}</th>
                                            <th rowspan="2">{{__('obs.signature')}}</th>
                                        </tr>
                                        <tr>
                                         
                                            <th>{{__('obs.hour')}}</th>
                                            <th>{{__('obs.taka')}}</th>

                                            <th>{{__('obs.day')}}</th>
                                            <th style="padding:0;margin:0;vertical-align: middle">{{__('obs.adjustment')}}</th>
                                            <th>{{__('obs.taka')}}</th>
                                            {{-- Late --}}
                                            <th>{{__('obs.day')}}</th>
                                            <th>{{__('obs.taka')}}</th>
                                            {{-- Absent --}}
                                            <th>{{__('obs.day')}}</th>
                                            <th>{{__('obs.taka')}}</th>
                                            {{-- Leave --}}
                                            @foreach($all_leave_type as $leave_type_val)
                                                <th>{{$leave_type_val->print_name ? $leave_type_val->print_name : $leave_type_val->name}}</th>
                                            @endforeach
                                            <th>{{__('obs.taka')}}</th>
                                            <th>{{__('obs.bank')}}</th>
                                            <th>{{__('obs.loan')}}</th>
                                            <th>{{__('obs.add')}}/{{__('obs.deduct')}}</th>
                                            <th>{{__('obs.advance')}}</th>
                                        </tr>
                                        </thead>

                                            
                                       
                                      
                                        <tbody id="tbody_data">
                                      
                                          @if($generated_info)
                                            @php
                                                $k = 0;
                                                $total_ot_day_amount = 0;$total_leave_amount = 0;$total_deduction_amount = 0; $conveyance_amount=0; $total_conveyance_amount =0; $total_income_tax =0 ;$income_tax_amount =0;
                                                $salary_allowance = [];$salary_other_allowance = [];$allowance_amount = 0;
                                            @endphp
                                           
                                            @foreach($chunked_salary as $salary)
                                                @php 
                                                    $gross_salary = 0;$basic_salary = 0;
                                                    // OT Variable Initialize
                                                    $ot_hour = 0;$ot_day = 0;$total_ot_amount = 0;
                                                    $per_day_salary = 0;$per_hour_salary = 0;
                                                    $ot_hour_amount = 0;$ot_day_amount = 0; $total_joining_absent = 0;$total_resign_absent=0;$total_absent = 0;
                                                    $ot_hour_salary = 0;$ot_day_salary = 0; $joining_deduction = 0;$resign_deduction=0;
                                                    $absent_amount = 0;$late_amount = 0;$leave_amount = 0;$add_allowance = 0;
                                                    $deduct_allowance = 0; $other_allowance_amount = 0; $total_other_allowance_amount = 0;
                                                @endphp
                                                <tr style="" >
                                                    <td class="center_id">{{++$i}}</td>
                                                    <td class="text-center">{{$salary->get_emp_info->emp_card}}</td>
                                                    <td class="text-left" style="white-space: nowrap;">
                                                        {{$salary->get_emp_info->emp_name}} - {{$salary->get_emp_info->emp_code}}
                                                    </td>
                                                   
                                                    
                                                  
                                                    <td class="text-left" style="white-space: nowrap;">{{$salary->get_emp_info ?  $salary->get_emp_info->fetch_designation ? $salary->get_emp_info->fetch_designation->name : null : null}}</td>
                                                    <td class="text-left" style="white-space: nowrap;">{{$salary->get_emp_info ?  $salary->get_emp_info->joining_date ? $salary->get_emp_info->joining_date : null : null}}</td>
                                                    {{-- <td class="center_id">{{$val['station_vehicle_no']}}</td> --}}
                                                    <td class="text-right">{{number_format($salary->basic_salary)}}
                                                        @php
                                                            $basic_salary = $salary->basic_salary;
                                                            $total_basic += $basic_salary;
                                                        @endphp
                                                    </td>
                                                    {{-- Allowance  --}}
                                                    {{-- @foreach($allowances as $allowance)
                                                    @php 
                                                        $allowance_data = $generated_allowance_info->where('emp_id', $salary->get_emp_info->id)->where('allowance_id', $allowance->id)->first();
                                                    @endphp
                                                        @if(!empty($allowance_data->allowance_amount))
                                                            <td>
                                                                {{abs($allowance_data->allowance_amount)}}
                                                            </td>
                                                        @else
                                                            <td>0</td>
                                                        @endif
                                                           
                                                    @endforeach --}}

                                                    <td class="text-right">
                                                        {{number_format($salary->gross_salary)}}
                                                       @php
                                                            $total_gross += $salary->gross_salary;
                                                       @endphp
                                                    </td>
                                                   
                                                    <td class="text-right"> <!--OT Hour-->
                                                        {{$salary->ot_hour}}
                                                    </td>

                                                    <td class="text-right"> 
                                                        {{number_format($salary->ot_hour_amount)}}
                                                        @php $total_ot_hour_amount += $salary->ot_hour_amount; @endphp
                                                    </td>
                                                   
                                                    <td class="center_id"><!--OT Day-->
                                                        {{$salary->ot_day}}
                                                    </td>
                                                    <td class="text-right"><!--OT Day Replace-->
                                                        {{$salary->ot_day_replace}}

                                                    </td>
                                                    <td class="text-right"><!--OT Day Amount-->
                                                         {{number_format( $salary->ot_day_amount)}}
                                                        @php $total_ot_amount += $salary->ot_day_amount;@endphp
                                                    </td>
                                                  
                                                  
                                                    <td class="center_id"><!--Late-->
                                                        {{ $salary->late}}|0
                                                    </td>
                                                    <td class="text-right"><!--Late Amount -->
                                                        @php 
                                                            $late_amount = $salary->late_amount;
                                                            $early_amount = $salary->early_leave_amount;
                                                            $absent_amount = $salary->absent_amount;
                                                           
                                                        @endphp
                                                        {{number_format($late_amount)}}
                                                         
                                                    </td>


                                                  
                                                    <td class="center_id"><!-- Absent Count -->
                                                        <!--Joining And Resignation Deduction -->
                                                        @php
                                                           $total_absent =$salary->absent;
                                                        @endphp

                                                        {{$total_absent}}
                                                    </td>

                                                    <td class="text-right">

                                                      {{number_format( $absent_amount)}}
                                                    </td>


                                                    @foreach($all_leave_type as $leave_type_val)
                                                                                                        <td class="center_id">
                                                        @if(!empty($total_leave_info) && count($total_leave_info)>0)
                                                            @foreach($total_leave_info as $leave_key=>$leave_val)
                                                                @if($leave_key==$leave_type_val['id'])
                                                                                                                                        {{$leave_val}}
                                                                @endif
                                                            @endforeach
                                                        @else
                                                            0                                                        @endif
                                                    </td>
                                                  @endforeach

                                                   
                                                  

                                                    <td class="text-right">
                                                           {{number_format($salary->leave_amount)}}
                                                            @php $total_leave_amount += $salary->leave_amount; @endphp
                                                    </td>
                                                    

                                                     @foreach($all_other_allowance as $other_allowance)
                                                        @php 
                                                            $generated_other_allowance = $generated_other_allowance_info->where('emp_id', $salary->emp_id)->where('allowance_id', $other_allowance->id)->first();
                                                       @endphp
                                                            <td>{{$generated_other_allowance->allowance_amount ?? null}}</td>
                                                    @endforeach
                                                  
                                                    <td class="text-right">
                                                        @php
                                                            $total_salary = $salary->total_salary;
                                                            $grand_total_salary += $total_salary
                                                        @endphp
                                                        {{number_format($total_salary)}}
                                                    </td>
                                                   
                                                    <td class="text-right">
                                                        @php 
                                                            $bank_amount = $salary->bank_amount;
                                                            $grand_bank_total += $bank_amount;
                                                        @endphp
                                                        {{number_format($bank_amount)}}
                                                    </td>
                                                    <td class="text-right">
                                                        @php
                                                            $loan_amount = $salary->loan_amount;
                                                            $grand_loan_total += $loan_amount
                                                        @endphp
                                                      
                                                        {{number_format($loan_amount)}}
                                                    </td>
                                                    {{-- Add/Ded--}}
                                                    <td class="text-right">
                                                        @php 
                                                            $add_deduct_amount=  $salary->add_deduct_amount;
                                                            $total_add_deduct_amount += $add_deduct_amount;
                                                        @endphp
                                                        {{number_format(abs($add_deduct_amount))}}
                                                    </td>
                                                    {{-- Suspense/Advance --}}
                                                    <td class="text-right">
                                                        @php
                                                            $advance_amount =$salary->advance_amount;
                                                            $grand_advance_total += $advance_amount 
                                                        @endphp
                                                
                                                        {{number_format($advance_amount)}}
                                            
                                                      </td>
                                                   
                                                    <td class="text-right">
                                                        @php 
                                                            $net_payable = $salary->net_amount;
                                                            $grand_net_payable += $net_payable
                                                        @endphp
                                                        {{number_format($net_payable)}}
                                                    </td>
                                                    <td class="text-center">&nbsp;</td>
                                                </tr>
                                             @endforeach
                                        @endif
                                    </tbody>
                                      


                                        @if($total_employee ==0 )
                                            @php 
                                              $total_salary_allowance = collect($salary_allowance);
                                              $total_other_allowance = collect($salary_other_allowance);
                                            @endphp
                                            <tr style="font-weight: bold;border-top: 2px solid black">
                                                <td colspan="5">{{__('obs.total')}}</td>
                                                <td class="text-right">{{number_format($total_basic)}}</td>
                                                {{-- Allowance --}}
                                                @if(count($allowances)> 0)
                                                    @foreach($allowances as $allowance)
                                                    {{-- @dd($total_salary_allowance) --}}
                                                    {{-- <td class="text-right">{{number_format($total_salary_allowance->sum($allowance->id))}}</td> --}}
                                                    @endforeach
                                                @endif
                                             
                                                <td class="text-right">{{number_format($total_gross)}}</td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td class="text-right">{{number_format($total_ot_day_amount)}}</td>
                                              
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>

                                                @if(count($all_leave_type)>0)
                                                    @foreach($all_leave_type as $leave_type_val)
                                                        <td>&nbsp;</td>
                                                    @endforeach
                                                @endif
                                                <td class="text-right">{{number_format($total_leave_amount)}}</td>
                                               
                                                @foreach($all_other_allowance as $data)
                                                    <td class="text-right"></td>
                                                @endforeach
                                                

                                                <td class="text-right">{{number_format($grand_total_salary)}}
                                                    <input type="hidden" name="net_total_salary" id="net_total_salary"
                                                           value="{{$grand_total_salary}}">
                                                </td>
                                                {{-- conveyance --}}
                                                {{-- <td class="text-right">
                                                    {{$total_conveyance_amount}}
                                                </td> --}}

                                                {{-- Tax --}}
                                                {{-- <td class="text-right">{{$total_income_tax}}</td> --}}
                                                <td class="text-right">{{number_format($grand_bank_total)}}</td>
                                                <td class="text-right">{{number_format($grand_loan_total)}}</td>
                                                <td class="text-right">{{number_format(abs($total_add_deduct_amount))}}</td>
                                                <td class="text-right">{{number_format($grand_advance_total)}}</td>
                                                <td class="text-right">{{number_format($grand_net_payable)}}
                                                    <input type="hidden" name="grand_net_payable" id="grand_net_payable" value="{{$grand_net_payable}}"></td>
                                                <td class="text-center">&nbsp;</td>
                                            </tr>
                                     
                                            <tr>
                                                <td colspan="{{$total_col_span}}">
                                                    @if($grand_net_payable > 0)
                                                        <div class="col-sm-12 text-center">
                                                            @php
                                                                $total_pay_in_word = number_format(round($grand_net_payable));
                                                                $converted_amount_in_text = convert_number($grand_net_payable);
                                                            @endphp
                                                            <b style="font-size: 16px ; margin-left: 29px">In Words : @php echo $converted_amount_in_text; @endphp  {{__('obs.taka_only')}}</b>
                                                            <br>
                                                            <b>{{$company_policy}}</b>
                                                        </div>
                                                    @endif

                                                    {{-- @include('payroll.signature') --}}
                                                    
                                                </td>
                                            </tr>
                                         @endif
                                      
                                    </table>
                                    @include('payroll.signature')

                                <div class="pagebreak"></div>
                            @endforeach
                         
                        </div>
                    </div>
                    
                </div>
            </div>
        </div>
    </div>
   

@endsection


@section('script')
<script src="{{ asset('payroll_assets/payroll_common.js') }}"></script>
<script src="{{ asset('payroll_assets/payroll_print.js') }}"></script>
<script>
    $(document).ready(function () {
        $('.select_2').select2();
    });
    function PrintDiv() {
    var divToPrint = document.getElementById('divTableDataHolder');
    var popupWin = window.open('', '_blank', 'width=900,height=900');
    popupWin.document.open();
    popupWin.document.write('<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><link href="{{asset('/')}}assets/css/bootstrap.min.css" rel="stylesheet" media="screen,print"></head><body onload="window.print()">' + divToPrint.innerHTML + '</html>');
    popupWin.document.write('<style>\n' +
        '.table thead tr th,.table tr td{\n' +
        '        border: 1px solid black !important;\n' +
        '        text-align: center !important;\n' +
        '    }\n' +
        '.value{\n' +
        '        font-size: 12px !important;\n' +
        '    }\n' +
        '.line_height{\n' +
        '        line-height: 1.00 !important;\n' +
        '        font-size: 16px !important;\n' +
        '    }\n' +
        '.table_line_height{\n' +
        '        line-height: 1.0 !important;\n' +
        '    }\n' +
        '.border_remove{\n' +
        '       border-top: 1px solid white !important;\n' +
        '       border-left: 1px solid white !important;\n' +
        '       border-right: 1px solid white !important;\n' +
        '    }\n' +
        '.display_none{\n' +
        '       display: none !important;\n' +
        '    }\n' +
        '</style>');
    popupWin.document.close();
}
 
      
</script>
@endsection