| Employee: {{ $employeeName }} | Salary Month: {{ $salaryMonth }} |
| Salary Period: {{ $salaryPeriod }} | Generated: {{ $generatedDate ?? now()->format('d-m-Y h:i A') }} |
|
Fixed Monthly Salary
{{ $money($summary['monthly_salary'] ?? 0) }}
|
Attendance Earnings
{{ $money($summary['attendance_earnings'] ?? 0) }}
|
Total Deductions
{{ $money(
($summary['leave_deduction'] ?? 0) +
($summary['permission_deduction'] ?? 0) +
($summary['advance_deduction'] ?? 0)
) }}
|
Final Payable Salary
{{ $money($finalSalary) }}
|
|
Present Days
{{ $summary['present_days'] ?? 0 }}
|
Absent Days
{{ $summary['absent_days'] ?? 0 }}
|
Advance Summary - Total Paid
{{ $money($totalAdvance) }}
|
Petrol Summary - Total KM
{{ number_format((float) $totalKm, 2) }} KM
Total Petrol Amount
{{ $money($petrolAmount) }}
|
| Scheduled Working Days {{ $summary['working_days'] ?? 0 }} | Present Days {{ $summary['present_days'] ?? 0 }} | Absent Days {{ $summary['absent_days'] ?? 0 }} | Total Worked Hours {{ $summary['total_worked_hours'] ?? 0 }} |
| Late Arrivals {{ $summary['late_arrivals'] ?? 0 }} | Total Break Minutes {{ $summary['total_break_minutes'] ?? 0 }} | Allowed Break Minutes / Day {{ $summary['allowed_break_minutes_per_day'] ?? 0 }} | Daily Salary {{ $money($summary['daily_salary'] ?? 0) }} |
| Holiday Count {{ $calculation['holiday_count'] ?? $data['holidays']['holiday_count'] ?? 0 }} | Holiday Earnings {{ $money($summary['holiday_earned'] ?? 0) }} |
| Date | Status | Check In | Check Out | Break Minutes | Worked Hours | Late Details |
|---|---|---|---|---|---|---|
| {{ $date(data_get($row, 'date')) }} | {{ data_get($row, 'status', '-') }} | {{ $time(data_get($row, 'check_in_time')) }} | {{ $time(data_get($row, 'check_out_time')) }} | {{ data_get($row, 'break_minutes', 0) }} | {{ data_get($row, 'worked_hours', 0) }} | {{ data_get($row, 'late_reason', '-') }} |
| No attendance details available | ||||||
| Total Leave Days {{ $summary['leave_days'] ?? 0 }} | Paid Leave Allowance {{ $summary['paid_leave_allowance'] ?? 0 }} | Paid Leave Days Counted {{ $summary['paid_leave_days'] ?? 0 }} | Excess Leave Days {{ $summary['excess_leave_days'] ?? 0 }} |
| Leave Date | Leave Reason | Leave Status | Paid / Unpaid | Daily Rate | Deduction |
|---|---|---|---|---|---|
| {{ $date($value($row, ['date', 'leave_date', 'attendance_date'])) }} | {{ $value($row, ['reason', 'leave_reason', 'remarks']) }} | {{ $value($row, ['status', 'leave_status']) }} | {{ $value($row, ['paid_status', 'paid_unpaid', 'payment_type', 'leave_type']) }} | {{ $money($value($row, ['daily_salary', 'daily_rate'], 0)) }} | {{ $money($value($row, ['deduction', 'leave_deduction', 'deduction_amount'], 0)) }} |
| No leave details available | |||||
| Total Leave Deduction | {{ $money($summary['leave_deduction'] ?? 0) }} |
| Permission Instances {{ $summary['permission_count'] ?? 0 }} | Total Permission Hours {{ $summary['permission_hours'] ?? 0 }} | Allowed Monthly Hours {{ $summary['allowed_monthly_hours'] ?? 0 }} | Permission Deduction {{ $money($summary['permission_deduction'] ?? 0) }} |
| Date | From | To | Duration | Status | Paid? | Deduction |
|---|---|---|---|---|---|---|
| {{ $date($value($row, ['date', 'permission_date'])) }} | {{ $value($row, ['from', 'from_time', 'start_time']) }} | {{ $value($row, ['to', 'to_time', 'end_time']) }} | {{ $value($row, ['duration', 'duration_hours', 'hours']) }} | {{ $value($row, ['status']) }} | {{ $value($row, ['is_paid', 'paid_status', 'paid'], '-') }} | {{ $money($value($row, ['deduction', 'permission_deduction', 'deduction_amount'], 0)) }} |
| No permission details available | ||||||
| Total Advances Paid {{ $money($summary['total_advance_paid'] ?? 0) }} | Total Advance Adjusted {{ $money($summary['total_advance_adjusted'] ?? 0) }} | Outstanding Advance {{ $money($summary['outstanding_advance'] ?? 0) }} | Advance Deduction This Salary {{ $money($summary['advance_deduction'] ?? 0) }} |
| Advance Date | Amount Paid | Adjusted | Outstanding | Payment Mode | Transaction ID | Status |
|---|---|---|---|---|---|---|
| {{ $date(data_get($row, 'advance_date')) }} | {{ $money(data_get($row, 'amount', 0)) }} | {{ $money(data_get($row, 'adjusted', 0)) }} | {{ $money(data_get($row, 'outstanding', 0)) }} | {{ data_get($row, 'payment_mode', '-') }} | {{ data_get($row, 'transaction_id', '-') }} | {{ data_get($row, 'status', '-') }} |
| No advance history available | ||||||
| Allowance Enabled {{ !empty($petrol['enabled']) ? 'Yes' : 'No' }} | Vehicle Type {{ $petrol['vehicle_type'] ?? 'Own Bike' }} | Total KM Travelled {{ number_format((float) $totalKm, 2) }} KM | Petrol Rate / KM {{ $money($petrol['km_rate'] ?? 0) }} |
| Total Petrol Allowance {{ $money($petrolAmount) }} | Petrol Records {{ $petrol['total_records'] ?? 0 }} |
| Date | Vehicle | Start KM | End KM | Total KM | Status |
|---|---|---|---|---|---|
| {{ $date(data_get($row, 'date')) }} | {{ data_get($row, 'vehicle_type', 'Own Bike') }} | {{ number_format((float) data_get($row, 'start_km', 0), 2) }} | {{ number_format((float) data_get($row, 'end_km', 0), 2) }} | {{ number_format((float) data_get($row, 'total_km', 0), 2) }} | {{ data_get($row, 'status', '-') }} |
| No petrol records available | |||||
| Fixed Monthly Salary | {{ $money($summary['monthly_salary'] ?? 0) }} |
| Attendance-based Earnings | {{ $money($summary['attendance_earnings'] ?? 0) }} |
| Paid Leave Earnings | {{ $money($summary['paid_leave_earnings'] ?? 0) }} |
| Leave Deduction | −{{ $money($summary['leave_deduction'] ?? 0) }} |
| Permission Deduction | −{{ $money($summary['permission_deduction'] ?? 0) }} |
| Salary Before Advance Adjustment | {{ $money($summary['salary_before_advance'] ?? 0) }} |
| Outstanding Advance Deduction | −{{ $money($summary['advance_deduction'] ?? 0) }} |
| Salary After Advance Deduction | {{ $money($summary['salary_after_advance_deduction'] ?? 0) }} |
| Holiday Count | {{ $calculation['holiday_count'] ?? 0 }} |
| Total Petrol Travelled KM | {{ number_format((float) $totalKm, 2) }} KM |
| Petrol Allowance Rate | {{ $money($summary['km_rate'] ?? 0) }} / KM |
| Petrol Allowance | {{ $money($petrolAmount) }} |
| Final Payable Salary | {{ $money($finalSalary) }} |
| Payment Status {{ $summary['payment_status'] ?? 'Pending' }} | Payment Date {{ $date($summary['payment_date'] ?? null) }} | Payment Mode {{ $summary['payment_mode'] ?? '-' }} | Paid Amount {{ $money($summary['paid_amount'] ?? 0) }} |