{% extends "pos/base.html" %}
{% load static %}

{% block title %}BP Agent Database{% endblock %}

{% block content %}

<div class="container-fluid py-3">
  <div class="card">
    <div class="card-header">
      <strong>BP Local Agent Database</strong>
    </div>

    <div class="card-body">
      <div class="alert alert-warning">
        Restore se pehle current agent database ka backup automatically banega.
        Sirf valid BP Agent SQLite DB upload karein.
      </div>

      <div class="mb-3">
        <button type="button" class="btn btn-primary btn-sm" id="btnDownloadAgentBackup">
          Download Current DB Backup
        </button>
      </div>

      <hr>

      <div class="form-group">
        <label><strong>Select DB File</strong></label>
        <input type="file" class="form-control" id="agentDbFile" accept=".db,.sqlite,.sqlite3">
      </div>

      <button type="button" class="btn btn-danger btn-sm" id="btnRestoreAgentDb">
        Restore Database
      </button>

      <div class="mt-3 small" id="agentDbStatus"></div>
    </div>
  </div>
</div>

<script>
(function () {
  var AGENT_URL = "{{ agent_base_url }}";

  function setStatus(message, type) {
    type = type || "info";

    var cls = "alert-info";
    if (type === "success") cls = "alert-success";
    if (type === "error") cls = "alert-danger";
    if (type === "warning") cls = "alert-warning";

    document.getElementById("agentDbStatus").innerHTML =
      '<div class="alert ' + cls + '">' + message + '</div>';
  }

  document.getElementById("btnDownloadAgentBackup").addEventListener("click", function () {
    window.open(AGENT_URL + "/backup/db", "_blank");
  });

  document.getElementById("btnRestoreAgentDb").addEventListener("click", function () {
    var fileInput = document.getElementById("agentDbFile");

    if (!fileInput.files || !fileInput.files.length) {
      setStatus("Please select database file first.", "warning");
      return;
    }

    if (!confirm("Are you sure? Current BP Agent database will be replaced after backup.")) {
      return;
    }

    var formData = new FormData();
    formData.append("file", fileInput.files[0]);

    setStatus("Restoring database, please wait...", "info");

    fetch(AGENT_URL + "/restore/db", {
      method: "POST",
      body: formData
    })
    .then(function (res) {
      return res.json();
    })
    .then(function (data) {
      if (data && data.ok) {
        setStatus(
          "Database restored successfully.<br>Backup: " + (data.backup_name || "-"),
          "success"
        );
      } else {
        setStatus((data && data.error) || "Restore failed.", "error");
      }
    })
    .catch(function (err) {
      setStatus("Agent connection failed: " + err, "error");
    });
  });
})();
</script>

{% endblock %}