{% extends "pos/base.html" %}
{% block title %}Duplicate Purchase Cleanup{% endblock %}

{% block content %}
<div class="container-fluid mt-3">

  <div class="d-flex justify-content-between align-items-center mb-3">
    <h4 class="mb-0">
      <i class="fas fa-broom"></i> Duplicate Purchase Invoice Cleanup
    </h4>
    <a href="{% url 'purchases:purchases_list' %}" class="btn btn-sm btn-outline-secondary">
      <i class="fas fa-arrow-left"></i> Back to Purchases
    </a>
  </div>

  {% if executed %}
    <div class="alert alert-success">
      <strong>Cleanup executed.</strong> Any remaining issues below are ones
      the run could not fully fix automatically.
    </div>
  {% endif %}

  {% if warnings %}
    <div class="alert alert-warning">
      <strong>Warnings ({{ warnings|length }}):</strong>
      <ul class="mb-0">
        {% for w in warnings %}<li>{{ w }}</li>{% endfor %}
      </ul>
    </div>
  {% endif %}

  <div class="card shadow-sm mb-3">
    <div class="card-body">
      <div class="row text-center">
        <div class="col">
          <div class="text-muted small">Affected invoices</div>
          <div class="h4 mb-0">{{ totals.invoices }}</div>
        </div>
        <div class="col">
          <div class="text-muted small">Extra payment rows</div>
          <div class="h4 mb-0 text-danger">{{ totals.pay_extras }}</div>
        </div>
        <div class="col">
          <div class="text-muted small">Extra line rows</div>
          <div class="h4 mb-0 text-danger">{{ totals.line_extras }}</div>
        </div>
        <div class="col">
          <div class="text-muted small">Extra stock_history rows</div>
          <div class="h4 mb-0 text-danger">{{ totals.sh_extras }}</div>
        </div>
        <div class="col">
          <div class="text-muted small">Serials removable</div>
          <div class="h4 mb-0">{{ totals.serial_safe }}</div>
        </div>
        <div class="col">
          <div class="text-muted small">Serials blocked</div>
          <div class="h4 mb-0 text-warning">{{ totals.serial_block }}</div>
        </div>
        <div class="col">
          <div class="text-muted small">Extra builty rows</div>
          <div class="h4 mb-0">{{ totals.builty_extras }}</div>
        </div>
      </div>
    </div>
  </div>

  {% if not plans %}
    <div class="alert alert-info mb-0">
      No duplicate purchase invoices detected. Nothing to do.
    </div>
  {% else %}

    <div class="card shadow-sm mb-3">
      <div class="card-body">
        <h6 class="mb-2">Plan — one block per (invoice #, bill type)</h6>
        <p class="text-muted small mb-0">
          Rows marked <span class="badge badge-success">KEEP</span> stay.
          Rows marked <span class="badge badge-danger">DEL</span> would be
          removed when Execute is pressed.
        </p>
      </div>
    </div>

    {% for plan in plans %}
      <div class="card shadow-sm mb-3">
        <div class="card-header">
          <strong>Invoice #{{ plan.invoice_no }}</strong>
          &nbsp;|&nbsp; {{ plan.category_label }}
          &nbsp;|&nbsp; Party: <strong>{{ plan.party_label }}</strong>
          <span class="float-right">
            {{ plan.pay_extras_count }} extra payments,
            {{ plan.line_extras }} extra lines,
            {{ plan.sh_extras }} extra stock rows
          </span>
        </div>
        <div class="card-body p-2">

          {# ─── PAYMENTS ─── #}
          <div class="mb-2">
            <div class="text-muted small font-weight-bold px-2">Payments</div>
            <table class="table table-sm mb-0">
              <thead class="thead-light">
                <tr>
                  <th>Action</th>
                  <th>payment_id</th>
                  <th class="text-right">total_amount</th>
                  <th class="text-right">amount_transaction (paid)</th>
                  <th>date</th>
                  <th>challan</th>
                </tr>
              </thead>
              <tbody>
                {% if plan.pay_keeper %}
                <tr class="table-success">
                  <td><span class="badge badge-success">KEEP</span></td>
                  <td>{{ plan.pay_keeper.payment_id }}</td>
                  <td class="text-right">{{ plan.pay_keeper.total_amount }}</td>
                  <td class="text-right">{{ plan.pay_keeper.amount_transaction }}</td>
                  <td>{{ plan.pay_keeper.transaction_date }}</td>
                  <td>{{ plan.pay_keeper.builty_no|default:"" }}</td>
                </tr>
                {% endif %}
                {% for p in plan.pay_extras %}
                <tr class="table-danger">
                  <td><span class="badge badge-danger">DEL</span></td>
                  <td>{{ p.payment_id }}</td>
                  <td class="text-right">{{ p.total_amount }}</td>
                  <td class="text-right">{{ p.amount_transaction }}</td>
                  <td>{{ p.transaction_date }}</td>
                  <td>{{ p.builty_no|default:"" }}</td>
                </tr>
                {% endfor %}
              </tbody>
            </table>
          </div>

          {# ─── LINES ─── #}
          <div class="mb-2">
            <div class="text-muted small font-weight-bold px-2">
              Purchase lines &nbsp;·&nbsp;
              {{ plan.line_total }} total &rArr; {{ plan.line_keepers }} keeper(s),
              {{ plan.line_extras }} extra
            </div>
          </div>

          {# ─── STOCK HISTORY ─── #}
          <div class="mb-2">
            <div class="text-muted small font-weight-bold px-2">
              stock_history &nbsp;·&nbsp;
              {{ plan.sh_total }} rows &rArr; {{ plan.sh_keepers }} keeper(s),
              {{ plan.sh_extras }} extra
            </div>
          </div>

          {# ─── SERIALS ─── #}
          {% if plan.serials_to_remove or plan.serials_blocked %}
          <div class="mb-2">
            <div class="text-muted small font-weight-bold px-2">Serials</div>
            <table class="table table-sm mb-0">
              <thead class="thead-light">
                <tr>
                  <th>Action</th>
                  <th>serial_no</th>
                  <th>status</th>
                </tr>
              </thead>
              <tbody>
                {% for s in plan.serials_to_remove %}
                <tr class="table-danger">
                  <td><span class="badge badge-danger">DEL</span></td>
                  <td>{{ s.serial_no }}</td>
                  <td>{{ s.status }}</td>
                </tr>
                {% endfor %}
                {% for s in plan.serials_blocked %}
                <tr class="table-warning">
                  <td><span class="badge badge-warning">SKIP</span></td>
                  <td>{{ s.serial_no }}</td>
                  <td>{{ s.status }} (already moved)</td>
                </tr>
                {% endfor %}
              </tbody>
            </table>
          </div>
          {% endif %}

          {# ─── FIFO ─── #}
          {% if plan.fifo_plan %}
          <div class="mb-2">
            <div class="text-muted small font-weight-bold px-2">FIFO layers (sub_products_list)</div>
            <table class="table table-sm mb-0">
              <thead class="thead-light">
                <tr>
                  <th>Product</th>
                  <th class="text-right">Price</th>
                  <th class="text-right">Layer qty (now)</th>
                  <th class="text-right">Want to reduce by</th>
                  <th class="text-right">Will reduce by</th>
                  <th></th>
                </tr>
              </thead>
              <tbody>
                {% for fp in plan.fifo_plan %}
                <tr {% if fp.floored %}class="table-warning"{% endif %}>
                  <td>{{ fp.prod_name }} <small class="text-muted">({{ fp.product_code }})</small></td>
                  <td class="text-right">{{ fp.price }}</td>
                  <td class="text-right">{{ fp.layer_qty }}</td>
                  <td class="text-right">{{ fp.want_reduce }}</td>
                  <td class="text-right">{{ fp.will_reduce }}</td>
                  <td>{% if fp.floored %}<small>partial — reconcile after</small>{% endif %}</td>
                </tr>
                {% endfor %}
              </tbody>
            </table>
          </div>
          {% endif %}

          {# ─── BUILTY EXTRAS ─── #}
          {% if plan.builty_extras_count %}
          <div class="mb-2">
            <div class="text-muted small font-weight-bold px-2">
              Builty expense extras: {{ plan.builty_extras_count }}
              (will also remove matching expense payment row + create_today_expense row)
            </div>
          </div>
          {% endif %}

          <div class="text-muted small px-2">
            Party running balance released after this cleanup:
            <strong>{{ plan.party_balance_delta|floatformat:2 }}</strong>
            (rebuilt from scratch on Execute)
          </div>

        </div>
      </div>
    {% endfor %}

    {# ── Execute button ── #}
    {% if not executed %}
    <div class="card shadow-sm mb-4 border-danger">
      <div class="card-body">
        <form method="POST">
          {% csrf_token %}
          <div class="form-check mb-2">
            <input type="checkbox" class="form-check-input" id="ack" required>
            <label class="form-check-label" for="ack">
              I have read the plan above and understand this will permanently
              delete the marked rows and rebuild running balances for every
              affected party. A DB backup exists.
            </label>
          </div>
          <button type="submit" name="confirm" value="EXECUTE"
                  class="btn btn-danger">
            <i class="fas fa-play"></i> Execute Cleanup
          </button>
          <a href="{% url 'purchases:cleanup_duplicates' %}" class="btn btn-secondary">
            Re-run Dry Run
          </a>
        </form>
      </div>
    </div>
    <script>
      // Only allow submit after acknowledgement is checked
      (function(){
        var f = document.querySelector('form[method="POST"]');
        if (!f) return;
        f.addEventListener('submit', function(e){
          var ack = document.getElementById('ack');
          if (!ack || !ack.checked) {
            e.preventDefault();
            alert('Please confirm the acknowledgement first.');
          }
        });
      })();
    </script>
    {% endif %}

  {% endif %}

</div>
{% endblock %}