@extends('admin.layout.master')
@section('home')
    <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('salary.generate-salary')}}" method="get">
                        <div class='row'>
                            <div class='col-md-2'>
                                <div class="form-group">
                                    <label>Emp 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>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</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</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 </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</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</button>
                            </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('salary.salary-complete')}}" 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>
                                            @if(!empty($all_other_allowance))
                                                @foreach($all_other_allowance as $other_allow)
                                                    <th rowspan="2">{{$other_allow->name}}</th>
                                                @endforeach
                                            @endif

                                            <th rowspan="2">Total Salary</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}}
                                                                    @endif
                                                                @endforeach
                                                            @else
                                                            {{0}}
                                                            @endif
                                                        </td>
                                                        @endforeach
                                                    @endif


                                                    <td class="text-right">{{number_format($val['gross'])}}
                                                                                                                <input type="hidden" name="gross_salary[]" id="gross_salary[]"
                                                               value="{{$val['gross']}}">
                                                    </td>
                                                   
                                                    <td> <!--OT Hour-->
                                                        @if(!empty($val['ot_settings']))
                                                            @if(!empty($ot_policy->hour_limit))
                                                                                                                            @else
                                                                                                                            @endif
                                                        @endif
                                                        {{$ot_hour}}
                                                        <input type="hidden" name="ot_hour[]" id="ot_hour[]"
                                                               value="{{$ot_hour}}">
                                                    </td>
                                                    <td class="text-right"> <!--OT Hour Amount-->
                                                        {{-- @if(!empty($val['ot_settings']))
                                                        @if(!empty($val['manual_ot_info']) && !empty($val['manual_ot_info'][0]))
                                                                                                                    @else
                                                            @if($ot_policy->amount_type == 1)<!--if Fixed Amount-->
                                                                                                                        @else
                                                                @if($ot_policy->salary_type==1) <!--Based On Basic-->
                                                                    @php($ot_day_salary = $per_day_basic_salary)
                                                                @else
                                                                    @php($ot_day_salary = $per_day_gross_salary) <!--Based On Gross Salary-->
                                                                    @endif
                                                                                                                                                                                                        @endif
                                                            @endif
                                                        @endif --}}


                                                        <input type="hidden" name="ot_hour_amount[]" id="ot_hour_amount[]" value="0">
                                                    </td>


                                                    
                                                    <input type="hidden" name="ot_hour[]" id="ot_hour[]" value="{{$ot_hour}}">
                                                    <input type="hidden" name="ot_hour_amount[]" id="ot_hour_amount[]" value="{{$ot_hour_amount}}">


                                                    <td class="center_id"><!--OT Day-->
                                                        @if(!empty($val['ot_settings']))
                                                                                                                        @if(!empty($val['manual_ot_info']) && !empty($val['manual_ot_info'][0]))
                                                                                                                            @else
                                                                                                                            @endif
                                                            {{$ot_day}}
                                                        @endif
                                                        <input type="hidden" name="ot_day[]" id="ot_day[]"
                                                               value="{{$ot_day}}">
                                                    </td>
                                                    <td class="text-right"><!--OT Day Amount-->
                                                    @if(!empty($val['ot_settings']))
                                                        @if(!empty($val['manual_ot_info']) && !empty($val['manual_ot_info'][0]))
                                                                                                                    @else
                                                            @if($ot_policy->amount_type == 1)<!--if Fixed Amount-->
                                                                                                                        @else
                                                                @if($ot_policy->salary_type==1) <!--Based On Basic-->
                                                                    @php($ot_day_salary = $per_day_basic_salary)
                                                                @else
                                                                    @php($ot_day_salary = $per_day_gross_salary) <!--Based On Gross Salary-->
                                                                    @endif
                                                                                                                                                                                                        @endif
                                                            @endif
                                                        @endif
                                                        {{number_format($ot_day_amount)}}
                                                                                                                                                                        <input type="hidden" name="ot_day_amount[]" id="ot_day_amount[]"
                                                               value="{{$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 style="display: none">
                                                        <!--Absent Amount Count And Other Deduction-->
                                                        @if(!empty($val['get_deduct_policy']))