@extends('layouts.admin')

@section('title', 'Reports')
@section('page-title', 'Reports')

@section('content')
<div class="row">
  <div class="col-12">
    <div class="card">
      <div class="card-header d-flex justify-content-between align-items-center">
        <div>
          <h5 class="mb-0">ASN Uploads Report</h5>
          <small class="text-muted">Filter by date range and view results</small>
        </div>
      </div>
      <div class="card-body">
        <form method="GET" action="{{ route('admin.reports.index') }}" class="row g-3 align-items-end">
          <div class="col-md-3">
            <label for="from" class="form-label">From</label>
            <input type="date" id="from" name="from" value="{{ $from }}" class="form-control">
          </div>
          <div class="col-md-3">
            <label for="to" class="form-label">To</label>
            <input type="date" id="to" name="to" value="{{ $to }}" class="form-control">
          </div>
          <div class="col-md-3">
            <button type="submit" class="btn btn-primary"><i class="fas fa-filter me-1"></i> Submit</button>
            <a class="btn btn-outline-secondary ms-2" href="{{ route('admin.reports.export', ['from' => $from, 'to' => $to]) }}">
              <i class="fas fa-file-export me-1"></i> Export CSV
            </a>
          </div>
        </form>

        <hr>

        <div class="row mb-3">
          <div class="col">
            <div class="d-flex gap-3">
              <span class="badge bg-secondary">Rows: {{ $summary['total_rows'] ?? 0 }}</span>
              <span class="badge bg-secondary">PCS: {{ $summary['sum_pcs'] ?? 0 }}</span>
              <span class="badge bg-secondary">Inward: {{ $summary['sum_inward'] ?? 0 }}</span>
              <span class="badge bg-secondary">Transfer: {{ $summary['sum_transfer'] ?? 0 }}</span>
              <span class="badge bg-secondary">Access: {{ $summary['sum_access'] ?? 0 }}</span>
            </div>
          </div>
        </div>

        <div class="table-responsive">
          <table class="table table-bordered table-striped table-hover">
            <thead class="table-light">
              <tr>
                <th>Timestamp</th>
                <th>Location</th>
                <th>Invoice</th>
                <th>Part No</th>
                <th>Description</th>
                <th class="text-end">PCS</th>
                <th class="text-end">Inward</th>
                <th class="text-end">Transfer</th>
                <th class="text-end">Access</th>
                <th>Status</th>
              </tr>
            </thead>
            <tbody>
              @forelse($rows as $r)
                <tr>
                  <td>{{ \Carbon\Carbon::parse($r->ts)->format('Y-m-d H:i') }}</td>
                  <td>{{ $r->location_id }}</td>
                  <td>{{ $r->invoice_number }}</td>
                  <td>{{ $r->part_no }}</td>
                  <td>{{ $r->description }}</td>
                  <td class="text-end">{{ $r->pcs }}</td>
                  <td class="text-end">{{ $r->inward_qty }}</td>
                  <td class="text-end">{{ $r->transfer_qty }}</td>
                  <td class="text-end">{{ $r->access_qty }}</td>
                  <td><span class="badge bg-light text-dark">{{ $r->status ?? '-' }}</span></td>
                </tr>
              @empty
                <tr><td colspan="10" class="text-center text-muted">No records found for selected range.</td></tr>
              @endforelse
            </tbody>
          </table>
        </div>
      </div>
    </div>
  </div>
</div>
@endsection