aggrid-8.x-1.x-dev/modules/aggrid_demo/config/install/aggrid.aggrid.aggrid_demo_we.yml

langcode: en
status: true
dependencies: {  }
id: aggrid_demo_we
label: 'ag-Grid DEMO Weekly Expenses'
aggridDefault: "{\r\n  \"columnDefs\": [\r\n    {\r\n      \"headerName\": \"Bills\",\r\n      \"field\": \"bills\",\r\n      \"width\": 75,\r\n      \"minWidth\": 75,\r\n      \"autoHeight\": true\r\n    },\r\n    {\r\n      \"headerName\": \"Mon\",\r\n      \"field\": \"mon\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Tue\",\r\n      \"field\": \"tue\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Wed\",\r\n      \"field\": \"wed\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Thu\",\r\n      \"field\": \"thu\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Fri\",\r\n      \"field\": \"fri\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Total\",\r\n      \"field\": \"total\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Rolling Total\",\r\n      \"field\": \"rollingtotal\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Percentage of Grand Total\",\r\n      \"field\": \"pototal\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Expected Cost\",\r\n      \"field\": \"expected\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    },\r\n    {\r\n      \"headerName\": \"Diff (Exp - Tot)\",\r\n      \"field\": \"difference\",\r\n      \"cellRenderer\":\"agAnimateShowChangeCellRenderer\"\r\n    }\r\n  ],\r\n  \"rowSettings\": {\r\n    \"default\": {\r\n      \"rowDefault\": {\r\n        \"parserType\": \"dec\",\r\n        \"formatType\": \"numUsd\",\r\n        \"valueGetter\": \"Number(params.data[params.column.colId]).toFixed(2)\",\r\n        \"constraintType\": {\r\n          \"constraint\": \"Number(params.data[params.column.colId]) >= 0 && Number(params.data[params.column.colId]) <= 2000\",\r\n          \"errorMsg\": \"The amount must be greater than 0 but less than $2,000.00.\"\r\n        }\r\n      },\r\n      \"bills\": {\r\n        \"isRowLabel\": true,\r\n        \"editable\": false,\r\n        \"formatType\": \"\",\r\n        \"parserType\": \"\",\r\n        \"valueGetter\": \"\",\r\n        \"constraintType\": \"\"\r\n      },\r\n      \"total\": {\r\n        \"editable\": false,\r\n        \"valueGetter\": \"(Number(params.data.mon) + Number(params.data.tue) + Number(params.data.wed) + Number(params.data.thu) + Number(params.data.fri)).toFixed(2)\",\r\n        \"constraintType\": \"\",\r\n        \"valueSuppression\": {\r\n          \"any\": true,\r\n          \"role\": [\"anonymous\"]\r\n        }\r\n      },\r\n      \"rollingtotal\": {\r\n        \"editable\": false,\r\n        \"valueGetter\": \"columnTotal(['mon', 'tue', 'wed', 'thu', 'fri'], 0, params.node.childIndex).toFixed(2)\",\r\n        \"constraintType\": \"\"\r\n      },\r\n      \"pototal\": {\r\n        \"editable\": false,\r\n        \"parserType\": \"dec\",\r\n        \"formatType\": \"numPer\",\r\n        \"valueGetter\": \"(Number(params.data.total) / columnTotal(['mon', 'tue', 'wed', 'thu', 'fri'], 0, 3)).toFixed(4)\"\r\n      },\r\n      \"difference\": {\r\n        \"editable\": false,\r\n        \"valueGetter\": \"(Number(params.data.expected) - Number(params.data.total)).toFixed(2)\",\r\n        \"constraintType\": \"\"\r\n      }\r\n    },\r\n    \"4\": {\r\n      \"rowDefault\": {\r\n        \"editable\": false,\r\n        \"cellClass\": \"aggrid-cell-total\",\r\n        \"valueGetter\": \"columnTotal(params.column.colId, 0, 3).toFixed(2)\",\r\n        \"valueSuppression\": {\r\n          \"any\": true,\r\n          \"role\": [\"anonymous\"]\r\n        }\r\n      },\r\n      \"bills\": {\r\n        \"valueGetter\": \"\"\r\n      },\r\n      \"rollingtotal\": {\r\n        \"valueGetter\": \"columnTotal(['mon', 'tue', 'wed', 'thu', 'fri'], 0, 3).toFixed(2)\"\r\n      },\r\n      \"pototal\": {\r\n        \"valueGetter\": \"(Number(params.data.total) / columnTotal(['mon', 'tue', 'wed', 'thu', 'fri'], 0, 3)).toFixed(4)\"\r\n      }\r\n    }\r\n  },\r\n  \"rowData\": [\r\n    {\r\n      \"id\": 1,\r\n      \"bills\": \"Groceries\",\r\n      \"mon\": 0,\r\n      \"tue\": 0,\r\n      \"wed\": 0,\r\n      \"thu\": 0,\r\n      \"fri\": 0,\r\n      \"total\": 0,\r\n      \"rollingtotal\": 0,\r\n      \"pototal\": 0,\r\n      \"expected\": 0,\r\n      \"difference\": 0\r\n    },\r\n    {\r\n      \"id\": 2,\r\n      \"bills\": \"Take-out\",\r\n      \"mon\": 0,\r\n      \"tue\": 0,\r\n      \"wed\": 0,\r\n      \"thu\": 0,\r\n      \"fri\": 0,\r\n      \"total\": 0,\r\n      \"rollingtotal\": 0,\r\n      \"pototal\": 0,\r\n      \"expected\": 0,\r\n      \"difference\": 0\r\n    },\r\n    {\r\n      \"id\": 3,\r\n      \"bills\": \"Clothes\",\r\n      \"mon\": 0,\r\n      \"tue\": 0,\r\n      \"wed\": 0,\r\n      \"thu\": 0,\r\n      \"fri\": 0,\r\n      \"total\": 0,\r\n      \"rollingtotal\": 0,\r\n      \"pototal\": 0,\r\n      \"expected\": 0,\r\n      \"difference\": 0\r\n    },\r\n    {\r\n      \"id\": 4,\r\n      \"bills\": \"Gas\",\r\n      \"mon\": 0,\r\n      \"tue\": 0,\r\n      \"wed\": 0,\r\n      \"thu\": 0,\r\n      \"fri\": 0,\r\n      \"total\": 0,\r\n      \"rollingtotal\": 0,\r\n      \"pototal\": 0,\r\n      \"expected\": 0,\r\n      \"difference\": 0\r\n    },\r\n    {\r\n      \"id\": 5,\r\n      \"bills\": \"Grand Total\",\r\n      \"mon\": 0,\r\n      \"tue\": 0,\r\n      \"wed\": 0,\r\n      \"thu\": 0,\r\n      \"fri\": 0,\r\n      \"total\": 0,\r\n      \"rollingtotal\": 0,\r\n      \"pototal\": 0,\r\n      \"expected\": 0,\r\n      \"difference\": 0\r\n    }\r\n  ]\r\n}"
addOptions: '{}'