@extends('admin.layouts.admin')
@section('style')
<link href="{{ asset('assets/admin/plugins/datatables/dataTables.bootstrap4.min.css') }}" rel="stylesheet" type="text/css" />
@endsection
@section('content')
<!-- Page Content-->
    <div class="page-content-tab">
        <div class="container-fluid">
            <!-- Page-Title -->
            <div class="row">
                <div class="col-sm-12">
                    <div class="page-title-box">
                        <div class="float-right">
                            <ol class="breadcrumb">
                                <li class="breadcrumb-item">
                                    <a href="javascript:void(0);">Salary</a>
                                </li>
                                <li class="breadcrumb-item active">Employee Salary Sheet</li>
                            </ol>
                        </div>
                        <h4 class="page-title">Employee Salary Sheet</h4>

                    </div>
                    <!--end page-title-box-->
                </div>
                <!--end col-->
            </div>
            <!--end row-->
            <!-- end page title end breadcrumb -->
            <div class="row">
                <div class="col-sm-12">
                    @if(session('alert-green'))
                            <div id="mydiv" class="alert alert-success mt-3 text-center">
                                {{ session('alert-green') }}
                            </div>
                        @endif

                        @if(session('alert-danger'))
                            <div id="mydiv" class="alert alert-danger mt-3 text-center">
                                {{ session('alert-danger') }}
                            </div>
                        @endif
                        @if($errors->any())
                            <div id="mydiv" class="row">
                                <div class="col-md-12 mb-5">
                                    @foreach ($errors->all() as $error)
                                        <div class="text-danger small mb-1">* {{$error}}</div>
                                    @endforeach
                                </div>
                            </div>
                        @endif
                        {{ session('status') }}

                    <div class="card">
                        <div class="card-body">
                            <h4 class="mt-0 mb-0 header-title">Filter</h4>
                            <p class="text-muted mb-3">Search Employee</p>
                            <form method="get" action="{{ route('admin.salary_process.salary_sheet', ['year' => $year, 'month' => $month]) }}" class="form-horizontal form-wizard-wrapper">
                        
                                <div class="row">
                                    <div class="col-md-2">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="emp_id">Employee ID</label>
                                            <input type="text" class="form-control" value="{{ Request::get('emp_id')}}"
                                                name="emp_id" aria-required="true" id="emp_id" placeholder="Emp ID">
                                        </div>
                                    </div>                                   
                                    
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="name">Name</label>
                                            <input type="text" class="form-control" value="{{ Request::get('name')}}"
                                                name="name" aria-required="true" id="name" placeholder="Name">
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-3">
                                        <div class="form-group">
                                            <label class="text-bold-600 text-uppercase" for="phone">Phone</label>
                                            <input type="text" class="form-control" value="{{ Request::get('phone')}}"
                                                name="phone" aria-required="true" id="phone" placeholder="phone">
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <a href="{{ route('admin.salary_process.salary_sheet', ['year' => $year, 'month' => $month]) }}"
                                                class="btn btn-danger waves-effect waves-light mt-4 mr-2">
                                                <i class="ti-reload mr-1"> </i> Clear
                                            </a>
                                            <button type="submit" class="btn btn-primary waves-effect waves-light mt-4">
                                                <i class="ti-search mr-1"> </i> Filter Now
                                            </button>
                                            <button type="submit" name="download" value="1"
                                                class="btn btn-success waves-effect waves-light mt-4"><i
                                                    class="fas fa-download"></i> Download as Excel
                                            </button>
                                        </div>
                                    </div>

                                </div>
                            </form>
                            <!--end form-->
                        </div>
                        <!--end card-body-->
                    </div>
                    <!--end card-->
                </div>
                <!--end col-->
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-lg-6 col-sm-6">
                                    <h4 class="mt-0 mb-0 header-title">Lists </h4>
                                </div>
                                
                                <!-- end row -->
                            </div>
                            <!-- end row -->  
                            <div class="table-responsive">
                                <table id="datatable" class="table table-bordered dt-responsive nowrap w-100" style="text-align:center;">
                                    <thead>
                                        <tr>                                  
                                            <th rowspan="2">SL No.</th>
                                            <th rowspan="2">Employee ID</th>
                                            <th rowspan="2">Employee name</th>
                                            <th rowspan="2">Designation</th>
                                            <th rowspan="2">Department</th>
                                            <th rowspan="2">Joining Date</th>
                                            <th rowspan="2">Service Start Day</th>
                                            <th rowspan="2">Service End Day</th>
                                            <th rowspan="2">Total Working Day</th>
                                            <th rowspan="2">Total Present Day</th>
                                            <th rowspan="2">Total Absent Day</th>
                                            <th rowspan="2">Attendance Allowance</th>
                                            <th rowspan="2">Attendance Deduction</th>
                                            <th rowspan="2">Gross Salary</th>                                        
                                            <th rowspan="2">Basic Salary</th>
                                            <th rowspan="2">Income Tax</th> 
                                            @php
                                            $x = 0;
                                            if($allowances){
                                                $x = $allowances->count();
                                            }
                                            @endphp
                                            <th colspan="{{ $x }}">Allowance</th>
                                            
                                            @php
                                            $y = 0;
                                            if($deductions){
                                                $y = $deductions->count();
                                            }
                                            @endphp
                                            <th colspan="{{ $y }}">Deduction</th>                                       
                                            <th rowspan="2">Total Deduction</th>                                        
                                            <th rowspan="2">Net Pay</th>                                        
                                            <th rowspan="2">Bank/Bkash Name</th>                                        
                                            <th rowspan="2">Bank/Bkash No</th>                                        
                                            <th rowspan="2">Routing No</th>                                        
                                            <th rowspan="2">Additional Allowance</th>                                        
                                            <th rowspan="2">Additional Deduction</th>                                        
                                            <th rowspan="2">Payable Amount</th>                                        
                                            <th rowspan="2">Action</th>                                        
                                        </tr>
                                        <tr>   
                                            @if($allowances)
                                                @foreach($allowances as $allowance)
                                                    <td>{{ $allowance->name ?? ''}}</td>
                                                @endforeach
                                            @endif
                                            
                                            @if($deductions)
                                                @foreach($deductions as $deduction)
                                                    <td>{{ $deduction->name ?? ''}}</td>
                                                @endforeach                                               
                                            @endif                                    
                                        </tr>
                                    </thead>
                                    <tbody> 
                                        @foreach($salaries as $emp)   
                                        <!-- "emp_id" => 7287
                                        "existing_id" => 175
                                        "total_attendance" => 23
                                        "total_leave" => 0
                                        "total_latein" => 1
                                        "working_day" => 26.0
                                        "total_absent" => 0
                                        "monthly_allocated_leave" => 1                                     -->
                                        <tr>
                                            <td>{{ $loop->iteration ?? '' }}</td>
                                            <td>{{ $emp->employee->emp_id ?? '' }}</td>
                                            <td>{{ $emp->employee->user->name ?? '' }}</td>
                                            <td>{{ $emp->employee->designation->name ?? '' }}</td>
                                            <td>{{ $emp->employee->department->name ?? '' }}</td>
                                            <td>{{ $emp->employee->joining_date ?? '' }}</td>    
                                            <td>{{ $start_date ?? '' }}</td> 
                                            <td>{{ $end_date ?? '' }}</td> 
                                            @php
                                            $attendance = getAttendanceOfEmployeeForSalary($emp->employee->emp_id, $start_date, $end_date);
                                           // dd($attendance);
                                            @endphp
                                            <td>{{ $attendance['working_day'] ?? '' }}</td> 
                                            <td>{{ $attendance['total_attendance'] ?? '' }}</td> 
                                            <td>{{ $attendance['total_absent'] ?? '' }}</td> 
                                            <td>{{ $emp->attandence_allowance ?? '' }}</td> 
                                            <td>{{ $emp->attandence_deduction ?? '' }}</td> 
                                            <td>{{ $emp->gross ?? '' }}</td> 
                                            <td>{{ $emp->basic ?? '' }}</td> 
                                            <td>{{ $emp->tax ?? '' }}</td>
                                            @if($allowances)
                                                @foreach($allowances as $allowance)
                                                <td>@foreach($emp->employee->employeePayscaleAssign->employeePayscaleDetails as $salaryHead)
                                                        @if($allowance->id == $salaryHead->salary_type_id)
                                                            {{ $salaryHead->amount ?? '0'}}
                                                        @endif
                                                    @endforeach
                                                </td>
                                                @endforeach
                                            @endif
                                             
                                             @php 
                                                $totaldeduction = 0;
                                            @endphp
                                            @if($deductions)

                                                @foreach($deductions as $deduction)
                                                <td>
                                                   
                                                    @foreach($emp->employee->employeePayscaleAssign->employeePayscaleDetails as $salaryHead)
                                                        @if($deduction->id == $salaryHead->salary_type_id)
                                                        @php 
                                                            $totaldeduction += $salaryHead->amount;
                                                        @endphp
                                                            {{ $salaryHead->amount ?? '0'}}
                                                        @endif
                                                    @endforeach
                                                </td>
                                                @endforeach                                               
                                            @endif
                                             
                                            <td>{{ $totaldeduction ?? '0' }}</td>                                             
                                            <td>{{ ($emp->gross - $totaldeduction) ?? ''}}</td>                                             
                                            @if($emp->employee->payment_method == 'Bank')                                          
                                            <td>{{ $emp->employee->bank_name ?? ''}}</td> 
                                            <td>{{ $emp->employee->account_number ?? ''}}</td> 
                                            <td>{{ $emp->employee->routing_number ?? ''}}</td> 
                                            @else
                                            <td>{{ $emp->employee->payment_method ?? ''}}</td> 
                                            <td>{{ $emp->employee->bkash_number ?? ''}}</td> 
                                            <td>{{ 'N/A'}}</td>
                                            @endif 
                                            <td>{{ $emp->aditional_allowance ?? ''}}</td>
                                            <td>{{ $emp->aditional_deduction ?? ''}}</td>
                                            <td>{{ (($emp->payable_amount + $emp->aditional_allowance) - $emp->attandence_deduction) ?? ''}}</td>
                                            <td>
                                                <a href="#" data-toggle="modal" data-target="#additional_adjustment" type="button" class="btn btn-success btn-sm salary_id" data-salary_id="{{ $emp->id ?? '' }}" title="Additional Adjustment" ><i class="fa fa-plus"></i> Additional</a>
                                                <a href="{{ route('admin.salary_process.view', ['id' => $emp->id ]) }}" class="btn btn-primary btn-sm" title="View"><i class="fa fa-eye"></i></a>
                                            </td>                                            
                                        </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div><!--end card-body-->
                    </div><!--end card-->
                </div><!--end col-->
            </div><!--end row-->
        </div>
        <div class="modal fade " id="additional_adjustment" tabindex="-1" role="dialog" aria-labelledby="additional_adjustment" aria-hidden="true">
            <div class="modal-dialog modal-lg" role="document">
                <div class="modal-content">
                    <div class="modal-header border-bottom-0">
                        <h5 class="modal-title" id="exampleModalLabel">Additional Adjustment</h5>
                        <button type="button" class="close" id="mod_cls" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <div class="modal-body">
                        <div class="card-body" id="card-form">

                            <form method="POST" action="{{ route('admin.salary_process.additional_adjustment') }}">
                                @csrf
                                <div class="form-group">
                                    <label class="input-label" for="department">Additional Allowance <span class="text-danger">*</span></label>
                                    <input type="number" min="0" class="form-control" name="aditional_allowance"  id="aditional_allowance">
                                </div>

                                <div class="form-group">
                                    <label class="input-label" for="department">Additional Deduction <span class="text-danger">*</span></label>
                                    <input type="number"  min="0" class="form-control" name="aditional_deduction"  id="aditional_deduction">
                                </div>                                
                                <button class="btn btn-primary" type="submit">Save</button>
                                <input type="hidden" name="salary_id" id="salary_id">
                            </form>

                            <!--end form-->
                        </div>
                    </div>

                </div>
            </div>
        </div>
        
        <!-- footer -->
    @include('admin.sections.footer')
    <!--end footer-->
    </div>
<!-- end page content -->
@endsection
@section('script')
<script type="text/javascript">
    $(document).on('click', '.salary_id', function(e) {
        e.preventDefault();
        //$('#product_list').empty();
        //var toAppend = '';
        const id = $(this).data('salary_id');
        $('#salary_id').val(id);
        

    })
</script>
@endsection