@extends('layouts.layout-horizontal')
@section('title', 'Product Price List')

@section('content')
<div class="card">
    <div class="card-header d-flex align-items-center justify-content-between">
        <div>
            <h5 class="mb-0">Product Price List</h5>
            <small class="text-muted">Purchase and sale prices are based on latest transactions. Price list shows the lowest vendor rate.</small>
        </div>
        <span class="badge bg-light text-dark">{{ $products->count() }} products</span>
    </div>
    <div class="card-body">
        <div data-st data-st-export="excel,print">
            <div class="table-responsive">
                <table class="table table-hover table-sm align-middle">
                    <thead class="table-light">
                        <tr>
                            <th>Product</th>
                            <th>SKU</th>
                            <th>HSN</th>
                            <th>Unit</th>
                            <th class="text-end">Purchase Price</th>
                            <th>Purchase Source</th>
                            <th class="text-end">Price List</th>
                            <th>Price List Source</th>
                            <th class="text-end">Sale Price</th>
                            <th>Sale Source</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($products as $product)
                        <tr>
                            <td>
                                <a href="{{ route('products.edit', $product->id) }}" class="fw-semibold">
                                    {{ $product->name }}
                                </a>
                            </td>
                            <td>{{ $product->product_id ?: '-' }}</td>
                            <td>{{ $product->hsn ?: '-' }}</td>
                            <td>{{ $product->unit ?: '-' }}</td>
                            <td class="text-end">{{ indian_number($product->purchase_price ?? 0, 2) }}</td>
                            <td>
                                {{ $product->purchase_price_source }}
                                @if($product->purchase_date)
                                    <div class="text-muted small">{{ \Carbon\Carbon::parse($product->purchase_date)->format('d-M-Y') }}</div>
                                @endif
                            </td>
                            <td class="text-end">
                                @if($product->price_list_rate !== null)
                                    {{ indian_number($product->price_list_rate, 2) }}
                                @else
                                    <span class="text-muted">-</span>
                                @endif
                            </td>
                            <td>
                                @if($product->price_list_rate !== null)
                                    {{ $product->price_list_vendor ?: 'Vendor price list' }}
                                    @if($product->price_list_date)
                                        <div class="text-muted small">{{ \Carbon\Carbon::parse($product->price_list_date)->format('d-M-Y') }}</div>
                                    @endif
                                @else
                                    <span class="text-muted">No price list</span>
                                @endif
                            </td>
                            <td class="text-end">{{ indian_number($product->sale_price ?? 0, 2) }}</td>
                            <td>
                                @if($product->sale_price)
                                    Latest sale
                                    <div class="text-muted small">{{ \Carbon\Carbon::parse($product->sale_date)->format('d-M-Y') }}</div>
                                @else
                                    <span class="text-muted">No sale price</span>
                                @endif
                            </td>
                        </tr>
                        @empty
                        <tr>
                            <td colspan="10" class="text-center text-muted py-4">No products found.</td>
                        </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection