Advanced Master-Detail View
This demo illustrates an advanced master-detail view in the DataGrid component. Master rows represent suppliers. Detail sections contain TabPanel components with two tabs: Orders and Address. In the Orders tab, you can choose a supplier's product from the SelectBox, and the DataGrid under it will show orders placed on this product. The Address tab displays the supplier's address.
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
<dx-data-grid id="gridContainer" [dataSource]="suppliersData" [remoteOperations]="true" [showBorders]="true">
<dxo-paging [pageSize]="15"></dxo-paging>
<dxi-column dataField="ContactName"></dxi-column>
<dxi-column dataField="ContactTitle"></dxi-column>
<dxi-column dataField="CompanyName"></dxi-column>
<dxi-column dataField="City"></dxi-column>
<dxi-column dataField="Country"></dxi-column>
<dxo-master-detail [enabled]="true" template="masterDetail"></dxo-master-detail>
<div *dxTemplate="let masterDetailItem of 'masterDetail'">
<detail-view [key]="masterDetailItem.key" [rowData]="masterDetailItem.data" ></detail-view>
</div>
</dx-data-grid>
import { NgModule, Component, enableProdMode } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { DxDataGridModule, DxFormModule, DxSelectBoxModule, DxTabPanelModule } from 'devextreme-angular';
import * as AspNetData from "devextreme-aspnet-data-nojquery";
import DataSource from 'devextreme/data/data_source';
import { DetailViewComponent } from './detail-view/detail-view.component';
if (!/localhost/.test(document.location.host)) {
enableProdMode();
}
@Component({
selector: 'demo-app',
templateUrl: 'app/app.component.html',
styleUrls: ['app/app.component.css'],
})
export class AppComponent {
url: string;
suppliersData: any;
productsDataMap: object = {};
productIdBySupplier: object = {};
orderHistoryDataMap: object = {};
constructor() {
this.url = "https://js.devexpress.com/Demos/Mvc/api/DataGridAdvancedMasterDetailView";
this.suppliersData = new DataSource({
store: AspNetData.createStore({
key: "SupplierID",
loadUrl: this.url + "/GetSuppliers"
})
});
}
}
@NgModule({
imports: [
BrowserModule,
DxDataGridModule,
DxFormModule,
DxSelectBoxModule,
DxTabPanelModule
],
declarations: [AppComponent, DetailViewComponent],
bootstrap: [AppComponent]
})
export class AppModule { }
platformBrowserDynamic().bootstrapModule(AppModule);
::ng-deep #gridContainer {
height: 620px;
}
::ng-deep .dx-datagrid-rowsview .dx-master-detail-row:not(.dx-datagrid-edit-form) > .dx-datagrid-group-space,
::ng-deep .dx-datagrid-rowsview .dx-master-detail-row:not(.dx-datagrid-edit-form) .dx-master-detail-cell {
background-color: transparent;
}
// In real applications, you should not transpile code in the browser. You can see how to create your own application with Angular and DevExtreme here:
// https://js.devexpress.com/Documentation/Guide/Angular_Components/Getting_Started/Create_a_DevExtreme_Application/
window.config = {
transpiler: 'ts',
typescriptOptions: {
module: "system",
emitDecoratorMetadata: true,
experimentalDecorators: true
},
meta: {
'typescript': {
"exports": "ts"
},
'devextreme-aspnet-data-nojquery': {
"esModule": true
},
'devextreme/localization.js': {
"esModule": true
},
},
paths: {
'npm:': 'https://unpkg.com/'
},
map: {
'ts': 'npm:plugin-typescript@8.0.0/lib/plugin.js',
'typescript': 'npm:typescript@3.5.3/lib/typescript.js',
'@angular': 'npm:@angular',
'tslib': 'npm:tslib@2.3.1/tslib.js',
'rxjs': 'npm:rxjs@6.4.0',
'devextreme-aspnet-data-nojquery': 'npm:devextreme-aspnet-data-nojquery@2.8.4/index.js',
'rrule': 'npm:rrule@2.6.6/dist/es5/rrule.js',
'luxon': 'npm:luxon@1.28.0/build/global/luxon.min.js',
'es6-object-assign': 'npm:es6-object-assign@1.1.0',
'devextreme': 'npm:devextreme@21.1.6/cjs',
'devextreme/bundles/dx.all': 'npm:devextreme@21.1.6/bundles/dx.all.js',
'jszip': 'npm:jszip@3.7.1/dist/jszip.min.js',
'devextreme-quill': 'npm:devextreme-quill@1.4.2/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.1.32',
'devexpress-gantt': 'npm:devexpress-gantt@3.0.14',
'devextreme-angular': 'npm:devextreme-angular@21.1.6',
'@devextreme/vdom': 'npm:@devextreme/vdom@1.2.2',
'inferno': 'npm:inferno@7.4.10/dist/inferno.min.js',
'inferno-compat': 'npm:inferno-compat@7.4.10/dist/inferno-compat.min.js',
'inferno-create-element': 'npm:inferno-create-element@7.4.10/dist/inferno-create-element.min.js',
'inferno-dom': 'npm:inferno-dom@1.0.7/dist/inferno-dom.min.js',
'inferno-hydrate': 'npm:inferno-hydrate@7.4.10/dist/inferno-hydrate.min.js',
'inferno-clone-vnode': 'npm:inferno-clone-vnode@7.4.10/dist/inferno-clone-vnode.min.js',
'inferno-create-class': 'npm:inferno-create-class@7.4.10/dist/inferno-create-class.min.js',
'inferno-extras': 'npm:inferno-extras@7.4.10/dist/inferno-extras.min.js'
},
packages: {
'app': {
main: './app.component.ts',
defaultExtension: 'ts'
},
'devextreme': {
defaultExtension: 'js'
},
'@devextreme/vdom': {
defaultExtension: 'js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js'
}
},
packageConfigPaths: [
"npm:@devextreme/*/package.json",
"npm:@angular/*/package.json",
"npm:@angular/common/*/package.json",
"npm:rxjs/package.json",
"npm:rxjs/operators/package.json",
"npm:devextreme-angular/*/package.json",
"npm:devextreme-angular/ui/*/package.json",
"npm:devextreme-angular/package.json",
"npm:devexpress-diagram/package.json",
"npm:devexpress-gantt/package.json",
]
};
System.config(window.config);
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<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/21.1.6/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/21.1.6/css/dx.light.css" />
<script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script>
<script src="https://unpkg.com/zone.js@0.10.3/dist/zone.js"></script>
<script src="https://unpkg.com/reflect-metadata@0.1.3/Reflect.js"></script>
<script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script>
<script src="config.js"></script>
<script>
System.import('app').catch(console.error.bind(console));
</script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<demo-app>Loading...</demo-app>
</div>
</body>
</html>
::ng-deep .form-container {
padding: 20px;
}
::ng-deep .address-form label {
font-weight: bold;
}
<dx-tab-panel>
<dxi-item title="Orders" template="ordersTab"></dxi-item>
<div *dxTemplate="let ordersTabItem of 'ordersTab'">
<dx-form labelLocation="top" class="form-container">
<dxi-item template="productSelectBox">
<dxo-label text="Product"></dxo-label>
</dxi-item>
<div *dxTemplate="let selectBoxItem of 'productSelectBox'">
<dx-select-box
[value]="productIdBySupplier"
[dataSource]="productsData"
[deferRendering]="false"
valueExpr="ProductID"
displayExpr="ProductName"
(onValueChanged)="handleValueChange($event)"
>
</dx-select-box>
</div>
<dxi-item template="orderHistory">
<dxo-label text="Order History"></dxo-label>
</dxi-item>
<div *dxTemplate="let order of 'orderHistory'">
<dx-data-grid
[dataSource]="orderHistoryData"
[showBorders]="true">
<dxo-paging [pageSize]="5"></dxo-paging>
<dxi-column dataField="OrderID"></dxi-column>
<dxi-column dataField="OrderDate" dataType="date"></dxi-column>
<dxi-column dataField="ShipCountry"></dxi-column>
<dxi-column dataField="ShipCity"></dxi-column>
<dxi-column dataField="UnitPrice" format="currency"></dxi-column>
<dxi-column dataField="Quantity"></dxi-column>
<dxi-column dataField="Discount" format="percent"></dxi-column>
<dxo-summary>
<dxi-total-item
column="UnitPrice"
summaryType="sum">
<dxo-value-format
format="currency"
[precision]="2"
></dxo-value-format>
</dxi-total-item>
<dxi-total-item column="Quantity" summaryType="count"></dxi-total-item>
</dxo-summary>
</dx-data-grid>
</div>
</dx-form>
</div>
<dxi-item title="Address" template="addressTab"></dxi-item>
<div *dxTemplate="let addressTabItem of 'addressTab'">
<dx-form
[formData]="rowData"
[colCount]="2"
[customizeItem]="customizeItemTemplate"
class="address-form form-container"
>
<dxi-item dataField="Address"></dxi-item>
<dxi-item dataField="City"></dxi-item>
<dxi-item dataField="Region"></dxi-item>
<dxi-item dataField="PostalCode"></dxi-item>
<dxi-item dataField="Country"></dxi-item>
<dxi-item dataField="Phone"></dxi-item>
<div *dxTemplate="let item of 'formItem'">
<span>{{item.editorOptions.value}}</span>
</div>
</dx-form>
</div>
</dx-tab-panel>
import { Component, Input, AfterViewInit } from '@angular/core';
import DataSource from 'devextreme/data/data_source';
import * as AspNetData from "devextreme-aspnet-data-nojquery";
@Component({
selector: 'detail-view',
templateUrl: 'app/detail-view/detail-view.component.html',
styleUrls: ['app/detail-view/detail-view.component.css'],
providers: []
})
export class DetailViewComponent implements AfterViewInit {
@Input() key: number;
@Input() rowData: object;
url: string;
productIdBySupplier: number;
productsData: DataSource;
orderHistoryData: DataSource;
constructor() {
this.url = "https://js.devexpress.com/Demos/Mvc/api/DataGridAdvancedMasterDetailView";
}
ngAfterViewInit() {
this.productsData = new DataSource({
store: AspNetData.createStore({
key: "ProductID",
loadParams: { SupplierID: this.key },
loadUrl: this.url + "/GetProductsBySupplier",
onLoaded: items => this.setDefaultProduct(items)
})
})
}
setDefaultProduct(items) {
let firstItem = items[0];
if(firstItem && this.productIdBySupplier === undefined) {
this.productIdBySupplier = firstItem.ProductID;
}
}
handleValueChange(e: any) {
this.productIdBySupplier = e.value;
this.orderHistoryData = new DataSource({
store: AspNetData.createStore({
key: "OrderID",
loadParams: { ProductID: e.value },
loadUrl: this.url + "/GetOrdersByProduct"
})
});
}
customizeItemTemplate(item: any) {
item.template = "formItem";
}
}