@extends('layouts.sidebar')

@section('content')
    <!-- Print Button -->
    <div class="container mx-auto">
        <a href="{{ url('waterbill') }}"
            class="px-4 py-2 mb-2 font-bold text-white bg-blue-500 rounded hover:bg-blue-700">back
        </a>
        <div class="mb-4 text-right">
            <button onclick="printDiv('print-section')" class="px-4 py-2 text-white bg-blue-500 rounded">
                Print
            </button>
        </div>
        <form id="filterForm" method="GET" action="{{ url('waterbilloutput') }}" class="mb-4">
            <div class="flex items-center space-x-4">
                <!-- Day Dropdown -->
                <label for="day" class="text-sm font-semibold">Day:</label>
                <select id="day" name="day"
                    class="text-sm text-gray-600 border-2 border-gray-300 rounded-md shadow-sm focus:border-blue-500 focus:ring focus:ring-blue-500 focus:ring-opacity-50">
                    <option value="">Select Day</option>
                    @for ($i = 1; $i <= 31; $i++)
                        <option value="{{ $i }}" {{ request('day') == $i ? 'selected' : '' }}>
                            {{ $i }}
                        </option>
                    @endfor
                </select>

                <!-- Month Dropdown -->
                <label for="month" class="text-sm font-semibold">Month:</label>
                <select id="month" name="month"
                    class="text-sm text-gray-600 border-2 border-gray-300 rounded-md shadow-sm focus:border-blue-500 focus:ring focus:ring-blue-500 focus:ring-opacity-50">
                    <option value="">Select Month</option>
                    @foreach (range(1, 12) as $month)
                        <option value="{{ $month }}" {{ request('month') == $month ? 'selected' : '' }}>
                            {{ \Carbon\Carbon::create()->month($month)->format('F') }}
                        </option>
                    @endforeach
                </select>

                <!-- Year Dropdown -->
                <label for="property_id" class="text-sm font-semibold">Property Name:</label>
                <select id="property_id" name="property_id"
                    class="text-sm text-gray-600 border-2 border-gray-300 rounded-md shadow-sm focus:border-blue-500 focus:ring focus:ring-blue-500 focus:ring-opacity-50">
                    <option value="">Select Property</option>
                    @foreach ($properties as $property)
                        <option value="{{ $property->id }}" {{ request('property_id') == $property->id ? 'selected' : '' }}>
                            {{ $property->property_name }}
                        </option>
                    @endforeach
                </select>

                <button type="submit" class="px-4 py-2 text-white bg-blue-500 rounded">Filter</button>
            </div>
        </form>
        <div id="print-section">
            <div class="grid grid-cols-2">
                @foreach ($data as $cl)
                    <div class="max-w-full p-4 mb-4 border border-gray-300 rounded-lg ">
                        <h2 class="mb-2 text-sm font-semibold text-center">RWEB Solutions Corp.</h2>
                        <h3 class="mb-2 text-xs font-semibold text-center">Water Bill</h3>

                        <table class="w-full text-xs border border-collapse border-gray-300">
                            <tbody>
                                <tr>
                                    <td class="px-2 py-1 font-semibold border-b border-gray-400">Period Covered:</td>
                                    <td class="px-2 py-1 text-center border-b border-gray-400">
                                        @php
                                            $startDate = \Carbon\Carbon::parse($cl->start_date);
                                            $endDate = \Carbon\Carbon::parse($cl->end_date);
                                            $payOnDate = $endDate->copy()->addMonth()->startOfMonth()->day(8);
                                        @endphp
                                        {{ $startDate->format('d-M-y') }} - {{ $endDate->format('d-M-y') }}
                                    </td>
                                </tr>
                                <tr>
                                    <td class="px-2 py-1 font-semibold border-b border-gray-400">Name:</td>
                                    <td class="px-2 py-1 text-center border-b border-gray-400">
                                        {{ $cl->billing->lease->client->owners_name }}
                                    </td>
                                </tr>
                                <tr>
                                    <td class="px-2 py-1 font-semibold border-b border-gray-400">Location:</td>
                                    <td class="px-2 py-1 text-center border-b border-gray-400">
                                        {{ $cl->billing->lease->property->property_name }},
                                        {{ $cl->billing->lease->unit->unit_name }}
                                    </td>
                                </tr>
                                <tr>
                                    <td class="px-2 py-1 font-semibold border-b border-gray-400">Previous Reading:</td>
                                    <td class="px-2 py-1 text-center border-b border-gray-400">
                                        {{ $cl->previous_reading }}
                                    </td>
                                </tr>
                                <tr>
                                    <td class="px-2 py-1 font-semibold border-b border-gray-400">Present Reading:</td>
                                    <td class="px-2 py-1 text-center border-b border-gray-400">
                                        {{ $cl->present_reading }}
                                    </td>
                                </tr>
                                <tr>
                                    <td class="px-2 py-1 font-semibold border-b border-gray-400">Consumption:</td>
                                    <td class="px-2 py-1 text-center border-b border-gray-400">
                                        {{ $cl->consumption }}
                                    </td>
                                </tr>
                            </tbody>
                        </table>

                        @php
                            $consumption = $cl->consumption;
                            $rates =
                                $cl->rate == '2.0'
                                    ? [357.0, 37.4, 48.4, 64.2, 93.6]
                                    : [312.25, 32.7, 42.35, 56.15, 81.9];

                            $amounts = [0, 0, 0, 0, 0];
                            $cn = [0, 0, 0, 0, 0];
                            $total = 0;

                            if ($consumption <= 10) {
                                $amounts[0] = $rates[0];
                            } elseif ($consumption <= 20) {
                                $amounts[0] = $rates[0];
                                $amounts[1] = ($consumption - 10) * $rates[1];
                                $cn[0] = 10;
                                $cn[1] = $consumption - 10;
                            } elseif ($consumption <= 30) {
                                $amounts[0] = $rates[0];
                                $amounts[1] = 10 * $rates[1];
                                $amounts[2] = ($consumption - 20) * $rates[2];
                                $cn[0] = 10;
                                $cn[1] = 10;
                                $cn[2] = $consumption - 20;
                            } elseif ($consumption <= 40) {
                                $amounts[0] = $rates[0];
                                $amounts[1] = 10 * $rates[1];
                                $amounts[2] = 10 * $rates[2];
                                $amounts[3] = ($consumption - 30) * $rates[3];
                                $cn[0] = 10;
                                $cn[1] = 10;
                                $cn[2] = 10;
                                $cn[3] = $consumption - 30;
                            } else {
                                $amounts[0] = $rates[0];
                                $amounts[1] = 10 * $rates[1];
                                $amounts[2] = 10 * $rates[2];
                                $amounts[3] = 10 * $rates[3];
                                $amounts[4] = ($consumption - 40) * $rates[4];
                                $cn[0] = 10;
                                $cn[1] = 10;
                                $cn[2] = 10;
                                $cn[3] = 10;
                                $cn[4] = $consumption - 40;
                            }

                            $total = array_sum($amounts);
                        @endphp

                        <div class="mt-4">
                            <h4 class="mb-2 text-xs font-semibold">Bracket # & Commodity Charge</h4>
                            <div class="grid grid-cols-4 gap-2 text-xs">
                                <div>
                                    <p>1-10</p>
                                    <p>11-20</p>
                                    <p>21-30</p>
                                    <p>31-40</p>
                                    <p>41 and up</p>
                                </div>
                                <div>
                                    <p>{{ number_format($cn[0], 2) }}</p>
                                    <p>{{ number_format($cn[1], 2) }}</p>
                                    <p>{{ number_format($cn[2], 2) }}</p>
                                    <p>{{ number_format($cn[3], 2) }}</p>
                                    <p>{{ number_format($cn[4], 2) }}</p>
                                </div>
                                <div>
                                    <p>{{ number_format($rates[0], 2) }} =</p>
                                    <p>{{ number_format($rates[1], 2) }} =</p>
                                    <p>{{ number_format($rates[2], 2) }} =</p>
                                    <p>{{ number_format($rates[3], 2) }} =</p>
                                    <p>{{ number_format($rates[4], 2) }}</p>
                                </div>
                                <div>
                                    <p>{{ number_format($amounts[0], 2) }}</p>
                                    <p>{{ number_format($amounts[1], 2) }}</p>
                                    <p>{{ number_format($amounts[2], 2) }}</p>
                                    <p>{{ number_format($amounts[3], 2) }}</p>
                                    <p>{{ number_format($amounts[4], 2) }}</p>
                                </div>
                            </div>

                            @php
                                $consumption = $totals[$cl->waterbill_id]['total_consumption'] ?? 0;
                                $bill = $totals[$cl->waterbill_id]['total_amount'] ?? 0; // Keep this as a number for calculations
                                $difference = $bill - $consumption; // Calculate the difference

                                // Check to prevent division by zero
                                $percentage_collection = $consumption > 0 ? $cl->amount / $consumption : 0;

                                // Calculate losses
                                $losses = $percentage_collection * $difference;
                                $total = $losses + $cl->amount;
                                $roundedTotal = ceil($total); // Round up to the nearest whole number

                            @endphp
                            <div class="flex gap-2 mr-4">
                                <p class="text-xs ">Additional Charge<br>
                                    (pro-rated
                                    based on gen loss)
                                    :</p>

                                <p class="text-xs font-semibold"> {{ number_format($losses, 2) }} </p>

                            </div>
                            <div class="flex justify-end gap-2 mr-4">
                                <p class="">Total</p>
                                <p class="font-semibold"> {{ number_format($losses + $cl->amount, 2) }}</p>
                            </div>
                            <div class="flex justify-start gap-2 mr-4 text-xs">
                                <p>Please pay on: <span class="font-semibold">{{ $payOnDate->format('d-M-y') }}</span></p>
                                {{-- <p class="font-semibold"></p> --}}
                            </div>
                        </div>
                    </div>
                @endforeach



            </div>
        </div>
        <div class="pagination">
            {{ $data->links() }}
        </div>
    </div>
    <style>
        @media print {
            @page {
                size: legal;
                margin: 1in;
            }

            body {
                width: 8.5in;
                height: 14in;
            }

            /* Optional: adjust any specific elements for better layout on legal size */
            .print-content {
                /* Example adjustments */
                font-size: 12pt;
                line-height: 1.2;
            }
        }
    </style>
    <script>
        function printDiv(divId) {
            var printContents = document.getElementById(divId).innerHTML;
            var originalContents = document.body.innerHTML;

            document.body.innerHTML = printContents;
            window.print();
            document.body.innerHTML = originalContents;
            window.location.reload(); // reload to ensure any dynamic content is restored
        }
    </script>
@endsection