{% extends "base.html" %}
{% block content %}
<div class="card" style="margin-top:14px">
  <div class="row" style="justify-content:space-between;align-items:center">
    <div>
      <div style="font-weight:1000;margin-bottom:6px">📋 Admin - Daftar Laporan</div>
      <small>Filter + export (CSV/XLSX). Attachment hanya bisa diakses admin.</small>
    </div>
    <div class="row">
      <a class="btn2" href="{{ url_for('export_csv') }}">Export CSV</a>
      <a class="btn2" href="{{ url_for('export_xlsx') }}">Export XLSX</a>
    </div>
  </div>

  <form method="get" action="{{ url_for('admin') }}" style="margin-top:12px" class="row">
    <input name="q" value="{{ q }}" placeholder="search title/desc/requester" style="flex:2;min-width:240px"/>
    <select name="category" style="flex:1;min-width:180px">
      <option value="">all category</option>
      <option value="hardware" {{ 'selected' if category=='hardware' else '' }}>hardware</option>
      <option value="software" {{ 'selected' if category=='software' else '' }}>software</option>
      <option value="network" {{ 'selected' if category=='network' else '' }}>network</option>
      <option value="account" {{ 'selected' if category=='account' else '' }}>account</option>
    </select>
    <select name="priority" style="flex:1;min-width:180px">
      <option value="">all priority</option>
      <option value="low" {{ 'selected' if priority=='low' else '' }}>low</option>
      <option value="medium" {{ 'selected' if priority=='medium' else '' }}>medium</option>
      <option value="high" {{ 'selected' if priority=='high' else '' }}>high</option>
      <option value="urgent" {{ 'selected' if priority=='urgent' else '' }}>urgent</option>
    </select>
    <button class="btn2" type="submit">Apply</button>
  </form>

  <div style="margin-top:12px">
    {% if items|length == 0 %}
      <div class="flash err">Empty state: belum ada data / filter tidak menemukan hasil.</div>
    {% else %}
      <table>
        <thead>
          <tr>
            <th>Time</th><th>Requester</th><th>Category</th><th>Priority</th><th>Title</th><th>Attachment</th>
          </tr>
        </thead>
        <tbody>
          {% for r in items %}
          <tr>
            <td>{{ r.created_at }}</td>
            <td>{{ r.requester }}</td>
            <td><span class="badge">{{ r.category }}</span></td>
            <td><span class="badge">{{ r.priority }}</span></td>
            <td>{{ r.title }}</td>
            <td>
              {% if r.attachment %}
                <a href="{{ url_for('download_upload', name=r.attachment) }}">download</a>
              {% else %}
                <small>-</small>
              {% endif %}
            </td>
          </tr>
          {% endfor %}
        </tbody>
      </table>
    {% endif %}
  </div>
</div>
{% endblock %}