Fix #7123 - getting abra ready to test
[Pman.Xtuple] / Pman.Tab.XtupleMetric.js
index e5c2ca9..ac138f6 100644 (file)
@@ -6,7 +6,7 @@ Pman.Tab.XtupleMetric = new Roo.XComponent({
     part     :  ["Xtuple","Metric"],
     order    : '900-Pman.Tab.XtupleMetric',
     region   : 'center',
-    parent   : 'Pman.Admin',
+    parent   : 'Pman.Tab.Admin',
     name     : "unnamed module",
     disabled : false, 
     permname : '', 
@@ -42,23 +42,13 @@ Pman.Tab.XtupleMetric = new Roo.XComponent({
                            this.footer.onClick('first');
                         }
                     },
-                    beforeedit : function (e)
+                    afteredit : function (e)
                     {
-                        var r = e.record.data.poitem_qty_received * 1;
-                        
-                        if(r > 0){
-                            Roo.MessageBox.alert("Error", "This item has been receipted");
-                            return false;
-                        }
-                        
-                        var status = _this.form.findField('pohead_status').getValue();
-                        
-                        if(status == 'C'){
-                            Roo.MessageBox.alert("Error", "This PO has been closed");
+                        if(e.originalValue == e.value || !e.value.length){
                             return false;
                         }
                         
-                        
+                        e.record.commit();
                     }
                 },
                 autoExpandColumn : 'metric_value',
@@ -70,41 +60,67 @@ Pman.Tab.XtupleMetric = new Roo.XComponent({
                     listeners : {
                         beforeload : function (_self, o){
                             o.params = o.params || {};
-                            var hid = _this.form.findField('pohead_id').getValue();
                             
-                            if(!hid.length){
-                                return false;
+                            var s = _this.searchBox.getValue();
+                            
+                            if(!s || !s.length){
+                                return;
                             }
                             
-                            o.params.poitem_pohead_id = hid;
-                            o.params._with_item = 1;
-                            o.params._roo_office = _this.data.office ? _this.data.office : baseURL.split('/').pop().substr(0,2);
-                        
+                            o.params['search[name]'] = s;
                         },
-                        load : function (_self, records, options)
+                        update : function (_self, record, operation)
                         {
-                            _this.grid.footer.updateSummary();
+                            if (operation != Roo.data.Record.COMMIT) {
+                                return;
+                            }
+                        
+                            if (!record.data.metric_name.length || !record.data.metric_value.length) {
+                                return;
+                            }
+                            
+                            new Pman.Request({
+                                url : baseURL + '/Roo/Metric',
+                                method : 'POST',
+                                params : record.data,
+                                success : function(res) {
+                                    _this.grid.footer.onClick('refresh');
+                                }
+                            });
+                            
                         }
                     },
                     remoteSort : true,
-                    sortInfo : { field : 'poitem_linenumber', direction: 'ASC' },
+                    sortInfo : { field : 'metric_name', direction: 'ASC' },
                     proxy : {
                         xtype: 'HttpProxy',
                         xns: Roo.data,
                         method : 'GET',
                         timeout : 90000,
-                        url : baseURL + '/Xtuple/Roo/Poitem.php'
+                        url : baseURL + '/Xtuple/Roo/Metric.php'
                     },
                     reader : {
                         xtype: 'JsonReader',
                         xns: Roo.data,
-                        id : 'poitem_id',
+                        id : 'metric_id',
                         root : 'data',
                         totalProperty : 'total',
                         fields : [
                             {
-                                'name': 'poitem_id',
+                                'name': 'metric_id',
                                 'type': 'int'
+                            },
+                            {
+                                'name': 'metric_name',
+                                'type': 'string'
+                            },
+                            {
+                                'name': 'metric_value',
+                                'type': 'string'
+                            },
+                            {
+                                'name': 'metric_module',
+                                'type': 'string'
                             }
                         ]
                     }
@@ -113,38 +129,66 @@ Pman.Tab.XtupleMetric = new Roo.XComponent({
                     xtype: 'Toolbar',
                     xns: Roo,
                     items : [
+                        {
+                            xtype: 'TextField',
+                            xns: Roo.form,
+                            listeners : {
+                                specialkey : function (_self, e)
+                                {
+                                  _this.grid.footer.onClick('first');
+                                },
+                                render : function (_self)
+                                {
+                                    _this.searchBox = _self;
+                                }
+                            }
+                        },
+                        {
+                            xtype: 'Button',
+                            xns: Roo.Toolbar,
+                            listeners : {
+                                click : function (_self, e)
+                                {
+                                    _this.grid.footer.onClick('first');
+                                }
+                            },
+                            cls : 'x-btn-icon',
+                            icon : rootURL + '/Pman/templates/images/search.gif'
+                        },
+                        {
+                            xtype: 'Button',
+                            xns: Roo.Toolbar,
+                            listeners : {
+                                click : function (_self, e)
+                                {
+                                    _this.searchBox.setValue('');
+                                    _this.grid.footer.onClick('first');\r
+                                }
+                            },
+                            cls : 'x-btn-icon',
+                            icon : rootURL + '/Pman/templates/images/edit-clear.gif'
+                        },
+                        {
+                            xtype: 'Fill',
+                            xns: Roo.Toolbar
+                        },
                         {
                             xtype: 'Button',
                             xns: Roo.Toolbar,
                             listeners : {
                                 click : function()
                                 {
-                                    var status = _this.form.findField('pohead_status').getValue();
-                                    
-                                    if(status == 'C'){
-                                        Roo.MessageBox.alert("Error", "This PO has been closed");
-                                        return;
-                                    }
-                                    
-                                    var ct  =    _this.grid.ds.getCount();
-                                    
-                                    var last = ct ? _this.grid.ds.getAt(ct-1).data.poitem_linenumber * 1 + 1 : 1;
-                                    
-                                    var dt = _this.form.findField('pohead_orderdate').getValue();
                                     
                                     var nr = _this.grid.ds.reader.newRow({
-                                        poitem_id : 0,
-                                        poitem_linenumber : last,
-                                        item_number : '',
-                                        item_descrip1 : '',
-                                        poitem_duedate : dt,
-                                        poitem_qty_ordered : 1,
-                                        poitem_unitprice : 0
+                                        metric_id : 0,
+                                        metric_name : '',
+                                        metric_value : '',
+                                        metric_module : ''
                                     });
                                     
                                     _this.grid.stopEditing();
-                                    _this.grid.ds.insert(_this.grid.ds.getCount(), nr); 
-                                    _this.grid.startEditing(_this.grid.ds.getCount()-1, 1);
+                                    _this.grid.ds.insert(0, nr); 
+                                    _this.grid.startEditing(0, 0);
                                 }
                             },
                             cls : 'x-btn-text-icon',
@@ -156,30 +200,33 @@ Pman.Tab.XtupleMetric = new Roo.XComponent({
                             xns: Roo.Toolbar,
                             listeners : {
                                 click : function ()
-                                {
-                                    var status = _this.form.findField('pohead_status').getValue();
-                                    
-                                    if(status == 'C'){
-                                        Roo.MessageBox.alert("Error", "This PO has been closed");
-                                        return;
-                                    }
-                                    
+                                {   
                                     var cs = _this.grid.getSelectionModel().getSelectedCell();
+                                    
                                     if (!cs) {
                                         Roo.MessageBox.alert("Error", "Select a cell");
                                         return;
                                     }
                                     _this.grid.stopEditing();
+                                 
                                     var r = _this.grid.ds.getAt(cs[0]);
                                     
-                                    if(r.data.poitem_qty_received * 1 > 0){
-                                        Roo.MessageBox.alert("Error", "This item has been receipted");
-                                        return;
-                                    }
-                                    
-                                    
-                                    _this.grid.ds.remove(r);
-                                   
+                                    Roo.MessageBox.confirm("Confirm", "Are you sure you want to delete this metric?", function (v){
+                                        if (v != 'yes') {
+                                            return;
+                                        }
+                                        
+                                        new Pman.Request({
+                                            url : baseURL + '/Roo/Metric',
+                                            method : 'POST',
+                                            params : {
+                                                _delete : r.data.id
+                                            },
+                                            success : function(res) {
+                                                _this.grid.footer.onClick('refresh');
+                                            }
+                                        });
+                                    });
                                 }
                             },
                             cls : 'x-btn-text-icon',
@@ -192,197 +239,58 @@ Pman.Tab.XtupleMetric = new Roo.XComponent({
                     xtype: 'PagingToolbar',
                     xns: Roo,
                     displayInfo : true,
-                    emptyMsg : "No Item found",
-                    pageSize : 100,
-                    updateSummary : function() {
-                    \r
-                        var f = this;\r
-                        new Pman.Request({\r
-                            url : baseURL + '/Xtuple/Roo/Poitem',\r
-                            method : 'GET',\r
-                            params : {
-                                _roo_office : _this.data.office ? _this.data.office : baseURL.split('/').pop().substr(0,2),\r
-                                _totals : 1,\r
-                                poitem_pohead_id : _this.form.findField('pohead_id').getValue()\r
-                            },\r
-                            success : function(d) {
-                                Roo.log(d);\r
-                                f.displayEl.update(String.format(\r
-                                    "{0} items | Total : {1} {2}",\r
-                                    d.data[0].count_item,\r
-                                    _this.form.findField('pohead_curr_id').el.dom.value,\r
-                                    d.data[0].totals\r
-                                ));\r
-                                    \r
-                            }\r
-                        });\r
-                    
-                    }
+                    emptyMsg : "No Metric found",
+                    pageSize : 50
                 },
                 colModel : [
                     {
                         xtype: 'ColumnModel',
                         xns: Roo.grid,
-                        align : 'right',
-                        dataIndex : 'poitem_linenumber',
-                        header : 'Line#',
-                        width : 50,
-                        renderer : function(v) { return String.format('{0}', v); }
-                    },
-                    {
-                        xtype: 'ColumnModel',
-                        xns: Roo.grid,
-                        dataIndex : 'item_number',
-                        header : 'Item code',
-                        width : 100,
+                        dataIndex : 'metric_name',
+                        header : 'Name',
+                        width : 250,
                         renderer : function(v) { return String.format('{0}', v); },
                         editor : {
                             xtype: 'GridEditor',
                             xns: Roo.grid,
                             field : {
-                                xtype: 'ComboBox',
+                                xtype: 'TextField',
                                 xns: Roo.form,
-                                listeners : {
-                                    beforeselect : function (combo, record, index)
-                                    {
-                                      var ar = _this.grid.activeEditor.record;
-                                      
-                                      (function() { 
-                                          ar.set('item_descrip1', record.data.itemsite_item_id_item_descrip1);
-                                          ar.set('poitem_itemsite_id', record.data.itemsite_id);
-                                      }).defer(100);
-                                      
-                                    }
-                                },
-                                allowBlank : false,
-                                displayField : 'itemsite_item_id_item_number',
-                                editable : true,
-                                emptyText : "Select item",
-                                forceSelection : true,
-                                hiddenName : 'itemsite_item_id_item_number',
-                                listWidth : 400,
-                                loadingText : "Searching...",
-                                minChars : 2,
-                                name : 'item_number',
-                                pageSize : 20,
-                                qtip : "Select item",
-                                queryParam : 'query[number]',
-                                selectOnFocus : true,
-                                tpl : '<div class="x-grid-cell-text x-btn button"><b>{itemsite_item_id_item_number}</b> - {itemsite_item_id_item_descrip1} </div>',
-                                triggerAction : 'all',
-                                typeAhead : false,
-                                valueField : 'item_number',
-                                store : {
-                                    xtype: 'Store',
-                                    xns: Roo.data,
-                                    listeners : {
-                                        beforeload : function (_self, o){
-                                            o.params = o.params || {}; 
-                                            o.params.itemsite_posupply = 1;
-                                        }
-                                    },
-                                    remoteSort : true,
-                                    sortInfo : { direction : 'ASC', field: 'item_number' },
-                                    proxy : {
-                                        xtype: 'HttpProxy',
-                                        xns: Roo.data,
-                                        method : 'GET',
-                                        url : baseURL + '/Roo/itemsite.php'
-                                    },
-                                    reader : {
-                                        xtype: 'JsonReader',
-                                        xns: Roo.data,
-                                        id : 'itemsite_id',
-                                        root : 'data',
-                                        totalProperty : 'total',
-                                        fields : [{"name":"item_id","type":"int"},"item_number"]
-                                    }
-                                }
+                                allowBlank : false
                             }
                         }
                     },
                     {
                         xtype: 'ColumnModel',
                         xns: Roo.grid,
-                        dataIndex : 'item_descrip1',
-                        header : 'Item description',
+                        dataIndex : 'metric_value',
+                        header : 'Value',
                         width : 150,
-                        renderer : function(v) { return String.format('{0}', v); }
-                    },
-                    {
-                        xtype: 'ColumnModel',
-                        xns: Roo.grid,
-                        dataIndex : 'poitem_duedate',
-                        header : 'Due date',
-                        width : 100,
-                        renderer : function(v) { return String.format('{0}', v ? v.format('Y-m-d') : ''); }
-                    },
-                    {
-                        xtype: 'ColumnModel',
-                        xns: Roo.grid,
-                        align : 'right',
-                        dataIndex : 'poitem_qty_ordered',
-                        header : 'Ordered',
-                        width : 75,
                         renderer : function(v) { return String.format('{0}', v); },
                         editor : {
                             xtype: 'GridEditor',
                             xns: Roo.grid,
                             field : {
-                                xtype: 'NumberField',
+                                xtype: 'TextField',
                                 xns: Roo.form,
-                                allowDecimals : false,
-                                decimalPrecision : 0,
-                                minValue : 1,
-                                style : 'text-align:right'
+                                allowBlank : false
                             }
                         }
                     },
                     {
                         xtype: 'ColumnModel',
                         xns: Roo.grid,
-                        align : 'right',
-                        dataIndex : 'poitem_qty_received',
-                        header : 'Received',
-                        width : 75,
-                        renderer : function(v,x,r) { 
-                            return String.format(
-                                r.data.poitem_qty_ordered != (v-r.data.poitem_qty_returned) ? '<span style="color:red">{0}</span>':  '{0}',
-                                 v - r.data.poitem_qty_returned);
-                        }
-                    },
-                    {
-                        xtype: 'ColumnModel',
-                        xns: Roo.grid,
-                        align : 'right',
-                        dataIndex : 'poitem_qty_vouchered',
-                        header : 'Vouchered',
-                        width : 65,
-                        renderer : function(v,x,r) { 
-                            return String.format(
-                                r.data.poitem_qty_ordered != v ? '<span style="color:red">{0}</span>':  '{0}',
-                                 v);
-                        }
-                    },
-                    {
-                        xtype: 'ColumnModel',
-                        xns: Roo.grid,
-                        align : 'right',
-                        dataIndex : 'poitem_unitprice',
-                        header : 'Unit price',
+                        dataIndex : 'metric_module',
+                        header : 'Module',
                         width : 100,
-                        renderer : function(v) { return String.format('{0}', (v || v == 0) ? parseFloat(v).toFixed(3) : ''); },
+                        renderer : function(v) { return String.format('{0}', v); },
                         editor : {
                             xtype: 'GridEditor',
                             xns: Roo.grid,
                             field : {
-                                xtype: 'NumberField',
+                                xtype: 'TextField',
                                 xns: Roo.form,
-                                allowBlank : false,
-                                allowDecimals : false,
-                                decimalPrecision : 0,
-                                minValue : 1,
-                                style : 'text-align:right'
+                                allowBlank : false
                             }
                         }
                     }