3 "name": "Pman.Tab.XtupleGeneralLedger",
4 "parent": "Pman.Tab.XtupleAccountsTab",
6 "path": "/home/edward/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 "click": "function (_self, e)\n{\n _this.grid.footer.onClick('first');\n}"
549 "|icon": "rootURL + '/Pman/templates/images/search.gif'",
550 "|xns": "Roo.Toolbar"
554 "click": "function (_self, e)\n{\n _this.gltransBox.setValue('');\r\n _this.grid.footer.onClick('first');\r\n}"
558 "|icon": "rootURL + '/Pman/templates/images/edit-clear.gif'",
559 "|xns": "Roo.Toolbar"
562 "|xns": "Roo.Toolbar",
566 "cls": "x-btn-text-icon",
569 "|icon": "rootURL + '/Pman/templates/images/spreadsheet.gif'",
570 "|xns": "Roo.Toolbar",
579 "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}"
581 "text": "Download All Transactions",
587 "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}"
589 "text": "Download All Transactions (Selected Financial Year)",
595 "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}"
597 "text": "Download All Transactions / All Accounts (Selected Financial Year)",
609 "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}"
611 "*prop": "dataSource",
620 "xtype": "HttpProxy",
621 "|url": "baseURL + '/Roo/Metasql.php'",
628 "totalProperty": "total",
629 "xtype": "JsonReader",
630 "|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]",
638 "xtype": "PagingToolbar",
642 "text": "Double Click To Edit",
644 "|xns": "Roo.Toolbar"
649 "*prop": "colModel[]",
650 "dataIndex": "gltrans_date",
654 "xtype": "ColumnModel",
655 "|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}",
659 "*prop": "colModel[]",
660 "dataIndex": "gltrans_source",
661 "header": "Source / Who",
664 "xtype": "ColumnModel",
665 "|renderer": "function(v,x,r) { \n return String.format('{0} - {1}<br/>{2}', v,r.data.gltrans_doctype, r.data.gltrans_username);\n }",
669 "*prop": "colModel[]",
670 "dataIndex": "gltrans_docnumber",
671 "header": "Doc Number",
675 "xtype": "ColumnModel",
679 "*prop": "colModel[]",
680 "dataIndex": "gltrans_notes",
681 "header": "Account / Notes",
683 "xtype": "ColumnModel",
684 "|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}",
689 "xtype": "GridEditor",
702 "*prop": "colModel[]",
704 "dataIndex": "gltrans_base_curr",
705 "header": "Currency",
708 "xtype": "ColumnModel",
709 "|renderer": "function(v) { \n return String.format('{0}', v); \n}",
713 "*prop": "colModel[]",
715 "dataIndex": "gltrans_credit_amount",
719 "xtype": "ColumnModel",
720 "|renderer": "function(v,x,r) { \n return String.format('{0}', v ? Roo.util.Format.number(v*1,2) : '' );\n}",
724 "*prop": "colModel[]",
726 "dataIndex": "gltrans_debit_amount",
730 "xtype": "ColumnModel",
731 "|renderer": "function(v,x,r) { \n return String.format('{0}', v ? Roo.util.Format.number(v*1,2) : '' );\n}",
735 "*prop": "colModel[]",
737 "dataIndex": "gltrans_balance",
741 "xtype": "ColumnModel",
742 "|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}",