JavaScript
// HTML: <div id="salesGrid"></div>
var salesData = [
{ name: '김지수', region: '서울', sales: 95, quota: 70 },
{ name: '이준호', region: '부산', sales: 42, quota: 70 },
{ name: '박미래', region: '대구', sales: 78, quota: 70 },
{ name: '최현우', region: '인천', sales: 88, quota: 70 },
{ name: '정수아', region: '서울', sales: 55, quota: 70 },
{ name: '한도윤', region: '부산', sales: 33, quota: 70 },
{ name: '윤서진', region: '대구', sales: 92, quota: 70 },
{ name: '임채원', region: '인천', sales: 61, quota: 70 },
{ name: '강민준', region: '서울', sales: 18, quota: 70 },
{ name: '조예린', region: '부산', sales: 85, quota: 70 }
];
var flex = new wijmo.grid.FlexGrid('#salesGrid', {
isReadOnly: true,
itemsSource: new wijmo.collections.CollectionView(salesData),
columns: [
{ binding: 'name', header: '이름', width: 100 },
{ binding: 'region', header: '지역', width: 90 },
{ binding: 'sales', header: '실적(%)', width: 100 },
{ binding: 'quota', header: '목표(%)', width: 100 }
]
});
flex.itemFormatter = function(panel, r, c, cell) {
var CellType = wijmo.grid.CellType;
if (panel.cellType === CellType.Cell) {
cell.style.backgroundColor = '';
cell.style.color = '';
cell.style.fontWeight = '';
var col = panel.columns[c];
var item = panel.rows[r].dataItem;
if (col.binding === 'sales') {
var pct = item.sales;
if (pct >= 80) {
cell.style.backgroundColor = '#d4edda';
cell.style.color = '#155724';
cell.style.fontWeight = 'bold';
} else if (pct >= 50) {
cell.style.backgroundColor = '#fff3cd';
cell.style.color = '#856404';
} else {
cell.style.backgroundColor = '#f8d7da';
cell.style.color = '#721c24';
}
}
} else if (panel.cellType === CellType.ColumnHeader) {
cell.style.backgroundColor = '';
var col = panel.columns[c];
if (col.binding === 'sales') {
cell.innerHTML = '📊 ' + col.header;
}
} else if (panel.cellType === CellType.RowHeader) {
cell.innerHTML = (r + 1) + '';
}
};