const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = false;
const sheet = spread.getActiveSheet();
sheet.name('생산 계획표');
spread.suspendPaint();
const headers = ['공정명', '작업지시번호', '계획 시작일', '계획 종료일', '담당자', '진행 상태', '진도율(%)'];
const colWidths = [120, 130, 100, 100, 80, 90, 90];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.setColumnWidth(c, colWidths[c]);
sheet.getCell(0, c)
.backColor('#1A3C6E').foreColor('#FFFFFF')
.font('bold 12px sans-serif')
.hAlign(GC.Spread.Sheets.HorizontalAlign.center);
});
sheet.setRowHeight(0, 36);
const data = [
['원재료 투입', 'WO-2024-001', '2024-06-01', '2024-06-03', '김민준', '완료', 100],
['절단 가공', 'WO-2024-002', '2024-06-03', '2024-06-05', '이서연', '완료', 100],
['용접', 'WO-2024-003', '2024-06-05', '2024-06-08', '박지호', '진행중', 65],
['도장', 'WO-2024-004', '2024-06-08', '2024-06-10', '최유진', '지연', 30],
['품질 검사', 'WO-2024-005', '2024-06-10', '2024-06-11', '정수민', '대기', 0],
['포장', 'WO-2024-006', '2024-06-11', '2024-06-12', '한지아', '대기', 0],
['출하', 'WO-2024-007', '2024-06-12', '2024-06-13', '오동훈', '대기', 0],
];
data.forEach((row, r) => {
row.forEach((val, c) => {
sheet.setValue(r + 1, c, val);
sheet.getCell(r + 1, c)
.hAlign(GC.Spread.Sheets.HorizontalAlign.center)
.vAlign(GC.Spread.Sheets.VerticalAlign.center);
});
sheet.setRowHeight(r + 1, 32);
const status = row[5];
const bg = status === '완료' ? '#E8F5E9' : status === '진행중' ? '#E3F2FD' : status === '지연' ? '#FFEBEE' : '#FAFAFA';
for (let c = 0; c < 7; c++) sheet.getCell(r + 1, c).backColor(bg);
});
const CF = GC.Spread.Sheets.ConditionalFormatting;
const textOp = CF.TextComparisonOperators;
const statusRange = [new GC.Spread.Sheets.Range(1, 5, 7, 1)];
const doneStyle = new GC.Spread.Sheets.Style();
doneStyle.backColor = '#A5D6A7'; doneStyle.foreColor = '#1B5E20'; doneStyle.font = 'bold 11px sans-serif';
sheet.conditionalFormats.addSpecificTextRule(textOp.contains, '완료', doneStyle, statusRange);
const inProgressStyle = new GC.Spread.Sheets.Style();
inProgressStyle.backColor = '#90CAF9'; inProgressStyle.foreColor = '#0D47A1'; inProgressStyle.font = 'bold 11px sans-serif';
sheet.conditionalFormats.addSpecificTextRule(textOp.contains, '진행중', inProgressStyle, statusRange);
const delayStyle = new GC.Spread.Sheets.Style();
delayStyle.backColor = '#EF9A9A'; delayStyle.foreColor = '#B71C1C'; delayStyle.font = 'bold 11px sans-serif';
sheet.conditionalFormats.addSpecificTextRule(textOp.contains, '지연', delayStyle, statusRange);
spread.resumePaint();