@extends('layouts.admin')

@section('title', 'Reports - Order Pipeline')
@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">Order Pipeline Report</h5>
          <small class="text-muted">Counts derived from so_numbers and key milestone dates</small>
        </div>
      </div>
      <div class="card-body">
        <form method="GET" action="{{ route('admin.reports.pipeline') }}" 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.pipeline.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">SO Count: {{ $summary['total_sos'] ?? 0 }}</span>
            </div>
          </div>
        </div>

        <div class="table-responsive">
          <table class="table table-bordered table-striped table-hover">
            <thead class="table-light">
              <tr>
                <th>Updated At</th>
                <th>PIC ID</th>
                <th class="text-end">SO Count</th>
                <th>Uploaded At</th>
                <th>Picking Status</th>
                <th>Picking Start</th>
                <th>Picking Complete</th>
                <th>Packing Status</th>
                <th>Packing Start</th>
                <th>Packing Complete</th>
                <th>Booking Status</th>
                <th>Booking Complete</th>
                <th>Dispatch Status</th>
                <th>Dispatched</th>
                <th>Delivered</th>
                <th>Delivery 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->pic_id }}</td>
                  <td class="text-end">{{ $r->so_count }}</td>
                  <td>{{ $r->uploaded_at }}</td>
                  <td>{{ $r->picking_status }}</td>
                  <td>{{ $r->picking_date_start }}</td>
                  <td>{{ $r->picking_date_complete }}</td>
                  <td>{{ $r->packing_status }}</td>
                  <td>{{ $r->packing_date_start }}</td>
                  <td>{{ $r->packing_date_complete }}</td>
                  <td>{{ $r->booking_status }}</td>
                  <td>{{ $r->booking_date_complete }}</td>
                  <td>{{ $r->dispatch_status }}</td>
                  <td>{{ $r->dispatch_date }}</td>
                  <td>{{ $r->delivery_date }}</td>
                  <td>{{ $r->delivery_status }}</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