(() => { "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 = "constructionEquipmentInspection.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_equipment_inspection_log_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:"settingKey", type:"text", required:true, colSpan:1}, {key:"settingValue", label:"settingValue", type:"text", required:true, colSpan:1}, {key:"description", label:"description", type:"textarea", colSpan:2}, {key:"recommendedChange", label:"recommendedChange", type:"select", optionCategory:"opt_category_yes_no", colSpan:1} ], inspections: [ {key:"inspectionNo", label:"inspectionNo", type:"text", required:true, codePrefix:"INS"}, {key:"company", label:"company", type:"text", required:true}, {key:"projectSite", label:"projectSite", type:"text", required:true}, {key:"businessScene", label:"businessScene", type:"select", optionCategory:"opt_category_scenario", required:true}, {key:"scope", label:"scope", type:"select", optionCategory:"opt_category_inspection_scope", required:true}, {key:"area", label:"area", type:"text"}, {key:"checkItem", label:"checkItem", type:"text", required:true}, {key:"standard", label:"standard", type:"textarea", colSpan:2}, {key:"riskLevel", label:"riskLevel", type:"select", optionCategory:"opt_category_risk_level", required:true}, {key:"ownerDept", label:"ownerDept", type:"select", optionCategory:"opt_category_department_crew"}, {key:"owner", label:"owner", type:"text"}, {key:"inspectionDate", label:"inspectionDate", type:"date", required:true}, {key:"status", label:"status", type:"select", optionCategory:"opt_category_status", required:true}, {key:"inspectionResult", label:"inspectionResult", type:"select", optionCategory:"opt_category_inspection_result"}, {key:"needsRectification", label:"needsRectification", type:"select", optionCategory:"opt_category_yes_no"}, {key:"rectificationDueDate", label:"rectificationDueDate", type:"date"}, {key:"needsPhoto", label:"needsPhoto", type:"select", optionCategory:"opt_category_yes_no"}, {key:"photoStatus", label:"photoStatus", type:"select", optionCategory:"opt_category_photo_confirmation"}, {key:"issueNote", label:"issueNote", type:"textarea", colSpan:2}, {key:"rectificationNo", label:"rectificationNo", type:"text"}, {key:"completionDate", label:"completionDate", type:"date"}, {key:"reviewer", label:"reviewer", type:"text"}, {key:"reviewConclusion", label:"reviewConclusion", type:"select", optionCategory:"opt_category_review_conclusion"}, {key:"overdueDays", label:"overdueDays", type:"number", readonly:true, hint:""}, {key:"sourceVersion", label:"sourceVersion", type:"text"} ], photos: [ {key:"photoNo", label:"photoNo", type:"text", required:true, codePrefix:"PH"}, {key:"inspectionNo", label:"inspectionNo", type:"text", required:true}, {key:"projectSite", label:"projectSite", type:"text"}, {key:"scope", label:"scope", type:"select", optionCategory:"opt_category_inspection_scope"}, {key:"checkItem", label:"checkItem", type:"text"}, {key:"photoDate", label:"photoDate", type:"date"}, {key:"photoCount", label:"photoCount", type:"number", min:0}, {key:"confirmStatus", label:"confirmStatus", type:"select", optionCategory:"opt_category_photo_confirmation"}, {key:"photoPath", label:"photoPath", type:"text", colSpan:2}, {key:"uploader", label:"uploader", type:"text"}, {key:"reviewOpinion", label:"reviewOpinion", type:"textarea", colSpan:2}, {key:"needsRetake", label:"needsRetake", type:"select", optionCategory:"opt_category_yes_no"}, {key:"retakeDueDate", label:"retakeDueDate", type:"date"}, {key:"rectificationNo", label:"rectificationNo", type:"text"}, {key:"attachments", label:"attachments", type:"files", colSpan:2, hint:""} ], rectifications: [ {key:"rectificationNo", label:"rectificationNo", type:"text", required:true, codePrefix:"CA"}, {key:"inspectionNo", label:"inspectionNo", type:"text"}, {key:"projectSite", label:"projectSite", type:"text", required:true}, {key:"businessScene", label:"businessScene", type:"select", optionCategory:"opt_category_scenario"}, {key:"issueDescription", label:"issueDescription", type:"textarea", required:true, colSpan:2}, {key:"riskLevel", label:"riskLevel", type:"select", optionCategory:"opt_category_risk_level"}, {key:"ownerDept", label:"ownerDept", type:"select", optionCategory:"opt_category_department_crew"}, {key:"owner", label:"owner", type:"text"}, {key:"openedDate", label:"openedDate", type:"date"}, {key:"dueDate", label:"dueDate", type:"date", required:true}, {key:"status", label:"status", type:"select", optionCategory:"opt_category_status"}, {key:"priority", label:"priority", type:"select", optionCategory:"opt_category_priority"}, {key:"correctiveAction", label:"correctiveAction", type:"textarea", colSpan:2}, {key:"needsPhotoEvidence", label:"needsPhotoEvidence", type:"select", optionCategory:"opt_category_yes_no"}, {key:"reviewDate", label:"reviewDate", type:"date"}, {key:"reviewer", label:"reviewer", type:"text"}, {key:"closeConclusion", label:"closeConclusion", type:"select", optionCategory:"opt_category_closure_conclusion"}, {key:"closedDate", label:"closedDate", type:"date"}, {key:"overdueDays", label:"overdueDays", type:"number", readonly:true, hint:""}, {key:"reminderStatus", label:"reminderStatus", type:"text", readonly:true, hint:""} ], monthlyPlans: [ {key:"month", label:"month", type:"month", required:true}, {key:"projectSite", label:"projectSite", type:"text", required:true}, {key:"businessScene", label:"businessScene", type:"select", optionCategory:"opt_category_scenario"}, {key:"scope", label:"scope", type:"select", optionCategory:"opt_category_inspection_scope"}, {key:"plannedInspections", label:"plannedInspections", type:"number", min:0}, {key:"plannedReviews", label:"plannedReviews", type:"number", min:0}, {key:"plannedRectifications", label:"plannedRectifications", type:"number", min:0}, {key:"status", label:"status", type:"select", optionCategory:"opt_category_status"}, {key:"owner", label:"owner", type:"text"}, {key:"remarks", label:"remarks", type:"textarea", colSpan:2} ], weeklyPlans: [ {key:"weekStartDate", label:"weekStartDate", type:"date", required:true}, {key:"weekday", label:"weekday", type:"select", values:uiList("lists.weekdaysMondayFirst", ["weekday.monday","weekday.tuesday","weekday.wednesday","weekday.thursday","weekday.friday","weekday.saturday","weekday.sunday"])}, {key:"date", label:"date", type:"date", required:true}, {key:"planType", label:"planType", type:"select", optionCategory:"opt_category_schedule_type"}, {key:"scope", label:"scope", type:"select", optionCategory:"opt_category_inspection_scope"}, {key:"plannedQuantity", label:"plannedQuantity", type:"number", min:0}, {key:"focus", label:"focus", type:"textarea", colSpan:2}, {key:"owner", label:"owner", type:"text"}, {key:"status", label:"status", type:"select", optionCategory:"opt_category_status"}, {key:"remarks", label:"remarks", type:"textarea", colSpan:2} ], schedules: [ {key:"date", label:"date", type:"date", required:true}, {key:"time", label:"time", type:"time"}, {key:"eventType", label:"eventType", type:"select", optionCategory:"opt_category_schedule_type"}, {key:"eventName", label:"eventName", type:"text", required:true}, {key:"scope", label:"scope", type:"select", optionCategory:"opt_category_inspection_scope"}, {key:"participants", label:"participants", type:"text"}, {key:"location", label:"location", type:"text"}, {key:"status", label:"status", type:"select", optionCategory:"opt_category_status"}, {key:"nextAction", label:"nextAction", type:"textarea", colSpan:2}, {key:"relatedNo", label:"relatedNo", type:"text"}, {key:"remarks", label:"remarks", type:"textarea", colSpan:2} ], checklistItems: [ {key:"businessScene", label:"businessScene", type:"select", optionCategory:"opt_category_scenario", required:true}, {key:"scope", label:"scope", type:"select", optionCategory:"opt_category_inspection_scope", required:true}, {key:"checkItem", label:"checkItem", type:"text", required:true}, {key:"standard", label:"standard", type:"textarea", colSpan:2}, {key:"riskLevel", label:"riskLevel", type:"select", optionCategory:"opt_category_risk_level"}, {key:"applicableStage", label:"applicableStage", type:"select", optionCategory:"opt_category_project_phase"}, {key:"needsPhoto", label:"needsPhoto", type:"select", optionCategory:"opt_category_yes_no"}, {key:"defaultOwnerRole", label:"defaultOwnerRole", type:"select", optionCategory:"opt_category_department_crew"}, {key:"remarks", label:"remarks", 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:"value", type:"text", required:true}, {key:"sortOrder", label:"sortOrder", type:"number", min:0}, {key:"active", label:"active", type:"select", optionCategory:"opt_category_yes_no"}, {key:"remarks", label:"remarks", type:"textarea", colSpan:2} ] }; const MODULES = [ {id:"dashboard", label:"dashboard", icon:"layout-dashboard", desc:""}, { id:"settings", store:"settings", label:"settings", icon:"settings", desc:"", idField:"settingKey", columns:["settingKey","settingValue","description","recommendedChange"], filterFields:["recommendedChange"], defaultSort:{key:"settingKey", dir:"asc"} }, { id:"inspections", store:"inspections", label:"inspections", icon:"clipboard-check", desc:"", 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:"photos", icon:"camera", desc:"", 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:"rectifications", icon:"wrench", desc:"", 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:"monthlyPlans", icon:"calendar-days", desc:"", 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:"weeklyPlans", icon:"calendar-range", desc:"", 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:"schedules", icon:"clock", desc:"", columns:["date","time","eventType","eventName","scope","participants","location","status","relatedNo"], filterFields:["eventType","scope","status"], defaultSort:{key:"date", dir:"asc"} }, { id:"checklistItems", store:"checklistItems", label:"checklistItems", icon:"library", desc:"", columns:["businessScene","scope","checkItem","standard","riskLevel","applicableStage","needsPhoto","defaultOwnerRole"], filterFields:["businessScene","scope","riskLevel","applicableStage"], defaultSort:{key:"businessScene", dir:"asc"} }, { id:"options", store:"options", label:"options", icon:"list-filter", desc:"", 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", "text.toast.systemConnected")}: ${DB_NAME}`); }catch(error){ console.error(error); content.innerHTML = `

${escapeHtml(ui("text.error.indexedDbInitFailed", "text.error.indexedDbInitFailed"))}
${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) => { const baseRecord = withSeedRecordId(storeName, {...record}, index); const localizedRecord = applyLocaleOverlayRecord(storeName, baseRecord, index) || baseRecord; return normalizeSeedRecord(storeName, {...localizedRecord}); }); 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", "text.dashboardSubtitle") : `${module.desc} · ${ui("text.moduleSubtitleSuffix", "text.moduleSubtitleSuffix")}`; content.innerHTML = `

${escapeHtml(ui("text.loadingModule", "text.loadingModule"))} ${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", "text.toast.entityAlreadyActive")); 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 => optionCode("opt_category_status", r.status) === "opt_status_needs_review" || ["opt_review_conclusion_pending_review","opt_review_conclusion_failed"].includes(optionCode("opt_category_review_conclusion", r.reviewConclusion))).length; const rectifying = rectifications.filter(r => !isClosedStatus(r.status)).length; const overdue = rectifications.filter(r => Number(r.overdueDays || 0) > 0 && !isClosedStatus(r.status)).length; const pendingPhotos = photos.filter(r => ["opt_photo_confirmation_pending_review","opt_photo_confirmation_retake_needed","opt_photo_confirmation_pending_upload"].includes(optionCode("opt_category_photo_confirmation", r.confirmStatus || r.photoStatus)) || isAffirmative(r.needsRetake)).length; const closedRect = rectifications.filter(r => isClosedStatus(r.status) || optionCode("opt_category_closure_conclusion", r.closeConclusion) === "opt_closure_conclusion_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 && !isClosedStatus(r.status)) .sort((a,b) => compareValues(a.dueDate, b.dueDate, "asc")) .slice(0, 5); const photoList = photos .filter(r => ["opt_photo_confirmation_pending_review","opt_photo_confirmation_retake_needed","opt_photo_confirmation_pending_upload"].includes(optionCode("opt_category_photo_confirmation", r.confirmStatus || "")) || isAffirmative(r.needsRetake)) .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", "text.dashboard.project"))}:${escapeHtml(settingsMap["Project name"] || "Not set")}　 ${escapeHtml(ui("text.dashboard.site", "text.dashboard.site"))}:${escapeHtml(settingsMap["Site / Zone"] || settingsMap["Project / Site"] || "Not set")}　 ${escapeHtml(ui("text.dashboard.personInCharge", "text.dashboard.personInCharge"))}:${escapeHtml(settingsMap["Site owner"] || "Not set")}　 ${escapeHtml(ui("text.dashboard.dataIsolation", "text.dashboard.dataIsolation"))}:${escapeHtml(DB_NAME)}

${kpiCard(ui("text.kpi.inspections", "text.kpi.inspections"), totalInspections, ui("text.kpi.inspectionsNote", "text.kpi.inspectionsNote"))} ${kpiCard(ui("text.kpi.thisWeek", "text.kpi.thisWeek"), weeklyInspections, `${formatDate(weekStart)} - ${formatDate(weekEnd)}`)} ${kpiCard(ui("text.kpi.needsReview", "text.kpi.needsReview"), needReview, ui("text.kpi.needsReviewNote", "text.kpi.needsReviewNote"))} ${kpiCard(ui("text.kpi.correctiveAction", "text.kpi.correctiveAction"), rectifying, ui("text.kpi.correctiveActionNote", "text.kpi.correctiveActionNote"))} ${kpiCard(ui("text.kpi.overdueCorrectiveActions", "text.kpi.overdueCorrectiveActions"), overdue, ui("text.kpi.overdueCorrectiveActionsNote", "text.kpi.overdueCorrectiveActionsNote"), overdue > 0 ? "red" : "green")} ${kpiCard(ui("text.kpi.correctiveClosureRate", "text.kpi.correctiveClosureRate"), `${closeRate}%`, ui("text.kpi.correctiveClosureRateNote", "text.kpi.correctiveClosureRateNote"))}

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

${escapeHtml(ui("text.dashboard.inspectionStatusDistributionDesc", "text.dashboard.inspectionStatusDistributionDesc"))}

${renderBarList(inspectionDist)}

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

${escapeHtml(ui("text.dashboard.correctiveStatusDistributionDesc", "text.dashboard.correctiveStatusDistributionDesc"))}

${renderBarList(rectificationDist)}

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

${escapeHtml(ui("text.dashboard.overdueCorrectiveActionsDesc", "text.dashboard.overdueCorrectiveActionsDesc"))}

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

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

${escapeHtml(ui("text.dashboard.photosPendingReviewDesc", "text.dashboard.photosPendingReviewDesc"))}

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

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

${escapeHtml(ui("text.dashboard.weeklyPlanSnapshotDesc", "text.dashboard.weeklyPlanSnapshotDesc"))}

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

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

${escapeHtml(ui("text.dashboard.riskLevelDistributionDesc", "text.dashboard.riskLevelDistributionDesc"))}

${renderBarList(riskDist)}

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

${escapeHtml(ui("text.dashboard.upcomingItemsDesc", "text.dashboard.upcomingItemsDesc"))}

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

`; 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", "text.modulePanelDescSuffix"))}

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

	${escapeHtml(ui("text.table.actions", "text.table.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 === "view-related-rectification") return openRelatedRectification(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", "text.empty.noMatchingRecords"))}

`; }else{ tbody.innerHTML = rows.map(record => renderTableRow(module, record)).join(""); } $("#resultSummary").textContent = `${ui("text.table.showing", "text.table.showing")} ${rows.length} / ${state.currentData.length} ${ui("text.table.records", "text.table.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" ? renderInspectionRectificationAction(record, ui("text.action.openAction", "text.action.openAction"), ui("text.action.viewAction", "text.action.viewAction")) : ""} ${module.id === "rectifications" && !isClosedStatus(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", "text.attachments"))}` : `${escapeHtml(ui("text.none", "text.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", "text.days"))}` : `0 ${escapeHtml(ui("text.days", "text.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", "text.kpi.needsReview"),"Pending review","Pending review",ui("text.kpi.correctiveAction", "text.kpi.correctiveAction"),"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", "text.action.edit")} ${module.label}` : `${ui("text.action.add", "text.action.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", "text.clearExistingAttachments"))} ` : `

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); if(module.store === "rectifications") await syncInspectionFromRectification(next); closeModal(); toast(mode === "create" ? ui("text.toast.recordAdded", "text.toast.recordAdded") : ui("text.toast.recordSaved", "text.toast.recordSaved")); 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:optionDisplayValue("opt_category_yes_no", "opt_yes_no_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: optionDisplayValue("opt_category_risk_level", "opt_risk_level_medium"), ownerDept: settings["Site owner"] ? optionDisplayValue("opt_category_department_crew", "opt_department_crew_safety_crew") : "", owner: settings["Site owner"] || "", inspectionDate: today, status: optionDisplayValue("opt_category_status", "opt_status_planned"), inspectionResult: optionDisplayValue("opt_category_inspection_result", "opt_inspection_result_pending_review"), needsRectification: optionDisplayValue("opt_category_yes_no", "opt_yes_no_no"), rectificationDueDate: "", needsPhoto: optionDisplayValue("opt_category_yes_no", "opt_yes_no_yes"), photoStatus: optionDisplayValue("opt_category_photo_confirmation", "opt_photo_confirmation_pending_upload"), reviewConclusion: optionDisplayValue("opt_category_review_conclusion", "opt_review_conclusion_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:optionDisplayValue("opt_category_photo_confirmation", "opt_photo_confirmation_pending_upload"), needsRetake:optionDisplayValue("opt_category_yes_no", "opt_yes_no_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: optionDisplayValue("opt_category_status", "opt_status_corrective_action"), priority: optionDisplayValue("opt_category_priority", "opt_priority_p3_medium"), needsPhotoEvidence: optionDisplayValue("opt_category_yes_no", "opt_yes_no_yes"), closeConclusion: optionDisplayValue("opt_category_closure_conclusion", "opt_closure_conclusion_open"), overdueDays: 0, reminderStatus: ui("text.reminder.normal", "text.reminder.normal"), ...preset }); } if(module.store === "monthlyPlans"){ return {...base, month: today.slice(0,7), projectSite: settings["Site / Zone"] || settings["Project name"] || "", status:optionDisplayValue("opt_category_status", "opt_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:optionDisplayValue("opt_category_schedule_type", "opt_schedule_type_inspection"), plannedQuantity:1, status:optionDisplayValue("opt_category_status", "opt_status_planned"), ...preset}; } if(module.store === "schedules"){ return {...base, date: today, time:"09:00", eventType:optionDisplayValue("opt_category_schedule_type", "opt_schedule_type_schedule_item"), status:optionDisplayValue("opt_category_status", "opt_status_planned"), ...preset}; } if(module.store === "checklistItems"){ return {...base, businessScene:optionDisplayValue("opt_category_scenario", "opt_scenario_daily_patrol"), riskLevel:optionDisplayValue("opt_category_risk_level", "opt_risk_level_medium"), needsPhoto:optionDisplayValue("opt_category_yes_no", "opt_yes_no_yes"), applicableStage:optionDisplayValue("opt_category_project_phase", "opt_project_phase_all_phases"), ...preset}; } if(module.store === "options"){ const options = await idbGetAll("options"); return {...base, category:uiCategory("opt_category_status"), value:"", sortOrder:options.length + 1, active:optionDisplayValue("opt_category_yes_no", "opt_yes_no_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(ui("text.toast.recordMissingOrDeleted", "text.toast.recordMissingOrDeleted")); 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(ui("text.toast.recordDeleted", "text.toast.recordDeleted")); await renderDataModule(module); } async function createInspectionFromChecklist(checklistId){ const item = applyLocaleOverlayRecord("checklistItems", await idbGet("checklistItems", checklistId)); if(!item) return toast(ui("text.toast.checklistItemNotFound", "text.toast.checklistItemNotFound")); 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 || optionDisplayValue("opt_category_risk_level", "opt_risk_level_medium"), ownerDept:item.defaultOwnerRole || "", owner:settings["Site owner"] || "", needsPhoto:item.needsPhoto || optionDisplayValue("opt_category_yes_no", "opt_yes_no_yes"), issueNote:item.remarks || "", status:optionDisplayValue("opt_category_status", "opt_status_planned"), inspectionResult:optionDisplayValue("opt_category_inspection_result", "opt_inspection_result_pending_review"), photoStatus:optionCode("opt_category_yes_no", item.needsPhoto) === "opt_yes_no_no" ? optionDisplayValue("opt_category_photo_confirmation", "opt_photo_confirmation_not_applicable") : optionDisplayValue("opt_category_photo_confirmation", "opt_photo_confirmation_pending_upload") }; await openRecordModal(module.id, "create", null, preset); } async function createRectificationFromInspection(inspectionId){ const inspection = applyLocaleOverlayRecord("inspections", await idbGet("inspections", inspectionId)); if(!inspection) return toast(ui("text.toast.inspectionRecordNotFound", "text.toast.inspectionRecordNotFound")); if(!canCreateRectificationFromInspectionRecord(inspection)) return toast(ui("text.toast.inspectionCannotCreateCorrective", "text.toast.inspectionCannotCreateCorrective")); const riskCode = optionCode("opt_category_risk_level", inspection.riskLevel); const priority = riskCode === "opt_risk_level_high" || riskCode === "opt_risk_level_critical" ? optionDisplayValue("opt_category_priority", "opt_priority_p1_urgent") : riskCode === "opt_risk_level_medium" ? optionDisplayValue("opt_category_priority", "opt_priority_p2_high") : optionDisplayValue("opt_category_priority", "opt_priority_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 || optionDisplayValue("opt_category_risk_level", "opt_risk_level_medium"), ownerDept:inspection.ownerDept || "", owner:inspection.owner || "", dueDate:inspection.rectificationDueDate || undefined, priority, needsPhotoEvidence:inspection.needsPhoto || optionDisplayValue("opt_category_yes_no", "opt_yes_no_yes") }; await openRecordModal("rectifications", "create", null, preset); } async function closeRectification(id){ const record = await idbGet("rectifications", id); if(!record) return toast(ui("text.toast.correctiveActionNotFound", "text.toast.correctiveActionNotFound")); if(!confirm(`Close corrective action ${record.rectificationNo || id}?`)) return; const next = normalizeRecord("rectifications", { ...record, status:optionDisplayValue("opt_category_status", "opt_status_closed"), closeConclusion:optionDisplayValue("opt_category_closure_conclusion", "opt_closure_conclusion_closed"), closedDate:TODAY(), reminderStatus:ui("text.reminder.normal", "text.reminder.normal"), overdueDays:0, updatedAt:new Date().toISOString() }); await idbPut("rectifications", next); await syncInspectionFromRectification(next); toast(ui("text.toast.correctiveActionClosed", "text.toast.correctiveActionClosed")); 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 || isClosedStatus(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(isClosedStatus(status)) return ui("text.reminder.normal", "text.reminder.normal"); if(Number(overdueDays || 0) > 0) return ui("text.reminder.overdue", "text.reminder.overdue"); const due = parseISODate(dueDate); if(!due) return ui("text.reminder.normal", "text.reminder.normal"); const today = parseISODate(TODAY()); const days = Math.ceil((due - today) / 86400000); if(days <= 1) return ui("text.reminder.dueSoon", "text.reminder.dueSoon"); return ui("text.reminder.normal", "text.reminder.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(optionCode("opt_category_yes_no", option.active) === "opt_yes_no_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: ui("text.export.sourceName", "text.export.sourceName"), data }; downloadText(`${entityId}_construction_inspection_system_data_${TODAY()}.json`, JSON.stringify(payload, null, 2), "application/json;charset=utf-8"); toast(ui("text.toast.jsonExported", "text.toast.jsonExported")); } 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(ui("text.error.noImportableData", "text.error.noImportableData")); } if(!confirm(ui("text.confirm.importReplace", "text.confirm.importReplace"))) 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(ui("text.toast.importComplete", "text.toast.importComplete")); await navigate(state.moduleId, {replaceHash:true}); }catch(error){ console.error(error); toast(`${ui("text.toast.importFailedPrefix", "text.toast.importFailedPrefix")}: ${error.message || error}`); } } async function resetSeedData(){ if(!confirm(ui("text.confirm.resetSampleData", "text.confirm.resetSampleData"))) 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(ui("text.toast.sampleDataRestored", "text.toast.sampleDataRestored")); 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] || ui("text.notSet", "text.notSet"); 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", "text.empty.noDataYet"))}

`; 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 = uiList("lists.weekdaysSundayFirst", ["weekday.sunday","weekday.monday","weekday.tuesday","weekday.wednesday","weekday.thursday","weekday.friday","weekday.saturday"]); return names[new Date(date).getDay()]; } function renderInspectionRectificationAction(record, createLabel = ui("text.action.openAction", "text.action.openAction"), viewLabel = ui("text.action.viewAction", "text.action.viewAction")){ if(record.rectificationNo){ return ``; } if(canCreateRectificationFromInspectionRecord(record)){ return ``; } return ""; } function canCreateRectificationFromInspectionRecord(record){ if(!record || record.rectificationNo || isClosedStatus(record.status)) return false; return isAffirmative(record.needsRectification) || isFailedInspectionResult(record.inspectionResult); } function isClosedStatus(value){ const code = optionCode("opt_category_status", value); return STATUS_CLOSED.has(String(value || "")) || ["opt_status_closed","opt_status_completed","opt_status_cancel"].includes(code); } function isAffirmative(value){ return optionCode("opt_category_yes_no", value) === "opt_yes_no_yes"; } function isFailedInspectionResult(value){ return optionCode("opt_category_inspection_result", value) === "opt_inspection_result_failed"; } function yesValue(){ return optionDisplayValue("opt_category_yes_no", "opt_yes_no_yes"); } function optionCode(categoryCode, value){ const text = String(value || ""); if(!text) return ""; const seedOptions = Array.isArray(SEED_DATA.options) ? SEED_DATA.options : []; const overlayOptions = Array.isArray(LOCALE_SEED_OVERLAY.options) ? LOCALE_SEED_OVERLAY.options : []; for(let index = 0; index < seedOptions.length; index += 1){ const base = seedOptions[index] || {}; const overlay = overlayOptions[index] || {}; const baseCategory = String(base.category || ""); const visibleCategory = String(overlay.category || baseCategory); if(categoryCode && baseCategory !== categoryCode && visibleCategory !== categoryCode) continue; const baseValue = String(base.value || ""); const visibleValue = String(overlay.value || baseValue); if(text === baseValue || text === visibleValue) return baseValue; } return text; } function optionDisplayValue(categoryCode, codeValue){ const seedOptions = Array.isArray(SEED_DATA.options) ? SEED_DATA.options : []; const overlayOptions = Array.isArray(LOCALE_SEED_OVERLAY.options) ? LOCALE_SEED_OVERLAY.options : []; for(let index = 0; index < seedOptions.length; index += 1){ const base = seedOptions[index] || {}; if(String(base.category || "") !== categoryCode || String(base.value || "") !== codeValue) continue; const overlay = overlayOptions[index] || {}; return String(overlay.value || base.value || codeValue); } return codeValue; } async function openRelatedRectification(rectificationNo){ const record = await idbGet("rectifications", rectificationNo); if(!record) return toast(ui("text.toast.relatedCorrectiveActionNotFound", "text.toast.relatedCorrectiveActionNotFound")); return openDetailsModal("rectifications", record.id); } async function findInspectionByNo(inspectionNo){ if(!inspectionNo) return null; const direct = await idbGet("inspections", inspectionNo); if(direct) return direct; const records = await idbGetAll("inspections"); return records.find(record => record.inspectionNo === inspectionNo) || null; } async function syncInspectionFromRectification(rectification){ if(!rectification || !rectification.inspectionNo) return; const inspection = await findInspectionByNo(rectification.inspectionNo); if(!inspection) return; const closed = isClosedStatus(rectification.status) || optionCode("opt_category_closure_conclusion", rectification.closeConclusion) === "opt_closure_conclusion_closed"; const next = normalizeRecord("inspections", { ...inspection, rectificationNo: rectification.rectificationNo || inspection.rectificationNo || "", needsRectification: yesValue(), rectificationDueDate: rectification.dueDate || inspection.rectificationDueDate || "", status: rectification.status || inspection.status, reviewConclusion: closed ? (rectification.closeConclusion || inspection.reviewConclusion) : inspection.reviewConclusion, completionDate: closed ? (rectification.closedDate || TODAY()) : inspection.completionDate, updatedAt: new Date().toISOString() }); await idbPut("inspections", next); } 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; if(id && seedIndex < 0) return null; 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 seedReminderStatus = record.reminderStatus; const normalized = normalizeRecord(storeName, record); if(storeName === "rectifications" && hadReminderStatus) normalized.reminderStatus = seedReminderStatus; 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(); } })();