@extends('admin.layout.master')
@section('content')
    <style>
        label {
            margin-bottom: 1px;
        }

        .form-group {
            margin-bottom: 9px;
        }

        .table-responsive {
            height: calc(100vh - 360px);
        }

        th {
            background: #007bff;
            color: white !important;
            position: sticky;
            top: 0;
            text-align: center;
        }

        table {
            position: relative;
        }

        .table-bordered td, .table-bordered th {
            border: 1px solid #aaabab;
        }

        td {
            text-align: center;
        }

        @media print {
            table.listdb {
                border-collapse: unset;
            }

            table td {
                border: 1px solid #000 !important;
            }
        }
    </style>

<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.bonus')}} {{__('obs.report')}}</h3>
                    </div>
                
                    @if(count($bonus_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="PrintTable();">{{__('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.bonus.search')}}" method="get">
                    <div class='row'>
                        <div class='col-md-3'>
                            <div class="form-group">
                                <label>{{__('obs.emp')}} {{__('obs.code')}}</label>
                                <input type="text" class="form-control input-sm" name="emp_code" id="emp_code">
                            </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 input-sm">
                                    <option value="0">--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-3'>
                            <div class="form-group">
                                <label>{{__('obs.designation')}}</label>
                                <select name="emp_designation" id="emp_designation" class="form-control input-sm">
                                    <option value="0">--Select--</option>
                                    @if(!empty($designation_lists))
                                        @foreach($designation_lists as $design_val)
                                            <option value="{{$design_val->id}}">{{$design_val->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>
                        <div class='col-md-3'>
                            <div class="form-group">
                                <label>{{__('obs.join')}} {{__('obs.date')}} {{__('obs.from')}} </label>
                                <input type="text" class="datepicker form-control input-sm"
                                       name="join_date_from" id="join_date_from">
                            </div>
                        </div>
                        <div class='col-md-3'>
                            <div class="form-group">
                                <label>{{__('obs.join')}} {{__('obs.date')}} {{__('obs.to')}}</label>
                                <input type="text" class="datepicker form-control input-sm"
                                       name="join_date_to" id="join_date_to">
                            </div>
                        </div>
                        <div class='col-md-2'>
                            <div class="form-group">
                                <label>{{__('obs.joining')}} {{__('obs.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-md-3'>
                            <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-3'>
                            <div class="form-group">
                                <label>{{__('obs.print')}} {{__('obs.month')}}</label>
                                <select class="form-control input-sm" name=print_month id="print_month">
                                    <option value="">{{__('obs.select')}}</option>
                                    <option value="January">{{__('obs.january')}}</option>
                                    <option value="February">{{__('obs.february')}}</option>
                                    <option value="March">{{__('obs.march')}}</option>
                                    <option value="April">{{__('obs.april')}}</option>
                                    <option value="May">{{__('obs.may')}}</option>
                                    <option value="June">{{__('obs.june')}}</option>
                                    <option value="July">{{__('obs.july')}}</option>
                                    <option value="August">{{__('obs.august')}}</option>
                                    <option value="September">{{__('obs.september')}}</option>
                                    <option value="October">{{__('obs.october')}}</option>
                                    <option value="November">{{__('obs.november')}}</option>
                                    <option value="December">{{__('obs.december')}}</option>
                                </select>
                            </div>
                        </div>
                        <div class='col-md-3 mt-4'>
                            <button class='btn btn-sm w-100 btn-danger'>{{__('obs.search')}}</button>
                        </div>
                    </div>
                   
                </form>
                </div>
            </div>
        </div>
    </div>
   






    <div id="divTableDataHolder" class="table2excel">

    <div class="row">
        <div class="col-lg-12">
            {{-- <h4 class="card-title text-center font-weight-bold">{{__('obs.bonus')}} {{__('obs.report')}}</h4>
          <button class="btn btn-md btn-info text-right" onclick="PrintTable();">{{__('obs.print')}}</button> --}}
          
                <table class="table table-bordered table-hover" id="">
                    <thead>
                    <tr>
                        <td colspan="15">
                            {{-- <h4 class="card-title text-center"> {{__('obs.mitali')}} {{__('obs.traders')}}</h4> --}}
                            <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}} (April)
                                        @endif
                                    @endforeach @endif
                                    FOR THE YEAR OF 2022
                            </h5>
                           
                        </td>
                    </tr>
                    <tr>
                        <th>{{__('obs.sl')}}#</th>
                        <th>{{__('obs.name')}}</th>
                        <th>{{__('obs.design')}}</th>
                        <th>{{__('obs.station')}}</th>
                        {{-- <th>{{__('obs.joining')}}</th> --}}
                        {{-- <th>{{__('obs.working')}} {{__('obs.month')}}</th> --}}
                        <th>{{__('obs.basic')}} {{__('obs.salary')}}</th>
                        @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==1)
                            <th>{{__('obs.leave')}} {{__('obs.day')}}</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.netpayable')}}</th>
                        <!--<th>Remarks</th>-->
                        <th>{{__('obs.signature')}}</th>
                    </tr>
                    </thead>
                    <tbody class="bonus_tbody">
                                        @if(!empty($bonus_info)) @php($i=1)@php($j=1)
                    @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">{{number_format($basic_salary)}}</td>

                            @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==1)
                                                                <td class="text-center">{{$emp_job_duration}}
                            @else
                               <td class="text-right">
                                   @if(!empty($_GET['bonus_type_filter']) && $_GET['bonus_type_filter']==3)
                                    {{number_format($half_bonus_amount)}}
                                   @endif
                            @endif
                            </td>
                            <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-right">&nbsp;</td>
                            @php($i++)
                        </tr>
                    @endforeach
                    @endif
                    </tbody>
                    @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>
                        </tr>
                    @endif
                    <tr>
                        <td colspan="27">                          
                           @include('payroll.signature')
                        </td>
                    </tr>
                </table>
           
        </div>
    </div>
    </div>

    

    <script src="{{asset('payroll_assets/bonus/bonus.js')}}"></script>
@endsection