@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-xs-12">
            <h4 class="page-title"></h4>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header"><h3>Income Tax Report </h3></div>
                <div class="card-body">
                   
                    <form action="{{route('income.tax.report')}}" method="get">
                     <input type="hidden" name="search" value="true">

                        <div class='row'>
                            <div class='col-lg-4 col-md-4  col-sm-6 '>
                                <div class="form-group">

                                    <label class="labels">Select employee</label>
                                    <select id="emp_select" class="name_live_search form-control" name="employee_id">
                                        <option selected disabled value="">Select employee</option>
                                        @foreach ($employes as $e)
                                            <option value="{{$e->id}}">{{$e->emp_name}}-{{$e->emp_code}}</option>
                                        @endforeach
                                    </select>
                                 </div>
                            </div>
                            <div class='col-lg-4 col-md-4 col-sm-6 '>
                                <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-lg-1 col-md-1  col-sm-4  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>
                
                    <table class="display datatable table table-stripped table-bordered mt-3">
                        <thead>
                            <tr>
                                <th>SL NO</th>
                                <th>Name</th>
                                <th>Calculation Type</th>
                                <th>Basic</th>
                                @foreach ($allowances as $allowance)
                                <th>{{$allowance->name}}</th> 
                                @endforeach
                                <th>Taxable Amount</th>
                                <th>Yearly Amount</th>
                                <th>Yearly Deduct</th>
                                <th>Due</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $i = 1; 
                            @endphp
                            @foreach ($employees as $employee )
                            @php $total_taxable_amount = 0; @endphp
                            <tr>
                                <td>{{$i++}}</td>
                                <td class="text-left">{{$employee['name']}}</td>
                                <td>{{$employee['calculation_type']}}</td>
                                <td style="color: green">
                                    {{$employee['basic']}}
                                    @php
                                        $total_taxable_amount += $employee['basic'];
                                    @endphp
                                </td>
                                @foreach ($allowances as $list)
                              
                                  <td>
                                    @if(!empty($employee['employee_allowances']) && count($employee['employee_allowances'])>0)
                                    @foreach($employee['employee_allowances'] as $key=>$value)
                                  
                                            @if($list->id == $value->allowance_id)
                                            @php
                                                 $allowance = $value->amount*12;
                                            @endphp
                                                @if($list->taxable ==1)
                                                @php
                                                    $total_taxable_amount += $allowance;
                                                @endphp
                                                <span style="color: green">{{$allowance}}</span>
                                              
                                                @else
                                                <span>{{$allowance}}</span>
                                                @endif
                                            @endif
                                        @endforeach
                                    @else
                                    {{0}}
                                    @endif
                                
                                  </th> 
                                @endforeach
                                <td>{{$employee['yearly_taxable_amount']}}</td>
                                <td>{{$employee['yearly_tax_amount']}}</td>
                                <td>{{$employee['yearly_paid']}}</td>
                                <td>{{$employee['yearly_due']}}</td>
                            </tr>
                            @endforeach
                           
                           
                        </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
       
    @endsection