@extends('admin.admin_dashboard')
@section('admin')

<div class="container-fluid py-4">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h4 class="mb-1">Beverage Inventory Report</h4>
            <p class="text-muted mb-0">Quantity ledger balances and recent movements.</p>
        </div>
        <a href="{{ route('beverage.sales.create') }}" class="btn btn-outline-primary">Open POS</a>
    </div>

    <div class="row g-3 mb-4">
        @foreach([
            'Green Bean' => $raw,
            'Roasted (kg)' => $roasted,
            'Ground (kg)' => $ground,
            'Roasted Packaged (kg)' => $roasted_packaged,
            'Ground Packaged (kg)' => $ground_packaged,
        ] as $label => $value)
            <div class="col-md-4 col-lg">
                <div class="card border-0 shadow-sm h-100">
                    <div class="card-body">
                        <div class="text-muted small">{{ $label }}</div>
                        <div class="fs-4 fw-bold">{{ number_format($value, 2) }}</div>
                    </div>
                </div>
            </div>
        @endforeach
    </div>

    <div class="card border-0 shadow-sm mb-4">
        <div class="card-header bg-white">
            <strong>Latest Ledger Movements</strong>
        </div>
        <div class="table-responsive">
            <table class="table table-sm mb-0">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Item</th>
                        <th>Movement</th>
                        <th class="text-end">In</th>
                        <th class="text-end">Out</th>
                        <th class="text-end">Net</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($journal as $entry)
                        <tr>
                            <td>{{ \Carbon\Carbon::parse($entry->created_at)->format('Y-m-d H:i') }}</td>
                            <td>{{ $entry->item_type }}</td>
                            <td>{{ $entry->movement_type }}</td>
                            <td class="text-end">{{ number_format($entry->quantity_in, 2) }}</td>
                            <td class="text-end">{{ number_format($entry->quantity_out, 2) }}</td>
                            <td class="text-end">{{ number_format($entry->net_qty, 2) }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="6" class="text-center text-muted py-4">No ledger entries yet.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <div class="row g-4">
        <div class="col-lg-6">
            <div class="card border-0 shadow-sm">
                <div class="card-header bg-white"><strong>Balance by Item Type</strong></div>
                <div class="card-body">
                    @forelse($pie as $slice)
                        <div class="d-flex justify-content-between border-bottom py-2">
                            <span>{{ $slice->item_type ?: 'Unknown' }}</span>
                            <strong>{{ number_format($slice->balance, 2) }}</strong>
                        </div>
                    @empty
                        <p class="text-muted mb-0">No balance data.</p>
                    @endforelse
                </div>
            </div>
        </div>
        <div class="col-lg-6">
            <div class="card border-0 shadow-sm">
                <div class="card-header bg-white"><strong>Daily Flow (recent)</strong></div>
                <div class="table-responsive">
                    <table class="table table-sm mb-0">
                        <thead>
                            <tr>
                                <th>Date</th>
                                <th class="text-end">Green In</th>
                                <th class="text-end">Roasted In</th>
                                <th class="text-end">Ground In</th>
                                <th class="text-end">Sales Out</th>
                                <th class="text-end">Loss Out</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($chartData->take(-14) as $day)
                                <tr>
                                    <td>{{ $day->date }}</td>
                                    <td class="text-end">{{ number_format($day->green_in, 2) }}</td>
                                    <td class="text-end">{{ number_format($day->roasted_in, 2) }}</td>
                                    <td class="text-end">{{ number_format($day->ground_in, 2) }}</td>
                                    <td class="text-end">{{ number_format($day->sales_out, 2) }}</td>
                                    <td class="text-end">{{ number_format($day->loss_out, 2) }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

@endsection