{{-- resources/views/stock_aging/turnover_analysis.blade.php --}}
@extends('layouts.app')
@section('title', 'Stock Turnover Analysis')

@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-exchange"></i> Stock Turnover Analysis
    </h1>
</section>

<section class="content">
    @component('components.widget', ['title' => 'Turnover Analysis'])
        <div class="table-responsive">
            <table class="table table-bordered table-striped" id="turnover_table">
                <thead>
                    <tr>
                        <th>Product</th>
                        <th>Location</th>
                        <th>Qty in Stock</th>
                        <th>Stock Value</th>
                        <th>Qty Sold (6 months)</th>
                        <th>Avg Monthly Sales</th>
                        <th>Stock Turnover</th>
                        <th>Est. Days to Sell</th>
                        <th>Days in Stock</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>{{ number_format($item['quantity'], 2) }} {{ $item['unit'] ?? '' }}</td>
                        <td>KSh {{ number_format($item['stock_value'], 2) }}</td>
                        <td>{{ number_format($item['quantity_sold'], 2) }}</td>
                        <td>{{ number_format($item['avg_monthly_sales'], 2) }}</td>
                        <td>
                            @if($item['stock_turnover'] > 5)
                                <span class="label label-success">{{ $item['stock_turnover'] }}</span>
                            @elseif($item['stock_turnover'] > 2)
                                <span class="label label-warning">{{ $item['stock_turnover'] }}</span>
                            @else
                                <span class="label label-danger">{{ $item['stock_turnover'] }}</span>
                            @endif
                        </td>
                        <td>
                            @if($item['estimated_days_to_sell'] !== null)
                                @if($item['estimated_days_to_sell'] <= 30)
                                    <span class="label label-success">{{ $item['estimated_days_to_sell'] }} days</span>
                                @elseif($item['estimated_days_to_sell'] <= 60)
                                    <span class="label label-warning">{{ $item['estimated_days_to_sell'] }} days</span>
                                @else
                                    <span class="label label-danger">{{ $item['estimated_days_to_sell'] }} days</span>
                                @endif
                            @else
                                <span class="label label-default">N/A</span>
                            @endif
                        </td>
                        <td><span class="label label-default">{{ $item['avg_days_in_stock'] }} days</span></td>
                        <td>
                            <a href="{{ route('products.show', $item['product_id']) }}" class="btn btn-xs btn-primary">
                                <i class="fa fa-eye"></i>
                            </a>
                        </td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="10" class="text-center">No data available.</td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    @endcomponent
</section>
@stop