ツール管理へ戻る

v1 のソース

<!DOCTYPE html>
<html lang="ja">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>ハードウェア一覧検索</title>
  <style>
    :root {
      color-scheme: light;
      font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI",
        "Noto Sans JP", sans-serif;
      color: #20252b;
      background: #f5f7fa;
    }

    * {
      box-sizing: border-box;
    }

    body {
      margin: 0;
      padding: 24px;
    }

    main {
      max-width: 1400px;
      margin: 0 auto;
    }

    h1 {
      margin: 0 0 8px;
      font-size: 1.7rem;
    }

    .description {
      margin: 0 0 20px;
      color: #536170;
      line-height: 1.6;
    }

    .panel {
      margin-bottom: 18px;
      padding: 18px;
      border: 1px solid #d8dee7;
      border-radius: 10px;
      background: #fff;
      box-shadow: 0 2px 8px rgb(20 35 55 / 5%);
    }

    .file-row {
      display: flex;
      flex-wrap: wrap;
      align-items: center;
      gap: 12px;
    }

    input[type="file"] {
      max-width: 100%;
    }

    #status {
      margin: 12px 0 0;
      color: #34495e;
      line-height: 1.5;
    }

    #error {
      display: none;
      margin-top: 12px;
      padding: 12px;
      border: 1px solid #e2a4a4;
      border-radius: 6px;
      color: #841f1f;
      background: #fff1f1;
      white-space: pre-wrap;
      overflow-wrap: anywhere;
    }

    .search-grid {
      display: grid;
      grid-template-columns: repeat(auto-fit, minmax(240px, 1fr));
      gap: 14px;
    }

    .search-field {
      min-width: 0;
    }

    .search-field label {
      display: block;
      margin-bottom: 5px;
      font-size: 0.9rem;
      font-weight: 650;
      overflow-wrap: anywhere;
    }

    .search-field input {
      width: 100%;
      min-height: 40px;
      padding: 8px 10px;
      border: 1px solid #aeb8c4;
      border-radius: 6px;
      font: inherit;
    }

    .search-field input:focus,
    button:focus,
    input[type="file"]:focus {
      outline: 3px solid rgb(35 115 190 / 22%);
      outline-offset: 1px;
      border-color: #2373be;
    }

    .field-hint {
      margin-top: 5px;
      color: #617080;
      font-size: 0.78rem;
    }

    .button-row {
      display: flex;
      flex-wrap: wrap;
      gap: 9px;
      margin-top: 18px;
    }

    button {
      min-height: 40px;
      padding: 8px 16px;
      border: 0;
      border-radius: 6px;
      font: inherit;
      cursor: pointer;
    }

    button:disabled {
      cursor: not-allowed;
      opacity: 0.55;
    }

    #searchButton {
      color: #fff;
      background: #1769aa;
    }

    #clearButton {
      color: #26323d;
      background: #e8edf2;
    }

    #resultSummary {
      margin: 16px 0 10px;
      font-weight: 650;
    }

    .table-wrap {
      overflow: auto;
      max-height: 70vh;
      border: 1px solid #cbd3dc;
      border-radius: 7px;
      background: #fff;
    }

    table {
      width: 100%;
      border-collapse: collapse;
      font-size: 0.86rem;
    }

    th,
    td {
      padding: 8px 10px;
      border-right: 1px solid #d6dce3;
      border-bottom: 1px solid #d6dce3;
      text-align: left;
      vertical-align: top;
      overflow-wrap: anywhere;
    }

    th {
      position: sticky;
      top: 0;
      z-index: 1;
      min-width: 110px;
      background: #edf2f7;
      white-space: nowrap;
    }

    th:last-child,
    td:last-child {
      border-right: 0;
    }

    tbody tr:last-child td {
      border-bottom: 0;
    }

    .empty-state {
      padding: 18px;
      color: #5b6875;
      text-align: center;
    }

    @media (max-width: 600px) {
      body {
        padding: 14px;
      }

      .panel {
        padding: 14px;
      }
    }
  </style>
</head>
<body>
  <main>
    <h1>ハードウェア一覧検索</h1>
    <p class="description">
      Excelファイルを選択し、検索条件を入力してください。複数の入力条件はAND検索です。
      入力欄には各項目の登録値が候補として表示されます。候補にない語句も検索できます。
      大文字・小文字、全角・半角を区別せず、部分一致で検索します。空欄の項目は条件に含めません。
    </p>

    <section class="panel" aria-label="ファイル読み込み">
      <div class="file-row">
        <label for="fileInput"><strong>ハードウェア一覧ファイル</strong></label>
        <input id="fileInput" type="file" accept=".xlsx,.xls,.csv">
      </div>
      <p id="status" role="status">ExcelまたはCSVファイルを選択してください。</p>
      <div id="error" role="alert"></div>
    </section>

    <section class="panel" aria-label="検索条件">
      <div id="searchGrid" class="search-grid">
        <div class="empty-state">ファイルを読み込むと検索欄が表示されます。</div>
      </div>
      <div class="button-row">
        <button id="searchButton" type="button" disabled>検索</button>
        <button id="clearButton" type="button" disabled>条件をクリア</button>
      </div>
    </section>

    <div id="resultSummary" aria-live="polite"></div>
    <div id="resultsContainer" class="table-wrap" aria-live="polite">
      <div class="empty-state">検索結果はここに表示されます。</div>
    </div>
  </main>

  <script>
    "use strict";

    /*
      XLSXファイルは、ブラウザの標準機能だけでは一般的な形式として
      展開できません。このページでは、外部通信なしで動作するよう、
      XLSXファイル内のZIP/XMLをブラウザ内で読み取ります。
      CSVファイルにも対応します。
    */

    var headers = [];
    var dataRows = [];
    var loadedFileName = "";

    var fileInput = document.getElementById("fileInput");
    var statusElement = document.getElementById("status");
    var errorElement = document.getElementById("error");
    var searchGrid = document.getElementById("searchGrid");
    var searchButton = document.getElementById("searchButton");
    var clearButton = document.getElementById("clearButton");
    var resultSummary = document.getElementById("resultSummary");
    var resultsContainer = document.getElementById("resultsContainer");

    function setError(error) {
      errorElement.style.display = "block";
      errorElement.textContent =
        "ファイルの読み込みまたは検索でエラーが発生しました。\n" +
        (error && error.message ? error.message : String(error));
    }

    function clearError() {
      errorElement.style.display = "none";
      errorElement.textContent = "";
    }

    function normalize(value) {
      var text = String(value == null ? "" : value);
      if (typeof text.normalize === "function") {
        text = text.normalize("NFKC");
      }
      return text.toLocaleLowerCase("ja");
    }

    function columnNameToIndex(name) {
      var result = 0;
      for (var i = 0; i < name.length; i++) {
        result = result * 26 + name.charCodeAt(i) - 64;
      }
      return result - 1;
    }

    function columnIndexToName(index) {
      var name = "";
      var value = index + 1;
      while (value > 0) {
        var remainder = (value - 1) % 26;
        name = String.fromCharCode(65 + remainder) + name;
        value = Math.floor((value - 1) / 26);
      }
      return name;
    }

    function parseXml(text) {
      var documentNode = new DOMParser().parseFromString(text, "application/xml");
      if (documentNode.getElementsByTagName("parsererror").length > 0) {
        throw new Error("Excelファイル内のXMLを読み取れませんでした。");
      }
      return documentNode;
    }

    function getElementsByLocalName(node, localName) {
      return Array.from(node.getElementsByTagNameNS("*", localName));
    }

    function getFirstElementByLocalName(node, localName) {
      var elements = getElementsByLocalName(node, localName);
      return elements.length ? elements[0] : null;
    }

    function getAttributeByLocalName(element, localName) {
      if (!element) return "";
      for (var i = 0; i < element.attributes.length; i++) {
        if (element.attributes[i].localName === localName) {
          return element.attributes[i].value;
        }
      }
      return "";
    }

    function decodeXmlText(element) {
      return element ? element.textContent : "";
    }

    function parseSharedStrings(xmlText) {
      if (!xmlText) return [];
      var documentNode = parseXml(xmlText);
      return getElementsByLocalName(documentNode, "si").map(function (item) {
        return getElementsByLocalName(item, "t")
          .map(decodeXmlText)
          .join("");
      });
    }

    function parseWorksheet(xmlText, sharedStrings) {
      var documentNode = parseXml(xmlText);
      var rowElements = getElementsByLocalName(documentNode, "row");
      var matrix = [];

      rowElements.forEach(function (rowElement, rowPosition) {
        var rowNumber = Number(getAttributeByLocalName(rowElement, "r")) || rowPosition + 1;
        var outputRow = matrix[rowNumber - 1] || [];
        var cells = getElementsByLocalName(rowElement, "c");

        cells.forEach(function (cell) {
          var reference = getAttributeByLocalName(cell, "r");
          var letters = reference.match(/^[A-Z]+/i);
          var columnIndex = letters ? columnNameToIndex(letters[0].toUpperCase()) : outputRow.length;
          var type = getAttributeByLocalName(cell, "t");
          var valueElement = getFirstElementByLocalName(cell, "v");
          var value = valueElement ? valueElement.textContent : "";

          if (type === "s") {
            var sharedIndex = Number(value);
            value = sharedStrings[sharedIndex] == null ? "" : sharedStrings[sharedIndex];
          } else if (type === "inlineStr") {
            var inlineElement = getFirstElementByLocalName(cell, "is");
            value = inlineElement
              ? getElementsByLocalName(inlineElement, "t").map(decodeXmlText).join("")
              : "";
          } else if (type === "b") {
            value = value === "1" ? "TRUE" : "FALSE";
          }

          outputRow[columnIndex] = value;
        });

        matrix[rowNumber - 1] = outputRow;
      });

      return matrix;
    }

    function resolveRelationshipPath(target) {
      var normalized = target.replace(/\\/g, "/");
      if (normalized.charAt(0) === "/") {
        return normalized.slice(1);
      }
      return "xl/" + normalized.replace(/^(\.\/)+/, "");
    }

    async function readXlsx(arrayBuffer) {
      if (typeof DecompressionStream !== "function") {
        throw new Error(
          "このブラウザはZIP形式の展開機能に対応していません。最新のChrome、Edge、Firefox、またはSafariでお試しください。"
        );
      }

      var bytes = new Uint8Array(arrayBuffer);
      var view = new DataView(arrayBuffer);
      var endOffset = -1;
      var searchStart = Math.max(0, bytes.length - 65557);

      for (var i = bytes.length - 22; i >= searchStart; i--) {
        if (
          view.getUint32(i, true) === 0x06054b50 &&
          i + 22 <= bytes.length
        ) {
          endOffset = i;
          break;
        }
      }

      if (endOffset < 0) {
        throw new Error("有効なXLSX形式のZIP構造が見つかりませんでした。");
      }

      var entryCount = view.getUint16(endOffset + 10, true);
      var centralDirectoryOffset = view.getUint32(endOffset + 16, true);
      var entries = new Map();
      var pointer = centralDirectoryOffset;

      for (var entryIndex = 0; entryIndex < entryCount; entryIndex++) {
        if (view.getUint32(pointer, true) !== 0x02014b50) {
          throw new Error("XLSXファイルのZIP目録を読み取れませんでした。");
        }

        var compressionMethod = view.getUint16(pointer + 10, true);
        var compressedSize = view.getUint32(pointer + 20, true);
        var fileNameLength = view.getUint16(pointer + 28, true);
        var extraLength = view.getUint16(pointer + 30, true);
        var commentLength = view.getUint16(pointer + 32, true);
        var localHeaderOffset = view.getUint32(pointer + 42, true);

        var fileNameBytes = bytes.subarray(
          pointer + 46,
          pointer + 46 + fileNameLength
        );
        var fileName = new TextDecoder("utf-8").decode(fileNameBytes);

        entries.set(fileName, {
          compressionMethod: compressionMethod,
          compressedSize: compressedSize,
          localHeaderOffset: localHeaderOffset
        });

        pointer += 46 + fileNameLength + extraLength + commentLength;
      }

      async function readZipEntry(path) {
        var entry = entries.get(path);
        if (!entry) return null;

        var localOffset = entry.localHeaderOffset;
        if (view.getUint32(localOffset, true) !== 0x04034b50) {
          throw new Error("XLSX内のファイルを読み取れませんでした: " + path);
        }

        var localNameLength = view.getUint16(localOffset + 26, true);
        var localExtraLength = view.getUint16(localOffset + 28, true);
        var contentOffset = localOffset + 30 + localNameLength + localExtraLength;
        var compressed = bytes.slice(contentOffset, contentOffset + entry.compressedSize);

        if (entry.compressionMethod === 0) {
          return new TextDecoder("utf-8").decode(compressed);
        }

        if (entry.compressionMethod !== 8) {
          throw new Error("対応していない圧縮形式です: " + path);
        }

        var stream = new Blob([compressed]).stream().pipeThrough(
          new DecompressionStream("deflate-raw")
        );
        var decompressed = await new Response(stream).arrayBuffer();
        return new TextDecoder("utf-8").decode(decompressed);
      }

      var workbookXml = await readZipEntry("xl/workbook.xml");
      if (!workbookXml) {
        throw new Error("Excelブック情報が見つかりません。");
      }

      var relationshipsXml = await readZipEntry("xl/_rels/workbook.xml.rels");
      if (!relationshipsXml) {
        throw new Error("Excelシート情報が見つかりません。");
      }

      var workbookDocument = parseXml(workbookXml);
      var relationshipsDocument = parseXml(relationshipsXml);
      var firstSheet = getElementsByLocalName(workbookDocument, "sheet")[0];

      if (!firstSheet) {
        throw new Error("Excelファイルにシートがありません。");
      }

      var relationshipId = getAttributeByLocalName(firstSheet, "id");
      var relationshipElements = getElementsByLocalName(
        relationshipsDocument,
        "Relationship"
      );
      var target = "";

      for (var relIndex = 0; relIndex < relationshipElements.length; relIndex++) {
        var relationship = relationshipElements[relIndex];
        if (relationship.getAttribute("Id") === relationshipId) {
          target = relationship.getAttribute("Target");
          break;
        }
      }

      if (!target) {
        throw new Error("先頭シートの参照先が見つかりません。");
      }

      var worksheetPath = resolveRelationshipPath(target);
      var worksheetXml = await readZipEntry(worksheetPath);
      if (!worksheetXml) {
        throw new Error("先頭シートのデータが見つかりません。");
      }

      var sharedStringsXml = await readZipEntry("xl/sharedStrings.xml");
      var sharedStrings = parseSharedStrings(sharedStringsXml);
      return parseWorksheet(worksheetXml, sharedStrings);
    }

    function parseCsv(text) {
      var rows = [];
      var row = [];
      var cell = "";
      var quoted = false;

      for (var i = 0; i < text.length; i++) {
        var character = text[i];

        if (quoted) {
          if (character === '"') {
            if (text[i + 1] === '"') {
              cell += '"';
              i++;
            } else {
              quoted = false;
            }
          } else {
            cell += character;
          }
        } else if (character === '"') {
          quoted = true;
        } else if (character === ",") {
          row.push(cell);
          cell = "";
        } else if (character === "\n") {
          row.push(cell.replace(/\r$/, ""));
          rows.push(row);
          row = [];
          cell = "";
        } else {
          cell += character;
        }
      }

      if (cell.length || row.length || (text.length && !/\n$/.test(text))) {
        row.push(cell.replace(/\r$/, ""));
        rows.push(row);
      }

      return rows;
    }

    function cleanRows(matrix) {
      return matrix.map(function (row) {
        return row.map(function (value) {
          return value == null ? "" : String(value);
        });
      }).filter(function (row) {
        return row.some(function (value) { return value !== ""; });
      });
    }

    function makeDatalistId(columnIndex) {
      return "values-column-" + columnIndex;
    }

    function buildSearchFields() {
      searchGrid.textContent = "";

      headers.forEach(function (header, columnIndex) {
        var field = document.createElement("div");
        field.className = "search-field";

        var label = document.createElement("label");
        var inputId = "search-column-" + columnIndex;
        label.htmlFor = inputId;
        label.textContent = header || ("列 " + (columnIndex + 1));

        var input = document.createElement("input");
        input.type = "search";
        input.id = inputId;
        input.dataset.column = String(columnIndex);
        input.setAttribute("list", makeDatalistId(columnIndex));
        input.setAttribute("autocomplete", "off");
        input.placeholder = "入力または候補から選択";

        var datalist = document.createElement("datalist");
        datalist.id = makeDatalistId(columnIndex);

        var uniqueValues = new Set();
        dataRows.forEach(function (row) {
          var value = row[columnIndex] == null ? "" : String(row[columnIndex]);
          if (value.trim() !== "") uniqueValues.add(value);
        });

        Array.from(uniqueValues).sort(function (a, b) {
          return a.localeCompare(b, "ja");
        }).forEach(function (value) {
          var option = document.createElement("option");
          option.value = value;
          datalist.appendChild(option);
        });

        var hint = document.createElement("div");
        hint.className = "field-hint";
        hint.textContent = uniqueValues.size + " 種類の登録値を候補表示";

        field.appendChild(label);
        field.appendChild(input);
        field.appendChild(datalist);
        field.appendChild(hint);
        searchGrid.appendChild(field);
      });

      searchButton.disabled = false;
      clearButton.disabled = false;
    }

    function createResultsTable(matches) {
      resultsContainer.textContent = "";

      if (matches.length === 0) {
        var empty = document.createElement("div");
        empty.className = "empty-state";
        empty.textContent = "該当するデータはありません。";
        resultsContainer.appendChild(empty);
        return;
      }

      var table = document.createElement("table");
      var thead = document.createElement("thead");
      var headerRow = document.createElement("tr");

      headers.forEach(function (header, index) {
        var th = document.createElement("th");
        th.textContent = header || ("列 " + (index + 1));
        headerRow.appendChild(th);
      });

      thead.appendChild(headerRow);
      table.appendChild(thead);

      var tbody = document.createElement("tbody");
      matches.forEach(function (row) {
        var tr = document.createElement("tr");
        headers.forEach(function (_, index) {
          var td = document.createElement("td");
          td.textContent = row[index] == null ? "" : String(row[index]);
          tr.appendChild(td);
        });
        tbody.appendChild(tr);
      });

      table.appendChild(tbody);
      resultsContainer.appendChild(table);
    }

    function runSearch() {
      clearError();

      var conditions = Array.from(
        document.querySelectorAll("#searchGrid input[data-column]")
      ).map(function (input) {
        return {
          column: Number(input.dataset.column),
          value: normalize(input.value.trim())
        };
      }).filter(function (condition) {
        return condition.value !== "";
      });

      var matches = dataRows.filter(function (row) {
        return conditions.every(function (condition) {
          return normalize(row[condition.column]).indexOf(condition.value) !== -1;
        });
      });

      resultSummary.textContent =
        "検索結果: " + matches.length + " 件" +
        (conditions.length ? "(入力条件 " + conditions.length + " 項目)" : "(条件なし)");

      createResultsTable(matches);
    }

    function clearConditions() {
      document.querySelectorAll("#searchGrid input[data-column]").forEach(function (input) {
        input.value = "";
      });
      clearError();
      resultSummary.textContent = "";
      resultsContainer.innerHTML =
        '<div class="empty-state">検索語を入力して「検索」を押してください。</div>';
    }

    async function loadFile(file) {
      clearError();
      headers = [];
      dataRows = [];
      loadedFileName = file.name;
      resultSummary.textContent = "";
      resultsContainer.innerHTML =
        '<div class="empty-state">ファイルを読み込んでいます。</div>';
      searchGrid.innerHTML =
        '<div class="empty-state">ファイルを読み込んでいます。</div>';
      searchButton.disabled = true;
      clearButton.disabled = true;
      statusElement.textContent = "読み込み中: " + file.name;

      try {
        var matrix;

        if (/\.csv$/i.test(file.name)) {
          var csvText = await file.text();
          matrix = parseCsv(csvText);
        } else if (/\.(xlsx|xls)$/i.test(file.name)) {
          matrix = await readXlsx(await file.arrayBuffer());
        } else {
          throw new Error("対応していないファイル形式です。XLSXまたはCSVを選択してください。");
        }

        matrix = cleanRows(matrix);
        if (!matrix.length) {
          throw new Error("ファイルに読み取れるデータがありません。");
        }

        headers = matrix[0].map(function (value) {
          return String(value == null ? "" : value);
        });
        dataRows = matrix.slice(1).map(function (row) {
          var completed = row.slice();
          while (completed.length < headers.length) completed.push("");
          return completed.slice(0, headers.length);
        });

        if (!headers.length) {
          throw new Error("列見出しを読み取れませんでした。");
        }

        buildSearchFields();
        statusElement.textContent =
          loadedFileName + " を読み込みました。データ " +
          dataRows.length + " 件、項目 " + headers.length + " 列です。";
        resultsContainer.innerHTML =
          '<div class="empty-state">検索語を入力して「検索」を押してください。</div>';
      } catch (error) {
        setError(error);
        statusElement.textContent = "ファイルを読み込めませんでした。";
        searchGrid.innerHTML =
          '<div class="empty-state">読み込みに失敗しました。ファイル形式やブラウザを確認してください。</div>';
      }
    }

    fileInput.addEventListener("change", function () {
      var file = fileInput.files && fileInput.files[0];
      if (file) loadFile(file);
    });

    searchButton.addEventListener("click", runSearch);
    clearButton.addEventListener("click", clearConditions);

    searchGrid.addEventListener("keydown", function (event) {
      if (event.key === "Enter" && event.target.matches("input")) {
        event.preventDefault();
        runSearch();
      }
    });
  </script>
</body>
</html>