@extends('layouts.admin')

@section('content')
<div class="container">
    <div class="row">
        <div class="col-md-12">
            <div class="card p-4">
                <div class="card-head">
                    <a href="{{ url()->previous() }}" class="btn btn-primary my-1">Back</a>
                </div>
                <div class="card-body">
                    <div class="row">
                        <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
                            <label for="" class="my-1">First Name</label>
                            <div class="border p-2">{{$order->user->name}}</div>
                            <label for="" class="my-1">Last Name</label>
                            <div class="border p-2">{{$order->user->last_name}}</div>
                            <label for="" class="my-1">Email</label>
                            <div class="border p-2">{{$order->user->email}}</div>
                            <label for="" class="my-1">Contact No</label>
                            <div class="border p-2">{{$order->user->phone}}</div>
                        </div>
                        <div class="col-md-6 table-responsive">
                            <table class="table  align-middle text-center">
                                <thead>
                                    <tr>
                                        <th>Name</th>
                                        <th>Quantity</th>
                                        <th>Price</th>
                                        <th>Image</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($order->orderItems as $item)
                                        <tr>
                                            <td class="text-ellipsis" style="max-width: 160px; overflow: hidden; text-overflow: ellipsis;">
                                                <a href="{{ url('admin/products/view/'.$item->product->id) }}">{{ $item->product->name }}</a>
                                            </td>
                                            <td>{{ $item->qty }}</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>
                                    @endforeach
                                </tbody>
                            </table>
                            @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>                            <div class="mt-3">
                                <label for="">Order Status</label>
                                <td>
                                    @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>
                                    @endif
                                </td>
                            </div>
@if ($order->delivery_option == 1)
    For Pickup
    @else
    For Delivery
    @endif
</div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection