@extends('layouts.master')

@section('content')

<div class="workflow-page">

    <div class="workflow-header">

        <div>
            <h1 class="workflow-title">
                Stock Balances
            </h1>

            <div class="workflow-subtitle">
                Current inventory by location, batch and expiry
            </div>
        </div>

        <div class="workflow-actions">

        <a
            href="{{ route('supply.procurement.create') }}"
            class="workflow-btn workflow-btn-danger">

            🛒 Generate PR

        </a>


        <a
            href="{{ route('supply.opening-stock.create') }}"
            class="workflow-btn workflow-btn-warning">

            📥 Load Opening Stock

        </a>

        <a href="{{ route('supply.receipts.create') }}"
        class="workflow-btn workflow-btn-success">
            ➕ Receive Stock
        </a>

        <a href="{{ route('supply.issues.create') }}"
        class="workflow-btn workflow-btn-primary">
            📤 Issue Stock
        </a>

        <a href="{{ route('supply.transfers.create') }}"
        class="workflow-btn workflow-btn-outline">
            🔄 Transfer
        </a>

        </div>

    </div>

    {{-- STOCK KPIs --}}

    <div class="workflow-stat-grid">

        <div class="workflow-stat-card">
            <div class="workflow-stat-value">
                {{ number_format($itemsInStock) }}
            </div>
            <div class="workflow-stat-label">
                Items In Stock
            </div>
        </div>

        <div class="workflow-stat-card">
            <div class="workflow-stat-value">
                UGX {{ number_format($stockValue, 2) }}
            </div>
            <div class="workflow-stat-label">
                Stock Value
            </div>
        </div>

        <div class="workflow-stat-card">
            <div class="workflow-stat-value">
                {{ number_format($lowStockItems) }}
            </div>
            <div class="workflow-stat-label">
                Low Stock Items
            </div>
        </div>

        <div class="workflow-stat-card">
            <div class="workflow-stat-value">
                {{ number_format($expiredBatches) }}
            </div>
            <div class="workflow-stat-label">
                Expired Batches
            </div>
        </div>

    </div>

    {{-- FILTERS --}}

    <div class="workflow-card">

        <div class="workflow-card-header">
            Search Inventory
        </div>

        <div class="workflow-card-body">

            <form method="GET">

                <div class="workflow-grid-4">

                    <div class="workflow-form-group">

                        <label>Search Item</label>

                        <input
                            type="text"
                            name="search"
                            value="{{ request('search') }}"
                            placeholder="Code or Item Name">

                    </div>

                    <div class="workflow-form-group">

                        <label>Location</label>

                        <select name="location_id">

                            <option value="">
                                All Locations
                            </option>

                            @foreach($locations as $location)

                                <option
                                    value="{{ $location->id }}"
                                    {{ request('location_id') == $location->id ? 'selected' : '' }}>

                                    {{ $location->name }}

                                </option>

                            @endforeach

                        </select>

                    </div>

                    <div class="workflow-form-group">

                        <label>Category</label>

                        <select name="category">

                            <option value="">
                                All Categories
                            </option>

                            <option value="Medicine">
                                Medicine
                            </option>

                            <option value="Vaccine">
                                Vaccine
                            </option>

                            <option value="Consumable">
                                Consumable
                            </option>

                            <option value="Laboratory">
                                Laboratory
                            </option>

                            <option value="Equipment">
                                Equipment
                            </option>

                        </select>

                    </div>

                    <div class="workflow-form-group">

                        <label>&nbsp;</label>

                        <button
                            type="submit"
                            class="workflow-btn workflow-btn-primary">

                            Search

                        </button>

                    </div>

                </div>

            </form>

        </div>

</div>

    {{-- STOCK TABLE --}}

    <div class="workflow-card">

        <div class="workflow-card-header">
            Current Stock Balances
        </div>

        <div class="workflow-card-body">

            <table class="workflow-table">

                <thead>
                    <tr>
                        <th>Code</th>
                        <th>Item</th>
                        <th>Location</th>
                        <th>Batch</th>
                        <th>Expiry</th>
                        <th>Available</th>
                        <th>Unit Cost</th>
                        <th>Value</th>
                        <th>Status</th>
                    </tr>
                </thead>

                    <tbody>

                    @forelse($stocks as $stock)

                        <tr>

                            <td>
                                {{ $stock->item_code }}
                            </td>

                            <td>
                                {{ $stock->item_name }}
                            </td>

                            <td>
                                {{ $stock->location_name }}
                            </td>

                            <td>
                                {{ $stock->batch_no }}
                            </td>

                            <td>

                                @if($stock->expiry_date)

                                    {{ \Carbon\Carbon::parse($stock->expiry_date)->format('d-M-Y') }}

                                @else

                                    -

                                @endif

                            </td>

                                <td>
                                    {{ number_format($stock->quantity_on_hand) }}
                                </td>

                                <td>
                                    UGX {{ number_format($stock->average_unit_cost, 2) }}
                                </td>

                                <td>
                                    UGX {{ number_format($stock->stock_value, 2) }}
                                </td>

                            <td>

                                @if($stock->quantity_on_hand <= 0)

                                    <span class="workflow-badge workflow-badge-red">
                                        Out
                                    </span>

                                @elseif($stock->quantity_on_hand <= 10)

                                    <span class="workflow-badge workflow-badge-orange">
                                        Low
                                    </span>

                                @else

                                    <span class="workflow-badge workflow-badge-green">
                                        Available
                                    </span>

                                @endif

                            </td>

                        </tr>

                    @empty

                        <tr>

                            <td colspan="9"
                                style="text-align:center;padding:20px;">

                                No stock available.

                            </td>

                        </tr>

                    @endforelse

                    </tbody>

            </table>
            <div style="margin-top:20px;">

                {{ $stocks->links() }}

            </div>

        </div>

    </div>

</div>

@endsection