@extends('reports.layout')
@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">{{ trans('master/master.monthly_performance_report') }}</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="home">{{ trans('common/common.home') }}</a>
                    </li>
                    <li class="breadcrumb-item active">{{ trans('master/master.performance_register') }}
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">
        <!-- Filters -->
        <div class="content-header row">
            <div class="content-header-left col-md-9 col-12 mb-2">
                <div class="row breadcrumbs-top">
                    <div class="col-12">
                        <h2 class="content-header-title float-start mb-0"></h2>
                    </div>
                </div>
            </div>
            <div class="content-header-right text-md-end col-md-3 col-12 d-md-block d-none">
                <div class="mb-1 breadcrumb-right">
                    <div class="dropdown">
                        <button class="btn-icon btn btn-primary btn-round btn-sm dropdown-toggle" type="button"
                            data-bs-toggle="offcanvas" data-bs-target="#offcanvasEnd" aria-controls="offcanvasEnd"
                            type="button"><i data-feather='filter'></i></button>
                    </div>
                </div>
            </div>
        </div>

        <form action="{{ "$orgUrl/attendance-report/performance-register" }}" id="filter-form" method="GET">
            @include('reports.filters')
        </form>
        <!-- // Filters // -->

        <div class="row" id="table-responsive">
            <div class="col-12">
                <div class="card">
                    <div class="card-header border-bottom">
                        <div class="head-label">
                            <ul class="demo-inline-spacing mt-0 mb-0" style="margin-left:-2em">
                                <li class="badge badge-glow bg-light-warning"><strong>Leave</strong> - L</li>
                                <li class="badge badge-glow bg-light-primary"><strong>Holiday</strong> - H</li>
                                <li class="badge badge-glow bg-light-secondary"><strong>Week-Off</strong> - WO</li>
                                <li class="badge badge-glow bg-light-sky text-light-sky">
                                    <strong>{{ ucfirst(App\Helpers\ConstantHelper::MODIFIED) }}</strong>
                                </li>
                                <li class="badge badge-glow bg-light-green text-light-green">
                                    <strong>{{ ucfirst(App\Helpers\ConstantHelper::REGULARIZED) }}</strong>
                                </li>
                            </ul>
                        </div>
                        <div class="dt-action-buttons text-end">
                            <div class="dropdown">
                                <a class="btn btn-primary dropdown-toggle" href="#" role="button"
                                    id="dropdownMenuLink" data-bs-toggle="dropdown" aria-expanded="false">
                                    Export
                                </a>
                                <ul class="dropdown-menu" aria-labelledby="dropdownMenuLink">
                                    <li>
                                        <a target="_blank"
                                            href="{{ $orgUrl }}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'pdf'])) }}"
                                            class="dropdown-item" id="exportToPdf">
                                            <span>PDF</span>
                                        </a>
                                    </li>
                                    <li>
                                        <a target="_blank"
                                            href="{{ $orgUrl }}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'excel'])) }}"
                                            class="dropdown-item">
                                            <span>Excel</span>
                                        </a>
                                    </li>
                                    <li>
                                        <a target="_blank"
                                            href="{{ $orgUrl }}/attendance-report/performance-register?{{ http_build_query(array_merge(request()->query(), ['type' => 'csv'])) }}"
                                            class="dropdown-item">
                                            <span>CSV</span>
                                        </a>
                                    </li>
                                    <li>
                                        <a href="#" class="dropdown-item" id="exportExcelAsync"
                                            data-async-url="{{ $orgUrl }}/attendance-report/performance-register/export-async?{{ http_build_query(request()->query()) }}">
                                            <span>Excel (Background)</span>
                                        </a>
                                    </li>
                                </ul>
                            </div>
                            <span id="exportAsyncStatus" class="ms-1"></span>
                        </div>
                    </div>
                    <div class="card-body">
                    </div>
                    <div class="table-responsive persumleftfixed">
                        <table class="table mb-0">
                            <tbody>
                                @foreach ($attendanceSummary as $value)
                                    <tr
                                        style="background-color:rgb(4, 23, 49); color:white; border-top: 5px solid transparent;">
                                        <td class="text-nowrap" colspan="{{ count($dateArr) / 2 }}">
                                            <div style="background-color:rgb(4, 23, 49);" class="d-inline-block">
                                                <strong>{{ trans('master/master.name') }}:</strong>:
                                                {{ $value->name }}
                                                <span class="employeecodereport">
                                                    ({{ $value->employee_code }})
                                                </span> &emsp;
                                                @if ($value->aadhar_number && isset($customFields) && in_array('aadhar_number', $customFields))
                                                    <span class="employeecodereport">
                                                        ( Aadhar : {{ $value->aadhar_number }})
                                                    </span> &emsp;
                                                @endif

                                                @if ($value->date_of_joining && isset($customFields) && in_array('date_of_joining', $customFields))
                                                    <span class="employeecodereport">
                                                        (DOJ :{{ $value->date_of_joining }})
                                                    </span> &emsp;
                                                @endif

                                                <strong>{{ trans('master/master.employee_type') }}:</strong>
                                                {{ ucwords($value->employee_type) }}
                                            </div>
                                        </td>

                                        <td class="text-nowrap" colspan="{{ count($dateArr) / 2 + 2 }}" class="text-right">
                                            
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="background: white"></td>
                                        @foreach ($dateArr as $dates)
                                            <td class="text-nowrap">{{ date('d', strtotime($dates)) }}</td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        @php
                                            $atSummary = $value->attendanceSummary->keyBy('attendance_date');
                                        @endphp
                                        <td class="text-nowrap" style="background: white">
                                            <strong>{{ trans('master/master.in') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif
                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                                if (
                                                    @$attendance->entry_mode == App\Helpers\ConstantHelper::REGULARIZED
                                                ) {
                                                    $boxColor = 'bg-light-green';
                                                } elseif (
                                                    @$attendance->entry_mode == App\Helpers\ConstantHelper::MODIFIED
                                                ) {
                                                    $boxColor = 'bg-light-sky';
                                                } else {
                                                    $boxColor = '';
                                                }
                                            @endphp
                                            <td class="text-nowrap {{ $boxColor }}">
                                                {{ $attendance->in_time ? date('H:i', strtotime($attendance->in_time)) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="background: white">
                                            <strong>{{ trans('master/master.out') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                                if (
                                                    @$attendance->entry_mode == App\Helpers\ConstantHelper::REGULARIZED
                                                ) {
                                                    $boxColor = 'bg-light-green';
                                                } elseif (
                                                    @$attendance->entry_mode == App\Helpers\ConstantHelper::MODIFIED
                                                ) {
                                                    $boxColor = 'bg-light-sky';
                                                } else {
                                                    $boxColor = '';
                                                }
                                            @endphp
                                            <td class="text-nowrap {{ $boxColor }}">
                                                {{ $attendance->out_time ? date('H:i', strtotime($attendance->out_time)) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    <tr>
                                        <td class="text-nowrap" style="background: white">
                                            <strong>{{ trans('attendance/admin.working_hours') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                            @endphp
                                            <td class="text-nowrap">
                                                {{ $attendance->working_time && $attendance->working_time != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->working_time) : '-' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                    @if ($user->can_role('Performance Incentive Hours'))
                                        <tr>
                                            <td class="text-nowrap" style="background: white">
                                                <strong>{{ trans('master/master.incentive_hours') }}: </strong>
                                            </td>
                                            @foreach ($dateArr as $date)
                                                @if (!isset($atSummary[$date]))
                                                    <td>
                                                        -
                                                    </td>

                                                    @continue;
                                                @endif

                                                @php
                                                    $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                                @endphp

                                                <td class="text-nowrap">
                                                    {{ $attendance->incentive_hours && $attendance->incentive_hours != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->incentive_hours) : '-' }}
                                                </td>
                                            @endforeach
                                        </tr>
                                    @endif
                                    
                                    <tr>
                                        <td class="text-nowrap" style="background: white">
                                            <strong>{{ trans('master/master.final_status') }}: </strong>
                                        </td>
                                        @foreach ($dateArr as $date)
                                            @if (!isset($atSummary[$date]))
                                                <td>
                                                    -
                                                </td>

                                                @continue;
                                            @endif

                                            @php
                                                $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null;
                                                $autoWeekClass =
                                                    $attendance->remarks == App\Helpers\ConstantHelper::AUTO_WEEK_OFF
                                                        ? 'autoweekoff'
                                                        : '';

                                                $bgColor = '';
                                                if (
                                                    $attendance->attendance_type == 'leave' ||
                                                    $attendance->on_duty == 4
                                                ) {
                                                    $bgColor = 'bg-light-warning';
                                                }

                                                if (
                                                    $attendance->attendance_type == 'holiday' ||
                                                    $attendance->on_duty == 3
                                                ) {
                                                    $bgColor = 'bg-light-primary';
                                                }

                                                if (
                                                    $attendance->attendance_type == 'week-off' ||
                                                    $attendance->on_duty == 2
                                                ) {
                                                    $bgColor = 'bg-light-secondary';
                                                }
                                            @endphp
                                            <td class="text-nowrap {{ $bgColor }} {{ $autoWeekClass }}">
                                                @php
                                                    $status = '-';
                                                
                                                    $first = strtoupper(trim($attendance->first_half_status));
                                                    $second = strtoupper(trim($attendance->second_half_status));

                                                    if ($first === 'A' && $second === 'A') {
                                                        $status = 'A';

                                                    } elseif (in_array($attendance->on_duty, [2, 3, 4])) {
                                                        $status = $attendance->status ?? '-';

                                                    } elseif (
                                                        ($first === 'P' || $first === 'HD') ||
                                                        ($second === 'P' || $second === 'HD')
                                                    ) {
                                                        $status = 'P';

                                                    } else {
                                                        $status = $attendance->status ?? '-';
                                                    }

                                                    if ($status === 'POH') {
                                                        $status = 'HP';
                                                    }
                                                @endphp
                                                {{ $status }} {{ $attendance->is_wfh ? '(WFH)' : '' }}
                                            </td>
                                        @endforeach
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                        <br>
                        {{ $attendanceSummary->appends(request()->except('page'))->links('pagination::bootstrap-4') }}
                    </div>
                </div>
            </div>
        </div>

    </section>
    <!--/ Column Search -->
@endsection
@push('custom-footer-script')
<script>
    let hasPreviousMonthInDateRange = @json($hasPreviousMonthInDateRange);
    function initializeDateRange(month = null, year = null, orgType = null) {
            if (month && year) {
                month = String(month).padStart(2, '0');
                let current = moment(month + '/01/' + year, 'MM/DD/YYYY');
                let fromDate, toDate;

                if (hasPreviousMonthInDateRange) {
                    fromDate = current.clone().subtract(1, 'month').startOf('month').format('MM/DD/YYYY');
                    toDate = current.clone().endOf('month').format('MM/DD/YYYY');
                } else {
                    fromDate = current.clone().startOf('month').format('MM/DD/YYYY');
                    toDate = current.clone().endOf('month').format('MM/DD/YYYY');
                }

                $('input[name="date_range"]').daterangepicker({
                    minDate: fromDate,
                    maxDate: toDate,
                    startDate: fromDate,
                    endDate: toDate,
                });

            } else {
                $('input[name="date_range"]').daterangepicker();
            }
        }

    document.getElementById('exportExcelAsync').addEventListener('click', function(e) {
        e.preventDefault();
        let statusEl = document.getElementById('exportAsyncStatus');
        statusEl.textContent = 'Starting export...';

        fetch(this.dataset.asyncUrl)
            .then(res => res.json())
            .then(data => {
                statusEl.textContent = 'Processing...';
                let poll = setInterval(function() {
                    fetch(data.status_url)
                        .then(res => res.json())
                        .then(status => {
                            if (status.status === 'completed') {
                                clearInterval(poll);
                                statusEl.innerHTML = '<a href="' + status.download_url + '" target="_blank">Download ready</a>';
                            } else if (status.status === 'failed') {
                                clearInterval(poll);
                                statusEl.textContent = 'Export failed. Please try again.';
                            }
                        });
                }, 3000);
            })
            .catch(() => {
                statusEl.textContent = 'Failed to start export.';
            });
    });
    </script>
@endpush