}
]
},
+ {
+ "|xns": "Roo",
+ "xtype": "GridPanel",
+ "title": "gltrans",
+ "fitToframe": true,
+ "fitContainer": true,
+ "tableName": "gltrans",
+ "background": true,
+ "region": "center",
+ "listeners": {
+ "|activate": "function() {\n _this.panel = this;\n if (_this.grid) {\n _this.grid.footer.onClick('first');\n }\n}"
+ },
+ "items": [
+ {
+ "*prop": "grid",
+ "xtype": "Grid",
+ "autoExpandColumn": "gltrans_source",
+ "loadMask": true,
+ "listeners": {
+ "|render": "function() \n{\n _this.grid = this; \n //_this.dialog = Pman.Dialog.FILL_IN\n if (_this.panel.active) {\n this.footer.onClick('first');\n }\n}",
+ "|rowdblclick": "function (_self, rowIndex, e)\n{\n if (!_this.dialog) return;\n _this.dialog.show( this.getDataSource().getAt(rowIndex).data, function() {\n _this.grid.footer.onClick('first');\n }); \n}\n"
+ },
+ "|xns": "Roo.grid",
+ "items": [
+ {
+ "*prop": "dataSource",
+ "xtype": "Store",
+ "remoteSort": true,
+ "|sortInfo": "{ field : 'gltrans_source', direction: 'ASC' }",
+ "|xns": "Roo.data",
+ "items": [
+ {
+ "*prop": "proxy",
+ "xtype": "HttpProxy",
+ "method": "GET",
+ "|url": "baseURL + '/Roo/gltrans.php'",
+ "|xns": "Roo.data"
+ },
+ {
+ "|xns": "Roo.data",
+ "xtype": "JsonReader",
+ "totalProperty": "total",
+ "root": "data",
+ "*prop": "reader",
+ "id": "id",
+ "|fields": "[\n {\n 'name': 'gltrans_id',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_exported',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_created',\n 'type': 'date',\n 'dateFormat': 'Y-m-d'\n },\n {\n 'name': 'gltrans_date',\n 'type': 'date',\n 'dateFormat': 'Y-m-d'\n },\n {\n 'name': 'gltrans_sequence',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_accnt_id',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_source',\n 'type': 'string'\n },\n {\n 'name': 'gltrans_docnumber',\n 'type': 'string'\n },\n {\n 'name': 'gltrans_misc_id',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_amount',\n 'type': 'float'\n },\n {\n 'name': 'gltrans_notes',\n 'type': 'string'\n },\n {\n 'name': 'gltrans_journalnumber',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_posted',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_doctype',\n 'type': 'string'\n },\n {\n 'name': 'gltrans_rec',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_username',\n 'type': 'string'\n },\n {\n 'name': 'gltrans_deleted',\n 'type': 'int'\n }\n]"
+ }
+ ]
+ },
+ {
+ "*prop": "footer",
+ "xtype": "PagingToolbar",
+ "pageSize": 25,
+ "displayInfo": true,
+ "displayMsg": "Displaying gltrans{0} - {1} of {2}",
+ "emptyMsg": "No gltrans found",
+ "|xns": "Roo"
+ },
+ {
+ "*prop": "toolbar",
+ "xtype": "Toolbar",
+ "|xns": "Roo",
+ "items": [
+ {
+ "text": "Add",
+ "xtype": "Button",
+ "cls": "x-btn-text-icon",
+ "|icon": "Roo.rootURL + 'images/default/dd/drop-add.gif'",
+ "listeners": {
+ "|click": "function()\n{\n if (!_this.dialog) return;\n _this.dialog.show( { id : 0 } , function() {\n _this.grid.footer.onClick('first');\n }); \n}\n"
+ },
+ "|xns": "Roo.Toolbar"
+ },
+ {
+ "text": "Edit",
+ "xtype": "Button",
+ "cls": "x-btn-text-icon",
+ "|icon": "Roo.rootURL + 'images/default/tree/leaf.gif'",
+ "listeners": {
+ "|click": "function()\n{\n var s = _this.grid.getSelectionModel().getSelections();\n if (!s.length || (s.length > 1)) {\n Roo.MessageBox.alert(\"Error\", s.length ? \"Select only one Row\" : \"Select a Row\");\n return;\n }\n if (!_this.dialog) return;\n _this.dialog.show(s[0].data, function() {\n _this.grid.footer.onClick('first');\n }); \n \n}\n"
+ },
+ "|xns": "Roo.Toolbar"
+ },
+ {
+ "text": "Delete",
+ "cls": "x-btn-text-icon",
+ "|icon": "rootURL + '/Pman/templates/images/trash.gif'",
+ "xtype": "Button",
+ "listeners": {
+ "|click": "function()\n{\n Pman.genericDelete(_this, 'gltrans'); \n}\n "
+ },
+ "|xns": "Roo.Toolbar"
+ }
+ ]
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans",
+ "width": 75,
+ "dataIndex": "gltrans_id",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans exported",
+ "width": 75,
+ "dataIndex": "gltrans_exported",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans created",
+ "width": 75,
+ "dataIndex": "gltrans_created",
+ "|renderer": "function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans date",
+ "width": 75,
+ "dataIndex": "gltrans_date",
+ "|renderer": "function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans sequence",
+ "width": 75,
+ "dataIndex": "gltrans_sequence",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans accnt",
+ "width": 75,
+ "dataIndex": "gltrans_accnt_id",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans source",
+ "width": 200,
+ "dataIndex": "gltrans_source",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans docnumber",
+ "width": 200,
+ "dataIndex": "gltrans_docnumber",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans misc",
+ "width": 75,
+ "dataIndex": "gltrans_misc_id",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans amount",
+ "width": 75,
+ "dataIndex": "gltrans_amount",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans notes",
+ "width": 200,
+ "dataIndex": "gltrans_notes",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans journalnumber",
+ "width": 75,
+ "dataIndex": "gltrans_journalnumber",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans posted",
+ "width": 75,
+ "dataIndex": "gltrans_posted",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans doctype",
+ "width": 200,
+ "dataIndex": "gltrans_doctype",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans rec",
+ "width": 75,
+ "dataIndex": "gltrans_rec",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans username",
+ "width": 200,
+ "dataIndex": "gltrans_username",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ },
+ {
+ "xtype": "ColumnModel",
+ "header": "Gltrans deleted",
+ "width": 75,
+ "dataIndex": "gltrans_deleted",
+ "|renderer": "function(v) { return String.format('{0}', v); }",
+ "|xns": "Roo.grid",
+ "*prop": "colModel[]"
+ }
+ ]
+ }
+ ]
+ },
{
"listeners": {
"click": "function (_self, e)\n{\n _this.dialog.hide();\n}"
]
}
]
+ },
+ {
+ xtype: 'GridPanel',
+ xns: Roo,
+ title : "gltrans",
+ fitToframe : true,
+ fitContainer : true,
+ tableName : 'gltrans',
+ background : true,
+ region : 'center',
+ listeners : {
+ activate : function() {
+ _this.panel = this;
+ if (_this.grid) {
+ _this.grid.footer.onClick('first');
+ }
+ }
+ },
+ grid : {
+ xtype: 'Grid',
+ xns: Roo.grid,
+ autoExpandColumn : 'gltrans_source',
+ loadMask : true,
+ listeners : {
+ render : function()
+ {
+ _this.grid = this;
+ //_this.dialog = Pman.Dialog.FILL_IN
+ if (_this.panel.active) {
+ this.footer.onClick('first');
+ }
+ },
+ rowdblclick : function (_self, rowIndex, e)
+ {
+ if (!_this.dialog) return;
+ _this.dialog.show( this.getDataSource().getAt(rowIndex).data, function() {
+ _this.grid.footer.onClick('first');
+ });
+ }
+ },
+ dataSource : {
+ xtype: 'Store',
+ xns: Roo.data,
+ remoteSort : true,
+ sortInfo : { field : 'gltrans_source', direction: 'ASC' },
+ proxy : {
+ xtype: 'HttpProxy',
+ xns: Roo.data,
+ method : 'GET',
+ url : baseURL + '/Roo/gltrans.php'
+ },
+ reader : {
+ xtype: 'JsonReader',
+ xns: Roo.data,
+ totalProperty : 'total',
+ root : 'data',
+ id : 'id',
+ fields : [
+ {
+ 'name': 'gltrans_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'gltrans_exported',
+ 'type': 'int'
+ },
+ {
+ 'name': 'gltrans_created',
+ 'type': 'date',
+ 'dateFormat': 'Y-m-d'
+ },
+ {
+ 'name': 'gltrans_date',
+ 'type': 'date',
+ 'dateFormat': 'Y-m-d'
+ },
+ {
+ 'name': 'gltrans_sequence',
+ 'type': 'int'
+ },
+ {
+ 'name': 'gltrans_accnt_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'gltrans_source',
+ 'type': 'string'
+ },
+ {
+ 'name': 'gltrans_docnumber',
+ 'type': 'string'
+ },
+ {
+ 'name': 'gltrans_misc_id',
+ 'type': 'int'
+ },
+ {
+ 'name': 'gltrans_amount',
+ 'type': 'float'
+ },
+ {
+ 'name': 'gltrans_notes',
+ 'type': 'string'
+ },
+ {
+ 'name': 'gltrans_journalnumber',
+ 'type': 'int'
+ },
+ {
+ 'name': 'gltrans_posted',
+ 'type': 'int'
+ },
+ {
+ 'name': 'gltrans_doctype',
+ 'type': 'string'
+ },
+ {
+ 'name': 'gltrans_rec',
+ 'type': 'int'
+ },
+ {
+ 'name': 'gltrans_username',
+ 'type': 'string'
+ },
+ {
+ 'name': 'gltrans_deleted',
+ 'type': 'int'
+ }
+ ]
+ }
+ },
+ footer : {
+ xtype: 'PagingToolbar',
+ xns: Roo,
+ pageSize : 25,
+ displayInfo : true,
+ displayMsg : "Displaying gltrans{0} - {1} of {2}",
+ emptyMsg : "No gltrans found"
+ },
+ toolbar : {
+ xtype: 'Toolbar',
+ xns: Roo,
+ items : [
+ {
+ xtype: 'Button',
+ xns: Roo.Toolbar,
+ text : "Add",
+ cls : 'x-btn-text-icon',
+ icon : Roo.rootURL + 'images/default/dd/drop-add.gif',
+ listeners : {
+ click : function()
+ {
+ if (!_this.dialog) return;
+ _this.dialog.show( { id : 0 } , function() {
+ _this.grid.footer.onClick('first');
+ });
+ }
+ }
+ },
+ {
+ xtype: 'Button',
+ xns: Roo.Toolbar,
+ text : "Edit",
+ cls : 'x-btn-text-icon',
+ icon : Roo.rootURL + 'images/default/tree/leaf.gif',
+ listeners : {
+ click : function()
+ {
+ var s = _this.grid.getSelectionModel().getSelections();
+ if (!s.length || (s.length > 1)) {
+ Roo.MessageBox.alert("Error", s.length ? "Select only one Row" : "Select a Row");
+ return;
+ }
+ if (!_this.dialog) return;
+ _this.dialog.show(s[0].data, function() {
+ _this.grid.footer.onClick('first');
+ });
+
+ }
+ }
+ },
+ {
+ xtype: 'Button',
+ xns: Roo.Toolbar,
+ text : "Delete",
+ cls : 'x-btn-text-icon',
+ icon : rootURL + '/Pman/templates/images/trash.gif',
+ listeners : {
+ click : function()
+ {
+ Pman.genericDelete(_this, 'gltrans');
+ }
+ }
+ }
+ ]
+ },
+ colModel : [
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans',
+ width : 75,
+ dataIndex : 'gltrans_id',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans exported',
+ width : 75,
+ dataIndex : 'gltrans_exported',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans created',
+ width : 75,
+ dataIndex : 'gltrans_created',
+ renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans date',
+ width : 75,
+ dataIndex : 'gltrans_date',
+ renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans sequence',
+ width : 75,
+ dataIndex : 'gltrans_sequence',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans accnt',
+ width : 75,
+ dataIndex : 'gltrans_accnt_id',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans source',
+ width : 200,
+ dataIndex : 'gltrans_source',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans docnumber',
+ width : 200,
+ dataIndex : 'gltrans_docnumber',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans misc',
+ width : 75,
+ dataIndex : 'gltrans_misc_id',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans amount',
+ width : 75,
+ dataIndex : 'gltrans_amount',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans notes',
+ width : 200,
+ dataIndex : 'gltrans_notes',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans journalnumber',
+ width : 75,
+ dataIndex : 'gltrans_journalnumber',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans posted',
+ width : 75,
+ dataIndex : 'gltrans_posted',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans doctype',
+ width : 200,
+ dataIndex : 'gltrans_doctype',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans rec',
+ width : 75,
+ dataIndex : 'gltrans_rec',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans username',
+ width : 200,
+ dataIndex : 'gltrans_username',
+ renderer : function(v) { return String.format('{0}', v); }
+ },
+ {
+ xtype: 'ColumnModel',
+ xns: Roo.grid,
+ header : 'Gltrans deleted',
+ width : 75,
+ dataIndex : 'gltrans_deleted',
+ renderer : function(v) { return String.format('{0}', v); }
+ }
+ ]
+ }
}
],
north : {
projects / Pman.Xtuple / commitdiff