(() => {
  const categories = [
    { id: 'cost', name: '自家成本' },
    { id: 'retail', name: '售价价格' },
    { id: 'dealer', name: '经销商价格' }
  ];
  const token = () => window.__manyiToken || '';
  const escapeHtml = (value) => String(value ?? '').replace(/[&<>"']/g, (character) => ({
    '&': '&amp;', '<': '&lt;', '>': '&gt;', '"': '&quot;', "'": '&#39;'
  }[character]));
  const api = (url, options = {}) => fetch(url, {
    ...options,
    headers: { Authorization: `Bearer ${token()}`, ...(options.headers || {}) }
  }).then(async (response) => {
    const body = await response.json();
    if (!response.ok) throw new Error(body.error || '操作失败');
    return body;
  });

  const init = () => {
    const card = document.querySelector('#files .card');
    if (!card || document.getElementById('priceLibrary')) return;
    const isAdmin = window.__manyiUser?.role === '管理员';
    const visibleCategories = isAdmin ? categories : categories.filter((item) => item.id === 'retail');
    const box = document.createElement('section');
    box.id = 'priceLibrary';
    box.innerHTML = `<h3>价格资料</h3><p class="muted">各类价格独立保存和索引，敏感价格仅管理员可见。</p><div class="price-tabs">${visibleCategories.map((item, index) => `<button class="btn price-tab ${index ? 'secondary' : ''}" data-category="${item.id}">${item.name}</button>`).join('')}</div><div id="pricePanel"></div><section class="order-query-files"><h3>单号查询员保存的文件</h3><p class="muted">按收录日期整理到文件夹，点击日期可展开当天的表格。</p><div class="order-query-toolbar"><input class="input order-query-search" placeholder="搜索文件名"><button class="btn secondary order-query-search-button">查询</button>${isAdmin ? '<input type="file" class="order-query-input" accept=".xls,.xlsx,.csv,.tsv" multiple><span class="order-query-upload-status muted">可一次上传多个表格</span>' : ''}</div><div class="order-query-file-list"><p class="muted">正在加载…</p></div></section>`;
    card.appendChild(box);
    const priceStyle = document.createElement('style');
    priceStyle.textContent = '#priceLibrary .price-files{margin-top:12px}#priceLibrary .price-file{display:flex;align-items:center;justify-content:space-between;gap:12px;padding:9px 0;border-bottom:1px solid #edf1f5}#priceLibrary .price-file>span{min-width:0;word-break:break-word}#priceLibrary .price-delete{width:32px;height:32px;flex:none;padding:0;font-size:20px;line-height:1}.order-query-files{margin-top:26px;padding-top:18px;border-top:1px solid #e1e7ee}.order-query-toolbar{display:flex;align-items:center;flex-wrap:wrap;gap:8px;margin:12px 0}.order-query-toolbar .input{margin:0;max-width:360px}.order-query-upload-status{font-size:12px}.order-query-folder{margin:16px 0}.order-query-folder summary{display:flex;justify-content:space-between;align-items:center;cursor:pointer;padding:8px 0;color:#506275;font-weight:700;border-bottom:1px solid #dfe7ee}.order-query-folder summary small{color:#8794a1;font-weight:400}.order-query-file{display:flex;align-items:center;justify-content:space-between;gap:12px;padding:10px 0;border-bottom:1px solid #edf1f5}.order-query-file small{display:block;color:#788696;margin-top:3px}.order-query-file a{color:#2f78df;text-decoration:none;white-space:nowrap}.order-query-file-actions{display:flex;align-items:center;gap:10px;white-space:nowrap}.order-query-delete{border:0;background:transparent;color:#b94343;font-size:20px;line-height:1;cursor:pointer;padding:0}';
    document.head.appendChild(priceStyle);

    const panel = box.querySelector('#pricePanel');
    const orderFileList = box.querySelector('.order-query-file-list');
    const loadOrderFiles = async (query = '') => {
      try {
        const result = await api(`/api/order-query/files?q=${encodeURIComponent(query)}`);
        const folders = result.folders || [{ date: null, items: result.items || [] }];
        const renderFile = (file) => `<div class="order-query-file"><span><b>${escapeHtml(file.fileName)}</b><small>${file.records} 条记录 · ${escapeHtml(file.sheetSummary || file.sheets.join('、'))} · ${formatFileSize(file.size)} · ${new Date(file.modifiedAt).toLocaleString()}</small></span><span class="order-query-file-actions"><a href="${file.downloadUrl}" target="_blank" rel="noreferrer">打开</a>${isAdmin ? `<button class="order-query-delete" data-order-delete="${escapeHtml(file.id)}" data-order-file-name="${escapeHtml(file.fileName)}" title="删除此文件" aria-label="删除 ${escapeHtml(file.fileName)}">×</button>` : ''}</span></div>`;
        orderFileList.innerHTML = result.items.length ? folders.map((folder, index) => `<details class="order-query-folder" ${index === 0 ? 'open' : ''}><summary>${escapeHtml(folder.date || '日期未记录')}<small>${folder.items.length} 个文件</small></summary>${folder.items.map(renderFile).join('')}</details>`).join('') : '<p class="muted">暂无单号查询员保存的文件</p>';
        orderFileList.querySelectorAll('[data-order-delete]').forEach((button) => button.onclick = async () => {
          if (!confirm(`确定删除“${button.dataset.orderFileName}”？本地文件和查询索引会同步删除。`)) return;
          try { await api(`/api/order-query/files/${button.dataset.orderDelete}`, { method: 'DELETE' }); await loadOrderFiles(box.querySelector('.order-query-search').value.trim()); }
          catch (error) { alert(error.message); }
        });
      } catch (error) { orderFileList.innerHTML = `<p class="muted">${escapeHtml(error.message)}</p>`; }
    };
    const formatFileSize = (bytes) => Number(bytes || 0) < 1048576 ? `${(Number(bytes || 0) / 1024).toFixed(1)} KB` : `${(Number(bytes || 0) / 1048576).toFixed(1)} MB`;
    let active = visibleCategories[0]?.id || 'retail';
    let uploadStatus = '';
    const defaultStatus = '可一次选择多个文件，逐个建立价格索引';

    const render = async () => {
      const category = visibleCategories.find((item) => item.id === active);
      const data = await api(`/api/price-files?category=${active}`);
      const adminControls = isAdmin
        ? `<input type="file" class="price-input" accept=".xls,.xlsx,.csv,.tsv,.ppt,.pptx" multiple><div class="price-status muted">${uploadStatus || defaultStatus}</div>`
        : '';
      const files = data.items.map((file) => {
        const summary = file.status === 'failed'
          ? `录入失败${file.error ? `：${escapeHtml(file.error)}` : ''}`
          : `${file.recordCount} 条记录`;
        return `<div class="price-file"><span>${escapeHtml(file.fileName)} · ${summary}</span>${isAdmin ? `<button class="btn danger price-delete" data-id="${file.id}" aria-label="删除 ${escapeHtml(file.fileName)}" title="删除此文件">×</button>` : ''}</div>`;
      }).join('');
      panel.innerHTML = `<h4>${escapeHtml(category.name)}</h4>${adminControls}<div class="price-files">${files || '<p class="muted">暂无价格文件</p>'}</div>`;

      const input = panel.querySelector('.price-input');
      if (input) input.onchange = async (event) => {
        const filesToUpload = Array.from(event.target.files || []);
        if (!filesToUpload.length) return;
        const results = [];
        const status = panel.querySelector('.price-status');
        for (const file of filesToUpload) {
          uploadStatus = `正在处理 ${escapeHtml(file.name)}…`;
          if (status) status.innerHTML = uploadStatus;
          try {
            const response = await fetch('/api/price-files', {
              method: 'POST',
              headers: {
                Authorization: `Bearer ${token()}`,
                'X-Price-Category': active,
                'X-File-Name-Encoded': encodeURIComponent(file.name)
              },
              body: await file.arrayBuffer()
            });
            const result = await response.json();
            if (!response.ok) throw new Error(result.error || '价格资料录入失败');
            results.push(`✓ ${escapeHtml(file.name)}：${result.file.recordCount} 条`);
          } catch (error) {
            results.push(`✗ ${escapeHtml(file.name)}：${escapeHtml(error.message)}`);
          }
        }
        uploadStatus = results.join('<br>');
        await render();
        event.target.value = '';
      };

      panel.querySelectorAll('.price-delete').forEach((button) => {
        button.onclick = async () => {
          const file = data.items.find((item) => item.id === button.dataset.id);
          if (!file || !confirm(`确定删除“${category.name}”中的 ${file.fileName}？本地文件也会同步删除。`)) return;
          try {
            await api(`/api/price-files/${file.id}?category=${active}`, { method: 'DELETE' });
            await render();
          } catch (error) {
            alert(error.message);
          }
        };
      });
    };

    box.querySelectorAll('.price-tab').forEach((button) => button.onclick = async () => {
      active = button.dataset.category;
      box.querySelectorAll('.price-tab').forEach((item) => item.classList.toggle('secondary', item !== button));
      uploadStatus = '';
      await render();
    });
    box.querySelector('.order-query-search-button').onclick = () => loadOrderFiles(box.querySelector('.order-query-search').value.trim());
    box.querySelector('.order-query-search').onkeydown = (event) => { if (event.key === 'Enter') loadOrderFiles(event.target.value.trim()); };
    const orderInput = box.querySelector('.order-query-input');
    if (orderInput) orderInput.onchange = async (event) => {
      const files = Array.from(event.target.files || []);
      if (!files.length) return;
      const status = box.querySelector('.order-query-upload-status'); const results = [];
      for (const file of files) {
        if (!/\.(xls|xlsx|csv|tsv)$/i.test(file.name)) { results.push(`✗ ${escapeHtml(file.name)}：不支持的表格格式`); continue; }
        if (status) status.textContent = `正在归档 ${file.name}…`;
        try {
          const response = await fetch('/api/order-query/files', { method: 'POST', headers: { Authorization: `Bearer ${token()}`, 'X-File-Name-Encoded': encodeURIComponent(file.name) }, body: await file.arrayBuffer() });
          const result = await response.json(); if (!response.ok) throw new Error(result.error || '表格录入失败');
          results.push(`✓ ${escapeHtml(file.name)}：已归档到 ${escapeHtml(result.day)}`);
        } catch (error) { results.push(`✗ ${escapeHtml(file.name)}：${escapeHtml(error.message)}`); }
      }
      if (status) status.innerHTML = results.join('<br>');
      event.target.value = '';
      await loadOrderFiles(box.querySelector('.order-query-search').value.trim());
    };
    render().catch((error) => { panel.textContent = error.message; });
    loadOrderFiles();
  };

  document.querySelector('[data-view="files"]')?.addEventListener('click', () => setTimeout(init, 80));
})();