@extends('layouts.layout-horizontal')
@section('title', 'Most Moving Items')

@section('content')
<div class="card">
    <form method="GET" class="report-filter">
        <div class="filter-group">
            <label>From</label>
            <input type="date" name="start_date" value="{{ $startDate }}">
        </div>
        <div class="filter-group">
            <label>To</label>
            <input type="date" name="end_date" value="{{ $endDate }}">
        </div>
        <button type="submit" class="btn btn-primary filter-btn">
            <i class="ph-duotone ph-funnel"></i> Filter
        </button>
    </form>
    <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>Item Name</th>
                        <th class="text-end">Qty Purchased</th>
                        <th class="text-end">Avg Purchase Rate</th>
                        <th class="text-end">Qty Sold</th>
                        <th class="text-end">Avg Sold Rate</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($products as $product)
                        @if($product->qty_sold > 0 || $product->qty_purchased > 0)
                        <tr>
                            <td>{{ $product->name }}</td>
                            <td class="text-end">{{ indian_number($product->qty_purchased, 2) }}</td>
                            <td class="text-end">{{ indian_number($product->avg_purchase_rate, 2) }}</td>
                            <td class="text-end">{{ indian_number($product->qty_sold, 2) }}</td>
                            <td class="text-end">{{ indian_number($product->avg_sold_rate, 2) }}</td>
                        </tr>
                        @endif
                    @endforeach
                </tbody>
            </table>
            </div>
        </div>
    </div>
</div>
@endsection