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

   1 //<script type="text/javascript">
   2
   3 // Auto generated file - created by app.Builder.js- do not edit directly (at present!)
   4
   5 Pman.Tab.XtupleArAging = new Roo.XComponent({
   6     part     :  ["Xtuple","ArAging"],
   7     order    : '300-Pman.Tab.XtupleArAging',
   8     region   : 'center',
   9     parent   : 'Pman.Tab.XtupleAccountsTab',
  10     name     : "unnamed module",
  11     disabled : false,
  12     permname : '',
  13     _tree : function()
  14     {
  15         var _this = this;
  16         var MODULE = this;
  17         return {
  18             xtype: 'NestedLayoutPanel',
  19             xns: Roo,
  20             background : true,
  21             fitContainer : true,
  22             fitToFrame : true,
  23             region : 'center',
  24             title : "Accounts Recievable",
  25             layout : {
  26                 xtype: 'BorderLayout',
  27                 xns: Roo,
  28                 items : [
  29                     {
  30                         xtype: 'GridPanel',
  31                         xns: Roo,
  32                         listeners : {
  33                             activate : function() {
  34                                 _this.panel = this;
  35                                 if (_this.grid) {
  36                                     _this.grid.footer.onClick('first');
  37                                 }
  38                             }
  39                         },
  40                         background : true,
  41                         fitContainer : true,
  42                         fitToframe : true,
  43                         region : 'center',
  44                         tableName : 'aropen',
  45                         title : "ArAging",
  46                         grid : {
  47                             xtype: 'Grid',
  48                             xns: Roo.grid,
  49                             listeners : {
  50                                 render : function()
  51                                 {
  52                                     _this.grid = this;
  53                                     //_this.dialog = Pman.Dialog.FILL_IN
  54                                     if (_this.panel.active) {
  55                                        this.footer.onClick('first');
  56                                     }
  57                                 }
  58                             },
  59                             autoExpandColumn : 'araging_docnumber',
  60                             loadMask : true,
  61                             dataSource : {
  62                                 xtype: 'Store',
  63                                 xns: Roo.data,
  64                                 listeners : {
  65                                     beforeload : function (_self, o)
  66                                     {
  67                                         o.params = o.params || {};
  68
  69                                         var dt = _this.relDate.getValue();
  70
  71                                         var params = {
  72                                             _group : 'arAging',
  73                                             _name : 'bydate',
  74                                             'relDate:text' : typeof(dt) == 'string' ? dt : dt.format('Y-m-d'),
  75                                             'useDocDate:text' : false
  76                                         };
  77
  78                                         var cs = this.customerSel.getValue();
  79                                         if (cs*1) {
  80                                             params['cust_id:number'] = cs;
  81
  82                                         }
  83
  84
  85                                         Roo.apply(o.params,params);
  86                                     }
  87                                 },
  88                                 remoteSort : true,
  89                                 proxy : {
  90                                     xtype: 'HttpProxy',
  91                                     xns: Roo.data,
  92                                     method : 'GET',
  93                                     timeout : 600000,
  94                                     url : baseURL + '/Roo/Metasql.php'
  95                                 },
  96                                 reader : {
  97                                     xtype: 'JsonReader',
  98                                     xns: Roo.data,
  99                                     id : 'id',
 100                                     root : 'data',
 101                                     totalProperty : 'total',
 102                                     fields : [
 103                                         {
 104                                             'name': 'id',
 105                                             'type': 'int'
 106                                         },
 107                                         {
 108                                             'name': 'name',
 109                                             'type': 'string'
 110                                         },
 111                                         {
 112                                             'name': 'type',
 113                                             'type': 'int'
 114                                         },
 115                                         {
 116                                             'name': 'leader',
 117                                             'type': 'int'
 118                                         },
 119                                         {
 120                                             'name': 'leader_id',
 121                                             'type': 'int'
 122                                         },
 123                                         {
 124                                             'name': 'leader_office_id',
 125                                             'type': 'int'
 126                                         },
 127                                         {
 128                                             'name': 'leader_name',
 129                                             'type': 'string'
 130                                         },
 131                                         {
 132                                             'name': 'leader_phone',
 133                                             'type': 'string'
 134                                         },
 135                                         {
 136                                             'name': 'leader_fax',
 137                                             'type': 'string'
 138                                         },
 139                                         {
 140                                             'name': 'leader_email',
 141                                             'type': 'string'
 142                                         },
 143                                         {
 144                                             'name': 'leader_company_id',
 145                                             'type': 'int'
 146                                         },
 147                                         {
 148                                             'name': 'leader_role',
 149                                             'type': 'string'
 150                                         },
 151                                         {
 152                                             'name': 'leader_active',
 153                                             'type': 'int'
 154                                         },
 155                                         {
 156                                             'name': 'leader_remarks',
 157                                             'type': 'string'
 158                                         },
 159                                         {
 160                                             'name': 'leader_passwd',
 161                                             'type': 'string'
 162                                         },
 163                                         {
 164                                             'name': 'leader_owner_id',
 165                                             'type': 'int'
 166                                         },
 167                                         {
 168                                             'name': 'leader_lang',
 169                                             'type': 'string'
 170                                         },
 171                                         {
 172                                             'name': 'leader_no_reset_sent',
 173                                             'type': 'int'
 174                                         },
 175                                         {
 176                                             'name': 'leader_action_type',
 177                                             'type': 'string'
 178                                         },
 179                                         {
 180                                             'name': 'leader_project_id',
 181                                             'type': 'int'
 182                                         },
 183                                         {
 184                                             'name': 'leader_deleted_by',
 185                                             'type': 'int'
 186                                         },
 187                                         {
 188                                             'name': 'leader_deleted_dt',
 189                                             'type': 'date'
 190                                         },
 191                                         {
 192                                             'name': 'leader_firstname',
 193                                             'type': 'string'
 194                                         },
 195                                         {
 196                                             'name': 'leader_lastname',
 197                                             'type': 'string'
 198                                         },
 199                                         {
 200                                             'name': 'leader_name_facebook',
 201                                             'type': 'string'
 202                                         },
 203                                         {
 204                                             'name': 'leader_url_blog',
 205                                             'type': 'string'
 206                                         },
 207                                         {
 208                                             'name': 'leader_url_twitter',
 209                                             'type': 'string'
 210                                         },
 211                                         {
 212                                             'name': 'leader_url_linkedin',
 213                                             'type': 'string'
 214                                         },
 215                                         {
 216                                             'name': 'leader_crm_lead_percentage',
 217                                             'type': 'int'
 218                                         },
 219                                         {
 220                                             'name': 'leader_crm_industry_id',
 221                                             'type': 'int'
 222                                         },
 223                                         {
 224                                             'name': 'leader_crm_updated_action_id',
 225                                             'type': 'int'
 226                                         },
 227                                         {
 228                                             'name': 'leader_crm_created_action_id',
 229                                             'type': 'int'
 230                                         },
 231                                         {
 232                                             'name': 'leader_crm_type_id',
 233                                             'type': 'int'
 234                                         }
 235                                     ]
 236                                 }
 237                             },
 238                             toolbar : {
 239                                 xtype: 'Toolbar',
 240                                 xns: Roo,
 241                                 items : [
 242                                     {
 243                                         xtype: 'ComboBox',
 244                                         xns: Roo.form,
 245                                         listeners : {
 246                                             render : function (_self)
 247                                             {
 248                                                 _this.custSel = _self;
 249                                             }
 250                                         },
 251                                         allowBlank : false,
 252                                         displayField : 'cust_name',
 253                                         editable : true,
 254                                         emptyText : "Select customer",
 255                                         fieldLabel : 'cust_name',
 256                                         forceSelection : true,
 257                                         hiddenName : 'cust_id',
 258                                         listWidth : 400,
 259                                         loadingText : "Searching...",
 260                                         minChars : 2,
 261                                         name : 'cust_name',
 262                                         pageSize : 20,
 263                                         qtip : "Select Customer",
 264                                         queryParam : 'query[cust_name]',
 265                                         selectOnFocus : true,
 266                                         tpl : '<div class="x-grid-cell-text x-btn button"><b>{cust_name}</b> </div>',
 267                                         triggerAction : 'all',
 268                                         typeAhead : true,
 269                                         valueField : 'cust_id',
 270                                         width : 300,
 271                                         store : {
 272                                             xtype: 'Store',
 273                                             xns: Roo.data,
 274                                             listeners : {
 275                                                 beforeload : function (_self, o){
 276                                                     o.params = o.params || {};
 277
 278                                                     if (!_this.relDate) {
 279                                                         return false;
 280                                                     }
 281                                                     var dt = _this.relDate.getValue();
 282                                                     // set more here
 283                                                     o.params['_group'] = 'arAging';
 284                                                     o.params['_name'] = 'customers';
 285                                                     o.params['relDate:text']  = typeof(dt) == 'string' ? dt : dt.format('Y-m-d');
 286                                                     o.params['useDocDate:text'] = false
 287                                                 }
 288                                             },
 289                                             remoteSort : true,
 290                                             sortInfo : { direction : 'ASC', field: 'cust_name' },
 291                                             proxy : {
 292                                                 xtype: 'HttpProxy',
 293                                                 xns: Roo.data,
 294                                                 method : 'GET',
 295                                                 url : baseURL + '/Roo/metasql.php'
 296                                             },
 297                                             reader : {
 298                                                 xtype: 'JsonReader',
 299                                                 xns: Roo.data,
 300                                                 id : 'cust_id',
 301                                                 root : 'data',
 302                                                 totalProperty : 'total',
 303                                                 fields : [{"name":"cust_id","type":"int"},"cust_name"]
 304                                             }
 305                                         }
 306                                     },
 307                                     {
 308                                         xtype: 'TextItem',
 309                                         xns: Roo.Toolbar,
 310                                         text : "as Of:"
 311                                     },
 312                                     {
 313                                         xtype: 'DateField',
 314                                         xns: Roo.form,
 315                                         listeners : {
 316                                             render : function (_self)\r
 317                                             {\r
 318                                                 _this.relDate = _self;\r
 319                                                _self.setValue(  new Date() );\r
 320                                             },
 321                                             select : function (combo, date)
 322                                             {
 323                                                 _this.grid.footer.onClick('first');
 324                                             }
 325                                         },
 326                                         allowBlank : false,
 327                                         format : 'Y-m-d',
 328                                         width : 100
 329                                     }
 330                                 ]
 331                             },
 332                             footer : {
 333                                 xtype: 'PagingToolbar',
 334                                 xns: Roo,
 335                                 displayInfo : true,
 336                                 displayMsg : "Displaying araging{0} - {1} of {2}",
 337                                 emptyMsg : "Nothing found",
 338                                 pageSize : 25
 339                             },
 340                             colModel : [
 341                                 {
 342                                     xtype: 'ColumnModel',
 343                                     xns: Roo.grid,
 344                                     dataIndex : 'araging_docdate',
 345                                     header : 'Date',
 346                                     width : 100,
 347                                     renderer : function(v) { return String.format('{0}', v); }
 348                                 },
 349                                 {
 350                                     xtype: 'ColumnModel',
 351                                     xns: Roo.grid,
 352                                     dataIndex : 'araging_cust_name',
 353                                     header : 'Customer',
 354                                     width : 200,
 355                                     renderer : function(v) { return String.format('{0}', v); }
 356                                 },
 357                                 {
 358                                     xtype: 'ColumnModel',
 359                                     xns: Roo.grid,
 360                                     dataIndex : 'araging_doctype',
 361                                     header : 'Doc Type',
 362                                     width : 40,
 363                                     renderer : function(v) { return String.format('{0}', v); }
 364                                 },
 365                                 {
 366                                     xtype: 'ColumnModel',
 367                                     xns: Roo.grid,
 368                                     dataIndex : 'araging_docnumber',
 369                                     header : 'Docnumber',
 370                                     width : 100,
 371                                     renderer : function(v) { return String.format('{0}', v); }
 372                                 },
 373                                 {
 374                                     xtype: 'ColumnModel',
 375                                     xns: Roo.grid,
 376                                     dataIndex : 'araging_ponumber_pretty',
 377                                     header : 'Order',
 378                                     width : 150,
 379                                     renderer : function(v) { return String.format('{0}', v); }
 380                                 },
 381                                 {
 382                                     xtype: 'ColumnModel',
 383                                     xns: Roo.grid,
 384                                     align : 'right',
 385                                     dataIndex : 'araging_aropen_amount',
 386                                     header : 'Value',
 387                                     width : 200,
 388                                     renderer : function(v) { return String.format('{0}', v); }
 389                                 },
 390                                 {
 391                                     xtype: 'ColumnModel',
 392                                     xns: Roo.grid,
 393                                     align : 'right',
 394                                     dataIndex : 'araging_cur_val',
 395                                     header : 'Cur Value',
 396                                     width : 200,
 397                                     renderer : function(v) { return String.format('{0}', v); }
 398                                 },
 399                                 {
 400                                     xtype: 'ColumnModel',
 401                                     xns: Roo.grid,
 402                                     align : 'right',
 403                                     dataIndex : 'araging_total_val',
 404                                     header : 'Total',
 405                                     width : 200,
 406                                     renderer : function(v) { return String.format('{0}', v); }
 407                                 },
 408                                 {
 409                                     xtype: 'ColumnModel',
 410                                     xns: Roo.grid,
 411                                     align : 'right',
 412                                     dataIndex : 'araging_total_val',
 413                                     header : 'Total',
 414                                     width : 200,
 415                                     renderer : function(v) { return String.format('{0}', v); }
 416                                 }
 417                             ]
 418                         }
 419                     }
 420                 ],
 421                 center : {
 422                     xtype: 'LayoutRegion',
 423                     xns: Roo
 424                 }
 425             }
 426         };
 427     }
 428 });