git.roojs.org Git - Pman.Xtuple/blob - Pman.Tab.XtuplePurchaseRecv.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.XtuplePurchaseRecv = new Roo.XComponent({
   6     part     :  ["Xtuple","PurchaseRecv"],
   7     order    : '001-Pman.Tab.XtuplePurchaseRecv',
   8     region   : 'center',
   9     parent   : 'Pman.Tab.XtuplePurchases',
  10     name     : "Pman.Tab.XtuplePurchaseRecv",
  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             region : 'center',
  22             title : "PO / Recieve Stock",
  23             layout : {
  24                 xtype: 'BorderLayout',
  25                 xns: Roo,
  26                 items : [
  27                     {
  28                         xtype: 'GridPanel',
  29                         xns: Roo,
  30                         listeners : {
  31                             activate : function() {
  32                                 _this.ppanel = this;
  33                                 if (_this.grid) {
  34                                     _this.grid.footer.onClick('first');
  35                                 }
  36                             }
  37                         },
  38                         background : true,
  39                         fitContainer : true,
  40                         fitToframe : true,
  41                         region : 'center',
  42                         tableName : 'pohead',
  43                         title : "PO Receive Stock",
  44                         grid : {
  45                             xtype: 'EditorGrid',
  46                             xns: Roo.grid,
  47                             listeners : {
  48                                 render : function()
  49                                 {
  50                                     _this.grid = this;
  51                                     //_this.dialog = Pman.Dialog.FILL_IN
  52                                     if (_this.ppanel.active) {
  53                                        this.footer.onClick('first');
  54                                     }
  55                                 },
  56                                 rowdblclick : function (_self, rowIndex, e)
  57                                 {
  58                                     var r = _this.grid.ds.getAt(rowIndex);
  59
  60                                     Pman.Dialog.XtuplePurchaseOrder.show( { pohead_id : r.data.pohead_id }, function() {
  61                                         _this.grid.footer.onClick('refresh');
  62                                     });
  63                                 },
  64                                 cellclick : function (_self, rowIndex, columnIndex, e)
  65                                 {
  66                                     var di = _this.grid.getColumnModel().getDataIndex(columnIndex);
  67                                     if(di == 'pohead_vouchered' || di == 'pohead_paid'){
  68                                         return;
  69                                     }
  70                                     _this.rggrid.ds.load({});
  71                                 },
  72                                 celldblclick : function (_self, rowIndex, columnIndex, e)
  73                                 {
  74                                     var di = _this.grid.getColumnModel().getDataIndex(columnIndex);
  75                                     if(di == 'pohead_vouchered' || di == 'pohead_paid'){
  76                                         return;
  77                                     }
  78
  79                                     var r = _this.grid.ds.getAt(rowIndex);
  80
  81                                     Pman.Dialog.XtuplePurchaseOrder.show( { pohead_id : r.data.pohead_id }, function() {
  82                                         _this.grid.footer.onClick('refresh');
  83                                     });
  84                                 }
  85                             },
  86                             autoExpandColumn : 'pohead_vend_id_vend_name',
  87                             loadMask : true,
  88                             trackMouseOver : true,
  89                             dataSource : {
  90                                 xtype: 'Store',
  91                                 xns: Roo.data,
  92                                 listeners : {
  93                                     beforeload : function (_self, o)
  94                                     {
  95                                         o.params._with_recv = 1;
  96
  97
  98                                         o.params['query[number]'] = _this.searchBox.getValue();
  99
 100                                         // only filter by type if the number is empty..
 101                                         if (!o.params['query[number]'].length) {
 102                                             o.params.pohead_status = _this.status.getValue();
 103                                         }
 104
 105
 106                                     },
 107                                     load : function (_self, records, options)
 108                                     {
 109
 110                                         (function() { _this.rggrid.ds.load({}); }).defer(100);
 111                                     }
 112                                 },
 113                                 remoteSort : true,
 114                                 sortInfo : { field : 'pohead_orderdate', direction: 'DESC' },
 115                                 proxy : {
 116                                     xtype: 'HttpProxy',
 117                                     xns: Roo.data,
 118                                     method : 'GET',
 119                                     url : baseURL + '/Roo/pohead.php'
 120                                 },
 121                                 reader : {
 122                                     xtype: 'JsonReader',
 123                                     xns: Roo.data,
 124                                     totalProperty : 'total',
 125                                     root : 'data',
 126                                     id : 'id',
 127                                     fields : [
 128                                         {
 129                                             'name': 'pohead_id',
 130                                             'type': 'int'
 131                                         },
 132                                         {
 133                                             'name': 'pohead_status',
 134                                             'type': 'string'
 135                                         },
 136                                         {
 137                                             'name': 'pohead_number',
 138                                             'type': 'string'
 139                                         },
 140                                         {
 141                                             'name': 'pohead_orderdate',
 142                                             'type': 'date',
 143                                             'dateFormat': 'Y-m-d'
 144                                         },
 145                                         {
 146                                             'name': 'pohead_vend_id',
 147                                             'type': 'int'
 148                                         },
 149                                         {
 150                                             'name': 'pohead_fob',
 151                                             'type': 'string'
 152                                         },
 153                                         {
 154                                             'name': 'pohead_shipvia',
 155                                             'type': 'string'
 156                                         },
 157                                         {
 158                                             'name': 'pohead_comments',
 159                                             'type': 'string'
 160                                         },
 161                                         {
 162                                             'name': 'pohead_freight',
 163                                             'type': 'float'
 164                                         },
 165                                         {
 166                                             'name': 'pohead_printed',
 167                                             'type': 'int'
 168                                         },
 169                                         {
 170                                             'name': 'pohead_terms_id',
 171                                             'type': 'int'
 172                                         },
 173                                         {
 174                                             'name': 'pohead_warehous_id',
 175                                             'type': 'int'
 176                                         },
 177                                         {
 178                                             'name': 'pohead_vendaddr_id',
 179                                             'type': 'int'
 180                                         },
 181                                         {
 182                                             'name': 'pohead_agent_username',
 183                                             'type': 'string'
 184                                         },
 185                                         {
 186                                             'name': 'pohead_curr_id',
 187                                             'type': 'int'
 188                                         },
 189                                         {
 190                                             'name': 'pohead_saved',
 191                                             'type': 'int'
 192                                         },
 193                                         {
 194                                             'name': 'pohead_taxzone_id',
 195                                             'type': 'int'
 196                                         },
 197                                         {
 198                                             'name': 'pohead_taxtype_id',
 199                                             'type': 'int'
 200                                         },
 201                                         {
 202                                             'name': 'pohead_dropship',
 203                                             'type': 'int'
 204                                         },
 205                                         {
 206                                             'name': 'pohead_vend_cntct_id',
 207                                             'type': 'int'
 208                                         },
 209                                         {
 210                                             'name': 'pohead_vend_cntct_honorific',
 211                                             'type': 'string'
 212                                         },
 213                                         {
 214                                             'name': 'pohead_vend_cntct_first_name',
 215                                             'type': 'string'
 216                                         },
 217                                         {
 218                                             'name': 'pohead_vend_cntct_middle',
 219                                             'type': 'string'
 220                                         },
 221                                         {
 222                                             'name': 'pohead_vend_cntct_last_name',
 223                                             'type': 'string'
 224                                         },
 225                                         {
 226                                             'name': 'pohead_vend_cntct_suffix',
 227                                             'type': 'string'
 228                                         },
 229                                         {
 230                                             'name': 'pohead_vend_cntct_phone',
 231                                             'type': 'string'
 232                                         },
 233                                         {
 234                                             'name': 'pohead_vend_cntct_title',
 235                                             'type': 'string'
 236                                         },
 237                                         {
 238                                             'name': 'pohead_vend_cntct_fax',
 239                                             'type': 'string'
 240                                         },
 241                                         {
 242                                             'name': 'pohead_vend_cntct_email',
 243                                             'type': 'string'
 244                                         },
 245                                         {
 246                                             'name': 'pohead_vendaddress1',
 247                                             'type': 'string'
 248                                         },
 249                                         {
 250                                             'name': 'pohead_vendaddress2',
 251                                             'type': 'string'
 252                                         },
 253                                         {
 254                                             'name': 'pohead_vendaddress3',
 255                                             'type': 'string'
 256                                         },
 257                                         {
 258                                             'name': 'pohead_vendcity',
 259                                             'type': 'string'
 260                                         },
 261                                         {
 262                                             'name': 'pohead_vendstate',
 263                                             'type': 'string'
 264                                         },
 265                                         {
 266                                             'name': 'pohead_vendzipcode',
 267                                             'type': 'string'
 268                                         },
 269                                         {
 270                                             'name': 'pohead_vendcountry',
 271                                             'type': 'string'
 272                                         },
 273                                         {
 274                                             'name': 'pohead_shipto_cntct_id',
 275                                             'type': 'int'
 276                                         },
 277                                         {
 278                                             'name': 'pohead_shipto_cntct_honorific',
 279                                             'type': 'string'
 280                                         },
 281                                         {
 282                                             'name': 'pohead_shipto_cntct_first_name',
 283                                             'type': 'string'
 284                                         },
 285                                         {
 286                                             'name': 'pohead_shipto_cntct_middle',
 287                                             'type': 'string'
 288                                         },
 289                                         {
 290                                             'name': 'pohead_shipto_cntct_last_name',
 291                                             'type': 'string'
 292                                         },
 293                                         {
 294                                             'name': 'pohead_shipto_cntct_suffix',
 295                                             'type': 'string'
 296                                         },
 297                                         {
 298                                             'name': 'pohead_shipto_cntct_phone',
 299                                             'type': 'string'
 300                                         },
 301                                         {
 302                                             'name': 'pohead_shipto_cntct_title',
 303                                             'type': 'string'
 304                                         },
 305                                         {
 306                                             'name': 'pohead_shipto_cntct_fax',
 307                                             'type': 'string'
 308                                         },
 309                                         {
 310                                             'name': 'pohead_shipto_cntct_email',
 311                                             'type': 'string'
 312                                         },
 313                                         {
 314                                             'name': 'pohead_shiptoddress_id',
 315                                             'type': 'int'
 316                                         },
 317                                         {
 318                                             'name': 'pohead_shiptoaddress1',
 319                                             'type': 'string'
 320                                         },
 321                                         {
 322                                             'name': 'pohead_shiptoaddress2',
 323                                             'type': 'string'
 324                                         },
 325                                         {
 326                                             'name': 'pohead_shiptoaddress3',
 327                                             'type': 'string'
 328                                         },
 329                                         {
 330                                             'name': 'pohead_shiptocity',
 331                                             'type': 'string'
 332                                         },
 333                                         {
 334                                             'name': 'pohead_shiptostate',
 335                                             'type': 'string'
 336                                         },
 337                                         {
 338                                             'name': 'pohead_shiptozipcode',
 339                                             'type': 'string'
 340                                         },
 341                                         {
 342                                             'name': 'pohead_shiptocountry',
 343                                             'type': 'string'
 344                                         },
 345                                         {
 346                                             'name': 'pohead_cohead_id',
 347                                             'type': 'int'
 348                                         },
 349                                         {
 350                                             'name': 'pohead_released',
 351                                             'type': 'date',
 352                                             'dateFormat': 'Y-m-d'
 353                                         },
 354                                         {
 355                                             'name': 'pohead_curr_id_curr_id',
 356                                             'type': 'int'
 357                                         },
 358                                         {
 359                                             'name': 'pohead_curr_id_curr_base',
 360                                             'type': 'int'
 361                                         },
 362                                         {
 363                                             'name': 'pohead_curr_id_curr_name',
 364                                             'type': 'string'
 365                                         },
 366                                         {
 367                                             'name': 'pohead_curr_id_curr_symbol',
 368                                             'type': 'string'
 369                                         },
 370                                         {
 371                                             'name': 'pohead_curr_id_curr_abbr',
 372                                             'type': 'string'
 373                                         },
 374                                         {
 375                                             'name': 'pohead_warehous_id_warehous_id',
 376                                             'type': 'int'
 377                                         },
 378                                         {
 379                                             'name': 'pohead_warehous_id_warehous_code',
 380                                             'type': 'string'
 381                                         },
 382                                         {
 383                                             'name': 'pohead_warehous_id_warehous_descrip',
 384                                             'type': 'string'
 385                                         },
 386                                         {
 387                                             'name': 'pohead_warehous_id_warehous_fob',
 388                                             'type': 'string'
 389                                         },
 390                                         {
 391                                             'name': 'pohead_warehous_id_warehous_active',
 392                                             'type': 'int'
 393                                         },
 394                                         {
 395                                             'name': 'pohead_warehous_id_warehous_counttag_prefix',
 396                                             'type': 'string'
 397                                         },
 398                                         {
 399                                             'name': 'pohead_warehous_id_warehous_counttag_number',
 400                                             'type': 'int'
 401                                         },
 402                                         {
 403                                             'name': 'pohead_warehous_id_warehous_bol_prefix',
 404                                             'type': 'string'
 405                                         },
 406                                         {
 407                                             'name': 'pohead_warehous_id_warehous_bol_number',
 408                                             'type': 'int'
 409                                         },
 410                                         {
 411                                             'name': 'pohead_warehous_id_warehous_shipping',
 412                                             'type': 'int'
 413                                         },
 414                                         {
 415                                             'name': 'pohead_warehous_id_warehous_useslips',
 416                                             'type': 'int'
 417                                         },
 418                                         {
 419                                             'name': 'pohead_warehous_id_warehous_usezones',
 420                                             'type': 'int'
 421                                         },
 422                                         {
 423                                             'name': 'pohead_warehous_id_warehous_aislesize',
 424                                             'type': 'int'
 425                                         },
 426                                         {
 427                                             'name': 'pohead_warehous_id_warehous_aislealpha',
 428                                             'type': 'int'
 429                                         },
 430                                         {
 431                                             'name': 'pohead_warehous_id_warehous_racksize',
 432                                             'type': 'int'
 433                                         },
 434                                         {
 435                                             'name': 'pohead_warehous_id_warehous_rackalpha',
 436                                             'type': 'int'
 437                                         },
 438                                         {
 439                                             'name': 'pohead_warehous_id_warehous_binsize',
 440                                             'type': 'int'
 441                                         },
 442                                         {
 443                                             'name': 'pohead_warehous_id_warehous_binalpha',
 444                                             'type': 'int'
 445                                         },
 446                                         {
 447                                             'name': 'pohead_warehous_id_warehous_locationsize',
 448                                             'type': 'int'
 449                                         },
 450                                         {
 451                                             'name': 'pohead_warehous_id_warehous_locationalpha',
 452                                             'type': 'int'
 453                                         },
 454                                         {
 455                                             'name': 'pohead_warehous_id_warehous_enforcearbl',
 456                                             'type': 'int'
 457                                         },
 458                                         {
 459                                             'name': 'pohead_warehous_id_warehous_default_accnt_id',
 460                                             'type': 'int'
 461                                         },
 462                                         {
 463                                             'name': 'pohead_warehous_id_warehous_shipping_commission',
 464                                             'type': 'float'
 465                                         },
 466                                         {
 467                                             'name': 'pohead_warehous_id_warehous_cntct_id',
 468                                             'type': 'int'
 469                                         },
 470                                         {
 471                                             'name': 'pohead_warehous_id_warehous_addr_id',
 472                                             'type': 'int'
 473                                         },
 474                                         {
 475                                             'name': 'pohead_warehous_id_warehous_transit',
 476                                             'type': 'int'
 477                                         },
 478                                         {
 479                                             'name': 'pohead_warehous_id_warehous_shipform_id',
 480                                             'type': 'int'
 481                                         },
 482                                         {
 483                                             'name': 'pohead_warehous_id_warehous_shipvia_id',
 484                                             'type': 'int'
 485                                         },
 486                                         {
 487                                             'name': 'pohead_warehous_id_warehous_shipcomments',
 488                                             'type': 'string'
 489                                         },
 490                                         {
 491                                             'name': 'pohead_warehous_id_warehous_costcat_id',
 492                                             'type': 'int'
 493                                         },
 494                                         {
 495                                             'name': 'pohead_warehous_id_warehous_costcat_id',
 496                                             'type': 'int'
 497                                         },
 498                                         {
 499                                             'name': 'pohead_warehous_id_warehous_sitetype_id',
 500                                             'type': 'int'
 501                                         },
 502                                         {
 503                                             'name': 'pohead_warehous_id_warehous_taxzone_id',
 504                                             'type': 'int'
 505                                         },
 506                                         {
 507                                             'name': 'pohead_warehous_id_warehous_sequence',
 508                                             'type': 'int'
 509                                         },
 510                                         {
 511                                             'name': 'pohead_vendaddr_id_vendaddr_id',
 512                                             'type': 'int'
 513                                         },
 514                                         {
 515                                             'name': 'pohead_vendaddr_id_vendaddr_vend_id',
 516                                             'type': 'int'
 517                                         },
 518                                         {
 519                                             'name': 'pohead_vendaddr_id_vendaddr_code',
 520                                             'type': 'string'
 521                                         },
 522                                         {
 523                                             'name': 'pohead_vendaddr_id_vendaddr_name',
 524                                             'type': 'string'
 525                                         },
 526                                         {
 527                                             'name': 'pohead_vendaddr_id_vendaddr_comments',
 528                                             'type': 'string'
 529                                         },
 530                                         {
 531                                             'name': 'pohead_vendaddr_id_vendaddr_cntct_id',
 532                                             'type': 'int'
 533                                         },
 534                                         {
 535                                             'name': 'pohead_vendaddr_id_vendaddr_addr_id',
 536                                             'type': 'int'
 537                                         },
 538                                         {
 539                                             'name': 'pohead_vendaddr_id_vendaddr_taxzone_id',
 540                                             'type': 'int'
 541                                         },
 542                                         {
 543                                             'name': 'pohead_vend_id_vend_id',
 544                                             'type': 'int'
 545                                         },
 546                                         {
 547                                             'name': 'pohead_vend_id_vend_name',
 548                                             'type': 'string'
 549                                         },
 550                                         {
 551                                             'name': 'pohead_vend_id_vend_lastpurchdate',
 552                                             'type': 'date'
 553                                         },
 554                                         {
 555                                             'name': 'pohead_vend_id_vend_active',
 556                                             'type': 'int'
 557                                         },
 558                                         {
 559                                             'name': 'pohead_vend_id_vend_po',
 560                                             'type': 'int'
 561                                         },
 562                                         {
 563                                             'name': 'pohead_vend_id_vend_comments',
 564                                             'type': 'string'
 565                                         },
 566                                         {
 567                                             'name': 'pohead_vend_id_vend_pocomments',
 568                                             'type': 'string'
 569                                         },
 570                                         {
 571                                             'name': 'pohead_vend_id_vend_number',
 572                                             'type': 'string'
 573                                         },
 574                                         {
 575                                             'name': 'pohead_vend_id_vend_1099',
 576                                             'type': 'int'
 577                                         },
 578                                         {
 579                                             'name': 'pohead_vend_id_vend_exported',
 580                                             'type': 'int'
 581                                         },
 582                                         {
 583                                             'name': 'pohead_vend_id_vend_fobsource',
 584                                             'type': 'string'
 585                                         },
 586                                         {
 587                                             'name': 'pohead_vend_id_vend_fob',
 588                                             'type': 'string'
 589                                         },
 590                                         {
 591                                             'name': 'pohead_vend_id_vend_terms_id',
 592                                             'type': 'int'
 593                                         },
 594                                         {
 595                                             'name': 'pohead_vend_id_vend_shipvia',
 596                                             'type': 'string'
 597                                         },
 598                                         {
 599                                             'name': 'pohead_vend_id_vend_vendtype_id',
 600                                             'type': 'int'
 601                                         },
 602                                         {
 603                                             'name': 'pohead_vend_id_vend_qualified',
 604                                             'type': 'int'
 605                                         },
 606                                         {
 607                                             'name': 'pohead_vend_id_vend_ediemail',
 608                                             'type': 'string'
 609                                         },
 610                                         {
 611                                             'name': 'pohead_vend_id_vend_ediemailbody',
 612                                             'type': 'string'
 613                                         },
 614                                         {
 615                                             'name': 'pohead_vend_id_vend_edisubject',
 616                                             'type': 'string'
 617                                         },
 618                                         {
 619                                             'name': 'pohead_vend_id_vend_edifilename',
 620                                             'type': 'string'
 621                                         },
 622                                         {
 623                                             'name': 'pohead_vend_id_vend_accntnum',
 624                                             'type': 'string'
 625                                         },
 626                                         {
 627                                             'name': 'pohead_vend_id_vend_emailpodelivery',
 628                                             'type': 'int'
 629                                         },
 630                                         {
 631                                             'name': 'pohead_vend_id_vend_restrictpurch',
 632                                             'type': 'int'
 633                                         },
 634                                         {
 635                                             'name': 'pohead_vend_id_vend_edicc',
 636                                             'type': 'string'
 637                                         },
 638                                         {
 639                                             'name': 'pohead_vend_id_vend_curr_id',
 640                                             'type': 'int'
 641                                         },
 642                                         {
 643                                             'name': 'pohead_vend_id_vend_cntct1_id',
 644                                             'type': 'int'
 645                                         },
 646                                         {
 647                                             'name': 'pohead_vend_id_vend_cntct2_id',
 648                                             'type': 'int'
 649                                         },
 650                                         {
 651                                             'name': 'pohead_vend_id_vend_addr_id',
 652                                             'type': 'int'
 653                                         },
 654                                         {
 655                                             'name': 'pohead_vend_id_vend_match',
 656                                             'type': 'int'
 657                                         },
 658                                         {
 659                                             'name': 'pohead_vend_id_vend_ach_enabled',
 660                                             'type': 'int'
 661                                         },
 662                                         {
 663                                             'name': 'pohead_vend_id_vend_ach_accnttype',
 664                                             'type': 'string'
 665                                         },
 666                                         {
 667                                             'name': 'pohead_vend_id_vend_ach_use_vendinfo',
 668                                             'type': 'int'
 669                                         },
 670                                         {
 671                                             'name': 'pohead_vend_id_vend_ach_indiv_number',
 672                                             'type': 'string'
 673                                         },
 674                                         {
 675                                             'name': 'pohead_vend_id_vend_ach_indiv_name',
 676                                             'type': 'string'
 677                                         },
 678                                         {
 679                                             'name': 'pohead_vend_id_vend_ediemailhtml',
 680                                             'type': 'int'
 681                                         },
 682                                         {
 683                                             'name': 'pohead_vend_id_vend_ach_routingnumber',
 684                                             'type': 'text'
 685                                         },
 686                                         {
 687                                             'name': 'pohead_vend_id_vend_ach_accntnumber',
 688                                             'type': 'text'
 689                                         },
 690                                         {
 691                                             'name': 'pohead_vend_id_vend_taxzone_id',
 692                                             'type': 'int'
 693                                         },
 694                                         {
 695                                             'name': 'pohead_vend_cntct_id_cntct_id',
 696                                             'type': 'int'
 697                                         },
 698                                         {
 699                                             'name': 'pohead_vend_cntct_id_cntct_crmacct_id',
 700                                             'type': 'int'
 701                                         },
 702                                         {
 703                                             'name': 'pohead_vend_cntct_id_cntct_addr_id',
 704                                             'type': 'int'
 705                                         },
 706                                         {
 707                                             'name': 'pohead_vend_cntct_id_cntct_first_name',
 708                                             'type': 'string'
 709                                         },
 710                                         {
 711                                             'name': 'pohead_vend_cntct_id_cntct_last_name',
 712                                             'type': 'string'
 713                                         },
 714                                         {
 715                                             'name': 'pohead_vend_cntct_id_cntct_honorific',
 716                                             'type': 'string'
 717                                         },
 718                                         {
 719                                             'name': 'pohead_vend_cntct_id_cntct_initials',
 720                                             'type': 'string'
 721                                         },
 722                                         {
 723                                             'name': 'pohead_vend_cntct_id_cntct_active',
 724                                             'type': 'int'
 725                                         },
 726                                         {
 727                                             'name': 'pohead_vend_cntct_id_cntct_phone',
 728                                             'type': 'string'
 729                                         },
 730                                         {
 731                                             'name': 'pohead_vend_cntct_id_cntct_phone2',
 732                                             'type': 'string'
 733                                         },
 734                                         {
 735                                             'name': 'pohead_vend_cntct_id_cntct_fax',
 736                                             'type': 'string'
 737                                         },
 738                                         {
 739                                             'name': 'pohead_vend_cntct_id_cntct_email',
 740                                             'type': 'string'
 741                                         },
 742                                         {
 743                                             'name': 'pohead_vend_cntct_id_cntct_webaddr',
 744                                             'type': 'string'
 745                                         },
 746                                         {
 747                                             'name': 'pohead_vend_cntct_id_cntct_notes',
 748                                             'type': 'string'
 749                                         },
 750                                         {
 751                                             'name': 'pohead_vend_cntct_id_cntct_title',
 752                                             'type': 'string'
 753                                         },
 754                                         {
 755                                             'name': 'pohead_vend_cntct_id_cntct_number',
 756                                             'type': 'string'
 757                                         },
 758                                         {
 759                                             'name': 'pohead_vend_cntct_id_cntct_middle',
 760                                             'type': 'string'
 761                                         },
 762                                         {
 763                                             'name': 'pohead_vend_cntct_id_cntct_suffix',
 764                                             'type': 'string'
 765                                         },
 766                                         {
 767                                             'name': 'pohead_vend_cntct_id_cntct_owner_username',
 768                                             'type': 'string'
 769                                         },
 770                                         {
 771                                             'name': 'pohead_vend_cntct_id_cntct_name',
 772                                             'type': 'string'
 773                                         },
 774                                         {
 775                                             'name': 'pohead_terms_id_terms_id',
 776                                             'type': 'int'
 777                                         },
 778                                         {
 779                                             'name': 'pohead_terms_id_terms_code',
 780                                             'type': 'string'
 781                                         },
 782                                         {
 783                                             'name': 'pohead_terms_id_terms_descrip',
 784                                             'type': 'string'
 785                                         },
 786                                         {
 787                                             'name': 'pohead_terms_id_terms_type',
 788                                             'type': 'string'
 789                                         },
 790                                         {
 791                                             'name': 'pohead_terms_id_terms_duedays',
 792                                             'type': 'int'
 793                                         },
 794                                         {
 795                                             'name': 'pohead_terms_id_terms_discdays',
 796                                             'type': 'int'
 797                                         },
 798                                         {
 799                                             'name': 'pohead_terms_id_terms_discprcnt',
 800                                             'type': 'float'
 801                                         },
 802                                         {
 803                                             'name': 'pohead_terms_id_terms_cutoffday',
 804                                             'type': 'int'
 805                                         },
 806                                         {
 807                                             'name': 'pohead_terms_id_terms_ap',
 808                                             'type': 'int'
 809                                         },
 810                                         {
 811                                             'name': 'pohead_terms_id_terms_ar',
 812                                             'type': 'int'
 813                                         },
 814                                         {
 815                                             'name': 'pohead_taxzone_id_taxzone_id',
 816                                             'type': 'int'
 817                                         },
 818                                         {
 819                                             'name': 'pohead_taxzone_id_taxzone_code',
 820                                             'type': 'string'
 821                                         },
 822                                         {
 823                                             'name': 'pohead_taxzone_id_taxzone_descrip',
 824                                             'type': 'string'
 825                                         },
 826                                         {
 827                                             'name': 'pohead_taxtype_id_taxtype_id',
 828                                             'type': 'int'
 829                                         },
 830                                         {
 831                                             'name': 'pohead_taxtype_id_taxtype_name',
 832                                             'type': 'string'
 833                                         },
 834                                         {
 835                                             'name': 'pohead_taxtype_id_taxtype_descrip',
 836                                             'type': 'string'
 837                                         },
 838                                         {
 839                                             'name': 'pohead_taxtype_id_taxtype_sys',
 840                                             'type': 'int'
 841                                         },
 842                                         {
 843                                             'name': 'pohead_shiptoddress_id_addr_id',
 844                                             'type': 'int'
 845                                         },
 846                                         {
 847                                             'name': 'pohead_shiptoddress_id_addr_active',
 848                                             'type': 'int'
 849                                         },
 850                                         {
 851                                             'name': 'pohead_shiptoddress_id_addr_line1',
 852                                             'type': 'string'
 853                                         },
 854                                         {
 855                                             'name': 'pohead_shiptoddress_id_addr_line2',
 856                                             'type': 'string'
 857                                         },
 858                                         {
 859                                             'name': 'pohead_shiptoddress_id_addr_line3',
 860                                             'type': 'string'
 861                                         },
 862                                         {
 863                                             'name': 'pohead_shiptoddress_id_addr_city',
 864                                             'type': 'string'
 865                                         },
 866                                         {
 867                                             'name': 'pohead_shiptoddress_id_addr_state',
 868                                             'type': 'string'
 869                                         },
 870                                         {
 871                                             'name': 'pohead_shiptoddress_id_addr_postalcode',
 872                                             'type': 'string'
 873                                         },
 874                                         {
 875                                             'name': 'pohead_shiptoddress_id_addr_country',
 876                                             'type': 'string'
 877                                         },
 878                                         {
 879                                             'name': 'pohead_shiptoddress_id_addr_notes',
 880                                             'type': 'string'
 881                                         },
 882                                         {
 883                                             'name': 'pohead_shiptoddress_id_addr_number',
 884                                             'type': 'string'
 885                                         },
 886                                         {
 887                                             'name': 'pohead_shipto_cntct_id_cntct_id',
 888                                             'type': 'int'
 889                                         },
 890                                         {
 891                                             'name': 'pohead_shipto_cntct_id_cntct_crmacct_id',
 892                                             'type': 'int'
 893                                         },
 894                                         {
 895                                             'name': 'pohead_shipto_cntct_id_cntct_addr_id',
 896                                             'type': 'int'
 897                                         },
 898                                         {
 899                                             'name': 'pohead_shipto_cntct_id_cntct_first_name',
 900                                             'type': 'string'
 901                                         },
 902                                         {
 903                                             'name': 'pohead_shipto_cntct_id_cntct_last_name',
 904                                             'type': 'string'
 905                                         },
 906                                         {
 907                                             'name': 'pohead_shipto_cntct_id_cntct_honorific',
 908                                             'type': 'string'
 909                                         },
 910                                         {
 911                                             'name': 'pohead_shipto_cntct_id_cntct_initials',
 912                                             'type': 'string'
 913                                         },
 914                                         {
 915                                             'name': 'pohead_shipto_cntct_id_cntct_active',
 916                                             'type': 'int'
 917                                         },
 918                                         {
 919                                             'name': 'pohead_shipto_cntct_id_cntct_phone',
 920                                             'type': 'string'
 921                                         },
 922                                         {
 923                                             'name': 'pohead_shipto_cntct_id_cntct_phone2',
 924                                             'type': 'string'
 925                                         },
 926                                         {
 927                                             'name': 'pohead_shipto_cntct_id_cntct_fax',
 928                                             'type': 'string'
 929                                         },
 930                                         {
 931                                             'name': 'pohead_shipto_cntct_id_cntct_email',
 932                                             'type': 'string'
 933                                         },
 934                                         {
 935                                             'name': 'pohead_shipto_cntct_id_cntct_webaddr',
 936                                             'type': 'string'
 937                                         },
 938                                         {
 939                                             'name': 'pohead_shipto_cntct_id_cntct_notes',
 940                                             'type': 'string'
 941                                         },
 942                                         {
 943                                             'name': 'pohead_shipto_cntct_id_cntct_title',
 944                                             'type': 'string'
 945                                         },
 946                                         {
 947                                             'name': 'pohead_shipto_cntct_id_cntct_number',
 948                                             'type': 'string'
 949                                         },
 950                                         {
 951                                             'name': 'pohead_shipto_cntct_id_cntct_middle',
 952                                             'type': 'string'
 953                                         },
 954                                         {
 955                                             'name': 'pohead_shipto_cntct_id_cntct_suffix',
 956                                             'type': 'string'
 957                                         },
 958                                         {
 959                                             'name': 'pohead_shipto_cntct_id_cntct_owner_username',
 960                                             'type': 'string'
 961                                         },
 962                                         {
 963                                             'name': 'pohead_shipto_cntct_id_cntct_name',
 964                                             'type': 'string'
 965                                         },
 966                                         {
 967                                             'name': 'pohead_cohead_id_cohead_id',
 968                                             'type': 'int'
 969                                         },
 970                                         {
 971                                             'name': 'pohead_cohead_id_cohead_number',
 972                                             'type': 'string'
 973                                         },
 974                                         {
 975                                             'name': 'pohead_cohead_id_cohead_cust_id',
 976                                             'type': 'int'
 977                                         },
 978                                         {
 979                                             'name': 'pohead_cohead_id_cohead_custponumber',
 980                                             'type': 'string'
 981                                         },
 982                                         {
 983                                             'name': 'pohead_cohead_id_cohead_type',
 984                                             'type': 'string'
 985                                         },
 986                                         {
 987                                             'name': 'pohead_cohead_id_cohead_orderdate',
 988                                             'type': 'date'
 989                                         },
 990                                         {
 991                                             'name': 'pohead_cohead_id_cohead_warehous_id',
 992                                             'type': 'int'
 993                                         },
 994                                         {
 995                                             'name': 'pohead_cohead_id_cohead_shipto_id',
 996                                             'type': 'int'
 997                                         },
 998                                         {
 999                                             'name': 'pohead_cohead_id_cohead_shiptoname',
1000                                             'type': 'string'
1001                                         },
1002                                         {
1003                                             'name': 'pohead_cohead_id_cohead_shiptoaddress1',
1004                                             'type': 'string'
1005                                         },
1006                                         {
1007                                             'name': 'pohead_cohead_id_cohead_shiptoaddress2',
1008                                             'type': 'string'
1009                                         },
1010                                         {
1011                                             'name': 'pohead_cohead_id_cohead_shiptoaddress3',
1012                                             'type': 'string'
1013                                         },
1014                                         {
1015                                             'name': 'pohead_cohead_id_cohead_shiptoaddress4',
1016                                             'type': 'string'
1017                                         },
1018                                         {
1019                                             'name': 'pohead_cohead_id_cohead_shiptoaddress5',
1020                                             'type': 'string'
1021                                         },
1022                                         {
1023                                             'name': 'pohead_cohead_id_cohead_salesrep_id',
1024                                             'type': 'int'
1025                                         },
1026                                         {
1027                                             'name': 'pohead_cohead_id_cohead_terms_id',
1028                                             'type': 'int'
1029                                         },
1030                                         {
1031                                             'name': 'pohead_cohead_id_cohead_origin',
1032                                             'type': 'string'
1033                                         },
1034                                         {
1035                                             'name': 'pohead_cohead_id_cohead_fob',
1036                                             'type': 'string'
1037                                         },
1038                                         {
1039                                             'name': 'pohead_cohead_id_cohead_shipvia',
1040                                             'type': 'string'
1041                                         },
1042                                         {
1043                                             'name': 'pohead_cohead_id_cohead_shiptocity',
1044                                             'type': 'string'
1045                                         },
1046                                         {
1047                                             'name': 'pohead_cohead_id_cohead_shiptostate',
1048                                             'type': 'string'
1049                                         },
1050                                         {
1051                                             'name': 'pohead_cohead_id_cohead_shiptozipcode',
1052                                             'type': 'string'
1053                                         },
1054                                         {
1055                                             'name': 'pohead_cohead_id_cohead_freight',
1056                                             'type': 'float'
1057                                         },
1058                                         {
1059                                             'name': 'pohead_cohead_id_cohead_misc',
1060                                             'type': 'float'
1061                                         },
1062                                         {
1063                                             'name': 'pohead_cohead_id_cohead_imported',
1064                                             'type': 'int'
1065                                         },
1066                                         {
1067                                             'name': 'pohead_cohead_id_cohead_ordercomments',
1068                                             'type': 'string'
1069                                         },
1070                                         {
1071                                             'name': 'pohead_cohead_id_cohead_shipcomments',
1072                                             'type': 'string'
1073                                         },
1074                                         {
1075                                             'name': 'pohead_cohead_id_cohead_shiptophone',
1076                                             'type': 'string'
1077                                         },
1078                                         {
1079                                             'name': 'pohead_cohead_id_cohead_shipchrg_id',
1080                                             'type': 'int'
1081                                         },
1082                                         {
1083                                             'name': 'pohead_cohead_id_cohead_shipform_id',
1084                                             'type': 'int'
1085                                         },
1086                                         {
1087                                             'name': 'pohead_cohead_id_cohead_billtoname',
1088                                             'type': 'string'
1089                                         },
1090                                         {
1091                                             'name': 'pohead_cohead_id_cohead_billtoaddress1',
1092                                             'type': 'string'
1093                                         },
1094                                         {
1095                                             'name': 'pohead_cohead_id_cohead_billtoaddress2',
1096                                             'type': 'string'
1097                                         },
1098                                         {
1099                                             'name': 'pohead_cohead_id_cohead_billtoaddress3',
1100                                             'type': 'string'
1101                                         },
1102                                         {
1103                                             'name': 'pohead_cohead_id_cohead_billtocity',
1104                                             'type': 'string'
1105                                         },
1106                                         {
1107                                             'name': 'pohead_cohead_id_cohead_billtostate',
1108                                             'type': 'string'
1109                                         },
1110                                         {
1111                                             'name': 'pohead_cohead_id_cohead_billtozipcode',
1112                                             'type': 'string'
1113                                         },
1114                                         {
1115                                             'name': 'pohead_cohead_id_cohead_misc_accnt_id',
1116                                             'type': 'int'
1117                                         },
1118                                         {
1119                                             'name': 'pohead_cohead_id_cohead_misc_accnt_id',
1120                                             'type': 'int'
1121                                         },
1122                                         {
1123                                             'name': 'pohead_cohead_id_cohead_misc_descrip',
1124                                             'type': 'string'
1125                                         },
1126                                         {
1127                                             'name': 'pohead_cohead_id_cohead_commission',
1128                                             'type': 'float'
1129                                         },
1130                                         {
1131                                             'name': 'pohead_cohead_id_cohead_miscdate',
1132                                             'type': 'date'
1133                                         },
1134                                         {
1135                                             'name': 'pohead_cohead_id_cohead_holdtype',
1136                                             'type': 'string'
1137                                         },
1138                                         {
1139                                             'name': 'pohead_cohead_id_cohead_packdate',
1140                                             'type': 'date'
1141                                         },
1142                                         {
1143                                             'name': 'pohead_cohead_id_cohead_prj_id',
1144                                             'type': 'int'
1145                                         },
1146                                         {
1147                                             'name': 'pohead_cohead_id_cohead_wasquote',
1148                                             'type': 'int'
1149                                         },
1150                                         {
1151                                             'name': 'pohead_cohead_id_cohead_lastupdated',
1152                                             'type': 'date'
1153                                         },
1154                                         {
1155                                             'name': 'pohead_cohead_id_cohead_shipcomplete',
1156                                             'type': 'int'
1157                                         },
1158                                         {
1159                                             'name': 'pohead_cohead_id_cohead_created',
1160                                             'type': 'date'
1161                                         },
1162                                         {
1163                                             'name': 'pohead_cohead_id_cohead_creator',
1164                                             'type': 'string'
1165                                         },
1166                                         {
1167                                             'name': 'pohead_cohead_id_cohead_quote_number',
1168                                             'type': 'string'
1169                                         },
1170                                         {
1171                                             'name': 'pohead_cohead_id_cohead_billtocountry',
1172                                             'type': 'string'
1173                                         },
1174                                         {
1175                                             'name': 'pohead_cohead_id_cohead_shiptocountry',
1176                                             'type': 'string'
1177                                         },
1178                                         {
1179                                             'name': 'pohead_cohead_id_cohead_curr_id',
1180                                             'type': 'int'
1181                                         },
1182                                         {
1183                                             'name': 'pohead_cohead_id_cohead_calcfreight',
1184                                             'type': 'int'
1185                                         },
1186                                         {
1187                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_id',
1188                                             'type': 'int'
1189                                         },
1190                                         {
1191                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_honorific',
1192                                             'type': 'string'
1193                                         },
1194                                         {
1195                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_first_name',
1196                                             'type': 'string'
1197                                         },
1198                                         {
1199                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_middle',
1200                                             'type': 'string'
1201                                         },
1202                                         {
1203                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_last_name',
1204                                             'type': 'string'
1205                                         },
1206                                         {
1207                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_suffix',
1208                                             'type': 'string'
1209                                         },
1210                                         {
1211                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_phone',
1212                                             'type': 'string'
1213                                         },
1214                                         {
1215                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_title',
1216                                             'type': 'string'
1217                                         },
1218                                         {
1219                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_fax',
1220                                             'type': 'string'
1221                                         },
1222                                         {
1223                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_email',
1224                                             'type': 'string'
1225                                         },
1226                                         {
1227                                             'name': 'pohead_cohead_id_cohead_billto_cntct_id',
1228                                             'type': 'int'
1229                                         },
1230                                         {
1231                                             'name': 'pohead_cohead_id_cohead_billto_cntct_honorific',
1232                                             'type': 'string'
1233                                         },
1234                                         {
1235                                             'name': 'pohead_cohead_id_cohead_billto_cntct_first_name',
1236                                             'type': 'string'
1237                                         },
1238                                         {
1239                                             'name': 'pohead_cohead_id_cohead_billto_cntct_middle',
1240                                             'type': 'string'
1241                                         },
1242                                         {
1243                                             'name': 'pohead_cohead_id_cohead_billto_cntct_last_name',
1244                                             'type': 'string'
1245                                         },
1246                                         {
1247                                             'name': 'pohead_cohead_id_cohead_billto_cntct_suffix',
1248                                             'type': 'string'
1249                                         },
1250                                         {
1251                                             'name': 'pohead_cohead_id_cohead_billto_cntct_phone',
1252                                             'type': 'string'
1253                                         },
1254                                         {
1255                                             'name': 'pohead_cohead_id_cohead_billto_cntct_title',
1256                                             'type': 'string'
1257                                         },
1258                                         {
1259                                             'name': 'pohead_cohead_id_cohead_billto_cntct_fax',
1260                                             'type': 'string'
1261                                         },
1262                                         {
1263                                             'name': 'pohead_cohead_id_cohead_billto_cntct_email',
1264                                             'type': 'string'
1265                                         },
1266                                         {
1267                                             'name': 'pohead_cohead_id_cohead_taxzone_id',
1268                                             'type': 'int'
1269                                         },
1270                                         {
1271                                             'name': 'pohead_cohead_id_cohead_taxtype_id',
1272                                             'type': 'int'
1273                                         },
1274                                         {
1275                                             'name': 'pohead_cohead_id_cohead_ophead_id',
1276                                             'type': 'int'
1277                                         },
1278                                         {
1279                                             'name': 'pohead_cohead_id_cohead_status',
1280                                             'type': 'string'
1281                                         },
1282                                         {
1283                                             'name': 'pohead_cohead_id_cohead_targetdate',
1284                                             'type': 'date'
1285                                         },
1286                                         {
1287                                             'name': 'pohead_cohead_id_cohead_location_src',
1288                                             'type': 'int'
1289                                         }
1290                                     ]
1291                                 }
1292                             },
1293                             footer : {
1294                                 xtype: 'PagingToolbar',
1295                                 xns: Roo,
1296                                 pageSize : 25,
1297                                 displayInfo : true,
1298                                 displayMsg : "Displaying pohead{0} - {1} of {2}",
1299                                 emptyMsg : "No pohead found"
1300                             },
1301                             toolbar : {
1302                                 xtype: 'Toolbar',
1303                                 xns: Roo,
1304                                 items : [
1305                                     {
1306                                         xtype: 'ComboBox',
1307                                         xns: Roo.form,
1308                                         listeners : {
1309                                             render : function (_self)
1310                                             {
1311                                               _this.status = _self;
1312                                             },
1313                                             select : function (combo, record, index)
1314                                             {
1315                                                 Roo.log('select');
1316                                                 _this.grid.footer.onClick('first');
1317                                             }
1318                                         },
1319                                         allowBlank : false,
1320                                         displayField : 'fname',
1321                                         editable : false,
1322                                         fieldLabel : 'Status',
1323                                         hiddenName : 'cm_status',
1324                                         listWidth : 200,
1325                                         mode : 'local',
1326                                         name : 'cm_status_name',
1327                                         triggerAction : 'all',
1328                                         value : "O",
1329                                         valueField : 'ftype',
1330                                         width : 150,
1331                                         store : {
1332                                             xtype: 'SimpleStore',
1333                                             xns: Roo.data,
1334                                             data : [
1335                                                 [ 'O', "Open"],
1336                                                 [ 'C' , "Closed"],
1337                                                 [ 'U', "Unreleased"]
1338                                             ],
1339                                             fields : [  'ftype', 'fname']
1340                                         }
1341                                     },
1342                                     {
1343                                         xtype: 'TextField',
1344                                         xns: Roo.form,
1345                                         listeners : {
1346                                             specialkey : function (_self, e)
1347                                             {
1348                                               _this.grid.footer.onClick('first');
1349                                             },
1350                                             render : function (_self)
1351                                             {
1352                                                 _this.searchBox = _self;
1353                                             }
1354                                         }
1355                                     },
1356                                     {
1357                                         xtype: 'Button',
1358                                         xns: Roo.Toolbar,
1359                                         listeners : {
1360                                             click : function (_self, e)
1361                                             {
1362                                             _this.grid.footer.onClick('first');
1363                                             }
1364                                         },
1365                                         cls : 'x-btn-icon',
1366                                         icon : rootURL + '/Pman/templates/images/search.gif'
1367                                     },
1368                                     {
1369                                         xtype: 'Button',
1370                                         xns: Roo.Toolbar,
1371                                         listeners : {
1372                                             click : function (_self, e)
1373                                             {
1374                                                 _this.searchBox.setValue('');
1375
1376
1377                                                 _this.grid.footer.onClick('first');
1378                                             }
1379                                         },
1380                                         cls : 'x-btn-icon',
1381                                         icon : rootURL + '/Pman/templates/images/edit-clear.gif'
1382                                     },
1383                                     {
1384                                         xtype: 'Fill',
1385                                         xns: Roo.Toolbar
1386                                     },
1387                                     {
1388                                         xtype: 'Button',
1389                                         xns: Roo.Toolbar,
1390                                         listeners : {
1391                                             click : function()
1392                                             {
1393
1394                                                Pman.Dialog.XtuplePurchaseOrderNew.show( {} , function(v) {
1395                                                     Pman.Dialog.XtuplePurchaseOrder.show(v , function() {
1396                                                         _this.grid.footer.onClick('first');
1397                                                     });
1398                                                });
1399                                             }
1400                                         },
1401                                         cls : 'x-btn-text-icon',
1402                                         text : "Add",
1403                                         icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
1404                                     },
1405                                     {
1406                                         xtype: 'Separator',
1407                                         xns: Roo.Toolbar
1408                                     },
1409                                     {
1410                                         xtype: 'Button',
1411                                         xns: Roo.Toolbar,
1412                                         listeners : {
1413                                             click : function (_self, e)
1414                                             {
1415                                                 var sel = _this.grid.selModel.getSelected();
1416                                                 if (!sel) {
1417                                                     Roo.MessageBox.alert("Error", "Select a row");
1418                                                     return;
1419                                                 }
1420
1421                                                 var print = function(){
1422                                                     var params  =   {
1423                                                         template: 'Purchase-Order',
1424                                                         filename : 'Purchase-Order-' + sel.data.pohead_number +
1425                                                             '-' + (new Date()).format('Y-m-d'),
1426                                                         'param[0]':   "pohead_id:number=" + sel.data.pohead_id
1427                                                     };
1428
1429                                                     new Pman.Download({
1430                                                       url : baseURL + '/Xtuple/Print',
1431
1432                                                       params :   params,
1433                                                       method : 'GET'
1434                                                     });
1435                                                     Roo.MessageBox.alert("Notice", "Report will download shortly");
1436
1437                                                 }
1438
1439
1440                                                 if(!sel.data.pohead_printed){
1441                                                     new Pman.Request({
1442                                                         url : baseURL + '/Roo/pohead',
1443                                                         mask : 'Updating',
1444                                                         method : 'POST',
1445                                                         params : {
1446                                                             pohead_id : sel.data.pohead_id,
1447                                                             _print : 1
1448                                                         },
1449                                                         success : function() {
1450                                                             print();
1451                                                         }
1452                                                     });
1453
1454                                                     return;
1455                                                 }
1456
1457                                                 print();
1458
1459                                             }
1460                                         },
1461                                         cls : 'x-btn-text-icon',
1462                                         text : "Print",
1463                                         icon : rootURL + '/Pman/templates/images/pdf.gif'
1464                                     },
1465                                     {
1466                                         xtype: 'Separator',
1467                                         xns: Roo.Toolbar
1468                                     },
1469                                     {
1470                                         xtype: 'Button',
1471                                         xns: Roo.Toolbar,
1472                                         cls : 'x-btn-text-icon',
1473                                         text : "Change Status",
1474                                         icon : Roo.rootURL + 'images/default/tree/leaf.gif',
1475                                         menu : {
1476                                             xtype: 'Menu',
1477                                             xns: Roo.menu,
1478                                             items : [
1479                                                 {
1480                                                     xtype: 'Item',
1481                                                     xns: Roo.menu,
1482                                                     listeners : {
1483                                                         click : function (_self, e)
1484                                                         {
1485                                                             var sel = _this.grid.selModel.getSelected();
1486                                                             if (!sel) {
1487                                                                 Roo.MessageBox.alert("Error", "Select a row");
1488                                                                 return;
1489                                                             }
1490                                                             if (sel.data.pohead_status == 'C') {
1491                                                                 Roo.MessageBox.alert("Error", "Purchase order is already closed");
1492                                                                 return;
1493                                                             }
1494
1495                                                             new Pman.Request({
1496                                                                 url : baseURL + '/Roo/pohead',
1497                                                                 mask : 'Closing',
1498                                                                 method : 'POST',
1499                                                                 params : {
1500                                                                     pohead_id : sel.data.pohead_id,
1501                                                                     _close : 1
1502                                                                 },
1503                                                                 success : function() {
1504                                                                     _this.grid.footer.onClick('refresh');
1505                                                                 }
1506                                                             });
1507
1508
1509                                                         }
1510                                                     },
1511                                                     text : "Close Selected",
1512                                                     icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1513                                                 },
1514                                                 {
1515                                                     xtype: 'Item',
1516                                                     xns: Roo.menu,
1517                                                     listeners : {
1518                                                         click : function (_self, e)
1519                                                         {
1520                                                             var sel = _this.grid.selModel.getSelected();
1521                                                             if (!sel) {
1522                                                                 Roo.MessageBox.alert("Error", "Select a row");
1523                                                                 return;
1524                                                             }
1525                                                             if (sel.data.pohead_status != 'O') {
1526                                                                 Roo.MessageBox.alert("Error", "Purchase order is not Open");
1527                                                                 return;
1528                                                             }
1529
1530                                                             new Pman.Request({
1531                                                                 url : baseURL + '/Roo/pohead',
1532                                                                 mask : 'Unreleasing',
1533                                                                 method : 'POST',
1534                                                                 params : {
1535                                                                     pohead_id : sel.data.pohead_id,
1536                                                                     _unrelease : 1
1537                                                                 },
1538                                                                 success : function() {
1539                                                                     _this.grid.footer.onClick('refresh');
1540                                                                 }
1541                                                             });
1542
1543
1544                                                         }
1545                                                     },
1546                                                     icon : Roo.rootURL + 'images/default/tree/leaf.gif',
1547                                                     text : "Unrelease Selected"
1548                                                 },
1549                                                 {
1550                                                     xtype: 'Item',
1551                                                     xns: Roo.menu,
1552                                                     listeners : {
1553                                                         click : function (_self, e)
1554                                                         {
1555                                                             var sel = _this.grid.selModel.getSelected();
1556                                                             if (!sel) {
1557                                                                 Roo.MessageBox.alert("Error", "Select a row");
1558                                                                 return;
1559                                                             }
1560                                                             if (sel.data.pohead_status == 'O') {
1561                                                                 Roo.MessageBox.alert("Error", "Purchase order is already Open");
1562                                                                 return;
1563                                                             }
1564
1565                                                             new Pman.Request({
1566                                                                 url : baseURL + '/Roo/pohead',
1567                                                                 mask : 'Reopening',
1568                                                                 method : 'POST',
1569                                                                 params : {
1570                                                                     pohead_id : sel.data.pohead_id,
1571                                                                     _reopen : 1
1572                                                                 },
1573                                                                 success : function() {
1574                                                                     _this.grid.footer.onClick('refresh');
1575                                                                 }
1576                                                             });
1577
1578
1579                                                         }
1580                                                     },
1581                                                     text : "Reopen",
1582                                                     icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1583                                                 }
1584                                             ]
1585                                         }
1586                                     },
1587                                     {
1588                                         xtype: 'Separator',
1589                                         xns: Roo.Toolbar
1590                                     },
1591                                     {
1592                                         xtype: 'TextItem',
1593                                         xns: Roo.Toolbar,
1594                                         text : "Report Since"
1595                                     },
1596                                     {
1597                                         xtype: 'DateField',
1598                                         xns: Roo.form,
1599                                         listeners : {
1600                                             render : function (_self)
1601                                             {
1602                                                 _this.reportSince = _self;
1603
1604                                                 this.setValue((new Date()).add(Date.MONTH, -1)) ; //.format('Y-m-d');
1605                                             }
1606                                         },
1607                                         format : 'd/M/Y',
1608                                         useIso : true,
1609                                         width : 100
1610                                     },
1611                                     {
1612                                         xtype: 'Button',
1613                                         xns: Roo.Toolbar,
1614                                         cls : 'x-btn-text-icon',
1615                                         text : "Reports",
1616                                         icon : rootURL + '/Pman/templates/images/spreadsheet.gif',
1617                                         menu : {
1618                                             xtype: 'Menu',
1619                                             xns: Roo.menu,
1620                                             items : [
1621                                                 {
1622                                                     xtype: 'Item',
1623                                                     xns: Roo.menu,
1624                                                     text : "AP Aging Report",
1625                                                     menu : {
1626                                                         xtype: 'Menu',
1627                                                         xns: Roo.menu,
1628                                                         items : [
1629                                                             {
1630                                                                 xtype: 'Item',
1631                                                                 xns: Roo.menu,
1632                                                                 listeners : {
1633                                                                     click : function (_self, e)
1634                                                                     {
1635                                                                         var dt = (new Date()).format('Y-m-d');
1636
1637                                                                         var params = {
1638                                                                             '_group' : 'apAging',
1639                                                                             '_name' : 'bydate',
1640                                                                             'limit' : 99999,
1641                                                                             'relDate:text' : dt,
1642                                                                             'useDocDate:text' : 'TRUE',
1643                                                                             'csvTitles' : '*',
1644                                                                             'csvCols' : '*'
1645                                                                         };
1646                                                                         var s = _this.grid.getSelectionModel().getSelected();
1647
1648                                                                         if(s){
1649                                                                             if(s.data.pohead_vend_id > 0){
1650                                                                                 params['vend_id:number'] = s.data.pohead_vend_id;
1651                                                                             }
1652                                                                         }
1653
1654                                                                         new Pman.Download({\r
1655                                                                           url : baseURL + '/Roo/Metasql',\r
1656                                                                           params :   params,\r
1657                                                                           method : 'GET'\r
1658                                                                         });\r
1659                                                                         Roo.MessageBox.alert("Notice", "Report will download shortly");\r
1660                                                                         \r
1661                                                                     }
1662                                                                 },
1663                                                                 text : "as Excel"
1664                                                             },
1665                                                             {
1666                                                                 xtype: 'Item',
1667                                                                 xns: Roo.menu,
1668                                                                 listeners : {
1669                                                                     click : function (_self, e)
1670                                                                     {
1671
1672                                                                         var params  =   {
1673                                                                             template: 'APAging',
1674                                                                             filename : 'ARAging-' + (new Date()).format('Y-m-d'),
1675                                                                             'param[0]':   "relDate:string='" + (new Date()).format('Y-m-d') + "'",
1676                                                                             'param[1]':   "useDocDate:number=1"
1677                                                                         };
1678
1679                                                                         var s = _this.grid.getSelectionModel().getSelected();
1680
1681                                                                         if(s){
1682                                                                             if(s.data.pohead_vend_id > 0){
1683                                                                                 params['param[2]'] = 'vend_id:number=' + s.data.pohead_vend_id;
1684                                                                             }
1685                                                                         }
1686
1687                                                                         new Pman.Download({
1688                                                                           url : baseURL + '/Xtuple/Print',
1689                                                                           params :   params,
1690                                                                           method : 'GET'
1691                                                                         });
1692                                                                         Roo.MessageBox.alert("Notice", "Report will download shortly");
1693                                                                     }
1694                                                                 },
1695                                                                 text : "as PDF"
1696                                                             }
1697                                                         ]
1698                                                     }
1699                                                 },
1700                                                 {
1701                                                     xtype: 'Item',
1702                                                     xns: Roo.menu,
1703                                                     text : "Goods Reciept Report",
1704                                                     menu : {
1705                                                         xtype: 'Menu',
1706                                                         xns: Roo.menu,
1707                                                         items : [
1708                                                             {
1709                                                                 xtype: 'Item',
1710                                                                 xns: Roo.menu,
1711                                                                 listeners : {
1712                                                                     click : function (_self, e)
1713                                                                     {
1714                                                                         var dt = Date.parseDate( _this.reportSince.getValue(), 'Y-m-d');
1715
1716                                                                         var params = {
1717                                                                             '_group' : 'recvgrp',
1718                                                                             '_name' : 'byorder',
1719                                                                             'limit' : 99999,
1720                                                                             'startDate:text' : dt.format('Y-m-d'),
1721                                                                             'endDate:text' : dt.add(Date.MONTH,1).format('Y-m-d'),
1722                                                                             'csvTitles' : '*',
1723                                                                             'csvCols' : '*'
1724                                                                         };
1725
1726                                                                         new Pman.Download({\r
1727                                                                           url : baseURL + '/Roo/Metasql',\r
1728                                                                           params :   params,\r
1729                                                                           method : 'GET'\r
1730                                                                         });\r
1731                                                                         Roo.MessageBox.alert("Notice", "Report will download shortly");\r
1732                                                                         \r
1733                                                                     }
1734                                                                 },
1735                                                                 text : "For 1 month"
1736                                                             },
1737                                                             {
1738                                                                 xtype: 'Item',
1739                                                                 xns: Roo.menu,
1740                                                                 listeners : {
1741                                                                     click : function (_self, e)
1742                                                                     {
1743                                                                         var dt = Date.parseDate( _this.reportSince.getValue(), 'Y-m-d');
1744
1745                                                                         var params = {
1746                                                                             '_group' : 'recvgrp',
1747                                                                             '_name' : 'byorder',
1748                                                                             'limit' : 99999,
1749                                                                             'startDate:text' : dt.format('Y-m-d'),
1750                                                                             'endDate:text' : dt.add(Date.YEAR,1).format('Y-m-d'),
1751                                                                             'csvTitles' : '*',
1752                                                                             'csvCols' : '*'
1753                                                                         };
1754
1755                                                                         new Pman.Download({\r
1756                                                                           url : baseURL + '/Roo/Metasql',\r
1757                                                                           params :   params,\r
1758                                                                           method : 'GET'\r
1759                                                                         });\r
1760                                                                         Roo.MessageBox.alert("Notice", "Report will download shortly");\r
1761                                                                         \r
1762                                                                     }
1763                                                                 },
1764                                                                 text : "For 1 year"
1765                                                             }
1766                                                         ]
1767                                                     }
1768                                                 }
1769                                             ]
1770                                         }
1771                                     }
1772                                 ]
1773                             },
1774                             colModel : [
1775                                 {
1776                                     xtype: 'ColumnModel',
1777                                     xns: Roo.grid,
1778                                     dataIndex : 'pohead_number',
1779                                     header : 'No#',
1780                                     sortable : true,
1781                                     width : 150,
1782                                     renderer : function(v,x,r) {
1783                                         var vv =v;
1784                                         var nn  = '';
1785                                         if (vv.indexOf(',') > -1) {
1786                                             vv = vv.split(',').shift();
1787
1788                                         }
1789                                         if (vv.match(/^NSPO-/)) {
1790                                             vv = vv.replace(/^NSPO-/, '');
1791                                             nn = 'ns:&nbsp;';
1792                                         }
1793
1794                                         return String.format('<i>'+ nn +'</i><b qtip="{1}">{0}</b> {2}', vv,v, r.data.pohead_comments );
1795
1796
1797                                      }
1798                                 },
1799                                 {
1800                                     xtype: 'ColumnModel',
1801                                     xns: Roo.grid,
1802                                     dataIndex : 'pohead_orderdate',
1803                                     header : 'Ordered',
1804                                     sortable : true,
1805                                     width : 75,
1806                                     renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
1807                                 },
1808                                 {
1809                                     xtype: 'ColumnModel',
1810                                     xns: Roo.grid,
1811                                     dataIndex : 'pohead_vend_id_vend_name',
1812                                     header : 'Vendor',
1813                                     sortable : true,
1814                                     width : 75,
1815                                     renderer : function(v) { return String.format('{0}', v); }
1816                                 },
1817                                 {
1818                                     xtype: 'ColumnModel',
1819                                     xns: Roo.grid,
1820                                     dataIndex : 'pohead_curr_id_curr_abbr',
1821                                     header : 'Currency',
1822                                     width : 75,
1823                                     renderer : function(v) { return String.format('{0}', v); }
1824                                 },
1825                                 {
1826                                     xtype: 'ColumnModel',
1827                                     xns: Roo.grid,
1828                                     align : 'right',
1829                                     dataIndex : 'pohead_val',
1830                                     header : 'PO value',
1831                                     width : 75,
1832                                     renderer : function(v,x,r) {
1833
1834                                         var f = (Math.round(v*100) != Math.round(r.data.pohead_vouchered*100)) ? '<span style="color:red;font-weight:bold">{0}</span>' : '{0}';
1835                                         return String.format(f,  v ? Roo.util.Format.usMoney( v) : '' );
1836
1837                                      }
1838                                 },
1839                                 {
1840                                     xtype: 'ColumnModel',
1841                                     xns: Roo.grid,
1842                                     align : 'right',
1843                                     dataIndex : 'pohead_vouchered',
1844                                     header : 'Vouchered',
1845                                     width : 75,
1846                                     renderer : function(v,x,r) {
1847
1848                                         var f =  (Math.round(v*100) != Math.round(r.data.pohead_paid*100)) ? '<span style="color:red;font-weight:bold">{0}</span>' : '{0}';
1849                                         return String.format(f,  v ? Roo.util.Format.usMoney( v) : '' );
1850                                      }
1851                                 },
1852                                 {
1853                                     xtype: 'ColumnModel',
1854                                     xns: Roo.grid,
1855                                     align : 'right',
1856                                     dataIndex : 'pohead_paid',
1857                                     header : 'Paid',
1858                                     width : 75,
1859                                     renderer : function(v) { return v ? Roo.util.Format.usMoney( v) : ''; }
1860                                 },
1861                                 {
1862                                     xtype: 'ColumnModel',
1863                                     xns: Roo.grid,
1864                                     align : 'right',
1865                                     dataIndex : 'landed_cost',
1866                                     header : 'Landed',
1867                                     width : 75,
1868                                     renderer : function(v,x,r) {
1869                                         if (r.data.landed_missing * 1) {
1870                                                 return v ? ('<b style="color:red">' + Roo.util.Format.usMoney( v) + '</b>') : '';
1871                                         }
1872
1873                                         return v ? Roo.util.Format.usMoney( v) : '';
1874                                     }
1875                                 },
1876                                 {
1877                                     xtype: 'ColumnModel',
1878                                     xns: Roo.grid,
1879                                     align : 'right',
1880                                     dataIndex : 'pohead_qty',
1881                                     header : 'Order Qty',
1882                                     width : 75,
1883                                     renderer : function(v) { return String.format('{0}', v ? (1*v).toFixed(0) : ''); }
1884                                 },
1885                                 {
1886                                     xtype: 'ColumnModel',
1887                                     xns: Roo.grid,
1888                                     align : 'right',
1889                                     dataIndex : 'pohead_qty_in_transit',
1890                                     header : 'In Transit',
1891                                     width : 75,
1892                                     renderer : function(v,x,r) {
1893                                          var vv = v - (1*r.data.pohead_qty_transfered_unposted) -
1894                                              (1*r.data.pohead_qty_transfered) ;
1895                                          return String.format('{0}',vv ? (1*vv).toFixed(0) : '');
1896
1897                                      }
1898                                 },
1899                                 {
1900                                     xtype: 'ColumnModel',
1901                                     xns: Roo.grid,
1902                                     align : 'right',
1903                                     dataIndex : 'pohead_qty_recv',
1904                                     header : 'Recieved',
1905                                     width : 75,
1906                                     renderer : function(v,x,r) {
1907
1908                                         // total recieved = recv + recv_transfered - intransit?
1909
1910                                         // old style = 0 in transit
1911                                         // all delivered direct to warehouse
1912                                         // 0 in
1913
1914                                         // new style = 100 in transit
1915                                         // it will record 100 in transit, and 100 recieved
1916                                         // and
1917
1918                                         // recv 610,unposted = 0 , transfer 610, in transit 610
1919
1920                                          var recv = (1*r.data.pohead_qty_recv) +
1921                                                (1*r.data.pohead_qty_transfered_unposted) +
1922                                                  (1*r.data.pohead_qty_transfered) -
1923                                                  (1*r.data.pohead_qty_in_transit) ;
1924
1925
1926                                         if(r.data.pohead_qty_transfered_unposted * 1 > 0){
1927                                             return String.format('<b style="color:red" qtip="{1} are Unposted">{0}</b>', recv ? (1*recv).toFixed(0) : '',
1928                                             r.data.pohead_qty_transfered_unposted);
1929                                         }
1930
1931                                         var format = '{0}';
1932                                         if(recv != r.data.pohead_qty){
1933                                             format = '<span style="color:red">{0}</span>';
1934                                         }
1935
1936                                         return String.format(format, recv ? (1*recv).toFixed(0) : '');
1937
1938                                      }
1939                                 }
1940                             ]
1941                         }
1942                     },
1943                     {
1944                         xtype: 'NestedLayoutPanel',
1945                         xns: Roo,
1946                         background : true,
1947                         fitContainer : true,
1948                         fitToFrame : true,
1949                         region : 'east',
1950                         layout : {
1951                             xtype: 'BorderLayout',
1952                             xns: Roo,
1953                             items : [
1954                                 {
1955                                     xtype: 'GridPanel',
1956                                     xns: Roo,
1957                                     listeners : {
1958                                         activate : function() {
1959                                             _this.rgpanel = this;
1960                                             if (_this.rggrid) {
1961                                                 //_this.rggrid.ds.load({});
1962                                             }
1963                                         }
1964                                     },
1965                                     background : true,
1966                                     fitContainer : true,
1967                                     fitToframe : true,
1968                                     region : 'center',
1969                                     tableName : 'recvgrp',
1970                                     title : "recvgrp",
1971                                     grid : {
1972                                         xtype: 'Grid',
1973                                         xns: Roo.grid,
1974                                         listeners : {
1975                                             render : function()
1976                                             {
1977                                                 _this.rggrid = this;
1978                                                 //_this.dialog = Pman.Dialog.FILL_IN
1979                                                 if (_this.rgpanel.active) {
1980                                                    //this.ds.load({});
1981                                                 }
1982                                             },
1983                                             rowdblclick : function (_self, rowIndex, e)
1984                                             {
1985                                                  var s  = _this.rggrid.ds.getAt(rowIndex);
1986
1987                                                 Pman.Dialog.XtupleRecvGrp.show( {
1988                                                      recvgrp_id : s.data.recvgrp_id
1989
1990                                                  } , function() {
1991                                                     _this.grid.footer.onClick('refresh');
1992                                                });
1993                                             },
1994                                             rowclick : function (_self, rowIndex, e)
1995                                             {
1996                                                 (function() { _this.rgrid.footer.onClick('first');}).defer(100);
1997                                             }
1998                                         },
1999                                         autoExpandColumn : 'recvgrp_number',
2000                                         loadMask : true,
2001                                         dataSource : {
2002                                             xtype: 'Store',
2003                                             xns: Roo.data,
2004                                             listeners : {
2005                                                 beforeload : function (_self, options)
2006                                                 {
2007                                                     if (!_this.grid || !_this.grid.selModel.getSelectedCell()) {
2008                                                          this.removeAll();
2009                                                          if (_this.rgrid) {
2010                                                             _this.rgrid.ds.removeAll();
2011                                                         }
2012                                                         return false;
2013                                                     }
2014                                                     var c = _this.grid.selModel.getSelectedCell();
2015
2016                                                     var r = _this.grid.ds.getAt(c[0]);
2017
2018                                                     options.params = options.params || {};
2019                                                     options.params.recvgrp_pohead_id = r.data.pohead_id;
2020
2021                                                 },
2022                                                 load : function (_self, records, options)
2023                                                 {
2024                                                     _this.rgrid.footer.onClick('first');
2025                                                 }
2026                                             },
2027                                             remoteSort : true,
2028                                             sortInfo : { field : 'recvgrp_id', direction: 'ASC' },
2029                                             proxy : {
2030                                                 xtype: 'HttpProxy',
2031                                                 xns: Roo.data,
2032                                                 method : 'GET',
2033                                                 url : baseURL + '/Roo/recvgrp.php'
2034                                             },
2035                                             reader : {
2036                                                 xtype: 'JsonReader',
2037                                                 xns: Roo.data,
2038                                                 totalProperty : 'total',
2039                                                 root : 'data',
2040                                                 id : 'id',
2041                                                 fields : [
2042                                                     {
2043                                                         'name': 'recv_id',
2044                                                         'type': 'int'
2045                                                     },
2046                                                     {
2047                                                         'name': 'recv_order_type',
2048                                                         'type': 'string'
2049                                                     },
2050                                                     {
2051                                                         'name': 'recv_order_number',
2052                                                         'type': 'string'
2053                                                     },
2054                                                     {
2055                                                         'name': 'recv_orderitem_id',
2056                                                         'type': 'int'
2057                                                     },
2058                                                     {
2059                                                         'name': 'recv_agent_username',
2060                                                         'type': 'string'
2061                                                     },
2062                                                     {
2063                                                         'name': 'recv_itemsite_id',
2064                                                         'type': 'int'
2065                                                     },
2066                                                     {
2067                                                         'name': 'recv_vend_id',
2068                                                         'type': 'int'
2069                                                     },
2070                                                     {
2071                                                         'name': 'recv_vend_item_number',
2072                                                         'type': 'string'
2073                                                     },
2074                                                     {
2075                                                         'name': 'recv_vend_item_descrip',
2076                                                         'type': 'string'
2077                                                     },
2078                                                     {
2079                                                         'name': 'recv_vend_uom',
2080                                                         'type': 'string'
2081                                                     },
2082                                                     {
2083                                                         'name': 'recv_purchcost',
2084                                                         'type': 'float'
2085                                                     },
2086                                                     {
2087                                                         'name': 'recv_purchcost_curr_id',
2088                                                         'type': 'int'
2089                                                     },
2090                                                     {
2091                                                         'name': 'recv_duedate',
2092                                                         'type': 'date',
2093                                                         'dateFormat': 'Y-m-d'
2094                                                     },
2095                                                     {
2096                                                         'name': 'recv_qty',
2097                                                         'type': 'float'
2098                                                     },
2099                                                     {
2100                                                         'name': 'recv_recvcost',
2101                                                         'type': 'float'
2102                                                     },
2103                                                     {
2104                                                         'name': 'recv_recvcost_curr_id',
2105                                                         'type': 'int'
2106                                                     },
2107                                                     {
2108                                                         'name': 'recv_freight',
2109                                                         'type': 'float'
2110                                                     },
2111                                                     {
2112                                                         'name': 'recv_freight_curr_id',
2113                                                         'type': 'int'
2114                                                     },
2115                                                     {
2116                                                         'name': 'recv_date',
2117                                                         'type': 'date',
2118                                                         'dateFormat': 'Y-m-d'
2119                                                     },
2120                                                     {
2121                                                         'name': 'recv_value',
2122                                                         'type': 'float'
2123                                                     },
2124                                                     {
2125                                                         'name': 'recv_posted',
2126                                                         'type': 'int'
2127                                                     },
2128                                                     {
2129                                                         'name': 'recv_invoiced',
2130                                                         'type': 'int'
2131                                                     },
2132                                                     {
2133                                                         'name': 'recv_vohead_id',
2134                                                         'type': 'int'
2135                                                     },
2136                                                     {
2137                                                         'name': 'recv_voitem_id',
2138                                                         'type': 'int'
2139                                                     },
2140                                                     {
2141                                                         'name': 'recv_trans_usr_name',
2142                                                         'type': 'string'
2143                                                     },
2144                                                     {
2145                                                         'name': 'recv_notes',
2146                                                         'type': 'string'
2147                                                     },
2148                                                     {
2149                                                         'name': 'recv_gldistdate',
2150                                                         'type': 'date',
2151                                                         'dateFormat': 'Y-m-d'
2152                                                     },
2153                                                     {
2154                                                         'name': 'recv_splitfrom_id',
2155                                                         'type': 'int'
2156                                                     },
2157                                                     {
2158                                                         'name': 'recv_rlsd_duedate',
2159                                                         'type': 'date',
2160                                                         'dateFormat': 'Y-m-d'
2161                                                     },
2162                                                     {
2163                                                         'name': 'recv_voitem_id_voitem_id',
2164                                                         'type': 'int'
2165                                                     },
2166                                                     {
2167                                                         'name': 'recv_voitem_id_voitem_vohead_id',
2168                                                         'type': 'int'
2169                                                     },
2170                                                     {
2171                                                         'name': 'recv_voitem_id_voitem_poitem_id',
2172                                                         'type': 'int'
2173                                                     },
2174                                                     {
2175                                                         'name': 'recv_voitem_id_voitem_close',
2176                                                         'type': 'int'
2177                                                     },
2178                                                     {
2179                                                         'name': 'recv_voitem_id_voitem_qty',
2180                                                         'type': 'float'
2181                                                     },
2182                                                     {
2183                                                         'name': 'recv_voitem_id_voitem_freight',
2184                                                         'type': 'float'
2185                                                     },
2186                                                     {
2187                                                         'name': 'recv_voitem_id_voitem_taxtype_id',
2188                                                         'type': 'int'
2189                                                     },
2190                                                     {
2191                                                         'name': 'recv_vohead_id_vohead_id',
2192                                                         'type': 'int'
2193                                                     },
2194                                                     {
2195                                                         'name': 'recv_vohead_id_vohead_number',
2196                                                         'type': 'string'
2197                                                     },
2198                                                     {
2199                                                         'name': 'recv_vohead_id_vohead_pohead_id',
2200                                                         'type': 'int'
2201                                                     },
2202                                                     {
2203                                                         'name': 'recv_vohead_id_vohead_posted',
2204                                                         'type': 'int'
2205                                                     },
2206                                                     {
2207                                                         'name': 'recv_vohead_id_vohead_duedate',
2208                                                         'type': 'date'
2209                                                     },
2210                                                     {
2211                                                         'name': 'recv_vohead_id_vohead_invcnumber',
2212                                                         'type': 'string'
2213                                                     },
2214                                                     {
2215                                                         'name': 'recv_vohead_id_vohead_amount',
2216                                                         'type': 'float'
2217                                                     },
2218                                                     {
2219                                                         'name': 'recv_vohead_id_vohead_docdate',
2220                                                         'type': 'date'
2221                                                     },
2222                                                     {
2223                                                         'name': 'recv_vohead_id_vohead_1099',
2224                                                         'type': 'int'
2225                                                     },
2226                                                     {
2227                                                         'name': 'recv_vohead_id_vohead_distdate',
2228                                                         'type': 'date'
2229                                                     },
2230                                                     {
2231                                                         'name': 'recv_vohead_id_vohead_reference',
2232                                                         'type': 'string'
2233                                                     },
2234                                                     {
2235                                                         'name': 'recv_vohead_id_vohead_terms_id',
2236                                                         'type': 'int'
2237                                                     },
2238                                                     {
2239                                                         'name': 'recv_vohead_id_vohead_vend_id',
2240                                                         'type': 'int'
2241                                                     },
2242                                                     {
2243                                                         'name': 'recv_vohead_id_vohead_curr_id',
2244                                                         'type': 'int'
2245                                                     },
2246                                                     {
2247                                                         'name': 'recv_vohead_id_vohead_adjtaxtype_id',
2248                                                         'type': 'int'
2249                                                     },
2250                                                     {
2251                                                         'name': 'recv_vohead_id_vohead_freighttaxtype_id',
2252                                                         'type': 'int'
2253                                                     },
2254                                                     {
2255                                                         'name': 'recv_vohead_id_vohead_gldistdate',
2256                                                         'type': 'date'
2257                                                     },
2258                                                     {
2259                                                         'name': 'recv_vohead_id_vohead_misc',
2260                                                         'type': 'int'
2261                                                     },
2262                                                     {
2263                                                         'name': 'recv_vohead_id_vohead_taxzone_id',
2264                                                         'type': 'int'
2265                                                     },
2266                                                     {
2267                                                         'name': 'recv_vohead_id_vohead_taxtype_id',
2268                                                         'type': 'int'
2269                                                     },
2270                                                     {
2271                                                         'name': 'recv_vohead_id_vohead_notes',
2272                                                         'type': 'string'
2273                                                     },
2274                                                     {
2275                                                         'name': 'recv_vend_id_vend_id',
2276                                                         'type': 'int'
2277                                                     },
2278                                                     {
2279                                                         'name': 'recv_vend_id_vend_name',
2280                                                         'type': 'string'
2281                                                     },
2282                                                     {
2283                                                         'name': 'recv_vend_id_vend_lastpurchdate',
2284                                                         'type': 'date'
2285                                                     },
2286                                                     {
2287                                                         'name': 'recv_vend_id_vend_active',
2288                                                         'type': 'int'
2289                                                     },
2290                                                     {
2291                                                         'name': 'recv_vend_id_vend_po',
2292                                                         'type': 'int'
2293                                                     },
2294                                                     {
2295                                                         'name': 'recv_vend_id_vend_comments',
2296                                                         'type': 'string'
2297                                                     },
2298                                                     {
2299                                                         'name': 'recv_vend_id_vend_pocomments',
2300                                                         'type': 'string'
2301                                                     },
2302                                                     {
2303                                                         'name': 'recv_vend_id_vend_number',
2304                                                         'type': 'string'
2305                                                     },
2306                                                     {
2307                                                         'name': 'recv_vend_id_vend_1099',
2308                                                         'type': 'int'
2309                                                     },
2310                                                     {
2311                                                         'name': 'recv_vend_id_vend_exported',
2312                                                         'type': 'int'
2313                                                     },
2314                                                     {
2315                                                         'name': 'recv_vend_id_vend_fobsource',
2316                                                         'type': 'string'
2317                                                     },
2318                                                     {
2319                                                         'name': 'recv_vend_id_vend_fob',
2320                                                         'type': 'string'
2321                                                     },
2322                                                     {
2323                                                         'name': 'recv_vend_id_vend_terms_id',
2324                                                         'type': 'int'
2325                                                     },
2326                                                     {
2327                                                         'name': 'recv_vend_id_vend_shipvia',
2328                                                         'type': 'string'
2329                                                     },
2330                                                     {
2331                                                         'name': 'recv_vend_id_vend_vendtype_id',
2332                                                         'type': 'int'
2333                                                     },
2334                                                     {
2335                                                         'name': 'recv_vend_id_vend_qualified',
2336                                                         'type': 'int'
2337                                                     },
2338                                                     {
2339                                                         'name': 'recv_vend_id_vend_ediemail',
2340                                                         'type': 'string'
2341                                                     },
2342                                                     {
2343                                                         'name': 'recv_vend_id_vend_ediemailbody',
2344                                                         'type': 'string'
2345                                                     },
2346                                                     {
2347                                                         'name': 'recv_vend_id_vend_edisubject',
2348                                                         'type': 'string'
2349                                                     },
2350                                                     {
2351                                                         'name': 'recv_vend_id_vend_edifilename',
2352                                                         'type': 'string'
2353                                                     },
2354                                                     {
2355                                                         'name': 'recv_vend_id_vend_accntnum',
2356                                                         'type': 'string'
2357                                                     },
2358                                                     {
2359                                                         'name': 'recv_vend_id_vend_emailpodelivery',
2360                                                         'type': 'int'
2361                                                     },
2362                                                     {
2363                                                         'name': 'recv_vend_id_vend_restrictpurch',
2364                                                         'type': 'int'
2365                                                     },
2366                                                     {
2367                                                         'name': 'recv_vend_id_vend_edicc',
2368                                                         'type': 'string'
2369                                                     },
2370                                                     {
2371                                                         'name': 'recv_vend_id_vend_curr_id',
2372                                                         'type': 'int'
2373                                                     },
2374                                                     {
2375                                                         'name': 'recv_vend_id_vend_cntct1_id',
2376                                                         'type': 'int'
2377                                                     },
2378                                                     {
2379                                                         'name': 'recv_vend_id_vend_cntct2_id',
2380                                                         'type': 'int'
2381                                                     },
2382                                                     {
2383                                                         'name': 'recv_vend_id_vend_addr_id',
2384                                                         'type': 'int'
2385                                                     },
2386                                                     {
2387                                                         'name': 'recv_vend_id_vend_match',
2388                                                         'type': 'int'
2389                                                     },
2390                                                     {
2391                                                         'name': 'recv_vend_id_vend_ach_enabled',
2392                                                         'type': 'int'
2393                                                     },
2394                                                     {
2395                                                         'name': 'recv_vend_id_vend_ach_accnttype',
2396                                                         'type': 'string'
2397                                                     },
2398                                                     {
2399                                                         'name': 'recv_vend_id_vend_ach_use_vendinfo',
2400                                                         'type': 'int'
2401                                                     },
2402                                                     {
2403                                                         'name': 'recv_vend_id_vend_ach_indiv_number',
2404                                                         'type': 'string'
2405                                                     },
2406                                                     {
2407                                                         'name': 'recv_vend_id_vend_ach_indiv_name',
2408                                                         'type': 'string'
2409                                                     },
2410                                                     {
2411                                                         'name': 'recv_vend_id_vend_ediemailhtml',
2412                                                         'type': 'int'
2413                                                     },
2414                                                     {
2415                                                         'name': 'recv_vend_id_vend_ach_routingnumber',
2416                                                         'type': 'text'
2417                                                     },
2418                                                     {
2419                                                         'name': 'recv_vend_id_vend_ach_accntnumber',
2420                                                         'type': 'text'
2421                                                     },
2422                                                     {
2423                                                         'name': 'recv_vend_id_vend_taxzone_id',
2424                                                         'type': 'int'
2425                                                     },
2426                                                     {
2427                                                         'name': 'recv_splitfrom_id_recv_id',
2428                                                         'type': 'int'
2429                                                     },
2430                                                     {
2431                                                         'name': 'recv_splitfrom_id_recv_order_type',
2432                                                         'type': 'string'
2433                                                     },
2434                                                     {
2435                                                         'name': 'recv_splitfrom_id_recv_order_number',
2436                                                         'type': 'string'
2437                                                     },
2438                                                     {
2439                                                         'name': 'recv_splitfrom_id_recv_orderitem_id',
2440                                                         'type': 'int'
2441                                                     },
2442                                                     {
2443                                                         'name': 'recv_splitfrom_id_recv_agent_username',
2444                                                         'type': 'string'
2445                                                     },
2446                                                     {
2447                                                         'name': 'recv_splitfrom_id_recv_itemsite_id',
2448                                                         'type': 'int'
2449                                                     },
2450                                                     {
2451                                                         'name': 'recv_splitfrom_id_recv_vend_id',
2452                                                         'type': 'int'
2453                                                     },
2454                                                     {
2455                                                         'name': 'recv_splitfrom_id_recv_vend_item_number',
2456                                                         'type': 'string'
2457                                                     },
2458                                                     {
2459                                                         'name': 'recv_splitfrom_id_recv_vend_item_descrip',
2460                                                         'type': 'string'
2461                                                     },
2462                                                     {
2463                                                         'name': 'recv_splitfrom_id_recv_vend_uom',
2464                                                         'type': 'string'
2465                                                     },
2466                                                     {
2467                                                         'name': 'recv_splitfrom_id_recv_purchcost',
2468                                                         'type': 'float'
2469                                                     },
2470                                                     {
2471                                                         'name': 'recv_splitfrom_id_recv_purchcost_curr_id',
2472                                                         'type': 'int'
2473                                                     },
2474                                                     {
2475                                                         'name': 'recv_splitfrom_id_recv_duedate',
2476                                                         'type': 'date'
2477                                                     },
2478                                                     {
2479                                                         'name': 'recv_splitfrom_id_recv_qty',
2480                                                         'type': 'float'
2481                                                     },
2482                                                     {
2483                                                         'name': 'recv_splitfrom_id_recv_recvcost',
2484                                                         'type': 'float'
2485                                                     },
2486                                                     {
2487                                                         'name': 'recv_splitfrom_id_recv_recvcost_curr_id',
2488                                                         'type': 'int'
2489                                                     },
2490                                                     {
2491                                                         'name': 'recv_splitfrom_id_recv_freight',
2492                                                         'type': 'float'
2493                                                     },
2494                                                     {
2495                                                         'name': 'recv_splitfrom_id_recv_freight_curr_id',
2496                                                         'type': 'int'
2497                                                     },
2498                                                     {
2499                                                         'name': 'recv_splitfrom_id_recv_date',
2500                                                         'type': 'date'
2501                                                     },
2502                                                     {
2503                                                         'name': 'recv_splitfrom_id_recv_value',
2504                                                         'type': 'float'
2505                                                     },
2506                                                     {
2507                                                         'name': 'recv_splitfrom_id_recv_posted',
2508                                                         'type': 'int'
2509                                                     },
2510                                                     {
2511                                                         'name': 'recv_splitfrom_id_recv_invoiced',
2512                                                         'type': 'int'
2513                                                     },
2514                                                     {
2515                                                         'name': 'recv_splitfrom_id_recv_vohead_id',
2516                                                         'type': 'int'
2517                                                     },
2518                                                     {
2519                                                         'name': 'recv_splitfrom_id_recv_voitem_id',
2520                                                         'type': 'int'
2521                                                     },
2522                                                     {
2523                                                         'name': 'recv_splitfrom_id_recv_trans_usr_name',
2524                                                         'type': 'string'
2525                                                     },
2526                                                     {
2527                                                         'name': 'recv_splitfrom_id_recv_notes',
2528                                                         'type': 'string'
2529                                                     },
2530                                                     {
2531                                                         'name': 'recv_splitfrom_id_recv_gldistdate',
2532                                                         'type': 'date'
2533                                                     },
2534                                                     {
2535                                                         'name': 'recv_splitfrom_id_recv_splitfrom_id',
2536                                                         'type': 'int'
2537                                                     },
2538                                                     {
2539                                                         'name': 'recv_splitfrom_id_recv_rlsd_duedate',
2540                                                         'type': 'date'
2541                                                     },
2542                                                     {
2543                                                         'name': 'recv_recvcost_curr_id_curr_id',
2544                                                         'type': 'int'
2545                                                     },
2546                                                     {
2547                                                         'name': 'recv_recvcost_curr_id_curr_base',
2548                                                         'type': 'int'
2549                                                     },
2550                                                     {
2551                                                         'name': 'recv_recvcost_curr_id_curr_name',
2552                                                         'type': 'string'
2553                                                     },
2554                                                     {
2555                                                         'name': 'recv_recvcost_curr_id_curr_symbol',
2556                                                         'type': 'string'
2557                                                     },
2558                                                     {
2559                                                         'name': 'recv_recvcost_curr_id_curr_abbr',
2560                                                         'type': 'string'
2561                                                     },
2562                                                     {
2563                                                         'name': 'recv_purchcost_curr_id_curr_id',
2564                                                         'type': 'int'
2565                                                     },
2566                                                     {
2567                                                         'name': 'recv_purchcost_curr_id_curr_base',
2568                                                         'type': 'int'
2569                                                     },
2570                                                     {
2571                                                         'name': 'recv_purchcost_curr_id_curr_name',
2572                                                         'type': 'string'
2573                                                     },
2574                                                     {
2575                                                         'name': 'recv_purchcost_curr_id_curr_symbol',
2576                                                         'type': 'string'
2577                                                     },
2578                                                     {
2579                                                         'name': 'recv_purchcost_curr_id_curr_abbr',
2580                                                         'type': 'string'
2581                                                     },
2582                                                     {
2583                                                         'name': 'recv_itemsite_id_itemsite_id',
2584                                                         'type': 'int'
2585                                                     },
2586                                                     {
2587                                                         'name': 'recv_itemsite_id_itemsite_item_id',
2588                                                         'type': 'int'
2589                                                     },
2590                                                     {
2591                                                         'name': 'recv_itemsite_id_itemsite_warehous_id',
2592                                                         'type': 'int'
2593                                                     },
2594                                                     {
2595                                                         'name': 'recv_itemsite_id_itemsite_qtyonhand',
2596                                                         'type': 'float'
2597                                                     },
2598                                                     {
2599                                                         'name': 'recv_itemsite_id_itemsite_reorderlevel',
2600                                                         'type': 'float'
2601                                                     },
2602                                                     {
2603                                                         'name': 'recv_itemsite_id_itemsite_ordertoqty',
2604                                                         'type': 'float'
2605                                                     },
2606                                                     {
2607                                                         'name': 'recv_itemsite_id_itemsite_cyclecountfreq',
2608                                                         'type': 'int'
2609                                                     },
2610                                                     {
2611                                                         'name': 'recv_itemsite_id_itemsite_datelastcount',
2612                                                         'type': 'date'
2613                                                     },
2614                                                     {
2615                                                         'name': 'recv_itemsite_id_itemsite_datelastused',
2616                                                         'type': 'date'
2617                                                     },
2618                                                     {
2619                                                         'name': 'recv_itemsite_id_itemsite_loccntrl',
2620                                                         'type': 'int'
2621                                                     },
2622                                                     {
2623                                                         'name': 'recv_itemsite_id_itemsite_safetystock',
2624                                                         'type': 'float'
2625                                                     },
2626                                                     {
2627                                                         'name': 'recv_itemsite_id_itemsite_minordqty',
2628                                                         'type': 'float'
2629                                                     },
2630                                                     {
2631                                                         'name': 'recv_itemsite_id_itemsite_multordqty',
2632                                                         'type': 'float'
2633                                                     },
2634                                                     {
2635                                                         'name': 'recv_itemsite_id_itemsite_leadtime',
2636                                                         'type': 'int'
2637                                                     },
2638                                                     {
2639                                                         'name': 'recv_itemsite_id_itemsite_abcclass',
2640                                                         'type': 'string'
2641                                                     },
2642                                                     {
2643                                                         'name': 'recv_itemsite_id_itemsite_issuemethod',
2644                                                         'type': 'string'
2645                                                     },
2646                                                     {
2647                                                         'name': 'recv_itemsite_id_itemsite_controlmethod',
2648                                                         'type': 'string'
2649                                                     },
2650                                                     {
2651                                                         'name': 'recv_itemsite_id_itemsite_active',
2652                                                         'type': 'int'
2653                                                     },
2654                                                     {
2655                                                         'name': 'recv_itemsite_id_itemsite_plancode_id',
2656                                                         'type': 'int'
2657                                                     },
2658                                                     {
2659                                                         'name': 'recv_itemsite_id_itemsite_costcat_id',
2660                                                         'type': 'int'
2661                                                     },
2662                                                     {
2663                                                         'name': 'recv_itemsite_id_itemsite_eventfence',
2664                                                         'type': 'int'
2665                                                     },
2666                                                     {
2667                                                         'name': 'recv_itemsite_id_itemsite_sold',
2668                                                         'type': 'int'
2669                                                     },
2670                                                     {
2671                                                         'name': 'recv_itemsite_id_itemsite_stocked',
2672                                                         'type': 'int'
2673                                                     },
2674                                                     {
2675                                                         'name': 'recv_itemsite_id_itemsite_freeze',
2676                                                         'type': 'int'
2677                                                     },
2678                                                     {
2679                                                         'name': 'recv_itemsite_id_itemsite_location_id',
2680                                                         'type': 'int'
2681                                                     },
2682                                                     {
2683                                                         'name': 'recv_itemsite_id_itemsite_useparams',
2684                                                         'type': 'int'
2685                                                     },
2686                                                     {
2687                                                         'name': 'recv_itemsite_id_itemsite_useparamsmanual',
2688                                                         'type': 'int'
2689                                                     },
2690                                                     {
2691                                                         'name': 'recv_itemsite_id_itemsite_soldranking',
2692                                                         'type': 'int'
2693                                                     },
2694                                                     {
2695                                                         'name': 'recv_itemsite_id_itemsite_createpr',
2696                                                         'type': 'int'
2697                                                     },
2698                                                     {
2699                                                         'name': 'recv_itemsite_id_itemsite_location',
2700                                                         'type': 'string'
2701                                                     },
2702                                                     {
2703                                                         'name': 'recv_itemsite_id_itemsite_location_comments',
2704                                                         'type': 'string'
2705                                                     },
2706                                                     {
2707                                                         'name': 'recv_itemsite_id_itemsite_notes',
2708                                                         'type': 'string'
2709                                                     },
2710                                                     {
2711                                                         'name': 'recv_itemsite_id_itemsite_perishable',
2712                                                         'type': 'int'
2713                                                     },
2714                                                     {
2715                                                         'name': 'recv_itemsite_id_itemsite_nnqoh',
2716                                                         'type': 'float'
2717                                                     },
2718                                                     {
2719                                                         'name': 'recv_itemsite_id_itemsite_autoabcclass',
2720                                                         'type': 'int'
2721                                                     },
2722                                                     {
2723                                                         'name': 'recv_itemsite_id_itemsite_ordergroup',
2724                                                         'type': 'int'
2725                                                     },
2726                                                     {
2727                                                         'name': 'recv_itemsite_id_itemsite_disallowblankwip',
2728                                                         'type': 'int'
2729                                                     },
2730                                                     {
2731                                                         'name': 'recv_itemsite_id_itemsite_maxordqty',
2732                                                         'type': 'float'
2733                                                     },
2734                                                     {
2735                                                         'name': 'recv_itemsite_id_itemsite_mps_timefence',
2736                                                         'type': 'int'
2737                                                     },
2738                                                     {
2739                                                         'name': 'recv_itemsite_id_itemsite_createwo',
2740                                                         'type': 'int'
2741                                                     },
2742                                                     {
2743                                                         'name': 'recv_itemsite_id_itemsite_warrpurc',
2744                                                         'type': 'int'
2745                                                     },
2746                                                     {
2747                                                         'name': 'recv_itemsite_id_itemsite_autoreg',
2748                                                         'type': 'int'
2749                                                     },
2750                                                     {
2751                                                         'name': 'recv_itemsite_id_itemsite_costmethod',
2752                                                         'type': 'string'
2753                                                     },
2754                                                     {
2755                                                         'name': 'recv_itemsite_id_itemsite_value',
2756                                                         'type': 'float'
2757                                                     },
2758                                                     {
2759                                                         'name': 'recv_itemsite_id_itemsite_ordergroup_first',
2760                                                         'type': 'int'
2761                                                     },
2762                                                     {
2763                                                         'name': 'recv_itemsite_id_itemsite_supply_itemsite_id',
2764                                                         'type': 'int'
2765                                                     },
2766                                                     {
2767                                                         'name': 'recv_itemsite_id_itemsite_planning_type',
2768                                                         'type': 'string'
2769                                                     },
2770                                                     {
2771                                                         'name': 'recv_itemsite_id_itemsite_wosupply',
2772                                                         'type': 'int'
2773                                                     },
2774                                                     {
2775                                                         'name': 'recv_itemsite_id_itemsite_posupply',
2776                                                         'type': 'int'
2777                                                     },
2778                                                     {
2779                                                         'name': 'recv_itemsite_id_itemsite_lsseq_id',
2780                                                         'type': 'int'
2781                                                     },
2782                                                     {
2783                                                         'name': 'recv_itemsite_id_itemsite_cosdefault',
2784                                                         'type': 'string'
2785                                                     },
2786                                                     {
2787                                                         'name': 'recv_itemsite_id_itemsite_createsopr',
2788                                                         'type': 'int'
2789                                                     },
2790                                                     {
2791                                                         'name': 'recv_itemsite_id_itemsite_createsopo',
2792                                                         'type': 'int'
2793                                                     },
2794                                                     {
2795                                                         'name': 'recv_itemsite_id_itemsite_dropship',
2796                                                         'type': 'int'
2797                                                     },
2798                                                     {
2799                                                         'name': 'recv_freight_curr_id_curr_id',
2800                                                         'type': 'int'
2801                                                     },
2802                                                     {
2803                                                         'name': 'recv_freight_curr_id_curr_base',
2804                                                         'type': 'int'
2805                                                     },
2806                                                     {
2807                                                         'name': 'recv_freight_curr_id_curr_name',
2808                                                         'type': 'string'
2809                                                     },
2810                                                     {
2811                                                         'name': 'recv_freight_curr_id_curr_symbol',
2812                                                         'type': 'string'
2813                                                     },
2814                                                     {
2815                                                         'name': 'recv_freight_curr_id_curr_abbr',
2816                                                         'type': 'string'
2817                                                     }
2818                                                 ]
2819                                             }
2820                                         },
2821                                         toolbar : {
2822                                             xtype: 'Toolbar',
2823                                             xns: Roo,
2824                                             items : [
2825                                                 {
2826                                                     xtype: 'Button',
2827                                                     xns: Roo.Toolbar,
2828                                                     listeners : {
2829                                                         click : function (_self, e)
2830                                                         {
2831
2832                                                            var sel =  _this.rggrid.selModel.getSelected();
2833                                                            if (!sel) {
2834                                                                 Roo.MessageBox.alert("Error", "Select Item receipt");
2835                                                                 return;
2836                                                             }
2837
2838
2839
2840                                                             Pman.Dialog.XtupleTransfer.show({ createFromRev : sel.data.recvgrp_id },
2841                                                                 function() {
2842                                                                     _this.grid.ds.load({});
2843                                                                 }
2844                                                                 );
2845                                                         }
2846                                                     },
2847                                                     cls : 'x-btn-text-icon',
2848                                                     hidden : true,
2849                                                     text : "Create Transfer",
2850                                                     icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
2851                                                 },
2852                                                 {
2853                                                     xtype: 'Fill',
2854                                                     xns: Roo.Toolbar
2855                                                 },
2856                                                 {
2857                                                     xtype: 'Button',
2858                                                     xns: Roo.Toolbar,
2859                                                     listeners : {
2860                                                         click : function()
2861                                                         {
2862                                                              var s  = _this.grid.selModel.getSelected();
2863                                                              if (!s) {
2864                                                                 Roo.MessageBox.alert("Error", "Select a purchase order");
2865                                                                 return
2866                                                             }
2867                                                             Pman.Dialog.XtupleRecvGrp.show( {
2868                                                                  recvgrp_pohead_id : s.data.pohead_id ,
2869                                                                  recvgrp_pohead_id_pohead_number : s.data.pohead_number
2870                                                              } , function() {
2871                                                                 _this.grid.footer.onClick('refresh');
2872                                                            });
2873                                                         }
2874                                                     },
2875                                                     cls : 'x-btn-text-icon',
2876                                                     text : "Add Receipt",
2877                                                     icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
2878                                                 }
2879                                             ]
2880                                         },
2881                                         colModel : [
2882                                             {
2883                                                 xtype: 'ColumnModel',
2884                                                 xns: Roo.grid,
2885                                                 dataIndex : 'recvgrp_number',
2886                                                 header : 'ref#',
2887                                                 width : 120,
2888                                                 renderer : function(v,x,r) {
2889                                                     var vv =v;
2890                                                     var nn  = '';
2891                                                     if (vv.indexOf(',') > -1) {
2892                                                         vv = vv.split(',').shift();
2893
2894                                                     }
2895                                                     if (vv.match(/^NSPO-/)) {
2896                                                         vv = vv.replace(/^NSPO-/, '');
2897                                                         nn = 'ns:&nbsp;';
2898                                                     }
2899
2900                                                     var format = '<i>'+ nn +'</i><b qtip="{1}">{0}</b>';
2901                                                     if (r.data.recvgrp_void *1) {
2902                                                         format = '<s>'  + format + '</s>';
2903                                                     }
2904                                                     return String.format(format, vv,v);
2905
2906
2907                                                  }
2908                                             },
2909                                             {
2910                                                 xtype: 'ColumnModel',
2911                                                 xns: Roo.grid,
2912                                                 dataIndex : 'recvgrp_location_id_location_name',
2913                                                 header : 'To',
2914                                                 width : 80,
2915                                                 renderer : function(v,x,r) {
2916
2917                                                     return String.format('{0}',  v);
2918
2919
2920                                                  }
2921                                             },
2922                                             {
2923                                                 xtype: 'ColumnModel',
2924                                                 xns: Roo.grid,
2925                                                 align : 'right',
2926                                                 dataIndex : 'recvgrp_date',
2927                                                 header : 'Date',
2928                                                 width : 75,
2929                                                 renderer : function(v) { return v ? v.format('d/M/Y')  : ''; }
2930                                             },
2931                                             {
2932                                                 xtype: 'ColumnModel',
2933                                                 xns: Roo.grid,
2934                                                 align : 'right',
2935                                                 dataIndex : 'total_landed_cost',
2936                                                 header : 'Landed Cost',
2937                                                 width : 80,
2938                                                 renderer : function(v,x,r) {
2939                                                     return String.format('{1}{0}', v, r.data.base_curr_symbol);
2940                                                 }
2941                                             }
2942                                         ]
2943                                     }
2944                                 },
2945                                 {
2946                                     xtype: 'GridPanel',
2947                                     xns: Roo,
2948                                     listeners : {
2949                                         activate : function() {
2950                                             _this.rpanel = this;
2951                                             if (_this.rgrid) {
2952                                                 _this.rgrid.footer.onClick('first');
2953                                             }
2954                                         }
2955                                     },
2956                                     background : true,
2957                                     fitContainer : true,
2958                                     fitToframe : false,
2959                                     region : 'south',
2960                                     tableName : 'poitem',
2961                                     title : "Items",
2962                                     grid : {
2963                                         xtype: 'Grid',
2964                                         xns: Roo.grid,
2965                                         listeners : {
2966                                             render : function()
2967                                             {
2968                                                 _this.rgrid = this;
2969                                                 //_this.dialog = Pman.Dialog.FILL_IN
2970                                                 if (_this.rpanel.active) {
2971                                                    this.footer.onClick('first');
2972                                                 }
2973                                             }
2974                                         },
2975                                         autoExpandColumn : 'item_number',
2976                                         loadMask : true,
2977                                         dataSource : {
2978                                             xtype: 'Store',
2979                                             xns: Roo.data,
2980                                             listeners : {
2981                                                 beforeload : function (_self, options)
2982                                                 {
2983                                                     if (!_this.grid || !_this.grid.selModel.getSelectedCell()) {
2984                                                         return false;
2985                                                     }
2986
2987                                                     var c = _this.grid.selModel.getSelectedCell();
2988
2989                                                     var r = _this.grid.ds.getAt(c[0]);
2990
2991                                                     options.params.poitem_pohead_id = r.data.pohead_id;
2992
2993                                                     var rr = _this.rggrid.selModel.getSelected();
2994
2995                                                     options.params.recvgrp_id = 0;
2996                                                     if (rr) {
2997                                                         options.params.recvgrp_id = rr.data.recvgrp_id;
2998                                                     }
2999
3000                                                     options.params._with_item  = 1;
3001                                                     options.params.item_type = 'P';
3002                                                 }
3003                                             },
3004                                             remoteSort : true,
3005                                             sortInfo : { field : 'recv_order_type', direction: 'ASC' },
3006                                             proxy : {
3007                                                 xtype: 'HttpProxy',
3008                                                 xns: Roo.data,
3009                                                 method : 'GET',
3010                                                 url : baseURL + '/Roo/poitem.php'
3011                                             },
3012                                             reader : {
3013                                                 xtype: 'JsonReader',
3014                                                 xns: Roo.data,
3015                                                 totalProperty : 'total',
3016                                                 root : 'data',
3017                                                 id : 'id',
3018                                                 fields : [
3019                                                     {
3020                                                         'name': 'recv_id',
3021                                                         'type': 'int'
3022                                                     },
3023                                                     {
3024                                                         'name': 'recv_order_type',
3025                                                         'type': 'string'
3026                                                     },
3027                                                     {
3028                                                         'name': 'recv_order_number',
3029                                                         'type': 'string'
3030                                                     },
3031                                                     {
3032                                                         'name': 'recv_orderitem_id',
3033                                                         'type': 'int'
3034                                                     },
3035                                                     {
3036                                                         'name': 'recv_agent_username',
3037                                                         'type': 'string'
3038                                                     },
3039                                                     {
3040                                                         'name': 'recv_itemsite_id',
3041                                                         'type': 'int'
3042                                                     },
3043                                                     {
3044                                                         'name': 'recv_vend_id',
3045                                                         'type': 'int'
3046                                                     },
3047                                                     {
3048                                                         'name': 'recv_vend_item_number',
3049                                                         'type': 'string'
3050                                                     },
3051                                                     {
3052                                                         'name': 'recv_vend_item_descrip',
3053                                                         'type': 'string'
3054                                                     },
3055                                                     {
3056                                                         'name': 'recv_vend_uom',
3057                                                         'type': 'string'
3058                                                     },
3059                                                     {
3060                                                         'name': 'recv_purchcost',
3061                                                         'type': 'float'
3062                                                     },
3063                                                     {
3064                                                         'name': 'recv_purchcost_curr_id',
3065                                                         'type': 'int'
3066                                                     },
3067                                                     {
3068                                                         'name': 'recv_duedate',
3069                                                         'type': 'date',
3070                                                         'dateFormat': 'Y-m-d'
3071                                                     },
3072                                                     {
3073                                                         'name': 'recv_qty',
3074                                                         'type': 'float'
3075                                                     },
3076                                                     {
3077                                                         'name': 'recv_recvcost',
3078                                                         'type': 'float'
3079                                                     },
3080                                                     {
3081                                                         'name': 'recv_recvcost_curr_id',
3082                                                         'type': 'int'
3083                                                     },
3084                                                     {
3085                                                         'name': 'recv_freight',
3086                                                         'type': 'float'
3087                                                     },
3088                                                     {
3089                                                         'name': 'recv_freight_curr_id',
3090                                                         'type': 'int'
3091                                                     },
3092                                                     {
3093                                                         'name': 'recv_date',
3094                                                         'type': 'date',
3095                                                         'dateFormat': 'Y-m-d'
3096                                                     },
3097                                                     {
3098                                                         'name': 'recv_value',
3099                                                         'type': 'float'
3100                                                     },
3101                                                     {
3102                                                         'name': 'recv_posted',
3103                                                         'type': 'int'
3104                                                     },
3105                                                     {
3106                                                         'name': 'recv_invoiced',
3107                                                         'type': 'int'
3108                                                     },
3109                                                     {
3110                                                         'name': 'recv_vohead_id',
3111                                                         'type': 'int'
3112                                                     },
3113                                                     {
3114                                                         'name': 'recv_voitem_id',
3115                                                         'type': 'int'
3116                                                     },
3117                                                     {
3118                                                         'name': 'recv_trans_usr_name',
3119                                                         'type': 'string'
3120                                                     },
3121                                                     {
3122                                                         'name': 'recv_notes',
3123                                                         'type': 'string'
3124                                                     },
3125                                                     {
3126                                                         'name': 'recv_gldistdate',
3127                                                         'type': 'date',
3128                                                         'dateFormat': 'Y-m-d'
3129                                                     },
3130                                                     {
3131                                                         'name': 'recv_splitfrom_id',
3132                                                         'type': 'int'
3133                                                     },
3134                                                     {
3135                                                         'name': 'recv_rlsd_duedate',
3136                                                         'type': 'date',
3137                                                         'dateFormat': 'Y-m-d'
3138                                                     },
3139                                                     {
3140                                                         'name': 'recv_voitem_id_voitem_id',
3141                                                         'type': 'int'
3142                                                     },
3143                                                     {
3144                                                         'name': 'recv_voitem_id_voitem_vohead_id',
3145                                                         'type': 'int'
3146                                                     },
3147                                                     {
3148                                                         'name': 'recv_voitem_id_voitem_poitem_id',
3149                                                         'type': 'int'
3150                                                     },
3151                                                     {
3152                                                         'name': 'recv_voitem_id_voitem_close',
3153                                                         'type': 'int'
3154                                                     },
3155                                                     {
3156                                                         'name': 'recv_voitem_id_voitem_qty',
3157                                                         'type': 'float'
3158                                                     },
3159                                                     {
3160                                                         'name': 'recv_voitem_id_voitem_freight',
3161                                                         'type': 'float'
3162                                                     },
3163                                                     {
3164                                                         'name': 'recv_voitem_id_voitem_taxtype_id',
3165                                                         'type': 'int'
3166                                                     },
3167                                                     {
3168                                                         'name': 'recv_vohead_id_vohead_id',
3169                                                         'type': 'int'
3170                                                     },
3171                                                     {
3172                                                         'name': 'recv_vohead_id_vohead_number',
3173                                                         'type': 'string'
3174                                                     },
3175                                                     {
3176                                                         'name': 'recv_vohead_id_vohead_pohead_id',
3177                                                         'type': 'int'
3178                                                     },
3179                                                     {
3180                                                         'name': 'recv_vohead_id_vohead_posted',
3181                                                         'type': 'int'
3182                                                     },
3183                                                     {
3184                                                         'name': 'recv_vohead_id_vohead_duedate',
3185                                                         'type': 'date'
3186                                                     },
3187                                                     {
3188                                                         'name': 'recv_vohead_id_vohead_invcnumber',
3189                                                         'type': 'string'
3190                                                     },
3191                                                     {
3192                                                         'name': 'recv_vohead_id_vohead_amount',
3193                                                         'type': 'float'
3194                                                     },
3195                                                     {
3196                                                         'name': 'recv_vohead_id_vohead_docdate',
3197                                                         'type': 'date'
3198                                                     },
3199                                                     {
3200                                                         'name': 'recv_vohead_id_vohead_1099',
3201                                                         'type': 'int'
3202                                                     },
3203                                                     {
3204                                                         'name': 'recv_vohead_id_vohead_distdate',
3205                                                         'type': 'date'
3206                                                     },
3207                                                     {
3208                                                         'name': 'recv_vohead_id_vohead_reference',
3209                                                         'type': 'string'
3210                                                     },
3211                                                     {
3212                                                         'name': 'recv_vohead_id_vohead_terms_id',
3213                                                         'type': 'int'
3214                                                     },
3215                                                     {
3216                                                         'name': 'recv_vohead_id_vohead_vend_id',
3217                                                         'type': 'int'
3218                                                     },
3219                                                     {
3220                                                         'name': 'recv_vohead_id_vohead_curr_id',
3221                                                         'type': 'int'
3222                                                     },
3223                                                     {
3224                                                         'name': 'recv_vohead_id_vohead_adjtaxtype_id',
3225                                                         'type': 'int'
3226                                                     },
3227                                                     {
3228                                                         'name': 'recv_vohead_id_vohead_freighttaxtype_id',
3229                                                         'type': 'int'
3230                                                     },
3231                                                     {
3232                                                         'name': 'recv_vohead_id_vohead_gldistdate',
3233                                                         'type': 'date'
3234                                                     },
3235                                                     {
3236                                                         'name': 'recv_vohead_id_vohead_misc',
3237                                                         'type': 'int'
3238                                                     },
3239                                                     {
3240                                                         'name': 'recv_vohead_id_vohead_taxzone_id',
3241                                                         'type': 'int'
3242                                                     },
3243                                                     {
3244                                                         'name': 'recv_vohead_id_vohead_taxtype_id',
3245                                                         'type': 'int'
3246                                                     },
3247                                                     {
3248                                                         'name': 'recv_vohead_id_vohead_notes',
3249                                                         'type': 'string'
3250                                                     },
3251                                                     {
3252                                                         'name': 'recv_vend_id_vend_id',
3253                                                         'type': 'int'
3254                                                     },
3255                                                     {
3256                                                         'name': 'recv_vend_id_vend_name',
3257                                                         'type': 'string'
3258                                                     },
3259                                                     {
3260                                                         'name': 'recv_vend_id_vend_lastpurchdate',
3261                                                         'type': 'date'
3262                                                     },
3263                                                     {
3264                                                         'name': 'recv_vend_id_vend_active',
3265                                                         'type': 'int'
3266                                                     },
3267                                                     {
3268                                                         'name': 'recv_vend_id_vend_po',
3269                                                         'type': 'int'
3270                                                     },
3271                                                     {
3272                                                         'name': 'recv_vend_id_vend_comments',
3273                                                         'type': 'string'
3274                                                     },
3275                                                     {
3276                                                         'name': 'recv_vend_id_vend_pocomments',
3277                                                         'type': 'string'
3278                                                     },
3279                                                     {
3280                                                         'name': 'recv_vend_id_vend_number',
3281                                                         'type': 'string'
3282                                                     },
3283                                                     {
3284                                                         'name': 'recv_vend_id_vend_1099',
3285                                                         'type': 'int'
3286                                                     },
3287                                                     {
3288                                                         'name': 'recv_vend_id_vend_exported',
3289                                                         'type': 'int'
3290                                                     },
3291                                                     {
3292                                                         'name': 'recv_vend_id_vend_fobsource',
3293                                                         'type': 'string'
3294                                                     },
3295                                                     {
3296                                                         'name': 'recv_vend_id_vend_fob',
3297                                                         'type': 'string'
3298                                                     },
3299                                                     {
3300                                                         'name': 'recv_vend_id_vend_terms_id',
3301                                                         'type': 'int'
3302                                                     },
3303                                                     {
3304                                                         'name': 'recv_vend_id_vend_shipvia',
3305                                                         'type': 'string'
3306                                                     },
3307                                                     {
3308                                                         'name': 'recv_vend_id_vend_vendtype_id',
3309                                                         'type': 'int'
3310                                                     },
3311                                                     {
3312                                                         'name': 'recv_vend_id_vend_qualified',
3313                                                         'type': 'int'
3314                                                     },
3315                                                     {
3316                                                         'name': 'recv_vend_id_vend_ediemail',
3317                                                         'type': 'string'
3318                                                     },
3319                                                     {
3320                                                         'name': 'recv_vend_id_vend_ediemailbody',
3321                                                         'type': 'string'
3322                                                     },
3323                                                     {
3324                                                         'name': 'recv_vend_id_vend_edisubject',
3325                                                         'type': 'string'
3326                                                     },
3327                                                     {
3328                                                         'name': 'recv_vend_id_vend_edifilename',
3329                                                         'type': 'string'
3330                                                     },
3331                                                     {
3332                                                         'name': 'recv_vend_id_vend_accntnum',
3333                                                         'type': 'string'
3334                                                     },
3335                                                     {
3336                                                         'name': 'recv_vend_id_vend_emailpodelivery',
3337                                                         'type': 'int'
3338                                                     },
3339                                                     {
3340                                                         'name': 'recv_vend_id_vend_restrictpurch',
3341                                                         'type': 'int'
3342                                                     },
3343                                                     {
3344                                                         'name': 'recv_vend_id_vend_edicc',
3345                                                         'type': 'string'
3346                                                     },
3347                                                     {
3348                                                         'name': 'recv_vend_id_vend_curr_id',
3349                                                         'type': 'int'
3350                                                     },
3351                                                     {
3352                                                         'name': 'recv_vend_id_vend_cntct1_id',
3353                                                         'type': 'int'
3354                                                     },
3355                                                     {
3356                                                         'name': 'recv_vend_id_vend_cntct2_id',
3357                                                         'type': 'int'
3358                                                     },
3359                                                     {
3360                                                         'name': 'recv_vend_id_vend_addr_id',
3361                                                         'type': 'int'
3362                                                     },
3363                                                     {
3364                                                         'name': 'recv_vend_id_vend_match',
3365                                                         'type': 'int'
3366                                                     },
3367                                                     {
3368                                                         'name': 'recv_vend_id_vend_ach_enabled',
3369                                                         'type': 'int'
3370                                                     },
3371                                                     {
3372                                                         'name': 'recv_vend_id_vend_ach_accnttype',
3373                                                         'type': 'string'
3374                                                     },
3375                                                     {
3376                                                         'name': 'recv_vend_id_vend_ach_use_vendinfo',
3377                                                         'type': 'int'
3378                                                     },
3379                                                     {
3380                                                         'name': 'recv_vend_id_vend_ach_indiv_number',
3381                                                         'type': 'string'
3382                                                     },
3383                                                     {
3384                                                         'name': 'recv_vend_id_vend_ach_indiv_name',
3385                                                         'type': 'string'
3386                                                     },
3387                                                     {
3388                                                         'name': 'recv_vend_id_vend_ediemailhtml',
3389                                                         'type': 'int'
3390                                                     },
3391                                                     {
3392                                                         'name': 'recv_vend_id_vend_ach_routingnumber',
3393                                                         'type': 'text'
3394                                                     },
3395                                                     {
3396                                                         'name': 'recv_vend_id_vend_ach_accntnumber',
3397                                                         'type': 'text'
3398                                                     },
3399                                                     {
3400                                                         'name': 'recv_vend_id_vend_taxzone_id',
3401                                                         'type': 'int'
3402                                                     },
3403                                                     {
3404                                                         'name': 'recv_splitfrom_id_recv_id',
3405                                                         'type': 'int'
3406                                                     },
3407                                                     {
3408                                                         'name': 'recv_splitfrom_id_recv_order_type',
3409                                                         'type': 'string'
3410                                                     },
3411                                                     {
3412                                                         'name': 'recv_splitfrom_id_recv_order_number',
3413                                                         'type': 'string'
3414                                                     },
3415                                                     {
3416                                                         'name': 'recv_splitfrom_id_recv_orderitem_id',
3417                                                         'type': 'int'
3418                                                     },
3419                                                     {
3420                                                         'name': 'recv_splitfrom_id_recv_agent_username',
3421                                                         'type': 'string'
3422                                                     },
3423                                                     {
3424                                                         'name': 'recv_splitfrom_id_recv_itemsite_id',
3425                                                         'type': 'int'
3426                                                     },
3427                                                     {
3428                                                         'name': 'recv_splitfrom_id_recv_vend_id',
3429                                                         'type': 'int'
3430                                                     },
3431                                                     {
3432                                                         'name': 'recv_splitfrom_id_recv_vend_item_number',
3433                                                         'type': 'string'
3434                                                     },
3435                                                     {
3436                                                         'name': 'recv_splitfrom_id_recv_vend_item_descrip',
3437                                                         'type': 'string'
3438                                                     },
3439                                                     {
3440                                                         'name': 'recv_splitfrom_id_recv_vend_uom',
3441                                                         'type': 'string'
3442                                                     },
3443                                                     {
3444                                                         'name': 'recv_splitfrom_id_recv_purchcost',
3445                                                         'type': 'float'
3446                                                     },
3447                                                     {
3448                                                         'name': 'recv_splitfrom_id_recv_purchcost_curr_id',
3449                                                         'type': 'int'
3450                                                     },
3451                                                     {
3452                                                         'name': 'recv_splitfrom_id_recv_duedate',
3453                                                         'type': 'date'
3454                                                     },
3455                                                     {
3456                                                         'name': 'recv_splitfrom_id_recv_qty',
3457                                                         'type': 'float'
3458                                                     },
3459                                                     {
3460                                                         'name': 'recv_splitfrom_id_recv_recvcost',
3461                                                         'type': 'float'
3462                                                     },
3463                                                     {
3464                                                         'name': 'recv_splitfrom_id_recv_recvcost_curr_id',
3465                                                         'type': 'int'
3466                                                     },
3467                                                     {
3468                                                         'name': 'recv_splitfrom_id_recv_freight',
3469                                                         'type': 'float'
3470                                                     },
3471                                                     {
3472                                                         'name': 'recv_splitfrom_id_recv_freight_curr_id',
3473                                                         'type': 'int'
3474                                                     },
3475                                                     {
3476                                                         'name': 'recv_splitfrom_id_recv_date',
3477                                                         'type': 'date'
3478                                                     },
3479                                                     {
3480                                                         'name': 'recv_splitfrom_id_recv_value',
3481                                                         'type': 'float'
3482                                                     },
3483                                                     {
3484                                                         'name': 'recv_splitfrom_id_recv_posted',
3485                                                         'type': 'int'
3486                                                     },
3487                                                     {
3488                                                         'name': 'recv_splitfrom_id_recv_invoiced',
3489                                                         'type': 'int'
3490                                                     },
3491                                                     {
3492                                                         'name': 'recv_splitfrom_id_recv_vohead_id',
3493                                                         'type': 'int'
3494                                                     },
3495                                                     {
3496                                                         'name': 'recv_splitfrom_id_recv_voitem_id',
3497                                                         'type': 'int'
3498                                                     },
3499                                                     {
3500                                                         'name': 'recv_splitfrom_id_recv_trans_usr_name',
3501                                                         'type': 'string'
3502                                                     },
3503                                                     {
3504                                                         'name': 'recv_splitfrom_id_recv_notes',
3505                                                         'type': 'string'
3506                                                     },
3507                                                     {
3508                                                         'name': 'recv_splitfrom_id_recv_gldistdate',
3509                                                         'type': 'date'
3510                                                     },
3511                                                     {
3512                                                         'name': 'recv_splitfrom_id_recv_splitfrom_id',
3513                                                         'type': 'int'
3514                                                     },
3515                                                     {
3516                                                         'name': 'recv_splitfrom_id_recv_rlsd_duedate',
3517                                                         'type': 'date'
3518                                                     },
3519                                                     {
3520                                                         'name': 'recv_recvcost_curr_id_curr_id',
3521                                                         'type': 'int'
3522                                                     },
3523                                                     {
3524                                                         'name': 'recv_recvcost_curr_id_curr_base',
3525                                                         'type': 'int'
3526                                                     },
3527                                                     {
3528                                                         'name': 'recv_recvcost_curr_id_curr_name',
3529                                                         'type': 'string'
3530                                                     },
3531                                                     {
3532                                                         'name': 'recv_recvcost_curr_id_curr_symbol',
3533                                                         'type': 'string'
3534                                                     },
3535                                                     {
3536                                                         'name': 'recv_recvcost_curr_id_curr_abbr',
3537                                                         'type': 'string'
3538                                                     },
3539                                                     {
3540                                                         'name': 'recv_purchcost_curr_id_curr_id',
3541                                                         'type': 'int'
3542                                                     },
3543                                                     {
3544                                                         'name': 'recv_purchcost_curr_id_curr_base',
3545                                                         'type': 'int'
3546                                                     },
3547                                                     {
3548                                                         'name': 'recv_purchcost_curr_id_curr_name',
3549                                                         'type': 'string'
3550                                                     },
3551                                                     {
3552                                                         'name': 'recv_purchcost_curr_id_curr_symbol',
3553                                                         'type': 'string'
3554                                                     },
3555                                                     {
3556                                                         'name': 'recv_purchcost_curr_id_curr_abbr',
3557                                                         'type': 'string'
3558                                                     },
3559                                                     {
3560                                                         'name': 'recv_itemsite_id_itemsite_id',
3561                                                         'type': 'int'
3562                                                     },
3563                                                     {
3564                                                         'name': 'recv_itemsite_id_itemsite_item_id',
3565                                                         'type': 'int'
3566                                                     },
3567                                                     {
3568                                                         'name': 'recv_itemsite_id_itemsite_warehous_id',
3569                                                         'type': 'int'
3570                                                     },
3571                                                     {
3572                                                         'name': 'recv_itemsite_id_itemsite_qtyonhand',
3573                                                         'type': 'float'
3574                                                     },
3575                                                     {
3576                                                         'name': 'recv_itemsite_id_itemsite_reorderlevel',
3577                                                         'type': 'float'
3578                                                     },
3579                                                     {
3580                                                         'name': 'recv_itemsite_id_itemsite_ordertoqty',
3581                                                         'type': 'float'
3582                                                     },
3583                                                     {
3584                                                         'name': 'recv_itemsite_id_itemsite_cyclecountfreq',
3585                                                         'type': 'int'
3586                                                     },
3587                                                     {
3588                                                         'name': 'recv_itemsite_id_itemsite_datelastcount',
3589                                                         'type': 'date'
3590                                                     },
3591                                                     {
3592                                                         'name': 'recv_itemsite_id_itemsite_datelastused',
3593                                                         'type': 'date'
3594                                                     },
3595                                                     {
3596                                                         'name': 'recv_itemsite_id_itemsite_loccntrl',
3597                                                         'type': 'int'
3598                                                     },
3599                                                     {
3600                                                         'name': 'recv_itemsite_id_itemsite_safetystock',
3601                                                         'type': 'float'
3602                                                     },
3603                                                     {
3604                                                         'name': 'recv_itemsite_id_itemsite_minordqty',
3605                                                         'type': 'float'
3606                                                     },
3607                                                     {
3608                                                         'name': 'recv_itemsite_id_itemsite_multordqty',
3609                                                         'type': 'float'
3610                                                     },
3611                                                     {
3612                                                         'name': 'recv_itemsite_id_itemsite_leadtime',
3613                                                         'type': 'int'
3614                                                     },
3615                                                     {
3616                                                         'name': 'recv_itemsite_id_itemsite_abcclass',
3617                                                         'type': 'string'
3618                                                     },
3619                                                     {
3620                                                         'name': 'recv_itemsite_id_itemsite_issuemethod',
3621                                                         'type': 'string'
3622                                                     },
3623                                                     {
3624                                                         'name': 'recv_itemsite_id_itemsite_controlmethod',
3625                                                         'type': 'string'
3626                                                     },
3627                                                     {
3628                                                         'name': 'recv_itemsite_id_itemsite_active',
3629                                                         'type': 'int'
3630                                                     },
3631                                                     {
3632                                                         'name': 'recv_itemsite_id_itemsite_plancode_id',
3633                                                         'type': 'int'
3634                                                     },
3635                                                     {
3636                                                         'name': 'recv_itemsite_id_itemsite_costcat_id',
3637                                                         'type': 'int'
3638                                                     },
3639                                                     {
3640                                                         'name': 'recv_itemsite_id_itemsite_eventfence',
3641                                                         'type': 'int'
3642                                                     },
3643                                                     {
3644                                                         'name': 'recv_itemsite_id_itemsite_sold',
3645                                                         'type': 'int'
3646                                                     },
3647                                                     {
3648                                                         'name': 'recv_itemsite_id_itemsite_stocked',
3649                                                         'type': 'int'
3650                                                     },
3651                                                     {
3652                                                         'name': 'recv_itemsite_id_itemsite_freeze',
3653                                                         'type': 'int'
3654                                                     },
3655                                                     {
3656                                                         'name': 'recv_itemsite_id_itemsite_location_id',
3657                                                         'type': 'int'
3658                                                     },
3659                                                     {
3660                                                         'name': 'recv_itemsite_id_itemsite_useparams',
3661                                                         'type': 'int'
3662                                                     },
3663                                                     {
3664                                                         'name': 'recv_itemsite_id_itemsite_useparamsmanual',
3665                                                         'type': 'int'
3666                                                     },
3667                                                     {
3668                                                         'name': 'recv_itemsite_id_itemsite_soldranking',
3669                                                         'type': 'int'
3670                                                     },
3671                                                     {
3672                                                         'name': 'recv_itemsite_id_itemsite_createpr',
3673                                                         'type': 'int'
3674                                                     },
3675                                                     {
3676                                                         'name': 'recv_itemsite_id_itemsite_location',
3677                                                         'type': 'string'
3678                                                     },
3679                                                     {
3680                                                         'name': 'recv_itemsite_id_itemsite_location_comments',
3681                                                         'type': 'string'
3682                                                     },
3683                                                     {
3684                                                         'name': 'recv_itemsite_id_itemsite_notes',
3685                                                         'type': 'string'
3686                                                     },
3687                                                     {
3688                                                         'name': 'recv_itemsite_id_itemsite_perishable',
3689                                                         'type': 'int'
3690                                                     },
3691                                                     {
3692                                                         'name': 'recv_itemsite_id_itemsite_nnqoh',
3693                                                         'type': 'float'
3694                                                     },
3695                                                     {
3696                                                         'name': 'recv_itemsite_id_itemsite_autoabcclass',
3697                                                         'type': 'int'
3698                                                     },
3699                                                     {
3700                                                         'name': 'recv_itemsite_id_itemsite_ordergroup',
3701                                                         'type': 'int'
3702                                                     },
3703                                                     {
3704                                                         'name': 'recv_itemsite_id_itemsite_disallowblankwip',
3705                                                         'type': 'int'
3706                                                     },
3707                                                     {
3708                                                         'name': 'recv_itemsite_id_itemsite_maxordqty',
3709                                                         'type': 'float'
3710                                                     },
3711                                                     {
3712                                                         'name': 'recv_itemsite_id_itemsite_mps_timefence',
3713                                                         'type': 'int'
3714                                                     },
3715                                                     {
3716                                                         'name': 'recv_itemsite_id_itemsite_createwo',
3717                                                         'type': 'int'
3718                                                     },
3719                                                     {
3720                                                         'name': 'recv_itemsite_id_itemsite_warrpurc',
3721                                                         'type': 'int'
3722                                                     },
3723                                                     {
3724                                                         'name': 'recv_itemsite_id_itemsite_autoreg',
3725                                                         'type': 'int'
3726                                                     },
3727                                                     {
3728                                                         'name': 'recv_itemsite_id_itemsite_costmethod',
3729                                                         'type': 'string'
3730                                                     },
3731                                                     {
3732                                                         'name': 'recv_itemsite_id_itemsite_value',
3733                                                         'type': 'float'
3734                                                     },
3735                                                     {
3736                                                         'name': 'recv_itemsite_id_itemsite_ordergroup_first',
3737                                                         'type': 'int'
3738                                                     },
3739                                                     {
3740                                                         'name': 'recv_itemsite_id_itemsite_supply_itemsite_id',
3741                                                         'type': 'int'
3742                                                     },
3743                                                     {
3744                                                         'name': 'recv_itemsite_id_itemsite_planning_type',
3745                                                         'type': 'string'
3746                                                     },
3747                                                     {
3748                                                         'name': 'recv_itemsite_id_itemsite_wosupply',
3749                                                         'type': 'int'
3750                                                     },
3751                                                     {
3752                                                         'name': 'recv_itemsite_id_itemsite_posupply',
3753                                                         'type': 'int'
3754                                                     },
3755                                                     {
3756                                                         'name': 'recv_itemsite_id_itemsite_lsseq_id',
3757                                                         'type': 'int'
3758                                                     },
3759                                                     {
3760                                                         'name': 'recv_itemsite_id_itemsite_cosdefault',
3761                                                         'type': 'string'
3762                                                     },
3763                                                     {
3764                                                         'name': 'recv_itemsite_id_itemsite_createsopr',
3765                                                         'type': 'int'
3766                                                     },
3767                                                     {
3768                                                         'name': 'recv_itemsite_id_itemsite_createsopo',
3769                                                         'type': 'int'
3770                                                     },
3771                                                     {
3772                                                         'name': 'recv_itemsite_id_itemsite_dropship',
3773                                                         'type': 'int'
3774                                                     },
3775                                                     {
3776                                                         'name': 'recv_freight_curr_id_curr_id',
3777                                                         'type': 'int'
3778                                                     },
3779                                                     {
3780                                                         'name': 'recv_freight_curr_id_curr_base',
3781                                                         'type': 'int'
3782                                                     },
3783                                                     {
3784                                                         'name': 'recv_freight_curr_id_curr_name',
3785                                                         'type': 'string'
3786                                                     },
3787                                                     {
3788                                                         'name': 'recv_freight_curr_id_curr_symbol',
3789                                                         'type': 'string'
3790                                                     },
3791                                                     {
3792                                                         'name': 'recv_freight_curr_id_curr_abbr',
3793                                                         'type': 'string'
3794                                                     }
3795                                                 ]
3796                                             }
3797                                         },
3798                                         footer : {
3799                                             xtype: 'PagingToolbar',
3800                                             xns: Roo,
3801                                             displayInfo : true,
3802                                             displayMsg : " ",
3803                                             emptyMsg : "No recv found",
3804                                             pageSize : 100
3805                                         },
3806                                         colModel : [
3807                                             {
3808                                                 xtype: 'ColumnModel',
3809                                                 xns: Roo.grid,
3810                                                 align : 'right',
3811                                                 dataIndex : 'item_number',
3812                                                 header : 'Item',
3813                                                 width : 75,
3814                                                 renderer : function(v) { return String.format('{0}', v); }
3815                                             },
3816                                             {
3817                                                 xtype: 'ColumnModel',
3818                                                 xns: Roo.grid,
3819                                                 align : 'right',
3820                                                 dataIndex : 'poitem_qty_ordered',
3821                                                 header : 'Ordered',
3822                                                 width : 60,
3823                                                 renderer : function(v) { return String.format('{0}', v); }
3824                                             },
3825                                             {
3826                                                 xtype: 'ColumnModel',
3827                                                 xns: Roo.grid,
3828                                                 align : 'right',
3829                                                 dataIndex : 'r.data.poitem_qty_received',
3830                                                 header : 'Outstanding',
3831                                                 width : 60,
3832                                                 renderer : function(v,x,r) {
3833
3834
3835                                                     var  d = r.data.poitem_qty_ordered - ( r.data.poitem_qty_received - r.data.poitem_qty_returned);
3836
3837                                                     if (!d) {
3838                                                         return '';
3839                                                     }
3840                                                     return String.format('<b style="color:red">{0}</b>', d);
3841                                                  }
3842                                             },
3843                                             {
3844                                                 xtype: 'ColumnModel',
3845                                                 xns: Roo.grid,
3846                                                 align : 'right',
3847                                                 dataIndex : 'recv_qty_in_transit',
3848                                                 header : 'In Transit',
3849                                                 width : 60,
3850                                                 renderer : function(v,x,r) {
3851                                                     // recv_qty
3852                                                     // this should show in transit.. (only applicable to
3853                                                     //var rr = _this.rggrid.selModel.getSelected();
3854                                                         //if (rr) {
3855                                                             //return '';
3856                                                     //    }
3857
3858                                                     // in transit = recieved, but not transfered.
3859                                                     if ((v*1) == 0.0) {
3860                                                         return '';
3861                                                     }
3862                                                     return String.format('{0}',  (v*1).toFixed(0));
3863                                                 /*
3864                                                         // no reciept selected..
3865                                                     d = r.data.poitem_qty_received - r.data.poitem_qty_returned ;
3866                                                     d -= (r.data.poitem_qty_transfered_unposted*1 + r.data.poitem_qty_transfered*1) ;
3867
3868                                                     if (!d) {
3869                                                         return '';
3870                                                     }
3871                                                     return String.format('{0}',  d);
3872                                                     */
3873                                                  }
3874                                             },
3875                                             {
3876                                                 xtype: 'ColumnModel',
3877                                                 xns: Roo.grid,
3878                                                 align : 'right',
3879                                                 dataIndex : 'recv_qty',
3880                                                 header : 'Recieved',
3881                                                 width : 60,
3882                                                 renderer : function(v,x,r) {
3883
3884                                                     var d = parseInt(v);;
3885                                                     var rr = _this.rggrid.selModel.getSelected();
3886                                                     if (!rr) {
3887                                                         // show summary
3888                                                         //d = r.data.poitem_qty_received - r.data.poitem_qty_returned;
3889                                                         // real recived amount = the total that has been transfered out
3890
3891
3892
3893                                                        //d =  (r.data.poitem_qty_transfered_unposted*1 + r.data.poitem_qty_transfered*1) ;
3894                                                         //var tot_rec =  r.data.poitem_qty_received - r.data.poitem_qty_returned;
3895                                                         //if (d < tot_rec) {
3896                                                         //    return String.format('<b style="color:red">{0}</b>',  d);
3897                                                         //}
3898
3899                                                         //return String.format('{0}',  d);
3900
3901
3902                                                     }
3903
3904
3905                                                     if (!d) {
3906                                                         return '';
3907                                                     }
3908                                                     if (rr && rr.data.recvgrp_void *1 ) {
3909                                                             return String.format('<s>{0}</s>',  d);
3910
3911                                                     }
3912
3913
3914
3915                                                     return String.format('{0}',  d);
3916                                                  }
3917                                             }
3918                                         ]
3919                                     }
3920                                 }
3921                             ],
3922                             center : {
3923                                 xtype: 'LayoutRegion',
3924                                 xns: Roo,
3925                                 title : "Item Receipts",
3926                                 titlebar : true
3927                             },
3928                             south : {
3929                                 xtype: 'LayoutRegion',
3930                                 xns: Roo,
3931                                 height : 450,
3932                                 split : true,
3933                                 title : "Items"
3934                             }
3935                         }
3936                     }
3937                 ],
3938                 center : {
3939                     xtype: 'LayoutRegion',
3940                     xns: Roo
3941                 },
3942                 east : {
3943                     xtype: 'LayoutRegion',
3944                     xns: Roo,
3945                     split : true,
3946                     width : 340
3947                 }
3948             }
3949         };
3950     }
3951 });