@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-3'>
                                <div class="form-group">
                                    <label>Emp 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>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>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">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>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>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-3 mt-4'>
                                <button class='btn btn-sm w-100 btn-danger'>Search</button>
                            </div>
                            <div class='col-md-6 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($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>
                                            {{--<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">Add/Ded</th>
                                            <th rowspan="2">Total Salary</th>
                                            <th colspan="4">Adjustment</th>
                                            <th rowspan="2">Net Payable</th>
                                            <th rowspan="2">Signature</th>
                                        </tr>
                                        <tr>
                                            <th>Salary</th>
                                            <!--Ot day -->
                                            <th>Day</th>
                                            <th>Tk</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>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']}}
                                                        <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(!empty($val['allowance']))