@extends('layouts.app')

@section('title', 'Inventory Aging and Dead Stock')

@section('content')
<section class="content-header">
    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">Inventory Aging and Dead Stock</h1>
    <p class="text-muted">Inventory is aged per product variation and branch using its last completed sale.</p>
</section>

<section class="content">
    <div class="row">
        <div class="col-md-4">
            <div class="small-box bg-aqua">
                <div class="inner"><h3>{{ number_format((int) ($summary->item_count ?? 0)) }}</h3><p>Stocked variations</p></div>
                <div class="icon"><i class="fa fa-cubes"></i></div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="small-box bg-yellow">
                <div class="inner"><h3>@format_currency((float) ($summary->stock_value ?? 0))</h3><p>Inventory cost in this view</p></div>
                <div class="icon"><i class="fa fa-money"></i></div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="small-box bg-red">
                <div class="inner"><h3>{{ $threshold }} days</h3><p>Dead-stock threshold</p></div>
                <div class="icon"><i class="fa fa-hourglass-end"></i></div>
            </div>
        </div>
    </div>

    <div class="box box-primary">
        <div class="box-header with-border"><h3 class="box-title">Filters</h3></div>
        <div class="box-body">
            {!! Form::open(['route' => 'inventory-aging.index', 'method' => 'get']) !!}
            <div class="row">
                <div class="col-md-3">
                    {!! Form::label('location_id', 'Branch') !!}
                    {!! Form::select('location_id', $locations, request('location_id'), ['class' => 'form-control select2', 'placeholder' => 'All branches', 'style' => 'width:100%']) !!}
                </div>
                <div class="col-md-2">
                    {!! Form::label('category_id', 'Category') !!}
                    {!! Form::select('category_id', $categories, request('category_id'), ['class' => 'form-control select2', 'placeholder' => 'All categories', 'style' => 'width:100%']) !!}
                </div>
                <div class="col-md-2">
                    {!! Form::label('brand_id', 'Brand') !!}
                    {!! Form::select('brand_id', $brands, request('brand_id'), ['class' => 'form-control select2', 'placeholder' => 'All brands', 'style' => 'width:100%']) !!}
                </div>
                <div class="col-md-2">
                    {!! Form::label('age_band', 'Aging status') !!}
                    {!! Form::select('age_band', [
                        'all' => 'All inventory',
                        'fresh' => 'Fresh (0–30 days)',
                        'slow' => 'Slow moving',
                        'dead' => 'Dead stock',
                        'never_sold' => 'Never sold',
                    ], request('age_band', 'all'), ['class' => 'form-control']) !!}
                </div>
                <div class="col-md-2">
                    {!! Form::label('threshold_days', 'Dead after') !!}
                    <div class="input-group">
                        {!! Form::number('threshold_days', $threshold, ['class' => 'form-control', 'min' => 31, 'max' => 3650]) !!}
                        <span class="input-group-addon">days</span>
                    </div>
                </div>
                <div class="col-md-1">
                    <label>&nbsp;</label>
                    <button class="btn btn-primary btn-block" type="submit"><i class="fa fa-filter"></i></button>
                </div>
            </div>
            {!! Form::close() !!}
        </div>
    </div>

    <div class="box box-solid">
        <div class="box-header with-border">
            <h3 class="box-title">Aging details</h3>
            <a href="{{ route('inventory-aging.export', request()->query()) }}" class="btn btn-success btn-sm pull-right">
                <i class="fa fa-download"></i> Export CSV
            </a>
        </div>
        <div class="box-body table-responsive">
            <table class="table table-bordered table-striped">
                <thead>
                    <tr>
                        <th>Product</th>
                        <th>SKU</th>
                        <th>Branch</th>
                        <th class="text-right">Quantity</th>
                        <th class="text-right">Unit cost</th>
                        <th class="text-right">Stock value</th>
                        <th>Last sold</th>
                        <th class="text-right">Days</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($items as $item)
                        <tr class="{{ $item->age_days >= $threshold ? 'danger' : ($item->age_days > 30 ? 'warning' : '') }}">
                            <td>
                                <strong>{{ $item->product_name }}</strong>
                                @if($item->product_variation_name !== 'DUMMY' || $item->variation_name !== 'DUMMY')
                                    <div class="text-muted">{{ $item->product_variation_name }} {{ $item->variation_name }}</div>
                                @endif
                            </td>
                            <td>{{ $item->sub_sku }}</td>
                            <td>{{ $item->location_name }}</td>
                            <td class="text-right">{{ @format_quantity($item->qty_available) }}</td>
                            <td class="text-right">@format_currency($item->unit_cost)</td>
                            <td class="text-right">@format_currency($item->stock_value)</td>
                            <td>{{ $item->last_sold_at ? \Carbon\Carbon::parse($item->last_sold_at)->format('M d, Y') : 'Never' }}</td>
                            <td class="text-right">{{ number_format($item->age_days) }}</td>
                            <td>
                                <span class="label {{ $item->age_days >= $threshold ? 'label-danger' : ($item->age_days > 30 ? 'label-warning' : 'label-success') }}">
                                    {{ $item->age_label }}
                                </span>
                            </td>
                        </tr>
                    @empty
                        <tr><td colspan="9" class="text-center text-muted">No stocked products match the selected aging filters.</td></tr>
                    @endforelse
                </tbody>
            </table>
            {{ $items->links() }}
        </div>
    </div>
</section>
@endsection