@extends('layouts.customer')

@section('title')
    My Orders
@endsection

@section('content')

<script src="https://maps.googleapis.com/maps/api/js?key=YOUR_API_KEY&callback=initMap&v=weekly" async defer></script>

<br>
<br>
<br>
<div class="container my-4">
    <div class="row">
        <div class="col-md-12">
            <div class="card p-4">
                <div class="card-header">
                <button onclick="window.history.back()" class="btn btn-secondary me-2">
    Back
</button>
                    <br>
                    <br>
                    <h4>My Orders</h4>
                </div>
                <div class="card-body">
                    <div class="row mb-4">
                        <div class="col-md-6">
                            <h5>Order Information</h5>
                            <hr>
                            <p><strong>Tracking Number:</strong> {{ $order->tracking_no }}</p>
                            <p><strong>Date Ordered :</strong> {{ $order->created_at->format('F j, Y h:i A') }}
</p>                        
                         @if ($order->status == '8')
                        <p><strong>Date Completed :</strong> {{ $order->updated_at->format('F j, Y h:i A') }}</p>
                        @endif

                            <hr>
                            <strong><h5>Rider</h5></strong> 
                            @if ($order->rider_id)
                                @php
                                    $rider = \App\Models\User::where('id', $order->rider_id)->where('role_as', 3)->first();
                                @endphp
                                @if ($rider)
                                    <p><strong>Rider Name:</strong> {{ $rider->name }} {{ $rider->last_name }}</p>
                                    <p><strong>Contact No.:</strong> {{ $rider->phone }}</p>
                                @else
                                    <p>Rider information not available.</p>
                                @endif
                            @else
                                <p>No rider information available.</p>
                            @endif
                            <hr>
                            @if ($order->delivery_option == 2)
                                <h5>Delivery Address</h5>
                                @php
                                    $address = \App\Models\Addresses::find($order->addresses_id);
                                @endphp
                                @if($address)
                                    <p>{{ $address->barangay }}, {{ $address->municipal }}, {{ $address->streets }}</p>
                                    <p>{{ $order->streets }}</p>
                                    <p>{{ $order->description }}</p>
                                @else
                                    <p>Address not found</p>
                                @endif
                            @elseif ($order->delivery_option == 1)
                                <h5>Pickup Address</h5>
                                @php
                                    $product = $order->product;
                                    $shopstreets = $product->user->shop->streets ?? 'N/A';
                                    $shopMunicipal = $product->user->shop->municipal ?? 'N/A';
                                    $shopBarangay = $product->user->shop->barangay ?? 'N/A';
                                @endphp
                                <p>{{ $shopstreets }}, {{ $shopBarangay }}, {{ $shopMunicipal }}</p>
                            @endif
                        </div>
                        <div class="col-md-6">
                            <h5>Order Details</h5>
                            <hr>
                            <div class="table-responsive">
                                <table class="table table-striped">
                                    <thead>
                                        <tr>
                                            <th>Name</th>
                                            <th>Quantity</th>
                                            <th>Price</th>
                                            <th>Image</th>
                                        </tr>
                                    </thead>
                                    <tbody>
    @foreach ($order->orderItems as $item)
        @if ($item->status == 0)
            <tr>
                <td><a href="{{ url(asset('view-product/'.$item->prod_id)) }}">{{ $item->product->name }}</a></td>
                <td><center>{{ $item->qty }}</center></td>
                <td>
                    @php
                        // Fetch the price that is not the latest in terms of timestamp
                        $activePrice = $item->product->productPrices()
                            ->where('is_active', 1)
                            ->where('created_at', '<', $item->created_at) // Compare timestamps
                            ->orderBy('created_at', 'desc') // Order by descending timestamp
                            ->first();
                    @endphp
                    @if ($activePrice)
                        ₱{{ number_format($activePrice->price, 2, '.', ',') }}
                    @else
                        No price available
                    @endif
                </td>
                <td>
                    @if ($item->product->product_images->isNotEmpty())
                        <img src="{{ asset('upload/product/'.$item->product->product_images->first()->image) }}" alt="Product Image" style="width: 100px; height: 100px;">
                    @else
                        <span>Image not found</span>
                    @endif
                </td>
            </tr>
        @endif
    @endforeach
</tbody>

                                </table>
                            </div>

                            @php
// Define the getDeliveryFee function
if (!function_exists('getDeliveryFee')) {
        function getDeliveryFee($shopId) {    $deliveryRate = \App\Models\DeliveryRate::
                                             where('is_active', 1)
                                              ->value('delivery_fee');
    return $deliveryRate ? $deliveryRate : 0;
}

}
@endphp
                  @php
    // Calculate grand total
    $grandTotal = 0;

    if ($order->delivery_option == 2) {
        $shippingFee = getDeliveryFee($order->shop_id);
        $grandTotal += $shippingFee;
    }

    // Calculate subtotal
    foreach ($order->orderItems as $item) {
        if ($item->status == 0) {
            // Fetch the price based on timestamp comparison
            $activePrice = $item->product->productPrices()
                ->where('is_active', 1)
                ->where('created_at', '<', $item->created_at) // Compare timestamps
                ->orderBy('created_at', 'desc') // Order by descending timestamp
                ->first();

            $originalPrice = $activePrice ? $activePrice->price : 0;
            $subtotal = $originalPrice * $item->qty;
            $grandTotal += $subtotal;
        }
    }
@endphp

                            @if ($order->delivery_option == 2)
                                <p class="shipping-fee">Shipping Fee: ₱ {{ number_format($shippingFee, 2, '.', ',') }}</p>
                            @endif
                            <h4 class="px-2">Grand Total: <span class="float-end">₱{{ number_format($grandTotal, 2, '.', ',') }}</span></h4>
                            <h8 class="px-2 mt-3">Status: 
                                @if ($order->delivery_option == 2)
                                    @if ($order->status == '0')
                                        <span class="badge bg-warning text-dark">Pending</span> 
                                    @elseif ($order->status == '1')
                                        <span class="badge bg-primary text-white">Approved Order </span>
                                    @elseif ($order->status == '2')
                                        <span class="badge bg-secondary text-white">Order Packed</span> 
                                    @elseif ($order->status == '3')
                                        <span class="badge bg-info text-white">Ready for Delivery</span>
                                    @elseif ($order->status == '4')
                                        <span class="badge bg-info text-white">Assigned to a rider</span>
                                    @elseif ($order->status == '5')
                                        <span class="badge bg-info text-white">Picked up</span>
                                    @elseif ($order->status == '6')
                                        <span class="badge bg-info text-white">Order is on the way</span>
                                    @elseif ($order->status == '7')
                                        <span class="badge bg-success text-white">Order Done </span>
                                    @elseif ($order->status == '8')
                                        <span class="badge bg-success text-white">Order Received </span>
                                    @elseif ($order->status == '11')
                                        <span class="badge bg-danger text-white">Cancelled Order</span>
                                    @endif
                                @elseif ($order->delivery_option == 1)
                                    @if ($order->status == '0')
                                        <span class="badge bg-warning text-dark">Pending</span> 
                                    @elseif ($order->status == '1')
                                        <span class="badge bg-primary text-white">Approved Order </span>
                                    @elseif ($order->status == '2')
                                        <span class="badge bg-secondary text-white">Order Packed</span> 
                                    @elseif ($order->status == '3')
                                        <span class="badge bg-info text-white">Ready for Pickup</span>
                                    @elseif ($order->status == '7')
                                        <span class="badge bg-success text-white">Order Done </span>
                                    @elseif ($order->status == '8')
                                        <span class="badge bg-success text-white">Order Received </span>
                                    @endif
                                @endif
                            </h8>
                            <br>
                            <br>
                            <br>
                            <br>
                            <td>
                                @if($order->status == '0')
                                    <form action="{{ route('cancel.order', ['orderId' => $order->id]) }}" method="POST" class="d-inline">
                                        @csrf
                                        @method('PATCH')
                                        <input type="hidden" name="status" value="11">
                                        <button type="submit" class="btn btn-outline-danger" onclick="return confirm('Are you sure you want to cancel this order?')">Cancel Order</button>
                                    </form>
                                @endif
                            </td>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection