<template>
<div>
<DxDataGrid
:ref="dataGridRefName"
:data-source="productsDataSource"
:repaint-changes-only="true"
:two-way-binding-enabled="false"
:column-auto-width="true"
:show-borders="true"
>
<DxPaging :page-size="10"/>
<DxColumn
data-field="ProductName"
data-type="string"
/>
<DxColumn
data-field="UnitPrice"
data-type="number"
format="currency"
/>
<DxColumn
data-field="OrderCount"
data-type="number"
/>
<DxColumn
data-field="Quantity"
data-type="number"
/>
<DxColumn
data-field="Amount"
data-type="number"
format="currency"
/>
<DxSummary>
<DxTotalItem
column="ProductName"
summary-type="count"
/>
<DxTotalItem
column="Amount"
summary-type="sum"
display-format="{0}"
value-format="currency"
/>
<DxTotalItem
column="OrderCount"
summary-type="sum"
display-format="{0}"
/>
</DxSummary>
<DxMasterDetail
:enabled="true"
template="productDetail"
/>
<template #productDetail="{ data: detail }">
<DxDataGrid
:data-source="getDetailGridDataSource(detail.data)"
:column-auto-width="true"
:repaint-changes-only="true"
:two-way-binding-enabled="false"
:show-borders="true"
>
<DxPaging :page-size="5"/>
<DxColumn
data-field="OrderID"
data-type="number"
/>
<DxColumn
data-field="ShipCity"
data-type="string"
/>
<DxColumn
data-field="OrderDate"
data-type="datetime"
format="yyyy/MM/dd HH:mm:ss"
/>
<DxColumn
data-field="UnitPrice"
data-type="number"
format="currency"
/>
<DxColumn
data-field="Quantity"
data-type="number"
/>
<DxColumn
:allow-sorting="true"
:calculate-cell-value="getAmount"
caption="Amount"
format="currency"
data-type="number"
/>
<DxSummary>
<DxTotalItem
column="OrderID"
summary-type="count"
/>
<DxTotalItem
column="Quantity"
summary-type="sum"
display-format="{0}"
/>
<DxTotalItem
column="Amount"
summary-type="sum"
display-format="{0}"
value-format="currency"
/>
</DxSummary>
</DxDataGrid>
</template>
</DxDataGrid>
<div class="options">
<div class="caption">Options</div>
<div class="option">
<span>Update frequency:</span>
<DxSlider
:min="10"
:step="10"
:max="5000"
v-model:value="updatesPerSecond"
>
<DxTooltip
:enabled="true"
format="#0 per second"
show-mode="always"
position="top"
/>
</DxSlider>
</div>
</div>
</div>
</template>
<script>
import {
DxDataGrid,
DxColumn,
DxSummary,
DxTotalItem,
DxMasterDetail,
DxPaging
} from 'devextreme-vue/data-grid';
import { DxSlider, DxTooltip } from 'devextreme-vue/slider';
import { productsStore, ordersStore, getOrderCount, addOrder } from './data.js';
export default {
components: {
DxDataGrid,
DxColumn,
DxSummary,
DxTotalItem,
DxMasterDetail,
DxPaging,
DxSlider,
DxTooltip
},
data() {
return {
updatesPerSecond: 100,
dataGridRefName: 'dataGrid',
productsDataSource: {
store: productsStore,
reshapeOnPush: true
}
};
},
created() {
setInterval(() => {
if(getOrderCount() > 500000) {
return;
}
for(var i = 0; i < this.updatesPerSecond / 20; i++) {
addOrder();
}
}, 50);
},
methods: {
getDetailGridDataSource(product) {
return {
store: ordersStore,
reshapeOnPush: true,
filter: ['ProductID', '=', product.ProductID]
};
},
getAmount(order) {
return order.UnitPrice * order.Quantity;
}
}
};
</script>
<style scoped>
.options {
padding: 20px;
margin-top: 20px;
background-color: rgba(191, 191, 191, 0.15);
}
.caption {
font-size: 18px;
font-weight: 500;
}
.option {
margin-top: 10px;
}
.option > span {
position: relative;
top: 2px;
margin-right: 10px;
}
.option > .dx-widget {
width: 500px;
display: inline-block;
vertical-align: middle;
}
</style>
import { createApp } from 'vue';
import App from './App.vue';
createApp(App).mount('#app');
<!DOCTYPE html>
<html>
<head>
<title>DevExtreme Demo</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.5/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.5/css/dx.light.css" />
<script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script>
<script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script>
<script type="text/javascript" src="config.js"></script>
<script type="text/javascript">
System.import('./index.js');
</script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<div id="app">
</div>
</div>
</body>
</html>
import ArrayStore from 'devextreme/data/array_store';
const cities = ['Los Angeles', 'Denver', 'Bentonville', 'Atlanta', 'Reno', 'Beaver', 'Malibu', 'Phoenix', 'San Diego', 'Little Rock', 'Pasadena', 'Boise', 'San Jose', 'Chatsworth', 'San Fernando', 'South Pasadena', 'San Fernando Valley', 'La Canada', 'St. Louis'];
const orders = [];
const products = [];
for(let i = 1; i <= 100; i++) {
products.push({ ProductID: i, ProductName: `Product ${ i}`, UnitPrice: Math.floor(Math.random() * 1000) + 1, Quantity: 0, Amount: 0, OrderCount: 0 });
}
export const productsStore = new ArrayStore({
key: 'ProductID',
data: products
});
export const ordersStore = new ArrayStore({
key: 'OrderID',
data: orders
});
export function getOrderCount() {
return orders.length;
}
export function addOrder() {
const product = products[Math.round(Math.random() * 99)];
const order = {
OrderID: orders.length ? orders[orders.length - 1].OrderID + 1 : 20001,
ShipCity: cities[Math.round(Math.random() * (cities.length - 1))],
ProductID: product.ProductID,
UnitPrice: product.UnitPrice,
OrderDate: new Date(),
Quantity: Math.round(Math.random() * 20) + 1
};
ordersStore.push([{ type: 'insert', data: order }]);
productsStore.push([{
type: 'update',
key: order.ProductID,
data: {
OrderCount: product.OrderCount + 1,
Quantity: product.Quantity + order.Quantity,
Amount: product.Amount + order.UnitPrice * order.Quantity
}
}]);
}
System.config({
transpiler: 'plugin-babel',
meta: {
'*.vue': {
loader: 'vue-loader'
},
'devextreme/localization.js': {
"esModule": true
},
},
paths: {
'npm:': 'https://unpkg.com/'
},
map: {
'vue': 'npm:vue@3.0.0/dist/vue.esm-browser.js',
'vue-loader': 'npm:dx-systemjs-vue-browser@1.0.15/index.js',
'mitt': 'npm:mitt/dist/mitt.umd.js',
'rrule': 'npm:rrule@2.6.6/dist/es5/rrule.js',
'luxon': 'npm:luxon@1.25.0/build/global/luxon.min.js',
'es6-object-assign': 'npm:es6-object-assign@1.1.0',
'devextreme': 'npm:devextreme@20.2.5',
'devextreme-vue': 'npm:devextreme-vue@20.2.5',
'jszip': 'npm:jszip@3.5.0/dist/jszip.min.js',
'devextreme-quill': 'npm:devextreme-quill@0.9.8/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.0.11/dist/dx-diagram.js',
'devexpress-gantt': 'npm:devexpress-gantt@2.0.18/dist/dx-gantt.js',
'preact': 'npm:preact@10.5.11/dist/preact.js',
'preact/hooks': 'npm:preact@10.5.11/hooks/dist/hooks.js',
'plugin-babel': 'npm:systemjs-plugin-babel@0.0.25/plugin-babel.js',
'systemjs-babel-build': 'npm:systemjs-plugin-babel@0.0.25/systemjs-babel-browser.js'
},
packages: {
'devextreme-vue': {
main: 'index.js'
},
'devextreme': {
defaultExtension: 'js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js'
}
},
babelOptions: {
sourceMaps: false,
stage0: true
}
});