Advanced Master-Detail View
This demo illustrates an advanced master-detail view in the DataGrid widget. Master rows represent suppliers. Detail sections contain TabPanel widgets 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'">
<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[masterDetailItem.key]"
[dataSource]="getProductsData(masterDetailItem.key)"
[deferRendering]="false"
valueExpr="ProductID"
displayExpr="ProductName"
(onValueChanged)="handleValueChange($event, masterDetailItem.key)"
>
</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]="getOrderHistoryData(masterDetailItem.key)"
[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]="masterDetailItem.data"
[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>
</div>
</dx-data-grid>
import { NgModule, Component, enableProdMode, ChangeDetectionStrategy } 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";
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 = AspNetData.createStore({
key: "SupplierID",
loadUrl: this.url + "/GetSuppliers"
});
}
handleValueChange(e: any, supplierID: number) {
this.productIdBySupplier[supplierID] = e.value;
this.orderHistoryDataMap[supplierID] = {
store: AspNetData.createStore({
key: "OrderID",
loadParams: { ProductID: e.value },
loadUrl: this.url + "/GetOrdersByProduct"
})
};
}
customizeItemTemplate(item: any) {
item.template = "formItem";
}
getProductsData(supplierID: number) : any {
return this.productsDataMap[supplierID] = this.productsDataMap[supplierID] || {
store: AspNetData.createStore({
key: "ProductID",
loadParams: { SupplierID: supplierID },
loadUrl: this.url + "/GetProductsBySupplier",
onLoaded: items => this.setDefaultProduct(items, supplierID)
})
};
}
setDefaultProduct(items, supplierID) {
let firstItem = items[0];
if(firstItem && this.productIdBySupplier[supplierID] === undefined) {
this.productIdBySupplier[supplierID] = firstItem.ProductID;
}
}
getOrderHistoryData(supplierID: number) : any {
return this.orderHistoryDataMap[supplierID];
}
}
@NgModule({
imports: [
BrowserModule,
DxDataGridModule,
DxFormModule,
DxSelectBoxModule,
DxTabPanelModule
],
declarations: [AppComponent],
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,
.dx-datagrid-rowsview .dx-master-detail-row:not(.dx-datagrid-edit-form) .dx-master-detail-cell {
background-color: transparent;
}
::ng-deep .form-container {
padding: 20px;
}
::ng-deep .address-form label {
font-weight: bold;
}
// 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/
System.config({
transpiler: 'ts',
typescriptOptions: {
module: "system",
emitDecoratorMetadata: true,
experimentalDecorators: true
},
meta: {
'typescript': {
"exports": "ts"
},
'devextreme-aspnet-data-nojquery': {
"esModule": true
},
},
paths: {
'npm:': 'https://unpkg.com/'
},
map: {
'ts': 'npm:plugin-typescript@8.0.0/lib/plugin.js',
'typescript': 'npm:typescript@3.4.5/lib/typescript.js',
'@angular': 'npm:@angular',
'tslib': 'npm:tslib/tslib.js',
'rxjs': 'npm:rxjs',
'devextreme-aspnet-data-nojquery': 'npm:devextreme-aspnet-data-nojquery@2.6.1',
'devextreme': 'npm:devextreme@20.1',
'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js',
'quill': 'npm:quill@1.3.7/dist/quill.js',
'devexpress-diagram': 'npm:devexpress-diagram@1.0.5',
'devexpress-gantt': 'npm:devexpress-gantt@1.0.3',
'devextreme-angular': 'npm:devextreme-angular@20.1'
},
packages: {
'app': {
main: './app.component.ts',
defaultExtension: 'ts'
},
'devextreme': {
defaultExtension: 'js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
},
packageConfigPaths: [
"npm:*/package.json",
"npm:@angular/*/package.json",
"npm:@angular/common/*/package.json",
"npm:rxjs/operators/package.json",
"npm:devextreme-angular@20.1/*/package.json",
"npm:devextreme-angular@20.1/ui/*/package.json",
]
});
<!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/20.1.4/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.1.4/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.2/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>