JavaScript
// --- 데이터 ---
var regions = ['서울', '부산', '대구', '인천', '광주', '대전', '울산', '수원'];
var products = ['FlexGrid', 'FlexChart', 'InputPro', 'ReportViewer'];
var rawData = [];
for (var i = 0; i < 24; i++) {
var sales = Math.round(2000000 + Math.random() * 8000000);
var expenses = Math.round(sales * (0.3 + Math.random() * 0.3));
rawData.push({
id: i + 1,
region: regions[i % regions.length],
product: products[i % products.length],
sales: sales,
expenses: expenses,
profit: sales - expenses,
growth: parseFloat((Math.random() * 40 - 10).toFixed(1))
});
}
// --- CollectionView: 초기 정렬을 매출 내림차순으로 ---
var cv = new wijmo.collections.CollectionView(rawData, {
sortDescriptions: [
new wijmo.collections.SortDescription('sales', false)
]
});
// --- FlexGrid 초기화 ---
var theGrid = new wijmo.grid.FlexGrid('#theGrid', {
autoGenerateColumns: false,
selectionMode: wijmo.grid.SelectionMode.Row,
alternatingRowStep: 1,
columns: [
{ binding: 'id', header: 'No.', width: 55, isReadOnly: true },
{ binding: 'region', header: '지역', width: '*' },
{ binding: 'product', header: '제품', width: '*' },
{ binding: 'sales', header: '매출액', width: '*', format: 'n0' },
{ binding: 'expenses',header: '비용', width: '*', format: 'n0' },
{ binding: 'profit', header: '수익', width: '*', format: 'n0' },
{ binding: 'growth', header: '성장률(%)', width: 100, format: 'n1' }
],
itemsSource: cv
});
// --- 지역 필터 ---
var regionFilter = document.getElementById('regionFilter');
if (regionFilter) {
regionFilter.addEventListener('change', function() {
var selected = this.value;
cv.filter = selected
? function(item) { return item.region === selected; }
: null;
});
}
// --- 수익 양수 필터 ---
var profitBtn = document.getElementById('profitFilter');
if (profitBtn) {
profitBtn.addEventListener('click', function() {
cv.filter = function(item) { return item.profit > 0; };
});
}
// --- 필터 초기화 ---
var clearBtn = document.getElementById('clearFilter');
if (clearBtn) {
clearBtn.addEventListener('click', function() {
cv.filter = null;
});
}