Threaded View

  1. #1
    Sencha - Community Support Team Condor's Avatar
    Join Date
    Mar 2007
    Location
    The Netherlands
    Posts
    24,246
    Vote Rating
    82
    Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of Condor has much to be proud of

      0  

    Default EditableGrid - Shows editors for all cells

    EditableGrid - Shows editors for all cells


    EditorGridPanel only supports one editor for each column and the editor is only shown after single or double clicking the cell.
    EditorGridPanel is not designed to show editors on every cell, because this would make the browser extremely slow with large datasets.

    I created this plugin to show editors for all cells in a GridPanel (so not an EditorGridPanel!).

    As noted above: Do NOT use this plugin for large datasets!

    The plugin:
    Code:
    Ext.ns('Ext.ux.grid');
    Ext.ux.grid.EditableGrid = Ext.extend(Object, {
        init : function(grid){
            Ext.apply(grid.getView(), {
                editors: [],
                editorPadding: 2,
                renderUI : function(){
                    this.constructor.prototype.renderUI.call(this);
                    this.el.addClass('x-grid-editing');
                },
                updateAllColumnWidths : function(){
                    this.constructor.prototype.updateAllColumnWidths.call(this);
                    var editors = this.editors,
                        rows = editors.length,
                        cols = this.cm.getColumnCount(),
                        col, row, ed, w = [];
                    for(col = 0; col < cols; col++){
                        w[col] = this.cm.getColumnWidth(col) - this.editorPadding;
                    }
                    for(row = 0; row < rows; row++){
                        for(col = 0; col < cols; col++){
                            ed = editors[row][col];
                            if(ed){
                                ed.setWidth(w[col]);
                            }
                        }
                    }
                },
                updateColumnWidth : function(col, width){
                    this.constructor.prototype.updateColumnWidth.call(this, col, width);
                    var editors = this.editors,
                        rows = editors.length,
                        row, ed,
                        w = this.cm.getColumnWidth(col) - this.editorPadding;
                    for(row = 0; row < rows; row++){
                        ed = editors[row][col];
                        if(ed){
                            ed.setWidth(w);
                        }
                    }
                },
                afterRender : function(){
                    this.constructor.prototype.afterRender.call(this);
                    this.destroyAllEditors();
                    this.renderEditors(0, this.ds.getCount() - 1);
                },
                insertRows : function(dm, firstRow, lastRow, isUpdate){
                    this.constructor.prototype.insertRows.call(this, dm, firstRow, lastRow, isUpdate);
                    var last = dm.getCount() - 1;
                    if(!isUpdate && firstRow === 0 && lastRow >= last){
                        return;
                    }
                    this.renderEditors(firstRow, lastRow);
                },
                deleteRows : function(dm, firstRow, lastRow){
                    if(dm.getRowCount() >= 1){
                        this.destroyEditors(firstRow, lastRow);
                    }
                    this.constructor.prototype.deleteRows.call(this, dm, firstRow, lastRow);
                },
                refreshRow : function(record){
                    var ds = this.ds, index;
                    if(typeof record == 'number'){
                        index = record;
                        record = ds.getAt(index);
                        if(!record){
                            return;
                        }
                    }else{
                        index = ds.indexOf(record);
                        if(index < 0){
                            return;
                        }
                    }
                    this.destroyEditors(index, index);
                    this.constructor.prototype.refreshRow.call(this, record);
                    this.renderEditors(index, index);
                },
                refresh : function(headersToo){
                    this.destroyAllEditors();
                    this.constructor.prototype.refresh.call(this, headersToo);
                    this.renderEditors(0, this.ds.getCount() - 1);
                },
                destroy : function(){
                    this.destroyAllEditors();
                    this.constructor.prototype.destroy.call(this);
                },
                focusCell : function(row, col, hscroll){
                    this.syncFocusEl(this.ensureVisible(row, col, hscroll));
                    var ed = this.editors[row][col], focusEl = ed ? ed : this.focusEl;
                    if(Ext.isGecko){
                        focusEl.focus();
                    }else{
                        focusEl.focus.defer(1, this.focusEl);
                    }
                },
                renderEditors: function(startRow, endRow){
                    var args = [startRow, 0],
                        cols = this.cm.getColumnCount(),
                        col, row, ed, w = [], rec, r, di, cell;
                    for(col = 0; col < cols; col++){
                        w[col] = this.cm.getColumnWidth(col) - this.editorPadding;
                    }
                    for(row = startRow; row <= endRow; row++){
                        r = [];
                        rec = this.ds.getAt(row);
                        for(col = 0; col < cols; col++){
                            ed = this.cm.isCellEditable(col, row) ? this.cm.getCellEditor(col, row) : null;
                            if(ed){
                                cell = this.getCell(row, col).firstChild;
                                cell.parentNode.removeAttribute('tabindex');
                                cell.innerHTML = '';
                                di = this.cm.getDataIndex(col);
                                ed = ed.field.cloneConfig({
                                    value: rec.get(di),
                                    width: w[col],
                                    renderTo: cell,
                                    ctCls: 'x-small-editor x-grid-editor ux-editable-grid'
                                });
                                ed.on('blur', this.onEditorBlur, {
                                    store: this.ds,
                                    row: row,
                                    dataIndex: di
                                });
                            }
                            r.push(ed);
                        }
                        args.push(r);
                    }
                    this.editors.splice.apply(this.editors, args);
                },
                destroyEditors: function(startRow, endRow){
                    var removed = this.editors.splice(startRow, endRow - startRow + 1);
                    Ext.destroy(removed);
                },
                destroyAllEditors: function(){
                    Ext.destroy(this.editors);
                    this.editors = [];
                },
                onEditorBlur: function(field){
                    this.store.getAt(this.row).data[this.dataIndex] = field.getValue();
                }
            });
        }
    });
    Ext.preg('editable-grid', Ext.ux.grid.EditableGrid);
    which requires the following css rule:
    Code:
    .ux-editable-grid {
        padding: 0;
    }
    Usage example:
    Code:
    Ext.onReady(function(){
        Ext.QuickTips.init();
        new Ext.grid.GridPanel({
            title: 'EditableGrid plugin test',
            width: 250,
            height: 150,
            store: [[1, 'One'], [2, 'Two'], [3, 'Three'], [4, 'Four'], [5, 'Five']],
            viewConfig: {
                forceFit: true
            },
            columns: [{
                header: 'Value',
                dataIndex: 'field1',
                editor: {
                    xtype: 'numberfield',
                    minValue: 0,
                    maxValue: 100
                }
            },{
                header: 'Text',
                dataIndex: 'field2',
                editor: {
                    xtype: 'textfield',
                    allowBlank: false
                }
            }],
            plugins: [{
                ptype: 'editable-grid'
            }],
            renderTo: Ext.getBody()
        });
    });
    Attached Images