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

   1 {
   2     "id": "roo-file-41",
   3     "name": "Pman.Tab.XtupleArAging",
   4     "parent": "Pman.Tab.XtupleAccountsTab",
   5     "title": "",
   6     "path": "/home/edward/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_cust_name",
  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                                                         "select": "function (combo, record, index)\n{\n    _this.grid.footer.onClick('first');\n}"
  87                                                     },
  88                                                     "allowBlank": true,
  89                                                     "displayField": "cust_name",
  90                                                     "editable": true,
  91                                                     "emptyText": "Select customer",
  92                                                     "fieldLabel": "cust_name",
  93                                                     "forceSelection": true,
  94                                                     "hiddenName": "cust_id",
  95                                                     "listWidth": 400,
  96                                                     "loadingText": "Searching...",
  97                                                     "minChars": 2,
  98                                                     "name": "cust_name",
  99                                                     "pageSize": 20,
 100                                                     "qtip": "Select Customer",
 101                                                     "queryParam": "query[cust_name]",
 102                                                     "selectOnFocus": true,
 103                                                     "tpl": "<div class=\"x-grid-cell-text x-btn button\"><b>{cust_name}</b> </div>",
 104                                                     "triggerAction": "all",
 105                                                     "typeAhead": true,
 106                                                     "valueField": "cust_id",
 107                                                     "width": 300,
 108                                                     "xtype": "ComboBox",
 109                                                     "|xns": "Roo.form",
 110                                                     "items": [
 111                                                         {
 112                                                             "listeners": {
 113                                                                 "|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"
 114                                                             },
 115                                                             "*prop": "store",
 116                                                             "remoteSort": true,
 117                                                             "xtype": "Store",
 118                                                             "|sortInfo": "{ direction : 'ASC', field: 'cust_name' }",
 119                                                             "|xns": "Roo.data",
 120                                                             "items": [
 121                                                                 {
 122                                                                     "*prop": "proxy",
 123                                                                     "method": "GET",
 124                                                                     "xtype": "HttpProxy",
 125                                                                     "|url": "baseURL + '/Roo/metasql.php'",
 126                                                                     "|xns": "Roo.data"
 127                                                                 },
 128                                                                 {
 129                                                                     "*prop": "reader",
 130                                                                     "xtype": "JsonReader",
 131                                                                     "|xns": "Roo.data",
 132                                                                     "id": "cust_id",
 133                                                                     "root": "data",
 134                                                                     "totalProperty": "total",
 135                                                                     "|fields": "[{\"name\":\"cust_id\",\"type\":\"int\"},\"cust_name\"]"
 136                                                                 }
 137                                                             ]
 138                                                         }
 139                                                     ]
 140                                                 },
 141                                                 {
 142                                                     "text": "as Of:",
 143                                                     "xtype": "TextItem",
 144                                                     "|xns": "Roo.Toolbar"
 145                                                 },
 146                                                 {
 147                                                     "listeners": {
 148                                                         "render": "function (_self)\r\n{\r\n    _this.relDate = _self;\r\n   _self.setValue(  new Date() );\r\n}",
 149                                                         "select": "function (combo, date)\n{\n    _this.grid.footer.onClick('first');\n}"
 150                                                     },
 151                                                     "allowBlank": false,
 152                                                     "format": "Y-m-d",
 153                                                     "width": 100,
 154                                                     "xtype": "DateField",
 155                                                     "|xns": "Roo.form"
 156                                                 }
 157                                             ]
 158                                         },
 159                                         {
 160                                             "*prop": "footer",
 161                                             "displayInfo": true,
 162                                             "displayMsg": "Displaying araging{0} - {1} of {2}",
 163                                             "emptyMsg": "Nothing found",
 164                                             "pageSize": 25,
 165                                             "xtype": "PagingToolbar",
 166                                             "|xns": "Roo"
 167                                         },
 168                                         {
 169                                             "*prop": "colModel[]",
 170                                             "dataIndex": "araging_docdate",
 171                                             "header": "Date",
 172                                             "width": 100,
 173                                             "xtype": "ColumnModel",
 174                                             "|renderer": "function(v) { \n    var d = Date.parseDate(v, 'Y-m-d');\n\n    return String.format('{0}', d.format('d/M/Y')); \n}",
 175                                             "|xns": "Roo.grid"
 176                                         },
 177                                         {
 178                                             "*prop": "colModel[]",
 179                                             "dataIndex": "araging_cust_name",
 180                                             "header": "Customer",
 181                                             "width": 200,
 182                                             "xtype": "ColumnModel",
 183                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 184                                             "|xns": "Roo.grid"
 185                                         },
 186                                         {
 187                                             "*prop": "colModel[]",
 188                                             "dataIndex": "araging_doctype",
 189                                             "header": "Doc Type",
 190                                             "width": 120,
 191                                             "xtype": "ColumnModel",
 192                                             "|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 }",
 193                                             "|xns": "Roo.grid"
 194                                         },
 195                                         {
 196                                             "*prop": "colModel[]",
 197                                             "dataIndex": "araging_docnumber",
 198                                             "header": "Docnumber",
 199                                             "width": 120,
 200                                             "xtype": "ColumnModel",
 201                                             "|renderer": "function(v) {\n    \n             return String.format('{0}', v); \n     \n }",
 202                                             "|xns": "Roo.grid"
 203                                         },
 204                                         {
 205                                             "*prop": "colModel[]",
 206                                             "dataIndex": "araging_ponumber_pretty",
 207                                             "header": "Order",
 208                                             "width": 150,
 209                                             "xtype": "ColumnModel",
 210                                             "|renderer": "function(v) { return String.format('{0}', v); }",
 211                                             "|xns": "Roo.grid"
 212                                         },
 213                                         {
 214                                             "*prop": "colModel[]",
 215                                             "align": "right",
 216                                             "dataIndex": "araging_aropen_amount",
 217                                             "header": "Value",
 218                                             "width": 100,
 219                                             "xtype": "ColumnModel",
 220                                             "|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    }",
 221                                             "|xns": "Roo.grid"
 222                                         },
 223                                         {
 224                                             "*prop": "colModel[]",
 225                                             "align": "right",
 226                                             "dataIndex": "araging_cur_val",
 227                                             "header": "30 Days",
 228                                             "width": 100,
 229                                             "xtype": "ColumnModel",
 230                                             "|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    }",
 231                                             "|xns": "Roo.grid"
 232                                         },
 233                                         {
 234                                             "*prop": "colModel[]",
 235                                             "align": "right",
 236                                             "dataIndex": "araging_sixty_val",
 237                                             "header": "60 Days",
 238                                             "width": 100,
 239                                             "xtype": "ColumnModel",
 240                                             "|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    }",
 241                                             "|xns": "Roo.grid"
 242                                         },
 243                                         {
 244                                             "*prop": "colModel[]",
 245                                             "align": "right",
 246                                             "dataIndex": "araging_ninety_val",
 247                                             "header": "90 Days",
 248                                             "width": 100,
 249                                             "xtype": "ColumnModel",
 250                                             "|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    }",
 251                                             "|xns": "Roo.grid"
 252                                         },
 253                                         {
 254                                             "*prop": "colModel[]",
 255                                             "align": "right",
 256                                             "dataIndex": "araging_plus_val",
 257                                             "header": "Over 90 days",
 258                                             "width": 150,
 259                                             "xtype": "ColumnModel",
 260                                             "|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    }",
 261                                             "|xns": "Roo.grid"
 262                                         },
 263                                         {
 264                                             "*prop": "colModel[]",
 265                                             "align": "right",
 266                                             "dataIndex": "araging_total_val",
 267                                             "header": "Total",
 268                                             "width": 150,
 269                                             "xtype": "ColumnModel",
 270                                             "|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    }",
 271                                             "|xns": "Roo.grid"
 272                                         }
 273                                     ]
 274                                 }
 275                             ]
 276                         }
 277                     ]
 278                 }
 279             ]
 280         }
 281     ],
 282     "permname": "",
 283     "modOrder": "300"
 284 }