@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">{{__('obs.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-2'>
                                <div class="form-group">
                                    <label>{{__('obs.employee_code')}}</label>
                                    <input type="text" class="form-control input-sm" name="emp_code" id="emp_code" value="{{ request()->get('emp_code') }}">
                                </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 input-sm">
                                        <option value="">--Select--</option>
                                        @if(!empty($department_lists))
                                            @foreach($department_lists as $depart_val)
                                                <option value="{{$depart_val->id}}" @if(request()->get('emp_department') == $depart_val) {{'selected'}} @endif>{{$depart_val->name}}</option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>Employee Type{{__('obs.')}}</label>
                                    <select name="emp_types" id="emp_types" class="form-control input-sm">
                                        <option value="">--Select--</option>
                                        @if(!empty($employee_types))
                                            <option value="0">All{{__('obs.total')}}</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-2'>
                                <div class="form-group">
                                    <label>Date From {{__('obs.')}}</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-2'>
                                <div class="form-group">
                                    <label>Date To{{__('obs.')}}</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-1 mt-4'>
                                <button class='btn btn-sm btn-danger'>Search{{__('obs.')}}</button>
                            </div>
                            <div class='col-md-1 text-right'>
                           
                                @include('payroll.includes.printAndExcel')
                               
                            </div>
                            <div class='col-md-1 mt-4 text-right'>
                                <div class="form-group">
                                    <button class="btn btn-md btn-info text-right" onclick="PrintTable();">Print</button>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <div class="card-box">
                <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">Mitali Traders</h4>
                                                <h5 class="card-title text-center">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 style="border: 1px solid black;margin-right: 75%;">@if(!empty($emp_department)){{$emp_department->name}}@endif</h5>

                                                    <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">
                                            </td>
                                        </tr>
                                        <tr>
                                            <th rowspan="2">#SL</th>
                                            <th rowspan="2">Name</th>
                                            <th rowspan="2">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">Basic</th>

                                        
                                            @if (!empty($allowances))
                                                @foreach($allowances as $allowance)
                                                    <th rowspan="2">{{$allowance->name}}</th>
                                                @endforeach
                                            @endif
                                        
                                            <th>Gross</th>
                                            <th colspan="2">OT Hour</th>
                                            <th colspan="2">OT Day</th>
                                         
                                            <th colspan={{count($all_leave_type)+1}}>Leave</th>
                                        
                                            <th colspan="3">Deduction</th>
                                            @foreach($all_other_allowance as $other_allow)
                                                <th rowspan="2" class="">{{$other_allow->name}}</th>
                                             @endforeach
                                           

                                            <th rowspan="2">Total Salary</th>
                                            {{-- conveyance --}}
                                            <th rowspan="2">Conveyance</th>
                                            <th rowspan="2">Tax</th>
                                            <th colspan="4">Adjustment</th>
                                            <th rowspan="2">Net Payable</th>
                                            <th rowspan="2">Signature</th>
                                        </tr>
                                        <tr>
                                            <th>Salary</th>
                                            <th>Hour</th>
                                            <th>Tk</th>

                                            <th>Day</th>
                                            <th>Tk</th>
                                         
                                            @if(count($all_leave_type)>0)
                                                @foreach($all_leave_type as $leave_type_val)
                                                    <th>{{$leave_type_val->name}}</th>
                                                @endforeach
                                            @else
                                                <th>Day</th>
                                            @endif
                                            <th>Tk</th>

                                            <th>Abs</th>
                                            <th>L/E</th>
                                            <th>Tk</th>
                                           
                                           

                                            <th>Bank</th>
                                            <th>Loan</th>
                                            <th>DN/PN</th>
                                            <th>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'] }} - {{$val['code']}}
                                                        <input type="hidden" name="emp_id[]" id="emp_id[]"
                                                               value="{{$val['id']}}">
                                                        <input type="hidden" name="emp_dept[]" id="emp_dept[]"
                                                               value="{{$val['department']}}">
                                                    </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'])}}
                                                                                                                <input type="hidden" name="basic_salary[]" id="basic_salary[]"
                                                               value="{{$val['basic']}}">
                                                    </td>


                                                    @if(count($allowances)> 0)
                                                        @foreach($allowances as $allowance)
                                                        <td class="center_id">
                                                            @if(!empty($val['allowance']) && count($val['allowance'])>0)
                                                            @foreach($val['allowance'] as $key=>$value)
                                                                    @if($allowance->id == $value->allowance_id)
                                                                        {{$value->amount}}
                                                                        <input type="hidden" name="allowance_amount[]"  value="{{$val['id']}}|{{$allowance->id}}|{{$value->amount}}|{{$val['department']}}">
                                                                    @endif
                                                                @endforeach
                                                            @else
                                                            {{0}}
                                                            <input type="hidden" name="allowance_amount[]" value="">
                                                            @endif
                                                        </td>
                                                        @endforeach
                                                    @endif


                                                    <td class="text-right">{{round($val['gross'])}}
                                                                                                                <input type="hidden" name="gross_salary[]" id="gross_salary[]"value="{{$val['gross']}}">
                                                    </td>
                                                   
                                                    <td class="text-right"> <!--OT Hour-->
                                                      
                                                        {{$val['total_ot_hour']}}
                                                        <input type="hidden" name="ot_hour[]" id="ot_hour[]" value="{{$val['total_ot_hour']}}">
                                                    </td>

                                                    <td class="text-right"> 
                                                        {{$val['ot_hour_amount']}}
                                                        @php $total_ot_amount += $val['ot_hour_amount'] ;@endphp
                                                        <input type="hidden" name="ot_hour_amount[]" id="ot_hour_amount[]" value="{{$val['ot_hour_amount']}}">
                                                    </td>
                                                   
                                                    
                                                    <td class="center_id"><!--OT Day-->
                                                        {{$val['total_ot_day']}}
                                                        <input type="hidden" name="ot_day[]" id="ot_day[]" value="{{$val['total_ot_day']}}">
                                                    </td>
                                                    <td class="text-right"><!--OT Day Amount-->
                                                    
                                                        {{round($val['total_ot_day_amount'])}}
                                                                                                                <input type="hidden" name="ot_day_amount[]" id="ot_day_amount[]" value="{{$val['total_ot_day_amount']}}">
                                                    </td>
                                                    @foreach($all_leave_type as $leave_type_val)
                                                                                                                <td class="center_id">
                                                            @if(!empty($val['total_leave_info']) && count($val['total_leave_info'])>0)
                                                                @foreach($val['total_leave_info'] as $leave_key=>$leave_val)
                                                                    @if($leave_key==$leave_type_val['id'])
                                                                                                                                                {{$leave_val}}
                                                                    @endif
                                                                @endforeach
                                                            @else
                                                                0                                                            @endif
                                                        </td>
                                                    @endforeach
                                                    {{-- @foreach($val['leave_type'] as $leave_val) {{$leave_val['name']}} @endforeach--}}
                                                    {{--{{$val['leave']}}--}}
                                                    <input type="hidden" name="leave[]" id="leave[]"
                                                           value="{{$val['leave']}}">

                                                    <td class="text-right">
                                                    @foreach($all_leave_type as $leave_type_val)
                                                                                                                @if(!empty($val['total_leave_info']) && count($val['total_leave_info'])>0)
                                                            @foreach($val['total_leave_info'] as $leave_key=>$leave_val)
                                                                @if($leave_key==$leave_type_val['id'])
                                                                    @if($leave_type_val['pay_type']==1) <!-- Paid Leave -->
                                                                        @if($leave_type_val['deduction_type']==1)<!--Gross Salary -->
                                                                                                                                        @else <!--From Basic Salary-->
                                                                                                                                                @endif
                                                                        @endif
                                                                    @endif
                                                                @endforeach
                                                            @endif
                                                        @endforeach
                                                        {{number_format($leave_amount)}}
                                                                                                                <input type="hidden" name="leave_amount[]" id="leave_amount[]"
                                                               value="{{$leave_amount}}">
                                                    </td>
                                                    <td class="center_id"><!-- Absent Count -->
                                                        <!--Joining And Resignation Deduction -->
                                                        
                                                        {{$total_absent}}
                                                        <input type="hidden" name="absent[]" id="absent[]" value="{{$total_absent}}">
                                                    </td>
                                                    
                                                    <td class="center_id">
                                                        {{$val['late_count']}}
                                                        <input type="hidden" name="late[]" id="late[]" value="{{$val['late_count']}}">
                                                    </td>
                                                    <td class="text-right"><!--Late Amount Count -->
                                                        @php 
                                                            $late_amount = $val['late_amount'];
                                                            $total_deduction_amount += ($late_amount + $absent_amount);
                                                        @endphp
                                                        {{round($late_amount + $absent_amount)}}
                                                         
                                                        <input type="hidden" name="late_amount[]" id="late_amount[]" value="{{$late_amount}}">
                                                    </td>
                                                   
                                                    @if(!empty($all_other_allowance))
                                                   
                                                        @foreach($all_other_allowance as $other_allow)
                                                           @php
                                                            if (count(collect($val['other_allowance'])) > 0 ) {
                                                                $other_allowance_info = collect($val['other_allowance'])->where('allowance_id', $other_allow->id)->first();
                                                                $other_allowance_amount = $other_allowance_info ? $other_allowance_info->allowance_amount : 0;
                                                            }else{
                                                                $other_allowance_amount=0; 
                                                            }
                                                            @endphp
                                                            <td class="center_id">{{$other_allowance_amount}}</td>
                                                                                                                        <input type="hidden" name="allowance_amount[]" value="{{$val['id']}}|{{$other_allow->id}}|{{$other_allowance_amount}}|{{$val['department']}}">
                                                        @endforeach
                                                        @else
                                                        <td></td>
                                                    @endif
                                                  
                                                  
                                                    <td class="text-right">
                                                                                                                {{number_format($total_salary)}}
                                                        <input type="hidden" name="total_salary[]" id="total_salary[]" value="{{$total_salary}}">
                                                    </td>
                                                    {{-- conveyance --}}
                                                    <td class="text-right">
                                                        {{$val['conveyance_amount']}}
                                                                                                            </td>
                                                      {{-- Tax --}}
                                                      <td class="text-right"> 
                                                        {{number_format($val['income_tax'])}}
                                                                                                                <input type="hidden" name="income_tax[]" id="income_tax[]"
                                                               value="{{$val['income_tax']}}">
                                                    </td>
                                                    <td class="text-right">
                                                        {{number_format($val['bank_amount'])}}
                                                                                                                <input type="hidden" name="bank_pamount[]" id="bank_amount"
                                                               value="{{$val['bank_amount']}}">
                                                    </td>
                                                    <td class="text-right">