@extends('layouts.admin')

@section('content')
    <div class="row">
        <div class="card-body">
            <div class="card mb-2">
                <div class="card-header">
                    <h5>Product Sales Reports</h5>
                </div>

                <div class="card-body">
                    <!-- Display total sales with fee and shipping -->
                    <div class="alert alert-info">
                        Total Orders Transactions  
                    </div>

                    @php
    use Illuminate\Support\Str;
@endphp

                    <!-- Display a table for completed orders with status 13 -->
                    <table class="table table-bordered">
    <thead>
        <tr>
            <th class="text-center">Tracking ID</th>
            <th class="text-center">Date Completed</th>

            <th class="text-center">Revenue</th>
            <th class="text-center">Order Done</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($completedOrders as $order)
            @foreach ($order->orderItems as $item)
                <tr>
                    <td class="text-center">{{ $order->tracking_no }}</td>
                    
                    <td class="text-center">{{ $order->created_at->format('d M Y') }}</td>

                    <td class="text-center">
                    @php
    $activePrice = $item->product->product_prices()
        ->where('is_active', 1)
        ->where('created_at', '<', $item->created_at)
        ->orderBy('created_at', 'desc')
        ->first();

    if ($activePrice) {
        $revenue = $activePrice->price * $item->qty;
        if ($item->order->delivery_options == 2) {
            $revenue -= 60;
        }
        $fee = $revenue * 0.018;
        echo "₱" . number_format($revenue, 2) . "<br>";
        echo "(" . number_format($fee, 2) . " as 1.8%)";
    } else {
        echo "Product price not found";
    }
@endphp

</td>

                    <td class="text-center">{{ $order->created_at->format('d M Y') }}</td>
                </tr>
                <div class="position-fixed" style="top: 30px; right: 20px;">
                    <div class="alert alert-info">
                        Total Revenue: ₱{{ number_format($totalOnePointEightPercent, 2) }}
                    </div>
            @endforeach
        @endforeach
    </tbody>
</table>


@endsection