${pages} `; openPrintWindow(html); }); el.printLedgerBtn.addEventListener("click", () => { const cal = buildCalendarGrid(state.month); const ym = state.month; const rows = state.employees.map(emp => { const m = computeMonthlyForEmployee(emp, cal); return ` ${emp.name} ${emp.id} ${emp.startDate || "-"} ${emp.job || "-"} ${fmtKRW(emp.hourlyWage)} ${m.workHoursInMonth.toFixed(2)}h ${m.holidayHoursInMonth.toFixed(2)}h ${fmtKRW(m.basePay)} ${fmtKRW(m.holidayPayInMonth)} ${fmtKRW(m.extraPay)} ${fmtKRW(m.grossPay)} ${fmtKRW(m.deductions.employeeTotal)} `; }).join(""); const html = `

임금대장(참고용) - ${ym}

${rows}

성명	직원ID	고용연월일	업무	시급	근로시간수(월)	주휴시간(월)	기본급	주휴수당	기타수당	임금총액	공제금액(합계)

`; openPrintWindow(html); }); // CSV templates / import el.downloadEmpTemplateBtn.addEventListener("click", () => { const rows = [ ["employee_id","name","hourly_wage","start_date","end_date","job","extra_pay","mon","tue","wed","thu","fri","sat","sun"], ["E001","김알바","10030","2025-12-01","","카운터","0","4","4","4","4","4","0","0"] ]; downloadText("employees_template.csv", toCSV(rows), "text/csv"); }); el.downloadTimeTemplateBtn.addEventListener("click", () => { const rows = [ ["employee_id","date","hours"], ["E001","2025-12-01","4"], ["E001","2025-12-02","4"] ]; downloadText("timesheet_template.csv", toCSV(rows), "text/csv"); }); el.importEmpCsv.addEventListener("change", async () => { const file = el.importEmpCsv.files?.[0]; if (!file) return; const text = await file.text(); const rows = parseCSV(text); if (rows.length < 2){ alert("CSV 데이터가 부족합니다."); el.importEmpCsv.value=""; return; } const header = rows[0].map(h => h.trim().toLowerCase()); const idx = (name) => header.indexOf(name); const req = ["employee_id","name","hourly_wage"]; for (const r of req){ if (idx(r) === -1){ alert("직원 CSV 필수 컬럼 누락: " + r); el.importEmpCsv.value=""; return; } } for (let i=1; i e.id === id); if (!emp){ emp = defaultEmployee(); emp.id = id; state.employees.push(emp); } emp.name = (r[idx("name")]||"").trim() || emp.name; emp.hourlyWage = Number((r[idx("hourly_wage")]||"").trim() || emp.hourlyWage); const sd = idx("start_date")>=0 ? (r[idx("start_date")]||"").trim() : ""; const ed = idx("end_date")>=0 ? (r[idx("end_date")]||"").trim() : ""; const job = idx("job")>=0 ? (r[idx("job")]||"").trim() : ""; const extra = idx("extra_pay")>=0 ? Number((r[idx("extra_pay")]||"").trim()||0) : 0; emp.startDate = sd; emp.endDate = ed; emp.job = job; emp.extraPay = extra; const mapDow = { mon:0,tue:1,wed:2,thu:3,fri:4,sat:5,sun:6 }; Object.entries(mapDow).forEach(([k,dow])=>{ const j = idx(k); if (j>=0){ emp.contractHoursByDow[dow] = Number((r[j]||"").trim() || 0); } }); } if (state.employees.length){ state.ui.selectedEmployeeId = state.employees[0].id; } renderAll(); autosave(); toast("직원 CSV 임포트 완료"); el.importEmpCsv.value=""; }); el.importTimeCsv.addEventListener("change", async () => { const file = el.importTimeCsv.files?.[0]; if (!file) return; const text = await file.text(); const rows = parseCSV(text); if (rows.length < 2){ alert("CSV 데이터가 부족합니다."); el.importTimeCsv.value=""; return; } const header = rows[0].map(h => h.trim().toLowerCase()); const idx = (name) => header.indexOf(name); const req = ["employee_id","date","hours"]; for (const r of req){ if (idx(r) === -1){ alert("근무기록 CSV 필수 컬럼 누락: " + r); el.importTimeCsv.value=""; return; } } for (let i=1; i e.id === id); if (!emp){ emp = defaultEmployee(); emp.id = id; emp.name = id; state.employees.push(emp); } emp.timesheet[date] = clamp(hours, 0, 24); } renderAll(); autosave(); toast("근무기록 CSV 임포트 완료"); el.importTimeCsv.value=""; }); /* ========================= Init ========================= */ loadStore(); setStateFromScenario(store.last); if (!state.month){ state.month = defaultScenario().month; } renderAll(); autosave();