{{-- Hidden Input --}} {!! Form::hidden('total_days_in_month', $totalDaysInMonth, [ 'id' => 'total_days_in_month', ]) !!} @if (count($employees) > 0) @foreach ($employees as $employee) @php $employeeCTC = employeeCTC($employee->id); $employeeData = employeeData($employee, $startOfMonth, $endOfMonth); $CTC = $employeeCTC->monthly_salary ?? 0; $payableDays = $employeeData['payable_days'] ?? 0; $variablePay = ($employeeCTC->variable_pay_type ?? '') === 'percentage' ? round(($CTC * ($employeeCTC->variable_pay_type_value ?? 10)) / 100) : $employeeCTC->variable_pay_type_value ?? 0; $total = $CTC - $variablePay; $actualDays = ($total / $totalDaysInMonth) * $payableDays; $basic = ($employeeCTC->basic_year_type ?? '') === 'percentage' ? ($actualDays * ($employee->basic_year_type_value ?? 40)) / 100 : $employee->basic_year_type_value ?? 0; $hra = $basic * 0.5; $otherAllowance = $actualDays - ($basic + $hra); $schemeIncentive = 0; $grossSalary = $basic + $hra + $otherAllowance; $PF = ($employeeCTC->employee_pf_type ?? '') === 'percentage' ? ($basic * ($employeeCTC->employee_pf_type_value ?? 12)) / 100 : $employeeCTC->employee_pf_type_value ?? 0; $ESIC = 0; $professionalTax = 200; $gratuity = ($employeeCTC->gratuity_type ?? '') === 'percentage' ? ($basic * ($employeeCTC->gratuity_type_value ?? 4.81)) / 100 : $employeeCTC->gratuity_type_value ?? 0; $advanceOrLoan = 0; $mediclaim = 0; $TDS = 0; $netDeduction = $PF + $ESIC + $professionalTax + $gratuity + $advanceOrLoan + $mediclaim + $TDS; $netSalary = $grossSalary - $netDeduction; $employerPF = ($employeeCTC->employer_pf_type ?? '') === 'percentage' ? ($basic * ($employeeCTC->employer_pf_type_value ?? 12)) / 100 : $employeeCTC->employer_pf_type_value ?? 0; $totalNetSalary = $grossSalary + $employerPF; @endphp @if ($CTC > 0) @endif @endforeach @endif
SALARY FOR THE MONTH OF {{ date('F - Y', strtotime($salaryMonth . '-01')) }}
{!! Form::checkbox('select_all', null, false, ['id' => 'select_all']) !!} Sr. Name of Employee with Designation Employee Code CTC Variable Pay Total Actual Days Days Earnings Deduction Net Salary (Employees) PF (Employer) Total Net Salary
(Including Employer PF)
Basic HRA Other Allowance Scheme Incentive Gross Salary PF ESIC Professional Tax Gratuity Advance/Loan Mediclaim TDS Net Deduction
{!! Form::checkbox('selected_employees[]', $employee->id, false, ['class' => 'employee-checkbox']) !!} {{ $loop->iteration }} {{ $employee->employee_name ?? '-' }} ({{ $employee->employeeDesignation->name ?? '-' }}) {{ $employee->employee_code ?? '-' }} {!! Form::text('employees[' . $employee->id . '][ctc]', $CTC, [ 'class' => 'form-control w-100', 'id' => 'ctc_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::hidden('employees[' . $employee->id . '][variable_pay_type]', $employeeCTC->variable_pay_type ?? '', [ 'id' => 'variable_pay_type_' . $employee->id, ]) !!} {!! Form::hidden( 'employees[' . $employee->id . '][variable_pay_type_value]', $employeeCTC->variable_pay_type_value ?? 10, [ 'id' => 'variable_pay_type_value_' . $employee->id, ], ) !!} {!! Form::text('employees[' . $employee->id . '][variable_pay]', $variablePay, [ 'class' => 'form-control w-100', 'id' => 'variable_pay_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][total]', $total, [ 'class' => 'form-control w-100', 'id' => 'total_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][actual_days]', round($actualDays), [ 'class' => 'form-control w-100', 'id' => 'actual_days_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][days]', $payableDays, [ 'class' => 'form-control w-100 number', 'id' => 'days_' . $employee->id, 'readonly' => false, 'onkeyup' => 'calculateSalary(' . $employee->id . ')', ]) !!} {!! Form::hidden('employees[' . $employee->id . '][basic_year_type]', $employeeCTC->basic_year_type ?? '', [ 'id' => 'basic_year_type_' . $employee->id, ]) !!} {!! Form::hidden( 'employees[' . $employee->id . '][basic_year_type_value]', $employeeCTC->basic_year_type_value ?? 10, [ 'id' => 'basic_year_type_value_' . $employee->id, ], ) !!} {!! Form::text('employees[' . $employee->id . '][basic]', round($basic), [ 'class' => 'form-control w-100', 'id' => 'basic_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][hra]', round($hra), [ 'class' => 'form-control w-100', 'id' => 'hra_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][other_allowance]', round($otherAllowance), [ 'class' => 'form-control w-100', 'id' => 'other_allowance_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][scheme_incentive]', $schemeIncentive, [ 'class' => 'form-control w-100', 'id' => 'scheme_incentive_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][gross_salary]', round($grossSalary), [ 'class' => 'form-control w-100', 'id' => 'gross_salary_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::hidden('employees[' . $employee->id . '][employee_pf_type]', $employeeCTC->employee_pf_type ?? '', [ 'id' => 'employee_pf_type_' . $employee->id, ]) !!} {!! Form::hidden( 'employees[' . $employee->id . '][employee_pf_type_value]', $employeeCTC->employee_pf_type_value ?? 10, [ 'id' => 'employee_pf_type_value_' . $employee->id, ], ) !!} {!! Form::text('employees[' . $employee->id . '][employee_pf]', round($PF), [ 'class' => 'form-control w-100', 'id' => 'employee_pf_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][esic]', $ESIC, [ 'class' => 'form-control w-100 amount', 'id' => 'esic_' . $employee->id, 'readonly' => false, 'onkeyup' => 'calculateSalary(' . $employee->id . ')', ]) !!} {!! Form::text('employees[' . $employee->id . '][professional_tax]', $professionalTax, [ 'class' => 'form-control w-100 amount', 'id' => 'professional_tax_' . $employee->id, 'readonly' => false, 'onkeyup' => 'calculateSalary(' . $employee->id . ')', ]) !!} {!! Form::hidden('employees[' . $employee->id . '][gratuity_type]', $employeeCTC->gratuity_type ?? '', [ 'id' => 'gratuity_type_' . $employee->id, ]) !!} {!! Form::hidden( 'employees[' . $employee->id . '][gratuity_type_value]', $employeeCTC->gratuity_type_value ?? 10, [ 'id' => 'gratuity_type_value_' . $employee->id, ], ) !!} {!! Form::text('employees[' . $employee->id . '][gratuity]', round($gratuity), [ 'class' => 'form-control w-100', 'id' => 'gratuity_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][advance_or_loan]', $advanceOrLoan, [ 'class' => 'form-control w-100 amount', 'id' => 'advance_or_loan_' . $employee->id, 'readonly' => false, 'onkeyup' => 'calculateSalary(' . $employee->id . ')', ]) !!} {!! Form::text('employees[' . $employee->id . '][mediclaim]', $mediclaim, [ 'class' => 'form-control w-100 amount', 'id' => 'mediclaim_' . $employee->id, 'readonly' => false, 'onkeyup' => 'calculateSalary(' . $employee->id . ')', ]) !!} {!! Form::text('employees[' . $employee->id . '][tds]', $TDS, [ 'class' => 'form-control w-100 amount', 'id' => 'tds_' . $employee->id, 'readonly' => false, 'onkeyup' => 'calculateSalary(' . $employee->id . ')', ]) !!} {!! Form::text('employees[' . $employee->id . '][net_deduction]', round($netDeduction), [ 'class' => 'form-control w-100', 'id' => 'net_deduction_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][net_salary]', round($netSalary), [ 'class' => 'form-control w-100', 'id' => 'net_salary_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::hidden('employees[' . $employee->id . '][employer_pf_type]', $employeeCTC->employer_pf_type ?? '', [ 'id' => 'employer_pf_type_' . $employee->id, ]) !!} {!! Form::hidden( 'employees[' . $employee->id . '][employer_pf_type_value]', $employeeCTC->employer_pf_type_value ?? 10, [ 'id' => 'employer_pf_type_value_' . $employee->id, ], ) !!} {!! Form::text('employees[' . $employee->id . '][employer_pf]', round($employerPF), [ 'class' => 'form-control w-100', 'id' => 'employer_pf_' . $employee->id, 'readonly' => true, ]) !!} {!! Form::text('employees[' . $employee->id . '][total_net_salary]', round($totalNetSalary), [ 'class' => 'form-control w-100', 'id' => 'total_net_salary_' . $employee->id, 'readonly' => true, ]) !!}