{# valor por defecto; Jumpseller lo expone en paged.per_page #}

<style>
  :root{
    --bg:#ffffff; --card:#fff; --muted:#6b7280; --fg:#0a0a0a;
    --accent:#d4af37; --accent-2:#c9a227; --ring:rgba(212,175,55,.35); --line:#ececec;
  }
  .ym-wrap{max-width:1220px;margin:0 auto;padding:20px;color:var(--fg);background:#fff}
  .ym-hero{display:grid;grid-template-columns:1fr 1fr;gap:28px;align-items:center;min-height:62vh}
  .ym-card{background:var(--card);border-radius:16px;padding:18px;box-shadow:0 6px 20px rgba(0,0,0,.06);border:1px solid var(--line)}
  .ym-title{font-weight:800;margin:0 0 6px;font-size:clamp(26px,3.6vw,38px)}
  .ym-sub{color:var(--muted);margin:0 0 12px}
  .ym-btn,.ym-actions a{display:inline-block;background:var(--accent);color:#111;text-decoration:none;font-weight:700;padding:10px 14px;border-radius:12px;border:1px solid #b69121;cursor:pointer}
  .ym-btn.secondary{background:#fff;border-color:var(--line)}
  .ym-badge{display:inline-flex;gap:8px;align-items:center;background:#fff7e0;color:#7a5b00;border:1px solid #f3e3a3;padding:6px 10px;border-radius:999px;font-size:12px}

  .ym-grid{display:grid;grid-template-columns:280px 1fr;gap:16px}
  .ym-panel{background:#fff;border:1px solid var(--line);border-radius:14px;padding:14px;margin-bottom:14px}
  .ym-panel h3{margin:0 0 10px;font-size:16px}
  .ym-filter label{display:block;font-size:12px;color:var(--muted);margin:10px 0 6px}
  .ym-filter input,.ym-filter select{width:100%;background:#fff;color:#111;border:1px solid var(--line);border-radius:10px;padding:10px}
  .filebox{display:flex;gap:8px;align-items:center}
  .filebox input[type=file]{display:none}
  .filebox label{background:#fff;border:1px solid var(--line);padding:9px 12px;border-radius:10px;cursor:pointer}

  .ym-table{width:100%;border-collapse:separate;border-spacing:0 10px;table-layout:fixed}
  .ym-thead th{font-size:12px;color:#6b7280;text-align:left;padding:0 8px}
  .ym-row{background:#fff;border:1px solid var(--line);border-radius:12px}
  .ym-row td{padding:14px 12px;vertical-align:middle}
  .ym-row img{width:56px;height:56px;object-fit:cover;border-radius:10px;border:1px solid var(--line)}
  .stock-chip{font-size:12px;border-radius:999px;padding:4px 10px;background:#fff7e0;color:#7a5b00;border:1px solid #f3e3a3}
  .qty{width:120px}
  .qty input,.obs input{width:100%;background:#fff;border:1px solid var(--line);border-radius:10px;padding:10px}
  .obs{min-width:260px}

  .ym-stickybar{position:sticky;bottom:16px;z-index:30;background:linear-gradient(180deg, rgba(255,255,255,0) 0%, rgba(255,255,255,.9) 50%, #fff 100%);padding-top:6px}
  .ym-sum{background:#fff;border:1px solid var(--line);border-radius:14px;display:flex;align-items:center;justify-content:space-between;padding:10px 12px}
  .pill{background:#fff7e0;border:1px solid #f3e3a3;color:#7a5b00;padding:6px 10px;border-radius:999px;font-size:12px}
  .note{font-size:12px;color:var(--muted)}

  .ym-pager{display:flex;gap:6px;align-items:center;justify-content:flex-end;flex-wrap:wrap}
  .ym-page{display:inline-flex;min-width:36px;justify-content:center;align-items:center;height:36px;border:1px solid var(--line);border-radius:10px;background:#fff;color:#111;text-decoration:none;font-weight:600;padding:0 10px;cursor:pointer}
  .ym-page.current{background:var(--accent);border-color:#b69121}
  .ym-page.disabled{opacity:.45;pointer-events:none}

  .pp-overlay{position:fixed;inset:0;background:rgba(255,255,255,.65);backdrop-filter:blur(2px);display:none;align-items:center;justify-content:center;z-index:50}
  .pp-overlay .pill{font-weight:700}

  @media(max-width:980px){
    .ym-grid{grid-template-columns:1fr}
    .obs{min-width:180px}
  }
</style>

<div class="ym-wrap">

  <!-- GATE -->
  <section id="auth-gate" class="ym-hero" style="display:none">
    <div>
      <span class="ym-badge">Acceso Mayorista</span>
      <h1 class="ym-title">Premium Perfumes Mayorista</h1>
      <p class="ym-sub">Ingresa la clave mayorista para ver el catálogo con stock y enviar tu solicitud de pedido.</p>
      <div class="ym-card" style="padding:16px;max-width:460px">
        <label for="pp-pass" style="display:block;margin-bottom:6px;color:var(--muted)">Clave mayorista</label>
        <input id="pp-pass" type="password" placeholder="Ingresa tu clave" style="width:100%;">
        <button id="pp-unlock" class="ym-btn" style="margin-top:10px;width:100%">Ingresar</button>
        <p class="note" style="margin-top:8px">¿Olvidaste la clave? Escríbenos a ventaspremiumperfumes@gmail.com.</p>
      </div>
    </div>
    <div class="ym-card">
      <img src="https://images.unsplash.com/photo-1606800052052-a08af7148866?q=80&w=1200&auto=format&fit=crop" alt="logística" style="width:100%;border-radius:12px">
    </div>
  </section>

  <!-- PORTAL -->
  <div class="ym-grid" id="pp-portal" style="display:none">

    <!-- Filtros / Excel -->
    <aside class="ym-panel">
      <h3>Filtros</h3>
      <div class="ym-filter">
        <label>Buscar en todo el catálogo</label>
        <input id="f-q" type="text" placeholder="Ej: Yara Pink 100ml o ABC123" />
        <small class="note">Pulsa Enter para buscar globalmente.</small>

        <label style="margin-top:12px">Marca (brand / tag)</label>
        <select id="f-brand">
          <option value="">Todas</option>
          
            
          
          
          <option value=" Ayelet Habibati "> Ayelet Habibati </option><option value="Armaf">Armaf</option><option value="Fragance World">Fragance World</option><option value="Fragrance World ">Fragrance World </option><option value="LATAFFA">LATAFFA</option><option value="Lataffa">Lataffa</option><option value="Lattafa">Lattafa</option><option value="Maison Alhambra">Maison Alhambra</option><option value="Paris Corner">Paris Corner</option><option value="Rave">Rave</option><option value="Riiffs ">Riiffs </option><option value="Risala">Risala</option><option value="Risala ">Risala </option><option value="Zak ">Zak </option>
        </select>

        <hr style="border-color:#f1f1f1;margin:14px 0">
        <h3>Cargar Excel</h3>
        <p class="note">Columnas: <b>SKU</b>, <b>CANTIDAD</b>, <b>OBSERVACION</b>.</p>
        <div class="filebox">
          <input id="xls-file" type="file" accept=".xlsx,.xls,.csv" />
          <label for="xls-file">Elegir archivo</label>
          <button class="ym-btn secondary" id="btn-xls-load" type="button">Cargar</button>
        </div>
      </div>
    </aside>

    <!-- Catálogo -->
    <main>
      <div class="ym-panel" style="margin-bottom:10px">
        <div style="display:flex;justify-content:space-between;align-items:center;gap:10px;flex-wrap:wrap">
          <div class="ym-badge">
            <span>Premium Perfumes Mayorista</span>
            <span class="pill" id="pill-count">0 seleccionados</span>
          </div>
        </div>
      </div>

      <div class="ym-panel">
        <table class="ym-table">
          <thead class="ym-thead">
            <tr>
              <th>Producto</th>
              <th>SKU</th>
              <th>Stock</th>
              <th class="qty">Cantidad</th>
              <th class="obs">Observación</th>
            </tr>
          </thead>

          <tbody id="ym-body">
          
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            
              
              
              
            

            <tr id="pager-row"><td colspan="5">
              <div style="display:flex;justify-content:space-between;align-items:center;gap:10px;flex-wrap:wrap">
                <div class="note">Página 32 de 32 · 1266 productos</div>
                <nav class="ym-pager" id="srv-pager">
                  <ul class="pager"><li class="first jump"><a href="/yara-ard-el-zaafaran-50ml-mujer?page=1">Primero</a></li><li class="previous jump" rel="prev"><a href="/yara-ard-el-zaafaran-50ml-mujer?page=31"><span title=Anterior>&laquo;</span></a></li><li class="more">...</li><li class="page-28"><a href="/yara-ard-el-zaafaran-50ml-mujer?page=28">28</a></li><li class="page-29"><a href="/yara-ard-el-zaafaran-50ml-mujer?page=29">29</a></li><li class="page-30"><a href="/yara-ard-el-zaafaran-50ml-mujer?page=30">30</a></li><li class="page-31"><a href="/yara-ard-el-zaafaran-50ml-mujer?page=31">31</a></li><li class="page-32 active"><a href="/yara-ard-el-zaafaran-50ml-mujer?page=32">32</a></li></ul>
                </nav>
              </div>
            </td></tr>
          
          </tbody>
        </table>

        <div class="ym-stickybar">
          <div class="ym-sum">
            <div>
              <b>Total ítems:</b> <span id="sum-count">0</span>
              <small class="pill" id="sum-skus">0 SKUs</small>
            </div>
            <div class="ym-footer">
              <button class="ym-btn secondary" id="btn-email" type="button">Enviar como solicitud</button>
            </div>
          </div>
        </div>
      </div>

      <div class="ym-panel" style="margin-top:10px">
        <h3>Datos de Facturación</h3>
        <p class="note">Estos datos se enviarán en la solicitud por correo.</p>
        <div class="ym-grid" style="grid-template-columns:repeat(3,1fr)">
          <div><label>Razón Social</label><input id="bill-razon" type="text" class="inp" placeholder="Ej: Premium Spa"></div>
          <div><label>RUT</label><input id="bill-rut" type="text" class="inp" placeholder="77.545.005-4"></div>
          <div><label>Comuna</label><input id="bill-comuna" type="text" class="inp"></div>
          <div><label>Dirección</label><input id="bill-dir" type="text" class="inp"></div>
          <div><label>Teléfono</label><input id="bill-tel" type="text" class="inp"></div>
          <div><label>Email</label><input id="bill-mail" type="email" class="inp" value=""></div>
        </div>
      </div>

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

<div class="pp-overlay" id="pp-loader"><span class="pill">Cargando…</span></div>

<!-- SheetJS -->
<script src="https://cdn.jsdelivr.net/npm/xlsx@0.18.5/dist/xlsx.full.min.js"></script><script>
window.__PP_META__ = {
  per: 40,
  cur: 1,
  total: 1,
  total_products: 0
};
</script>

<script>
(function(){
  // ====== GATE ROBUSTO ======
  function getCookie(name){ return (document.cookie.split('; ').find(r=>r.startsWith(name+'='))||'').split('=')[1]||''; }
  function setCookie(name,val,days){
    var max = '; max-age=' + (days*24*60*60);
    document.cookie = name + '=' + val + max + '; path=/';
  }
  function qs(name){ try{ return new URL(location.href).searchParams.get(name)||''; }catch(e){ return ''; } }
  var PASS = 'PPMAYORISTA2025'; // <<< CAMBIA AQUÍ
  var fromUrl = qs('key');
  if(fromUrl && fromUrl === PASS){
    setCookie('wholesale_ok','1',30);
    history.replaceState({},'',location.pathname + location.search.replace(/([?&])key=[^&]+&?/,'$1').replace(/[?&]$/,''));
  }
  var ok = getCookie('wholesale_ok')==='1';
  var gate = document.getElementById('auth-gate');
  var portal = document.getElementById('pp-portal');
  function showPortal(){ portal.style.display=''; gate.style.display='none'; }
  function showGate(){ gate.style.display=''; portal.style.display='none'; }
  if(ok) showPortal(); else showGate();
  document.getElementById('pp-unlock')?.addEventListener('click', ()=>{
    var v = document.getElementById('pp-pass').value.trim();
    if(v===PASS){ setCookie('wholesale_ok','1',30); showPortal(); } else { alert('Clave incorrecta'); }
  });
  document.getElementById('pp-pass')?.addEventListener('keydown',e=>{
    if(e.key==='Enter'){ e.preventDefault(); document.getElementById('pp-unlock').click(); }
  });

  if(!portal || portal.style.display==='none') return;

  // ====== META DEL SERVIDOR ======
  let META = window.__PP_META__ || { per: 40, cur: 1, total: 1 };

  // ====== Helpers ======
  const $ = (s,el=document)=>el.querySelector(s);
  const $$ = (s,el=document)=>Array.from(el.querySelectorAll(s));
  const body = $('#ym-body'); const pill = $('#pill-count'); const sumCount = $('#sum-count'); const sumSkus = $('#sum-skus');
  const q = $('#f-q'); const fBrand = $('#f-brand');
  const loader = $('#pp-loader');

  function spinner(on){ loader.style.display = on ? 'flex' : 'none'; }

  // ====== Estado selección (persiste por SKU) ======
  const LS_KEY = 'PP_SELS';
  function readSels(){ try{ return JSON.parse(localStorage.getItem(LS_KEY)||'{}'); }catch(e){ return {}; } }
  function writeSels(m){ localStorage.setItem(LS_KEY, JSON.stringify(m)); }
  function applySelsToRow(tr){
    const sku = tr.dataset.sku; const sels = readSels();
    if(sku && sels[sku]){
      const {qty,obs} = sels[sku];
      if(tr.querySelector('.inp-qty')) tr.querySelector('.inp-qty').value = qty||0;
      if(tr.querySelector('.inp-obs') && obs) tr.querySelector('.inp-obs').value = obs;
    }
  }

  // ====== Agregador AJAX (paginación virtual) ======
  const AGG = {
    key: null,
    rowsPer: META.per || 40,           // Tamaño de página REAL del servidor
    serverTotalPages: META.total,
    fetched: new Set(),                // páginas servidor ya procesadas
    pos: [],                           // filas stock > 0
    zero: []                           // filas stock = 0
  };

  function baseKeyFromUrl(url){
    const u = new URL(url, location.origin);
    u.searchParams.delete('page');
    return u.pathname + (u.searchParams.toString() ? ('?' + u.searchParams.toString()) : '');
  }

  function resetAggFor(url){
    AGG.key = baseKeyFromUrl(url);
    AGG.serverTotalPages = META.total;
    AGG.rowsPer = META.per || 40;      // Fijamos per_page del servidor (no se toca)
    AGG.fetched.clear(); AGG.pos.length=0; AGG.zero.length=0;
  }

  function rowToObj(tr){
    return {
      html: tr.outerHTML,
      name: (tr.dataset.name||'').toLowerCase(),
      sku: (tr.dataset.sku||'').toLowerCase(),
      brand: (tr.dataset.brand||'').toLowerCase(),
      stock: parseInt(tr.dataset.stock||'0',10)
    };
  }

  function indexCurrentRows(){
    $$('.ym-row', body).forEach(tr=>{
      const o = rowToObj(tr);
      if(o.stock>0) AGG.pos.push(o); else AGG.zero.push(o);
    });
  }

  // Paginador servidor -> URLs
  function serverPageUrl(n){
    const base = new URL(location.href);
    base.searchParams.set('page', String(n));
    return base.toString();
  }

  async function fetchPage(n){
    if(AGG.fetched.has(n)) return;
    AGG.fetched.add(n);
    try{
      const res = await fetch(serverPageUrl(n), {credentials:'same-origin'});
      const html = await res.text();
      const dom = new DOMParser().parseFromString(html, 'text/html');
      // Actualizamos META de esa respuesta
      try{
        const scr = dom.querySelector('script');
        // buscamos window.__PP_META__ dentro de todos los scripts:
        dom.querySelectorAll('script').forEach(sc=>{
          if(sc.textContent.includes('window.__PP_META__')){
            const m = sc.textContent.match(/__PP_META__\s*=\s*({[\s\S]*?});/);
            if(m){ META = Object.assign(META, JSON.parse(m[1])); }
          }
        });
      }catch(e){}
      dom.querySelectorAll('#ym-body .ym-row').forEach(tr=>{
        const o = rowToObj(tr);
        if(o.stock>0) AGG.pos.push(o); else AGG.zero.push(o);
      });
    }catch(e){ console.error('Fetch page error', e); }
  }

  function rebuildPager(current,total){
    const nav = $('#srv-pager');
    if(!nav) return;
    const frag = document.createDocumentFragment();
    function mk(label, n, disabled, current){
      const a = document.createElement('a');
      a.className = 'ym-page' + (current?' current':'') + (disabled?' disabled':'');
      a.textContent = label;
      if(!disabled && !current){
        a.href = '#';
        a.addEventListener('click', (ev)=>{ ev.preventDefault(); go(n); });
      }
      return a;
    }
    // Primero
    frag.appendChild(mk('Primero',1,current===1,false));
    // Números
    const windowSize = 5;
    const start = Math.max(1, current - 2);
    const end = Math.min(total, start + windowSize - 1);
    for(let i=start;i<=end;i++) frag.appendChild(mk(String(i),i,false, i===current));
    if(end<total-1){ const span=document.createElement('span'); span.className='ym-page disabled'; span.textContent='…'; frag.appendChild(span); }
    if(end<total) frag.appendChild(mk(String(total), total, false, current===total));
    // Último
    frag.appendChild(mk('Último', total, current===total, false));
    nav.innerHTML = '';
    nav.appendChild(frag);
  }

  function renderPage(page){
    // Lista global: primero stock>0 y luego stock=0
    const all = AGG.pos.concat(AGG.zero);
    const start = (page-1)*AGG.rowsPer;
    const end = start + AGG.rowsPer;
    const slice = all.slice(start, end);

    // Construimos tbody
    const rowsHtml = slice.map(o=>o.html).join('');
    const pager = $('#pager-row', body);
    const before = body.innerHTML;
    body.innerHTML = rowsHtml + (pager ? pager.outerHTML : '');
    // Re-aplicamos selección guardada
    $$('.ym-row', body).forEach(applySelsToRow);
    // Reparar eventos de inputs
    attachInputsHandlers();
    // Recalcular sumas
    recalc();
    // Pager virtual (usa total virtual: ceil(all/rowsPer))
    const totalPages = Math.max(1, Math.ceil(all.length / AGG.rowsPer));
    rebuildPager(page, totalPages);
  }

  // Garantiza tener suficientes filas agregadas para cubrir la página pedida
  async function ensureFor(page){
    const need = page * AGG.rowsPer;
    const have = AGG.pos.length + AGG.zero.length;
    if(have >= need) return;
    spinner(true);
    // Traemos páginas del servidor hasta cubrir
    const toFetch = [];
    for(let i=1;i<=AGG.serverTotalPages;i++){
      if(!AGG.fetched.has(i)) toFetch.push(i);
      if(AGG.pos.length + AGG.zero.length >= need) break;
    }
    // Concurrencia 4
    const CONC = 4;
    for(let i=0;i<toFetch.length;i+=CONC){
      await Promise.all(toFetch.slice(i,i+CONC).map(n=>fetchPage(n)));
      if(AGG.pos.length + AGG.zero.length >= need) break;
    }
    spinner(false);
  }

  async function go(page){
    await ensureFor(page);
    renderPage(page);
    CURRENT.page = page;
  }

  // ====== Búsqueda global (por nombre o SKU) ======
  const SEARCH = { active:false, rows:[] };
  async function buildFullIndex(){
    // Cargar TODO el catálogo antes de buscar
    const need = AGG.serverTotalPages;
    spinner(true);
    const toFetch = [];
    for(let i=1;i<=need;i++){ if(!AGG.fetched.has(i)) toFetch.push(i); }
    const CONC = 5;
    for(let i=0;i<toFetch.length;i+=CONC){ await Promise.all(toFetch.slice(i,i+CONC).map(n=>fetchPage(n))); }
    spinner(false);
  }
  async function doSearch(term){
    const t = term.toLowerCase().trim();
    if(!t){ SEARCH.active=false; CURRENT.page=1; return go(1); }
    await buildFullIndex();
    const all = AGG.pos.concat(AGG.zero);
    SEARCH.rows = all.filter(o=> o.name.includes(t) || o.sku.includes(t) );
    SEARCH.active = true;
    // Mostrar resultados (sin stock0 al final? mantenemos orden: pos luego zero ya viene así)
    const pager = $('#srv-pager'); if(pager) pager.innerHTML='';
    const rowsHtml = SEARCH.rows.slice(0, AGG.rowsPer).map(o=>o.html).join('');
    const pagerRow = $('#pager-row', body);
    body.innerHTML = rowsHtml + (pagerRow ? pagerRow.outerHTML : '');
    attachInputsHandlers(); recalc();
    rebuildPager(1, Math.max(1, Math.ceil(SEARCH.rows.length / AGG.rowsPer)));
    CURRENT.page = 1;
  }
  async function goSearchPage(page){
    const start = (page-1)*AGG.rowsPer;
    const end = start + AGG.rowsPer;
    const rowsHtml = SEARCH.rows.slice(start, end).map(o=>o.html).join('');
    const pagerRow = $('#pager-row', body);
    body.innerHTML = rowsHtml + (pagerRow ? pagerRow.outerHTML : '');
    attachInputsHandlers(); recalc();
    rebuildPager(page, Math.max(1, Math.ceil(SEARCH.rows.length / AGG.rowsPer)));
    CURRENT.page = page;
  }

  // Interceptamos clicks del pager cuando estamos buscando
  $('#srv-pager')?.addEventListener('click', (ev)=>{
    const a = ev.target.closest('a.ym-page'); if(!a) return;
    if(SEARCH.active){
      ev.preventDefault();
      const n = parseInt(a.textContent.trim(),10);
      if(!isNaN(n)) goSearchPage(n);
    }
  });

  // ====== Inicialización agregador y eventos ======
  const CURRENT = { page: META.cur || 1 };

  resetAggFor(location.href);
  // Marcamos la página actual como ya indexada
  AGG.fetched.add(CURRENT.page);
  indexCurrentRows();

  // Pre-calentamos 2 páginas siguientes si existen
  (async function warmup(){
    const n1 = CURRENT.page+1, n2 = CURRENT.page+2;
    const todo = [];
    if(n1<=AGG.serverTotalPages) todo.push(fetchPage(n1));
    if(n2<=AGG.serverTotalPages) todo.push(fetchPage(n2));
    if(todo.length) await Promise.all(todo);
  })();

  // Re-render inicial para respetar orden (stock>0 luego stock=0)
  renderPage(CURRENT.page);

  // Paginación AJAX
  $('#srv-pager')?.querySelectorAll('a').forEach(a=>{
    a.addEventListener('click', (ev)=>{
      ev.preventDefault();
      const t = a.textContent.trim();
      let n = parseInt(t,10);
      if(isNaN(n)){
        if(/Primero/i.test(t)) n = 1;
        else if(/Último/i.test(t)) n = Math.max(1, Math.ceil((AGG.pos.length+AGG.zero.length)/AGG.rowsPer));
      }
      if(n) go(n);
    });
  });

  // Filtros instantáneos (marca en la vista actual)
  function applyFiltersLocal(){
    const term = ''; // se maneja por búsqueda global
    const brand = fBrand?.value||'';
    $$('.ym-row', body).forEach(tr=>{
      const brands = (tr.dataset.brand||'');
      tr.style.display = (!brand || brands.split('|').includes(brand)) ? '' : 'none';
    });
  }
  fBrand?.addEventListener('change', applyFiltersLocal);

  // Buscador global por Enter
  q?.addEventListener('keydown', ev=>{
    if(ev.key==='Enter'){ ev.preventDefault(); doSearch(q.value||''); }
    if(ev.key==='Escape'){ q.value=''; SEARCH.active=false; go(1); }
  });

  // ====== Recuento / selección persistente ======
  function recalc(){
    const rows = $$('.inp-qty', body);
    let total = 0; let skus = 0;
    rows.forEach(inp=>{
      const n = parseInt(inp.value||'0',10); if(n>0){ total += n; skus++; }
    });
    pill.textContent = `${skus} seleccionados`; sumCount.textContent = total; sumSkus.textContent = `${skus} SKUs`;
  }
  function attachInputsHandlers(){
    body.addEventListener('input', onInput, {once:true}); // asegurar 1 solo handler por render
    $$('.ym-row', body).forEach(applySelsToRow);
  }
  function onInput(e){
    if(e.target.classList.contains('inp-qty') || e.target.classList.contains('inp-obs')){
      const tr = e.target.closest('.ym-row'); if(!tr) return;
      const sku = tr.dataset.sku;
      const qty = parseInt(tr.querySelector('.inp-qty').value||'0',10) || 0;
      const obs = tr.querySelector('.inp-obs').value||'';
      const sels = readSels();
      if(qty>0 || obs){ sels[sku] = {qty, obs}; } else { delete sels[sku]; }
      writeSels(sels);
      recalc();
    }
    // volviendo a escuchar tras primera activación
    body.addEventListener('input', onInput, {once:true});
  }

  // ====== Excel ======
  $('#btn-xls-load')?.addEventListener('click', async ()=>{
    const file = $('#xls-file').files[0];
    if(!file){ alert('Selecciona un archivo primero'); return; }
    const data = await file.arrayBuffer();
    const wb = XLSX.read(data, {type:'array'}); const ws = wb.Sheets[wb.SheetNames[0]];
    const rows = XLSX.utils.sheet_to_json(ws, {header:1});
    const headers = rows[0].map(h=>String(h).trim().toUpperCase());
    const iSku = headers.indexOf('SKU'); const iQty = headers.indexOf('CANTIDAD'); const iObs = headers.indexOf('OBSERVACION');
    if(iSku<0 || iQty<0){ alert('El Excel debe tener columnas SKU y CANTIDAD. OBSERVACION es opcional.'); return; }
    const map = {}; rows.slice(1).forEach(r=>{
      const sku = String(r[iSku]||'').trim(); if(!sku) return;
      const qty = parseInt(r[iQty]||'0',10)|0; const obs = iObs>=0 ? String(r[iObs]||'').trim() : '';
      map[sku] = {qty, obs};
    });
    const sels = readSels();
    Object.keys(map).forEach(sku=>{ sels[sku] = {qty:map[sku].qty, obs:map[sku].obs}; });
    writeSels(sels);
    // Aplicar en DOM actual
    $$('.ym-row', body).forEach(tr=>{
      const sku = tr.dataset.sku;
      if(map[sku]){
        tr.querySelector('.inp-qty').value = map[sku].qty;
        const ob = tr.querySelector('.inp-obs'); if(map[sku].obs) ob.value = map[sku].obs;
      }
    });
    recalc(); alert('Excel cargado. Revisa las cantidades aplicadas.');
  });

  // ====== Email ======
  $('#btn-email')?.addEventListener('click', ()=>{
    const sels = readSels();
    const skus = Object.keys(sels).filter(s=> (sels[s].qty||0)>0 );
    if(!skus.length){ alert('No has seleccionado cantidades.'); return; }
    const bill = {
      razon: $('#bill-razon')?.value.trim()||'',
      rut: $('#bill-rut')?.value.trim()||'',
      comuna: $('#bill-comuna')?.value.trim()||'',
      dir: $('#bill-dir')?.value.trim()||'',
      tel: $('#bill-tel')?.value.trim()||'',
      mail: $('#bill-mail')?.value.trim()||''
    };
    let bodyMail = 'SOLICITUD DE PEDIDO MAYORISTA%0D%0A%0D%0A';
    bodyMail += `Razón Social: ${encodeURIComponent(bill.razon)}%0D%0A`;
    bodyMail += `RUT: ${encodeURIComponent(bill.rut)}%0D%0A`;
    bodyMail += `Dirección: ${encodeURIComponent(bill.dir)}%0D%0A`;
    bodyMail += `Comuna: ${encodeURIComponent(bill.comuna)}%0D%0A`;
    bodyMail += `Teléfono: ${encodeURIComponent(bill.tel)}%0D%0A`;
    bodyMail += `Email: ${encodeURIComponent(bill.mail)}%0D%0A%0D%0A`;
    bodyMail += 'Productos:%0D%0A';
    // Generamos líneas desde el índice agregado si existe, sino con SKU a secas
    const idx = {};
    AGG.pos.concat(AGG.zero).forEach(o=> idx[o.sku] = o );
    skus.forEach(sku=>{
      const sel = sels[sku];
      const name = idx[sku]?.name || sku;
      bodyMail += `- ${encodeURIComponent(name)} | SKU ${encodeURIComponent(sku)} | Cant ${sel.qty} | Obs: ${encodeURIComponent(sel.obs||'')}%0D%0A`;
    });
    const subject = encodeURIComponent('Solicitud de Pedido Mayorista');
    const to = encodeURIComponent('ventaspremiumperfumes@gmail.com');
    window.location.href = `mailto:${to}?subject=${subject}&body=${bodyMail}`;
  });

})();
</script>
<meta name="csrf-param" content="authenticity_token" />
<meta name="csrf-token" content="PVV4B3G4FXWhfsksw81XekAwkM9qmLWTKout7tbIRjCw2X95FKpBNGl4cSvcaCS_dycPBwqZxusXAhgUyrE40w" />
<script src="https://files.jumpseller.com/javascripts/dist/jumpseller-2.0.0.js" defer="defer"></script>