ツール管理へ戻る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>