@extends('app-new')

@section('content')
<div class="content-w">
  <div class="content-i">
    <div class="content-box">
      <div class="row mb-3">
        <div class="col-md-8">
          <h5 class="mb-0">Stock In Hand</h5>
          <div class="text-muted small">Current stock balances by location</div>
        </div>
        <div class="col-md-4 text-md-end">
          <a href="{{ route('inventory.stock-in') }}" class="btn btn-outline-primary">Stock In</a>
          <a href="{{ route('inventory.stock-issue') }}" class="btn btn-outline-primary">Stock Issue</a>
          <a href="{{ route('inventory.stock-adjust') }}" class="btn btn-outline-primary">Adjustment</a>
        </div>
      </div>

      <form method="GET" action="{{ route('inventory.stock-in-hand') }}" class="card border-0 shadow-sm mb-3">
        <div class="card-body">
          <div class="row g-3">
            <div class="col-lg-3">
              <select name="location_id" class="form-select select2">
                <option value="">All Locations</option>
                @foreach($locations as $loc)
                  <option value="{{ $loc->id }}" @selected(request('location_id')==$loc->id)>{{ $loc->name }}</option>
                @endforeach
              </select>
            </div>
            <div class="col-lg-3">
              <select name="sub_location_id" class="form-select select2">
                <option value="">All Sub Locations</option>
                @foreach($subLocations as $subloc)
                  <option value="{{ $subloc->id }}" @selected(request('sub_location_id')==$subloc->id)>{{ $subloc->name }}</option>
                @endforeach
              </select>
            </div>
            <div class="col-lg-3">
              <select name="item_id" class="form-select select2">
                <option value="">All Items</option>
                @foreach($items as $item)
                  <option value="{{ $item->id }}" @selected(request('item_id')==$item->id)>{{ $item->item_name }}</option>
                @endforeach
              </select>
            </div>
            <div class="col-lg-3">
              <button type="submit" class="btn btn-outline-primary">Filter</button>
              <a href="{{ route('inventory.stock-in-hand') }}" class="btn btn-link">Reset</a>
            </div>
          </div>
        </div>
      </form>

      <div class="card border-0 shadow-sm">
        <div class="card-body p-0">
          <div class="table-responsive">
            <table class="table table-striped table-hover mb-0" id="datatable">
              <thead class="table-light">
                <tr>
                  <th>Location</th>
                  <th>Sub Location</th>
                  <th>Item</th>
                  <th class="text-end">Qty In Hand</th>
                </tr>
              </thead>
              <tbody>
                @forelse($stocks as $row)
                  <tr>
                    <td>{{ $row->location->name ?? '-' }}</td>
                    <td>{{ $row->subLocation->name ?? '-' }}</td>
                    <td>{{ $row->item->item_name ?? '-' }}</td>
                    <td class="text-end">{{ number_format((float) $row->qty_in_hand, 3) }}</td>
                  </tr>
                @empty
                  <tr>
                    <td colspan="4" class="text-center text-muted py-4">No records found</td>
                  </tr>
                @endforelse
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
@endsection

@push('head-script')
<script>
  document.addEventListener('DOMContentLoaded', function () {
    if (window.$ && $.fn.select2) {
      $('.select2').select2({ width: '100%' });
    }
  });
</script>
@endpush