@extends('layouts.sidebar')
@section('title', 'Payroll')
@section('content')
    @if (in_array('Payroll Checking', $privileges) || in_array('Payroll Approve', $privileges))


        <div class="py-3 text-sm text-center">
            <div class="flex items-center justify-center">
                <img class="w-32" src="{{ asset($data->client->client->agency->contact_person) }}">
            </div>
            <h1 class="font-bold ">{{ $data->client->client->agency->name }} </h1>
            <p class="font-bold ">
                {{ $data->client->department_name }} Summary Payroll report with Batch ID: {{ $batch_id }}
            </p>
            <p class="font-bold ">Period Cover: {{ \Carbon\Carbon::parse($data->pay_period_start)->format('F j, Y') }}
                to
                {{ \Carbon\Carbon::parse($data->pay_period_end)->format('F j, Y') }}</p>
        </div>

        @if (session('success'))
            <div class="p-4 mb-4 text-white bg-green-500">
                {{ session('success') }}
            </div>
        @endif
        <div class="flex justify-end p-5 text-sm gap-3">
            <div>
                <label for="display_late">
                    <input type="checkbox" id="display_late" {{ $data->display_late ? 'checked' : '' }}
                        onchange="toggleDisplayLate({{ $data->id }})">
                    Display Late
                </label>
            </div>
            <script>
                function toggleDisplayLate(batchcodeId) {
                    const isChecked = document.getElementById('display_late').checked;

                    axios.post("{{ route('batchcode.toggleDisplayLate', ['id' => '__id__']) }}".replace('__id__', batchcodeId), {
                            display_late: isChecked ? 1 : 0
                        })
                        .then(response => {
                            console.log('Updated:', response.data);
                            $('#payrollsDataTable').DataTable().ajax.reload(null,
                                false);
                        })
                        .catch(error => {
                            console.error('Error updating display_late:', error);
                        });
                }
            </script>
            <div><a href="{{ route('payroll.report.download', ['batchId' => $batch_id, 'clientId' => $data->client->id]) }}"
                    class="px-4 py-2 text-white bg-blue-500 rounded-md">
                    Download Payroll Report
                </a></div>

        </div>

        <div class="overflow-hidden ">
            <table id="payrollsDataTable" class="min-w-full border border-collapse border-gray-200 rounded shadow-md">
                <thead>
                    <tr class="text-sm leading-normal uppercase ">
                        <th>ID</th>
                        <th>Employee Name</th>
                        <th class="">Rate</th>
                        <th class="">Earnings</th>
                        <th class="">Deductions</th>
                        <th class="">netpay</th>
                        <th class="bg-yellow-300">Action</th>
                    </tr>
                </thead>
                <tbody class="text-sm font-light text-center text-gray-600">
                </tbody>
                <tfoot>
                    <tr>
                        <th colspan="2" class="text-center">Total</th>
                        <th class="text-center" id="totalRate">0</th>
                        <th class="text-center" id="totalEarnings">0</th>
                        <th class="text-center" id="totalDeductions">0</th>
                        <th class="text-center" id="totalNetPay">0</th>
                        <th class="text-center"></th>
                    </tr>
                </tfoot>
            </table>
        </div>



        <div class="grid grid-cols-5 gap-10 overflow-auto ">

            <div class="col-span-3">
                <p class="mt-5 mb-2 text-xs font-bold">SUMMARY</p>
                <table class="max-w-full min-w-full rounded-lg shadow-md">
                    <thead class="border-2 border-black">
                        <tr class="text-sm text-gray-700">
                            <th class="px-4 border-b">Trx Name</th>
                            <th class="px-4 border-b">Earnings</th>
                            <th class="px-4 border-b">Deduction</th>
                        </tr>
                    </thead>
                    <tbody class="text-xs font-light text-center text-gray-600 border-b-2 border-black">
                        @php
                            $totalEarnings = 0;
                            $totalDeductions = 0;
                        @endphp




                        {{-- Basic Salary --}}
                        @php
                            $basicSalaryTotal = 0;
                            $days = 0;
                        @endphp

                        @foreach ($payrolls as $payroll)
                            @php
                                $basicSalary = $payroll->days_worked_withdeduction * $payroll->rate;
                                $basicSalaryTotal += $basicSalary;
                                $days += $payroll->rate;

                            @endphp
                        @endforeach

                        <tr class="hover:bg-gray-100">
                            <td class="px-4 py-2 border-b">Basic Salary - {{ $days }}</td>
                            <td class="px-4 py-2 border-b">₱{{ number_format($basicSalaryTotal, 2) }}</td>
                            <td class="px-4 py-2 border-b"></td>
                        </tr>
                        @php
                            $totalEarnings += $basicSalaryTotal;
                        @endphp












                        {{-- Earnings from othersForPayroll --}}
                        @php
                            $groupedOthers = [];

                            foreach ($payrolls as $payroll) {
                                foreach ($payroll->othersForPayroll as $earning) {
                                    $name = $earning->name;
                                    if (!isset($groupedOthers[$name])) {
                                        $groupedOthers[$name] = 0;
                                    }
                                    $groupedOthers[$name] += $earning->amount;
                                }
                            }
                        @endphp

                        @foreach ($groupedOthers as $name => $amount)
                            <tr class="hover:bg-gray-100">
                                <td class="px-4 py-2 border-b">{{ $name }}</td>
                                <td class="px-4 py-2 border-b">₱{{ number_format($amount, 2) }}</td>
                                <td class="px-4 py-2 border-b"></td>
                            </tr>
                            @php $totalEarnings += $amount; @endphp
                        @endforeach
                        @php
                            // Initialize an empty array to hold the grouped benefits by type
                            $groupedBenefits = [];

                            // Group the benefits by their type
                            foreach ($payrolls as $payroll) {
                                foreach ($payroll->benefits as $benefits) {
                                    if (!isset($groupedBenefits[$benefits->type])) {
                                        $groupedBenefits[$benefits->type] = 0;
                                    }
                                    $groupedBenefits[$benefits->type] += $benefits->employee_share;
                                }
                            }
                        @endphp

                        @foreach ($groupedBenefits as $type => $totalShare)
                            <tr class="hover:bg-gray-100">
                                <td class="px-4 py-2 border-b">{{ $type }}</td>
                                <td class="px-4 py-2 border-b"></td>
                                <td class="px-4 py-2 border-b">₱{{ number_format($totalShare, 2) }}</td>
                            </tr>
                            @php $totalDeductions += $totalShare; @endphp
                        @endforeach


                        @foreach ($groupedDeductions as $group)
                            <tr class="hover:bg-gray-100">
                                <td class="px-4 py-2 border-b">
                                    {{ $group['description'] }}
                                </td>
                                <td class="px-4 py-2 border-b">
                                    @if ($group['earnings'] > 0)
                                        ₱{{ number_format($group['earnings'], 2) }}
                                        @php $totalEarnings += $group['earnings']; @endphp
                                    @endif
                                </td>
                                <td class="px-4 py-2 border-b">
                                    @if ($group['deductions'] > 0)
                                        ₱{{ number_format($group['deductions'], 2) }}
                                        @php $totalDeductions += $group['deductions']; @endphp
                                    @endif
                                </td>
                            </tr>
                        @endforeach

                        {{-- trxLoanDeductions --}}
                        @foreach ($payrolls as $payroll)
                            @foreach ($payroll->trxLoanDeductions as $loan)
                                <tr class="hover:bg-gray-100">
                                    <td class="px-4 py-2 border-b">
                                        {{ optional(App\Models\TrxCode::find($loan->trxLoan->group_code_id))->description }}
                                    </td>
                                    <td class="px-4 py-2 border-b"></td>
                                    <td class="px-4 py-2 border-b">
                                        ₱{{ number_format($loan->Amount, 2) }}
                                        @php $totalDeductions += $loan->Amount; @endphp
                                    </td>
                                </tr>
                            @endforeach
                        @endforeach
                    </tbody>

                    <tfoot class="text-sm font-bold text-center text-gray-700 bg-gray-100">
                        <tr>
                            <td class="px-4 py-3 border-t">Total</td>
                            <td class="px-4 py-3 border-t">₱{{ number_format($totalEarnings, 2) }}</td>
                            <td class="px-4 py-3 border-t">₱{{ number_format($totalDeductions, 2) }}</td>
                        </tr>
                    </tfoot>
                </table>



            </div>
            <div class="flex flex-col items-center justify-center col-span-2 gap-3">
                <form id="payrollForm" method="POST" action="{{ route('update.batch.status') }}">
                    @csrf
                    <div class="hidden mb-4">
                        <label for="id" class="block text-sm font-medium text-gray-700">Batch ID:</label>
                        <input type="text" name="id" id="id"
                            class="block w-full mt-1 border border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500"
                            required value="{{ $batch_id }}">
                    </div>

                    @if ($data->status == '0')
                        <div class="flex items-center justify-center">
                            <button type="button" onclick="openConfirmationModal()"
                                class=" py-2 w-[15rem] font-semibold text-white bg-blue-600 rounded-md shadow-sm hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-blue-500">
                                CLOSE PAYROLL
                            </button>
                        </div>
                    @endif
                    @if (in_array('Payroll Approve', $privileges))
                        @if ($data->status == '1')
                            <div class="flex items-center justify-center">
                                <button type="button" onclick="openConfirmationModal()"
                                    class=" py-2 w-[15rem] font-semibold text-white bg-blue-600 rounded-md shadow-sm hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-blue-500">
                                    Approved
                                </button>
                            </div>
                        @endif
                    @else
                    @endif
                </form>
                @if (in_array('Payroll Approve', $privileges))
                    @if ($data->status != '0')
                        <form method="POST" action="{{ route('admin.updatebatch', $batch_id) }}">
                            @csrf
                            @method('POST')
                            <!-- This is required if you're using a PUT/PATCH request, but for POST it can be omitted -->
                            <button
                                class=" py-2 w-[15rem] font-semibold text-white bg-blue-600 rounded-md shadow-sm hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-blue-500"
                                type="submit">Back to Checking</button>
                        </form>
                    @endif
                @endif

            </div>

        </div>


        @if ($data->status !== '0')
            <div class="flex gap-20 mt-20">
                @if ($prepared && $prepared->user)
                    <p>Prepared By: <strong>{{ $prepared->user->name }}</strong></p>
                @endif

                @if ($approved && $approved->user)
                    <p>Approved By: <strong>{{ $approved->user->name }}</strong></p>
                @endif
            </div>
        @endif




        <!-- Confirmation Modal -->
        <div id="confirmationModal"
            class="fixed inset-0 z-50 flex items-start justify-center hidden bg-black bg-opacity-50">
            <div class="w-auto p-6 mt-10 bg-white rounded-lg shadow-lg">
                <h2 class="mb-4 text-lg font-bold">Confirm Action</h2>
                <p class="mb-6 text-gray-700">Are you sure you want to save this as the final payroll?</p>
                <div class="flex justify-end gap-4">
                    <button onclick="closeConfirmationModal()"
                        class="px-4 py-2 text-gray-700 bg-gray-200 rounded-md hover:bg-gray-300 focus:outline-none">
                        Cancel
                    </button>
                    <button onclick="submitPayrollForm1()"
                        class="px-4 py-2 text-white bg-blue-600 rounded-md hover:bg-blue-700 focus:outline-none">
                        Confirm
                    </button>
                </div>
            </div>
        </div>





        <script>
            // Open the confirmation modal
            function openConfirmationModal() {
                document.getElementById('confirmationModal').classList.remove('hidden');
            }

            // Close the confirmation modal
            function closeConfirmationModal() {
                document.getElementById('confirmationModal').classList.add('hidden');
            }

            // Submit the form upon confirmation
            function submitPayrollForm1() {
                document.getElementById('payrollForm').submit();
            }
        </script>
        @include('Admin.Payroll.payrollbatch.modal')
    @else
        <div class="flex items-center justify-center w-full h-full my-2">
            <div>
                <i class="mr-2 text-3xl bx bx-lock"></i> <!-- Large lock icon indicating no access -->
                <span class="text-gray-500">You don't have privilege to access this page</span>
            </div>

        </div>
    @endif





@endsection