@extends('layouts.pdf')
@section('title', 'Invoice')
@section('heading', 'Invoice')

@section('content')
<div>
    @if (isset($invoice->id))
        <style>
            @page {
                margin: 20mm;
            }

            body {
                font-family: Arial, sans-serif;
                font-size: 10pt;
                color: #000;
            }

            .invoice-header {
                margin-bottom: 20px;
            }

            .company-name {
                font-size: 18pt;
                font-weight: bold;
                margin-bottom: 10px;
            }

            .invoice-info {
                display: flex;
                justify-content: space-between;
                margin-bottom: 20px;
            }

            .invoice-info-left {
                font-size: 11pt;
            }

            .invoice-info-right {
                text-align: right;
                font-size: 11pt;
            }

            table {
                width: 100%;
                border-collapse: collapse;
                margin-bottom: 20px;
                font-size: 9pt;
            }

            th {
                background-color: #f0f0f0;
                border: 1px solid #000;
                padding: 6px;
                text-align: center;
                font-weight: bold;
            }

            td {
                border: 1px solid #000;
                padding: 4px 6px;
                text-align: center;
            }

            .text-right {
                text-align: right;
            }

            .text-left {
                text-align: left;
            }

            .summary-section {
                float: right;
                width: 250px;
                margin-top: 20px;
            }

            .summary-row {
                display: flex;
                justify-content: space-between;
                margin-bottom: 8px;
                padding: 4px 0;
            }

            .summary-label {
                font-weight: bold;
            }

            .summary-value {
                text-align: right;
                min-width: 100px;
            }

            .footer-section {
                margin-top: 40px;
                clear: both;
                display: flex;
                justify-content: space-between;
                font-size: 9pt;
            }

            .footer-left {
                width: 45%;
            }

            .footer-right {
                width: 45%;
                text-align: right;
            }

            .order-group {
                border-top: 2px solid #000;
            }

            .order-total-row {
                background-color: #f5f5f5;
                font-weight: bold;
            }
        </style>

  <table width="100%" style="border: none; margin-bottom: 20px;">
    <tr>
        <td style="border: none; text-align: left; vertical-align: middle;">
            <div class="company-name" style="font-size: 18pt; font-weight: bold; margin: 0;">
                {{ optional(optional(optional($orders->first())->orderable)->partner)->organization_name ?? 'N/A' }}
            </div>
        </td>
        
        <td style="border: none; text-align: right; vertical-align: middle;">
            <img src="{{ public_path('assets/media/logos/alpine.png') }}" 
                 alt="logo" 
                 style="max-width: 200px; height: auto;" />
        </td>
    </tr>
</table>


        <div class="invoice-info">
            <div class="invoice-info-left">
                     
                <strong>Invoice #:</strong> {{ $invoice->id }}<br>
                <strong>Invoice Date:</strong>   
                    {{ $invoice->closed_at 
                        ? \Carbon\Carbon::parse($invoice->closed_at)->format('d M, Y') 
                        : 'Not yet closed' 
                    }}
                        </div>
                    </div>

        @php
            $allLineItems = [];
            $sortedOrders = $orders->sortBy(function ($order) {
                $earliestBooking = $order->bookings->min('booking_date');
                if ($earliestBooking) return \Carbon\Carbon::parse($earliestBooking)->format('Y-m-d');
                if ($order->order_date) return \Carbon\Carbon::parse($order->order_date)->format('Y-m-d');
                return $order->created_at?->format('Y-m-d') ?? '9999-12-31';
            })->values();
            
            foreach ($sortedOrders as $order) {
                $orderDate = optional($order->bookings->first())->booking_date 
                    ? \Carbon\Carbon::parse($order->bookings->first()->booking_date)->format('Y-m-d')
                    : ($order->order_date ? \Carbon\Carbon::parse($order->order_date)->format('Y-m-d') : '');
                
                // Group passengers by tour name and type (like invoice-view)
                $tourTypeCounts = [];
                $tourTypePrices = [];
                $tourTypeDiscounts = [];
                $tourTypeTaxes = [];
                
                foreach ($order->bookings as $booking) {
                    $tourName = $booking->tour->name ?? 'N/A';
                    
                    foreach ($booking->passengers as $passenger) {
                        $type = $passenger->type ?? 'N/A';
                        $price = $passenger->price ?? 0;
                        $discount = (float) $passenger->discountedPrice();
                        $tax = $passenger->effectiveTaxTotal();
                        
                        // Store data grouped by tour and type
                        if (!isset($tourTypeCounts[$tourName][$type])) {
                            $tourTypeCounts[$tourName][$type] = 1;
                            $tourTypePrices[$tourName][$type] = $price;
                            $tourTypeDiscounts[$tourName][$type] = $discount;
                            $tourTypeTaxes[$tourName][$type] = $tax;
                        } else {
                            $tourTypeCounts[$tourName][$type]++;
                            $tourTypePrices[$tourName][$type] += $price;
                            $tourTypeDiscounts[$tourName][$type] += $discount;
                            $tourTypeTaxes[$tourName][$type] += $tax;
                        }
                    }
                }
                
                // Add tour/type rows grouped by tour and passenger type
                foreach ($tourTypeCounts as $tourName => $types) {
                    foreach ($types as $type => $count) {
                        $totalPrice = $tourTypePrices[$tourName][$type] ?? 0;
                        $totalDiscount = $tourTypeDiscounts[$tourName][$type] ?? 0;
                        $totalTax = $tourTypeTaxes[$tourName][$type] ?? 0;
                        
                        // Calculate single price
                        $singlePrice = $count > 0 ? $totalPrice / $count : 0;
                        
                        // Calculate subtotal
                        $subtotal = $totalPrice;
                        
                        // Calculate taxes (GST)
                        $lineGST = $totalTax;
                        
                        // Add tour/type product line
                        $allLineItems[] = [
                            'order_id' => $order->id,
                            'partner_ref_id' => $order->partner_ref_id ?? '',
                            'date' => $orderDate,
                            'product' => $tourName,
                            'rate' => ucfirst($type),
                            'price' => $singlePrice,
                            'qty' => $count,
                            'subtotal' => $subtotal,
                            'discount' => $totalDiscount,
                            'gst' => $lineGST,
                            'total' => $subtotal + $totalDiscount + $lineGST,
                        ];
                    }
                }
                
                // Process line items (order => many lineItems, lineItem => many discounts AND taxes)
                foreach ($order->lineItems as $lineItem) {
                    $qty = $lineItem->qty ?? 1;
                    $price = $lineItem->price ?? 0;
                    $lineSubtotal = $price * $qty;
                    $lineGST = $lineItem->effectiveTaxTotal();
                    
                    // Calculate discount from lineItem
                    $lineItemDiscount = 0;
                    $lineItemDiscounts = $lineItem->discounts ?? [];
                    if (!empty($lineItemDiscounts)) {
                        foreach ($lineItemDiscounts as $discount) {
                            $discountIsPercentage = ($discount['type'] ?? '') === 'percentage';
                            $discountAmount = $discountIsPercentage
                                ? -1 * ($lineSubtotal * $discount['value']/100) 
                                : $discount['value'];
                            $lineItemDiscount += $discountAmount;
                        }
                    }
                    
                    // Add line item product
                    $allLineItems[] = [
                        'order_id' => $order->id,
                        'partner_ref_id' => $order->partner_ref_id ?? '',
                        'date' => $orderDate,
                        'product' => $lineItem->name ?? 'Line Item',
                        'rate' => ucfirst($lineItem->type ?? 'Individual'),
                        'price' => $price,
                        'qty' => $qty,
                        'subtotal' => $lineSubtotal,
                        'discount' => $lineItemDiscount,
                        'gst' => $lineGST,
                        'total' => $lineSubtotal + $lineItemDiscount + $lineGST,
                    ];
                    
                }
                
            }
            
            // Get totals from database (from updateOrderTotals function)
            $subtotal = $orders->sum('total_price');
            $totalDiscount = abs($orders->sum('discount')); // discount is stored as negative
            $totalGST = $orders->sum('taxes');
            $totalPaid = $orders->sum('paid');
            
            $groupedByOrder = [];
            foreach ($allLineItems as $item) {
                $orderId = $item['order_id'];
                if (!isset($groupedByOrder[$orderId])) {
                    $order = $sortedOrders->firstWhere('id', $orderId);
                    $orderTotal = ($order->total_price + $order->discount) + ($order->taxes ?? 0);
                    $groupedByOrder[$orderId] = [
                        'partner_ref_id' => $item['partner_ref_id'],
                        'date' => $item['date'],
                        'items' => [],
                        'order_total' => $orderTotal,
                        'order_paid' => $order->paid ?? 0,
                    ];
                }
                $groupedByOrder[$orderId]['items'][] = $item;
            }
            
            // finalTotal = subtotal + discount (negative) + taxes
            $finalTotal = $subtotal + $orders->sum('discount') + $totalGST;
            $balanceDue = $finalTotal - $totalPaid;
        @endphp

        <table>
            <thead>
                <tr>
                    <th>Order #</th>
                    <th>Reference #</th>
                    <th>Date</th>
                    <th>Product</th>
                    <th>Rate</th>
                    <th>Price</th>
                    <th>Qty</th>
                    <th>Subtotal</th>
                    <th>Discount</th>
                    <th>Taxes</th>
                    <th>Total</th>
                    <th>Paid</th>
                    <th>Due</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($groupedByOrder as $orderId => $orderData)
                    @foreach ($orderData['items'] as $index => $item)
                        <tr class="{{ $index === 0 ? 'order-group' : '' }}">
                            @if ($index === 0)
                                <td rowspan="{{ count($orderData['items']) }}">{{ $orderId }}</td>
                                <td rowspan="{{ count($orderData['items']) }}">{{ $orderData['partner_ref_id'] ?: 'N/A' }}</td>
                                <td rowspan="{{ count($orderData['items']) }}">{{ $orderData['date'] }}</td>
                            @endif
                            <td class="text-left">{{ $item['product'] ?? '' }}</td>
                            <td class="text-left">{{ $item['rate'] ?? '' }}</td>
                            <td class="text-right">{{ ($item['price'] ?? 0) < 0 ? '-' : '' }}${{ number_format(abs($item['price'] ?? 0), 2) }}</td>
                            <td>{{ ($item['qty'] ?? 0) < 0 ? '-' : '' }}{{ abs($item['qty'] ?? 0) }}</td>
                            <td class="text-right">{{ ($item['subtotal'] ?? 0) < 0 ? '-' : '' }}${{ number_format(abs($item['subtotal'] ?? 0), 2) }}</td>
                            <td class="text-right">{{ ($item['discount'] ?? 0) < 0 ? '-' : '' }}${{ number_format(abs($item['discount'] ?? 0), 2) }}</td>
                            <td class="text-right">{{ ($item['gst'] ?? 0) < 0 ? '-' : '' }}${{ number_format(abs($item['gst'] ?? 0), 2) }}</td>                            
                            @if ($index === 0)
                                <td rowspan="{{ count($orderData['items']) }}" class="text-right order-total-row">
                                    {{ $orderData['order_total'] < 0 ? '-' : '' }}${{ number_format(abs($orderData['order_total']), 2) }}
                                </td>
                                <td rowspan="{{ count($orderData['items']) }}" class="text-right order-total-row">
                                    {{ $orderData['order_paid'] < 0 ? '-' : '' }}${{ number_format(abs($orderData['order_paid']), 2) }}
                                </td>
                                @php
                                    $orderDue = $orderData['order_total'] - $orderData['order_paid'];
                                @endphp
                                <td rowspan="{{ count($orderData['items']) }}" class="text-right order-total-row">
                                    {{ $orderDue < 0 ? '-' : '' }}${{ number_format(abs($orderDue), 2) }}
                                </td>
                            @endif
                        </tr>
                    @endforeach
                @endforeach
            </tbody>
        </table>
            <table width="100%" cellpadding="0" cellspacing="0" border="0" style="font-family: Arial, sans-serif; margin-bottom: 30px;">
                <tr>
                    <td width="55%">&nbsp;</td>
                    <td width="45%">
                        <table width="100%" cellpadding="0" cellspacing="0" border="0" style="font-size: 10pt; line-height: 1.5;">
                            <tr>
                                <td style="padding: 4px 0; font-weight: bold;">Subtotal:</td>
                                <td style="padding: 4px 0; text-align: right;">{{ $subtotal < 0 ? '-' : '' }}${{ number_format(abs($subtotal), 2) }}</td>
                            </tr>
                            <tr>
                                <td style="padding: 4px 0; font-weight: bold;">Discount:</td>
                                <td style="padding: 4px 0; text-align: right;">-${{ number_format($totalDiscount, 2) }}</td>
                            </tr>
                            <tr>
                                <td style="padding: 4px 0; font-weight: bold;">Taxes:</td>
                                <td style="padding: 4px 0; text-align: right;">{{ $totalGST < 0 ? '-' : '' }}${{ number_format(abs($totalGST), 2) }}</td>
                            </tr>
                            <tr>
                                <td colspan="2" style="border-top: 1px solid #000; padding: 4px 0;"></td>
                            </tr>
                            <tr>
                                <td style="font-weight: bold; font-size: 11pt;">Total:</td>
                                <td style="text-align: right; font-weight: bold; font-size: 11pt;">{{ $finalTotal < 0 ? '-' : '' }}${{ number_format(abs($finalTotal), 2) }}</td>
                            </tr>
                            <tr>
                                <td style="padding: 4px 0; font-weight: bold;">Payments:</td>
                                <td style="padding: 4px 0; text-align: right;">-${{ number_format($totalPaid, 2) }}</td>
                            </tr>
                            <tr>
                                <td colspan="2" style="border-top: 1px solid #000; padding: 4px 0;"></td>
                            </tr>
                            <tr>
                                <td style="font-weight: bold; font-size: 11pt;">Balance Due:</td>
                                <td style="text-align: right; font-weight: bold; font-size: 11pt;">{{ $balanceDue < 0 ? '-' : '' }}${{ number_format(abs($balanceDue), 2) }}</td>
                            </tr>
                        </table>
                    </td>
                </tr>
            </table>

            <table width="100%" cellpadding="0" cellspacing="0" border="0" style="font-family: Arial, sans-serif; border-top: 1px solid #dddddd; padding-top: 20px;">
                <tr>
                    <td width="48%" valign="top" style="text-align: left; font-size: 12px; color: #333333; line-height: 1.4;">
                        <strong style="color: #000;">G.S.T Registration No:</strong> 84417 5539 RT0001<br>
                        <strong style="color: #000;">Currency:</strong> Canadian Dollars
                    </td>
                    <td width="4%">&nbsp;</td>
                    <td width="48%" valign="top" style="text-align: right; font-size: 12px; color: #333333; line-height: 1.4;">
                        Please indicate invoice # on all payments<br>
                        <strong style="color: #000;">Remit any Balance Owing to:</strong><br>
                        1295 Industrial Rd Kelowna BC Canada V1Z 1G4<br>
                        <strong style="color: #000;">Or send remittance advice to:</strong><br>
                        <a href="mailto:gcousins@alpinehelicopters.com" style="color: #004a99; text-decoration: none;">gcousins@alpinehelicopters.com</a>
                    </td>
                </tr>
            </table>
    @endif
</div>
@endsection