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

   1 {
   2     "id": "roo-file-362",
   3     "name": "Pman.Tab.XtupleArAging",
   4     "parent": "Pman.Tab.XtupleAccountsTab",
   5     "title": "",
   6     "path": "/home/alan/gitlive/web.xtuple/Pman/Xtuple/Pman.Tab.XtupleArAging.bjs",
   7     "items": [
   8         {
   9             "background": true,
  10             "fitContainer": true,
  11             "fitToFrame": true,
  12             "region": "center",
  13             "title": "Accounts Recievable",
  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                             "xtype": "LayoutRegion",
  25                             "|xns": "Roo"
  26                         },
  27                         {
  28                             "listeners": {
  29                                 "|activate": "function() {\n    _this.panel = this;\n    if (_this.grid) {\n        _this.grid.footer.onClick('first');\n    }\n}"
  30                             },
  31                             "background": true,
  32                             "fitContainer": true,
  33                             "fitToframe": true,
  34                             "region": "center",
  35                             "tableName": "aropen",
  36                             "title": "ArAging",
  37                             "xtype": "GridPanel",
  38                             "|xns": "Roo",
  39                             "items": [
  40                                 {
  41                                     "listeners": {
  42                                         "|render": "function() \n{\n    _this.grid = this; \n    //_this.dialog = Pman.Dialog.FILL_IN\n    if (_this.panel.active) {\n       this.footer.onClick('first');\n    }\n}"
  43                                     },
  44                                     "*prop": "grid",
  45                                     "autoExpandColumn": "araging_docnumber",
  46                                     "loadMask": true,
  47                                     "xtype": "Grid",
  48                                     "|xns": "Roo.grid",
  49                                     "items": [
  50                                         {
  51                                             "listeners": {
  52                                                 "beforeload": "function (_self, o)\n{\n    o.params = o.params || {};\n    \n\n    \n    var dt = _this.relDate.getValue();\n    \n    var params = {\n        _group : 'arAging',\n        _name : 'bydate',\n        'relDate:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),\n        'useDocDate:text' : false\n    };\n    \n    var cs = _this.customerSel.getValue();\n    if (cs*1) {\n        params['cust_id:number'] = cs;\n    \n    }\n    \n    \n    Roo.apply(o.params,params);\n}"
  53                                             },
  54                                             "*prop": "dataSource",
  55                                             "remoteSort": true,
  56                                             "xtype": "Store",
  57                                             "|xns": "Roo.data",
  58                                             "items": [
  59                                                 {
  60                                                     "*prop": "proxy",
  61                                                     "method": "GET",
  62                                                     "timeout": 600000,
  63                                                     "xtype": "HttpProxy",
  64                                                     "|url": "baseURL + '/Roo/Metasql.php'",
  65                                                     "|xns": "Roo.data"
  66                                                 },
  67                                                 {
  68                                                     "*prop": "reader",
  69                                                     "id": "id",
  70                                                     "root": "data",
  71                                                     "totalProperty": "total",
  72                                                     "xtype": "JsonReader",
  73                                                     "|fields": "[\n    {\n        'name': 'id',\n        'type': 'int'\n    },\n    {\n        'name': 'name',\n        'type': 'string'\n    },\n    {\n        'name': 'type',\n        'type': 'int'\n    },\n    {\n        'name': 'leader',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_id',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_office_id',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_name',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_phone',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_fax',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_email',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_company_id',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_role',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_active',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_remarks',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_passwd',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_owner_id',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_lang',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_no_reset_sent',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_action_type',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_project_id',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_deleted_by',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_deleted_dt',\n        'type': 'date'\n    },\n    {\n        'name': 'leader_firstname',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_lastname',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_name_facebook',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_url_blog',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_url_twitter',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_url_linkedin',\n        'type': 'string'\n    },\n    {\n        'name': 'leader_crm_lead_percentage',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_crm_industry_id',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_crm_updated_action_id',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_crm_created_action_id',\n        'type': 'int'\n    },\n    {\n        'name': 'leader_crm_type_id',\n        'type': 'int'\n    }\n]",
  74                                                     "|xns": "Roo.data"
  75                                                 }
  76                                             ]
  77                                         },
  78                                         {
  79                                             "|xns": "Roo",
  80                                             "xtype": "Toolbar",
  81                                             "*prop": "toolbar",
  82                                             "items": [
  83                                                 {
  84                                                     "listeners": {
  85                                                         "render": "function (_self)\n{\n    _this.customerSel = _self;\n}"
  86                                                     },
  87                                                     "allowBlank": false,
  88                                                     "displayField": "cust_name",
  89                                                     "editable": true,
  90                                                     "emptyText": "Select customer",
  91                                                     "fieldLabel": "cust_name",
  92                                                     "forceSelection": true,
  93                                                     "hiddenName": "cust_id",
  94                                                     "listWidth": 400,
  95                                                     "loadingText": "Searching...",
  96                                                     "minChars": 2,
  97                                                     "name": "cust_name",
  98                                                     "pageSize": 20,
  99                                                     "qtip": "Select Customer",
 100                                                     "queryParam": "query[cust_name]",
 101                                                     "selectOnFocus": true,
 102                                                     "tpl": "<div class=\"x-grid-cell-text x-btn button\"><b>{cust_name}</b> </div>",
 103                                                     "triggerAction": "all",
 104                                                     "typeAhead": true,
 105                                                     "valueField": "cust_id",
 106                                                     "width": 300,
 107                                                     "xtype": "ComboBox",
 108                                                     "|xns": "Roo.form",
 109                                                     "items": [
 110                                                         {
 111                                                             "listeners": {
 112                                                                 "|beforeload": "function (_self, o){\n    o.params = o.params || {};\n\n    if (!_this.relDate) {\n        return false;\n    }\n    var dt = _this.relDate.getValue();    \n    // set more here\n    o.params['_group'] = 'arAging';\n    o.params['_name'] = 'customers';\n    o.params['relDate:text']  = typeof(dt) == 'string' ? dt : dt.format('Y-m-d');\n    o.params['useDocDate:text'] = false    \n}\n"
 113                                                             },
 114                                                             "*prop": "store",
 115                                                             "remoteSort": true,
 116                                                             "xtype": "Store",
 117                                                             "|sortInfo": "{ direction : 'ASC', field: 'cust_name' }",
 118                                                             "|xns": "Roo.data",
 119                                                             "items": [
 120                                                                 {
 121                                                                     "*prop": "proxy",
 122                                                                     "method": "GET",
 123                                                                     "xtype": "HttpProxy",
 124                                                                     "|url": "baseURL + '/Roo/metasql.php'",
 125                                                                     "|xns": "Roo.data"
 126                                                                 },
 127                                                                 {
 128                                                                     "*prop": "reader",
 129                                                                     "xtype": "JsonReader",
 130                                                                     "|xns": "Roo.data",
 131                                                                     "id": "cust_id",
 132                                                                     "root": "data",
 133                                                                     "totalProperty": "total",
 134                                                                     "|fields": "[{\"name\":\"cust_id\",\"type\":\"int\"},\"cust_name\"]"
 135                                                                 }
 136                                                             ]
 137                                                         }
 138                                                     ]
 139                                                 },
 140                                                 {
 141                                                     "text": "as Of:",
 142                                                     "xtype": "TextItem",
 143                                                     "|xns": "Roo.Toolbar"
 144                                                 },
 145                                                 {
 146                                                     "listeners": {
 147                                                         "render": "function (_self)\r\n{\r\n    _this.relDate = _self;\r\n   _self.setValue(  new Date() );\r\n}",
 148                                                         "select": "function (combo, date)\n{\n    _this.grid.footer.onClick('first');\n}"
 149                                                     },
 150                                                     "allowBlank": false,
 151                                                     "format": "Y-m-d",
 152                                                     "width": 100,
 153                                                     "xtype": "DateField",
 154                                                     "|xns": "Roo.form"
 155                                                 }
 156                                             ]
 157                                         },
 158                                         {
 159                                             "*prop": "footer",
 160                                             "displayInfo": true,
 161                                             "displayMsg": "Displaying araging{0} - {1} of {2}",
 162                                             "emptyMsg": "Nothing found",
 163                                             "pageSize": 25,
 164                                             "xtype": "PagingToolbar",
 165                                             "|xns": "Roo"
 166                                         },
 167                                         {
 168                                             "*prop": "colModel[]",
 169                                             "dataIndex": "araging_docdate",
 170                                             "header": "Date",
 171                                             "width": 100,
 172                                             "xtype": "ColumnModel",
 173                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 174                                             "|xns": "Roo.grid"
 175                                         },
 176                                         {
 177                                             "*prop": "colModel[]",
 178                                             "dataIndex": "araging_cust_name",
 179                                             "header": "Customer",
 180                                             "width": 200,
 181                                             "xtype": "ColumnModel",
 182                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 183                                             "|xns": "Roo.grid"
 184                                         },
 185                                         {
 186                                             "*prop": "colModel[]",
 187                                             "dataIndex": "araging_doctype",
 188                                             "header": "Doc Type",
 189                                             "width": 40,
 190                                             "xtype": "ColumnModel",
 191                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 192                                             "|xns": "Roo.grid"
 193                                         },
 194                                         {
 195                                             "*prop": "colModel[]",
 196                                             "dataIndex": "araging_docnumber",
 197                                             "header": "Docnumber",
 198                                             "width": 120,
 199                                             "xtype": "ColumnModel",
 200                                             "|renderer": "function(v) {\n    switch(v) {\n        case 'I':\n            return \"Invoice\";\n        case 'C':\n            return \"Credit Memo\";        \n        case 'D':\n            return \"Debit Memo\";                    \n        case 'R':\n            return \"Cash Receipt\";        \n        default:\n             return String.format('{0}', v); \n     }\n }",
 201                                             "|xns": "Roo.grid"
 202                                         },
 203                                         {
 204                                             "*prop": "colModel[]",
 205                                             "dataIndex": "araging_ponumber_pretty",
 206                                             "header": "Order",
 207                                             "width": 150,
 208                                             "xtype": "ColumnModel",
 209                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 210                                             "|xns": "Roo.grid"
 211                                         },
 212                                         {
 213                                             "*prop": "colModel[]",
 214                                             "align": "right",
 215                                             "dataIndex": "araging_aropen_amount",
 216                                             "header": "Value",
 217                                             "width": 100,
 218                                             "xtype": "ColumnModel",
 219                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 220                                             "|xns": "Roo.grid"
 221                                         },
 222                                         {
 223                                             "*prop": "colModel[]",
 224                                             "align": "right",
 225                                             "dataIndex": "araging_cur_val",
 226                                             "header": "30 Days",
 227                                             "width": 100,
 228                                             "xtype": "ColumnModel",
 229                                             "|renderer": "function(v) { \n\n        return String.format(v*1 < 0 ? '<span style=\"color:red\">{0}</span>' : '{0}', \n            Roo.util.Format.usMoney(v)); \n    }",
 230                                             "|xns": "Roo.grid"
 231                                         },
 232                                         {
 233                                             "*prop": "colModel[]",
 234                                             "align": "right",
 235                                             "dataIndex": "araging_sixty_val",
 236                                             "header": "60 Days",
 237                                             "width": 100,
 238                                             "xtype": "ColumnModel",
 239                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 240                                             "|xns": "Roo.grid"
 241                                         },
 242                                         {
 243                                             "*prop": "colModel[]",
 244                                             "align": "right",
 245                                             "dataIndex": "araging_ninety_val",
 246                                             "header": "90 Days",
 247                                             "width": 100,
 248                                             "xtype": "ColumnModel",
 249                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 250                                             "|xns": "Roo.grid"
 251                                         },
 252                                         {
 253                                             "*prop": "colModel[]",
 254                                             "align": "right",
 255                                             "dataIndex": "araging_plus_val",
 256                                             "header": "Over 90 days",
 257                                             "width": 150,
 258                                             "xtype": "ColumnModel",
 259                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 260                                             "|xns": "Roo.grid"
 261                                         },
 262                                         {
 263                                             "*prop": "colModel[]",
 264                                             "align": "right",
 265                                             "dataIndex": "araging_total_val",
 266                                             "header": "Total",
 267                                             "width": 150,
 268                                             "xtype": "ColumnModel",
 269                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 270                                             "|xns": "Roo.grid"
 271                                         }
 272                                     ]
 273                                 }
 274                             ]
 275                         }
 276                     ]
 277                 }
 278             ]
 279         }
 280     ],
 281     "permname": "",
 282     "modOrder": "300"
 283 }