brecht on Add colmodel option: Addable

Thu, 17 Nov 2011 14:20:39 +0200

Didn't like the implementation.

This is better:

recreateForm: true,
beforeInitData: function (formid) {                                      // Add fields which are addable but not editable. jQgrid doesn't know a property 'Addable'.
      colModelIterator(function(col) {
          if (col.addable) {
       grid.setColProp(col.name, { editable: true });
          }
      });
},
afterComplete: function (response, postdata, formid) {
// Remove editable option.
   colModelIterator(function (col) {
       if (col.addable) {
          grid.setColProp(col.name, { editable: false });
        }
    });
}

function colModelIterator(callback) {
var colModel = grid.jqGrid('getGridParam', 'colModel');
for (var index in colModel) { callback(colModel[index]); }
}

brecht on Add colmodel option: Addable

Tue, 15 Nov 2011 15:42:50 +0200

I'de like to have an option 'Addable' or 'Insertable' on the colModel.
Why? Imagine this scenario:

I want a grid on a table with all crud operations. My table can have multiple columns which I don't want to be edited, like eg: primary key(s), incremental id, .. . However, I want some of those uneditable columns to be insertable in the add form.

I tackled this by following workaround in the navgrid add dialog properties:

recreateForm: true, beforeShowForm: function (formid) { // Add fields which are addable but not editable. jQgrid doesn't know a property 'Addable'.
var extraAddable = jQuery("#GenericTableManager").jqGrid('getGridParam', 'colModel');

   for (var i = extraAddable.length -1; i > 0 ; i--) {
       if (extraAddable[i].addable) {
           $('<tr id="tr_' + extraAddable[i].name + '" class="FormData">' +
               '<td class="CaptionTD">' + extraAddable[i].name + '</td>' +
               '<td class="DataTD">' +
                   '<input id="' + extraAddable[i].name + '" class="FormElement ui-widget-content ui-corner-all" type="text" name="'
                       + extraAddable[i].name + '" role="textbox">' +
               '</td>' +
              '</tr>')
               .insertAfter($('.tinfo'));
       }
   }
}

Works just fine, but would be nice if this was a default option.

Sorry about the edits: pasting code is one hardcore business.

jQuery Grid Plugin - jqGrid - Topic: Add colmodel option: Addable

brecht on Add colmodel option: Addable

brecht on Add colmodel option: Addable