@extends('layouts.pdf')

@section('title')
    {{ $extra['module_name'] }}
@endsection
@section('content')
    {{-- Custom Styling --}}
    <style>
        .box {
            background-color: #0D1117;
            color: #ffffff;
            text-transform: uppercase;
            width: 40% !important;
            margin: auto;
            padding: 10px;
            font-weight: bolder !important;
            font-size: 20px !important
        }

        .custom-table {
            margin-top: 3%;
            width: 100%;
            line-height: 30px;
        }

        .font-bold{
            font-weight: bold;
        }
    </style>
    {{-- End Custom Styling --}}
<div size="A4">

    @include('admin.partials.header', ['extra' => $extra])
    <div class="box">
        <h4 class="text-center">{{ $extra['module_name'] }} For The Month of {{ $common->getMonthName($payroll->month) }} - {{ $payroll->year }}</h4>
    </div>
    
    <br>
    <table class="table table-sm table-bordered"  id="payroll_table">
        <thead>
            <tr>
                <th>{{ __('lang.sno') }}</th>
                <th width="10%">{{ __('lang.employee') }}</th>
                <th>{{ __('lang.working_days') }}</th>
                <th>{{ __('lang.present_days') }}</th>
                <th>{{ __('lang.leave_days') }}</th>
                <th>{{ __('lang.absent_days') }}</th>
                <th>{{ __('lang.total_over_time') }}</th>
                <th class="text-right">{{ __('lang.basic_salary') }}            ({{ config('settings.currency_symbol') }})</th>
                <th class="text-right">{{ __('lang.total_over_time_amount') }}  ({{ config('settings.currency_symbol') }})</th>
                <th class="text-right">{{ __('lang.allowances') }}              ({{ config('settings.currency_symbol') }})</th>
                <th class="text-right">{{ __('lang.deductions') }}              ({{ config('settings.currency_symbol') }})</th>
                <th class="text-right">{{ __('lang.salary_advances') }}         ({{ config('settings.currency_symbol') }})</th>
                <th class="text-right">{{ __('lang.loan_deductions') }}         ({{ config('settings.currency_symbol') }})</th>
                <th class="text-right">{{ __('lang.absent_deduction') }}        ({{ config('settings.currency_symbol') }})</th>
                <th class="text-right">{{ __('lang.short_shift_deduction') }}   ({{ config('settings.currency_symbol') }})</th>
                <th class="text-right">{{ __('lang.net_salary_amount') }}       ({{ config('settings.currency_symbol') }})</th>
            </tr>
        </thead>
        <tbody class="table-data">
            @foreach ($payroll->payroll_items as $payroll_items)
                @php
                    $employee_name                  = $payroll_items->employee->name;
                    $working_days                   = $payroll_items->total_work_day;
                    $present_days                   = $payroll_items->total_present_day;
                    $leave_days                     = $payroll_items->total_leave_days;
                    $absent_days                    = $working_days - $present_days - $leave_days;
                    $overtime                       = $payroll_items->total_over_time;
                    $basic_salary                   = $payroll_items->basic_salary;
                    $overtime_amount                = $payroll_items->total_over_time_amount;
                    $allowances_amount              = $payroll_items->payroll_allowance_items_add->sum('amount');
                    $deductions_amount              = $payroll_items->payroll_allowance_items_less->sum('amount');
                    $advances_amount                = $payroll_items->payroll_advance_items->sum('amount');
                    $loans_amount                   = $payroll_items->payroll_loan_items->sum('amount');
                    $absent_deduction               = $payroll_items->absent_deduction_amount + $payroll_items->late_deduction_amount + $payroll_items->halfday_deduction_amount;
                    $short_shift_deduction          = $payroll_items->short_shift_deduction_amount;
                    $gross_salary_amount            = $payroll_items->salary_amount;

                    $total_working_days             += $working_days;
                    $total_present_days             += $present_days;
                    $total_leave_days               += $leave_days;
                    $total_absent_days              += $absent_days;
                    $total_overtime                 += $overtime;
                    $total_basic_salary             += $basic_salary;
                    $total_overtime_amount          += $overtime_amount;
                    $total_allowances_amount        += $allowances_amount;
                    $total_deductions_amount        += $deductions_amount;
                    $total_advances_amount          += $advances_amount;
                    $total_loans_amount             += $loans_amount;
                    $total_absent_deduction         += $absent_deduction;
                    $total_short_shift_deduction    += $short_shift_deduction;
                    $total_gross_salary_amount      += $gross_salary_amount;
                @endphp
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $employee_name }}</td>
                    <td>{{ $working_days }}</td>
                    <td>{{ $present_days }}</td>
                    <td>{{ $leave_days }}</td>
                    <td>{{ $absent_days }}</td>
                    <td>{{ $common->min_to_hr_and_min($overtime) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($basic_salary) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($overtime_amount) }}</td>
                    <td class="text-right">{{ $transaction->convert_money_format($allowances_amount) }}</td>
                    <td class="text-right">({{ $transaction->convert_money_format($deductions_amount) }})</td>
                    <td class="text-right">({{ $transaction->convert_money_format($advances_amount) }})</td>
                    <td class="text-right">({{ $transaction->convert_money_format($loans_amount) }})</td>
                    <td class="text-right">({{ $transaction->convert_money_format($absent_deduction) }})</td>
                    <td class="text-right">({{ $transaction->convert_money_format($short_shift_deduction) }})</td>
                    <td class="text-right">{{ $transaction->convert_money_format($gross_salary_amount) }}</td>
                </tr>
            @endforeach
            <tr>
                <th class="text-right" colspan="7">{{ __('lang.total') }}</th>
                <th class="text-right">{{ $transaction->convert_money_format($total_basic_salary) }}</th>
                <th class="text-right">{{ $transaction->convert_money_format($total_overtime_amount) }}</th>
                <th class="text-right">{{ $transaction->convert_money_format($total_allowances_amount) }}</th>
                <th class="text-right">({{ $transaction->convert_money_format($total_deductions_amount) }})</th>
                <th class="text-right">({{ $transaction->convert_money_format($total_advances_amount) }})</th>
                <th class="text-right">({{ $transaction->convert_money_format($total_loans_amount) }})</th>
                <th class="text-right">({{ $transaction->convert_money_format($total_absent_deduction) }})</th>
                <th class="text-right">({{ $transaction->convert_money_format($total_short_shift_deduction) }})</th>
                <th class="text-right">{{ $transaction->convert_money_format($total_gross_salary_amount) }}</th>
            </tr>
        </tbody>
    </table>
    <div class="text-right">
        <p>
            Generated By : {{ $payroll->createdby->name }} on {{ date('d-M-Y g:i A',strtotime($payroll->created_at)) }}
        </p>
    </div>
</div>

@endsection