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

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