(() => { "use strict"; const SEED_DATA = JSON.parse(document.getElementById("seed-data").textContent); const LOCALE_SEED_OVERLAY = window.__finiteFieldLocaleSeedOverlay || {}; const LOCALE_UI = window.__finiteFieldLocaleUi || {}; const STORAGE_ENTITY_KEY = "constructionInspection.entityId"; const DEFAULT_ENTITY_ID = "entity_default"; const requestedEntityId = new URLSearchParams(location.search).get("entityId") || localStorage.getItem(STORAGE_ENTITY_KEY) || DEFAULT_ENTITY_ID; const entityId = sanitizeEntityId(requestedEntityId); const DB_NAME = `${entityId}_${(() => { const localeSuffix = String(document.documentElement.lang || "ja").toLowerCase().replace(/[^a-z0-9]+/g, "_").replace(/^_+|_+$/g, "") || "ja"; return localeSuffix; })()}_construction_inspection_checklist_db`; const DB_VERSION = 1; const DATA_STORES = [ "settings", "inspections", "photos", "rectifications", "monthlyPlans", "weeklyPlans", "schedules", "checklistItems", "options" ]; const ALL_STORES = ["meta", ...DATA_STORES]; const STATUS_CLOSED = new Set(uiList("sets.closedStatuses", ["Closed", "Completed", "Cancel", "Close"])); const TODAY = () => toISODate(new Date()); const FIELD_DEFS = { settings: [ {key:"settingKey", label:"Setting key", type:"text", required:true, colSpan:1}, {key:"settingValue", label:"Setting value", type:"text", required:true, colSpan:1}, {key:"description", label:"Notes", type:"textarea", colSpan:2}, {key:"recommendedChange", label:"Recommended change", type:"select", optionCategory:"Yes / No", colSpan:1} ], inspections: [ {key:"inspectionNo", label:"Inspection ID", type:"text", required:true, codePrefix:"INS"}, {key:"company", label:"Company", type:"text", required:true}, {key:"projectSite", label:"Project / Site", type:"text", required:true}, {key:"businessScene", label:"Scenario", type:"select", optionCategory:"Scenario", required:true}, {key:"scope", label:"Inspection scope", type:"select", optionCategory:"Inspection scope", required:true}, {key:"area", label:"Area / Floor", type:"text"}, {key:"checkItem", label:"Checklist item", type:"text", required:true}, {key:"standard", label:"Standard / Requirement", type:"textarea", colSpan:2}, {key:"riskLevel", label:"Risk level", type:"select", optionCategory:"Risk level", required:true}, {key:"ownerDept", label:"Responsible department / Crew", type:"select", optionCategory:"Department / Crew"}, {key:"owner", label:"Owner", type:"text"}, {key:"inspectionDate", label:"Inspection date", type:"date", required:true}, {key:"status", label:"Status", type:"select", optionCategory:"Status", required:true}, {key:"inspectionResult", label:"Inspection result", type:"select", optionCategory:"Inspection result"}, {key:"needsRectification", label:"Needs corrective action?", type:"select", optionCategory:"Yes / No"}, {key:"rectificationDueDate", label:"Corrective deadline", type:"date"}, {key:"needsPhoto", label:"Photos required?", type:"select", optionCategory:"Yes / No"}, {key:"photoStatus", label:"Photo confirmation", type:"select", optionCategory:"Photo confirmation"}, {key:"issueNote", label:"Findings / Notes", type:"textarea", colSpan:2}, {key:"rectificationNo", label:"Corrective action ID", type:"text"}, {key:"completionDate", label:"Actual completion date", type:"date"}, {key:"reviewer", label:"Reviewer", type:"text"}, {key:"reviewConclusion", label:"Review conclusion", type:"select", optionCategory:"Review conclusion"}, {key:"overdueDays", label:"Overdue days", type:"number", readonly:true, hint:"Calculated from the corrective deadline and current status when saved."}, {key:"sourceVersion", label:"Data source / Version", type:"text"} ], photos: [ {key:"photoNo", label:"Photo ID", type:"text", required:true, codePrefix:"PH"}, {key:"inspectionNo", label:"Inspection ID", type:"text", required:true}, {key:"projectSite", label:"Project / Site", type:"text"}, {key:"scope", label:"Inspection scope", type:"select", optionCategory:"Inspection scope"}, {key:"checkItem", label:"Checklist item", type:"text"}, {key:"photoDate", label:"Photo date", type:"date"}, {key:"photoCount", label:"Photo count", type:"number", min:0}, {key:"confirmStatus", label:"Confirmation status", type:"select", optionCategory:"Photo confirmation"}, {key:"photoPath", label:"Photo link / Path", type:"text", colSpan:2}, {key:"uploader", label:"Uploader", type:"text"}, {key:"reviewOpinion", label:"Review opinion", type:"textarea", colSpan:2}, {key:"needsRetake", label:"Retake required?", type:"select", optionCategory:"Yes / No"}, {key:"retakeDueDate", label:"Retake deadline", type:"date"}, {key:"rectificationNo", label:"Related corrective action", type:"text"}, {key:"attachments", label:"Local attachments", type:"files", colSpan:2, hint:"Upload field photos or evidence. Files are stored as Base64 in the current browser IndexedDB."} ], rectifications: [ {key:"rectificationNo", label:"Corrective action ID", type:"text", required:true, codePrefix:"CA"}, {key:"inspectionNo", label:"Inspection ID", type:"text"}, {key:"projectSite", label:"Project / Site", type:"text", required:true}, {key:"businessScene", label:"Scenario", type:"select", optionCategory:"Scenario"}, {key:"issueDescription", label:"Issue description", type:"textarea", required:true, colSpan:2}, {key:"riskLevel", label:"Risk level", type:"select", optionCategory:"Risk level"}, {key:"ownerDept", label:"Responsible department / Crew", type:"select", optionCategory:"Department / Crew"}, {key:"owner", label:"Owner", type:"text"}, {key:"openedDate", label:"Opened date", type:"date"}, {key:"dueDate", label:"Corrective deadline", type:"date", required:true}, {key:"status", label:"Status", type:"select", optionCategory:"Status"}, {key:"priority", label:"Priority", type:"select", optionCategory:"Priority"}, {key:"correctiveAction", label:"Corrective measure", type:"textarea", colSpan:2}, {key:"needsPhotoEvidence", label:"Photo evidence required?", type:"select", optionCategory:"Yes / No"}, {key:"reviewDate", label:"Review date", type:"date"}, {key:"reviewer", label:"Reviewer", type:"text"}, {key:"closeConclusion", label:"Closure conclusion", type:"select", optionCategory:"Closure conclusion"}, {key:"closedDate", label:"Closure date", type:"date"}, {key:"overdueDays", label:"Overdue days", type:"number", readonly:true, hint:"Calculated automatically when saved."}, {key:"reminderStatus", label:"Reminder status", type:"text", readonly:true, hint:"Generated on save: Overdue, Due soon, or Normal."} ], monthlyPlans: [ {key:"month", label:"Month", type:"month", required:true}, {key:"projectSite", label:"Project / Site", type:"text", required:true}, {key:"businessScene", label:"Scenario", type:"select", optionCategory:"Scenario"}, {key:"scope", label:"Inspection scope", type:"select", optionCategory:"Inspection scope"}, {key:"plannedInspections", label:"Planned inspections", type:"number", min:0}, {key:"plannedReviews", label:"Planned reviews", type:"number", min:0}, {key:"plannedRectifications", label:"Planned corrective follow-ups", type:"number", min:0}, {key:"status", label:"Plan status", type:"select", optionCategory:"Status"}, {key:"owner", label:"Person in charge", type:"text"}, {key:"remarks", label:"Notes", type:"textarea", colSpan:2} ], weeklyPlans: [ {key:"weekStartDate", label:"Week start date", type:"date", required:true}, {key:"weekday", label:"Day of week", type:"select", values:["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]}, {key:"date", label:"Date", type:"date", required:true}, {key:"planType", label:"Type", type:"select", optionCategory:"Schedule type"}, {key:"scope", label:"Inspection scope", type:"select", optionCategory:"Inspection scope"}, {key:"plannedQuantity", label:"Planned quantity", type:"number", min:0}, {key:"focus", label:"Focus item", type:"textarea", colSpan:2}, {key:"owner", label:"Person in charge", type:"text"}, {key:"status", label:"Status", type:"select", optionCategory:"Status"}, {key:"remarks", label:"Notes", type:"textarea", colSpan:2} ], schedules: [ {key:"date", label:"Date", type:"date", required:true}, {key:"time", label:"Time", type:"time"}, {key:"eventType", label:"Schedule type", type:"select", optionCategory:"Schedule type"}, {key:"eventName", label:"Schedule item", type:"text", required:true}, {key:"scope", label:"Related scope", type:"select", optionCategory:"Inspection scope"}, {key:"participants", label:"Participants", type:"text"}, {key:"location", label:"Location", type:"text"}, {key:"status", label:"Status", type:"select", optionCategory:"Status"}, {key:"nextAction", label:"Next action", type:"textarea", colSpan:2}, {key:"relatedNo", label:"Related ID", type:"text"}, {key:"remarks", label:"Notes", type:"textarea", colSpan:2} ], checklistItems: [ {key:"businessScene", label:"Scenario", type:"select", optionCategory:"Scenario", required:true}, {key:"scope", label:"Inspection scope", type:"select", optionCategory:"Inspection scope", required:true}, {key:"checkItem", label:"Checklist item", type:"text", required:true}, {key:"standard", label:"Standard / Checkpoint", type:"textarea", colSpan:2}, {key:"riskLevel", label:"Risk level", type:"select", optionCategory:"Risk level"}, {key:"applicableStage", label:"Applicable phase", type:"select", optionCategory:"Project phase"}, {key:"needsPhoto", label:"Photo required", type:"select", optionCategory:"Yes / No"}, {key:"defaultOwnerRole", label:"Default owner role", type:"select", optionCategory:"Department / Crew"}, {key:"remarks", label:"Notes", type:"textarea", colSpan:2} ], options: [ {key:"category", label:"Category", type:"select", values:["Status","Scenario","Inspection scope","Risk level","Yes / No","Photo confirmation","Department / Crew","Schedule type","Priority","Inspection result","Review conclusion","Project phase","Closure conclusion"], required:true}, {key:"value", label:"Option value", type:"text", required:true}, {key:"sortOrder", label:"Sort order", type:"number", min:0}, {key:"active", label:"Active", type:"select", optionCategory:"Yes / No"}, {key:"remarks", label:"Notes", type:"textarea", colSpan:2} ] }; const MODULES = [ {id:"dashboard", label:"Dashboard", icon:"layout-dashboard", desc:"Metrics and risk overview"}, { id:"settings", store:"settings", label:"Basic Settings", icon:"settings", desc:"Company, project, and rules", idField:"settingKey", columns:["settingKey","settingValue","description","recommendedChange"], filterFields:["recommendedChange"], defaultSort:{key:"settingKey", dir:"asc"} }, { id:"inspections", store:"inspections", label:"Inspection Register", icon:"clipboard-check", desc:"Field inspection records", idField:"inspectionNo", codePrefix:"INS", columns:["inspectionNo","businessScene","scope","checkItem","riskLevel","owner","inspectionDate","status","inspectionResult","photoStatus","rectificationNo","overdueDays"], filterFields:["businessScene","scope","riskLevel","status","inspectionResult"], defaultSort:{key:"inspectionDate", dir:"desc"} }, { id:"photos", store:"photos", label:"Photo Log", icon:"camera", desc:"Photo evidence and review", idField:"photoNo", codePrefix:"PH", columns:["photoNo","inspectionNo","projectSite","scope","checkItem","photoDate","photoCount","confirmStatus","needsRetake","retakeDueDate","rectificationNo"], filterFields:["scope","confirmStatus","needsRetake"], defaultSort:{key:"photoDate", dir:"desc"} }, { id:"rectifications", store:"rectifications", label:"Corrective Action Tracker", icon:"wrench", desc:"Issue closure and overdue reminders", idField:"rectificationNo", codePrefix:"CA", columns:["rectificationNo","inspectionNo","businessScene","issueDescription","riskLevel","owner","openedDate","dueDate","status","priority","overdueDays","reminderStatus"], filterFields:["businessScene","riskLevel","status","priority","reminderStatus"], defaultSort:{key:"dueDate", dir:"asc"} }, { id:"monthlyPlans", store:"monthlyPlans", label:"Monthly Plan", icon:"calendar-days", desc:"Monthly inspection plan", columns:["month","projectSite","businessScene","scope","plannedInspections","plannedReviews","plannedRectifications","status","owner"], filterFields:["month","businessScene","scope","status"], defaultSort:{key:"month", dir:"desc"} }, { id:"weeklyPlans", store:"weeklyPlans", label:"Weekly Plan", icon:"calendar-range", desc:"Weekly and daily plan", columns:["weekStartDate","weekday","date","planType","scope","plannedQuantity","focus","owner","status"], filterFields:["weekStartDate","planType","scope","status"], defaultSort:{key:"date", dir:"asc"} }, { id:"schedules", store:"schedules", label:"Schedule", icon:"clock", desc:"Meetings, site entries, reviews, and deadline items", columns:["date","time","eventType","eventName","scope","participants","location","status","relatedNo"], filterFields:["eventType","scope","status"], defaultSort:{key:"date", dir:"asc"} }, { id:"checklistItems", store:"checklistItems", label:"Checklist Library", icon:"library", desc:"Standard checklist item library", columns:["businessScene","scope","checkItem","standard","riskLevel","applicableStage","needsPhoto","defaultOwnerRole"], filterFields:["businessScene","scope","riskLevel","applicableStage"], defaultSort:{key:"businessScene", dir:"asc"} }, { id:"options", store:"options", label:"Dropdown Options", icon:"list-filter", desc:"Option value maintenance", columns:["category","value","sortOrder","active","remarks"], filterFields:["category","active"], defaultSort:{key:"category", dir:"asc"} } ]; localizeRuntimeDefinitions(); const moduleById = Object.fromEntries(MODULES.map(m => [m.id, m])); let db = null; const state = { moduleId: location.hash ? location.hash.replace("#", "") : "dashboard", search: "", filters: {}, sort: {}, currentData: [], currentModule: null }; const $ = (selector) => document.querySelector(selector); const content = $("#content"); init(); async function init(){ localStorage.setItem(STORAGE_ENTITY_KEY, entityId); $("#dbName").textContent = DB_NAME; $("#entityInput").value = entityId; renderNav(); refreshIcons(); bindGlobalEvents(); try{ db = await openDatabase(); await ensureSeeded(); if(!moduleById[state.moduleId]) state.moduleId = "dashboard"; await navigate(state.moduleId, {replaceHash:true}); toast(`${ui("text.toast.systemConnected", "System connected")}: ${DB_NAME}`); }catch(error){ console.error(error); content.innerHTML = `

IndexedDB initialization failed
${escapeHtml(error.message || String(error))}

`; } } function sanitizeEntityId(value){ const cleaned = String(value || DEFAULT_ENTITY_ID).trim() .replace(/\s+/g, "_") .replace(/[^\u4e00-\u9fa5A-Za-z0-9_-]/g, "_") .replace(/^_+|_+$/g, ""); return cleaned || DEFAULT_ENTITY_ID; } function openDatabase(){ return new Promise((resolve, reject) => { const request = indexedDB.open(DB_NAME, DB_VERSION); request.onupgradeneeded = (event) => { const database = event.target.result; for(const storeName of ALL_STORES){ if(!database.objectStoreNames.contains(storeName)){ const store = database.createObjectStore(storeName, {keyPath:"id"}); store.createIndex("updatedAt", "updatedAt", {unique:false}); if(storeName === "inspections"){ store.createIndex("inspectionNo", "inspectionNo", {unique:false}); store.createIndex("status", "status", {unique:false}); store.createIndex("riskLevel", "riskLevel", {unique:false}); store.createIndex("inspectionDate", "inspectionDate", {unique:false}); } if(storeName === "rectifications"){ store.createIndex("rectificationNo", "rectificationNo", {unique:false}); store.createIndex("status", "status", {unique:false}); store.createIndex("dueDate", "dueDate", {unique:false}); store.createIndex("reminderStatus", "reminderStatus", {unique:false}); } if(storeName === "photos"){ store.createIndex("photoNo", "photoNo", {unique:false}); store.createIndex("confirmStatus", "confirmStatus", {unique:false}); } if(storeName === "options"){ store.createIndex("category", "category", {unique:false}); } } } }; request.onsuccess = () => resolve(request.result); request.onerror = () => reject(request.error); }); } function idbGet(storeName, id){ return new Promise((resolve, reject) => { const tx = db.transaction(storeName, "readonly"); const req = tx.objectStore(storeName).get(id); req.onsuccess = () => resolve(req.result || null); req.onerror = () => reject(req.error); }); } function idbGetAll(storeName){ return new Promise((resolve, reject) => { const tx = db.transaction(storeName, "readonly"); const req = tx.objectStore(storeName).getAll(); req.onsuccess = () => resolve(req.result || []); req.onerror = () => reject(req.error); }); } function idbPut(storeName, record){ return new Promise((resolve, reject) => { const tx = db.transaction(storeName, "readwrite"); tx.objectStore(storeName).put(record); tx.oncomplete = () => resolve(record); tx.onerror = () => reject(tx.error); }); } function idbBulkPut(storeName, records){ return new Promise((resolve, reject) => { const tx = db.transaction(storeName, "readwrite"); const store = tx.objectStore(storeName); for(const record of records) store.put(record); tx.oncomplete = () => resolve(); tx.onerror = () => reject(tx.error); }); } function idbDelete(storeName, id){ return new Promise((resolve, reject) => { const tx = db.transaction(storeName, "readwrite"); tx.objectStore(storeName).delete(id); tx.oncomplete = () => resolve(); tx.onerror = () => reject(tx.error); }); } function idbClear(storeName){ return new Promise((resolve, reject) => { const tx = db.transaction(storeName, "readwrite"); tx.objectStore(storeName).clear(); tx.oncomplete = () => resolve(); tx.onerror = () => reject(tx.error); }); } async function ensureSeeded(){ const seeded = await idbGet("meta", "seeded"); if(seeded) return; await seedAllData(); await idbPut("meta", {id:"seeded", seededAt:new Date().toISOString(), source:"Construction_Inspection_Checklist_Template.xlsx", version:"1.0"}); } async function seedAllData(){ for(const storeName of DATA_STORES){ const records = (SEED_DATA[storeName] || []).map((record, index) => normalizeSeedRecord(storeName, withSeedRecordId(storeName, {...record}, index))); await idbBulkPut(storeName, records); } } function bindGlobalEvents(){ $("#hamburger").addEventListener("click", openSidebar); $("#overlay").addEventListener("click", closeSidebar); $("#applyEntityBtn").addEventListener("click", applyEntityChange); $("#entityInput").addEventListener("keydown", (event) => { if(event.key === "Enter") applyEntityChange(); }); $("#exportJsonBtn").addEventListener("click", exportAllData); $("#importJsonBtn").addEventListener("click", () => $("#importFileInput").click()); $("#importFileInput").addEventListener("change", importAllData); $("#resetSeedBtn").addEventListener("click", resetSeedData); window.addEventListener("hashchange", () => { const target = location.hash.replace("#", "") || "dashboard"; if(moduleById[target]) navigate(target, {replaceHash:true}); }); document.addEventListener("keydown", (event) => { if(event.key === "Escape"){ closeModal(); closeSidebar(); } }); } function renderNav(){ const nav = $("#nav"); nav.innerHTML = MODULES.map(module => ` `).join(""); nav.addEventListener("click", (event) => { const button = event.target.closest("[data-nav]"); if(!button) return; navigate(button.dataset.nav); closeSidebar(); }); } function updateNavActive(){ document.querySelectorAll("[data-nav]").forEach(btn => { btn.classList.toggle("active", btn.dataset.nav === state.moduleId); }); } async function navigate(moduleId, options = {}){ state.moduleId = moduleId; state.search = ""; state.filters = {}; state.sort = {}; const module = moduleById[moduleId]; if(!options.replaceHash && location.hash.replace("#", "") !== moduleId){ const nextURL = `${location.pathname}${location.search}#${encodeURIComponent(moduleId)}`; history.replaceState(history.state, "", nextURL); } updateNavActive(); $("#pageTitle").textContent = module.label; $("#pageSubtitle").textContent = module.id === "dashboard" ? ui("text.dashboardSubtitle", "Live summary of inspections, corrective actions, photos, and plans") : `${module.desc} · ${ui("text.moduleSubtitleSuffix", "Supports add, view, edit, delete, and export")}`; content.innerHTML = `

${escapeHtml(ui("text.loadingModule", "Loading"))} ${escapeHtml(module.label)}...

`; if(moduleId === "dashboard"){ await renderDashboard(); }else{ await renderDataModule(module); } content.focus({preventScroll:true}); refreshIcons(); } function openSidebar(){ $("#sidebar").classList.add("open"); $("#overlay").classList.add("open"); } function closeSidebar(){ $("#sidebar").classList.remove("open"); $("#overlay").classList.remove("open"); } function applyEntityChange(){ const next = sanitizeEntityId($("#entityInput").value); if(!next) return; if(next === entityId){ toast(ui("text.toast.entityAlreadyActive", "This entityId is already active.")); return; } localStorage.setItem(STORAGE_ENTITY_KEY, next); const url = new URL(location.href); url.searchParams.set("entityId", next); location.href = url.toString(); } async function renderDashboard(){ const [settingsRaw, inspectionsRaw, photosRaw, rectificationsRaw, monthlyPlansRaw, weeklyPlansRaw, schedulesRaw] = await Promise.all([ idbGetAll("settings"), idbGetAll("inspections"), idbGetAll("photos"), idbGetAll("rectifications"), idbGetAll("monthlyPlans"), idbGetAll("weeklyPlans"), idbGetAll("schedules") ]); const settings = applyLocaleOverlayRows("settings", settingsRaw.map(r => normalizeRecord("settings", {...r}))); const inspections = applyLocaleOverlayRows("inspections", inspectionsRaw.map(r => normalizeRecord("inspections", {...r}))); const photos = applyLocaleOverlayRows("photos", photosRaw.map(r => normalizeRecord("photos", {...r}))); const rectifications = applyLocaleOverlayRows("rectifications", rectificationsRaw.map(r => normalizeRecord("rectifications", {...r}))); const monthlyPlans = applyLocaleOverlayRows("monthlyPlans", monthlyPlansRaw.map(r => normalizeRecord("monthlyPlans", {...r}))); const weeklyPlans = applyLocaleOverlayRows("weeklyPlans", weeklyPlansRaw.map(r => normalizeRecord("weeklyPlans", {...r}))); const schedules = applyLocaleOverlayRows("schedules", schedulesRaw.map(r => normalizeRecord("schedules", {...r}))); const settingsMap = Object.fromEntries(settings.map(s => [s.settingKey, s.settingValue])); const weekStart = startOfWeek(new Date()); const weekEnd = addDays(weekStart, 6); const isThisWeek = d => { const date = parseISODate(d); return date && date >= weekStart && date <= weekEnd; }; const totalInspections = inspections.length; const weeklyInspections = inspections.filter(r => isThisWeek(r.inspectionDate)).length; const needReview = inspections.filter(r => [ui("text.kpi.needsReview", "Needs review"),"Pending review"].includes(r.status) || ["Pending review","Failed"].includes(r.reviewConclusion)).length; const rectifying = rectifications.filter(r => !STATUS_CLOSED.has(r.status || "")).length; const overdue = rectifications.filter(r => Number(r.overdueDays || 0) > 0 && !STATUS_CLOSED.has(r.status || "")).length; const pendingPhotos = photos.filter(r => ["Pending review","Retake needed","Pending upload"].includes(r.confirmStatus || r.photoStatus || "") || r.needsRetake === "Yes").length; const closedRect = rectifications.filter(r => STATUS_CLOSED.has(r.status || "") || r.closeConclusion === "Closed").length; const closeRate = rectifications.length ? Math.round((closedRect / rectifications.length) * 100) : 0; const inspectionDist = distribution(inspections, "status"); const rectificationDist = distribution(rectifications, "status"); const riskDist = distribution(inspections, "riskLevel"); const overdueList = rectifications .filter(r => Number(r.overdueDays || 0) > 0 && !STATUS_CLOSED.has(r.status || "")) .sort((a,b) => compareValues(a.dueDate, b.dueDate, "asc")) .slice(0, 5); const photoList = photos .filter(r => ["Pending review","Retake needed","Pending upload"].includes(r.confirmStatus || "") || r.needsRetake === "Yes") .sort((a,b) => compareValues(a.retakeDueDate || a.photoDate, b.retakeDueDate || b.photoDate, "asc")) .slice(0, 5); const weeklyPlanList = weeklyPlans .sort((a,b) => compareValues(a.date, b.date, "asc")) .slice(0, 7); const scheduleList = schedules .sort((a,b) => compareValues(`${a.date || ""} ${a.time || ""}`, `${b.date || ""} ${b.time || ""}`, "asc")) .slice(0, 5); content.innerHTML = `

${escapeHtml(ui("text.dashboard.project", "Project"))}:${escapeHtml(settingsMap["Project name"] || "Not set")}　 ${escapeHtml(ui("text.dashboard.site", "Site"))}:${escapeHtml(settingsMap["Site / Zone"] || settingsMap["Project / Site"] || "Not set")}　 ${escapeHtml(ui("text.dashboard.personInCharge", "Person in charge"))}:${escapeHtml(settingsMap["Site owner"] || "Not set")}　 ${escapeHtml(ui("text.dashboard.dataIsolation", "Data isolation"))}:${escapeHtml(DB_NAME)}

${kpiCard(ui("text.kpi.inspections", "Inspections"), totalInspections, ui("text.kpi.inspectionsNote", "Total register rows"))} ${kpiCard(ui("text.kpi.thisWeek", "This week"), weeklyInspections, `${formatDate(weekStart)} - ${formatDate(weekEnd)}`)} ${kpiCard(ui("text.kpi.needsReview", "Needs review"), needReview, ui("text.kpi.needsReviewNote", "Pending review or failed items"))} ${kpiCard(ui("text.kpi.correctiveAction", "Corrective action"), rectifying, ui("text.kpi.correctiveActionNote", "Open corrective actions"))} ${kpiCard(ui("text.kpi.overdueCorrectiveActions", "Overdue corrective actions"), overdue, ui("text.kpi.overdueCorrectiveActionsNote", "Past corrective deadline"), overdue > 0 ? "red" : "green")} ${kpiCard(ui("text.kpi.correctiveClosureRate", "Corrective closure rate"), `${closeRate}%`, ui("text.kpi.correctiveClosureRateNote", "Closed / total corrective actions"))}

${escapeHtml(ui("text.dashboard.inspectionStatusDistribution", "Inspection status distribution"))}

${escapeHtml(ui("text.dashboard.inspectionStatusDistributionDesc", "Helps quickly identify planned, corrective, review, and closed states."))}

${renderBarList(inspectionDist)}

${escapeHtml(ui("text.dashboard.correctiveStatusDistribution", "Corrective status distribution"))}

${escapeHtml(ui("text.dashboard.correctiveStatusDistributionDesc", "Use reminder status for weekly and monthly closure tracking."))}

${renderBarList(rectificationDist)}

${escapeHtml(ui("text.dashboard.overdueCorrectiveActions", "Overdue corrective actions"))}

${escapeHtml(ui("text.dashboard.overdueCorrectiveActionsDesc", "Prioritize high-risk and P1/P2 items."))}

${renderMiniList(overdueList, "rectifications", ["rectificationNo","riskLevel","dueDate","owner"], ui("text.empty.noOverdueCorrectiveActions", "No overdue corrective actions."))}

${escapeHtml(ui("text.dashboard.photosPendingReview", "Photos pending review"))}

${escapeHtml(ui("text.dashboard.photosPendingReviewDesc", "Incomplete photos may block corrective-action closure."))}

${renderMiniList(photoList, "photos", ["photoNo","inspectionNo","confirmStatus","retakeDueDate"], ui("text.empty.noPhotosPendingReview", "No photos pending review or retake."))}

${escapeHtml(ui("text.dashboard.weeklyPlanSnapshot", "Weekly plan snapshot"))}

${escapeHtml(ui("text.dashboard.weeklyPlanSnapshotDesc", "Lists this week inspections, reviews, and schedule items by date."))}

${renderMiniList(weeklyPlanList, "weeklyPlans", ["weekday","date","planType","scope","owner"], ui("text.empty.noWeeklyPlans", "No weekly plans yet."))}

${escapeHtml(ui("text.dashboard.riskLevelDistribution", "Risk level distribution"))}

${escapeHtml(ui("text.dashboard.riskLevelDistributionDesc", "Helps discipline engineers prioritize reviews and spot checks."))}

${renderBarList(riskDist)}

${escapeHtml(ui("text.dashboard.upcomingItems", "Upcoming items"))}

${escapeHtml(ui("text.dashboard.upcomingItemsDesc", "Meetings, deliveries, reviews, and deadlines."))}

${renderMiniList(scheduleList, "schedules", ["date","time","eventType","eventName","relatedNo"], ui("text.empty.noScheduleItems", "No schedule items yet."))}

`; content.onclick = (event) => { const jump = event.target.closest("[data-jump]"); if(jump) navigate(jump.dataset.jump); }; } async function renderDataModule(module){ state.currentModule = module; state.currentData = applyLocaleOverlayRows(module.store, (await idbGetAll(module.store)).map(record => normalizeRecord(module.store, {...record}))); state.sort = {...(module.defaultSort || {})}; const fields = FIELD_DEFS[module.store]; const fieldLabels = Object.fromEntries(fields.map(f => [f.key, f.label])); content.innerHTML = `

${escapeHtml(module.icon)} ${escapeHtml(module.label)}

${escapeHtml(module.desc)}. ${escapeHtml(ui("text.modulePanelDescSuffix", "Each record supports add, view, edit, and delete. Data is stored in the IndexedDB database for the current entityId."))}

${module.columns.map(key => ` `).join("")}

	${escapeHtml(ui("text.table.actions", "Actions"))}

`; await renderFilterControls(module); updateTableView(); content.onclick = handleModuleClick; content.oninput = handleModuleInput; content.onchange = handleModuleChange; } async function renderFilterControls(module){ const row = $("#filterRow"); const optionsMap = await getOptionsMap(); const filters = module.filterFields || []; if(!filters.length){ row.innerHTML = ""; return; } row.innerHTML = filters.map(key => { const field = FIELD_DEFS[module.store].find(f => f.key === key) || {key, label:key}; const uniqueFromData = uniqueValues(state.currentData.map(r => r[key]).filter(Boolean)); const optionValues = uniqueValues([...(field.optionCategory ? (optionsMap[field.optionCategory] || []) : []), ...(field.values || []), ...uniqueFromData]); return ` `; }).join("") + ``; } function handleModuleInput(event){ if(event.target.id === "moduleSearch"){ state.search = event.target.value.trim(); updateTableView(); } } function handleModuleChange(event){ const filter = event.target.closest("[data-filter]"); if(!filter) return; state.filters[filter.dataset.filter] = filter.value; updateTableView(); } async function handleModuleClick(event){ const actionTarget = event.target.closest("[data-action]"); const sortTarget = event.target.closest("[data-sort]"); if(sortTarget){ const key = sortTarget.dataset.sort; if(state.sort.key === key) state.sort.dir = state.sort.dir === "asc" ? "desc" : "asc"; else state.sort = {key, dir:"asc"}; updateTableView(); return; } if(!actionTarget) return; const action = actionTarget.dataset.action; const id = actionTarget.dataset.id; const module = state.currentModule; if(action === "create") return openRecordModal(module.id, "create"); if(action === "view") return openDetailsModal(module.id, id); if(action === "edit") return openRecordModal(module.id, "edit", id); if(action === "delete") return deleteRecord(module, id); if(action === "export-csv") return exportModuleCsv(module); if(action === "clear-filters"){ state.filters = {}; state.search = ""; $("#moduleSearch").value = ""; document.querySelectorAll("[data-filter]").forEach(el => el.value = ""); updateTableView(); return; } if(action === "create-inspection-from-checklist") return createInspectionFromChecklist(id); if(action === "create-rectification-from-inspection") return createRectificationFromInspection(id); if(action === "close-rectification") return closeRectification(id); } function updateTableView(){ const module = state.currentModule; if(!module) return; let rows = getFilteredRows(module); if(state.sort.key){ rows = rows.sort((a,b) => compareValues(a[state.sort.key], b[state.sort.key], state.sort.dir)); } document.querySelectorAll("[data-sort-i]").forEach(span => { span.textContent = span.dataset.sortI === state.sort.key ? (state.sort.dir === "asc" ? "▲" : "▼") : ""; }); const tbody = $("#dataTbody"); if(!rows.length){ tbody.innerHTML = `

${escapeHtml(ui("text.empty.noMatchingRecords", "No matching records. Adjust filters or add a new record."))}

`; }else{ tbody.innerHTML = rows.map(record => renderTableRow(module, record)).join(""); } $("#resultSummary").textContent = `${ui("text.table.showing", "Showing")} ${rows.length} / ${state.currentData.length} ${ui("text.table.records", "records")}`; } function getFilteredRows(module){ const query = normalizeText(state.search || ""); return state.currentData.filter(record => { for(const [key, value] of Object.entries(state.filters)){ if(value && String(record[key] || "") !== value) return false; } if(!query) return true; return normalizeText(Object.values(record).join(" ")).includes(query); }); } function renderTableRow(module, record){ return ` ${module.columns.map(key => `${formatCell(module.store, key, record[key], record)}`).join("")}

${module.id === "checklistItems" ? `` : ""} ${module.id === "inspections" ? `` : ""} ${module.id === "rectifications" && !STATUS_CLOSED.has(record.status || "") ? `` : ""}

`; } function formatCell(storeName, key, value, record){ if(key === "attachments"){ const count = Array.isArray(value) ? value.length : 0; return count ? `${count} ${escapeHtml(ui("text.attachments", "attachments"))}` : `${escapeHtml(ui("text.none", "None"))}`; } if(value === undefined || value === null || value === "") return `—`; if(["status","confirmStatus","photoStatus","reminderStatus","inspectionResult","reviewConclusion","closeConclusion","active","recommendedChange","needsPhoto","needsRectification","needsRetake","needsPhotoEvidence"].includes(key)){ return badge(String(value)); } if(key === "riskLevel") return riskBadge(String(value)); if(key === "priority") return priorityBadge(String(value)); if(["overdueDays"].includes(key)){ const n = Number(value || 0); return n > 0 ? `${n} ${escapeHtml(ui("text.days", "days"))}` : `0 ${escapeHtml(ui("text.days", "days"))}`; } const text = String(value); if(text.length > 26){ return `${escapeHtml(text)}`; } return escapeHtml(text); } function badge(value){ let cls = "gray"; if(["Completed","Closed","Passed","Pass","Confirmed","Normal","Yes","Active"].includes(value)) cls = "green"; else if(["Overdue","Failed","Failed","Retake needed","No"].includes(value)) cls = "red"; else if([ui("text.kpi.needsReview", "Needs review"),"Pending review","Pending review",ui("text.kpi.correctiveAction", "Corrective action"),"In progress","Due soon"].includes(value)) cls = "yellow"; else if(["Planned","Not started","Pending upload"].includes(value)) cls = "blue"; else if(["Paused","Cancel","Not applicable"].includes(value)) cls = "gray"; return `${escapeHtml(value)}`; } function riskBadge(value){ const cls = value === "Critical" || value === "High" ? "red" : value === "Medium" ? "yellow" : value === "Low" ? "green" : "gray"; return `${escapeHtml(value)}`; } function priorityBadge(value){ const cls = value.includes("P1") ? "red" : value.includes("P2") ? "yellow" : value.includes("P3") ? "blue" : "gray"; return `${escapeHtml(value)}`; } async function openRecordModal(moduleId, mode, id = null, preset = {}){ const module = moduleById[moduleId]; const fields = FIELD_DEFS[module.store]; const optionsMap = await getOptionsMap(); const original = mode === "edit" ? (await idbGet(module.store, id)) : null; const record = mode === "edit" ? normalizeRecord(module.store, {...original}) : await buildDefaultRecord(module, preset); const title = mode === "edit" ? `${ui("text.action.edit", "Edit")} ${module.label}` : `${ui("text.action.add", "Add")} ${module.label}`; $("#modalRoot").innerHTML = ` `; bindModalClose(); refreshIcons(); $("#recordForm").addEventListener("submit", async (event) => { event.preventDefault(); await saveRecordFromForm(module, fields, mode, record); }); } function renderFormField(field, record, optionsMap){ const value = record[field.key] ?? ""; const id = `field_${field.key}`; const required = field.required ? "required" : ""; const readonly = field.readonly ? "readonly" : ""; const requiredDot = field.required ? `*` : ""; const span = field.colSpan === 2 ? "span-2" : ""; const hint = field.hint ? `

${escapeHtml(field.hint)}

` : ""; const common = `id="${escapeAttr(id)}" name="${escapeAttr(field.key)}" ${required} ${readonly} ${field.readonly ? "class='readonly-field'" : ""}`; let control = ""; if(field.type === "textarea"){ control = ``; }else if(field.type === "select"){ const opts = uniqueValues([...(field.values || []), ...(field.optionCategory ? (optionsMap[field.optionCategory] || []) : []), value].filter(v => v !== undefined && v !== null && v !== "")); control = ``; }else if(field.type === "files"){ const attachments = Array.isArray(record[field.key]) ? record[field.key] : []; control = ` ${attachments.length ? `

${attachments.map((att, index) => ` ${escapeHtml(att.name || `Attachment ${index+1}`)} (${formatBytes(att.size || 0)})`).join("")}

${escapeHtml(ui("text.clearExistingAttachments", "Clear existing attachments"))} ` : `

No saved attachments.

`} `; }else{ const min = field.min !== undefined ? `min="${escapeAttr(field.min)}"` : ""; control = ``; } return `

${escapeHtml(field.label)} ${requiredDot} ${control} ${hint}

`; } async function saveRecordFromForm(module, fields, mode, existingRecord){ const form = $("#recordForm"); const formData = new FormData(form); let next = {...existingRecord}; for(const field of fields){ if(field.type === "files"){ const clear = formData.get(`${field.key}__clear`) === "1"; const input = form.querySelector(`input[name="${cssEscape(field.key)}"]`); const files = input ? Array.from(input.files || []) : []; const newAttachments = files.length ? await Promise.all(files.map(readFileAsAttachment)) : []; const previous = clear ? [] : (Array.isArray(existingRecord[field.key]) ? existingRecord[field.key] : []); next[field.key] = [...previous, ...newAttachments]; if(field.key === "attachments" && newAttachments.length && (!next.photoCount || Number(next.photoCount) < next[field.key].length)){ next.photoCount = next[field.key].length; } continue; } let value = formData.get(field.key); if(field.type === "number"){ value = value === "" || value === null ? "" : Number(value); }else{ value = value === null ? "" : String(value).trim(); } next[field.key] = value; } const now = new Date().toISOString(); if(mode === "create"){ next.id = deriveRecordId(module, next); next.createdAt = now; } next.updatedAt = now; next = normalizeRecord(module.store, next); await idbPut(module.store, next); closeModal(); toast(mode === "create" ? ui("text.toast.recordAdded", "Record added.") : ui("text.toast.recordSaved", "Record saved.")); await renderDataModule(module); } async function openDetailsModal(moduleId, id){ const module = moduleById[moduleId]; const record = applyLocaleOverlayRecord(module.store, normalizeRecord(module.store, {...(await idbGet(module.store, id))})); const fields = FIELD_DEFS[module.store]; $("#modalRoot").innerHTML = ` `; bindModalClose(); refreshIcons(); $("#modalRoot").querySelector("[data-action='edit-from-view']").addEventListener("click", () => openRecordModal(moduleId, "edit", record.id)); } function renderDetailItem(field, value, record){ let display = ""; if(field.type === "files"){ const attachments = Array.isArray(value) ? value : []; display = attachments.length ? `

${attachments.map((att, index) => ` ${escapeHtml(att.name || `Attachment ${index+1}`)} (${formatBytes(att.size || 0)})`).join("")}

` : "—"; }else{ display = formatDetailValue(value); } return `

${escapeHtml(field.label)}

${display}

`; } function formatDetailValue(value){ if(value === undefined || value === null || value === "") return "—"; return escapeHtml(String(value)).replace(/\n/g, "
"); } function bindModalClose(){ $("#modalRoot").querySelectorAll("[data-modal-close]").forEach(btn => btn.addEventListener("click", closeModal)); $("#modalRoot").querySelector(".modal-backdrop").addEventListener("click", (event) => { if(event.target.classList.contains("modal-backdrop")) closeModal(); }); } function closeModal(){ $("#modalRoot").innerHTML = ""; } async function buildDefaultRecord(module, preset = {}){ const settings = await getSettingsMap(); const today = TODAY(); const defaultDue = addDays(parseISODate(today), Number(settings["Default corrective deadline in days"] || 3)); const base = { id: randomId(), createdAt: new Date().toISOString(), updatedAt: new Date().toISOString() }; if(module.store === "settings"){ return {...base, settingKey:"New setting", settingValue:"", recommendedChange:"Yes", ...preset}; } if(module.store === "inspections"){ return normalizeRecord(module.store, { ...base, inspectionNo: await generateCode(module.store, "inspectionNo", "INS"), company: settings["Company name"] || "", projectSite: settings["Site / Zone"] || settings["Project name"] || "", businessScene: "", scope: "", area: "", checkItem: "", standard: "", riskLevel: "Medium", ownerDept: settings["Site owner"] ? "Safety crew" : "", owner: settings["Site owner"] || "", inspectionDate: today, status: "Planned", inspectionResult: "Pending review", needsRectification: "No", rectificationDueDate: "", needsPhoto: "Yes", photoStatus: "Pending upload", reviewConclusion: "Pending review", overdueDays: 0, sourceVersion: "Web system", ...preset }); } if(module.store === "photos"){ return {...base, photoNo: await generateCode(module.store, "photoNo", "PH"), photoDate: today, photoCount: 0, confirmStatus:"Pending upload", needsRetake:"No", attachments:[], ...preset}; } if(module.store === "rectifications"){ return normalizeRecord(module.store, { ...base, rectificationNo: await generateCode(module.store, "rectificationNo", "CA"), projectSite: settings["Site / Zone"] || settings["Project name"] || "", openedDate: today, dueDate: toISODate(defaultDue), status: ui("text.kpi.correctiveAction", "Corrective action"), priority: "P3-Medium", needsPhotoEvidence: "Yes", closeConclusion: "Open", overdueDays: 0, reminderStatus: "Normal", ...preset }); } if(module.store === "monthlyPlans"){ return {...base, month: today.slice(0,7), projectSite: settings["Site / Zone"] || settings["Project name"] || "", status:"Planned", plannedInspections:0, plannedReviews:0, plannedRectifications:0, ...preset}; } if(module.store === "weeklyPlans"){ const week = startOfWeek(new Date()); return {...base, weekStartDate: toISODate(week), weekday: weekdayName(new Date()), date: today, planType:"Inspection", plannedQuantity:1, status:"Planned", ...preset}; } if(module.store === "schedules"){ return {...base, date: today, time:"09:00", eventType:"Schedule item", status:"Planned", ...preset}; } if(module.store === "checklistItems"){ return {...base, businessScene:"Daily patrol", riskLevel:"Medium", needsPhoto:"Yes", applicableStage:"All phases", ...preset}; } if(module.store === "options"){ const options = await idbGetAll("options"); return {...base, category:"Status", value:"", sortOrder:options.length + 1, active:"Yes", remarks:"", ...preset}; } return {...base, ...preset}; } function deriveRecordId(module, record){ const idField = module.idField; if(idField && record[idField]) return String(record[idField]); return randomId(); } async function generateCode(storeName, fieldKey, prefix){ const records = await idbGetAll(storeName); let max = 0; for(const record of records){ const value = String(record[fieldKey] || ""); const match = value.match(new RegExp(`^${prefix}-(\\d+)$`)); if(match) max = Math.max(max, Number(match[1])); } return `${prefix}-${String(max + 1).padStart(4, "0")}`; } async function deleteRecord(module, id){ const record = await idbGet(module.store, id); if(!record) return toast("The record does not exist or has been deleted."); const label = module.idField ? record[module.idField] : id; if(!confirm(`Delete ${module.label} record: ${label || id}? This action removes it from IndexedDB.`)) return; await idbDelete(module.store, id); toast("Record deleted."); await renderDataModule(module); } async function createInspectionFromChecklist(checklistId){ const itemRaw = await idbGet("checklistItems", checklistId); const item = itemRaw ? applyLocaleOverlayRecord("checklistItems", itemRaw) : null; if(!item) return toast("Checklist item not found."); const settings = await getSettingsMap(); const module = moduleById.inspections; const preset = { businessScene:item.businessScene || "", scope:item.scope || "", checkItem:item.checkItem || "", standard:item.standard || "", riskLevel:item.riskLevel || "Medium", ownerDept:item.defaultOwnerRole || "", owner:settings["Site owner"] || "", needsPhoto:item.needsPhoto || "Yes", issueNote:item.remarks || "", status:"Planned", inspectionResult:"Pending review", photoStatus:item.needsPhoto === "No" ? "Not applicable" : "Pending upload" }; await openRecordModal(module.id, "create", null, preset); } async function createRectificationFromInspection(inspectionId){ const inspectionRaw = await idbGet("inspections", inspectionId); const inspection = inspectionRaw ? applyLocaleOverlayRecord("inspections", inspectionRaw) : null; if(!inspection) return toast("Inspection record not found."); const priority = inspection.riskLevel === "High" || inspection.riskLevel === "Critical" ? "P1-Urgent" : inspection.riskLevel === "Medium" ? "P2-High" : "P4-Low"; const preset = { inspectionNo:inspection.inspectionNo || "", projectSite:inspection.projectSite || "", businessScene:inspection.businessScene || "", issueDescription:inspection.issueNote || `${inspection.checkItem || "Inspection item"} requires corrective action.`, riskLevel:inspection.riskLevel || "Medium", ownerDept:inspection.ownerDept || "", owner:inspection.owner || "", dueDate:inspection.rectificationDueDate || undefined, priority, needsPhotoEvidence:inspection.needsPhoto || "Yes" }; await openRecordModal("rectifications", "create", null, preset); } async function closeRectification(id){ const record = await idbGet("rectifications", id); if(!record) return toast("Corrective action not found."); if(!confirm(`Close corrective action ${record.rectificationNo || id}?`)) return; const next = normalizeRecord("rectifications", { ...record, status:"Closed", closeConclusion:"Closed", closedDate:TODAY(), reminderStatus:"Normal", overdueDays:0, updatedAt:new Date().toISOString() }); await idbPut("rectifications", next); toast("Corrective action closed."); await renderDataModule(moduleById.rectifications); } function normalizeRecord(storeName, record){ if(!record.id) record.id = randomId(); if(storeName === "inspections"){ record.overdueDays = computeOverdueDays(record.rectificationDueDate, record.status); } if(storeName === "rectifications"){ record.overdueDays = computeOverdueDays(record.dueDate, record.status); record.reminderStatus = computeReminderStatus(record.dueDate, record.status, record.overdueDays); } if(storeName === "photos"){ if(!Array.isArray(record.attachments)) record.attachments = []; if(record.photoCount === "" || record.photoCount === undefined || record.photoCount === null) record.photoCount = record.attachments.length || 0; } if(!record.createdAt) record.createdAt = new Date().toISOString(); if(!record.updatedAt) record.updatedAt = new Date().toISOString(); return record; } function computeOverdueDays(dueDate, status){ if(!dueDate || STATUS_CLOSED.has(status || "")) return 0; const due = parseISODate(dueDate); if(!due) return 0; const today = parseISODate(TODAY()); return Math.max(0, Math.floor((today - due) / 86400000)); } function computeReminderStatus(dueDate, status, overdueDays){ if(STATUS_CLOSED.has(status || "")) return "Normal"; if(Number(overdueDays || 0) > 0) return "Overdue"; const due = parseISODate(dueDate); if(!due) return "Normal"; const today = parseISODate(TODAY()); const days = Math.ceil((due - today) / 86400000); if(days <= 1) return "Due soon"; return "Normal"; } async function getSettingsMap(){ const settings = applyLocaleOverlayRows("settings", (await idbGetAll("settings")).map(record => normalizeRecord("settings", {...record}))); return Object.fromEntries(settings.map(s => [s.settingKey, s.settingValue])); } async function getOptionsMap(){ const options = applyLocaleOverlayRows("options", (await idbGetAll("options")).map(record => normalizeRecord("options", {...record}))); const map = {}; for(const option of options){ if(option.active === "No") continue; if(!option.category || !option.value) continue; if(!map[option.category]) map[option.category] = []; map[option.category].push(option.value); } for(const key of Object.keys(map)) map[key] = uniqueValues(map[key]); return map; } function getFieldLabel(storeName, key){ const field = (FIELD_DEFS[storeName] || []).find(f => f.key === key); return field ? field.label : key; } function getFilteredExportRows(module){ return getFilteredRows(module).map(row => ({...row})); } function exportModuleCsv(module){ const rows = getFilteredExportRows(module); const fields = FIELD_DEFS[module.store].filter(f => f.type !== "files"); const header = fields.map(f => f.label); const body = rows.map(record => fields.map(f => csvCell(record[f.key]))); const csv = "\ufeff" + [header.map(csvCell).join(","), ...body.map(row => row.join(","))].join("\n"); downloadText(`${entityId}_${module.label}_${TODAY()}.csv`, csv, "text/csv;charset=utf-8"); } async function exportAllData(){ const data = {}; for(const storeName of DATA_STORES) data[storeName] = await idbGetAll(storeName); const payload = { entityId, databaseName: DB_NAME, exportedAt: new Date().toISOString(), source: "Construction Inspection Checklist Web System", data }; downloadText(`${entityId}_construction_inspection_system_data_${TODAY()}.json`, JSON.stringify(payload, null, 2), "application/json;charset=utf-8"); toast("JSON data exported."); } async function importAllData(event){ const file = event.target.files && event.target.files[0]; event.target.value = ""; if(!file) return; try{ const text = await file.text(); const payload = JSON.parse(text); const data = payload.data || payload; if(!DATA_STORES.some(store => Array.isArray(data[store]))){ throw new Error("No importable data tables were found in the JSON file."); } if(!confirm("Importing will clear the current entityId data and replace it with the imported content. Continue?")) return; for(const storeName of DATA_STORES) await idbClear(storeName); for(const storeName of DATA_STORES){ const records = Array.isArray(data[storeName]) ? data[storeName].map(r => normalizeRecord(storeName, {...r})) : []; await idbBulkPut(storeName, records); } await idbPut("meta", {id:"seeded", seededAt:new Date().toISOString(), source:"import", version:"imported"}); toast("Import complete."); await navigate(state.moduleId, {replaceHash:true}); }catch(error){ console.error(error); toast(`Import failed: ${error.message || error}`); } } async function resetSeedData(){ if(!confirm("Reset to the Excel template sample data? All data under the current entityId will be cleared.")) return; for(const storeName of DATA_STORES) await idbClear(storeName); await seedAllData(); await idbPut("meta", {id:"seeded", seededAt:new Date().toISOString(), source:"reset", version:"1.0"}); toast("Sample template data has been restored."); await navigate(state.moduleId, {replaceHash:true}); } function kpiCard(label, value, note, tone = ""){ const extra = tone === "red" ? "style='border-color:#fecaca'" : tone === "green" ? "style='border-color:#bbf7d0'" : ""; return `

${escapeHtml(label)}

${escapeHtml(value)}

${escapeHtml(note)}

`; } function distribution(records, key){ const map = new Map(); for(const record of records){ const value = record[key] || "Not set"; map.set(value, (map.get(value) || 0) + 1); } return Array.from(map.entries()).map(([label, count]) => ({label, count})).sort((a,b) => b.count - a.count); } function renderBarList(items){ if(!items.length) return `

${escapeHtml(ui("text.empty.noDataYet", "No data yet."))}

`; const total = items.reduce((sum, item) => sum + item.count, 0) || 1; return `

${items.map(item => { const pct = Math.round((item.count / total) * 100); return `

${escapeHtml(item.label)}

${item.count}

`; }).join("")}

`; } function renderMiniList(records, moduleId, keys, emptyText){ if(!records.length) return `

${escapeHtml(emptyText)}

`; const module = moduleById[moduleId]; return `

${records.map(record => `

${escapeHtml(record[keys[0]] || record[module.idField] || record.id)}

${keys.slice(1).map(key => `${escapeHtml(getFieldLabel(module.store, key))}: ${stripTags(formatCell(module.store, key, record[key], record))}`).join("")}

`).join("")}

`; } function readFileAsAttachment(file){ return new Promise((resolve, reject) => { const reader = new FileReader(); reader.onload = () => resolve({ id: randomId(), name:file.name, type:file.type, size:file.size, lastModified:file.lastModified, data:reader.result, uploadedAt:new Date().toISOString() }); reader.onerror = () => reject(reader.error); reader.readAsDataURL(file); }); } function startOfWeek(date){ const d = new Date(date); d.setHours(0,0,0,0); const day = d.getDay() || 7; d.setDate(d.getDate() - day + 1); return d; } function addDays(date, days){ const d = new Date(date); d.setDate(d.getDate() + Number(days || 0)); return d; } function toISODate(date){ const d = new Date(date); if(Number.isNaN(d.getTime())) return ""; const tz = new Date(d.getTime() - d.getTimezoneOffset() * 60000); return tz.toISOString().slice(0,10); } function parseISODate(value){ if(!value) return null; const d = new Date(`${value}T00:00:00`); return Number.isNaN(d.getTime()) ? null : d; } function formatDate(date){ return toISODate(date); } function weekdayName(date){ const names = ["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]; return names[new Date(date).getDay()]; } function compareValues(a, b, dir = "asc"){ const av = a === undefined || a === null ? "" : a; const bv = b === undefined || b === null ? "" : b; const an = Number(av); const bn = Number(bv); let result; if(av !== "" && bv !== "" && !Number.isNaN(an) && !Number.isNaN(bn)) result = an - bn; else result = String(av).localeCompare(String(bv), "zh-Hans-CN", {numeric:true, sensitivity:"base"}); return dir === "desc" ? -result : result; } function uniqueValues(values){ return Array.from(new Set(values.map(v => String(v)).filter(v => v !== ""))).sort((a,b) => a.localeCompare(b, "zh-Hans-CN", {numeric:true})); } function normalizeText(text){ return String(text || "").toLowerCase().replace(/\s+/g, " "); } function escapeHtml(value){ return String(value ?? "").replace(/[&<>"']/g, char => ({ "&":"&", "<":"<", ">":">", '"':""", "'":"'" }[char])); } function escapeAttr(value){ return escapeHtml(value); } function stripTags(html){ return String(html || "").replace(/<[^>]+>/g, ""); } function cssEscape(value){ if(window.CSS && typeof window.CSS.escape === "function") return window.CSS.escape(value); return String(value).replace(/["\\]/g, "\\$&"); } function csvCell(value){ if(value === undefined || value === null) value = ""; if(Array.isArray(value)) value = JSON.stringify(value); const text = String(value).replace(/"/g, '""'); return `"${text}"`; } function downloadText(filename, text, type){ const blob = new Blob([text], {type}); const url = URL.createObjectURL(blob); const link = document.createElement("a"); link.href = url; link.download = filename; document.body.appendChild(link); link.click(); link.remove(); setTimeout(() => URL.revokeObjectURL(url), 2000); } function formatBytes(bytes){ const n = Number(bytes || 0); if(!n) return "0 B"; const units = ["B","KB","MB","GB"]; let value = n; let i = 0; while(value >= 1024 && i < units.length - 1){ value /= 1024; i += 1; } return `${value.toFixed(value >= 10 || i === 0 ? 0 : 1)} ${units[i]}`; } function randomId(){ if(window.crypto && typeof window.crypto.randomUUID === "function") return window.crypto.randomUUID(); return `id_${Date.now()}_${Math.random().toString(16).slice(2)}`; } function toast(message){ const root = $("#toast"); const item = document.createElement("div"); item.className = "toast-item"; item.textContent = message; root.appendChild(item); setTimeout(() => { item.style.opacity = "0"; item.style.transform = "translateY(8px)"; setTimeout(() => item.remove(), 260); }, 3300); } function applyLocaleOverlayRows(storeName, records){ return records.map((record, index) => applyLocaleOverlayRecord(storeName, record, index)); } function applyLocaleOverlayRecord(storeName, record, index = -1){ if(!record) return record; const overlay = localeOverlayForRecord(storeName, record, index); return overlay ? {...record, ...overlay} : record; } function localeOverlayForRecord(storeName, record, index = -1){ const rows = LOCALE_SEED_OVERLAY[storeName]; if(!rows) return null; const id = recordIdentity(record); if(Array.isArray(rows)){ const seedRows = SEED_DATA[storeName] || []; const seedIndex = id ? seedRows.findIndex(seed => recordIdentity(seed) === id) : -1; const overlayIndex = seedIndex >= 0 ? seedIndex : index; const overlay = overlayIndex >= 0 ? rows[overlayIndex] : null; return isPlainObject(overlay) ? overlay : null; } if(isPlainObject(rows)){ const overlay = id ? rows[id] : null; return isPlainObject(overlay) ? overlay : null; } return null; } function withSeedRecordId(storeName, record, index){ if(record.id || record.record_id) return record; return {...record, id:`${storeName}_${String(index + 1).padStart(4, "0")}`}; } function recordIdentity(record){ return record && (record.id || record.record_id) ? String(record.id || record.record_id) : ""; } function isPlainObject(value){ return Boolean(value) && typeof value === "object" && !Array.isArray(value); } function normalizeSeedRecord(storeName, record){ const hadReminderStatus = Object.prototype.hasOwnProperty.call(record, "reminderStatus"); const normalized = normalizeRecord(storeName, record); if(storeName === "rectifications" && !hadReminderStatus) delete normalized.reminderStatus; return normalized; } function ui(path, fallback = ""){ const value = uiPath(path); return value === undefined || value === null || value === "" ? fallback : value; } function uiList(path, fallback = []){ const value = uiPath(path); if(Array.isArray(value)) return value; if(typeof value === "string" && value.trim()) return value.split("|").map(item => item.trim()).filter(Boolean); return fallback; } function uiPath(path){ const parts = String(path).split(/[\/.]+/).filter(Boolean); if(parts.length && String(parts[0]).toLowerCase() === "ui") parts.shift(); return parts.reduce((current, part) => { if(!current) return undefined; if(Object.prototype.hasOwnProperty.call(current, part)) return current[part]; const titlePart = part ? part.charAt(0).toUpperCase() + part.slice(1) : part; if(Object.prototype.hasOwnProperty.call(current, titlePart)) return current[titlePart]; const lowerPart = String(part).toLowerCase(); if(Object.prototype.hasOwnProperty.call(current, lowerPart)) return current[lowerPart]; return undefined; }, LOCALE_UI); } function uiCategory(value){ return ui(`optionCategories.${value}`, value); } function localizeRuntimeDefinitions(){ for(const module of MODULES){ const localized = uiPath(`modules.${module.id}`) || {}; if(localized.label) module.label = localized.label; if(localized.desc) module.desc = localized.desc; } for(const [storeName, fields] of Object.entries(FIELD_DEFS)){ for(const field of fields){ const localized = uiPath(`fields.${storeName}.${field.key}`) || {}; if(localized.label) field.label = localized.label; if(localized.hint) field.hint = localized.hint; if(field.optionCategory) field.optionCategory = uiCategory(field.optionCategory); } } } function refreshIcons(){ if(window.lucide) window.lucide.createIcons(); } })();