{% extends "pos/base.html" %}
{% load static %}
{% block title %}Bulk Variant Stock Edit{% endblock %}


{% block stylesheets %}
  {{ block.super }}
  <style>
    :root {
      --primary: #2563eb;
      --primary-dark: #1d4ed8;
      --primary-light: #dbeafe;
      --success: #16a34a;
      --warning: #f59e0b;
      --danger: #dc2626;
      --gray-50: #f9fafb;
      --gray-100: #f3f4f6;
      --gray-200: #e5e7eb;
      --gray-300: #d1d5db;
      --gray-400: #9ca3af;
      --gray-500: #6b7280;
      --gray-600: #4b5563;
      --gray-700: #374151;
      --gray-800: #1f2937;
    }
    * { box-sizing: border-box; }
    .bv-wrapper { max-width: 100%; overflow-x: hidden; padding: 0 5px; }

    /* Card */
    .card-compact { background:#fff; border:1px solid var(--gray-200); border-radius:6px; margin-bottom:12px; box-shadow:0 1px 2px rgba(0,0,0,.04); }
    .card-compact .card-header { background:var(--gray-50); border-bottom:1px solid var(--gray-200); padding:10px 15px; font-size:13px; font-weight:600; color:var(--gray-700); display:flex; align-items:center; gap:8px; }
    .card-compact .card-header i { color:var(--primary); font-size:12px; }
    .card-compact .card-body { padding:12px 15px; }

    /* Top Bar */
    .top-bar { display:flex; justify-content:space-between; align-items:center; margin-bottom:12px; flex-wrap:wrap; gap:10px; }
    .btn-back { background:#fff; color:var(--gray-600); border:1px solid var(--gray-300); padding:6px 14px; border-radius:5px; font-size:13px; font-weight:500; text-decoration:none; display:inline-flex; align-items:center; gap:6px; transition:all .15s; }
    .btn-back:hover { background:var(--gray-50); color:var(--gray-700); text-decoration:none; }
    .page-title { font-size:18px; font-weight:600; color:var(--gray-800); display:flex; align-items:center; gap:8px; }
    .page-title i { color:var(--primary); }

    /* Filter Row */
    .filter-row { display:flex; flex-wrap:wrap; align-items:flex-end; gap:12px; }
    .filter-item { display:flex; flex-direction:column; gap:4px; }
    .filter-item label { font-size:11px; font-weight:600; color:var(--gray-500); text-transform:uppercase; letter-spacing:.3px; }
    .filter-item .form-control,
    .filter-item .select2-container { min-width:160px; }

    /* Radio Group */
    .radio-group { display:flex; gap:4px; background:var(--gray-100); padding:3px; border-radius:5px; }
    .radio-group input { display:none; }
    .radio-group label { padding:5px 12px; font-size:12px; font-weight:500; color:var(--gray-600); cursor:pointer; border-radius:4px; transition:all .15s; text-transform:none; letter-spacing:0; display:flex; align-items:center; gap:4px; }
    .radio-group label i { font-size:10px; }
    .radio-group input:checked + label { background:#fff; color:var(--primary); box-shadow:0 1px 2px rgba(0,0,0,.08); }

    /* Small Input */
    .input-sm { height:32px; padding:4px 10px; font-size:13px; border:1px solid var(--gray-300); border-radius:5px; color:var(--gray-700); transition:border-color .15s; }
    .input-sm:focus { outline:none; border-color:var(--primary); box-shadow:0 0 0 2px var(--primary-light); }

    /* Select2 overrides */
    .select2-container--default .select2-selection--single { height:32px; border:1px solid var(--gray-300); border-radius:5px; }
    .select2-container--default .select2-selection--single .select2-selection__rendered { line-height:30px; font-size:13px; padding-left:10px; }
    .select2-container--default .select2-selection--single .select2-selection__arrow { height:30px; }

    /* Toggle */
    .toggle-sm { display:flex; align-items:center; gap:6px; }
    .toggle-sm input { display:none; }
    .toggle-sm .slider { width:36px; height:20px; background:var(--gray-300); border-radius:10px; cursor:pointer; position:relative; transition:background .2s; }
    .toggle-sm .slider::after { content:''; position:absolute; width:16px; height:16px; background:#fff; border-radius:50%; top:2px; left:2px; transition:transform .2s; box-shadow:0 1px 2px rgba(0,0,0,.15); }
    .toggle-sm input:checked + .slider { background:var(--primary); }
    .toggle-sm input:checked + .slider::after { transform:translateX(16px); }
    .toggle-sm .label-text { font-size:12px; color:var(--gray-600); }

    /* Buttons */
    .btn-sm { height:32px; padding:0 14px; font-size:12px; font-weight:600; border-radius:5px; border:none; cursor:pointer; display:inline-flex; align-items:center; gap:5px; transition:all .15s; }
    .btn-primary { background:var(--primary); color:#fff; }
    .btn-primary:hover { background:var(--primary-dark); }
    .btn-success { background:var(--success); color:#fff; }
    .btn-success:hover { background:#15803d; }
    .btn-secondary { background:var(--gray-100); color:var(--gray-600); border:1px solid var(--gray-300); }
    .btn-secondary:hover { background:var(--gray-200); }

    /* Action Bar */
    .action-bar { display:flex; justify-content:space-between; align-items:center; flex-wrap:wrap; gap:10px; margin-bottom:12px; padding:10px 15px; background:#fff; border:1px solid var(--gray-200); border-radius:6px; }
    .action-buttons { display:flex; gap:8px; flex-wrap:wrap; }
    .status-box { display:flex; align-items:center; gap:8px; font-size:13px; color:var(--gray-500); }
    .status-dot { width:8px; height:8px; border-radius:50%; background:var(--gray-300); }
    .status-dot.active { background:var(--warning); animation:pulse 1.5s infinite; }
    @keyframes pulse { 0%,100%{opacity:1} 50%{opacity:.5} }

    /* ════════════════════════════════════════════
       🔍 SEARCH BAR STYLES (NEW)
       ════════════════════════════════════════════ */
    .search-bar {
      display: flex;
      align-items: center;
      gap: 10px;
      margin-bottom: 12px;
      padding: 10px 15px;
      background: #fff;
      border: 1px solid var(--gray-200);
      border-radius: 6px;
    }
    .search-input-wrapper {
      position: relative;
      flex: 1;
      max-width: 450px;
    }
    .search-input-wrapper i.search-icon {
      position: absolute;
      left: 10px;
      top: 50%;
      transform: translateY(-50%);
      color: var(--gray-400);
      font-size: 13px;
      pointer-events: none;
      transition: color 0.2s;
    }
    .search-input-wrapper input {
      width: 100%;
      height: 36px;
      padding: 6px 36px 6px 32px;
      font-size: 13px;
      border: 2px solid var(--gray-200);
      border-radius: 8px;
      color: var(--gray-700);
      background: var(--gray-50);
      transition: all 0.2s;
    }
    .search-input-wrapper input:focus {
      outline: none;
      border-color: var(--primary);
      background: #fff;
      box-shadow: 0 0 0 3px var(--primary-light);
    }
    .search-input-wrapper input:focus + i.search-icon,
    .search-input-wrapper input:not(:placeholder-shown) + i.search-icon {
      color: var(--primary);
    }
    .search-input-wrapper input::placeholder {
      color: var(--gray-400);
      font-size: 12px;
    }
    .search-clear-btn {
      position: absolute;
      right: 8px;
      top: 50%;
      transform: translateY(-50%);
      background: var(--gray-200);
      border: none;
      color: var(--gray-500);
      cursor: pointer;
      width: 20px;
      height: 20px;
      border-radius: 50%;
      display: none;
      align-items: center;
      justify-content: center;
      font-size: 10px;
      transition: all 0.15s;
    }
    .search-clear-btn:hover {
      background: var(--danger);
      color: #fff;
    }
    .search-input-wrapper input:not(:placeholder-shown) ~ .search-clear-btn {
      display: flex;
    }
    .search-result-count {
      font-size: 12px;
      color: var(--gray-500);
      white-space: nowrap;
      display: flex;
      align-items: center;
      gap: 5px;
    }
    .search-result-count .count-badge {
      background: var(--primary-light);
      color: var(--primary);
      padding: 2px 8px;
      border-radius: 10px;
      font-weight: 600;
      font-size: 11px;
    }
    .search-result-count .count-badge.filtered {
      background: #fef3c7;
      color: var(--warning);
    }
    .search-shortcut {
      font-size: 10px;
      color: var(--gray-400);
      background: var(--gray-100);
      border: 1px solid var(--gray-200);
      padding: 2px 6px;
      border-radius: 3px;
      font-family: monospace;
    }

    /* Info Banner */
    .info-banner { background:linear-gradient(135deg, var(--primary) 0%, var(--primary-dark) 100%); border-radius:6px; padding:12px 16px; margin-bottom:12px; display:flex; align-items:center; gap:12px; color:#fff; font-size:13px; }
    .info-banner i { font-size:18px; opacity:.85; }
    .info-banner .info-text { flex:1; }
    .info-banner .info-text strong { display:block; font-size:14px; margin-bottom:2px; }
    .info-banner .info-text span { opacity:.8; font-size:11px; }

    /* Tabulator */
    .tabulator { font-size:12px; border:1px solid var(--gray-200); border-radius:6px; }
    .tabulator .tabulator-header { background:var(--gray-700); border-bottom:none; }
    .tabulator .tabulator-header .tabulator-col { background:transparent; border-right:1px solid var(--gray-600); }
    .tabulator .tabulator-header .tabulator-col .tabulator-col-content { padding:8px 6px; }
    .tabulator .tabulator-header .tabulator-col .tabulator-col-title { color:#fff; font-weight:600; font-size:11px; }
    .tabulator .tabulator-tableholder .tabulator-table .tabulator-row { border-bottom:1px solid var(--gray-100); }
    .tabulator .tabulator-tableholder .tabulator-table .tabulator-row:nth-child(even) { background:var(--gray-50); }
    .tabulator .tabulator-tableholder .tabulator-table .tabulator-row:hover { background:var(--primary-light); }
    .tabulator .tabulator-cell { padding:6px; border-right:1px solid var(--gray-100); }
    .tabulator .tabulator-cell.dirty-cell { background:#fef3c7 !important; }
    .tabulator .tabulator-cell.multi-variant { background:#fee2e2 !important; cursor:not-allowed; }
    .tabulator .tabulator-cell input { border:1px solid var(--primary); border-radius:3px; padding:2px 5px; font-size:12px; }
    .tabulator .tabulator-cell input:focus { outline:none; box-shadow:0 0 0 2px var(--primary-light); }
    .tabulator .tabulator-frozen { background:#eef2ff !important; }

    /* Default variant column header highlight */
    .tabulator .tabulator-header .tabulator-col[tabulator-field="sa_default"] {
      background: #1e3a5f !important;
    }
    .tabulator .tabulator-cell[tabulator-field="sa_default"] {
      background: #f0f4ff !important;
      border-right: 2px solid var(--gray-300) !important;
    }
    .tabulator .tabulator-cell[tabulator-field="sa_default"].dirty-cell {
      background: #fef3c7 !important;
    }

    /* Remove number spinners */
    input[type="number"]::-webkit-outer-spin-button,
    input[type="number"]::-webkit-inner-spin-button { -webkit-appearance:none; margin:0; }
    input[type="number"] { -moz-appearance:textfield; }

    /* Toast */
    .toast-container { position:fixed; top:15px; right:15px; z-index:9999; }
    .toast { background:#fff; border-radius:6px; box-shadow:0 4px 15px rgba(0,0,0,.15); padding:10px 14px; margin-bottom:8px; display:flex; align-items:center; gap:10px; min-width:250px; max-width:350px; animation:slideIn .25s ease; border-left:4px solid var(--gray-400); }
    @keyframes slideIn { from{transform:translateX(100%);opacity:0} to{transform:translateX(0);opacity:1} }
    .toast.success { border-left-color:var(--success); }
    .toast.error   { border-left-color:var(--danger);  }
    .toast.warning { border-left-color:var(--warning); }
    .toast.info    { border-left-color:var(--primary); }
    .toast i { font-size:14px; }
    .toast.success i { color:var(--success); }
    .toast.error i   { color:var(--danger);  }
    .toast.warning i { color:var(--warning); }
    .toast.info i    { color:var(--primary); }
    .toast-content { flex:1; }
    .toast-title { font-size:13px; font-weight:600; color:var(--gray-800); }
    .toast-msg   { font-size:11px; color:var(--gray-500); }
    .toast-close { background:none; border:none; color:var(--gray-400); cursor:pointer; padding:2px; }

    /* Loading */
    .loading-overlay { position:fixed; top:0;left:0;right:0;bottom:0; background:rgba(255,255,255,.85); display:flex; flex-direction:column; align-items:center; justify-content:center; z-index:9998; opacity:0; visibility:hidden; transition:all .2s; }
    .loading-overlay.show { opacity:1; visibility:visible; }
    .spinner { width:36px; height:36px; border:3px solid var(--gray-200); border-top-color:var(--primary); border-radius:50%; animation:spin .8s linear infinite; }
    @keyframes spin { to{transform:rotate(360deg)} }
    .loading-text { margin-top:10px; font-size:13px; color:var(--gray-600); }

    /* Responsive */
    @media (max-width:768px) {
      .filter-row { flex-direction:column; align-items:stretch; }
      .filter-item { width:100%; }
      .filter-item .form-control,
      .filter-item .select2-container { width:100%!important; min-width:100%; }
      .search-bar { flex-direction:column; align-items:stretch; }
      .search-input-wrapper { max-width:100%; }
    }
  </style>
{% endblock %}

{% block content %}

<!-- Toast Container -->
<div id="toastContainer" class="toast-container"></div>

<!-- Loading Overlay -->
<div id="loadingOverlay" class="loading-overlay">
  <div class="spinner"></div>
  <div class="loading-text">Processing...</div>
</div>

<div class="bv-wrapper">

  <!-- ═══ Top Bar ═══ -->
  <div class="top-bar">
    <span class="page-title">
      <i class="fas fa-layer-group"></i> Bulk Variant Stock Edit
    </span>
    <a href="{% url 'products:products_list' %}" class="btn-back">
      <i class="fas fa-arrow-left"></i> Back
    </a>
  </div>

  <!-- ═══ Filter Card ═══ -->
  <div class="card-compact">
    <div class="card-header">
      <i class="fas fa-filter"></i> Filter &amp; Load Data
    </div>
    <div class="card-body">
      <div class="filter-row">

        <!-- Mode -->
        <div class="filter-item">
          <label>Filter By</label>
          <div class="radio-group">
            <input type="radio" name="mode" id="modeAll" value="all" checked>
            <label for="modeAll"><i class="fas fa-globe"></i> All</label>
            <input type="radio" name="mode" id="modeCompany" value="company">
            <label for="modeCompany"><i class="fas fa-building"></i> Company</label>
            <input type="radio" name="mode" id="modeCategory" value="category">
            <label for="modeCategory"><i class="fas fa-tag"></i> Category</label>
          </div>
        </div>

        <!-- Company (hidden by default) -->
        <div class="filter-item" id="companyGroup" style="display:none;">
          <label>Company</label>
          <select id="filter_company" class="form-control" style="width:180px;"></select>
        </div>

        <!-- Category (hidden by default) -->
        <div class="filter-item" id="categoryGroup" style="display:none;">
          <label>Category</label>
          <select id="filter_category" class="form-control" style="width:180px;"></select>
        </div>

        <!-- Spec-A Filter -->
        <div class="filter-item">
          <label>Spec-A</label>
          <select id="filter_spec_a" class="form-control" style="width:180px;"></select>
        </div>

        <!-- Limit -->
        <div class="filter-item">
          <label>Max Rows</label>
          <input type="number" id="limit" class="input-sm" value="500" min="1" style="width:85px;">
        </div>

        <!-- Show All -->
        <div class="filter-item">
          <label>Show All Products</label>
          <div class="toggle-sm">
            <input type="checkbox" id="showAll">
            <label for="showAll" class="slider"></label>
            <span class="label-text" id="showAllLabel">Off</span>
          </div>
        </div>

        <!-- Load Button -->
        <div class="filter-item">
          <label>&nbsp;</label>
          <button id="btnLoad" class="btn-sm btn-primary">
            <i class="fas fa-download"></i> Load
          </button>
        </div>

      </div>
    </div>
  </div>

  <!-- ═══════════════════════════════════════════
       🔍 SEARCH BAR (NEW)
       ═══════════════════════════════════════════ -->
  <div class="search-bar">
    <div class="search-input-wrapper">
      <input type="text" id="gridSearch" placeholder="Search by Code or Product Name..." autocomplete="off">
      <i class="fas fa-search search-icon"></i>
      <button class="search-clear-btn" id="searchClearBtn" title="Clear search">
        <i class="fas fa-times"></i>
      </button>
    </div>
    <div class="search-result-count" id="searchResultCount">
      <span id="searchCountText">Type to search...</span>
      <span class="search-shortcut" title="Press Ctrl+F to focus search">Ctrl+F</span>
    </div>
  </div>

  <!-- ═══ Action Bar ═══ -->
  <div class="action-bar">
    <div class="action-buttons">
      <button id="btnSave" class="btn-sm btn-success">
        <i class="fas fa-save"></i> Save
      </button>
      <button id="btnDiscard" class="btn-sm btn-secondary">
        <i class="fas fa-undo"></i> Discard
      </button>
      <button id="btnRefresh" class="btn-sm btn-secondary">
        <i class="fas fa-sync-alt"></i> Refresh
      </button>
    </div>
    <div class="status-box">
      <div class="status-dot" id="statusDot"></div>
      <span id="statusText">No changes</span>
    </div>
  </div>

  <!-- ═══ Grid ═══ -->
  <div id="grid"></div>

</div>

{% endblock %}

{% block javascripts %}
  {{ block.super }}
  <script>
  (function() {
    "use strict";

    // CONSTANTS & URLS
    const CSRF      = getCookie('csrftoken') || '{{ csrf_token }}';
    const FETCH_URL = '{% url "products:variant_stock_bulk_fetch" %}';
    const SAVE_URL  = '{% url "products:variant_stock_bulk_save" %}';

    function getCookie(n) {
      const m = document.cookie.match('(^|;)\\s*' + n + '\\s*=\\s*([^;]+)');
      return m ? m.pop() : '';
    }

    // TOAST
    function toast(type, title, msg, dur) {
      dur = dur || 3500;
      const icons = {success:'fa-check-circle', error:'fa-times-circle', warning:'fa-exclamation-circle', info:'fa-info-circle'};
      const c = document.getElementById('toastContainer');
      const t = document.createElement('div');
      t.className = 'toast ' + type;
      t.innerHTML =
        '<i class="fas ' + (icons[type]||'fa-info-circle') + '"></i>' +
        '<div class="toast-content">' +
          '<div class="toast-title">' + title + '</div>' +
          '<div class="toast-msg">' + msg + '</div>' +
        '</div>' +
        '<button class="toast-close"><i class="fas fa-times"></i></button>';
      c.appendChild(t);
      t.querySelector('.toast-close').onclick = function() { t.remove(); };
      setTimeout(function() { t.remove(); }, dur);
    }

    function showLoad(txt) {
      var o = document.getElementById('loadingOverlay');
      o.querySelector('.loading-text').textContent = txt || 'Processing...';
      o.classList.add('show');
    }
    function hideLoad() { document.getElementById('loadingOverlay').classList.remove('show'); }

    // STATE
    var table          = null;
    var currentData    = [];
    var currentCols    = [];
    var originalData   = {};
    var changedCells   = {};
    var changedCount   = 0;

    // SELECT2 INIT
    $('#filter_company').select2({
      ajax: { url:'{% url "products:companies_autocomplete" %}', data:function(p){return {term:p.term};}, processResults:function(d){return {results:d};} },
      placeholder:'Search...', allowClear:true, minimumInputLength:1, width:'100%'
    });
    $('#filter_category').select2({
      ajax: { url:'{% url "products:categories_autocomplete" %}', data:function(p){return {term:p.term};}, processResults:function(d){return {results:d};} },
      placeholder:'Search...', allowClear:true, minimumInputLength:1, width:'100%'
    });
    $('#filter_spec_a').select2({
      ajax: { url:'{% url "products:spec_a_autocomplete" %}', data:function(p){return {term:p.term};}, processResults:function(d){return {results:d};} },
      placeholder:'All Spec-A...', allowClear:true, minimumInputLength:0, width:'100%'
    });

    // Mode toggles
    $('input[name="mode"]').on('change', function() {
      $('#companyGroup, #categoryGroup').hide();
      $('#filter_company, #filter_category').val(null).trigger('change');
      if (this.value === 'company')  $('#companyGroup').show();
      if (this.value === 'category') $('#categoryGroup').show();
    });

    $('#showAll').on('change', function() {
      $('#showAllLabel').text(this.checked ? 'On' : 'Off');
    });

    function buildColumns(specACols) {
        var cols = [
            { field:"product_code", title:"Code",         frozen:true, width:110 },
            { field:"name",         title:"Product Name",  frozen:true, minWidth:160 },
            { field:"present_stock",title:"Total Stock",   hozAlign:"right", width:90,
              cssClass:"tabulator-frozen",
              formatter: function(cell) {
                return parseFloat(cell.getValue() || 0).toFixed(2);
              }
            },
            // ── Default Variant column ──
            {
              field: 'sa_default',
              title: 'Default',
              editor: 'input',
              hozAlign: 'right',
              width: 105,
              headerTooltip: 'Default Variant Stock',
              editable: function(cell) {
                return cell.getRow().getData().vid_default != null;
              },
              formatter: function(cell) {
                if (cell.getRow().getData().vid_default == null) {
                  return '<span style="color:#ccc;">—</span>';
                }
                return parseFloat(cell.getValue() || 0).toFixed(2);
              },
              headerHozAlign: 'center',
            },
        ];

        specACols.forEach(function(sa) {
            cols.push({
                field: 'sa_' + sa.id,
                title: sa.name,
                editor: 'input',
                hozAlign: 'right',
                width: 100,
                headerTooltip: 'Spec-A: ' + sa.name,
                editable: true,
                formatter: function(cell) {
                    return parseFloat(cell.getValue() || 0).toFixed(2);
                },
            });
        });

        return cols;
    }

    // INIT / REBUILD TABLE
    function initTable() {
      if (table) { table.destroy(); table = null; }

      var cols = buildColumns(currentCols);

      table = new Tabulator("#grid", {
        height: "58vh",
        layout: "fitDataStretch",
        movableColumns: false,
        selectable: false,
        columns: cols,
        index: "id",
        data: currentData,
        placeholder: '<div style="padding:40px;color:#9ca3af;text-align:center;">' +
                     '<i class="fas fa-layer-group" style="font-size:28px;"></i><br><br>' +
                     'No data — select filters and click <b>Load</b></div>',
      });

      attachGridEvents();
      reapplyDirty();

      // ═══ Re-apply current search filter after table rebuild ═══
      var currentSearch = document.getElementById('gridSearch').value.trim();
      if (currentSearch) {
        applySearchFilter(currentSearch);
      } else {
        updateSearchCount();
      }
    }

    // GRID EVENTS
    function attachGridEvents() {

      table.on("cellEdited", function(cell) {
        var field = cell.getField();
        if (field.indexOf('sa_') !== 0) return;

        var suffix    = field.replace('sa_', '');
        var isDefault = (suffix === 'default');
        var specAId   = isDefault ? null : parseInt(suffix);
        var row       = cell.getRow();
        var d         = row.getData();
        var rowId     = d.id;
        var key       = rowId + '_' + suffix;

        var origRow  = originalData[rowId] || {};
        var origVal  = parseFloat(origRow[field]) || 0;
        var newVal   = parseFloat(cell.getValue()) || 0;

        if (Math.abs(newVal - origVal) > 0.0001) {
          changedCells[key] = {
            product_id: rowId,
            prod_id:    d.prod_id,
            variant_id: d['vid_' + suffix],
            spec_a_id:  specAId,
            old_stock:  origVal,
            new_stock:  newVal,
          };
          cell.getElement().classList.add('dirty-cell');
        } else {
          delete changedCells[key];
          cell.getElement().classList.remove('dirty-cell');
        }
        updateStatus();
      });

      // ── Cell editing (keyboard nav) ────────────
      table.on("cellEditing", function(cell) {
        setTimeout(function() {
          var ed = cell.getElement().querySelector('input,textarea');
          if (!ed) return;
          try { ed.select(); } catch(e) {}

          ed.addEventListener('keydown', function(e) {
            if (e.key === 'Enter') {
              e.preventDefault();
              ed.blur();
              setTimeout(function() { moveEdit(cell, 'down'); }, 0);
              return;
            }
            if (e.key === 'ArrowUp' || e.key === 'ArrowDown' ||
                e.key === 'ArrowLeft' || e.key === 'ArrowRight') {
              e.preventDefault();
              var dir = e.key === 'ArrowLeft'  ? 'left'
                      : e.key === 'ArrowRight' ? 'right'
                      : e.key === 'ArrowUp'    ? 'up' : 'down';
              moveEdit(cell, dir);
            }
          });
        }, 0);
      });

      // ═══ Re-apply dirty after data filter changes ═══
      table.on("dataFiltered", function() {
        reapplyDirty();
        updateSearchCount();
      });
    }

    // KEYBOARD NAVIGATION
    function getEditFields() {
      if (!table) return [];
      return table.getColumns()
        .filter(function(c) { return c.isVisible() && c.getDefinition().editor; })
        .map(function(c) { return c.getField(); });
    }

    function focusCell(c) {
      if (!c) return;
      c.edit(true);
      setTimeout(function() {
        var inp = c.getElement().querySelector('input,textarea');
        if (inp) { inp.focus(); try { inp.select(); } catch(e){} }
      }, 0);
    }

    function moveEdit(cell, dir) {
      var row = cell.getRow(), f = cell.getField();
      var edFields = getEditFields();
      if (!edFields.length) return;

      if (dir === 'left' || dir === 'right') {
        var idx = edFields.indexOf(f);
        if (idx === -1) idx = 0;
        idx = dir === 'left' ? Math.max(0, idx - 1) : Math.min(edFields.length - 1, idx + 1);
        return focusCell(row.getCell(edFields[idx]));
      }
      var nr = dir === 'up' ? row.getPrevRow() : row.getNextRow();
      if (!nr) return;
      var tf = edFields.indexOf(f) >= 0 ? f : edFields[0];
      return focusCell(nr.getCell(tf));
    }

    // RE-APPLY DIRTY CLASS AFTER REBUILD
    function reapplyDirty() {
      if (!table) return;
      setTimeout(function() {
        Object.keys(changedCells).forEach(function(key) {
          var c     = changedCells[key];
          var row   = table.getRow(c.product_id);
          if (!row) return;
          var fname = c.spec_a_id ? ('sa_' + c.spec_a_id) : 'sa_default';
          var cell  = row.getCell(fname);
          if (cell) cell.getElement().classList.add('dirty-cell');
        });
      }, 80);
    }

    // STATUS
    function updateStatus() {
      changedCount = Object.keys(changedCells).length;
      document.getElementById('statusDot').classList.toggle('active', changedCount > 0);
      document.getElementById('statusText').innerHTML =
        changedCount ? '<b>' + changedCount + '</b> cell(s) changed' : 'No changes';
    }

    // ════════════════════════════════════════════════════════
    //  🔍 SEARCH FUNCTIONALITY (NEW)
    // ════════════════════════════════════════════════════════

    var searchInput    = document.getElementById('gridSearch');
    var searchClearBtn = document.getElementById('searchClearBtn');
    var searchTimer    = null;

    // Apply filter to Tabulator
    function applySearchFilter(term) {
      if (!table) return;

      term = term.toLowerCase().trim();

      if (!term) {
        // Clear all filters — show all rows
        table.clearFilter();
      } else {
        // Custom filter: match Code OR Name
        table.setFilter(function(data) {
          var code = (data.product_code || '').toString().toLowerCase();
          var name = (data.name || '').toString().toLowerCase();
          return code.indexOf(term) !== -1 || name.indexOf(term) !== -1;
        });
      }
    }

    // Update search result count display
    function updateSearchCount() {
      if (!table) {
        document.getElementById('searchCountText').textContent = 'Type to search...';
        return;
      }

      var term       = searchInput.value.trim();
      var totalRows  = currentData.length;
      var shownRows  = table.getDataCount("active");  // visible after filter

      var countText = document.getElementById('searchCountText');
      var countEl   = document.getElementById('searchResultCount');

      if (!term) {
        countText.innerHTML = '<span class="count-badge">' + totalRows + '</span> total products';
      } else {
        var badgeClass = shownRows < totalRows ? 'count-badge filtered' : 'count-badge';
        countText.innerHTML =
          '<span class="' + badgeClass + '">' + shownRows + '</span> of ' +
          totalRows + ' matched';
      }
    }

    // Search input — debounced keyup
    searchInput.addEventListener('input', function() {
      var term = this.value;

      // Show/hide clear button
      if (term.length > 0) {
        searchClearBtn.style.display = 'flex';
      } else {
        searchClearBtn.style.display = 'none';
      }

      // Debounce: wait 200ms after user stops typing
      clearTimeout(searchTimer);
      searchTimer = setTimeout(function() {
        applySearchFilter(term);
      }, 200);
    });

    // Clear button click
    searchClearBtn.addEventListener('click', function() {
      searchInput.value = '';
      searchClearBtn.style.display = 'none';
      applySearchFilter('');
      searchInput.focus();
    });

    // Keyboard shortcut: Ctrl+F to focus search (override browser find)
    document.addEventListener('keydown', function(e) {
      if ((e.ctrlKey || e.metaKey) && e.key === 'f') {
        e.preventDefault();
        searchInput.focus();
        searchInput.select();
      }
      // Escape to clear search
      if (e.key === 'Escape' && document.activeElement === searchInput) {
        searchInput.value = '';
        searchClearBtn.style.display = 'none';
        applySearchFilter('');
        searchInput.blur();
      }
    });

    // ════════════════════════════════════════════════════════
    //  END SEARCH FUNCTIONALITY
    // ════════════════════════════════════════════════════════

    // LOAD DATA
    function loadData() {
      var mode  = $('input[name="mode"]:checked').val();
      var limit = $('#limit').val() || 500;
      var q     = '';
      var saId  = '';

      if (mode === 'company') {
        var cd = $('#filter_company').select2('data');
        q = (cd && cd[0]) ? cd[0].text : '';
      } else if (mode === 'category') {
        var cd2 = $('#filter_category').select2('data');
        q = (cd2 && cd2[0]) ? cd2[0].text : '';
      }

      var sad = $('#filter_spec_a').select2('data');
      saId = (sad && sad[0]) ? sad[0].id : '';

      var showAll = $('#showAll').is(':checked') ? '1' : '0';

      var url = FETCH_URL +
        '?mode='      + encodeURIComponent(mode) +
        '&q='         + encodeURIComponent(q) +
        '&spec_a_id=' + encodeURIComponent(saId) +
        '&show_all='  + showAll +
        '&limit='     + encodeURIComponent(limit);

      showLoad('Loading...');

      $.getJSON(url, function(resp) {
        currentCols = resp.spec_a_cols || [];
        currentData = resp.rows || [];

        // Store original snapshot
        originalData = {};
        currentData.forEach(function(r) {
          originalData[r.id] = JSON.parse(JSON.stringify(r));
        });

        // Reset changes
        changedCells = {};
        updateStatus();

        // Rebuild table with new dynamic columns
        initTable();

        hideLoad();
        if (currentData.length) {
          toast('success', 'Loaded', currentData.length + ' products, ' + currentCols.length + ' Spec-A columns');
        } else if (!currentCols.length) {
          toast('warning', 'No Spec-A', 'No Spec-A terms found. Create them first.');
        } else {
          toast('info', 'No Results', 'No products found for the selected filters');
        }
      }).fail(function() {
        hideLoad();
        toast('error', 'Error', 'Failed to load data');
      });
    }

    // SAVE
    function saveData() {
      var keys = Object.keys(changedCells);
      if (!keys.length) {
        toast('info', 'No Changes', 'Nothing to save');
        return;
      }

      var changes = [];
      keys.forEach(function(key) {
        var c = changedCells[key];
        if (Math.abs(c.new_stock - c.old_stock) > 0.0001) {
          changes.push({
            product_id: c.product_id,
            prod_id:    c.prod_id,
            variant_id: c.variant_id,
            spec_a_id:  c.spec_a_id,
            old_stock:  c.old_stock,
            new_stock:  c.new_stock,
          });
        }
      });

      if (!changes.length) {
        toast('info', 'No Changes', 'Nothing to save');
        return;
      }

      if (!confirm('Save ' + changes.length + ' stock change(s)?')) return;

      showLoad('Saving ' + changes.length + ' change(s)...');

      fetch(SAVE_URL, {
        method: 'POST',
        headers: {'Content-Type': 'application/json', 'X-CSRFToken': CSRF},
        body: JSON.stringify({changes: changes}),
      })
      .then(function(r) { return r.json(); })
      .then(function(res) {
        hideLoad();
        var results = res.results || [];
        var ok   = results.filter(function(r) { return r.ok; }).length;
        var fail = results.filter(function(r) { return !r.ok; });

        if (ok)          toast('success', 'Saved', ok + ' change(s) saved successfully');
        if (fail.length) {
          var msgs = fail.map(function(f) { return f.msg || 'unknown'; }).join(', ');
          toast('error', 'Failed', fail.length + ' change(s) failed: ' + msgs, 6000);
        }

        // Refresh data
        loadData();
      })
      .catch(function(err) {
        hideLoad();
        toast('error', 'Error', 'Save failed — check console');
        console.error(err);
      });
    }

    // BUTTON BINDINGS
    document.getElementById('btnLoad').addEventListener('click', function() {
      if (changedCount > 0 && !confirm('You have unsaved changes. Load new data?')) return;
      loadData();
    });

    document.getElementById('btnSave').addEventListener('click', saveData);

    document.getElementById('btnDiscard').addEventListener('click', function() {
      if (changedCount > 0 && !confirm('Discard all changes?')) return;
      changedCells = {};
      updateStatus();
      loadData();
      toast('info', 'Discarded', 'Changes discarded');
    });

    document.getElementById('btnRefresh').addEventListener('click', function() {
      if (changedCount > 0 && !confirm('Unsaved changes will be lost. Refresh?')) return;
      loadData();
    });

    initTable();      // empty table first
    loadData();       // auto-load

  })();
  </script>
{% endblock %}