@extends('layouts.sidebar')

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

            .print-content,
            .print-content * {
                visibility: visible;
                font-size: 11 pt;
                /* Adjust font size as needed */
                line-height: 1.2;
                /* Adjust line height for better spacing */
            }
         
            .sidebar,
            .header,
            .footer,
            .non-printable {
                display: none;
            }

            .print-content {
                position: absolute;
                left: 0;
                top: 0;
                width: calc(105% - 20mm);
               
                height: auto;
           
                box-sizing: border-box;
                padding: 2px;
              
                margin: 5mm;
               
            }

           
        }
    </style>


    <div class="container mx-aut">

        <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">San Roque Hermanas Inc.</h1>
                    <p class="text-gray-700">MGR BLDG. II, Matina Crossing, Davao City</p>
                    <p class="text-gray-700">Tel: (082)299-4103</p>
                    <p class="text-gray-700">Cell # 0910-651-1604</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>
                   

                 
                    <table class="w-full text-xs text-center border border-collapse">
                        <thead>
                            <tr class="bg-gray-100 border-b">
                                <th class="p-2 border">Description</th>
                                <th class="p-2 border">Voucher #</th>
                                <th class="p-2 border">Amount (P)</th>
                               
                            </tr>
                        </thead>
                        <tbody>
                            <!-- Collection Row -->
                            <tr class="border-b">
                                <td class="p-2 border">Collection</td>
                          
                                <td class="p-2 border">
                                    <input type="text" class="font-bold text-center border-none w-14" id="voucher" readonly>
                                </td>
                                <td class="p-2 border">
                                    P{{ number_format(
                                        $newPaymentsCash->sum('rental_amount') + 
                                        $newPaymentsEWCash->sum('waterbill_amount') + 
                                        $newPaymentsEWCash->sum('electricbill_amount'), 
                                        2
                                    ) }}
                                </td>
                            </tr>
                    
                            <!-- CR Income Rows -->
                            @foreach ($crIncome as $cr)
                            <tr class="border-b">
                                <td class="p-2 border">
                                    {{ $cr->property->property_name ?? 'Unknown Property' }} CR
                                </td>
                                <td class="p-2 border">—</td>
                                <td class="p-2 border">
                                    P{{ number_format($cr->amount, 2) }}
                                </td>
                                
                            </tr>
                            @endforeach
                    
                            <!-- Lease Payments Rows -->
                            @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;
                            @endphp
                    
                            @foreach ($leaseTotals as $lease)
                                @php
                                    $leaseTotal = $lease['security_deposit'] + $lease['relief_rental'] + $lease['utilities'];
                                    $grandTotal += $leaseTotal;
                                @endphp
                                <tr class="border-b">
                                    <td class="p-2 border">
                                        {{ $lease['property_name'] }} - {{ $lease['unit_name'] }} ({{ $lease['owners_name'] }})
                                    </td>
                                   
                                    <td class="p-2 border">—</td>
                                    <td class="p-2 border">
                                        P{{ number_format($leaseTotal, 2) }}
                                    </td>
                                </tr>
                            @endforeach
                    
                            <!-- Total Collection Row -->
                            <tr class="font-bold bg-gray-100">
                                <td colspan="2" class="p-2 border">Total Collection</tdc>
                                <td class="p-2 border">
                                    P{{ number_format(
                                        $newPaymentsCash->sum('rental_amount') + 
                                        $crIncome->sum('amount') + 
                                        $newPaymentsEWCash->sum('electricbill_amount') + 
                                        $newPaymentsEWCash->sum('waterbill_amount') + 
                                        $grandTotal, 
                                        2
                                    ) }}
                                </td>
                               
                            </tr>
                        </tbody>
                    </table>
                </div>   

                   

        

                <!-- Expenses Section -->
                <div class="mb-6">
                    <h2 class="pb-2 mb-4 text-xl font-semibold border-b">Expenses</h2>
                    
                    <table class="w-full text-xs text-center border border-collapse">
                        <thead>
                            <tr class="bg-gray-100 border-b">
                                <th class="p-2 border">Description</th>
                                <th class="p-2 border">Voucher #</th>
                               
                                <th class="p-2 border">Amount (P)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($expenses->groupBy('date') as $date => $expensesOnDate)
                                <!-- Display the voucher once for the entire group of expenses on the same date -->
                                @php $voucher = $expensesOnDate->first()->Voucher; @endphp
                                
                                @foreach ($expensesOnDate as $index => $expense)
                                <tr class="border-b">
                                    <!-- Display the date and voucher only in the first row of the group -->
                               
                                    <td class="p-2 border">{{ $expense->remarks }}</td>
                                    @if ($index === 0)
                                      
                                    <td class="p-2 border" rowspan="{{ $expensesOnDate->count() }}">{{ $voucher }}</td>
                                @endif
                                    <td class="p-2 border">P {{ number_format($expense->expenses_amount, 2) }}</td>
                                </tr>
                                @endforeach
                            @endforeach
                
                            <!-- Total Expenses Row -->
                            <tr class="font-bold bg-gray-100">
                                <td colspan="2" class="p-2 text-right border">Total Expenses:</td>
                                <td class="p-2 border">P {{ number_format($expenses->sum('expenses_amount'), 2) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </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>
                
                    <table class="w-full text-xs text-center border border-collapse">
                        <thead>
                            <tr class="bg-gray-100 border-b">
                            <th class="p-2 border">Description</th>
                                <th class="p-2 border">Check #</th>
                                <th class="p-2 border">Check Date</th>
                                <th class="p-2 border">Voucher #</th>
                                <th class="p-2 border">Amount (P)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($checkExpenses as $checkExpense)
                                <tr class="border-b">
                                <td class="p-2 border">{{ $checkExpense->remarks }}</td>
                                    <td class="p-2 border">{{ $checkExpense->check_number }}</td>
                                    <td class="p-2 border">{{ $checkExpense->check_date }}</td>
                                    <td class="p-2 border">V#{{ $checkExpense->Voucher }}</td>
                                    <td class="p-2 border">P {{ number_format($checkExpense->expenses_amount, 2) }}</td>
                                   
                                   
                                </tr>
                            @endforeach
                
                            <!-- Total Check Expenses Row -->
                            <tr class="font-bold bg-gray-100">
                                <td colspan="4" class="p-2 text-right border">Total Check Expenses:</td>
                              
                                <td class="p-2 border">P {{ number_format($checkExpenses->sum('expenses_amount'), 2) }}</td>
                                
                            </tr>
                        </tbody>
                    </table>
                </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>