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

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

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

        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">
        <div class="col-lg-12">
            <h4 class="card-title text-center font-weight-bold">Employee Salary </h4>
            {{-- @if (count($errors) > 0)
                <div class="alert alert-danger">
                    <ul>
                        @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                        @endforeach
                    </ul>
                </div>
            @endif --}}
            <div class="card-box">
                <div class="card-block">

                    <!-- Button trigger modal -->
                    <form action="{{route('payroll.payroll.salary.generate')}}" 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 input-sm name_code_live_search" name="emp_code" id="emp_code">
                                    </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="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.employee_type')}}</label>
                                    <select name="emp_types" id="emp_types" class="form-control input-sm">
                                        <option value="0">--Select--</option>
                                        @if(!empty($employee_types))
                                            <option value="0">{{__('obs.all')}}</option>
                                            @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-3'>
                                <div class="form-group">
                                    <label>{{__('obs.date_from')}} </label>
                                    <input type="text" class="datepicker form-control input-sm"
                                           name="date_from" id="date_from" value="{{ request()->get('date_from') }}">
                                </div>
                            </div>
                            <div class='col-md-3'>
                                <div class="form-group">
                                    <label>{{__('obs.date_to')}}</label>
                                    <input type="text" class="datepicker form-control input-sm"
                                           name="date_to" id="date_to" value="{{ request()->get('date_to') }}">
                                </div>
                            </div>
                           
                            <div class='col-md-6 mt-4'>
                                <button class='btn btn-sm w-40 btn-danger'>{{__('obs.search')}}</button>
                            </div>
                            
                            <div class='col-md-1 mt-4 text-right'>
                                @include('payroll.includes.printAndExcel')
                            </div>

                            <div class='col-md-1 mt-4 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>
                    </form>
                </div>
            </div>
           
             <div id="divTableDataHolder" class="card-box table2excel">
                <div class="card-block">
                    <div class="row">
                        <div class="col-lg-12">
                            <form action="{{route('payroll.payroll.salary.store')}}" method="post">
                                @csrf
                                <div class="table-responsive" id="print">
                                    <table class="table table-bordered table-hover" id="salary_table">
                                        <thead>
                                        <tr>
                                                                                        <td colspan="{{$total_col_span}}">
                                                <h4 class="card-title text-center">{{__('obs.mitali_traders')}}</h4>
                                                <h5 class="card-title text-center"> {{__('obs.salary_sheet_for_the_month_of')}}
                                                    {{--From @if(!empty($start_date)){{date('d-m-Y',strtotime($start_date))}}@endif--}}
                                                    @if(!empty($end_date)){{date('F\'Y',strtotime($end_date))}}@endif</h5>
                                                    <h5 id="heading_name" style="border: 1px solid black;margin-right: 75%;">@if(!empty($emp_department)){{$emp_department->name}}@endif</h5>
                                             <div style="display: none" class="div_gross">
                                                <input type="hidden" name="start_date" id="start_date" value="@if(!empty($start_date)){{$start_date}}@endif">
                                                <input type="hidden" name="end_date" id="end_date" value="@if(!empty($end_date)){{$end_date}}@endif">
                                             </div>
                                            </td>
                                        </tr>
                                        <tr>
                                            <th rowspan="2">#{{__('obs.sl')}}</th>
                                            <th rowspan="2">{{__('obs.name')}}</th>
                                            <th rowspan="2">{{__('obs.designation')}}</th>
                                            @if(!empty($emp_type_info) && $emp_type_info==5)
                                                <th rowspan="2">{{'Station'}}</th>
                                            @elseif(!empty($emp_type_info) && $emp_type_info==6)
                                                <th rowspan="2">{{'Vehicle'}}</th>
                                            @else
                                                <th rowspan="2">{{'Station'}}</th>
                                            @endif
                                            <th rowspan="2">{{__('obs.basic')}}</th>
                                            @if(!empty($salary_info))
                                                @foreach($salary_info[1]['allowance'] as $allow_name)
                                                    @if(!empty($allow_name->get_allowance_info))
                                                        <th rowspan="2">{{$allow_name->get_allowance_info->name}}</th>@endif
                                                @endforeach
                                            @endif
                                            <th>Gross</th>
                                              {{-- Arrear Amount --}}
                                            {{-- <th rowspan="2">Arrear</th> --}}

                                            {{--<th>OT Hour</th>
                                            <th>Amount</th>--}}
                                            <th colspan="2">OT</th>
                                            {{--<th>Amount</th>--}}
                                            <th colspan={{count($all_leave_type)+1}}>Leave</th>
                                            {{--<th>Amount</th>--}}
                                            <th colspan="3">Deduction</th>
                                            {{--<th>Amount</th>--}}
                                            {{--<th>Late</th>
                                            <th>Amount</th>--}}
                                            @if(!empty($all_other_allowance))
                                                @foreach($all_other_allowance as $other_allow)
                                                    <th rowspan="2">{{$other_allow->name}}</th>
                                                @endforeach
                                            @endif
                                            <th rowspan="2">{{__('obs.add')}}/{{__('obs.deduct')}}</th>
                                            <th rowspan="2">{{__('obs.total_salary')}}</th>
                                            <th colspan="4">{{__('obs.adjustment')}}</th>
                                            <th rowspan="2">{{__('obs.net_payable')}}</th>
                                            <th rowspan="2">{{__('obs.signature')}}</th>
                                        </tr>
                                        <tr>
                                            <th>{{__('obs.salary')}}</th>
                                          
                                            <!--Ot day -->
                                            <th>{{__('obs.day')}}</th>
                                            <th>{{__('obs.taka')}}</th>
                                            <!-- Leave -->
                                            @if(count($all_leave_type)>0)
                                                @foreach($all_leave_type as $leave_type_val)
                                                    <th>{{$leave_type_val->name}}</th>
                                                @endforeach
                                            @else
                                                <th>{{__('obs.day')}}</th>
                                            @endif
                                            <th>{{__('obs.taka')}}/th>
                                            <th>{{__('obs.absent')}}</th>
                                            <th>{{__('obs.leave')}}/{{__('obs.early')}}</th>
                                            <th>{{__('obs.taka')}}</th>
                                            <th>{{__('obs.bank')}}</th>
                                            <th>{{__('obs.loan')}}</th>
                                            <th>{{__('obs.donation')}}/{{__('obs.pension')}}</th>
                                            <th>{{__('obs.suspense')}}</th>
                                        </tr>
                                        </thead>
                                        <tbody id="tbody_data">
                                        {{-- @dd($salary_info)--}}
                                                                                @if(!empty($salary_info))
                                                                                                                                    @foreach($salary_info as $val)
                                                                                                <tr>
                                                    <td class="center_id">{{++$i}}</td>
                                                    <td class="text-left">{{$val['name']}}
                                                        <div style="display: none" class="div_gross">
                                                            <input type="hidden" name="emp_id[]" id="emp_id[]" value="{{$val['id']}}">
                                                            <input type="hidden" name="emp_dept[]" id="emp_dept[]" value="{{$val['department']}}">
                                                        </div>
                                                    </td>
                                                    <td class="text-left">{{$val['designation']}}</td>
                                                    <td class="center_id">{{$val['station_vehicle_no']}}</td>
                                                    <td class="text-right">{{number_format($val['basic'])}}
                                                                                                                <div style="display: none" class="div_gross">
                                                            <input type="hidden" name="basic_salary[]" id="basic_salary[]" value="{{$basic_salary}}">
                                                        </div>
                                                    </td>

                                                    @if(!empty($val['allowance']))