{% extends "base.html" %}
{% block title %}{{ form_title }} — {{ project.name }} — Fossilrepo{% endblock %}

{% block content %}
<h1 class="text-2xl font-bold text-gray-100 mb-2">{{ project.name }}</h1>
{% include "fossil/_project_nav.html" %}

<div class="mb-4">
  <a href="{% url 'fossil:ticket_reports' slug=project.slug %}" class="text-sm text-brand-light hover:text-brand">&larr; Back to Reports</a>
</div>

<div class="mx-auto max-w-3xl">
  <h2 class="text-xl font-bold text-gray-100 mb-4">{{ form_title }}</h2>

  <form method="post" class="space-y-4 rounded-lg bg-gray-800 p-6 shadow border border-gray-700">
    {% csrf_token %}

    <div>
      <label class="block text-sm font-medium text-gray-300 mb-1">Title <span class="text-red-400">*</span></label>
      <input type="text" name="title" required placeholder="Report title"
             value="{% if report %}{{ report.title }}{% endif %}"
             class="w-full rounded-md border-gray-700 bg-gray-800 text-gray-100 shadow-sm focus:border-brand focus:ring-brand sm:text-sm">
    </div>

    <div>
      <label class="block text-sm font-medium text-gray-300 mb-1">Description</label>
      <textarea name="description" rows="2" placeholder="What does this report show?"
                class="w-full rounded-md border-gray-700 bg-gray-800 text-gray-100 shadow-sm focus:border-brand focus:ring-brand sm:text-sm">{% if report %}{{ report.description }}{% endif %}</textarea>
    </div>

    <div>
      <label class="block text-sm font-medium text-gray-300 mb-1">SQL Query <span class="text-red-400">*</span></label>
      <textarea name="sql_query" rows="10" required
                placeholder="SELECT tkt_uuid, title, status, type FROM ticket WHERE status = 'Open' ORDER BY tkt_ctime DESC"
                class="w-full rounded-md border-gray-700 bg-gray-800 text-gray-100 shadow-sm focus:border-brand focus:ring-brand sm:text-sm font-mono">{% if report %}{{ report.sql_query }}{% endif %}</textarea>
      <div class="mt-2 text-xs text-gray-500 space-y-1">
        <p>Must be a SELECT statement. INSERT, UPDATE, DELETE, DROP, and other write operations are not allowed.</p>
        <p>Available placeholders: <code class="text-gray-400">{status}</code>, <code class="text-gray-400">{type}</code> (filled from query parameters).</p>
        <p>Common columns: <code class="text-gray-400">tkt_uuid</code>, <code class="text-gray-400">title</code>, <code class="text-gray-400">status</code>, <code class="text-gray-400">type</code>, <code class="text-gray-400">priority</code>, <code class="text-gray-400">severity</code>, <code class="text-gray-400">subsystem</code>, <code class="text-gray-400">tkt_ctime</code>.</p>
      </div>
    </div>

    <label class="flex items-center gap-2 text-sm text-gray-300 cursor-pointer">
      <input type="checkbox" name="is_public"
             {% if report %}{% if report.is_public %}checked{% endif %}{% else %}checked{% endif %}
             class="rounded border-gray-600 bg-gray-900 text-brand focus:ring-brand">
      Public (visible to all project members)
    </label>

    <div class="flex justify-end gap-3 pt-2">
      <a href="{% url 'fossil:ticket_reports' slug=project.slug %}"
         class="rounded-md bg-gray-700 px-4 py-2 text-sm font-semibold text-gray-100 shadow-sm ring-1 ring-inset ring-gray-600 hover:bg-gray-600">
        Cancel
      </a>
      <button type="submit" class="rounded-md bg-brand px-4 py-2 text-sm font-semibold text-white shadow-sm hover:bg-brand-hover">
        {{ submit_label }}
      </button>
    </div>
  </form>
</div>
{% endblock %}