3 "name": "Pman.Tab.XtupleGeneralLedger",
4 "parent": "Pman.Tab.XtupleAccountsTab",
6 "path": "/home/alan/gitlive/web.xtuple/Pman/Xtuple/Pman.Tab.XtupleGeneralLedger.bjs",
13 "title": "General Ledger",
14 "xtype": "NestedLayoutPanel",
19 "xtype": "BorderLayout",
25 "xtype": "LayoutRegion",
33 "xtype": "LayoutRegion",
38 "|activate": "function() {\n _this.wpanel = this;\n if (_this.wgrid) {\n _this.wgrid.ds.load({});\n }\n}"
51 "|render": "function() \n{\n _this.wgrid = this; \n _this.active = 1;\n //_this.dialog = Pman.Dialog.FILL_IN\n if (_this.wpanel.active) {\n this.ds.load({});\n }\n}",
52 "rowclick": "function (_self, rowIndex, e)\n{\n var s = _this.wgrid.ds.getAt(rowIndex);\n \n if(s.data.accnt_id * 1 < 1){\n return;\n }\n \n _this.grid.footer.onClick('first');\n \n \n}",
53 "rowdblclick": "function (_self, rowIndex, e)\n{\n var ret = _this.wgrid.ds.getAt(rowIndex).data;\n if(ret.accnt_id * 1 < 1){\n Roo.MessageBox.alert(\"Error\", \"Error occur on getting the account id!\");\n return;\n }\n Pman.Dialog.XtupleGLAccountNameEdit.show( {accnt_id : ret.accnt_id}, function() {\n _this.wgrid.ds.load({});\n }); \n}"
56 "autoExpandColumn": "accnt_descrip",
68 "specialkey": "function (_self, e)\n{\n _this.wgrid.ds.load({});\n}",
69 "render": "function (_self)\n{\n _this.searchBox = _self;\n}"
77 "click": "function (_self, e)\n{\n _this.wgrid.ds.load({});\n}"
81 "|icon": "rootURL + '/Pman/templates/images/search.gif'",
86 "click": "function (_self, e)\n{\n _this.searchBox.setValue('');\r\n _this.wgrid.ds.load({});\r\n}"
90 "|icon": "rootURL + '/Pman/templates/images/edit-clear.gif'",
95 "render": "function (_self)\r\n{\r\n _this.dateSel = _self;\r\n _self.setValue( new Date() );\r\n}",
96 "select": "function (combo, date)\n{\n _this.wgrid.ds.load({});\n}"
101 "xtype": "DateField",
105 "|xns": "Roo.Toolbar",
110 "render": "function (_self)\n{\n _this.orderBox = _self;\n}"
113 "xtype": "TextField",
117 "text": "Download / Upload",
119 "|xns": "Roo.Toolbar",
128 "click": "function (_self, e)\n{\n _this.active = (_this.active) ? 0 : 1;\n this.setText(_this.active ? \"Show Inactive\" : \"Hide Inactive\");\n _this.wgrid.ds.load({});\n}"
130 "text": "Show Inactive",
140 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 60000,\n newWindow : true,\n params : {\n _group : 'accnt',\n _name : 'export',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n \n }\n });;\n Roo.MessageBox.alert(\"Notice\", \"Downloading\");\n}"
142 "text": "Export Account Details",
148 "click": "function (_self, e)\n{\n \n new Pman.download({\n url : baseURL + '/Roo/accnt.php',\n method : 'GET',\n params : {\n 'start' : 0,\n 'limit' : 9999,\n _with_xt_balances : 1,\n 'csvTitles[0]' : 'Name', 'csvCols[0]' : 'accnt_name',\n 'csvTitles[1]' : 'Description', 'csvCols[1]' : 'accnt_descrip',\n 'csvTitles[2]' : 'Alternative Code', 'csvCols[2]' : 'accnt_code_alt',\n 'csvTitles[3]' : 'Alternative Description', 'csvCols[3]' : 'accnt_code_descrip',\n 'csvTitles[4]' : 'ADJUST', 'csvCols[4]' : 'balance_base'\n }\n \n });\n}"
150 "text": "Download Balances",
160 "click": "function (_self, e)\n{\n Pman.Dialog.XtupleUploadBalances.show( {} , function(res) {\n Pman.Dialog.Image.show({\n _url : baseURL + '/Xtuple/Import/JournalEntry?' + Roo.urlEncode(res)\n }, function(data) {\n _this.wgrid.ds.load({});\n });\n }); \n}"
162 "text": "Upload JE adjustment",
168 "click": "function (_self, e)\n{\n Pman.Dialog.Image.show(\n {\n _url : baseURL+'/Xtuple/Import/Accounts',\n timeout : 90000\n \n },\n function (data) {\n Roo.MessageBox.alert(\"Notice\", data); \n _this.grid.footer.onClick('first');\n\n }\n );\n}"
170 "text": "Upload Account Details",
180 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 60000,\n newWindow : true,\n params : {\n _group : 'apopen',\n _name : 'bydate',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n \n }\n });;\n Roo.MessageBox.alert(\"Notice\", \"This may take some time to calculate\");\n}"
182 "text": "Download AP - Day by Day Comparison",
188 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 90000,\n params : {\n _group : 'apopen',\n _name : 'bydatesummary',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n \n }\n });;\n Roo.MessageBox.alert(\"Notice\", \"This may take some time to calculate\");\n}"
190 "text": "Download AP open vs GL - summary of bad days",
196 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 90000,\n params : {\n 'startDate:text' : _this.dateSel.getValue().format('Y-m-d'),\n 'endDate:text' : _this.dateSel.getValue().add(Date.DAY,1).format('Y-m-d'),\n \n _group : 'apopen',\n _name : 'all',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n \n }\n });;\n Roo.MessageBox.alert(\"Notice\", \"This may take some time to calculate\");\n}"
198 "text": "Download AP - Transactions on a single day",
204 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 90000,\n newWindow : 1,\n params : {\n 'relDate:text' : _this.dateSel.getValue().format('Y-m-d'),\n 'useDocDate:text' : 'FALSE',\n \n _group : 'apAging',\n _name : 'bydate',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n \n }\n });;\n Roo.MessageBox.alert(\"Notice\", \"This may take some time to calculate\");\n}\n "
206 "text": "Download AP Aging at this date",
212 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 90000,\n params : {\n 'relDate:text' : _this.dateSel.getValue().format('Y-m-d'),\n \n _group : 'apopen',\n _name : 'history',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n \n }\n });\n Roo.MessageBox.alert(\"Notice\", \"This may take some time to calculate\");\n}\n "
214 "text": "Download AP Aging Comparison back from this date",
224 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n params : {\n _group : 'aropen',\n _name : 'all',\n 'startDate:text' : _this.dateSel.getValue().format('Y-m-d'),\n 'endDate:text' : _this.dateSel.getValue().add(Date.DAY,1).format('Y-m-d'),\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n \n }\n });;\n}"
226 "text": "Download AR - Transactions on a day",
232 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n params : {\n _group : 'aropen',\n _name : 'bydate',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n \n }\n });;\n}"
234 "text": "Download AR - Day by Day Comparison",
243 "text": "Gltrans vs Stock (COHEAD)",
254 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 600000,\n params : {\n _group : 'gltrans_stock',\n _name : 'bydate',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n }\n });\n}"
256 "text": "Download Gltrans vs Stock By Date",
262 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 600000,\n params : {\n _group : 'gltrans_stock',\n _name : 'bycohead',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n }\n });\n}"
264 "text": "Download Gltrans vs Sales Order",
270 "click": "function (_self, e)\n{\n var dt = _this.dateSel.getValue();\n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n params : {\n _group : 'gltrans_stock',\n _name : 'gltrans',\n '_as_of:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n }\n });\n}"
272 "text": "Download Gltrans",
278 "click": "function (_self, e)\n{\n var dt = _this.dateSel.getValue();\n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n params : {\n _group : 'gltrans_stock',\n _name : 'stock',\n '_as_of:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n }\n });\n}"
280 "text": "Download Stock",
293 "text": "Gltrans vs Stock (PO)",
304 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n timeout: 600000,\n params : {\n _group : 'gltrans_stock',\n _name : 'byorder',\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n }\n });\n}"
306 "text": "Download Gltrans vs Stock By PO",
312 "click": "function (_self, e)\n{\n var ord = _this.orderBox.getValue();\n \n if(!ord.length){\n Roo.MessageBox.alert('Error','Please enter a PO number');\n return;\n }\n \n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n params : {\n _group : 'gltrans_stock',\n _name : 'byordergltrans',\n 'docnumber:text' : ord,\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n }\n });\n}"
314 "text": "Download Gltrans",
320 "click": "function (_self, e)\n{\n var ord = _this.orderBox.getValue();\n \n if(!ord.length){\n Roo.MessageBox.alert('Error','Please enter a PO number');\n return;\n }\n \n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n method : 'GET',\n params : {\n _group : 'gltrans_stock',\n _name : 'byorderstock',\n 'docnumber:text' : ord,\n csvCols : '*',\n csvTitles : '*', \n limit : 9999 \n }\n });\n}"
322 "text": "Download Stock",
346 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL+'/Xtuple/Kingdee/Currency',\n method : 'GET',\n timeout: 600000\n });\n Roo.MessageBox.alert(\"Notice\", \"Report will download shortly\");\n}"
354 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL+'/Xtuple/Kingdee/Rate',\n method : 'GET',\n timeout: 600000\n });\n Roo.MessageBox.alert(\"Notice\", \"Report will download shortly\");\n}"
356 "text": "Exchange Rate",
362 "click": "function (_self, e)\n{\n \n new Pman.Download({\n url : baseURL+'/Xtuple/Kingdee/Account',\n method : 'GET',\n timeout: 600000\n });\n Roo.MessageBox.alert(\"Notice\", \"Report will download shortly\");\n}"
370 "click": "function (_self, e)\n{\n new Pman.Download({\n url : baseURL+'/Xtuple/Kingdee/VoucherGroup',\n method : 'GET',\n timeout: 600000\n });\n Roo.MessageBox.alert(\"Notice\", \"Report will download shortly\");\n}"
372 "text": "Voucher Category",
378 "click": "function (_self, e)\n{\n var dt = _this.dateSel.getValue();\n new Pman.Download({\n url : baseURL+'/Xtuple/Kingdee/Voucher',\n method : 'GET',\n timeout: 600000,\n params : {\n _as_of : (typeof(dt) == 'string') ? dt : dt.format('Y-m-d')\n }\n });\n Roo.MessageBox.alert(\"Notice\", \"Report will download shortly - If you wanna import again, please delete all the exist!\");\n}"
380 "text": "Transactions",
396 "beforeload": "function (_self, options)\n{\n options.params = options.params || {};\n \n options.params.limit = 9999;\n \n options.params._general_ledger = 1;\n \n options.params['search[name]'] = _this.searchBox.getValue();\n \n if (_this.active) {\r\n options.params.accnt_active = 1;\n options.params._with_balances = 1;\r\n }\n \n \n \r var dt = _this.dateSel.getValue();\r\n options.params._as_of = typeof(dt) == 'string' ? dt : dt.format('Y-m-d');\n \n\n}"
398 "*prop": "dataSource",
401 "|sortInfo": "{ field : 'accnt_name', direction: 'ASC' }",
406 "loadexception": "function (This, o, arg, e)\n{\n\n}"
410 "xtype": "HttpProxy",
411 "|url": "baseURL + '/Roo/accnt.php'",
418 "totalProperty": "total",
419 "xtype": "JsonReader",
420 "|fields": "[\n {\n 'name': 'accnt_id',\n 'type': 'int'\n },\n {\n 'name': 'accnt_name',\n 'type': 'string'\n },\n {\n 'name': 'accnt_descrip',\n 'type': 'string'\n },\n {\n 'name': 'accnt_type',\n 'type': 'string'\n },\n {\n 'name': 'accnt_subaccnttype_code',\n 'type': 'string'\n },\n {\n 'name': 'accnt_curr_id_curr_name',\n 'type': 'string'\n },\n {\n 'name': 'accnt_curr_id_curr_id',\n 'type': 'int'\n }\n]",
426 "*prop": "colModel[]",
427 "dataIndex": "accnt_name",
431 "xtype": "ColumnModel",
432 "|renderer": "function(v) { return String.format('{0}', v); }",
436 "*prop": "colModel[]",
437 "dataIndex": "accnt_code_alt",
438 "header": "Alternative Code",
442 "xtype": "ColumnModel",
443 "|renderer": "function(v) { return String.format('{0}', v); }",
447 "*prop": "colModel[]",
448 "dataIndex": "accnt_descrip_alt",
449 "header": "Alternative Description",
453 "xtype": "ColumnModel",
454 "|renderer": "function(v) { return String.format('{0}', v); }",
458 "*prop": "colModel[]",
459 "dataIndex": "accnt_type",
463 "xtype": "ColumnModel",
464 "|renderer": "function(v,x,r) {\n return String.format('{0}-{1}', v,r.data.accnt_subaccnttype_code); \n }",
468 "*prop": "colModel[]",
469 "dataIndex": "accnt_descrip",
470 "header": "Description",
473 "xtype": "ColumnModel",
474 "|renderer": "function(v,x,r) \n{ \n if(r.data.accnt_descrip_alt){\n return String.format('{0} ({1})', v, r.data.accnt_descrip_alt); \n }\n \n return String.format('{0}', v); \n}",
478 "*prop": "colModel[]",
480 "dataIndex": "accnt_curr_id_curr_name",
481 "header": "Currency",
484 "xtype": "ColumnModel",
485 "|renderer": "function(v) { \n var base = baseURL.match(/sg\\.php$/) ? 'SGD' : 'HKD';\n if (v != base) {\n return String.format('<span style=\"color:green\">{0}</span>', v); \n }\n\n return String.format('{0}', v); \n}",
489 "*prop": "colModel[]",
490 "dataIndex": "balance",
494 "xtype": "ColumnModel",
495 "|renderer": "function(v) { \r\n return String.format('<span style=\"color:blue;text-decoration:underline;\">{0}</span>',\r\n Roo.util.Format.usMoney(v) ); \n}",
504 "|activate": "function() {\n _this.panel = this;\n /* if (_this.grid) {\n _this.grid.ds.load({});\n } */\n}"
507 "fitContainer": true,
510 "tableName": "gltrans",
511 "title": "Transactions",
512 "xtype": "GridPanel",
517 "|render": "function() \n{\n _this.grid = this; \n //_this.dialog = Pman.Dialog.FILL_IN\n /* if (_this.panel.active) {\n this.ds.load({});\n } */\n}",
518 "afteredit": "function (e)\n{ \n var r = _this.grid.ds.getAt(e.row);\n \n if(e.value == e.originalValue || !r){\n return;\n }\n\n new Pman.Request({\n url : baseURL + '/Roo/Gltrans.php',\n method :'POST',\n params : {\n gltrans_id : r.data.gltrans_id,\n gltrans_notes : e.value,\n _update_notes : 1\n \n },\n success : function() {\n \n _this.grid.footer.onClick('refresh');\n \n }\n });\n \n}",
519 "rowclass": "function (gridview, rowcfg)\n{\n rowcfg.rowClass = 'dragon-gl-fixedheight';\n}",
520 "celldblclick": "function (_self, rowIndex, columnIndex, e)\n{\n var cm = this.colModel.config[columnIndex].dataIndex;\n var r = this.ds.getAt(rowIndex);\n if (cm != 'gltrans_date') {\n return;\n }\n new Pman.Download({\n url : baseURL+ '/Roo/Metasql',\n method : 'GET',\n params : {\n _group : 'gltrans',\n _name : 'sequence',\n 'gltrans_sequence:number' : r.data.gltrans_sequence,\n limit : 9999\n }\n });\n \n}",
521 "cellclick": "function (_self, rowIndex, columnIndex, e)\n{\n if (!Roo.get(e.getTarget()).hasClass('dragon-ref-accounts')) {\n return;\n }\n var r = this.ds.getAt(rowIndex);\n Pman.Dialog.XtupleJournalEntry.show({\n gltrans_id : r.data.gltrans_id\n }, function()\n {\n // no need to refresh as it's viewed only?\n });\n \n \n}"
524 "autoExpandColumn": "gltrans_notes",
527 "xtype": "EditorGrid",
537 "specialkey": "function (_self, e)\n{\n _this.grid.footer.onClick('first');\n}",
538 "render": "function (_self)\n{\n _this.gltransBox = _self;\n}"
540 "xtype": "TextField",
545 "render": "function (_self)\n{\n _this.sourceCombo = _self;\n}",
546 "select": "function (combo, record, index)\n{\n Roo.log('select');\n _this.grid.footer.onClick('first');\n}"
549 "displayField": "fname",
551 "fieldLabel": "Status",
552 "hiddenName": "gltrans_source",
555 "name": "gltrans_source_name",
556 "triggerAction": "all",
557 "value": "NOTCLOSED",
558 "valueField": "ftype",
565 "xtype": "SimpleStore",
566 "|data": "[ \n [ 'NOTCLOSED', \"Not Closed\"],\n [ 'CLOSED' , \"Closed\"],\n [ 'UNPOSTED', \"Unposted only\"] ,\n [ 'UNUSED', \"Posted and not used\"] \n]\n",
567 "|fields": "[ 'ftype', 'fname']",
574 "click": "function (_self, e)\n{\n _this.grid.footer.onClick('first');\n}"
578 "|icon": "rootURL + '/Pman/templates/images/search.gif'",
579 "|xns": "Roo.Toolbar"
583 "click": "function (_self, e)\n{\n _this.gltransBox.setValue('');\r\n _this.grid.footer.onClick('first');\r\n}"
587 "|icon": "rootURL + '/Pman/templates/images/edit-clear.gif'",
588 "|xns": "Roo.Toolbar"
591 "|xns": "Roo.Toolbar",
595 "cls": "x-btn-text-icon",
598 "|icon": "rootURL + '/Pman/templates/images/spreadsheet.gif'",
599 "|xns": "Roo.Toolbar",
608 "click": "function (_self, e)\n{\n var s = _this.wgrid.getSelectionModel().getSelected();\n \n if(!s){\n Roo.MessageBox.alert(\"Error\", \"Please select a account\"); \n return false;\n }\n \n var dt = _this.dateSel.getValue();\n \n if(!dt){\n Roo.MessageBox.alert(\"Error\", \"Please select a date on the right\"); \n return false;\n } \n \n var g = _this.gltransBox.getValue();\n \n var params = {\n '_group' : 'account',\n '_name' : 'summary',\n 'limit' : 99999,\n 'accnt_id:number' : s.data.accnt_id,\n 'endDate:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),\n 'csvTitles' : '*',\n 'csvCols' : '*'\n };\n \n if(g.length){\n params['search:text'] = g;\n }\n \n new Pman.Download({\n url : baseURL + '/Roo/Metasql',\n params : params,\n method : 'GET'\n });\n \n Roo.MessageBox.alert(\"Notice\", \"All Transactions Report for \" + s.data.accnt_descrip + \" will download shortly\");\n}"
610 "text": "Download All Transactions",
616 "click": "function (_self, e)\n{\n var s = _this.wgrid.getSelectionModel().getSelected();\n \n if(!s){\n Roo.MessageBox.alert(\"Error\", \"Please select a account\"); \n return false;\n }\n \n var dt = _this.dateSel.getValue();\n \n if(!dt){\n Roo.MessageBox.alert(\"Error\", \"Please select a date on the right\"); \n return false;\n } \n \n new Pman.Download({\n url : baseURL + '/Roo/Gltrans.php',\n method :'GET',\n params : {\n gltrans_accnt_id : s.data.accnt_id,\n _as_of : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),\n _download : 1\n }\n });\n \n Roo.MessageBox.alert(\"Notice\", \"Financial Year Report for \" + s.data.accnt_descrip + \" will download shortly\");\n}"
618 "text": "Download All Transactions (Selected Financial Year)",
624 "click": "function (_self, e)\n{ \n var dt = _this.dateSel.getValue();\n \n if(!dt){\n Roo.MessageBox.alert(\"Error\", \"Please select a date on the right\"); \n return false;\n } \n \n new Pman.Download({\n url : baseURL + '/Roo/Gltrans.php',\n method :'GET',\n timeout : 900000,\n params : {\n _as_of : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),\n _download : 1\n }\n });\n \n Roo.MessageBox.alert(\"Notice\", \"Financial Year Report for all accounts will download shortly! it might take several minutes\");\n}"
626 "text": "Download All Transactions / All Accounts (Selected Financial Year)",
638 "beforeload": "function (_self, options)\n{\n options.params = options.params || {};\n \n var s = _this.wgrid.getSelectionModel().getSelected();\n \n if(!s){\n return;\n }\n \n var dt = _this.dateSel.getValue();\n var g = _this.gltransBox.getValue();\n \n var params = {\n _group : 'account',\n _name : 'summary',\n 'accnt_id:number' : s.data.accnt_id,\n 'endDate:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d')\n };\n \n if(g.length){\n params['search:text'] = g;\n }\n \n Roo.apply(options.params,params);\n \n var cm = _this.grid.getColumnModel();\n var hide = (g.length) ? true : false;\n \n cm.setHidden(cm.getIndexByDataIndex('gltrans_balance'), hide);\n \n \n}"
640 "*prop": "dataSource",
649 "xtype": "HttpProxy",
650 "|url": "baseURL + '/Roo/Metasql.php'",
657 "totalProperty": "total",
658 "xtype": "JsonReader",
659 "|fields": "[\n {\n 'name': 'gltrans_id',\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_amount',\n 'type': 'int'\n },\n {\n 'name': 'gltrans_notes',\n 'type': 'string'\n }\n]",
667 "xtype": "PagingToolbar",
671 "text": "Double Click To Edit",
673 "|xns": "Roo.Toolbar"
678 "*prop": "colModel[]",
679 "dataIndex": "gltrans_date",
683 "xtype": "ColumnModel",
684 "|renderer": "function(v,x,r) { \n return String.format('{0}<br/><i style=\"color:#ccc;\">{1}</i>',\n v ? v : '', r.data.gltrans_sequence\n ); \n}",
688 "*prop": "colModel[]",
689 "dataIndex": "gltrans_source",
690 "header": "Source / Who",
693 "xtype": "ColumnModel",
694 "|renderer": "function(v,x,r) { \n return String.format('{0} - {1}<br/>{2}', v,r.data.gltrans_doctype, r.data.gltrans_username);\n }",
698 "*prop": "colModel[]",
699 "dataIndex": "gltrans_docnumber",
700 "header": "Doc Number",
704 "xtype": "ColumnModel",
708 "*prop": "colModel[]",
709 "dataIndex": "gltrans_notes",
710 "header": "Account / Notes",
712 "xtype": "ColumnModel",
713 "|renderer": "function(v,x,r) \n{ \n return String.format(\n '<u class=\"dragon-ref-accounts\">{3}</u> - <span qtip=\"{2}\"><b>{0}</b>' + \"\\n\" + '{1}', \n r.data.gltrans_docnumber,\n v, \n v.split('\\n').join('<br/>'),\n r.data.related_accounts\n \n ).split('\\n').join('<br/>');\n \n}",
718 "xtype": "GridEditor",
731 "*prop": "colModel[]",
733 "dataIndex": "gltrans_base_curr",
734 "header": "Currency",
737 "xtype": "ColumnModel",
738 "|renderer": "function(v) { \n return String.format('{0}', v); \n}",
742 "*prop": "colModel[]",
744 "dataIndex": "gltrans_credit_amount",
748 "xtype": "ColumnModel",
749 "|renderer": "function(v,x,r) { \n return String.format('{0}', v ? Roo.util.Format.number(v*1,2) : '' );\n}",
753 "*prop": "colModel[]",
755 "dataIndex": "gltrans_debit_amount",
759 "xtype": "ColumnModel",
760 "|renderer": "function(v,x,r) { \n return String.format('{0}', v ? Roo.util.Format.number(v*1,2) : '' );\n}",
764 "*prop": "colModel[]",
766 "dataIndex": "gltrans_balance",
770 "xtype": "ColumnModel",
771 "|renderer": "function(v) { \n var c =v >= 0.0 ? 'black' : 'red';\n\r\n return String.format('<span style=\"color:' + c + ';\">{0}</span>',\r\n Roo.util.Format.number(v,2) ); \n}",