@extends('admin.layouts.app') @section('content')
| # | Employee | Department | Designation | Days | Prsnt | Late | Pybl | OT Hrs | OT Amt | Basic(Pro) | Bonus | Gross | PF | ESI | PT | TDS | {{--Loan Ded. | --}}Total Ded. | Net Salary | Pay Slip |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ $i++ }} |
{{ $row['employee']->name }}
{{ $row['employee']->employee_code ?? '' }}
|
{{ $row['employee']->department->name ?? '—' }} | {{ $row['employee']->designation->name ?? '—' }} | {{ $row['total_days'] }} | {{ $row['present_days'] }} | {{ $row['late_days'] }} | {{ $row['payable_days'] }} | {{ $row['ot_hours'] > 0 ? $row['ot_hours'] : '-' }} | {{ $row['ot_amount'] > 0 ? number_format($row['ot_amount'], 2) : '-' }} | {{ number_format($row['basic_salary'], 2) }} |
{{ number_format($row['total_bonus'], 2) }}
@if($row['bonuses']->count())
@foreach($row['bonuses'] as $b)({{ $b->bonus_name }})@endforeach
@endif
|
{{ number_format($row['total_additions'], 2) }} | {{ number_format($row['pf_amount'], 2) }} | {{ number_format($row['esi_amount'], 2) }} | {{ number_format($row['pt_amount'], 2) }} | {{ number_format($row['tds'], 2) }} | {{--
{{ number_format($row['total_loan_ded'], 2) }}
@if($row['loans']->count())
@foreach($row['loans'] as $l)({{ $l->loan_type }})@endforeach
@endif
| --}}
{{ number_format($row['total_deductions'], 2) }} | {{ number_format($row['net_salary'], 2) }} | @if(!empty($row['payslip_id'])) View @else — @endif |
| Grand Total Net Salary: | {{ number_format($grandNet, 2) }} | |||||||||||||||||||
Total Employees
{{ $reportData->count() }}
Total Gross
{{ number_format($reportData->sum('total_additions'), 2) }}
Total Deductions
{{ number_format($reportData->sum('total_deductions'), 2) }}
Total Net Payable
{{ number_format($grandNet, 2) }}