@extends('layouts.sidebar')

@section('content')
    <style>
        @media print {
            body * {
                visibility: hidden;
            }

            .print-content,
            .print-content * {
                visibility: visible;
                font-size: 8pt;
                /* Adjust font size as needed */
                line-height: 1.2;
                /* Adjust line height for better spacing */
            }

            /* Hide elements not needed in print view */
            .sidebar,
            .header,
            .footer,
            .non-printable {
                display: none;
            }

            .print-content {
                position: absolute;
                left: 0;
                top: 0;
                width: calc(100% - 20mm);
                /* Adjust width for side margins */
                height: auto;
                /* Adjust height if needed */
                box-sizing: border-box;
                padding: 10px;
                /* Adjust padding for spacing around content */
                margin: 10mm;
                /* Add margin for space around the content */
            }

            @page {
                size: A4;
                margin: 10mm;
                /* Add margin to the A4 page size */
            }
        }
    </style>


    <div class="container mx-auto">

        <a href="{{ url('expenses') }}" class="px-4 py-2 mb-2 font-bold text-white bg-blue-500 rounded hover:bg-blue-700">back
        </a>
        <div class="max-w-5xl p-6 mx-auto bg-white rounded-lg shadow-lg">

            <!-- Filter Form -->
            <div class="mb-6 ">
                <form method="GET" action="{{ route('expense.report') }}" class="flex flex-col gap-4 md:flex-row">
                    <div class="flex items-center gap-4">
                        <input type="checkbox" id="today" name="today" value="1"
                            {{ request('today') == '1' ? 'checked' : '' }}>
                        <label for="today" class="font-semibold">Today</label>
                    </div>
                    <div class="flex items-center gap-4">
                        <label for="specific_date" class="font-semibold">Select Date:</label>
                        <input type="date" id="specific_date" name="specific_date"
                            class="px-3 py-2 border border-gray-300 rounded-lg" value="{{ request('specific_date') }}">
                        <button type="submit" class="px-4 py-2 text-white bg-blue-500 rounded-lg">Filter</button>
                    </div>

                </form>
            </div>

            <!-- Collection Section -->
            <div class="max-w-4xl p-6 mx-auto text-sm bg-white rounded-md print-content">
                <div class="mb-6 text-center">
                    <h1 class="text-xl font-bold">RWEB Solutions Corp</h1>
                    <p class="text-gray-700">Airpro BLDG., Bacaca, Davao City</p>
                    <p class="text-gray-700">Tel: (0##)###-####</p>
                    <p class="text-gray-700">Cell # 0###-###-####</p>
                </div>
                <div class="mb-6">
                    <h2 class="pb-2 mb-4 text-2xl font-semibold border-b">Collection</h2>

                    <div class="flex justify-between mb-4 font-semibold">
                        <span>Date:</span>
                        <span id="formattedDate">
                            @php
                                $specificDate = request('specific_date');
                                $formattedDate = \Carbon\Carbon::parse($specificDate)->format('d-M-Y');
                            @endphp
                            {{ $formattedDate }}
                        </span>
                    </div>
                   

                 




    



    <div class="flex justify-between py-2 border-b">
        <span>Collection</span>
        <span >
     P{{ number_format(
        $newPaymentsCash->sum('rental_amount') + 
        $newPaymentsEWCash->sum('waterbill_amount') + 
        $newPaymentsEWCash->sum('electricbill_amount'), 
        2
    ) }}  <span class="font-bold">V#<input type="text" class="w-14" id="voucher" readonly></span>
</span>

    </div>


                  

                    @foreach ($crIncome as $cr)
                        <div class="flex justify-between py-2 border-b">
                            <span>
                                {{ $cr->property->property_name ?? 'Unknown Property' }} CR</span>
                            <span> {{ number_format($cr->amount, 2) }}</span>
                        </div>
                    @endforeach
                    @php
                        $leaseTotals = [];
                    @endphp

                    @foreach ($leases as $lease)
                        @if (
                            $lease->security_deposit_paymentmethod === 'Cash' ||
                                $lease->relief_rental_paymentmethod === 'Cash' ||
                                $lease->utilities_paymentmethod === 'Cash')
                            @php

                                $key = $lease->lease_id;
                                if (!isset($leaseTotals[$key])) {
                                    $leaseTotals[$key] = [
                                        'owners_name' => $lease->client->owners_name,
                                        'property_name' => $lease->property->property_name,
                                        'unit_name' => $lease->unit->unit_name,
                                        'security_deposit' => 0,
                                        'relief_rental' => 0,
                                        'utilities' => 0,
                                    ];
                                }

                                if (
                                    $lease->security_deposit !== null &&
                                    $lease->security_deposit_paymentmethod === 'Cash'
                                ) {
                                    $leaseTotals[$key]['security_deposit'] += $lease->security_deposit;
                                }
                                if ($lease->relief_rental !== null && $lease->relief_rental_paymentmethod === 'Cash') {
                                    $leaseTotals[$key]['relief_rental'] += $lease->relief_rental;
                                }
                                if ($lease->utilities !== null && $lease->utilities_paymentmethod === 'Cash') {
                                    $leaseTotals[$key]['utilities'] += $lease->utilities;
                                }
                            @endphp
                        @endif
                    @endforeach

                    @php
                        $grandTotal = 0;
                        $utility = 0;
                    @endphp

                    @foreach ($leaseTotals as $total)
                        @php
                            $currentTotal = $total['security_deposit'] + $total['relief_rental'] + $total['utilities'];
                            $grandTotal += $currentTotal; 
                        @endphp

                        <div class="flex justify-between py-2 border-b">
                            <span>{{ $total['owners_name'] }} ({{ $total['property_name'] }} {{ $total['unit_name'] }})
                                (new) 
                            </span>
                            <span>{{ number_format($currentTotal, 2) }}  <span class="font-bold">V#{{ $lease->security_deposit_voucher ?? ($lease->relief_rental_voucher ?? $lease->utilities_voucher) }}</span></span> <!-- Display the total for this lease -->
                        </div>
                    @endforeach
                    <div class="flex justify-between mt-4 font-bold">
                        <span>Total Collection</span>
                        <span>P
    {{ number_format(
        $newPaymentsCash->sum('rental_amount') + 
        $crIncome->sum('amount') + 
        $newPaymentsEWCash->sum('electricbill_amount') + 
        $newPaymentsEWCash->sum('waterbill_amount') + 
        $grandTotal, 
        2
    ) }}
</span>

                    </div>
                </div>

                <!-- Expenses Section -->
                <div class="mb-6">
                    <h2 class="pb-2 mb-4 text-xl font-semibold border-b">Expenses</h2>
                    @foreach ($expenses->groupBy('date') as $date => $expensesOnDate)
    <!-- Display the voucher once for the entire group of expenses on the same date -->
    <p class="font-bold text-right">V#<span>{{ $expensesOnDate->first()->Voucher }}</span></p>
    
    @foreach ($expensesOnDate as $expense)
        <div class="flex justify-between py-2 border-b">
            <span>{{ $expense->Description }}</span>
            <span>P {{ number_format($expense->expenses_amount, 2) }}</span>
        </div>
    @endforeach
@endforeach

                    <div class="flex justify-end gap-5 mt-4 font-bold">
                        <span>Total Expenses:</span>
                        <span>P {{ number_format($expenses->sum('expenses_amount'), 2) }}</span>
                    </div>
                </div>
                <div class="mb-6">
                    <h2 class="pb-2 mb-4 text-xl font-semibold border-b">Total Income</h2>
                    <div class="flex justify-between py-2 border-b">
                        <span>Total Income</span>
                        <span>P
                            {{ number_format($newPaymentsCash->sum('rental_amount') + $newPaymentsEWCash->sum('waterbill_amount') + $newPaymentsEWCash->sum('electricbill_amount') + $crIncome->sum('amount') + $grandTotal, 2) }}</span>
                    </div>
                    <div class="flex justify-between py-2 border-b">
                        <span>Less Expenses</span>
                        <span>
                            {{ number_format($expenses->sum('expenses_amount'), 2) }}</span>
                    </div>
                    <div class="flex justify-end gap-5 mt-4 font-bold">
                        <span>Net Income:</span>
                        <span>P
                            {{ number_format($newPaymentsCash->sum('rental_amount')  + $newPaymentsEWCash->sum('waterbill_amount') + $newPaymentsEWCash->sum('electricbill_amount') + $crIncome->sum('amount') + $grandTotal - $expenses->sum('expenses_amount'), 2) }}</span>
                    </div>
                </div>
                <!-- Check Expenses Section -->
                <div class="mb-6">
                    <h2 class="pb-2 mb-4 text-xl font-semibold border-b">Check Expenses</h2>
                    @foreach ($checkExpenses as $checkExpense)
                        <div class="flex justify-between py-2 border-b">
                            <span>{{ $checkExpense->Description }}</span>
                            <span> {{ $checkExpense->check_number }}</span>
                            <span> {{ $checkExpense->date }}</span>
                            <span>{{ number_format($checkExpense->expenses_amount, 2) }}</span>
                            <span>{{ $checkExpense->remarks}}</span>
                           <span> V#{{ $checkExpense->Voucher}}</span>
                        </div>
                    @endforeach

                    {{-- <div class="flex justify-between mt-4 font-bold">
                        <span>Total Check Expenses</span>
                        <span>P {{ number_format($checkExpenses->sum('expenses_amount'), 2) }}</span>
                    </div> --}}
                </div>
                <div class="mb-6">
                    <h2 class="pb-2 mb-4 text-xl font-semibold border-b">Check Income</h2>
                    @foreach ($newPaymentsCheck as $payment)
                        <div class="flex justify-between py-2 border-b">
                            <span>{{ $payment->payment->lease->unit->unit_name ?? 'Unknown Unit' }} -
                                {{ $payment->payment->lease->property->property_name ?? 'Unknown Property' }}</span>
                            <span>Check #: {{ $payment->check_no }}</span>
                            <span> {{ $payment->date }}</span>
                            <span> {{ number_format($payment->rental_amount, 2) }}</span>
                        </div>
                    @endforeach

                    @php
   
    $leasesGrouped = [];
@endphp

@foreach ($leases as $lchek)
    @php
     
        $leaseId = $lchek->lease_id;

      
        if (!isset($leasesGrouped[$leaseId])) {
            $leasesGrouped[$leaseId] = [
                'lease' => $lchek,
                'total_security' => 0,
                'total_relief' => 0,
                'total_utilities' => 0
            ];
        }

       
        if ($lchek->security_deposit_paymentmethod == 'Check') {
            $leasesGrouped[$leaseId]['total_security'] += $lchek->security_deposit;
        }

        // Accumulate relief rental if payment method is "Check"
        if ($lchek->relief_rental_paymentmethod == 'Check') {
            $leasesGrouped[$leaseId]['total_relief'] += $lchek->relief_rental;
        }

        // Accumulate utilities if payment method is "Check"
        if ($lchek->utilities_paymentmethod == 'Check') {
            $leasesGrouped[$leaseId]['total_utilities'] += $lchek->utilities;
        }
    @endphp
@endforeach


@foreach ($leasesGrouped as $leaseData)
    @php
        $lease = $leaseData['lease'];
        $total = $leaseData['total_security'] + $leaseData['total_relief'] + $leaseData['total_utilities'];

        // Only display if there's any non-zero total (i.e., at least one check payment)
        if ($total > 0):
    @endphp

    <div class="flex items-center justify-between py-2 border-b">
        <div>
            <span>{{ $lease->client->owners_name }}<br></span>
            <span>{{ $lease->property->property_name }}<br></span>
            <span>{{ $lease->unit->unit_name }} (new)</span>
        </div>

        <div>
            <span>Bank: {{ $lease->security_deposit_bank  }}</span><br>
            <span>Check #: {{ $lease->security_deposit_chckno  }}</span><br>
            {{ 
                !empty($lease->relief_rental_chckdate) 
                ? \Carbon\Carbon::parse($lease->security_deposit_chckdate)->format('d-M-y') 
                : 'N/A' 
            }}
            <span>{{$lease->security_deposit }}</span>
           
        </div>
        <div>
            <span>Bank: {{ $lease->relief_rental_bank  }}</span><br>
            <span>Check #: {{ $lease->relief_rental_chckno  }}</span><br>
            {{ 
                !empty($lease->relief_rental_chckdate) 
                ? \Carbon\Carbon::parse($lease->relief_rental_chckdate)->format('d-M-y') 
                : 'N/A' 
            }}
        </span>

            <span>{{$lease->relief_rental }}</span>
           
        </div>
        
        <div>
            <span>Bank: {{  $lease->utilities_bank }}</span><br>
            <span>Check #: {{  $lease->utilities_chckno }}</span><br>
            {{ 
                !empty($lease->relief_rental_chckdate) 
                ? \Carbon\Carbon::parse($lease->utilities_chckdate)->format('d-M-y') 
                : 'N/A' 
            }}
        </span>
            <span>{{$lease->utilities }}</span>
            <span class="font-bold">
                @if ($lease->security_deposit_voucher || $lease->relief_rental_voucher || $lease->utilities_voucher)
                    V#{{ $lease->security_deposit_voucher ?? ($lease->relief_rental_voucher ?? $lease->utilities_voucher) }}
                @endif
            </span>
        </div>
    </div>

    @php
        endif; 
    @endphp
@endforeach


                </div>


                <div class="flex justify-between pt-4 mt-10 border-t">
                    <div class="w-1/2 pr-4 border-r border-gray-400">
                        <span class="block mb-2 font-bold">Prepared By:</span>
                        <span class="block h-6 mb-2">___________________________</span>
                        <span class="block mb-1 text-sm">Name</span>
                        <span class="block text-sm">{{ now()->format('d-M-Y') }}</span>
                    </div>
                    <div class="w-1/2 pl-4">
                        <span class="block mb-2 font-bold">Checked By:</span>
                        <span class="block h-6 mb-2">___________________________</span>
                        <span class="block text-sm">Name</span>
                    </div>
                </div>


            </div>

        </div>
    </div>
    <div class="mt-6 text-center">
        <button onclick="window.print()" class="px-4 py-2 text-white bg-green-500 rounded-lg">
            Print
        </button>
    </div>
@endsection
<script>
    function generateUniqueVoucher(formattedDate) {
        // Use the passed formatted date
        const dateParts = formattedDate.split('-');
        const day = String(dateParts[0]).padStart(2, '0'); // Ensure day is 2 digits
        const month = String(new Date(Date.parse(dateParts[1] + " 1, 2021")).getMonth() + 1).padStart(2, '0'); // Convert month to number
        const year = dateParts[2].slice(-2); // Get last 2 digits of the year

        // Combine to form the unique voucher (pure number format)
        const voucher = `${year}${month}${day}`;

        return voucher;
    }

    function checkAndGenerateVoucher() {
        const storedDate = localStorage.getItem('voucherDate');
        const storedVoucher = localStorage.getItem('voucher');
        const formattedDate = document.getElementById('formattedDate').innerText;

        // Check if we have a voucher for the specific date
        if (storedDate === formattedDate && storedVoucher) {
            // Use the existing voucher
            document.getElementById('voucher').value = storedVoucher;
        } else {
            // Generate a new voucher and store it
            const voucher = generateUniqueVoucher(formattedDate);
            document.getElementById('voucher').value = voucher;

            // Store the new voucher and date in localStorage
            localStorage.setItem('voucherDate', formattedDate);
            localStorage.setItem('voucher', voucher);
        }
    }

    // Set the voucher when the page loads
    document.addEventListener('DOMContentLoaded', checkAndGenerateVoucher);
</script>