ツール管理へ戻る

v1 → v2 の差分

--- v1
+++ v2
@@ -1,793 +1,859 @@
-<!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>
+<!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 searchInputs = [];
+    var fieldHints = [];
+
+    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 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 getCurrentConditions() {
+      return searchInputs.map(function (input) {
+        return {
+          column: Number(input.dataset.column),
+          value: normalize(input.value.trim())
+        };
+      }).filter(function (condition) {
+        return condition.value !== "";
+      });
+    }
+
+    function rowMatchesConditions(row, conditions) {
+      return conditions.every(function (condition) {
+        return normalize(row[condition.column]).indexOf(condition.value) !== -1;
+      });
+    }
+
+    function updateSuggestions() {
+      var conditions = getCurrentConditions();
+
+      searchInputs.forEach(function (input, columnIndex) {
+        var datalist = document.getElementById(makeDatalistId(columnIndex));
+        if (!datalist) return;
+
+        /*
+          候補を作る列自身の入力条件は除き、
+          ほかの列に入力された条件だけで対象行を絞り込みます。
+        */
+        var otherConditions = conditions.filter(function (condition) {
+          return condition.column !== columnIndex;
+        });
+
+        var uniqueValues = new Set();
+
+        dataRows.forEach(function (row) {
+          if (!rowMatchesConditions(row, otherConditions)) return;
+
+          var value = row[columnIndex] == null
+            ? ""
+            : String(row[columnIndex]);
+
+          if (value.trim() !== "") {
+            uniqueValues.add(value);
+          }
+        });
+
+        var sortedValues = Array.from(uniqueValues).sort(function (a, b) {
+          return a.localeCompare(b, "ja");
+        });
+
+        datalist.textContent = "";
+        sortedValues.forEach(function (value) {
+          var option = document.createElement("option");
+          option.value = value;
+          datalist.appendChild(option);
+        });
+
+        fieldHints[columnIndex].textContent =
+          sortedValues.length + " 種類の候補(他項目の条件を反映)";
+      });
+    }
+
+    function buildSearchFields() {
+      searchGrid.textContent = "";
+      searchInputs = [];
+      fieldHints = [];
+
+      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 hint = document.createElement("div");
+        hint.className = "field-hint";
+
+        input.addEventListener("input", function () {
+          updateSuggestions();
+        });
+
+        searchInputs.push(input);
+        fieldHints.push(hint);
+
+        field.appendChild(label);
+        field.appendChild(input);
+        field.appendChild(datalist);
+        field.appendChild(hint);
+        searchGrid.appendChild(field);
+      });
+
+      searchButton.disabled = false;
+      clearButton.disabled = false;
+      updateSuggestions();
+    }
+
+    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 = getCurrentConditions();
+      var matches = dataRows.filter(function (row) {
+        return rowMatchesConditions(row, conditions);
+      });
+
+      resultSummary.textContent =
+        "検索結果: " + matches.length + " 件" +
+        (conditions.length
+          ? "(入力条件 " + conditions.length + " 項目)"
+          : "(条件なし)");
+
+      createResultsTable(matches);
+    }
+
+    function clearConditions() {
+      searchInputs.forEach(function (input) {
+        input.value = "";
+      });
+
+      clearError();
+      resultSummary.textContent = "";
+      updateSuggestions();
+      resultsContainer.innerHTML =
+        '<div class="empty-state">検索語を入力して「検索」を押してください。</div>';
+    }
+
+    async function loadFile(file) {
+      clearError();
+      headers = [];
+      dataRows = [];
+      searchInputs = [];
+      fieldHints = [];
+      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>