git.roojs.org Git - Pman.Xtuple/blob - Pman.Tab.XtupleGeneralLedger.bjs

   1 {
   2     "name" : "Pman.Tab.XtupleGeneralLedger",
   3     "parent" : "Pman.Tab.XtupleAccountsTab",
   4     "title" : "",
   5     "path" : "/home/edward/gitlive/web.xtuple/Pman/Xtuple/Pman.Tab.XtupleGeneralLedger.bjs",
   6     "permname" : "",
   7     "modOrder" : "100",
   8     "items" : [
   9         {
  10             "fitToFrame" : true,
  11             "background" : true,
  12             "region" : "center",
  13             "title" : "General Ledger",
  14             "xtype" : "NestedLayoutPanel",
  15             "fitContainer" : true,
  16             "$ xns" : "Roo",
  17             "items" : [
  18                 {
  19                     "xtype" : "BorderLayout",
  20                     "$ xns" : "Roo",
  21                     "* prop" : "layout",
  22                     "items" : [
  23                         {
  24                             "xtype" : "LayoutRegion",
  25                             "tabPosition" : "top",
  26                             "$ xns" : "Roo",
  27                             "* prop" : "center"
  28                         },
  29                         {
  30                             "xtype" : "LayoutRegion",
  31                             "tabPosition" : "top",
  32                             "width" : 600,
  33                             "$ xns" : "Roo",
  34                             "split" : true,
  35                             "* prop" : "west"
  36                         },
  37                         {
  38                             "listeners" : {
  39                                 "|activate" : "function() {\n    _this.wpanel = this;\n    if (_this.wgrid) {\n        _this.wgrid.ds.load({});\n    }\n}"
  40                             },
  41                             "fitToframe" : true,
  42                             "background" : false,
  43                             "region" : "west",
  44                             "title" : "Account",
  45                             "xtype" : "GridPanel",
  46                             "fitContainer" : true,
  47                             "$ xns" : "Roo",
  48                             "tableName" : "accnt",
  49                             "items" : [
  50                                 {
  51                                     "listeners" : {
  52                                         "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}",
  53                                         "|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}",
  54                                         "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}"
  55                                     },
  56                                     "autoExpandColumn" : "accnt_descrip",
  57                                     "xtype" : "Grid",
  58                                     "loadMask" : true,
  59                                     "$ xns" : "Roo.grid",
  60                                     "* prop" : "grid",
  61                                     "items" : [
  62                                         {
  63                                             "xtype" : "Toolbar",
  64                                             "$ xns" : "Roo",
  65                                             "* prop" : "toolbar",
  66                                             "items" : [
  67                                                 {
  68                                                     "listeners" : {
  69                                                         "specialkey" : "function (_self, e)\n{\n  _this.wgrid.ds.load({});\n}",
  70                                                         "render" : "function (_self)\n{\n    _this.searchBox = _self;\n}"
  71                                                     },
  72                                                     "xtype" : "TextField",
  73                                                     "$ xns" : "Roo.form",
  74                                                     "width" : 100
  75                                                 },
  76                                                 {
  77                                                     "listeners" : {
  78                                                         "click" : "function (_self, e)\n{\n    _this.wgrid.ds.load({});\n}"
  79                                                     },
  80                                                     "xtype" : "Button",
  81                                                     "cls" : "x-btn-icon",
  82                                                     "$ icon" : "rootURL + '/Pman/templates/images/search.gif'",
  83                                                     "$ xns" : "Roo.Toolbar"
  84                                                 },
  85                                                 {
  86                                                     "listeners" : {
  87                                                         "click" : "function (_self, e)\n{\n    _this.searchBox.setValue('');\r\n    _this.wgrid.ds.load({});\r\n}"
  88                                                     },
  89                                                     "xtype" : "Button",
  90                                                     "cls" : "x-btn-icon",
  91                                                     "$ icon" : "rootURL + '/Pman/templates/images/edit-clear.gif'",
  92                                                     "$ xns" : "Roo.Toolbar"
  93                                                 },
  94                                                 {
  95                                                     "listeners" : {
  96                                                         "render" : "function (_self)\r\n{\r\n    _this.dateSel = _self;\r\n   _self.setValue(  new Date() );\r\n}",
  97                                                         "select" : "function (combo, date)\n{\n    _this.wgrid.ds.load({});\n}"
  98                                                     },
  99                                                     "format" : "d/M/Y",
 100                                                     "xtype" : "DateField",
 101                                                     "allowBlank" : false,
 102                                                     "width" : 100,
 103                                                     "$ xns" : "Roo.form"
 104                                                 },
 105                                                 {
 106                                                     "xtype" : "Fill",
 107                                                     "$ xns" : "Roo.Toolbar"
 108                                                 },
 109                                                 {
 110                                                     "listeners" : {
 111                                                         "render" : "function (_self)\n{\n    _this.orderBox = _self;\n}"
 112                                                     },
 113                                                     "xtype" : "TextField",
 114                                                     "$ xns" : "Roo.form",
 115                                                     "width" : 80
 116                                                 },
 117                                                 {
 118                                                     "text" : "Download / Upload",
 119                                                     "xtype" : "Button",
 120                                                     "$ xns" : "Roo.Toolbar",
 121                                                     "items" : [
 122                                                         {
 123                                                             "xtype" : "Menu",
 124                                                             "$ xns" : "Roo.menu",
 125                                                             "* prop" : "menu",
 126                                                             "items" : [
 127                                                                 {
 128                                                                     "listeners" : {
 129                                                                         "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                                                                     },
 131                                                                     "text" : "Show Inactive",
 132                                                                     "xtype" : "Item",
 133                                                                     "$ xns" : "Roo.menu"
 134                                                                 },
 135                                                                 {
 136                                                                     "xtype" : "Separator",
 137                                                                     "$ xns" : "Roo.menu"
 138                                                                 },
 139                                                                 {
 140                                                                     "listeners" : {
 141                                                                         "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                                                                     },
 143                                                                     "text" : "Export Account Details",
 144                                                                     "xtype" : "Item",
 145                                                                     "$ xns" : "Roo.menu"
 146                                                                 },
 147                                                                 {
 148                                                                     "listeners" : {
 149                                                                         "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                                                                     },
 151                                                                     "text" : "Download Balances",
 152                                                                     "xtype" : "Item",
 153                                                                     "$ xns" : "Roo.menu"
 154                                                                 },
 155                                                                 {
 156                                                                     "xtype" : "Separator",
 157                                                                     "$ xns" : "Roo.menu"
 158                                                                 },
 159                                                                 {
 160                                                                     "listeners" : {
 161                                                                         "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                                                                     },
 163                                                                     "text" : "Upload JE adjustment",
 164                                                                     "xtype" : "Item",
 165                                                                     "$ xns" : "Roo.menu"
 166                                                                 },
 167                                                                 {
 168                                                                     "listeners" : {
 169                                                                         "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                                                                     },
 171                                                                     "text" : "Upload Account Details",
 172                                                                     "xtype" : "Item",
 173                                                                     "$ xns" : "Roo.menu"
 174                                                                 },
 175                                                                 {
 176                                                                     "xtype" : "Separator",
 177                                                                     "$ xns" : "Roo.menu"
 178                                                                 },
 179                                                                 {
 180                                                                     "listeners" : {
 181                                                                         "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                                                                     },
 183                                                                     "text" : "Download AP - Day by Day Comparison",
 184                                                                     "xtype" : "Item",
 185                                                                     "$ xns" : "Roo.menu"
 186                                                                 },
 187                                                                 {
 188                                                                     "listeners" : {
 189                                                                         "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                                                                     },
 191                                                                     "text" : "Download AP open vs GL - summary of bad days",
 192                                                                     "xtype" : "Item",
 193                                                                     "$ xns" : "Roo.menu"
 194                                                                 },
 195                                                                 {
 196                                                                     "listeners" : {
 197                                                                         "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                                                                     },
 199                                                                     "text" : "Download AP - Transactions on a single day",
 200                                                                     "xtype" : "Item",
 201                                                                     "$ xns" : "Roo.menu"
 202                                                                 },
 203                                                                 {
 204                                                                     "listeners" : {
 205                                                                         "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                                                                     },
 207                                                                     "text" : "Download AP Aging at this date",
 208                                                                     "xtype" : "Item",
 209                                                                     "$ xns" : "Roo.menu"
 210                                                                 },
 211                                                                 {
 212                                                                     "listeners" : {
 213                                                                         "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                                                                     },
 215                                                                     "text" : "Download AP Aging Comparison back from this date",
 216                                                                     "xtype" : "Item",
 217                                                                     "$ xns" : "Roo.menu"
 218                                                                 },
 219                                                                 {
 220                                                                     "xtype" : "Separator",
 221                                                                     "$ xns" : "Roo.menu"
 222                                                                 },
 223                                                                 {
 224                                                                     "listeners" : {
 225                                                                         "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                                                                     },
 227                                                                     "text" : "Download AR - Transactions on a day",
 228                                                                     "xtype" : "Item",
 229                                                                     "$ xns" : "Roo.menu"
 230                                                                 },
 231                                                                 {
 232                                                                     "listeners" : {
 233                                                                         "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                                                                     },
 235                                                                     "text" : "Download AR - Day by Day Comparison",
 236                                                                     "xtype" : "Item",
 237                                                                     "$ xns" : "Roo.menu"
 238                                                                 },
 239                                                                 {
 240                                                                     "xtype" : "Separator",
 241                                                                     "$ xns" : "Roo.menu"
 242                                                                 },
 243                                                                 {
 244                                                                     "text" : "Gltrans vs Stock (COHEAD)",
 245                                                                     "xtype" : "Item",
 246                                                                     "$ xns" : "Roo.menu",
 247                                                                     "items" : [
 248                                                                         {
 249                                                                             "xtype" : "Menu",
 250                                                                             "$ xns" : "Roo.menu",
 251                                                                             "* prop" : "menu",
 252                                                                             "items" : [
 253                                                                                 {
 254                                                                                     "listeners" : {
 255                                                                                         "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                                                                                     },
 257                                                                                     "text" : "Download Gltrans vs Stock By Date",
 258                                                                                     "xtype" : "Item",
 259                                                                                     "$ xns" : "Roo.menu"
 260                                                                                 },
 261                                                                                 {
 262                                                                                     "listeners" : {
 263                                                                                         "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                                                                                     },
 265                                                                                     "text" : "Download Gltrans vs Sales Order",
 266                                                                                     "xtype" : "Item",
 267                                                                                     "$ xns" : "Roo.menu"
 268                                                                                 },
 269                                                                                 {
 270                                                                                     "listeners" : {
 271                                                                                         "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                                                                                     },
 273                                                                                     "text" : "Download Gltrans",
 274                                                                                     "xtype" : "Item",
 275                                                                                     "$ xns" : "Roo.menu"
 276                                                                                 },
 277                                                                                 {
 278                                                                                     "listeners" : {
 279                                                                                         "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                                                                                     },
 281                                                                                     "text" : "Download Stock",
 282                                                                                     "xtype" : "Item",
 283                                                                                     "$ xns" : "Roo.menu"
 284                                                                                 }
 285                                                                             ]
 286                                                                         }
 287                                                                     ]
 288                                                                 },
 289                                                                 {
 290                                                                     "xtype" : "Separator",
 291                                                                     "$ xns" : "Roo.menu"
 292                                                                 },
 293                                                                 {
 294                                                                     "text" : "Gltrans vs Stock (PO)",
 295                                                                     "xtype" : "Item",
 296                                                                     "$ xns" : "Roo.menu",
 297                                                                     "items" : [
 298                                                                         {
 299                                                                             "xtype" : "Menu",
 300                                                                             "$ xns" : "Roo.menu",
 301                                                                             "* prop" : "menu",
 302                                                                             "items" : [
 303                                                                                 {
 304                                                                                     "listeners" : {
 305                                                                                         "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                                                                                     },
 307                                                                                     "text" : "Download Gltrans vs Stock By PO",
 308                                                                                     "xtype" : "Item",
 309                                                                                     "$ xns" : "Roo.menu"
 310                                                                                 },
 311                                                                                 {
 312                                                                                     "listeners" : {
 313                                                                                         "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                                                                                     },
 315                                                                                     "text" : "Download Gltrans",
 316                                                                                     "xtype" : "Item",
 317                                                                                     "$ xns" : "Roo.menu"
 318                                                                                 },
 319                                                                                 {
 320                                                                                     "listeners" : {
 321                                                                                         "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                                                                                     },
 323                                                                                     "text" : "Download Stock",
 324                                                                                     "xtype" : "Item",
 325                                                                                     "$ xns" : "Roo.menu"
 326                                                                                 }
 327                                                                             ]
 328                                                                         }
 329                                                                     ]
 330                                                                 },
 331                                                                 {
 332                                                                     "xtype" : "Separator",
 333                                                                     "$ xns" : "Roo.menu"
 334                                                                 },
 335                                                                 {
 336                                                                     "text" : "Kingdee",
 337                                                                     "xtype" : "Item",
 338                                                                     "$ xns" : "Roo.menu",
 339                                                                     "items" : [
 340                                                                         {
 341                                                                             "xtype" : "Menu",
 342                                                                             "$ xns" : "Roo.menu",
 343                                                                             "* prop" : "menu",
 344                                                                             "items" : [
 345                                                                                 {
 346                                                                                     "listeners" : {
 347                                                                                         "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}"
 348                                                                                     },
 349                                                                                     "text" : "Currency",
 350                                                                                     "xtype" : "Item",
 351                                                                                     "$ xns" : "Roo.menu"
 352                                                                                 },
 353                                                                                 {
 354                                                                                     "listeners" : {
 355                                                                                         "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                                                                                     },
 357                                                                                     "text" : "Exchange Rate",
 358                                                                                     "xtype" : "Item",
 359                                                                                     "$ xns" : "Roo.menu"
 360                                                                                 },
 361                                                                                 {
 362                                                                                     "listeners" : {
 363                                                                                         "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}"
 364                                                                                     },
 365                                                                                     "text" : "Accounts",
 366                                                                                     "xtype" : "Item",
 367                                                                                     "$ xns" : "Roo.menu"
 368                                                                                 },
 369                                                                                 {
 370                                                                                     "listeners" : {
 371                                                                                         "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                                                                                     },
 373                                                                                     "text" : "Voucher Category",
 374                                                                                     "xtype" : "Item",
 375                                                                                     "$ xns" : "Roo.menu"
 376                                                                                 },
 377                                                                                 {
 378                                                                                     "listeners" : {
 379                                                                                         "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                                                                                     },
 381                                                                                     "text" : "Transactions",
 382                                                                                     "xtype" : "Item",
 383                                                                                     "$ xns" : "Roo.menu"
 384                                                                                 }
 385                                                                             ]
 386                                                                         }
 387                                                                     ]
 388                                                                 }
 389                                                             ]
 390                                                         }
 391                                                     ]
 392                                                 }
 393                                             ]
 394                                         },
 395                                         {
 396                                             "listeners" : {
 397                                                 "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                                             },
 399                                             "xtype" : "Store",
 400                                             "remoteSort" : true,
 401                                             "$ sortInfo" : "{ field : 'accnt_name', direction: 'ASC' }",
 402                                             "$ xns" : "Roo.data",
 403                                             "* prop" : "dataSource",
 404                                             "items" : [
 405                                                 {
 406                                                     "listeners" : {
 407                                                         "loadexception" : "function (This, o, arg, e)\n{\n\n}"
 408                                                     },
 409                                                     "$ url" : "baseURL + '/Roo/accnt.php'",
 410                                                     "xtype" : "HttpProxy",
 411                                                     "method" : "GET",
 412                                                     "$ xns" : "Roo.data",
 413                                                     "* prop" : "proxy"
 414                                                 },
 415                                                 {
 416                                                     "id" : "accnt_id",
 417                                                     "root" : "data",
 418                                                     "xtype" : "JsonReader",
 419                                                     "$ 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]",
 420                                                     "$ xns" : "Roo.data",
 421                                                     "* prop" : "reader",
 422                                                     "totalProperty" : "total"
 423                                                 }
 424                                             ]
 425                                         },
 426                                         {
 427                                             "xtype" : "ColumnModel",
 428                                             "sortable" : true,
 429                                             "header" : "Name",
 430                                             "width" : 100,
 431                                             "$ renderer" : "function(v) { return String.format('{0}', v); }",
 432                                             "$ xns" : "Roo.grid",
 433                                             "* prop" : "colModel[]",
 434                                             "dataIndex" : "accnt_name"
 435                                         },
 436                                         {
 437                                             "hidden" : true,
 438                                             "xtype" : "ColumnModel",
 439                                             "sortable" : true,
 440                                             "header" : "Alternative Code",
 441                                             "width" : 50,
 442                                             "$ renderer" : "function(v) { return String.format('{0}', v); }",
 443                                             "$ xns" : "Roo.grid",
 444                                             "* prop" : "colModel[]",
 445                                             "dataIndex" : "accnt_code_alt"
 446                                         },
 447                                         {
 448                                             "hidden" : true,
 449                                             "xtype" : "ColumnModel",
 450                                             "sortable" : true,
 451                                             "header" : "Alternative Description",
 452                                             "width" : 50,
 453                                             "$ renderer" : "function(v) { return String.format('{0}', v); }",
 454                                             "$ xns" : "Roo.grid",
 455                                             "* prop" : "colModel[]",
 456                                             "dataIndex" : "accnt_descrip_alt"
 457                                         },
 458                                         {
 459                                             "xtype" : "ColumnModel",
 460                                             "sortable" : true,
 461                                             "header" : "Type",
 462                                             "width" : 50,
 463                                             "$ renderer" : "function(v,x,r) {\n     return String.format('{0}-{1}', v,r.data.accnt_subaccnttype_code); \n }",
 464                                             "$ xns" : "Roo.grid",
 465                                             "* prop" : "colModel[]",
 466                                             "dataIndex" : "accnt_type"
 467                                         },
 468                                         {
 469                                             "xtype" : "ColumnModel",
 470                                             "sortable" : true,
 471                                             "header" : "Description",
 472                                             "width" : 200,
 473                                             "$ 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}",
 474                                             "$ xns" : "Roo.grid",
 475                                             "* prop" : "colModel[]",
 476                                             "dataIndex" : "accnt_descrip"
 477                                         },
 478                                         {
 479                                             "align" : "right",
 480                                             "xtype" : "ColumnModel",
 481                                             "sortable" : true,
 482                                             "header" : "Currency",
 483                                             "width" : 50,
 484                                             "$ 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}",
 485                                             "$ xns" : "Roo.grid",
 486                                             "* prop" : "colModel[]",
 487                                             "dataIndex" : "accnt_curr_id_curr_name"
 488                                         },
 489                                         {
 490                                             "xtype" : "ColumnModel",
 491                                             "sortable" : true,
 492                                             "header" : "Balance",
 493                                             "width" : 100,
 494                                             "$ 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}",
 495                                             "$ xns" : "Roo.grid",
 496                                             "* prop" : "colModel[]",
 497                                             "dataIndex" : "balance"
 498                                         }
 499                                     ]
 500                                 }
 501                             ]
 502                         },
 503                         {
 504                             "listeners" : {
 505                                 "|activate" : "function() {\n    _this.panel = this;\n /*   if (_this.grid) {\n        _this.grid.ds.load({});\n    } */\n}"
 506                             },
 507                             "fitToframe" : true,
 508                             "background" : false,
 509                             "region" : "center",
 510                             "title" : "Transactions",
 511                             "xtype" : "GridPanel",
 512                             "fitContainer" : true,
 513                             "$ xns" : "Roo",
 514                             "tableName" : "gltrans",
 515                             "items" : [
 516                                 {
 517                                     "listeners" : {
 518                                         "|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}",
 519                                         "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}",
 520                                         "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}",
 521                                         "rowclass" : "function (gridview, rowcfg)\n{\n  rowcfg.rowClass = 'dragon-gl-fixedheight';\n}",
 522                                         "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}"
 523                                     },
 524                                     "autoExpandColumn" : "gltrans_notes",
 525                                     "xtype" : "EditorGrid",
 526                                     "loadMask" : true,
 527                                     "clicksToEdit" : 2,
 528                                     "$ xns" : "Roo.grid",
 529                                     "* prop" : "grid",
 530                                     "items" : [
 531                                         {
 532                                             "xtype" : "Toolbar",
 533                                             "$ xns" : "Roo",
 534                                             "* prop" : "toolbar",
 535                                             "items" : [
 536                                                 {
 537                                                     "listeners" : {
 538                                                         "specialkey" : "function (_self, e)\n{\n  _this.grid.footer.onClick('first');\n}",
 539                                                         "render" : "function (_self)\n{\n    _this.gltransBox = _self;\n}"
 540                                                     },
 541                                                     "xtype" : "TextField",
 542                                                     "$ xns" : "Roo.form"
 543                                                 },
 544                                                 {
 545                                                     "listeners" : {
 546                                                         "render" : "function (_self)\n{\n  _this.sourceCombo = _self;\n}",
 547                                                         "select" : "function (combo, record, index)\n{\n    Roo.log('select');\n    _this.grid.footer.onClick('first');\n}"
 548                                                     },
 549                                                     "listWidth" : 200,
 550                                                     "triggerAction" : "all",
 551                                                     "displayField" : "gltrans_source_name",
 552                                                     "hiddenName" : "gltrans_source",
 553                                                     "value" : "ALL",
 554                                                     "valueField" : "gltrans_source",
 555                                                     "xtype" : "ComboBox",
 556                                                     "allowBlank" : false,
 557                                                     "editable" : false,
 558                                                     "width" : 150,
 559                                                     "$ xns" : "Roo.form",
 560                                                     "mode" : "local",
 561                                                     "name" : "gltrans_source_name",
 562                                                     "tpl" : "<div class=\"x-grid-cell-text x-btn button\"><b>{gltrans_source_name}</b> </div>",
 563                                                     "items" : [
 564                                                         {
 565                                                             "xtype" : "SimpleStore",
 566                                                             "$ data" : "[ \n    [ 'ALL', \"All Transactions\"],\n    [ 'S/R' , \"Sales Return\"],\n    [ 'S/O', \"Sales Orders\"] ,\n    [ 'A/P', \"Accounts Payable\"] ,\n    [ 'A/R', \"Accounts Recievable\"] ,\n    [ 'I/M', \"Inventory \"] ,\n    [ 'G/L', \"General Ledger \"] \n    \n    \n]\n",
 567                                                             "$ fields" : "[  'gltrans_source', 'gltrans_source_name']",
 568                                                             "$ xns" : "Roo.data",
 569                                                             "* prop" : "store"
 570                                                         }
 571                                                     ]
 572                                                 },
 573                                                 {
 574                                                     "listeners" : {
 575                                                         "click" : "function (_self, e)\n{\n    _this.grid.footer.onClick('first');\n}"
 576                                                     },
 577                                                     "xtype" : "Button",
 578                                                     "cls" : "x-btn-icon",
 579                                                     "$ icon" : "rootURL + '/Pman/templates/images/search.gif'",
 580                                                     "$ xns" : "Roo.Toolbar"
 581                                                 },
 582                                                 {
 583                                                     "listeners" : {
 584                                                         "click" : "function (_self, e)\n{\n    _this.gltransBox.setValue('');\r\n    _this.grid.footer.onClick('first');\r\n}"
 585                                                     },
 586                                                     "xtype" : "Button",
 587                                                     "cls" : "x-btn-icon",
 588                                                     "$ icon" : "rootURL + '/Pman/templates/images/edit-clear.gif'",
 589                                                     "$ xns" : "Roo.Toolbar"
 590                                                 },
 591                                                 {
 592                                                     "xtype" : "Fill",
 593                                                     "$ xns" : "Roo.Toolbar"
 594                                                 },
 595                                                 {
 596                                                     "text" : "Download",
 597                                                     "xtype" : "Button",
 598                                                     "cls" : "x-btn-text-icon",
 599                                                     "$ icon" : "rootURL + '/Pman/templates/images/spreadsheet.gif'",
 600                                                     "$ xns" : "Roo.Toolbar",
 601                                                     "items" : [
 602                                                         {
 603                                                             "xtype" : "Menu",
 604                                                             "$ xns" : "Roo.menu",
 605                                                             "* prop" : "menu",
 606                                                             "items" : [
 607                                                                 {
 608                                                                     "listeners" : {
 609                                                                         "click" : "function (_self, e)\n{\n    \n    new Pman.Download({\n        grid : _this.grid,\n        csvCols : '*',\n        csvTitles : '*',\n        method : 'GET'\n    });\n    \n    Roo.MessageBox.alert(\"Notice\", \"Search Transactions Report for \" + s.data.accnt_descrip + \" will download shortly\");\n}"
 610                                                                     },
 611                                                                     "text" : "Transactions from search result",
 612                                                                     "xtype" : "Item",
 613                                                                     "$ xns" : "Roo.menu"
 614                                                                 },
 615                                                                 {
 616                                                                     "xtype" : "Separator",
 617                                                                     "$ xns" : "Roo.menu"
 618                                                                 },
 619                                                                 {
 620                                                                     "listeners" : {
 621                                                                         "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}"
 622                                                                     },
 623                                                                     "text" : "All Transactions",
 624                                                                     "xtype" : "Item",
 625                                                                     "$ xns" : "Roo.menu"
 626                                                                 },
 627                                                                 {
 628                                                                     "listeners" : {
 629                                                                         "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}"
 630                                                                     },
 631                                                                     "text" : "All Transactions (Selected Financial Year)",
 632                                                                     "xtype" : "Item",
 633                                                                     "$ xns" : "Roo.menu"
 634                                                                 },
 635                                                                 {
 636                                                                     "listeners" : {
 637                                                                         "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}"
 638                                                                     },
 639                                                                     "text" : "All Transactions  / All Accounts (Selected Financial Year)",
 640                                                                     "xtype" : "Item",
 641                                                                     "$ xns" : "Roo.menu"
 642                                                                 }
 643                                                             ]
 644                                                         }
 645                                                     ]
 646                                                 }
 647                                             ]
 648                                         },
 649                                         {
 650                                             "listeners" : {
 651                                                 "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    // can not do source + search..\n    var source = _this.sourceCombo.getValue();\n    if (source != 'ALL') {\n        params['search:text']  = source;\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}"
 652                                             },
 653                                             "xtype" : "Store",
 654                                             "remoteSort" : true,
 655                                             "$ xns" : "Roo.data",
 656                                             "* prop" : "dataSource",
 657                                             "items" : [
 658                                                 {
 659                                                     "$ url" : "baseURL + '/Roo/Metasql.php'",
 660                                                     "method" : "GET",
 661                                                     "xtype" : "HttpProxy",
 662                                                     "timeout" : 600000,
 663                                                     "$ xns" : "Roo.data",
 664                                                     "* prop" : "proxy"
 665                                                 },
 666                                                 {
 667                                                     "id" : "gltrans_id",
 668                                                     "root" : "data",
 669                                                     "xtype" : "JsonReader",
 670                                                     "$ 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]",
 671                                                     "$ xns" : "Roo.data",
 672                                                     "* prop" : "reader",
 673                                                     "totalProperty" : "total"
 674                                                 }
 675                                             ]
 676                                         },
 677                                         {
 678                                             "pageSize" : 100,
 679                                             "xtype" : "PagingToolbar",
 680                                             "$ xns" : "Roo",
 681                                             "* prop" : "footer",
 682                                             "items" : [
 683                                                 {
 684                                                     "text" : "Double Click To Edit",
 685                                                     "xtype" : "TextItem",
 686                                                     "$ xns" : "Roo.Toolbar"
 687                                                 }
 688                                             ]
 689                                         },
 690                                         {
 691                                             "xtype" : "ColumnModel",
 692                                             "sortable" : true,
 693                                             "header" : "Date",
 694                                             "width" : 100,
 695                                             "$ 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}",
 696                                             "$ xns" : "Roo.grid",
 697                                             "* prop" : "colModel[]",
 698                                             "dataIndex" : "gltrans_date"
 699                                         },
 700                                         {
 701                                             "hidden" : true,
 702                                             "xtype" : "ColumnModel",
 703                                             "sortable" : true,
 704                                             "header" : "Date",
 705                                             "width" : 100,
 706                                             "$ renderer" : "function(v,x,r) { \n    return String.format('{0}', v); \n}",
 707                                             "$ xns" : "Roo.grid",
 708                                             "* prop" : "colModel[]",
 709                                             "dataIndex" : "gltrans_created"
 710                                         },
 711                                         {
 712                                             "xtype" : "ColumnModel",
 713                                             "sortable" : true,
 714                                             "header" : "Source / Who",
 715                                             "width" : 100,
 716                                             "$ renderer" : "function(v,x,r) { \n    return String.format('{0} - {1}<br/>{2} <i style=\"color:#ccc;\">{3}</i>',\n    \n             v,r.data.gltrans_doctype, \n             r.data.gltrans_username,\n             r.data.gltrans_created);\n }",
 717                                             "$ xns" : "Roo.grid",
 718                                             "* prop" : "colModel[]",
 719                                             "dataIndex" : "gltrans_source"
 720                                         },
 721                                         {
 722                                             "hidden" : true,
 723                                             "xtype" : "ColumnModel",
 724                                             "sortable" : true,
 725                                             "header" : "Doc Number",
 726                                             "width" : 100,
 727                                             "$ xns" : "Roo.grid",
 728                                             "* prop" : "colModel[]",
 729                                             "dataIndex" : "gltrans_docnumber"
 730                                         },
 731                                         {
 732                                             "xtype" : "ColumnModel",
 733                                             "header" : "Account / Notes",
 734                                             "width" : 200,
 735                                             "$ 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}",
 736                                             "$ xns" : "Roo.grid",
 737                                             "* prop" : "colModel[]",
 738                                             "dataIndex" : "gltrans_notes",
 739                                             "items" : [
 740                                                 {
 741                                                     "xtype" : "GridEditor",
 742                                                     "$ xns" : "Roo.grid",
 743                                                     "* prop" : "editor",
 744                                                     "items" : [
 745                                                         {
 746                                                             "xtype" : "TextArea",
 747                                                             "$ xns" : "Roo.form",
 748                                                             "* prop" : "field"
 749                                                         }
 750                                                     ]
 751                                                 }
 752                                             ]
 753                                         },
 754                                         {
 755                                             "align" : "right",
 756                                             "xtype" : "ColumnModel",
 757                                             "sortable" : true,
 758                                             "header" : "Currency",
 759                                             "width" : 75,
 760                                             "$ renderer" : "function(v) { \n    return String.format('{0}', v); \n}",
 761                                             "$ xns" : "Roo.grid",
 762                                             "* prop" : "colModel[]",
 763                                             "dataIndex" : "gltrans_base_curr"
 764                                         },
 765                                         {
 766                                             "align" : "right",
 767                                             "xtype" : "ColumnModel",
 768                                             "sortable" : true,
 769                                             "header" : "Credit",
 770                                             "width" : 100,
 771                                             "$ renderer" : "function(v,x,r) { \n    return String.format('{0}', v ? Roo.util.Format.number(v*1,2)  : ''  );\n}",
 772                                             "$ xns" : "Roo.grid",
 773                                             "* prop" : "colModel[]",
 774                                             "dataIndex" : "gltrans_credit_amount"
 775                                         },
 776                                         {
 777                                             "align" : "right",
 778                                             "xtype" : "ColumnModel",
 779                                             "sortable" : true,
 780                                             "header" : "Debit",
 781                                             "width" : 100,
 782                                             "$ renderer" : "function(v,x,r) { \n    return String.format('{0}', v ? Roo.util.Format.number(v*1,2)  : ''  );\n}",
 783                                             "$ xns" : "Roo.grid",
 784                                             "* prop" : "colModel[]",
 785                                             "dataIndex" : "gltrans_debit_amount"
 786                                         },
 787                                         {
 788                                             "align" : "right",
 789                                             "xtype" : "ColumnModel",
 790                                             "sortable" : true,
 791                                             "header" : "Amount",
 792                                             "width" : 100,
 793                                             "$ 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}",
 794                                             "$ xns" : "Roo.grid",
 795                                             "* prop" : "colModel[]",
 796                                             "dataIndex" : "gltrans_balance"
 797                                         }
 798                                     ]
 799                                 }
 800                             ]
 801                         }
 802                     ]
 803                 }
 804             ]
 805         }
 806     ]
 807 }