const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
sheet.options.rowHeaderVisible = false;
// 헤더 행 (row 0)
const COLS = ['부품코드', '부품명', '단위', '수량', '단가(원)', '소계(원)'];
const WIDTHS = [90, 190, 50, 55, 90, 100];
COLS.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#1565C0').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, WIDTHS[c]);
});
sheet.setRowHeight(0, 36);
// BOM 데이터 — indent 값이 계층 레벨
const bomData = [
{ code: 'FG-001', name: '스마트 팩토리 컨트롤러', unit: 'EA', qty: 1, price: 0, indent: 0 },
{ code: 'ASM-010', name: '메인 어셈블리', unit: 'EA', qty: 1, price: 0, indent: 1 },
{ code: 'SUBASM-011', name: '제어 보드 어셈블리', unit: 'EA', qty: 1, price: 0, indent: 2 },
{ code: 'P-0111', name: 'MCU 프로세서', unit: 'EA', qty: 2, price: 8500, indent: 3 },
{ code: 'P-0112', name: '전원 IC', unit: 'EA', qty: 4, price: 1200, indent: 3 },
{ code: 'M-01121', name: '구리 리드 프레임', unit: 'g', qty: 0.5, price: 320, indent: 4 },
{ code: 'SUBASM-012', name: '통신 모듈 어셈블리', unit: 'EA', qty: 1, price: 0, indent: 2 },
{ code: 'P-0121', name: 'WiFi/BLE 칩셋', unit: 'EA', qty: 1, price: 12000, indent: 3 },
{ code: 'P-0122', name: '안테나', unit: 'EA', qty: 2, price: 850, indent: 3 },
{ code: 'ASM-020', name: '하우징 어셈블리', unit: 'EA', qty: 1, price: 0, indent: 1 },
{ code: 'P-0201', name: '알루미늄 케이스', unit: 'EA', qty: 1, price: 5600, indent: 2 },
{ code: 'P-0202', name: '방열 패드', unit: 'EA', qty: 2, price: 430, indent: 2 },
{ code: 'M-02011', name: '알루미늄 합금(A6061)', unit: 'kg', qty: 0.3, price: 4800, indent: 3 },
];
spread.suspendPaint();
sheet.setRowCount(bomData.length + 1);
// 계층별 색상 팔레트 (indent 0~4)
const BG = ['#0D47A1', '#1565C0', '#1976D2', '#E3F2FD', '#F3F8FF'];
const FG = ['#ffffff', '#ffffff', '#ffffff', '#0D47A1', '#37474F'];
bomData.forEach((item, i) => {
const r = i + 1;
sheet.setValue(r, 0, item.code);
sheet.setValue(r, 1, item.name);
sheet.setValue(r, 2, item.unit);
sheet.setValue(r, 3, item.qty);
if (item.price > 0) {
sheet.setValue(r, 4, item.price);
sheet.setFormula(r, 5, `=D${r + 1}*E${r + 1}`);
}
// 부품명 컬럼에 들여쓰기로 계층 레벨 표현
sheet.getRange(r, 1, 1, 1).textIndent(item.indent);
const level = Math.min(item.indent, BG.length - 1);
for (let c = 0; c < 6; c++) {
sheet.getCell(r, c).backColor(BG[level]).foreColor(FG[level]);
if (item.indent <= 1) sheet.getCell(r, c).font('bold 12px sans-serif');
}
});
// OutlineColumn 활성화 — columnIndex를 부품명 열(1)로 지정
sheet.outlineColumn.options({ columnIndex: 1, maxLevel: 4 });
sheet.showRowOutline(true);
// 금액 컬럼 포맷
sheet.getRange(1, 4, bomData.length, 2).formatter('#,##0');
spread.invalidateLayout();
spread.resumePaint();