@extends('layouts.master')

@section('content')

<div class="workflow-page">

    <div class="workflow-header">

        <div>

            <h1 class="workflow-title">
                {{ $item->item_name }}
            </h1>

            <div class="workflow-subtitle">

                {{ $item->item_code }}

            </div>

        </div>

    </div>

    {{-- KPI CARDS --}}

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

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

            <div class="workflow-stat-value">
                {{ number_format($totalStock) }}
            </div>

            <div class="workflow-stat-label">
                Quantity On Hand
            </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">
                {{ $item->reorder_level }}
            </div>

            <div class="workflow-stat-label">
                Reorder Level
            </div>

        </div>

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

            <div class="workflow-stat-value">
                {{ $item->status }}
            </div>

            <div class="workflow-stat-label">
                Status
            </div>

        </div>

    </div>

    {{-- ITEM DETAILS --}}

    <div class="workflow-card">

        <div class="workflow-card-header">
            Item Details
        </div>

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

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

                <div>
                    <strong>Category:</strong>
                    {{ $item->category }}
                </div>

                <div>
                    <strong>Base Unit:</strong>
                    {{ $item->base_unit }}
                </div>

                <div>
                    <strong>Issue Unit:</strong>
                    {{ $item->issue_unit }}
                </div>

                <div>
                    <strong>Generic Name:</strong>
                    {{ $item->generic_name }}
                </div>

                <div>
                    <strong>Brand Name:</strong>
                    {{ $item->brand_name }}
                </div>

                <div>
                    <strong>Manufacturer:</strong>
                    {{ $item->manufacturer }}
                </div>

            </div>

        </div>

    </div>

    {{-- BATCHES --}}

    <div class="workflow-card">

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

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

            <table class="workflow-table">

                <thead>

                <tr>

                    <th>Location</th>
                    <th>Batch</th>
                    <th>Expiry</th>
                    <th>Quantity</th>
                    <th>Unit Cost</th>
                    <th>Value</th>

                </tr>

                </thead>

                <tbody>

                @forelse($stockBalances as $batch)

                    <tr>

                        <td>
                            {{ $batch->location_name ?? '-' }}
                        </td>

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

                        <td>

                            @if($batch->expiry_date)

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

                            @else

                                -

                            @endif

                        </td>

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

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

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

                    </tr>

                @empty

                    <tr>

                        <td colspan="6">
                            No stock available
                        </td>

                    </tr>

                @endforelse

                </tbody>

            </table>

        </div>

    </div>

    {{-- STOCK LEDGER --}}

    <div class="workflow-card">

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

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

            <table class="workflow-table">

                <thead>

                <tr>

                    <th>Date</th>
                    <th>Movement</th>
                    <th>Location</th>
                    <th>Batch</th>
                    <th>Qty In</th>
                    <th>Qty Out</th>

                </tr>

                </thead>

                <tbody>

                @foreach($movements as $movement)

                    <tr>

                        <td>
                            {{ \Carbon\Carbon::parse($movement->movement_date)->format('d-m-Y') }}
                        </td>

                        <td>
                            {{ $movement->movement_type }}
                        </td>

                        <td>
                            {{ $movement->location_name ?? '-' }}
                        </td>

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

                        <td>
                            {{ number_format($movement->qty_in) }}
                        </td>

                        <td>
                            {{ number_format($movement->qty_out) }}
                        </td>

                    </tr>

                @endforeach

                </tbody>

            </table>

        </div>

    </div>

</div>
{{-- RECEIPT HISTORY --}}

<div class="workflow-card">

    <div class="workflow-card-header">
        Receipt History
    </div>

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

        <table class="workflow-table">

            <thead>

                <tr>

                    <th>Receipt No</th>
                    <th>Date</th>
                    <th>Batch</th>
                    <th>Quantity</th>
                    <th>Unit Cost</th>
                    <th>Total</th>

                </tr>

            </thead>

            <tbody>

            @forelse($receipts as $receipt)

                <tr>

                    <td>
                        {{ $receipt->receipt_no }}
                    </td>

                    <td>
                        {{ \Carbon\Carbon::parse($receipt->receipt_date)->format('d-m-Y') }}
                    </td>

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

                    <td>
                        {{ number_format($receipt->quantity_received) }}
                    </td>

                    <td>
                        UGX {{ number_format($receipt->unit_cost, 2) }}
                    </td>

                    <td>
                        UGX {{ number_format($receipt->line_total, 2) }}
                    </td>

                </tr>

            @empty

                <tr>

                    <td colspan="6">
                        No receipt history available.
                    </td>

                </tr>

            @endforelse

            </tbody>

        </table>

    </div>

</div>

{{-- ISSUE HISTORY --}}

<div class="workflow-card">

    <div class="workflow-card-header">
        Issue History
    </div>

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

        <table class="workflow-table">

            <thead>

                <tr>

                    <th>Issue No</th>
                    <th>Date</th>
                    <th>Destination</th>
                    <th>Batch</th>
                    <th>Quantity</th>
                    <th>Total</th>

                </tr>

            </thead>

            <tbody>

            @forelse($issues as $issue)

                <tr>

                    <td>
                        {{ $issue->issue_no }}
                    </td>

                    <td>
                        {{ \Carbon\Carbon::parse($issue->issue_date)->format('d-m-Y') }}
                    </td>

                    <td>
                        {{ $issue->destination_name ?? '-' }}
                    </td>

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

                    <td>
                        {{ number_format($issue->quantity_issued) }}
                    </td>

                    <td>
                        UGX {{ number_format($issue->line_total, 2) }}
                    </td>

                </tr>

            @empty

                <tr>

                    <td colspan="6">
                        No issue history available.
                    </td>

                </tr>

            @endforelse

            </tbody>

        </table>

    </div>

</div>

@endsection