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