// 관리자: 전체 리본 사용 가능
const adminConfig = JSON.parse(JSON.stringify(GC.Spread.Sheets.Designer.DefaultConfig));
// 뷰어: Home·View 탭만 + 파일 메뉴 제거
const viewerConfig = JSON.parse(JSON.stringify(GC.Spread.Sheets.Designer.DefaultConfig));
viewerConfig.ribbon = viewerConfig.ribbon.filter(tab => ['home', 'view'].includes(tab.id));
delete viewerConfig.fileMenu;
const designer = new GC.Spread.Sheets.Designer.Designer(document.getElementById('spreadContainer'));
const spread = designer.getWorkbook();
const sheet = spread.getActiveSheet();
// 직원 권한 테이블 샘플 데이터
const headers = ['이름', '부서', '역할', '편집 가능 범위'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#1565C0').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, c === 3 ? 160 : 110);
});
const empData = [
['김민준', '개발팀', '관리자', '전체 셀'],
['이서연', '기획팀', '뷰어', '없음(읽기 전용)'],
['박지호', '영업팀', '뷰어', '없음(읽기 전용)'],
['최유진', '재무팀', '관리자', '전체 셀'],
];
empData.forEach((row, r) => {
row.forEach((val, c) => sheet.setValue(r + 1, c, val));
const color = row[2] === '관리자' ? '#E3F2FD' : '#F5F5F5';
for (let c = 0; c < 4; c++) sheet.getCell(r + 1, c).backColor(color);
});
sheet.setRowHeight(0, 36);
function setRole(role) {
const isAdmin = role === 'admin';
designer.setConfig(isAdmin ? adminConfig : viewerConfig);
sheet.options.isProtected = !isAdmin;
const btnAdmin = document.getElementById('btnAdmin');
const btnViewer = document.getElementById('btnViewer');
const roleMsg = document.getElementById('roleMsg');
if (btnAdmin) {
btnAdmin.style.background = isAdmin ? '#1565C0' : '#fff';
btnAdmin.style.color = isAdmin ? '#fff' : '#333';
btnAdmin.style.borderColor = isAdmin ? '#1565C0' : '#bbb';
}
if (btnViewer) {
btnViewer.style.background = !isAdmin ? '#1565C0' : '#fff';
btnViewer.style.color = !isAdmin ? '#fff' : '#333';
btnViewer.style.borderColor = !isAdmin ? '#1565C0' : '#bbb';
}
if (roleMsg) {
roleMsg.textContent = isAdmin
? '✏️ 편집 가능 — 모든 리본 기능 활성화'
: '👁 읽기 전용 — 셀 편집 비활성화';
}
}
document.getElementById('btnAdmin')?.addEventListener('click', () => setRole('admin'));
document.getElementById('btnViewer')?.addEventListener('click', () => setRole('viewer'));
setRole('admin');