@extends('layouts.sidebar')
@section('title', 'billings')
@section('content')
    @if (in_array('Billing Checking', $privileges))


        <div class="bg-white ">
            <div class="flex items-end justify-end gap-5">
                @if (!$latestPayroll)
                    @if ($motherBillingId == null)
                        <form method="get" action="{{ url('admin/company-billings/' . $id . '/' . $client_id . '/1') }}"
                            class="">
                            <button type="submit"
                                class="px-4 py-2 font-bold text-white bg-gray-900 rounded-md w-60 hover:bg-blue-700">
                                Final Billing
                            </button>
                        </form>
                    @else
                        <form method="get" action="{{ url('admin/company-billings/' . $id . '/' . $client_id . '/0') }}"
                            class="">
                            <button type="submit"
                                class="px-4 py-2 font-bold text-white bg-gray-900 rounded-md w-60 hover:bg-blue-700">
                                Without Adjustment
                            </button>
                        </form>
                    @endif
                @endif
                <button onclick="printDiv('print-section')"
                    class="px-4 py-2 font-bold text-white bg-gray-900 rounded-md w-44 hover:bg-blue-700">
                    Print
                </button>

            </div>
            <form id="form2" action="{{ route('billings.store') }}" method="POST">
                @csrf
                <div class="p-6 mx-auto print-content " id="print-section">
                    <div class="p-5">
                        <div class="text-2xl flex items-center justify-center flex-col text-center md:mb-10 font-serif">
                            <img class="w-32" src="{{ asset($client->company->agency->contact_person) }}">
                            <p class="font-extrabold text-gray-800">{{ $client->company->agency->name }}</p>
                            <p class="text-sm text-gray-600">{{ $client->company->agency->address }}</p>
                            <p class="text-sm text-gray-600">Tel: {{ $client->company->agency->contact_phone }}</p>
                        </div>
                        <hr class="border-t border-gray-300 mb-4">
                        <div class="mb-4">
                            <p class="text-sm font-semibold text-gray-700">Client Name: <span
                                    class="font-normal text-gray-600">{{ $client->business_name }}</span></p>
                            <p class="text-sm font-semibold text-gray-700">Address: <span
                                    class="font-normal text-gray-600">{{ $client->address }}</span></p>
                            <p class="text-sm font-semibold text-gray-700">Billing Ref. #: <span
                                    class="font-normal text-gray-600">{{ $motherBillingId }}</span></p>
                            <p class="text-sm font-semibold text-gray-700">Period Covered: <span
                                    class="font-normal text-gray-600">
                                    {{ \Carbon\Carbon::parse($payPeriodStart)->format('F d, Y') }} -
                                    {{ \Carbon\Carbon::parse($payPeriodEnd)->format('F d, Y') }}</span></p>
                        </div>
                        <hr class="border-t border-gray-300 mb-4">
                        <div class="hidden">
                            <input type="text" class="form-control" name="user_id" value="{{ $currentUser->id }}"
                                required>
                            <input type="date" class="form-control" name="date" value="{{ date('Y-m-d') }}" required>
                        </div>
                        @php
                            // Collect all unique headers and initialize totals
                            $uniqueHeaders = [];
                            $totals = [
                                'others' => [],
                                'deductions' => [],
                                'benefits' => [],
                                'grand_total' => 0, // Track grand total
                            ];

                            foreach ($payrolls as $payroll) {
                                foreach ($payroll->othersForPayroll as $earning) {
                                    $uniqueHeaders['others'][$earning->name] = $earning->name;
                                }
                                foreach ($payroll->trxConstantDeductions->where('status', 1) as $earning) {
                                    $description = optional(
                                        App\Models\TrxCode::find($earning->trxConstant->group_code_id),
                                    )->description;
                                    $uniqueHeaders['deductions'][$description] = $description;
                                }
                                foreach ($payroll->benefits as $earning) {
                                    $uniqueHeaders['benefits'][$earning->type] = $earning->type;
                                }
                            }
                        @endphp

                        <div class="overflow-auto shadow-md rounded-lg">
                            <table class="min-w-full border-collapse border border-gray-300"
                                style="table-layout: fixed; width: 100%;">
                                <thead class="bg-gray-100 text-gray-600 text-xs leading-normal">
                                    <tr>
                                        <th class="py-2 px-3 text-left border border-gray-300 text-xs">Employee Name</th>
                                        <th class="py-2 px-3 text-left border border-gray-300 text-xs">Days</th>
                                        <th class="py-2 px-3 text-left border border-gray-300 text-xs">Rate</th>
                                        <th class="py-2 px-3 text-left border border-gray-300 text-xs">Amount</th>

                                        <!-- Render headers for Others, Deductions, and Benefits -->
                                        @foreach ($uniqueHeaders['others'] ?? [] as $header)
                                            <th class="py-2 px-3 text-left border border-gray-300 text-xs">
                                                {{ $header }}</th>
                                        @endforeach

                                        @foreach ($uniqueHeaders['deductions'] ?? [] as $header)
                                            <th class="py-2 px-3 text-left border border-gray-300 text-xs">
                                                {{ $header }}</th>
                                        @endforeach

                                        @foreach ($uniqueHeaders['benefits'] ?? [] as $header)
                                            <th class="py-2 px-3 text-left border border-gray-300 text-xs">
                                                {{ $header }}</th>
                                        @endforeach

                                        <th class="py-2 px-3 text-left border border-gray-300 text-xs">Grand Total</th>
                                    </tr>
                                </thead>

                                <tbody class="text-gray-700 text-xs font-light">
                                    <!-- Render rows -->
                                    @foreach ($payrolls as $payroll)
                                        @php
                                            // Calculate the base earnings (Rate * Days)
                                            $basicEarnings = $payroll->rate * $payroll->days_worked_withdeduction;
                                            $rowTotal = $basicEarnings; // Add earnings

                                            // Add other earnings to the row total (e.g., COLA, Allowances)
                                            foreach ($uniqueHeaders['others'] ?? [] as $header) {
                                                $amount =
                                                    $payroll->othersForPayroll->firstWhere('name', $header)?->amount ??
                                                    0;
                                                $rowTotal += $amount;
                                                $totals['others'][$header] =
                                                    ($totals['others'][$header] ?? 0) + $amount;
                                            }

                                            // Subtract deductions (SSS, Pag-IBIG, PhilHealth)
                                            foreach ($uniqueHeaders['deductions'] ?? [] as $header) {
                                                $amount =
                                                    $payroll->trxConstantDeductions->firstWhere(
                                                        fn($earning) => optional(
                                                            App\Models\TrxCode::find(
                                                                $earning->trxConstant->group_code_id,
                                                            ),
                                                        )->description === $header,
                                                    )?->E_Amount ?? 0;
                                                $rowTotal += $amount;
                                                $totals['deductions'][$header] =
                                                    ($totals['deductions'][$header] ?? 0) + $amount;
                                            }

                                            // Add benefits (if applicable)
                                            foreach ($uniqueHeaders['benefits'] ?? [] as $header) {
                                                $amount =
                                                    $payroll->benefits->firstWhere('type', $header)?->employer_share ??
                                                    0;
                                                $rowTotal += $amount;
                                                $totals['benefits'][$header] =
                                                    ($totals['benefits'][$header] ?? 0) + $amount;
                                            }

                                            // Accumulate grand total
                                            $totals['grand_total'] += $rowTotal;
                                        @endphp

                                        <tr class="border-b border-gray-300 hover:bg-gray-100">
                                            <td class="py-1 px-3 border border-gray-300 text-xs">
                                                {{ $payroll->employee->first_name }}
                                                {{ substr($payroll->employee->middle_name, 0, 1) }}.
                                                {{ $payroll->employee->last_name }}
                                            </td>

                                            <td class="py-1 px-3 border border-gray-300 text-xs">
                                                {{ $payroll->days_worked_withdeduction }}</td>
                                            <td class="py-1 px-3 border border-gray-300 text-xs">{{ $payroll->rate }}</td>
                                            <td class="py-1 px-3 border border-gray-300 text-xs">{{ $payroll->earnings }}
                                            </td>

                                            <!-- Render Others for Payroll -->
                                            @foreach ($uniqueHeaders['others'] ?? [] as $header)
                                                @php
                                                    $amount =
                                                        $payroll->othersForPayroll->firstWhere('name', $header)
                                                            ?->amount ?? '-';
                                                @endphp
                                                <td class="py-1 px-3 border border-gray-300 text-xs">
                                                    {{ is_numeric($amount) ? number_format($amount, 2) : $amount }}
                                                </td>
                                            @endforeach

                                            <!-- Render Deductions -->
                                            @foreach ($uniqueHeaders['deductions'] ?? [] as $header)
                                                @php
                                                    $amount =
                                                        $payroll->trxConstantDeductions->firstWhere(
                                                            fn($earning) => optional(
                                                                App\Models\TrxCode::find(
                                                                    $earning->trxConstant->group_code_id,
                                                                ),
                                                            )->description === $header,
                                                        )?->E_Amount ?? '-';
                                                @endphp
                                                <td class="py-1 px-3 border border-gray-300 text-xs">
                                                    {{ is_numeric($amount) ? number_format($amount, 2) : $amount }}
                                                </td>
                                            @endforeach

                                            <!-- Render Benefits -->
                                            @foreach ($uniqueHeaders['benefits'] ?? [] as $header)
                                                @php
                                                    $amount =
                                                        $payroll->benefits->firstWhere('type', $header)
                                                            ?->employer_share ?? '-';
                                                @endphp
                                                <td class="py-1 px-3 border border-gray-300 text-xs">
                                                    {{ is_numeric($amount) ? number_format($amount, 2) : $amount }}
                                                </td>
                                            @endforeach

                                            <!-- Grand Total column -->
                                            <td class="py-1 px-3 border border-gray-300 text-xs">
                                                {{ number_format($rowTotal, 2) }}</td>
                                        </tr>
                                    @endforeach
                                </tbody>

                                <!-- Footer with totals -->
                                <tfoot>
                                    <tr class="font-semibold bg-gray-100">
                                        <td class="py-1 px-3 border border-gray-300 text-xs text-left" colspan="4">Total
                                        </td>

                                        <!-- Render total for Others -->
                                        @foreach ($uniqueHeaders['others'] ?? [] as $header)
                                            <td class="py-1 px-3 border border-gray-300 text-xs">
                                                {{ is_numeric($totals['others'][$header]) ? number_format($totals['others'][$header], 2) : '-' }}
                                            </td>
                                        @endforeach

                                        <!-- Render total for Deductions -->
                                        @foreach ($uniqueHeaders['deductions'] ?? [] as $header)
                                            <td class="py-1 px-3 border border-gray-300 text-xs">
                                                {{ is_numeric($totals['deductions'][$header]) ? number_format($totals['deductions'][$header], 2) : '-' }}
                                            </td>
                                        @endforeach

                                        <!-- Render total for Benefits -->
                                        @foreach ($uniqueHeaders['benefits'] ?? [] as $header)
                                            <td class="py-1 px-3 border border-gray-300 text-xs">
                                                {{ is_numeric($totals['benefits'][$header]) ? number_format($totals['benefits'][$header], 2) : '-' }}
                                            </td>
                                        @endforeach

                                        <!-- Grand Total Row -->
                                        <td class="py-1 px-3 border border-gray-300 text-xs">
                                            {{ number_format($totals['grand_total'], 2) }}
                                        </td>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>

                        @php
                            $service_charge = $totals['grand_total'] * ($latestCharge->service_charge / 100);
                            $subtotal = $service_charge + $totals['grand_total'];
                            $vat = $subtotal * ($latestCharge->vat / 100);
                            $subtotal1 = $vat + $subtotal;
                            $holding = $subtotal1 * ($latestCharge->withholding_tax / 100);
                            $Amountbill = $subtotal1 - $holding;
                        @endphp

                        <div class="flex items-center justify-end md:mt-8">
                            <div
                                class="grid grid-cols-1 gap-2 w-[24rem] p-4 bg-white shadow-md rounded-lg border border-gray-200">

                                <!-- Hidden Section for Inputs -->
                                <div class="hidden">
                                    <label for="service_charge" class="font-semibold text-xs text-gray-600">Service Charge
                                        (%):</label>
                                    <input type="number" id="service_charge" value="{{ $latestCharge->service_charge }}"
                                        class="p-2 text-xs border-2 border-gray-300 rounded-md" />

                                    <label for="vat" class="font-semibold text-xs text-gray-600">VAT (%):</label>
                                    <input type="number" id="vat" value="{{ $latestCharge->vat }}"
                                        class="p-2 text-xs border-2 border-gray-300 rounded-md" />

                                    <label for="withholding_tax" class="font-semibold text-xs text-gray-600">Withholding Tax
                                        (%):</label>
                                    <input type="number" id="withholding_tax" value="{{ $latestCharge->withholding_tax }}"
                                        class="p-2 text-xs border-2 border-gray-300 rounded-md" />
                                </div>

                                <!-- Financial Summary -->
                                <div class="space-y-2">
                                    <!-- Total Row -->
                                    <div class="flex justify-between items-center text-xs font-medium text-gray-700">
                                        <span>Total:</span>
                                        <span id="display_total"
                                            class="text-right text-gray-800">{{ number_format($totals['grand_total'], 2) }}</span>
                                    </div>

                                    <!-- Service Charge -->
                                    <div class="flex justify-between items-center text-xs text-gray-700">
                                        <span>Service Charge <span id="display_service_charge_percent"
                                                class="text-gray-800">{{ number_format($latestCharge->service_charge, 0, '.', '') }}%</span>
                                        </span>
                                        <span id="display_service_charge"
                                            class="text-right text-gray-800">{{ number_format($service_charge, 2, '.', ',') }}</span>
                                    </div>

                                    <!-- Subtotal -->
                                    <div class="flex justify-between items-center text-xs text-gray-700">
                                        <span>Subtotal:</span>
                                        <span id="display_subtotal"
                                            class="text-right text-gray-800">{{ number_format($subtotal, 2, '.', ',') }}</span>
                                    </div>

                                    <!-- VAT -->
                                    <div class="flex justify-between items-center text-xs text-gray-700">
                                        <span>VAT <span id="display_vat_percent"
                                                class="text-gray-800">{{ number_format($latestCharge->vat, 0, '.', '') }}%</span></span>
                                        <span id="display_vat"
                                            class="text-right text-gray-800">{{ number_format($vat, 2, '.', ',') }}</span>
                                    </div>

                                    <!-- Subtotal1 -->
                                    <div class="flex justify-between items-center text-xs text-gray-700">
                                        <span>Subtotal:</span>
                                        <span id="display_subtotal1"
                                            class="text-right text-gray-800">{{ number_format($subtotal1, 2, '.', ',') }}</span>
                                    </div>

                                    <!-- Withholding Tax -->
                                    <div class="flex justify-between items-center text-xs text-gray-700">
                                        <span>Withholding Tax <span id="display_withholding_tax_percent"
                                                class="text-gray-800">{{ number_format($latestCharge->withholding_tax, 0, '.', '') }}%</span>
                                        </span>
                                        <span id="display_holding_tax"
                                            class="text-right text-gray-800">{{ number_format($holding, 2, '.', ',') }}</span>
                                    </div>

                                    <!-- Amount Bill Payable -->
                                    <div class="flex justify-between items-center text-xs font-semibold text-gray-800">
                                        <span>Amount Bill Payable:</span>
                                        <span id="display_amount_bill_payable"
                                            class="font-semibold text-lg">{{ number_format($Amountbill, 2, '.', ',') }}</span>
                                    </div>
                                </div>
                            </div>
                        </div>

                    </div>









                    {{-- <div class="overflow-auto">

                        <table class="min-w-full mb-2 table-auto">
                            <thead>
                                <tr
                                    class="text-xs leading-normal border-2 border-black text-gray-600 uppercase bg-gray-200">
                                    <th class=" ">Employee Name</th>


                                    @if (!isset($settings) || (isset($settings->regular_column) && $settings->regular_column == 1))
                                        <th colspan="3" class="  border-2 border-black ">Regular</th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->drd_column) && $settings->drd_column == 1))
                                        <th colspan="2" class="  border-2 border-black ">DRD </th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->lh_column) && $settings->lh_column == 1))
                                        <th colspan="2" class="  border-2 border-black ">Legal Holiday </th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->sh_column) && $settings->sh_column == 1))
                                        <th colspan="2" class="  border-2 border-black ">Special Holiday </th>
                                    @endif
                                    <th colspan="2" class=" border-2 border-black ">Overtime </th>
                                    @if (!isset($settings) || (isset($settings->gross_pay) && $settings->gross_pay == 1))
                                        <th colspan="2" class=" border-2 border-black "> </th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->benefits) && $settings->benefits == 1))
                                        <th colspan="3" class=" border-2 border-black">Pag-ibig</th>
                                    @endif
                                    <th class="  border-2 border-black"></th>
                                </tr>
                                <tr
                                    class="text-xs leading-normal  border-2 border-black text-gray-600 uppercase bg-gray-200">
                                    <th class="  py-2"></th>
                                    @if (!isset($settings) || (isset($settings->regular_column) && $settings->regular_column == 1))
                                        <th class=" py-2  border-2 border-black">Days</th>
                                        <th class=" py-2  border-2 border-black">Rate</th>
                                        <th class=" py-2  px-2 border-2 border-black">Amount</th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->drd_column) && $settings->drd_column == 1))
                                        <th class=" py-2  border-2 border-black">Hours </th>
                                        <th class=" py-2  border-2 border-black">Amount</th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->lh_column) && $settings->lh_column == 1))
                                        <th class=" py-2  border-2 border-black">Hours </th>
                                        <th class="py-2  border-2 border-black">Amount</th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->sh_column) && $settings->sh_column == 1))
                                        <th class=" py-2  border-2 border-black">Hours </th>
                                        <th class=" py-2  border-2 border-black">Amount</th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->ot_column) && $settings->ot_column == 1))
                                        <th class=" py-2  border-2 border-black">Hours </th>
                                        <th class="py-2  border-2 border-black">Amount</th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->gross_pay) && $settings->gross_pay == 1))
                                        <th class=" py-2 border-2 border-black ">Gross Pay</th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->thirtheen_month) && $settings->thirtheen_month == 1))
                                        <th class=" py-2  border-2 border-black">13 Month</th>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->benefits) && $settings->benefits == 1))
                                        <th class=" py-2 border-2 border-black ">SSS</th>
                                        <th class=" py-2  border-2 border-black">Phic</th>
                                        <th class=" py-2  border-2 border-black">Pag-ibig</th>
                                    @endif
                                    <th class=" py-2  border-2 border-black">Grand total</th>
                                </tr>
                            </thead>
                            <tbody class="text-xs font-light text-gray-600 border-b-2 border-black">
                                @php
                                    $total_gross = 0;
                                    $gross = 0;
                                    $total_days = 0;
                                    $net_pay = 0;
                                    $amount1 = 0;
                                    $total_sss = 0;
                                    $total_pagibig = 0;
                                    $total_philhealth = 0;
                                    $total_131 = 0;
                                @endphp
                                @foreach ($data as $index => $data)
                                    <div class="hidden"> <input type="text" class="form-control"
                                            name="payrolls[{{ $index }}][code_id]" value="{{ $data->code_id }}">
                                        <input type="text" class="form-control"
                                            name="payrolls[{{ $index }}][client_id]" value="{{ $data->client_id }}"
                                            required>
                                        <input type="text" class="form-control"
                                            name="payrolls[{{ $index }}][employee_id]"
                                            value="{{ $data->employee_id }}" required>

                                        <input type="number" step="0.01" class="form-control"
                                            name="payrolls[{{ $index }}][overtime]" value="{{ $data->overtime }}"
                                            required>
                                        <input type="number" step="0.01" class="form-control"
                                            name="payrolls[{{ $index }}][deductions]"
                                            value="{{ $data->deductions }}">

                                        <input type="number" step="0.01" class="form-control"
                                            name="payrolls[{{ $index }}][net_pay]" value="{{ $data->net_pay }}">
                                        <input type="number" step="0.01" class="form-control"
                                            name="payrolls[{{ $index }}][total_late_hours]"
                                            value="{{ $data->total_late_hours }}">
                                        <input type="number" step="0.01" class="form-control"
                                            name="payrolls[{{ $index }}][total_undertime_hours]"
                                            value="{{ $data->total_undertime_hours }}">
                                    </div>


                                    <tr class="text-center border-t border-gray-300">
                                        <td class="px-4 py-2 md:py-3 md:px-6">
                                            {{ $data->employee->first_name }}
                                            {{ substr($data->employee->middle_name, 0, 1) }}.
                                            {{ $data->employee->last_name }}
                                        </td>


                                        @php

                                            $workminutes = $data->workminutes;

                                            $totalWorkdays = $data->days_worked_withdeduction;

                                        @endphp
                                        <input type="hidden" name="payrolls[{{ $index }}][workminutes]"
                                            value="{{ $workminutes }}">
                                        <input type="hidden" name="payrolls[{{ $index }}][days_worked]"
                                            value="{{ $data->days_worked }}">

                                        @if (!isset($settings) || (isset($settings->regular_column) && $settings->regular_column == 1))
                                            <td class="px-4 py-2 md:py-3 md:px-6">
                                                <input type="number" id="days_worked{{ $data->id }}"
                                                    name="payrolls[{{ $index }}][days_worked_withdeduction]"
                                                    value="{{ $totalWorkdays }}"
                                                    class="w-20 px-2 py-1 text-black border-gray-300 rounded days-worked"
                                                    data-id="{{ $data->id }}" step="0.01" />
                                            </td>

                                            @foreach ($data->employee->channelclient->where('status', '1') as $channel)
                                                <td class="px-4 py-2 md:py-3 md:px-6">
                                                    <input type="number" id="salary_{{ $data->id }}"
                                                        name="salary[{{ $data->id }}]"
                                                        value="{{ $channel->salary }}"
                                                        class="w-20 px-2 py-1 text-black border-gray-300 rounded salary"
                                                        step="0.01" />
                                                </td>
                                                @php
                                                    $monthpay_13 = $data->net_pay + $channel->salary;

                                                    $amount = $totalWorkdays * $channel->salary;
                                                    $amount1 += $data->days_worked * $channel->salary;
                                                    $total_131 += $monthpay_13 / 12;
                                                    $total_13 = $monthpay_13 / 12;
                                                @endphp
                                            @endforeach

                                            @php
                                                $net_pay += $data->net_pay;
                                                $total_days += $data->days_worked;
                                            @endphp

                                            <td class="px-4 py-2 md:py-3 md:px-6">
                                                <input type="number" id="net_pay_{{ $data->id }}"
                                                    name="payrolls[{{ $index }}][basic_salary]"
                                                    value="{{ $amount }}"
                                                    class="w-20 px-2 py-1 text-black border-gray-300 rounded net-pay"
                                                    data-id="{{ $data->id }}" step="0.01" />
                                            </td>
                                        @endif
                                        @if (!isset($settings) || (isset($settings->drd_column) && $settings->drd_column == 1))
                                            <td class="px-4 py-2 md:py-3 md:px-6"></td>
                                            <td class="px-4 py-2 md:py-3 md:px-6"></td>
                                        @endif
                                        @if (!isset($settings) || (isset($settings->lh_column) && $settings->lh_column == 1))
                                            <td class="px-4 py-2 md:py-3 md:px-6"></td>
                                            <td class="px-4 py-2 md:py-3 md:px-6"></td>
                                        @endif
                                        @if (!isset($settings) || (isset($settings->sh_column) && $settings->sh_column == 1))
                                            <td class="px-4 py-2 md:py-3 md:px-6"></td>
                                            <td class="px-4 py-2 md:py-3 md:px-6"></td>
                                        @endif
                                        @if (!isset($settings) || (isset($settings->ot_column) && $settings->ot_column == 1))
                                            <td class="px-4 py-2 md:py-3 md:px-6"></td>
                                            <td class="px-4 py-2 md:py-3 md:px-6"></td>
                                        @endif
                                        @if (!isset($settings) || (isset($settings->gross_pay) && $settings->gross_pay == 1))
                                            <td class="px-4 py-2 md:py-3 md:px-6">
                                                <input type="number" id="gross_pay_{{ $data->id }}"
                                                    name="payrolls[{{ $index }}][gross_pay]"
                                                    value="{{ $data->gross_pay }}"
                                                    class="w-20 px-2 py-1 text-black border-gray-300 rounded gross-pay"
                                                    step="0.01" />
                                            </td>
                                        @endif
                                        @if (!isset($settings) || (isset($settings->thirtheen_month) && $settings->thirtheen_month == 1))
                                            <td class="px-4 py-2 md:py-3 md:px-6">
                                                <input type="text" id="total_13_{{ $data->id }}"
                                                    name="total_13[{{ $data->id }}]" value="{{ $total_13 }}"
                                                    class="w-20 px-2 py-1 text-black border-gray-300 rounded"
                                                    step="0.01" />
                                            </td>
                                        @endif
                                        @if (!isset($settings) || (isset($settings->benefits) && $settings->benefits == 1))
                                            @foreach ($data->benefits->where('type', 'SSS') as $channel)
                                                <td class="px-4 py-2 md:py-3 md:px-6">
                                                    <input type="number" id="sss_{{ $data->id }}" name="sss"
                                                        value="{{ $channel->employer_share }}"
                                                        class="w-20 px-2 py-1 text-black border-gray-300 rounded"
                                                        step="0.01" />
                                                </td>
                                                @php
                                                    $total_sss += $channel->employer_share;
                                                @endphp
                                            @endforeach

                                            @foreach ($data->benefits->where('type', 'Pag-IBIG') as $channel)
                                                <td class="px-4 py-2 md:py-3 md:px-6">
                                                    <input type="number" id="pagibig_{{ $data->id }}"
                                                        name="pagibig" value="{{ $channel->employer_share }}"
                                                        class="w-20 px-2 py-1 text-black border-gray-300 rounded"
                                                        step="0.01" />
                                                </td>
                                                @php
                                                    $total_pagibig += $channel->employer_share;
                                                @endphp
                                            @endforeach

                                            @foreach ($data->benefits->where('type', 'PhilHealth') as $channel)
                                                <td class="px-4 py-2 md:py-3 md:px-6">
                                                    <input type="number" id="philhealth_{{ $data->id }}"
                                                        name="philhealth" value="{{ $channel->employer_share }}"
                                                        class="w-20 px-2 py-1 text-black border-gray-300 rounded"
                                                        step="0.01" />
                                                </td>
                                                @php
                                                    $total_philhealth += $channel->employer_share;
                                                @endphp
                                            @endforeach
                                        @endif
                                        @php
                                            $g_total = $data->gross_pay + $total_13 + $total_sss;
                                        @endphp
                                        <td class="px-4 py-2 md:py-3 md:px-6">
                                            <input type="text" id="g_total_{{ $data->id }}"
                                                name="g_total[{{ $data->id }}]" value="{{ $g_total }}"
                                                class="w-20 px-2 py-1 text-black border-gray-300 rounded"
                                                step="0.01" />
                                        </td>

                                        @php
                                            $total_gross += $g_total;
                                            $gross += $data->gross_pay;
                                        @endphp
                                    </tr>
                                @endforeach

                            </tbody>
                            <tfoot class="bg-gray-200 border-b-2 text-sm border-black">
                                <tr class="text-center">
                                    <td class="font-bold">Total</td>
                                    @if (!isset($settings) || (isset($settings->regular_column) && $settings->regular_column == 1))
                                        <td class="px-4 md:px-6" id="footer_total_days">
                                            {{ number_format($total_days, 2, '.', ',') }}</td>


                                        <td class="px-4  md:px-6"></td>
                                        <td class="px-4 md:px-6" id="footer_net_pay">
                                            {{ number_format($amount1, 2, '.', ',') }}
                                        </td>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->drd_column) && $settings->drd_column == 1))
                                        <td class="px-4  md:px-6"></td>
                                        <td class="px-4  md:px-6"></td>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->lh_column) && $settings->lh_column == 1))
                                        <td class="px-4  md:px-6"></td>
                                        <td class="px-4  md:px-6"></td>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->sh_column) && $settings->sh_column == 1))
                                        <td class="px-4  md:px-6"></td>
                                        <td class="px-4  md:px-6"></td>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->ot_column) && $settings->ot_column == 1))
                                        <td class="px-4  md:px-6"></td>
                                        <td class="px-4  md:px-6"></td>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->gross_pay) && $settings->gross_pay == 1))
                                        <td class="px-4  md:px-6" id="footer_gross_pay">
                                            {{ number_format($gross, 2, '.', ',') }}
                                        </td>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->thirtheen_month) && $settings->thirtheen_month == 1))
                                        <td class="px-4  md:px-6" id="footer_13_month">
                                            {{ number_format($total_131, 2, '.', ',') }}</td>
                                    @endif
                                    @if (!isset($settings) || (isset($settings->benefits) && $settings->benefits == 1))
                                        <td class="px-4  md:px-6" id="footer_sss">
                                            {{ number_format($total_sss, 2, '.', ',') }}
                                        </td>
                                        <td class="px-4  md:px-6" id="footer_pagibig">
                                            {{ number_format($total_pagibig, 2, '.', ',') }}</td>
                                        <td class="px-4  md:px-6" id="footer_philhealth">
                                            {{ number_format($total_philhealth, 2, '.', ',') }}</td>
                                    @endif
                                    <td class="px-4  md:px-6" id="footer_total_gross">
                                        {{ number_format($total_gross, 2, '.', ',') }}</td>
                                </tr>
                            </tfoot>

                            @php
                                $service_charge = $total_gross * ($latestCharge->service_charge / 100);
                                $subtotal = $service_charge + $total_gross;
                                $vat = $subtotal * ($latestCharge->vat / 100);
                                $subtotal1 = $vat + $subtotal;
                                $holding = $subtotal1 * ($latestCharge->withholding_tax / 100);
                                $Amountbill = $subtotal1 - $holding;
                            @endphp
                            @include('Admin.Client.Billings.billingjs')

                        </table>
                    </div> --}}


                    @if (!$latestPayroll && $checked)
                        <div>
                            <p class="font-bold">checked by: {{ $checked->user->name }}</p>
                        </div>
                    @endif
                </div>
                <div class="my-4 text-center">
                    <div class="hidden"> <input name="status" value="1">
                        <input name="client_id" value="{{ $client_id }}">
                        <input name="id" value="{{ $id }}">
                    </div>
                    @if ($motherBillingId == null && $latestPayroll)
                        <button type="submit"
                            class="px-4 py-2 w-44 my-10 font-bold text-white bg-gray-900 rounded-md hover:bg-blue-700">
                            Save
                        </button>
                    @endif


                </div>
            </form>

        </div>
        <script>
            document.addEventListener('DOMContentLoaded', function() {
                const form = document.getElementById('form2'); // Replace with your actual form ID
                const confirmationModal = document.getElementById('confirmationModal');
                const confirmButton = document.getElementById('confirmButton');
                const cancelButton = document.getElementById('cancelButton');

                form.addEventListener('submit', function(event) {
                    // Prevent the default form submission
                    event.preventDefault();

                    // Show the confirmation modal
                    confirmationModal.classList.remove('hidden');
                });

                confirmButton.addEventListener('click', function() {
                    confirmationModal.classList.add('hidden');
                    form.submit(); // Proceed with the form submission
                });

                cancelButton.addEventListener('click', function() {
                    confirmationModal.classList.add('hidden'); // Close the modal
                });
            });
        </script>
        <div id="confirmationModal"
            class="fixed inset-0 z-50 flex items-start justify-center hidden bg-gray-800 bg-opacity-75">
            <div class="p-6 mt-20 bg-white rounded-lg shadow-lg">
                <h2 class="text-lg font-semibold">Confirm Save</h2>
                <p>Are you sure you want to save? Saving will serve as a final billing.</p>
                <div class="flex justify-end mt-4 space-x-2">
                    <button id="cancelButton" class="px-4 py-2 text-white bg-gray-500 rounded-md hover:bg-gray-600">
                        Cancel
                    </button>
                    <button id="confirmButton" class="px-4 py-2  text-white bg-blue-500 rounded-md hover:bg-blue-700">
                        Confirm
                    </button>
                </div>
            </div>
        </div>
    @else
        <div class="my-2 flex h-full w-full justify-center items-center">
            <div>
                <i class="text-3xl bx bx-lock mr-2"></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

    <script>
        function printDiv(divId) {
            var printContents = document.getElementById(divId).innerHTML;
            var originalContents = document.body.innerHTML;

            // Temporarily update the body content for printing
            document.body.innerHTML = printContents;

            // Create a link tag to import Poppins font from Google Fonts
            var link = document.createElement('link');
            link.href = "https://fonts.googleapis.com/css2?family=Poppins:wght@400;600&display=swap";
            link.rel = "stylesheet";
            document.head.appendChild(link);

            // Apply print styles
            var style = document.createElement('style');
            style.innerHTML = `
                @media print {
                    /* Specify custom paper size (e.g., 15cm x 30cm) */
                    @page {
                        size: 50cm 40cm;  /* Custom paper size (width x height in cm) */
                        margin: 1cm;       /* Adjust margins as necessary */
                    }
    
                    /* Ensure the body has the correct styles for printing */
                    body {
                        font-family: 'Poppins', sans-serif;  /* Use Poppins font */
                        font-size: 12pt;                    /* Set font size for printing */
                        padding: 0;
                        margin: 0;
                        width: 100%;
                    }
    
                    /* Ensure all content is handled correctly for printing */
                    * {
                        box-sizing: border-box;
                    }
    
                    /* Make sure the table is responsive and fits within the page */
                    table {
                        width: 100% !important;  /* Ensure table width adjusts to the page */
                        border-collapse: collapse;
                        page-break-inside: auto;  /* Allow page breaks inside tables */
                    }
    
                    /* Handle page breaks between content blocks */
                    .content {
                        page-break-before: always;
                    }
    
                    /* Prevent table rows from breaking in the middle */
                    tr {
                        page-break-inside: avoid; /* Avoid breaking rows between pages */
                    }
                }
            `;
            document.head.appendChild(style);

            // Trigger the print dialog
            window.print();

            // Restore the original page content after printing
            document.body.innerHTML = originalContents;
        }
    </script>



















@endsection