@extends('layouts.admin')
@section('title', 'Market rates')
@section('actions')
    <form method="POST" action="{{ route('admin.market-rates.sync') }}">@csrf
        <button class="btn btn-sm btn-primary" @disabled($keyMissing)><i class="bi bi-arrow-repeat"></i> Sync now</button>
    </form>
@endsection

@section('content')
@if ($keyMissing)<div class="alert alert-warning small">Set <code>DATA_GOV_API_KEY</code> in <code>.env</code> to load prices.</div>@endif

<div class="row g-3 mb-3">
    <div class="col-md-4"><div class="card stat-card"><div class="label">Showing prices for</div><div class="value">{{ $date ? \Illuminate\Support\Carbon::parse($date)->format('d M Y') : '—' }}</div><div class="sub">Latest in database: {{ $latest ? \Illuminate\Support\Carbon::parse($latest)->format('d M Y') : 'none' }}</div></div></div>
    <div class="col-md-8"><div class="card stat-card h-100"><div class="label">Last sync</div>
        @if ($last)
            <div class="mt-1">{{ ist($last['ran_at']) }} · fetched {{ $last['fetched'] }}, saved {{ $last['saved'] }}, new markets {{ $last['markets_created'] }}</div>
        @else
            <div class="sub mt-1">Never run from this panel. It also runs automatically at 8 am and 6 pm IST when the Laravel scheduler is on.</div>
        @endif
        <div class="sub">Source: Agmarknet via data.gov.in · prices are ₹ per quintal.</div></div></div>
</div>

@if ($last && $last['unmatched'])
    <div class="card mb-3 border-warning">
        <div class="card-header"><i class="bi bi-exclamation-triangle text-warning me-1"></i> {{ count($last['unmatched']) }} commodities in the feed have no crop</div>
        <div class="card-body">
            <p class="small text-muted-2">Their prices are skipped until the crop exists. Add the ones farmers trade; the rest can stay out.</p>
            <div class="row g-2">
                @foreach ($last['unmatched'] as $name => $n)
                    <div class="col-md-6 col-xl-4">
                        <form method="POST" action="{{ route('admin.market-rates.add-crop') }}" class="d-flex gap-2 align-items-center border rounded p-2">
                            @csrf <input type="hidden" name="commodity" value="{{ $name }}">
                            <div class="me-auto small"><strong>{{ $name }}</strong><div class="text-muted-2">{{ $n }} prices</div></div>
                            @can('settings.manage')
                                <select name="crop_category_id" class="form-select form-select-sm w-auto" required>@foreach ($cropCategories as $id => $c)<option value="{{ $id }}">{{ $c }}</option>@endforeach</select>
                                <button class="btn btn-sm btn-outline-primary" data-confirm="Add &quot;{{ $name }}&quot; as a crop?">Add</button>
                            @endcan
                        </form>
                    </div>
                @endforeach
            </div>
        </div>
    </div>
@endif

<form class="filters row g-2 align-items-end">
    <div class="col-md-2"><label class="form-label small mb-0">Date</label><input type="date" name="date" value="{{ $date }}" class="form-control"></div>
    <div class="col-md-3"><select name="crop" class="form-select"><option value="">All crops</option>@foreach ($crops as $id => $n)<option value="{{ $id }}" @selected(request('crop') == $id)>{{ $n }}</option>@endforeach</select></div>
    <div class="col-md-3"><select name="market" class="form-select"><option value="">All markets</option>@foreach ($markets as $id => $n)<option value="{{ $id }}" @selected(request('market') == $id)>{{ $n }}</option>@endforeach</select></div>
    <div class="col-md-2"><select name="district" class="form-select"><option value="">All districts</option>@foreach ($districts as $id => $n)<option value="{{ $id }}" @selected(request('district') == $id)>{{ $n }}</option>@endforeach</select></div>
    <div class="col-auto"><button class="btn btn-outline-primary">Filter</button></div>
</form>

<div class="card">
    <div class="table-responsive">
        <table class="table table-hover">
            <thead><tr><th>Crop</th><th>Variety / grade</th><th>Market</th><th>District</th><th class="text-end">Min ₹</th><th class="text-end">Modal ₹</th><th class="text-end">Max ₹</th></tr></thead>
            <tbody>
            @forelse ($prices as $p)
                <tr>
                    <td class="fw-semibold">{{ $p->crop }}</td>
                    <td class="small">{{ trim($p->variety_label.' '.($p->grade_label && $p->grade_label !== $p->variety_label ? '· '.$p->grade_label : '')) ?: '—' }}</td>
                    <td>{{ $p->market }}</td>
                    <td>{{ $p->district ?? '—' }}</td>
                    <td class="text-end">{{ indian_number($p->min_price) }}</td>
                    <td class="text-end fw-semibold">{{ indian_number($p->modal_price) }}</td>
                    <td class="text-end">{{ indian_number($p->max_price) }}</td>
                </tr>
            @empty
                <tr><td colspan="7"><div class="empty-state"><i class="bi bi-graph-up"></i>No prices for this date. Press “Sync now”.</div></td></tr>
            @endforelse
            </tbody>
        </table>
    </div>
</div>
<div class="mt-3">{{ $prices->links() }}</div>
@endsection