375 lines
16 KiB
JavaScript
375 lines
16 KiB
JavaScript
const EstIssues = (() => {
|
||
let page = 0,
|
||
tableFilter = "all",
|
||
typeFilter = "all";
|
||
const grouped = new Set(["HeadMainDat", "CostMainDat", "MachMainDat"]);
|
||
const kinds = {
|
||
5: "StuffcDat",
|
||
6: "LaborcDat",
|
||
21: "SilJukDat",
|
||
101: "EstiMateDat",
|
||
103: "HeadMainDat",
|
||
104: "CostMainDat",
|
||
105: "MachMainDat",
|
||
};
|
||
function scan(project) {
|
||
const issues = [],
|
||
sources = new Map();
|
||
for (const [kind, table] of Object.entries(kinds)) {
|
||
const codes = new Map();
|
||
(project.tables[table] || []).forEach((row, index) => {
|
||
if (!row.Code || (grouped.has(table) && !(Number(row.Index) > 0))) return;
|
||
const list = codes.get(String(row.Code)) || [];
|
||
list.push({ row, index });
|
||
codes.set(String(row.Code), list);
|
||
});
|
||
sources.set(Number(kind), codes);
|
||
for (const [code, list] of codes)
|
||
if (list.length > 1)
|
||
for (const { index } of list) issues.push({ table, index, code, message: "코드 중복" });
|
||
}
|
||
for (const table of ["EstMainDat", "HeadMainDat", "MachMainDat", "CostMainDat"]) {
|
||
(project.tables[table] || []).forEach((row, index) => {
|
||
const link = Number(row.LinkIndex);
|
||
if (
|
||
Number(row.Level || 0) === 0 &&
|
||
Number(row.Index || 0) === 0 &&
|
||
[52, 57, 58, 62, 67].includes(link) &&
|
||
row.Unite &&
|
||
!["%", "％"].includes(String(row.Unite).trim())
|
||
) {
|
||
issues.push({
|
||
table,
|
||
index,
|
||
code: row.Code,
|
||
message: "단위 백분율(%) 불일치",
|
||
rowUnite: row.Unite,
|
||
});
|
||
}
|
||
if (Number(row.Level) > 0 || Number(row.Index) > 0 || !row.Code) return;
|
||
const codes = sources.get(link);
|
||
if (!codes) return;
|
||
const matches = codes.get(String(row.Code)) || [];
|
||
if (!matches.length)
|
||
issues.push({ table, index, code: row.Code, message: "연결 자료 없음" });
|
||
else if (matches.length > 1)
|
||
issues.push({ table, index, code: row.Code, message: "연결 코드 중복" });
|
||
else
|
||
for (const field of ["Name", "Size", "Unite"]) {
|
||
const a = row[field],
|
||
b = matches[0].row[field];
|
||
if (a && b && EstNative.normalize(a) !== EstNative.normalize(b))
|
||
issues.push({
|
||
table,
|
||
index,
|
||
code: row.Code,
|
||
message:
|
||
field === "Name"
|
||
? "연결 품명 차이"
|
||
: field === "Size"
|
||
? "연결 규격 차이"
|
||
: "연결 단위 차이",
|
||
sourceName: matches[0].row.Name,
|
||
sourceSize: matches[0].row.Size,
|
||
sourceUnite: matches[0].row.Unite,
|
||
});
|
||
}
|
||
});
|
||
}
|
||
// 수량산출서 및 직접 수식표 항목의 내역 연결(TargetKey 또는 TargetCode/LinkCode) 검사:
|
||
// 실제 totals() 연결 규칙과 일치하도록:
|
||
// 1) item.TargetKey 가 있으면 row.PkID != null && `id:${row.PkID}` === item.TargetKey 우선 매칭
|
||
// 2) 없으면 code = item.TargetCode ?? item.LinkCode 로 row.Code === code 매칭
|
||
// 3) level > 0 (공종/비고행) 제외
|
||
const sourcesToCheck = [];
|
||
(project.quantitySheets || []).forEach((sheet) => {
|
||
(sheet.items || []).forEach((item, itemIndex) => {
|
||
sourcesToCheck.push({ item, sheetCode: sheet.Code, itemIndex });
|
||
});
|
||
});
|
||
(project.quantities || []).forEach((item, itemIndex) => {
|
||
sourcesToCheck.push({ item, sheetCode: "manual", itemIndex });
|
||
});
|
||
|
||
const estRows = (project.tables.EstMainDat || []).map((row, index) => ({ row, index }));
|
||
sourcesToCheck.forEach(({ item, sheetCode, itemIndex }) => {
|
||
const code = item.TargetCode ?? item.LinkCode;
|
||
if (!code && !item.TargetKey) {
|
||
issues.push({
|
||
table: "quantity",
|
||
sheetCode,
|
||
index: itemIndex,
|
||
code: item.Code,
|
||
message: "수량 내역 미연결",
|
||
unlinked: true,
|
||
item,
|
||
});
|
||
return;
|
||
}
|
||
const targets = estRows.filter(
|
||
({ row }) =>
|
||
!Number(row.Level) &&
|
||
(item.TargetKey
|
||
? row.PkID != null && `id:${row.PkID}` === item.TargetKey
|
||
: row.Code === code),
|
||
);
|
||
if (!targets.length) {
|
||
issues.push({
|
||
table: "quantity",
|
||
sheetCode,
|
||
index: itemIndex,
|
||
code: item.Code,
|
||
message: `수량 대상 내역 없음: ${item.TargetKey || code}`,
|
||
unlinked: true,
|
||
item,
|
||
});
|
||
} else if (targets.length > 1) {
|
||
issues.push({
|
||
table: "quantity",
|
||
sheetCode,
|
||
index: itemIndex,
|
||
code: item.Code,
|
||
message: `수량 대상 내역 중복: ${item.TargetKey || code}`,
|
||
});
|
||
}
|
||
});
|
||
const costs = project.tables.CostMainDat || [],
|
||
costGroups = EstNative.groups(costs);
|
||
if (typeof EstWonga !== "undefined" && typeof EstWonga.scan === "function") {
|
||
const direct = project.calculation?.direct || {};
|
||
const bases = {
|
||
NC: Number(direct.NC) || 0,
|
||
GC: Number(direct.GC) || 0,
|
||
JC: Number(direct.JC) || 0,
|
||
SC: Number(direct.SC) || 0,
|
||
TC: Number(direct.TC) || 0,
|
||
노무비: Number(direct.NC) || 0,
|
||
재료비: Number(direct.GC) || 0,
|
||
경비: Number(direct.JC) || 0,
|
||
실적: Number(direct.SC) || 0,
|
||
직접공사비: Number(direct.TC) || 0,
|
||
};
|
||
const wongaIssues = EstWonga.scan(project.tables?.Wonga, project.options || {}, bases);
|
||
issues.push(...wongaIssues);
|
||
}
|
||
for (const message of project.calculation?.errors || []) {
|
||
const text = String(message),
|
||
match = text.match(/^(.+):(\d+) /),
|
||
code = match?.[1],
|
||
group = code && costGroups.get(code),
|
||
offset = match ? Number(match[2]) - 1 : -1,
|
||
unique = group && sources.get(104)?.get(code)?.length === 1,
|
||
index = unique && offset >= 0 && offset < group.rows.length ? group.start + offset : -1;
|
||
issues.push({
|
||
table: index >= 0 ? "CostMainDat" : "",
|
||
index,
|
||
code: index >= 0 ? code : "",
|
||
message: text,
|
||
});
|
||
}
|
||
return issues;
|
||
}
|
||
function targetSelect(project, item, sheetCode, itemIndex) {
|
||
const { esc } = EstApp;
|
||
const rows = (project.tables?.EstMainDat || []).filter(
|
||
(row) => row.PkID != null && !Number(row.Level),
|
||
);
|
||
return `<select data-issue-target-select="${esc(sheetCode)}" data-issue-item-index="${itemIndex}" aria-label="연결 내역 선택"><option value="">내역 행 선택</option>${rows
|
||
.map((row) => {
|
||
const key = `id:${row.PkID}`;
|
||
return `<option value="${esc(key)}" ${item.TargetKey === key ? "selected" : ""}>${esc(row.Name || "내역")} · ${esc(row.Code || "코드 없음")} · ${esc(row.PkID)}</option>`;
|
||
})
|
||
.join("")}</select>`;
|
||
}
|
||
function render() {
|
||
const { state, esc, byId, titles } = EstApp,
|
||
allIssues = scan(state.project);
|
||
const tables = [...new Set(allIssues.map((i) => i.table || ""))];
|
||
const messages = [...new Set(allIssues.map((i) => i.message))];
|
||
const filtered = allIssues.filter((i) => {
|
||
if (tableFilter !== "all" && (i.table || "") !== tableFilter) return false;
|
||
if (typeFilter !== "all" && i.message !== typeFilter) return false;
|
||
return true;
|
||
});
|
||
page = Math.max(0, Math.min(page, Math.ceil(filtered.length / 100) - 1));
|
||
const rows = filtered.slice(page * 100, page * 100 + 100);
|
||
const tableSelect = `<label>자료 <select id="issue-table-filter"><option value="all">전체 자료</option>${tables
|
||
.map(
|
||
(t) =>
|
||
`<option value="${esc(t)}" ${tableFilter === t ? "selected" : ""}>${esc(titles[t] || t || "전체 계산")}</option>`,
|
||
)
|
||
.join("")}</select></label>`;
|
||
const typeSelect = `<label>내용 <select id="issue-type-filter"><option value="all">전체 유형</option>${messages
|
||
.map(
|
||
(m) => `<option value="${esc(m)}" ${typeFilter === m ? "selected" : ""}>${esc(m)}</option>`,
|
||
)
|
||
.join("")}</select></label>`;
|
||
byId("work-content").innerHTML =
|
||
`<div class="business-tools"><b>자료 오류 검색</b>${tableSelect} ${typeSelect}<span>검색 ${filtered.length}건 (전체 ${allIssues.length}건) · ${page + 1}/${Math.max(1, Math.ceil(filtered.length / 100))}쪽</span><button data-issue-page="-1" ${page === 0 ? "disabled" : ""}>이전</button><button data-issue-page="1" ${(page + 1) * 100 >= filtered.length ? "disabled" : ""}>다음</button>${
|
||
filtered.some(
|
||
(i) => i.sourceName && ["연결 품명 차이", "연결 규격 차이"].includes(i.message),
|
||
)
|
||
? ' <button data-issue-sync-all="1">불일치 원천 명칭/규격 일괄 반영</button>'
|
||
: ""
|
||
}</div><p>연결 품명·규격 차이는 확인 후 개별 또는 일괄로 반영할 수 있으며, 단위 차이는 수량·단가 환산 보호를 위해 개별 확인 시에만 반영됩니다.</p><table class="sheet"><thead><tr><th>자료</th><th>행</th><th>코드</th><th>내용</th><th>원천 실제 명칭</th><th>이동 및 조작</th></tr></thead><tbody>${rows
|
||
.map(
|
||
(item) =>
|
||
`<tr><td>${esc(titles[item.table] || item.table || "전체 계산")}</td><td>${item.index >= 0 ? item.index + 1 : ""}</td><td>${esc(item.code)}</td><td>${esc(item.message)}</td><td>${
|
||
item.sourceName
|
||
? `${esc(item.sourceName)}${item.sourceSize ? " · " + esc(item.sourceSize) : ""}${item.sourceUnite ? " · " + esc(item.sourceUnite) : ""}`
|
||
: ""
|
||
}</td><td>${
|
||
item.table === "quantity"
|
||
? `<button data-issue-quantity="${esc(item.sheetCode || "")}" data-issue-row="${item.index}">산출서 열기</button>${
|
||
item.unlinked
|
||
? " " + targetSelect(state.project, item.item, item.sheetCode, item.index)
|
||
: ""
|
||
}`
|
||
: item.table
|
||
? `<button data-issue-table="${esc(item.table)}" data-issue-row="${item.index}">행 열기</button>${
|
||
item.sourceName &&
|
||
["연결 품명 차이", "연결 규격 차이", "연결 단위 차이"].includes(item.message)
|
||
? ` <button data-issue-sync-row="${esc(item.table)}" data-issue-sync-index="${item.index}" data-issue-sync-msg="${esc(item.message)}">${
|
||
item.message === "연결 단위 차이" ? "원천단위 반영" : "원천명칭 반영"
|
||
}</button>`
|
||
: ""
|
||
}`
|
||
: ""
|
||
}</td></tr>`,
|
||
)
|
||
.join("")}</tbody></table>`;
|
||
}
|
||
function install() {
|
||
document.addEventListener("change", (event) => {
|
||
if (event.target.id === "issue-table-filter") {
|
||
tableFilter = event.target.value;
|
||
page = 0;
|
||
render();
|
||
return;
|
||
}
|
||
if (event.target.id === "issue-type-filter") {
|
||
typeFilter = event.target.value;
|
||
page = 0;
|
||
render();
|
||
return;
|
||
}
|
||
const select = event.target.closest("[data-issue-target-select]");
|
||
if (!select) return;
|
||
const { state } = EstApp,
|
||
sheetCode = select.dataset.issueTargetSelect,
|
||
itemIndex = Number(select.dataset.issueItemIndex);
|
||
const item =
|
||
sheetCode === "manual"
|
||
? state.project.quantities?.[itemIndex]
|
||
: state.project.quantitySheets?.find((s) => s.Code === sheetCode)?.items?.[itemIndex];
|
||
if (!item) return;
|
||
const row = (state.project.tables.EstMainDat || []).find(
|
||
(r) => r.PkID != null && `id:${r.PkID}` === select.value && !Number(r.Level),
|
||
);
|
||
EstApp.change(() => {
|
||
item.TargetKey = row ? select.value : "";
|
||
item.TargetCode = row?.Code || "";
|
||
}, false);
|
||
});
|
||
document.addEventListener("click", (event) => {
|
||
const step = event.target.closest("[data-issue-page]");
|
||
if (step) {
|
||
page += Number(step.dataset.issuePage);
|
||
render();
|
||
return;
|
||
}
|
||
const qNode = event.target.closest("[data-issue-quantity]");
|
||
if (qNode) {
|
||
const sheetCode = qNode.dataset.issueQuantity;
|
||
EstApp.state.view = "quantity";
|
||
EstApp.state.quantitySheet = sheetCode || "manual";
|
||
EstApp.navigate("quantity");
|
||
return;
|
||
}
|
||
const syncAllBtn = event.target.closest("[data-issue-sync-all]");
|
||
if (syncAllBtn) {
|
||
const { state } = EstApp;
|
||
// 현재 필터링 조건에 일치하는 품명·규격 불일치 항목만 일괄 반영 대상
|
||
const currentFiltered = scan(state.project).filter((i) => {
|
||
if (tableFilter !== "all" && (i.table || "") !== tableFilter) return false;
|
||
if (typeFilter !== "all" && i.message !== typeFilter) return false;
|
||
return i.sourceName && (i.message === "연결 품명 차이" || i.message === "연결 규격 차이");
|
||
});
|
||
if (!currentFiltered.length) return;
|
||
EstApp.change(() => {
|
||
for (const issue of currentFiltered) {
|
||
const row = state.project.tables[issue.table]?.[issue.index];
|
||
if (!row) continue;
|
||
if (issue.message === "연결 품명 차이" && issue.sourceName) {
|
||
row.Name = issue.sourceName;
|
||
} else if (issue.message === "연결 규격 차이") {
|
||
if (issue.sourceSize && issue.sourceSize.trim() !== "") {
|
||
row.Size = issue.sourceSize;
|
||
}
|
||
}
|
||
}
|
||
});
|
||
render();
|
||
return;
|
||
}
|
||
const syncRowBtn = event.target.closest("[data-issue-sync-row]");
|
||
if (syncRowBtn) {
|
||
const { state } = EstApp;
|
||
const targetTable = syncRowBtn.dataset.issueSyncRow,
|
||
targetIndex = Number(syncRowBtn.dataset.issueSyncIndex),
|
||
targetMsg = syncRowBtn.dataset.issueSyncMsg;
|
||
const issue = scan(state.project).find(
|
||
(i) =>
|
||
i.table === targetTable &&
|
||
i.index === targetIndex &&
|
||
(!targetMsg || i.message === targetMsg) &&
|
||
i.sourceName,
|
||
);
|
||
if (!issue) return;
|
||
EstApp.change(() => {
|
||
const row = state.project.tables[targetTable]?.[targetIndex];
|
||
if (!row) return;
|
||
if (issue.message === "연결 품명 차이" && issue.sourceName) {
|
||
row.Name = issue.sourceName;
|
||
} else if (issue.message === "연결 규격 차이") {
|
||
if (issue.sourceSize && issue.sourceSize.trim() !== "") {
|
||
row.Size = issue.sourceSize;
|
||
}
|
||
} else if (issue.message === "연결 단위 차이") {
|
||
if (issue.sourceUnite !== undefined) {
|
||
row.Unite = issue.sourceUnite;
|
||
}
|
||
}
|
||
});
|
||
render();
|
||
return;
|
||
}
|
||
const node = event.target.closest("[data-issue-table]");
|
||
if (!node) return;
|
||
const table = node.dataset.issueTable,
|
||
index = Number(node.dataset.issueRow),
|
||
rows = EstApp.state.project.tables[table] || [];
|
||
if (!rows[index]) return;
|
||
let group = "";
|
||
if (grouped.has(table))
|
||
for (const [code, item] of EstNative.groups(rows))
|
||
if (index >= item.start && index < item.start + item.rows.length) {
|
||
group = code;
|
||
break;
|
||
}
|
||
if (grouped.has(table) && !group) {
|
||
EstApp.state.notice = "묶음 코드가 중복되거나 해당 행의 묶음이 없어 이동할 수 없습니다.";
|
||
EstApp.render();
|
||
return;
|
||
}
|
||
EstApp.navigate(table, group);
|
||
const visible = EstApp.visibleRows(),
|
||
position = visible.findIndex((item) => item.index === index);
|
||
if (position >= 0) EstApp.state.page = Math.floor(position / 100);
|
||
EstApp.state.selection = new Set([index]);
|
||
EstApp.render();
|
||
});
|
||
}
|
||
return { scan, render, install };
|
||
})();
|