{% extends "base.html" %}
{% block title %}Data Workspace{% endblock %}
{% block content %}
<header class="page-head">
  <div>
    <div class="eyebrow">Controlled data onboarding</div>
    <h1>Data Workspace</h1>
    <div class="subtitle">
      Upload a prepared five-sheet merchandising and GA4 workbook to initialise
      the decision-support pipeline.
    </div>
  </div>
</header>

<section class="section">
  <div class="section-head">
    <div>
      <h2>Import workbook</h2>
      <p>Select a prepared .xlsx workbook that follows the controlled MDSS schema.</p>
    </div>
  </div>
  <div class="section-body">
    <form method="post" enctype="multipart/form-data">
      <label
        style="display:block;border:2px dashed var(--line);border-radius:12px;padding:46px;text-align:center;background:#f8faff;cursor:pointer"
      >
        <b>Select an MDSS workbook</b>
        <div class="sub" style="margin-top:6px">
          BI Product · BI Category · GA4 Product · GA4 Pages · GA4 Search
        </div>
        <input
          name="datafile"
          type="file"
          accept=".xlsx,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
          required
          style="margin-top:18px"
        >
      </label>
      <button class="button" type="submit" style="width:100%;margin-top:14px">
        Upload and validate
      </button>
    </form>
  </div>
</section>

{% if result %}
<section class="section" aria-live="polite">
  <div class="section-head">
    <div>
      <h2>Import result</h2>
      <p>Validation outcome by source sheet.</p>
    </div>
  </div>
  <div class="section-body">
    {% if result.error %}
      <div class="note bad" role="alert">{{ result.error }}</div>
    {% endif %}
    {% if result|length > 1 or not result.error %}
      <div class="table-wrap" style="margin-top:{{ '16px' if result.error else '0' }}">
        <table>
          <thead>
            <tr>
              <th>Sheet</th>
              <th>Status</th>
              <th class="num">Rows</th>
              <th>Notes</th>
            </tr>
          </thead>
          <tbody>
            {% for sheet, info in result.items() if sheet != 'error' %}
            <tr>
              <td class="product">{{ sheet }}</td>
              <td>
                <span class="pill {{ 'High' if info.status in ['ok', 'validated'] else 'Critical' }}">
                  {{ info.status }}
                </span>
              </td>
              <td class="num">{{ info.rows }}</td>
              <td class="reason">
                {{ info.errors|join(', ') if info.errors else 'Validated' }}
              </td>
            </tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    {% endif %}
    {% if not result.error %}
      <div style="margin-top:16px">
        <a class="button" href="{{ url_for('index') }}">Open generated results</a>
      </div>
    {% endif %}
  </div>
</section>
{% endif %}
{% endblock %}