{% extends "ui/templates/base/layout.html" %}
{% block content %}
<div class="mx-auto max-w-7xl space-y-5 p-4">
  <div class="flex items-center justify-between gap-3">
    <div>
      <h1 class="text-2xl font-bold">GST Return Reconciliation</h1>
      <p class="text-sm text-slate-600">Download GST returns through the lightweight operator agent, store them in the configured client local storage, and reconcile against Accounting Mirror.</p>
    </div>
    <a href="/tools/tally{% if selected_client %}?client_id={{ selected_client.id }}{% endif %}" class="rounded-lg border px-3 py-2 text-sm">Back to Accounting</a>
  </div>

  {% if message %}<div class="rounded-lg border border-emerald-200 bg-emerald-50 p-3 text-emerald-800">{{ message }}</div>{% endif %}
  {% if error %}<div class="rounded-lg border border-red-200 bg-red-50 p-3 text-red-800">{{ error }}</div>{% endif %}

  <form method="get" class="grid gap-3 rounded-xl border bg-white p-4 md:grid-cols-5">
    <label class="text-sm">Client
      <select name="client_id" class="mt-1 w-full rounded border p-2" onchange="this.form.submit()">
        <option value="">Select client</option>
        {% for c in clients %}<option value="{{ c.id }}" {% if selected_client and c.id==selected_client.id %}selected{% endif %}>{{ c.client_name }}</option>{% endfor %}
      </select>
    </label>
    <label class="text-sm">GSTIN
      <select name="registration_id" class="mt-1 w-full rounded border p-2" onchange="this.form.submit()">
        <option value="">Select GSTIN</option>
        {% for r,t in registrations %}<option value="{{ r.id }}" {% if selected_registration and r.id==selected_registration.id %}selected{% endif %}>{{ r.registration_number }}{% if r.trade_name %} — {{ r.trade_name }}{% endif %}</option>{% endfor %}
      </select>
    </label>
    <label class="text-sm">Financial Year<input name="financial_year" value="{{ financial_year }}" pattern="[0-9]{4}-[0-9]{2}" placeholder="2025-26" class="mt-1 w-full rounded border p-2"></label>
    <label class="text-sm">Mode
      <select name="download_mode" class="mt-1 w-full rounded border p-2">
        <option value="single" {% if download_mode=='single' %}selected{% endif %}>Single Month</option>
        <option value="full_fy" {% if download_mode=='full_fy' %}selected{% endif %}>Full Financial Year</option>
      </select>
    </label>
    <div class="flex items-end"><button class="w-full rounded bg-slate-800 px-3 py-2 text-white">Load</button></div>
    <label class="text-sm md:col-span-2">Single Month Period (MMYYYY)
      <input name="period" value="{{ period }}" pattern="[0-9]{6}" placeholder="042025" class="mt-1 w-full rounded border p-2">
      <span class="text-xs text-slate-500">Used only when Mode = Single Month.</span>
    </label>
  </form>

  {% if selected_client and selected_registration %}
  <div class="grid gap-4 lg:grid-cols-2">
    <form method="post" action="/tools/accounting/gst-reconciliation/download/start" class="rounded-xl border bg-white p-4 space-y-4">
      <input type="hidden" name="csrf_token" value="{{ csrf_token }}">
      <input type="hidden" name="client_id" value="{{ selected_client.id }}">
      <input type="hidden" name="registration_id" value="{{ selected_registration.id }}">
      <input type="hidden" name="period" value="{{ period }}">
      <input type="hidden" name="financial_year" value="{{ financial_year }}">
      <input type="hidden" name="download_mode" value="{{ download_mode }}">
      <div>
        <h2 class="font-semibold">1. Automatic GST Download</h2>
        <p class="mt-1 text-sm text-slate-600">The lightweight GST Operator Agent runs only on this workstation. It opens visible Chrome/Edge, autofills the selected Credential Vault username/password, and waits for you to complete CAPTCHA/OTP. It does not run Tally or hold the client storage.</p>
      </div>

      <div class="flex flex-wrap items-center gap-2 rounded-lg border bg-slate-50 p-3 text-sm">
        <span>GST Operator Agent:</span>
        <span class="font-semibold text-slate-700">Windows protocol launcher</span>
        <span class="text-slate-400">v{{ operator_agent_version }}</span>
        <a href="/tools/accounting/gst-reconciliation/operator-agent/download" class="ml-auto rounded border bg-white px-3 py-1.5 text-xs font-medium">Download / Clean Install Agent</a>
      </div>
      <p class="text-xs text-slate-500">No browser-to-localhost connection is required. When you start a GST download, Windows opens the installed agent through <b>arrrgst://</b>. Chrome/Edge may ask once for permission to open the ARRR GST Operator Agent.</p>

      <label class="text-sm">Credential Vault Entry
        <select name="credential_id" required class="mt-1 w-full rounded border p-2" {% if not credentials %}disabled{% endif %}>
          {% if credentials %}
            {% for c in credentials %}<option value="{{ c.id }}" {% if credentials|length==1 %}selected{% endif %}>{{ c.title }}{% if c.reference_number %} — {{ c.reference_number }}{% endif %}</option>{% endfor %}
          {% else %}
            <option>No GST Portal credential found</option>
          {% endif %}
        </select>
      </label>
      {% if credentials|length==1 %}<p class="text-xs text-slate-500">The only eligible GST Portal credential has been selected automatically.</p>{% endif %}

      <div class="rounded-lg border p-3">
        <div class="mb-2 text-sm font-medium">Returns to download</div>
        <div class="grid grid-cols-2 gap-3 text-sm">
          <label><input type="checkbox" name="gstr1" value="1" checked class="mr-2">GSTR-1</label>
          <label><input type="checkbox" name="gstr2b" value="1" checked class="mr-2">GSTR-2B</label>
          <label><input type="checkbox" name="gstr3b" value="1" checked class="mr-2">GSTR-3B</label>
          <label><input type="checkbox" name="gstr2a" value="1" class="mr-2">GSTR-2A</label>
        </div>
      </div>

      <button {% if not node_online or not credentials %}disabled{% endif %} class="rounded bg-indigo-600 px-4 py-2 text-white disabled:opacity-50">Start GST Download</button>
      <div class="text-xs">Configured Storage Agent: <b>{{ 'Online' if node_online else 'Offline' }}</b></div>
      <p class="text-xs text-slate-500">For Full Financial Year, the job processes April through March and reports progress month by month. The custom protocol contains only a short-lived signed job token. GST username/password are redeemed directly by the agent and are never placed in this page's HTML or protocol URL.</p>
    </form>

    <form method="post" action="/tools/accounting/gst-reconciliation/import" enctype="multipart/form-data" class="rounded-xl border bg-white p-4 space-y-3">
      <input type="hidden" name="csrf_token" value="{{ csrf_token }}">
      <input type="hidden" name="client_id" value="{{ selected_client.id }}">
      <input type="hidden" name="registration_id" value="{{ selected_registration.id }}">
      <input type="hidden" name="period" value="{{ period }}">
      <input type="hidden" name="financial_year" value="{{ financial_year }}">
      <input type="hidden" name="download_mode" value="{{ download_mode }}">
      <div>
        <h2 class="font-semibold">2. Manual Import Fallback</h2>
        <p class="mt-1 text-sm text-slate-600">If a GST portal download cannot be automated, keep the workflow moving by importing the portal JSON/ZIP files. They use the same client GST storage hierarchy and the same reconciliation engine.</p>
      </div>
      <label class="block text-sm">GSTR-1 files<input type="file" name="gstr1_files" accept=".json,.zip,application/json,application/zip" multiple class="mt-1 block w-full rounded border p-2"></label>
      <label class="block text-sm">GSTR-2B files<input type="file" name="gstr2b_files" accept=".json,.zip,application/json,application/zip" multiple class="mt-1 block w-full rounded border p-2"></label>
      <label class="block text-sm">GSTR-3B files<input type="file" name="gstr3b_files" accept=".json,.zip,application/json,application/zip" multiple class="mt-1 block w-full rounded border p-2"></label>
      <label class="block text-sm">GSTR-2A files <span class="text-slate-400">(optional)</span><input type="file" name="gstr2a_files" accept=".json,.zip,application/json,application/zip" multiple class="mt-1 block w-full rounded border p-2"></label>
      <button {% if not node_online %}disabled{% endif %} class="rounded bg-sky-700 px-4 py-2 text-white disabled:opacity-50">Import & Store GST Returns</button>
    </form>
  </div>

  <div id="gst-job-panel" class="hidden rounded-xl border bg-white p-4 space-y-2">
    <h2 class="font-semibold">Interactive GST Download</h2>
    <div id="gst-job-stage" class="text-sm font-medium"></div>
    <div id="gst-job-message" class="text-sm text-slate-600"></div>
    <a id="gst-agent-open" href="#" class="hidden inline-block rounded bg-indigo-600 px-4 py-2 text-sm text-white">Open GST Operator Agent</a>
    <p class="text-xs text-slate-500">If Chrome/Edge asks whether to open ARRR GST Operator Agent, choose Open/Allow. The GST browser then opens separately and the operator completes CAPTCHA/OTP there.</p>
  </div>

  <form method="post" action="/tools/accounting/gst-reconciliation/analyze" class="rounded-xl border bg-white p-4 space-y-3">
    <input type="hidden" name="csrf_token" value="{{ csrf_token }}"><input type="hidden" name="client_id" value="{{ selected_client.id }}"><input type="hidden" name="registration_id" value="{{ selected_registration.id }}"><input type="hidden" name="period" value="{{ period }}"><input type="hidden" name="financial_year" value="{{ financial_year }}">
    <h2 class="font-semibold">3. Reconcile Stored Data</h2>
    <p class="text-sm text-slate-600">Sales: Accounting Mirror vs GSTR-1. Purchases: Accounting Mirror vs GSTR-2B. ITC: GSTR-2B vs GSTR-3B. Analysis reads only stored client data, so download and reconciliation remain independent.</p>
    <div class="flex flex-wrap items-end gap-3">
      <label class="text-sm min-w-64">Analysis scope<select name="analyze_mode" class="mt-1 w-full rounded border p-2"><option value="single">Single Month</option><option value="full_fy" {% if download_mode=='full_fy' %}selected{% endif %}>Full Financial Year</option></select></label>
      <button {% if not node_online %}disabled{% endif %} class="rounded bg-emerald-600 px-4 py-2 text-white disabled:opacity-50">Run Reconciliation</button>
    </div>
  </form>

  {% set a=request.session.get('gst_reconciliation_result') or {} %}
  {% if a %}
    {% set s=a.get('sales_reconciliation',{}).get('counts',{}) %}{% set p=a.get('purchase_reconciliation',{}).get('counts',{}) %}
    <div class="rounded-xl border bg-white p-4 space-y-4"><h2 class="font-semibold">Reconciliation Summary — {{ a.get('period','') }}</h2>
      <div class="grid gap-3 md:grid-cols-2"><div class="rounded-lg border p-3"><h3 class="font-medium">Sales vs GSTR-1</h3><p class="text-sm">Books {{ s.get('books',0) }} · Portal {{ s.get('portal',0) }} · Matched {{ s.get('matched',0) }} · Missing in portal {{ s.get('missing_in_portal',0) }} · Missing in books {{ s.get('missing_in_books',0) }} · Value mismatch {{ s.get('value_mismatch',0) }}</p></div><div class="rounded-lg border p-3"><h3 class="font-medium">Purchases vs GSTR-2B</h3><p class="text-sm">Books {{ p.get('books',0) }} · 2B {{ p.get('portal',0) }} · Matched {{ p.get('matched',0) }} · Missing in 2B {{ p.get('missing_in_portal',0) }} · Missing in books {{ p.get('missing_in_books',0) }} · Value mismatch {{ p.get('value_mismatch',0) }}</p></div></div>
      <div><h3 class="font-medium mb-2">ITC: GSTR-2B vs GSTR-3B</h3><div class="overflow-x-auto"><table class="min-w-full text-sm"><thead><tr><th class="p-2 text-left">Tax</th><th class="p-2 text-right">GSTR-2B</th><th class="p-2 text-right">GSTR-3B</th><th class="p-2 text-right">Difference</th></tr></thead><tbody>{% for tax,row in a.get('itc_reconciliation',{}).items() %}<tr class="border-t"><td class="p-2 uppercase">{{ tax }}</td><td class="p-2 text-right">{{ '%.2f'|format(row.get('gstr2b',0)) }}</td><td class="p-2 text-right">{{ '%.2f'|format(row.get('gstr3b',0)) }}</td><td class="p-2 text-right">{{ '%.2f'|format(row.get('difference',0)) }}</td></tr>{% endfor %}</tbody></table></div></div>
    </div>
  {% endif %}
  {% endif %}
</div>

<script>
(() => {
  const panel = document.getElementById('gst-job-panel');
  const stage = document.getElementById('gst-job-stage');
  const msg = document.getElementById('gst-job-message');
  const openLink = document.getElementById('gst-agent-open');

  {% if operator_job %}
  const prepared = {{ operator_job|tojson }};
  if (panel) panel.classList.remove('hidden');
  if (stage) stage.textContent = 'Launching GST Operator Agent';
  if (msg) msg.textContent = 'Windows is being asked to open the lightweight GST agent. If the browser shows an external-app confirmation, choose Open/Allow.';
  if (openLink) {
    openLink.href = prepared.launch_url;
    openLink.classList.remove('hidden');
  }
  // The protocol launch replaces the previous browser-to-localhost HTTPS fetch.
  // A short delay lets the ERP page finish rendering before Chrome/Edge opens the registered Windows handler.
  window.setTimeout(() => { window.location.href = prepared.launch_url; }, 250);
  {% endif %}
})();
</script>
{% endblock %}