@extends('layouts.app')

@section('title', 'Stock Movement Audit Ledger')
@section('page_title', 'Stock Movements & Audit Trail')

@section('content')
<div class="container-fluid p-0">
    <div class="card border-0 shadow-sm mb-4">
        <div class="card-body">
            <div class="d-flex flex-wrap justify-content-between align-items-center gap-3">
                <form action="{{ route('stock-movements.index') }}" method="GET" class="d-flex flex-wrap align-items-center gap-2 flex-grow-1">
                    <select name="product_id" class="form-select" style="max-width: 250px;" onchange="this.form.submit()">
                        <option value="">All Products</option>
                        @foreach($products as $p)
                            <option value="{{ $p->id }}" {{ request('product_id') == $p->id ? 'selected' : '' }}>
                                {{ $p->name }}
                            </option>
                        @endforeach
                    </select>

                    <select name="movement_type" class="form-select" style="max-width: 200px;" onchange="this.form.submit()">
                        <option value="">All Movement Types</option>
                        <option value="purchase" {{ request('movement_type') == 'purchase' ? 'selected' : '' }}>Purchase (Stock In)</option>
                        <option value="sale" {{ request('movement_type') == 'sale' ? 'selected' : '' }}>Sale (Stock Out)</option>
                        <option value="adjustment_add" {{ request('movement_type') == 'adjustment_add' ? 'selected' : '' }}>Adjustment (+)</option>
                        <option value="adjustment_sub" {{ request('movement_type') == 'adjustment_sub' ? 'selected' : '' }}>Adjustment (-)</option>
                        <option value="sale_return" {{ request('movement_type') == 'sale_return' ? 'selected' : '' }}>Sale Return In</option>
                        <option value="purchase_return" {{ request('movement_type') == 'purchase_return' ? 'selected' : '' }}>Purchase Return Out</option>
                    </select>

                    @if(request()->hasAny(['product_id', 'movement_type']))
                        <a href="{{ route('stock-movements.index') }}" class="btn btn-outline-secondary btn-sm">Clear</a>
                    @endif
                </form>

                <div>
                    <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#adjustmentModal">
                        <i class="bi bi-sliders me-1"></i> Manual Stock Adjustment
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- Movements Ledger Table -->
    <div class="card border-0 shadow-sm">
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover align-middle mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Date & Time</th>
                            <th>Product Name / SKU</th>
                            <th>Movement Type</th>
                            <th class="text-center">Quantity</th>
                            <th class="text-center">Stock Before</th>
                            <th class="text-center">Stock After</th>
                            <th>Reference Document</th>
                            <th>Audit Notes / Reason</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($movements as $m)
                            <tr>
                                <td class="small text-muted">{{ $m->created_at->format('d M Y, h:i A') }}</td>
                                <td>
                                    <a href="{{ route('products.show', $m->product_id) }}" class="fw-bold text-dark text-decoration-none">
                                        {{ $m->product ? $m->product->name : 'Deleted Product' }}
                                    </a>
                                    <div class="small text-muted">{{ $m->product ? 'SKU: ' . $m->product->sku : '' }}</div>
                                </td>
                                <td>
                                    <span class="badge {{ $m->badge_class }}">
                                        {{ $m->formatted_type }}
                                    </span>
                                </td>
                                <td class="text-center fw-bold fs-6">
                                    {{ in_array($m->movement_type, ['purchase', 'adjustment_add', 'sale_return']) ? '+' : '-' }}{{ number_format($m->quantity, 0) }}
                                    <small class="text-muted fw-normal">{{ $m->product && $m->product->unit ? $m->product->unit->short_code : '' }}</small>
                                </td>
                                <td class="text-center text-muted">{{ number_format($m->stock_before, 0) }}</td>
                                <td class="text-center fw-bold text-primary">{{ number_format($m->stock_after, 0) }}</td>
                                <td>
                                    @if($m->reference_type == 'Invoice')
                                        <a href="{{ route('invoices.show', $m->reference_id) }}" class="badge bg-light text-primary border text-decoration-none">
                                            Sales Invoice #{{ $m->reference_id }}
                                        </a>
                                    @elseif($m->reference_type == 'Purchase')
                                        <a href="{{ route('purchases.show', $m->reference_id) }}" class="badge bg-light text-success border text-decoration-none">
                                            Purchase Bill #{{ $m->reference_id }}
                                        </a>
                                    @else
                                        <span class="badge bg-light text-muted border">{{ $m->reference_type ?? 'Manual' }}</span>
                                    @endif
                                </td>
                                <td class="small text-muted">{{ $m->notes ?? '-' }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="8" class="text-center py-4 text-muted">
                                    <i class="bi bi-clock-history fs-1 d-block mb-2 text-secondary"></i>
                                    No stock audit movements found.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
        @if($movements->hasPages())
            <div class="card-footer bg-white border-top py-3">
                {{ $movements->links() }}
            </div>
        @endif
    </div>
</div>

<!-- Manual Adjustment Modal -->
<div class="modal fade" id="adjustmentModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <form action="{{ route('stock-movements.adjust') }}" method="POST">
                @csrf
                <div class="modal-header">
                    <h5 class="modal-title fw-bold">Manual Inventory Adjustment</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label fw-semibold">Select Product <span class="text-danger">*</span></label>
                        <select name="product_id" class="form-select" required>
                            <option value="">-- Choose Product --</option>
                            @foreach($products as $p)
                                <option value="{{ $p->id }}">{{ $p->name }} (Current: {{ number_format($p->current_stock, 0) }})</option>
                            @endforeach
                        </select>
                    </div>

                    <div class="mb-3">
                        <label class="form-label fw-semibold">Adjustment Operation <span class="text-danger">*</span></label>
                        <select name="adjustment_type" class="form-select" required>
                            <option value="add">Add Stock (+) - Found Inventory / Extra Units</option>
                            <option value="subtract">Deduct Stock (-) - Damaged / Expired / Lost Units</option>
                            <option value="recount">Physical Recount (Override to Exact Stock Count)</option>
                        </select>
                    </div>

                    <div class="mb-3">
                        <label class="form-label fw-semibold">Quantity <span class="text-danger">*</span></label>
                        <input type="number" step="0.01" min="0.01" name="quantity" class="form-control" placeholder="Enter quantity" required>
                    </div>

                    <div class="mb-3">
                        <label class="form-label fw-semibold">Reason for Audit Log <span class="text-danger">*</span></label>
                        <input type="text" name="reason" class="form-control" placeholder="e.g. Annual audit count discrepancy, damaged during transit" required>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary fw-semibold">Apply & Log Adjustment</button>
                </div>
            </form>
        </div>
    </div>
</div>
@endsection