{% extends "data_hub/base_data_hub.html" %}
{% block data_hub_content %}
<h4 class="mb-4"><i class="fas fa-database me-2 text-success"></i>Data Sources</h4>

<div class="card border-0 shadow-sm">
  <div class="table-responsive">
    <table class="table mb-0">
      <thead class="table-light">
        <tr>
          <th class="px-3">Source</th>
          <th>Type</th>
          <th class="text-center">Ingredients</th>
          <th>Notes</th>
        </tr>
      </thead>
      <tbody>
      {% for s in sources %}
        <tr>
          <td class="px-3 fw-semibold">{{ s.name }}</td>
          <td><span class="badge bg-light text-dark border">{{ s.type }}</span></td>
          <td class="text-center">
            <span class="fw-bold {% if s.count > 0 %}text-success{% else %}text-muted{% endif %}">
              {{ s.count }}
            </span>
          </td>
          <td class="small text-muted">
            {% if s.key == 'usda_sr' %}USDA SR Legacy — filter with USDA Audit tool{% endif %}
            {% if s.key == 'culinary' %}CulinaryDB seed — 943 base entities{% endif %}
            {% if s.key == 'global' %}Global cuisine additions{% endif %}
            {% if s.key == 'manual' %}Admin-added entries{% endif %}
            {% if not s.key %}Check source field on ingredient table{% endif %}
          </td>
        </tr>
      {% endfor %}
      </tbody>
    </table>
  </div>
</div>

<div class="mt-3 text-muted small">
  <i class="fas fa-info-circle me-1"></i>
  Source field was added in Phase 0.5. Ingredients imported before this migration show
  as "manual" or NULL. Use the USDA Audit tool to identify and clean shadow entries.
</div>
{% endblock %}