| # | Staff Name | Attendance Date | Salary | Total Working Hours | Hour Based Salary | Per Day Salary | Paid Leave Days | Paid Leave Amt | Present Days | Half Day | Full Day | One & Half Day | Double Duty | Hour Based | Day Based Salary | Advance | Balance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ $i + 1 }} | {{ $item['staff_name'] }} | {{ $item['attendance_date'] }} | ₹ {{ number_format($item['salary'], 2) }} | {{ $item['total_working_hours'] }} | ₹ {{ number_format($item['hour_based_salary'], 2) }} | ₹ {{ number_format($item['per_day_salary'], 2) }} | {{ $item['paid_leave_days'] }} | ₹ {{ number_format($item['paid_leave_amount'], 2) }} | {{ $item['present_days'] }} | {{ $item['half_day_count'] }} | {{ $item['full_day_count'] }} | {{ $item['one_half_day_count'] }} | {{ $item['double_duty_count'] }} | {{ $item['hour_based_count'] }} | ₹ {{ number_format($item['day_based_salary'], 2) }} | ₹ {{ number_format($item['advance'], 2) }} | ₹ {{ number_format($item['balance'], 2) }} |
| Total | ₹ {{ number_format($data->sum('salary'), 2) }} | ₹ {{ number_format($data->sum('hour_based_salary'), 2) }} | {{ $data->sum('paid_leave_days') }} | ₹ {{ number_format($data->sum('paid_leave_amount'), 2) }} | {{ $data->sum('present_days') }} | {{ $data->sum('half_day_count') }} | {{ $data->sum('full_day_count') }} | {{ $data->sum('one_half_day_count') }} | {{ $data->sum('double_duty_count') }} | {{ $data->sum('hour_based_count') }} | ₹ {{ number_format($data->sum('day_based_salary'), 2) }} | ₹ {{ number_format($data->sum('advance'), 2) }} | ₹ {{ number_format($data->sum('balance'), 2) }} | ||||