<div class="row">
    <div class="col-xs-12">
        <div class="white-box">
            <div class="table-responsive">
                <div class="row">
                    <div class="col-md-12">
                        <table class="dt-column-search table table-responsive mothsumleftfixed tablenewheadfixed"
                            id="organization">
                            <tr>
                                <th colspan="7" style="font-weight:bold;text-align: center;">
                                    {{ $organization->name }} Month Attendance Register - {{ $month_name }}
                                    {{ $year }}
                                </th>
                            </tr>
                            <tr></tr>
                            <tr>
                                <th>Emp Code</th>
                                <th>Employee Name</th>
                                <th>Gender</th>
                                <th>Vendor</th>
                                <th>Location</th>
                                <th>Date of Joining</th>
                                <th>Employee Type</th>
                                <th>Cost Centre</th>
                                <th>Department</th>
                                <th>Process</th>
                                <th>Designation</th>
                                @foreach ($dateList as $date)
                                    <th>{{ date('d/M', strtotime($date)) }}</th>
                                @endforeach
                                <th>Absent</th>
                                <th>Night Duty</th>
                                <th>Day Duty</th>
                                <th>Holiday</th>
                                <th>WeekOff</th>
                                <th>Leaves</th>
                                <th>Incentive Days</th>
                                <th>Extra Days</th>
                                <th>Arrear Days</th>
                                <th>OT Hours</th>
                                <th>Attenance Incentive</th>
                                @foreach ($leaveTypes as $leaveType)
                                    <th colspan="2">{{ strtoupper($leaveType->alias) }} </th>
                                @endforeach

                                <th>Status</th>
                                <th>LWD</th>
                            </tr>
                            <tr>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                @foreach ($dateList as $date)
                                    <th>{{ date('D', strtotime($date)) }}</th>
                                @endforeach

                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                <th>Total</th>
                                @foreach ($leaveTypes as $leaveType)
                                    <th> Taken </th>
                                    <th> Balance </th>
                                @endforeach

                                <th></th>
                            </tr>

                            @foreach ($employees as $employee)
                                @php
                                    $dayPresence = 0;
                                    $nightPresence = 0;
                                    $absent = 0;
                                    $leave = [];
                                    $totalLeave = 0;
                                    $totalWeekOff = 0;
                                    $totalHoliday = 0;
                                    $holidayIncentiveDays = @$employee->payrollAttendance->holiday_incentive_days ?? 0;
                                    $extraDays =
                                        @$employee->payrollAttendance->payrollExtraDayAdditionalDetails->details[
                                            'pay_days'
                                        ] ?? 0;
                                    $ariyorDays = @$employee->payrollAttendance->ariyor_days ?? 0;
                                    $otHours =
                                        @$employee->payrollAttendance->overtime_details['overtime'][
                                            'calculated_overtime'
                                        ] ?? 0;
                                    $attendanceIncentive =
                                        @$employee->payrollAttendance->incentive_details['amount'] ?? 0;
                                @endphp
                                <tr>
                                    <td>{{ $employee->employee_code }}</td>
                                    <td>{{ $employee->name }}</td>
                                    <td>{{ $employee->gender }}</td>
                                    <td>{{ @$employee->contractor->name }}</td>
                                    <td>{{ $employee->locations->pluck('name')->implode(', ') }}</td>
                                    <td>{{ $employee->date_of_joining }}</td>
                                    <td>{{ $employee->employee_type }}</td>
                                    <td>{{ @$employee->workStation->name }}</td>
                                    <td>{{ @$employee->department->name }}</td>
                                    <td>{{ @$employee->subDepartment->name }}</td>
                                    <td>{{ @$employee->designation->name }}</td>
                                    @foreach ($dateList as $date)
                                        @php
                                            $attSummary = $employee->attendanceSummary
                                                ->where('attendance_date', '=', $date)
                                                ->first();
                                            if ($attSummary) {
                                                if (@$attSummary->shift_type == '1') {
                                                    $attSummaryStatus = 'NP';
                                                } else {
                                                    $attSummaryStatus = 'DP';
                                                }

                                                $extraDays += $attSummary->compensation->bal_day_count ?? 0;

                                                if ($attSummary->duty_type == 'incentive') {
                                                    $incentiveDays++;
                                                }

                                                if (@$attSummary->attendance_type == 'absent' && @$attSummary->on_duty== '1') {
                                                    $attSummaryStatus = 'A';
                                                    $absent++;
                                                } elseif ($attSummary->attendance_type == 'week-off') {
                                                    $attSummaryStatus = 'OFF';
                                                    $totalWeekOff++;
                                                } elseif ($attSummary->attendance_type == 'holiday') {
                                                    $attSummaryStatus = 'H';
                                                    $totalHoliday++;
                                                } elseif ((@$attSummary->first_half_status == 'HD' || @$attSummary->first_half_status == 'A') &&
                                                        (!in_array(@$attSummary->status, ['POH', 'POW']))) {
                                                    $attSummaryStatus = 'A:' . $attSummaryStatus;
                                                    $absent += 0.5;
                                                } elseif ((@$attSummary->second_half_status == 'HD' || @$attSummary->second_half_status == 'A') &&
                                                        (!in_array(@$attSummary->status, ['POH', 'POW']))) {
                                                    $attSummaryStatus = $attSummaryStatus . ':A';
                                                    $absent += 0.5;
                                                }


                                                if (
                                                    @$attSummary->leave_type &&
                                                    (@$attSummary->first_half_status == 'L' ||
                                                        @$attSummary->second_half_status == 'L')
                                                ) {
                                                    if (@$attSummary->day_count) {
                                                        $totalLeave += $attSummary->day_count;
                                                    } else {
                                                        $totalLeave++;
                                                    }

                                                    $attSummaryStatus = strtoupper($attSummary->leave_type);
                                                    if (!isset($leave[$attSummaryStatus])) {
                                                        $leave[$attSummaryStatus] = 0;
                                                    }

                                                    if (@$attSummary->day_count) {
                                                        $leave[$attSummaryStatus] += $attSummary->day_count;
                                                    } else {
                                                        $leave[$attSummaryStatus]++;
                                                    }
                                                }
                                            } else {
                                                $attSummaryStatus = 'Inactive';
                                            }

                                            $employeeLeaves = [];

                                            foreach ($employee->employeeLeaves as $l) {
                                                $employeeLeaves[strtoupper($l->leaveType->alias)] = $l;
                                            }

                                            if ($attSummaryStatus == 'NP') {
                                                $nightPresence++;
                                            } elseif ($attSummaryStatus == 'NP:A' || $attSummaryStatus == 'A:NP') {
                                                $nightPresence += 0.5;
                                            }

                                            if ($attSummaryStatus == 'DP') {
                                                $dayPresence++;
                                            } elseif ($attSummaryStatus == 'DP:A' || $attSummaryStatus == 'A:DP') {
                                                $dayPresence += 0.5;
                                            }
                                        @endphp
                                        <td>{{ $attSummaryStatus }}</td>
                                    @endforeach

                                    <th>{{ $absent }}</th>
                                    <th>{{ $nightPresence }}</th>
                                    <th>{{ $dayPresence }}</th>
                                    <th>{{ $totalHoliday }}</th>
                                    <th>{{ $totalWeekOff }}</th>
                                    <th>{{ $totalLeave }}</th>
                                    <th>{{ $holidayIncentiveDays }}</th>
                                    <th>{{ $extraDays }}</th>
                                    <th>{{ $ariyorDays }}</th>
                                    <th>{{ $otHours }}</th>
                                    <th>{{ $attendanceIncentive }}</th>

                                    @foreach ($leaveTypes as $leaveType)
                                        <td>{{ isset($leave[strtoupper($leaveType->alias)]) ? $leave[strtoupper($leaveType->alias)] : 0 }}
                                        </td>

                                        <td>
                                            {{ isset($employeeLeaves[strtoupper($leaveType->alias)]) ? $employeeLeaves[strtoupper($leaveType->alias)]->balance_leaves : 0 }}
                                        </td>
                                    @endforeach


                                    <td>{{ $employee->status }}</td>
                                    <td>{{ @$employee->date_of_leaving }}</td>
                                    <td></td>
                                </tr>
                            @endforeach
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
{{ $organization->name }} Month Attendance Register - {{ $month_name }} {{ $year }}
Emp Code	Employee Name	Gender	Vendor	Location	Date of Joining	Employee Type	Cost Centre	Department	Process	Designation	{{ date('d/M', strtotime($date)) }}	Absent	Night Duty	Day Duty	Holiday	WeekOff	Leaves	Incentive Days	Extra Days	Arrear Days	OT Hours	Attenance Incentive	{{ strtoupper($leaveType->alias) }}		Status	LWD
											{{ date('D', strtotime($date)) }}	Total	Total	Total	Total	Total	Total	Total	Total	Total	Total	Total	Taken	Balance
{{ $employee->employee_code }}	{{ $employee->name }}	{{ $employee->gender }}	{{ @$employee->contractor->name }}	{{ $employee->locations->pluck('name')->implode(', ') }}	{{ $employee->date_of_joining }}	{{ $employee->employee_type }}	{{ @$employee->workStation->name }}	{{ @$employee->department->name }}	{{ @$employee->subDepartment->name }}	{{ @$employee->designation->name }}	{{ $attSummaryStatus }}	{{ $absent }}	{{ $nightPresence }}	{{ $dayPresence }}	{{ $totalHoliday }}	{{ $totalWeekOff }}	{{ $totalLeave }}	{{ $holidayIncentiveDays }}	{{ $extraDays }}	{{ $ariyorDays }}	{{ $otHours }}	{{ $attendanceIncentive }}	{{ isset($leave[strtoupper($leaveType->alias)]) ? $leave[strtoupper($leaveType->alias)] : 0 }}	{{ isset($employeeLeaves[strtoupper($leaveType->alias)]) ? $employeeLeaves[strtoupper($leaveType->alias)]->balance_leaves : 0 }}	{{ $employee->status }}	{{ @$employee->date_of_leaving }}