@extends('layouts.admin')

@section('title', 'Purchase Order Details')

@section('breadcrumb-title', 'Details')

@section('breadcrumb-item')
    <li class="breadcrumb-item">Purchase Orders</li>
    <li class="breadcrumb-item active">Details</li>
@endsection

@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-sm-12">
                <div class="card">
                    <div class="card-header">
                        <h5>Purchase Order Details</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-bordered">
                            <tr>
                                <th>Vendor</th>
                                <td>{{ optional($purchase_order->supplier)->name }}</td>
                            </tr>
                            <tr>
                                <th>Order number</th>
                                <td>{{ $purchase_order->order_number }}</td>
                            </tr>
                            <tr>
                                <th>Date</th>
                                <td>{{ $purchase_order->date }}</td>
                            </tr>
                            <tr>
                                <th>Status</th>
                                <td>{{ $purchase_order->status_name }}</td>
                            </tr>
                        </table>
                    </div>
                </div>

                <div class="card">
                    <div class="card-header">
                        <h5>Products</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-hover table-striped">
                            <tr>
                                <th>#</th>
                                <th>Product</th>
                                <th>Description</th>
                                <th>Quantity</th>
                                <th>Batch</th>
                                <th>Mfg Date</th>
                                <th>Exp Date</th>
                                <th>Unit Price</th>
                                <th>Total</th>
                            </tr>
                            @php
                                $groupedProducts = $purchase_order->products->groupBy('name')->map(
                                function ($products, $name) 
                                {
                                    $firstProduct = $products->first();
                                    $quantity = $products->sum('pivot.quantity');
                                    $sub_total = $products->sum(
                                    function ($product) {
                                        return $product->pivot->quantity * $product->pivot->unit_price;
                                    });

                                    return [
                                        'description' => $firstProduct->pivot->description,
                                        'quantity' => $quantity,
                                        'batch' => $firstProduct->pivot->batch,
                                        'mfg_date' => $firstProduct->pivot->mfg_date,
                                        'exp_date' => $firstProduct->pivot->exp_date,
                                        'unit_price' => $firstProduct->pivot->unit_price,
                                        'sub_total' => $sub_total,
                                    ];
                                });
                            @endphp

                            @foreach($groupedProducts as $index => $details)
                                <tr>
                                    <td>{{ $loop->iteration }}</td>
                                    <td>{{ $index }}</td>
                                    <td>{{ $details['description'] }}</td>
                                    <td>{{ $details['quantity'] }}</td>
                                    <td>{{ $details['batch'] }}</td>
                                    <td>{{ $details['mfg_date'] }}</td>
                                    <td>{{ $details['exp_date'] }}</td>
                                    <td>{{ $details['unit_price'] }}</td>
                                    <td>{{ $details['sub_total'] }}</td>
                                </tr>
                            @endforeach
                            <tr>
                                <th colspan="8" class="text-right">Total</th>
                                <td>{{ $purchase_order->total }}</td>
                            </tr>
                        </table>
                        @if(!$purchase_order->received)
                            <a href="{{ route('admin.purchase_orders.receive', ['purchase_order' => $purchase_order->id]) }}"
                               class="btn btn-success btn-sm">Receive Inventory</a>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection