git.roojs.org Git - Pman.Xtuple/blob - Pman.Dialog.XtupleTransfer.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.Dialog.XtupleTransfer = {
   6
   7     dialog : false,
   8     callback:  false,
   9
  10     show : function(data, cb)
  11     {
  12         if (!this.dialog) {
  13             this.create();
  14         }
  15
  16         this.callback = cb;
  17         this.data = data;
  18         this.dialog.show(this.data._el);
  19         if (this.form) {
  20            this.form.reset();
  21            this.form.setValues(data);
  22            this.form.fireEvent('actioncomplete', this.form,  { type: 'setdata', data: data });
  23         }
  24
  25     },
  26
  27     create : function()
  28     {
  29         var _this = this;
  30         this.dialog = Roo.factory({
  31             xtype: 'LayoutDialog',
  32             xns: Roo,
  33             listeners : {
  34                 show : function (_self)
  35                 {
  36                     this.layout.getRegion('center').showPanel(0);
  37                 }
  38             },
  39             closable : false,
  40             collapsible : false,
  41             height : 660,
  42             modal : true,
  43             resizable : false,
  44             title : "Edit / Create Inventory Transfer",
  45             width : 800,
  46             items : [
  47                 {
  48                     xtype: 'NestedLayoutPanel',
  49                     xns: Roo,
  50                     region : 'center',
  51                     title : "Inventory Transfer",
  52                     layout : {
  53                         xtype: 'BorderLayout',
  54                         xns: Roo,
  55                         items : [
  56                             {
  57                                 xtype: 'ContentPanel',
  58                                 xns: Roo,
  59                                 region : 'north',
  60                                 items : [
  61                                     {
  62                                         xtype: 'Form',
  63                                         xns: Roo.form,
  64                                         listeners : {
  65                                             actioncomplete : function(_self,action)
  66                                             {
  67                                                 if (action.type == 'setdata') {
  68                                                    //_this.dialog.el.mask("Loading");
  69                                                    Roo.log('setdata');
  70                                                    Roo.log(_this.data);
  71                                                    // reversal...
  72                                                    _this.grid.setColumns();
  73                                                    _this.saveBtn.show();
  74                                                    if (_this.data.createFromRev) {
  75                                                         Roo.log('recvg');
  76                                                         this.load({ method: 'GET', params: { '_createFromRecv' : _this.data.createFromRev }});
  77                                                         return;
  78
  79                                                    }
  80
  81                                                     if (_this.data.invhist_transfer_id) {
  82
  83
  84                                                         var tdb = baseURL.split('/').pop().split('.').shift();
  85                                                         if (tdb != _this.data._roo_office) {
  86                                                             this.el.mask('Remote Transfer - Read Only');
  87                                                             _this.grid.view.headerPanel.mask("");
  88                                                             _this.uploadBtn.hide();
  89                                                             _this.saveBtn.hide();
  90                                                         } else {
  91                                                             this.el.unmask();
  92                                                             _this.grid.view.headerPanel.unmask();
  93                                                             _this.uploadBtn.show();
  94                                                             _this.saveBtn.show();
  95                                                         }
  96
  97
  98
  99                                                         this.load({ method: 'GET', params: {
 100                                                              _id : _this.data.invhist_transfer_id,
 101                                                              _roo_office  : _this.data._roo_office
 102                                                        }});
 103                                                         return;
 104                                                     }
 105                                                     _this.grid.ds.removeAll();
 106                                                     _this.form.setValues({
 107                                                         invhist_transfer_transdate :
 108                                                                 typeof(_this.data.invhist_transfer_transdate) == 'undefined' ?
 109                                                                         (new Date()).format('Y-m-d') :
 110                                                                         _this.data.invhist_transfer_transdate
 111                                                                     ,
 112                                                         invhist_transfer_number : 'AUTOMATIC',
 113                                                         _roo_office :  _this.data._roo_office
 114                                                     });
 115
 116                                                     if(_this.data._createReverse){
 117                                                         if(_this.grid){
 118                                                             new Pman.Request({\r
 119                                                                 url : baseURL + '/Roo/invhist_transfer_item',\r
 120                                                                 method : 'GET',\r
 121                                                                 params : {\r
 122                                                                     invhist_transfer_item_invhist_transfer_id : _this.data._createReverse,\r
 123                                                                     'query[at_location]' : _this.data.invhist_transfer_from,
 124                                                                     _requestMeta : 1,
 125                                                                     limit : 999,
 126                                                                     sort : 'invhist_transfer_item_line',
 127                                                                     dir : 'ASC'\r
 128                                                                 },\r
 129                                                                 success : function (res) \r
 130                                                                 {
 131                                                                     Roo.log('loadData');
 132                                                                     Roo.log(res); \r
 133                                                                    _this.grid.ds.loadData(res,false);\r
 134                                                                 }\r
 135                                                             });
 136                                                         }
 137                                                     }
 138
 139                                                     this.setValues({
 140                                                         invhist_transfer_salesrep_id : Pman.Login.authUser.salesrep.salesrep_id,
 141                                                         invhist_transfer_salesrep_id_salesrep_name : Pman.Login.authUser.salesrep.salesrep_name
 142                                                     });
 143
 144
 145                                                     if (typeof(_this.data._ns_autofill) != 'undefined') {
 146                                                         Roo.log("autofill: " +  _this.data._ns_autofill);
 147
 148
 149                                                         var locid = _this.data._ns_autofill === 1 ?_this.data.invhist_transfer_to  : _this.data.invhist_transfer_from;
 150                                                         // clear it so it's not done again..
 151
 152                                                         Roo.log("locid: " + locid);
 153
 154                                                          var rn = 0;
 155                                                          var addRow = function(r) {
 156
 157                                                                 var nsQty = r.netsuite_qty*1;
 158                                                                 nsQty = nsQty < 1 ? 0 : nsQty;
 159
 160                                                                 var ourQty = r.itemsite_qty *1;
 161                                                                 var addQty = 0;
 162                                                                 if (_this.data._ns_autofill === 1) {
 163                                                                     // then we are trying to transfer from somewhere to her, to increase the qty to match
 164                                                                     // so if  ourQty < nsQty
 165                                                                     if (ourQty < nsQty) {
 166                                                                         addQty = nsQty - ourQty;
 167                                                                     }
 168
 169                                                                 } else {
 170                                                                     // we are trying to transfer out to get rid of stock to match..
 171                                                                     if (nsQty < ourQty) {
 172                                                                         addQty = ourQty - nsQty;
 173                                                                     }
 174                                                                 }
 175
 176                                                                 if (addQty * 1 < 1) {
 177
 178                                                                     return;
 179                                                                 }
 180
 181                                                                var nr = _this.grid.ds.reader.newRow({
 182                                                                     invhist_transfer_item_line : rn + 1,
 183                                                                     item_id : r.itemsite_item_id,
 184                                                                     invhist_transfer_item_itemsite_id :         r.itemsite_id,
 185                                                                     item_number : r.itemsite_item_id_item_number,
 186                                                                     item_descrip1 : r.itemsite_item_id_item_descrip1,
 187                                                                     invhist_transfer_item_qty : addQty,
 188                                                                     item_availqty : 0
 189                                                                    // invhist_transfer_item_transfer_id : tid << we do not know this?!?
 190                                                                });
 191                                                                  _this.grid.ds.insert(rn++, nr);
 192
 193                                                         };
 194
 195
 196
 197
 198                                                         // do the request..
 199                                                         new Pman.Request({
 200                                                             url : baseURL + '/Roo/itemsite',
 201                                                             mask: "Fetching Stock Quantities",
 202                                                             method : 'GET',
 203                                                             params : {
 204                                                                 limit : 99999,
 205                                                                 location_id : locid,
 206                                                                 _as_of : _this.data.invhist_transfer_transdate,
 207                                                                 _with_stock_and_value : 1,
 208                                                                 _with_ns_all_stock : 1,
 209                                                                 'sort' :  'itemsite_item_id_item_number',
 210                                                                 'dir' : 'ASC'
 211                                                             },
 212                                                             success : function(res) {
 213                                                                 Roo.log(res);
 214                                                                  Roo.each(res.data, addRow);
 215                                                                  _this.data._ns_autofill = undefined;
 216                                                             }
 217                                                         });
 218                                                     }
 219
 220                                                    return;
 221                                                 }
 222                                                 if (action.type == 'load') {
 223
 224                                                     // fix date..
 225                                                     this.findField('_roo_office').setValue(  _this.data._roo_office );
 226                                                     Roo.log(action);
 227                                                     _this.data = action.result.data;
 228                                                     if(_this.data.invhist_transfer_void){
 229                                                         _this.saveBtn.hide();
 230                                                     }
 231                                                     var dt = Date.parseDate(_this.data.invhist_transfer_transdate.split(' ')[0], "Y-m-d");
 232                                                     _this.form.findField('invhist_transfer_transdate').setValue(dt);
 233                                                     var dt = Date.parseDate(_this.data.invhist_transfer_arrivaldate.split(' ')[0],"Y-m-d");
 234                                                     _this.form.findField('invhist_transfer_arrivaldate').setValue(dt);
 235                                                     _this.grid.ds.load({});
 236
 237                                                     return;
 238                                                 }
 239                                                 if (action.type =='submit') {
 240
 241
 242                                                     _this.dialog.hide();
 243
 244                                                      if (_this.callback) {
 245                                                         _this.callback.call(_this, _this.form.getValues());
 246                                                      }
 247                                                      _this.form.reset();
 248                                                      return;
 249                                                 }
 250                                             },
 251                                             rendered : function (form)
 252                                             {
 253                                                 _this.form= form;
 254                                             }
 255                                         },
 256                                         method : 'POST',
 257                                         style : 'margin:10px;',
 258                                         url : baseURL + '/Xtuple/Roo/invhist_transfer.php',
 259                                         items : [
 260                                             {
 261                                                 xtype: 'Column',
 262                                                 xns: Roo.form,
 263                                                 width : 400,
 264                                                 items : [
 265                                                     {
 266                                                         xtype: 'FieldSet',
 267                                                         xns: Roo.form,
 268                                                         legend : "Transfer Details",
 269                                                         style : 'width: 380px;height:220px;',
 270                                                         items : [
 271                                                             {
 272                                                                 xtype: 'DateField',
 273                                                                 xns: Roo.form,
 274                                                                 allowBlank : false,
 275                                                                 fieldLabel : 'Date',
 276                                                                 format : 'Y-m-d',
 277                                                                 name : 'invhist_transfer_transdate',
 278                                                                 width : 100
 279                                                             },
 280                                                             {
 281                                                                 xtype: 'DateField',
 282                                                                 xns: Roo.form,
 283                                                                 allowBlank : true,
 284                                                                 fieldLabel : 'Arrival date',
 285                                                                 format : 'Y-m-d',
 286                                                                 name : 'invhist_transfer_arrivaldate',
 287                                                                 width : 100
 288                                                             },
 289                                                             {
 290                                                                 xtype: 'TextField',
 291                                                                 xns: Roo.form,
 292                                                                 fieldLabel : 'Reference #',
 293                                                                 name : 'invhist_transfer_number',
 294                                                                 readOnly : true,
 295                                                                 width : 200
 296                                                             },
 297                                                             {
 298                                                                 xtype: 'ComboBox',
 299                                                                 xns: Roo.form,
 300                                                                 allowBlank : true,
 301                                                                 displayField : 'salesrep_name',
 302                                                                 editable : false,
 303                                                                 emptyText : "Select salesrep",
 304                                                                 fieldLabel : 'Sales Rep',
 305                                                                 forceSelection : true,
 306                                                                 hiddenName : 'invhist_transfer_salesrep_id',
 307                                                                 listWidth : 400,
 308                                                                 loadingText : "Searching...",
 309                                                                 minChars : 2,
 310                                                                 name : 'invhist_transfer_salesrep_id_salesrep_name',
 311                                                                 pageSize : 20,
 312                                                                 qtip : "Select salesrep",
 313                                                                 queryParam : 'query[salesrep_name]',
 314                                                                 selectOnFocus : true,
 315                                                                 tpl : '<div class="x-grid-cell-text x-btn button"><b>{salesrep_name}</b> </div>',
 316                                                                 triggerAction : 'all',
 317                                                                 typeAhead : true,
 318                                                                 valueField : 'salesrep_id',
 319                                                                 width : 250,
 320                                                                 store : {
 321                                                                     xtype: 'Store',
 322                                                                     xns: Roo.data,
 323                                                                     listeners : {
 324                                                                         beforeload : function (_self, o){
 325                                                                             o.params = o.params || {};
 326                                                                             // set more here
 327                                                                         }
 328                                                                     },
 329                                                                     remoteSort : true,
 330                                                                     sortInfo : { direction : 'ASC', field: 'salesrep_name' },
 331                                                                     proxy : {
 332                                                                         xtype: 'HttpProxy',
 333                                                                         xns: Roo.data,
 334                                                                         method : 'GET',
 335                                                                         url : baseURL + '/Roo/salesrep.php'
 336                                                                     },
 337                                                                     reader : {
 338                                                                         xtype: 'JsonReader',
 339                                                                         xns: Roo.data,
 340                                                                         id : 'salesrep_id',
 341                                                                         root : 'data',
 342                                                                         totalProperty : 'total',
 343                                                                         fields : [{"name":"salesrep_id","type":"int"},"salesrep_name"]
 344                                                                     }
 345                                                                 }
 346                                                             },
 347                                                             {
 348                                                                 xtype: 'ComboBox',
 349                                                                 xns: Roo.form,
 350                                                                 listeners : {
 351                                                                     render : function (_self)
 352                                                                     {
 353                                                                         _this.fromLocation = _self;
 354                                                                     }
 355                                                                 },
 356                                                                 allowBlank : false,
 357                                                                 displayField : 'location_descrip',
 358                                                                 editable : true,
 359                                                                 emptyText : "Select location",
 360                                                                 fieldLabel : 'From Location',
 361                                                                 forceSelection : true,
 362                                                                 hiddenName : 'invhist_transfer_from',
 363                                                                 listWidth : 400,
 364                                                                 loadingText : "Searching...",
 365                                                                 minChars : 2,
 366                                                                 name : 'invhist_transfer_from_location_descrip',
 367                                                                 pageSize : 200,
 368                                                                 qtip : "Select location",
 369                                                                 queryParam : 'query[location_name]',
 370                                                                 selectOnFocus : true,
 371                                                                 tpl : '<div class="x-grid-cell-text x-btn button"><b>{location_name}</b> - {location_descrip} </div>',
 372                                                                 triggerAction : 'all',
 373                                                                 valueField : 'location_id',
 374                                                                 width : 250,
 375                                                                 store : {
 376                                                                     xtype: 'Store',
 377                                                                     xns: Roo.data,
 378                                                                     listeners : {
 379                                                                         beforeload : function (_self, o){
 380                                                                             o.params = o.params || {};
 381                                                                             // set more here
 382
 383                                                                                 o.params._notinternalcompany = 1;
 384
 385                                                                         }
 386                                                                     },
 387                                                                     remoteSort : true,
 388                                                                     sortInfo : { direction : 'ASC', field: 'location_name' },
 389                                                                     proxy : {
 390                                                                         xtype: 'HttpProxy',
 391                                                                         xns: Roo.data,
 392                                                                         method : 'GET',
 393                                                                         url : baseURL + '/Roo/location.php'
 394                                                                     },
 395                                                                     reader : {
 396                                                                         xtype: 'JsonReader',
 397                                                                         xns: Roo.data,
 398                                                                         id : 'id',
 399                                                                         root : 'data',
 400                                                                         totalProperty : 'total',
 401                                                                         fields : [{"name":"id","type":"int"},{"name":"location_name","type":"string"}]
 402                                                                     }
 403                                                                 }
 404                                                             },
 405                                                             {
 406                                                                 xtype: 'ComboBox',
 407                                                                 xns: Roo.form,
 408                                                                 listeners : {
 409                                                                     select : function (combo, record, index)
 410                                                                     {
 411                                                                         combo._is_internalcompany = false;
 412
 413                                                                         if(record.data.cust_to_internalcompany.length){
 414                                                                             combo._is_internalcompany = true;
 415                                                                         }
 416
 417                                                                         _this.grid.setColumns();
 418                                                                     },
 419                                                                     render : function (_self)
 420                                                                     {
 421                                                                         _this.toLocation = _self;
 422                                                                     }
 423                                                                 },
 424                                                                 allowBlank : false,
 425                                                                 displayField : 'location_descrip',
 426                                                                 editable : true,
 427                                                                 emptyText : "Select location",
 428                                                                 fieldLabel : 'To Location',
 429                                                                 forceSelection : true,
 430                                                                 hiddenName : 'invhist_transfer_to',
 431                                                                 listWidth : 400,
 432                                                                 loadingText : "Searching...",
 433                                                                 minChars : 2,
 434                                                                 name : 'invhist_transfer_to_location_descrip',
 435                                                                 pageSize : 200,
 436                                                                 qtip : "Select location",
 437                                                                 queryParam : 'query[location_name]',
 438                                                                 selectOnFocus : true,
 439                                                                 tpl : '<div class="x-grid-cell-text x-btn button"><b>{location_name}</b>  - <b style="color:red">{location_cust_id_char_internalcompany} </b> {location_descrip} </div>',
 440                                                                 triggerAction : 'all',
 441                                                                 valueField : 'location_id',
 442                                                                 width : 250,
 443                                                                 store : {
 444                                                                     xtype: 'Store',
 445                                                                     xns: Roo.data,
 446                                                                     listeners : {
 447                                                                         beforeload : function (_self, o){
 448                                                                             o.params = o.params || {};
 449                                                                             o.params.location_restrict = 0;
 450                                                                             o.params._with_internalcompany = 1;
 451
 452                                                                         }
 453                                                                     },
 454                                                                     remoteSort : true,
 455                                                                     sortInfo : { direction : 'ASC', field: 'location_name' },
 456                                                                     proxy : {
 457                                                                         xtype: 'HttpProxy',
 458                                                                         xns: Roo.data,
 459                                                                         method : 'GET',
 460                                                                         url : baseURL + '/Roo/location.php'
 461                                                                     },
 462                                                                     reader : {
 463                                                                         xtype: 'JsonReader',
 464                                                                         xns: Roo.data,
 465                                                                         id : 'id',
 466                                                                         root : 'data',
 467                                                                         totalProperty : 'total',
 468                                                                         fields : [{"name":"id","type":"int"},{"name":"location_name","type":"string"}]
 469                                                                     }
 470                                                                 }
 471                                                             }
 472                                                         ]
 473                                                     }
 474                                                 ]
 475                                             },
 476                                             {
 477                                                 xtype: 'Column',
 478                                                 xns: Roo.form,
 479                                                 style : 'margin-left: 10px; float: left;',
 480                                                 width : 280,
 481                                                 items : [
 482                                                     {
 483                                                         xtype: 'FieldSet',
 484                                                         xns: Roo.form,
 485                                                         hideLabels : true,
 486                                                         legend : "Transfer Delivery Note Reference",
 487                                                         style : 'width: 260px',
 488                                                         items : [
 489                                                             {
 490                                                                 xtype: 'TextArea',
 491                                                                 xns: Roo.form,
 492                                                                 fieldLabel : 'invhist_transfer_delivery_note',
 493                                                                 name : 'invhist_transfer_delivery_note',
 494                                                                 width : 250
 495                                                             }
 496                                                         ]
 497                                                     },
 498                                                     {
 499                                                         xtype: 'FieldSet',
 500                                                         xns: Roo.form,
 501                                                         hideLabels : true,
 502                                                         legend : "Transfer Description",
 503                                                         style : 'width: 260px',
 504                                                         items : [
 505                                                             {
 506                                                                 xtype: 'TextArea',
 507                                                                 xns: Roo.form,
 508                                                                 fieldLabel : 'invhist_transfer_descrip',
 509                                                                 name : 'invhist_transfer_descrip',
 510                                                                 width : 250
 511                                                             }
 512                                                         ]
 513                                                     },
 514                                                     {
 515                                                         xtype: 'Row',
 516                                                         xns: Roo.form,
 517                                                         items : [
 518                                                             {
 519                                                                 xtype: 'ComboBox',
 520                                                                 xns: Roo.form,
 521                                                                 allowBlank : true,
 522                                                                 displayField : 'desc',
 523                                                                 editable : false,
 524                                                                 fieldLabel : 'Transfer Price',
 525                                                                 hiddenName : 'invhist_transfer_price',
 526                                                                 listWidth : 200,
 527                                                                 mode : 'local',
 528                                                                 name : 'invhist_transfer_price_desc',
 529                                                                 triggerAction : 'all',
 530                                                                 value : "",
 531                                                                 valueField : 'code',
 532                                                                 width : 150,
 533                                                                 store : {
 534                                                                     xtype: 'SimpleStore',
 535                                                                     xns: Roo.data,
 536                                                                     data : [
 537                                                                         [ 'PRICELIST', "At Transfer Price"],
 538                                                                         [ 'LASTPLUS' , "Last Purchase +10% + 15% or stdcost +15%"],
 539                                                                         [ 'STDCOST' , "stdcost - for old transfers only%"]
 540
 541                                                                     ],
 542                                                                     fields : [  'code', 'desc']
 543                                                                 }
 544                                                             }
 545                                                         ]
 546                                                     }
 547                                                 ]
 548                                             },
 549                                             {
 550                                                 xtype: 'Hidden',
 551                                                 xns: Roo.form,
 552                                                 name : 'transfer_items'
 553                                             },
 554                                             {
 555                                                 xtype: 'Hidden',
 556                                                 xns: Roo.form,
 557                                                 name : '_roo_office'
 558                                             },
 559                                             {
 560                                                 xtype: 'Hidden',
 561                                                 xns: Roo.form,
 562                                                 name : 'invhist_transfer_id'
 563                                             }
 564                                         ]
 565                                     }
 566                                 ]
 567                             },
 568                             {
 569                                 xtype: 'GridPanel',
 570                                 xns: Roo,
 571                                 listeners : {
 572                                     activate : function() {
 573                                         _this.panel = this;
 574                                         if (_this.grid) {
 575                                             _this.grid.ds.load({});
 576                                         }
 577                                     }
 578                                 },
 579                                 fitContainer : true,
 580                                 fitToframe : true,
 581                                 region : 'center',
 582                                 tableName : 'invhist_transfer_item',
 583                                 title : "invhist_transfer_item",
 584                                 grid : {
 585                                     xtype: 'EditorGrid',
 586                                     xns: Roo.grid,
 587                                     listeners : {
 588                                         render : function()
 589                                         {
 590                                             _this.grid = this;
 591                                             //_this.dialog = Pman.Dialog.FILL_IN
 592                                             if (_this.panel.active) {
 593                                                this.ds.load({});
 594                                             }
 595                                         },
 596                                         rowdblclick : function (_self, rowIndex, e)
 597                                         {
 598                                             if (!_this.dialog) return;
 599                                             _this.dialog.show( this.getDataSource().getAt(rowIndex), function() {
 600                                                 _this.grid.footer.onClick('first');
 601                                             });
 602                                         },
 603                                         beforeedit : function (e)
 604                                         {
 605                                             if(_this.data.invhist_transfer_posted){
 606                                                 Roo.MessageBox.alert('Error', 'This transfer has been posted');
 607                                                 return false;
 608                                             }
 609                                             if(_this.data.invhist_transfer_void){
 610                                                 Roo.MessageBox.alert('Error', 'This transfer has been voided');
 611                                                 return false;
 612                                             }
 613
 614                                             if(e.field == 'invhist_transfer_item_unit_price' && (!_this.data.cust_to_internalcompany || !_this.data.cust_to_internalcompany.length) && !_this.toLocation._is_internalcompany){
 615                                                 Roo.MessageBox.alert('Error', 'Not a inter-comany transfer');
 616                                                 return false;
 617                                             }
 618
 619
 620
 621                                         }
 622                                     },
 623                                     autoExpandColumn : 'item_descrip1',
 624                                     clicksToEdit : 1,
 625                                     loadMask : true,
 626                                     setColumns : function() {
 627                                         var cm = _this.grid.getColumnModel();
 628
 629                                         function cid(str) {
 630                                             return cm.getIndexByDataIndex(str);
 631                                         }
 632
 633                                         if((!_this.data.cust_to_internalcompany || !_this.data.cust_to_internalcompany.length) && !_this.toLocation._is_internalcompany){
 634                                             cm.setHidden(cid('invhist_transfer_item_unit_price'), true);
 635                                             cm.setHidden(cid('invhist_transfer_item_unit_price_default'), true);
 636                                             return;
 637                                         }
 638
 639                                         cm.setHidden(cid('invhist_transfer_item_unit_price'), false);
 640                                         cm.setHidden(cid('invhist_transfer_item_unit_price_default'), false);
 641                                     },
 642                                     sm : {
 643                                         xtype: 'CellSelectionModel',
 644                                         xns: Roo.grid,
 645                                         listeners : {
 646                                             tabend : function (_self)
 647                                             {
 648                                                 _this.addItemBtn.fireEvent('click', _this.addItemBtn);
 649                                             }
 650                                         }
 651                                     },
 652                                     dataSource : {
 653                                         xtype: 'Store',
 654                                         xns: Roo.data,
 655                                         listeners : {
 656                                             beforeload : function (_self, o)
 657                                             {
 658
 659                                                 o.params = o.params || {};
 660                                                 if (!_this.form) {
 661                                                     return false;
 662                                                 }
 663
 664                                                 o.params.invhist_transfer_item_invhist_transfer_id = _this.form.findField('invhist_transfer_id').getValue() * 1;
 665
 666                                                 if ( !o.params.invhist_transfer_item_invhist_transfer_id) {
 667                                                     _this.grid.ds.removeAll();
 668                                                     return false;
 669                                                 }
 670
 671                                                 o.params['query[at_location]'] = _this.form.findField('invhist_transfer_from').getValue();
 672                                                 o.params.limit = 999;
 673                                                 o.params._roo_office =  _this.form.findField('_roo_office').getValue();
 674
 675                                                 _this.grid.setColumns();
 676
 677                                                 if(!_this.data.cust_to_internalcompany || !_this.data.cust_to_internalcompany.length){
 678                                                     return;
 679                                                 }
 680
 681                                                 o.params._inter_transfer = 1;
 682
 683
 684
 685                                             }
 686                                         },
 687                                         remoteSort : true,
 688                                         sortInfo : { field : 'invhist_transfer_item_line', direction: 'ASC' },
 689                                         proxy : {
 690                                             xtype: 'HttpProxy',
 691                                             xns: Roo.data,
 692                                             method : 'GET',
 693                                             url : baseURL + '/Xtuple/Roo/invhist_transfer_item.php'
 694                                         },
 695                                         reader : {
 696                                             xtype: 'JsonReader',
 697                                             xns: Roo.data,
 698                                             id : 'id',
 699                                             root : 'data',
 700                                             totalProperty : 'total',
 701                                             fields : [
 702                                                 {
 703                                                     'name': 'invhist_transfer_item_id',
 704                                                     'type': 'int'
 705                                                 },
 706                                                 {
 707                                                     'name': 'invhist_transfer_item_invhist_transfer_id',
 708                                                     'type': 'int'
 709                                                 },
 710                                                 {
 711                                                     'name': 'invhist_transfer_item_itemsite_id',
 712                                                     'type': 'int'
 713                                                 },
 714                                                 {
 715                                                     'name': 'invhist_transfer_item_qty',
 716                                                     'type': 'int'
 717                                                 },
 718                                                 {
 719                                                     'name': 'invhist_transfer_item_line',
 720                                                     'type': 'int'
 721                                                 },
 722                                                 {
 723                                                     'name': 'invhist_transfer_invhist_id',
 724                                                     'type': 'int'
 725                                                 },
 726                                                 'item_id',
 727                                                 'item_number',
 728                                                 'item_descrip1',
 729                                                 'avail_at_location'
 730
 731
 732                                             ]
 733                                         }
 734                                     },
 735                                     toolbar : {
 736                                         xtype: 'Toolbar',
 737                                         xns: Roo,
 738                                         items : [
 739                                             {
 740                                                 xtype: 'Button',
 741                                                 xns: Roo.Toolbar,
 742                                                 listeners : {
 743                                                     click : function()
 744                                                     {
 745
 746                                                          if (_this.data.invhist_transfer_posted) {
 747                                                             Roo.MessageBox.alert("Error", "Transfer has been posted, void it first");
 748                                                             return;
 749                                                         }
 750
 751                                                         // work out last
 752                                                         var grid = _this.grid;
 753                                                         var last = 0;
 754
 755                                                         _this.grid.ds.each(function(r) {
 756                                                             last = r.data.invhist_transfer_item_line;
 757                                                         });
 758
 759                                                         last++;
 760
 761                                                         var nr = _this.grid.ds.reader.newRow({
 762                                                             invhist_transfer_item_line : last,
 763                                                             item_number : '',
 764                                                             item_descrip1 : '',
 765                                                             invhist_transfer_item_qty : 0,
 766                                                             item_availqty : 0,
 767                                                             invhist_transfer_item_transfer_id : _this.form.findField('invhist_transfer_id').getValue()
 768                                                        });
 769
 770                                                         grid.stopEditing();
 771                                                         grid.ds.insert(grid.ds.getCount(), nr);
 772                                                         grid.startEditing(grid.ds.getCount()-1, 1); // type..
 773                                                     },
 774                                                     render : function (_self)
 775                                                     {
 776                                                         _this.addItemBtn = _self;
 777                                                     }
 778                                                 },
 779                                                 cls : 'x-btn-text-icon',
 780                                                 text : "Add",
 781                                                 icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
 782                                             },
 783                                             {
 784                                                 xtype: 'Button',
 785                                                 xns: Roo.Toolbar,
 786                                                 cls : 'x-btn-text-icon',
 787                                                 text : "Fill based on Stock",
 788                                                 icon : Roo.rootURL + 'images/default/dd/drop-add.gif',
 789                                                 menu : {
 790                                                     xtype: 'Menu',
 791                                                     xns: Roo.menu,
 792                                                     items : [
 793                                                         {
 794                                                             xtype: 'Item',
 795                                                             xns: Roo.menu,
 796                                                             listeners : {
 797                                                                 click : function()
 798                                                                 {
 799                                                                     var    rn =      _this.grid.ds.getCount();
 800                                                                     var tid = 1 * _this.form.findField('invhist_transfer_id').getValue();
 801                                                                     var addRow = function(r) {
 802
 803                                                                         if (r.itemsite_qty * 1 < 1) {
 804
 805                                                                             return;
 806                                                                             }
 807                                                                       var nr = _this.grid.ds.reader.newRow({
 808                                                                             invhist_transfer_item_line : rn + 1,
 809                                                                             item_id : r.itemsite_item_id,
 810                                                                             invhist_transfer_item_itemsite_id :         r.itemsite_id,
 811                                                                             item_number : r.itemsite_item_id_item_number,
 812                                                                             item_descrip1 : r.itemsite_item_id_item_descrip1,
 813                                                                             invhist_transfer_item_qty : r.itemsite_qty,
 814                                                                             item_availqty : 0,
 815                                                                             invhist_transfer_item_transfer_id : tid
 816                                                                        });
 817                                                                          _this.grid.ds.insert(rn++, nr);
 818
 819                                                                     };
 820
 821                                                                     var loc  = _this.form.findField('invhist_transfer_from').getValue()*1;
 822                                                                     var dt  = _this.form.findField('invhist_transfer_transdate').getValue().format('Y-m-d');
 823
 824                                                                     _this.grid.stopEditing();
 825
 826                                                                     new Pman.Request({
 827                                                                         url :  baseURL + '/Roo/itemsite',
 828                                                                         mask : 'Fetching stock',
 829                                                                         method : 'GET',
 830                                                                         params : {
 831                                                                             limit : 2000, // alot!
 832                                                                             _with_stock_and_value : 1,
 833                                                                             _viewtype : 1,
 834                                                                             location_id : loc,
 835                                                                             _as_of : dt,
 836                                                                             'sort' : 'itemsite_item_id_item_number',
 837                                                                             'dir'  : 'ASC'
 838                                                                         },
 839                                                                         success : function(r) {
 840                                                                             Roo.log(r);
 841                                                                             Roo.each(r.data, addRow);
 842
 843
 844                                                                         }
 845
 846                                                                     });
 847
 848
 849
 850
 851
 852
 853
 854                                                                 },
 855                                                                 render : function (_self)
 856                                                                 {
 857                                                                     _this.addItemBtn = _self;
 858                                                                 }
 859                                                             },
 860                                                             cls : 'x-btn-text-icon',
 861                                                             text : "Transfer all from Location",
 862                                                             icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
 863                                                         },
 864                                                         {
 865                                                             xtype: 'Item',
 866                                                             xns: Roo.menu,
 867                                                             listeners : {
 868                                                                 click : function()
 869                                                                 {
 870                                                                  var    rn =      _this.grid.ds.getCount();
 871                                                                         var tid = 1 * _this.form.findField('invhist_transfer_id').getValue();
 872
 873
 874                                                                         var addRow = function(r) {
 875
 876                                                                             if (r.itemsite_qty * 1 > -1) {
 877
 878                                                                                 return;
 879                                                                             }
 880                                                                           var nr = _this.grid.ds.reader.newRow({
 881                                                                                 invhist_transfer_item_line : rn + 1,
 882                                                                                 item_id : r.itemsite_item_id,
 883                                                                                 invhist_transfer_item_itemsite_id :         r.itemsite_id,
 884                                                                                 item_number : r.itemsite_item_id_item_number,
 885                                                                                 item_descrip1 : r.itemsite_item_id_item_descrip1,
 886                                                                                 invhist_transfer_item_qty : Math.abs(r.itemsite_qty),
 887                                                                                 item_availqty : 0,
 888                                                                                 invhist_transfer_item_transfer_id : tid
 889                                                                            });
 890                                                                              _this.grid.ds.insert(rn++, nr);
 891
 892                                                                         };
 893
 894                                                                         var loc  = _this.form.findField('invhist_transfer_to').getValue()*1;
 895                                                                         var dt  = _this.form.findField('invhist_transfer_transdate').getValue().format('Y-m-d');
 896
 897                                                                         _this.grid.stopEditing();
 898
 899                                                                         new Pman.Request({
 900                                                                             url :  baseURL + '/Roo/itemsite',
 901                                                                             mask : 'Fetching stock',
 902                                                                             method : 'GET',
 903                                                                             params : {
 904                                                                                 limit : 2000, // alot!
 905                                                                                 _with_stock_and_value : 1,
 906                                                                                 _viewtype : -1,
 907                                                                                 location_id : loc,
 908                                                                                 _as_of : dt,
 909                                                                                 'sort' : 'itemsite_item_id_item_number',
 910                                                                                 'dir'  : 'ASC'
 911                                                                             },
 912                                                                             success : function(r) {
 913                                                                                 Roo.log(r);
 914                                                                                 Roo.each(r.data, addRow);
 915
 916
 917                                                                             }
 918
 919                                                                         });
 920
 921
 922
 923
 924
 925
 926
 927                                                                 },
 928                                                                 render : function (_self)
 929                                                                 {
 930                                                                     _this.addItemBtn = _self;
 931                                                                 }
 932                                                             },
 933                                                             cls : 'x-btn-text-icon',
 934                                                             text : "Fill negative at Target",
 935                                                             icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
 936                                                         }
 937                                                     ]
 938                                                 }
 939                                             },
 940                                             {
 941                                                 xtype: 'Fill',
 942                                                 xns: Roo.Toolbar
 943                                             },
 944                                             {
 945                                                 xtype: 'Button',
 946                                                 xns: Roo.Toolbar,
 947                                                 listeners : {
 948                                                     click : function()
 949                                                     {
 950                                                          _this.grid.stopEditing();
 951
 952                                                          if (_this.data.invhist_transfer_posted) {
 953                                                             Roo.MessageBox.alert("Error", "Transfer has been posted, void it first");
 954                                                             return;
 955                                                         }
 956
 957                                                         var rc= _this.grid.selModel.getSelectedCell();
 958                                                          if (!rc) {
 959                                                             Roo.MessageBox.alert("Error", "Select a item to delete");
 960                                                             return;
 961                                                          }
 962
 963                                                          var rec = _this.grid.ds.getAt(rc[0]);
 964                                                          _this.grid.ds.remove(rec);
 965
 966
 967                                                         rec = _this.grid.ds.getAt(rc[0]);
 968                                                         if (rec) {
 969                                                             _this.grid.selModel.select(rc[0], 2);
 970                                                             return;
 971                                                         }
 972                                                         var ln = rc[0]-1;
 973                                                         if (ln < 0) {
 974                                                           return;
 975                                                         } // nothing left to select..
 976                                                         _this.grid.selModel.select(rc[0]-1, 2);
 977
 978
 979
 980
 981                                                     }
 982                                                 },
 983                                                 cls : 'x-btn-text-icon',
 984                                                 text : "Delete",
 985                                                 icon : rootURL + '/Pman/templates/images/trash.gif'
 986                                             }
 987                                         ]
 988                                     },
 989                                     colModel : [
 990                                         {
 991                                             xtype: 'ColumnModel',
 992                                             xns: Roo.grid,
 993                                             dataIndex : 'invhist_transfer_item_line',
 994                                             header : 'Line',
 995                                             width : 75,
 996                                             renderer : function(v) { return String.format('{0}', v); }
 997                                         },
 998                                         {
 999                                             xtype: 'ColumnModel',
1000                                             xns: Roo.grid,
1001                                             dataIndex : 'item_id',
1002                                             header : 'Item Code',
1003                                             width : 75,
1004                                             renderer : function(v,x,r) {
1005                                                 return String.format('{0}', r.data.item_number);
1006                                              },
1007                                             editor : {
1008                                                 xtype: 'GridEditor',
1009                                                 xns: Roo.grid,
1010                                                 field : {
1011                                                     xtype: 'ComboBox',
1012                                                     xns: Roo.form,
1013                                                     listeners : {
1014                                                         beforeselect : function (combo, record, index)
1015                                                         {
1016                                                           // set _this.data values ..
1017                                                           var ar = _this.grid.activeEditor.record;
1018                                                           //Roo.log('beforeselect');
1019                                                           (function() {
1020                                                              //  Roo.log('beforeselect-cb');
1021                                                               ar.set('item_descrip1', record.data.itemsite_item_id_item_descrip1);
1022                                                              // ar.set('coitem_price', record.data.item_listprice);
1023                                                              // ar.set('coitem_custprice', record.data.item_price);
1024                                                                ar.set('invhist_transfer_item_itemsite_id', record.data.itemsite_id);
1025                                                               ar.set('item_number', record.data.itemsite_item_id_item_number);
1026                                                               ar.set('avail_at_location', record.data.avail_at_location);
1027                                                               ar.commit();
1028                                                           }).defer(100);
1029
1030                                                         }
1031                                                     },
1032                                                     allowBlank : false,
1033                                                     displayField : 'itemsite_item_id_item_number',
1034                                                     editable : true,
1035                                                     emptyText : "Select item",
1036                                                     forceSelection : true,
1037                                                     hiddenName : 'itemsite_item_id_item_number',
1038                                                     listWidth : 400,
1039                                                     loadingText : "Searching...",
1040                                                     minChars : 2,
1041                                                     name : 'item_number',
1042                                                     pageSize : 20,
1043                                                     qtip : "Select item",
1044                                                     queryParam : 'query[number]',
1045                                                     selectOnFocus : true,
1046                                                     tpl : '<div class="x-grid-cell-text x-btn button"><b>{itemsite_item_id_item_number}</b>  {itemsite_item_id_item_descrip1} ({avail_at_location})</div>',
1047                                                     triggerAction : 'all',
1048                                                     valueField : 'item_number',
1049                                                     store : {
1050                                                         xtype: 'Store',
1051                                                         xns: Roo.data,
1052                                                         listeners : {
1053                                                             beforeload : function (_self, o){
1054                                                                 o.params = o.params || {};
1055
1056                                                                 o.params['query[at_location]'] = _this.form.findField('invhist_transfer_from').getValue();
1057
1058                                                             }
1059                                                         },
1060                                                         remoteSort : true,
1061                                                         sortInfo : { direction : 'ASC', field: 'itemsite_item_id_item_number' },
1062                                                         proxy : {
1063                                                             xtype: 'HttpProxy',
1064                                                             xns: Roo.data,
1065                                                             method : 'GET',
1066                                                             url : baseURL + '/Roo/itemsite.php'
1067                                                         },
1068                                                         reader : {
1069                                                             xtype: 'JsonReader',
1070                                                             xns: Roo.data,
1071                                                             id : 'shipto_id',
1072                                                             root : 'data',
1073                                                             totalProperty : 'total',
1074                                                             fields : [{"name":"item_id","type":"int"},"item_number"]
1075                                                         }
1076                                                     }
1077                                                 }
1078                                             }
1079                                         },
1080                                         {
1081                                             xtype: 'ColumnModel',
1082                                             xns: Roo.grid,
1083                                             dataIndex : 'item_descrip1',
1084                                             header : 'Description',
1085                                             width : 75,
1086                                             renderer : function(v,x,r) { return String.format('{0}', v); }
1087                                         },
1088                                         {
1089                                             xtype: 'ColumnModel',
1090                                             xns: Roo.grid,
1091                                             align : 'right',
1092                                             dataIndex : 'avail_at_location',
1093                                             header : 'Cur. Avail',
1094                                             width : 75,
1095                                             renderer : function(v,x,r) { return String.format('{0}', v); }
1096                                         },
1097                                         {
1098                                             xtype: 'ColumnModel',
1099                                             xns: Roo.grid,
1100                                             align : 'right',
1101                                             dataIndex : 'invhist_transfer_item_qty',
1102                                             header : 'Qty',
1103                                             width : '50.00',
1104                                             renderer : function(v,x,r) {
1105                                                 var vv = parseInt(v);
1106                                                 //var aq = parseInt(r.data.avail_qty);
1107                                                 //aq = isNaN(aq) ? 0 : aq;
1108
1109
1110
1111
1112                                                 return String.format('{0}', vv.toFixed(0));
1113
1114                                             },
1115                                             editor : {
1116                                                 xtype: 'GridEditor',
1117                                                 xns: Roo.grid,
1118                                                 field : {
1119                                                     xtype: 'NumberField',
1120                                                     xns: Roo.form,
1121                                                     allowDecimals : false,
1122                                                     decimalPrecision : 0,
1123                                                     minValue : 1,
1124                                                     style : 'text-align:right'
1125                                                 }
1126                                             }
1127                                         },
1128                                         {
1129                                             xtype: 'ColumnModel',
1130                                             xns: Roo.grid,
1131                                             align : 'right',
1132                                             dataIndex : 'invhist_transfer_item_unit_price',
1133                                             header : 'Unit Price',
1134                                             hidden : true,
1135                                             width : 75,
1136                                             renderer : function(v,x,r)
1137                                             {
1138                                                 if(!v && v !== 0){
1139                                                     return '';
1140                                                 }
1141                                                 var color = '#666'; // orignal color
1142
1143                                                 if(r.data.invhist_transfer_item_unit_price_default != v){
1144                                                     color = 'red';
1145                                                 }
1146
1147                                                 return String.format('<span style="color:{0};">{1} {2}</span>', color, (r.data.invhist_transfer_item_curr_name) ? r.data.invhist_transfer_item_curr_name : '' , Roo.util.Format.number(v,2));
1148                                             },
1149                                             editor : {
1150                                                 xtype: 'GridEditor',
1151                                                 xns: Roo.grid,
1152                                                 field : {
1153                                                     xtype: 'NumberField',
1154                                                     xns: Roo.form,
1155                                                     allowBlank : false,
1156                                                     allowDecimals : true,
1157                                                     decimalPrecision : 2,
1158                                                     style : 'text-align:right'
1159                                                 }
1160                                             }
1161                                         },
1162                                         {
1163                                             xtype: 'ColumnModel',
1164                                             xns: Roo.grid,
1165                                             align : 'right',
1166                                             dataIndex : 'invhist_transfer_item_unit_price_default',
1167                                             header : 'Default Price',
1168                                             hidden : true,
1169                                             width : 75,
1170                                             renderer : function(v,x,r)
1171                                             {
1172                                                 if(!v && v !== 0){
1173                                                     return '';
1174                                                 }
1175                                                 return String.format('{0} {1}', (r.data.invhist_transfer_item_curr_name) ? r.data.invhist_transfer_item_curr_name : '' , Roo.util.Format.number(v,2));
1176                                             }
1177                                         }
1178                                     ]
1179                                 }
1180                             }
1181                         ],
1182                         north : {
1183                             xtype: 'LayoutRegion',
1184                             xns: Roo,
1185                             height : 260
1186                         },
1187                         center : {
1188                             xtype: 'LayoutRegion',
1189                             xns: Roo
1190                         }
1191                     }
1192                 },
1193                 {
1194                     xtype: 'GridPanel',
1195                     xns: Roo,
1196                     listeners : {
1197                         activate : function() {
1198                             _this.ipanel = this;
1199                             if (_this.igrid) {
1200                                 _this.igrid.footer.onClick('first');
1201                             }
1202                         }
1203                     },
1204                     background : false,
1205                     fitContainer : true,
1206                     fitToframe : true,
1207                     region : 'center',
1208                     tableName : 'Images',
1209                     title : "Reference Files",
1210                     grid : {
1211                         xtype: 'Grid',
1212                         xns: Roo.grid,
1213                         listeners : {
1214                             render : function() {
1215                                 _this.igrid = this;
1216                                 //_this.dialog = Pman.Dialog.FILL_IN
1217                                 //if (_this.panel.active) {
1218                                 //   this.footer.onClick('first');
1219                                 //}
1220                             },
1221                             rowdblclick : function (_self, rowIndex, e)
1222                             {
1223
1224                                var s =  _self.getDataSource().getAt(rowIndex);
1225                                new Pman.Download({
1226                                     url : baseURL + '/Images/' + s.data.id
1227
1228                                 });
1229
1230                             }
1231                         },
1232                         autoExpandColumn : 'id',
1233                         loadMask : true,
1234                         dataSource : {
1235                             xtype: 'Store',
1236                             xns: Roo.data,
1237                             listeners : {
1238                                 beforeload : function (_self, o)
1239                                 {
1240                                     //o.params.ontable = 'Companies';
1241
1242                                   //   o.params.imgtype = 'PressRelease';
1243
1244                                     o.params = o.params || {};
1245                                     o.params.onid = _this.form.findField('invhist_transfer_id').getValue();
1246                                     o.params.ontable = 'invhist_transfer';
1247                                     Roo.log(_this);
1248
1249                                 },
1250                                 load : function (_self, records, options)
1251                                 {
1252                                  _this.panel.el.unmask();
1253                                 }
1254                             },
1255                             remoteSort : true,
1256                             sortInfo : { field: 'created' , direction: 'DESC' },
1257                             reader : {
1258                                 xtype: 'JsonReader',
1259                                 xns: Roo.data,
1260                                 id : 'id',
1261                                 root : 'data',
1262                                 totalProperty : 'total',
1263                                 fields : [
1264                                     {
1265                                         'name': 'id',
1266                                         'type': 'int'
1267                                     },
1268                                     {
1269                                         'name': 'filename',
1270                                         'type': 'string'
1271                                     },
1272                                     {
1273                                         'name': 'ontable',
1274                                         'type': 'string'
1275                                     },
1276                                     {
1277                                         'name': 'onid',
1278                                         'type': 'int'
1279                                     },
1280                                     {
1281                                         'name': 'mimetype',
1282                                         'type': 'string'
1283                                     },
1284                                     {
1285                                         'name': 'width',
1286                                         'type': 'int'
1287                                     },
1288                                     {
1289                                         'name': 'height',
1290                                         'type': 'int'
1291                                     },
1292                                     {
1293                                         'name': 'filesize',
1294                                         'type': 'int'
1295                                     },
1296                                     {
1297                                         'name': 'displayorder',
1298                                         'type': 'int'
1299                                     },
1300                                     {
1301                                         'name': 'language',
1302                                         'type': 'string'
1303                                     },
1304                                     {
1305                                         'name': 'parent_image_id',
1306                                         'type': 'int'
1307                                     },
1308                                     {
1309                                         'name': 'created',
1310                                         'type': 'date',
1311                                         'dateFormat' : 'Y-m-d H:i:s'
1312                                     },
1313                                     {
1314                                         'name': 'imgtype',
1315                                         'type': 'string'
1316                                     },
1317                                     {
1318                                         'name': 'linkurl',
1319                                         'type': 'string'
1320                                     },
1321                                     {
1322                                         'name': 'descript',
1323                                         'type': 'string'
1324                                     },
1325                                     {
1326                                         'name': 'title',
1327                                         'type': 'string'
1328                                     }
1329                                 ]
1330                             },
1331                             proxy : {
1332                                 xtype: 'HttpProxy',
1333                                 xns: Roo.data,
1334                                 method : 'GET',
1335                                 url : baseURL + '/Roo/Images.php'
1336                             }
1337                         },
1338                         footer : {
1339                             xtype: 'PagingToolbar',
1340                             xns: Roo,
1341                             pageSize : 25,
1342                             displayInfo : true,
1343                             displayMsg : "Displaying Images  {0} - {1} of {2}",
1344                             emptyMsg : "No Images found"
1345                         },
1346                         toolbar : {
1347                             xtype: 'Toolbar',
1348                             xns: Roo,
1349                             items : [
1350                                 {
1351                                     xtype: 'Button',
1352                                     xns: Roo.Toolbar,
1353                                     listeners : {
1354                                         click : function()
1355                                         {
1356
1357                                             //var sel = Pman.Tab.PressReleaseCompanies  ? Pman.Tab.PressReleaseCompanies.grid.getSelectionModel().getSelected() : false
1358
1359                                             Pman.Dialog.Image.show({
1360                                                 id : 0,
1361                                                 ontable: 'invhist_transfer',
1362                                                 onid: _this.form.findField('invhist_transfer_id').getValue(),
1363                                                 imgtype : ''
1364                                             }, function(data){
1365                                                 if (!data) { return; }
1366                                                 _this.igrid.footer.onClick('first');
1367                                             });
1368
1369                                         }
1370                                     },
1371                                     cls : 'x-btn-text-icon',
1372                                     text : "Add",
1373                                     icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
1374                                 },
1375                                 {
1376                                     xtype: 'Button',
1377                                     xns: Roo.Toolbar,
1378                                     listeners : {
1379                                         click : function()
1380                                                 {
1381                                                 Pman.genericDelete(_this, 'Images');
1382                                                 }
1383                                     },
1384                                     cls : 'x-btn-text-icon',
1385                                     text : "Delete",
1386                                     icon : rootURL + '/Pman/templates/images/trash.gif'
1387                                 }
1388                             ]
1389                         },
1390                         colModel : [
1391                             {
1392                                 xtype: 'ColumnModel',
1393                                 xns: Roo.grid,
1394                                 dataIndex : 'created',
1395                                 header : 'Created',
1396                                 sortable : true,
1397                                 width : 200,
1398                                 renderer : function(v,x,r) {
1399                                        return String.format('{0}<br/><i>{1}</i><br/>{2}<br/><i>{3}x{4}</i>',
1400                                             v.format('d/M/Y'), r.data.mimetype, r.data.filename,
1401                                     r.data.width, r.data.height
1402                                     );
1403                                 }
1404                             },
1405                             {
1406                                 xtype: 'ColumnModel',
1407                                 xns: Roo.grid,
1408                                 dataIndex : 'id',
1409                                 header : 'Image',
1410                                 width : 100,
1411                                 renderer : function(v,x,r) { return String.format('<img src="{0}/Images/Thumb/100/{1}/{2}" height="100">', baseURL, v, r.data.filename); }
1412                             }
1413                         ]
1414                     }
1415                 },
1416                 {
1417                     xtype: 'GridPanel',
1418                     xns: Roo,
1419                     listeners : {
1420                         activate : function() {
1421                             _this.hpanel = this;
1422                             if (_this.hgrid) {
1423                                 _this.hgrid.footer.onClick('first');
1424                             }
1425                         }
1426                     },
1427                     background : true,
1428                     fitContainer : true,
1429                     fitToframe : true,
1430                     region : 'center',
1431                     tableName : 'events',
1432                     title : "History",
1433                     grid : {
1434                         xtype: 'Grid',
1435                         xns: Roo.grid,
1436                         listeners : {
1437                             render : function()
1438                             {
1439                                 _this.hgrid = this;
1440                                 if (_this.hpanel.active) {
1441                                    this.footer.onClick('first');
1442                                 }
1443                             }
1444                         },
1445                         autoExpandColumn : 'remarks',
1446                         loadMask : true,
1447                         dataSource : {
1448                             xtype: 'Store',
1449                             xns: Roo.data,
1450                             listeners : {
1451                                 beforeload : function (_self, options)
1452                                 {
1453                                     options.params = options.params || {};
1454
1455                                     options.params.on_table = 'invhist_transfer';
1456                                     options.params.on_id = _this.form.findField('invhist_transfer_id').getValue();
1457                                 }
1458                             },
1459                             remoteSort : true,
1460                             sortInfo : { field : 'event_when', direction: 'DESC' },
1461                             proxy : {
1462                                 xtype: 'HttpProxy',
1463                                 xns: Roo.data,
1464                                 method : 'GET',
1465                                 url : baseURL + '/Roo/events.php'
1466                             },
1467                             reader : {
1468                                 xtype: 'JsonReader',
1469                                 xns: Roo.data,
1470                                 id : 'id',
1471                                 root : 'data',
1472                                 totalProperty : 'total',
1473                                 fields : [
1474                                     {
1475                                         'name': 'event_when',
1476                                         'type': 'date'
1477                                     },
1478                                     {
1479                                         'name': 'action',
1480                                         'type': 'string'
1481                                     },
1482                                     {
1483                                         'name': 'ipaddr',
1484                                         'type': 'string'
1485                                     },
1486                                     {
1487                                         'name': 'person_id_name',
1488                                         'type': 'string'
1489                                     },
1490                                     {
1491                                         'name': 'remarks',
1492                                         'type': 'string'
1493                                     }
1494                                 ]
1495                             }
1496                         },
1497                         footer : {
1498                             xtype: 'PagingToolbar',
1499                             xns: Roo,
1500                             displayInfo : true,
1501                             displayMsg : "Displaying events{0} - {1} of {2}",
1502                             emptyMsg : "No Events found",
1503                             pageSize : 25
1504                         },
1505                         colModel : [
1506                             {
1507                                 xtype: 'ColumnModel',
1508                                 xns: Roo.grid,
1509                                 dataIndex : 'event_when',
1510                                 header : 'Changed',
1511                                 width : 120,
1512                                 renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y H:i:s') : ''); }
1513                             },
1514                             {
1515                                 xtype: 'ColumnModel',
1516                                 xns: Roo.grid,
1517                                 dataIndex : 'action',
1518                                 header : 'Action',
1519                                 width : 200,
1520                                 renderer : function(v,x,r) { return String.format('{0} - {1}', v, r.data.on_table); }
1521                             },
1522                             {
1523                                 xtype: 'ColumnModel',
1524                                 xns: Roo.grid,
1525                                 dataIndex : 'ipaddr',
1526                                 header : 'IP Address',
1527                                 width : 200,
1528                                 renderer : function(v) { return String.format('{0}', v); }
1529                             },
1530                             {
1531                                 xtype: 'ColumnModel',
1532                                 xns: Roo.grid,
1533                                 dataIndex : 'person_id_name',
1534                                 header : 'Who',
1535                                 width : 75,
1536                                 renderer : function(v) { return String.format('{0}', v); }
1537                             },
1538                             {
1539                                 xtype: 'ColumnModel',
1540                                 xns: Roo.grid,
1541                                 dataIndex : 'remarks',
1542                                 header : 'Notes',
1543                                 width : 200,
1544                                 renderer : function(v) { return String.format('{0}', v); }
1545                             }
1546                         ]
1547                     }
1548                 },
1549                 {
1550                     xtype: 'GridPanel',
1551                     xns: Roo,
1552                     listeners : {
1553                         activate : function() {
1554                             _this.tpanel = this;
1555                             if (_this.tgrid) {
1556                                 _this.tgrid.footer.onClick('first');
1557                             }
1558                         }
1559                     },
1560                     background : true,
1561                     fitContainer : true,
1562                     fitToframe : true,
1563                     region : 'center',
1564                     tableName : 'invhist_transfer_item',
1565                     title : "Transfered",
1566                     grid : {
1567                         xtype: 'Grid',
1568                         xns: Roo.grid,
1569                         listeners : {
1570                             render : function()
1571                             {
1572                                 _this.tgrid = this;
1573                                 if (_this.tpanel.active) {
1574                                    this.footer.onClick('first');
1575                                 }
1576                             }
1577                         },
1578                         autoExpandColumn : 'remarks',
1579                         loadMask : true,
1580                         dataSource : {
1581                             xtype: 'Store',
1582                             xns: Roo.data,
1583                             listeners : {
1584                                 beforeload : function (_self, options)
1585                                 {
1586                                     options.params = options.params || {};
1587
1588                                     if(!_this.data.invhist_transfer_posted){
1589                                         return false;
1590                                     }
1591
1592                                     var id = _this.form.findField('invhist_transfer_id').getValue();
1593
1594                                     options.params.invhist_transfer_item_invhist_transfer_id = id;
1595
1596
1597                                 }
1598                             },
1599                             remoteSort : true,
1600                             sortInfo : { field : 'invhist_transfer_item_line', direction: 'ASC' },
1601                             proxy : {
1602                                 xtype: 'HttpProxy',
1603                                 xns: Roo.data,
1604                                 method : 'GET',
1605                                 url : baseURL + '/Roo/invhist_transfer_item.php'
1606                             },
1607                             reader : {
1608                                 xtype: 'JsonReader',
1609                                 xns: Roo.data,
1610                                 id : 'invhist_transfer_item_id',
1611                                 root : 'data',
1612                                 totalProperty : 'total',
1613                                 fields : [
1614                                     {
1615                                         'name': 'invhist_transfer_item_id',
1616                                         'type': 'int'
1617                                     },
1618                                     {
1619                                         'name': 'invhist_transfer_item_qty',
1620                                         'type': 'int'
1621                                     },
1622                                     {
1623                                         'name': 'invhist_transfer_item_line',
1624                                         'type': 'int'
1625                                     }
1626                                 ]
1627                             }
1628                         },
1629                         footer : {
1630                             xtype: 'PagingToolbar',
1631                             xns: Roo,
1632                             displayInfo : true,
1633                             displayMsg : "Displaying Transfer Items{0} - {1} of {2}",
1634                             emptyMsg : "No Events found",
1635                             pageSize : 25
1636                         },
1637                         colModel : [
1638                             {
1639                                 xtype: 'ColumnModel',
1640                                 xns: Roo.grid,
1641                                 dataIndex : 'event_when',
1642                                 header : 'Changed',
1643                                 width : 120,
1644                                 renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y H:i:s') : ''); }
1645                             },
1646                             {
1647                                 xtype: 'ColumnModel',
1648                                 xns: Roo.grid,
1649                                 dataIndex : 'action',
1650                                 header : 'Action',
1651                                 width : 200,
1652                                 renderer : function(v,x,r) { return String.format('{0} - {1}', v, r.data.on_table); }
1653                             },
1654                             {
1655                                 xtype: 'ColumnModel',
1656                                 xns: Roo.grid,
1657                                 dataIndex : 'ipaddr',
1658                                 header : 'IP Address',
1659                                 width : 200,
1660                                 renderer : function(v) { return String.format('{0}', v); }
1661                             },
1662                             {
1663                                 xtype: 'ColumnModel',
1664                                 xns: Roo.grid,
1665                                 dataIndex : 'person_id_name',
1666                                 header : 'Who',
1667                                 width : 75,
1668                                 renderer : function(v) { return String.format('{0}', v); }
1669                             },
1670                             {
1671                                 xtype: 'ColumnModel',
1672                                 xns: Roo.grid,
1673                                 dataIndex : 'remarks',
1674                                 header : 'Notes',
1675                                 width : 200,
1676                                 renderer : function(v) { return String.format('{0}', v); }
1677                             }
1678                         ]
1679                     }
1680                 }
1681             ],
1682             center : {
1683                 xtype: 'LayoutRegion',
1684                 xns: Roo,
1685                 tabPosition : 'top'
1686             },
1687             buttons : [
1688                 {
1689                     xtype: 'Button',
1690                     xns: Roo,
1691                     listeners : {
1692                         click : function (_self, e)
1693                         {
1694
1695                             var rn =      _this.grid.ds.getCount();
1696                             var tid = 1 * _this.form.findField('invhist_transfer_id').getValue();
1697                             var addRow = function(r) {
1698                                 if (r.itemsite_qty * 1 < 1) {
1699                                     return;
1700                                 }
1701
1702                                 var nr = _this.grid.ds.reader.newRow({
1703                                     invhist_transfer_item_line : rn + 1,
1704                                     item_id : r.itemsite_item_id,
1705                                     invhist_transfer_item_itemsite_id : r.itemsite_id,
1706                                     item_number : r.itemsite_item_id_item_number,
1707                                     item_descrip1 : r.itemsite_item_id_item_descrip1,
1708                                     invhist_transfer_item_qty : r.itemsite_qty,
1709                                     item_availqty : 0,
1710                                     avail_at_location : '',
1711                                     invhist_transfer_item_transfer_id : tid,
1712                                     invhist_transfer_item_unit_price : r.unit_price,
1713                                     invhist_transfer_item_unit_price_default : r.unit_price,
1714                                 });
1715                                 _this.grid.ds.insert(rn++, nr);
1716
1717                             };
1718
1719                             Pman.Dialog.Image.show(
1720                                {
1721                                     _url : baseURL + '/Xtuple/Import/Transfer'
1722
1723                                },
1724                                function (r) {
1725                                     Roo.log(r);
1726                                     Roo.each(r.items, addRow);
1727
1728                                     if (typeof(r.Date) !='undefined') {
1729                                         _this.form.findField('invhist_transfer_transdate').setValue( Date.parseDate((r.Date) ? r.Date : (new Date()).format('Y-m-d'), "Y-m-d"));
1730                                     }
1731                                     if (typeof(r.ArrivalDate) !='undefined') {
1732                                         _this.form.findField('invhist_transfer_arrivaldate').setValue(Date.parseDate((r.ArrivalDate) ? r.ArrivalDate : (new Date()).format('Y-m-d'), "Y-m-d"));
1733                                     }
1734                                     if(r.invhist_transfer_from){
1735                                         _this.fromLocation.setValue(r.invhist_transfer_from);
1736                                         _this.fromLocation.el.dom.value = r.invhist_transfer_from_location_name;
1737                                     }
1738                                     if(r.invhist_transfer_to){
1739                                         _this.toLocation.setValue(r.invhist_transfer_to);
1740                                         _this.toLocation.el.dom.value = r.invhist_transfer_to_location_name;
1741                                     }
1742
1743                                     if(r.isInter == 1){
1744                                         _this.toLocation._is_internalcompany = true;
1745                                     }
1746                                     _this.grid.setColumns();\r
1747                                }
1748                            );
1749                         },
1750                         render : function (_self)
1751                         {
1752                             _this.uploadBtn = _self;
1753                         }
1754                     },
1755                     text : "Upload (Excel)"
1756                 },
1757                 {
1758                     xtype: 'Button',
1759                     xns: Roo,
1760                     listeners : {
1761                         click : function (_self, e)
1762                         {
1763
1764                            new Pman.Download({
1765                                 url : baseURL + '/Xtuple/Roo/invhist_transfer',
1766                                 method : 'GET',
1767                                 params : {
1768                                     _roo_office : _this.form.findField('_roo_office').getValue(),
1769                                    _download : _this.data.invhist_transfer_id
1770
1771                                 }
1772                             });
1773
1774
1775
1776                         }
1777                     },
1778                     text : "Download (Excel)"
1779                 },
1780                 {
1781                     xtype: 'Button',
1782                     xns: Roo,
1783                     listeners : {
1784                         click : function (_self, e)
1785                         {
1786                             _this.grid.stopEditing();
1787                             if (_this.data.invhist_transfer_posted || _this.data.invhist_transfer_void) {
1788                                 _this.dialog.hide();
1789                                 return;
1790                             }
1791
1792                             if (_this.data.createFromRev) {
1793                                 Roo.MessageBox.alert("Warning", "A draft item reciept has been created - please void it if it is not needed");
1794                                 _this.dialog.hide();
1795                                 return;
1796                             }
1797
1798
1799
1800                             Roo.MessageBox.confirm("Confirm", "Are you sure want to cancel, all changes will be lost", function(r) {
1801
1802                                 if (r !='yes') {
1803                                     return;
1804                                 }
1805                                 _this.dialog.hide();
1806
1807                            })
1808
1809
1810
1811                         }
1812                     },
1813                     text : "Cancel"
1814                 },
1815                 {
1816                     xtype: 'Button',
1817                     xns: Roo,
1818                     listeners : {
1819                         click : function (_self, e)
1820                         {
1821                             // do some checks?
1822                             _this.grid.stopEditing();
1823                             var ar = [];
1824                             var err = false;
1825                             _this.grid.ds.each(function (r) {
1826                                 var missingqty = r.data.invhist_transfer_item_qty < 1;
1827                                 var missingsku = r.data.invhist_transfer_item_itemsite_id < 1;
1828                                 if (missingsku && missingqty) {
1829                                     return;
1830                                 }
1831
1832
1833                                 if (missingqty) {
1834                                     err = "Missing Quantity on line : " + r.data.invhist_transfer_item_line;
1835                                 }
1836                                 if (missingsku) {
1837                                    err = "Missing SKU on line : " + r.data.invhist_transfer_item_line;
1838                                 }
1839                                 ar.push({
1840                                     id: r.data.invhist_transfer_item_id,
1841                                     itemsite_id : r.data.invhist_transfer_item_itemsite_id,
1842                                     line:  r.data.invhist_transfer_item_line,
1843                                     qty: r.data.invhist_transfer_item_qty,
1844                                     price : r.data.invhist_transfer_item_unit_price
1845                                 });
1846
1847                              });
1848                              if (err) {
1849                                 Roo.MessageBox.alert("Error", err);
1850                                 return;
1851                              }
1852                              if (!ar.length) {
1853                                Roo.MessageBox.alert("Error", "Nothing listed to transfer");
1854                                 return;
1855                              }
1856                              _this.form.findField('transfer_items').setValue(  Roo.encode(ar));
1857
1858                             var arrivaldate = _this.form.findField('invhist_transfer_arrivaldate').getValue();
1859                             var transferprice = _this.form.findField('invhist_transfer_price').getValue();
1860
1861                             if(_this.toLocation._is_internalcompany && !arrivaldate){
1862                                 Roo.MessageBox.alert("Error", "Arrival date must be filled in");
1863                                 return;
1864                             }
1865                             if(_this.toLocation._is_internalcompany && !transferprice.length){
1866                                 Roo.MessageBox.alert("Error", "For inter company transfer a price must be set");
1867                                 return;
1868                             }
1869                             if(!arrivaldate){
1870                                 _this.form.findField('invhist_transfer_arrivaldate').setValue(_this.form.findField('invhist_transfer_transdate').getValue());
1871                             }
1872                             _this.form.doAction("submit");
1873
1874
1875
1876
1877                         },
1878                         render : function (_self)
1879                         {
1880                             _this.saveBtn = _self;
1881                         }
1882                     },
1883                     text : "Save"
1884                 }
1885             ]
1886         });
1887     }
1888 };