const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = false;
const sheet = spread.getActiveSheet();
// 주식 시세 초기 데이터
const stocks = ['삼성전자', 'SK하이닉스', 'LG에너지솔루션', 'NAVER', '카카오'];
const basePrice = [72000, 145000, 410000, 220000, 52000];
const prices = [...basePrice];
['종목명', '현재가', '전일대비', '등락률(%)'].forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#263238').foreColor('#fff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, c === 0 ? 140 : 110);
});
sheet.setRowHeight(0, 34);
stocks.forEach((name, r) => {
sheet.setValue(r + 1, 0, name);
sheet.setValue(r + 1, 1, prices[r]);
sheet.setValue(r + 1, 2, 0);
sheet.setValue(r + 1, 3, '0.00%');
sheet.setRowHeight(r + 1, 30);
});
// WebSocket 수신 처리 — 실제: ws.onmessage = (e) => handleMsg(JSON.parse(e.data))
function handleWsMessage(rowIdx, newPrice) {
const diff = newPrice - prices[rowIdx];
const rate = ((diff / prices[rowIdx]) * 100).toFixed(2);
prices[rowIdx] = newPrice;
spread.suspendPaint();
sheet.setValue(rowIdx + 1, 1, newPrice);
sheet.setValue(rowIdx + 1, 2, diff > 0 ? '+' + diff : diff);
sheet.setValue(rowIdx + 1, 3, (diff >= 0 ? '+' : '') + rate + '%');
const flashBg = diff >= 0 ? '#E3F2FD' : '#FFEBEE';
const textColor = diff >= 0 ? '#1B5E20' : '#B71C1C';
[1, 2, 3].forEach(c => {
sheet.getCell(rowIdx + 1, c).backColor(flashBg).foreColor(c > 1 ? textColor : '#000');
});
spread.resumePaint();
setTimeout(() => {
spread.suspendPaint();
const finalBg = diff >= 0 ? '#E8F5E9' : '#FFF3F3';
[1, 2, 3].forEach(c => sheet.getCell(rowIdx + 1, c).backColor(finalBg));
spread.resumePaint();
}, 500);
}
let wsTimer = null;
document.getElementById('btnStartWS')?.addEventListener('click', () => {
if (wsTimer) return;
document.getElementById('wsStatus').textContent = '● 실시간 연결됨';
wsTimer = setInterval(() => {
const r = Math.floor(Math.random() * 5);
const change = Math.round((Math.random() - 0.48) * basePrice[r] * 0.012);
handleWsMessage(r, prices[r] + change);
}, 800);
});
document.getElementById('btnStopWS')?.addEventListener('click', () => {
clearInterval(wsTimer);
wsTimer = null;
document.getElementById('wsStatus').textContent = '연결 해제됨';
});