<!DOCTYPE html>
<html lang="en">
<head>
<title>Angular 2 ag-Grid starter</title>
<script>document.write('<base href="' + document.location + '" />');</script>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<style> html, body { margin: 0; padding: 0; height: 100%; }
.example-wrapper {
display: flex;
flex-direction: column;
height: 100%;
}
#myGrid {
flex: 1 1 0px;
width: 100%;
}
.sick-days-warning {
/* background-color: sandybrown !important; */
}
.ag-row-editing{
background-color: sandybrown !important;
}
/* .sick-days-breach { */
background-color: lightcoral !important;
}
</style>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.12.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css"/>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap-theme.min.css"/>
<script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"/>
<!-- Polyfills -->
<script src="https://unpkg.com/zone.js@0.8.17?main=browser"></script>
<script src="https://unpkg.com/systemjs@0.19.39/dist/system.src.js"></script>
<script>
var appLocation = '';
var boilerplatePath = '';
var systemJsMap = {
"@ag-grid-community/all-modules/dist/styles/ag-grid.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-grid.css",
"@ag-grid-community/core/dist/styles/ag-grid.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-grid.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-alpine-dark.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-alpine-dark.css",
"@ag-grid-community/core/dist/styles/ag-theme-alpine-dark.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-alpine-dark.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-alpine.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-alpine.css",
"@ag-grid-community/core/dist/styles/ag-theme-alpine.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-alpine.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-balham-dark.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-balham-dark.css",
"@ag-grid-community/core/dist/styles/ag-theme-balham-dark.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-balham-dark.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-balham.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-balham.css",
"@ag-grid-community/core/dist/styles/ag-theme-balham.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-balham.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-blue.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-blue.css",
"@ag-grid-community/core/dist/styles/ag-theme-blue.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-blue.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-bootstrap.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-bootstrap.css",
"@ag-grid-community/core/dist/styles/ag-theme-bootstrap.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-bootstrap.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-dark.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-dark.css",
"@ag-grid-community/core/dist/styles/ag-theme-dark.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-dark.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-fresh.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-fresh.css",
"@ag-grid-community/core/dist/styles/ag-theme-fresh.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-fresh.css",
"@ag-grid-community/all-modules/dist/styles/ag-theme-material.css": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/styles/ag-theme-material.css",
"@ag-grid-community/core/dist/styles/ag-theme-material.css": "https://unpkg.com/@ag-grid-community/core@23.2.0/dist/styles/ag-theme-material.css",
"@ag-grid-community/react": "https://unpkg.com/@ag-grid-community/react@23.2.0/",
"@ag-grid-community/angular": "https://unpkg.com/@ag-grid-community/angular@23.2.0/",
"@ag-grid-community/vue": "https://unpkg.com/@ag-grid-community/vue@23.2.0/",
"ag-charts-community": "https://unpkg.com/ag-charts-community@1.2.0/dist/ag-charts-community.cjs.js",
"ag-grid-community": "https://unpkg.com/ag-grid-community@23.2.0/",
"ag-grid-enterprise": "https://unpkg.com/ag-grid-enterprise@23.2.0/",
"ag-grid-angular": "https://unpkg.com/ag-grid-angular@23.2.0/",
"ag-grid-react": "https://unpkg.com/ag-grid-react@23.2.0/",
"ag-grid-vue": "https://unpkg.com/ag-grid-vue@23.2.0/"
};
var systemJsPaths = {
"@ag-grid-community/all-modules": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/ag-grid-community.cjs.js",
"@ag-grid-community/client-side-row-model": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/ag-grid-community.cjs.js",
"@ag-grid-community/core": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/ag-grid-community.cjs.js",
"@ag-grid-community/csv-export": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/ag-grid-community.cjs.js",
"@ag-grid-community/infinite-row-model": "https://unpkg.com/@ag-grid-community/all-modules@23.2.0/dist/ag-grid-community.cjs.js"
};
</script>
<script src="systemjs.config.js"></script>
<script>
System.import('main.ts').catch(function(err){ console.error(err); });
</script>
</head>
<body>
<my-app>Loading ag-Grid example…</my-app>
</body>
</html>
import { Component, ViewChild } from "@angular/core";
import 'ag-grid-community/dist/styles/ag-grid.css';
import 'ag-grid-community/dist/styles/ag-theme-balham.css';
import { rowEditComponent } from "./row-edit-component";
@Component({
selector: "my-app",
template: `
<div style="height: 100%; box-sizing: border-box;">
<ag-grid-angular
#agGrid
style="width: 100%; height: 100%;"
id="myGrid"
class="ag-theme-balham"
[columnDefs]="columnDefs"
[rowData]="rowData"
[editType]="editType"
[rowClassRules]="rowClassRules"
[frameworkComponents]="frameworkComponents"
(gridReady)="onGridReady($event)"
(cellClicked)="onCellClicked($event)"
[defaultColDef] = "defaultColDef"
[immutableColumns] = "true"
suppressClickEdit
></ag-grid-angular>
</div>
`
})
export class AppComponent {
private gridApi;
private gridColumnApi;
private columnDefs;
private rowData;
private context;
private frameworkComponents;
private editType;
private defaultColDef;
private rowClassRules;
constructor() {
this.columnDefs = [
{
headerName: "Actions",
field: "action",
cellRenderer: "rowEditCRenderer",
cellRendererParams: {
cancelOtherRowEditors: this.cancelOtherRowEditors.bind(this)
},
width: 180,
pinned:'left'
},
{
headerName: "Row",
editable: true,
field: "row",
width: 150
},
{
headerName: "value1",
field: "value1",
editable: true,
width: 150
},
{
headerName: "value2",
field: "value2",
editable: true,
width: 150
},
{
headerName: "value3",
field: "value3",
editable: true,
width: 150
},
{
headerName: "value4",
field: "value4",
editable: true,
width: 150
},
{
headerName: "value5",
field: "value5",
editable: true,
width: 150
},
{
headerName: "value6",
field: "value6",
editable: true,
width: 150
},
{
headerName: "value7",
field: "value7",
editable: true,
width: 150
},
{
headerName: "value8",
field: "value8",
editable: true,
width: 150
},
{
headerName: "value9",
field: "value9",
editable: true,
width: 150
},
{
headerName: "value10",
field: "value10",
editable: true,
width: 150
},
{
headerName: "Total",
field: "currency",
editable: false,
width: 100
}
];
this.rowData = createRowData();
this.editType = "fullRow";
this.frameworkComponents = {
rowEditCRenderer: rowEditComponent
};
this.rowClassRules = {
'sick-days-warning': function (params) {
var numSickDays = params.data.value1;
return (numSickDays % 2) == 0;
},
'sick-days-breach': 'data.value1 % 2',
};
this.defaultColDef = {
sortingOrder: ["asc", "desc"],
stopEditingWhenGridLosesFocus: false,
sortable:true,
enableFilter: true,
suppressKeyboardEvent: function (event) {
if(!event.editing || event.event.code === "Enter")
return true;
}
};
}
cancelOtherRowEditors(currentRowIndex) {
const renderers = this.gridApi.getCellRendererInstances();
renderers.forEach(function(renderer) {
if(!renderer._agAwareComponent.isNew &&
currentRowIndex !== renderer._params.node.rowIndex) {
renderer._agAwareComponent.onCancelClick();
}
});
}
onGridReady(params) {
this.gridApi = params.api;
this.gridColumnApi = params.columnApi;
}
onCellClicked(params) {
if(params.node.field !== 'action') {
this.cancelOtherRowEditors(params.node.rowIndex);
}
}
}
function createRowData() {
var rowData = [];
for (var i = 0; i < 15; i++) {
rowData.push({
row: "Row " + i,
value1: i,
value2: i +10 + 'sampledummydata',
value3: i +30+ 'sampledummydata',
value4: i +30+ 'sampledummydata',
value5: i +30+ 'sampledummydata',
value6: i +30+ 'sampledummydata',
value7: i +30+ 'sampledummydata',
value8: i +30+ 'sampledummydata',
value9: i +30+ 'sampledummydata',
value10: i +30+ 'sampledummydata',
currency: i + Number(Math.random().toFixed(2))
});
}
return rowData;
}
import { NgModule } from "@angular/core";
import { BrowserModule } from "@angular/platform-browser";
import { FormsModule } from "@angular/forms"; // <-- NgModel lives here
// HttpClient
import { HttpClientModule } from "@angular/common/http";
// ag-grid
import { AgGridModule } from "ag-grid-angular";
import { AppComponent } from "./app.component";
import { rowEditComponent } from "./row-edit-component";
@NgModule({
imports: [
BrowserModule,
FormsModule, // <-- import the FormsModule before binding with [(ngModel)]
HttpClientModule,
AgGridModule.withComponents([rowEditComponent])
],
declarations: [AppComponent, rowEditComponent],
bootstrap: [AppComponent]
})
export class AppModule {}
import {Component} from "@angular/core";
import {ICellRendererAngularComp} from "ag-grid-angular";
@Component({
selector: 'child-cell',
template: `
<button type="button" *ngIf="isNew == true" (click) = "onEditClick()" data-action-type="view" class="btn btn-default">
Edit
</button>
<button type="button" *ngIf="isNew == false" (click) = "onUpdateClick()" data-action-type="view" class="btn btn-default">
Update
</button>
<button type="button" *ngIf="isNew == false" (click) = "onCancelClick()" data-action-type="view" class="btn btn-default">
Cancel
</button>
`,
styles: [
`.btn {
line-height: 0.5
}`
]
})
export class rowEditComponent implements ICellRendererAngularComp {
public params: any;
public isNew: any;
agInit(params: any): void {
this.params = params;
}
constructor() {
this.isNew = true;
}
public invokeParentMethod() {
this.params.context.componentParent.methodFromParent(`Row: ${this.params.node.rowIndex}, Col: ${this.params.colDef.headerName}`)
}
refresh(): boolean {
return false;
}
onEditClick() {
const index = this.params.node.rowIndex;
this.params.cancelOtherRowEditors(index);
this.isNew = false;
this.previousData = JSON.parse(JSON.stringify(this.params.node.data));
let cols = this.params.columnApi.getAllGridColumns();
let firstCol = {
"colId": ""
}
if (cols) {
firstCol = cols[0];
}
let rowIndex = this.params.node.rowIndex;
this.params.api.setFocusedCell(rowIndex, firstCol.colId);
this.params.api.startEditingCell({
rowIndex: rowIndex,
colKey: "row"
});
}
onUpdateClick() {
this.isNew = true;
let obj: any = {};
obj.type = "update";
this.params.api.stopEditing();
obj.selectedData = [this.params.data];
// update logic ....
}
public onCancelClick() {
this.isNew = true;
this.params.node.setData(this.previousData);
this.params.api.stopEditing(true);
}
onDeleteClick() {
const selectedData = [this.params.node.data];
console.log(selectedData);
this.params.api.applyTransaction({ remove: selectedData });
}
}
// Angular entry point file
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { AppModule } from 'app/app.module';
platformBrowserDynamic().bootstrapModule(AppModule);
/**
* WEB ANGULAR VERSION
* (based on systemjs.config.js from the angular tutorial - https://angular.io/tutorial)
* System configuration for Angular samples
* Adjust as necessary for your application needs.
*/
var templateUrlRegex = /templateUrl\s*:(\s*['"`](.*?)['"`]\s*)/gm;
var stylesRegex = /styleUrls *:(\s*\[[^\]]*?\])/g;
var stringRegex = /(['`"])((?:[^\\]\\\1|.)*?)\1/g;
module.exports.translate = function(load){
if (load.source.indexOf('moduleId') != -1) return load;
var url = document.createElement('a');
url.href = load.address;
var basePathParts = url.pathname.split('/');
basePathParts.pop();
var basePath = basePathParts.join('/');
var baseHref = document.createElement('a');
baseHref.href = this.baseURL;
baseHref = baseHref.pathname;
if (!baseHref.startsWith('/base/')) { // it is not karma
basePath = basePath.replace(baseHref, '');
}
load.source = load.source
.replace(templateUrlRegex, function(match, quote, url){
var resolvedUrl = url;
if (url.startsWith('.')) {
resolvedUrl = basePath + url.substr(1);
}
return 'templateUrl: "' + resolvedUrl + '"';
})
.replace(stylesRegex, function(match, relativeUrls) {
var urls = [];
while ((match = stringRegex.exec(relativeUrls)) !== null) {
if (match[2].startsWith('.')) {
urls.push('"' + basePath + match[2].substr(1) + '"');
} else {
urls.push('"' + match[2] + '"');
}
}
return "styleUrls: [" + urls.join(', ') + "]";
});
return load;
};
/**
* WEB ANGULAR VERSION
* (based on systemjs.config.js from the angular tutorial - https://angular.io/tutorial)
* System configuration for Angular samples
* Adjust as necessary for your application needs.
*/
(function (global) {
var ANGULAR_VERSION = "5.1.3";
var ANGULAR_CDK_VERSION = "5.2.5";
var ANGULAR_MATERIAL_VERSION = "5.2.5";
function assign() {
var result = {};
for (var i = 0, len = arguments.length; i < len; i++) {
var arg = arguments[i];
for (var prop in arg) {
result[prop] = arg[prop];
}
}
return result;
}
System.config({
// DEMO ONLY! REAL CODE SHOULD NOT TRANSPILE IN THE BROWSER
transpiler: "ts",
typescriptOptions: {
// Copy of compiler options in standard tsconfig.json
target: "es5",
module: "system", //gets rid of console warning
moduleResolution: "node",
sourceMap: true,
emitDecoratorMetadata: true,
experimentalDecorators: true,
lib: ["es2015", "dom"],
noImplicitAny: true,
suppressImplicitAnyIndexErrors: true
},
meta: {
typescript: {
exports: "ts"
},
'*.css': {loader: 'css'}
},
paths:
assign(
{
// paths serve as alias
"npm:": "https://unpkg.com/",
}, systemJsPaths)
,
// RxJS makes a lot of requests to unpkg. This guy addressed it:
// https://github.com/OasisDigital/rxjs-system-bundle.
bundles: {
"npm:rxjs-system-bundle@5.5.5/Rx.system.js": [
"rxjs",
"rxjs/*",
"rxjs/operator/*",
"rxjs/operators/*",
"rxjs/observable/*",
"rxjs/scheduler/*",
"rxjs/symbol/*",
"rxjs/add/operator/*",
"rxjs/add/observable/*",
"rxjs/util/*"
]
},
// map tells the System loader where to look for things
map: assign(
{
// css plugin
'css': 'npm:systemjs-plugin-css/css.js',
// angular bundles
"@angular/animations": "npm:@angular/animations@" + ANGULAR_VERSION + "/bundles/animations.umd.js",
"@angular/animations/browser": "npm:@angular/animations@" + ANGULAR_VERSION + "/bundles/animations-browser.umd.js",
"@angular/core": "npm:@angular/core@" + ANGULAR_VERSION + "/bundles/core.umd.js",
"@angular/common": "npm:@angular/common@" + ANGULAR_VERSION + "/bundles/common.umd.js",
"@angular/common/http": "npm:@angular/common@" + ANGULAR_VERSION + "/bundles/common-http.umd.js",
"@angular/compiler": "npm:@angular/compiler@" + ANGULAR_VERSION + "/bundles/compiler.umd.js",
"@angular/platform-browser": "npm:@angular/platform-browser@" + ANGULAR_VERSION + "/bundles/platform-browser.umd.js",
"@angular/platform-browser/animations": "npm:@angular/platform-browser@" + ANGULAR_VERSION + "/bundles/platform-browser-animations.umd.js",
"@angular/platform-browser-dynamic": "npm:@angular/platform-browser-dynamic@" + ANGULAR_VERSION + "/bundles/platform-browser-dynamic.umd.js",
"@angular/http": "npm:@angular/http@" + ANGULAR_VERSION + "/bundles/http.umd.js",
"@angular/router": "npm:@angular/router@" + ANGULAR_VERSION + "/bundles/router.umd.js",
"@angular/router/upgrade": "npm:@angular/router@" + ANGULAR_VERSION + "/bundles/router-upgrade.umd.js",
"@angular/forms": "npm:@angular/forms@" + ANGULAR_VERSION + "/bundles/forms.umd.js",
"@angular/upgrade": "npm:@angular/upgrade@" + ANGULAR_VERSION + "/bundles/upgrade.umd.js",
"@angular/upgrade/static": "npm:@angular/upgrade@" + ANGULAR_VERSION + "/bundles/upgrade-static.umd.js",
"angular-in-memory-web-api": "npm:angular-in-memory-web-api/bundles/in-memory-web-api.umd.js",
// material design
"@angular/material": "npm:@angular/material@" + ANGULAR_MATERIAL_VERSION + "/bundles/material.umd.js",
"@angular/cdk/platform": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-platform.umd.js",
"@angular/cdk/bidi": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-bidi.umd.js",
"@angular/cdk/coercion": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-coercion.umd.js",
"@angular/cdk/keycodes": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-keycodes.umd.js",
"@angular/cdk/a11y": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-a11y.umd.js",
"@angular/cdk/overlay": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-overlay.umd.js",
"@angular/cdk/portal": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-portal.umd.js",
"@angular/cdk/observers": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-observers.umd.js",
"@angular/cdk/collections": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-collections.umd.js",
"@angular/cdk/accordion": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-accordion.umd.js",
"@angular/cdk/scrolling": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-scrolling.umd.js",
"@angular/cdk/layout": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-layout.umd.js",
"@angular/cdk/table": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-table.umd.js",
"@angular/cdk/text-field": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-text-field.umd.js",
"@angular/cdk/tree": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-tree.umd.js",
"@angular/cdk/stepper": "npm:@angular/cdk@" + ANGULAR_CDK_VERSION + "/bundles/cdk-stepper.umd.js",
// ngx bootstrap
"ngx-bootstrap": "npm:ngx-bootstrap@2.0.0-rc.0",
// ng2 typeahead
"ng2-typeahead": "npm:ng2-typeahead@1.2.0",
ts: "npm:plugin-typescript@5.2.7/lib/plugin.js",
tslib: "npm:tslib@1.7.1/tslib.js",
typescript: "npm:typescript@2.3.2/lib/typescript.js",
// for some of the examples
lodash: "npm:lodash@4.17.4/lodash.js",
// our app is within the app folder, appLocation comes from index.html
app: appLocation + "app",
rxjs: "npm:rxjs@6.1.0/bundles/rxjs.umd.min.js"
},
systemJsMap
),
// packages tells the System loader how to load when no filename and/or no extension
packages: {
app: {
main: "./main.ts",
defaultExtension: "ts",
meta: {
"./*.ts": {
loader: boilerplatePath + "systemjs-angular-loader.js"
}
}
},
'ag-grid-angular': {
main: './bundles/ag-grid-angular.umd.js',
defaultExtension: 'js'
},
'ag-grid-community': {
main: './dist/ag-grid-community.cjs.js',
defaultExtension: 'js'
},
'ag-grid-enterprise': {
main: './dist/ag-grid-enterprise.cjs.js',
defaultExtension: 'js'
},
"@ag-grid-community/angular": {
main: "./bundles/ag-grid-community-angular.umd.js",
defaultExtension: "js"
},
rxjs: {
defaultExtension: false
}
}
});
})(this);