{{-- resources/views/stock_aging/slow_moving.blade.php --}}
@extends('layouts.app')
@section('title', 'Slow Moving Stock')

@section('content')
<section class="content-header">
    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">
        <i class="fa fa-hourglass-half"></i> Slow Moving Stock
    </h1>
    <small>Products aged 61-90 days</small>
</section>

<section class="content">
    <div class="row">
        <div class="col-md-12">
            <div class="callout callout-warning">
                <h4><i class="icon fa fa-clock-o"></i> Slow Moving Stock Summary</h4>
                <p>
                    Total value: <strong>KSh {{ number_format(collect($data)->sum('stock_value'), 2) }}</strong>
                    | Total products: <strong>{{ count($data) }}</strong>
                    | Total quantity: <strong>{{ number_format(collect($data)->sum('quantity'), 2) }}</strong>
                </p>
                <p class="text-warning">
                    <strong>Recommended Action:</strong> Consider promotion
                </p>
            </div>
        </div>
    </div>

    @component('components.widget', ['title' => 'Slow Moving Products (61-90 Days)'])
        <div class="table-responsive">
            <table class="table table-bordered table-striped" id="slow_moving_table">
                <thead>
                    <tr>
                        <th>Product</th>
                        <th>Location</th>
                        <th>Category</th>
                        <th>Qty</th>
                        <th>Stock Value</th>
                        <th>Days</th>
                        <th>Last Sale</th>
                        <th>Avg Monthly Sales</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($data as $item)
                    <tr>
                        <td>{{ $item['product_name'] }} ({{ $item['sku'] }})</td>
                        <td>{{ $item['location_name'] }}</td>
                        <td>{{ $item['category_name'] ?? '' }}</td>
                        <td>{{ number_format($item['quantity'], 2) }} {{ $item['unit'] ?? '' }}</td>
                        <td>KSh {{ number_format($item['stock_value'], 2) }}</td>
                        <td><span class="label label-warning">{{ $item['avg_days_in_stock'] }} days</span></td>
                        <td>{{ $item['last_sale_date'] ? \Carbon\Carbon::parse($item['last_sale_date'])->format('d-m-Y') : 'Never' }}</td>
                        <td>{{ number_format($item['avg_monthly_sales'], 2) }}</td>
                        <td>
                            <span class="label label-warning">{{ $item['recommended_action'] }}</span>
                        </td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="9" class="text-center">No slow moving products found.</td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    @endcomponent
</section>
@stop