@extends('admin.layout.master')
@section('content')
<div class="card sina-card">
    <div class="card-header d-flex justify-content-between align-items-center ">
        <h5 class="font-weight-bold mb-0">{{__('obs.bonus')}} {{__('obs.report')}}</h5>
        @if(count($bonus_info) >0)
        <button type="button" class="btn btn-sm btn-info text-right" onclick="PrintDiv();">{{__('obs.print')}}</button>
        @include('payroll.includes.printAndExcel')
        @endif

    </div>
 

    <div class="card-body">
        <form action="{{route('payroll.payroll.bonus.search')}}" method="get">
            <input type="hidden" name="search" value="true">
            <div class='row'>
                <div class='col-2'>
                    <div class="form-group">

                        <label>{{__('obs.name')}}/{{__('obs.code')}}</label>
                        <select class="form-control input-sm name_code_live_search" name="emp_id" id="emp_id">
                        </select>
                    
                    </div>
                </div>
                <div class='col-md-3'>
                    <div class="form-group">
                        <label>{{__('obs.department')}}</label>
                        <select name="emp_department" id="emp_department" class="form-control select_2">
                            <option value=" ">{{__('obs.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>Joining month ></label>
                        <input type="text" class="form-control input-sm" name="subtract_month_from_bonus_month"
                            id="subtract_month_from_bonus_month">
                    </div>
                </div> --}}

                <div class='col-2'>
                    <div class="form-group">
                        <label>{{__('obs.bonus')}} {{__('obs.type')}}</label>
                        <select class="form-control input-sm" name=bonus_type_filter id="bonus_type_filter">
                            <option value="">{{__('obs.select')}}</option>
                            @foreach($bonus_types as $b_type)
                                <option value="{{$b_type->id}}">{{$b_type->title}}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class='col-md-2'>
                    <div class="form-group">
                        <label>{{__('obs.year')}}</label>
                        <select class="form-control input-sm" name=year id="year">
                            <option value="">{{__('obs.select')}} {{__('obs.year')}}</option>
                            <option value="2020">2020</option>
                            <option value="2021">2021</option>
                            <option value="2022">2022</option>
                            <option value="2023">2023</option>
                            <option value="2024">2024</option>
                            <option value="2025">2025</option>
                        </select>
                    </div>
                </div>

                <div class='col-md-2'>
                    <div class="form-group">
                        <label>{{__('obs.print')}} {{__('obs.month')}}</label>
                        <input type="text" class="datepicker form-control input-sm" name="print_month" id="print_month">

                    </div>
                </div>
            
                <div class='col-md-1 mt-4'>
                    <button class='btn btn-sm w-100 btn-danger'>{{__('obs.search')}}</button>
                </div>
            </div>
        </form>
        @if(count($bonus_info) >0)
            <div id="divTableDataHolder" class="table2excel">
                <div class="row" >
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-body" style="padding: 0 ">
        
                                    <div class=" row m-3">
                                        <table class="table table-stripped table-bordered" style="width:100%">
                                            <tr>
                                                <th colspan="15" class="text-center">
                                                    <h4 class="card-title text-center m-0">{{store_info()->name_eng}}</h4>
                                                    <span id="heading_name" style="display: none">{{__('obs.bonus')}} {{__('obs.report')}}</span>
                                                    <h5 class="text-center">@if(!empty($_GET['emp_department']))
                                                        {{\App\Models\Payroll\Settings\PayDepartments::find($_GET['emp_department'])->name}}@endif</h5>
                                                <h5 class="card-title text-center" >@if(!empty($_GET['bonus_type_filter']))
                                                        @foreach($bonus_types as $b_type)
                                                            @if($b_type->id==$_GET['bonus_type_filter'])
                                                                {{$b_type->title}} 
                                                            @endif
                                                        @endforeach @endif
                                                        
                                                            For The Year Of
                                                            @if($print_month)
                                                            {{ carbon()->parse($print_month)->format("F")}} {{"-"}}
                                                            @endif
                                                        {{carbon()->parse($print_month)->format("Y")}}
                                                </h5>
                                                </th>
                                            </tr>
                                            
                                        </table>
                                    </div>
                            
                                <div class="col-lg-12 col-md-12 col-sm-12 " style="">
                                    <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>{{__('obs.sl')}}#</th>
                                                <th>{{__('obs.name')}}</th>
                                                <th>{{__('obs.design')}}</th>
                                                <th>{{__('obs.station')}}</th>
                                                {{-- <th>Joining</th> --}}
                                                {{-- <th>Working Month</th> --}}
                                                <th>{{__('obs.basic')}} {{__('obs.salary')}}</th>
                                                @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==1)
                                                    <th>{{__('obs.leave')}} {{__('obs.days')}}</th>
                                                    <th>{{__('obs.salary')}}</th>
                                                @else
                                                    @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==3)
                                                        <th>{{__('obs.half')}} {{__('obs.bonus')}}</th>
                                                    @else
                                                        <th>{{__('obs.full')}} {{__('obs.bonus')}}</th>
                                                    @endif
                                                    <th>{{__('obs.bonus')}}</th>
                                                @endif
                                                <th>{{__('obs.bank')}}</th>
                                                <th>{{__('obs.net')}} {{__('obs.payable')}}</th>
                                                <th>{{__('obs.note')}}</th>
                                                <th>{{__('obs.signature')}}</th>
                                            </tr>
                                            </thead>
                                            <tbody id="tbody_data">
                                                @php
                                                    $total_bonus_amount = 0;$total_bank_amount = 0;$total_cash_amount = 0;$total_basic = 0;$total_gross =$total_half_bonus_amount= 0;
                                                    $i=1;
                                                    $j=1;
                                                @endphp
                                                
                                                @foreach($bonus_info as $bonus_val)
                                                {{-- @dd($bonus_val->empBasicInfo) --}}
                                                    <tr data-id="{{$i}}">
                                                        <td>{{$j++}}</td>
                                                        <td class="text-left">{{$bonus_val->empBasicInfo->emp_name}}</td>
                                                        <td class="text-left">{{$bonus_val->empBasicInfo->fetch_designation->name}}</td>
                                                        <td class="text-center">{{$bonus_val->empBasicInfo->station_vehicle_no}}</td>
                                                                                                                    
                                                        {{-- <td class="text-center">
                                                            {{$bonus_val->empBasicInfo->joining_date}}
                                                        </td>
                            
                                                        <td>
                                                            {{ $emp_job_duration = $diff}} Months
                                                        </td> --}}
                            
                                                        <td class="text-right">
                                                            @php
                                                                $basic_salary = $bonus_val->basic ? $bonus_val->basic : $bonus_val->empBasicInfo->basic_salary; $total_basic += $basic_salary; 
                                                            @endphp
                                                            
                                                            {{number_format($basic_salary)}}
                                                            
                                                        </td>
                            
                                                        @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==1)
                                                            <td class="text-center">{{$bonus_val->leave_days}}</td>
                                                        @else
                                                            <td class="text-right">
                                                                @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==3)
                                                                {{number_format($half_bonus_amount)}}
                                                                @endif
                                                            </td>
                                                        @endif
                                                        
                                                        <td class="text-right">{{number_format($bonus_amount)}}</td>
                                                        <td class="text-right">{{number_format($bank_amount)}}</td>
                                                        <td class="text-right">{{number_format($cash_amount)}}</td>
                                                        <!-- <td class="text-center">&nbsp;</td>-->
                                                        <td class="text-left">{{$bonus_val->note}}</td>
                                                        <td class="text-right">&nbsp;</td>
                                                        @php($i++)
                                                    </tr>
                                                @endforeach
                                                @if(!empty($bonus_info))
                                                <tr style="font-weight: bold;border-top: 2px solid black">
                                                    <td colspan="4">Total</td>
                                                    <td class="text-right">{{number_format($total_basic)}}</td>
                                                    <td class="text-right">@if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==3){{round($total_half_bonus_amount)}}@else &nbsp; @endif</td>
                                                    <td class="text-right">{{number_format($total_bonus_amount)}}</td>
                                                    <td class="text-right">{{number_format($total_bank_amount)}}</td>
                                                    <td class="text-right">{{number_format($total_cash_amount)}}</td>
                                                    <!--<td class="text-right">&nbsp;</td>-->
                                                    <td class="text-right">&nbsp;</td>
                                                    <td class="text-right">&nbsp;</td>
                                                </tr>
                                            @endif
                                            <tr>
                                                <td colspan="15">                                                
                                                @include('payroll.signature')
                                                </td>
                                            </tr> 
                                            </tbody>  
                                            
                                    </table>
                                    
                                </div>                         
                                
                            </div>
                        </div>
                        </div>
                    </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"> {{__('obs.no')}} {{__('obs.data')}} {{__('obs.found')}}</h4>
                            </div>
                        </div>
                    </div>
                </div>
                @endif
            @endif
        </div> 
 </div>
@endsection

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