@extends('backEnd.master')
@section('title')
    @lang('hr.payroll_report')
@endsection

@section('mainContent')
    @php
        $setting = generalSetting();
        if (!empty($setting->currency_symbol)) {
            $currency = $setting->currency_symbol;
        } else {
            $currency = '$';
        }
    @endphp

    <section class="sms-breadcrumb mb-20">
        <div class="container-fluid">
            <div class="row justify-content-between">
                <h1>@lang('hr.payroll_report')</h1>
                <div class="bc-pages">
                    <a href="{{ route('dashboard') }}">@lang('common.dashboard')</a>
                    <a href="#">@lang('hr.human_resource')</a>
                    <a href="#">@lang('hr.payroll_report')</a>
                </div>
            </div>
        </div>
    </section>
    <section class="admin-visitor-area up_admin_visitor">
        <div class="container-fluid p-0">
            <div class="row">
                <div class="col-lg-12">

                    <div class="white-box">
                        <div class="row">
                            <div class="col-lg-4 col-md-6">
                                <div class="main-title">
                                    <h3 class="mb-15">@lang('common.select_criteria') </h3>
                                </div>
                            </div>
                        </div>
                        {{ Form::open(['class' => 'form-horizontal', 'files' => true, 'route' => 'searchPayrollReport', 'method' => 'POST', 'enctype' => 'multipart/form-data']) }}
                        <div class="row">
                            <div class="col-lg-4">
                                <select
                                    class="primary_select  form-control {{ $errors->has('role_id') ? ' is-invalid' : '' }}"
                                    name="role_id" id="role_id">
                                    <option data-display="@lang('hr.role') *" value="">@lang('common.select') *</option>
                                    @foreach ($roles as $key => $value)
                                        <option value="{{ $value->id }}"
                                            {{ isset($role_id) ? ($role_id == $value->id ? 'selected' : '') : '' }}>
                                            {{ $value->name }}</option>
                                    @endforeach
                                </select>
                                @if ($errors->has('role_id'))
                                    <span class="text-danger invalid-select" role="alert">
                                        {{ $errors->first('role_id') }}
                                    </span>
                                @endif
                            </div>

                            @php $month = date('F'); @endphp
                            <div class="col-lg-4 mt-30-lg">
                                <select
                                    class="primary_select  form-control {{ $errors->has('payroll_month') ? 'is-invalid' : '' }}"
                                    name="payroll_month" id="payroll_month">
                                    <option data-display="@lang('student.select_month') *" value="">@lang('student.select_month') *</option>
                                    <option value="January"
                                        {{ isset($payroll_month) ? ($payroll_month == 'January' ? 'selected' : '') : ($month == 'January' ? 'selected' : '') }}>
                                        @lang('student.january')</option>
                                    <option value="February"
                                        {{ isset($payroll_month) ? ($payroll_month == 'February' ? 'selected' : '') : ($month == 'February' ? 'selected' : '') }}>
                                        @lang('student.february')</option>
                                    <option value="March"
                                        {{ isset($payroll_month) ? ($payroll_month == 'March' ? 'selected' : '') : ($month == 'March' ? 'selected' : '') }}>
                                        @lang('student.march')</option>
                                    <option value="April"
                                        {{ isset($payroll_month) ? ($payroll_month == 'April' ? 'selected' : '') : ($month == 'April' ? 'selected' : '') }}>
                                        @lang('student.april')</option>
                                    <option value="May"
                                        {{ isset($payroll_month) ? ($payroll_month == 'May' ? 'selected' : '') : ($month == 'May' ? 'selected' : '') }}>
                                        @lang('student.may')</option>
                                    <option value="June"
                                        {{ isset($payroll_month) ? ($payroll_month == 'June' ? 'selected' : '') : ($month == 'June' ? 'selected' : '') }}>
                                        @lang('student.june')</option>
                                    <option value="July"
                                        {{ isset($payroll_month) ? ($payroll_month == 'July' ? 'selected' : '') : ($month == 'July' ? 'selected' : '') }}>
                                        @lang('student.july')</option>
                                    <option value="August"
                                        {{ isset($payroll_month) ? ($payroll_month == 'August' ? 'selected' : '') : ($month == 'August' ? 'selected' : '') }}>
                                        @lang('student.august')</option>
                                    <option value="September"
                                        {{ isset($payroll_month) ? ($payroll_month == 'September' ? 'selected' : '') : ($month == 'September' ? 'selected' : '') }}>
                                        @lang('student.september')</option>
                                    <option value="October"
                                        {{ isset($payroll_month) ? ($payroll_month == 'October' ? 'selected' : '') : ($month == 'October' ? 'selected' : '') }}>
                                        @lang('student.october')</option>
                                    <option value="November"
                                        {{ isset($payroll_month) ? ($payroll_month == 'November' ? 'selected' : '') : ($month == 'November' ? 'selected' : '') }}>
                                        @lang('student.november')</option>
                                    <option value="December"
                                        {{ isset($payroll_month) ? ($payroll_month == 'December' ? 'selected' : '') : ($month == 'December' ? 'selected' : '') }}>
                                        @lang('student.december')</option>
                                </select>
                                @if ($errors->has('payroll_month'))
                                    <span class="text-danger invalid-select" role="alert">
                                        {{ $errors->first('payroll_month') }}
                                    </span>
                                @endif
                            </div>
                            <div class="col-lg-4 mt-30-lg">
                                <select
                                    class="primary_select  form-control {{ $errors->has('payroll_year') ? 'is-invalid' : '' }}"
                                    name="payroll_year" id="payroll_year">
                                    <option data-display="@lang('hr.select_year')*" value="">@lang('hr.select_year') *</option>

                                    @php
                                        $year = date('Y');
                                        $ini = date('y');
                                        $limit = $ini + 30;

                                    @endphp

                                    @for ($i = $ini; $i <= $limit; $i++)
                                        <option value="{{ $year }}"
                                            {{ isset($payroll_year) ? ($payroll_year == $year ? 'selected' : '') : (date('Y') == $year ? 'selected' : '') }}>
                                            {{ $year-- }}</option>
                                    @endfor
                                </select>
                                @if ($errors->has('payroll_year'))
                                    <span class="text-danger invalid-select" role="alert">
                                        {{ $errors->first('payroll_year') }}
                                    </span>
                                @endif
                            </div>
                            <div class="col-lg-12 mt-20 text-right">
                                <button type="submit" class="primary-btn small fix-gr-bg">
                                    <span class="ti-search pr-2"></span>
                                    @lang('common.search')
                                </button>
                            </div>
                        </div>
                        {{ Form::close() }}
                    </div>
                </div>
            </div>
            @if (isset($staffsPayroll))
                <div class="row mt-40">
                    <div class="col-lg-12">
                        <div class="white-box">
                            <div class="row">
                                <div class="col-lg-4 no-gutters">
                                    <div class="main-title">
                                        <h3 class="mb-15">@lang('hr.staff_list')</h3>
                                    </div>
                                </div>
                            </div>
    
                            <div class="row">
                                <div class="col-lg-12">
                                    <x-table>
                                        <table id="table_id" class="table" cellspacing="0" width="100%">
                                            <thead>
                                                <tr>
                                                    <th>@lang('hr.staff_name')</th>
                                                    <th>@lang('hr.role')</th>
                                                    <th>@lang('common.description')</th>
                                                    <th>@lang('hr.month_year')</th>
                                                    <th>@lang('hr.payslip') #</th>
                                                    <th>@lang('hr.basic_salary')({{ generalSetting()->currency_symbol }})</th>
                                                    <th>@lang('hr.earnings')({{ generalSetting()->currency_symbol }})</th>
                                                    <th>@lang('hr.deductions')({{ generalSetting()->currency_symbol }})</th>
                                                    <th>@lang('leave.leave_deductions')({{ generalSetting()->currency_symbol }})</th>
                                                    <th>@lang('hr.gross_salary')({{ generalSetting()->currency_symbol }})</th>
                                                    <th>@lang('hr.tax')({{ generalSetting()->currency_symbol }})</th>
                                                    <th>@lang('hr.net_salary')({{ generalSetting()->currency_symbol }})</th>
                                                </tr>
                                            </thead>
    
                                            <tbody>
                                                @php
                                                    $basic_salary = 0;
                                                    $earnings = 0;
                                                    $deductions = 0;
                                                    $gross_salary = 0;
                                                    $tax = 0;
                                                    $net_salary = 0;
                                                @endphp
                                                @foreach ($staffsPayroll as $value)
                                                    <tr>
                                                        <td>{{ $value->full_name }}</td>
                                                        <td>{{ $value->name }}</td>
                                                        <td>{{ $value->title }}</td>
                                                        <td>{{ $value->payroll_month }} - {{ $value->payroll_year }}</td>
                                                        <td>{{ $value->id }}</td>
                                                        <td>{{ $value->basic_salary }}</td>
                                                        <td>
                                                            @php
                                                                $totalEarnings = App\SmHrPayrollEarnDeduc::getTotalEarnings($value->id);
                                                            @endphp
                                                            @if ($totalEarnings > 0)
                                                                {{ $totalEarnings }}
                                                                @php $earnings +=$totalEarnings; @endphp
                                                            @else
                                                                {{ 0 }}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            @php
                                                                $totalDeductions = App\SmHrPayrollEarnDeduc::getTotalDeductions($value->id);
                                                            @endphp
                                                            @if ($totalDeductions > 0)
                                                                {{ $totalDeductions }}
                                                                @php $deductions +=$totalDeductions; @endphp
                                                            @else
                                                                {{ 0 }}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            @php
                                                                $leaveDeductions = App\SmLeaveDeductionInfo::select('salary_deduct')
                                                                    ->where('payroll_id', $value->id)
                                                                    ->first();
                                                            @endphp
                                                            @if (@$leaveDeductions->salary_deduct > 0)
                                                                {{ @$leaveDeductions->salary_deduct }}
                                                            @else
                                                                {{ 0 }}
                                                            @endif
                                                        </td>
                                                        <td>{{ $value->gross_salary }}</td>
                                                        <td>{{ $value->tax }}</td>
                                                        <td>{{ $value->net_salary }}</td>
                                                        @php
                                                            $basic_salary += $value->basic_salary;
                                                            $gross_salary += $value->gross_salary;
                                                            $tax += $value->tax;
                                                            $net_salary += $value->net_salary;
                                                        @endphp
                                                    </tr>
                                                @endforeach
    
                                            </tbody>
                                            <tfoot>
                                                <tr>
                                                    <th></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th></th>
                                                    <th>@lang('fees.grand_total')</th>
                                                    <th>{{ currency_format($basic_salary) }}</th>
                                                    <th>{{ currency_format($earnings) }}</th>
                                                    <th>{{ currency_format($deductions) }}</th>
                                                    <th>{{ currency_format(@$leaveDeductions->salary_deduct) }}</th>
                                                    <th>{{ currency_format($gross_salary) }}</th>
                                                    <th>{{ currency_format($tax) }}</th>
                                                    <th>{{ currency_format($net_salary) }}</th>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </x-table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            @endif
        </div>
        </div>
        </div>
        </div>
        {{-- @endif --}}
        </div>
    </section>
@endsection
@include('backEnd.partials.data_table_js')